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_CONTROL_ACTION_VALIDATIONS dependencies on PO_RELEASES

Line 161: -- shipmentid in case of document type= PO/Releases and subtype=Planned/

157: -- char5 - process_entity_flag
158: -- date1 - entity_action_date
159: -- index_num1 - lowestentityid
160: --lowestentityid :
161: -- shipmentid in case of document type= PO/Releases and subtype=Planned/
162: -- Standard at any entity level
163: -- Lineid in case of BPA and GBPA at any entity level
164: -- Headerid in case of CPA
165: INSERT INTO PO_ONLINE_REPORT_TEXT

Line 322: -- shipmentid in case of document type= PO/Releases and

318: --char5 - process_entity_flag
319: --date1 - entity_action_date
320: --index_num1 - lowestentityid
321: --lowestentityid :
322: -- shipmentid in case of document type= PO/Releases and
323: -- subtype= Planned/Standard at any entity level
324: -- Lineid in case of BPA and GBPA at any entity level
325: -- Headerid in case of CPA
326:

Line 481: -- shipmentid in case of document type= PO/Releases and

477: --char5 - process_entity_flag
478: --date1 - entity_action_date
479: --index_num1 - lowestentityid
480: --lowestentityid :
481: -- shipmentid in case of document type= PO/Releases and
482: -- subtype= Planned/Standard at any entity level
483: -- Lineid in case of BPA and GBPA at any entity level
484: -- Headerid in case of CPA
485:

Line 687: -- shipmentid in case of document type= PO/Releases and

683: --char5 - process_entity_flag
684: --date1 - entity_action_date
685: --index_num1 - lowestentityid
686: --lowestentityid :
687: -- shipmentid in case of document type= PO/Releases and
688: -- subtype= Planned/Standard at any entity level
689: -- Lineid in case of BPA and GBPA at any entity level
690: -- Headerid in case of CPA
691:

Line 854: -- shipmentid in case of document type= PO/Releases and

850: --char5 - process_entity_flag
851: --date1 - entity_action_date
852: --index_num1 - lowestentityid
853: --lowestentityid :
854: -- shipmentid in case of document type= PO/Releases and
855: -- subtype= Planned/Standard at any entity level
856: -- Lineid in case of BPA and GBPA at any entity level
857: -- Headerid in case of CPA
858:

Line 1044: -- shipmentid in case of document type= PO/Releases and

1040: --char5 - process_entity_flag
1041: --date1 - entity_action_date
1042: --index_num1 - lowestentityid
1043: --lowestentityid :
1044: -- shipmentid in case of document type= PO/Releases and
1045: -- subtype= Planned/Standard at any entity level
1046: -- Lineid in case of BPA and GBPA at any entity level
1047: -- Headerid in case of CPA
1048:

Line 1214: -- shipmentid in case of document type= PO/Releases and

1210: --char5 - process_entity_flag
1211: --date1 - entity_action_date
1212: --index_num1 - lowestentityid
1213: --lowestentityid :
1214: -- shipmentid in case of document type= PO/Releases and
1215: -- subtype= Planned/Standard at any entity level
1216: -- Lineid in case of BPA and GBPA at any entity level
1217: -- Headerid in case of CPA
1218:

Line 1385: -- shipmentid in case of document type= PO/Releases and

1381: --char5 - process_entity_flag
1382: --date1 - entity_action_date
1383: --index_num1 - lowestentityid
1384: --lowestentityid :
1385: -- shipmentid in case of document type= PO/Releases and
1386: -- subtype= Planned/Standard at any entity level
1387: -- Lineid in case of BPA and GBPA at any entity level
1388: -- Headerid in case of CPA
1389:

Line 1563: -- shipmentid in case of document type= PO/Releases and

1559: -- char5 - process_entity_flag
1560: -- date1 - entity_action_date
1561: -- index_num1 - lowestentityid
1562: --lowestentityid :
1563: -- shipmentid in case of document type= PO/Releases and
1564: -- subtype= Planned/Standard at any entity level
1565: -- Lineid in case of BPA and GBPA at any entity level
1566: -- Headerid in case of CPA
1567:

