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_FRM_BUS dependencies on OTA_FORUMS_B

Line 31: , ota_forums_b frm

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_forums_b frm
32: where frm.forum_id = p_forum_id
33: and pbg.business_group_id = frm.business_group_id;
34: --
35: -- Declare local variables

Line 101: , ota_forums_b frm

97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , ota_forums_b frm
102: where frm.forum_id = p_forum_id
103: and pbg.business_group_id = frm.business_group_id;
104: --
105: -- Declare local variables

Line 241: p_associated_column1 => 'OTA_FORUMS_B.START_DATE_ACTIVE')

237: Exception
238: WHEN app_exception.application_exception THEN
239:
240: IF hr_multi_message.exception_add(
241: p_associated_column1 => 'OTA_FORUMS_B.START_DATE_ACTIVE')
242: -- ,p_associated_column2 => 'OTA_FORUMS_B.END_DATE_ACTIVE')
243: THEN
244:
245: hr_utility.set_location(' Leaving:'||v_proc, 22);

Line 242: -- ,p_associated_column2 => 'OTA_FORUMS_B.END_DATE_ACTIVE')

238: WHEN app_exception.application_exception THEN
239:
240: IF hr_multi_message.exception_add(
241: p_associated_column1 => 'OTA_FORUMS_B.START_DATE_ACTIVE')
242: -- ,p_associated_column2 => 'OTA_FORUMS_B.END_DATE_ACTIVE')
243: THEN
244:
245: hr_utility.set_location(' Leaving:'||v_proc, 22);
246: RAISE;

Line 295: (p_check_column1 => 'OTA_FORUMS_B.START_DATE_ACTIVE'

291: Begin
292: hr_utility.set_location(' Entering:' || l_proc,10);
293: --
294: if(hr_multi_message.no_exclusive_error
295: (p_check_column1 => 'OTA_FORUMS_B.START_DATE_ACTIVE'
296: ,p_check_column2 => 'OTA_FORUMS_B.END_DATE_ACTIVE'
297: ,p_associated_column1 => 'OTA_FORUMS_B.START_DATE_ACTIVE'
298: ,p_associated_column2 => 'OTA_FORUMS_B.END_DATE_ACTIVE'
299: )) THEN

Line 296: ,p_check_column2 => 'OTA_FORUMS_B.END_DATE_ACTIVE'

292: hr_utility.set_location(' Entering:' || l_proc,10);
293: --
294: if(hr_multi_message.no_exclusive_error
295: (p_check_column1 => 'OTA_FORUMS_B.START_DATE_ACTIVE'
296: ,p_check_column2 => 'OTA_FORUMS_B.END_DATE_ACTIVE'
297: ,p_associated_column1 => 'OTA_FORUMS_B.START_DATE_ACTIVE'
298: ,p_associated_column2 => 'OTA_FORUMS_B.END_DATE_ACTIVE'
299: )) THEN
300: --

Line 297: ,p_associated_column1 => 'OTA_FORUMS_B.START_DATE_ACTIVE'

293: --
294: if(hr_multi_message.no_exclusive_error
295: (p_check_column1 => 'OTA_FORUMS_B.START_DATE_ACTIVE'
296: ,p_check_column2 => 'OTA_FORUMS_B.END_DATE_ACTIVE'
297: ,p_associated_column1 => 'OTA_FORUMS_B.START_DATE_ACTIVE'
298: ,p_associated_column2 => 'OTA_FORUMS_B.END_DATE_ACTIVE'
299: )) THEN
300: --
301: OPEN csr_cat_start_end_date;

Line 298: ,p_associated_column2 => 'OTA_FORUMS_B.END_DATE_ACTIVE'

294: if(hr_multi_message.no_exclusive_error
295: (p_check_column1 => 'OTA_FORUMS_B.START_DATE_ACTIVE'
296: ,p_check_column2 => 'OTA_FORUMS_B.END_DATE_ACTIVE'
297: ,p_associated_column1 => 'OTA_FORUMS_B.START_DATE_ACTIVE'
298: ,p_associated_column2 => 'OTA_FORUMS_B.END_DATE_ACTIVE'
299: )) THEN
300: --
301: OPEN csr_cat_start_end_date;
302: FETCH csr_cat_start_end_date into l_cat_start_date, l_cat_end_date;

Line 325: (p_associated_column1 => 'OTA_FORUMS_B.START_DATE_ACTIVE'

321: hr_utility.set_location(' Leaving:' || l_proc,10);
322: Exception
323: when app_exception.application_exception then
324: IF hr_multi_message.exception_add
325: (p_associated_column1 => 'OTA_FORUMS_B.START_DATE_ACTIVE'
326: ,p_associated_column2 => 'OTA_FORUMS_B.END_DATE_ACTIVE'
327: ) THEN
328: hr_utility.set_location(' Leaving:'|| l_proc,20);
329: raise;

Line 326: ,p_associated_column2 => 'OTA_FORUMS_B.END_DATE_ACTIVE'

322: Exception
323: when app_exception.application_exception then
324: IF hr_multi_message.exception_add
325: (p_associated_column1 => 'OTA_FORUMS_B.START_DATE_ACTIVE'
326: ,p_associated_column2 => 'OTA_FORUMS_B.END_DATE_ACTIVE'
327: ) THEN
328: hr_utility.set_location(' Leaving:'|| l_proc,20);
329: raise;
330: END IF;

Line 393: (p_associated_column1 => 'OTA_FORUMS_B.END_DATE_ACTIVE'

389: hr_utility.set_location(' Leaving:' || l_proc,10);
390: Exception
391: when app_exception.application_exception then
392: IF hr_multi_message.exception_add
393: (p_associated_column1 => 'OTA_FORUMS_B.END_DATE_ACTIVE'
394: ) THEN
395: hr_utility.set_location(' Leaving:'|| l_proc,20);
396: raise;
397: END IF;