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_R11_PREPAY_PKG dependencies on AP_UTILITIES_PKG

Line 702: X_prepay_curr_amount_apply := ap_utilities_pkg.ap_round_currency(

698: -- Full application
699: X_prepay_curr_amount_apply := C_invoice_amount;
700: else
701: -- Partial application
702: X_prepay_curr_amount_apply := ap_utilities_pkg.ap_round_currency(
703: X_amount_apply / C_payment_cross_rate,
704: C_currency_code);
705: end if;
706: else

Line 721: X_prepay_curr_amount_apply := ap_utilities_pkg.ap_round_currency(

717: -- Full unapplication
718: X_prepay_curr_amount_apply := C_invoice_amount - C_orig_prepay_amount;
719: else
720: -- Partial unapplication
721: X_prepay_curr_amount_apply := ap_utilities_pkg.ap_round_currency(
722: X_amount_apply / C_payment_cross_rate,
723: C_currency_code);
724: end if;
725: end if;

Line 746: ap_utilities_pkg.ap_round_precision(

742: -- Go to base tables AP_INVIOCES_ALL and AP_INVOICE_DISTRIBUTIONS_ALL ( only for D2 )
743: -- to eliminate MJC and reduce shared memory usage
744:
745: SELECT nvl(I.original_prepayment_amount,0),
746: ap_utilities_pkg.ap_round_precision(
747: D1.amount/I.original_prepayment_amount *
748: X_amount_apply,
749: C_pay_curr_min_unit, C_pay_curr_precision),
750: DECODE(D2.line_type_lookup_code,

Line 753: ap_utilities_pkg.ap_round_precision(

749: C_pay_curr_min_unit, C_pay_curr_precision),
750: DECODE(D2.line_type_lookup_code,
751: 'ITEM', 0, null, 0,
752: (X_amount_apply -
753: ap_utilities_pkg.ap_round_precision(
754: D1.amount/I.original_prepayment_amount *
755: X_amount_apply,
756: C_pay_curr_min_unit, C_pay_curr_precision)))
757: INTO X_orig_amount,

Line 931: ap_utilities_pkg.ap_round_precision(

927: X_amount_apply,
928: base_amount = DECODE(invoice_currency_code,
929: X_base_currency, base_amount,
930: base_amount -
931: ap_utilities_pkg.ap_round_precision(
932: exchange_rate * X_prepay_curr_amount_apply,
933: X_min_unit, X_precision)),
934: last_update_date = SYSDATE,
935: last_updated_by = X_user_id,

Line 943: ap_utilities_pkg.ap_round_precision(

939: else /* Update invoice info*/
940:
941: UPDATE ap_invoices
942: SET amount_paid = nvl(amount_paid, 0) +
943: ap_utilities_pkg.ap_round_precision(
944: X_amount_apply, X_min_unit, X_precision),
945: discount_amount_taken = nvl(discount_amount_taken, 0),
946: payment_status_flag =
947: DECODE(NVL(amount_paid, 0) + NVL(discount_amount_taken, 0) +

Line 948: ap_utilities_pkg.ap_round_precision(

944: X_amount_apply, X_min_unit, X_precision),
945: discount_amount_taken = nvl(discount_amount_taken, 0),
946: payment_status_flag =
947: DECODE(NVL(amount_paid, 0) + NVL(discount_amount_taken, 0) +
948: ap_utilities_pkg.ap_round_precision(
949: X_amount_apply, X_min_unit, X_precision),
950: nvl(pay_curr_invoice_amount, invoice_amount), 'Y',
951: 0,'N',
952: 'P'),

Line 1084: ap_utilities_pkg.ap_round_precision(

1080: X_user_id,
1081: X_gl_date,
1082: X_period_name,
1083: set_of_books_id,
1084: ap_utilities_pkg.ap_round_precision(
1085: (-1) * X_dist_line_amount / X_payment_cross_rate,
1086: X_min_unit, X_precision),
1087: 'Prepayment Application',
1088: type_1099,

Line 1101: ap_utilities_pkg.ap_round_precision(

1097: 'U',
1098: new_line_num,
1099: line_type_lookup_code,
1100: DECODE(base_amount, null, null,
1101: ap_utilities_pkg.ap_round_precision(
1102: (-1) * exchange_rate * X_dist_line_amount
1103: / X_payment_cross_rate,
1104: X_base_min_unit, X_base_precision)),
1105: exchange_rate,

Line 1222: ap_utilities_pkg.ap_round_precision(

1218: SYSDATE,
1219: X_user_id,
1220: SYSDATE,
1221: SYSDATE,
1222: ap_utilities_pkg.ap_round_precision(
1223: (-1) * X_amount_apply, X_pay_curr_min_unit,
1224: X_pay_curr_precision),
1225: ap_utilities_pkg.ap_round_precision(
1226: (-1) * X_prepay_curr_amount_apply,

Line 1225: ap_utilities_pkg.ap_round_precision(

1221: SYSDATE,
1222: ap_utilities_pkg.ap_round_precision(
1223: (-1) * X_amount_apply, X_pay_curr_min_unit,
1224: X_pay_curr_precision),
1225: ap_utilities_pkg.ap_round_precision(
1226: (-1) * X_prepay_curr_amount_apply,
1227: X_min_unit, X_precision),
1228: 0,
1229: 0,

Line 1375: ap_utilities_pkg.ap_round_precision(

1371: debug_info := 'Update ap_payment_schedule for the invoice, case 1';
1372:
1373: UPDATE ap_payment_schedules
1374: SET amount_remaining = (amount_remaining -
1375: ap_utilities_pkg.ap_round_precision(
1376: C_amount_apply_remaining,
1377: X_pay_curr_min_unit, X_pay_curr_precision)),
1378: payment_status_flag =
1379: DECODE(amount_remaining -

Line 1380: ap_utilities_pkg.ap_round_precision(

1376: C_amount_apply_remaining,
1377: X_pay_curr_min_unit, X_pay_curr_precision)),
1378: payment_status_flag =
1379: DECODE(amount_remaining -
1380: ap_utilities_pkg.ap_round_precision(
1381: C_amount_apply_remaining,
1382: X_pay_curr_min_unit, X_pay_curr_precision),
1383: 0,'Y',
1384: gross_amount, 'N',

Line 1706: ap_utilities_pkg.ap_round_precision(

1702: X_new_invoice_id,
1703: new_line_num,
1704: P.check_id,
1705: DECODE(P.invoice_id, X_new_invoice_id,
1706: ap_utilities_pkg.ap_round_precision(
1707: (-1) * X_amount_apply, X_pay_curr_min_unit,
1708: X_pay_curr_precision),
1709: ap_utilities_pkg.ap_round_precision(
1710: X_amount_apply, X_pay_curr_min_unit,

Line 1709: ap_utilities_pkg.ap_round_precision(

1705: DECODE(P.invoice_id, X_new_invoice_id,
1706: ap_utilities_pkg.ap_round_precision(
1707: (-1) * X_amount_apply, X_pay_curr_min_unit,
1708: X_pay_curr_precision),
1709: ap_utilities_pkg.ap_round_precision(
1710: X_amount_apply, X_pay_curr_min_unit,
1711: X_pay_curr_precision)),
1712: SYSDATE,
1713: X_user_id,

Line 1729: ap_utilities_pkg.ap_round_precision(

1725: P.exchange_rate,
1726: P.exchange_date,
1727: 0,
1728: DECODE(P.invoice_id, X_new_invoice_id,
1729: ap_utilities_pkg.ap_round_precision(
1730: (-1) *
1731: decode(I.invoice_currency_code,
1732: ASP.base_currency_code,
1733: decode(I.payment_currency_code,

Line 1740: ap_utilities_pkg.ap_round_precision(

1736: I.exchange_rate)
1737: * X_amount_apply
1738: / X_payment_cross_rate,
1739: X_base_min_unit, X_base_precision),
1740: ap_utilities_pkg.ap_round_precision(
1741: decode(I.invoice_currency_code,
1742: ASP.base_currency_code,
1743: decode(I.payment_currency_code,
1744: ASP.base_currency_code,

Line 1750: ap_utilities_pkg.ap_round_precision(

1746: I.exchange_rate) * X_amount_apply
1747: / X_payment_cross_rate,
1748: X_base_min_unit, X_base_precision)),
1749: DECODE(P.invoice_id, X_new_invoice_id,
1750: ap_utilities_pkg.ap_round_precision(
1751: (-1) *
1752: decode(I.payment_currency_code,
1753: ASP.base_currency_code,
1754: decode(I.invoice_currency_code,

Line 1760: ap_utilities_pkg.ap_round_precision(

1756: P.exchange_rate, 1),
1757: P.exchange_rate)
1758: * X_amount_apply,
1759: X_base_min_unit, X_base_precision),
1760: ap_utilities_pkg.ap_round_precision(
1761: decode(I.payment_currency_code,
1762: ASP.base_currency_code,
1763: decode(I.invoice_currency_code,
1764: ASP.base_currency_code,

Line 1891: ap_utilities_pkg.ap_round_precision(

1887: ------------------------------------------------------------------
1888: debug_info := 'Update ap_invoice_prepays';
1889: UPDATE ap_invoice_prepays
1890: SET prepayment_amount_applied = prepayment_amount_applied +
1891: ap_utilities_pkg.ap_round_precision(
1892: X_amount_apply, X_min_unit, X_precision),
1893: last_update_date = SYSDATE,
1894: last_updated_by = X_user_id,
1895: last_update_login = X_last_update_login

Line 1929: ap_utilities_pkg.ap_round_precision(

1925: created_by,
1926: org_id ) /* Bug 3700128. MOAC Project */
1927: SELECT X_prepay_id,
1928: X_invoice_id,
1929: ap_utilities_pkg.ap_round_precision(
1930: X_amount_apply, X_min_unit, X_precision),
1931: SYSDATE,
1932: X_user_id,
1933: DECODE(X_last_update_login, -999, null, X_last_update_login),