APPS.OKL_AM_TERMNT_QUOTE_PVT dependencies on OKL_TRX_QUOTES_V

Line 957: FROM OKL_TRX_QUOTES_V OTQV,

953: OTQV.partial_yn, -- RMUNJULU 3061751 Added
954: TRUNC(OTQV.creation_date), -- rmunjulu EDAT Added
955: OTQV.perdiem_amount, -- rmunjulu LOANS_ENHANCEMENT
956: OTQV.REPO_QUOTE_INDICATOR_YN -- Bug 6674730
957: FROM OKL_TRX_QUOTES_V OTQV,
958: OKL_K_HEADERS_FULL_V OKHV
959: WHERE OTQV.id = p_id
960: AND OTQV.khr_id = OKHV.id;
961:

Line 3200: p_trx_source_table => 'OKL_TRX_QUOTES_V',

3196: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.process_messages');
3197: END IF;
3198: -- Save message from stack into transaction message table
3199: OKL_AM_UTIL_PVT.process_messages(
3200: p_trx_source_table => 'OKL_TRX_QUOTES_V',
3201: p_trx_id => lp_term_rec.id,
3202: x_return_status => l_return_status);
3203: IF (is_debug_statement_on) THEN
3204: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.process_messages , return status: ' || l_return_status);

Line 3365: FROM okl_trx_quotes_v qte

3361:
3362: -- rmunjulu 4128965 Get quote details
3363: CURSOR get_qte_dtls_csr ( p_qte_id IN NUMBER) IS
3364: SELECT qte.accepted_yn
3365: FROM okl_trx_quotes_v qte
3366: WHERE qte.id = p_qte_id;
3367:
3368: -- rmunjulu 4128965
3369: get_qte_dtls_rec get_qte_dtls_csr%ROWTYPE;

Line 3544: p_trx_source_table => 'OKL_TRX_QUOTES_V',

3540: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.process_messages');
3541: END IF;
3542: -- Save message from stack into transaction message table
3543: OKL_AM_UTIL_PVT.process_messages(
3544: p_trx_source_table => 'OKL_TRX_QUOTES_V',
3545: p_trx_id => p_term_tbl(i).id,
3546: x_return_status => x_return_status);
3547: IF (is_debug_statement_on) THEN
3548: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.process_messages , return status: ' || x_return_status);

Line 3645: FROM OKL_TRX_QUOTES_V QTE

3641: -- RMUNJULU 23-JAN-03 2762065 Added cursor
3642: -- Get the quote status
3643: CURSOR get_quote_status_csr (p_qte_id IN NUMBER) IS
3644: SELECT QTE.qst_code
3645: FROM OKL_TRX_QUOTES_V QTE
3646: WHERE QTE.id = p_qte_id;
3647:
3648: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3649: l_api_name CONSTANT VARCHAR2(30) := 'submit_for_approval';

Line 3798: p_trx_source_table => 'OKL_TRX_QUOTES_V',

3794: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.process_messages');
3795: END IF;
3796: -- Save messages in database
3797: OKL_AM_UTIL_PVT.process_messages (
3798: p_trx_source_table => 'OKL_TRX_QUOTES_V',
3799: p_trx_id => p_term_rec.id,
3800: x_return_status => l_return_status);
3801: IF (is_debug_statement_on) THEN
3802: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.process_messages , return status: ' || l_return_status);

Line 4830: FROM OKL_TRX_QUOTES_V QTE

4826: -- get the contract id for the quote, since the quote line id does not
4827: -- exist during create
4828: CURSOR get_khr_id_csr (p_qte_id IN NUMBER) IS
4829: SELECT QTE.khr_id khr_id
4830: FROM OKL_TRX_QUOTES_V QTE
4831: WHERE QTE.id = p_qte_id;
4832:
4833: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4834: l_functional_currency_code VARCHAR2(15);

Line 5510: FROM OKL_TRX_QUOTES_V QTE,

5506: CURSOR get_quote_dtls_csr ( p_tql_id IN NUMBER) IS
5507: SELECT QTE.qst_code,
5508: QTE.id qte_id, -- rmunjulu Sales_Tax_Enhancement
5509: TQL.amount -- rmunjulu Sales_Tax_Enhancement
5510: FROM OKL_TRX_QUOTES_V QTE,
5511: OKL_TXL_QUOTE_LINES_V TQL
5512: WHERE TQL.id = p_tql_id
5513: AND TQL.qte_id = QTE.id;
5514:

Line 6379: FROM OKL_TRX_QUOTES_V QTE,

6375: -- Get the quote details
6376: CURSOR get_quote_dtls_csr ( p_tql_id IN NUMBER) IS
6377: SELECT QTE.qst_code,
6378: QTE.id qte_id -- rmunjulu Sales_Tax_Enhancement
6379: FROM OKL_TRX_QUOTES_V QTE,
6380: OKL_TXL_QUOTE_LINES_V TQL
6381: WHERE TQL.id = p_tql_id
6382: AND TQL.qte_id = QTE.id;
6383: