50: p_pl_bnf_ctfn_id => p_pl_bnf_ctfn_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_pl_bnf_ctfn_id,hr_api.g_number)
55: <> ben_pcx_shd.g_old_rec.pl_bnf_ctfn_id) then
56: --
57: -- raise error as PK has changed
58: --
202: p_effective_date => p_effective_date,
203: p_object_version_number => p_object_version_number);
204: --
205: if (l_api_updating
206: and nvl(p_ctfn_rqd_when_rl,hr_api.g_number)
207: <> ben_pcx_shd.g_old_rec.ctfn_rqd_when_rl
208: or not l_api_updating)
209: and p_ctfn_rqd_when_rl is not null then
210: --
281: p_object_version_number => p_object_version_number);
282: --
283: if (l_api_updating
284: and p_pfd_flag
285: <> nvl(ben_pcx_shd.g_old_rec.pfd_flag,hr_api.g_varchar2)
286: or not l_api_updating)
287: and p_pfd_flag is not null then
288: --
289: -- check if value of lookup falls within lookup type.
287: and p_pfd_flag is not null then
288: --
289: -- check if value of lookup falls within lookup type.
290: --
291: if hr_api.not_exists_in_hr_lookups
292: (p_lookup_type => 'YES_NO',
293: p_lookup_code => p_pfd_flag,
294: p_effective_date => p_effective_date) then
295: --
350: p_object_version_number => p_object_version_number);
351: --
352: if (l_api_updating
353: and p_lack_ctfn_sspnd_enrt_flag
354: <> nvl(ben_pcx_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag,hr_api.g_varchar2)
355: or not l_api_updating)
356: and p_lack_ctfn_sspnd_enrt_flag is not null then
357: --
358: -- check if value of lookup falls within lookup type.
356: and p_lack_ctfn_sspnd_enrt_flag is not null then
357: --
358: -- check if value of lookup falls within lookup type.
359: --
360: if hr_api.not_exists_in_hr_lookups
361: (p_lookup_type => 'YES_NO',
362: p_lookup_code => p_lack_ctfn_sspnd_enrt_flag,
363: p_effective_date => p_effective_date) then
364: --
419: p_object_version_number => p_object_version_number);
420: --
421: if (l_api_updating
422: and p_bnf_ctfn_typ_cd
423: <> nvl(ben_pcx_shd.g_old_rec.bnf_ctfn_typ_cd,hr_api.g_varchar2)
424: or not l_api_updating)
425: and p_bnf_ctfn_typ_cd is not null then
426: --
427: -- check if value of lookup falls within lookup type.
425: and p_bnf_ctfn_typ_cd is not null then
426: --
427: -- check if value of lookup falls within lookup type.
428: --
429: if hr_api.not_exists_in_hr_lookups
430: (p_lookup_type => 'BEN_BNF_CTFN_TYP',
431: p_lookup_code => p_bnf_ctfn_typ_cd,
432: p_effective_date => p_effective_date) then
433: --
473: --
474: -- {End Of Comments}
475: -- ----------------------------------------------------------------------------
476: Procedure dt_update_validate
477: (p_pl_id in number default hr_api.g_number,
478: p_datetrack_mode in varchar2,
479: p_validation_start_date in date,
480: p_validation_end_date in date) Is
481: --
487: hr_utility.set_location('Entering:'||l_proc, 5);
488: --
489: -- Ensure that the p_datetrack_mode argument is not null
490: --
491: hr_api.mandatory_arg_error
492: (p_api_name => l_proc,
493: p_argument => 'datetrack_mode',
494: p_argument_value => p_datetrack_mode);
495: --
499: --
500: --
501: -- Ensure the arguments are not null
502: --
503: hr_api.mandatory_arg_error
504: (p_api_name => l_proc,
505: p_argument => 'validation_start_date',
506: p_argument_value => p_validation_start_date);
507: --
504: (p_api_name => l_proc,
505: p_argument => 'validation_start_date',
506: p_argument_value => p_validation_start_date);
507: --
508: hr_api.mandatory_arg_error
509: (p_api_name => l_proc,
510: p_argument => 'validation_end_date',
511: p_argument_value => p_validation_end_date);
512: --
509: (p_api_name => l_proc,
510: p_argument => 'validation_end_date',
511: p_argument_value => p_validation_end_date);
512: --
513: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
514: NOT (dt_api.check_min_max_dates
515: (p_base_table_name => 'ben_pl_f',
516: p_base_key_column => 'pl_id',
517: p_base_key_value => p_pl_id,
592: hr_utility.set_location('Entering:'||l_proc, 5);
593: --
594: -- Ensure that the p_datetrack_mode argument is not null
595: --
596: hr_api.mandatory_arg_error
597: (p_api_name => l_proc,
598: p_argument => 'datetrack_mode',
599: p_argument_value => p_datetrack_mode);
600: --
606: --
607: --
608: -- Ensure the arguments are not null
609: --
610: hr_api.mandatory_arg_error
611: (p_api_name => l_proc,
612: p_argument => 'validation_start_date',
613: p_argument_value => p_validation_start_date);
614: --
611: (p_api_name => l_proc,
612: p_argument => 'validation_start_date',
613: p_argument_value => p_validation_start_date);
614: --
615: hr_api.mandatory_arg_error
616: (p_api_name => l_proc,
617: p_argument => 'validation_end_date',
618: p_argument_value => p_validation_end_date);
619: --
616: (p_api_name => l_proc,
617: p_argument => 'validation_end_date',
618: p_argument_value => p_validation_end_date);
619: --
620: hr_api.mandatory_arg_error
621: (p_api_name => l_proc,
622: p_argument => 'pl_bnf_ctfn_id',
623: p_argument_value => p_pl_bnf_ctfn_id);
624: --
663: --
664: -- Call all supporting business operations
665: --
666: --
667: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
668: --
669: chk_pl_bnf_ctfn_id
670: (p_pl_bnf_ctfn_id => p_rec.pl_bnf_ctfn_id,
671: p_effective_date => p_effective_date,
725: --
726: -- Call all supporting business operations
727: --
728: --
729: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
730: --
731: chk_pl_bnf_ctfn_id
732: (p_pl_bnf_ctfn_id => p_rec.pl_bnf_ctfn_id,
733: p_effective_date => p_effective_date,
831: hr_utility.set_location('Entering:'|| l_proc, 10);
832: --
833: -- Ensure that all the mandatory parameter are not null
834: --
835: hr_api.mandatory_arg_error(p_api_name => l_proc,
836: p_argument => 'pl_bnf_ctfn_id',
837: p_argument_value => p_pl_bnf_ctfn_id);
838: --
839: open csr_leg_code;