Line 1767: -- shipmentid in case of document type= PO/Releases and

1763: -- char5 - process_entity_flag
1764: -- date1 - entity_action_date
1765: -- index_num1 - lowestentityid
1766: --lowestentityid :
1767: -- shipmentid in case of document type= PO/Releases and
1768: -- subtype= Planned/Standard at any entity level
1769: -- Lineid in case of BPA and GBPA at any entity level
1770: -- Headerid in case of CPA
1771:

Line 1963: -- shipmentid in case of document type= PO/Releases and

1959: -- char5 - process_entity_flag
1960: -- date1 - entity_action_date
1961: -- index_num1 - lowestentityid
1962: --lowestentityid :
1963: -- shipmentid in case of document type= PO/Releases and
1964: -- subtype= Planned/Standard at any entity level
1965: -- Lineid in case of BPA and GBPA at any entity level
1966: -- Headerid in case of CPA
1967:

Line 2162: -- shipmentid in case of document type= PO/Releases and

2158: -- char5 - process_entity_flag
2159: -- date1 - entity_action_date
2160: -- index_num1 - lowestentityid
2161: --lowestentityid :
2162: -- shipmentid in case of document type= PO/Releases and
2163: -- subtype= Planned/Standard at any entity level
2164: -- Lineid in case of BPA and GBPA at any entity level
2165: -- Headerid in case of CPA
2166:

Line 2331: -- shipmentid in case of document type= PO/Releases and

2327: -- char5 - process_entity_flag
2328: -- date1 - entity_action_date
2329: -- index_num1 - lowestentityid
2330: --lowestentityid :
2331: -- shipmentid in case of document type= PO/Releases and
2332: -- subtype= Planned/Standard at any entity level
2333: -- Lineid in case of BPA and GBPA at any entity level
2334: -- Headerid in case of CPA
2335:

Line 2488: -- shipmentid in case of document type= PO/Releases and

2484: -- char5 - process_entity_flag
2485: -- date1 - entity_action_date
2486: -- index_num1 - lowestentityid
2487: --lowestentityid :
2488: -- shipmentid in case of document type= PO/Releases and
2489: -- subtype= Planned/Standard at any entity level
2490: -- Lineid in case of BPA and GBPA at any entity level
2491: -- Headerid in case of CPA
2492:

Line 2649: -- shipmentid in case of document type= PO/Releases and

2645: -- char5 - process_entity_flag
2646: -- date1 - entity_action_date
2647: -- index_num1 - lowestentityid
2648: --lowestentityid :
2649: -- shipmentid in case of document type= PO/Releases and
2650: -- subtype= Planned/Standard at any entity level
2651: -- Lineid in case of BPA and GBPA at any entity level
2652: -- Headerid in case of CPA
2653:

Line 2817: -- shipmentid in case of document type= PO/Releases and

2813: -- char5 - process_entity_flag
2814: -- date1 - entity_action_date
2815: -- index_num1 - lowestentityid
2816: --lowestentityid :
2817: -- shipmentid in case of document type= PO/Releases and
2818: -- subtype= Planned/Standard at any entity level
2819: -- Lineid in case of BPA and GBPA at any entity level
2820: -- Headerid in case of CPA
2821:

Line 2982: -- shipmentid in case of document type= PO/Releases and

2978: -- char5 - process_entity_flag
2979: -- date1 - entity_action_date
2980: -- index_num1 - lowestentityid
2981: --lowestentityid :
2982: -- shipmentid in case of document type= PO/Releases and
2983: -- subtype= Planned/Standard at any entity level
2984: -- Lineid in case of BPA and GBPA at any entity level
2985: -- Headerid in case of CPA
2986:

Line 3138: -- shipmentid in case of document type= PO/Releases and

