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_PRG_BUS dependencies on BEN_PRG_SHD

Line 48: l_api_updating := ben_prg_shd.api_updating

44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_prg_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_pl_regn_id => p_pl_regn_id,
51: p_object_version_number => p_object_version_number);
52: --

Line 55: <> ben_prg_shd.g_old_rec.pl_regn_id) then

51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_pl_regn_id,hr_api.g_number)
55: <> ben_prg_shd.g_old_rec.pl_regn_id) then
56: --
57: -- raise error as PK has changed
58: --
59: ben_prg_shd.constraint_error('BEN_PL_REGN_PK');

Line 59: ben_prg_shd.constraint_error('BEN_PL_REGN_PK');

55: <> ben_prg_shd.g_old_rec.pl_regn_id) then
56: --
57: -- raise error as PK has changed
58: --
59: ben_prg_shd.constraint_error('BEN_PL_REGN_PK');
60: --
61: elsif not l_api_updating then
62: --
63: -- check if PK is null

Line 69: ben_prg_shd.constraint_error('BEN_PL_REGN_PK');

65: if p_pl_regn_id is not null then
66: --
67: -- raise error as PK is not null
68: --
69: ben_prg_shd.constraint_error('BEN_PL_REGN_PK');
70: --
71: end if;
72: --
73: end if;

Line 193: l_api_updating := ben_prg_shd.api_updating

189: Begin
190: --
191: hr_utility.set_location('Entering:'||l_proc,5);
192: --
193: l_api_updating := ben_prg_shd.api_updating
194: (p_pl_regn_id => p_pl_regn_id,
195: p_effective_date => p_effective_date,
196: p_object_version_number => p_object_version_number);
197: --

Line 200: <> nvl(ben_prg_shd.g_old_rec.rptg_grp_id,hr_api.g_number)

196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating
199: and nvl(p_rptg_grp_id,hr_api.g_number)
200: <> nvl(ben_prg_shd.g_old_rec.rptg_grp_id,hr_api.g_number)
201: or not l_api_updating) then
202: --
203: -- check if pl_id value exists in ben_rept_grp table
204: --

Line 281: l_api_updating := ben_prg_shd.api_updating

277: Begin
278: --
279: hr_utility.set_location('Entering:'||l_proc, 5);
280: --
281: l_api_updating := ben_prg_shd.api_updating
282: (p_pl_regn_id => p_pl_regn_id ,
283: p_effective_date => p_effective_date,
284: p_object_version_number => p_object_version_number);
285: --

Line 288: <> ben_prg_shd.g_old_rec.hghly_compd_det_rl

284: p_object_version_number => p_object_version_number);
285: --
286: if (l_api_updating
287: and nvl(p_hghly_compd_det_rl ,hr_api.g_number)
288: <> ben_prg_shd.g_old_rec.hghly_compd_det_rl
289: or not l_api_updating)
290: and p_hghly_compd_det_rl is not null then
291: --
292: -- check if value of formula rule is valid.

Line 373: l_api_updating := ben_prg_shd.api_updating

369: Begin
370: --
371: hr_utility.set_location('Entering:'||l_proc, 5);
372: --
373: l_api_updating := ben_prg_shd.api_updating
374: (p_pl_regn_id => p_pl_regn_id,
375: p_effective_date => p_effective_date,
376: p_object_version_number => p_object_version_number);
377: --

Line 380: <> ben_prg_shd.g_old_rec.key_ee_det_rl

376: p_object_version_number => p_object_version_number);
377: --
378: if (l_api_updating
379: and nvl(p_key_ee_det_rl ,hr_api.g_number)
380: <> ben_prg_shd.g_old_rec.key_ee_det_rl
381: or not l_api_updating)
382: and p_key_ee_det_rl is not null then
383: --
384: -- check if value of formula rule is valid.

Line 465: l_api_updating := ben_prg_shd.api_updating

461: Begin
462: --
463: hr_utility.set_location('Entering:'||l_proc, 5);
464: --
465: l_api_updating := ben_prg_shd.api_updating
466: (p_pl_regn_id => p_pl_regn_id,
467: p_effective_date => p_effective_date,
468: p_object_version_number => p_object_version_number);
469: --

Line 472: <> ben_prg_shd.g_old_rec.cntr_nndscrn_rl

468: p_object_version_number => p_object_version_number);
469: --
470: if (l_api_updating
471: and nvl(p_cntr_nndscrn_rl ,hr_api.g_number)
472: <> ben_prg_shd.g_old_rec.cntr_nndscrn_rl
473: or not l_api_updating)
474: and p_cntr_nndscrn_rl is not null then
475: --
476: -- check if value of formula rule is valid.

Line 557: l_api_updating := ben_prg_shd.api_updating

553: Begin
554: --
555: hr_utility.set_location('Entering:'||l_proc, 5);
556: --
557: l_api_updating := ben_prg_shd.api_updating
558: (p_pl_regn_id => p_pl_regn_id ,
559: p_effective_date => p_effective_date,
560: p_object_version_number => p_object_version_number);
561: --

Line 564: <> ben_prg_shd.g_old_rec.cvg_nndscrn_rl

560: p_object_version_number => p_object_version_number);
561: --
562: if (l_api_updating
563: and nvl(p_cvg_nndscrn_rl ,hr_api.g_number)
564: <> ben_prg_shd.g_old_rec.cvg_nndscrn_rl
565: or not l_api_updating)
566: and p_cvg_nndscrn_rl is not null then
567: --
568: -- check if value of formula rule is valid.

Line 649: l_api_updating := ben_prg_shd.api_updating

645: Begin
646: --
647: hr_utility.set_location('Entering:'||l_proc, 5);
648: --
649: l_api_updating := ben_prg_shd.api_updating
650: (p_pl_regn_id => p_pl_regn_id,
651: p_effective_date => p_effective_date,
652: p_object_version_number => p_object_version_number);
653: --

Line 656: <> ben_prg_shd.g_old_rec.five_pct_ownr_rl

652: p_object_version_number => p_object_version_number);
653: --
654: if (l_api_updating
655: and nvl(p_five_pct_ownr_rl ,hr_api.g_number)
656: <> ben_prg_shd.g_old_rec.five_pct_ownr_rl
657: or not l_api_updating)
658: and p_five_pct_ownr_rl is not null then
659: --
660: -- check if value of formula rule is valid.

Line 725: l_api_updating := ben_prg_shd.api_updating

721: Begin
722: --
723: hr_utility.set_location('Entering:'||l_proc, 5);
724: --
725: l_api_updating := ben_prg_shd.api_updating
726: (p_pl_regn_id => p_pl_regn_id,
727: p_effective_date => p_effective_date,
728: p_object_version_number => p_object_version_number);
729: --

Line 732: <> nvl(ben_prg_shd.g_old_rec.regy_pl_typ_cd,hr_api.g_varchar2)

728: p_object_version_number => p_object_version_number);
729: --
730: if (l_api_updating
731: and p_regy_pl_typ_cd
732: <> nvl(ben_prg_shd.g_old_rec.regy_pl_typ_cd,hr_api.g_varchar2)
733: or not l_api_updating) and p_regy_pl_typ_cd is not null then
734: --
735: -- check if value of lookup falls within lookup type.
736: --

Line 1029: (p_rec in ben_prg_shd.g_rec_type,

1025: -- ----------------------------------------------------------------------------
1026: -- |---------------------------< insert_validate >----------------------------|
1027: -- ----------------------------------------------------------------------------
1028: Procedure insert_validate
1029: (p_rec in ben_prg_shd.g_rec_type,
1030: p_effective_date in date,
1031: p_datetrack_mode in varchar2,
1032: p_validation_start_date in date,
1033: p_validation_end_date in date) is

Line 1121: (p_rec in ben_prg_shd.g_rec_type,

1117: -- ----------------------------------------------------------------------------
1118: -- |---------------------------< update_validate >----------------------------|
1119: -- ----------------------------------------------------------------------------
1120: Procedure update_validate
1121: (p_rec in ben_prg_shd.g_rec_type,
1122: p_effective_date in date,
1123: p_datetrack_mode in varchar2,
1124: p_validation_start_date in date,
1125: p_validation_end_date in date) is

Line 1226: (p_rec in ben_prg_shd.g_rec_type,

1222: -- ----------------------------------------------------------------------------
1223: -- |---------------------------< delete_validate >----------------------------|
1224: -- ----------------------------------------------------------------------------
1225: Procedure delete_validate
1226: (p_rec in ben_prg_shd.g_rec_type,
1227: p_effective_date in date,
1228: p_datetrack_mode in varchar2,
1229: p_validation_start_date in date,
1230: p_validation_end_date in date) is