APPS.HR_ITL_SHD dependencies on HR_KI_INTEGRATIONS

Line 21: If (p_constraint_name = 'HR_KI_INTEGRATIONS_TL_PK') Then

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'HR_KI_INTEGRATIONS_TL_PK') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;

Line 53: from hr_ki_integrations_tl

49: ,partner_name
50: ,service_name
51: ,language
52: ,source_lang
53: from hr_ki_integrations_tl
54: where
55: integration_id = p_integration_id
56: and language = p_language;
57: --

Line 121: from hr_ki_integrations_tl

117: ,partner_name
118: ,service_name
119: ,language
120: ,source_lang
121: from hr_ki_integrations_tl
122: where
123: integration_id = p_integration_id
124: and language = p_language
125: for update nowait;

Line 168: fnd_message.set_token('TABLE_NAME', 'hr_ki_integrations_tl');

164: -- The object is locked therefore we need to supply a meaningful
165: -- error message.
166: --
167: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
168: fnd_message.set_token('TABLE_NAME', 'hr_ki_integrations_tl');
169: fnd_message.raise_error;
170: End lck;
171: --
172: -- ----------------------------------------------------------------------------

Line 185: delete from HR_KI_INTEGRATIONS_TL T

181: -- ----------------------------------------------------------------------------
182: PROCEDURE add_language IS
183: Begin
184:
185: delete from HR_KI_INTEGRATIONS_TL T
186: where not exists
187: (select NULL
188: from HR_KI_INTEGRATIONS B
189: where B.INTEGRATION_ID = T.INTEGRATION_ID

Line 188: from HR_KI_INTEGRATIONS B

184:
185: delete from HR_KI_INTEGRATIONS_TL T
186: where not exists
187: (select NULL
188: from HR_KI_INTEGRATIONS B
189: where B.INTEGRATION_ID = T.INTEGRATION_ID
190: );
191:
192: update HR_KI_INTEGRATIONS_TL T set (

Line 192: update HR_KI_INTEGRATIONS_TL T set (

188: from HR_KI_INTEGRATIONS B
189: where B.INTEGRATION_ID = T.INTEGRATION_ID
190: );
191:
192: update HR_KI_INTEGRATIONS_TL T set (
193: PARTNER_NAME,
194: SERVICE_NAME
195: ) = (select
196: B.PARTNER_NAME,

Line 198: from HR_KI_INTEGRATIONS_TL B

194: SERVICE_NAME
195: ) = (select
196: B.PARTNER_NAME,
197: B.SERVICE_NAME
198: from HR_KI_INTEGRATIONS_TL B
199: where B.INTEGRATION_ID = T.INTEGRATION_ID
200: and B.LANGUAGE = T.SOURCE_LANG)
201: where (
202: T.INTEGRATION_ID,

Line 207: from HR_KI_INTEGRATIONS_TL SUBB, HR_KI_INTEGRATIONS_TL SUBT

203: T.LANGUAGE
204: ) in (select
205: SUBT.INTEGRATION_ID,
206: SUBT.LANGUAGE
207: from HR_KI_INTEGRATIONS_TL SUBB, HR_KI_INTEGRATIONS_TL SUBT
208: where SUBB.INTEGRATION_ID = SUBT.INTEGRATION_ID
209: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
210: and (SUBB.PARTNER_NAME <> SUBT.PARTNER_NAME
211: or SUBB.SERVICE_NAME <> SUBT.SERVICE_NAME

Line 214: insert into HR_KI_INTEGRATIONS_TL (

210: and (SUBB.PARTNER_NAME <> SUBT.PARTNER_NAME
211: or SUBB.SERVICE_NAME <> SUBT.SERVICE_NAME
212: ));
213:
214: insert into HR_KI_INTEGRATIONS_TL (
215: INTEGRATION_ID,
216: PARTNER_NAME,
217: SERVICE_NAME,
218: LAST_UPDATE_DATE,

Line 236: from HR_KI_INTEGRATIONS_TL B, FND_LANGUAGES L

232: B.CREATED_BY,
233: B.CREATION_DATE,
234: L.LANGUAGE_CODE,
235: B.SOURCE_LANG
236: from HR_KI_INTEGRATIONS_TL B, FND_LANGUAGES L
237: where L.INSTALLED_FLAG in ('I', 'B')
238: and B.LANGUAGE = userenv('LANG')
239: and not exists
240: (select NULL

Line 241: from HR_KI_INTEGRATIONS_TL T

237: where L.INSTALLED_FLAG in ('I', 'B')
238: and B.LANGUAGE = userenv('LANG')
239: and not exists
240: (select NULL
241: from HR_KI_INTEGRATIONS_TL T
242: where T.INTEGRATION_ID = B.INTEGRATION_ID
243: and T.LANGUAGE = L.LANGUAGE_CODE);
244: End;
245: --