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_ENGINE dependencies on AME_ACTIONS

Line 3775: ame_actions.action_type_id,

3771: end fetchActiveConditionUsages;
3772: procedure fetchApplicableActions as
3773: cursor applicableActionsCursor(ruleIdIn in integer) is
3774: select
3775: ame_actions.action_type_id,
3776: ame_actions.parameter,
3777: ame_actions.parameter_two
3778: from
3779: ame_actions,

Line 3776: ame_actions.parameter,

3772: procedure fetchApplicableActions as
3773: cursor applicableActionsCursor(ruleIdIn in integer) is
3774: select
3775: ame_actions.action_type_id,
3776: ame_actions.parameter,
3777: ame_actions.parameter_two
3778: from
3779: ame_actions,
3780: ame_action_usages

Line 3777: ame_actions.parameter_two

3773: cursor applicableActionsCursor(ruleIdIn in integer) is
3774: select
3775: ame_actions.action_type_id,
3776: ame_actions.parameter,
3777: ame_actions.parameter_two
3778: from
3779: ame_actions,
3780: ame_action_usages
3781: where

Line 3779: ame_actions,

3775: ame_actions.action_type_id,
3776: ame_actions.parameter,
3777: ame_actions.parameter_two
3778: from
3779: ame_actions,
3780: ame_action_usages
3781: where
3782: ame_actions.action_id = ame_action_usages.action_id and
3783: ame_action_usages.rule_id = ruleIdIn and

Line 3782: ame_actions.action_id = ame_action_usages.action_id and

3778: from
3779: ame_actions,
3780: ame_action_usages
3781: where
3782: ame_actions.action_id = ame_action_usages.action_id and
3783: ame_action_usages.rule_id = ruleIdIn and
3784: engEffectiveRuleDate between
3785: ame_actions.start_date and
3786: nvl(ame_actions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

Line 3785: ame_actions.start_date and

3781: where
3782: ame_actions.action_id = ame_action_usages.action_id and
3783: ame_action_usages.rule_id = ruleIdIn and
3784: engEffectiveRuleDate between
3785: ame_actions.start_date and
3786: nvl(ame_actions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3787: engEffectiveRuleDate between
3788: ame_action_usages.start_date and
3789: nvl(ame_action_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate);

Line 3786: nvl(ame_actions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

3782: ame_actions.action_id = ame_action_usages.action_id and
3783: ame_action_usages.rule_id = ruleIdIn and
3784: engEffectiveRuleDate between
3785: ame_actions.start_date and
3786: nvl(ame_actions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3787: engEffectiveRuleDate between
3788: ame_action_usages.start_date and
3789: nvl(ame_action_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate);
3790: productionActionTypeId integer;

Line 4405: ame_actions,

4401: and nvl(ame_condition_usages.end_date - (1/86400), engEffectiveRuleDate)))
4402: union
4403: select 1
4404: from ame_mandatory_attributes,
4405: ame_actions,
4406: ame_action_usages,
4407: ame_rules,
4408: ame_rule_usages
4409: where ame_mandatory_attributes.attribute_id = ame_attributes.attribute_id

Line 4411: ame_actions.action_type_id

4407: ame_rules,
4408: ame_rule_usages
4409: where ame_mandatory_attributes.attribute_id = ame_attributes.attribute_id
4410: and ame_mandatory_attributes.action_type_id =
4411: ame_actions.action_type_id
4412: and ame_actions.action_id = ame_action_usages.action_id
4413: and ame_action_usages.rule_id = ame_rules.rule_id
4414: and ame_rules.rule_id = ame_rule_usages.rule_id
4415: and ame_rule_usages.item_id = applicationIdIn

Line 4412: and ame_actions.action_id = ame_action_usages.action_id

4408: ame_rule_usages
4409: where ame_mandatory_attributes.attribute_id = ame_attributes.attribute_id
4410: and ame_mandatory_attributes.action_type_id =
4411: ame_actions.action_type_id
4412: and ame_actions.action_id = ame_action_usages.action_id
4413: and ame_action_usages.rule_id = ame_rules.rule_id
4414: and ame_rules.rule_id = ame_rule_usages.rule_id
4415: and ame_rule_usages.item_id = applicationIdIn
4416: and ((engEffectiveRuleDate between ame_rules.start_date

Line 4422: and engEffectiveRuleDate between ame_actions.start_date

4418: and ((engEffectiveRuleDate between ame_rule_usages.start_date
4419: and nvl(ame_rule_usages.end_date - (1/86400), engEffectiveRuleDate)))
4420: and engEffectiveRuleDate between ame_mandatory_attributes.start_date
4421: and nvl(ame_mandatory_attributes.end_date - (1/86400), engEffectiveRuleDate)
4422: and engEffectiveRuleDate between ame_actions.start_date
4423: and nvl(ame_actions.end_date - (1/86400), engEffectiveRuleDate)
4424: and ((engEffectiveRuleDate between ame_action_usages.start_date
4425: and nvl(ame_action_usages.end_date - (1/86400), engEffectiveRuleDate)))
4426: )

Line 4423: and nvl(ame_actions.end_date - (1/86400), engEffectiveRuleDate)

4419: and nvl(ame_rule_usages.end_date - (1/86400), engEffectiveRuleDate)))
4420: and engEffectiveRuleDate between ame_mandatory_attributes.start_date
4421: and nvl(ame_mandatory_attributes.end_date - (1/86400), engEffectiveRuleDate)
4422: and engEffectiveRuleDate between ame_actions.start_date
4423: and nvl(ame_actions.end_date - (1/86400), engEffectiveRuleDate)
4424: and ((engEffectiveRuleDate between ame_action_usages.start_date
4425: and nvl(ame_action_usages.end_date - (1/86400), engEffectiveRuleDate)))
4426: )
4427: /*

Line 11500: exchangeParameter ame_actions.parameter%type;

11496: exchangeAppItemId ame_util.stringType;
11497: exchangeApproverCategory ame_util.charType;
11498: exchangeItemClassId integer;
11499: exchangeItemId ame_util.stringType;
11500: exchangeParameter ame_actions.parameter%type;
11501: exchangeParameterTwo ame_actions.parameter_two%type;
11502: exchangePriority integer;
11503: exchangeRuleId integer;
11504: exchangeRuleItemClassId integer;

Line 11501: exchangeParameterTwo ame_actions.parameter_two%type;

11497: exchangeApproverCategory ame_util.charType;
11498: exchangeItemClassId integer;
11499: exchangeItemId ame_util.stringType;
11500: exchangeParameter ame_actions.parameter%type;
11501: exchangeParameterTwo ame_actions.parameter_two%type;
11502: exchangePriority integer;
11503: exchangeRuleId integer;
11504: exchangeRuleItemClassId integer;
11505: exchangeRuleType ame_util.stringType;