19: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SETUPDQUALITYS_PUB';
20:
21: G_EXCEPTION_HALT_PROCESSING EXCEPTION;
22:
23: SUBTYPE pdqv_rec_type IS OKL_SETUPDQUALITYS_PVT.pdqv_rec_type;
24: SUBTYPE pdqv_tbl_type IS OKL_SETUPDQUALITYS_PVT.pdqv_tbl_type;
25:
26: SUBTYPE ptlv_rec_type IS OKL_SETUPDQUALITYS_PVT.ptlv_rec_type;
27: SUBTYPE ptlv_tbl_type IS OKL_SETUPDQUALITYS_PVT.ptlv_tbl_type;
20:
21: G_EXCEPTION_HALT_PROCESSING EXCEPTION;
22:
23: SUBTYPE pdqv_rec_type IS OKL_SETUPDQUALITYS_PVT.pdqv_rec_type;
24: SUBTYPE pdqv_tbl_type IS OKL_SETUPDQUALITYS_PVT.pdqv_tbl_type;
25:
26: SUBTYPE ptlv_rec_type IS OKL_SETUPDQUALITYS_PVT.ptlv_rec_type;
27: SUBTYPE ptlv_tbl_type IS OKL_SETUPDQUALITYS_PVT.ptlv_tbl_type;
28:
22:
23: SUBTYPE pdqv_rec_type IS OKL_SETUPDQUALITYS_PVT.pdqv_rec_type;
24: SUBTYPE pdqv_tbl_type IS OKL_SETUPDQUALITYS_PVT.pdqv_tbl_type;
25:
26: SUBTYPE ptlv_rec_type IS OKL_SETUPDQUALITYS_PVT.ptlv_rec_type;
27: SUBTYPE ptlv_tbl_type IS OKL_SETUPDQUALITYS_PVT.ptlv_tbl_type;
28:
29: PROCEDURE get_rec (
30: p_pdqv_rec IN pdqv_rec_type,
23: SUBTYPE pdqv_rec_type IS OKL_SETUPDQUALITYS_PVT.pdqv_rec_type;
24: SUBTYPE pdqv_tbl_type IS OKL_SETUPDQUALITYS_PVT.pdqv_tbl_type;
25:
26: SUBTYPE ptlv_rec_type IS OKL_SETUPDQUALITYS_PVT.ptlv_rec_type;
27: SUBTYPE ptlv_tbl_type IS OKL_SETUPDQUALITYS_PVT.ptlv_tbl_type;
28:
29: PROCEDURE get_rec (
30: p_pdqv_rec IN pdqv_rec_type,
31: x_no_data_found OUT NOCOPY BOOLEAN,