APPS.OKL_SETUPPSTYPES_PVT dependencies on OKL_PRODUCTS_V

Line 83: FROM Okl_products_V pdtv

79: ) IS
80: CURSOR okl_pdt_pk_csr (p_pdt_id IN NUMBER) IS
81: SELECT FROM_DATE,
82: TO_DATE
83: FROM Okl_products_V pdtv
84: WHERE pdtv.id = p_pdt_id;
85: l_okl_pdtv_pk okl_pdt_pk_csr%ROWTYPE;
86: l_pdtv_rec pdtv_rec_type;
87: BEGIN

Line 137: CURSOR okl_psy_pdt_fk_csr (p_pdt_id IN Okl_Products_V.ID%TYPE,

133: ) IS
134: SELECT '1' FROM okl_k_headers_v khdr
135: WHERE khdr.pdt_id = p_pdt_id;
136:
137: CURSOR okl_psy_pdt_fk_csr (p_pdt_id IN Okl_Products_V.ID%TYPE,
138: p_date IN Okl_Products_V.TO_DATE%TYPE
139: ) IS
140: SELECT '1'
141: FROM Okl_products_V pdt

Line 138: p_date IN Okl_Products_V.TO_DATE%TYPE

134: SELECT '1' FROM okl_k_headers_v khdr
135: WHERE khdr.pdt_id = p_pdt_id;
136:
137: CURSOR okl_psy_pdt_fk_csr (p_pdt_id IN Okl_Products_V.ID%TYPE,
138: p_date IN Okl_Products_V.TO_DATE%TYPE
139: ) IS
140: SELECT '1'
141: FROM Okl_products_V pdt
142: WHERE pdt.ID = p_pdt_id

Line 141: FROM Okl_products_V pdt

137: CURSOR okl_psy_pdt_fk_csr (p_pdt_id IN Okl_Products_V.ID%TYPE,
138: p_date IN Okl_Products_V.TO_DATE%TYPE
139: ) IS
140: SELECT '1'
141: FROM Okl_products_V pdt
142: WHERE pdt.ID = p_pdt_id
143: AND NVL(pdt.TO_DATE, p_date) < p_date;
144:
145: CURSOR okl_psy_constraints_csr(p_sty_id IN Okl_Prod_Strm_Types_V.STY_ID%TYPE,

Line 243: p_token2_value => 'Okl_Prod_Strm_Types_V,Okl_Products_V');

239: p_msg_name => G_DATES_MISMATCH,
240: p_token1 => G_PARENT_TABLE_TOKEN,
241: p_token1_value => 'Okl_Strm_Type_V',
242: p_token2 => G_CHILD_TABLE_TOKEN,
243: p_token2_value => 'Okl_Prod_Strm_Types_V,Okl_Products_V');
244: x_valid := FALSE;
245: x_return_status := OKL_API.G_RET_STS_ERROR;
246: RAISE G_EXCEPTION_HALT_PROCESSING;
247: END IF;*/