10: -- ----------------------------------------------------------------------------
11: -- |----------------------< create_statutory_situation >----------------------|
12: -- ----------------------------------------------------------------------------
13: PROCEDURE create_statutory_situation
14: (p_validate in number default hr_api.g_false_num
15: ,p_effective_date in date default null
16: ,p_business_group_id in number
17: ,p_situation_name in varchar2
18: ,p_type_of_ps in varchar2
80: --
81: -- Convert constant values to their corresponding boolean value
82: --
83: l_validate :=
84: hr_api.constant_to_boolean
85: (p_constant_value => p_validate);
86: --
87: -- Register Surrogate ID or user key values
88: --
206: -- ----------------------------------------------------------------------------
207: -- |----------------------< delete_statutory_situation >----------------------|
208: -- ----------------------------------------------------------------------------
209: PROCEDURE delete_statutory_situation
210: (p_validate in number default hr_api.g_false_num
211: ,p_statutory_situation_id in number
212: ,p_object_version_number in number
213: ,p_return_status out nocopy varchar2
214: ) is
251: --
252: -- Convert constant values to their corresponding boolean value
253: --
254: l_validate :=
255: hr_api.constant_to_boolean
256: (p_constant_value => p_validate);
257: --
258: -- Register Surrogate ID or user key values
259: --
351: -- ----------------------------------------------------------------------------
352: -- |----------------------< update_statutory_situation >----------------------|
353: -- ----------------------------------------------------------------------------
354: PROCEDURE update_statutory_situation
355: (p_validate in number default hr_api.g_false_num
356: ,p_effective_date in date default hr_api.g_date
357: ,p_statutory_situation_id in number
358: ,p_object_version_number in out nocopy number
359: ,p_business_group_id in number default hr_api.g_number
352: -- |----------------------< update_statutory_situation >----------------------|
353: -- ----------------------------------------------------------------------------
354: PROCEDURE update_statutory_situation
355: (p_validate in number default hr_api.g_false_num
356: ,p_effective_date in date default hr_api.g_date
357: ,p_statutory_situation_id in number
358: ,p_object_version_number in out nocopy number
359: ,p_business_group_id in number default hr_api.g_number
360: ,p_situation_name in varchar2 default hr_api.g_varchar2
355: (p_validate in number default hr_api.g_false_num
356: ,p_effective_date in date default hr_api.g_date
357: ,p_statutory_situation_id in number
358: ,p_object_version_number in out nocopy number
359: ,p_business_group_id in number default hr_api.g_number
360: ,p_situation_name in varchar2 default hr_api.g_varchar2
361: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
362: ,p_situation_type in varchar2 default hr_api.g_varchar2
363: ,p_sub_type in varchar2 default hr_api.g_varchar2
356: ,p_effective_date in date default hr_api.g_date
357: ,p_statutory_situation_id in number
358: ,p_object_version_number in out nocopy number
359: ,p_business_group_id in number default hr_api.g_number
360: ,p_situation_name in varchar2 default hr_api.g_varchar2
361: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
362: ,p_situation_type in varchar2 default hr_api.g_varchar2
363: ,p_sub_type in varchar2 default hr_api.g_varchar2
364: ,p_source in varchar2 default hr_api.g_varchar2
357: ,p_statutory_situation_id in number
358: ,p_object_version_number in out nocopy number
359: ,p_business_group_id in number default hr_api.g_number
360: ,p_situation_name in varchar2 default hr_api.g_varchar2
361: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
362: ,p_situation_type in varchar2 default hr_api.g_varchar2
363: ,p_sub_type in varchar2 default hr_api.g_varchar2
364: ,p_source in varchar2 default hr_api.g_varchar2
365: ,p_location in varchar2 default hr_api.g_varchar2
358: ,p_object_version_number in out nocopy number
359: ,p_business_group_id in number default hr_api.g_number
360: ,p_situation_name in varchar2 default hr_api.g_varchar2
361: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
362: ,p_situation_type in varchar2 default hr_api.g_varchar2
363: ,p_sub_type in varchar2 default hr_api.g_varchar2
364: ,p_source in varchar2 default hr_api.g_varchar2
365: ,p_location in varchar2 default hr_api.g_varchar2
366: ,p_reason in varchar2 default hr_api.g_varchar2
359: ,p_business_group_id in number default hr_api.g_number
360: ,p_situation_name in varchar2 default hr_api.g_varchar2
361: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
362: ,p_situation_type in varchar2 default hr_api.g_varchar2
363: ,p_sub_type in varchar2 default hr_api.g_varchar2
364: ,p_source in varchar2 default hr_api.g_varchar2
365: ,p_location in varchar2 default hr_api.g_varchar2
366: ,p_reason in varchar2 default hr_api.g_varchar2
367: ,p_is_default in varchar2 default hr_api.g_varchar2
360: ,p_situation_name in varchar2 default hr_api.g_varchar2
361: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
362: ,p_situation_type in varchar2 default hr_api.g_varchar2
363: ,p_sub_type in varchar2 default hr_api.g_varchar2
364: ,p_source in varchar2 default hr_api.g_varchar2
365: ,p_location in varchar2 default hr_api.g_varchar2
366: ,p_reason in varchar2 default hr_api.g_varchar2
367: ,p_is_default in varchar2 default hr_api.g_varchar2
368: ,p_date_from in date default hr_api.g_date
361: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
362: ,p_situation_type in varchar2 default hr_api.g_varchar2
363: ,p_sub_type in varchar2 default hr_api.g_varchar2
364: ,p_source in varchar2 default hr_api.g_varchar2
365: ,p_location in varchar2 default hr_api.g_varchar2
366: ,p_reason in varchar2 default hr_api.g_varchar2
367: ,p_is_default in varchar2 default hr_api.g_varchar2
368: ,p_date_from in date default hr_api.g_date
369: ,p_date_to in date default hr_api.g_date
362: ,p_situation_type in varchar2 default hr_api.g_varchar2
363: ,p_sub_type in varchar2 default hr_api.g_varchar2
364: ,p_source in varchar2 default hr_api.g_varchar2
365: ,p_location in varchar2 default hr_api.g_varchar2
366: ,p_reason in varchar2 default hr_api.g_varchar2
367: ,p_is_default in varchar2 default hr_api.g_varchar2
368: ,p_date_from in date default hr_api.g_date
369: ,p_date_to in date default hr_api.g_date
370: ,p_request_type in varchar2 default hr_api.g_varchar2
363: ,p_sub_type in varchar2 default hr_api.g_varchar2
364: ,p_source in varchar2 default hr_api.g_varchar2
365: ,p_location in varchar2 default hr_api.g_varchar2
366: ,p_reason in varchar2 default hr_api.g_varchar2
367: ,p_is_default in varchar2 default hr_api.g_varchar2
368: ,p_date_from in date default hr_api.g_date
369: ,p_date_to in date default hr_api.g_date
370: ,p_request_type in varchar2 default hr_api.g_varchar2
371: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
364: ,p_source in varchar2 default hr_api.g_varchar2
365: ,p_location in varchar2 default hr_api.g_varchar2
366: ,p_reason in varchar2 default hr_api.g_varchar2
367: ,p_is_default in varchar2 default hr_api.g_varchar2
368: ,p_date_from in date default hr_api.g_date
369: ,p_date_to in date default hr_api.g_date
370: ,p_request_type in varchar2 default hr_api.g_varchar2
371: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
372: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
365: ,p_location in varchar2 default hr_api.g_varchar2
366: ,p_reason in varchar2 default hr_api.g_varchar2
367: ,p_is_default in varchar2 default hr_api.g_varchar2
368: ,p_date_from in date default hr_api.g_date
369: ,p_date_to in date default hr_api.g_date
370: ,p_request_type in varchar2 default hr_api.g_varchar2
371: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
372: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
373: ,p_print_arrette in varchar2 default hr_api.g_varchar2
366: ,p_reason in varchar2 default hr_api.g_varchar2
367: ,p_is_default in varchar2 default hr_api.g_varchar2
368: ,p_date_from in date default hr_api.g_date
369: ,p_date_to in date default hr_api.g_date
370: ,p_request_type in varchar2 default hr_api.g_varchar2
371: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
372: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
373: ,p_print_arrette in varchar2 default hr_api.g_varchar2
374: ,p_reserve_position in varchar2 default hr_api.g_varchar2
367: ,p_is_default in varchar2 default hr_api.g_varchar2
368: ,p_date_from in date default hr_api.g_date
369: ,p_date_to in date default hr_api.g_date
370: ,p_request_type in varchar2 default hr_api.g_varchar2
371: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
372: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
373: ,p_print_arrette in varchar2 default hr_api.g_varchar2
374: ,p_reserve_position in varchar2 default hr_api.g_varchar2
375: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
368: ,p_date_from in date default hr_api.g_date
369: ,p_date_to in date default hr_api.g_date
370: ,p_request_type in varchar2 default hr_api.g_varchar2
371: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
372: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
373: ,p_print_arrette in varchar2 default hr_api.g_varchar2
374: ,p_reserve_position in varchar2 default hr_api.g_varchar2
375: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
376: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
369: ,p_date_to in date default hr_api.g_date
370: ,p_request_type in varchar2 default hr_api.g_varchar2
371: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
372: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
373: ,p_print_arrette in varchar2 default hr_api.g_varchar2
374: ,p_reserve_position in varchar2 default hr_api.g_varchar2
375: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
376: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
377: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
370: ,p_request_type in varchar2 default hr_api.g_varchar2
371: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
372: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
373: ,p_print_arrette in varchar2 default hr_api.g_varchar2
374: ,p_reserve_position in varchar2 default hr_api.g_varchar2
375: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
376: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
377: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
378: ,p_pay_share in number default hr_api.g_number
371: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
372: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
373: ,p_print_arrette in varchar2 default hr_api.g_varchar2
374: ,p_reserve_position in varchar2 default hr_api.g_varchar2
375: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
376: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
377: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
378: ,p_pay_share in number default hr_api.g_number
379: ,p_pay_periods in number default hr_api.g_number
372: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
373: ,p_print_arrette in varchar2 default hr_api.g_varchar2
374: ,p_reserve_position in varchar2 default hr_api.g_varchar2
375: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
376: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
377: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
378: ,p_pay_share in number default hr_api.g_number
379: ,p_pay_periods in number default hr_api.g_number
380: ,p_frequency in varchar2 default hr_api.g_varchar2
373: ,p_print_arrette in varchar2 default hr_api.g_varchar2
374: ,p_reserve_position in varchar2 default hr_api.g_varchar2
375: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
376: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
377: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
378: ,p_pay_share in number default hr_api.g_number
379: ,p_pay_periods in number default hr_api.g_number
380: ,p_frequency in varchar2 default hr_api.g_varchar2
381: ,p_first_period_max_duration in number default hr_api.g_number
374: ,p_reserve_position in varchar2 default hr_api.g_varchar2
375: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
376: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
377: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
378: ,p_pay_share in number default hr_api.g_number
379: ,p_pay_periods in number default hr_api.g_number
380: ,p_frequency in varchar2 default hr_api.g_varchar2
381: ,p_first_period_max_duration in number default hr_api.g_number
382: ,p_min_duration_per_request in number default hr_api.g_number
375: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
376: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
377: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
378: ,p_pay_share in number default hr_api.g_number
379: ,p_pay_periods in number default hr_api.g_number
380: ,p_frequency in varchar2 default hr_api.g_varchar2
381: ,p_first_period_max_duration in number default hr_api.g_number
382: ,p_min_duration_per_request in number default hr_api.g_number
383: ,p_max_duration_per_request in number default hr_api.g_number
376: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
377: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
378: ,p_pay_share in number default hr_api.g_number
379: ,p_pay_periods in number default hr_api.g_number
380: ,p_frequency in varchar2 default hr_api.g_varchar2
381: ,p_first_period_max_duration in number default hr_api.g_number
382: ,p_min_duration_per_request in number default hr_api.g_number
383: ,p_max_duration_per_request in number default hr_api.g_number
384: ,p_max_duration_whole_career in number default hr_api.g_number
377: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
378: ,p_pay_share in number default hr_api.g_number
379: ,p_pay_periods in number default hr_api.g_number
380: ,p_frequency in varchar2 default hr_api.g_varchar2
381: ,p_first_period_max_duration in number default hr_api.g_number
382: ,p_min_duration_per_request in number default hr_api.g_number
383: ,p_max_duration_per_request in number default hr_api.g_number
384: ,p_max_duration_whole_career in number default hr_api.g_number
385: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
378: ,p_pay_share in number default hr_api.g_number
379: ,p_pay_periods in number default hr_api.g_number
380: ,p_frequency in varchar2 default hr_api.g_varchar2
381: ,p_first_period_max_duration in number default hr_api.g_number
382: ,p_min_duration_per_request in number default hr_api.g_number
383: ,p_max_duration_per_request in number default hr_api.g_number
384: ,p_max_duration_whole_career in number default hr_api.g_number
385: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
386: ,p_max_no_of_renewals in number default hr_api.g_number
379: ,p_pay_periods in number default hr_api.g_number
380: ,p_frequency in varchar2 default hr_api.g_varchar2
381: ,p_first_period_max_duration in number default hr_api.g_number
382: ,p_min_duration_per_request in number default hr_api.g_number
383: ,p_max_duration_per_request in number default hr_api.g_number
384: ,p_max_duration_whole_career in number default hr_api.g_number
385: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
386: ,p_max_no_of_renewals in number default hr_api.g_number
387: ,p_max_duration_per_renewal in number default hr_api.g_number
380: ,p_frequency in varchar2 default hr_api.g_varchar2
381: ,p_first_period_max_duration in number default hr_api.g_number
382: ,p_min_duration_per_request in number default hr_api.g_number
383: ,p_max_duration_per_request in number default hr_api.g_number
384: ,p_max_duration_whole_career in number default hr_api.g_number
385: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
386: ,p_max_no_of_renewals in number default hr_api.g_number
387: ,p_max_duration_per_renewal in number default hr_api.g_number
388: ,p_max_tot_continuous_duration in number default hr_api.g_number
381: ,p_first_period_max_duration in number default hr_api.g_number
382: ,p_min_duration_per_request in number default hr_api.g_number
383: ,p_max_duration_per_request in number default hr_api.g_number
384: ,p_max_duration_whole_career in number default hr_api.g_number
385: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
386: ,p_max_no_of_renewals in number default hr_api.g_number
387: ,p_max_duration_per_renewal in number default hr_api.g_number
388: ,p_max_tot_continuous_duration in number default hr_api.g_number
389: ,p_remunerate_assign_status_id in number default hr_api.g_number
382: ,p_min_duration_per_request in number default hr_api.g_number
383: ,p_max_duration_per_request in number default hr_api.g_number
384: ,p_max_duration_whole_career in number default hr_api.g_number
385: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
386: ,p_max_no_of_renewals in number default hr_api.g_number
387: ,p_max_duration_per_renewal in number default hr_api.g_number
388: ,p_max_tot_continuous_duration in number default hr_api.g_number
389: ,p_remunerate_assign_status_id in number default hr_api.g_number
390: ,p_return_status out nocopy varchar2
383: ,p_max_duration_per_request in number default hr_api.g_number
384: ,p_max_duration_whole_career in number default hr_api.g_number
385: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
386: ,p_max_no_of_renewals in number default hr_api.g_number
387: ,p_max_duration_per_renewal in number default hr_api.g_number
388: ,p_max_tot_continuous_duration in number default hr_api.g_number
389: ,p_remunerate_assign_status_id in number default hr_api.g_number
390: ,p_return_status out nocopy varchar2
391: ) is
384: ,p_max_duration_whole_career in number default hr_api.g_number
385: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
386: ,p_max_no_of_renewals in number default hr_api.g_number
387: ,p_max_duration_per_renewal in number default hr_api.g_number
388: ,p_max_tot_continuous_duration in number default hr_api.g_number
389: ,p_remunerate_assign_status_id in number default hr_api.g_number
390: ,p_return_status out nocopy varchar2
391: ) is
392: --
385: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
386: ,p_max_no_of_renewals in number default hr_api.g_number
387: ,p_max_duration_per_renewal in number default hr_api.g_number
388: ,p_max_tot_continuous_duration in number default hr_api.g_number
389: ,p_remunerate_assign_status_id in number default hr_api.g_number
390: ,p_return_status out nocopy varchar2
391: ) is
392: --
393: -- Variables for API Boolean parameters
422: --
423: -- Convert constant values to their corresponding boolean value
424: --
425: l_validate :=
426: hr_api.constant_to_boolean
427: (p_constant_value => p_validate);
428: --
429: -- Register Surrogate ID or user key values
430: --