20: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SETUPPQYVALUES_PVT';
21:
22: G_EXCEPTION_HALT_PROCESSING EXCEPTION;
23:
24: SUBTYPE qvev_rec_type IS okl_pdt_qualitys_pub.qvev_rec_type;
25: SUBTYPE qvev_tbl_type IS okl_pdt_qualitys_pub.qvev_tbl_type;
26:
27: SUBTYPE pqyv_rec_type IS okl_pdt_qualitys_pub.pqyv_rec_type;
28: SUBTYPE pqyv_tbl_type IS okl_pdt_qualitys_pub.pqyv_tbl_type;
21:
22: G_EXCEPTION_HALT_PROCESSING EXCEPTION;
23:
24: SUBTYPE qvev_rec_type IS okl_pdt_qualitys_pub.qvev_rec_type;
25: SUBTYPE qvev_tbl_type IS okl_pdt_qualitys_pub.qvev_tbl_type;
26:
27: SUBTYPE pqyv_rec_type IS okl_pdt_qualitys_pub.pqyv_rec_type;
28: SUBTYPE pqyv_tbl_type IS okl_pdt_qualitys_pub.pqyv_tbl_type;
29:
23:
24: SUBTYPE qvev_rec_type IS okl_pdt_qualitys_pub.qvev_rec_type;
25: SUBTYPE qvev_tbl_type IS okl_pdt_qualitys_pub.qvev_tbl_type;
26:
27: SUBTYPE pqyv_rec_type IS okl_pdt_qualitys_pub.pqyv_rec_type;
28: SUBTYPE pqyv_tbl_type IS okl_pdt_qualitys_pub.pqyv_tbl_type;
29:
30: PROCEDURE get_rec (
31: p_qvev_rec IN qvev_rec_type,
24: SUBTYPE qvev_rec_type IS okl_pdt_qualitys_pub.qvev_rec_type;
25: SUBTYPE qvev_tbl_type IS okl_pdt_qualitys_pub.qvev_tbl_type;
26:
27: SUBTYPE pqyv_rec_type IS okl_pdt_qualitys_pub.pqyv_rec_type;
28: SUBTYPE pqyv_tbl_type IS okl_pdt_qualitys_pub.pqyv_tbl_type;
29:
30: PROCEDURE get_rec (
31: p_qvev_rec IN qvev_rec_type,
32: x_no_data_found OUT NOCOPY BOOLEAN,