DBA Data[Home] [Help]

APPS.AP_WEB_EXPORT_ER dependencies on AP_UTILITIES_PKG

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

190:
191: ELSE
192: l_dist_rec_curr_amt := l_dist_amount;
193: END IF;
194: l_dist_rec_curr_amt := ap_utilities_pkg.ap_round_currency(l_dist_rec_curr_amt,l_receipt_currency_code);
195: l_total_dist_rec_curr_amt := l_total_dist_rec_curr_amt + l_dist_rec_curr_amt;
196: l_prev_dist_id := l_report_distribution_id;
197:
198: update ap_exp_report_dists set

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

309: nvl(emps.employee_id, -1) employee_id,
310: emps.employee_num employee_number,
311: XH.week_end_date week_end_date,
312: nvl(XH.invoice_num, '') invoice_num,
313: to_char(ap_utilities_pkg.ap_round_currency(XH.total,
314: XH.default_currency_code)) total,
315: nvl(XH.description, '') description,
316: substrb(rtrim(emps.last_name || ', ' || emps.first_name ||
317: DECODE(people.middle_names, null, '', ' ') ||

Line 1346: AP_UTILITIES_PKG.Get_Invoice_LE(

1342: fnd_file.put_line(fnd_file.log, l_debug_info);
1343: END IF;
1344:
1345:
1346: AP_UTILITIES_PKG.Get_Invoice_LE(
1347: l_vendor_rec.vendor_site_id,
1348: nvl(l_invoice_rec.accts_pay_ccid, l_vendor_rec.liab_acc),
1349: nvl(l_invoice_rec.org_id, nvl(p_org_id, NULL)),
1350: l_le_id);

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

1935: SIGN(nvl(amount, 0)) distribution_amount_sign,
1936: SIGN(nvl(stat_amount, 0)) stat_amount_sign,
1937: to_char(nvl(xl.stat_amount, '')) stat_amount,
1938: xl.set_of_books_id line_set_of_books_id,
1939: to_char(nvl(ap_utilities_pkg.ap_round_currency(xl.amount,
1940: XH.default_currency_code),
1941: 0)) distribution_amount,
1942: nvl(xl.item_description, '') item_description,
1943: xl.line_type_lookup_code db_line_type,

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

1946: xh.default_currency_code,
1947: null,
1948: DECODE(F.minimum_accountable_unit,
1949: '',
1950: ROUND(ap_utilities_pkg.ap_round_currency(xl.amount,
1951: XH.default_currency_code) *
1952: xh.default_exchange_rate,
1953: F.precision),
1954: ROUND(ap_utilities_pkg.ap_round_currency(xl.amount,

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

1950: ROUND(ap_utilities_pkg.ap_round_currency(xl.amount,
1951: XH.default_currency_code) *
1952: xh.default_exchange_rate,
1953: F.precision),
1954: ROUND(ap_utilities_pkg.ap_round_currency(xl.amount,
1955: XH.default_currency_code) *
1956: xh.default_exchange_rate /
1957: F.minimum_accountable_unit) *
1958: F.minimum_accountable_unit))) base_amount,

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

2477: AP_INVOICE_LINES_INTERFACE_S.nextval,
2478: xl.distribution_line_number,
2479: nvl(lc.lookup_code, '') line_type_lookup_code,
2480: '',
2481: to_char(nvl(ap_utilities_pkg.ap_round_currency(xl.amount,
2482: XH.default_currency_code),
2483: 0)) distribution_amount,
2484: '' accounting_date,
2485: nvl(xl.item_description, '') item_description,