The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure update_strm_gen_template(
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_gtsv_rec IN gtsv_rec_type
,p_gttv_rec IN gttv_rec_type
,p_gtpv_tbl IN gtpv_tbl_type
,p_gtlv_tbl IN gtlv_tbl_type
,x_gttv_rec OUT NOCOPY gttv_rec_type -- Return the Template Info
)IS
l_api_name VARCHAR2(30):= 'update_strm_gen_template';
OKL_STRM_GEN_TEMPLATE_PVT.update_strm_gen_template(
p_api_version => l_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_gtsv_rec => p_gtsv_rec
,p_gttv_rec => p_gttv_rec
,p_gtpv_tbl => p_gtpv_tbl
,p_gtlv_tbl => p_gtlv_tbl
,x_gttv_rec => x_gttv_rec
);
Procedure update_dep_strms(
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_gtt_id IN OKL_ST_GEN_TEMPLATES.ID%type
,p_pri_sty_id IN OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID%TYPE
,p_gtlv_tbl IN gtlv_tbl_type
,x_missing_deps OUT NOCOPY VARCHAR2
,x_show_warn_flag OUT NOCOPY VARCHAR2
)IS
l_api_name VARCHAR2(30):= 'update_dep_strms';
OKL_STRM_GEN_TEMPLATE_PVT.update_dep_strms(
p_api_version => l_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_gtt_id => p_gtt_id
,p_pri_sty_id => p_pri_sty_id
,p_gtlv_tbl => p_gtlv_tbl
,x_missing_deps => x_missing_deps
,x_show_warn_flag => x_show_warn_flag
);
Procedure delete_tmpt_prc_params(
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_gtpv_tbl IN gtpv_tbl_type
) IS
l_api_name VARCHAR2(30):= 'delete_tmpt_prc_params';
OKL_STRM_GEN_TEMPLATE_PVT.delete_tmpt_prc_params(
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_gtpv_tbl => p_gtpv_tbl
);
Procedure delete_pri_tmpt_lns(
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_gtlv_tbl IN gtlv_tbl_type
)IS
l_api_name VARCHAR2(30):= 'delete_pri_tmpt_lns';
OKL_STRM_GEN_TEMPLATE_PVT.delete_pri_tmpt_lns(
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_gtlv_tbl => p_gtlv_tbl
);
Procedure delete_dep_tmpt_lns(
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_gtlv_tbl IN gtlv_tbl_type
)IS
l_api_name VARCHAR2(30):= 'delete_dep_tmpt_lns';
OKL_STRM_GEN_TEMPLATE_PVT.delete_dep_tmpt_lns(
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_gtlv_tbl => p_gtlv_tbl
);
PROCEDURE update_pri_dep_of_sgt(
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_gtsv_rec IN gtsv_rec_type
,p_gttv_rec IN gttv_rec_type
,p_gtpv_tbl IN gtpv_tbl_type
,p_pri_gtlv_tbl IN gtlv_tbl_type
,p_del_dep_gtlv_tbl IN gtlv_tbl_type
,p_ins_dep_gtlv_tbl IN gtlv_tbl_type
,x_gttv_rec OUT NOCOPY gttv_rec_type
,x_pri_purpose_list OUT NOCOPY VARCHAR2)
IS
l_api_name VARCHAR2(30):= 'update_pri_dep_of_sgt';
okl_strm_gen_template_pvt.update_pri_dep_of_sgt(
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_gtsv_rec => p_gtsv_rec,
p_gttv_rec => p_gttv_rec,
p_gtpv_tbl => p_gtpv_tbl,
p_pri_gtlv_tbl => p_pri_gtlv_tbl,
p_del_dep_gtlv_tbl => p_del_dep_gtlv_tbl,
p_ins_dep_gtlv_tbl => p_ins_dep_gtlv_tbl ,
x_gttv_rec => x_gttv_rec,
x_pri_purpose_list => x_pri_purpose_list );
END update_pri_dep_of_sgt;