The following lines contain the word 'select', 'insert', 'update' or 'delete':
Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIBB.pls call okl_sib_pvt.insert_row');
okl_sib_pvt.insert_row(l_api_version,
l_init_msg_list,
l_return_status,
l_msg_count,
l_msg_data,
l_budget_line_tbl,
x_budget_line_tbl);
Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIBB.pls call okl_sib_pvt.insert_row ');
PROCEDURE update_budget_line ( p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
,p_budget_line_tbl IN budget_line_tbl
,x_budget_line_tbl OUT NOCOPY budget_line_tbl
) IS
---------------------------
-- DECLARE Local Variables
---------------------------
L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_BUDGET_PVT.UPDATE_BUDGET_LINE';
Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIBB.pls call okl_sib_pvt.update_row ');
SAVEPOINT update_budget_line_PVT;
okl_sib_pvt.update_row (l_api_version,
l_init_msg_list,
l_return_status,
l_msg_count,
l_msg_data,
l_budget_line_tbl,
x_budget_line_tbl);
Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIBB.pls call okl_sib_pvt.update_row ');
END update_budget_line;
SELECT id
,object_version_number
,sfwt_flag
,note
,budget_type_code
,effective_from_date
,decision_status_code
,budget_amount
,subsidy_pool_id
,decision_date
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,created_by
,creation_date
,last_updated_by
,last_update_date
,last_update_login
FROM OKL_SUBSIDY_POOL_BUDGETS_V
WHERE id = cp_sub_pool_budget_id;
Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIBB.pls call okl_sib_pvt.update_row ');
okl_sib_pvt.update_row(l_api_version,
l_init_msg_list,
l_return_status,
l_msg_count,
l_msg_data,
l_budget_line_rec,
x_budget_line_rec);
Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIBB.pls call okl_sib_pvt.update_row ');