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_CNP_BUS dependencies on HR_API

Line 79: hr_api.mandatory_arg_error

75: hr_utility.set_location('Entering:'|| l_proc, 10);
76: --
77: -- Ensure that all the mandatory parameter are not null
78: --
79: hr_api.mandatory_arg_error
80: (p_api_name => l_proc
81: ,p_argument => 'canvas_property_id'
82: ,p_argument_value => p_canvas_property_id
83: );

Line 85: if ( nvl(hr_cnp_bus.g_canvas_property_id, hr_api.g_number)

81: ,p_argument => 'canvas_property_id'
82: ,p_argument_value => p_canvas_property_id
83: );
84: --
85: if ( nvl(hr_cnp_bus.g_canvas_property_id, hr_api.g_number)
86: = p_canvas_property_id) then
87: --
88: -- The legislation code has already been found with a previous
89: -- call to this function. Just return the value in the global

Line 147: (p_form_canvas_id in number default hr_api.g_number

143: -- Internal Row Handler Use Only.
144: --
145: -- ----------------------------------------------------------------------------
146: Function return_canvas_type
147: (p_form_canvas_id in number default hr_api.g_number
148: ,p_template_canvas_id in number default hr_api.g_number
149: )
150: Return Varchar2 Is
151: --

Line 148: ,p_template_canvas_id in number default hr_api.g_number

144: --
145: -- ----------------------------------------------------------------------------
146: Function return_canvas_type
147: (p_form_canvas_id in number default hr_api.g_number
148: ,p_template_canvas_id in number default hr_api.g_number
149: )
150: Return Varchar2 Is
151: --
152: -- Declare cursors

Line 175: if ( nvl(hr_cnp_bus.g_form_canvas_id, hr_api.g_number) = nvl(p_form_canvas_id, hr_api.g_number)

171: Begin
172: --
173: hr_utility.set_location('Entering:'|| l_proc, 10);
174: --
175: if ( nvl(hr_cnp_bus.g_form_canvas_id, hr_api.g_number) = nvl(p_form_canvas_id, hr_api.g_number)
176: and nvl(hr_cnp_bus.g_template_canvas_id, hr_api.g_number) = nvl(p_template_canvas_id, hr_api.g_number)
177: ) then
178: --
179: -- The canvas has already been found with a previous

Line 176: and nvl(hr_cnp_bus.g_template_canvas_id, hr_api.g_number) = nvl(p_template_canvas_id, hr_api.g_number)

172: --
173: hr_utility.set_location('Entering:'|| l_proc, 10);
174: --
175: if ( nvl(hr_cnp_bus.g_form_canvas_id, hr_api.g_number) = nvl(p_form_canvas_id, hr_api.g_number)
176: and nvl(hr_cnp_bus.g_template_canvas_id, hr_api.g_number) = nvl(p_template_canvas_id, hr_api.g_number)
177: ) then
178: --
179: -- The canvas has already been found with a previous
180: -- call to this function. Just return the value in the global

Line 190: if (nvl(p_form_canvas_id, hr_api.g_number) <> hr_api.g_number) then

186: --
187: -- The IDs are different to the last call to this function
188: -- or this is the first call to this function.
189: --
190: if (nvl(p_form_canvas_id, hr_api.g_number) <> hr_api.g_number) then
191: --
192: open csr_form_canvas;
193: fetch csr_form_canvas into l_canvas_type;
194: --

Line 205: elsif (nvl(p_template_canvas_id, hr_api.g_number) <> hr_api.g_number) then

201: end if;
202: hr_utility.set_location(l_proc,30);
203: close csr_form_canvas;
204: --
205: elsif (nvl(p_template_canvas_id, hr_api.g_number) <> hr_api.g_number) then
206: --
207: open csr_template_canvas;
208: fetch csr_template_canvas into l_canvas_type;
209: --

Line 271: nvl(hr_cnp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

267: begin
268: hr_utility.set_location('Entering:'||l_proc,10);
269: --
270: if ((p_rec.canvas_property_id is not null) and (
271: nvl(hr_cnp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
272: nvl(p_rec.information_category, hr_api.g_varchar2) or
273: nvl(hr_cnp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
274: nvl(p_rec.information1, hr_api.g_varchar2) or
275: nvl(hr_cnp_shd.g_old_rec.information2, hr_api.g_varchar2) <>

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

268: hr_utility.set_location('Entering:'||l_proc,10);
269: --
270: if ((p_rec.canvas_property_id is not null) and (
271: nvl(hr_cnp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
272: nvl(p_rec.information_category, hr_api.g_varchar2) or
273: nvl(hr_cnp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
274: nvl(p_rec.information1, hr_api.g_varchar2) or
275: nvl(hr_cnp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
276: nvl(p_rec.information2, hr_api.g_varchar2) or

Line 273: nvl(hr_cnp_shd.g_old_rec.information1, hr_api.g_varchar2) <>

269: --
270: if ((p_rec.canvas_property_id is not null) and (
271: nvl(hr_cnp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
272: nvl(p_rec.information_category, hr_api.g_varchar2) or
273: nvl(hr_cnp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
274: nvl(p_rec.information1, hr_api.g_varchar2) or
275: nvl(hr_cnp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
276: nvl(p_rec.information2, hr_api.g_varchar2) or
277: nvl(hr_cnp_shd.g_old_rec.information3, hr_api.g_varchar2) <>

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

270: if ((p_rec.canvas_property_id is not null) and (
271: nvl(hr_cnp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
272: nvl(p_rec.information_category, hr_api.g_varchar2) or
273: nvl(hr_cnp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
274: nvl(p_rec.information1, hr_api.g_varchar2) or
275: nvl(hr_cnp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
276: nvl(p_rec.information2, hr_api.g_varchar2) or
277: nvl(hr_cnp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
278: nvl(p_rec.information3, hr_api.g_varchar2) or

Line 275: nvl(hr_cnp_shd.g_old_rec.information2, hr_api.g_varchar2) <>

271: nvl(hr_cnp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
272: nvl(p_rec.information_category, hr_api.g_varchar2) or
273: nvl(hr_cnp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
274: nvl(p_rec.information1, hr_api.g_varchar2) or
275: nvl(hr_cnp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
276: nvl(p_rec.information2, hr_api.g_varchar2) or
277: nvl(hr_cnp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
278: nvl(p_rec.information3, hr_api.g_varchar2) or
279: nvl(hr_cnp_shd.g_old_rec.information4, hr_api.g_varchar2) <>

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

272: nvl(p_rec.information_category, hr_api.g_varchar2) or
273: nvl(hr_cnp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
274: nvl(p_rec.information1, hr_api.g_varchar2) or
275: nvl(hr_cnp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
276: nvl(p_rec.information2, hr_api.g_varchar2) or
277: nvl(hr_cnp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
278: nvl(p_rec.information3, hr_api.g_varchar2) or
279: nvl(hr_cnp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
280: nvl(p_rec.information4, hr_api.g_varchar2) or

Line 277: nvl(hr_cnp_shd.g_old_rec.information3, hr_api.g_varchar2) <>

273: nvl(hr_cnp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
274: nvl(p_rec.information1, hr_api.g_varchar2) or
275: nvl(hr_cnp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
276: nvl(p_rec.information2, hr_api.g_varchar2) or
277: nvl(hr_cnp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
278: nvl(p_rec.information3, hr_api.g_varchar2) or
279: nvl(hr_cnp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
280: nvl(p_rec.information4, hr_api.g_varchar2) or
281: nvl(hr_cnp_shd.g_old_rec.information5, hr_api.g_varchar2) <>

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

274: nvl(p_rec.information1, hr_api.g_varchar2) or
275: nvl(hr_cnp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
276: nvl(p_rec.information2, hr_api.g_varchar2) or
277: nvl(hr_cnp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
278: nvl(p_rec.information3, hr_api.g_varchar2) or
279: nvl(hr_cnp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
280: nvl(p_rec.information4, hr_api.g_varchar2) or
281: nvl(hr_cnp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
282: nvl(p_rec.information5, hr_api.g_varchar2) or

Line 279: nvl(hr_cnp_shd.g_old_rec.information4, hr_api.g_varchar2) <>

275: nvl(hr_cnp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
276: nvl(p_rec.information2, hr_api.g_varchar2) or
277: nvl(hr_cnp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
278: nvl(p_rec.information3, hr_api.g_varchar2) or
279: nvl(hr_cnp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
280: nvl(p_rec.information4, hr_api.g_varchar2) or
281: nvl(hr_cnp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
282: nvl(p_rec.information5, hr_api.g_varchar2) or
283: nvl(hr_cnp_shd.g_old_rec.information6, hr_api.g_varchar2) <>

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

276: nvl(p_rec.information2, hr_api.g_varchar2) or
277: nvl(hr_cnp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
278: nvl(p_rec.information3, hr_api.g_varchar2) or
279: nvl(hr_cnp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
280: nvl(p_rec.information4, hr_api.g_varchar2) or
281: nvl(hr_cnp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
282: nvl(p_rec.information5, hr_api.g_varchar2) or
283: nvl(hr_cnp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
284: nvl(p_rec.information6, hr_api.g_varchar2) or

Line 281: nvl(hr_cnp_shd.g_old_rec.information5, hr_api.g_varchar2) <>

277: nvl(hr_cnp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
278: nvl(p_rec.information3, hr_api.g_varchar2) or
279: nvl(hr_cnp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
280: nvl(p_rec.information4, hr_api.g_varchar2) or
281: nvl(hr_cnp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
282: nvl(p_rec.information5, hr_api.g_varchar2) or
283: nvl(hr_cnp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
284: nvl(p_rec.information6, hr_api.g_varchar2) or
285: nvl(hr_cnp_shd.g_old_rec.information7, hr_api.g_varchar2) <>

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

278: nvl(p_rec.information3, hr_api.g_varchar2) or
279: nvl(hr_cnp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
280: nvl(p_rec.information4, hr_api.g_varchar2) or
281: nvl(hr_cnp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
282: nvl(p_rec.information5, hr_api.g_varchar2) or
283: nvl(hr_cnp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
284: nvl(p_rec.information6, hr_api.g_varchar2) or
285: nvl(hr_cnp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
286: nvl(p_rec.information7, hr_api.g_varchar2) or

Line 283: nvl(hr_cnp_shd.g_old_rec.information6, hr_api.g_varchar2) <>

279: nvl(hr_cnp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
280: nvl(p_rec.information4, hr_api.g_varchar2) or
281: nvl(hr_cnp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
282: nvl(p_rec.information5, hr_api.g_varchar2) or
283: nvl(hr_cnp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
284: nvl(p_rec.information6, hr_api.g_varchar2) or
285: nvl(hr_cnp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
286: nvl(p_rec.information7, hr_api.g_varchar2) or
287: nvl(hr_cnp_shd.g_old_rec.information8, hr_api.g_varchar2) <>

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

280: nvl(p_rec.information4, hr_api.g_varchar2) or
281: nvl(hr_cnp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
282: nvl(p_rec.information5, hr_api.g_varchar2) or
283: nvl(hr_cnp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
284: nvl(p_rec.information6, hr_api.g_varchar2) or
285: nvl(hr_cnp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
286: nvl(p_rec.information7, hr_api.g_varchar2) or
287: nvl(hr_cnp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
288: nvl(p_rec.information8, hr_api.g_varchar2) or

Line 285: nvl(hr_cnp_shd.g_old_rec.information7, hr_api.g_varchar2) <>

281: nvl(hr_cnp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
282: nvl(p_rec.information5, hr_api.g_varchar2) or
283: nvl(hr_cnp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
284: nvl(p_rec.information6, hr_api.g_varchar2) or
285: nvl(hr_cnp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
286: nvl(p_rec.information7, hr_api.g_varchar2) or
287: nvl(hr_cnp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
288: nvl(p_rec.information8, hr_api.g_varchar2) or
289: nvl(hr_cnp_shd.g_old_rec.information9, hr_api.g_varchar2) <>

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

282: nvl(p_rec.information5, hr_api.g_varchar2) or
283: nvl(hr_cnp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
284: nvl(p_rec.information6, hr_api.g_varchar2) or
285: nvl(hr_cnp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
286: nvl(p_rec.information7, hr_api.g_varchar2) or
287: nvl(hr_cnp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
288: nvl(p_rec.information8, hr_api.g_varchar2) or
289: nvl(hr_cnp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
290: nvl(p_rec.information9, hr_api.g_varchar2) or

Line 287: nvl(hr_cnp_shd.g_old_rec.information8, hr_api.g_varchar2) <>

283: nvl(hr_cnp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
284: nvl(p_rec.information6, hr_api.g_varchar2) or
285: nvl(hr_cnp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
286: nvl(p_rec.information7, hr_api.g_varchar2) or
287: nvl(hr_cnp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
288: nvl(p_rec.information8, hr_api.g_varchar2) or
289: nvl(hr_cnp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
290: nvl(p_rec.information9, hr_api.g_varchar2) or
291: nvl(hr_cnp_shd.g_old_rec.information10, hr_api.g_varchar2) <>

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

284: nvl(p_rec.information6, hr_api.g_varchar2) or
285: nvl(hr_cnp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
286: nvl(p_rec.information7, hr_api.g_varchar2) or
287: nvl(hr_cnp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
288: nvl(p_rec.information8, hr_api.g_varchar2) or
289: nvl(hr_cnp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
290: nvl(p_rec.information9, hr_api.g_varchar2) or
291: nvl(hr_cnp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
292: nvl(p_rec.information10, hr_api.g_varchar2) or

Line 289: nvl(hr_cnp_shd.g_old_rec.information9, hr_api.g_varchar2) <>

285: nvl(hr_cnp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
286: nvl(p_rec.information7, hr_api.g_varchar2) or
287: nvl(hr_cnp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
288: nvl(p_rec.information8, hr_api.g_varchar2) or
289: nvl(hr_cnp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
290: nvl(p_rec.information9, hr_api.g_varchar2) or
291: nvl(hr_cnp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
292: nvl(p_rec.information10, hr_api.g_varchar2) or
293: nvl(hr_cnp_shd.g_old_rec.information11, hr_api.g_varchar2) <>

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

286: nvl(p_rec.information7, hr_api.g_varchar2) or
287: nvl(hr_cnp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
288: nvl(p_rec.information8, hr_api.g_varchar2) or
289: nvl(hr_cnp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
290: nvl(p_rec.information9, hr_api.g_varchar2) or
291: nvl(hr_cnp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
292: nvl(p_rec.information10, hr_api.g_varchar2) or
293: nvl(hr_cnp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
294: nvl(p_rec.information11, hr_api.g_varchar2) or

Line 291: nvl(hr_cnp_shd.g_old_rec.information10, hr_api.g_varchar2) <>

287: nvl(hr_cnp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
288: nvl(p_rec.information8, hr_api.g_varchar2) or
289: nvl(hr_cnp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
290: nvl(p_rec.information9, hr_api.g_varchar2) or
291: nvl(hr_cnp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
292: nvl(p_rec.information10, hr_api.g_varchar2) or
293: nvl(hr_cnp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
294: nvl(p_rec.information11, hr_api.g_varchar2) or
295: nvl(hr_cnp_shd.g_old_rec.information12, hr_api.g_varchar2) <>

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

288: nvl(p_rec.information8, hr_api.g_varchar2) or
289: nvl(hr_cnp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
290: nvl(p_rec.information9, hr_api.g_varchar2) or
291: nvl(hr_cnp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
292: nvl(p_rec.information10, hr_api.g_varchar2) or
293: nvl(hr_cnp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
294: nvl(p_rec.information11, hr_api.g_varchar2) or
295: nvl(hr_cnp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
296: nvl(p_rec.information12, hr_api.g_varchar2) or

Line 293: nvl(hr_cnp_shd.g_old_rec.information11, hr_api.g_varchar2) <>

289: nvl(hr_cnp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
290: nvl(p_rec.information9, hr_api.g_varchar2) or
291: nvl(hr_cnp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
292: nvl(p_rec.information10, hr_api.g_varchar2) or
293: nvl(hr_cnp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
294: nvl(p_rec.information11, hr_api.g_varchar2) or
295: nvl(hr_cnp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
296: nvl(p_rec.information12, hr_api.g_varchar2) or
297: nvl(hr_cnp_shd.g_old_rec.information13, hr_api.g_varchar2) <>

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

290: nvl(p_rec.information9, hr_api.g_varchar2) or
291: nvl(hr_cnp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
292: nvl(p_rec.information10, hr_api.g_varchar2) or
293: nvl(hr_cnp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
294: nvl(p_rec.information11, hr_api.g_varchar2) or
295: nvl(hr_cnp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
296: nvl(p_rec.information12, hr_api.g_varchar2) or
297: nvl(hr_cnp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
298: nvl(p_rec.information13, hr_api.g_varchar2) or

Line 295: nvl(hr_cnp_shd.g_old_rec.information12, hr_api.g_varchar2) <>

291: nvl(hr_cnp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
292: nvl(p_rec.information10, hr_api.g_varchar2) or
293: nvl(hr_cnp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
294: nvl(p_rec.information11, hr_api.g_varchar2) or
295: nvl(hr_cnp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
296: nvl(p_rec.information12, hr_api.g_varchar2) or
297: nvl(hr_cnp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
298: nvl(p_rec.information13, hr_api.g_varchar2) or
299: nvl(hr_cnp_shd.g_old_rec.information14, hr_api.g_varchar2) <>

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

292: nvl(p_rec.information10, hr_api.g_varchar2) or
293: nvl(hr_cnp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
294: nvl(p_rec.information11, hr_api.g_varchar2) or
295: nvl(hr_cnp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
296: nvl(p_rec.information12, hr_api.g_varchar2) or
297: nvl(hr_cnp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
298: nvl(p_rec.information13, hr_api.g_varchar2) or
299: nvl(hr_cnp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
300: nvl(p_rec.information14, hr_api.g_varchar2) or

Line 297: nvl(hr_cnp_shd.g_old_rec.information13, hr_api.g_varchar2) <>

293: nvl(hr_cnp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
294: nvl(p_rec.information11, hr_api.g_varchar2) or
295: nvl(hr_cnp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
296: nvl(p_rec.information12, hr_api.g_varchar2) or
297: nvl(hr_cnp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
298: nvl(p_rec.information13, hr_api.g_varchar2) or
299: nvl(hr_cnp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
300: nvl(p_rec.information14, hr_api.g_varchar2) or
301: nvl(hr_cnp_shd.g_old_rec.information15, hr_api.g_varchar2) <>

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

294: nvl(p_rec.information11, hr_api.g_varchar2) or
295: nvl(hr_cnp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
296: nvl(p_rec.information12, hr_api.g_varchar2) or
297: nvl(hr_cnp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
298: nvl(p_rec.information13, hr_api.g_varchar2) or
299: nvl(hr_cnp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
300: nvl(p_rec.information14, hr_api.g_varchar2) or
301: nvl(hr_cnp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
302: nvl(p_rec.information15, hr_api.g_varchar2) or

Line 299: nvl(hr_cnp_shd.g_old_rec.information14, hr_api.g_varchar2) <>

295: nvl(hr_cnp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
296: nvl(p_rec.information12, hr_api.g_varchar2) or
297: nvl(hr_cnp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
298: nvl(p_rec.information13, hr_api.g_varchar2) or
299: nvl(hr_cnp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
300: nvl(p_rec.information14, hr_api.g_varchar2) or
301: nvl(hr_cnp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
302: nvl(p_rec.information15, hr_api.g_varchar2) or
303: nvl(hr_cnp_shd.g_old_rec.information16, hr_api.g_varchar2) <>

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

296: nvl(p_rec.information12, hr_api.g_varchar2) or
297: nvl(hr_cnp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
298: nvl(p_rec.information13, hr_api.g_varchar2) or
299: nvl(hr_cnp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
300: nvl(p_rec.information14, hr_api.g_varchar2) or
301: nvl(hr_cnp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
302: nvl(p_rec.information15, hr_api.g_varchar2) or
303: nvl(hr_cnp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
304: nvl(p_rec.information16, hr_api.g_varchar2) or

Line 301: nvl(hr_cnp_shd.g_old_rec.information15, hr_api.g_varchar2) <>

297: nvl(hr_cnp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
298: nvl(p_rec.information13, hr_api.g_varchar2) or
299: nvl(hr_cnp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
300: nvl(p_rec.information14, hr_api.g_varchar2) or
301: nvl(hr_cnp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
302: nvl(p_rec.information15, hr_api.g_varchar2) or
303: nvl(hr_cnp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
304: nvl(p_rec.information16, hr_api.g_varchar2) or
305: nvl(hr_cnp_shd.g_old_rec.information17, hr_api.g_varchar2) <>

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

298: nvl(p_rec.information13, hr_api.g_varchar2) or
299: nvl(hr_cnp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
300: nvl(p_rec.information14, hr_api.g_varchar2) or
301: nvl(hr_cnp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
302: nvl(p_rec.information15, hr_api.g_varchar2) or
303: nvl(hr_cnp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
304: nvl(p_rec.information16, hr_api.g_varchar2) or
305: nvl(hr_cnp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
306: nvl(p_rec.information17, hr_api.g_varchar2) or

Line 303: nvl(hr_cnp_shd.g_old_rec.information16, hr_api.g_varchar2) <>

299: nvl(hr_cnp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
300: nvl(p_rec.information14, hr_api.g_varchar2) or
301: nvl(hr_cnp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
302: nvl(p_rec.information15, hr_api.g_varchar2) or
303: nvl(hr_cnp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
304: nvl(p_rec.information16, hr_api.g_varchar2) or
305: nvl(hr_cnp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
306: nvl(p_rec.information17, hr_api.g_varchar2) or
307: nvl(hr_cnp_shd.g_old_rec.information18, hr_api.g_varchar2) <>

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

300: nvl(p_rec.information14, hr_api.g_varchar2) or
301: nvl(hr_cnp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
302: nvl(p_rec.information15, hr_api.g_varchar2) or
303: nvl(hr_cnp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
304: nvl(p_rec.information16, hr_api.g_varchar2) or
305: nvl(hr_cnp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
306: nvl(p_rec.information17, hr_api.g_varchar2) or
307: nvl(hr_cnp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
308: nvl(p_rec.information18, hr_api.g_varchar2) or

Line 305: nvl(hr_cnp_shd.g_old_rec.information17, hr_api.g_varchar2) <>

301: nvl(hr_cnp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
302: nvl(p_rec.information15, hr_api.g_varchar2) or
303: nvl(hr_cnp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
304: nvl(p_rec.information16, hr_api.g_varchar2) or
305: nvl(hr_cnp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
306: nvl(p_rec.information17, hr_api.g_varchar2) or
307: nvl(hr_cnp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
308: nvl(p_rec.information18, hr_api.g_varchar2) or
309: nvl(hr_cnp_shd.g_old_rec.information19, hr_api.g_varchar2) <>

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

302: nvl(p_rec.information15, hr_api.g_varchar2) or
303: nvl(hr_cnp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
304: nvl(p_rec.information16, hr_api.g_varchar2) or
305: nvl(hr_cnp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
306: nvl(p_rec.information17, hr_api.g_varchar2) or
307: nvl(hr_cnp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
308: nvl(p_rec.information18, hr_api.g_varchar2) or
309: nvl(hr_cnp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
310: nvl(p_rec.information19, hr_api.g_varchar2) or

Line 307: nvl(hr_cnp_shd.g_old_rec.information18, hr_api.g_varchar2) <>

303: nvl(hr_cnp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
304: nvl(p_rec.information16, hr_api.g_varchar2) or
305: nvl(hr_cnp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
306: nvl(p_rec.information17, hr_api.g_varchar2) or
307: nvl(hr_cnp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
308: nvl(p_rec.information18, hr_api.g_varchar2) or
309: nvl(hr_cnp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
310: nvl(p_rec.information19, hr_api.g_varchar2) or
311: nvl(hr_cnp_shd.g_old_rec.information20, hr_api.g_varchar2) <>

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

304: nvl(p_rec.information16, hr_api.g_varchar2) or
305: nvl(hr_cnp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
306: nvl(p_rec.information17, hr_api.g_varchar2) or
307: nvl(hr_cnp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
308: nvl(p_rec.information18, hr_api.g_varchar2) or
309: nvl(hr_cnp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
310: nvl(p_rec.information19, hr_api.g_varchar2) or
311: nvl(hr_cnp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
312: nvl(p_rec.information20, hr_api.g_varchar2) or

Line 309: nvl(hr_cnp_shd.g_old_rec.information19, hr_api.g_varchar2) <>

305: nvl(hr_cnp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
306: nvl(p_rec.information17, hr_api.g_varchar2) or
307: nvl(hr_cnp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
308: nvl(p_rec.information18, hr_api.g_varchar2) or
309: nvl(hr_cnp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
310: nvl(p_rec.information19, hr_api.g_varchar2) or
311: nvl(hr_cnp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
312: nvl(p_rec.information20, hr_api.g_varchar2) or
313: nvl(hr_cnp_shd.g_old_rec.information21, hr_api.g_varchar2) <>

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

306: nvl(p_rec.information17, hr_api.g_varchar2) or
307: nvl(hr_cnp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
308: nvl(p_rec.information18, hr_api.g_varchar2) or
309: nvl(hr_cnp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
310: nvl(p_rec.information19, hr_api.g_varchar2) or
311: nvl(hr_cnp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
312: nvl(p_rec.information20, hr_api.g_varchar2) or
313: nvl(hr_cnp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
314: nvl(p_rec.information21, hr_api.g_varchar2) or

Line 311: nvl(hr_cnp_shd.g_old_rec.information20, hr_api.g_varchar2) <>

307: nvl(hr_cnp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
308: nvl(p_rec.information18, hr_api.g_varchar2) or
309: nvl(hr_cnp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
310: nvl(p_rec.information19, hr_api.g_varchar2) or
311: nvl(hr_cnp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
312: nvl(p_rec.information20, hr_api.g_varchar2) or
313: nvl(hr_cnp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
314: nvl(p_rec.information21, hr_api.g_varchar2) or
315: nvl(hr_cnp_shd.g_old_rec.information22, hr_api.g_varchar2) <>

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

308: nvl(p_rec.information18, hr_api.g_varchar2) or
309: nvl(hr_cnp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
310: nvl(p_rec.information19, hr_api.g_varchar2) or
311: nvl(hr_cnp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
312: nvl(p_rec.information20, hr_api.g_varchar2) or
313: nvl(hr_cnp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
314: nvl(p_rec.information21, hr_api.g_varchar2) or
315: nvl(hr_cnp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
316: nvl(p_rec.information22, hr_api.g_varchar2) or

Line 313: nvl(hr_cnp_shd.g_old_rec.information21, hr_api.g_varchar2) <>

309: nvl(hr_cnp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
310: nvl(p_rec.information19, hr_api.g_varchar2) or
311: nvl(hr_cnp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
312: nvl(p_rec.information20, hr_api.g_varchar2) or
313: nvl(hr_cnp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
314: nvl(p_rec.information21, hr_api.g_varchar2) or
315: nvl(hr_cnp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
316: nvl(p_rec.information22, hr_api.g_varchar2) or
317: nvl(hr_cnp_shd.g_old_rec.information23, hr_api.g_varchar2) <>

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

310: nvl(p_rec.information19, hr_api.g_varchar2) or
311: nvl(hr_cnp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
312: nvl(p_rec.information20, hr_api.g_varchar2) or
313: nvl(hr_cnp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
314: nvl(p_rec.information21, hr_api.g_varchar2) or
315: nvl(hr_cnp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
316: nvl(p_rec.information22, hr_api.g_varchar2) or
317: nvl(hr_cnp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
318: nvl(p_rec.information23, hr_api.g_varchar2) or

Line 315: nvl(hr_cnp_shd.g_old_rec.information22, hr_api.g_varchar2) <>

311: nvl(hr_cnp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
312: nvl(p_rec.information20, hr_api.g_varchar2) or
313: nvl(hr_cnp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
314: nvl(p_rec.information21, hr_api.g_varchar2) or
315: nvl(hr_cnp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
316: nvl(p_rec.information22, hr_api.g_varchar2) or
317: nvl(hr_cnp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
318: nvl(p_rec.information23, hr_api.g_varchar2) or
319: nvl(hr_cnp_shd.g_old_rec.information24, hr_api.g_varchar2) <>

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

312: nvl(p_rec.information20, hr_api.g_varchar2) or
313: nvl(hr_cnp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
314: nvl(p_rec.information21, hr_api.g_varchar2) or
315: nvl(hr_cnp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
316: nvl(p_rec.information22, hr_api.g_varchar2) or
317: nvl(hr_cnp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
318: nvl(p_rec.information23, hr_api.g_varchar2) or
319: nvl(hr_cnp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
320: nvl(p_rec.information24, hr_api.g_varchar2) or

Line 317: nvl(hr_cnp_shd.g_old_rec.information23, hr_api.g_varchar2) <>

313: nvl(hr_cnp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
314: nvl(p_rec.information21, hr_api.g_varchar2) or
315: nvl(hr_cnp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
316: nvl(p_rec.information22, hr_api.g_varchar2) or
317: nvl(hr_cnp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
318: nvl(p_rec.information23, hr_api.g_varchar2) or
319: nvl(hr_cnp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
320: nvl(p_rec.information24, hr_api.g_varchar2) or
321: nvl(hr_cnp_shd.g_old_rec.information25, hr_api.g_varchar2) <>

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

314: nvl(p_rec.information21, hr_api.g_varchar2) or
315: nvl(hr_cnp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
316: nvl(p_rec.information22, hr_api.g_varchar2) or
317: nvl(hr_cnp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
318: nvl(p_rec.information23, hr_api.g_varchar2) or
319: nvl(hr_cnp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
320: nvl(p_rec.information24, hr_api.g_varchar2) or
321: nvl(hr_cnp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
322: nvl(p_rec.information25, hr_api.g_varchar2) or

Line 319: nvl(hr_cnp_shd.g_old_rec.information24, hr_api.g_varchar2) <>

315: nvl(hr_cnp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
316: nvl(p_rec.information22, hr_api.g_varchar2) or
317: nvl(hr_cnp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
318: nvl(p_rec.information23, hr_api.g_varchar2) or
319: nvl(hr_cnp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
320: nvl(p_rec.information24, hr_api.g_varchar2) or
321: nvl(hr_cnp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
322: nvl(p_rec.information25, hr_api.g_varchar2) or
323: nvl(hr_cnp_shd.g_old_rec.information26, hr_api.g_varchar2) <>

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

316: nvl(p_rec.information22, hr_api.g_varchar2) or
317: nvl(hr_cnp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
318: nvl(p_rec.information23, hr_api.g_varchar2) or
319: nvl(hr_cnp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
320: nvl(p_rec.information24, hr_api.g_varchar2) or
321: nvl(hr_cnp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
322: nvl(p_rec.information25, hr_api.g_varchar2) or
323: nvl(hr_cnp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
324: nvl(p_rec.information26, hr_api.g_varchar2) or

Line 321: nvl(hr_cnp_shd.g_old_rec.information25, hr_api.g_varchar2) <>

317: nvl(hr_cnp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
318: nvl(p_rec.information23, hr_api.g_varchar2) or
319: nvl(hr_cnp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
320: nvl(p_rec.information24, hr_api.g_varchar2) or
321: nvl(hr_cnp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
322: nvl(p_rec.information25, hr_api.g_varchar2) or
323: nvl(hr_cnp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
324: nvl(p_rec.information26, hr_api.g_varchar2) or
325: nvl(hr_cnp_shd.g_old_rec.information27, hr_api.g_varchar2) <>

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

318: nvl(p_rec.information23, hr_api.g_varchar2) or
319: nvl(hr_cnp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
320: nvl(p_rec.information24, hr_api.g_varchar2) or
321: nvl(hr_cnp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
322: nvl(p_rec.information25, hr_api.g_varchar2) or
323: nvl(hr_cnp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
324: nvl(p_rec.information26, hr_api.g_varchar2) or
325: nvl(hr_cnp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
326: nvl(p_rec.information27, hr_api.g_varchar2) or

Line 323: nvl(hr_cnp_shd.g_old_rec.information26, hr_api.g_varchar2) <>

319: nvl(hr_cnp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
320: nvl(p_rec.information24, hr_api.g_varchar2) or
321: nvl(hr_cnp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
322: nvl(p_rec.information25, hr_api.g_varchar2) or
323: nvl(hr_cnp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
324: nvl(p_rec.information26, hr_api.g_varchar2) or
325: nvl(hr_cnp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
326: nvl(p_rec.information27, hr_api.g_varchar2) or
327: nvl(hr_cnp_shd.g_old_rec.information28, hr_api.g_varchar2) <>

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

320: nvl(p_rec.information24, hr_api.g_varchar2) or
321: nvl(hr_cnp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
322: nvl(p_rec.information25, hr_api.g_varchar2) or
323: nvl(hr_cnp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
324: nvl(p_rec.information26, hr_api.g_varchar2) or
325: nvl(hr_cnp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
326: nvl(p_rec.information27, hr_api.g_varchar2) or
327: nvl(hr_cnp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
328: nvl(p_rec.information28, hr_api.g_varchar2) or

Line 325: nvl(hr_cnp_shd.g_old_rec.information27, hr_api.g_varchar2) <>

321: nvl(hr_cnp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
322: nvl(p_rec.information25, hr_api.g_varchar2) or
323: nvl(hr_cnp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
324: nvl(p_rec.information26, hr_api.g_varchar2) or
325: nvl(hr_cnp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
326: nvl(p_rec.information27, hr_api.g_varchar2) or
327: nvl(hr_cnp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
328: nvl(p_rec.information28, hr_api.g_varchar2) or
329: nvl(hr_cnp_shd.g_old_rec.information29, hr_api.g_varchar2) <>

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

322: nvl(p_rec.information25, hr_api.g_varchar2) or
323: nvl(hr_cnp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
324: nvl(p_rec.information26, hr_api.g_varchar2) or
325: nvl(hr_cnp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
326: nvl(p_rec.information27, hr_api.g_varchar2) or
327: nvl(hr_cnp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
328: nvl(p_rec.information28, hr_api.g_varchar2) or
329: nvl(hr_cnp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
330: nvl(p_rec.information29, hr_api.g_varchar2) or

Line 327: nvl(hr_cnp_shd.g_old_rec.information28, hr_api.g_varchar2) <>

323: nvl(hr_cnp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
324: nvl(p_rec.information26, hr_api.g_varchar2) or
325: nvl(hr_cnp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
326: nvl(p_rec.information27, hr_api.g_varchar2) or
327: nvl(hr_cnp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
328: nvl(p_rec.information28, hr_api.g_varchar2) or
329: nvl(hr_cnp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
330: nvl(p_rec.information29, hr_api.g_varchar2) or
331: nvl(hr_cnp_shd.g_old_rec.information30, hr_api.g_varchar2) <>

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

324: nvl(p_rec.information26, hr_api.g_varchar2) or
325: nvl(hr_cnp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
326: nvl(p_rec.information27, hr_api.g_varchar2) or
327: nvl(hr_cnp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
328: nvl(p_rec.information28, hr_api.g_varchar2) or
329: nvl(hr_cnp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
330: nvl(p_rec.information29, hr_api.g_varchar2) or
331: nvl(hr_cnp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
332: nvl(p_rec.information30, hr_api.g_varchar2) )

Line 329: nvl(hr_cnp_shd.g_old_rec.information29, hr_api.g_varchar2) <>

325: nvl(hr_cnp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
326: nvl(p_rec.information27, hr_api.g_varchar2) or
327: nvl(hr_cnp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
328: nvl(p_rec.information28, hr_api.g_varchar2) or
329: nvl(hr_cnp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
330: nvl(p_rec.information29, hr_api.g_varchar2) or
331: nvl(hr_cnp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
332: nvl(p_rec.information30, hr_api.g_varchar2) )
333: or (p_rec.canvas_property_id is null) ) then

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

326: nvl(p_rec.information27, hr_api.g_varchar2) or
327: nvl(hr_cnp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
328: nvl(p_rec.information28, hr_api.g_varchar2) or
329: nvl(hr_cnp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
330: nvl(p_rec.information29, hr_api.g_varchar2) or
331: nvl(hr_cnp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
332: nvl(p_rec.information30, hr_api.g_varchar2) )
333: or (p_rec.canvas_property_id is null) ) then
334: --

Line 331: nvl(hr_cnp_shd.g_old_rec.information30, hr_api.g_varchar2) <>

327: nvl(hr_cnp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
328: nvl(p_rec.information28, hr_api.g_varchar2) or
329: nvl(hr_cnp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
330: nvl(p_rec.information29, hr_api.g_varchar2) or
331: nvl(hr_cnp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
332: nvl(p_rec.information30, hr_api.g_varchar2) )
333: or (p_rec.canvas_property_id is null) ) then
334: --
335: -- Only execute the validation if absolutely necessary:

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

328: nvl(p_rec.information28, hr_api.g_varchar2) or
329: nvl(hr_cnp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
330: nvl(p_rec.information29, hr_api.g_varchar2) or
331: nvl(hr_cnp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
332: nvl(p_rec.information30, hr_api.g_varchar2) )
333: or (p_rec.canvas_property_id is null) ) then
334: --
335: -- Only execute the validation if absolutely necessary:
336: -- a) During update, the structure column value or any

Line 461: IF (nvl(p_rec.form_canvas_id,hr_api.g_number) <>

457: fnd_message.set_token('STEP ', '5');
458: fnd_message.raise_error;
459: END IF;
460: --
461: IF (nvl(p_rec.form_canvas_id,hr_api.g_number) <>
462: nvl(hr_cnp_shd.g_old_rec.form_canvas_id,hr_api.g_number)
463: ) THEN
464: l_argument := 'form_canvas_id';
465: RAISE l_error;

Line 462: nvl(hr_cnp_shd.g_old_rec.form_canvas_id,hr_api.g_number)

458: fnd_message.raise_error;
459: END IF;
460: --
461: IF (nvl(p_rec.form_canvas_id,hr_api.g_number) <>
462: nvl(hr_cnp_shd.g_old_rec.form_canvas_id,hr_api.g_number)
463: ) THEN
464: l_argument := 'form_canvas_id';
465: RAISE l_error;
466: END IF;

Line 468: IF (nvl(p_rec.template_canvas_id,hr_api.g_number) <>

464: l_argument := 'form_canvas_id';
465: RAISE l_error;
466: END IF;
467: --
468: IF (nvl(p_rec.template_canvas_id,hr_api.g_number) <>
469: nvl(hr_cnp_shd.g_old_rec.template_canvas_id,hr_api.g_number)
470: ) THEN
471: l_argument := 'template_canvas_id';
472: RAISE l_error;

Line 469: nvl(hr_cnp_shd.g_old_rec.template_canvas_id,hr_api.g_number)

465: RAISE l_error;
466: END IF;
467: --
468: IF (nvl(p_rec.template_canvas_id,hr_api.g_number) <>
469: nvl(hr_cnp_shd.g_old_rec.template_canvas_id,hr_api.g_number)
470: ) THEN
471: l_argument := 'template_canvas_id';
472: RAISE l_error;
473: END IF;

Line 477: hr_api.argument_changed_error

473: END IF;
474: --
475: EXCEPTION
476: WHEN l_error THEN
477: hr_api.argument_changed_error
478: (p_api_name => l_proc
479: ,p_argument => l_argument);
480: WHEN OTHERS THEN
481: RAISE;

Line 541: and nvl(hr_cnp_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>

537: --
538: -- Only proceed with SQL validation if absolutely necessary
539: --
540: if ( ( l_api_updating
541: and nvl(hr_cnp_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
542: nvl(p_form_canvas_id,hr_api.g_number))
543: or (NOT l_api_updating)) then
544: --
545: hr_utility.set_location(l_proc,30);

Line 542: nvl(p_form_canvas_id,hr_api.g_number))

538: -- Only proceed with SQL validation if absolutely necessary
539: --
540: if ( ( l_api_updating
541: and nvl(hr_cnp_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
542: nvl(p_form_canvas_id,hr_api.g_number))
543: or (NOT l_api_updating)) then
544: --
545: hr_utility.set_location(l_proc,30);
546: --

Line 558: if (nvl(l_canvas_type,hr_api.g_varchar2) NOT in ('CONTENT','TAB','TAB_STACKED')) then

554: (p_form_canvas_id => p_form_canvas_id
555: );
556: --
557: /*
558: if (nvl(l_canvas_type,hr_api.g_varchar2) NOT in ('CONTENT','TAB','TAB_STACKED')) then
559: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
560: fnd_message.set_token('PROCEDURE', l_proc);
561: fnd_message.set_token('STEP','10');
562: fnd_message.raise_error;

Line 599: and nvl(hr_cnp_shd.g_old_rec.template_canvas_id,hr_api.g_number) <>

595: --
596: -- Only proceed with SQL validation if absolutely necessary
597: --
598: if ( ( l_api_updating
599: and nvl(hr_cnp_shd.g_old_rec.template_canvas_id,hr_api.g_number) <>
600: nvl(p_template_canvas_id,hr_api.g_number))
601: or (NOT l_api_updating)) then
602: --
603: hr_utility.set_location(l_proc,30);

Line 600: nvl(p_template_canvas_id,hr_api.g_number))

596: -- Only proceed with SQL validation if absolutely necessary
597: --
598: if ( ( l_api_updating
599: and nvl(hr_cnp_shd.g_old_rec.template_canvas_id,hr_api.g_number) <>
600: nvl(p_template_canvas_id,hr_api.g_number))
601: or (NOT l_api_updating)) then
602: --
603: hr_utility.set_location(l_proc,30);
604: --

Line 615: if (nvl(l_canvas_type,hr_api.g_varchar2) NOT in ('CONTENT','TAB')) then

611: l_canvas_type := return_canvas_type
612: (p_template_canvas_id => p_template_canvas_id
613: );
614: /*
615: if (nvl(l_canvas_type,hr_api.g_varchar2) NOT in ('CONTENT','TAB')) then
616: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
617: fnd_message.set_token('PROCEDURE', l_proc);
618: fnd_message.set_token('STEP','10');
619: fnd_message.raise_error;

Line 681: hr_api.mandatory_arg_error

677: hr_utility.set_location('Entering:'||l_proc, 10);
678: --
679: -- Check mandatory arguments have been set
680: --
681: hr_api.mandatory_arg_error
682: (p_api_name => l_proc
683: ,p_argument => 'effective_date'
684: ,p_argument_value => p_effective_date
685: );

Line 696: and nvl(hr_cnp_shd.g_old_rec.visible,hr_api.g_number) <>

692: --
693: -- Only proceed with SQL validation if absolutely necessary
694: --
695: if ( ( l_api_updating
696: and nvl(hr_cnp_shd.g_old_rec.visible,hr_api.g_number) <>
697: nvl(p_visible,hr_api.g_number))
698: or (NOT l_api_updating)) then
699: --
700: hr_utility.set_location(l_proc,30);

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

693: -- Only proceed with SQL validation if absolutely necessary
694: --
695: if ( ( l_api_updating
696: and nvl(hr_cnp_shd.g_old_rec.visible,hr_api.g_number) <>
697: nvl(p_visible,hr_api.g_number))
698: or (NOT l_api_updating)) then
699: --
700: hr_utility.set_location(l_proc,30);
701: --

Line 709: if hr_api.not_exists_in_hrstanlookups

705: --
706: -- Must exist in hr_standard_lookups where lookup_type is
707: -- PROPERTY_TRUE_OR_FALSE
708: --
709: if hr_api.not_exists_in_hrstanlookups
710: (p_effective_date => p_effective_date
711: ,p_lookup_type => 'PROPERTY_TRUE_OR_FALSE'
712: ,p_lookup_code => p_visible
713: ) then

Line 881: if (nvl(p_rec.height,hr_api.g_number) <> nvl(l_window_height,hr_api.g_number)) then

877: fetch csr_template_window into l_window_height,l_window_width;
878: close csr_template_window;
879: end if;
880: --
881: if (nvl(p_rec.height,hr_api.g_number) <> nvl(l_window_height,hr_api.g_number)) then
882: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
883: fnd_message.set_token('PROCEDURE', l_proc);
884: fnd_message.set_token('STEP','10');
885: fnd_message.raise_error;

Line 888: if (nvl(p_rec.width,hr_api.g_number) <> nvl(l_window_width,hr_api.g_number)) then

884: fnd_message.set_token('STEP','10');
885: fnd_message.raise_error;
886: end if;
887: --
888: if (nvl(p_rec.width,hr_api.g_number) <> nvl(l_window_width,hr_api.g_number)) then
889: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
890: fnd_message.set_token('PROCEDURE', l_proc);
891: fnd_message.set_token('STEP','20');
892: fnd_message.raise_error;

Line 900: if (nvl(l_canvas_type,hr_api.g_varchar2) not in ('TAB','STACKED')) then

896: --
897: -- Visible is only applicable for TAB or STACKED canvases
898: --
899: if (p_rec.visible is not null) then
900: if (nvl(l_canvas_type,hr_api.g_varchar2) not in ('TAB','STACKED')) then
901: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
902: fnd_message.set_token('PROCEDURE', l_proc);
903: fnd_message.set_token('STEP','30');
904: fnd_message.raise_error;

Line 911: if (nvl(l_canvas_type,hr_api.g_varchar2) not in ('TAB','STACKED')) then

907: --
908: -- X position is only applicable for TAB or STACKED canvases
909: --
910: if (p_rec.x_position is not null) then
911: if (nvl(l_canvas_type,hr_api.g_varchar2) not in ('TAB','STACKED')) then
912: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
913: fnd_message.set_token('PROCEDURE', l_proc);
914: fnd_message.set_token('STEP','40');
915: fnd_message.raise_error;

Line 922: if (nvl(l_canvas_type,hr_api.g_varchar2) not in ('TAB','STACKED')) then

918: --
919: -- Y position is only applicable for TAB or STACKED canvases
920: --
921: if (p_rec.y_position is not null) then
922: if (nvl(l_canvas_type,hr_api.g_varchar2) not in ('TAB','STACKED')) then
923: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
924: fnd_message.set_token('PROCEDURE', l_proc);
925: fnd_message.set_token('STEP','50');
926: fnd_message.raise_error;

Line 967: hr_api.mandatory_arg_error

963: hr_utility.set_location('Entering:'||l_proc, 5);
964: --
965: -- Check mandatory arguments have been set
966: --
967: hr_api.mandatory_arg_error
968: (p_api_name => l_proc
969: ,p_argument => 'effective_date'
970: ,p_argument_value => p_effective_date
971: );

Line 1055: hr_api.mandatory_arg_error

1051: hr_utility.set_location('Entering:'||l_proc, 5);
1052: --
1053: -- Check mandatory arguments have been set
1054: --
1055: hr_api.mandatory_arg_error
1056: (p_api_name => l_proc
1057: ,p_argument => 'effective_date'
1058: ,p_argument_value => p_effective_date
1059: );