DBA Data[Home] [Help]

APPS.PO_AP_PURGE_UTIL_PVT dependencies on PO_REQUISITION_HEADERS

Line 375: FROM po_requisition_headers PRH

371: )
372: SELECT PRH.requisition_header_id,
373: p_purge_name,
374: 'Y'
375: FROM po_requisition_headers PRH
376: WHERE PRH.last_update_date <= p_last_activity_date
377: AND (PRH.closed_code = 'FINALLY CLOSED'
378: OR PRH.authorization_status = 'CANCELLED')
379: AND NOT EXISTS

Line 1024: l_in_rec.entity_name := 'PO_REQUISITION_HEADERS';

1020: END IF;
1021:
1022: x_return_status := FND_API.G_RET_STS_SUCCESS;
1023:
1024: l_in_rec.entity_name := 'PO_REQUISITION_HEADERS';
1025:
1026: OPEN c_po_list;
1027:
1028: LOOP

Line 2385: l_in_rec.entity_name := 'PO_REQUISITION_HEADERS';

2381: AND PPL.po_header_id BETWEEN p_range_low AND p_range_high;
2382:
2383: l_progress := '010';
2384: ELSE
2385: l_in_rec.entity_name := 'PO_REQUISITION_HEADERS';
2386:
2387: SELECT PPRL.requisition_header_id
2388: BULK COLLECT
2389: INTO l_in_rec.entity_ids