APPS.AME_SEED_UTILITY dependencies on DBMS_LOCK

Line 432: DBMS_LOCK.ALLOCATE_UNIQUE (LOCKNAME =>'AME_ACTION_TYPE_CONFIG.'||X_APPLICATION_ID||X_ACTION_TYPE_ID

428: AME_UTIL.DYNAMICPOSTAPPROVER, 2,
429: X_ORDER_NUMBER)
430: INTO X_ACTION_TYPE_ORDER_NUMBER
431: FROM DUAL;
432: DBMS_LOCK.ALLOCATE_UNIQUE (LOCKNAME =>'AME_ACTION_TYPE_CONFIG.'||X_APPLICATION_ID||X_ACTION_TYPE_ID
433: ,LOCKHANDLE => LOCKHANDLE);
434: RETURNVALUE := DBMS_LOCK.REQUEST(LOCKHANDLE => LOCKHANDLE,TIMEOUT => 0
435: ,RELEASE_ON_COMMIT => TRUE);
436: IF RETURNVALUE = 0 THEN

Line 434: RETURNVALUE := DBMS_LOCK.REQUEST(LOCKHANDLE => LOCKHANDLE,TIMEOUT => 0

430: INTO X_ACTION_TYPE_ORDER_NUMBER
431: FROM DUAL;
432: DBMS_LOCK.ALLOCATE_UNIQUE (LOCKNAME =>'AME_ACTION_TYPE_CONFIG.'||X_APPLICATION_ID||X_ACTION_TYPE_ID
433: ,LOCKHANDLE => LOCKHANDLE);
434: RETURNVALUE := DBMS_LOCK.REQUEST(LOCKHANDLE => LOCKHANDLE,TIMEOUT => 0
435: ,RELEASE_ON_COMMIT => TRUE);
436: IF RETURNVALUE = 0 THEN
437: INSERT INTO AME_ACTION_TYPE_CONFIG
438: (APPLICATION_ID

Line 491: DBMS_LOCK.ALLOCATE_UNIQUE (LOCKNAME =>'AME_APPROVAL_GROUP_CONFIG.'||X_APPLICATION_ID||X_APPROVAL_GROUP_ID

487: IF X_ORDER_NUMBER IS NULL THEN
488: X_ORDER_NUMBER := 1;
489: END IF;
490: CLOSE MAX_AG_ORDER_NUMBER_CURSOR;
491: DBMS_LOCK.ALLOCATE_UNIQUE (LOCKNAME =>'AME_APPROVAL_GROUP_CONFIG.'||X_APPLICATION_ID||X_APPROVAL_GROUP_ID
492: ,LOCKHANDLE => LOCKHANDLE);
493: RETURNVALUE := DBMS_LOCK.REQUEST(LOCKHANDLE => LOCKHANDLE,TIMEOUT => 0
494: ,RELEASE_ON_COMMIT => TRUE);
495: IF RETURNVALUE = 0 THEN

Line 493: RETURNVALUE := DBMS_LOCK.REQUEST(LOCKHANDLE => LOCKHANDLE,TIMEOUT => 0

489: END IF;
490: CLOSE MAX_AG_ORDER_NUMBER_CURSOR;
491: DBMS_LOCK.ALLOCATE_UNIQUE (LOCKNAME =>'AME_APPROVAL_GROUP_CONFIG.'||X_APPLICATION_ID||X_APPROVAL_GROUP_ID
492: ,LOCKHANDLE => LOCKHANDLE);
493: RETURNVALUE := DBMS_LOCK.REQUEST(LOCKHANDLE => LOCKHANDLE,TIMEOUT => 0
494: ,RELEASE_ON_COMMIT => TRUE);
495: IF RETURNVALUE = 0 THEN
496: INSERT INTO AME_APPROVAL_GROUP_CONFIG
497: (APPLICATION_ID