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_TPC_LOAD_API dependencies on HR_KI_TOPICS

Line 6: g_package varchar2(33) := 'HR_KI_TOPICS_API';

2: /* $Header: hrkitpcl.pkb 120.1 2006/06/27 16:08:26 avarri noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := 'HR_KI_TOPICS_API';
7: --
8: procedure UPDATE_ROW (
9: X_TOPIC_ID in NUMBER,
10: X_NAME in VARCHAR2,

Line 22: update HR_KI_TOPICS set

18:
19: begin
20:
21:
22: update HR_KI_TOPICS set
23: HANDLER = X_HANDLER,
24: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
25: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
26: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

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 86: cursor C is select ROWID from HR_KI_TOPICS

82: X_LAST_UPDATE_DATE in DATE,
83: X_LAST_UPDATED_BY in NUMBER,
84: X_LAST_UPDATE_LOGIN in NUMBER
85: ) is
86: cursor C is select ROWID from HR_KI_TOPICS
87: where topic_id = X_TOPIC_ID;
88:
89: begin
90:

Line 91: select HR_KI_TOPICS_S.NEXTVAL into X_TOPIC_ID from SYS.DUAL;

87: where topic_id = X_TOPIC_ID;
88:
89: begin
90:
91: select HR_KI_TOPICS_S.NEXTVAL into X_TOPIC_ID from SYS.DUAL;
92:
93: insert into HR_KI_TOPICS (
94: TOPIC_ID,
95: TOPIC_KEY,

Line 93: insert into HR_KI_TOPICS (

89: begin
90:
91: select HR_KI_TOPICS_S.NEXTVAL into X_TOPIC_ID from SYS.DUAL;
92:
93: insert into HR_KI_TOPICS (
94: TOPIC_ID,
95: TOPIC_KEY,
96: HANDLER,
97: CREATION_DATE,

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 150: 'hr_ki_topics.insert_row');

146: if (c%notfound) then
147: close c;
148: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
149: hr_utility.set_message_token('PROCEDURE',
150: 'hr_ki_topics.insert_row');
151: hr_utility.set_message_token('STEP','1');
152: hr_utility.raise_error;
153: end if;
154: close c;

Line 172: l_created_by HR_KI_TOPICS.created_by%TYPE := 0;

168: )
169: is
170: l_proc VARCHAR2(61) := 'HR_KI_TPC_LOAD_API.LOAD_ROW';
171: l_rowid rowid;
172: l_created_by HR_KI_TOPICS.created_by%TYPE := 0;
173: l_creation_date HR_KI_TOPICS.creation_date%TYPE := SYSDATE;
174: l_last_update_date HR_KI_TOPICS.last_update_date%TYPE := SYSDATE;
175: l_last_updated_by HR_KI_TOPICS.last_updated_by%TYPE := 0;
176: l_last_update_login HR_KI_TOPICS.last_update_login%TYPE := 0;

Line 173: l_creation_date HR_KI_TOPICS.creation_date%TYPE := SYSDATE;

169: is
170: l_proc VARCHAR2(61) := 'HR_KI_TPC_LOAD_API.LOAD_ROW';
171: l_rowid rowid;
172: l_created_by HR_KI_TOPICS.created_by%TYPE := 0;
173: l_creation_date HR_KI_TOPICS.creation_date%TYPE := SYSDATE;
174: l_last_update_date HR_KI_TOPICS.last_update_date%TYPE := SYSDATE;
175: l_last_updated_by HR_KI_TOPICS.last_updated_by%TYPE := 0;
176: l_last_update_login HR_KI_TOPICS.last_update_login%TYPE := 0;
177: l_topic_id HR_KI_TOPICS.topic_id%TYPE;

Line 174: l_last_update_date HR_KI_TOPICS.last_update_date%TYPE := SYSDATE;

170: l_proc VARCHAR2(61) := 'HR_KI_TPC_LOAD_API.LOAD_ROW';
171: l_rowid rowid;
172: l_created_by HR_KI_TOPICS.created_by%TYPE := 0;
173: l_creation_date HR_KI_TOPICS.creation_date%TYPE := SYSDATE;
174: l_last_update_date HR_KI_TOPICS.last_update_date%TYPE := SYSDATE;
175: l_last_updated_by HR_KI_TOPICS.last_updated_by%TYPE := 0;
176: l_last_update_login HR_KI_TOPICS.last_update_login%TYPE := 0;
177: l_topic_id HR_KI_TOPICS.topic_id%TYPE;
178: l_object_version_number HR_KI_TOPICS.object_version_number%TYPE;

Line 175: l_last_updated_by HR_KI_TOPICS.last_updated_by%TYPE := 0;

171: l_rowid rowid;
172: l_created_by HR_KI_TOPICS.created_by%TYPE := 0;
173: l_creation_date HR_KI_TOPICS.creation_date%TYPE := SYSDATE;
174: l_last_update_date HR_KI_TOPICS.last_update_date%TYPE := SYSDATE;
175: l_last_updated_by HR_KI_TOPICS.last_updated_by%TYPE := 0;
176: l_last_update_login HR_KI_TOPICS.last_update_login%TYPE := 0;
177: l_topic_id HR_KI_TOPICS.topic_id%TYPE;
178: l_object_version_number HR_KI_TOPICS.object_version_number%TYPE;
179:

Line 176: l_last_update_login HR_KI_TOPICS.last_update_login%TYPE := 0;

172: l_created_by HR_KI_TOPICS.created_by%TYPE := 0;
173: l_creation_date HR_KI_TOPICS.creation_date%TYPE := SYSDATE;
174: l_last_update_date HR_KI_TOPICS.last_update_date%TYPE := SYSDATE;
175: l_last_updated_by HR_KI_TOPICS.last_updated_by%TYPE := 0;
176: l_last_update_login HR_KI_TOPICS.last_update_login%TYPE := 0;
177: l_topic_id HR_KI_TOPICS.topic_id%TYPE;
178: l_object_version_number HR_KI_TOPICS.object_version_number%TYPE;
179:
180: db_luby number; -- entity owner in db

Line 177: l_topic_id HR_KI_TOPICS.topic_id%TYPE;

173: l_creation_date HR_KI_TOPICS.creation_date%TYPE := SYSDATE;
174: l_last_update_date HR_KI_TOPICS.last_update_date%TYPE := SYSDATE;
175: l_last_updated_by HR_KI_TOPICS.last_updated_by%TYPE := 0;
176: l_last_update_login HR_KI_TOPICS.last_update_login%TYPE := 0;
177: l_topic_id HR_KI_TOPICS.topic_id%TYPE;
178: l_object_version_number HR_KI_TOPICS.object_version_number%TYPE;
179:
180: db_luby number; -- entity owner in db
181: db_ludate date; -- entity update date in db

Line 178: l_object_version_number HR_KI_TOPICS.object_version_number%TYPE;

174: l_last_update_date HR_KI_TOPICS.last_update_date%TYPE := SYSDATE;
175: l_last_updated_by HR_KI_TOPICS.last_updated_by%TYPE := 0;
176: l_last_update_login HR_KI_TOPICS.last_update_login%TYPE := 0;
177: l_topic_id HR_KI_TOPICS.topic_id%TYPE;
178: l_object_version_number HR_KI_TOPICS.object_version_number%TYPE;
179:
180: db_luby number; -- entity owner in db
181: db_ludate date; -- entity update date in db
182:

Line 186: from HR_KI_TOPICS

182:
183:
184: CURSOR C_APPL IS
185: select topic_id,object_version_number
186: from HR_KI_TOPICS
187: where upper(topic_key) = upper(X_TOPIC_KEY);
188:
189: begin
190: --

Line 227: from HR_KI_TOPICS

223: -- start update part
224: close C_APPL;
225: select LAST_UPDATED_BY, LAST_UPDATE_DATE
226: into db_luby, db_ludate
227: from HR_KI_TOPICS
228: where topic_id = l_topic_id;
229:
230:
231: if (fnd_load_util.upload_test(l_last_updated_by, l_last_update_date, db_luby,

Line 259: l_topic_id HR_KI_TOPICS.topic_id%TYPE;

255: X_CUSTOM_MODE in varchar2,
256: X_LAST_UPDATE_DATE in varchar2
257: )
258: is
259: l_topic_id HR_KI_TOPICS.topic_id%TYPE;
260:
261: f_luby number; -- entity owner in file
262: f_ludate date; -- entity update date in file
263: db_luby number; -- entity owner in db

Line 275: from HR_KI_TOPICS

271: --
272:
273:
274: select topic_id into l_topic_id
275: from HR_KI_TOPICS
276: where upper(topic_key) = upper(X_TOPIC_KEY);
277:
278:
279: -- Translate owner to file_last_updated_by

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,