DBA Data[Home] [Help]

APPS.OKL_AM_CALCULATE_QUOTE_PVT dependencies on OKL_TRX_QUOTES_B

Line 1050: p_source_table => 'OKL_TRX_QUOTES_B'); -- SOURCE_TABLE IS OKL_TRX_QUOTES_B

1046: x_msg_count => l_msg_count,
1047: x_msg_data => l_msg_data,
1048: p_source_trx_id => p_qtev_rec.id, -- TRX_ID is QUOTE_ID
1049: p_source_trx_name => 'Estimated Billing', -- TRX_NAME IS NULL
1050: p_source_table => 'OKL_TRX_QUOTES_B'); -- SOURCE_TABLE IS OKL_TRX_QUOTES_B
1051:
1052: IF (is_debug_statement_on) THEN
1053: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1054: 'After OKL_AM_CALCULATE_QUOTE_PVT.estimate_tax calls OKL_PROCESS_SALES_TAX_PUB.calculate_sales_tax :'||l_return_status);

Line 4620: CURSOR get_qte_dtls_csr (p_qte_id OKL_TRX_QUOTES_B.ID%TYPE) IS

4616: AND l.label = cp_operand_label
4617: AND o.id = l.opd_id;
4618:
4619: -- Bug#12811901 - Added Cursor to get partial termination flag
4620: CURSOR get_qte_dtls_csr (p_qte_id OKL_TRX_QUOTES_B.ID%TYPE) IS
4621: SELECT upper(nvl(qte.partial_yn,'N')) partial_yn
4622: FROM OKL_TRX_QUOTES_B QTE
4623: WHERE QTE.ID = p_qte_id;
4624:

Line 4622: FROM OKL_TRX_QUOTES_B QTE

4618:
4619: -- Bug#12811901 - Added Cursor to get partial termination flag
4620: CURSOR get_qte_dtls_csr (p_qte_id OKL_TRX_QUOTES_B.ID%TYPE) IS
4621: SELECT upper(nvl(qte.partial_yn,'N')) partial_yn
4622: FROM OKL_TRX_QUOTES_B QTE
4623: WHERE QTE.ID = p_qte_id;
4624:
4625: l_partial_yn VARCHAR2(3);
4626: