DBA Data[Home] [Help]

APPS.BEN_FTR_BUS dependencies on HR_API

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

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

Line 126: <> nvl(ben_ftr_shd.g_old_rec.fl_tm_pt_tm_cd,hr_api.g_varchar2)

122: p_object_version_number => p_object_version_number);
123: --
124: if (l_api_updating
125: and p_fl_tm_pt_tm_cd
126: <> nvl(ben_ftr_shd.g_old_rec.fl_tm_pt_tm_cd,hr_api.g_varchar2)
127: or not l_api_updating) then
128: --
129: -- check if value of lookup falls within lookup type.
130: --

Line 132: if hr_api.not_exists_in_hr_lookups

128: --
129: -- check if value of lookup falls within lookup type.
130: --
131: --
132: if hr_api.not_exists_in_hr_lookups
133: (p_lookup_type => 'EMP_CAT',
134: p_lookup_code => p_fl_tm_pt_tm_cd,
135: p_effective_date => p_effective_date) then
136: --

Line 202: and fl_tm_pt_tm_rt_id <> nvl(p_fl_tm_pt_tm_rt_id,hr_api.g_number)

198: select null
199: from ben_fl_tm_pt_tm_rt_f
200: where fl_tm_pt_tm_cd = p_fl_tm_pt_tm_cd
201: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
202: and fl_tm_pt_tm_rt_id <> nvl(p_fl_tm_pt_tm_rt_id,hr_api.g_number)
203: and business_group_id + 0 = p_business_group_id
204: and p_validation_start_date <= effective_end_date
205: and p_validation_end_date >= effective_start_date;
206: --

Line 217: and p_fl_tm_pt_tm_cd <> nvl(ben_ftr_shd.g_old_rec.fl_tm_pt_tm_cd,hr_api.g_varchar2)

213: p_effective_date => p_effective_date,
214: p_object_version_number => p_object_version_number);
215: --
216: if (l_api_updating
217: and p_fl_tm_pt_tm_cd <> nvl(ben_ftr_shd.g_old_rec.fl_tm_pt_tm_cd,hr_api.g_varchar2)
218: or not l_api_updating) then
219:
220: open c_dup;
221: fetch c_dup into l_exists;

Line 345: <> nvl(ben_ftr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

341: p_object_version_number => p_object_version_number);
342: --
343: if (l_api_updating
344: and p_excld_flag
345: <> nvl(ben_ftr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
346: or not l_api_updating) then
347: --
348: -- check if value of lookup falls within lookup type.
349: --

Line 351: if hr_api.not_exists_in_hr_lookups

347: --
348: -- check if value of lookup falls within lookup type.
349: --
350: --
351: if hr_api.not_exists_in_hr_lookups
352: (p_lookup_type => 'YES_NO',
353: p_lookup_code => p_excld_flag,
354: p_effective_date => p_effective_date) then
355: --

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

395: --
396: -- {End Of Comments}
397: -- ----------------------------------------------------------------------------
398: Procedure dt_update_validate
399: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
400: p_datetrack_mode in varchar2,
401: p_validation_start_date in date,
402: p_validation_end_date in date) Is
403: --

Line 413: hr_api.mandatory_arg_error

409: hr_utility.set_location('Entering:'||l_proc, 5);
410: --
411: -- Ensure that the p_datetrack_mode argument is not null
412: --
413: hr_api.mandatory_arg_error
414: (p_api_name => l_proc,
415: p_argument => 'datetrack_mode',
416: p_argument_value => p_datetrack_mode);
417: --

Line 425: hr_api.mandatory_arg_error

421: --
422: --
423: -- Ensure the arguments are not null
424: --
425: hr_api.mandatory_arg_error
426: (p_api_name => l_proc,
427: p_argument => 'validation_start_date',
428: p_argument_value => p_validation_start_date);
429: --

Line 430: hr_api.mandatory_arg_error

426: (p_api_name => l_proc,
427: p_argument => 'validation_start_date',
428: p_argument_value => p_validation_start_date);
429: --
430: hr_api.mandatory_arg_error
431: (p_api_name => l_proc,
432: p_argument => 'validation_end_date',
433: p_argument_value => p_validation_end_date);
434: --

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

431: (p_api_name => l_proc,
432: p_argument => 'validation_end_date',
433: p_argument_value => p_validation_end_date);
434: --
435: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
436: NOT (dt_api.check_min_max_dates
437: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
438: p_base_key_column => 'vrbl_rt_prfl_id',
439: p_base_key_value => p_vrbl_rt_prfl_id,

Line 518: hr_api.mandatory_arg_error

514: hr_utility.set_location('Entering:'||l_proc, 5);
515: --
516: -- Ensure that the p_datetrack_mode argument is not null
517: --
518: hr_api.mandatory_arg_error
519: (p_api_name => l_proc,
520: p_argument => 'datetrack_mode',
521: p_argument_value => p_datetrack_mode);
522: --

Line 532: hr_api.mandatory_arg_error

528: --
529: --
530: -- Ensure the arguments are not null
531: --
532: hr_api.mandatory_arg_error
533: (p_api_name => l_proc,
534: p_argument => 'validation_start_date',
535: p_argument_value => p_validation_start_date);
536: --

Line 537: hr_api.mandatory_arg_error

533: (p_api_name => l_proc,
534: p_argument => 'validation_start_date',
535: p_argument_value => p_validation_start_date);
536: --
537: hr_api.mandatory_arg_error
538: (p_api_name => l_proc,
539: p_argument => 'validation_end_date',
540: p_argument_value => p_validation_end_date);
541: --

Line 542: hr_api.mandatory_arg_error

538: (p_api_name => l_proc,
539: p_argument => 'validation_end_date',
540: p_argument_value => p_validation_end_date);
541: --
542: hr_api.mandatory_arg_error
543: (p_api_name => l_proc,
544: p_argument => 'fl_tm_pt_tm_rt_id',
545: p_argument_value => p_fl_tm_pt_tm_rt_id);
546: --

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

586: --
587: -- Call all supporting business operations
588: --
589: --
590: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
591: --
592: chk_fl_tm_pt_tm_rt_id
593: (p_fl_tm_pt_tm_rt_id => p_rec.fl_tm_pt_tm_rt_id,
594: p_effective_date => p_effective_date,

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

643: --
644: -- Call all supporting business operations
645: --
646: --
647: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
648: --
649: chk_fl_tm_pt_tm_rt_id
650: (p_fl_tm_pt_tm_rt_id => p_rec.fl_tm_pt_tm_rt_id,
651: p_effective_date => p_effective_date,

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

744: hr_utility.set_location('Entering:'|| l_proc, 10);
745: --
746: -- Ensure that all the mandatory parameter are not null
747: --
748: hr_api.mandatory_arg_error(p_api_name => l_proc,
749: p_argument => 'fl_tm_pt_tm_rt_id',
750: p_argument_value => p_fl_tm_pt_tm_rt_id);
751: --
752: open csr_leg_code;