APPS.BEN_ESW_INS dependencies on BEN_ESW_INS

Line 1: Package Body ben_esw_ins as

1: Package Body ben_esw_ins as
2: /* $Header: beeswrhi.pkb 120.1 2005/06/17 09:40 abparekh noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' ben_esw_ins.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' ben_esw_ins.'; -- Global package name
9: --
10: -- The following global variables are only to be used by
11: -- the set_base_key_value and pre_insert procedures.
12: --

Line 26: ben_esw_ins.g_elig_scre_wtg_id_i := p_elig_scre_wtg_id;

22: --
23: Begin
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: ben_esw_ins.g_elig_scre_wtg_id_i := p_elig_scre_wtg_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --

Line 230: ben_esw_ins.dt_insert_dml

226: --
227: Begin
228: hr_utility.set_location('Entering:'||l_proc, 5);
229: --
230: ben_esw_ins.dt_insert_dml
231: (p_rec => p_rec
232: ,p_effective_date => p_effective_date
233: ,p_datetrack_mode => p_datetrack_mode
234: ,p_validation_start_date => p_validation_start_date

Line 294: ben_esw_ins.g_elig_scre_wtg_id_i;

290: Cursor C_Sel2 is
291: Select null
292: from ben_elig_scre_wtg_f
293: where elig_scre_wtg_id =
294: ben_esw_ins.g_elig_scre_wtg_id_i;
295: --
296: l_proc varchar2(72) := g_package||'pre_insert';
297: l_exists varchar2(1);
298: --

Line 302: If (ben_esw_ins.g_elig_scre_wtg_id_i is not null) Then

298: --
299: Begin
300: hr_utility.set_location('Entering:'||l_proc, 5);
301: --
302: If (ben_esw_ins.g_elig_scre_wtg_id_i is not null) Then
303: --
304: -- Verify registered primary key values not already in use
305: --
306: Open C_Sel2;

Line 322: ben_esw_ins.g_elig_scre_wtg_id_i;

318: --
319: -- Use registered key values and clear globals
320: --
321: p_rec.elig_scre_wtg_id :=
322: ben_esw_ins.g_elig_scre_wtg_id_i;
323: ben_esw_ins.g_elig_scre_wtg_id_i := null;
324: Else
325: --
326: -- No registerd key values, so select the next sequence number

Line 323: ben_esw_ins.g_elig_scre_wtg_id_i := null;

319: -- Use registered key values and clear globals
320: --
321: p_rec.elig_scre_wtg_id :=
322: ben_esw_ins.g_elig_scre_wtg_id_i;
323: ben_esw_ins.g_elig_scre_wtg_id_i := null;
324: Else
325: --
326: -- No registerd key values, so select the next sequence number
327: --

Line 526: ben_esw_ins.ins_lck

522: hr_utility.set_location('Entering:'||l_proc, 5);
523: --
524: -- Call the lock operation
525: --
526: ben_esw_ins.ins_lck
527: (p_effective_date => p_effective_date
528: ,p_datetrack_mode => l_datetrack_mode
529: ,p_rec => p_rec
530: ,p_validation_start_date => l_validation_start_date

Line 549: ben_esw_ins.pre_insert

545: hr_multi_message.end_validation_set;
546: --
547: -- Call the supporting pre-insert operation
548: --
549: ben_esw_ins.pre_insert
550: (p_rec => p_rec
551: ,p_effective_date => p_effective_date
552: ,p_datetrack_mode => l_datetrack_mode
553: ,p_validation_start_date => l_validation_start_date

Line 559: ben_esw_ins.insert_dml

555: );
556: --
557: -- Insert the row
558: --
559: ben_esw_ins.insert_dml
560: (p_rec => p_rec
561: ,p_effective_date => p_effective_date
562: ,p_datetrack_mode => l_datetrack_mode
563: ,p_validation_start_date => l_validation_start_date

Line 569: ben_esw_ins.post_insert

565: );
566: --
567: -- Call the supporting post-insert operation
568: --
569: ben_esw_ins.post_insert
570: (p_rec => p_rec
571: ,p_effective_date => p_effective_date
572: ,p_datetrack_mode => l_datetrack_mode
573: ,p_validation_start_date => l_validation_start_date

Line 633: ben_esw_ins.ins

629: -- Having converted the arguments into the ben_esw_rec
630: -- plsql record structure we call the corresponding record
631: -- business process.
632: --
633: ben_esw_ins.ins
634: (p_effective_date
635: ,l_rec
636: );
637: --

Line 649: end ben_esw_ins;

645: --
646: hr_utility.set_location(' Leaving:'||l_proc, 10);
647: End ins;
648: --
649: end ben_esw_ins;