APPS.OKS_ARFETCH_PUB dependencies on OKS_BILL_TRANSACTIONS

Line 159: From oks_bill_transactions btn

155: ,ralines.customer_trx_id
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

Line 252: update oks_bill_transactions

248: ,l_trx_date limit 1000;
249: If l_txn_id.COUNT > 0 then
250: Begin
251: forall i in l_txn_id.FIRST..l_txn_id.LAST
252: update oks_bill_transactions
253: set trx_date = l_trx_date(i)
254: ,trx_number = l_trx_number(i)
255: ,trx_amount = nvl(trx_amount,0) + l_extended_amount(i)
256: ,trx_class = l_type(i)

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

258: ,last_update_date = sysdate
259: where id = l_txn_id(i);
260: Exception
261: When others then
262: FND_FILE.PUT_LINE(FND_FILE.LOG,'Update failed on OKS_BILL_TRANSACTIONS , SQLERRM = '|| SQLERRM);
263: Raise;
264: End;
265:
266: BEGIN