APPS.INV_TXN_MANAGER_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 463: SELECT mtl_material_transactions_s.NEXTVAL

459: END IF;
460:
461: IF (p_current_index = l_count AND l_remaining_qty > 0)
462: THEN
463: SELECT mtl_material_transactions_s.NEXTVAL
464: INTO l_transaction_interface_id --J-dev
465: FROM DUAL;
466:
467: --shuld execute only once

Line 1018: SELECT mtl_material_transactions_s.NEXTVAL

1014: END LOOP;
1015:
1016: l_rem_var_index := l_rem_serial_tbl.FIRST;
1017:
1018: SELECT mtl_material_transactions_s.NEXTVAL
1019: INTO l_sequence
1020: FROM DUAL;
1021:
1022: IF (l_debug = 1)

Line 1838: SELECT mtl_material_transactions_s.NEXTVAL

1834: l_old_hdr_id NUMBER;
1835: BEGIN
1836: l_old_hdr_id := p_txn_hdr_id;
1837:
1838: SELECT mtl_material_transactions_s.NEXTVAL
1839: INTO l_new_hdr_id
1840: FROM DUAL;
1841:
1842: p_txn_hdr_id := l_new_hdr_id;

Line 2276: NVL (transaction_temp_id, mtl_material_transactions_s.NEXTVAL)

2272:
2273: UPDATE mtl_material_transactions_temp
2274: SET last_update_date = SYSDATE
2275: , transaction_temp_id =
2276: NVL (transaction_temp_id, mtl_material_transactions_s.NEXTVAL)
2277: , last_updated_by = l_userid
2278: , last_update_login = l_loginid
2279: , program_application_id = l_applid
2280: , program_id = l_progid

Line 2634: , mtl_material_transactions_s.NEXTVAL

2630: UPDATE mtl_transactions_interface
2631: SET last_update_date = SYSDATE
2632: , transaction_interface_id =
2633: NVL (transaction_interface_id
2634: , mtl_material_transactions_s.NEXTVAL
2635: )
2636: , transaction_batch_id =
2637: NVL (transaction_batch_id
2638: , DECODE (transaction_source_type_id

Line 2668: mtl_material_transactions_s.nextval),

2664:
2665: UPDATE MTL_TRANSACTIONS_INTERFACE
2666: SET LAST_UPDATE_DATE = SYSDATE,
2667: TRANSACTION_INTERFACE_ID = NVL(TRANSACTION_INTERFACE_ID,
2668: mtl_material_transactions_s.nextval),
2669: LAST_UPDATED_BY = l_userid,
2670: LAST_UPDATE_LOGIN = l_loginid,
2671: PROGRAM_APPLICATION_ID = l_applid,
2672: PROGRAM_ID = l_progid,