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_TIS_LOAD_API dependencies on HR_KI_TOPIC_INTEGRATIONS

Line 8: -- The below procedure inserts the row into HR_KI_TOPIC_INTEGRATIONS

4: -- Package Variables
5: --
6: g_package varchar2(31) := 'HR_KI_TIS_LOAD_API';
7: --
8: -- The below procedure inserts the row into HR_KI_TOPIC_INTEGRATIONS
9: --
10: procedure INSERT_ROW (
11: X_ROWID in out nocopy VARCHAR2,
12: X_TOPIC_INTEGRATIONS_ID in out nocopy NUMBER,

Line 46: FROM HR_KI_TOPIC_INTEGRATIONS

42: L_RETURN_VALUE number;
43: --
44: cursor C is
45: SELECT ROWID
46: FROM HR_KI_TOPIC_INTEGRATIONS
47: WHERE topic_integrations_id = x_topic_integrations_id;
48: --
49: begin
50: --

Line 52: (LOCKNAME =>'HR_KI_TOPIC_INTEGRATIONS.'||X_TOPIC_INTEGRATIONS_ID

48: --
49: begin
50: --
51: DBMS_LOCK.ALLOCATE_UNIQUE
52: (LOCKNAME =>'HR_KI_TOPIC_INTEGRATIONS.'||X_TOPIC_INTEGRATIONS_ID
53: ,LOCKHANDLE => L_LOCK_HANDLE
54: );
55: L_RETURN_VALUE := DBMS_LOCK.REQUEST
56: (LOCKHANDLE => L_LOCK_HANDLE

Line 61: select HR_KI_TOPIC_INTEGRATIONS_S.NEXTVAL into x_topic_integrations_id

57: ,TIMEOUT => 0
58: ,RELEASE_ON_COMMIT => true);
59:
60: if L_RETURN_VALUE = 0 then
61: select HR_KI_TOPIC_INTEGRATIONS_S.NEXTVAL into x_topic_integrations_id
62: from sys.dual;
63: --
64: insert into HR_KI_TOPIC_INTEGRATIONS (
65: TOPIC_INTEGRATIONS_ID,

Line 64: insert into HR_KI_TOPIC_INTEGRATIONS (

60: if L_RETURN_VALUE = 0 then
61: select HR_KI_TOPIC_INTEGRATIONS_S.NEXTVAL into x_topic_integrations_id
62: from sys.dual;
63: --
64: insert into HR_KI_TOPIC_INTEGRATIONS (
65: TOPIC_INTEGRATIONS_ID,
66: TOPIC_ID,
67: INTEGRATION_ID,
68: PARAM_NAME1,

Line 133: 'HR_KI_TOPIC_INTEGRATIONS.insert_row');

129: if (c%notfound) then
130: close c;
131: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
132: hr_utility.set_message_token('PROCEDURE',
133: 'HR_KI_TOPIC_INTEGRATIONS.insert_row');
134: hr_utility.set_message_token('STEP','1');
135: hr_utility.raise_error;
136: end if;
137: close c;

Line 141: -- The below procure updates the existing row in HR_KI_TOPIC_INTEGRATIONS

137: close c;
138: --
139: end INSERT_ROW;
140: --
141: -- The below procure updates the existing row in HR_KI_TOPIC_INTEGRATIONS
142: --
143: procedure UPDATE_ROW
144: (X_TOPIC_INTEGRATIONS_ID in NUMBER,
145: X_TOPIC_ID in NUMBER,

Line 179: (LOCKNAME =>'HR_KI_TOPIC_INTEGRATIONS.'||X_TOPIC_INTEGRATIONS_ID

175: L_RETURN_VALUE number;
176: --
177: begin
178: DBMS_LOCK.ALLOCATE_UNIQUE
179: (LOCKNAME =>'HR_KI_TOPIC_INTEGRATIONS.'||X_TOPIC_INTEGRATIONS_ID
180: ,LOCKHANDLE => L_LOCK_HANDLE
181: );
182: L_RETURN_VALUE := DBMS_LOCK.REQUEST
183: (LOCKHANDLE => L_LOCK_HANDLE

Line 188: UPDATE HR_KI_TOPIC_INTEGRATIONS TIS

184: ,TIMEOUT => 0
185: ,RELEASE_ON_COMMIT => true);
186: --
187: if L_RETURN_VALUE = 0 then
188: UPDATE HR_KI_TOPIC_INTEGRATIONS TIS
189: SET tis.topic_id = X_TOPIC_ID
190: ,tis.integration_id = X_INTEGRATION_ID
191: ,tis.PARAM_NAME1 = X_PARAM_NAME1
192: ,tis.PARAM_VALUE1 = X_PARAM_VALUE1

Line 298: l_created_by HR_KI_TOPIC_INTEGRATIONS.created_by%TYPE := 0;

294: )
295: is
296: l_proc VARCHAR2(31) := 'HR_KI_TIS_LOAD_API.LOAD_ROW';
297: l_rowid rowid;
298: l_created_by HR_KI_TOPIC_INTEGRATIONS.created_by%TYPE := 0;
299: l_creation_date HR_KI_TOPIC_INTEGRATIONS.creation_date%TYPE := SYSDATE;
300: l_last_update_date HR_KI_TOPIC_INTEGRATIONS.last_update_date%TYPE := SYSDATE;
301: l_last_updated_by HR_KI_TOPIC_INTEGRATIONS.last_updated_by%TYPE := 0;
302: l_last_update_login HR_KI_TOPIC_INTEGRATIONS.last_update_login%TYPE := 0;

Line 299: l_creation_date HR_KI_TOPIC_INTEGRATIONS.creation_date%TYPE := SYSDATE;

295: is
296: l_proc VARCHAR2(31) := 'HR_KI_TIS_LOAD_API.LOAD_ROW';
297: l_rowid rowid;
298: l_created_by HR_KI_TOPIC_INTEGRATIONS.created_by%TYPE := 0;
299: l_creation_date HR_KI_TOPIC_INTEGRATIONS.creation_date%TYPE := SYSDATE;
300: l_last_update_date HR_KI_TOPIC_INTEGRATIONS.last_update_date%TYPE := SYSDATE;
301: l_last_updated_by HR_KI_TOPIC_INTEGRATIONS.last_updated_by%TYPE := 0;
302: l_last_update_login HR_KI_TOPIC_INTEGRATIONS.last_update_login%TYPE := 0;
303: l_topic_integrations_id HR_KI_TOPIC_INTEGRATIONS.topic_integrations_id%TYPE;

Line 300: l_last_update_date HR_KI_TOPIC_INTEGRATIONS.last_update_date%TYPE := SYSDATE;

296: l_proc VARCHAR2(31) := 'HR_KI_TIS_LOAD_API.LOAD_ROW';
297: l_rowid rowid;
298: l_created_by HR_KI_TOPIC_INTEGRATIONS.created_by%TYPE := 0;
299: l_creation_date HR_KI_TOPIC_INTEGRATIONS.creation_date%TYPE := SYSDATE;
300: l_last_update_date HR_KI_TOPIC_INTEGRATIONS.last_update_date%TYPE := SYSDATE;
301: l_last_updated_by HR_KI_TOPIC_INTEGRATIONS.last_updated_by%TYPE := 0;
302: l_last_update_login HR_KI_TOPIC_INTEGRATIONS.last_update_login%TYPE := 0;
303: l_topic_integrations_id HR_KI_TOPIC_INTEGRATIONS.topic_integrations_id%TYPE;
304: l_object_version_number HR_KI_TOPIC_INTEGRATIONS.object_version_number%TYPE;

Line 301: l_last_updated_by HR_KI_TOPIC_INTEGRATIONS.last_updated_by%TYPE := 0;

297: l_rowid rowid;
298: l_created_by HR_KI_TOPIC_INTEGRATIONS.created_by%TYPE := 0;
299: l_creation_date HR_KI_TOPIC_INTEGRATIONS.creation_date%TYPE := SYSDATE;
300: l_last_update_date HR_KI_TOPIC_INTEGRATIONS.last_update_date%TYPE := SYSDATE;
301: l_last_updated_by HR_KI_TOPIC_INTEGRATIONS.last_updated_by%TYPE := 0;
302: l_last_update_login HR_KI_TOPIC_INTEGRATIONS.last_update_login%TYPE := 0;
303: l_topic_integrations_id HR_KI_TOPIC_INTEGRATIONS.topic_integrations_id%TYPE;
304: l_object_version_number HR_KI_TOPIC_INTEGRATIONS.object_version_number%TYPE;
305: l_topic_id HR_KI_TOPICS.topic_id%TYPE;

Line 302: l_last_update_login HR_KI_TOPIC_INTEGRATIONS.last_update_login%TYPE := 0;

298: l_created_by HR_KI_TOPIC_INTEGRATIONS.created_by%TYPE := 0;
299: l_creation_date HR_KI_TOPIC_INTEGRATIONS.creation_date%TYPE := SYSDATE;
300: l_last_update_date HR_KI_TOPIC_INTEGRATIONS.last_update_date%TYPE := SYSDATE;
301: l_last_updated_by HR_KI_TOPIC_INTEGRATIONS.last_updated_by%TYPE := 0;
302: l_last_update_login HR_KI_TOPIC_INTEGRATIONS.last_update_login%TYPE := 0;
303: l_topic_integrations_id HR_KI_TOPIC_INTEGRATIONS.topic_integrations_id%TYPE;
304: l_object_version_number HR_KI_TOPIC_INTEGRATIONS.object_version_number%TYPE;
305: l_topic_id HR_KI_TOPICS.topic_id%TYPE;
306: l_integration_id HR_KI_INTEGRATIONS.integration_id%TYPE;

Line 303: l_topic_integrations_id HR_KI_TOPIC_INTEGRATIONS.topic_integrations_id%TYPE;

299: l_creation_date HR_KI_TOPIC_INTEGRATIONS.creation_date%TYPE := SYSDATE;
300: l_last_update_date HR_KI_TOPIC_INTEGRATIONS.last_update_date%TYPE := SYSDATE;
301: l_last_updated_by HR_KI_TOPIC_INTEGRATIONS.last_updated_by%TYPE := 0;
302: l_last_update_login HR_KI_TOPIC_INTEGRATIONS.last_update_login%TYPE := 0;
303: l_topic_integrations_id HR_KI_TOPIC_INTEGRATIONS.topic_integrations_id%TYPE;
304: l_object_version_number HR_KI_TOPIC_INTEGRATIONS.object_version_number%TYPE;
305: l_topic_id HR_KI_TOPICS.topic_id%TYPE;
306: l_integration_id HR_KI_INTEGRATIONS.integration_id%TYPE;
307: db_luby number; -- entity owner in db

Line 304: l_object_version_number HR_KI_TOPIC_INTEGRATIONS.object_version_number%TYPE;

300: l_last_update_date HR_KI_TOPIC_INTEGRATIONS.last_update_date%TYPE := SYSDATE;
301: l_last_updated_by HR_KI_TOPIC_INTEGRATIONS.last_updated_by%TYPE := 0;
302: l_last_update_login HR_KI_TOPIC_INTEGRATIONS.last_update_login%TYPE := 0;
303: l_topic_integrations_id HR_KI_TOPIC_INTEGRATIONS.topic_integrations_id%TYPE;
304: l_object_version_number HR_KI_TOPIC_INTEGRATIONS.object_version_number%TYPE;
305: l_topic_id HR_KI_TOPICS.topic_id%TYPE;
306: l_integration_id HR_KI_INTEGRATIONS.integration_id%TYPE;
307: db_luby number; -- entity owner in db
308: db_ludate date; -- entity update date in db

Line 313: from hr_ki_topic_integrations tpi,

309: --
310: CURSOR C_APPL IS
311: select tpi.topic_integrations_id,
312: nvl(tpi.object_version_number,1)
313: from hr_ki_topic_integrations tpi,
314: hr_ki_topics top,
315: hr_ki_integrations int
316: where tpi.topic_id = top.topic_id
317: and tpi.integration_id = int.integration_id

Line 322: X_CURRENT_LAST_UPDATE_DATE HR_KI_TOPIC_INTEGRATIONS.last_update_date%TYPE;

318: and top.topic_key = X_TOPIC_KEY
319: and int.integration_key = X_INTEGRATION_KEY;
320: --
321: X_CURRENT_OWNER NUMBER;
322: X_CURRENT_LAST_UPDATE_DATE HR_KI_TOPIC_INTEGRATIONS.last_update_date%TYPE;
323: --
324: begin
325: --
326: -- added for 5354277

Line 388: FROM HR_KI_TOPIC_INTEGRATIONS tis

384: SELECT tis.LAST_UPDATED_BY,
385: tis.LAST_UPDATE_DATE
386: INTO X_CURRENT_OWNER,
387: X_CURRENT_LAST_UPDATE_DATE
388: FROM HR_KI_TOPIC_INTEGRATIONS tis
389: WHERE tis.topic_id = l_topic_id
390: AND tis.integration_id = l_integration_id;
391: --
392: if (FND_LOAD_UTIL.UPLOAD_TEST