[Home] [Help]
20: --
21: l_proc varchar2(72) := g_package||'set_base_key_value';
22: --
23: Begin
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: per_qua_ins.g_qualification_id_i := p_qualification_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: per_qua_ins.g_qualification_id_i := p_qualification_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: -- ----------------------------------------------------------------------------
32: -- |------------------------------< insert_dml >------------------------------|
75: --
76: l_proc varchar2(72) := g_package||'insert_dml';
77: --
78: Begin
79: hr_utility.set_location('Entering:'||l_proc, 5);
80: p_rec.object_version_number := 1; -- Initialise the object version
81: --
82: per_qua_shd.g_api_dml := true; -- Set the api dml status
83: --
235: );
236: --
237: per_qua_shd.g_api_dml := false; -- Unset the api dml status
238: --
239: hr_utility.set_location(' Leaving:'||l_proc, 10);
240: Exception
241: When hr_api.check_integrity_violated Then
242: -- A check constraint has been violated
243: per_qua_shd.g_api_dml := false; -- Unset the api dml status
308: where qualification_id = per_qua_ins.g_qualification_id_i;
309: --
310:
311: Begin
312: hr_utility.set_location('Entering:'||l_proc, 5);
313: --
314: if per_qua_ins.g_qualification_id_i is not null then
315: --
316: -- Verify registered primary key values not already in use
342: Fetch C_Sel1 Into p_rec.qualification_id;
343: Close C_Sel1;
344: --
345: end if;
346: hr_utility.set_location(' Leaving:'||l_proc, 10);
347: End pre_insert;
348: --
349: -- ----------------------------------------------------------------------------
350: -- |-----------------------------< post_insert >------------------------------|
383: --
384: l_proc varchar2(72) := g_package||'post_insert';
385: --
386: Begin
387: hr_utility.set_location('Entering:'||l_proc, 5);
388: --
389: -- Start of Row Handler User Hook for post_insert.
390: --
391: Begin
475: end;
476: --
477: -- End of Row Handler User Hook for post_insert.
478: --
479: hr_utility.set_location(' Leaving:'||l_proc, 10);
480: End post_insert;
481: --
482: -- ----------------------------------------------------------------------------
483: -- |---------------------------------< ins >----------------------------------|
491: --
492: l_proc varchar2(72) := g_package||'ins';
493: --
494: Begin
495: hr_utility.set_location('Entering:'||l_proc, 5);
496: --
497: -- Determine if the business process is to be validated.
498: --
499: If p_validate then
532: If p_validate then
533: Raise HR_Api.Validate_Enabled;
534: End If;
535: --
536: hr_utility.set_location(' Leaving:'||l_proc, 10);
537: Exception
538: When HR_Api.Validate_Enabled Then
539: --
540: -- As the Validate_Enabled exception has been raised
628: l_rec per_qua_shd.g_rec_type;
629: l_proc varchar2(72) := g_package||'ins';
630: --
631: Begin
632: hr_utility.set_location('Entering:'||l_proc, 5);
633: --
634: -- Call conversion function to turn arguments into the
635: -- p_rec structure.
636: --
722: --
723: p_qualification_id := l_rec.qualification_id;
724: p_object_version_number := l_rec.object_version_number;
725: --
726: hr_utility.set_location(' Leaving:'||l_proc, 10);
727: End ins;
728: --
729: end per_qua_ins;