DBA Data[Home] [Help]

APPS.AME_ACTION_USAGES_API dependencies on AME_RULES

Line 35: from AME_RULES

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

Line 84: from AME_RULES

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);

Line 165: from AME_RULES

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;