DBA Data[Home] [Help]

APPS.QA_SOLUTION_DISPOSITION_PKG dependencies on MTL_SERIAL_NUMBERS_INTERFACE

Line 1021: -- and MTL_SERIAL_NUMBERS_INTERFACE

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.
1024: -- 4. Calls WRITE_BACK proc to write the result of the transaction processor
1025: -- against the Quality record.

Line 1331: INSERT INTO MTL_SERIAL_NUMBERS_INTERFACE (

1327: );
1328: END IF;
1329:
1330: IF l_serial_control_code IN (2,5) THEN
1331: INSERT INTO MTL_SERIAL_NUMBERS_INTERFACE (
1332: TRANSACTION_INTERFACE_ID,
1333: FM_SERIAL_NUMBER,
1334: LAST_UPDATE_DATE,
1335: LAST_UPDATED_BY,

Line 2409: INSERT INTO MTL_SERIAL_NUMBERS_INTERFACE (

2405:
2406: IF l_serial_control_code IN (2,5) THEN
2407:
2408:
2409: INSERT INTO MTL_SERIAL_NUMBERS_INTERFACE (
2410: TRANSACTION_INTERFACE_ID,
2411: FM_SERIAL_NUMBER,
2412: LAST_UPDATE_DATE,
2413: LAST_UPDATED_BY,