96: Procedure upd
97: (p_effective_date in date
98: ,p_statutory_situation_id in number
99: ,p_object_version_number in out nocopy number
100: ,p_business_group_id in number default hr_api.g_number
101: ,p_situation_name in varchar2 default hr_api.g_varchar2
102: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
103: ,p_situation_type in varchar2 default hr_api.g_varchar2
104: ,p_sub_type in varchar2 default hr_api.g_varchar2
97: (p_effective_date in date
98: ,p_statutory_situation_id in number
99: ,p_object_version_number in out nocopy number
100: ,p_business_group_id in number default hr_api.g_number
101: ,p_situation_name in varchar2 default hr_api.g_varchar2
102: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
103: ,p_situation_type in varchar2 default hr_api.g_varchar2
104: ,p_sub_type in varchar2 default hr_api.g_varchar2
105: ,p_source in varchar2 default hr_api.g_varchar2
98: ,p_statutory_situation_id in number
99: ,p_object_version_number in out nocopy number
100: ,p_business_group_id in number default hr_api.g_number
101: ,p_situation_name in varchar2 default hr_api.g_varchar2
102: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
103: ,p_situation_type in varchar2 default hr_api.g_varchar2
104: ,p_sub_type in varchar2 default hr_api.g_varchar2
105: ,p_source in varchar2 default hr_api.g_varchar2
106: ,p_location in varchar2 default hr_api.g_varchar2
99: ,p_object_version_number in out nocopy number
100: ,p_business_group_id in number default hr_api.g_number
101: ,p_situation_name in varchar2 default hr_api.g_varchar2
102: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
103: ,p_situation_type in varchar2 default hr_api.g_varchar2
104: ,p_sub_type in varchar2 default hr_api.g_varchar2
105: ,p_source in varchar2 default hr_api.g_varchar2
106: ,p_location in varchar2 default hr_api.g_varchar2
107: ,p_reason in varchar2 default hr_api.g_varchar2
100: ,p_business_group_id in number default hr_api.g_number
101: ,p_situation_name in varchar2 default hr_api.g_varchar2
102: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
103: ,p_situation_type in varchar2 default hr_api.g_varchar2
104: ,p_sub_type in varchar2 default hr_api.g_varchar2
105: ,p_source in varchar2 default hr_api.g_varchar2
106: ,p_location in varchar2 default hr_api.g_varchar2
107: ,p_reason in varchar2 default hr_api.g_varchar2
108: ,p_is_default in varchar2 default hr_api.g_varchar2
101: ,p_situation_name in varchar2 default hr_api.g_varchar2
102: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
103: ,p_situation_type in varchar2 default hr_api.g_varchar2
104: ,p_sub_type in varchar2 default hr_api.g_varchar2
105: ,p_source in varchar2 default hr_api.g_varchar2
106: ,p_location in varchar2 default hr_api.g_varchar2
107: ,p_reason in varchar2 default hr_api.g_varchar2
108: ,p_is_default in varchar2 default hr_api.g_varchar2
109: ,p_date_from in date default hr_api.g_date
102: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
103: ,p_situation_type in varchar2 default hr_api.g_varchar2
104: ,p_sub_type in varchar2 default hr_api.g_varchar2
105: ,p_source in varchar2 default hr_api.g_varchar2
106: ,p_location in varchar2 default hr_api.g_varchar2
107: ,p_reason in varchar2 default hr_api.g_varchar2
108: ,p_is_default in varchar2 default hr_api.g_varchar2
109: ,p_date_from in date default hr_api.g_date
110: ,p_date_to in date default hr_api.g_date
103: ,p_situation_type in varchar2 default hr_api.g_varchar2
104: ,p_sub_type in varchar2 default hr_api.g_varchar2
105: ,p_source in varchar2 default hr_api.g_varchar2
106: ,p_location in varchar2 default hr_api.g_varchar2
107: ,p_reason in varchar2 default hr_api.g_varchar2
108: ,p_is_default in varchar2 default hr_api.g_varchar2
109: ,p_date_from in date default hr_api.g_date
110: ,p_date_to in date default hr_api.g_date
111: ,p_request_type in varchar2 default hr_api.g_varchar2
104: ,p_sub_type in varchar2 default hr_api.g_varchar2
105: ,p_source in varchar2 default hr_api.g_varchar2
106: ,p_location in varchar2 default hr_api.g_varchar2
107: ,p_reason in varchar2 default hr_api.g_varchar2
108: ,p_is_default in varchar2 default hr_api.g_varchar2
109: ,p_date_from in date default hr_api.g_date
110: ,p_date_to in date default hr_api.g_date
111: ,p_request_type in varchar2 default hr_api.g_varchar2
112: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
105: ,p_source in varchar2 default hr_api.g_varchar2
106: ,p_location in varchar2 default hr_api.g_varchar2
107: ,p_reason in varchar2 default hr_api.g_varchar2
108: ,p_is_default in varchar2 default hr_api.g_varchar2
109: ,p_date_from in date default hr_api.g_date
110: ,p_date_to in date default hr_api.g_date
111: ,p_request_type in varchar2 default hr_api.g_varchar2
112: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
113: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
106: ,p_location in varchar2 default hr_api.g_varchar2
107: ,p_reason in varchar2 default hr_api.g_varchar2
108: ,p_is_default in varchar2 default hr_api.g_varchar2
109: ,p_date_from in date default hr_api.g_date
110: ,p_date_to in date default hr_api.g_date
111: ,p_request_type in varchar2 default hr_api.g_varchar2
112: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
113: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
114: ,p_print_arrette in varchar2 default hr_api.g_varchar2
107: ,p_reason in varchar2 default hr_api.g_varchar2
108: ,p_is_default in varchar2 default hr_api.g_varchar2
109: ,p_date_from in date default hr_api.g_date
110: ,p_date_to in date default hr_api.g_date
111: ,p_request_type in varchar2 default hr_api.g_varchar2
112: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
113: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
114: ,p_print_arrette in varchar2 default hr_api.g_varchar2
115: ,p_reserve_position in varchar2 default hr_api.g_varchar2
108: ,p_is_default in varchar2 default hr_api.g_varchar2
109: ,p_date_from in date default hr_api.g_date
110: ,p_date_to in date default hr_api.g_date
111: ,p_request_type in varchar2 default hr_api.g_varchar2
112: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
113: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
114: ,p_print_arrette in varchar2 default hr_api.g_varchar2
115: ,p_reserve_position in varchar2 default hr_api.g_varchar2
116: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
109: ,p_date_from in date default hr_api.g_date
110: ,p_date_to in date default hr_api.g_date
111: ,p_request_type in varchar2 default hr_api.g_varchar2
112: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
113: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
114: ,p_print_arrette in varchar2 default hr_api.g_varchar2
115: ,p_reserve_position in varchar2 default hr_api.g_varchar2
116: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
117: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
110: ,p_date_to in date default hr_api.g_date
111: ,p_request_type in varchar2 default hr_api.g_varchar2
112: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
113: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
114: ,p_print_arrette in varchar2 default hr_api.g_varchar2
115: ,p_reserve_position in varchar2 default hr_api.g_varchar2
116: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
117: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
118: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
111: ,p_request_type in varchar2 default hr_api.g_varchar2
112: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
113: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
114: ,p_print_arrette in varchar2 default hr_api.g_varchar2
115: ,p_reserve_position in varchar2 default hr_api.g_varchar2
116: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
117: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
118: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
119: ,p_pay_share in number default hr_api.g_number
112: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
113: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
114: ,p_print_arrette in varchar2 default hr_api.g_varchar2
115: ,p_reserve_position in varchar2 default hr_api.g_varchar2
116: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
117: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
118: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
119: ,p_pay_share in number default hr_api.g_number
120: ,p_pay_periods in number default hr_api.g_number
113: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
114: ,p_print_arrette in varchar2 default hr_api.g_varchar2
115: ,p_reserve_position in varchar2 default hr_api.g_varchar2
116: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
117: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
118: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
119: ,p_pay_share in number default hr_api.g_number
120: ,p_pay_periods in number default hr_api.g_number
121: ,p_frequency in varchar2 default hr_api.g_varchar2
114: ,p_print_arrette in varchar2 default hr_api.g_varchar2
115: ,p_reserve_position in varchar2 default hr_api.g_varchar2
116: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
117: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
118: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
119: ,p_pay_share in number default hr_api.g_number
120: ,p_pay_periods in number default hr_api.g_number
121: ,p_frequency in varchar2 default hr_api.g_varchar2
122: ,p_first_period_max_duration in number default hr_api.g_number
115: ,p_reserve_position in varchar2 default hr_api.g_varchar2
116: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
117: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
118: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
119: ,p_pay_share in number default hr_api.g_number
120: ,p_pay_periods in number default hr_api.g_number
121: ,p_frequency in varchar2 default hr_api.g_varchar2
122: ,p_first_period_max_duration in number default hr_api.g_number
123: ,p_min_duration_per_request in number default hr_api.g_number
116: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
117: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
118: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
119: ,p_pay_share in number default hr_api.g_number
120: ,p_pay_periods in number default hr_api.g_number
121: ,p_frequency in varchar2 default hr_api.g_varchar2
122: ,p_first_period_max_duration in number default hr_api.g_number
123: ,p_min_duration_per_request in number default hr_api.g_number
124: ,p_max_duration_per_request in number default hr_api.g_number
117: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
118: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
119: ,p_pay_share in number default hr_api.g_number
120: ,p_pay_periods in number default hr_api.g_number
121: ,p_frequency in varchar2 default hr_api.g_varchar2
122: ,p_first_period_max_duration in number default hr_api.g_number
123: ,p_min_duration_per_request in number default hr_api.g_number
124: ,p_max_duration_per_request in number default hr_api.g_number
125: ,p_max_duration_whole_career in number default hr_api.g_number
118: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
119: ,p_pay_share in number default hr_api.g_number
120: ,p_pay_periods in number default hr_api.g_number
121: ,p_frequency in varchar2 default hr_api.g_varchar2
122: ,p_first_period_max_duration in number default hr_api.g_number
123: ,p_min_duration_per_request in number default hr_api.g_number
124: ,p_max_duration_per_request in number default hr_api.g_number
125: ,p_max_duration_whole_career in number default hr_api.g_number
126: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
119: ,p_pay_share in number default hr_api.g_number
120: ,p_pay_periods in number default hr_api.g_number
121: ,p_frequency in varchar2 default hr_api.g_varchar2
122: ,p_first_period_max_duration in number default hr_api.g_number
123: ,p_min_duration_per_request in number default hr_api.g_number
124: ,p_max_duration_per_request in number default hr_api.g_number
125: ,p_max_duration_whole_career in number default hr_api.g_number
126: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
127: ,p_max_no_of_renewals in number default hr_api.g_number
120: ,p_pay_periods in number default hr_api.g_number
121: ,p_frequency in varchar2 default hr_api.g_varchar2
122: ,p_first_period_max_duration in number default hr_api.g_number
123: ,p_min_duration_per_request in number default hr_api.g_number
124: ,p_max_duration_per_request in number default hr_api.g_number
125: ,p_max_duration_whole_career in number default hr_api.g_number
126: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
127: ,p_max_no_of_renewals in number default hr_api.g_number
128: ,p_max_duration_per_renewal in number default hr_api.g_number
121: ,p_frequency in varchar2 default hr_api.g_varchar2
122: ,p_first_period_max_duration in number default hr_api.g_number
123: ,p_min_duration_per_request in number default hr_api.g_number
124: ,p_max_duration_per_request in number default hr_api.g_number
125: ,p_max_duration_whole_career in number default hr_api.g_number
126: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
127: ,p_max_no_of_renewals in number default hr_api.g_number
128: ,p_max_duration_per_renewal in number default hr_api.g_number
129: ,p_max_tot_continuous_duration in number default hr_api.g_number
122: ,p_first_period_max_duration in number default hr_api.g_number
123: ,p_min_duration_per_request in number default hr_api.g_number
124: ,p_max_duration_per_request in number default hr_api.g_number
125: ,p_max_duration_whole_career in number default hr_api.g_number
126: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
127: ,p_max_no_of_renewals in number default hr_api.g_number
128: ,p_max_duration_per_renewal in number default hr_api.g_number
129: ,p_max_tot_continuous_duration in number default hr_api.g_number
130: ,p_remunerate_assign_status_id in number default hr_api.g_number
123: ,p_min_duration_per_request in number default hr_api.g_number
124: ,p_max_duration_per_request in number default hr_api.g_number
125: ,p_max_duration_whole_career in number default hr_api.g_number
126: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
127: ,p_max_no_of_renewals in number default hr_api.g_number
128: ,p_max_duration_per_renewal in number default hr_api.g_number
129: ,p_max_tot_continuous_duration in number default hr_api.g_number
130: ,p_remunerate_assign_status_id in number default hr_api.g_number
131: );
124: ,p_max_duration_per_request in number default hr_api.g_number
125: ,p_max_duration_whole_career in number default hr_api.g_number
126: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
127: ,p_max_no_of_renewals in number default hr_api.g_number
128: ,p_max_duration_per_renewal in number default hr_api.g_number
129: ,p_max_tot_continuous_duration in number default hr_api.g_number
130: ,p_remunerate_assign_status_id in number default hr_api.g_number
131: );
132: --
125: ,p_max_duration_whole_career in number default hr_api.g_number
126: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
127: ,p_max_no_of_renewals in number default hr_api.g_number
128: ,p_max_duration_per_renewal in number default hr_api.g_number
129: ,p_max_tot_continuous_duration in number default hr_api.g_number
130: ,p_remunerate_assign_status_id in number default hr_api.g_number
131: );
132: --
133: end pqh_sts_upd;
126: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
127: ,p_max_no_of_renewals in number default hr_api.g_number
128: ,p_max_duration_per_renewal in number default hr_api.g_number
129: ,p_max_tot_continuous_duration in number default hr_api.g_number
130: ,p_remunerate_assign_status_id in number default hr_api.g_number
131: );
132: --
133: end pqh_sts_upd;