The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure update_routing_history
(p_validate in boolean default false
,p_routing_history_id in number
,p_approval_cd in varchar2 default hr_api.g_varchar2
,p_comments in varchar2 default hr_api.g_varchar2
,p_forwarded_by_assignment_id in number default hr_api.g_number
,p_forwarded_by_member_id in number default hr_api.g_number
,p_forwarded_by_position_id in number default hr_api.g_number
,p_forwarded_by_user_id in number default hr_api.g_number
,p_forwarded_by_role_id in number default hr_api.g_number
,p_forwarded_to_assignment_id in number default hr_api.g_number
,p_forwarded_to_member_id in number default hr_api.g_number
,p_forwarded_to_position_id in number default hr_api.g_number
,p_forwarded_to_user_id in number default hr_api.g_number
,p_forwarded_to_role_id in number default hr_api.g_number
,p_notification_date in date default hr_api.g_date
,p_pos_structure_version_id in number default hr_api.g_number
,p_routing_category_id in number default hr_api.g_number
,p_transaction_category_id in number default hr_api.g_number
,p_transaction_id in number default hr_api.g_number
,p_user_action_cd in varchar2 default hr_api.g_varchar2
,p_object_version_number in out nocopy number
,p_from_range_name in varchar2 default hr_api.g_varchar2
,p_to_range_name in varchar2 default hr_api.g_varchar2
,p_list_range_name in varchar2 default hr_api.g_varchar2
,p_effective_date in date
) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||'update_routing_history';
savepoint update_routing_history;
pqh_routing_history_bk2.update_routing_history_b
(
p_routing_history_id => p_routing_history_id
,p_approval_cd => p_approval_cd
,p_comments => p_comments
,p_forwarded_by_assignment_id => p_forwarded_by_assignment_id
,p_forwarded_by_member_id => p_forwarded_by_member_id
,p_forwarded_by_position_id => p_forwarded_by_position_id
,p_forwarded_by_user_id => p_forwarded_by_user_id
,p_forwarded_by_role_id => p_forwarded_by_role_id
,p_forwarded_to_assignment_id => p_forwarded_to_assignment_id
,p_forwarded_to_member_id => p_forwarded_to_member_id
,p_forwarded_to_position_id => p_forwarded_to_position_id
,p_forwarded_to_user_id => p_forwarded_to_user_id
,p_forwarded_to_role_id => p_forwarded_to_role_id
,p_notification_date => p_notification_date
,p_pos_structure_version_id => p_pos_structure_version_id
,p_routing_category_id => p_routing_category_id
,p_transaction_category_id => p_transaction_category_id
,p_transaction_id => p_transaction_id
,p_user_action_cd => p_user_action_cd
,p_object_version_number => p_object_version_number
,p_from_range_name => p_from_range_name
,p_to_range_name => p_to_range_name
,p_list_range_name => p_list_range_name
,p_effective_date => trunc(p_effective_date)
);
(p_module_name => 'UPDATE_ROUTING_HISTORY'
,p_hook_type => 'BP'
);
pqh_routing_history_bk2.update_routing_history_a
(
p_routing_history_id => p_routing_history_id
,p_approval_cd => p_approval_cd
,p_comments => p_comments
,p_forwarded_by_assignment_id => p_forwarded_by_assignment_id
,p_forwarded_by_member_id => p_forwarded_by_member_id
,p_forwarded_by_position_id => p_forwarded_by_position_id
,p_forwarded_by_user_id => p_forwarded_by_user_id
,p_forwarded_by_role_id => p_forwarded_by_role_id
,p_forwarded_to_assignment_id => p_forwarded_to_assignment_id
,p_forwarded_to_member_id => p_forwarded_to_member_id
,p_forwarded_to_position_id => p_forwarded_to_position_id
,p_forwarded_to_user_id => p_forwarded_to_user_id
,p_forwarded_to_role_id => p_forwarded_to_role_id
,p_notification_date => p_notification_date
,p_pos_structure_version_id => p_pos_structure_version_id
,p_routing_category_id => p_routing_category_id
,p_transaction_category_id => p_transaction_category_id
,p_transaction_id => p_transaction_id
,p_user_action_cd => p_user_action_cd
,p_object_version_number => l_object_version_number
,p_from_range_name => p_from_range_name
,p_to_range_name => p_to_range_name
,p_list_range_name => p_list_range_name
,p_effective_date => trunc(p_effective_date)
);
(p_module_name => 'UPDATE_ROUTING_HISTORY'
,p_hook_type => 'AP'
);
ROLLBACK TO update_routing_history;
ROLLBACK TO update_routing_history;
end update_routing_history;
procedure delete_routing_history
(p_validate in boolean default false
,p_routing_history_id in number
,p_object_version_number in out nocopy number
,p_effective_date in date
) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||'update_routing_history';
savepoint delete_routing_history;
pqh_routing_history_bk3.delete_routing_history_b
(
p_routing_history_id => p_routing_history_id
,p_object_version_number => p_object_version_number
,p_effective_date => trunc(p_effective_date)
);
(p_module_name => 'DELETE_ROUTING_HISTORY'
,p_hook_type => 'BP'
);
delete from pqh_routing_hist_attribs
where routing_history_id = p_routing_history_id;
pqh_routing_history_bk3.delete_routing_history_a
(
p_routing_history_id => p_routing_history_id
,p_object_version_number => l_object_version_number
,p_effective_date => trunc(p_effective_date)
);
(p_module_name => 'DELETE_ROUTING_HISTORY'
,p_hook_type => 'AP'
);
ROLLBACK TO delete_routing_history;
ROLLBACK TO delete_routing_history;
end delete_routing_history;
This procedure will call the create_routing_history API and then insert records into
pqh_routing_hist_attribs by calling create_routing_hist_attrib API in loop
*/
l_proc varchar2(72) := g_package||'create_routing_history_bp';
hr_utility.set_location(' Inserting Into pqh_routing_hist_attribs: '||l_proc, 5);
hr_utility.set_location(' Done Inserting Into pqh_routing_hist_attribs: '||l_routing_hist_attrib_id, 7);