47: (p_contr_history_id => p_contr_history_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_contr_history_id,hr_api.g_number)
52: <> pay_con_shd.g_old_rec.contr_history_id) then
53: --
54: -- raise error as PK has changed
55: --
224: Begin
225: --
226: hr_utility.set_location('Entering:'||l_proc, 5);
227: --
228: -- hr_api.mandatory_arg_error
229: -- (p_api_name => l_proc
230: -- ,p_argument => 'contr_type'
231: -- ,p_argument_value => p_effective_date
232: -- );
236: if (p_lookup_code = 'G') then
237: --
238: -- check if value of lookup falls within lookup type.
239: --
240: if hr_api.not_exists_in_hr_lookups
241: (p_lookup_type => p_lookup_type,
242: p_lookup_code => p_lookup_code,
243: p_effective_date => p_effective_date) then
244: --
273: chk_contr_history_id
274: (p_contr_history_id => p_rec.contr_history_id,
275: p_object_version_number => p_rec.object_version_number);
276: --
277: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
278: --
279: valid_date_return(
280: p_from_date => p_rec.date_from,
281: p_to_date => p_rec.date_to);
310: chk_contr_history_id
311: (p_contr_history_id => p_rec.contr_history_id,
312: p_object_version_number => p_rec.object_version_number);
313: --
314: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
315: --
316: valid_date_return
317: (
318: p_from_date => p_rec.date_from,
370: hr_utility.set_location('Entering:'|| l_proc, 10);
371: --
372: -- Ensure that all the mandatory parameter are not null
373: --
374: hr_api.mandatory_arg_error(p_api_name => l_proc,
375: p_argument => 'contr_history_id',
376: p_argument_value => p_contr_history_id);
377: --
378: open csr_leg_code;