need to fix an error in the above code
hi,please help me to resolve this error
CREATE OR REPLACE PROCEDURE XXLOT_TRANSLATE(P_LPN_NUMBER IN VARCHAR2,P_POSTFIX IN VARCHAR2) IS
l_transaction_type_id NUMBER ;
l_transaction_action_id NUMBER;
l_transaction_source_type_id NUMBER ;
l_orgANIZATION_id NUMBER ;
l_txn_header_id NUMBER;
l_txn_if_id1 NUMBER;
l_txn_if_id2 NUMBER;
l_txn_if_id3 NUMBER;
l_parent_id NUMBER;
l_sysdate DATE;
l_item_id NUMBER ;
l_user_id NUMBER;
l_quantity NUMBER;
l_lpn_id NUMBER;
l_locater_id NUMBER;
l_lot_number VARCHAR2(20);
l_distribution_account_id NUMBER;
l_subinv_code VARCHAR2(10BYTE);
CREATE OR REPLACE PROCEDURE XXLOT_TRANSLATE(P_LPN_NUMBER IN VARCHAR2,P_POSTFIX IN VARCHAR2) IS
l_transaction_type_id NUMBER ;
l_transaction_action_id NUMBER;
l_transaction_source_type_id NUMBER ;
l_orgANIZATION_id NUMBER ;
l_txn_header_id NUMBER;
l_txn_if_id1 NUMBER;
l_txn_if_id2 NUMBER;
l_txn_if_id3 NUMBER;
l_parent_id NUMBER;
l_sysdate DATE;
l_item_id NUMBER ;
l_user_id NUMBER;
l_quantity NUMBER;
l_lpn_id NUMBER;
l_locater_id NUMBER;
l_lot_number VARCHAR2(20);
l_distribution_account_id NUMBER;
l_subinv_code VARCHAR2(10BYTE);
0