50: p_regn_for_regy_body_id => p_regn_for_regy_body_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_regn_for_regy_body_id,hr_api.g_number)
55: <> ben_rrb_shd.g_old_rec.regn_for_regy_body_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_regn_admin_cd
124: <> nvl(ben_rrb_shd.g_old_rec.regn_admin_cd,hr_api.g_varchar2)
125: or not l_api_updating)
126: and p_regn_admin_cd is not null then
127: --
128: -- check if value of lookup falls within lookup type.
126: and p_regn_admin_cd is not null then
127: --
128: -- check if value of lookup falls within lookup type.
129: --
130: if hr_api.not_exists_in_hr_lookups
131: (p_lookup_type => 'BEN_REGN_ADMN',
132: p_lookup_code => p_regn_admin_cd,
133: p_effective_date => p_effective_date) then
134: --
193: select null
194: from ben_regn_for_regy_body_f
195: where organization_id = p_organization_id
196: and regn_id = p_regn_id
197: and regn_for_regy_body_id <> nvl(p_regn_for_regy_body_id,hr_api.g_number)
198: and business_group_id + 0 = p_business_group_id
199: and p_validation_start_date <= effective_end_date
200: and p_validation_end_date >= effective_start_date
201: ;
265: --
266: -- {End Of Comments}
267: -- ----------------------------------------------------------------------------
268: Procedure dt_update_validate
269: (p_regn_id in number default hr_api.g_number,
270: p_datetrack_mode in varchar2,
271: p_validation_start_date in date,
272: p_validation_end_date in date) Is
273: --
279: hr_utility.set_location('Entering:'||l_proc, 5);
280: --
281: -- Ensure that the p_datetrack_mode argument is not null
282: --
283: hr_api.mandatory_arg_error
284: (p_api_name => l_proc,
285: p_argument => 'datetrack_mode',
286: p_argument_value => p_datetrack_mode);
287: --
291: --
292: --
293: -- Ensure the arguments are not null
294: --
295: hr_api.mandatory_arg_error
296: (p_api_name => l_proc,
297: p_argument => 'validation_start_date',
298: p_argument_value => p_validation_start_date);
299: --
296: (p_api_name => l_proc,
297: p_argument => 'validation_start_date',
298: p_argument_value => p_validation_start_date);
299: --
300: hr_api.mandatory_arg_error
301: (p_api_name => l_proc,
302: p_argument => 'validation_end_date',
303: p_argument_value => p_validation_end_date);
304: --
301: (p_api_name => l_proc,
302: p_argument => 'validation_end_date',
303: p_argument_value => p_validation_end_date);
304: --
305: If ((nvl(p_regn_id, hr_api.g_number) <> hr_api.g_number) and
306: NOT (dt_api.check_min_max_dates
307: (p_base_table_name => 'ben_regn_f',
308: p_base_key_column => 'regn_id',
309: p_base_key_value => p_regn_id,
385: hr_utility.set_location('Entering:'||l_proc, 5);
386: --
387: -- Ensure that the p_datetrack_mode argument is not null
388: --
389: hr_api.mandatory_arg_error
390: (p_api_name => l_proc,
391: p_argument => 'datetrack_mode',
392: p_argument_value => p_datetrack_mode);
393: --
399: --
400: --
401: -- Ensure the arguments are not null
402: --
403: hr_api.mandatory_arg_error
404: (p_api_name => l_proc,
405: p_argument => 'validation_start_date',
406: p_argument_value => p_validation_start_date);
407: --
404: (p_api_name => l_proc,
405: p_argument => 'validation_start_date',
406: p_argument_value => p_validation_start_date);
407: --
408: hr_api.mandatory_arg_error
409: (p_api_name => l_proc,
410: p_argument => 'validation_end_date',
411: p_argument_value => p_validation_end_date);
412: --
409: (p_api_name => l_proc,
410: p_argument => 'validation_end_date',
411: p_argument_value => p_validation_end_date);
412: --
413: hr_api.mandatory_arg_error
414: (p_api_name => l_proc,
415: p_argument => 'regn_for_regy_body_id',
416: p_argument_value => p_regn_for_regy_body_id);
417: --
457: --
458: -- Call all supporting business operations
459: --
460: --
461: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
462: --
463: chk_regn_for_regy_body_id
464: (p_regn_for_regy_body_id => p_rec.regn_for_regy_body_id,
465: p_effective_date => p_effective_date,
501: --
502: -- Call all supporting business operations
503: --
504: --
505: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
506: --
507: chk_regn_for_regy_body_id
508: (p_regn_for_regy_body_id => p_rec.regn_for_regy_body_id,
509: p_effective_date => p_effective_date,
590: hr_utility.set_location('Entering:'|| l_proc, 10);
591: --
592: -- Ensure that all the mandatory parameter are not null
593: --
594: hr_api.mandatory_arg_error(p_api_name => l_proc,
595: p_argument => 'regn_for_regy_body_id',
596: p_argument_value => p_regn_for_regy_body_id);
597: --
598: open csr_leg_code;