The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure update_organization_account
( p_validate in boolean default false
, p_organization_account_id in number
, p_gl_code_combination_id in number
, p_project_id in number
, p_expenditure_organization_id in number
, p_expenditure_type in varchar2
, p_task_id in number
, p_award_id in number
, p_comments in varchar2
, p_attribute_category in varchar2
, p_attribute1 in varchar2
, p_attribute2 in varchar2
, p_attribute3 in varchar2
, p_attribute4 in varchar2
, p_attribute5 in varchar2
, p_attribute6 in varchar2
, p_attribute7 in varchar2
, p_attribute8 in varchar2
, p_attribute9 in varchar2
, p_attribute10 in varchar2
, p_attribute11 in varchar2
, p_attribute12 in varchar2
, p_attribute13 in varchar2
, p_attribute14 in varchar2
, p_attribute15 in varchar2
, p_set_of_books_id in number
, p_account_type_code in varchar2
, p_start_date_active in date
, p_business_group_id in number
, p_end_date_active in date
, p_organization_id in number
, p_poeta_start_date in date
, p_poeta_end_date in date
, p_funding_source_code in varchar2
, p_object_version_number in out nocopy number
, p_return_status out nocopy boolean
) is
--
-- Declare cursors and local variables
--
l_object_version_number number(9);
l_proc varchar2(72) := g_package||'update_organization_account';
savepoint update_organization_account;
psp_organization_accounts_bk2.update_organization_account_b
( p_organization_account_id => p_organization_account_id
, p_gl_code_combination_id => p_gl_code_combination_id
, p_project_id => p_project_id
, p_expenditure_organization_id => p_expenditure_organization_id
, p_expenditure_type => p_expenditure_type
, p_task_id => p_task_id
, p_award_id => p_award_id
, p_comments => p_comments
, 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_set_of_books_id => p_set_of_books_id
, p_account_type_code => p_account_type_code
, p_start_date_active => l_start_date_active
, p_business_group_id => p_business_group_id
, p_end_date_active => l_end_date_active
, p_organization_id => p_organization_id
, p_poeta_start_date => l_poeta_start_date
, p_poeta_end_date => l_poeta_end_date
, p_funding_source_code => p_funding_source_code
);
(p_module_name => 'update_organization_account'
,p_hook_type => 'BP'
);
psp_organization_accounts_bk2.update_organization_account_a
( p_organization_account_id => p_organization_account_id
, p_gl_code_combination_id => p_gl_code_combination_id
, p_project_id => p_project_id
, p_expenditure_organization_id => p_expenditure_organization_id
, p_expenditure_type => p_expenditure_type
, p_task_id => p_task_id
, p_award_id => p_award_id
, p_comments => p_comments
, 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_set_of_books_id => p_set_of_books_id
, p_account_type_code => p_account_type_code
, p_start_date_active => l_start_date_active
, p_business_group_id => p_business_group_id
, p_end_date_active => l_end_date_active
, p_organization_id => p_organization_id
, p_poeta_start_date => l_poeta_start_date
, p_poeta_end_date => l_poeta_end_date
, p_funding_source_code => p_funding_source_code
);
(p_module_name => 'update_organization_account'
,p_hook_type => 'AP'
);
rollback to update_organization_account;
rollback to update_organization_account;
end update_organization_account;
procedure delete_organization_account
( p_validate in boolean default false
, p_organization_account_id in number
, p_object_version_number in out nocopy number
, p_return_status out nocopy boolean
) is
--
-- Declare cursors and local variables
--
l_object_version_number number(9);
l_proc varchar2(72) := g_package||'delete_organization_account';
savepoint delete_organization_account;
psp_organization_accounts_bk3.delete_organization_account_b
( p_organization_account_id => p_organization_account_id
);
(p_module_name => 'delete_organization_account'
,p_hook_type => 'BP'
);
psp_organization_accounts_bk3.delete_organization_account_a
( p_organization_account_id => p_organization_account_id
);
(p_module_name => 'delete_organization_account'
,p_hook_type => 'AP'
);
rollback to delete_organization_account;
rollback to delete_organization_account;
end delete_organization_account;