APPS.WSM_JOBPURGE_GRP dependencies on WSM_LOT_JOB_INTERFACE

Line 151: from WSM_LOT_JOB_INTERFACE wlji

147: -- get header_ids of purge job in wlji
148:
149: cursor get_purge_wlji (pEntityName VARCHAR2, pOrgId NUMBER) is
150: select wlji.header_id, wlji.request_id
151: from WSM_LOT_JOB_INTERFACE wlji
152: where wlji.job_name = pEntityName
153: and wlji.organization_id = pOrgId;
154:
155:

Line 316: -- WIE ref WSM_LOT_JOB_INTERFACE

312: num_rows => x_wsmti_rows);
313: x_wsmti_rows := 0;
314: end if;
315:
316: -- WIE ref WSM_LOT_JOB_INTERFACE
317: -- before delete wlji, purge WIE first
318: open get_purge_wlji (x_purge_rec.entity_name, x_purge_rec.org_id);
319:
320: loop

Line 369: x_purge_rec.table_name := 'WSM_LOT_JOB_INTERFACE';

365: num_rows => x_wie_rows);
366: x_wie_rows := 0;
367: end if;
368:
369: x_purge_rec.table_name := 'WSM_LOT_JOB_INTERFACE';
370:
371: if (p_option = REPORT_ONLY) then
372: select count(*)
373: into x_num_rows

Line 374: from WSM_LOT_JOB_INTERFACE

370:
371: if (p_option = REPORT_ONLY) then
372: select count(*)
373: into x_num_rows
374: from WSM_LOT_JOB_INTERFACE
375: where job_name = x_purge_rec.entity_name
376: and organization_id = x_purge_rec.org_id;
377: else
378:

Line 379: DELETE FROM WSM_LOT_JOB_INTERFACE

375: where job_name = x_purge_rec.entity_name
376: and organization_id = x_purge_rec.org_id;
377: else
378:
379: DELETE FROM WSM_LOT_JOB_INTERFACE
380: WHERE job_name = x_purge_rec.entity_name
381: AND organization_id = x_purge_rec.org_id;
382: x_num_rows := SQL%ROWCOUNT;
383: