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_ROUND_PKG dependencies on AP_PREPAY_APP_DISTS

Line 92: FROM AP_Prepay_App_Dists APAD,

88:
89: /* Get the prepayment app dists amount that has already been accounted */
90: SELECT SUM(-1 * APAD.Amount)
91: INTO l_prepay_acctg_amt
92: FROM AP_Prepay_App_Dists APAD,
93: AP_Invoice_Distributions_All AID
94: WHERE APAD.Prepay_App_Distribution_ID = AID.Invoice_Distribution_ID
95: AND AID.Prepay_Distribution_ID = p_prepay_dist_rec.prepay_distribution_id;
96:

Line 350: l_max_prepay_rec AP_PREPAY_APP_DISTS%ROWTYPE;

346: l_dist_count_per_event NUMBER;
347:
348:
349:
350: l_max_prepay_rec AP_PREPAY_APP_DISTS%ROWTYPE;
351: l_pad_rec AP_PREPAY_APP_DISTS%ROWTYPE;
352: l_max_pay_rec AP_PAYMENT_HIST_DISTS%ROWTYPE;
353: l_pd_rec AP_PAYMENT_HIST_DISTS%ROWTYPE;
354: l_erv_base_amount AP_INVOICE_DISTRIBUTIONS_ALL.base_amount%type := 0;

Line 351: l_pad_rec AP_PREPAY_APP_DISTS%ROWTYPE;

347:
348:
349:
350: l_max_prepay_rec AP_PREPAY_APP_DISTS%ROWTYPE;
351: l_pad_rec AP_PREPAY_APP_DISTS%ROWTYPE;
352: l_max_pay_rec AP_PAYMENT_HIST_DISTS%ROWTYPE;
353: l_pd_rec AP_PAYMENT_HIST_DISTS%ROWTYPE;
354: l_erv_base_amount AP_INVOICE_DISTRIBUTIONS_ALL.base_amount%type := 0;
355:

Line 506: FROM AP_Prepay_App_Dists APAD,

