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.PQH_CGN_UPD dependencies on HR_API

Line 95: When hr_api.check_integrity_violated Then

91: --
92: hr_utility.set_location(' Leaving:'||l_proc, 10);
93: --
94: Exception
95: When hr_api.check_integrity_violated Then
96: -- A check constraint has been violated
97: --
98: pqh_cgn_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.check_integrity_violated Then
96: -- A check constraint has been violated
97: --
98: pqh_cgn_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.parent_integrity_violated Then
101: -- Parent integrity has been violated
102: --
103: pqh_cgn_shd.constraint_error

Line 100: When hr_api.parent_integrity_violated Then

96: -- A check constraint has been violated
97: --
98: pqh_cgn_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.parent_integrity_violated Then
101: -- Parent integrity has been violated
102: --
103: pqh_cgn_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

100: When hr_api.parent_integrity_violated Then
101: -- Parent integrity has been violated
102: --
103: pqh_cgn_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: --
108: pqh_cgn_shd.constraint_error

Line 105: When hr_api.unique_integrity_violated Then

101: -- Parent integrity has been violated
102: --
103: pqh_cgn_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: --
108: pqh_cgn_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: --
108: pqh_cgn_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When Others Then
111: --
112: Raise;
113: End update_dml;

Line 270: when hr_api.cannot_find_prog_unit then

266: );
267: --
268: exception
269: --
270: when hr_api.cannot_find_prog_unit then
271: --
272: hr_api.cannot_find_prog_unit_error
273: (p_module_name => 'PQH_DE_CASE_GROUPS'
274: ,p_hook_type => 'AU');

Line 272: hr_api.cannot_find_prog_unit_error

268: exception
269: --
270: when hr_api.cannot_find_prog_unit then
271: --
272: hr_api.cannot_find_prog_unit_error
273: (p_module_name => 'PQH_DE_CASE_GROUPS'
274: ,p_hook_type => 'AU');
275: --
276: end;

Line 335: If (p_rec.case_group_number = hr_api.g_varchar2) then

331: -- p_rec plsql record structure
332: -- to see if a system default is being used. If a system default
333: -- is being used then we must set to the 'current' argument value.
334: --
335: If (p_rec.case_group_number = hr_api.g_varchar2) then
336: p_rec.case_group_number :=
337: pqh_cgn_shd.g_old_rec.case_group_number;
338: End If;
339: If (p_rec.description = hr_api.g_varchar2) then

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

335: If (p_rec.case_group_number = hr_api.g_varchar2) then
336: p_rec.case_group_number :=
337: pqh_cgn_shd.g_old_rec.case_group_number;
338: End If;
339: If (p_rec.description = hr_api.g_varchar2) then
340: p_rec.description :=
341: pqh_cgn_shd.g_old_rec.description;
342: End If;
343: If (p_rec.advanced_pay_grade = hr_api.g_number) then

Line 343: If (p_rec.advanced_pay_grade = hr_api.g_number) then

339: If (p_rec.description = hr_api.g_varchar2) then
340: p_rec.description :=
341: pqh_cgn_shd.g_old_rec.description;
342: End If;
343: If (p_rec.advanced_pay_grade = hr_api.g_number) then
344: p_rec.advanced_pay_grade :=
345: pqh_cgn_shd.g_old_rec.advanced_pay_grade;
346: End If;
347: If (p_rec.entries_in_minute = hr_api.g_varchar2) then

Line 347: If (p_rec.entries_in_minute = hr_api.g_varchar2) then

343: If (p_rec.advanced_pay_grade = hr_api.g_number) then
344: p_rec.advanced_pay_grade :=
345: pqh_cgn_shd.g_old_rec.advanced_pay_grade;
346: End If;
347: If (p_rec.entries_in_minute = hr_api.g_varchar2) then
348: p_rec.entries_in_minute :=
349: pqh_cgn_shd.g_old_rec.entries_in_minute;
350: End If;
351: If (p_rec.period_of_prob_advmnt = hr_api.g_number) then

Line 351: If (p_rec.period_of_prob_advmnt = hr_api.g_number) then

347: If (p_rec.entries_in_minute = hr_api.g_varchar2) then
348: p_rec.entries_in_minute :=
349: pqh_cgn_shd.g_old_rec.entries_in_minute;
350: End If;
351: If (p_rec.period_of_prob_advmnt = hr_api.g_number) then
352: p_rec.period_of_prob_advmnt :=
353: pqh_cgn_shd.g_old_rec.period_of_prob_advmnt;
354: End If;
355: If (p_rec.period_of_time_advmnt = hr_api.g_number) then

Line 355: If (p_rec.period_of_time_advmnt = hr_api.g_number) then

351: If (p_rec.period_of_prob_advmnt = hr_api.g_number) then
352: p_rec.period_of_prob_advmnt :=
353: pqh_cgn_shd.g_old_rec.period_of_prob_advmnt;
354: End If;
355: If (p_rec.period_of_time_advmnt = hr_api.g_number) then
356: p_rec.period_of_time_advmnt :=
357: pqh_cgn_shd.g_old_rec.period_of_time_advmnt;
358: End If;
359: If (p_rec.advancement_to = hr_api.g_number) then

Line 359: If (p_rec.advancement_to = hr_api.g_number) then

355: If (p_rec.period_of_time_advmnt = hr_api.g_number) then
356: p_rec.period_of_time_advmnt :=
357: pqh_cgn_shd.g_old_rec.period_of_time_advmnt;
358: End If;
359: If (p_rec.advancement_to = hr_api.g_number) then
360: p_rec.advancement_to :=
361: pqh_cgn_shd.g_old_rec.advancement_to;
362: End If;
363: If (p_rec.advancement_additional_pyt = hr_api.g_number) then

Line 363: If (p_rec.advancement_additional_pyt = hr_api.g_number) then

359: If (p_rec.advancement_to = hr_api.g_number) then
360: p_rec.advancement_to :=
361: pqh_cgn_shd.g_old_rec.advancement_to;
362: End If;
363: If (p_rec.advancement_additional_pyt = hr_api.g_number) then
364: p_rec.advancement_additional_pyt :=
365: pqh_cgn_shd.g_old_rec.advancement_additional_pyt;
366: End If;
367: If (p_rec.time_advanced_pay_grade = hr_api.g_number) then

Line 367: If (p_rec.time_advanced_pay_grade = hr_api.g_number) then

363: If (p_rec.advancement_additional_pyt = hr_api.g_number) then
364: p_rec.advancement_additional_pyt :=
365: pqh_cgn_shd.g_old_rec.advancement_additional_pyt;
366: End If;
367: If (p_rec.time_advanced_pay_grade = hr_api.g_number) then
368: p_rec.time_advanced_pay_grade :=
369: pqh_cgn_shd.g_old_rec.time_advanced_pay_grade;
370: End If;
371: If (p_rec.time_advancement_to = hr_api.g_number) then

Line 371: If (p_rec.time_advancement_to = hr_api.g_number) then

367: If (p_rec.time_advanced_pay_grade = hr_api.g_number) then
368: p_rec.time_advanced_pay_grade :=
369: pqh_cgn_shd.g_old_rec.time_advanced_pay_grade;
370: End If;
371: If (p_rec.time_advancement_to = hr_api.g_number) then
372: p_rec.time_advancement_to :=
373: pqh_cgn_shd.g_old_rec.time_advancement_to;
374: End If;
375: If (p_rec.business_group_id = hr_api.g_number) then

Line 375: If (p_rec.business_group_id = hr_api.g_number) then

371: If (p_rec.time_advancement_to = hr_api.g_number) then
372: p_rec.time_advancement_to :=
373: pqh_cgn_shd.g_old_rec.time_advancement_to;
374: End If;
375: If (p_rec.business_group_id = hr_api.g_number) then
376: p_rec.business_group_id :=
377: pqh_cgn_shd.g_old_rec.business_group_id;
378: End If;
379: If (p_rec.time_advn_units = hr_api.g_varchar2) then

Line 379: If (p_rec.time_advn_units = hr_api.g_varchar2) then

375: If (p_rec.business_group_id = hr_api.g_number) then
376: p_rec.business_group_id :=
377: pqh_cgn_shd.g_old_rec.business_group_id;
378: End If;
379: If (p_rec.time_advn_units = hr_api.g_varchar2) then
380: p_rec.time_advn_units :=
381: pqh_cgn_shd.g_old_rec.time_advn_units;
382: End If;
383: If (p_rec.prob_advn_units = hr_api.g_varchar2) then

Line 383: If (p_rec.prob_advn_units = hr_api.g_varchar2) then

