APPS.PER_ORS_BUS dependencies on HR_API

Line 39: hr_api.mandatory_arg_error

35: --
36: hr_utility.set_location('Entering:'|| l_proc, 10);
37: --
38: --
39: hr_api.mandatory_arg_error
40: (p_api_name => l_proc
41: ,p_argument => 'p_name'
42: ,p_argument_value => p_name
43: );

Line 126: hr_api.mandatory_arg_error

122: --
123: hr_utility.set_location('Entering:'|| l_proc, 10);
124: --
125: --
126: hr_api.mandatory_arg_error
127: (p_api_name => l_proc
128: ,p_argument => 'p_organization_structure_id'
129: ,p_argument_value => p_organization_structure_id
130: );

Line 161: IF hr_api.not_exists_in_hrstanlookups

157: begin
158: hr_utility.set_location('Entering:'|| l_proc, 10);
159: --
160: --
161: IF hr_api.not_exists_in_hrstanlookups
162: (p_effective_date => p_effective_date
163: ,p_lookup_type => 'YES_NO'
164: ,p_lookup_code => p_flag
165: ) THEN

Line 189: hr_api.mandatory_arg_error

185: --
186: hr_utility.set_location('Entering:'|| l_proc, 10);
187: --
188: --
189: hr_api.mandatory_arg_error
190: (p_api_name => l_proc
191: ,p_argument => 'p_organization_structure_id'
192: ,p_argument_value => p_organization_structure_id
193: );

Line 320: hr_api.mandatory_arg_error

316: hr_utility.set_location('Entering:'|| l_proc, 10);
317: --
318: -- Ensure that all the mandatory parameter are not null
319: --
320: hr_api.mandatory_arg_error
321: (p_api_name => l_proc
322: ,p_argument => 'organization_structure_id'
323: ,p_argument_value => p_organization_structure_id
324: );

Line 343: hr_api.set_security_group_id

339: close csr_sec_grp;
340: --
341: -- Set the security_group_id in CLIENT_INFO
342: --
343: hr_api.set_security_group_id
344: (p_security_group_id => l_security_group_id
345: );
346: --
347: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 381: hr_api.mandatory_arg_error

377: hr_utility.set_location('Entering:'|| l_proc, 10);
378: --
379: -- Ensure that all the mandatory parameter are not null
380: --
381: hr_api.mandatory_arg_error
382: (p_api_name => l_proc
383: ,p_argument => 'organization_structure_id'
384: ,p_argument_value => p_organization_structure_id
385: );

Line 387: if ( nvl(per_ors_bus.g_organization_structure_id, hr_api.g_number)

383: ,p_argument => 'organization_structure_id'
384: ,p_argument_value => p_organization_structure_id
385: );
386: --
387: if ( nvl(per_ors_bus.g_organization_structure_id, hr_api.g_number)
388: = p_organization_structure_id) then
389: --
390: -- The legislation code has already been found with a previous
391: -- call to this function. Just return the value in the global

Line 463: nvl(per_ors_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

459: begin
460: hr_utility.set_location('Entering:'||l_proc,10);
461: --
462: if ((p_rec.organization_structure_id is not null) and (
463: nvl(per_ors_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
464: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
465: nvl(per_ors_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
466: nvl(p_rec.attribute1, hr_api.g_varchar2) or
467: nvl(per_ors_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

460: hr_utility.set_location('Entering:'||l_proc,10);
461: --
462: if ((p_rec.organization_structure_id is not null) and (
463: nvl(per_ors_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
464: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
465: nvl(per_ors_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
466: nvl(p_rec.attribute1, hr_api.g_varchar2) or
467: nvl(per_ors_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
468: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 465: nvl(per_ors_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

461: --
462: if ((p_rec.organization_structure_id is not null) and (
463: nvl(per_ors_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
464: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
465: nvl(per_ors_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
466: nvl(p_rec.attribute1, hr_api.g_varchar2) or
467: nvl(per_ors_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
468: nvl(p_rec.attribute2, hr_api.g_varchar2) or
469: nvl(per_ors_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

462: if ((p_rec.organization_structure_id is not null) and (
463: nvl(per_ors_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
464: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
465: nvl(per_ors_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
466: nvl(p_rec.attribute1, hr_api.g_varchar2) or
467: nvl(per_ors_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
468: nvl(p_rec.attribute2, hr_api.g_varchar2) or
469: nvl(per_ors_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
470: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 467: nvl(per_ors_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

463: nvl(per_ors_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
464: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
465: nvl(per_ors_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
466: nvl(p_rec.attribute1, hr_api.g_varchar2) or
467: nvl(per_ors_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
468: nvl(p_rec.attribute2, hr_api.g_varchar2) or
469: nvl(per_ors_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
470: nvl(p_rec.attribute3, hr_api.g_varchar2) or
471: nvl(per_ors_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

464: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
465: nvl(per_ors_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
466: nvl(p_rec.attribute1, hr_api.g_varchar2) or
467: nvl(per_ors_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
468: nvl(p_rec.attribute2, hr_api.g_varchar2) or
469: nvl(per_ors_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
470: nvl(p_rec.attribute3, hr_api.g_varchar2) or
471: nvl(per_ors_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
472: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 469: nvl(per_ors_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

465: nvl(per_ors_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
466: nvl(p_rec.attribute1, hr_api.g_varchar2) or
467: nvl(per_ors_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
468: nvl(p_rec.attribute2, hr_api.g_varchar2) or
469: nvl(per_ors_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
470: nvl(p_rec.attribute3, hr_api.g_varchar2) or
471: nvl(per_ors_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
472: nvl(p_rec.attribute4, hr_api.g_varchar2) or
473: nvl(per_ors_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

466: nvl(p_rec.attribute1, hr_api.g_varchar2) or
467: nvl(per_ors_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
468: nvl(p_rec.attribute2, hr_api.g_varchar2) or
469: nvl(per_ors_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
470: nvl(p_rec.attribute3, hr_api.g_varchar2) or
471: nvl(per_ors_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
472: nvl(p_rec.attribute4, hr_api.g_varchar2) or
473: nvl(per_ors_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
474: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 471: nvl(per_ors_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

467: nvl(per_ors_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
468: nvl(p_rec.attribute2, hr_api.g_varchar2) or
469: nvl(per_ors_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
470: nvl(p_rec.attribute3, hr_api.g_varchar2) or
471: nvl(per_ors_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
472: nvl(p_rec.attribute4, hr_api.g_varchar2) or
473: nvl(per_ors_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
474: nvl(p_rec.attribute5, hr_api.g_varchar2) or
475: nvl(per_ors_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

468: nvl(p_rec.attribute2, hr_api.g_varchar2) or
469: nvl(per_ors_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
470: nvl(p_rec.attribute3, hr_api.g_varchar2) or
471: nvl(per_ors_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
472: nvl(p_rec.attribute4, hr_api.g_varchar2) or
473: nvl(per_ors_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
474: nvl(p_rec.attribute5, hr_api.g_varchar2) or
475: nvl(per_ors_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
476: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 473: nvl(per_ors_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

469: nvl(per_ors_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
470: nvl(p_rec.attribute3, hr_api.g_varchar2) or
471: nvl(per_ors_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
472: nvl(p_rec.attribute4, hr_api.g_varchar2) or
473: nvl(per_ors_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
474: nvl(p_rec.attribute5, hr_api.g_varchar2) or
475: nvl(per_ors_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
476: nvl(p_rec.attribute6, hr_api.g_varchar2) or
477: nvl(per_ors_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

470: nvl(p_rec.attribute3, hr_api.g_varchar2) or
471: nvl(per_ors_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
472: nvl(p_rec.attribute4, hr_api.g_varchar2) or
473: nvl(per_ors_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
474: nvl(p_rec.attribute5, hr_api.g_varchar2) or
475: nvl(per_ors_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
476: nvl(p_rec.attribute6, hr_api.g_varchar2) or
477: nvl(per_ors_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
478: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 475: nvl(per_ors_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

471: nvl(per_ors_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
472: nvl(p_rec.attribute4, hr_api.g_varchar2) or
473: nvl(per_ors_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
474: nvl(p_rec.attribute5, hr_api.g_varchar2) or
475: nvl(per_ors_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
476: nvl(p_rec.attribute6, hr_api.g_varchar2) or
477: nvl(per_ors_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
478: nvl(p_rec.attribute7, hr_api.g_varchar2) or
479: nvl(per_ors_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

472: nvl(p_rec.attribute4, hr_api.g_varchar2) or
473: nvl(per_ors_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
474: nvl(p_rec.attribute5, hr_api.g_varchar2) or
475: nvl(per_ors_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
476: nvl(p_rec.attribute6, hr_api.g_varchar2) or
477: nvl(per_ors_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
478: nvl(p_rec.attribute7, hr_api.g_varchar2) or
479: nvl(per_ors_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
480: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 477: nvl(per_ors_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

473: nvl(per_ors_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
474: nvl(p_rec.attribute5, hr_api.g_varchar2) or
475: nvl(per_ors_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
476: nvl(p_rec.attribute6, hr_api.g_varchar2) or
477: nvl(per_ors_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
478: nvl(p_rec.attribute7, hr_api.g_varchar2) or
479: nvl(per_ors_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
480: nvl(p_rec.attribute8, hr_api.g_varchar2) or
481: nvl(per_ors_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

474: nvl(p_rec.attribute5, hr_api.g_varchar2) or
475: nvl(per_ors_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
476: nvl(p_rec.attribute6, hr_api.g_varchar2) or
477: nvl(per_ors_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
478: nvl(p_rec.attribute7, hr_api.g_varchar2) or
479: nvl(per_ors_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
480: nvl(p_rec.attribute8, hr_api.g_varchar2) or
481: nvl(per_ors_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
482: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 479: nvl(per_ors_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

475: nvl(per_ors_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
476: nvl(p_rec.attribute6, hr_api.g_varchar2) or
477: nvl(per_ors_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
478: nvl(p_rec.attribute7, hr_api.g_varchar2) or
479: nvl(per_ors_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
480: nvl(p_rec.attribute8, hr_api.g_varchar2) or
481: nvl(per_ors_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
482: nvl(p_rec.attribute9, hr_api.g_varchar2) or
483: nvl(per_ors_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

476: nvl(p_rec.attribute6, hr_api.g_varchar2) or
477: nvl(per_ors_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
478: nvl(p_rec.attribute7, hr_api.g_varchar2) or
479: nvl(per_ors_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
480: nvl(p_rec.attribute8, hr_api.g_varchar2) or
481: nvl(per_ors_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
482: nvl(p_rec.attribute9, hr_api.g_varchar2) or
483: nvl(per_ors_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
484: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 481: nvl(per_ors_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

477: nvl(per_ors_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
478: nvl(p_rec.attribute7, hr_api.g_varchar2) or
479: nvl(per_ors_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
480: nvl(p_rec.attribute8, hr_api.g_varchar2) or
481: nvl(per_ors_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
482: nvl(p_rec.attribute9, hr_api.g_varchar2) or
483: nvl(per_ors_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
484: nvl(p_rec.attribute10, hr_api.g_varchar2) or
485: nvl(per_ors_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

478: nvl(p_rec.attribute7, hr_api.g_varchar2) or
479: nvl(per_ors_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
480: nvl(p_rec.attribute8, hr_api.g_varchar2) or
481: nvl(per_ors_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
482: nvl(p_rec.attribute9, hr_api.g_varchar2) or
483: nvl(per_ors_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
484: nvl(p_rec.attribute10, hr_api.g_varchar2) or
485: nvl(per_ors_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
486: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 483: nvl(per_ors_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

479: nvl(per_ors_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
480: nvl(p_rec.attribute8, hr_api.g_varchar2) or
481: nvl(per_ors_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
482: nvl(p_rec.attribute9, hr_api.g_varchar2) or
483: nvl(per_ors_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
484: nvl(p_rec.attribute10, hr_api.g_varchar2) or
485: nvl(per_ors_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
486: nvl(p_rec.attribute11, hr_api.g_varchar2) or
487: nvl(per_ors_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

480: nvl(p_rec.attribute8, hr_api.g_varchar2) or
481: nvl(per_ors_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
482: nvl(p_rec.attribute9, hr_api.g_varchar2) or
483: nvl(per_ors_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
484: nvl(p_rec.attribute10, hr_api.g_varchar2) or
485: nvl(per_ors_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
486: nvl(p_rec.attribute11, hr_api.g_varchar2) or
487: nvl(per_ors_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
488: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 485: nvl(per_ors_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

481: nvl(per_ors_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
482: nvl(p_rec.attribute9, hr_api.g_varchar2) or
483: nvl(per_ors_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
484: nvl(p_rec.attribute10, hr_api.g_varchar2) or
485: nvl(per_ors_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
486: nvl(p_rec.attribute11, hr_api.g_varchar2) or
487: nvl(per_ors_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
488: nvl(p_rec.attribute12, hr_api.g_varchar2) or
489: nvl(per_ors_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

482: nvl(p_rec.attribute9, hr_api.g_varchar2) or
483: nvl(per_ors_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
484: nvl(p_rec.attribute10, hr_api.g_varchar2) or
485: nvl(per_ors_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
486: nvl(p_rec.attribute11, hr_api.g_varchar2) or
487: nvl(per_ors_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
488: nvl(p_rec.attribute12, hr_api.g_varchar2) or
489: nvl(per_ors_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
490: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 487: nvl(per_ors_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

483: nvl(per_ors_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
484: nvl(p_rec.attribute10, hr_api.g_varchar2) or
485: nvl(per_ors_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
486: nvl(p_rec.attribute11, hr_api.g_varchar2) or
487: nvl(per_ors_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
488: nvl(p_rec.attribute12, hr_api.g_varchar2) or
489: nvl(per_ors_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
490: nvl(p_rec.attribute13, hr_api.g_varchar2) or
491: nvl(per_ors_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

484: nvl(p_rec.attribute10, hr_api.g_varchar2) or
485: nvl(per_ors_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
486: nvl(p_rec.attribute11, hr_api.g_varchar2) or
487: nvl(per_ors_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
488: nvl(p_rec.attribute12, hr_api.g_varchar2) or
489: nvl(per_ors_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
490: nvl(p_rec.attribute13, hr_api.g_varchar2) or
491: nvl(per_ors_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
492: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 489: nvl(per_ors_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

485: nvl(per_ors_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
486: nvl(p_rec.attribute11, hr_api.g_varchar2) or
487: nvl(per_ors_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
488: nvl(p_rec.attribute12, hr_api.g_varchar2) or
489: nvl(per_ors_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
490: nvl(p_rec.attribute13, hr_api.g_varchar2) or
491: nvl(per_ors_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
492: nvl(p_rec.attribute14, hr_api.g_varchar2) or
493: nvl(per_ors_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

486: nvl(p_rec.attribute11, hr_api.g_varchar2) or
487: nvl(per_ors_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
488: nvl(p_rec.attribute12, hr_api.g_varchar2) or
489: nvl(per_ors_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
490: nvl(p_rec.attribute13, hr_api.g_varchar2) or
491: nvl(per_ors_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
492: nvl(p_rec.attribute14, hr_api.g_varchar2) or
493: nvl(per_ors_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
494: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 491: nvl(per_ors_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

487: nvl(per_ors_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
488: nvl(p_rec.attribute12, hr_api.g_varchar2) or
489: nvl(per_ors_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
490: nvl(p_rec.attribute13, hr_api.g_varchar2) or
491: nvl(per_ors_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
492: nvl(p_rec.attribute14, hr_api.g_varchar2) or
493: nvl(per_ors_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
494: nvl(p_rec.attribute15, hr_api.g_varchar2) or
495: nvl(per_ors_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

488: nvl(p_rec.attribute12, hr_api.g_varchar2) or
489: nvl(per_ors_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
490: nvl(p_rec.attribute13, hr_api.g_varchar2) or
491: nvl(per_ors_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
492: nvl(p_rec.attribute14, hr_api.g_varchar2) or
493: nvl(per_ors_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
494: nvl(p_rec.attribute15, hr_api.g_varchar2) or
495: nvl(per_ors_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
496: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 493: nvl(per_ors_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

489: nvl(per_ors_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
490: nvl(p_rec.attribute13, hr_api.g_varchar2) or
491: nvl(per_ors_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
492: nvl(p_rec.attribute14, hr_api.g_varchar2) or
493: nvl(per_ors_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
494: nvl(p_rec.attribute15, hr_api.g_varchar2) or
495: nvl(per_ors_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
496: nvl(p_rec.attribute16, hr_api.g_varchar2) or
497: nvl(per_ors_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

490: nvl(p_rec.attribute13, hr_api.g_varchar2) or
491: nvl(per_ors_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
492: nvl(p_rec.attribute14, hr_api.g_varchar2) or
493: nvl(per_ors_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
494: nvl(p_rec.attribute15, hr_api.g_varchar2) or
495: nvl(per_ors_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
496: nvl(p_rec.attribute16, hr_api.g_varchar2) or
497: nvl(per_ors_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
498: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 495: nvl(per_ors_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

491: nvl(per_ors_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
492: nvl(p_rec.attribute14, hr_api.g_varchar2) or
493: nvl(per_ors_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
494: nvl(p_rec.attribute15, hr_api.g_varchar2) or
495: nvl(per_ors_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
496: nvl(p_rec.attribute16, hr_api.g_varchar2) or
497: nvl(per_ors_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
498: nvl(p_rec.attribute17, hr_api.g_varchar2) or
499: nvl(per_ors_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

492: nvl(p_rec.attribute14, hr_api.g_varchar2) or
493: nvl(per_ors_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
494: nvl(p_rec.attribute15, hr_api.g_varchar2) or
495: nvl(per_ors_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
496: nvl(p_rec.attribute16, hr_api.g_varchar2) or
497: nvl(per_ors_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
498: nvl(p_rec.attribute17, hr_api.g_varchar2) or
499: nvl(per_ors_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
500: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 497: nvl(per_ors_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

493: nvl(per_ors_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
494: nvl(p_rec.attribute15, hr_api.g_varchar2) or
495: nvl(per_ors_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
496: nvl(p_rec.attribute16, hr_api.g_varchar2) or
497: nvl(per_ors_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
498: nvl(p_rec.attribute17, hr_api.g_varchar2) or
499: nvl(per_ors_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
500: nvl(p_rec.attribute18, hr_api.g_varchar2) or
501: nvl(per_ors_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

494: nvl(p_rec.attribute15, hr_api.g_varchar2) or
495: nvl(per_ors_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
496: nvl(p_rec.attribute16, hr_api.g_varchar2) or
497: nvl(per_ors_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
498: nvl(p_rec.attribute17, hr_api.g_varchar2) or
499: nvl(per_ors_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
500: nvl(p_rec.attribute18, hr_api.g_varchar2) or
501: nvl(per_ors_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
502: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 499: nvl(per_ors_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

495: nvl(per_ors_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
496: nvl(p_rec.attribute16, hr_api.g_varchar2) or
497: nvl(per_ors_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
498: nvl(p_rec.attribute17, hr_api.g_varchar2) or
499: nvl(per_ors_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
500: nvl(p_rec.attribute18, hr_api.g_varchar2) or
501: nvl(per_ors_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
502: nvl(p_rec.attribute19, hr_api.g_varchar2) or
503: nvl(per_ors_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

496: nvl(p_rec.attribute16, hr_api.g_varchar2) or
497: nvl(per_ors_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
498: nvl(p_rec.attribute17, hr_api.g_varchar2) or
499: nvl(per_ors_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
500: nvl(p_rec.attribute18, hr_api.g_varchar2) or
501: nvl(per_ors_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
502: nvl(p_rec.attribute19, hr_api.g_varchar2) or
503: nvl(per_ors_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
504: nvl(p_rec.attribute20, hr_api.g_varchar2) ))

Line 501: nvl(per_ors_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

497: nvl(per_ors_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
498: nvl(p_rec.attribute17, hr_api.g_varchar2) or
499: nvl(per_ors_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
500: nvl(p_rec.attribute18, hr_api.g_varchar2) or
501: nvl(per_ors_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
502: nvl(p_rec.attribute19, hr_api.g_varchar2) or
503: nvl(per_ors_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
504: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
505: or (p_rec.organization_structure_id is null) then

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

498: nvl(p_rec.attribute17, hr_api.g_varchar2) or
499: nvl(per_ors_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
500: nvl(p_rec.attribute18, hr_api.g_varchar2) or
501: nvl(per_ors_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
502: nvl(p_rec.attribute19, hr_api.g_varchar2) or
503: nvl(per_ors_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
504: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
505: or (p_rec.organization_structure_id is null) then
506: --

Line 503: nvl(per_ors_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

499: nvl(per_ors_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
500: nvl(p_rec.attribute18, hr_api.g_varchar2) or
501: nvl(per_ors_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
502: nvl(p_rec.attribute19, hr_api.g_varchar2) or
503: nvl(per_ors_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
504: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
505: or (p_rec.organization_structure_id is null) then
506: --
507: -- Only execute the validation if absolutely necessary:

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

500: nvl(p_rec.attribute18, hr_api.g_varchar2) or
501: nvl(per_ors_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
502: nvl(p_rec.attribute19, hr_api.g_varchar2) or
503: nvl(per_ors_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
504: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
505: or (p_rec.organization_structure_id is null) then
506: --
507: -- Only execute the validation if absolutely necessary:
508: -- a) During update, the structure column value or any

Line 615: hr_api.argument_changed_error

611: END IF;
612: --
613: EXCEPTION
614: WHEN l_error THEN
615: hr_api.argument_changed_error
616: (p_api_name => l_proc
617: ,p_argument => l_argument);
618: WHEN OTHERS THEN
619: RAISE;

Line 638: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

634: --
635: -- Call all supporting business operations
636: --
637: if p_rec.business_group_id IS NOT NULL then
638: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
639: end if;
640:
641: chk_org_name
642: (p_organization_structure_id => p_rec.organization_structure_id

Line 684: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

680: --
681: -- Call all supporting business operations
682: --
683: if p_rec.business_group_id IS NOT NULL then
684: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
685: end if;
686:
687: chk_y_or_n
688: (p_effective_date => p_effective_date