[Home] [Help]
79: l_last_updated_by ben_elig_per_f.last_updated_by%TYPE;
80: l_last_update_login ben_elig_per_f.last_update_login%TYPE;
81: --
82: Begin
83: hr_utility.set_location('Entering:'||l_proc, 5);
84: --
85: -- Get the object version number for the insert
86: --
87: p_rec.object_version_number :=
88: dt_api.get_object_version_number
89: (p_base_table_name => 'ben_elig_per_f',
90: p_base_key_column => 'elig_per_id',
91: p_base_key_value => p_rec.elig_per_id);
92: hr_utility.set_location('Dn DTAPI_GOVN:'||l_proc, 5);
93: --
94: -- Set the effective start and end dates to the corresponding
95: -- validation start and end dates
96: --
100: -- If the datetrack_mode is not INSERT then we must populate the WHO
101: -- columns with the 'old' creation values and 'new' updated values.
102: --
103: If (p_datetrack_mode <> 'INSERT') then
104: hr_utility.set_location(l_proc, 10);
105: --
106: -- Select the 'old' created values
107: --
108: Open C_Sel1;
130: ben_pep_shd.g_api_dml := true; -- Set the api dml status
131: --
132: -- Insert the row into: ben_elig_per_f
133: --
134: hr_utility.set_location('Ins PEP:'||l_proc, 5);
135: insert into ben_elig_per_f
136: (
137: elig_per_id,
138: effective_start_date,
351: l_last_update_login
352: );
353: --
354: ben_pep_shd.g_api_dml := false; -- Unset the api dml status
355: hr_utility.set_location(' Leaving:'||l_proc, 15);
356: --
357: Exception
358: When hr_api.check_integrity_violated Then
359: -- A check constraint has been violated
382: --
383: l_proc varchar2(72) := g_package||'insert_dml';
384: --
385: Begin
386: hr_utility.set_location('Entering:'||l_proc, 5);
387: --
388: dt_insert_dml(p_rec => p_rec,
389: p_effective_date => p_effective_date,
390: p_datetrack_mode => p_datetrack_mode,
390: p_datetrack_mode => p_datetrack_mode,
391: p_validation_start_date => p_validation_start_date,
392: p_validation_end_date => p_validation_end_date);
393: --
394: hr_utility.set_location(' Leaving:'||l_proc, 10);
395: End insert_dml;
396: --
397: -- ----------------------------------------------------------------------------
398: -- |------------------------------< pre_insert >------------------------------|
444: --
445: Cursor C_Sel1 is select ben_elig_per_f_s.nextval from sys.dual;
446: --
447: Begin
448: hr_utility.set_location('Entering:'||l_proc, 5);
449: --
450: --
451: -- Select the next sequence number
452: --
454: Fetch C_Sel1 Into p_rec.elig_per_id;
455: Close C_Sel1;
456: --
457: --
458: hr_utility.set_location(' Leaving:'||l_proc, 10);
459: End pre_insert;
460: --
461: -- ----------------------------------------------------------------------------
462: -- |-----------------------------< post_insert >------------------------------|
499: --
500: l_proc varchar2(72) := g_package||'post_insert';
501: --
502: Begin
503: hr_utility.set_location('Entering:'||l_proc, 5);
504: --
505: ben_pep_rki.after_insert
506: (
507: p_elig_per_id => p_rec.elig_per_id,
666: l_validation_start_date date;
667: l_validation_end_date date;
668: --
669: Begin
670: hr_utility.set_location('Entering:'||l_proc, 5);
671: --
672: -- Validate the datetrack mode mode getting the validation start
673: -- and end dates for the specified datetrack operation.
674: --
705: --
706: p_validation_start_date := l_validation_start_date;
707: p_validation_end_date := l_validation_end_date;
708: --
709: hr_utility.set_location(' Leaving:'||l_proc, 10);
710: --
711: End ins_lck;
712: --
713: -- ----------------------------------------------------------------------------
725: l_validation_start_date date;
726: l_validation_end_date date;
727: --
728: Begin
729: hr_utility.set_location('Entering:'||l_proc, 5);
730: --
731: -- Call the lock operation
732: --
733: ins_lck
895: l_rec ben_pep_shd.g_rec_type;
896: l_proc varchar2(72) := g_package||'ins';
897: --
898: Begin
899: hr_utility.set_location('Entering:'||l_proc, 5);
900: --
901: -- Call conversion function to turn arguments into the
902: -- p_rec structure.
903: --
1020: p_effective_end_date := l_rec.effective_end_date;
1021: p_object_version_number := l_rec.object_version_number;
1022: --
1023: --
1024: hr_utility.set_location(' Leaving:'||l_proc, 10);
1025: End ins;
1026: --
1027: end ben_pep_ins;