APPS.HR_KI_OTY_LOAD_API dependencies on HR_KI_OPTION_TYPES_TL

Line 34: update HR_KI_OPTION_TYPES_TL set

30: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER+1
31: where OPTION_TYPE_ID = X_OPTION_TYPE_ID;
32:
33:
34: update HR_KI_OPTION_TYPES_TL set
35: OPTION_NAME = X_OPTION_NAME,
36: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
37: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
38: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 45: insert into HR_KI_OPTION_TYPES_TL (

41: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
42:
43: if (sql%notfound) then
44:
45: insert into HR_KI_OPTION_TYPES_TL (
46: OPTION_TYPE_ID,
47: OPTION_NAME,
48: CREATED_BY,
49: CREATION_DATE,

Line 69: from HR_KI_OPTION_TYPES_TL T

65: from FND_LANGUAGES L
66: where L.INSTALLED_FLAG in ('I', 'B')
67: and not exists
68: (select NULL
69: from HR_KI_OPTION_TYPES_TL T
70: where T.OPTION_TYPE_ID = X_OPTION_TYPE_ID
71: and T.LANGUAGE = L.LANGUAGE_CODE);
72:
73: end if;

Line 121: insert into HR_KI_OPTION_TYPES_TL (

117: 1
118: );
119:
120:
121: insert into HR_KI_OPTION_TYPES_TL (
122: OPTION_TYPE_ID,
123: OPTION_NAME,
124: CREATED_BY,
125: CREATION_DATE,

Line 145: from HR_KI_OPTION_TYPES_TL T

141: from FND_LANGUAGES L
142: where L.INSTALLED_FLAG in ('I', 'B')
143: and not exists
144: (select NULL
145: from HR_KI_OPTION_TYPES_TL T
146: where T.OPTION_TYPE_ID = X_OPTION_TYPE_ID
147: and T.LANGUAGE = L.LANGUAGE_CODE);
148:
149: open c;

Line 294: from HR_KI_OPTION_TYPES_TL

290:
291: begin
292: select LAST_UPDATED_BY, LAST_UPDATE_DATE
293: into db_luby, db_ludate
294: from HR_KI_OPTION_TYPES_TL
295: where
296: LANGUAGE = userenv('LANG')
297: and option_type_id = l_option_type_id;
298:

Line 303: UPDATE HR_KI_OPTION_TYPES_TL

299: -- Test for customization and version
300: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
301: db_ludate,X_CUSTOM_MODE)) then
302:
303: UPDATE HR_KI_OPTION_TYPES_TL
304: SET
305: OPTION_NAME = X_OPTION_NAME,
306: LAST_UPDATE_DATE = f_ludate ,
307: LAST_UPDATED_BY = f_luby,