DBA Data[Home] [Help]

APPS.AP_WEB_EXPORT_ER dependencies on AP_UTILITIES_PKG

Line 278: l_rate := AP_UTILITIES_PKG.get_exchange_rate(l_def_currency_code, l_base_currency, l_default_rate_type, sysdate, 'PrintExportOutput');

274: BEGIN
275: IF(l_base_currency = l_def_currency_code) THEN
276: l_total_func_amount := l_total_func_amount + l_inv_amount;
277: ELSE
278: l_rate := AP_UTILITIES_PKG.get_exchange_rate(l_def_currency_code, l_base_currency, l_default_rate_type, sysdate, 'PrintExportOutput');
279: l_conv_amount := AP_WEB_UTILITIES_PKG.Oie_Round_Currency(l_inv_amount * l_rate, l_base_currency);
280: l_total_func_amount := l_total_func_amount + l_conv_amount;
281: END IF;
282: EXCEPTION

Line 463: l_rate := AP_UTILITIES_PKG.get_exchange_rate(l_def_currency_code, l_base_currency, l_default_rate_type, sysdate, 'PrintExportOutput');

459: BEGIN
460: IF(l_base_currency = l_def_currency_code) THEN
461: l_total_func_amount := l_total_func_amount + l_inv_amount;
462: ELSE
463: l_rate := AP_UTILITIES_PKG.get_exchange_rate(l_def_currency_code, l_base_currency, l_default_rate_type, sysdate, 'PrintExportOutput');
464: l_conv_amount := AP_WEB_UTILITIES_PKG.Oie_Round_Currency(l_inv_amount * l_rate, l_base_currency);
465: l_total_func_amount := l_total_func_amount + l_conv_amount;
466: END IF;
467: EXCEPTION

Line 646: l_rate := AP_UTILITIES_PKG.get_exchange_rate(l_def_currency_code, l_base_currency, l_default_rate_type, sysdate, 'PrintExportOutput');

642: BEGIN
643: IF(l_base_currency = l_def_currency_code) THEN
644: l_total_func_amount := l_total_func_amount + l_inv_amount;
645: ELSE
646: l_rate := AP_UTILITIES_PKG.get_exchange_rate(l_def_currency_code, l_base_currency, l_default_rate_type, sysdate, 'PrintExportOutput');
647: l_conv_amount := AP_WEB_UTILITIES_PKG.Oie_Round_Currency(l_inv_amount * l_rate, l_base_currency);
648: l_total_func_amount := l_total_func_amount + l_conv_amount;
649: END IF;
650: EXCEPTION

Line 1307: l_dist_rec_curr_amt := ap_utilities_pkg.ap_round_currency(l_dist_rec_curr_amt,l_receipt_currency_code);

1303:
1304: ELSE
1305: l_dist_rec_curr_amt := l_dist_amount;
1306: END IF;
1307: l_dist_rec_curr_amt := ap_utilities_pkg.ap_round_currency(l_dist_rec_curr_amt,l_receipt_currency_code);
1308: l_total_dist_rec_curr_amt := l_total_dist_rec_curr_amt + l_dist_rec_curr_amt;
1309: l_prev_dist_id := l_report_distribution_id;
1310:
1311: update ap_exp_report_dists set

Line 1426: to_char(ap_utilities_pkg.ap_round_currency(XH.total,

1422: nvl(emps.employee_id, -1) employee_id,
1423: emps.employee_num employee_number,
1424: XH.week_end_date week_end_date,
1425: nvl(XH.invoice_num, '') invoice_num,
1426: to_char(ap_utilities_pkg.ap_round_currency(XH.total,
1427: XH.default_currency_code)) total,
1428: nvl(XH.description, '') description,
1429: substrb(rtrim(emps.last_name || ', ' || emps.first_name ||
1430: DECODE(people.middle_names, null, '', ' ') ||

Line 2402: AP_UTILITIES_PKG.Get_Invoice_LE(

2398: fnd_file.put_line(fnd_file.log, l_debug_info);
2399: END IF;
2400:
2401:
2402: AP_UTILITIES_PKG.Get_Invoice_LE(
2403: l_vendor_rec.vendor_site_id,
2404: nvl(l_invoice_rec.accts_pay_ccid, l_vendor_rec.liab_acc),
2405: nvl(l_invoice_rec.org_id, nvl(p_org_id, NULL)),
2406: l_le_id);

Line 3023: to_char(nvl(ap_utilities_pkg.ap_round_currency(xl.amount,

3019: SIGN(nvl(amount, 0)) distribution_amount_sign,
3020: SIGN(nvl(stat_amount, 0)) stat_amount_sign,
3021: to_char(nvl(xl.stat_amount, '')) stat_amount,
3022: xl.set_of_books_id line_set_of_books_id,
3023: to_char(nvl(ap_utilities_pkg.ap_round_currency(xl.amount,
3024: XH.default_currency_code),
3025: 0)) distribution_amount,
3026: nvl(xl.item_description, '') item_description,
3027: xl.line_type_lookup_code db_line_type,

Line 3034: ROUND(ap_utilities_pkg.ap_round_currency(xl.amount,

3030: xh.default_currency_code,
3031: null,
3032: DECODE(F.minimum_accountable_unit,
3033: '',
3034: ROUND(ap_utilities_pkg.ap_round_currency(xl.amount,
3035: XH.default_currency_code) *
3036: xh.default_exchange_rate,
3037: F.precision),
3038: ROUND(ap_utilities_pkg.ap_round_currency(xl.amount,

Line 3038: ROUND(ap_utilities_pkg.ap_round_currency(xl.amount,

3034: ROUND(ap_utilities_pkg.ap_round_currency(xl.amount,
3035: XH.default_currency_code) *
3036: xh.default_exchange_rate,
3037: F.precision),
3038: ROUND(ap_utilities_pkg.ap_round_currency(xl.amount,
3039: XH.default_currency_code) *
3040: xh.default_exchange_rate /
3041: F.minimum_accountable_unit) *
3042: F.minimum_accountable_unit))) base_amount,

Line 3586: to_char(nvl(ap_utilities_pkg.ap_round_currency(xl.amount,

3582: AP_INVOICE_LINES_INTERFACE_S.nextval,
3583: xl.distribution_line_number,
3584: nvl(lc.lookup_code, '') line_type_lookup_code,
3585: '',
3586: to_char(nvl(ap_utilities_pkg.ap_round_currency(xl.amount,
3587: XH.default_currency_code),
3588: 0)) distribution_amount,
3589: '' accounting_date,
3590: nvl(xl.item_description, '') item_description,