APPS.IRC_VCE_BUS dependencies on IRC_VARIABLE_COMP_ELEMENTS

Line 103: -- Join between irc_variable_comp_elements and PER_BUSINESS_GROUPS

99: Return Varchar2 Is
100: --
101: -- Declare cursor
102: --
103: -- Join between irc_variable_comp_elements and PER_BUSINESS_GROUPS
104: -- so that the legislation_code for
105: -- the current business group context can be derived.
106:
107: cursor csr_leg_code is

Line 227: -- Since no update is there for IRC_VARIABLE_COMP_ELEMENTS, no additional

223: fnd_message.set_token('STEP ', '5');
224: fnd_message.raise_error;
225: END IF;
226: --
227: -- Since no update is there for IRC_VARIABLE_COMP_ELEMENTS, no additional
228: -- checks need to be added here.
229: --
230: End chk_non_updateable_args;
231: --

Line 260: irc_variable_comp_elements.variable_comp_lookup%TYPE

256: -- ----------------------------------------------------------------------------
257: Procedure chk_variable_comp_lookup
258: (p_effective_date in date
259: ,p_variable_comp_lookup in
260: irc_variable_comp_elements.variable_comp_lookup%TYPE
261: ) IS
262: --
263: l_proc varchar2(72) := g_package || 'chk_variable_comp_lookup';
264: l_ret boolean;

Line 291: 'IRC_VARIABLE_COMP_ELEMENTS.VARIABLE_COMP_LOOKUP'

287: exception
288: when app_exception.application_exception then
289: if hr_multi_message.exception_add
290: (p_associated_column1 =>
291: 'IRC_VARIABLE_COMP_ELEMENTS.VARIABLE_COMP_LOOKUP'
292: ) then
293: hr_utility.set_location(' Leaving:'||l_proc,30);
294: raise;
295: end if;

Line 325: ,p_vacancy_id in irc_variable_comp_elements.vacancy_id%TYPE

321: -- {End Of Comments}
322: -- ----------------------------------------------------------------------------
323: Procedure chk_vacancy_id
324: (p_effective_date in date
325: ,p_vacancy_id in irc_variable_comp_elements.vacancy_id%TYPE
326: ) IS
327: --
328: l_proc varchar2(72) := g_package || 'chk_vacancy_id';
329: l_vacancy_id varchar2(1);

Line 359: 'IRC_VARIABLE_COMP_ELEMENTS.VACANCY_ID'

355: exception
356: when app_exception.application_exception then
357: if hr_multi_message.exception_add
358: (p_associated_column1 =>
359: 'IRC_VARIABLE_COMP_ELEMENTS.VACANCY_ID'
360: ) then
361: hr_utility.set_location(' Leaving:'||l_proc,25);
362: raise;
363: end if;

Line 382: -- As IRC_VARIABLE_COMP_ELEMENTS does not have a mandatory business_group_id

378: hr_utility.set_location('Entering:'||l_proc, 5);
379: --
380: -- Validate Important Attributes
381: --
382: -- As IRC_VARIABLE_COMP_ELEMENTS does not have a mandatory business_group_id
383: -- column, client_info is populated by calling
384: -- irc_vce_bus.set_security_group_id procedure.
385: hr_utility.set_location(l_proc,10);
386: irc_vce_bus.set_security_group_id(

Line 444: -- As IRC_VARIABLE_COMP_ELEMENTS does not have a mandatory business_group_id

440: (p_effective_date => p_effective_date
441: ,p_rec => p_rec
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(