20: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SETUPTQYVALUES_PVT';
21:
22: G_EXCEPTION_HALT_PROCESSING EXCEPTION;
23:
24: SUBTYPE ptvv_rec_type IS okl_ptl_qualitys_pub.ptvv_rec_type;
25: SUBTYPE ptvv_tbl_type IS okl_ptl_qualitys_pub.ptvv_tbl_type;
26:
27: --TEMPLATE QUALITY
28: SUBTYPE ptqv_rec_type IS okl_ptl_qualitys_pub.ptqv_rec_type;
21:
22: G_EXCEPTION_HALT_PROCESSING EXCEPTION;
23:
24: SUBTYPE ptvv_rec_type IS okl_ptl_qualitys_pub.ptvv_rec_type;
25: SUBTYPE ptvv_tbl_type IS okl_ptl_qualitys_pub.ptvv_tbl_type;
26:
27: --TEMPLATE QUALITY
28: SUBTYPE ptqv_rec_type IS okl_ptl_qualitys_pub.ptqv_rec_type;
29: SUBTYPE ptqv_tbl_type IS okl_ptl_qualitys_pub.ptqv_tbl_type;
24: SUBTYPE ptvv_rec_type IS okl_ptl_qualitys_pub.ptvv_rec_type;
25: SUBTYPE ptvv_tbl_type IS okl_ptl_qualitys_pub.ptvv_tbl_type;
26:
27: --TEMPLATE QUALITY
28: SUBTYPE ptqv_rec_type IS okl_ptl_qualitys_pub.ptqv_rec_type;
29: SUBTYPE ptqv_tbl_type IS okl_ptl_qualitys_pub.ptqv_tbl_type;
30:
31: PROCEDURE get_rec (
32: p_ptvv_rec IN ptvv_rec_type,
25: SUBTYPE ptvv_tbl_type IS okl_ptl_qualitys_pub.ptvv_tbl_type;
26:
27: --TEMPLATE QUALITY
28: SUBTYPE ptqv_rec_type IS okl_ptl_qualitys_pub.ptqv_rec_type;
29: SUBTYPE ptqv_tbl_type IS okl_ptl_qualitys_pub.ptqv_tbl_type;
30:
31: PROCEDURE get_rec (
32: p_ptvv_rec IN ptvv_rec_type,
33: x_no_data_found OUT NOCOPY BOOLEAN,