DBA Data[Home] [Help]

APPS.AP_INVOICE_DISTRIBUTIONS_PKG dependencies on AP_UTILITIES_PKG

Line 1615: ap_utilities_pkg.ap_round_currency(

1611: UPDATE AP_INVOICE_DISTRIBUTIONS_ALL
1612: SET base_amount =
1613: DECODE(l_base_currency_code,
1614: l_invoice_currency_code, NULL,
1615: ap_utilities_pkg.ap_round_currency(
1616: amount * l_exchange_rate,
1617: l_base_currency_code)),
1618: last_update_login = l_last_update_login,
1619: last_updated_by = l_last_updated_by,

Line 1627: ap_utilities_pkg.ap_round_currency(

1623: AND NVL(posted_flag,'N') = 'N'
1624: AND ( ( base_amount is null AND
1625: DECODE(l_base_currency_code,
1626: l_invoice_currency_code, NULL,
1627: ap_utilities_pkg.ap_round_currency(
1628: amount * l_exchange_rate,
1629: l_base_currency_code)) is not null)
1630: OR
1631: (NVL(base_amount,0) <>

Line 1634: ap_utilities_pkg.ap_round_currency(

1630: OR
1631: (NVL(base_amount,0) <>
1632: DECODE(l_base_currency_code,
1633: l_invoice_currency_code, NULL,
1634: ap_utilities_pkg.ap_round_currency(
1635: amount * l_exchange_rate,
1636: l_base_currency_code))
1637: AND NVL(reversal_flag,'N') <> 'Y' --Bug 8347194
1638: ))

Line 3982: l_invoice_attribute_rec AP_UTILITIES_PKG.r_invoice_attribute_rec; --bug 8713737

3978: AND line_number = X_line_number;
3979:
3980:
3981: l_invoice_line_rec AP_INVOICES_PKG.r_invoice_line_rec;
3982: l_invoice_attribute_rec AP_UTILITIES_PKG.r_invoice_attribute_rec; --bug 8713737
3983:
3984: l_distribution_class
3985: AP_INVOICE_DISTRIBUTIONS.DISTRIBUTION_CLASS%TYPE;
3986: l_dist_ccid

Line 4207: AP_UTILITIES_PKG.GET_CURRENT_GL_DATE(

4203: BEGIN
4204: l_open_period_name := NULL;
4205:
4206: l_open_period_name :=
4207: AP_UTILITIES_PKG.GET_CURRENT_GL_DATE(
4208: l_invoice_line_rec.accounting_date,
4209: l_invoice_line_rec.org_id);
4210:
4211: IF (l_open_period_name is NULL) then

Line 4212: AP_UTILITIES_PKG.GET_OPEN_GL_DATE(l_invoice_line_rec.accounting_date,

4208: l_invoice_line_rec.accounting_date,
4209: l_invoice_line_rec.org_id);
4210:
4211: IF (l_open_period_name is NULL) then
4212: AP_UTILITIES_PKG.GET_OPEN_GL_DATE(l_invoice_line_rec.accounting_date,
4213: l_open_period_name,
4214: l_open_gl_date);
4215: --Invoice Lines: Distributions
4216: --For the case when the accounting_date on the line fell in an open

Line 4444: IF ( NOT (AP_UTILITIES_PKG.pa_flexbuild(

4440: -- there is PA_FLEXBUILD
4441:
4442: debug_info := 'Billable Flag To PA FlexBuild '||l_billable_flag; --Bug6523162
4443:
4444: IF ( NOT (AP_UTILITIES_PKG.pa_flexbuild(
4445: p_vendor_id => X_vendor_id, --IN
4446: p_employee_id => l_employee_id, --IN
4447: p_set_of_books_id =>
4448: l_invoice_line_rec.set_of_books_id, --IN

Line 4491: IF ( NOT (AP_UTILITIES_PKG.IS_CCID_VALID(

4487: RETURN(FALSE);
4488: END IF;
4489:
4490: IF (l_pa_allows_overrides = 'N') then
4491: IF ( NOT (AP_UTILITIES_PKG.IS_CCID_VALID(
4492: l_dist_ccid,
4493: l_chart_of_accounts_id,
4494: l_open_gl_date,
4495: current_calling_sequence))) then

Line 4509: IF ( NOT (AP_UTILITIES_PKG.IS_CCID_VALID(

4505: IF (l_invoice_line_rec.overlay_dist_code_concat is NULL AND
4506: l_invoice_line_rec.balancing_segment is NULL AND
4507: l_invoice_line_rec.account_segment is NULL AND
4508: l_invoice_line_rec.cost_center_segment is NULL) then
4509: IF ( NOT (AP_UTILITIES_PKG.IS_CCID_VALID(
4510: l_dist_ccid,
4511: l_chart_of_accounts_id,
4512: l_open_gl_date,
4513: current_calling_sequence))) then

Line 4518: IF ( NOT (AP_UTILITIES_PKG.OVERLAY_SEGMENTS (

4514: X_error_code := 'AP_INVALID_ACCOUNT';
4515: RETURN(FALSE);
4516: END IF;
4517: ELSE
4518: IF ( NOT (AP_UTILITIES_PKG.OVERLAY_SEGMENTS (
4519: l_invoice_line_rec.balancing_segment,
4520: l_invoice_line_rec.cost_center_segment,
4521: l_invoice_line_rec.account_segment,
4522: l_invoice_line_rec.overlay_dist_code_concat,

Line 4546: IF ( NOT (AP_UTILITIES_PKG.IS_CCID_VALID(

4542: IF (l_invoice_line_rec.overlay_dist_code_concat is NULL AND
4543: l_invoice_line_rec.balancing_segment is NULL AND
4544: l_invoice_line_rec.account_segment is NULL AND
4545: l_invoice_line_rec.cost_center_segment is NULL) then
4546: IF ( NOT (AP_UTILITIES_PKG.IS_CCID_VALID(
4547: l_dist_ccid,
4548: l_chart_of_accounts_id,
4549: l_open_gl_date,
4550: current_calling_sequence))) THEN

Line 4555: IF ( NOT (AP_UTILITIES_PKG.OVERLAY_SEGMENTS (

4551: X_error_code := 'AP_INVALID_ACCOUNT';
4552: RETURN(FALSE);
4553: END IF;
4554: ELSE
4555: IF ( NOT (AP_UTILITIES_PKG.OVERLAY_SEGMENTS (
4556: l_invoice_line_rec.balancing_segment,
4557: l_invoice_line_rec.cost_center_segment,
4558: l_invoice_line_rec.account_segment,
4559: l_invoice_line_rec.overlay_dist_code_concat,

Line 4652: l_invoice_line_rec.base_amount := ap_utilities_pkg.ap_round_currency(

4648: --bug6653070
4649:
4650: /*l_invoice_line_rec.amount := l_invoice_line_rec.amount -
4651: NVL(l_invoice_line_rec.included_tax_amount,0);*/
4652: l_invoice_line_rec.base_amount := ap_utilities_pkg.ap_round_currency(
4653: l_invoice_line_rec.amount * x_exchange_rate,
4654: l_base_currency_code);
4655:
4656: ----------------------------------------------------------------------------

Line 5392: AP_UTILITIES_PKG.GET_CURRENT_GL_DATE(

5388: BEGIN
5389: l_open_period_name := NULL;
5390:
5391: l_open_period_name :=
5392: AP_UTILITIES_PKG.GET_CURRENT_GL_DATE(
5393: l_invoice_line_rec.accounting_date,
5394: l_invoice_line_rec.org_id);
5395:
5396: IF (l_open_period_name is NULL) then

Line 5397: AP_UTILITIES_PKG.GET_OPEN_GL_DATE(l_invoice_line_rec.accounting_date,

5393: l_invoice_line_rec.accounting_date,
5394: l_invoice_line_rec.org_id);
5395:
5396: IF (l_open_period_name is NULL) then
5397: AP_UTILITIES_PKG.GET_OPEN_GL_DATE(l_invoice_line_rec.accounting_date,
5398: l_open_period_name,
5399: l_open_gl_date);
5400: --Invoice Lines: Distributions
5401: --For the case when the accounting_date on the line fell in an open

Line 5496: l_invoice_line_rec.base_amount := ap_utilities_pkg.ap_round_currency(

5492: ---------------------------------------------------------------------------
5493:
5494: debug_info := 'Before Calc Inv line base amount'||l_invoice_line_rec.amount ||'Xrate '|| x_exchange_rate ||'l_base_currency_code '||l_base_currency_code;
5495:
5496: l_invoice_line_rec.base_amount := ap_utilities_pkg.ap_round_currency(
5497: l_invoice_line_rec.amount * x_exchange_rate,
5498: l_base_currency_code);
5499:
5500: debug_info := 'After Calc Inv line base amount'||l_invoice_line_rec.amount ||'Xrate ' || x_exchange_rate ||'l_base_currency_code '||l_base_currency_code;

Line 5771: , ap_utilities_pkg.ap_round_currency

5767: , NULL accounting_event_id
5768: , NULL upgrade_posted_amt
5769: , NULL upgrade_base_posted_amt
5770: , l_invoice_line_rec.set_of_books_id set_of_books_id
5771: , ap_utilities_pkg.ap_round_currency
5772: (l_invoice_line_rec.amount * aid.amount / l_dist_total
5773: , X_invoice_currency) amount
5774: , DECODE(X_exchange_rate_type
5775: , NULL , NULL

Line 5776: , ap_utilities_pkg.ap_round_currency(

5772: (l_invoice_line_rec.amount * aid.amount / l_dist_total
5773: , X_invoice_currency) amount
5774: , DECODE(X_exchange_rate_type
5775: , NULL , NULL
5776: , ap_utilities_pkg.ap_round_currency(
5777: (l_invoice_line_rec.amount * aid.amount / l_dist_total) * X_exchange_rate
5778: , X_invoice_currency)) base_amount
5779: , 0 rounding_amt
5780: , NULL quantity_variance

Line 6108: l_invoice_attribute_rec AP_UTILITIES_PKG.r_invoice_attribute_rec; --bug 8713737

6104: l_sys_link_function VARCHAR2(2); /* Bug 5102724 */
6105: l_web_parameter_id number; --Bug5003249
6106: l_employee_ccid number;
6107: l_message_text fnd_new_messages.message_text%TYPE;
6108: l_invoice_attribute_rec AP_UTILITIES_PKG.r_invoice_attribute_rec; --bug 8713737
6109:
6110: BEGIN
6111:
6112: -------------------------------------------------------------------

Line 6372: -- l_dist_ccid := AP_UTILITIES_PKG.PA_FLEXBUILD

6368: ----------------------------------------------------------------------------
6369: --Bug5003249 added condition on invoice type lookup code
6370: IF (X_project_id IS NOT NULL AND X_item_dist_project_id IS NULL
6371: AND l_invoice_type_lookup_code<>'PREPAYMENT') THEN
6372: -- l_dist_ccid := AP_UTILITIES_PKG.PA_FLEXBUILD
6373:
6374: debug_info := 'Billable Flag To PA FlexBuild '||l_billable_flag; --Bug6523162
6375:
6376: IF ( NOT (AP_UTILITIES_PKG.pa_flexbuild(

Line 6376: IF ( NOT (AP_UTILITIES_PKG.pa_flexbuild(

6372: -- l_dist_ccid := AP_UTILITIES_PKG.PA_FLEXBUILD
6373:
6374: debug_info := 'Billable Flag To PA FlexBuild '||l_billable_flag; --Bug6523162
6375:
6376: IF ( NOT (AP_UTILITIES_PKG.pa_flexbuild(
6377: p_vendor_id => X_vendor_id, --IN
6378: p_employee_id => l_employee_id, --IN
6379: p_set_of_books_id => X_sob_id, --IN
6380: p_chart_of_accounts_id => X_chart_of_accounts_id, -- IN

Line 6416: IF ( NOT (AP_UTILITIES_PKG.OVERLAY_SEGMENTS (

6412: X_balancing_segment IS NOT NULL OR
6413: X_account_segment IS NOT NULL OR
6414: X_cost_center_segment IS NOT NULL)) THEN
6415:
6416: IF ( NOT (AP_UTILITIES_PKG.OVERLAY_SEGMENTS (
6417: X_balancing_segment,
6418: X_cost_center_segment,
6419: X_account_segment,
6420: X_overlay_dist_code_concat,

Line 6470: IF ( NOT (AP_UTILITIES_PKG.OVERLAY_SEGMENTS (

6466: X_cost_center_segment IS NOT NULL)
6467:
6468: ) THEN
6469:
6470: IF ( NOT (AP_UTILITIES_PKG.OVERLAY_SEGMENTS (
6471: X_balancing_segment,
6472: X_cost_center_segment,
6473: X_account_segment,
6474: X_overlay_dist_code_concat,

Line 6491: IF ( NOT (AP_UTILITIES_PKG.IS_CCID_VALID(

6487: RETURN(FALSE);
6488: END IF;
6489:
6490: ELSE
6491: IF ( NOT (AP_UTILITIES_PKG.IS_CCID_VALID(
6492: l_dist_ccid,
6493: X_chart_of_accounts_id,
6494: X_GL_date,
6495: 'Create Charge Account'))) THEN

Line 6509: IF ( NOT (AP_UTILITIES_PKG.OVERLAY_SEGMENTS (

6505: X_balancing_segment IS NOT NULL OR
6506: X_account_segment IS NOT NULL OR
6507: X_cost_center_segment IS NOT NULL) THEN
6508:
6509: IF ( NOT (AP_UTILITIES_PKG.OVERLAY_SEGMENTS (
6510: X_balancing_segment,
6511: X_cost_center_segment,
6512: X_account_segment,
6513: X_overlay_dist_code_concat,

Line 6529: IF ( NOT (AP_UTILITIES_PKG.IS_CCID_VALID(l_dist_ccid,

6525: X_error_code := 'AP_CANNOT_OVERLAY';
6526: RETURN(FALSE);
6527: END IF;
6528: ELSE
6529: IF ( NOT (AP_UTILITIES_PKG.IS_CCID_VALID(l_dist_ccid,
6530: X_chart_of_accounts_id,
6531: X_GL_date,
6532: 'Create Charge Account'))) then
6533: X_error_code := 'AP_INVALID_ACCOUNT';

Line 7163: l_open_period_name := AP_UTILITIES_PKG.GET_CURRENT_GL_DATE(

7159: debug_info :=
7160: 'Get gl date from open period if line gl date is in a closed one';
7161: BEGIN
7162: l_open_period_name := NULL;
7163: l_open_period_name := AP_UTILITIES_PKG.GET_CURRENT_GL_DATE(
7164: l_accounting_date,
7165: l_org_id);
7166:
7167: IF (l_open_period_name is NULL) then

Line 7168: AP_UTILITIES_PKG.GET_OPEN_GL_DATE(l_accounting_date, l_open_period_name,

7164: l_accounting_date,
7165: l_org_id);
7166:
7167: IF (l_open_period_name is NULL) then
7168: AP_UTILITIES_PKG.GET_OPEN_GL_DATE(l_accounting_date, l_open_period_name,
7169: l_open_gl_date,l_org_id);
7170: --Invoice Lines: Distributions, added the ELSE part of the IF condition
7171: ELSE
7172: l_open_gl_date := l_accounting_date;

Line 7243: AP_UTILITIES_PKG.Ap_Round_Currency(

7239:
7240: FOR t IN 0..l_alloc_line_tab.COUNT-1
7241: LOOP
7242: l_alloc_line_tab(t).amount :=
7243: AP_UTILITIES_PKG.Ap_Round_Currency(
7244: (l_alloc_line_tab(t).amount * l_line_amount) /
7245: l_sum_applic_lines,
7246: l_invoice_currency_code);
7247: IF (ABS(l_alloc_line_tab(t).amount) >= ABS(nvl(l_max_alloc,0)) OR

Line 7303: AP_UTILITIES_PKG.Ap_Round_Currency(

7299: l_alloc_line_tab(t).invoice_line_number :=
7300: l_alloc_rule_line_number;
7301: l_alloc_line_tab(t).percentage := l_alloc_rule_line_percent;
7302: l_alloc_line_tab(t).amount :=
7303: AP_UTILITIES_PKG.Ap_Round_Currency(
7304: (l_line_amount * l_alloc_rule_line_percent) / 100,
7305: l_invoice_currency_code);
7306: l_alloc_line_tab(t).sum_amount_dists := l_sum_dists_applic_line;
7307:

Line 7460: AP_UTILITIES_PKG.Ap_Round_Currency(

7456: l_dist_tab(i).attribute15 := NULL;
7457: l_dist_tab(i).type_1099 := l_type_1099;
7458: l_dist_tab(i).income_tax_region := l_income_tax_region;
7459: l_dist_tab(i).amount:=
7460: AP_UTILITIES_PKG.Ap_Round_Currency(
7461: (l_alloc_line_tab(t).amount * l_dist_amount) /
7462: l_alloc_line_tab(t).sum_amount_dists,
7463: l_invoice_currency_code);
7464: l_dist_tab(i).base_amount :=

Line 7465: AP_UTILITIES_PKG.Ap_Round_Currency(

7461: (l_alloc_line_tab(t).amount * l_dist_amount) /
7462: l_alloc_line_tab(t).sum_amount_dists,
7463: l_invoice_currency_code);
7464: l_dist_tab(i).base_amount :=
7465: AP_UTILITIES_PKG.Ap_Round_Currency(
7466: NVL(l_dist_tab(i).amount, 0) * l_exchange_rate ,
7467: l_base_currency_code);
7468: l_dist_tab(i).rounding_amt := 0;
7469:

Line 7586: AP_UTILITIES_PKG.Ap_Round_Currency(

7582: l_running_total_alloc);
7583: l_running_total_base_amt := l_running_total_base_amt -
7584: l_dist_tab(l_max_I).base_amount;
7585: l_dist_tab(l_max_i).base_amount :=
7586: AP_UTILITIES_PKG.Ap_Round_Currency(
7587: NVL(l_dist_tab(l_max_i).amount, 0) * l_exchange_rate ,
7588: l_base_currency_code);
7589: l_running_total_base_amt := l_running_total_base_amt +
7590: l_dist_tab(l_max_i).base_amount;

Line 8589: l_original_dist_base_amt := AP_UTILITIES_PKG.ap_round_currency(

8585:
8586: /* l_original_dist_base_amt := l_dist_base_amt + NVL(x_bipv, 0)
8587: + NVL(x_erv, 0); */
8588:
8589: l_original_dist_base_amt := AP_UTILITIES_PKG.ap_round_currency(
8590: ((l_distribution_amt+NVL(x_ipv, 0))*l_inv_rate)
8591: ,l_base_currency_code);
8592: l_original_dist_amt := l_distribution_amt + NVL(x_ipv, 0);
8593:

Line 8616: l_original_dist_base_amt := AP_UTILITIES_PKG.ap_round_currency(

8612: --for Bug 16029169
8613:
8614: /* l_original_dist_base_amt := l_dist_base_amt; */
8615:
8616: l_original_dist_base_amt := AP_UTILITIES_PKG.ap_round_currency(
8617: (l_distribution_amt*l_inv_rate)
8618: ,l_base_currency_code);
8619: l_original_dist_amt := l_distribution_amt;
8620:

Line 8658: x_erv := AP_UTILITIES_PKG.ap_round_currency(

8654:
8655: IF (l_rate_diff = 0) THEN
8656: x_erv := 0;
8657: ELSE
8658: x_erv := AP_UTILITIES_PKG.ap_round_currency(
8659: l_corrected_qty * l_po_price *
8660: l_rate_diff
8661: ,l_base_currency_code);
8662: END IF;

Line 8664: x_ipv := AP_UTILITIES_PKG.ap_round_currency(

8660: l_rate_diff
8661: ,l_base_currency_code);
8662: END IF;
8663:
8664: x_ipv := AP_UTILITIES_PKG.ap_round_currency(
8665: l_corrected_qty * l_price_diff
8666: ,l_inv_currency_code);
8667:
8668: IF (x_ipv = 0) THEN

Line 8673: /* x_bipv := AP_UTILITIES_PKG.ap_round_currency(

8669: x_bipv := 0;
8670: ELSE
8671: -- Bug 5484167 base invoice price variance should be calculated directly from the invoice price variance
8672: --to avoid incorrect rounding logic
8673: /* x_bipv := AP_UTILITIES_PKG.ap_round_currency(
8674: l_corrected_qty * l_inv_rate * l_price_diff
8675: , l_base_currency_code);*/
8676: x_bipv := AP_UTILITIES_PKG.ap_round_currency(x_ipv * l_inv_rate, l_base_currency_code);
8677:

Line 8676: x_bipv := AP_UTILITIES_PKG.ap_round_currency(x_ipv * l_inv_rate, l_base_currency_code);

8672: --to avoid incorrect rounding logic
8673: /* x_bipv := AP_UTILITIES_PKG.ap_round_currency(
8674: l_corrected_qty * l_inv_rate * l_price_diff
8675: , l_base_currency_code);*/
8676: x_bipv := AP_UTILITIES_PKG.ap_round_currency(x_ipv * l_inv_rate, l_base_currency_code);
8677:
8678: END IF;
8679: --Bug#10416960
8680: --Line_source condition is need when running cadip 2nd time for same PO

Line 8688: x_erv := AP_UTILITIES_PKG.ap_round_currency(

8684:
8685: IF (l_rate_diff = 0) THEN
8686: x_erv := 0;
8687: ELSE
8688: x_erv := AP_UTILITIES_PKG.ap_round_currency(
8689: l_corrected_qty * l_inv_price *
8690: l_rate_diff
8691: ,l_base_currency_code);
8692: END IF;

Line 8710: x_erv := AP_UTILITIES_PKG.ap_round_Currency( l_original_dist_amt *

8706: where D.invoice_distribution_id = l_corrected_inv_dist_id
8707: and D.invoice_id = AI.invoice_id;
8708:
8709: /* Modified below statement for bug#14360581
8710: x_erv := AP_UTILITIES_PKG.ap_round_Currency( l_original_dist_amt *
8711: (l_corrected_inv_rate - l_inv_rate)
8712: , l_base_currency_code); */
8713:
8714: x_erv := AP_UTILITIES_PKG.ap_round_Currency( l_original_dist_amt *

Line 8714: x_erv := AP_UTILITIES_PKG.ap_round_Currency( l_original_dist_amt *

8710: x_erv := AP_UTILITIES_PKG.ap_round_Currency( l_original_dist_amt *
8711: (l_corrected_inv_rate - l_inv_rate)
8712: , l_base_currency_code); */
8713:
8714: x_erv := AP_UTILITIES_PKG.ap_round_Currency( l_original_dist_amt *
8715: ( l_inv_rate - l_corrected_inv_rate)
8716: , l_base_currency_code);
8717: x_ipv := 0;
8718: x_bipv := 0;

Line 8733: x_erv := AP_UTILITIES_PKG.ap_round_currency(

8729: IF (l_rate_diff = 0) THEN
8730: x_erv := 0;
8731: ELSE
8732: IF l_cnt = 0 then --bug 9242891
8733: x_erv := AP_UTILITIES_PKG.ap_round_currency(
8734: l_qty_invoiced * l_po_price * l_rate_diff
8735: ,l_base_currency_code);
8736: ELSE
8737: x_erv := AP_UTILITIES_PKG.ap_round_currency(

Line 8737: x_erv := AP_UTILITIES_PKG.ap_round_currency(

8733: x_erv := AP_UTILITIES_PKG.ap_round_currency(
8734: l_qty_invoiced * l_po_price * l_rate_diff
8735: ,l_base_currency_code);
8736: ELSE
8737: x_erv := AP_UTILITIES_PKG.ap_round_currency(
8738: l_original_dist_amt * l_rate_diff
8739: ,l_base_currency_code);
8740: END IF;
8741: END IF;

Line 8748: x_ipv := AP_UTILITIES_PKG.ap_round_currency(

8744: IF (l_price_diff = 0) THEN
8745: x_ipv := 0;
8746: x_bipv := 0;
8747: ELSE
8748: x_ipv := AP_UTILITIES_PKG.ap_round_currency(
8749: l_qty_invoiced * l_price_diff
8750: , l_inv_currency_code );
8751:
8752: IF (x_ipv = 0) THEN

Line 8757: /* x_bipv := AP_UTILITIES_PKG.ap_round_currency(

8753: x_bipv := 0;
8754: ELSE
8755: -- Bug 5484167 base invoice price variance should be calculated directly from the invoice price variance
8756: --to avoid incorrect rounding logic
8757: /* x_bipv := AP_UTILITIES_PKG.ap_round_currency(
8758: l_qty_invoiced * l_inv_rate * l_price_diff
8759: , l_base_currency_code);*/
8760: x_bipv := AP_UTILITIES_PKG.ap_round_currency(x_ipv * l_inv_rate, l_base_currency_code);
8761:

Line 8760: x_bipv := AP_UTILITIES_PKG.ap_round_currency(x_ipv * l_inv_rate, l_base_currency_code);

8756: --to avoid incorrect rounding logic
8757: /* x_bipv := AP_UTILITIES_PKG.ap_round_currency(
8758: l_qty_invoiced * l_inv_rate * l_price_diff
8759: , l_base_currency_code);*/
8760: x_bipv := AP_UTILITIES_PKG.ap_round_currency(x_ipv * l_inv_rate, l_base_currency_code);
8761:
8762: END IF;
8763:
8764: END IF; -- end of check l_price_diff

Line 8786: x_erv := AP_UTILITIES_PKG.ap_round_Currency( l_original_dist_amt *

8782: where D.invoice_distribution_id = l_corrected_inv_dist_id
8783: and D.invoice_id = AI.invoice_id;
8784:
8785: /* Modified below statement for bug#14360581
8786: x_erv := AP_UTILITIES_PKG.ap_round_Currency( l_original_dist_amt *
8787: (l_corrected_inv_rate - l_inv_rate)
8788: , l_base_currency_code); */
8789:
8790: x_erv := AP_UTILITIES_PKG.ap_round_Currency( l_original_dist_amt *

Line 8790: x_erv := AP_UTILITIES_PKG.ap_round_Currency( l_original_dist_amt *

8786: x_erv := AP_UTILITIES_PKG.ap_round_Currency( l_original_dist_amt *
8787: (l_corrected_inv_rate - l_inv_rate)
8788: , l_base_currency_code); */
8789:
8790: x_erv := AP_UTILITIES_PKG.ap_round_Currency( l_original_dist_amt *
8791: (l_inv_rate - l_corrected_inv_rate)
8792: , l_base_currency_code);
8793:
8794: x_ipv := 0;

Line 8809: x_erv := AP_UTILITIES_PKG.ap_round_currency(

8805:
8806: IF (l_rate_diff = 0) THEN
8807: x_erv := 0;
8808: ELSE
8809: x_erv := AP_UTILITIES_PKG.ap_round_currency(
8810: l_original_dist_amt * l_rate_diff
8811: ,l_base_currency_code);
8812: END IF;
8813: