79: l_last_updated_by ben_pl_f.last_updated_by%TYPE;
80: l_last_update_login ben_pl_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 :=
99: -- If the datetrack_mode is not INSERT then we must populate the WHO
100: -- columns with the 'old' creation values and 'new' updated values.
101: --
102: If (p_datetrack_mode <> 'INSERT') then
103: hr_utility.set_location(l_proc, 10);
104: --
105: -- Select the 'old' created values
106: --
107: Open C_Sel1;
523: ,p_rec.use_csd_rsd_prccng_cd
524: );
525: --
526: ben_pln_shd.g_api_dml := false; -- Unset the api dml status
527: hr_utility.set_location(' Leaving:'||l_proc, 15);
528: --
529: Exception
530: When hr_api.check_integrity_violated Then
531: -- A check constraint has been violated
554: --
555: l_proc varchar2(72) := g_package||'insert_dml';
556: --
557: Begin
558: hr_utility.set_location('Entering:'||l_proc, 5);
559: --
560: dt_insert_dml(p_rec => p_rec,
561: p_effective_date => p_effective_date,
562: p_datetrack_mode => p_datetrack_mode,
562: p_datetrack_mode => p_datetrack_mode,
563: p_validation_start_date => p_validation_start_date,
564: p_validation_end_date => p_validation_end_date);
565: --
566: hr_utility.set_location(' Leaving:'||l_proc, 10);
567: End insert_dml;
568: --
569: -- ----------------------------------------------------------------------------
570: -- |------------------------------< pre_insert >------------------------------|
630:
631: l_opt_typ_cd ben_pl_typ_f.opt_typ_cd%type ;
632: --
633: Begin
634: hr_utility.set_location('Entering:'||l_proc, 5);
635: --
636: open c1;
637: --
638: fetch c1 into p_rec.pl_id;
644: fetch c_pln_typ_opt_typ_cd into l_opt_typ_cd ;
645: close c_pln_typ_opt_typ_cd ;
646: if l_opt_typ_cd = 'CWB' then
647: p_rec.group_pl_id := p_rec.pl_id;
648: hr_utility.set_location('CWB parent plan id :'|| p_rec.group_pl_id, 5);
649: --
650: --ICM Changes
651: elsif l_opt_typ_cd = 'ICM' then
652: --
668: p_effective_date => p_effective_date,
669: p_name => p_rec.name
670: ) ;
671: --Bug : 3460429
672: hr_utility.set_location(' Leaving:'||l_proc, 10);
673: End pre_insert;
674: --
675: -- ----------------------------------------------------------------------------
676: -- |-----------------------------< post_insert >------------------------------|
713: --
714: l_proc varchar2(72) := g_package||'post_insert';
715: --
716: Begin
717: hr_utility.set_location('Entering:'||l_proc, 5);
718: --
719: -- Start of API User Hook for post_insert.
720: --
721: -- Added for GSP validations
942: end;
943: --
944: -- End of API User Hook for post_insert.
945: --
946: hr_utility.set_location(' Leaving:'||l_proc, 10);
947: End post_insert;
948: --
949: -- ----------------------------------------------------------------------------
950: -- |-------------------------------< ins_lck >--------------------------------|
996: l_validation_start_date1 date;
997: l_validation_end_date1 date;
998: --
999: Begin
1000: hr_utility.set_location('Entering:'||l_proc, 5);
1001: --
1002: -- Validate the datetrack mode mode getting the validation start
1003: -- and end dates for the specified datetrack operation.
1004: --
1094: p_validation_end_date := l_validation_end_date;
1095: --
1096: end if;
1097: --
1098: hr_utility.set_location(' Leaving:'||l_proc, 10);
1099: --
1100: End ins_lck;
1101: --
1102: -- ----------------------------------------------------------------------------
1113: l_validation_start_date date;
1114: l_validation_end_date date;
1115: --
1116: Begin
1117: hr_utility.set_location('Entering:'||l_proc, 5);
1118: --
1119: -- Call the lock operation
1120: --
1121: ins_lck
1365: l_rec ben_pln_shd.g_rec_type;
1366: l_proc varchar2(72) := g_package||'ins';
1367: --
1368: Begin
1369: hr_utility.set_location('Entering:'||l_proc, 5);
1370: --
1371: -- Call conversion function to turn arguments into the
1372: -- p_rec structure.
1373: --
1579: p_effective_end_date := l_rec.effective_end_date;
1580: p_object_version_number := l_rec.object_version_number;
1581: --
1582: --
1583: hr_utility.set_location(' Leaving:'||l_proc, 10);
1584: End ins;
1585: --
1586: end ben_pln_ins;