APPS.BEN_PRR_BUS dependencies on HR_API

Line 55: and nvl(p_perf_rtng_rt_id,hr_api.g_number)

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

Line 125: <> nvl(ben_prr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

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

Line 131: if hr_api.not_exists_in_hr_lookups

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

Line 207: and nvl(p_event_type,hr_api.g_varchar2)

203: p_effective_date => p_effective_date,
204: p_object_version_number => p_object_version_number);
205: --
206: if (l_api_updating
207: and nvl(p_event_type,hr_api.g_varchar2)
208: <> nvl(ben_prr_shd.g_old_rec.event_type,hr_api.g_varchar2)
209: or not l_api_updating)
210: and p_event_type is not null
211: and p_event_type <> '-1' /* Bug 4031314 : Enter Event Type as -1, when user does not select it */

Line 208: <> nvl(ben_prr_shd.g_old_rec.event_type,hr_api.g_varchar2)

204: p_object_version_number => p_object_version_number);
205: --
206: if (l_api_updating
207: and nvl(p_event_type,hr_api.g_varchar2)
208: <> nvl(ben_prr_shd.g_old_rec.event_type,hr_api.g_varchar2)
209: or not l_api_updating)
210: and p_event_type is not null
211: and p_event_type <> '-1' /* Bug 4031314 : Enter Event Type as -1, when user does not select it */
212: then

Line 296: and nvl(p_perf_rtng_cd,hr_api.g_varchar2)

292: p_effective_date => p_effective_date,
293: p_object_version_number => p_object_version_number);
294: --
295: if (l_api_updating
296: and nvl(p_perf_rtng_cd,hr_api.g_varchar2)
297: <> nvl(ben_prr_shd.g_old_rec.perf_rtng_cd,hr_api.g_varchar2)
298: or not l_api_updating)
299: and p_perf_rtng_cd is not null then
300: --

Line 297: <> nvl(ben_prr_shd.g_old_rec.perf_rtng_cd,hr_api.g_varchar2)

293: p_object_version_number => p_object_version_number);
294: --
295: if (l_api_updating
296: and nvl(p_perf_rtng_cd,hr_api.g_varchar2)
297: <> nvl(ben_prr_shd.g_old_rec.perf_rtng_cd,hr_api.g_varchar2)
298: or not l_api_updating)
299: and p_perf_rtng_cd is not null then
300: --
301: -- check if event_type value exists in

Line 374: and prr.perf_rtng_rt_id <> nvl(p_perf_rtng_rt_id,hr_api.g_number)

370: from ben_perf_rtng_rt_f prr
371: where nvl(prr.event_type,-1) = nvl(p_event_type,-1)
372: and nvl(prr.perf_rtng_cd,-1) = nvl(p_perf_rtng_cd,-1)
373: and prr.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
374: and prr.perf_rtng_rt_id <> nvl(p_perf_rtng_rt_id,hr_api.g_number)
375: and prr.business_group_id = p_business_group_id
376: and p_validation_start_date <= prr.effective_end_date
377: and p_validation_end_date >= prr.effective_start_date;
378:

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

502: --
503: -- {End Of Comments}
504: -- ----------------------------------------------------------------------------
505: Procedure dt_update_validate
506: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
507: p_datetrack_mode in varchar2,
508: p_validation_start_date in date,
509: p_validation_end_date in date) Is
510: --

Line 520: hr_api.mandatory_arg_error

516: hr_utility.set_location('Entering:'||l_proc, 5);
517: --
518: -- Ensure that the p_datetrack_mode argument is not null
519: --
520: hr_api.mandatory_arg_error
521: (p_api_name => l_proc,
522: p_argument => 'datetrack_mode',
523: p_argument_value => p_datetrack_mode);
524: --

Line 532: hr_api.mandatory_arg_error

528: --
529: --
530: -- Ensure the arguments are not null
531: --
532: hr_api.mandatory_arg_error
533: (p_api_name => l_proc,
534: p_argument => 'validation_start_date',
535: p_argument_value => p_validation_start_date);
536: --

Line 537: hr_api.mandatory_arg_error

533: (p_api_name => l_proc,
534: p_argument => 'validation_start_date',
535: p_argument_value => p_validation_start_date);
536: --
537: hr_api.mandatory_arg_error
538: (p_api_name => l_proc,
539: p_argument => 'validation_end_date',
540: p_argument_value => p_validation_end_date);
541: --

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

538: (p_api_name => l_proc,
539: p_argument => 'validation_end_date',
540: p_argument_value => p_validation_end_date);
541: --
542: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
543: NOT (dt_api.check_min_max_dates
544: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
545: p_base_key_column => 'vrbl_rt_prfl_id',
546: p_base_key_value => p_vrbl_rt_prfl_id,

Line 625: hr_api.mandatory_arg_error

621: hr_utility.set_location('Entering:'||l_proc, 5);
622: --
623: -- Ensure that the p_datetrack_mode argument is not null
624: --
625: hr_api.mandatory_arg_error
626: (p_api_name => l_proc,
627: p_argument => 'datetrack_mode',
628: p_argument_value => p_datetrack_mode);
629: --

Line 639: hr_api.mandatory_arg_error

635: --
636: --
637: -- Ensure the arguments are not null
638: --
639: hr_api.mandatory_arg_error
640: (p_api_name => l_proc,
641: p_argument => 'validation_start_date',
642: p_argument_value => p_validation_start_date);
643: --

Line 644: hr_api.mandatory_arg_error

640: (p_api_name => l_proc,
641: p_argument => 'validation_start_date',
642: p_argument_value => p_validation_start_date);
643: --
644: hr_api.mandatory_arg_error
645: (p_api_name => l_proc,
646: p_argument => 'validation_end_date',
647: p_argument_value => p_validation_end_date);
648: --

Line 649: hr_api.mandatory_arg_error

645: (p_api_name => l_proc,
646: p_argument => 'validation_end_date',
647: p_argument_value => p_validation_end_date);
648: --
649: hr_api.mandatory_arg_error
650: (p_api_name => l_proc,
651: p_argument => 'perf_rtng_rt_id',
652: p_argument_value => p_perf_rtng_rt_id);
653: --

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

693: --
694: -- Call all supporting business operations
695: --
696: --
697: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
698: --
699: chk_perf_rtng_rt_id
700: (p_perf_rtng_rt_id => p_rec.perf_rtng_rt_id,
701: p_effective_date => p_effective_date,

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

760: --
761: -- Call all supporting business operations
762: --
763: --
764: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
765: --
766: chk_perf_rtng_rt_id
767: (p_perf_rtng_rt_id => p_rec.perf_rtng_rt_id,
768: p_effective_date => p_effective_date,

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

871: hr_utility.set_location('Entering:'|| l_proc, 10);
872: --
873: -- Ensure that all the mandatory parameter are not null
874: --
875: hr_api.mandatory_arg_error(p_api_name => l_proc,
876: p_argument => 'perf_rtng_rt_id',
877: p_argument_value => p_perf_rtng_rt_id);
878: --
879: open csr_leg_code;