379: If (p_rec.time_advn_units = hr_api.g_varchar2) then
380: p_rec.time_advn_units :=
381: pqh_cgn_shd.g_old_rec.time_advn_units;
382: End If;
383: If (p_rec.prob_advn_units = hr_api.g_varchar2) then
384: p_rec.prob_advn_units :=
385: pqh_cgn_shd.g_old_rec.prob_advn_units;
386: End If;
387: If (p_rec.sub_csgrp_description = hr_api.g_varchar2) then

Line 387: If (p_rec.sub_csgrp_description = hr_api.g_varchar2) then

383: If (p_rec.prob_advn_units = hr_api.g_varchar2) then
384: p_rec.prob_advn_units :=
385: pqh_cgn_shd.g_old_rec.prob_advn_units;
386: End If;
387: If (p_rec.sub_csgrp_description = hr_api.g_varchar2) then
388: p_rec.sub_csgrp_description :=
389: pqh_cgn_shd.g_old_rec.sub_csgrp_description;
390: End If;
391: --

Line 458: ,p_case_group_number in varchar2 default hr_api.g_varchar2

454: Procedure upd
455: (p_effective_date in date
456: ,p_case_group_id in number
457: ,p_object_version_number in out nocopy number
458: ,p_case_group_number in varchar2 default hr_api.g_varchar2
459: ,p_description in varchar2 default hr_api.g_varchar2
460: ,p_advanced_pay_grade in number default hr_api.g_number
461: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
462: ,p_period_of_prob_advmnt in number default hr_api.g_number

Line 459: ,p_description in varchar2 default hr_api.g_varchar2

455: (p_effective_date in date
456: ,p_case_group_id in number
457: ,p_object_version_number in out nocopy number
458: ,p_case_group_number in varchar2 default hr_api.g_varchar2
459: ,p_description in varchar2 default hr_api.g_varchar2
460: ,p_advanced_pay_grade in number default hr_api.g_number
461: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
462: ,p_period_of_prob_advmnt in number default hr_api.g_number
463: ,p_period_of_time_advmnt in number default hr_api.g_number

Line 460: ,p_advanced_pay_grade in number default hr_api.g_number

456: ,p_case_group_id in number
457: ,p_object_version_number in out nocopy number
458: ,p_case_group_number in varchar2 default hr_api.g_varchar2
459: ,p_description in varchar2 default hr_api.g_varchar2
460: ,p_advanced_pay_grade in number default hr_api.g_number
461: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
462: ,p_period_of_prob_advmnt in number default hr_api.g_number
463: ,p_period_of_time_advmnt in number default hr_api.g_number
464: ,p_advancement_to in number default hr_api.g_number

Line 461: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2

457: ,p_object_version_number in out nocopy number
458: ,p_case_group_number in varchar2 default hr_api.g_varchar2
459: ,p_description in varchar2 default hr_api.g_varchar2
460: ,p_advanced_pay_grade in number default hr_api.g_number
461: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
462: ,p_period_of_prob_advmnt in number default hr_api.g_number
463: ,p_period_of_time_advmnt in number default hr_api.g_number
464: ,p_advancement_to in number default hr_api.g_number
465: ,p_advancement_additional_pyt in number default hr_api.g_number

Line 462: ,p_period_of_prob_advmnt in number default hr_api.g_number

458: ,p_case_group_number in varchar2 default hr_api.g_varchar2
459: ,p_description in varchar2 default hr_api.g_varchar2
460: ,p_advanced_pay_grade in number default hr_api.g_number
461: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
462: ,p_period_of_prob_advmnt in number default hr_api.g_number
463: ,p_period_of_time_advmnt in number default hr_api.g_number
464: ,p_advancement_to in number default hr_api.g_number
465: ,p_advancement_additional_pyt in number default hr_api.g_number
466: ,p_time_advanced_pay_grade in number default hr_api.g_number

Line 463: ,p_period_of_time_advmnt in number default hr_api.g_number

459: ,p_description in varchar2 default hr_api.g_varchar2
460: ,p_advanced_pay_grade in number default hr_api.g_number
461: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
462: ,p_period_of_prob_advmnt in number default hr_api.g_number
463: ,p_period_of_time_advmnt in number default hr_api.g_number
464: ,p_advancement_to in number default hr_api.g_number
465: ,p_advancement_additional_pyt in number default hr_api.g_number
466: ,p_time_advanced_pay_grade in number default hr_api.g_number
467: ,p_time_advancement_to in number default hr_api.g_number

Line 464: ,p_advancement_to in number default hr_api.g_number

460: ,p_advanced_pay_grade in number default hr_api.g_number
461: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
462: ,p_period_of_prob_advmnt in number default hr_api.g_number
463: ,p_period_of_time_advmnt in number default hr_api.g_number
464: ,p_advancement_to in number default hr_api.g_number
465: ,p_advancement_additional_pyt in number default hr_api.g_number
466: ,p_time_advanced_pay_grade in number default hr_api.g_number
467: ,p_time_advancement_to in number default hr_api.g_number
468: ,p_business_group_id in number default hr_api.g_number

Line 465: ,p_advancement_additional_pyt in number default hr_api.g_number

461: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
462: ,p_period_of_prob_advmnt in number default hr_api.g_number
463: ,p_period_of_time_advmnt in number default hr_api.g_number
464: ,p_advancement_to in number default hr_api.g_number
465: ,p_advancement_additional_pyt in number default hr_api.g_number
466: ,p_time_advanced_pay_grade in number default hr_api.g_number
467: ,p_time_advancement_to in number default hr_api.g_number
468: ,p_business_group_id in number default hr_api.g_number
469: ,p_time_advn_units in varchar2 default hr_api.g_varchar2

Line 466: ,p_time_advanced_pay_grade in number default hr_api.g_number

462: ,p_period_of_prob_advmnt in number default hr_api.g_number
463: ,p_period_of_time_advmnt in number default hr_api.g_number
464: ,p_advancement_to in number default hr_api.g_number
465: ,p_advancement_additional_pyt in number default hr_api.g_number
466: ,p_time_advanced_pay_grade in number default hr_api.g_number
467: ,p_time_advancement_to in number default hr_api.g_number
468: ,p_business_group_id in number default hr_api.g_number
469: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
470: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2

Line 467: ,p_time_advancement_to in number default hr_api.g_number

463: ,p_period_of_time_advmnt in number default hr_api.g_number
464: ,p_advancement_to in number default hr_api.g_number
465: ,p_advancement_additional_pyt in number default hr_api.g_number
466: ,p_time_advanced_pay_grade in number default hr_api.g_number
467: ,p_time_advancement_to in number default hr_api.g_number
468: ,p_business_group_id in number default hr_api.g_number
469: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
470: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2
471: ,p_sub_csgrp_description in varchar2 default hr_api.g_varchar2

Line 468: ,p_business_group_id in number default hr_api.g_number

464: ,p_advancement_to in number default hr_api.g_number
465: ,p_advancement_additional_pyt in number default hr_api.g_number
466: ,p_time_advanced_pay_grade in number default hr_api.g_number
467: ,p_time_advancement_to in number default hr_api.g_number
468: ,p_business_group_id in number default hr_api.g_number
469: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
470: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2
471: ,p_sub_csgrp_description in varchar2 default hr_api.g_varchar2
472: ) is

Line 469: ,p_time_advn_units in varchar2 default hr_api.g_varchar2

465: ,p_advancement_additional_pyt in number default hr_api.g_number
466: ,p_time_advanced_pay_grade in number default hr_api.g_number
467: ,p_time_advancement_to in number default hr_api.g_number
468: ,p_business_group_id in number default hr_api.g_number
469: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
470: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2
471: ,p_sub_csgrp_description in varchar2 default hr_api.g_varchar2
472: ) is
473: --

Line 470: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2

466: ,p_time_advanced_pay_grade in number default hr_api.g_number
467: ,p_time_advancement_to in number default hr_api.g_number
468: ,p_business_group_id in number default hr_api.g_number
469: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
470: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2
471: ,p_sub_csgrp_description in varchar2 default hr_api.g_varchar2
472: ) is
473: --
474: l_rec pqh_cgn_shd.g_rec_type;

Line 471: ,p_sub_csgrp_description in varchar2 default hr_api.g_varchar2

467: ,p_time_advancement_to in number default hr_api.g_number
468: ,p_business_group_id in number default hr_api.g_number
469: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
470: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2
471: ,p_sub_csgrp_description in varchar2 default hr_api.g_varchar2
472: ) is
473: --
474: l_rec pqh_cgn_shd.g_rec_type;
475: l_proc varchar2(72) := g_package||'upd';