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_BEC_BUS dependencies on BEN_BEC_SHD

Line 46: l_api_updating := ben_bec_shd.api_updating

42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := ben_bec_shd.api_updating
47: (p_batch_elctbl_id => p_batch_elctbl_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating

Line 52: <> ben_bec_shd.g_old_rec.batch_elctbl_id) then

48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_batch_elctbl_id,hr_api.g_number)
52: <> ben_bec_shd.g_old_rec.batch_elctbl_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ben_bec_shd.constraint_error('BEN_BATCH_ELCTBL_CHC_INFO_PK');

Line 56: ben_bec_shd.constraint_error('BEN_BATCH_ELCTBL_CHC_INFO_PK');

52: <> ben_bec_shd.g_old_rec.batch_elctbl_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ben_bec_shd.constraint_error('BEN_BATCH_ELCTBL_CHC_INFO_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: ben_bec_shd.constraint_error('BEN_BATCH_ELCTBL_CHC_INFO_PK');

62: if p_batch_elctbl_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: ben_bec_shd.constraint_error('BEN_BATCH_ELCTBL_CHC_INFO_PK');
67: --
68: end if;
69: --
70: end if;

Line 123: l_api_updating := ben_bec_shd.api_updating

119: Begin
120: --
121: hr_utility.set_location('Entering:'||l_proc,5);
122: --
123: l_api_updating := ben_bec_shd.api_updating
124: (p_batch_elctbl_id => p_batch_elctbl_id,
125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating

Line 129: <> nvl(ben_bec_shd.g_old_rec.person_id,hr_api.g_number)

125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating
128: and nvl(p_person_id,hr_api.g_number)
129: <> nvl(ben_bec_shd.g_old_rec.person_id,hr_api.g_number)
130: or not l_api_updating) then
131: --
132: -- check if person_id value exists in per_all_people_f table
133: --

Line 144: ben_bec_shd.constraint_error('BEN_BATCH_ELCTBL_CHC_INFO_DT4');

140: --
141: -- raise error as FK does not relate to PK in per_all_people_f
142: -- table.
143: --
144: ben_bec_shd.constraint_error('BEN_BATCH_ELCTBL_CHC_INFO_DT4');
145: --
146: end if;
147: --
148: close c1;

Line 203: l_api_updating := ben_bec_shd.api_updating

199: Begin
200: --
201: hr_utility.set_location('Entering:'||l_proc,5);
202: --
203: l_api_updating := ben_bec_shd.api_updating
204: (p_batch_elctbl_id => p_batch_elctbl_id,
205: p_object_version_number => p_object_version_number);
206: --
207: if (l_api_updating

Line 209: <> nvl(ben_bec_shd.g_old_rec.oipl_id,hr_api.g_number)

205: p_object_version_number => p_object_version_number);
206: --
207: if (l_api_updating
208: and nvl(p_oipl_id,hr_api.g_number)
209: <> nvl(ben_bec_shd.g_old_rec.oipl_id,hr_api.g_number)
210: or not l_api_updating) and
211: p_oipl_id is not null then
212: --
213: -- check if oipl_id value exists in ben_oipl_f table

Line 225: ben_bec_shd.constraint_error('BEN_BATCH_ELCTBL_CHC_INFO_DT3');

221: --
222: -- raise error as FK does not relate to PK in ben_oipl_f
223: -- table.
224: --
225: ben_bec_shd.constraint_error('BEN_BATCH_ELCTBL_CHC_INFO_DT3');
226: --
227: end if;
228: --
229: close c1;

Line 284: l_api_updating := ben_bec_shd.api_updating

280: Begin
281: --
282: hr_utility.set_location('Entering:'||l_proc,5);
283: --
284: l_api_updating := ben_bec_shd.api_updating
285: (p_batch_elctbl_id => p_batch_elctbl_id,
286: p_object_version_number => p_object_version_number);
287: --
288: if (l_api_updating

Line 290: <> nvl(ben_bec_shd.g_old_rec.pl_id,hr_api.g_number)

286: p_object_version_number => p_object_version_number);
287: --
288: if (l_api_updating
289: and nvl(p_pl_id,hr_api.g_number)
290: <> nvl(ben_bec_shd.g_old_rec.pl_id,hr_api.g_number)
291: or not l_api_updating) and
292: p_pl_id is not null then
293: --
294: -- check if pl_id value exists in ben_pl_f table

Line 306: ben_bec_shd.constraint_error('BEN_BATCH_ELCTBL_CHC_INFO_DT2');

302: --
303: -- raise error as FK does not relate to PK in ben_pl_f
304: -- table.
305: --
306: ben_bec_shd.constraint_error('BEN_BATCH_ELCTBL_CHC_INFO_DT2');
307: --
308: end if;
309: --
310: close c1;

Line 365: l_api_updating := ben_bec_shd.api_updating

361: Begin
362: --
363: hr_utility.set_location('Entering:'||l_proc,5);
364: --
365: l_api_updating := ben_bec_shd.api_updating
366: (p_batch_elctbl_id => p_batch_elctbl_id,
367: p_object_version_number => p_object_version_number);
368: --
369: if (l_api_updating

Line 371: <> nvl(ben_bec_shd.g_old_rec.pgm_id,hr_api.g_number)

367: p_object_version_number => p_object_version_number);
368: --
369: if (l_api_updating
370: and nvl(p_pgm_id,hr_api.g_number)
371: <> nvl(ben_bec_shd.g_old_rec.pgm_id,hr_api.g_number)
372: or not l_api_updating) and
373: p_pgm_id is not null then
374: --
375: -- check if pgm_id value exists in ben_pgm_f table

Line 387: ben_bec_shd.constraint_error('BEN_BATCH_ELCTBL_CHC_INFO_DT1');

383: --
384: -- raise error as FK does not relate to PK in ben_pgm_f
385: -- table.
386: --
387: ben_bec_shd.constraint_error('BEN_BATCH_ELCTBL_CHC_INFO_DT1');
388: --
389: end if;
390: --
391: close c1;

Line 441: l_api_updating := ben_bec_shd.api_updating

437: Begin
438: --
439: hr_utility.set_location('Entering:'||l_proc,5);
440: --
441: l_api_updating := ben_bec_shd.api_updating
442: (p_batch_elctbl_id => p_batch_elctbl_id,
443: p_object_version_number => p_object_version_number);
444: --
445: if (l_api_updating

Line 447: <> nvl(ben_bec_shd.g_old_rec.benefit_action_id,hr_api.g_number)

443: p_object_version_number => p_object_version_number);
444: --
445: if (l_api_updating
446: and nvl(p_benefit_action_id,hr_api.g_number)
447: <> nvl(ben_bec_shd.g_old_rec.benefit_action_id,hr_api.g_number)
448: or not l_api_updating) then
449: --
450: -- check if benefit_action_id value exists in ben_benefit_actions table
451: --

Line 462: ben_bec_shd.constraint_error('BEN_BATCH_ELCTBL_CHC_INFO_FK1');

458: --
459: -- raise error as FK does not relate to PK in ben_benefit_actions
460: -- table.
461: --
462: ben_bec_shd.constraint_error('BEN_BATCH_ELCTBL_CHC_INFO_FK1');
463: --
464: end if;
465: --
466: close c1;

Line 512: l_api_updating := ben_bec_shd.api_updating

508: Begin
509: --
510: hr_utility.set_location('Entering:'||l_proc, 5);
511: --
512: l_api_updating := ben_bec_shd.api_updating
513: (p_batch_elctbl_id => p_batch_elctbl_id,
514: p_object_version_number => p_object_version_number);
515: --
516: if (l_api_updating

Line 518: <> nvl(ben_bec_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)

514: p_object_version_number => p_object_version_number);
515: --
516: if (l_api_updating
517: and p_dflt_flag
518: <> nvl(ben_bec_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)
519: or not l_api_updating) then
520: --
521: -- check if value of lookup falls within lookup type.
522: --

Line 582: l_api_updating := ben_bec_shd.api_updating

578: Begin
579: --
580: hr_utility.set_location('Entering:'||l_proc, 5);
581: --
582: l_api_updating := ben_bec_shd.api_updating
583: (p_batch_elctbl_id => p_batch_elctbl_id,
584: p_object_version_number => p_object_version_number);
585: --
586: if (l_api_updating

Line 588: <> nvl(ben_bec_shd.g_old_rec.mndtry_flag,hr_api.g_varchar2)

584: p_object_version_number => p_object_version_number);
585: --
586: if (l_api_updating
587: and p_mndtry_flag
588: <> nvl(ben_bec_shd.g_old_rec.mndtry_flag,hr_api.g_varchar2)
589: or not l_api_updating) then
590: --
591: -- check if value of lookup falls within lookup type.
592: --

Line 652: l_api_updating := ben_bec_shd.api_updating

648: Begin
649: --
650: hr_utility.set_location('Entering:'||l_proc, 5);
651: --
652: l_api_updating := ben_bec_shd.api_updating
653: (p_batch_elctbl_id => p_batch_elctbl_id,
654: p_object_version_number => p_object_version_number);
655: --
656: if (l_api_updating

Line 658: <> nvl(ben_bec_shd.g_old_rec.comp_lvl_cd,hr_api.g_varchar2)

654: p_object_version_number => p_object_version_number);
655: --
656: if (l_api_updating
657: and p_comp_lvl_cd
658: <> nvl(ben_bec_shd.g_old_rec.comp_lvl_cd,hr_api.g_varchar2)
659: or not l_api_updating)
660: and p_comp_lvl_cd is not null then
661: --
662: -- check if value of lookup falls within lookup type.

Line 722: l_api_updating := ben_bec_shd.api_updating

718: Begin
719: --
720: hr_utility.set_location('Entering:'||l_proc, 5);
721: --
722: l_api_updating := ben_bec_shd.api_updating
723: (p_batch_elctbl_id => p_batch_elctbl_id,
724: p_object_version_number => p_object_version_number);
725: --
726: if (l_api_updating

Line 728: <> nvl(ben_bec_shd.g_old_rec.enrt_typ_cycl_cd,hr_api.g_varchar2)

724: p_object_version_number => p_object_version_number);
725: --
726: if (l_api_updating
727: and p_enrt_typ_cycl_cd
728: <> nvl(ben_bec_shd.g_old_rec.enrt_typ_cycl_cd,hr_api.g_varchar2)
729: or not l_api_updating)
730: and p_enrt_typ_cycl_cd is not null then
731: --
732: -- check if value of lookup falls within lookup type.

Line 757: Procedure insert_validate(p_rec in ben_bec_shd.g_rec_type

753: --
754: -- ----------------------------------------------------------------------------
755: -- |---------------------------< insert_validate >----------------------------|
756: -- ----------------------------------------------------------------------------
757: Procedure insert_validate(p_rec in ben_bec_shd.g_rec_type
758: ,p_effective_date in date) is
759: --
760: l_proc varchar2(72) := g_package||'insert_validate';
761: --

Line 833: Procedure update_validate(p_rec in ben_bec_shd.g_rec_type

829: --
830: -- ----------------------------------------------------------------------------
831: -- |---------------------------< update_validate >----------------------------|
832: -- ----------------------------------------------------------------------------
833: Procedure update_validate(p_rec in ben_bec_shd.g_rec_type
834: ,p_effective_date in date) is
835: --
836: l_proc varchar2(72) := g_package||'update_validate';
837: --

Line 909: Procedure delete_validate(p_rec in ben_bec_shd.g_rec_type

905: --
906: -- ----------------------------------------------------------------------------
907: -- |---------------------------< delete_validate >----------------------------|
908: -- ----------------------------------------------------------------------------
909: Procedure delete_validate(p_rec in ben_bec_shd.g_rec_type
910: ,p_effective_date in date) is
911: --
912: l_proc varchar2(72) := g_package||'delete_validate';
913: --