41: hr_utility.set_location('Entering:'|| l_proc, 10);
42: --
43: -- Ensure that all the mandatory parameter are not null
44: --
45: hr_api.mandatory_arg_error
46: (p_api_name => l_proc
47: ,p_argument => 'element_type_id'
48: ,p_argument_value => p_element_type_id
49: );
67: close csr_sec_grp;
68: --
69: -- Set the security_group_id in CLIENT_INFO
70: --
71: hr_api.set_security_group_id
72: (p_security_group_id => l_security_group_id
73: );
74: end if;
75: --
105: hr_utility.set_location('Entering:'|| l_proc, 10);
106: --
107: -- Ensure that all the mandatory parameter are not null
108: --
109: hr_api.mandatory_arg_error
110: (p_api_name => l_proc
111: ,p_argument => 'element_type_id'
112: ,p_argument_value => p_element_type_id
113: );
111: ,p_argument => 'element_type_id'
112: ,p_argument_value => p_element_type_id
113: );
114: --
115: if ( nvl(pay_etp_bus_nd.g_element_type_id, hr_api.g_number)
116: = p_element_type_id) then
117: --
118: -- The legislation code has already been found with a previous
119: -- call to this function. Just return the value in the global
188: hr_utility.set_location('Entering:'||l_proc,10);
189: --
190: if ((p_rec.element_type_id is not null) and
191: (nvl(pay_etp_shd_nd.g_old_rec.element_information_category,
192: hr_api.g_varchar2) <>
193: nvl(p_rec.element_information_category, hr_api.g_varchar2) or
194: nvl(pay_etp_shd_nd.g_old_rec.element_information1, hr_api.g_varchar2) <>
195: nvl(p_rec.element_information1, hr_api.g_varchar2) or
196: nvl(pay_etp_shd_nd.g_old_rec.element_information2, hr_api.g_varchar2) <>
189: --
190: if ((p_rec.element_type_id is not null) and
191: (nvl(pay_etp_shd_nd.g_old_rec.element_information_category,
192: hr_api.g_varchar2) <>
193: nvl(p_rec.element_information_category, hr_api.g_varchar2) or
194: nvl(pay_etp_shd_nd.g_old_rec.element_information1, hr_api.g_varchar2) <>
195: nvl(p_rec.element_information1, hr_api.g_varchar2) or
196: nvl(pay_etp_shd_nd.g_old_rec.element_information2, hr_api.g_varchar2) <>
197: nvl(p_rec.element_information2, hr_api.g_varchar2) or
190: if ((p_rec.element_type_id is not null) and
191: (nvl(pay_etp_shd_nd.g_old_rec.element_information_category,
192: hr_api.g_varchar2) <>
193: nvl(p_rec.element_information_category, hr_api.g_varchar2) or
194: nvl(pay_etp_shd_nd.g_old_rec.element_information1, hr_api.g_varchar2) <>
195: nvl(p_rec.element_information1, hr_api.g_varchar2) or
196: nvl(pay_etp_shd_nd.g_old_rec.element_information2, hr_api.g_varchar2) <>
197: nvl(p_rec.element_information2, hr_api.g_varchar2) or
198: nvl(pay_etp_shd_nd.g_old_rec.element_information3, hr_api.g_varchar2) <>
191: (nvl(pay_etp_shd_nd.g_old_rec.element_information_category,
192: hr_api.g_varchar2) <>
193: nvl(p_rec.element_information_category, hr_api.g_varchar2) or
194: nvl(pay_etp_shd_nd.g_old_rec.element_information1, hr_api.g_varchar2) <>
195: nvl(p_rec.element_information1, hr_api.g_varchar2) or
196: nvl(pay_etp_shd_nd.g_old_rec.element_information2, hr_api.g_varchar2) <>
197: nvl(p_rec.element_information2, hr_api.g_varchar2) or
198: nvl(pay_etp_shd_nd.g_old_rec.element_information3, hr_api.g_varchar2) <>
199: nvl(p_rec.element_information3, hr_api.g_varchar2) or
192: hr_api.g_varchar2) <>
193: nvl(p_rec.element_information_category, hr_api.g_varchar2) or
194: nvl(pay_etp_shd_nd.g_old_rec.element_information1, hr_api.g_varchar2) <>
195: nvl(p_rec.element_information1, hr_api.g_varchar2) or
196: nvl(pay_etp_shd_nd.g_old_rec.element_information2, hr_api.g_varchar2) <>
197: nvl(p_rec.element_information2, hr_api.g_varchar2) or
198: nvl(pay_etp_shd_nd.g_old_rec.element_information3, hr_api.g_varchar2) <>
199: nvl(p_rec.element_information3, hr_api.g_varchar2) or
200: nvl(pay_etp_shd_nd.g_old_rec.element_information4, hr_api.g_varchar2) <>
193: nvl(p_rec.element_information_category, hr_api.g_varchar2) or
194: nvl(pay_etp_shd_nd.g_old_rec.element_information1, hr_api.g_varchar2) <>
195: nvl(p_rec.element_information1, hr_api.g_varchar2) or
196: nvl(pay_etp_shd_nd.g_old_rec.element_information2, hr_api.g_varchar2) <>
197: nvl(p_rec.element_information2, hr_api.g_varchar2) or
198: nvl(pay_etp_shd_nd.g_old_rec.element_information3, hr_api.g_varchar2) <>
199: nvl(p_rec.element_information3, hr_api.g_varchar2) or
200: nvl(pay_etp_shd_nd.g_old_rec.element_information4, hr_api.g_varchar2) <>
201: nvl(p_rec.element_information4, hr_api.g_varchar2) or
194: nvl(pay_etp_shd_nd.g_old_rec.element_information1, hr_api.g_varchar2) <>
195: nvl(p_rec.element_information1, hr_api.g_varchar2) or
196: nvl(pay_etp_shd_nd.g_old_rec.element_information2, hr_api.g_varchar2) <>
197: nvl(p_rec.element_information2, hr_api.g_varchar2) or
198: nvl(pay_etp_shd_nd.g_old_rec.element_information3, hr_api.g_varchar2) <>
199: nvl(p_rec.element_information3, hr_api.g_varchar2) or
200: nvl(pay_etp_shd_nd.g_old_rec.element_information4, hr_api.g_varchar2) <>
201: nvl(p_rec.element_information4, hr_api.g_varchar2) or
202: nvl(pay_etp_shd_nd.g_old_rec.element_information5, hr_api.g_varchar2) <>
195: nvl(p_rec.element_information1, hr_api.g_varchar2) or
196: nvl(pay_etp_shd_nd.g_old_rec.element_information2, hr_api.g_varchar2) <>
197: nvl(p_rec.element_information2, hr_api.g_varchar2) or
198: nvl(pay_etp_shd_nd.g_old_rec.element_information3, hr_api.g_varchar2) <>
199: nvl(p_rec.element_information3, hr_api.g_varchar2) or
200: nvl(pay_etp_shd_nd.g_old_rec.element_information4, hr_api.g_varchar2) <>
201: nvl(p_rec.element_information4, hr_api.g_varchar2) or
202: nvl(pay_etp_shd_nd.g_old_rec.element_information5, hr_api.g_varchar2) <>
203: nvl(p_rec.element_information5, hr_api.g_varchar2) or
196: nvl(pay_etp_shd_nd.g_old_rec.element_information2, hr_api.g_varchar2) <>
197: nvl(p_rec.element_information2, hr_api.g_varchar2) or
198: nvl(pay_etp_shd_nd.g_old_rec.element_information3, hr_api.g_varchar2) <>
199: nvl(p_rec.element_information3, hr_api.g_varchar2) or
200: nvl(pay_etp_shd_nd.g_old_rec.element_information4, hr_api.g_varchar2) <>
201: nvl(p_rec.element_information4, hr_api.g_varchar2) or
202: nvl(pay_etp_shd_nd.g_old_rec.element_information5, hr_api.g_varchar2) <>
203: nvl(p_rec.element_information5, hr_api.g_varchar2) or
204: nvl(pay_etp_shd_nd.g_old_rec.element_information6, hr_api.g_varchar2) <>
197: nvl(p_rec.element_information2, hr_api.g_varchar2) or
198: nvl(pay_etp_shd_nd.g_old_rec.element_information3, hr_api.g_varchar2) <>
199: nvl(p_rec.element_information3, hr_api.g_varchar2) or
200: nvl(pay_etp_shd_nd.g_old_rec.element_information4, hr_api.g_varchar2) <>
201: nvl(p_rec.element_information4, hr_api.g_varchar2) or
202: nvl(pay_etp_shd_nd.g_old_rec.element_information5, hr_api.g_varchar2) <>
203: nvl(p_rec.element_information5, hr_api.g_varchar2) or
204: nvl(pay_etp_shd_nd.g_old_rec.element_information6, hr_api.g_varchar2) <>
205: nvl(p_rec.element_information6, hr_api.g_varchar2) or
198: nvl(pay_etp_shd_nd.g_old_rec.element_information3, hr_api.g_varchar2) <>
199: nvl(p_rec.element_information3, hr_api.g_varchar2) or
200: nvl(pay_etp_shd_nd.g_old_rec.element_information4, hr_api.g_varchar2) <>
201: nvl(p_rec.element_information4, hr_api.g_varchar2) or
202: nvl(pay_etp_shd_nd.g_old_rec.element_information5, hr_api.g_varchar2) <>
203: nvl(p_rec.element_information5, hr_api.g_varchar2) or
204: nvl(pay_etp_shd_nd.g_old_rec.element_information6, hr_api.g_varchar2) <>
205: nvl(p_rec.element_information6, hr_api.g_varchar2) or
206: nvl(pay_etp_shd_nd.g_old_rec.element_information7, hr_api.g_varchar2) <>
199: nvl(p_rec.element_information3, hr_api.g_varchar2) or
200: nvl(pay_etp_shd_nd.g_old_rec.element_information4, hr_api.g_varchar2) <>
201: nvl(p_rec.element_information4, hr_api.g_varchar2) or
202: nvl(pay_etp_shd_nd.g_old_rec.element_information5, hr_api.g_varchar2) <>
203: nvl(p_rec.element_information5, hr_api.g_varchar2) or
204: nvl(pay_etp_shd_nd.g_old_rec.element_information6, hr_api.g_varchar2) <>
205: nvl(p_rec.element_information6, hr_api.g_varchar2) or
206: nvl(pay_etp_shd_nd.g_old_rec.element_information7, hr_api.g_varchar2) <>
207: nvl(p_rec.element_information7, hr_api.g_varchar2) or
200: nvl(pay_etp_shd_nd.g_old_rec.element_information4, hr_api.g_varchar2) <>
201: nvl(p_rec.element_information4, hr_api.g_varchar2) or
202: nvl(pay_etp_shd_nd.g_old_rec.element_information5, hr_api.g_varchar2) <>
203: nvl(p_rec.element_information5, hr_api.g_varchar2) or
204: nvl(pay_etp_shd_nd.g_old_rec.element_information6, hr_api.g_varchar2) <>
205: nvl(p_rec.element_information6, hr_api.g_varchar2) or
206: nvl(pay_etp_shd_nd.g_old_rec.element_information7, hr_api.g_varchar2) <>
207: nvl(p_rec.element_information7, hr_api.g_varchar2) or
208: nvl(pay_etp_shd_nd.g_old_rec.element_information8, hr_api.g_varchar2) <>
201: nvl(p_rec.element_information4, hr_api.g_varchar2) or
202: nvl(pay_etp_shd_nd.g_old_rec.element_information5, hr_api.g_varchar2) <>
203: nvl(p_rec.element_information5, hr_api.g_varchar2) or
204: nvl(pay_etp_shd_nd.g_old_rec.element_information6, hr_api.g_varchar2) <>
205: nvl(p_rec.element_information6, hr_api.g_varchar2) or
206: nvl(pay_etp_shd_nd.g_old_rec.element_information7, hr_api.g_varchar2) <>
207: nvl(p_rec.element_information7, hr_api.g_varchar2) or
208: nvl(pay_etp_shd_nd.g_old_rec.element_information8, hr_api.g_varchar2) <>
209: nvl(p_rec.element_information8, hr_api.g_varchar2) or
202: nvl(pay_etp_shd_nd.g_old_rec.element_information5, hr_api.g_varchar2) <>
203: nvl(p_rec.element_information5, hr_api.g_varchar2) or
204: nvl(pay_etp_shd_nd.g_old_rec.element_information6, hr_api.g_varchar2) <>
205: nvl(p_rec.element_information6, hr_api.g_varchar2) or
206: nvl(pay_etp_shd_nd.g_old_rec.element_information7, hr_api.g_varchar2) <>
207: nvl(p_rec.element_information7, hr_api.g_varchar2) or
208: nvl(pay_etp_shd_nd.g_old_rec.element_information8, hr_api.g_varchar2) <>
209: nvl(p_rec.element_information8, hr_api.g_varchar2) or
210: nvl(pay_etp_shd_nd.g_old_rec.element_information9, hr_api.g_varchar2) <>
203: nvl(p_rec.element_information5, hr_api.g_varchar2) or
204: nvl(pay_etp_shd_nd.g_old_rec.element_information6, hr_api.g_varchar2) <>
205: nvl(p_rec.element_information6, hr_api.g_varchar2) or
206: nvl(pay_etp_shd_nd.g_old_rec.element_information7, hr_api.g_varchar2) <>
207: nvl(p_rec.element_information7, hr_api.g_varchar2) or
208: nvl(pay_etp_shd_nd.g_old_rec.element_information8, hr_api.g_varchar2) <>
209: nvl(p_rec.element_information8, hr_api.g_varchar2) or
210: nvl(pay_etp_shd_nd.g_old_rec.element_information9, hr_api.g_varchar2) <>
211: nvl(p_rec.element_information9, hr_api.g_varchar2) or
204: nvl(pay_etp_shd_nd.g_old_rec.element_information6, hr_api.g_varchar2) <>
205: nvl(p_rec.element_information6, hr_api.g_varchar2) or
206: nvl(pay_etp_shd_nd.g_old_rec.element_information7, hr_api.g_varchar2) <>
207: nvl(p_rec.element_information7, hr_api.g_varchar2) or
208: nvl(pay_etp_shd_nd.g_old_rec.element_information8, hr_api.g_varchar2) <>
209: nvl(p_rec.element_information8, hr_api.g_varchar2) or
210: nvl(pay_etp_shd_nd.g_old_rec.element_information9, hr_api.g_varchar2) <>
211: nvl(p_rec.element_information9, hr_api.g_varchar2) or
212: nvl(pay_etp_shd_nd.g_old_rec.element_information10, hr_api.g_varchar2) <>
205: nvl(p_rec.element_information6, hr_api.g_varchar2) or
206: nvl(pay_etp_shd_nd.g_old_rec.element_information7, hr_api.g_varchar2) <>
207: nvl(p_rec.element_information7, hr_api.g_varchar2) or
208: nvl(pay_etp_shd_nd.g_old_rec.element_information8, hr_api.g_varchar2) <>
209: nvl(p_rec.element_information8, hr_api.g_varchar2) or
210: nvl(pay_etp_shd_nd.g_old_rec.element_information9, hr_api.g_varchar2) <>
211: nvl(p_rec.element_information9, hr_api.g_varchar2) or
212: nvl(pay_etp_shd_nd.g_old_rec.element_information10, hr_api.g_varchar2) <>
213: nvl(p_rec.element_information10, hr_api.g_varchar2) or
206: nvl(pay_etp_shd_nd.g_old_rec.element_information7, hr_api.g_varchar2) <>
207: nvl(p_rec.element_information7, hr_api.g_varchar2) or
208: nvl(pay_etp_shd_nd.g_old_rec.element_information8, hr_api.g_varchar2) <>
209: nvl(p_rec.element_information8, hr_api.g_varchar2) or
210: nvl(pay_etp_shd_nd.g_old_rec.element_information9, hr_api.g_varchar2) <>
211: nvl(p_rec.element_information9, hr_api.g_varchar2) or
212: nvl(pay_etp_shd_nd.g_old_rec.element_information10, hr_api.g_varchar2) <>
213: nvl(p_rec.element_information10, hr_api.g_varchar2) or
214: nvl(pay_etp_shd_nd.g_old_rec.element_information11, hr_api.g_varchar2) <>
207: nvl(p_rec.element_information7, hr_api.g_varchar2) or
208: nvl(pay_etp_shd_nd.g_old_rec.element_information8, hr_api.g_varchar2) <>
209: nvl(p_rec.element_information8, hr_api.g_varchar2) or
210: nvl(pay_etp_shd_nd.g_old_rec.element_information9, hr_api.g_varchar2) <>
211: nvl(p_rec.element_information9, hr_api.g_varchar2) or
212: nvl(pay_etp_shd_nd.g_old_rec.element_information10, hr_api.g_varchar2) <>
213: nvl(p_rec.element_information10, hr_api.g_varchar2) or
214: nvl(pay_etp_shd_nd.g_old_rec.element_information11, hr_api.g_varchar2) <>
215: nvl(p_rec.element_information11, hr_api.g_varchar2) or
208: nvl(pay_etp_shd_nd.g_old_rec.element_information8, hr_api.g_varchar2) <>
209: nvl(p_rec.element_information8, hr_api.g_varchar2) or
210: nvl(pay_etp_shd_nd.g_old_rec.element_information9, hr_api.g_varchar2) <>
211: nvl(p_rec.element_information9, hr_api.g_varchar2) or
212: nvl(pay_etp_shd_nd.g_old_rec.element_information10, hr_api.g_varchar2) <>
213: nvl(p_rec.element_information10, hr_api.g_varchar2) or
214: nvl(pay_etp_shd_nd.g_old_rec.element_information11, hr_api.g_varchar2) <>
215: nvl(p_rec.element_information11, hr_api.g_varchar2) or
216: nvl(pay_etp_shd_nd.g_old_rec.element_information12, hr_api.g_varchar2) <>
209: nvl(p_rec.element_information8, hr_api.g_varchar2) or
210: nvl(pay_etp_shd_nd.g_old_rec.element_information9, hr_api.g_varchar2) <>
211: nvl(p_rec.element_information9, hr_api.g_varchar2) or
212: nvl(pay_etp_shd_nd.g_old_rec.element_information10, hr_api.g_varchar2) <>
213: nvl(p_rec.element_information10, hr_api.g_varchar2) or
214: nvl(pay_etp_shd_nd.g_old_rec.element_information11, hr_api.g_varchar2) <>
215: nvl(p_rec.element_information11, hr_api.g_varchar2) or
216: nvl(pay_etp_shd_nd.g_old_rec.element_information12, hr_api.g_varchar2) <>
217: nvl(p_rec.element_information12, hr_api.g_varchar2) or
210: nvl(pay_etp_shd_nd.g_old_rec.element_information9, hr_api.g_varchar2) <>
211: nvl(p_rec.element_information9, hr_api.g_varchar2) or
212: nvl(pay_etp_shd_nd.g_old_rec.element_information10, hr_api.g_varchar2) <>
213: nvl(p_rec.element_information10, hr_api.g_varchar2) or
214: nvl(pay_etp_shd_nd.g_old_rec.element_information11, hr_api.g_varchar2) <>
215: nvl(p_rec.element_information11, hr_api.g_varchar2) or
216: nvl(pay_etp_shd_nd.g_old_rec.element_information12, hr_api.g_varchar2) <>
217: nvl(p_rec.element_information12, hr_api.g_varchar2) or
218: nvl(pay_etp_shd_nd.g_old_rec.element_information13, hr_api.g_varchar2) <>
211: nvl(p_rec.element_information9, hr_api.g_varchar2) or
212: nvl(pay_etp_shd_nd.g_old_rec.element_information10, hr_api.g_varchar2) <>
213: nvl(p_rec.element_information10, hr_api.g_varchar2) or
214: nvl(pay_etp_shd_nd.g_old_rec.element_information11, hr_api.g_varchar2) <>
215: nvl(p_rec.element_information11, hr_api.g_varchar2) or
216: nvl(pay_etp_shd_nd.g_old_rec.element_information12, hr_api.g_varchar2) <>
217: nvl(p_rec.element_information12, hr_api.g_varchar2) or
218: nvl(pay_etp_shd_nd.g_old_rec.element_information13, hr_api.g_varchar2) <>
219: nvl(p_rec.element_information13, hr_api.g_varchar2) or
212: nvl(pay_etp_shd_nd.g_old_rec.element_information10, hr_api.g_varchar2) <>
213: nvl(p_rec.element_information10, hr_api.g_varchar2) or
214: nvl(pay_etp_shd_nd.g_old_rec.element_information11, hr_api.g_varchar2) <>
215: nvl(p_rec.element_information11, hr_api.g_varchar2) or
216: nvl(pay_etp_shd_nd.g_old_rec.element_information12, hr_api.g_varchar2) <>
217: nvl(p_rec.element_information12, hr_api.g_varchar2) or
218: nvl(pay_etp_shd_nd.g_old_rec.element_information13, hr_api.g_varchar2) <>
219: nvl(p_rec.element_information13, hr_api.g_varchar2) or
220: nvl(pay_etp_shd_nd.g_old_rec.element_information14, hr_api.g_varchar2) <>
213: nvl(p_rec.element_information10, hr_api.g_varchar2) or
214: nvl(pay_etp_shd_nd.g_old_rec.element_information11, hr_api.g_varchar2) <>
215: nvl(p_rec.element_information11, hr_api.g_varchar2) or
216: nvl(pay_etp_shd_nd.g_old_rec.element_information12, hr_api.g_varchar2) <>
217: nvl(p_rec.element_information12, hr_api.g_varchar2) or
218: nvl(pay_etp_shd_nd.g_old_rec.element_information13, hr_api.g_varchar2) <>
219: nvl(p_rec.element_information13, hr_api.g_varchar2) or
220: nvl(pay_etp_shd_nd.g_old_rec.element_information14, hr_api.g_varchar2) <>
221: nvl(p_rec.element_information14, hr_api.g_varchar2) or
214: nvl(pay_etp_shd_nd.g_old_rec.element_information11, hr_api.g_varchar2) <>
215: nvl(p_rec.element_information11, hr_api.g_varchar2) or
216: nvl(pay_etp_shd_nd.g_old_rec.element_information12, hr_api.g_varchar2) <>
217: nvl(p_rec.element_information12, hr_api.g_varchar2) or
218: nvl(pay_etp_shd_nd.g_old_rec.element_information13, hr_api.g_varchar2) <>
219: nvl(p_rec.element_information13, hr_api.g_varchar2) or
220: nvl(pay_etp_shd_nd.g_old_rec.element_information14, hr_api.g_varchar2) <>
221: nvl(p_rec.element_information14, hr_api.g_varchar2) or
222: nvl(pay_etp_shd_nd.g_old_rec.element_information15, hr_api.g_varchar2) <>
215: nvl(p_rec.element_information11, hr_api.g_varchar2) or
216: nvl(pay_etp_shd_nd.g_old_rec.element_information12, hr_api.g_varchar2) <>
217: nvl(p_rec.element_information12, hr_api.g_varchar2) or
218: nvl(pay_etp_shd_nd.g_old_rec.element_information13, hr_api.g_varchar2) <>
219: nvl(p_rec.element_information13, hr_api.g_varchar2) or
220: nvl(pay_etp_shd_nd.g_old_rec.element_information14, hr_api.g_varchar2) <>
221: nvl(p_rec.element_information14, hr_api.g_varchar2) or
222: nvl(pay_etp_shd_nd.g_old_rec.element_information15, hr_api.g_varchar2) <>
223: nvl(p_rec.element_information15, hr_api.g_varchar2) or
216: nvl(pay_etp_shd_nd.g_old_rec.element_information12, hr_api.g_varchar2) <>
217: nvl(p_rec.element_information12, hr_api.g_varchar2) or
218: nvl(pay_etp_shd_nd.g_old_rec.element_information13, hr_api.g_varchar2) <>
219: nvl(p_rec.element_information13, hr_api.g_varchar2) or
220: nvl(pay_etp_shd_nd.g_old_rec.element_information14, hr_api.g_varchar2) <>
221: nvl(p_rec.element_information14, hr_api.g_varchar2) or
222: nvl(pay_etp_shd_nd.g_old_rec.element_information15, hr_api.g_varchar2) <>
223: nvl(p_rec.element_information15, hr_api.g_varchar2) or
224: nvl(pay_etp_shd_nd.g_old_rec.element_information16, hr_api.g_varchar2) <>
217: nvl(p_rec.element_information12, hr_api.g_varchar2) or
218: nvl(pay_etp_shd_nd.g_old_rec.element_information13, hr_api.g_varchar2) <>
219: nvl(p_rec.element_information13, hr_api.g_varchar2) or
220: nvl(pay_etp_shd_nd.g_old_rec.element_information14, hr_api.g_varchar2) <>
221: nvl(p_rec.element_information14, hr_api.g_varchar2) or
222: nvl(pay_etp_shd_nd.g_old_rec.element_information15, hr_api.g_varchar2) <>
223: nvl(p_rec.element_information15, hr_api.g_varchar2) or
224: nvl(pay_etp_shd_nd.g_old_rec.element_information16, hr_api.g_varchar2) <>
225: nvl(p_rec.element_information16, hr_api.g_varchar2) or
218: nvl(pay_etp_shd_nd.g_old_rec.element_information13, hr_api.g_varchar2) <>
219: nvl(p_rec.element_information13, hr_api.g_varchar2) or
220: nvl(pay_etp_shd_nd.g_old_rec.element_information14, hr_api.g_varchar2) <>
221: nvl(p_rec.element_information14, hr_api.g_varchar2) or
222: nvl(pay_etp_shd_nd.g_old_rec.element_information15, hr_api.g_varchar2) <>
223: nvl(p_rec.element_information15, hr_api.g_varchar2) or
224: nvl(pay_etp_shd_nd.g_old_rec.element_information16, hr_api.g_varchar2) <>
225: nvl(p_rec.element_information16, hr_api.g_varchar2) or
226: nvl(pay_etp_shd_nd.g_old_rec.element_information17, hr_api.g_varchar2) <>
219: nvl(p_rec.element_information13, hr_api.g_varchar2) or
220: nvl(pay_etp_shd_nd.g_old_rec.element_information14, hr_api.g_varchar2) <>
221: nvl(p_rec.element_information14, hr_api.g_varchar2) or
222: nvl(pay_etp_shd_nd.g_old_rec.element_information15, hr_api.g_varchar2) <>
223: nvl(p_rec.element_information15, hr_api.g_varchar2) or
224: nvl(pay_etp_shd_nd.g_old_rec.element_information16, hr_api.g_varchar2) <>
225: nvl(p_rec.element_information16, hr_api.g_varchar2) or
226: nvl(pay_etp_shd_nd.g_old_rec.element_information17, hr_api.g_varchar2) <>
227: nvl(p_rec.element_information17, hr_api.g_varchar2) or
220: nvl(pay_etp_shd_nd.g_old_rec.element_information14, hr_api.g_varchar2) <>
221: nvl(p_rec.element_information14, hr_api.g_varchar2) or
222: nvl(pay_etp_shd_nd.g_old_rec.element_information15, hr_api.g_varchar2) <>
223: nvl(p_rec.element_information15, hr_api.g_varchar2) or
224: nvl(pay_etp_shd_nd.g_old_rec.element_information16, hr_api.g_varchar2) <>
225: nvl(p_rec.element_information16, hr_api.g_varchar2) or
226: nvl(pay_etp_shd_nd.g_old_rec.element_information17, hr_api.g_varchar2) <>
227: nvl(p_rec.element_information17, hr_api.g_varchar2) or
228: nvl(pay_etp_shd_nd.g_old_rec.element_information18, hr_api.g_varchar2) <>
221: nvl(p_rec.element_information14, hr_api.g_varchar2) or
222: nvl(pay_etp_shd_nd.g_old_rec.element_information15, hr_api.g_varchar2) <>
223: nvl(p_rec.element_information15, hr_api.g_varchar2) or
224: nvl(pay_etp_shd_nd.g_old_rec.element_information16, hr_api.g_varchar2) <>
225: nvl(p_rec.element_information16, hr_api.g_varchar2) or
226: nvl(pay_etp_shd_nd.g_old_rec.element_information17, hr_api.g_varchar2) <>
227: nvl(p_rec.element_information17, hr_api.g_varchar2) or
228: nvl(pay_etp_shd_nd.g_old_rec.element_information18, hr_api.g_varchar2) <>
229: nvl(p_rec.element_information18, hr_api.g_varchar2) or
222: nvl(pay_etp_shd_nd.g_old_rec.element_information15, hr_api.g_varchar2) <>
223: nvl(p_rec.element_information15, hr_api.g_varchar2) or
224: nvl(pay_etp_shd_nd.g_old_rec.element_information16, hr_api.g_varchar2) <>
225: nvl(p_rec.element_information16, hr_api.g_varchar2) or
226: nvl(pay_etp_shd_nd.g_old_rec.element_information17, hr_api.g_varchar2) <>
227: nvl(p_rec.element_information17, hr_api.g_varchar2) or
228: nvl(pay_etp_shd_nd.g_old_rec.element_information18, hr_api.g_varchar2) <>
229: nvl(p_rec.element_information18, hr_api.g_varchar2) or
230: nvl(pay_etp_shd_nd.g_old_rec.element_information19, hr_api.g_varchar2) <>
223: nvl(p_rec.element_information15, hr_api.g_varchar2) or
224: nvl(pay_etp_shd_nd.g_old_rec.element_information16, hr_api.g_varchar2) <>
225: nvl(p_rec.element_information16, hr_api.g_varchar2) or
226: nvl(pay_etp_shd_nd.g_old_rec.element_information17, hr_api.g_varchar2) <>
227: nvl(p_rec.element_information17, hr_api.g_varchar2) or
228: nvl(pay_etp_shd_nd.g_old_rec.element_information18, hr_api.g_varchar2) <>
229: nvl(p_rec.element_information18, hr_api.g_varchar2) or
230: nvl(pay_etp_shd_nd.g_old_rec.element_information19, hr_api.g_varchar2) <>
231: nvl(p_rec.element_information19, hr_api.g_varchar2) or
224: nvl(pay_etp_shd_nd.g_old_rec.element_information16, hr_api.g_varchar2) <>
225: nvl(p_rec.element_information16, hr_api.g_varchar2) or
226: nvl(pay_etp_shd_nd.g_old_rec.element_information17, hr_api.g_varchar2) <>
227: nvl(p_rec.element_information17, hr_api.g_varchar2) or
228: nvl(pay_etp_shd_nd.g_old_rec.element_information18, hr_api.g_varchar2) <>
229: nvl(p_rec.element_information18, hr_api.g_varchar2) or
230: nvl(pay_etp_shd_nd.g_old_rec.element_information19, hr_api.g_varchar2) <>
231: nvl(p_rec.element_information19, hr_api.g_varchar2) or
232: nvl(pay_etp_shd_nd.g_old_rec.element_information20, hr_api.g_varchar2) <>
225: nvl(p_rec.element_information16, hr_api.g_varchar2) or
226: nvl(pay_etp_shd_nd.g_old_rec.element_information17, hr_api.g_varchar2) <>
227: nvl(p_rec.element_information17, hr_api.g_varchar2) or
228: nvl(pay_etp_shd_nd.g_old_rec.element_information18, hr_api.g_varchar2) <>
229: nvl(p_rec.element_information18, hr_api.g_varchar2) or
230: nvl(pay_etp_shd_nd.g_old_rec.element_information19, hr_api.g_varchar2) <>
231: nvl(p_rec.element_information19, hr_api.g_varchar2) or
232: nvl(pay_etp_shd_nd.g_old_rec.element_information20, hr_api.g_varchar2) <>
233: nvl(p_rec.element_information20, hr_api.g_varchar2) ))
226: nvl(pay_etp_shd_nd.g_old_rec.element_information17, hr_api.g_varchar2) <>
227: nvl(p_rec.element_information17, hr_api.g_varchar2) or
228: nvl(pay_etp_shd_nd.g_old_rec.element_information18, hr_api.g_varchar2) <>
229: nvl(p_rec.element_information18, hr_api.g_varchar2) or
230: nvl(pay_etp_shd_nd.g_old_rec.element_information19, hr_api.g_varchar2) <>
231: nvl(p_rec.element_information19, hr_api.g_varchar2) or
232: nvl(pay_etp_shd_nd.g_old_rec.element_information20, hr_api.g_varchar2) <>
233: nvl(p_rec.element_information20, hr_api.g_varchar2) ))
234: or (p_rec.element_type_id is null) then
227: nvl(p_rec.element_information17, hr_api.g_varchar2) or
228: nvl(pay_etp_shd_nd.g_old_rec.element_information18, hr_api.g_varchar2) <>
229: nvl(p_rec.element_information18, hr_api.g_varchar2) or
230: nvl(pay_etp_shd_nd.g_old_rec.element_information19, hr_api.g_varchar2) <>
231: nvl(p_rec.element_information19, hr_api.g_varchar2) or
232: nvl(pay_etp_shd_nd.g_old_rec.element_information20, hr_api.g_varchar2) <>
233: nvl(p_rec.element_information20, hr_api.g_varchar2) ))
234: or (p_rec.element_type_id is null) then
235: --
228: nvl(pay_etp_shd_nd.g_old_rec.element_information18, hr_api.g_varchar2) <>
229: nvl(p_rec.element_information18, hr_api.g_varchar2) or
230: nvl(pay_etp_shd_nd.g_old_rec.element_information19, hr_api.g_varchar2) <>
231: nvl(p_rec.element_information19, hr_api.g_varchar2) or
232: nvl(pay_etp_shd_nd.g_old_rec.element_information20, hr_api.g_varchar2) <>
233: nvl(p_rec.element_information20, hr_api.g_varchar2) ))
234: or (p_rec.element_type_id is null) then
235: --
236: -- Only execute the validation if absolutely necessary:
229: nvl(p_rec.element_information18, hr_api.g_varchar2) or
230: nvl(pay_etp_shd_nd.g_old_rec.element_information19, hr_api.g_varchar2) <>
231: nvl(p_rec.element_information19, hr_api.g_varchar2) or
232: nvl(pay_etp_shd_nd.g_old_rec.element_information20, hr_api.g_varchar2) <>
233: nvl(p_rec.element_information20, hr_api.g_varchar2) ))
234: or (p_rec.element_type_id is null) then
235: --
236: -- Only execute the validation if absolutely necessary:
237: -- a) During update, the structure column value or any
326: begin
327: hr_utility.set_location('Entering:'||l_proc,10);
328: --
329: if ((p_rec.element_type_id is not null) and (
330: nvl(pay_etp_shd_nd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
332: nvl(pay_etp_shd_nd.g_old_rec.attribute1, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute1, hr_api.g_varchar2) or
334: nvl(pay_etp_shd_nd.g_old_rec.attribute2, hr_api.g_varchar2) <>
327: hr_utility.set_location('Entering:'||l_proc,10);
328: --
329: if ((p_rec.element_type_id is not null) and (
330: nvl(pay_etp_shd_nd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
332: nvl(pay_etp_shd_nd.g_old_rec.attribute1, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute1, hr_api.g_varchar2) or
334: nvl(pay_etp_shd_nd.g_old_rec.attribute2, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute2, hr_api.g_varchar2) or
328: --
329: if ((p_rec.element_type_id is not null) and (
330: nvl(pay_etp_shd_nd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
332: nvl(pay_etp_shd_nd.g_old_rec.attribute1, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute1, hr_api.g_varchar2) or
334: nvl(pay_etp_shd_nd.g_old_rec.attribute2, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute2, hr_api.g_varchar2) or
336: nvl(pay_etp_shd_nd.g_old_rec.attribute3, hr_api.g_varchar2) <>
329: if ((p_rec.element_type_id is not null) and (
330: nvl(pay_etp_shd_nd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
332: nvl(pay_etp_shd_nd.g_old_rec.attribute1, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute1, hr_api.g_varchar2) or
334: nvl(pay_etp_shd_nd.g_old_rec.attribute2, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute2, hr_api.g_varchar2) or
336: nvl(pay_etp_shd_nd.g_old_rec.attribute3, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute3, hr_api.g_varchar2) or
330: nvl(pay_etp_shd_nd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
332: nvl(pay_etp_shd_nd.g_old_rec.attribute1, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute1, hr_api.g_varchar2) or
334: nvl(pay_etp_shd_nd.g_old_rec.attribute2, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute2, hr_api.g_varchar2) or
336: nvl(pay_etp_shd_nd.g_old_rec.attribute3, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute3, hr_api.g_varchar2) or
338: nvl(pay_etp_shd_nd.g_old_rec.attribute4, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
332: nvl(pay_etp_shd_nd.g_old_rec.attribute1, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute1, hr_api.g_varchar2) or
334: nvl(pay_etp_shd_nd.g_old_rec.attribute2, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute2, hr_api.g_varchar2) or
336: nvl(pay_etp_shd_nd.g_old_rec.attribute3, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute3, hr_api.g_varchar2) or
338: nvl(pay_etp_shd_nd.g_old_rec.attribute4, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute4, hr_api.g_varchar2) or
332: nvl(pay_etp_shd_nd.g_old_rec.attribute1, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute1, hr_api.g_varchar2) or
334: nvl(pay_etp_shd_nd.g_old_rec.attribute2, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute2, hr_api.g_varchar2) or
336: nvl(pay_etp_shd_nd.g_old_rec.attribute3, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute3, hr_api.g_varchar2) or
338: nvl(pay_etp_shd_nd.g_old_rec.attribute4, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute4, hr_api.g_varchar2) or
340: nvl(pay_etp_shd_nd.g_old_rec.attribute5, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute1, hr_api.g_varchar2) or
334: nvl(pay_etp_shd_nd.g_old_rec.attribute2, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute2, hr_api.g_varchar2) or
336: nvl(pay_etp_shd_nd.g_old_rec.attribute3, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute3, hr_api.g_varchar2) or
338: nvl(pay_etp_shd_nd.g_old_rec.attribute4, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute4, hr_api.g_varchar2) or
340: nvl(pay_etp_shd_nd.g_old_rec.attribute5, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute5, hr_api.g_varchar2) or
334: nvl(pay_etp_shd_nd.g_old_rec.attribute2, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute2, hr_api.g_varchar2) or
336: nvl(pay_etp_shd_nd.g_old_rec.attribute3, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute3, hr_api.g_varchar2) or
338: nvl(pay_etp_shd_nd.g_old_rec.attribute4, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute4, hr_api.g_varchar2) or
340: nvl(pay_etp_shd_nd.g_old_rec.attribute5, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute5, hr_api.g_varchar2) or
342: nvl(pay_etp_shd_nd.g_old_rec.attribute6, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute2, hr_api.g_varchar2) or
336: nvl(pay_etp_shd_nd.g_old_rec.attribute3, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute3, hr_api.g_varchar2) or
338: nvl(pay_etp_shd_nd.g_old_rec.attribute4, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute4, hr_api.g_varchar2) or
340: nvl(pay_etp_shd_nd.g_old_rec.attribute5, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute5, hr_api.g_varchar2) or
342: nvl(pay_etp_shd_nd.g_old_rec.attribute6, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute6, hr_api.g_varchar2) or
336: nvl(pay_etp_shd_nd.g_old_rec.attribute3, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute3, hr_api.g_varchar2) or
338: nvl(pay_etp_shd_nd.g_old_rec.attribute4, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute4, hr_api.g_varchar2) or
340: nvl(pay_etp_shd_nd.g_old_rec.attribute5, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute5, hr_api.g_varchar2) or
342: nvl(pay_etp_shd_nd.g_old_rec.attribute6, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute6, hr_api.g_varchar2) or
344: nvl(pay_etp_shd_nd.g_old_rec.attribute7, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute3, hr_api.g_varchar2) or
338: nvl(pay_etp_shd_nd.g_old_rec.attribute4, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute4, hr_api.g_varchar2) or
340: nvl(pay_etp_shd_nd.g_old_rec.attribute5, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute5, hr_api.g_varchar2) or
342: nvl(pay_etp_shd_nd.g_old_rec.attribute6, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute6, hr_api.g_varchar2) or
344: nvl(pay_etp_shd_nd.g_old_rec.attribute7, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute7, hr_api.g_varchar2) or
338: nvl(pay_etp_shd_nd.g_old_rec.attribute4, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute4, hr_api.g_varchar2) or
340: nvl(pay_etp_shd_nd.g_old_rec.attribute5, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute5, hr_api.g_varchar2) or
342: nvl(pay_etp_shd_nd.g_old_rec.attribute6, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute6, hr_api.g_varchar2) or
344: nvl(pay_etp_shd_nd.g_old_rec.attribute7, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute7, hr_api.g_varchar2) or
346: nvl(pay_etp_shd_nd.g_old_rec.attribute8, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute4, hr_api.g_varchar2) or
340: nvl(pay_etp_shd_nd.g_old_rec.attribute5, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute5, hr_api.g_varchar2) or
342: nvl(pay_etp_shd_nd.g_old_rec.attribute6, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute6, hr_api.g_varchar2) or
344: nvl(pay_etp_shd_nd.g_old_rec.attribute7, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute7, hr_api.g_varchar2) or
346: nvl(pay_etp_shd_nd.g_old_rec.attribute8, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute8, hr_api.g_varchar2) or
340: nvl(pay_etp_shd_nd.g_old_rec.attribute5, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute5, hr_api.g_varchar2) or
342: nvl(pay_etp_shd_nd.g_old_rec.attribute6, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute6, hr_api.g_varchar2) or
344: nvl(pay_etp_shd_nd.g_old_rec.attribute7, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute7, hr_api.g_varchar2) or
346: nvl(pay_etp_shd_nd.g_old_rec.attribute8, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute8, hr_api.g_varchar2) or
348: nvl(pay_etp_shd_nd.g_old_rec.attribute9, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute5, hr_api.g_varchar2) or
342: nvl(pay_etp_shd_nd.g_old_rec.attribute6, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute6, hr_api.g_varchar2) or
344: nvl(pay_etp_shd_nd.g_old_rec.attribute7, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute7, hr_api.g_varchar2) or
346: nvl(pay_etp_shd_nd.g_old_rec.attribute8, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute8, hr_api.g_varchar2) or
348: nvl(pay_etp_shd_nd.g_old_rec.attribute9, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute9, hr_api.g_varchar2) or
342: nvl(pay_etp_shd_nd.g_old_rec.attribute6, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute6, hr_api.g_varchar2) or
344: nvl(pay_etp_shd_nd.g_old_rec.attribute7, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute7, hr_api.g_varchar2) or
346: nvl(pay_etp_shd_nd.g_old_rec.attribute8, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute8, hr_api.g_varchar2) or
348: nvl(pay_etp_shd_nd.g_old_rec.attribute9, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute9, hr_api.g_varchar2) or
350: nvl(pay_etp_shd_nd.g_old_rec.attribute10, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute6, hr_api.g_varchar2) or
344: nvl(pay_etp_shd_nd.g_old_rec.attribute7, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute7, hr_api.g_varchar2) or
346: nvl(pay_etp_shd_nd.g_old_rec.attribute8, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute8, hr_api.g_varchar2) or
348: nvl(pay_etp_shd_nd.g_old_rec.attribute9, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute9, hr_api.g_varchar2) or
350: nvl(pay_etp_shd_nd.g_old_rec.attribute10, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute10, hr_api.g_varchar2) or
344: nvl(pay_etp_shd_nd.g_old_rec.attribute7, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute7, hr_api.g_varchar2) or
346: nvl(pay_etp_shd_nd.g_old_rec.attribute8, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute8, hr_api.g_varchar2) or
348: nvl(pay_etp_shd_nd.g_old_rec.attribute9, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute9, hr_api.g_varchar2) or
350: nvl(pay_etp_shd_nd.g_old_rec.attribute10, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute10, hr_api.g_varchar2) or
352: nvl(pay_etp_shd_nd.g_old_rec.attribute11, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute7, hr_api.g_varchar2) or
346: nvl(pay_etp_shd_nd.g_old_rec.attribute8, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute8, hr_api.g_varchar2) or
348: nvl(pay_etp_shd_nd.g_old_rec.attribute9, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute9, hr_api.g_varchar2) or
350: nvl(pay_etp_shd_nd.g_old_rec.attribute10, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute10, hr_api.g_varchar2) or
352: nvl(pay_etp_shd_nd.g_old_rec.attribute11, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute11, hr_api.g_varchar2) or
346: nvl(pay_etp_shd_nd.g_old_rec.attribute8, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute8, hr_api.g_varchar2) or
348: nvl(pay_etp_shd_nd.g_old_rec.attribute9, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute9, hr_api.g_varchar2) or
350: nvl(pay_etp_shd_nd.g_old_rec.attribute10, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute10, hr_api.g_varchar2) or
352: nvl(pay_etp_shd_nd.g_old_rec.attribute11, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute11, hr_api.g_varchar2) or
354: nvl(pay_etp_shd_nd.g_old_rec.attribute12, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute8, hr_api.g_varchar2) or
348: nvl(pay_etp_shd_nd.g_old_rec.attribute9, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute9, hr_api.g_varchar2) or
350: nvl(pay_etp_shd_nd.g_old_rec.attribute10, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute10, hr_api.g_varchar2) or
352: nvl(pay_etp_shd_nd.g_old_rec.attribute11, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute11, hr_api.g_varchar2) or
354: nvl(pay_etp_shd_nd.g_old_rec.attribute12, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute12, hr_api.g_varchar2) or
348: nvl(pay_etp_shd_nd.g_old_rec.attribute9, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute9, hr_api.g_varchar2) or
350: nvl(pay_etp_shd_nd.g_old_rec.attribute10, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute10, hr_api.g_varchar2) or
352: nvl(pay_etp_shd_nd.g_old_rec.attribute11, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute11, hr_api.g_varchar2) or
354: nvl(pay_etp_shd_nd.g_old_rec.attribute12, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute12, hr_api.g_varchar2) or
356: nvl(pay_etp_shd_nd.g_old_rec.attribute13, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute9, hr_api.g_varchar2) or
350: nvl(pay_etp_shd_nd.g_old_rec.attribute10, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute10, hr_api.g_varchar2) or
352: nvl(pay_etp_shd_nd.g_old_rec.attribute11, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute11, hr_api.g_varchar2) or
354: nvl(pay_etp_shd_nd.g_old_rec.attribute12, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute12, hr_api.g_varchar2) or
356: nvl(pay_etp_shd_nd.g_old_rec.attribute13, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute13, hr_api.g_varchar2) or
350: nvl(pay_etp_shd_nd.g_old_rec.attribute10, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute10, hr_api.g_varchar2) or
352: nvl(pay_etp_shd_nd.g_old_rec.attribute11, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute11, hr_api.g_varchar2) or
354: nvl(pay_etp_shd_nd.g_old_rec.attribute12, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute12, hr_api.g_varchar2) or
356: nvl(pay_etp_shd_nd.g_old_rec.attribute13, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute13, hr_api.g_varchar2) or
358: nvl(pay_etp_shd_nd.g_old_rec.attribute14, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute10, hr_api.g_varchar2) or
352: nvl(pay_etp_shd_nd.g_old_rec.attribute11, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute11, hr_api.g_varchar2) or
354: nvl(pay_etp_shd_nd.g_old_rec.attribute12, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute12, hr_api.g_varchar2) or
356: nvl(pay_etp_shd_nd.g_old_rec.attribute13, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute13, hr_api.g_varchar2) or
358: nvl(pay_etp_shd_nd.g_old_rec.attribute14, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute14, hr_api.g_varchar2) or
352: nvl(pay_etp_shd_nd.g_old_rec.attribute11, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute11, hr_api.g_varchar2) or
354: nvl(pay_etp_shd_nd.g_old_rec.attribute12, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute12, hr_api.g_varchar2) or
356: nvl(pay_etp_shd_nd.g_old_rec.attribute13, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute13, hr_api.g_varchar2) or
358: nvl(pay_etp_shd_nd.g_old_rec.attribute14, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute14, hr_api.g_varchar2) or
360: nvl(pay_etp_shd_nd.g_old_rec.attribute15, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute11, hr_api.g_varchar2) or
354: nvl(pay_etp_shd_nd.g_old_rec.attribute12, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute12, hr_api.g_varchar2) or
356: nvl(pay_etp_shd_nd.g_old_rec.attribute13, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute13, hr_api.g_varchar2) or
358: nvl(pay_etp_shd_nd.g_old_rec.attribute14, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute14, hr_api.g_varchar2) or
360: nvl(pay_etp_shd_nd.g_old_rec.attribute15, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute15, hr_api.g_varchar2) or
354: nvl(pay_etp_shd_nd.g_old_rec.attribute12, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute12, hr_api.g_varchar2) or
356: nvl(pay_etp_shd_nd.g_old_rec.attribute13, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute13, hr_api.g_varchar2) or
358: nvl(pay_etp_shd_nd.g_old_rec.attribute14, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute14, hr_api.g_varchar2) or
360: nvl(pay_etp_shd_nd.g_old_rec.attribute15, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute15, hr_api.g_varchar2) or
362: nvl(pay_etp_shd_nd.g_old_rec.attribute16, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute12, hr_api.g_varchar2) or
356: nvl(pay_etp_shd_nd.g_old_rec.attribute13, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute13, hr_api.g_varchar2) or
358: nvl(pay_etp_shd_nd.g_old_rec.attribute14, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute14, hr_api.g_varchar2) or
360: nvl(pay_etp_shd_nd.g_old_rec.attribute15, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute15, hr_api.g_varchar2) or
362: nvl(pay_etp_shd_nd.g_old_rec.attribute16, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute16, hr_api.g_varchar2) or
356: nvl(pay_etp_shd_nd.g_old_rec.attribute13, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute13, hr_api.g_varchar2) or
358: nvl(pay_etp_shd_nd.g_old_rec.attribute14, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute14, hr_api.g_varchar2) or
360: nvl(pay_etp_shd_nd.g_old_rec.attribute15, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute15, hr_api.g_varchar2) or
362: nvl(pay_etp_shd_nd.g_old_rec.attribute16, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute16, hr_api.g_varchar2) or
364: nvl(pay_etp_shd_nd.g_old_rec.attribute17, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute13, hr_api.g_varchar2) or
358: nvl(pay_etp_shd_nd.g_old_rec.attribute14, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute14, hr_api.g_varchar2) or
360: nvl(pay_etp_shd_nd.g_old_rec.attribute15, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute15, hr_api.g_varchar2) or
362: nvl(pay_etp_shd_nd.g_old_rec.attribute16, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute16, hr_api.g_varchar2) or
364: nvl(pay_etp_shd_nd.g_old_rec.attribute17, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute17, hr_api.g_varchar2) or
358: nvl(pay_etp_shd_nd.g_old_rec.attribute14, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute14, hr_api.g_varchar2) or
360: nvl(pay_etp_shd_nd.g_old_rec.attribute15, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute15, hr_api.g_varchar2) or
362: nvl(pay_etp_shd_nd.g_old_rec.attribute16, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute16, hr_api.g_varchar2) or
364: nvl(pay_etp_shd_nd.g_old_rec.attribute17, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute17, hr_api.g_varchar2) or
366: nvl(pay_etp_shd_nd.g_old_rec.attribute18, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute14, hr_api.g_varchar2) or
360: nvl(pay_etp_shd_nd.g_old_rec.attribute15, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute15, hr_api.g_varchar2) or
362: nvl(pay_etp_shd_nd.g_old_rec.attribute16, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute16, hr_api.g_varchar2) or
364: nvl(pay_etp_shd_nd.g_old_rec.attribute17, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute17, hr_api.g_varchar2) or
366: nvl(pay_etp_shd_nd.g_old_rec.attribute18, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute18, hr_api.g_varchar2) or
360: nvl(pay_etp_shd_nd.g_old_rec.attribute15, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute15, hr_api.g_varchar2) or
362: nvl(pay_etp_shd_nd.g_old_rec.attribute16, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute16, hr_api.g_varchar2) or
364: nvl(pay_etp_shd_nd.g_old_rec.attribute17, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute17, hr_api.g_varchar2) or
366: nvl(pay_etp_shd_nd.g_old_rec.attribute18, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute18, hr_api.g_varchar2) or
368: nvl(pay_etp_shd_nd.g_old_rec.attribute19, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute15, hr_api.g_varchar2) or
362: nvl(pay_etp_shd_nd.g_old_rec.attribute16, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute16, hr_api.g_varchar2) or
364: nvl(pay_etp_shd_nd.g_old_rec.attribute17, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute17, hr_api.g_varchar2) or
366: nvl(pay_etp_shd_nd.g_old_rec.attribute18, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute18, hr_api.g_varchar2) or
368: nvl(pay_etp_shd_nd.g_old_rec.attribute19, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute19, hr_api.g_varchar2) or
362: nvl(pay_etp_shd_nd.g_old_rec.attribute16, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute16, hr_api.g_varchar2) or
364: nvl(pay_etp_shd_nd.g_old_rec.attribute17, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute17, hr_api.g_varchar2) or
366: nvl(pay_etp_shd_nd.g_old_rec.attribute18, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute18, hr_api.g_varchar2) or
368: nvl(pay_etp_shd_nd.g_old_rec.attribute19, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute19, hr_api.g_varchar2) or
370: nvl(pay_etp_shd_nd.g_old_rec.attribute20, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute16, hr_api.g_varchar2) or
364: nvl(pay_etp_shd_nd.g_old_rec.attribute17, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute17, hr_api.g_varchar2) or
366: nvl(pay_etp_shd_nd.g_old_rec.attribute18, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute18, hr_api.g_varchar2) or
368: nvl(pay_etp_shd_nd.g_old_rec.attribute19, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute19, hr_api.g_varchar2) or
370: nvl(pay_etp_shd_nd.g_old_rec.attribute20, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
364: nvl(pay_etp_shd_nd.g_old_rec.attribute17, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute17, hr_api.g_varchar2) or
366: nvl(pay_etp_shd_nd.g_old_rec.attribute18, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute18, hr_api.g_varchar2) or
368: nvl(pay_etp_shd_nd.g_old_rec.attribute19, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute19, hr_api.g_varchar2) or
370: nvl(pay_etp_shd_nd.g_old_rec.attribute20, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
372: or (p_rec.element_type_id is null) then
365: nvl(p_rec.attribute17, hr_api.g_varchar2) or
366: nvl(pay_etp_shd_nd.g_old_rec.attribute18, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute18, hr_api.g_varchar2) or
368: nvl(pay_etp_shd_nd.g_old_rec.attribute19, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute19, hr_api.g_varchar2) or
370: nvl(pay_etp_shd_nd.g_old_rec.attribute20, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
372: or (p_rec.element_type_id is null) then
373: --
366: nvl(pay_etp_shd_nd.g_old_rec.attribute18, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute18, hr_api.g_varchar2) or
368: nvl(pay_etp_shd_nd.g_old_rec.attribute19, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute19, hr_api.g_varchar2) or
370: nvl(pay_etp_shd_nd.g_old_rec.attribute20, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
372: or (p_rec.element_type_id is null) then
373: --
374: -- Only execute the validation if absolutely necessary:
367: nvl(p_rec.attribute18, hr_api.g_varchar2) or
368: nvl(pay_etp_shd_nd.g_old_rec.attribute19, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute19, hr_api.g_varchar2) or
370: nvl(pay_etp_shd_nd.g_old_rec.attribute20, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
372: or (p_rec.element_type_id is null) then
373: --
374: -- Only execute the validation if absolutely necessary:
375: -- a) During update, the structure column value or any
519: Begin
520: --
521: -- Ensure that the p_datetrack_mode argument is not null
522: --
523: hr_api.mandatory_arg_error
524: (p_api_name => l_proc
525: ,p_argument => 'datetrack_mode'
526: ,p_argument_value => p_datetrack_mode
527: );
529: -- Mode will be valid, as this is checked at the start of the upd.
530: --
531: -- Ensure the arguments are not null
532: --
533: hr_api.mandatory_arg_error
534: (p_api_name => l_proc
535: ,p_argument => 'validation_start_date'
536: ,p_argument_value => p_validation_start_date
537: );
535: ,p_argument => 'validation_start_date'
536: ,p_argument_value => p_validation_start_date
537: );
538: --
539: hr_api.mandatory_arg_error
540: (p_api_name => l_proc
541: ,p_argument => 'validation_end_date'
542: ,p_argument_value => p_validation_end_date
543: );
603: Begin
604: --
605: -- Ensure that the p_datetrack_mode argument is not null
606: --
607: hr_api.mandatory_arg_error
608: (p_api_name => l_proc
609: ,p_argument => 'datetrack_mode'
610: ,p_argument_value => p_datetrack_mode
611: );
612: --
613: -- Only perform the validation if the datetrack mode is either
614: -- DELETE or ZAP
615: --
616: If (p_datetrack_mode = hr_api.g_delete or
617: p_datetrack_mode = hr_api.g_zap) then
618: --
619: --
620: -- Ensure the arguments are not null
613: -- Only perform the validation if the datetrack mode is either
614: -- DELETE or ZAP
615: --
616: If (p_datetrack_mode = hr_api.g_delete or
617: p_datetrack_mode = hr_api.g_zap) then
618: --
619: --
620: -- Ensure the arguments are not null
621: --
618: --
619: --
620: -- Ensure the arguments are not null
621: --
622: hr_api.mandatory_arg_error
623: (p_api_name => l_proc
624: ,p_argument => 'validation_start_date'
625: ,p_argument_value => p_validation_start_date
626: );
624: ,p_argument => 'validation_start_date'
625: ,p_argument_value => p_validation_start_date
626: );
627: --
628: hr_api.mandatory_arg_error
629: (p_api_name => l_proc
630: ,p_argument => 'validation_end_date'
631: ,p_argument_value => p_validation_end_date
632: );
630: ,p_argument => 'validation_end_date'
631: ,p_argument_value => p_validation_end_date
632: );
633: --
634: hr_api.mandatory_arg_error
635: (p_api_name => l_proc
636: ,p_argument => 'element_type_id'
637: ,p_argument_value => p_element_type_id
638: );
759: select '1'
760: from hr_all_organization_units
761: where business_group_id = p_business_group_id;
762: -- and p_effective_date between date_from
763: -- and nvl(date_to, hr_api.g_eot);
764: --
765: Begin
766: hr_utility.set_location('Entering:'||l_proc, 5);
767: --
993: Cursor c_leg_rule_currency
994: is
995: select rule_mode
996: from pay_legislation_rules
997: where legislation_code = hr_api.return_legislation_code
998: (p_business_group_id)
999: and rule_type = 'DC';
1000: --
1001: Begin
1183: --
1184: Begin
1185: hr_utility.set_location('Entering:'||l_proc, 5);
1186: --
1187: If hr_api.not_exists_in_hr_lookups
1188: (p_effective_date
1189: ,'YES_NO'
1190: ,p_addl_entry_allowed_flag) Then
1191: --
1250: --
1251: Begin
1252: hr_utility.set_location('Entering:'||l_proc, 5);
1253: --
1254: If hr_api.not_exists_in_hr_lookups
1255: (p_effective_date
1256: ,'YES_NO'
1257: ,p_adjustment_only_flag) Then
1258: --
1262: fnd_message.raise_error;
1263: --
1264: End If;
1265: --
1266: If hr_api.not_exists_in_hr_lookups
1267: (p_effective_date
1268: ,'YES_NO'
1269: ,p_closed_for_entry_flag) Then
1270: --
1441: --
1442: Begin
1443: hr_utility.set_location('Entering:'||l_proc, 5);
1444: --
1445: If hr_api.not_exists_in_hr_lookups
1446: (p_effective_date
1447: ,'YES_NO'
1448: ,p_multiple_entries_allowed_flg) Then
1449: --
1538: --
1539: Begin
1540: hr_utility.set_location('Entering:'||l_proc, 5);
1541: --
1542: If hr_api.not_exists_in_hr_lookups
1543: (p_effective_date
1544: ,'YES_NO'
1545: ,p_process_in_run_flag) Then
1546: --
1550: fnd_message.raise_error;
1551: --
1552: End If;
1553: --
1554: If hr_api.not_exists_in_hr_lookups
1555: (p_effective_date
1556: ,'YES_NO'
1557: ,p_indirect_only_flag) Then
1558: --
1562: fnd_message.raise_error;
1563: --
1564: End If;
1565: --
1566: If hr_api.not_exists_in_hr_lookups
1567: (p_effective_date
1568: ,'YES_NO'
1569: ,p_multiply_value_flag) Then
1570: --
1574: fnd_message.raise_error;
1575: --
1576: End If;
1577: --
1578: If hr_api.not_exists_in_hr_lookups
1579: (p_effective_date
1580: ,'TERMINATION_RULE'
1581: ,p_post_termination_rule) Then
1582: --
1586: fnd_message.raise_error;
1587: --
1588: End If;
1589: --
1590: If hr_api.not_exists_in_hr_lookups
1591: (p_effective_date
1592: ,'YES_NO'
1593: ,p_once_each_period_flag) Then
1594: --
1733: --
1734: Begin
1735: hr_utility.set_location('Entering:'||l_proc, 5);
1736: --
1737: If hr_api.not_exists_in_hr_lookups
1738: (p_effective_date
1739: ,'PROCESSING_TYPE'
1740: ,p_processing_type) Then
1741: --
1797: --
1798: Begin
1799: hr_utility.set_location('Entering:'||l_proc, 5);
1800: --
1801: If hr_api.not_exists_in_hr_lookups
1802: (p_effective_date
1803: ,'YES_NO'
1804: ,p_standard_link_flag) Then
1805: --
1871: --
1872: Begin
1873: hr_utility.set_location('Entering:'||l_proc, 5);
1874: --
1875: If nvl(p_qualifying_age,hr_api.g_number) <> hr_api.g_number Then
1876: If (sign(p_qualifying_age) = -1) or (p_qualifying_age not between 0 and 99)
1877: then
1878: --
1879: fnd_message.set_name('PAY','PAY_33096_QUALI_AGE_CHECK');
1879: fnd_message.set_name('PAY','PAY_33096_QUALI_AGE_CHECK');
1880: fnd_message.raise_error;
1881: --
1882: End If;
1883: Elsif nvl(p_qualifying_length_of_service,hr_api.g_number) <> hr_api.g_number
1884: then
1885: If (sign(p_qualifying_length_of_service) = -1) Then
1886: --
1887: fnd_message.set_name('PAY','PAY_34143_QUALI_LOS_VLDTN');
1888: fnd_message.raise_error;
1889: --
1890: End If;
1891: --
1892: If nvl(p_qualifying_units,hr_api.g_varchar2) = hr_api.g_varchar2 Then
1893: --
1894: fnd_message.set_name('PAY','PAY_34137_QUALI_FACTORS_VLDTN');
1895: fnd_message.raise_error;
1896: --
1895: fnd_message.raise_error;
1896: --
1897: Else
1898: --
1899: If hr_api.not_exists_in_hr_lookups
1900: (p_effective_date
1901: ,'QUALIFYING_UNITS'
1902: ,p_qualifying_units) Then
1903: --
1957: --
1958: Begin
1959: hr_utility.set_location('Entering:'||l_proc, 5);
1960: --
1961: If hr_api.not_exists_in_hr_lookups
1962: (p_effective_date
1963: ,'YES_NO'
1964: ,nvl(p_third_party_pay_only_flag,'N')) Then
1965: --
1970: --
1971: End If;
1972: If p_element_type_id is not null and
1973: (p_third_party_pay_only_flag <>
1974: nvl(pay_etp_shd_nd.g_old_rec.third_party_pay_only_flag,hr_api.g_varchar2))
1975: Then
1976: --
1977: If pay_element_types_pkg.element_entries_exist
1978: (p_element_type_id
2046: --
2047: Begin
2048: hr_utility.set_location('Entering:'||l_proc, 5);
2049: --
2050: If nvl(p_iterative_formula_id,hr_api.g_number) <> hr_api.g_number Then
2051: If not (dt_api.rows_exist
2052: (p_base_table_name => 'FF_FORMULAS_F'
2053: ,p_base_key_column => 'FORMULA_ID'
2054: ,p_base_key_value => p_iterative_formula_id
2063: --
2064: End If;
2065: End If;
2066: --
2067: If hr_api.not_exists_in_hr_lookups
2068: (p_effective_date
2069: ,'YES_NO'
2070: ,nvl(p_iterative_flag,'N')) Then
2071: --
2075: fnd_message.raise_error;
2076: --
2077: End If;
2078: --
2079: If hr_api.not_exists_in_hr_lookups
2080: (p_effective_date
2081: ,'YES_NO'
2082: ,nvl(p_grossup_flag,'N')) Then
2083: --
2167: --
2168: Begin
2169: hr_utility.set_location('Entering:'||l_proc, 5);
2170: --
2171: If nvl(p_retro_summ_ele_id,hr_api.g_number) <> hr_api.g_number Then
2172: If not (dt_api.rows_exist
2173: (p_base_table_name => 'PAY_ELEMENT_TYPES_F'
2174: ,p_base_key_column => 'ELEMENT_TYPE_ID'
2175: ,p_base_key_value => p_retro_summ_ele_id
2184: --
2185: End If;
2186: End If;
2187: --
2188: If nvl(p_proration_formula_id,hr_api.g_number) <> hr_api.g_number Then
2189: If not (dt_api.rows_exist
2190: (p_base_table_name => 'FF_FORMULAS_F'
2191: ,p_base_key_column => 'FORMULA_ID'
2192: ,p_base_key_value => p_proration_formula_id
2201: --
2202: End If;
2203: End If;
2204: --
2205: If nvl(p_proration_group_id,hr_api.g_number) <> hr_api.g_number Then
2206: --
2207: Open c_chk_event_group_id(p_proration_group_id);
2208: Fetch c_chk_event_group_id into l_exists, p_event_group_type;
2209: If c_chk_event_group_id%notfound Then
2224: Close c_chk_event_group_id;
2225: --
2226: End If;
2227: --
2228: If nvl(p_recalc_event_group_id,hr_api.g_number) <> hr_api.g_number Then
2229: --
2230: Open c_chk_event_group_id(p_recalc_event_group_id);
2231: Fetch c_chk_event_group_id into l_exists, p_event_group_type;
2232: If c_chk_event_group_id%notfound Then
2323: --
2324: Begin
2325: --
2326: hr_utility.set_location('Entering:'||l_proc, 5);
2327: /* If hr_api.not_exists_in_hr_lookups
2328: (p_effective_date
2329: ,'PAY_TIME_DEFINITION_TYPE'
2330: ,p_time_definition_type) Then
2331: --
2749: NOT IN ('GENERIC','STARTUP') THEN
2750: --
2751: -- Validate Important Attributes
2752: --
2753: hr_api.validate_bus_grp_id
2754: (p_business_group_id => p_rec.business_group_id
2755: ,p_associated_column1 => pay_etp_shd_nd.g_tab_nam
2756: || '.BUSINESS_GROUP_ID');
2757: --
2924: NOT IN ('GENERIC','STARTUP') THEN
2925: --
2926: -- Validate Important Attributes
2927: --
2928: hr_api.validate_bus_grp_id
2929: (p_business_group_id => p_rec.business_group_id
2930: ,p_associated_column1 => pay_etp_shd_nd.g_tab_nam
2931: || '.BUSINESS_GROUP_ID');
2932: --