APPS.AME_RULES_API dependencies on DBMS_LOCK

Line 157: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_RULES.'||X_RULE_ID,lockhandle => lockHandle);

153: is
154: lockHandle varchar2(500);
155: returnValue integer;
156: begin
157: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_RULES.'||X_RULE_ID,lockhandle => lockHandle);
158: returnValue := DBMS_LOCK.REQUEST(lockhandle => lockHandle,timeout => 0
159: ,release_on_commit => true);
160: if returnValue = 0 then
161: insert into AME_RULES

Line 158: returnValue := DBMS_LOCK.REQUEST(lockhandle => lockHandle,timeout => 0

154: lockHandle varchar2(500);
155: returnValue integer;
156: begin
157: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_RULES.'||X_RULE_ID,lockhandle => lockHandle);
158: returnValue := DBMS_LOCK.REQUEST(lockhandle => lockHandle,timeout => 0
159: ,release_on_commit => true);
160: if returnValue = 0 then
161: insert into AME_RULES
162: (

Line 257: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_ACTION_USAGES.'||X_RULE_ID||X_ACTION_ID

253: is
254: lockHandle varchar2(500);
255: returnValue integer;
256: begin
257: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_ACTION_USAGES.'||X_RULE_ID||X_ACTION_ID
258: ,lockhandle => lockHandle);
259: returnValue := DBMS_LOCK.REQUEST(lockhandle => lockHandle,timeout => 0
260: ,release_on_commit => true);
261: if returnValue = 0 then

Line 259: returnValue := DBMS_LOCK.REQUEST(lockhandle => lockHandle,timeout => 0

255: returnValue integer;
256: begin
257: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_ACTION_USAGES.'||X_RULE_ID||X_ACTION_ID
258: ,lockhandle => lockHandle);
259: returnValue := DBMS_LOCK.REQUEST(lockhandle => lockHandle,timeout => 0
260: ,release_on_commit => true);
261: if returnValue = 0 then
262: insert into AME_ACTION_USAGES
263: (