DBA Data[Home] [Help]

APPS.CSI_TRANSACTION_IMPORT_PVT dependencies on FND_GLOBAL

Line 202: set batch_id = -1,last_update_date = sysdate,last_updated_by = fnd_global.user_id

198: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
199:
200: -- unmark rows in csi_batch_txn_lines
201: update csi_batch_txn_lines
202: set batch_id = -1,last_update_date = sysdate,last_updated_by = fnd_global.user_id
203: where batch_id = cur_batch.batch_id;
204:
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: end if;

Line 211: set processed_flag = 1,last_update_date = sysdate,last_updated_by = fnd_global.user_id

207:
208: -- set the processed flag to 1 so that the next run of this program
209: -- will not process the rows
210: update CSI_BATCH_TXN_LINES
211: set processed_flag = 1,last_update_date = sysdate,last_updated_by = fnd_global.user_id
212: where batch_id = cur_batch.batch_id
213: and processed_flag = 0;
214:
215: end loop;

Line 230: set batch_id = -1,last_update_date = sysdate,last_updated_by = fnd_global.user_id

226: fnd_log.string(fnd_log.level_unexpected,'csi.plsql.csi_transaction_import_pvt.process_transaction_rows', 'WHEN OTHERS: ' ||SQLERRM);
227: END IF;
228:
229: update csi_batch_txn_lines
230: set batch_id = -1,last_update_date = sysdate,last_updated_by = fnd_global.user_id
231: where processed_flag = 0;
232:
233: commit;
234: RAISE;