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 197: l_base_currency ap_system_parameters_all.base_currency_code%TYPE;

193: l_prev_org_id NUMBER;
194: l_org_name hr_organization_units.name%TYPE;
195: l_print_header BOOLEAN := TRUE;
196: l_page_count NUMBER;
197: l_base_currency ap_system_parameters_all.base_currency_code%TYPE;
198: l_default_rate_type ap_system_parameters_all.default_exchange_rate_type%TYPE;
199: l_def_currency_code ap_expense_report_headers_all.default_currency_code%TYPE;
200: l_conv_amount NUMBER := 0;
201: l_total_func_amount NUMBER := 0;

Line 198: l_default_rate_type ap_system_parameters_all.default_exchange_rate_type%TYPE;

194: l_org_name hr_organization_units.name%TYPE;
195: l_print_header BOOLEAN := TRUE;
196: l_page_count NUMBER;
197: l_base_currency ap_system_parameters_all.base_currency_code%TYPE;
198: l_default_rate_type ap_system_parameters_all.default_exchange_rate_type%TYPE;
199: l_def_currency_code ap_expense_report_headers_all.default_currency_code%TYPE;
200: l_conv_amount NUMBER := 0;
201: l_total_func_amount NUMBER := 0;
202: l_rate NUMBER := 0;

Line 267: FROM ap_system_parameters_all where org_id = l_org_id;

263: l_header := 0;
264: BEGIN
265: SELECT base_currency_code, default_exchange_rate_type
266: INTO l_base_currency, l_default_rate_type
267: FROM ap_system_parameters_all where org_id = l_org_id;
268:
269: EXCEPTION
270: WHEN OTHERS THEN
271: NULL;

Line 452: FROM ap_system_parameters_all where org_id = l_org_id;

448: l_header := 0;
449: BEGIN
450: SELECT base_currency_code, default_exchange_rate_type
451: INTO l_base_currency, l_default_rate_type
452: FROM ap_system_parameters_all where org_id = l_org_id;
453:
454: EXCEPTION
455: WHEN OTHERS THEN
456: NULL;

Line 635: FROM ap_system_parameters_all where org_id = l_org_id;

631: l_header := 0;
632: BEGIN
633: SELECT base_currency_code, default_exchange_rate_type
634: INTO l_base_currency, l_default_rate_type
635: FROM ap_system_parameters_all where org_id = l_org_id;
636:
637: EXCEPTION
638: WHEN OTHERS THEN
639: NULL;

Line 1126: p_set_of_books_id IN ap_system_parameters.set_of_books_id%TYPE,

1122: -----------------------------------------------------------------------------------------------
1123: PROCEDURE ValidateGLDate(p_source_date IN DATE,
1124: p_valid_inv_gl_date IN DATE,
1125: p_source_item IN VARCHAR2,
1126: p_set_of_books_id IN ap_system_parameters.set_of_books_id%TYPE,
1127: p_open_gl_date OUT NOCOPY DATE,
1128: p_reject_code OUT NOCOPY ap_expense_report_headers.reject_code%TYPE) IS
1129: l_gl_period_status varchar2(2);
1130: l_new_gl_date ap_expense_report_headers_all.week_end_date%TYPE;

Line 1378: FROM ap_system_parameters_all sp,

1374: f.precision,
1375: sp.employee_pay_group_lookup_code,
1376: sp.employee_terms_id,
1377: sp.apply_advances_default
1378: FROM ap_system_parameters_all sp,
1379: financials_system_parameters fp,
1380: fnd_currencies f
1381: WHERE sp.base_currency_code = f.currency_code
1382: AND sp.org_id = l_org_id;

Line 1653: l_employee_terms_id ap_system_parameters.employee_terms_id%TYPE;

