APPS.PO_AP_PURGE_UTIL_PVT dependencies on PO_RELEASES

Line 213: FROM po_releases PR

209: AND (PH.closed_code = 'FINALLY CLOSED'
210: OR PH.cancel_flag = 'Y')
211: AND NOT EXISTS
212: (SELECT NULL
213: FROM po_releases PR
214: WHERE PR.po_header_id = PH.po_header_id
215: AND PR.last_update_date > p_last_activity_date)
216: AND NOT EXISTS
217: (SELECT NULL

Line 300: FROM po_releases PR

296: AND (PH.closed_code = 'FINALLY CLOSED'
297: OR PH.cancel_flag = 'Y')
298: AND NOT EXISTS
299: (SELECT NULL
300: FROM po_releases PR
301: WHERE PR.po_header_id = PH.po_header_id
302: AND PR.last_update_date > p_last_activity_date)
303: AND NOT EXISTS
304: (SELECT NULL

Line 3126: po_releases PR

3122:
3123: CURSOR c_po_release IS
3124: SELECT PR.po_release_id
3125: FROM po_purge_po_list PPL,
3126: po_releases PR
3127: WHERE PPL.po_header_id BETWEEN p_range_low AND p_range_high
3128: AND PPL.double_check_flag = 'Y'
3129: AND PPL.po_header_id = PR.po_header_id;
3130:

Line 3186: -- Delete po releases attachments

3182: END LOOP;
3183:
3184: l_progress := '020';
3185:
3186: -- Delete po releases attachments
3187:
3188: FOR rec IN c_po_release LOOP
3189: l_progress := '030';
3190:

Line 3192: ( x_entity_name => 'PO_RELEASES',

3188: FOR rec IN c_po_release LOOP
3189: l_progress := '030';
3190:
3191: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments
3192: ( x_entity_name => 'PO_RELEASES',
3193: x_pk1_value => rec.po_release_id,
3194: x_delete_document_flag => 'Y'
3195: );
3196: