85: ) IS
86: CURSOR okl_pdt_pk_csr (p_pdt_id IN NUMBER) IS
87: SELECT FROM_DATE,
88: TO_DATE
89: FROM Okl_products_V pdtv
90: WHERE pdtv.id = p_pdt_id;
91: l_okl_pdtv_pk okl_pdt_pk_csr%ROWTYPE;
92: l_pdtv_rec pdtv_rec_type;
93: BEGIN
136: ) IS
137: SELECT '1' FROM okl_k_headers_v khdr
138: WHERE khdr.pdt_id = p_pdt_id;
139:
140: CURSOR okl_pon_pdt_fk_csr (p_pdt_id IN Okl_Products_V.ID%TYPE,
141: p_date IN Okl_Products_V.TO_DATE%TYPE
142: ) IS
143: SELECT '1'
144: FROM Okl_products_V pdt
137: SELECT '1' FROM okl_k_headers_v khdr
138: WHERE khdr.pdt_id = p_pdt_id;
139:
140: CURSOR okl_pon_pdt_fk_csr (p_pdt_id IN Okl_Products_V.ID%TYPE,
141: p_date IN Okl_Products_V.TO_DATE%TYPE
142: ) IS
143: SELECT '1'
144: FROM Okl_products_V pdt
145: WHERE pdt.ID = p_pdt_id
140: CURSOR okl_pon_pdt_fk_csr (p_pdt_id IN Okl_Products_V.ID%TYPE,
141: p_date IN Okl_Products_V.TO_DATE%TYPE
142: ) IS
143: SELECT '1'
144: FROM Okl_products_V pdt
145: WHERE pdt.ID = p_pdt_id
146: AND NVL(pdt.TO_DATE, p_date) < p_date;
147:
148: CURSOR okl_pon_constraints_csr(p_opt_id IN Okl_Options_V.ID%TYPE,