[Home] [Help]
38: ) IS
39:
40: l_curr_calling_sequence VARCHAR2(2000);
41: l_pay_mat_count NUMBER;
42: l_when_to_account_gain_loss ap_system_parameters_all.when_to_account_gain_loss%TYPE;
43:
44: -- Logging Infra:
45: l_procedure_name CONSTANT VARCHAR2(30) := 'Update_Gain_Loss_Ind';
46: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
158: AND APH1.Transaction_Type = 'PAYMENT MATURITY';
159:
160: SELECT ASP.when_to_account_gain_loss
161: INTO l_when_to_account_gain_loss
162: FROM ap_system_parameters_all ASP
163: , AP_Payment_History_All APH
164: WHERE APH.org_id = ASP.org_id
165: AND APH.Payment_History_Id = p_pay_hist_rec.payment_history_id;
166:
197: -- commented for the bug 13257091 and the select statement moved to above
198:
199: /* SELECT ASP.when_to_account_gain_loss
200: INTO l_when_to_account_gain_loss
201: FROM ap_system_parameters_all ASP
202: , AP_Payment_History_All APH
203: WHERE APH.org_id = ASP.org_id
204: AND APH.Payment_History_Id = p_pay_hist_rec.payment_history_id;
205: */
349: CURSOR c_sum_per_event(p_acct_event_id NUMBER) IS
350: SELECT SUM(amount), count(1)
351: FROM ap_invoice_distributions_all aid,
352: xla_events evnt,
353: ap_system_parameters_all asp
354: WHERE aid.accounting_event_id = p_acct_event_id
355: AND aid.accounting_event_id = evnt.event_id
356: AND evnt.event_type_code in ('INVOICE ADJUSTED', 'CREDIT MEMO ADJUSTED',
357: 'DEBIT MEMO ADJUSTED','PREPAYMENT ADJUSTED') --7630203 12731687
586: -- commenting below for bug10183934
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'
683: --FROM AP_Invoice_Payments_All AIP
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'
877: FROM (SELECT AID.Invoice_Distribution_ID
878: FROM AP_Invoice_Distributions_All AID,
879: Financials_System_Params_All FSP,
880: AP_Invoices_All AI,
881: AP_System_Parameters_All ASP
882: WHERE AID.Invoice_ID = l_inv_rec.Invoice_ID
883: AND AI.Invoice_ID = AID.Invoice_ID
884: AND ASP.Org_ID = AI.Org_ID
885: AND AID.Line_Type_Lookup_Code NOT IN ('PREPAY', 'ERV', 'TERV'
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'
5075: AND XAH.application_id = 200
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
5115: AND aph.posted_flag = 'Y'
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 =
5185: DECODE(l_transaction_type,
5664: APH.Transaction_Type Transaction_Type,
5665: AEL.Accounting_Class_Code Accounting_Class_Code,
5666: xte_inv.entity_id aid_Entity_id
5667: FROM AP_Checks_All AC,
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,
5782: APH.Transaction_Type Transaction_Type,
5783: AEL.Accounting_Class_Code Accounting_Class_Code,
5784: xte_inv.entity_id aid_Entity_id --- changed for bug#7293021
5785: FROM AP_Checks_All AC,
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,
6097: APH.Transaction_Type Transaction_Type,
6098: AEL.Accounting_Class_Code Accounting_Class_Code,
6099: xte_inv.entity_id aid_Entity_id
6100: FROM AP_Checks_All AC,
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,
6195: APH.Transaction_Type Transaction_Type,
6196: AEL.Accounting_Class_Code Accounting_Class_Code,
6197: xte_inv.entity_id AID_Entity_id --- changed for bug#7293021
6198: FROM AP_Checks_All AC,
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,
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
6295: AND xh.application_id = 200