APPS.AME_RULE_API dependencies on AME_UTILITY_PKG

Line 70: elsif (ruleUsage.end_date = ame_utility_pkg.endOfTime and p_rlu_end_date = ame_utility_pkg.endOfTime) then

66: elsif ( trunc(p_rlu_start_date) = trunc(ruleUsage.start_date) and
67: trunc(p_rlu_end_date) = trunc(ruleUsage.end_date)
68: ) then
69: return(2);
70: elsif (ruleUsage.end_date = ame_utility_pkg.endOfTime and p_rlu_end_date = ame_utility_pkg.endOfTime) then
71: return(3);
72: elsif ((p_rlu_end_date = ame_utility_pkg.endOfTime and p_rlu_start_date < ruleUsage.end_date)
73: or
74: ( ruleUsage.end_date = ame_utility_pkg.endOfTime and

Line 72: elsif ((p_rlu_end_date = ame_utility_pkg.endOfTime and p_rlu_start_date < ruleUsage.end_date)

68: ) then
69: return(2);
70: elsif (ruleUsage.end_date = ame_utility_pkg.endOfTime and p_rlu_end_date = ame_utility_pkg.endOfTime) then
71: return(3);
72: elsif ((p_rlu_end_date = ame_utility_pkg.endOfTime and p_rlu_start_date < ruleUsage.end_date)
73: or
74: ( ruleUsage.end_date = ame_utility_pkg.endOfTime and
75: (p_rlu_start_date >= ruleUsage.start_date
76: or p_rlu_end_date > ruleUsage.start_date))

Line 74: ( ruleUsage.end_date = ame_utility_pkg.endOfTime and

70: elsif (ruleUsage.end_date = ame_utility_pkg.endOfTime and p_rlu_end_date = ame_utility_pkg.endOfTime) then
71: return(3);
72: elsif ((p_rlu_end_date = ame_utility_pkg.endOfTime and p_rlu_start_date < ruleUsage.end_date)
73: or
74: ( ruleUsage.end_date = ame_utility_pkg.endOfTime and
75: (p_rlu_start_date >= ruleUsage.start_date
76: or p_rlu_end_date > ruleUsage.start_date))
77: ) then
78: return(3);

Line 620: l_rul_end_date := ame_utility_pkg.endOfTime;

616: else
617: l_rul_start_date := p_rul_start_date;
618: end if;
619: if p_rul_end_date is null then
620: l_rul_end_date := ame_utility_pkg.endOfTime;
621: else
622: l_rul_end_date := p_rul_end_date;
623: end if;
624:

Line 1254: l_rlu_end_date := ame_utility_pkg.endOfTime;

1250: if l_rlu_start_date is null then
1251: l_rlu_start_date := l_effective_date;
1252: end if;
1253: if l_rlu_end_date is null then
1254: l_rlu_end_date := ame_utility_pkg.endOfTime;
1255: else
1256: l_rlu_end_date := trunc(l_rlu_end_date);
1257: end if;
1258: ame_rlu_ins.ins(p_rule_id => p_rule_id