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_INT_LOAD_API dependencies on HR_KI_INTEGRATIONS

Line 60: update HR_KI_INTEGRATIONS

56:
57: begin
58:
59:
60: update HR_KI_INTEGRATIONS
61: set
62: PARTY_TYPE = X_PARTY_TYPE
63: ,PARTY_NAME = X_PARTY_NAME
64: ,PARTY_SITE_NAME = X_PARTY_SITE_NAME

Line 106: update HR_KI_INTEGRATIONS_TL set

102: where
103: INTEGRATION_ID = X_INTEGRATION_ID;
104:
105: --Update TL table
106: update HR_KI_INTEGRATIONS_TL set
107: PARTNER_NAME = X_PARTNER_NAME,
108: SERVICE_NAME = X_SERVICE_NAME,
109: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
110: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 118: insert into HR_KI_INTEGRATIONS_TL (

114: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
115:
116: if (sql%notfound) then
117:
118: insert into HR_KI_INTEGRATIONS_TL (
119: INTEGRATION_ID,
120: PARTNER_NAME,
121: SERVICE_NAME,
122: CREATED_BY,

Line 144: from HR_KI_INTEGRATIONS_TL T

140: from FND_LANGUAGES L
141: where L.INSTALLED_FLAG in ('I', 'B')
142: and not exists
143: (select NULL
144: from HR_KI_INTEGRATIONS_TL T
145: where T.integration_id = X_integration_id
146: and T.LANGUAGE = L.LANGUAGE_CODE);
147:
148: end if;

Line 204: cursor C is select ROWID from HR_KI_INTEGRATIONS

200:
201:
202: ) is
203:
204: cursor C is select ROWID from HR_KI_INTEGRATIONS
205: where integration_id = X_INTEGRATION_ID;
206:
207: begin
208:

Line 209: select HR_KI_INTEGRATIONS_S.NEXTVAL into X_INTEGRATION_ID from sys.dual;

205: where integration_id = X_INTEGRATION_ID;
206:
207: begin
208:
209: select HR_KI_INTEGRATIONS_S.NEXTVAL into X_INTEGRATION_ID from sys.dual;
210:
211: insert into HR_KI_INTEGRATIONS (
212: INTEGRATION_ID,
213: INTEGRATION_KEY,

Line 211: insert into HR_KI_INTEGRATIONS (

207: begin
208:
209: select HR_KI_INTEGRATIONS_S.NEXTVAL into X_INTEGRATION_ID from sys.dual;
210:
211: insert into HR_KI_INTEGRATIONS (
212: INTEGRATION_ID,
213: INTEGRATION_KEY,
214: PARTY_TYPE,
215: PARTY_NAME,

Line 304: insert into HR_KI_INTEGRATIONS_TL (

300: ,1
301: );
302:
303:
304: insert into HR_KI_INTEGRATIONS_TL (
305: INTEGRATION_ID,
306: PARTNER_NAME,
307: SERVICE_NAME,
308: CREATED_BY,

Line 330: from HR_KI_INTEGRATIONS_TL T

326: from FND_LANGUAGES L
327: where L.INSTALLED_FLAG in ('I', 'B')
328: and not exists
329: (select NULL
330: from HR_KI_INTEGRATIONS_TL T
331: where T.integration_id = X_integration_id
332: and T.LANGUAGE = L.LANGUAGE_CODE);
333:
334: open c;

Line 340: 'HR_KI_INTEGRATIONS.insert_row');

336: if (c%notfound) then
337: close c;
338: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
339: hr_utility.set_message_token('PROCEDURE',
340: 'HR_KI_INTEGRATIONS.insert_row');
341: hr_utility.set_message_token('STEP','1');
342: hr_utility.raise_error;
343: end if;
344: close c;

Line 398: l_created_by HR_KI_INTEGRATIONS.created_by%TYPE := 0;

394: )
395: is
396: l_proc VARCHAR2(31) := 'HR_KI_INT_LOAD_API.LOAD_ROW';
397: l_rowid rowid;
398: l_created_by HR_KI_INTEGRATIONS.created_by%TYPE := 0;
399: l_creation_date HR_KI_INTEGRATIONS.creation_date%TYPE := SYSDATE;
400: l_last_update_date HR_KI_INTEGRATIONS.last_update_date%TYPE := SYSDATE;
401: l_last_updated_by HR_KI_INTEGRATIONS.last_updated_by%TYPE := 0;
402: l_last_update_login HR_KI_INTEGRATIONS.last_update_login%TYPE := 0;

Line 399: l_creation_date HR_KI_INTEGRATIONS.creation_date%TYPE := SYSDATE;

395: is
396: l_proc VARCHAR2(31) := 'HR_KI_INT_LOAD_API.LOAD_ROW';
397: l_rowid rowid;
398: l_created_by HR_KI_INTEGRATIONS.created_by%TYPE := 0;
399: l_creation_date HR_KI_INTEGRATIONS.creation_date%TYPE := SYSDATE;
400: l_last_update_date HR_KI_INTEGRATIONS.last_update_date%TYPE := SYSDATE;
401: l_last_updated_by HR_KI_INTEGRATIONS.last_updated_by%TYPE := 0;
402: l_last_update_login HR_KI_INTEGRATIONS.last_update_login%TYPE := 0;
403: l_integration_id HR_KI_INTEGRATIONS.integration_id%TYPE;

Line 400: l_last_update_date HR_KI_INTEGRATIONS.last_update_date%TYPE := SYSDATE;

396: l_proc VARCHAR2(31) := 'HR_KI_INT_LOAD_API.LOAD_ROW';
397: l_rowid rowid;
398: l_created_by HR_KI_INTEGRATIONS.created_by%TYPE := 0;
399: l_creation_date HR_KI_INTEGRATIONS.creation_date%TYPE := SYSDATE;
400: l_last_update_date HR_KI_INTEGRATIONS.last_update_date%TYPE := SYSDATE;
401: l_last_updated_by HR_KI_INTEGRATIONS.last_updated_by%TYPE := 0;
402: l_last_update_login HR_KI_INTEGRATIONS.last_update_login%TYPE := 0;
403: l_integration_id HR_KI_INTEGRATIONS.integration_id%TYPE;
404: l_object_version_number HR_KI_INTEGRATIONS.object_version_number%TYPE;

Line 401: l_last_updated_by HR_KI_INTEGRATIONS.last_updated_by%TYPE := 0;

397: l_rowid rowid;
398: l_created_by HR_KI_INTEGRATIONS.created_by%TYPE := 0;
399: l_creation_date HR_KI_INTEGRATIONS.creation_date%TYPE := SYSDATE;
400: l_last_update_date HR_KI_INTEGRATIONS.last_update_date%TYPE := SYSDATE;
401: l_last_updated_by HR_KI_INTEGRATIONS.last_updated_by%TYPE := 0;
402: l_last_update_login HR_KI_INTEGRATIONS.last_update_login%TYPE := 0;
403: l_integration_id HR_KI_INTEGRATIONS.integration_id%TYPE;
404: l_object_version_number HR_KI_INTEGRATIONS.object_version_number%TYPE;
405: l_synched HR_KI_INTEGRATIONS.synched%TYPE;

Line 402: l_last_update_login HR_KI_INTEGRATIONS.last_update_login%TYPE := 0;

398: l_created_by HR_KI_INTEGRATIONS.created_by%TYPE := 0;
399: l_creation_date HR_KI_INTEGRATIONS.creation_date%TYPE := SYSDATE;
400: l_last_update_date HR_KI_INTEGRATIONS.last_update_date%TYPE := SYSDATE;
401: l_last_updated_by HR_KI_INTEGRATIONS.last_updated_by%TYPE := 0;
402: l_last_update_login HR_KI_INTEGRATIONS.last_update_login%TYPE := 0;
403: l_integration_id HR_KI_INTEGRATIONS.integration_id%TYPE;
404: l_object_version_number HR_KI_INTEGRATIONS.object_version_number%TYPE;
405: l_synched HR_KI_INTEGRATIONS.synched%TYPE;
406:

Line 403: l_integration_id HR_KI_INTEGRATIONS.integration_id%TYPE;

399: l_creation_date HR_KI_INTEGRATIONS.creation_date%TYPE := SYSDATE;
400: l_last_update_date HR_KI_INTEGRATIONS.last_update_date%TYPE := SYSDATE;
401: l_last_updated_by HR_KI_INTEGRATIONS.last_updated_by%TYPE := 0;
402: l_last_update_login HR_KI_INTEGRATIONS.last_update_login%TYPE := 0;
403: l_integration_id HR_KI_INTEGRATIONS.integration_id%TYPE;
404: l_object_version_number HR_KI_INTEGRATIONS.object_version_number%TYPE;
405: l_synched HR_KI_INTEGRATIONS.synched%TYPE;
406:
407: db_luby number; -- entity owner in db

Line 404: l_object_version_number HR_KI_INTEGRATIONS.object_version_number%TYPE;

400: l_last_update_date HR_KI_INTEGRATIONS.last_update_date%TYPE := SYSDATE;
401: l_last_updated_by HR_KI_INTEGRATIONS.last_updated_by%TYPE := 0;
402: l_last_update_login HR_KI_INTEGRATIONS.last_update_login%TYPE := 0;
403: l_integration_id HR_KI_INTEGRATIONS.integration_id%TYPE;
404: l_object_version_number HR_KI_INTEGRATIONS.object_version_number%TYPE;
405: l_synched HR_KI_INTEGRATIONS.synched%TYPE;
406:
407: db_luby number; -- entity owner in db
408: db_ludate date; -- entity update date in db

Line 405: l_synched HR_KI_INTEGRATIONS.synched%TYPE;

401: l_last_updated_by HR_KI_INTEGRATIONS.last_updated_by%TYPE := 0;
402: l_last_update_login HR_KI_INTEGRATIONS.last_update_login%TYPE := 0;
403: l_integration_id HR_KI_INTEGRATIONS.integration_id%TYPE;
404: l_object_version_number HR_KI_INTEGRATIONS.object_version_number%TYPE;
405: l_synched HR_KI_INTEGRATIONS.synched%TYPE;
406:
407: db_luby number; -- entity owner in db
408: db_ludate date; -- entity update date in db
409:

Line 414: from HR_KI_INTEGRATIONS

410:
411:
412: CURSOR C_APPL IS
413: select integration_id,object_version_number
414: from HR_KI_INTEGRATIONS
415: where upper(integration_key) = upper(X_INTEGRATION_KEY);
416:
417: begin
418: --

Line 504: from HR_KI_INTEGRATIONS

500: close C_APPL;
501: --start of update part
502: select LAST_UPDATED_BY, LAST_UPDATE_DATE
503: into db_luby, db_ludate
504: from HR_KI_INTEGRATIONS
505: where integration_id = l_integration_id;
506:
507:
508: if (fnd_load_util.upload_test(l_last_updated_by, l_last_update_date, db_luby,

Line 575: l_integration_id HR_KI_INTEGRATIONS.integration_id%TYPE;

571: X_CUSTOM_MODE in varchar2,
572: X_LAST_UPDATE_DATE in varchar2
573: )
574: is
575: l_integration_id HR_KI_INTEGRATIONS.integration_id%TYPE;
576:
577: f_luby number; -- entity owner in file
578: f_ludate date; -- entity update date in file
579: db_luby number; -- entity owner in db

Line 590: from HR_KI_INTEGRATIONS

586: hr_general.g_data_migrator_mode := 'Y';
587: --
588:
589: select integration_id into l_integration_id
590: from HR_KI_INTEGRATIONS
591: where upper(integration_key) = upper(X_INTEGRATION_KEY);
592:
593:
594: -- Translate owner to file_last_updated_by

Line 603: from HR_KI_INTEGRATIONS_TL

599:
600: begin
601: select LAST_UPDATED_BY, LAST_UPDATE_DATE
602: into db_luby, db_ludate
603: from HR_KI_INTEGRATIONS_TL
604: where
605: LANGUAGE = userenv('LANG')
606: and integration_id = l_integration_id;
607:

Line 612: UPDATE HR_KI_INTEGRATIONS_TL

608: -- Test for customization and version
609: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
610: db_ludate,X_CUSTOM_MODE)) then
611:
612: UPDATE HR_KI_INTEGRATIONS_TL
613: SET
614: PARTNER_NAME = X_PARTNER_NAME,
615: SERVICE_NAME = X_SERVICE_NAME,
616: LAST_UPDATE_DATE = f_ludate ,