DBA Data[Home] [Help]

APPS.AP_PURGE_PKG dependencies on PO_PURGE_REQ_LIST

Line 218: from po_purge_req_list

214:
215: -- count_reqs
216: select count(1)
217: into req_count
218: from po_purge_req_list
219: where double_check_flag = 'Y';
220:
221: if (req_count = 0) then
222:

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

249: end if;
250:
251: else -- req_count <> 0
252:
253: debug_info := 'The PO_PURGE_REQ_LIST table contains records. ';
254: Print('Check_no_purge_in_process' || debug_info);
255: Print('Please make sure no purges are running and clear');
256: Print(' this table. Process terminating.');
257:

Line 2532: from po_purge_req_list

2528: -- get_req_range
2529: select nvl(min(requisition_header_id),-1),
2530: nvl(max(requisition_header_id),-1)
2531: into p_req_lower_limit, p_req_upper_limit
2532: from po_purge_req_list
2533: where double_check_flag = 'Y';
2534:
2535: -- get_chv_range
2536: select nvl(min(schedule_item_id),-1),