[Home] [Help]
50: p_cntnu_prtn_ctfn_typ_id => p_cntnu_prtn_ctfn_typ_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_cntnu_prtn_ctfn_typ_id,hr_api.g_number)
55: <> ben_cpc_shd.g_old_rec.cntnu_prtn_ctfn_typ_id) then
56: --
57: -- raise error as PK has changed
58: --
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_prtn_ctfn_typ_cd
124: <> nvl(ben_cpc_shd.g_old_rec.prtn_ctfn_typ_cd,hr_api.g_varchar2)
125: or not l_api_updating) then
126: --
127: -- check if value of lookup falls within lookup type.
128: --
126: --
127: -- check if value of lookup falls within lookup type.
128: --
129: --
130: if hr_api.not_exists_in_hr_lookups
131: (p_lookup_type => 'BEN_PRTN_CTFN_TYP',
132: p_lookup_code => p_prtn_ctfn_typ_cd,
133: p_effective_date => p_effective_date) then
134: --
191: p_effective_date => p_effective_date,
192: p_object_version_number => p_object_version_number);
193: --
194: if (l_api_updating
195: and nvl(p_ctfn_rqd_when_rl,hr_api.g_number)
196: <> ben_cpc_shd.g_old_rec.ctfn_rqd_when_rl
197: or not l_api_updating)
198: and p_ctfn_rqd_when_rl is not null then
199: --
263: p_object_version_number => p_object_version_number);
264: --
265: if (l_api_updating
266: and p_lack_ctfn_sspnd_elig_flag
267: <> nvl(ben_cpc_shd.g_old_rec.lack_ctfn_sspnd_elig_flag,hr_api.g_varchar2)
268: or not l_api_updating) then
269: --
270: -- check if value of lookup falls within lookup type.
271: --
269: --
270: -- check if value of lookup falls within lookup type.
271: --
272: --
273: if hr_api.not_exists_in_hr_lookups
274: (p_lookup_type => 'YES_NO',
275: p_lookup_code => p_lack_ctfn_sspnd_elig_flag,
276: p_effective_date => p_effective_date) then
277: --
334: p_object_version_number => p_object_version_number);
335: --
336: if (l_api_updating
337: and p_pfd_flag
338: <> nvl(ben_cpc_shd.g_old_rec.pfd_flag,hr_api.g_varchar2)
339: or not l_api_updating) then
340: --
341: -- check if value of lookup falls within lookup type.
342: --
340: --
341: -- check if value of lookup falls within lookup type.
342: --
343: --
344: if hr_api.not_exists_in_hr_lookups
345: (p_lookup_type => 'YES_NO',
346: p_lookup_code => p_pfd_flag,
347: p_effective_date => p_effective_date) then
348: --
390: --
391: -- {End Of Comments}
392: -- ----------------------------------------------------------------------------
393: Procedure dt_update_validate
394: (p_cntng_prtn_elig_prfl_id in number default hr_api.g_number,
395: p_datetrack_mode in varchar2,
396: p_validation_start_date in date,
397: p_validation_end_date in date) Is
398: --
404: hr_utility.set_location('Entering:'||l_proc, 5);
405: --
406: -- Ensure that the p_datetrack_mode argument is not null
407: --
408: hr_api.mandatory_arg_error
409: (p_api_name => l_proc,
410: p_argument => 'datetrack_mode',
411: p_argument_value => p_datetrack_mode);
412: --
416: --
417: --
418: -- Ensure the arguments are not null
419: --
420: hr_api.mandatory_arg_error
421: (p_api_name => l_proc,
422: p_argument => 'validation_start_date',
423: p_argument_value => p_validation_start_date);
424: --
421: (p_api_name => l_proc,
422: p_argument => 'validation_start_date',
423: p_argument_value => p_validation_start_date);
424: --
425: hr_api.mandatory_arg_error
426: (p_api_name => l_proc,
427: p_argument => 'validation_end_date',
428: p_argument_value => p_validation_end_date);
429: --
426: (p_api_name => l_proc,
427: p_argument => 'validation_end_date',
428: p_argument_value => p_validation_end_date);
429: --
430: If ((nvl(p_cntng_prtn_elig_prfl_id, hr_api.g_number) <> hr_api.g_number) and
431: NOT (dt_api.check_min_max_dates
432: (p_base_table_name => 'ben_cntng_prtn_elig_prfl_f',
433: p_base_key_column => 'cntng_prtn_elig_prfl_id',
434: p_base_key_value => p_cntng_prtn_elig_prfl_id,
510: hr_utility.set_location('Entering:'||l_proc, 5);
511: --
512: -- Ensure that the p_datetrack_mode argument is not null
513: --
514: hr_api.mandatory_arg_error
515: (p_api_name => l_proc,
516: p_argument => 'datetrack_mode',
517: p_argument_value => p_datetrack_mode);
518: --
524: --
525: --
526: -- Ensure the arguments are not null
527: --
528: hr_api.mandatory_arg_error
529: (p_api_name => l_proc,
530: p_argument => 'validation_start_date',
531: p_argument_value => p_validation_start_date);
532: --
529: (p_api_name => l_proc,
530: p_argument => 'validation_start_date',
531: p_argument_value => p_validation_start_date);
532: --
533: hr_api.mandatory_arg_error
534: (p_api_name => l_proc,
535: p_argument => 'validation_end_date',
536: p_argument_value => p_validation_end_date);
537: --
534: (p_api_name => l_proc,
535: p_argument => 'validation_end_date',
536: p_argument_value => p_validation_end_date);
537: --
538: hr_api.mandatory_arg_error
539: (p_api_name => l_proc,
540: p_argument => 'cntnu_prtn_ctfn_typ_id',
541: p_argument_value => p_cntnu_prtn_ctfn_typ_id);
542: --
582: --
583: -- Call all supporting business operations
584: --
585: --
586: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
587: --
588: chk_cntnu_prtn_ctfn_typ_id
589: (p_cntnu_prtn_ctfn_typ_id => p_rec.cntnu_prtn_ctfn_typ_id,
590: p_effective_date => p_effective_date,
635: --
636: -- Call all supporting business operations
637: --
638: --
639: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
640: --
641: chk_cntnu_prtn_ctfn_typ_id
642: (p_cntnu_prtn_ctfn_typ_id => p_rec.cntnu_prtn_ctfn_typ_id,
643: p_effective_date => p_effective_date,
732: hr_utility.set_location('Entering:'|| l_proc, 10);
733: --
734: -- Ensure that all the mandatory parameter are not null
735: --
736: hr_api.mandatory_arg_error(p_api_name => l_proc,
737: p_argument => 'cntnu_prtn_ctfn_typ_id',
738: p_argument_value => p_cntnu_prtn_ctfn_typ_id);
739: --
740: open csr_leg_code;