17: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SETUPPOPTIONS_PUB';
18:
19: G_EXCEPTION_HALT_PROCESSING EXCEPTION;
20:
21: SUBTYPE ponv_rec_type IS OKL_SETUPPOPTIONS_PVT.ponv_rec_type;
22: SUBTYPE ponv_tbl_type IS OKL_SETUPPOPTIONS_PVT.ponv_tbl_type;
23:
24: -- FOR PRODUCTS
25: SUBTYPE pdtv_rec_type IS OKL_SETUPPOPTIONS_PVT.pdtv_rec_type;
18:
19: G_EXCEPTION_HALT_PROCESSING EXCEPTION;
20:
21: SUBTYPE ponv_rec_type IS OKL_SETUPPOPTIONS_PVT.ponv_rec_type;
22: SUBTYPE ponv_tbl_type IS OKL_SETUPPOPTIONS_PVT.ponv_tbl_type;
23:
24: -- FOR PRODUCTS
25: SUBTYPE pdtv_rec_type IS OKL_SETUPPOPTIONS_PVT.pdtv_rec_type;
26: SUBTYPE pdtv_tbl_type IS OKL_SETUPPOPTIONS_PVT.pdtv_tbl_type;
21: SUBTYPE ponv_rec_type IS OKL_SETUPPOPTIONS_PVT.ponv_rec_type;
22: SUBTYPE ponv_tbl_type IS OKL_SETUPPOPTIONS_PVT.ponv_tbl_type;
23:
24: -- FOR PRODUCTS
25: SUBTYPE pdtv_rec_type IS OKL_SETUPPOPTIONS_PVT.pdtv_rec_type;
26: SUBTYPE pdtv_tbl_type IS OKL_SETUPPOPTIONS_PVT.pdtv_tbl_type;
27:
28: PROCEDURE get_rec (
29: p_ponv_rec IN ponv_rec_type,
22: SUBTYPE ponv_tbl_type IS OKL_SETUPPOPTIONS_PVT.ponv_tbl_type;
23:
24: -- FOR PRODUCTS
25: SUBTYPE pdtv_rec_type IS OKL_SETUPPOPTIONS_PVT.pdtv_rec_type;
26: SUBTYPE pdtv_tbl_type IS OKL_SETUPPOPTIONS_PVT.pdtv_tbl_type;
27:
28: PROCEDURE get_rec (
29: p_ponv_rec IN ponv_rec_type,
30: x_return_status OUT NOCOPY VARCHAR2,