DBA Data[Home] [Help]

APPS.WSM_JOBPURGE_GRP dependencies on WSM_STARTING_JOBS_INTERFACE

Line 139: from wsm_starting_jobs_interface sj

135: from wsm_split_merge_txn_interface wtxni
136: where wtxni.organization_id = pOrgId
137: and wtxni.header_id in (
138: select sj.header_id
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

Line 210: from WSM_STARTING_JOBS_INTERFACE

206:
207: if (p_option = REPORT_ONLY) then
208: select count(*)
209: into x_tmp_num_rows
210: from WSM_STARTING_JOBS_INTERFACE
211: where header_id = x_header_id;
212: else
213:
214: DELETE FROM WSM_STARTING_JOBS_INTERFACE

Line 214: DELETE FROM WSM_STARTING_JOBS_INTERFACE

210: from WSM_STARTING_JOBS_INTERFACE
211: where header_id = x_header_id;
212: else
213:
214: DELETE FROM WSM_STARTING_JOBS_INTERFACE
215: WHERE header_id = x_header_id;
216: x_tmp_num_rows := SQL%ROWCOUNT;
217:
218: end if;

Line 285: x_purge_rec.table_name := 'WSM_STARTING_JOBS_INTERFACE';

281: end if;
282:
283: if x_wsji_rows > 0 then
284:
285: x_purge_rec.table_name := 'WSM_STARTING_JOBS_INTERFACE';
286:
287: before_append_report(
288: p_option => p_option,
289: p_purge_rec => x_purge_rec,