DBA Data[Home] [Help]

APPS.INV_TRX_UTIL_PUB dependencies on DUAL

Line 103: FROM DUAL; */

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