APPS.QA_SOLUTION_DISPOSITION_PKG dependencies on MTL_TRANSACTIONS_INTERFACE

Line 1019: -- 1. Inserts into the MTL_TRANSACTIONS_INTERFACE

1015: -- Notes
1016: --
1017: -- We are performing all the below activities here
1018: --
1019: -- 1. Inserts into the MTL_TRANSACTIONS_INTERFACE
1020: -- 2. If applicable, inserts into MTL_TRANSACTION_LOTS_INTERFACE
1021: -- and MTL_SERIAL_NUMBERS_INTERFACE
1022: -- 3. Invokes the MTL_ONLINE_TRANSACTION_PUB.PROCESS_ONLINE proc to do the
1023: -- transaction processing.

Line 1083: FROM mtl_transactions_interface

1079: WHERE transaction_set_id = set_id;
1080:
1081: CURSOR mti_cur (header_id NUMBER) IS
1082: SELECT transaction_interface_id
1083: FROM mtl_transactions_interface
1084: WHERE transaction_header_id = header_id;
1085:
1086: CURSOR disp IS
1087: SELECT disposition_id

Line 1241: INSERT INTO MTL_TRANSACTIONS_INTERFACE (

1237: FETCH item_cur INTO l_lot_control_code,l_serial_control_code;
1238: CLOSE item_cur;
1239:
1240: -- Insert into Interface table.
1241: INSERT INTO MTL_TRANSACTIONS_INTERFACE (
1242: TRANSACTION_HEADER_ID,
1243: TRANSACTION_INTERFACE_ID,
1244: SOURCE_CODE,
1245: SOURCE_HEADER_ID,

Line 1897: FROM mtl_transactions_interface

1893: WHERE transaction_set_id = set_id;
1894:
1895: CURSOR mti_cur (header_id NUMBER) IS
1896: SELECT transaction_interface_id
1897: FROM mtl_transactions_interface
1898: WHERE transaction_header_id = header_id;
1899:
1900: CURSOR reason_cur IS
1901: SELECT reason_id

Line 2123: FROM mtl_transactions_interface

2119: WHERE transaction_set_id = set_id;
2120:
2121: CURSOR mti_cur (header_id NUMBER) IS
2122: SELECT transaction_interface_id
2123: FROM mtl_transactions_interface
2124: WHERE transaction_header_id = header_id;
2125:
2126: CURSOR reason_cur IS
2127: SELECT reason_id

Line 2308: INSERT INTO MTL_TRANSACTIONS_INTERFACE (

2304: OPEN item_cur;
2305: FETCH item_cur INTO l_lot_control_code,l_serial_control_code;
2306: CLOSE item_cur;
2307:
2308: INSERT INTO MTL_TRANSACTIONS_INTERFACE (
2309: TRANSACTION_HEADER_ID,
2310: TRANSACTION_INTERFACE_ID,
2311: SOURCE_CODE,
2312: SOURCE_HEADER_ID,