APPS.AP_AUTOSELECT_PKG dependencies on AP_UTILITIES_PKG

Line 289: l_inv_curr_int_amt := ap_utilities_pkg.ap_round_currency(

285: FROM ap_selected_invoices
286: WHERE original_invoice_id = to_char(l_invoice_id); --4388916
287:
288:
289: l_inv_curr_int_amt := ap_utilities_pkg.ap_round_currency(
290: l_int_invoice_amt / l_payment_cross_rate,
291: l_invoice_currency_code);
292:
293: INSERT INTO ap_selected_invoices_all

Line 613: ap_utilities_pkg.get_invoice_status(inv.invoice_id, null),

609: SELECT /*+NO_EXPAND */ inv.invoice_id,
610: ps.payment_num,
611: ps.hold_flag,
612: sites.hold_all_payments_flag,
613: ap_utilities_pkg.get_invoice_status(inv.invoice_id, null),
614: inv.wfapproval_status,
615: inv.org_id,
616: ps.due_date,
617: ps.discount_amount_available,

Line 3630: SET payment_amount = ap_utilities_pkg.ap_round_currency

3626:
3627:
3628: --round the values we just updated
3629: UPDATE ap_selected_invoices_all ASI
3630: SET payment_amount = ap_utilities_pkg.ap_round_currency
3631: (payment_amount,payment_currency_code),
3632: proposed_payment_amount = ap_utilities_pkg.ap_round_currency
3633: (proposed_payment_amount,payment_currency_code) ,
3634: discount_amount = ap_utilities_pkg.ap_round_currency

Line 3632: proposed_payment_amount = ap_utilities_pkg.ap_round_currency

3628: --round the values we just updated
3629: UPDATE ap_selected_invoices_all ASI
3630: SET payment_amount = ap_utilities_pkg.ap_round_currency
3631: (payment_amount,payment_currency_code),
3632: proposed_payment_amount = ap_utilities_pkg.ap_round_currency
3633: (proposed_payment_amount,payment_currency_code) ,
3634: discount_amount = ap_utilities_pkg.ap_round_currency
3635: (discount_amount,payment_currency_code)
3636: WHERE checkrun_id= l_checkrun_id;

Line 3634: discount_amount = ap_utilities_pkg.ap_round_currency

3630: SET payment_amount = ap_utilities_pkg.ap_round_currency
3631: (payment_amount,payment_currency_code),
3632: proposed_payment_amount = ap_utilities_pkg.ap_round_currency
3633: (proposed_payment_amount,payment_currency_code) ,
3634: discount_amount = ap_utilities_pkg.ap_round_currency
3635: (discount_amount,payment_currency_code)
3636: WHERE checkrun_id= l_checkrun_id;
3637:
3638:

Line 3761: ap_utilities_pkg.get_exchange_rate(

3757:
3758: update ap_selected_invoices asi
3759: set (payment_exchange_rate_type, payment_exchange_rate) =
3760: (select l_batch_exchange_rate_type,
3761: ap_utilities_pkg.get_exchange_rate(
3762: asi.payment_currency_code,
3763: asp.base_currency_code,
3764: l_batch_exchange_rate_type,
3765: l_check_date,

Line 4323: ap_utilities_pkg.get_exchange_rate(

4319:
4320: update ap_selected_invoices asi
4321: set (payment_exchange_rate_type, payment_exchange_rate) =
4322: (select l_batch_exchange_rate_type,
4323: ap_utilities_pkg.get_exchange_rate(
4324: asi.payment_currency_code,
4325: asp.base_currency_code,
4326: l_batch_exchange_rate_type,
4327: l_check_date,

Line 4708: ap_utilities_pkg.clob_to_file(l_result_clob);

4704: DBMS_XMLGEN.setRowTag(l_qryCtx, 'SELECTION_CRITERIA');
4705: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
4706: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
4707: DBMS_XMLGEN.closeContext(l_qryCtx);
4708: ap_utilities_pkg.clob_to_file(l_result_clob);
4709:
4710:
4711: l_debug_info := 'select pay group';
4712:

Line 4722: ap_utilities_pkg.clob_to_file(l_result_clob);

4718: DBMS_XMLGEN.setRowTag(l_qryCtx, 'PAY_GROUP');
4719: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
4720: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
4721: DBMS_XMLGEN.closeContext(l_qryCtx);
4722: ap_utilities_pkg.clob_to_file(l_result_clob);
4723:
4724:
4725: l_debug_info := 'select currency group';
4726:

Line 4735: ap_utilities_pkg.clob_to_file(l_result_clob);

4731: DBMS_XMLGEN.setRowTag(l_qryCtx, 'CURRENCY_GROUP');
4732: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
4733: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
4734: DBMS_XMLGEN.closeContext(l_qryCtx);
4735: ap_utilities_pkg.clob_to_file(l_result_clob);
4736:
4737:
4738:
4739: l_debug_info:= 'select le group';

Line 4750: ap_utilities_pkg.clob_to_file(l_result_clob);

4746: DBMS_XMLGEN.setRowTag(l_qryCtx, 'LE_GROUP');
4747: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
4748: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
4749: DBMS_XMLGEN.closeContext(l_qryCtx);
4750: ap_utilities_pkg.clob_to_file(l_result_clob);
4751:
4752:
4753: l_debug_info := 'select ou group';
4754:

Line 4764: ap_utilities_pkg.clob_to_file(l_result_clob);

4760: DBMS_XMLGEN.setRowTag(l_qryCtx, 'OU_GROUP');
4761: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
4762: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
4763: DBMS_XMLGEN.closeContext(l_qryCtx);
4764: ap_utilities_pkg.clob_to_file(l_result_clob);
4765:
4766: fnd_file.put_line(fnd_file.output, '');
4767:
4768: EXCEPTION