APPS.OTA_TEA_SHD dependencies on OTA_EVENT_ASSOCIATIONS

Line 37: If (p_constraint_name = 'OTA_EVENT_ASSOCIATIONS_PK') Then

33: --
34: Begin
35: hr_utility.set_location('Entering:'||l_proc, 5);
36: --
37: If (p_constraint_name = 'OTA_EVENT_ASSOCIATIONS_PK') Then
38: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
39: hr_utility.set_message_token('PROCEDURE', l_proc);
40: hr_utility.set_message_token('STEP','5');
41: hr_utility.raise_error;

Line 42: ElsIf (p_constraint_name = 'OTA_EVENT_ASSOCIATIONS_UK2') Then

38: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
39: hr_utility.set_message_token('PROCEDURE', l_proc);
40: hr_utility.set_message_token('STEP','5');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'OTA_EVENT_ASSOCIATIONS_UK2') Then
43: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','10');
46: hr_utility.raise_error;

Line 101: from ota_event_associations

97: tea_information17,
98: tea_information18,
99: tea_information19,
100: tea_information20
101: from ota_event_associations
102: where event_association_id = p_event_association_id;
103: --
104: l_proc varchar2(72) := g_package||'api_updating';
105: l_fct_ret boolean;

Line 204: from ota_event_associations

200: tea_information17,
201: tea_information18,
202: tea_information19,
203: tea_information20
204: from ota_event_associations
205: where event_association_id = p_event_association_id
206: for update nowait;
207: --
208: l_proc varchar2(72) := g_package||'lck';

Line 251: hr_utility.set_message_token('TABLE_NAME', 'ota_event_associations');

247: -- The object is locked therefore we need to supply a meaningful
248: -- error message.
249: --
250: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
251: hr_utility.set_message_token('TABLE_NAME', 'ota_event_associations');
252: hr_utility.raise_error;
253: End lck;
254: --
255: -- ----------------------------------------------------------------------------