APPS.WIP_WICTPG dependencies on MTL_SERIAL_NUMBERS

Line 1326: x_purge_rec.table_name := 'MTL_SERIAL_NUMBERS';

1322: append_report(x_purge_rec, p_option);
1323: end if;
1324:
1325:
1326: x_purge_rec.table_name := 'MTL_SERIAL_NUMBERS';
1327:
1328: if (x_purge_rec.primary_item_id IS NULL) then
1329:
1330: SELECT COUNT(*)

Line 1335: FROM MTL_SERIAL_NUMBERS

1331: into x_records_returned
1332: FROM DUAL
1333: WHERE EXISTS
1334: (SELECT 1
1335: FROM MTL_SERIAL_NUMBERS
1336: WHERE ORIGINAL_WIP_ENTITY_ID = x_purge_rec.wip_entity_id
1337: AND INVENTORY_ITEM_ID IS NULL );
1338: else
1339:

Line 1345: FROM MTL_SERIAL_NUMBERS

1341: into x_records_returned
1342: FROM DUAL
1343: WHERE EXISTS
1344: (SELECT 1
1345: FROM MTL_SERIAL_NUMBERS
1346: WHERE ORIGINAL_WIP_ENTITY_ID = x_purge_rec.wip_entity_id
1347: AND INVENTORY_ITEM_ID = x_purge_rec.primary_item_id );
1348:
1349: end if;

Line 1449: from MTL_SERIAL_NUMBERS

1445: x_purge_rec.info_type := EXCEPTIONS;
1446:
1447: if (p_option = REPORT_ONLY) then
1448: select count(*) into x_num_rows
1449: from MTL_SERIAL_NUMBERS
1450: WHERE ORIGINAL_WIP_ENTITY_ID = x_purge_rec.wip_entity_id ;
1451: else
1452: update MTL_SERIAL_NUMBERS
1453: set original_wip_entity_id = -999

Line 1452: update MTL_SERIAL_NUMBERS

1448: select count(*) into x_num_rows
1449: from MTL_SERIAL_NUMBERS
1450: WHERE ORIGINAL_WIP_ENTITY_ID = x_purge_rec.wip_entity_id ;
1451: else
1452: update MTL_SERIAL_NUMBERS
1453: set original_wip_entity_id = -999
1454: WHERE ORIGINAL_WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
1455:
1456: x_num_rows := SQL%ROWCOUNT ;

Line 1460: x_purge_rec.table_name := 'MTL_SERIAL_NUMBERS';

1456: x_num_rows := SQL%ROWCOUNT ;
1457: end if;
1458:
1459: if x_num_rows > 0 then
1460: x_purge_rec.table_name := 'MTL_SERIAL_NUMBERS';
1461: fnd_message.set_name('WIP', 'WIP_SERIAL_FOREIGN_KEY');
1462: x_purge_rec.info := fnd_message.get;
1463: append_report(x_purge_rec, p_option);
1464: end if;