APPS.OKS_ARFETCH_PUB dependencies on OKS_BILL_TXN_LINES

Line 160: ,oks_bill_txn_lines btxnl

156: ,ralines.extended_amount
157: ,ratypes.type
158: ,rahdr.trx_date
159: From oks_bill_transactions btn
160: ,oks_bill_txn_lines btxnl
161: ,RA_CUSTOMER_TRX_LINES RALINES
162: ,okc_k_headers_all_b hdr
163: ,RA_CUSTOMER_TRX_ALL RAHDR
164: ,RA_CUST_TRX_TYPES_ALL RATYPES

Line 195: FROM oks_bill_txn_lines

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

Line 281: UPDATE oks_bill_txn_lines

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

Line 298: UPDATE oks_bill_txn_lines

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

Line 372: UPDATE oks_bill_txn_lines

368: END IF; ---last index chk
369:
370:
371:
372: UPDATE oks_bill_txn_lines
373: SET trx_class = l_type(i)
374: ,trx_number = l_trx_number(i)
375: ,trx_date = l_trx_date(i)
376: ,trx_amount = l_line_trx_amt

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

389:
390:
391: EXCEPTION
392: WHEN OTHERS THEN
393: FND_FILE.PUT_LINE(FND_FILE.LOG,'Update failed on OKS_BILL_TXN_LINES , SQLERRM = '|| SQLERRM);
394: Raise;
395: END;
396:
397: Begin