APPS.CE_AUTO_BANK_MATCH dependencies on DBMS_LOCK

Line 6799: -- dbms_lock of row to deal with other locking

6795: lockmode := 6;
6796: expiration_secs := 10;
6797: release_on_commit := FALSE;
6798: --
6799: -- dbms_lock of row to deal with other locking
6800: --
6801: cep_standard.debug('>>CE_AUTO_BANK_MATCH.Allocating unique');
6802: dbms_lock.allocate_unique (lockname, lockhandle, expiration_secs);
6803: lock_status := dbms_lock.request( lockhandle, lockmode, timeout,

Line 6802: dbms_lock.allocate_unique (lockname, lockhandle, expiration_secs);

6798: --
6799: -- dbms_lock of row to deal with other locking
6800: --
6801: cep_standard.debug('>>CE_AUTO_BANK_MATCH.Allocating unique');
6802: dbms_lock.allocate_unique (lockname, lockhandle, expiration_secs);
6803: lock_status := dbms_lock.request( lockhandle, lockmode, timeout,
6804: release_on_commit );
6805: IF (lock_status <> 0) THEN
6806: lock_status := dbms_lock.release(lockhandle);

Line 6803: lock_status := dbms_lock.request( lockhandle, lockmode, timeout,

6799: -- dbms_lock of row to deal with other locking
6800: --
6801: cep_standard.debug('>>CE_AUTO_BANK_MATCH.Allocating unique');
6802: dbms_lock.allocate_unique (lockname, lockhandle, expiration_secs);
6803: lock_status := dbms_lock.request( lockhandle, lockmode, timeout,
6804: release_on_commit );
6805: IF (lock_status <> 0) THEN
6806: lock_status := dbms_lock.release(lockhandle);
6807: RAISE APP_EXCEPTIONS.record_lock_exception;

Line 6806: lock_status := dbms_lock.release(lockhandle);

6802: dbms_lock.allocate_unique (lockname, lockhandle, expiration_secs);
6803: lock_status := dbms_lock.request( lockhandle, lockmode, timeout,
6804: release_on_commit );
6805: IF (lock_status <> 0) THEN
6806: lock_status := dbms_lock.release(lockhandle);
6807: RAISE APP_EXCEPTIONS.record_lock_exception;
6808: END IF;
6809: cep_standard.debug('< 6810: RETURN(TRUE);

Line 10322: lock_status := dbms_lock.release(lockhandle);

10318: CE_RECONCILIATION_ERRORS_PKG.insert_row(
10319: CE_AUTO_BANK_MATCH.csh_statement_header_id,to_number(NULL),
10320: 'CE_LOCK_STATEMENT_HEADER_ERR');
10321: END IF;
10322: lock_status := dbms_lock.release(lockhandle);
10323:
10324: ELSE -- check digits failed
10325: /* error_statement_line_id := get_min_statement_line_id;
10326: CE_RECONCILIATION_ERRORS_PKG.delete_row(error_statement_line_id);

Line 10362: lock_status := dbms_lock.release(lockhandle);

10358: END IF;
10359: IF trx_code_cursor%ISOPEN THEN
10360: CLOSE trx_code_cursor;
10361: END IF;
10362: lock_status := dbms_lock.release(lockhandle);
10363: cep_standard.debug('DEBUG: sqlcode:' || sqlcode );
10364: cep_standard.debug('DEBUG: sqlerrm:' || sqlerrm);
10365: RAISE;
10366: END match_process;