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_PRV_BUS dependencies on HR_API

Line 51: and nvl(p_prtt_rt_val_id,hr_api.g_number)

47: (p_prtt_rt_val_id => p_prtt_rt_val_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_prtt_rt_val_id,hr_api.g_number)
52: <> ben_prv_shd.g_old_rec.prtt_rt_val_id) then
53: --
54: -- raise error as PK has changed
55: --

Line 128: and nvl(p_prtt_enrt_rslt_id,hr_api.g_number)

124: (p_prtt_rt_val_id => p_prtt_rt_val_id,
125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating
128: and nvl(p_prtt_enrt_rslt_id,hr_api.g_number)
129: <> nvl(ben_prv_shd.g_old_rec.prtt_enrt_rslt_id,hr_api.g_number)
130: or not l_api_updating) then
131: --
132: -- check if prtt_enrt_rslt_id value exists in ben_prtt_enrt_rslt_f table

Line 129: <> nvl(ben_prv_shd.g_old_rec.prtt_enrt_rslt_id,hr_api.g_number)

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

Line 208: and nvl(p_element_entry_value_id,hr_api.g_number)

204: (p_prtt_rt_val_id => p_prtt_rt_val_id,
205: p_object_version_number => p_object_version_number);
206: --
207: if (l_api_updating
208: and nvl(p_element_entry_value_id,hr_api.g_number)
209: <> nvl(ben_prv_shd.g_old_rec.element_entry_value_id,hr_api.g_number)
210: or not l_api_updating) then
211: --
212: -- check if element_entry_value_id value exists in pay_element_entry_values_f table

Line 209: <> nvl(ben_prv_shd.g_old_rec.element_entry_value_id,hr_api.g_number)

205: p_object_version_number => p_object_version_number);
206: --
207: if (l_api_updating
208: and nvl(p_element_entry_value_id,hr_api.g_number)
209: <> nvl(ben_prv_shd.g_old_rec.element_entry_value_id,hr_api.g_number)
210: or not l_api_updating) then
211: --
212: -- check if element_entry_value_id value exists in pay_element_entry_values_f table
213: --

Line 280: <> nvl(ben_prv_shd.g_old_rec.cmcd_ref_perd_cd,hr_api.g_varchar2)

276: p_object_version_number => p_object_version_number);
277: --
278: if (l_api_updating
279: and p_cmcd_ref_perd_cd
280: <> nvl(ben_prv_shd.g_old_rec.cmcd_ref_perd_cd,hr_api.g_varchar2)
281: or not l_api_updating)
282: and p_cmcd_ref_perd_cd is not null then
283: --
284: -- check if value of lookup falls within lookup type.

Line 286: if hr_api.not_exists_in_hr_lookups

282: and p_cmcd_ref_perd_cd is not null then
283: --
284: -- check if value of lookup falls within lookup type.
285: --
286: if hr_api.not_exists_in_hr_lookups
287: (p_lookup_type => 'BEN_ENRT_INFO_RT_FREQ',
288: p_lookup_code => p_cmcd_ref_perd_cd,
289: p_effective_date => p_effective_date) then
290: --

Line 349: <> nvl(ben_prv_shd.g_old_rec.prtt_rt_val_stat_cd,hr_api.g_varchar2)

345: p_object_version_number => p_object_version_number);
346: --
347: if (l_api_updating
348: and p_prtt_rt_val_stat_cd
349: <> nvl(ben_prv_shd.g_old_rec.prtt_rt_val_stat_cd,hr_api.g_varchar2)
350: or not l_api_updating)
351: and p_prtt_rt_val_stat_cd is not null then
352: --
353: -- check if value of lookup falls within lookup type.

Line 355: if hr_api.not_exists_in_hr_lookups

351: and p_prtt_rt_val_stat_cd is not null then
352: --
353: -- check if value of lookup falls within lookup type.
354: -- The prtt-rt-val status code shares a lookup with the result status code.
355: if hr_api.not_exists_in_hr_lookups
356: (p_lookup_type => 'BEN_PRTT_ENRT_RSLT_STAT',
357: p_lookup_code => p_prtt_rt_val_stat_cd,
358: p_effective_date => p_effective_date) then
359: --

Line 419: <> nvl(ben_prv_shd.g_old_rec.bnft_rt_typ_cd,hr_api.g_varchar2)

415: p_object_version_number => p_object_version_number);
416: --
417: if (l_api_updating
418: and p_bnft_rt_typ_cd
419: <> nvl(ben_prv_shd.g_old_rec.bnft_rt_typ_cd,hr_api.g_varchar2)
420: or not l_api_updating)
421: and p_bnft_rt_typ_cd is not null then
422: --
423: -- check if value of lookup falls within lookup type.

