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

APPS.PER_PAT_BUS dependencies on HR_API

Line 55: hr_api.mandatory_arg_error

51: hr_utility.set_location('Entering:'|| l_proc, 10);
52: --
53: -- Ensure that all the mandatory parameter are not null
54: --
55: hr_api.mandatory_arg_error
56: (p_api_name => l_proc
57: ,p_argument => 'allocated_task_id'
58: ,p_argument_value => p_allocated_task_id
59: );

Line 82: hr_api.set_security_group_id

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

Line 88: hr_api.set_legislation_context(l_legislation_code);

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

Line 130: hr_api.mandatory_arg_error

126: hr_utility.set_location('Entering:'|| l_proc, 10);
127: --
128: -- Ensure that all the mandatory parameter are not null
129: --
130: hr_api.mandatory_arg_error
131: (p_api_name => l_proc
132: ,p_argument => 'allocated_task_id'
133: ,p_argument_value => p_allocated_task_id
134: );

Line 136: if ( nvl(per_pat_bus.g_allocated_task_id, hr_api.g_number)

132: ,p_argument => 'allocated_task_id'
133: ,p_argument_value => p_allocated_task_id
134: );
135: --
136: if ( nvl(per_pat_bus.g_allocated_task_id, hr_api.g_number)
137: = p_allocated_task_id) then
138: --
139: -- The legislation code has already been found with a previous
140: -- call to this function. Just return the value in the global

Line 215: AND NVL(per_pat_shd.g_old_rec.task_name, hr_api.g_varchar2) = nvl(p_task_name,hr_api.g_varchar2)

211: ,p_object_version_number => p_object_version_number
212: );
213:
214: IF (l_api_updating
215: AND NVL(per_pat_shd.g_old_rec.task_name, hr_api.g_varchar2) = nvl(p_task_name,hr_api.g_varchar2)
216: )
217: THEN
218: RETURN;
219: END IF;

Line 355: nvl(per_pat_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

351: hr_utility.set_location('Entering:'||l_proc,10);
352: --
353: /*
354: if ((p_rec.allocated_task_id is not null) and (
355: nvl(per_pat_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
356: nvl(p_rec.information_category, hr_api.g_varchar2) or
357: nvl(per_pat_shd.g_old_rec.information1, hr_api.g_varchar2) <>
358: nvl(p_rec.information1, hr_api.g_varchar2) or
359: nvl(per_pat_shd.g_old_rec.information2, hr_api.g_varchar2) <>

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

352: --
353: /*
354: if ((p_rec.allocated_task_id is not null) and (
355: nvl(per_pat_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
356: nvl(p_rec.information_category, hr_api.g_varchar2) or
357: nvl(per_pat_shd.g_old_rec.information1, hr_api.g_varchar2) <>
358: nvl(p_rec.information1, hr_api.g_varchar2) or
359: nvl(per_pat_shd.g_old_rec.information2, hr_api.g_varchar2) <>
360: nvl(p_rec.information2, hr_api.g_varchar2) or

Line 357: nvl(per_pat_shd.g_old_rec.information1, hr_api.g_varchar2) <>

353: /*
354: if ((p_rec.allocated_task_id is not null) and (
355: nvl(per_pat_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
356: nvl(p_rec.information_category, hr_api.g_varchar2) or
357: nvl(per_pat_shd.g_old_rec.information1, hr_api.g_varchar2) <>
358: nvl(p_rec.information1, hr_api.g_varchar2) or
359: nvl(per_pat_shd.g_old_rec.information2, hr_api.g_varchar2) <>
360: nvl(p_rec.information2, hr_api.g_varchar2) or
361: nvl(per_pat_shd.g_old_rec.information3, hr_api.g_varchar2) <>

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

354: if ((p_rec.allocated_task_id is not null) and (
355: nvl(per_pat_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
356: nvl(p_rec.information_category, hr_api.g_varchar2) or
357: nvl(per_pat_shd.g_old_rec.information1, hr_api.g_varchar2) <>
358: nvl(p_rec.information1, hr_api.g_varchar2) or
359: nvl(per_pat_shd.g_old_rec.information2, hr_api.g_varchar2) <>
360: nvl(p_rec.information2, hr_api.g_varchar2) or
361: nvl(per_pat_shd.g_old_rec.information3, hr_api.g_varchar2) <>
362: nvl(p_rec.information3, hr_api.g_varchar2) or

Line 359: nvl(per_pat_shd.g_old_rec.information2, hr_api.g_varchar2) <>

355: nvl(per_pat_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
356: nvl(p_rec.information_category, hr_api.g_varchar2) or
357: nvl(per_pat_shd.g_old_rec.information1, hr_api.g_varchar2) <>
358: nvl(p_rec.information1, hr_api.g_varchar2) or
359: nvl(per_pat_shd.g_old_rec.information2, hr_api.g_varchar2) <>
360: nvl(p_rec.information2, hr_api.g_varchar2) or
361: nvl(per_pat_shd.g_old_rec.information3, hr_api.g_varchar2) <>
362: nvl(p_rec.information3, hr_api.g_varchar2) or
363: nvl(per_pat_shd.g_old_rec.information4, hr_api.g_varchar2) <>

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

356: nvl(p_rec.information_category, hr_api.g_varchar2) or
357: nvl(per_pat_shd.g_old_rec.information1, hr_api.g_varchar2) <>
358: nvl(p_rec.information1, hr_api.g_varchar2) or
359: nvl(per_pat_shd.g_old_rec.information2, hr_api.g_varchar2) <>
360: nvl(p_rec.information2, hr_api.g_varchar2) or
361: nvl(per_pat_shd.g_old_rec.information3, hr_api.g_varchar2) <>
362: nvl(p_rec.information3, hr_api.g_varchar2) or
363: nvl(per_pat_shd.g_old_rec.information4, hr_api.g_varchar2) <>
364: nvl(p_rec.information4, hr_api.g_varchar2) or

Line 361: nvl(per_pat_shd.g_old_rec.information3, hr_api.g_varchar2) <>

357: nvl(per_pat_shd.g_old_rec.information1, hr_api.g_varchar2) <>
358: nvl(p_rec.information1, hr_api.g_varchar2) or
359: nvl(per_pat_shd.g_old_rec.information2, hr_api.g_varchar2) <>
360: nvl(p_rec.information2, hr_api.g_varchar2) or
361: nvl(per_pat_shd.g_old_rec.information3, hr_api.g_varchar2) <>
362: nvl(p_rec.information3, hr_api.g_varchar2) or
363: nvl(per_pat_shd.g_old_rec.information4, hr_api.g_varchar2) <>
364: nvl(p_rec.information4, hr_api.g_varchar2) or
365: nvl(per_pat_shd.g_old_rec.information5, hr_api.g_varchar2) <>

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

358: nvl(p_rec.information1, hr_api.g_varchar2) or
359: nvl(per_pat_shd.g_old_rec.information2, hr_api.g_varchar2) <>
360: nvl(p_rec.information2, hr_api.g_varchar2) or
361: nvl(per_pat_shd.g_old_rec.information3, hr_api.g_varchar2) <>
362: nvl(p_rec.information3, hr_api.g_varchar2) or
363: nvl(per_pat_shd.g_old_rec.information4, hr_api.g_varchar2) <>
364: nvl(p_rec.information4, hr_api.g_varchar2) or
365: nvl(per_pat_shd.g_old_rec.information5, hr_api.g_varchar2) <>
366: nvl(p_rec.information5, hr_api.g_varchar2) or

Line 363: nvl(per_pat_shd.g_old_rec.information4, hr_api.g_varchar2) <>

359: nvl(per_pat_shd.g_old_rec.information2, hr_api.g_varchar2) <>
360: nvl(p_rec.information2, hr_api.g_varchar2) or
361: nvl(per_pat_shd.g_old_rec.information3, hr_api.g_varchar2) <>
362: nvl(p_rec.information3, hr_api.g_varchar2) or
363: nvl(per_pat_shd.g_old_rec.information4, hr_api.g_varchar2) <>
364: nvl(p_rec.information4, hr_api.g_varchar2) or
365: nvl(per_pat_shd.g_old_rec.information5, hr_api.g_varchar2) <>
366: nvl(p_rec.information5, hr_api.g_varchar2) or
367: nvl(per_pat_shd.g_old_rec.information6, hr_api.g_varchar2) <>

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

360: nvl(p_rec.information2, hr_api.g_varchar2) or
361: nvl(per_pat_shd.g_old_rec.information3, hr_api.g_varchar2) <>
362: nvl(p_rec.information3, hr_api.g_varchar2) or
363: nvl(per_pat_shd.g_old_rec.information4, hr_api.g_varchar2) <>
364: nvl(p_rec.information4, hr_api.g_varchar2) or
365: nvl(per_pat_shd.g_old_rec.information5, hr_api.g_varchar2) <>
366: nvl(p_rec.information5, hr_api.g_varchar2) or
367: nvl(per_pat_shd.g_old_rec.information6, hr_api.g_varchar2) <>
368: nvl(p_rec.information6, hr_api.g_varchar2) or

Line 365: nvl(per_pat_shd.g_old_rec.information5, hr_api.g_varchar2) <>

361: nvl(per_pat_shd.g_old_rec.information3, hr_api.g_varchar2) <>
362: nvl(p_rec.information3, hr_api.g_varchar2) or
363: nvl(per_pat_shd.g_old_rec.information4, hr_api.g_varchar2) <>
364: nvl(p_rec.information4, hr_api.g_varchar2) or
365: nvl(per_pat_shd.g_old_rec.information5, hr_api.g_varchar2) <>
366: nvl(p_rec.information5, hr_api.g_varchar2) or
367: nvl(per_pat_shd.g_old_rec.information6, hr_api.g_varchar2) <>
368: nvl(p_rec.information6, hr_api.g_varchar2) or
369: nvl(per_pat_shd.g_old_rec.information7, hr_api.g_varchar2) <>

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

362: nvl(p_rec.information3, hr_api.g_varchar2) or
363: nvl(per_pat_shd.g_old_rec.information4, hr_api.g_varchar2) <>
364: nvl(p_rec.information4, hr_api.g_varchar2) or
365: nvl(per_pat_shd.g_old_rec.information5, hr_api.g_varchar2) <>
366: nvl(p_rec.information5, hr_api.g_varchar2) or
367: nvl(per_pat_shd.g_old_rec.information6, hr_api.g_varchar2) <>
368: nvl(p_rec.information6, hr_api.g_varchar2) or
369: nvl(per_pat_shd.g_old_rec.information7, hr_api.g_varchar2) <>
370: nvl(p_rec.information7, hr_api.g_varchar2) or

Line 367: nvl(per_pat_shd.g_old_rec.information6, hr_api.g_varchar2) <>

363: nvl(per_pat_shd.g_old_rec.information4, hr_api.g_varchar2) <>
364: nvl(p_rec.information4, hr_api.g_varchar2) or
365: nvl(per_pat_shd.g_old_rec.information5, hr_api.g_varchar2) <>
366: nvl(p_rec.information5, hr_api.g_varchar2) or
367: nvl(per_pat_shd.g_old_rec.information6, hr_api.g_varchar2) <>
368: nvl(p_rec.information6, hr_api.g_varchar2) or
369: nvl(per_pat_shd.g_old_rec.information7, hr_api.g_varchar2) <>
370: nvl(p_rec.information7, hr_api.g_varchar2) or
371: nvl(per_pat_shd.g_old_rec.information8, hr_api.g_varchar2) <>

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

364: nvl(p_rec.information4, hr_api.g_varchar2) or
365: nvl(per_pat_shd.g_old_rec.information5, hr_api.g_varchar2) <>
366: nvl(p_rec.information5, hr_api.g_varchar2) or
367: nvl(per_pat_shd.g_old_rec.information6, hr_api.g_varchar2) <>
368: nvl(p_rec.information6, hr_api.g_varchar2) or
369: nvl(per_pat_shd.g_old_rec.information7, hr_api.g_varchar2) <>
370: nvl(p_rec.information7, hr_api.g_varchar2) or
371: nvl(per_pat_shd.g_old_rec.information8, hr_api.g_varchar2) <>
372: nvl(p_rec.information8, hr_api.g_varchar2) or

Line 369: nvl(per_pat_shd.g_old_rec.information7, hr_api.g_varchar2) <>

365: nvl(per_pat_shd.g_old_rec.information5, hr_api.g_varchar2) <>
366: nvl(p_rec.information5, hr_api.g_varchar2) or
367: nvl(per_pat_shd.g_old_rec.information6, hr_api.g_varchar2) <>
368: nvl(p_rec.information6, hr_api.g_varchar2) or
369: nvl(per_pat_shd.g_old_rec.information7, hr_api.g_varchar2) <>
370: nvl(p_rec.information7, hr_api.g_varchar2) or
371: nvl(per_pat_shd.g_old_rec.information8, hr_api.g_varchar2) <>
372: nvl(p_rec.information8, hr_api.g_varchar2) or
373: nvl(per_pat_shd.g_old_rec.information9, hr_api.g_varchar2) <>

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

366: nvl(p_rec.information5, hr_api.g_varchar2) or
367: nvl(per_pat_shd.g_old_rec.information6, hr_api.g_varchar2) <>
368: nvl(p_rec.information6, hr_api.g_varchar2) or
369: nvl(per_pat_shd.g_old_rec.information7, hr_api.g_varchar2) <>
370: nvl(p_rec.information7, hr_api.g_varchar2) or
371: nvl(per_pat_shd.g_old_rec.information8, hr_api.g_varchar2) <>
372: nvl(p_rec.information8, hr_api.g_varchar2) or
373: nvl(per_pat_shd.g_old_rec.information9, hr_api.g_varchar2) <>
374: nvl(p_rec.information9, hr_api.g_varchar2) or

Line 371: nvl(per_pat_shd.g_old_rec.information8, hr_api.g_varchar2) <>

367: nvl(per_pat_shd.g_old_rec.information6, hr_api.g_varchar2) <>
368: nvl(p_rec.information6, hr_api.g_varchar2) or
369: nvl(per_pat_shd.g_old_rec.information7, hr_api.g_varchar2) <>
370: nvl(p_rec.information7, hr_api.g_varchar2) or
371: nvl(per_pat_shd.g_old_rec.information8, hr_api.g_varchar2) <>
372: nvl(p_rec.information8, hr_api.g_varchar2) or
373: nvl(per_pat_shd.g_old_rec.information9, hr_api.g_varchar2) <>
374: nvl(p_rec.information9, hr_api.g_varchar2) or
375: nvl(per_pat_shd.g_old_rec.information10, hr_api.g_varchar2) <>

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

368: nvl(p_rec.information6, hr_api.g_varchar2) or
369: nvl(per_pat_shd.g_old_rec.information7, hr_api.g_varchar2) <>
370: nvl(p_rec.information7, hr_api.g_varchar2) or
371: nvl(per_pat_shd.g_old_rec.information8, hr_api.g_varchar2) <>
372: nvl(p_rec.information8, hr_api.g_varchar2) or
373: nvl(per_pat_shd.g_old_rec.information9, hr_api.g_varchar2) <>
374: nvl(p_rec.information9, hr_api.g_varchar2) or
375: nvl(per_pat_shd.g_old_rec.information10, hr_api.g_varchar2) <>
376: nvl(p_rec.information10, hr_api.g_varchar2) or

Line 373: nvl(per_pat_shd.g_old_rec.information9, hr_api.g_varchar2) <>

369: nvl(per_pat_shd.g_old_rec.information7, hr_api.g_varchar2) <>
370: nvl(p_rec.information7, hr_api.g_varchar2) or
371: nvl(per_pat_shd.g_old_rec.information8, hr_api.g_varchar2) <>
372: nvl(p_rec.information8, hr_api.g_varchar2) or
373: nvl(per_pat_shd.g_old_rec.information9, hr_api.g_varchar2) <>
374: nvl(p_rec.information9, hr_api.g_varchar2) or
375: nvl(per_pat_shd.g_old_rec.information10, hr_api.g_varchar2) <>
376: nvl(p_rec.information10, hr_api.g_varchar2) or
377: nvl(per_pat_shd.g_old_rec.information11, hr_api.g_varchar2) <>

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

370: nvl(p_rec.information7, hr_api.g_varchar2) or
371: nvl(per_pat_shd.g_old_rec.information8, hr_api.g_varchar2) <>
372: nvl(p_rec.information8, hr_api.g_varchar2) or
373: nvl(per_pat_shd.g_old_rec.information9, hr_api.g_varchar2) <>
374: nvl(p_rec.information9, hr_api.g_varchar2) or
375: nvl(per_pat_shd.g_old_rec.information10, hr_api.g_varchar2) <>
376: nvl(p_rec.information10, hr_api.g_varchar2) or
377: nvl(per_pat_shd.g_old_rec.information11, hr_api.g_varchar2) <>
378: nvl(p_rec.information11, hr_api.g_varchar2) or

Line 375: nvl(per_pat_shd.g_old_rec.information10, hr_api.g_varchar2) <>

371: nvl(per_pat_shd.g_old_rec.information8, hr_api.g_varchar2) <>
372: nvl(p_rec.information8, hr_api.g_varchar2) or
373: nvl(per_pat_shd.g_old_rec.information9, hr_api.g_varchar2) <>
374: nvl(p_rec.information9, hr_api.g_varchar2) or
375: nvl(per_pat_shd.g_old_rec.information10, hr_api.g_varchar2) <>
376: nvl(p_rec.information10, hr_api.g_varchar2) or
377: nvl(per_pat_shd.g_old_rec.information11, hr_api.g_varchar2) <>
378: nvl(p_rec.information11, hr_api.g_varchar2) or
379: nvl(per_pat_shd.g_old_rec.information12, hr_api.g_varchar2) <>

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

372: nvl(p_rec.information8, hr_api.g_varchar2) or
373: nvl(per_pat_shd.g_old_rec.information9, hr_api.g_varchar2) <>
374: nvl(p_rec.information9, hr_api.g_varchar2) or
375: nvl(per_pat_shd.g_old_rec.information10, hr_api.g_varchar2) <>
376: nvl(p_rec.information10, hr_api.g_varchar2) or
377: nvl(per_pat_shd.g_old_rec.information11, hr_api.g_varchar2) <>
378: nvl(p_rec.information11, hr_api.g_varchar2) or
379: nvl(per_pat_shd.g_old_rec.information12, hr_api.g_varchar2) <>
380: nvl(p_rec.information12, hr_api.g_varchar2) or

Line 377: nvl(per_pat_shd.g_old_rec.information11, hr_api.g_varchar2) <>

373: nvl(per_pat_shd.g_old_rec.information9, hr_api.g_varchar2) <>
374: nvl(p_rec.information9, hr_api.g_varchar2) or
375: nvl(per_pat_shd.g_old_rec.information10, hr_api.g_varchar2) <>
376: nvl(p_rec.information10, hr_api.g_varchar2) or
377: nvl(per_pat_shd.g_old_rec.information11, hr_api.g_varchar2) <>
378: nvl(p_rec.information11, hr_api.g_varchar2) or
379: nvl(per_pat_shd.g_old_rec.information12, hr_api.g_varchar2) <>
380: nvl(p_rec.information12, hr_api.g_varchar2) or
381: nvl(per_pat_shd.g_old_rec.information13, hr_api.g_varchar2) <>

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

374: nvl(p_rec.information9, hr_api.g_varchar2) or
375: nvl(per_pat_shd.g_old_rec.information10, hr_api.g_varchar2) <>
376: nvl(p_rec.information10, hr_api.g_varchar2) or
377: nvl(per_pat_shd.g_old_rec.information11, hr_api.g_varchar2) <>
378: nvl(p_rec.information11, hr_api.g_varchar2) or
379: nvl(per_pat_shd.g_old_rec.information12, hr_api.g_varchar2) <>
380: nvl(p_rec.information12, hr_api.g_varchar2) or
381: nvl(per_pat_shd.g_old_rec.information13, hr_api.g_varchar2) <>
382: nvl(p_rec.information13, hr_api.g_varchar2) or

Line 379: nvl(per_pat_shd.g_old_rec.information12, hr_api.g_varchar2) <>

375: nvl(per_pat_shd.g_old_rec.information10, hr_api.g_varchar2) <>
376: nvl(p_rec.information10, hr_api.g_varchar2) or
377: nvl(per_pat_shd.g_old_rec.information11, hr_api.g_varchar2) <>
378: nvl(p_rec.information11, hr_api.g_varchar2) or
379: nvl(per_pat_shd.g_old_rec.information12, hr_api.g_varchar2) <>
380: nvl(p_rec.information12, hr_api.g_varchar2) or
381: nvl(per_pat_shd.g_old_rec.information13, hr_api.g_varchar2) <>
382: nvl(p_rec.information13, hr_api.g_varchar2) or
383: nvl(per_pat_shd.g_old_rec.information14, hr_api.g_varchar2) <>

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

376: nvl(p_rec.information10, hr_api.g_varchar2) or
377: nvl(per_pat_shd.g_old_rec.information11, hr_api.g_varchar2) <>
378: nvl(p_rec.information11, hr_api.g_varchar2) or
379: nvl(per_pat_shd.g_old_rec.information12, hr_api.g_varchar2) <>
380: nvl(p_rec.information12, hr_api.g_varchar2) or
381: nvl(per_pat_shd.g_old_rec.information13, hr_api.g_varchar2) <>
382: nvl(p_rec.information13, hr_api.g_varchar2) or
383: nvl(per_pat_shd.g_old_rec.information14, hr_api.g_varchar2) <>
384: nvl(p_rec.information14, hr_api.g_varchar2) or

Line 381: nvl(per_pat_shd.g_old_rec.information13, hr_api.g_varchar2) <>

377: nvl(per_pat_shd.g_old_rec.information11, hr_api.g_varchar2) <>
378: nvl(p_rec.information11, hr_api.g_varchar2) or
379: nvl(per_pat_shd.g_old_rec.information12, hr_api.g_varchar2) <>
380: nvl(p_rec.information12, hr_api.g_varchar2) or
381: nvl(per_pat_shd.g_old_rec.information13, hr_api.g_varchar2) <>
382: nvl(p_rec.information13, hr_api.g_varchar2) or
383: nvl(per_pat_shd.g_old_rec.information14, hr_api.g_varchar2) <>
384: nvl(p_rec.information14, hr_api.g_varchar2) or
385: nvl(per_pat_shd.g_old_rec.information15, hr_api.g_varchar2) <>

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

378: nvl(p_rec.information11, hr_api.g_varchar2) or
379: nvl(per_pat_shd.g_old_rec.information12, hr_api.g_varchar2) <>
380: nvl(p_rec.information12, hr_api.g_varchar2) or
381: nvl(per_pat_shd.g_old_rec.information13, hr_api.g_varchar2) <>
382: nvl(p_rec.information13, hr_api.g_varchar2) or
383: nvl(per_pat_shd.g_old_rec.information14, hr_api.g_varchar2) <>
384: nvl(p_rec.information14, hr_api.g_varchar2) or
385: nvl(per_pat_shd.g_old_rec.information15, hr_api.g_varchar2) <>
386: nvl(p_rec.information15, hr_api.g_varchar2) or

Line 383: nvl(per_pat_shd.g_old_rec.information14, hr_api.g_varchar2) <>

379: nvl(per_pat_shd.g_old_rec.information12, hr_api.g_varchar2) <>
380: nvl(p_rec.information12, hr_api.g_varchar2) or
381: nvl(per_pat_shd.g_old_rec.information13, hr_api.g_varchar2) <>
382: nvl(p_rec.information13, hr_api.g_varchar2) or
383: nvl(per_pat_shd.g_old_rec.information14, hr_api.g_varchar2) <>
384: nvl(p_rec.information14, hr_api.g_varchar2) or
385: nvl(per_pat_shd.g_old_rec.information15, hr_api.g_varchar2) <>
386: nvl(p_rec.information15, hr_api.g_varchar2) or
387: nvl(per_pat_shd.g_old_rec.information16, hr_api.g_varchar2) <>

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

380: nvl(p_rec.information12, hr_api.g_varchar2) or
381: nvl(per_pat_shd.g_old_rec.information13, hr_api.g_varchar2) <>
382: nvl(p_rec.information13, hr_api.g_varchar2) or
383: nvl(per_pat_shd.g_old_rec.information14, hr_api.g_varchar2) <>
384: nvl(p_rec.information14, hr_api.g_varchar2) or
385: nvl(per_pat_shd.g_old_rec.information15, hr_api.g_varchar2) <>
386: nvl(p_rec.information15, hr_api.g_varchar2) or
387: nvl(per_pat_shd.g_old_rec.information16, hr_api.g_varchar2) <>
388: nvl(p_rec.information16, hr_api.g_varchar2) or

Line 385: nvl(per_pat_shd.g_old_rec.information15, hr_api.g_varchar2) <>

381: nvl(per_pat_shd.g_old_rec.information13, hr_api.g_varchar2) <>
382: nvl(p_rec.information13, hr_api.g_varchar2) or
383: nvl(per_pat_shd.g_old_rec.information14, hr_api.g_varchar2) <>
384: nvl(p_rec.information14, hr_api.g_varchar2) or
385: nvl(per_pat_shd.g_old_rec.information15, hr_api.g_varchar2) <>
386: nvl(p_rec.information15, hr_api.g_varchar2) or
387: nvl(per_pat_shd.g_old_rec.information16, hr_api.g_varchar2) <>
388: nvl(p_rec.information16, hr_api.g_varchar2) or
389: nvl(per_pat_shd.g_old_rec.information17, hr_api.g_varchar2) <>

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

382: nvl(p_rec.information13, hr_api.g_varchar2) or
383: nvl(per_pat_shd.g_old_rec.information14, hr_api.g_varchar2) <>
384: nvl(p_rec.information14, hr_api.g_varchar2) or
385: nvl(per_pat_shd.g_old_rec.information15, hr_api.g_varchar2) <>
386: nvl(p_rec.information15, hr_api.g_varchar2) or
387: nvl(per_pat_shd.g_old_rec.information16, hr_api.g_varchar2) <>
388: nvl(p_rec.information16, hr_api.g_varchar2) or
389: nvl(per_pat_shd.g_old_rec.information17, hr_api.g_varchar2) <>
390: nvl(p_rec.information17, hr_api.g_varchar2) or

Line 387: nvl(per_pat_shd.g_old_rec.information16, hr_api.g_varchar2) <>

383: nvl(per_pat_shd.g_old_rec.information14, hr_api.g_varchar2) <>
384: nvl(p_rec.information14, hr_api.g_varchar2) or
385: nvl(per_pat_shd.g_old_rec.information15, hr_api.g_varchar2) <>
386: nvl(p_rec.information15, hr_api.g_varchar2) or
387: nvl(per_pat_shd.g_old_rec.information16, hr_api.g_varchar2) <>
388: nvl(p_rec.information16, hr_api.g_varchar2) or
389: nvl(per_pat_shd.g_old_rec.information17, hr_api.g_varchar2) <>
390: nvl(p_rec.information17, hr_api.g_varchar2) or
391: nvl(per_pat_shd.g_old_rec.information18, hr_api.g_varchar2) <>

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

384: nvl(p_rec.information14, hr_api.g_varchar2) or
385: nvl(per_pat_shd.g_old_rec.information15, hr_api.g_varchar2) <>
386: nvl(p_rec.information15, hr_api.g_varchar2) or
387: nvl(per_pat_shd.g_old_rec.information16, hr_api.g_varchar2) <>
388: nvl(p_rec.information16, hr_api.g_varchar2) or
389: nvl(per_pat_shd.g_old_rec.information17, hr_api.g_varchar2) <>
390: nvl(p_rec.information17, hr_api.g_varchar2) or
391: nvl(per_pat_shd.g_old_rec.information18, hr_api.g_varchar2) <>
392: nvl(p_rec.information18, hr_api.g_varchar2) or

Line 389: nvl(per_pat_shd.g_old_rec.information17, hr_api.g_varchar2) <>

385: nvl(per_pat_shd.g_old_rec.information15, hr_api.g_varchar2) <>
386: nvl(p_rec.information15, hr_api.g_varchar2) or
387: nvl(per_pat_shd.g_old_rec.information16, hr_api.g_varchar2) <>
388: nvl(p_rec.information16, hr_api.g_varchar2) or
389: nvl(per_pat_shd.g_old_rec.information17, hr_api.g_varchar2) <>
390: nvl(p_rec.information17, hr_api.g_varchar2) or
391: nvl(per_pat_shd.g_old_rec.information18, hr_api.g_varchar2) <>
392: nvl(p_rec.information18, hr_api.g_varchar2) or
393: nvl(per_pat_shd.g_old_rec.information19, hr_api.g_varchar2) <>

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

386: nvl(p_rec.information15, hr_api.g_varchar2) or
387: nvl(per_pat_shd.g_old_rec.information16, hr_api.g_varchar2) <>
388: nvl(p_rec.information16, hr_api.g_varchar2) or
389: nvl(per_pat_shd.g_old_rec.information17, hr_api.g_varchar2) <>
390: nvl(p_rec.information17, hr_api.g_varchar2) or
391: nvl(per_pat_shd.g_old_rec.information18, hr_api.g_varchar2) <>
392: nvl(p_rec.information18, hr_api.g_varchar2) or
393: nvl(per_pat_shd.g_old_rec.information19, hr_api.g_varchar2) <>
394: nvl(p_rec.information19, hr_api.g_varchar2) or

Line 391: nvl(per_pat_shd.g_old_rec.information18, hr_api.g_varchar2) <>

387: nvl(per_pat_shd.g_old_rec.information16, hr_api.g_varchar2) <>
388: nvl(p_rec.information16, hr_api.g_varchar2) or
389: nvl(per_pat_shd.g_old_rec.information17, hr_api.g_varchar2) <>
390: nvl(p_rec.information17, hr_api.g_varchar2) or
391: nvl(per_pat_shd.g_old_rec.information18, hr_api.g_varchar2) <>
392: nvl(p_rec.information18, hr_api.g_varchar2) or
393: nvl(per_pat_shd.g_old_rec.information19, hr_api.g_varchar2) <>
394: nvl(p_rec.information19, hr_api.g_varchar2) or
395: nvl(per_pat_shd.g_old_rec.information20, hr_api.g_varchar2) <>

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

388: nvl(p_rec.information16, hr_api.g_varchar2) or
389: nvl(per_pat_shd.g_old_rec.information17, hr_api.g_varchar2) <>
390: nvl(p_rec.information17, hr_api.g_varchar2) or
391: nvl(per_pat_shd.g_old_rec.information18, hr_api.g_varchar2) <>
392: nvl(p_rec.information18, hr_api.g_varchar2) or
393: nvl(per_pat_shd.g_old_rec.information19, hr_api.g_varchar2) <>
394: nvl(p_rec.information19, hr_api.g_varchar2) or
395: nvl(per_pat_shd.g_old_rec.information20, hr_api.g_varchar2) <>
396: nvl(p_rec.information20, hr_api.g_varchar2) ))

Line 393: nvl(per_pat_shd.g_old_rec.information19, hr_api.g_varchar2) <>

389: nvl(per_pat_shd.g_old_rec.information17, hr_api.g_varchar2) <>
390: nvl(p_rec.information17, hr_api.g_varchar2) or
391: nvl(per_pat_shd.g_old_rec.information18, hr_api.g_varchar2) <>
392: nvl(p_rec.information18, hr_api.g_varchar2) or
393: nvl(per_pat_shd.g_old_rec.information19, hr_api.g_varchar2) <>
394: nvl(p_rec.information19, hr_api.g_varchar2) or
395: nvl(per_pat_shd.g_old_rec.information20, hr_api.g_varchar2) <>
396: nvl(p_rec.information20, hr_api.g_varchar2) ))
397: or (p_rec.allocated_task_id is null) then

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

390: nvl(p_rec.information17, hr_api.g_varchar2) or
391: nvl(per_pat_shd.g_old_rec.information18, hr_api.g_varchar2) <>
392: nvl(p_rec.information18, hr_api.g_varchar2) or
393: nvl(per_pat_shd.g_old_rec.information19, hr_api.g_varchar2) <>
394: nvl(p_rec.information19, hr_api.g_varchar2) or
395: nvl(per_pat_shd.g_old_rec.information20, hr_api.g_varchar2) <>
396: nvl(p_rec.information20, hr_api.g_varchar2) ))
397: or (p_rec.allocated_task_id is null) then
398: --

Line 395: nvl(per_pat_shd.g_old_rec.information20, hr_api.g_varchar2) <>

391: nvl(per_pat_shd.g_old_rec.information18, hr_api.g_varchar2) <>
392: nvl(p_rec.information18, hr_api.g_varchar2) or
393: nvl(per_pat_shd.g_old_rec.information19, hr_api.g_varchar2) <>
394: nvl(p_rec.information19, hr_api.g_varchar2) or
395: nvl(per_pat_shd.g_old_rec.information20, hr_api.g_varchar2) <>
396: nvl(p_rec.information20, hr_api.g_varchar2) ))
397: or (p_rec.allocated_task_id is null) then
398: --
399: -- Only execute the validation if absolutely necessary:

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

392: nvl(p_rec.information18, hr_api.g_varchar2) or
393: nvl(per_pat_shd.g_old_rec.information19, hr_api.g_varchar2) <>
394: nvl(p_rec.information19, hr_api.g_varchar2) or
395: nvl(per_pat_shd.g_old_rec.information20, hr_api.g_varchar2) <>
396: nvl(p_rec.information20, hr_api.g_varchar2) ))
397: or (p_rec.allocated_task_id is null) then
398: --
399: -- Only execute the validation if absolutely necessary:
400: -- a) During update, the structure column value or any

Line 494: nvl(per_pat_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

490: hr_utility.set_location('Entering:'||l_proc,10);
491: --
492:
493: /* if ((p_rec.allocated_task_id is not null) and (
494: nvl(per_pat_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
495: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
496: nvl(per_pat_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
497: nvl(p_rec.attribute1, hr_api.g_varchar2) or
498: nvl(per_pat_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

491: --
492:
493: /* if ((p_rec.allocated_task_id is not null) and (
494: nvl(per_pat_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
495: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
496: nvl(per_pat_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
497: nvl(p_rec.attribute1, hr_api.g_varchar2) or
498: nvl(per_pat_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
499: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 496: nvl(per_pat_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

492:
493: /* if ((p_rec.allocated_task_id is not null) and (
494: nvl(per_pat_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
495: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
496: nvl(per_pat_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
497: nvl(p_rec.attribute1, hr_api.g_varchar2) or
498: nvl(per_pat_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
499: nvl(p_rec.attribute2, hr_api.g_varchar2) or
500: nvl(per_pat_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

493: /* if ((p_rec.allocated_task_id is not null) and (
494: nvl(per_pat_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
495: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
496: nvl(per_pat_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
497: nvl(p_rec.attribute1, hr_api.g_varchar2) or
498: nvl(per_pat_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
499: nvl(p_rec.attribute2, hr_api.g_varchar2) or
500: nvl(per_pat_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
501: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 498: nvl(per_pat_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

494: nvl(per_pat_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
495: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
496: nvl(per_pat_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
497: nvl(p_rec.attribute1, hr_api.g_varchar2) or
498: nvl(per_pat_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
499: nvl(p_rec.attribute2, hr_api.g_varchar2) or
500: nvl(per_pat_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
501: nvl(p_rec.attribute3, hr_api.g_varchar2) or
502: nvl(per_pat_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

495: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
496: nvl(per_pat_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
497: nvl(p_rec.attribute1, hr_api.g_varchar2) or
498: nvl(per_pat_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
499: nvl(p_rec.attribute2, hr_api.g_varchar2) or
500: nvl(per_pat_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
501: nvl(p_rec.attribute3, hr_api.g_varchar2) or
502: nvl(per_pat_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
503: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 500: nvl(per_pat_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

496: nvl(per_pat_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
497: nvl(p_rec.attribute1, hr_api.g_varchar2) or
498: nvl(per_pat_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
499: nvl(p_rec.attribute2, hr_api.g_varchar2) or
500: nvl(per_pat_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
501: nvl(p_rec.attribute3, hr_api.g_varchar2) or
502: nvl(per_pat_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
503: nvl(p_rec.attribute4, hr_api.g_varchar2) or
504: nvl(per_pat_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

497: nvl(p_rec.attribute1, hr_api.g_varchar2) or
498: nvl(per_pat_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
499: nvl(p_rec.attribute2, hr_api.g_varchar2) or
500: nvl(per_pat_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
501: nvl(p_rec.attribute3, hr_api.g_varchar2) or
502: nvl(per_pat_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
503: nvl(p_rec.attribute4, hr_api.g_varchar2) or
504: nvl(per_pat_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
505: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 502: nvl(per_pat_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

498: nvl(per_pat_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
499: nvl(p_rec.attribute2, hr_api.g_varchar2) or
500: nvl(per_pat_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
501: nvl(p_rec.attribute3, hr_api.g_varchar2) or
502: nvl(per_pat_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
503: nvl(p_rec.attribute4, hr_api.g_varchar2) or
504: nvl(per_pat_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
505: nvl(p_rec.attribute5, hr_api.g_varchar2) or
506: nvl(per_pat_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

499: nvl(p_rec.attribute2, hr_api.g_varchar2) or
500: nvl(per_pat_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
501: nvl(p_rec.attribute3, hr_api.g_varchar2) or
502: nvl(per_pat_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
503: nvl(p_rec.attribute4, hr_api.g_varchar2) or
504: nvl(per_pat_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
505: nvl(p_rec.attribute5, hr_api.g_varchar2) or
506: nvl(per_pat_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
507: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 504: nvl(per_pat_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

500: nvl(per_pat_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
501: nvl(p_rec.attribute3, hr_api.g_varchar2) or
502: nvl(per_pat_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
503: nvl(p_rec.attribute4, hr_api.g_varchar2) or
504: nvl(per_pat_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
505: nvl(p_rec.attribute5, hr_api.g_varchar2) or
506: nvl(per_pat_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
507: nvl(p_rec.attribute6, hr_api.g_varchar2) or
508: nvl(per_pat_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

501: nvl(p_rec.attribute3, hr_api.g_varchar2) or
502: nvl(per_pat_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
503: nvl(p_rec.attribute4, hr_api.g_varchar2) or
504: nvl(per_pat_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
505: nvl(p_rec.attribute5, hr_api.g_varchar2) or
506: nvl(per_pat_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
507: nvl(p_rec.attribute6, hr_api.g_varchar2) or
508: nvl(per_pat_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
509: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 506: nvl(per_pat_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

502: nvl(per_pat_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
503: nvl(p_rec.attribute4, hr_api.g_varchar2) or
504: nvl(per_pat_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
505: nvl(p_rec.attribute5, hr_api.g_varchar2) or
506: nvl(per_pat_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
507: nvl(p_rec.attribute6, hr_api.g_varchar2) or
508: nvl(per_pat_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
509: nvl(p_rec.attribute7, hr_api.g_varchar2) or
510: nvl(per_pat_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

503: nvl(p_rec.attribute4, hr_api.g_varchar2) or
504: nvl(per_pat_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
505: nvl(p_rec.attribute5, hr_api.g_varchar2) or
506: nvl(per_pat_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
507: nvl(p_rec.attribute6, hr_api.g_varchar2) or
508: nvl(per_pat_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
509: nvl(p_rec.attribute7, hr_api.g_varchar2) or
510: nvl(per_pat_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
511: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 508: nvl(per_pat_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

504: nvl(per_pat_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
505: nvl(p_rec.attribute5, hr_api.g_varchar2) or
506: nvl(per_pat_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
507: nvl(p_rec.attribute6, hr_api.g_varchar2) or
508: nvl(per_pat_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
509: nvl(p_rec.attribute7, hr_api.g_varchar2) or
510: nvl(per_pat_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
511: nvl(p_rec.attribute8, hr_api.g_varchar2) or
512: nvl(per_pat_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

505: nvl(p_rec.attribute5, hr_api.g_varchar2) or
506: nvl(per_pat_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
507: nvl(p_rec.attribute6, hr_api.g_varchar2) or
508: nvl(per_pat_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
509: nvl(p_rec.attribute7, hr_api.g_varchar2) or
510: nvl(per_pat_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
511: nvl(p_rec.attribute8, hr_api.g_varchar2) or
512: nvl(per_pat_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
513: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 510: nvl(per_pat_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

506: nvl(per_pat_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
507: nvl(p_rec.attribute6, hr_api.g_varchar2) or
508: nvl(per_pat_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
509: nvl(p_rec.attribute7, hr_api.g_varchar2) or
510: nvl(per_pat_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
511: nvl(p_rec.attribute8, hr_api.g_varchar2) or
512: nvl(per_pat_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
513: nvl(p_rec.attribute9, hr_api.g_varchar2) or
514: nvl(per_pat_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

507: nvl(p_rec.attribute6, hr_api.g_varchar2) or
508: nvl(per_pat_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
509: nvl(p_rec.attribute7, hr_api.g_varchar2) or
510: nvl(per_pat_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
511: nvl(p_rec.attribute8, hr_api.g_varchar2) or
512: nvl(per_pat_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
513: nvl(p_rec.attribute9, hr_api.g_varchar2) or
514: nvl(per_pat_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
515: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 512: nvl(per_pat_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

508: nvl(per_pat_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
509: nvl(p_rec.attribute7, hr_api.g_varchar2) or
510: nvl(per_pat_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
511: nvl(p_rec.attribute8, hr_api.g_varchar2) or
512: nvl(per_pat_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
513: nvl(p_rec.attribute9, hr_api.g_varchar2) or
514: nvl(per_pat_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
515: nvl(p_rec.attribute10, hr_api.g_varchar2) or
516: nvl(per_pat_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

509: nvl(p_rec.attribute7, hr_api.g_varchar2) or
510: nvl(per_pat_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
511: nvl(p_rec.attribute8, hr_api.g_varchar2) or
512: nvl(per_pat_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
513: nvl(p_rec.attribute9, hr_api.g_varchar2) or
514: nvl(per_pat_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
515: nvl(p_rec.attribute10, hr_api.g_varchar2) or
516: nvl(per_pat_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
517: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 514: nvl(per_pat_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

510: nvl(per_pat_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
511: nvl(p_rec.attribute8, hr_api.g_varchar2) or
512: nvl(per_pat_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
513: nvl(p_rec.attribute9, hr_api.g_varchar2) or
514: nvl(per_pat_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
515: nvl(p_rec.attribute10, hr_api.g_varchar2) or
516: nvl(per_pat_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
517: nvl(p_rec.attribute11, hr_api.g_varchar2) or
518: nvl(per_pat_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

511: nvl(p_rec.attribute8, hr_api.g_varchar2) or
512: nvl(per_pat_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
513: nvl(p_rec.attribute9, hr_api.g_varchar2) or
514: nvl(per_pat_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
515: nvl(p_rec.attribute10, hr_api.g_varchar2) or
516: nvl(per_pat_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
517: nvl(p_rec.attribute11, hr_api.g_varchar2) or
518: nvl(per_pat_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
519: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 516: nvl(per_pat_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

512: nvl(per_pat_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
513: nvl(p_rec.attribute9, hr_api.g_varchar2) or
514: nvl(per_pat_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
515: nvl(p_rec.attribute10, hr_api.g_varchar2) or
516: nvl(per_pat_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
517: nvl(p_rec.attribute11, hr_api.g_varchar2) or
518: nvl(per_pat_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
519: nvl(p_rec.attribute12, hr_api.g_varchar2) or
520: nvl(per_pat_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

513: nvl(p_rec.attribute9, hr_api.g_varchar2) or
514: nvl(per_pat_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
515: nvl(p_rec.attribute10, hr_api.g_varchar2) or
516: nvl(per_pat_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
517: nvl(p_rec.attribute11, hr_api.g_varchar2) or
518: nvl(per_pat_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
519: nvl(p_rec.attribute12, hr_api.g_varchar2) or
520: nvl(per_pat_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
521: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 518: nvl(per_pat_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

514: nvl(per_pat_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
515: nvl(p_rec.attribute10, hr_api.g_varchar2) or
516: nvl(per_pat_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
517: nvl(p_rec.attribute11, hr_api.g_varchar2) or
518: nvl(per_pat_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
519: nvl(p_rec.attribute12, hr_api.g_varchar2) or
520: nvl(per_pat_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
521: nvl(p_rec.attribute13, hr_api.g_varchar2) or
522: nvl(per_pat_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

515: nvl(p_rec.attribute10, hr_api.g_varchar2) or
516: nvl(per_pat_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
517: nvl(p_rec.attribute11, hr_api.g_varchar2) or
518: nvl(per_pat_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
519: nvl(p_rec.attribute12, hr_api.g_varchar2) or
520: nvl(per_pat_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
521: nvl(p_rec.attribute13, hr_api.g_varchar2) or
522: nvl(per_pat_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
523: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 520: nvl(per_pat_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

516: nvl(per_pat_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
517: nvl(p_rec.attribute11, hr_api.g_varchar2) or
518: nvl(per_pat_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
519: nvl(p_rec.attribute12, hr_api.g_varchar2) or
520: nvl(per_pat_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
521: nvl(p_rec.attribute13, hr_api.g_varchar2) or
522: nvl(per_pat_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
523: nvl(p_rec.attribute14, hr_api.g_varchar2) or
524: nvl(per_pat_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

517: nvl(p_rec.attribute11, hr_api.g_varchar2) or
518: nvl(per_pat_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
519: nvl(p_rec.attribute12, hr_api.g_varchar2) or
520: nvl(per_pat_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
521: nvl(p_rec.attribute13, hr_api.g_varchar2) or
522: nvl(per_pat_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
523: nvl(p_rec.attribute14, hr_api.g_varchar2) or
524: nvl(per_pat_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
525: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 522: nvl(per_pat_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

518: nvl(per_pat_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
519: nvl(p_rec.attribute12, hr_api.g_varchar2) or
520: nvl(per_pat_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
521: nvl(p_rec.attribute13, hr_api.g_varchar2) or
522: nvl(per_pat_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
523: nvl(p_rec.attribute14, hr_api.g_varchar2) or
524: nvl(per_pat_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
525: nvl(p_rec.attribute15, hr_api.g_varchar2) or
526: nvl(per_pat_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

519: nvl(p_rec.attribute12, hr_api.g_varchar2) or
520: nvl(per_pat_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
521: nvl(p_rec.attribute13, hr_api.g_varchar2) or
522: nvl(per_pat_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
523: nvl(p_rec.attribute14, hr_api.g_varchar2) or
524: nvl(per_pat_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
525: nvl(p_rec.attribute15, hr_api.g_varchar2) or
526: nvl(per_pat_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
527: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 524: nvl(per_pat_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

520: nvl(per_pat_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
521: nvl(p_rec.attribute13, hr_api.g_varchar2) or
522: nvl(per_pat_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
523: nvl(p_rec.attribute14, hr_api.g_varchar2) or
524: nvl(per_pat_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
525: nvl(p_rec.attribute15, hr_api.g_varchar2) or
526: nvl(per_pat_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
527: nvl(p_rec.attribute16, hr_api.g_varchar2) or
528: nvl(per_pat_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

521: nvl(p_rec.attribute13, hr_api.g_varchar2) or
522: nvl(per_pat_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
523: nvl(p_rec.attribute14, hr_api.g_varchar2) or
524: nvl(per_pat_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
525: nvl(p_rec.attribute15, hr_api.g_varchar2) or
526: nvl(per_pat_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
527: nvl(p_rec.attribute16, hr_api.g_varchar2) or
528: nvl(per_pat_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
529: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 526: nvl(per_pat_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

522: nvl(per_pat_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
523: nvl(p_rec.attribute14, hr_api.g_varchar2) or
524: nvl(per_pat_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
525: nvl(p_rec.attribute15, hr_api.g_varchar2) or
526: nvl(per_pat_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
527: nvl(p_rec.attribute16, hr_api.g_varchar2) or
528: nvl(per_pat_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
529: nvl(p_rec.attribute17, hr_api.g_varchar2) or
530: nvl(per_pat_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

523: nvl(p_rec.attribute14, hr_api.g_varchar2) or
524: nvl(per_pat_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
525: nvl(p_rec.attribute15, hr_api.g_varchar2) or
526: nvl(per_pat_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
527: nvl(p_rec.attribute16, hr_api.g_varchar2) or
528: nvl(per_pat_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
529: nvl(p_rec.attribute17, hr_api.g_varchar2) or
530: nvl(per_pat_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
531: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 528: nvl(per_pat_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

524: nvl(per_pat_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
525: nvl(p_rec.attribute15, hr_api.g_varchar2) or
526: nvl(per_pat_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
527: nvl(p_rec.attribute16, hr_api.g_varchar2) or
528: nvl(per_pat_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
529: nvl(p_rec.attribute17, hr_api.g_varchar2) or
530: nvl(per_pat_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
531: nvl(p_rec.attribute18, hr_api.g_varchar2) or
532: nvl(per_pat_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

525: nvl(p_rec.attribute15, hr_api.g_varchar2) or
526: nvl(per_pat_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
527: nvl(p_rec.attribute16, hr_api.g_varchar2) or
528: nvl(per_pat_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
529: nvl(p_rec.attribute17, hr_api.g_varchar2) or
530: nvl(per_pat_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
531: nvl(p_rec.attribute18, hr_api.g_varchar2) or
532: nvl(per_pat_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
533: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 530: nvl(per_pat_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

526: nvl(per_pat_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
527: nvl(p_rec.attribute16, hr_api.g_varchar2) or
528: nvl(per_pat_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
529: nvl(p_rec.attribute17, hr_api.g_varchar2) or
530: nvl(per_pat_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
531: nvl(p_rec.attribute18, hr_api.g_varchar2) or
532: nvl(per_pat_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
533: nvl(p_rec.attribute19, hr_api.g_varchar2) or
534: nvl(per_pat_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

527: nvl(p_rec.attribute16, hr_api.g_varchar2) or
528: nvl(per_pat_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
529: nvl(p_rec.attribute17, hr_api.g_varchar2) or
530: nvl(per_pat_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
531: nvl(p_rec.attribute18, hr_api.g_varchar2) or
532: nvl(per_pat_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
533: nvl(p_rec.attribute19, hr_api.g_varchar2) or
534: nvl(per_pat_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
535: nvl(p_rec.attribute20, hr_api.g_varchar2) ))

Line 532: nvl(per_pat_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

528: nvl(per_pat_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
529: nvl(p_rec.attribute17, hr_api.g_varchar2) or
530: nvl(per_pat_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
531: nvl(p_rec.attribute18, hr_api.g_varchar2) or
532: nvl(per_pat_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
533: nvl(p_rec.attribute19, hr_api.g_varchar2) or
534: nvl(per_pat_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
535: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
536: or (p_rec.allocated_task_id is null) then

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

529: nvl(p_rec.attribute17, hr_api.g_varchar2) or
530: nvl(per_pat_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
531: nvl(p_rec.attribute18, hr_api.g_varchar2) or
532: nvl(per_pat_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
533: nvl(p_rec.attribute19, hr_api.g_varchar2) or
534: nvl(per_pat_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
535: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
536: or (p_rec.allocated_task_id is null) then
537: --

Line 534: nvl(per_pat_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

530: nvl(per_pat_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
531: nvl(p_rec.attribute18, hr_api.g_varchar2) or
532: nvl(per_pat_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
533: nvl(p_rec.attribute19, hr_api.g_varchar2) or
534: nvl(per_pat_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
535: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
536: or (p_rec.allocated_task_id is null) then
537: --
538: -- Only execute the validation if absolutely necessary:

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

531: nvl(p_rec.attribute18, hr_api.g_varchar2) or
532: nvl(per_pat_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
533: nvl(p_rec.attribute19, hr_api.g_varchar2) or
534: nvl(per_pat_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
535: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
536: or (p_rec.allocated_task_id is null) then
537: --
538: -- Only execute the validation if absolutely necessary:
539: -- a) During update, the structure column value or any