APPS.AME_SEED_UTILITY dependencies on AME_APPROVAL_GROUP_CONFIG

Line 340: FROM AME_APPROVAL_GROUP_CONFIG

336: WHERE APPLICATION_ID = C_APPLICATION_ID
337: AND SYSDATE BETWEEN START_DATE AND NVL(END_DATE,SYSDATE);
338: CURSOR MAX_AG_ORDER_NUMBER_CURSOR(C_APPLICATION_ID INTEGER) IS
339: SELECT MAX(ORDER_NUMBER) + 1
340: FROM AME_APPROVAL_GROUP_CONFIG
341: WHERE APPLICATION_ID = C_APPLICATION_ID
342: AND SYSDATE BETWEEN START_DATE AND NVL(END_DATE,SYSDATE);
343: CURSOR COA_ACTION_TYPE_CURSOR IS
344: SELECT NULL

Line 476: FROM AME_APPROVAL_GROUP_CONFIG

472: IF X_GROUP_BASED_ACTION = 'Y' THEN
473: BEGIN
474: SELECT NULL
475: INTO X_DUMMY
476: FROM AME_APPROVAL_GROUP_CONFIG
477: WHERE SYSDATE BETWEEN START_DATE AND NVL(END_DATE,SYSDATE)
478: AND APPLICATION_ID = X_APPLICATION_ID
479: AND APPROVAL_GROUP_ID = X_APPROVAL_GROUP_ID;
480: EXCEPTION

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 496: INSERT INTO AME_APPROVAL_GROUP_CONFIG

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
498: ,APPROVAL_GROUP_ID
499: ,VOTING_REGIME
500: ,ORDER_NUMBER

Line 523: FROM AME_APPROVAL_GROUP_CONFIG

519: ,0
520: ,1
521: FROM DUAL
522: WHERE NOT EXISTS (SELECT NULL
523: FROM AME_APPROVAL_GROUP_CONFIG
524: WHERE APPROVAL_GROUP_ID = X_APPROVAL_GROUP_ID
525: AND APPLICATION_ID = X_APPLICATION_ID
526: AND SYSDATE BETWEEN START_DATE AND NVL(END_DATE - (1/86400),SYSDATE));
527: END IF;