APPS.BEN_WLR_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_wlr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_excld_flag
124: <> nvl(ben_wlr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
125: or not l_api_updating) then
126: --
127: -- check if value of lookup falls within lookup type.
128: --

Line 130: if hr_api.not_exists_in_hr_lookups

126: --
127: -- check if value of lookup falls within lookup type.
128: --
129: --
130: if hr_api.not_exists_in_hr_lookups
131: (p_lookup_type => 'YES_NO',
132: p_lookup_code => p_excld_flag,
133: p_effective_date => p_effective_date) then
134: --

Line 249: and wk_loc_rt_id <> nvl(p_wk_loc_rt_id,hr_api.g_number)

245: select null
246: from ben_wk_loc_rt_f
247: where location_id = p_location_id
248: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
249: and wk_loc_rt_id <> nvl(p_wk_loc_rt_id,hr_api.g_number)
250: and business_group_id + 0 = p_business_group_id
251: and p_validation_start_date <= effective_end_date
252: and p_validation_end_date >= effective_start_date;
253: --

Line 264: and p_location_id <> nvl(ben_wlr_shd.g_old_rec.location_id,hr_api.g_number)

260: p_effective_date => p_effective_date,
261: p_object_version_number => p_object_version_number);
262: --
263: if (l_api_updating
264: and p_location_id <> nvl(ben_wlr_shd.g_old_rec.location_id,hr_api.g_number)
265: or not l_api_updating) then
266:
267: open c_dup;
268: fetch c_dup into l_exists;

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

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

Line 402: hr_api.mandatory_arg_error

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

Line 414: hr_api.mandatory_arg_error

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

Line 419: hr_api.mandatory_arg_error

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

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

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

Line 507: hr_api.mandatory_arg_error

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

Line 521: hr_api.mandatory_arg_error

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

Line 526: hr_api.mandatory_arg_error

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

Line 531: hr_api.mandatory_arg_error

527: (p_api_name => l_proc,
528: p_argument => 'validation_end_date',
529: p_argument_value => p_validation_end_date);
530: --
531: hr_api.mandatory_arg_error
532: (p_api_name => l_proc,
533: p_argument => 'wk_loc_rt_id',
534: p_argument_value => p_wk_loc_rt_id);
535: --

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

575: --
576: -- Call all supporting business operations
577: --
578: --
579: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
580: --
581: chk_wk_loc_rt_id
582: (p_wk_loc_rt_id => p_rec.wk_loc_rt_id,
583: p_effective_date => p_effective_date,

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

633: --
634: -- Call all supporting business operations
635: --
636: --
637: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
638: --
639: chk_wk_loc_rt_id
640: (p_wk_loc_rt_id => p_rec.wk_loc_rt_id,
641: p_effective_date => p_effective_date,

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

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