DBA Data[Home] [Help]

APPS.AP_RECONCILIATION_PKG dependencies on AP_UTILITIES_PKG

Line 294: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (

290: AND ac.check_id = x_check_id;
291:
292: l_debug_info := 'Call rounding function';
293:
294: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
295: -- X_Transaction_Amount*nvl(X_Exchange_Rate, 1),
296: -- Bug 3168106
297: X_Transaction_Amount*X_Exchange_Rate,
298: l_functional_currency_code );

Line 619: l_remainder_errors_pmt_amt := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (

615: -- the errors and charges before proration.
616:
617: IF (l_currency_case = 'INTERNATIONAL') THEN
618: l_debug_info := 'Inside International';
619: l_remainder_errors_pmt_amt := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
620: l_errors_bank_amount / nvl(X_PMT_TO_BASE_XRATE,1),
621: l_pmt_currency_code );
622: l_remainder_charges_pmt_amt := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
623: l_charges_bank_amount / nvl(X_PMT_TO_BASE_XRATE,1),

Line 622: l_remainder_charges_pmt_amt := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (

618: l_debug_info := 'Inside International';
619: l_remainder_errors_pmt_amt := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
620: l_errors_bank_amount / nvl(X_PMT_TO_BASE_XRATE,1),
621: l_pmt_currency_code );
622: l_remainder_charges_pmt_amt := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
623: l_charges_bank_amount / nvl(X_PMT_TO_BASE_XRATE,1),
624: l_pmt_currency_code );
625:
626: -- Since the bank and base currencies are the same ...

Line 671: l_ind_errors_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (

667:
668: IF (l_pay_sum_amt = 0) THEN
669: l_debug_info := 'Inside l_pay_sum_amt is 0';
670:
671: l_ind_errors_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
672: l_errors_pmt_amount/l_payment_count,
673: l_pmt_currency_code );
674: l_ind_charges_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
675: l_charges_pmt_amount/l_payment_count,

Line 674: l_ind_charges_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (

670:
671: l_ind_errors_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
672: l_errors_pmt_amount/l_payment_count,
673: l_pmt_currency_code );
674: l_ind_charges_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
675: l_charges_pmt_amount/l_payment_count,
676: l_pmt_currency_code );
677:
678: ELSIF (l_running_total_payments = l_pay_sum_amt) THEN

Line 687: l_ind_errors_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (

683:
684: ELSE
685: l_debug_info := 'Inside l_pay_sum_amt is another value';
686:
687: l_ind_errors_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
688: l_errors_pmt_amount*l_check_amount
689: /l_pay_sum_amt,
690: l_pmt_currency_code );
691: l_ind_charges_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (

Line 691: l_ind_charges_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (

687: l_ind_errors_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
688: l_errors_pmt_amount*l_check_amount
689: /l_pay_sum_amt,
690: l_pmt_currency_code );
691: l_ind_charges_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
692: l_charges_pmt_amount*l_check_amount
693: /l_pay_sum_amt,
694: l_pmt_currency_code );
695:

Line 730: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

726: - l_runtotal_charges_bank_amount;
727: ELSE
728: l_debug_info := 'Inside Negotiable, International amounts not eq';
729:
730: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
731: (l_check_amount + l_ind_errors_pmt_amount
732: + l_ind_charges_pmt_amount) * nvl(X_PMT_TO_BASE_XRATE,1),
733: l_functional_currency_code);
734: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

Line 734: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

730: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
731: (l_check_amount + l_ind_errors_pmt_amount
732: + l_ind_charges_pmt_amount) * nvl(X_PMT_TO_BASE_XRATE,1),
733: l_functional_currency_code);
734: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
735: l_ind_errors_pmt_amount
736: * nvl(X_PMT_TO_BASE_XRATE,1),
737: l_functional_currency_code);
738: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

Line 738: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

734: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
735: l_ind_errors_pmt_amount
736: * nvl(X_PMT_TO_BASE_XRATE,1),
737: l_functional_currency_code);
738: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
739: l_ind_charges_pmt_amount
740: * nvl(X_PMT_TO_BASE_XRATE,1),
741: l_functional_currency_code);
742: END IF;

Line 797: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

793:
794: ELSIF (l_currency_case = 'FOREIGN') THEN
795: l_debug_info := 'Inside Negotiable, Foreign';
796:
797: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
798: (l_check_amount + l_ind_errors_pmt_amount
799: + l_ind_charges_pmt_amount) * nvl(X_PMT_TO_BASE_XRATE,1),
800: l_functional_currency_code);
801: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

Line 801: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

797: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
798: (l_check_amount + l_ind_errors_pmt_amount
799: + l_ind_charges_pmt_amount) * nvl(X_PMT_TO_BASE_XRATE,1),
800: l_functional_currency_code);
801: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
802: l_ind_errors_pmt_amount
803: * nvl(X_PMT_TO_BASE_XRATE,1),
804: l_functional_currency_code);
805: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

Line 805: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

801: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
802: l_ind_errors_pmt_amount
803: * nvl(X_PMT_TO_BASE_XRATE,1),
804: l_functional_currency_code);
805: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
806: l_ind_charges_pmt_amount
807: * nvl(X_PMT_TO_BASE_XRATE,1),
808: l_functional_currency_code);
809: -- Bug 2276503

Line 934: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

930: l_charges_base_amount := X_CHARGES_BANK_AMOUNT
931: - l_runtotal_charges_bank_amount;
932: ELSE
933:
934: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
935: (l_check_amount + l_ind_errors_pmt_amount
936: + l_ind_charges_pmt_amount)
937: * nvl(X_PMT_TO_BASE_XRATE,1),
938: l_functional_currency_code);

