APPS.AME_RULES_API2 dependencies on DBMS_LOCK

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

286: returnValue integer;
287: X_RULE_ID number;
288: begin
289:
290: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_RULES.'||X_RULE_KEY,lockhandle => lockHandle);
291: returnValue := DBMS_LOCK.REQUEST(lockhandle => lockHandle,timeout => 0, release_on_commit=>true);
292: if returnValue = 0 then
293: select ame_rules_s.nextval into X_RULE_ID from dual;
294: insert into AME_RULES

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

287: X_RULE_ID number;
288: begin
289:
290: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_RULES.'||X_RULE_KEY,lockhandle => lockHandle);
291: returnValue := DBMS_LOCK.REQUEST(lockhandle => lockHandle,timeout => 0, release_on_commit=>true);
292: if returnValue = 0 then
293: select ame_rules_s.nextval into X_RULE_ID from dual;
294: insert into AME_RULES
295: (

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

378: is
379: lockHandle varchar2(500);
380: returnValue integer;
381: begin
382: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_RULES.'||X_RULE_ID,lockhandle => lockHandle);
383: returnValue := DBMS_LOCK.REQUEST(lockhandle => lockHandle,timeout => 0, release_on_commit=>true);
384: if returnValue = 0 then
385: insert into AME_RULES
386: (

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

379: lockHandle varchar2(500);
380: returnValue integer;
381: begin
382: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_RULES.'||X_RULE_ID,lockhandle => lockHandle);
383: returnValue := DBMS_LOCK.REQUEST(lockhandle => lockHandle,timeout => 0, release_on_commit=>true);
384: if returnValue = 0 then
385: insert into AME_RULES
386: (
387: RULE_ID,