APPS.CE_ZBA_DEAL_GENERATION dependencies on DBMS_LOCK

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

179: lockmode := 6;
180: expiration_secs := 10;
181: release_on_commit := FALSE;
182:
183: -- dbms_lock of row to deal with other locking
184: cep_standard.debug('Allocating unique');
185: dbms_lock.allocate_unique (lockname, lockhandle, expiration_secs);
186: lock_status := dbms_lock.request( lockhandle, lockmode, timeout, release_on_commit );
187:

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

181: release_on_commit := FALSE;
182:
183: -- dbms_lock of row to deal with other locking
184: cep_standard.debug('Allocating unique');
185: dbms_lock.allocate_unique (lockname, lockhandle, expiration_secs);
186: lock_status := dbms_lock.request( lockhandle, lockmode, timeout, release_on_commit );
187:
188: IF (lock_status <> 0) THEN
189: lock_status := dbms_lock.release(lockhandle);

Line 186: lock_status := dbms_lock.request( lockhandle, lockmode, timeout, release_on_commit );

182:
183: -- dbms_lock of row to deal with other locking
184: cep_standard.debug('Allocating unique');
185: dbms_lock.allocate_unique (lockname, lockhandle, expiration_secs);
186: lock_status := dbms_lock.request( lockhandle, lockmode, timeout, release_on_commit );
187:
188: IF (lock_status <> 0) THEN
189: lock_status := dbms_lock.release(lockhandle);
190: RAISE APP_EXCEPTIONS.record_lock_exception;

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

185: dbms_lock.allocate_unique (lockname, lockhandle, expiration_secs);
186: lock_status := dbms_lock.request( lockhandle, lockmode, timeout, release_on_commit );
187:
188: IF (lock_status <> 0) THEN
189: lock_status := dbms_lock.release(lockhandle);
190: RAISE APP_EXCEPTIONS.record_lock_exception;
191: END IF;
192:
193: RETURN(TRUE);

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

929: CE_ZBA_DEAL_GENERATION.csh_statement_header_id,
930: to_number(NULL),
931: 'CE_LOCK_STATEMENT_HEADER_ERR');
932: END IF; -- statement lock check
933: lock_status := dbms_lock.release(lockhandle);
934: ELSE -- check digits failed
935: cep_standard.debug('Account/Statement check digit mismatch');
936: CE_ZBA_DEAL_INF_PKG.delete_row(
937: CE_ZBA_DEAL_GENERATION.csh_statement_header_id, to_number(NULL));

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

1014: END IF;
1015: IF line_cursor%ISOPEN THEN
1016: CLOSE line_cursor;
1017: END IF;
1018: lock_status := dbms_lock.release(lockhandle);
1019: cep_standard.debug('DEBUG: sqlcode:' || sqlcode );
1020: cep_standard.debug('DEBUG: sqlerrm:' || sqlerrm);
1021: RAISE;
1022: END zba_generation;