[Home] [Help]
35: ) IS
36:
37: l_curr_calling_sequence VARCHAR2(2000);
38: l_pay_mat_count NUMBER;
39: l_when_to_account_gain_loss ap_system_parameters_all.when_to_account_gain_loss%TYPE;
40:
41: -- Logging Infra:
42: l_procedure_name CONSTANT VARCHAR2(30) := 'Update_Gain_Loss_Ind';
43: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
168: --bug 5257209
169:
170: SELECT ASP.when_to_account_gain_loss
171: INTO l_when_to_account_gain_loss
172: FROM ap_system_parameters_all ASP,
173: AP_Payment_History_All APH
174: WHERE APH.org_id = ASP.org_id
175: AND APH.Payment_History_Id = p_pay_hist_rec.payment_history_id;
176:
297: CURSOR c_sum_per_event(p_acct_event_id NUMBER) IS
298: SELECT SUM(amount), count(1)
299: FROM ap_invoice_distributions_all aid,
300: xla_events evnt,
301: ap_system_parameters_all asp
302: WHERE aid.accounting_event_id = p_acct_event_id
303: AND aid.accounting_event_id = evnt.event_id
304: AND evnt.event_type_code in ('INVOICE ADJUSTED', 'CREDIT MEMO ADJUSTED',
305: 'DEBIT MEMO ADJUSTED') --7630203
4652: APH.Transaction_Type Transaction_Type,
4653: AEL.Accounting_Class_Code Accounting_Class_Code,
4654: aid_xe.entity_id aid_Entity_id
4655: FROM AP_Checks_All AC,
4656: AP_System_Parameters_All ASP,
4657: XLA_Transaction_Entities_Upg XTE,
4658: XLA_Events XLE,
4659: AP_Payment_History_All APH,
4660: XLA_AE_Headers AEH,
4731: APH.Transaction_Type Transaction_Type,
4732: AEL.Accounting_Class_Code Accounting_Class_Code,
4733: aid_xe.entity_id aid_Entity_id --- changed for bug#7293021
4734: FROM AP_Checks_All AC,
4735: AP_System_Parameters_All ASP,
4736: XLA_Transaction_Entities_Upg XTE,
4737: XLA_Events XLE,
4738: AP_Payment_History_All APH,
4739: XLA_AE_Headers AEH,