APPS.PQH_STS_UPD dependencies on HR_API

Line 121: When hr_api.check_integrity_violated Then

117: --
118: End if;
119: --
120: Exception
121: When hr_api.check_integrity_violated Then
122: -- A check constraint has been violated
123: --
124: pqh_sts_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

121: When hr_api.check_integrity_violated Then
122: -- A check constraint has been violated
123: --
124: pqh_sts_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: --
129: pqh_sts_shd.constraint_error

Line 126: When hr_api.parent_integrity_violated Then

122: -- A check constraint has been violated
123: --
124: pqh_sts_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: --
129: pqh_sts_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: --
129: pqh_sts_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.unique_integrity_violated Then
132: -- Unique integrity has been violated
133: --
134: pqh_sts_shd.constraint_error

Line 131: When hr_api.unique_integrity_violated Then

127: -- Parent integrity has been violated
128: --
129: pqh_sts_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.unique_integrity_violated Then
132: -- Unique integrity has been violated
133: --
134: pqh_sts_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

131: When hr_api.unique_integrity_violated Then
132: -- Unique integrity has been violated
133: --
134: pqh_sts_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When Others Then
137: --
138: Raise;
139: End update_dml;

Line 372: when hr_api.cannot_find_prog_unit then

368: );
369: --
370: exception
371: --
372: when hr_api.cannot_find_prog_unit then
373: --
374: hr_api.cannot_find_prog_unit_error
375: (p_module_name => 'PQH_FR_STAT_SITUATIONS'
376: ,p_hook_type => 'AU');

Line 374: hr_api.cannot_find_prog_unit_error

370: exception
371: --
372: when hr_api.cannot_find_prog_unit then
373: --
374: hr_api.cannot_find_prog_unit_error
375: (p_module_name => 'PQH_FR_STAT_SITUATIONS'
376: ,p_hook_type => 'AU');
377: --
378: end;

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

438: -- p_rec plsql record structure
439: -- to see if a system default is being used. If a system default
440: -- is being used then we must set to the 'current' argument value.
441: --
442: If (p_rec.business_group_id = hr_api.g_number) then
443: p_rec.business_group_id :=
444: pqh_sts_shd.g_old_rec.business_group_id;
445: End If;
446: If (p_rec.situation_name = hr_api.g_varchar2) then

Line 446: If (p_rec.situation_name = hr_api.g_varchar2) then

442: If (p_rec.business_group_id = hr_api.g_number) then
443: p_rec.business_group_id :=
444: pqh_sts_shd.g_old_rec.business_group_id;
445: End If;
446: If (p_rec.situation_name = hr_api.g_varchar2) then
447: p_rec.situation_name :=
448: pqh_sts_shd.g_old_rec.situation_name;
449: End If;
450: If (p_rec.type_of_ps = hr_api.g_varchar2) then

Line 450: If (p_rec.type_of_ps = hr_api.g_varchar2) then

446: If (p_rec.situation_name = hr_api.g_varchar2) then
447: p_rec.situation_name :=
448: pqh_sts_shd.g_old_rec.situation_name;
449: End If;
450: If (p_rec.type_of_ps = hr_api.g_varchar2) then
451: p_rec.type_of_ps :=
452: pqh_sts_shd.g_old_rec.type_of_ps;
453: End If;
454: If (p_rec.situation_type = hr_api.g_varchar2) then

Line 454: If (p_rec.situation_type = hr_api.g_varchar2) then

450: If (p_rec.type_of_ps = hr_api.g_varchar2) then
451: p_rec.type_of_ps :=
452: pqh_sts_shd.g_old_rec.type_of_ps;
453: End If;
454: If (p_rec.situation_type = hr_api.g_varchar2) then
455: p_rec.situation_type :=
456: pqh_sts_shd.g_old_rec.situation_type;
457: End If;
458: If (p_rec.sub_type = hr_api.g_varchar2) then

Line 458: If (p_rec.sub_type = hr_api.g_varchar2) then

454: If (p_rec.situation_type = hr_api.g_varchar2) then
455: p_rec.situation_type :=
456: pqh_sts_shd.g_old_rec.situation_type;
457: End If;
458: If (p_rec.sub_type = hr_api.g_varchar2) then
459: p_rec.sub_type :=
460: pqh_sts_shd.g_old_rec.sub_type;
461: End If;
462: If (p_rec.source = hr_api.g_varchar2) then

