The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT id
,object_version_number
,sfwt_flag
,pool_type_code
,subsidy_pool_name
,short_description
,description
,effective_from_date
,effective_to_date
,currency_code
,currency_conversion_type
,decision_status_code
,subsidy_pool_id
,reporting_pool_limit
,total_budgets
,total_subsidy_amount
,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_POOLS_V
WHERE id = cp_pool_id;
Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.insert_row ');
okl_sip_pvt.insert_row( l_api_version,
l_init_msg_list,
l_return_status,
l_msg_count,
l_msg_data,
l_sub_pool_rec,
x_sub_pool_rec);
Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.insert_row ');
PROCEDURE update_sub_pool ( 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_sub_pool_rec IN subsidy_pool_rec
,x_sub_pool_rec OUT NOCOPY subsidy_pool_rec
) IS
---------------------------
-- DECLARE Local Variables
---------------------------
L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.UPDATE_SUB_POOL';
l_api_name CONSTANT VARCHAR2(30) := 'update_sub_pool';
SELECT effective_to_date
FROM okl_subsidy_pools_v
WHERE id = cp_pool_id;
SELECT 'X'
FROM okl_subsidy_pools_v pool, okl_subsidies_b sub
WHERE sub.subsidy_pool_id = pool.id
AND pool.id = cp_pool_id
AND (
NOT ((pool.effective_from_date BETWEEN sub.effective_from_date AND NVL(sub.effective_to_date,(TO_DATE('1','j') + 5300000)))
OR (sub.effective_from_date BETWEEN pool.effective_from_date AND cp_effective_to))
);
SELECT max(TRUNC(trx_date))
FROM okl_trx_subsidy_pools
WHERE subsidy_pool_id = cp_pool_id;
Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
SAVEPOINT update_sub_pool_PVT;
okl_sip_pvt.update_row(l_api_version,
l_init_msg_list,
l_return_status,
l_msg_count,
l_msg_data,
l_sub_pool_rec,
x_sub_pool_rec);
Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
END update_sub_pool;
Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
okl_sip_pvt.update_row(l_api_version,
l_init_msg_list,
l_return_status,
l_msg_count,
l_msg_data,
l_sub_pool_rec,
x_sub_pool_rec);
Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
PROCEDURE update_total_budget ( 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_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE,
p_total_budget_amt IN okl_subsidy_pools_b.total_budgets%TYPE ) IS
---------------------------
-- DECLARE Local Variables
---------------------------
L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.UPDATE_TOTAL_BUDGET';
l_api_name CONSTANT VARCHAR2(30) := 'update_total_budget';
Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
SAVEPOINT update_total_budget_PVT;
okl_sip_pvt.update_row(l_api_version,
l_init_msg_list,
l_return_status,
l_msg_count,
l_msg_data,
l_sub_pool_rec,
x_sub_pool_rec);
Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
END update_total_budget;
PROCEDURE update_subsidy_amount ( 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_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE,
p_total_subsidy_amt IN okl_subsidy_pools_b.total_subsidy_amount%TYPE) IS
---------------------------
-- DECLARE Local Variables
---------------------------
L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.UPDATE_SUBSIDY_AMOUNT';
l_api_name CONSTANT VARCHAR2(30) := 'update_subsidy_amount';
Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
SAVEPOINT update_subsidy_amount_PVT;
okl_sip_pvt.update_row(l_api_version,
l_init_msg_list,
l_return_status,
l_msg_count,
l_msg_data,
l_sub_pool_rec,
x_sub_pool_rec);
Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
END update_subsidy_amount;
Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');
okl_sip_pvt.update_row(l_api_version,
l_init_msg_list,
l_return_status,
l_msg_count,
l_msg_data,
l_sub_pool_rec,
x_sub_pool_rec);
Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSIPB.pls call okl_sip_pvt.update_row ');