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_QAT_UPD dependencies on HR_API

Line 89: When hr_api.check_integrity_violated Then

85: --
86: hr_utility.set_location(' Leaving:'||l_proc, 10);
87: --
88: Exception
89: When hr_api.check_integrity_violated Then
90: -- A check constraint has been violated
91: --
92: per_qat_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

89: When hr_api.check_integrity_violated Then
90: -- A check constraint has been violated
91: --
92: per_qat_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.parent_integrity_violated Then
95: -- Parent integrity has been violated
96: --
97: per_qat_shd.constraint_error

Line 94: When hr_api.parent_integrity_violated Then

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

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

94: When hr_api.parent_integrity_violated Then
95: -- Parent integrity has been violated
96: --
97: per_qat_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When hr_api.unique_integrity_violated Then
100: -- Unique integrity has been violated
101: --
102: per_qat_shd.constraint_error

Line 99: When hr_api.unique_integrity_violated Then

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

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

99: When hr_api.unique_integrity_violated Then
100: -- Unique integrity has been violated
101: --
102: per_qat_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When Others Then
105: --
106: Raise;
107: End update_dml;

Line 240: when hr_api.cannot_find_prog_unit then

236: );
237: --
238: exception
239: --
240: when hr_api.cannot_find_prog_unit then
241: --
242: hr_api.cannot_find_prog_unit_error
243: (p_module_name => 'PER_QUALIFICATIONS_TL'
244: ,p_hook_type => 'AU');

Line 242: hr_api.cannot_find_prog_unit_error

238: exception
239: --
240: when hr_api.cannot_find_prog_unit then
241: --
242: hr_api.cannot_find_prog_unit_error
243: (p_module_name => 'PER_QUALIFICATIONS_TL'
244: ,p_hook_type => 'AU');
245: --
246: end;

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

301: -- p_rec plsql record structure
302: -- to see if a system default is being used. If a system default
303: -- is being used then we must set to the 'current' argument value.
304: --
305: If (p_rec.source_lang = hr_api.g_varchar2) then
306: p_rec.source_lang :=
307: per_qat_shd.g_old_rec.source_lang;
308: End If;
309: If (p_rec.title = hr_api.g_varchar2) then

Line 309: If (p_rec.title = hr_api.g_varchar2) then

305: If (p_rec.source_lang = hr_api.g_varchar2) then
306: p_rec.source_lang :=
307: per_qat_shd.g_old_rec.source_lang;
308: End If;
309: If (p_rec.title = hr_api.g_varchar2) then
310: p_rec.title :=
311: per_qat_shd.g_old_rec.title;
312: End If;
313: If (p_rec.group_ranking = hr_api.g_varchar2) then

Line 313: If (p_rec.group_ranking = hr_api.g_varchar2) then

309: If (p_rec.title = hr_api.g_varchar2) then
310: p_rec.title :=
311: per_qat_shd.g_old_rec.title;
312: End If;
313: If (p_rec.group_ranking = hr_api.g_varchar2) then
314: p_rec.group_ranking :=
315: per_qat_shd.g_old_rec.group_ranking;
316: End If;
317: If (p_rec.license_restrictions = hr_api.g_varchar2) then

Line 317: If (p_rec.license_restrictions = hr_api.g_varchar2) then

313: If (p_rec.group_ranking = hr_api.g_varchar2) then
314: p_rec.group_ranking :=
315: per_qat_shd.g_old_rec.group_ranking;
316: End If;
317: If (p_rec.license_restrictions = hr_api.g_varchar2) then
318: p_rec.license_restrictions :=
319: per_qat_shd.g_old_rec.license_restrictions;
320: End If;
321: If (p_rec.awarding_body = hr_api.g_varchar2) then

Line 321: If (p_rec.awarding_body = hr_api.g_varchar2) then

317: If (p_rec.license_restrictions = hr_api.g_varchar2) then
318: p_rec.license_restrictions :=
319: per_qat_shd.g_old_rec.license_restrictions;
320: End If;
321: If (p_rec.awarding_body = hr_api.g_varchar2) then
322: p_rec.awarding_body :=
323: per_qat_shd.g_old_rec.awarding_body;
324: End If;
325: If (p_rec.grade_attained = hr_api.g_varchar2) then

Line 325: If (p_rec.grade_attained = hr_api.g_varchar2) then

321: If (p_rec.awarding_body = hr_api.g_varchar2) then
322: p_rec.awarding_body :=
323: per_qat_shd.g_old_rec.awarding_body;
324: End If;
325: If (p_rec.grade_attained = hr_api.g_varchar2) then
326: p_rec.grade_attained :=
327: per_qat_shd.g_old_rec.grade_attained;
328: End If;
329: If (p_rec.reimbursement_arrangements = hr_api.g_varchar2) then

Line 329: If (p_rec.reimbursement_arrangements = hr_api.g_varchar2) then

325: If (p_rec.grade_attained = hr_api.g_varchar2) then
326: p_rec.grade_attained :=
327: per_qat_shd.g_old_rec.grade_attained;
328: End If;
329: If (p_rec.reimbursement_arrangements = hr_api.g_varchar2) then
330: p_rec.reimbursement_arrangements :=
331: per_qat_shd.g_old_rec.reimbursement_arrangements;
332: End If;
333: If (p_rec.training_completed_units = hr_api.g_varchar2) then

Line 333: If (p_rec.training_completed_units = hr_api.g_varchar2) then

329: If (p_rec.reimbursement_arrangements = hr_api.g_varchar2) then
330: p_rec.reimbursement_arrangements :=
331: per_qat_shd.g_old_rec.reimbursement_arrangements;
332: End If;
333: If (p_rec.training_completed_units = hr_api.g_varchar2) then
334: p_rec.training_completed_units :=
335: per_qat_shd.g_old_rec.training_completed_units;
336: End If;
337: If (p_rec.membership_category = hr_api.g_varchar2) then

Line 337: If (p_rec.membership_category = hr_api.g_varchar2) then

333: If (p_rec.training_completed_units = hr_api.g_varchar2) then
334: p_rec.training_completed_units :=
335: per_qat_shd.g_old_rec.training_completed_units;
336: End If;
337: If (p_rec.membership_category = hr_api.g_varchar2) then
338: p_rec.membership_category :=
339: per_qat_shd.g_old_rec.membership_category;
340: End If;
341: --

Line 401: ,p_source_lang in varchar2 default hr_api.g_varchar2

