APPS.OTA_FCE_SHD dependencies on OTA_OPEN_FC_ENROLLMENTS

Line 32: If (p_constraint_name = 'OTA_OPEN_FC_ENROLLMENTS_PK') Then

28: l_proc varchar2(72) := g_package||'constraint_error';
29: --
30: Begin
31: --
32: If (p_constraint_name = 'OTA_OPEN_FC_ENROLLMENTS_PK') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;

Line 67: from ota_open_fc_enrollments

63: ,person_id
64: ,contact_id
65: ,object_version_number
66: ,chat_id
67: from ota_open_fc_enrollments
68: where enrollment_id = p_enrollment_id;
69: --
70: l_fct_ret boolean;
71: --

Line 139: from ota_open_fc_enrollments

135: ,person_id
136: ,contact_id
137: ,object_version_number
138: ,chat_id
139: from ota_open_fc_enrollments
140: where enrollment_id = p_enrollment_id
141: for update nowait;
142: --
143: l_proc varchar2(72) := g_package||'lck';

Line 188: fnd_message.set_token('TABLE_NAME', 'ota_open_fc_enrollments');

184: -- The object is locked therefore we need to supply a meaningful
185: -- error message.
186: --
187: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
188: fnd_message.set_token('TABLE_NAME', 'ota_open_fc_enrollments');
189: fnd_message.raise_error;
190: End lck;
191: --
192: -- ----------------------------------------------------------------------------