APPS.OKS_ARFETCH_PUB dependencies on OKS_BILL_TRANSACTIONS

Line 163: From oks_bill_transactions btn

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

Line 256: update oks_bill_transactions

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

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

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