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_TYPES

Line 131: select distinct(ame_action_types.action_type_id) action_type_id

127: end bothSeededLMActionTypesChosen;
128: function bothSeededLMActionTypesChosen2(ruleIdIn in integer,
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

Line 132: from ame_action_types,

128: function bothSeededLMActionTypesChosen2(ruleIdIn in integer,
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

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 141: sysdate between ame_action_types.start_date 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);
145: actionTypeIds ame_util.idList;

Line 142: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) 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);
145: actionTypeIds ame_util.idList;
146: finalAuthActionTypeId integer;

Line 365: select distinct(ame_action_types.action_type_id) action_type_id

361: return(true);
362: end finalAuthorityActionType;
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

Line 366: from ame_action_types,

362: end finalAuthorityActionType;
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

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 375: sysdate between ame_action_types.start_date 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);
379: finalAuthActionTypeId integer;

Line 376: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) 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);
379: finalAuthActionTypeId integer;
380: begin

Line 1384: ame_action_types,

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

Line 1387: ame_action_types.action_type_id = ame_action_type_usages.action_type_id and

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
1390: sysdate between ame_action_type_usages.start_date and
1391: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, sysdate) 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 1392: sysdate between ame_action_types.start_date 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
1394: sysdate between ame_actions.start_date and
1395: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);
1396: begin

Line 1393: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) 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
1394: sysdate between ame_actions.start_date and
1395: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate);
1396: begin
1397: /*

Line 1541: select count(distinct ame_action_types.action_type_id)

1537: end hasNonProductionActionTypes;
1538: function hasSubOrListModAction(ruleIdIn in integer) return boolean as
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,

Line 1545: ame_action_types,

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

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

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

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

Line 2509: select distinct(ame_action_types.action_type_id) action_type_id

2505: return(true);
2506: end nonFinalAuthorityActionType;
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

Line 2510: from ame_action_types,

2506: end nonFinalAuthorityActionType;
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

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 2519: sysdate between ame_action_types.start_date 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);
2523: nonFinalAuthActionTypeId integer;

Line 2520: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) 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);
2523: nonFinalAuthActionTypeId integer;
2524: begin

Line 2877: actionTypeId1 ame_action_types.action_type_id%type;

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;
2880: conditionCount integer;
2881: applicationIds ame_util.idList;

Line 2878: actionTypeId2 ame_action_types.action_type_id%type;

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;
2880: conditionCount integer;
2881: applicationIds ame_util.idList;
2882: conditionId integer;

Line 3639: ame_action_types.name,

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,
3643: ame_action_types,

Line 3640: ame_action_types.dynamic_description,

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,
3643: ame_action_types,
3644: ame_action_usages

Line 3641: ame_action_types.description_query

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,
3643: ame_action_types,
3644: ame_action_usages
3645: where

Line 3643: ame_action_types,

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
3647: ame_actions.action_id = ame_action_usages.action_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 3651: sysdate between ame_action_types.start_date 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
3655: (sysdate < ame_action_usages.start_date and

Line 3652: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) 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
3655: (sysdate < ame_action_usages.start_date and
3656: ame_action_usages.start_date < nvl(ame_action_usages.end_date,

Line 3723: ame_action_types.dynamic_description,

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

Line 3724: ame_action_types.description_query

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
3727: where
3728: ame_actions.action_type_id = ame_action_types.action_type_id and

Line 3726: ame_action_types

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
3730: ame_actions.action_id not in

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 3742: sysdate between ame_action_types.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;
3746: tempIndex integer;

Line 3743: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate)

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;
3746: tempIndex integer;
3747: begin