DBA Data[Home] [Help]

APPS.AP_PREPAY_PKG dependencies on STANDARD

Line 786: -- Get the Invoice Amount Remaining for the standard invoice.

782: l_invoice_amount_remaining NUMBER;
783: l_prepay_amount_remaining NUMBER;
784:
785: BEGIN
786: -- Get the Invoice Amount Remaining for the standard invoice.
787: -- This is the unpaid amount. Since we are importing the invoice
788: -- there is no posibility of partial payment of the invoice, so
789: -- there is no need to verify the payment_status flag.
790:

Line 1413: -- Standard Invoice Related Variables

1409: IS
1410:
1411: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
1412:
1413: -- Standard Invoice Related Variables
1414: l_std_inv_batch_id ap_invoices_all.batch_id%TYPE;
1415: l_std_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1416: l_std_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1417: l_std_inv_xdate ap_invoices_all.exchange_date%TYPE;

Line 1659: -- Step 1: Get Required Information from the STANDARD INVOICE

1655:
1656: CLOSE C_SYS_PARAMS;
1657:
1658: -- ==========================================================
1659: -- Step 1: Get Required Information from the STANDARD INVOICE
1660: -- ==========================================================
1661:
1662: l_debug_info := 'Get Required Information from the STANDARD INVOICE';
1663: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1662: l_debug_info := 'Get Required Information from the STANDARD INVOICE';

1658: -- ==========================================================
1659: -- Step 1: Get Required Information from the STANDARD INVOICE
1660: -- ==========================================================
1661:
1662: l_debug_info := 'Get Required Information from the STANDARD INVOICE';
1663: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1664: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1665: END IF;
1666:

Line 1783: -- calculated using the Standard Invoice XRATE.

1779: -- Step 6: Get Line Level Apply Base Amount
1780: -- This base amount will be the base amount of the
1781: -- PREPAY line that will be created as a result of
1782: -- this application. This base amount will be
1783: -- calculated using the Standard Invoice XRATE.
1784: -- ==========================================================
1785: l_debug_info := 'Get Line Level Apply Base Amount';
1786: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1787: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 1890: -- STANDARD Invoice if performing 'Prepayment Application'

1886: END IF;
1887:
1888: -- ==========================================================
1889: -- Step 8: Get Next Line Number for the PREPAY Line from the
1890: -- STANDARD Invoice if performing 'Prepayment Application'
1891: -- not for 'Recoupment'.
1892: -- ==========================================================
1893:
1894: l_debug_info := 'Get Next Line Number for the PREPAY Line from the '||

Line 1895: 'STANDARD Invoice';

1891: -- not for 'Recoupment'.
1892: -- ==========================================================
1893:
1894: l_debug_info := 'Get Next Line Number for the PREPAY Line from the '||
1895: 'STANDARD Invoice';
1896: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1897: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1898: END IF;
1899:

Line 2047: -- the standard invoice.

2043: -- ==========================================================
2044:
2045: -- ==========================================================
2046: -- Step 13.1: Get maximum distribution line number from
2047: -- the standard invoice.
2048: -- ==========================================================
2049:
2050: l_debug_info := 'Get maximum distribution line number from '||
2051: 'the standard invoice';

Line 2051: 'the standard invoice';

2047: -- the standard invoice.
2048: -- ==========================================================
2049:
2050: l_debug_info := 'Get maximum distribution line number from '||
2051: 'the standard invoice';
2052: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2053: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2054: END IF;
2055:

Line 2216: --be part of the same ITEM line on the Standard invoice which is recouping.

2212: --Proration for both exclusive and inclusive tax cases, since
2213: --for recoupment regardless of how the tax was calculated on the
2214: --parent Item line on the Prepayment invoice, when recouping
2215: --the Prepay dists as well as tax tied to those distributions will
2216: --be part of the same ITEM line on the Standard invoice which is recouping.
2217:
2218: l_prepay_dist_info(l_loop_counter).PREPAY_APPLY_AMOUNT :=
2219: (l_prepay_dist_info(l_loop_counter).PPAY_AMOUNT_REMAINING/
2220: l_ppay_ln_amount_remaining) *

Line 2257: -- Get the Base Amount at the Standard Invoice Exchange Rate

2253: l_prepay_dist_info(l_loop_variable).PREPAY_DIST_LINE_NUMBER :=
2254: l_max_dist_number + l_dist_line_counter;
2255: l_dist_line_counter := l_dist_line_counter+1;
2256:
2257: -- Get the Base Amount at the Standard Invoice Exchange Rate
2258:
2259: IF (l_std_inv_curr_code <> l_base_currency_code) THEN
2260: IF l_std_inv_xrate_type = 'User' THEN
2261: l_prepay_dist_info(l_loop_variable).PREPAY_BASE_AMOUNT :=

Line 2465: -- is the Standard Invoice. This is valid only in the

2461:
2462: -- ===========================================================
2463: -- Step 16: Update line amount total if there is a diff of tax
2464: -- rate or tax recovery rate and the calculation point
2465: -- is the Standard Invoice. This is valid only in the
2466: -- inclusive case.
2467: -- ===========================================================
2468: l_debug_info := 'Update parent PREPAY line amount if required';
2469: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2715: -- point for the tax is the standard invoice.

2711:
2712: --COMMENT!!!!!!This comment is for who is going to modify latter on the
2713: -- final application rounding. The l_apply_amount at this moment includes
2714: -- any tax difference etax has returned in the case the calculation
2715: -- point for the tax is the standard invoice.
2716: -- IF (l_apply_amount = l_ppay_ln_amount_remaining) THEN
2717: -- l_final_application := 'Y';
2718: -- END IF;
2719:

Line 3849: -- is the standard invoice the prepay_tax_diff_amount will include any

3845: END LOOP;
3846:
3847: -- Update prepay_amount_remaining for tax distributions.
3848: -- In the case the tax calculation point for the prepayment application
3849: -- is the standard invoice the prepay_tax_diff_amount will include any
3850: -- tax difference included, so that amount needs to be reduced from the
3851: -- distribution amount from the standard invoice tax distributions
3852:
3853: IF (p_calling_mode = 'PREPAYMENT APPLICATION') THEN

Line 3851: -- distribution amount from the standard invoice tax distributions

3847: -- Update prepay_amount_remaining for tax distributions.
3848: -- In the case the tax calculation point for the prepayment application
3849: -- is the standard invoice the prepay_tax_diff_amount will include any
3850: -- tax difference included, so that amount needs to be reduced from the
3851: -- distribution amount from the standard invoice tax distributions
3852:
3853: IF (p_calling_mode = 'PREPAYMENT APPLICATION') THEN
3854:
3855: l_debug_info := 'Update prepayment_amt_remaining: '|| ' Invoice ID: '||p_prepay_invoice_id