The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_order_sequence (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_okl_csh_order_rec IN okl_csh_order_rec_type
,x_okl_csh_order_rec OUT NOCOPY okl_csh_order_rec_type) IS
i NUMBER :=0;
SAVEPOINT csh_order_seq_update_rec;
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSATB.pls call Okl_Csh_Order_Seq_Pvt.insert_row ');
Okl_Csh_Order_Seq_Pvt.insert_row(
l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,lp_okl_csh_order_rec
,lx_okl_csh_order_rec);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSATB.pls call Okl_Csh_Order_Seq_Pvt.insert_row ');
ROLLBACK TO csh_order_seq_update_rec;
ROLLBACK TO csh_order_seq_update_rec;
ROLLBACK TO csh_order_seq_update_rec;
END insert_order_sequence;
PROCEDURE insert_order_sequence (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_okl_csh_order_tbl IN okl_csh_order_tbl_type
,x_okl_csh_order_tbl OUT NOCOPY okl_csh_order_tbl_type) IS
i NUMBER :=0;
SAVEPOINT csh_order_seq_update_tbl;
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSATB.pls call Okl_Csh_Order_Seq_Pvt.insert_row ');
Okl_Csh_Order_Seq_Pvt.insert_row(
l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,lp_okl_csh_order_tbl(i)
,lx_okl_csh_order_tbl(i));
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSATB.pls call Okl_Csh_Order_Seq_Pvt.insert_row ');
ROLLBACK TO csh_order_seq_update_tbl;
ROLLBACK TO csh_order_seq_update_tbl;
ROLLBACK TO csh_order_seq_update_tbl;
END insert_order_sequence;
PROCEDURE update_order_sequence (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_okl_csh_order_rec IN okl_csh_order_rec_type
,x_okl_csh_order_rec OUT NOCOPY okl_csh_order_rec_type) IS
i NUMBER :=0;
SAVEPOINT csh_order_seq_update_rec;
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSATB.pls call Okl_Csh_Order_Seq_Pvt.update_row ');
Okl_Csh_Order_Seq_Pvt.update_row(
l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,lp_okl_csh_order_rec
,lx_okl_csh_order_rec);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSATB.pls call Okl_Csh_Order_Seq_Pvt.update_row ');
ROLLBACK TO csh_order_seq_update_rec;
ROLLBACK TO csh_order_seq_update_rec;
ROLLBACK TO csh_order_seq_update_rec;
END update_order_sequence;
PROCEDURE update_order_sequence (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_okl_csh_order_tbl IN okl_csh_order_tbl_type
,x_okl_csh_order_tbl OUT NOCOPY okl_csh_order_tbl_type
) IS
i NUMBER :=0;
SELECT id
FROM OKL_STRM_TYP_ALLOCS sta
WHERE sta.STY_ID = l_sty_id
AND sta.CAT_ID = l_cat_id
AND sta.STREAM_ALLC_TYPE = 'ODD';
SELECT id
FROM OKL_STRM_TYP_ALLOCS sta
WHERE sta.STY_ID = l_sty_id
AND sta.CAT_ID = l_cat_id
AND sta.STREAM_ALLC_TYPE = 'PRO';
SELECT count(*) COUNT
FROM OKL_STRM_TYP_ALLOCS sta
WHERE sta.STY_ID = l_sty_id
AND sta.CAT_ID = l_cat_id
AND sta.STREAM_ALLC_TYPE = 'ODD';
SELECT count(*) COUNT
FROM OKL_STRM_TYP_ALLOCS sta
WHERE sta.STY_ID = l_sty_id
AND sta.CAT_ID = l_cat_id
AND sta.STREAM_ALLC_TYPE = 'PRO'
AND sta.ID is not null;
SAVEPOINT csh_order_seq_update_tbl;
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSATB.pls call Okl_Csh_Order_Seq_Pvt.update_row ');
Okl_Csh_Order_Seq_Pvt.update_row(
l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,lp_okl_csh_order_upd_tbl
,lx_okl_csh_order_upd_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSATB.pls call Okl_Csh_Order_Seq_Pvt.update_row ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSATB.pls call Okl_Csh_Order_Seq_Pvt.insert_row ');
Okl_Csh_Order_Seq_Pvt.insert_row(
l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,lp_okl_csh_order_ins_tbl
,lx_okl_csh_order_ins_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSATB.pls call Okl_Csh_Order_Seq_Pvt.insert_row ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSATB.pls call Okl_Csh_Order_Seq_Pvt.delete_row ');
Okl_Csh_Order_Seq_Pvt.delete_row(
l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,lp_okl_csh_order_del_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSATB.pls call Okl_Csh_Order_Seq_Pvt.delete_row ');
Okl_Csh_Order_Seq_Pvt.insert_row(
l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,lp_okl_csh_pro_ins_tbl
,lx_okl_csh_pro_ins_tbl);
Okl_Csh_Order_Seq_Pvt.delete_row(
l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,lp_okl_csh_pro_del_tbl);
ROLLBACK TO csh_order_seq_update_tbl;
ROLLBACK TO csh_order_seq_update_tbl;
ROLLBACK TO csh_order_seq_update_tbl;
END update_order_sequence;