APPS.PER_GRS_BUS dependencies on HR_API

Line 53: and nvl(p_cagr_grade_structure_id,hr_api.g_number)

49: p_object_version_number => p_object_version_number,
50: p_effective_date => p_effective_date);
51: --
52: if (l_api_updating
53: and nvl(p_cagr_grade_structure_id,hr_api.g_number)
54: <> per_grs_shd.g_old_rec.cagr_grade_structure_id) then
55: --
56: -- raise error as PK has changed
57: --

Line 127: hr_api.mandatory_arg_error

123: hr_utility.set_location('Entering:'||l_proc,5);
124: --
125: -- Perform COLLECTIVE_AGREEMENT_ID mandatory check
126: --
127: hr_api.mandatory_arg_error
128: (p_api_name => l_proc
129: ,p_argument => 'collective_agreement_id'
130: ,p_argument_value => p_collective_agreement_id
131: );

Line 202: hr_api.mandatory_arg_error

198: hr_utility.set_location('Entering:'||l_proc,5);
199: --
200: -- Perform id_flex_num mandatory check
201: --
202: hr_api.mandatory_arg_error
203: (p_api_name => l_proc
204: ,p_argument => 'id_flex_num'
205: ,p_argument_value => p_id_flex_num
206: );

Line 278: hr_api.mandatory_arg_error

274: hr_utility.set_location('Entering:'||l_proc,5);
275: --
276: -- Perform id_flex_num mandatory check
277: --
278: hr_api.mandatory_arg_error
279: (p_api_name => l_proc
280: ,p_argument => 'id_flex_num'
281: ,p_argument_value => p_id_flex_num
282: );

Line 288: hr_api.mandatory_arg_error

284: hr_utility.set_location(l_proc,10);
285: --
286: -- Perform COLLECTIVE_AGREEMENT_ID mandatory check
287: --
288: hr_api.mandatory_arg_error
289: (p_api_name => l_proc
290: ,p_argument => 'collective_agreement_id'
291: ,p_argument_value => p_collective_agreement_id
292: );

