2: /* $Header: pepemfii.pkb 120.0 2005/05/31 13:25:51 appldev noship $ */
3:
4: -- Package Variables
5: g_package VARCHAR2(33) := 'hr_fi_previous_employment_api.';
6: g_debug boolean := hr_utility.debug_enabled;
7:
8: procedure create_fi_previous_job
9: ( p_effective_date in date
10: ,p_validate in boolean default false
80: fetch csr_bg
81: into l_legislation_code;
82: if csr_bg%notfound then
83: close csr_bg;
84: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
85: hr_utility.raise_error;
86: end if;
87: close csr_bg;
88: --
81: into l_legislation_code;
82: if csr_bg%notfound then
83: close csr_bg;
84: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
85: hr_utility.raise_error;
86: end if;
87: close csr_bg;
88: --
89: -- Check that the legislation of the specified business group is 'FI'.
88: --
89: -- Check that the legislation of the specified business group is 'FI'.
90: --
91: if l_legislation_code <> 'FI' then
92: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
93: hr_utility.set_message_token('LEG_CODE','FI');
94: hr_utility.raise_error;
95: end if;
96:
89: -- Check that the legislation of the specified business group is 'FI'.
90: --
91: if l_legislation_code <> 'FI' then
92: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
93: hr_utility.set_message_token('LEG_CODE','FI');
94: hr_utility.raise_error;
95: end if;
96:
97:
90: --
91: if l_legislation_code <> 'FI' then
92: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
93: hr_utility.set_message_token('LEG_CODE','FI');
94: hr_utility.raise_error;
95: end if;
96:
97:
98: --
149: ,p_object_version_number => p_object_version_number
150: );
151: --
152: if g_debug then
153: hr_utility.set_location(' Leaving:'||l_proc, 40);
154: end if;
155:
156: END ;
157: --
232: fetch csr_bg
233: into l_legislation_code;
234: if csr_bg%notfound then
235: close csr_bg;
236: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
237: hr_utility.raise_error;
238: end if;
239: close csr_bg;
240: --
233: into l_legislation_code;
234: if csr_bg%notfound then
235: close csr_bg;
236: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
237: hr_utility.raise_error;
238: end if;
239: close csr_bg;
240: --
241: -- Check that the legislation of the specified business group is 'FI'.
240: --
241: -- Check that the legislation of the specified business group is 'FI'.
242: --
243: if l_legislation_code <> 'FI' then
244: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
245: hr_utility.set_message_token('LEG_CODE','FI');
246: hr_utility.raise_error;
247: end if;
248:
241: -- Check that the legislation of the specified business group is 'FI'.
242: --
243: if l_legislation_code <> 'FI' then
244: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
245: hr_utility.set_message_token('LEG_CODE','FI');
246: hr_utility.raise_error;
247: end if;
248:
249:
242: --
243: if l_legislation_code <> 'FI' then
244: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
245: hr_utility.set_message_token('LEG_CODE','FI');
246: hr_utility.raise_error;
247: end if;
248:
249:
250: --
298: ,p_object_version_number => p_object_version_number
299: );
300:
301: if g_debug then
302: hr_utility.set_location(' Leaving:'||l_proc, 40);
303: end if;
304: end update_fi_previous_job;
305:
306: --