APPS.OKL_TQD_PVT dependencies on OKL_TXL_QUOTE_LINES_V

Line 430: -- Description : Foreign Key validation for Okl_Txl_Quote_Lines_V

426: -------------------------------------
427: -- Start of comments
428: --
429: -- Procedure Name : validate_tql_id
430: -- Description : Foreign Key validation for Okl_Txl_Quote_Lines_V
431: -- Business Rules :
432: -- Parameters :
433: -- Version : 1.0
434: -- End of comments

Line 443: FROM Okl_Txl_Quote_Lines_V

439: CURSOR okl_tqlv_pk_csr (p_tql_id IN NUMBER) IS
440: SELECT 1
441: FROM DUAL
442: WHERE EXISTS (SELECT 'x'
443: FROM Okl_Txl_Quote_Lines_V
444: WHERE okl_txl_quote_lines_v.id = p_tql_id);
445:
446: BEGIN
447: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 444: WHERE okl_txl_quote_lines_v.id = p_tql_id);

440: SELECT 1
441: FROM DUAL
442: WHERE EXISTS (SELECT 'x'
443: FROM Okl_Txl_Quote_Lines_V
444: WHERE okl_txl_quote_lines_v.id = p_tql_id);
445:
446: BEGIN
447: x_return_status := OKC_API.G_RET_STS_SUCCESS;
448: IF (p_tql_id = OKC_API.G_MISS_NUM OR