Line 462: If (p_rec.source = hr_api.g_varchar2) then

458: If (p_rec.sub_type = hr_api.g_varchar2) then
459: p_rec.sub_type :=
460: pqh_sts_shd.g_old_rec.sub_type;
461: End If;
462: If (p_rec.source = hr_api.g_varchar2) then
463: p_rec.source :=
464: pqh_sts_shd.g_old_rec.source;
465: End If;
466: If (p_rec.location = hr_api.g_varchar2) then

Line 466: If (p_rec.location = hr_api.g_varchar2) then

462: If (p_rec.source = hr_api.g_varchar2) then
463: p_rec.source :=
464: pqh_sts_shd.g_old_rec.source;
465: End If;
466: If (p_rec.location = hr_api.g_varchar2) then
467: p_rec.location :=
468: pqh_sts_shd.g_old_rec.location;
469: End If;
470: If (p_rec.reason = hr_api.g_varchar2) then

Line 470: If (p_rec.reason = hr_api.g_varchar2) then

466: If (p_rec.location = hr_api.g_varchar2) then
467: p_rec.location :=
468: pqh_sts_shd.g_old_rec.location;
469: End If;
470: If (p_rec.reason = hr_api.g_varchar2) then
471: p_rec.reason :=
472: pqh_sts_shd.g_old_rec.reason;
473: End If;
474: If (p_rec.is_default = hr_api.g_varchar2) then

Line 474: If (p_rec.is_default = hr_api.g_varchar2) then

470: If (p_rec.reason = hr_api.g_varchar2) then
471: p_rec.reason :=
472: pqh_sts_shd.g_old_rec.reason;
473: End If;
474: If (p_rec.is_default = hr_api.g_varchar2) then
475: p_rec.is_default :=
476: pqh_sts_shd.g_old_rec.is_default;
477: End If;
478: If (p_rec.date_from = hr_api.g_date) then

Line 478: If (p_rec.date_from = hr_api.g_date) then

474: If (p_rec.is_default = hr_api.g_varchar2) then
475: p_rec.is_default :=
476: pqh_sts_shd.g_old_rec.is_default;
477: End If;
478: If (p_rec.date_from = hr_api.g_date) then
479: p_rec.date_from :=
480: pqh_sts_shd.g_old_rec.date_from;
481: End If;
482: If (p_rec.date_to = hr_api.g_date) then

Line 482: If (p_rec.date_to = hr_api.g_date) then

478: If (p_rec.date_from = hr_api.g_date) then
479: p_rec.date_from :=
480: pqh_sts_shd.g_old_rec.date_from;
481: End If;
482: If (p_rec.date_to = hr_api.g_date) then
483: p_rec.date_to :=
484: pqh_sts_shd.g_old_rec.date_to;
485: End If;
486: If (p_rec.request_type = hr_api.g_varchar2) then

Line 486: If (p_rec.request_type = hr_api.g_varchar2) then

482: If (p_rec.date_to = hr_api.g_date) then
483: p_rec.date_to :=
484: pqh_sts_shd.g_old_rec.date_to;
485: End If;
486: If (p_rec.request_type = hr_api.g_varchar2) then
487: p_rec.request_type :=
488: pqh_sts_shd.g_old_rec.request_type;
489: End If;
490: If (p_rec.employee_agreement_needed = hr_api.g_varchar2) then

Line 490: If (p_rec.employee_agreement_needed = hr_api.g_varchar2) then

486: If (p_rec.request_type = hr_api.g_varchar2) then
487: p_rec.request_type :=
488: pqh_sts_shd.g_old_rec.request_type;
489: End If;
490: If (p_rec.employee_agreement_needed = hr_api.g_varchar2) then
491: p_rec.employee_agreement_needed :=
492: pqh_sts_shd.g_old_rec.employee_agreement_needed;
493: End If;
494: If (p_rec.manager_agreement_needed = hr_api.g_varchar2) then

Line 494: If (p_rec.manager_agreement_needed = hr_api.g_varchar2) then

490: If (p_rec.employee_agreement_needed = hr_api.g_varchar2) then
491: p_rec.employee_agreement_needed :=
492: pqh_sts_shd.g_old_rec.employee_agreement_needed;
493: End If;
494: If (p_rec.manager_agreement_needed = hr_api.g_varchar2) then
495: p_rec.manager_agreement_needed :=
496: pqh_sts_shd.g_old_rec.manager_agreement_needed;
497: End If;
498: If (p_rec.print_arrette = hr_api.g_varchar2) then

