APPS.OKL_AM_CNTRCT_LN_TRMNT_PVT dependencies on OKL_TXD_QUOTE_LINE_DTLS

Line 1626: FROM okl_txd_quote_line_dtls txd

1622: p_tql_id IN NUMBER
1623: )
1624: IS
1625: SELECT COUNT (txd.ID) ib_lines_count
1626: FROM okl_txd_quote_line_dtls txd
1627: WHERE txd.tql_id = p_tql_id;
1628:
1629: -- Get the IB Lines for the quote_line_id (tql_id)
1630: CURSOR get_ib_lines_csr (

Line 1635: FROM okl_txd_quote_line_dtls txd

1631: p_tql_id IN NUMBER
1632: )
1633: IS
1634: SELECT txd.kle_id
1635: FROM okl_txd_quote_line_dtls txd
1636: WHERE txd.tql_id = p_tql_id;
1637:
1638: lx_txdv_tbl okl_txd_assets_pub.adpv_tbl_type;
1639: lx_txlv_rec okl_txl_assets_pub.tlpv_rec_type;

Line 1919: --OKL_TXD_QUOTE_LINE_DTLS_V, to create_split_transaction procedure.

1915: END IF;
1916:
1917: --SECHAWLA 14-JAN-03 2748110 : Modified the logic to send those ib
1918: -- line ids that do not exist in
1919: --OKL_TXD_QUOTE_LINE_DTLS_V, to create_split_transaction procedure.
1920: -- This change follows the change
1921: -- in p_split_into_units quantity, on 08-JAN-03, to send
1922: -- asset quantity minus quote quantity as split
1923: -- into units.

Line 1933: -- procedure with rows from okl_txd_quote_line_dtls table

1929: LOOP
1930: id_exists := 'F';
1931:
1932: -- Populate the input table of IB line IDs to create split transaction
1933: -- procedure with rows from okl_txd_quote_line_dtls table
1934: FOR get_ib_lines_rec IN
1935: get_ib_lines_csr (px_klev_tbl (i).p_tql_id)
1936: LOOP
1937: IF lx_clev_tbl (ib_line_id).ID =

Line 2270: -- OKL_TXD_QUOTE_LINE_DTLS_V, to create_split_transaction procedure

2266: -- SECHAWLA 08-JAN-03 2736865 Changed the logic to send (asset qty - quote qty)
2267: -- in p_split_into_units parameter, instead of sending the quote qty
2268: -- SECHAWLA 14-JAN-03 2748110 : Modified the logic to send
2269: -- those ib line ids that do not exist in
2270: -- OKL_TXD_QUOTE_LINE_DTLS_V, to create_split_transaction procedure
2271: -- RMUNJULU 2757312 MAJOR CHANGES TO this proc
2272: -- Added parameters, removed create split trn to do_split_trn
2273: -- coded for two flags to maintain split asset status
2274: -- This proc will use tmt_split_asset_yn

Line 2301: FROM okl_txd_quote_line_dtls txd

2297: p_tql_id IN NUMBER
2298: )
2299: IS
2300: SELECT COUNT (txd.ID) ib_lines_count
2301: FROM okl_txd_quote_line_dtls txd
2302: WHERE txd.tql_id = p_tql_id;
2303:
2304: -- Get the IB Lines for the quote_line_id (tql_id)
2305: CURSOR get_ib_lines_csr (

Line 2310: FROM okl_txd_quote_line_dtls txd

2306: p_tql_id IN NUMBER
2307: )
2308: IS
2309: SELECT txd.kle_id
2310: FROM okl_txd_quote_line_dtls txd
2311: WHERE txd.tql_id = p_tql_id;
2312:
2313: lx_txdv_tbl okl_txd_assets_pub.adpv_tbl_type;
2314: lx_txlv_rec okl_txl_assets_pub.tlpv_rec_type;