[Home] [Help]
12: begin
13: begin
14: select ARU.RULE_ID
15: into X_RULE_ID
16: from AME_RULES ARU
17: where ARU.RULE_KEY = X_RULE_KEY
18: and sysdate between ARU.START_DATE and nvl(ARU.END_DATE - (1/86400),sysdate);
19: exception
20: when no_data_found then
47: begin
48: begin
49: select ARU.RULE_TYPE
50: into X_RULE_TYPE
51: from AME_RULES ARU
52: where ARU.RULE_KEY = X_RULE_KEY
53: and sysdate between ARU.START_DATE and nvl(ARU.END_DATE - (1/86400),sysdate);
54: if X_RULE_TYPE not in (1,2,5,6,7) then
55: raise_application_error(-20001,'AME is attempting to upload usages for an invalid rule type');
262: L_DUMMY varchar2(1);
263: L_PARAMETER AME_ACTIONS.PARAMETER%TYPE;
264: L_PARAMETER_TWO AME_ACTIONS.PARAMETER_TWO%TYPE;
265: L_ACTION_TYPE_NAME AME_ACTION_TYPES.NAME%TYPE;
266: L_RULE_KEY AME_RULES.RULE_KEY%TYPE;
267: L_OWNER varchar2(100);
268: L_LAST_UPDATE_DATE varchar2(19);
269: L_OBJECT_VERSION_NUMBER number;
270: L_ROWID ROWID;
325: exception
326: when no_data_found then
327: select count(*)
328: into L_ACTION_USAGES_COUNT
329: from ame_rules
330: where RULE_ID = L_RULE_ID
331: and ACTION_ID = L_ACTION_ID
332: and sysdate between START_DATE
333: and nvl(END_DATE - (1/86400), sysdate);
379: from (select AAU.LAST_UPDATED_BY OWNER,
380: AME_SEED_UTILITY.DATE_AS_STRING(AAU.LAST_UPDATE_DATE) LAST_UPDATE_DATE
381: from AME_ACTIONS ACT,
382: AME_ACTION_TYPES AAT,
383: AME_RULES ARU,
384: AME_ACTION_USAGES AAU
385: where ACT.ACTION_TYPE_ID = AAT.ACTION_TYPE_ID
386: and ACT.ACTION_ID = AAU.ACTION_ID
387: and AAU.RULE_ID = ARU.RULE_ID
400: select AAU.LAST_UPDATED_BY OWNER,
401: AME_SEED_UTILITY.DATE_AS_STRING(AAU.LAST_UPDATE_DATE) LAST_UPDATE_DATE
402: from AME_ACTIONS ACT,
403: AME_ACTION_TYPES AAT,
404: AME_RULES ARU,
405: AME_ACTION_USAGES AAU,
406: AME_APPROVAL_GROUPS AAG
407: where ACT.ACTION_TYPE_ID = AAT.ACTION_TYPE_ID
408: and ACT.ACTION_ID = AAU.ACTION_ID