[Home] [Help]
39: l_legislation_code varchar2(150);
40: --
41: begin
42: --
43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Ensure that all the mandatory parameter are not null
46: --
47: hr_api.mandatory_arg_error
79: --
80: hr_api.set_legislation_context(l_legislation_code);
81: end if;
82: --
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: --
85: end set_security_group_id;
86: --
87: -- ---------------------------------------------------------------------------
107: l_proc varchar2(72) := g_package||'return_legislation_code';
108: --
109: Begin
110: --
111: hr_utility.set_location('Entering:'|| l_proc, 10);
112: --
113: -- Ensure that all the mandatory parameter are not null
114: --
115: hr_api.mandatory_arg_error
125: -- call to this function. Just return the value in the global
126: -- variable.
127: --
128: l_legislation_code := per_wbi_bus.g_legislation_code;
129: hr_utility.set_location(l_proc, 20);
130: else
131: --
132: -- The ID is different to the last call to this function
133: -- or this is the first call to this function.
142: close csr_leg_code;
143: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
144: fnd_message.raise_error;
145: end if;
146: hr_utility.set_location(l_proc,30);
147: --
148: -- Set the global variables so the values are
149: -- available for the next call to this function.
150: --
151: close csr_leg_code;
152: per_wbi_bus.g_workbench_item_code := p_workbench_item_code;
153: per_wbi_bus.g_legislation_code := l_legislation_code;
154: end if;
155: hr_utility.set_location(' Leaving:'|| l_proc, 40);
156: return l_legislation_code;
157: end return_legislation_code;
158: --
159: -- ----------------------------------------------------------------------------
251:
252: l_proc varchar2(72) := g_package||'chk_workbench_item_type';
253:
254: Begin
255: hr_utility.set_location('Entering:'|| l_proc, 1);
256:
257:
258: If p_workbench_item_type Is Not Null Then
259:
275: End If;
276:
277: End If;
278:
279: hr_utility.set_location('Leaving:'|| l_proc, 1);
280:
281: End chk_workbench_item_type;
282: --
283: -- ----------------------------------------------------------------------------
290: --
291: l_proc varchar2(72) := g_package||'insert_validate';
292: --
293: Begin
294: hr_utility.set_location('Entering:'||l_proc, 5);
295: --
296: -- Call all supporting business operations
297:
298: -- Validate Dependent Attributes
303: ,p_object_version_number =>p_rec.object_version_number
304: ,p_workbench_item_type =>p_rec.workbench_item_type
305: ) ;
306:
307: hr_utility.set_location(' Leaving:'||l_proc, 10);
308: End insert_validate;
309: --
310: -- ----------------------------------------------------------------------------
311: -- |---------------------------< update_validate >----------------------------|
317: --
318: l_proc varchar2(72) := g_package||'update_validate';
319: --
320: Begin
321: hr_utility.set_location('Entering:'||l_proc, 5);
322: --
323: -- Call all supporting business operations
324: --
325: --
337: ,p_workbench_item_type =>p_rec.workbench_item_type
338: ) ;
339: --
340: --
341: hr_utility.set_location(' Leaving:'||l_proc, 10);
342: End update_validate;
343: --
344: -- ----------------------------------------------------------------------------
345: -- |---------------------------< delete_validate >----------------------------|
350: --
351: l_proc varchar2(72) := g_package||'delete_validate';
352: --
353: Begin
354: hr_utility.set_location('Entering:'||l_proc, 5);
355: --
356: -- Call all supporting business operations
357: --
358: hr_utility.set_location(' Leaving:'||l_proc, 10);
354: hr_utility.set_location('Entering:'||l_proc, 5);
355: --
356: -- Call all supporting business operations
357: --
358: hr_utility.set_location(' Leaving:'||l_proc, 10);
359: End delete_validate;
360: --
361: end per_wbi_bus;