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_OPTIONS

Line 29: from hr_ki_options

25: begin
26:
27: select integration_id,option_type_id,option_level_id
28: into l_integration_id,l_option_type_id,l_option_level_id
29: from hr_ki_options
30: where OPTION_ID = X_OPTION_ID;
31:
32: if X_ENCRYPTED = 'Y' then
33: l_value := l_integration_id || '#'

Line 42: update HR_KI_OPTIONS

38: else
39: l_value := X_VALUE;
40: end if;
41:
42: update HR_KI_OPTIONS
43: set
44: VALUE = l_value ,
45: ENCRYPTED = X_ENCRYPTED,
46: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 75: cursor C is select ROWID from HR_KI_OPTIONS

71: X_LAST_UPDATED_BY in NUMBER,
72: X_LAST_UPDATE_LOGIN in NUMBER
73:
74: ) is
75: cursor C is select ROWID from HR_KI_OPTIONS
76: where option_id = X_OPTION_ID;
77:
78: l_value varchar2(1000);
79:

Line 81: select HR_KI_OPTIONS_S.NEXTVAL into X_OPTION_ID from sys.dual;

77:
78: l_value varchar2(1000);
79:
80: begin
81: select HR_KI_OPTIONS_S.NEXTVAL into X_OPTION_ID from sys.dual;
82: if X_ENCRYPTED = 'Y' then
83: l_value := X_INTEGRATION_ID || '#'
84: || X_OPTION_TYPE_ID || '#'
85: || X_OPTION_LEVEL_ID || '#'

Line 93: insert into HR_KI_OPTIONS (

89: else
90: l_value := X_VALUE;
91: end if;
92:
93: insert into HR_KI_OPTIONS (
94: OPTION_ID,
95: OPTION_TYPE_ID,
96: OPTION_LEVEL,
97: OPTION_LEVEL_ID,

Line 129: 'hr_ki_options.insert_row');

125: if (c%notfound) then
126: close c;
127: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
128: hr_utility.set_message_token('PROCEDURE',
129: 'hr_ki_options.insert_row');
130: hr_utility.set_message_token('STEP','1');
131: hr_utility.raise_error;
132: end if;
133: close c;

Line 251: l_proc VARCHAR2(31) := 'HR_KI_OPTIONS_API.LOAD_ROW';

247: X_CUSTOM_MODE in VARCHAR2,
248: X_LAST_UPDATE_DATE in VARCHAR2
249: )
250: is
251: l_proc VARCHAR2(31) := 'HR_KI_OPTIONS_API.LOAD_ROW';
252: l_rowid rowid;
253: l_created_by HR_KI_OPTIONS.created_by%TYPE := 0;
254: l_creation_date HR_KI_OPTIONS.creation_date%TYPE := SYSDATE;
255: l_last_update_date HR_KI_OPTIONS.last_update_date%TYPE := SYSDATE;

Line 253: l_created_by HR_KI_OPTIONS.created_by%TYPE := 0;

249: )
250: is
251: l_proc VARCHAR2(31) := 'HR_KI_OPTIONS_API.LOAD_ROW';
252: l_rowid rowid;
253: l_created_by HR_KI_OPTIONS.created_by%TYPE := 0;
254: l_creation_date HR_KI_OPTIONS.creation_date%TYPE := SYSDATE;
255: l_last_update_date HR_KI_OPTIONS.last_update_date%TYPE := SYSDATE;
256: l_last_updated_by HR_KI_OPTIONS.last_updated_by%TYPE := 0;
257: l_last_update_login HR_KI_OPTIONS.last_update_login%TYPE := 0;

Line 254: l_creation_date HR_KI_OPTIONS.creation_date%TYPE := SYSDATE;

