APPS.AME_STV_BUS dependencies on AME_UTIL

Line 49: nvl(amecon.end_date - ame_util.oneSecond, p_effective_date)

45: ,ame_attributes ameatr
46: where amecon.condition_id = p_condition_id
47: and amecon.attribute_id = ameatr.attribute_id
48: and p_effective_date between amecon.start_date and
49: nvl(amecon.end_date - ame_util.oneSecond, p_effective_date)
50: and p_effective_date between ameatr.start_date and
51: nvl(ameatr.end_date - ame_util.oneSecond, p_effective_date);
52: l_key number;
53: l_key2 varchar2(30);

Line 51: nvl(ameatr.end_date - ame_util.oneSecond, p_effective_date);

47: and amecon.attribute_id = ameatr.attribute_id
48: and p_effective_date between amecon.start_date and
49: nvl(amecon.end_date - ame_util.oneSecond, p_effective_date)
50: and p_effective_date between ameatr.start_date and
51: nvl(ameatr.end_date - ame_util.oneSecond, p_effective_date);
52: l_key number;
53: l_key2 varchar2(30);
54: l_proc varchar2(72) := g_package || 'CHK_CONDITION_ID';
55: --

Line 69: elsif(l_key2 <> ame_util.stringAttributeType) then

65: if(csr_name%notfound) then
66: close csr_name;
67: fnd_message.set_name('PER', 'AME_400497_INVALID_CONDITION');
68: fnd_message.raise_error;
69: elsif(l_key2 <> ame_util.stringAttributeType) then
70: close csr_name;
71: fnd_message.set_name('PER', 'AME_400508_ATTR_TYP_NOT_STR');
72: fnd_message.raise_error;
73: end if;

Line 128: nvl(end_date - ame_util.oneSecond, p_effective_date);

124: from ame_string_values
125: where condition_id = p_condition_id
126: and string_value = p_string_value
127: and p_effective_date between start_date and
128: nvl(end_date - ame_util.oneSecond, p_effective_date);
129: l_key varchar2(1);
130: l_proc varchar2(72) := g_package || 'CHK_STRING_VALUE';
131: --
132: Begin