eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CPD_INS dependencies on BEN_CPD_INS

Line 1: Package Body ben_cpd_ins as

1: Package Body ben_cpd_ins as
2: /* $Header: becpdrhi.pkb 120.4.12020000.3 2013/01/02 07:16:14 kmsuresh ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' ben_cpd_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 30: ben_cpd_ins.g_pl_id_i := p_pl_id;

26: --
27: Begin
28: hr_utility.set_location('Entering:'||l_proc, 10);
29: --
30: ben_cpd_ins.g_pl_id_i := p_pl_id;
31: ben_cpd_ins.g_lf_evt_ocrd_dt_i := p_lf_evt_ocrd_dt;
32: ben_cpd_ins.g_oipl_id_i := p_oipl_id;
33: --
34: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 31: ben_cpd_ins.g_lf_evt_ocrd_dt_i := p_lf_evt_ocrd_dt;

27: Begin
28: hr_utility.set_location('Entering:'||l_proc, 10);
29: --
30: ben_cpd_ins.g_pl_id_i := p_pl_id;
31: ben_cpd_ins.g_lf_evt_ocrd_dt_i := p_lf_evt_ocrd_dt;
32: ben_cpd_ins.g_oipl_id_i := p_oipl_id;
33: --
34: hr_utility.set_location(' Leaving:'||l_proc, 20);
35: End set_base_key_value;

Line 32: ben_cpd_ins.g_oipl_id_i := p_oipl_id;

28: hr_utility.set_location('Entering:'||l_proc, 10);
29: --
30: ben_cpd_ins.g_pl_id_i := p_pl_id;
31: ben_cpd_ins.g_lf_evt_ocrd_dt_i := p_lf_evt_ocrd_dt;
32: ben_cpd_ins.g_oipl_id_i := p_oipl_id;
33: --
34: hr_utility.set_location(' Leaving:'||l_proc, 20);
35: End set_base_key_value;
36: --

Line 355: ben_cpd_ins.g_pl_id_i

351: Cursor C_Sel1 is
352: Select null
353: from ben_cwb_pl_dsgn
354: where pl_id =
355: ben_cpd_ins.g_pl_id_i
356: or lf_evt_ocrd_dt =
357: ben_cpd_ins.g_lf_evt_ocrd_dt_i
358: or oipl_id =
359: ben_cpd_ins.g_oipl_id_i;

Line 357: ben_cpd_ins.g_lf_evt_ocrd_dt_i

353: from ben_cwb_pl_dsgn
354: where pl_id =
355: ben_cpd_ins.g_pl_id_i
356: or lf_evt_ocrd_dt =
357: ben_cpd_ins.g_lf_evt_ocrd_dt_i
358: or oipl_id =
359: ben_cpd_ins.g_oipl_id_i;
360: --
361: l_proc varchar2(72) := g_package||'pre_insert';

Line 359: ben_cpd_ins.g_oipl_id_i;

355: ben_cpd_ins.g_pl_id_i
356: or lf_evt_ocrd_dt =
357: ben_cpd_ins.g_lf_evt_ocrd_dt_i
358: or oipl_id =
359: ben_cpd_ins.g_oipl_id_i;
360: --
361: l_proc varchar2(72) := g_package||'pre_insert';
362: l_exists varchar2(1);
363: --

Line 367: If (ben_cpd_ins.g_pl_id_i is not null or

363: --
364: Begin
365: hr_utility.set_location('Entering:'||l_proc, 5);
366: --
367: If (ben_cpd_ins.g_pl_id_i is not null or
368: ben_cpd_ins.g_lf_evt_ocrd_dt_i is not null or
369: ben_cpd_ins.g_oipl_id_i is not null) Then
370: --
371: -- Verify registered primary key values not already in use

Line 368: ben_cpd_ins.g_lf_evt_ocrd_dt_i is not null or

364: Begin
365: hr_utility.set_location('Entering:'||l_proc, 5);
366: --
367: If (ben_cpd_ins.g_pl_id_i is not null or
368: ben_cpd_ins.g_lf_evt_ocrd_dt_i is not null or
369: ben_cpd_ins.g_oipl_id_i is not null) Then
370: --
371: -- Verify registered primary key values not already in use
372: --

Line 369: ben_cpd_ins.g_oipl_id_i is not null) Then

365: hr_utility.set_location('Entering:'||l_proc, 5);
366: --
367: If (ben_cpd_ins.g_pl_id_i is not null or
368: ben_cpd_ins.g_lf_evt_ocrd_dt_i is not null or
369: ben_cpd_ins.g_oipl_id_i is not null) Then
370: --
371: -- Verify registered primary key values not already in use
372: --
373: Open C_Sel1;

Line 389: ben_cpd_ins.g_pl_id_i;

385: --
386: -- Use registered key values and clear globals
387: --
388: p_rec.pl_id :=
389: ben_cpd_ins.g_pl_id_i;
390: ben_cpd_ins.g_pl_id_i := null;
391: p_rec.lf_evt_ocrd_dt :=
392: ben_cpd_ins.g_lf_evt_ocrd_dt_i;
393: ben_cpd_ins.g_lf_evt_ocrd_dt_i := null;

Line 390: ben_cpd_ins.g_pl_id_i := null;

386: -- Use registered key values and clear globals
387: --
388: p_rec.pl_id :=
389: ben_cpd_ins.g_pl_id_i;
390: ben_cpd_ins.g_pl_id_i := null;
391: p_rec.lf_evt_ocrd_dt :=
392: ben_cpd_ins.g_lf_evt_ocrd_dt_i;
393: ben_cpd_ins.g_lf_evt_ocrd_dt_i := null;
394: p_rec.oipl_id :=

Line 392: ben_cpd_ins.g_lf_evt_ocrd_dt_i;

388: p_rec.pl_id :=
389: ben_cpd_ins.g_pl_id_i;
390: ben_cpd_ins.g_pl_id_i := null;
391: p_rec.lf_evt_ocrd_dt :=
392: ben_cpd_ins.g_lf_evt_ocrd_dt_i;
393: ben_cpd_ins.g_lf_evt_ocrd_dt_i := null;
394: p_rec.oipl_id :=
395: ben_cpd_ins.g_oipl_id_i;
396: ben_cpd_ins.g_oipl_id_i := null;

Line 393: ben_cpd_ins.g_lf_evt_ocrd_dt_i := null;

389: ben_cpd_ins.g_pl_id_i;
390: ben_cpd_ins.g_pl_id_i := null;
391: p_rec.lf_evt_ocrd_dt :=
392: ben_cpd_ins.g_lf_evt_ocrd_dt_i;
393: ben_cpd_ins.g_lf_evt_ocrd_dt_i := null;
394: p_rec.oipl_id :=
395: ben_cpd_ins.g_oipl_id_i;
396: ben_cpd_ins.g_oipl_id_i := null;
397: Else

Line 395: ben_cpd_ins.g_oipl_id_i;

391: p_rec.lf_evt_ocrd_dt :=
392: ben_cpd_ins.g_lf_evt_ocrd_dt_i;
393: ben_cpd_ins.g_lf_evt_ocrd_dt_i := null;
394: p_rec.oipl_id :=
395: ben_cpd_ins.g_oipl_id_i;
396: ben_cpd_ins.g_oipl_id_i := null;
397: Else
398: -- Commented out the following code as it is not required.
399: null;

Line 396: ben_cpd_ins.g_oipl_id_i := null;

392: ben_cpd_ins.g_lf_evt_ocrd_dt_i;
393: ben_cpd_ins.g_lf_evt_ocrd_dt_i := null;
394: p_rec.oipl_id :=
395: ben_cpd_ins.g_oipl_id_i;
396: ben_cpd_ins.g_oipl_id_i := null;
397: Else
398: -- Commented out the following code as it is not required.
399: null;
400: /* --

Line 681: ben_cpd_ins.pre_insert(p_rec);

677: hr_multi_message.end_validation_set;
678: --
679: -- Call the supporting pre-insert operation
680: --
681: ben_cpd_ins.pre_insert(p_rec);
682: --
683: -- Insert the row
684: --
685: ben_cpd_ins.insert_dml(p_rec);

Line 685: ben_cpd_ins.insert_dml(p_rec);

681: ben_cpd_ins.pre_insert(p_rec);
682: --
683: -- Insert the row
684: --
685: ben_cpd_ins.insert_dml(p_rec);
686: --
687: -- Call the supporting post-insert operation
688: --
689: ben_cpd_ins.post_insert

Line 689: ben_cpd_ins.post_insert

685: ben_cpd_ins.insert_dml(p_rec);
686: --
687: -- Call the supporting post-insert operation
688: --
689: ben_cpd_ins.post_insert
690: (p_rec
691: );
692: --
693: -- Call to raise any errors on multi-message list

Line 917: ben_cpd_ins.ins

913: --
914: -- Having converted the arguments into the ben_cpd_rec
915: -- plsql record structure we call the corresponding record business process.
916: --
917: ben_cpd_ins.ins
918: (l_rec
919: );
920: --
921: -- As the primary key argument(s)

Line 929: end ben_cpd_ins;

925: --
926: hr_utility.set_location(' Leaving:'||l_proc, 10);
927: End ins;
928: --
929: end ben_cpd_ins;