[Home] [Help]
42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_opp_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_oiplip_id => p_oiplip_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_oiplip_id;
78: --
79: -- ----------------------------------------------------------------------------
116: l_integrity_error Exception;
117: l_table_name all_tables.table_name%TYPE;
118: --
119: Begin
120: hr_utility.set_location('Entering:'||l_proc, 5);
121: --
122: -- Ensure that the p_datetrack_mode argument is not null
123: --
124: hr_api.mandatory_arg_error
165: End If;
166: --
167: End If;
168: --
169: hr_utility.set_location(' Leaving:'||l_proc, 10);
170: Exception
171: When l_integrity_error Then
172: --
173: -- A referential integrity check was violated therefore
231: l_rows_exist Exception;
232: l_table_name all_tables.table_name%TYPE;
233: --
234: Begin
235: hr_utility.set_location('Entering:'||l_proc, 5);
236: --
237: -- Ensure that the p_datetrack_mode argument is not null
238: --
239: hr_api.mandatory_arg_error
268: --
269: --
270: End If;
271: --
272: hr_utility.set_location(' Leaving:'||l_proc, 10);
273: Exception
274: When l_rows_exist Then
275: --
276: -- A referential integrity check was violated therefore
302: --
303: l_proc varchar2(72) := g_package||'insert_validate';
304: --
305: Begin
306: hr_utility.set_location('Entering:'||l_proc, 5);
307: --
308: -- Call all supporting business operations
309: --
310: --
316: (p_oiplip_id => p_rec.oiplip_id,
317: p_effective_date => p_effective_date,
318: p_object_version_number => p_rec.object_version_number);
319: --
320: hr_utility.set_location(' Leaving:'||l_proc, 10);
321: End insert_validate;
322: --
323: -- ----------------------------------------------------------------------------
324: -- |---------------------------< update_validate >----------------------------|
332: --
333: l_proc varchar2(72) := g_package||'update_validate';
334: --
335: Begin
336: hr_utility.set_location('Entering:'||l_proc, 5);
337: --
338: -- Call all supporting business operations
339: --
340: --
355: p_datetrack_mode => p_datetrack_mode,
356: p_validation_start_date => p_validation_start_date,
357: p_validation_end_date => p_validation_end_date);
358: --
359: hr_utility.set_location(' Leaving:'||l_proc, 10);
360: End update_validate;
361: --
362: -- ----------------------------------------------------------------------------
363: -- |---------------------------< delete_validate >----------------------------|
371: --
372: l_proc varchar2(72) := g_package||'delete_validate';
373: --
374: Begin
375: hr_utility.set_location('Entering:'||l_proc, 5);
376: --
377: -- Call all supporting business operations
378: --
379: dt_delete_validate
381: p_validation_start_date => p_validation_start_date,
382: p_validation_end_date => p_validation_end_date,
383: p_oiplip_id => p_rec.oiplip_id);
384: --
385: hr_utility.set_location(' Leaving:'||l_proc, 10);
386: End delete_validate;
387: --
388: --
389: -- ---------------------------------------------------------------------------
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: --