eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_AP_PURGE_PVT dependencies on PO_PURGE_PO_LIST

Line 1242: FROM po_purge_po_list;

1238: DELETE
1239: FROM po_purge_req_list;
1240:
1241: DELETE
1242: FROM po_purge_po_list;
1243:
1244: IF (FND_API.to_boolean(p_commit)) THEN
1245: COMMIT;
1246: END IF;

Line 1710: --Modifies: po_purge_po_list

1706: -----------------------------------------------------------------------
1707: --Start of Comments
1708: --Name: seed_po
1709: --Pre-reqs:
1710: --Modifies: po_purge_po_list
1711: --Locks:
1712: -- None
1713: --Function:
1714: -- Populate po purge list with eligible pos that have not been updated

Line 1795: INSERT INTO po_purge_po_list

1791: -- will be additional rules getting applied to this table
1792: -- to remove records that are actually not eligible for
1793: -- purge
1794:
1795: INSERT INTO po_purge_po_list
1796: ( po_header_id,
1797: purge_name,
1798: double_check_flag
1799: )

Line 1856: INSERT INTO po_purge_po_list

1852: -- will be additional rules getting applied to this table
1853: -- to remove records that are actually not eligible for
1854: -- purge
1855:
1856: INSERT INTO po_purge_po_list
1857: ( po_header_id,
1858: purge_name,
1859: double_check_flag
1860: )

Line 2472: --Modifies: po_purge_po_list

2468: -----------------------------------------------------------------------
2469: --Start of Comments
2470: --Name: filter_referenced_po
2471: --Pre-reqs:
2472: --Modifies: po_purge_po_list
2473: --Locks:
2474: -- None
2475: --Function:
2476: -- Remove po from the req purge list if it is referenced by records

Line 2519: UPDATE po_purge_po_list PPL

