50: p_pl_gd_r_svc_ctfn_id => p_pl_gd_r_svc_ctfn_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_pl_gd_r_svc_ctfn_id,hr_api.g_number)
55: <> ben_pct_shd.g_old_rec.pl_gd_r_svc_ctfn_id) then
56: --
57: -- raise error as PK has changed
58: --
136: p_effective_date => p_effective_date,
137: p_object_version_number => p_object_version_number);
138: --
139: if (l_api_updating
140: and nvl(p_ctfn_rqd_when_rl,hr_api.g_number)
141: <> ben_pct_shd.g_old_rec.ctfn_rqd_when_rl
142: or not l_api_updating)
143: and p_ctfn_rqd_when_rl is not null then
144: --
213: p_object_version_number => p_object_version_number);
214: --
215: if (l_api_updating
216: and p_rmbmt_ctfn_typ_cd
217: <> nvl(ben_pct_shd.g_old_rec.rmbmt_ctfn_typ_cd,hr_api.g_varchar2)
218: or not l_api_updating) then
219: --
220: -- check if value of lookup falls within lookup type.
221: --
219: --
220: -- check if value of lookup falls within lookup type.
221: --
222: --
223: if hr_api.not_exists_in_hr_lookups
224: (p_lookup_type => 'BEN_REIMBMT_CTFN_TYP',
225: p_lookup_code => p_rmbmt_ctfn_typ_cd,
226: p_effective_date => p_effective_date) then
227: --
282: p_object_version_number => p_object_version_number);
283: --
284: if (l_api_updating
285: and p_rqd_flag
286: <> nvl(ben_pct_shd.g_old_rec.rqd_flag,hr_api.g_varchar2)
287: or not l_api_updating)
288: and p_rqd_flag is not null then
289: --
290: -- check if value of lookup falls within lookup type.
288: and p_rqd_flag is not null then
289: --
290: -- check if value of lookup falls within lookup type.
291: --
292: if hr_api.not_exists_in_hr_lookups
293: (p_lookup_type => 'YES_NO',
294: p_lookup_code => p_rqd_flag,
295: p_effective_date => p_effective_date) then
296: --
351: p_object_version_number => p_object_version_number);
352: --
353: if (l_api_updating
354: and p_pfd_flag
355: <> nvl(ben_pct_shd.g_old_rec.pfd_flag,hr_api.g_varchar2)
356: or not l_api_updating)
357: and p_pfd_flag is not null then
358: --
359: -- check if value of lookup falls within lookup type.
357: and p_pfd_flag is not null then
358: --
359: -- check if value of lookup falls within lookup type.
360: --
361: if hr_api.not_exists_in_hr_lookups
362: (p_lookup_type => 'YES_NO',
363: p_lookup_code => p_pfd_flag,
364: p_effective_date => p_effective_date) then
365: --
405: --
406: -- {End Of Comments}
407: -- ----------------------------------------------------------------------------
408: Procedure dt_update_validate
409: (p_ctfn_rqd_when_rl in number default hr_api.g_number,
410: p_pl_gd_or_svc_id in number default hr_api.g_number,
411: p_datetrack_mode in varchar2,
412: p_validation_start_date in date,
413: p_validation_end_date in date) Is
406: -- {End Of Comments}
407: -- ----------------------------------------------------------------------------
408: Procedure dt_update_validate
409: (p_ctfn_rqd_when_rl in number default hr_api.g_number,
410: p_pl_gd_or_svc_id in number default hr_api.g_number,
411: p_datetrack_mode in varchar2,
412: p_validation_start_date in date,
413: p_validation_end_date in date) Is
414: --
420: hr_utility.set_location('Entering:'||l_proc, 5);
421: --
422: -- Ensure that the p_datetrack_mode argument is not null
423: --
424: hr_api.mandatory_arg_error
425: (p_api_name => l_proc,
426: p_argument => 'datetrack_mode',
427: p_argument_value => p_datetrack_mode);
428: --
432: --
433: --
434: -- Ensure the arguments are not null
435: --
436: hr_api.mandatory_arg_error
437: (p_api_name => l_proc,
438: p_argument => 'validation_start_date',
439: p_argument_value => p_validation_start_date);
440: --
437: (p_api_name => l_proc,
438: p_argument => 'validation_start_date',
439: p_argument_value => p_validation_start_date);
440: --
441: hr_api.mandatory_arg_error
442: (p_api_name => l_proc,
443: p_argument => 'validation_end_date',
444: p_argument_value => p_validation_end_date);
445: --
442: (p_api_name => l_proc,
443: p_argument => 'validation_end_date',
444: p_argument_value => p_validation_end_date);
445: --
446: If ((nvl(p_ctfn_rqd_when_rl, hr_api.g_number) <> hr_api.g_number) and
447: NOT (dt_api.check_min_max_dates
448: (p_base_table_name => 'ff_formulas_f',
449: p_base_key_column => 'formula_id',
450: p_base_key_value => p_ctfn_rqd_when_rl,
452: p_to_date => p_validation_end_date))) Then
453: l_table_name := 'ff_formulas_f';
454: Raise l_integrity_error;
455: End If;
456: If ((nvl(p_pl_gd_or_svc_id, hr_api.g_number) <> hr_api.g_number) and
457: NOT (dt_api.check_min_max_dates
458: (p_base_table_name => 'ben_pl_gd_or_svc_f',
459: p_base_key_column => 'pl_gd_or_svc_id',
460: p_base_key_value => p_pl_gd_or_svc_id,
462: p_to_date => p_validation_end_date))) Then
463: l_table_name := 'ben_pl_gd_or_svc_f';
464: Raise l_integrity_error;
465: End If;
466: /*If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
467: NOT (dt_api.check_min_max_dates
468: (p_base_table_name => 'ben_pl_f',
469: p_base_key_column => 'pl_id',
470: p_base_key_value => p_pl_id,
546: hr_utility.set_location('Entering:'||l_proc, 5);
547: --
548: -- Ensure that the p_datetrack_mode argument is not null
549: --
550: hr_api.mandatory_arg_error
551: (p_api_name => l_proc,
552: p_argument => 'datetrack_mode',
553: p_argument_value => p_datetrack_mode);
554: --
560: --
561: --
562: -- Ensure the arguments are not null
563: --
564: hr_api.mandatory_arg_error
565: (p_api_name => l_proc,
566: p_argument => 'validation_start_date',
567: p_argument_value => p_validation_start_date);
568: --
565: (p_api_name => l_proc,
566: p_argument => 'validation_start_date',
567: p_argument_value => p_validation_start_date);
568: --
569: hr_api.mandatory_arg_error
570: (p_api_name => l_proc,
571: p_argument => 'validation_end_date',
572: p_argument_value => p_validation_end_date);
573: --
570: (p_api_name => l_proc,
571: p_argument => 'validation_end_date',
572: p_argument_value => p_validation_end_date);
573: --
574: hr_api.mandatory_arg_error
575: (p_api_name => l_proc,
576: p_argument => 'pl_gd_r_svc_ctfn_id',
577: p_argument_value => p_pl_gd_r_svc_ctfn_id);
578: --
618: --
619: -- Call all supporting business operations
620: --
621: --
622: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
623: --
624: chk_pl_gd_r_svc_ctfn_id
625: (p_pl_gd_r_svc_ctfn_id => p_rec.pl_gd_r_svc_ctfn_id,
626: p_effective_date => p_effective_date,
671: --
672: -- Call all supporting business operations
673: --
674: --
675: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
676: --
677: chk_pl_gd_r_svc_ctfn_id
678: (p_pl_gd_r_svc_ctfn_id => p_rec.pl_gd_r_svc_ctfn_id,
679: p_effective_date => p_effective_date,
768: hr_utility.set_location('Entering:'|| l_proc, 10);
769: --
770: -- Ensure that all the mandatory parameter are not null
771: --
772: hr_api.mandatory_arg_error(p_api_name => l_proc,
773: p_argument => 'pl_gd_r_svc_ctfn_id',
774: p_argument_value => p_pl_gd_r_svc_ctfn_id);
775: --
776: open csr_leg_code;