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 710: ame_condition_usages

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

Line 743: ame_condition_usages

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

Line 745: ame_rule_usages.rule_id = ame_condition_usages.rule_id and

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

Line 747: ame_condition_usages.condition_id = conditionIdIn and

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

Line 753: ((sysdate between ame_condition_usages.start_date and

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

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

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

Line 755: (sysdate < ame_condition_usages.start_date and

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

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

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

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

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

Line 780: from ame_condition_usages

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

Line 1285: from ame_condition_usages

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

Line 1299: from ame_condition_usages

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

Line 1309: insert into ame_condition_usages(rule_id,

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

Line 1963: ame_condition_usages

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

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

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

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

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

Line 1982: (sysdate < ame_condition_usages.start_date and

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

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

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

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

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

Line 2423: update ame_condition_usages

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