[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
PROCEDURE Update_fin_cap_cost(
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_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
p_clev_rec IN clev_rec_type,
p_klev_rec IN klev_rec_type,
x_clev_rec OUT NOCOPY clev_rec_type,
x_klev_rec OUT NOCOPY klev_rec_type) IS
l_clev_fin_rec clev_rec_type;
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_FIN_CAP_COST';
savepoint Update_fin_cap_cost_pub;
OKL_CREATE_KLE_PVT.Update_fin_cap_cost(p_api_version => p_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_New_YN => P_new_yn,
p_asset_number => p_asset_number,
p_clev_rec => l_clev_fin_rec,
p_klev_rec => l_klev_fin_rec,
x_clev_rec => x_clev_rec,
x_klev_rec => x_klev_rec);
ROLLBACK TO Update_fin_cap_cost_pub;
ROLLBACK TO Update_fin_cap_cost_pub;
ROLLBACK TO Update_fin_cap_cost_pub;
END Update_fin_cap_cost;
PROCEDURE update_add_on_line(p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
p_clev_tbl IN clev_tbl_type,
p_klev_tbl IN klev_tbl_type,
p_cimv_tbl IN cimv_tbl_type,
x_clev_tbl OUT NOCOPY clev_tbl_type,
x_klev_tbl OUT NOCOPY klev_tbl_type,
x_cimv_tbl OUT NOCOPY cimv_tbl_type,
x_fin_clev_rec OUT NOCOPY clev_rec_type,
x_fin_klev_rec OUT NOCOPY klev_rec_type) IS
i NUMBER := 0;
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ADD_ON_LINE';
savepoint Update_add_on_line_pub;
OKL_CREATE_KLE_PVT.Update_add_on_line(p_api_version => p_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_New_YN => P_new_yn,
p_asset_number => p_asset_number,
p_clev_tbl => l_clev_tbl,
p_klev_tbl => l_klev_tbl,
p_cimv_tbl => l_cimv_tbl,
x_clev_tbl => x_clev_tbl,
x_klev_tbl => x_klev_tbl,
x_cimv_tbl => x_cimv_tbl,
x_fin_clev_rec => x_fin_clev_rec,
x_fin_klev_rec => x_fin_klev_rec);
ROLLBACK TO Update_add_on_line_pub;
ROLLBACK TO Update_add_on_line_pub;
ROLLBACK TO Update_add_on_line_pub;
END update_add_on_line;
PROCEDURE delete_add_on_line(p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
p_clev_tbl IN clev_tbl_type,
p_klev_tbl IN klev_tbl_type,
x_fin_clev_rec OUT NOCOPY clev_rec_type,
x_fin_klev_rec OUT NOCOPY klev_rec_type) IS
i NUMBER := 0;
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_ADD_ON_LINE';
savepoint delete_add_on_line_pub;
OKL_CREATE_KLE_PVT.delete_add_on_line(p_api_version => p_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_New_YN => P_new_yn,
p_asset_number => p_asset_number,
p_clev_tbl => l_clev_tbl,
p_klev_tbl => l_klev_tbl,
x_fin_clev_rec => x_fin_clev_rec,
x_fin_klev_rec => x_fin_klev_rec);
ROLLBACK TO delete_add_on_line_pub;
ROLLBACK TO delete_add_on_line_pub;
ROLLBACK TO delete_add_on_line_pub;
END delete_add_on_line;
PROCEDURE Update_all_line(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
p_clev_fin_rec IN clev_rec_type,
p_klev_fin_rec IN klev_rec_type,
p_clev_model_rec IN clev_rec_type,
p_cimv_model_rec IN cimv_rec_type,
p_clev_fa_rec IN clev_rec_type,
p_cimv_fa_rec IN cimv_rec_type,
p_talv_fa_rec IN talv_rec_type,
p_clev_ib_rec IN clev_rec_type,
p_itiv_ib_rec IN itiv_rec_type,
x_clev_fin_rec OUT NOCOPY clev_rec_type,
x_clev_model_rec OUT NOCOPY clev_rec_type,
x_clev_fa_rec OUT NOCOPY clev_rec_type,
x_clev_ib_rec OUT NOCOPY clev_rec_type) IS
l_clev_fin_rec clev_rec_type;
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ALL_LINE';
savepoint update_all_line_pub;
OKL_CREATE_KLE_PVT.update_all_line(p_api_version => p_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_new_yn => P_new_yn,
p_asset_number => p_asset_number,
p_clev_fin_rec => l_clev_fin_rec,
p_klev_fin_rec => l_klev_fin_rec,
p_clev_model_rec => l_clev_model_rec,
p_cimv_model_rec => l_cimv_model_rec,
p_clev_fa_rec => l_clev_fa_rec,
p_cimv_fa_rec => l_cimv_fa_rec,
p_talv_fa_rec => l_talv_fa_rec,
p_clev_ib_rec => l_clev_ib_rec,
p_itiv_ib_rec => l_itiv_ib_rec,
x_clev_fin_rec => x_clev_fin_rec,
x_clev_model_rec => x_clev_model_rec,
x_clev_fa_rec => x_clev_fa_rec,
x_clev_ib_rec => x_clev_ib_rec);
ROLLBACK TO update_all_line_pub;
ROLLBACK TO update_all_line_pub;
ROLLBACK TO update_all_line_pub;
FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_update_KLE_PUB');
END update_all_line;
FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_update_KLE_PUB');
PROCEDURE update_ints_ib_line(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
p_top_line_id IN OKC_K_LINES_V.ID%TYPE,
p_dnz_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
p_itiv_ib_tbl IN itiv_tbl_type,
x_clev_ib_tbl OUT NOCOPY clev_tbl_type,
x_itiv_ib_tbl OUT NOCOPY itiv_tbl_type) IS
l_clev_ib_tbl clev_tbl_type;
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_INST_IB_LINE';
savepoint update_ints_ib_line_pub;
OKL_CREATE_KLE_PVT.update_ints_ib_line(p_api_version => p_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_new_yn => P_new_yn,
p_asset_number => p_asset_number,
p_top_line_id => p_top_line_id,
p_dnz_chr_id => p_dnz_chr_id,
p_itiv_ib_tbl => l_itiv_ib_tbl,
x_clev_ib_tbl => x_clev_ib_tbl,
x_itiv_ib_tbl => x_itiv_ib_tbl);
ROLLBACK TO update_ints_ib_line_pub;
ROLLBACK TO update_ints_ib_line_pub;
ROLLBACK TO update_ints_ib_line_pub;
FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_update_KLE_PUB');
END update_ints_ib_line;
PROCEDURE delete_ints_ib_line(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
p_clev_ib_tbl IN clev_tbl_type,
x_clev_fin_rec OUT NOCOPY clev_rec_type,
x_klev_fin_rec OUT NOCOPY klev_rec_type,
x_cimv_model_rec OUT NOCOPY cimv_rec_type,
x_cimv_fa_rec OUT NOCOPY cimv_rec_type,
x_talv_fa_rec OUT NOCOPY talv_rec_type) IS
l_clev_ib_tbl clev_tbl_type;
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_INST_IB_LINE';
savepoint delete_inst_ib_line_pub;
OKL_CREATE_KLE_PVT.delete_ints_ib_line(p_api_version => p_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_new_yn => P_new_yn,
p_asset_number => p_asset_number,
p_clev_ib_tbl => l_clev_ib_tbl,
x_clev_fin_rec => x_clev_fin_rec,
x_klev_fin_rec => x_klev_fin_rec,
x_cimv_model_rec => x_cimv_model_rec,
x_cimv_fa_rec => x_cimv_fa_rec,
x_talv_fa_rec => x_talv_fa_rec);
ROLLBACK TO delete_inst_ib_line_pub;
ROLLBACK TO delete_inst_ib_line_pub;
ROLLBACK TO delete_inst_ib_line_pub;
FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'OKL_update_KLE_PUB');
END delete_ints_ib_line;
PROCEDURE Update_party_roles_rec(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_cplv_rec IN cplv_rec_type,
x_cplv_rec OUT NOCOPY cplv_rec_type) IS
l_cplv_rec cplv_rec_type;
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PARTY_ROLE';
savepoint Update_party_roles_pub;
OKL_CREATE_KLE_PVT.Update_party_roles_rec(p_api_version => p_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_cplv_rec => l_cplv_rec,
x_cplv_rec => x_cplv_rec);
ROLLBACK TO Update_party_roles_pub;
ROLLBACK TO Update_party_roles_pub;
ROLLBACK TO Update_party_roles_pub;
END update_party_roles_rec;
PROCEDURE update_asset_line_details(
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_txdv_tbl IN txdv_tbl_type,
x_txdv_tbl OUT NOCOPY txdv_tbl_type) IS
l_txdv_tbl txdv_tbl_type;
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TXD_ASSET_DEF';
savepoint update_asset_line_details_pub;
OKL_CREATE_KLE_PVT.update_asset_line_details(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_txdv_tbl => l_txdv_tbl,
x_txdv_tbl => x_txdv_tbl);
ROLLBACK TO update_asset_line_details_pub;
ROLLBACK TO update_asset_line_details_pub;
ROLLBACK TO update_asset_line_details_pub;
FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'update_asset_line_details_pub');
END update_asset_line_details;