53:
54: -- get the transaction_header_id
55: SELECT mtl_material_transactions_s.NEXTVAL
56: INTO x_trx_header_id
57: FROM DUAL;
58:
59: -- get the transaction_temp_id
60: SELECT mtl_material_transactions_s.NEXTVAL
61: INTO x_trx_temp_id
58:
59: -- get the transaction_temp_id
60: SELECT mtl_material_transactions_s.NEXTVAL
61: INTO x_trx_temp_id
62: FROM DUAL;
63:
64: INSERT INTO mtl_material_transactions_temp
65: (TRANSACTION_HEADER_ID
66: ,TRANSACTION_TEMP_ID