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_WEB_EXPORT_ER dependencies on AP_SYSTEM_PARAMETERS

Line 12: p_set_of_books_id IN ap_system_parameters.set_of_books_id%TYPE,

8: -----------------------------------------------------------------------------------------------
9: PROCEDURE ValidateGLDate(p_source_date IN DATE,
10: p_valid_inv_gl_date IN DATE,
11: p_source_item IN VARCHAR2,
12: p_set_of_books_id IN ap_system_parameters.set_of_books_id%TYPE,
13: p_open_gl_date OUT NOCOPY DATE,
14: p_reject_code OUT NOCOPY ap_expense_report_headers.reject_code%TYPE) IS
15: l_gl_period_status varchar2(2);
16: l_new_gl_date ap_expense_report_headers_all.week_end_date%TYPE;

Line 265: FROM ap_system_parameters_all sp,

261: f.precision,
262: sp.employee_pay_group_lookup_code,
263: sp.employee_terms_id,
264: sp.apply_advances_default
265: FROM ap_system_parameters_all sp,
266: financials_system_parameters fp,
267: fnd_currencies f
268: WHERE sp.base_currency_code = f.currency_code
269: AND sp.org_id = l_org_id;

Line 538: l_employee_terms_id ap_system_parameters.employee_terms_id%TYPE;

534: l_dummy VARCHAR2(50);
535: l_debug_info VARCHAR2(2000);
536: batch_failure EXCEPTION;
537: validation_failed EXCEPTION;
538: l_employee_terms_id ap_system_parameters.employee_terms_id%TYPE;
539: l_base_currency ap_system_parameters.base_currency_code%TYPE;
540: l_set_of_books_id ap_system_parameters.set_of_books_id%TYPE;
541: l_enable_recoverable_flag financials_system_parameters.non_recoverable_tax_flag%TYPE;
542: l_doc_category_override ap_system_parameters.inv_doc_category_override%TYPE;

Line 539: l_base_currency ap_system_parameters.base_currency_code%TYPE;

535: l_debug_info VARCHAR2(2000);
536: batch_failure EXCEPTION;
537: validation_failed EXCEPTION;
538: l_employee_terms_id ap_system_parameters.employee_terms_id%TYPE;
539: l_base_currency ap_system_parameters.base_currency_code%TYPE;
540: l_set_of_books_id ap_system_parameters.set_of_books_id%TYPE;
541: l_enable_recoverable_flag financials_system_parameters.non_recoverable_tax_flag%TYPE;
542: l_doc_category_override ap_system_parameters.inv_doc_category_override%TYPE;
543: l_gl_date_flag ap_system_parameters.gl_date_from_receipt_flag%TYPE;

Line 540: l_set_of_books_id ap_system_parameters.set_of_books_id%TYPE;

536: batch_failure EXCEPTION;
537: validation_failed EXCEPTION;
538: l_employee_terms_id ap_system_parameters.employee_terms_id%TYPE;
539: l_base_currency ap_system_parameters.base_currency_code%TYPE;
540: l_set_of_books_id ap_system_parameters.set_of_books_id%TYPE;
541: l_enable_recoverable_flag financials_system_parameters.non_recoverable_tax_flag%TYPE;
542: l_doc_category_override ap_system_parameters.inv_doc_category_override%TYPE;
543: l_gl_date_flag ap_system_parameters.gl_date_from_receipt_flag%TYPE;
544: l_address_flag financials_system_parameters.expense_check_address_flag%TYPE;

Line 542: l_doc_category_override ap_system_parameters.inv_doc_category_override%TYPE;

538: l_employee_terms_id ap_system_parameters.employee_terms_id%TYPE;
539: l_base_currency ap_system_parameters.base_currency_code%TYPE;
540: l_set_of_books_id ap_system_parameters.set_of_books_id%TYPE;
541: l_enable_recoverable_flag financials_system_parameters.non_recoverable_tax_flag%TYPE;
542: l_doc_category_override ap_system_parameters.inv_doc_category_override%TYPE;
543: l_gl_date_flag ap_system_parameters.gl_date_from_receipt_flag%TYPE;
544: l_address_flag financials_system_parameters.expense_check_address_flag%TYPE;
545: l_min_accountable_unit NUMBER;
546: l_precision NUMBER;

Line 543: l_gl_date_flag ap_system_parameters.gl_date_from_receipt_flag%TYPE;