Line 939: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

935: (l_check_amount + l_ind_errors_pmt_amount
936: + l_ind_charges_pmt_amount)
937: * nvl(X_PMT_TO_BASE_XRATE,1),
938: l_functional_currency_code);
939: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
940: l_ind_errors_pmt_amount
941: * nvl(X_PMT_TO_BASE_XRATE,1),
942: l_functional_currency_code);
943: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

Line 943: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

939: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
940: l_ind_errors_pmt_amount
941: * nvl(X_PMT_TO_BASE_XRATE,1),
942: l_functional_currency_code);
943: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
944: l_ind_charges_pmt_amount
945: * nvl(X_PMT_TO_BASE_XRATE,1),
946: l_functional_currency_code);
947: END IF;

Line 951: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

947: END IF;
948:
949: ELSIF (l_currency_case = 'FOREIGN') THEN
950:
951: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
952: (l_check_amount + l_ind_errors_pmt_amount
953: + l_ind_charges_pmt_amount)
954: * nvl(X_PMT_TO_BASE_XRATE,1),
955: l_functional_currency_code);

Line 956: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

952: (l_check_amount + l_ind_errors_pmt_amount
953: + l_ind_charges_pmt_amount)
954: * nvl(X_PMT_TO_BASE_XRATE,1),
955: l_functional_currency_code);
956: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
957: l_ind_errors_pmt_amount
958: * nvl(X_PMT_TO_BASE_XRATE,1),
959: l_functional_currency_code);
960: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

Line 960: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

956: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
957: l_ind_errors_pmt_amount
958: * nvl(X_PMT_TO_BASE_XRATE,1),
959: l_functional_currency_code);
960: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
961: l_ind_charges_pmt_amount
962: * nvl(X_PMT_TO_BASE_XRATE,1),
963: l_functional_currency_code);
964:

Line 1080: l_ind_errors_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (

1076: -- the errors and charges before proration.
1077: IF (l_currency_case = 'INTERNATIONAL') THEN
1078: l_debug_info := 'checkrun is null, inside International';
1079:
1080: l_ind_errors_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
1081: l_errors_bank_amount / nvl(X_PMT_TO_BASE_XRATE,1),
1082: l_pmt_currency_code );
1083: l_ind_charges_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
1084: l_charges_bank_amount / nvl(X_PMT_TO_BASE_XRATE,1),

Line 1083: l_ind_charges_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (

1079:
1080: l_ind_errors_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
1081: l_errors_bank_amount / nvl(X_PMT_TO_BASE_XRATE,1),
1082: l_pmt_currency_code );
1083: l_ind_charges_pmt_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY (
1084: l_charges_bank_amount / nvl(X_PMT_TO_BASE_XRATE,1),
1085: l_pmt_currency_code );
1086:
1087: -- Since the bank and base currencies are the same ...

Line 1182: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

1178:
1179:
1180: ELSIF (l_currency_case = 'FOREIGN') THEN
1181:
1182: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1183: (l_check_amount + l_ind_errors_pmt_amount
1184: + l_ind_charges_pmt_amount) * nvl(X_PMT_TO_BASE_XRATE,1),
1185: l_functional_currency_code);
1186: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

Line 1186: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

1182: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1183: (l_check_amount + l_ind_errors_pmt_amount
1184: + l_ind_charges_pmt_amount) * nvl(X_PMT_TO_BASE_XRATE,1),
1185: l_functional_currency_code);
1186: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1187: l_ind_errors_pmt_amount * nvl(X_PMT_TO_BASE_XRATE,1),
1188: l_functional_currency_code);
1189: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1190: l_ind_charges_pmt_amount * nvl(X_PMT_TO_BASE_XRATE,1),

Line 1189: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

1185: l_functional_currency_code);
1186: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1187: l_ind_errors_pmt_amount * nvl(X_PMT_TO_BASE_XRATE,1),
1188: l_functional_currency_code);
1189: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1190: l_ind_charges_pmt_amount * nvl(X_PMT_TO_BASE_XRATE,1),
1191: l_functional_currency_code);
1192:
1193: -- Bug 2276503

Line 1308: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

1304: l_charges_base_amount := X_CHARGES_BANK_AMOUNT;
1305:
1306: ELSIF (l_currency_case = 'FOREIGN') THEN
1307:
1308: l_trx_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1309: (l_check_amount + l_ind_errors_pmt_amount
1310: + l_ind_charges_pmt_amount )
1311: * nvl(X_PMT_TO_BASE_XRATE,1),
1312: l_functional_currency_code);

Line 1314: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

1310: + l_ind_charges_pmt_amount )
1311: * nvl(X_PMT_TO_BASE_XRATE,1),
1312: l_functional_currency_code);
1313:
1314: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1315: l_ind_errors_pmt_amount * nvl(X_PMT_TO_BASE_XRATE,1),
1316: l_functional_currency_code);
1317:
1318: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

Line 1318: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(

1314: l_errors_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1315: l_ind_errors_pmt_amount * nvl(X_PMT_TO_BASE_XRATE,1),
1316: l_functional_currency_code);
1317:
1318: l_charges_base_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY(
1319: l_ind_charges_pmt_amount * nvl(X_PMT_TO_BASE_XRATE,1),
1320: l_functional_currency_code);
1321:
1322: ELSIF (l_currency_case = 'DOMESTIC') THEN