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_RULE_UTILITY_PKG dependencies on AME_CONDITIONS

Line 156: ,ame_conditions cond

152: ,applicationIdIn in integer
153: ,endDateIn in date ) is
154: select distinct atr.attribute_id, atr.name
155: from ame_attributes atr
156: ,ame_conditions cond
157: ,ame_condition_usages condu
158: ,ame_rules rules
159: where cond.attribute_id = atr.attribute_id
160: and condu.condition_id = cond.condition_id

Line 286: ,ame_conditions con

282: cursor checkLMConditions(ruleIdIn in integer
283: ,endDateIn in date) is
284: select 'Y'
285: from ame_rules rul
286: ,ame_conditions con
287: ,ame_condition_usages cnu
288: ,wf_roles wf
289: where rul.rule_id = ruleIdIn
290: and con.condition_id = cnu.condition_id

Line 492: ,ame_conditions cond

488: cursor checkAttributeUsagesCursor(ruleIdIn in integer
489: ,applicationIdIn in integer) is
490: select distinct atr.attribute_id, atr.name
491: from ame_attributes atr
492: ,ame_conditions cond
493: ,ame_condition_usages condu
494: ,ame_rules rules
495: where cond.attribute_id = atr.attribute_id
496: and condu.condition_id = cond.condition_id

Line 645: ,ame_conditions con

641: --+
642: cursor checkLMConditions(ruleIdIn in integer) is
643: select 'Y'
644: from ame_rules rul
645: ,ame_conditions con
646: ,ame_condition_usages cnu
647: ,wf_roles wf
648: where rul.rule_id = ruleIdIn
649: and con.condition_id = cnu.condition_id

Line 860: from ame_conditions con

856: cursor checkConditions(ruleIdIn in integer
857: ,endDateIn in date
858: ) is
859: select count(*)
860: from ame_conditions con
861: ,ame_condition_usages cnu
862: ,ame_rules rul
863: where rul.rule_id = ruleIdIn
864: and rul.end_date = endDateIn

Line 1119: ,ame_conditions con

1115: cursor getInvalidAttributes(applicationIdIn in integer
1116: ,conditionIdIn in integer) is
1117: select atr.attribute_id, atr.name
1118: from ame_attributes atr
1119: ,ame_conditions con
1120: where atr.attribute_id = con.attribute_id
1121: and con.condition_id = conditionIdIn
1122: and con.condition_type <> ame_util.listModConditionType
1123: and sysdate between atr.start_date and nvl(atr.end_date - (1/86400), sysdate)

Line 1134: from ame_conditions con

1130: and nvl(atu.end_date - (1/86400), sysdate));
1131: --+
1132: cursor checkLMCondition(conditionIdIn in integer) is
1133: select 'Y'
1134: from ame_conditions con
1135: ,wf_roles wf
1136: where con.condition_id = conditionIdIn
1137: and con.condition_type = ame_util.listModConditionType
1138: and con.parameter_two = wf.name

Line 1574: from ame_conditions

1570: procedure checkConditionId(p_condition_id in number) is
1571: --+
1572: cursor checkCondition(p_condition_id in number) is
1573: select count(*)
1574: from ame_conditions
1575: where condition_id = p_condition_id
1576: and sysdate between start_date and nvl(end_date - (1/86400),sysdate);
1577: l_count number(3);
1578: --+

Line 1938: ,ame_conditions cnd

1934: cursor getLMConditions(p_rule_id in integer) is
1935: select count(*)
1936: from ame_rules rul
1937: ,ame_condition_usages cnu
1938: ,ame_conditions cnd
1939: where rul.rule_id = p_rule_id
1940: and cnu.rule_id = rul.rule_id
1941: and cnd.condition_id = cnu.condition_id
1942: and cnd.condition_type = ame_util.listModConditionType

Line 1978: from ame_conditions cnd

1974: --+ Check if this application has a usage for the attribute on which the condition is based.
1975: cursor getConditions(p_application_id in integer
1976: ,p_condition_id in integer) is
1977: select count(*)
1978: from ame_conditions cnd
1979: ,ame_attribute_usages atu
1980: where cnd.condition_id = p_condition_id
1981: and cnd.condition_type <> ame_util.listModConditionType
1982: and atu.application_id = p_application_id

