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_CONDITION_USAGES

Line 707: ame_condition_usages

703: begin
704: select count(*)
705: into useCount
706: from
707: ame_condition_usages
708: where
709: condition_id = conditionIdIn and
710: rule_id = ruleIdIn and
711: ((sysdate between start_date and

Line 740: ame_condition_usages

736: select count(*)
737: into useCount
738: from
739: ame_rule_usages,
740: ame_condition_usages
741: where
742: ame_rule_usages.rule_id = ame_condition_usages.rule_id and
743: ame_rule_usages.item_id <> applicationIdIn and
744: ame_condition_usages.condition_id = conditionIdIn and

Line 742: ame_rule_usages.rule_id = ame_condition_usages.rule_id and

738: from
739: ame_rule_usages,
740: ame_condition_usages
741: where
742: ame_rule_usages.rule_id = ame_condition_usages.rule_id and
743: ame_rule_usages.item_id <> applicationIdIn and
744: ame_condition_usages.condition_id = conditionIdIn and
745: ((sysdate between ame_rule_usages.start_date and
746: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or

Line 744: ame_condition_usages.condition_id = conditionIdIn and

740: ame_condition_usages
741: where
742: ame_rule_usages.rule_id = ame_condition_usages.rule_id and
743: ame_rule_usages.item_id <> applicationIdIn and
744: ame_condition_usages.condition_id = conditionIdIn and
745: ((sysdate between ame_rule_usages.start_date and
746: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
747: (sysdate < ame_rule_usages.start_date and
748: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,

Line 750: ((sysdate between ame_condition_usages.start_date and

746: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
747: (sysdate < ame_rule_usages.start_date and
748: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
749: ame_rule_usages.start_date + ame_util.oneSecond))) and
750: ((sysdate between ame_condition_usages.start_date and
751: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
752: (sysdate < ame_condition_usages.start_date and
753: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
754: ame_condition_usages.start_date + ame_util.oneSecond))) ;

Line 751: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or

747: (sysdate < ame_rule_usages.start_date and
748: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
749: ame_rule_usages.start_date + ame_util.oneSecond))) and
750: ((sysdate between ame_condition_usages.start_date and
751: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
752: (sysdate < ame_condition_usages.start_date and
753: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
754: ame_condition_usages.start_date + ame_util.oneSecond))) ;
755: if(useCount > 0) then

Line 752: (sysdate < ame_condition_usages.start_date and

748: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
749: ame_rule_usages.start_date + ame_util.oneSecond))) and
750: ((sysdate between ame_condition_usages.start_date and
751: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
752: (sysdate < ame_condition_usages.start_date and
753: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
754: ame_condition_usages.start_date + ame_util.oneSecond))) ;
755: if(useCount > 0) then
756: return(true);

Line 753: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,

749: ame_rule_usages.start_date + ame_util.oneSecond))) and
750: ((sysdate between ame_condition_usages.start_date and
751: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
752: (sysdate < ame_condition_usages.start_date and
753: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
754: ame_condition_usages.start_date + ame_util.oneSecond))) ;
755: if(useCount > 0) then
756: return(true);
757: end if;

Line 754: ame_condition_usages.start_date + ame_util.oneSecond))) ;

750: ((sysdate between ame_condition_usages.start_date and
751: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
752: (sysdate < ame_condition_usages.start_date and
753: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
754: ame_condition_usages.start_date + ame_util.oneSecond))) ;
755: if(useCount > 0) then
756: return(true);
757: end if;
758: return(false);

Line 777: from ame_condition_usages

773: useCount integer;
774: begin
775: select count(*)
776: into useCount
777: from ame_condition_usages
778: where
779: condition_id = conditionIdIn and
780: ((sysdate between start_date and
781: nvl(end_date - ame_util.oneSecond, sysdate)) or

Line 1282: from ame_condition_usages

1278: processingDate := processingDateIn;
1279: end if;
1280: select count(*)
1281: into useCount
1282: from ame_condition_usages
1283: where
1284: condition_id = conditionIdIn and
1285: rule_id = ruleIdIn and
1286: ((sysdate between start_date and

Line 1296: from ame_condition_usages

1292: end if;
1293: currentUserId := ame_util.getCurrentUserId;
1294: select count(*)
1295: into tempCount
1296: from ame_condition_usages
1297: where
1298: condition_id = conditionIdIn and
1299: rule_id = ruleIdIn and
1300: created_by = ame_util.seededDataCreatedById;

Line 1306: insert into ame_condition_usages(rule_id,

1302: createdBy := ame_util.seededDataCreatedById;
1303: else
1304: createdBy := currentUserId;
1305: end if;
1306: insert into ame_condition_usages(rule_id,
1307: condition_id,
1308: created_by,
1309: creation_date,
1310: last_updated_by,

Line 1960: ame_condition_usages

1956: from
1957: ame_rules,
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

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 1966: ame_condition_usages.condition_id = conditionIdIn and

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

Line 1977: ((sysdate between ame_condition_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,
1976: ame_rule_usages.start_date + ame_util.oneSecond))) and
1977: ((sysdate between ame_condition_usages.start_date and
1978: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
1979: (sysdate < ame_condition_usages.start_date and
1980: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
1981: ame_condition_usages.start_date + ame_util.oneSecond))) and

Line 1978: nvl(ame_condition_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,
1976: ame_rule_usages.start_date + ame_util.oneSecond))) and
1977: ((sysdate between ame_condition_usages.start_date and
1978: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
1979: (sysdate < ame_condition_usages.start_date and
1980: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
1981: ame_condition_usages.start_date + ame_util.oneSecond))) and
1982: sysdate between ame_calling_apps.start_date and

Line 1979: (sysdate < ame_condition_usages.start_date and

1975: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
1976: ame_rule_usages.start_date + ame_util.oneSecond))) and
1977: ((sysdate between ame_condition_usages.start_date and
1978: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
1979: (sysdate < ame_condition_usages.start_date and
1980: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
1981: ame_condition_usages.start_date + ame_util.oneSecond))) and
1982: sysdate between ame_calling_apps.start_date and
1983: nvl(ame_calling_apps.end_date - ame_util.oneSecond, sysdate)

Line 1980: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,

1976: ame_rule_usages.start_date + ame_util.oneSecond))) and
1977: ((sysdate between ame_condition_usages.start_date and
1978: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
1979: (sysdate < ame_condition_usages.start_date and
1980: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
1981: ame_condition_usages.start_date + ame_util.oneSecond))) and
1982: sysdate between ame_calling_apps.start_date and
1983: nvl(ame_calling_apps.end_date - ame_util.oneSecond, sysdate)
1984: order by ame_calling_apps.application_name;

Line 1981: ame_condition_usages.start_date + ame_util.oneSecond))) and

1977: ((sysdate between ame_condition_usages.start_date and
1978: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
1979: (sysdate < ame_condition_usages.start_date and
1980: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
1981: ame_condition_usages.start_date + ame_util.oneSecond))) and
1982: sysdate between ame_calling_apps.start_date and
1983: nvl(ame_calling_apps.end_date - ame_util.oneSecond, sysdate)
1984: order by ame_calling_apps.application_name;
1985: tempIndex integer;

Line 2420: update ame_condition_usages

2416: else
2417: processingDate := processingDateIn;
2418: end if;
2419: currentUserId := ame_util.getCurrentUserId;
2420: update ame_condition_usages
2421: set
2422: last_updated_by = currentUserId,
2423: last_update_date = processingDate,
2424: last_update_login = currentUserId,