APPS.HR_KI_TPC_LOAD_API dependencies on HR_KI_TOPICS_TL

Line 30: update HR_KI_TOPICS_TL set

26: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
27: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER+1
28: where TOPIC_ID = X_TOPIC_ID;
29:
30: update HR_KI_TOPICS_TL set
31: NAME = X_NAME,
32: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
33: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
34: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 41: insert into HR_KI_TOPICS_TL (

37: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
38:
39: if (sql%notfound) then
40:
41: insert into HR_KI_TOPICS_TL (
42: TOPIC_ID,
43: NAME,
44: CREATED_BY,
45: CREATION_DATE,

Line 65: from HR_KI_TOPICS_TL T

61: from FND_LANGUAGES L
62: where L.INSTALLED_FLAG in ('I', 'B')
63: and not exists
64: (select NULL
65: from HR_KI_TOPICS_TL T
66: where T.TOPIC_ID = X_TOPIC_ID
67: and T.LANGUAGE = L.LANGUAGE_CODE);
68:
69: end if;

Line 116: insert into HR_KI_TOPICS_TL (

112: 1
113: );
114:
115:
116: insert into HR_KI_TOPICS_TL (
117: TOPIC_ID,
118: NAME,
119: CREATED_BY,
120: CREATION_DATE,

Line 140: from HR_KI_TOPICS_TL T

136: from FND_LANGUAGES L
137: where L.INSTALLED_FLAG in ('I', 'B')
138: and not exists
139: (select NULL
140: from HR_KI_TOPICS_TL T
141: where T.TOPIC_ID = X_TOPIC_ID
142: and T.LANGUAGE = L.LANGUAGE_CODE);
143:
144: open c;

Line 288: from HR_KI_TOPICS_TL

284:
285: begin
286: select LAST_UPDATED_BY, LAST_UPDATE_DATE
287: into db_luby, db_ludate
288: from HR_KI_TOPICS_TL
289: where
290: LANGUAGE = userenv('LANG')
291: and topic_id = l_topic_id;
292:

Line 297: UPDATE HR_KI_TOPICS_TL

293: -- Test for customization and version
294: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
295: db_ludate,X_CUSTOM_MODE)) then
296:
297: UPDATE HR_KI_TOPICS_TL
298: SET
299: NAME = X_NAME,
300: LAST_UPDATE_DATE = f_ludate ,
301: LAST_UPDATED_BY = f_luby,