DBA Data[Home] [Help]

APPS.BEN_TUR_BUS dependencies on HR_API

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

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

Line 183: <> nvl(ben_tur_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_tur_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 252: and tbco_use_rt_id <> nvl(p_tbco_use_rt_id,hr_api.g_number)

248: select null
249: from ben_tbco_use_rt_f
250: where uses_tbco_flag = p_uses_tbco_flag
251: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
252: and tbco_use_rt_id <> nvl(p_tbco_use_rt_id,hr_api.g_number)
253: and business_group_id + 0 = p_business_group_id
254: and p_validation_start_date <= effective_end_date
255: and p_validation_end_date >= effective_start_date;
256: -- end bug # 2452735

Line 268: <> nvl(ben_tur_shd.g_old_rec.uses_tbco_flag,hr_api.g_varchar2)

264: p_object_version_number => p_object_version_number);
265: --
266: if (l_api_updating
267: and p_uses_tbco_flag
268: <> nvl(ben_tur_shd.g_old_rec.uses_tbco_flag,hr_api.g_varchar2)
269: or not l_api_updating) then
270: --
271: -- check if value of lookup falls within lookup type.
272: --

Line 274: if hr_api.not_exists_in_hr_lookups

270: --
271: -- check if value of lookup falls within lookup type.
272: --
273: --
274: if hr_api.not_exists_in_hr_lookups
275: (p_lookup_type => 'TOBACCO_USER',
276: p_lookup_code => p_uses_tbco_flag,
277: p_effective_date => p_effective_date) then
278: --

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 457: hr_api.mandatory_arg_error

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

Line 471: hr_api.mandatory_arg_error

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

Line 476: hr_api.mandatory_arg_error

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

Line 481: hr_api.mandatory_arg_error

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

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

525: --
526: -- Call all supporting business operations
527: --
528: --
529: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
530: --
531: chk_tbco_use_rt_id
532: (p_tbco_use_rt_id => p_rec.tbco_use_rt_id,
533: p_effective_date => p_effective_date,

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

576: --
577: -- Call all supporting business operations
578: --
579: --
580: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
581: --
582: chk_tbco_use_rt_id
583: (p_tbco_use_rt_id => p_rec.tbco_use_rt_id,
584: p_effective_date => p_effective_date,

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

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