APPS.AP_WEB_MANAGEMENT_REPORTS_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 20: FROM ap_system_parameters;

16: BEGIN
17:
18: SELECT base_currency_code, default_exchange_rate_type
19: INTO P_BaseCurrencyCode, P_ExchangeRateType
20: FROM ap_system_parameters;
21:
22: EXCEPTION
23: WHEN TOO_MANY_ROWS THEN
24: AP_WEB_DB_UTIL_PKG.RaiseException ('AP_WEB_MANAGEMENT_REPORTS_PKG.GetBaseCurrencyInfo',

Line 61: FROM ap_system_parameters SP,

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

Line 335: L_BaseCurrencyCode ap_system_parameters.BASE_CURRENCY_CODE%TYPE;

331: L_ByManagerTab ByManagerTabType;
332:
333: L_TabIndex BINARY_INTEGER := 0;
334: L_EmployeeId ap_expense_report_headers.EMPLOYEE_ID%TYPE;
335: L_BaseCurrencyCode ap_system_parameters.BASE_CURRENCY_CODE%TYPE;
336: L_ExchangeRateType ap_system_parameters.DEFAULT_EXCHANGE_RATE_TYPE%TYPE;
337: L_ExpenseAmount NUMBER := 0;
338: L_ViolationLineAmount NUMBER;
339: L_ViolationAmount NUMBER;

Line 336: L_ExchangeRateType ap_system_parameters.DEFAULT_EXCHANGE_RATE_TYPE%TYPE;

332:
333: L_TabIndex BINARY_INTEGER := 0;
334: L_EmployeeId ap_expense_report_headers.EMPLOYEE_ID%TYPE;
335: L_BaseCurrencyCode ap_system_parameters.BASE_CURRENCY_CODE%TYPE;
336: L_ExchangeRateType ap_system_parameters.DEFAULT_EXCHANGE_RATE_TYPE%TYPE;
337: L_ExpenseAmount NUMBER := 0;
338: L_ViolationLineAmount NUMBER;
339: L_ViolationAmount NUMBER;
340: L_Convert BOOLEAN := FALSE;

Line 877: L_BaseCurrencyCode ap_system_parameters.BASE_CURRENCY_CODE%TYPE;

873: L_ByExpCatTab ByExpenseCategoryTabType;
874:
875: L_TabIndex BINARY_INTEGER := 0;
876: L_EmployeeId ap_expense_report_headers.EMPLOYEE_ID%TYPE;
877: L_BaseCurrencyCode ap_system_parameters.BASE_CURRENCY_CODE%TYPE;
878: L_ExchangeRateType ap_system_parameters.DEFAULT_EXCHANGE_RATE_TYPE%TYPE;
879: L_ExpenseCategory ap_lookup_codes.LOOKUP_CODE%TYPE;
880: L_ExpenseAmount NUMBER := 0;
881: L_ViolationLineAmount NUMBER;

Line 878: L_ExchangeRateType ap_system_parameters.DEFAULT_EXCHANGE_RATE_TYPE%TYPE;

874:
875: L_TabIndex BINARY_INTEGER := 0;
876: L_EmployeeId ap_expense_report_headers.EMPLOYEE_ID%TYPE;
877: L_BaseCurrencyCode ap_system_parameters.BASE_CURRENCY_CODE%TYPE;
878: L_ExchangeRateType ap_system_parameters.DEFAULT_EXCHANGE_RATE_TYPE%TYPE;
879: L_ExpenseCategory ap_lookup_codes.LOOKUP_CODE%TYPE;
880: L_ExpenseAmount NUMBER := 0;
881: L_ViolationLineAmount NUMBER;
882: L_ViolationAmount NUMBER;

Line 1444: L_BaseCurrencyCode ap_system_parameters.BASE_CURRENCY_CODE%TYPE;

1440: L_ByViolTypeTab ByViolationTypeTabType;
1441:
1442: L_TabIndex BINARY_INTEGER := 0;
1443: L_EmployeeId ap_expense_report_headers.EMPLOYEE_ID%TYPE;
1444: L_BaseCurrencyCode ap_system_parameters.BASE_CURRENCY_CODE%TYPE;
1445: L_ExchangeRateType ap_system_parameters.DEFAULT_EXCHANGE_RATE_TYPE%TYPE;
1446: L_ViolationType ap_lookup_codes.LOOKUP_CODE%TYPE;
1447: L_ViolationLineAmount NUMBER;
1448: L_ViolationAmount NUMBER;

Line 1445: L_ExchangeRateType ap_system_parameters.DEFAULT_EXCHANGE_RATE_TYPE%TYPE;

1441:
1442: L_TabIndex BINARY_INTEGER := 0;
1443: L_EmployeeId ap_expense_report_headers.EMPLOYEE_ID%TYPE;
1444: L_BaseCurrencyCode ap_system_parameters.BASE_CURRENCY_CODE%TYPE;
1445: L_ExchangeRateType ap_system_parameters.DEFAULT_EXCHANGE_RATE_TYPE%TYPE;
1446: L_ViolationType ap_lookup_codes.LOOKUP_CODE%TYPE;
1447: L_ViolationLineAmount NUMBER;
1448: L_ViolationAmount NUMBER;
1449: L_AllowableAmount NUMBER;