[Home] [Help]
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_cel_ins.g_competence_element_id_i := p_competence_element_id;
28: --
29: hr_utility.set_location(' Leaving:'||l_proc, 20);
25: hr_utility.set_location('Entering:'||l_proc, 10);
26: --
27: per_cel_ins.g_competence_element_id_i := p_competence_element_id;
28: --
29: hr_utility.set_location(' Leaving:'||l_proc, 20);
30: End set_base_key_value;
31: --
32: -- ----------------------------------------------------------------------------
33: -- |------------------------------< insert_dml >------------------------------|
76: --
77: l_proc varchar2(72) := g_package||'insert_dml';
78: --
79: Begin
80: hr_utility.set_location('Entering:'||l_proc, 5);
81: p_rec.object_version_number := 1; -- Initialise the object version
82: --
83: per_cel_shd.g_api_dml := true; -- Set the api dml status
84: --
256: );
257: --
258: per_cel_shd.g_api_dml := false; -- Unset the api dml status
259: --
260: hr_utility.set_location(' Leaving:'||l_proc, 10);
261: Exception
262: When hr_api.check_integrity_violated Then
263: -- A check constraint has been violated
264: per_cel_shd.g_api_dml := false; -- Unset the api dml status
328: from per_competence_elements
329: where competence_element_id = per_cel_ins.g_competence_element_id_i;
330: --
331: Begin
332: hr_utility.set_location('Entering:'||l_proc, 5);
333: --
334: if per_cel_ins.g_competence_element_id_i is not null then
335: --
336: -- Verify registered primary key values not already in use
362: Fetch C_Sel1 Into p_rec.competence_element_id;
363: Close C_Sel1;
364: --
365: end if;
366: hr_utility.set_location(' Leaving:'||l_proc, 10);
367: End pre_insert;
368: --
369: -- ----------------------------------------------------------------------------
370: -- |-----------------------------< post_insert >------------------------------|
402: --
403: l_proc varchar2(72) := g_package||'post_insert';
404: --
405: Begin
406: hr_utility.set_location('Entering:'||l_proc, 5);
407: --
408: -- This is a hook point and the user hook for post_insert is called here.
409: -- ngundura Added object id and name as parameters to per_cel_rki.after_insert
410: begin
505: );
506: end;
507: -- End of API User Hook for post_insert.
508: --
509: hr_utility.set_location(' Leaving:'||l_proc, 10);
510: End post_insert;
511: --
512: -- ----------------------------------------------------------------------------
513: -- |---------------------------------< ins >----------------------------------|
521: --
522: l_proc varchar2(72) := g_package||'ins';
523: --
524: Begin
525: hr_utility.set_location('Entering:'||l_proc, 5);
526: --
527: -- Determine if the business process is to be validated.
528: --
529: If p_validate then
560: If p_validate then
561: Raise HR_Api.Validate_Enabled;
562: End If;
563: --
564: hr_utility.set_location(' Leaving:'||l_proc, 10);
565: Exception
566: When HR_Api.Validate_Enabled Then
567: --
568: -- As the Validate_Enabled exception has been raised
667: l_rec per_cel_shd.g_rec_type;
668: l_proc varchar2(72) := g_package||'ins';
669: --
670: Begin
671: hr_utility.set_location('Entering:'||l_proc, 5);
672: --
673: -- Call conversion function to turn arguments into the
674: -- p_rec structure.
675: -- ngundura added object_id and name as parameters to convert_args
672: --
673: -- Call conversion function to turn arguments into the
674: -- p_rec structure.
675: -- ngundura added object_id and name as parameters to convert_args
676: hr_utility.set_location(p_type,99);
677: l_rec :=
678: per_cel_shd.convert_args
679: (
680: null,
773: --
774: p_competence_element_id := l_rec.competence_element_id;
775: p_object_version_number := l_rec.object_version_number;
776: --
777: hr_utility.set_location(' Leaving:'||l_proc, 10);
778: End ins;
779: --
780: end per_cel_ins;