DBA Data[Home] [Help]

APPS.OKL_QAB_PVT dependencies on OKL_TRX_QUOTES_B

Line 611: FROM OKL_TRX_QUOTES_B qte

607: -- select the ID of the parent record from the parent
608: -- rmunjulu
609: CURSOR okl_qte_csr (p_qte_id IN NUMBER) IS
610: SELECT 'x'
611: FROM OKL_TRX_QUOTES_B qte
612: WHERE qte.id = p_qte_id;
613:
614: -- rmunjulu
615: l_val VARCHAR2(3);

Line 639: G_CHILD_TABLE_TOKEN, 'OKL_TXL_QTE_ANTCPT_BILL_V', G_PARENT_TABLE_TOKEN, 'OKL_TRX_QUOTES_B');

635: END IF;
636: CLOSE okl_qte_csr;
637: IF l_invalid_value = 'Y' THEN
638: OKC_API.set_message(G_APP_NAME, G_NO_PARENT_RECORD, G_COL_NAME_TOKEN, 'qte_id',
639: G_CHILD_TABLE_TOKEN, 'OKL_TXL_QTE_ANTCPT_BILL_V', G_PARENT_TABLE_TOKEN, 'OKL_TRX_QUOTES_B');
640: x_return_status := OKC_API.G_RET_STS_ERROR;
641: RAISE G_EXCEPTION_HALT_VALIDATION;
642: END IF;
643: END IF;