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_RULE_PKG dependencies on AME_ACTION_USAGES

Line 134: ame_action_usages

130: cursor actionTypeIdsCursor(ruleIdIn in integer) is
131: select distinct(ame_action_types.action_type_id) action_type_id
132: from ame_action_types,
133: ame_actions,
134: ame_action_usages
135: where
136: ame_action_types.action_type_id = ame_actions.action_type_id and
137: ame_actions.action_id = ame_action_usages.action_id and
138: ame_action_usages.rule_id = ruleIdIn and

Line 137: ame_actions.action_id = ame_action_usages.action_id and

133: ame_actions,
134: ame_action_usages
135: where
136: ame_action_types.action_type_id = ame_actions.action_type_id and
137: ame_actions.action_id = ame_action_usages.action_id and
138: ame_action_usages.rule_id = ruleIdIn and
139: sysdate between ame_action_usages.start_date and
140: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
141: sysdate between ame_action_types.start_date and

Line 138: ame_action_usages.rule_id = ruleIdIn and

134: ame_action_usages
135: where
136: ame_action_types.action_type_id = ame_actions.action_type_id and
137: ame_actions.action_id = ame_action_usages.action_id and
138: ame_action_usages.rule_id = ruleIdIn and
139: sysdate between ame_action_usages.start_date and
140: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
141: sysdate between ame_action_types.start_date and
142: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and

Line 139: sysdate between ame_action_usages.start_date and

135: where
136: ame_action_types.action_type_id = ame_actions.action_type_id and
137: ame_actions.action_id = ame_action_usages.action_id and
138: ame_action_usages.rule_id = ruleIdIn and
139: sysdate between ame_action_usages.start_date and
140: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
141: sysdate between ame_action_types.start_date and
142: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
143: sysdate between ame_actions.start_date and

Line 140: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and

136: ame_action_types.action_type_id = ame_actions.action_type_id and
137: ame_actions.action_id = ame_action_usages.action_id and
138: ame_action_usages.rule_id = ruleIdIn and
139: sysdate between ame_action_usages.start_date and
140: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
141: sysdate between ame_action_types.start_date and
142: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
143: sysdate between ame_actions.start_date and
144: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);

Line 368: ame_action_usages

364: cursor actionTypeIdsCursor(ruleIdIn in integer) is
365: select distinct(ame_action_types.action_type_id) action_type_id
366: from ame_action_types,
367: ame_actions,
368: ame_action_usages
369: where
370: ame_action_types.action_type_id = ame_actions.action_type_id and
371: ame_actions.action_id = ame_action_usages.action_id and
372: ame_action_usages.rule_id = ruleIdIn and

Line 371: ame_actions.action_id = ame_action_usages.action_id and

367: ame_actions,
368: ame_action_usages
369: where
370: ame_action_types.action_type_id = ame_actions.action_type_id and
371: ame_actions.action_id = ame_action_usages.action_id and
372: ame_action_usages.rule_id = ruleIdIn and
373: sysdate between ame_action_usages.start_date and
374: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
375: sysdate between ame_action_types.start_date and

Line 372: ame_action_usages.rule_id = ruleIdIn and

368: ame_action_usages
369: where
370: ame_action_types.action_type_id = ame_actions.action_type_id and
371: ame_actions.action_id = ame_action_usages.action_id and
372: ame_action_usages.rule_id = ruleIdIn and
373: sysdate between ame_action_usages.start_date and
374: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
375: sysdate between ame_action_types.start_date and
376: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and

Line 373: sysdate between ame_action_usages.start_date and

369: where
370: ame_action_types.action_type_id = ame_actions.action_type_id and
371: ame_actions.action_id = ame_action_usages.action_id and
372: ame_action_usages.rule_id = ruleIdIn and
373: sysdate between ame_action_usages.start_date and
374: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
375: sysdate between ame_action_types.start_date and
376: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
377: sysdate between ame_actions.start_date and

Line 374: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and

370: ame_action_types.action_type_id = ame_actions.action_type_id and
371: ame_actions.action_id = ame_action_usages.action_id and
372: ame_action_usages.rule_id = ruleIdIn and
373: sysdate between ame_action_usages.start_date and
374: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
375: sysdate between ame_action_types.start_date and
376: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
377: sysdate between ame_actions.start_date and
378: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);

Line 1543: from ame_action_usages,

1539: subOrListModActionCount integer;
1540: begin
1541: select count(distinct ame_action_types.action_type_id)
1542: into subOrListModActionCount
1543: from ame_action_usages,
1544: ame_actions,
1545: ame_action_types,
1546: ame_action_type_usages
1547: where ame_action_usages.rule_id = ruleIdIn and

Line 1547: where ame_action_usages.rule_id = ruleIdIn and

1543: from ame_action_usages,
1544: ame_actions,
1545: ame_action_types,
1546: ame_action_type_usages
1547: where ame_action_usages.rule_id = ruleIdIn and
1548: ame_action_usages.action_id = ame_actions.action_id and
1549: ame_action_types.action_type_id = ame_actions.action_type_id and
1550: ame_action_type_usages.action_type_id = ame_action_types.action_type_id and
1551: ame_action_type_usages.rule_type in (ame_util.substitutionRuleType,

Line 1548: ame_action_usages.action_id = ame_actions.action_id and

1544: ame_actions,
1545: ame_action_types,
1546: ame_action_type_usages
1547: where ame_action_usages.rule_id = ruleIdIn and
1548: ame_action_usages.action_id = ame_actions.action_id and
1549: ame_action_types.action_type_id = ame_actions.action_type_id and
1550: ame_action_type_usages.action_type_id = ame_action_types.action_type_id and
1551: ame_action_type_usages.rule_type in (ame_util.substitutionRuleType,
1552: ame_util.listModRuleType) and

Line 1553: sysdate between ame_action_usages.start_date and

1549: ame_action_types.action_type_id = ame_actions.action_type_id and
1550: ame_action_type_usages.action_type_id = ame_action_types.action_type_id and
1551: ame_action_type_usages.rule_type in (ame_util.substitutionRuleType,
1552: ame_util.listModRuleType) and
1553: sysdate between ame_action_usages.start_date and
1554: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
1555: sysdate between ame_action_type_usages.start_date and
1556: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate) and
1557: sysdate between ame_action_types.start_date and

Line 1554: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and

1550: ame_action_type_usages.action_type_id = ame_action_types.action_type_id and
1551: ame_action_type_usages.rule_type in (ame_util.substitutionRuleType,
1552: ame_util.listModRuleType) and
1553: sysdate between ame_action_usages.start_date and
1554: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
1555: sysdate between ame_action_type_usages.start_date and
1556: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate) and
1557: sysdate between ame_action_types.start_date and
1558: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and

Line 1897: insert into ame_action_usages(rule_id,

1893: endDateToInsert);
1894: end loop;
1895: end if;
1896: for tempIndex in 1 .. actionIdsIn.count loop
1897: insert into ame_action_usages(rule_id,
1898: action_id,
1899: created_by,
1900: creation_date,
1901: last_updated_by,

Line 2267: update ame_action_usages

2263: processingDateIn => processingDate);
2264: getActionIds(ruleIdIn => ruleIdIn,
2265: actionIdListOut => actionIdList);
2266: for i in 1..actionIdList.count loop
2267: update ame_action_usages
2268: set
2269: last_updated_by = currentUserId,
2270: last_update_date = processingDate,
2271: last_update_login = currentUserId,

Line 2512: ame_action_usages

2508: cursor actionTypeIdsCursor(ruleIdIn in integer) is
2509: select distinct(ame_action_types.action_type_id) action_type_id
2510: from ame_action_types,
2511: ame_actions,
2512: ame_action_usages
2513: where
2514: ame_action_types.action_type_id = ame_actions.action_type_id and
2515: ame_actions.action_id = ame_action_usages.action_id and
2516: ame_action_usages.rule_id = ruleIdIn and

Line 2515: ame_actions.action_id = ame_action_usages.action_id and

2511: ame_actions,
2512: ame_action_usages
2513: where
2514: ame_action_types.action_type_id = ame_actions.action_type_id and
2515: ame_actions.action_id = ame_action_usages.action_id and
2516: ame_action_usages.rule_id = ruleIdIn and
2517: sysdate between ame_action_usages.start_date and
2518: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
2519: sysdate between ame_action_types.start_date and

Line 2516: ame_action_usages.rule_id = ruleIdIn and

2512: ame_action_usages
2513: where
2514: ame_action_types.action_type_id = ame_actions.action_type_id and
2515: ame_actions.action_id = ame_action_usages.action_id and
2516: ame_action_usages.rule_id = ruleIdIn and
2517: sysdate between ame_action_usages.start_date and
2518: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
2519: sysdate between ame_action_types.start_date and
2520: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and

Line 2517: sysdate between ame_action_usages.start_date and

2513: where
2514: ame_action_types.action_type_id = ame_actions.action_type_id and
2515: ame_actions.action_id = ame_action_usages.action_id and
2516: ame_action_usages.rule_id = ruleIdIn and
2517: sysdate between ame_action_usages.start_date and
2518: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
2519: sysdate between ame_action_types.start_date and
2520: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
2521: sysdate between ame_actions.start_date and

Line 2518: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and

2514: ame_action_types.action_type_id = ame_actions.action_type_id and
2515: ame_actions.action_id = ame_action_usages.action_id and
2516: ame_action_usages.rule_id = ruleIdIn and
2517: sysdate between ame_action_usages.start_date and
2518: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) and
2519: sysdate between ame_action_types.start_date and
2520: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
2521: sysdate between ame_actions.start_date and
2522: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);

Line 3061: update ame_action_usages

3057: ((sysdate between start_date and
3058: nvl(end_date - ame_util.oneSecond, sysdate)) or
3059: (sysdate < start_date and
3060: start_date < nvl(end_date,start_date + ame_util.oneSecond)));
3061: update ame_action_usages
3062: set
3063: last_updated_by = currentUserId,
3064: last_update_date = endDate,
3065: last_update_login = currentUserId,

Line 3601: ame_action_usages.action_id

3597: procedure getActionIds(ruleIdIn in integer,
3598: actionIdListOut out nocopy ame_util.idList) as
3599: cursor actionCursor(ruleIdIn in integer) is
3600: select
3601: ame_action_usages.action_id
3602: from
3603: ame_action_usages
3604: where
3605: rule_id = ruleIdIn and

Line 3603: ame_action_usages

3599: cursor actionCursor(ruleIdIn in integer) is
3600: select
3601: ame_action_usages.action_id
3602: from
3603: ame_action_usages
3604: where
3605: rule_id = ruleIdIn and
3606: ((sysdate between ame_action_usages.start_date and
3607: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or

Line 3606: ((sysdate between ame_action_usages.start_date and

3602: from
3603: ame_action_usages
3604: where
3605: rule_id = ruleIdIn and
3606: ((sysdate between ame_action_usages.start_date and
3607: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
3608: (sysdate < ame_action_usages.start_date and
3609: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
3610: ame_action_usages.start_date + ame_util.oneSecond)));

Line 3607: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or

3603: ame_action_usages
3604: where
3605: rule_id = ruleIdIn and
3606: ((sysdate between ame_action_usages.start_date and
3607: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
3608: (sysdate < ame_action_usages.start_date and
3609: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
3610: ame_action_usages.start_date + ame_util.oneSecond)));
3611: actionId integer;

Line 3608: (sysdate < ame_action_usages.start_date and

3604: where
3605: rule_id = ruleIdIn and
3606: ((sysdate between ame_action_usages.start_date and
3607: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
3608: (sysdate < ame_action_usages.start_date and
3609: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
3610: ame_action_usages.start_date + ame_util.oneSecond)));
3611: actionId integer;
3612: tempIndex integer;

Line 3609: ame_action_usages.start_date < nvl(ame_action_usages.end_date,

3605: rule_id = ruleIdIn and
3606: ((sysdate between ame_action_usages.start_date and
3607: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
3608: (sysdate < ame_action_usages.start_date and
3609: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
3610: ame_action_usages.start_date + ame_util.oneSecond)));
3611: actionId integer;
3612: tempIndex integer;
3613: begin

Line 3610: ame_action_usages.start_date + ame_util.oneSecond)));

3606: ((sysdate between ame_action_usages.start_date and
3607: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
3608: (sysdate < ame_action_usages.start_date and
3609: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
3610: ame_action_usages.start_date + ame_util.oneSecond)));
3611: actionId integer;
3612: tempIndex integer;
3613: begin
3614: tempIndex := 1;

Line 3644: ame_action_usages

3640: ame_action_types.dynamic_description,
3641: ame_action_types.description_query
3642: from ame_actions,
3643: ame_action_types,
3644: ame_action_usages
3645: where
3646: ame_actions.action_type_id = ame_action_types.action_type_id and
3647: ame_actions.action_id = ame_action_usages.action_id and
3648: ame_action_usages.rule_id = ruleIdIn and

Line 3647: ame_actions.action_id = ame_action_usages.action_id and

3643: ame_action_types,
3644: ame_action_usages
3645: where
3646: ame_actions.action_type_id = ame_action_types.action_type_id and
3647: ame_actions.action_id = ame_action_usages.action_id and
3648: ame_action_usages.rule_id = ruleIdIn and
3649: sysdate between ame_actions.start_date and
3650: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and
3651: sysdate between ame_action_types.start_date and

Line 3648: ame_action_usages.rule_id = ruleIdIn and

3644: ame_action_usages
3645: where
3646: ame_actions.action_type_id = ame_action_types.action_type_id and
3647: ame_actions.action_id = ame_action_usages.action_id and
3648: ame_action_usages.rule_id = ruleIdIn and
3649: sysdate between ame_actions.start_date and
3650: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and
3651: sysdate between ame_action_types.start_date and
3652: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and

Line 3653: ((sysdate between ame_action_usages.start_date and

3649: sysdate between ame_actions.start_date and
3650: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and
3651: sysdate between ame_action_types.start_date and
3652: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
3653: ((sysdate between ame_action_usages.start_date and
3654: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
3655: (sysdate < ame_action_usages.start_date and
3656: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
3657: ame_action_usages.start_date + ame_util.oneSecond)))

Line 3654: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or

3650: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and
3651: sysdate between ame_action_types.start_date and
3652: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
3653: ((sysdate between ame_action_usages.start_date and
3654: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
3655: (sysdate < ame_action_usages.start_date and
3656: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
3657: ame_action_usages.start_date + ame_util.oneSecond)))
3658: order by ame_actions.created_by, ame_actions.description;

Line 3655: (sysdate < ame_action_usages.start_date and

3651: sysdate between ame_action_types.start_date and
3652: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
3653: ((sysdate between ame_action_usages.start_date and
3654: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
3655: (sysdate < ame_action_usages.start_date and
3656: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
3657: ame_action_usages.start_date + ame_util.oneSecond)))
3658: order by ame_actions.created_by, ame_actions.description;
3659: actionId integer;

Line 3656: ame_action_usages.start_date < nvl(ame_action_usages.end_date,

3652: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
3653: ((sysdate between ame_action_usages.start_date and
3654: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
3655: (sysdate < ame_action_usages.start_date and
3656: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
3657: ame_action_usages.start_date + ame_util.oneSecond)))
3658: order by ame_actions.created_by, ame_actions.description;
3659: actionId integer;
3660: tempActionDescription ame_util.stringType;

Line 3657: ame_action_usages.start_date + ame_util.oneSecond)))

3653: ((sysdate between ame_action_usages.start_date and
3654: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
3655: (sysdate < ame_action_usages.start_date and
3656: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
3657: ame_action_usages.start_date + ame_util.oneSecond)))
3658: order by ame_actions.created_by, ame_actions.description;
3659: actionId integer;
3660: tempActionDescription ame_util.stringType;
3661: tempIndex integer;

Line 3732: from ame_action_usages

3728: ame_actions.action_type_id = ame_action_types.action_type_id and
3729: ame_actions.action_type_id = actionTypeIdIn and
3730: ame_actions.action_id not in
3731: (select action_id
3732: from ame_action_usages
3733: where
3734: rule_id = ruleIdIn and
3735: ((sysdate between ame_action_usages.start_date and
3736: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or

Line 3735: ((sysdate between ame_action_usages.start_date and

3731: (select action_id
3732: from ame_action_usages
3733: where
3734: rule_id = ruleIdIn and
3735: ((sysdate between ame_action_usages.start_date and
3736: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
3737: (sysdate < ame_action_usages.start_date and
3738: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
3739: ame_action_usages.start_date + ame_util.oneSecond)))) and

Line 3736: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or

3732: from ame_action_usages
3733: where
3734: rule_id = ruleIdIn and
3735: ((sysdate between ame_action_usages.start_date and
3736: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
3737: (sysdate < ame_action_usages.start_date and
3738: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
3739: ame_action_usages.start_date + ame_util.oneSecond)))) and
3740: sysdate between ame_actions.start_date and

Line 3737: (sysdate < ame_action_usages.start_date and

3733: where
3734: rule_id = ruleIdIn and
3735: ((sysdate between ame_action_usages.start_date and
3736: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
3737: (sysdate < ame_action_usages.start_date and
3738: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
3739: ame_action_usages.start_date + ame_util.oneSecond)))) and
3740: sysdate between ame_actions.start_date and
3741: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and

Line 3738: ame_action_usages.start_date < nvl(ame_action_usages.end_date,

3734: rule_id = ruleIdIn and
3735: ((sysdate between ame_action_usages.start_date and
3736: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
3737: (sysdate < ame_action_usages.start_date and
3738: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
3739: ame_action_usages.start_date + ame_util.oneSecond)))) and
3740: sysdate between ame_actions.start_date and
3741: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and
3742: sysdate between ame_action_types.start_date and

Line 3739: ame_action_usages.start_date + ame_util.oneSecond)))) and

3735: ((sysdate between ame_action_usages.start_date and
3736: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
3737: (sysdate < ame_action_usages.start_date and
3738: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
3739: ame_action_usages.start_date + ame_util.oneSecond)))) and
3740: sysdate between ame_actions.start_date and
3741: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and
3742: sysdate between ame_action_types.start_date and
3743: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate)

Line 4149: ame_action_usages,

4145: union
4146: select ame_mandatory_attributes.attribute_id attribute_id
4147: from
4148: ame_mandatory_attributes,
4149: ame_action_usages,
4150: ame_actions
4151: where
4152: ame_mandatory_attributes.action_type_id = ame_actions.action_type_id and
4153: ame_actions.action_id = ame_action_usages.action_id and

Line 4153: ame_actions.action_id = ame_action_usages.action_id and

4149: ame_action_usages,
4150: ame_actions
4151: where
4152: ame_mandatory_attributes.action_type_id = ame_actions.action_type_id and
4153: ame_actions.action_id = ame_action_usages.action_id and
4154: ame_action_usages.rule_id = ruleIdIn and
4155: (ame_mandatory_attributes.start_date <= sysdate and
4156: (ame_mandatory_attributes.end_date is null or sysdate < ame_mandatory_attributes.end_date)) and
4157: ((sysdate between ame_action_usages.start_date and

Line 4154: ame_action_usages.rule_id = ruleIdIn and

4150: ame_actions
4151: where
4152: ame_mandatory_attributes.action_type_id = ame_actions.action_type_id and
4153: ame_actions.action_id = ame_action_usages.action_id and
4154: ame_action_usages.rule_id = ruleIdIn and
4155: (ame_mandatory_attributes.start_date <= sysdate and
4156: (ame_mandatory_attributes.end_date is null or sysdate < ame_mandatory_attributes.end_date)) and
4157: ((sysdate between ame_action_usages.start_date and
4158: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or

Line 4157: ((sysdate between ame_action_usages.start_date and

4153: ame_actions.action_id = ame_action_usages.action_id and
4154: ame_action_usages.rule_id = ruleIdIn and
4155: (ame_mandatory_attributes.start_date <= sysdate and
4156: (ame_mandatory_attributes.end_date is null or sysdate < ame_mandatory_attributes.end_date)) and
4157: ((sysdate between ame_action_usages.start_date and
4158: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
4159: (sysdate < ame_action_usages.start_date and
4160: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
4161: ame_action_usages.start_date + ame_util.oneSecond))) and

Line 4158: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or

4154: ame_action_usages.rule_id = ruleIdIn and
4155: (ame_mandatory_attributes.start_date <= sysdate and
4156: (ame_mandatory_attributes.end_date is null or sysdate < ame_mandatory_attributes.end_date)) and
4157: ((sysdate between ame_action_usages.start_date and
4158: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
4159: (sysdate < ame_action_usages.start_date and
4160: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
4161: ame_action_usages.start_date + ame_util.oneSecond))) and
4162: (ame_actions.start_date <= sysdate and

Line 4159: (sysdate < ame_action_usages.start_date and

4155: (ame_mandatory_attributes.start_date <= sysdate and
4156: (ame_mandatory_attributes.end_date is null or sysdate < ame_mandatory_attributes.end_date)) and
4157: ((sysdate between ame_action_usages.start_date and
4158: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
4159: (sysdate < ame_action_usages.start_date and
4160: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
4161: ame_action_usages.start_date + ame_util.oneSecond))) and
4162: (ame_actions.start_date <= sysdate and
4163: (ame_actions.end_date is null or sysdate < ame_actions.end_date));

Line 4160: ame_action_usages.start_date < nvl(ame_action_usages.end_date,

4156: (ame_mandatory_attributes.end_date is null or sysdate < ame_mandatory_attributes.end_date)) and
4157: ((sysdate between ame_action_usages.start_date and
4158: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
4159: (sysdate < ame_action_usages.start_date and
4160: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
4161: ame_action_usages.start_date + ame_util.oneSecond))) and
4162: (ame_actions.start_date <= sysdate and
4163: (ame_actions.end_date is null or sysdate < ame_actions.end_date));
4164: tempIndex integer;

Line 4161: ame_action_usages.start_date + ame_util.oneSecond))) and

4157: ((sysdate between ame_action_usages.start_date and
4158: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
4159: (sysdate < ame_action_usages.start_date and
4160: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
4161: ame_action_usages.start_date + ame_util.oneSecond))) and
4162: (ame_actions.start_date <= sysdate and
4163: (ame_actions.end_date is null or sysdate < ame_actions.end_date));
4164: tempIndex integer;
4165: begin

Line 4648: update ame_action_usages

4644: end loop;
4645: end if;
4646: if actionCount > 0 then
4647: for i in 1..actionCount loop
4648: update ame_action_usages
4649: set
4650: last_updated_by = currentUserId,
4651: last_update_date = processingDate,
4652: last_update_login = currentUserId,