APPS.OKL_SETUPPSTYPES_PVT dependencies on OKL_STRM_TYPE_V

Line 150: FROM Okl_Strm_Type_V sty

146: p_from_date IN Okl_Prod_Strm_Types_V.FROM_DATE%TYPE,
147: p_to_date IN Okl_Prod_Strm_Types_V.TO_DATE%TYPE
148: ) IS
149: SELECT '1'
150: FROM Okl_Strm_Type_V sty
151: WHERE sty.ID = p_sty_id
152: AND ((sty.START_DATE > p_from_date OR
153: p_from_date > NVL(sty.END_DATE,p_from_date)) OR
154: NVL(sty.END_DATE, p_to_date) < p_to_date);

Line 241: p_token1_value => 'Okl_Strm_Type_V',

237: IF l_row_not_found = FALSE THEN
238: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
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;

Line 291: FROM okl_strm_type_v

287: p_sty_id IN NUMBER)
288: IS
289: CURSOR okl_styv_pk_csr (p_id IN NUMBER) IS
290: SELECT '1'
291: FROM okl_strm_type_v
292: WHERE okl_strm_type_v.id = p_id;
293:
294: l_sty_status VARCHAR2(1);
295: l_row_notfound BOOLEAN := TRUE;

Line 292: WHERE okl_strm_type_v.id = p_id;

288: IS
289: CURSOR okl_styv_pk_csr (p_id IN NUMBER) IS
290: SELECT '1'
291: FROM okl_strm_type_v
292: WHERE okl_strm_type_v.id = p_id;
293:
294: l_sty_status VARCHAR2(1);
295: l_row_notfound BOOLEAN := TRUE;
296: l_token_1 VARCHAR2(1999);