61: l_last_updated_by per_election_candidates.last_updated_by%TYPE;
62: l_last_update_login per_election_candidates.last_update_login%TYPE;
63: --
64: Begin
65: hr_utility.set_location('Entering:'||l_proc, 5);
66: p_rec.object_version_number := 1; -- Initialise the object version
67: --
68: --
69: -- Set the who columns
230: );
231: --
232: --
233: --
234: hr_utility.set_location(' Leaving:'||l_proc, 10);
235: Exception
236: When hr_api.check_integrity_violated Then
237: -- A check constraint has been violated
238: --
298: --
299: Cursor C_Sel1 is select per_election_candidates_s.nextval from sys.dual;
300: --
301: Begin
302: hr_utility.set_location('Entering:'||l_proc, 5);
303: --
304: --
305: -- Select the next sequence number
306: --
307: Open C_Sel1;
308: Fetch C_Sel1 Into p_rec.election_candidate_id;
309: Close C_Sel1;
310: --
311: hr_utility.set_location(' Leaving:'||l_proc, 10);
312: End pre_insert;
313: --
314: -- ----------------------------------------------------------------------------
315: -- |-----------------------------< post_insert >------------------------------|
349: --
350: l_proc varchar2(72) := g_package||'post_insert';
351: --
352: Begin
353: hr_utility.set_location('Entering:'||l_proc, 5);
354: begin
355: --
356: per_eca_rki.after_insert
357: (p_election_candidate_id
503: ,p_hook_type => 'AI');
504: --
505: end;
506: --
507: hr_utility.set_location(' Leaving:'||l_proc, 10);
508: End post_insert;
509: --
510: -- ----------------------------------------------------------------------------
511: -- |---------------------------------< ins >----------------------------------|
517: --
518: l_proc varchar2(72) := g_package||'ins';
519: --
520: Begin
521: hr_utility.set_location('Entering:'||l_proc, 5);
522: --
523: -- Determine if the business process is to be validated.
524: --
525: If p_validate then
555: If p_validate then
556: Raise HR_Api.Validate_Enabled;
557: End If;
558: --
559: hr_utility.set_location('Leaving:'||l_proc, 20);
560: Exception
561: When HR_Api.Validate_Enabled Then
562: --
563: -- As the Validate_Enabled exception has been raised
644: l_rec per_eca_shd.g_rec_type;
645: l_proc varchar2(72) := g_package||'ins';
646: --
647: Begin
648: hr_utility.set_location('Entering:'||l_proc, 5);
649: --
650: -- Call conversion function to turn arguments into the
651: -- p_rec structure.
652: --
735: --
736: p_election_candidate_id := l_rec.election_candidate_id;
737: p_object_version_number := l_rec.object_version_number;
738: --
739: hr_utility.set_location(' Leaving:'||l_proc, 10);
740: End ins;
741: --
742: end per_eca_ins;