31: (
32: X_RULE_KEY in VARCHAR2
33: ) is
34: select RULE_ID
35: from AME_RULES
36: where RULE_KEY = X_RULE_KEY;
37: cursor CSR_GET_ACTION_TYPE_ID
38: (
39: X_ACTION_TYPE_NAME in VARCHAR2
80: (
81: X_RULE_ID in NUMBER,
82: X_ACTION_ID in NUMBER
83: ) is select ROWID
84: from AME_RULES
85: where RULE_ID = X_RULE_ID
86: and ACTION_ID = X_ACTION_ID
87: and sysdate between START_DATE
88: and nvl(END_DATE - (1/86400), sysdate);
161: end KEY_TO_IDS;
162: procedure VALIDATE_RULE_TYPE (X_RULE_KEY in VARCHAR2) is
163: cursor CSR_GET_RULE_TYPE(X_RULE_KEY in VARCHAR2) is
164: select RULE_TYPE
165: from AME_RULES
166: where RULE_KEY = X_RULE_KEY
167: and sysdate between START_DATE
168: and nvl(END_DATE - (1/86400), sysdate);
169: invalidRuleTypeException exception;