10:
11: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
12: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SETUPOVDTEMPLATES_PUB';
13:
14: SUBTYPE optv_rec_type IS okl_setupovdtemplates_pvt.optv_rec_type;
15: SUBTYPE optv_tbl_type IS okl_setupovdtemplates_pvt.optv_tbl_type;
16: SUBTYPE ovev_rec_type IS okl_setupovdtemplates_pvt.ovev_rec_type;
17: SUBTYPE ovev_tbl_type IS okl_setupovdtemplates_pvt.ovev_tbl_type;
18: SUBTYPE ovdv_rec_type IS okl_setupovdtemplates_pvt.ovdv_rec_type;
11: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
12: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SETUPOVDTEMPLATES_PUB';
13:
14: SUBTYPE optv_rec_type IS okl_setupovdtemplates_pvt.optv_rec_type;
15: SUBTYPE optv_tbl_type IS okl_setupovdtemplates_pvt.optv_tbl_type;
16: SUBTYPE ovev_rec_type IS okl_setupovdtemplates_pvt.ovev_rec_type;
17: SUBTYPE ovev_tbl_type IS okl_setupovdtemplates_pvt.ovev_tbl_type;
18: SUBTYPE ovdv_rec_type IS okl_setupovdtemplates_pvt.ovdv_rec_type;
19: SUBTYPE ovdv_tbl_type IS okl_setupovdtemplates_pvt.ovdv_tbl_type;
12: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SETUPOVDTEMPLATES_PUB';
13:
14: SUBTYPE optv_rec_type IS okl_setupovdtemplates_pvt.optv_rec_type;
15: SUBTYPE optv_tbl_type IS okl_setupovdtemplates_pvt.optv_tbl_type;
16: SUBTYPE ovev_rec_type IS okl_setupovdtemplates_pvt.ovev_rec_type;
17: SUBTYPE ovev_tbl_type IS okl_setupovdtemplates_pvt.ovev_tbl_type;
18: SUBTYPE ovdv_rec_type IS okl_setupovdtemplates_pvt.ovdv_rec_type;
19: SUBTYPE ovdv_tbl_type IS okl_setupovdtemplates_pvt.ovdv_tbl_type;
20: SUBTYPE ovtv_rec_type IS okl_setupovdtemplates_pvt.ovtv_rec_type;
13:
14: SUBTYPE optv_rec_type IS okl_setupovdtemplates_pvt.optv_rec_type;
15: SUBTYPE optv_tbl_type IS okl_setupovdtemplates_pvt.optv_tbl_type;
16: SUBTYPE ovev_rec_type IS okl_setupovdtemplates_pvt.ovev_rec_type;
17: SUBTYPE ovev_tbl_type IS okl_setupovdtemplates_pvt.ovev_tbl_type;
18: SUBTYPE ovdv_rec_type IS okl_setupovdtemplates_pvt.ovdv_rec_type;
19: SUBTYPE ovdv_tbl_type IS okl_setupovdtemplates_pvt.ovdv_tbl_type;
20: SUBTYPE ovtv_rec_type IS okl_setupovdtemplates_pvt.ovtv_rec_type;
21: SUBTYPE ovtv_tbl_type IS okl_setupovdtemplates_pvt.ovtv_tbl_type;
14: SUBTYPE optv_rec_type IS okl_setupovdtemplates_pvt.optv_rec_type;
15: SUBTYPE optv_tbl_type IS okl_setupovdtemplates_pvt.optv_tbl_type;
16: SUBTYPE ovev_rec_type IS okl_setupovdtemplates_pvt.ovev_rec_type;
17: SUBTYPE ovev_tbl_type IS okl_setupovdtemplates_pvt.ovev_tbl_type;
18: SUBTYPE ovdv_rec_type IS okl_setupovdtemplates_pvt.ovdv_rec_type;
19: SUBTYPE ovdv_tbl_type IS okl_setupovdtemplates_pvt.ovdv_tbl_type;
20: SUBTYPE ovtv_rec_type IS okl_setupovdtemplates_pvt.ovtv_rec_type;
21: SUBTYPE ovtv_tbl_type IS okl_setupovdtemplates_pvt.ovtv_tbl_type;
22:
15: SUBTYPE optv_tbl_type IS okl_setupovdtemplates_pvt.optv_tbl_type;
16: SUBTYPE ovev_rec_type IS okl_setupovdtemplates_pvt.ovev_rec_type;
17: SUBTYPE ovev_tbl_type IS okl_setupovdtemplates_pvt.ovev_tbl_type;
18: SUBTYPE ovdv_rec_type IS okl_setupovdtemplates_pvt.ovdv_rec_type;
19: SUBTYPE ovdv_tbl_type IS okl_setupovdtemplates_pvt.ovdv_tbl_type;
20: SUBTYPE ovtv_rec_type IS okl_setupovdtemplates_pvt.ovtv_rec_type;
21: SUBTYPE ovtv_tbl_type IS okl_setupovdtemplates_pvt.ovtv_tbl_type;
22:
23: PROCEDURE get_rec(
16: SUBTYPE ovev_rec_type IS okl_setupovdtemplates_pvt.ovev_rec_type;
17: SUBTYPE ovev_tbl_type IS okl_setupovdtemplates_pvt.ovev_tbl_type;
18: SUBTYPE ovdv_rec_type IS okl_setupovdtemplates_pvt.ovdv_rec_type;
19: SUBTYPE ovdv_tbl_type IS okl_setupovdtemplates_pvt.ovdv_tbl_type;
20: SUBTYPE ovtv_rec_type IS okl_setupovdtemplates_pvt.ovtv_rec_type;
21: SUBTYPE ovtv_tbl_type IS okl_setupovdtemplates_pvt.ovtv_tbl_type;
22:
23: PROCEDURE get_rec(
24: p_ovtv_rec IN ovtv_rec_type,
17: SUBTYPE ovev_tbl_type IS okl_setupovdtemplates_pvt.ovev_tbl_type;
18: SUBTYPE ovdv_rec_type IS okl_setupovdtemplates_pvt.ovdv_rec_type;
19: SUBTYPE ovdv_tbl_type IS okl_setupovdtemplates_pvt.ovdv_tbl_type;
20: SUBTYPE ovtv_rec_type IS okl_setupovdtemplates_pvt.ovtv_rec_type;
21: SUBTYPE ovtv_tbl_type IS okl_setupovdtemplates_pvt.ovtv_tbl_type;
22:
23: PROCEDURE get_rec(
24: p_ovtv_rec IN ovtv_rec_type,
25: x_return_status OUT NOCOPY VARCHAR2,