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_REQ_LIST

Line 1239: FROM po_purge_req_list;

1235:
1236: -- clear the purge lists
1237:
1238: DELETE
1239: FROM po_purge_req_list;
1240:
1241: DELETE
1242: FROM po_purge_po_list;
1243:

Line 1575: --Modifies: po_purge_req_list

1571: -----------------------------------------------------------------------
1572: --Start of Comments
1573: --Name: seed_simple_req
1574: --Pre-reqs:
1575: --Modifies: po_purge_req_list
1576: --Locks:
1577: -- None
1578: --Function:
1579: -- Populate req purge list with eligible reqs that have not been updated

Line 1628: INSERT INTO po_purge_req_list

1624: -- SQL Why: This is the initial list of reqs to be purged. Later on the
1625: -- records in this list will be removed if the records are no
1626: -- longer eligible for purging after additional rules are applied
1627:
1628: INSERT INTO po_purge_req_list
1629: ( requisition_header_id,
1630: purge_name,
1631: double_check_flag
1632: )

Line 1922: INSERT INTO po_purge_req_list

1918: -- the records in this list will be removed if the records
1919: -- are no longer eligible for purging after additional rules
1920: -- are applied
1921:
1922: INSERT INTO po_purge_req_list
1923: ( requisition_header_id,
1924: purge_name,
1925: double_check_flag
1926: )

Line 2288: --Modifies: po_purge_req_list

2284: -----------------------------------------------------------------------
2285: --Start of Comments
2286: --Name: filter_referenced_req
2287: --Pre-reqs:
2288: --Modifies: po_purge_req_list
2289: --Locks:
2290: -- None
2291: --Function:
2292: -- Remove req from the req purge list if it is referenced by records

Line 2336: UPDATE po_purge_req_list PPRL

