APPS.OKL_SETUPPMVALUES_PVT dependencies on OKL_PDT_TEMPLATES_V

Line 75: -- PROCEDURE get_parent_dates for: OKL_PDT_TEMPLATES_V

71:
72: END get_rec;
73:
74: ---------------------------------------------------------------------------
75: -- PROCEDURE get_parent_dates for: OKL_PDT_TEMPLATES_V
76: ---------------------------------------------------------------------------
77:
78: PROCEDURE get_parent_dates(
79: p_pmvv_rec IN pmvv_rec_type,

Line 87: FROM Okl_pdt_templates_V ptlv

83: ) IS
84: CURSOR okl_ptl_pk_csr (p_ptl_id IN NUMBER) IS
85: SELECT FROM_DATE,
86: TO_DATE
87: FROM Okl_pdt_templates_V ptlv
88: WHERE ptlv.id = p_ptl_id;
89: l_okl_ptlv_pk okl_ptl_pk_csr%ROWTYPE;
90: l_ptlv_rec ptlv_rec_type;
91: BEGIN

Line 138: SELECT '1' FROM okl_pdt_templates_v ptvv,

134: ) IS
135:
136: CURSOR okl_pmvv_chk_csr(p_ptl_id NUMBER
137: ) IS
138: SELECT '1' FROM okl_pdt_templates_v ptvv,
139: okl_products pdtv,
140: okl_k_headers_v khdr
141: WHERE ptvv.id = p_ptl_id
142: AND ptvv.id = pdtv.ptl_id

Line 149: FROM Okl_pdt_templates_V ptl

145: CURSOR okl_pmv_ptl_fk_csr (p_ptl_id IN Okl_Products_V.ID%TYPE,
146: p_date IN Okl_Products_V.TO_DATE%TYPE
147: ) IS
148: SELECT '1'
149: FROM Okl_pdt_templates_V ptl
150: WHERE ptl.ID = p_ptl_id
151: AND NVL(ptl.TO_DATE, p_date) < p_date;
152:
153: CURSOR okl_pmv_constraints_csr (p_ptv_id IN Okl_Ptq_Values_V.ID%TYPE,