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