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 1893: FROM mtl_transactions_interface

1889: WHERE transaction_set_id = set_id;
1890:
1891: CURSOR mti_cur (header_id NUMBER) IS
1892: SELECT transaction_interface_id
1893: FROM mtl_transactions_interface
1894: WHERE transaction_header_id = header_id;
1895:
1896: CURSOR reason_cur IS
1897: SELECT reason_id

Line 2119: FROM mtl_transactions_interface

2115: WHERE transaction_set_id = set_id;
2116:
2117: CURSOR mti_cur (header_id NUMBER) IS
2118: SELECT transaction_interface_id
2119: FROM mtl_transactions_interface
2120: WHERE transaction_header_id = header_id;
2121:
2122: CURSOR reason_cur IS
2123: SELECT reason_id

Line 2304: INSERT INTO MTL_TRANSACTIONS_INTERFACE (

2300: OPEN item_cur;
2301: FETCH item_cur INTO l_lot_control_code,l_serial_control_code;
2302: CLOSE item_cur;
2303:
2304: INSERT INTO MTL_TRANSACTIONS_INTERFACE (
2305: TRANSACTION_HEADER_ID,
2306: TRANSACTION_INTERFACE_ID,
2307: SOURCE_CODE,
2308: SOURCE_HEADER_ID,