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_CONFIG

Line 154: select max(ame_action_type_config.order_number)

150: function getActionTypeMaxOrderNumber(applicationIdIn in integer,
151: ruleTypeIn in integer) return integer as
152: orderNumber integer;
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

Line 156: from ame_action_type_config,

152: orderNumber integer;
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

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 163: ame_action_type_config.application_id = applicationIdIn and

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

Line 164: sysdate between ame_action_type_config.start_date and

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
167: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate) and
168: sysdate between ame_action_types.start_date and

Line 165: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) 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
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);

Line 266: from ame_action_type_config

262: orderNumber integer;
263: begin
264: select order_number
265: into orderNumber
266: from ame_action_type_config
267: where
268: action_type_id = actionTypeIdIn and
269: application_id = applicationIdIn and
270: sysdate between start_date and

Line 381: from ame_action_type_config

377: chainOrderingMode ame_util.charType;
378: begin
379: select chain_ordering_mode
380: into chainOrderingMode
381: from ame_action_type_config
382: where
383: action_type_id = actionTypeIdIn and
384: application_id = applicationIdIn and
385: sysdate between start_date and

Line 428: from ame_action_type_config

424: stringStartDate varchar2(50);
425: begin
426: select start_date
427: into startDate
428: from ame_action_type_config
429: where
430: action_type_id = actionTypeIdIn and
431: application_id = applicationIdIn and
432: sysdate between start_date and

Line 767: from ame_action_type_config

763: votingRegime ame_approval_group_config.voting_regime%type;
764: begin
765: select voting_regime
766: into votingRegime
767: from ame_action_type_config
768: where
769: action_type_id = actionTypeIdIn and
770: application_id = applicationIdIn and
771: sysdate between start_date and

Line 1473: from ame_action_type_config,

1469: begin
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

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 1477: ame_action_type_config.application_id = applicationIdIn and

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
1481: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and

Line 1478: ame_action_type_config.order_number = orderNumberIn and

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
1481: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
1482: sysdate between ame_action_type_usages.start_date and

Line 1480: sysdate between ame_action_type_config.start_date and

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);
1484: if(tempCount > 1) then

Line 1481: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) 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);
1484: if(tempCount > 1) then
1485: return(false);

Line 1897: from ame_action_type_config

1893: nvl(end_date - ame_util.oneSecond, sysdate)
1894: for update;
1895: cursor startDateCursor2 is
1896: select start_date
1897: from ame_action_type_config
1898: where
1899: action_type_id = actionTypeIdIn and
1900: application_id = applicationIdIn and
1901: sysdate between start_date and

Line 2091: update ame_action_type_config

2087: else /* The order number is not unique. */
2088: raise orderNumberException;
2089: end if;
2090: else
2091: update ame_action_type_config
2092: set
2093: last_updated_by = currentUserId,
2094: last_update_date = endDate,
2095: last_update_login = currentUserId,

Line 2119: insert into ame_action_type_config(application_id,

2115: incrementActionTypeOrdNumbers(applicationIdIn => applicationIdIn,
2116: actionTypeIdIn => actionTypeIdIn,
2117: orderNumberIn => newOrderNumber);
2118: end if;
2119: insert into ame_action_type_config(application_id,
2120: action_type_id,
2121: voting_regime,
2122: order_number,
2123: chain_ordering_mode,

Line 2145: update ame_action_type_config

2141: newStartDate,
2142: null);
2143: end if;
2144: if(updateOnlyATModified) then
2145: update ame_action_type_config
2146: set
2147: last_updated_by = currentUserId,
2148: last_update_date = endDate,
2149: last_update_login = currentUserId,

Line 2156: insert into ame_action_type_config(application_id,

2152: application_id = applicationIdIn and
2153: action_type_id = actionTypeIdIn and
2154: sysdate between start_date and
2155: nvl(end_date - ame_util.oneSecond, sysdate);
2156: insert into ame_action_type_config(application_id,
2157: action_type_id,
2158: voting_regime,
2159: order_number,
2160: chain_ordering_mode,

Line 2215: select ame_action_type_config.action_type_id,

2211: finalizeIn in boolean default false) as
2212: cursor orderNumberCursor(applicationIdIn in integer,
2213: orderNumberIn in integer,
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

Line 2216: ame_action_type_config.order_number

2212: cursor orderNumberCursor(applicationIdIn in integer,
2213: orderNumberIn in integer,
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

Line 2217: from ame_action_type_config,

2213: orderNumberIn in integer,
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

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 2221: ame_action_type_config.application_id = applicationIdIn and

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
2225: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and

Line 2222: ame_action_type_config.order_number > orderNumberIn and

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
2225: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and
2226: sysdate between ame_action_type_usages.start_date and

Line 2224: sysdate between ame_action_type_config.start_date and

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)
2228: order by order_number;

Line 2225: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) 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)
2228: order by order_number;
2229: actionTypeIds ame_util.idList;

Line 2251: update ame_action_type_config

2247: votingRegime := getVotingRegime(actionTypeIdIn => actionTypeIds(i),
2248: applicationIdIn => applicationIdIn);
2249: chainOrderingMode := getChainOrderingMode(actionTypeIdIn => actionTypeIds(i),
2250: applicationIdIn => applicationIdIn);
2251: update ame_action_type_config
2252: set
2253: last_updated_by = currentUserId,
2254: last_update_date = processingDate,
2255: last_update_login = currentUserId,

Line 2262: insert into ame_action_type_config(application_id,

2258: application_id = applicationIdIn and
2259: action_type_id = actionTypeIds(i) and
2260: sysdate between start_date and
2261: nvl(end_date - ame_util.oneSecond, sysdate);
2262: insert into ame_action_type_config(application_id,
2263: action_type_id,
2264: voting_regime,
2265: order_number,
2266: chain_ordering_mode,

Line 2610: ame_action_type_config.order_number

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
2614: where

Line 2613: ame_action_type_config

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
2617: ame_action_type_config.application_id = applicationIdIn and

Line 2616: ame_action_types.action_type_id = ame_action_type_config.action_type_id and

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
2620: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and

Line 2617: ame_action_type_config.application_id = applicationIdIn and

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
2620: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
2621: sysdate between ame_action_type_usages.start_date and

Line 2623: sysdate between ame_action_type_config.start_date 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,
2627: ame_action_types.name;

Line 2624: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate)

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,
2627: ame_action_types.name;
2628: tempIndex integer;

Line 2626: ame_action_type_config.order_number,

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
2630: tempIndex := 1;

Line 3055: select ame_action_type_config.action_type_id,

3051: cursor orderNumberCursor(applicationIdIn in integer,
3052: actionTypeIdIn in integer,
3053: orderNumberIn in integer,
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

Line 3056: ame_action_type_config.order_number

3052: actionTypeIdIn in integer,
3053: orderNumberIn in integer,
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

Line 3057: from ame_action_type_config,

3053: orderNumberIn in integer,
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

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 3061: ame_action_type_config.application_id = applicationIdIn and

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
3065: sysdate between ame_action_type_config.start_date and

Line 3062: ame_action_type_config.action_type_id <> actionTypeIdIn and

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
3065: sysdate between ame_action_type_config.start_date and
3066: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and

Line 3063: ame_action_type_config.order_number >= orderNumberIn and

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

Line 3065: sysdate between ame_action_type_config.start_date 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)
3069: order by order_number;

Line 3066: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) 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)
3069: order by order_number;
3070: actionTypeIds ame_util.idList;

