APPS.HR_PUMP_UTILS dependencies on HR_API_MODULES

Line 186: FROM HR_API_MODULES

182: (P_MODULE_NAME IN VARCHAR2
183: ,P_API_MODULE_TYPE IN VARCHAR2
184: ) IS
185: SELECT API_MODULE_ID
186: FROM HR_API_MODULES
187: WHERE UPPER(MODULE_NAME) = P_MODULE_NAME
188: AND UPPER(API_MODULE_TYPE) = P_API_MODULE_TYPE;
189: BEGIN
190: L_MODULE_NAME := UPPER(P_MODULE_NAME);

Line 206: -- HR_API_MODULES exists.

202: FETCH CSR_API_MODULE_ID
203: INTO L_API_MODULE_ID;
204: --
205: -- Call the appropriate API depending on whether or not a row in
206: -- HR_API_MODULES exists.
207: --
208: IF CSR_API_MODULE_ID%NOTFOUND THEN
209: CLOSE CSR_API_MODULE_ID;
210: HR_API_MODULE_INTERNAL.CREATE_API_MODULE

Line 491: from hr_api_modules

487: is
488:
489: cursor csr_get_api_module_id (p_module_name hr_pump_spread_loaders.module_name%type) is
490: select api_module_id
491: from hr_api_modules
492: where module_name = p_module_name
493: and api_module_type in ('AI','BP');
494:
495: cursor csr_chk_row_exists is