DBA Data[Home] [Help]

APPS.BEN_PTR_BUS dependencies on HR_API

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

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

Line 131: and per_typ_rt_id <> nvl(p_per_typ_rt_id,hr_api.g_number)

127: select null
128: from ben_per_typ_rt_f
129: where person_type_id = p_person_type_id
130: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
131: and per_typ_rt_id <> nvl(p_per_typ_rt_id,hr_api.g_number)
132: and business_group_id + 0 = p_business_group_id
133: and p_validation_start_date <= effective_end_date
134: and p_validation_end_date >= effective_start_date;
135: -- end bug # 2375772

Line 153: <> nvl(ben_ptr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

149: -- person types.
150: --
151: /* if (l_api_updating
152: and p_per_typ_cd
153: <> nvl(ben_ptr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
154: or not l_api_updating) then */
155: if (l_api_updating
156: and p_person_type_id
157: <> nvl(ben_ptr_shd.g_old_rec.person_type_id,hr_api.g_number)

Line 157: <> nvl(ben_ptr_shd.g_old_rec.person_type_id,hr_api.g_number)

153: <> nvl(ben_ptr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
154: or not l_api_updating) then */
155: if (l_api_updating
156: and p_person_type_id
157: <> nvl(ben_ptr_shd.g_old_rec.person_type_id,hr_api.g_number)
158: or not l_api_updating) then
159: --
160: -- check if value of lookup falls within lookup type.
161: -- As part of Bug 1631182 decided not to support per_typ_cd

Line 165: /*if hr_api.not_exists_in_hr_lookups

161: -- As part of Bug 1631182 decided not to support per_typ_cd
162: -- So using a cursor insted of hr_lookups
163: open c_person_type_id;
164: fetch c_person_type_id into l_person_type_id;
165: /*if hr_api.not_exists_in_hr_lookups
166: (p_lookup_type => 'PERSON_TYPE',
167: p_lookup_code => p_per_typ_cd,
168: p_effective_date => p_effective_date) then */
169: if c_person_type_id%notfound then

Line 308: <> nvl(ben_ptr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

304: p_object_version_number => p_object_version_number);
305: --
306: if (l_api_updating
307: and p_excld_flag
308: <> nvl(ben_ptr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
309: or not l_api_updating) then
310: --
311: -- check if value of lookup falls within lookup type.
312: --

Line 314: if hr_api.not_exists_in_hr_lookups

310: --
311: -- check if value of lookup falls within lookup type.
312: --
313: --
314: if hr_api.not_exists_in_hr_lookups
315: (p_lookup_type => 'YES_NO',
316: p_lookup_code => p_excld_flag,
317: p_effective_date => p_effective_date) then
318: --

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

358: --
359: -- {End Of Comments}
360: -- ----------------------------------------------------------------------------
361: Procedure dt_update_validate
362: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
363: p_datetrack_mode in varchar2,
364: p_validation_start_date in date,
365: p_validation_end_date in date) Is
366: --

Line 376: hr_api.mandatory_arg_error

372: hr_utility.set_location('Entering:'||l_proc, 5);
373: --
374: -- Ensure that the p_datetrack_mode argument is not null
375: --
376: hr_api.mandatory_arg_error
377: (p_api_name => l_proc,
378: p_argument => 'datetrack_mode',
379: p_argument_value => p_datetrack_mode);
380: --

Line 388: hr_api.mandatory_arg_error

384: --
385: --
386: -- Ensure the arguments are not null
387: --
388: hr_api.mandatory_arg_error
389: (p_api_name => l_proc,
390: p_argument => 'validation_start_date',
391: p_argument_value => p_validation_start_date);
392: --

Line 393: hr_api.mandatory_arg_error

389: (p_api_name => l_proc,
390: p_argument => 'validation_start_date',
391: p_argument_value => p_validation_start_date);
392: --
393: hr_api.mandatory_arg_error
394: (p_api_name => l_proc,
395: p_argument => 'validation_end_date',
396: p_argument_value => p_validation_end_date);
397: --

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

394: (p_api_name => l_proc,
395: p_argument => 'validation_end_date',
396: p_argument_value => p_validation_end_date);
397: --
398: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
399: NOT (dt_api.check_min_max_dates
400: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
401: p_base_key_column => 'vrbl_rt_prfl_id',
402: p_base_key_value => p_vrbl_rt_prfl_id,

Line 481: hr_api.mandatory_arg_error

477: hr_utility.set_location('Entering:'||l_proc, 5);
478: --
479: -- Ensure that the p_datetrack_mode argument is not null
480: --
481: hr_api.mandatory_arg_error
482: (p_api_name => l_proc,
483: p_argument => 'datetrack_mode',
484: p_argument_value => p_datetrack_mode);
485: --

Line 495: hr_api.mandatory_arg_error

491: --
492: --
493: -- Ensure the arguments are not null
494: --
495: hr_api.mandatory_arg_error
496: (p_api_name => l_proc,
497: p_argument => 'validation_start_date',
498: p_argument_value => p_validation_start_date);
499: --

Line 500: hr_api.mandatory_arg_error

496: (p_api_name => l_proc,
497: p_argument => 'validation_start_date',
498: p_argument_value => p_validation_start_date);
499: --
500: hr_api.mandatory_arg_error
501: (p_api_name => l_proc,
502: p_argument => 'validation_end_date',
503: p_argument_value => p_validation_end_date);
504: --

Line 505: hr_api.mandatory_arg_error

501: (p_api_name => l_proc,
502: p_argument => 'validation_end_date',
503: p_argument_value => p_validation_end_date);
504: --
505: hr_api.mandatory_arg_error
506: (p_api_name => l_proc,
507: p_argument => 'per_typ_rt_id',
508: p_argument_value => p_per_typ_rt_id);
509: --

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

549: --
550: -- Call all supporting business operations
551: --
552: --
553: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
554: --
555: chk_per_typ_rt_id
556: (p_per_typ_rt_id => p_rec.per_typ_rt_id,
557: p_effective_date => p_effective_date,

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

601: --
602: -- Call all supporting business operations
603: --
604: --
605: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
606: --
607: chk_per_typ_rt_id
608: (p_per_typ_rt_id => p_rec.per_typ_rt_id,
609: p_effective_date => p_effective_date,

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

697: hr_utility.set_location('Entering:'|| l_proc, 10);
698: --
699: -- Ensure that all the mandatory parameter are not null
700: --
701: hr_api.mandatory_arg_error(p_api_name => l_proc,
702: p_argument => 'per_typ_rt_id',
703: p_argument_value => p_per_typ_rt_id);
704: --
705: open csr_leg_code;