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));
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
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));
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
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));
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;
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');
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;
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: --
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: --
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;
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';