DBA Data[Home] [Help]

APPS.OKS_ARFETCH_PUB dependencies on DBMS_TRANSACTION

Line 231: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');

227: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type ;
228: l_cvmv_out_rec OKC_CVM_PVT.cvmv_rec_type ;
229:
230: BEGIN
231: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
232: x_return_status := 'S';
233: Open get_fetch_records_csr;
234: Loop
235: Fetch get_fetch_records_csr bulk collect into l_txn_id

Line 441: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

437:
438: EXCEPTION
439: WHEN OTHERS THEN
440: x_return_status := 'E';
441: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
442: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error'||SQLCODE || '- '||SQLERRM);
443: END Get_AR_RECORD;
444:
445: END OKS_ARFETCH_PUB;