eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_CPL_UPD dependencies on HR_API

Line 85: When hr_api.check_integrity_violated Then

81: --
82: hr_utility.set_location(' Leaving:'||l_proc, 10);
83: --
84: Exception
85: When hr_api.check_integrity_violated Then
86: -- A check constraint has been violated
87: --
88: per_cpl_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

85: When hr_api.check_integrity_violated Then
86: -- A check constraint has been violated
87: --
88: per_cpl_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.parent_integrity_violated Then
91: -- Parent integrity has been violated
92: --
93: per_cpl_shd.constraint_error

Line 90: When hr_api.parent_integrity_violated Then

86: -- A check constraint has been violated
87: --
88: per_cpl_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.parent_integrity_violated Then
91: -- Parent integrity has been violated
92: --
93: per_cpl_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

90: When hr_api.parent_integrity_violated Then
91: -- Parent integrity has been violated
92: --
93: per_cpl_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: --
98: per_cpl_shd.constraint_error

Line 95: When hr_api.unique_integrity_violated Then

91: -- Parent integrity has been violated
92: --
93: per_cpl_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: --
98: per_cpl_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: --
98: per_cpl_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When Others Then
101: --
102: Raise;
103: End update_dml;

Line 222: when hr_api.cannot_find_prog_unit then

218: );
219: --
220: exception
221: --
222: when hr_api.cannot_find_prog_unit then
223: --
224: hr_api.cannot_find_prog_unit_error
225: (p_module_name => 'PER_COMPETENCES_TL'
226: ,p_hook_type => 'AU');

Line 224: hr_api.cannot_find_prog_unit_error

220: exception
221: --
222: when hr_api.cannot_find_prog_unit then
223: --
224: hr_api.cannot_find_prog_unit_error
225: (p_module_name => 'PER_COMPETENCES_TL'
226: ,p_hook_type => 'AU');
227: --
228: end;

Line 287: If (p_rec.source_lang = hr_api.g_varchar2) then

283: -- p_rec plsql record structure
284: -- to see if a system default is being used. If a system default
285: -- is being used then we must set to the 'current' argument value.
286: --
287: If (p_rec.source_lang = hr_api.g_varchar2) then
288: p_rec.source_lang :=
289: per_cpl_shd.g_old_rec.source_lang;
290: End If;
291: If (p_rec.name = hr_api.g_varchar2) then

Line 291: If (p_rec.name = hr_api.g_varchar2) then

287: If (p_rec.source_lang = hr_api.g_varchar2) then
288: p_rec.source_lang :=
289: per_cpl_shd.g_old_rec.source_lang;
290: End If;
291: If (p_rec.name = hr_api.g_varchar2) then
292: p_rec.name :=
293: per_cpl_shd.g_old_rec.name;
294: End If;
295: If (p_rec.competence_alias = hr_api.g_varchar2) then

Line 295: If (p_rec.competence_alias = hr_api.g_varchar2) then

291: If (p_rec.name = hr_api.g_varchar2) then
292: p_rec.name :=
293: per_cpl_shd.g_old_rec.name;
294: End If;
295: If (p_rec.competence_alias = hr_api.g_varchar2) then
296: p_rec.competence_alias :=
297: per_cpl_shd.g_old_rec.competence_alias;
298: End If;
299: If (p_rec.behavioural_indicator = hr_api.g_varchar2) then

Line 299: If (p_rec.behavioural_indicator = hr_api.g_varchar2) then

295: If (p_rec.competence_alias = hr_api.g_varchar2) then
296: p_rec.competence_alias :=
297: per_cpl_shd.g_old_rec.competence_alias;
298: End If;
299: If (p_rec.behavioural_indicator = hr_api.g_varchar2) then
300: p_rec.behavioural_indicator :=
301: per_cpl_shd.g_old_rec.behavioural_indicator;
302: End If;
303: If (p_rec.description = hr_api.g_varchar2) then

Line 303: If (p_rec.description = hr_api.g_varchar2) then

299: If (p_rec.behavioural_indicator = hr_api.g_varchar2) then
300: p_rec.behavioural_indicator :=
301: per_cpl_shd.g_old_rec.behavioural_indicator;
302: End If;
303: If (p_rec.description = hr_api.g_varchar2) then
304: p_rec.description :=
305: per_cpl_shd.g_old_rec.description;
306: End If;
307: --

Line 371: ,p_source_lang in varchar2 default hr_api.g_varchar2

367: Procedure upd
368: (p_effective_date in date
369: ,p_competence_id in number
370: ,p_language in varchar2
371: ,p_source_lang in varchar2 default hr_api.g_varchar2
372: ,p_name in varchar2 default hr_api.g_varchar2
373: ,p_competence_alias in varchar2 default hr_api.g_varchar2
374: ,p_behavioural_indicator in varchar2 default hr_api.g_varchar2
375: ,p_description in varchar2 default hr_api.g_varchar2

Line 372: ,p_name in varchar2 default hr_api.g_varchar2

368: (p_effective_date in date
369: ,p_competence_id in number
370: ,p_language in varchar2
371: ,p_source_lang in varchar2 default hr_api.g_varchar2
372: ,p_name in varchar2 default hr_api.g_varchar2
373: ,p_competence_alias in varchar2 default hr_api.g_varchar2
374: ,p_behavioural_indicator in varchar2 default hr_api.g_varchar2
375: ,p_description in varchar2 default hr_api.g_varchar2
376: ) is

Line 373: ,p_competence_alias in varchar2 default hr_api.g_varchar2

369: ,p_competence_id in number
370: ,p_language in varchar2
371: ,p_source_lang in varchar2 default hr_api.g_varchar2
372: ,p_name in varchar2 default hr_api.g_varchar2
373: ,p_competence_alias in varchar2 default hr_api.g_varchar2
374: ,p_behavioural_indicator in varchar2 default hr_api.g_varchar2
375: ,p_description in varchar2 default hr_api.g_varchar2
376: ) is
377: --

Line 374: ,p_behavioural_indicator in varchar2 default hr_api.g_varchar2

370: ,p_language in varchar2
371: ,p_source_lang in varchar2 default hr_api.g_varchar2
372: ,p_name in varchar2 default hr_api.g_varchar2
373: ,p_competence_alias in varchar2 default hr_api.g_varchar2
374: ,p_behavioural_indicator in varchar2 default hr_api.g_varchar2
375: ,p_description in varchar2 default hr_api.g_varchar2
376: ) is
377: --
378: l_rec per_cpl_shd.g_rec_type;

Line 375: ,p_description in varchar2 default hr_api.g_varchar2

371: ,p_source_lang in varchar2 default hr_api.g_varchar2
372: ,p_name in varchar2 default hr_api.g_varchar2
373: ,p_competence_alias in varchar2 default hr_api.g_varchar2
374: ,p_behavioural_indicator in varchar2 default hr_api.g_varchar2
375: ,p_description in varchar2 default hr_api.g_varchar2
376: ) is
377: --
378: l_rec per_cpl_shd.g_rec_type;
379: l_proc varchar2(72) := g_package||'upd';

Line 418: ,p_name in varchar2 default hr_api.g_varchar2

414: Procedure upd_tl
415: (p_effective_date in date
416: ,p_language_code in varchar2
417: ,p_competence_id in number
418: ,p_name in varchar2 default hr_api.g_varchar2
419: ,p_competence_alias in varchar2 default hr_api.g_varchar2
420: ,p_behavioural_indicator in varchar2 default hr_api.g_varchar2
421: ,p_description in varchar2 default hr_api.g_varchar2
422: ) is

Line 419: ,p_competence_alias in varchar2 default hr_api.g_varchar2

415: (p_effective_date in date
416: ,p_language_code in varchar2
417: ,p_competence_id in number
418: ,p_name in varchar2 default hr_api.g_varchar2
419: ,p_competence_alias in varchar2 default hr_api.g_varchar2
420: ,p_behavioural_indicator in varchar2 default hr_api.g_varchar2
421: ,p_description in varchar2 default hr_api.g_varchar2
422: ) is
423: --

Line 420: ,p_behavioural_indicator in varchar2 default hr_api.g_varchar2

416: ,p_language_code in varchar2
417: ,p_competence_id in number
418: ,p_name in varchar2 default hr_api.g_varchar2
419: ,p_competence_alias in varchar2 default hr_api.g_varchar2
420: ,p_behavioural_indicator in varchar2 default hr_api.g_varchar2
421: ,p_description in varchar2 default hr_api.g_varchar2
422: ) is
423: --
424: -- Cursor to obtain the translation rows where the language or

Line 421: ,p_description in varchar2 default hr_api.g_varchar2

417: ,p_competence_id in number
418: ,p_name in varchar2 default hr_api.g_varchar2
419: ,p_competence_alias in varchar2 default hr_api.g_varchar2
420: ,p_behavioural_indicator in varchar2 default hr_api.g_varchar2
421: ,p_description in varchar2 default hr_api.g_varchar2
422: ) is
423: --
424: -- Cursor to obtain the translation rows where the language or
425: -- source_lang match the specified language.