APPS.WSM_JOBPURGE_GRP dependencies on WSM_INTERFACE_ERRORS

Line 88: from WSM_INTERFACE_ERRORS

84: begin
85: if (p_option = REPORT_ONLY) then
86: select count(*)
87: into p_wie_num_rows
88: from WSM_INTERFACE_ERRORS
89: where header_id = p_header_id
90: and request_id = nvl(p_request_id, -1);
91: else
92: DELETE FROM WSM_INTERFACE_ERRORS

Line 92: DELETE FROM WSM_INTERFACE_ERRORS

88: from WSM_INTERFACE_ERRORS
89: where header_id = p_header_id
90: and request_id = nvl(p_request_id, -1);
91: else
92: DELETE FROM WSM_INTERFACE_ERRORS
93: WHERE header_id = p_header_id
94: and request_id = nvl(p_request_id, -1);
95: p_wie_num_rows := SQL%ROWCOUNT;
96: end if;

Line 274: x_purge_rec.table_name := 'WSM_INTERFACE_ERRORS';

270: close get_purge_wtxnis;
271:
272: if x_wie_rows > 0 then
273:
274: x_purge_rec.table_name := 'WSM_INTERFACE_ERRORS';
275:
276: before_append_report(
277: p_option => p_option,
278: p_purge_rec => x_purge_rec,

Line 324: x_purge_rec.table_name := 'WSM_INTERFACE_ERRORS';

320: loop
321: FETCH get_purge_wlji into x_header_id, x_request_id;
322: EXIT when get_purge_wlji%NOTFOUND;
323:
324: x_purge_rec.table_name := 'WSM_INTERFACE_ERRORS';
325:
326: delete_wie(
327: p_option => p_option,
328: p_header_id => x_header_id,

Line 403: x_purge_rec.table_name := 'WSM_INTERFACE_ERRORS';

399: loop
400: FETCH get_purge_wlmti into x_header_id, x_request_id;
401: EXIT when get_purge_wlmti%NOTFOUND;
402:
403: x_purge_rec.table_name := 'WSM_INTERFACE_ERRORS';
404:
405: delete_wie(
406: p_option => p_option,
407: p_header_id => x_header_id,