APPS.OKL_AM_TERMNT_QUOTE_PVT dependencies on OKL_TXD_QUOTE_LINE_DTLS

Line 1002: FROM OKL_TXD_QUOTE_LINE_DTLS TXD

998: -- RMUNJULU -- 12-DEC-02 Bug # 2484327 Changes for Asset level termination
999: -- Get the count of IB lines for the quote_line_id (TQL_ID )
1000: CURSOR get_ib_lines_cnt_csr ( p_tql_id IN NUMBER) IS
1001: SELECT COUNT(TXD.id) ib_lines_count
1002: FROM OKL_TXD_QUOTE_LINE_DTLS TXD
1003: WHERE TXD.tql_id = p_tql_id;
1004:
1005:
1006:

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

1436: -- If unprocessed trn for contract exists then error end if
1437: -- If accepted qte with no trn exists for contract then error end if
1438: -- Get the assets for quote
1439: -- Loop thru assets
1440: -- If asset serialized, then count of okl_txd_quote_line_dtls
1441: -- for the TQL_ID should equal the quote quantity
1442: -- Get other quotes for asset
1443: -- Loop thru quotes
1444: -- If different quote id and not completed or canceled then

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

2282: FOR get_qte_lines_rec IN get_qte_lines_csr(lp_term_rec.id) LOOP
2283:
2284:
2285: -- *****************
2286: -- IF asset serialized, then count of okl_txd_quote_line_dtls
2287: -- for the TQL_ID should equal the quote asset quantity
2288: -- *****************
2289:
2290: -- Get if asset serialized

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

4638: -- Badrinath Kuchibholta
4639: -- Procedure Name : quote_line_dtls
4640: -- Description : Used for creation of DML on Quote Line details record
4641: -- Business Rules : After Validtion of the PL/SQL table of records, If Select YN is select
4642: -- 'Y' and tqd_id is null then we create a record in OKL_TXD_QUOTE_LINE_DTLS
4643: -- , If Select YN is N and tqd_id is not null then we delete the record in
4644: -- OKL_TXD_QUOTE_LINE_DTLS
4645: -- Parameters : PL/SQL table of record of qte_ln_dtl_tbl type
4646: -- Version : 1.0

Line 4644: -- OKL_TXD_QUOTE_LINE_DTLS

4640: -- Description : Used for creation of DML on Quote Line details record
4641: -- Business Rules : After Validtion of the PL/SQL table of records, If Select YN is select
4642: -- 'Y' and tqd_id is null then we create a record in OKL_TXD_QUOTE_LINE_DTLS
4643: -- , If Select YN is N and tqd_id is not null then we delete the record in
4644: -- OKL_TXD_QUOTE_LINE_DTLS
4645: -- Parameters : PL/SQL table of record of qte_ln_dtl_tbl type
4646: -- Version : 1.0
4647: -- History : BAKUCHIB 10-DEC-2002 Bug 2484327 Created
4648: -- End of Commnets

Line 4713: -- Create or Delete OKL_TXD_QUOTE_LINE_DTLS record

4709: END IF;
4710: IF l_qld_tbl.COUNT > 0 THEN
4711: i := l_qld_tbl.FIRST;
4712: -- looping the table of record to decide weather to
4713: -- Create or Delete OKL_TXD_QUOTE_LINE_DTLS record
4714: LOOP
4715: IF l_qld_tbl(i).select_yn = 'Y' AND
4716: (l_qld_tbl(i).tqd_id IS NULL OR
4717: l_qld_tbl(i).tqd_id = OKL_API.G_MISS_NUM) THEN

Line 6192: FROM OKL_TXD_QUOTE_LINE_DTLS TQD

6188:
6189: -- Cursor to check if quote units exists
6190: CURSOR check_quote_units_exist_csr( p_tql_id IN NUMBER) IS
6191: SELECT TQD.id
6192: FROM OKL_TXD_QUOTE_LINE_DTLS TQD
6193: WHERE TQD.tql_id = p_tql_id;
6194:
6195:
6196: -- Cursor to return data when quote units not populated -- get from IB INST

Line 6330: OKL_TXD_QUOTE_LINE_DTLS TQD

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
6332: AND CLE_FIN.CHR_ID = CLE_FIN.DNZ_CHR_ID
6333: AND CLE_FIN.ID = CLET_FIN.ID
6334: AND CLET_FIN.LANGUAGE = USERENV('LANG')