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_CONDITION_PKG dependencies on AME_RULES

Line 1957: ame_rules,

1953: cursor getApplicationsCursor(conditionIdIn in integer,
1954: applicationIdIn in integer) is
1955: select distinct ame_calling_apps.application_name
1956: from
1957: ame_rules,
1958: ame_rule_usages,
1959: ame_calling_apps,
1960: ame_condition_usages
1961: where

Line 1962: ame_rules.rule_id = ame_rule_usages.rule_id and

1958: ame_rule_usages,
1959: ame_calling_apps,
1960: ame_condition_usages
1961: where
1962: ame_rules.rule_id = ame_rule_usages.rule_id and
1963: ame_rules.rule_id = ame_condition_usages.rule_id and
1964: ame_rule_usages.item_id = ame_calling_apps.application_id and
1965: ame_rule_usages.item_id <> applicationIdIn and
1966: ame_condition_usages.condition_id = conditionIdIn and

Line 1963: ame_rules.rule_id = ame_condition_usages.rule_id and

1959: ame_calling_apps,
1960: ame_condition_usages
1961: where
1962: ame_rules.rule_id = ame_rule_usages.rule_id and
1963: ame_rules.rule_id = ame_condition_usages.rule_id and
1964: ame_rule_usages.item_id = ame_calling_apps.application_id and
1965: ame_rule_usages.item_id <> applicationIdIn and
1966: ame_condition_usages.condition_id = conditionIdIn and
1967: ((sysdate between ame_rules.start_date and

Line 1967: ((sysdate between ame_rules.start_date and

1963: ame_rules.rule_id = ame_condition_usages.rule_id and
1964: ame_rule_usages.item_id = ame_calling_apps.application_id and
1965: ame_rule_usages.item_id <> applicationIdIn and
1966: ame_condition_usages.condition_id = conditionIdIn and
1967: ((sysdate between ame_rules.start_date and
1968: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate)) or
1969: (sysdate < ame_rules.start_date and
1970: ame_rules.start_date < nvl(ame_rules.end_date,
1971: ame_rules.start_date + ame_util.oneSecond))) and

Line 1968: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate)) or

1964: ame_rule_usages.item_id = ame_calling_apps.application_id and
1965: ame_rule_usages.item_id <> applicationIdIn and
1966: ame_condition_usages.condition_id = conditionIdIn and
1967: ((sysdate between ame_rules.start_date and
1968: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate)) or
1969: (sysdate < ame_rules.start_date and
1970: ame_rules.start_date < nvl(ame_rules.end_date,
1971: ame_rules.start_date + ame_util.oneSecond))) and
1972: ((sysdate between ame_rule_usages.start_date and

Line 1969: (sysdate < ame_rules.start_date and

1965: ame_rule_usages.item_id <> applicationIdIn and
1966: ame_condition_usages.condition_id = conditionIdIn and
1967: ((sysdate between ame_rules.start_date and
1968: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate)) or
1969: (sysdate < ame_rules.start_date and
1970: ame_rules.start_date < nvl(ame_rules.end_date,
1971: ame_rules.start_date + ame_util.oneSecond))) and
1972: ((sysdate between ame_rule_usages.start_date and
1973: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or

Line 1970: ame_rules.start_date < nvl(ame_rules.end_date,

1966: ame_condition_usages.condition_id = conditionIdIn and
1967: ((sysdate between ame_rules.start_date and
1968: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate)) or
1969: (sysdate < ame_rules.start_date and
1970: ame_rules.start_date < nvl(ame_rules.end_date,
1971: ame_rules.start_date + ame_util.oneSecond))) and
1972: ((sysdate between ame_rule_usages.start_date and
1973: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
1974: (sysdate < ame_rule_usages.start_date and

Line 1971: ame_rules.start_date + ame_util.oneSecond))) and

1967: ((sysdate between ame_rules.start_date and
1968: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate)) or
1969: (sysdate < ame_rules.start_date and
1970: ame_rules.start_date < nvl(ame_rules.end_date,
1971: ame_rules.start_date + ame_util.oneSecond))) and
1972: ((sysdate between ame_rule_usages.start_date and
1973: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
1974: (sysdate < ame_rule_usages.start_date and
1975: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,

Line 2411: ruleType ame_rules.rule_type%type;

2407: errorCode integer;
2408: errorMessage ame_util.longestStringType;
2409: inUseException exception;
2410: processingDate date;
2411: ruleType ame_rules.rule_type%type;
2412: tempIndex integer;
2413: begin
2414: if processingDateIn is null then
2415: processingDate := sysdate;