APPS.AME_RULE_UTILITY_PKG dependencies on AME_ATTRIBUTES

Line 155: from ame_attributes atr

151: cursor checkAttributeUsagesCursor(ruleIdIn in integer
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

Line 175: from ame_attributes atr

171: and rules.end_date = endDateIn
172: and condu.end_date = rules.end_date
173: union
174: select distinct atr.attribute_id, atr.name
175: from ame_attributes atr
176: ,ame_action_usages acu
177: ,ame_actions act
178: ,ame_mandatory_attributes ama
179: ,ame_rules rules

Line 491: from ame_attributes atr

487: --+
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

Line 517: from ame_attributes atr

513: (sysdate < condu.start_date and condu.start_date < nvl(condu.end_date, condu.start_date + (1/86400)))
514: )
515: union
516: select distinct atr.attribute_id, atr.name
517: from ame_attributes atr
518: ,ame_action_usages acu
519: ,ame_actions act
520: ,ame_mandatory_attributes ama
521: ,ame_rules rules

Line 1118: from ame_attributes atr

1114: --+
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

Line 1220: from ame_attributes atr

1216: --+
1217: cursor getInvalidRequiredAttributes(applicationIdIn in integer
1218: ,actionIdIn in integer) is
1219: select distinct atr.attribute_id, atr.name
1220: from ame_attributes atr
1221: ,ame_mandatory_attributes man
1222: ,ame_actions act
1223: where act.action_id = actionIdIn
1224: and act.action_type_id = man.action_type_id

Line 1502: from ame_attributes

1498: procedure getAttributeName(p_attribute_id in number
1499: ,p_attribute_name_out out nocopy varchar2) is
1500: cursor getAtrName(p_attribute_id in number) is
1501: select name
1502: from ame_attributes
1503: where attribute_id = p_attribute_id
1504: and sysdate between start_date and nvl(end_date-(1/84600),sysdate);
1505: begin
1506: open getAtrName(p_attribute_id => p_attribute_id);

Line 2254: ,ame_attributes atr

2250: cursor get_sub_ic_cond(p_rule_id in integer) is
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

Line 2300: ,ame_attributes atr

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)
2304: and sysdate between atr.start_date and nvl(atr.end_date - (1/86400),sysdate);