2332:
2333: IF (g_chv_install_status = 'Y') THEN
2334: l_progress := '010';
2335:
2336: UPDATE po_purge_req_list PPRL
2337: SET PPRL.double_check_flag = 'N'
2338: WHERE PPRL.double_check_flag = 'Y'
2339: AND EXISTS
2340: (SELECT NULL

Line 2360: UPDATE po_purge_req_list PPRL

2356:
2357: IF (g_pa_install_status = 'Y') THEN
2358: l_progress := '020';
2359:
2360: UPDATE po_purge_req_list PPRL
2361: SET PPRL.double_check_flag = 'N'
2362: WHERE PPRL.double_check_flag = 'Y'
2363: AND EXISTS
2364: (SELECT NULL

Line 2394: UPDATE po_purge_req_list PPRL

2390:
2391: IF (g_pjm_install_status = 'Y') THEN
2392: l_progress := '030';
2393:
2394: UPDATE po_purge_req_list PPRL
2395: SET PPRL.double_check_flag = 'N'
2396: WHERE PPRL.double_check_flag = 'Y'
2397: AND EXISTS
2398: (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 2808: FROM po_purge_req_list PRL

2804: WHERE PLL.po_header_id = PPL.po_header_id
2805: AND PLL.line_location_id = RL.line_location_id
2806: AND NOT EXISTS (
2807: SELECT NULL
2808: FROM po_purge_req_list PRL
2809: WHERE PRL.requisition_header_id =
2810: RL.requisition_header_id
2811: AND PRL.double_check_flag = 'Y'))
2812: OR

Line 2874: UPDATE po_purge_req_list PPRL

2870: -- is not in the po purge list
2871: -- SQL Why: If PO and REQ are linked, either both of them are purged or
2872: -- none of them are purged
2873:
2874: UPDATE po_purge_req_list PPRL
2875: SET PPRL.double_check_flag = 'N'
2876: WHERE PPRL.double_check_flag = 'Y'
2877: AND EXISTS (
2878: 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 3107: DELETE FROM po_purge_req_list

3103: END IF;
3104:
3105: x_return_status := FND_API.G_RET_STS_SUCCESS;
3106:
3107: DELETE FROM po_purge_req_list
3108: WHERE double_check_flag = 'N';
3109:
3110: IF (g_fnd_debug = 'Y') THEN
3111: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 3166: --Modifies: po_purge_req_list

3162: -----------------------------------------------------------------------
3163: --Start of Comments
3164: --Name: confirm_simple_req
3165: --Pre-reqs:
3166: --Modifies: po_purge_req_list
3167: --Locks:
3168: -- None
3169: --Function:
3170: -- Exclude req records from the purge list that have been updated recently

Line 3220: UPDATE po_purge_req_list PPRL

3216: -- SQL Why: At Confirmation Stage, we need to make sure that all the
3217: -- remaining records in the purge list are still eligible for
3218: -- purging
3219:
3220: UPDATE po_purge_req_list PPRL
3221: SET double_check_flag = 'N'
3222: WHERE double_check_flag = 'Y'
3223: AND NOT EXISTS (
3224: SELECT NULL

Line 3507: UPDATE po_purge_req_list PPRL

3503: -- rather than including records that are eligible
3504: -- SQL Why: At Confirmation Stage, we need to make sure that all the
3505: -- remaining records in the purge list are still eligible for
3506: -- purging
3507: UPDATE po_purge_req_list PPRL
3508: SET double_check_flag = 'N'
3509: WHERE double_check_flag = 'Y'
3510: AND NOT EXISTS (
3511: SELECT NULL

Line 3654: FROM po_purge_req_list PPRL

3650: SELECT NVL ( MIN (PPRL.requisition_header_id), -1 ),
3651: NVL ( MAX (PPRL.requisition_header_id), -1 )
3652: INTO x_lower_limit,
3653: x_upper_limit
3654: FROM po_purge_req_list PPRL
3655: WHERE PPRL.double_check_flag = 'Y';
3656:
3657: ELSIF (p_category = 'PO') THEN
3658: l_progress := '020';

Line 3854: FROM po_purge_req_list PRL,

3850: RL.amount)),
3851: PAPF.full_name,
3852: p_purge_name,
3853: RH.org_id -- bug5446437
3854: FROM po_purge_req_list PRL,
3855: per_all_people_f PAPF,
3856: po_requisition_headers RH,
3857: po_requisition_lines RL
3858: WHERE PRL.requisition_header_id = RH.requisition_header_id

Line 4435: --SQL What: This cursor will divide po_purge_req_list into groups of

4431: IF (p_req_lower_limit = -1) THEN
4432: RETURN;
4433: END IF;
4434:
4435: --SQL What: This cursor will divide po_purge_req_list into groups of
4436: -- records with size p_range_size. Each fetch will return the
4437: -- highest req id of that group
4438: --SQL Why: We want to delete data in smaller groups to avoid running
4439: -- out of rollback segments

Line 4445: FROM po_purge_req_list PPRL

4441: SELECT PPRL2.req_header_id
4442: BULK COLLECT INTO l_ids_tbl
4443: FROM (SELECT PPRL.requisition_header_id req_header_id,
4444: MOD(ROWNUM, p_range_size) mod_result
4445: FROM po_purge_req_list PPRL
4446: WHERE PPRL.double_check_flag = 'Y'
4447: ORDER BY PPRL.requisition_header_id) PPRL2
4448: WHERE PPRL2.mod_result = 0;
4449:

Line 4494: FROM po_purge_req_list PPRL

4490: DELETE
4491: FROM po_requisition_headers RH
4492: WHERE EXISTS (
4493: SELECT NULL
4494: FROM po_purge_req_list PPRL
4495: WHERE PPRL.requisition_header_id =
4496: RH.requisition_header_id
4497: AND PPRL.double_check_flag = 'Y'
4498: AND PPRL.requisition_header_id BETWEEN l_range_low

Line 4518: FROM po_purge_req_list PPRL,

4514: DELETE
4515: FROM po_req_distributions RD
4516: WHERE EXISTS (
4517: SELECT NULL
4518: FROM po_purge_req_list PPRL,
4519: po_requisition_lines RL
4520: WHERE PPRL.requisition_header_id =
4521: RL.requisition_header_id
4522: AND RL.requisition_line_id =

Line 4545: FROM po_purge_req_list PPRL

4541: DELETE
4542: FROM po_requisition_lines RL
4543: WHERE EXISTS (
4544: SELECT NULL
4545: FROM po_purge_req_list PPRL
4546: WHERE PPRL.requisition_header_id =
4547: RL.requisition_header_id
4548: AND PPRL.double_check_flag = 'Y'
4549: AND PPRL.requisition_header_id BETWEEN l_range_low

Line 4569: FROM po_purge_req_list PPRL

4565: FROM po_action_history PA
4566: WHERE PA.object_type_code = 'REQUISITION'
4567: AND EXISTS (
4568: SELECT NULL
4569: FROM po_purge_req_list PPRL
4570: WHERE PPRL.requisition_header_id = PA.object_id
4571: AND PPRL.double_check_flag = 'Y'
4572: AND PPRL.requisition_header_id BETWEEN l_range_low
4573: AND l_range_high);