APPS.WSM_JOBPURGE_GRP dependencies on WSM_SPLIT_MERGE_TXN_INTERFACE

Line 135: from wsm_split_merge_txn_interface wtxni

131: l_serial_intf_rows NUMBER := 0;
132:
133: cursor get_purge_wtxnis (pEntityName VARCHAR2, pWipEntityId NUMBER, pOrgId NUMBER) is
134: select wtxni.header_id, wtxni.request_id
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

Line 240: from WSM_SPLIT_MERGE_TXN_INTERFACE

236:
237: if (p_option = REPORT_ONLY) then
238: select count(*)
239: into x_tmp_num_rows
240: from WSM_SPLIT_MERGE_TXN_INTERFACE
241: where header_id = x_header_id;
242: else
243:
244: DELETE FROM WSM_SPLIT_MERGE_TXN_INTERFACE

Line 244: DELETE FROM WSM_SPLIT_MERGE_TXN_INTERFACE

240: from WSM_SPLIT_MERGE_TXN_INTERFACE
241: where header_id = x_header_id;
242: else
243:
244: DELETE FROM WSM_SPLIT_MERGE_TXN_INTERFACE
245: WHERE header_id = x_header_id;
246: x_tmp_num_rows := SQL%ROWCOUNT;
247:
248: end if;

Line 307: x_purge_rec.table_name := 'WSM_SPLIT_MERGE_TXN_INTERFACE';

303: end if;
304:
305: if x_wsmti_rows > 0 then
306:
307: x_purge_rec.table_name := 'WSM_SPLIT_MERGE_TXN_INTERFACE';
308:
309: before_append_report(
310: p_option => p_option,
311: p_purge_rec => x_purge_rec,