DBA Data[Home] [Help]

APPS.BEN_DBR_BUS dependencies on HR_API

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

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

Line 183: <> nvl(ben_dbr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

179: p_object_version_number => p_object_version_number);
180: --
181: if (l_api_updating
182: and p_excld_flag
183: <> nvl(ben_dbr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
184: or not l_api_updating) then
185: --
186: -- check if value of lookup falls within lookup type.
187: --

Line 189: if hr_api.not_exists_in_hr_lookups

185: --
186: -- check if value of lookup falls within lookup type.
187: --
188: --
189: if hr_api.not_exists_in_hr_lookups
190: (p_lookup_type => 'YES_NO',
191: p_lookup_code => p_excld_flag,
192: p_effective_date => p_effective_date) then
193: --

Line 254: and dsbld_rt_id <> nvl(p_dsbld_rt_id,hr_api.g_number)

250: select null
251: from ben_dsbld_rt_f
252: where dsbld_cd = p_dsbld_cd
253: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
254: and dsbld_rt_id <> nvl(p_dsbld_rt_id,hr_api.g_number)
255: and business_group_id + 0 = p_business_group_id
256: and p_validation_start_date <= effective_end_date
257: and p_validation_end_date >= effective_start_date;
258: -- end bug # 2452735

Line 270: <> nvl(ben_dbr_shd.g_old_rec.dsbld_cd,hr_api.g_varchar2)

266: p_object_version_number => p_object_version_number);
267: --
268: if (l_api_updating
269: and p_dsbld_cd
270: <> nvl(ben_dbr_shd.g_old_rec.dsbld_cd,hr_api.g_varchar2)
271: or not l_api_updating) then
272: --
273: -- check if value of lookup falls within lookup type.
274: --

Line 276: if hr_api.not_exists_in_hr_lookups

272: --
273: -- check if value of lookup falls within lookup type.
274: --
275: --
276: if hr_api.not_exists_in_hr_lookups
277: (p_lookup_type => 'REGISTERED_DISABLED',
278: p_lookup_code => p_dsbld_cd,
279: p_effective_date => p_effective_date) then
280: --

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

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

Line 355: hr_api.mandatory_arg_error

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

Line 367: hr_api.mandatory_arg_error

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

Line 372: hr_api.mandatory_arg_error

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

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

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

Line 460: hr_api.mandatory_arg_error

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

Line 474: hr_api.mandatory_arg_error

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

Line 479: hr_api.mandatory_arg_error

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

Line 484: hr_api.mandatory_arg_error

480: (p_api_name => l_proc,
481: p_argument => 'validation_end_date',
482: p_argument_value => p_validation_end_date);
483: --
484: hr_api.mandatory_arg_error
485: (p_api_name => l_proc,
486: p_argument => 'dsbld_rt_id',
487: p_argument_value => p_dsbld_rt_id);
488: --

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

527: hr_utility.set_location('Entering:'||l_proc, 5);
528: --
529: -- Call all supporting business operations
530: --
531: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
532: --
533: chk_dsbld_rt_id
534: (p_dsbld_rt_id => p_rec.dsbld_rt_id,
535: p_effective_date => p_effective_date,

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

577: hr_utility.set_location('Entering:'||l_proc, 5);
578: --
579: -- Call all supporting business operations
580: --
581: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
582: --
583: chk_dsbld_rt_id
584: (p_dsbld_rt_id => p_rec.dsbld_rt_id,
585: p_effective_date => p_effective_date,

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

672: hr_utility.set_location('Entering:'|| l_proc, 10);
673: --
674: -- Ensure that all the mandatory parameter are not null
675: --
676: hr_api.mandatory_arg_error(p_api_name => l_proc,
677: p_argument => 'dsbld_rt_id',
678: p_argument_value => p_dsbld_rt_id);
679: --
680: open csr_leg_code;