250: is
251: l_proc VARCHAR2(31) := 'HR_KI_OPTIONS_API.LOAD_ROW';
252: l_rowid rowid;
253: l_created_by HR_KI_OPTIONS.created_by%TYPE := 0;
254: l_creation_date HR_KI_OPTIONS.creation_date%TYPE := SYSDATE;
255: l_last_update_date HR_KI_OPTIONS.last_update_date%TYPE := SYSDATE;
256: l_last_updated_by HR_KI_OPTIONS.last_updated_by%TYPE := 0;
257: l_last_update_login HR_KI_OPTIONS.last_update_login%TYPE := 0;
258: l_option_id HR_KI_OPTIONS.option_id%TYPE;

Line 255: l_last_update_date HR_KI_OPTIONS.last_update_date%TYPE := SYSDATE;

251: l_proc VARCHAR2(31) := 'HR_KI_OPTIONS_API.LOAD_ROW';
252: l_rowid rowid;
253: l_created_by HR_KI_OPTIONS.created_by%TYPE := 0;
254: l_creation_date HR_KI_OPTIONS.creation_date%TYPE := SYSDATE;
255: l_last_update_date HR_KI_OPTIONS.last_update_date%TYPE := SYSDATE;
256: l_last_updated_by HR_KI_OPTIONS.last_updated_by%TYPE := 0;
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;

Line 256: l_last_updated_by HR_KI_OPTIONS.last_updated_by%TYPE := 0;

252: l_rowid rowid;
253: l_created_by HR_KI_OPTIONS.created_by%TYPE := 0;
254: l_creation_date HR_KI_OPTIONS.creation_date%TYPE := SYSDATE;
255: l_last_update_date HR_KI_OPTIONS.last_update_date%TYPE := SYSDATE;
256: l_last_updated_by HR_KI_OPTIONS.last_updated_by%TYPE := 0;
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;

Line 257: l_last_update_login HR_KI_OPTIONS.last_update_login%TYPE := 0;

253: l_created_by HR_KI_OPTIONS.created_by%TYPE := 0;
254: l_creation_date HR_KI_OPTIONS.creation_date%TYPE := SYSDATE;
255: l_last_update_date HR_KI_OPTIONS.last_update_date%TYPE := SYSDATE;
256: l_last_updated_by HR_KI_OPTIONS.last_updated_by%TYPE := 0;
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;

Line 258: l_option_id HR_KI_OPTIONS.option_id%TYPE;

254: l_creation_date HR_KI_OPTIONS.creation_date%TYPE := SYSDATE;
255: l_last_update_date HR_KI_OPTIONS.last_update_date%TYPE := SYSDATE;
256: l_last_updated_by HR_KI_OPTIONS.last_updated_by%TYPE := 0;
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;

Line 259: l_option_level_id HR_KI_OPTIONS.option_level_id%TYPE;

255: l_last_update_date HR_KI_OPTIONS.last_update_date%TYPE := SYSDATE;
256: l_last_updated_by HR_KI_OPTIONS.last_updated_by%TYPE := 0;
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:

Line 262: l_object_version_number HR_KI_OPTIONS.object_version_number%TYPE;

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
266:

Line 270: from HR_KI_OPTIONS opt,HR_KI_OPTION_TYPES oty,

266:
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

Line 283: from HR_KI_OPTIONS opt,HR_KI_OPTION_TYPES oty,

279:
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

Line 296: from HR_KI_OPTIONS opt,HR_KI_OPTION_TYPES oty,

292:
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

Line 311: from HR_KI_OPTIONS opt,HR_KI_OPTION_TYPES oty,

307:
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

Line 329: from HR_KI_OPTIONS opt,HR_KI_OPTION_TYPES oty,

325:
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

Line 385: from HR_KI_OPTIONS

381: end if;
382:
383: select LAST_UPDATED_BY, LAST_UPDATE_DATE
384: into db_luby, db_ludate
385: from HR_KI_OPTIONS
386: where option_id = l_option_id;
387:
388:
389: if (fnd_load_util.upload_test(l_last_updated_by, l_last_update_date, db_luby,