153: begin
154: select max(ame_action_type_config.order_number)
155: into orderNumber
156: from ame_action_type_config,
157: ame_action_type_usages,
158: ame_action_types
159: where
160: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and
161: ame_action_type_config.action_type_id = ame_action_type_usages.action_type_id and
156: from ame_action_type_config,
157: ame_action_type_usages,
158: ame_action_types
159: where
160: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and
161: ame_action_type_config.action_type_id = ame_action_type_usages.action_type_id and
162: ame_action_type_usages.rule_type = ruleTypeIn and
163: ame_action_type_config.application_id = applicationIdIn and
164: sysdate between ame_action_type_config.start_date and
157: ame_action_type_usages,
158: ame_action_types
159: where
160: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and
161: ame_action_type_config.action_type_id = ame_action_type_usages.action_type_id and
162: ame_action_type_usages.rule_type = ruleTypeIn and
163: ame_action_type_config.application_id = applicationIdIn and
164: sysdate between ame_action_type_config.start_date and
165: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
158: ame_action_types
159: where
160: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and
161: ame_action_type_config.action_type_id = ame_action_type_usages.action_type_id and
162: ame_action_type_usages.rule_type = ruleTypeIn and
163: ame_action_type_config.application_id = applicationIdIn and
164: sysdate between ame_action_type_config.start_date and
165: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
166: sysdate between ame_action_type_usages.start_date and
162: ame_action_type_usages.rule_type = ruleTypeIn and
163: ame_action_type_config.application_id = applicationIdIn and
164: sysdate between ame_action_type_config.start_date and
165: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
166: sysdate between ame_action_type_usages.start_date and
167: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate) and
168: sysdate between ame_action_types.start_date and
169: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate);
170: return(orderNumber);
163: ame_action_type_config.application_id = applicationIdIn and
164: sysdate between ame_action_type_config.start_date and
165: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
166: sysdate between ame_action_type_usages.start_date and
167: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate) and
168: sysdate between ame_action_types.start_date and
169: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate);
170: return(orderNumber);
171: exception
312: tempCount integer;
313: begin
314: select count(*)
315: into tempCount
316: from ame_action_type_usages
317: where
318: action_type_id = actionTypeIdIn and
319: sysdate between start_date and
320: nvl(end_date - ame_util.oneSecond, sysdate);
324: return(ame_util.authorityRuleType);
325: else
326: select rule_type
327: into ruleType
328: from ame_action_type_usages
329: where
330: action_type_id = actionTypeIdIn and
331: sysdate between start_date and
332: nvl(end_date - ame_util.oneSecond, sysdate);
828: tempCount integer;
829: begin
830: select count(*)
831: into tempCount
832: from ame_action_type_usages
833: where
834: action_type_id = actionTypeIdIn and
835: rule_type = ame_util.authorityRuleType and
836: sysdate between start_date and
1470: ruleType := getAllowedRuleType(actionTypeIdIn => actionTypeIdIn);
1471: select count(*)
1472: into tempCount
1473: from ame_action_type_config,
1474: ame_action_type_usages
1475: where
1476: ame_action_type_config.action_type_id = ame_action_type_usages.action_type_id and
1477: ame_action_type_config.application_id = applicationIdIn and
1478: ame_action_type_config.order_number = orderNumberIn and
1472: into tempCount
1473: from ame_action_type_config,
1474: ame_action_type_usages
1475: where
1476: ame_action_type_config.action_type_id = ame_action_type_usages.action_type_id and
1477: ame_action_type_config.application_id = applicationIdIn and
1478: ame_action_type_config.order_number = orderNumberIn and
1479: ame_action_type_usages.rule_type = ruleType and
1480: sysdate between ame_action_type_config.start_date and
1475: where
1476: ame_action_type_config.action_type_id = ame_action_type_usages.action_type_id and
1477: ame_action_type_config.application_id = applicationIdIn and
1478: ame_action_type_config.order_number = orderNumberIn and
1479: ame_action_type_usages.rule_type = ruleType and
1480: sysdate between ame_action_type_config.start_date and
1481: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
1482: sysdate between ame_action_type_usages.start_date and
1483: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate);
1478: ame_action_type_config.order_number = orderNumberIn and
1479: ame_action_type_usages.rule_type = ruleType and
1480: sysdate between ame_action_type_config.start_date and
1481: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
1482: sysdate between ame_action_type_usages.start_date and
1483: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate);
1484: if(tempCount > 1) then
1485: return(false);
1486: else
1479: ame_action_type_usages.rule_type = ruleType and
1480: sysdate between ame_action_type_config.start_date and
1481: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
1482: sysdate between ame_action_type_usages.start_date and
1483: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate);
1484: if(tempCount > 1) then
1485: return(false);
1486: else
1487: return(true);
2214: ruleTypeIn in integer) is
2215: select ame_action_type_config.action_type_id,
2216: ame_action_type_config.order_number
2217: from ame_action_type_config,
2218: ame_action_type_usages
2219: where
2220: ame_action_type_config.action_type_id = ame_action_type_usages.action_type_id and
2221: ame_action_type_config.application_id = applicationIdIn and
2222: ame_action_type_config.order_number > orderNumberIn and
2216: ame_action_type_config.order_number
2217: from ame_action_type_config,
2218: ame_action_type_usages
2219: where
2220: ame_action_type_config.action_type_id = ame_action_type_usages.action_type_id and
2221: ame_action_type_config.application_id = applicationIdIn and
2222: ame_action_type_config.order_number > orderNumberIn and
2223: ame_action_type_usages.rule_type = ruleTypeIn and
2224: sysdate between ame_action_type_config.start_date and
2219: where
2220: ame_action_type_config.action_type_id = ame_action_type_usages.action_type_id and
2221: ame_action_type_config.application_id = applicationIdIn and
2222: ame_action_type_config.order_number > orderNumberIn and
2223: ame_action_type_usages.rule_type = ruleTypeIn and
2224: sysdate between ame_action_type_config.start_date and
2225: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
2226: sysdate between ame_action_type_usages.start_date and
2227: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)
2222: ame_action_type_config.order_number > orderNumberIn and
2223: ame_action_type_usages.rule_type = ruleTypeIn and
2224: sysdate between ame_action_type_config.start_date and
2225: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
2226: sysdate between ame_action_type_usages.start_date and
2227: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)
2228: order by order_number;
2229: actionTypeIds ame_util.idList;
2230: chainOrderingMode ame_util.charType;
2223: ame_action_type_usages.rule_type = ruleTypeIn and
2224: sysdate between ame_action_type_config.start_date and
2225: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
2226: sysdate between ame_action_type_usages.start_date and
2227: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)
2228: order by order_number;
2229: actionTypeIds ame_util.idList;
2230: chainOrderingMode ame_util.charType;
2231: currentUserId integer;
2605: cursor actionTypeCursor is
2606: select ame_action_types.action_type_id,
2607: ame_action_types.name,
2608: ame_action_types.description,
2609: ame_action_type_usages.rule_type,
2610: ame_action_type_config.order_number
2611: from ame_action_types,
2612: ame_action_type_usages,
2613: ame_action_type_config
2608: ame_action_types.description,
2609: ame_action_type_usages.rule_type,
2610: ame_action_type_config.order_number
2611: from ame_action_types,
2612: ame_action_type_usages,
2613: ame_action_type_config
2614: where
2615: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and
2616: ame_action_types.action_type_id = ame_action_type_config.action_type_id and
2611: from ame_action_types,
2612: ame_action_type_usages,
2613: ame_action_type_config
2614: where
2615: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and
2616: ame_action_types.action_type_id = ame_action_type_config.action_type_id and
2617: ame_action_type_config.application_id = applicationIdIn and
2618: ame_action_type_usages.rule_type <> ame_util.exceptionRuleType and
2619: sysdate between ame_action_types.start_date and
2614: where
2615: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and
2616: ame_action_types.action_type_id = ame_action_type_config.action_type_id and
2617: ame_action_type_config.application_id = applicationIdIn and
2618: ame_action_type_usages.rule_type <> ame_util.exceptionRuleType and
2619: sysdate between ame_action_types.start_date and
2620: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
2621: sysdate between ame_action_type_usages.start_date and
2622: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate) and
2617: ame_action_type_config.application_id = applicationIdIn and
2618: ame_action_type_usages.rule_type <> ame_util.exceptionRuleType and
2619: sysdate between ame_action_types.start_date and
2620: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
2621: sysdate between ame_action_type_usages.start_date and
2622: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate) and
2623: sysdate between ame_action_type_config.start_date and
2624: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate)
2625: order by ame_action_type_usages.rule_type,
2618: ame_action_type_usages.rule_type <> ame_util.exceptionRuleType and
2619: sysdate between ame_action_types.start_date and
2620: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
2621: sysdate between ame_action_type_usages.start_date and
2622: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate) and
2623: sysdate between ame_action_type_config.start_date and
2624: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate)
2625: order by ame_action_type_usages.rule_type,
2626: ame_action_type_config.order_number,
2621: sysdate between ame_action_type_usages.start_date and
2622: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate) and
2623: sysdate between ame_action_type_config.start_date and
2624: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate)
2625: order by ame_action_type_usages.rule_type,
2626: ame_action_type_config.order_number,
2627: ame_action_types.name;
2628: tempIndex integer;
2629: begin
2681: procedure getActionTypeUsages(actionTypeIdIn in integer,
2682: ruleTypesOut out nocopy ame_util.stringList) as
2683: cursor getRuleTypesCur(actionTypeIdIn in integer) is
2684: select rule_type
2685: from ame_action_type_usages
2686: where action_type_id = actionTypeIdIn and
2687: sysdate between start_date and
2688: nvl(end_date - ame_util.oneSecond, sysdate)
2689: order by rule_type;
2711: ruleTypesOut out nocopy ame_util.idList) as
2712: cursor getRuleTypesCur is
2713: select action_type_id,
2714: rule_type
2715: from ame_action_type_usages
2716: where
2717: /* There are two rows in ame_action_type_usages for list creation rules
2718: and list exception rules. Only grab on row, so here we're
2719: eliminating the exception rule. */
2713: select action_type_id,
2714: rule_type
2715: from ame_action_type_usages
2716: where
2717: /* There are two rows in ame_action_type_usages for list creation rules
2718: and list exception rules. Only grab on row, so here we're
2719: eliminating the exception rule. */
2720: rule_type <> ame_util.exceptionRuleType and
2721: sysdate between start_date and
2814: ame_action_types.action_type_id action_type_id,
2815: ame_action_types.description description
2816: from
2817: ame_action_types,
2818: ame_action_type_usages
2819: where
2820: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and
2821: ((allowProductionsIn = ame_util.yes and ame_action_type_usages.rule_type = ame_util.productionRuleType) or
2822: ame_action_type_usages.rule_type = ruleTypeIn) and
2816: from
2817: ame_action_types,
2818: ame_action_type_usages
2819: where
2820: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and
2821: ((allowProductionsIn = ame_util.yes and ame_action_type_usages.rule_type = ame_util.productionRuleType) or
2822: ame_action_type_usages.rule_type = ruleTypeIn) and
2823: (allowAllApproverTypesIn = ame_util.yes or
2824: ame_action_types.action_type_id in (
2817: ame_action_types,
2818: ame_action_type_usages
2819: where
2820: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and
2821: ((allowProductionsIn = ame_util.yes and ame_action_type_usages.rule_type = ame_util.productionRuleType) or
2822: ame_action_type_usages.rule_type = ruleTypeIn) and
2823: (allowAllApproverTypesIn = ame_util.yes or
2824: ame_action_types.action_type_id in (
2825: select distinct action_type_id
2818: ame_action_type_usages
2819: where
2820: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and
2821: ((allowProductionsIn = ame_util.yes and ame_action_type_usages.rule_type = ame_util.productionRuleType) or
2822: ame_action_type_usages.rule_type = ruleTypeIn) and
2823: (allowAllApproverTypesIn = ame_util.yes or
2824: ame_action_types.action_type_id in (
2825: select distinct action_type_id
2826: from ame_approver_type_usages
2836: sysdate between
2837: ame_action_types.start_date and
2838: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
2839: sysdate
2840: between ame_action_type_usages.start_date and
2841: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)
2842: order by upper(description);
2843: actionTypeIds ame_util.stringList;
2844: actionTypeIds2 ame_util.stringList;
2837: ame_action_types.start_date and
2838: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
2839: sysdate
2840: between ame_action_type_usages.start_date and
2841: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)
2842: order by upper(description);
2843: actionTypeIds ame_util.stringList;
2844: actionTypeIds2 ame_util.stringList;
2845: actionTypeDescriptions ame_util.stringList;
2933: ame_action_types.action_type_id action_type_id,
2934: ame_action_types.description description
2935: from
2936: ame_action_types,
2937: ame_action_type_usages
2938: where
2939: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and
2940: ((allowProductionsIn = ame_util.yes and
2941: ame_action_type_usages.rule_type = ame_util.productionRuleType) or
2935: from
2936: ame_action_types,
2937: ame_action_type_usages
2938: where
2939: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and
2940: ((allowProductionsIn = ame_util.yes and
2941: ame_action_type_usages.rule_type = ame_util.productionRuleType) or
2942: (subOrListModActsForCombRuleIn = ame_util.no and
2943: ame_action_type_usages.rule_type in
2937: ame_action_type_usages
2938: where
2939: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and
2940: ((allowProductionsIn = ame_util.yes and
2941: ame_action_type_usages.rule_type = ame_util.productionRuleType) or
2942: (subOrListModActsForCombRuleIn = ame_util.no and
2943: ame_action_type_usages.rule_type in
2944: (ame_util.authorityRuleType,
2945: ame_util.preListGroupRuleType,
2939: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and
2940: ((allowProductionsIn = ame_util.yes and
2941: ame_action_type_usages.rule_type = ame_util.productionRuleType) or
2942: (subOrListModActsForCombRuleIn = ame_util.no and
2943: ame_action_type_usages.rule_type in
2944: (ame_util.authorityRuleType,
2945: ame_util.preListGroupRuleType,
2946: ame_util.postListGroupRuleType)) or
2947: (subOrListModActsForCombRuleIn = ame_util.yes and
2944: (ame_util.authorityRuleType,
2945: ame_util.preListGroupRuleType,
2946: ame_util.postListGroupRuleType)) or
2947: (subOrListModActsForCombRuleIn = ame_util.yes and
2948: ame_action_type_usages.rule_type in
2949: (ame_util.listModRuleType,
2950: ame_util.substitutionRuleType))) and
2951: (allowAllApproverTypesIn = ame_util.yes or
2952: ame_action_types.action_type_id in (
2964: sysdate between
2965: ame_action_types.start_date and
2966: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
2967: sysdate
2968: between ame_action_type_usages.start_date and
2969: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)
2970: order by upper(description);
2971: actionTypeIds ame_util.stringList;
2972: actionTypeIds2 ame_util.stringList;
2965: ame_action_types.start_date and
2966: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
2967: sysdate
2968: between ame_action_type_usages.start_date and
2969: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)
2970: order by upper(description);
2971: actionTypeIds ame_util.stringList;
2972: actionTypeIds2 ame_util.stringList;
2973: actionTypeDescriptions ame_util.stringList;
3054: ruleTypeIn in integer) is
3055: select ame_action_type_config.action_type_id,
3056: ame_action_type_config.order_number
3057: from ame_action_type_config,
3058: ame_action_type_usages
3059: where
3060: ame_action_type_config.action_type_id = ame_action_type_usages.action_type_id and
3061: ame_action_type_config.application_id = applicationIdIn and
3062: ame_action_type_config.action_type_id <> actionTypeIdIn and
3056: ame_action_type_config.order_number
3057: from ame_action_type_config,
3058: ame_action_type_usages
3059: where
3060: ame_action_type_config.action_type_id = ame_action_type_usages.action_type_id and
3061: ame_action_type_config.application_id = applicationIdIn and
3062: ame_action_type_config.action_type_id <> actionTypeIdIn and
3063: ame_action_type_config.order_number >= orderNumberIn and
3064: ame_action_type_usages.rule_type = ruleTypeIn and
3060: ame_action_type_config.action_type_id = ame_action_type_usages.action_type_id and
3061: ame_action_type_config.application_id = applicationIdIn and
3062: ame_action_type_config.action_type_id <> actionTypeIdIn and
3063: ame_action_type_config.order_number >= orderNumberIn and
3064: ame_action_type_usages.rule_type = ruleTypeIn and
3065: sysdate between ame_action_type_config.start_date and
3066: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
3067: sysdate between ame_action_type_usages.start_date and
3068: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)
3063: ame_action_type_config.order_number >= orderNumberIn and
3064: ame_action_type_usages.rule_type = ruleTypeIn and
3065: sysdate between ame_action_type_config.start_date and
3066: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
3067: sysdate between ame_action_type_usages.start_date and
3068: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)
3069: order by order_number;
3070: actionTypeIds ame_util.idList;
3071: chainOrderingMode ame_util.charType;
3064: ame_action_type_usages.rule_type = ruleTypeIn and
3065: sysdate between ame_action_type_config.start_date and
3066: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
3067: sysdate between ame_action_type_usages.start_date and
3068: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)
3069: order by order_number;
3070: actionTypeIds ame_util.idList;
3071: chainOrderingMode ame_util.charType;
3072: currentUserId integer;
3195: else
3196: select (nvl(max(order_number), 0) + 1)
3197: into orderNumber
3198: from ame_action_type_config,
3199: ame_action_type_usages
3200: where
3201: ame_action_type_config.action_type_id = ame_action_type_usages.action_type_id and
3202: ame_action_type_config.application_id = applicationIds(i) and
3203: ame_action_type_usages.rule_type = ruleTypeIn and
3197: into orderNumber
3198: from ame_action_type_config,
3199: ame_action_type_usages
3200: where
3201: ame_action_type_config.action_type_id = ame_action_type_usages.action_type_id and
3202: ame_action_type_config.application_id = applicationIds(i) and
3203: ame_action_type_usages.rule_type = ruleTypeIn and
3204: sysdate between ame_action_type_config.start_date and
3205: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
3199: ame_action_type_usages
3200: where
3201: ame_action_type_config.action_type_id = ame_action_type_usages.action_type_id and
3202: ame_action_type_config.application_id = applicationIds(i) and
3203: ame_action_type_usages.rule_type = ruleTypeIn and
3204: sysdate between ame_action_type_config.start_date and
3205: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
3206: sysdate between ame_action_type_usages.start_date and
3207: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate);
3202: ame_action_type_config.application_id = applicationIds(i) and
3203: ame_action_type_usages.rule_type = ruleTypeIn and
3204: sysdate between ame_action_type_config.start_date and
3205: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
3206: sysdate between ame_action_type_usages.start_date and
3207: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate);
3208: end if;
3209: end if;
3210: insert into ame_action_type_config(application_id,
3203: ame_action_type_usages.rule_type = ruleTypeIn and
3204: sysdate between ame_action_type_config.start_date and
3205: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
3206: sysdate between ame_action_type_usages.start_date and
3207: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate);
3208: end if;
3209: end if;
3210: insert into ame_action_type_config(application_id,
3211: action_type_id,
3266: end if;
3267: currentUserId := ame_util.getCurrentUserId;
3268: select count(*)
3269: into tempCount
3270: from ame_action_type_usages
3271: where
3272: action_type_id = actionTypeIdIn and
3273: created_by = ame_util.seededDataCreatedById;
3274: if(tempCount > 0) then
3279: if(ruleTypeIn = ame_util.exceptionRuleType) then
3280: /* chain of authority so insert two rows,
3281: one for list-creation and one for list-exception */
3282: for i in 1 .. 2 loop
3283: insert into ame_action_type_usages
3284: (action_type_id,
3285: rule_type,
3286: created_by,
3287: creation_date,
3300: processingDate,
3301: null);
3302: end loop;
3303: else
3304: insert into ame_action_type_usages
3305: (action_type_id,
3306: rule_type,
3307: created_by,
3308: creation_date,
3661: else
3662: processingDate := processingDateIn;
3663: end if;
3664: currentUserId := ame_util.getCurrentUserId;
3665: update ame_action_type_usages
3666: set
3667: last_updated_by = currentUserId,
3668: last_update_date = processingDate,
3669: last_update_login = currentUserId,
3692: finalizeIn in boolean default false,
3693: processingDateIn in date default null) as
3694: cursor getRuleTypesCur(actionTypeIdIn in integer) is
3695: select rule_type
3696: from ame_action_type_usages
3697: where
3698: action_type_id = actionTypeIdIn and
3699: sysdate between start_date and
3700: nvl(end_date - ame_util.oneSecond, sysdate)