397: -- ----------------------------------------------------------------------------
398: Procedure upd
399: (p_qualification_id in number
400: ,p_language in varchar2
401: ,p_source_lang in varchar2 default hr_api.g_varchar2
402: ,p_title in varchar2 default hr_api.g_varchar2
403: ,p_group_ranking in varchar2 default hr_api.g_varchar2
404: ,p_license_restrictions in varchar2 default hr_api.g_varchar2
405: ,p_awarding_body in varchar2 default hr_api.g_varchar2

Line 402: ,p_title in varchar2 default hr_api.g_varchar2

398: Procedure upd
399: (p_qualification_id in number
400: ,p_language in varchar2
401: ,p_source_lang in varchar2 default hr_api.g_varchar2
402: ,p_title in varchar2 default hr_api.g_varchar2
403: ,p_group_ranking in varchar2 default hr_api.g_varchar2
404: ,p_license_restrictions in varchar2 default hr_api.g_varchar2
405: ,p_awarding_body in varchar2 default hr_api.g_varchar2
406: ,p_grade_attained in varchar2 default hr_api.g_varchar2

Line 403: ,p_group_ranking in varchar2 default hr_api.g_varchar2

399: (p_qualification_id in number
400: ,p_language in varchar2
401: ,p_source_lang in varchar2 default hr_api.g_varchar2
402: ,p_title in varchar2 default hr_api.g_varchar2
403: ,p_group_ranking in varchar2 default hr_api.g_varchar2
404: ,p_license_restrictions in varchar2 default hr_api.g_varchar2
405: ,p_awarding_body in varchar2 default hr_api.g_varchar2
406: ,p_grade_attained in varchar2 default hr_api.g_varchar2
407: ,p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2

Line 404: ,p_license_restrictions in varchar2 default hr_api.g_varchar2

400: ,p_language in varchar2
401: ,p_source_lang in varchar2 default hr_api.g_varchar2
402: ,p_title in varchar2 default hr_api.g_varchar2
403: ,p_group_ranking in varchar2 default hr_api.g_varchar2
404: ,p_license_restrictions in varchar2 default hr_api.g_varchar2
405: ,p_awarding_body in varchar2 default hr_api.g_varchar2
406: ,p_grade_attained in varchar2 default hr_api.g_varchar2
407: ,p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2
408: ,p_training_completed_units in varchar2 default hr_api.g_varchar2

Line 405: ,p_awarding_body in varchar2 default hr_api.g_varchar2

401: ,p_source_lang in varchar2 default hr_api.g_varchar2
402: ,p_title in varchar2 default hr_api.g_varchar2
403: ,p_group_ranking in varchar2 default hr_api.g_varchar2
404: ,p_license_restrictions in varchar2 default hr_api.g_varchar2
405: ,p_awarding_body in varchar2 default hr_api.g_varchar2
406: ,p_grade_attained in varchar2 default hr_api.g_varchar2
407: ,p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2
408: ,p_training_completed_units in varchar2 default hr_api.g_varchar2
409: ,p_membership_category in varchar2 default hr_api.g_varchar2

Line 406: ,p_grade_attained in varchar2 default hr_api.g_varchar2

402: ,p_title in varchar2 default hr_api.g_varchar2
403: ,p_group_ranking in varchar2 default hr_api.g_varchar2
404: ,p_license_restrictions in varchar2 default hr_api.g_varchar2
405: ,p_awarding_body in varchar2 default hr_api.g_varchar2
406: ,p_grade_attained in varchar2 default hr_api.g_varchar2
407: ,p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2
408: ,p_training_completed_units in varchar2 default hr_api.g_varchar2
409: ,p_membership_category in varchar2 default hr_api.g_varchar2
410: ) is

Line 407: ,p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2

403: ,p_group_ranking in varchar2 default hr_api.g_varchar2
404: ,p_license_restrictions in varchar2 default hr_api.g_varchar2
405: ,p_awarding_body in varchar2 default hr_api.g_varchar2
406: ,p_grade_attained in varchar2 default hr_api.g_varchar2
407: ,p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2
408: ,p_training_completed_units in varchar2 default hr_api.g_varchar2
409: ,p_membership_category in varchar2 default hr_api.g_varchar2
410: ) is
411: --

Line 408: ,p_training_completed_units in varchar2 default hr_api.g_varchar2

404: ,p_license_restrictions in varchar2 default hr_api.g_varchar2
405: ,p_awarding_body in varchar2 default hr_api.g_varchar2
406: ,p_grade_attained in varchar2 default hr_api.g_varchar2
407: ,p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2
408: ,p_training_completed_units in varchar2 default hr_api.g_varchar2
409: ,p_membership_category in varchar2 default hr_api.g_varchar2
410: ) is
411: --
412: l_rec per_qat_shd.g_rec_type;

Line 409: ,p_membership_category in varchar2 default hr_api.g_varchar2

405: ,p_awarding_body in varchar2 default hr_api.g_varchar2
406: ,p_grade_attained in varchar2 default hr_api.g_varchar2
407: ,p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2
408: ,p_training_completed_units in varchar2 default hr_api.g_varchar2
409: ,p_membership_category in varchar2 default hr_api.g_varchar2
410: ) is
411: --
412: l_rec per_qat_shd.g_rec_type;
413: l_proc varchar2(72) := g_package||'upd';

Line 454: ,p_title in varchar2 default hr_api.g_varchar2

