50: p_bnft_rstrn_ctfn_id => p_bnft_rstrn_ctfn_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_bnft_rstrn_ctfn_id,hr_api.g_number)
55: <> ben_brc_shd.g_old_rec.bnft_rstrn_ctfn_id) then
56: --
57: -- raise error as PK has changed
58: --
120: p_effective_date => p_effective_date,
121: p_object_version_number => p_object_version_number);
122: --
123: if (l_api_updating
124: and nvl(p_ctfn_rqd_when_rl,hr_api.g_number)
125: <> ben_brc_shd.g_old_rec.ctfn_rqd_when_rl
126: or not l_api_updating)
127: and p_ctfn_rqd_when_rl is not null then
128: --
193: p_object_version_number => p_object_version_number);
194: --
195: if (l_api_updating
196: and p_enrt_ctfn_typ_cd
197: <> nvl(ben_brc_shd.g_old_rec.enrt_ctfn_typ_cd,hr_api.g_varchar2)
198: or not l_api_updating)
199: and p_enrt_ctfn_typ_cd is not null then
200: --
201: -- check if value of lookup falls within lookup type.
199: and p_enrt_ctfn_typ_cd is not null then
200: --
201: -- check if value of lookup falls within lookup type.
202: --
203: if hr_api.not_exists_in_hr_lookups
204: (p_lookup_type => 'BEN_ENRT_CTFN_TYP',
205: p_lookup_code => p_enrt_ctfn_typ_cd,
206: p_effective_date => p_effective_date) then
207: --
329: p_object_version_number => p_object_version_number);
330: --
331: if (l_api_updating
332: and p_rqd_flag
333: <> nvl(ben_brc_shd.g_old_rec.rqd_flag,hr_api.g_varchar2)
334: or not l_api_updating) and p_rqd_flag is not null then
335: --
336: -- check if value of lookup falls within lookup type.
337: --
335: --
336: -- check if value of lookup falls within lookup type.
337: --
338: --
339: if hr_api.not_exists_in_hr_lookups
340: (p_lookup_type => 'YES_NO',
341: p_lookup_code => p_rqd_flag,
342: p_effective_date => p_effective_date) then
343: --
385: --
386: -- {End Of Comments}
387: -- ----------------------------------------------------------------------------
388: Procedure dt_update_validate
389: (p_pl_id in number default hr_api.g_number,
390: p_datetrack_mode in varchar2,
391: p_validation_start_date in date,
392: p_validation_end_date in date) Is
393: --
399: hr_utility.set_location('Entering:'||l_proc, 5);
400: --
401: -- Ensure that the p_datetrack_mode argument is not null
402: --
403: hr_api.mandatory_arg_error
404: (p_api_name => l_proc,
405: p_argument => 'datetrack_mode',
406: p_argument_value => p_datetrack_mode);
407: --
411: --
412: --
413: -- Ensure the arguments are not null
414: --
415: hr_api.mandatory_arg_error
416: (p_api_name => l_proc,
417: p_argument => 'validation_start_date',
418: p_argument_value => p_validation_start_date);
419: --
416: (p_api_name => l_proc,
417: p_argument => 'validation_start_date',
418: p_argument_value => p_validation_start_date);
419: --
420: hr_api.mandatory_arg_error
421: (p_api_name => l_proc,
422: p_argument => 'validation_end_date',
423: p_argument_value => p_validation_end_date);
424: --
421: (p_api_name => l_proc,
422: p_argument => 'validation_end_date',
423: p_argument_value => p_validation_end_date);
424: --
425: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
426: NOT (dt_api.check_min_max_dates
427: (p_base_table_name => 'ben_pl_f',
428: p_base_key_column => 'pl_id',
429: p_base_key_value => p_pl_id,
503: hr_utility.set_location('Entering:'||l_proc, 5);
504: --
505: -- Ensure that the p_datetrack_mode argument is not null
506: --
507: hr_api.mandatory_arg_error
508: (p_api_name => l_proc,
509: p_argument => 'datetrack_mode',
510: p_argument_value => p_datetrack_mode);
511: --
517: --
518: --
519: -- Ensure the arguments are not null
520: --
521: hr_api.mandatory_arg_error
522: (p_api_name => l_proc,
523: p_argument => 'validation_start_date',
524: p_argument_value => p_validation_start_date);
525: --
522: (p_api_name => l_proc,
523: p_argument => 'validation_start_date',
524: p_argument_value => p_validation_start_date);
525: --
526: hr_api.mandatory_arg_error
527: (p_api_name => l_proc,
528: p_argument => 'validation_end_date',
529: p_argument_value => p_validation_end_date);
530: --
527: (p_api_name => l_proc,
528: p_argument => 'validation_end_date',
529: p_argument_value => p_validation_end_date);
530: --
531: hr_api.mandatory_arg_error
532: (p_api_name => l_proc,
533: p_argument => 'bnft_rstrn_ctfn_id',
534: p_argument_value => p_bnft_rstrn_ctfn_id);
535: --
574: --
575: -- Call all supporting business operations
576: --
577: --
578: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
579: --
580: chk_bnft_rstrn_ctfn_id
581: (p_bnft_rstrn_ctfn_id => p_rec.bnft_rstrn_ctfn_id,
582: p_effective_date => p_effective_date,
630: --
631: -- Call all supporting business operations
632: --
633: --
634: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
635: --
636: chk_bnft_rstrn_ctfn_id
637: (p_bnft_rstrn_ctfn_id => p_rec.bnft_rstrn_ctfn_id,
638: p_effective_date => p_effective_date,
730: hr_utility.set_location('Entering:'|| l_proc, 10);
731: --
732: -- Ensure that all the mandatory parameter are not null
733: --
734: hr_api.mandatory_arg_error(p_api_name => l_proc,
735: p_argument => 'bnft_rstrn_ctfn_id',
736: p_argument_value => p_bnft_rstrn_ctfn_id);
737: --
738: open csr_leg_code;