The following lines contain the word 'select', 'insert', 'update' or 'delete':
OKL_CBL_PVT.insert_row(p_api_version => l_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_cblv_rec => p_cblv_rec,
x_cblv_rec => x_cblv_rec);
'okl_cbl_pvt.insert_row(rec) returned with status '||x_return_status||' id '||x_cblv_rec.id
);
END create_contract_balance; -- end of record insert api - REC
OKL_CBL_PVT.insert_row(p_api_version => l_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_cblv_tbl => p_cblv_tbl,
x_cblv_tbl => x_cblv_tbl);
'okl_cbl_pvt.insert_row (tbl) returned with status '||x_return_status
);
END create_contract_balance; -- end of table insert api - TBL
PROCEDURE update_contract_balance(
p_api_version IN NUMBER
, p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
, p_cblv_rec IN okl_cblv_rec
, x_cblv_rec OUT NOCOPY okl_cblv_rec) AS
l_api_version CONSTANT NUMBER DEFAULT 1.0;
l_api_name CONSTANT VARCHAR2(30) DEFAULT 'UPDATE_CONTRACT_BAL_REC';
l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_CONTRACT_BALANCES_PVT.UPDATE_CONTRACT_BALANCE';
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCBLB.pls call update_contract_balance(REC)');
OKL_CBL_PVT.update_row(p_api_version => l_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_cblv_rec => p_cblv_rec,
x_cblv_rec => x_cblv_rec);
'okl_cbl_pvt.update_row(rec) returned with status '||x_return_status||'id '||x_cblv_rec.id
);
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCBLB.pls call update_contract_balance(REC)');
END update_contract_balance; -- end of record update api - REC
PROCEDURE update_contract_balance(
p_api_version IN NUMBER
, p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
, p_cblv_tbl IN okl_cblv_tbl
, x_cblv_tbl OUT NOCOPY okl_cblv_tbl) AS
l_api_version CONSTANT NUMBER DEFAULT 1.0;
l_api_name CONSTANT VARCHAR2(30) DEFAULT 'UPDATE_CONTRACT_BAL_TBL';
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCBLB.pls call update_contract_balance(TBL)');
OKL_CBL_PVT.update_row(p_api_version => l_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_cblv_tbl => p_cblv_tbl,
x_cblv_tbl => x_cblv_tbl);
'okl_cbl_pvt.update_row (tbl) returned with status '||x_return_status
);
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCBLB.pls call update_contract_balance(TBL)');
END update_contract_balance; -- end of table update api - TBL
PROCEDURE delete_contract_balances(
p_api_version IN NUMBER
, p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
, p_cblv_tbl IN okl_cblv_tbl) AS
l_api_version CONSTANT NUMBER DEFAULT 1.0;
l_api_name CONSTANT VARCHAR2(30) DEFAULT 'DELETE_CONTRACT_BAL_TBL';
l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_CONTRACT_BALANCES_PVT.DELETE_CONTRACT_BALANCE';
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRCBLB.pls call delete_contract_balance(TBL)');
OKL_CBL_PVT.delete_row(p_api_version => l_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_cblv_tbl => p_cblv_tbl);
'okl_cbl_pvt.delete_row (tbl) returned with status '||x_return_status
);
okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRCBLB.pls call delete_contract_balance(TBL)');
END delete_contract_balances; -- end of table update api - TBL