APPS.OTA_ANC_SHD dependencies on OTA_ANNOUNCEMENTS

Line 21: If (p_constraint_name = 'OTA_ANNOUNCEMENTS_PK1') Then

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'OTA_ANNOUNCEMENTS_PK1') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;

Line 76: from ota_announcements

72: ,attribute17
73: ,attribute18
74: ,attribute19
75: ,attribute20
76: from ota_announcements
77: where announcement_id = p_announcement_id;
78: --
79: l_fct_ret boolean;
80: --

Line 168: from ota_announcements

164: ,attribute17
165: ,attribute18
166: ,attribute19
167: ,attribute20
168: from ota_announcements
169: where announcement_id = p_announcement_id
170: for update nowait;
171: --
172: l_proc varchar2(72) := g_package||'lck';

Line 217: fnd_message.set_token('TABLE_NAME', 'ota_announcements');

213: -- The object is locked therefore we need to supply a meaningful
214: -- error message.
215: --
216: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
217: fnd_message.set_token('TABLE_NAME', 'ota_announcements');
218: fnd_message.raise_error;
219: End lck;
220: --
221: -- ----------------------------------------------------------------------------