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_HRC_LOAD_API dependencies on HR_KI_HIERARCHIES

Line 25: update HR_KI_HIERARCHIES

21:
22: begin
23:
24:
25: update HR_KI_HIERARCHIES
26: set
27: PARENT_HIERARCHY_ID = X_PARENT_HIERARCHY_ID,
28: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
29: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 35: update HR_KI_HIERARCHIES_TL set

31: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER+1
32: where HIERARCHY_ID = X_HIERARCHY_ID;
33:
34:
35: update HR_KI_HIERARCHIES_TL set
36: NAME = X_NAME,
37: DESCRIPTION = X_DESCRIPTION,
38: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
39: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 47: insert into HR_KI_HIERARCHIES_TL (

43: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
44:
45: if (sql%notfound) then
46:
47: insert into HR_KI_HIERARCHIES_TL (
48: HIERARCHY_ID,
49: NAME,
50: DESCRIPTION,
51: CREATED_BY,

Line 73: from HR_KI_HIERARCHIES_TL T

69: from FND_LANGUAGES L
70: where L.INSTALLED_FLAG in ('I', 'B')
71: and not exists
72: (select NULL
73: from HR_KI_HIERARCHIES_TL T
74: where T.hierarchy_id = X_hierarchy_id
75: and T.LANGUAGE = L.LANGUAGE_CODE);
76:
77: end if;

Line 97: cursor C is select ROWID from HR_KI_HIERARCHIES

93: X_LAST_UPDATE_LOGIN in NUMBER
94:
95: ) is
96:
97: cursor C is select ROWID from HR_KI_HIERARCHIES
98: where hierarchy_id = X_HIERARCHY_ID;
99:
100: begin
101:

Line 102: select HR_KI_HIERARCHIES_S.NEXTVAL into X_HIERARCHY_ID from sys.dual;

98: where hierarchy_id = X_HIERARCHY_ID;
99:
100: begin
101:
102: select HR_KI_HIERARCHIES_S.NEXTVAL into X_HIERARCHY_ID from sys.dual;
103:
104: insert into HR_KI_HIERARCHIES (
105: HIERARCHY_ID,
106: HIERARCHY_KEY,

Line 104: insert into HR_KI_HIERARCHIES (

100: begin
101:
102: select HR_KI_HIERARCHIES_S.NEXTVAL into X_HIERARCHY_ID from sys.dual;
103:
104: insert into HR_KI_HIERARCHIES (
105: HIERARCHY_ID,
106: HIERARCHY_KEY,
107: PARENT_HIERARCHY_ID,
108: CREATION_DATE,

Line 127: insert into HR_KI_HIERARCHIES_TL (

123: 1
124: );
125:
126:
127: insert into HR_KI_HIERARCHIES_TL (
128: HIERARCHY_ID,
129: NAME,
130: DESCRIPTION,
131: CREATED_BY,

Line 153: from HR_KI_HIERARCHIES_TL T

149: from FND_LANGUAGES L
150: where L.INSTALLED_FLAG in ('I', 'B')
151: and not exists
152: (select NULL
153: from HR_KI_HIERARCHIES_TL T
154: where T.hierarchy_id = X_hierarchy_id
155: and T.LANGUAGE = L.LANGUAGE_CODE);
156:
157: open c;

Line 163: 'HR_KI_HIERARCHIES.insert_row');

159: if (c%notfound) then
160: close c;
161: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
162: hr_utility.set_message_token('PROCEDURE',
163: 'HR_KI_HIERARCHIES.insert_row');
164: hr_utility.set_message_token('STEP','1');
165: hr_utility.raise_error;
166: end if;
167: close c;

Line 180: l_hierarchy_id HR_KI_HIERARCHIES.hierarchy_id%TYPE;

176: )
177: is
178:
179: l_proc VARCHAR2(61) := 'HR_KI_HRC_LOAD_API.VALIDATE_PARENT_KEY';
180: l_hierarchy_id HR_KI_HIERARCHIES.hierarchy_id%TYPE;
181:
182: CURSOR C_VAL IS
183: select hierarchy_id
184: from HR_KI_HIERARCHIES

Line 184: from HR_KI_HIERARCHIES

180: l_hierarchy_id HR_KI_HIERARCHIES.hierarchy_id%TYPE;
181:
182: CURSOR C_VAL IS
183: select hierarchy_id
184: from HR_KI_HIERARCHIES
185: where upper(hierarchy_key) = upper(X_PARENT_HIERARCHY_KEY);
186:
187: begin
188:

Line 224: l_created_by HR_KI_HIERARCHIES.created_by%TYPE := 0;

220: )
221: is
222: l_proc VARCHAR2(31) := 'HR_KI_HRC_LOAD_API.LOAD_ROW';
223: l_rowid rowid;
224: l_created_by HR_KI_HIERARCHIES.created_by%TYPE := 0;
225: l_creation_date HR_KI_HIERARCHIES.creation_date%TYPE := SYSDATE;
226: l_last_update_date HR_KI_HIERARCHIES.last_update_date%TYPE := SYSDATE;
227: l_last_updated_by HR_KI_HIERARCHIES.last_updated_by%TYPE := 0;
228: l_last_update_login HR_KI_HIERARCHIES.last_update_login%TYPE := 0;

Line 225: l_creation_date HR_KI_HIERARCHIES.creation_date%TYPE := SYSDATE;

221: is
222: l_proc VARCHAR2(31) := 'HR_KI_HRC_LOAD_API.LOAD_ROW';
223: l_rowid rowid;
224: l_created_by HR_KI_HIERARCHIES.created_by%TYPE := 0;
225: l_creation_date HR_KI_HIERARCHIES.creation_date%TYPE := SYSDATE;
226: l_last_update_date HR_KI_HIERARCHIES.last_update_date%TYPE := SYSDATE;
227: l_last_updated_by HR_KI_HIERARCHIES.last_updated_by%TYPE := 0;
228: l_last_update_login HR_KI_HIERARCHIES.last_update_login%TYPE := 0;
229: l_hierarchy_id HR_KI_HIERARCHIES.hierarchy_id%TYPE;

Line 226: l_last_update_date HR_KI_HIERARCHIES.last_update_date%TYPE := SYSDATE;

222: l_proc VARCHAR2(31) := 'HR_KI_HRC_LOAD_API.LOAD_ROW';
223: l_rowid rowid;
224: l_created_by HR_KI_HIERARCHIES.created_by%TYPE := 0;
225: l_creation_date HR_KI_HIERARCHIES.creation_date%TYPE := SYSDATE;
226: l_last_update_date HR_KI_HIERARCHIES.last_update_date%TYPE := SYSDATE;
227: l_last_updated_by HR_KI_HIERARCHIES.last_updated_by%TYPE := 0;
228: l_last_update_login HR_KI_HIERARCHIES.last_update_login%TYPE := 0;
229: l_hierarchy_id HR_KI_HIERARCHIES.hierarchy_id%TYPE;
230: l_parent_hierarchy_id HR_KI_HIERARCHIES.parent_hierarchy_id%TYPE;

Line 227: l_last_updated_by HR_KI_HIERARCHIES.last_updated_by%TYPE := 0;

223: l_rowid rowid;
224: l_created_by HR_KI_HIERARCHIES.created_by%TYPE := 0;
225: l_creation_date HR_KI_HIERARCHIES.creation_date%TYPE := SYSDATE;
226: l_last_update_date HR_KI_HIERARCHIES.last_update_date%TYPE := SYSDATE;
227: l_last_updated_by HR_KI_HIERARCHIES.last_updated_by%TYPE := 0;
228: l_last_update_login HR_KI_HIERARCHIES.last_update_login%TYPE := 0;
229: l_hierarchy_id HR_KI_HIERARCHIES.hierarchy_id%TYPE;
230: l_parent_hierarchy_id HR_KI_HIERARCHIES.parent_hierarchy_id%TYPE;
231: l_object_version_number HR_KI_HIERARCHIES.object_version_number%TYPE;

Line 228: l_last_update_login HR_KI_HIERARCHIES.last_update_login%TYPE := 0;

224: l_created_by HR_KI_HIERARCHIES.created_by%TYPE := 0;
225: l_creation_date HR_KI_HIERARCHIES.creation_date%TYPE := SYSDATE;
226: l_last_update_date HR_KI_HIERARCHIES.last_update_date%TYPE := SYSDATE;
227: l_last_updated_by HR_KI_HIERARCHIES.last_updated_by%TYPE := 0;
228: l_last_update_login HR_KI_HIERARCHIES.last_update_login%TYPE := 0;
229: l_hierarchy_id HR_KI_HIERARCHIES.hierarchy_id%TYPE;
230: l_parent_hierarchy_id HR_KI_HIERARCHIES.parent_hierarchy_id%TYPE;
231: l_object_version_number HR_KI_HIERARCHIES.object_version_number%TYPE;
232:

Line 229: l_hierarchy_id HR_KI_HIERARCHIES.hierarchy_id%TYPE;

225: l_creation_date HR_KI_HIERARCHIES.creation_date%TYPE := SYSDATE;
226: l_last_update_date HR_KI_HIERARCHIES.last_update_date%TYPE := SYSDATE;
227: l_last_updated_by HR_KI_HIERARCHIES.last_updated_by%TYPE := 0;
228: l_last_update_login HR_KI_HIERARCHIES.last_update_login%TYPE := 0;
229: l_hierarchy_id HR_KI_HIERARCHIES.hierarchy_id%TYPE;
230: l_parent_hierarchy_id HR_KI_HIERARCHIES.parent_hierarchy_id%TYPE;
231: l_object_version_number HR_KI_HIERARCHIES.object_version_number%TYPE;
232:
233: db_luby number; -- entity owner in db

Line 230: l_parent_hierarchy_id HR_KI_HIERARCHIES.parent_hierarchy_id%TYPE;

226: l_last_update_date HR_KI_HIERARCHIES.last_update_date%TYPE := SYSDATE;
227: l_last_updated_by HR_KI_HIERARCHIES.last_updated_by%TYPE := 0;
228: l_last_update_login HR_KI_HIERARCHIES.last_update_login%TYPE := 0;
229: l_hierarchy_id HR_KI_HIERARCHIES.hierarchy_id%TYPE;
230: l_parent_hierarchy_id HR_KI_HIERARCHIES.parent_hierarchy_id%TYPE;
231: l_object_version_number HR_KI_HIERARCHIES.object_version_number%TYPE;
232:
233: db_luby number; -- entity owner in db
234: db_ludate date; -- entity update date in db

Line 231: l_object_version_number HR_KI_HIERARCHIES.object_version_number%TYPE;

227: l_last_updated_by HR_KI_HIERARCHIES.last_updated_by%TYPE := 0;
228: l_last_update_login HR_KI_HIERARCHIES.last_update_login%TYPE := 0;
229: l_hierarchy_id HR_KI_HIERARCHIES.hierarchy_id%TYPE;
230: l_parent_hierarchy_id HR_KI_HIERARCHIES.parent_hierarchy_id%TYPE;
231: l_object_version_number HR_KI_HIERARCHIES.object_version_number%TYPE;
232:
233: db_luby number; -- entity owner in db
234: db_ludate date; -- entity update date in db
235:

Line 240: from HR_KI_HIERARCHIES

236:
237:
238: CURSOR C_APPL IS
239: select hierarchy_id,object_version_number
240: from HR_KI_HIERARCHIES
241: where upper(hierarchy_key) = upper(X_HIERARCHY_KEY);
242:
243: begin
244: --

Line 291: from HR_KI_HIERARCHIES

287: close C_APPL;
288: --start of update part
289: select LAST_UPDATED_BY, LAST_UPDATE_DATE
290: into db_luby, db_ludate
291: from HR_KI_HIERARCHIES
292: where hierarchy_id = l_hierarchy_id;
293:
294:
295: if (fnd_load_util.upload_test(l_last_updated_by, l_last_update_date, db_luby,

Line 327: l_hierarchy_id HR_KI_HIERARCHIES.hierarchy_id%TYPE;

323: X_CUSTOM_MODE in varchar2,
324: X_LAST_UPDATE_DATE in varchar2
325: )
326: is
327: l_hierarchy_id HR_KI_HIERARCHIES.hierarchy_id%TYPE;
328:
329: f_luby number; -- entity owner in file
330: f_ludate date; -- entity update date in file
331: db_luby number; -- entity owner in db

Line 341: from HR_KI_HIERARCHIES

337: -- added for 5354277
338: hr_general.g_data_migrator_mode := 'Y';
339: --
340: select hierarchy_id into l_hierarchy_id
341: from HR_KI_HIERARCHIES
342: where upper(hierarchy_key) = upper(X_HIERARCHY_KEY);
343:
344:
345: -- Translate owner to file_last_updated_by

Line 354: from HR_KI_HIERARCHIES_TL

350:
351: begin
352: select LAST_UPDATED_BY, LAST_UPDATE_DATE
353: into db_luby, db_ludate
354: from HR_KI_HIERARCHIES_TL
355: where
356: LANGUAGE = userenv('LANG')
357: and hierarchy_id = l_hierarchy_id;
358:

Line 363: UPDATE HR_KI_HIERARCHIES_TL

359: -- Test for customization and version
360: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
361: db_ludate,X_CUSTOM_MODE)) then
362:
363: UPDATE HR_KI_HIERARCHIES_TL
364: SET
365: NAME = X_NAME,
366: DESCRIPTION = X_DESCRIPTION,
367: LAST_UPDATE_DATE = f_ludate ,