APPS.OKS_ARFETCH_PUB dependencies on OKS_BILL_TXN_LINES

Line 164: ,oks_bill_txn_lines btxnl

160: ,ralines.extended_amount
161: ,ratypes.type
162: ,rahdr.trx_date
163: From oks_bill_transactions btn
164: ,oks_bill_txn_lines btxnl
165: ,RA_CUSTOMER_TRX_LINES RALINES
166: ,okc_k_headers_all_b hdr
167: ,RA_CUSTOMER_TRX_ALL RAHDR
168: ,RA_CUST_TRX_TYPES_ALL RATYPES

Line 199: FROM oks_bill_txn_lines

195: ,btn_id
196: ,bcl_id
197: ,bsl_id
198: ,trx_amount
199: FROM oks_bill_txn_lines
200: WHERE bill_instance_number = p_bill_instance_num;
201:
202: CURSOR l_ra_tax_csr(p_id NUMBER) IS
203: SELECT nvl(sum(ctl.extended_amount),0 )

Line 285: UPDATE oks_bill_txn_lines

281: amt can be added.But later on we have to identify these records******/
282:
283: IF l_txn_lines_id(i) <> nvl(l_previous_btn,0) then
284:
285: UPDATE oks_bill_txn_lines
286: SET trx_line_tax_amount = 0
287: ,trx_amount = 0
288: ,trx_line_amount = 0
289: WHERE id = l_txn_lines_id(i);

Line 302: UPDATE oks_bill_txn_lines

298: OPEN l_ra_tax_csr(l_customer_trx_line_id(i));
299: FETCH l_ra_tax_csr INTO l_tot_tax_amt;
300: CLOSE l_ra_tax_csr;
301:
302: UPDATE oks_bill_txn_lines
303: SET trx_class = l_type(i)
304: ,trx_number = l_trx_number(i)
305: ,trx_date = l_trx_date(i)
306: ,trx_line_tax_amount = nvl(trx_line_tax_amount,0) + nvl(l_tot_tax_amt,0)

Line 376: UPDATE oks_bill_txn_lines

372: END IF; ---last index chk
373:
374:
375:
376: UPDATE oks_bill_txn_lines
377: SET trx_class = l_type(i)
378: ,trx_number = l_trx_number(i)
379: ,trx_date = l_trx_date(i)
380: ,trx_amount = l_line_trx_amt

Line 397: FND_FILE.PUT_LINE(FND_FILE.LOG,'Update failed on OKS_BILL_TXN_LINES , SQLERRM = '|| SQLERRM);

393:
394:
395: EXCEPTION
396: WHEN OTHERS THEN
397: FND_FILE.PUT_LINE(FND_FILE.LOG,'Update failed on OKS_BILL_TXN_LINES , SQLERRM = '|| SQLERRM);
398: Raise;
399: END;
400:
401: Begin