DBA Data[Home] [Help]

APPS.HR_TIS_BUS dependencies on HR_KI_TOPIC_INTEGRATIONS

Line 133: (p_associated_column1 => 'HR_KI_TOPIC_INTEGRATIONS.INTEGRATION_ID'

129: hr_utility.set_location(' Leaving:'||l_proc,40);
130: exception
131: when app_exception.application_exception then
132: if hr_multi_message.exception_add
133: (p_associated_column1 => 'HR_KI_TOPIC_INTEGRATIONS.INTEGRATION_ID'
134: )then
135: hr_utility.set_location(' Leaving:'||l_proc, 50);
136: raise;
137: end if;

Line 204: (p_associated_column1 => 'HR_KI_TOPIC_INTEGRATIONS.TOPIC_ID'

200: hr_utility.set_location(' Leaving:'||l_proc,40);
201: exception
202: when app_exception.application_exception then
203: if hr_multi_message.exception_add
204: (p_associated_column1 => 'HR_KI_TOPIC_INTEGRATIONS.TOPIC_ID'
205: )then
206: hr_utility.set_location(' Leaving:'||l_proc, 50);
207: raise;
208: end if;

Line 248: from hr_ki_topic_integrations

244: l_found varchar2(1);
245:
246: cursor csr_int_options is
247: select null
248: from hr_ki_topic_integrations
249: where topic_id = p_topic_id
250: and integration_id = p_integration_id;
251: --
252: Begin

Line 260: (p_check_column1 => 'HR_KI_TOPIC_INTEGRATIONS.TOPIC_ID'

256: -- Multiple Message List does not already contain an errors
257: -- associated with the topic_id/integration_id columns.
258: --
259: if hr_multi_message.no_exclusive_error
260: (p_check_column1 => 'HR_KI_TOPIC_INTEGRATIONS.TOPIC_ID'
261: ,p_associated_column1 => 'HR_KI_TOPIC_INTEGRATIONS.TOPIC_ID'
262: ,p_check_column2 => 'HR_KI_TOPIC_INTEGRATIONS.INTEGRATION_ID'
263: ,p_associated_column2 => 'HR_KI_TOPIC_INTEGRATIONS.INTEGRATION_ID'
264: ) then

Line 261: ,p_associated_column1 => 'HR_KI_TOPIC_INTEGRATIONS.TOPIC_ID'

257: -- associated with the topic_id/integration_id columns.
258: --
259: if hr_multi_message.no_exclusive_error
260: (p_check_column1 => 'HR_KI_TOPIC_INTEGRATIONS.TOPIC_ID'
261: ,p_associated_column1 => 'HR_KI_TOPIC_INTEGRATIONS.TOPIC_ID'
262: ,p_check_column2 => 'HR_KI_TOPIC_INTEGRATIONS.INTEGRATION_ID'
263: ,p_associated_column2 => 'HR_KI_TOPIC_INTEGRATIONS.INTEGRATION_ID'
264: ) then
265:

Line 262: ,p_check_column2 => 'HR_KI_TOPIC_INTEGRATIONS.INTEGRATION_ID'

258: --
259: if hr_multi_message.no_exclusive_error
260: (p_check_column1 => 'HR_KI_TOPIC_INTEGRATIONS.TOPIC_ID'
261: ,p_associated_column1 => 'HR_KI_TOPIC_INTEGRATIONS.TOPIC_ID'
262: ,p_check_column2 => 'HR_KI_TOPIC_INTEGRATIONS.INTEGRATION_ID'
263: ,p_associated_column2 => 'HR_KI_TOPIC_INTEGRATIONS.INTEGRATION_ID'
264: ) then
265:
266:

Line 263: ,p_associated_column2 => 'HR_KI_TOPIC_INTEGRATIONS.INTEGRATION_ID'

259: if hr_multi_message.no_exclusive_error
260: (p_check_column1 => 'HR_KI_TOPIC_INTEGRATIONS.TOPIC_ID'
261: ,p_associated_column1 => 'HR_KI_TOPIC_INTEGRATIONS.TOPIC_ID'
262: ,p_check_column2 => 'HR_KI_TOPIC_INTEGRATIONS.INTEGRATION_ID'
263: ,p_associated_column2 => 'HR_KI_TOPIC_INTEGRATIONS.INTEGRATION_ID'
264: ) then
265:
266:
267: open csr_int_options;

Line 332: from hr_ki_topic_integrations

328: l_found varchar2(1);
329:
330: cursor csr_int_options is
331: select null
332: from hr_ki_topic_integrations
333: where topic_id = p_topic_id
334: and integration_id = p_integration_id
335: and topic_integrations_id <> p_topic_integrations_id;
336: --

Line 345: (p_check_column1 => 'HR_KI_TOPIC_INTEGRATIONS.TOPIC_ID'

341: -- Multiple Message List does not already contain an errors
342: -- associated with the topic_id/integration_id columns.
343: --
344: if hr_multi_message.no_exclusive_error
345: (p_check_column1 => 'HR_KI_TOPIC_INTEGRATIONS.TOPIC_ID'
346: ,p_associated_column1 => 'HR_KI_TOPIC_INTEGRATIONS.TOPIC_ID'
347: ,p_check_column2 => 'HR_KI_TOPIC_INTEGRATIONS.INTEGRATION_ID'
348: ,p_associated_column2 => 'HR_KI_TOPIC_INTEGRATIONS.INTEGRATION_ID'
349: ) then

Line 346: ,p_associated_column1 => 'HR_KI_TOPIC_INTEGRATIONS.TOPIC_ID'

342: -- associated with the topic_id/integration_id columns.
343: --
344: if hr_multi_message.no_exclusive_error
345: (p_check_column1 => 'HR_KI_TOPIC_INTEGRATIONS.TOPIC_ID'
346: ,p_associated_column1 => 'HR_KI_TOPIC_INTEGRATIONS.TOPIC_ID'
347: ,p_check_column2 => 'HR_KI_TOPIC_INTEGRATIONS.INTEGRATION_ID'
348: ,p_associated_column2 => 'HR_KI_TOPIC_INTEGRATIONS.INTEGRATION_ID'
349: ) then
350:

Line 347: ,p_check_column2 => 'HR_KI_TOPIC_INTEGRATIONS.INTEGRATION_ID'

343: --
344: if hr_multi_message.no_exclusive_error
345: (p_check_column1 => 'HR_KI_TOPIC_INTEGRATIONS.TOPIC_ID'
346: ,p_associated_column1 => 'HR_KI_TOPIC_INTEGRATIONS.TOPIC_ID'
347: ,p_check_column2 => 'HR_KI_TOPIC_INTEGRATIONS.INTEGRATION_ID'
348: ,p_associated_column2 => 'HR_KI_TOPIC_INTEGRATIONS.INTEGRATION_ID'
349: ) then
350:
351:

Line 348: ,p_associated_column2 => 'HR_KI_TOPIC_INTEGRATIONS.INTEGRATION_ID'

344: if hr_multi_message.no_exclusive_error
345: (p_check_column1 => 'HR_KI_TOPIC_INTEGRATIONS.TOPIC_ID'
346: ,p_associated_column1 => 'HR_KI_TOPIC_INTEGRATIONS.TOPIC_ID'
347: ,p_check_column2 => 'HR_KI_TOPIC_INTEGRATIONS.INTEGRATION_ID'
348: ,p_associated_column2 => 'HR_KI_TOPIC_INTEGRATIONS.INTEGRATION_ID'
349: ) then
350:
351:
352: open csr_int_options;