DBA Data[Home] [Help]

APPS.AME_MAN_ATTRIBUTES_API dependencies on DBMS_LOCK

Line 153: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_MANDATORY_ATTRIBUTES.'||to_char(X_ATTRIBUTE_ID)

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

Line 155: returnValue := DBMS_LOCK.REQUEST(lockhandle => lockHandle,timeout => 0,release_on_commit => true);

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,