APPS.PER_CPL_SHD dependencies on PER_COMPETENCES

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

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'PER_COMPETENCES_TL_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 55: from per_competences_tl

51: ,name
52: ,competence_alias
53: ,behavioural_indicator
54: ,description
55: from per_competences_tl
56: where competence_id = p_competence_id
57: and language = p_language;
58: --
59: l_fct_ret boolean;

Line 124: from per_competences_tl

120: ,name
121: ,competence_alias
122: ,behavioural_indicator
123: ,description
124: from per_competences_tl
125: where competence_id = p_competence_id
126: and language = p_language
127: for update nowait;
128: --

Line 170: fnd_message.set_token('TABLE_NAME', 'per_competences_tl');

166: -- The object is locked therefore we need to supply a meaningful
167: -- error message.
168: --
169: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
170: fnd_message.set_token('TABLE_NAME', 'per_competences_tl');
171: fnd_message.raise_error;
172: End lck;
173: --
174: -- ----------------------------------------------------------------------------

Line 198: from per_competences cpn

194: , cpl.description
195: , cpl.competence_alias
196: , cpl.name
197: --
198: from per_competences cpn
199: , per_competence_definitions cd
200: , per_competences_tl cpl
201: , fnd_languages l
202: where cpn.competence_definition_id = cd.competence_definition_id

Line 200: , per_competences_tl cpl

196: , cpl.name
197: --
198: from per_competences cpn
199: , per_competence_definitions cd
200: , per_competences_tl cpl
201: , fnd_languages l
202: where cpn.competence_definition_id = cd.competence_definition_id
203: and cpn.competence_id = cpl.competence_id
204: and cpl.language = userenv('LANG')

Line 207: from per_competences_tl t

203: and cpn.competence_id = cpl.competence_id
204: and cpl.language = userenv('LANG')
205: and l.installed_flag in ('I', 'B')
206: and not exists (select null
207: from per_competences_tl t
208: where t.competence_id = cpl.competence_id
209: and t.language = l.language_code)
210: order by l.language_code;
211: --

Line 222: delete from PER_COMPETENCES_TL T

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
225: from PER_COMPETENCES B
226: where B.COMPETENCE_ID = T.COMPETENCE_ID

Line 225: from PER_COMPETENCES B

221: --
222: delete from PER_COMPETENCES_TL T
223: where not exists
224: (select NULL
225: from PER_COMPETENCES B
226: where B.COMPETENCE_ID = T.COMPETENCE_ID
227: );
228:
229:

Line 246: insert into PER_COMPETENCES_TL (

242:
243: End if;
244: --
245:
246: insert into PER_COMPETENCES_TL (
247: COMPETENCE_ID,
248: NAME,
249: CREATED_BY,
250: CREATION_DATE,