Line 425: if hr_api.not_exists_in_hr_lookups

421: and p_bnft_rt_typ_cd is not null then
422: --
423: -- check if value of lookup falls within lookup type.
424: --
425: if hr_api.not_exists_in_hr_lookups
426: (p_lookup_type => 'BEN_RT_TYP',
427: p_lookup_code => p_bnft_rt_typ_cd,
428: p_effective_date => p_effective_date) then
429: --

Line 489: <> nvl(ben_prv_shd.g_old_rec.acty_ref_perd_cd,hr_api.g_varchar2)

485: p_object_version_number => p_object_version_number);
486: --
487: if (l_api_updating
488: and p_acty_ref_perd_cd
489: <> nvl(ben_prv_shd.g_old_rec.acty_ref_perd_cd,hr_api.g_varchar2)
490: or not l_api_updating)
491: and p_acty_ref_perd_cd is not null then
492: --
493: -- check if value of lookup falls within lookup type.

Line 495: if hr_api.not_exists_in_hr_lookups

491: and p_acty_ref_perd_cd is not null then
492: --
493: -- check if value of lookup falls within lookup type.
494: --
495: if hr_api.not_exists_in_hr_lookups
496: (p_lookup_type => 'BEN_ACTY_REF_PERD',
497: p_lookup_code => p_acty_ref_perd_cd,
498: p_effective_date => p_effective_date) then
499: --

Line 559: <> nvl(ben_prv_shd.g_old_rec.mlt_cd,hr_api.g_varchar2)

555: p_object_version_number => p_object_version_number);
556: --
557: if (l_api_updating
558: and p_mlt_cd
559: <> nvl(ben_prv_shd.g_old_rec.mlt_cd,hr_api.g_varchar2)
560: or not l_api_updating)
561: and p_mlt_cd is not null then
562: --
563: -- check if value of lookup falls within lookup type.

Line 565: if hr_api.not_exists_in_hr_lookups

561: and p_mlt_cd is not null then
562: --
563: -- check if value of lookup falls within lookup type.
564: --
565: if hr_api.not_exists_in_hr_lookups
566: (p_lookup_type => 'BEN_MLT',
567: p_lookup_code => p_mlt_cd,
568: p_effective_date => p_effective_date) then
569: --

Line 629: <> nvl(ben_prv_shd.g_old_rec.acty_typ_cd,hr_api.g_varchar2)

625: p_object_version_number => p_object_version_number);
626: --
627: if (l_api_updating
628: and p_acty_typ_cd
629: <> nvl(ben_prv_shd.g_old_rec.acty_typ_cd,hr_api.g_varchar2)
630: or not l_api_updating)
631: and p_acty_typ_cd is not null then
632: --
633: -- check if value of lookup falls within lookup type.

Line 635: if hr_api.not_exists_in_hr_lookups

631: and p_acty_typ_cd is not null then
632: --
633: -- check if value of lookup falls within lookup type.
634: --
635: if hr_api.not_exists_in_hr_lookups
636: (p_lookup_type => 'BEN_ACTY_TYP',
637: p_lookup_code => p_acty_typ_cd,
638: p_effective_date => p_effective_date) then
639: --

Line 699: <> nvl(ben_prv_shd.g_old_rec.tx_typ_cd,hr_api.g_varchar2)

695: p_object_version_number => p_object_version_number);
696: --
697: if (l_api_updating
698: and p_tx_typ_cd
699: <> nvl(ben_prv_shd.g_old_rec.tx_typ_cd,hr_api.g_varchar2)
700: or not l_api_updating)
701: and p_tx_typ_cd is not null then
702: --
703: -- check if value of lookup falls within lookup type.

Line 705: if hr_api.not_exists_in_hr_lookups

701: and p_tx_typ_cd is not null then
702: --
703: -- check if value of lookup falls within lookup type.
704: --
705: if hr_api.not_exists_in_hr_lookups
706: (p_lookup_type => 'BEN_TX_TYP',
707: p_lookup_code => p_tx_typ_cd,
708: p_effective_date => p_effective_date) then
709: --

Line 769: <> nvl(ben_prv_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2)

765: p_object_version_number => p_object_version_number);
766: --
767: if (l_api_updating
768: and p_rt_typ_cd
769: <> nvl(ben_prv_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2)
770: or not l_api_updating)
771: and p_rt_typ_cd is not null then
772: --
773: -- check if value of lookup falls within lookup type.

Line 775: if hr_api.not_exists_in_hr_lookups

