61: hr_utility.set_location('Entering:'|| l_proc, 10);
62: --
63: -- Ensure that all the mandatory parameter are not null
64: --
65: hr_api.mandatory_arg_error
66: (p_api_name => l_proc
67: ,p_argument => 'action_information_id'
68: ,p_argument_value => p_action_information_id
69: );
84: close csr_sec_grp;
85: --
86: -- Set the security_group_id in CLIENT_INFO
87: --
88: hr_api.set_security_group_id
89: (p_security_group_id => l_security_group_id
90: );
91: --
92: hr_utility.set_location(' Leaving:'|| l_proc, 20);
135: hr_utility.set_location('Entering:'|| l_proc, 10);
136: --
137: -- Ensure that all the mandatory parameter are not null
138: --
139: hr_api.mandatory_arg_error
140: (p_api_name => l_proc
141: ,p_argument => 'action_information_id'
142: ,p_argument_value => p_action_information_id
143: );
141: ,p_argument => 'action_information_id'
142: ,p_argument_value => p_action_information_id
143: );
144: --
145: if ( nvl(pay_aif_bus.g_action_information_id, hr_api.g_number)
146: = p_action_information_id) then
147: --
148: -- The legislation code has already been found with a previous
149: -- call to this function. Just return the value in the global
218: hr_utility.set_location('Entering:'|| l_proc, 10);
219: --
220: -- Ensure that all the mandatory parameter are not null
221: --
222: hr_api.mandatory_arg_error
223: (p_api_name => l_proc
224: ,p_argument => 'action_context_id'
225: ,p_argument_value => p_action_context_id
226: );
223: (p_api_name => l_proc
224: ,p_argument => 'action_context_id'
225: ,p_argument_value => p_action_context_id
226: );
227: hr_api.mandatory_arg_error
228: (p_api_name => l_proc
229: ,p_argument => 'action_context_type'
230: ,p_argument_value => p_action_context_type
231: );
229: ,p_argument => 'action_context_type'
230: ,p_argument_value => p_action_context_type
231: );
232: --
233: if ((nvl(pay_aif_bus.g_action_context_id,hr_api.g_number) = p_action_context_id)
234: and (nvl(pay_aif_bus.g_action_context_type,hr_api.g_varchar2) = p_action_context_type)) then
235: --
236: --
237: -- Legislation code is for same row as cached values therefore return
230: ,p_argument_value => p_action_context_type
231: );
232: --
233: if ((nvl(pay_aif_bus.g_action_context_id,hr_api.g_number) = p_action_context_id)
234: and (nvl(pay_aif_bus.g_action_context_type,hr_api.g_varchar2) = p_action_context_type)) then
235: --
236: --
237: -- Legislation code is for same row as cached values therefore return
238: -- cached legislation code
340: begin
341: hr_utility.set_location('Entering:'||l_proc,10);
342: --
343: if ((p_rec.action_information_id is not null) and (
344: nvl(pay_aif_shd.g_old_rec.action_information_id, hr_api.g_number) <>
345: nvl(p_rec.action_information_id, hr_api.g_number) or
346: nvl(pay_aif_shd.g_old_rec.effective_date, hr_api.g_date) <>
347: nvl(p_rec.effective_date, hr_api.g_date) or
348: nvl(pay_aif_shd.g_old_rec.assignment_id, hr_api.g_number) <>
341: hr_utility.set_location('Entering:'||l_proc,10);
342: --
343: if ((p_rec.action_information_id is not null) and (
344: nvl(pay_aif_shd.g_old_rec.action_information_id, hr_api.g_number) <>
345: nvl(p_rec.action_information_id, hr_api.g_number) or
346: nvl(pay_aif_shd.g_old_rec.effective_date, hr_api.g_date) <>
347: nvl(p_rec.effective_date, hr_api.g_date) or
348: nvl(pay_aif_shd.g_old_rec.assignment_id, hr_api.g_number) <>
349: nvl(p_rec.assignment_id, hr_api.g_number) or
342: --
343: if ((p_rec.action_information_id is not null) and (
344: nvl(pay_aif_shd.g_old_rec.action_information_id, hr_api.g_number) <>
345: nvl(p_rec.action_information_id, hr_api.g_number) or
346: nvl(pay_aif_shd.g_old_rec.effective_date, hr_api.g_date) <>
347: nvl(p_rec.effective_date, hr_api.g_date) or
348: nvl(pay_aif_shd.g_old_rec.assignment_id, hr_api.g_number) <>
349: nvl(p_rec.assignment_id, hr_api.g_number) or
350: nvl(pay_aif_shd.g_old_rec.action_information_category, hr_api.g_varchar2) <>
343: if ((p_rec.action_information_id is not null) and (
344: nvl(pay_aif_shd.g_old_rec.action_information_id, hr_api.g_number) <>
345: nvl(p_rec.action_information_id, hr_api.g_number) or
346: nvl(pay_aif_shd.g_old_rec.effective_date, hr_api.g_date) <>
347: nvl(p_rec.effective_date, hr_api.g_date) or
348: nvl(pay_aif_shd.g_old_rec.assignment_id, hr_api.g_number) <>
349: nvl(p_rec.assignment_id, hr_api.g_number) or
350: nvl(pay_aif_shd.g_old_rec.action_information_category, hr_api.g_varchar2) <>
351: nvl(p_rec.action_information_category, hr_api.g_varchar2) or
344: nvl(pay_aif_shd.g_old_rec.action_information_id, hr_api.g_number) <>
345: nvl(p_rec.action_information_id, hr_api.g_number) or
346: nvl(pay_aif_shd.g_old_rec.effective_date, hr_api.g_date) <>
347: nvl(p_rec.effective_date, hr_api.g_date) or
348: nvl(pay_aif_shd.g_old_rec.assignment_id, hr_api.g_number) <>
349: nvl(p_rec.assignment_id, hr_api.g_number) or
350: nvl(pay_aif_shd.g_old_rec.action_information_category, hr_api.g_varchar2) <>
351: nvl(p_rec.action_information_category, hr_api.g_varchar2) or
352: nvl(pay_aif_shd.g_old_rec.action_information1, hr_api.g_varchar2) <>
345: nvl(p_rec.action_information_id, hr_api.g_number) or
346: nvl(pay_aif_shd.g_old_rec.effective_date, hr_api.g_date) <>
347: nvl(p_rec.effective_date, hr_api.g_date) or
348: nvl(pay_aif_shd.g_old_rec.assignment_id, hr_api.g_number) <>
349: nvl(p_rec.assignment_id, hr_api.g_number) or
350: nvl(pay_aif_shd.g_old_rec.action_information_category, hr_api.g_varchar2) <>
351: nvl(p_rec.action_information_category, hr_api.g_varchar2) or
352: nvl(pay_aif_shd.g_old_rec.action_information1, hr_api.g_varchar2) <>
353: nvl(p_rec.action_information1, hr_api.g_varchar2) or
346: nvl(pay_aif_shd.g_old_rec.effective_date, hr_api.g_date) <>
347: nvl(p_rec.effective_date, hr_api.g_date) or
348: nvl(pay_aif_shd.g_old_rec.assignment_id, hr_api.g_number) <>
349: nvl(p_rec.assignment_id, hr_api.g_number) or
350: nvl(pay_aif_shd.g_old_rec.action_information_category, hr_api.g_varchar2) <>
351: nvl(p_rec.action_information_category, hr_api.g_varchar2) or
352: nvl(pay_aif_shd.g_old_rec.action_information1, hr_api.g_varchar2) <>
353: nvl(p_rec.action_information1, hr_api.g_varchar2) or
354: nvl(pay_aif_shd.g_old_rec.action_information2, hr_api.g_varchar2) <>
347: nvl(p_rec.effective_date, hr_api.g_date) or
348: nvl(pay_aif_shd.g_old_rec.assignment_id, hr_api.g_number) <>
349: nvl(p_rec.assignment_id, hr_api.g_number) or
350: nvl(pay_aif_shd.g_old_rec.action_information_category, hr_api.g_varchar2) <>
351: nvl(p_rec.action_information_category, hr_api.g_varchar2) or
352: nvl(pay_aif_shd.g_old_rec.action_information1, hr_api.g_varchar2) <>
353: nvl(p_rec.action_information1, hr_api.g_varchar2) or
354: nvl(pay_aif_shd.g_old_rec.action_information2, hr_api.g_varchar2) <>
355: nvl(p_rec.action_information2, hr_api.g_varchar2) or
348: nvl(pay_aif_shd.g_old_rec.assignment_id, hr_api.g_number) <>
349: nvl(p_rec.assignment_id, hr_api.g_number) or
350: nvl(pay_aif_shd.g_old_rec.action_information_category, hr_api.g_varchar2) <>
351: nvl(p_rec.action_information_category, hr_api.g_varchar2) or
352: nvl(pay_aif_shd.g_old_rec.action_information1, hr_api.g_varchar2) <>
353: nvl(p_rec.action_information1, hr_api.g_varchar2) or
354: nvl(pay_aif_shd.g_old_rec.action_information2, hr_api.g_varchar2) <>
355: nvl(p_rec.action_information2, hr_api.g_varchar2) or
356: nvl(pay_aif_shd.g_old_rec.action_information3, hr_api.g_varchar2) <>
349: nvl(p_rec.assignment_id, hr_api.g_number) or
350: nvl(pay_aif_shd.g_old_rec.action_information_category, hr_api.g_varchar2) <>
351: nvl(p_rec.action_information_category, hr_api.g_varchar2) or
352: nvl(pay_aif_shd.g_old_rec.action_information1, hr_api.g_varchar2) <>
353: nvl(p_rec.action_information1, hr_api.g_varchar2) or
354: nvl(pay_aif_shd.g_old_rec.action_information2, hr_api.g_varchar2) <>
355: nvl(p_rec.action_information2, hr_api.g_varchar2) or
356: nvl(pay_aif_shd.g_old_rec.action_information3, hr_api.g_varchar2) <>
357: nvl(p_rec.action_information3, hr_api.g_varchar2) or
350: nvl(pay_aif_shd.g_old_rec.action_information_category, hr_api.g_varchar2) <>
351: nvl(p_rec.action_information_category, hr_api.g_varchar2) or
352: nvl(pay_aif_shd.g_old_rec.action_information1, hr_api.g_varchar2) <>
353: nvl(p_rec.action_information1, hr_api.g_varchar2) or
354: nvl(pay_aif_shd.g_old_rec.action_information2, hr_api.g_varchar2) <>
355: nvl(p_rec.action_information2, hr_api.g_varchar2) or
356: nvl(pay_aif_shd.g_old_rec.action_information3, hr_api.g_varchar2) <>
357: nvl(p_rec.action_information3, hr_api.g_varchar2) or
358: nvl(pay_aif_shd.g_old_rec.action_information4, hr_api.g_varchar2) <>
351: nvl(p_rec.action_information_category, hr_api.g_varchar2) or
352: nvl(pay_aif_shd.g_old_rec.action_information1, hr_api.g_varchar2) <>
353: nvl(p_rec.action_information1, hr_api.g_varchar2) or
354: nvl(pay_aif_shd.g_old_rec.action_information2, hr_api.g_varchar2) <>
355: nvl(p_rec.action_information2, hr_api.g_varchar2) or
356: nvl(pay_aif_shd.g_old_rec.action_information3, hr_api.g_varchar2) <>
357: nvl(p_rec.action_information3, hr_api.g_varchar2) or
358: nvl(pay_aif_shd.g_old_rec.action_information4, hr_api.g_varchar2) <>
359: nvl(p_rec.action_information4, hr_api.g_varchar2) or
352: nvl(pay_aif_shd.g_old_rec.action_information1, hr_api.g_varchar2) <>
353: nvl(p_rec.action_information1, hr_api.g_varchar2) or
354: nvl(pay_aif_shd.g_old_rec.action_information2, hr_api.g_varchar2) <>
355: nvl(p_rec.action_information2, hr_api.g_varchar2) or
356: nvl(pay_aif_shd.g_old_rec.action_information3, hr_api.g_varchar2) <>
357: nvl(p_rec.action_information3, hr_api.g_varchar2) or
358: nvl(pay_aif_shd.g_old_rec.action_information4, hr_api.g_varchar2) <>
359: nvl(p_rec.action_information4, hr_api.g_varchar2) or
360: nvl(pay_aif_shd.g_old_rec.action_information5, hr_api.g_varchar2) <>
353: nvl(p_rec.action_information1, hr_api.g_varchar2) or
354: nvl(pay_aif_shd.g_old_rec.action_information2, hr_api.g_varchar2) <>
355: nvl(p_rec.action_information2, hr_api.g_varchar2) or
356: nvl(pay_aif_shd.g_old_rec.action_information3, hr_api.g_varchar2) <>
357: nvl(p_rec.action_information3, hr_api.g_varchar2) or
358: nvl(pay_aif_shd.g_old_rec.action_information4, hr_api.g_varchar2) <>
359: nvl(p_rec.action_information4, hr_api.g_varchar2) or
360: nvl(pay_aif_shd.g_old_rec.action_information5, hr_api.g_varchar2) <>
361: nvl(p_rec.action_information5, hr_api.g_varchar2) or
354: nvl(pay_aif_shd.g_old_rec.action_information2, hr_api.g_varchar2) <>
355: nvl(p_rec.action_information2, hr_api.g_varchar2) or
356: nvl(pay_aif_shd.g_old_rec.action_information3, hr_api.g_varchar2) <>
357: nvl(p_rec.action_information3, hr_api.g_varchar2) or
358: nvl(pay_aif_shd.g_old_rec.action_information4, hr_api.g_varchar2) <>
359: nvl(p_rec.action_information4, hr_api.g_varchar2) or
360: nvl(pay_aif_shd.g_old_rec.action_information5, hr_api.g_varchar2) <>
361: nvl(p_rec.action_information5, hr_api.g_varchar2) or
362: nvl(pay_aif_shd.g_old_rec.action_information6, hr_api.g_varchar2) <>
355: nvl(p_rec.action_information2, hr_api.g_varchar2) or
356: nvl(pay_aif_shd.g_old_rec.action_information3, hr_api.g_varchar2) <>
357: nvl(p_rec.action_information3, hr_api.g_varchar2) or
358: nvl(pay_aif_shd.g_old_rec.action_information4, hr_api.g_varchar2) <>
359: nvl(p_rec.action_information4, hr_api.g_varchar2) or
360: nvl(pay_aif_shd.g_old_rec.action_information5, hr_api.g_varchar2) <>
361: nvl(p_rec.action_information5, hr_api.g_varchar2) or
362: nvl(pay_aif_shd.g_old_rec.action_information6, hr_api.g_varchar2) <>
363: nvl(p_rec.action_information6, hr_api.g_varchar2) or
356: nvl(pay_aif_shd.g_old_rec.action_information3, hr_api.g_varchar2) <>
357: nvl(p_rec.action_information3, hr_api.g_varchar2) or
358: nvl(pay_aif_shd.g_old_rec.action_information4, hr_api.g_varchar2) <>
359: nvl(p_rec.action_information4, hr_api.g_varchar2) or
360: nvl(pay_aif_shd.g_old_rec.action_information5, hr_api.g_varchar2) <>
361: nvl(p_rec.action_information5, hr_api.g_varchar2) or
362: nvl(pay_aif_shd.g_old_rec.action_information6, hr_api.g_varchar2) <>
363: nvl(p_rec.action_information6, hr_api.g_varchar2) or
364: nvl(pay_aif_shd.g_old_rec.action_information7, hr_api.g_varchar2) <>
357: nvl(p_rec.action_information3, hr_api.g_varchar2) or
358: nvl(pay_aif_shd.g_old_rec.action_information4, hr_api.g_varchar2) <>
359: nvl(p_rec.action_information4, hr_api.g_varchar2) or
360: nvl(pay_aif_shd.g_old_rec.action_information5, hr_api.g_varchar2) <>
361: nvl(p_rec.action_information5, hr_api.g_varchar2) or
362: nvl(pay_aif_shd.g_old_rec.action_information6, hr_api.g_varchar2) <>
363: nvl(p_rec.action_information6, hr_api.g_varchar2) or
364: nvl(pay_aif_shd.g_old_rec.action_information7, hr_api.g_varchar2) <>
365: nvl(p_rec.action_information7, hr_api.g_varchar2) or
358: nvl(pay_aif_shd.g_old_rec.action_information4, hr_api.g_varchar2) <>
359: nvl(p_rec.action_information4, hr_api.g_varchar2) or
360: nvl(pay_aif_shd.g_old_rec.action_information5, hr_api.g_varchar2) <>
361: nvl(p_rec.action_information5, hr_api.g_varchar2) or
362: nvl(pay_aif_shd.g_old_rec.action_information6, hr_api.g_varchar2) <>
363: nvl(p_rec.action_information6, hr_api.g_varchar2) or
364: nvl(pay_aif_shd.g_old_rec.action_information7, hr_api.g_varchar2) <>
365: nvl(p_rec.action_information7, hr_api.g_varchar2) or
366: nvl(pay_aif_shd.g_old_rec.action_information8, hr_api.g_varchar2) <>
359: nvl(p_rec.action_information4, hr_api.g_varchar2) or
360: nvl(pay_aif_shd.g_old_rec.action_information5, hr_api.g_varchar2) <>
361: nvl(p_rec.action_information5, hr_api.g_varchar2) or
362: nvl(pay_aif_shd.g_old_rec.action_information6, hr_api.g_varchar2) <>
363: nvl(p_rec.action_information6, hr_api.g_varchar2) or
364: nvl(pay_aif_shd.g_old_rec.action_information7, hr_api.g_varchar2) <>
365: nvl(p_rec.action_information7, hr_api.g_varchar2) or
366: nvl(pay_aif_shd.g_old_rec.action_information8, hr_api.g_varchar2) <>
367: nvl(p_rec.action_information8, hr_api.g_varchar2) or
360: nvl(pay_aif_shd.g_old_rec.action_information5, hr_api.g_varchar2) <>
361: nvl(p_rec.action_information5, hr_api.g_varchar2) or
362: nvl(pay_aif_shd.g_old_rec.action_information6, hr_api.g_varchar2) <>
363: nvl(p_rec.action_information6, hr_api.g_varchar2) or
364: nvl(pay_aif_shd.g_old_rec.action_information7, hr_api.g_varchar2) <>
365: nvl(p_rec.action_information7, hr_api.g_varchar2) or
366: nvl(pay_aif_shd.g_old_rec.action_information8, hr_api.g_varchar2) <>
367: nvl(p_rec.action_information8, hr_api.g_varchar2) or
368: nvl(pay_aif_shd.g_old_rec.action_information9, hr_api.g_varchar2) <>
361: nvl(p_rec.action_information5, hr_api.g_varchar2) or
362: nvl(pay_aif_shd.g_old_rec.action_information6, hr_api.g_varchar2) <>
363: nvl(p_rec.action_information6, hr_api.g_varchar2) or
364: nvl(pay_aif_shd.g_old_rec.action_information7, hr_api.g_varchar2) <>
365: nvl(p_rec.action_information7, hr_api.g_varchar2) or
366: nvl(pay_aif_shd.g_old_rec.action_information8, hr_api.g_varchar2) <>
367: nvl(p_rec.action_information8, hr_api.g_varchar2) or
368: nvl(pay_aif_shd.g_old_rec.action_information9, hr_api.g_varchar2) <>
369: nvl(p_rec.action_information9, hr_api.g_varchar2) or
362: nvl(pay_aif_shd.g_old_rec.action_information6, hr_api.g_varchar2) <>
363: nvl(p_rec.action_information6, hr_api.g_varchar2) or
364: nvl(pay_aif_shd.g_old_rec.action_information7, hr_api.g_varchar2) <>
365: nvl(p_rec.action_information7, hr_api.g_varchar2) or
366: nvl(pay_aif_shd.g_old_rec.action_information8, hr_api.g_varchar2) <>
367: nvl(p_rec.action_information8, hr_api.g_varchar2) or
368: nvl(pay_aif_shd.g_old_rec.action_information9, hr_api.g_varchar2) <>
369: nvl(p_rec.action_information9, hr_api.g_varchar2) or
370: nvl(pay_aif_shd.g_old_rec.action_information10, hr_api.g_varchar2) <>
363: nvl(p_rec.action_information6, hr_api.g_varchar2) or
364: nvl(pay_aif_shd.g_old_rec.action_information7, hr_api.g_varchar2) <>
365: nvl(p_rec.action_information7, hr_api.g_varchar2) or
366: nvl(pay_aif_shd.g_old_rec.action_information8, hr_api.g_varchar2) <>
367: nvl(p_rec.action_information8, hr_api.g_varchar2) or
368: nvl(pay_aif_shd.g_old_rec.action_information9, hr_api.g_varchar2) <>
369: nvl(p_rec.action_information9, hr_api.g_varchar2) or
370: nvl(pay_aif_shd.g_old_rec.action_information10, hr_api.g_varchar2) <>
371: nvl(p_rec.action_information10, hr_api.g_varchar2) or
364: nvl(pay_aif_shd.g_old_rec.action_information7, hr_api.g_varchar2) <>
365: nvl(p_rec.action_information7, hr_api.g_varchar2) or
366: nvl(pay_aif_shd.g_old_rec.action_information8, hr_api.g_varchar2) <>
367: nvl(p_rec.action_information8, hr_api.g_varchar2) or
368: nvl(pay_aif_shd.g_old_rec.action_information9, hr_api.g_varchar2) <>
369: nvl(p_rec.action_information9, hr_api.g_varchar2) or
370: nvl(pay_aif_shd.g_old_rec.action_information10, hr_api.g_varchar2) <>
371: nvl(p_rec.action_information10, hr_api.g_varchar2) or
372: nvl(pay_aif_shd.g_old_rec.action_information11, hr_api.g_varchar2) <>
365: nvl(p_rec.action_information7, hr_api.g_varchar2) or
366: nvl(pay_aif_shd.g_old_rec.action_information8, hr_api.g_varchar2) <>
367: nvl(p_rec.action_information8, hr_api.g_varchar2) or
368: nvl(pay_aif_shd.g_old_rec.action_information9, hr_api.g_varchar2) <>
369: nvl(p_rec.action_information9, hr_api.g_varchar2) or
370: nvl(pay_aif_shd.g_old_rec.action_information10, hr_api.g_varchar2) <>
371: nvl(p_rec.action_information10, hr_api.g_varchar2) or
372: nvl(pay_aif_shd.g_old_rec.action_information11, hr_api.g_varchar2) <>
373: nvl(p_rec.action_information11, hr_api.g_varchar2) or
366: nvl(pay_aif_shd.g_old_rec.action_information8, hr_api.g_varchar2) <>
367: nvl(p_rec.action_information8, hr_api.g_varchar2) or
368: nvl(pay_aif_shd.g_old_rec.action_information9, hr_api.g_varchar2) <>
369: nvl(p_rec.action_information9, hr_api.g_varchar2) or
370: nvl(pay_aif_shd.g_old_rec.action_information10, hr_api.g_varchar2) <>
371: nvl(p_rec.action_information10, hr_api.g_varchar2) or
372: nvl(pay_aif_shd.g_old_rec.action_information11, hr_api.g_varchar2) <>
373: nvl(p_rec.action_information11, hr_api.g_varchar2) or
374: nvl(pay_aif_shd.g_old_rec.action_information12, hr_api.g_varchar2) <>
367: nvl(p_rec.action_information8, hr_api.g_varchar2) or
368: nvl(pay_aif_shd.g_old_rec.action_information9, hr_api.g_varchar2) <>
369: nvl(p_rec.action_information9, hr_api.g_varchar2) or
370: nvl(pay_aif_shd.g_old_rec.action_information10, hr_api.g_varchar2) <>
371: nvl(p_rec.action_information10, hr_api.g_varchar2) or
372: nvl(pay_aif_shd.g_old_rec.action_information11, hr_api.g_varchar2) <>
373: nvl(p_rec.action_information11, hr_api.g_varchar2) or
374: nvl(pay_aif_shd.g_old_rec.action_information12, hr_api.g_varchar2) <>
375: nvl(p_rec.action_information12, hr_api.g_varchar2) or
368: nvl(pay_aif_shd.g_old_rec.action_information9, hr_api.g_varchar2) <>
369: nvl(p_rec.action_information9, hr_api.g_varchar2) or
370: nvl(pay_aif_shd.g_old_rec.action_information10, hr_api.g_varchar2) <>
371: nvl(p_rec.action_information10, hr_api.g_varchar2) or
372: nvl(pay_aif_shd.g_old_rec.action_information11, hr_api.g_varchar2) <>
373: nvl(p_rec.action_information11, hr_api.g_varchar2) or
374: nvl(pay_aif_shd.g_old_rec.action_information12, hr_api.g_varchar2) <>
375: nvl(p_rec.action_information12, hr_api.g_varchar2) or
376: nvl(pay_aif_shd.g_old_rec.action_information13, hr_api.g_varchar2) <>
369: nvl(p_rec.action_information9, hr_api.g_varchar2) or
370: nvl(pay_aif_shd.g_old_rec.action_information10, hr_api.g_varchar2) <>
371: nvl(p_rec.action_information10, hr_api.g_varchar2) or
372: nvl(pay_aif_shd.g_old_rec.action_information11, hr_api.g_varchar2) <>
373: nvl(p_rec.action_information11, hr_api.g_varchar2) or
374: nvl(pay_aif_shd.g_old_rec.action_information12, hr_api.g_varchar2) <>
375: nvl(p_rec.action_information12, hr_api.g_varchar2) or
376: nvl(pay_aif_shd.g_old_rec.action_information13, hr_api.g_varchar2) <>
377: nvl(p_rec.action_information13, hr_api.g_varchar2) or
370: nvl(pay_aif_shd.g_old_rec.action_information10, hr_api.g_varchar2) <>
371: nvl(p_rec.action_information10, hr_api.g_varchar2) or
372: nvl(pay_aif_shd.g_old_rec.action_information11, hr_api.g_varchar2) <>
373: nvl(p_rec.action_information11, hr_api.g_varchar2) or
374: nvl(pay_aif_shd.g_old_rec.action_information12, hr_api.g_varchar2) <>
375: nvl(p_rec.action_information12, hr_api.g_varchar2) or
376: nvl(pay_aif_shd.g_old_rec.action_information13, hr_api.g_varchar2) <>
377: nvl(p_rec.action_information13, hr_api.g_varchar2) or
378: nvl(pay_aif_shd.g_old_rec.action_information14, hr_api.g_varchar2) <>
371: nvl(p_rec.action_information10, hr_api.g_varchar2) or
372: nvl(pay_aif_shd.g_old_rec.action_information11, hr_api.g_varchar2) <>
373: nvl(p_rec.action_information11, hr_api.g_varchar2) or
374: nvl(pay_aif_shd.g_old_rec.action_information12, hr_api.g_varchar2) <>
375: nvl(p_rec.action_information12, hr_api.g_varchar2) or
376: nvl(pay_aif_shd.g_old_rec.action_information13, hr_api.g_varchar2) <>
377: nvl(p_rec.action_information13, hr_api.g_varchar2) or
378: nvl(pay_aif_shd.g_old_rec.action_information14, hr_api.g_varchar2) <>
379: nvl(p_rec.action_information14, hr_api.g_varchar2) or
372: nvl(pay_aif_shd.g_old_rec.action_information11, hr_api.g_varchar2) <>
373: nvl(p_rec.action_information11, hr_api.g_varchar2) or
374: nvl(pay_aif_shd.g_old_rec.action_information12, hr_api.g_varchar2) <>
375: nvl(p_rec.action_information12, hr_api.g_varchar2) or
376: nvl(pay_aif_shd.g_old_rec.action_information13, hr_api.g_varchar2) <>
377: nvl(p_rec.action_information13, hr_api.g_varchar2) or
378: nvl(pay_aif_shd.g_old_rec.action_information14, hr_api.g_varchar2) <>
379: nvl(p_rec.action_information14, hr_api.g_varchar2) or
380: nvl(pay_aif_shd.g_old_rec.action_information15, hr_api.g_varchar2) <>
373: nvl(p_rec.action_information11, hr_api.g_varchar2) or
374: nvl(pay_aif_shd.g_old_rec.action_information12, hr_api.g_varchar2) <>
375: nvl(p_rec.action_information12, hr_api.g_varchar2) or
376: nvl(pay_aif_shd.g_old_rec.action_information13, hr_api.g_varchar2) <>
377: nvl(p_rec.action_information13, hr_api.g_varchar2) or
378: nvl(pay_aif_shd.g_old_rec.action_information14, hr_api.g_varchar2) <>
379: nvl(p_rec.action_information14, hr_api.g_varchar2) or
380: nvl(pay_aif_shd.g_old_rec.action_information15, hr_api.g_varchar2) <>
381: nvl(p_rec.action_information15, hr_api.g_varchar2) or
374: nvl(pay_aif_shd.g_old_rec.action_information12, hr_api.g_varchar2) <>
375: nvl(p_rec.action_information12, hr_api.g_varchar2) or
376: nvl(pay_aif_shd.g_old_rec.action_information13, hr_api.g_varchar2) <>
377: nvl(p_rec.action_information13, hr_api.g_varchar2) or
378: nvl(pay_aif_shd.g_old_rec.action_information14, hr_api.g_varchar2) <>
379: nvl(p_rec.action_information14, hr_api.g_varchar2) or
380: nvl(pay_aif_shd.g_old_rec.action_information15, hr_api.g_varchar2) <>
381: nvl(p_rec.action_information15, hr_api.g_varchar2) or
382: nvl(pay_aif_shd.g_old_rec.action_information16, hr_api.g_varchar2) <>
375: nvl(p_rec.action_information12, hr_api.g_varchar2) or
376: nvl(pay_aif_shd.g_old_rec.action_information13, hr_api.g_varchar2) <>
377: nvl(p_rec.action_information13, hr_api.g_varchar2) or
378: nvl(pay_aif_shd.g_old_rec.action_information14, hr_api.g_varchar2) <>
379: nvl(p_rec.action_information14, hr_api.g_varchar2) or
380: nvl(pay_aif_shd.g_old_rec.action_information15, hr_api.g_varchar2) <>
381: nvl(p_rec.action_information15, hr_api.g_varchar2) or
382: nvl(pay_aif_shd.g_old_rec.action_information16, hr_api.g_varchar2) <>
383: nvl(p_rec.action_information16, hr_api.g_varchar2) or
376: nvl(pay_aif_shd.g_old_rec.action_information13, hr_api.g_varchar2) <>
377: nvl(p_rec.action_information13, hr_api.g_varchar2) or
378: nvl(pay_aif_shd.g_old_rec.action_information14, hr_api.g_varchar2) <>
379: nvl(p_rec.action_information14, hr_api.g_varchar2) or
380: nvl(pay_aif_shd.g_old_rec.action_information15, hr_api.g_varchar2) <>
381: nvl(p_rec.action_information15, hr_api.g_varchar2) or
382: nvl(pay_aif_shd.g_old_rec.action_information16, hr_api.g_varchar2) <>
383: nvl(p_rec.action_information16, hr_api.g_varchar2) or
384: nvl(pay_aif_shd.g_old_rec.action_information17, hr_api.g_varchar2) <>
377: nvl(p_rec.action_information13, hr_api.g_varchar2) or
378: nvl(pay_aif_shd.g_old_rec.action_information14, hr_api.g_varchar2) <>
379: nvl(p_rec.action_information14, hr_api.g_varchar2) or
380: nvl(pay_aif_shd.g_old_rec.action_information15, hr_api.g_varchar2) <>
381: nvl(p_rec.action_information15, hr_api.g_varchar2) or
382: nvl(pay_aif_shd.g_old_rec.action_information16, hr_api.g_varchar2) <>
383: nvl(p_rec.action_information16, hr_api.g_varchar2) or
384: nvl(pay_aif_shd.g_old_rec.action_information17, hr_api.g_varchar2) <>
385: nvl(p_rec.action_information17, hr_api.g_varchar2) or
378: nvl(pay_aif_shd.g_old_rec.action_information14, hr_api.g_varchar2) <>
379: nvl(p_rec.action_information14, hr_api.g_varchar2) or
380: nvl(pay_aif_shd.g_old_rec.action_information15, hr_api.g_varchar2) <>
381: nvl(p_rec.action_information15, hr_api.g_varchar2) or
382: nvl(pay_aif_shd.g_old_rec.action_information16, hr_api.g_varchar2) <>
383: nvl(p_rec.action_information16, hr_api.g_varchar2) or
384: nvl(pay_aif_shd.g_old_rec.action_information17, hr_api.g_varchar2) <>
385: nvl(p_rec.action_information17, hr_api.g_varchar2) or
386: nvl(pay_aif_shd.g_old_rec.action_information18, hr_api.g_varchar2) <>
379: nvl(p_rec.action_information14, hr_api.g_varchar2) or
380: nvl(pay_aif_shd.g_old_rec.action_information15, hr_api.g_varchar2) <>
381: nvl(p_rec.action_information15, hr_api.g_varchar2) or
382: nvl(pay_aif_shd.g_old_rec.action_information16, hr_api.g_varchar2) <>
383: nvl(p_rec.action_information16, hr_api.g_varchar2) or
384: nvl(pay_aif_shd.g_old_rec.action_information17, hr_api.g_varchar2) <>
385: nvl(p_rec.action_information17, hr_api.g_varchar2) or
386: nvl(pay_aif_shd.g_old_rec.action_information18, hr_api.g_varchar2) <>
387: nvl(p_rec.action_information18, hr_api.g_varchar2) or
380: nvl(pay_aif_shd.g_old_rec.action_information15, hr_api.g_varchar2) <>
381: nvl(p_rec.action_information15, hr_api.g_varchar2) or
382: nvl(pay_aif_shd.g_old_rec.action_information16, hr_api.g_varchar2) <>
383: nvl(p_rec.action_information16, hr_api.g_varchar2) or
384: nvl(pay_aif_shd.g_old_rec.action_information17, hr_api.g_varchar2) <>
385: nvl(p_rec.action_information17, hr_api.g_varchar2) or
386: nvl(pay_aif_shd.g_old_rec.action_information18, hr_api.g_varchar2) <>
387: nvl(p_rec.action_information18, hr_api.g_varchar2) or
388: nvl(pay_aif_shd.g_old_rec.action_information19, hr_api.g_varchar2) <>
381: nvl(p_rec.action_information15, hr_api.g_varchar2) or
382: nvl(pay_aif_shd.g_old_rec.action_information16, hr_api.g_varchar2) <>
383: nvl(p_rec.action_information16, hr_api.g_varchar2) or
384: nvl(pay_aif_shd.g_old_rec.action_information17, hr_api.g_varchar2) <>
385: nvl(p_rec.action_information17, hr_api.g_varchar2) or
386: nvl(pay_aif_shd.g_old_rec.action_information18, hr_api.g_varchar2) <>
387: nvl(p_rec.action_information18, hr_api.g_varchar2) or
388: nvl(pay_aif_shd.g_old_rec.action_information19, hr_api.g_varchar2) <>
389: nvl(p_rec.action_information19, hr_api.g_varchar2) or
382: nvl(pay_aif_shd.g_old_rec.action_information16, hr_api.g_varchar2) <>
383: nvl(p_rec.action_information16, hr_api.g_varchar2) or
384: nvl(pay_aif_shd.g_old_rec.action_information17, hr_api.g_varchar2) <>
385: nvl(p_rec.action_information17, hr_api.g_varchar2) or
386: nvl(pay_aif_shd.g_old_rec.action_information18, hr_api.g_varchar2) <>
387: nvl(p_rec.action_information18, hr_api.g_varchar2) or
388: nvl(pay_aif_shd.g_old_rec.action_information19, hr_api.g_varchar2) <>
389: nvl(p_rec.action_information19, hr_api.g_varchar2) or
390: nvl(pay_aif_shd.g_old_rec.action_information20, hr_api.g_varchar2) <>
383: nvl(p_rec.action_information16, hr_api.g_varchar2) or
384: nvl(pay_aif_shd.g_old_rec.action_information17, hr_api.g_varchar2) <>
385: nvl(p_rec.action_information17, hr_api.g_varchar2) or
386: nvl(pay_aif_shd.g_old_rec.action_information18, hr_api.g_varchar2) <>
387: nvl(p_rec.action_information18, hr_api.g_varchar2) or
388: nvl(pay_aif_shd.g_old_rec.action_information19, hr_api.g_varchar2) <>
389: nvl(p_rec.action_information19, hr_api.g_varchar2) or
390: nvl(pay_aif_shd.g_old_rec.action_information20, hr_api.g_varchar2) <>
391: nvl(p_rec.action_information20, hr_api.g_varchar2) or
384: nvl(pay_aif_shd.g_old_rec.action_information17, hr_api.g_varchar2) <>
385: nvl(p_rec.action_information17, hr_api.g_varchar2) or
386: nvl(pay_aif_shd.g_old_rec.action_information18, hr_api.g_varchar2) <>
387: nvl(p_rec.action_information18, hr_api.g_varchar2) or
388: nvl(pay_aif_shd.g_old_rec.action_information19, hr_api.g_varchar2) <>
389: nvl(p_rec.action_information19, hr_api.g_varchar2) or
390: nvl(pay_aif_shd.g_old_rec.action_information20, hr_api.g_varchar2) <>
391: nvl(p_rec.action_information20, hr_api.g_varchar2) or
392: nvl(pay_aif_shd.g_old_rec.action_information21, hr_api.g_varchar2) <>
385: nvl(p_rec.action_information17, hr_api.g_varchar2) or
386: nvl(pay_aif_shd.g_old_rec.action_information18, hr_api.g_varchar2) <>
387: nvl(p_rec.action_information18, hr_api.g_varchar2) or
388: nvl(pay_aif_shd.g_old_rec.action_information19, hr_api.g_varchar2) <>
389: nvl(p_rec.action_information19, hr_api.g_varchar2) or
390: nvl(pay_aif_shd.g_old_rec.action_information20, hr_api.g_varchar2) <>
391: nvl(p_rec.action_information20, hr_api.g_varchar2) or
392: nvl(pay_aif_shd.g_old_rec.action_information21, hr_api.g_varchar2) <>
393: nvl(p_rec.action_information21, hr_api.g_varchar2) or
386: nvl(pay_aif_shd.g_old_rec.action_information18, hr_api.g_varchar2) <>
387: nvl(p_rec.action_information18, hr_api.g_varchar2) or
388: nvl(pay_aif_shd.g_old_rec.action_information19, hr_api.g_varchar2) <>
389: nvl(p_rec.action_information19, hr_api.g_varchar2) or
390: nvl(pay_aif_shd.g_old_rec.action_information20, hr_api.g_varchar2) <>
391: nvl(p_rec.action_information20, hr_api.g_varchar2) or
392: nvl(pay_aif_shd.g_old_rec.action_information21, hr_api.g_varchar2) <>
393: nvl(p_rec.action_information21, hr_api.g_varchar2) or
394: nvl(pay_aif_shd.g_old_rec.action_information22, hr_api.g_varchar2) <>
387: nvl(p_rec.action_information18, hr_api.g_varchar2) or
388: nvl(pay_aif_shd.g_old_rec.action_information19, hr_api.g_varchar2) <>
389: nvl(p_rec.action_information19, hr_api.g_varchar2) or
390: nvl(pay_aif_shd.g_old_rec.action_information20, hr_api.g_varchar2) <>
391: nvl(p_rec.action_information20, hr_api.g_varchar2) or
392: nvl(pay_aif_shd.g_old_rec.action_information21, hr_api.g_varchar2) <>
393: nvl(p_rec.action_information21, hr_api.g_varchar2) or
394: nvl(pay_aif_shd.g_old_rec.action_information22, hr_api.g_varchar2) <>
395: nvl(p_rec.action_information22, hr_api.g_varchar2) or
388: nvl(pay_aif_shd.g_old_rec.action_information19, hr_api.g_varchar2) <>
389: nvl(p_rec.action_information19, hr_api.g_varchar2) or
390: nvl(pay_aif_shd.g_old_rec.action_information20, hr_api.g_varchar2) <>
391: nvl(p_rec.action_information20, hr_api.g_varchar2) or
392: nvl(pay_aif_shd.g_old_rec.action_information21, hr_api.g_varchar2) <>
393: nvl(p_rec.action_information21, hr_api.g_varchar2) or
394: nvl(pay_aif_shd.g_old_rec.action_information22, hr_api.g_varchar2) <>
395: nvl(p_rec.action_information22, hr_api.g_varchar2) or
396: nvl(pay_aif_shd.g_old_rec.action_information23, hr_api.g_varchar2) <>
389: nvl(p_rec.action_information19, hr_api.g_varchar2) or
390: nvl(pay_aif_shd.g_old_rec.action_information20, hr_api.g_varchar2) <>
391: nvl(p_rec.action_information20, hr_api.g_varchar2) or
392: nvl(pay_aif_shd.g_old_rec.action_information21, hr_api.g_varchar2) <>
393: nvl(p_rec.action_information21, hr_api.g_varchar2) or
394: nvl(pay_aif_shd.g_old_rec.action_information22, hr_api.g_varchar2) <>
395: nvl(p_rec.action_information22, hr_api.g_varchar2) or
396: nvl(pay_aif_shd.g_old_rec.action_information23, hr_api.g_varchar2) <>
397: nvl(p_rec.action_information23, hr_api.g_varchar2) or
390: nvl(pay_aif_shd.g_old_rec.action_information20, hr_api.g_varchar2) <>
391: nvl(p_rec.action_information20, hr_api.g_varchar2) or
392: nvl(pay_aif_shd.g_old_rec.action_information21, hr_api.g_varchar2) <>
393: nvl(p_rec.action_information21, hr_api.g_varchar2) or
394: nvl(pay_aif_shd.g_old_rec.action_information22, hr_api.g_varchar2) <>
395: nvl(p_rec.action_information22, hr_api.g_varchar2) or
396: nvl(pay_aif_shd.g_old_rec.action_information23, hr_api.g_varchar2) <>
397: nvl(p_rec.action_information23, hr_api.g_varchar2) or
398: nvl(pay_aif_shd.g_old_rec.action_information24, hr_api.g_varchar2) <>
391: nvl(p_rec.action_information20, hr_api.g_varchar2) or
392: nvl(pay_aif_shd.g_old_rec.action_information21, hr_api.g_varchar2) <>
393: nvl(p_rec.action_information21, hr_api.g_varchar2) or
394: nvl(pay_aif_shd.g_old_rec.action_information22, hr_api.g_varchar2) <>
395: nvl(p_rec.action_information22, hr_api.g_varchar2) or
396: nvl(pay_aif_shd.g_old_rec.action_information23, hr_api.g_varchar2) <>
397: nvl(p_rec.action_information23, hr_api.g_varchar2) or
398: nvl(pay_aif_shd.g_old_rec.action_information24, hr_api.g_varchar2) <>
399: nvl(p_rec.action_information24, hr_api.g_varchar2) or
392: nvl(pay_aif_shd.g_old_rec.action_information21, hr_api.g_varchar2) <>
393: nvl(p_rec.action_information21, hr_api.g_varchar2) or
394: nvl(pay_aif_shd.g_old_rec.action_information22, hr_api.g_varchar2) <>
395: nvl(p_rec.action_information22, hr_api.g_varchar2) or
396: nvl(pay_aif_shd.g_old_rec.action_information23, hr_api.g_varchar2) <>
397: nvl(p_rec.action_information23, hr_api.g_varchar2) or
398: nvl(pay_aif_shd.g_old_rec.action_information24, hr_api.g_varchar2) <>
399: nvl(p_rec.action_information24, hr_api.g_varchar2) or
400: nvl(pay_aif_shd.g_old_rec.action_information25, hr_api.g_varchar2) <>
393: nvl(p_rec.action_information21, hr_api.g_varchar2) or
394: nvl(pay_aif_shd.g_old_rec.action_information22, hr_api.g_varchar2) <>
395: nvl(p_rec.action_information22, hr_api.g_varchar2) or
396: nvl(pay_aif_shd.g_old_rec.action_information23, hr_api.g_varchar2) <>
397: nvl(p_rec.action_information23, hr_api.g_varchar2) or
398: nvl(pay_aif_shd.g_old_rec.action_information24, hr_api.g_varchar2) <>
399: nvl(p_rec.action_information24, hr_api.g_varchar2) or
400: nvl(pay_aif_shd.g_old_rec.action_information25, hr_api.g_varchar2) <>
401: nvl(p_rec.action_information25, hr_api.g_varchar2) or
394: nvl(pay_aif_shd.g_old_rec.action_information22, hr_api.g_varchar2) <>
395: nvl(p_rec.action_information22, hr_api.g_varchar2) or
396: nvl(pay_aif_shd.g_old_rec.action_information23, hr_api.g_varchar2) <>
397: nvl(p_rec.action_information23, hr_api.g_varchar2) or
398: nvl(pay_aif_shd.g_old_rec.action_information24, hr_api.g_varchar2) <>
399: nvl(p_rec.action_information24, hr_api.g_varchar2) or
400: nvl(pay_aif_shd.g_old_rec.action_information25, hr_api.g_varchar2) <>
401: nvl(p_rec.action_information25, hr_api.g_varchar2) or
402: nvl(pay_aif_shd.g_old_rec.action_information26, hr_api.g_varchar2) <>
395: nvl(p_rec.action_information22, hr_api.g_varchar2) or
396: nvl(pay_aif_shd.g_old_rec.action_information23, hr_api.g_varchar2) <>
397: nvl(p_rec.action_information23, hr_api.g_varchar2) or
398: nvl(pay_aif_shd.g_old_rec.action_information24, hr_api.g_varchar2) <>
399: nvl(p_rec.action_information24, hr_api.g_varchar2) or
400: nvl(pay_aif_shd.g_old_rec.action_information25, hr_api.g_varchar2) <>
401: nvl(p_rec.action_information25, hr_api.g_varchar2) or
402: nvl(pay_aif_shd.g_old_rec.action_information26, hr_api.g_varchar2) <>
403: nvl(p_rec.action_information26, hr_api.g_varchar2) or
396: nvl(pay_aif_shd.g_old_rec.action_information23, hr_api.g_varchar2) <>
397: nvl(p_rec.action_information23, hr_api.g_varchar2) or
398: nvl(pay_aif_shd.g_old_rec.action_information24, hr_api.g_varchar2) <>
399: nvl(p_rec.action_information24, hr_api.g_varchar2) or
400: nvl(pay_aif_shd.g_old_rec.action_information25, hr_api.g_varchar2) <>
401: nvl(p_rec.action_information25, hr_api.g_varchar2) or
402: nvl(pay_aif_shd.g_old_rec.action_information26, hr_api.g_varchar2) <>
403: nvl(p_rec.action_information26, hr_api.g_varchar2) or
404: nvl(pay_aif_shd.g_old_rec.action_information27, hr_api.g_varchar2) <>
397: nvl(p_rec.action_information23, hr_api.g_varchar2) or
398: nvl(pay_aif_shd.g_old_rec.action_information24, hr_api.g_varchar2) <>
399: nvl(p_rec.action_information24, hr_api.g_varchar2) or
400: nvl(pay_aif_shd.g_old_rec.action_information25, hr_api.g_varchar2) <>
401: nvl(p_rec.action_information25, hr_api.g_varchar2) or
402: nvl(pay_aif_shd.g_old_rec.action_information26, hr_api.g_varchar2) <>
403: nvl(p_rec.action_information26, hr_api.g_varchar2) or
404: nvl(pay_aif_shd.g_old_rec.action_information27, hr_api.g_varchar2) <>
405: nvl(p_rec.action_information27, hr_api.g_varchar2) or
398: nvl(pay_aif_shd.g_old_rec.action_information24, hr_api.g_varchar2) <>
399: nvl(p_rec.action_information24, hr_api.g_varchar2) or
400: nvl(pay_aif_shd.g_old_rec.action_information25, hr_api.g_varchar2) <>
401: nvl(p_rec.action_information25, hr_api.g_varchar2) or
402: nvl(pay_aif_shd.g_old_rec.action_information26, hr_api.g_varchar2) <>
403: nvl(p_rec.action_information26, hr_api.g_varchar2) or
404: nvl(pay_aif_shd.g_old_rec.action_information27, hr_api.g_varchar2) <>
405: nvl(p_rec.action_information27, hr_api.g_varchar2) or
406: nvl(pay_aif_shd.g_old_rec.action_information28, hr_api.g_varchar2) <>
399: nvl(p_rec.action_information24, hr_api.g_varchar2) or
400: nvl(pay_aif_shd.g_old_rec.action_information25, hr_api.g_varchar2) <>
401: nvl(p_rec.action_information25, hr_api.g_varchar2) or
402: nvl(pay_aif_shd.g_old_rec.action_information26, hr_api.g_varchar2) <>
403: nvl(p_rec.action_information26, hr_api.g_varchar2) or
404: nvl(pay_aif_shd.g_old_rec.action_information27, hr_api.g_varchar2) <>
405: nvl(p_rec.action_information27, hr_api.g_varchar2) or
406: nvl(pay_aif_shd.g_old_rec.action_information28, hr_api.g_varchar2) <>
407: nvl(p_rec.action_information28, hr_api.g_varchar2) or
400: nvl(pay_aif_shd.g_old_rec.action_information25, hr_api.g_varchar2) <>
401: nvl(p_rec.action_information25, hr_api.g_varchar2) or
402: nvl(pay_aif_shd.g_old_rec.action_information26, hr_api.g_varchar2) <>
403: nvl(p_rec.action_information26, hr_api.g_varchar2) or
404: nvl(pay_aif_shd.g_old_rec.action_information27, hr_api.g_varchar2) <>
405: nvl(p_rec.action_information27, hr_api.g_varchar2) or
406: nvl(pay_aif_shd.g_old_rec.action_information28, hr_api.g_varchar2) <>
407: nvl(p_rec.action_information28, hr_api.g_varchar2) or
408: nvl(pay_aif_shd.g_old_rec.action_information29, hr_api.g_varchar2) <>
401: nvl(p_rec.action_information25, hr_api.g_varchar2) or
402: nvl(pay_aif_shd.g_old_rec.action_information26, hr_api.g_varchar2) <>
403: nvl(p_rec.action_information26, hr_api.g_varchar2) or
404: nvl(pay_aif_shd.g_old_rec.action_information27, hr_api.g_varchar2) <>
405: nvl(p_rec.action_information27, hr_api.g_varchar2) or
406: nvl(pay_aif_shd.g_old_rec.action_information28, hr_api.g_varchar2) <>
407: nvl(p_rec.action_information28, hr_api.g_varchar2) or
408: nvl(pay_aif_shd.g_old_rec.action_information29, hr_api.g_varchar2) <>
409: nvl(p_rec.action_information29, hr_api.g_varchar2) or
402: nvl(pay_aif_shd.g_old_rec.action_information26, hr_api.g_varchar2) <>
403: nvl(p_rec.action_information26, hr_api.g_varchar2) or
404: nvl(pay_aif_shd.g_old_rec.action_information27, hr_api.g_varchar2) <>
405: nvl(p_rec.action_information27, hr_api.g_varchar2) or
406: nvl(pay_aif_shd.g_old_rec.action_information28, hr_api.g_varchar2) <>
407: nvl(p_rec.action_information28, hr_api.g_varchar2) or
408: nvl(pay_aif_shd.g_old_rec.action_information29, hr_api.g_varchar2) <>
409: nvl(p_rec.action_information29, hr_api.g_varchar2) or
410: nvl(pay_aif_shd.g_old_rec.action_information30, hr_api.g_varchar2) <>
403: nvl(p_rec.action_information26, hr_api.g_varchar2) or
404: nvl(pay_aif_shd.g_old_rec.action_information27, hr_api.g_varchar2) <>
405: nvl(p_rec.action_information27, hr_api.g_varchar2) or
406: nvl(pay_aif_shd.g_old_rec.action_information28, hr_api.g_varchar2) <>
407: nvl(p_rec.action_information28, hr_api.g_varchar2) or
408: nvl(pay_aif_shd.g_old_rec.action_information29, hr_api.g_varchar2) <>
409: nvl(p_rec.action_information29, hr_api.g_varchar2) or
410: nvl(pay_aif_shd.g_old_rec.action_information30, hr_api.g_varchar2) <>
411: nvl(p_rec.action_information30, hr_api.g_varchar2) ))
404: nvl(pay_aif_shd.g_old_rec.action_information27, hr_api.g_varchar2) <>
405: nvl(p_rec.action_information27, hr_api.g_varchar2) or
406: nvl(pay_aif_shd.g_old_rec.action_information28, hr_api.g_varchar2) <>
407: nvl(p_rec.action_information28, hr_api.g_varchar2) or
408: nvl(pay_aif_shd.g_old_rec.action_information29, hr_api.g_varchar2) <>
409: nvl(p_rec.action_information29, hr_api.g_varchar2) or
410: nvl(pay_aif_shd.g_old_rec.action_information30, hr_api.g_varchar2) <>
411: nvl(p_rec.action_information30, hr_api.g_varchar2) ))
412: or (p_rec.action_information_id is null) then
405: nvl(p_rec.action_information27, hr_api.g_varchar2) or
406: nvl(pay_aif_shd.g_old_rec.action_information28, hr_api.g_varchar2) <>
407: nvl(p_rec.action_information28, hr_api.g_varchar2) or
408: nvl(pay_aif_shd.g_old_rec.action_information29, hr_api.g_varchar2) <>
409: nvl(p_rec.action_information29, hr_api.g_varchar2) or
410: nvl(pay_aif_shd.g_old_rec.action_information30, hr_api.g_varchar2) <>
411: nvl(p_rec.action_information30, hr_api.g_varchar2) ))
412: or (p_rec.action_information_id is null) then
413: --
406: nvl(pay_aif_shd.g_old_rec.action_information28, hr_api.g_varchar2) <>
407: nvl(p_rec.action_information28, hr_api.g_varchar2) or
408: nvl(pay_aif_shd.g_old_rec.action_information29, hr_api.g_varchar2) <>
409: nvl(p_rec.action_information29, hr_api.g_varchar2) or
410: nvl(pay_aif_shd.g_old_rec.action_information30, hr_api.g_varchar2) <>
411: nvl(p_rec.action_information30, hr_api.g_varchar2) ))
412: or (p_rec.action_information_id is null) then
413: --
414: -- Only execute the validation if absolutely necessary:
407: nvl(p_rec.action_information28, hr_api.g_varchar2) or
408: nvl(pay_aif_shd.g_old_rec.action_information29, hr_api.g_varchar2) <>
409: nvl(p_rec.action_information29, hr_api.g_varchar2) or
410: nvl(pay_aif_shd.g_old_rec.action_information30, hr_api.g_varchar2) <>
411: nvl(p_rec.action_information30, hr_api.g_varchar2) ))
412: or (p_rec.action_information_id is null) then
413: --
414: -- Only execute the validation if absolutely necessary:
415: -- a) During update, the structure column value or any
726: END IF;
727: --
728: -- action_context_id
729: --
730: if nvl(p_rec.action_context_id,hr_api.g_number) <>
731: nvl(pay_aif_shd.g_old_rec.action_context_id,hr_api.g_number) then
732: --
733: l_argument := 'p_rec.action_context_id';
734: raise l_error;
727: --
728: -- action_context_id
729: --
730: if nvl(p_rec.action_context_id,hr_api.g_number) <>
731: nvl(pay_aif_shd.g_old_rec.action_context_id,hr_api.g_number) then
732: --
733: l_argument := 'p_rec.action_context_id';
734: raise l_error;
735: --
736: end if;
737: --
738: -- action_context_type
739: --
740: if nvl(p_rec.action_context_type,hr_api.g_varchar2) <>
741: nvl(pay_aif_shd.g_old_rec.action_context_type,hr_api.g_varchar2) then
742: --
743: l_argument := 'p_rec.action_context_type';
744: raise l_error;
737: --
738: -- action_context_type
739: --
740: if nvl(p_rec.action_context_type,hr_api.g_varchar2) <>
741: nvl(pay_aif_shd.g_old_rec.action_context_type,hr_api.g_varchar2) then
742: --
743: l_argument := 'p_rec.action_context_type';
744: raise l_error;
745: --
746: end if;
747: --
748: -- effective_date
749: --
750: if nvl(p_rec.effective_date,hr_api.g_date) <>
751: nvl(pay_aif_shd.g_old_rec.effective_date,hr_api.g_date) then
752: --
753: l_argument := 'p_rec.effective_date';
754: raise l_error;
747: --
748: -- effective_date
749: --
750: if nvl(p_rec.effective_date,hr_api.g_date) <>
751: nvl(pay_aif_shd.g_old_rec.effective_date,hr_api.g_date) then
752: --
753: l_argument := 'p_rec.effective_date';
754: raise l_error;
755: --
756: end if;
757: --
758: -- assignment_id
759: --
760: if nvl(p_rec.assignment_id,hr_api.g_number) <>
761: nvl(pay_aif_shd.g_old_rec.assignment_id,hr_api.g_number) then
762: --
763: l_argument := 'p_rec.assignment_id';
764: raise l_error;
757: --
758: -- assignment_id
759: --
760: if nvl(p_rec.assignment_id,hr_api.g_number) <>
761: nvl(pay_aif_shd.g_old_rec.assignment_id,hr_api.g_number) then
762: --
763: l_argument := 'p_rec.assignment_id';
764: raise l_error;
765: --
766: end if;
767: --
768: -- action_information_category
769: --
770: if nvl(p_rec.action_information_category,hr_api.g_varchar2) <>
771: nvl(pay_aif_shd.g_old_rec.action_information_category,hr_api.g_varchar2) then
772: --
773: l_argument := 'p_rec.action_information_category';
774: raise l_error;
767: --
768: -- action_information_category
769: --
770: if nvl(p_rec.action_information_category,hr_api.g_varchar2) <>
771: nvl(pay_aif_shd.g_old_rec.action_information_category,hr_api.g_varchar2) then
772: --
773: l_argument := 'p_rec.action_information_category';
774: raise l_error;
775: --
776: end if;
777: --
778: -- tax_unit_id
779: --
780: if nvl(p_rec.tax_unit_id,hr_api.g_number) <>
781: nvl(pay_aif_shd.g_old_rec.tax_unit_id,hr_api.g_number) then
782: --
783: l_argument := 'p_rec.tax_unit_id';
784: raise l_error;
777: --
778: -- tax_unit_id
779: --
780: if nvl(p_rec.tax_unit_id,hr_api.g_number) <>
781: nvl(pay_aif_shd.g_old_rec.tax_unit_id,hr_api.g_number) then
782: --
783: l_argument := 'p_rec.tax_unit_id';
784: raise l_error;
785: --
786: end if;
787: --
788: -- jurisdiction_code
789: --
790: if nvl(p_rec.jurisdiction_code,hr_api.g_varchar2) <>
791: nvl(pay_aif_shd.g_old_rec.jurisdiction_code,hr_api.g_varchar2) then
792: --
793: l_argument := 'p_rec.jurisdiction_code';
794: raise l_error;
787: --
788: -- jurisdiction_code
789: --
790: if nvl(p_rec.jurisdiction_code,hr_api.g_varchar2) <>
791: nvl(pay_aif_shd.g_old_rec.jurisdiction_code,hr_api.g_varchar2) then
792: --
793: l_argument := 'p_rec.jurisdiction_code';
794: raise l_error;
795: --
796: end if;
797: --
798: -- source_id
799: --
800: if nvl(p_rec.source_id,hr_api.g_number) <>
801: nvl(pay_aif_shd.g_old_rec.source_id,hr_api.g_number) then
802: --
803: l_argument := 'p_rec.source_id';
804: raise l_error;
797: --
798: -- source_id
799: --
800: if nvl(p_rec.source_id,hr_api.g_number) <>
801: nvl(pay_aif_shd.g_old_rec.source_id,hr_api.g_number) then
802: --
803: l_argument := 'p_rec.source_id';
804: raise l_error;
805: --
806: end if;
807: --
808: -- source_text
809: --
810: if nvl(p_rec.source_text,hr_api.g_varchar2) <>
811: nvl(pay_aif_shd.g_old_rec.source_text,hr_api.g_varchar2) then
812: --
813: l_argument := 'p_rec.source_text';
814: raise l_error;
807: --
808: -- source_text
809: --
810: if nvl(p_rec.source_text,hr_api.g_varchar2) <>
811: nvl(pay_aif_shd.g_old_rec.source_text,hr_api.g_varchar2) then
812: --
813: l_argument := 'p_rec.source_text';
814: raise l_error;
815: --
816: end if;
817: --
818: -- tax_group
819: --
820: if nvl(p_rec.tax_group,hr_api.g_varchar2) <>
821: nvl(pay_aif_shd.g_old_rec.tax_group,hr_api.g_varchar2) then
822: --
823: l_argument := 'p_rec.tax_group';
824: raise l_error;
817: --
818: -- tax_group
819: --
820: if nvl(p_rec.tax_group,hr_api.g_varchar2) <>
821: nvl(pay_aif_shd.g_old_rec.tax_group,hr_api.g_varchar2) then
822: --
823: l_argument := 'p_rec.tax_group';
824: raise l_error;
825: --
826: end if;
827: --
828: EXCEPTION
829: WHEN l_error THEN
830: hr_api.argument_changed_error
831: (p_api_name => l_proc
832: ,p_argument => l_argument);
833: WHEN OTHERS THEN
834: RAISE;