APPS.BEN_QIG_INS dependencies on BEN_QIG_INS

Line 1: Package Body ben_qig_ins as

1: Package Body ben_qig_ins as
2: /* $Header: beqigrhi.pkb 120.3 2008/02/05 08:40:32 rtagarra noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' ben_qig_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_qig_ins.g_qua_in_gr_rt_id_i := p_qua_in_gr_rt_id;

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

Line 286: ben_qig_ins.dt_insert_dml

282: --
283: Begin
284: hr_utility.set_location('Entering:'||l_proc, 5);
285: --
286: ben_qig_ins.dt_insert_dml
287: (p_rec => p_rec
288: ,p_effective_date => p_effective_date
289: ,p_datetrack_mode => p_datetrack_mode
290: ,p_validation_start_date => p_validation_start_date

Line 350: ben_qig_ins.g_qua_in_gr_rt_id_i;

346: Cursor C_Sel2 is
347: Select null
348: from ben_qua_in_gr_rt_f
349: where qua_in_gr_rt_id =
350: ben_qig_ins.g_qua_in_gr_rt_id_i;
351: --
352: l_proc varchar2(72) := g_package||'pre_insert';
353: l_exists varchar2(1);
354: --

Line 358: If (ben_qig_ins.g_qua_in_gr_rt_id_i is not null) Then

354: --
355: Begin
356: hr_utility.set_location('Entering:'||l_proc, 5);
357: --
358: If (ben_qig_ins.g_qua_in_gr_rt_id_i is not null) Then
359: --
360: -- Verify registered primary key values not already in use
361: --
362: Open C_Sel2;

Line 378: ben_qig_ins.g_qua_in_gr_rt_id_i;

374: --
375: -- Use registered key values and clear globals
376: --
377: p_rec.qua_in_gr_rt_id :=
378: ben_qig_ins.g_qua_in_gr_rt_id_i;
379: ben_qig_ins.g_qua_in_gr_rt_id_i := null;
380: Else
381: --
382: -- No registerd key values, so select the next sequence number

Line 379: ben_qig_ins.g_qua_in_gr_rt_id_i := null;

375: -- Use registered key values and clear globals
376: --
377: p_rec.qua_in_gr_rt_id :=
378: ben_qig_ins.g_qua_in_gr_rt_id_i;
379: ben_qig_ins.g_qua_in_gr_rt_id_i := null;
380: Else
381: --
382: -- No registerd key values, so select the next sequence number
383: --

Line 639: ben_qig_ins.ins_lck

635: hr_utility.set_location('Entering:'||l_proc, 5);
636: --
637: -- Call the lock operation
638: --
639: ben_qig_ins.ins_lck
640: (p_effective_date => p_effective_date
641: ,p_datetrack_mode => l_datetrack_mode
642: ,p_rec => p_rec
643: ,p_validation_start_date => l_validation_start_date

Line 662: ben_qig_ins.pre_insert

658: hr_multi_message.end_validation_set;
659: --
660: -- Call the supporting pre-insert operation
661: --
662: ben_qig_ins.pre_insert
663: (p_rec => p_rec
664: ,p_effective_date => p_effective_date
665: ,p_datetrack_mode => l_datetrack_mode
666: ,p_validation_start_date => l_validation_start_date

Line 672: ben_qig_ins.insert_dml

668: );
669: --
670: -- Insert the row
671: --
672: ben_qig_ins.insert_dml
673: (p_rec => p_rec
674: ,p_effective_date => p_effective_date
675: ,p_datetrack_mode => l_datetrack_mode
676: ,p_validation_start_date => l_validation_start_date

Line 682: ben_qig_ins.post_insert

678: );
679: --
680: -- Call the supporting post-insert operation
681: --
682: ben_qig_ins.post_insert
683: (p_rec => p_rec
684: ,p_effective_date => p_effective_date
685: ,p_datetrack_mode => l_datetrack_mode
686: ,p_validation_start_date => l_validation_start_date

Line 800: ben_qig_ins.ins

796: -- Having converted the arguments into the ben_qig_rec
797: -- plsql record structure we call the corresponding record
798: -- business process.
799: --
800: ben_qig_ins.ins
801: (p_effective_date
802: ,l_rec
803: );
804: --

Line 816: end ben_qig_ins;

812: --
813: hr_utility.set_location(' Leaving:'||l_proc, 10);
814: End ins;
815: --
816: end ben_qig_ins;