Line 350: nvl(per_grs_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

346: begin
347: hr_utility.set_location('Entering:'||l_proc, 10);
348: --
349: if ((p_rec.cagr_grade_structure_id is not null) and (
350: nvl(per_grs_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
352: nvl(per_grs_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute1, hr_api.g_varchar2) or
354: nvl(per_grs_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

347: hr_utility.set_location('Entering:'||l_proc, 10);
348: --
349: if ((p_rec.cagr_grade_structure_id is not null) and (
350: nvl(per_grs_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
352: nvl(per_grs_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute1, hr_api.g_varchar2) or
354: nvl(per_grs_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 352: nvl(per_grs_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

348: --
349: if ((p_rec.cagr_grade_structure_id is not null) and (
350: nvl(per_grs_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
352: nvl(per_grs_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute1, hr_api.g_varchar2) or
354: nvl(per_grs_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute2, hr_api.g_varchar2) or
356: nvl(per_grs_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

349: if ((p_rec.cagr_grade_structure_id is not null) and (
350: nvl(per_grs_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
352: nvl(per_grs_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute1, hr_api.g_varchar2) or
354: nvl(per_grs_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute2, hr_api.g_varchar2) or
356: nvl(per_grs_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 354: nvl(per_grs_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

350: nvl(per_grs_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
352: nvl(per_grs_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute1, hr_api.g_varchar2) or
354: nvl(per_grs_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute2, hr_api.g_varchar2) or
356: nvl(per_grs_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute3, hr_api.g_varchar2) or
358: nvl(per_grs_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

351: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
352: nvl(per_grs_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute1, hr_api.g_varchar2) or
354: nvl(per_grs_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute2, hr_api.g_varchar2) or
356: nvl(per_grs_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute3, hr_api.g_varchar2) or
358: nvl(per_grs_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 356: nvl(per_grs_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

352: nvl(per_grs_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute1, hr_api.g_varchar2) or
354: nvl(per_grs_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute2, hr_api.g_varchar2) or
356: nvl(per_grs_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute3, hr_api.g_varchar2) or
358: nvl(per_grs_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute4, hr_api.g_varchar2) or
360: nvl(per_grs_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

353: nvl(p_rec.attribute1, hr_api.g_varchar2) or
354: nvl(per_grs_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute2, hr_api.g_varchar2) or
356: nvl(per_grs_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute3, hr_api.g_varchar2) or
358: nvl(per_grs_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute4, hr_api.g_varchar2) or
360: nvl(per_grs_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 358: nvl(per_grs_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

354: nvl(per_grs_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute2, hr_api.g_varchar2) or
356: nvl(per_grs_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute3, hr_api.g_varchar2) or
358: nvl(per_grs_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute4, hr_api.g_varchar2) or
360: nvl(per_grs_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute5, hr_api.g_varchar2) or
362: nvl(per_grs_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

355: nvl(p_rec.attribute2, hr_api.g_varchar2) or
356: nvl(per_grs_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute3, hr_api.g_varchar2) or
358: nvl(per_grs_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute4, hr_api.g_varchar2) or
360: nvl(per_grs_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute5, hr_api.g_varchar2) or
362: nvl(per_grs_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 360: nvl(per_grs_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

356: nvl(per_grs_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute3, hr_api.g_varchar2) or
358: nvl(per_grs_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute4, hr_api.g_varchar2) or
360: nvl(per_grs_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute5, hr_api.g_varchar2) or
362: nvl(per_grs_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute6, hr_api.g_varchar2) or
364: nvl(per_grs_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

357: nvl(p_rec.attribute3, hr_api.g_varchar2) or
358: nvl(per_grs_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute4, hr_api.g_varchar2) or
360: nvl(per_grs_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute5, hr_api.g_varchar2) or
362: nvl(per_grs_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute6, hr_api.g_varchar2) or
364: nvl(per_grs_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 362: nvl(per_grs_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

358: nvl(per_grs_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute4, hr_api.g_varchar2) or
360: nvl(per_grs_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute5, hr_api.g_varchar2) or
362: nvl(per_grs_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute6, hr_api.g_varchar2) or
364: nvl(per_grs_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute7, hr_api.g_varchar2) or
366: nvl(per_grs_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

359: nvl(p_rec.attribute4, hr_api.g_varchar2) or
360: nvl(per_grs_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute5, hr_api.g_varchar2) or
362: nvl(per_grs_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute6, hr_api.g_varchar2) or
364: nvl(per_grs_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute7, hr_api.g_varchar2) or
366: nvl(per_grs_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 364: nvl(per_grs_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

360: nvl(per_grs_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute5, hr_api.g_varchar2) or
362: nvl(per_grs_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute6, hr_api.g_varchar2) or
364: nvl(per_grs_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute7, hr_api.g_varchar2) or
366: nvl(per_grs_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute8, hr_api.g_varchar2) or
368: nvl(per_grs_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

361: nvl(p_rec.attribute5, hr_api.g_varchar2) or
362: nvl(per_grs_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute6, hr_api.g_varchar2) or
364: nvl(per_grs_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute7, hr_api.g_varchar2) or
366: nvl(per_grs_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute8, hr_api.g_varchar2) or
368: nvl(per_grs_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 366: nvl(per_grs_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

362: nvl(per_grs_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute6, hr_api.g_varchar2) or
364: nvl(per_grs_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute7, hr_api.g_varchar2) or
366: nvl(per_grs_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute8, hr_api.g_varchar2) or
368: nvl(per_grs_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute9, hr_api.g_varchar2) or
370: nvl(per_grs_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

363: nvl(p_rec.attribute6, hr_api.g_varchar2) or
364: nvl(per_grs_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute7, hr_api.g_varchar2) or
366: nvl(per_grs_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute8, hr_api.g_varchar2) or
368: nvl(per_grs_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute9, hr_api.g_varchar2) or
370: nvl(per_grs_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 368: nvl(per_grs_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

364: nvl(per_grs_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute7, hr_api.g_varchar2) or
366: nvl(per_grs_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute8, hr_api.g_varchar2) or
368: nvl(per_grs_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute9, hr_api.g_varchar2) or
370: nvl(per_grs_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute10, hr_api.g_varchar2) or
372: nvl(per_grs_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

365: nvl(p_rec.attribute7, hr_api.g_varchar2) or
366: nvl(per_grs_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute8, hr_api.g_varchar2) or
368: nvl(per_grs_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute9, hr_api.g_varchar2) or
370: nvl(per_grs_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute10, hr_api.g_varchar2) or
372: nvl(per_grs_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
373: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 370: nvl(per_grs_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

366: nvl(per_grs_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute8, hr_api.g_varchar2) or
368: nvl(per_grs_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute9, hr_api.g_varchar2) or
370: nvl(per_grs_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute10, hr_api.g_varchar2) or
372: nvl(per_grs_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
373: nvl(p_rec.attribute11, hr_api.g_varchar2) or
374: nvl(per_grs_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

367: nvl(p_rec.attribute8, hr_api.g_varchar2) or
368: nvl(per_grs_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute9, hr_api.g_varchar2) or
370: nvl(per_grs_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute10, hr_api.g_varchar2) or
372: nvl(per_grs_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
373: nvl(p_rec.attribute11, hr_api.g_varchar2) or
374: nvl(per_grs_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
375: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 372: nvl(per_grs_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

368: nvl(per_grs_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute9, hr_api.g_varchar2) or
370: nvl(per_grs_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute10, hr_api.g_varchar2) or
372: nvl(per_grs_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
373: nvl(p_rec.attribute11, hr_api.g_varchar2) or
374: nvl(per_grs_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
375: nvl(p_rec.attribute12, hr_api.g_varchar2) or
376: nvl(per_grs_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

369: nvl(p_rec.attribute9, hr_api.g_varchar2) or
370: nvl(per_grs_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute10, hr_api.g_varchar2) or
372: nvl(per_grs_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
373: nvl(p_rec.attribute11, hr_api.g_varchar2) or
374: nvl(per_grs_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
375: nvl(p_rec.attribute12, hr_api.g_varchar2) or
376: nvl(per_grs_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
377: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 374: nvl(per_grs_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

370: nvl(per_grs_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute10, hr_api.g_varchar2) or
372: nvl(per_grs_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
373: nvl(p_rec.attribute11, hr_api.g_varchar2) or
374: nvl(per_grs_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
375: nvl(p_rec.attribute12, hr_api.g_varchar2) or
376: nvl(per_grs_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
377: nvl(p_rec.attribute13, hr_api.g_varchar2) or
378: nvl(per_grs_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

371: nvl(p_rec.attribute10, hr_api.g_varchar2) or
372: nvl(per_grs_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
373: nvl(p_rec.attribute11, hr_api.g_varchar2) or
374: nvl(per_grs_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
375: nvl(p_rec.attribute12, hr_api.g_varchar2) or
376: nvl(per_grs_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
377: nvl(p_rec.attribute13, hr_api.g_varchar2) or
378: nvl(per_grs_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
379: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 376: nvl(per_grs_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

372: nvl(per_grs_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
373: nvl(p_rec.attribute11, hr_api.g_varchar2) or
374: nvl(per_grs_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
375: nvl(p_rec.attribute12, hr_api.g_varchar2) or
376: nvl(per_grs_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
377: nvl(p_rec.attribute13, hr_api.g_varchar2) or
378: nvl(per_grs_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
379: nvl(p_rec.attribute14, hr_api.g_varchar2) or
380: nvl(per_grs_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

373: nvl(p_rec.attribute11, hr_api.g_varchar2) or
374: nvl(per_grs_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
375: nvl(p_rec.attribute12, hr_api.g_varchar2) or
376: nvl(per_grs_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
377: nvl(p_rec.attribute13, hr_api.g_varchar2) or
378: nvl(per_grs_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
379: nvl(p_rec.attribute14, hr_api.g_varchar2) or
380: nvl(per_grs_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
381: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 378: nvl(per_grs_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

374: nvl(per_grs_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
375: nvl(p_rec.attribute12, hr_api.g_varchar2) or
376: nvl(per_grs_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
377: nvl(p_rec.attribute13, hr_api.g_varchar2) or
378: nvl(per_grs_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
379: nvl(p_rec.attribute14, hr_api.g_varchar2) or
380: nvl(per_grs_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
381: nvl(p_rec.attribute15, hr_api.g_varchar2) or
382: nvl(per_grs_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

375: nvl(p_rec.attribute12, hr_api.g_varchar2) or
376: nvl(per_grs_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
377: nvl(p_rec.attribute13, hr_api.g_varchar2) or
378: nvl(per_grs_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
379: nvl(p_rec.attribute14, hr_api.g_varchar2) or
380: nvl(per_grs_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
381: nvl(p_rec.attribute15, hr_api.g_varchar2) or
382: nvl(per_grs_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
383: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 380: nvl(per_grs_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

376: nvl(per_grs_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
377: nvl(p_rec.attribute13, hr_api.g_varchar2) or
378: nvl(per_grs_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
379: nvl(p_rec.attribute14, hr_api.g_varchar2) or
380: nvl(per_grs_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
381: nvl(p_rec.attribute15, hr_api.g_varchar2) or
382: nvl(per_grs_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
383: nvl(p_rec.attribute16, hr_api.g_varchar2) or
384: nvl(per_grs_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

377: nvl(p_rec.attribute13, hr_api.g_varchar2) or
378: nvl(per_grs_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
379: nvl(p_rec.attribute14, hr_api.g_varchar2) or
380: nvl(per_grs_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
381: nvl(p_rec.attribute15, hr_api.g_varchar2) or
382: nvl(per_grs_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
383: nvl(p_rec.attribute16, hr_api.g_varchar2) or
384: nvl(per_grs_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
385: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 382: nvl(per_grs_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

378: nvl(per_grs_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
379: nvl(p_rec.attribute14, hr_api.g_varchar2) or
380: nvl(per_grs_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
381: nvl(p_rec.attribute15, hr_api.g_varchar2) or
382: nvl(per_grs_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
383: nvl(p_rec.attribute16, hr_api.g_varchar2) or
384: nvl(per_grs_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
385: nvl(p_rec.attribute17, hr_api.g_varchar2) or
386: nvl(per_grs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

379: nvl(p_rec.attribute14, hr_api.g_varchar2) or
380: nvl(per_grs_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
381: nvl(p_rec.attribute15, hr_api.g_varchar2) or
382: nvl(per_grs_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
383: nvl(p_rec.attribute16, hr_api.g_varchar2) or
384: nvl(per_grs_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
385: nvl(p_rec.attribute17, hr_api.g_varchar2) or
386: nvl(per_grs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
387: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 384: nvl(per_grs_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

380: nvl(per_grs_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
381: nvl(p_rec.attribute15, hr_api.g_varchar2) or
382: nvl(per_grs_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
383: nvl(p_rec.attribute16, hr_api.g_varchar2) or
384: nvl(per_grs_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
385: nvl(p_rec.attribute17, hr_api.g_varchar2) or
386: nvl(per_grs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
387: nvl(p_rec.attribute18, hr_api.g_varchar2) or
388: nvl(per_grs_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

381: nvl(p_rec.attribute15, hr_api.g_varchar2) or
382: nvl(per_grs_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
383: nvl(p_rec.attribute16, hr_api.g_varchar2) or
384: nvl(per_grs_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
385: nvl(p_rec.attribute17, hr_api.g_varchar2) or
386: nvl(per_grs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
387: nvl(p_rec.attribute18, hr_api.g_varchar2) or
388: nvl(per_grs_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
389: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 386: nvl(per_grs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

382: nvl(per_grs_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
383: nvl(p_rec.attribute16, hr_api.g_varchar2) or
384: nvl(per_grs_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
385: nvl(p_rec.attribute17, hr_api.g_varchar2) or
386: nvl(per_grs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
387: nvl(p_rec.attribute18, hr_api.g_varchar2) or
388: nvl(per_grs_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
389: nvl(p_rec.attribute19, hr_api.g_varchar2) or
390: nvl(per_grs_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

383: nvl(p_rec.attribute16, hr_api.g_varchar2) or
384: nvl(per_grs_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
385: nvl(p_rec.attribute17, hr_api.g_varchar2) or
386: nvl(per_grs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
387: nvl(p_rec.attribute18, hr_api.g_varchar2) or
388: nvl(per_grs_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
389: nvl(p_rec.attribute19, hr_api.g_varchar2) or
390: nvl(per_grs_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
391: nvl(p_rec.attribute20, hr_api.g_varchar2)))

Line 388: nvl(per_grs_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

384: nvl(per_grs_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
385: nvl(p_rec.attribute17, hr_api.g_varchar2) or
386: nvl(per_grs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
387: nvl(p_rec.attribute18, hr_api.g_varchar2) or
388: nvl(per_grs_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
389: nvl(p_rec.attribute19, hr_api.g_varchar2) or
390: nvl(per_grs_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
391: nvl(p_rec.attribute20, hr_api.g_varchar2)))
392: or

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

385: nvl(p_rec.attribute17, hr_api.g_varchar2) or
386: nvl(per_grs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
387: nvl(p_rec.attribute18, hr_api.g_varchar2) or
388: nvl(per_grs_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
389: nvl(p_rec.attribute19, hr_api.g_varchar2) or
390: nvl(per_grs_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
391: nvl(p_rec.attribute20, hr_api.g_varchar2)))
392: or
393: (p_rec.cagr_grade_structure_id is null) then

Line 390: nvl(per_grs_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

386: nvl(per_grs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
387: nvl(p_rec.attribute18, hr_api.g_varchar2) or
388: nvl(per_grs_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
389: nvl(p_rec.attribute19, hr_api.g_varchar2) or
390: nvl(per_grs_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
391: nvl(p_rec.attribute20, hr_api.g_varchar2)))
392: or
393: (p_rec.cagr_grade_structure_id is null) then
394: --

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

387: nvl(p_rec.attribute18, hr_api.g_varchar2) or
388: nvl(per_grs_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
389: nvl(p_rec.attribute19, hr_api.g_varchar2) or
390: nvl(per_grs_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
391: nvl(p_rec.attribute20, hr_api.g_varchar2)))
392: or
393: (p_rec.cagr_grade_structure_id is null) then
394: --
395: -- Only execute the validation if absolutely necessary:

Line 492: hr_api.mandatory_arg_error

488: hr_utility.set_location('Entering:'|| l_proc, 10);
489: --
490: -- Check mandatory parameters have been set
491: --
492: hr_api.mandatory_arg_error
493: (p_api_name => l_proc
494: ,p_argument => 'effective_date'
495: ,p_argument_value => p_effective_date
496: );

Line 498: hr_api.mandatory_arg_error

494: ,p_argument => 'effective_date'
495: ,p_argument_value => p_effective_date
496: );
497: --
498: hr_api.mandatory_arg_error
499: (p_api_name => l_proc
500: ,p_argument => 'dynamic_insert_allowed'
501: ,p_argument_value => p_dynamic_insert_allowed
502: );

Line 515: nvl(per_grs_shd.g_old_rec.dynamic_insert_allowed, hr_api.g_varchar2)<>

511: --
512: hr_utility.set_location(l_proc, 30);
513: --
514: if ((l_api_updating and
515: nvl(per_grs_shd.g_old_rec.dynamic_insert_allowed, hr_api.g_varchar2)<>
516: nvl(p_dynamic_insert_allowed, hr_api.g_varchar2))
517: or (NOT l_api_updating))
518: then
519: hr_utility.set_location(l_proc, 40);

Line 516: nvl(p_dynamic_insert_allowed, hr_api.g_varchar2))

512: hr_utility.set_location(l_proc, 30);
513: --
514: if ((l_api_updating and
515: nvl(per_grs_shd.g_old_rec.dynamic_insert_allowed, hr_api.g_varchar2)<>
516: nvl(p_dynamic_insert_allowed, hr_api.g_varchar2))
517: or (NOT l_api_updating))
518: then
519: hr_utility.set_location(l_proc, 40);
520: --

Line 525: if hr_api.not_exists_in_fnd_lookups

521: --
522: -- Check that the type exists in hr_lookups for the
523: -- lookup type 'YES_NO' with an enabled flag set to 'Y'.
524: --
525: if hr_api.not_exists_in_fnd_lookups
526: (p_effective_date => p_effective_date
527: ,p_lookup_type => 'YES_NO'
528: ,p_lookup_code => p_dynamic_insert_allowed
529: )

Line 583: hr_api.mandatory_arg_error

579: hr_utility.set_location('Entering:'|| l_proc, 10);
580: --
581: -- Perform CAGR_GRADE_STRUCTURE_ID mandatory check
582: --
583: hr_api.mandatory_arg_error
584: (p_api_name => l_proc
585: ,p_argument => 'cagr_grade_structure_id'
586: ,p_argument_value => p_cagr_grade_structure_id
587: );