APPS.OTA_LPS_SHD dependencies on OTA_LEARNING_PATHS

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

18: --
19: Begin
20: --
21: /*
22: If (p_constraint_name = 'OTA_LEARNING_PATHS_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 34: If (p_constraint_name = 'OTA_LEARNING_PATHS_UK1') Then

30: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
31: fnd_message.raise_error;
32: End If;
33: */
34: If (p_constraint_name = 'OTA_LEARNING_PATHS_UK1') Then
35: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
36: fnd_message.set_token('PROCEDURE', l_proc);
37: fnd_message.set_token('STEP','5');
38: fnd_message.raise_error;

Line 100: from ota_learning_paths

96: ,contact_id
97: ,display_to_learner_flag
98: ,public_flag
99: ,competency_update_level
100: from ota_learning_paths
101: where learning_path_id = p_learning_path_id;
102: --
103: l_fct_ret boolean;
104: --

Line 203: from ota_learning_paths

199: ,contact_id
200: ,display_to_learner_flag
201: ,public_flag
202: ,competency_update_level
203: from ota_learning_paths
204: where learning_path_id = p_learning_path_id
205: for update nowait;
206: --
207: l_proc varchar2(72) := g_package||'lck';

Line 252: fnd_message.set_token('TABLE_NAME', 'ota_learning_paths');

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