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 2292: NVL (transaction_temp_id, mtl_material_transactions_s.NEXTVAL)

2288:
2289: UPDATE mtl_material_transactions_temp
2290: SET last_update_date = SYSDATE
2291: , transaction_temp_id =
2292: NVL (transaction_temp_id, mtl_material_transactions_s.NEXTVAL)
2293: , last_updated_by = l_userid
2294: , last_update_login = l_loginid
2295: , program_application_id = l_applid
2296: , program_id = l_progid

Line 2651: , mtl_material_transactions_s.NEXTVAL

2647: UPDATE mtl_transactions_interface
2648: SET last_update_date = SYSDATE
2649: , transaction_interface_id =
2650: NVL (transaction_interface_id
2651: , mtl_material_transactions_s.NEXTVAL
2652: )
2653: , transaction_batch_id =
2654: NVL (transaction_batch_id
2655: , DECODE (transaction_source_type_id

Line 2686: , mtl_material_transactions_s.NEXTVAL

2682: UPDATE mtl_transactions_interface
2683: SET last_update_date = SYSDATE
2684: , transaction_interface_id =
2685: NVL (transaction_interface_id
2686: , mtl_material_transactions_s.NEXTVAL
2687: )
2688: , transaction_batch_id =
2689: NVL (transaction_batch_id
2690: , DECODE (transaction_source_type_id

Line 2712: mtl_material_transactions_s.nextval),

2708:
2709: UPDATE MTL_TRANSACTIONS_INTERFACE
2710: SET LAST_UPDATE_DATE = SYSDATE,
2711: TRANSACTION_INTERFACE_ID = NVL(TRANSACTION_INTERFACE_ID,
2712: mtl_material_transactions_s.nextval),
2713: LAST_UPDATED_BY = l_userid,
2714: LAST_UPDATE_LOGIN = l_loginid,
2715: PROGRAM_APPLICATION_ID = l_applid,
2716: PROGRAM_ID = l_progid,