APPS.AME_ADMIN_PKG dependencies on AME_RULES

Line 245: from ame_rules,

241: ruleCount integer;
242: begin
243: select count(*)
244: into ruleCount
245: from ame_rules,
246: ame_rule_usages,
247: ame_rule_stripe_sets
248: where
249: ame_rule_usages.item_id = applicationIdIn and

Line 250: ame_rules.rule_id = ame_rule_stripe_sets.rule_id and

246: ame_rule_usages,
247: ame_rule_stripe_sets
248: where
249: ame_rule_usages.item_id = applicationIdIn and
250: ame_rules.rule_id = ame_rule_stripe_sets.rule_id and
251: ame_rules.rule_id = ame_rule_usages.rule_id and
252: (ame_rule_usages.end_date is null or sysdate < ame_rule_usages.end_date) and
253: (ame_rule_stripe_sets.end_date is null or sysdate < ame_rule_stripe_sets.end_date) and
254: (ame_rules.end_date is null or sysdate < ame_rules.end_date);

Line 251: ame_rules.rule_id = ame_rule_usages.rule_id and

247: ame_rule_stripe_sets
248: where
249: ame_rule_usages.item_id = applicationIdIn and
250: ame_rules.rule_id = ame_rule_stripe_sets.rule_id and
251: ame_rules.rule_id = ame_rule_usages.rule_id and
252: (ame_rule_usages.end_date is null or sysdate < ame_rule_usages.end_date) and
253: (ame_rule_stripe_sets.end_date is null or sysdate < ame_rule_stripe_sets.end_date) and
254: (ame_rules.end_date is null or sysdate < ame_rules.end_date);
255: return(ruleCount);

Line 254: (ame_rules.end_date is null or sysdate < ame_rules.end_date);

250: ame_rules.rule_id = ame_rule_stripe_sets.rule_id and
251: ame_rules.rule_id = ame_rule_usages.rule_id and
252: (ame_rule_usages.end_date is null or sysdate < ame_rule_usages.end_date) and
253: (ame_rule_stripe_sets.end_date is null or sysdate < ame_rule_stripe_sets.end_date) and
254: (ame_rules.end_date is null or sysdate < ame_rules.end_date);
255: return(ruleCount);
256: exception
257: when others then
258: rollback;

Line 777: ame_rules

773: select count(*)
774: into ruleUsageCount
775: from
776: ame_rule_usages,
777: ame_rules
778: where
779: ame_rule_usages.rule_id = ame_rules.rule_id and
780: ame_rule_usages.item_id = applicationIdIn and
781: ame_rules.item_class_id = itemClassIdIn and

Line 779: ame_rule_usages.rule_id = ame_rules.rule_id and

775: from
776: ame_rule_usages,
777: ame_rules
778: where
779: ame_rule_usages.rule_id = ame_rules.rule_id and
780: ame_rule_usages.item_id = applicationIdIn and
781: ame_rules.item_class_id = itemClassIdIn and
782: sysdate between ame_rule_usages.start_date and
783: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate) and

Line 781: ame_rules.item_class_id = itemClassIdIn and

777: ame_rules
778: where
779: ame_rule_usages.rule_id = ame_rules.rule_id and
780: ame_rule_usages.item_id = applicationIdIn and
781: ame_rules.item_class_id = itemClassIdIn and
782: sysdate between ame_rule_usages.start_date and
783: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate) and
784: sysdate between ame_rules.start_date and
785: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate);

Line 784: sysdate between ame_rules.start_date and

780: ame_rule_usages.item_id = applicationIdIn and
781: ame_rules.item_class_id = itemClassIdIn and
782: sysdate between ame_rule_usages.start_date and
783: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate) and
784: sysdate between ame_rules.start_date and
785: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate);
786: if(ruleUsageCount > 0) then
787: return(true);
788: end if;

Line 785: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate);

781: ame_rules.item_class_id = itemClassIdIn and
782: sysdate between ame_rule_usages.start_date and
783: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate) and
784: sysdate between ame_rules.start_date and
785: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate);
786: if(ruleUsageCount > 0) then
787: return(true);
788: end if;
789: return(false);