APPS.PO_AP_PURGE_UTIL_PVT dependencies on PO_HEADERS

Line 205: FROM po_headers PH

201: )
202: SELECT PH.po_header_id,
203: p_purge_name,
204: 'Y'
205: FROM po_headers PH
206: WHERE PH.type_lookup_code IN ('STANDARD', 'PLANNED',
207: 'BLANKET', 'CONTRACT')
208: AND PH.last_update_date <= p_last_activity_date
209: AND (PH.closed_code = 'FINALLY CLOSED'

Line 292: FROM po_headers PH

288: )
289: SELECT PH.po_header_id,
290: p_purge_name,
291: 'Y'
292: FROM po_headers PH
293: WHERE PH.type_lookup_code IN ('STANDARD', 'PLANNED',
294: 'BLANKET', 'CONTRACT')
295: AND PH.last_update_date <= p_last_activity_date
296: AND (PH.closed_code = 'FINALLY CLOSED'

Line 1351: p_purge_entity_type => 'PO_HEADERS',

1347: p_commit => FND_API.G_FALSE,
1348: x_return_status => l_return_status,
1349: x_msg_count => l_msg_count,
1350: x_msg_data => l_msg_data,
1351: p_purge_entity_type => 'PO_HEADERS',
1352: p_purge_in_rec => l_in_rec,
1353: x_purge_out_rec => l_out_rec
1354: );
1355:

Line 1518: p_entity => 'PO_HEADERS',

1514: p_commit => FND_API.G_FALSE,
1515: x_return_status => l_return_status,
1516: x_msg_count => l_msg_count,
1517: x_msg_data => l_msg_data,
1518: p_entity => 'PO_HEADERS',
1519: p_entity_id_tbl => l_hdr_id_tbl,
1520: x_purge_allowed_tbl => l_purge_allowed_tbl
1521: );
1522:

Line 1646: l_in_rec.entity_name := 'PO_HEADERS';

1642: END IF;
1643:
1644: x_return_status := FND_API.G_RET_STS_SUCCESS;
1645:
1646: l_in_rec.entity_name := 'PO_HEADERS';
1647:
1648: OPEN c_po_list;
1649:
1650: LOOP

Line 2142: p_entity => 'PO_HEADERS',

2138: p_commit => FND_API.G_FALSE,
2139: x_return_status => l_return_status,
2140: x_msg_count => l_msg_count,
2141: x_msg_data => l_msg_data,
2142: p_entity => 'PO_HEADERS',
2143: p_entity_id_tbl => l_po_hdr_tbl
2144: );
2145:
2146: IF (g_fnd_debug = 'Y') THEN

Line 2374: l_in_rec.entity_name := 'PO_HEADERS';

2370:
2371: x_return_status := FND_API.G_RET_STS_SUCCESS;
2372:
2373: IF (p_purge_entity = 'PO') THEN
2374: l_in_rec.entity_name := 'PO_HEADERS';
2375:
2376: SELECT PPL.po_header_id
2377: BULK COLLECT
2378: INTO l_in_rec.entity_ids

Line 2500: FROM po_headers PH,

2496: SELECT DECODE (PH.type_lookup_code, 'STANDARD', 'PO_STANDARD',
2497: 'BLANKET' , 'PA_BLANKET',
2498: 'CONTRACT', 'PA_CONTRACT') DOC_TYPE,
2499: PH.po_header_id DOC_ID
2500: FROM po_headers PH,
2501: po_purge_po_list PPL
2502: WHERE PH.po_header_id = PPL.po_header_id
2503: AND PPL.double_check_flag = 'Y'
2504: AND PPL.po_header_id BETWEEN p_range_low AND p_range_high

Line 3169: ( x_entity_name => 'PO_HEADERS',

3165: FOR rec IN c_po_header LOOP
3166: l_progress := '010';
3167:
3168: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments
3169: ( x_entity_name => 'PO_HEADERS',
3170: x_pk1_value => rec.po_header_id,
3171: x_delete_document_flag => 'Y'
3172: );
3173: