DBA Data[Home] [Help]

APPS.AP_PURGE_PKG dependencies on PO_PURGE_REQ_LIST

Line 230: from po_purge_req_list

226:
227: -- count_reqs
228: select count(1)
229: into req_count
230: from po_purge_req_list
231: where double_check_flag = 'Y';
232:
233: if (req_count = 0) then
234:

Line 265: debug_info := 'The PO_PURGE_REQ_LIST table contains records. ';

261: end if;
262:
263: else -- req_count <> 0
264:
265: debug_info := 'The PO_PURGE_REQ_LIST table contains records. ';
266: Print('Check_no_purge_in_process' || debug_info);
267: Print('Please make sure no purges are running and clear');
268: Print(' this table. Process terminating.');
269:

Line 2787: from po_purge_req_list

2783: -- get_req_range
2784: select nvl(min(requisition_header_id),-1),
2785: nvl(max(requisition_header_id),-1)
2786: into p_req_lower_limit, p_req_upper_limit
2787: from po_purge_req_list
2788: where double_check_flag = 'Y';
2789:
2790: -- get_chv_range
2791: select nvl(min(schedule_item_id),-1),