APPS.PER_PAC_BUS dependencies on HR_API

Line 52: hr_api.mandatory_arg_error

48: hr_utility.set_location('Entering:'|| l_proc, 10);
49: --
50: -- Ensure that all the mandatory parameter are not null
51: --
52: hr_api.mandatory_arg_error
53: (p_api_name => l_proc
54: ,p_argument => 'allocated_checklist_id'
55: ,p_argument_value => p_allocated_checklist_id
56: );

Line 79: hr_api.set_security_group_id

75: close csr_sec_grp;
76: --
77: -- Set the security_group_id in CLIENT_INFO
78: --
79: hr_api.set_security_group_id
80: (p_security_group_id => l_security_group_id
81: );
82: --
83: -- Set the sessions legislation context in HR_SESSION_DATA

Line 85: hr_api.set_legislation_context(l_legislation_code);

81: );
82: --
83: -- Set the sessions legislation context in HR_SESSION_DATA
84: --
85: hr_api.set_legislation_context(l_legislation_code);
86: end if;
87: --
88: hr_utility.set_location(' Leaving:'|| l_proc, 20);
89: --

Line 127: hr_api.mandatory_arg_error

123: hr_utility.set_location('Entering:'|| l_proc, 10);
124: --
125: -- Ensure that all the mandatory parameter are not null
126: --
127: hr_api.mandatory_arg_error
128: (p_api_name => l_proc
129: ,p_argument => 'allocated_checklist_id'
130: ,p_argument_value => p_allocated_checklist_id
131: );

Line 133: if ( nvl(per_pac_bus.g_allocated_checklist_id, hr_api.g_number)

129: ,p_argument => 'allocated_checklist_id'
130: ,p_argument_value => p_allocated_checklist_id
131: );
132: --
133: if ( nvl(per_pac_bus.g_allocated_checklist_id, hr_api.g_number)
134: = p_allocated_checklist_id) then
135: --
136: -- The legislation code has already been found with a previous
137: -- call to this function. Just return the value in the global

Line 213: AND NVL(per_pac_shd.g_old_rec.checklist_name, hr_api.g_varchar2) = nvl(p_checklist_name,hr_api.g_varchar2)

209: ,p_object_version_number => p_object_version_number
210: );
211:
212: IF (l_api_updating
213: AND NVL(per_pac_shd.g_old_rec.checklist_name, hr_api.g_varchar2) = nvl(p_checklist_name,hr_api.g_varchar2)
214: )
215: THEN
216: RETURN;
217: END IF;

Line 296: nvl(per_pac_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

292: hr_utility.set_location('Entering:'||l_proc,10);
293: --
294: /*
295: if ((p_rec.allocated_checklist_id is not null) and (
296: nvl(per_pac_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
297: nvl(p_rec.information_category, hr_api.g_varchar2) or
298: nvl(per_pac_shd.g_old_rec.information1, hr_api.g_varchar2) <>
299: nvl(p_rec.information1, hr_api.g_varchar2) or
300: nvl(per_pac_shd.g_old_rec.information2, hr_api.g_varchar2) <>

Line 297: nvl(p_rec.information_category, hr_api.g_varchar2) or

293: --
294: /*
295: if ((p_rec.allocated_checklist_id is not null) and (
296: nvl(per_pac_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
297: nvl(p_rec.information_category, hr_api.g_varchar2) or
298: nvl(per_pac_shd.g_old_rec.information1, hr_api.g_varchar2) <>
299: nvl(p_rec.information1, hr_api.g_varchar2) or
300: nvl(per_pac_shd.g_old_rec.information2, hr_api.g_varchar2) <>
301: nvl(p_rec.information2, hr_api.g_varchar2) or

Line 298: nvl(per_pac_shd.g_old_rec.information1, hr_api.g_varchar2) <>

294: /*
295: if ((p_rec.allocated_checklist_id is not null) and (
296: nvl(per_pac_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
297: nvl(p_rec.information_category, hr_api.g_varchar2) or
298: nvl(per_pac_shd.g_old_rec.information1, hr_api.g_varchar2) <>
299: nvl(p_rec.information1, hr_api.g_varchar2) or
300: nvl(per_pac_shd.g_old_rec.information2, hr_api.g_varchar2) <>
301: nvl(p_rec.information2, hr_api.g_varchar2) or
302: nvl(per_pac_shd.g_old_rec.information3, hr_api.g_varchar2) <>

Line 299: nvl(p_rec.information1, hr_api.g_varchar2) or

295: if ((p_rec.allocated_checklist_id is not null) and (
296: nvl(per_pac_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
297: nvl(p_rec.information_category, hr_api.g_varchar2) or
298: nvl(per_pac_shd.g_old_rec.information1, hr_api.g_varchar2) <>
299: nvl(p_rec.information1, hr_api.g_varchar2) or
300: nvl(per_pac_shd.g_old_rec.information2, hr_api.g_varchar2) <>
301: nvl(p_rec.information2, hr_api.g_varchar2) or
302: nvl(per_pac_shd.g_old_rec.information3, hr_api.g_varchar2) <>
303: nvl(p_rec.information3, hr_api.g_varchar2) or

Line 300: nvl(per_pac_shd.g_old_rec.information2, hr_api.g_varchar2) <>

296: nvl(per_pac_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
297: nvl(p_rec.information_category, hr_api.g_varchar2) or
298: nvl(per_pac_shd.g_old_rec.information1, hr_api.g_varchar2) <>
299: nvl(p_rec.information1, hr_api.g_varchar2) or
300: nvl(per_pac_shd.g_old_rec.information2, hr_api.g_varchar2) <>
301: nvl(p_rec.information2, hr_api.g_varchar2) or
302: nvl(per_pac_shd.g_old_rec.information3, hr_api.g_varchar2) <>
303: nvl(p_rec.information3, hr_api.g_varchar2) or
304: nvl(per_pac_shd.g_old_rec.information4, hr_api.g_varchar2) <>

Line 301: nvl(p_rec.information2, hr_api.g_varchar2) or

297: nvl(p_rec.information_category, hr_api.g_varchar2) or
298: nvl(per_pac_shd.g_old_rec.information1, hr_api.g_varchar2) <>
299: nvl(p_rec.information1, hr_api.g_varchar2) or
300: nvl(per_pac_shd.g_old_rec.information2, hr_api.g_varchar2) <>
301: nvl(p_rec.information2, hr_api.g_varchar2) or
302: nvl(per_pac_shd.g_old_rec.information3, hr_api.g_varchar2) <>
303: nvl(p_rec.information3, hr_api.g_varchar2) or
304: nvl(per_pac_shd.g_old_rec.information4, hr_api.g_varchar2) <>
305: nvl(p_rec.information4, hr_api.g_varchar2) or

Line 302: nvl(per_pac_shd.g_old_rec.information3, hr_api.g_varchar2) <>

298: nvl(per_pac_shd.g_old_rec.information1, hr_api.g_varchar2) <>
299: nvl(p_rec.information1, hr_api.g_varchar2) or
300: nvl(per_pac_shd.g_old_rec.information2, hr_api.g_varchar2) <>
301: nvl(p_rec.information2, hr_api.g_varchar2) or
302: nvl(per_pac_shd.g_old_rec.information3, hr_api.g_varchar2) <>
303: nvl(p_rec.information3, hr_api.g_varchar2) or
304: nvl(per_pac_shd.g_old_rec.information4, hr_api.g_varchar2) <>
305: nvl(p_rec.information4, hr_api.g_varchar2) or
306: nvl(per_pac_shd.g_old_rec.information5, hr_api.g_varchar2) <>

Line 303: nvl(p_rec.information3, hr_api.g_varchar2) or

299: nvl(p_rec.information1, hr_api.g_varchar2) or
300: nvl(per_pac_shd.g_old_rec.information2, hr_api.g_varchar2) <>
301: nvl(p_rec.information2, hr_api.g_varchar2) or
302: nvl(per_pac_shd.g_old_rec.information3, hr_api.g_varchar2) <>
303: nvl(p_rec.information3, hr_api.g_varchar2) or
304: nvl(per_pac_shd.g_old_rec.information4, hr_api.g_varchar2) <>
305: nvl(p_rec.information4, hr_api.g_varchar2) or
306: nvl(per_pac_shd.g_old_rec.information5, hr_api.g_varchar2) <>
307: nvl(p_rec.information5, hr_api.g_varchar2) or

Line 304: nvl(per_pac_shd.g_old_rec.information4, hr_api.g_varchar2) <>

300: nvl(per_pac_shd.g_old_rec.information2, hr_api.g_varchar2) <>
301: nvl(p_rec.information2, hr_api.g_varchar2) or
302: nvl(per_pac_shd.g_old_rec.information3, hr_api.g_varchar2) <>
303: nvl(p_rec.information3, hr_api.g_varchar2) or
304: nvl(per_pac_shd.g_old_rec.information4, hr_api.g_varchar2) <>
305: nvl(p_rec.information4, hr_api.g_varchar2) or
306: nvl(per_pac_shd.g_old_rec.information5, hr_api.g_varchar2) <>
307: nvl(p_rec.information5, hr_api.g_varchar2) or
308: nvl(per_pac_shd.g_old_rec.information6, hr_api.g_varchar2) <>

Line 305: nvl(p_rec.information4, hr_api.g_varchar2) or

301: nvl(p_rec.information2, hr_api.g_varchar2) or
302: nvl(per_pac_shd.g_old_rec.information3, hr_api.g_varchar2) <>
303: nvl(p_rec.information3, hr_api.g_varchar2) or
304: nvl(per_pac_shd.g_old_rec.information4, hr_api.g_varchar2) <>
305: nvl(p_rec.information4, hr_api.g_varchar2) or
306: nvl(per_pac_shd.g_old_rec.information5, hr_api.g_varchar2) <>
307: nvl(p_rec.information5, hr_api.g_varchar2) or
308: nvl(per_pac_shd.g_old_rec.information6, hr_api.g_varchar2) <>
309: nvl(p_rec.information6, hr_api.g_varchar2) or

Line 306: nvl(per_pac_shd.g_old_rec.information5, hr_api.g_varchar2) <>

302: nvl(per_pac_shd.g_old_rec.information3, hr_api.g_varchar2) <>
303: nvl(p_rec.information3, hr_api.g_varchar2) or
304: nvl(per_pac_shd.g_old_rec.information4, hr_api.g_varchar2) <>
305: nvl(p_rec.information4, hr_api.g_varchar2) or
306: nvl(per_pac_shd.g_old_rec.information5, hr_api.g_varchar2) <>
307: nvl(p_rec.information5, hr_api.g_varchar2) or
308: nvl(per_pac_shd.g_old_rec.information6, hr_api.g_varchar2) <>
309: nvl(p_rec.information6, hr_api.g_varchar2) or
310: nvl(per_pac_shd.g_old_rec.information7, hr_api.g_varchar2) <>

Line 307: nvl(p_rec.information5, hr_api.g_varchar2) or

303: nvl(p_rec.information3, hr_api.g_varchar2) or
304: nvl(per_pac_shd.g_old_rec.information4, hr_api.g_varchar2) <>
305: nvl(p_rec.information4, hr_api.g_varchar2) or
306: nvl(per_pac_shd.g_old_rec.information5, hr_api.g_varchar2) <>
307: nvl(p_rec.information5, hr_api.g_varchar2) or
308: nvl(per_pac_shd.g_old_rec.information6, hr_api.g_varchar2) <>
309: nvl(p_rec.information6, hr_api.g_varchar2) or
310: nvl(per_pac_shd.g_old_rec.information7, hr_api.g_varchar2) <>
311: nvl(p_rec.information7, hr_api.g_varchar2) or

Line 308: nvl(per_pac_shd.g_old_rec.information6, hr_api.g_varchar2) <>

304: nvl(per_pac_shd.g_old_rec.information4, hr_api.g_varchar2) <>
305: nvl(p_rec.information4, hr_api.g_varchar2) or
306: nvl(per_pac_shd.g_old_rec.information5, hr_api.g_varchar2) <>
307: nvl(p_rec.information5, hr_api.g_varchar2) or
308: nvl(per_pac_shd.g_old_rec.information6, hr_api.g_varchar2) <>
309: nvl(p_rec.information6, hr_api.g_varchar2) or
310: nvl(per_pac_shd.g_old_rec.information7, hr_api.g_varchar2) <>
311: nvl(p_rec.information7, hr_api.g_varchar2) or
312: nvl(per_pac_shd.g_old_rec.information8, hr_api.g_varchar2) <>

Line 309: nvl(p_rec.information6, hr_api.g_varchar2) or

305: nvl(p_rec.information4, hr_api.g_varchar2) or
306: nvl(per_pac_shd.g_old_rec.information5, hr_api.g_varchar2) <>
307: nvl(p_rec.information5, hr_api.g_varchar2) or
308: nvl(per_pac_shd.g_old_rec.information6, hr_api.g_varchar2) <>
309: nvl(p_rec.information6, hr_api.g_varchar2) or
310: nvl(per_pac_shd.g_old_rec.information7, hr_api.g_varchar2) <>
311: nvl(p_rec.information7, hr_api.g_varchar2) or
312: nvl(per_pac_shd.g_old_rec.information8, hr_api.g_varchar2) <>
313: nvl(p_rec.information8, hr_api.g_varchar2) or

Line 310: nvl(per_pac_shd.g_old_rec.information7, hr_api.g_varchar2) <>

306: nvl(per_pac_shd.g_old_rec.information5, hr_api.g_varchar2) <>
307: nvl(p_rec.information5, hr_api.g_varchar2) or
308: nvl(per_pac_shd.g_old_rec.information6, hr_api.g_varchar2) <>
309: nvl(p_rec.information6, hr_api.g_varchar2) or
310: nvl(per_pac_shd.g_old_rec.information7, hr_api.g_varchar2) <>
311: nvl(p_rec.information7, hr_api.g_varchar2) or
312: nvl(per_pac_shd.g_old_rec.information8, hr_api.g_varchar2) <>
313: nvl(p_rec.information8, hr_api.g_varchar2) or
314: nvl(per_pac_shd.g_old_rec.information9, hr_api.g_varchar2) <>

Line 311: nvl(p_rec.information7, hr_api.g_varchar2) or

307: nvl(p_rec.information5, hr_api.g_varchar2) or
308: nvl(per_pac_shd.g_old_rec.information6, hr_api.g_varchar2) <>
309: nvl(p_rec.information6, hr_api.g_varchar2) or
310: nvl(per_pac_shd.g_old_rec.information7, hr_api.g_varchar2) <>
311: nvl(p_rec.information7, hr_api.g_varchar2) or
312: nvl(per_pac_shd.g_old_rec.information8, hr_api.g_varchar2) <>
313: nvl(p_rec.information8, hr_api.g_varchar2) or
314: nvl(per_pac_shd.g_old_rec.information9, hr_api.g_varchar2) <>
315: nvl(p_rec.information9, hr_api.g_varchar2) or

Line 312: nvl(per_pac_shd.g_old_rec.information8, hr_api.g_varchar2) <>

308: nvl(per_pac_shd.g_old_rec.information6, hr_api.g_varchar2) <>
309: nvl(p_rec.information6, hr_api.g_varchar2) or
310: nvl(per_pac_shd.g_old_rec.information7, hr_api.g_varchar2) <>
311: nvl(p_rec.information7, hr_api.g_varchar2) or
312: nvl(per_pac_shd.g_old_rec.information8, hr_api.g_varchar2) <>
313: nvl(p_rec.information8, hr_api.g_varchar2) or
314: nvl(per_pac_shd.g_old_rec.information9, hr_api.g_varchar2) <>
315: nvl(p_rec.information9, hr_api.g_varchar2) or
316: nvl(per_pac_shd.g_old_rec.information10, hr_api.g_varchar2) <>

Line 313: nvl(p_rec.information8, hr_api.g_varchar2) or

309: nvl(p_rec.information6, hr_api.g_varchar2) or
310: nvl(per_pac_shd.g_old_rec.information7, hr_api.g_varchar2) <>
311: nvl(p_rec.information7, hr_api.g_varchar2) or
312: nvl(per_pac_shd.g_old_rec.information8, hr_api.g_varchar2) <>
313: nvl(p_rec.information8, hr_api.g_varchar2) or
314: nvl(per_pac_shd.g_old_rec.information9, hr_api.g_varchar2) <>
315: nvl(p_rec.information9, hr_api.g_varchar2) or
316: nvl(per_pac_shd.g_old_rec.information10, hr_api.g_varchar2) <>
317: nvl(p_rec.information10, hr_api.g_varchar2) or

Line 314: nvl(per_pac_shd.g_old_rec.information9, hr_api.g_varchar2) <>

310: nvl(per_pac_shd.g_old_rec.information7, hr_api.g_varchar2) <>
311: nvl(p_rec.information7, hr_api.g_varchar2) or
312: nvl(per_pac_shd.g_old_rec.information8, hr_api.g_varchar2) <>
313: nvl(p_rec.information8, hr_api.g_varchar2) or
314: nvl(per_pac_shd.g_old_rec.information9, hr_api.g_varchar2) <>
315: nvl(p_rec.information9, hr_api.g_varchar2) or
316: nvl(per_pac_shd.g_old_rec.information10, hr_api.g_varchar2) <>
317: nvl(p_rec.information10, hr_api.g_varchar2) or
318: nvl(per_pac_shd.g_old_rec.information11, hr_api.g_varchar2) <>

Line 315: nvl(p_rec.information9, hr_api.g_varchar2) or

311: nvl(p_rec.information7, hr_api.g_varchar2) or
312: nvl(per_pac_shd.g_old_rec.information8, hr_api.g_varchar2) <>
313: nvl(p_rec.information8, hr_api.g_varchar2) or
314: nvl(per_pac_shd.g_old_rec.information9, hr_api.g_varchar2) <>
315: nvl(p_rec.information9, hr_api.g_varchar2) or
316: nvl(per_pac_shd.g_old_rec.information10, hr_api.g_varchar2) <>
317: nvl(p_rec.information10, hr_api.g_varchar2) or
318: nvl(per_pac_shd.g_old_rec.information11, hr_api.g_varchar2) <>
319: nvl(p_rec.information11, hr_api.g_varchar2) or

Line 316: nvl(per_pac_shd.g_old_rec.information10, hr_api.g_varchar2) <>

312: nvl(per_pac_shd.g_old_rec.information8, hr_api.g_varchar2) <>
313: nvl(p_rec.information8, hr_api.g_varchar2) or
314: nvl(per_pac_shd.g_old_rec.information9, hr_api.g_varchar2) <>
315: nvl(p_rec.information9, hr_api.g_varchar2) or
316: nvl(per_pac_shd.g_old_rec.information10, hr_api.g_varchar2) <>
317: nvl(p_rec.information10, hr_api.g_varchar2) or
318: nvl(per_pac_shd.g_old_rec.information11, hr_api.g_varchar2) <>
319: nvl(p_rec.information11, hr_api.g_varchar2) or
320: nvl(per_pac_shd.g_old_rec.information12, hr_api.g_varchar2) <>

Line 317: nvl(p_rec.information10, hr_api.g_varchar2) or

313: nvl(p_rec.information8, hr_api.g_varchar2) or
314: nvl(per_pac_shd.g_old_rec.information9, hr_api.g_varchar2) <>
315: nvl(p_rec.information9, hr_api.g_varchar2) or
316: nvl(per_pac_shd.g_old_rec.information10, hr_api.g_varchar2) <>
317: nvl(p_rec.information10, hr_api.g_varchar2) or
318: nvl(per_pac_shd.g_old_rec.information11, hr_api.g_varchar2) <>
319: nvl(p_rec.information11, hr_api.g_varchar2) or
320: nvl(per_pac_shd.g_old_rec.information12, hr_api.g_varchar2) <>
321: nvl(p_rec.information12, hr_api.g_varchar2) or

Line 318: nvl(per_pac_shd.g_old_rec.information11, hr_api.g_varchar2) <>

314: nvl(per_pac_shd.g_old_rec.information9, hr_api.g_varchar2) <>
315: nvl(p_rec.information9, hr_api.g_varchar2) or
316: nvl(per_pac_shd.g_old_rec.information10, hr_api.g_varchar2) <>
317: nvl(p_rec.information10, hr_api.g_varchar2) or
318: nvl(per_pac_shd.g_old_rec.information11, hr_api.g_varchar2) <>
319: nvl(p_rec.information11, hr_api.g_varchar2) or
320: nvl(per_pac_shd.g_old_rec.information12, hr_api.g_varchar2) <>
321: nvl(p_rec.information12, hr_api.g_varchar2) or
322: nvl(per_pac_shd.g_old_rec.information13, hr_api.g_varchar2) <>

Line 319: nvl(p_rec.information11, hr_api.g_varchar2) or

315: nvl(p_rec.information9, hr_api.g_varchar2) or
316: nvl(per_pac_shd.g_old_rec.information10, hr_api.g_varchar2) <>
317: nvl(p_rec.information10, hr_api.g_varchar2) or
318: nvl(per_pac_shd.g_old_rec.information11, hr_api.g_varchar2) <>
319: nvl(p_rec.information11, hr_api.g_varchar2) or
320: nvl(per_pac_shd.g_old_rec.information12, hr_api.g_varchar2) <>
321: nvl(p_rec.information12, hr_api.g_varchar2) or
322: nvl(per_pac_shd.g_old_rec.information13, hr_api.g_varchar2) <>
323: nvl(p_rec.information13, hr_api.g_varchar2) or

Line 320: nvl(per_pac_shd.g_old_rec.information12, hr_api.g_varchar2) <>

316: nvl(per_pac_shd.g_old_rec.information10, hr_api.g_varchar2) <>
317: nvl(p_rec.information10, hr_api.g_varchar2) or
318: nvl(per_pac_shd.g_old_rec.information11, hr_api.g_varchar2) <>
319: nvl(p_rec.information11, hr_api.g_varchar2) or
320: nvl(per_pac_shd.g_old_rec.information12, hr_api.g_varchar2) <>
321: nvl(p_rec.information12, hr_api.g_varchar2) or
322: nvl(per_pac_shd.g_old_rec.information13, hr_api.g_varchar2) <>
323: nvl(p_rec.information13, hr_api.g_varchar2) or
324: nvl(per_pac_shd.g_old_rec.information14, hr_api.g_varchar2) <>

Line 321: nvl(p_rec.information12, hr_api.g_varchar2) or

317: nvl(p_rec.information10, hr_api.g_varchar2) or
318: nvl(per_pac_shd.g_old_rec.information11, hr_api.g_varchar2) <>
319: nvl(p_rec.information11, hr_api.g_varchar2) or
320: nvl(per_pac_shd.g_old_rec.information12, hr_api.g_varchar2) <>
321: nvl(p_rec.information12, hr_api.g_varchar2) or
322: nvl(per_pac_shd.g_old_rec.information13, hr_api.g_varchar2) <>
323: nvl(p_rec.information13, hr_api.g_varchar2) or
324: nvl(per_pac_shd.g_old_rec.information14, hr_api.g_varchar2) <>
325: nvl(p_rec.information14, hr_api.g_varchar2) or

Line 322: nvl(per_pac_shd.g_old_rec.information13, hr_api.g_varchar2) <>

318: nvl(per_pac_shd.g_old_rec.information11, hr_api.g_varchar2) <>
319: nvl(p_rec.information11, hr_api.g_varchar2) or
320: nvl(per_pac_shd.g_old_rec.information12, hr_api.g_varchar2) <>
321: nvl(p_rec.information12, hr_api.g_varchar2) or
322: nvl(per_pac_shd.g_old_rec.information13, hr_api.g_varchar2) <>
323: nvl(p_rec.information13, hr_api.g_varchar2) or
324: nvl(per_pac_shd.g_old_rec.information14, hr_api.g_varchar2) <>
325: nvl(p_rec.information14, hr_api.g_varchar2) or
326: nvl(per_pac_shd.g_old_rec.information15, hr_api.g_varchar2) <>

Line 323: nvl(p_rec.information13, hr_api.g_varchar2) or

319: nvl(p_rec.information11, hr_api.g_varchar2) or
320: nvl(per_pac_shd.g_old_rec.information12, hr_api.g_varchar2) <>
321: nvl(p_rec.information12, hr_api.g_varchar2) or
322: nvl(per_pac_shd.g_old_rec.information13, hr_api.g_varchar2) <>
323: nvl(p_rec.information13, hr_api.g_varchar2) or
324: nvl(per_pac_shd.g_old_rec.information14, hr_api.g_varchar2) <>
325: nvl(p_rec.information14, hr_api.g_varchar2) or
326: nvl(per_pac_shd.g_old_rec.information15, hr_api.g_varchar2) <>
327: nvl(p_rec.information15, hr_api.g_varchar2) or

Line 324: nvl(per_pac_shd.g_old_rec.information14, hr_api.g_varchar2) <>

320: nvl(per_pac_shd.g_old_rec.information12, hr_api.g_varchar2) <>
321: nvl(p_rec.information12, hr_api.g_varchar2) or
322: nvl(per_pac_shd.g_old_rec.information13, hr_api.g_varchar2) <>
323: nvl(p_rec.information13, hr_api.g_varchar2) or
324: nvl(per_pac_shd.g_old_rec.information14, hr_api.g_varchar2) <>
325: nvl(p_rec.information14, hr_api.g_varchar2) or
326: nvl(per_pac_shd.g_old_rec.information15, hr_api.g_varchar2) <>
327: nvl(p_rec.information15, hr_api.g_varchar2) or
328: nvl(per_pac_shd.g_old_rec.information16, hr_api.g_varchar2) <>

Line 325: nvl(p_rec.information14, hr_api.g_varchar2) or

321: nvl(p_rec.information12, hr_api.g_varchar2) or
322: nvl(per_pac_shd.g_old_rec.information13, hr_api.g_varchar2) <>
323: nvl(p_rec.information13, hr_api.g_varchar2) or
324: nvl(per_pac_shd.g_old_rec.information14, hr_api.g_varchar2) <>
325: nvl(p_rec.information14, hr_api.g_varchar2) or
326: nvl(per_pac_shd.g_old_rec.information15, hr_api.g_varchar2) <>
327: nvl(p_rec.information15, hr_api.g_varchar2) or
328: nvl(per_pac_shd.g_old_rec.information16, hr_api.g_varchar2) <>
329: nvl(p_rec.information16, hr_api.g_varchar2) or

Line 326: nvl(per_pac_shd.g_old_rec.information15, hr_api.g_varchar2) <>

322: nvl(per_pac_shd.g_old_rec.information13, hr_api.g_varchar2) <>
323: nvl(p_rec.information13, hr_api.g_varchar2) or
324: nvl(per_pac_shd.g_old_rec.information14, hr_api.g_varchar2) <>
325: nvl(p_rec.information14, hr_api.g_varchar2) or
326: nvl(per_pac_shd.g_old_rec.information15, hr_api.g_varchar2) <>
327: nvl(p_rec.information15, hr_api.g_varchar2) or
328: nvl(per_pac_shd.g_old_rec.information16, hr_api.g_varchar2) <>
329: nvl(p_rec.information16, hr_api.g_varchar2) or
330: nvl(per_pac_shd.g_old_rec.information17, hr_api.g_varchar2) <>

Line 327: nvl(p_rec.information15, hr_api.g_varchar2) or

323: nvl(p_rec.information13, hr_api.g_varchar2) or
324: nvl(per_pac_shd.g_old_rec.information14, hr_api.g_varchar2) <>
325: nvl(p_rec.information14, hr_api.g_varchar2) or
326: nvl(per_pac_shd.g_old_rec.information15, hr_api.g_varchar2) <>
327: nvl(p_rec.information15, hr_api.g_varchar2) or
328: nvl(per_pac_shd.g_old_rec.information16, hr_api.g_varchar2) <>
329: nvl(p_rec.information16, hr_api.g_varchar2) or
330: nvl(per_pac_shd.g_old_rec.information17, hr_api.g_varchar2) <>
331: nvl(p_rec.information17, hr_api.g_varchar2) or

Line 328: nvl(per_pac_shd.g_old_rec.information16, hr_api.g_varchar2) <>

324: nvl(per_pac_shd.g_old_rec.information14, hr_api.g_varchar2) <>
325: nvl(p_rec.information14, hr_api.g_varchar2) or
326: nvl(per_pac_shd.g_old_rec.information15, hr_api.g_varchar2) <>
327: nvl(p_rec.information15, hr_api.g_varchar2) or
328: nvl(per_pac_shd.g_old_rec.information16, hr_api.g_varchar2) <>
329: nvl(p_rec.information16, hr_api.g_varchar2) or
330: nvl(per_pac_shd.g_old_rec.information17, hr_api.g_varchar2) <>
331: nvl(p_rec.information17, hr_api.g_varchar2) or
332: nvl(per_pac_shd.g_old_rec.information18, hr_api.g_varchar2) <>

Line 329: nvl(p_rec.information16, hr_api.g_varchar2) or

325: nvl(p_rec.information14, hr_api.g_varchar2) or
326: nvl(per_pac_shd.g_old_rec.information15, hr_api.g_varchar2) <>
327: nvl(p_rec.information15, hr_api.g_varchar2) or
328: nvl(per_pac_shd.g_old_rec.information16, hr_api.g_varchar2) <>
329: nvl(p_rec.information16, hr_api.g_varchar2) or
330: nvl(per_pac_shd.g_old_rec.information17, hr_api.g_varchar2) <>
331: nvl(p_rec.information17, hr_api.g_varchar2) or
332: nvl(per_pac_shd.g_old_rec.information18, hr_api.g_varchar2) <>
333: nvl(p_rec.information18, hr_api.g_varchar2) or

Line 330: nvl(per_pac_shd.g_old_rec.information17, hr_api.g_varchar2) <>

326: nvl(per_pac_shd.g_old_rec.information15, hr_api.g_varchar2) <>
327: nvl(p_rec.information15, hr_api.g_varchar2) or
328: nvl(per_pac_shd.g_old_rec.information16, hr_api.g_varchar2) <>
329: nvl(p_rec.information16, hr_api.g_varchar2) or
330: nvl(per_pac_shd.g_old_rec.information17, hr_api.g_varchar2) <>
331: nvl(p_rec.information17, hr_api.g_varchar2) or
332: nvl(per_pac_shd.g_old_rec.information18, hr_api.g_varchar2) <>
333: nvl(p_rec.information18, hr_api.g_varchar2) or
334: nvl(per_pac_shd.g_old_rec.information19, hr_api.g_varchar2) <>

Line 331: nvl(p_rec.information17, hr_api.g_varchar2) or

327: nvl(p_rec.information15, hr_api.g_varchar2) or
328: nvl(per_pac_shd.g_old_rec.information16, hr_api.g_varchar2) <>
329: nvl(p_rec.information16, hr_api.g_varchar2) or
330: nvl(per_pac_shd.g_old_rec.information17, hr_api.g_varchar2) <>
331: nvl(p_rec.information17, hr_api.g_varchar2) or
332: nvl(per_pac_shd.g_old_rec.information18, hr_api.g_varchar2) <>
333: nvl(p_rec.information18, hr_api.g_varchar2) or
334: nvl(per_pac_shd.g_old_rec.information19, hr_api.g_varchar2) <>
335: nvl(p_rec.information19, hr_api.g_varchar2) or

Line 332: nvl(per_pac_shd.g_old_rec.information18, hr_api.g_varchar2) <>

328: nvl(per_pac_shd.g_old_rec.information16, hr_api.g_varchar2) <>
329: nvl(p_rec.information16, hr_api.g_varchar2) or
330: nvl(per_pac_shd.g_old_rec.information17, hr_api.g_varchar2) <>
331: nvl(p_rec.information17, hr_api.g_varchar2) or
332: nvl(per_pac_shd.g_old_rec.information18, hr_api.g_varchar2) <>
333: nvl(p_rec.information18, hr_api.g_varchar2) or
334: nvl(per_pac_shd.g_old_rec.information19, hr_api.g_varchar2) <>
335: nvl(p_rec.information19, hr_api.g_varchar2) or
336: nvl(per_pac_shd.g_old_rec.information20, hr_api.g_varchar2) <>

Line 333: nvl(p_rec.information18, hr_api.g_varchar2) or

329: nvl(p_rec.information16, hr_api.g_varchar2) or
330: nvl(per_pac_shd.g_old_rec.information17, hr_api.g_varchar2) <>
331: nvl(p_rec.information17, hr_api.g_varchar2) or
332: nvl(per_pac_shd.g_old_rec.information18, hr_api.g_varchar2) <>
333: nvl(p_rec.information18, hr_api.g_varchar2) or
334: nvl(per_pac_shd.g_old_rec.information19, hr_api.g_varchar2) <>
335: nvl(p_rec.information19, hr_api.g_varchar2) or
336: nvl(per_pac_shd.g_old_rec.information20, hr_api.g_varchar2) <>
337: nvl(p_rec.information20, hr_api.g_varchar2) ))

Line 334: nvl(per_pac_shd.g_old_rec.information19, hr_api.g_varchar2) <>

330: nvl(per_pac_shd.g_old_rec.information17, hr_api.g_varchar2) <>
331: nvl(p_rec.information17, hr_api.g_varchar2) or
332: nvl(per_pac_shd.g_old_rec.information18, hr_api.g_varchar2) <>
333: nvl(p_rec.information18, hr_api.g_varchar2) or
334: nvl(per_pac_shd.g_old_rec.information19, hr_api.g_varchar2) <>
335: nvl(p_rec.information19, hr_api.g_varchar2) or
336: nvl(per_pac_shd.g_old_rec.information20, hr_api.g_varchar2) <>
337: nvl(p_rec.information20, hr_api.g_varchar2) ))
338: or (p_rec.allocated_checklist_id is null) then

Line 335: nvl(p_rec.information19, hr_api.g_varchar2) or

331: nvl(p_rec.information17, hr_api.g_varchar2) or
332: nvl(per_pac_shd.g_old_rec.information18, hr_api.g_varchar2) <>
333: nvl(p_rec.information18, hr_api.g_varchar2) or
334: nvl(per_pac_shd.g_old_rec.information19, hr_api.g_varchar2) <>
335: nvl(p_rec.information19, hr_api.g_varchar2) or
336: nvl(per_pac_shd.g_old_rec.information20, hr_api.g_varchar2) <>
337: nvl(p_rec.information20, hr_api.g_varchar2) ))
338: or (p_rec.allocated_checklist_id is null) then
339: --

Line 336: nvl(per_pac_shd.g_old_rec.information20, hr_api.g_varchar2) <>

332: nvl(per_pac_shd.g_old_rec.information18, hr_api.g_varchar2) <>
333: nvl(p_rec.information18, hr_api.g_varchar2) or
334: nvl(per_pac_shd.g_old_rec.information19, hr_api.g_varchar2) <>
335: nvl(p_rec.information19, hr_api.g_varchar2) or
336: nvl(per_pac_shd.g_old_rec.information20, hr_api.g_varchar2) <>
337: nvl(p_rec.information20, hr_api.g_varchar2) ))
338: or (p_rec.allocated_checklist_id is null) then
339: --
340: -- Only execute the validation if absolutely necessary:

Line 337: nvl(p_rec.information20, hr_api.g_varchar2) ))

333: nvl(p_rec.information18, hr_api.g_varchar2) or
334: nvl(per_pac_shd.g_old_rec.information19, hr_api.g_varchar2) <>
335: nvl(p_rec.information19, hr_api.g_varchar2) or
336: nvl(per_pac_shd.g_old_rec.information20, hr_api.g_varchar2) <>
337: nvl(p_rec.information20, hr_api.g_varchar2) ))
338: or (p_rec.allocated_checklist_id is null) then
339: --
340: -- Only execute the validation if absolutely necessary:
341: -- a) During update, the structure column value or any

Line 435: nvl(per_pac_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

431: hr_utility.set_location('Entering:'||l_proc,10);
432: --
433: /*
434: if ((p_rec.allocated_checklist_id is not null) and (
435: nvl(per_pac_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
436: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
437: nvl(per_pac_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
438: nvl(p_rec.attribute1, hr_api.g_varchar2) or
439: nvl(per_pac_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

432: --
433: /*
434: if ((p_rec.allocated_checklist_id is not null) and (
435: nvl(per_pac_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
436: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
437: nvl(per_pac_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
438: nvl(p_rec.attribute1, hr_api.g_varchar2) or
439: nvl(per_pac_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
440: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 437: nvl(per_pac_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

433: /*
434: if ((p_rec.allocated_checklist_id is not null) and (
435: nvl(per_pac_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
436: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
437: nvl(per_pac_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
438: nvl(p_rec.attribute1, hr_api.g_varchar2) or
439: nvl(per_pac_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
440: nvl(p_rec.attribute2, hr_api.g_varchar2) or
441: nvl(per_pac_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

434: if ((p_rec.allocated_checklist_id is not null) and (
435: nvl(per_pac_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
436: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
437: nvl(per_pac_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
438: nvl(p_rec.attribute1, hr_api.g_varchar2) or
439: nvl(per_pac_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
440: nvl(p_rec.attribute2, hr_api.g_varchar2) or
441: nvl(per_pac_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
442: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 439: nvl(per_pac_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

435: nvl(per_pac_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
436: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
437: nvl(per_pac_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
438: nvl(p_rec.attribute1, hr_api.g_varchar2) or
439: nvl(per_pac_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
440: nvl(p_rec.attribute2, hr_api.g_varchar2) or
441: nvl(per_pac_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
442: nvl(p_rec.attribute3, hr_api.g_varchar2) or
443: nvl(per_pac_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

436: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
437: nvl(per_pac_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
438: nvl(p_rec.attribute1, hr_api.g_varchar2) or
439: nvl(per_pac_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
440: nvl(p_rec.attribute2, hr_api.g_varchar2) or
441: nvl(per_pac_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
442: nvl(p_rec.attribute3, hr_api.g_varchar2) or
443: nvl(per_pac_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
444: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 441: nvl(per_pac_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

437: nvl(per_pac_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
438: nvl(p_rec.attribute1, hr_api.g_varchar2) or
439: nvl(per_pac_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
440: nvl(p_rec.attribute2, hr_api.g_varchar2) or
441: nvl(per_pac_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
442: nvl(p_rec.attribute3, hr_api.g_varchar2) or
443: nvl(per_pac_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
444: nvl(p_rec.attribute4, hr_api.g_varchar2) or
445: nvl(per_pac_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

438: nvl(p_rec.attribute1, hr_api.g_varchar2) or
439: nvl(per_pac_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
440: nvl(p_rec.attribute2, hr_api.g_varchar2) or
441: nvl(per_pac_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
442: nvl(p_rec.attribute3, hr_api.g_varchar2) or
443: nvl(per_pac_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
444: nvl(p_rec.attribute4, hr_api.g_varchar2) or
445: nvl(per_pac_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
446: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 443: nvl(per_pac_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

439: nvl(per_pac_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
440: nvl(p_rec.attribute2, hr_api.g_varchar2) or
441: nvl(per_pac_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
442: nvl(p_rec.attribute3, hr_api.g_varchar2) or
443: nvl(per_pac_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
444: nvl(p_rec.attribute4, hr_api.g_varchar2) or
445: nvl(per_pac_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
446: nvl(p_rec.attribute5, hr_api.g_varchar2) or
447: nvl(per_pac_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

440: nvl(p_rec.attribute2, hr_api.g_varchar2) or
441: nvl(per_pac_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
442: nvl(p_rec.attribute3, hr_api.g_varchar2) or
443: nvl(per_pac_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
444: nvl(p_rec.attribute4, hr_api.g_varchar2) or
445: nvl(per_pac_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
446: nvl(p_rec.attribute5, hr_api.g_varchar2) or
447: nvl(per_pac_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
448: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 445: nvl(per_pac_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

441: nvl(per_pac_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
442: nvl(p_rec.attribute3, hr_api.g_varchar2) or
443: nvl(per_pac_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
444: nvl(p_rec.attribute4, hr_api.g_varchar2) or
445: nvl(per_pac_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
446: nvl(p_rec.attribute5, hr_api.g_varchar2) or
447: nvl(per_pac_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
448: nvl(p_rec.attribute6, hr_api.g_varchar2) or
449: nvl(per_pac_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

442: nvl(p_rec.attribute3, hr_api.g_varchar2) or
443: nvl(per_pac_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
444: nvl(p_rec.attribute4, hr_api.g_varchar2) or
445: nvl(per_pac_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
446: nvl(p_rec.attribute5, hr_api.g_varchar2) or
447: nvl(per_pac_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
448: nvl(p_rec.attribute6, hr_api.g_varchar2) or
449: nvl(per_pac_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
450: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 447: nvl(per_pac_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

443: nvl(per_pac_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
444: nvl(p_rec.attribute4, hr_api.g_varchar2) or
445: nvl(per_pac_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
446: nvl(p_rec.attribute5, hr_api.g_varchar2) or
447: nvl(per_pac_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
448: nvl(p_rec.attribute6, hr_api.g_varchar2) or
449: nvl(per_pac_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
450: nvl(p_rec.attribute7, hr_api.g_varchar2) or
451: nvl(per_pac_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

444: nvl(p_rec.attribute4, hr_api.g_varchar2) or
445: nvl(per_pac_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
446: nvl(p_rec.attribute5, hr_api.g_varchar2) or
447: nvl(per_pac_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
448: nvl(p_rec.attribute6, hr_api.g_varchar2) or
449: nvl(per_pac_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
450: nvl(p_rec.attribute7, hr_api.g_varchar2) or
451: nvl(per_pac_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
452: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 449: nvl(per_pac_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

445: nvl(per_pac_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
446: nvl(p_rec.attribute5, hr_api.g_varchar2) or
447: nvl(per_pac_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
448: nvl(p_rec.attribute6, hr_api.g_varchar2) or
449: nvl(per_pac_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
450: nvl(p_rec.attribute7, hr_api.g_varchar2) or
451: nvl(per_pac_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
452: nvl(p_rec.attribute8, hr_api.g_varchar2) or
453: nvl(per_pac_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

446: nvl(p_rec.attribute5, hr_api.g_varchar2) or
447: nvl(per_pac_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
448: nvl(p_rec.attribute6, hr_api.g_varchar2) or
449: nvl(per_pac_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
450: nvl(p_rec.attribute7, hr_api.g_varchar2) or
451: nvl(per_pac_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
452: nvl(p_rec.attribute8, hr_api.g_varchar2) or
453: nvl(per_pac_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
454: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 451: nvl(per_pac_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

447: nvl(per_pac_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
448: nvl(p_rec.attribute6, hr_api.g_varchar2) or
449: nvl(per_pac_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
450: nvl(p_rec.attribute7, hr_api.g_varchar2) or
451: nvl(per_pac_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
452: nvl(p_rec.attribute8, hr_api.g_varchar2) or
453: nvl(per_pac_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
454: nvl(p_rec.attribute9, hr_api.g_varchar2) or
455: nvl(per_pac_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

448: nvl(p_rec.attribute6, hr_api.g_varchar2) or
449: nvl(per_pac_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
450: nvl(p_rec.attribute7, hr_api.g_varchar2) or
451: nvl(per_pac_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
452: nvl(p_rec.attribute8, hr_api.g_varchar2) or
453: nvl(per_pac_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
454: nvl(p_rec.attribute9, hr_api.g_varchar2) or
455: nvl(per_pac_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
456: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 453: nvl(per_pac_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

449: nvl(per_pac_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
450: nvl(p_rec.attribute7, hr_api.g_varchar2) or
451: nvl(per_pac_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
452: nvl(p_rec.attribute8, hr_api.g_varchar2) or
453: nvl(per_pac_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
454: nvl(p_rec.attribute9, hr_api.g_varchar2) or
455: nvl(per_pac_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
456: nvl(p_rec.attribute10, hr_api.g_varchar2) or
457: nvl(per_pac_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

450: nvl(p_rec.attribute7, hr_api.g_varchar2) or
451: nvl(per_pac_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
452: nvl(p_rec.attribute8, hr_api.g_varchar2) or
453: nvl(per_pac_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
454: nvl(p_rec.attribute9, hr_api.g_varchar2) or
455: nvl(per_pac_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
456: nvl(p_rec.attribute10, hr_api.g_varchar2) or
457: nvl(per_pac_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
458: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 455: nvl(per_pac_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

451: nvl(per_pac_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
452: nvl(p_rec.attribute8, hr_api.g_varchar2) or
453: nvl(per_pac_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
454: nvl(p_rec.attribute9, hr_api.g_varchar2) or
455: nvl(per_pac_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
456: nvl(p_rec.attribute10, hr_api.g_varchar2) or
457: nvl(per_pac_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
458: nvl(p_rec.attribute11, hr_api.g_varchar2) or
459: nvl(per_pac_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

452: nvl(p_rec.attribute8, hr_api.g_varchar2) or
453: nvl(per_pac_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
454: nvl(p_rec.attribute9, hr_api.g_varchar2) or
455: nvl(per_pac_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
456: nvl(p_rec.attribute10, hr_api.g_varchar2) or
457: nvl(per_pac_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
458: nvl(p_rec.attribute11, hr_api.g_varchar2) or
459: nvl(per_pac_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
460: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 457: nvl(per_pac_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

453: nvl(per_pac_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
454: nvl(p_rec.attribute9, hr_api.g_varchar2) or
455: nvl(per_pac_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
456: nvl(p_rec.attribute10, hr_api.g_varchar2) or
457: nvl(per_pac_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
458: nvl(p_rec.attribute11, hr_api.g_varchar2) or
459: nvl(per_pac_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
460: nvl(p_rec.attribute12, hr_api.g_varchar2) or
461: nvl(per_pac_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

454: nvl(p_rec.attribute9, hr_api.g_varchar2) or
455: nvl(per_pac_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
456: nvl(p_rec.attribute10, hr_api.g_varchar2) or
457: nvl(per_pac_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
458: nvl(p_rec.attribute11, hr_api.g_varchar2) or
459: nvl(per_pac_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
460: nvl(p_rec.attribute12, hr_api.g_varchar2) or
461: nvl(per_pac_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
462: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 459: nvl(per_pac_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

455: nvl(per_pac_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
456: nvl(p_rec.attribute10, hr_api.g_varchar2) or
457: nvl(per_pac_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
458: nvl(p_rec.attribute11, hr_api.g_varchar2) or
459: nvl(per_pac_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
460: nvl(p_rec.attribute12, hr_api.g_varchar2) or
461: nvl(per_pac_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
462: nvl(p_rec.attribute13, hr_api.g_varchar2) or
463: nvl(per_pac_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

456: nvl(p_rec.attribute10, hr_api.g_varchar2) or
457: nvl(per_pac_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
458: nvl(p_rec.attribute11, hr_api.g_varchar2) or
459: nvl(per_pac_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
460: nvl(p_rec.attribute12, hr_api.g_varchar2) or
461: nvl(per_pac_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
462: nvl(p_rec.attribute13, hr_api.g_varchar2) or
463: nvl(per_pac_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
464: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 461: nvl(per_pac_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

457: nvl(per_pac_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
458: nvl(p_rec.attribute11, hr_api.g_varchar2) or
459: nvl(per_pac_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
460: nvl(p_rec.attribute12, hr_api.g_varchar2) or
461: nvl(per_pac_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
462: nvl(p_rec.attribute13, hr_api.g_varchar2) or
463: nvl(per_pac_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
464: nvl(p_rec.attribute14, hr_api.g_varchar2) or
465: nvl(per_pac_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

458: nvl(p_rec.attribute11, hr_api.g_varchar2) or
459: nvl(per_pac_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
460: nvl(p_rec.attribute12, hr_api.g_varchar2) or
461: nvl(per_pac_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
462: nvl(p_rec.attribute13, hr_api.g_varchar2) or
463: nvl(per_pac_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
464: nvl(p_rec.attribute14, hr_api.g_varchar2) or
465: nvl(per_pac_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
466: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 463: nvl(per_pac_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

459: nvl(per_pac_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
460: nvl(p_rec.attribute12, hr_api.g_varchar2) or
461: nvl(per_pac_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
462: nvl(p_rec.attribute13, hr_api.g_varchar2) or
463: nvl(per_pac_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
464: nvl(p_rec.attribute14, hr_api.g_varchar2) or
465: nvl(per_pac_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
466: nvl(p_rec.attribute15, hr_api.g_varchar2) or
467: nvl(per_pac_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

460: nvl(p_rec.attribute12, hr_api.g_varchar2) or
461: nvl(per_pac_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
462: nvl(p_rec.attribute13, hr_api.g_varchar2) or
463: nvl(per_pac_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
464: nvl(p_rec.attribute14, hr_api.g_varchar2) or
465: nvl(per_pac_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
466: nvl(p_rec.attribute15, hr_api.g_varchar2) or
467: nvl(per_pac_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
468: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 465: nvl(per_pac_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

461: nvl(per_pac_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
462: nvl(p_rec.attribute13, hr_api.g_varchar2) or
463: nvl(per_pac_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
464: nvl(p_rec.attribute14, hr_api.g_varchar2) or
465: nvl(per_pac_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
466: nvl(p_rec.attribute15, hr_api.g_varchar2) or
467: nvl(per_pac_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
468: nvl(p_rec.attribute16, hr_api.g_varchar2) or
469: nvl(per_pac_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

462: nvl(p_rec.attribute13, hr_api.g_varchar2) or
463: nvl(per_pac_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
464: nvl(p_rec.attribute14, hr_api.g_varchar2) or
465: nvl(per_pac_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
466: nvl(p_rec.attribute15, hr_api.g_varchar2) or
467: nvl(per_pac_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
468: nvl(p_rec.attribute16, hr_api.g_varchar2) or
469: nvl(per_pac_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
470: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 467: nvl(per_pac_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

463: nvl(per_pac_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
464: nvl(p_rec.attribute14, hr_api.g_varchar2) or
465: nvl(per_pac_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
466: nvl(p_rec.attribute15, hr_api.g_varchar2) or
467: nvl(per_pac_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
468: nvl(p_rec.attribute16, hr_api.g_varchar2) or
469: nvl(per_pac_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
470: nvl(p_rec.attribute17, hr_api.g_varchar2) or
471: nvl(per_pac_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

464: nvl(p_rec.attribute14, hr_api.g_varchar2) or
465: nvl(per_pac_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
466: nvl(p_rec.attribute15, hr_api.g_varchar2) or
467: nvl(per_pac_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
468: nvl(p_rec.attribute16, hr_api.g_varchar2) or
469: nvl(per_pac_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
470: nvl(p_rec.attribute17, hr_api.g_varchar2) or
471: nvl(per_pac_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
472: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 469: nvl(per_pac_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

465: nvl(per_pac_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
466: nvl(p_rec.attribute15, hr_api.g_varchar2) or
467: nvl(per_pac_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
468: nvl(p_rec.attribute16, hr_api.g_varchar2) or
469: nvl(per_pac_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
470: nvl(p_rec.attribute17, hr_api.g_varchar2) or
471: nvl(per_pac_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
472: nvl(p_rec.attribute18, hr_api.g_varchar2) or
473: nvl(per_pac_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

466: nvl(p_rec.attribute15, hr_api.g_varchar2) or
467: nvl(per_pac_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
468: nvl(p_rec.attribute16, hr_api.g_varchar2) or
469: nvl(per_pac_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
470: nvl(p_rec.attribute17, hr_api.g_varchar2) or
471: nvl(per_pac_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
472: nvl(p_rec.attribute18, hr_api.g_varchar2) or
473: nvl(per_pac_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
474: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 471: nvl(per_pac_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

467: nvl(per_pac_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
468: nvl(p_rec.attribute16, hr_api.g_varchar2) or
469: nvl(per_pac_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
470: nvl(p_rec.attribute17, hr_api.g_varchar2) or
471: nvl(per_pac_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
472: nvl(p_rec.attribute18, hr_api.g_varchar2) or
473: nvl(per_pac_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
474: nvl(p_rec.attribute19, hr_api.g_varchar2) or
475: nvl(per_pac_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

468: nvl(p_rec.attribute16, hr_api.g_varchar2) or
469: nvl(per_pac_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
470: nvl(p_rec.attribute17, hr_api.g_varchar2) or
471: nvl(per_pac_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
472: nvl(p_rec.attribute18, hr_api.g_varchar2) or
473: nvl(per_pac_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
474: nvl(p_rec.attribute19, hr_api.g_varchar2) or
475: nvl(per_pac_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
476: nvl(p_rec.attribute20, hr_api.g_varchar2) ))

Line 473: nvl(per_pac_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

469: nvl(per_pac_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
470: nvl(p_rec.attribute17, hr_api.g_varchar2) or
471: nvl(per_pac_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
472: nvl(p_rec.attribute18, hr_api.g_varchar2) or
473: nvl(per_pac_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
474: nvl(p_rec.attribute19, hr_api.g_varchar2) or
475: nvl(per_pac_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
476: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
477: or (p_rec.allocated_checklist_id is null) then

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

470: nvl(p_rec.attribute17, hr_api.g_varchar2) or
471: nvl(per_pac_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
472: nvl(p_rec.attribute18, hr_api.g_varchar2) or
473: nvl(per_pac_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
474: nvl(p_rec.attribute19, hr_api.g_varchar2) or
475: nvl(per_pac_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
476: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
477: or (p_rec.allocated_checklist_id is null) then
478: --

Line 475: nvl(per_pac_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

471: nvl(per_pac_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
472: nvl(p_rec.attribute18, hr_api.g_varchar2) or
473: nvl(per_pac_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
474: nvl(p_rec.attribute19, hr_api.g_varchar2) or
475: nvl(per_pac_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
476: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
477: or (p_rec.allocated_checklist_id is null) then
478: --
479: -- Only execute the validation if absolutely necessary:

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

472: nvl(p_rec.attribute18, hr_api.g_varchar2) or
473: nvl(per_pac_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
474: nvl(p_rec.attribute19, hr_api.g_varchar2) or
475: nvl(per_pac_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
476: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
477: or (p_rec.allocated_checklist_id is null) then
478: --
479: -- Only execute the validation if absolutely necessary:
480: -- a) During update, the structure column value or any