186: ---DON'T REMOVE ORDER BY CLAUSE added for bug#4089706
187:
188: Cursor l_hdr_csr is
189: Select distinct hdr_id
190: From oks_ar_fetch_temp;
191:
192: CURSOR l_btl_csr(p_bill_instance_num NUMBER) IS
193: SELECT id txn_lines_id
194: ,bill_instance_number
399: END;
400:
401: Begin
402: forall k in l_hdr_id.FIRST..l_hdr_id.LAST
403: insert into oks_ar_fetch_temp o
404: ( hdr_id )
405: values ( l_hdr_id(k));
406: Exception
407: When others then
404: ( hdr_id )
405: values ( l_hdr_id(k));
406: Exception
407: When others then
408: FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert failed on OKS_AR_FETCH_TEMP , SQLERRM = '|| SQLERRM);
409: Raise;
410: End ;
411: End If;
412: Exit when get_fetch_records_csr%NOTFOUND;