APPS.AME_CFV_BUS dependencies on AME_UTIL

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

48: from ame_config_vars
49: where application_id=p_csr_application_id
50: and variable_name=p_csr_variable_name
51: and p_effective_date between start_date
52: and nvl(end_date - ame_util.oneSecond, p_effective_date);
53: l_proc varchar2(72) := g_package || 'chk_nonupdateable_variable_values';
54: l_oldVal ame_config_vars.variable_value%TYPE;
55: --
56: Begin

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

135: select 1
136: from ame_calling_apps
137: where application_id=p_application_id
138: and p_effective_date between start_date
139: and nvl(end_date - ame_util.oneSecond, p_effective_date);
140: l_proc varchar2(72) := g_package || 'CHK_APPLICATION_ID';
141: l_key number;
142: --
143: Begin

Line 146: if(p_application_id <> ame_utility_pkg.defaultAmeAppId) then

142: --
143: Begin
144: hr_utility.set_location('Entering:'||l_proc,10);
145: --
146: if(p_application_id <> ame_utility_pkg.defaultAmeAppId) then
147: open csr_application;
148: fetch csr_application into l_key;
149: if(csr_application%notfound) then
150: fnd_message.set_name('PER', 'AME_400474_INV_APPLICATION_ID');

Line 255: and application_id = ame_utility_pkg.defaultAmeAppId;

251: cursor csr_var_name(p_var_name varchar2) is
252: select 'Y'
253: from ame_config_vars
254: where variable_name = p_var_name
255: and application_id = ame_utility_pkg.defaultAmeAppId;
256: l_proc varchar2(72) := g_package || 'CHK_VARIABLE_NAME';
257: l_key varchar2(1);
258: --
259: Begin

Line 495: (ame_util.isANonNegativeInteger(substr(l_priority,instr(l_priority,'_')+1)))

491: (substr(l_priority,1,instr(l_priority,'_')) in ('absolute_'
492: ,'relative_'
493: ))
494: and
495: (ame_util.isANonNegativeInteger(substr(l_priority,instr(l_priority,'_')+1)))
496: and
497: (substr(l_priority,instr(l_priority,'_')+1)<>'0')
498: ))then
499: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');

Line 605: or not (ame_util.isANonNegativeInteger(p_variable_value))

601: elsif(p_variable_name = 'currencyConversionWindow'
602: or p_variable_name = 'purgeFrequency'
603: ) then
604: if (trim(p_variable_value)='0')
605: or not (ame_util.isANonNegativeInteger(p_variable_value))
606: then
607: fnd_message.set_name('PER', 'AME_400662_CFV_NEG_VAL');
608: fnd_message.set_token('VARNAME',p_variable_name);
609: fnd_message.raise_error;

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

708: from ame_config_vars
709: where variable_name = p_variable_name
710: and application_id = p_application_id
711: and p_effective_date between start_date
712: and nvl(end_date - ame_util.oneSecond, p_effective_date);
713: l_proc varchar2(72) := g_package || 'CHK_VARIABLE_NAME';
714: l_key varchar2(1);
715: --
716: Begin

Line 725: if(p_application_id <> ame_utility_pkg.defaultAmeAppId) then

721: (p_check_column1 => 'AME_CONFIG_VARS.APPLICATION_ID')) then
722: --
723: -- Check if the varible name is already defined for the application.
724: --
725: if(p_application_id <> ame_utility_pkg.defaultAmeAppId) then
726: --
727: -- Check if a non-overridable config variable has been overridden.
728: --
729: if p_variable_name in ('distributedEnvironment'