APPS.WSM_JOBPURGE_GRP dependencies on WSM_RESULTING_JOBS_INTERFACE

Line 143: from wsm_resulting_jobs_interface rj

139: from wsm_starting_jobs_interface sj
140: where sj.wip_entity_id = pWipEntityId
141: union
142: select rj.header_id
143: from wsm_resulting_jobs_interface rj
144: where rj.wip_entity_name = pEntityName
145: );
146:
147: -- get header_ids of purge job in wlji

Line 225: from WSM_RESULTING_JOBS_INTERFACE

221:
222: if (p_option = REPORT_ONLY) then
223: select count(*)
224: into x_tmp_num_rows
225: from WSM_RESULTING_JOBS_INTERFACE
226: where header_id = x_header_id;
227: else
228:
229: DELETE FROM WSM_RESULTING_JOBS_INTERFACE

Line 229: DELETE FROM WSM_RESULTING_JOBS_INTERFACE

225: from WSM_RESULTING_JOBS_INTERFACE
226: where header_id = x_header_id;
227: else
228:
229: DELETE FROM WSM_RESULTING_JOBS_INTERFACE
230: WHERE header_id = x_header_id;
231: x_tmp_num_rows := SQL%ROWCOUNT;
232:
233: end if;

Line 296: x_purge_rec.table_name := 'WSM_RESULTING_JOBS_INTERFACE';

292: end if;
293:
294: if x_wrji_rows > 0 then
295:
296: x_purge_rec.table_name := 'WSM_RESULTING_JOBS_INTERFACE';
297:
298: before_append_report(
299: p_option => p_option,
300: p_purge_rec => x_purge_rec,