APPS.HR_KI_INT_LOAD_API dependencies on HR_KI_INTEGRATIONS_TL

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 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 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 ,