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_ACTIONS

Line 133: ame_actions,

129: actionTypeIdsIn in ame_util.idList) return boolean as
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

Line 136: ame_action_types.action_type_id = ame_actions.action_type_id and

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
139: sysdate between ame_action_usages.start_date and
140: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) 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 143: sysdate between ame_actions.start_date 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);
145: actionTypeIds ame_util.idList;
146: finalAuthActionTypeId integer;
147: finalAuthority boolean;

Line 144: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);

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);
145: actionTypeIds ame_util.idList;
146: finalAuthActionTypeId integer;
147: finalAuthority boolean;
148: nonFinalAuthActionTypeId integer;

Line 367: ame_actions,

363: function finalAuthorityActionType2(ruleIdIn in integer) return boolean as
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

Line 370: ame_action_types.action_type_id = ame_actions.action_type_id and

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
373: sysdate between ame_action_usages.start_date and
374: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) 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 377: sysdate between ame_actions.start_date 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);
379: finalAuthActionTypeId integer;
380: begin
381: finalAuthActionTypeId :=

Line 378: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);

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);
379: finalAuthActionTypeId integer;
380: begin
381: finalAuthActionTypeId :=
382: ame_action_pkg.getActionTypeIdByName(actionTypeNameIn => ame_util.finalAuthorityTypeName);

Line 1385: ame_actions

1381: cursor actionTypeUsagesCur(actionIdIn in integer) is
1382: select ame_action_type_usages.rule_type
1383: from ame_action_type_usages,
1384: ame_action_types,
1385: ame_actions
1386: where
1387: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and
1388: ame_action_types.action_type_id = ame_actions.action_type_id and
1389: ame_actions.action_id = actionIdIn and

Line 1388: ame_action_types.action_type_id = ame_actions.action_type_id and

1384: ame_action_types,
1385: ame_actions
1386: where
1387: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and
1388: ame_action_types.action_type_id = ame_actions.action_type_id and
1389: ame_actions.action_id = actionIdIn and
1390: sysdate between ame_action_type_usages.start_date and
1391: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate) and
1392: sysdate between ame_action_types.start_date and

Line 1389: ame_actions.action_id = actionIdIn and

1385: ame_actions
1386: where
1387: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and
1388: ame_action_types.action_type_id = ame_actions.action_type_id and
1389: ame_actions.action_id = actionIdIn and
1390: sysdate between ame_action_type_usages.start_date and
1391: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate) and
1392: sysdate between ame_action_types.start_date and
1393: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and

Line 1394: sysdate between ame_actions.start_date and

1390: sysdate between ame_action_type_usages.start_date and
1391: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate) and
1392: sysdate between ame_action_types.start_date and
1393: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1394: sysdate between ame_actions.start_date and
1395: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);
1396: begin
1397: /*
1398: With exception of the combination rule type, a rule must have at least

Line 1395: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);

1391: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate) and
1392: sysdate between ame_action_types.start_date and
1393: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
1394: sysdate between ame_actions.start_date and
1395: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);
1396: begin
1397: /*
1398: With exception of the combination rule type, a rule must have at least
1399: one action of an action type that has an action-type usage for

Line 1544: ame_actions,

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
1548: ame_action_usages.action_id = ame_actions.action_id and

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 1549: ame_action_types.action_type_id = ame_actions.action_type_id and

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
1553: sysdate between ame_action_usages.start_date and

Line 1559: sysdate between ame_actions.start_date 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
1559: sysdate between ame_actions.start_date and
1560: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);
1561: if(subOrListModActionCount > 0) then
1562: return(true);
1563: else

Line 1560: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);

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
1559: sysdate between ame_actions.start_date and
1560: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);
1561: if(subOrListModActionCount > 0) then
1562: return(true);
1563: else
1564: return(false);

Line 2511: ame_actions,

2507: function nonFinalAuthorityActionType2(ruleIdIn in integer) return boolean as
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

Line 2514: ame_action_types.action_type_id = ame_actions.action_type_id and

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
2517: sysdate between ame_action_usages.start_date and
2518: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate) 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 2521: sysdate between ame_actions.start_date 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);
2523: nonFinalAuthActionTypeId integer;
2524: begin
2525: nonFinalAuthActionTypeId :=

Line 2522: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);

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);
2523: nonFinalAuthActionTypeId integer;
2524: begin
2525: nonFinalAuthActionTypeId :=
2526: ame_action_pkg.getActionTypeIdByName(actionTypeNameIn => ame_util.nonFinalAuthority);

Line 2875: actionId1 ame_actions.action_id%type;

2871: actionCount integer;
2872: actionCount2 integer;
2873: actionDeletionException exception;
2874: actionId integer;
2875: actionId1 ame_actions.action_id%type;
2876: actionIdListCopy ame_util.idList;
2877: actionTypeId1 ame_action_types.action_type_id%type;
2878: actionTypeId2 ame_action_types.action_type_id%type;
2879: actionTypeUsageException exception;

Line 3636: select ame_actions.action_id,

3632: procedure getActions(ruleIdIn in integer,
3633: actionIdsOut out nocopy ame_util.idList,
3634: actionDescriptionsOut out nocopy ame_util.longStringList) as
3635: cursor actionsCursor(ruleIdIn in integer) is
3636: select ame_actions.action_id,
3637: ame_actions.parameter,
3638: ame_actions.parameter_two,
3639: ame_action_types.name,
3640: ame_action_types.dynamic_description,

Line 3637: ame_actions.parameter,

3633: actionIdsOut out nocopy ame_util.idList,
3634: actionDescriptionsOut out nocopy ame_util.longStringList) as
3635: cursor actionsCursor(ruleIdIn in integer) is
3636: select ame_actions.action_id,
3637: ame_actions.parameter,
3638: ame_actions.parameter_two,
3639: ame_action_types.name,
3640: ame_action_types.dynamic_description,
3641: ame_action_types.description_query

Line 3638: ame_actions.parameter_two,

3634: actionDescriptionsOut out nocopy ame_util.longStringList) as
3635: cursor actionsCursor(ruleIdIn in integer) is
3636: select ame_actions.action_id,
3637: ame_actions.parameter,
3638: ame_actions.parameter_two,
3639: ame_action_types.name,
3640: ame_action_types.dynamic_description,
3641: ame_action_types.description_query
3642: from ame_actions,

Line 3642: from ame_actions,

3638: ame_actions.parameter_two,
3639: ame_action_types.name,
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

Line 3646: ame_actions.action_type_id = ame_action_types.action_type_id and

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
3649: sysdate between ame_actions.start_date and
3650: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) 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 3649: sysdate between ame_actions.start_date and

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
3653: ((sysdate between ame_action_usages.start_date and

Line 3650: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and

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
3653: ((sysdate between ame_action_usages.start_date and
3654: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or

Line 3658: order by ame_actions.created_by, ame_actions.description;

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;
3662: begin

Line 3719: select ame_actions.action_id,

3715: actionTypeIdIn in integer,
3716: actionIdsOut out nocopy ame_util.stringList,
3717: actionDescriptionsOut out nocopy ame_util.stringList) as
3718: cursor actionsCursor(ruleIdIn in integer) is
3719: select ame_actions.action_id,
3720: ame_actions.parameter,
3721: ame_actions.parameter_two,
3722: ame_actions.description,
3723: ame_action_types.dynamic_description,

Line 3720: ame_actions.parameter,

3716: actionIdsOut out nocopy ame_util.stringList,
3717: actionDescriptionsOut out nocopy ame_util.stringList) as
3718: cursor actionsCursor(ruleIdIn in integer) is
3719: select ame_actions.action_id,
3720: ame_actions.parameter,
3721: ame_actions.parameter_two,
3722: ame_actions.description,
3723: ame_action_types.dynamic_description,
3724: ame_action_types.description_query

Line 3721: ame_actions.parameter_two,

3717: actionDescriptionsOut out nocopy ame_util.stringList) as
3718: cursor actionsCursor(ruleIdIn in integer) is
3719: select ame_actions.action_id,
3720: ame_actions.parameter,
3721: ame_actions.parameter_two,
3722: ame_actions.description,
3723: ame_action_types.dynamic_description,
3724: ame_action_types.description_query
3725: from ame_actions,

Line 3722: ame_actions.description,

3718: cursor actionsCursor(ruleIdIn in integer) is
3719: select ame_actions.action_id,
3720: ame_actions.parameter,
3721: ame_actions.parameter_two,
3722: ame_actions.description,
3723: ame_action_types.dynamic_description,
3724: ame_action_types.description_query
3725: from ame_actions,
3726: ame_action_types

Line 3725: from ame_actions,

3721: ame_actions.parameter_two,
3722: ame_actions.description,
3723: ame_action_types.dynamic_description,
3724: ame_action_types.description_query
3725: from ame_actions,
3726: ame_action_types
3727: where
3728: ame_actions.action_type_id = ame_action_types.action_type_id and
3729: ame_actions.action_type_id = actionTypeIdIn and

Line 3728: ame_actions.action_type_id = ame_action_types.action_type_id and

3724: ame_action_types.description_query
3725: from ame_actions,
3726: ame_action_types
3727: where
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

Line 3729: ame_actions.action_type_id = actionTypeIdIn and

3725: from ame_actions,
3726: ame_action_types
3727: where
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

Line 3730: ame_actions.action_id not in

3726: ame_action_types
3727: where
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

Line 3740: sysdate between ame_actions.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)
3744: order by ame_actions.created_by, ame_actions.description;

Line 3741: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and

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)
3744: order by ame_actions.created_by, ame_actions.description;
3745: actionId integer;

Line 3744: order by ame_actions.created_by, ame_actions.description;

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)
3744: order by ame_actions.created_by, ame_actions.description;
3745: actionId integer;
3746: tempIndex integer;
3747: begin
3748: tempIndex := 1;

Line 4150: ame_actions

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
4154: ame_action_usages.rule_id = ruleIdIn and

Line 4152: ame_mandatory_attributes.action_type_id = ame_actions.action_type_id and

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

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 4162: (ame_actions.start_date <= sysdate 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
4166: tempIndex := 0;

Line 4163: (ame_actions.end_date is null or sysdate < ame_actions.end_date));

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
4166: tempIndex := 0;
4167: for tempAttribute in attributeCursor(ruleIdIn => ruleIdIn) loop