149: lockHandle varchar2(500);
150: returnValue integer;
151: begin
152:
153: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_MANDATORY_ATTRIBUTES.'||to_char(X_ATTRIBUTE_ID)
154: ||'.'||to_char(X_ACTION_TYPE_ID),lockhandle => lockHandle);
155: returnValue := DBMS_LOCK.REQUEST(lockhandle => lockHandle,timeout => 0,release_on_commit => true);
156: if returnValue = 0 then
157: insert into AME_MANDATORY_ATTRIBUTES
151: begin
152:
153: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_MANDATORY_ATTRIBUTES.'||to_char(X_ATTRIBUTE_ID)
154: ||'.'||to_char(X_ACTION_TYPE_ID),lockhandle => lockHandle);
155: returnValue := DBMS_LOCK.REQUEST(lockhandle => lockHandle,timeout => 0,release_on_commit => true);
156: if returnValue = 0 then
157: insert into AME_MANDATORY_ATTRIBUTES
158: (
159: ATTRIBUTE_ID,