APPS.OTA_COI_BUS dependencies on OTA_CHAT_OBJ_INCLUSIONS

Line 34: -- ota_chat_obj_inclusions and PER_BUSINESS_GROUPS_PERF

30: --
31: -- Declare cursor
32: --
33: -- EDIT_HERE In the following cursor statement add join(s) between
34: -- ota_chat_obj_inclusions and PER_BUSINESS_GROUPS_PERF
35: -- so that the security_group_id for
36: -- the current business group context can be derived.
37: -- Remove this comment when the edit has been completed.
38: cursor csr_sec_grp is

Line 42: , ota_chat_obj_inclusions coi

38: cursor csr_sec_grp is
39: select pbg.security_group_id,
40: pbg.legislation_code
41: from per_business_groups_perf pbg
42: , ota_chat_obj_inclusions coi
43: -- , EDIT_HERE table_name(s) 333
44: where coi.chat_id = p_chat_id
45: and coi.object_id = p_object_id
46: and coi.object_type = p_object_type;

Line 129: -- ota_chat_obj_inclusions and PER_BUSINESS_GROUPS_PERF

125: --
126: -- Declare cursor
127: --
128: -- EDIT_HERE In the following cursor statement add join(s) between
129: -- ota_chat_obj_inclusions and PER_BUSINESS_GROUPS_PERF
130: -- so that the legislation_code for
131: -- the current business group context can be derived.
132: -- Remove this comment when the edit has been completed.
133: cursor csr_leg_code is

Line 136: , ota_chat_obj_inclusions coi

132: -- Remove this comment when the edit has been completed.
133: cursor csr_leg_code is
134: select pbg.legislation_code
135: from per_business_groups_perf pbg
136: , ota_chat_obj_inclusions coi
137: -- , EDIT_HERE table_name(s) 333
138: where coi.chat_id = p_chat_id
139: and coi.object_id = p_object_id
140: and coi.object_type = p_object_type;

Line 290: from OTA_CHAT_OBJ_INCLUSIONS coi

286: v_proc varchar2(72) := g_package||'check_unique_key';
287: --
288: cursor sel_unique_key is
289: select 'Y'
290: from OTA_CHAT_OBJ_INCLUSIONS coi
291: where coi.chat_id = p_chat_id
292: and coi.object_id = p_object_id
293: and coi.object_type = 'C';
294: --

Line 314: p_associated_column1 => 'OTA_CHAT_OBJ_INCLUSIONS.chat_id',

310: Exception
311: WHEN app_exception.application_exception THEN
312:
313: IF hr_multi_message.exception_add(
314: p_associated_column1 => 'OTA_CHAT_OBJ_INCLUSIONS.chat_id',
315: p_associated_column2 => 'OTA_CHAT_OBJ_INCLUSIONS.object_id')
316: THEN
317: hr_utility.set_location(' Leaving:'||v_proc, 22);
318: RAISE;

Line 315: p_associated_column2 => 'OTA_CHAT_OBJ_INCLUSIONS.object_id')

311: WHEN app_exception.application_exception THEN
312:
313: IF hr_multi_message.exception_add(
314: p_associated_column1 => 'OTA_CHAT_OBJ_INCLUSIONS.chat_id',
315: p_associated_column2 => 'OTA_CHAT_OBJ_INCLUSIONS.object_id')
316: THEN
317: hr_utility.set_location(' Leaving:'||v_proc, 22);
318: RAISE;
319:

Line 429: from OTA_CHAT_OBJ_INCLUSIONS coi

425: v_proc varchar2(72) := g_package||'check_multiple_primary_ctgr';
426: v_exists varchar2(1);
427: cursor sel_multiple_primary is
428: select 'Y'
429: from OTA_CHAT_OBJ_INCLUSIONS coi
430: where coi.chat_id = p_chat_id
431: and coi.primary_flag = 'Y';
432: --
433: Begin

Line 453: p_associated_column1 => 'OTA_CHAT_OBJ_INCLUSIONS.PRIMARY_FLAG')

449: Exception
450: WHEN app_exception.application_exception THEN
451:
452: IF hr_multi_message.exception_add(
453: p_associated_column1 => 'OTA_CHAT_OBJ_INCLUSIONS.PRIMARY_FLAG')
454:
455: THEN
456:
457: hr_utility.set_location(' Leaving:'||v_proc, 22);

Line 483: from OTA_CHAT_OBJ_INCLUSIONS coi

479: v_proc varchar2(72) := g_package||'check_if_primary_category';
480: v_exists varchar2(1);
481: cursor sel_primary_category is
482: select 'Y'
483: from OTA_CHAT_OBJ_INCLUSIONS coi
484: where coi.chat_id = p_chat_id
485: and coi.object_id = p_object_id
486: and coi.primary_flag = 'Y';
487: --

Line 507: p_associated_column1 => 'OTA_CHAT_OBJ_INCLUSIONS.PRIMARY_FLAG')

503: Exception
504: WHEN app_exception.application_exception THEN
505:
506: IF hr_multi_message.exception_add(
507: p_associated_column1 => 'OTA_CHAT_OBJ_INCLUSIONS.PRIMARY_FLAG')
508:
509: THEN
510:
511: hr_utility.set_location(' Leaving:'||v_proc, 22);

Line 546: p_associated_column1 => 'OTA_CHAT_OBJ_INCLUSIONS.START_DATE_ACTIVE'

542: Exception
543: WHEN app_exception.application_exception THEN
544:
545: IF hr_multi_message.exception_add(
546: p_associated_column1 => 'OTA_CHAT_OBJ_INCLUSIONS.START_DATE_ACTIVE'
547: ,p_associated_column2 => 'OTA_CHAT_OBJ_INCLUSIONS.END_DATE_ACTIVE')
548: THEN
549:
550: hr_utility.set_location(' Leaving:'||v_proc, 22);

Line 547: ,p_associated_column2 => 'OTA_CHAT_OBJ_INCLUSIONS.END_DATE_ACTIVE')

543: WHEN app_exception.application_exception THEN
544:
545: IF hr_multi_message.exception_add(
546: p_associated_column1 => 'OTA_CHAT_OBJ_INCLUSIONS.START_DATE_ACTIVE'
547: ,p_associated_column2 => 'OTA_CHAT_OBJ_INCLUSIONS.END_DATE_ACTIVE')
548: THEN
549:
550: hr_utility.set_location(' Leaving:'||v_proc, 22);
551: RAISE;