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.HR_ITP_BUS dependencies on HR_API

Line 87: hr_api.mandatory_arg_error

83: hr_utility.set_location('Entering:'|| l_proc, 10);
84: --
85: -- Ensure that all the mandatory parameter are not null
86: --
87: hr_api.mandatory_arg_error
88: (p_api_name => l_proc
89: ,p_argument => 'item_property_id'
90: ,p_argument_value => p_item_property_id
91: );

Line 93: if ( nvl(hr_itp_bus.g_item_property_id, hr_api.g_number)

89: ,p_argument => 'item_property_id'
90: ,p_argument_value => p_item_property_id
91: );
92: --
93: if ( nvl(hr_itp_bus.g_item_property_id, hr_api.g_number)
94: = p_item_property_id) then
95: --
96: -- The legislation code has already been found with a previous
97: -- call to this function. Just return the value in the global

Line 189: (nvl(hr_itp_shd.g_old_rec.previous_navigation_item_id,hr_api.g_number)

185: hr_utility.set_location('Entering:'||l_proc, 10);
186:
187: IF (p_item_property_id is not null
188: and ((p_previous_navigation_item_id is not null and
189: (nvl(hr_itp_shd.g_old_rec.previous_navigation_item_id,hr_api.g_number)
190: <> nvl(p_previous_navigation_item_id,hr_api.g_number)))
191: or (p_next_navigation_item_id is not null and
192: (nvl(hr_itp_shd.g_old_rec.next_navigation_item_id,hr_api.g_number)
193: <> nvl(p_next_navigation_item_id,hr_api.g_number)))))

Line 190: <> nvl(p_previous_navigation_item_id,hr_api.g_number)))

186:
187: IF (p_item_property_id is not null
188: and ((p_previous_navigation_item_id is not null and
189: (nvl(hr_itp_shd.g_old_rec.previous_navigation_item_id,hr_api.g_number)
190: <> nvl(p_previous_navigation_item_id,hr_api.g_number)))
191: or (p_next_navigation_item_id is not null and
192: (nvl(hr_itp_shd.g_old_rec.next_navigation_item_id,hr_api.g_number)
193: <> nvl(p_next_navigation_item_id,hr_api.g_number)))))
194: or ( p_item_property_id is null and

Line 192: (nvl(hr_itp_shd.g_old_rec.next_navigation_item_id,hr_api.g_number)

188: and ((p_previous_navigation_item_id is not null and
189: (nvl(hr_itp_shd.g_old_rec.previous_navigation_item_id,hr_api.g_number)
190: <> nvl(p_previous_navigation_item_id,hr_api.g_number)))
191: or (p_next_navigation_item_id is not null and
192: (nvl(hr_itp_shd.g_old_rec.next_navigation_item_id,hr_api.g_number)
193: <> nvl(p_next_navigation_item_id,hr_api.g_number)))))
194: or ( p_item_property_id is null and
195: ( p_previous_navigation_item_id is not null
196: or p_next_navigation_item_id is not null )) THEN

Line 193: <> nvl(p_next_navigation_item_id,hr_api.g_number)))))

189: (nvl(hr_itp_shd.g_old_rec.previous_navigation_item_id,hr_api.g_number)
190: <> nvl(p_previous_navigation_item_id,hr_api.g_number)))
191: or (p_next_navigation_item_id is not null and
192: (nvl(hr_itp_shd.g_old_rec.next_navigation_item_id,hr_api.g_number)
193: <> nvl(p_next_navigation_item_id,hr_api.g_number)))))
194: or ( p_item_property_id is null and
195: ( p_previous_navigation_item_id is not null
196: or p_next_navigation_item_id is not null )) THEN
197:

Line 227: (nvl(hr_itp_shd.g_old_rec.previous_navigation_item_id,hr_api.g_number)

223: END IF;
224:
225: if (p_item_property_id is not null
226: and (p_previous_navigation_item_id is not null and
227: (nvl(hr_itp_shd.g_old_rec.previous_navigation_item_id,hr_api.g_number)
228: <> nvl(p_previous_navigation_item_id,hr_api.g_number))))
229: or (p_item_property_id is null
230: and p_previous_navigation_item_id is not null) then
231:

Line 228: <> nvl(p_previous_navigation_item_id,hr_api.g_number))))

224:
225: if (p_item_property_id is not null
226: and (p_previous_navigation_item_id is not null and
227: (nvl(hr_itp_shd.g_old_rec.previous_navigation_item_id,hr_api.g_number)
228: <> nvl(p_previous_navigation_item_id,hr_api.g_number))))
229: or (p_item_property_id is null
230: and p_previous_navigation_item_id is not null) then
231:
232: OPEN cur_item(p_previous_navigation_item_id);

Line 259: (nvl(hr_itp_shd.g_old_rec.next_navigation_item_id,hr_api.g_number)

255: hr_utility.set_location('Leaving:'||l_proc, 20);
256:
257: if (p_item_property_id is not null and
258: (p_next_navigation_item_id is not null and
259: (nvl(hr_itp_shd.g_old_rec.next_navigation_item_id,hr_api.g_number)
260: <> nvl(p_next_navigation_item_id,hr_api.g_number))))
261: or (p_item_property_id is null and p_next_navigation_item_id is not null)
262: then
263:

Line 260: <> nvl(p_next_navigation_item_id,hr_api.g_number))))

256:
257: if (p_item_property_id is not null and
258: (p_next_navigation_item_id is not null and
259: (nvl(hr_itp_shd.g_old_rec.next_navigation_item_id,hr_api.g_number)
260: <> nvl(p_next_navigation_item_id,hr_api.g_number))))
261: or (p_item_property_id is null and p_next_navigation_item_id is not null)
262: then
263:
264: OPEN cur_item(p_next_navigation_item_id);

Line 296: (p_form_item_id in number default hr_api.g_number

292: -- ---------------------------------------------------------------------------
293: -- |---------------------------< return_item_type >--------------------------|
294: -- ---------------------------------------------------------------------------
295: FUNCTION return_item_type
296: (p_form_item_id in number default hr_api.g_number
297: ,p_template_item_id in number default hr_api.g_number
298: ,p_template_item_context_id in number default hr_api.g_number
299: ) RETURN varchar2 is
300: --

Line 297: ,p_template_item_id in number default hr_api.g_number

293: -- |---------------------------< return_item_type >--------------------------|
294: -- ---------------------------------------------------------------------------
295: FUNCTION return_item_type
296: (p_form_item_id in number default hr_api.g_number
297: ,p_template_item_id in number default hr_api.g_number
298: ,p_template_item_context_id in number default hr_api.g_number
299: ) RETURN varchar2 is
300: --
301: -- Declare cursors

Line 298: ,p_template_item_context_id in number default hr_api.g_number

294: -- ---------------------------------------------------------------------------
295: FUNCTION return_item_type
296: (p_form_item_id in number default hr_api.g_number
297: ,p_template_item_id in number default hr_api.g_number
298: ,p_template_item_context_id in number default hr_api.g_number
299: ) RETURN varchar2 is
300: --
301: -- Declare cursors
302: --

Line 333: if ( nvl(hr_itp_bus.g_form_item_id, hr_api.g_number) = nvl(p_form_item_id, hr_api.g_number)

329: Begin
330: --
331: hr_utility.set_location('Entering:'|| l_proc, 10);
332: --
333: if ( nvl(hr_itp_bus.g_form_item_id, hr_api.g_number) = nvl(p_form_item_id, hr_api.g_number)
334: and nvl(hr_itp_bus.g_template_item_id, hr_api.g_number) = nvl(p_template_item_id, hr_api.g_number)
335: and nvl(hr_itp_bus.g_template_item_context_id, hr_api.g_number) = nvl(p_template_item_context_id, hr_api.g_number)
336: ) then
337: --

Line 334: and nvl(hr_itp_bus.g_template_item_id, hr_api.g_number) = nvl(p_template_item_id, hr_api.g_number)

330: --
331: hr_utility.set_location('Entering:'|| l_proc, 10);
332: --
333: if ( nvl(hr_itp_bus.g_form_item_id, hr_api.g_number) = nvl(p_form_item_id, hr_api.g_number)
334: and nvl(hr_itp_bus.g_template_item_id, hr_api.g_number) = nvl(p_template_item_id, hr_api.g_number)
335: and nvl(hr_itp_bus.g_template_item_context_id, hr_api.g_number) = nvl(p_template_item_context_id, hr_api.g_number)
336: ) then
337: --
338: -- The item has already been found with a previous

Line 335: and nvl(hr_itp_bus.g_template_item_context_id, hr_api.g_number) = nvl(p_template_item_context_id, hr_api.g_number)

331: hr_utility.set_location('Entering:'|| l_proc, 10);
332: --
333: if ( nvl(hr_itp_bus.g_form_item_id, hr_api.g_number) = nvl(p_form_item_id, hr_api.g_number)
334: and nvl(hr_itp_bus.g_template_item_id, hr_api.g_number) = nvl(p_template_item_id, hr_api.g_number)
335: and nvl(hr_itp_bus.g_template_item_context_id, hr_api.g_number) = nvl(p_template_item_context_id, hr_api.g_number)
336: ) then
337: --
338: -- The item has already been found with a previous
339: -- call to this function. Just return the value in the global

Line 349: if (nvl(p_form_item_id, hr_api.g_number) <> hr_api.g_number) then

345: --
346: -- The IDs are different to the last call to this function
347: -- or this is the first call to this function.
348: --
349: if (nvl(p_form_item_id, hr_api.g_number) <> hr_api.g_number) then
350: --
351: open csr_form_item;
352: fetch csr_form_item into l_item_type;
353: --

Line 367: elsif (nvl(p_template_item_id, hr_api.g_number) <> hr_api.g_number) then

363: end if;
364: hr_utility.set_location(l_proc,30);
365: close csr_form_item;
366: --
367: elsif (nvl(p_template_item_id, hr_api.g_number) <> hr_api.g_number) then
368: --
369: open csr_template_item;
370: fetch csr_template_item into l_item_type;
371: --

Line 385: elsif (nvl(p_template_item_context_id, hr_api.g_number) <> hr_api.g_number) then

381: end if;
382: hr_utility.set_location(l_proc,40);
383: close csr_template_item;
384: --
385: elsif (nvl(p_template_item_context_id, hr_api.g_number) <> hr_api.g_number) then
386: --
387: open csr_template_item_context;
388: fetch csr_template_item_context into l_item_type;
389: --

Line 455: nvl(hr_itp_shd.g_old_rec.information_formula_id, hr_api.g_number) <>

451: begin
452: hr_utility.set_location('Entering:'||l_proc,10);
453: --
454: if ((p_rec.item_property_id is not null) and (
455: nvl(hr_itp_shd.g_old_rec.information_formula_id, hr_api.g_number) <>
456: nvl(p_rec.information_formula_id, hr_api.g_number) or
457: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id1, hr_api.g_number)
458: <>
459: nvl(p_rec.information_parameter_item_id1, hr_api.g_number) or

Line 456: nvl(p_rec.information_formula_id, hr_api.g_number) or

452: hr_utility.set_location('Entering:'||l_proc,10);
453: --
454: if ((p_rec.item_property_id is not null) and (
455: nvl(hr_itp_shd.g_old_rec.information_formula_id, hr_api.g_number) <>
456: nvl(p_rec.information_formula_id, hr_api.g_number) or
457: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id1, hr_api.g_number)
458: <>
459: nvl(p_rec.information_parameter_item_id1, hr_api.g_number) or
460: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id2, hr_api.g_number)

Line 457: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id1, hr_api.g_number)

453: --
454: if ((p_rec.item_property_id is not null) and (
455: nvl(hr_itp_shd.g_old_rec.information_formula_id, hr_api.g_number) <>
456: nvl(p_rec.information_formula_id, hr_api.g_number) or
457: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id1, hr_api.g_number)
458: <>
459: nvl(p_rec.information_parameter_item_id1, hr_api.g_number) or
460: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id2, hr_api.g_number)
461: <>

Line 459: nvl(p_rec.information_parameter_item_id1, hr_api.g_number) or

455: nvl(hr_itp_shd.g_old_rec.information_formula_id, hr_api.g_number) <>
456: nvl(p_rec.information_formula_id, hr_api.g_number) or
457: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id1, hr_api.g_number)
458: <>
459: nvl(p_rec.information_parameter_item_id1, hr_api.g_number) or
460: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id2, hr_api.g_number)
461: <>
462: nvl(p_rec.information_parameter_item_id2, hr_api.g_number) or
463: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id3, hr_api.g_number)

Line 460: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id2, hr_api.g_number)

456: nvl(p_rec.information_formula_id, hr_api.g_number) or
457: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id1, hr_api.g_number)
458: <>
459: nvl(p_rec.information_parameter_item_id1, hr_api.g_number) or
460: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id2, hr_api.g_number)
461: <>
462: nvl(p_rec.information_parameter_item_id2, hr_api.g_number) or
463: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id3, hr_api.g_number)
464: <>

Line 462: nvl(p_rec.information_parameter_item_id2, hr_api.g_number) or

458: <>
459: nvl(p_rec.information_parameter_item_id1, hr_api.g_number) or
460: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id2, hr_api.g_number)
461: <>
462: nvl(p_rec.information_parameter_item_id2, hr_api.g_number) or
463: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id3, hr_api.g_number)
464: <>
465: nvl(p_rec.information_parameter_item_id3, hr_api.g_number) or
466: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id4, hr_api.g_number)

Line 463: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id3, hr_api.g_number)

459: nvl(p_rec.information_parameter_item_id1, hr_api.g_number) or
460: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id2, hr_api.g_number)
461: <>
462: nvl(p_rec.information_parameter_item_id2, hr_api.g_number) or
463: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id3, hr_api.g_number)
464: <>
465: nvl(p_rec.information_parameter_item_id3, hr_api.g_number) or
466: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id4, hr_api.g_number)
467: <>

Line 465: nvl(p_rec.information_parameter_item_id3, hr_api.g_number) or

461: <>
462: nvl(p_rec.information_parameter_item_id2, hr_api.g_number) or
463: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id3, hr_api.g_number)
464: <>
465: nvl(p_rec.information_parameter_item_id3, hr_api.g_number) or
466: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id4, hr_api.g_number)
467: <>
468: nvl(p_rec.information_parameter_item_id4, hr_api.g_number) or
469: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id5, hr_api.g_number)

Line 466: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id4, hr_api.g_number)

462: nvl(p_rec.information_parameter_item_id2, hr_api.g_number) or
463: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id3, hr_api.g_number)
464: <>
465: nvl(p_rec.information_parameter_item_id3, hr_api.g_number) or
466: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id4, hr_api.g_number)
467: <>
468: nvl(p_rec.information_parameter_item_id4, hr_api.g_number) or
469: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id5, hr_api.g_number)
470: <>

Line 468: nvl(p_rec.information_parameter_item_id4, hr_api.g_number) or

464: <>
465: nvl(p_rec.information_parameter_item_id3, hr_api.g_number) or
466: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id4, hr_api.g_number)
467: <>
468: nvl(p_rec.information_parameter_item_id4, hr_api.g_number) or
469: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id5, hr_api.g_number)
470: <>
471: nvl(p_rec.information_parameter_item_id5, hr_api.g_number) or
472: nvl(hr_itp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

Line 469: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id5, hr_api.g_number)

