APPS.BEN_GRR_BUS dependencies on HR_API

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

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

Line 187: and grade_rt_id <> nvl(p_grade_rt_id,hr_api.g_number)

183: select null
184: from ben_grade_rt_f
185: where grade_id = p_grade_id
186: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
187: and grade_rt_id <> nvl(p_grade_rt_id,hr_api.g_number)
188: and business_group_id + 0 = p_business_group_id
189: and p_validation_start_date <= effective_end_date
190: and p_validation_end_date >= effective_start_date;
191: --

Line 202: and p_grade_id <> nvl(ben_grr_shd.g_old_rec.grade_id,hr_api.g_number)

198: p_effective_date => p_effective_date,
199: p_object_version_number => p_object_version_number);
200: --
201: if (l_api_updating
202: and p_grade_id <> nvl(ben_grr_shd.g_old_rec.grade_id,hr_api.g_number)
203: or not l_api_updating) then
204:
205: open c_dup;
206: fetch c_dup into l_exists;

Line 337: <> nvl(ben_grr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

333: p_object_version_number => p_object_version_number);
334: --
335: if (l_api_updating
336: and p_excld_flag
337: <> nvl(ben_grr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
338: or not l_api_updating) then
339: --
340: -- check if value of lookup falls within lookup type.
341: --

Line 343: if hr_api.not_exists_in_hr_lookups

339: --
340: -- check if value of lookup falls within lookup type.
341: --
342: --
343: if hr_api.not_exists_in_hr_lookups
344: (p_lookup_type => 'YES_NO',
345: p_lookup_code => p_excld_flag,
346: p_effective_date => p_effective_date) then
347: --

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

387: --
388: -- {End Of Comments}
389: -- ----------------------------------------------------------------------------
390: Procedure dt_update_validate
391: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
392: p_datetrack_mode in varchar2,
393: p_validation_start_date in date,
394: p_validation_end_date in date) Is
395: --

Line 405: hr_api.mandatory_arg_error

401: hr_utility.set_location('Entering:'||l_proc, 5);
402: --
403: -- Ensure that the p_datetrack_mode argument is not null
404: --
405: hr_api.mandatory_arg_error
406: (p_api_name => l_proc,
407: p_argument => 'datetrack_mode',
408: p_argument_value => p_datetrack_mode);
409: --

Line 417: hr_api.mandatory_arg_error

413: --
414: --
415: -- Ensure the arguments are not null
416: --
417: hr_api.mandatory_arg_error
418: (p_api_name => l_proc,
419: p_argument => 'validation_start_date',
420: p_argument_value => p_validation_start_date);
421: --

Line 422: hr_api.mandatory_arg_error

418: (p_api_name => l_proc,
419: p_argument => 'validation_start_date',
420: p_argument_value => p_validation_start_date);
421: --
422: hr_api.mandatory_arg_error
423: (p_api_name => l_proc,
424: p_argument => 'validation_end_date',
425: p_argument_value => p_validation_end_date);
426: --

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

423: (p_api_name => l_proc,
424: p_argument => 'validation_end_date',
425: p_argument_value => p_validation_end_date);
426: --
427: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
428: NOT (dt_api.check_min_max_dates
429: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
430: p_base_key_column => 'vrbl_rt_prfl_id',
431: p_base_key_value => p_vrbl_rt_prfl_id,

Line 510: hr_api.mandatory_arg_error

506: hr_utility.set_location('Entering:'||l_proc, 5);
507: --
508: -- Ensure that the p_datetrack_mode argument is not null
509: --
510: hr_api.mandatory_arg_error
511: (p_api_name => l_proc,
512: p_argument => 'datetrack_mode',
513: p_argument_value => p_datetrack_mode);
514: --

Line 524: hr_api.mandatory_arg_error

520: --
521: --
522: -- Ensure the arguments are not null
523: --
524: hr_api.mandatory_arg_error
525: (p_api_name => l_proc,
526: p_argument => 'validation_start_date',
527: p_argument_value => p_validation_start_date);
528: --

Line 529: hr_api.mandatory_arg_error

525: (p_api_name => l_proc,
526: p_argument => 'validation_start_date',
527: p_argument_value => p_validation_start_date);
528: --
529: hr_api.mandatory_arg_error
530: (p_api_name => l_proc,
531: p_argument => 'validation_end_date',
532: p_argument_value => p_validation_end_date);
533: --

Line 534: hr_api.mandatory_arg_error

530: (p_api_name => l_proc,
531: p_argument => 'validation_end_date',
532: p_argument_value => p_validation_end_date);
533: --
534: hr_api.mandatory_arg_error
535: (p_api_name => l_proc,
536: p_argument => 'grade_rt_id',
537: p_argument_value => p_grade_rt_id);
538: --

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

578: --
579: -- Call all supporting business operations
580: --
581: --
582: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
583: --
584: chk_grade_rt_id
585: (p_grade_rt_id => p_rec.grade_rt_id,
586: p_effective_date => p_effective_date,

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

634: --
635: -- Call all supporting business operations
636: --
637: --
638: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
639: --
640: chk_grade_rt_id
641: (p_grade_rt_id => p_rec.grade_rt_id,
642: p_effective_date => p_effective_date,

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

734: hr_utility.set_location('Entering:'|| l_proc, 10);
735: --
736: -- Ensure that all the mandatory parameter are not null
737: --
738: hr_api.mandatory_arg_error(p_api_name => l_proc,
739: p_argument => 'grade_rt_id',
740: p_argument_value => p_grade_rt_id);
741: --
742: open csr_leg_code;