416: returnValue integer;
417:
418: begin
419:
420: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_CONDITIONS.'||X_CONDITION_KEY,lockhandle => lockHandle);
421: returnValue := DBMS_LOCK.REQUEST(lockhandle => lockHandle,timeout => 0,release_on_commit => true);
422: if returnValue = 0 then
423: insert into AME_CONDITIONS
424: (
417:
418: begin
419:
420: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_CONDITIONS.'||X_CONDITION_KEY,lockhandle => lockHandle);
421: returnValue := DBMS_LOCK.REQUEST(lockhandle => lockHandle,timeout => 0,release_on_commit => true);
422: if returnValue = 0 then
423: insert into AME_CONDITIONS
424: (
425: CONDITION_ID,
485: lockHandle varchar2(500);
486: returnValue integer;
487: begin
488:
489: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_CONDITIONS.'||X_CONDITION_ID,lockhandle => lockHandle);
490: returnValue := DBMS_LOCK.REQUEST(lockhandle => lockHandle,timeout => 0,release_on_commit => true);
491: insert into AME_CONDITIONS
492: (
493: CONDITION_ID,
486: returnValue integer;
487: begin
488:
489: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_CONDITIONS.'||X_CONDITION_ID,lockhandle => lockHandle);
490: returnValue := DBMS_LOCK.REQUEST(lockhandle => lockHandle,timeout => 0,release_on_commit => true);
491: insert into AME_CONDITIONS
492: (
493: CONDITION_ID,
494: CONDITION_KEY,