APPS.BEN_WYP_BUS dependencies on HR_API

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

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

Line 123: and nvl(p_yr_perd_id,hr_api.g_number)

119: (p_wthn_yr_perd_id => p_wthn_yr_perd_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_yr_perd_id,hr_api.g_number)
124: <> nvl(ben_wyp_shd.g_old_rec.yr_perd_id,hr_api.g_number)
125: or not l_api_updating) and
126: p_yr_perd_id is not null then
127: --

Line 124: <> nvl(ben_wyp_shd.g_old_rec.yr_perd_id,hr_api.g_number)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_yr_perd_id,hr_api.g_number)
124: <> nvl(ben_wyp_shd.g_old_rec.yr_perd_id,hr_api.g_number)
125: or not l_api_updating) and
126: p_yr_perd_id is not null then
127: --
128: -- check if yr_perd_id value exists in ben_yr_perd table

Line 516: and wthn_yr_perd_id <> nvl(p_wthn_yr_perd_id, hr_api.g_number)

512: select strt_day, strt_mo, end_day, end_mo
513: from ben_wthn_yr_perd
514: where tm_uom = p_tm_uom
515: and yr_perd_id = p_yr_perd_id
516: and wthn_yr_perd_id <> nvl(p_wthn_yr_perd_id, hr_api.g_number)
517: and business_group_id + 0 = p_business_group_id;
518: --
519: Begin
520: --

Line 662: and wthn_yr_perd_id <> nvl(p_wthn_yr_perd_id, hr_api.g_number)

658: and strt_day = p_strt_day
659: and strt_mo = p_strt_mo
660: and end_day = p_end_day
661: and end_mo = p_end_mo
662: and wthn_yr_perd_id <> nvl(p_wthn_yr_perd_id, hr_api.g_number)
663: and business_group_id + 0 = p_business_group_id;
664: --
665: Begin
666: --

Line 736: <> nvl(ben_wyp_shd.g_old_rec.tm_uom,hr_api.g_varchar2)

732: p_object_version_number => p_object_version_number);
733: --
734: if (l_api_updating
735: and p_tm_uom
736: <> nvl(ben_wyp_shd.g_old_rec.tm_uom,hr_api.g_varchar2)
737: or not l_api_updating)
738: and p_tm_uom is not null then
739: --
740: -- check if value of lookup falls within lookup type.

Line 742: if hr_api.not_exists_in_hr_lookups

738: and p_tm_uom is not null then
739: --
740: -- check if value of lookup falls within lookup type.
741: --
742: if hr_api.not_exists_in_hr_lookups
743: (p_lookup_type => 'BEN_TM_UOM',
744: p_lookup_code => p_tm_uom,
745: p_effective_date => p_effective_date) then
746: --

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

872: --
873: -- Call all supporting business operations
874: --
875: --
876: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
877: --
878: chk_wthn_yr_perd_id
879: (p_wthn_yr_perd_id => p_rec.wthn_yr_perd_id,
880: p_object_version_number => p_rec.object_version_number);

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

960: --
961: -- Call all supporting business operations
962: --
963: --
964: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
965: --
966: chk_wthn_yr_perd_id
967: (p_wthn_yr_perd_id => p_rec.wthn_yr_perd_id,
968: p_object_version_number => p_rec.object_version_number);

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

1076: hr_utility.set_location('Entering:'|| l_proc, 10);
1077: --
1078: -- Ensure that all the mandatory parameter are not null
1079: --
1080: hr_api.mandatory_arg_error(p_api_name => l_proc,
1081: p_argument => 'wthn_yr_perd_id',
1082: p_argument_value => p_wthn_yr_perd_id);
1083: --
1084: open csr_leg_code;