APPS.OKL_AM_TERMNT_QUOTE_PVT dependencies on OKL_TXD_QUOTE_LINE_DTLS

Line 990: FROM OKL_TXD_QUOTE_LINE_DTLS TXD

986: -- RMUNJULU -- 12-DEC-02 Bug # 2484327 Changes for Asset level termination
987: -- Get the count of IB lines for the quote_line_id (TQL_ID )
988: CURSOR get_ib_lines_cnt_csr ( p_tql_id IN NUMBER) IS
989: SELECT COUNT(TXD.id) ib_lines_count
990: FROM OKL_TXD_QUOTE_LINE_DTLS TXD
991: WHERE TXD.tql_id = p_tql_id;
992:
993:
994:

Line 1388: -- If asset serialized, then count of okl_txd_quote_line_dtls

1384: -- If unprocessed trn for contract exists then error end if
1385: -- If accepted qte with no trn exists for contract then error end if
1386: -- Get the assets for quote
1387: -- Loop thru assets
1388: -- If asset serialized, then count of okl_txd_quote_line_dtls
1389: -- for the TQL_ID should equal the quote quantity
1390: -- Get other quotes for asset
1391: -- Loop thru quotes
1392: -- If different quote id and not completed or canceled then

Line 2234: -- IF asset serialized, then count of okl_txd_quote_line_dtls

2230: FOR get_qte_lines_rec IN get_qte_lines_csr(lp_term_rec.id) LOOP
2231:
2232:
2233: -- *****************
2234: -- IF asset serialized, then count of okl_txd_quote_line_dtls
2235: -- for the TQL_ID should equal the quote asset quantity
2236: -- *****************
2237:
2238: -- Get if asset serialized

Line 4432: -- 'Y' and tqd_id is null then we create a record in OKL_TXD_QUOTE_LINE_DTLS

4428: -- Badrinath Kuchibholta
4429: -- Procedure Name : quote_line_dtls
4430: -- Description : Used for creation of DML on Quote Line details record
4431: -- Business Rules : After Validtion of the PL/SQL table of records, If Select YN is select
4432: -- 'Y' and tqd_id is null then we create a record in OKL_TXD_QUOTE_LINE_DTLS
4433: -- , If Select YN is N and tqd_id is not null then we delete the record in
4434: -- OKL_TXD_QUOTE_LINE_DTLS
4435: -- Parameters : PL/SQL table of record of qte_ln_dtl_tbl type
4436: -- Version : 1.0

Line 4434: -- OKL_TXD_QUOTE_LINE_DTLS

4430: -- Description : Used for creation of DML on Quote Line details record
4431: -- Business Rules : After Validtion of the PL/SQL table of records, If Select YN is select
4432: -- 'Y' and tqd_id is null then we create a record in OKL_TXD_QUOTE_LINE_DTLS
4433: -- , If Select YN is N and tqd_id is not null then we delete the record in
4434: -- OKL_TXD_QUOTE_LINE_DTLS
4435: -- Parameters : PL/SQL table of record of qte_ln_dtl_tbl type
4436: -- Version : 1.0
4437: -- History : BAKUCHIB 10-DEC-2002 Bug 2484327 Created
4438: -- End of Commnets

Line 4503: -- Create or Delete OKL_TXD_QUOTE_LINE_DTLS record

4499: END IF;
4500: IF l_qld_tbl.COUNT > 0 THEN
4501: i := l_qld_tbl.FIRST;
4502: -- looping the table of record to decide weather to
4503: -- Create or Delete OKL_TXD_QUOTE_LINE_DTLS record
4504: LOOP
4505: IF l_qld_tbl(i).select_yn = 'Y' AND
4506: (l_qld_tbl(i).tqd_id IS NULL OR
4507: l_qld_tbl(i).tqd_id = OKL_API.G_MISS_NUM) THEN

Line 5982: FROM OKL_TXD_QUOTE_LINE_DTLS TQD

5978:
5979: -- Cursor to check if quote units exists
5980: CURSOR check_quote_units_exist_csr( p_tql_id IN NUMBER) IS
5981: SELECT TQD.id
5982: FROM OKL_TXD_QUOTE_LINE_DTLS TQD
5983: WHERE TQD.tql_id = p_tql_id;
5984:
5985:
5986: -- Cursor to return data when quote units not populated -- get from IB INST

Line 6120: OKL_TXD_QUOTE_LINE_DTLS TQD

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
6121: WHERE CLE_FIN.CLE_ID IS NULL
6122: AND CLE_FIN.CHR_ID = CLE_FIN.DNZ_CHR_ID
6123: AND CLE_FIN.ID = CLET_FIN.ID
6124: AND CLET_FIN.LANGUAGE = USERENV('LANG')