APPS.BEN_PST_BUS dependencies on HR_API

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

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

Line 132: and nvl(p_position_id,hr_api.g_number)

128: p_effective_date => p_effective_date,
129: p_object_version_number => p_object_version_number);
130: --
131: if (l_api_updating
132: and nvl(p_position_id,hr_api.g_number)
133: <> nvl(ben_pst_shd.g_old_rec.position_id,hr_api.g_number)
134: or not l_api_updating)
135: and p_position_id is not null then
136: --

Line 133: <> nvl(ben_pst_shd.g_old_rec.position_id,hr_api.g_number)

129: p_object_version_number => p_object_version_number);
130: --
131: if (l_api_updating
132: and nvl(p_position_id,hr_api.g_number)
133: <> nvl(ben_pst_shd.g_old_rec.position_id,hr_api.g_number)
134: or not l_api_updating)
135: and p_position_id is not null then
136: --
137: -- check if position_id value exists in

Line 212: and pstn_rt_id <> nvl(p_pstn_rt_id,hr_api.g_number)

208: select null
209: from ben_pstn_rt_f
210: where position_id = p_position_id
211: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
212: and pstn_rt_id <> nvl(p_pstn_rt_id,hr_api.g_number)
213: and business_group_id + 0 = p_business_group_id
214: and p_validation_start_date <= effective_end_date
215: and p_validation_end_date >= effective_start_date;
216: --

Line 227: and p_position_id <> nvl(ben_pst_shd.g_old_rec.position_id,hr_api.g_number)

223: p_effective_date => p_effective_date,
224: p_object_version_number => p_object_version_number);
225: --
226: if (l_api_updating
227: and p_position_id <> nvl(ben_pst_shd.g_old_rec.position_id,hr_api.g_number)
228: or not l_api_updating) then
229:
230: open c_dup;
231: fetch c_dup into l_exists;

Line 297: <> nvl(ben_pst_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

293: p_object_version_number => p_object_version_number);
294: --
295: if (l_api_updating
296: and p_excld_flag
297: <> nvl(ben_pst_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
298: or not l_api_updating) then
299: --
300: -- check if value of lookup falls within lookup type.
301: --

Line 303: if hr_api.not_exists_in_hr_lookups

299: --
300: -- check if value of lookup falls within lookup type.
301: --
302: --
303: if hr_api.not_exists_in_hr_lookups
304: (p_lookup_type => 'YES_NO',
305: p_lookup_code => p_excld_flag,
306: p_effective_date => p_effective_date) then
307: --

Line 423: p_vrbl_rt_prfl_id in number default hr_api.g_number,

419: -- {End Of Comments}
420: -- ----------------------------------------------------------------------------
421: Procedure dt_update_validate
422: (
423: p_vrbl_rt_prfl_id in number default hr_api.g_number,
424: p_position_id in number default hr_api.g_number,
425: p_datetrack_mode in varchar2,
426: p_validation_start_date in date,
427: p_validation_end_date in date) Is

Line 424: p_position_id in number default hr_api.g_number,

420: -- ----------------------------------------------------------------------------
421: Procedure dt_update_validate
422: (
423: p_vrbl_rt_prfl_id in number default hr_api.g_number,
424: p_position_id in number default hr_api.g_number,
425: p_datetrack_mode in varchar2,
426: p_validation_start_date in date,
427: p_validation_end_date in date) Is
428: --

Line 438: hr_api.mandatory_arg_error

434: hr_utility.set_location('Entering:'||l_proc, 5);
435: --
436: -- Ensure that the p_datetrack_mode argument is not null
437: --
438: hr_api.mandatory_arg_error
439: (p_api_name => l_proc,
440: p_argument => 'datetrack_mode',
441: p_argument_value => p_datetrack_mode);
442: --

Line 450: hr_api.mandatory_arg_error

446: --
447: --
448: -- Ensure the arguments are not null
449: --
450: hr_api.mandatory_arg_error
451: (p_api_name => l_proc,
452: p_argument => 'validation_start_date',
453: p_argument_value => p_validation_start_date);
454: --

Line 455: hr_api.mandatory_arg_error

451: (p_api_name => l_proc,
452: p_argument => 'validation_start_date',
453: p_argument_value => p_validation_start_date);
454: --
455: hr_api.mandatory_arg_error
456: (p_api_name => l_proc,
457: p_argument => 'validation_end_date',
458: p_argument_value => p_validation_end_date);
459: --

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

456: (p_api_name => l_proc,
457: p_argument => 'validation_end_date',
458: p_argument_value => p_validation_end_date);
459: --
460: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
461: NOT (dt_api.check_min_max_dates
462: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
463: p_base_key_column => 'vrbl_rt_prfl_id',
464: p_base_key_value => p_vrbl_rt_prfl_id,

Line 542: hr_api.mandatory_arg_error

538: hr_utility.set_location('Entering:'||l_proc, 5);
539: --
540: -- Ensure that the p_datetrack_mode argument is not null
541: --
542: hr_api.mandatory_arg_error
543: (p_api_name => l_proc,
544: p_argument => 'datetrack_mode',
545: p_argument_value => p_datetrack_mode);
546: --

Line 556: hr_api.mandatory_arg_error

552: --
553: --
554: -- Ensure the arguments are not null
555: --
556: hr_api.mandatory_arg_error
557: (p_api_name => l_proc,
558: p_argument => 'validation_start_date',
559: p_argument_value => p_validation_start_date);
560: --

Line 561: hr_api.mandatory_arg_error

557: (p_api_name => l_proc,
558: p_argument => 'validation_start_date',
559: p_argument_value => p_validation_start_date);
560: --
561: hr_api.mandatory_arg_error
562: (p_api_name => l_proc,
563: p_argument => 'validation_end_date',
564: p_argument_value => p_validation_end_date);
565: --

Line 566: hr_api.mandatory_arg_error

562: (p_api_name => l_proc,
563: p_argument => 'validation_end_date',
564: p_argument_value => p_validation_end_date);
565: --
566: hr_api.mandatory_arg_error
567: (p_api_name => l_proc,
568: p_argument => 'pstn_rt_id',
569: p_argument_value => p_pstn_rt_id);
570: --

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

644: ,p_validation_end_date => p_validation_end_date
645: ,p_business_group_id => p_rec.business_group_id);
646:
647: --
648: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
649: --
650: hr_utility.set_location(' Leaving:'||l_proc, 10);
651: End insert_validate;
652: --

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

703: ,p_validation_end_date => p_validation_end_date
704: ,p_business_group_id => p_rec.business_group_id);
705:
706: --
707: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
708: --
709: -- Call the datetrack update integrity operation
710: --
711: dt_update_validate

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

772: hr_utility.set_location('Entering:'|| l_proc, 10);
773: --
774: -- Ensure that all the mandatory parameter are not null
775: --
776: hr_api.mandatory_arg_error(p_api_name => l_proc,
777: p_argument => 'pstn_rt_id',
778: p_argument_value => p_pstn_rt_id);
779: --
780: open csr_leg_code;