APPS.AME_ATTRIBUTE_PKG dependencies on AME_RULES

Line 266: ame_rules,

262: select count(*)
263: into attributeConditionInUseCnt
264: from ame_attributes,
265: ame_conditions,
266: ame_rules,
267: ame_condition_usages
268: where
269: ame_attributes.attribute_id = ame_conditions.attribute_id and
270: ame_conditions.condition_id = ame_condition_usages.condition_id and

Line 271: ame_rules.rule_id = ame_condition_usages.rule_id and

267: ame_condition_usages
268: where
269: ame_attributes.attribute_id = ame_conditions.attribute_id and
270: ame_conditions.condition_id = ame_condition_usages.condition_id and
271: ame_rules.rule_id = ame_condition_usages.rule_id and
272: ame_rules.rule_id = ruleIdIn and
273: ame_attributes.attribute_id = attributeIdIn and
274: ame_conditions.condition_type = conditionTypeIn and
275: sysdate between ame_attributes.start_date and

Line 272: ame_rules.rule_id = ruleIdIn and

268: where
269: ame_attributes.attribute_id = ame_conditions.attribute_id and
270: ame_conditions.condition_id = ame_condition_usages.condition_id and
271: ame_rules.rule_id = ame_condition_usages.rule_id and
272: ame_rules.rule_id = ruleIdIn and
273: ame_attributes.attribute_id = attributeIdIn and
274: ame_conditions.condition_type = conditionTypeIn and
275: sysdate between ame_attributes.start_date and
276: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

Line 284: ((sysdate between ame_rules.start_date and

280: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
281: (sysdate < ame_condition_usages.start_date and
282: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
283: ame_condition_usages.start_date + ame_util.oneSecond))) and
284: ((sysdate between ame_rules.start_date and
285: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate)) or
286: (sysdate < ame_rules.start_date and
287: ame_rules.start_date < nvl(ame_rules.end_date,
288: ame_rules.start_date + ame_util.oneSecond)));

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

281: (sysdate < ame_condition_usages.start_date and
282: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
283: ame_condition_usages.start_date + ame_util.oneSecond))) and
284: ((sysdate between ame_rules.start_date and
285: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate)) or
286: (sysdate < ame_rules.start_date and
287: ame_rules.start_date < nvl(ame_rules.end_date,
288: ame_rules.start_date + ame_util.oneSecond)));
289: return(attributeConditionInUseCnt);

Line 286: (sysdate < ame_rules.start_date and

282: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
283: ame_condition_usages.start_date + ame_util.oneSecond))) and
284: ((sysdate between ame_rules.start_date and
285: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate)) or
286: (sysdate < ame_rules.start_date and
287: ame_rules.start_date < nvl(ame_rules.end_date,
288: ame_rules.start_date + ame_util.oneSecond)));
289: return(attributeConditionInUseCnt);
290: exception

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

283: ame_condition_usages.start_date + ame_util.oneSecond))) and
284: ((sysdate between ame_rules.start_date and
285: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate)) or
286: (sysdate < ame_rules.start_date and
287: ame_rules.start_date < nvl(ame_rules.end_date,
288: ame_rules.start_date + ame_util.oneSecond)));
289: return(attributeConditionInUseCnt);
290: exception
291: when others then

Line 288: ame_rules.start_date + ame_util.oneSecond)));

284: ((sysdate between ame_rules.start_date and
285: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate)) or
286: (sysdate < ame_rules.start_date and
287: ame_rules.start_date < nvl(ame_rules.end_date,
288: ame_rules.start_date + ame_util.oneSecond)));
289: return(attributeConditionInUseCnt);
290: exception
291: when others then
292: rollback;