[Home] [Help]
83: hr_utility.set_location('Entering:'|| l_proc, 10);
84: --
85: -- Ensure that all the mandatory parameter are not null
86: --
87: hr_api.mandatory_arg_error
88: (p_api_name => l_proc
89: ,p_argument => 'ext_rcd_id'
90: ,p_argument_value => p_ext_rcd_id
91: );
106: close csr_sec_grp;
107: --
108: -- Set the security_group_id in CLIENT_INFO
109: --
110: hr_api.set_security_group_id
111: (p_security_group_id => l_security_group_id
112: );
113: --
114: hr_utility.set_location(' Leaving:'|| l_proc, 20);
156: (p_ext_rcd_id => p_ext_rcd_id,
157: p_object_version_number => p_object_version_number);
158: --
159: if (l_api_updating
160: and nvl(p_ext_rcd_id,hr_api.g_number)
161: <> ben_xrc_shd.g_old_rec.ext_rcd_id) then
162: --
163: -- raise error as PK has changed
164: --
290: p_object_version_number => p_object_version_number);
291: --
292: if (l_api_updating
293: and p_rcd_type_cd
294: <> nvl(ben_xrc_shd.g_old_rec.rcd_type_cd,hr_api.g_varchar2)
295: or not l_api_updating)
296: and p_rcd_type_cd is not null then
297: --
298: -- check if value of lookup falls within lookup type.
298: -- check if value of lookup falls within lookup type.
299: --
300: if p_business_group_id is not null then
301: /* BG is set, so use the existing call, with no modifications*/
302: if hr_api.not_exists_in_hr_lookups
303: (p_lookup_type => 'BEN_EXT_RCD_TYP',
304: p_lookup_code => p_rcd_type_cd,
305: p_effective_date => p_effective_date) then
306: --
314: --
315: end if;
316: else
317: /* BG is null, so alternative call is required */
318: if hr_api.not_exists_in_hrstanlookups
319: (p_lookup_type => 'BEN_EXT_RCD_TYP',
320: p_lookup_code => p_rcd_type_cd,
321: p_effective_date => p_effective_date) then
322: --
381: p_object_version_number => p_object_version_number);
382: --
383: if (l_api_updating
384: and p_low_lvl_cd
385: <> nvl(ben_xrc_shd.g_old_rec.low_lvl_cd,hr_api.g_varchar2)
386: or not l_api_updating)
387: and p_low_lvl_cd is not null then
388: --
389: -- check if value of lookup falls within lookup type.
389: -- check if value of lookup falls within lookup type.
390: --
391: if p_business_group_id is not null then
392: /* BG is set, so use the existing call, with no modifications*/
393: if hr_api.not_exists_in_hr_lookups
394: (p_lookup_type => 'BEN_EXT_LVL',
395: p_lookup_code => p_low_lvl_cd,
396: p_effective_date => p_effective_date) then
397: --
405: --
406: end if;
407: else
408: /* BG is null, so alternative call is required */
409: if hr_api.not_exists_in_hrstanlookups
410: (p_lookup_type => 'BEN_EXT_LVL',
411: p_lookup_code => p_low_lvl_cd,
412: p_effective_date => p_effective_date) then
413: --
476: p_object_version_number => p_object_version_number);
477: --
478: if (l_api_updating
479: and p_rcd_type_cd
480: <> nvl(ben_xrc_shd.g_old_rec.rcd_type_cd,hr_api.g_varchar2)
481: or not l_api_updating)
482: and p_rcd_type_cd is not null then
483: --
484: -- check if value of lookup falls within lookup type.
532: chk_startup_action(True
533: ,p_rec.business_group_id
534: ,p_rec.legislation_code);
535: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
536: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp
537: END IF;
538: --
539: chk_ext_rcd_id
540: (p_ext_rcd_id => p_rec.ext_rcd_id,
580: chk_startup_action(False
581: ,p_rec.business_group_id
582: ,p_rec.legislation_code);
583: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
584: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp
585: END IF;
586: --
587: chk_ext_rcd_id
588: (p_ext_rcd_id => p_rec.ext_rcd_id,
663: hr_utility.set_location('Entering:'|| l_proc, 10);
664: --
665: -- Ensure that all the mandatory parameter are not null
666: --
667: hr_api.mandatory_arg_error(p_api_name => l_proc,
668: p_argument => 'ext_rcd_id',
669: p_argument_value => p_ext_rcd_id);
670: --
671: open csr_leg_code;