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_HIST_DISTS

Line 76: FROM AP_Payment_Hist_Dists APHD

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
77: WHERE APHD.Payment_History_ID = APH.Payment_History_ID
78: AND APHD.Accounting_Event_ID = p_xla_event_rec.event_id
79: --AND NVL(APHD.Reversal_Flag,'N') <> 'Y' --added for bug 7244022
80: --above condition commented for bug 7445576

Line 102: FROM AP_Payment_Hist_Dists APHD

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
103: WHERE APHD.Payment_History_ID = APH.Payment_History_ID
104: AND APHD.Accounting_Event_ID = p_xla_event_rec.event_id
105: AND NVL(APHD.Reversal_Flag,'N') <> 'Y'
106: )

Line 123: FROM AP_Payment_Hist_Dists APHD

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
124: WHERE APHD.Payment_History_ID = APH.Payment_History_ID
125: AND APHD.Accounting_Event_ID = p_xla_event_rec.event_id)
126: WHERE APH.Payment_History_Id = p_pay_hist_rec.payment_history_id;
127:

Line 157: FROM AP_Payment_Hist_Dists APHD

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
158: WHERE APHD.Payment_History_ID = APH.Payment_History_ID
159: AND APHD.Accounting_Event_ID = p_xla_event_rec.event_id)
160: WHERE APH.Payment_History_Id = p_pay_hist_rec.payment_history_id;
161: ELSE

Line 190: FROM AP_Payment_Hist_Dists APHD

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
191: WHERE APHD.Payment_History_ID = APH.Payment_History_ID
192: AND APHD.Accounting_Event_ID = p_xla_event_rec.event_id)
193: WHERE APH.Payment_History_Id = p_pay_hist_rec.payment_history_id;
194:

Line 207: FROM AP_Payment_Hist_Dists APHD

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
208: WHERE APHD.Payment_History_ID = APH.Payment_History_ID
209: AND APHD.Accounting_Event_ID = p_xla_event_rec.event_id)
210: WHERE APH.Payment_History_Id = p_pay_hist_rec.payment_history_id;
211:

Line 511: -- some exchange rates in the ap_payment_hist_dists table and trying to

507: -- Bug6900582
508: -- Get the count of historical payment history records for this check.
509: -- We should not do final and total rounding for payments that have been
510: -- upgraded to R12, since during upgrade the amounts are not populated for
511: -- some exchange rates in the ap_payment_hist_dists table and trying to
512: -- calculate the rounding for such payments will result in incorrect
513: -- accounting.
514:
515: SELECT count(*)

Line 1319: AP_Payment_Hist_Dists APHD

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
1323: AND APH.Payment_History_ID = APHD.Payment_History_ID

Line 1580: FROM ap_payment_hist_dists

1576: IF l_inv_dist_rec.parent_reversal_id IS NOT NULL THEN
1577:
1578: SELECT count(*)
1579: INTO l_pay_dist_cnt
1580: FROM ap_payment_hist_dists
1581: WHERE invoice_distribution_id = l_inv_dist_rec.parent_reversal_id;
1582:
1583: END IF;
1584:

Line 1751: FROM AP_Payment_Hist_Dists APHD,

1747: INTO l_sum_paid_amount,
1748: l_sum_disc_amount,
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

Line 1768: UPDATE AP_Payment_Hist_Dists APD

1764: END IF;
1765:
1766:
1767: /* Adjust the payment amount for technical rounding */
1768: UPDATE AP_Payment_Hist_Dists APD
1769: SET APD.Amount = APD.Amount - NVL(l_sum_paid_amount,0) + l_inv_pay_rec.amount
1770: WHERE APD.Invoice_Distribution_ID =
1771: (SELECT MAX(APD1.Invoice_Distribution_ID)
1772: FROM AP_Payment_Hist_Dists APD1

Line 1772: FROM AP_Payment_Hist_Dists APD1

1768: UPDATE AP_Payment_Hist_Dists APD
1769: SET APD.Amount = APD.Amount - NVL(l_sum_paid_amount,0) + l_inv_pay_rec.amount
1770: WHERE APD.Invoice_Distribution_ID =
1771: (SELECT MAX(APD1.Invoice_Distribution_ID)
1772: FROM AP_Payment_Hist_Dists APD1
1773: WHERE APD1.Accounting_Event_ID = p_xla_event_rec.event_id
1774: AND APD1.Invoice_Payment_ID = l_inv_pay_rec.invoice_payment_id
1775: AND APD1.Pay_Dist_Lookup_Code = 'CASH'
1776: AND ABS(APD1.Amount) =

Line 1778: FROM AP_Payment_Hist_Dists APD2

1774: AND APD1.Invoice_Payment_ID = l_inv_pay_rec.invoice_payment_id
1775: AND APD1.Pay_Dist_Lookup_Code = 'CASH'
1776: AND ABS(APD1.Amount) =
1777: (SELECT MAX(APD2.Amount)
1778: FROM AP_Payment_Hist_Dists APD2
1779: WHERE APD2.Accounting_Event_ID = p_xla_event_rec.event_id
1780: AND APD2.Invoice_Payment_ID = l_inv_pay_rec.invoice_payment_id
1781: AND APD2.Pay_Dist_Lookup_Code = 'CASH'))
1782: AND APD.Pay_Dist_Lookup_Code = 'CASH'

Line 1797: UPDATE AP_Payment_Hist_Dists APD

1793: END IF;
1794:
1795:
1796: /* Adjust the discount amount for technical rounding */
1797: UPDATE AP_Payment_Hist_Dists APD
1798: SET APD.Amount = APD.Amount - NVL(l_sum_disc_amount,0)
1799: + l_inv_pay_rec.discount_taken
1800: WHERE APD.Invoice_Distribution_ID =
1801: (SELECT MAX(APD1.Invoice_Distribution_ID)

Line 1802: FROM AP_Payment_Hist_Dists APD1

1798: SET APD.Amount = APD.Amount - NVL(l_sum_disc_amount,0)
1799: + l_inv_pay_rec.discount_taken
1800: WHERE APD.Invoice_Distribution_ID =
1801: (SELECT MAX(APD1.Invoice_Distribution_ID)
1802: FROM AP_Payment_Hist_Dists APD1
1803: WHERE APD1.Accounting_Event_ID = p_xla_event_rec.event_id
1804: AND APD1.Invoice_Payment_ID = l_inv_pay_rec.invoice_payment_id
1805: AND APD1.Pay_Dist_Lookup_Code = 'DISCOUNT'
1806: AND ABS(APD1.Amount) =

Line 1808: FROM AP_Payment_Hist_Dists APD2

1804: AND APD1.Invoice_Payment_ID = l_inv_pay_rec.invoice_payment_id
1805: AND APD1.Pay_Dist_Lookup_Code = 'DISCOUNT'
1806: AND ABS(APD1.Amount) =
1807: (SELECT MAX(APD2.Amount)
1808: FROM AP_Payment_Hist_Dists APD2
1809: WHERE APD2.Accounting_Event_ID = p_xla_event_rec.event_id
1810: AND APD2.Invoice_Payment_ID = l_inv_pay_rec.invoice_payment_id
1811: AND APD2.Pay_Dist_Lookup_Code = 'DISCOUNT'))
1812: AND APD.Pay_Dist_Lookup_Code = 'DISCOUNT'

Line 1828: UPDATE AP_Payment_Hist_Dists APD

1824: END IF;
1825:
1826:
1827: /* Adjust the bank errors amount for technical rounding */
1828: UPDATE AP_Payment_Hist_Dists APD
1829: SET APD.Amount = APD.Amount - NVL(l_sum_error_amount,0)
1830: + l_pay_hist_rec.errors_bank_amount
1831: WHERE APD.Invoice_Distribution_ID =
1832: (SELECT MAX(APD1.Invoice_Distribution_ID)

Line 1833: FROM AP_Payment_Hist_Dists APD1

1829: SET APD.Amount = APD.Amount - NVL(l_sum_error_amount,0)
1830: + l_pay_hist_rec.errors_bank_amount
1831: WHERE APD.Invoice_Distribution_ID =
1832: (SELECT MAX(APD1.Invoice_Distribution_ID)
1833: FROM AP_Payment_Hist_Dists APD1
1834: WHERE APD1.Accounting_Event_ID = p_xla_event_rec.event_id
1835: AND APD1.Invoice_Payment_ID = l_inv_pay_rec.invoice_payment_id
1836: AND APD1.Pay_Dist_Lookup_Code = 'BANK ERROR'
1837: AND ABS(APD1.Amount) =

Line 1839: FROM AP_Payment_Hist_Dists APD2

1835: AND APD1.Invoice_Payment_ID = l_inv_pay_rec.invoice_payment_id
1836: AND APD1.Pay_Dist_Lookup_Code = 'BANK ERROR'
1837: AND ABS(APD1.Amount) =
1838: (SELECT MAX(APD2.Amount)
1839: FROM AP_Payment_Hist_Dists APD2
1840: WHERE APD2.Accounting_Event_ID = p_xla_event_rec.event_id
1841: AND APD2.Invoice_Payment_ID = l_inv_pay_rec.invoice_payment_id
1842: AND APD2.Pay_Dist_Lookup_Code = 'BANK ERROR'))
1843: AND APD.Pay_Dist_Lookup_Code = 'BANK ERROR'

Line 1859: UPDATE AP_Payment_Hist_Dists APD

1855: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1856: END IF;
1857:
1858: /* Adjust the bank charges amount for technical rounding */
1859: UPDATE AP_Payment_Hist_Dists APD
1860: SET APD.Amount = APD.Amount - NVL(l_sum_charge_amount,0)
1861: + l_pay_hist_rec.charges_bank_amount
1862: WHERE APD.Invoice_Distribution_ID =
1863: (SELECT MAX(APD1.Invoice_Distribution_ID)

Line 1864: FROM AP_Payment_Hist_Dists APD1

1860: SET APD.Amount = APD.Amount - NVL(l_sum_charge_amount,0)
1861: + l_pay_hist_rec.charges_bank_amount
1862: WHERE APD.Invoice_Distribution_ID =
1863: (SELECT MAX(APD1.Invoice_Distribution_ID)
1864: FROM AP_Payment_Hist_Dists APD1
1865: WHERE APD1.Accounting_Event_ID = p_xla_event_rec.event_id
1866: AND APD1.Invoice_Payment_ID = l_inv_pay_rec.invoice_payment_id
1867: AND APD1.Pay_Dist_Lookup_Code = 'BANK CHARGE'
1868: AND ABS(APD1.Amount) =

Line 1870: FROM AP_Payment_Hist_Dists APD2

1866: AND APD1.Invoice_Payment_ID = l_inv_pay_rec.invoice_payment_id
1867: AND APD1.Pay_Dist_Lookup_Code = 'BANK CHARGE'
1868: AND ABS(APD1.Amount) =
1869: (SELECT MAX(APD2.Amount)
1870: FROM AP_Payment_Hist_Dists APD2
1871: WHERE APD2.Accounting_Event_ID = p_xla_event_rec.event_id
1872: AND APD2.Invoice_Payment_ID = l_inv_pay_rec.invoice_payment_id
1873: AND APD2.Pay_Dist_Lookup_Code = 'BANK CHARGE'))
1874: AND APD.Pay_Dist_Lookup_Code = 'BANK CHARGE'

Line 2035: l_pd_rec AP_PAYMENT_HIST_DISTS%ROWTYPE;

2031: l_base_qty_variance NUMBER;
2032: l_amt_variance NUMBER;
2033: l_base_amt_variance NUMBER;
2034:
2035: l_pd_rec AP_PAYMENT_HIST_DISTS%ROWTYPE;
2036:
2037: -- Logging Infra:
2038: l_procedure_name CONSTANT VARCHAR2(30) := 'Pay_Dist_Proc';
2039: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 2958: l_pd_rec AP_PAYMENT_HIST_DISTS%ROWTYPE;

2954: l_bank_curr_amount NUMBER;
2955: l_disc_amt_inv_curr NUMBER;
2956: l_disc_amt_bank_curr NUMBER;
2957:
2958: l_pd_rec AP_PAYMENT_HIST_DISTS%ROWTYPE;
2959:
2960: -- Logging Infra:
2961: l_procedure_name CONSTANT VARCHAR2(30) := 'Pay_Dist_Discount';
2962: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 3379: l_pd_rec AP_PAYMENT_HIST_DISTS%ROWTYPE;

3375: l_po_exchange_rate NUMBER;
3376: l_po_pay_exchange_rate NUMBER;
3377: l_erv_amount NUMBER;
3378: l_inv_erv_amount NUMBER;
3379: l_pd_rec AP_PAYMENT_HIST_DISTS%ROWTYPE;
3380:
3381: -- Logging Infra:
3382: l_procedure_name CONSTANT VARCHAR2(30) := 'Pay_Dist_ERV';
3383: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 3549: l_pd_rec AP_PAYMENT_HIST_DISTS%ROWTYPE;

3545: l_total_dist_amt NUMBER := 0;
3546: l_total_prorated_amt NUMBER := 0;
3547: l_inv_dist_amount NUMBER;
3548:
3549: l_pd_rec AP_PAYMENT_HIST_DISTS%ROWTYPE;
3550:
3551: CURSOR clearing_pay_dists
3552: (P_Event_ID NUMBER)
3553: IS

Line 3559: FROM AP_Payment_Hist_Dists APHD

3555: Invoice_Distribution_ID,
3556: Amount,
3557: Payment_History_ID,
3558: Invoice_Payment_ID
3559: FROM AP_Payment_Hist_Dists APHD
3560: WHERE APHD.Accounting_Event_ID = P_Event_ID
3561: AND APHD.Pay_Dist_Lookup_Code = 'CASH'
3562: ORDER BY Amount;
3563:

Line 3618: FROM AP_Payment_Hist_Dists

3614:
3615:
3616: SELECT SUM(Amount)
3617: INTO l_total_pay_amt
3618: FROM AP_Payment_Hist_Dists
3619: WHERE Payment_History_ID = p_pay_hist_rec.payment_history_id
3620: AND Pay_Dist_Lookup_Code = 'CASH';
3621:
3622:

Line 3817: INSERT INTO ap_payment_hist_dists

3813: p_reversal_inv_pmt_id;
3814: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
3815: END IF;
3816:
3817: INSERT INTO ap_payment_hist_dists
3818: (Payment_Hist_Dist_ID,
3819: Accounting_Event_ID,
3820: Amount,
3821: Pay_Dist_Lookup_Code,

Line 3851: SELECT AP_Payment_Hist_Dists_S.nextval,

3847: Program_Login_ID,
3848: Program_Update_Date,
3849: Request_ID
3850: )
3851: SELECT AP_Payment_Hist_Dists_S.nextval,
3852: p_xla_event_rec.event_id,
3853: -1 * APHD.Amount,
3854: APHD.Pay_Dist_Lookup_Code,
3855: p_pay_hist_rec.Payment_History_ID,

Line 3883: FROM AP_Payment_Hist_Dists APHD,

3879: FND_GLOBAL.Conc_Program_ID,
3880: NULL,
3881: SYSDATE,
3882: FND_GLOBAL.Conc_Request_ID
3883: FROM AP_Payment_Hist_Dists APHD,
3884: AP_Invoice_Payments_All AIP,
3885: AP_Invoice_Distributions_All AID
3886: WHERE AIP.Invoice_Payment_ID = p_reversal_inv_pmt_id
3887: AND AIP.Accounting_Event_ID = APHD.Accounting_Event_ID

Line 3906: INSERT INTO ap_payment_hist_dists

3902: -- cancelled event.
3903: IF p_xla_event_rec.event_type_code IN ('PAYMENT CANCELLED',
3904: 'REFUND CANCELLED') THEN
3905:
3906: INSERT INTO ap_payment_hist_dists
3907: (Payment_Hist_Dist_ID,
3908: Accounting_Event_ID,
3909: Amount,
3910: Pay_Dist_Lookup_Code,

Line 3940: SELECT AP_Payment_Hist_Dists_S.nextval,

3936: Program_Login_ID,
3937: Program_Update_Date,
3938: Request_ID
3939: )
3940: SELECT AP_Payment_Hist_Dists_S.nextval,
3941: p_xla_event_rec.event_id,
3942: -1 * APHD.Amount,
3943: APHD.Pay_Dist_Lookup_Code,
3944: p_pay_hist_rec.Payment_History_ID,

Line 3972: FROM AP_Payment_Hist_Dists APHD,

3968: FND_GLOBAL.Conc_Program_ID,
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

Line 3985: FROM AP_Payment_Hist_Dists APHD1

3981: AND AIP.Accounting_Event_ID = p_xla_event_rec.event_id
3982: AND AIP.Check_ID = APH.Check_ID -- Bug 6856694
3983: AND AIP.Invoice_ID = AID.Invoice_ID
3984: AND NOT EXISTS (SELECT 'Reversal Payment Dists'
3985: FROM AP_Payment_Hist_Dists APHD1
3986: WHERE APHD1.Reversed_Pay_Hist_Dist_ID
3987: = APHD.Payment_Hist_Dist_ID
3988: -- Bug 6856694
3989: AND APHD1.Invoice_Distribution_ID

Line 3993: INSERT INTO ap_payment_hist_dists

3989: AND APHD1.Invoice_Distribution_ID
3990: = APHD.Invoice_Distribution_ID);
3991:
3992: ELSE
3993: INSERT INTO ap_payment_hist_dists
3994: (Payment_Hist_Dist_ID,
3995: Accounting_Event_ID,
3996: Amount,
3997: Pay_Dist_Lookup_Code,

Line 4027: SELECT AP_Payment_Hist_Dists_S.nextval,

4023: Program_Login_ID,
4024: Program_Update_Date,
4025: Request_ID
4026: )
4027: SELECT AP_Payment_Hist_Dists_S.nextval,
4028: p_xla_event_rec.event_id,
4029: -1 * APHD.Amount,
4030: APHD.Pay_Dist_Lookup_Code,
4031: p_pay_hist_rec.Payment_History_ID,

Line 4059: FROM AP_Payment_Hist_Dists APHD,

4055: FND_GLOBAL.Conc_Program_ID,
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

Line 4066: FROM AP_Payment_Hist_Dists APHD1

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'
4065: AND NOT EXISTS (SELECT 'Reversal Payment Dists'
4066: FROM AP_Payment_Hist_Dists APHD1
4067: WHERE APHD1.Reversed_Pay_Hist_Dist_ID
4068: = APHD.Payment_Hist_Dist_ID
4069: -- Bug 6856694
4070: AND APHD1.Invoice_Distribution_ID

Line 4083: INSERT INTO ap_payment_hist_dists

4079: p_invoice_dist_id;
4080: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
4081: END IF;
4082:
4083: INSERT INTO ap_payment_hist_dists
4084: (Payment_Hist_Dist_ID,
4085: Accounting_Event_ID,
4086: Amount,
4087: Pay_Dist_Lookup_Code,

Line 4117: SELECT AP_Payment_Hist_Dists_S.nextval,

4113: Program_Login_ID,
4114: Program_Update_Date,
4115: Request_ID
4116: )
4117: SELECT AP_Payment_Hist_Dists_S.nextval,
4118: p_xla_event_rec.event_id,
4119: -1 * APHD.Amount,
4120: APHD.Pay_Dist_Lookup_Code,
4121: p_pay_hist_rec.Payment_History_ID,

Line 4149: FROM AP_Payment_Hist_Dists APHD,

4145: FND_GLOBAL.Conc_Program_ID,
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

Line 4269: -- ap_payment_hist_dists table

4265:
4266: ----------------------------------------------------------------------------------
4267: -- PROCEDURE Pay_Dist_Insert
4268: -- This procedure is used to insert the payment hist distributions into the
4269: -- ap_payment_hist_dists table
4270: ----------------------------------------------------------------------------------
4271:
4272: PROCEDURE Pay_Dist_Insert
4273: (P_PD_Rec IN AP_PAYMENT_HIST_DISTS%ROWTYPE

Line 4273: (P_PD_Rec IN AP_PAYMENT_HIST_DISTS%ROWTYPE

4269: -- ap_payment_hist_dists table
4270: ----------------------------------------------------------------------------------
4271:
4272: PROCEDURE Pay_Dist_Insert
4273: (P_PD_Rec IN AP_PAYMENT_HIST_DISTS%ROWTYPE
4274: ,P_Calling_Sequence IN VARCHAR2
4275: ) IS
4276:
4277: l_curr_calling_sequence VARCHAR2(2000);

Line 4297: INSERT INTO AP_Payment_Hist_Dists

4293: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
4294: END IF;
4295:
4296:
4297: INSERT INTO AP_Payment_Hist_Dists
4298: (Payment_Hist_Dist_ID,
4299: Accounting_Event_ID,
4300: Amount,
4301: Pay_Dist_Lookup_Code,

Line 4331: VALUES (AP_Payment_Hist_Dists_S.nextval,

4327: Program_Login_ID,
4328: Program_Update_Date,
4329: Request_ID
4330: )
4331: VALUES (AP_Payment_Hist_Dists_S.nextval,
4332: P_PD_Rec.Accounting_Event_ID,
4333: P_PD_Rec.Amount,
4334: P_PD_Rec.Pay_Dist_Lookup_Code,
4335: P_PD_Rec.Payment_History_ID,

Line 4392: -- ap_payment_hist_dists table

4388: -- distribution links with the right amounts
4389: ----------------------------------------------------------------------------------
4390: -- PROCEDURE Upg_Dist_Links_Insert
4391: -- This procedure is used to insert the payment hist distributions into the
4392: -- ap_payment_hist_dists table
4393: ----------------------------------------------------------------------------------
4394:
4395: PROCEDURE Upg_Dist_Links_Insert
4396: (p_xla_event_rec IN ap_accounting_pay_pkg.r_xla_event_info

Line 4665: AP_Payment_Hist_Dists APHD,

4661: XLA_AE_Lines AEL,
4662: AP_Inv_Dists_Source AID1,
4663: AP_Invoices_All AI,
4664: AP_Invoice_Distributions_All AID,
4665: AP_Payment_Hist_Dists APHD,
4666: xla_events aid_xe -- changed for bug#7293021
4667: WHERE AC.Check_ID = p_xla_event_rec.source_id_int_1
4668: AND AC.Org_ID = ASP.Org_ID
4669: AND XLE.Event_ID = p_accounting_event_id

Line 4741: AP_Payment_Hist_Dists APHD,

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,
4743: AP_Invoices_All AI,
4744: xla_events aid_xe -- changed for bug#7293021
4745: WHERE AC.Check_ID = p_xla_event_rec.source_id_int_1