[Home] [Help]
42: l_legislation_code varchar2(150);
43: --
44: begin
45: --
46: hr_utility.set_location('Entering:'|| l_proc, 10);
47: --
48: -- Ensure that all the mandatory parameter are not null
49: --
50: hr_api.mandatory_arg_error
82: --
83: hr_api.set_legislation_context(l_legislation_code);
84: end if;
85: --
86: hr_utility.set_location(' Leaving:'|| l_proc, 20);
87: --
88: end set_security_group_id;
89: --
90: -- ---------------------------------------------------------------------------
114: l_proc constant varchar2(72) := g_package||'return_legislation_code';
115: --
116: Begin
117: --
118: hr_utility.set_location('Entering:'|| l_proc, 10);
119: --
120: -- Ensure that all the mandatory parameter are not null
121: --
122: hr_api.mandatory_arg_error
132: -- call to this function. Just return the value in the global
133: -- variable.
134: --
135: l_legislation_code := pqh_rnk_bus.g_legislation_code;
136: hr_utility.set_location(l_proc, 20);
137: else
138: --
139: -- The ID is different to the last call to this function
140: -- or this is the first call to this function.
149: close csr_leg_code;
150: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
151: fnd_message.raise_error;
152: end if;
153: hr_utility.set_location(l_proc,30);
154: --
155: -- Set the global variables so the values are
156: -- available for the next call to this function.
157: --
158: close csr_leg_code;
159: pqh_rnk_bus.g_rank_process_id := p_rank_process_id;
160: pqh_rnk_bus.g_legislation_code := l_legislation_code;
161: end if;
162: hr_utility.set_location(' Leaving:'|| l_proc, 40);
163: return l_legislation_code;
164: end return_legislation_code;
165: --
166: -- ----------------------------------------------------------------------------
225: --
226: l_proc constant varchar2(72) := g_package||'insert_validate';
227: --
228: Begin
229: hr_utility.set_location('Entering:'||l_proc, 5);
230: --
231: -- Validate Dependent Attributes
232: --
233: pqh_rnk_bus.set_security_group_id(
232: --
233: pqh_rnk_bus.set_security_group_id(
234: p_rank_process_id => p_rec.rank_process_id);
235: --
236: hr_utility.set_location(' Leaving:'||l_proc, 10);
237: End insert_validate;
238: --
239: -- ----------------------------------------------------------------------------
240: -- |---------------------------< update_validate >----------------------------|
246: --
247: l_proc constant varchar2(72) := g_package||'update_validate';
248: --
249: Begin
250: hr_utility.set_location('Entering:'||l_proc, 5);
251: --
252: pqh_rnk_bus.set_security_group_id(
253: p_rank_process_id => p_rec.rank_process_id);
254: --
257: ,p_rec => p_rec
258: );
259: --
260: --
261: hr_utility.set_location(' Leaving:'||l_proc, 10);
262: End update_validate;
263: --
264: -- ----------------------------------------------------------------------------
265: -- |---------------------------< delete_validate >----------------------------|
270: --
271: l_proc constant varchar2(72) := g_package||'delete_validate';
272: --
273: Begin
274: hr_utility.set_location('Entering:'||l_proc, 5);
275: --
276: -- Call all supporting business operations
277: --
278: hr_utility.set_location(' Leaving:'||l_proc, 10);
274: hr_utility.set_location('Entering:'||l_proc, 5);
275: --
276: -- Call all supporting business operations
277: --
278: hr_utility.set_location(' Leaving:'||l_proc, 10);
279: End delete_validate;
280: --
281: end pqh_rnk_bus;