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

Line 102: AND AP_UTILITIES_PKG.GET_CCR_STATUS(asi.vendor_id,'S') <> 'F'

98: ,asi.remit_to_supplier_site_id
99: FROM ap_selected_invoices_all asi,ap_invoices_all ai
100: WHERE ai.invoice_id=asi.invoice_id
101: AND ai.invoice_type_lookup_code in ('STANDARD','PREPAYMENT')
102: AND AP_UTILITIES_PKG.GET_CCR_STATUS(asi.vendor_id,'S') <> 'F'
103: AND asi.checkrun_id=p_checkrun_id;
104:
105: BEGIN
106:

Line 483: l_inv_curr_int_amt := ap_utilities_pkg.ap_round_currency(

479: FROM ap_selected_invoices
480: WHERE original_invoice_id = to_char(l_invoice_id); --4388916
481:
482:
483: l_inv_curr_int_amt := ap_utilities_pkg.ap_round_currency(
484: l_int_invoice_amt / l_payment_cross_rate,
485: l_invoice_currency_code);
486:
487: INSERT INTO ap_selected_invoices_all

Line 886: ' ap_utilities_pkg.get_invoice_status(ai.invoice_id, null), '||

882: ' ai.invoice_id, '||
883: ' ps.payment_num, '||
884: ' ps.hold_flag, '||
885: ' sites.hold_all_payments_flag, '||
886: ' ap_utilities_pkg.get_invoice_status(ai.invoice_id, null), '||
887: ' ai.wfapproval_status, '||
888: ' ai.org_id, '||
889: ' ps.due_date, '||
890: ' ps.discount_amount_available, '||

Line 4744: SET payment_amount = ap_utilities_pkg.ap_round_currency

4740:
4741:
4742: --round the values we just updated
4743: UPDATE ap_selected_invoices_all ASI
4744: SET payment_amount = ap_utilities_pkg.ap_round_currency
4745: (payment_amount,payment_currency_code),
4746: proposed_payment_amount = ap_utilities_pkg.ap_round_currency
4747: (proposed_payment_amount,payment_currency_code) ,
4748: discount_amount = ap_utilities_pkg.ap_round_currency

Line 4746: proposed_payment_amount = ap_utilities_pkg.ap_round_currency

4742: --round the values we just updated
4743: UPDATE ap_selected_invoices_all ASI
4744: SET payment_amount = ap_utilities_pkg.ap_round_currency
4745: (payment_amount,payment_currency_code),
4746: proposed_payment_amount = ap_utilities_pkg.ap_round_currency
4747: (proposed_payment_amount,payment_currency_code) ,
4748: discount_amount = ap_utilities_pkg.ap_round_currency
4749: (discount_amount,payment_currency_code)
4750: WHERE checkrun_id= l_checkrun_id;

Line 4748: discount_amount = ap_utilities_pkg.ap_round_currency

4744: SET payment_amount = ap_utilities_pkg.ap_round_currency
4745: (payment_amount,payment_currency_code),
4746: proposed_payment_amount = ap_utilities_pkg.ap_round_currency
4747: (proposed_payment_amount,payment_currency_code) ,
4748: discount_amount = ap_utilities_pkg.ap_round_currency
4749: (discount_amount,payment_currency_code)
4750: WHERE checkrun_id= l_checkrun_id;
4751:
4752:

Line 4819: ap_utilities_pkg.get_exchange_rate(

4815:
4816: update ap_selected_invoices asi
4817: set (payment_exchange_rate_type, payment_exchange_rate) =
4818: (select l_batch_exchange_rate_type,
4819: ap_utilities_pkg.get_exchange_rate(
4820: asi.payment_currency_code,
4821: asp.base_currency_code,
4822: l_batch_exchange_rate_type,
4823: l_check_date,

Line 5612: ap_utilities_pkg.get_exchange_rate(

5608:
5609: update ap_selected_invoices asi
5610: set (payment_exchange_rate_type, payment_exchange_rate) =
5611: (select l_batch_exchange_rate_type,
5612: ap_utilities_pkg.get_exchange_rate(
5613: asi.payment_currency_code,
5614: asp.base_currency_code,
5615: l_batch_exchange_rate_type,
5616: l_check_date,

Line 5879: ap_utilities_pkg.get_exchange_rate(

5875:
5876: update ap_selected_invoices asi
5877: set (payment_exchange_rate_type, payment_exchange_rate) =
5878: (select l_batch_exchange_rate_type,
5879: ap_utilities_pkg.get_exchange_rate(
5880: asi.payment_currency_code,
5881: asp.base_currency_code,
5882: l_batch_exchange_rate_type,
5883: l_check_date,

Line 6308: ap_utilities_pkg.clob_to_file(l_result_clob);

6304: DBMS_XMLGEN.setRowTag(l_qryCtx, 'SELECTION_CRITERIA');
6305: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
6306: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
6307: DBMS_XMLGEN.closeContext(l_qryCtx);
6308: ap_utilities_pkg.clob_to_file(l_result_clob);
6309:
6310:
6311: l_debug_info := 'select pay group';
6312:

Line 6322: ap_utilities_pkg.clob_to_file(l_result_clob);

6318: DBMS_XMLGEN.setRowTag(l_qryCtx, 'PAY_GROUP');
6319: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
6320: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
6321: DBMS_XMLGEN.closeContext(l_qryCtx);
6322: ap_utilities_pkg.clob_to_file(l_result_clob);
6323:
6324:
6325: l_debug_info := 'select currency group';
6326:

Line 6335: ap_utilities_pkg.clob_to_file(l_result_clob);

6331: DBMS_XMLGEN.setRowTag(l_qryCtx, 'CURRENCY_GROUP');
6332: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
6333: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
6334: DBMS_XMLGEN.closeContext(l_qryCtx);
6335: ap_utilities_pkg.clob_to_file(l_result_clob);
6336:
6337:
6338:
6339: l_debug_info:= 'select le group';

Line 6350: ap_utilities_pkg.clob_to_file(l_result_clob);

6346: DBMS_XMLGEN.setRowTag(l_qryCtx, 'LE_GROUP');
6347: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
6348: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
6349: DBMS_XMLGEN.closeContext(l_qryCtx);
6350: ap_utilities_pkg.clob_to_file(l_result_clob);
6351:
6352:
6353: l_debug_info := 'select ou group';
6354:

Line 6364: ap_utilities_pkg.clob_to_file(l_result_clob);

6360: DBMS_XMLGEN.setRowTag(l_qryCtx, 'OU_GROUP');
6361: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
6362: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
6363: DBMS_XMLGEN.closeContext(l_qryCtx);
6364: ap_utilities_pkg.clob_to_file(l_result_clob);
6365:
6366: fnd_file.put_line(fnd_file.output, '');
6367:
6368: EXCEPTION