[Home] [Help]
45: hr_utility.set_location('Entering:'|| l_proc, 10);
46: --
47: -- Ensure that all the mandatory parameters are not null
48: --
49: hr_api.mandatory_arg_error
50: (p_api_name => l_proc
51: ,p_argument => 'payroll_id'
52: ,p_argument_value => p_payroll_id
53: );
73: close csr_sec_grp;
74: --
75: -- Set the security_group_id in CLIENT_INFO
76: --
77: hr_api.set_security_group_id(p_security_group_id => l_security_group_id );
78: --
79: -- Set the sessions legislation context in HR_SESSION_DATA
80: --
81: hr_api.set_legislation_context(l_legislation_code);
77: hr_api.set_security_group_id(p_security_group_id => l_security_group_id );
78: --
79: -- Set the sessions legislation context in HR_SESSION_DATA
80: --
81: hr_api.set_legislation_context(l_legislation_code);
82: --
83: end if;
84: --
85: hr_utility.set_location(' Leaving:'|| l_proc, 20);
114: hr_utility.set_location('Entering:'|| l_proc, 10);
115: --
116: -- Ensure that all the mandatory parameter are not null
117: --
118: hr_api.mandatory_arg_error
119: (p_api_name => l_proc
120: ,p_argument => 'payroll_id'
121: ,p_argument_value => p_payroll_id
122: );
120: ,p_argument => 'payroll_id'
121: ,p_argument_value => p_payroll_id
122: );
123: --
124: if ( nvl(pay_pay_bus.g_payroll_id, hr_api.g_number) = p_payroll_id) then
125: --
126: -- The legislation code has already been found with a previous
127: -- call to this function. Just return the value in the global
128: -- variable.
201: begin
202: hr_utility.set_location('Entering:'||l_proc,10);
203: --
204: if ((p_rec.payroll_id is not null) and (
205: nvl(pay_pay_shd.g_old_rec.prl_information_category, hr_api.g_varchar2) <>
206: nvl(p_rec.prl_information_category, hr_api.g_varchar2) or
207: nvl(pay_pay_shd.g_old_rec.prl_information1, hr_api.g_varchar2) <>
208: nvl(p_rec.prl_information1, hr_api.g_varchar2) or
209: nvl(pay_pay_shd.g_old_rec.prl_information2, hr_api.g_varchar2) <>
202: hr_utility.set_location('Entering:'||l_proc,10);
203: --
204: if ((p_rec.payroll_id is not null) and (
205: nvl(pay_pay_shd.g_old_rec.prl_information_category, hr_api.g_varchar2) <>
206: nvl(p_rec.prl_information_category, hr_api.g_varchar2) or
207: nvl(pay_pay_shd.g_old_rec.prl_information1, hr_api.g_varchar2) <>
208: nvl(p_rec.prl_information1, hr_api.g_varchar2) or
209: nvl(pay_pay_shd.g_old_rec.prl_information2, hr_api.g_varchar2) <>
210: nvl(p_rec.prl_information2, hr_api.g_varchar2) or
203: --
204: if ((p_rec.payroll_id is not null) and (
205: nvl(pay_pay_shd.g_old_rec.prl_information_category, hr_api.g_varchar2) <>
206: nvl(p_rec.prl_information_category, hr_api.g_varchar2) or
207: nvl(pay_pay_shd.g_old_rec.prl_information1, hr_api.g_varchar2) <>
208: nvl(p_rec.prl_information1, hr_api.g_varchar2) or
209: nvl(pay_pay_shd.g_old_rec.prl_information2, hr_api.g_varchar2) <>
210: nvl(p_rec.prl_information2, hr_api.g_varchar2) or
211: nvl(pay_pay_shd.g_old_rec.prl_information3, hr_api.g_varchar2) <>
204: if ((p_rec.payroll_id is not null) and (
205: nvl(pay_pay_shd.g_old_rec.prl_information_category, hr_api.g_varchar2) <>
206: nvl(p_rec.prl_information_category, hr_api.g_varchar2) or
207: nvl(pay_pay_shd.g_old_rec.prl_information1, hr_api.g_varchar2) <>
208: nvl(p_rec.prl_information1, hr_api.g_varchar2) or
209: nvl(pay_pay_shd.g_old_rec.prl_information2, hr_api.g_varchar2) <>
210: nvl(p_rec.prl_information2, hr_api.g_varchar2) or
211: nvl(pay_pay_shd.g_old_rec.prl_information3, hr_api.g_varchar2) <>
212: nvl(p_rec.prl_information3, hr_api.g_varchar2) or
205: nvl(pay_pay_shd.g_old_rec.prl_information_category, hr_api.g_varchar2) <>
206: nvl(p_rec.prl_information_category, hr_api.g_varchar2) or
207: nvl(pay_pay_shd.g_old_rec.prl_information1, hr_api.g_varchar2) <>
208: nvl(p_rec.prl_information1, hr_api.g_varchar2) or
209: nvl(pay_pay_shd.g_old_rec.prl_information2, hr_api.g_varchar2) <>
210: nvl(p_rec.prl_information2, hr_api.g_varchar2) or
211: nvl(pay_pay_shd.g_old_rec.prl_information3, hr_api.g_varchar2) <>
212: nvl(p_rec.prl_information3, hr_api.g_varchar2) or
213: nvl(pay_pay_shd.g_old_rec.prl_information4, hr_api.g_varchar2) <>
206: nvl(p_rec.prl_information_category, hr_api.g_varchar2) or
207: nvl(pay_pay_shd.g_old_rec.prl_information1, hr_api.g_varchar2) <>
208: nvl(p_rec.prl_information1, hr_api.g_varchar2) or
209: nvl(pay_pay_shd.g_old_rec.prl_information2, hr_api.g_varchar2) <>
210: nvl(p_rec.prl_information2, hr_api.g_varchar2) or
211: nvl(pay_pay_shd.g_old_rec.prl_information3, hr_api.g_varchar2) <>
212: nvl(p_rec.prl_information3, hr_api.g_varchar2) or
213: nvl(pay_pay_shd.g_old_rec.prl_information4, hr_api.g_varchar2) <>
214: nvl(p_rec.prl_information4, hr_api.g_varchar2) or
207: nvl(pay_pay_shd.g_old_rec.prl_information1, hr_api.g_varchar2) <>
208: nvl(p_rec.prl_information1, hr_api.g_varchar2) or
209: nvl(pay_pay_shd.g_old_rec.prl_information2, hr_api.g_varchar2) <>
210: nvl(p_rec.prl_information2, hr_api.g_varchar2) or
211: nvl(pay_pay_shd.g_old_rec.prl_information3, hr_api.g_varchar2) <>
212: nvl(p_rec.prl_information3, hr_api.g_varchar2) or
213: nvl(pay_pay_shd.g_old_rec.prl_information4, hr_api.g_varchar2) <>
214: nvl(p_rec.prl_information4, hr_api.g_varchar2) or
215: nvl(pay_pay_shd.g_old_rec.prl_information5, hr_api.g_varchar2) <>
208: nvl(p_rec.prl_information1, hr_api.g_varchar2) or
209: nvl(pay_pay_shd.g_old_rec.prl_information2, hr_api.g_varchar2) <>
210: nvl(p_rec.prl_information2, hr_api.g_varchar2) or
211: nvl(pay_pay_shd.g_old_rec.prl_information3, hr_api.g_varchar2) <>
212: nvl(p_rec.prl_information3, hr_api.g_varchar2) or
213: nvl(pay_pay_shd.g_old_rec.prl_information4, hr_api.g_varchar2) <>
214: nvl(p_rec.prl_information4, hr_api.g_varchar2) or
215: nvl(pay_pay_shd.g_old_rec.prl_information5, hr_api.g_varchar2) <>
216: nvl(p_rec.prl_information5, hr_api.g_varchar2) or
209: nvl(pay_pay_shd.g_old_rec.prl_information2, hr_api.g_varchar2) <>
210: nvl(p_rec.prl_information2, hr_api.g_varchar2) or
211: nvl(pay_pay_shd.g_old_rec.prl_information3, hr_api.g_varchar2) <>
212: nvl(p_rec.prl_information3, hr_api.g_varchar2) or
213: nvl(pay_pay_shd.g_old_rec.prl_information4, hr_api.g_varchar2) <>
214: nvl(p_rec.prl_information4, hr_api.g_varchar2) or
215: nvl(pay_pay_shd.g_old_rec.prl_information5, hr_api.g_varchar2) <>
216: nvl(p_rec.prl_information5, hr_api.g_varchar2) or
217: nvl(pay_pay_shd.g_old_rec.prl_information6, hr_api.g_varchar2) <>
210: nvl(p_rec.prl_information2, hr_api.g_varchar2) or
211: nvl(pay_pay_shd.g_old_rec.prl_information3, hr_api.g_varchar2) <>
212: nvl(p_rec.prl_information3, hr_api.g_varchar2) or
213: nvl(pay_pay_shd.g_old_rec.prl_information4, hr_api.g_varchar2) <>
214: nvl(p_rec.prl_information4, hr_api.g_varchar2) or
215: nvl(pay_pay_shd.g_old_rec.prl_information5, hr_api.g_varchar2) <>
216: nvl(p_rec.prl_information5, hr_api.g_varchar2) or
217: nvl(pay_pay_shd.g_old_rec.prl_information6, hr_api.g_varchar2) <>
218: nvl(p_rec.prl_information6, hr_api.g_varchar2) or
211: nvl(pay_pay_shd.g_old_rec.prl_information3, hr_api.g_varchar2) <>
212: nvl(p_rec.prl_information3, hr_api.g_varchar2) or
213: nvl(pay_pay_shd.g_old_rec.prl_information4, hr_api.g_varchar2) <>
214: nvl(p_rec.prl_information4, hr_api.g_varchar2) or
215: nvl(pay_pay_shd.g_old_rec.prl_information5, hr_api.g_varchar2) <>
216: nvl(p_rec.prl_information5, hr_api.g_varchar2) or
217: nvl(pay_pay_shd.g_old_rec.prl_information6, hr_api.g_varchar2) <>
218: nvl(p_rec.prl_information6, hr_api.g_varchar2) or
219: nvl(pay_pay_shd.g_old_rec.prl_information7, hr_api.g_varchar2) <>
212: nvl(p_rec.prl_information3, hr_api.g_varchar2) or
213: nvl(pay_pay_shd.g_old_rec.prl_information4, hr_api.g_varchar2) <>
214: nvl(p_rec.prl_information4, hr_api.g_varchar2) or
215: nvl(pay_pay_shd.g_old_rec.prl_information5, hr_api.g_varchar2) <>
216: nvl(p_rec.prl_information5, hr_api.g_varchar2) or
217: nvl(pay_pay_shd.g_old_rec.prl_information6, hr_api.g_varchar2) <>
218: nvl(p_rec.prl_information6, hr_api.g_varchar2) or
219: nvl(pay_pay_shd.g_old_rec.prl_information7, hr_api.g_varchar2) <>
220: nvl(p_rec.prl_information7, hr_api.g_varchar2) or
213: nvl(pay_pay_shd.g_old_rec.prl_information4, hr_api.g_varchar2) <>
214: nvl(p_rec.prl_information4, hr_api.g_varchar2) or
215: nvl(pay_pay_shd.g_old_rec.prl_information5, hr_api.g_varchar2) <>
216: nvl(p_rec.prl_information5, hr_api.g_varchar2) or
217: nvl(pay_pay_shd.g_old_rec.prl_information6, hr_api.g_varchar2) <>
218: nvl(p_rec.prl_information6, hr_api.g_varchar2) or
219: nvl(pay_pay_shd.g_old_rec.prl_information7, hr_api.g_varchar2) <>
220: nvl(p_rec.prl_information7, hr_api.g_varchar2) or
221: nvl(pay_pay_shd.g_old_rec.prl_information8, hr_api.g_varchar2) <>
214: nvl(p_rec.prl_information4, hr_api.g_varchar2) or
215: nvl(pay_pay_shd.g_old_rec.prl_information5, hr_api.g_varchar2) <>
216: nvl(p_rec.prl_information5, hr_api.g_varchar2) or
217: nvl(pay_pay_shd.g_old_rec.prl_information6, hr_api.g_varchar2) <>
218: nvl(p_rec.prl_information6, hr_api.g_varchar2) or
219: nvl(pay_pay_shd.g_old_rec.prl_information7, hr_api.g_varchar2) <>
220: nvl(p_rec.prl_information7, hr_api.g_varchar2) or
221: nvl(pay_pay_shd.g_old_rec.prl_information8, hr_api.g_varchar2) <>
222: nvl(p_rec.prl_information8, hr_api.g_varchar2) or
215: nvl(pay_pay_shd.g_old_rec.prl_information5, hr_api.g_varchar2) <>
216: nvl(p_rec.prl_information5, hr_api.g_varchar2) or
217: nvl(pay_pay_shd.g_old_rec.prl_information6, hr_api.g_varchar2) <>
218: nvl(p_rec.prl_information6, hr_api.g_varchar2) or
219: nvl(pay_pay_shd.g_old_rec.prl_information7, hr_api.g_varchar2) <>
220: nvl(p_rec.prl_information7, hr_api.g_varchar2) or
221: nvl(pay_pay_shd.g_old_rec.prl_information8, hr_api.g_varchar2) <>
222: nvl(p_rec.prl_information8, hr_api.g_varchar2) or
223: nvl(pay_pay_shd.g_old_rec.prl_information9, hr_api.g_varchar2) <>
216: nvl(p_rec.prl_information5, hr_api.g_varchar2) or
217: nvl(pay_pay_shd.g_old_rec.prl_information6, hr_api.g_varchar2) <>
218: nvl(p_rec.prl_information6, hr_api.g_varchar2) or
219: nvl(pay_pay_shd.g_old_rec.prl_information7, hr_api.g_varchar2) <>
220: nvl(p_rec.prl_information7, hr_api.g_varchar2) or
221: nvl(pay_pay_shd.g_old_rec.prl_information8, hr_api.g_varchar2) <>
222: nvl(p_rec.prl_information8, hr_api.g_varchar2) or
223: nvl(pay_pay_shd.g_old_rec.prl_information9, hr_api.g_varchar2) <>
224: nvl(p_rec.prl_information9, hr_api.g_varchar2) or
217: nvl(pay_pay_shd.g_old_rec.prl_information6, hr_api.g_varchar2) <>
218: nvl(p_rec.prl_information6, hr_api.g_varchar2) or
219: nvl(pay_pay_shd.g_old_rec.prl_information7, hr_api.g_varchar2) <>
220: nvl(p_rec.prl_information7, hr_api.g_varchar2) or
221: nvl(pay_pay_shd.g_old_rec.prl_information8, hr_api.g_varchar2) <>
222: nvl(p_rec.prl_information8, hr_api.g_varchar2) or
223: nvl(pay_pay_shd.g_old_rec.prl_information9, hr_api.g_varchar2) <>
224: nvl(p_rec.prl_information9, hr_api.g_varchar2) or
225: nvl(pay_pay_shd.g_old_rec.prl_information10, hr_api.g_varchar2) <>
218: nvl(p_rec.prl_information6, hr_api.g_varchar2) or
219: nvl(pay_pay_shd.g_old_rec.prl_information7, hr_api.g_varchar2) <>
220: nvl(p_rec.prl_information7, hr_api.g_varchar2) or
221: nvl(pay_pay_shd.g_old_rec.prl_information8, hr_api.g_varchar2) <>
222: nvl(p_rec.prl_information8, hr_api.g_varchar2) or
223: nvl(pay_pay_shd.g_old_rec.prl_information9, hr_api.g_varchar2) <>
224: nvl(p_rec.prl_information9, hr_api.g_varchar2) or
225: nvl(pay_pay_shd.g_old_rec.prl_information10, hr_api.g_varchar2) <>
226: nvl(p_rec.prl_information10, hr_api.g_varchar2) or
219: nvl(pay_pay_shd.g_old_rec.prl_information7, hr_api.g_varchar2) <>
220: nvl(p_rec.prl_information7, hr_api.g_varchar2) or
221: nvl(pay_pay_shd.g_old_rec.prl_information8, hr_api.g_varchar2) <>
222: nvl(p_rec.prl_information8, hr_api.g_varchar2) or
223: nvl(pay_pay_shd.g_old_rec.prl_information9, hr_api.g_varchar2) <>
224: nvl(p_rec.prl_information9, hr_api.g_varchar2) or
225: nvl(pay_pay_shd.g_old_rec.prl_information10, hr_api.g_varchar2) <>
226: nvl(p_rec.prl_information10, hr_api.g_varchar2) or
227: nvl(pay_pay_shd.g_old_rec.prl_information11, hr_api.g_varchar2) <>
220: nvl(p_rec.prl_information7, hr_api.g_varchar2) or
221: nvl(pay_pay_shd.g_old_rec.prl_information8, hr_api.g_varchar2) <>
222: nvl(p_rec.prl_information8, hr_api.g_varchar2) or
223: nvl(pay_pay_shd.g_old_rec.prl_information9, hr_api.g_varchar2) <>
224: nvl(p_rec.prl_information9, hr_api.g_varchar2) or
225: nvl(pay_pay_shd.g_old_rec.prl_information10, hr_api.g_varchar2) <>
226: nvl(p_rec.prl_information10, hr_api.g_varchar2) or
227: nvl(pay_pay_shd.g_old_rec.prl_information11, hr_api.g_varchar2) <>
228: nvl(p_rec.prl_information11, hr_api.g_varchar2) or
221: nvl(pay_pay_shd.g_old_rec.prl_information8, hr_api.g_varchar2) <>
222: nvl(p_rec.prl_information8, hr_api.g_varchar2) or
223: nvl(pay_pay_shd.g_old_rec.prl_information9, hr_api.g_varchar2) <>
224: nvl(p_rec.prl_information9, hr_api.g_varchar2) or
225: nvl(pay_pay_shd.g_old_rec.prl_information10, hr_api.g_varchar2) <>
226: nvl(p_rec.prl_information10, hr_api.g_varchar2) or
227: nvl(pay_pay_shd.g_old_rec.prl_information11, hr_api.g_varchar2) <>
228: nvl(p_rec.prl_information11, hr_api.g_varchar2) or
229: nvl(pay_pay_shd.g_old_rec.prl_information12, hr_api.g_varchar2) <>
222: nvl(p_rec.prl_information8, hr_api.g_varchar2) or
223: nvl(pay_pay_shd.g_old_rec.prl_information9, hr_api.g_varchar2) <>
224: nvl(p_rec.prl_information9, hr_api.g_varchar2) or
225: nvl(pay_pay_shd.g_old_rec.prl_information10, hr_api.g_varchar2) <>
226: nvl(p_rec.prl_information10, hr_api.g_varchar2) or
227: nvl(pay_pay_shd.g_old_rec.prl_information11, hr_api.g_varchar2) <>
228: nvl(p_rec.prl_information11, hr_api.g_varchar2) or
229: nvl(pay_pay_shd.g_old_rec.prl_information12, hr_api.g_varchar2) <>
230: nvl(p_rec.prl_information12, hr_api.g_varchar2) or
223: nvl(pay_pay_shd.g_old_rec.prl_information9, hr_api.g_varchar2) <>
224: nvl(p_rec.prl_information9, hr_api.g_varchar2) or
225: nvl(pay_pay_shd.g_old_rec.prl_information10, hr_api.g_varchar2) <>
226: nvl(p_rec.prl_information10, hr_api.g_varchar2) or
227: nvl(pay_pay_shd.g_old_rec.prl_information11, hr_api.g_varchar2) <>
228: nvl(p_rec.prl_information11, hr_api.g_varchar2) or
229: nvl(pay_pay_shd.g_old_rec.prl_information12, hr_api.g_varchar2) <>
230: nvl(p_rec.prl_information12, hr_api.g_varchar2) or
231: nvl(pay_pay_shd.g_old_rec.prl_information13, hr_api.g_varchar2) <>
224: nvl(p_rec.prl_information9, hr_api.g_varchar2) or
225: nvl(pay_pay_shd.g_old_rec.prl_information10, hr_api.g_varchar2) <>
226: nvl(p_rec.prl_information10, hr_api.g_varchar2) or
227: nvl(pay_pay_shd.g_old_rec.prl_information11, hr_api.g_varchar2) <>
228: nvl(p_rec.prl_information11, hr_api.g_varchar2) or
229: nvl(pay_pay_shd.g_old_rec.prl_information12, hr_api.g_varchar2) <>
230: nvl(p_rec.prl_information12, hr_api.g_varchar2) or
231: nvl(pay_pay_shd.g_old_rec.prl_information13, hr_api.g_varchar2) <>
232: nvl(p_rec.prl_information13, hr_api.g_varchar2) or
225: nvl(pay_pay_shd.g_old_rec.prl_information10, hr_api.g_varchar2) <>
226: nvl(p_rec.prl_information10, hr_api.g_varchar2) or
227: nvl(pay_pay_shd.g_old_rec.prl_information11, hr_api.g_varchar2) <>
228: nvl(p_rec.prl_information11, hr_api.g_varchar2) or
229: nvl(pay_pay_shd.g_old_rec.prl_information12, hr_api.g_varchar2) <>
230: nvl(p_rec.prl_information12, hr_api.g_varchar2) or
231: nvl(pay_pay_shd.g_old_rec.prl_information13, hr_api.g_varchar2) <>
232: nvl(p_rec.prl_information13, hr_api.g_varchar2) or
233: nvl(pay_pay_shd.g_old_rec.prl_information14, hr_api.g_varchar2) <>
226: nvl(p_rec.prl_information10, hr_api.g_varchar2) or
227: nvl(pay_pay_shd.g_old_rec.prl_information11, hr_api.g_varchar2) <>
228: nvl(p_rec.prl_information11, hr_api.g_varchar2) or
229: nvl(pay_pay_shd.g_old_rec.prl_information12, hr_api.g_varchar2) <>
230: nvl(p_rec.prl_information12, hr_api.g_varchar2) or
231: nvl(pay_pay_shd.g_old_rec.prl_information13, hr_api.g_varchar2) <>
232: nvl(p_rec.prl_information13, hr_api.g_varchar2) or
233: nvl(pay_pay_shd.g_old_rec.prl_information14, hr_api.g_varchar2) <>
234: nvl(p_rec.prl_information14, hr_api.g_varchar2) or
227: nvl(pay_pay_shd.g_old_rec.prl_information11, hr_api.g_varchar2) <>
228: nvl(p_rec.prl_information11, hr_api.g_varchar2) or
229: nvl(pay_pay_shd.g_old_rec.prl_information12, hr_api.g_varchar2) <>
230: nvl(p_rec.prl_information12, hr_api.g_varchar2) or
231: nvl(pay_pay_shd.g_old_rec.prl_information13, hr_api.g_varchar2) <>
232: nvl(p_rec.prl_information13, hr_api.g_varchar2) or
233: nvl(pay_pay_shd.g_old_rec.prl_information14, hr_api.g_varchar2) <>
234: nvl(p_rec.prl_information14, hr_api.g_varchar2) or
235: nvl(pay_pay_shd.g_old_rec.prl_information15, hr_api.g_varchar2) <>
228: nvl(p_rec.prl_information11, hr_api.g_varchar2) or
229: nvl(pay_pay_shd.g_old_rec.prl_information12, hr_api.g_varchar2) <>
230: nvl(p_rec.prl_information12, hr_api.g_varchar2) or
231: nvl(pay_pay_shd.g_old_rec.prl_information13, hr_api.g_varchar2) <>
232: nvl(p_rec.prl_information13, hr_api.g_varchar2) or
233: nvl(pay_pay_shd.g_old_rec.prl_information14, hr_api.g_varchar2) <>
234: nvl(p_rec.prl_information14, hr_api.g_varchar2) or
235: nvl(pay_pay_shd.g_old_rec.prl_information15, hr_api.g_varchar2) <>
236: nvl(p_rec.prl_information15, hr_api.g_varchar2) or
229: nvl(pay_pay_shd.g_old_rec.prl_information12, hr_api.g_varchar2) <>
230: nvl(p_rec.prl_information12, hr_api.g_varchar2) or
231: nvl(pay_pay_shd.g_old_rec.prl_information13, hr_api.g_varchar2) <>
232: nvl(p_rec.prl_information13, hr_api.g_varchar2) or
233: nvl(pay_pay_shd.g_old_rec.prl_information14, hr_api.g_varchar2) <>
234: nvl(p_rec.prl_information14, hr_api.g_varchar2) or
235: nvl(pay_pay_shd.g_old_rec.prl_information15, hr_api.g_varchar2) <>
236: nvl(p_rec.prl_information15, hr_api.g_varchar2) or
237: nvl(pay_pay_shd.g_old_rec.prl_information16, hr_api.g_varchar2) <>
230: nvl(p_rec.prl_information12, hr_api.g_varchar2) or
231: nvl(pay_pay_shd.g_old_rec.prl_information13, hr_api.g_varchar2) <>
232: nvl(p_rec.prl_information13, hr_api.g_varchar2) or
233: nvl(pay_pay_shd.g_old_rec.prl_information14, hr_api.g_varchar2) <>
234: nvl(p_rec.prl_information14, hr_api.g_varchar2) or
235: nvl(pay_pay_shd.g_old_rec.prl_information15, hr_api.g_varchar2) <>
236: nvl(p_rec.prl_information15, hr_api.g_varchar2) or
237: nvl(pay_pay_shd.g_old_rec.prl_information16, hr_api.g_varchar2) <>
238: nvl(p_rec.prl_information16, hr_api.g_varchar2) or
231: nvl(pay_pay_shd.g_old_rec.prl_information13, hr_api.g_varchar2) <>
232: nvl(p_rec.prl_information13, hr_api.g_varchar2) or
233: nvl(pay_pay_shd.g_old_rec.prl_information14, hr_api.g_varchar2) <>
234: nvl(p_rec.prl_information14, hr_api.g_varchar2) or
235: nvl(pay_pay_shd.g_old_rec.prl_information15, hr_api.g_varchar2) <>
236: nvl(p_rec.prl_information15, hr_api.g_varchar2) or
237: nvl(pay_pay_shd.g_old_rec.prl_information16, hr_api.g_varchar2) <>
238: nvl(p_rec.prl_information16, hr_api.g_varchar2) or
239: nvl(pay_pay_shd.g_old_rec.prl_information17, hr_api.g_varchar2) <>
232: nvl(p_rec.prl_information13, hr_api.g_varchar2) or
233: nvl(pay_pay_shd.g_old_rec.prl_information14, hr_api.g_varchar2) <>
234: nvl(p_rec.prl_information14, hr_api.g_varchar2) or
235: nvl(pay_pay_shd.g_old_rec.prl_information15, hr_api.g_varchar2) <>
236: nvl(p_rec.prl_information15, hr_api.g_varchar2) or
237: nvl(pay_pay_shd.g_old_rec.prl_information16, hr_api.g_varchar2) <>
238: nvl(p_rec.prl_information16, hr_api.g_varchar2) or
239: nvl(pay_pay_shd.g_old_rec.prl_information17, hr_api.g_varchar2) <>
240: nvl(p_rec.prl_information17, hr_api.g_varchar2) or
233: nvl(pay_pay_shd.g_old_rec.prl_information14, hr_api.g_varchar2) <>
234: nvl(p_rec.prl_information14, hr_api.g_varchar2) or
235: nvl(pay_pay_shd.g_old_rec.prl_information15, hr_api.g_varchar2) <>
236: nvl(p_rec.prl_information15, hr_api.g_varchar2) or
237: nvl(pay_pay_shd.g_old_rec.prl_information16, hr_api.g_varchar2) <>
238: nvl(p_rec.prl_information16, hr_api.g_varchar2) or
239: nvl(pay_pay_shd.g_old_rec.prl_information17, hr_api.g_varchar2) <>
240: nvl(p_rec.prl_information17, hr_api.g_varchar2) or
241: nvl(pay_pay_shd.g_old_rec.prl_information18, hr_api.g_varchar2) <>
234: nvl(p_rec.prl_information14, hr_api.g_varchar2) or
235: nvl(pay_pay_shd.g_old_rec.prl_information15, hr_api.g_varchar2) <>
236: nvl(p_rec.prl_information15, hr_api.g_varchar2) or
237: nvl(pay_pay_shd.g_old_rec.prl_information16, hr_api.g_varchar2) <>
238: nvl(p_rec.prl_information16, hr_api.g_varchar2) or
239: nvl(pay_pay_shd.g_old_rec.prl_information17, hr_api.g_varchar2) <>
240: nvl(p_rec.prl_information17, hr_api.g_varchar2) or
241: nvl(pay_pay_shd.g_old_rec.prl_information18, hr_api.g_varchar2) <>
242: nvl(p_rec.prl_information18, hr_api.g_varchar2) or
235: nvl(pay_pay_shd.g_old_rec.prl_information15, hr_api.g_varchar2) <>
236: nvl(p_rec.prl_information15, hr_api.g_varchar2) or
237: nvl(pay_pay_shd.g_old_rec.prl_information16, hr_api.g_varchar2) <>
238: nvl(p_rec.prl_information16, hr_api.g_varchar2) or
239: nvl(pay_pay_shd.g_old_rec.prl_information17, hr_api.g_varchar2) <>
240: nvl(p_rec.prl_information17, hr_api.g_varchar2) or
241: nvl(pay_pay_shd.g_old_rec.prl_information18, hr_api.g_varchar2) <>
242: nvl(p_rec.prl_information18, hr_api.g_varchar2) or
243: nvl(pay_pay_shd.g_old_rec.prl_information19, hr_api.g_varchar2) <>
236: nvl(p_rec.prl_information15, hr_api.g_varchar2) or
237: nvl(pay_pay_shd.g_old_rec.prl_information16, hr_api.g_varchar2) <>
238: nvl(p_rec.prl_information16, hr_api.g_varchar2) or
239: nvl(pay_pay_shd.g_old_rec.prl_information17, hr_api.g_varchar2) <>
240: nvl(p_rec.prl_information17, hr_api.g_varchar2) or
241: nvl(pay_pay_shd.g_old_rec.prl_information18, hr_api.g_varchar2) <>
242: nvl(p_rec.prl_information18, hr_api.g_varchar2) or
243: nvl(pay_pay_shd.g_old_rec.prl_information19, hr_api.g_varchar2) <>
244: nvl(p_rec.prl_information19, hr_api.g_varchar2) or
237: nvl(pay_pay_shd.g_old_rec.prl_information16, hr_api.g_varchar2) <>
238: nvl(p_rec.prl_information16, hr_api.g_varchar2) or
239: nvl(pay_pay_shd.g_old_rec.prl_information17, hr_api.g_varchar2) <>
240: nvl(p_rec.prl_information17, hr_api.g_varchar2) or
241: nvl(pay_pay_shd.g_old_rec.prl_information18, hr_api.g_varchar2) <>
242: nvl(p_rec.prl_information18, hr_api.g_varchar2) or
243: nvl(pay_pay_shd.g_old_rec.prl_information19, hr_api.g_varchar2) <>
244: nvl(p_rec.prl_information19, hr_api.g_varchar2) or
245: nvl(pay_pay_shd.g_old_rec.prl_information20, hr_api.g_varchar2) <>
238: nvl(p_rec.prl_information16, hr_api.g_varchar2) or
239: nvl(pay_pay_shd.g_old_rec.prl_information17, hr_api.g_varchar2) <>
240: nvl(p_rec.prl_information17, hr_api.g_varchar2) or
241: nvl(pay_pay_shd.g_old_rec.prl_information18, hr_api.g_varchar2) <>
242: nvl(p_rec.prl_information18, hr_api.g_varchar2) or
243: nvl(pay_pay_shd.g_old_rec.prl_information19, hr_api.g_varchar2) <>
244: nvl(p_rec.prl_information19, hr_api.g_varchar2) or
245: nvl(pay_pay_shd.g_old_rec.prl_information20, hr_api.g_varchar2) <>
246: nvl(p_rec.prl_information20, hr_api.g_varchar2) or
239: nvl(pay_pay_shd.g_old_rec.prl_information17, hr_api.g_varchar2) <>
240: nvl(p_rec.prl_information17, hr_api.g_varchar2) or
241: nvl(pay_pay_shd.g_old_rec.prl_information18, hr_api.g_varchar2) <>
242: nvl(p_rec.prl_information18, hr_api.g_varchar2) or
243: nvl(pay_pay_shd.g_old_rec.prl_information19, hr_api.g_varchar2) <>
244: nvl(p_rec.prl_information19, hr_api.g_varchar2) or
245: nvl(pay_pay_shd.g_old_rec.prl_information20, hr_api.g_varchar2) <>
246: nvl(p_rec.prl_information20, hr_api.g_varchar2) or
247: nvl(pay_pay_shd.g_old_rec.prl_information21, hr_api.g_varchar2) <>
240: nvl(p_rec.prl_information17, hr_api.g_varchar2) or
241: nvl(pay_pay_shd.g_old_rec.prl_information18, hr_api.g_varchar2) <>
242: nvl(p_rec.prl_information18, hr_api.g_varchar2) or
243: nvl(pay_pay_shd.g_old_rec.prl_information19, hr_api.g_varchar2) <>
244: nvl(p_rec.prl_information19, hr_api.g_varchar2) or
245: nvl(pay_pay_shd.g_old_rec.prl_information20, hr_api.g_varchar2) <>
246: nvl(p_rec.prl_information20, hr_api.g_varchar2) or
247: nvl(pay_pay_shd.g_old_rec.prl_information21, hr_api.g_varchar2) <>
248: nvl(p_rec.prl_information21, hr_api.g_varchar2) or
241: nvl(pay_pay_shd.g_old_rec.prl_information18, hr_api.g_varchar2) <>
242: nvl(p_rec.prl_information18, hr_api.g_varchar2) or
243: nvl(pay_pay_shd.g_old_rec.prl_information19, hr_api.g_varchar2) <>
244: nvl(p_rec.prl_information19, hr_api.g_varchar2) or
245: nvl(pay_pay_shd.g_old_rec.prl_information20, hr_api.g_varchar2) <>
246: nvl(p_rec.prl_information20, hr_api.g_varchar2) or
247: nvl(pay_pay_shd.g_old_rec.prl_information21, hr_api.g_varchar2) <>
248: nvl(p_rec.prl_information21, hr_api.g_varchar2) or
249: nvl(pay_pay_shd.g_old_rec.prl_information22, hr_api.g_varchar2) <>
242: nvl(p_rec.prl_information18, hr_api.g_varchar2) or
243: nvl(pay_pay_shd.g_old_rec.prl_information19, hr_api.g_varchar2) <>
244: nvl(p_rec.prl_information19, hr_api.g_varchar2) or
245: nvl(pay_pay_shd.g_old_rec.prl_information20, hr_api.g_varchar2) <>
246: nvl(p_rec.prl_information20, hr_api.g_varchar2) or
247: nvl(pay_pay_shd.g_old_rec.prl_information21, hr_api.g_varchar2) <>
248: nvl(p_rec.prl_information21, hr_api.g_varchar2) or
249: nvl(pay_pay_shd.g_old_rec.prl_information22, hr_api.g_varchar2) <>
250: nvl(p_rec.prl_information22, hr_api.g_varchar2) or
243: nvl(pay_pay_shd.g_old_rec.prl_information19, hr_api.g_varchar2) <>
244: nvl(p_rec.prl_information19, hr_api.g_varchar2) or
245: nvl(pay_pay_shd.g_old_rec.prl_information20, hr_api.g_varchar2) <>
246: nvl(p_rec.prl_information20, hr_api.g_varchar2) or
247: nvl(pay_pay_shd.g_old_rec.prl_information21, hr_api.g_varchar2) <>
248: nvl(p_rec.prl_information21, hr_api.g_varchar2) or
249: nvl(pay_pay_shd.g_old_rec.prl_information22, hr_api.g_varchar2) <>
250: nvl(p_rec.prl_information22, hr_api.g_varchar2) or
251: nvl(pay_pay_shd.g_old_rec.prl_information23, hr_api.g_varchar2) <>
244: nvl(p_rec.prl_information19, hr_api.g_varchar2) or
245: nvl(pay_pay_shd.g_old_rec.prl_information20, hr_api.g_varchar2) <>
246: nvl(p_rec.prl_information20, hr_api.g_varchar2) or
247: nvl(pay_pay_shd.g_old_rec.prl_information21, hr_api.g_varchar2) <>
248: nvl(p_rec.prl_information21, hr_api.g_varchar2) or
249: nvl(pay_pay_shd.g_old_rec.prl_information22, hr_api.g_varchar2) <>
250: nvl(p_rec.prl_information22, hr_api.g_varchar2) or
251: nvl(pay_pay_shd.g_old_rec.prl_information23, hr_api.g_varchar2) <>
252: nvl(p_rec.prl_information23, hr_api.g_varchar2) or
245: nvl(pay_pay_shd.g_old_rec.prl_information20, hr_api.g_varchar2) <>
246: nvl(p_rec.prl_information20, hr_api.g_varchar2) or
247: nvl(pay_pay_shd.g_old_rec.prl_information21, hr_api.g_varchar2) <>
248: nvl(p_rec.prl_information21, hr_api.g_varchar2) or
249: nvl(pay_pay_shd.g_old_rec.prl_information22, hr_api.g_varchar2) <>
250: nvl(p_rec.prl_information22, hr_api.g_varchar2) or
251: nvl(pay_pay_shd.g_old_rec.prl_information23, hr_api.g_varchar2) <>
252: nvl(p_rec.prl_information23, hr_api.g_varchar2) or
253: nvl(pay_pay_shd.g_old_rec.prl_information24, hr_api.g_varchar2) <>
246: nvl(p_rec.prl_information20, hr_api.g_varchar2) or
247: nvl(pay_pay_shd.g_old_rec.prl_information21, hr_api.g_varchar2) <>
248: nvl(p_rec.prl_information21, hr_api.g_varchar2) or
249: nvl(pay_pay_shd.g_old_rec.prl_information22, hr_api.g_varchar2) <>
250: nvl(p_rec.prl_information22, hr_api.g_varchar2) or
251: nvl(pay_pay_shd.g_old_rec.prl_information23, hr_api.g_varchar2) <>
252: nvl(p_rec.prl_information23, hr_api.g_varchar2) or
253: nvl(pay_pay_shd.g_old_rec.prl_information24, hr_api.g_varchar2) <>
254: nvl(p_rec.prl_information24, hr_api.g_varchar2) or
247: nvl(pay_pay_shd.g_old_rec.prl_information21, hr_api.g_varchar2) <>
248: nvl(p_rec.prl_information21, hr_api.g_varchar2) or
249: nvl(pay_pay_shd.g_old_rec.prl_information22, hr_api.g_varchar2) <>
250: nvl(p_rec.prl_information22, hr_api.g_varchar2) or
251: nvl(pay_pay_shd.g_old_rec.prl_information23, hr_api.g_varchar2) <>
252: nvl(p_rec.prl_information23, hr_api.g_varchar2) or
253: nvl(pay_pay_shd.g_old_rec.prl_information24, hr_api.g_varchar2) <>
254: nvl(p_rec.prl_information24, hr_api.g_varchar2) or
255: nvl(pay_pay_shd.g_old_rec.prl_information25, hr_api.g_varchar2) <>
248: nvl(p_rec.prl_information21, hr_api.g_varchar2) or
249: nvl(pay_pay_shd.g_old_rec.prl_information22, hr_api.g_varchar2) <>
250: nvl(p_rec.prl_information22, hr_api.g_varchar2) or
251: nvl(pay_pay_shd.g_old_rec.prl_information23, hr_api.g_varchar2) <>
252: nvl(p_rec.prl_information23, hr_api.g_varchar2) or
253: nvl(pay_pay_shd.g_old_rec.prl_information24, hr_api.g_varchar2) <>
254: nvl(p_rec.prl_information24, hr_api.g_varchar2) or
255: nvl(pay_pay_shd.g_old_rec.prl_information25, hr_api.g_varchar2) <>
256: nvl(p_rec.prl_information25, hr_api.g_varchar2) or
249: nvl(pay_pay_shd.g_old_rec.prl_information22, hr_api.g_varchar2) <>
250: nvl(p_rec.prl_information22, hr_api.g_varchar2) or
251: nvl(pay_pay_shd.g_old_rec.prl_information23, hr_api.g_varchar2) <>
252: nvl(p_rec.prl_information23, hr_api.g_varchar2) or
253: nvl(pay_pay_shd.g_old_rec.prl_information24, hr_api.g_varchar2) <>
254: nvl(p_rec.prl_information24, hr_api.g_varchar2) or
255: nvl(pay_pay_shd.g_old_rec.prl_information25, hr_api.g_varchar2) <>
256: nvl(p_rec.prl_information25, hr_api.g_varchar2) or
257: nvl(pay_pay_shd.g_old_rec.prl_information26, hr_api.g_varchar2) <>
250: nvl(p_rec.prl_information22, hr_api.g_varchar2) or
251: nvl(pay_pay_shd.g_old_rec.prl_information23, hr_api.g_varchar2) <>
252: nvl(p_rec.prl_information23, hr_api.g_varchar2) or
253: nvl(pay_pay_shd.g_old_rec.prl_information24, hr_api.g_varchar2) <>
254: nvl(p_rec.prl_information24, hr_api.g_varchar2) or
255: nvl(pay_pay_shd.g_old_rec.prl_information25, hr_api.g_varchar2) <>
256: nvl(p_rec.prl_information25, hr_api.g_varchar2) or
257: nvl(pay_pay_shd.g_old_rec.prl_information26, hr_api.g_varchar2) <>
258: nvl(p_rec.prl_information26, hr_api.g_varchar2) or
251: nvl(pay_pay_shd.g_old_rec.prl_information23, hr_api.g_varchar2) <>
252: nvl(p_rec.prl_information23, hr_api.g_varchar2) or
253: nvl(pay_pay_shd.g_old_rec.prl_information24, hr_api.g_varchar2) <>
254: nvl(p_rec.prl_information24, hr_api.g_varchar2) or
255: nvl(pay_pay_shd.g_old_rec.prl_information25, hr_api.g_varchar2) <>
256: nvl(p_rec.prl_information25, hr_api.g_varchar2) or
257: nvl(pay_pay_shd.g_old_rec.prl_information26, hr_api.g_varchar2) <>
258: nvl(p_rec.prl_information26, hr_api.g_varchar2) or
259: nvl(pay_pay_shd.g_old_rec.prl_information27, hr_api.g_varchar2) <>
252: nvl(p_rec.prl_information23, hr_api.g_varchar2) or
253: nvl(pay_pay_shd.g_old_rec.prl_information24, hr_api.g_varchar2) <>
254: nvl(p_rec.prl_information24, hr_api.g_varchar2) or
255: nvl(pay_pay_shd.g_old_rec.prl_information25, hr_api.g_varchar2) <>
256: nvl(p_rec.prl_information25, hr_api.g_varchar2) or
257: nvl(pay_pay_shd.g_old_rec.prl_information26, hr_api.g_varchar2) <>
258: nvl(p_rec.prl_information26, hr_api.g_varchar2) or
259: nvl(pay_pay_shd.g_old_rec.prl_information27, hr_api.g_varchar2) <>
260: nvl(p_rec.prl_information27, hr_api.g_varchar2) or
253: nvl(pay_pay_shd.g_old_rec.prl_information24, hr_api.g_varchar2) <>
254: nvl(p_rec.prl_information24, hr_api.g_varchar2) or
255: nvl(pay_pay_shd.g_old_rec.prl_information25, hr_api.g_varchar2) <>
256: nvl(p_rec.prl_information25, hr_api.g_varchar2) or
257: nvl(pay_pay_shd.g_old_rec.prl_information26, hr_api.g_varchar2) <>
258: nvl(p_rec.prl_information26, hr_api.g_varchar2) or
259: nvl(pay_pay_shd.g_old_rec.prl_information27, hr_api.g_varchar2) <>
260: nvl(p_rec.prl_information27, hr_api.g_varchar2) or
261: nvl(pay_pay_shd.g_old_rec.prl_information28, hr_api.g_varchar2) <>
254: nvl(p_rec.prl_information24, hr_api.g_varchar2) or
255: nvl(pay_pay_shd.g_old_rec.prl_information25, hr_api.g_varchar2) <>
256: nvl(p_rec.prl_information25, hr_api.g_varchar2) or
257: nvl(pay_pay_shd.g_old_rec.prl_information26, hr_api.g_varchar2) <>
258: nvl(p_rec.prl_information26, hr_api.g_varchar2) or
259: nvl(pay_pay_shd.g_old_rec.prl_information27, hr_api.g_varchar2) <>
260: nvl(p_rec.prl_information27, hr_api.g_varchar2) or
261: nvl(pay_pay_shd.g_old_rec.prl_information28, hr_api.g_varchar2) <>
262: nvl(p_rec.prl_information28, hr_api.g_varchar2) or
255: nvl(pay_pay_shd.g_old_rec.prl_information25, hr_api.g_varchar2) <>
256: nvl(p_rec.prl_information25, hr_api.g_varchar2) or
257: nvl(pay_pay_shd.g_old_rec.prl_information26, hr_api.g_varchar2) <>
258: nvl(p_rec.prl_information26, hr_api.g_varchar2) or
259: nvl(pay_pay_shd.g_old_rec.prl_information27, hr_api.g_varchar2) <>
260: nvl(p_rec.prl_information27, hr_api.g_varchar2) or
261: nvl(pay_pay_shd.g_old_rec.prl_information28, hr_api.g_varchar2) <>
262: nvl(p_rec.prl_information28, hr_api.g_varchar2) or
263: nvl(pay_pay_shd.g_old_rec.prl_information29, hr_api.g_varchar2) <>
256: nvl(p_rec.prl_information25, hr_api.g_varchar2) or
257: nvl(pay_pay_shd.g_old_rec.prl_information26, hr_api.g_varchar2) <>
258: nvl(p_rec.prl_information26, hr_api.g_varchar2) or
259: nvl(pay_pay_shd.g_old_rec.prl_information27, hr_api.g_varchar2) <>
260: nvl(p_rec.prl_information27, hr_api.g_varchar2) or
261: nvl(pay_pay_shd.g_old_rec.prl_information28, hr_api.g_varchar2) <>
262: nvl(p_rec.prl_information28, hr_api.g_varchar2) or
263: nvl(pay_pay_shd.g_old_rec.prl_information29, hr_api.g_varchar2) <>
264: nvl(p_rec.prl_information29, hr_api.g_varchar2) or
257: nvl(pay_pay_shd.g_old_rec.prl_information26, hr_api.g_varchar2) <>
258: nvl(p_rec.prl_information26, hr_api.g_varchar2) or
259: nvl(pay_pay_shd.g_old_rec.prl_information27, hr_api.g_varchar2) <>
260: nvl(p_rec.prl_information27, hr_api.g_varchar2) or
261: nvl(pay_pay_shd.g_old_rec.prl_information28, hr_api.g_varchar2) <>
262: nvl(p_rec.prl_information28, hr_api.g_varchar2) or
263: nvl(pay_pay_shd.g_old_rec.prl_information29, hr_api.g_varchar2) <>
264: nvl(p_rec.prl_information29, hr_api.g_varchar2) or
265: nvl(pay_pay_shd.g_old_rec.prl_information30, hr_api.g_varchar2) <>
258: nvl(p_rec.prl_information26, hr_api.g_varchar2) or
259: nvl(pay_pay_shd.g_old_rec.prl_information27, hr_api.g_varchar2) <>
260: nvl(p_rec.prl_information27, hr_api.g_varchar2) or
261: nvl(pay_pay_shd.g_old_rec.prl_information28, hr_api.g_varchar2) <>
262: nvl(p_rec.prl_information28, hr_api.g_varchar2) or
263: nvl(pay_pay_shd.g_old_rec.prl_information29, hr_api.g_varchar2) <>
264: nvl(p_rec.prl_information29, hr_api.g_varchar2) or
265: nvl(pay_pay_shd.g_old_rec.prl_information30, hr_api.g_varchar2) <>
266: nvl(p_rec.prl_information30, hr_api.g_varchar2) ))
259: nvl(pay_pay_shd.g_old_rec.prl_information27, hr_api.g_varchar2) <>
260: nvl(p_rec.prl_information27, hr_api.g_varchar2) or
261: nvl(pay_pay_shd.g_old_rec.prl_information28, hr_api.g_varchar2) <>
262: nvl(p_rec.prl_information28, hr_api.g_varchar2) or
263: nvl(pay_pay_shd.g_old_rec.prl_information29, hr_api.g_varchar2) <>
264: nvl(p_rec.prl_information29, hr_api.g_varchar2) or
265: nvl(pay_pay_shd.g_old_rec.prl_information30, hr_api.g_varchar2) <>
266: nvl(p_rec.prl_information30, hr_api.g_varchar2) ))
267: or (p_rec.payroll_id is null) then
260: nvl(p_rec.prl_information27, hr_api.g_varchar2) or
261: nvl(pay_pay_shd.g_old_rec.prl_information28, hr_api.g_varchar2) <>
262: nvl(p_rec.prl_information28, hr_api.g_varchar2) or
263: nvl(pay_pay_shd.g_old_rec.prl_information29, hr_api.g_varchar2) <>
264: nvl(p_rec.prl_information29, hr_api.g_varchar2) or
265: nvl(pay_pay_shd.g_old_rec.prl_information30, hr_api.g_varchar2) <>
266: nvl(p_rec.prl_information30, hr_api.g_varchar2) ))
267: or (p_rec.payroll_id is null) then
268: --
261: nvl(pay_pay_shd.g_old_rec.prl_information28, hr_api.g_varchar2) <>
262: nvl(p_rec.prl_information28, hr_api.g_varchar2) or
263: nvl(pay_pay_shd.g_old_rec.prl_information29, hr_api.g_varchar2) <>
264: nvl(p_rec.prl_information29, hr_api.g_varchar2) or
265: nvl(pay_pay_shd.g_old_rec.prl_information30, hr_api.g_varchar2) <>
266: nvl(p_rec.prl_information30, hr_api.g_varchar2) ))
267: or (p_rec.payroll_id is null) then
268: --
269: -- Only execute the validation if absolutely necessary:
262: nvl(p_rec.prl_information28, hr_api.g_varchar2) or
263: nvl(pay_pay_shd.g_old_rec.prl_information29, hr_api.g_varchar2) <>
264: nvl(p_rec.prl_information29, hr_api.g_varchar2) or
265: nvl(pay_pay_shd.g_old_rec.prl_information30, hr_api.g_varchar2) <>
266: nvl(p_rec.prl_information30, hr_api.g_varchar2) ))
267: or (p_rec.payroll_id is null) then
268: --
269: -- Only execute the validation if absolutely necessary:
270: -- a) During update, the structure column value or any
379: begin
380: hr_utility.set_location('Entering:'||l_proc,10);
381: --
382: if ((p_rec.payroll_id is not null) and (
383: nvl(pay_pay_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
384: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
385: nvl(pay_pay_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
386: nvl(p_rec.attribute1, hr_api.g_varchar2) or
387: nvl(pay_pay_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
380: hr_utility.set_location('Entering:'||l_proc,10);
381: --
382: if ((p_rec.payroll_id is not null) and (
383: nvl(pay_pay_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
384: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
385: nvl(pay_pay_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
386: nvl(p_rec.attribute1, hr_api.g_varchar2) or
387: nvl(pay_pay_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
388: nvl(p_rec.attribute2, hr_api.g_varchar2) or
381: --
382: if ((p_rec.payroll_id is not null) and (
383: nvl(pay_pay_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
384: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
385: nvl(pay_pay_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
386: nvl(p_rec.attribute1, hr_api.g_varchar2) or
387: nvl(pay_pay_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
388: nvl(p_rec.attribute2, hr_api.g_varchar2) or
389: nvl(pay_pay_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
382: if ((p_rec.payroll_id is not null) and (
383: nvl(pay_pay_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
384: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
385: nvl(pay_pay_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
386: nvl(p_rec.attribute1, hr_api.g_varchar2) or
387: nvl(pay_pay_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
388: nvl(p_rec.attribute2, hr_api.g_varchar2) or
389: nvl(pay_pay_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
390: nvl(p_rec.attribute3, hr_api.g_varchar2) or
383: nvl(pay_pay_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
384: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
385: nvl(pay_pay_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
386: nvl(p_rec.attribute1, hr_api.g_varchar2) or
387: nvl(pay_pay_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
388: nvl(p_rec.attribute2, hr_api.g_varchar2) or
389: nvl(pay_pay_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
390: nvl(p_rec.attribute3, hr_api.g_varchar2) or
391: nvl(pay_pay_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
384: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
385: nvl(pay_pay_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
386: nvl(p_rec.attribute1, hr_api.g_varchar2) or
387: nvl(pay_pay_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
388: nvl(p_rec.attribute2, hr_api.g_varchar2) or
389: nvl(pay_pay_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
390: nvl(p_rec.attribute3, hr_api.g_varchar2) or
391: nvl(pay_pay_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
392: nvl(p_rec.attribute4, hr_api.g_varchar2) or
385: nvl(pay_pay_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
386: nvl(p_rec.attribute1, hr_api.g_varchar2) or
387: nvl(pay_pay_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
388: nvl(p_rec.attribute2, hr_api.g_varchar2) or
389: nvl(pay_pay_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
390: nvl(p_rec.attribute3, hr_api.g_varchar2) or
391: nvl(pay_pay_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
392: nvl(p_rec.attribute4, hr_api.g_varchar2) or
393: nvl(pay_pay_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
386: nvl(p_rec.attribute1, hr_api.g_varchar2) or
387: nvl(pay_pay_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
388: nvl(p_rec.attribute2, hr_api.g_varchar2) or
389: nvl(pay_pay_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
390: nvl(p_rec.attribute3, hr_api.g_varchar2) or
391: nvl(pay_pay_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
392: nvl(p_rec.attribute4, hr_api.g_varchar2) or
393: nvl(pay_pay_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
394: nvl(p_rec.attribute5, hr_api.g_varchar2) or
387: nvl(pay_pay_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
388: nvl(p_rec.attribute2, hr_api.g_varchar2) or
389: nvl(pay_pay_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
390: nvl(p_rec.attribute3, hr_api.g_varchar2) or
391: nvl(pay_pay_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
392: nvl(p_rec.attribute4, hr_api.g_varchar2) or
393: nvl(pay_pay_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
394: nvl(p_rec.attribute5, hr_api.g_varchar2) or
395: nvl(pay_pay_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
388: nvl(p_rec.attribute2, hr_api.g_varchar2) or
389: nvl(pay_pay_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
390: nvl(p_rec.attribute3, hr_api.g_varchar2) or
391: nvl(pay_pay_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
392: nvl(p_rec.attribute4, hr_api.g_varchar2) or
393: nvl(pay_pay_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
394: nvl(p_rec.attribute5, hr_api.g_varchar2) or
395: nvl(pay_pay_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
396: nvl(p_rec.attribute6, hr_api.g_varchar2) or
389: nvl(pay_pay_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
390: nvl(p_rec.attribute3, hr_api.g_varchar2) or
391: nvl(pay_pay_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
392: nvl(p_rec.attribute4, hr_api.g_varchar2) or
393: nvl(pay_pay_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
394: nvl(p_rec.attribute5, hr_api.g_varchar2) or
395: nvl(pay_pay_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
396: nvl(p_rec.attribute6, hr_api.g_varchar2) or
397: nvl(pay_pay_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
390: nvl(p_rec.attribute3, hr_api.g_varchar2) or
391: nvl(pay_pay_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
392: nvl(p_rec.attribute4, hr_api.g_varchar2) or
393: nvl(pay_pay_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
394: nvl(p_rec.attribute5, hr_api.g_varchar2) or
395: nvl(pay_pay_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
396: nvl(p_rec.attribute6, hr_api.g_varchar2) or
397: nvl(pay_pay_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
398: nvl(p_rec.attribute7, hr_api.g_varchar2) or
391: nvl(pay_pay_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
392: nvl(p_rec.attribute4, hr_api.g_varchar2) or
393: nvl(pay_pay_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
394: nvl(p_rec.attribute5, hr_api.g_varchar2) or
395: nvl(pay_pay_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
396: nvl(p_rec.attribute6, hr_api.g_varchar2) or
397: nvl(pay_pay_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
398: nvl(p_rec.attribute7, hr_api.g_varchar2) or
399: nvl(pay_pay_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
392: nvl(p_rec.attribute4, hr_api.g_varchar2) or
393: nvl(pay_pay_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
394: nvl(p_rec.attribute5, hr_api.g_varchar2) or
395: nvl(pay_pay_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
396: nvl(p_rec.attribute6, hr_api.g_varchar2) or
397: nvl(pay_pay_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
398: nvl(p_rec.attribute7, hr_api.g_varchar2) or
399: nvl(pay_pay_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
400: nvl(p_rec.attribute8, hr_api.g_varchar2) or
393: nvl(pay_pay_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
394: nvl(p_rec.attribute5, hr_api.g_varchar2) or
395: nvl(pay_pay_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
396: nvl(p_rec.attribute6, hr_api.g_varchar2) or
397: nvl(pay_pay_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
398: nvl(p_rec.attribute7, hr_api.g_varchar2) or
399: nvl(pay_pay_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
400: nvl(p_rec.attribute8, hr_api.g_varchar2) or
401: nvl(pay_pay_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
394: nvl(p_rec.attribute5, hr_api.g_varchar2) or
395: nvl(pay_pay_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
396: nvl(p_rec.attribute6, hr_api.g_varchar2) or
397: nvl(pay_pay_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
398: nvl(p_rec.attribute7, hr_api.g_varchar2) or
399: nvl(pay_pay_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
400: nvl(p_rec.attribute8, hr_api.g_varchar2) or
401: nvl(pay_pay_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
402: nvl(p_rec.attribute9, hr_api.g_varchar2) or
395: nvl(pay_pay_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
396: nvl(p_rec.attribute6, hr_api.g_varchar2) or
397: nvl(pay_pay_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
398: nvl(p_rec.attribute7, hr_api.g_varchar2) or
399: nvl(pay_pay_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
400: nvl(p_rec.attribute8, hr_api.g_varchar2) or
401: nvl(pay_pay_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
402: nvl(p_rec.attribute9, hr_api.g_varchar2) or
403: nvl(pay_pay_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
396: nvl(p_rec.attribute6, hr_api.g_varchar2) or
397: nvl(pay_pay_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
398: nvl(p_rec.attribute7, hr_api.g_varchar2) or
399: nvl(pay_pay_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
400: nvl(p_rec.attribute8, hr_api.g_varchar2) or
401: nvl(pay_pay_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
402: nvl(p_rec.attribute9, hr_api.g_varchar2) or
403: nvl(pay_pay_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
404: nvl(p_rec.attribute10, hr_api.g_varchar2) or
397: nvl(pay_pay_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
398: nvl(p_rec.attribute7, hr_api.g_varchar2) or
399: nvl(pay_pay_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
400: nvl(p_rec.attribute8, hr_api.g_varchar2) or
401: nvl(pay_pay_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
402: nvl(p_rec.attribute9, hr_api.g_varchar2) or
403: nvl(pay_pay_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
404: nvl(p_rec.attribute10, hr_api.g_varchar2) or
405: nvl(pay_pay_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
398: nvl(p_rec.attribute7, hr_api.g_varchar2) or
399: nvl(pay_pay_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
400: nvl(p_rec.attribute8, hr_api.g_varchar2) or
401: nvl(pay_pay_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
402: nvl(p_rec.attribute9, hr_api.g_varchar2) or
403: nvl(pay_pay_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
404: nvl(p_rec.attribute10, hr_api.g_varchar2) or
405: nvl(pay_pay_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
406: nvl(p_rec.attribute11, hr_api.g_varchar2) or
399: nvl(pay_pay_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
400: nvl(p_rec.attribute8, hr_api.g_varchar2) or
401: nvl(pay_pay_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
402: nvl(p_rec.attribute9, hr_api.g_varchar2) or
403: nvl(pay_pay_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
404: nvl(p_rec.attribute10, hr_api.g_varchar2) or
405: nvl(pay_pay_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
406: nvl(p_rec.attribute11, hr_api.g_varchar2) or
407: nvl(pay_pay_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
400: nvl(p_rec.attribute8, hr_api.g_varchar2) or
401: nvl(pay_pay_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
402: nvl(p_rec.attribute9, hr_api.g_varchar2) or
403: nvl(pay_pay_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
404: nvl(p_rec.attribute10, hr_api.g_varchar2) or
405: nvl(pay_pay_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
406: nvl(p_rec.attribute11, hr_api.g_varchar2) or
407: nvl(pay_pay_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
408: nvl(p_rec.attribute12, hr_api.g_varchar2) or
401: nvl(pay_pay_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
402: nvl(p_rec.attribute9, hr_api.g_varchar2) or
403: nvl(pay_pay_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
404: nvl(p_rec.attribute10, hr_api.g_varchar2) or
405: nvl(pay_pay_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
406: nvl(p_rec.attribute11, hr_api.g_varchar2) or
407: nvl(pay_pay_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
408: nvl(p_rec.attribute12, hr_api.g_varchar2) or
409: nvl(pay_pay_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
402: nvl(p_rec.attribute9, hr_api.g_varchar2) or
403: nvl(pay_pay_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
404: nvl(p_rec.attribute10, hr_api.g_varchar2) or
405: nvl(pay_pay_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
406: nvl(p_rec.attribute11, hr_api.g_varchar2) or
407: nvl(pay_pay_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
408: nvl(p_rec.attribute12, hr_api.g_varchar2) or
409: nvl(pay_pay_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
410: nvl(p_rec.attribute13, hr_api.g_varchar2) or
403: nvl(pay_pay_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
404: nvl(p_rec.attribute10, hr_api.g_varchar2) or
405: nvl(pay_pay_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
406: nvl(p_rec.attribute11, hr_api.g_varchar2) or
407: nvl(pay_pay_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
408: nvl(p_rec.attribute12, hr_api.g_varchar2) or
409: nvl(pay_pay_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
410: nvl(p_rec.attribute13, hr_api.g_varchar2) or
411: nvl(pay_pay_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
404: nvl(p_rec.attribute10, hr_api.g_varchar2) or
405: nvl(pay_pay_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
406: nvl(p_rec.attribute11, hr_api.g_varchar2) or
407: nvl(pay_pay_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
408: nvl(p_rec.attribute12, hr_api.g_varchar2) or
409: nvl(pay_pay_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
410: nvl(p_rec.attribute13, hr_api.g_varchar2) or
411: nvl(pay_pay_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
412: nvl(p_rec.attribute14, hr_api.g_varchar2) or
405: nvl(pay_pay_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
406: nvl(p_rec.attribute11, hr_api.g_varchar2) or
407: nvl(pay_pay_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
408: nvl(p_rec.attribute12, hr_api.g_varchar2) or
409: nvl(pay_pay_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
410: nvl(p_rec.attribute13, hr_api.g_varchar2) or
411: nvl(pay_pay_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
412: nvl(p_rec.attribute14, hr_api.g_varchar2) or
413: nvl(pay_pay_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
406: nvl(p_rec.attribute11, hr_api.g_varchar2) or
407: nvl(pay_pay_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
408: nvl(p_rec.attribute12, hr_api.g_varchar2) or
409: nvl(pay_pay_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
410: nvl(p_rec.attribute13, hr_api.g_varchar2) or
411: nvl(pay_pay_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
412: nvl(p_rec.attribute14, hr_api.g_varchar2) or
413: nvl(pay_pay_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
414: nvl(p_rec.attribute15, hr_api.g_varchar2) or
407: nvl(pay_pay_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
408: nvl(p_rec.attribute12, hr_api.g_varchar2) or
409: nvl(pay_pay_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
410: nvl(p_rec.attribute13, hr_api.g_varchar2) or
411: nvl(pay_pay_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
412: nvl(p_rec.attribute14, hr_api.g_varchar2) or
413: nvl(pay_pay_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
414: nvl(p_rec.attribute15, hr_api.g_varchar2) or
415: nvl(pay_pay_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
408: nvl(p_rec.attribute12, hr_api.g_varchar2) or
409: nvl(pay_pay_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
410: nvl(p_rec.attribute13, hr_api.g_varchar2) or
411: nvl(pay_pay_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
412: nvl(p_rec.attribute14, hr_api.g_varchar2) or
413: nvl(pay_pay_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
414: nvl(p_rec.attribute15, hr_api.g_varchar2) or
415: nvl(pay_pay_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
416: nvl(p_rec.attribute16, hr_api.g_varchar2) or
409: nvl(pay_pay_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
410: nvl(p_rec.attribute13, hr_api.g_varchar2) or
411: nvl(pay_pay_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
412: nvl(p_rec.attribute14, hr_api.g_varchar2) or
413: nvl(pay_pay_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
414: nvl(p_rec.attribute15, hr_api.g_varchar2) or
415: nvl(pay_pay_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
416: nvl(p_rec.attribute16, hr_api.g_varchar2) or
417: nvl(pay_pay_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
410: nvl(p_rec.attribute13, hr_api.g_varchar2) or
411: nvl(pay_pay_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
412: nvl(p_rec.attribute14, hr_api.g_varchar2) or
413: nvl(pay_pay_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
414: nvl(p_rec.attribute15, hr_api.g_varchar2) or
415: nvl(pay_pay_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
416: nvl(p_rec.attribute16, hr_api.g_varchar2) or
417: nvl(pay_pay_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
418: nvl(p_rec.attribute17, hr_api.g_varchar2) or
411: nvl(pay_pay_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
412: nvl(p_rec.attribute14, hr_api.g_varchar2) or
413: nvl(pay_pay_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
414: nvl(p_rec.attribute15, hr_api.g_varchar2) or
415: nvl(pay_pay_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
416: nvl(p_rec.attribute16, hr_api.g_varchar2) or
417: nvl(pay_pay_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
418: nvl(p_rec.attribute17, hr_api.g_varchar2) or
419: nvl(pay_pay_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
412: nvl(p_rec.attribute14, hr_api.g_varchar2) or
413: nvl(pay_pay_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
414: nvl(p_rec.attribute15, hr_api.g_varchar2) or
415: nvl(pay_pay_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
416: nvl(p_rec.attribute16, hr_api.g_varchar2) or
417: nvl(pay_pay_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
418: nvl(p_rec.attribute17, hr_api.g_varchar2) or
419: nvl(pay_pay_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
420: nvl(p_rec.attribute18, hr_api.g_varchar2) or
413: nvl(pay_pay_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
414: nvl(p_rec.attribute15, hr_api.g_varchar2) or
415: nvl(pay_pay_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
416: nvl(p_rec.attribute16, hr_api.g_varchar2) or
417: nvl(pay_pay_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
418: nvl(p_rec.attribute17, hr_api.g_varchar2) or
419: nvl(pay_pay_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
420: nvl(p_rec.attribute18, hr_api.g_varchar2) or
421: nvl(pay_pay_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
414: nvl(p_rec.attribute15, hr_api.g_varchar2) or
415: nvl(pay_pay_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
416: nvl(p_rec.attribute16, hr_api.g_varchar2) or
417: nvl(pay_pay_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
418: nvl(p_rec.attribute17, hr_api.g_varchar2) or
419: nvl(pay_pay_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
420: nvl(p_rec.attribute18, hr_api.g_varchar2) or
421: nvl(pay_pay_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
422: nvl(p_rec.attribute19, hr_api.g_varchar2) or
415: nvl(pay_pay_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
416: nvl(p_rec.attribute16, hr_api.g_varchar2) or
417: nvl(pay_pay_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
418: nvl(p_rec.attribute17, hr_api.g_varchar2) or
419: nvl(pay_pay_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
420: nvl(p_rec.attribute18, hr_api.g_varchar2) or
421: nvl(pay_pay_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
422: nvl(p_rec.attribute19, hr_api.g_varchar2) or
423: nvl(pay_pay_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
416: nvl(p_rec.attribute16, hr_api.g_varchar2) or
417: nvl(pay_pay_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
418: nvl(p_rec.attribute17, hr_api.g_varchar2) or
419: nvl(pay_pay_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
420: nvl(p_rec.attribute18, hr_api.g_varchar2) or
421: nvl(pay_pay_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
422: nvl(p_rec.attribute19, hr_api.g_varchar2) or
423: nvl(pay_pay_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
424: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
417: nvl(pay_pay_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
418: nvl(p_rec.attribute17, hr_api.g_varchar2) or
419: nvl(pay_pay_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
420: nvl(p_rec.attribute18, hr_api.g_varchar2) or
421: nvl(pay_pay_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
422: nvl(p_rec.attribute19, hr_api.g_varchar2) or
423: nvl(pay_pay_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
424: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
425: or (p_rec.payroll_id is null) then
418: nvl(p_rec.attribute17, hr_api.g_varchar2) or
419: nvl(pay_pay_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
420: nvl(p_rec.attribute18, hr_api.g_varchar2) or
421: nvl(pay_pay_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
422: nvl(p_rec.attribute19, hr_api.g_varchar2) or
423: nvl(pay_pay_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
424: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
425: or (p_rec.payroll_id is null) then
426: --
419: nvl(pay_pay_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
420: nvl(p_rec.attribute18, hr_api.g_varchar2) or
421: nvl(pay_pay_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
422: nvl(p_rec.attribute19, hr_api.g_varchar2) or
423: nvl(pay_pay_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
424: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
425: or (p_rec.payroll_id is null) then
426: --
427: -- Only execute the validation if absolutely necessary:
420: nvl(p_rec.attribute18, hr_api.g_varchar2) or
421: nvl(pay_pay_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
422: nvl(p_rec.attribute19, hr_api.g_varchar2) or
423: nvl(pay_pay_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
424: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
425: or (p_rec.payroll_id is null) then
426: --
427: -- Only execute the validation if absolutely necessary:
428: -- a) During update, the structure column value or any
530: fnd_message.set_token('STEP ', '5');
531: fnd_message.raise_error;
532: END IF;
533:
534: if nvl(p_rec.gl_set_of_books_id, hr_api.g_number) <>
535: nvl(pay_pay_shd.g_old_rec.gl_set_of_books_id, hr_api.g_number) then
536: --
537: hr_api.argument_changed_error
538: (p_api_name => l_proc
531: fnd_message.raise_error;
532: END IF;
533:
534: if nvl(p_rec.gl_set_of_books_id, hr_api.g_number) <>
535: nvl(pay_pay_shd.g_old_rec.gl_set_of_books_id, hr_api.g_number) then
536: --
537: hr_api.argument_changed_error
538: (p_api_name => l_proc
539: ,p_argument => 'GL_SET_OF_BOOKS_ID'
533:
534: if nvl(p_rec.gl_set_of_books_id, hr_api.g_number) <>
535: nvl(pay_pay_shd.g_old_rec.gl_set_of_books_id, hr_api.g_number) then
536: --
537: hr_api.argument_changed_error
538: (p_api_name => l_proc
539: ,p_argument => 'GL_SET_OF_BOOKS_ID'
540: ,p_base_table => pay_pay_shd.g_tab_nam
541: );
541: );
542: --
543: end if;
544:
545: if nvl(p_rec.period_type, hr_api.g_varchar2) <>
546: nvl(pay_pay_shd.g_old_rec.period_type, hr_api.g_varchar2) then
547: --
548: hr_api.argument_changed_error
549: (p_api_name => l_proc
542: --
543: end if;
544:
545: if nvl(p_rec.period_type, hr_api.g_varchar2) <>
546: nvl(pay_pay_shd.g_old_rec.period_type, hr_api.g_varchar2) then
547: --
548: hr_api.argument_changed_error
549: (p_api_name => l_proc
550: ,p_argument => 'PERIOD_TYPE'
544:
545: if nvl(p_rec.period_type, hr_api.g_varchar2) <>
546: nvl(pay_pay_shd.g_old_rec.period_type, hr_api.g_varchar2) then
547: --
548: hr_api.argument_changed_error
549: (p_api_name => l_proc
550: ,p_argument => 'PERIOD_TYPE'
551: ,p_base_table => pay_pay_shd.g_tab_nam
552: );
552: );
553: --
554: end if;
555:
556: if nvl(p_rec.organization_id, hr_api.g_number) <>
557: nvl(pay_pay_shd.g_old_rec.organization_id, hr_api.g_number) then
558: --
559: hr_api.argument_changed_error
560: (p_api_name => l_proc
553: --
554: end if;
555:
556: if nvl(p_rec.organization_id, hr_api.g_number) <>
557: nvl(pay_pay_shd.g_old_rec.organization_id, hr_api.g_number) then
558: --
559: hr_api.argument_changed_error
560: (p_api_name => l_proc
561: ,p_argument => 'ORGANIZATION_ID'
555:
556: if nvl(p_rec.organization_id, hr_api.g_number) <>
557: nvl(pay_pay_shd.g_old_rec.organization_id, hr_api.g_number) then
558: --
559: hr_api.argument_changed_error
560: (p_api_name => l_proc
561: ,p_argument => 'ORGANIZATION_ID'
562: ,p_base_table => pay_pay_shd.g_tab_nam
563: );
563: );
564: --
565: end if;
566:
567: if nvl(p_rec.cut_off_date_offset , hr_api.g_number) <>
568: nvl(pay_pay_shd.g_old_rec.cut_off_date_offset, hr_api.g_number) then
569: --
570: hr_api.argument_changed_error
571: (p_api_name => l_proc
564: --
565: end if;
566:
567: if nvl(p_rec.cut_off_date_offset , hr_api.g_number) <>
568: nvl(pay_pay_shd.g_old_rec.cut_off_date_offset, hr_api.g_number) then
569: --
570: hr_api.argument_changed_error
571: (p_api_name => l_proc
572: ,p_argument => 'CUT_OFF_DATE_OFFSET'
566:
567: if nvl(p_rec.cut_off_date_offset , hr_api.g_number) <>
568: nvl(pay_pay_shd.g_old_rec.cut_off_date_offset, hr_api.g_number) then
569: --
570: hr_api.argument_changed_error
571: (p_api_name => l_proc
572: ,p_argument => 'CUT_OFF_DATE_OFFSET'
573: ,p_base_table => pay_pay_shd.g_tab_nam
574: );
574: );
575: --
576: end if;
577:
578: if nvl(p_rec.direct_deposit_date_offset , hr_api.g_number) <>
579: nvl(pay_pay_shd.g_old_rec.direct_deposit_date_offset, hr_api.g_number) then
580: --
581: hr_api.argument_changed_error
582: (p_api_name => l_proc
575: --
576: end if;
577:
578: if nvl(p_rec.direct_deposit_date_offset , hr_api.g_number) <>
579: nvl(pay_pay_shd.g_old_rec.direct_deposit_date_offset, hr_api.g_number) then
580: --
581: hr_api.argument_changed_error
582: (p_api_name => l_proc
583: ,p_argument => 'DIRECT_DEPOSIT_DATE_OFFSET'
577:
578: if nvl(p_rec.direct_deposit_date_offset , hr_api.g_number) <>
579: nvl(pay_pay_shd.g_old_rec.direct_deposit_date_offset, hr_api.g_number) then
580: --
581: hr_api.argument_changed_error
582: (p_api_name => l_proc
583: ,p_argument => 'DIRECT_DEPOSIT_DATE_OFFSET'
584: ,p_base_table => pay_pay_shd.g_tab_nam
585: );
585: );
586: --
587: end if;
588:
589: if nvl(p_rec.first_period_end_date , hr_api.g_date) <>
590: nvl(pay_pay_shd.g_old_rec.first_period_end_date, hr_api.g_date) then
591: --
592: hr_api.argument_changed_error
593: (p_api_name => l_proc
586: --
587: end if;
588:
589: if nvl(p_rec.first_period_end_date , hr_api.g_date) <>
590: nvl(pay_pay_shd.g_old_rec.first_period_end_date, hr_api.g_date) then
591: --
592: hr_api.argument_changed_error
593: (p_api_name => l_proc
594: ,p_argument => 'FIRST_PERIOD_END_DATE'
588:
589: if nvl(p_rec.first_period_end_date , hr_api.g_date) <>
590: nvl(pay_pay_shd.g_old_rec.first_period_end_date, hr_api.g_date) then
591: --
592: hr_api.argument_changed_error
593: (p_api_name => l_proc
594: ,p_argument => 'FIRST_PERIOD_END_DATE'
595: ,p_base_table => pay_pay_shd.g_tab_nam
596: );
596: );
597: --
598: end if;
599:
600: if nvl(p_rec.pay_advice_date_offset , hr_api.g_number) <>
601: nvl(pay_pay_shd.g_old_rec.pay_advice_date_offset, hr_api.g_number) then
602: --
603: hr_api.argument_changed_error
604: (p_api_name => l_proc
597: --
598: end if;
599:
600: if nvl(p_rec.pay_advice_date_offset , hr_api.g_number) <>
601: nvl(pay_pay_shd.g_old_rec.pay_advice_date_offset, hr_api.g_number) then
602: --
603: hr_api.argument_changed_error
604: (p_api_name => l_proc
605: ,p_argument => 'PAY_ADVICE_DATE_OFFSET'
599:
600: if nvl(p_rec.pay_advice_date_offset , hr_api.g_number) <>
601: nvl(pay_pay_shd.g_old_rec.pay_advice_date_offset, hr_api.g_number) then
602: --
603: hr_api.argument_changed_error
604: (p_api_name => l_proc
605: ,p_argument => 'PAY_ADVICE_DATE_OFFSET'
606: ,p_base_table => pay_pay_shd.g_tab_nam
607: );
607: );
608: --
609: end if;
610:
611: if nvl(p_rec.pay_date_offset , hr_api.g_number) <>
612: nvl(pay_pay_shd.g_old_rec.pay_date_offset, hr_api.g_number) then
613: --
614: hr_api.argument_changed_error
615: (p_api_name => l_proc
608: --
609: end if;
610:
611: if nvl(p_rec.pay_date_offset , hr_api.g_number) <>
612: nvl(pay_pay_shd.g_old_rec.pay_date_offset, hr_api.g_number) then
613: --
614: hr_api.argument_changed_error
615: (p_api_name => l_proc
616: ,p_argument => 'PAY_DATE_OFFSET'
610:
611: if nvl(p_rec.pay_date_offset , hr_api.g_number) <>
612: nvl(pay_pay_shd.g_old_rec.pay_date_offset, hr_api.g_number) then
613: --
614: hr_api.argument_changed_error
615: (p_api_name => l_proc
616: ,p_argument => 'PAY_DATE_OFFSET'
617: ,p_base_table => pay_pay_shd.g_tab_nam
618: );
618: );
619: --
620: end if;
621:
622: if nvl(p_rec.midpoint_offset , hr_api.g_number) <>
623: nvl(pay_pay_shd.g_old_rec.midpoint_offset, hr_api.g_number) then
624: --
625: hr_api.argument_changed_error
626: (p_api_name => l_proc
619: --
620: end if;
621:
622: if nvl(p_rec.midpoint_offset , hr_api.g_number) <>
623: nvl(pay_pay_shd.g_old_rec.midpoint_offset, hr_api.g_number) then
624: --
625: hr_api.argument_changed_error
626: (p_api_name => l_proc
627: ,p_argument => 'MIDPOINT_OFFSET'
621:
622: if nvl(p_rec.midpoint_offset , hr_api.g_number) <>
623: nvl(pay_pay_shd.g_old_rec.midpoint_offset, hr_api.g_number) then
624: --
625: hr_api.argument_changed_error
626: (p_api_name => l_proc
627: ,p_argument => 'MIDPOINT_OFFSET'
628: ,p_base_table => pay_pay_shd.g_tab_nam
629: );
629: );
630: --
631: end if;
632:
633: if nvl(p_rec.payroll_type , hr_api.g_varchar2) <>
634: nvl(pay_pay_shd.g_old_rec.payroll_type, hr_api.g_varchar2) then
635: --
636: hr_api.argument_changed_error
637: (p_api_name => l_proc
630: --
631: end if;
632:
633: if nvl(p_rec.payroll_type , hr_api.g_varchar2) <>
634: nvl(pay_pay_shd.g_old_rec.payroll_type, hr_api.g_varchar2) then
635: --
636: hr_api.argument_changed_error
637: (p_api_name => l_proc
638: ,p_argument => 'PAYROLL_TYPE'
632:
633: if nvl(p_rec.payroll_type , hr_api.g_varchar2) <>
634: nvl(pay_pay_shd.g_old_rec.payroll_type, hr_api.g_varchar2) then
635: --
636: hr_api.argument_changed_error
637: (p_api_name => l_proc
638: ,p_argument => 'PAYROLL_TYPE'
639: ,p_base_table => pay_pay_shd.g_tab_nam
640: );
640: );
641: --
642: end if;
643:
644: if nvl(p_rec.period_reset_years, hr_api.g_varchar2) <>
645: nvl(pay_pay_shd.g_old_rec.period_reset_years, hr_api.g_varchar2) then
646: --
647: hr_api.argument_changed_error
648: (p_api_name => l_proc
641: --
642: end if;
643:
644: if nvl(p_rec.period_reset_years, hr_api.g_varchar2) <>
645: nvl(pay_pay_shd.g_old_rec.period_reset_years, hr_api.g_varchar2) then
646: --
647: hr_api.argument_changed_error
648: (p_api_name => l_proc
649: ,p_argument => 'PERIOD_RESET_YEARS'
643:
644: if nvl(p_rec.period_reset_years, hr_api.g_varchar2) <>
645: nvl(pay_pay_shd.g_old_rec.period_reset_years, hr_api.g_varchar2) then
646: --
647: hr_api.argument_changed_error
648: (p_api_name => l_proc
649: ,p_argument => 'PERIOD_RESET_YEARS'
650: ,p_base_table => pay_pay_shd.g_tab_nam
651: );
683: --
684: -- {End Of Comments}
685: -- ----------------------------------------------------------------------------
686: Procedure dt_update_validate
687: (p_org_payment_method_id in number default hr_api.g_number
688: ,p_datetrack_mode in varchar2
689: ,p_validation_start_date in date
690: ,p_validation_end_date in date
691: ) Is
695: Begin
696: --
697: -- Ensure that the p_datetrack_mode argument is not null
698: --
699: hr_api.mandatory_arg_error
700: (p_api_name => l_proc
701: ,p_argument => 'datetrack_mode'
702: ,p_argument_value => p_datetrack_mode
703: );
705: -- Mode will be valid, as this is checked at the start of the upd.
706: --
707: -- Ensure the arguments are not null
708: --
709: hr_api.mandatory_arg_error
710: (p_api_name => l_proc
711: ,p_argument => 'validation_start_date'
712: ,p_argument_value => p_validation_start_date
713: );
711: ,p_argument => 'validation_start_date'
712: ,p_argument_value => p_validation_start_date
713: );
714: --
715: hr_api.mandatory_arg_error
716: (p_api_name => l_proc
717: ,p_argument => 'validation_end_date'
718: ,p_argument_value => p_validation_end_date
719: );
717: ,p_argument => 'validation_end_date'
718: ,p_argument_value => p_validation_end_date
719: );
720: --
721: If ((nvl(p_org_payment_method_id, hr_api.g_number) <> hr_api.g_number) and
722: NOT (dt_api.check_min_max_dates
723: (p_base_table_name => 'pay_org_payment_methods_f'
724: ,p_base_key_column => 'ORG_PAYMENT_METHOD_ID'
725: ,p_base_key_value => p_org_payment_method_id
798: --
799: -- Ensure that the p_datetrack_mode argument is not null
800: --
801: hr_utility.set_location('Entering:'||l_proc, 5);
802: hr_api.mandatory_arg_error
803: (p_api_name => l_proc
804: ,p_argument => 'datetrack_mode'
805: ,p_argument_value => p_datetrack_mode
806: );
807: --
808: -- Only perform the validation if the datetrack mode is either
809: -- DELETE or ZAP
810: --
811: If (p_datetrack_mode = hr_api.g_delete or
812: p_datetrack_mode = hr_api.g_zap) then
813: --
814: --
815: -- Ensure the arguments are not null
808: -- Only perform the validation if the datetrack mode is either
809: -- DELETE or ZAP
810: --
811: If (p_datetrack_mode = hr_api.g_delete or
812: p_datetrack_mode = hr_api.g_zap) then
813: --
814: --
815: -- Ensure the arguments are not null
816: --
813: --
814: --
815: -- Ensure the arguments are not null
816: --
817: hr_api.mandatory_arg_error
818: (p_api_name => l_proc
819: ,p_argument => 'validation_start_date'
820: ,p_argument_value => p_validation_start_date
821: );
819: ,p_argument => 'validation_start_date'
820: ,p_argument_value => p_validation_start_date
821: );
822: --
823: hr_api.mandatory_arg_error
824: (p_api_name => l_proc
825: ,p_argument => 'validation_end_date'
826: ,p_argument_value => p_validation_end_date
827: );
825: ,p_argument => 'validation_end_date'
826: ,p_argument_value => p_validation_end_date
827: );
828: --
829: hr_api.mandatory_arg_error
830: (p_api_name => l_proc
831: ,p_argument => 'payroll_id'
832: ,p_argument_value => p_payroll_id
833: );
959: end if;
960: --
961: -- Payment method must be valid for the lifetime of payroll
962: --
963: if v_start_date > p_effective_date or v_end_date < hr_api.g_eot then
964: --
965: fnd_message.set_name('PAY', 'HR_7096_PAYM_PYRLL_DFLT_INVID');
966: fnd_message.raise_error;
967: --
1236: p_effective_date in date
1237: ,p_negative_pay_allowed_flag in varchar2
1238: ) is
1239: begin
1240: if hr_api.not_exists_in_hr_lookups
1241: (p_effective_date
1242: ,'YES_NO'
1243: ,p_negative_pay_allowed_flag) then
1244: --
1361: ,p_arrears_flag in varchar2
1362: ,p_arrears_flag_rule in varchar2
1363: ) is
1364: begin
1365: if hr_api.not_exists_in_hr_lookups
1366: (p_effective_date
1367: ,'YES_NO'
1368: ,p_arrears_flag) then
1369: --
1401: begin
1402: --
1403: -- Check that the value supplied for payroll type exists in HR_LOOKUPS
1404: --
1405: if hr_api.not_exists_in_hr_lookups
1406: (p_effective_date
1407: ,'PAYROLL_TYPE'
1408: ,p_payroll_type) then
1409: --
1467: close get_legislation_rule;
1468: --
1469: -- Multi_assignments_flag must exist in HR_LOOKUPS
1470: --
1471: if hr_api.not_exists_in_hr_lookups
1472: (p_effective_date
1473: ,'YES_NO'
1474: ,p_multi_assignments_flag) then
1475: --
1532: p_effective_date in date
1533: ,p_workload_shifting_level in varchar2
1534: ) is
1535: begin
1536: if hr_api.not_exists_in_hr_lookups
1537: (p_effective_date
1538: ,'WORKLOAD_SHIFTING_LEVEL'
1539: ,p_workload_shifting_level) then
1540: --
1589: where organization_id = p_organization_id;
1590: --
1591: begin
1592: --
1593: if (p_datetrack_mode = hr_api.g_insert and
1594: p_cost_allocation_keyflex_id is not null)
1595: or ((p_datetrack_mode <> hr_api.g_insert) and
1596: (p_cost_allocation_keyflex_id <>
1597: nvl(pay_pay_shd.g_old_rec.COST_ALLOCATION_KEYFLEX_ID, hr_api.g_number)))
1591: begin
1592: --
1593: if (p_datetrack_mode = hr_api.g_insert and
1594: p_cost_allocation_keyflex_id is not null)
1595: or ((p_datetrack_mode <> hr_api.g_insert) and
1596: (p_cost_allocation_keyflex_id <>
1597: nvl(pay_pay_shd.g_old_rec.COST_ALLOCATION_KEYFLEX_ID, hr_api.g_number)))
1598: then
1599: --
1593: if (p_datetrack_mode = hr_api.g_insert and
1594: p_cost_allocation_keyflex_id is not null)
1595: or ((p_datetrack_mode <> hr_api.g_insert) and
1596: (p_cost_allocation_keyflex_id <>
1597: nvl(pay_pay_shd.g_old_rec.COST_ALLOCATION_KEYFLEX_ID, hr_api.g_number)))
1598: then
1599: --
1600: open csr_chk_keyflexs (p_cost_allocation_keyflex_id);
1601: fetch csr_chk_keyflexs into g_exists;
1611: close csr_chk_keyflexs;
1612: --
1613: end if;
1614: --
1615: if (p_datetrack_mode = hr_api.g_insert and
1616: p_suspense_account_keyflex_id is not null)
1617: or ((p_datetrack_mode <> hr_api.g_insert) and
1618: (p_suspense_account_keyflex_id <>
1619: nvl(pay_pay_shd.g_old_rec.suspense_account_keyflex_id, hr_api.g_number)))
1613: end if;
1614: --
1615: if (p_datetrack_mode = hr_api.g_insert and
1616: p_suspense_account_keyflex_id is not null)
1617: or ((p_datetrack_mode <> hr_api.g_insert) and
1618: (p_suspense_account_keyflex_id <>
1619: nvl(pay_pay_shd.g_old_rec.suspense_account_keyflex_id, hr_api.g_number)))
1620: then
1621: --
1615: if (p_datetrack_mode = hr_api.g_insert and
1616: p_suspense_account_keyflex_id is not null)
1617: or ((p_datetrack_mode <> hr_api.g_insert) and
1618: (p_suspense_account_keyflex_id <>
1619: nvl(pay_pay_shd.g_old_rec.suspense_account_keyflex_id, hr_api.g_number)))
1620: then
1621: --
1622: open csr_chk_keyflexs (p_suspense_account_keyflex_id);
1623: fetch csr_chk_keyflexs into g_exists;
1633: close csr_chk_keyflexs;
1634: --
1635: end if;
1636: --
1637: if (p_datetrack_mode = hr_api.g_insert and
1638: p_soft_coding_keyflex_id is not null)
1639: or ((p_datetrack_mode <> hr_api.g_insert) and
1640: (p_soft_coding_keyflex_id <>
1641: nvl(pay_pay_shd.g_old_rec.soft_coding_keyflex_id, hr_api.g_number)))
1635: end if;
1636: --
1637: if (p_datetrack_mode = hr_api.g_insert and
1638: p_soft_coding_keyflex_id is not null)
1639: or ((p_datetrack_mode <> hr_api.g_insert) and
1640: (p_soft_coding_keyflex_id <>
1641: nvl(pay_pay_shd.g_old_rec.soft_coding_keyflex_id, hr_api.g_number)))
1642: then
1643: --
1637: if (p_datetrack_mode = hr_api.g_insert and
1638: p_soft_coding_keyflex_id is not null)
1639: or ((p_datetrack_mode <> hr_api.g_insert) and
1640: (p_soft_coding_keyflex_id <>
1641: nvl(pay_pay_shd.g_old_rec.soft_coding_keyflex_id, hr_api.g_number)))
1642: then
1643: --
1644: open csr_chk_soft_coding_kff;
1645: fetch csr_chk_soft_coding_kff into g_exists;
1655: close csr_chk_soft_coding_kff;
1656: --
1657: end if;
1658: --
1659: if (p_datetrack_mode = hr_api.g_insert and
1660: p_gl_set_of_books_id is not null)
1661: then
1662: --
1663: open csr_chk_set_of_books;
1674: --
1675: close csr_chk_set_of_books;
1676: end if;
1677: --
1678: if (p_datetrack_mode = hr_api.g_insert and
1679: p_organization_id is not null)
1680: then
1681: open csr_chk_org;
1682: fetch csr_chk_org into g_exists;
1725: pay_pay_bus.chk_consolidation_set_id(p_rec.consolidation_set_id,
1726: l_business_group_id);
1727: p_rec.business_group_id := l_business_group_id;
1728:
1729: hr_api.validate_bus_grp_id
1730: (p_business_group_id => p_rec.business_group_id
1731: ,p_associated_column1 => pay_pay_shd.g_tab_nam
1732: || '.BUSINESS_GROUP_ID');
1733: --
1749: );
1750: --
1751: end if;
1752:
1753: g_legislation_code := hr_api.return_legislation_code(p_rec.business_group_id);
1754:
1755: chk_period_type
1756: (p_period_type => p_rec.period_type
1757: ,p_legislation_code => g_legislation_code
1832: ,p_suspense_account_keyflex_id => p_rec.suspense_account_keyflex_id
1833: ,p_gl_set_of_books_id => p_rec.gl_set_of_books_id
1834: ,p_soft_coding_keyflex_id => p_rec.soft_coding_keyflex_id
1835: ,p_organization_id => p_rec.organization_id
1836: ,p_datetrack_mode => hr_api.g_insert
1837: );
1838: --
1839: chk_workload_shifting_level
1840: (p_effective_date => p_effective_date
1868: hr_utility.set_location('Entering:'||l_proc, 5);
1869: --
1870: -- Call all supporting business operations
1871: --
1872: hr_api.validate_bus_grp_id
1873: (p_business_group_id => p_rec.business_group_id
1874: ,p_associated_column1 => pay_pay_shd.g_tab_nam
1875: || '.BUSINESS_GROUP_ID');
1876:
1876:
1877: hr_multi_message.end_validation_set;
1878: --
1879: if p_rec.default_payment_method_id <>
1880: nvl(pay_pay_shd.g_old_rec.default_payment_method_id, hr_api.g_number) then
1881: pay_pay_bus.chk_default_payment_method_id
1882: (p_effective_date => p_effective_date
1883: ,p_business_group_id => p_rec.business_group_id
1884: ,p_default_payment_method_id => p_rec.default_payment_method_id
1885: );
1886: end if;
1887: --
1888: if p_rec.consolidation_set_id <>
1889: nvl(pay_pay_shd.g_old_rec.consolidation_set_id, hr_api.g_number) then
1890: --
1891: pay_pay_bus.chk_consolidation_set_id( p_rec.consolidation_set_id,
1892: l_business_group_id );
1893: if (l_business_group_id <> p_rec.business_group_id) then
1900: End if;
1901: --
1902: --
1903: if p_rec.negative_pay_allowed_flag <>
1904: nvl(pay_pay_shd.g_old_rec.negative_pay_allowed_flag, hr_api.g_varchar2) then
1905: --
1906: pay_pay_bus.chk_negative_pay_allowed_flag
1907: (p_effective_date => p_effective_date
1908: ,p_negative_pay_allowed_flag => p_rec.negative_pay_allowed_flag
1939: ,p_pay_date_rule => l_dummy
1940: ,p_arrears_flag_rule => l_arrears_flag_rule
1941: );
1942: --
1943: if p_rec.arrears_flag <> nvl(pay_pay_shd.g_old_rec.arrears_flag, hr_api.g_varchar2) then
1944: --
1945: pay_pay_bus.chk_arrears_flag
1946: (p_effective_date => p_effective_date
1947: ,p_arrears_flag => p_rec.arrears_flag
1950: --
1951: end if;
1952: --
1953: if p_rec.multi_assignments_flag <>
1954: nvl(pay_pay_shd.g_old_rec.multi_assignments_flag, hr_api.g_varchar2) then
1955: --
1956: pay_pay_bus.chk_multi_assignments_flag
1957: (p_effective_date => p_effective_date
1958: ,p_multi_assignments_flag => p_rec.multi_assignments_flag