Line 498: If (p_rec.print_arrette = hr_api.g_varchar2) then

494: If (p_rec.manager_agreement_needed = hr_api.g_varchar2) then
495: p_rec.manager_agreement_needed :=
496: pqh_sts_shd.g_old_rec.manager_agreement_needed;
497: End If;
498: If (p_rec.print_arrette = hr_api.g_varchar2) then
499: p_rec.print_arrette :=
500: pqh_sts_shd.g_old_rec.print_arrette;
501: End If;
502: If (p_rec.reserve_position = hr_api.g_varchar2) then

Line 502: If (p_rec.reserve_position = hr_api.g_varchar2) then

498: If (p_rec.print_arrette = hr_api.g_varchar2) then
499: p_rec.print_arrette :=
500: pqh_sts_shd.g_old_rec.print_arrette;
501: End If;
502: If (p_rec.reserve_position = hr_api.g_varchar2) then
503: p_rec.reserve_position :=
504: pqh_sts_shd.g_old_rec.reserve_position;
505: End If;
506: If (p_rec.allow_progressions = hr_api.g_varchar2) then

Line 506: If (p_rec.allow_progressions = hr_api.g_varchar2) then

502: If (p_rec.reserve_position = hr_api.g_varchar2) then
503: p_rec.reserve_position :=
504: pqh_sts_shd.g_old_rec.reserve_position;
505: End If;
506: If (p_rec.allow_progressions = hr_api.g_varchar2) then
507: p_rec.allow_progressions :=
508: pqh_sts_shd.g_old_rec.reserve_position;
509: End If;
510: If (p_rec.extend_probation_period = hr_api.g_varchar2) then

Line 510: If (p_rec.extend_probation_period = hr_api.g_varchar2) then

506: If (p_rec.allow_progressions = hr_api.g_varchar2) then
507: p_rec.allow_progressions :=
508: pqh_sts_shd.g_old_rec.reserve_position;
509: End If;
510: If (p_rec.extend_probation_period = hr_api.g_varchar2) then
511: p_rec.extend_probation_period :=
512: pqh_sts_shd.g_old_rec.reserve_position;
513: End If;
514: If (p_rec.remuneration_paid = hr_api.g_varchar2) then

Line 514: If (p_rec.remuneration_paid = hr_api.g_varchar2) then

510: If (p_rec.extend_probation_period = hr_api.g_varchar2) then
511: p_rec.extend_probation_period :=
512: pqh_sts_shd.g_old_rec.reserve_position;
513: End If;
514: If (p_rec.remuneration_paid = hr_api.g_varchar2) then
515: p_rec.remuneration_paid :=
516: pqh_sts_shd.g_old_rec.remuneration_paid;
517: End If;
518: If (p_rec.pay_share = hr_api.g_number) then

Line 518: If (p_rec.pay_share = hr_api.g_number) then

514: If (p_rec.remuneration_paid = hr_api.g_varchar2) then
515: p_rec.remuneration_paid :=
516: pqh_sts_shd.g_old_rec.remuneration_paid;
517: End If;
518: If (p_rec.pay_share = hr_api.g_number) then
519: p_rec.pay_share :=
520: pqh_sts_shd.g_old_rec.pay_share;
521: End If;
522: If (p_rec.pay_periods = hr_api.g_number) then

Line 522: If (p_rec.pay_periods = hr_api.g_number) then

518: If (p_rec.pay_share = hr_api.g_number) then
519: p_rec.pay_share :=
520: pqh_sts_shd.g_old_rec.pay_share;
521: End If;
522: If (p_rec.pay_periods = hr_api.g_number) then
523: p_rec.pay_periods :=
524: pqh_sts_shd.g_old_rec.pay_periods;
525: End If;
526: If (p_rec.frequency = hr_api.g_varchar2) then

Line 526: If (p_rec.frequency = hr_api.g_varchar2) then

522: If (p_rec.pay_periods = hr_api.g_number) then
523: p_rec.pay_periods :=
524: pqh_sts_shd.g_old_rec.pay_periods;
525: End If;
526: If (p_rec.frequency = hr_api.g_varchar2) then
527: p_rec.frequency :=
528: pqh_sts_shd.g_old_rec.frequency;
529: End If;
530: If (p_rec.first_period_max_duration = hr_api.g_number) then

