APPS.BEN_PGR_BUS dependencies on HR_API

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

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

Line 128: and ppl_grp_rt_id <> nvl(p_ppl_grp_rt_id,hr_api.g_number)

124: select null
125: from ben_ppl_grp_rt_f
126: where people_group_id = p_people_group_id
127: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
128: and ppl_grp_rt_id <> nvl(p_ppl_grp_rt_id,hr_api.g_number)
129: and business_group_id + 0 = p_business_group_id
130: and p_validation_start_date <= effective_end_date
131: and p_validation_end_date >= effective_start_date;
132: --

Line 143: and p_people_group_id <> nvl(ben_pgr_shd.g_old_rec.people_group_id,hr_api.g_number)

139: p_effective_date => p_effective_date,
140: p_object_version_number => p_object_version_number);
141: --
142: if (l_api_updating
143: and p_people_group_id <> nvl(ben_pgr_shd.g_old_rec.people_group_id,hr_api.g_number)
144: or not l_api_updating) then
145:
146: open c_dup;
147: fetch c_dup into l_exists;

Line 270: <> nvl(ben_pgr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

266: p_object_version_number => p_object_version_number);
267: --
268: if (l_api_updating
269: and p_excld_flag
270: <> nvl(ben_pgr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
271: or not l_api_updating) then
272: --
273: -- check if value of lookup falls within lookup type.
274: --

Line 276: if hr_api.not_exists_in_hr_lookups

272: --
273: -- check if value of lookup falls within lookup type.
274: --
275: --
276: if hr_api.not_exists_in_hr_lookups
277: (p_lookup_type => 'YES_NO',
278: p_lookup_code => p_excld_flag,
279: p_effective_date => p_effective_date) then
280: --

Line 324: (p_vrbl_rt_prfl_id in number default hr_api.g_number,

320: --
321: -- {End Of Comments}
322: -- ----------------------------------------------------------------------------
323: Procedure dt_update_validate
324: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
325: p_datetrack_mode in varchar2,
326: p_validation_start_date in date,
327: p_validation_end_date in date) Is
328: --

Line 338: hr_api.mandatory_arg_error

334: hr_utility.set_location('Entering:'||l_proc, 5);
335: --
336: -- Ensure that the p_datetrack_mode argument is not null
337: --
338: hr_api.mandatory_arg_error
339: (p_api_name => l_proc,
340: p_argument => 'datetrack_mode',
341: p_argument_value => p_datetrack_mode);
342: --

Line 350: hr_api.mandatory_arg_error

346: --
347: --
348: -- Ensure the arguments are not null
349: --
350: hr_api.mandatory_arg_error
351: (p_api_name => l_proc,
352: p_argument => 'validation_start_date',
353: p_argument_value => p_validation_start_date);
354: --

Line 355: hr_api.mandatory_arg_error

351: (p_api_name => l_proc,
352: p_argument => 'validation_start_date',
353: p_argument_value => p_validation_start_date);
354: --
355: hr_api.mandatory_arg_error
356: (p_api_name => l_proc,
357: p_argument => 'validation_end_date',
358: p_argument_value => p_validation_end_date);
359: --

Line 360: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and

356: (p_api_name => l_proc,
357: p_argument => 'validation_end_date',
358: p_argument_value => p_validation_end_date);
359: --
360: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
361: NOT (dt_api.check_min_max_dates
362: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
363: p_base_key_column => 'vrbl_rt_prfl_id',
364: p_base_key_value => p_vrbl_rt_prfl_id,

Line 444: hr_api.mandatory_arg_error

440: hr_utility.set_location('Entering:'||l_proc, 5);
441: --
442: -- Ensure that the p_datetrack_mode argument is not null
443: --
444: hr_api.mandatory_arg_error
445: (p_api_name => l_proc,
446: p_argument => 'datetrack_mode',
447: p_argument_value => p_datetrack_mode);
448: --

Line 458: hr_api.mandatory_arg_error

454: --
455: --
456: -- Ensure the arguments are not null
457: --
458: hr_api.mandatory_arg_error
459: (p_api_name => l_proc,
460: p_argument => 'validation_start_date',
461: p_argument_value => p_validation_start_date);
462: --

Line 463: hr_api.mandatory_arg_error

459: (p_api_name => l_proc,
460: p_argument => 'validation_start_date',
461: p_argument_value => p_validation_start_date);
462: --
463: hr_api.mandatory_arg_error
464: (p_api_name => l_proc,
465: p_argument => 'validation_end_date',
466: p_argument_value => p_validation_end_date);
467: --

Line 468: hr_api.mandatory_arg_error

464: (p_api_name => l_proc,
465: p_argument => 'validation_end_date',
466: p_argument_value => p_validation_end_date);
467: --
468: hr_api.mandatory_arg_error
469: (p_api_name => l_proc,
470: p_argument => 'ppl_grp_rt_id',
471: p_argument_value => p_ppl_grp_rt_id);
472: --

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

512: --
513: -- Call all supporting business operations
514: --
515: --
516: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
517: --
518: chk_ppl_grp_rt_id
519: (p_ppl_grp_rt_id => p_rec.ppl_grp_rt_id,
520: p_effective_date => p_effective_date,

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

563: --
564: -- Call all supporting business operations
565: --
566: --
567: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
568: --
569: chk_ppl_grp_rt_id
570: (p_ppl_grp_rt_id => p_rec.ppl_grp_rt_id,
571: p_effective_date => p_effective_date,

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

658: hr_utility.set_location('Entering:'|| l_proc, 10);
659: --
660: -- Ensure that all the mandatory parameter are not null
661: --
662: hr_api.mandatory_arg_error(p_api_name => l_proc,
663: p_argument => 'ppl_grp_rt_id',
664: p_argument_value => p_ppl_grp_rt_id);
665: --
666: open csr_leg_code;