APPS.HR_KI_HRC_LOAD_API dependencies on HR_KI_HIERARCHIES_TL

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 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 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 ,