APPS.PER_JOB_BUS dependencies on PER_JOB_SHD

Line 86: l_api_updating := per_job_shd.api_updating

82: );
83: --
84: hr_utility.set_location(l_proc, 2);
85: --
86: l_api_updating := per_job_shd.api_updating
87: (p_job_id => p_job_id
88: ,p_object_version_number => p_object_version_number);
89: --
90: hr_utility.set_location(l_proc, 3);

Line 93: (per_job_shd.g_old_rec.job_definition_id <>

89: --
90: hr_utility.set_location(l_proc, 3);
91: --
92: if ((l_api_updating and
93: (per_job_shd.g_old_rec.job_definition_id <>
94: p_job_definition_id)) or (NOT l_api_updating)) then
95: --
96: hr_utility.set_location(l_proc, 4);
97: --

Line 102: per_job_shd.constraint_error(p_constraint_name => 'PER_JOBS_FK2');

98: open csr_job_def;
99: fetch csr_job_def into l_exists;
100: if csr_job_def%notfound then
101: close csr_job_def;
102: per_job_shd.constraint_error(p_constraint_name => 'PER_JOBS_FK2');
103: end if;
104: close csr_job_def;
105: --
106: hr_utility.set_location(l_proc, 5);

Line 181: l_api_updating := per_job_shd.api_updating

177: -- Only proceed with validation if :
178: -- a) The current g_old_rec is current and
179: -- b) The date_end value has changed
180: --
181: l_api_updating := per_job_shd.api_updating
182: (p_job_id => p_job_id
183: ,p_object_version_number => p_object_version_number);
184: --
185: if (((l_api_updating and

Line 186: (nvl(per_job_shd.g_old_rec.date_to,hr_api.g_eot) <>

182: (p_job_id => p_job_id
183: ,p_object_version_number => p_object_version_number);
184: --
185: if (((l_api_updating and
186: (nvl(per_job_shd.g_old_rec.date_to,hr_api.g_eot) <>
187: nvl(p_date_to,hr_api.g_eot)) or
188: (per_job_shd.g_old_rec.date_from <> p_date_from)) or
189: (NOT l_api_updating))) then
190: --

Line 188: (per_job_shd.g_old_rec.date_from <> p_date_from)) or

184: --
185: if (((l_api_updating and
186: (nvl(per_job_shd.g_old_rec.date_to,hr_api.g_eot) <>
187: nvl(p_date_to,hr_api.g_eot)) or
188: (per_job_shd.g_old_rec.date_from <> p_date_from)) or
189: (NOT l_api_updating))) then
190: --
191: -- Check that date_from <= date_to
192: --

Line 235: (p_rec in per_job_shd.g_rec_type) is

231: -- Access Status:
232: -- Internal Row Handler Use Only.
233: --
234: procedure chk_df
235: (p_rec in per_job_shd.g_rec_type) is
236: --
237: l_proc varchar2(72) := g_package||'chk_df';
238: --
239: begin

Line 243: nvl(per_job_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

239: begin
240: hr_utility.set_location('Entering:'||l_proc, 10);
241: --
242: if ((p_rec.job_id is not null) and (
243: nvl(per_job_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
244: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
245: nvl(per_job_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
246: nvl(p_rec.attribute1, hr_api.g_varchar2) or
247: nvl(per_job_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 245: nvl(per_job_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

241: --
242: if ((p_rec.job_id is not null) and (
243: nvl(per_job_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
244: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
245: nvl(per_job_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
246: nvl(p_rec.attribute1, hr_api.g_varchar2) or
247: nvl(per_job_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
248: nvl(p_rec.attribute2, hr_api.g_varchar2) or
249: nvl(per_job_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 247: nvl(per_job_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

243: nvl(per_job_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
244: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
245: nvl(per_job_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
246: nvl(p_rec.attribute1, hr_api.g_varchar2) or
247: nvl(per_job_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
248: nvl(p_rec.attribute2, hr_api.g_varchar2) or
249: nvl(per_job_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
250: nvl(p_rec.attribute3, hr_api.g_varchar2) or
251: nvl(per_job_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 249: nvl(per_job_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

245: nvl(per_job_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
246: nvl(p_rec.attribute1, hr_api.g_varchar2) or
247: nvl(per_job_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
248: nvl(p_rec.attribute2, hr_api.g_varchar2) or
249: nvl(per_job_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
250: nvl(p_rec.attribute3, hr_api.g_varchar2) or
251: nvl(per_job_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
252: nvl(p_rec.attribute4, hr_api.g_varchar2) or
253: nvl(per_job_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 251: nvl(per_job_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

247: nvl(per_job_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
248: nvl(p_rec.attribute2, hr_api.g_varchar2) or
249: nvl(per_job_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
250: nvl(p_rec.attribute3, hr_api.g_varchar2) or
251: nvl(per_job_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
252: nvl(p_rec.attribute4, hr_api.g_varchar2) or
253: nvl(per_job_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
254: nvl(p_rec.attribute5, hr_api.g_varchar2) or
255: nvl(per_job_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 253: nvl(per_job_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

249: nvl(per_job_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
250: nvl(p_rec.attribute3, hr_api.g_varchar2) or
251: nvl(per_job_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
252: nvl(p_rec.attribute4, hr_api.g_varchar2) or
253: nvl(per_job_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
254: nvl(p_rec.attribute5, hr_api.g_varchar2) or
255: nvl(per_job_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute6, hr_api.g_varchar2) or
257: nvl(per_job_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 255: nvl(per_job_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

251: nvl(per_job_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
252: nvl(p_rec.attribute4, hr_api.g_varchar2) or
253: nvl(per_job_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
254: nvl(p_rec.attribute5, hr_api.g_varchar2) or
255: nvl(per_job_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute6, hr_api.g_varchar2) or
257: nvl(per_job_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute7, hr_api.g_varchar2) or
259: nvl(per_job_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 257: nvl(per_job_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

253: nvl(per_job_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
254: nvl(p_rec.attribute5, hr_api.g_varchar2) or
255: nvl(per_job_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute6, hr_api.g_varchar2) or
257: nvl(per_job_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute7, hr_api.g_varchar2) or
259: nvl(per_job_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute8, hr_api.g_varchar2) or
261: nvl(per_job_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 259: nvl(per_job_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

255: nvl(per_job_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute6, hr_api.g_varchar2) or
257: nvl(per_job_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute7, hr_api.g_varchar2) or
259: nvl(per_job_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute8, hr_api.g_varchar2) or
261: nvl(per_job_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute9, hr_api.g_varchar2) or
263: nvl(per_job_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 261: nvl(per_job_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

257: nvl(per_job_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute7, hr_api.g_varchar2) or
259: nvl(per_job_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute8, hr_api.g_varchar2) or
261: nvl(per_job_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute9, hr_api.g_varchar2) or
263: nvl(per_job_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute10, hr_api.g_varchar2) or
265: nvl(per_job_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 263: nvl(per_job_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

259: nvl(per_job_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute8, hr_api.g_varchar2) or
261: nvl(per_job_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute9, hr_api.g_varchar2) or
263: nvl(per_job_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute10, hr_api.g_varchar2) or
265: nvl(per_job_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute11, hr_api.g_varchar2) or
267: nvl(per_job_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 265: nvl(per_job_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

261: nvl(per_job_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute9, hr_api.g_varchar2) or
263: nvl(per_job_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute10, hr_api.g_varchar2) or
265: nvl(per_job_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute11, hr_api.g_varchar2) or
267: nvl(per_job_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
268: nvl(p_rec.attribute12, hr_api.g_varchar2) or
269: nvl(per_job_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 267: nvl(per_job_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

263: nvl(per_job_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute10, hr_api.g_varchar2) or
265: nvl(per_job_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute11, hr_api.g_varchar2) or
267: nvl(per_job_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
268: nvl(p_rec.attribute12, hr_api.g_varchar2) or
269: nvl(per_job_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
270: nvl(p_rec.attribute13, hr_api.g_varchar2) or
271: nvl(per_job_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 269: nvl(per_job_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

265: nvl(per_job_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute11, hr_api.g_varchar2) or
267: nvl(per_job_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
268: nvl(p_rec.attribute12, hr_api.g_varchar2) or
269: nvl(per_job_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
270: nvl(p_rec.attribute13, hr_api.g_varchar2) or
271: nvl(per_job_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
272: nvl(p_rec.attribute14, hr_api.g_varchar2) or
273: nvl(per_job_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 271: nvl(per_job_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

267: nvl(per_job_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
268: nvl(p_rec.attribute12, hr_api.g_varchar2) or
269: nvl(per_job_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
270: nvl(p_rec.attribute13, hr_api.g_varchar2) or
271: nvl(per_job_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
272: nvl(p_rec.attribute14, hr_api.g_varchar2) or
273: nvl(per_job_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
274: nvl(p_rec.attribute15, hr_api.g_varchar2) or
275: nvl(per_job_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 273: nvl(per_job_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

269: nvl(per_job_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
270: nvl(p_rec.attribute13, hr_api.g_varchar2) or
271: nvl(per_job_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
272: nvl(p_rec.attribute14, hr_api.g_varchar2) or
273: nvl(per_job_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
274: nvl(p_rec.attribute15, hr_api.g_varchar2) or
275: nvl(per_job_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
276: nvl(p_rec.attribute16, hr_api.g_varchar2) or
277: nvl(per_job_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 275: nvl(per_job_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

271: nvl(per_job_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
272: nvl(p_rec.attribute14, hr_api.g_varchar2) or
273: nvl(per_job_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
274: nvl(p_rec.attribute15, hr_api.g_varchar2) or
275: nvl(per_job_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
276: nvl(p_rec.attribute16, hr_api.g_varchar2) or
277: nvl(per_job_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
278: nvl(p_rec.attribute17, hr_api.g_varchar2) or
279: nvl(per_job_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 277: nvl(per_job_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

273: nvl(per_job_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
274: nvl(p_rec.attribute15, hr_api.g_varchar2) or
275: nvl(per_job_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
276: nvl(p_rec.attribute16, hr_api.g_varchar2) or
277: nvl(per_job_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
278: nvl(p_rec.attribute17, hr_api.g_varchar2) or
279: nvl(per_job_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
280: nvl(p_rec.attribute18, hr_api.g_varchar2) or
281: nvl(per_job_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 279: nvl(per_job_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

275: nvl(per_job_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
276: nvl(p_rec.attribute16, hr_api.g_varchar2) or
277: nvl(per_job_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
278: nvl(p_rec.attribute17, hr_api.g_varchar2) or
279: nvl(per_job_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
280: nvl(p_rec.attribute18, hr_api.g_varchar2) or
281: nvl(per_job_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
282: nvl(p_rec.attribute19, hr_api.g_varchar2) or
283: nvl(per_job_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 281: nvl(per_job_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

277: nvl(per_job_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
278: nvl(p_rec.attribute17, hr_api.g_varchar2) or
279: nvl(per_job_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
280: nvl(p_rec.attribute18, hr_api.g_varchar2) or
281: nvl(per_job_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
282: nvl(p_rec.attribute19, hr_api.g_varchar2) or
283: nvl(per_job_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
284: nvl(p_rec.attribute20, hr_api.g_varchar2)))
285: or

Line 283: nvl(per_job_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

279: nvl(per_job_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
280: nvl(p_rec.attribute18, hr_api.g_varchar2) or
281: nvl(per_job_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
282: nvl(p_rec.attribute19, hr_api.g_varchar2) or
283: nvl(per_job_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
284: nvl(p_rec.attribute20, hr_api.g_varchar2)))
285: or
286: (p_rec.job_id is null) then
287: --

Line 371: (p_rec in per_job_shd.g_rec_type) is

367: -- Access Status:
368: -- Internal Row Handler Use Only.
369: --
370: procedure chk_ddf
371: (p_rec in per_job_shd.g_rec_type) is
372: --
373: l_proc varchar2(72) := g_package||'chk_ddf';
374: --
375: begin

Line 379: nvl(per_job_shd.g_old_rec.job_information_category, hr_api.g_varchar2) <>

375: begin
376: hr_utility.set_location('Entering:'||l_proc, 10);
377: --
378: if ((p_rec.job_id is not null) and (
379: nvl(per_job_shd.g_old_rec.job_information_category, hr_api.g_varchar2) <>
380: nvl(p_rec.job_information_category, hr_api.g_varchar2) or
381: nvl(per_job_shd.g_old_rec.job_information1, hr_api.g_varchar2) <>
382: nvl(p_rec.job_information1, hr_api.g_varchar2) or
383: nvl(per_job_shd.g_old_rec.job_information2, hr_api.g_varchar2) <>

Line 381: nvl(per_job_shd.g_old_rec.job_information1, hr_api.g_varchar2) <>

377: --
378: if ((p_rec.job_id is not null) and (
379: nvl(per_job_shd.g_old_rec.job_information_category, hr_api.g_varchar2) <>
380: nvl(p_rec.job_information_category, hr_api.g_varchar2) or
381: nvl(per_job_shd.g_old_rec.job_information1, hr_api.g_varchar2) <>
382: nvl(p_rec.job_information1, hr_api.g_varchar2) or
383: nvl(per_job_shd.g_old_rec.job_information2, hr_api.g_varchar2) <>
384: nvl(p_rec.job_information2, hr_api.g_varchar2) or
385: nvl(per_job_shd.g_old_rec.job_information3, hr_api.g_varchar2) <>

Line 383: nvl(per_job_shd.g_old_rec.job_information2, hr_api.g_varchar2) <>

379: nvl(per_job_shd.g_old_rec.job_information_category, hr_api.g_varchar2) <>
380: nvl(p_rec.job_information_category, hr_api.g_varchar2) or
381: nvl(per_job_shd.g_old_rec.job_information1, hr_api.g_varchar2) <>
382: nvl(p_rec.job_information1, hr_api.g_varchar2) or
383: nvl(per_job_shd.g_old_rec.job_information2, hr_api.g_varchar2) <>
384: nvl(p_rec.job_information2, hr_api.g_varchar2) or
385: nvl(per_job_shd.g_old_rec.job_information3, hr_api.g_varchar2) <>
386: nvl(p_rec.job_information3, hr_api.g_varchar2) or
387: nvl(per_job_shd.g_old_rec.job_information4, hr_api.g_varchar2) <>

Line 385: nvl(per_job_shd.g_old_rec.job_information3, hr_api.g_varchar2) <>

381: nvl(per_job_shd.g_old_rec.job_information1, hr_api.g_varchar2) <>
382: nvl(p_rec.job_information1, hr_api.g_varchar2) or
383: nvl(per_job_shd.g_old_rec.job_information2, hr_api.g_varchar2) <>
384: nvl(p_rec.job_information2, hr_api.g_varchar2) or
385: nvl(per_job_shd.g_old_rec.job_information3, hr_api.g_varchar2) <>
386: nvl(p_rec.job_information3, hr_api.g_varchar2) or
387: nvl(per_job_shd.g_old_rec.job_information4, hr_api.g_varchar2) <>
388: nvl(p_rec.job_information4, hr_api.g_varchar2) or
389: nvl(per_job_shd.g_old_rec.job_information5, hr_api.g_varchar2) <>

Line 387: nvl(per_job_shd.g_old_rec.job_information4, hr_api.g_varchar2) <>

383: nvl(per_job_shd.g_old_rec.job_information2, hr_api.g_varchar2) <>
384: nvl(p_rec.job_information2, hr_api.g_varchar2) or
385: nvl(per_job_shd.g_old_rec.job_information3, hr_api.g_varchar2) <>
386: nvl(p_rec.job_information3, hr_api.g_varchar2) or
387: nvl(per_job_shd.g_old_rec.job_information4, hr_api.g_varchar2) <>
388: nvl(p_rec.job_information4, hr_api.g_varchar2) or
389: nvl(per_job_shd.g_old_rec.job_information5, hr_api.g_varchar2) <>
390: nvl(p_rec.job_information5, hr_api.g_varchar2) or
391: nvl(per_job_shd.g_old_rec.job_information6, hr_api.g_varchar2) <>

Line 389: nvl(per_job_shd.g_old_rec.job_information5, hr_api.g_varchar2) <>

385: nvl(per_job_shd.g_old_rec.job_information3, hr_api.g_varchar2) <>
386: nvl(p_rec.job_information3, hr_api.g_varchar2) or
387: nvl(per_job_shd.g_old_rec.job_information4, hr_api.g_varchar2) <>
388: nvl(p_rec.job_information4, hr_api.g_varchar2) or
389: nvl(per_job_shd.g_old_rec.job_information5, hr_api.g_varchar2) <>
390: nvl(p_rec.job_information5, hr_api.g_varchar2) or
391: nvl(per_job_shd.g_old_rec.job_information6, hr_api.g_varchar2) <>
392: nvl(p_rec.job_information6, hr_api.g_varchar2) or
393: nvl(per_job_shd.g_old_rec.job_information7, hr_api.g_varchar2) <>

Line 391: nvl(per_job_shd.g_old_rec.job_information6, hr_api.g_varchar2) <>

387: nvl(per_job_shd.g_old_rec.job_information4, hr_api.g_varchar2) <>
388: nvl(p_rec.job_information4, hr_api.g_varchar2) or
389: nvl(per_job_shd.g_old_rec.job_information5, hr_api.g_varchar2) <>
390: nvl(p_rec.job_information5, hr_api.g_varchar2) or
391: nvl(per_job_shd.g_old_rec.job_information6, hr_api.g_varchar2) <>
392: nvl(p_rec.job_information6, hr_api.g_varchar2) or
393: nvl(per_job_shd.g_old_rec.job_information7, hr_api.g_varchar2) <>
394: nvl(p_rec.job_information7, hr_api.g_varchar2) or
395: nvl(per_job_shd.g_old_rec.job_information8, hr_api.g_varchar2) <>

Line 393: nvl(per_job_shd.g_old_rec.job_information7, hr_api.g_varchar2) <>

389: nvl(per_job_shd.g_old_rec.job_information5, hr_api.g_varchar2) <>
390: nvl(p_rec.job_information5, hr_api.g_varchar2) or
391: nvl(per_job_shd.g_old_rec.job_information6, hr_api.g_varchar2) <>
392: nvl(p_rec.job_information6, hr_api.g_varchar2) or
393: nvl(per_job_shd.g_old_rec.job_information7, hr_api.g_varchar2) <>
394: nvl(p_rec.job_information7, hr_api.g_varchar2) or
395: nvl(per_job_shd.g_old_rec.job_information8, hr_api.g_varchar2) <>
396: nvl(p_rec.job_information8, hr_api.g_varchar2) or
397: nvl(per_job_shd.g_old_rec.job_information9, hr_api.g_varchar2) <>

Line 395: nvl(per_job_shd.g_old_rec.job_information8, hr_api.g_varchar2) <>

391: nvl(per_job_shd.g_old_rec.job_information6, hr_api.g_varchar2) <>
392: nvl(p_rec.job_information6, hr_api.g_varchar2) or
393: nvl(per_job_shd.g_old_rec.job_information7, hr_api.g_varchar2) <>
394: nvl(p_rec.job_information7, hr_api.g_varchar2) or
395: nvl(per_job_shd.g_old_rec.job_information8, hr_api.g_varchar2) <>
396: nvl(p_rec.job_information8, hr_api.g_varchar2) or
397: nvl(per_job_shd.g_old_rec.job_information9, hr_api.g_varchar2) <>
398: nvl(p_rec.job_information9, hr_api.g_varchar2) or
399: nvl(per_job_shd.g_old_rec.job_information10, hr_api.g_varchar2) <>

Line 397: nvl(per_job_shd.g_old_rec.job_information9, hr_api.g_varchar2) <>

393: nvl(per_job_shd.g_old_rec.job_information7, hr_api.g_varchar2) <>
394: nvl(p_rec.job_information7, hr_api.g_varchar2) or
395: nvl(per_job_shd.g_old_rec.job_information8, hr_api.g_varchar2) <>
396: nvl(p_rec.job_information8, hr_api.g_varchar2) or
397: nvl(per_job_shd.g_old_rec.job_information9, hr_api.g_varchar2) <>
398: nvl(p_rec.job_information9, hr_api.g_varchar2) or
399: nvl(per_job_shd.g_old_rec.job_information10, hr_api.g_varchar2) <>
400: nvl(p_rec.job_information10, hr_api.g_varchar2) or
401: nvl(per_job_shd.g_old_rec.job_information11, hr_api.g_varchar2) <>

Line 399: nvl(per_job_shd.g_old_rec.job_information10, hr_api.g_varchar2) <>

395: nvl(per_job_shd.g_old_rec.job_information8, hr_api.g_varchar2) <>
396: nvl(p_rec.job_information8, hr_api.g_varchar2) or
397: nvl(per_job_shd.g_old_rec.job_information9, hr_api.g_varchar2) <>
398: nvl(p_rec.job_information9, hr_api.g_varchar2) or
399: nvl(per_job_shd.g_old_rec.job_information10, hr_api.g_varchar2) <>
400: nvl(p_rec.job_information10, hr_api.g_varchar2) or
401: nvl(per_job_shd.g_old_rec.job_information11, hr_api.g_varchar2) <>
402: nvl(p_rec.job_information11, hr_api.g_varchar2) or
403: nvl(per_job_shd.g_old_rec.job_information12, hr_api.g_varchar2) <>

Line 401: nvl(per_job_shd.g_old_rec.job_information11, hr_api.g_varchar2) <>

397: nvl(per_job_shd.g_old_rec.job_information9, hr_api.g_varchar2) <>
398: nvl(p_rec.job_information9, hr_api.g_varchar2) or
399: nvl(per_job_shd.g_old_rec.job_information10, hr_api.g_varchar2) <>
400: nvl(p_rec.job_information10, hr_api.g_varchar2) or
401: nvl(per_job_shd.g_old_rec.job_information11, hr_api.g_varchar2) <>
402: nvl(p_rec.job_information11, hr_api.g_varchar2) or
403: nvl(per_job_shd.g_old_rec.job_information12, hr_api.g_varchar2) <>
404: nvl(p_rec.job_information12, hr_api.g_varchar2) or
405: nvl(per_job_shd.g_old_rec.job_information13, hr_api.g_varchar2) <>

Line 403: nvl(per_job_shd.g_old_rec.job_information12, hr_api.g_varchar2) <>

399: nvl(per_job_shd.g_old_rec.job_information10, hr_api.g_varchar2) <>
400: nvl(p_rec.job_information10, hr_api.g_varchar2) or
401: nvl(per_job_shd.g_old_rec.job_information11, hr_api.g_varchar2) <>
402: nvl(p_rec.job_information11, hr_api.g_varchar2) or
403: nvl(per_job_shd.g_old_rec.job_information12, hr_api.g_varchar2) <>
404: nvl(p_rec.job_information12, hr_api.g_varchar2) or
405: nvl(per_job_shd.g_old_rec.job_information13, hr_api.g_varchar2) <>
406: nvl(p_rec.job_information13, hr_api.g_varchar2) or
407: nvl(per_job_shd.g_old_rec.job_information14, hr_api.g_varchar2) <>

Line 405: nvl(per_job_shd.g_old_rec.job_information13, hr_api.g_varchar2) <>

401: nvl(per_job_shd.g_old_rec.job_information11, hr_api.g_varchar2) <>
402: nvl(p_rec.job_information11, hr_api.g_varchar2) or
403: nvl(per_job_shd.g_old_rec.job_information12, hr_api.g_varchar2) <>
404: nvl(p_rec.job_information12, hr_api.g_varchar2) or
405: nvl(per_job_shd.g_old_rec.job_information13, hr_api.g_varchar2) <>
406: nvl(p_rec.job_information13, hr_api.g_varchar2) or
407: nvl(per_job_shd.g_old_rec.job_information14, hr_api.g_varchar2) <>
408: nvl(p_rec.job_information14, hr_api.g_varchar2) or
409: nvl(per_job_shd.g_old_rec.job_information15, hr_api.g_varchar2) <>

Line 407: nvl(per_job_shd.g_old_rec.job_information14, hr_api.g_varchar2) <>

403: nvl(per_job_shd.g_old_rec.job_information12, hr_api.g_varchar2) <>
404: nvl(p_rec.job_information12, hr_api.g_varchar2) or
405: nvl(per_job_shd.g_old_rec.job_information13, hr_api.g_varchar2) <>
406: nvl(p_rec.job_information13, hr_api.g_varchar2) or
407: nvl(per_job_shd.g_old_rec.job_information14, hr_api.g_varchar2) <>
408: nvl(p_rec.job_information14, hr_api.g_varchar2) or
409: nvl(per_job_shd.g_old_rec.job_information15, hr_api.g_varchar2) <>
410: nvl(p_rec.job_information15, hr_api.g_varchar2) or
411: nvl(per_job_shd.g_old_rec.job_information16, hr_api.g_varchar2) <>

Line 409: nvl(per_job_shd.g_old_rec.job_information15, hr_api.g_varchar2) <>

405: nvl(per_job_shd.g_old_rec.job_information13, hr_api.g_varchar2) <>
406: nvl(p_rec.job_information13, hr_api.g_varchar2) or
407: nvl(per_job_shd.g_old_rec.job_information14, hr_api.g_varchar2) <>
408: nvl(p_rec.job_information14, hr_api.g_varchar2) or
409: nvl(per_job_shd.g_old_rec.job_information15, hr_api.g_varchar2) <>
410: nvl(p_rec.job_information15, hr_api.g_varchar2) or
411: nvl(per_job_shd.g_old_rec.job_information16, hr_api.g_varchar2) <>
412: nvl(p_rec.job_information16, hr_api.g_varchar2) or
413: nvl(per_job_shd.g_old_rec.job_information17, hr_api.g_varchar2) <>

Line 411: nvl(per_job_shd.g_old_rec.job_information16, hr_api.g_varchar2) <>

407: nvl(per_job_shd.g_old_rec.job_information14, hr_api.g_varchar2) <>
408: nvl(p_rec.job_information14, hr_api.g_varchar2) or
409: nvl(per_job_shd.g_old_rec.job_information15, hr_api.g_varchar2) <>
410: nvl(p_rec.job_information15, hr_api.g_varchar2) or
411: nvl(per_job_shd.g_old_rec.job_information16, hr_api.g_varchar2) <>
412: nvl(p_rec.job_information16, hr_api.g_varchar2) or
413: nvl(per_job_shd.g_old_rec.job_information17, hr_api.g_varchar2) <>
414: nvl(p_rec.job_information17, hr_api.g_varchar2) or
415: nvl(per_job_shd.g_old_rec.job_information18, hr_api.g_varchar2) <>

Line 413: nvl(per_job_shd.g_old_rec.job_information17, hr_api.g_varchar2) <>

409: nvl(per_job_shd.g_old_rec.job_information15, hr_api.g_varchar2) <>
410: nvl(p_rec.job_information15, hr_api.g_varchar2) or
411: nvl(per_job_shd.g_old_rec.job_information16, hr_api.g_varchar2) <>
412: nvl(p_rec.job_information16, hr_api.g_varchar2) or
413: nvl(per_job_shd.g_old_rec.job_information17, hr_api.g_varchar2) <>
414: nvl(p_rec.job_information17, hr_api.g_varchar2) or
415: nvl(per_job_shd.g_old_rec.job_information18, hr_api.g_varchar2) <>
416: nvl(p_rec.job_information18, hr_api.g_varchar2) or
417: nvl(per_job_shd.g_old_rec.job_information19, hr_api.g_varchar2) <>

Line 415: nvl(per_job_shd.g_old_rec.job_information18, hr_api.g_varchar2) <>

411: nvl(per_job_shd.g_old_rec.job_information16, hr_api.g_varchar2) <>
412: nvl(p_rec.job_information16, hr_api.g_varchar2) or
413: nvl(per_job_shd.g_old_rec.job_information17, hr_api.g_varchar2) <>
414: nvl(p_rec.job_information17, hr_api.g_varchar2) or
415: nvl(per_job_shd.g_old_rec.job_information18, hr_api.g_varchar2) <>
416: nvl(p_rec.job_information18, hr_api.g_varchar2) or
417: nvl(per_job_shd.g_old_rec.job_information19, hr_api.g_varchar2) <>
418: nvl(p_rec.job_information19, hr_api.g_varchar2) or
419: nvl(per_job_shd.g_old_rec.job_information20, hr_api.g_varchar2) <>

Line 417: nvl(per_job_shd.g_old_rec.job_information19, hr_api.g_varchar2) <>

413: nvl(per_job_shd.g_old_rec.job_information17, hr_api.g_varchar2) <>
414: nvl(p_rec.job_information17, hr_api.g_varchar2) or
415: nvl(per_job_shd.g_old_rec.job_information18, hr_api.g_varchar2) <>
416: nvl(p_rec.job_information18, hr_api.g_varchar2) or
417: nvl(per_job_shd.g_old_rec.job_information19, hr_api.g_varchar2) <>
418: nvl(p_rec.job_information19, hr_api.g_varchar2) or
419: nvl(per_job_shd.g_old_rec.job_information20, hr_api.g_varchar2) <>
420: nvl(p_rec.job_information20, hr_api.g_varchar2)))
421: or

Line 419: nvl(per_job_shd.g_old_rec.job_information20, hr_api.g_varchar2) <>

415: nvl(per_job_shd.g_old_rec.job_information18, hr_api.g_varchar2) <>
416: nvl(p_rec.job_information18, hr_api.g_varchar2) or
417: nvl(per_job_shd.g_old_rec.job_information19, hr_api.g_varchar2) <>
418: nvl(p_rec.job_information19, hr_api.g_varchar2) or
419: nvl(per_job_shd.g_old_rec.job_information20, hr_api.g_varchar2) <>
420: nvl(p_rec.job_information20, hr_api.g_varchar2)))
421: or
422: (p_rec.job_id is null) then
423: --

Line 482: Procedure insert_validate(p_rec in per_job_shd.g_rec_type) is

478: --
479: -- ---------------------------------------------------------------------------
480: -- |---------------------------< insert_validate >----------------------------|
481: -- ----------------------------------------------------------------------------
482: Procedure insert_validate(p_rec in per_job_shd.g_rec_type) is
483: --
484: l_proc varchar2(72) := g_package||'insert_validate';
485: --
486: Begin

Line 571: Procedure update_validate(p_rec in per_job_shd.g_rec_type) is

567: --
568: -- ----------------------------------------------------------------------------
569: -- |---------------------------< update_validate >----------------------------|
570: -- ----------------------------------------------------------------------------
571: Procedure update_validate(p_rec in per_job_shd.g_rec_type) is
572: --
573: l_proc varchar2(72) := g_package||'update_validate';
574: --
575: Begin

Line 666: Procedure delete_validate(p_rec in per_job_shd.g_rec_type) is

662: --
663: -- ----------------------------------------------------------------------------
664: -- |---------------------------< delete_validate >----------------------------|
665: -- ----------------------------------------------------------------------------
666: Procedure delete_validate(p_rec in per_job_shd.g_rec_type) is
667: --
668: cursor csr_bg is select business_group_id from per_jobs
669: where job_id = p_rec.job_id;
670: l_business_group_id number;

Line 757: ,p_rec in per_job_shd.g_rec_type

753: -- |-----------------------< chk_non_updateable_args >------------------------|
754: -- ----------------------------------------------------------------------------
755: Procedure chk_non_updateable_args
756: (p_date_from in date
757: ,p_rec in per_job_shd.g_rec_type
758: ) IS
759: --
760: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
761: l_error EXCEPTION;

Line 769: IF NOT per_job_shd.api_updating

765: --
766: -- Only proceed with the validation if a row exists for the current
767: -- record in the HR Schema.
768: --
769: IF NOT per_job_shd.api_updating
770: (p_job_id => p_rec.job_id,
771: p_object_version_number => p_rec.object_version_number
772: ) THEN
773: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 780: nvl(per_job_shd.g_old_rec.business_group_id,hr_api.g_number)

776: fnd_message.raise_error;
777: END IF;
778: --
779: IF (nvl(p_rec.business_group_id,hr_api.g_number) <>
780: nvl(per_job_shd.g_old_rec.business_group_id,hr_api.g_number)
781: ) THEN
782: l_argument := 'business_group_id';
783: RAISE l_error;
784: END IF;

Line 787: nvl(per_job_shd.g_old_rec.job_group_id,hr_api.g_number)

783: RAISE l_error;
784: END IF;
785:
786: IF (nvl(p_rec.job_group_id,hr_api.g_number) <>
787: nvl(per_job_shd.g_old_rec.job_group_id,hr_api.g_number)
788: ) THEN
789: l_argument := 'job_group_id';
790: RAISE l_error;
791: END IF;

Line 794: nvl(per_job_shd.g_old_rec.job_id,hr_api.g_number)

790: RAISE l_error;
791: END IF;
792:
793: IF (nvl(p_rec.job_id,hr_api.g_number) <>
794: nvl(per_job_shd.g_old_rec.job_id,hr_api.g_number)
795: ) THEN
796: l_argument := 'job_id';
797: RAISE l_error;
798: END IF;

Line 814: ,p_rec in per_job_shd.g_rec_type) is

810: -- |------------------------< chk_emp_rights_flag >-------------------------|
811: -- -------------------------------------------------------------------------+
812: procedure chk_emp_rights_flag
813: (p_emp_rights_flag in per_jobs.emp_rights_flag%TYPE
814: ,p_rec in per_job_shd.g_rec_type) is
815:
816: l_proc varchar2(72) := g_package||'chk_emp_rights_flag';
817: l_api_updating boolean;
818:

Line 822: l_api_updating := per_job_shd.api_updating

818:
819: begin
820: hr_utility.set_location('Entering:'|| l_proc, 10);
821:
822: l_api_updating := per_job_shd.api_updating
823: (p_job_id => p_rec.job_id
824: ,p_object_version_number => p_rec.object_version_number);
825:
826: if (l_api_updating and

Line 827: (nvl(per_job_shd.g_old_rec.emp_rights_flag,hr_api.g_varchar2) <>

823: (p_job_id => p_rec.job_id
824: ,p_object_version_number => p_rec.object_version_number);
825:
826: if (l_api_updating and
827: (nvl(per_job_shd.g_old_rec.emp_rights_flag,hr_api.g_varchar2) <>
828: nvl(p_emp_rights_flag,hr_api.g_varchar2)) or NOT l_api_updating) then
829:
830: if (p_emp_rights_flag <> 'Y' and p_emp_rights_flag <> 'N' and
831: p_emp_rights_flag is not null) then

Line 881: ,p_rec in per_job_shd.g_rec_type) is

877: -- |-----------------------< chk_approval_authority >-----------------------|
878: -- -------------------------------------------------------------------------+
879: procedure chk_approval_authority
880: (p_approval_authority in per_jobs.approval_authority%TYPE
881: ,p_rec in per_job_shd.g_rec_type) is
882:
883: l_proc varchar2(72) := g_package||'chk_approval_authority';
884: l_approval_authority number := p_approval_authority;
885: l_api_updating boolean;

Line 891: l_api_updating := per_job_shd.api_updating

887: begin
888:
889: hr_utility.set_location('Entering:'|| l_proc, 10);
890:
891: l_api_updating := per_job_shd.api_updating
892: (p_job_id => p_rec.job_id
893: ,p_object_version_number => p_rec.object_version_number);
894:
895: if (l_api_updating and

Line 896: (nvl(per_job_shd.g_old_rec.approval_authority,hr_api.g_number) <>

892: (p_job_id => p_rec.job_id
893: ,p_object_version_number => p_rec.object_version_number);
894:
895: if (l_api_updating and
896: (nvl(per_job_shd.g_old_rec.approval_authority,hr_api.g_number) <>
897: nvl(p_approval_authority,hr_api.g_number)) or
898: NOT l_api_updating) then
899:
900: if (l_approval_authority < 0) then

Line 917: ,p_rec in per_job_shd.g_rec_type) is

913: -- -------------------------------------------------------------------------+
914: procedure chk_benchmark_job_flag
915: (p_benchmark_job_flag in per_jobs.benchmark_job_flag%TYPE
916: ,p_benchmark_job_id in per_jobs.benchmark_job_id%TYPE
917: ,p_rec in per_job_shd.g_rec_type) is
918:
919: l_proc varchar2(72) := g_package||'chk_benchmark_job_flag';
920: l_api_updating boolean;
921: begin

Line 925: l_api_updating := per_job_shd.api_updating

921: begin
922:
923: hr_utility.set_location('Entering:'|| l_proc, 10);
924:
925: l_api_updating := per_job_shd.api_updating
926: (p_job_id => p_rec.job_id
927: ,p_object_version_number => p_rec.object_version_number);
928:
929: if (l_api_updating and

Line 930: (nvl(per_job_shd.g_old_rec.benchmark_job_flag,'N') <>

926: (p_job_id => p_rec.job_id
927: ,p_object_version_number => p_rec.object_version_number);
928:
929: if (l_api_updating and
930: (nvl(per_job_shd.g_old_rec.benchmark_job_flag,'N') <>
931: nvl(p_benchmark_job_flag, 'N')) or
932: (nvl(per_job_shd.g_old_rec.benchmark_job_id, hr_api.g_number) <>
933: nvl(p_benchmark_job_id, hr_api.g_number)) or
934: NOT l_api_updating) then

Line 932: (nvl(per_job_shd.g_old_rec.benchmark_job_id, hr_api.g_number) <>

928:
929: if (l_api_updating and
930: (nvl(per_job_shd.g_old_rec.benchmark_job_flag,'N') <>
931: nvl(p_benchmark_job_flag, 'N')) or
932: (nvl(per_job_shd.g_old_rec.benchmark_job_id, hr_api.g_number) <>
933: nvl(p_benchmark_job_id, hr_api.g_number)) or
934: NOT l_api_updating) then
935:
936: if (p_benchmark_job_flag = 'Y' and p_benchmark_job_id is not null) then

Line 954: ,p_rec in per_job_shd.g_rec_type) is

950: procedure chk_benchmark_job_id
951: (p_benchmark_job_id in per_jobs.benchmark_job_id%TYPE
952: ,p_job_id in per_jobs.job_id%TYPE
953: ,p_business_group_id in per_jobs.business_group_id%TYPE
954: ,p_rec in per_job_shd.g_rec_type) is
955:
956: cursor csr_benchmark_job_id is
957: select 1
958: from per_jobs

Line 976: l_api_updating := per_job_shd.api_updating

972: begin
973:
974: hr_utility.set_location('Entering:'|| l_proc, 10);
975:
976: l_api_updating := per_job_shd.api_updating
977: (p_job_id => p_rec.job_id
978: ,p_object_version_number => p_rec.object_version_number);
979:
980: if (l_api_updating and

Line 981: (nvl(per_job_shd.g_old_rec.benchmark_job_id,hr_api.g_number) <>

977: (p_job_id => p_rec.job_id
978: ,p_object_version_number => p_rec.object_version_number);
979:
980: if (l_api_updating and
981: (nvl(per_job_shd.g_old_rec.benchmark_job_id,hr_api.g_number) <>
982: nvl(p_benchmark_job_id,hr_api.g_number)) or NOT l_api_updating) then
983:
984: if (p_benchmark_job_id is not null) then
985: