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.

[Home] [Help]

APPS.AP_ACCTG_PREPAY_DIST_PKG dependencies on AP_ACCOUNTING_PAY_PKG

Line 30: (P_XLA_Event_Rec IN ap_accounting_pay_pkg.r_xla_event_info

26: -- prepay history table based on the exchange rates of prepayment transactions.
27: --
28: --------------------------------------------------------------------------------
29: PROCEDURE Update_Gain_Loss_Ind
30: (P_XLA_Event_Rec IN ap_accounting_pay_pkg.r_xla_event_info
31: ,P_Calling_Sequence IN VARCHAR2
32: ) IS
33:
34: l_curr_calling_sequence VARCHAR2(2000);

Line 437: l_pay_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;

433: l_curr_calling_sequence VARCHAR2(2000);
434: l_total_paid_amt NUMBER;
435: l_final_payment BOOLEAN := FALSE;
436:
437: l_pay_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;
438: l_clr_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;
439: l_inv_rec ap_accounting_pay_pkg.r_invoices_info;
440: l_prepay_inv_rec ap_accounting_pay_pkg.r_invoices_info;
441: l_inv_dist_rec ap_accounting_pay_pkg.r_inv_dist_info;

Line 438: l_clr_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;

434: l_total_paid_amt NUMBER;
435: l_final_payment BOOLEAN := FALSE;
436:
437: l_pay_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;
438: l_clr_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;
439: l_inv_rec ap_accounting_pay_pkg.r_invoices_info;
440: l_prepay_inv_rec ap_accounting_pay_pkg.r_invoices_info;
441: l_inv_dist_rec ap_accounting_pay_pkg.r_inv_dist_info;
442: l_prepay_hist_rec r_prepay_hist_info;

Line 439: l_inv_rec ap_accounting_pay_pkg.r_invoices_info;

435: l_final_payment BOOLEAN := FALSE;
436:
437: l_pay_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;
438: l_clr_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;
439: l_inv_rec ap_accounting_pay_pkg.r_invoices_info;
440: l_prepay_inv_rec ap_accounting_pay_pkg.r_invoices_info;
441: l_inv_dist_rec ap_accounting_pay_pkg.r_inv_dist_info;
442: l_prepay_hist_rec r_prepay_hist_info;
443: l_prepay_dist_rec r_prepay_dist_info;

Line 440: l_prepay_inv_rec ap_accounting_pay_pkg.r_invoices_info;

436:
437: l_pay_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;
438: l_clr_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;
439: l_inv_rec ap_accounting_pay_pkg.r_invoices_info;
440: l_prepay_inv_rec ap_accounting_pay_pkg.r_invoices_info;
441: l_inv_dist_rec ap_accounting_pay_pkg.r_inv_dist_info;
442: l_prepay_hist_rec r_prepay_hist_info;
443: l_prepay_dist_rec r_prepay_dist_info;
444: l_payment_type_flag AP_CHECKS_ALL.payment_type_flag%TYPE;

Line 441: l_inv_dist_rec ap_accounting_pay_pkg.r_inv_dist_info;

437: l_pay_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;
438: l_clr_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;
439: l_inv_rec ap_accounting_pay_pkg.r_invoices_info;
440: l_prepay_inv_rec ap_accounting_pay_pkg.r_invoices_info;
441: l_inv_dist_rec ap_accounting_pay_pkg.r_inv_dist_info;
442: l_prepay_hist_rec r_prepay_hist_info;
443: l_prepay_dist_rec r_prepay_dist_info;
444: l_payment_type_flag AP_CHECKS_ALL.payment_type_flag%TYPE;
445: l_pay_trx_type AP_PAYMENT_HISTORY_ALL.transaction_type%TYPE;

Line 806: IF AP_Accounting_Pay_Pkg.Is_Final_Payment

802: --IF l_upg_inv_pmts = 0 AND l_upg_prepay_app = 0 THEN
803:
804: /* Check if the invoice is fully paid */
805: --bug 9108925, added the call to Is_Final_Event
806: IF AP_Accounting_Pay_Pkg.Is_Final_Payment
807: (l_inv_rec,
808: NULL, -- Payment Amount
809: NULL, -- Discount Amount
810: l_prepay_dist_rec.amount,

Line 816: l_final_payment := AP_ACCOUNTING_PAY_PKG.Is_Final_Event

812: l_curr_calling_sequence) THEN
813: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
814: l_log_msg := 'Final payment of Invoice_ID '||l_prepay_dist_rec.invoice_id;
815: END IF;
816: l_final_payment := AP_ACCOUNTING_PAY_PKG.Is_Final_Event
817: (l_inv_rec,
818: NULL, --p_xla_event_rec
819: l_prepay_dist_rec.invoice_distribution_id,
820: l_curr_calling_sequence);

Line 942: INTO ap_accounting_pay_pkg.g_base_currency_code

938: END IF;
939:
940: -- bug 7611160
941: SELECT asp.base_currency_code
942: INTO ap_accounting_pay_pkg.g_base_currency_code
943: FROM ap_system_parameters_all asp,
944: ap_invoices_all ai
945: WHERE asp.org_id = ai.org_id
946: AND ai.invoice_id = l_inv_rec.invoice_id;

Line 1004: (P_XLA_Event_Rec IN ap_accounting_pay_pkg.r_xla_event_info

1000: -- prepayment application payment distributions.
1001: --
1002: --------------------------------------------------------------------------------
1003: PROCEDURE Prepay_Dist_Cascade_Adj
1004: (P_XLA_Event_Rec IN ap_accounting_pay_pkg.r_xla_event_info
1005: ,P_Calling_Sequence IN VARCHAR2
1006: ) IS
1007:
1008: l_curr_calling_sequence VARCHAR2(2000);

Line 1013: l_pay_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;

1009: l_inv_adj_amount NUMBER := 0;
1010: l_sum_prepaid_amount NUMBER := 0;
1011: l_sum_tax_diff_amount NUMBER := 0;
1012:
1013: l_pay_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;
1014: l_clr_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;
1015: l_prepay_inv_rec ap_accounting_pay_pkg.r_invoices_info;
1016: l_inv_rec ap_accounting_pay_pkg.r_invoices_info;
1017: l_prepay_hist_rec r_prepay_hist_info;

Line 1014: l_clr_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;

1010: l_sum_prepaid_amount NUMBER := 0;
1011: l_sum_tax_diff_amount NUMBER := 0;
1012:
1013: l_pay_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;
1014: l_clr_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;
1015: l_prepay_inv_rec ap_accounting_pay_pkg.r_invoices_info;
1016: l_inv_rec ap_accounting_pay_pkg.r_invoices_info;
1017: l_prepay_hist_rec r_prepay_hist_info;
1018: l_prepay_dist_rec r_prepay_dist_info;

Line 1015: l_prepay_inv_rec ap_accounting_pay_pkg.r_invoices_info;

1011: l_sum_tax_diff_amount NUMBER := 0;
1012:
1013: l_pay_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;
1014: l_clr_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;
1015: l_prepay_inv_rec ap_accounting_pay_pkg.r_invoices_info;
1016: l_inv_rec ap_accounting_pay_pkg.r_invoices_info;
1017: l_prepay_hist_rec r_prepay_hist_info;
1018: l_prepay_dist_rec r_prepay_dist_info;
1019: l_inv_dist_rec ap_accounting_pay_pkg.r_inv_dist_info;

Line 1016: l_inv_rec ap_accounting_pay_pkg.r_invoices_info;

1012:
1013: l_pay_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;
1014: l_clr_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;
1015: l_prepay_inv_rec ap_accounting_pay_pkg.r_invoices_info;
1016: l_inv_rec ap_accounting_pay_pkg.r_invoices_info;
1017: l_prepay_hist_rec r_prepay_hist_info;
1018: l_prepay_dist_rec r_prepay_dist_info;
1019: l_inv_dist_rec ap_accounting_pay_pkg.r_inv_dist_info;
1020: l_rounding_adjust_id NUMBER; --bug8201141

Line 1019: l_inv_dist_rec ap_accounting_pay_pkg.r_inv_dist_info;

1015: l_prepay_inv_rec ap_accounting_pay_pkg.r_invoices_info;
1016: l_inv_rec ap_accounting_pay_pkg.r_invoices_info;
1017: l_prepay_hist_rec r_prepay_hist_info;
1018: l_prepay_dist_rec r_prepay_dist_info;
1019: l_inv_dist_rec ap_accounting_pay_pkg.r_inv_dist_info;
1020: l_rounding_adjust_id NUMBER; --bug8201141
1021: --7488981
1022: l_prepay_dist_cnt NUMBER;
1023:

Line 1466: IF(l_inv_rec.invoice_currency_code=ap_accounting_pay_pkg.g_base_currency_code) THEN

1462:
1463: IF NVL(l_sum_prepaid_amount, 0) <> l_prepay_dist_rec.amount THEN -- added for bug12858105
1464:
1465: -- bug 9240725
1466: IF(l_inv_rec.invoice_currency_code=ap_accounting_pay_pkg.g_base_currency_code) THEN
1467:
1468: UPDATE AP_Prepay_App_Dists APAD
1469: SET APAD.Amount = APAD.Amount - NVL(l_sum_prepaid_amount,0) + l_prepay_dist_rec.amount,
1470: APAD.BASE_AMT_AT_PREPAY_XRATE = APAD.BASE_AMT_AT_PREPAY_XRATE - NVL(l_sum_prepaid_amount,0) + l_prepay_dist_rec.amount,

Line 1594: IF(l_inv_rec.invoice_currency_code=ap_accounting_pay_pkg.g_base_currency_code) THEN

1590: AND APAD.Prepay_App_Distribution_ID = l_prepay_dist_rec.invoice_distribution_id
1591: AND APAD.Accounting_Event_ID = p_xla_event_rec.event_id; */
1592:
1593: /* bug12858105 - start */
1594: IF(l_inv_rec.invoice_currency_code=ap_accounting_pay_pkg.g_base_currency_code) THEN
1595:
1596: UPDATE AP_Prepay_App_Dists APAD
1597: SET APAD.Amount = APAD.Amount- NVL(l_sum_tax_diff_amount,0) + l_prepay_dist_rec.prepay_tax_diff_amount ,
1598: APAD.BASE_AMT_AT_PREPAY_XRATE = APAD.BASE_AMT_AT_PREPAY_XRATE

Line 1748: (p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info

1744: -- Also calculates ERV
1745: ---------------------------------------------------------------------
1746: -- Bug 6698125. Added p_xla_event_rec parameter
1747: PROCEDURE Prepay_Dist_Proc
1748: (p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
1749: ,p_clr_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
1750: ,p_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
1751: ,p_prepay_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
1752: ,p_prepay_hist_rec IN r_prepay_hist_info

Line 1749: ,p_clr_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info

1745: ---------------------------------------------------------------------
1746: -- Bug 6698125. Added p_xla_event_rec parameter
1747: PROCEDURE Prepay_Dist_Proc
1748: (p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
1749: ,p_clr_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
1750: ,p_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
1751: ,p_prepay_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
1752: ,p_prepay_hist_rec IN r_prepay_hist_info
1753: ,p_prepay_dist_rec IN r_prepay_dist_info

Line 1750: ,p_inv_rec IN ap_accounting_pay_pkg.r_invoices_info

1746: -- Bug 6698125. Added p_xla_event_rec parameter
1747: PROCEDURE Prepay_Dist_Proc
1748: (p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
1749: ,p_clr_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
1750: ,p_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
1751: ,p_prepay_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
1752: ,p_prepay_hist_rec IN r_prepay_hist_info
1753: ,p_prepay_dist_rec IN r_prepay_dist_info
1754: ,p_inv_dist_rec IN ap_accounting_pay_pkg.r_inv_dist_info

Line 1751: ,p_prepay_inv_rec IN ap_accounting_pay_pkg.r_invoices_info

1747: PROCEDURE Prepay_Dist_Proc
1748: (p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
1749: ,p_clr_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
1750: ,p_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
1751: ,p_prepay_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
1752: ,p_prepay_hist_rec IN r_prepay_hist_info
1753: ,p_prepay_dist_rec IN r_prepay_dist_info
1754: ,p_inv_dist_rec IN ap_accounting_pay_pkg.r_inv_dist_info
1755: ,p_xla_event_rec IN ap_accounting_pay_pkg.r_xla_event_info

Line 1754: ,p_inv_dist_rec IN ap_accounting_pay_pkg.r_inv_dist_info

1750: ,p_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
1751: ,p_prepay_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
1752: ,p_prepay_hist_rec IN r_prepay_hist_info
1753: ,p_prepay_dist_rec IN r_prepay_dist_info
1754: ,p_inv_dist_rec IN ap_accounting_pay_pkg.r_inv_dist_info
1755: ,p_xla_event_rec IN ap_accounting_pay_pkg.r_xla_event_info
1756: ,p_calc_mode IN VARCHAR2
1757: ,p_final_payment IN BOOLEAN
1758: ,p_calling_sequence IN VARCHAR2

Line 1755: ,p_xla_event_rec IN ap_accounting_pay_pkg.r_xla_event_info

1751: ,p_prepay_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
1752: ,p_prepay_hist_rec IN r_prepay_hist_info
1753: ,p_prepay_dist_rec IN r_prepay_dist_info
1754: ,p_inv_dist_rec IN ap_accounting_pay_pkg.r_inv_dist_info
1755: ,p_xla_event_rec IN ap_accounting_pay_pkg.r_xla_event_info
1756: ,p_calc_mode IN VARCHAR2
1757: ,p_final_payment IN BOOLEAN
1758: ,p_calling_sequence IN VARCHAR2
1759: ) IS

Line 1835: l_log_msg := 'Calling procedure AP_Accounting_Pay_Pkg.Get_Pay_Sum';

1831: -- total. This way the liability is fully relieved.
1832: IF p_final_payment = TRUE THEN
1833:
1834: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1835: l_log_msg := 'Calling procedure AP_Accounting_Pay_Pkg.Get_Pay_Sum';
1836: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
1837: END IF;
1838:
1839: AP_Accounting_Pay_Pkg.Get_Pay_Sum

Line 1839: AP_Accounting_Pay_Pkg.Get_Pay_Sum

1835: l_log_msg := 'Calling procedure AP_Accounting_Pay_Pkg.Get_Pay_Sum';
1836: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
1837: END IF;
1838:
1839: AP_Accounting_Pay_Pkg.Get_Pay_Sum
1840: (p_inv_dist_rec.invoice_distribution_id,
1841: 'PAYMENT CREATED',
1842: l_total_paid_amt,
1843: l_total_inv_dist_amt,

Line 1848: l_total_prepaid_amt := AP_Accounting_Pay_Pkg.Get_Prepay_Sum

1844: l_total_bank_curr_amt,
1845: l_curr_calling_sequence);
1846:
1847:
1848: l_total_prepaid_amt := AP_Accounting_Pay_Pkg.Get_Prepay_Sum
1849: (p_inv_dist_rec.invoice_distribution_id,
1850: l_curr_calling_sequence);
1851:
1852:

Line 1882: --now in ap_accounting_pay_pkg.get_prepay_sum

1878: l_prorated_amount := -1 * (-1*p_inv_dist_rec.amount - l_total_paid_amt +
1879: l_total_prepaid_amt);
1880: ELSE
1881: --commenting out the following code for bug8882706 as the same will be handled
1882: --now in ap_accounting_pay_pkg.get_prepay_sum
1883: /*SELECT SUM(apad.amount) INTO l_awt_prorated_amt
1884: FROM ap_prepay_app_dists apad
1885: WHERE apad.prepay_dist_lookup_code = 'AWT'
1886: AND apad.awt_related_id = p_inv_dist_rec.invoice_distribution_id

Line 1982: - AP_Accounting_Pay_Pkg.get_casc_prepay_sum

1978: -- give us the amount that needs to be adjusted
1979: l_prorated_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY
1980: (((p_inv_dist_rec.amount * p_prepay_dist_rec.amount)
1981: / g_total_inv_amount) --8244163
1982: - AP_Accounting_Pay_Pkg.get_casc_prepay_sum
1983: (p_inv_dist_rec.invoice_distribution_id,
1984: p_prepay_dist_rec.invoice_distribution_id,
1985: l_curr_calling_sequence),
1986: p_inv_rec.invoice_currency_code);

Line 2044: l_pad_rec.base_amt_at_prepay_xrate := AP_Accounting_Pay_Pkg.Get_Base_Amount

2040: l_pad_rec.prepay_pay_exchange_rate_type := p_pay_hist_rec.pmt_to_base_xrate_type;
2041: l_pad_rec.prepay_clr_exchange_rate_type := p_clr_hist_rec.bank_to_base_xrate_type;
2042:
2043:
2044: l_pad_rec.base_amt_at_prepay_xrate := AP_Accounting_Pay_Pkg.Get_Base_Amount
2045: (l_prorated_amount,
2046: p_prepay_inv_rec.invoice_currency_code,
2047: p_inv_rec.base_currency_code,
2048: p_prepay_inv_rec.exchange_rate_type,

Line 2062: l_pad_rec.base_amt_at_prepay_pay_xrate := AP_Accounting_Pay_Pkg.Get_Base_Amount

2058: ELSE
2059: l_prorated_pay_amt := l_prorated_amount;
2060: END IF;
2061:
2062: l_pad_rec.base_amt_at_prepay_pay_xrate := AP_Accounting_Pay_Pkg.Get_Base_Amount
2063: (l_prorated_pay_amt,
2064: p_pay_hist_rec.pmt_currency_code,
2065: p_inv_rec.base_currency_code,
2066: p_pay_hist_rec.pmt_to_base_xrate_type,

Line 2080: l_pad_rec.base_amt_at_prepay_clr_xrate := AP_Accounting_Pay_Pkg.Get_Base_Amount

2076: ELSE
2077: l_prorated_clr_amt := l_prorated_pay_amt;
2078: END IF;
2079:
2080: l_pad_rec.base_amt_at_prepay_clr_xrate := AP_Accounting_Pay_Pkg.Get_Base_Amount
2081: (l_prorated_clr_amt,
2082: p_clr_hist_rec.bank_currency_code,
2083: p_inv_rec.base_currency_code,
2084: p_clr_hist_rec.bank_to_base_xrate_type,

Line 2090: l_pad_rec.base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount

2086: p_clr_hist_rec.bank_to_base_xrate,
2087: l_curr_calling_sequence);
2088:
2089:
2090: l_pad_rec.base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
2091: (l_prorated_amount,
2092: p_inv_rec.invoice_currency_code,
2093: p_inv_rec.base_currency_code,
2094: p_inv_rec.exchange_rate_type,

Line 2249: (p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info

2245: -- application distribution table
2246: ---------------------------------------------------------------------
2247:
2248: PROCEDURE Prepay_Dist_Tax_Diff
2249: (p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
2250: ,p_clr_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
2251: ,p_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
2252: ,p_prepay_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
2253: ,p_prepay_hist_rec IN r_prepay_hist_info

Line 2250: ,p_clr_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info

2246: ---------------------------------------------------------------------
2247:
2248: PROCEDURE Prepay_Dist_Tax_Diff
2249: (p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
2250: ,p_clr_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
2251: ,p_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
2252: ,p_prepay_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
2253: ,p_prepay_hist_rec IN r_prepay_hist_info
2254: ,p_prepay_dist_rec IN r_prepay_dist_info

Line 2251: ,p_inv_rec IN ap_accounting_pay_pkg.r_invoices_info

2247:
2248: PROCEDURE Prepay_Dist_Tax_Diff
2249: (p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
2250: ,p_clr_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
2251: ,p_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
2252: ,p_prepay_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
2253: ,p_prepay_hist_rec IN r_prepay_hist_info
2254: ,p_prepay_dist_rec IN r_prepay_dist_info
2255: ,p_inv_dist_rec IN ap_accounting_pay_pkg.r_inv_dist_info

Line 2252: ,p_prepay_inv_rec IN ap_accounting_pay_pkg.r_invoices_info

2248: PROCEDURE Prepay_Dist_Tax_Diff
2249: (p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
2250: ,p_clr_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
2251: ,p_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
2252: ,p_prepay_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
2253: ,p_prepay_hist_rec IN r_prepay_hist_info
2254: ,p_prepay_dist_rec IN r_prepay_dist_info
2255: ,p_inv_dist_rec IN ap_accounting_pay_pkg.r_inv_dist_info
2256: ,p_calc_mode IN VARCHAR2

Line 2255: ,p_inv_dist_rec IN ap_accounting_pay_pkg.r_inv_dist_info

2251: ,p_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
2252: ,p_prepay_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
2253: ,p_prepay_hist_rec IN r_prepay_hist_info
2254: ,p_prepay_dist_rec IN r_prepay_dist_info
2255: ,p_inv_dist_rec IN ap_accounting_pay_pkg.r_inv_dist_info
2256: ,p_calc_mode IN VARCHAR2
2257: ,p_calling_sequence IN VARCHAR2
2258: ) IS
2259:

Line 2320: - AP_Accounting_Pay_Pkg.get_casc_tax_diff_sum

2316: -- give us the amount that needs to be adjusted
2317: l_prorated_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY
2318: (((p_inv_dist_rec.amount * p_prepay_dist_rec.prepay_tax_diff_amount)
2319: / g_total_inv_amount)
2320: - AP_Accounting_Pay_Pkg.get_casc_tax_diff_sum
2321: (p_inv_dist_rec.invoice_distribution_id,
2322: p_prepay_dist_rec.invoice_distribution_id,
2323: l_curr_calling_sequence),
2324: p_inv_rec.invoice_currency_code);

Line 2361: l_pad_rec.base_amt_at_prepay_xrate := AP_Accounting_Pay_Pkg.Get_Base_Amount

2357: l_pad_rec.prepay_pay_exchange_rate_type := p_pay_hist_rec.pmt_to_base_xrate_type;
2358: l_pad_rec.prepay_clr_exchange_rate_type := p_clr_hist_rec.bank_to_base_xrate_type;
2359:
2360:
2361: l_pad_rec.base_amt_at_prepay_xrate := AP_Accounting_Pay_Pkg.Get_Base_Amount
2362: (l_prorated_amount,
2363: p_prepay_inv_rec.invoice_currency_code,
2364: p_inv_rec.base_currency_code,
2365: p_prepay_inv_rec.exchange_rate_type,

Line 2377: l_pad_rec.base_amt_at_prepay_pay_xrate := AP_Accounting_Pay_Pkg.Get_Base_Amount

2373: l_prorated_pay_amt := l_prorated_amount;
2374: END IF;
2375:
2376:
2377: l_pad_rec.base_amt_at_prepay_pay_xrate := AP_Accounting_Pay_Pkg.Get_Base_Amount
2378: (l_prorated_pay_amt,
2379: p_pay_hist_rec.pmt_currency_code,
2380: p_inv_rec.base_currency_code,
2381: p_pay_hist_rec.pmt_to_base_xrate_type,

Line 2395: l_pad_rec.base_amt_at_prepay_clr_xrate := AP_Accounting_Pay_Pkg.Get_Base_Amount

2391: ELSE
2392: l_prorated_clr_amt := l_prorated_pay_amt;
2393: END IF;
2394:
2395: l_pad_rec.base_amt_at_prepay_clr_xrate := AP_Accounting_Pay_Pkg.Get_Base_Amount
2396: (l_prorated_clr_amt,
2397: p_clr_hist_rec.bank_currency_code,
2398: p_inv_rec.base_currency_code,
2399: p_clr_hist_rec.bank_to_base_xrate_type,

Line 2405: l_pad_rec.base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount

2401: p_clr_hist_rec.bank_to_base_xrate,
2402: l_curr_calling_sequence);
2403:
2404:
2405: l_pad_rec.base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
2406: (l_prorated_amount,
2407: p_inv_rec.invoice_currency_code,
2408: p_inv_rec.base_currency_code,
2409: p_inv_rec.exchange_rate_type,

Line 2451: (p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info

2447: -- and inserts the calculated values into prepay appl payment dists table
2448: ---------------------------------------------------------------------
2449:
2450: PROCEDURE Prepay_Dist_ERV
2451: (p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
2452: ,p_clr_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
2453: ,p_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
2454: ,p_prepay_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
2455: ,p_prepay_hist_rec IN r_prepay_hist_info

Line 2452: ,p_clr_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info

2448: ---------------------------------------------------------------------
2449:
2450: PROCEDURE Prepay_Dist_ERV
2451: (p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
2452: ,p_clr_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
2453: ,p_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
2454: ,p_prepay_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
2455: ,p_prepay_hist_rec IN r_prepay_hist_info
2456: ,p_prepay_dist_rec IN r_prepay_dist_info

Line 2453: ,p_inv_rec IN ap_accounting_pay_pkg.r_invoices_info

2449:
2450: PROCEDURE Prepay_Dist_ERV
2451: (p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
2452: ,p_clr_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
2453: ,p_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
2454: ,p_prepay_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
2455: ,p_prepay_hist_rec IN r_prepay_hist_info
2456: ,p_prepay_dist_rec IN r_prepay_dist_info
2457: ,p_inv_dist_rec IN ap_accounting_pay_pkg.r_inv_dist_info

Line 2454: ,p_prepay_inv_rec IN ap_accounting_pay_pkg.r_invoices_info

2450: PROCEDURE Prepay_Dist_ERV
2451: (p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
2452: ,p_clr_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
2453: ,p_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
2454: ,p_prepay_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
2455: ,p_prepay_hist_rec IN r_prepay_hist_info
2456: ,p_prepay_dist_rec IN r_prepay_dist_info
2457: ,p_inv_dist_rec IN ap_accounting_pay_pkg.r_inv_dist_info
2458: ,p_prorated_amount IN NUMBER

Line 2457: ,p_inv_dist_rec IN ap_accounting_pay_pkg.r_inv_dist_info

2453: ,p_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
2454: ,p_prepay_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
2455: ,p_prepay_hist_rec IN r_prepay_hist_info
2456: ,p_prepay_dist_rec IN r_prepay_dist_info
2457: ,p_inv_dist_rec IN ap_accounting_pay_pkg.r_inv_dist_info
2458: ,p_prorated_amount IN NUMBER
2459: ,p_calling_sequence IN VARCHAR2
2460: ) IS
2461:

Line 2632: ,P_XLA_Event_Rec IN ap_accounting_pay_pkg.r_xla_event_info

2628: -- Bug 7134020. Added p_inv_dist_id parameter
2629: PROCEDURE Prepay_Dist_Reverse
2630: (p_prepay_hist_rec IN r_prepay_hist_info
2631: ,p_prepay_reversal_id IN NUMBER
2632: ,P_XLA_Event_Rec IN ap_accounting_pay_pkg.r_xla_event_info
2633: ,p_inv_reversal_id IN NUMBER
2634: ,p_inv_dist_id IN NUMBER
2635: ,p_prepay_inv_dist_id IN NUMBER
2636: ,p_calling_sequence IN VARCHAR2