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_KI_OPT_LOAD_API dependencies on HR_KI_INTEGRATIONS

Line 153: hr_ki_integrations

149: is
150: CURSOR CUR_VALIDATE_INT IS
151: select integration_id
152: from
153: hr_ki_integrations
154: where
155: upper(integration_key) = upper(X_INTEGRATION_KEY);
156:
157: CURSOR CUR_VALIDATE_OTY IS

Line 261: l_integration_id HR_KI_INTEGRATIONS.integration_id%TYPE;

257: l_last_update_login HR_KI_OPTIONS.last_update_login%TYPE := 0;
258: l_option_id HR_KI_OPTIONS.option_id%TYPE;
259: l_option_level_id HR_KI_OPTIONS.option_level_id%TYPE;
260: l_option_type_id HR_KI_OPTION_TYPES.option_type_id%TYPE;
261: l_integration_id HR_KI_INTEGRATIONS.integration_id%TYPE;
262: l_object_version_number HR_KI_OPTIONS.object_version_number%TYPE;
263:
264: db_luby number; -- entity owner in db
265: db_ludate date; -- entity update date in db

Line 271: hr_ki_integrations int

267: CURSOR CUR_VALIDATE_SITE IS
268: select
269: distinct opt.option_id,opt.object_version_number
270: from HR_KI_OPTIONS opt,HR_KI_OPTION_TYPES oty,
271: hr_ki_integrations int
272: where
273: opt.option_type_id=oty.option_type_id
274: and int.integration_id=opt.integration_id
275: and upper(int.integration_key) = upper(X_INTEGRATION_KEY)

Line 284: hr_ki_integrations int

280: CURSOR CUR_VALIDATE_ROLE IS
281: select
282: distinct opt.option_id,opt.object_version_number
283: from HR_KI_OPTIONS opt,HR_KI_OPTION_TYPES oty,
284: hr_ki_integrations int
285: where
286: opt.option_type_id=oty.option_type_id
287: and int.integration_id=opt.integration_id
288: and upper(int.integration_key) = upper(X_INTEGRATION_KEY)

Line 297: hr_ki_integrations int,

293: CURSOR CUR_VALIDATE_USER IS
294: select
295: distinct opt.option_id,opt.object_version_number
296: from HR_KI_OPTIONS opt,HR_KI_OPTION_TYPES oty,
297: hr_ki_integrations int,
298: fnd_user usr
299: where
300: opt.option_type_id=oty.option_type_id
301: and int.integration_id=opt.integration_id

Line 312: hr_ki_integrations int,

308: CURSOR CUR_VALIDATE_RESP IS
309: select
310: distinct opt.option_id,opt.object_version_number
311: from HR_KI_OPTIONS opt,HR_KI_OPTION_TYPES oty,
312: hr_ki_integrations int,
313: fnd_responsibility resp
314: where
315: opt.option_type_id=oty.option_type_id
316: and int.integration_id=opt.integration_id

Line 330: hr_ki_integrations int,

326: CURSOR CUR_VALIDATE_APP IS
327: select
328: distinct opt.option_id,opt.object_version_number
329: from HR_KI_OPTIONS opt,HR_KI_OPTION_TYPES oty,
330: hr_ki_integrations int,
331: fnd_application app
332: where
333: opt.option_type_id=oty.option_type_id
334: and int.integration_id=opt.integration_id