eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AME_ACTION_PKG dependencies on AME_ACTION_TYPE_USAGES

Line 157: ame_action_type_usages,

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

Line 160: ame_action_types.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

Line 161: ame_action_type_config.action_type_id = ame_action_type_usages.action_type_id 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

Line 162: ame_action_type_usages.rule_type = ruleTypeIn 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

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

Line 167: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate) 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);
171: exception

Line 316: from ame_action_type_usages

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

Line 328: from ame_action_type_usages

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

Line 832: from ame_action_type_usages

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

Line 1474: ame_action_type_usages

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

Line 1476: ame_action_type_config.action_type_id = ame_action_type_usages.action_type_id 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

Line 1479: ame_action_type_usages.rule_type = ruleType 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);

Line 1482: sysdate between ame_action_type_usages.start_date 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);
1484: if(tempCount > 1) then
1485: return(false);
1486: else

Line 1483: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate);

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

Line 2218: ame_action_type_usages

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

Line 2220: ame_action_type_config.action_type_id = ame_action_type_usages.action_type_id 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

Line 2223: ame_action_type_usages.rule_type = ruleTypeIn 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)

Line 2226: sysdate between ame_action_type_usages.start_date 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)
2228: order by order_number;
2229: actionTypeIds ame_util.idList;
2230: chainOrderingMode ame_util.charType;

Line 2227: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)

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;

Line 2609: ame_action_type_usages.rule_type,

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

Line 2612: ame_action_type_usages,

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

Line 2615: ame_action_types.action_type_id = ame_action_type_usages.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

Line 2618: ame_action_type_usages.rule_type <> ame_util.exceptionRuleType 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

Line 2621: sysdate between ame_action_type_usages.start_date 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,

Line 2622: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate) 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,
2626: ame_action_type_config.order_number,

Line 2625: order by ame_action_type_usages.rule_type,

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

Line 2685: from ame_action_type_usages

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;

Line 2715: from ame_action_type_usages

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. */

Line 2717: /* There are two rows in ame_action_type_usages for list creation rules

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

Line 2818: ame_action_type_usages

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

Line 2820: ame_action_types.action_type_id = ame_action_type_usages.action_type_id 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 (

Line 2821: ((allowProductionsIn = ame_util.yes and ame_action_type_usages.rule_type = ame_util.productionRuleType) or

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

Line 2822: ame_action_type_usages.rule_type = ruleTypeIn) and

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

Line 2840: between ame_action_type_usages.start_date and

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;

Line 2841: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)

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;

Line 2937: ame_action_type_usages

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

Line 2939: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and

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

Line 2941: ame_action_type_usages.rule_type = ame_util.productionRuleType) or

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,

Line 2943: ame_action_type_usages.rule_type in

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

Line 2948: 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
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 (

Line 2968: between ame_action_type_usages.start_date and

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;

Line 2969: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)

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;

Line 3058: ame_action_type_usages

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

Line 3060: ame_action_type_config.action_type_id = ame_action_type_usages.action_type_id 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

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

Line 3067: sysdate between ame_action_type_usages.start_date 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)
3069: order by order_number;
3070: actionTypeIds ame_util.idList;
3071: chainOrderingMode ame_util.charType;

Line 3068: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate)

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;

Line 3199: ame_action_type_usages

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

Line 3201: ame_action_type_config.action_type_id = ame_action_type_usages.action_type_id 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

Line 3203: ame_action_type_usages.rule_type = ruleTypeIn 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);

Line 3206: sysdate between ame_action_type_usages.start_date 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);
3208: end if;
3209: end if;
3210: insert into ame_action_type_config(application_id,

Line 3207: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate);

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,

Line 3270: from ame_action_type_usages

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

Line 3283: insert into ame_action_type_usages

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,

Line 3304: insert into ame_action_type_usages

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,

Line 3665: update ame_action_type_usages

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,

Line 3696: from ame_action_type_usages

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)