APPS.OTA_OCL_SHD dependencies on OTA_COMPETENCE_LANGUAGES

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

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'OTA_COMPETENCE_LANGUAGES_PK') 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 26: ElsIf (p_constraint_name = 'OTA_COMPETENCE_LANGUAGES_UK') 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;
26: ElsIf (p_constraint_name = 'OTA_COMPETENCE_LANGUAGES_UK') Then
27: fnd_message.set_name('OTA','OTA_OCL_MAPPING_EXISTS');
28: fnd_message.raise_error;
29:
30: Else

Line 80: from ota_competence_languages

76: ,ocl_information17
77: ,ocl_information18
78: ,ocl_information19
79: ,ocl_information20
80: from ota_competence_languages
81: where competence_language_id = p_competence_language_id;
82: --
83: l_fct_ret boolean;
84: --

Line 172: from ota_competence_languages

168: ,ocl_information17
169: ,ocl_information18
170: ,ocl_information19
171: ,ocl_information20
172: from ota_competence_languages
173: where competence_language_id = p_competence_language_id
174: for update nowait;
175: --
176: l_proc varchar2(72) := g_package||'lck';

Line 215: fnd_message.set_token('TABLE_NAME', 'ota_competence_languages');

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