APPS.OKL_AM_TERMNT_QUOTE_PVT dependencies on OKL_TRX_QUOTES_V

Line 969: FROM OKL_TRX_QUOTES_V OTQV,

965: OTQV.partial_yn, -- RMUNJULU 3061751 Added
966: TRUNC(OTQV.creation_date), -- rmunjulu EDAT Added
967: OTQV.perdiem_amount, -- rmunjulu LOANS_ENHANCEMENT
968: OTQV.REPO_QUOTE_INDICATOR_YN -- Bug 6674730
969: FROM OKL_TRX_QUOTES_V OTQV,
970: OKL_K_HEADERS_FULL_V OKHV
971: WHERE OTQV.id = p_id
972: AND OTQV.khr_id = OKHV.id;
973:

Line 3410: p_trx_source_table => 'OKL_TRX_QUOTES_V',

3406: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.process_messages');
3407: END IF;
3408: -- Save message from stack into transaction message table
3409: OKL_AM_UTIL_PVT.process_messages(
3410: p_trx_source_table => 'OKL_TRX_QUOTES_V',
3411: p_trx_id => lp_term_rec.id,
3412: x_return_status => l_return_status);
3413: IF (is_debug_statement_on) THEN
3414: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.process_messages , return status: ' || l_return_status);

Line 3575: FROM okl_trx_quotes_v qte

3571:
3572: -- rmunjulu 4128965 Get quote details
3573: CURSOR get_qte_dtls_csr ( p_qte_id IN NUMBER) IS
3574: SELECT qte.accepted_yn
3575: FROM okl_trx_quotes_v qte
3576: WHERE qte.id = p_qte_id;
3577:
3578: -- rmunjulu 4128965
3579: get_qte_dtls_rec get_qte_dtls_csr%ROWTYPE;

Line 3754: p_trx_source_table => 'OKL_TRX_QUOTES_V',

3750: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.process_messages');
3751: END IF;
3752: -- Save message from stack into transaction message table
3753: OKL_AM_UTIL_PVT.process_messages(
3754: p_trx_source_table => 'OKL_TRX_QUOTES_V',
3755: p_trx_id => p_term_tbl(i).id,
3756: x_return_status => x_return_status);
3757: IF (is_debug_statement_on) THEN
3758: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.process_messages , return status: ' || x_return_status);

Line 3855: FROM OKL_TRX_QUOTES_V QTE

3851: -- RMUNJULU 23-JAN-03 2762065 Added cursor
3852: -- Get the quote status
3853: CURSOR get_quote_status_csr (p_qte_id IN NUMBER) IS
3854: SELECT QTE.qst_code
3855: FROM OKL_TRX_QUOTES_V QTE
3856: WHERE QTE.id = p_qte_id;
3857:
3858: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3859: l_api_name CONSTANT VARCHAR2(30) := 'submit_for_approval';

Line 4008: p_trx_source_table => 'OKL_TRX_QUOTES_V',

4004: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.process_messages');
4005: END IF;
4006: -- Save messages in database
4007: OKL_AM_UTIL_PVT.process_messages (
4008: p_trx_source_table => 'OKL_TRX_QUOTES_V',
4009: p_trx_id => p_term_rec.id,
4010: x_return_status => l_return_status);
4011: IF (is_debug_statement_on) THEN
4012: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.process_messages , return status: ' || l_return_status);

Line 5040: FROM OKL_TRX_QUOTES_V QTE

5036: -- get the contract id for the quote, since the quote line id does not
5037: -- exist during create
5038: CURSOR get_khr_id_csr (p_qte_id IN NUMBER) IS
5039: SELECT QTE.khr_id khr_id
5040: FROM OKL_TRX_QUOTES_V QTE
5041: WHERE QTE.id = p_qte_id;
5042:
5043: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
5044: l_functional_currency_code VARCHAR2(15);

Line 5720: FROM OKL_TRX_QUOTES_V QTE,

5716: CURSOR get_quote_dtls_csr ( p_tql_id IN NUMBER) IS
5717: SELECT QTE.qst_code,
5718: QTE.id qte_id, -- rmunjulu Sales_Tax_Enhancement
5719: TQL.amount -- rmunjulu Sales_Tax_Enhancement
5720: FROM OKL_TRX_QUOTES_V QTE,
5721: OKL_TXL_QUOTE_LINES_V TQL
5722: WHERE TQL.id = p_tql_id
5723: AND TQL.qte_id = QTE.id;
5724:

Line 6589: FROM OKL_TRX_QUOTES_V QTE,

6585: -- Get the quote details
6586: CURSOR get_quote_dtls_csr ( p_tql_id IN NUMBER) IS
6587: SELECT QTE.qst_code,
6588: QTE.id qte_id -- rmunjulu Sales_Tax_Enhancement
6589: FROM OKL_TRX_QUOTES_V QTE,
6590: OKL_TXL_QUOTE_LINES_V TQL
6591: WHERE TQL.id = p_tql_id
6592: AND TQL.qte_id = QTE.id;
6593: