The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure insert_external_effort_line
( p_validate in boolean default false
, p_batch_name in varchar2
, p_distribution_date in date
, p_person_id in number
, p_assignment_id in number
, p_currency_code in varchar2
, p_distribution_amount in number
, p_business_group_id in number
, p_set_of_books_id in number
, p_gl_code_combination_id in number default null
, p_project_id in number default null
, p_task_id in number default null
, p_award_id in number default null
, p_expenditure_organization_id in number default null
, p_expenditure_type in varchar2 default null
, p_attribute_category in varchar2 default null
, p_attribute1 in varchar2 default null
, p_attribute2 in varchar2 default null
, p_attribute3 in varchar2 default null
, p_attribute4 in varchar2 default null
, p_attribute5 in varchar2 default null
, p_attribute6 in varchar2 default null
, p_attribute7 in varchar2 default null
, p_attribute8 in varchar2 default null
, p_attribute9 in varchar2 default null
, p_attribute10 in varchar2 default null
, p_attribute11 in varchar2 default null
, p_attribute12 in varchar2 default null
, p_attribute13 in varchar2 default null
, p_attribute14 in varchar2 default null
, p_attribute15 in varchar2 default null
, p_object_version_number in out nocopy number
, p_external_effort_line_id out nocopy number
, p_return_status out nocopy boolean
)
IS
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||'insert_external_effort_line';
savepoint insert_external_effort_line;
psp_external_effort_lines_bk1.insert_external_effort_line_b
( p_batch_name => p_batch_name
, p_distribution_date => p_distribution_date
, p_person_id => p_person_id
, p_assignment_id => p_assignment_id
, p_currency_code => p_currency_code
, p_distribution_amount => p_distribution_amount
, p_business_group_id => p_business_group_id
, p_set_of_books_id => p_set_of_books_id
, p_gl_code_combination_id => p_gl_code_combination_id
, p_project_id => p_project_id
, p_task_id => p_task_id
, p_award_id => p_award_id
, p_expenditure_organization_id => p_expenditure_organization_id
, p_expenditure_type => p_expenditure_type
, p_attribute_category => p_attribute_category
, p_attribute1 => p_attribute1
, p_attribute2 => p_attribute2
, p_attribute3 => p_attribute3
, p_attribute4 => p_attribute4
, p_attribute5 => p_attribute5
, p_attribute6 => p_attribute6
, p_attribute7 => p_attribute7
, p_attribute8 => p_attribute8
, p_attribute9 => p_attribute9
, p_attribute10 => p_attribute10
, p_attribute11 => p_attribute11
, p_attribute12 => p_attribute12
, p_attribute13 => p_attribute13
, p_attribute14 => p_attribute14
, p_attribute15 => p_attribute15
);
(p_module_name => 'insert_external_effort_line'
,p_hook_type => 'BP'
);
psp_external_effort_lines_bk1.insert_external_effort_line_a
( p_batch_name => p_batch_name
, p_distribution_date => p_distribution_date
, p_person_id => p_person_id
, p_assignment_id => p_assignment_id
, p_currency_code => p_currency_code
, p_distribution_amount => p_distribution_amount
, p_business_group_id => p_business_group_id
, p_set_of_books_id => p_set_of_books_id
, p_gl_code_combination_id => p_gl_code_combination_id
, p_project_id => p_project_id
, p_task_id => p_task_id
, p_award_id => p_award_id
, p_expenditure_organization_id => p_expenditure_organization_id
, p_expenditure_type => p_expenditure_type
, p_attribute_category => p_attribute_category
, p_attribute1 => p_attribute1
, p_attribute2 => p_attribute2
, p_attribute3 => p_attribute3
, p_attribute4 => p_attribute4
, p_attribute5 => p_attribute5
, p_attribute6 => p_attribute6
, p_attribute7 => p_attribute7
, p_attribute8 => p_attribute8
, p_attribute9 => p_attribute9
, p_attribute10 => p_attribute10
, p_attribute11 => p_attribute11
, p_attribute12 => p_attribute12
, p_attribute13 => p_attribute13
, p_attribute14 => p_attribute14
, p_attribute15 => p_attribute15
, p_object_version_number => l_object_version_number
, p_external_effort_line_id => l_external_effort_line_id
, p_return_status => l_return_status
);
(p_module_name => 'insert_external_effort_line'
,p_hook_type => 'AP'
);
rollback to insert_external_effort_line;
rollback to insert_external_effort_line;
end insert_external_effort_line;
procedure update_external_effort_line
( p_validate in boolean default false
, p_external_effort_line_id in number
, p_batch_name in varchar2 default hr_api.g_varchar2
, p_distribution_date in date default hr_api.g_date
, p_person_id in number default hr_api.g_number
, p_assignment_id in number default hr_api.g_number
, p_currency_code in varchar2 default hr_api.g_varchar2
, p_distribution_amount in number default hr_api.g_number
, p_business_group_id in number default hr_api.g_number
, p_set_of_books_id in number default hr_api.g_number
, p_gl_code_combination_id in number default hr_api.g_number
, p_project_id in number default hr_api.g_number
, p_task_id in number default hr_api.g_number
, p_award_id in number default hr_api.g_number
, p_expenditure_organization_id in number default hr_api.g_number
, p_expenditure_type in varchar2 default hr_api.g_varchar2
, p_attribute_category in varchar2 default hr_api.g_varchar2
, p_attribute1 in varchar2 default hr_api.g_varchar2
, p_attribute2 in varchar2 default hr_api.g_varchar2
, p_attribute3 in varchar2 default hr_api.g_varchar2
, p_attribute4 in varchar2 default hr_api.g_varchar2
, p_attribute5 in varchar2 default hr_api.g_varchar2
, p_attribute6 in varchar2 default hr_api.g_varchar2
, p_attribute7 in varchar2 default hr_api.g_varchar2
, p_attribute8 in varchar2 default hr_api.g_varchar2
, p_attribute9 in varchar2 default hr_api.g_varchar2
, p_attribute10 in varchar2 default hr_api.g_varchar2
, p_attribute11 in varchar2 default hr_api.g_varchar2
, p_attribute12 in varchar2 default hr_api.g_varchar2
, p_attribute13 in varchar2 default hr_api.g_varchar2
, p_attribute14 in varchar2 default hr_api.g_varchar2
, p_attribute15 in varchar2 default hr_api.g_varchar2
, p_object_version_number in out nocopy number
, p_return_status out nocopy boolean
) IS
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||'update_external_effort_line';
savepoint update_external_effort_line;
psp_external_effort_lines_bk2.update_external_effort_line_b
( p_external_effort_line_id => p_external_effort_line_id
, p_batch_name => p_batch_name
, p_distribution_date => p_distribution_date
, p_person_id => p_person_id
, p_assignment_id => p_assignment_id
, p_currency_code => p_currency_code
, p_distribution_amount => p_distribution_amount
, p_business_group_id => p_business_group_id
, p_set_of_books_id => p_set_of_books_id
, p_gl_code_combination_id => p_gl_code_combination_id
, p_project_id => p_project_id
, p_task_id => p_task_id
, p_award_id => p_award_id
, p_expenditure_organization_id => p_expenditure_organization_id
, p_expenditure_type => p_expenditure_type
, p_attribute_category => p_attribute_category
, p_attribute1 => p_attribute1
, p_attribute2 => p_attribute2
, p_attribute3 => p_attribute3
, p_attribute4 => p_attribute4
, p_attribute5 => p_attribute5
, p_attribute6 => p_attribute6
, p_attribute7 => p_attribute7
, p_attribute8 => p_attribute8
, p_attribute9 => p_attribute9
, p_attribute10 => p_attribute10
, p_attribute11 => p_attribute11
, p_attribute12 => p_attribute12
, p_attribute13 => p_attribute13
, p_attribute14 => p_attribute14
, p_attribute15 => p_attribute15
, p_object_version_number => l_object_version_number
);
(p_module_name => 'update_external_effort_line'
,p_hook_type => 'BP'
);
psp_external_effort_lines_bk2.update_external_effort_line_a
( p_external_effort_line_id => p_external_effort_line_id
, p_batch_name => p_batch_name
, p_distribution_date => p_distribution_date
, p_person_id => p_person_id
, p_assignment_id => p_assignment_id
, p_currency_code => p_currency_code
, p_distribution_amount => p_distribution_amount
, p_business_group_id => p_business_group_id
, p_set_of_books_id => p_set_of_books_id
, p_gl_code_combination_id => p_gl_code_combination_id
, p_project_id => p_project_id
, p_task_id => p_task_id
, p_award_id => p_award_id
, p_expenditure_organization_id => p_expenditure_organization_id
, p_expenditure_type => p_expenditure_type
, p_attribute_category => p_attribute_category
, p_attribute1 => p_attribute1
, p_attribute2 => p_attribute2
, p_attribute3 => p_attribute3
, p_attribute4 => p_attribute4
, p_attribute5 => p_attribute5
, p_attribute6 => p_attribute6
, p_attribute7 => p_attribute7
, p_attribute8 => p_attribute8
, p_attribute9 => p_attribute9
, p_attribute10 => p_attribute10
, p_attribute11 => p_attribute11
, p_attribute12 => p_attribute12
, p_attribute13 => p_attribute13
, p_attribute14 => p_attribute14
, p_attribute15 => p_attribute15
, p_object_version_number => l_object_version_number
, p_return_status => l_return_status
);
(p_module_name => 'update_external_effort_line'
,p_hook_type => 'AP'
);
rollback to update_external_effort_line;
rollback to update_external_effort_line;
end update_external_effort_line;
procedure delete_external_effort_line
( p_validate in boolean default false
, p_external_effort_line_id in number
, p_object_version_number in out nocopy number
)
IS
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||'delete_effort_interface_line';
savepoint delete_external_effort_line;
psp_external_effort_lines_bk3.delete_external_effort_line_b
( p_external_effort_line_id => p_external_effort_line_id
, p_object_version_number => l_object_version_number
);
(p_module_name => 'delete_external_effort_line'
,p_hook_type => 'BP'
);
psp_external_effort_lines_bk3.delete_external_effort_line_a
( p_external_effort_line_id => p_external_effort_line_id
, p_object_version_number => l_object_version_number
);
(p_module_name => 'delete_external_effort_line'
,p_hook_type => 'AP'
);
rollback to delete_external_effort_line;
rollback to delete_external_effort_line;
end delete_external_effort_line;
procedure delete_external_effort_line_batch
( p_validate in boolean default false
, p_batch_name in varchar2
, p_person_id in number default hr_api.g_number
, p_assignment_id in number default hr_api.g_number
, p_return_status out nocopy boolean
)
IS
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||'delete_external_effort_line_batch';
SELECT external_effort_line_id, object_version_number
FROM psp_external_effort_lines
WHERE batch_name = p_batch_name
AND (person_id = p_person_id OR p_person_id = hr_api.g_number)
AND (assignment_id= p_assignment_id OR p_assignment_id = hr_api.g_number);
savepoint delete_external_effort_line_batch;
delete_effort_interface
( p_external_effort_line_id=> l_external_effort_line_id
, p_object_version_number => l_object_version_number
);
rollback to delete_external_effort_line_batch;
rollback to delete_external_effort_line_batch;
end delete_external_effort_line_batch;