APPS.OTA_LPE_SHD dependencies on OTA_LP_ENROLLMENTS

Line 22: If (p_constraint_name = 'OTA_LP_ENROLLMENTS_PK') Then

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

Line 95: from ota_lp_enrollments

91: ,attribute28
92: ,attribute29
93: ,attribute30
94: ,is_history_flag
95: from ota_lp_enrollments
96: where lp_enrollment_id = p_lp_enrollment_id;
97: --
98: l_fct_ret boolean;
99: --

Line 205: from ota_lp_enrollments

201: ,attribute28
202: ,attribute29
203: ,attribute30
204: ,is_history_flag
205: from ota_lp_enrollments
206: where lp_enrollment_id = p_lp_enrollment_id
207: for update nowait;
208: --
209: l_proc varchar2(72) := g_package||'lck';

Line 254: fnd_message.set_token('TABLE_NAME', 'ota_lp_enrollments');

250: -- The object is locked therefore we need to supply a meaningful
251: -- error message.
252: --
253: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
254: fnd_message.set_token('TABLE_NAME', 'ota_lp_enrollments');
255: fnd_message.raise_error;
256: End lck;
257: --
258: -- ----------------------------------------------------------------------------