3134: -- char5 - process_entity_flag
3135: -- date1 - entity_action_date
3136: -- index_num1 - lowestentityid
3137: -- lowestentityid :
3138: -- shipmentid in case of document type= PO/Releases and
3139: -- subtype= Planned/Standard at any entity level
3140: -- Lineid in case of BPA and GBPA at any entity level
3141: -- Headerid in case of CPA
3142:

Line 3193: FROM po_releases por

3189: AND nvl(PLL.cancel_flag,'N') = 'N'
3190: AND nvl(PLL.closed_code, 'OPEN') <> 'FINALLY CLOSED'
3191: UNION
3192: SELECT 'Uncancelled Releases Exist'
3193: FROM po_releases por
3194: WHERE POR.po_header_id = pol.po_header_id
3195: -- bug 16590732: Do this check if it is Header level cancel
3196: AND gt.char3 = po_document_cancel_pvt.c_entity_level_header
3197: AND nvl(POR.cancel_flag,'N') = 'N'

Line 3253: FROM po_releases por

3249: AND nvl(PLL.cancel_flag,'N') = 'N'
3250: AND nvl(PLL.closed_code, 'OPEN') <> 'FINALLY CLOSED'
3251: UNION
3252: SELECT 'Uncancelled Releases Exist'
3253: FROM po_releases por
3254: WHERE POR.po_header_id = pol.po_header_id
3255: -- bug 16590732: Do this check if it is Header level cancel
3256: AND gt.char3 = po_document_cancel_pvt.c_entity_level_header
3257: AND nvl(POR.cancel_flag,'N') = 'N'

Line 3359: -- shipmentid in case of document type= PO/Releases and

3355: -- char5 - process_entity_flag
3356: -- date1 - entity_action_date
3357: -- index_num1 - lowestentityid
3358: --lowestentityid :
3359: -- shipmentid in case of document type= PO/Releases and
3360: -- subtype= Planned/Standard at any entity level
3361: -- Lineid in case of BPA and GBPA at any entity level
3362: -- Headerid in case of CPA
3363:

Line 3528: -- * shipments in case of document type= PO/Releases and subtype= Planned/Standard

3524: -- Function:
3525: -- Cancel action be performed at any of the three levels[Header/Line/Shipment]
3526: -- for a docuemnt
3527: -- But All Business Rules Valdiations are with the :
3528: -- * shipments in case of document type= PO/Releases and subtype= Planned/Standard
3529: -- * Lines in case of BPA and GBPA
3530: -- * Header in case of CPA
3531: -- Ex: On cancelling a PO Header, all its shipments are validated against
3532: -- the business rules,similarly, if we cancel a PO line, all its shipments

Line 3640: FROM po_releases por,