Line 530: If (p_rec.first_period_max_duration = hr_api.g_number) then

526: If (p_rec.frequency = hr_api.g_varchar2) then
527: p_rec.frequency :=
528: pqh_sts_shd.g_old_rec.frequency;
529: End If;
530: If (p_rec.first_period_max_duration = hr_api.g_number) then
531: p_rec.first_period_max_duration :=
532: pqh_sts_shd.g_old_rec.first_period_max_duration;
533: End If;
534: If (p_rec.min_duration_per_request = hr_api.g_number) then

Line 534: If (p_rec.min_duration_per_request = hr_api.g_number) then

530: If (p_rec.first_period_max_duration = hr_api.g_number) then
531: p_rec.first_period_max_duration :=
532: pqh_sts_shd.g_old_rec.first_period_max_duration;
533: End If;
534: If (p_rec.min_duration_per_request = hr_api.g_number) then
535: p_rec.min_duration_per_request :=
536: pqh_sts_shd.g_old_rec.min_duration_per_request;
537: End If;
538: If (p_rec.max_duration_per_request = hr_api.g_number) then

Line 538: If (p_rec.max_duration_per_request = hr_api.g_number) then

534: If (p_rec.min_duration_per_request = hr_api.g_number) then
535: p_rec.min_duration_per_request :=
536: pqh_sts_shd.g_old_rec.min_duration_per_request;
537: End If;
538: If (p_rec.max_duration_per_request = hr_api.g_number) then
539: p_rec.max_duration_per_request :=
540: pqh_sts_shd.g_old_rec.max_duration_per_request;
541: End If;
542: If (p_rec.max_duration_whole_career = hr_api.g_number) then

Line 542: If (p_rec.max_duration_whole_career = hr_api.g_number) then

538: If (p_rec.max_duration_per_request = hr_api.g_number) then
539: p_rec.max_duration_per_request :=
540: pqh_sts_shd.g_old_rec.max_duration_per_request;
541: End If;
542: If (p_rec.max_duration_whole_career = hr_api.g_number) then
543: p_rec.max_duration_whole_career :=
544: pqh_sts_shd.g_old_rec.max_duration_whole_career;
545: End If;
546: If (p_rec.renewable_allowed = hr_api.g_varchar2) then

Line 546: If (p_rec.renewable_allowed = hr_api.g_varchar2) then

542: If (p_rec.max_duration_whole_career = hr_api.g_number) then
543: p_rec.max_duration_whole_career :=
544: pqh_sts_shd.g_old_rec.max_duration_whole_career;
545: End If;
546: If (p_rec.renewable_allowed = hr_api.g_varchar2) then
547: p_rec.renewable_allowed :=
548: pqh_sts_shd.g_old_rec.renewable_allowed;
549: End If;
550: If (p_rec.max_no_of_renewals = hr_api.g_number) then

Line 550: If (p_rec.max_no_of_renewals = hr_api.g_number) then

546: If (p_rec.renewable_allowed = hr_api.g_varchar2) then
547: p_rec.renewable_allowed :=
548: pqh_sts_shd.g_old_rec.renewable_allowed;
549: End If;
550: If (p_rec.max_no_of_renewals = hr_api.g_number) then
551: p_rec.max_no_of_renewals :=
552: pqh_sts_shd.g_old_rec.max_no_of_renewals;
553: End If;
554: If (p_rec.max_duration_per_renewal = hr_api.g_number) then

Line 554: If (p_rec.max_duration_per_renewal = hr_api.g_number) then

550: If (p_rec.max_no_of_renewals = hr_api.g_number) then
551: p_rec.max_no_of_renewals :=
552: pqh_sts_shd.g_old_rec.max_no_of_renewals;
553: End If;
554: If (p_rec.max_duration_per_renewal = hr_api.g_number) then
555: p_rec.max_duration_per_renewal :=
556: pqh_sts_shd.g_old_rec.max_duration_per_renewal;
557: End If;
558: If (p_rec.max_tot_continuous_duration = hr_api.g_number) then

Line 558: If (p_rec.max_tot_continuous_duration = hr_api.g_number) then

