[Home] [Help]
1471: CURSOR get_podetails Is
1472: SELECT 'PO'
1473: ,po_header_id
1474: ,po_distribution_id
1475: FROM po_distributions_all pod
1476: WHERE pod.req_distribution_id = p_req_distribution_id ;
1477:
1478: CURSOR c_req_raw_burden IS
1479: SELECT parent_bc_packet_id
1593: l_cc_found_flag VARCHAR2(1) := 'N';
1594: l_return_flag VARCHAR2(1) := 'N';
1595: l_cc_det_pf_line_id varchar2(30); --Bug 6393954 changed from number to varchar2
1596: L_PARENT_BC_PACKET_ID PA_BC_PACKETS.PARENT_BC_PACKET_ID%TYPE;
1597: L_CC_HEADER_ID varchar2(30); --Bug 6393954 changed from PO_DISTRIBUTIONS_ALL.PO_HEADER_ID%TYPE
1599: L_CC_DISTRIBUTION_ID NUMBER;
1600:
1601: -- this cursor checks whehter the AP is based on Purchase Order if so then
1594: l_return_flag VARCHAR2(1) := 'N';
1595: l_cc_det_pf_line_id varchar2(30); --Bug 6393954 changed from number to varchar2
1596: L_PARENT_BC_PACKET_ID PA_BC_PACKETS.PARENT_BC_PACKET_ID%TYPE;
1597: L_CC_HEADER_ID varchar2(30); --Bug 6393954 changed from PO_DISTRIBUTIONS_ALL.PO_HEADER_ID%TYPE
1598: L_PO_DESTINATION_TYPE PO_DISTRIBUTIONS_ALL.DESTINATION_TYPE_CODE%TYPE;
1599: L_CC_DISTRIBUTION_ID NUMBER;
1600:
1601: -- this cursor checks whehter the AP is based on Purchase Order if so then
1602: -- take the calculated burden amount from pa_bc_commitments table
1603: CURSOR po_cur is
1604: SELECT po.req_header_reference_num
1605: ,po.req_line_reference_num
1606: ,po.destination_type_code
1607: FROM po_distributions_all po
1608: WHERE po.po_distribution_id = p_po_distribution_id;
1609:
1610: -- Added for 13903042
1611: CURSOR cc_cur (p_det_pf_line_id NUMBER) IS
1856: (SELECT encumbrance_type_id
1857: FROM gl_encumbrance_types
1858: WHERE encumbrance_type_KEY = 'Obligation') po_encumbrance_type_id ,
1859: po.rate -- Bug 5665232
1860: FROM po_distributions_all po
1861: WHERE po.po_distribution_id = p_po_distribution_id;
1862:
1863:
1864: CURSOR c_po_dist_type (p_po_header_id NUMBER,
2083: po.po_line_id,
2084: po.po_distribution_id,
2085: po.org_id) cwk_po_flag,
2086: NVL(po.accrue_on_receipt_flag,'N') accrue_on_receipt_flag
2087: FROM po_distributions_all po
2088: WHERE po.po_distribution_id = p_po_distribution_id;
2089:
2090: BEGIN
2091:
2693: AND porl.requisition_line_id = pobc.line_id
2694: AND pobc.distribution_type = 'REQUISITION'
2695: UNION ALL
2696: SELECT 1
2697: FROM po_distributions_all pord
2698: WHERE nvl(pord.DESTINATION_TYPE_CODE,'EXPENSE') = 'EXPENSE'
2699: AND pord.po_distribution_id = pobc.distribution_id
2700: AND pobc.distribution_type <> 'REQUISITION' )
2701: /** Bug fix : 2347699 added this check to make sure that project is not cross charged **/
2759: -- Bug 5533290 : AP TAX Distribution matched to CWK PO will be fundschecked only for the
2760: -- the variance amount.Even tough AP TAX is eligible for interface to projects,the commitment amount
2761: -- will remain with PO and during interface will be relieved from PO bucket
2762: AND NOT EXISTS ( SELECT 1
2763: FROM po_distributions_all pod
2764: WHERE pod.po_distribution_id = apd.po_distribution_id
2765: AND apd.po_distribution_id IS NOT NULL
2766: AND ((NVL(pod.accrue_on_receipt_flag,'N') = 'Y' -- Bug 5348212
2767: AND apd.line_type_lookup_code IN ('ITEM','ACCRUAL','NONREC_TAX'))
2819: WHERE apd.line_type_lookup_code IN ('PREPAY','NONREC_TAX')
2820: AND apd.prepay_distribution_id IS NOT NULL
2821: AND apd.po_distribution_id IS NOT NULL)
2822: AND NOT EXISTS ( SELECT 1
2823: FROM po_distributions_all pod
2824: WHERE pod.po_distribution_id = apd.po_distribution_id
2825: AND apd.po_distribution_id IS NOT NULL
2826: AND ((NVL(pod.accrue_on_receipt_flag,'N') = 'Y'
2827: AND apd.line_type_lookup_code IN ('ITEM','ACCRUAL','NONREC_TAX'))
3003: ,AID.invoice_distribution_id aid_invoice_dist_id
3004: ,AID.parent_reversal_id aid_parent_reversal_id
3005: ,AID.po_distribution_id po_distribution_id
3006: ,AID.invoice_id bus_flow_inv_id
3007: ,Decode (IGC.CC_LINE, null, 'PO_DISTRIBUTIONS_ALL', IGC.CC_DIST_TYPE) Bus_Flow_PO_Dist_Type
3008: ,Decode (IGC.CC_LINE, null, Decode (pod.po_release_id, NULL, 'PURCHASE_ORDER', 'RELEASE') , IGC.CC_ENTITY_CODE) Bus_Flow_PO_Entity_Code
3009: ,Decode (IGC.CC_LINE, null, Decode (pod.po_release_id, NULL, pod.po_header_id,pod.po_release_id)
3010: ,IGC.cc_doc_id) Bus_Flow_PO_Doc_Id
3011: ,AID.project_id aid_project_id
3022: - NVL(AID.quantity_variance,0) encumbrance_amount
3023: ,AID.CHARGE_APPLICABLE_TO_DIST_ID charge_applicable_to_dist_id
3024: ,'N' self_assessed_tax_flag
3025: FROM AP_INVOICE_DISTRIBUTIONS_ALL AID,
3026: PO_DISTRIBUTIONS_ALL POD,
3027: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
3028: IGC_CC_SLA_BFLOW_PRIOR_V IGC,
3029: ap_system_parameters_all ASP
3030: WHERE nvl(AID.posted_flag,'N') <> 'Y'
3045: ,AID.invoice_distribution_id aid_invoice_dist_id
3046: ,AID.parent_reversal_id aid_parent_reversal_id
3047: ,AID.po_distribution_id po_distribution_id
3048: ,AID.invoice_id bus_flow_inv_id
3049: ,Decode (IGC.CC_LINE, null, 'PO_DISTRIBUTIONS_ALL', IGC.CC_DIST_TYPE) Bus_Flow_PO_Dist_Type
3050: ,Decode (IGC.CC_LINE, null, Decode (pod.po_release_id, NULL, 'PURCHASE_ORDER', 'RELEASE') , IGC.CC_ENTITY_CODE) Bus_Flow_PO_Entity_Code
3051: ,Decode (IGC.CC_LINE, null, Decode (pod.po_release_id, NULL, pod.po_header_id,pod.po_release_id)
3052: ,IGC.cc_doc_id) Bus_Flow_PO_Doc_Id
3053: ,AID.project_id aid_project_id
3064: - NVL(AID.quantity_variance,0) encumbrance_amount
3065: ,AID.CHARGE_APPLICABLE_TO_DIST_ID charge_applicable_to_dist_id
3066: ,AID.self_assessed_flag self_assessed_tax_flag
3067: FROM AP_SELF_ASSESSED_TAX_DIST_ALL AID,
3068: PO_DISTRIBUTIONS_ALL POD,
3069: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
3070: IGC_CC_SLA_BFLOW_PRIOR_V IGC,
3071: ap_system_parameters_all ASP
3072: WHERE nvl(AID.posted_flag,'N') <> 'Y'