[Home] [Help]
55: qte.khr_id,
56: qte.partial_yn,
57: qte.early_termination_yn,
58: tql.qlt_code
59: FROM okl_trx_quotes_b qte,
60: okl_txl_quote_lines_b tql
61: WHERE tql.id = p_line_id
62: AND tql.qte_id = qte.id;
63:
236: qte.partial_yn,
237: qte.early_termination_yn,
238: tql.qlt_code,
239: tql.kle_id
240: FROM okl_trx_quotes_b qte,
241: okl_txl_quote_lines_b tql
242: WHERE tql.id = p_line_id
243: AND tql.qte_id = qte.id;
244:
4118: ln_qte_qty OKL_TXL_QUOTE_LINES_B.QUOTE_QUANTITY%TYPE;
4119: lv_asset_number OKC_K_LINES_TL.NAME%TYPE := null;
4120: ln_dummy1 NUMBER := 0;
4121: ln_dummy2 NUMBER := 0;
4122: ln_quote_number OKL_TRX_QUOTES_B.QUOTE_NUMBER%TYPE := null;
4123: i NUMBER := 0;
4124: l_qld_tbl qte_ln_dtl_tbl := p_qld_tbl;
4125: l_clev_tbl CLEV_TBL_TYPE;
4126: lv_sno_yn VARCHAR2(3);
4184: AND cle.lse_id = lse.id
4185: AND lse.lty_code = 'INST_ITEM');
4186:
4187: -- Get the Quote number for Qte id
4188: CURSOR validate_qte_id_csr(p_qte_id OKL_TRX_QUOTES_B.ID%TYPE) IS
4189: SELECT quote_number
4190: FROM OKL_TRX_QUOTES_B qte
4191: WHERE qte.id = p_qte_id;
4192: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'validate_qte_ln_dtls';
4186:
4187: -- Get the Quote number for Qte id
4188: CURSOR validate_qte_id_csr(p_qte_id OKL_TRX_QUOTES_B.ID%TYPE) IS
4189: SELECT quote_number
4190: FROM OKL_TRX_QUOTES_B qte
4191: WHERE qte.id = p_qte_id;
4192: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'validate_qte_ln_dtls';
4193: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
4194: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
5417: x_msg_count => x_msg_count,
5418: x_msg_data => x_msg_data,
5419: p_source_trx_id => lx_tqlv_rec.qte_id, -- TRX_ID is QUOTE_ID
5420: p_source_trx_name => 'Estimated Billing', -- TRX_NAME IS NULL
5421: p_source_table => 'OKL_TRX_QUOTES_B'); -- SOURCE_TABLE IS OKL_TRX_QUOTES_B
5422: IF (is_debug_statement_on) THEN
5423: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_PROCESS_SALES_TAX_PUB.calculate_sales_tax , return status: ' || l_return_status);
5424: END IF;
5425:
5911: x_msg_count => x_msg_count,
5912: x_msg_data => x_msg_data,
5913: p_source_trx_id => l_qte_id, -- TRX_ID is QUOTE_ID
5914: p_source_trx_name => 'Estimated Billing', -- TRX_NAME IS NULL
5915: p_source_table => 'OKL_TRX_QUOTES_B'); -- SOURCE_TABLE IS OKL_TRX_QUOTES_B
5916: IF (is_debug_statement_on) THEN
5917: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_PROCESS_SALES_TAX_PUB.calculate_sales_tax , return status: ' || l_return_status);
5918: END IF;
5919:
6243: OKC_LINE_STYLES_B LSE_INST,
6244: OKC_K_LINES_B CLE_INST,
6245: OKC_LINE_STYLES_B LSE_FIN,
6246: OKL_TXL_QUOTE_LINES_B TQL,
6247: OKL_TRX_QUOTES_B QTE,
6248: OKC_K_LINES_TL CLET_FIN,
6249: OKC_K_LINES_B CLE_FIN
6250: WHERE CLE_FIN.CLE_ID IS NULL
6251: AND CLE_FIN.CHR_ID = CLE_FIN.DNZ_CHR_ID
6323: OKC_LINE_STYLES_B LSE_INST,
6324: OKC_K_LINES_B CLE_INST,
6325: OKC_LINE_STYLES_B LSE_FIN,
6326: OKL_TXL_QUOTE_LINES_B TQL,
6327: OKL_TRX_QUOTES_B QTE,
6328: OKC_K_LINES_TL CLET_FIN,
6329: OKC_K_LINES_B CLE_FIN,
6330: OKL_TXD_QUOTE_LINE_DTLS TQD
6331: WHERE CLE_FIN.CLE_ID IS NULL
6724: x_msg_count => x_msg_count,
6725: x_msg_data => x_msg_data,
6726: p_source_trx_id => l_qte_id, -- TRX_ID is QUOTE_ID
6727: p_source_trx_name => 'Estimated Billing', -- TRX_NAME IS NULL
6728: p_source_table => 'OKL_TRX_QUOTES_B'); -- SOURCE_TABLE IS OKL_TRX_QUOTES_B
6729: IF (is_debug_statement_on) THEN
6730: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_PROCESS_SALES_TAX_PUB.calculate_sales_tax , return status: ' || l_return_status);
6731: END IF;
6732: