44: hr_utility.set_location('Entering:'|| l_proc, 10);
45: --
46: -- Ensure that all the mandatory parameter are not null
47: --
48: hr_api.mandatory_arg_error
49: (p_api_name => l_proc
50: ,p_argument =>'vehicle_repository_id'
51: ,p_argument_value => p_vehicle_repository_id
52: );
70: CLOSE csr_sec_grp;
71: --
72: -- Set the security_group_id in CLIENT_INFO
73: --
74: hr_api.set_security_group_id
75: (p_security_group_id => l_security_group_id
76: );
77: --
78: -- Set the sessions legislation context in HR_SESSION_DATA
76: );
77: --
78: -- Set the sessions legislation context in HR_SESSION_DATA
79: --
80: hr_api.set_legislation_context(l_legislation_code);
81: END IF;
82: --
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: --
113: hr_utility.set_location('Entering:'|| l_proc, 10);
114: --
115: -- Ensure that all the mandatory parameter are not null
116: --
117: hr_api.mandatory_arg_error
118: (p_api_name => l_proc
119: ,p_argument => 'vehicle_repository_id'
120: ,p_argument_value => p_vehicle_repository_id
121: );
119: ,p_argument => 'vehicle_repository_id'
120: ,p_argument_value => p_vehicle_repository_id
121: );
122: --
123: IF ( nvl(pqp_vre_bus.g_vehicle_repository_id, hr_api.g_number)
124: = p_vehicle_repository_id) THEN
125: --
126: -- The legislation code has already been found with a previous
127: -- call to this function. Just return the value in the global
195: BEGIN
196: hr_utility.set_location('Entering:'||l_proc,10);
197: --
198: IF ((p_rec.vehicle_repository_id is not null) and (
199: nvl(pqp_vre_shd.g_old_rec.vre_information_category, hr_api.g_varchar2) <>
200: nvl(p_rec.vre_information_category, hr_api.g_varchar2) or
201: nvl(pqp_vre_shd.g_old_rec.vre_information1, hr_api.g_varchar2) <>
202: nvl(p_rec.vre_information1, hr_api.g_varchar2) or
203: nvl(pqp_vre_shd.g_old_rec.vre_information2, hr_api.g_varchar2) <>
196: hr_utility.set_location('Entering:'||l_proc,10);
197: --
198: IF ((p_rec.vehicle_repository_id is not null) and (
199: nvl(pqp_vre_shd.g_old_rec.vre_information_category, hr_api.g_varchar2) <>
200: nvl(p_rec.vre_information_category, hr_api.g_varchar2) or
201: nvl(pqp_vre_shd.g_old_rec.vre_information1, hr_api.g_varchar2) <>
202: nvl(p_rec.vre_information1, hr_api.g_varchar2) or
203: nvl(pqp_vre_shd.g_old_rec.vre_information2, hr_api.g_varchar2) <>
204: nvl(p_rec.vre_information2, hr_api.g_varchar2) or
197: --
198: IF ((p_rec.vehicle_repository_id is not null) and (
199: nvl(pqp_vre_shd.g_old_rec.vre_information_category, hr_api.g_varchar2) <>
200: nvl(p_rec.vre_information_category, hr_api.g_varchar2) or
201: nvl(pqp_vre_shd.g_old_rec.vre_information1, hr_api.g_varchar2) <>
202: nvl(p_rec.vre_information1, hr_api.g_varchar2) or
203: nvl(pqp_vre_shd.g_old_rec.vre_information2, hr_api.g_varchar2) <>
204: nvl(p_rec.vre_information2, hr_api.g_varchar2) or
205: nvl(pqp_vre_shd.g_old_rec.vre_information3, hr_api.g_varchar2) <>
198: IF ((p_rec.vehicle_repository_id is not null) and (
199: nvl(pqp_vre_shd.g_old_rec.vre_information_category, hr_api.g_varchar2) <>
200: nvl(p_rec.vre_information_category, hr_api.g_varchar2) or
201: nvl(pqp_vre_shd.g_old_rec.vre_information1, hr_api.g_varchar2) <>
202: nvl(p_rec.vre_information1, hr_api.g_varchar2) or
203: nvl(pqp_vre_shd.g_old_rec.vre_information2, hr_api.g_varchar2) <>
204: nvl(p_rec.vre_information2, hr_api.g_varchar2) or
205: nvl(pqp_vre_shd.g_old_rec.vre_information3, hr_api.g_varchar2) <>
206: nvl(p_rec.vre_information3, hr_api.g_varchar2) or
199: nvl(pqp_vre_shd.g_old_rec.vre_information_category, hr_api.g_varchar2) <>
200: nvl(p_rec.vre_information_category, hr_api.g_varchar2) or
201: nvl(pqp_vre_shd.g_old_rec.vre_information1, hr_api.g_varchar2) <>
202: nvl(p_rec.vre_information1, hr_api.g_varchar2) or
203: nvl(pqp_vre_shd.g_old_rec.vre_information2, hr_api.g_varchar2) <>
204: nvl(p_rec.vre_information2, hr_api.g_varchar2) or
205: nvl(pqp_vre_shd.g_old_rec.vre_information3, hr_api.g_varchar2) <>
206: nvl(p_rec.vre_information3, hr_api.g_varchar2) or
207: nvl(pqp_vre_shd.g_old_rec.vre_information4, hr_api.g_varchar2) <>
200: nvl(p_rec.vre_information_category, hr_api.g_varchar2) or
201: nvl(pqp_vre_shd.g_old_rec.vre_information1, hr_api.g_varchar2) <>
202: nvl(p_rec.vre_information1, hr_api.g_varchar2) or
203: nvl(pqp_vre_shd.g_old_rec.vre_information2, hr_api.g_varchar2) <>
204: nvl(p_rec.vre_information2, hr_api.g_varchar2) or
205: nvl(pqp_vre_shd.g_old_rec.vre_information3, hr_api.g_varchar2) <>
206: nvl(p_rec.vre_information3, hr_api.g_varchar2) or
207: nvl(pqp_vre_shd.g_old_rec.vre_information4, hr_api.g_varchar2) <>
208: nvl(p_rec.vre_information4, hr_api.g_varchar2) or
201: nvl(pqp_vre_shd.g_old_rec.vre_information1, hr_api.g_varchar2) <>
202: nvl(p_rec.vre_information1, hr_api.g_varchar2) or
203: nvl(pqp_vre_shd.g_old_rec.vre_information2, hr_api.g_varchar2) <>
204: nvl(p_rec.vre_information2, hr_api.g_varchar2) or
205: nvl(pqp_vre_shd.g_old_rec.vre_information3, hr_api.g_varchar2) <>
206: nvl(p_rec.vre_information3, hr_api.g_varchar2) or
207: nvl(pqp_vre_shd.g_old_rec.vre_information4, hr_api.g_varchar2) <>
208: nvl(p_rec.vre_information4, hr_api.g_varchar2) or
209: nvl(pqp_vre_shd.g_old_rec.vre_information5, hr_api.g_varchar2) <>
202: nvl(p_rec.vre_information1, hr_api.g_varchar2) or
203: nvl(pqp_vre_shd.g_old_rec.vre_information2, hr_api.g_varchar2) <>
204: nvl(p_rec.vre_information2, hr_api.g_varchar2) or
205: nvl(pqp_vre_shd.g_old_rec.vre_information3, hr_api.g_varchar2) <>
206: nvl(p_rec.vre_information3, hr_api.g_varchar2) or
207: nvl(pqp_vre_shd.g_old_rec.vre_information4, hr_api.g_varchar2) <>
208: nvl(p_rec.vre_information4, hr_api.g_varchar2) or
209: nvl(pqp_vre_shd.g_old_rec.vre_information5, hr_api.g_varchar2) <>
210: nvl(p_rec.vre_information5, hr_api.g_varchar2) or
203: nvl(pqp_vre_shd.g_old_rec.vre_information2, hr_api.g_varchar2) <>
204: nvl(p_rec.vre_information2, hr_api.g_varchar2) or
205: nvl(pqp_vre_shd.g_old_rec.vre_information3, hr_api.g_varchar2) <>
206: nvl(p_rec.vre_information3, hr_api.g_varchar2) or
207: nvl(pqp_vre_shd.g_old_rec.vre_information4, hr_api.g_varchar2) <>
208: nvl(p_rec.vre_information4, hr_api.g_varchar2) or
209: nvl(pqp_vre_shd.g_old_rec.vre_information5, hr_api.g_varchar2) <>
210: nvl(p_rec.vre_information5, hr_api.g_varchar2) or
211: nvl(pqp_vre_shd.g_old_rec.vre_information6, hr_api.g_varchar2) <>
204: nvl(p_rec.vre_information2, hr_api.g_varchar2) or
205: nvl(pqp_vre_shd.g_old_rec.vre_information3, hr_api.g_varchar2) <>
206: nvl(p_rec.vre_information3, hr_api.g_varchar2) or
207: nvl(pqp_vre_shd.g_old_rec.vre_information4, hr_api.g_varchar2) <>
208: nvl(p_rec.vre_information4, hr_api.g_varchar2) or
209: nvl(pqp_vre_shd.g_old_rec.vre_information5, hr_api.g_varchar2) <>
210: nvl(p_rec.vre_information5, hr_api.g_varchar2) or
211: nvl(pqp_vre_shd.g_old_rec.vre_information6, hr_api.g_varchar2) <>
212: nvl(p_rec.vre_information6, hr_api.g_varchar2) or
205: nvl(pqp_vre_shd.g_old_rec.vre_information3, hr_api.g_varchar2) <>
206: nvl(p_rec.vre_information3, hr_api.g_varchar2) or
207: nvl(pqp_vre_shd.g_old_rec.vre_information4, hr_api.g_varchar2) <>
208: nvl(p_rec.vre_information4, hr_api.g_varchar2) or
209: nvl(pqp_vre_shd.g_old_rec.vre_information5, hr_api.g_varchar2) <>
210: nvl(p_rec.vre_information5, hr_api.g_varchar2) or
211: nvl(pqp_vre_shd.g_old_rec.vre_information6, hr_api.g_varchar2) <>
212: nvl(p_rec.vre_information6, hr_api.g_varchar2) or
213: nvl(pqp_vre_shd.g_old_rec.vre_information7, hr_api.g_varchar2) <>
206: nvl(p_rec.vre_information3, hr_api.g_varchar2) or
207: nvl(pqp_vre_shd.g_old_rec.vre_information4, hr_api.g_varchar2) <>
208: nvl(p_rec.vre_information4, hr_api.g_varchar2) or
209: nvl(pqp_vre_shd.g_old_rec.vre_information5, hr_api.g_varchar2) <>
210: nvl(p_rec.vre_information5, hr_api.g_varchar2) or
211: nvl(pqp_vre_shd.g_old_rec.vre_information6, hr_api.g_varchar2) <>
212: nvl(p_rec.vre_information6, hr_api.g_varchar2) or
213: nvl(pqp_vre_shd.g_old_rec.vre_information7, hr_api.g_varchar2) <>
214: nvl(p_rec.vre_information7, hr_api.g_varchar2) or
207: nvl(pqp_vre_shd.g_old_rec.vre_information4, hr_api.g_varchar2) <>
208: nvl(p_rec.vre_information4, hr_api.g_varchar2) or
209: nvl(pqp_vre_shd.g_old_rec.vre_information5, hr_api.g_varchar2) <>
210: nvl(p_rec.vre_information5, hr_api.g_varchar2) or
211: nvl(pqp_vre_shd.g_old_rec.vre_information6, hr_api.g_varchar2) <>
212: nvl(p_rec.vre_information6, hr_api.g_varchar2) or
213: nvl(pqp_vre_shd.g_old_rec.vre_information7, hr_api.g_varchar2) <>
214: nvl(p_rec.vre_information7, hr_api.g_varchar2) or
215: nvl(pqp_vre_shd.g_old_rec.vre_information8, hr_api.g_varchar2) <>
208: nvl(p_rec.vre_information4, hr_api.g_varchar2) or
209: nvl(pqp_vre_shd.g_old_rec.vre_information5, hr_api.g_varchar2) <>
210: nvl(p_rec.vre_information5, hr_api.g_varchar2) or
211: nvl(pqp_vre_shd.g_old_rec.vre_information6, hr_api.g_varchar2) <>
212: nvl(p_rec.vre_information6, hr_api.g_varchar2) or
213: nvl(pqp_vre_shd.g_old_rec.vre_information7, hr_api.g_varchar2) <>
214: nvl(p_rec.vre_information7, hr_api.g_varchar2) or
215: nvl(pqp_vre_shd.g_old_rec.vre_information8, hr_api.g_varchar2) <>
216: nvl(p_rec.vre_information8, hr_api.g_varchar2) or
209: nvl(pqp_vre_shd.g_old_rec.vre_information5, hr_api.g_varchar2) <>
210: nvl(p_rec.vre_information5, hr_api.g_varchar2) or
211: nvl(pqp_vre_shd.g_old_rec.vre_information6, hr_api.g_varchar2) <>
212: nvl(p_rec.vre_information6, hr_api.g_varchar2) or
213: nvl(pqp_vre_shd.g_old_rec.vre_information7, hr_api.g_varchar2) <>
214: nvl(p_rec.vre_information7, hr_api.g_varchar2) or
215: nvl(pqp_vre_shd.g_old_rec.vre_information8, hr_api.g_varchar2) <>
216: nvl(p_rec.vre_information8, hr_api.g_varchar2) or
217: nvl(pqp_vre_shd.g_old_rec.vre_information9, hr_api.g_varchar2) <>
210: nvl(p_rec.vre_information5, hr_api.g_varchar2) or
211: nvl(pqp_vre_shd.g_old_rec.vre_information6, hr_api.g_varchar2) <>
212: nvl(p_rec.vre_information6, hr_api.g_varchar2) or
213: nvl(pqp_vre_shd.g_old_rec.vre_information7, hr_api.g_varchar2) <>
214: nvl(p_rec.vre_information7, hr_api.g_varchar2) or
215: nvl(pqp_vre_shd.g_old_rec.vre_information8, hr_api.g_varchar2) <>
216: nvl(p_rec.vre_information8, hr_api.g_varchar2) or
217: nvl(pqp_vre_shd.g_old_rec.vre_information9, hr_api.g_varchar2) <>
218: nvl(p_rec.vre_information9, hr_api.g_varchar2) or
211: nvl(pqp_vre_shd.g_old_rec.vre_information6, hr_api.g_varchar2) <>
212: nvl(p_rec.vre_information6, hr_api.g_varchar2) or
213: nvl(pqp_vre_shd.g_old_rec.vre_information7, hr_api.g_varchar2) <>
214: nvl(p_rec.vre_information7, hr_api.g_varchar2) or
215: nvl(pqp_vre_shd.g_old_rec.vre_information8, hr_api.g_varchar2) <>
216: nvl(p_rec.vre_information8, hr_api.g_varchar2) or
217: nvl(pqp_vre_shd.g_old_rec.vre_information9, hr_api.g_varchar2) <>
218: nvl(p_rec.vre_information9, hr_api.g_varchar2) or
219: nvl(pqp_vre_shd.g_old_rec.vre_information10, hr_api.g_varchar2) <>
212: nvl(p_rec.vre_information6, hr_api.g_varchar2) or
213: nvl(pqp_vre_shd.g_old_rec.vre_information7, hr_api.g_varchar2) <>
214: nvl(p_rec.vre_information7, hr_api.g_varchar2) or
215: nvl(pqp_vre_shd.g_old_rec.vre_information8, hr_api.g_varchar2) <>
216: nvl(p_rec.vre_information8, hr_api.g_varchar2) or
217: nvl(pqp_vre_shd.g_old_rec.vre_information9, hr_api.g_varchar2) <>
218: nvl(p_rec.vre_information9, hr_api.g_varchar2) or
219: nvl(pqp_vre_shd.g_old_rec.vre_information10, hr_api.g_varchar2) <>
220: nvl(p_rec.vre_information10, hr_api.g_varchar2) or
213: nvl(pqp_vre_shd.g_old_rec.vre_information7, hr_api.g_varchar2) <>
214: nvl(p_rec.vre_information7, hr_api.g_varchar2) or
215: nvl(pqp_vre_shd.g_old_rec.vre_information8, hr_api.g_varchar2) <>
216: nvl(p_rec.vre_information8, hr_api.g_varchar2) or
217: nvl(pqp_vre_shd.g_old_rec.vre_information9, hr_api.g_varchar2) <>
218: nvl(p_rec.vre_information9, hr_api.g_varchar2) or
219: nvl(pqp_vre_shd.g_old_rec.vre_information10, hr_api.g_varchar2) <>
220: nvl(p_rec.vre_information10, hr_api.g_varchar2) or
221: nvl(pqp_vre_shd.g_old_rec.vre_information11, hr_api.g_varchar2) <>
214: nvl(p_rec.vre_information7, hr_api.g_varchar2) or
215: nvl(pqp_vre_shd.g_old_rec.vre_information8, hr_api.g_varchar2) <>
216: nvl(p_rec.vre_information8, hr_api.g_varchar2) or
217: nvl(pqp_vre_shd.g_old_rec.vre_information9, hr_api.g_varchar2) <>
218: nvl(p_rec.vre_information9, hr_api.g_varchar2) or
219: nvl(pqp_vre_shd.g_old_rec.vre_information10, hr_api.g_varchar2) <>
220: nvl(p_rec.vre_information10, hr_api.g_varchar2) or
221: nvl(pqp_vre_shd.g_old_rec.vre_information11, hr_api.g_varchar2) <>
222: nvl(p_rec.vre_information11, hr_api.g_varchar2) or
215: nvl(pqp_vre_shd.g_old_rec.vre_information8, hr_api.g_varchar2) <>
216: nvl(p_rec.vre_information8, hr_api.g_varchar2) or
217: nvl(pqp_vre_shd.g_old_rec.vre_information9, hr_api.g_varchar2) <>
218: nvl(p_rec.vre_information9, hr_api.g_varchar2) or
219: nvl(pqp_vre_shd.g_old_rec.vre_information10, hr_api.g_varchar2) <>
220: nvl(p_rec.vre_information10, hr_api.g_varchar2) or
221: nvl(pqp_vre_shd.g_old_rec.vre_information11, hr_api.g_varchar2) <>
222: nvl(p_rec.vre_information11, hr_api.g_varchar2) or
223: nvl(pqp_vre_shd.g_old_rec.vre_information12, hr_api.g_varchar2) <>
216: nvl(p_rec.vre_information8, hr_api.g_varchar2) or
217: nvl(pqp_vre_shd.g_old_rec.vre_information9, hr_api.g_varchar2) <>
218: nvl(p_rec.vre_information9, hr_api.g_varchar2) or
219: nvl(pqp_vre_shd.g_old_rec.vre_information10, hr_api.g_varchar2) <>
220: nvl(p_rec.vre_information10, hr_api.g_varchar2) or
221: nvl(pqp_vre_shd.g_old_rec.vre_information11, hr_api.g_varchar2) <>
222: nvl(p_rec.vre_information11, hr_api.g_varchar2) or
223: nvl(pqp_vre_shd.g_old_rec.vre_information12, hr_api.g_varchar2) <>
224: nvl(p_rec.vre_information12, hr_api.g_varchar2) or
217: nvl(pqp_vre_shd.g_old_rec.vre_information9, hr_api.g_varchar2) <>
218: nvl(p_rec.vre_information9, hr_api.g_varchar2) or
219: nvl(pqp_vre_shd.g_old_rec.vre_information10, hr_api.g_varchar2) <>
220: nvl(p_rec.vre_information10, hr_api.g_varchar2) or
221: nvl(pqp_vre_shd.g_old_rec.vre_information11, hr_api.g_varchar2) <>
222: nvl(p_rec.vre_information11, hr_api.g_varchar2) or
223: nvl(pqp_vre_shd.g_old_rec.vre_information12, hr_api.g_varchar2) <>
224: nvl(p_rec.vre_information12, hr_api.g_varchar2) or
225: nvl(pqp_vre_shd.g_old_rec.vre_information13, hr_api.g_varchar2) <>
218: nvl(p_rec.vre_information9, hr_api.g_varchar2) or
219: nvl(pqp_vre_shd.g_old_rec.vre_information10, hr_api.g_varchar2) <>
220: nvl(p_rec.vre_information10, hr_api.g_varchar2) or
221: nvl(pqp_vre_shd.g_old_rec.vre_information11, hr_api.g_varchar2) <>
222: nvl(p_rec.vre_information11, hr_api.g_varchar2) or
223: nvl(pqp_vre_shd.g_old_rec.vre_information12, hr_api.g_varchar2) <>
224: nvl(p_rec.vre_information12, hr_api.g_varchar2) or
225: nvl(pqp_vre_shd.g_old_rec.vre_information13, hr_api.g_varchar2) <>
226: nvl(p_rec.vre_information13, hr_api.g_varchar2) or
219: nvl(pqp_vre_shd.g_old_rec.vre_information10, hr_api.g_varchar2) <>
220: nvl(p_rec.vre_information10, hr_api.g_varchar2) or
221: nvl(pqp_vre_shd.g_old_rec.vre_information11, hr_api.g_varchar2) <>
222: nvl(p_rec.vre_information11, hr_api.g_varchar2) or
223: nvl(pqp_vre_shd.g_old_rec.vre_information12, hr_api.g_varchar2) <>
224: nvl(p_rec.vre_information12, hr_api.g_varchar2) or
225: nvl(pqp_vre_shd.g_old_rec.vre_information13, hr_api.g_varchar2) <>
226: nvl(p_rec.vre_information13, hr_api.g_varchar2) or
227: nvl(pqp_vre_shd.g_old_rec.vre_information14, hr_api.g_varchar2) <>
220: nvl(p_rec.vre_information10, hr_api.g_varchar2) or
221: nvl(pqp_vre_shd.g_old_rec.vre_information11, hr_api.g_varchar2) <>
222: nvl(p_rec.vre_information11, hr_api.g_varchar2) or
223: nvl(pqp_vre_shd.g_old_rec.vre_information12, hr_api.g_varchar2) <>
224: nvl(p_rec.vre_information12, hr_api.g_varchar2) or
225: nvl(pqp_vre_shd.g_old_rec.vre_information13, hr_api.g_varchar2) <>
226: nvl(p_rec.vre_information13, hr_api.g_varchar2) or
227: nvl(pqp_vre_shd.g_old_rec.vre_information14, hr_api.g_varchar2) <>
228: nvl(p_rec.vre_information14, hr_api.g_varchar2) or
221: nvl(pqp_vre_shd.g_old_rec.vre_information11, hr_api.g_varchar2) <>
222: nvl(p_rec.vre_information11, hr_api.g_varchar2) or
223: nvl(pqp_vre_shd.g_old_rec.vre_information12, hr_api.g_varchar2) <>
224: nvl(p_rec.vre_information12, hr_api.g_varchar2) or
225: nvl(pqp_vre_shd.g_old_rec.vre_information13, hr_api.g_varchar2) <>
226: nvl(p_rec.vre_information13, hr_api.g_varchar2) or
227: nvl(pqp_vre_shd.g_old_rec.vre_information14, hr_api.g_varchar2) <>
228: nvl(p_rec.vre_information14, hr_api.g_varchar2) or
229: nvl(pqp_vre_shd.g_old_rec.vre_information15, hr_api.g_varchar2) <>
222: nvl(p_rec.vre_information11, hr_api.g_varchar2) or
223: nvl(pqp_vre_shd.g_old_rec.vre_information12, hr_api.g_varchar2) <>
224: nvl(p_rec.vre_information12, hr_api.g_varchar2) or
225: nvl(pqp_vre_shd.g_old_rec.vre_information13, hr_api.g_varchar2) <>
226: nvl(p_rec.vre_information13, hr_api.g_varchar2) or
227: nvl(pqp_vre_shd.g_old_rec.vre_information14, hr_api.g_varchar2) <>
228: nvl(p_rec.vre_information14, hr_api.g_varchar2) or
229: nvl(pqp_vre_shd.g_old_rec.vre_information15, hr_api.g_varchar2) <>
230: nvl(p_rec.vre_information15, hr_api.g_varchar2) or
223: nvl(pqp_vre_shd.g_old_rec.vre_information12, hr_api.g_varchar2) <>
224: nvl(p_rec.vre_information12, hr_api.g_varchar2) or
225: nvl(pqp_vre_shd.g_old_rec.vre_information13, hr_api.g_varchar2) <>
226: nvl(p_rec.vre_information13, hr_api.g_varchar2) or
227: nvl(pqp_vre_shd.g_old_rec.vre_information14, hr_api.g_varchar2) <>
228: nvl(p_rec.vre_information14, hr_api.g_varchar2) or
229: nvl(pqp_vre_shd.g_old_rec.vre_information15, hr_api.g_varchar2) <>
230: nvl(p_rec.vre_information15, hr_api.g_varchar2) or
231: nvl(pqp_vre_shd.g_old_rec.vre_information16, hr_api.g_varchar2) <>
224: nvl(p_rec.vre_information12, hr_api.g_varchar2) or
225: nvl(pqp_vre_shd.g_old_rec.vre_information13, hr_api.g_varchar2) <>
226: nvl(p_rec.vre_information13, hr_api.g_varchar2) or
227: nvl(pqp_vre_shd.g_old_rec.vre_information14, hr_api.g_varchar2) <>
228: nvl(p_rec.vre_information14, hr_api.g_varchar2) or
229: nvl(pqp_vre_shd.g_old_rec.vre_information15, hr_api.g_varchar2) <>
230: nvl(p_rec.vre_information15, hr_api.g_varchar2) or
231: nvl(pqp_vre_shd.g_old_rec.vre_information16, hr_api.g_varchar2) <>
232: nvl(p_rec.vre_information16, hr_api.g_varchar2) or
225: nvl(pqp_vre_shd.g_old_rec.vre_information13, hr_api.g_varchar2) <>
226: nvl(p_rec.vre_information13, hr_api.g_varchar2) or
227: nvl(pqp_vre_shd.g_old_rec.vre_information14, hr_api.g_varchar2) <>
228: nvl(p_rec.vre_information14, hr_api.g_varchar2) or
229: nvl(pqp_vre_shd.g_old_rec.vre_information15, hr_api.g_varchar2) <>
230: nvl(p_rec.vre_information15, hr_api.g_varchar2) or
231: nvl(pqp_vre_shd.g_old_rec.vre_information16, hr_api.g_varchar2) <>
232: nvl(p_rec.vre_information16, hr_api.g_varchar2) or
233: nvl(pqp_vre_shd.g_old_rec.vre_information17, hr_api.g_varchar2) <>
226: nvl(p_rec.vre_information13, hr_api.g_varchar2) or
227: nvl(pqp_vre_shd.g_old_rec.vre_information14, hr_api.g_varchar2) <>
228: nvl(p_rec.vre_information14, hr_api.g_varchar2) or
229: nvl(pqp_vre_shd.g_old_rec.vre_information15, hr_api.g_varchar2) <>
230: nvl(p_rec.vre_information15, hr_api.g_varchar2) or
231: nvl(pqp_vre_shd.g_old_rec.vre_information16, hr_api.g_varchar2) <>
232: nvl(p_rec.vre_information16, hr_api.g_varchar2) or
233: nvl(pqp_vre_shd.g_old_rec.vre_information17, hr_api.g_varchar2) <>
234: nvl(p_rec.vre_information17, hr_api.g_varchar2) or
227: nvl(pqp_vre_shd.g_old_rec.vre_information14, hr_api.g_varchar2) <>
228: nvl(p_rec.vre_information14, hr_api.g_varchar2) or
229: nvl(pqp_vre_shd.g_old_rec.vre_information15, hr_api.g_varchar2) <>
230: nvl(p_rec.vre_information15, hr_api.g_varchar2) or
231: nvl(pqp_vre_shd.g_old_rec.vre_information16, hr_api.g_varchar2) <>
232: nvl(p_rec.vre_information16, hr_api.g_varchar2) or
233: nvl(pqp_vre_shd.g_old_rec.vre_information17, hr_api.g_varchar2) <>
234: nvl(p_rec.vre_information17, hr_api.g_varchar2) or
235: nvl(pqp_vre_shd.g_old_rec.vre_information18, hr_api.g_varchar2) <>
228: nvl(p_rec.vre_information14, hr_api.g_varchar2) or
229: nvl(pqp_vre_shd.g_old_rec.vre_information15, hr_api.g_varchar2) <>
230: nvl(p_rec.vre_information15, hr_api.g_varchar2) or
231: nvl(pqp_vre_shd.g_old_rec.vre_information16, hr_api.g_varchar2) <>
232: nvl(p_rec.vre_information16, hr_api.g_varchar2) or
233: nvl(pqp_vre_shd.g_old_rec.vre_information17, hr_api.g_varchar2) <>
234: nvl(p_rec.vre_information17, hr_api.g_varchar2) or
235: nvl(pqp_vre_shd.g_old_rec.vre_information18, hr_api.g_varchar2) <>
236: nvl(p_rec.vre_information18, hr_api.g_varchar2) or
229: nvl(pqp_vre_shd.g_old_rec.vre_information15, hr_api.g_varchar2) <>
230: nvl(p_rec.vre_information15, hr_api.g_varchar2) or
231: nvl(pqp_vre_shd.g_old_rec.vre_information16, hr_api.g_varchar2) <>
232: nvl(p_rec.vre_information16, hr_api.g_varchar2) or
233: nvl(pqp_vre_shd.g_old_rec.vre_information17, hr_api.g_varchar2) <>
234: nvl(p_rec.vre_information17, hr_api.g_varchar2) or
235: nvl(pqp_vre_shd.g_old_rec.vre_information18, hr_api.g_varchar2) <>
236: nvl(p_rec.vre_information18, hr_api.g_varchar2) or
237: nvl(pqp_vre_shd.g_old_rec.vre_information19, hr_api.g_varchar2) <>
230: nvl(p_rec.vre_information15, hr_api.g_varchar2) or
231: nvl(pqp_vre_shd.g_old_rec.vre_information16, hr_api.g_varchar2) <>
232: nvl(p_rec.vre_information16, hr_api.g_varchar2) or
233: nvl(pqp_vre_shd.g_old_rec.vre_information17, hr_api.g_varchar2) <>
234: nvl(p_rec.vre_information17, hr_api.g_varchar2) or
235: nvl(pqp_vre_shd.g_old_rec.vre_information18, hr_api.g_varchar2) <>
236: nvl(p_rec.vre_information18, hr_api.g_varchar2) or
237: nvl(pqp_vre_shd.g_old_rec.vre_information19, hr_api.g_varchar2) <>
238: nvl(p_rec.vre_information19, hr_api.g_varchar2) or
231: nvl(pqp_vre_shd.g_old_rec.vre_information16, hr_api.g_varchar2) <>
232: nvl(p_rec.vre_information16, hr_api.g_varchar2) or
233: nvl(pqp_vre_shd.g_old_rec.vre_information17, hr_api.g_varchar2) <>
234: nvl(p_rec.vre_information17, hr_api.g_varchar2) or
235: nvl(pqp_vre_shd.g_old_rec.vre_information18, hr_api.g_varchar2) <>
236: nvl(p_rec.vre_information18, hr_api.g_varchar2) or
237: nvl(pqp_vre_shd.g_old_rec.vre_information19, hr_api.g_varchar2) <>
238: nvl(p_rec.vre_information19, hr_api.g_varchar2) or
239: nvl(pqp_vre_shd.g_old_rec.vre_information20, hr_api.g_varchar2) <>
232: nvl(p_rec.vre_information16, hr_api.g_varchar2) or
233: nvl(pqp_vre_shd.g_old_rec.vre_information17, hr_api.g_varchar2) <>
234: nvl(p_rec.vre_information17, hr_api.g_varchar2) or
235: nvl(pqp_vre_shd.g_old_rec.vre_information18, hr_api.g_varchar2) <>
236: nvl(p_rec.vre_information18, hr_api.g_varchar2) or
237: nvl(pqp_vre_shd.g_old_rec.vre_information19, hr_api.g_varchar2) <>
238: nvl(p_rec.vre_information19, hr_api.g_varchar2) or
239: nvl(pqp_vre_shd.g_old_rec.vre_information20, hr_api.g_varchar2) <>
240: nvl(p_rec.vre_information20, hr_api.g_varchar2) ))
233: nvl(pqp_vre_shd.g_old_rec.vre_information17, hr_api.g_varchar2) <>
234: nvl(p_rec.vre_information17, hr_api.g_varchar2) or
235: nvl(pqp_vre_shd.g_old_rec.vre_information18, hr_api.g_varchar2) <>
236: nvl(p_rec.vre_information18, hr_api.g_varchar2) or
237: nvl(pqp_vre_shd.g_old_rec.vre_information19, hr_api.g_varchar2) <>
238: nvl(p_rec.vre_information19, hr_api.g_varchar2) or
239: nvl(pqp_vre_shd.g_old_rec.vre_information20, hr_api.g_varchar2) <>
240: nvl(p_rec.vre_information20, hr_api.g_varchar2) ))
241: or (p_rec.vehicle_repository_id is null) THEN
234: nvl(p_rec.vre_information17, hr_api.g_varchar2) or
235: nvl(pqp_vre_shd.g_old_rec.vre_information18, hr_api.g_varchar2) <>
236: nvl(p_rec.vre_information18, hr_api.g_varchar2) or
237: nvl(pqp_vre_shd.g_old_rec.vre_information19, hr_api.g_varchar2) <>
238: nvl(p_rec.vre_information19, hr_api.g_varchar2) or
239: nvl(pqp_vre_shd.g_old_rec.vre_information20, hr_api.g_varchar2) <>
240: nvl(p_rec.vre_information20, hr_api.g_varchar2) ))
241: or (p_rec.vehicle_repository_id is null) THEN
242: --
235: nvl(pqp_vre_shd.g_old_rec.vre_information18, hr_api.g_varchar2) <>
236: nvl(p_rec.vre_information18, hr_api.g_varchar2) or
237: nvl(pqp_vre_shd.g_old_rec.vre_information19, hr_api.g_varchar2) <>
238: nvl(p_rec.vre_information19, hr_api.g_varchar2) or
239: nvl(pqp_vre_shd.g_old_rec.vre_information20, hr_api.g_varchar2) <>
240: nvl(p_rec.vre_information20, hr_api.g_varchar2) ))
241: or (p_rec.vehicle_repository_id is null) THEN
242: --
243: -- Only execute the validation if absolutely necessary:
236: nvl(p_rec.vre_information18, hr_api.g_varchar2) or
237: nvl(pqp_vre_shd.g_old_rec.vre_information19, hr_api.g_varchar2) <>
238: nvl(p_rec.vre_information19, hr_api.g_varchar2) or
239: nvl(pqp_vre_shd.g_old_rec.vre_information20, hr_api.g_varchar2) <>
240: nvl(p_rec.vre_information20, hr_api.g_varchar2) ))
241: or (p_rec.vehicle_repository_id is null) THEN
242: --
243: -- Only execute the validation if absolutely necessary:
244: -- a) During update, the structure column value or any
332: BEGIN
333: hr_utility.set_location('Entering:'||l_proc,10);
334: --
335: IF ((p_rec.vehicle_repository_id is not null) and (
336: nvl(pqp_vre_shd.g_old_rec.vre_attribute_category, hr_api.g_varchar2) <>
337: nvl(p_rec.vre_attribute_category, hr_api.g_varchar2) or
338: nvl(pqp_vre_shd.g_old_rec.vre_attribute1, hr_api.g_varchar2) <>
339: nvl(p_rec.vre_attribute1, hr_api.g_varchar2) or
340: nvl(pqp_vre_shd.g_old_rec.vre_attribute2, hr_api.g_varchar2) <>
333: hr_utility.set_location('Entering:'||l_proc,10);
334: --
335: IF ((p_rec.vehicle_repository_id is not null) and (
336: nvl(pqp_vre_shd.g_old_rec.vre_attribute_category, hr_api.g_varchar2) <>
337: nvl(p_rec.vre_attribute_category, hr_api.g_varchar2) or
338: nvl(pqp_vre_shd.g_old_rec.vre_attribute1, hr_api.g_varchar2) <>
339: nvl(p_rec.vre_attribute1, hr_api.g_varchar2) or
340: nvl(pqp_vre_shd.g_old_rec.vre_attribute2, hr_api.g_varchar2) <>
341: nvl(p_rec.vre_attribute2, hr_api.g_varchar2) or
334: --
335: IF ((p_rec.vehicle_repository_id is not null) and (
336: nvl(pqp_vre_shd.g_old_rec.vre_attribute_category, hr_api.g_varchar2) <>
337: nvl(p_rec.vre_attribute_category, hr_api.g_varchar2) or
338: nvl(pqp_vre_shd.g_old_rec.vre_attribute1, hr_api.g_varchar2) <>
339: nvl(p_rec.vre_attribute1, hr_api.g_varchar2) or
340: nvl(pqp_vre_shd.g_old_rec.vre_attribute2, hr_api.g_varchar2) <>
341: nvl(p_rec.vre_attribute2, hr_api.g_varchar2) or
342: nvl(pqp_vre_shd.g_old_rec.vre_attribute3, hr_api.g_varchar2) <>
335: IF ((p_rec.vehicle_repository_id is not null) and (
336: nvl(pqp_vre_shd.g_old_rec.vre_attribute_category, hr_api.g_varchar2) <>
337: nvl(p_rec.vre_attribute_category, hr_api.g_varchar2) or
338: nvl(pqp_vre_shd.g_old_rec.vre_attribute1, hr_api.g_varchar2) <>
339: nvl(p_rec.vre_attribute1, hr_api.g_varchar2) or
340: nvl(pqp_vre_shd.g_old_rec.vre_attribute2, hr_api.g_varchar2) <>
341: nvl(p_rec.vre_attribute2, hr_api.g_varchar2) or
342: nvl(pqp_vre_shd.g_old_rec.vre_attribute3, hr_api.g_varchar2) <>
343: nvl(p_rec.vre_attribute3, hr_api.g_varchar2) or
336: nvl(pqp_vre_shd.g_old_rec.vre_attribute_category, hr_api.g_varchar2) <>
337: nvl(p_rec.vre_attribute_category, hr_api.g_varchar2) or
338: nvl(pqp_vre_shd.g_old_rec.vre_attribute1, hr_api.g_varchar2) <>
339: nvl(p_rec.vre_attribute1, hr_api.g_varchar2) or
340: nvl(pqp_vre_shd.g_old_rec.vre_attribute2, hr_api.g_varchar2) <>
341: nvl(p_rec.vre_attribute2, hr_api.g_varchar2) or
342: nvl(pqp_vre_shd.g_old_rec.vre_attribute3, hr_api.g_varchar2) <>
343: nvl(p_rec.vre_attribute3, hr_api.g_varchar2) or
344: nvl(pqp_vre_shd.g_old_rec.vre_attribute4, hr_api.g_varchar2) <>
337: nvl(p_rec.vre_attribute_category, hr_api.g_varchar2) or
338: nvl(pqp_vre_shd.g_old_rec.vre_attribute1, hr_api.g_varchar2) <>
339: nvl(p_rec.vre_attribute1, hr_api.g_varchar2) or
340: nvl(pqp_vre_shd.g_old_rec.vre_attribute2, hr_api.g_varchar2) <>
341: nvl(p_rec.vre_attribute2, hr_api.g_varchar2) or
342: nvl(pqp_vre_shd.g_old_rec.vre_attribute3, hr_api.g_varchar2) <>
343: nvl(p_rec.vre_attribute3, hr_api.g_varchar2) or
344: nvl(pqp_vre_shd.g_old_rec.vre_attribute4, hr_api.g_varchar2) <>
345: nvl(p_rec.vre_attribute4, hr_api.g_varchar2) or
338: nvl(pqp_vre_shd.g_old_rec.vre_attribute1, hr_api.g_varchar2) <>
339: nvl(p_rec.vre_attribute1, hr_api.g_varchar2) or
340: nvl(pqp_vre_shd.g_old_rec.vre_attribute2, hr_api.g_varchar2) <>
341: nvl(p_rec.vre_attribute2, hr_api.g_varchar2) or
342: nvl(pqp_vre_shd.g_old_rec.vre_attribute3, hr_api.g_varchar2) <>
343: nvl(p_rec.vre_attribute3, hr_api.g_varchar2) or
344: nvl(pqp_vre_shd.g_old_rec.vre_attribute4, hr_api.g_varchar2) <>
345: nvl(p_rec.vre_attribute4, hr_api.g_varchar2) or
346: nvl(pqp_vre_shd.g_old_rec.vre_attribute5, hr_api.g_varchar2) <>
339: nvl(p_rec.vre_attribute1, hr_api.g_varchar2) or
340: nvl(pqp_vre_shd.g_old_rec.vre_attribute2, hr_api.g_varchar2) <>
341: nvl(p_rec.vre_attribute2, hr_api.g_varchar2) or
342: nvl(pqp_vre_shd.g_old_rec.vre_attribute3, hr_api.g_varchar2) <>
343: nvl(p_rec.vre_attribute3, hr_api.g_varchar2) or
344: nvl(pqp_vre_shd.g_old_rec.vre_attribute4, hr_api.g_varchar2) <>
345: nvl(p_rec.vre_attribute4, hr_api.g_varchar2) or
346: nvl(pqp_vre_shd.g_old_rec.vre_attribute5, hr_api.g_varchar2) <>
347: nvl(p_rec.vre_attribute5, hr_api.g_varchar2) or
340: nvl(pqp_vre_shd.g_old_rec.vre_attribute2, hr_api.g_varchar2) <>
341: nvl(p_rec.vre_attribute2, hr_api.g_varchar2) or
342: nvl(pqp_vre_shd.g_old_rec.vre_attribute3, hr_api.g_varchar2) <>
343: nvl(p_rec.vre_attribute3, hr_api.g_varchar2) or
344: nvl(pqp_vre_shd.g_old_rec.vre_attribute4, hr_api.g_varchar2) <>
345: nvl(p_rec.vre_attribute4, hr_api.g_varchar2) or
346: nvl(pqp_vre_shd.g_old_rec.vre_attribute5, hr_api.g_varchar2) <>
347: nvl(p_rec.vre_attribute5, hr_api.g_varchar2) or
348: nvl(pqp_vre_shd.g_old_rec.vre_attribute6, hr_api.g_varchar2) <>
341: nvl(p_rec.vre_attribute2, hr_api.g_varchar2) or
342: nvl(pqp_vre_shd.g_old_rec.vre_attribute3, hr_api.g_varchar2) <>
343: nvl(p_rec.vre_attribute3, hr_api.g_varchar2) or
344: nvl(pqp_vre_shd.g_old_rec.vre_attribute4, hr_api.g_varchar2) <>
345: nvl(p_rec.vre_attribute4, hr_api.g_varchar2) or
346: nvl(pqp_vre_shd.g_old_rec.vre_attribute5, hr_api.g_varchar2) <>
347: nvl(p_rec.vre_attribute5, hr_api.g_varchar2) or
348: nvl(pqp_vre_shd.g_old_rec.vre_attribute6, hr_api.g_varchar2) <>
349: nvl(p_rec.vre_attribute6, hr_api.g_varchar2) or
342: nvl(pqp_vre_shd.g_old_rec.vre_attribute3, hr_api.g_varchar2) <>
343: nvl(p_rec.vre_attribute3, hr_api.g_varchar2) or
344: nvl(pqp_vre_shd.g_old_rec.vre_attribute4, hr_api.g_varchar2) <>
345: nvl(p_rec.vre_attribute4, hr_api.g_varchar2) or
346: nvl(pqp_vre_shd.g_old_rec.vre_attribute5, hr_api.g_varchar2) <>
347: nvl(p_rec.vre_attribute5, hr_api.g_varchar2) or
348: nvl(pqp_vre_shd.g_old_rec.vre_attribute6, hr_api.g_varchar2) <>
349: nvl(p_rec.vre_attribute6, hr_api.g_varchar2) or
350: nvl(pqp_vre_shd.g_old_rec.vre_attribute7, hr_api.g_varchar2) <>
343: nvl(p_rec.vre_attribute3, hr_api.g_varchar2) or
344: nvl(pqp_vre_shd.g_old_rec.vre_attribute4, hr_api.g_varchar2) <>
345: nvl(p_rec.vre_attribute4, hr_api.g_varchar2) or
346: nvl(pqp_vre_shd.g_old_rec.vre_attribute5, hr_api.g_varchar2) <>
347: nvl(p_rec.vre_attribute5, hr_api.g_varchar2) or
348: nvl(pqp_vre_shd.g_old_rec.vre_attribute6, hr_api.g_varchar2) <>
349: nvl(p_rec.vre_attribute6, hr_api.g_varchar2) or
350: nvl(pqp_vre_shd.g_old_rec.vre_attribute7, hr_api.g_varchar2) <>
351: nvl(p_rec.vre_attribute7, hr_api.g_varchar2) or
344: nvl(pqp_vre_shd.g_old_rec.vre_attribute4, hr_api.g_varchar2) <>
345: nvl(p_rec.vre_attribute4, hr_api.g_varchar2) or
346: nvl(pqp_vre_shd.g_old_rec.vre_attribute5, hr_api.g_varchar2) <>
347: nvl(p_rec.vre_attribute5, hr_api.g_varchar2) or
348: nvl(pqp_vre_shd.g_old_rec.vre_attribute6, hr_api.g_varchar2) <>
349: nvl(p_rec.vre_attribute6, hr_api.g_varchar2) or
350: nvl(pqp_vre_shd.g_old_rec.vre_attribute7, hr_api.g_varchar2) <>
351: nvl(p_rec.vre_attribute7, hr_api.g_varchar2) or
352: nvl(pqp_vre_shd.g_old_rec.vre_attribute8, hr_api.g_varchar2) <>
345: nvl(p_rec.vre_attribute4, hr_api.g_varchar2) or
346: nvl(pqp_vre_shd.g_old_rec.vre_attribute5, hr_api.g_varchar2) <>
347: nvl(p_rec.vre_attribute5, hr_api.g_varchar2) or
348: nvl(pqp_vre_shd.g_old_rec.vre_attribute6, hr_api.g_varchar2) <>
349: nvl(p_rec.vre_attribute6, hr_api.g_varchar2) or
350: nvl(pqp_vre_shd.g_old_rec.vre_attribute7, hr_api.g_varchar2) <>
351: nvl(p_rec.vre_attribute7, hr_api.g_varchar2) or
352: nvl(pqp_vre_shd.g_old_rec.vre_attribute8, hr_api.g_varchar2) <>
353: nvl(p_rec.vre_attribute8, hr_api.g_varchar2) or
346: nvl(pqp_vre_shd.g_old_rec.vre_attribute5, hr_api.g_varchar2) <>
347: nvl(p_rec.vre_attribute5, hr_api.g_varchar2) or
348: nvl(pqp_vre_shd.g_old_rec.vre_attribute6, hr_api.g_varchar2) <>
349: nvl(p_rec.vre_attribute6, hr_api.g_varchar2) or
350: nvl(pqp_vre_shd.g_old_rec.vre_attribute7, hr_api.g_varchar2) <>
351: nvl(p_rec.vre_attribute7, hr_api.g_varchar2) or
352: nvl(pqp_vre_shd.g_old_rec.vre_attribute8, hr_api.g_varchar2) <>
353: nvl(p_rec.vre_attribute8, hr_api.g_varchar2) or
354: nvl(pqp_vre_shd.g_old_rec.vre_attribute9, hr_api.g_varchar2) <>
347: nvl(p_rec.vre_attribute5, hr_api.g_varchar2) or
348: nvl(pqp_vre_shd.g_old_rec.vre_attribute6, hr_api.g_varchar2) <>
349: nvl(p_rec.vre_attribute6, hr_api.g_varchar2) or
350: nvl(pqp_vre_shd.g_old_rec.vre_attribute7, hr_api.g_varchar2) <>
351: nvl(p_rec.vre_attribute7, hr_api.g_varchar2) or
352: nvl(pqp_vre_shd.g_old_rec.vre_attribute8, hr_api.g_varchar2) <>
353: nvl(p_rec.vre_attribute8, hr_api.g_varchar2) or
354: nvl(pqp_vre_shd.g_old_rec.vre_attribute9, hr_api.g_varchar2) <>
355: nvl(p_rec.vre_attribute9, hr_api.g_varchar2) or
348: nvl(pqp_vre_shd.g_old_rec.vre_attribute6, hr_api.g_varchar2) <>
349: nvl(p_rec.vre_attribute6, hr_api.g_varchar2) or
350: nvl(pqp_vre_shd.g_old_rec.vre_attribute7, hr_api.g_varchar2) <>
351: nvl(p_rec.vre_attribute7, hr_api.g_varchar2) or
352: nvl(pqp_vre_shd.g_old_rec.vre_attribute8, hr_api.g_varchar2) <>
353: nvl(p_rec.vre_attribute8, hr_api.g_varchar2) or
354: nvl(pqp_vre_shd.g_old_rec.vre_attribute9, hr_api.g_varchar2) <>
355: nvl(p_rec.vre_attribute9, hr_api.g_varchar2) or
356: nvl(pqp_vre_shd.g_old_rec.vre_attribute10, hr_api.g_varchar2) <>
349: nvl(p_rec.vre_attribute6, hr_api.g_varchar2) or
350: nvl(pqp_vre_shd.g_old_rec.vre_attribute7, hr_api.g_varchar2) <>
351: nvl(p_rec.vre_attribute7, hr_api.g_varchar2) or
352: nvl(pqp_vre_shd.g_old_rec.vre_attribute8, hr_api.g_varchar2) <>
353: nvl(p_rec.vre_attribute8, hr_api.g_varchar2) or
354: nvl(pqp_vre_shd.g_old_rec.vre_attribute9, hr_api.g_varchar2) <>
355: nvl(p_rec.vre_attribute9, hr_api.g_varchar2) or
356: nvl(pqp_vre_shd.g_old_rec.vre_attribute10, hr_api.g_varchar2) <>
357: nvl(p_rec.vre_attribute10, hr_api.g_varchar2) or
350: nvl(pqp_vre_shd.g_old_rec.vre_attribute7, hr_api.g_varchar2) <>
351: nvl(p_rec.vre_attribute7, hr_api.g_varchar2) or
352: nvl(pqp_vre_shd.g_old_rec.vre_attribute8, hr_api.g_varchar2) <>
353: nvl(p_rec.vre_attribute8, hr_api.g_varchar2) or
354: nvl(pqp_vre_shd.g_old_rec.vre_attribute9, hr_api.g_varchar2) <>
355: nvl(p_rec.vre_attribute9, hr_api.g_varchar2) or
356: nvl(pqp_vre_shd.g_old_rec.vre_attribute10, hr_api.g_varchar2) <>
357: nvl(p_rec.vre_attribute10, hr_api.g_varchar2) or
358: nvl(pqp_vre_shd.g_old_rec.vre_attribute11, hr_api.g_varchar2) <>
351: nvl(p_rec.vre_attribute7, hr_api.g_varchar2) or
352: nvl(pqp_vre_shd.g_old_rec.vre_attribute8, hr_api.g_varchar2) <>
353: nvl(p_rec.vre_attribute8, hr_api.g_varchar2) or
354: nvl(pqp_vre_shd.g_old_rec.vre_attribute9, hr_api.g_varchar2) <>
355: nvl(p_rec.vre_attribute9, hr_api.g_varchar2) or
356: nvl(pqp_vre_shd.g_old_rec.vre_attribute10, hr_api.g_varchar2) <>
357: nvl(p_rec.vre_attribute10, hr_api.g_varchar2) or
358: nvl(pqp_vre_shd.g_old_rec.vre_attribute11, hr_api.g_varchar2) <>
359: nvl(p_rec.vre_attribute11, hr_api.g_varchar2) or
352: nvl(pqp_vre_shd.g_old_rec.vre_attribute8, hr_api.g_varchar2) <>
353: nvl(p_rec.vre_attribute8, hr_api.g_varchar2) or
354: nvl(pqp_vre_shd.g_old_rec.vre_attribute9, hr_api.g_varchar2) <>
355: nvl(p_rec.vre_attribute9, hr_api.g_varchar2) or
356: nvl(pqp_vre_shd.g_old_rec.vre_attribute10, hr_api.g_varchar2) <>
357: nvl(p_rec.vre_attribute10, hr_api.g_varchar2) or
358: nvl(pqp_vre_shd.g_old_rec.vre_attribute11, hr_api.g_varchar2) <>
359: nvl(p_rec.vre_attribute11, hr_api.g_varchar2) or
360: nvl(pqp_vre_shd.g_old_rec.vre_attribute12, hr_api.g_varchar2) <>
353: nvl(p_rec.vre_attribute8, hr_api.g_varchar2) or
354: nvl(pqp_vre_shd.g_old_rec.vre_attribute9, hr_api.g_varchar2) <>
355: nvl(p_rec.vre_attribute9, hr_api.g_varchar2) or
356: nvl(pqp_vre_shd.g_old_rec.vre_attribute10, hr_api.g_varchar2) <>
357: nvl(p_rec.vre_attribute10, hr_api.g_varchar2) or
358: nvl(pqp_vre_shd.g_old_rec.vre_attribute11, hr_api.g_varchar2) <>
359: nvl(p_rec.vre_attribute11, hr_api.g_varchar2) or
360: nvl(pqp_vre_shd.g_old_rec.vre_attribute12, hr_api.g_varchar2) <>
361: nvl(p_rec.vre_attribute12, hr_api.g_varchar2) or
354: nvl(pqp_vre_shd.g_old_rec.vre_attribute9, hr_api.g_varchar2) <>
355: nvl(p_rec.vre_attribute9, hr_api.g_varchar2) or
356: nvl(pqp_vre_shd.g_old_rec.vre_attribute10, hr_api.g_varchar2) <>
357: nvl(p_rec.vre_attribute10, hr_api.g_varchar2) or
358: nvl(pqp_vre_shd.g_old_rec.vre_attribute11, hr_api.g_varchar2) <>
359: nvl(p_rec.vre_attribute11, hr_api.g_varchar2) or
360: nvl(pqp_vre_shd.g_old_rec.vre_attribute12, hr_api.g_varchar2) <>
361: nvl(p_rec.vre_attribute12, hr_api.g_varchar2) or
362: nvl(pqp_vre_shd.g_old_rec.vre_attribute13, hr_api.g_varchar2) <>
355: nvl(p_rec.vre_attribute9, hr_api.g_varchar2) or
356: nvl(pqp_vre_shd.g_old_rec.vre_attribute10, hr_api.g_varchar2) <>
357: nvl(p_rec.vre_attribute10, hr_api.g_varchar2) or
358: nvl(pqp_vre_shd.g_old_rec.vre_attribute11, hr_api.g_varchar2) <>
359: nvl(p_rec.vre_attribute11, hr_api.g_varchar2) or
360: nvl(pqp_vre_shd.g_old_rec.vre_attribute12, hr_api.g_varchar2) <>
361: nvl(p_rec.vre_attribute12, hr_api.g_varchar2) or
362: nvl(pqp_vre_shd.g_old_rec.vre_attribute13, hr_api.g_varchar2) <>
363: nvl(p_rec.vre_attribute13, hr_api.g_varchar2) or
356: nvl(pqp_vre_shd.g_old_rec.vre_attribute10, hr_api.g_varchar2) <>
357: nvl(p_rec.vre_attribute10, hr_api.g_varchar2) or
358: nvl(pqp_vre_shd.g_old_rec.vre_attribute11, hr_api.g_varchar2) <>
359: nvl(p_rec.vre_attribute11, hr_api.g_varchar2) or
360: nvl(pqp_vre_shd.g_old_rec.vre_attribute12, hr_api.g_varchar2) <>
361: nvl(p_rec.vre_attribute12, hr_api.g_varchar2) or
362: nvl(pqp_vre_shd.g_old_rec.vre_attribute13, hr_api.g_varchar2) <>
363: nvl(p_rec.vre_attribute13, hr_api.g_varchar2) or
364: nvl(pqp_vre_shd.g_old_rec.vre_attribute14, hr_api.g_varchar2) <>
357: nvl(p_rec.vre_attribute10, hr_api.g_varchar2) or
358: nvl(pqp_vre_shd.g_old_rec.vre_attribute11, hr_api.g_varchar2) <>
359: nvl(p_rec.vre_attribute11, hr_api.g_varchar2) or
360: nvl(pqp_vre_shd.g_old_rec.vre_attribute12, hr_api.g_varchar2) <>
361: nvl(p_rec.vre_attribute12, hr_api.g_varchar2) or
362: nvl(pqp_vre_shd.g_old_rec.vre_attribute13, hr_api.g_varchar2) <>
363: nvl(p_rec.vre_attribute13, hr_api.g_varchar2) or
364: nvl(pqp_vre_shd.g_old_rec.vre_attribute14, hr_api.g_varchar2) <>
365: nvl(p_rec.vre_attribute14, hr_api.g_varchar2) or
358: nvl(pqp_vre_shd.g_old_rec.vre_attribute11, hr_api.g_varchar2) <>
359: nvl(p_rec.vre_attribute11, hr_api.g_varchar2) or
360: nvl(pqp_vre_shd.g_old_rec.vre_attribute12, hr_api.g_varchar2) <>
361: nvl(p_rec.vre_attribute12, hr_api.g_varchar2) or
362: nvl(pqp_vre_shd.g_old_rec.vre_attribute13, hr_api.g_varchar2) <>
363: nvl(p_rec.vre_attribute13, hr_api.g_varchar2) or
364: nvl(pqp_vre_shd.g_old_rec.vre_attribute14, hr_api.g_varchar2) <>
365: nvl(p_rec.vre_attribute14, hr_api.g_varchar2) or
366: nvl(pqp_vre_shd.g_old_rec.vre_attribute15, hr_api.g_varchar2) <>
359: nvl(p_rec.vre_attribute11, hr_api.g_varchar2) or
360: nvl(pqp_vre_shd.g_old_rec.vre_attribute12, hr_api.g_varchar2) <>
361: nvl(p_rec.vre_attribute12, hr_api.g_varchar2) or
362: nvl(pqp_vre_shd.g_old_rec.vre_attribute13, hr_api.g_varchar2) <>
363: nvl(p_rec.vre_attribute13, hr_api.g_varchar2) or
364: nvl(pqp_vre_shd.g_old_rec.vre_attribute14, hr_api.g_varchar2) <>
365: nvl(p_rec.vre_attribute14, hr_api.g_varchar2) or
366: nvl(pqp_vre_shd.g_old_rec.vre_attribute15, hr_api.g_varchar2) <>
367: nvl(p_rec.vre_attribute15, hr_api.g_varchar2) or
360: nvl(pqp_vre_shd.g_old_rec.vre_attribute12, hr_api.g_varchar2) <>
361: nvl(p_rec.vre_attribute12, hr_api.g_varchar2) or
362: nvl(pqp_vre_shd.g_old_rec.vre_attribute13, hr_api.g_varchar2) <>
363: nvl(p_rec.vre_attribute13, hr_api.g_varchar2) or
364: nvl(pqp_vre_shd.g_old_rec.vre_attribute14, hr_api.g_varchar2) <>
365: nvl(p_rec.vre_attribute14, hr_api.g_varchar2) or
366: nvl(pqp_vre_shd.g_old_rec.vre_attribute15, hr_api.g_varchar2) <>
367: nvl(p_rec.vre_attribute15, hr_api.g_varchar2) or
368: nvl(pqp_vre_shd.g_old_rec.vre_attribute16, hr_api.g_varchar2) <>
361: nvl(p_rec.vre_attribute12, hr_api.g_varchar2) or
362: nvl(pqp_vre_shd.g_old_rec.vre_attribute13, hr_api.g_varchar2) <>
363: nvl(p_rec.vre_attribute13, hr_api.g_varchar2) or
364: nvl(pqp_vre_shd.g_old_rec.vre_attribute14, hr_api.g_varchar2) <>
365: nvl(p_rec.vre_attribute14, hr_api.g_varchar2) or
366: nvl(pqp_vre_shd.g_old_rec.vre_attribute15, hr_api.g_varchar2) <>
367: nvl(p_rec.vre_attribute15, hr_api.g_varchar2) or
368: nvl(pqp_vre_shd.g_old_rec.vre_attribute16, hr_api.g_varchar2) <>
369: nvl(p_rec.vre_attribute16, hr_api.g_varchar2) or
362: nvl(pqp_vre_shd.g_old_rec.vre_attribute13, hr_api.g_varchar2) <>
363: nvl(p_rec.vre_attribute13, hr_api.g_varchar2) or
364: nvl(pqp_vre_shd.g_old_rec.vre_attribute14, hr_api.g_varchar2) <>
365: nvl(p_rec.vre_attribute14, hr_api.g_varchar2) or
366: nvl(pqp_vre_shd.g_old_rec.vre_attribute15, hr_api.g_varchar2) <>
367: nvl(p_rec.vre_attribute15, hr_api.g_varchar2) or
368: nvl(pqp_vre_shd.g_old_rec.vre_attribute16, hr_api.g_varchar2) <>
369: nvl(p_rec.vre_attribute16, hr_api.g_varchar2) or
370: nvl(pqp_vre_shd.g_old_rec.vre_attribute17, hr_api.g_varchar2) <>
363: nvl(p_rec.vre_attribute13, hr_api.g_varchar2) or
364: nvl(pqp_vre_shd.g_old_rec.vre_attribute14, hr_api.g_varchar2) <>
365: nvl(p_rec.vre_attribute14, hr_api.g_varchar2) or
366: nvl(pqp_vre_shd.g_old_rec.vre_attribute15, hr_api.g_varchar2) <>
367: nvl(p_rec.vre_attribute15, hr_api.g_varchar2) or
368: nvl(pqp_vre_shd.g_old_rec.vre_attribute16, hr_api.g_varchar2) <>
369: nvl(p_rec.vre_attribute16, hr_api.g_varchar2) or
370: nvl(pqp_vre_shd.g_old_rec.vre_attribute17, hr_api.g_varchar2) <>
371: nvl(p_rec.vre_attribute17, hr_api.g_varchar2) or
364: nvl(pqp_vre_shd.g_old_rec.vre_attribute14, hr_api.g_varchar2) <>
365: nvl(p_rec.vre_attribute14, hr_api.g_varchar2) or
366: nvl(pqp_vre_shd.g_old_rec.vre_attribute15, hr_api.g_varchar2) <>
367: nvl(p_rec.vre_attribute15, hr_api.g_varchar2) or
368: nvl(pqp_vre_shd.g_old_rec.vre_attribute16, hr_api.g_varchar2) <>
369: nvl(p_rec.vre_attribute16, hr_api.g_varchar2) or
370: nvl(pqp_vre_shd.g_old_rec.vre_attribute17, hr_api.g_varchar2) <>
371: nvl(p_rec.vre_attribute17, hr_api.g_varchar2) or
372: nvl(pqp_vre_shd.g_old_rec.vre_attribute18, hr_api.g_varchar2) <>
365: nvl(p_rec.vre_attribute14, hr_api.g_varchar2) or
366: nvl(pqp_vre_shd.g_old_rec.vre_attribute15, hr_api.g_varchar2) <>
367: nvl(p_rec.vre_attribute15, hr_api.g_varchar2) or
368: nvl(pqp_vre_shd.g_old_rec.vre_attribute16, hr_api.g_varchar2) <>
369: nvl(p_rec.vre_attribute16, hr_api.g_varchar2) or
370: nvl(pqp_vre_shd.g_old_rec.vre_attribute17, hr_api.g_varchar2) <>
371: nvl(p_rec.vre_attribute17, hr_api.g_varchar2) or
372: nvl(pqp_vre_shd.g_old_rec.vre_attribute18, hr_api.g_varchar2) <>
373: nvl(p_rec.vre_attribute18, hr_api.g_varchar2) or
366: nvl(pqp_vre_shd.g_old_rec.vre_attribute15, hr_api.g_varchar2) <>
367: nvl(p_rec.vre_attribute15, hr_api.g_varchar2) or
368: nvl(pqp_vre_shd.g_old_rec.vre_attribute16, hr_api.g_varchar2) <>
369: nvl(p_rec.vre_attribute16, hr_api.g_varchar2) or
370: nvl(pqp_vre_shd.g_old_rec.vre_attribute17, hr_api.g_varchar2) <>
371: nvl(p_rec.vre_attribute17, hr_api.g_varchar2) or
372: nvl(pqp_vre_shd.g_old_rec.vre_attribute18, hr_api.g_varchar2) <>
373: nvl(p_rec.vre_attribute18, hr_api.g_varchar2) or
374: nvl(pqp_vre_shd.g_old_rec.vre_attribute19, hr_api.g_varchar2) <>
367: nvl(p_rec.vre_attribute15, hr_api.g_varchar2) or
368: nvl(pqp_vre_shd.g_old_rec.vre_attribute16, hr_api.g_varchar2) <>
369: nvl(p_rec.vre_attribute16, hr_api.g_varchar2) or
370: nvl(pqp_vre_shd.g_old_rec.vre_attribute17, hr_api.g_varchar2) <>
371: nvl(p_rec.vre_attribute17, hr_api.g_varchar2) or
372: nvl(pqp_vre_shd.g_old_rec.vre_attribute18, hr_api.g_varchar2) <>
373: nvl(p_rec.vre_attribute18, hr_api.g_varchar2) or
374: nvl(pqp_vre_shd.g_old_rec.vre_attribute19, hr_api.g_varchar2) <>
375: nvl(p_rec.vre_attribute19, hr_api.g_varchar2) or
368: nvl(pqp_vre_shd.g_old_rec.vre_attribute16, hr_api.g_varchar2) <>
369: nvl(p_rec.vre_attribute16, hr_api.g_varchar2) or
370: nvl(pqp_vre_shd.g_old_rec.vre_attribute17, hr_api.g_varchar2) <>
371: nvl(p_rec.vre_attribute17, hr_api.g_varchar2) or
372: nvl(pqp_vre_shd.g_old_rec.vre_attribute18, hr_api.g_varchar2) <>
373: nvl(p_rec.vre_attribute18, hr_api.g_varchar2) or
374: nvl(pqp_vre_shd.g_old_rec.vre_attribute19, hr_api.g_varchar2) <>
375: nvl(p_rec.vre_attribute19, hr_api.g_varchar2) or
376: nvl(pqp_vre_shd.g_old_rec.vre_attribute20, hr_api.g_varchar2) <>
369: nvl(p_rec.vre_attribute16, hr_api.g_varchar2) or
370: nvl(pqp_vre_shd.g_old_rec.vre_attribute17, hr_api.g_varchar2) <>
371: nvl(p_rec.vre_attribute17, hr_api.g_varchar2) or
372: nvl(pqp_vre_shd.g_old_rec.vre_attribute18, hr_api.g_varchar2) <>
373: nvl(p_rec.vre_attribute18, hr_api.g_varchar2) or
374: nvl(pqp_vre_shd.g_old_rec.vre_attribute19, hr_api.g_varchar2) <>
375: nvl(p_rec.vre_attribute19, hr_api.g_varchar2) or
376: nvl(pqp_vre_shd.g_old_rec.vre_attribute20, hr_api.g_varchar2) <>
377: nvl(p_rec.vre_attribute20, hr_api.g_varchar2) ))
370: nvl(pqp_vre_shd.g_old_rec.vre_attribute17, hr_api.g_varchar2) <>
371: nvl(p_rec.vre_attribute17, hr_api.g_varchar2) or
372: nvl(pqp_vre_shd.g_old_rec.vre_attribute18, hr_api.g_varchar2) <>
373: nvl(p_rec.vre_attribute18, hr_api.g_varchar2) or
374: nvl(pqp_vre_shd.g_old_rec.vre_attribute19, hr_api.g_varchar2) <>
375: nvl(p_rec.vre_attribute19, hr_api.g_varchar2) or
376: nvl(pqp_vre_shd.g_old_rec.vre_attribute20, hr_api.g_varchar2) <>
377: nvl(p_rec.vre_attribute20, hr_api.g_varchar2) ))
378: or (p_rec.vehicle_repository_id is null) then
371: nvl(p_rec.vre_attribute17, hr_api.g_varchar2) or
372: nvl(pqp_vre_shd.g_old_rec.vre_attribute18, hr_api.g_varchar2) <>
373: nvl(p_rec.vre_attribute18, hr_api.g_varchar2) or
374: nvl(pqp_vre_shd.g_old_rec.vre_attribute19, hr_api.g_varchar2) <>
375: nvl(p_rec.vre_attribute19, hr_api.g_varchar2) or
376: nvl(pqp_vre_shd.g_old_rec.vre_attribute20, hr_api.g_varchar2) <>
377: nvl(p_rec.vre_attribute20, hr_api.g_varchar2) ))
378: or (p_rec.vehicle_repository_id is null) then
379: --
372: nvl(pqp_vre_shd.g_old_rec.vre_attribute18, hr_api.g_varchar2) <>
373: nvl(p_rec.vre_attribute18, hr_api.g_varchar2) or
374: nvl(pqp_vre_shd.g_old_rec.vre_attribute19, hr_api.g_varchar2) <>
375: nvl(p_rec.vre_attribute19, hr_api.g_varchar2) or
376: nvl(pqp_vre_shd.g_old_rec.vre_attribute20, hr_api.g_varchar2) <>
377: nvl(p_rec.vre_attribute20, hr_api.g_varchar2) ))
378: or (p_rec.vehicle_repository_id is null) then
379: --
380: -- Only execute the validation if absolutely necessary:
373: nvl(p_rec.vre_attribute18, hr_api.g_varchar2) or
374: nvl(pqp_vre_shd.g_old_rec.vre_attribute19, hr_api.g_varchar2) <>
375: nvl(p_rec.vre_attribute19, hr_api.g_varchar2) or
376: nvl(pqp_vre_shd.g_old_rec.vre_attribute20, hr_api.g_varchar2) <>
377: nvl(p_rec.vre_attribute20, hr_api.g_varchar2) ))
378: or (p_rec.vehicle_repository_id is null) then
379: --
380: -- Only execute the validation if absolutely necessary:
381: -- a) During update, the structure column value or any
527: BEGIN
528: --
529: -- Ensure that the p_datetrack_mode argument is not null
530: --
531: hr_api.mandatory_arg_error
532: (p_api_name => l_proc
533: ,p_argument => 'datetrack_mode'
534: ,p_argument_value => p_datetrack_mode
535: );
537: -- Mode will be valid, as this is checked at the start of the upd.
538: --
539: -- Ensure the arguments are not null
540: --
541: hr_api.mandatory_arg_error
542: (p_api_name => l_proc
543: ,p_argument => 'validation_start_date'
544: ,p_argument_value => p_validation_start_date
545: );
543: ,p_argument => 'validation_start_date'
544: ,p_argument_value => p_validation_start_date
545: );
546: --
547: hr_api.mandatory_arg_error
548: (p_api_name => l_proc
549: ,p_argument => 'validation_end_date'
550: ,p_argument_value => p_validation_end_date
551: );
611: BEGIN
612: --
613: -- Ensure that the p_datetrack_mode argument is not null
614: --
615: hr_api.mandatory_arg_error
616: (p_api_name => l_proc
617: ,p_argument => 'datetrack_mode'
618: ,p_argument_value => p_datetrack_mode
619: );
620: --
621: -- Only perform the validation if the datetrack mode is either
622: -- DELETE or ZAP
623: --
624: IF (p_datetrack_mode = hr_api.g_delete or
625: p_datetrack_mode = hr_api.g_zap) THEN
626: --
627: --
628: -- Ensure the arguments are not null
621: -- Only perform the validation if the datetrack mode is either
622: -- DELETE or ZAP
623: --
624: IF (p_datetrack_mode = hr_api.g_delete or
625: p_datetrack_mode = hr_api.g_zap) THEN
626: --
627: --
628: -- Ensure the arguments are not null
629: --
626: --
627: --
628: -- Ensure the arguments are not null
629: --
630: hr_api.mandatory_arg_error
631: (p_api_name => l_proc
632: ,p_argument => 'validation_start_date'
633: ,p_argument_value => p_validation_start_date
634: );
632: ,p_argument => 'validation_start_date'
633: ,p_argument_value => p_validation_start_date
634: );
635: --
636: hr_api.mandatory_arg_error
637: (p_api_name => l_proc
638: ,p_argument => 'validation_end_date'
639: ,p_argument_value => p_validation_end_date
640: );
638: ,p_argument => 'validation_end_date'
639: ,p_argument_value => p_validation_end_date
640: );
641: --
642: hr_api.mandatory_arg_error
643: (p_api_name => l_proc
644: ,p_argument => 'vehicle_repository_id'
645: ,p_argument_value => p_vehicle_repository_id
646: );
909: --Getting the legislationId for business groupId
910: l_legislation_code :=
911: pqp_vre_bus.get_legislation_code(p_business_group_id);
912: --setting the lg context
913: hr_api.set_legislation_context(l_legislation_code);
914: OPEN fiscal_cursor;
915: FETCH fiscal_cursor INTO l_meaning;
916: CLOSE fiscal_cursor;
917: p_meaning := NVL(l_meaning,'NONE');
939: -- Check if the argument value exists in hr_lookups
940: -- where the lookup_type is passed lookuptype
941: --
942: IF p_lookup_code IS NOT NULL then
943: IF hr_api.not_exists_in_dt_hrstanlookups
944: (p_effective_date => p_effective_date
945: ,p_validation_start_date => p_validation_start_date
946: ,p_validation_end_date => p_validation_end_date
947: ,p_lookup_type => p_lookup_type
1483:
1484: --
1485: -- Call all supporting business operations
1486: --
1487: hr_api.validate_bus_grp_id
1488: (p_business_group_id => p_rec.business_group_id
1489: ,p_associated_column1 => pqp_vre_shd.g_tab_nam
1490: || '.BUSINESS_GROUP_ID');
1491:
1854: -- Call all supporting business operations
1855: --
1856:
1857:
1858: hr_api.validate_bus_grp_id
1859: (p_business_group_id => p_rec.business_group_id
1860: ,p_associated_column1 => pqp_vre_shd.g_tab_nam
1861: || '.BUSINESS_GROUP_ID');
1862:
2082: END IF;
2083:
2084:
2085: --Checking for value change
2086: IF ( nvl(pqp_vre_shd.g_old_rec.vehicle_status,hr_api.g_varchar2)
2087: <> nvl(p_rec.vehicle_status,hr_api.g_varchar2) ) THEN
2088:
2089: --Checking If Vehicle Status is Inactive then inactive reason is mandatory
2090: --and should check with lookup
2083:
2084:
2085: --Checking for value change
2086: IF ( nvl(pqp_vre_shd.g_old_rec.vehicle_status,hr_api.g_varchar2)
2087: <> nvl(p_rec.vehicle_status,hr_api.g_varchar2) ) THEN
2088:
2089: --Checking If Vehicle Status is Inactive then inactive reason is mandatory
2090: --and should check with lookup
2091: IF p_rec.vehicle_status = 'I' THEN
2111: END IF;
2112: END IF;
2113:
2114: --Checking for value change
2115: IF ( nvl(pqp_vre_shd.g_old_rec.vehicle_ownership,hr_api.g_varchar2)
2116: <> nvl(p_rec.vehicle_ownership,hr_api.g_varchar2) ) THEN
2117: --If not equal then Checking Ownership lookup validation
2118: l_return_status := chk_lookup(
2119: p_vehicle_repository_id => p_rec.vehicle_repository_id
2112: END IF;
2113:
2114: --Checking for value change
2115: IF ( nvl(pqp_vre_shd.g_old_rec.vehicle_ownership,hr_api.g_varchar2)
2116: <> nvl(p_rec.vehicle_ownership,hr_api.g_varchar2) ) THEN
2117: --If not equal then Checking Ownership lookup validation
2118: l_return_status := chk_lookup(
2119: p_vehicle_repository_id => p_rec.vehicle_repository_id
2120: ,p_lookup_type =>'PQP_VEHICLE_OWNERSHIP_TYPE'
2129: END IF;
2130: END IF;
2131:
2132: --Checking for value change
2133: IF ( nvl(pqp_vre_shd.g_old_rec.vehicle_status,hr_api.g_varchar2)
2134: <> nvl(p_rec.vehicle_status,hr_api.g_varchar2) ) THEN
2135: --If not equal then Checking vehicle_status lookup validation
2136: l_return_status := chk_lookup(
2137: p_vehicle_repository_id => p_rec.vehicle_repository_id
2130: END IF;
2131:
2132: --Checking for value change
2133: IF ( nvl(pqp_vre_shd.g_old_rec.vehicle_status,hr_api.g_varchar2)
2134: <> nvl(p_rec.vehicle_status,hr_api.g_varchar2) ) THEN
2135: --If not equal then Checking vehicle_status lookup validation
2136: l_return_status := chk_lookup(
2137: p_vehicle_repository_id => p_rec.vehicle_repository_id
2138: ,p_lookup_type =>'PQP_VEHICLE_STATUS'
2147: END IF;
2148: END IF;
2149:
2150: --Checking for value change
2151: IF ( nvl(pqp_vre_shd.g_old_rec.fuel_type,hr_api.g_varchar2)
2152: <> nvl(p_rec.fuel_type,hr_api.g_varchar2) ) THEN
2153: --Checking Fuel Type lookup validation
2154: l_return_status := chk_lookup(
2155: p_vehicle_repository_id => p_rec.vehicle_repository_id
2148: END IF;
2149:
2150: --Checking for value change
2151: IF ( nvl(pqp_vre_shd.g_old_rec.fuel_type,hr_api.g_varchar2)
2152: <> nvl(p_rec.fuel_type,hr_api.g_varchar2) ) THEN
2153: --Checking Fuel Type lookup validation
2154: l_return_status := chk_lookup(
2155: p_vehicle_repository_id => p_rec.vehicle_repository_id
2156: ,p_lookup_type =>'PQP_FUEL_TYPE'
2164: END IF;
2165: END IF;
2166:
2167: --Checking for value change
2168: IF ( nvl(pqp_vre_shd.g_old_rec.vehicle_type,hr_api.g_varchar2)
2169: <> nvl(p_rec.vehicle_type,hr_api.g_varchar2) ) THEN
2170: --Checking Vehicle Type lookup validation
2171: l_return_status := chk_lookup(
2172: p_vehicle_repository_id => p_rec.vehicle_repository_id
2165: END IF;
2166:
2167: --Checking for value change
2168: IF ( nvl(pqp_vre_shd.g_old_rec.vehicle_type,hr_api.g_varchar2)
2169: <> nvl(p_rec.vehicle_type,hr_api.g_varchar2) ) THEN
2170: --Checking Vehicle Type lookup validation
2171: l_return_status := chk_lookup(
2172: p_vehicle_repository_id => p_rec.vehicle_repository_id
2173: ,p_lookup_type =>'PQP_VEHICLE_TYPE'