771: and p_rt_typ_cd is not null then
772: --
773: -- check if value of lookup falls within lookup type.
774: --
775: if hr_api.not_exists_in_hr_lookups
776: (p_lookup_type => 'BEN_RT_TYP',
777: p_lookup_code => p_rt_typ_cd,
778: p_effective_date => p_effective_date) then
779: --

Line 839: <> nvl(ben_prv_shd.g_old_rec.rt_ovridn_flag,hr_api.g_varchar2)

835: p_object_version_number => p_object_version_number);
836: --
837: if (l_api_updating
838: and p_rt_ovridn_flag
839: <> nvl(ben_prv_shd.g_old_rec.rt_ovridn_flag,hr_api.g_varchar2)
840: or not l_api_updating) then
841: --
842: -- check if value of lookup falls within lookup type.
843: --

Line 845: if hr_api.not_exists_in_hr_lookups

841: --
842: -- check if value of lookup falls within lookup type.
843: --
844: --
845: if hr_api.not_exists_in_hr_lookups
846: (p_lookup_type => 'YES_NO',
847: p_lookup_code => p_rt_ovridn_flag,
848: p_effective_date => p_effective_date) then
849: --

Line 909: <> nvl(ben_prv_shd.g_old_rec.dsply_on_enrt_flag,hr_api.g_varchar2)

905: p_object_version_number => p_object_version_number);
906: --
907: if (l_api_updating
908: and p_dsply_on_enrt_flag
909: <> nvl(ben_prv_shd.g_old_rec.dsply_on_enrt_flag,hr_api.g_varchar2)
910: or not l_api_updating) then
911: --
912: -- check if value of lookup falls within lookup type.
913: --

Line 915: if hr_api.not_exists_in_hr_lookups

911: --
912: -- check if value of lookup falls within lookup type.
913: --
914: --
915: if hr_api.not_exists_in_hr_lookups
916: (p_lookup_type => 'YES_NO',
917: p_lookup_code => p_dsply_on_enrt_flag,
918: p_effective_date => p_effective_date) then
919: --

Line 1035: <> nvl(ben_prv_shd.g_old_rec.ann_rt_val,hr_api.g_number)

1031: p_object_version_number => p_object_version_number);
1032: --
1033: If (l_api_updating
1034: and p_ann_rt_val
1035: <> nvl(ben_prv_shd.g_old_rec.ann_rt_val,hr_api.g_number)
1036: or not l_api_updating)
1037: and p_ann_rt_val is not null then
1038: --
1039: -- get the annual min max values from enrt_rt If enrt_rt_id is not NULL

Line 1283: <> nvl(ben_prv_shd.g_old_rec.rt_val,hr_api.g_number)

1279: p_object_version_number => p_object_version_number);
1280: --
1281: if (l_api_updating
1282: and p_rt_val
1283: <> nvl(ben_prv_shd.g_old_rec.rt_val,hr_api.g_number)
1284: or not l_api_updating)
1285: and p_rt_val is not null then
1286: --
1287: -- get the min max and incrt values from enrt_rt

Line 1464: <> nvl(ben_prv_shd.g_old_rec.acty_base_rt_id,hr_api.g_number)

1460: p_object_version_number => p_object_version_number);
1461: --
1462: if (l_api_updating
1463: and nvl(p_acty_base_rt_id,-1)
1464: <> nvl(ben_prv_shd.g_old_rec.acty_base_rt_id,hr_api.g_number)
1465: or not l_api_updating) then
1466:
1467: if p_acty_base_rt_id is not null then
1468: open c_abr;

Line 1559: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1555: /*
1556: --
1557: -- Call all supporting business operations
1558: --
1559: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1560: */
1561:
1562: if ben_manage_life_events.fonm = 'Y' then
1563: l_effective_date := ben_manage_life_events.g_fonm_rt_strt_dt;

Line 1693: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1689: /*
1690: --
1691: -- Call all supporting business operations
1692: --
1693: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1694: */
1695: if ben_manage_life_events.fonm = 'Y' then
1696: l_effective_date := ben_manage_life_events.g_fonm_rt_strt_dt;
1697: else

Line 1844: hr_api.mandatory_arg_error(p_api_name => l_proc,

1840: hr_utility.set_location('Entering:'|| l_proc, 10);
1841: --
1842: -- Ensure that all the mandatory parameter are not null
1843: --
1844: hr_api.mandatory_arg_error(p_api_name => l_proc,
1845: p_argument => 'prtt_rt_val_id',
1846: p_argument_value => p_prtt_rt_val_id);
1847: --
1848: open csr_leg_code;