3636: Decode (
3637: pgt.char1,
3638: po_document_cancel_pvt.c_doc_type_RELEASE,
3639: (SELECT poh.segment1||'-'|| por.release_num
3640: FROM po_releases por,
3641: po_headers poh
3642: WHERE por.po_release_id=poll.po_release_id
3643: AND por.po_header_id=poh.po_header_id),
3644: (SELECT segment1

Line 4538: po_releases prh,

4534: 'DOC_NUM',gt.char6),
4535: gt.num1,
4536: gt.char3
4537: FROM
4538: po_releases prh,
4539: po_session_gt gt
4540: WHERE gt.key=p_key
4541: AND prh.po_release_id = gt.char4
4542: AND gt.char1 = po_document_cancel_pvt.c_doc_type_RELEASE

Line 4838: FROM po_releases por,

4834: 'DOC_NUM',
4835: Decode(p_entity_rec_tbl(i).document_type,
4836: po_document_cancel_pvt.c_doc_type_RELEASE,
4837: (SELECT poh.segment1||'-'|| por.release_num
4838: FROM po_releases por,
4839: po_headers poh
4840: WHERE por.po_release_id=p_entity_rec_tbl(i).doc_id
4841: AND por.po_header_id=poh.po_header_id),
4842: (SELECT segment1

Line 5126: -- shipmentid in case of document type= PO/Releases and

5122: --char5 - process_entity_flag
5123: --date1 - entity_action_date
5124: --index_num1 - lowestentityid
5125: --lowestentityid :
5126: -- shipmentid in case of document type= PO/Releases and
5127: -- subtype= Planned/Standard at any entity level
5128: -- Lineid in case of BPA and GBPA at any entity level
5129: -- Headerid in case of CPA
5130:

Line 5418: -- shipmentid in case of document type= PO/Releases and

5414: --char5 - process_entity_flag
5415: --date1 - entity_action_date
5416: --index_num1 - lowestentityid
5417: --lowestentityid :
5418: -- shipmentid in case of document type= PO/Releases and
5419: -- subtype= Planned/Standard at any entity level
5420: -- Lineid in case of BPA and GBPA at any entity level
5421: -- Headerid in case of CPA
5422:

Line 5748: -- valid po_header_id/po_release_id in po_headers/po_releases

5744: -- valid line_location_id in po_line_locations
5745: -- - If the entity level is LINE, then the entity_id should a
5746: -- valid po_line_id in po_lines
5747: -- - If the entity level is HEADER, then the entity_id should a
5748: -- valid po_header_id/po_release_id in po_headers/po_releases
5749: -- 2. Validate the parameter doc_id
5750: -- - doc_id should always be po_header_id
5751: -- 3. Validate doc_type and doc_subtype combination
5752: -- ex: doc_type=PO and doc_subtype=STANADARD/PLANNED is valid

Line 6009: -- then the entity_id should a valid po_release_id in po_releases

6005: p_sequence := P_SEQUENCE + SQL%ROWCOUNT;
6006: l_progress := '005';
6007:
6008: -- Validate : If the entity level is HEADER and docuemnt type is RELEASE,
6009: -- then the entity_id should a valid po_release_id in po_releases
6010: INSERT INTO PO_ONLINE_REPORT_TEXT(
6011: ONLINE_REPORT_ID,
6012: LAST_UPDATE_LOGIN,
6013: LAST_UPDATED_BY,

Line 6047: FROM po_releases poh

6043: WHERE gt.key=p_key
6044: AND gt.char3 =po_document_cancel_pvt.c_entity_level_HEADER
6045: AND gt.char1 =po_document_cancel_pvt.c_doc_type_RELEASE
6046: AND NOT EXISTS (SELECT '1'
6047: FROM po_releases poh
6048: WHERE poh.po_release_id = gt.num1 ));
6049:
6050:
6051:

Line 6056: -- or valid po_release_id in po_releases

6052: p_sequence := P_SEQUENCE + SQL%ROWCOUNT;
6053: l_progress := '006';
6054:
6055: -- Validate :doc_id parametr should be a valid po_header_id in po_headers
6056: -- or valid po_release_id in po_releases
6057:
6058: INSERT INTO PO_ONLINE_REPORT_TEXT(
6059: ONLINE_REPORT_ID,
6060: LAST_UPDATE_LOGIN,

Line 6098: FROM po_releases prh

6094: FROM po_headers poh
6095: WHERE poh.po_header_id = gt.char4
6096: UNION ALL
6097: SELECT '1'
6098: FROM po_releases prh
6099: WHERE prh.po_release_id = gt.char4));--validate doc_id
6100:
6101:
6102: p_sequence := P_SEQUENCE + SQL%ROWCOUNT;

Line 6206: -- valid po_header_id/po_release_id in po_headers/po_releases

6202: -- valid line_location_id in po_line_locations
6203: -- - If the entity level is LINE, then the entity_id should a valid
6204: -- po_line_id in po_lines
6205: -- - If the entity level is HEADER, then the entity_id should a
6206: -- valid po_header_id/po_release_id in po_headers/po_releases
6207: -- 2. Validate the parameter doc_id
6208: -- - doc_id should always be po_header_id
6209: -- 3. Validate doc_type and doc_subtype combination
6210: -- ex: doc_type=PO and doc_subtype=STANADARD/PLANNED is valid