APPS.AP_WEB_MANAGEMENT_REPORTS_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 21: FROM ap_system_parameters;

17:
18: -- Bug# 8988384: Exchange rate type should be considered from OIE setup and then from Payables setup.
19: SELECT base_currency_code, nvl((select exchange_rate_type from ap_pol_exrate_options where enabled = 'Y'), default_exchange_rate_type) exchange_rate_type
20: INTO P_BaseCurrencyCode, P_ExchangeRateType
21: FROM ap_system_parameters;
22:
23: EXCEPTION
24: WHEN TOO_MANY_ROWS THEN
25: AP_WEB_DB_UTIL_PKG.RaiseException ('AP_WEB_MANAGEMENT_REPORTS_PKG.GetBaseCurrencyInfo',

Line 62: FROM ap_system_parameters SP,

58: -- and a date.
59: --
60: CURSOR C_PeriodDateRange ( P_PeriodType VARCHAR2, P_Date VARCHAR2 ) IS
61: SELECT glps.start_date, glps.end_date
62: FROM ap_system_parameters SP,
63: gl_sets_of_books SOB,
64: gl_date_period_map map,
65: gl_periods glps
66: WHERE SOB.set_of_books_id = SP.set_of_books_id

Line 346: L_BaseCurrencyCode ap_system_parameters.BASE_CURRENCY_CODE%TYPE;

342: L_ByManagerTab ByManagerTabType;
343:
344: L_TabIndex BINARY_INTEGER := 0;
345: L_EmployeeId ap_expense_report_headers.EMPLOYEE_ID%TYPE;
346: L_BaseCurrencyCode ap_system_parameters.BASE_CURRENCY_CODE%TYPE;
347: L_ExchangeRateType ap_system_parameters.DEFAULT_EXCHANGE_RATE_TYPE%TYPE;
348: L_ExpenseAmount NUMBER := 0;
349: L_ViolationLineAmount NUMBER;
350: L_ViolationAmount NUMBER;

Line 347: L_ExchangeRateType ap_system_parameters.DEFAULT_EXCHANGE_RATE_TYPE%TYPE;

343:
344: L_TabIndex BINARY_INTEGER := 0;
345: L_EmployeeId ap_expense_report_headers.EMPLOYEE_ID%TYPE;
346: L_BaseCurrencyCode ap_system_parameters.BASE_CURRENCY_CODE%TYPE;
347: L_ExchangeRateType ap_system_parameters.DEFAULT_EXCHANGE_RATE_TYPE%TYPE;
348: L_ExpenseAmount NUMBER := 0;
349: L_ViolationLineAmount NUMBER;
350: L_ViolationAmount NUMBER;
351: L_Convert BOOLEAN := FALSE;

Line 894: L_BaseCurrencyCode ap_system_parameters.BASE_CURRENCY_CODE%TYPE;

890: L_ByExpCatTab ByExpenseCategoryTabType;
891:
892: L_TabIndex BINARY_INTEGER := 0;
893: L_EmployeeId ap_expense_report_headers.EMPLOYEE_ID%TYPE;
894: L_BaseCurrencyCode ap_system_parameters.BASE_CURRENCY_CODE%TYPE;
895: L_ExchangeRateType ap_system_parameters.DEFAULT_EXCHANGE_RATE_TYPE%TYPE;
896: L_ExpenseCategory ap_lookup_codes.LOOKUP_CODE%TYPE;
897: L_ExpenseAmount NUMBER := 0;
898: L_ViolationLineAmount NUMBER;

Line 895: L_ExchangeRateType ap_system_parameters.DEFAULT_EXCHANGE_RATE_TYPE%TYPE;

891:
892: L_TabIndex BINARY_INTEGER := 0;
893: L_EmployeeId ap_expense_report_headers.EMPLOYEE_ID%TYPE;
894: L_BaseCurrencyCode ap_system_parameters.BASE_CURRENCY_CODE%TYPE;
895: L_ExchangeRateType ap_system_parameters.DEFAULT_EXCHANGE_RATE_TYPE%TYPE;
896: L_ExpenseCategory ap_lookup_codes.LOOKUP_CODE%TYPE;
897: L_ExpenseAmount NUMBER := 0;
898: L_ViolationLineAmount NUMBER;
899: L_ViolationAmount NUMBER;

Line 1465: L_BaseCurrencyCode ap_system_parameters.BASE_CURRENCY_CODE%TYPE;

1461: L_ByViolTypeTab ByViolationTypeTabType;
1462:
1463: L_TabIndex BINARY_INTEGER := 0;
1464: L_EmployeeId ap_expense_report_headers.EMPLOYEE_ID%TYPE;
1465: L_BaseCurrencyCode ap_system_parameters.BASE_CURRENCY_CODE%TYPE;
1466: L_ExchangeRateType ap_system_parameters.DEFAULT_EXCHANGE_RATE_TYPE%TYPE;
1467: L_ViolationType ap_lookup_codes.LOOKUP_CODE%TYPE;
1468: L_ViolationLineAmount NUMBER;
1469: L_ViolationAmount NUMBER;

Line 1466: L_ExchangeRateType ap_system_parameters.DEFAULT_EXCHANGE_RATE_TYPE%TYPE;

1462:
1463: L_TabIndex BINARY_INTEGER := 0;
1464: L_EmployeeId ap_expense_report_headers.EMPLOYEE_ID%TYPE;
1465: L_BaseCurrencyCode ap_system_parameters.BASE_CURRENCY_CODE%TYPE;
1466: L_ExchangeRateType ap_system_parameters.DEFAULT_EXCHANGE_RATE_TYPE%TYPE;
1467: L_ViolationType ap_lookup_codes.LOOKUP_CODE%TYPE;
1468: L_ViolationLineAmount NUMBER;
1469: L_ViolationAmount NUMBER;
1470: L_AllowableAmount NUMBER;