eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AME_CFV_BUS dependencies on AME_CONFIG_VARS

Line 48: from ame_config_vars

44: ) IS
45: --
46: cursor csr_variable_value(p_csr_application_id in number,p_csr_variable_name in varchar2) is
47: select variable_value
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);

Line 54: l_oldVal ame_config_vars.variable_value%TYPE;

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
57: hr_utility.set_location('Entering:'||l_proc,10);
58: --

Line 92: (p_associated_column1 => 'AME_CONFIG_VARS.APPLICATION_ID'

88: hr_utility.set_location(' Leaving:'||l_proc,30);
89: exception
90: when app_exception.application_exception then
91: if hr_multi_message.exception_add
92: (p_associated_column1 => 'AME_CONFIG_VARS.APPLICATION_ID'
93: ) then
94: hr_utility.set_location(' Leaving:'||l_proc, 40);
95: raise;
96: end if;

Line 159: (p_associated_column1 => 'AME_CONFIG_VARS.APPLICATION_ID'

155: hr_utility.set_location(' Leaving:'||l_proc,30);
156: exception
157: when app_exception.application_exception then
158: if hr_multi_message.exception_add
159: (p_associated_column1 => 'AME_CONFIG_VARS.APPLICATION_ID'
160: ) then
161: hr_utility.set_location(' Leaving:'||l_proc, 40);
162: raise;
163: end if;

Line 214: (p_associated_column1 => 'AME_CONFIG_VARS.APPLICATION_ID'

210: end if;
211: exception
212: when app_exception.application_exception then
213: if hr_multi_message.exception_add
214: (p_associated_column1 => 'AME_CONFIG_VARS.APPLICATION_ID'
215: ) then
216: hr_utility.set_location(' Leaving:'||l_proc, 40);
217: raise;
218: end if;

Line 253: from ame_config_vars

249: procedure chk_variable_name(p_variable_name in varchar2) IS
250: --
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);

Line 281: (p_associated_column1 => 'AME_CONFIG_VARS.VARIABLE_NAME'

277: hr_utility.set_location(' Leaving:'||l_proc,30);
278: exception
279: when app_exception.application_exception then
280: if hr_multi_message.exception_add
281: (p_associated_column1 => 'AME_CONFIG_VARS.VARIABLE_NAME'
282: ) then
283: hr_utility.set_location(' Leaving:'||l_proc, 40);
284: raise;
285: end if;

Line 427: (p_associated_column1 => 'AME_CONFIG_VARS.FORWARDING_BEHAVIOUR'

423: return true;
424: exception
425: when app_exception.application_exception then
426: if hr_multi_message.exception_add
427: (p_associated_column1 => 'AME_CONFIG_VARS.FORWARDING_BEHAVIOUR'
428: ) then
429: hr_utility.set_location(' Leaving:'||l_proc, 40);
430: raise;
431: end if;

Line 517: (p_associated_column1 => 'AME_CONFIG_VARS.PRIORITY_MODE'

513: return true;
514: exception
515: when app_exception.application_exception then
516: if hr_multi_message.exception_add
517: (p_associated_column1 => 'AME_CONFIG_VARS.PRIORITY_MODE'
518: ) then
519: hr_utility.set_location(' Leaving:'||l_proc, 40);
520: raise;
521: end if;

Line 577: (p_check_column1 => 'AME_CONFIG_VARS.VARIABLE_NAME') then

573: --
574: -- Check if the varible value is in appropriate format.
575: --
576: if hr_multi_message.no_all_inclusive_error
577: (p_check_column1 => 'AME_CONFIG_VARS.VARIABLE_NAME') then
578: if(p_variable_name = 'adminApprover') then
579: open csr_role;
580: fetch csr_role into l_key;
581: if(csr_role%notfound) then

Line 662: (p_associated_column1 => 'AME_CONFIG_VARS.VARIABLE_VALUE'

658: hr_utility.set_location(' Leaving:'||l_proc,30);
659: exception
660: when app_exception.application_exception then
661: if hr_multi_message.exception_add
662: (p_associated_column1 => 'AME_CONFIG_VARS.VARIABLE_VALUE'
663: ) then
664: hr_utility.set_location(' Leaving:'||l_proc, 40);
665: raise;
666: end if;

Line 708: from ame_config_vars

704: ) IS
705: --
706: cursor csr_var_name is
707: select 'Y'
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);

Line 719: (p_check_column1 => 'AME_CONFIG_VARS.VARIABLE_NAME')

715: --
716: Begin
717: hr_utility.set_location('Entering:'||l_proc,10);
718: if (hr_multi_message.no_all_inclusive_error
719: (p_check_column1 => 'AME_CONFIG_VARS.VARIABLE_NAME')
720: and hr_multi_message.no_all_inclusive_error
721: (p_check_column1 => 'AME_CONFIG_VARS.APPLICATION_ID')) then
722: --
723: -- Check if the varible name is already defined for the application.

Line 721: (p_check_column1 => 'AME_CONFIG_VARS.APPLICATION_ID')) then

717: hr_utility.set_location('Entering:'||l_proc,10);
718: if (hr_multi_message.no_all_inclusive_error
719: (p_check_column1 => 'AME_CONFIG_VARS.VARIABLE_NAME')
720: and hr_multi_message.no_all_inclusive_error
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

Line 765: (p_associated_column1 => 'AME_CONFIG_VARS.APPLICATION_VARIABLE_NAME'

761: hr_utility.set_location(' Leaving:'||l_proc,30);
762: exception
763: when app_exception.application_exception then
764: if hr_multi_message.exception_add
765: (p_associated_column1 => 'AME_CONFIG_VARS.APPLICATION_VARIABLE_NAME'
766: ) then
767: hr_utility.set_location(' Leaving:'||l_proc, 40);
768: raise;
769: end if;