DBA Data[Home] [Help]

APPS.AP_PREPAY_UTILS_PKG dependencies on AP_UTILITIES_PKG

Line 876: --l_tax_lines_proration := ap_utilities_pkg.ap_round_currency(l_tax_lines_proration, l_invoice_currency_code);

872: AND ail.line_type_lookup_code = 'TAX'
873: AND (ail.amount > 0 OR nvl(ail.invoice_includes_prepay_flag, 'N') = 'Y'); /*Bug 9338463: invoice includes prepay check added*/
874:
875: --Bug 9338463 commented below code
876: --l_tax_lines_proration := ap_utilities_pkg.ap_round_currency(l_tax_lines_proration, l_invoice_currency_code);
877:
878: --payments made by check
879: SELECT nvl(SUM(amount), 0)
880: INTO l_sum_checks_payment

Line 918: l_tax_prorated := ap_utilities_pkg.ap_round_currency(l_tax_prorated, l_invoice_currency_code);

914:
915: ELSE
916: --prorate tax
917: l_tax_prorated :=(l_invoice_total *l_tax_lines_proration) /(l_item_lines_proration + l_tax_lines_proration);
918: l_tax_prorated := ap_utilities_pkg.ap_round_currency(l_tax_prorated, l_invoice_currency_code);
919: l_invoice_unpaid_amount := l_invoice_total -l_tax_prorated + l_prep_applied -l_sum_checks_payment + l_awt_lines;
920:
921: END IF;
922:

Line 952: l_prorated_unpaid_amt := ap_utilities_pkg.ap_round_currency(l_prorated_unpaid_amt, l_invoice_currency_code);

948: --This proration logic was implemented in 7506584 to take care of QA bug 7498687 and that bug.
949:
950: l_tax_prorated := (l_tax_lines_proration /(l_item_lines_proration + l_tax_lines_proration));
951: l_prorated_unpaid_amt :=(l_invoice_total-l_sum_checks_payment + l_prep_applied + l_awt_lines) * (1-l_tax_prorated);
952: l_prorated_unpaid_amt := ap_utilities_pkg.ap_round_currency(l_prorated_unpaid_amt, l_invoice_currency_code);
953: l_invoice_unpaid_amount := l_prorated_unpaid_amt;
954:
955: END IF; /*bug 9338463 end*/
956:

Line 962: l_tax_prorated := ap_utilities_pkg.ap_round_currency(l_tax_prorated, l_invoice_currency_code);

958: /*ELSE
959: -- Invoice has any partial payment
960:
961: l_tax_prorated :=(l_invoice_total *l_tax_lines_proration) /(l_item_lines_proration + l_tax_lines_proration);
962: l_tax_prorated := ap_utilities_pkg.ap_round_currency(l_tax_prorated, l_invoice_currency_code);
963: l_invoice_unpaid_amount := l_invoice_total -l_tax_prorated + l_prep_applied -l_sum_checks_payment + l_awt_lines;
964:
965: END IF; */
966: --End of bug8921145

Line 1016: l_invoice_unpaid_amount := AP_Utilities_PKG.AP_Round_Currency (

1012: END IF;
1013:
1014: -- get the rounded proportion of the unpaid amount exclusive
1015: -- of tax from the total unpaid amount
1016: l_invoice_unpaid_amount := AP_Utilities_PKG.AP_Round_Currency (
1017: l_lines_total_no_exc_tax*l_unpaid_amount/l_invoice_total,
1018: l_invoice_currency_code);
1019:
1020: END IF;

Line 1137: l_invoice_unpaid_amount := AP_Utilities_PKG.AP_Round_Currency (

1133: -- get the rounded proportion of the unpaid amount exclusive
1134: -- of tax from the total unpaid amount
1135:
1136: /*Commented for bug 7506584
1137: l_invoice_unpaid_amount := AP_Utilities_PKG.AP_Round_Currency (
1138: l_lines_total_with_exc_tax*l_unpaid_amount/l_invoice_total,
1139: l_invoice_currency_code);
1140: */
1141: l_invoice_unpaid_amount := ap_utilities_pkg.ap_round_currency(l_unpaid_amount, l_invoice_currency_code);

Line 1141: l_invoice_unpaid_amount := ap_utilities_pkg.ap_round_currency(l_unpaid_amount, l_invoice_currency_code);

1137: l_invoice_unpaid_amount := AP_Utilities_PKG.AP_Round_Currency (
1138: l_lines_total_with_exc_tax*l_unpaid_amount/l_invoice_total,
1139: l_invoice_currency_code);
1140: */
1141: l_invoice_unpaid_amount := ap_utilities_pkg.ap_round_currency(l_unpaid_amount, l_invoice_currency_code);
1142:
1143: --END IF;
1144:
1145: RETURN(l_invoice_unpaid_amount);

Line 1242: l_inclusive_unpaid_amount := AP_Utilities_PKG.AP_Round_Currency (

1238: END IF;
1239:
1240: -- get the proportion of the unpaid amount exclusive of tax from the
1241: -- total unpaid amount
1242: l_inclusive_unpaid_amount := AP_Utilities_PKG.AP_Round_Currency (
1243: l_inclusive_tax_total_lines*l_unpaid_amount/l_invoice_total,
1244: l_invoice_currency_code);
1245:
1246: