99: END IF;
100:
101: /* SELECT mtl_material_transactions_s.NEXTVAL
102: INTO x_trx_tmp_id 103: FROM DUAL; */ 104:
105: -- If content Item Id is not NULL then set ItemId = -1;
106: IF (p_cnt_lpn_id IS NOT NULL) THEN
107: v_item_id := -1;
Line 1404: SELECT mtl_material_transactions_s.NEXTVAL INTO x_new_txn_temp_id FROM DUAL;
1400: END IF;
1401: END IF;
1402:
1403: 1404: SELECT mtl_material_transactions_s.NEXTVAL INTO x_new_txn_temp_id FROM DUAL; 1405:
1406: INSERT INTO mtl_material_transactions_temp(
1407: transaction_header_id
1408: , transaction_temp_id