1649: l_batch_name VARCHAR2(50);
1650: l_debug_info VARCHAR2(2000);
1651: batch_failure EXCEPTION;
1652: validation_failed EXCEPTION;
1653: l_employee_terms_id ap_system_parameters.employee_terms_id%TYPE;
1654: l_base_currency ap_system_parameters.base_currency_code%TYPE;
1655: l_set_of_books_id ap_system_parameters.set_of_books_id%TYPE;
1656: l_enable_recoverable_flag financials_system_parameters.non_recoverable_tax_flag%TYPE;
1657: l_doc_category_override ap_system_parameters.inv_doc_category_override%TYPE;

Line 1654: l_base_currency ap_system_parameters.base_currency_code%TYPE;

1650: l_debug_info VARCHAR2(2000);
1651: batch_failure EXCEPTION;
1652: validation_failed EXCEPTION;
1653: l_employee_terms_id ap_system_parameters.employee_terms_id%TYPE;
1654: l_base_currency ap_system_parameters.base_currency_code%TYPE;
1655: l_set_of_books_id ap_system_parameters.set_of_books_id%TYPE;
1656: l_enable_recoverable_flag financials_system_parameters.non_recoverable_tax_flag%TYPE;
1657: l_doc_category_override ap_system_parameters.inv_doc_category_override%TYPE;
1658: l_gl_date_flag ap_system_parameters.gl_date_from_receipt_flag%TYPE;

Line 1655: l_set_of_books_id ap_system_parameters.set_of_books_id%TYPE;

1651: batch_failure EXCEPTION;
1652: validation_failed EXCEPTION;
1653: l_employee_terms_id ap_system_parameters.employee_terms_id%TYPE;
1654: l_base_currency ap_system_parameters.base_currency_code%TYPE;
1655: l_set_of_books_id ap_system_parameters.set_of_books_id%TYPE;
1656: l_enable_recoverable_flag financials_system_parameters.non_recoverable_tax_flag%TYPE;
1657: l_doc_category_override ap_system_parameters.inv_doc_category_override%TYPE;
1658: l_gl_date_flag ap_system_parameters.gl_date_from_receipt_flag%TYPE;
1659: l_address_flag financials_system_parameters.expense_check_address_flag%TYPE;

Line 1657: l_doc_category_override ap_system_parameters.inv_doc_category_override%TYPE;

1653: l_employee_terms_id ap_system_parameters.employee_terms_id%TYPE;
1654: l_base_currency ap_system_parameters.base_currency_code%TYPE;
1655: l_set_of_books_id ap_system_parameters.set_of_books_id%TYPE;
1656: l_enable_recoverable_flag financials_system_parameters.non_recoverable_tax_flag%TYPE;
1657: l_doc_category_override ap_system_parameters.inv_doc_category_override%TYPE;
1658: l_gl_date_flag ap_system_parameters.gl_date_from_receipt_flag%TYPE;
1659: l_address_flag financials_system_parameters.expense_check_address_flag%TYPE;
1660: l_min_accountable_unit NUMBER;
1661: l_precision NUMBER;

Line 1658: l_gl_date_flag ap_system_parameters.gl_date_from_receipt_flag%TYPE;

1654: l_base_currency ap_system_parameters.base_currency_code%TYPE;
1655: l_set_of_books_id ap_system_parameters.set_of_books_id%TYPE;
1656: l_enable_recoverable_flag financials_system_parameters.non_recoverable_tax_flag%TYPE;
1657: l_doc_category_override ap_system_parameters.inv_doc_category_override%TYPE;
1658: l_gl_date_flag ap_system_parameters.gl_date_from_receipt_flag%TYPE;
1659: l_address_flag financials_system_parameters.expense_check_address_flag%TYPE;
1660: l_min_accountable_unit NUMBER;
1661: l_precision NUMBER;
1662: vendor_valid_flag VARCHAR2(2);

Line 1685: l_emp_pg_lookup_code ap_system_parameters.employee_pay_group_lookup_code%TYPE;

