50: p_prtt_prem_id => p_prtt_prem_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_prtt_prem_id,hr_api.g_number)
55: <> ben_ppe_shd.g_old_rec.prtt_prem_id) then
56: --
57: -- raise error as PK has changed
58: --
126: p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating
129: and p_std_prem_uom
130: <> nvl(ben_ppe_shd.g_old_rec.std_prem_uom,hr_api.g_varchar2)
131: or not l_api_updating)
132: and p_std_prem_uom is not null then
133: --
134: -- check if value of lookup falls within lookup type.
187: --
188: -- {End Of Comments}
189: -- ----------------------------------------------------------------------------
190: Procedure dt_update_validate
191: (p_actl_prem_id in number default hr_api.g_number,
192: p_prtt_enrt_rslt_id in number default hr_api.g_number,
193: p_datetrack_mode in varchar2,
194: p_validation_start_date in date,
195: p_validation_end_date in date) Is
188: -- {End Of Comments}
189: -- ----------------------------------------------------------------------------
190: Procedure dt_update_validate
191: (p_actl_prem_id in number default hr_api.g_number,
192: p_prtt_enrt_rslt_id in number default hr_api.g_number,
193: p_datetrack_mode in varchar2,
194: p_validation_start_date in date,
195: p_validation_end_date in date) Is
196: --
202: hr_utility.set_location('Entering:'||l_proc, 5);
203: --
204: -- Ensure that the p_datetrack_mode argument is not null
205: --
206: hr_api.mandatory_arg_error
207: (p_api_name => l_proc,
208: p_argument => 'datetrack_mode',
209: p_argument_value => p_datetrack_mode);
210: --
214: --
215: --
216: -- Ensure the arguments are not null
217: --
218: hr_api.mandatory_arg_error
219: (p_api_name => l_proc,
220: p_argument => 'validation_start_date',
221: p_argument_value => p_validation_start_date);
222: --
219: (p_api_name => l_proc,
220: p_argument => 'validation_start_date',
221: p_argument_value => p_validation_start_date);
222: --
223: hr_api.mandatory_arg_error
224: (p_api_name => l_proc,
225: p_argument => 'validation_end_date',
226: p_argument_value => p_validation_end_date);
227: --
224: (p_api_name => l_proc,
225: p_argument => 'validation_end_date',
226: p_argument_value => p_validation_end_date);
227: --
228: If ((nvl(p_actl_prem_id, hr_api.g_number) <> hr_api.g_number) and
229: NOT (dt_api.check_min_max_dates
230: (p_base_table_name => 'ben_actl_prem_f',
231: p_base_key_column => 'actl_prem_id',
232: p_base_key_value => p_actl_prem_id,
239: -- Bug#1646442: removed following block of code
240: /***************** BEGIN CODE PRIOR TO WWBUG: 1646442 ****************
241: -- because pen now has different datetracking from ppe must sever
242: -- connection based on effective dating.
243: If ((nvl(p_prtt_enrt_rslt_id, hr_api.g_number) <> hr_api.g_number) and
244: NOT (dt_api.check_min_max_dates
245: (p_base_table_name => 'ben_prtt_enrt_rslt_f',
246: p_base_key_column => 'prtt_enrt_rslt_id',
247: p_base_key_value => p_prtt_enrt_rslt_id,
322: hr_utility.set_location('Entering:'||l_proc, 5);
323: --
324: -- Ensure that the p_datetrack_mode argument is not null
325: --
326: hr_api.mandatory_arg_error
327: (p_api_name => l_proc,
328: p_argument => 'datetrack_mode',
329: p_argument_value => p_datetrack_mode);
330: --
336: --
337: --
338: -- Ensure the arguments are not null
339: --
340: hr_api.mandatory_arg_error
341: (p_api_name => l_proc,
342: p_argument => 'validation_start_date',
343: p_argument_value => p_validation_start_date);
344: --
341: (p_api_name => l_proc,
342: p_argument => 'validation_start_date',
343: p_argument_value => p_validation_start_date);
344: --
345: hr_api.mandatory_arg_error
346: (p_api_name => l_proc,
347: p_argument => 'validation_end_date',
348: p_argument_value => p_validation_end_date);
349: --
346: (p_api_name => l_proc,
347: p_argument => 'validation_end_date',
348: p_argument_value => p_validation_end_date);
349: --
350: hr_api.mandatory_arg_error
351: (p_api_name => l_proc,
352: p_argument => 'prtt_prem_id',
353: p_argument_value => p_prtt_prem_id);
354: --
399: /*
400: --
401: -- Call all supporting business operations
402: --
403: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
404: */
405: --
406: chk_prtt_prem_id
407: (p_prtt_prem_id => p_rec.prtt_prem_id,
441: /*
442: --
443: -- Call all supporting business operations
444: --
445: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
446: */
447: --
448: chk_prtt_prem_id
449: (p_prtt_prem_id => p_rec.prtt_prem_id,
521: hr_utility.set_location('Entering:'|| l_proc, 10);
522: --
523: -- Ensure that all the mandatory parameter are not null
524: --
525: hr_api.mandatory_arg_error(p_api_name => l_proc,
526: p_argument => 'prtt_prem_id',
527: p_argument_value => p_prtt_prem_id);
528: --
529: open csr_leg_code;