[Home] [Help]
587: --SELECT count(*)
588: --INTO l_upg_pmt_hist
589: --FROM AP_Payment_History_All APH,
590: -- AP_System_Parameters_ALL ASP,
591: -- XLA_AE_Headers XAH
592: --WHERE APH.Check_ID = p_xla_event_rec.source_id_int_1
593: --AND APH.Historical_Flag = 'Y'
594: --AND APH.Posted_Flag = 'Y'
595: --AND APH.Org_ID = ASP.Org_ID
684: --WHERE Invoice_ID = l_inv_pay_rec.invoice_id
685: --AND EXISTS (SELECT 'Upg Payment'
686: -- FROM AP_Payment_History_All APH,
687: -- AP_System_Parameters_All ASP,
688: -- XLA_AE_Headers XAH
689: -- WHERE APH.Check_ID = AIP.Check_ID
690: -- AND APH.Historical_Flag = 'Y'
691: -- AND APH.Posted_Flag = 'Y'
692: -- AND APH.Org_id = ASP.Org_id
705: -- commented below for bug10183934
706: --SELECT count(*)
707: -- INTO l_upg_prepay_app
708: -- FROM AP_Invoice_Distributions_ALL AID,
709: -- XLA_AE_Headers XAH
710: -- WHERE AID.accounting_event_id = XAH.Event_ID
711: -- AND XAH.Application_ID = 200
712: -- AND XAH.Event_type_Code IN ('PREPAYMENT APPLIED', 'PREPAYMENT UNAPPLIED')
713: -- AND XAH.Upg_batch_ID IS NOT NULL
4669: l_payment_history_id AP_PAYMENT_HISTORY_ALL.PAYMENT_HISTORY_ID%TYPE;
4670: l_accounting_event_id AP_PAYMENT_HISTORY_ALL.ACCOUNTING_EVENT_ID%TYPE;
4671: l_historical_flag AP_PAYMENT_HISTORY_ALL.HISTORICAL_FLAG%TYPE;
4672: l_reversed_in_R12 VARCHAR2(1) := 'N';
4673: l_upg_batch_id XLA_AE_HEADERS.UPG_BATCH_ID%TYPE;
4674:
4675:
4676: BEGIN
4677:
5066: Accounting_Event_ID,
5067: NVL(Historical_Flag, 'N') Historical_Flag,
5068: XAH.upg_batch_id
5069: FROM ap_payment_history_all APH,
5070: xla_ae_headers XAH,
5071: ap_system_parameters_all ASP
5072: WHERE APH.Check_ID = p_xla_event_rec.source_id_int_1
5073: -- AND APH.rev_pmt_hist_id is null bug9448974
5074: AND APH.Posted_Flag = 'Y'
5106: FROM dual
5107: WHERE EXISTS
5108: (SELECT 'reversed in R12'
5109: FROM ap_payment_history_all aph,
5110: xla_ae_headers xah,
5111: ap_system_parameters_all asp
5112: WHERE aph.rev_pmt_hist_id = aph_events.payment_history_id
5113: AND xah.application_id = 200
5114: AND aph.accounting_event_id = xah.event_id
5176: l_accounting_event_id,
5177: l_historical_flag,
5178: l_upg_batch_id
5179: FROM ap_payment_history_all APH,
5180: xla_ae_headers XAH,
5181: ap_system_parameters_all ASP
5182: WHERE APH.Check_ID = p_xla_event_rec.source_id_int_1
5183: AND APH.Transaction_Type = l_transaction_type
5184: AND APH.payment_history_id =
5418: DELETE FROM xla_distribution_links
5419: WHERE application_id = 200
5420: AND ae_header_id IN
5421: (SELECT ae_header_id
5422: FROM xla_ae_headers aeh,
5423: ap_payment_history_all aph
5424: WHERE aeh.event_id = aph.accounting_event_id
5425: AND aph.accounting_event_id = p_accounting_event_id
5426: AND aph.check_id = p_xla_event_rec.source_id_int_1
5668: AP_System_Parameters_All ASP,
5669: XLA_Transaction_Entities_Upg XTE,
5670: XLA_Events XLE,
5671: AP_Payment_History_All APH,
5672: XLA_AE_Headers AEH,
5673: XLA_AE_Lines AEL,
5674: AP_Inv_Dists_Source AID1,
5675: AP_Invoices_All AI,
5676: AP_Invoice_Distributions_All AID,
5786: AP_System_Parameters_All ASP,
5787: XLA_Transaction_Entities_Upg XTE,
5788: XLA_Events XLE,
5789: AP_Payment_History_All APH,
5790: XLA_AE_Headers AEH,
5791: XLA_AE_Lines AEL,
5792: AP_Payment_Hist_Dists APHD,
5793: AP_Invoice_Distributions_All AID,
5794: AP_Invoices_All AI,
6101: AP_System_Parameters_All ASP,
6102: XLA_Transaction_Entities_Upg XTE,
6103: XLA_Events XLE,
6104: AP_Payment_History_All APH,
6105: XLA_AE_Headers AEH,
6106: XLA_AE_Lines AEL,
6107: AP_Inv_Dists_Source AID1,
6108: AP_Invoices_All AI,
6109: AP_Invoice_Distributions_All AID,
6199: AP_System_Parameters_All ASP,
6200: XLA_Transaction_Entities_Upg XTE,
6201: XLA_Events XLE,
6202: AP_Payment_History_All APH,
6203: XLA_AE_Headers AEH,
6204: XLA_AE_Lines AEL,
6205: AP_Payment_Hist_Dists APHD,
6206: ap_mc_invoice_dists AID_MC,
6207: AP_Invoices_All AI,
6286: aphd.invoice_dist_amount ,
6287: NVL(xdl.unrounded_entered_cr,0) - NVL(xdl.unrounded_entered_dr,0) xdl_ent_amt
6288: FROM ap_payment_hist_dists aphd,
6289: ap_payment_history_all aph,
6290: xla_ae_headers xh,
6291: ap_system_parameters_all asp,
6292: xla_distribution_links xdl
6293: WHERE aphd.payment_history_id = aph.payment_history_id
6294: AND aph.related_event_id = xh.event_id