DBA Data[Home] [Help]

APPS.IRC_IAS_BUS dependencies on IRC_IAS_BUS

Line 1: Package Body irc_ias_bus as

1: Package Body irc_ias_bus as
2: /* $Header: iriasrhi.pkb 120.0.12010000.3 2008/08/05 10:48:01 ubhat ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' irc_ias_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 106: if ( nvl(irc_ias_bus.g_assignment_status_id, hr_api.g_number)

102: --
103: -- Ensure that all the mandatory parameter are not null
104: --
105: --
106: if ( nvl(irc_ias_bus.g_assignment_status_id, hr_api.g_number)
107: = p_assignment_status_id) then
108: --
109: -- The legislation code has already been found with a previous
110: -- call to this function. Just return the value in the global

Line 113: l_legislation_code := irc_ias_bus.g_legislation_code;

109: -- The legislation code has already been found with a previous
110: -- call to this function. Just return the value in the global
111: -- variable.
112: --
113: l_legislation_code := irc_ias_bus.g_legislation_code;
114: hr_utility.set_location(l_proc, 20);
115: else
116: --
117: -- The ID is different to the last call to this function

Line 137: irc_ias_bus.g_assignment_status_id := p_assignment_status_id;

133: -- Set the global variables so the values are
134: -- available for the next call to this function.
135: --
136: close csr_leg_code;
137: irc_ias_bus.g_assignment_status_id := p_assignment_status_id;
138: irc_ias_bus.g_legislation_code := l_legislation_code;
139: end if;
140: hr_utility.set_location(' Leaving:'|| l_proc, 40);
141: return l_legislation_code;

Line 138: irc_ias_bus.g_legislation_code := l_legislation_code;

134: -- available for the next call to this function.
135: --
136: close csr_leg_code;
137: irc_ias_bus.g_assignment_status_id := p_assignment_status_id;
138: irc_ias_bus.g_legislation_code := l_legislation_code;
139: end if;
140: hr_utility.set_location(' Leaving:'|| l_proc, 40);
141: return l_legislation_code;
142: end return_legislation_code;

Line 382: -- irc_ias_bus.set_security_group_id procedure

378: (p_asg_status_type_id => p_rec.assignment_status_type_id
379: );
380: -- As this table does not have a mandatory business_group_id
381: -- column, ensure client_info is populated by calling the
382: -- irc_ias_bus.set_security_group_id procedure
383: --
384: hr_utility.set_location(l_proc, 20);
385: irc_ias_bus.set_security_group_id
386: (p_assignment_id => p_rec.assignment_id

Line 385: irc_ias_bus.set_security_group_id

381: -- column, ensure client_info is populated by calling the
382: -- irc_ias_bus.set_security_group_id procedure
383: --
384: hr_utility.set_location(l_proc, 20);
385: irc_ias_bus.set_security_group_id
386: (p_assignment_id => p_rec.assignment_id
387: ,p_associated_column1 => irc_ias_shd.g_tab_nam||'.ASSIGNMENT_ID'
388: );
389: hr_utility.set_location(' Leaving:'||l_proc, 30);

Line 441: end irc_ias_bus;

437: --
438: hr_utility.set_location(' Leaving:'||l_proc, 10);
439: End delete_validate;
440: --
441: end irc_ias_bus;