10:
11: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
12: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SETUPOPTVALUES_PUB';
13:
14: SUBTYPE optv_rec_type IS okl_setupoptvalues_pvt.optv_rec_type;
15: SUBTYPE optv_tbl_type IS okl_setupoptvalues_pvt.optv_tbl_type;
16: SUBTYPE ovev_rec_type IS okl_setupoptvalues_pvt.ovev_rec_type;
17: SUBTYPE ovev_tbl_type IS okl_setupoptvalues_pvt.ovev_tbl_type;
18:
11: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
12: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SETUPOPTVALUES_PUB';
13:
14: SUBTYPE optv_rec_type IS okl_setupoptvalues_pvt.optv_rec_type;
15: SUBTYPE optv_tbl_type IS okl_setupoptvalues_pvt.optv_tbl_type;
16: SUBTYPE ovev_rec_type IS okl_setupoptvalues_pvt.ovev_rec_type;
17: SUBTYPE ovev_tbl_type IS okl_setupoptvalues_pvt.ovev_tbl_type;
18:
19: PROCEDURE get_rec(
12: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SETUPOPTVALUES_PUB';
13:
14: SUBTYPE optv_rec_type IS okl_setupoptvalues_pvt.optv_rec_type;
15: SUBTYPE optv_tbl_type IS okl_setupoptvalues_pvt.optv_tbl_type;
16: SUBTYPE ovev_rec_type IS okl_setupoptvalues_pvt.ovev_rec_type;
17: SUBTYPE ovev_tbl_type IS okl_setupoptvalues_pvt.ovev_tbl_type;
18:
19: PROCEDURE get_rec(
20: p_ovev_rec IN ovev_rec_type,
13:
14: SUBTYPE optv_rec_type IS okl_setupoptvalues_pvt.optv_rec_type;
15: SUBTYPE optv_tbl_type IS okl_setupoptvalues_pvt.optv_tbl_type;
16: SUBTYPE ovev_rec_type IS okl_setupoptvalues_pvt.ovev_rec_type;
17: SUBTYPE ovev_tbl_type IS okl_setupoptvalues_pvt.ovev_tbl_type;
18:
19: PROCEDURE get_rec(
20: p_ovev_rec IN ovev_rec_type,
21: x_return_status OUT NOCOPY VARCHAR2,