465: nvl(p_rec.information_parameter_item_id3, hr_api.g_number) or
466: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id4, hr_api.g_number)
467: <>
468: nvl(p_rec.information_parameter_item_id4, hr_api.g_number) or
469: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id5, hr_api.g_number)
470: <>
471: nvl(p_rec.information_parameter_item_id5, hr_api.g_number) or
472: nvl(hr_itp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
473: nvl(p_rec.information_category, hr_api.g_varchar2) or

Line 471: nvl(p_rec.information_parameter_item_id5, hr_api.g_number) or

467: <>
468: nvl(p_rec.information_parameter_item_id4, hr_api.g_number) or
469: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id5, hr_api.g_number)
470: <>
471: nvl(p_rec.information_parameter_item_id5, hr_api.g_number) or
472: nvl(hr_itp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
473: nvl(p_rec.information_category, hr_api.g_varchar2) or
474: nvl(hr_itp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
475: nvl(p_rec.information1, hr_api.g_varchar2) or

Line 472: nvl(hr_itp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

468: nvl(p_rec.information_parameter_item_id4, hr_api.g_number) or
469: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id5, hr_api.g_number)
470: <>
471: nvl(p_rec.information_parameter_item_id5, hr_api.g_number) or
472: nvl(hr_itp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
473: nvl(p_rec.information_category, hr_api.g_varchar2) or
474: nvl(hr_itp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
475: nvl(p_rec.information1, hr_api.g_varchar2) or
476: nvl(hr_itp_shd.g_old_rec.information2, hr_api.g_varchar2) <>

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

469: nvl(hr_itp_shd.g_old_rec.information_parameter_item_id5, hr_api.g_number)
470: <>
471: nvl(p_rec.information_parameter_item_id5, hr_api.g_number) or
472: nvl(hr_itp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
473: nvl(p_rec.information_category, hr_api.g_varchar2) or
474: nvl(hr_itp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
475: nvl(p_rec.information1, hr_api.g_varchar2) or
476: nvl(hr_itp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
477: nvl(p_rec.information2, hr_api.g_varchar2) or

Line 474: nvl(hr_itp_shd.g_old_rec.information1, hr_api.g_varchar2) <>

470: <>
471: nvl(p_rec.information_parameter_item_id5, hr_api.g_number) or
472: nvl(hr_itp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
473: nvl(p_rec.information_category, hr_api.g_varchar2) or
474: nvl(hr_itp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
475: nvl(p_rec.information1, hr_api.g_varchar2) or
476: nvl(hr_itp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
477: nvl(p_rec.information2, hr_api.g_varchar2) or
478: nvl(hr_itp_shd.g_old_rec.information3, hr_api.g_varchar2) <>

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

471: nvl(p_rec.information_parameter_item_id5, hr_api.g_number) or
472: nvl(hr_itp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
473: nvl(p_rec.information_category, hr_api.g_varchar2) or
474: nvl(hr_itp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
475: nvl(p_rec.information1, hr_api.g_varchar2) or
476: nvl(hr_itp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
477: nvl(p_rec.information2, hr_api.g_varchar2) or
478: nvl(hr_itp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
479: nvl(p_rec.information3, hr_api.g_varchar2) or

Line 476: nvl(hr_itp_shd.g_old_rec.information2, hr_api.g_varchar2) <>

472: nvl(hr_itp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
473: nvl(p_rec.information_category, hr_api.g_varchar2) or
474: nvl(hr_itp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
475: nvl(p_rec.information1, hr_api.g_varchar2) or
476: nvl(hr_itp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
477: nvl(p_rec.information2, hr_api.g_varchar2) or
478: nvl(hr_itp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
479: nvl(p_rec.information3, hr_api.g_varchar2) or
480: nvl(hr_itp_shd.g_old_rec.information4, hr_api.g_varchar2) <>

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

473: nvl(p_rec.information_category, hr_api.g_varchar2) or
474: nvl(hr_itp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
475: nvl(p_rec.information1, hr_api.g_varchar2) or
476: nvl(hr_itp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
477: nvl(p_rec.information2, hr_api.g_varchar2) or
478: nvl(hr_itp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
479: nvl(p_rec.information3, hr_api.g_varchar2) or
480: nvl(hr_itp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
481: nvl(p_rec.information4, hr_api.g_varchar2) or

Line 478: nvl(hr_itp_shd.g_old_rec.information3, hr_api.g_varchar2) <>

474: nvl(hr_itp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
475: nvl(p_rec.information1, hr_api.g_varchar2) or
476: nvl(hr_itp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
477: nvl(p_rec.information2, hr_api.g_varchar2) or
478: nvl(hr_itp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
479: nvl(p_rec.information3, hr_api.g_varchar2) or
480: nvl(hr_itp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
481: nvl(p_rec.information4, hr_api.g_varchar2) or
482: nvl(hr_itp_shd.g_old_rec.information5, hr_api.g_varchar2) <>

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

475: nvl(p_rec.information1, hr_api.g_varchar2) or
476: nvl(hr_itp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
477: nvl(p_rec.information2, hr_api.g_varchar2) or
478: nvl(hr_itp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
479: nvl(p_rec.information3, hr_api.g_varchar2) or
480: nvl(hr_itp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
481: nvl(p_rec.information4, hr_api.g_varchar2) or
482: nvl(hr_itp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
483: nvl(p_rec.information5, hr_api.g_varchar2) or

Line 480: nvl(hr_itp_shd.g_old_rec.information4, hr_api.g_varchar2) <>

476: nvl(hr_itp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
477: nvl(p_rec.information2, hr_api.g_varchar2) or
478: nvl(hr_itp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
479: nvl(p_rec.information3, hr_api.g_varchar2) or
480: nvl(hr_itp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
481: nvl(p_rec.information4, hr_api.g_varchar2) or
482: nvl(hr_itp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
483: nvl(p_rec.information5, hr_api.g_varchar2) or
484: nvl(hr_itp_shd.g_old_rec.information6, hr_api.g_varchar2) <>

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

477: nvl(p_rec.information2, hr_api.g_varchar2) or
478: nvl(hr_itp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
479: nvl(p_rec.information3, hr_api.g_varchar2) or
480: nvl(hr_itp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
481: nvl(p_rec.information4, hr_api.g_varchar2) or
482: nvl(hr_itp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
483: nvl(p_rec.information5, hr_api.g_varchar2) or
484: nvl(hr_itp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
485: nvl(p_rec.information6, hr_api.g_varchar2) or

Line 482: nvl(hr_itp_shd.g_old_rec.information5, hr_api.g_varchar2) <>

478: nvl(hr_itp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
479: nvl(p_rec.information3, hr_api.g_varchar2) or
480: nvl(hr_itp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
481: nvl(p_rec.information4, hr_api.g_varchar2) or
482: nvl(hr_itp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
483: nvl(p_rec.information5, hr_api.g_varchar2) or
484: nvl(hr_itp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
485: nvl(p_rec.information6, hr_api.g_varchar2) or
486: nvl(hr_itp_shd.g_old_rec.information7, hr_api.g_varchar2) <>

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

479: nvl(p_rec.information3, hr_api.g_varchar2) or
480: nvl(hr_itp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
481: nvl(p_rec.information4, hr_api.g_varchar2) or
482: nvl(hr_itp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
483: nvl(p_rec.information5, hr_api.g_varchar2) or
484: nvl(hr_itp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
485: nvl(p_rec.information6, hr_api.g_varchar2) or
486: nvl(hr_itp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
487: nvl(p_rec.information7, hr_api.g_varchar2) or

Line 484: nvl(hr_itp_shd.g_old_rec.information6, hr_api.g_varchar2) <>

480: nvl(hr_itp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
481: nvl(p_rec.information4, hr_api.g_varchar2) or
482: nvl(hr_itp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
483: nvl(p_rec.information5, hr_api.g_varchar2) or
484: nvl(hr_itp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
485: nvl(p_rec.information6, hr_api.g_varchar2) or
486: nvl(hr_itp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
487: nvl(p_rec.information7, hr_api.g_varchar2) or
488: nvl(hr_itp_shd.g_old_rec.information8, hr_api.g_varchar2) <>

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

481: nvl(p_rec.information4, hr_api.g_varchar2) or
482: nvl(hr_itp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
483: nvl(p_rec.information5, hr_api.g_varchar2) or
484: nvl(hr_itp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
485: nvl(p_rec.information6, hr_api.g_varchar2) or
486: nvl(hr_itp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
487: nvl(p_rec.information7, hr_api.g_varchar2) or
488: nvl(hr_itp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
489: nvl(p_rec.information8, hr_api.g_varchar2) or

Line 486: nvl(hr_itp_shd.g_old_rec.information7, hr_api.g_varchar2) <>

482: nvl(hr_itp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
483: nvl(p_rec.information5, hr_api.g_varchar2) or
484: nvl(hr_itp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
485: nvl(p_rec.information6, hr_api.g_varchar2) or
486: nvl(hr_itp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
487: nvl(p_rec.information7, hr_api.g_varchar2) or
488: nvl(hr_itp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
489: nvl(p_rec.information8, hr_api.g_varchar2) or
490: nvl(hr_itp_shd.g_old_rec.information9, hr_api.g_varchar2) <>

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

483: nvl(p_rec.information5, hr_api.g_varchar2) or
484: nvl(hr_itp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
485: nvl(p_rec.information6, hr_api.g_varchar2) or
486: nvl(hr_itp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
487: nvl(p_rec.information7, hr_api.g_varchar2) or
488: nvl(hr_itp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
489: nvl(p_rec.information8, hr_api.g_varchar2) or
490: nvl(hr_itp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
491: nvl(p_rec.information9, hr_api.g_varchar2) or

Line 488: nvl(hr_itp_shd.g_old_rec.information8, hr_api.g_varchar2) <>

484: nvl(hr_itp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
485: nvl(p_rec.information6, hr_api.g_varchar2) or
486: nvl(hr_itp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
487: nvl(p_rec.information7, hr_api.g_varchar2) or
488: nvl(hr_itp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
489: nvl(p_rec.information8, hr_api.g_varchar2) or
490: nvl(hr_itp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
491: nvl(p_rec.information9, hr_api.g_varchar2) or
492: nvl(hr_itp_shd.g_old_rec.information10, hr_api.g_varchar2) <>

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

485: nvl(p_rec.information6, hr_api.g_varchar2) or
486: nvl(hr_itp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
487: nvl(p_rec.information7, hr_api.g_varchar2) or
488: nvl(hr_itp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
489: nvl(p_rec.information8, hr_api.g_varchar2) or
490: nvl(hr_itp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
491: nvl(p_rec.information9, hr_api.g_varchar2) or
492: nvl(hr_itp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
493: nvl(p_rec.information10, hr_api.g_varchar2) or

Line 490: nvl(hr_itp_shd.g_old_rec.information9, hr_api.g_varchar2) <>

486: nvl(hr_itp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
487: nvl(p_rec.information7, hr_api.g_varchar2) or
488: nvl(hr_itp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
489: nvl(p_rec.information8, hr_api.g_varchar2) or
490: nvl(hr_itp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
491: nvl(p_rec.information9, hr_api.g_varchar2) or
492: nvl(hr_itp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
493: nvl(p_rec.information10, hr_api.g_varchar2) or
494: nvl(hr_itp_shd.g_old_rec.information11, hr_api.g_varchar2) <>

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

487: nvl(p_rec.information7, hr_api.g_varchar2) or
488: nvl(hr_itp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
489: nvl(p_rec.information8, hr_api.g_varchar2) or
490: nvl(hr_itp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
491: nvl(p_rec.information9, hr_api.g_varchar2) or
492: nvl(hr_itp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
493: nvl(p_rec.information10, hr_api.g_varchar2) or
494: nvl(hr_itp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
495: nvl(p_rec.information11, hr_api.g_varchar2) or

Line 492: nvl(hr_itp_shd.g_old_rec.information10, hr_api.g_varchar2) <>

488: nvl(hr_itp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
489: nvl(p_rec.information8, hr_api.g_varchar2) or
490: nvl(hr_itp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
491: nvl(p_rec.information9, hr_api.g_varchar2) or
492: nvl(hr_itp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
493: nvl(p_rec.information10, hr_api.g_varchar2) or
494: nvl(hr_itp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
495: nvl(p_rec.information11, hr_api.g_varchar2) or
496: nvl(hr_itp_shd.g_old_rec.information12, hr_api.g_varchar2) <>

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

489: nvl(p_rec.information8, hr_api.g_varchar2) or
490: nvl(hr_itp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
491: nvl(p_rec.information9, hr_api.g_varchar2) or
492: nvl(hr_itp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
493: nvl(p_rec.information10, hr_api.g_varchar2) or
494: nvl(hr_itp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
495: nvl(p_rec.information11, hr_api.g_varchar2) or
496: nvl(hr_itp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
497: nvl(p_rec.information12, hr_api.g_varchar2) or

Line 494: nvl(hr_itp_shd.g_old_rec.information11, hr_api.g_varchar2) <>

490: nvl(hr_itp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
491: nvl(p_rec.information9, hr_api.g_varchar2) or
492: nvl(hr_itp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
493: nvl(p_rec.information10, hr_api.g_varchar2) or
494: nvl(hr_itp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
495: nvl(p_rec.information11, hr_api.g_varchar2) or
496: nvl(hr_itp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
497: nvl(p_rec.information12, hr_api.g_varchar2) or
498: nvl(hr_itp_shd.g_old_rec.information13, hr_api.g_varchar2) <>

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

491: nvl(p_rec.information9, hr_api.g_varchar2) or
492: nvl(hr_itp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
493: nvl(p_rec.information10, hr_api.g_varchar2) or
494: nvl(hr_itp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
495: nvl(p_rec.information11, hr_api.g_varchar2) or
496: nvl(hr_itp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
497: nvl(p_rec.information12, hr_api.g_varchar2) or
498: nvl(hr_itp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
499: nvl(p_rec.information13, hr_api.g_varchar2) or

Line 496: nvl(hr_itp_shd.g_old_rec.information12, hr_api.g_varchar2) <>

492: nvl(hr_itp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
493: nvl(p_rec.information10, hr_api.g_varchar2) or
494: nvl(hr_itp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
495: nvl(p_rec.information11, hr_api.g_varchar2) or
496: nvl(hr_itp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
497: nvl(p_rec.information12, hr_api.g_varchar2) or
498: nvl(hr_itp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
499: nvl(p_rec.information13, hr_api.g_varchar2) or
500: nvl(hr_itp_shd.g_old_rec.information14, hr_api.g_varchar2) <>

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

493: nvl(p_rec.information10, hr_api.g_varchar2) or
494: nvl(hr_itp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
495: nvl(p_rec.information11, hr_api.g_varchar2) or
496: nvl(hr_itp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
497: nvl(p_rec.information12, hr_api.g_varchar2) or
498: nvl(hr_itp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
499: nvl(p_rec.information13, hr_api.g_varchar2) or
500: nvl(hr_itp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
501: nvl(p_rec.information14, hr_api.g_varchar2) or

Line 498: nvl(hr_itp_shd.g_old_rec.information13, hr_api.g_varchar2) <>

494: nvl(hr_itp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
495: nvl(p_rec.information11, hr_api.g_varchar2) or
496: nvl(hr_itp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
497: nvl(p_rec.information12, hr_api.g_varchar2) or
498: nvl(hr_itp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
499: nvl(p_rec.information13, hr_api.g_varchar2) or
500: nvl(hr_itp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
501: nvl(p_rec.information14, hr_api.g_varchar2) or
502: nvl(hr_itp_shd.g_old_rec.information15, hr_api.g_varchar2) <>

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

495: nvl(p_rec.information11, hr_api.g_varchar2) or
496: nvl(hr_itp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
497: nvl(p_rec.information12, hr_api.g_varchar2) or
498: nvl(hr_itp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
499: nvl(p_rec.information13, hr_api.g_varchar2) or
500: nvl(hr_itp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
501: nvl(p_rec.information14, hr_api.g_varchar2) or
502: nvl(hr_itp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
503: nvl(p_rec.information15, hr_api.g_varchar2) or

Line 500: nvl(hr_itp_shd.g_old_rec.information14, hr_api.g_varchar2) <>

496: nvl(hr_itp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
497: nvl(p_rec.information12, hr_api.g_varchar2) or
498: nvl(hr_itp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
499: nvl(p_rec.information13, hr_api.g_varchar2) or
500: nvl(hr_itp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
501: nvl(p_rec.information14, hr_api.g_varchar2) or
502: nvl(hr_itp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
503: nvl(p_rec.information15, hr_api.g_varchar2) or
504: nvl(hr_itp_shd.g_old_rec.information16, hr_api.g_varchar2) <>

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

497: nvl(p_rec.information12, hr_api.g_varchar2) or
498: nvl(hr_itp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
499: nvl(p_rec.information13, hr_api.g_varchar2) or
500: nvl(hr_itp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
501: nvl(p_rec.information14, hr_api.g_varchar2) or
502: nvl(hr_itp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
503: nvl(p_rec.information15, hr_api.g_varchar2) or
504: nvl(hr_itp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
505: nvl(p_rec.information16, hr_api.g_varchar2) or

Line 502: nvl(hr_itp_shd.g_old_rec.information15, hr_api.g_varchar2) <>

498: nvl(hr_itp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
499: nvl(p_rec.information13, hr_api.g_varchar2) or
500: nvl(hr_itp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
501: nvl(p_rec.information14, hr_api.g_varchar2) or
502: nvl(hr_itp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
503: nvl(p_rec.information15, hr_api.g_varchar2) or
504: nvl(hr_itp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
505: nvl(p_rec.information16, hr_api.g_varchar2) or
506: nvl(hr_itp_shd.g_old_rec.information17, hr_api.g_varchar2) <>

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

499: nvl(p_rec.information13, hr_api.g_varchar2) or
500: nvl(hr_itp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
501: nvl(p_rec.information14, hr_api.g_varchar2) or
502: nvl(hr_itp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
503: nvl(p_rec.information15, hr_api.g_varchar2) or
504: nvl(hr_itp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
505: nvl(p_rec.information16, hr_api.g_varchar2) or
506: nvl(hr_itp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
507: nvl(p_rec.information17, hr_api.g_varchar2) or

Line 504: nvl(hr_itp_shd.g_old_rec.information16, hr_api.g_varchar2) <>

500: nvl(hr_itp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
501: nvl(p_rec.information14, hr_api.g_varchar2) or
502: nvl(hr_itp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
503: nvl(p_rec.information15, hr_api.g_varchar2) or
504: nvl(hr_itp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
505: nvl(p_rec.information16, hr_api.g_varchar2) or
506: nvl(hr_itp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
507: nvl(p_rec.information17, hr_api.g_varchar2) or
508: nvl(hr_itp_shd.g_old_rec.information18, hr_api.g_varchar2) <>

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

501: nvl(p_rec.information14, hr_api.g_varchar2) or
502: nvl(hr_itp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
503: nvl(p_rec.information15, hr_api.g_varchar2) or
504: nvl(hr_itp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
505: nvl(p_rec.information16, hr_api.g_varchar2) or
506: nvl(hr_itp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
507: nvl(p_rec.information17, hr_api.g_varchar2) or
508: nvl(hr_itp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
509: nvl(p_rec.information18, hr_api.g_varchar2) or

Line 506: nvl(hr_itp_shd.g_old_rec.information17, hr_api.g_varchar2) <>

502: nvl(hr_itp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
503: nvl(p_rec.information15, hr_api.g_varchar2) or
504: nvl(hr_itp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
505: nvl(p_rec.information16, hr_api.g_varchar2) or
506: nvl(hr_itp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
507: nvl(p_rec.information17, hr_api.g_varchar2) or
508: nvl(hr_itp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
509: nvl(p_rec.information18, hr_api.g_varchar2) or
510: nvl(hr_itp_shd.g_old_rec.information19, hr_api.g_varchar2) <>

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

503: nvl(p_rec.information15, hr_api.g_varchar2) or
504: nvl(hr_itp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
505: nvl(p_rec.information16, hr_api.g_varchar2) or
506: nvl(hr_itp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
507: nvl(p_rec.information17, hr_api.g_varchar2) or
508: nvl(hr_itp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
509: nvl(p_rec.information18, hr_api.g_varchar2) or
510: nvl(hr_itp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
511: nvl(p_rec.information19, hr_api.g_varchar2) or

Line 508: nvl(hr_itp_shd.g_old_rec.information18, hr_api.g_varchar2) <>

504: nvl(hr_itp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
505: nvl(p_rec.information16, hr_api.g_varchar2) or
506: nvl(hr_itp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
507: nvl(p_rec.information17, hr_api.g_varchar2) or
508: nvl(hr_itp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
509: nvl(p_rec.information18, hr_api.g_varchar2) or
510: nvl(hr_itp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
511: nvl(p_rec.information19, hr_api.g_varchar2) or
512: nvl(hr_itp_shd.g_old_rec.information20, hr_api.g_varchar2) <>

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

505: nvl(p_rec.information16, hr_api.g_varchar2) or
506: nvl(hr_itp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
507: nvl(p_rec.information17, hr_api.g_varchar2) or
508: nvl(hr_itp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
509: nvl(p_rec.information18, hr_api.g_varchar2) or
510: nvl(hr_itp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
511: nvl(p_rec.information19, hr_api.g_varchar2) or
512: nvl(hr_itp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
513: nvl(p_rec.information20, hr_api.g_varchar2) or

Line 510: nvl(hr_itp_shd.g_old_rec.information19, hr_api.g_varchar2) <>

506: nvl(hr_itp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
507: nvl(p_rec.information17, hr_api.g_varchar2) or
508: nvl(hr_itp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
509: nvl(p_rec.information18, hr_api.g_varchar2) or
510: nvl(hr_itp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
511: nvl(p_rec.information19, hr_api.g_varchar2) or
512: nvl(hr_itp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
513: nvl(p_rec.information20, hr_api.g_varchar2) or
514: nvl(hr_itp_shd.g_old_rec.information21, hr_api.g_varchar2) <>

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

507: nvl(p_rec.information17, hr_api.g_varchar2) or
508: nvl(hr_itp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
509: nvl(p_rec.information18, hr_api.g_varchar2) or
510: nvl(hr_itp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
511: nvl(p_rec.information19, hr_api.g_varchar2) or
512: nvl(hr_itp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
513: nvl(p_rec.information20, hr_api.g_varchar2) or
514: nvl(hr_itp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
515: nvl(p_rec.information21, hr_api.g_varchar2) or

Line 512: nvl(hr_itp_shd.g_old_rec.information20, hr_api.g_varchar2) <>

508: nvl(hr_itp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
509: nvl(p_rec.information18, hr_api.g_varchar2) or
510: nvl(hr_itp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
511: nvl(p_rec.information19, hr_api.g_varchar2) or
512: nvl(hr_itp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
513: nvl(p_rec.information20, hr_api.g_varchar2) or
514: nvl(hr_itp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
515: nvl(p_rec.information21, hr_api.g_varchar2) or
516: nvl(hr_itp_shd.g_old_rec.information22, hr_api.g_varchar2) <>

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

509: nvl(p_rec.information18, hr_api.g_varchar2) or
510: nvl(hr_itp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
511: nvl(p_rec.information19, hr_api.g_varchar2) or
512: nvl(hr_itp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
513: nvl(p_rec.information20, hr_api.g_varchar2) or
514: nvl(hr_itp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
515: nvl(p_rec.information21, hr_api.g_varchar2) or
516: nvl(hr_itp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
517: nvl(p_rec.information22, hr_api.g_varchar2) or

Line 514: nvl(hr_itp_shd.g_old_rec.information21, hr_api.g_varchar2) <>

510: nvl(hr_itp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
511: nvl(p_rec.information19, hr_api.g_varchar2) or
512: nvl(hr_itp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
513: nvl(p_rec.information20, hr_api.g_varchar2) or
514: nvl(hr_itp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
515: nvl(p_rec.information21, hr_api.g_varchar2) or
516: nvl(hr_itp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
517: nvl(p_rec.information22, hr_api.g_varchar2) or
518: nvl(hr_itp_shd.g_old_rec.information23, hr_api.g_varchar2) <>

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

511: nvl(p_rec.information19, hr_api.g_varchar2) or
512: nvl(hr_itp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
513: nvl(p_rec.information20, hr_api.g_varchar2) or
514: nvl(hr_itp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
515: nvl(p_rec.information21, hr_api.g_varchar2) or
516: nvl(hr_itp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
517: nvl(p_rec.information22, hr_api.g_varchar2) or
518: nvl(hr_itp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
519: nvl(p_rec.information23, hr_api.g_varchar2) or

Line 516: nvl(hr_itp_shd.g_old_rec.information22, hr_api.g_varchar2) <>

512: nvl(hr_itp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
513: nvl(p_rec.information20, hr_api.g_varchar2) or
514: nvl(hr_itp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
515: nvl(p_rec.information21, hr_api.g_varchar2) or
516: nvl(hr_itp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
517: nvl(p_rec.information22, hr_api.g_varchar2) or
518: nvl(hr_itp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
519: nvl(p_rec.information23, hr_api.g_varchar2) or
520: nvl(hr_itp_shd.g_old_rec.information24, hr_api.g_varchar2) <>

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

513: nvl(p_rec.information20, hr_api.g_varchar2) or
514: nvl(hr_itp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
515: nvl(p_rec.information21, hr_api.g_varchar2) or
516: nvl(hr_itp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
517: nvl(p_rec.information22, hr_api.g_varchar2) or
518: nvl(hr_itp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
519: nvl(p_rec.information23, hr_api.g_varchar2) or
520: nvl(hr_itp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
521: nvl(p_rec.information24, hr_api.g_varchar2) or

Line 518: nvl(hr_itp_shd.g_old_rec.information23, hr_api.g_varchar2) <>

514: nvl(hr_itp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
515: nvl(p_rec.information21, hr_api.g_varchar2) or
516: nvl(hr_itp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
517: nvl(p_rec.information22, hr_api.g_varchar2) or
518: nvl(hr_itp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
519: nvl(p_rec.information23, hr_api.g_varchar2) or
520: nvl(hr_itp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
521: nvl(p_rec.information24, hr_api.g_varchar2) or
522: nvl(hr_itp_shd.g_old_rec.information25, hr_api.g_varchar2) <>

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

515: nvl(p_rec.information21, hr_api.g_varchar2) or
516: nvl(hr_itp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
517: nvl(p_rec.information22, hr_api.g_varchar2) or
518: nvl(hr_itp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
519: nvl(p_rec.information23, hr_api.g_varchar2) or
520: nvl(hr_itp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
521: nvl(p_rec.information24, hr_api.g_varchar2) or
522: nvl(hr_itp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
523: nvl(p_rec.information25, hr_api.g_varchar2) or

Line 520: nvl(hr_itp_shd.g_old_rec.information24, hr_api.g_varchar2) <>

516: nvl(hr_itp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
517: nvl(p_rec.information22, hr_api.g_varchar2) or
518: nvl(hr_itp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
519: nvl(p_rec.information23, hr_api.g_varchar2) or
520: nvl(hr_itp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
521: nvl(p_rec.information24, hr_api.g_varchar2) or
522: nvl(hr_itp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
523: nvl(p_rec.information25, hr_api.g_varchar2) or
524: nvl(hr_itp_shd.g_old_rec.information26, hr_api.g_varchar2) <>

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

517: nvl(p_rec.information22, hr_api.g_varchar2) or
518: nvl(hr_itp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
519: nvl(p_rec.information23, hr_api.g_varchar2) or
520: nvl(hr_itp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
521: nvl(p_rec.information24, hr_api.g_varchar2) or
522: nvl(hr_itp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
523: nvl(p_rec.information25, hr_api.g_varchar2) or
524: nvl(hr_itp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
525: nvl(p_rec.information26, hr_api.g_varchar2) or

Line 522: nvl(hr_itp_shd.g_old_rec.information25, hr_api.g_varchar2) <>

518: nvl(hr_itp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
519: nvl(p_rec.information23, hr_api.g_varchar2) or
520: nvl(hr_itp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
521: nvl(p_rec.information24, hr_api.g_varchar2) or
522: nvl(hr_itp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
523: nvl(p_rec.information25, hr_api.g_varchar2) or
524: nvl(hr_itp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
525: nvl(p_rec.information26, hr_api.g_varchar2) or
526: nvl(hr_itp_shd.g_old_rec.information27, hr_api.g_varchar2) <>

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

519: nvl(p_rec.information23, hr_api.g_varchar2) or
520: nvl(hr_itp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
521: nvl(p_rec.information24, hr_api.g_varchar2) or
522: nvl(hr_itp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
523: nvl(p_rec.information25, hr_api.g_varchar2) or
524: nvl(hr_itp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
525: nvl(p_rec.information26, hr_api.g_varchar2) or
526: nvl(hr_itp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
527: nvl(p_rec.information27, hr_api.g_varchar2) or

Line 524: nvl(hr_itp_shd.g_old_rec.information26, hr_api.g_varchar2) <>

520: nvl(hr_itp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
521: nvl(p_rec.information24, hr_api.g_varchar2) or
522: nvl(hr_itp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
523: nvl(p_rec.information25, hr_api.g_varchar2) or
524: nvl(hr_itp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
525: nvl(p_rec.information26, hr_api.g_varchar2) or
526: nvl(hr_itp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
527: nvl(p_rec.information27, hr_api.g_varchar2) or
528: nvl(hr_itp_shd.g_old_rec.information28, hr_api.g_varchar2) <>

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

521: nvl(p_rec.information24, hr_api.g_varchar2) or
522: nvl(hr_itp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
523: nvl(p_rec.information25, hr_api.g_varchar2) or
524: nvl(hr_itp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
525: nvl(p_rec.information26, hr_api.g_varchar2) or
526: nvl(hr_itp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
527: nvl(p_rec.information27, hr_api.g_varchar2) or
528: nvl(hr_itp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
529: nvl(p_rec.information28, hr_api.g_varchar2) or

Line 526: nvl(hr_itp_shd.g_old_rec.information27, hr_api.g_varchar2) <>

522: nvl(hr_itp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
523: nvl(p_rec.information25, hr_api.g_varchar2) or
524: nvl(hr_itp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
525: nvl(p_rec.information26, hr_api.g_varchar2) or
526: nvl(hr_itp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
527: nvl(p_rec.information27, hr_api.g_varchar2) or
528: nvl(hr_itp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
529: nvl(p_rec.information28, hr_api.g_varchar2) or
530: nvl(hr_itp_shd.g_old_rec.information29, hr_api.g_varchar2) <>

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

523: nvl(p_rec.information25, hr_api.g_varchar2) or
524: nvl(hr_itp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
525: nvl(p_rec.information26, hr_api.g_varchar2) or
526: nvl(hr_itp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
527: nvl(p_rec.information27, hr_api.g_varchar2) or
528: nvl(hr_itp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
529: nvl(p_rec.information28, hr_api.g_varchar2) or
530: nvl(hr_itp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
531: nvl(p_rec.information29, hr_api.g_varchar2) or

Line 528: nvl(hr_itp_shd.g_old_rec.information28, hr_api.g_varchar2) <>

524: nvl(hr_itp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
525: nvl(p_rec.information26, hr_api.g_varchar2) or
526: nvl(hr_itp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
527: nvl(p_rec.information27, hr_api.g_varchar2) or
528: nvl(hr_itp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
529: nvl(p_rec.information28, hr_api.g_varchar2) or
530: nvl(hr_itp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
531: nvl(p_rec.information29, hr_api.g_varchar2) or
532: nvl(hr_itp_shd.g_old_rec.information30, hr_api.g_varchar2) <>

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

525: nvl(p_rec.information26, hr_api.g_varchar2) or
526: nvl(hr_itp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
527: nvl(p_rec.information27, hr_api.g_varchar2) or
528: nvl(hr_itp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
529: nvl(p_rec.information28, hr_api.g_varchar2) or
530: nvl(hr_itp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
531: nvl(p_rec.information29, hr_api.g_varchar2) or
532: nvl(hr_itp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
533: nvl(p_rec.information30, hr_api.g_varchar2) )

Line 530: nvl(hr_itp_shd.g_old_rec.information29, hr_api.g_varchar2) <>

526: nvl(hr_itp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
527: nvl(p_rec.information27, hr_api.g_varchar2) or
528: nvl(hr_itp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
529: nvl(p_rec.information28, hr_api.g_varchar2) or
530: nvl(hr_itp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
531: nvl(p_rec.information29, hr_api.g_varchar2) or
532: nvl(hr_itp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
533: nvl(p_rec.information30, hr_api.g_varchar2) )
534: or (p_rec.item_property_id is null) ) then

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

527: nvl(p_rec.information27, hr_api.g_varchar2) or
528: nvl(hr_itp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
529: nvl(p_rec.information28, hr_api.g_varchar2) or
530: nvl(hr_itp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
531: nvl(p_rec.information29, hr_api.g_varchar2) or
532: nvl(hr_itp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
533: nvl(p_rec.information30, hr_api.g_varchar2) )
534: or (p_rec.item_property_id is null) ) then
535: --

Line 532: nvl(hr_itp_shd.g_old_rec.information30, hr_api.g_varchar2) <>

528: nvl(hr_itp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
529: nvl(p_rec.information28, hr_api.g_varchar2) or
530: nvl(hr_itp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
531: nvl(p_rec.information29, hr_api.g_varchar2) or
532: nvl(hr_itp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
533: nvl(p_rec.information30, hr_api.g_varchar2) )
534: or (p_rec.item_property_id is null) ) then
535: --
536: -- Only execute the validation if absolutely necessary:

Line 533: nvl(p_rec.information30, hr_api.g_varchar2) )

529: nvl(p_rec.information28, hr_api.g_varchar2) or
530: nvl(hr_itp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
531: nvl(p_rec.information29, hr_api.g_varchar2) or
532: nvl(hr_itp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
533: nvl(p_rec.information30, hr_api.g_varchar2) )
534: or (p_rec.item_property_id is null) ) then
535: --
536: -- Only execute the validation if absolutely necessary:
537: -- a) During update, the structure column value or any

Line 662: IF (nvl(p_rec.form_item_id,hr_api.g_number) <>

658: fnd_message.set_token('STEP ', '5');
659: fnd_message.raise_error;
660: END IF;
661: --
662: IF (nvl(p_rec.form_item_id,hr_api.g_number) <>
663: nvl(hr_itp_shd.g_old_rec.form_item_id,hr_api.g_number)
664: ) THEN
665: l_argument := 'form_item_id';
666: RAISE l_error;

Line 663: nvl(hr_itp_shd.g_old_rec.form_item_id,hr_api.g_number)

659: fnd_message.raise_error;
660: END IF;
661: --
662: IF (nvl(p_rec.form_item_id,hr_api.g_number) <>
663: nvl(hr_itp_shd.g_old_rec.form_item_id,hr_api.g_number)
664: ) THEN
665: l_argument := 'form_item_id';
666: RAISE l_error;
667: END IF;

Line 669: IF (nvl(p_rec.template_item_id,hr_api.g_number) <>

665: l_argument := 'form_item_id';
666: RAISE l_error;
667: END IF;
668: --
669: IF (nvl(p_rec.template_item_id,hr_api.g_number) <>
670: nvl(hr_itp_shd.g_old_rec.template_item_id,hr_api.g_number)
671: ) THEN
672: l_argument := 'template_item_id';
673: RAISE l_error;

Line 670: nvl(hr_itp_shd.g_old_rec.template_item_id,hr_api.g_number)

666: RAISE l_error;
667: END IF;
668: --
669: IF (nvl(p_rec.template_item_id,hr_api.g_number) <>
670: nvl(hr_itp_shd.g_old_rec.template_item_id,hr_api.g_number)
671: ) THEN
672: l_argument := 'template_item_id';
673: RAISE l_error;
674: END IF;

Line 676: IF (nvl(p_rec.template_item_context_id,hr_api.g_number) <>

672: l_argument := 'template_item_id';
673: RAISE l_error;
674: END IF;
675: --
676: IF (nvl(p_rec.template_item_context_id,hr_api.g_number) <>
677: nvl(hr_itp_shd.g_old_rec.template_item_context_id,hr_api.g_number)
678: ) THEN
679: l_argument := 'template_item_context_id';
680: RAISE l_error;

Line 677: nvl(hr_itp_shd.g_old_rec.template_item_context_id,hr_api.g_number)

673: RAISE l_error;
674: END IF;
675: --
676: IF (nvl(p_rec.template_item_context_id,hr_api.g_number) <>
677: nvl(hr_itp_shd.g_old_rec.template_item_context_id,hr_api.g_number)
678: ) THEN
679: l_argument := 'template_item_context_id';
680: RAISE l_error;
681: END IF;

Line 685: hr_api.argument_changed_error

681: END IF;
682: --
683: EXCEPTION
684: WHEN l_error THEN
685: hr_api.argument_changed_error
686: (p_api_name => l_proc
687: ,p_argument => l_argument);
688: WHEN OTHERS THEN
689: RAISE;

Line 814: hr_api.mandatory_arg_error

810: hr_utility.set_location('Entering:'||l_proc, 10);
811: --
812: -- Check mandatory arguments have been set
813: --
814: hr_api.mandatory_arg_error
815: (p_api_name => l_proc
816: ,p_argument => 'effective_date'
817: ,p_argument_value => p_effective_date
818: );

Line 829: and nvl(hr_itp_shd.g_old_rec.alignment,hr_api.g_number) <>

825: --
826: -- Only proceed with SQL validation if absolutely necessary
827: --
828: if ( ( l_api_updating
829: and nvl(hr_itp_shd.g_old_rec.alignment,hr_api.g_number) <>
830: nvl(p_alignment,hr_api.g_number))
831: or (NOT l_api_updating)) then
832: --
833: hr_utility.set_location(l_proc,30);

Line 830: nvl(p_alignment,hr_api.g_number))

826: -- Only proceed with SQL validation if absolutely necessary
827: --
828: if ( ( l_api_updating
829: and nvl(hr_itp_shd.g_old_rec.alignment,hr_api.g_number) <>
830: nvl(p_alignment,hr_api.g_number))
831: or (NOT l_api_updating)) then
832: --
833: hr_utility.set_location(l_proc,30);
834: --

Line 842: if hr_api.not_exists_in_hrstanlookups

838: --
839: -- Must exist in hr_standard_lookups where lookup_type is
840: -- ALIGNMENTS
841: --
842: if hr_api.not_exists_in_hrstanlookups
843: (p_effective_date => p_effective_date
844: ,p_lookup_type => 'ALIGNMENTS'
845: ,p_lookup_code => p_alignment
846: ) then

Line 878: hr_api.mandatory_arg_error

874: hr_utility.set_location('Entering:'||l_proc, 10);
875: --
876: -- Check mandatory arguments have been set
877: --
878: hr_api.mandatory_arg_error
879: (p_api_name => l_proc
880: ,p_argument => 'effective_date'
881: ,p_argument_value => p_effective_date
882: );

Line 893: and nvl(hr_itp_shd.g_old_rec.bevel,hr_api.g_number) <>

889: --
890: -- Only proceed with SQL validation if absolutely necessary
891: --
892: if ( ( l_api_updating
893: and nvl(hr_itp_shd.g_old_rec.bevel,hr_api.g_number) <>
894: nvl(p_bevel,hr_api.g_number))
895: or (NOT l_api_updating)) then
896: --
897: hr_utility.set_location(l_proc,30);

Line 894: nvl(p_bevel,hr_api.g_number))

890: -- Only proceed with SQL validation if absolutely necessary
891: --
892: if ( ( l_api_updating
893: and nvl(hr_itp_shd.g_old_rec.bevel,hr_api.g_number) <>
894: nvl(p_bevel,hr_api.g_number))
895: or (NOT l_api_updating)) then
896: --
897: hr_utility.set_location(l_proc,30);
898: --

Line 906: if hr_api.not_exists_in_hrstanlookups

902: --
903: -- Must exist in hr_standard_lookups where lookup_type is
904: -- BORDER_BEVELS
905: --
906: if hr_api.not_exists_in_hrstanlookups
907: (p_effective_date => p_effective_date
908: ,p_lookup_type => 'BORDER_BEVELS'
909: ,p_lookup_code => p_bevel
910: ) then

Line 942: hr_api.mandatory_arg_error

938: hr_utility.set_location('Entering:'||l_proc, 10);
939: --
940: -- Check mandatory arguments have been set
941: --
942: hr_api.mandatory_arg_error
943: (p_api_name => l_proc
944: ,p_argument => 'effective_date'
945: ,p_argument_value => p_effective_date
946: );

Line 957: and nvl(hr_itp_shd.g_old_rec.case_restriction,hr_api.g_number) <>

953: --
954: -- Only proceed with SQL validation if absolutely necessary
955: --
956: if ( ( l_api_updating
957: and nvl(hr_itp_shd.g_old_rec.case_restriction,hr_api.g_number) <>
958: nvl(p_case_restriction,hr_api.g_number))
959: or (NOT l_api_updating)) then
960: --
961: hr_utility.set_location(l_proc,30);

Line 958: nvl(p_case_restriction,hr_api.g_number))

954: -- Only proceed with SQL validation if absolutely necessary
955: --
956: if ( ( l_api_updating
957: and nvl(hr_itp_shd.g_old_rec.case_restriction,hr_api.g_number) <>
958: nvl(p_case_restriction,hr_api.g_number))
959: or (NOT l_api_updating)) then
960: --
961: hr_utility.set_location(l_proc,30);
962: --

Line 970: if hr_api.not_exists_in_hrstanlookups

966: --
967: -- Must exist in hr_standard_lookups where lookup_type is
968: -- CASE_RESTRICTIONS
969: --
970: if hr_api.not_exists_in_hrstanlookups
971: (p_effective_date => p_effective_date
972: ,p_lookup_type => 'CASE_RESTRICTIONS'
973: ,p_lookup_code => p_case_restriction
974: ) then

Line 1006: hr_api.mandatory_arg_error

1002: hr_utility.set_location('Entering:'||l_proc, 10);
1003: --
1004: -- Check mandatory arguments have been set
1005: --
1006: hr_api.mandatory_arg_error
1007: (p_api_name => l_proc
1008: ,p_argument => 'effective_date'
1009: ,p_argument_value => p_effective_date
1010: );

Line 1021: and nvl(hr_itp_shd.g_old_rec.enabled,hr_api.g_number) <>

1017: --
1018: -- Only proceed with SQL validation if absolutely necessary
1019: --
1020: if ( ( l_api_updating
1021: and nvl(hr_itp_shd.g_old_rec.enabled,hr_api.g_number) <>
1022: nvl(p_enabled,hr_api.g_number))
1023: or (NOT l_api_updating)) then
1024: --
1025: hr_utility.set_location(l_proc,30);

Line 1022: nvl(p_enabled,hr_api.g_number))

1018: -- Only proceed with SQL validation if absolutely necessary
1019: --
1020: if ( ( l_api_updating
1021: and nvl(hr_itp_shd.g_old_rec.enabled,hr_api.g_number) <>
1022: nvl(p_enabled,hr_api.g_number))
1023: or (NOT l_api_updating)) then
1024: --
1025: hr_utility.set_location(l_proc,30);
1026: --

Line 1034: if hr_api.not_exists_in_hrstanlookups

1030: --
1031: -- Must exist in hr_standard_lookups where lookup_type is
1032: -- PROPERTY_TRUE_OR_FALSE
1033: --
1034: if hr_api.not_exists_in_hrstanlookups
1035: (p_effective_date => p_effective_date
1036: ,p_lookup_type => 'PROPERTY_TRUE_OR_FALSE'
1037: ,p_lookup_code => p_enabled
1038: ) then

Line 1140: and nvl(hr_itp_shd.g_old_rec.information_formula_id,hr_api.g_number) <>

1136: --
1137: -- Only proceed with SQL validation if absolutely necessary
1138: --
1139: if ( ( l_api_updating
1140: and nvl(hr_itp_shd.g_old_rec.information_formula_id,hr_api.g_number) <>
1141: nvl(p_information_formula_id,hr_api.g_number))
1142: or (NOT l_api_updating)) then
1143: --
1144: if p_information_formula_id is not null then

Line 1141: nvl(p_information_formula_id,hr_api.g_number))

1137: -- Only proceed with SQL validation if absolutely necessary
1138: --
1139: if ( ( l_api_updating
1140: and nvl(hr_itp_shd.g_old_rec.information_formula_id,hr_api.g_number) <>
1141: nvl(p_information_formula_id,hr_api.g_number))
1142: or (NOT l_api_updating)) then
1143: --
1144: if p_information_formula_id is not null then
1145: --

Line 1161: if nvl(l_formula_type_name,hr_api.g_varchar2) <> 'Template Information' then

1157: close csr_formula;
1158: --
1159: -- Check formula is of type 'Template Information' if specified
1160: --
1161: if nvl(l_formula_type_name,hr_api.g_varchar2) <> 'Template Information' then
1162: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1163: fnd_message.set_token('PROCEDURE', l_proc);
1164: fnd_message.set_token('STEP','20');
1165: fnd_message.raise_error;

Line 1231: hr_api.mandatory_arg_error

1227: hr_utility.set_location('Entering:'||l_proc, 10);
1228: --
1229: -- Check mandatory arguments have been set
1230: --
1231: hr_api.mandatory_arg_error
1232: (p_api_name => l_proc
1233: ,p_argument => 'effective_date'
1234: ,p_argument_value => p_effective_date
1235: );

Line 1246: and nvl(hr_itp_shd.g_old_rec.insert_allowed,hr_api.g_number) <>

1242: --
1243: -- Only proceed with SQL validation if absolutely necessary
1244: --
1245: if ( ( l_api_updating
1246: and nvl(hr_itp_shd.g_old_rec.insert_allowed,hr_api.g_number) <>
1247: nvl(p_insert_allowed,hr_api.g_number))
1248: or (NOT l_api_updating)) then
1249: --
1250: hr_utility.set_location(l_proc,30);

Line 1247: nvl(p_insert_allowed,hr_api.g_number))

1243: -- Only proceed with SQL validation if absolutely necessary
1244: --
1245: if ( ( l_api_updating
1246: and nvl(hr_itp_shd.g_old_rec.insert_allowed,hr_api.g_number) <>
1247: nvl(p_insert_allowed,hr_api.g_number))
1248: or (NOT l_api_updating)) then
1249: --
1250: hr_utility.set_location(l_proc,30);
1251: --

Line 1259: if hr_api.not_exists_in_hrstanlookups

1255: --
1256: -- Must exist in hr_standard_lookups where lookup_type is
1257: -- PROPERTY_TRUE_OR_FALSE
1258: --
1259: if hr_api.not_exists_in_hrstanlookups
1260: (p_effective_date => p_effective_date
1261: ,p_lookup_type => 'PROPERTY_TRUE_OR_FALSE'
1262: ,p_lookup_code => p_insert_allowed
1263: ) then

Line 1313: hr_api.mandatory_arg_error

1309: hr_utility.set_location('Entering:'||l_proc, 10);
1310: --
1311: -- Check mandatory arguments have been set
1312: --
1313: hr_api.mandatory_arg_error
1314: (p_api_name => l_proc
1315: ,p_argument => 'effective_date'
1316: ,p_argument_value => p_effective_date
1317: );

Line 1328: and nvl(hr_itp_shd.g_old_rec.prompt_display_style,hr_api.g_number) <>

1324: --
1325: -- Only proceed with SQL validation if absolutely necessary
1326: --
1327: if ( ( l_api_updating
1328: and nvl(hr_itp_shd.g_old_rec.prompt_display_style,hr_api.g_number) <>
1329: nvl(p_prompt_display_style,hr_api.g_number))
1330: or (NOT l_api_updating)) then
1331: --
1332: hr_utility.set_location(l_proc,30);

Line 1329: nvl(p_prompt_display_style,hr_api.g_number))

1325: -- Only proceed with SQL validation if absolutely necessary
1326: --
1327: if ( ( l_api_updating
1328: and nvl(hr_itp_shd.g_old_rec.prompt_display_style,hr_api.g_number) <>
1329: nvl(p_prompt_display_style,hr_api.g_number))
1330: or (NOT l_api_updating)) then
1331: --
1332: hr_utility.set_location(l_proc,30);
1333: --

Line 1341: if hr_api.not_exists_in_hrstanlookups

1337: --
1338: -- Must exist in hr_standard_lookups where lookup_type is
1339: -- PROMTP_DISPLAY_STYLES
1340: --
1341: if hr_api.not_exists_in_hrstanlookups
1342: (p_effective_date => p_effective_date
1343: ,p_lookup_type => 'PROMPT_DISPLAY_STYLES'
1344: ,p_lookup_code => p_prompt_display_style
1345: ) then

Line 1377: hr_api.mandatory_arg_error

1373: hr_utility.set_location('Entering:'||l_proc, 10);
1374: --
1375: -- Check mandatory arguments have been set
1376: --
1377: hr_api.mandatory_arg_error
1378: (p_api_name => l_proc
1379: ,p_argument => 'effective_date'
1380: ,p_argument_value => p_effective_date
1381: );

Line 1392: and nvl(hr_itp_shd.g_old_rec.prompt_edge,hr_api.g_number) <>

1388: --
1389: -- Only proceed with SQL validation if absolutely necessary
1390: --
1391: if ( ( l_api_updating
1392: and nvl(hr_itp_shd.g_old_rec.prompt_edge,hr_api.g_number) <>
1393: nvl(p_prompt_edge,hr_api.g_number))
1394: or (NOT l_api_updating)) then
1395: --
1396: hr_utility.set_location(l_proc,30);

Line 1393: nvl(p_prompt_edge,hr_api.g_number))

1389: -- Only proceed with SQL validation if absolutely necessary
1390: --
1391: if ( ( l_api_updating
1392: and nvl(hr_itp_shd.g_old_rec.prompt_edge,hr_api.g_number) <>
1393: nvl(p_prompt_edge,hr_api.g_number))
1394: or (NOT l_api_updating)) then
1395: --
1396: hr_utility.set_location(l_proc,30);
1397: --

Line 1405: if hr_api.not_exists_in_hrstanlookups

1401: --
1402: -- Must exist in hr_standard_lookups where lookup_type is
1403: -- PROMPT_EDGES
1404: --
1405: if hr_api.not_exists_in_hrstanlookups
1406: (p_effective_date => p_effective_date
1407: ,p_lookup_type => 'PROMPT_EDGES'
1408: ,p_lookup_code => p_prompt_edge
1409: ) then

Line 1441: hr_api.mandatory_arg_error

1437: hr_utility.set_location('Entering:'||l_proc, 10);
1438: --
1439: -- Check mandatory arguments have been set
1440: --
1441: hr_api.mandatory_arg_error
1442: (p_api_name => l_proc
1443: ,p_argument => 'effective_date'
1444: ,p_argument_value => p_effective_date
1445: );

Line 1456: and nvl(hr_itp_shd.g_old_rec.prompt_edge_alignment,hr_api.g_number) <>

1452: --
1453: -- Only proceed with SQL validation if absolutely necessary
1454: --
1455: if ( ( l_api_updating
1456: and nvl(hr_itp_shd.g_old_rec.prompt_edge_alignment,hr_api.g_number) <>
1457: nvl(p_prompt_edge_alignment,hr_api.g_number))
1458: or (NOT l_api_updating)) then
1459: --
1460: hr_utility.set_location(l_proc,30);

Line 1457: nvl(p_prompt_edge_alignment,hr_api.g_number))

1453: -- Only proceed with SQL validation if absolutely necessary
1454: --
1455: if ( ( l_api_updating
1456: and nvl(hr_itp_shd.g_old_rec.prompt_edge_alignment,hr_api.g_number) <>
1457: nvl(p_prompt_edge_alignment,hr_api.g_number))
1458: or (NOT l_api_updating)) then
1459: --
1460: hr_utility.set_location(l_proc,30);
1461: --

Line 1469: if hr_api.not_exists_in_hrstanlookups

1465: --
1466: -- Must exist in hr_standard_lookups where lookup_type is
1467: -- PROMPT_EDGE_ALIGNMENTS
1468: --
1469: if hr_api.not_exists_in_hrstanlookups
1470: (p_effective_date => p_effective_date
1471: ,p_lookup_type => 'PROMPT_EDGE_ALIGNMENTS'
1472: ,p_lookup_code => p_prompt_edge_alignment
1473: ) then

Line 1523: hr_api.mandatory_arg_error

1519: hr_utility.set_location('Entering:'||l_proc, 10);
1520: --
1521: -- Check mandatory arguments have been set
1522: --
1523: hr_api.mandatory_arg_error
1524: (p_api_name => l_proc
1525: ,p_argument => 'effective_date'
1526: ,p_argument_value => p_effective_date
1527: );

Line 1538: and nvl(hr_itp_shd.g_old_rec.prompt_text_alignment,hr_api.g_number) <>

1534: --
1535: -- Only proceed with SQL validation if absolutely necessary
1536: --
1537: if ( ( l_api_updating
1538: and nvl(hr_itp_shd.g_old_rec.prompt_text_alignment,hr_api.g_number) <>
1539: nvl(p_prompt_text_alignment,hr_api.g_number))
1540: or (NOT l_api_updating)) then
1541: --
1542: hr_utility.set_location(l_proc,30);

Line 1539: nvl(p_prompt_text_alignment,hr_api.g_number))

1535: -- Only proceed with SQL validation if absolutely necessary
1536: --
1537: if ( ( l_api_updating
1538: and nvl(hr_itp_shd.g_old_rec.prompt_text_alignment,hr_api.g_number) <>
1539: nvl(p_prompt_text_alignment,hr_api.g_number))
1540: or (NOT l_api_updating)) then
1541: --
1542: hr_utility.set_location(l_proc,30);
1543: --

Line 1551: if hr_api.not_exists_in_hrstanlookups

1547: --
1548: -- Must exist in hr_standard_lookups where lookup_type is
1549: -- PROMPT_TEXT_ALIGNMENTS
1550: --
1551: if hr_api.not_exists_in_hrstanlookups
1552: (p_effective_date => p_effective_date
1553: ,p_lookup_type => 'PROMPT_TEXT_ALIGNMENTS'
1554: ,p_lookup_code => p_prompt_text_alignment
1555: ) then

Line 1587: hr_api.mandatory_arg_error

1583: hr_utility.set_location('Entering:'||l_proc, 10);
1584: --
1585: -- Check mandatory arguments have been set
1586: --
1587: hr_api.mandatory_arg_error
1588: (p_api_name => l_proc
1589: ,p_argument => 'effective_date'
1590: ,p_argument_value => p_effective_date
1591: );

Line 1602: and nvl(hr_itp_shd.g_old_rec.query_allowed,hr_api.g_number) <>

1598: --
1599: -- Only proceed with SQL validation if absolutely necessary
1600: --
1601: if ( ( l_api_updating
1602: and nvl(hr_itp_shd.g_old_rec.query_allowed,hr_api.g_number) <>
1603: nvl(p_query_allowed,hr_api.g_number))
1604: or (NOT l_api_updating)) then
1605: --
1606: hr_utility.set_location(l_proc,30);

Line 1603: nvl(p_query_allowed,hr_api.g_number))

1599: -- Only proceed with SQL validation if absolutely necessary
1600: --
1601: if ( ( l_api_updating
1602: and nvl(hr_itp_shd.g_old_rec.query_allowed,hr_api.g_number) <>
1603: nvl(p_query_allowed,hr_api.g_number))
1604: or (NOT l_api_updating)) then
1605: --
1606: hr_utility.set_location(l_proc,30);
1607: --

Line 1615: if hr_api.not_exists_in_hrstanlookups

1611: --
1612: -- Must exist in hr_standard_lookups where lookup_type is
1613: -- PROPERTY_TRUE_OR_FALSE
1614: --
1615: if hr_api.not_exists_in_hrstanlookups
1616: (p_effective_date => p_effective_date
1617: ,p_lookup_type => 'PROPERTY_TRUE_OR_FALSE'
1618: ,p_lookup_code => p_query_allowed
1619: ) then

Line 1651: hr_api.mandatory_arg_error

1647: hr_utility.set_location('Entering:'||l_proc, 10);
1648: --
1649: -- Check mandatory arguments have been set
1650: --
1651: hr_api.mandatory_arg_error
1652: (p_api_name => l_proc
1653: ,p_argument => 'effective_date'
1654: ,p_argument_value => p_effective_date
1655: );

Line 1666: and nvl(hr_itp_shd.g_old_rec.required,hr_api.g_number) <>

1662: --
1663: -- Only proceed with SQL validation if absolutely necessary
1664: --
1665: if ( ( l_api_updating
1666: and nvl(hr_itp_shd.g_old_rec.required,hr_api.g_number) <>
1667: nvl(p_required,hr_api.g_number))
1668: or (NOT l_api_updating)) then
1669: --
1670: hr_utility.set_location(l_proc,30);

Line 1667: nvl(p_required,hr_api.g_number))

1663: -- Only proceed with SQL validation if absolutely necessary
1664: --
1665: if ( ( l_api_updating
1666: and nvl(hr_itp_shd.g_old_rec.required,hr_api.g_number) <>
1667: nvl(p_required,hr_api.g_number))
1668: or (NOT l_api_updating)) then
1669: --
1670: hr_utility.set_location(l_proc,30);
1671: --

Line 1679: if hr_api.not_exists_in_hrstanlookups

1675: --
1676: -- Must exist in hr_standard_lookups where lookup_type is
1677: -- PROPERTY_TRUE_OR_FALSE
1678: --
1679: if hr_api.not_exists_in_hrstanlookups
1680: (p_effective_date => p_effective_date
1681: ,p_lookup_type => 'PROPERTY_TRUE_OR_FALSE'
1682: ,p_lookup_code => p_required
1683: ) then

Line 1715: hr_api.mandatory_arg_error

1711: hr_utility.set_location('Entering:'||l_proc, 10);
1712: --
1713: -- Check mandatory arguments have been set
1714: --
1715: hr_api.mandatory_arg_error
1716: (p_api_name => l_proc
1717: ,p_argument => 'effective_date'
1718: ,p_argument_value => p_effective_date
1719: );

Line 1730: and nvl(hr_itp_shd.g_old_rec.update_allowed,hr_api.g_number) <>

1726: --
1727: -- Only proceed with SQL validation if absolutely necessary
1728: --
1729: if ( ( l_api_updating
1730: and nvl(hr_itp_shd.g_old_rec.update_allowed,hr_api.g_number) <>
1731: nvl(p_update_allowed,hr_api.g_number))
1732: or (NOT l_api_updating)) then
1733: --
1734: hr_utility.set_location(l_proc,30);

Line 1731: nvl(p_update_allowed,hr_api.g_number))

1727: -- Only proceed with SQL validation if absolutely necessary
1728: --
1729: if ( ( l_api_updating
1730: and nvl(hr_itp_shd.g_old_rec.update_allowed,hr_api.g_number) <>
1731: nvl(p_update_allowed,hr_api.g_number))
1732: or (NOT l_api_updating)) then
1733: --
1734: hr_utility.set_location(l_proc,30);
1735: --

Line 1743: if hr_api.not_exists_in_hrstanlookups

1739: --
1740: -- Must exist in hr_standard_lookups where lookup_type is
1741: -- PROPERTY_TRUE_OR_FALSE
1742: --
1743: if hr_api.not_exists_in_hrstanlookups
1744: (p_effective_date => p_effective_date
1745: ,p_lookup_type => 'PROPERTY_TRUE_OR_FALSE'
1746: ,p_lookup_code => p_update_allowed
1747: ) then

Line 1794: and nvl(hr_itp_shd.g_old_rec.validation_formula_id,hr_api.g_number) <>

1790: --
1791: -- Only proceed with SQL validation if absolutely necessary
1792: --
1793: if ( ( l_api_updating
1794: and nvl(hr_itp_shd.g_old_rec.validation_formula_id,hr_api.g_number) <>
1795: nvl(p_validation_formula_id,hr_api.g_number))
1796: or (NOT l_api_updating)) then
1797: --
1798: if p_validation_formula_id is not null then

Line 1795: nvl(p_validation_formula_id,hr_api.g_number))

1791: -- Only proceed with SQL validation if absolutely necessary
1792: --
1793: if ( ( l_api_updating
1794: and nvl(hr_itp_shd.g_old_rec.validation_formula_id,hr_api.g_number) <>
1795: nvl(p_validation_formula_id,hr_api.g_number))
1796: or (NOT l_api_updating)) then
1797: --
1798: if p_validation_formula_id is not null then
1799: --

Line 1815: if nvl(l_formula_type_name,hr_api.g_varchar2) <> 'Template Validation' then

1811: close csr_formula;
1812: --
1813: -- Check formula is of type 'Template Validation' if specified
1814: --
1815: if nvl(l_formula_type_name,hr_api.g_varchar2) <> 'Template Validation' then
1816: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1817: fnd_message.set_token('PROCEDURE', l_proc);
1818: fnd_message.set_token('STEP','20');
1819: fnd_message.raise_error;

Line 1885: hr_api.mandatory_arg_error

1881: hr_utility.set_location('Entering:'||l_proc, 10);
1882: --
1883: -- Check mandatory arguments have been set
1884: --
1885: hr_api.mandatory_arg_error
1886: (p_api_name => l_proc
1887: ,p_argument => 'effective_date'
1888: ,p_argument_value => p_effective_date
1889: );

Line 1900: and nvl(hr_itp_shd.g_old_rec.visible,hr_api.g_number) <>

1896: --
1897: -- Only proceed with SQL validation if absolutely necessary
1898: --
1899: if ( ( l_api_updating
1900: and nvl(hr_itp_shd.g_old_rec.visible,hr_api.g_number) <>
1901: nvl(p_visible,hr_api.g_number))
1902: or (NOT l_api_updating)) then
1903: --
1904: hr_utility.set_location(l_proc,30);

Line 1901: nvl(p_visible,hr_api.g_number))

1897: -- Only proceed with SQL validation if absolutely necessary
1898: --
1899: if ( ( l_api_updating
1900: and nvl(hr_itp_shd.g_old_rec.visible,hr_api.g_number) <>
1901: nvl(p_visible,hr_api.g_number))
1902: or (NOT l_api_updating)) then
1903: --
1904: hr_utility.set_location(l_proc,30);
1905: --

Line 1913: if hr_api.not_exists_in_hrstanlookups

1909: --
1910: -- Must exist in hr_standard_lookups where lookup_type is
1911: -- PROPERTY_TRUE_OR_FALSE
1912: --
1913: if hr_api.not_exists_in_hrstanlookups
1914: (p_effective_date => p_effective_date
1915: ,p_lookup_type => 'PROPERTY_TRUE_OR_FALSE'
1916: ,p_lookup_code => p_visible
1917: ) then