eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_ACCTG_PAY_DIST_PKG dependencies on AP_PAYMENT_HISTORY_ALL

Line 72: UPDATE AP_Payment_History_All APH

68: P_XLA_Event_Rec.Event_Type_Code;
69: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
70: END IF;
71:
72: UPDATE AP_Payment_History_All APH
73: SET Gain_Loss_Indicator =
74: (SELECT DECODE(SIGN(SUM(APHD.Invoice_Dist_Base_Amount - APHD.Paid_Base_Amount)),
75: 1, 'G', -1, 'L', NULL)
76: FROM AP_Payment_Hist_Dists APHD

Line 98: UPDATE AP_Payment_History_All APH

94: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
95: END IF;
96:
97:
98: UPDATE AP_Payment_History_All APH
99: SET Gain_Loss_Indicator =
100: (SELECT DECODE(SIGN(SUM(APHD.Invoice_Dist_Base_Amount - APHD.Paid_Base_Amount)),
101: 1, 'G', -1, 'L', NULL)
102: FROM AP_Payment_Hist_Dists APHD

Line 119: UPDATE AP_Payment_History_All APH

115: P_XLA_Event_Rec.Event_ID;
116: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
117: END IF;
118:
119: UPDATE AP_Payment_History_All APH
120: SET Gain_Loss_Indicator =
121: (SELECT DECODE(SIGN(SUM(APHD.Paid_Base_Amount - APHD.Matured_Base_Amount)),
122: 1, 'G', -1, 'L', NULL)
123: FROM AP_Payment_Hist_Dists APHD

Line 139: FROM AP_Payment_History_All APH,

135: END IF;
136:
137: SELECT count(*)
138: INTO l_pay_mat_count
139: FROM AP_Payment_History_All APH,
140: AP_Payment_History_All APH1
141: WHERE APH.Payment_History_Id = p_pay_hist_rec.payment_history_id
142: AND APH.Check_ID = APH1.Check_ID
143: AND APH.Transaction_Type IN ('PAYMENT CLEARING', 'PAYMENT CLEARING ADJUSTED')

Line 140: AP_Payment_History_All APH1

136:
137: SELECT count(*)
138: INTO l_pay_mat_count
139: FROM AP_Payment_History_All APH,
140: AP_Payment_History_All APH1
141: WHERE APH.Payment_History_Id = p_pay_hist_rec.payment_history_id
142: AND APH.Check_ID = APH1.Check_ID
143: AND APH.Transaction_Type IN ('PAYMENT CLEARING', 'PAYMENT CLEARING ADJUSTED')
144: AND APH1.Transaction_Type = 'PAYMENT MATURITY';

Line 153: UPDATE AP_Payment_History_All APH

149: l_log_msg := 'Updating Gain Loss between maturity and clearing events';
150: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
151: END IF;
152:
153: UPDATE AP_Payment_History_All APH
154: SET Gain_Loss_Indicator =
155: (SELECT DECODE(SIGN(SUM(APHD.Matured_Base_Amount - APHD.Cleared_Base_Amount)),
156: 1, 'G', -1, 'L', NULL)
157: FROM AP_Payment_Hist_Dists APHD

Line 173: AP_Payment_History_All APH

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:
177: IF ( l_when_to_account_gain_loss IS NOT NULL AND

Line 186: UPDATE AP_Payment_History_All APH

182: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
183: END IF;
184:
185: -- Bug 6678474. Backing out the fix for bug 6621586 since it is incorrect.
186: UPDATE AP_Payment_History_All APH
187: SET Gain_Loss_Indicator =
188: (SELECT DECODE(SIGN(SUM(APHD.Invoice_Dist_Base_Amount - APHD.Cleared_Base_Amount)),
189: 1, 'G', -1, 'L', NULL)
190: FROM AP_Payment_Hist_Dists APHD

Line 203: UPDATE AP_Payment_History_All APH

199: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
200: END IF;
201:
202: -- Bug 6678474. Backing out the fix for bug 6621586 since it is incorrect.
203: UPDATE AP_Payment_History_All APH
204: SET Gain_Loss_Indicator =
205: (SELECT DECODE(SIGN(SUM(APHD.Paid_Base_Amount - APHD.Cleared_Base_Amount)),
206: 1, 'G', -1, 'L', NULL)
207: FROM AP_Payment_Hist_Dists APHD

Line 227: UPDATE AP_Payment_History_All APH

223: P_XLA_Event_Rec.Event_ID;
224: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
225: END IF;
226:
227: UPDATE AP_Payment_History_All APH
228: SET APH.Gain_Loss_Indicator =
229: (SELECT Gain_Loss_Indicator
230: FROM AP_Payment_History_All APH1
231: WHERE APH1.Payment_History_ID = APH.Rev_Pmt_Hist_ID)

Line 230: FROM AP_Payment_History_All APH1

226:
227: UPDATE AP_Payment_History_All APH
228: SET APH.Gain_Loss_Indicator =
229: (SELECT Gain_Loss_Indicator
230: FROM AP_Payment_History_All APH1
231: WHERE APH1.Payment_History_ID = APH.Rev_Pmt_Hist_ID)
232: WHERE APH.Payment_History_Id = p_pay_hist_rec.payment_history_id;
233:
234: END IF;

Line 359: FROM AP_Payment_History_All APH

355: INTO l_pay_history_id,
356: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
357: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
358: ap_accounting_pay_pkg.g_pmt_to_base_xrate
359: FROM AP_Payment_History_All APH
360: WHERE APH.Payment_History_ID =
361: (SELECT MAX(APH1.Payment_History_ID)
362: FROM AP_Payment_History_All APH1
363: WHERE APH1.Check_ID = p_xla_event_rec.source_id_int_1

Line 362: FROM AP_Payment_History_All APH1

358: ap_accounting_pay_pkg.g_pmt_to_base_xrate
359: FROM AP_Payment_History_All APH
360: WHERE APH.Payment_History_ID =
361: (SELECT MAX(APH1.Payment_History_ID)
362: FROM AP_Payment_History_All APH1
363: WHERE APH1.Check_ID = p_xla_event_rec.source_id_int_1
364: AND APH1.Transaction_Type IN ('PAYMENT CREATED', 'REFUND RECORDED'));
365:
366:

Line 418: FROM AP_Payment_History_All APH

414: INTO l_pay_history_id,
415: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
416: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
417: ap_accounting_pay_pkg.g_pmt_to_base_xrate
418: FROM AP_Payment_History_All APH
419: WHERE APH.Payment_History_ID =
420: (SELECT MAX(APH1.Payment_History_ID)
421: FROM AP_Payment_History_All APH1
422: WHERE APH1.Check_ID = p_xla_event_rec.source_id_int_1

Line 421: FROM AP_Payment_History_All APH1

417: ap_accounting_pay_pkg.g_pmt_to_base_xrate
418: FROM AP_Payment_History_All APH
419: WHERE APH.Payment_History_ID =
420: (SELECT MAX(APH1.Payment_History_ID)
421: FROM AP_Payment_History_All APH1
422: WHERE APH1.Check_ID = p_xla_event_rec.source_id_int_1
423: AND APH1.Transaction_Type IN ('PAYMENT CREATED', 'REFUND RECORDED'));
424:
425: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 435: FROM AP_Payment_History_All APH

431: END IF;
432:
433: SELECT MAX(APH.Payment_History_ID)
434: INTO l_mat_history_id
435: FROM AP_Payment_History_All APH
436: WHERE APH.Check_ID = p_xla_event_rec.source_id_int_1
437: AND APH.Transaction_Type IN ('PAYMENT MATURITY');
438:
439:

Line 448: FROM AP_Payment_History_All APH

444: APH.Pmt_To_Base_XRate
445: INTO ap_accounting_pay_pkg.g_mat_to_base_xrate_type,
446: ap_accounting_pay_pkg.g_mat_to_base_xrate_date,
447: ap_accounting_pay_pkg.g_mat_to_base_xrate
448: FROM AP_Payment_History_All APH
449: WHERE APH.Payment_History_ID = l_mat_history_id;
450:
451: END IF;
452:

Line 517: FROM AP_Payment_History_All

513: -- accounting.
514:
515: SELECT count(*)
516: INTO l_upg_pmt_hist
517: FROM AP_Payment_History_All
518: WHERE Check_ID = p_xla_event_rec.source_id_int_1
519: AND Historical_Flag = 'Y'
520: AND Posted_Flag = 'Y';
521:

Line 588: FROM AP_Payment_History_All APH

584: INTO l_upg_inv_pmts
585: FROM AP_Invoice_Payments_All AIP
586: WHERE Invoice_ID = l_inv_pay_rec.invoice_id
587: AND EXISTS (SELECT 'Upg Payment'
588: FROM AP_Payment_History_All APH
589: WHERE APH.Check_ID = AIP.Check_ID
590: AND APH.Historical_Flag = 'Y'
591: AND APH.Posted_Flag = 'Y'
592: AND Rownum = 1);

Line 1318: AP_Payment_History_All APH,

1314: AID.Base_Amount_Variance,
1315: AID.historical_flag, -- bug fix 6674279
1316: AID.accounting_event_id -- bug fix 6674279
1317: FROM AP_Invoice_Distributions_All AID,
1318: AP_Payment_History_All APH,
1319: AP_Payment_Hist_Dists APHD
1320: WHERE AID.Invoice_ID = P_Invoice_ID
1321: AND NVL(AID.Reversal_Flag,'N') <> 'Y'
1322: AND AID.Invoice_Distribution_ID = APHD.Invoice_Distribution_ID

Line 1388: FROM AP_Payment_History_All APH

1384: IF (P_XLA_Event_Rec.Event_Type_Code IN ('PAYMENT MATURITY ADJUSTED')) THEN
1385:
1386: SELECT MAX(APH.Payment_History_ID)
1387: INTO l_pay_history_id
1388: FROM AP_Payment_History_All APH
1389: WHERE APH.Check_ID = p_xla_event_rec.source_id_int_1
1390: AND APH.Transaction_Type IN ('PAYMENT CREATED', 'REFUND RECORDED');
1391:
1392: SELECT APH.Pmt_To_Base_XRate_Type,

Line 1398: FROM AP_Payment_History_All APH

1394: APH.Pmt_To_Base_XRate
1395: INTO ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
1396: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
1397: ap_accounting_pay_pkg.g_pmt_to_base_xrate
1398: FROM AP_Payment_History_All APH
1399: WHERE APH.Payment_History_ID = l_pay_history_id;
1400:
1401: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1402: l_log_msg := 'Payment_History_ID for payment = '|| l_pay_history_id;

Line 1427: FROM AP_Payment_History_All APH

1423: ELSIF (P_XLA_Event_Rec.Event_Type_Code IN ('PAYMENT CLEARING ADJUSTED')) THEN
1424:
1425: SELECT MAX(APH.Payment_History_ID)
1426: INTO l_pay_history_id
1427: FROM AP_Payment_History_All APH
1428: WHERE APH.Check_ID = p_xla_event_rec.source_id_int_1
1429: AND APH.Transaction_Type IN ('PAYMENT CREATED', 'REFUND RECORDED');
1430:
1431: SELECT APH.Pmt_To_Base_XRate_Type,

Line 1437: FROM AP_Payment_History_All APH

1433: APH.Pmt_To_Base_XRate
1434: INTO ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
1435: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
1436: ap_accounting_pay_pkg.g_pmt_to_base_xrate
1437: FROM AP_Payment_History_All APH
1438: WHERE APH.Payment_History_ID = l_pay_history_id;
1439:
1440: SELECT MAX(APH.Payment_History_ID)
1441: INTO l_mat_history_id

Line 1442: FROM AP_Payment_History_All APH

1438: WHERE APH.Payment_History_ID = l_pay_history_id;
1439:
1440: SELECT MAX(APH.Payment_History_ID)
1441: INTO l_mat_history_id
1442: FROM AP_Payment_History_All APH
1443: WHERE APH.Check_ID = p_xla_event_rec.source_id_int_1
1444: AND APH.Transaction_Type IN ('PAYMENT MATURITY');
1445:
1446:

Line 1455: FROM AP_Payment_History_All APH

1451: APH.Pmt_To_Base_XRate
1452: INTO ap_accounting_pay_pkg.g_mat_to_base_xrate_type,
1453: ap_accounting_pay_pkg.g_mat_to_base_xrate_date,
1454: ap_accounting_pay_pkg.g_mat_to_base_xrate
1455: FROM AP_Payment_History_All APH
1456: WHERE APH.Payment_History_ID = l_mat_history_id;
1457:
1458: END IF;
1459:

Line 1728: FROM ap_payment_history_all aph1,

1724: -- Calling rounding only once for all payment adjsument events
1725: -- for each invoice payment level.
1726:
1727: SELECT max(aph2.payment_history_id) into l_do_round
1728: FROM ap_payment_history_all aph1,
1729: ap_payment_history_all aph2
1730: WHERE aph1.payment_history_id = l_pay_hist_rec.payment_history_id
1731: AND aph2.check_id = aph1.check_id
1732: AND aph2.posted_flag <> 'Y'

Line 1729: ap_payment_history_all aph2

1725: -- for each invoice payment level.
1726:
1727: SELECT max(aph2.payment_history_id) into l_do_round
1728: FROM ap_payment_history_all aph1,
1729: ap_payment_history_all aph2
1730: WHERE aph1.payment_history_id = l_pay_hist_rec.payment_history_id
1731: AND aph2.check_id = aph1.check_id
1732: AND aph2.posted_flag <> 'Y'
1733: AND aph1.posted_flag <> 'Y'

Line 1753: AP_Payment_History_All APH

1749: l_sum_error_amount,
1750: l_sum_charge_amount
1751: FROM AP_Payment_Hist_Dists APHD,
1752: AP_Invoice_Distributions_All AID,
1753: AP_Payment_History_All APH
1754: WHERE APH.Related_Event_ID = l_pay_hist_rec.related_event_id
1755: AND APHD.Invoice_Payment_ID = l_inv_pay_rec.invoice_payment_id
1756: AND APH.Payment_History_ID = APHD.Payment_History_ID
1757: AND APHD.Invoice_Distribution_ID = AID.Invoice_Distribution_ID

Line 3790: l_transaction_type AP_PAYMENT_HISTORY_ALL.TRANSACTION_TYPE%TYPE;

3786: -- Logging Infra:
3787: l_procedure_name CONSTANT VARCHAR2(30) := 'Pay_Dist_Reverse';
3788: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3789:
3790: l_transaction_type AP_PAYMENT_HISTORY_ALL.TRANSACTION_TYPE%TYPE;
3791: l_payment_history_id AP_PAYMENT_HISTORY_ALL.PAYMENT_HISTORY_ID%TYPE;
3792: l_accounting_event_id AP_PAYMENT_HISTORY_ALL.ACCOUNTING_EVENT_ID%TYPE;
3793: l_historical_flag AP_PAYMENT_HISTORY_ALL.HISTORICAL_FLAG%TYPE;
3794:

Line 3791: l_payment_history_id AP_PAYMENT_HISTORY_ALL.PAYMENT_HISTORY_ID%TYPE;

3787: l_procedure_name CONSTANT VARCHAR2(30) := 'Pay_Dist_Reverse';
3788: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3789:
3790: l_transaction_type AP_PAYMENT_HISTORY_ALL.TRANSACTION_TYPE%TYPE;
3791: l_payment_history_id AP_PAYMENT_HISTORY_ALL.PAYMENT_HISTORY_ID%TYPE;
3792: l_accounting_event_id AP_PAYMENT_HISTORY_ALL.ACCOUNTING_EVENT_ID%TYPE;
3793: l_historical_flag AP_PAYMENT_HISTORY_ALL.HISTORICAL_FLAG%TYPE;
3794:
3795:

Line 3792: l_accounting_event_id AP_PAYMENT_HISTORY_ALL.ACCOUNTING_EVENT_ID%TYPE;

3788: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3789:
3790: l_transaction_type AP_PAYMENT_HISTORY_ALL.TRANSACTION_TYPE%TYPE;
3791: l_payment_history_id AP_PAYMENT_HISTORY_ALL.PAYMENT_HISTORY_ID%TYPE;
3792: l_accounting_event_id AP_PAYMENT_HISTORY_ALL.ACCOUNTING_EVENT_ID%TYPE;
3793: l_historical_flag AP_PAYMENT_HISTORY_ALL.HISTORICAL_FLAG%TYPE;
3794:
3795:
3796: BEGIN

Line 3793: l_historical_flag AP_PAYMENT_HISTORY_ALL.HISTORICAL_FLAG%TYPE;

3789:
3790: l_transaction_type AP_PAYMENT_HISTORY_ALL.TRANSACTION_TYPE%TYPE;
3791: l_payment_history_id AP_PAYMENT_HISTORY_ALL.PAYMENT_HISTORY_ID%TYPE;
3792: l_accounting_event_id AP_PAYMENT_HISTORY_ALL.ACCOUNTING_EVENT_ID%TYPE;
3793: l_historical_flag AP_PAYMENT_HISTORY_ALL.HISTORICAL_FLAG%TYPE;
3794:
3795:
3796: BEGIN
3797:

Line 3973: AP_Payment_History_All APH,

3969: NULL,
3970: SYSDATE,
3971: FND_GLOBAL.Conc_Request_ID
3972: FROM AP_Payment_Hist_Dists APHD,
3973: AP_Payment_History_All APH,
3974: AP_Invoice_Payments_All AIP,
3975: AP_Invoice_Distributions_All AID -- 6804379
3976: WHERE nvl(APH.Related_Event_ID, APH.Accounting_Event_ID) = p_related_event_id
3977: AND APHD.Payment_History_ID = APH.Payment_History_ID

Line 4060: AP_Payment_History_All APH -- 6804379

4056: NULL,
4057: SYSDATE,
4058: FND_GLOBAL.Conc_Request_ID
4059: FROM AP_Payment_Hist_Dists APHD,
4060: AP_Payment_History_All APH -- 6804379
4061: WHERE APH.Check_ID = p_xla_event_rec.Source_ID_Int_1 -- Bug 6856694
4062: AND NVL(APH.Related_Event_ID, APH.Accounting_Event_ID) = p_related_event_id
4063: AND APHD.Payment_History_ID = APH.Payment_History_ID
4064: AND NVL(APHD.Reversal_Flag,'N') <> 'Y'

Line 4150: AP_Payment_History_All APH

4146: NULL,
4147: SYSDATE,
4148: FND_GLOBAL.Conc_Request_ID
4149: FROM AP_Payment_Hist_Dists APHD,
4150: AP_Payment_History_All APH
4151: WHERE APHD.Invoice_Distribution_ID = p_invoice_dist_id
4152: AND APHD.Payment_History_ID = APH.Payment_History_ID
4153: AND APH.Check_ID = p_xla_event_rec.source_id_int_1 -- Bug 6887295
4154: AND APH.Related_Event_ID = p_pay_hist_rec.related_event_id;

Line 4198: FROM ap_payment_history_all APH

4194: NVL(Historical_Flag, 'N')
4195: INTO l_payment_history_id,
4196: l_accounting_event_id,
4197: l_historical_flag
4198: FROM ap_payment_history_all APH
4199: WHERE APH.Check_ID = p_xla_event_rec.source_id_int_1
4200: AND APH.Transaction_Type = l_transaction_type
4201: AND APH.Posted_Flag = 'Y';
4202:

Line 4432: ap_payment_history_all aph

4428: WHERE application_id = 200
4429: AND ae_header_id IN
4430: (SELECT ae_header_id
4431: FROM xla_ae_headers aeh,
4432: ap_payment_history_all aph
4433: WHERE aeh.event_id = aph.accounting_event_id
4434: AND aph.accounting_event_id = p_accounting_event_id
4435: AND aph.check_id = p_xla_event_rec.source_id_int_1
4436: AND aph.historical_flag = 'Y'

Line 4659: AP_Payment_History_All APH,

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,
4661: XLA_AE_Lines AEL,
4662: AP_Inv_Dists_Source AID1,
4663: AP_Invoices_All AI,

Line 4738: AP_Payment_History_All APH,

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,
4740: XLA_AE_Lines AEL,
4741: AP_Payment_Hist_Dists APHD,
4742: AP_Invoice_Distributions_All AID,