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.IRC_VCE_BUS dependencies on IRC_VCE_BUS

Line 1: Package Body irc_vce_bus as

1: Package Body irc_vce_bus as
2: /* $Header: irvcerhi.pkb 120.1 2005/12/13 06:42:58 cnholmes noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' irc_vce_bus.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' irc_vce_bus.'; -- Global package name
9: --
10: -- The following two global variables are only to be
11: -- used by the return_legislation_code function.
12: --

Line 136: if (( nvl(irc_vce_bus.g_vacancy_id, hr_api.g_number)

132: ,p_argument => 'variable_comp_lookup'
133: ,p_argument_value => p_variable_comp_lookup
134: );
135: --
136: if (( nvl(irc_vce_bus.g_vacancy_id, hr_api.g_number)
137: = p_vacancy_id)
138: and ( nvl(irc_vce_bus.g_variable_comp_lookup, hr_api.g_varchar2)
139: = p_variable_comp_lookup)) then
140: --

Line 138: and ( nvl(irc_vce_bus.g_variable_comp_lookup, hr_api.g_varchar2)

134: );
135: --
136: if (( nvl(irc_vce_bus.g_vacancy_id, hr_api.g_number)
137: = p_vacancy_id)
138: and ( nvl(irc_vce_bus.g_variable_comp_lookup, hr_api.g_varchar2)
139: = p_variable_comp_lookup)) then
140: --
141: -- The legislation code has already been found with a previous
142: -- call to this function. Just return the value in the global

Line 145: l_legislation_code := irc_vce_bus.g_legislation_code;

141: -- The legislation code has already been found with a previous
142: -- call to this function. Just return the value in the global
143: -- variable.
144: --
145: l_legislation_code := irc_vce_bus.g_legislation_code;
146: hr_utility.set_location(l_proc, 20);
147: else
148: --
149: -- The ID is different to the last call to this function

Line 169: irc_vce_bus.g_vacancy_id := p_vacancy_id;

165: -- Set the global variables so the values are
166: -- available for the next call to this function.
167: --
168: close csr_leg_code;
169: irc_vce_bus.g_vacancy_id := p_vacancy_id;
170: irc_vce_bus.g_variable_comp_lookup := p_variable_comp_lookup;
171: irc_vce_bus.g_legislation_code := l_legislation_code;
172: end if;
173: hr_utility.set_location(' Leaving:'|| l_proc, 40);

Line 170: irc_vce_bus.g_variable_comp_lookup := p_variable_comp_lookup;

166: -- available for the next call to this function.
167: --
168: close csr_leg_code;
169: irc_vce_bus.g_vacancy_id := p_vacancy_id;
170: irc_vce_bus.g_variable_comp_lookup := p_variable_comp_lookup;
171: irc_vce_bus.g_legislation_code := l_legislation_code;
172: end if;
173: hr_utility.set_location(' Leaving:'|| l_proc, 40);
174: return l_legislation_code;

Line 171: irc_vce_bus.g_legislation_code := l_legislation_code;

167: --
168: close csr_leg_code;
169: irc_vce_bus.g_vacancy_id := p_vacancy_id;
170: irc_vce_bus.g_variable_comp_lookup := p_variable_comp_lookup;
171: irc_vce_bus.g_legislation_code := l_legislation_code;
172: end if;
173: hr_utility.set_location(' Leaving:'|| l_proc, 40);
174: return l_legislation_code;
175: end return_legislation_code;

Line 405: -- irc_vce_bus.set_security_group_id procedure.

401: );
402: --
403: -- As IRC_VARIABLE_COMP_ELEMENTS does not have a mandatory business_group_id
404: -- column, client_info is populated by calling
405: -- irc_vce_bus.set_security_group_id procedure.
406: hr_utility.set_location(l_proc,20);
407: irc_vce_bus.set_security_group_id(
408: p_vacancy_id => p_rec.vacancy_id
409: ,p_variable_comp_lookup => p_rec.variable_comp_lookup

Line 407: irc_vce_bus.set_security_group_id(

403: -- As IRC_VARIABLE_COMP_ELEMENTS does not have a mandatory business_group_id
404: -- column, client_info is populated by calling
405: -- irc_vce_bus.set_security_group_id procedure.
406: hr_utility.set_location(l_proc,20);
407: irc_vce_bus.set_security_group_id(
408: p_vacancy_id => p_rec.vacancy_id
409: ,p_variable_comp_lookup => p_rec.variable_comp_lookup
410: );
411: --

Line 446: -- irc_vce_bus.set_security_group_id procedure.

442: );
443: --
444: -- As IRC_VARIABLE_COMP_ELEMENTS does not have a mandatory business_group_id
445: -- column, client_info is populated by calling
446: -- irc_vce_bus.set_security_group_id procedure.
447: hr_utility.set_location(l_proc,15);
448: irc_vce_bus.set_security_group_id(
449: p_vacancy_id => p_rec.vacancy_id
450: ,p_variable_comp_lookup => p_rec.variable_comp_lookup

Line 448: irc_vce_bus.set_security_group_id(

444: -- As IRC_VARIABLE_COMP_ELEMENTS does not have a mandatory business_group_id
445: -- column, client_info is populated by calling
446: -- irc_vce_bus.set_security_group_id procedure.
447: hr_utility.set_location(l_proc,15);
448: irc_vce_bus.set_security_group_id(
449: p_vacancy_id => p_rec.vacancy_id
450: ,p_variable_comp_lookup => p_rec.variable_comp_lookup
451: );
452: --

Line 473: end irc_vce_bus;

469: --
470: hr_utility.set_location(' Leaving:'||l_proc, 10);
471: End delete_validate;
472: --
473: end irc_vce_bus;