APPS.PO_AP_PURGE_UTIL_PVT dependencies on PO_LINES

Line 218: FROM po_lines PL

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
218: FROM po_lines PL
219: WHERE PL.po_header_id = PH.po_header_id
220: AND (
221: PL.last_update_date > p_last_activity_date
222: OR

Line 305: FROM po_lines PL

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
305: FROM po_lines PL
306: WHERE PL.po_header_id = PH.po_header_id
307: AND (
308: PL.last_update_date > p_last_activity_date
309: OR

Line 2694: po_lines POL

2690: WHERE PPD.entity_type IN ('PO LINE', 'BLANKET LINE')
2691: AND EXISTS (
2692: SELECT NULL
2693: FROM po_purge_po_list PPL,
2694: po_lines POL
2695: WHERE PPL.po_header_id = POL.po_header_id
2696: AND POL.po_line_id = PPD.entity_id
2697: AND PPL.double_check_flag = 'Y'
2698: AND PPL.po_header_id BETWEEN p_range_low

Line 2719: po_lines POL

2715: WHERE PPD.entity_type IN ('PO LINE', 'BLANKET LINE')
2716: AND EXISTS (
2717: SELECT NULL
2718: FROM po_purge_po_list PPL,
2719: po_lines POL
2720: WHERE PPL.po_header_id = POL.po_header_id
2721: AND POL.po_line_id = PPD.entity_id
2722: AND PPL.double_check_flag = 'Y'
2723: AND PPL.po_header_id BETWEEN p_range_low

Line 2871: po_lines POL

2867: WHERE PPD.entity_type IN ('PO LINE', 'BLANKET LINE')
2868: AND EXISTS (
2869: SELECT NULL
2870: FROM po_purge_po_list PPL,
2871: po_lines POL
2872: WHERE PPL.po_header_id = POL.po_header_id
2873: AND POL.po_line_id = PPD.entity_id
2874: AND PPL.double_check_flag = 'Y'
2875: AND PPL.po_header_id BETWEEN p_range_low

Line 2895: po_lines POL

2891: FROM po_attribute_values PAV
2892: WHERE PAV.po_line_id IN
2893: ( SELECT po_line_id
2894: FROM po_purge_po_list PPL,
2895: po_lines POL
2896: WHERE PPL.po_header_id = POL.po_header_id
2897: AND PPL.double_check_flag = 'Y'
2898: AND PPL.po_header_id BETWEEN p_range_low
2899: AND p_range_high);

Line 2918: po_lines POL

2914: FROM po_attribute_values_tlp PAVT
2915: WHERE PAVT.po_line_id IN
2916: ( SELECT po_line_id
2917: FROM po_purge_po_list PPL,
2918: po_lines POL
2919: WHERE PPL.po_header_id = POL.po_header_id
2920: AND PPL.double_check_flag = 'Y'
2921: AND PPL.po_header_id BETWEEN p_range_low
2922: AND p_range_high);

Line 3134: po_lines POL

3130:
3131: CURSOR c_po_line IS
3132: SELECT POL.po_line_id
3133: FROM po_purge_po_list PPL,
3134: po_lines POL
3135: WHERE PPL.po_header_id BETWEEN p_range_low AND p_range_high
3136: AND PPL.double_check_flag = 'Y'
3137: AND PPL.po_header_id = POL.po_header_id;
3138:

Line 3215: -- attachments will be under entity PO_LINES and PO_IN_GA_LINES.

3211: FOR rec IN c_po_line LOOP
3212: l_progress := '050';
3213:
3214: -- If a GA line contains attachements, the references for these
3215: -- attachments will be under entity PO_LINES and PO_IN_GA_LINES.
3216: -- When deleting the reference in PO_IN_GA_LINES, we do not need to
3217: -- remove the actual attachments as they will be taken care of when
3218: -- we delete reference under entity PO_LINES.
3219:

Line 3218: -- we delete reference under entity PO_LINES.

3214: -- If a GA line contains attachements, the references for these
3215: -- attachments will be under entity PO_LINES and PO_IN_GA_LINES.
3216: -- When deleting the reference in PO_IN_GA_LINES, we do not need to
3217: -- remove the actual attachments as they will be taken care of when
3218: -- we delete reference under entity PO_LINES.
3219:
3220: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments
3221: ( x_entity_name => 'PO_IN_GA_LINES',
3222: x_pk1_value => rec.po_line_id,

Line 3228: ( x_entity_name => 'PO_LINES',

3224: x_automatically_added_flag=> 'Y'
3225: );
3226:
3227: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments
3228: ( x_entity_name => 'PO_LINES',
3229: x_pk1_value => rec.po_line_id,
3230: x_delete_document_flag => 'Y'
3231: );
3232: