APPS.AME_SEED_UTILITY dependencies on AME_ACTION_TYPE_CONFIG

Line 335: FROM AME_ACTION_TYPE_CONFIG

331: AND (SYSDATE BETWEEN AAU.START_DATE AND NVL(AAU.END_DATE,SYSDATE) OR
332: AAU.START_DATE > SYSDATE AND NVL(AAU.END_DATE,AAU.START_DATE + (1/86400)) < AAU.START_DATE);
333: CURSOR MAX_AT_ORDER_NUMBER_CURSOR(C_APPLICATION_ID INTEGER) IS
334: SELECT MAX(ORDER_NUMBER) + 1
335: FROM AME_ACTION_TYPE_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

Line 396: FROM AME_ACTION_TYPE_CONFIG

392: EXIT WHEN APPLICATION_USING_RULE_CURSOR%NOTFOUND;
393: BEGIN
394: SELECT NULL
395: INTO X_DUMMY
396: FROM AME_ACTION_TYPE_CONFIG
397: WHERE ACTION_TYPE_ID = X_ACTION_TYPE_ID
398: AND APPLICATION_ID = X_APPLICATION_ID
399: AND SYSDATE BETWEEN START_DATE AND NVL(END_DATE,SYSDATE);
400: EXCEPTION

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 437: INSERT INTO AME_ACTION_TYPE_CONFIG

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
439: ,ACTION_TYPE_ID
440: ,VOTING_REGIME
441: ,ORDER_NUMBER

Line 466: FROM AME_ACTION_TYPE_CONFIG

462: ,0
463: ,1
464: FROM DUAL
465: WHERE NOT EXISTS (SELECT NULL
466: FROM AME_ACTION_TYPE_CONFIG
467: WHERE ACTION_TYPE_ID = X_ACTION_TYPE_ID
468: AND APPLICATION_ID = X_APPLICATION_ID
469: AND SYSDATE BETWEEN START_DATE AND NVL(END_DATE - (1/86400),SYSDATE));
470: END IF;