[Home] [Help]
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
166: (ONLINE_REPORT_ID,
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:
327: INSERT INTO PO_ONLINE_REPORT_TEXT(
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:
486: INSERT INTO PO_ONLINE_REPORT_TEXT(
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:
692: INSERT INTO PO_ONLINE_REPORT_TEXT(
735: AND poll.line_location_id = gt.index_num1 -- lowestentityid i.e.
736: AND poll.po_line_id = pol.po_line_id
737: AND gt.char1 <> po_document_cancel_pvt.c_doc_type_PA
738: AND pol.unit_price <> poll.price_override
739: AND poll.shipment_type in ('STANDARD','PLANNED')
740: AND po_control_action_validations.is_complex_work_po(poll.po_header_id) ='N'
741: );
742:
743: p_sequence := P_SEQUENCE + SQL%ROWCOUNT;
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:
859:
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:
1049:
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:
1219: INSERT INTO PO_ONLINE_REPORT_TEXT(
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:
1390: --Bug15869000 : At the distribution level, quantity delivered can be
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:
1568: --Bug15869000 : At the distribution level, quantity billed can be
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:
1772:
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:
1968:
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:
2167:
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:
2336:
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:
2493:
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:
2654: --Bug 15913701. p_action_date is already a date variable.
2699: WHERE gt.key=p_key
2700: AND pod.line_location_id=gt.index_num1
2701: AND POD.line_location_id = POLL.line_location_id
2702: AND POL.po_line_id = POLL.po_line_id
2703: AND POLL.shipment_type in ('STANDARD', 'PLANNED','PREPAYMENT')
2704: AND GCC.code_combination_id = POD.BUDGET_ACCOUNT_ID
2705: AND gt.char1 <> po_document_cancel_pvt.c_doc_type_PA
2706: AND fsp.purch_encumbrance_flag = 'Y'
2707: AND (GCC.enabled_flag <> 'Y' OR
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:
2822: --Bug 15913701. p_action_date is already a date variable.
2910: --Start of Comments
2911: --Name:ga_with_open_std_ref_chk
2912: --
2913: -- Function:
2914: -- Validates If GBPA has Uncancelled Open Standard PO reference,
2915: -- then the GBPA cannot be cancelled
2916:
2917: --Parameters:
2918: --IN:
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:
2987:
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:
3143: -- Bug 16174863: Add condition in the select statement for
3290: --Start of Comments
3291: --Name:cga_with_open_std_ref_chk
3292: --
3293: -- Function:
3294: -- Validates If CPA has Uncancelled Open Standard PO reference,
3295: -- then the CPA cannot be cancelled
3296:
3297: --Parameters:
3298: --IN:
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:
3364:
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
4045: p_sequence =>p_sequence,
4046: x_return_status =>x_return_status,
4047: x_msg_data =>x_msg_data);
4048:
4049: -- If GBPA has Uncancelled Open Standard PO reference,
4050: -- then the GBPA cannot be cancelled
4051: WHEN c_can_ga_with_open_std_ref THEN
4052: ga_with_open_std_ref_chk(
4053: p_online_report_id =>p_online_report_id,
4070: x_return_status =>x_return_status,
4071: x_msg_data =>x_msg_data);
4072:
4073:
4074: -- If CPA has Uncancelled Open Standard PO reference,
4075: -- then the CPA cannot be cancelled
4076: WHEN c_can_cga_with_open_std_ref THEN
4077: cga_with_open_std_ref_chk(
4078: p_online_report_id =>p_online_report_id,
4164: -- 10. If there are any ASN that have not been fully received for the
4165: -- shipments,then cancel action is not allowed on the entity
4166: -- 11. If Blanket PA/Planned PO has Uncancelled Open Releases, then the
4167: -- BPA/PPO cannot be cancelled
4168: -- 12. If GBPA has Uncancelled Open Standard PO reference, then the GBPA
4169: -- cannot be cancelled
4170: -- 12. If CPA has Uncancelled Open Standard PO reference, then the CPA
4171: -- cannot be cancelled
4172: -- 14. If there are any custom validations, until they pass, the document
4166: -- 11. If Blanket PA/Planned PO has Uncancelled Open Releases, then the
4167: -- BPA/PPO cannot be cancelled
4168: -- 12. If GBPA has Uncancelled Open Standard PO reference, then the GBPA
4169: -- cannot be cancelled
4170: -- 12. If CPA has Uncancelled Open Standard PO reference, then the CPA
4171: -- cannot be cancelled
4172: -- 14. If there are any custom validations, until they pass, the document
4173: -- can not be cancelled
4174: --
4950:
4951:
4952: BEGIN
4953:
4954: -- Start standard API initialization
4955: IF FND_API.to_boolean(p_init_msg_list) THEN
4956: FND_MSG_PUB.initialize;
4957: END IF;
4958:
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:
5131:
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:
5423:
5853: OR gt.char1 NOT IN (po_document_cancel_pvt.c_doc_type_PO,
5854: po_document_cancel_pvt.c_doc_type_PA,
5855: po_document_cancel_pvt.c_doc_type_RELEASE)
5856: OR (gt.char1=po_document_cancel_pvt.c_doc_type_PO
5857: AND gt.char2 NOT IN(po_document_cancel_pvt.c_doc_subtype_STANDARD,
5858: po_document_cancel_pvt.c_doc_subtype_PLANNED))
5859: OR (gt.char1=po_document_cancel_pvt.c_doc_type_PA
5860: AND gt.char2 NOT IN (po_document_cancel_pvt.c_doc_subtype_BLANKET,
5861: po_document_cancel_pvt.c_doc_subtype_contract))