Line 1989: lm_param2 ame_conditions.parameter_two%type;

1985: and sysdate between atu.start_date and nvl(atu.end_date - (1/86400),sysdate);
1986: --+
1987: l_count number(3);
1988: lm_count number(3);
1989: lm_param2 ame_conditions.parameter_two%type;
1990: begin
1991: --+
1992: select count(*)
1993: into lm_count

Line 1994: from ame_conditions

1990: begin
1991: --+
1992: select count(*)
1993: into lm_count
1994: from ame_conditions
1995: where condition_type = ame_util.listModConditionType
1996: and condition_id = p_condition_id
1997: and sysdate between start_date and nvl(end_date - (1/86400),sysdate);
1998: --+

Line 2017: from ame_conditions

2013: else
2014: --+
2015: select parameter_two
2016: into lm_param2
2017: from ame_conditions
2018: where condition_id = p_condition_id
2019: and sysdate between start_date and nvl(end_date - (1/86400),sysdate);
2020: --+
2021: if is_pos_approver(p_name => lm_param2) then

Line 2099: from ame_conditions

2095: --+
2096: cursor getConditionParam(p_condition_id in integer) is
2097: select parameter_one
2098: ,parameter_two
2099: from ame_conditions
2100: where condition_id = p_condition_id
2101: and sysdate between start_date and nvl(end_date - (1/86400),sysdate);
2102: --+
2103: cursor getActionType(p_action_id in integer) is

Line 2112: l_param ame_conditions.parameter_one%type;

2108: and aty.action_type_id = act.action_type_id
2109: and sysdate between act.start_date and nvl(act.end_date - (1/86400),sysdate)
2110: and sysdate between aty.start_date and nvl(aty.end_date - (1/86400),sysdate);
2111: --+
2112: l_param ame_conditions.parameter_one%type;
2113: l_param_two ame_conditions.parameter_two%type;
2114: l_action_type ame_action_types.name%type;
2115: --+
2116: begin

Line 2113: l_param_two ame_conditions.parameter_two%type;

2109: and sysdate between act.start_date and nvl(act.end_date - (1/86400),sysdate)
2110: and sysdate between aty.start_date and nvl(aty.end_date - (1/86400),sysdate);
2111: --+
2112: l_param ame_conditions.parameter_one%type;
2113: l_param_two ame_conditions.parameter_two%type;
2114: l_action_type ame_action_types.name%type;
2115: --+
2116: begin
2117: open getConditionParam(p_condition_id => p_condition_id);

Line 2255: ,ame_conditions con

2251: select distinct atr.item_class_id
2252: from ame_rules rul
2253: ,ame_condition_usages cnu
2254: ,ame_attributes atr
2255: ,ame_conditions con
2256: ,ame_item_classes itc
2257: where rul.rule_id = p_rule_id
2258: and rul.rule_id = cnu.rule_id
2259: and cnu.condition_id = con.condition_id

Line 2279: l_con_type ame_conditions.condition_type%type;

2275: l_item_class_id ame_rules.item_class_id%type;
2276: l_header_item_class_id ame_rules.item_class_id%type;
2277: l_sub_ic_cond_list ame_util.idList;
2278: l_con_item_class_id ame_rules.item_class_id%type;
2279: l_con_type ame_conditions.condition_type%type;
2280: begin
2281: --+
2282: select condition_type
2283: into l_con_type

Line 2284: from ame_conditions

2280: begin
2281: --+
2282: select condition_type
2283: into l_con_type
2284: from ame_conditions
2285: where condition_id = p_condition_id
2286: and sysdate between start_date and nvl(end_date - (1/84600),sysdate);
2287: if l_con_type = ame_util.listModConditionType then
2288: return;

Line 2299: from ame_conditions con

2295: and sysdate between start_date and nvl(end_date - (1/84600),sysdate);
2296: --+
2297: select atr.item_class_id
2298: into l_con_item_class_id
2299: from ame_conditions con
2300: ,ame_attributes atr
2301: where con.attribute_id = atr.attribute_id
2302: and con.condition_id = p_condition_id
2303: and sysdate between con.start_date and nvl(con.end_date - (1/86400),sysdate)