APPS.BEN_PAP_BUS dependencies on HR_API

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

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

Line 129: and prtt_anthr_pl_rt_id <> nvl(p_prtt_anthr_pl_rt_id,hr_api.g_number)

125: select null
126: from ben_prtt_anthr_pl_rt_f
127: where pl_id = p_pl_id
128: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
129: and prtt_anthr_pl_rt_id <> nvl(p_prtt_anthr_pl_rt_id,hr_api.g_number)
130: and business_group_id + 0 = p_business_group_id
131: and p_validation_start_date <= effective_end_date
132: and p_validation_end_date >= effective_start_date;
133: --

Line 144: and p_pl_id <> nvl(ben_pap_shd.g_old_rec.pl_id,hr_api.g_number)

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

Line 214: <> nvl(ben_pap_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

210: p_object_version_number => p_object_version_number);
211: --
212: if (l_api_updating
213: and p_excld_flag
214: <> nvl(ben_pap_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
215: or not l_api_updating) then
216: --
217: -- check if value of lookup falls within lookup type.
218: --

Line 220: if hr_api.not_exists_in_hr_lookups

216: --
217: -- check if value of lookup falls within lookup type.
218: --
219: --
220: if hr_api.not_exists_in_hr_lookups
221: (p_lookup_type => 'YES_NO',
222: p_lookup_code => p_excld_flag,
223: p_effective_date => p_effective_date) then
224: --

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

334: --
335: -- {End Of Comments}
336: -- ----------------------------------------------------------------------------
337: Procedure dt_update_validate
338: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
339: p_datetrack_mode in varchar2,
340: p_validation_start_date in date,
341: p_validation_end_date in date) Is
342: --

Line 352: hr_api.mandatory_arg_error

348: hr_utility.set_location('Entering:'||l_proc, 5);
349: --
350: -- Ensure that the p_datetrack_mode argument is not null
351: --
352: hr_api.mandatory_arg_error
353: (p_api_name => l_proc,
354: p_argument => 'datetrack_mode',
355: p_argument_value => p_datetrack_mode);
356: --

Line 364: hr_api.mandatory_arg_error

360: --
361: --
362: -- Ensure the arguments are not null
363: --
364: hr_api.mandatory_arg_error
365: (p_api_name => l_proc,
366: p_argument => 'validation_start_date',
367: p_argument_value => p_validation_start_date);
368: --

Line 369: hr_api.mandatory_arg_error

365: (p_api_name => l_proc,
366: p_argument => 'validation_start_date',
367: p_argument_value => p_validation_start_date);
368: --
369: hr_api.mandatory_arg_error
370: (p_api_name => l_proc,
371: p_argument => 'validation_end_date',
372: p_argument_value => p_validation_end_date);
373: --

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

370: (p_api_name => l_proc,
371: p_argument => 'validation_end_date',
372: p_argument_value => p_validation_end_date);
373: --
374: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
375: NOT (dt_api.check_min_max_dates
376: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
377: p_base_key_column => 'vrbl_rt_prfl_id',
378: p_base_key_value => p_vrbl_rt_prfl_id,

Line 458: hr_api.mandatory_arg_error

454: hr_utility.set_location('Entering:'||l_proc, 5);
455: --
456: -- Ensure that the p_datetrack_mode argument is not null
457: --
458: hr_api.mandatory_arg_error
459: (p_api_name => l_proc,
460: p_argument => 'datetrack_mode',
461: p_argument_value => p_datetrack_mode);
462: --

Line 472: hr_api.mandatory_arg_error

468: --
469: --
470: -- Ensure the arguments are not null
471: --
472: hr_api.mandatory_arg_error
473: (p_api_name => l_proc,
474: p_argument => 'validation_start_date',
475: p_argument_value => p_validation_start_date);
476: --

Line 477: hr_api.mandatory_arg_error

473: (p_api_name => l_proc,
474: p_argument => 'validation_start_date',
475: p_argument_value => p_validation_start_date);
476: --
477: hr_api.mandatory_arg_error
478: (p_api_name => l_proc,
479: p_argument => 'validation_end_date',
480: p_argument_value => p_validation_end_date);
481: --

Line 482: hr_api.mandatory_arg_error

478: (p_api_name => l_proc,
479: p_argument => 'validation_end_date',
480: p_argument_value => p_validation_end_date);
481: --
482: hr_api.mandatory_arg_error
483: (p_api_name => l_proc,
484: p_argument => 'prtt_anthr_pl_rt_id',
485: p_argument_value => p_prtt_anthr_pl_rt_id);
486: --

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

526: --
527: -- Call all supporting business operations
528: --
529: --
530: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
531: --
532: chk_prtt_anthr_pl_rt_id
533: (p_prtt_anthr_pl_rt_id => p_rec.prtt_anthr_pl_rt_id,
534: p_effective_date => p_effective_date,

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

579: --
580: -- Call all supporting business operations
581: --
582: --
583: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
584: --
585: chk_prtt_anthr_pl_rt_id
586: (p_prtt_anthr_pl_rt_id => p_rec.prtt_anthr_pl_rt_id,
587: p_effective_date => p_effective_date,

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

676: hr_utility.set_location('Entering:'|| l_proc, 10);
677: --
678: -- Ensure that all the mandatory parameter are not null
679: --
680: hr_api.mandatory_arg_error(p_api_name => l_proc,
681: p_argument => 'prtt_anthr_pl_rt_id',
682: p_argument_value => p_prtt_anthr_pl_rt_id);
683: --
684: open csr_leg_code;