Line 3093: update ame_action_type_config

3089: votingRegime := getVotingRegime(actionTypeIdIn => actionTypeIds(i),
3090: applicationIdIn => applicationIdIn);
3091: chainOrderingMode := getChainOrderingMode(actionTypeIdIn => actionTypeIds(i),
3092: applicationIdIn => applicationIdIn);
3093: update ame_action_type_config
3094: set
3095: last_updated_by = currentUserId,
3096: last_update_date = processingDate,
3097: last_update_login = currentUserId,

Line 3104: insert into ame_action_type_config(application_id,

3100: application_id = applicationIdIn and
3101: action_type_id = actionTypeIds(i) and
3102: sysdate between start_date and
3103: nvl(end_date - ame_util.oneSecond, sysdate);
3104: insert into ame_action_type_config(application_id,
3105: action_type_id,
3106: voting_regime,
3107: order_number,
3108: chain_ordering_mode,

Line 3161: orderNumber ame_action_type_config.order_number%type;

3157: applicationIds ame_util.idList;
3158: chainOrderingMode ame_util.charType;
3159: currentUserId integer;
3160: maxOrderNumber integer;
3161: orderNumber ame_action_type_config.order_number%type;
3162: processingDate date;
3163: tempCount integer;
3164: votingRegime ame_util.charType;
3165: begin

Line 3188: from ame_action_type_config

3184: votingRegime := ame_util.serializedVoting;
3185: chainOrderingMode := ame_util.serialChainsMode;
3186: select count(*)
3187: into tempCount
3188: from ame_action_type_config
3189: where
3190: application_id = applicationIds(i) and
3191: sysdate between start_date and
3192: nvl(end_date - ame_util.oneSecond, sysdate);

Line 3198: from ame_action_type_config,

3194: orderNumber := 1;
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

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 3202: ame_action_type_config.application_id = applicationIds(i) and

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
3206: sysdate between ame_action_type_usages.start_date and

Line 3204: sysdate between ame_action_type_config.start_date and

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);
3208: end if;

Line 3205: nvl(ame_action_type_config.end_date - ame_util.oneSecond, sysdate) and

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);
3208: end if;
3209: end if;

Line 3210: insert into ame_action_type_config(application_id,

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,
3212: voting_regime,
3213: order_number,
3214: chain_ordering_mode,

Line 3394: from ame_action_type_config

3390: close applicationIdCursor;
3391: for i in 1 .. applicationIds.count loop
3392: select order_number
3393: into orderNumber
3394: from ame_action_type_config
3395: where
3396: application_id = applicationIds(i) and
3397: action_type_id = actionTypeIdIn and
3398: sysdate between start_date and

Line 3421: update ame_action_type_config

3417: where
3418: action_type_id = actionTypeIdIn and
3419: processingDate between start_date and
3420: nvl(end_date - ame_util.oneSecond, processingDate);
3421: update ame_action_type_config
3422: set
3423: last_updated_by = currentUserId,
3424: last_update_date = processingDate,
3425: last_update_login = currentUserId,