DBA Data[Home] [Help]

APPS.OKL_QCO_PVT dependencies on OKL_TRX_QUOTES_V

Line 425: FROM Okl_Trx_Quotes_V

421: l_dummy_var VARCHAR2(1) := '?' ;
422: l_dummy_req_var VARCHAR2(1) := '?' ;
423: CURSOR okl_qcov_qtev_fk_csr (p_id IN NUMBER) IS
424: SELECT 'x'
425: FROM Okl_Trx_Quotes_V
426: WHERE okl_trx_quotes_v.id = p_id;
427:
428: CURSOR okl_qcov_trxv_fk_csr (p_id IN NUMBER) IS
429: SELECT 'x'

Line 426: WHERE okl_trx_quotes_v.id = p_id;

422: l_dummy_req_var VARCHAR2(1) := '?' ;
423: CURSOR okl_qcov_qtev_fk_csr (p_id IN NUMBER) IS
424: SELECT 'x'
425: FROM Okl_Trx_Quotes_V
426: WHERE okl_trx_quotes_v.id = p_id;
427:
428: CURSOR okl_qcov_trxv_fk_csr (p_id IN NUMBER) IS
429: SELECT 'x'
430: FROM OKL_TRX_REQUESTS

Line 463: 'OKL_TRX_QUOTES_V OR OKL_TRX_REQUESTS');

459: 'qte_id',
460: g_child_table_token ,
461: 'OKL_TRX_QTE_CF_OBJECTS_V',
462: g_parent_table_token ,
463: 'OKL_TRX_QUOTES_V OR OKL_TRX_REQUESTS');
464: l_return_status := OKC_API.G_RET_STS_ERROR;
465: END IF;
466:
467: END IF;

Line 712: FROM Okl_Trx_Quotes_V

708: l_okl_qcov_cfov_fk okl_qcov_cfov_fk_csr%ROWTYPE;
709:
710: CURSOR okl_qcov_qtev_fk_csr (p_id IN NUMBER) IS
711: SELECT 'x'
712: FROM Okl_Trx_Quotes_V
713: WHERE okl_trx_quotes_v.id = p_id;
714: l_okl_qcov_qtev_fk okl_qcov_qtev_fk_csr%ROWTYPE;
715:
716: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 713: WHERE okl_trx_quotes_v.id = p_id;

709:
710: CURSOR okl_qcov_qtev_fk_csr (p_id IN NUMBER) IS
711: SELECT 'x'
712: FROM Okl_Trx_Quotes_V
713: WHERE okl_trx_quotes_v.id = p_id;
714: l_okl_qcov_qtev_fk okl_qcov_qtev_fk_csr%ROWTYPE;
715:
716: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
717: l_row_notfound BOOLEAN := TRUE;