539: l_base_currency ap_system_parameters.base_currency_code%TYPE;
540: l_set_of_books_id ap_system_parameters.set_of_books_id%TYPE;
541: l_enable_recoverable_flag financials_system_parameters.non_recoverable_tax_flag%TYPE;
542: l_doc_category_override ap_system_parameters.inv_doc_category_override%TYPE;
543: l_gl_date_flag ap_system_parameters.gl_date_from_receipt_flag%TYPE;
544: l_address_flag financials_system_parameters.expense_check_address_flag%TYPE;
545: l_min_accountable_unit NUMBER;
546: l_precision NUMBER;
547: vendor_valid_flag VARCHAR2(2);

Line 571: l_emp_pg_lookup_code ap_system_parameters.employee_pay_group_lookup_code%TYPE;

567: l_seq_profile VARCHAR2(2);
568: l_rows_to_import NUMBER := 0;
569: l_expenses_fetched NUMBER := 0;
570: l_org_id NUMBER;
571: l_emp_pg_lookup_code ap_system_parameters.employee_pay_group_lookup_code%TYPE;
572: l_emp_terms_id ap_system_parameters.employee_terms_id%TYPE;
573: l_sys_apply_advances_flag ap_system_parameters.apply_advances_default%TYPE;
574:
575: TYPE ReportHeaderIdType IS TABLE OF ap_expense_report_headers.report_header_id%TYPE

Line 572: l_emp_terms_id ap_system_parameters.employee_terms_id%TYPE;

568: l_rows_to_import NUMBER := 0;
569: l_expenses_fetched NUMBER := 0;
570: l_org_id NUMBER;
571: l_emp_pg_lookup_code ap_system_parameters.employee_pay_group_lookup_code%TYPE;
572: l_emp_terms_id ap_system_parameters.employee_terms_id%TYPE;
573: l_sys_apply_advances_flag ap_system_parameters.apply_advances_default%TYPE;
574:
575: TYPE ReportHeaderIdType IS TABLE OF ap_expense_report_headers.report_header_id%TYPE
576: INDEX BY BINARY_INTEGER;

Line 573: l_sys_apply_advances_flag ap_system_parameters.apply_advances_default%TYPE;

569: l_expenses_fetched NUMBER := 0;
570: l_org_id NUMBER;
571: l_emp_pg_lookup_code ap_system_parameters.employee_pay_group_lookup_code%TYPE;
572: l_emp_terms_id ap_system_parameters.employee_terms_id%TYPE;
573: l_sys_apply_advances_flag ap_system_parameters.apply_advances_default%TYPE;
574:
575: TYPE ReportHeaderIdType IS TABLE OF ap_expense_report_headers.report_header_id%TYPE
576: INDEX BY BINARY_INTEGER;
577: TYPE RejectCodeType IS TABLE OF ap_interface_rejections.reject_lookup_code%TYPE

Line 2750: FROM ap_system_parameters_all

2746:
2747: --Bug#7012808 - Payment Priority Defaulted to 99
2748: CURSOR c_create_supplier(l_org_id IN NUMBER) IS
2749: SELECT create_employee_vendor_flag, base_currency_code, employee_payment_priority
2750: FROM ap_system_parameters_all
2751: WHERE org_id = l_org_id;
2752:
2753:
2754: l_vendor_id NUMBER;

Line 2784: l_create_vendor_flag ap_system_parameters_all.create_employee_vendor_flag%TYPE;

2780: l_val_msg_count NUMBER;
2781: l_val_msg_data VARCHAR2(1000);
2782: l_vendor_rec AP_VENDOR_PUB_PKG.r_vendor_rec_type;
2783: l_vendor_site_rec AP_VENDOR_PUB_PKG.r_vendor_site_rec_type;
2784: l_create_vendor_flag ap_system_parameters_all.create_employee_vendor_flag%TYPE;
2785:
2786: l_supplier_numbering_method ap_product_setup.supplier_numbering_method%TYPE;
2787: l_base_currency_code ap_system_parameters.base_currency_code%TYPE;
2788:

Line 2787: l_base_currency_code ap_system_parameters.base_currency_code%TYPE;

2783: l_vendor_site_rec AP_VENDOR_PUB_PKG.r_vendor_site_rec_type;
2784: l_create_vendor_flag ap_system_parameters_all.create_employee_vendor_flag%TYPE;
2785:
2786: l_supplier_numbering_method ap_product_setup.supplier_numbering_method%TYPE;
2787: l_base_currency_code ap_system_parameters.base_currency_code%TYPE;
2788:
2789: BEGIN
2790:
2791: PrintVendorInfo(p_vendor_rec);