eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_OPM_BUS dependencies on HR_API

Line 44: hr_api.mandatory_arg_error

40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: --
42: -- Ensure that all the mandatory parameter are not null
43: --
44: hr_api.mandatory_arg_error
45: (p_api_name => l_proc
46: ,p_argument => 'org_payment_method_id'
47: ,p_argument_value => p_org_payment_method_id
48: );

Line 67: hr_api.set_security_group_id

63: close csr_sec_grp;
64: --
65: -- Set the security_group_id in CLIENT_INFO
66: --
67: hr_api.set_security_group_id
68: (p_security_group_id => l_security_group_id
69: );
70: --
71: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 104: hr_api.mandatory_arg_error

100: hr_utility.set_location('Entering:'|| l_proc, 10);
101: --
102: -- Ensure that all the mandatory parameter are not null
103: --
104: hr_api.mandatory_arg_error
105: (p_api_name => l_proc
106: ,p_argument => 'org_payment_method_id'
107: ,p_argument_value => p_org_payment_method_id
108: );

Line 110: if ( nvl(pay_opm_bus.g_org_payment_method_id, hr_api.g_number)

106: ,p_argument => 'org_payment_method_id'
107: ,p_argument_value => p_org_payment_method_id
108: );
109: --
110: if ( nvl(pay_opm_bus.g_org_payment_method_id, hr_api.g_number)
111: = p_org_payment_method_id) then
112: --
113: -- The legislation code has already been found with a previous
114: -- call to this function. Just return the value in the global

Line 186: nvl(pay_opm_shd.g_old_rec.pmeth_information_category, hr_api.g_varchar2) <>