2515:
2516: IF (g_inv_install_status = 'Y') THEN
2517: l_progress := '010';
2518:
2519: UPDATE po_purge_po_list PPL
2520: SET PPL.double_check_flag = 'N'
2521: WHERE PPL.double_check_flag = 'Y'
2522: AND EXISTS (
2523: SELECT NULL

Line 2548: UPDATE po_purge_po_list PPL

2544:
2545: IF (g_wip_install_status = 'Y') THEN
2546: l_progress := '020';
2547:
2548: UPDATE po_purge_po_list PPL
2549: SET PPL.double_check_flag = 'N'
2550: WHERE PPL.double_check_flag = 'Y'
2551: AND EXISTS (
2552: SELECT NULL

Line 2576: UPDATE po_purge_po_list PPL

2572:
2573: IF (g_mrp_install_status = 'Y') THEN
2574: l_progress := '030';
2575:
2576: UPDATE po_purge_po_list PPL
2577: SET PPL.double_check_flag = 'N'
2578: WHERE PPL.double_check_flag = 'Y'
2579: AND EXISTS (
2580: SELECT NULL

Line 2605: UPDATE po_purge_po_list PPL

2601:
2602: IF (g_chv_install_status = 'Y') THEN
2603: l_progress := '040';
2604:
2605: UPDATE po_purge_po_list PPL
2606: SET PPL.double_check_flag = 'N'
2607: WHERE PPL.double_check_flag = 'Y'
2608: AND EXISTS(
2609: SELECT NULL

Line 2629: UPDATE po_purge_po_list PPL

2625:
2626: IF (g_pa_install_status = 'Y') THEN
2627: l_progress := '050';
2628:
2629: UPDATE po_purge_po_list PPL
2630: SET PPL.double_check_flag = 'N'
2631: WHERE PPL.double_check_flag = 'Y'
2632: AND EXISTS (
2633: SELECT NULL

Line 2659: UPDATE po_purge_po_list PPL

2655:
2656: IF (g_pjm_install_status = 'Y') THEN
2657: l_progress := '060';
2658:
2659: UPDATE po_purge_po_list PPL
2660: SET PPL.double_check_flag = 'N'
2661: WHERE PPL.double_check_flag = 'Y'
2662: AND EXISTS (
2663: SELECT NULL

Line 2730: --Modifies: po_purge_po_list, po_purge_req_list

2726: -----------------------------------------------------------------------
2727: --Start of Comments
2728: --Name: filter_dependent_po_req_list
2729: --Pre-reqs:
2730: --Modifies: po_purge_po_list, po_purge_req_list
2731: --Locks:
2732: -- None
2733: --Function:
2734: -- Remove documents (req, po, ga, contract) from the purge list if their

Line 2797: UPDATE po_purge_po_list PPL

2793: -- SQL Why: If PO has backing req, either both of them are purged or
2794: -- none of them are purged. Same for the PO-Contract and
2795: -- PO-GA relationship
2796:
2797: UPDATE po_purge_po_list PPL
2798: SET PPL.double_check_flag = 'N'
2799: WHERE PPL.double_check_flag = 'Y'
2800: AND (EXISTS ( -- rm po if req not in purge list
2801: SELECT NULL

Line 2820: FROM po_purge_po_list PPL1

2816: WHERE POL.po_header_id = PPL.po_header_id
2817: AND POL.contract_id IS NOT NULL
2818: AND NOT EXISTS (
2819: SELECT NULL
2820: FROM po_purge_po_list PPL1
2821: WHERE PPL1.double_check_flag = 'Y'
2822: AND PPL1.po_header_id =
2823: POL.contract_id))
2824: OR

Line 2835: FROM po_purge_po_list PPL1

2831: AND POH.type_lookup_code = 'BLANKET'
2832: AND POH.global_agreement_flag = 'Y'
2833: AND NOT EXISTS (
2834: SELECT NULL
2835: FROM po_purge_po_list PPL1
2836: WHERE PPL1.double_check_flag = 'Y'
2837: AND POH.po_header_id =
2838: PPL1.po_Header_id))
2839: OR

Line 2846: FROM po_purge_po_list PPL1

2842: FROM po_lines_all POL
2843: WHERE PPL.po_header_id = POL.contract_id
2844: AND NOT EXISTS (
2845: SELECT NULL
2846: FROM po_purge_po_list PPL1
2847: WHERE PPL1.double_check_flag = 'Y'
2848: AND POL.po_header_id =
2849: PPL1.po_header_id))
2850: OR

Line 2861: FROM po_purge_po_list PPL1

2857: AND POH.global_agreement_flag = 'Y'
2858: AND POL.from_header_id = POH.po_header_id
2859: AND NOT EXISTS (
2860: SELECT NULL
2861: FROM po_purge_po_list PPL1
2862: WHERE PPL1.double_check_flag = 'Y'
2863: AND POL.po_header_id =
2864: PPL1.po_header_id)));
2865:

Line 2886: FROM po_purge_po_list PPL

2882: PPRL.requisition_header_id
2883: AND RL.line_location_id = PLL.line_location_id
2884: AND NOT EXISTS (
2885: SELECT NULL
2886: FROM po_purge_po_list PPL
2887: WHERE PPL.double_check_flag = 'Y'
2888: AND PPL.po_header_id =
2889: PLL.po_header_id));
2890: l_req_count := SQL%ROWCOUNT;

Line 2949: --Modifies: po_purge_po_list

2945: -----------------------------------------------------------------------
2946: --Start of Comments
2947: --Name: filter_dependent_po_ap_list
2948: --Pre-reqs:
2949: --Modifies: po_purge_po_list
2950: --Locks:
2951: -- None
2952: --Function:
2953: -- Remove PO from the list if its depending invoice is not in the purge list

Line 3001: UPDATE po_purge_po_list PPL

2997: -- is not in the po purge list
2998: -- SQL Why: If PO and Invoice are linked, either both of them are
2999: -- purged or none of them is purged
3000:
3001: UPDATE po_purge_po_list PPL
3002: SET PPL.double_check_flag = 'N'
3003: WHERE PPL.double_check_flag = 'Y'
3004: AND EXISTS (
3005: SELECT NULL

Line 3061: --Modifies: po_purge_po_list, po_purge_req_list

3057: -----------------------------------------------------------------------
3058: --Start of Comments
3059: --Name: remove_filtered_records
3060: --Pre-reqs:
3061: --Modifies: po_purge_po_list, po_purge_req_list
3062: --Locks:
3063: -- None
3064: --Function:
3065: -- Delete records from purge list if the record has double_check_flag = 'N'

Line 3126: DELETE FROM po_purge_po_list

3122: IF (p_purge_category IN (PO_AP_PURGE_GRP.G_PUR_CAT_SIMPLE_PO,
3123: PO_AP_PURGE_GRP.G_PUR_CAT_MATCHED_PO_INV)) THEN
3124: l_progress := '020';
3125:
3126: DELETE FROM po_purge_po_list
3127: WHERE double_check_flag = 'N';
3128:
3129: IF (g_fnd_debug = 'Y') THEN
3130: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 3302: --Modifies: po_purge_po_list

3298: -----------------------------------------------------------------------
3299: --Start of Comments
3300: --Name: confirm_po
3301: --Pre-reqs:
3302: --Modifies: po_purge_po_list
3303: --Locks:
3304: -- None
3305: --Function:
3306: -- Exclude pos that have been updated recently from the purge list

Line 3363: UPDATE po_purge_po_list PPL

3359: -- SQL Why: At Confirmation Stage, we need to make sure that all the
3360: -- remaining records in the purge list are still eligible for
3361: -- purging
3362:
3363: UPDATE po_purge_po_list PPL
3364: SET double_check_flag = 'N'
3365: WHERE double_check_flag = 'Y'
3366: AND NOT EXISTS (
3367: SELECT NULL

Line 3432: UPDATE po_purge_po_list PPL

3428: -- SQL Why: At Confirmation Stage, we need to make sure that all the
3429: -- remaining records in the purge list are still eligible for
3430: -- purging
3431:
3432: UPDATE po_purge_po_list PPL
3433: SET double_check_flag = 'N'
3434: WHERE double_check_flag = 'Y'
3435: AND NOT EXISTS (
3436: SELECT NULL

Line 3667: FROM po_purge_po_list PPL

3663: SELECT NVL ( MIN (PPL.po_header_id), -1 ),
3664: NVL ( MAX (PPL.po_header_id), -1 )
3665: INTO x_lower_limit,
3666: x_upper_limit
3667: FROM po_purge_po_list PPL
3668: WHERE PPL.double_check_flag = 'Y';
3669:
3670: END IF; -- p_category
3671:

Line 4075: po_purge_po_list PPL

4071: FROM per_all_people_f PAPF,
4072: po_vendor_sites VDS,
4073: po_headers PH,
4074: po_line_locations PLL,
4075: po_purge_po_list PPL
4076: WHERE PPL.po_header_id BETWEEN l_range_low AND l_range_high
4077: AND PPL.double_check_flag = 'Y'
4078: AND PPL.po_header_id = PH.po_header_id
4079: AND NVL(PH.global_agreement_flag, 'N') = 'N'

Line 4151: po_purge_po_list PPL

4147: FROM per_all_people_f PAPF,
4148: po_vendor_sites VDS,
4149: po_headers PH,
4150: po_line_locations_all PLL,
4151: po_purge_po_list PPL
4152: WHERE PPL.po_header_id BETWEEN l_range_low AND l_range_high
4153: AND PPL.double_check_flag = 'Y'
4154: AND PPL.po_header_id = PH.po_header_id
4155: AND PH.global_agreement_flag = 'Y'

Line 4225: po_purge_po_list PPL

4221: po_vendor_sites VDS,
4222: po_headers PH,
4223: po_lines_all POL,
4224: po_line_locations_all PLL,
4225: po_purge_po_list PPL
4226: WHERE PPL.po_header_id BETWEEN l_range_low AND l_range_high
4227: AND PPL.double_check_flag = 'Y'
4228: AND PPL.po_header_id = PH.po_header_id
4229: AND PH.type_lookup_code = 'CONTRACT'

Line 4301: po_purge_po_list PPL

4297: per_all_people_f PAPF,
4298: po_releases PREL,
4299: po_headers PH,
4300: po_line_locations PLL,
4301: po_purge_po_list PPL
4302: WHERE PPL.po_header_id = PH.po_header_id
4303: AND PH.po_header_id = PREL.po_header_id
4304: AND PREL.po_release_id = PLL.po_release_id
4305: AND PLL.shipment_type IN ('SCHEDULED', 'BLANKET')

Line 4694: --SQL What: This cursor will divide po_purge_po_list into groups of

4690: IF (p_po_lower_limit = -1) THEN
4691: RETURN;
4692: END IF;
4693:
4694: --SQL What: This cursor will divide po_purge_po_list into groups of
4695: -- records with size p_range_size. Each fetch will return the
4696: -- highest req id of that group
4697: --SQL Why: We want to delete data in smaller groups to avoid running
4698: -- out of rollback segments

Line 4704: FROM po_purge_po_list PPL

4700: SELECT PPL2.po_header_id
4701: BULK COLLECT INTO l_ids_tbl
4702: FROM (SELECT PPL.po_header_id po_header_id,
4703: MOD(ROWNUM, p_range_size) mod_result
4704: FROM po_purge_po_list PPL
4705: WHERE PPL.double_check_flag = 'Y'
4706: ORDER BY PPL.po_header_id) PPL2
4707: WHERE PPL2.mod_result = 0;
4708:

Line 4753: FROM po_purge_po_list PPL

4749: DELETE
4750: FROM po_headers PH
4751: WHERE EXISTS (
4752: SELECT NULL
4753: FROM po_purge_po_list PPL
4754: WHERE PPL.po_header_id = PH.po_header_id
4755: AND PPL.double_check_flag = 'Y'
4756: AND PPL.po_header_id BETWEEN l_range_low
4757: AND l_range_high)

Line 4780: FROM po_purge_po_list PPL

4776: DELETE
4777: FROM po_headers_archive PHA
4778: WHERE EXISTS (
4779: SELECT NULL
4780: FROM po_purge_po_list PPL
4781: WHERE PPL.po_header_id = PHA.po_header_id
4782: AND PPL.double_check_flag = 'Y'
4783: AND PPL.po_header_id BETWEEN l_range_low
4784: AND l_range_high);

Line 4803: FROM po_purge_po_list PPL

4799: DELETE
4800: FROM po_lines PL
4801: WHERE EXISTS (
4802: SELECT NULL
4803: FROM po_purge_po_list PPL
4804: WHERE PPL.po_header_id = PL.po_header_id
4805: AND PPL.double_check_flag = 'Y'
4806: AND PPL.po_header_id BETWEEN l_range_low
4807: AND l_range_high);

Line 4827: FROM po_purge_po_list PPL,

4823: DELETE
4824: FROM PO_ATTRIBUTE_VALUES POATR
4825: WHERE EXISTS (
4826: SELECT NULL
4827: FROM po_purge_po_list PPL,
4828: po_lines_all POL
4829: WHERE PPL.po_header_id = POL.po_header_id
4830: AND POATR.po_line_id = POL.po_line_id
4831: AND PPL.double_check_flag = 'Y'

Line 4852: FROM po_purge_po_list PPL,

4848: DELETE
4849: FROM PO_ATTRIBUTE_VALUES_TLP POTLP
4850: WHERE EXISTS (
4851: SELECT NULL
4852: FROM po_purge_po_list PPL,
4853: po_lines_all POL
4854: WHERE PPL.po_header_id = POL.po_header_id
4855: AND POTLP.po_line_id = POL.po_line_id
4856: AND PPL.double_check_flag = 'Y'

Line 4878: FROM po_purge_po_list PPL

4874: DELETE
4875: FROM po_lines_archive PLA
4876: WHERE EXISTS (
4877: SELECT NULL
4878: FROM po_purge_po_list PPL
4879: WHERE PPL.po_header_id = PLA.po_header_id
4880: AND PPL.double_check_flag = 'Y'
4881: AND PPL.po_header_id BETWEEN l_range_low
4882: AND l_range_high);

Line 4902: FROM po_purge_po_list PPL,

4898: DELETE
4899: FROM PO_ATTR_VALUES_ARCHIVE POATRA
4900: WHERE EXISTS (
4901: SELECT NULL
4902: FROM po_purge_po_list PPL,
4903: po_lines_all POL
4904: WHERE PPL.po_header_id = POL.po_header_id
4905: AND POATRA.po_line_id = POL.po_line_id
4906: AND PPL.double_check_flag = 'Y'

Line 4927: FROM po_purge_po_list PPL,

4923: DELETE
4924: FROM PO_ATTR_VALUES_TLP_ARCHIVE POTLPA
4925: WHERE EXISTS (
4926: SELECT NULL
4927: FROM po_purge_po_list PPL,
4928: po_lines_all POL
4929: WHERE PPL.po_header_id = POL.po_header_id
4930: AND POTLPA.po_line_id = POL.po_line_id
4931: AND PPL.double_check_flag = 'Y'

Line 4953: FROM po_purge_po_list PPL

4949: DELETE
4950: FROM po_line_locations PLL
4951: WHERE EXISTS (
4952: SELECT NULL
4953: FROM po_purge_po_list PPL
4954: WHERE PPL.po_header_id = PLL.po_header_id
4955: AND PPL.double_check_flag = 'Y'
4956: AND PPL.po_header_id BETWEEN l_range_low
4957: AND l_range_high);

Line 4976: FROM po_purge_po_list PPL

4972: DELETE
4973: FROM po_line_locations_archive PLLA
4974: WHERE EXISTS (
4975: SELECT NULL
4976: FROM po_purge_po_list PPL
4977: WHERE PPL.po_header_id = PLLA.po_header_id
4978: AND PPL.double_check_flag = 'Y'
4979: AND PPL.po_header_id BETWEEN l_range_low
4980: AND l_range_high);

Line 4999: FROM po_purge_po_list PPL

4995: DELETE
4996: FROM po_distributions PD
4997: WHERE EXISTS (
4998: SELECT NULL
4999: FROM po_purge_po_list PPL
5000: WHERE PPL.po_header_id = PD.po_header_id
5001: AND PPL.double_check_flag = 'Y'
5002: AND PPL.po_header_id BETWEEN l_range_low
5003: AND l_range_high);

Line 5022: FROM po_purge_po_list PPL

5018: DELETE
5019: FROM po_distributions_archive PDA
5020: WHERE EXISTS (
5021: SELECT NULL
5022: FROM po_purge_po_list PPL
5023: WHERE PPL.po_header_id = PDA.po_header_id
5024: AND PPL.double_check_flag = 'Y'
5025: AND PPL.po_header_id BETWEEN l_range_low
5026: AND l_range_high);

Line 5045: FROM po_purge_po_list PPL

5041: DELETE
5042: FROM po_releases PR
5043: WHERE EXISTS (
5044: SELECT NULL
5045: FROM po_purge_po_list PPL
5046: WHERE PPL.po_header_id = PR.po_header_id
5047: AND PPL.double_check_flag = 'Y'
5048: AND PPL.po_header_id BETWEEN l_range_low
5049: AND l_range_high)

Line 5073: FROM po_purge_po_list PPL

5069: DELETE
5070: FROM po_releases_archive PRA
5071: WHERE EXISTS (
5072: SELECT NULL
5073: FROM po_purge_po_list PPL
5074: WHERE PPL.po_header_id = PRA.po_header_id
5075: AND PPL.double_check_flag = 'Y'
5076: AND PPL.po_header_id BETWEEN l_range_low
5077: AND l_range_high);

Line 5096: FROM po_purge_po_list PPL

5092: DELETE
5093: FROM po_acceptances PA
5094: WHERE EXISTS (
5095: SELECT NULL
5096: FROM po_purge_po_list PPL
5097: WHERE PPL.po_header_id = PA.po_header_id
5098: AND PPL.double_check_flag = 'Y'
5099: AND PPL.po_header_id BETWEEN l_range_low
5100: AND l_range_high);

Line 5120: FROM po_purge_po_list PPL

5116: FROM po_action_history PAH
5117: WHERE PAH.object_type_code = 'PO'
5118: AND EXISTS (
5119: SELECT NULL
5120: FROM po_purge_po_list PPL
5121: WHERE PPL.po_header_id = PAH.object_id
5122: AND PPL.double_check_flag = 'Y'
5123: AND PPL.po_header_id BETWEEN l_range_low
5124: AND l_range_high);

Line 5149: FROM po_purge_po_list PPL

5145: PRL.last_update_login = FND_GLOBAL.login_id
5146: WHERE PRL.blanket_po_header_id IS NOT NULL
5147: AND PRL.blanket_po_header_id IN (
5148: SELECT po_header_id
5149: FROM po_purge_po_list PPL
5150: WHERE PPL.double_check_flag = 'Y'
5151: AND PPL.po_header_id BETWEEN l_range_low
5152: AND l_range_high);
5153: