The following lines contain the word 'select', 'insert', 'update' or 'delete':
select id, priced_yn from okc_line_styles_b
Connect by prior id = lse_parent_id
start with id = p_id;
OKC_LINE_STYLES_PUB.UPDATE_LINE_STYLES(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_lsev_rec,
lx_lsev_rec);
select id, priced_yn from okc_line_styles_b
connect by prior lse_parent_id = id
start with id = p_id;
OKC_LINE_STYLES_PUB.UPDATE_LINE_STYLES(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_lsev_rec,
lx_lsev_rec);
select id, item_to_price_yn from okc_line_styles_b
Connect by prior id = lse_parent_id
start with id = p_id;
OKC_LINE_STYLES_PUB.UPDATE_LINE_STYLES(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_lsev_rec,
lx_lsev_rec);
select id, item_to_price_yn from okc_line_styles_b
connect by prior lse_parent_id = id
start with id = p_id;
OKC_LINE_STYLES_PUB.UPDATE_LINE_STYLES(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_lsev_rec,
lx_lsev_rec);
select id, price_basis_yn from okc_line_styles_b
Connect by prior id = lse_parent_id
start with id = p_id;
OKC_LINE_STYLES_PUB.UPDATE_LINE_STYLES(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_lsev_rec,
lx_lsev_rec);
select id, price_basis_yn from okc_line_styles_b
connect by prior lse_parent_id = id
start with id = p_id;
OKC_LINE_STYLES_PUB.UPDATE_LINE_STYLES(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_lsev_rec,
lx_lsev_rec);
select OKC_API.G_RET_STS_ERROR from okc_k_lines_b where lse_id=p_id;
select OKC_API.G_RET_STS_ERROR from okc_line_style_roles where lse_id=p_id;
select OKC_API.G_RET_STS_ERROR from okc_lse_rule_groups where lse_id=p_id;
select OKC_API.G_RET_STS_ERROR from okc_subclass_top_line where lse_id=p_id;
select OKC_API.G_RET_STS_ERROR from okc_line_style_sources where lse_id=p_id;
select OKC_API.G_RET_STS_ERROR from okc_val_line_operations where lse_id=p_id;
PROCEDURE DELETE_SUB_LINES(
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_lsev_rec IN lsev_rec_type) IS
l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
select id from okc_line_styles_b where lse_parent_id=p_id;
OKC_LINE_STYLES_PUB.DELETE_LINE_STYLES(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_lsev_rec);
END DELETE_SUB_LINES;
PROCEDURE DELETE_SOURCES(
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_lsev_rec IN lsev_rec_type) IS
l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
select lse_id,jtot_object_code from okc_line_style_sources where lse_id=p_id;
OKC_LINE_STYLES_PUB.DELETE_LINE_STYLE_SOURCES(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_lssv_rec);
END DELETE_SOURCES;
PROCEDURE DELETE_VAL_OPS(
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_lsev_rec IN lsev_rec_type) IS
l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
select lse_id from okc_val_line_operations where lse_id=p_id;
OKC_LINE_STYLES_PUB.DELETE_VAL_LINE_OPERATION(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_vlov_rec);
END DELETE_VAL_OPS;
okc_lse_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_lsev_rec,
x_lsev_rec);
PROCEDURE UPDATE_LINE_STYLES(
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_lsev_rec IN lsev_rec_type,
x_lsev_rec OUT NOCOPY lsev_rec_type) IS
l_excp_error EXCEPTION;
DELETE_SOURCES(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_lsev_rec);
okc_lse_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_lsev_rec,
x_lsev_rec);
--If the updated line has priced_yn set to 'Y' then set its parent's to 'N'
CHANGE_PRICED_FOR_PARENT(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
x_lsev_rec);
END UPDATE_LINE_STYLES;
PROCEDURE DELETE_LINE_STYLES(
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_lsev_rec IN lsev_rec_type) IS
l_excp_error EXCEPTION;
DELETE_SUB_LINES(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_lsev_rec);
DELETE_VAL_OPS(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_lsev_rec);
DELETE_SOURCES(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_lsev_rec);
okc_lse_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_lsev_rec);
END DELETE_LINE_STYLES;
okc_lss_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_lssv_rec,
x_lssv_rec);
PROCEDURE UPDATE_LINE_STYLE_SOURCES(
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_lssv_rec IN lssv_rec_type,
x_lssv_rec OUT NOCOPY lssv_rec_type) IS
BEGIN
okc_lss_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_lssv_rec,
x_lssv_rec);
END UPDATE_LINE_STYLE_SOURCES;
PROCEDURE DELETE_LINE_STYLE_SOURCES(
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_lssv_rec IN lssv_rec_type) IS
BEGIN
okc_lss_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_lssv_rec);
END DELETE_LINE_STYLE_SOURCES;
okc_vlo_pvt.insert_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_vlov_rec,
x_vlov_rec);
PROCEDURE UPDATE_VAL_LINE_OPERATION(
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_vlov_rec IN vlov_rec_type,
x_vlov_rec OUT NOCOPY vlov_rec_type) IS
BEGIN
okc_vlo_pvt.update_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_vlov_rec,
x_vlov_rec);
END UPDATE_VAL_LINE_OPERATION;
PROCEDURE DELETE_VAL_LINE_OPERATION(
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_vlov_rec IN vlov_rec_type) IS
BEGIN
okc_vlo_pvt.delete_row(
p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_vlov_rec);
END DELETE_VAL_LINE_OPERATION;