The following lines contain the word 'select', 'insert', 'update' or 'delete':
,p_program_update_date in date default null
,p_last_update_date in date default null
,p_last_updated_by in number default null
,p_last_update_login in number default null
,p_created_by in number default null
,p_creation_date in date default null
,p_object_version_number out nocopy number
,p_assignment_budget_value_id out nocopy number
) is
--
-- Declare cursors and local variables
--
l_assignment_budget_value_id number;
,p_program_update_date => p_program_update_date
,p_last_update_date => p_last_update_date
,p_last_updated_by => p_last_updated_by
,p_last_update_login => p_last_update_login
,p_created_by => p_created_by
,p_creation_date => p_creation_date
);
,p_program_update_date => p_program_update_date
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_assignment_budget_value_id => l_assignment_budget_value_id
,p_object_version_number => p_object_version_number
);
,p_program_update_date => p_program_update_date
,p_last_update_date => p_last_update_date
,p_last_updated_by => p_last_updated_by
,p_last_update_login => p_last_update_login
,p_created_by => p_created_by
,p_creation_date => p_creation_date
,p_assignment_budget_value_id=> l_assignment_budget_value_id
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_object_version_number => l_object_version_number
);
procedure UPDATE_ASG_BUDGET_VALUE
(p_validate in boolean default false
,p_assignment_budget_value_id in number
,p_effective_date in date
,p_datetrack_mode in varchar2
,p_business_group_id in number default hr_api.g_number
,p_unit in varchar2 default hr_api.g_varchar2
,p_value in number default hr_api.g_number
,p_request_id in number default hr_api.g_number
,p_program_application_id in number default hr_api.g_number
,p_program_id in number default hr_api.g_number
,p_program_update_date in date default hr_api.g_date
,p_last_update_date in date default hr_api.g_date
,p_last_updated_by in number default hr_api.g_number
,p_last_update_login in number default hr_api.g_number
,p_created_by in number default hr_api.g_number
,p_creation_date in date default hr_api.g_date
,p_object_version_number in out nocopy number
) is
--
-- Declare cursors and local variables
--
l_effective_start_date date;
l_proc varchar2(72) := g_package||'UPDATE_ASG_BUDGET_VALUE';
savepoint UPDATE_ASG_BUDGET_VALUE;
HR_ASG_BUDGET_VALUE_BK2.UPDATE_ASG_BUDGET_VALUE_b
(p_effective_date => p_effective_date
,p_assignment_budget_value_id=> p_assignment_budget_value_id
,p_business_group_id => p_business_group_id
,p_unit => p_unit
,p_value => p_value
,p_request_id => p_request_id
,p_program_application_id => p_program_application_id
,p_program_id => p_program_id
,p_program_update_date => p_program_update_date
,p_last_update_date => p_last_update_date
,p_last_updated_by => p_last_updated_by
,p_last_update_login => p_last_update_login
,p_created_by => p_created_by
,p_creation_date => p_creation_date
,p_datetrack_mode => p_datetrack_mode
,p_object_version_number => p_object_version_number
);
(p_module_name => 'UPDATE_ASG_BUDGET_VALUE'
,p_hook_type => 'BP'
);
,p_program_update_date => p_program_update_date
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_object_version_number => p_object_version_number
);
HR_ASG_BUDGET_VALUE_BK2.UPDATE_ASG_BUDGET_VALUE_a
(p_effective_date => p_effective_date
,p_datetrack_mode => p_datetrack_mode
,p_business_group_id => p_business_group_id
,p_unit => p_unit
,p_value => p_value
,p_request_id => p_request_id
,p_program_application_id => p_program_application_id
,p_program_id => p_program_id
,p_program_update_date => p_program_update_date
,p_last_update_date => p_last_update_date
,p_last_updated_by => p_last_updated_by
,p_last_update_login => p_last_update_login
,p_created_by => p_created_by
,p_creation_date => p_creation_date
,p_assignment_budget_value_id=> p_assignment_budget_value_id
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_object_version_number => p_object_version_number
);
(p_module_name => 'UPDATE_ASG_BUDGET_VALUE'
,p_hook_type => 'AP'
);
rollback to UPDATE_ASG_BUDGET_VALUE;
rollback to UPDATE_ASG_BUDGET_VALUE;
end UPDATE_ASG_BUDGET_VALUE;
procedure DELETE_ASG_BUDGET_VALUE
(p_validate in boolean default false
,p_assignment_budget_value_id in number
,p_effective_date in date
,p_datetrack_mode in varchar2
,p_object_version_number in out nocopy number
) is
--
-- Declare cursors and local variables
--
l_effective_start_date date;
l_proc varchar2(72) := g_package||'DELETE_ASG_BUDGET_VALUE';
savepoint DELETE_ASG_BUDGET_VALUE;
HR_ASG_BUDGET_VALUE_BK3.DELETE_ASG_BUDGET_VALUE_b
(p_assignment_budget_value_id=> p_assignment_budget_value_id
,p_datetrack_mode => p_datetrack_mode
,p_effective_date => p_effective_date
,p_object_version_number => p_object_version_number);
(p_module_name => 'DELETE_ASG_BUDGET_VALUE'
,p_hook_type => 'BP'
);
HR_ASG_BUDGET_VALUE_BK3.DELETE_ASG_BUDGET_VALUE_a
(p_effective_date => p_effective_date
,p_datetrack_mode => p_datetrack_mode
,p_assignment_budget_value_id => p_assignment_budget_value_id
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_object_version_number => l_object_version_number
);
(p_module_name => 'DELETE_ASG_BUDGET_VALUE'
,p_hook_type => 'AP'
);
rollback to DELETE_ASG_BUDGET_VALUE;
rollback to DELETE_ASG_BUDGET_VALUE;
end DELETE_ASG_BUDGET_VALUE;