DBA Data[Home] [Help]

APPS.BEN_SVA_BUS dependencies on HR_API

Line 54: and nvl(p_svc_area_id,hr_api.g_number)

50: p_svc_area_id => p_svc_area_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_svc_area_id,hr_api.g_number)
55: <> ben_sva_shd.g_old_rec.svc_area_id) then
56: --
57: -- raise error as PK has changed
58: --

Line 177: <> nvl(ben_sva_shd.g_old_rec.org_unit_prdct,hr_api.g_varchar2)

173: p_object_version_number => p_object_version_number);
174: --
175: if (l_api_updating
176: and p_org_unit_prdct
177: <> nvl(ben_sva_shd.g_old_rec.org_unit_prdct,hr_api.g_varchar2)
178: or not l_api_updating)
179: and p_org_unit_prdct is not null then
180: --
181: -- check if value of lookup falls within lookup type.

Line 183: if hr_api.not_exists_in_hr_lookups

179: and p_org_unit_prdct is not null then
180: --
181: -- check if value of lookup falls within lookup type.
182: --
183: if hr_api.not_exists_in_hr_lookups
184: (p_lookup_type => 'BEN_PRDCT',
185: p_lookup_code => p_org_unit_prdct,
186: p_effective_date => p_effective_date) then
187: --

Line 248: hr_api.mandatory_arg_error

244: hr_utility.set_location('Entering:'||l_proc, 5);
245: --
246: -- Ensure that the p_datetrack_mode argument is not null
247: --
248: hr_api.mandatory_arg_error
249: (p_api_name => l_proc,
250: p_argument => 'datetrack_mode',
251: p_argument_value => p_datetrack_mode);
252: --

Line 260: hr_api.mandatory_arg_error

256: --
257: --
258: -- Ensure the arguments are not null
259: --
260: hr_api.mandatory_arg_error
261: (p_api_name => l_proc,
262: p_argument => 'validation_start_date',
263: p_argument_value => p_validation_start_date);
264: --

Line 265: hr_api.mandatory_arg_error

261: (p_api_name => l_proc,
262: p_argument => 'validation_start_date',
263: p_argument_value => p_validation_start_date);
264: --
265: hr_api.mandatory_arg_error
266: (p_api_name => l_proc,
267: p_argument => 'validation_end_date',
268: p_argument_value => p_validation_end_date);
269: --

Line 343: hr_api.mandatory_arg_error

339: hr_utility.set_location('Entering:'||l_proc, 5);
340: --
341: -- Ensure that the p_datetrack_mode argument is not null
342: --
343: hr_api.mandatory_arg_error
344: (p_api_name => l_proc,
345: p_argument => 'datetrack_mode',
346: p_argument_value => p_datetrack_mode);
347: --

Line 357: hr_api.mandatory_arg_error

353: --
354: --
355: -- Ensure the arguments are not null
356: --
357: hr_api.mandatory_arg_error
358: (p_api_name => l_proc,
359: p_argument => 'validation_start_date',
360: p_argument_value => p_validation_start_date);
361: --

Line 362: hr_api.mandatory_arg_error

358: (p_api_name => l_proc,
359: p_argument => 'validation_start_date',
360: p_argument_value => p_validation_start_date);
361: --
362: hr_api.mandatory_arg_error
363: (p_api_name => l_proc,
364: p_argument => 'validation_end_date',
365: p_argument_value => p_validation_end_date);
366: --

Line 367: hr_api.mandatory_arg_error

363: (p_api_name => l_proc,
364: p_argument => 'validation_end_date',
365: p_argument_value => p_validation_end_date);
366: --
367: hr_api.mandatory_arg_error
368: (p_api_name => l_proc,
369: p_argument => 'svc_area_id',
370: p_argument_value => p_svc_area_id);
371: --

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

435: hr_utility.set_location('Entering:'||l_proc, 5);
436: --
437: -- Call all supporting business operations
438: --
439: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
440: --
441: chk_svc_area_id
442: (p_svc_area_id => p_rec.svc_area_id,
443: p_effective_date => p_effective_date,

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

473: hr_utility.set_location('Entering:'||l_proc, 5);
474: --
475: -- Call all supporting business operations
476: --
477: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
478: --
479: chk_svc_area_id
480: (p_svc_area_id => p_rec.svc_area_id,
481: p_effective_date => p_effective_date,

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

556: hr_utility.set_location('Entering:'|| l_proc, 10);
557: --
558: -- Ensure that all the mandatory parameter are not null
559: --
560: hr_api.mandatory_arg_error(p_api_name => l_proc,
561: p_argument => 'svc_area_id',
562: p_argument_value => p_svc_area_id);
563: --
564: open csr_leg_code;