APPS.AP_WEB_EXPORT_ER dependencies on AP_SYSTEM_PARAMETERS_ALL

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 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 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: