3: -- --------------------------------------------------------------------------
4: -- | Private Global Definitions |
5: -- --------------------------------------------------------------------------
6: g_package varchar2(33) := ' hxc_tat_ins.'; -- global package name
7: g_debug boolean := hr_utility.debug_enabled;
8: -- --------------------------------------------------------------------------
9: -- |------------------------------< insert_dml >----------------------------|
10: -- --------------------------------------------------------------------------
11: -- {Start Of Comments}
57: begin
58:
59: if g_debug then
60: l_proc := g_package||'insert_dml';
61: hr_utility.set_location('Entering:'||l_proc, 5);
62: end if;
63:
64: p_rec.object_version_number := 1; -- initialise the object version
65:
141: )
142: returning time_attribute_id into p_rec.time_attribute_id; --Fix for Bug#3062133
143:
144: if g_debug then
145: hr_utility.set_location(' Leaving:'||l_proc, 10);
146: end if;
147:
148: exception
149: when hr_api.check_integrity_violated then
207: begin
208:
209: if g_debug then
210: l_proc := g_package||'pre_insert';
211: hr_utility.set_location('Entering:'||l_proc, 5);
212: end if;
213:
214: -- Fix for Bug#3062133 starts
215:
219:
220: -- Fix for Bug#3062133 ends
221:
222: if g_debug then
223: hr_utility.set_location(' Leaving:'||l_proc, 10);
224: end if;
225:
226: end pre_insert;
227:
267: begin
268:
269: if g_debug then
270: l_proc := g_package||'post_insert';
271: hr_utility.set_location('Entering:'||l_proc, 5);
272: end if;
273:
274: begin
275: /*
354:
355: end;
356:
357: if g_debug then
358: hr_utility.set_location(' Leaving:'||l_proc, 10);
359: end if;
360:
361: end post_insert;
362:
370:
371: l_proc varchar2(72) ;
372:
373: begin
374: g_debug :=hr_utility.debug_enabled;
375: if g_debug then
376: l_proc := g_package||'ins';
377: hr_utility.set_location('Entering:'||l_proc, 5);
378: end if;
373: begin
374: g_debug :=hr_utility.debug_enabled;
375: if g_debug then
376: l_proc := g_package||'ins';
377: hr_utility.set_location('Entering:'||l_proc, 5);
378: end if;
379:
380: -- call the supporting insert validate operations
381:
399: ,p_rec
400: );
401:
402: if g_debug then
403: hr_utility.set_location('Leaving:'||l_proc, 20);
404: end if;
405:
406: end ins;
407:
450: l_rec hxc_tat_shd.g_rec_type;
451: l_proc varchar2(72) ;
452:
453: begin
454: g_debug :=hr_utility.debug_enabled;
455: if g_debug then
456: l_proc := g_package||'ins';
457: hr_utility.set_location('Entering:'||l_proc, 5);
458: end if;
453: begin
454: g_debug :=hr_utility.debug_enabled;
455: if g_debug then
456: l_proc := g_package||'ins';
457: hr_utility.set_location('Entering:'||l_proc, 5);
458: end if;
459:
460: -- call conversion function to turn arguments into the p_rec structure.
461:
512: p_time_attribute_id := l_rec.time_attribute_id;
513: p_object_version_number := l_rec.object_version_number;
514:
515: if g_debug then
516: hr_utility.set_location(' Leaving:'||l_proc, 10);
517: end if;
518:
519: end ins;
520: