47: (p_yr_perd_id => p_yr_perd_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_yr_perd_id,hr_api.g_number)
52: <> ben_yrp_shd.g_old_rec.yr_perd_id) then
53: --
54: -- raise error as PK has changed
55: --
117: p_object_version_number => p_object_version_number);
118: --
119: if (l_api_updating
120: and p_perd_typ_cd
121: <> nvl(ben_yrp_shd.g_old_rec.perd_typ_cd,hr_api.g_varchar2)
122: or not l_api_updating)
123: and p_perd_typ_cd is not null then
124: --
125: -- check if value of lookup falls within lookup type.
123: and p_perd_typ_cd is not null then
124: --
125: -- check if value of lookup falls within lookup type.
126: --
127: if hr_api.not_exists_in_hr_lookups
128: (p_lookup_type => 'BEN_PERD_TYP',
129: p_lookup_code => p_perd_typ_cd,
130: p_effective_date => p_effective_date) then
131: --
187: p_object_version_number => p_object_version_number);
188: --
189: if (l_api_updating
190: and p_perd_tm_uom_cd
191: <> nvl(ben_yrp_shd.g_old_rec.perd_tm_uom_cd,hr_api.g_varchar2)
192: or not l_api_updating)
193: and p_perd_tm_uom_cd is not null then
194: --
195: -- check if value of lookup falls within lookup type.
193: and p_perd_tm_uom_cd is not null then
194: --
195: -- check if value of lookup falls within lookup type.
196: --
197: if hr_api.not_exists_in_hr_lookups
198: (p_lookup_type => 'BEN_TM_UOM',
199: p_lookup_code => p_perd_tm_uom_cd,
200: p_effective_date => p_effective_date) then
201: --
445: --
446: -- Call all supporting business operations
447: --
448: --
449: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
450: --
451: chk_yr_perd_id
452: (p_yr_perd_id => p_rec.yr_perd_id,
453: p_object_version_number => p_rec.object_version_number);
501: --
502: -- Call all supporting business operations
503: --
504: --
505: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
506: --
507: chk_yr_perd_id
508: (p_yr_perd_id => p_rec.yr_perd_id,
509: p_object_version_number => p_rec.object_version_number);
639: hr_utility.set_location('Entering:'|| l_proc, 10);
640: --
641: -- Ensure that all the mandatory parameter are not null
642: --
643: hr_api.mandatory_arg_error(p_api_name => l_proc,
644: p_argument => 'yr_perd_id',
645: p_argument_value => p_yr_perd_id);
646: --
647: open csr_leg_code;