APPS.WSM_JOBPURGE_GRP dependencies on WSM_LOT_MOVE_TXN_INTERFACE

Line 158: from WSM_LOT_MOVE_TXN_INTERFACE wlmti

154:
155:
156: cursor get_purge_wlmti (pWipEntityId NUMBER, pOrgId NUMBER) is
157: select wlmti.header_id, wlmti.request_id
158: from WSM_LOT_MOVE_TXN_INTERFACE wlmti
159: where wlmti.wip_entity_id = pWipEntityId
160: and wlmti.organization_id = pOrgId;
161:
162: begin

Line 393: -- WIE ref WSM_LOT_MOVE_TXN_INTERFACE

389: p_purge_rec => x_purge_rec,
390: num_rows => x_num_rows);
391: end if;
392:
393: -- WIE ref WSM_LOT_MOVE_TXN_INTERFACE
394:
395: x_wie_rows := 0;
396:
397: open get_purge_wlmti(x_purge_rec.wip_entity_id, x_purge_rec.org_id);

Line 449: x_purge_rec.table_name := 'WSM_LOT_MOVE_TXN_INTERFACE';

445: num_rows => x_wie_rows);
446: x_wie_rows := 0;
447: end if;
448:
449: x_purge_rec.table_name := 'WSM_LOT_MOVE_TXN_INTERFACE';
450:
451: if (p_option = REPORT_ONLY) then
452: select count(*)
453: into x_num_rows

Line 454: from WSM_LOT_MOVE_TXN_INTERFACE

450:
451: if (p_option = REPORT_ONLY) then
452: select count(*)
453: into x_num_rows
454: from WSM_LOT_MOVE_TXN_INTERFACE
455: where wip_entity_id = x_purge_rec.wip_entity_id;
456:
457: else
458:

Line 459: DELETE FROM WSM_LOT_MOVE_TXN_INTERFACE

455: where wip_entity_id = x_purge_rec.wip_entity_id;
456:
457: else
458:
459: DELETE FROM WSM_LOT_MOVE_TXN_INTERFACE
460: WHERE wip_entity_id = x_purge_rec.wip_entity_id;
461: x_num_rows := SQL%ROWCOUNT;
462:
463: end if;