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.OTA_CHA_BUS dependencies on OTA_CHATS_B

Line 31: , ota_chats_b cha

27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , ota_chats_b cha
32: where cha.chat_id = p_chat_id
33: and pbg.business_group_id = cha.business_group_id;
34: --
35: -- Declare local variables

Line 101: , ota_chats_b cha

97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , ota_chats_b cha
102: where cha.chat_id = p_chat_id
103: and pbg.business_group_id = cha.business_group_id;
104: --
105: -- Declare local variables

Line 256: (p_check_column1 => 'OTA_CHATS_B.START_DATE_ACTIVE'

252: Begin
253: hr_utility.set_location(' Entering:' || l_proc,10);
254: --
255: IF hr_multi_message.no_exclusive_error
256: (p_check_column1 => 'OTA_CHATS_B.START_DATE_ACTIVE'
257: ,p_check_column2 => 'OTA_CHATS_B.END_DATE_ACTIVE'
258: ,p_associated_column1 => 'OTA_CHATS_B.START_DATE_ACTIVE'
259: ,p_associated_column2 => 'OTA_CHATS_B.END_DATE_ACTIVE'
260: ) THEN

Line 257: ,p_check_column2 => 'OTA_CHATS_B.END_DATE_ACTIVE'

253: hr_utility.set_location(' Entering:' || l_proc,10);
254: --
255: IF hr_multi_message.no_exclusive_error
256: (p_check_column1 => 'OTA_CHATS_B.START_DATE_ACTIVE'
257: ,p_check_column2 => 'OTA_CHATS_B.END_DATE_ACTIVE'
258: ,p_associated_column1 => 'OTA_CHATS_B.START_DATE_ACTIVE'
259: ,p_associated_column2 => 'OTA_CHATS_B.END_DATE_ACTIVE'
260: ) THEN
261: --

Line 258: ,p_associated_column1 => 'OTA_CHATS_B.START_DATE_ACTIVE'

254: --
255: IF hr_multi_message.no_exclusive_error
256: (p_check_column1 => 'OTA_CHATS_B.START_DATE_ACTIVE'
257: ,p_check_column2 => 'OTA_CHATS_B.END_DATE_ACTIVE'
258: ,p_associated_column1 => 'OTA_CHATS_B.START_DATE_ACTIVE'
259: ,p_associated_column2 => 'OTA_CHATS_B.END_DATE_ACTIVE'
260: ) THEN
261: --
262: OPEN csr_cat_start_end_date;

Line 259: ,p_associated_column2 => 'OTA_CHATS_B.END_DATE_ACTIVE'

255: IF hr_multi_message.no_exclusive_error
256: (p_check_column1 => 'OTA_CHATS_B.START_DATE_ACTIVE'
257: ,p_check_column2 => 'OTA_CHATS_B.END_DATE_ACTIVE'
258: ,p_associated_column1 => 'OTA_CHATS_B.START_DATE_ACTIVE'
259: ,p_associated_column2 => 'OTA_CHATS_B.END_DATE_ACTIVE'
260: ) THEN
261: --
262: OPEN csr_cat_start_end_date;
263: FETCH csr_cat_start_end_date into l_cat_start_date, l_cat_end_date;

Line 286: (p_associated_column1 => 'OTA_CHATS_B.START_DATE_ACTIVE'

282: hr_utility.set_location(' Leaving:' || l_proc,10);
283: Exception
284: when app_exception.application_exception then
285: IF hr_multi_message.exception_add
286: (p_associated_column1 => 'OTA_CHATS_B.START_DATE_ACTIVE'
287: ,p_associated_column2 => 'OTA_CHATS_B.END_DATE_ACTIVE'
288: ) THEN
289: hr_utility.set_location(' Leaving:'|| l_proc,20);
290: raise;

Line 287: ,p_associated_column2 => 'OTA_CHATS_B.END_DATE_ACTIVE'

283: Exception
284: when app_exception.application_exception then
285: IF hr_multi_message.exception_add
286: (p_associated_column1 => 'OTA_CHATS_B.START_DATE_ACTIVE'
287: ,p_associated_column2 => 'OTA_CHATS_B.END_DATE_ACTIVE'
288: ) THEN
289: hr_utility.set_location(' Leaving:'|| l_proc,20);
290: raise;
291: END IF;