DBA Data[Home] [Help]

APPS.OKL_SETUPPSTYPES_PVT dependencies on OKL_K_HEADERS_V

Line 134: SELECT '1' FROM okl_k_headers_v khdr

130: x_valid OUT NOCOPY BOOLEAN
131: ) IS
132: CURSOR okl_psyv_chk_upd(p_pdt_id NUMBER
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

Line 207: p_token2_value => 'okl_k_headers_v');

203: p_msg_name => G_IN_USE,
204: p_token1 => G_PARENT_TABLE_TOKEN,
205: p_token1_value => 'Okl_Prod_Strm_Types_V',
206: p_token2 => G_CHILD_TABLE_TOKEN,
207: p_token2_value => 'okl_k_headers_v');
208: x_valid := FALSE;
209: x_return_status := Okl_Api.G_RET_STS_ERROR;
210: RAISE G_EXCEPTION_HALT_PROCESSING;
211: END IF;