502:
503: -- Bug 7138115. Added additional join conditions to improve performance
504: SELECT SUM(APAD.Base_Amount)
505: INTO l_sum_prepay_base_amt
506: FROM AP_Prepay_App_Dists APAD,
507: AP_Prepay_History_All APH
508: WHERE ((APAD.Invoice_Distribution_ID = l_inv_dist_rec.invoice_distribution_id
509: AND APAD.Prepay_Dist_Lookup_Code IN ('PREPAY APPL', 'PREPAY APPL REC TAX',
510: 'PREPAY APPL NONREC TAX'))

Line 580: FROM AP_Prepay_App_Dists APAD

576:
577: -- Get the prepay appl pay dists info for this distribution
578: SELECT APAD.*
579: INTO l_max_prepay_rec
580: FROM AP_Prepay_App_Dists APAD
581: WHERE APAD.Prepay_App_Distribution_ID = p_prepay_dist_rec.invoice_distribution_id
582: AND APAD.Prepay_History_ID = p_prepay_hist_rec.prepay_history_id
583: AND APAD.Invoice_Distribution_ID = l_inv_dist_rec.invoice_distribution_id
584: AND Rownum = 1;

Line 1585: l_max_prepay_rec AP_PREPAY_APP_DISTS%ROWTYPE;

1581: l_td_diff_prepay_rate_amt NUMBER;
1582: l_td_diff_prepay_pay_rate_amt NUMBER;
1583: l_td_diff_prepay_clr_rate_amt NUMBER;
1584:
1585: l_max_prepay_rec AP_PREPAY_APP_DISTS%ROWTYPE;
1586: l_pad_rec AP_PREPAY_APP_DISTS%ROWTYPE;
1587:
1588: -- Logging Infra:
1589: l_procedure_name CONSTANT VARCHAR2(30) := 'Total_Appl';

Line 1586: l_pad_rec AP_PREPAY_APP_DISTS%ROWTYPE;

1582: l_td_diff_prepay_pay_rate_amt NUMBER;
1583: l_td_diff_prepay_clr_rate_amt NUMBER;
1584:
1585: l_max_prepay_rec AP_PREPAY_APP_DISTS%ROWTYPE;
1586: l_pad_rec AP_PREPAY_APP_DISTS%ROWTYPE;
1587:
1588: -- Logging Infra:
1589: l_procedure_name CONSTANT VARCHAR2(30) := 'Total_Appl';
1590: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 1607: FROM AP_Prepay_App_Dists APAD

1603:
1604: -- Get the max of the largest distribution for inserting the rounding line
1605: SELECT APAD.*
1606: INTO l_max_prepay_rec
1607: FROM AP_Prepay_App_Dists APAD
1608: WHERE Prepay_App_Distribution_ID = p_prepay_dist_rec.invoice_distribution_id
1609: AND APAD.Prepay_History_ID = p_prepay_hist_rec.prepay_history_id
1610: AND Invoice_Distribution_ID =
1611: (SELECT MAX(APAD1.Invoice_Distribution_ID)

Line 1612: FROM AP_Prepay_App_Dists APAD1

1608: WHERE Prepay_App_Distribution_ID = p_prepay_dist_rec.invoice_distribution_id
1609: AND APAD.Prepay_History_ID = p_prepay_hist_rec.prepay_history_id
1610: AND Invoice_Distribution_ID =
1611: (SELECT MAX(APAD1.Invoice_Distribution_ID)
1612: FROM AP_Prepay_App_Dists APAD1
1613: WHERE APAD1.Prepay_App_Distribution_ID =
1614: p_prepay_dist_rec.invoice_distribution_id
1615: AND APAD1.Prepay_History_ID = p_prepay_hist_rec.prepay_history_id
1616: AND ABS(APAD1.Amount) =

Line 1618: FROM AP_Prepay_App_Dists APAD2

1614: p_prepay_dist_rec.invoice_distribution_id
1615: AND APAD1.Prepay_History_ID = p_prepay_hist_rec.prepay_history_id
1616: AND ABS(APAD1.Amount) =
1617: (SELECT MAX(ABS(APAD2.Amount))
1618: FROM AP_Prepay_App_Dists APAD2
1619: WHERE APAD2.Prepay_App_Distribution_ID =
1620: p_prepay_dist_rec.invoice_distribution_id
1621: AND APAD2.Prepay_History_ID = p_prepay_hist_rec.prepay_history_id))
1622: AND Rownum = 1;

Line 1741: FROM AP_Prepay_App_Dists APAD

1737: l_td_sum_inv_rate_amt,
1738: l_td_sum_prepay_rate_amt,
1739: l_td_sum_prepay_pay_rate_amt,
1740: l_td_sum_prepay_clr_rate_amt
1741: FROM AP_Prepay_App_Dists APAD
1742: WHERE APAD.Prepay_App_Distribution_ID = p_prepay_dist_rec.invoice_distribution_id;
1743:
1744:
1745: /* If there is difference between the total and sum amounts then we will insert the

Line 1773: UPDATE AP_Prepay_App_Dists APPD

1769: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1770: END IF;
1771:
1772:
1773: UPDATE AP_Prepay_App_Dists APPD
1774: SET Base_Amount = Base_Amount + NVL(l_diff_inv_rate_amt,0),
1775: Rounding_Amt = l_diff_inv_rate_amt,
1776: Base_Amt_At_Prepay_XRate = Base_Amt_At_Prepay_XRate
1777: + NVL(l_diff_prepay_rate_amt,0),

Line 1811: UPDATE AP_Prepay_App_Dists APPD

1807: l_log_msg := 'Updating tax diff rounding amount';
1808: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1809: END IF;
1810:
1811: UPDATE AP_Prepay_App_Dists APPD
1812: SET Base_Amount = Base_Amount + NVL(l_td_diff_inv_rate_amt,0),
1813: Rounding_Amt = l_td_diff_inv_rate_amt,
1814: Base_Amt_At_Prepay_XRate = Base_Amt_At_Prepay_XRate
1815: + NVL(l_td_diff_prepay_rate_amt,0),

Line 1889: l_max_prepay_rec AP_PREPAY_APP_DISTS%ROWTYPE;

1885: l_diff_prepay_rate_amt NUMBER;
1886: l_diff_prepay_pay_rate_amt NUMBER;
1887: l_diff_prepay_clr_rate_amt NUMBER;
1888:
1889: l_max_prepay_rec AP_PREPAY_APP_DISTS%ROWTYPE;
1890: l_pad_rec AP_PREPAY_APP_DISTS%ROWTYPE;
1891:
1892: -- Logging Infra:
1893: l_procedure_name CONSTANT VARCHAR2(30) := 'Final_Appl';

Line 1890: l_pad_rec AP_PREPAY_APP_DISTS%ROWTYPE;

1886: l_diff_prepay_pay_rate_amt NUMBER;
1887: l_diff_prepay_clr_rate_amt NUMBER;
1888:
1889: l_max_prepay_rec AP_PREPAY_APP_DISTS%ROWTYPE;
1890: l_pad_rec AP_PREPAY_APP_DISTS%ROWTYPE;
1891:
1892: -- Logging Infra:
1893: l_procedure_name CONSTANT VARCHAR2(30) := 'Final_Appl';
1894: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 1910: FROM AP_Prepay_App_Dists APAD

1906:
1907: -- Getting the max of the largest distribution for inserting the rounding dist
1908: SELECT APAD.*
1909: INTO l_max_prepay_rec
1910: FROM AP_Prepay_App_Dists APAD
1911: WHERE Invoice_Distribution_ID IN
1912: (SELECT MAX(APAD1.Invoice_Distribution_ID)
1913: FROM AP_Prepay_App_Dists APAD1
1914: WHERE APAD1.Prepay_App_Distribution_ID = p_prepay_dist_rec.invoice_distribution_id

Line 1913: FROM AP_Prepay_App_Dists APAD1

1909: INTO l_max_prepay_rec
1910: FROM AP_Prepay_App_Dists APAD
1911: WHERE Invoice_Distribution_ID IN
1912: (SELECT MAX(APAD1.Invoice_Distribution_ID)
1913: FROM AP_Prepay_App_Dists APAD1
1914: WHERE APAD1.Prepay_App_Distribution_ID = p_prepay_dist_rec.invoice_distribution_id
1915: AND APAD1.Prepay_History_ID = p_prepay_hist_rec.prepay_history_id
1916: AND ABS(APAD1.Amount) =
1917: (SELECT MAX(ABS(APAD2.Amount))

Line 1918: FROM AP_Prepay_App_Dists APAD2

1914: WHERE APAD1.Prepay_App_Distribution_ID = p_prepay_dist_rec.invoice_distribution_id
1915: AND APAD1.Prepay_History_ID = p_prepay_hist_rec.prepay_history_id
1916: AND ABS(APAD1.Amount) =
1917: (SELECT MAX(ABS(APAD2.Amount))
1918: FROM AP_Prepay_App_Dists APAD2
1919: WHERE APAD2.Prepay_App_Distribution_ID = p_prepay_dist_rec.invoice_distribution_id
1920: AND APAD2.Prepay_History_ID = p_prepay_hist_rec.prepay_history_id))
1921: AND APAD.Prepay_App_Distribution_ID = p_prepay_dist_rec.invoice_distribution_id
1922: AND APAD.Prepay_History_ID = p_prepay_hist_rec.prepay_history_id

Line 1963: FROM AP_Prepay_App_Dists

1959: SUM(Base_Amt_At_Prepay_Clr_XRate)
1960: INTO l_sum_prepay_rate_amt,
1961: l_sum_prepay_pay_rate_amt,
1962: l_sum_prepay_clr_rate_amt
1963: FROM AP_Prepay_App_Dists
1964: WHERE Prepay_App_Distribution_ID IN
1965: (SELECT AID.Invoice_Distribution_ID
1966: FROM AP_Invoice_Distributions_All AID
1967: WHERE AID.Prepay_Distribution_ID = p_prepay_dist_rec.prepay_distribution_id);