21: --
22: l_proc varchar2(72) := g_package||'set_base_key_value';
23: --
24: Begin
25: hr_utility.set_location('Entering:'||l_proc, 10);
26: --
27: per_apr_ins.g_appraisal_id_i := p_appraisal_id;
28: --
29: hr_utility.set_location(' Leaving:'||l_proc, 20);
25: hr_utility.set_location('Entering:'||l_proc, 10);
26: --
27: per_apr_ins.g_appraisal_id_i := p_appraisal_id;
28: --
29: hr_utility.set_location(' Leaving:'||l_proc, 20);
30: End set_base_key_value;
31: --
32: --
33: -- ---------------------------------------------------------------------------+
71:
72: l_proc varchar2(72) := g_package||'insert_dml';
73:
74: Begin
75: hr_utility.set_location('Entering:'||l_proc, 5);
76: p_rec.object_version_number := 1; -- Initialise the object version
77:
78:
79: -- Insert the row into: per_appraisals
219: p_rec.offline_status
220: );
221:
222:
223: hr_utility.set_location(' Leaving:'||l_proc, 10);
224: Exception
225: When hr_api.check_integrity_violated Then
226: -- A check constraint has been violated
227: per_apr_shd.constraint_error
288: where appraisal_id =
289: per_apr_ins.g_appraisal_id_i;
290: --
291: Begin
292: hr_utility.set_location('Entering:'||l_proc, 5);
293:
294:
295: -- Select the next sequence number
296: If (per_apr_ins.g_appraisal_id_i is not null)
321: Fetch C_Sel1 Into p_rec.appraisal_id;
322: Close C_Sel1;
323:
324: End If;
325: hr_utility.set_location(' Leaving:'||l_proc, 10);
326: End pre_insert;
327:
328: -- ---------------------------------------------------------------------------+
329: -- |-----------------------------< post_insert >------------------------------|
361:
362: l_proc varchar2(72) := g_package||'post_insert';
363:
364: Begin
365: hr_utility.set_location('Entering:'||l_proc, 5);
366:
367: -- This is a hook point and the user hook for post_insert is called here.
368:
369: begin
445: );
446: end;
447: -- End of API User Hook for post_insert.
448:
449: hr_utility.set_location(' Leaving:'||l_proc, 10);
450: End post_insert;
451:
452: -- ---------------------------------------------------------------------------+
453: -- |---------------------------------< ins >----------------------------------|
461:
462: l_proc varchar2(72) := g_package||'ins';
463:
464: Begin
465: hr_utility.set_location('Entering:'||l_proc, 5);
466:
467: -- Determine if the business process is to be validated.
468:
469: If p_validate then
500: If p_validate then
501: Raise HR_Api.Validate_Enabled;
502: End If;
503:
504: hr_utility.set_location(' Leaving:'||l_proc, 10);
505: Exception
506: When HR_Api.Validate_Enabled Then
507:
508: -- As the Validate_Enabled exception has been raised
591: l_rec per_apr_shd.g_rec_type;
592: l_proc varchar2(72) := g_package||'ins';
593:
594: Begin
595: hr_utility.set_location('Entering:'||l_proc, 5);
596:
597: -- Call conversion function to turn arguments into the
598: -- p_rec structure.
599:
680:
681: p_appraisal_id := l_rec.appraisal_id;
682: p_object_version_number := l_rec.object_version_number;
683:
684: hr_utility.set_location(' Leaving:'||l_proc, 10);
685: End ins;
686:
687: end per_apr_ins;