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 4117: ln_asset_qty OKL_TXL_QUOTE_LINES_B.ASSET_QUANTITY%TYPE;

4113: PROCEDURE validate_qte_ln_dtls(
4114: p_qld_tbl IN OUT NOCOPY qte_ln_dtl_tbl,
4115: x_return_status OUT NOCOPY VARCHAR2) IS
4116:
4117: ln_asset_qty OKL_TXL_QUOTE_LINES_B.ASSET_QUANTITY%TYPE;
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;

Line 4118: ln_qte_qty OKL_TXL_QUOTE_LINES_B.QUOTE_QUANTITY%TYPE;

4114: p_qld_tbl IN OUT NOCOPY qte_ln_dtl_tbl,
4115: x_return_status OUT NOCOPY VARCHAR2) IS
4116:
4117: ln_asset_qty OKL_TXL_QUOTE_LINES_B.ASSET_QUANTITY%TYPE;
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;

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

4142:
4143:
4144: -- Get the asset qty, Quote qty and Asset Number
4145: -- RMUNJULU 24-JAN-03 2759726 Taken out the sts_code check
4146: CURSOR get_tql_csr(p_tql_id OKL_TXL_QUOTE_LINES_B.ID%TYPE) IS
4147: SELECT tql.asset_quantity,
4148: tql.quote_quantity,
4149: cle.name,
4150: cle.chr_id -- RMUNJULU 24-JAN-03 2759726 Added

Line 4151: FROM OKL_TXL_QUOTE_LINES_B tql,

4147: SELECT tql.asset_quantity,
4148: tql.quote_quantity,
4149: cle.name,
4150: cle.chr_id -- RMUNJULU 24-JAN-03 2759726 Added
4151: FROM OKL_TXL_QUOTE_LINES_B tql,
4152: OKC_K_LINES_V cle,
4153: OKC_LINE_STYLES_B lse
4154: WHERE tql.id = P_tql_id
4155: AND tql.qlt_code = 'AMCFIA'

Line 5268: select max(line_number) from OKL_TXL_QUOTE_LINES_B

5264: -- End (eBTax enhancement) Bug 5866207
5265: --akrangan Bug# 5485331:Start
5266: -- get the max line_number within a quote
5267: CURSOR get_max_tql_line_num_csr(p_qte_id IN NUMBER) IS
5268: select max(line_number) from OKL_TXL_QUOTE_LINES_B
5269: where qte_id = p_qte_id;
5270: l_new_line_number NUMBER;
5271: --akrangan Bug# 5485331:End
5272: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'create_quote_line';

Line 6246: OKL_TXL_QUOTE_LINES_B TQL,

6242: OKC_K_LINES_B CLE_IB,
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

Line 6326: OKL_TXL_QUOTE_LINES_B TQL,

6322: OKC_K_LINES_B CLE_IB,
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