[Home] [Help]
37: l_proc varchar2(72) := g_package||'set_security_group_id';
38: --
39: begin
40: --
41: hr_utility.set_location('Entering:'|| l_proc, 10);
42: --
43: -- Ensure that all the mandatory parameter are not null
44: --
45: hr_api.mandatory_arg_error
72: (p_security_group_id => l_security_group_id
73: );
74: end if;
75: --
76: hr_utility.set_location(' Leaving:'|| l_proc, 20);
77: --
78: end set_security_group_id;
79: --
80: -- ---------------------------------------------------------------------------
101: l_proc varchar2(72) := g_package||'return_legislation_code';
102: --
103: Begin
104: --
105: hr_utility.set_location('Entering:'|| l_proc, 10);
106: --
107: -- Ensure that all the mandatory parameter are not null
108: --
109: hr_api.mandatory_arg_error
119: -- call to this function. Just return the value in the global
120: -- variable.
121: --
122: l_legislation_code := ben_bcd_bus.g_legislation_code;
123: hr_utility.set_location(l_proc, 20);
124: else
125: --
126: -- The ID is different to the last call to this function
127: -- or this is the first call to this function.
136: close csr_leg_code;
137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: end if;
140: hr_utility.set_location(l_proc,30);
141: --
142: -- Set the global variables so the values are
143: -- available for the next call to this function.
144: --
145: close csr_leg_code;
146: ben_bcd_bus.g_cwb_matrix_dtl_id := p_cwb_matrix_dtl_id;
147: ben_bcd_bus.g_legislation_code := l_legislation_code;
148: end if;
149: hr_utility.set_location(' Leaving:'|| l_proc, 40);
150: return l_legislation_code;
151: end return_legislation_code;
152: --
153: -- ----------------------------------------------------------------------------
242: where a.cwb_matrix_id = p_cwb_matrix_id;
243: --
244: Begin
245: --
246: hr_utility.set_location('Entering:'||l_proc,5);
247: --
248: l_api_updating := ben_bcd_shd.api_updating
249: (p_cwb_matrix_dtl_id => p_cwb_matrix_dtl_id,
250: p_object_version_number => p_object_version_number);
274: close c1;
275: --
276: end if;
277: --
278: hr_utility.set_location('Leaving:'||l_proc,10);
279: --
280: End chk_cwb_matrix_id;
281: --
282: -- ----------------------------------------------------------------------------
288: --
289: l_proc varchar2(72) := g_package||'insert_validate';
290: --
291: Begin
292: hr_utility.set_location('Entering:'||l_proc, 5);
293: --
294: -- Call all supporting business operations
295: --
296: hr_api.validate_bus_grp_id
310: (p_cwb_matrix_dtl_id => p_rec.cwb_matrix_dtl_id,
311: p_cwb_matrix_id => p_rec.cwb_matrix_id,
312: p_object_version_number => p_rec.object_version_number);
313: --
314: hr_utility.set_location(' Leaving:'||l_proc, 10);
315: End insert_validate;
316: --
317: -- ----------------------------------------------------------------------------
318: -- |---------------------------< update_validate >----------------------------|
323: --
324: l_proc varchar2(72) := g_package||'update_validate';
325: --
326: Begin
327: hr_utility.set_location('Entering:'||l_proc, 5);
328: --
329: -- Call all supporting business operations
330: --
331: hr_api.validate_bus_grp_id
349: chk_non_updateable_args
350: (p_rec => p_rec
351: );
352: --
353: hr_utility.set_location(' Leaving:'||l_proc, 10);
354: End update_validate;
355: --
356: -- ----------------------------------------------------------------------------
357: -- |---------------------------< delete_validate >----------------------------|
362: --
363: l_proc varchar2(72) := g_package||'delete_validate';
364: --
365: Begin
366: hr_utility.set_location('Entering:'||l_proc, 5);
367: --
368: -- Call all supporting business operations
369: --
370: hr_utility.set_location(' Leaving:'||l_proc, 10);
366: hr_utility.set_location('Entering:'||l_proc, 5);
367: --
368: -- Call all supporting business operations
369: --
370: hr_utility.set_location(' Leaving:'||l_proc, 10);
371: End delete_validate;
372: --
373: end ben_bcd_bus;