APPS.OTA_ANC_BUS dependencies on OTA_ANNOUNCEMENTS

Line 31: , ota_announcements anc

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_announcements anc
32: where anc.announcement_id = p_announcement_id
33: and pbg.business_group_id = anc.business_group_id;
34: --
35: -- Declare local variables

Line 101: , ota_announcements anc

97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , ota_announcements anc
102: where anc.announcement_id = p_announcement_id
103: and pbg.business_group_id = anc.business_group_id;
104: --
105: -- Declare local variables

Line 190: p_associated_column1 => 'OTA_ANNOUNCEMENTS.START_DATE_ACTIVE'

186: Exception
187: WHEN app_exception.application_exception THEN
188:
189: IF hr_multi_message.exception_add(
190: p_associated_column1 => 'OTA_ANNOUNCEMENTS.START_DATE_ACTIVE'
191: ,p_associated_column2 => 'OTA_ANNOUNCEMENTS.END_DATE_ACTIVE')
192: THEN
193:
194: hr_utility.set_location(' Leaving:'||l_proc, 22);

Line 191: ,p_associated_column2 => 'OTA_ANNOUNCEMENTS.END_DATE_ACTIVE')

187: WHEN app_exception.application_exception THEN
188:
189: IF hr_multi_message.exception_add(
190: p_associated_column1 => 'OTA_ANNOUNCEMENTS.START_DATE_ACTIVE'
191: ,p_associated_column2 => 'OTA_ANNOUNCEMENTS.END_DATE_ACTIVE')
192: THEN
193:
194: hr_utility.set_location(' Leaving:'||l_proc, 22);
195: RAISE;

Line 291: ,p_descflex_name => 'OTA_ANNOUNCEMENTS'

287: -- b) During insert.
288: --
289: hr_dflex_utility.ins_or_upd_descflex_attribs
290: (p_appl_short_name => 'OTA'
291: ,p_descflex_name => 'OTA_ANNOUNCEMENTS'
292: ,p_attribute_category => p_rec.attribute_category
293: ,p_attribute1_name => 'ATTRIBUTE1'
294: ,p_attribute1_value => p_rec.attribute1
295: ,p_attribute2_name => 'ATTRIBUTE2'