The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure update_dml
(p_rec in out nocopy pqh_sts_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'update_dml';
update pqh_fr_stat_situations
set
statutory_situation_id = p_rec.statutory_situation_id
,business_group_id = p_rec.business_group_id
,situation_name = p_rec.situation_name
,type_of_ps = p_rec.type_of_ps
,situation_type = p_rec.situation_type
,sub_type = p_rec.sub_type
,source = p_rec.source
,location = p_rec.location
,reason = p_rec.reason
,default_flag = p_rec.is_default
,date_from = trunc(p_rec.date_from)
,date_to = trunc(p_rec.date_to)
,request_type = p_rec.request_type
,employee_agreement_needed = p_rec.employee_agreement_needed
,manager_agreement_needed = p_rec.manager_agreement_needed
,print_arrette = p_rec.print_arrette
,reserve_position = p_rec.reserve_position
,allow_progression_flag = p_rec.allow_progressions
,extend_probation_period_flag = p_rec.extend_probation_period
,remuneration_paid = p_rec.remuneration_paid
,pay_share = p_rec.pay_share
,pay_periods = p_rec.pay_periods
,frequency = p_rec.frequency
,first_period_max_duration = p_rec.first_period_max_duration
,min_duration_per_request = p_rec.min_duration_per_request
,max_duration_per_request = p_rec.max_duration_per_request
,max_duration_whole_career = p_rec.max_duration_whole_career
,renewable_allowed = p_rec.renewable_allowed
,max_no_of_renewals = p_rec.max_no_of_renewals
,max_duration_per_renewal = p_rec.max_duration_per_renewal
,max_tot_continuous_duration = p_rec.max_tot_continuous_duration
,object_version_number = p_rec.object_version_number
,remunerate_assign_status_id = p_rec.remunerate_assign_status_id
where statutory_situation_id = p_rec.statutory_situation_id;
End update_dml;
Procedure pre_update
(p_rec in pqh_sts_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'pre_update';
End pre_update;
Procedure post_update
(p_effective_date in date
,p_rec in pqh_sts_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'post_update';
pqh_sts_rku.after_update
(p_effective_date => trunc(p_effective_date)
,p_statutory_situation_id
=> p_rec.statutory_situation_id
,p_business_group_id
=> p_rec.business_group_id
,p_situation_name
=> p_rec.situation_name
,p_type_of_ps
=> p_rec.type_of_ps
,p_situation_type
=> p_rec.situation_type
,p_sub_type
=> p_rec.sub_type
,p_source
=> p_rec.source
,p_location
=> p_rec.location
,p_reason
=> p_rec.reason
,p_is_default
=> p_rec.is_default
,p_date_from
=> trunc(p_rec.date_from)
,p_date_to
=> trunc(p_rec.date_to)
,p_request_type
=> p_rec.request_type
,p_employee_agreement_needed
=> p_rec.employee_agreement_needed
,p_manager_agreement_needed
=> p_rec.manager_agreement_needed
,p_print_arrette
=> p_rec.print_arrette
,p_reserve_position
=> p_rec.reserve_position
,p_allow_progressions
=> p_rec.allow_progressions
,p_extend_probation_period
=> p_rec.extend_probation_period
,p_remuneration_paid
=> p_rec.remuneration_paid
,p_pay_share
=> p_rec.pay_share
,p_pay_periods
=> p_rec.pay_periods
,p_frequency
=> p_rec.frequency
,p_first_period_max_duration
=> p_rec.first_period_max_duration
,p_min_duration_per_request
=> p_rec.min_duration_per_request
,p_max_duration_per_request
=> p_rec.max_duration_per_request
,p_max_duration_whole_career
=> p_rec.max_duration_whole_career
,p_renewable_allowed
=> p_rec.renewable_allowed
,p_max_no_of_renewals
=> p_rec.max_no_of_renewals
,p_max_duration_per_renewal
=> p_rec.max_duration_per_renewal
,p_max_tot_continuous_duration
=> p_rec.max_tot_continuous_duration
,p_object_version_number
=> p_rec.object_version_number
,p_remunerate_assign_status_id
=> p_rec.remunerate_assign_status_id
,p_business_group_id_o
=> pqh_sts_shd.g_old_rec.business_group_id
,p_situation_name_o
=> pqh_sts_shd.g_old_rec.situation_name
,p_type_of_ps_o
=> pqh_sts_shd.g_old_rec.type_of_ps
,p_situation_type_o
=> pqh_sts_shd.g_old_rec.situation_type
,p_sub_type_o
=> pqh_sts_shd.g_old_rec.sub_type
,p_source_o
=> pqh_sts_shd.g_old_rec.source
,p_location_o
=> pqh_sts_shd.g_old_rec.location
,p_reason_o
=> pqh_sts_shd.g_old_rec.reason
,p_is_default_o
=> pqh_sts_shd.g_old_rec.is_default
,p_date_from_o
=> pqh_sts_shd.g_old_rec.date_from
,p_date_to_o
=> pqh_sts_shd.g_old_rec.date_to
,p_request_type_o
=> pqh_sts_shd.g_old_rec.request_type
,p_employee_agreement_needed_o
=> pqh_sts_shd.g_old_rec.employee_agreement_needed
,p_manager_agreement_needed_o
=> pqh_sts_shd.g_old_rec.manager_agreement_needed
,p_print_arrette_o
=> pqh_sts_shd.g_old_rec.print_arrette
,p_reserve_position_o
=> pqh_sts_shd.g_old_rec.reserve_position
,p_allow_progressions_o
=> pqh_sts_shd.g_old_rec.allow_progressions
,p_extend_probation_period_o
=> pqh_sts_shd.g_old_rec.extend_probation_period
,p_remuneration_paid_o
=> pqh_sts_shd.g_old_rec.remuneration_paid
,p_pay_share_o
=> pqh_sts_shd.g_old_rec.pay_share
,p_pay_periods_o
=> pqh_sts_shd.g_old_rec.pay_periods
,p_frequency_o
=> pqh_sts_shd.g_old_rec.frequency
,p_first_period_max_duration_o
=> pqh_sts_shd.g_old_rec.first_period_max_duration
,p_min_duration_per_request_o
=> pqh_sts_shd.g_old_rec.min_duration_per_request
,p_max_duration_per_request_o
=> pqh_sts_shd.g_old_rec.max_duration_per_request
,p_max_duration_whole_career_o
=> pqh_sts_shd.g_old_rec.max_duration_whole_career
,p_renewable_allowed_o
=> pqh_sts_shd.g_old_rec.renewable_allowed
,p_max_no_of_renewals_o
=> pqh_sts_shd.g_old_rec.max_no_of_renewals
,p_max_duration_per_renewal_o
=> pqh_sts_shd.g_old_rec.max_duration_per_renewal
,p_max_tot_continuous_duratio_o
=> pqh_sts_shd.g_old_rec.max_tot_continuous_duration
,p_object_version_number_o
=> pqh_sts_shd.g_old_rec.object_version_number
,p_remunerate_assign_stat_id_o
=> pqh_sts_shd.g_old_rec.remunerate_assign_status_id
);
End post_update;
pqh_sts_bus.update_validate
(p_effective_date
,p_rec
);
pqh_sts_upd.pre_update(p_rec);
pqh_sts_upd.update_dml(p_rec);
pqh_sts_upd.post_update
(p_effective_date
,p_rec
);