128: --
129: l_proc varchar2(72) := g_package||'lck';
130: --
131: Begin
132: hr_utility.set_location('Entering:'||l_proc, 5);
133: --
134: hr_api.mandatory_arg_error
135: (p_api_name => l_proc
136: ,p_argument => 'COMPETENCE_ID'
135: (p_api_name => l_proc
136: ,p_argument => 'COMPETENCE_ID'
137: ,p_argument_value => p_competence_id
138: );
139: hr_utility.set_location(l_proc,6);
140: hr_api.mandatory_arg_error
141: (p_api_name => l_proc
142: ,p_argument => 'LANGUAGE'
143: ,p_argument_value => p_language
155: End If;
156: Close C_Sel1;
157: --
158: --
159: hr_utility.set_location(' Leaving:'||l_proc, 10);
160: --
161: -- We need to trap the ORA LOCK exception
162: --
163: Exception
216: l_proc varchar2(72) := g_package||'add_language';
217: --
218: begin
219: --
220: hr_utility.set_location('Entering:'||l_proc, 5);
221: --
222: delete from PER_COMPETENCES_TL T
223: where not exists
224: (select NULL
281: End loop;
282: --
283: hr_kflex_utility.set_session_language_code( l_userenv_language_code );
284: --
285: hr_utility.set_location(' Leaving:'||l_proc, 10);
286: --
287:
288: Exception
289: --