41: l_api_updating boolean;
42: --
43: Begin
44: --
45: hr_utility.set_location('Entering:'||l_proc, 5);
46: --
47: l_api_updating := ben_dsq_shd.api_updating
48: (p_ded_sched_py_freq_id => p_ded_sched_py_freq_id,
49: p_object_version_number => p_object_version_number);
69: end if;
70: --
71: end if;
72: --
73: hr_utility.set_location('Leaving:'||l_proc, 10);
74: --
75: End chk_ded_sched_py_freq_id;
76: --
77: -- ----------------------------------------------------------------------------
109: l_api_updating boolean;
110: --
111: Begin
112: --
113: hr_utility.set_location('Entering:'||l_proc, 5);
114: --
115: l_api_updating := ben_dsq_shd.api_updating
116: (p_ded_sched_py_freq_id => p_ded_sched_py_freq_id,
117: p_object_version_number => p_object_version_number);
137: end if;
138: --
139: end if;
140: --
141: hr_utility.set_location('Leaving:'||l_proc,10);
142: --
143: end chk_dflt_flag;
144: --
145: /*
178: l_api_updating boolean;
179: --
180: Begin
181: --
182: hr_utility.set_location('Entering:'||l_proc, 5);
183: --
184: l_api_updating := ben_dsq_shd.api_updating
185: (p_ded_sched_py_freq_id => p_ded_sched_py_freq_id,
186: p_object_version_number => p_object_version_number);
208: end if;
209: --
210: end if;
211: --
212: hr_utility.set_location('Leaving:'||l_proc,10);
213: --
214: end chk_pymt_sched_cd;
215: --
216: */
249: l_api_updating boolean;
250: --
251: Begin
252: --
253: hr_utility.set_location('Entering:'||l_proc, 5);
254: --
255: l_api_updating := ben_dsq_shd.api_updating
256: (p_ded_sched_py_freq_id => p_ded_sched_py_freq_id,
257: p_object_version_number => p_object_version_number);
279: end if;
280: --
281: end if;
282: --
283: hr_utility.set_location('Leaving:'||l_proc,10);
284: --
285: end chk_py_freq_cd;
286: --
287: -- ----------------------------------------------------------------------------
292: --
293: l_proc varchar2(72) := g_package||'insert_validate';
294: --
295: Begin
296: hr_utility.set_location('Entering:'||l_proc, 5);
297: --
298: -- Call all supporting business operations
299: --
300: --
323: p_py_freq_cd => p_rec.py_freq_cd,
324: p_effective_date => p_effective_date,
325: p_object_version_number => p_rec.object_version_number);
326: --
327: hr_utility.set_location(' Leaving:'||l_proc, 10);
328: End insert_validate;
329: --
330: -- ----------------------------------------------------------------------------
331: -- |---------------------------< update_validate >----------------------------|
335: --
336: l_proc varchar2(72) := g_package||'update_validate';
337: --
338: Begin
339: hr_utility.set_location('Entering:'||l_proc, 5);
340: --
341: -- Call all supporting business operations
342: --
343: --
366: p_py_freq_cd => p_rec.py_freq_cd,
367: p_effective_date => p_effective_date,
368: p_object_version_number => p_rec.object_version_number);
369: --
370: hr_utility.set_location(' Leaving:'||l_proc, 10);
371: End update_validate;
372: --
373: -- ----------------------------------------------------------------------------
374: -- |---------------------------< delete_validate >----------------------------|
378: --
379: l_proc varchar2(72) := g_package||'delete_validate';
380: --
381: Begin
382: hr_utility.set_location('Entering:'||l_proc, 5);
383: --
384: -- Call all supporting business operations
385: --
386: hr_utility.set_location(' Leaving:'||l_proc, 10);
382: hr_utility.set_location('Entering:'||l_proc, 5);
383: --
384: -- Call all supporting business operations
385: --
386: hr_utility.set_location(' Leaving:'||l_proc, 10);
387: End delete_validate;
388: --
389: --
390: -- ---------------------------------------------------------------------------
409: l_proc varchar2(72) := g_package||'return_legislation_code';
410: --
411: begin
412: --
413: hr_utility.set_location('Entering:'|| l_proc, 10);
414: --
415: -- Ensure that all the mandatory parameter are not null
416: --
417: hr_api.mandatory_arg_error(p_api_name => l_proc,
434: end if;
435: --
436: close csr_leg_code;
437: --
438: hr_utility.set_location(' Leaving:'|| l_proc, 20);
439: --
440: return l_legislation_code;
441: --
442: end return_legislation_code;