DBA Data[Home] [Help]

APPS.BEN_GNR_BUS dependencies on HR_API

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

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

Line 183: <> nvl(ben_gnr_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_gnr_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 253: and gndr_rt_id <> nvl(p_gndr_rt_id,hr_api.g_number)

249: select null
250: from ben_gndr_rt_f
251: where gndr_cd = p_gndr_cd
252: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
253: and gndr_rt_id <> nvl(p_gndr_rt_id,hr_api.g_number)
254: and business_group_id + 0 = p_business_group_id
255: and p_validation_start_date <= effective_end_date
256: and p_validation_end_date >= effective_start_date;
257: -- end bug # 2452735

Line 269: <> nvl(ben_gnr_shd.g_old_rec.gndr_cd,hr_api.g_varchar2)

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

Line 275: if hr_api.not_exists_in_hr_lookups

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

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

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

Line 354: hr_api.mandatory_arg_error

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

Line 366: hr_api.mandatory_arg_error

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

Line 371: hr_api.mandatory_arg_error

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

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

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

Line 459: hr_api.mandatory_arg_error

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

Line 473: hr_api.mandatory_arg_error

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

Line 478: hr_api.mandatory_arg_error

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

Line 483: hr_api.mandatory_arg_error

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

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

527: --
528: -- Call all supporting business operations
529: --
530: --
531: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
532: --
533: chk_gndr_rt_id
534: (p_gndr_rt_id => p_rec.gndr_rt_id,
535: p_effective_date => p_effective_date,

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

578: --
579: -- Call all supporting business operations
580: --
581: --
582: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
583: --
584: chk_gndr_rt_id
585: (p_gndr_rt_id => p_rec.gndr_rt_id,
586: p_effective_date => p_effective_date,

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

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