[Home] [Help]
34: l_proc varchar2(72) := g_package||'set_security_group_id';
35: --
36: begin
37: --
38: hr_utility.set_location('Entering:'|| l_proc, 10);
39: --
40: open csr_sec_grp;
41: fetch csr_sec_grp into l_security_group_id;
42: --
57: hr_api.set_security_group_id
58: (p_security_group_id => l_security_group_id
59: );
60: --
61: hr_utility.set_location(' Leaving:'|| l_proc, 20);
62: --
63: end set_security_group_id;
64: --
65: -- ---------------------------------------------------------------------------
84: l_proc varchar2(72) := g_package||'return_legislation_code';
85: --
86: Begin
87: --
88: hr_utility.set_location('Entering:'|| l_proc, 10);
89: --
90: -- The legislation code has already been found with a previous
91: -- call to this function. Just return the value in the global
92: -- variable.
92: -- variable.
93: --
94: if pqp_ers_bus.g_legislation_code IS NOT NULL THEN
95: l_legislation_code := pqp_ers_bus.g_legislation_code;
96: hr_utility.set_location(l_proc, 20);
97: else
98: hr_utility.set_location(l_proc, 30);
99: -- The ID is different to the last call to this function
100: -- or this is the first call to this function.
94: if pqp_ers_bus.g_legislation_code IS NOT NULL THEN
95: l_legislation_code := pqp_ers_bus.g_legislation_code;
96: hr_utility.set_location(l_proc, 20);
97: else
98: hr_utility.set_location(l_proc, 30);
99: -- The ID is different to the last call to this function
100: -- or this is the first call to this function.
101: --
102: open csr_leg_code;
109: close csr_leg_code;
110: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
111: fnd_message.raise_error;
112: end if;
113: hr_utility.set_location(l_proc,30);
114: --
115: -- Set the global variables so the values are
116: -- available for the next call to this function.
117: --
117: --
118: close csr_leg_code;
119: pqp_ers_bus.g_legislation_code := l_legislation_code;
120: end if;
121: hr_utility.set_location(' Leaving:'|| l_proc, 40);
122: return l_legislation_code;
123: end return_legislation_code;
124: --
125: -- ----------------------------------------------------------------------------
185: --
186: l_proc varchar2(72) := g_package||'insert_validate';
187: --
188: Begin
189: hr_utility.set_location('Entering:'||l_proc, 5);
190: --
191: -- Call all supporting business operations
192: --
193: --
196: --
197: -- Validate Dependent Attributes
198: --
199: -- No validation required.
200: hr_utility.set_location(' Leaving:'||l_proc, 10);
201: End insert_validate;
202: --
203: -- ----------------------------------------------------------------------------
204: -- |---------------------------< update_validate >----------------------------|
209: --
210: l_proc varchar2(72) := g_package||'update_validate';
211: --
212: Begin
213: hr_utility.set_location('Entering:'||l_proc, 5);
214: --
215: -- Call all supporting business operations
216: --
217: --
224: (p_rec => p_rec
225: );
226: --
227: --
228: hr_utility.set_location(' Leaving:'||l_proc, 10);
229: End update_validate;
230: --
231: -- ----------------------------------------------------------------------------
232: -- |---------------------------< delete_validate >----------------------------|
237: --
238: l_proc varchar2(72) := g_package||'delete_validate';
239: --
240: Begin
241: hr_utility.set_location('Entering:'||l_proc, 5);
242: --
243: -- Call all supporting business operations
244: --
245: hr_utility.set_location(' Leaving:'||l_proc, 10);
241: hr_utility.set_location('Entering:'||l_proc, 5);
242: --
243: -- Call all supporting business operations
244: --
245: hr_utility.set_location(' Leaving:'||l_proc, 10);
246: End delete_validate;
247: --
248: end pqp_ers_bus;