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;
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