182: begin
183: hr_utility.set_location('Entering:'||l_proc,10);
184: --
185: if ((p_rec.org_payment_method_id is not null) and (
186: nvl(pay_opm_shd.g_old_rec.pmeth_information_category, hr_api.g_varchar2) <>
187: nvl(p_rec.pmeth_information_category, hr_api.g_varchar2) or
188: nvl(pay_opm_shd.g_old_rec.pmeth_information1, hr_api.g_varchar2) <>
189: nvl(p_rec.pmeth_information1, hr_api.g_varchar2) or
190: nvl(pay_opm_shd.g_old_rec.pmeth_information2, hr_api.g_varchar2) <>

Line 187: nvl(p_rec.pmeth_information_category, hr_api.g_varchar2) or

183: hr_utility.set_location('Entering:'||l_proc,10);
184: --
185: if ((p_rec.org_payment_method_id is not null) and (
186: nvl(pay_opm_shd.g_old_rec.pmeth_information_category, hr_api.g_varchar2) <>
187: nvl(p_rec.pmeth_information_category, hr_api.g_varchar2) or
188: nvl(pay_opm_shd.g_old_rec.pmeth_information1, hr_api.g_varchar2) <>
189: nvl(p_rec.pmeth_information1, hr_api.g_varchar2) or
190: nvl(pay_opm_shd.g_old_rec.pmeth_information2, hr_api.g_varchar2) <>
191: nvl(p_rec.pmeth_information2, hr_api.g_varchar2) or

Line 188: nvl(pay_opm_shd.g_old_rec.pmeth_information1, hr_api.g_varchar2) <>

184: --
185: if ((p_rec.org_payment_method_id is not null) and (
186: nvl(pay_opm_shd.g_old_rec.pmeth_information_category, hr_api.g_varchar2) <>
187: nvl(p_rec.pmeth_information_category, hr_api.g_varchar2) or
188: nvl(pay_opm_shd.g_old_rec.pmeth_information1, hr_api.g_varchar2) <>
189: nvl(p_rec.pmeth_information1, hr_api.g_varchar2) or
190: nvl(pay_opm_shd.g_old_rec.pmeth_information2, hr_api.g_varchar2) <>
191: nvl(p_rec.pmeth_information2, hr_api.g_varchar2) or
192: nvl(pay_opm_shd.g_old_rec.pmeth_information3, hr_api.g_varchar2) <>

Line 189: nvl(p_rec.pmeth_information1, hr_api.g_varchar2) or

185: if ((p_rec.org_payment_method_id is not null) and (
186: nvl(pay_opm_shd.g_old_rec.pmeth_information_category, hr_api.g_varchar2) <>
187: nvl(p_rec.pmeth_information_category, hr_api.g_varchar2) or
188: nvl(pay_opm_shd.g_old_rec.pmeth_information1, hr_api.g_varchar2) <>
189: nvl(p_rec.pmeth_information1, hr_api.g_varchar2) or
190: nvl(pay_opm_shd.g_old_rec.pmeth_information2, hr_api.g_varchar2) <>
191: nvl(p_rec.pmeth_information2, hr_api.g_varchar2) or
192: nvl(pay_opm_shd.g_old_rec.pmeth_information3, hr_api.g_varchar2) <>
193: nvl(p_rec.pmeth_information3, hr_api.g_varchar2) or

Line 190: nvl(pay_opm_shd.g_old_rec.pmeth_information2, hr_api.g_varchar2) <>

186: nvl(pay_opm_shd.g_old_rec.pmeth_information_category, hr_api.g_varchar2) <>
187: nvl(p_rec.pmeth_information_category, hr_api.g_varchar2) or
188: nvl(pay_opm_shd.g_old_rec.pmeth_information1, hr_api.g_varchar2) <>
189: nvl(p_rec.pmeth_information1, hr_api.g_varchar2) or
190: nvl(pay_opm_shd.g_old_rec.pmeth_information2, hr_api.g_varchar2) <>
191: nvl(p_rec.pmeth_information2, hr_api.g_varchar2) or
192: nvl(pay_opm_shd.g_old_rec.pmeth_information3, hr_api.g_varchar2) <>
193: nvl(p_rec.pmeth_information3, hr_api.g_varchar2) or
194: nvl(pay_opm_shd.g_old_rec.pmeth_information4, hr_api.g_varchar2) <>

Line 191: nvl(p_rec.pmeth_information2, hr_api.g_varchar2) or

187: nvl(p_rec.pmeth_information_category, hr_api.g_varchar2) or
188: nvl(pay_opm_shd.g_old_rec.pmeth_information1, hr_api.g_varchar2) <>
189: nvl(p_rec.pmeth_information1, hr_api.g_varchar2) or
190: nvl(pay_opm_shd.g_old_rec.pmeth_information2, hr_api.g_varchar2) <>
191: nvl(p_rec.pmeth_information2, hr_api.g_varchar2) or
192: nvl(pay_opm_shd.g_old_rec.pmeth_information3, hr_api.g_varchar2) <>
193: nvl(p_rec.pmeth_information3, hr_api.g_varchar2) or
194: nvl(pay_opm_shd.g_old_rec.pmeth_information4, hr_api.g_varchar2) <>
195: nvl(p_rec.pmeth_information4, hr_api.g_varchar2) or

Line 192: nvl(pay_opm_shd.g_old_rec.pmeth_information3, hr_api.g_varchar2) <>

188: nvl(pay_opm_shd.g_old_rec.pmeth_information1, hr_api.g_varchar2) <>
189: nvl(p_rec.pmeth_information1, hr_api.g_varchar2) or
190: nvl(pay_opm_shd.g_old_rec.pmeth_information2, hr_api.g_varchar2) <>
191: nvl(p_rec.pmeth_information2, hr_api.g_varchar2) or
192: nvl(pay_opm_shd.g_old_rec.pmeth_information3, hr_api.g_varchar2) <>
193: nvl(p_rec.pmeth_information3, hr_api.g_varchar2) or
194: nvl(pay_opm_shd.g_old_rec.pmeth_information4, hr_api.g_varchar2) <>
195: nvl(p_rec.pmeth_information4, hr_api.g_varchar2) or
196: nvl(pay_opm_shd.g_old_rec.pmeth_information5, hr_api.g_varchar2) <>

Line 193: nvl(p_rec.pmeth_information3, hr_api.g_varchar2) or

189: nvl(p_rec.pmeth_information1, hr_api.g_varchar2) or
190: nvl(pay_opm_shd.g_old_rec.pmeth_information2, hr_api.g_varchar2) <>
191: nvl(p_rec.pmeth_information2, hr_api.g_varchar2) or
192: nvl(pay_opm_shd.g_old_rec.pmeth_information3, hr_api.g_varchar2) <>
193: nvl(p_rec.pmeth_information3, hr_api.g_varchar2) or
194: nvl(pay_opm_shd.g_old_rec.pmeth_information4, hr_api.g_varchar2) <>
195: nvl(p_rec.pmeth_information4, hr_api.g_varchar2) or
196: nvl(pay_opm_shd.g_old_rec.pmeth_information5, hr_api.g_varchar2) <>
197: nvl(p_rec.pmeth_information5, hr_api.g_varchar2) or

Line 194: nvl(pay_opm_shd.g_old_rec.pmeth_information4, hr_api.g_varchar2) <>

190: nvl(pay_opm_shd.g_old_rec.pmeth_information2, hr_api.g_varchar2) <>
191: nvl(p_rec.pmeth_information2, hr_api.g_varchar2) or
192: nvl(pay_opm_shd.g_old_rec.pmeth_information3, hr_api.g_varchar2) <>
193: nvl(p_rec.pmeth_information3, hr_api.g_varchar2) or
194: nvl(pay_opm_shd.g_old_rec.pmeth_information4, hr_api.g_varchar2) <>
195: nvl(p_rec.pmeth_information4, hr_api.g_varchar2) or
196: nvl(pay_opm_shd.g_old_rec.pmeth_information5, hr_api.g_varchar2) <>
197: nvl(p_rec.pmeth_information5, hr_api.g_varchar2) or
198: nvl(pay_opm_shd.g_old_rec.pmeth_information6, hr_api.g_varchar2) <>

Line 195: nvl(p_rec.pmeth_information4, hr_api.g_varchar2) or

191: nvl(p_rec.pmeth_information2, hr_api.g_varchar2) or
192: nvl(pay_opm_shd.g_old_rec.pmeth_information3, hr_api.g_varchar2) <>
193: nvl(p_rec.pmeth_information3, hr_api.g_varchar2) or
194: nvl(pay_opm_shd.g_old_rec.pmeth_information4, hr_api.g_varchar2) <>
195: nvl(p_rec.pmeth_information4, hr_api.g_varchar2) or
196: nvl(pay_opm_shd.g_old_rec.pmeth_information5, hr_api.g_varchar2) <>
197: nvl(p_rec.pmeth_information5, hr_api.g_varchar2) or
198: nvl(pay_opm_shd.g_old_rec.pmeth_information6, hr_api.g_varchar2) <>
199: nvl(p_rec.pmeth_information6, hr_api.g_varchar2) or

Line 196: nvl(pay_opm_shd.g_old_rec.pmeth_information5, hr_api.g_varchar2) <>

192: nvl(pay_opm_shd.g_old_rec.pmeth_information3, hr_api.g_varchar2) <>
193: nvl(p_rec.pmeth_information3, hr_api.g_varchar2) or
194: nvl(pay_opm_shd.g_old_rec.pmeth_information4, hr_api.g_varchar2) <>
195: nvl(p_rec.pmeth_information4, hr_api.g_varchar2) or
196: nvl(pay_opm_shd.g_old_rec.pmeth_information5, hr_api.g_varchar2) <>
197: nvl(p_rec.pmeth_information5, hr_api.g_varchar2) or
198: nvl(pay_opm_shd.g_old_rec.pmeth_information6, hr_api.g_varchar2) <>
199: nvl(p_rec.pmeth_information6, hr_api.g_varchar2) or
200: nvl(pay_opm_shd.g_old_rec.pmeth_information7, hr_api.g_varchar2) <>

Line 197: nvl(p_rec.pmeth_information5, hr_api.g_varchar2) or

193: nvl(p_rec.pmeth_information3, hr_api.g_varchar2) or
194: nvl(pay_opm_shd.g_old_rec.pmeth_information4, hr_api.g_varchar2) <>
195: nvl(p_rec.pmeth_information4, hr_api.g_varchar2) or
196: nvl(pay_opm_shd.g_old_rec.pmeth_information5, hr_api.g_varchar2) <>
197: nvl(p_rec.pmeth_information5, hr_api.g_varchar2) or
198: nvl(pay_opm_shd.g_old_rec.pmeth_information6, hr_api.g_varchar2) <>
199: nvl(p_rec.pmeth_information6, hr_api.g_varchar2) or
200: nvl(pay_opm_shd.g_old_rec.pmeth_information7, hr_api.g_varchar2) <>
201: nvl(p_rec.pmeth_information7, hr_api.g_varchar2) or

Line 198: nvl(pay_opm_shd.g_old_rec.pmeth_information6, hr_api.g_varchar2) <>

194: nvl(pay_opm_shd.g_old_rec.pmeth_information4, hr_api.g_varchar2) <>
195: nvl(p_rec.pmeth_information4, hr_api.g_varchar2) or
196: nvl(pay_opm_shd.g_old_rec.pmeth_information5, hr_api.g_varchar2) <>
197: nvl(p_rec.pmeth_information5, hr_api.g_varchar2) or
198: nvl(pay_opm_shd.g_old_rec.pmeth_information6, hr_api.g_varchar2) <>
199: nvl(p_rec.pmeth_information6, hr_api.g_varchar2) or
200: nvl(pay_opm_shd.g_old_rec.pmeth_information7, hr_api.g_varchar2) <>
201: nvl(p_rec.pmeth_information7, hr_api.g_varchar2) or
202: nvl(pay_opm_shd.g_old_rec.pmeth_information8, hr_api.g_varchar2) <>

Line 199: nvl(p_rec.pmeth_information6, hr_api.g_varchar2) or

195: nvl(p_rec.pmeth_information4, hr_api.g_varchar2) or
196: nvl(pay_opm_shd.g_old_rec.pmeth_information5, hr_api.g_varchar2) <>
197: nvl(p_rec.pmeth_information5, hr_api.g_varchar2) or
198: nvl(pay_opm_shd.g_old_rec.pmeth_information6, hr_api.g_varchar2) <>
199: nvl(p_rec.pmeth_information6, hr_api.g_varchar2) or
200: nvl(pay_opm_shd.g_old_rec.pmeth_information7, hr_api.g_varchar2) <>
201: nvl(p_rec.pmeth_information7, hr_api.g_varchar2) or
202: nvl(pay_opm_shd.g_old_rec.pmeth_information8, hr_api.g_varchar2) <>
203: nvl(p_rec.pmeth_information8, hr_api.g_varchar2) or

Line 200: nvl(pay_opm_shd.g_old_rec.pmeth_information7, hr_api.g_varchar2) <>

196: nvl(pay_opm_shd.g_old_rec.pmeth_information5, hr_api.g_varchar2) <>
197: nvl(p_rec.pmeth_information5, hr_api.g_varchar2) or
198: nvl(pay_opm_shd.g_old_rec.pmeth_information6, hr_api.g_varchar2) <>
199: nvl(p_rec.pmeth_information6, hr_api.g_varchar2) or
200: nvl(pay_opm_shd.g_old_rec.pmeth_information7, hr_api.g_varchar2) <>
201: nvl(p_rec.pmeth_information7, hr_api.g_varchar2) or
202: nvl(pay_opm_shd.g_old_rec.pmeth_information8, hr_api.g_varchar2) <>
203: nvl(p_rec.pmeth_information8, hr_api.g_varchar2) or
204: nvl(pay_opm_shd.g_old_rec.pmeth_information9, hr_api.g_varchar2) <>

Line 201: nvl(p_rec.pmeth_information7, hr_api.g_varchar2) or

197: nvl(p_rec.pmeth_information5, hr_api.g_varchar2) or
198: nvl(pay_opm_shd.g_old_rec.pmeth_information6, hr_api.g_varchar2) <>
199: nvl(p_rec.pmeth_information6, hr_api.g_varchar2) or
200: nvl(pay_opm_shd.g_old_rec.pmeth_information7, hr_api.g_varchar2) <>
201: nvl(p_rec.pmeth_information7, hr_api.g_varchar2) or
202: nvl(pay_opm_shd.g_old_rec.pmeth_information8, hr_api.g_varchar2) <>
203: nvl(p_rec.pmeth_information8, hr_api.g_varchar2) or
204: nvl(pay_opm_shd.g_old_rec.pmeth_information9, hr_api.g_varchar2) <>
205: nvl(p_rec.pmeth_information9, hr_api.g_varchar2) or

Line 202: nvl(pay_opm_shd.g_old_rec.pmeth_information8, hr_api.g_varchar2) <>

198: nvl(pay_opm_shd.g_old_rec.pmeth_information6, hr_api.g_varchar2) <>
199: nvl(p_rec.pmeth_information6, hr_api.g_varchar2) or
200: nvl(pay_opm_shd.g_old_rec.pmeth_information7, hr_api.g_varchar2) <>
201: nvl(p_rec.pmeth_information7, hr_api.g_varchar2) or
202: nvl(pay_opm_shd.g_old_rec.pmeth_information8, hr_api.g_varchar2) <>
203: nvl(p_rec.pmeth_information8, hr_api.g_varchar2) or
204: nvl(pay_opm_shd.g_old_rec.pmeth_information9, hr_api.g_varchar2) <>
205: nvl(p_rec.pmeth_information9, hr_api.g_varchar2) or
206: nvl(pay_opm_shd.g_old_rec.pmeth_information10, hr_api.g_varchar2) <>

Line 203: nvl(p_rec.pmeth_information8, hr_api.g_varchar2) or

199: nvl(p_rec.pmeth_information6, hr_api.g_varchar2) or
200: nvl(pay_opm_shd.g_old_rec.pmeth_information7, hr_api.g_varchar2) <>
201: nvl(p_rec.pmeth_information7, hr_api.g_varchar2) or
202: nvl(pay_opm_shd.g_old_rec.pmeth_information8, hr_api.g_varchar2) <>
203: nvl(p_rec.pmeth_information8, hr_api.g_varchar2) or
204: nvl(pay_opm_shd.g_old_rec.pmeth_information9, hr_api.g_varchar2) <>
205: nvl(p_rec.pmeth_information9, hr_api.g_varchar2) or
206: nvl(pay_opm_shd.g_old_rec.pmeth_information10, hr_api.g_varchar2) <>
207: nvl(p_rec.pmeth_information10, hr_api.g_varchar2) or

Line 204: nvl(pay_opm_shd.g_old_rec.pmeth_information9, hr_api.g_varchar2) <>

200: nvl(pay_opm_shd.g_old_rec.pmeth_information7, hr_api.g_varchar2) <>
201: nvl(p_rec.pmeth_information7, hr_api.g_varchar2) or
202: nvl(pay_opm_shd.g_old_rec.pmeth_information8, hr_api.g_varchar2) <>
203: nvl(p_rec.pmeth_information8, hr_api.g_varchar2) or
204: nvl(pay_opm_shd.g_old_rec.pmeth_information9, hr_api.g_varchar2) <>
205: nvl(p_rec.pmeth_information9, hr_api.g_varchar2) or
206: nvl(pay_opm_shd.g_old_rec.pmeth_information10, hr_api.g_varchar2) <>
207: nvl(p_rec.pmeth_information10, hr_api.g_varchar2) or
208: nvl(pay_opm_shd.g_old_rec.pmeth_information11, hr_api.g_varchar2) <>

Line 205: nvl(p_rec.pmeth_information9, hr_api.g_varchar2) or

201: nvl(p_rec.pmeth_information7, hr_api.g_varchar2) or
202: nvl(pay_opm_shd.g_old_rec.pmeth_information8, hr_api.g_varchar2) <>
203: nvl(p_rec.pmeth_information8, hr_api.g_varchar2) or
204: nvl(pay_opm_shd.g_old_rec.pmeth_information9, hr_api.g_varchar2) <>
205: nvl(p_rec.pmeth_information9, hr_api.g_varchar2) or
206: nvl(pay_opm_shd.g_old_rec.pmeth_information10, hr_api.g_varchar2) <>
207: nvl(p_rec.pmeth_information10, hr_api.g_varchar2) or
208: nvl(pay_opm_shd.g_old_rec.pmeth_information11, hr_api.g_varchar2) <>
209: nvl(p_rec.pmeth_information11, hr_api.g_varchar2) or

Line 206: nvl(pay_opm_shd.g_old_rec.pmeth_information10, hr_api.g_varchar2) <>

202: nvl(pay_opm_shd.g_old_rec.pmeth_information8, hr_api.g_varchar2) <>
203: nvl(p_rec.pmeth_information8, hr_api.g_varchar2) or
204: nvl(pay_opm_shd.g_old_rec.pmeth_information9, hr_api.g_varchar2) <>
205: nvl(p_rec.pmeth_information9, hr_api.g_varchar2) or
206: nvl(pay_opm_shd.g_old_rec.pmeth_information10, hr_api.g_varchar2) <>
207: nvl(p_rec.pmeth_information10, hr_api.g_varchar2) or
208: nvl(pay_opm_shd.g_old_rec.pmeth_information11, hr_api.g_varchar2) <>
209: nvl(p_rec.pmeth_information11, hr_api.g_varchar2) or
210: nvl(pay_opm_shd.g_old_rec.pmeth_information12, hr_api.g_varchar2) <>

Line 207: nvl(p_rec.pmeth_information10, hr_api.g_varchar2) or

203: nvl(p_rec.pmeth_information8, hr_api.g_varchar2) or
204: nvl(pay_opm_shd.g_old_rec.pmeth_information9, hr_api.g_varchar2) <>
205: nvl(p_rec.pmeth_information9, hr_api.g_varchar2) or
206: nvl(pay_opm_shd.g_old_rec.pmeth_information10, hr_api.g_varchar2) <>
207: nvl(p_rec.pmeth_information10, hr_api.g_varchar2) or
208: nvl(pay_opm_shd.g_old_rec.pmeth_information11, hr_api.g_varchar2) <>
209: nvl(p_rec.pmeth_information11, hr_api.g_varchar2) or
210: nvl(pay_opm_shd.g_old_rec.pmeth_information12, hr_api.g_varchar2) <>
211: nvl(p_rec.pmeth_information12, hr_api.g_varchar2) or

Line 208: nvl(pay_opm_shd.g_old_rec.pmeth_information11, hr_api.g_varchar2) <>

204: nvl(pay_opm_shd.g_old_rec.pmeth_information9, hr_api.g_varchar2) <>
205: nvl(p_rec.pmeth_information9, hr_api.g_varchar2) or
206: nvl(pay_opm_shd.g_old_rec.pmeth_information10, hr_api.g_varchar2) <>
207: nvl(p_rec.pmeth_information10, hr_api.g_varchar2) or
208: nvl(pay_opm_shd.g_old_rec.pmeth_information11, hr_api.g_varchar2) <>
209: nvl(p_rec.pmeth_information11, hr_api.g_varchar2) or
210: nvl(pay_opm_shd.g_old_rec.pmeth_information12, hr_api.g_varchar2) <>
211: nvl(p_rec.pmeth_information12, hr_api.g_varchar2) or
212: nvl(pay_opm_shd.g_old_rec.pmeth_information13, hr_api.g_varchar2) <>

Line 209: nvl(p_rec.pmeth_information11, hr_api.g_varchar2) or

205: nvl(p_rec.pmeth_information9, hr_api.g_varchar2) or
206: nvl(pay_opm_shd.g_old_rec.pmeth_information10, hr_api.g_varchar2) <>
207: nvl(p_rec.pmeth_information10, hr_api.g_varchar2) or
208: nvl(pay_opm_shd.g_old_rec.pmeth_information11, hr_api.g_varchar2) <>
209: nvl(p_rec.pmeth_information11, hr_api.g_varchar2) or
210: nvl(pay_opm_shd.g_old_rec.pmeth_information12, hr_api.g_varchar2) <>
211: nvl(p_rec.pmeth_information12, hr_api.g_varchar2) or
212: nvl(pay_opm_shd.g_old_rec.pmeth_information13, hr_api.g_varchar2) <>
213: nvl(p_rec.pmeth_information13, hr_api.g_varchar2) or

Line 210: nvl(pay_opm_shd.g_old_rec.pmeth_information12, hr_api.g_varchar2) <>

206: nvl(pay_opm_shd.g_old_rec.pmeth_information10, hr_api.g_varchar2) <>
207: nvl(p_rec.pmeth_information10, hr_api.g_varchar2) or
208: nvl(pay_opm_shd.g_old_rec.pmeth_information11, hr_api.g_varchar2) <>
209: nvl(p_rec.pmeth_information11, hr_api.g_varchar2) or
210: nvl(pay_opm_shd.g_old_rec.pmeth_information12, hr_api.g_varchar2) <>
211: nvl(p_rec.pmeth_information12, hr_api.g_varchar2) or
212: nvl(pay_opm_shd.g_old_rec.pmeth_information13, hr_api.g_varchar2) <>
213: nvl(p_rec.pmeth_information13, hr_api.g_varchar2) or
214: nvl(pay_opm_shd.g_old_rec.pmeth_information14, hr_api.g_varchar2) <>

Line 211: nvl(p_rec.pmeth_information12, hr_api.g_varchar2) or

207: nvl(p_rec.pmeth_information10, hr_api.g_varchar2) or
208: nvl(pay_opm_shd.g_old_rec.pmeth_information11, hr_api.g_varchar2) <>
209: nvl(p_rec.pmeth_information11, hr_api.g_varchar2) or
210: nvl(pay_opm_shd.g_old_rec.pmeth_information12, hr_api.g_varchar2) <>
211: nvl(p_rec.pmeth_information12, hr_api.g_varchar2) or
212: nvl(pay_opm_shd.g_old_rec.pmeth_information13, hr_api.g_varchar2) <>
213: nvl(p_rec.pmeth_information13, hr_api.g_varchar2) or
214: nvl(pay_opm_shd.g_old_rec.pmeth_information14, hr_api.g_varchar2) <>
215: nvl(p_rec.pmeth_information14, hr_api.g_varchar2) or

Line 212: nvl(pay_opm_shd.g_old_rec.pmeth_information13, hr_api.g_varchar2) <>

208: nvl(pay_opm_shd.g_old_rec.pmeth_information11, hr_api.g_varchar2) <>
209: nvl(p_rec.pmeth_information11, hr_api.g_varchar2) or
210: nvl(pay_opm_shd.g_old_rec.pmeth_information12, hr_api.g_varchar2) <>
211: nvl(p_rec.pmeth_information12, hr_api.g_varchar2) or
212: nvl(pay_opm_shd.g_old_rec.pmeth_information13, hr_api.g_varchar2) <>
213: nvl(p_rec.pmeth_information13, hr_api.g_varchar2) or
214: nvl(pay_opm_shd.g_old_rec.pmeth_information14, hr_api.g_varchar2) <>
215: nvl(p_rec.pmeth_information14, hr_api.g_varchar2) or
216: nvl(pay_opm_shd.g_old_rec.pmeth_information15, hr_api.g_varchar2) <>

Line 213: nvl(p_rec.pmeth_information13, hr_api.g_varchar2) or

209: nvl(p_rec.pmeth_information11, hr_api.g_varchar2) or
210: nvl(pay_opm_shd.g_old_rec.pmeth_information12, hr_api.g_varchar2) <>
211: nvl(p_rec.pmeth_information12, hr_api.g_varchar2) or
212: nvl(pay_opm_shd.g_old_rec.pmeth_information13, hr_api.g_varchar2) <>
213: nvl(p_rec.pmeth_information13, hr_api.g_varchar2) or
214: nvl(pay_opm_shd.g_old_rec.pmeth_information14, hr_api.g_varchar2) <>
215: nvl(p_rec.pmeth_information14, hr_api.g_varchar2) or
216: nvl(pay_opm_shd.g_old_rec.pmeth_information15, hr_api.g_varchar2) <>
217: nvl(p_rec.pmeth_information15, hr_api.g_varchar2) or

Line 214: nvl(pay_opm_shd.g_old_rec.pmeth_information14, hr_api.g_varchar2) <>

210: nvl(pay_opm_shd.g_old_rec.pmeth_information12, hr_api.g_varchar2) <>
211: nvl(p_rec.pmeth_information12, hr_api.g_varchar2) or
212: nvl(pay_opm_shd.g_old_rec.pmeth_information13, hr_api.g_varchar2) <>
213: nvl(p_rec.pmeth_information13, hr_api.g_varchar2) or
214: nvl(pay_opm_shd.g_old_rec.pmeth_information14, hr_api.g_varchar2) <>
215: nvl(p_rec.pmeth_information14, hr_api.g_varchar2) or
216: nvl(pay_opm_shd.g_old_rec.pmeth_information15, hr_api.g_varchar2) <>
217: nvl(p_rec.pmeth_information15, hr_api.g_varchar2) or
218: nvl(pay_opm_shd.g_old_rec.pmeth_information16, hr_api.g_varchar2) <>

Line 215: nvl(p_rec.pmeth_information14, hr_api.g_varchar2) or

211: nvl(p_rec.pmeth_information12, hr_api.g_varchar2) or
212: nvl(pay_opm_shd.g_old_rec.pmeth_information13, hr_api.g_varchar2) <>
213: nvl(p_rec.pmeth_information13, hr_api.g_varchar2) or
214: nvl(pay_opm_shd.g_old_rec.pmeth_information14, hr_api.g_varchar2) <>
215: nvl(p_rec.pmeth_information14, hr_api.g_varchar2) or
216: nvl(pay_opm_shd.g_old_rec.pmeth_information15, hr_api.g_varchar2) <>
217: nvl(p_rec.pmeth_information15, hr_api.g_varchar2) or
218: nvl(pay_opm_shd.g_old_rec.pmeth_information16, hr_api.g_varchar2) <>
219: nvl(p_rec.pmeth_information16, hr_api.g_varchar2) or

Line 216: nvl(pay_opm_shd.g_old_rec.pmeth_information15, hr_api.g_varchar2) <>

212: nvl(pay_opm_shd.g_old_rec.pmeth_information13, hr_api.g_varchar2) <>
213: nvl(p_rec.pmeth_information13, hr_api.g_varchar2) or
214: nvl(pay_opm_shd.g_old_rec.pmeth_information14, hr_api.g_varchar2) <>
215: nvl(p_rec.pmeth_information14, hr_api.g_varchar2) or
216: nvl(pay_opm_shd.g_old_rec.pmeth_information15, hr_api.g_varchar2) <>
217: nvl(p_rec.pmeth_information15, hr_api.g_varchar2) or
218: nvl(pay_opm_shd.g_old_rec.pmeth_information16, hr_api.g_varchar2) <>
219: nvl(p_rec.pmeth_information16, hr_api.g_varchar2) or
220: nvl(pay_opm_shd.g_old_rec.pmeth_information17, hr_api.g_varchar2) <>

Line 217: nvl(p_rec.pmeth_information15, hr_api.g_varchar2) or

213: nvl(p_rec.pmeth_information13, hr_api.g_varchar2) or
214: nvl(pay_opm_shd.g_old_rec.pmeth_information14, hr_api.g_varchar2) <>
215: nvl(p_rec.pmeth_information14, hr_api.g_varchar2) or
216: nvl(pay_opm_shd.g_old_rec.pmeth_information15, hr_api.g_varchar2) <>
217: nvl(p_rec.pmeth_information15, hr_api.g_varchar2) or
218: nvl(pay_opm_shd.g_old_rec.pmeth_information16, hr_api.g_varchar2) <>
219: nvl(p_rec.pmeth_information16, hr_api.g_varchar2) or
220: nvl(pay_opm_shd.g_old_rec.pmeth_information17, hr_api.g_varchar2) <>
221: nvl(p_rec.pmeth_information17, hr_api.g_varchar2) or

Line 218: nvl(pay_opm_shd.g_old_rec.pmeth_information16, hr_api.g_varchar2) <>

214: nvl(pay_opm_shd.g_old_rec.pmeth_information14, hr_api.g_varchar2) <>
215: nvl(p_rec.pmeth_information14, hr_api.g_varchar2) or
216: nvl(pay_opm_shd.g_old_rec.pmeth_information15, hr_api.g_varchar2) <>
217: nvl(p_rec.pmeth_information15, hr_api.g_varchar2) or
218: nvl(pay_opm_shd.g_old_rec.pmeth_information16, hr_api.g_varchar2) <>
219: nvl(p_rec.pmeth_information16, hr_api.g_varchar2) or
220: nvl(pay_opm_shd.g_old_rec.pmeth_information17, hr_api.g_varchar2) <>
221: nvl(p_rec.pmeth_information17, hr_api.g_varchar2) or
222: nvl(pay_opm_shd.g_old_rec.pmeth_information18, hr_api.g_varchar2) <>

Line 219: nvl(p_rec.pmeth_information16, hr_api.g_varchar2) or

215: nvl(p_rec.pmeth_information14, hr_api.g_varchar2) or
216: nvl(pay_opm_shd.g_old_rec.pmeth_information15, hr_api.g_varchar2) <>
217: nvl(p_rec.pmeth_information15, hr_api.g_varchar2) or
218: nvl(pay_opm_shd.g_old_rec.pmeth_information16, hr_api.g_varchar2) <>
219: nvl(p_rec.pmeth_information16, hr_api.g_varchar2) or
220: nvl(pay_opm_shd.g_old_rec.pmeth_information17, hr_api.g_varchar2) <>
221: nvl(p_rec.pmeth_information17, hr_api.g_varchar2) or
222: nvl(pay_opm_shd.g_old_rec.pmeth_information18, hr_api.g_varchar2) <>
223: nvl(p_rec.pmeth_information18, hr_api.g_varchar2) or

Line 220: nvl(pay_opm_shd.g_old_rec.pmeth_information17, hr_api.g_varchar2) <>

216: nvl(pay_opm_shd.g_old_rec.pmeth_information15, hr_api.g_varchar2) <>
217: nvl(p_rec.pmeth_information15, hr_api.g_varchar2) or
218: nvl(pay_opm_shd.g_old_rec.pmeth_information16, hr_api.g_varchar2) <>
219: nvl(p_rec.pmeth_information16, hr_api.g_varchar2) or
220: nvl(pay_opm_shd.g_old_rec.pmeth_information17, hr_api.g_varchar2) <>
221: nvl(p_rec.pmeth_information17, hr_api.g_varchar2) or
222: nvl(pay_opm_shd.g_old_rec.pmeth_information18, hr_api.g_varchar2) <>
223: nvl(p_rec.pmeth_information18, hr_api.g_varchar2) or
224: nvl(pay_opm_shd.g_old_rec.pmeth_information19, hr_api.g_varchar2) <>

Line 221: nvl(p_rec.pmeth_information17, hr_api.g_varchar2) or

217: nvl(p_rec.pmeth_information15, hr_api.g_varchar2) or
218: nvl(pay_opm_shd.g_old_rec.pmeth_information16, hr_api.g_varchar2) <>
219: nvl(p_rec.pmeth_information16, hr_api.g_varchar2) or
220: nvl(pay_opm_shd.g_old_rec.pmeth_information17, hr_api.g_varchar2) <>
221: nvl(p_rec.pmeth_information17, hr_api.g_varchar2) or
222: nvl(pay_opm_shd.g_old_rec.pmeth_information18, hr_api.g_varchar2) <>
223: nvl(p_rec.pmeth_information18, hr_api.g_varchar2) or
224: nvl(pay_opm_shd.g_old_rec.pmeth_information19, hr_api.g_varchar2) <>
225: nvl(p_rec.pmeth_information19, hr_api.g_varchar2) or

Line 222: nvl(pay_opm_shd.g_old_rec.pmeth_information18, hr_api.g_varchar2) <>

218: nvl(pay_opm_shd.g_old_rec.pmeth_information16, hr_api.g_varchar2) <>
219: nvl(p_rec.pmeth_information16, hr_api.g_varchar2) or
220: nvl(pay_opm_shd.g_old_rec.pmeth_information17, hr_api.g_varchar2) <>
221: nvl(p_rec.pmeth_information17, hr_api.g_varchar2) or
222: nvl(pay_opm_shd.g_old_rec.pmeth_information18, hr_api.g_varchar2) <>
223: nvl(p_rec.pmeth_information18, hr_api.g_varchar2) or
224: nvl(pay_opm_shd.g_old_rec.pmeth_information19, hr_api.g_varchar2) <>
225: nvl(p_rec.pmeth_information19, hr_api.g_varchar2) or
226: nvl(pay_opm_shd.g_old_rec.pmeth_information20, hr_api.g_varchar2) <>

Line 223: nvl(p_rec.pmeth_information18, hr_api.g_varchar2) or

219: nvl(p_rec.pmeth_information16, hr_api.g_varchar2) or
220: nvl(pay_opm_shd.g_old_rec.pmeth_information17, hr_api.g_varchar2) <>
221: nvl(p_rec.pmeth_information17, hr_api.g_varchar2) or
222: nvl(pay_opm_shd.g_old_rec.pmeth_information18, hr_api.g_varchar2) <>
223: nvl(p_rec.pmeth_information18, hr_api.g_varchar2) or
224: nvl(pay_opm_shd.g_old_rec.pmeth_information19, hr_api.g_varchar2) <>
225: nvl(p_rec.pmeth_information19, hr_api.g_varchar2) or
226: nvl(pay_opm_shd.g_old_rec.pmeth_information20, hr_api.g_varchar2) <>
227: nvl(p_rec.pmeth_information20, hr_api.g_varchar2) ))

Line 224: nvl(pay_opm_shd.g_old_rec.pmeth_information19, hr_api.g_varchar2) <>

220: nvl(pay_opm_shd.g_old_rec.pmeth_information17, hr_api.g_varchar2) <>
221: nvl(p_rec.pmeth_information17, hr_api.g_varchar2) or
222: nvl(pay_opm_shd.g_old_rec.pmeth_information18, hr_api.g_varchar2) <>
223: nvl(p_rec.pmeth_information18, hr_api.g_varchar2) or
224: nvl(pay_opm_shd.g_old_rec.pmeth_information19, hr_api.g_varchar2) <>
225: nvl(p_rec.pmeth_information19, hr_api.g_varchar2) or
226: nvl(pay_opm_shd.g_old_rec.pmeth_information20, hr_api.g_varchar2) <>
227: nvl(p_rec.pmeth_information20, hr_api.g_varchar2) ))
228: or (p_rec.org_payment_method_id is null) then

Line 225: nvl(p_rec.pmeth_information19, hr_api.g_varchar2) or

221: nvl(p_rec.pmeth_information17, hr_api.g_varchar2) or
222: nvl(pay_opm_shd.g_old_rec.pmeth_information18, hr_api.g_varchar2) <>
223: nvl(p_rec.pmeth_information18, hr_api.g_varchar2) or
224: nvl(pay_opm_shd.g_old_rec.pmeth_information19, hr_api.g_varchar2) <>
225: nvl(p_rec.pmeth_information19, hr_api.g_varchar2) or
226: nvl(pay_opm_shd.g_old_rec.pmeth_information20, hr_api.g_varchar2) <>
227: nvl(p_rec.pmeth_information20, hr_api.g_varchar2) ))
228: or (p_rec.org_payment_method_id is null) then
229: --

Line 226: nvl(pay_opm_shd.g_old_rec.pmeth_information20, hr_api.g_varchar2) <>

222: nvl(pay_opm_shd.g_old_rec.pmeth_information18, hr_api.g_varchar2) <>
223: nvl(p_rec.pmeth_information18, hr_api.g_varchar2) or
224: nvl(pay_opm_shd.g_old_rec.pmeth_information19, hr_api.g_varchar2) <>
225: nvl(p_rec.pmeth_information19, hr_api.g_varchar2) or
226: nvl(pay_opm_shd.g_old_rec.pmeth_information20, hr_api.g_varchar2) <>
227: nvl(p_rec.pmeth_information20, hr_api.g_varchar2) ))
228: or (p_rec.org_payment_method_id is null) then
229: --
230: -- Only execute the validation if absolutely necessary:

Line 227: nvl(p_rec.pmeth_information20, hr_api.g_varchar2) ))

223: nvl(p_rec.pmeth_information18, hr_api.g_varchar2) or
224: nvl(pay_opm_shd.g_old_rec.pmeth_information19, hr_api.g_varchar2) <>
225: nvl(p_rec.pmeth_information19, hr_api.g_varchar2) or
226: nvl(pay_opm_shd.g_old_rec.pmeth_information20, hr_api.g_varchar2) <>
227: nvl(p_rec.pmeth_information20, hr_api.g_varchar2) ))
228: or (p_rec.org_payment_method_id is null) then
229: --
230: -- Only execute the validation if absolutely necessary:
231: -- a) During update, the structure column value or any

Line 323: nvl(pay_opm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

319: begin
320: hr_utility.set_location('Entering:'||l_proc,10);
321: --
322: if ((p_rec.org_payment_method_id is not null) and (
323: nvl(pay_opm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
324: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
325: nvl(pay_opm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
326: nvl(p_rec.attribute1, hr_api.g_varchar2) or
327: nvl(pay_opm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 324: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

320: hr_utility.set_location('Entering:'||l_proc,10);
321: --
322: if ((p_rec.org_payment_method_id is not null) and (
323: nvl(pay_opm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
324: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
325: nvl(pay_opm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
326: nvl(p_rec.attribute1, hr_api.g_varchar2) or
327: nvl(pay_opm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
328: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 325: nvl(pay_opm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

321: --
322: if ((p_rec.org_payment_method_id is not null) and (
323: nvl(pay_opm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
324: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
325: nvl(pay_opm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
326: nvl(p_rec.attribute1, hr_api.g_varchar2) or
327: nvl(pay_opm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
328: nvl(p_rec.attribute2, hr_api.g_varchar2) or
329: nvl(pay_opm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 326: nvl(p_rec.attribute1, hr_api.g_varchar2) or

322: if ((p_rec.org_payment_method_id is not null) and (
323: nvl(pay_opm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
324: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
325: nvl(pay_opm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
326: nvl(p_rec.attribute1, hr_api.g_varchar2) or
327: nvl(pay_opm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
328: nvl(p_rec.attribute2, hr_api.g_varchar2) or
329: nvl(pay_opm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
330: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 327: nvl(pay_opm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

323: nvl(pay_opm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
324: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
325: nvl(pay_opm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
326: nvl(p_rec.attribute1, hr_api.g_varchar2) or
327: nvl(pay_opm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
328: nvl(p_rec.attribute2, hr_api.g_varchar2) or
329: nvl(pay_opm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
330: nvl(p_rec.attribute3, hr_api.g_varchar2) or
331: nvl(pay_opm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 328: nvl(p_rec.attribute2, hr_api.g_varchar2) or

324: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
325: nvl(pay_opm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
326: nvl(p_rec.attribute1, hr_api.g_varchar2) or
327: nvl(pay_opm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
328: nvl(p_rec.attribute2, hr_api.g_varchar2) or
329: nvl(pay_opm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
330: nvl(p_rec.attribute3, hr_api.g_varchar2) or
331: nvl(pay_opm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
332: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 329: nvl(pay_opm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

325: nvl(pay_opm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
326: nvl(p_rec.attribute1, hr_api.g_varchar2) or
327: nvl(pay_opm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
328: nvl(p_rec.attribute2, hr_api.g_varchar2) or
329: nvl(pay_opm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
330: nvl(p_rec.attribute3, hr_api.g_varchar2) or
331: nvl(pay_opm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
332: nvl(p_rec.attribute4, hr_api.g_varchar2) or
333: nvl(pay_opm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 330: nvl(p_rec.attribute3, hr_api.g_varchar2) or

326: nvl(p_rec.attribute1, hr_api.g_varchar2) or
327: nvl(pay_opm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
328: nvl(p_rec.attribute2, hr_api.g_varchar2) or
329: nvl(pay_opm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
330: nvl(p_rec.attribute3, hr_api.g_varchar2) or
331: nvl(pay_opm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
332: nvl(p_rec.attribute4, hr_api.g_varchar2) or
333: nvl(pay_opm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
334: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 331: nvl(pay_opm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

327: nvl(pay_opm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
328: nvl(p_rec.attribute2, hr_api.g_varchar2) or
329: nvl(pay_opm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
330: nvl(p_rec.attribute3, hr_api.g_varchar2) or
331: nvl(pay_opm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
332: nvl(p_rec.attribute4, hr_api.g_varchar2) or
333: nvl(pay_opm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
334: nvl(p_rec.attribute5, hr_api.g_varchar2) or
335: nvl(pay_opm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 332: nvl(p_rec.attribute4, hr_api.g_varchar2) or

328: nvl(p_rec.attribute2, hr_api.g_varchar2) or
329: nvl(pay_opm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
330: nvl(p_rec.attribute3, hr_api.g_varchar2) or
331: nvl(pay_opm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
332: nvl(p_rec.attribute4, hr_api.g_varchar2) or
333: nvl(pay_opm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
334: nvl(p_rec.attribute5, hr_api.g_varchar2) or
335: nvl(pay_opm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
336: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 333: nvl(pay_opm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

329: nvl(pay_opm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
330: nvl(p_rec.attribute3, hr_api.g_varchar2) or
331: nvl(pay_opm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
332: nvl(p_rec.attribute4, hr_api.g_varchar2) or
333: nvl(pay_opm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
334: nvl(p_rec.attribute5, hr_api.g_varchar2) or
335: nvl(pay_opm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
336: nvl(p_rec.attribute6, hr_api.g_varchar2) or
337: nvl(pay_opm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 334: nvl(p_rec.attribute5, hr_api.g_varchar2) or

330: nvl(p_rec.attribute3, hr_api.g_varchar2) or
331: nvl(pay_opm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
332: nvl(p_rec.attribute4, hr_api.g_varchar2) or
333: nvl(pay_opm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
334: nvl(p_rec.attribute5, hr_api.g_varchar2) or
335: nvl(pay_opm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
336: nvl(p_rec.attribute6, hr_api.g_varchar2) or
337: nvl(pay_opm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
338: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 335: nvl(pay_opm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

331: nvl(pay_opm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
332: nvl(p_rec.attribute4, hr_api.g_varchar2) or
333: nvl(pay_opm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
334: nvl(p_rec.attribute5, hr_api.g_varchar2) or
335: nvl(pay_opm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
336: nvl(p_rec.attribute6, hr_api.g_varchar2) or
337: nvl(pay_opm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
338: nvl(p_rec.attribute7, hr_api.g_varchar2) or
339: nvl(pay_opm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 336: nvl(p_rec.attribute6, hr_api.g_varchar2) or

332: nvl(p_rec.attribute4, hr_api.g_varchar2) or
333: nvl(pay_opm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
334: nvl(p_rec.attribute5, hr_api.g_varchar2) or
335: nvl(pay_opm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
336: nvl(p_rec.attribute6, hr_api.g_varchar2) or
337: nvl(pay_opm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
338: nvl(p_rec.attribute7, hr_api.g_varchar2) or
339: nvl(pay_opm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
340: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 337: nvl(pay_opm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

333: nvl(pay_opm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
334: nvl(p_rec.attribute5, hr_api.g_varchar2) or
335: nvl(pay_opm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
336: nvl(p_rec.attribute6, hr_api.g_varchar2) or
337: nvl(pay_opm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
338: nvl(p_rec.attribute7, hr_api.g_varchar2) or
339: nvl(pay_opm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
340: nvl(p_rec.attribute8, hr_api.g_varchar2) or
341: nvl(pay_opm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 338: nvl(p_rec.attribute7, hr_api.g_varchar2) or

334: nvl(p_rec.attribute5, hr_api.g_varchar2) or
335: nvl(pay_opm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
336: nvl(p_rec.attribute6, hr_api.g_varchar2) or
337: nvl(pay_opm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
338: nvl(p_rec.attribute7, hr_api.g_varchar2) or
339: nvl(pay_opm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
340: nvl(p_rec.attribute8, hr_api.g_varchar2) or
341: nvl(pay_opm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
342: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 339: nvl(pay_opm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

335: nvl(pay_opm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
336: nvl(p_rec.attribute6, hr_api.g_varchar2) or
337: nvl(pay_opm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
338: nvl(p_rec.attribute7, hr_api.g_varchar2) or
339: nvl(pay_opm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
340: nvl(p_rec.attribute8, hr_api.g_varchar2) or
341: nvl(pay_opm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
342: nvl(p_rec.attribute9, hr_api.g_varchar2) or
343: nvl(pay_opm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 340: nvl(p_rec.attribute8, hr_api.g_varchar2) or

336: nvl(p_rec.attribute6, hr_api.g_varchar2) or
337: nvl(pay_opm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
338: nvl(p_rec.attribute7, hr_api.g_varchar2) or
339: nvl(pay_opm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
340: nvl(p_rec.attribute8, hr_api.g_varchar2) or
341: nvl(pay_opm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
342: nvl(p_rec.attribute9, hr_api.g_varchar2) or
343: nvl(pay_opm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
344: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 341: nvl(pay_opm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

337: nvl(pay_opm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
338: nvl(p_rec.attribute7, hr_api.g_varchar2) or
339: nvl(pay_opm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
340: nvl(p_rec.attribute8, hr_api.g_varchar2) or
341: nvl(pay_opm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
342: nvl(p_rec.attribute9, hr_api.g_varchar2) or
343: nvl(pay_opm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
344: nvl(p_rec.attribute10, hr_api.g_varchar2) or
345: nvl(pay_opm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 342: nvl(p_rec.attribute9, hr_api.g_varchar2) or

338: nvl(p_rec.attribute7, hr_api.g_varchar2) or
339: nvl(pay_opm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
340: nvl(p_rec.attribute8, hr_api.g_varchar2) or
341: nvl(pay_opm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
342: nvl(p_rec.attribute9, hr_api.g_varchar2) or
343: nvl(pay_opm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
344: nvl(p_rec.attribute10, hr_api.g_varchar2) or
345: nvl(pay_opm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
346: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 343: nvl(pay_opm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

339: nvl(pay_opm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
340: nvl(p_rec.attribute8, hr_api.g_varchar2) or
341: nvl(pay_opm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
342: nvl(p_rec.attribute9, hr_api.g_varchar2) or
343: nvl(pay_opm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
344: nvl(p_rec.attribute10, hr_api.g_varchar2) or
345: nvl(pay_opm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
346: nvl(p_rec.attribute11, hr_api.g_varchar2) or
347: nvl(pay_opm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 344: nvl(p_rec.attribute10, hr_api.g_varchar2) or

340: nvl(p_rec.attribute8, hr_api.g_varchar2) or
341: nvl(pay_opm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
342: nvl(p_rec.attribute9, hr_api.g_varchar2) or
343: nvl(pay_opm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
344: nvl(p_rec.attribute10, hr_api.g_varchar2) or
345: nvl(pay_opm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
346: nvl(p_rec.attribute11, hr_api.g_varchar2) or
347: nvl(pay_opm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
348: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 345: nvl(pay_opm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

341: nvl(pay_opm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
342: nvl(p_rec.attribute9, hr_api.g_varchar2) or
343: nvl(pay_opm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
344: nvl(p_rec.attribute10, hr_api.g_varchar2) or
345: nvl(pay_opm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
346: nvl(p_rec.attribute11, hr_api.g_varchar2) or
347: nvl(pay_opm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
348: nvl(p_rec.attribute12, hr_api.g_varchar2) or
349: nvl(pay_opm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 346: nvl(p_rec.attribute11, hr_api.g_varchar2) or

342: nvl(p_rec.attribute9, hr_api.g_varchar2) or
343: nvl(pay_opm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
344: nvl(p_rec.attribute10, hr_api.g_varchar2) or
345: nvl(pay_opm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
346: nvl(p_rec.attribute11, hr_api.g_varchar2) or
347: nvl(pay_opm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
348: nvl(p_rec.attribute12, hr_api.g_varchar2) or
349: nvl(pay_opm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
350: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 347: nvl(pay_opm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

343: nvl(pay_opm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
344: nvl(p_rec.attribute10, hr_api.g_varchar2) or
345: nvl(pay_opm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
346: nvl(p_rec.attribute11, hr_api.g_varchar2) or
347: nvl(pay_opm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
348: nvl(p_rec.attribute12, hr_api.g_varchar2) or
349: nvl(pay_opm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
350: nvl(p_rec.attribute13, hr_api.g_varchar2) or
351: nvl(pay_opm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 348: nvl(p_rec.attribute12, hr_api.g_varchar2) or

344: nvl(p_rec.attribute10, hr_api.g_varchar2) or
345: nvl(pay_opm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
346: nvl(p_rec.attribute11, hr_api.g_varchar2) or
347: nvl(pay_opm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
348: nvl(p_rec.attribute12, hr_api.g_varchar2) or
349: nvl(pay_opm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
350: nvl(p_rec.attribute13, hr_api.g_varchar2) or
351: nvl(pay_opm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
352: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 349: nvl(pay_opm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

345: nvl(pay_opm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
346: nvl(p_rec.attribute11, hr_api.g_varchar2) or
347: nvl(pay_opm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
348: nvl(p_rec.attribute12, hr_api.g_varchar2) or
349: nvl(pay_opm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
350: nvl(p_rec.attribute13, hr_api.g_varchar2) or
351: nvl(pay_opm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
352: nvl(p_rec.attribute14, hr_api.g_varchar2) or
353: nvl(pay_opm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 350: nvl(p_rec.attribute13, hr_api.g_varchar2) or

346: nvl(p_rec.attribute11, hr_api.g_varchar2) or
347: nvl(pay_opm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
348: nvl(p_rec.attribute12, hr_api.g_varchar2) or
349: nvl(pay_opm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
350: nvl(p_rec.attribute13, hr_api.g_varchar2) or
351: nvl(pay_opm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
352: nvl(p_rec.attribute14, hr_api.g_varchar2) or
353: nvl(pay_opm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
354: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 351: nvl(pay_opm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

347: nvl(pay_opm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
348: nvl(p_rec.attribute12, hr_api.g_varchar2) or
349: nvl(pay_opm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
350: nvl(p_rec.attribute13, hr_api.g_varchar2) or
351: nvl(pay_opm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
352: nvl(p_rec.attribute14, hr_api.g_varchar2) or
353: nvl(pay_opm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
354: nvl(p_rec.attribute15, hr_api.g_varchar2) or
355: nvl(pay_opm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 352: nvl(p_rec.attribute14, hr_api.g_varchar2) or

348: nvl(p_rec.attribute12, hr_api.g_varchar2) or
349: nvl(pay_opm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
350: nvl(p_rec.attribute13, hr_api.g_varchar2) or
351: nvl(pay_opm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
352: nvl(p_rec.attribute14, hr_api.g_varchar2) or
353: nvl(pay_opm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
354: nvl(p_rec.attribute15, hr_api.g_varchar2) or
355: nvl(pay_opm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
356: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 353: nvl(pay_opm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

349: nvl(pay_opm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
350: nvl(p_rec.attribute13, hr_api.g_varchar2) or
351: nvl(pay_opm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
352: nvl(p_rec.attribute14, hr_api.g_varchar2) or
353: nvl(pay_opm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
354: nvl(p_rec.attribute15, hr_api.g_varchar2) or
355: nvl(pay_opm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
356: nvl(p_rec.attribute16, hr_api.g_varchar2) or
357: nvl(pay_opm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 354: nvl(p_rec.attribute15, hr_api.g_varchar2) or

350: nvl(p_rec.attribute13, hr_api.g_varchar2) or
351: nvl(pay_opm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
352: nvl(p_rec.attribute14, hr_api.g_varchar2) or
353: nvl(pay_opm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
354: nvl(p_rec.attribute15, hr_api.g_varchar2) or
355: nvl(pay_opm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
356: nvl(p_rec.attribute16, hr_api.g_varchar2) or
357: nvl(pay_opm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
358: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 355: nvl(pay_opm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

351: nvl(pay_opm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
352: nvl(p_rec.attribute14, hr_api.g_varchar2) or
353: nvl(pay_opm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
354: nvl(p_rec.attribute15, hr_api.g_varchar2) or
355: nvl(pay_opm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
356: nvl(p_rec.attribute16, hr_api.g_varchar2) or
357: nvl(pay_opm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
358: nvl(p_rec.attribute17, hr_api.g_varchar2) or
359: nvl(pay_opm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 356: nvl(p_rec.attribute16, hr_api.g_varchar2) or

352: nvl(p_rec.attribute14, hr_api.g_varchar2) or
353: nvl(pay_opm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
354: nvl(p_rec.attribute15, hr_api.g_varchar2) or
355: nvl(pay_opm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
356: nvl(p_rec.attribute16, hr_api.g_varchar2) or
357: nvl(pay_opm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
358: nvl(p_rec.attribute17, hr_api.g_varchar2) or
359: nvl(pay_opm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
360: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 357: nvl(pay_opm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

353: nvl(pay_opm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
354: nvl(p_rec.attribute15, hr_api.g_varchar2) or
355: nvl(pay_opm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
356: nvl(p_rec.attribute16, hr_api.g_varchar2) or
357: nvl(pay_opm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
358: nvl(p_rec.attribute17, hr_api.g_varchar2) or
359: nvl(pay_opm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
360: nvl(p_rec.attribute18, hr_api.g_varchar2) or
361: nvl(pay_opm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 358: nvl(p_rec.attribute17, hr_api.g_varchar2) or

354: nvl(p_rec.attribute15, hr_api.g_varchar2) or
355: nvl(pay_opm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
356: nvl(p_rec.attribute16, hr_api.g_varchar2) or
357: nvl(pay_opm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
358: nvl(p_rec.attribute17, hr_api.g_varchar2) or
359: nvl(pay_opm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
360: nvl(p_rec.attribute18, hr_api.g_varchar2) or
361: nvl(pay_opm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
362: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 359: nvl(pay_opm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

355: nvl(pay_opm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
356: nvl(p_rec.attribute16, hr_api.g_varchar2) or
357: nvl(pay_opm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
358: nvl(p_rec.attribute17, hr_api.g_varchar2) or
359: nvl(pay_opm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
360: nvl(p_rec.attribute18, hr_api.g_varchar2) or
361: nvl(pay_opm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
362: nvl(p_rec.attribute19, hr_api.g_varchar2) or
363: nvl(pay_opm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 360: nvl(p_rec.attribute18, hr_api.g_varchar2) or

356: nvl(p_rec.attribute16, hr_api.g_varchar2) or
357: nvl(pay_opm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
358: nvl(p_rec.attribute17, hr_api.g_varchar2) or
359: nvl(pay_opm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
360: nvl(p_rec.attribute18, hr_api.g_varchar2) or
361: nvl(pay_opm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
362: nvl(p_rec.attribute19, hr_api.g_varchar2) or
363: nvl(pay_opm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
364: nvl(p_rec.attribute20, hr_api.g_varchar2) ))

Line 361: nvl(pay_opm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

357: nvl(pay_opm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
358: nvl(p_rec.attribute17, hr_api.g_varchar2) or
359: nvl(pay_opm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
360: nvl(p_rec.attribute18, hr_api.g_varchar2) or
361: nvl(pay_opm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
362: nvl(p_rec.attribute19, hr_api.g_varchar2) or
363: nvl(pay_opm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
364: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
365: or (p_rec.org_payment_method_id is null) then

Line 362: nvl(p_rec.attribute19, hr_api.g_varchar2) or

358: nvl(p_rec.attribute17, hr_api.g_varchar2) or
359: nvl(pay_opm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
360: nvl(p_rec.attribute18, hr_api.g_varchar2) or
361: nvl(pay_opm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
362: nvl(p_rec.attribute19, hr_api.g_varchar2) or
363: nvl(pay_opm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
364: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
365: or (p_rec.org_payment_method_id is null) then
366: --

Line 363: nvl(pay_opm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

359: nvl(pay_opm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
360: nvl(p_rec.attribute18, hr_api.g_varchar2) or
361: nvl(pay_opm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
362: nvl(p_rec.attribute19, hr_api.g_varchar2) or
363: nvl(pay_opm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
364: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
365: or (p_rec.org_payment_method_id is null) then
366: --
367: -- Only execute the validation if absolutely necessary:

Line 364: nvl(p_rec.attribute20, hr_api.g_varchar2) ))

360: nvl(p_rec.attribute18, hr_api.g_varchar2) or
361: nvl(pay_opm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
362: nvl(p_rec.attribute19, hr_api.g_varchar2) or
363: nvl(pay_opm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
364: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
365: or (p_rec.org_payment_method_id is null) then
366: --
367: -- Only execute the validation if absolutely necessary:
368: -- a) During update, the structure column value or any

Line 478: if nvl(p_rec.business_group_id, hr_api.g_number) <>

474: END IF;
475: --
476: hr_utility.set_location(l_proc, 10);
477: --
478: if nvl(p_rec.business_group_id, hr_api.g_number) <>
479: pay_opm_shd.g_old_rec.business_group_id then
480: l_argument := 'business_group_id';
481: raise l_error;
482: end if;

Line 486: if nvl(p_rec.payment_type_id, hr_api.g_number) <>

482: end if;
483: --
484: hr_utility.set_location(l_proc, 20);
485: --
486: if nvl(p_rec.payment_type_id, hr_api.g_number) <>
487: pay_opm_shd.g_old_rec.payment_type_id then
488: l_argument := 'payment_type_id';
489: raise l_error;
490: end if;

Line 494: if nvl(p_rec.defined_balance_id, hr_api.g_number) <>

490: end if;
491: --
492: hr_utility.set_location(l_proc, 30);
493: --
494: if nvl(p_rec.defined_balance_id, hr_api.g_number) <>
495: nvl(pay_opm_shd.g_old_rec.defined_balance_id, hr_api.g_number) then
496: l_argument := 'defined_balance_id';
497: raise l_error;
498: end if;

Line 495: nvl(pay_opm_shd.g_old_rec.defined_balance_id, hr_api.g_number) then

491: --
492: hr_utility.set_location(l_proc, 30);
493: --
494: if nvl(p_rec.defined_balance_id, hr_api.g_number) <>
495: nvl(pay_opm_shd.g_old_rec.defined_balance_id, hr_api.g_number) then
496: l_argument := 'defined_balance_id';
497: raise l_error;
498: end if;
499: --

Line 502: if nvl(p_rec.org_payment_method_name, hr_api.g_varchar2) <>

498: end if;
499: --
500: hr_utility.set_location(l_proc, 35);
501: --
502: if nvl(p_rec.org_payment_method_name, hr_api.g_varchar2) <>
503: nvl(pay_opm_shd.g_old_rec.org_payment_method_name, hr_api.g_varchar2) then
504: l_argument := 'org_payment_method_name';
505: raise l_error;
506: end if;

Line 503: nvl(pay_opm_shd.g_old_rec.org_payment_method_name, hr_api.g_varchar2) then

499: --
500: hr_utility.set_location(l_proc, 35);
501: --
502: if nvl(p_rec.org_payment_method_name, hr_api.g_varchar2) <>
503: nvl(pay_opm_shd.g_old_rec.org_payment_method_name, hr_api.g_varchar2) then
504: l_argument := 'org_payment_method_name';
505: raise l_error;
506: end if;
507: --

Line 512: hr_api.argument_changed_error

508: hr_utility.set_location(l_proc, 40);
509: --
510: EXCEPTION
511: WHEN l_error THEN
512: hr_api.argument_changed_error
513: (p_api_name => l_proc
514: ,p_argument => l_argument);
515: WHEN OTHERS THEN
516: RAISE;

Line 562: hr_api.mandatory_arg_error

558: Begin
559: --
560: -- Ensure that the p_datetrack_mode argument is not null
561: --
562: hr_api.mandatory_arg_error
563: (p_api_name => l_proc
564: ,p_argument => 'datetrack_mode'
565: ,p_argument_value => p_datetrack_mode
566: );

Line 572: hr_api.mandatory_arg_error

568: -- Mode will be valid, as this is checked at the start of the upd.
569: --
570: -- Ensure the arguments are not null
571: --
572: hr_api.mandatory_arg_error
573: (p_api_name => l_proc
574: ,p_argument => 'validation_start_date'
575: ,p_argument_value => p_validation_start_date
576: );

Line 578: hr_api.mandatory_arg_error

574: ,p_argument => 'validation_start_date'
575: ,p_argument_value => p_validation_start_date
576: );
577: --
578: hr_api.mandatory_arg_error
579: (p_api_name => l_proc
580: ,p_argument => 'validation_end_date'
581: ,p_argument_value => p_validation_end_date
582: );

Line 656: hr_api.mandatory_arg_error

652: Begin
653: --
654: -- Ensure that the p_datetrack_mode argument is not null
655: --
656: hr_api.mandatory_arg_error
657: (p_api_name => l_proc
658: ,p_argument => 'datetrack_mode'
659: ,p_argument_value => p_datetrack_mode
660: );

Line 665: If (p_datetrack_mode = hr_api.g_delete or

661: --
662: -- Only perform the validation if the datetrack mode is either
663: -- DELETE or ZAP
664: --
665: If (p_datetrack_mode = hr_api.g_delete or
666: p_datetrack_mode = hr_api.g_zap) then
667: --
668: --
669: -- Ensure the arguments are not null

Line 666: p_datetrack_mode = hr_api.g_zap) then

662: -- Only perform the validation if the datetrack mode is either
663: -- DELETE or ZAP
664: --
665: If (p_datetrack_mode = hr_api.g_delete or
666: p_datetrack_mode = hr_api.g_zap) then
667: --
668: --
669: -- Ensure the arguments are not null
670: --

Line 671: hr_api.mandatory_arg_error

667: --
668: --
669: -- Ensure the arguments are not null
670: --
671: hr_api.mandatory_arg_error
672: (p_api_name => l_proc
673: ,p_argument => 'validation_start_date'
674: ,p_argument_value => p_validation_start_date
675: );

Line 677: hr_api.mandatory_arg_error

673: ,p_argument => 'validation_start_date'
674: ,p_argument_value => p_validation_start_date
675: );
676: --
677: hr_api.mandatory_arg_error
678: (p_api_name => l_proc
679: ,p_argument => 'validation_end_date'
680: ,p_argument_value => p_validation_end_date
681: );

Line 683: hr_api.mandatory_arg_error

679: ,p_argument => 'validation_end_date'
680: ,p_argument_value => p_validation_end_date
681: );
682: --
683: hr_api.mandatory_arg_error
684: (p_api_name => l_proc
685: ,p_argument => 'org_payment_method_id'
686: ,p_argument_value => p_org_payment_method_id
687: );

Line 837: hr_api.mandatory_arg_error

833: --
834: -- Check mandatory external_account_id exists
835: --
836: --
837: hr_api.mandatory_arg_error
838: (p_api_name => l_proc
839: ,p_argument => 'payment_type_id'
840: ,p_argument_value => p_payment_type_id
841: );

Line 843: hr_api.mandatory_arg_error

839: ,p_argument => 'payment_type_id'
840: ,p_argument_value => p_payment_type_id
841: );
842: --
843: hr_api.mandatory_arg_error
844: (p_api_name => l_proc
845: ,p_argument => 'business_group_id'
846: ,p_argument_value => p_business_group_id
847: );

Line 849: hr_api.mandatory_arg_error

845: ,p_argument => 'business_group_id'
846: ,p_argument_value => p_business_group_id
847: );
848: --
849: hr_api.mandatory_arg_error
850: (p_api_name => l_proc
851: ,p_argument => 'effective_date'
852: ,p_argument_value => p_effective_date
853: );

Line 863: hr_api.mandatory_arg_error

859: if p_external_account_id is null and l_dummy > 2 then
860: return;
861: end if;
862: --
863: hr_api.mandatory_arg_error
864: (p_api_name => l_proc
865: ,p_argument => 'external_account_id'
866: ,p_argument_value => p_external_account_id
867: );

Line 880: nvl(pay_opm_shd.g_old_rec.external_account_id,hr_api.g_number) <>

876: --
877: -- Only proceed with SQL validation if absolutely necessary
878: --
879: if ((l_api_updating and
880: nvl(pay_opm_shd.g_old_rec.external_account_id,hr_api.g_number) <>
881: nvl(p_external_account_id,hr_api.g_number))
882: or (NOT l_api_updating)) then
883: --
884: hr_utility.set_location(l_proc,20);

Line 881: nvl(p_external_account_id,hr_api.g_number))

877: -- Only proceed with SQL validation if absolutely necessary
878: --
879: if ((l_api_updating and
880: nvl(pay_opm_shd.g_old_rec.external_account_id,hr_api.g_number) <>
881: nvl(p_external_account_id,hr_api.g_number))
882: or (NOT l_api_updating)) then
883: --
884: hr_utility.set_location(l_proc,20);
885: --

Line 967: hr_api.mandatory_arg_error

963: hr_utility.set_location('Entering:'||l_proc, 5);
964: --
965: -- Check mandatory currency_code exists
966: --
967: hr_api.mandatory_arg_error
968: (p_api_name => l_proc
969: ,p_argument => 'currency_code'
970: ,p_argument_value => p_currency_code
971: );

Line 973: hr_api.mandatory_arg_error

969: ,p_argument => 'currency_code'
970: ,p_argument_value => p_currency_code
971: );
972: --
973: hr_api.mandatory_arg_error
974: (p_api_name => l_proc
975: ,p_argument => 'payment_type_id'
976: ,p_argument_value => p_payment_type_id
977: );

Line 979: hr_api.mandatory_arg_error

975: ,p_argument => 'payment_type_id'
976: ,p_argument_value => p_payment_type_id
977: );
978: --
979: hr_api.mandatory_arg_error
980: (p_api_name => l_proc
981: ,p_argument => 'effective_date'
982: ,p_argument_value => p_effective_date
983: );

Line 996: nvl(pay_opm_shd.g_old_rec.currency_code,hr_api.g_varchar2) <>

992: --
993: -- Only proceed with SQL validation if absolutely necessary
994: --
995: if ((l_api_updating and
996: nvl(pay_opm_shd.g_old_rec.currency_code,hr_api.g_varchar2) <>
997: nvl(p_currency_code,hr_api.g_varchar2))
998: or (NOT l_api_updating)) then
999: --
1000: hr_utility.set_location(l_proc,20);

Line 997: nvl(p_currency_code,hr_api.g_varchar2))

993: -- Only proceed with SQL validation if absolutely necessary
994: --
995: if ((l_api_updating and
996: nvl(pay_opm_shd.g_old_rec.currency_code,hr_api.g_varchar2) <>
997: nvl(p_currency_code,hr_api.g_varchar2))
998: or (NOT l_api_updating)) then
999: --
1000: hr_utility.set_location(l_proc,20);
1001: --

Line 1087: hr_api.mandatory_arg_error

1083: hr_utility.set_location('Entering:'||l_proc, 5);
1084: --
1085: -- Check mandatory payment_type_id exists
1086: --
1087: hr_api.mandatory_arg_error
1088: (p_api_name => l_proc
1089: ,p_argument => 'payment_type_id'
1090: ,p_argument_value => p_payment_type_id
1091: );

Line 1093: hr_api.mandatory_arg_error

1089: ,p_argument => 'payment_type_id'
1090: ,p_argument_value => p_payment_type_id
1091: );
1092: --
1093: hr_api.mandatory_arg_error
1094: (p_api_name => l_proc
1095: ,p_argument => 'business_group_id'
1096: ,p_argument_value => p_business_group_id
1097: );

Line 1188: -- hr_api.mandatory_arg_error

1184: hr_utility.set_location('Entering:'||l_proc, 5);
1185: --
1186: -- Check mandatory defined_balance_id exists
1187: --
1188: -- hr_api.mandatory_arg_error
1189: -- (p_api_name => l_proc
1190: -- ,p_argument => 'defined_balance_id'
1191: -- ,p_argument_value => p_defined_balance_id
1192: -- );

Line 1194: hr_api.mandatory_arg_error

1190: -- ,p_argument => 'defined_balance_id'
1191: -- ,p_argument_value => p_defined_balance_id
1192: -- );
1193: --
1194: hr_api.mandatory_arg_error
1195: (p_api_name => l_proc
1196: ,p_argument => 'business_group_id'
1197: ,p_argument_value => p_business_group_id
1198: );

Line 1279: hr_api.mandatory_arg_error

1275: hr_utility.set_location('Entering:'||l_proc, 5);
1276: --
1277: -- Check mandatory org_payment_method_name exists
1278: --
1279: hr_api.mandatory_arg_error
1280: (p_api_name => l_proc
1281: ,p_argument => 'org_payment_method_name'
1282: ,p_argument_value => p_org_payment_method_name
1283: );

Line 1285: hr_api.mandatory_arg_error

1281: ,p_argument => 'org_payment_method_name'
1282: ,p_argument_value => p_org_payment_method_name
1283: );
1284: --
1285: hr_api.mandatory_arg_error
1286: (p_api_name => l_proc
1287: ,p_argument => 'business_group_id'
1288: ,p_argument_value => p_business_group_id
1289: );

Line 1369: hr_api.mandatory_arg_error

1365: Begin
1366: hr_utility.set_location('Entering:'||l_proc, 5);
1367: --
1368: --
1369: hr_api.mandatory_arg_error
1370: (p_api_name => l_proc
1371: ,p_argument => 'validation_start_date'
1372: ,p_argument_value => p_validation_start_date
1373: );

Line 1429: l_legislation_code := hr_api.return_legislation_code(p_business_group_id);

1425: and lfi.legislation_code = l_legislation_code;
1426: begin
1427: hr_utility.set_location(l_proc,10);
1428: --
1429: l_legislation_code := hr_api.return_legislation_code(p_business_group_id);
1430: --
1431: open csr_chk_leg_field_info;
1432: fetch csr_chk_leg_field_info into l_flag;
1433: if (csr_chk_leg_field_info % NOTFOUND or

Line 1478: if hr_api.not_exists_in_hr_lookups

1474: ) is
1475: begin
1476: if (p_cost_payment is not null) then
1477: --
1478: if hr_api.not_exists_in_hr_lookups
1479: (p_effective_date
1480: ,'YES_NO'
1481: ,p_cost_payment) then
1482: --

Line 1513: if hr_api.not_exists_in_hr_lookups

1509: ) is
1510: begin
1511: if(p_cost_cleared_payment is not null) then
1512: --
1513: if hr_api.not_exists_in_hr_lookups
1514: (p_effective_date
1515: ,'YES_NO'
1516: ,p_cost_cleared_payment) then
1517: --

Line 1556: if hr_api.not_exists_in_hr_lookups

1552: ) is
1553: begin
1554: if (p_cost_cleared_void_payment is not null) then
1555: --
1556: if hr_api.not_exists_in_hr_lookups
1557: (p_effective_date
1558: ,'YES_NO'
1559: ,p_cost_cleared_void_payment) then
1560: --

Line 1599: if hr_api.not_exists_in_hr_lookups

1595: ) is
1596: begin
1597: if (p_exclude_manual_payment is not null) then
1598: --
1599: if hr_api.not_exists_in_hr_lookups
1600: (p_effective_date
1601: ,'YES_NO'
1602: ,p_exclude_manual_payment) then
1603: --

Line 1642: if hr_api.not_exists_in_hr_lookups

1638: ) is
1639: begin
1640: if(p_transfer_to_gl_flag is not null) then
1641: --
1642: if hr_api.not_exists_in_hr_lookups
1643: (p_effective_date
1644: ,'YES_NO'
1645: ,p_transfer_to_gl_flag) then
1646: --

Line 1728: and (p_datetrack_mode = hr_api.g_zap

1724: pay_payroll_actions ppa
1725: where ppt.org_payment_method_id = p_org_payment_method_id
1726: and ppt.assignment_action_id = paa.assignment_action_id
1727: and paa.payroll_action_id = ppa.payroll_action_id
1728: and (p_datetrack_mode = hr_api.g_zap
1729: or (p_datetrack_mode = hr_api.g_delete
1730: and p_effective_date < ppa.effective_date));
1731: --
1732: cursor csr_org_pay_methods_tl_exists is

Line 1729: or (p_datetrack_mode = hr_api.g_delete

1725: where ppt.org_payment_method_id = p_org_payment_method_id
1726: and ppt.assignment_action_id = paa.assignment_action_id
1727: and paa.payroll_action_id = ppa.payroll_action_id
1728: and (p_datetrack_mode = hr_api.g_zap
1729: or (p_datetrack_mode = hr_api.g_delete
1730: and p_effective_date < ppa.effective_date));
1731: --
1732: cursor csr_org_pay_methods_tl_exists is
1733: select null

Line 1736: and p_datetrack_mode = hr_api.g_zap;

1732: cursor csr_org_pay_methods_tl_exists is
1733: select null
1734: from pay_org_payment_methods_f_tl opt
1735: where opt.org_payment_method_id = p_org_payment_method_id
1736: and p_datetrack_mode = hr_api.g_zap;
1737: --
1738: cursor csr_payroll_actions_exists is
1739: select null
1740: from pay_payroll_actions ppa

Line 1742: and (p_datetrack_mode = hr_api.g_zap

1738: cursor csr_payroll_actions_exists is
1739: select null
1740: from pay_payroll_actions ppa
1741: where ppa.org_payment_method_id = p_org_payment_method_id
1742: and (p_datetrack_mode = hr_api.g_zap
1743: or (p_datetrack_mode = hr_api.g_delete
1744: and p_effective_date < ppa.effective_date));
1745: --
1746: cursor csr_payrolls_exists is

Line 1743: or (p_datetrack_mode = hr_api.g_delete

1739: select null
1740: from pay_payroll_actions ppa
1741: where ppa.org_payment_method_id = p_org_payment_method_id
1742: and (p_datetrack_mode = hr_api.g_zap
1743: or (p_datetrack_mode = hr_api.g_delete
1744: and p_effective_date < ppa.effective_date));
1745: --
1746: cursor csr_payrolls_exists is
1747: select null

Line 1757: hr_api.mandatory_arg_error

1753: hr_utility.set_location('Entering:'||l_proc, 1);
1754: --
1755: -- Ensure that the p_datetrack_mode argument is not null
1756: --
1757: hr_api.mandatory_arg_error
1758: (p_api_name => l_proc
1759: ,p_argument => 'datetrack_mode'
1760: ,p_argument_value => p_datetrack_mode
1761: );

Line 1766: If (p_datetrack_mode = hr_api.g_delete or

1762: --
1763: -- Only perform the validation if the datetrack mode is either
1764: -- DELETE or ZAP
1765: --
1766: If (p_datetrack_mode = hr_api.g_delete or
1767: p_datetrack_mode = hr_api.g_zap) then
1768: --
1769: -- Ensure the arguments are not null
1770: --

Line 1767: p_datetrack_mode = hr_api.g_zap) then

1763: -- Only perform the validation if the datetrack mode is either
1764: -- DELETE or ZAP
1765: --
1766: If (p_datetrack_mode = hr_api.g_delete or
1767: p_datetrack_mode = hr_api.g_zap) then
1768: --
1769: -- Ensure the arguments are not null
1770: --
1771: hr_api.mandatory_arg_error

Line 1771: hr_api.mandatory_arg_error

1767: p_datetrack_mode = hr_api.g_zap) then
1768: --
1769: -- Ensure the arguments are not null
1770: --
1771: hr_api.mandatory_arg_error
1772: (p_api_name => l_proc
1773: ,p_argument => 'effective_date'
1774: ,p_argument_value => p_effective_date
1775: );

Line 1777: hr_api.mandatory_arg_error

1773: ,p_argument => 'effective_date'
1774: ,p_argument_value => p_effective_date
1775: );
1776: --
1777: hr_api.mandatory_arg_error
1778: (p_api_name => l_proc
1779: ,p_argument => 'business_group_id'
1780: ,p_argument_value => p_business_group_id
1781: );

Line 1851: if (p_datetrack_mode = hr_api.g_zap) then

1847: If csr_payrolls_exists%found Then
1848: --
1849: close csr_payrolls_exists;
1850: --
1851: if (p_datetrack_mode = hr_api.g_zap) then
1852: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1853: fnd_message.set_token('TABLE_NAME', 'PAY_ALL_PAYROLLS_F');
1854: fnd_message.raise_error;
1855: else

Line 1900: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1896: hr_utility.set_location('Entering:'||l_proc, 5);
1897: --
1898: -- Call all supporting business operations
1899: --
1900: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1901: --
1902: hr_utility.set_location(l_proc,10);
1903: --
1904: pay_opm_bus.chk_external_account_id(p_external_account_id => p_rec.external_account_id

Line 2004: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

2000: hr_utility.set_location('Entering:'||l_proc, 5);
2001: --
2002: -- Call all supporting business operations
2003: --
2004: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
2005: --
2006: -- Call the datetrack update integrity operation
2007: --
2008: dt_update_validate