DBA Data[Home] [Help]

APPS.BEN_XRD_BUS dependencies on HR_API

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

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

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

124: (p_ext_rslt_dtl_id => p_ext_rslt_dtl_id,
125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating
128: and nvl(p_person_id,hr_api.g_number)
129: <> nvl(ben_xrd_shd.g_old_rec.person_id,hr_api.g_number)
130: or not l_api_updating) then
131: --
132: -- check if person_id value exists in per_all_people_f table

Line 129: <> nvl(ben_xrd_shd.g_old_rec.person_id,hr_api.g_number)

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

Line 203: and nvl(p_ext_rcd_id,hr_api.g_number)

199: (p_ext_rslt_dtl_id => p_ext_rslt_dtl_id,
200: p_object_version_number => p_object_version_number);
201: --
202: if (l_api_updating
203: and nvl(p_ext_rcd_id,hr_api.g_number)
204: <> nvl(ben_xrd_shd.g_old_rec.ext_rcd_id,hr_api.g_number)
205: or not l_api_updating) then
206: --
207: -- check if ext_rcd_id value exists in ben_ext_rcd table

Line 204: <> nvl(ben_xrd_shd.g_old_rec.ext_rcd_id,hr_api.g_number)

200: p_object_version_number => p_object_version_number);
201: --
202: if (l_api_updating
203: and nvl(p_ext_rcd_id,hr_api.g_number)
204: <> nvl(ben_xrd_shd.g_old_rec.ext_rcd_id,hr_api.g_number)
205: or not l_api_updating) then
206: --
207: -- check if ext_rcd_id value exists in ben_ext_rcd table
208: --

Line 257: and nvl(p_ext_rcd_in_file_id,hr_api.g_number)

253: (p_ext_rslt_dtl_id => p_ext_rslt_dtl_id,
254: p_object_version_number => p_object_version_number);
255: --
256: if (l_api_updating
257: and nvl(p_ext_rcd_in_file_id,hr_api.g_number)
258: <> nvl(ben_xrd_shd.g_old_rec.ext_rcd_in_file_id,hr_api.g_number)
259: or not l_api_updating) and p_ext_rcd_in_file_id is not null then
260: --
261: -- check if ext_rcd_id value exists in ben_ext_rcd table

Line 258: <> nvl(ben_xrd_shd.g_old_rec.ext_rcd_in_file_id,hr_api.g_number)

254: p_object_version_number => p_object_version_number);
255: --
256: if (l_api_updating
257: and nvl(p_ext_rcd_in_file_id,hr_api.g_number)
258: <> nvl(ben_xrd_shd.g_old_rec.ext_rcd_in_file_id,hr_api.g_number)
259: or not l_api_updating) and p_ext_rcd_in_file_id is not null then
260: --
261: -- check if ext_rcd_id value exists in ben_ext_rcd table
262: --

Line 335: and nvl(p_ext_rslt_id,hr_api.g_number)

331: (p_ext_rslt_dtl_id => p_ext_rslt_dtl_id,
332: p_object_version_number => p_object_version_number);
333: --
334: if (l_api_updating
335: and nvl(p_ext_rslt_id,hr_api.g_number)
336: <> nvl(ben_xrd_shd.g_old_rec.ext_rslt_id,hr_api.g_number)
337: or not l_api_updating) then
338: --
339: -- check if ext_rslt_id value exists in ben_ext_rslt table

Line 336: <> nvl(ben_xrd_shd.g_old_rec.ext_rslt_id,hr_api.g_number)

332: p_object_version_number => p_object_version_number);
333: --
334: if (l_api_updating
335: and nvl(p_ext_rslt_id,hr_api.g_number)
336: <> nvl(ben_xrd_shd.g_old_rec.ext_rslt_id,hr_api.g_number)
337: or not l_api_updating) then
338: --
339: -- check if ext_rslt_id value exists in ben_ext_rslt table
340: --

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

372: --
373: -- Call all supporting business operations
374: --
375: --
376: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
377: --
378: if p_rec.ext_per_bg_id is not null then
379: hr_api.validate_bus_grp_id(p_rec.ext_per_bg_id); -- Validate Bus Grp
380: end if ;

Line 379: hr_api.validate_bus_grp_id(p_rec.ext_per_bg_id); -- Validate Bus Grp

375: --
376: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
377: --
378: if p_rec.ext_per_bg_id is not null then
379: hr_api.validate_bus_grp_id(p_rec.ext_per_bg_id); -- Validate Bus Grp
380: end if ;
381:
382: chk_ext_rslt_dtl_id
383: (p_ext_rslt_dtl_id => p_rec.ext_rslt_dtl_id,

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

414: --
415: -- Call all supporting business operations
416: --
417: --
418: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
419: if p_rec.ext_per_bg_id is not null then
420: hr_api.validate_bus_grp_id(p_rec.ext_per_bg_id); -- Validate Bus Grp
421: end if ;
422: --

Line 420: hr_api.validate_bus_grp_id(p_rec.ext_per_bg_id); -- Validate Bus Grp

416: --
417: --
418: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
419: if p_rec.ext_per_bg_id is not null then
420: hr_api.validate_bus_grp_id(p_rec.ext_per_bg_id); -- Validate Bus Grp
421: end if ;
422: --
423: chk_ext_rslt_dtl_id
424: (p_ext_rslt_dtl_id => p_rec.ext_rslt_dtl_id,

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

485: hr_utility.set_location('Entering:'|| l_proc, 10);
486: --
487: -- Ensure that all the mandatory parameter are not null
488: --
489: hr_api.mandatory_arg_error(p_api_name => l_proc,
490: p_argument => 'ext_rslt_dtl_id',
491: p_argument_value => p_ext_rslt_dtl_id);
492: --
493: open csr_leg_code;