554: If (p_rec.max_duration_per_renewal = hr_api.g_number) then
555: p_rec.max_duration_per_renewal :=
556: pqh_sts_shd.g_old_rec.max_duration_per_renewal;
557: End If;
558: If (p_rec.max_tot_continuous_duration = hr_api.g_number) then
559: p_rec.max_tot_continuous_duration :=
560: pqh_sts_shd.g_old_rec.max_tot_continuous_duration;
561: End If;
562: If (p_rec.remunerate_assign_status_id = hr_api.g_number) then

Line 562: If (p_rec.remunerate_assign_status_id = hr_api.g_number) then

558: If (p_rec.max_tot_continuous_duration = hr_api.g_number) then
559: p_rec.max_tot_continuous_duration :=
560: pqh_sts_shd.g_old_rec.max_tot_continuous_duration;
561: End If;
562: If (p_rec.remunerate_assign_status_id = hr_api.g_number) then
563: p_rec.remunerate_assign_status_id :=
564: pqh_sts_shd.g_old_rec.remunerate_assign_status_id;
565: End If;
566: --

Line 637: ,p_business_group_id in number default hr_api.g_number

633: Procedure upd
634: (p_effective_date in date
635: ,p_statutory_situation_id in number
636: ,p_object_version_number in out nocopy number
637: ,p_business_group_id in number default hr_api.g_number
638: ,p_situation_name in varchar2 default hr_api.g_varchar2
639: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
640: ,p_situation_type in varchar2 default hr_api.g_varchar2
641: ,p_sub_type in varchar2 default hr_api.g_varchar2

Line 638: ,p_situation_name in varchar2 default hr_api.g_varchar2

634: (p_effective_date in date
635: ,p_statutory_situation_id in number
636: ,p_object_version_number in out nocopy number
637: ,p_business_group_id in number default hr_api.g_number
638: ,p_situation_name in varchar2 default hr_api.g_varchar2
639: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
640: ,p_situation_type in varchar2 default hr_api.g_varchar2
641: ,p_sub_type in varchar2 default hr_api.g_varchar2
642: ,p_source in varchar2 default hr_api.g_varchar2

Line 639: ,p_type_of_ps in varchar2 default hr_api.g_varchar2

635: ,p_statutory_situation_id in number
636: ,p_object_version_number in out nocopy number
637: ,p_business_group_id in number default hr_api.g_number
638: ,p_situation_name in varchar2 default hr_api.g_varchar2
639: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
640: ,p_situation_type in varchar2 default hr_api.g_varchar2
641: ,p_sub_type in varchar2 default hr_api.g_varchar2
642: ,p_source in varchar2 default hr_api.g_varchar2
643: ,p_location in varchar2 default hr_api.g_varchar2

Line 640: ,p_situation_type in varchar2 default hr_api.g_varchar2

636: ,p_object_version_number in out nocopy number
637: ,p_business_group_id in number default hr_api.g_number
638: ,p_situation_name in varchar2 default hr_api.g_varchar2
639: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
640: ,p_situation_type in varchar2 default hr_api.g_varchar2
641: ,p_sub_type in varchar2 default hr_api.g_varchar2
642: ,p_source in varchar2 default hr_api.g_varchar2
643: ,p_location in varchar2 default hr_api.g_varchar2
644: ,p_reason in varchar2 default hr_api.g_varchar2

Line 641: ,p_sub_type in varchar2 default hr_api.g_varchar2

637: ,p_business_group_id in number default hr_api.g_number
638: ,p_situation_name in varchar2 default hr_api.g_varchar2
639: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
640: ,p_situation_type in varchar2 default hr_api.g_varchar2
641: ,p_sub_type in varchar2 default hr_api.g_varchar2
642: ,p_source in varchar2 default hr_api.g_varchar2
643: ,p_location in varchar2 default hr_api.g_varchar2
644: ,p_reason in varchar2 default hr_api.g_varchar2
645: ,p_is_default in varchar2 default hr_api.g_varchar2

Line 642: ,p_source in varchar2 default hr_api.g_varchar2

638: ,p_situation_name in varchar2 default hr_api.g_varchar2
639: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
640: ,p_situation_type in varchar2 default hr_api.g_varchar2
641: ,p_sub_type in varchar2 default hr_api.g_varchar2
642: ,p_source in varchar2 default hr_api.g_varchar2
643: ,p_location in varchar2 default hr_api.g_varchar2
644: ,p_reason in varchar2 default hr_api.g_varchar2
645: ,p_is_default in varchar2 default hr_api.g_varchar2
646: ,p_date_from in date default hr_api.g_date

Line 643: ,p_location in varchar2 default hr_api.g_varchar2

639: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
640: ,p_situation_type in varchar2 default hr_api.g_varchar2
641: ,p_sub_type in varchar2 default hr_api.g_varchar2
642: ,p_source in varchar2 default hr_api.g_varchar2
643: ,p_location in varchar2 default hr_api.g_varchar2
644: ,p_reason in varchar2 default hr_api.g_varchar2
645: ,p_is_default in varchar2 default hr_api.g_varchar2
646: ,p_date_from in date default hr_api.g_date
647: ,p_date_to in date default hr_api.g_date

Line 644: ,p_reason in varchar2 default hr_api.g_varchar2

640: ,p_situation_type in varchar2 default hr_api.g_varchar2
641: ,p_sub_type in varchar2 default hr_api.g_varchar2
642: ,p_source in varchar2 default hr_api.g_varchar2
643: ,p_location in varchar2 default hr_api.g_varchar2
644: ,p_reason in varchar2 default hr_api.g_varchar2
645: ,p_is_default in varchar2 default hr_api.g_varchar2
646: ,p_date_from in date default hr_api.g_date
647: ,p_date_to in date default hr_api.g_date
648: ,p_request_type in varchar2 default hr_api.g_varchar2

Line 645: ,p_is_default in varchar2 default hr_api.g_varchar2

641: ,p_sub_type in varchar2 default hr_api.g_varchar2
642: ,p_source in varchar2 default hr_api.g_varchar2
643: ,p_location in varchar2 default hr_api.g_varchar2
644: ,p_reason in varchar2 default hr_api.g_varchar2
645: ,p_is_default in varchar2 default hr_api.g_varchar2
646: ,p_date_from in date default hr_api.g_date
647: ,p_date_to in date default hr_api.g_date
648: ,p_request_type in varchar2 default hr_api.g_varchar2
649: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2

Line 646: ,p_date_from in date default hr_api.g_date

642: ,p_source in varchar2 default hr_api.g_varchar2
643: ,p_location in varchar2 default hr_api.g_varchar2
644: ,p_reason in varchar2 default hr_api.g_varchar2
645: ,p_is_default in varchar2 default hr_api.g_varchar2
646: ,p_date_from in date default hr_api.g_date
647: ,p_date_to in date default hr_api.g_date
648: ,p_request_type in varchar2 default hr_api.g_varchar2
649: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
650: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2

Line 647: ,p_date_to in date default hr_api.g_date

643: ,p_location in varchar2 default hr_api.g_varchar2
644: ,p_reason in varchar2 default hr_api.g_varchar2
645: ,p_is_default in varchar2 default hr_api.g_varchar2
646: ,p_date_from in date default hr_api.g_date
647: ,p_date_to in date default hr_api.g_date
648: ,p_request_type in varchar2 default hr_api.g_varchar2
649: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
650: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
651: ,p_print_arrette in varchar2 default hr_api.g_varchar2

Line 648: ,p_request_type in varchar2 default hr_api.g_varchar2

644: ,p_reason in varchar2 default hr_api.g_varchar2
645: ,p_is_default in varchar2 default hr_api.g_varchar2
646: ,p_date_from in date default hr_api.g_date
647: ,p_date_to in date default hr_api.g_date
648: ,p_request_type in varchar2 default hr_api.g_varchar2
649: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
650: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
651: ,p_print_arrette in varchar2 default hr_api.g_varchar2
652: ,p_reserve_position in varchar2 default hr_api.g_varchar2

Line 649: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2

645: ,p_is_default in varchar2 default hr_api.g_varchar2
646: ,p_date_from in date default hr_api.g_date
647: ,p_date_to in date default hr_api.g_date
648: ,p_request_type in varchar2 default hr_api.g_varchar2
649: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
650: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
651: ,p_print_arrette in varchar2 default hr_api.g_varchar2
652: ,p_reserve_position in varchar2 default hr_api.g_varchar2
653: ,p_allow_progressions in varchar2 default hr_api.g_varchar2

Line 650: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2

646: ,p_date_from in date default hr_api.g_date
647: ,p_date_to in date default hr_api.g_date
648: ,p_request_type in varchar2 default hr_api.g_varchar2
649: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
650: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
651: ,p_print_arrette in varchar2 default hr_api.g_varchar2
652: ,p_reserve_position in varchar2 default hr_api.g_varchar2
653: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
654: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2

Line 651: ,p_print_arrette in varchar2 default hr_api.g_varchar2

647: ,p_date_to in date default hr_api.g_date
648: ,p_request_type in varchar2 default hr_api.g_varchar2
649: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
650: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
651: ,p_print_arrette in varchar2 default hr_api.g_varchar2
652: ,p_reserve_position in varchar2 default hr_api.g_varchar2
653: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
654: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
655: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2

Line 652: ,p_reserve_position in varchar2 default hr_api.g_varchar2

648: ,p_request_type in varchar2 default hr_api.g_varchar2
649: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
650: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
651: ,p_print_arrette in varchar2 default hr_api.g_varchar2
652: ,p_reserve_position in varchar2 default hr_api.g_varchar2
653: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
654: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
655: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
656: ,p_pay_share in number default hr_api.g_number

Line 653: ,p_allow_progressions in varchar2 default hr_api.g_varchar2

649: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
650: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
651: ,p_print_arrette in varchar2 default hr_api.g_varchar2
652: ,p_reserve_position in varchar2 default hr_api.g_varchar2
653: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
654: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
655: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
656: ,p_pay_share in number default hr_api.g_number
657: ,p_pay_periods in number default hr_api.g_number

Line 654: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2

650: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
651: ,p_print_arrette in varchar2 default hr_api.g_varchar2
652: ,p_reserve_position in varchar2 default hr_api.g_varchar2
653: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
654: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
655: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
656: ,p_pay_share in number default hr_api.g_number
657: ,p_pay_periods in number default hr_api.g_number
658: ,p_frequency in varchar2 default hr_api.g_varchar2

Line 655: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2

651: ,p_print_arrette in varchar2 default hr_api.g_varchar2
652: ,p_reserve_position in varchar2 default hr_api.g_varchar2
653: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
654: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
655: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
656: ,p_pay_share in number default hr_api.g_number
657: ,p_pay_periods in number default hr_api.g_number
658: ,p_frequency in varchar2 default hr_api.g_varchar2
659: ,p_first_period_max_duration in number default hr_api.g_number

Line 656: ,p_pay_share in number default hr_api.g_number

652: ,p_reserve_position in varchar2 default hr_api.g_varchar2
653: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
654: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
655: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
656: ,p_pay_share in number default hr_api.g_number
657: ,p_pay_periods in number default hr_api.g_number
658: ,p_frequency in varchar2 default hr_api.g_varchar2
659: ,p_first_period_max_duration in number default hr_api.g_number
660: ,p_min_duration_per_request in number default hr_api.g_number

Line 657: ,p_pay_periods in number default hr_api.g_number

653: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
654: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
655: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
656: ,p_pay_share in number default hr_api.g_number
657: ,p_pay_periods in number default hr_api.g_number
658: ,p_frequency in varchar2 default hr_api.g_varchar2
659: ,p_first_period_max_duration in number default hr_api.g_number
660: ,p_min_duration_per_request in number default hr_api.g_number
661: ,p_max_duration_per_request in number default hr_api.g_number

Line 658: ,p_frequency in varchar2 default hr_api.g_varchar2

654: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
655: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
656: ,p_pay_share in number default hr_api.g_number
657: ,p_pay_periods in number default hr_api.g_number
658: ,p_frequency in varchar2 default hr_api.g_varchar2
659: ,p_first_period_max_duration in number default hr_api.g_number
660: ,p_min_duration_per_request in number default hr_api.g_number
661: ,p_max_duration_per_request in number default hr_api.g_number
662: ,p_max_duration_whole_career in number default hr_api.g_number

Line 659: ,p_first_period_max_duration in number default hr_api.g_number

655: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
656: ,p_pay_share in number default hr_api.g_number
657: ,p_pay_periods in number default hr_api.g_number
658: ,p_frequency in varchar2 default hr_api.g_varchar2
659: ,p_first_period_max_duration in number default hr_api.g_number
660: ,p_min_duration_per_request in number default hr_api.g_number
661: ,p_max_duration_per_request in number default hr_api.g_number
662: ,p_max_duration_whole_career in number default hr_api.g_number
663: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2

Line 660: ,p_min_duration_per_request in number default hr_api.g_number

656: ,p_pay_share in number default hr_api.g_number
657: ,p_pay_periods in number default hr_api.g_number
658: ,p_frequency in varchar2 default hr_api.g_varchar2
659: ,p_first_period_max_duration in number default hr_api.g_number
660: ,p_min_duration_per_request in number default hr_api.g_number
661: ,p_max_duration_per_request in number default hr_api.g_number
662: ,p_max_duration_whole_career in number default hr_api.g_number
663: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
664: ,p_max_no_of_renewals in number default hr_api.g_number

Line 661: ,p_max_duration_per_request in number default hr_api.g_number

657: ,p_pay_periods in number default hr_api.g_number
658: ,p_frequency in varchar2 default hr_api.g_varchar2
659: ,p_first_period_max_duration in number default hr_api.g_number
660: ,p_min_duration_per_request in number default hr_api.g_number
661: ,p_max_duration_per_request in number default hr_api.g_number
662: ,p_max_duration_whole_career in number default hr_api.g_number
663: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
664: ,p_max_no_of_renewals in number default hr_api.g_number
665: ,p_max_duration_per_renewal in number default hr_api.g_number

Line 662: ,p_max_duration_whole_career in number default hr_api.g_number

658: ,p_frequency in varchar2 default hr_api.g_varchar2
659: ,p_first_period_max_duration in number default hr_api.g_number
660: ,p_min_duration_per_request in number default hr_api.g_number
661: ,p_max_duration_per_request in number default hr_api.g_number
662: ,p_max_duration_whole_career in number default hr_api.g_number
663: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
664: ,p_max_no_of_renewals in number default hr_api.g_number
665: ,p_max_duration_per_renewal in number default hr_api.g_number
666: ,p_max_tot_continuous_duration in number default hr_api.g_number

Line 663: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2

659: ,p_first_period_max_duration in number default hr_api.g_number
660: ,p_min_duration_per_request in number default hr_api.g_number
661: ,p_max_duration_per_request in number default hr_api.g_number
662: ,p_max_duration_whole_career in number default hr_api.g_number
663: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
664: ,p_max_no_of_renewals in number default hr_api.g_number
665: ,p_max_duration_per_renewal in number default hr_api.g_number
666: ,p_max_tot_continuous_duration in number default hr_api.g_number
667: ,p_remunerate_assign_status_id in number default hr_api.g_number

Line 664: ,p_max_no_of_renewals in number default hr_api.g_number

660: ,p_min_duration_per_request in number default hr_api.g_number
661: ,p_max_duration_per_request in number default hr_api.g_number
662: ,p_max_duration_whole_career in number default hr_api.g_number
663: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
664: ,p_max_no_of_renewals in number default hr_api.g_number
665: ,p_max_duration_per_renewal in number default hr_api.g_number
666: ,p_max_tot_continuous_duration in number default hr_api.g_number
667: ,p_remunerate_assign_status_id in number default hr_api.g_number
668: ) is

Line 665: ,p_max_duration_per_renewal in number default hr_api.g_number

661: ,p_max_duration_per_request in number default hr_api.g_number
662: ,p_max_duration_whole_career in number default hr_api.g_number
663: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
664: ,p_max_no_of_renewals in number default hr_api.g_number
665: ,p_max_duration_per_renewal in number default hr_api.g_number
666: ,p_max_tot_continuous_duration in number default hr_api.g_number
667: ,p_remunerate_assign_status_id in number default hr_api.g_number
668: ) is
669: --

Line 666: ,p_max_tot_continuous_duration in number default hr_api.g_number

662: ,p_max_duration_whole_career in number default hr_api.g_number
663: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
664: ,p_max_no_of_renewals in number default hr_api.g_number
665: ,p_max_duration_per_renewal in number default hr_api.g_number
666: ,p_max_tot_continuous_duration in number default hr_api.g_number
667: ,p_remunerate_assign_status_id in number default hr_api.g_number
668: ) is
669: --
670: l_rec pqh_sts_shd.g_rec_type;

Line 667: ,p_remunerate_assign_status_id in number default hr_api.g_number

663: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
664: ,p_max_no_of_renewals in number default hr_api.g_number
665: ,p_max_duration_per_renewal in number default hr_api.g_number
666: ,p_max_tot_continuous_duration in number default hr_api.g_number
667: ,p_remunerate_assign_status_id in number default hr_api.g_number
668: ) is
669: --
670: l_rec pqh_sts_shd.g_rec_type;
671: l_proc varchar2(72) := g_package||'upd';