1681: l_seq_profile VARCHAR2(2);
1682: l_rows_to_import NUMBER := 0;
1683: l_expenses_fetched NUMBER := 0;
1684: l_org_id NUMBER;
1685: l_emp_pg_lookup_code ap_system_parameters.employee_pay_group_lookup_code%TYPE;
1686: l_emp_terms_id ap_system_parameters.employee_terms_id%TYPE;
1687: l_sys_apply_advances_flag ap_system_parameters.apply_advances_default%TYPE;
1688:
1689: TYPE ReportHeaderIdType IS TABLE OF ap_expense_report_headers.report_header_id%TYPE

Line 1686: l_emp_terms_id ap_system_parameters.employee_terms_id%TYPE;

1682: l_rows_to_import NUMBER := 0;
1683: l_expenses_fetched NUMBER := 0;
1684: l_org_id NUMBER;
1685: l_emp_pg_lookup_code ap_system_parameters.employee_pay_group_lookup_code%TYPE;
1686: l_emp_terms_id ap_system_parameters.employee_terms_id%TYPE;
1687: l_sys_apply_advances_flag ap_system_parameters.apply_advances_default%TYPE;
1688:
1689: TYPE ReportHeaderIdType IS TABLE OF ap_expense_report_headers.report_header_id%TYPE
1690: INDEX BY BINARY_INTEGER;

Line 1687: l_sys_apply_advances_flag ap_system_parameters.apply_advances_default%TYPE;

1683: l_expenses_fetched NUMBER := 0;
1684: l_org_id NUMBER;
1685: l_emp_pg_lookup_code ap_system_parameters.employee_pay_group_lookup_code%TYPE;
1686: l_emp_terms_id ap_system_parameters.employee_terms_id%TYPE;
1687: l_sys_apply_advances_flag ap_system_parameters.apply_advances_default%TYPE;
1688:
1689: TYPE ReportHeaderIdType IS TABLE OF ap_expense_report_headers.report_header_id%TYPE
1690: INDEX BY BINARY_INTEGER;
1691: TYPE RejectCodeType IS TABLE OF ap_interface_rejections.reject_lookup_code%TYPE

Line 3859: FROM ap_system_parameters_all

3855:
3856: --Bug#7012808 - Payment Priority Defaulted to 99
3857: CURSOR c_create_supplier(l_org_id IN NUMBER) IS
3858: SELECT create_employee_vendor_flag, base_currency_code, employee_payment_priority
3859: FROM ap_system_parameters_all
3860: WHERE org_id = l_org_id;
3861:
3862:
3863: l_vendor_id NUMBER;

Line 3893: l_create_vendor_flag ap_system_parameters_all.create_employee_vendor_flag%TYPE;

3889: l_val_msg_count NUMBER;
3890: l_val_msg_data VARCHAR2(1000);
3891: l_vendor_rec AP_VENDOR_PUB_PKG.r_vendor_rec_type;
3892: l_vendor_site_rec AP_VENDOR_PUB_PKG.r_vendor_site_rec_type;
3893: l_create_vendor_flag ap_system_parameters_all.create_employee_vendor_flag%TYPE;
3894:
3895: l_supplier_numbering_method ap_product_setup.supplier_numbering_method%TYPE;
3896: l_base_currency_code ap_system_parameters.base_currency_code%TYPE;
3897:

Line 3896: l_base_currency_code ap_system_parameters.base_currency_code%TYPE;

3892: l_vendor_site_rec AP_VENDOR_PUB_PKG.r_vendor_site_rec_type;
3893: l_create_vendor_flag ap_system_parameters_all.create_employee_vendor_flag%TYPE;
3894:
3895: l_supplier_numbering_method ap_product_setup.supplier_numbering_method%TYPE;
3896: l_base_currency_code ap_system_parameters.base_currency_code%TYPE;
3897:
3898: BEGIN
3899:
3900: PrintVendorInfo(p_vendor_rec);