The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure update_TRAN_CATEGORY
(p_validate in boolean default false
,p_transaction_category_id in number
,p_custom_wf_process_name in varchar2 default hr_api.g_varchar2
,p_custom_workflow_name in varchar2 default hr_api.g_varchar2
,p_form_name in varchar2 default hr_api.g_varchar2
,p_freeze_status_cd in varchar2 default hr_api.g_varchar2
,p_future_action_cd in varchar2 default hr_api.g_varchar2
,p_member_cd in varchar2 default hr_api.g_varchar2
,p_name in varchar2 default hr_api.g_varchar2
,p_short_name in varchar2 default hr_api.g_varchar2
,p_post_style_cd in varchar2 default hr_api.g_varchar2
,p_post_txn_function in varchar2 default hr_api.g_varchar2
,p_route_validated_txn_flag in varchar2 default hr_api.g_varchar2
,p_prevent_approver_skip in varchar2 default hr_api.g_varchar2
,p_workflow_enable_flag in varchar2 default hr_api.g_varchar2
,p_enable_flag in varchar2 default hr_api.g_varchar2
,p_timeout_days in number default hr_api.g_number
,p_object_version_number in out nocopy number
,p_consolidated_table_route_id in number default hr_api.g_number
,p_business_group_id in number default hr_api.g_number
,p_setup_type_cd in varchar2 default hr_api.g_varchar2
,p_master_table_route_id in number default hr_api.g_number
,p_effective_date in date
,p_language_code in varchar2 default hr_api.userenv_lang
) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||'update_TRAN_CATEGORY';
savepoint update_TRAN_CATEGORY;
pqh_TRAN_CATEGORY_bk2.update_TRAN_CATEGORY_b
(
p_transaction_category_id => p_transaction_category_id
,p_custom_wf_process_name => p_custom_wf_process_name
,p_custom_workflow_name => p_custom_workflow_name
,p_form_name => p_form_name
,p_freeze_status_cd => p_freeze_status_cd
,p_future_action_cd => p_future_action_cd
,p_member_cd => p_member_cd
,p_name => p_name
,p_short_name => p_short_name
,p_post_style_cd => p_post_style_cd
,p_post_txn_function => p_post_txn_function
,p_route_validated_txn_flag => p_route_validated_txn_flag
,p_prevent_approver_skip => p_prevent_approver_skip
,p_workflow_enable_flag => p_workflow_enable_flag
,p_enable_flag => p_enable_flag
,p_timeout_days => p_timeout_days
,p_object_version_number => p_object_version_number
,p_consolidated_table_route_id => p_consolidated_table_route_id
,p_business_group_id => p_business_group_id
,p_setup_type_cd => p_setup_type_cd
,p_master_table_route_id => p_master_table_route_id
,p_effective_date => trunc(p_effective_date)
);
(p_module_name => 'UPDATE_TRAN_CATEGORY'
,p_hook_type => 'BP'
);
pqh_TRAN_CATEGORY_bk2.update_TRAN_CATEGORY_a
(
p_transaction_category_id => p_transaction_category_id
,p_custom_wf_process_name => p_custom_wf_process_name
,p_custom_workflow_name => p_custom_workflow_name
,p_form_name => p_form_name
,p_freeze_status_cd => p_freeze_status_cd
,p_future_action_cd => p_future_action_cd
,p_member_cd => p_member_cd
,p_name => p_name
,p_short_name => p_short_name
,p_post_style_cd => p_post_style_cd
,p_post_txn_function => p_post_txn_function
,p_route_validated_txn_flag => p_route_validated_txn_flag
,p_prevent_approver_skip => p_prevent_approver_skip
,p_workflow_enable_flag => p_workflow_enable_flag
,p_enable_flag => p_enable_flag
,p_timeout_days => p_timeout_days
,p_object_version_number => l_object_version_number
,p_consolidated_table_route_id => p_consolidated_table_route_id
,p_business_group_id => p_business_group_id
,p_setup_type_cd => p_setup_type_cd
,p_master_table_route_id => p_master_table_route_id
,p_effective_date => trunc(p_effective_date)
);
(p_module_name => 'UPDATE_TRAN_CATEGORY'
,p_hook_type => 'AP'
);
ROLLBACK TO update_TRAN_CATEGORY;
ROLLBACK TO update_TRAN_CATEGORY;
end update_TRAN_CATEGORY;
procedure delete_TRAN_CATEGORY
(p_validate in boolean default false
,p_transaction_category_id in number
,p_object_version_number in number
,p_effective_date in date
) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||'delete_TRAN_CATEGORY';
savepoint delete_TRAN_CATEGORY;
pqh_TRAN_CATEGORY_bk3.delete_TRAN_CATEGORY_b
(
p_transaction_category_id => p_transaction_category_id
,p_object_version_number => p_object_version_number
,p_effective_date => trunc(p_effective_date)
);
(p_module_name => 'DELETE_TRAN_CATEGORY'
,p_hook_type => 'BP'
);
pqh_TRAN_CATEGORY_bk3.delete_TRAN_CATEGORY_a
(
p_transaction_category_id => p_transaction_category_id
,p_object_version_number => l_object_version_number
,p_effective_date => trunc(p_effective_date)
);
(p_module_name => 'DELETE_TRAN_CATEGORY'
,p_hook_type => 'AP'
);
ROLLBACK TO delete_TRAN_CATEGORY;
ROLLBACK TO delete_TRAN_CATEGORY;
end delete_TRAN_CATEGORY;