The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure update_dml
(p_rec in out nocopy pay_bld_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'update_dml';
update pay_balance_dimensions
set
balance_dimension_id = p_rec.balance_dimension_id
,business_group_id = p_rec.business_group_id
,legislation_code = p_rec.legislation_code
,route_id = p_rec.route_id
,database_item_suffix = p_rec.database_item_suffix
,dimension_name = p_rec.dimension_name
,dimension_type = p_rec.dimension_type
,description = p_rec.description
,feed_checking_code = p_rec.feed_checking_code
,legislation_subgroup = p_rec.legislation_subgroup
,payments_flag = p_rec.payments_flag
,expiry_checking_code = p_rec.expiry_checking_code
,expiry_checking_level = p_rec.expiry_checking_level
,feed_checking_type = p_rec.feed_checking_type
,dimension_level = p_rec.dimension_level
,period_type = p_rec.period_type
,asg_action_balance_dim_id = p_rec.asg_action_balance_dim_id
,database_item_function = p_rec.database_item_function
,save_run_balance_enabled = p_rec.save_run_balance_enabled
,start_date_code = p_rec.start_date_code
where balance_dimension_id = p_rec.balance_dimension_id;
End update_dml;
Procedure pre_update
(p_rec in pay_bld_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'pre_update';
End pre_update;
Procedure post_update
(p_rec in pay_bld_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'post_update';
pay_bld_rku.after_update
(p_balance_dimension_id
=> p_rec.balance_dimension_id
,p_business_group_id
=> p_rec.business_group_id
,p_legislation_code
=> p_rec.legislation_code
,p_route_id
=> p_rec.route_id
,p_database_item_suffix
=> p_rec.database_item_suffix
,p_dimension_name
=> p_rec.dimension_name
,p_dimension_type
=> p_rec.dimension_type
,p_description
=> p_rec.description
,p_feed_checking_code
=> p_rec.feed_checking_code
,p_legislation_subgroup
=> p_rec.legislation_subgroup
,p_payments_flag
=> p_rec.payments_flag
,p_expiry_checking_code
=> p_rec.expiry_checking_code
,p_expiry_checking_level
=> p_rec.expiry_checking_level
,p_feed_checking_type
=> p_rec.feed_checking_type
,p_dimension_level
=> p_rec.dimension_level
,p_period_type
=> p_rec.period_type
,p_asg_action_balance_dim_id
=> p_rec.asg_action_balance_dim_id
,p_database_item_function
=> p_rec.database_item_function
,p_save_run_balance_enabled
=> p_rec.save_run_balance_enabled
,p_start_date_code
=> p_rec.start_date_code
,p_business_group_id_o
=> pay_bld_shd.g_old_rec.business_group_id
,p_legislation_code_o
=> pay_bld_shd.g_old_rec.legislation_code
,p_route_id_o
=> pay_bld_shd.g_old_rec.route_id
,p_database_item_suffix_o
=> pay_bld_shd.g_old_rec.database_item_suffix
,p_dimension_name_o
=> pay_bld_shd.g_old_rec.dimension_name
,p_dimension_type_o
=> pay_bld_shd.g_old_rec.dimension_type
,p_description_o
=> pay_bld_shd.g_old_rec.description
,p_feed_checking_code_o
=> pay_bld_shd.g_old_rec.feed_checking_code
,p_legislation_subgroup_o
=> pay_bld_shd.g_old_rec.legislation_subgroup
,p_payments_flag_o
=> pay_bld_shd.g_old_rec.payments_flag
,p_expiry_checking_code_o
=> pay_bld_shd.g_old_rec.expiry_checking_code
,p_expiry_checking_level_o
=> pay_bld_shd.g_old_rec.expiry_checking_level
,p_feed_checking_type_o
=> pay_bld_shd.g_old_rec.feed_checking_type
,p_dimension_level_o
=> pay_bld_shd.g_old_rec.dimension_level
,p_period_type_o
=> pay_bld_shd.g_old_rec.period_type
,p_asg_action_balance_dim_id_o
=> pay_bld_shd.g_old_rec.asg_action_balance_dim_id
,p_database_item_function_o
=> pay_bld_shd.g_old_rec.database_item_function
,p_save_run_balance_enabled_o
=> pay_bld_shd.g_old_rec.save_run_balance_enabled
,p_start_date_code_o
=> pay_bld_shd.g_old_rec.start_date_code
);
End post_update;
pay_bld_bus.update_validate
(p_rec
);
pay_bld_upd.pre_update(p_rec);
pay_bld_upd.update_dml(p_rec);
pay_bld_upd.post_update
(p_rec
);