47: (p_ext_rslt_id => p_ext_rslt_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_ext_rslt_id,hr_api.g_number)
52: <> ben_xrs_shd.g_old_rec.ext_rslt_id) then
53: --
54: -- raise error as PK has changed
55: --
119: (p_ext_rslt_id => p_ext_rslt_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_ext_dfn_id,hr_api.g_number)
124: <> nvl(ben_xrs_shd.g_old_rec.ext_dfn_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if ext_dfn_id value exists in ben_ext_dfn table
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_ext_dfn_id,hr_api.g_number)
124: <> nvl(ben_xrs_shd.g_old_rec.ext_dfn_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if ext_dfn_id value exists in ben_ext_dfn table
128: --
191: p_object_version_number => p_object_version_number);
192: --
193: if (l_api_updating
194: and p_ext_stat_cd
195: <> nvl(ben_xrs_shd.g_old_rec.ext_stat_cd,hr_api.g_varchar2)
196: or not l_api_updating)
197: and p_ext_stat_cd is not null then
198: --
199: -- check if value of lookup falls within lookup type.
197: and p_ext_stat_cd is not null then
198: --
199: -- check if value of lookup falls within lookup type.
200: --
201: if hr_api.not_exists_in_hr_lookups
202: (p_lookup_type => 'BEN_EXT_STAT',
203: p_lookup_code => p_ext_stat_cd,
204: p_effective_date => p_effective_date) then
205: --
321: --
322: -- Call all supporting business operations
323: --
324: --
325: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
326: --
327: chk_ext_rslt_id
328: (p_ext_rslt_id => p_rec.ext_rslt_id,
329: p_object_version_number => p_rec.object_version_number);
366: --
367: -- Call all supporting business operations
368: --
369: --
370: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
371: --
372: chk_ext_rslt_id
373: (p_ext_rslt_id => p_rec.ext_rslt_id,
374: p_object_version_number => p_rec.object_version_number);
439: hr_utility.set_location('Entering:'|| l_proc, 10);
440: --
441: -- Ensure that all the mandatory parameter are not null
442: --
443: hr_api.mandatory_arg_error(p_api_name => l_proc,
444: p_argument => 'ext_rslt_id',
445: p_argument_value => p_ext_rslt_id);
446: --
447: open csr_leg_code;