eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PUMP_UTILS dependencies on HR_API

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 210: HR_API_MODULE_INTERNAL.CREATE_API_MODULE

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
211: (P_VALIDATE => FALSE
212: ,P_EFFECTIVE_DATE => HR_API.G_SYS
213: ,P_API_MODULE_TYPE => L_API_MODULE_TYPE
214: ,P_MODULE_NAME => L_MODULE_NAME

Line 212: ,P_EFFECTIVE_DATE => HR_API.G_SYS

208: IF CSR_API_MODULE_ID%NOTFOUND THEN
209: CLOSE CSR_API_MODULE_ID;
210: HR_API_MODULE_INTERNAL.CREATE_API_MODULE
211: (P_VALIDATE => FALSE
212: ,P_EFFECTIVE_DATE => HR_API.G_SYS
213: ,P_API_MODULE_TYPE => L_API_MODULE_TYPE
214: ,P_MODULE_NAME => L_MODULE_NAME
215: ,P_DATA_WITHIN_BUSINESS_GROUP => L_DATA_WITHIN_BUSINESS_GROUP
216: ,P_LEGISLATION_CODE => L_LEGISLATION_CODE

Line 222: HR_API_MODULE_INTERNAL.UPDATE_API_MODULE

218: ,P_API_MODULE_ID => L_API_MODULE_ID
219: );
220: ELSE
221: CLOSE CSR_API_MODULE_ID;
222: HR_API_MODULE_INTERNAL.UPDATE_API_MODULE
223: (P_VALIDATE => FALSE
224: ,P_API_MODULE_ID => L_API_MODULE_ID
225: ,P_MODULE_NAME => L_MODULE_NAME
226: ,P_MODULE_PACKAGE => L_MODULE_PACKAGE

Line 228: ,P_EFFECTIVE_DATE => HR_API.G_SYS

224: ,P_API_MODULE_ID => L_API_MODULE_ID
225: ,P_MODULE_NAME => L_MODULE_NAME
226: ,P_MODULE_PACKAGE => L_MODULE_PACKAGE
227: ,P_DATA_WITHIN_BUSINESS_GROUP => L_DATA_WITHIN_BUSINESS_GROUP
228: ,P_EFFECTIVE_DATE => HR_API.G_SYS
229: );
230: END IF;
231: END SEED_API;
232:

Line 329: AND NVL(UPPER(MODULE_NAME), HR_API.G_VARCHAR2) =

325: --
326: DELETE
327: FROM HR_PUMP_MAPPING_PACKAGES
328: WHERE UPPER(MAPPING_PACKAGE) = L_MAPPING_PACKAGE
329: AND NVL(UPPER(MODULE_NAME), HR_API.G_VARCHAR2) =
330: NVL(L_MODULE_NAME, HR_API.G_VARCHAR2)
331: AND NVL(UPPER(API_MODULE_TYPE), HR_API.G_VARCHAR2) =
332: NVL(L_API_MODULE_TYPE, HR_API.G_VARCHAR2)
333: AND NVL(UPPER(MODULE_PACKAGE), HR_API.G_VARCHAR2) =

Line 330: NVL(L_MODULE_NAME, HR_API.G_VARCHAR2)

326: DELETE
327: FROM HR_PUMP_MAPPING_PACKAGES
328: WHERE UPPER(MAPPING_PACKAGE) = L_MAPPING_PACKAGE
329: AND NVL(UPPER(MODULE_NAME), HR_API.G_VARCHAR2) =
330: NVL(L_MODULE_NAME, HR_API.G_VARCHAR2)
331: AND NVL(UPPER(API_MODULE_TYPE), HR_API.G_VARCHAR2) =
332: NVL(L_API_MODULE_TYPE, HR_API.G_VARCHAR2)
333: AND NVL(UPPER(MODULE_PACKAGE), HR_API.G_VARCHAR2) =
334: NVL(L_MODULE_PACKAGE, HR_API.G_VARCHAR2);

Line 331: AND NVL(UPPER(API_MODULE_TYPE), HR_API.G_VARCHAR2) =

327: FROM HR_PUMP_MAPPING_PACKAGES
328: WHERE UPPER(MAPPING_PACKAGE) = L_MAPPING_PACKAGE
329: AND NVL(UPPER(MODULE_NAME), HR_API.G_VARCHAR2) =
330: NVL(L_MODULE_NAME, HR_API.G_VARCHAR2)
331: AND NVL(UPPER(API_MODULE_TYPE), HR_API.G_VARCHAR2) =
332: NVL(L_API_MODULE_TYPE, HR_API.G_VARCHAR2)
333: AND NVL(UPPER(MODULE_PACKAGE), HR_API.G_VARCHAR2) =
334: NVL(L_MODULE_PACKAGE, HR_API.G_VARCHAR2);
335: --

Line 332: NVL(L_API_MODULE_TYPE, HR_API.G_VARCHAR2)

328: WHERE UPPER(MAPPING_PACKAGE) = L_MAPPING_PACKAGE
329: AND NVL(UPPER(MODULE_NAME), HR_API.G_VARCHAR2) =
330: NVL(L_MODULE_NAME, HR_API.G_VARCHAR2)
331: AND NVL(UPPER(API_MODULE_TYPE), HR_API.G_VARCHAR2) =
332: NVL(L_API_MODULE_TYPE, HR_API.G_VARCHAR2)
333: AND NVL(UPPER(MODULE_PACKAGE), HR_API.G_VARCHAR2) =
334: NVL(L_MODULE_PACKAGE, HR_API.G_VARCHAR2);
335: --
336: INSERT

Line 333: AND NVL(UPPER(MODULE_PACKAGE), HR_API.G_VARCHAR2) =

329: AND NVL(UPPER(MODULE_NAME), HR_API.G_VARCHAR2) =
330: NVL(L_MODULE_NAME, HR_API.G_VARCHAR2)
331: AND NVL(UPPER(API_MODULE_TYPE), HR_API.G_VARCHAR2) =
332: NVL(L_API_MODULE_TYPE, HR_API.G_VARCHAR2)
333: AND NVL(UPPER(MODULE_PACKAGE), HR_API.G_VARCHAR2) =
334: NVL(L_MODULE_PACKAGE, HR_API.G_VARCHAR2);
335: --
336: INSERT
337: INTO HR_PUMP_MAPPING_PACKAGES

Line 334: NVL(L_MODULE_PACKAGE, HR_API.G_VARCHAR2);

330: NVL(L_MODULE_NAME, HR_API.G_VARCHAR2)
331: AND NVL(UPPER(API_MODULE_TYPE), HR_API.G_VARCHAR2) =
332: NVL(L_API_MODULE_TYPE, HR_API.G_VARCHAR2)
333: AND NVL(UPPER(MODULE_PACKAGE), HR_API.G_VARCHAR2) =
334: NVL(L_MODULE_PACKAGE, HR_API.G_VARCHAR2);
335: --
336: INSERT
337: INTO HR_PUMP_MAPPING_PACKAGES
338: (MAPPING_PACKAGE

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