APPS.AP_WEB_OA_REPORTING_UTIL dependencies on AP_SYSTEM_PARAMETERS

Line 135: l_base_currency_code AP_SYSTEM_PARAMETERS.base_currency_code%Type;

131: p_base_currency_code OUT NOCOPY VARCHAR2,
132: p_exchange_rate_type OUT NOCOPY VARCHAR2)
133: IS
134: l_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;
135: l_base_currency_code AP_SYSTEM_PARAMETERS.base_currency_code%Type;
136: l_exchange_rate_type AP_SYSTEM_PARAMETERS.default_exchange_rate_type%Type;
137: BEGIN
138:
139: -- Query up the Chart of Accounts Id for the Employee

Line 136: l_exchange_rate_type AP_SYSTEM_PARAMETERS.default_exchange_rate_type%Type;

132: p_exchange_rate_type OUT NOCOPY VARCHAR2)
133: IS
134: l_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;
135: l_base_currency_code AP_SYSTEM_PARAMETERS.base_currency_code%Type;
136: l_exchange_rate_type AP_SYSTEM_PARAMETERS.default_exchange_rate_type%Type;
137: BEGIN
138:
139: -- Query up the Chart of Accounts Id for the Employee
140: SELECT GS.chart_of_accounts_id, S.base_currency_code, S.default_exchange_rate_type

Line 142: FROM ap_system_parameters S,

138:
139: -- Query up the Chart of Accounts Id for the Employee
140: SELECT GS.chart_of_accounts_id, S.base_currency_code, S.default_exchange_rate_type
141: INTO l_chart_of_accounts_id, l_base_currency_code, l_exchange_rate_type
142: FROM ap_system_parameters S,
143: gl_sets_of_books GS
144: WHERE GS.set_of_books_id = S.set_of_books_id
145: AND rownum = 1;
146:

Line 174: FROM ap_system_parameters;

170: BEGIN
171:
172: SELECT base_currency_code, default_exchange_rate_type
173: INTO P_BaseCurrencyCode, P_ExchangeRateType
174: FROM ap_system_parameters;
175:
176: EXCEPTION
177: WHEN TOO_MANY_ROWS THEN
178: AP_WEB_DB_UTIL_PKG.RaiseException ('AP_WEB_OA_REPORTING_UTIL',

Line 179: 'Too many rows found in ap_system_parameters');

175:
176: EXCEPTION
177: WHEN TOO_MANY_ROWS THEN
178: AP_WEB_DB_UTIL_PKG.RaiseException ('AP_WEB_OA_REPORTING_UTIL',
179: 'Too many rows found in ap_system_parameters');
180: APP_EXCEPTION.RAISE_EXCEPTION;
181: WHEN NO_DATA_FOUND THEN
182: AP_WEB_DB_UTIL_PKG.RaiseException ('AP_WEB_OA_REPORTING_UTIL',
183: 'No Data Found in ap_system_parameters');

Line 183: 'No Data Found in ap_system_parameters');

179: 'Too many rows found in ap_system_parameters');
180: APP_EXCEPTION.RAISE_EXCEPTION;
181: WHEN NO_DATA_FOUND THEN
182: AP_WEB_DB_UTIL_PKG.RaiseException ('AP_WEB_OA_REPORTING_UTIL',
183: 'No Data Found in ap_system_parameters');
184: APP_EXCEPTION.RAISE_EXCEPTION;
185: WHEN OTHERS THEN
186: AP_WEB_DB_UTIL_PKG.RaiseException ('AP_WEB_OA_REPORTING_UTIL',
187: SQLERRM);