APPS.OKL_AM_TERMNT_QUOTE_PVT dependencies on OKL_TXL_QUOTE_LINES_B

Line 60: okl_txl_quote_lines_b tql

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:
64: l_return_status VARCHAR2(3);

Line 241: okl_txl_quote_lines_b tql

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:
245: -- Get asset number for line id

Line 3907: ln_asset_qty OKL_TXL_QUOTE_LINES_B.ASSET_QUANTITY%TYPE;

3903: PROCEDURE validate_qte_ln_dtls(
3904: p_qld_tbl IN OUT NOCOPY qte_ln_dtl_tbl,
3905: x_return_status OUT NOCOPY VARCHAR2) IS
3906:
3907: ln_asset_qty OKL_TXL_QUOTE_LINES_B.ASSET_QUANTITY%TYPE;
3908: ln_qte_qty OKL_TXL_QUOTE_LINES_B.QUOTE_QUANTITY%TYPE;
3909: lv_asset_number OKC_K_LINES_TL.NAME%TYPE := null;
3910: ln_dummy1 NUMBER := 0;
3911: ln_dummy2 NUMBER := 0;

Line 3908: ln_qte_qty OKL_TXL_QUOTE_LINES_B.QUOTE_QUANTITY%TYPE;

3904: p_qld_tbl IN OUT NOCOPY qte_ln_dtl_tbl,
3905: x_return_status OUT NOCOPY VARCHAR2) IS
3906:
3907: ln_asset_qty OKL_TXL_QUOTE_LINES_B.ASSET_QUANTITY%TYPE;
3908: ln_qte_qty OKL_TXL_QUOTE_LINES_B.QUOTE_QUANTITY%TYPE;
3909: lv_asset_number OKC_K_LINES_TL.NAME%TYPE := null;
3910: ln_dummy1 NUMBER := 0;
3911: ln_dummy2 NUMBER := 0;
3912: ln_quote_number OKL_TRX_QUOTES_B.QUOTE_NUMBER%TYPE := null;

Line 3936: CURSOR get_tql_csr(p_tql_id OKL_TXL_QUOTE_LINES_B.ID%TYPE) IS

3932:
3933:
3934: -- Get the asset qty, Quote qty and Asset Number
3935: -- RMUNJULU 24-JAN-03 2759726 Taken out the sts_code check
3936: CURSOR get_tql_csr(p_tql_id OKL_TXL_QUOTE_LINES_B.ID%TYPE) IS
3937: SELECT tql.asset_quantity,
3938: tql.quote_quantity,
3939: cle.name,
3940: cle.chr_id -- RMUNJULU 24-JAN-03 2759726 Added

Line 3941: FROM OKL_TXL_QUOTE_LINES_B tql,

3937: SELECT tql.asset_quantity,
3938: tql.quote_quantity,
3939: cle.name,
3940: cle.chr_id -- RMUNJULU 24-JAN-03 2759726 Added
3941: FROM OKL_TXL_QUOTE_LINES_B tql,
3942: OKC_K_LINES_V cle,
3943: OKC_LINE_STYLES_B lse
3944: WHERE tql.id = P_tql_id
3945: AND tql.qlt_code = 'AMCFIA'

Line 5058: select max(line_number) from OKL_TXL_QUOTE_LINES_B

5054: -- End (eBTax enhancement) Bug 5866207
5055: --akrangan Bug# 5485331:Start
5056: -- get the max line_number within a quote
5057: CURSOR get_max_tql_line_num_csr(p_qte_id IN NUMBER) IS
5058: select max(line_number) from OKL_TXL_QUOTE_LINES_B
5059: where qte_id = p_qte_id;
5060: l_new_line_number NUMBER;
5061: --akrangan Bug# 5485331:End
5062: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'create_quote_line';

Line 6036: OKL_TXL_QUOTE_LINES_B TQL,

6032: OKC_K_LINES_B CLE_IB,
6033: OKC_LINE_STYLES_B LSE_INST,
6034: OKC_K_LINES_B CLE_INST,
6035: OKC_LINE_STYLES_B LSE_FIN,
6036: OKL_TXL_QUOTE_LINES_B TQL,
6037: OKL_TRX_QUOTES_B QTE,
6038: OKC_K_LINES_TL CLET_FIN,
6039: OKC_K_LINES_B CLE_FIN
6040: WHERE CLE_FIN.CLE_ID IS NULL

Line 6116: OKL_TXL_QUOTE_LINES_B TQL,

6112: OKC_K_LINES_B CLE_IB,
6113: OKC_LINE_STYLES_B LSE_INST,
6114: OKC_K_LINES_B CLE_INST,
6115: OKC_LINE_STYLES_B LSE_FIN,
6116: OKL_TXL_QUOTE_LINES_B TQL,
6117: OKL_TRX_QUOTES_B QTE,
6118: OKC_K_LINES_TL CLET_FIN,
6119: OKC_K_LINES_B CLE_FIN,
6120: OKL_TXD_QUOTE_LINE_DTLS TQD