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 1960: ame_rules,

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

Line 1965: ame_rules.rule_id = ame_rule_usages.rule_id and

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

Line 1966: ame_rules.rule_id = ame_condition_usages.rule_id and

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

Line 1970: ((sysdate between ame_rules.start_date and

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

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

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

Line 1972: (sysdate < ame_rules.start_date and

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

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

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

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

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

Line 2414: ruleType ame_rules.rule_type%type;

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