104: --
105: l_proc varchar2(72) := g_package||'insert_dml';
106: --
107: Begin
108: hr_utility.set_location('Entering:'||l_proc, 5);
109: p_rec.object_version_number := 1; -- Initialise the object version
110: --
111: --
112: --
184: );
185: --
186: --
187: --
188: hr_utility.set_location(' Leaving:'||l_proc, 10);
189: Exception
190: When hr_api.check_integrity_violated Then
191: -- A check constraint has been violated
192: --
252: --
253: Cursor C_Sel1 is select per_cagr_entitlement_results_s.nextval from sys.dual;
254: --
255: Begin
256: hr_utility.set_location('Entering:'||l_proc, 5);
257: --
258: --
259: -- Select the next sequence number
260: --
261: Open C_Sel1;
262: Fetch C_Sel1 Into p_rec.cagr_entitlement_result_id;
263: Close C_Sel1;
264: --
265: hr_utility.set_location(' Leaving:'||l_proc, 10);
266: End pre_insert;
267: --
268: -- ----------------------------------------------------------------------------
269: -- |-----------------------------< post_insert >------------------------------|
304: --
305: l_proc varchar2(72) := g_package||'post_insert';
306: --
307: Begin
308: hr_utility.set_location('Entering:'||l_proc, 5);
309: /*
310: begin
311: --
312: null;
399: --
400: end;
401: */
402: --
403: hr_utility.set_location(' Leaving:'||l_proc, 10);
404: End post_insert;
405: --
406: -- ----------------------------------------------------------------------------
407: -- |---------------------------------< ins >----------------------------------|
413: --
414: l_proc varchar2(72) := g_package||'ins';
415: --
416: Begin
417: hr_utility.set_location('Entering:'||l_proc, 5);
418: --
419: -- Call the supporting insert validate operations
420: --
421: per_res_bus.insert_validate
437: (p_effective_date
438: ,p_rec
439: );
440: --
441: hr_utility.set_location('Leaving:'||l_proc, 20);
442: end ins;
443: --
444: -- ----------------------------------------------------------------------------
445: -- |---------------------------------< ins >----------------------------------|
484: l_rec per_res_shd.g_rec_type;
485: l_proc varchar2(72) := g_package||'ins';
486: --
487: Begin
488: hr_utility.set_location('Entering:'||l_proc, 5);
489: --
490: -- Call conversion function to turn arguments into the
491: -- p_rec structure.
492: --
540: --
541: p_cagr_entitlement_result_id := l_rec.cagr_entitlement_result_id;
542: p_object_version_number := l_rec.object_version_number;
543: --
544: hr_utility.set_location(' Leaving:'||l_proc, 10);
545: End ins;
546: --
547: end per_res_ins;