450: -- ----------------------------------------------------------------------------
451: Procedure upd_tl
452: (p_language_code in varchar2
453: ,p_qualification_id in number
454: ,p_title in varchar2 default hr_api.g_varchar2
455: ,p_group_ranking in varchar2 default hr_api.g_varchar2
456: ,p_license_restrictions in varchar2 default hr_api.g_varchar2
457: ,p_awarding_body in varchar2 default hr_api.g_varchar2
458: ,p_grade_attained in varchar2 default hr_api.g_varchar2

Line 455: ,p_group_ranking in varchar2 default hr_api.g_varchar2

451: Procedure upd_tl
452: (p_language_code in varchar2
453: ,p_qualification_id in number
454: ,p_title in varchar2 default hr_api.g_varchar2
455: ,p_group_ranking in varchar2 default hr_api.g_varchar2
456: ,p_license_restrictions in varchar2 default hr_api.g_varchar2
457: ,p_awarding_body in varchar2 default hr_api.g_varchar2
458: ,p_grade_attained in varchar2 default hr_api.g_varchar2
459: ,p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2

Line 456: ,p_license_restrictions in varchar2 default hr_api.g_varchar2

452: (p_language_code in varchar2
453: ,p_qualification_id in number
454: ,p_title in varchar2 default hr_api.g_varchar2
455: ,p_group_ranking in varchar2 default hr_api.g_varchar2
456: ,p_license_restrictions in varchar2 default hr_api.g_varchar2
457: ,p_awarding_body in varchar2 default hr_api.g_varchar2
458: ,p_grade_attained in varchar2 default hr_api.g_varchar2
459: ,p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2
460: ,p_training_completed_units in varchar2 default hr_api.g_varchar2

Line 457: ,p_awarding_body in varchar2 default hr_api.g_varchar2

453: ,p_qualification_id in number
454: ,p_title in varchar2 default hr_api.g_varchar2
455: ,p_group_ranking in varchar2 default hr_api.g_varchar2
456: ,p_license_restrictions in varchar2 default hr_api.g_varchar2
457: ,p_awarding_body in varchar2 default hr_api.g_varchar2
458: ,p_grade_attained in varchar2 default hr_api.g_varchar2
459: ,p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2
460: ,p_training_completed_units in varchar2 default hr_api.g_varchar2
461: ,p_membership_category in varchar2 default hr_api.g_varchar2

Line 458: ,p_grade_attained in varchar2 default hr_api.g_varchar2

454: ,p_title in varchar2 default hr_api.g_varchar2
455: ,p_group_ranking in varchar2 default hr_api.g_varchar2
456: ,p_license_restrictions in varchar2 default hr_api.g_varchar2
457: ,p_awarding_body in varchar2 default hr_api.g_varchar2
458: ,p_grade_attained in varchar2 default hr_api.g_varchar2
459: ,p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2
460: ,p_training_completed_units in varchar2 default hr_api.g_varchar2
461: ,p_membership_category in varchar2 default hr_api.g_varchar2
462: ) is

Line 459: ,p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2

455: ,p_group_ranking in varchar2 default hr_api.g_varchar2
456: ,p_license_restrictions in varchar2 default hr_api.g_varchar2
457: ,p_awarding_body in varchar2 default hr_api.g_varchar2
458: ,p_grade_attained in varchar2 default hr_api.g_varchar2
459: ,p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2
460: ,p_training_completed_units in varchar2 default hr_api.g_varchar2
461: ,p_membership_category in varchar2 default hr_api.g_varchar2
462: ) is
463: --

Line 460: ,p_training_completed_units in varchar2 default hr_api.g_varchar2

456: ,p_license_restrictions in varchar2 default hr_api.g_varchar2
457: ,p_awarding_body in varchar2 default hr_api.g_varchar2
458: ,p_grade_attained in varchar2 default hr_api.g_varchar2
459: ,p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2
460: ,p_training_completed_units in varchar2 default hr_api.g_varchar2
461: ,p_membership_category in varchar2 default hr_api.g_varchar2
462: ) is
463: --
464: -- Cursor to obtain the translation rows where the language or

Line 461: ,p_membership_category in varchar2 default hr_api.g_varchar2

457: ,p_awarding_body in varchar2 default hr_api.g_varchar2
458: ,p_grade_attained in varchar2 default hr_api.g_varchar2
459: ,p_reimbursement_arrangements in varchar2 default hr_api.g_varchar2
460: ,p_training_completed_units in varchar2 default hr_api.g_varchar2
461: ,p_membership_category in varchar2 default hr_api.g_varchar2
462: ) is
463: --
464: -- Cursor to obtain the translation rows where the language or
465: -- source_lang match the specified language.