[Home] [Help]
46: end if;
47: --
48: -- Ensure that all the mandatory parameter are not null
49: --
50: hr_api.mandatory_arg_error(p_api_name => l_proc,
51: p_argument => 'assignment_id',
52: p_argument_value => p_assignment_id);
53: --
54: open csr_sec_grp;
68: close csr_sec_grp;
69: --
70: -- Set the security_group_id in CLIENT_INFO
71: --
72: hr_api.set_security_group_id
73: (p_security_group_id => l_security_group_id
74: );
75: end if;
76: --
75: end if;
76: --
77: -- Set the sessions legislation context in HR_SESSION_DATA
78: --
79: hr_api.set_legislation_context(l_legislation_code);
80: --
81: --
82: if g_debug then
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
139: if g_debug then
140: hr_utility.set_location(l_proc, 6);
141: end if;
142: --
143: if nvl(p_rec.business_group_id, hr_api.g_number) <>
144: nvl(per_asg_shd.g_old_rec.business_group_id, hr_api.g_number) then
145: hr_api.argument_changed_error
146: (p_api_name => l_proc
147: ,p_argument => 'BUSINESS_GROUP_ID'
140: hr_utility.set_location(l_proc, 6);
141: end if;
142: --
143: if nvl(p_rec.business_group_id, hr_api.g_number) <>
144: nvl(per_asg_shd.g_old_rec.business_group_id, hr_api.g_number) then
145: hr_api.argument_changed_error
146: (p_api_name => l_proc
147: ,p_argument => 'BUSINESS_GROUP_ID'
148: ,p_base_table => per_asg_shd.g_tab_nam
141: end if;
142: --
143: if nvl(p_rec.business_group_id, hr_api.g_number) <>
144: nvl(per_asg_shd.g_old_rec.business_group_id, hr_api.g_number) then
145: hr_api.argument_changed_error
146: (p_api_name => l_proc
147: ,p_argument => 'BUSINESS_GROUP_ID'
148: ,p_base_table => per_asg_shd.g_tab_nam
149: );
152: hr_utility.set_location(l_proc, 7);
153: end if;
154: --
155: if p_rec.assignment_id <> per_asg_shd.g_old_rec.assignment_id then
156: hr_api.argument_changed_error
157: (p_api_name => l_proc
158: ,p_argument => 'ASSIGNMENT_ID'
159: ,p_base_table => per_asg_shd.g_tab_nam
160: );
163: hr_utility.set_location(l_proc, 8);
164: end if;
165: --
166: if p_rec.person_id <> per_asg_shd.g_old_rec.person_id then
167: hr_api.argument_changed_error
168: (p_api_name => l_proc
169: ,p_argument => 'PERSON_ID'
170: ,p_base_table => per_asg_shd.g_tab_nam
171: );
174: hr_utility.set_location(l_proc, 9);
175: end if;
176: --
177: if p_rec.assignment_sequence <> per_asg_shd.g_old_rec.assignment_sequence then
178: hr_api.argument_changed_error
179: (p_api_name => l_proc
180: ,p_argument => 'ASSIGNMENT_SEQUENCE'
181: ,p_base_table => per_asg_shd.g_tab_nam
182: );
189: -- Bug fix 3101091 starts. Commenting out the check that makes vendor_id
190: -- non updatable
191: /* if p_rec.vendor_id <> per_asg_shd.g_old_rec.vendor_id then
192: --
193: hr_api.argument_changed_error
194: (p_api_name => l_proc
195: ,p_argument => 'VENDOR_ID'
196: ,p_base_table => per_asg_shd.g_tab_nam);
197: --
460: end if;
461: --
462: -- Ensure that the p_datetrack_mode argument is not null
463: --
464: hr_api.mandatory_arg_error
465: (p_api_name => l_proc,
466: p_argument => 'datetrack_mode',
467: p_argument_value => p_datetrack_mode);
468: --
474: --
475: --
476: -- Ensure the arguments are not null
477: --
478: hr_api.mandatory_arg_error
479: (p_api_name => l_proc,
480: p_argument => 'validation_start_date',
481: p_argument_value => p_validation_start_date);
482: --
479: (p_api_name => l_proc,
480: p_argument => 'validation_start_date',
481: p_argument_value => p_validation_start_date);
482: --
483: hr_api.mandatory_arg_error
484: (p_api_name => l_proc,
485: p_argument => 'validation_end_date',
486: p_argument_value => p_validation_end_date);
487: --
484: (p_api_name => l_proc,
485: p_argument => 'validation_end_date',
486: p_argument_value => p_validation_end_date);
487: --
488: hr_api.mandatory_arg_error
489: (p_api_name => l_proc,
490: p_argument => 'assignment_id',
491: p_argument_value => p_assignment_id);
492: --
625: --
626: -- {End Of Comments}
627: -- ----------------------------------------------------------------------------
628: Procedure dt_update_validate
629: (p_payroll_id in number default hr_api.g_number,
630: p_person_id in number default hr_api.g_number,
631: p_datetrack_mode in varchar2,
632: p_validation_start_date in date,
633: p_validation_end_date in date) Is
626: -- {End Of Comments}
627: -- ----------------------------------------------------------------------------
628: Procedure dt_update_validate
629: (p_payroll_id in number default hr_api.g_number,
630: p_person_id in number default hr_api.g_number,
631: p_datetrack_mode in varchar2,
632: p_validation_start_date in date,
633: p_validation_end_date in date) Is
634: --
642: end if;
643: --
644: -- Ensure that the p_datetrack_mode argument is not null
645: --
646: hr_api.mandatory_arg_error
647: (p_api_name => l_proc,
648: p_argument => 'datetrack_mode',
649: p_argument_value => p_datetrack_mode);
650: --
653: --
654: --
655: -- Ensure the arguments are not null
656: --
657: hr_api.mandatory_arg_error
658: (p_api_name => l_proc,
659: p_argument => 'validation_start_date',
660: p_argument_value => p_validation_start_date);
661: --
658: (p_api_name => l_proc,
659: p_argument => 'validation_start_date',
660: p_argument_value => p_validation_start_date);
661: --
662: hr_api.mandatory_arg_error
663: (p_api_name => l_proc,
664: p_argument => 'validation_end_date',
665: p_argument_value => p_validation_end_date);
666: --
665: p_argument_value => p_validation_end_date);
666: --
667: -- Start of fix 2535030
668: /*
669: If ((nvl(p_payroll_id, hr_api.g_number) <> hr_api.g_number) and
670: NOT (dt_api.check_min_max_dates
671: (p_base_table_name => 'pay_all_payrolls_f', -- bug fix 2679167
672: p_base_key_column => 'payroll_id',
673: p_base_key_value => p_payroll_id,
678: End If;
679: */
680: -- End of fix 2535030
681:
682: If ((nvl(p_person_id, hr_api.g_number) <> hr_api.g_number) and
683: NOT (dt_api.check_min_max_dates
684: (p_base_table_name => 'per_all_people_f',
685: p_base_key_column => 'person_id',
686: p_base_key_value => p_person_id,
799: --
800: --
801: If ( (p_rec.assignment_id is not null)
802: and
803: ( (nvl(per_asg_shd.g_old_rec.ass_attribute_category, hr_api.g_varchar2) <>
804: nvl(p_rec.ass_attribute_category, hr_api.g_varchar2) or
805: nvl(per_asg_shd.g_old_rec.ass_attribute1, hr_api.g_varchar2) <>
806: nvl(p_rec.ass_attribute1, hr_api.g_varchar2) or
807: nvl(per_asg_shd.g_old_rec.ass_attribute2, hr_api.g_varchar2) <>
800: --
801: If ( (p_rec.assignment_id is not null)
802: and
803: ( (nvl(per_asg_shd.g_old_rec.ass_attribute_category, hr_api.g_varchar2) <>
804: nvl(p_rec.ass_attribute_category, hr_api.g_varchar2) or
805: nvl(per_asg_shd.g_old_rec.ass_attribute1, hr_api.g_varchar2) <>
806: nvl(p_rec.ass_attribute1, hr_api.g_varchar2) or
807: nvl(per_asg_shd.g_old_rec.ass_attribute2, hr_api.g_varchar2) <>
808: nvl(p_rec.ass_attribute2, hr_api.g_varchar2) or
801: If ( (p_rec.assignment_id is not null)
802: and
803: ( (nvl(per_asg_shd.g_old_rec.ass_attribute_category, hr_api.g_varchar2) <>
804: nvl(p_rec.ass_attribute_category, hr_api.g_varchar2) or
805: nvl(per_asg_shd.g_old_rec.ass_attribute1, hr_api.g_varchar2) <>
806: nvl(p_rec.ass_attribute1, hr_api.g_varchar2) or
807: nvl(per_asg_shd.g_old_rec.ass_attribute2, hr_api.g_varchar2) <>
808: nvl(p_rec.ass_attribute2, hr_api.g_varchar2) or
809: nvl(per_asg_shd.g_old_rec.ass_attribute3, hr_api.g_varchar2) <>
802: and
803: ( (nvl(per_asg_shd.g_old_rec.ass_attribute_category, hr_api.g_varchar2) <>
804: nvl(p_rec.ass_attribute_category, hr_api.g_varchar2) or
805: nvl(per_asg_shd.g_old_rec.ass_attribute1, hr_api.g_varchar2) <>
806: nvl(p_rec.ass_attribute1, hr_api.g_varchar2) or
807: nvl(per_asg_shd.g_old_rec.ass_attribute2, hr_api.g_varchar2) <>
808: nvl(p_rec.ass_attribute2, hr_api.g_varchar2) or
809: nvl(per_asg_shd.g_old_rec.ass_attribute3, hr_api.g_varchar2) <>
810: nvl(p_rec.ass_attribute3, hr_api.g_varchar2) or
803: ( (nvl(per_asg_shd.g_old_rec.ass_attribute_category, hr_api.g_varchar2) <>
804: nvl(p_rec.ass_attribute_category, hr_api.g_varchar2) or
805: nvl(per_asg_shd.g_old_rec.ass_attribute1, hr_api.g_varchar2) <>
806: nvl(p_rec.ass_attribute1, hr_api.g_varchar2) or
807: nvl(per_asg_shd.g_old_rec.ass_attribute2, hr_api.g_varchar2) <>
808: nvl(p_rec.ass_attribute2, hr_api.g_varchar2) or
809: nvl(per_asg_shd.g_old_rec.ass_attribute3, hr_api.g_varchar2) <>
810: nvl(p_rec.ass_attribute3, hr_api.g_varchar2) or
811: nvl(per_asg_shd.g_old_rec.ass_attribute4, hr_api.g_varchar2) <>
804: nvl(p_rec.ass_attribute_category, hr_api.g_varchar2) or
805: nvl(per_asg_shd.g_old_rec.ass_attribute1, hr_api.g_varchar2) <>
806: nvl(p_rec.ass_attribute1, hr_api.g_varchar2) or
807: nvl(per_asg_shd.g_old_rec.ass_attribute2, hr_api.g_varchar2) <>
808: nvl(p_rec.ass_attribute2, hr_api.g_varchar2) or
809: nvl(per_asg_shd.g_old_rec.ass_attribute3, hr_api.g_varchar2) <>
810: nvl(p_rec.ass_attribute3, hr_api.g_varchar2) or
811: nvl(per_asg_shd.g_old_rec.ass_attribute4, hr_api.g_varchar2) <>
812: nvl(p_rec.ass_attribute4, hr_api.g_varchar2) or
805: nvl(per_asg_shd.g_old_rec.ass_attribute1, hr_api.g_varchar2) <>
806: nvl(p_rec.ass_attribute1, hr_api.g_varchar2) or
807: nvl(per_asg_shd.g_old_rec.ass_attribute2, hr_api.g_varchar2) <>
808: nvl(p_rec.ass_attribute2, hr_api.g_varchar2) or
809: nvl(per_asg_shd.g_old_rec.ass_attribute3, hr_api.g_varchar2) <>
810: nvl(p_rec.ass_attribute3, hr_api.g_varchar2) or
811: nvl(per_asg_shd.g_old_rec.ass_attribute4, hr_api.g_varchar2) <>
812: nvl(p_rec.ass_attribute4, hr_api.g_varchar2) or
813: nvl(per_asg_shd.g_old_rec.ass_attribute5, hr_api.g_varchar2) <>
806: nvl(p_rec.ass_attribute1, hr_api.g_varchar2) or
807: nvl(per_asg_shd.g_old_rec.ass_attribute2, hr_api.g_varchar2) <>
808: nvl(p_rec.ass_attribute2, hr_api.g_varchar2) or
809: nvl(per_asg_shd.g_old_rec.ass_attribute3, hr_api.g_varchar2) <>
810: nvl(p_rec.ass_attribute3, hr_api.g_varchar2) or
811: nvl(per_asg_shd.g_old_rec.ass_attribute4, hr_api.g_varchar2) <>
812: nvl(p_rec.ass_attribute4, hr_api.g_varchar2) or
813: nvl(per_asg_shd.g_old_rec.ass_attribute5, hr_api.g_varchar2) <>
814: nvl(p_rec.ass_attribute5, hr_api.g_varchar2) or
807: nvl(per_asg_shd.g_old_rec.ass_attribute2, hr_api.g_varchar2) <>
808: nvl(p_rec.ass_attribute2, hr_api.g_varchar2) or
809: nvl(per_asg_shd.g_old_rec.ass_attribute3, hr_api.g_varchar2) <>
810: nvl(p_rec.ass_attribute3, hr_api.g_varchar2) or
811: nvl(per_asg_shd.g_old_rec.ass_attribute4, hr_api.g_varchar2) <>
812: nvl(p_rec.ass_attribute4, hr_api.g_varchar2) or
813: nvl(per_asg_shd.g_old_rec.ass_attribute5, hr_api.g_varchar2) <>
814: nvl(p_rec.ass_attribute5, hr_api.g_varchar2) or
815: nvl(per_asg_shd.g_old_rec.ass_attribute6, hr_api.g_varchar2) <>
808: nvl(p_rec.ass_attribute2, hr_api.g_varchar2) or
809: nvl(per_asg_shd.g_old_rec.ass_attribute3, hr_api.g_varchar2) <>
810: nvl(p_rec.ass_attribute3, hr_api.g_varchar2) or
811: nvl(per_asg_shd.g_old_rec.ass_attribute4, hr_api.g_varchar2) <>
812: nvl(p_rec.ass_attribute4, hr_api.g_varchar2) or
813: nvl(per_asg_shd.g_old_rec.ass_attribute5, hr_api.g_varchar2) <>
814: nvl(p_rec.ass_attribute5, hr_api.g_varchar2) or
815: nvl(per_asg_shd.g_old_rec.ass_attribute6, hr_api.g_varchar2) <>
816: nvl(p_rec.ass_attribute6, hr_api.g_varchar2) or
809: nvl(per_asg_shd.g_old_rec.ass_attribute3, hr_api.g_varchar2) <>
810: nvl(p_rec.ass_attribute3, hr_api.g_varchar2) or
811: nvl(per_asg_shd.g_old_rec.ass_attribute4, hr_api.g_varchar2) <>
812: nvl(p_rec.ass_attribute4, hr_api.g_varchar2) or
813: nvl(per_asg_shd.g_old_rec.ass_attribute5, hr_api.g_varchar2) <>
814: nvl(p_rec.ass_attribute5, hr_api.g_varchar2) or
815: nvl(per_asg_shd.g_old_rec.ass_attribute6, hr_api.g_varchar2) <>
816: nvl(p_rec.ass_attribute6, hr_api.g_varchar2) or
817: nvl(per_asg_shd.g_old_rec.ass_attribute7, hr_api.g_varchar2) <>
810: nvl(p_rec.ass_attribute3, hr_api.g_varchar2) or
811: nvl(per_asg_shd.g_old_rec.ass_attribute4, hr_api.g_varchar2) <>
812: nvl(p_rec.ass_attribute4, hr_api.g_varchar2) or
813: nvl(per_asg_shd.g_old_rec.ass_attribute5, hr_api.g_varchar2) <>
814: nvl(p_rec.ass_attribute5, hr_api.g_varchar2) or
815: nvl(per_asg_shd.g_old_rec.ass_attribute6, hr_api.g_varchar2) <>
816: nvl(p_rec.ass_attribute6, hr_api.g_varchar2) or
817: nvl(per_asg_shd.g_old_rec.ass_attribute7, hr_api.g_varchar2) <>
818: nvl(p_rec.ass_attribute7, hr_api.g_varchar2) or
811: nvl(per_asg_shd.g_old_rec.ass_attribute4, hr_api.g_varchar2) <>
812: nvl(p_rec.ass_attribute4, hr_api.g_varchar2) or
813: nvl(per_asg_shd.g_old_rec.ass_attribute5, hr_api.g_varchar2) <>
814: nvl(p_rec.ass_attribute5, hr_api.g_varchar2) or
815: nvl(per_asg_shd.g_old_rec.ass_attribute6, hr_api.g_varchar2) <>
816: nvl(p_rec.ass_attribute6, hr_api.g_varchar2) or
817: nvl(per_asg_shd.g_old_rec.ass_attribute7, hr_api.g_varchar2) <>
818: nvl(p_rec.ass_attribute7, hr_api.g_varchar2) or
819: nvl(per_asg_shd.g_old_rec.ass_attribute8, hr_api.g_varchar2) <>
812: nvl(p_rec.ass_attribute4, hr_api.g_varchar2) or
813: nvl(per_asg_shd.g_old_rec.ass_attribute5, hr_api.g_varchar2) <>
814: nvl(p_rec.ass_attribute5, hr_api.g_varchar2) or
815: nvl(per_asg_shd.g_old_rec.ass_attribute6, hr_api.g_varchar2) <>
816: nvl(p_rec.ass_attribute6, hr_api.g_varchar2) or
817: nvl(per_asg_shd.g_old_rec.ass_attribute7, hr_api.g_varchar2) <>
818: nvl(p_rec.ass_attribute7, hr_api.g_varchar2) or
819: nvl(per_asg_shd.g_old_rec.ass_attribute8, hr_api.g_varchar2) <>
820: nvl(p_rec.ass_attribute8, hr_api.g_varchar2) or
813: nvl(per_asg_shd.g_old_rec.ass_attribute5, hr_api.g_varchar2) <>
814: nvl(p_rec.ass_attribute5, hr_api.g_varchar2) or
815: nvl(per_asg_shd.g_old_rec.ass_attribute6, hr_api.g_varchar2) <>
816: nvl(p_rec.ass_attribute6, hr_api.g_varchar2) or
817: nvl(per_asg_shd.g_old_rec.ass_attribute7, hr_api.g_varchar2) <>
818: nvl(p_rec.ass_attribute7, hr_api.g_varchar2) or
819: nvl(per_asg_shd.g_old_rec.ass_attribute8, hr_api.g_varchar2) <>
820: nvl(p_rec.ass_attribute8, hr_api.g_varchar2) or
821: nvl(per_asg_shd.g_old_rec.ass_attribute9, hr_api.g_varchar2) <>
814: nvl(p_rec.ass_attribute5, hr_api.g_varchar2) or
815: nvl(per_asg_shd.g_old_rec.ass_attribute6, hr_api.g_varchar2) <>
816: nvl(p_rec.ass_attribute6, hr_api.g_varchar2) or
817: nvl(per_asg_shd.g_old_rec.ass_attribute7, hr_api.g_varchar2) <>
818: nvl(p_rec.ass_attribute7, hr_api.g_varchar2) or
819: nvl(per_asg_shd.g_old_rec.ass_attribute8, hr_api.g_varchar2) <>
820: nvl(p_rec.ass_attribute8, hr_api.g_varchar2) or
821: nvl(per_asg_shd.g_old_rec.ass_attribute9, hr_api.g_varchar2) <>
822: nvl(p_rec.ass_attribute9, hr_api.g_varchar2) or
815: nvl(per_asg_shd.g_old_rec.ass_attribute6, hr_api.g_varchar2) <>
816: nvl(p_rec.ass_attribute6, hr_api.g_varchar2) or
817: nvl(per_asg_shd.g_old_rec.ass_attribute7, hr_api.g_varchar2) <>
818: nvl(p_rec.ass_attribute7, hr_api.g_varchar2) or
819: nvl(per_asg_shd.g_old_rec.ass_attribute8, hr_api.g_varchar2) <>
820: nvl(p_rec.ass_attribute8, hr_api.g_varchar2) or
821: nvl(per_asg_shd.g_old_rec.ass_attribute9, hr_api.g_varchar2) <>
822: nvl(p_rec.ass_attribute9, hr_api.g_varchar2) or
823: nvl(per_asg_shd.g_old_rec.ass_attribute10, hr_api.g_varchar2) <>
816: nvl(p_rec.ass_attribute6, hr_api.g_varchar2) or
817: nvl(per_asg_shd.g_old_rec.ass_attribute7, hr_api.g_varchar2) <>
818: nvl(p_rec.ass_attribute7, hr_api.g_varchar2) or
819: nvl(per_asg_shd.g_old_rec.ass_attribute8, hr_api.g_varchar2) <>
820: nvl(p_rec.ass_attribute8, hr_api.g_varchar2) or
821: nvl(per_asg_shd.g_old_rec.ass_attribute9, hr_api.g_varchar2) <>
822: nvl(p_rec.ass_attribute9, hr_api.g_varchar2) or
823: nvl(per_asg_shd.g_old_rec.ass_attribute10, hr_api.g_varchar2) <>
824: nvl(p_rec.ass_attribute10, hr_api.g_varchar2) or
817: nvl(per_asg_shd.g_old_rec.ass_attribute7, hr_api.g_varchar2) <>
818: nvl(p_rec.ass_attribute7, hr_api.g_varchar2) or
819: nvl(per_asg_shd.g_old_rec.ass_attribute8, hr_api.g_varchar2) <>
820: nvl(p_rec.ass_attribute8, hr_api.g_varchar2) or
821: nvl(per_asg_shd.g_old_rec.ass_attribute9, hr_api.g_varchar2) <>
822: nvl(p_rec.ass_attribute9, hr_api.g_varchar2) or
823: nvl(per_asg_shd.g_old_rec.ass_attribute10, hr_api.g_varchar2) <>
824: nvl(p_rec.ass_attribute10, hr_api.g_varchar2) or
825: nvl(per_asg_shd.g_old_rec.ass_attribute11, hr_api.g_varchar2) <>
818: nvl(p_rec.ass_attribute7, hr_api.g_varchar2) or
819: nvl(per_asg_shd.g_old_rec.ass_attribute8, hr_api.g_varchar2) <>
820: nvl(p_rec.ass_attribute8, hr_api.g_varchar2) or
821: nvl(per_asg_shd.g_old_rec.ass_attribute9, hr_api.g_varchar2) <>
822: nvl(p_rec.ass_attribute9, hr_api.g_varchar2) or
823: nvl(per_asg_shd.g_old_rec.ass_attribute10, hr_api.g_varchar2) <>
824: nvl(p_rec.ass_attribute10, hr_api.g_varchar2) or
825: nvl(per_asg_shd.g_old_rec.ass_attribute11, hr_api.g_varchar2) <>
826: nvl(p_rec.ass_attribute11, hr_api.g_varchar2) or
819: nvl(per_asg_shd.g_old_rec.ass_attribute8, hr_api.g_varchar2) <>
820: nvl(p_rec.ass_attribute8, hr_api.g_varchar2) or
821: nvl(per_asg_shd.g_old_rec.ass_attribute9, hr_api.g_varchar2) <>
822: nvl(p_rec.ass_attribute9, hr_api.g_varchar2) or
823: nvl(per_asg_shd.g_old_rec.ass_attribute10, hr_api.g_varchar2) <>
824: nvl(p_rec.ass_attribute10, hr_api.g_varchar2) or
825: nvl(per_asg_shd.g_old_rec.ass_attribute11, hr_api.g_varchar2) <>
826: nvl(p_rec.ass_attribute11, hr_api.g_varchar2) or
827: nvl(per_asg_shd.g_old_rec.ass_attribute12, hr_api.g_varchar2) <>
820: nvl(p_rec.ass_attribute8, hr_api.g_varchar2) or
821: nvl(per_asg_shd.g_old_rec.ass_attribute9, hr_api.g_varchar2) <>
822: nvl(p_rec.ass_attribute9, hr_api.g_varchar2) or
823: nvl(per_asg_shd.g_old_rec.ass_attribute10, hr_api.g_varchar2) <>
824: nvl(p_rec.ass_attribute10, hr_api.g_varchar2) or
825: nvl(per_asg_shd.g_old_rec.ass_attribute11, hr_api.g_varchar2) <>
826: nvl(p_rec.ass_attribute11, hr_api.g_varchar2) or
827: nvl(per_asg_shd.g_old_rec.ass_attribute12, hr_api.g_varchar2) <>
828: nvl(p_rec.ass_attribute12, hr_api.g_varchar2) or
821: nvl(per_asg_shd.g_old_rec.ass_attribute9, hr_api.g_varchar2) <>
822: nvl(p_rec.ass_attribute9, hr_api.g_varchar2) or
823: nvl(per_asg_shd.g_old_rec.ass_attribute10, hr_api.g_varchar2) <>
824: nvl(p_rec.ass_attribute10, hr_api.g_varchar2) or
825: nvl(per_asg_shd.g_old_rec.ass_attribute11, hr_api.g_varchar2) <>
826: nvl(p_rec.ass_attribute11, hr_api.g_varchar2) or
827: nvl(per_asg_shd.g_old_rec.ass_attribute12, hr_api.g_varchar2) <>
828: nvl(p_rec.ass_attribute12, hr_api.g_varchar2) or
829: nvl(per_asg_shd.g_old_rec.ass_attribute13, hr_api.g_varchar2) <>
822: nvl(p_rec.ass_attribute9, hr_api.g_varchar2) or
823: nvl(per_asg_shd.g_old_rec.ass_attribute10, hr_api.g_varchar2) <>
824: nvl(p_rec.ass_attribute10, hr_api.g_varchar2) or
825: nvl(per_asg_shd.g_old_rec.ass_attribute11, hr_api.g_varchar2) <>
826: nvl(p_rec.ass_attribute11, hr_api.g_varchar2) or
827: nvl(per_asg_shd.g_old_rec.ass_attribute12, hr_api.g_varchar2) <>
828: nvl(p_rec.ass_attribute12, hr_api.g_varchar2) or
829: nvl(per_asg_shd.g_old_rec.ass_attribute13, hr_api.g_varchar2) <>
830: nvl(p_rec.ass_attribute13, hr_api.g_varchar2) or
823: nvl(per_asg_shd.g_old_rec.ass_attribute10, hr_api.g_varchar2) <>
824: nvl(p_rec.ass_attribute10, hr_api.g_varchar2) or
825: nvl(per_asg_shd.g_old_rec.ass_attribute11, hr_api.g_varchar2) <>
826: nvl(p_rec.ass_attribute11, hr_api.g_varchar2) or
827: nvl(per_asg_shd.g_old_rec.ass_attribute12, hr_api.g_varchar2) <>
828: nvl(p_rec.ass_attribute12, hr_api.g_varchar2) or
829: nvl(per_asg_shd.g_old_rec.ass_attribute13, hr_api.g_varchar2) <>
830: nvl(p_rec.ass_attribute13, hr_api.g_varchar2) or
831: nvl(per_asg_shd.g_old_rec.ass_attribute14, hr_api.g_varchar2) <>
824: nvl(p_rec.ass_attribute10, hr_api.g_varchar2) or
825: nvl(per_asg_shd.g_old_rec.ass_attribute11, hr_api.g_varchar2) <>
826: nvl(p_rec.ass_attribute11, hr_api.g_varchar2) or
827: nvl(per_asg_shd.g_old_rec.ass_attribute12, hr_api.g_varchar2) <>
828: nvl(p_rec.ass_attribute12, hr_api.g_varchar2) or
829: nvl(per_asg_shd.g_old_rec.ass_attribute13, hr_api.g_varchar2) <>
830: nvl(p_rec.ass_attribute13, hr_api.g_varchar2) or
831: nvl(per_asg_shd.g_old_rec.ass_attribute14, hr_api.g_varchar2) <>
832: nvl(p_rec.ass_attribute14, hr_api.g_varchar2) or
825: nvl(per_asg_shd.g_old_rec.ass_attribute11, hr_api.g_varchar2) <>
826: nvl(p_rec.ass_attribute11, hr_api.g_varchar2) or
827: nvl(per_asg_shd.g_old_rec.ass_attribute12, hr_api.g_varchar2) <>
828: nvl(p_rec.ass_attribute12, hr_api.g_varchar2) or
829: nvl(per_asg_shd.g_old_rec.ass_attribute13, hr_api.g_varchar2) <>
830: nvl(p_rec.ass_attribute13, hr_api.g_varchar2) or
831: nvl(per_asg_shd.g_old_rec.ass_attribute14, hr_api.g_varchar2) <>
832: nvl(p_rec.ass_attribute14, hr_api.g_varchar2) or
833: nvl(per_asg_shd.g_old_rec.ass_attribute15, hr_api.g_varchar2) <>
826: nvl(p_rec.ass_attribute11, hr_api.g_varchar2) or
827: nvl(per_asg_shd.g_old_rec.ass_attribute12, hr_api.g_varchar2) <>
828: nvl(p_rec.ass_attribute12, hr_api.g_varchar2) or
829: nvl(per_asg_shd.g_old_rec.ass_attribute13, hr_api.g_varchar2) <>
830: nvl(p_rec.ass_attribute13, hr_api.g_varchar2) or
831: nvl(per_asg_shd.g_old_rec.ass_attribute14, hr_api.g_varchar2) <>
832: nvl(p_rec.ass_attribute14, hr_api.g_varchar2) or
833: nvl(per_asg_shd.g_old_rec.ass_attribute15, hr_api.g_varchar2) <>
834: nvl(p_rec.ass_attribute15, hr_api.g_varchar2) or
827: nvl(per_asg_shd.g_old_rec.ass_attribute12, hr_api.g_varchar2) <>
828: nvl(p_rec.ass_attribute12, hr_api.g_varchar2) or
829: nvl(per_asg_shd.g_old_rec.ass_attribute13, hr_api.g_varchar2) <>
830: nvl(p_rec.ass_attribute13, hr_api.g_varchar2) or
831: nvl(per_asg_shd.g_old_rec.ass_attribute14, hr_api.g_varchar2) <>
832: nvl(p_rec.ass_attribute14, hr_api.g_varchar2) or
833: nvl(per_asg_shd.g_old_rec.ass_attribute15, hr_api.g_varchar2) <>
834: nvl(p_rec.ass_attribute15, hr_api.g_varchar2) or
835: nvl(per_asg_shd.g_old_rec.ass_attribute16, hr_api.g_varchar2) <>
828: nvl(p_rec.ass_attribute12, hr_api.g_varchar2) or
829: nvl(per_asg_shd.g_old_rec.ass_attribute13, hr_api.g_varchar2) <>
830: nvl(p_rec.ass_attribute13, hr_api.g_varchar2) or
831: nvl(per_asg_shd.g_old_rec.ass_attribute14, hr_api.g_varchar2) <>
832: nvl(p_rec.ass_attribute14, hr_api.g_varchar2) or
833: nvl(per_asg_shd.g_old_rec.ass_attribute15, hr_api.g_varchar2) <>
834: nvl(p_rec.ass_attribute15, hr_api.g_varchar2) or
835: nvl(per_asg_shd.g_old_rec.ass_attribute16, hr_api.g_varchar2) <>
836: nvl(p_rec.ass_attribute16, hr_api.g_varchar2) or
829: nvl(per_asg_shd.g_old_rec.ass_attribute13, hr_api.g_varchar2) <>
830: nvl(p_rec.ass_attribute13, hr_api.g_varchar2) or
831: nvl(per_asg_shd.g_old_rec.ass_attribute14, hr_api.g_varchar2) <>
832: nvl(p_rec.ass_attribute14, hr_api.g_varchar2) or
833: nvl(per_asg_shd.g_old_rec.ass_attribute15, hr_api.g_varchar2) <>
834: nvl(p_rec.ass_attribute15, hr_api.g_varchar2) or
835: nvl(per_asg_shd.g_old_rec.ass_attribute16, hr_api.g_varchar2) <>
836: nvl(p_rec.ass_attribute16, hr_api.g_varchar2) or
837: nvl(per_asg_shd.g_old_rec.ass_attribute17, hr_api.g_varchar2) <>
830: nvl(p_rec.ass_attribute13, hr_api.g_varchar2) or
831: nvl(per_asg_shd.g_old_rec.ass_attribute14, hr_api.g_varchar2) <>
832: nvl(p_rec.ass_attribute14, hr_api.g_varchar2) or
833: nvl(per_asg_shd.g_old_rec.ass_attribute15, hr_api.g_varchar2) <>
834: nvl(p_rec.ass_attribute15, hr_api.g_varchar2) or
835: nvl(per_asg_shd.g_old_rec.ass_attribute16, hr_api.g_varchar2) <>
836: nvl(p_rec.ass_attribute16, hr_api.g_varchar2) or
837: nvl(per_asg_shd.g_old_rec.ass_attribute17, hr_api.g_varchar2) <>
838: nvl(p_rec.ass_attribute17, hr_api.g_varchar2) or
831: nvl(per_asg_shd.g_old_rec.ass_attribute14, hr_api.g_varchar2) <>
832: nvl(p_rec.ass_attribute14, hr_api.g_varchar2) or
833: nvl(per_asg_shd.g_old_rec.ass_attribute15, hr_api.g_varchar2) <>
834: nvl(p_rec.ass_attribute15, hr_api.g_varchar2) or
835: nvl(per_asg_shd.g_old_rec.ass_attribute16, hr_api.g_varchar2) <>
836: nvl(p_rec.ass_attribute16, hr_api.g_varchar2) or
837: nvl(per_asg_shd.g_old_rec.ass_attribute17, hr_api.g_varchar2) <>
838: nvl(p_rec.ass_attribute17, hr_api.g_varchar2) or
839: nvl(per_asg_shd.g_old_rec.ass_attribute18, hr_api.g_varchar2) <>
832: nvl(p_rec.ass_attribute14, hr_api.g_varchar2) or
833: nvl(per_asg_shd.g_old_rec.ass_attribute15, hr_api.g_varchar2) <>
834: nvl(p_rec.ass_attribute15, hr_api.g_varchar2) or
835: nvl(per_asg_shd.g_old_rec.ass_attribute16, hr_api.g_varchar2) <>
836: nvl(p_rec.ass_attribute16, hr_api.g_varchar2) or
837: nvl(per_asg_shd.g_old_rec.ass_attribute17, hr_api.g_varchar2) <>
838: nvl(p_rec.ass_attribute17, hr_api.g_varchar2) or
839: nvl(per_asg_shd.g_old_rec.ass_attribute18, hr_api.g_varchar2) <>
840: nvl(p_rec.ass_attribute18, hr_api.g_varchar2) or
833: nvl(per_asg_shd.g_old_rec.ass_attribute15, hr_api.g_varchar2) <>
834: nvl(p_rec.ass_attribute15, hr_api.g_varchar2) or
835: nvl(per_asg_shd.g_old_rec.ass_attribute16, hr_api.g_varchar2) <>
836: nvl(p_rec.ass_attribute16, hr_api.g_varchar2) or
837: nvl(per_asg_shd.g_old_rec.ass_attribute17, hr_api.g_varchar2) <>
838: nvl(p_rec.ass_attribute17, hr_api.g_varchar2) or
839: nvl(per_asg_shd.g_old_rec.ass_attribute18, hr_api.g_varchar2) <>
840: nvl(p_rec.ass_attribute18, hr_api.g_varchar2) or
841: nvl(per_asg_shd.g_old_rec.ass_attribute19, hr_api.g_varchar2) <>
834: nvl(p_rec.ass_attribute15, hr_api.g_varchar2) or
835: nvl(per_asg_shd.g_old_rec.ass_attribute16, hr_api.g_varchar2) <>
836: nvl(p_rec.ass_attribute16, hr_api.g_varchar2) or
837: nvl(per_asg_shd.g_old_rec.ass_attribute17, hr_api.g_varchar2) <>
838: nvl(p_rec.ass_attribute17, hr_api.g_varchar2) or
839: nvl(per_asg_shd.g_old_rec.ass_attribute18, hr_api.g_varchar2) <>
840: nvl(p_rec.ass_attribute18, hr_api.g_varchar2) or
841: nvl(per_asg_shd.g_old_rec.ass_attribute19, hr_api.g_varchar2) <>
842: nvl(p_rec.ass_attribute19, hr_api.g_varchar2) or
835: nvl(per_asg_shd.g_old_rec.ass_attribute16, hr_api.g_varchar2) <>
836: nvl(p_rec.ass_attribute16, hr_api.g_varchar2) or
837: nvl(per_asg_shd.g_old_rec.ass_attribute17, hr_api.g_varchar2) <>
838: nvl(p_rec.ass_attribute17, hr_api.g_varchar2) or
839: nvl(per_asg_shd.g_old_rec.ass_attribute18, hr_api.g_varchar2) <>
840: nvl(p_rec.ass_attribute18, hr_api.g_varchar2) or
841: nvl(per_asg_shd.g_old_rec.ass_attribute19, hr_api.g_varchar2) <>
842: nvl(p_rec.ass_attribute19, hr_api.g_varchar2) or
843: nvl(per_asg_shd.g_old_rec.ass_attribute20, hr_api.g_varchar2) <>
836: nvl(p_rec.ass_attribute16, hr_api.g_varchar2) or
837: nvl(per_asg_shd.g_old_rec.ass_attribute17, hr_api.g_varchar2) <>
838: nvl(p_rec.ass_attribute17, hr_api.g_varchar2) or
839: nvl(per_asg_shd.g_old_rec.ass_attribute18, hr_api.g_varchar2) <>
840: nvl(p_rec.ass_attribute18, hr_api.g_varchar2) or
841: nvl(per_asg_shd.g_old_rec.ass_attribute19, hr_api.g_varchar2) <>
842: nvl(p_rec.ass_attribute19, hr_api.g_varchar2) or
843: nvl(per_asg_shd.g_old_rec.ass_attribute20, hr_api.g_varchar2) <>
844: nvl(p_rec.ass_attribute20, hr_api.g_varchar2) or
837: nvl(per_asg_shd.g_old_rec.ass_attribute17, hr_api.g_varchar2) <>
838: nvl(p_rec.ass_attribute17, hr_api.g_varchar2) or
839: nvl(per_asg_shd.g_old_rec.ass_attribute18, hr_api.g_varchar2) <>
840: nvl(p_rec.ass_attribute18, hr_api.g_varchar2) or
841: nvl(per_asg_shd.g_old_rec.ass_attribute19, hr_api.g_varchar2) <>
842: nvl(p_rec.ass_attribute19, hr_api.g_varchar2) or
843: nvl(per_asg_shd.g_old_rec.ass_attribute20, hr_api.g_varchar2) <>
844: nvl(p_rec.ass_attribute20, hr_api.g_varchar2) or
845: nvl(per_asg_shd.g_old_rec.ass_attribute21, hr_api.g_varchar2) <>
838: nvl(p_rec.ass_attribute17, hr_api.g_varchar2) or
839: nvl(per_asg_shd.g_old_rec.ass_attribute18, hr_api.g_varchar2) <>
840: nvl(p_rec.ass_attribute18, hr_api.g_varchar2) or
841: nvl(per_asg_shd.g_old_rec.ass_attribute19, hr_api.g_varchar2) <>
842: nvl(p_rec.ass_attribute19, hr_api.g_varchar2) or
843: nvl(per_asg_shd.g_old_rec.ass_attribute20, hr_api.g_varchar2) <>
844: nvl(p_rec.ass_attribute20, hr_api.g_varchar2) or
845: nvl(per_asg_shd.g_old_rec.ass_attribute21, hr_api.g_varchar2) <>
846: nvl(p_rec.ass_attribute21, hr_api.g_varchar2) or
839: nvl(per_asg_shd.g_old_rec.ass_attribute18, hr_api.g_varchar2) <>
840: nvl(p_rec.ass_attribute18, hr_api.g_varchar2) or
841: nvl(per_asg_shd.g_old_rec.ass_attribute19, hr_api.g_varchar2) <>
842: nvl(p_rec.ass_attribute19, hr_api.g_varchar2) or
843: nvl(per_asg_shd.g_old_rec.ass_attribute20, hr_api.g_varchar2) <>
844: nvl(p_rec.ass_attribute20, hr_api.g_varchar2) or
845: nvl(per_asg_shd.g_old_rec.ass_attribute21, hr_api.g_varchar2) <>
846: nvl(p_rec.ass_attribute21, hr_api.g_varchar2) or
847: nvl(per_asg_shd.g_old_rec.ass_attribute22, hr_api.g_varchar2) <>
840: nvl(p_rec.ass_attribute18, hr_api.g_varchar2) or
841: nvl(per_asg_shd.g_old_rec.ass_attribute19, hr_api.g_varchar2) <>
842: nvl(p_rec.ass_attribute19, hr_api.g_varchar2) or
843: nvl(per_asg_shd.g_old_rec.ass_attribute20, hr_api.g_varchar2) <>
844: nvl(p_rec.ass_attribute20, hr_api.g_varchar2) or
845: nvl(per_asg_shd.g_old_rec.ass_attribute21, hr_api.g_varchar2) <>
846: nvl(p_rec.ass_attribute21, hr_api.g_varchar2) or
847: nvl(per_asg_shd.g_old_rec.ass_attribute22, hr_api.g_varchar2) <>
848: nvl(p_rec.ass_attribute22, hr_api.g_varchar2) or
841: nvl(per_asg_shd.g_old_rec.ass_attribute19, hr_api.g_varchar2) <>
842: nvl(p_rec.ass_attribute19, hr_api.g_varchar2) or
843: nvl(per_asg_shd.g_old_rec.ass_attribute20, hr_api.g_varchar2) <>
844: nvl(p_rec.ass_attribute20, hr_api.g_varchar2) or
845: nvl(per_asg_shd.g_old_rec.ass_attribute21, hr_api.g_varchar2) <>
846: nvl(p_rec.ass_attribute21, hr_api.g_varchar2) or
847: nvl(per_asg_shd.g_old_rec.ass_attribute22, hr_api.g_varchar2) <>
848: nvl(p_rec.ass_attribute22, hr_api.g_varchar2) or
849: nvl(per_asg_shd.g_old_rec.ass_attribute23, hr_api.g_varchar2) <>
842: nvl(p_rec.ass_attribute19, hr_api.g_varchar2) or
843: nvl(per_asg_shd.g_old_rec.ass_attribute20, hr_api.g_varchar2) <>
844: nvl(p_rec.ass_attribute20, hr_api.g_varchar2) or
845: nvl(per_asg_shd.g_old_rec.ass_attribute21, hr_api.g_varchar2) <>
846: nvl(p_rec.ass_attribute21, hr_api.g_varchar2) or
847: nvl(per_asg_shd.g_old_rec.ass_attribute22, hr_api.g_varchar2) <>
848: nvl(p_rec.ass_attribute22, hr_api.g_varchar2) or
849: nvl(per_asg_shd.g_old_rec.ass_attribute23, hr_api.g_varchar2) <>
850: nvl(p_rec.ass_attribute23, hr_api.g_varchar2) or
843: nvl(per_asg_shd.g_old_rec.ass_attribute20, hr_api.g_varchar2) <>
844: nvl(p_rec.ass_attribute20, hr_api.g_varchar2) or
845: nvl(per_asg_shd.g_old_rec.ass_attribute21, hr_api.g_varchar2) <>
846: nvl(p_rec.ass_attribute21, hr_api.g_varchar2) or
847: nvl(per_asg_shd.g_old_rec.ass_attribute22, hr_api.g_varchar2) <>
848: nvl(p_rec.ass_attribute22, hr_api.g_varchar2) or
849: nvl(per_asg_shd.g_old_rec.ass_attribute23, hr_api.g_varchar2) <>
850: nvl(p_rec.ass_attribute23, hr_api.g_varchar2) or
851: nvl(per_asg_shd.g_old_rec.ass_attribute24, hr_api.g_varchar2) <>
844: nvl(p_rec.ass_attribute20, hr_api.g_varchar2) or
845: nvl(per_asg_shd.g_old_rec.ass_attribute21, hr_api.g_varchar2) <>
846: nvl(p_rec.ass_attribute21, hr_api.g_varchar2) or
847: nvl(per_asg_shd.g_old_rec.ass_attribute22, hr_api.g_varchar2) <>
848: nvl(p_rec.ass_attribute22, hr_api.g_varchar2) or
849: nvl(per_asg_shd.g_old_rec.ass_attribute23, hr_api.g_varchar2) <>
850: nvl(p_rec.ass_attribute23, hr_api.g_varchar2) or
851: nvl(per_asg_shd.g_old_rec.ass_attribute24, hr_api.g_varchar2) <>
852: nvl(p_rec.ass_attribute24, hr_api.g_varchar2) or
845: nvl(per_asg_shd.g_old_rec.ass_attribute21, hr_api.g_varchar2) <>
846: nvl(p_rec.ass_attribute21, hr_api.g_varchar2) or
847: nvl(per_asg_shd.g_old_rec.ass_attribute22, hr_api.g_varchar2) <>
848: nvl(p_rec.ass_attribute22, hr_api.g_varchar2) or
849: nvl(per_asg_shd.g_old_rec.ass_attribute23, hr_api.g_varchar2) <>
850: nvl(p_rec.ass_attribute23, hr_api.g_varchar2) or
851: nvl(per_asg_shd.g_old_rec.ass_attribute24, hr_api.g_varchar2) <>
852: nvl(p_rec.ass_attribute24, hr_api.g_varchar2) or
853: nvl(per_asg_shd.g_old_rec.ass_attribute25, hr_api.g_varchar2) <>
846: nvl(p_rec.ass_attribute21, hr_api.g_varchar2) or
847: nvl(per_asg_shd.g_old_rec.ass_attribute22, hr_api.g_varchar2) <>
848: nvl(p_rec.ass_attribute22, hr_api.g_varchar2) or
849: nvl(per_asg_shd.g_old_rec.ass_attribute23, hr_api.g_varchar2) <>
850: nvl(p_rec.ass_attribute23, hr_api.g_varchar2) or
851: nvl(per_asg_shd.g_old_rec.ass_attribute24, hr_api.g_varchar2) <>
852: nvl(p_rec.ass_attribute24, hr_api.g_varchar2) or
853: nvl(per_asg_shd.g_old_rec.ass_attribute25, hr_api.g_varchar2) <>
854: nvl(p_rec.ass_attribute25, hr_api.g_varchar2) or
847: nvl(per_asg_shd.g_old_rec.ass_attribute22, hr_api.g_varchar2) <>
848: nvl(p_rec.ass_attribute22, hr_api.g_varchar2) or
849: nvl(per_asg_shd.g_old_rec.ass_attribute23, hr_api.g_varchar2) <>
850: nvl(p_rec.ass_attribute23, hr_api.g_varchar2) or
851: nvl(per_asg_shd.g_old_rec.ass_attribute24, hr_api.g_varchar2) <>
852: nvl(p_rec.ass_attribute24, hr_api.g_varchar2) or
853: nvl(per_asg_shd.g_old_rec.ass_attribute25, hr_api.g_varchar2) <>
854: nvl(p_rec.ass_attribute25, hr_api.g_varchar2) or
855: nvl(per_asg_shd.g_old_rec.ass_attribute26, hr_api.g_varchar2) <>
848: nvl(p_rec.ass_attribute22, hr_api.g_varchar2) or
849: nvl(per_asg_shd.g_old_rec.ass_attribute23, hr_api.g_varchar2) <>
850: nvl(p_rec.ass_attribute23, hr_api.g_varchar2) or
851: nvl(per_asg_shd.g_old_rec.ass_attribute24, hr_api.g_varchar2) <>
852: nvl(p_rec.ass_attribute24, hr_api.g_varchar2) or
853: nvl(per_asg_shd.g_old_rec.ass_attribute25, hr_api.g_varchar2) <>
854: nvl(p_rec.ass_attribute25, hr_api.g_varchar2) or
855: nvl(per_asg_shd.g_old_rec.ass_attribute26, hr_api.g_varchar2) <>
856: nvl(p_rec.ass_attribute26, hr_api.g_varchar2) or
849: nvl(per_asg_shd.g_old_rec.ass_attribute23, hr_api.g_varchar2) <>
850: nvl(p_rec.ass_attribute23, hr_api.g_varchar2) or
851: nvl(per_asg_shd.g_old_rec.ass_attribute24, hr_api.g_varchar2) <>
852: nvl(p_rec.ass_attribute24, hr_api.g_varchar2) or
853: nvl(per_asg_shd.g_old_rec.ass_attribute25, hr_api.g_varchar2) <>
854: nvl(p_rec.ass_attribute25, hr_api.g_varchar2) or
855: nvl(per_asg_shd.g_old_rec.ass_attribute26, hr_api.g_varchar2) <>
856: nvl(p_rec.ass_attribute26, hr_api.g_varchar2) or
857: nvl(per_asg_shd.g_old_rec.ass_attribute27, hr_api.g_varchar2) <>
850: nvl(p_rec.ass_attribute23, hr_api.g_varchar2) or
851: nvl(per_asg_shd.g_old_rec.ass_attribute24, hr_api.g_varchar2) <>
852: nvl(p_rec.ass_attribute24, hr_api.g_varchar2) or
853: nvl(per_asg_shd.g_old_rec.ass_attribute25, hr_api.g_varchar2) <>
854: nvl(p_rec.ass_attribute25, hr_api.g_varchar2) or
855: nvl(per_asg_shd.g_old_rec.ass_attribute26, hr_api.g_varchar2) <>
856: nvl(p_rec.ass_attribute26, hr_api.g_varchar2) or
857: nvl(per_asg_shd.g_old_rec.ass_attribute27, hr_api.g_varchar2) <>
858: nvl(p_rec.ass_attribute27, hr_api.g_varchar2) or
851: nvl(per_asg_shd.g_old_rec.ass_attribute24, hr_api.g_varchar2) <>
852: nvl(p_rec.ass_attribute24, hr_api.g_varchar2) or
853: nvl(per_asg_shd.g_old_rec.ass_attribute25, hr_api.g_varchar2) <>
854: nvl(p_rec.ass_attribute25, hr_api.g_varchar2) or
855: nvl(per_asg_shd.g_old_rec.ass_attribute26, hr_api.g_varchar2) <>
856: nvl(p_rec.ass_attribute26, hr_api.g_varchar2) or
857: nvl(per_asg_shd.g_old_rec.ass_attribute27, hr_api.g_varchar2) <>
858: nvl(p_rec.ass_attribute27, hr_api.g_varchar2) or
859: nvl(per_asg_shd.g_old_rec.ass_attribute28, hr_api.g_varchar2) <>
852: nvl(p_rec.ass_attribute24, hr_api.g_varchar2) or
853: nvl(per_asg_shd.g_old_rec.ass_attribute25, hr_api.g_varchar2) <>
854: nvl(p_rec.ass_attribute25, hr_api.g_varchar2) or
855: nvl(per_asg_shd.g_old_rec.ass_attribute26, hr_api.g_varchar2) <>
856: nvl(p_rec.ass_attribute26, hr_api.g_varchar2) or
857: nvl(per_asg_shd.g_old_rec.ass_attribute27, hr_api.g_varchar2) <>
858: nvl(p_rec.ass_attribute27, hr_api.g_varchar2) or
859: nvl(per_asg_shd.g_old_rec.ass_attribute28, hr_api.g_varchar2) <>
860: nvl(p_rec.ass_attribute28, hr_api.g_varchar2) or
853: nvl(per_asg_shd.g_old_rec.ass_attribute25, hr_api.g_varchar2) <>
854: nvl(p_rec.ass_attribute25, hr_api.g_varchar2) or
855: nvl(per_asg_shd.g_old_rec.ass_attribute26, hr_api.g_varchar2) <>
856: nvl(p_rec.ass_attribute26, hr_api.g_varchar2) or
857: nvl(per_asg_shd.g_old_rec.ass_attribute27, hr_api.g_varchar2) <>
858: nvl(p_rec.ass_attribute27, hr_api.g_varchar2) or
859: nvl(per_asg_shd.g_old_rec.ass_attribute28, hr_api.g_varchar2) <>
860: nvl(p_rec.ass_attribute28, hr_api.g_varchar2) or
861: nvl(per_asg_shd.g_old_rec.ass_attribute29, hr_api.g_varchar2) <>
854: nvl(p_rec.ass_attribute25, hr_api.g_varchar2) or
855: nvl(per_asg_shd.g_old_rec.ass_attribute26, hr_api.g_varchar2) <>
856: nvl(p_rec.ass_attribute26, hr_api.g_varchar2) or
857: nvl(per_asg_shd.g_old_rec.ass_attribute27, hr_api.g_varchar2) <>
858: nvl(p_rec.ass_attribute27, hr_api.g_varchar2) or
859: nvl(per_asg_shd.g_old_rec.ass_attribute28, hr_api.g_varchar2) <>
860: nvl(p_rec.ass_attribute28, hr_api.g_varchar2) or
861: nvl(per_asg_shd.g_old_rec.ass_attribute29, hr_api.g_varchar2) <>
862: nvl(p_rec.ass_attribute29, hr_api.g_varchar2) or
855: nvl(per_asg_shd.g_old_rec.ass_attribute26, hr_api.g_varchar2) <>
856: nvl(p_rec.ass_attribute26, hr_api.g_varchar2) or
857: nvl(per_asg_shd.g_old_rec.ass_attribute27, hr_api.g_varchar2) <>
858: nvl(p_rec.ass_attribute27, hr_api.g_varchar2) or
859: nvl(per_asg_shd.g_old_rec.ass_attribute28, hr_api.g_varchar2) <>
860: nvl(p_rec.ass_attribute28, hr_api.g_varchar2) or
861: nvl(per_asg_shd.g_old_rec.ass_attribute29, hr_api.g_varchar2) <>
862: nvl(p_rec.ass_attribute29, hr_api.g_varchar2) or
863: nvl(per_asg_shd.g_old_rec.ass_attribute30, hr_api.g_varchar2) <>
856: nvl(p_rec.ass_attribute26, hr_api.g_varchar2) or
857: nvl(per_asg_shd.g_old_rec.ass_attribute27, hr_api.g_varchar2) <>
858: nvl(p_rec.ass_attribute27, hr_api.g_varchar2) or
859: nvl(per_asg_shd.g_old_rec.ass_attribute28, hr_api.g_varchar2) <>
860: nvl(p_rec.ass_attribute28, hr_api.g_varchar2) or
861: nvl(per_asg_shd.g_old_rec.ass_attribute29, hr_api.g_varchar2) <>
862: nvl(p_rec.ass_attribute29, hr_api.g_varchar2) or
863: nvl(per_asg_shd.g_old_rec.ass_attribute30, hr_api.g_varchar2) <>
864: nvl(p_rec.ass_attribute30, hr_api.g_varchar2)
857: nvl(per_asg_shd.g_old_rec.ass_attribute27, hr_api.g_varchar2) <>
858: nvl(p_rec.ass_attribute27, hr_api.g_varchar2) or
859: nvl(per_asg_shd.g_old_rec.ass_attribute28, hr_api.g_varchar2) <>
860: nvl(p_rec.ass_attribute28, hr_api.g_varchar2) or
861: nvl(per_asg_shd.g_old_rec.ass_attribute29, hr_api.g_varchar2) <>
862: nvl(p_rec.ass_attribute29, hr_api.g_varchar2) or
863: nvl(per_asg_shd.g_old_rec.ass_attribute30, hr_api.g_varchar2) <>
864: nvl(p_rec.ass_attribute30, hr_api.g_varchar2)
865: )
858: nvl(p_rec.ass_attribute27, hr_api.g_varchar2) or
859: nvl(per_asg_shd.g_old_rec.ass_attribute28, hr_api.g_varchar2) <>
860: nvl(p_rec.ass_attribute28, hr_api.g_varchar2) or
861: nvl(per_asg_shd.g_old_rec.ass_attribute29, hr_api.g_varchar2) <>
862: nvl(p_rec.ass_attribute29, hr_api.g_varchar2) or
863: nvl(per_asg_shd.g_old_rec.ass_attribute30, hr_api.g_varchar2) <>
864: nvl(p_rec.ass_attribute30, hr_api.g_varchar2)
865: )
866: or
859: nvl(per_asg_shd.g_old_rec.ass_attribute28, hr_api.g_varchar2) <>
860: nvl(p_rec.ass_attribute28, hr_api.g_varchar2) or
861: nvl(per_asg_shd.g_old_rec.ass_attribute29, hr_api.g_varchar2) <>
862: nvl(p_rec.ass_attribute29, hr_api.g_varchar2) or
863: nvl(per_asg_shd.g_old_rec.ass_attribute30, hr_api.g_varchar2) <>
864: nvl(p_rec.ass_attribute30, hr_api.g_varchar2)
865: )
866: or
867: (
860: nvl(p_rec.ass_attribute28, hr_api.g_varchar2) or
861: nvl(per_asg_shd.g_old_rec.ass_attribute29, hr_api.g_varchar2) <>
862: nvl(p_rec.ass_attribute29, hr_api.g_varchar2) or
863: nvl(per_asg_shd.g_old_rec.ass_attribute30, hr_api.g_varchar2) <>
864: nvl(p_rec.ass_attribute30, hr_api.g_varchar2)
865: )
866: or
867: (
868: (p_rec.ass_attribute_category is null) and
1016: --
1017: l_other_manager_warning := FALSE;
1018: l_hourly_salaried_warning := FALSE;
1019: --
1020: hr_api.validate_bus_grp_id
1021: (p_business_group_id => p_rec.business_group_id
1022: ,p_associated_column1 => per_asg_shd.g_tab_nam ||
1023: '.BUSINESS_GROUP_ID'
1024: );
2115: l_no_managers_warning := FALSE;
2116:
2117: l_org_now_no_manager_warning := FALSE;
2118: --
2119: hr_api.validate_bus_grp_id
2120: (p_business_group_id => p_rec.business_group_id
2121: ,p_associated_column1 => per_asg_shd.g_tab_nam ||
2122: '.BUSINESS_GROUP_ID'
2123: ); -- chk business group id
2717: ,p_object_version_number => p_rec.object_version_number
2718: );
2719:
2720: if(l_api_updating and
2721: nvl(per_asg_shd.g_old_rec.assignment_type, hr_api.g_varchar2)
2722: = 'A' and p_rec.assignment_type = 'E') THEN
2723:
2724: hr_assignment.gen_new_ass_sequence
2725: ( p_rec.person_id
3277: from per_applications
3278: where application_id = p_application_id
3279: and p_validation_start_date
3280: between date_received
3281: and nvl(date_end,hr_api.g_eot);
3282: --
3283: begin
3284: if g_debug then
3285: hr_utility.set_location('Entering:'|| l_proc, 10);
3287: --
3288: --
3289: -- Check mandatory parameters have been set
3290: --
3291: hr_api.mandatory_arg_error
3292: (p_api_name => l_proc
3293: ,p_argument => 'effective_date'
3294: ,p_argument_value => p_effective_date
3295: );
3293: ,p_argument => 'effective_date'
3294: ,p_argument_value => p_effective_date
3295: );
3296: --
3297: hr_api.mandatory_arg_error
3298: (p_api_name => l_proc
3299: ,p_argument => 'validation_start_date'
3300: ,p_argument_value => p_validation_start_date
3301: );
3315: --
3316: -- Check if the assignment is being inserted or updated.
3317: --
3318: if ((l_api_updating and
3319: nvl(per_asg_shd.g_old_rec.application_id, hr_api.g_number)
3320: <> nvl(p_application_id, hr_api.g_number))
3321: or (NOT l_api_updating))
3322: then
3323: if g_debug then
3316: -- Check if the assignment is being inserted or updated.
3317: --
3318: if ((l_api_updating and
3319: nvl(per_asg_shd.g_old_rec.application_id, hr_api.g_number)
3320: <> nvl(p_application_id, hr_api.g_number))
3321: or (NOT l_api_updating))
3322: then
3323: if g_debug then
3324: hr_utility.set_location(l_proc, 40);
3496: if g_debug then
3497: hr_utility.set_location('Entering: '|| l_proc, 10);
3498: end if;
3499: --
3500: hr_api.mandatory_arg_error
3501: (p_api_name => l_proc
3502: ,p_argument => 'person_id'
3503: ,p_argument_value => p_person_id
3504: );
3502: ,p_argument => 'person_id'
3503: ,p_argument_value => p_person_id
3504: );
3505: --
3506: hr_api.mandatory_arg_error
3507: (p_api_name => l_proc
3508: ,p_argument => 'business_group_id'
3509: ,p_argument_value => p_business_group_id
3510: );
3508: ,p_argument => 'business_group_id'
3509: ,p_argument_value => p_business_group_id
3510: );
3511: --
3512: hr_api.mandatory_arg_error
3513: (p_api_name => l_proc
3514: ,p_argument => 'assignment_type'
3515: ,p_argument_value => p_assignment_type
3516: );
3514: ,p_argument => 'assignment_type'
3515: ,p_argument_value => p_assignment_type
3516: );
3517: --
3518: hr_api.mandatory_arg_error
3519: (p_api_name => l_proc
3520: ,p_argument => 'assignment_sequence'
3521: ,p_argument_value => p_assignment_sequence
3522: );
3542: -- Removed p_assignment_number is not null from the check condition
3543: -- of the top level if statement
3544: --
3545: if ((l_api_updating and
3546: nvl(per_asg_shd.g_old_rec.assignment_number, hr_api.g_varchar2) <>
3547: nvl(p_assignment_number, hr_api.g_varchar2)) or
3548: (NOT l_api_updating)) then
3549: --
3550: if g_debug then
3543: -- of the top level if statement
3544: --
3545: if ((l_api_updating and
3546: nvl(per_asg_shd.g_old_rec.assignment_number, hr_api.g_varchar2) <>
3547: nvl(p_assignment_number, hr_api.g_varchar2)) or
3548: (NOT l_api_updating)) then
3549: --
3550: if g_debug then
3551: hr_utility.set_location(l_proc, 40);
3629: -- Check if the applicant assignment is being converted to an employee
3630: -- assignment.
3631: --
3632: elsif (l_api_updating and
3633: nvl(per_asg_shd.g_old_rec.assignment_type, hr_api.g_varchar2)
3634: = 'A' and p_assignment_type = 'E') then
3635: --
3636: if hr_multi_message.no_exclusive_error
3637: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID') then
3724: --
3725: -- Check if inserting or assignment type has changed
3726: --
3727: IF ((l_api_updating AND
3728: nvl(per_asg_shd.g_old_rec.assignment_category, hr_api.g_varchar2) <>
3729: nvl(p_assignment_category, hr_api.g_varchar2)) OR
3730: (NOT l_api_updating)) THEN
3731: --
3732: if g_debug then
3725: -- Check if inserting or assignment type has changed
3726: --
3727: IF ((l_api_updating AND
3728: nvl(per_asg_shd.g_old_rec.assignment_category, hr_api.g_varchar2) <>
3729: nvl(p_assignment_category, hr_api.g_varchar2)) OR
3730: (NOT l_api_updating)) THEN
3731: --
3732: if g_debug then
3733: hr_utility.set_location(l_proc, 40);
3738: --
3739: IF p_assignment_type = 'C' AND
3740: p_assignment_category IS NOT NULL THEN
3741: --
3742: IF hr_api.not_exists_in_dt_hr_lookups
3743: (p_effective_date => p_effective_date
3744: ,p_validation_start_date => p_validation_start_date
3745: ,p_validation_end_date => p_validation_end_date
3746: ,p_lookup_type => 'CWK_ASG_CATEGORY'
3851: ) then
3852: --
3853: -- If p_assignment_status_type_id is g_number then derive it's default value.
3854: --
3855: if nvl(p_assignment_status_type_id, hr_api.g_number) = hr_api.g_number then
3856: --
3857: if g_debug then
3858: hr_utility.set_location(l_proc, 10);
3859: end if;
4010: -- the first assignment datetracked instance with assignment
4011: -- status type PER_SYSTEM_STATUS of 'ACTIVE_ASSIGN'
4012: --
4013: cursor csr_get_initial_ins_date is
4014: select nvl(min(asg.effective_start_date), hr_api.g_eot)
4015: from per_all_assignments_f asg
4016: ,per_assignment_status_types ast
4017: where asg.assignment_id = p_rec.assignment_id
4018: and ast.assignment_status_type_id = asg.assignment_status_type_id
4046: end if;
4047: --
4048: -- Check mandatory parameters have been set.
4049: --
4050: hr_api.mandatory_arg_error
4051: (p_api_name => l_proc
4052: ,p_argument => 'assignment_status_type_id'
4053: ,p_argument_value => p_rec.assignment_status_type_id
4054: );
4052: ,p_argument => 'assignment_status_type_id'
4053: ,p_argument_value => p_rec.assignment_status_type_id
4054: );
4055: --
4056: hr_api.mandatory_arg_error
4057: (p_api_name => l_proc
4058: ,p_argument => 'effective_date'
4059: ,p_argument_value => p_effective_date
4060: );
4058: ,p_argument => 'effective_date'
4059: ,p_argument_value => p_effective_date
4060: );
4061: --
4062: hr_api.mandatory_arg_error
4063: (p_api_name => l_proc
4064: ,p_argument => 'validation_start_date'
4065: ,p_argument_value => p_validation_start_date
4066: );
4064: ,p_argument => 'validation_start_date'
4065: ,p_argument_value => p_validation_start_date
4066: );
4067: --
4068: hr_api.mandatory_arg_error
4069: (p_api_name => l_proc
4070: ,p_argument => 'business_group_id'
4071: ,p_argument_value => p_rec.business_group_id
4072: );
4308: -- a) The current g_old_rec is current and
4309: -- b) The value for assignment status type has changed
4310: --
4311: if (l_api_updating
4312: and nvl(per_asg_shd.g_old_rec.assignment_status_type_id, hr_api.g_number)
4313: <> nvl(p_rec.assignment_status_type_id, hr_api.g_number)
4314: )
4315: or not l_api_updating
4316: then
4309: -- b) The value for assignment status type has changed
4310: --
4311: if (l_api_updating
4312: and nvl(per_asg_shd.g_old_rec.assignment_status_type_id, hr_api.g_number)
4313: <> nvl(p_rec.assignment_status_type_id, hr_api.g_number)
4314: )
4315: or not l_api_updating
4316: then
4317: if g_debug then
4638: end if;
4639: --
4640: -- Check mandatory parameters have been set
4641: --
4642: hr_api.mandatory_arg_error
4643: (p_api_name => l_proc
4644: ,p_argument => 'assignment_type'
4645:
4646: ,p_argument_value => p_assignment_type
4662: --
4663: -- Check if inserting or assignment type has changed
4664: --
4665: if ((l_api_updating and
4666: nvl(per_asg_shd.g_old_rec.assignment_type, hr_api.g_varchar2) <>
4667: nvl(p_assignment_type, hr_api.g_varchar2))
4668: or
4669: (NOT l_api_updating))
4670: then
4663: -- Check if inserting or assignment type has changed
4664: --
4665: if ((l_api_updating and
4666: nvl(per_asg_shd.g_old_rec.assignment_type, hr_api.g_varchar2) <>
4667: nvl(p_assignment_type, hr_api.g_varchar2))
4668: or
4669: (NOT l_api_updating))
4670: then
4671: if g_debug then
4809: end if;
4810: --
4811: -- Check mandatory arguments
4812: --
4813: hr_api.mandatory_arg_error
4814: (p_api_name => l_proc
4815: ,p_argument => 'effective_date'
4816: ,p_argument_value => p_effective_date
4817: );
4815: ,p_argument => 'effective_date'
4816: ,p_argument_value => p_effective_date
4817: );
4818: --
4819: hr_api.mandatory_arg_error
4820: (p_api_name => l_proc
4821: ,p_argument => 'validation_start_date'
4822: ,p_argument_value => p_validation_start_date
4823: );
4821: ,p_argument => 'validation_start_date'
4822: ,p_argument_value => p_validation_start_date
4823: );
4824: --
4825: hr_api.mandatory_arg_error
4826: (p_api_name => l_proc
4827: ,p_argument => 'validation_end_date'
4828: ,p_argument_value => p_validation_end_date
4829: );
4840: hr_utility.set_location(l_proc, 30);
4841: end if;
4842: --
4843: if ((l_api_updating and
4844: nvl(per_asg_shd.g_old_rec.change_reason, hr_api.g_varchar2) <>
4845: nvl(p_change_reason, hr_api.g_varchar2))
4846: or
4847: (NOT l_api_updating))
4848: then
4841: end if;
4842: --
4843: if ((l_api_updating and
4844: nvl(per_asg_shd.g_old_rec.change_reason, hr_api.g_varchar2) <>
4845: nvl(p_change_reason, hr_api.g_varchar2))
4846: or
4847: (NOT l_api_updating))
4848: then
4849: if g_debug then
4862: -- lookup type 'EMP_ASSIGN_REASON' with an enabled flag set to 'Y'
4863: -- and that the effective strt date of the assignment is between
4864: -- start date active and end date active in hr_lookups.
4865: --
4866: if hr_api.not_exists_in_dt_hr_lookups
4867: (p_effective_date => p_effective_date
4868: ,p_validation_start_date => p_validation_start_date
4869: ,p_validation_end_date => p_validation_end_date
4870: ,p_lookup_type => 'EMP_ASSIGN_REASON'
4890: -- lookup type 'CWK_ASSIGN_REASON' with an enabled flag set to 'Y'
4891: -- and that the effective start date of the assignment is between
4892: -- start date active and end date active in hr_lookups.
4893: --
4894: IF hr_api.not_exists_in_dt_hr_lookups
4895: (p_effective_date => p_effective_date
4896: ,p_validation_start_date => p_validation_start_date
4897: ,p_validation_end_date => p_validation_end_date
4898: ,p_lookup_type => 'CWK_ASSIGN_REASON'
4913: -- lookup type 'APL_ASSIGN_REASON' with an enabled flag set to 'Y'
4914: -- and that the effective strt date of the assignment is between
4915: -- start date active and end date active in hr_lookups.
4916: --
4917: if hr_api.not_exists_in_dt_hr_lookups
4918: (p_effective_date => p_effective_date
4919: ,p_validation_start_date => p_validation_start_date
4920: ,p_validation_end_date => p_validation_end_date
4921: ,p_lookup_type => 'APL_ASSIGN_REASON'
5011: and (exists(select null
5012: from per_all_assignments_f pas2
5013: , per_periods_of_service ppos2
5014: where pas2.effective_end_date =
5015: nvl(ppos2.actual_termination_date, hr_api.g_eot)
5016: and pas.assignment_id = pas2.assignment_id
5017: and pas2.period_of_service_id = ppos2.period_of_service_id ))); -- Added this last filter for Bug 4300591.
5018: --
5019: begin
5022: end if;
5023: --
5024: -- Check mandatory parameters have been set
5025: --
5026: hr_api.mandatory_arg_error
5027: (p_api_name => l_proc
5028: ,p_argument => 'primary_flag'
5029: ,p_argument_value => p_primary_flag
5030: );
5097: end if;
5098: --
5099: -- Check mandatory parameters have been set
5100: --
5101: hr_api.mandatory_arg_error
5102: (p_api_name => l_proc
5103: ,p_argument => 'assignment_type'
5104: ,p_argument_value => p_assignment_type
5105: );
5103: ,p_argument => 'assignment_type'
5104: ,p_argument_value => p_assignment_type
5105: );
5106: --
5107: hr_api.mandatory_arg_error
5108: (p_api_name => l_proc
5109: ,p_argument => 'validation_start_date'
5110: ,p_argument_value => p_validation_start_date
5111: );
5109: ,p_argument => 'validation_start_date'
5110: ,p_argument_value => p_validation_start_date
5111: );
5112: --
5113: hr_api.mandatory_arg_error
5114: (p_api_name => l_proc
5115: ,p_argument => 'effective_date'
5116: ,p_argument_value => p_effective_date
5117: );
5128: ,p_effective_date => p_effective_date
5129: ,p_object_version_number => p_object_version_number);
5130: --
5131: if ((l_api_updating and
5132: nvl(per_asg_shd.g_old_rec.date_probation_end, hr_api.g_date)
5133: <> nvl(p_date_probation_end, hr_api.g_date))
5134: or
5135: (NOT l_api_updating))
5136: then
5129: ,p_object_version_number => p_object_version_number);
5130: --
5131: if ((l_api_updating and
5132: nvl(per_asg_shd.g_old_rec.date_probation_end, hr_api.g_date)
5133: <> nvl(p_date_probation_end, hr_api.g_date))
5134: or
5135: (NOT l_api_updating))
5136: then
5137: if g_debug then
5228: from gl_code_combinations
5229: where code_combination_id = p_default_code_comb_id
5230: and enabled_flag = 'Y'
5231: and p_validation_start_date
5232: between nvl(start_date_active,hr_api.g_sot)
5233: and nvl(end_date_active,hr_api.g_eot);
5234: --
5235: begin
5236: if g_debug then
5229: where code_combination_id = p_default_code_comb_id
5230: and enabled_flag = 'Y'
5231: and p_validation_start_date
5232: between nvl(start_date_active,hr_api.g_sot)
5233: and nvl(end_date_active,hr_api.g_eot);
5234: --
5235: begin
5236: if g_debug then
5237: hr_utility.set_location('Entering:'|| l_proc, 10);
5238: end if;
5239: --
5240: -- Check mandatory parameters have been set
5241: --
5242: hr_api.mandatory_arg_error
5243: (p_api_name => l_proc
5244: ,p_argument => 'effective_date'
5245: ,p_argument_value => p_effective_date
5246: );
5261: hr_utility.set_location(l_proc, 30);
5262: end if;
5263: --
5264: if ((l_api_updating and
5265: nvl(per_asg_shd.g_old_rec.default_code_comb_id, hr_api.g_number) <>
5266: nvl(p_default_code_comb_id, hr_api.g_number)) or
5267: (NOT l_api_updating))
5268: then
5269: if g_debug then
5262: end if;
5263: --
5264: if ((l_api_updating and
5265: nvl(per_asg_shd.g_old_rec.default_code_comb_id, hr_api.g_number) <>
5266: nvl(p_default_code_comb_id, hr_api.g_number)) or
5267: (NOT l_api_updating))
5268: then
5269: if g_debug then
5270: hr_utility.set_location(l_proc, 40);
5418: end if;
5419: --
5420: -- Check mandatory parameters have been set
5421: --
5422: hr_api.mandatory_arg_error
5423: (p_api_name => l_proc
5424: ,p_argument => 'effective_date'
5425: ,p_argument_value => p_effective_date
5426: );
5424: ,p_argument => 'effective_date'
5425: ,p_argument_value => p_effective_date
5426: );
5427: --
5428: hr_api.mandatory_arg_error
5429: (p_api_name => l_proc
5430: ,p_argument => 'validation_start_date'
5431: ,p_argument_value => p_validation_start_date
5432: );
5430: ,p_argument => 'validation_start_date'
5431: ,p_argument_value => p_validation_start_date
5432: );
5433: --
5434: hr_api.mandatory_arg_error
5435: (p_api_name => l_proc
5436: ,p_argument => 'validation_end_date'
5437: ,p_argument_value => p_validation_end_date
5438: );
5449: hr_utility.set_location(l_proc, 30);
5450: end if;
5451: --
5452: if ((l_api_updating and
5453: nvl(per_asg_shd.g_old_rec.employment_category, hr_api.g_varchar2) <>
5454: nvl(p_employment_category, hr_api.g_varchar2))
5455: or (NOT l_api_updating))
5456: then
5457: if g_debug then
5450: end if;
5451: --
5452: if ((l_api_updating and
5453: nvl(per_asg_shd.g_old_rec.employment_category, hr_api.g_varchar2) <>
5454: nvl(p_employment_category, hr_api.g_varchar2))
5455: or (NOT l_api_updating))
5456: then
5457: if g_debug then
5458: hr_utility.set_location(l_proc, 40);
5479: --
5480: -- Bug 1472162.
5481: --
5482: /*
5483: if hr_api.not_exists_in_dt_hr_lookups
5484: (p_effective_date => p_effective_date
5485: ,p_validation_start_date => p_validation_start_date
5486: ,p_validation_end_date => p_validation_end_date
5487: ,p_lookup_type => 'EMP_CAT'
5496: if g_debug then
5497: hr_utility.set_location(l_proc, 60);
5498: end if;
5499:
5500: if hr_api.not_exists_in_leg_lookups
5501: (p_effective_date => p_effective_date
5502: ,p_lookup_type => 'EMP_CAT'
5503: ,p_lookup_code => p_employment_category
5504: )
5583: end if;
5584: --
5585: -- Check mandatory parameters
5586: --
5587: hr_api.mandatory_arg_error
5588: (p_api_name => l_proc
5589: ,p_argument => 'effective_date'
5590: ,p_argument_value => p_effective_date
5591: );
5589: ,p_argument => 'effective_date'
5590: ,p_argument_value => p_effective_date
5591: );
5592: --
5593: hr_api.mandatory_arg_error
5594: (p_api_name => l_proc
5595: ,p_argument => 'validation_start_date'
5596: ,p_argument_value => p_validation_start_date
5597: );
5595: ,p_argument => 'validation_start_date'
5596: ,p_argument_value => p_validation_start_date
5597: );
5598: --
5599: hr_api.mandatory_arg_error
5600: (p_api_name => l_proc
5601: ,p_argument => 'validation_end_date'
5602: ,p_argument_value => p_validation_end_date
5603: );
5618: hr_utility.set_location(l_proc, 30);
5619: end if;
5620: --
5621: if ((l_api_updating and
5622: nvl(per_asg_shd.g_old_rec.frequency, hr_api.g_varchar2) <>
5623: nvl(p_frequency, hr_api.g_varchar2)) or
5624: (NOT l_api_updating))
5625: then
5626: if g_debug then
5619: end if;
5620: --
5621: if ((l_api_updating and
5622: nvl(per_asg_shd.g_old_rec.frequency, hr_api.g_varchar2) <>
5623: nvl(p_frequency, hr_api.g_varchar2)) or
5624: (NOT l_api_updating))
5625: then
5626: if g_debug then
5627: hr_utility.set_location(l_proc||' '||p_frequency, 40);
5635: -- type 'FREQUENCY' with an enabled flag set to 'Y' and that the
5636: -- effective start date of the assignment is between start date
5637: -- active and end date active in hr_lookups.
5638: --
5639: if hr_api.not_exists_in_dt_hr_lookups
5640: (p_effective_date => p_effective_date
5641: ,p_validation_start_date => p_validation_start_date
5642: ,p_validation_end_date => p_validation_end_date
5643: ,p_lookup_type => 'FREQUENCY'
5729: end if;
5730: --
5731: -- Check mandatory parameters have been set
5732: --
5733: hr_api.mandatory_arg_error
5734: (p_api_name => l_proc
5735: ,p_argument => 'primary flag'
5736: ,p_argument_value => p_primary_flag
5737: );
5798: select business_group_id
5799: from per_grades
5800: where grade_id = p_grade_id
5801: and p_validation_start_date
5802: between date_from and nvl(date_to, hr_api.g_eot);
5803: --
5804: begin
5805: if g_debug then
5806: hr_utility.set_location('Entering:'|| l_proc, 10);
5808: --
5809: --
5810: -- Check mandatory parameters have been set
5811: --
5812: hr_api.mandatory_arg_error
5813: (p_api_name => l_proc
5814: ,p_argument => 'effective_date'
5815: ,p_argument_value => p_effective_date
5816: );
5814: ,p_argument => 'effective_date'
5815: ,p_argument_value => p_effective_date
5816: );
5817: --
5818: hr_api.mandatory_arg_error
5819: (p_api_name => l_proc
5820: ,p_argument => 'validation_start_date'
5821: ,p_argument_value => p_validation_start_date
5822: );
5820: ,p_argument => 'validation_start_date'
5821: ,p_argument_value => p_validation_start_date
5822: );
5823: --
5824: hr_api.mandatory_arg_error
5825: (p_api_name => l_proc
5826: ,p_argument => 'validation_end_date'
5827: ,p_argument_value => p_validation_end_date
5828: );
5826: ,p_argument => 'validation_end_date'
5827: ,p_argument_value => p_validation_end_date
5828: );
5829: --
5830: hr_api.mandatory_arg_error
5831: (p_api_name => l_proc
5832: ,p_argument => 'business_group_id'
5833: ,p_argument_value => p_business_group_id
5834: );
5849: hr_utility.set_location(l_proc, 30);
5850: end if;
5851: --
5852: if ((l_api_updating and
5853: nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>
5854: nvl(p_grade_id, hr_api.g_number)) or
5855: (NOT l_api_updating)) then
5856: if g_debug then
5857: hr_utility.set_location(l_proc, 40);
5850: end if;
5851: --
5852: if ((l_api_updating and
5853: nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>
5854: nvl(p_grade_id, hr_api.g_number)) or
5855: (NOT l_api_updating)) then
5856: if g_debug then
5857: hr_utility.set_location(l_proc, 40);
5858: end if;
5949: from per_jobs_v
5950: where job_id = p_job_id
5951: and p_validation_start_date
5952: between date_from
5953: and nvl(date_to, hr_api.g_eot);
5954: */
5955: cursor csr_valid_job is
5956: select job.business_group_id
5957: from per_jobs job
5958: , per_job_groups jgr
5959: where job.job_id = p_job_id
5960: and (p_validation_start_date
5961: between job.date_from
5962: and nvl(job.date_to, hr_api.g_eot))
5963: and job.job_group_id = jgr.job_group_id
5964: and jgr.internal_name = 'HR_'||jgr.business_group_id
5965: and (jgr.business_group_id = job.business_group_id
5966: or jgr.business_group_id is null);
5974: --
5975: --
5976: -- Check mandatory arguments
5977: --
5978: hr_api.mandatory_arg_error
5979: (p_api_name => l_proc
5980: ,p_argument => 'effective_date'
5981: ,p_argument_value => p_effective_date
5982: );
5980: ,p_argument => 'effective_date'
5981: ,p_argument_value => p_effective_date
5982: );
5983: --
5984: hr_api.mandatory_arg_error
5985: (p_api_name => l_proc
5986: ,p_argument => 'validation_start_date'
5987: ,p_argument_value => p_validation_start_date
5988: );
5986: ,p_argument => 'validation_start_date'
5987: ,p_argument_value => p_validation_start_date
5988: );
5989: --
5990: hr_api.mandatory_arg_error
5991: (p_api_name => l_proc
5992: ,p_argument => 'validation_end_date'
5993: ,p_argument_value => p_validation_end_date
5994: );
6012: -- b) The value for job has changed
6013: --
6014: if ((l_api_updating and
6015: nvl(per_asg_shd.g_old_rec.job_id,
6016: hr_api.g_number) <> nvl(p_job_id, hr_api.g_number))
6017: or
6018: NOT l_api_updating) then
6019: if g_debug then
6020: hr_utility.set_location(l_proc, 40);
6102: from per_valid_grades
6103: where job_id = p_job_id
6104: and p_validation_start_date
6105: between date_from
6106: and nvl(date_to, hr_api.g_eot);
6107: --
6108: -- Bug 3566686 Ends Here
6109: --
6110: cursor csr_val_job_grade is
6113: where job_id = p_job_id
6114: and grade_id = p_grade_id
6115: and p_validation_start_date
6116: between date_from
6117: and nvl(date_to, hr_api.g_eot);
6118: --
6119: begin
6120: if g_debug then
6121: hr_utility.set_location('Entering:'|| l_proc, 10);
6127: ) then
6128: --
6129: -- Check mandatory arguments
6130: --
6131: hr_api.mandatory_arg_error
6132: (p_api_name => l_proc
6133: ,p_argument => 'effective_date'
6134: ,p_argument_value => p_effective_date
6135: );
6133: ,p_argument => 'effective_date'
6134: ,p_argument_value => p_effective_date
6135: );
6136: --
6137: hr_api.mandatory_arg_error
6138: (p_api_name => l_proc
6139: ,p_argument => 'validation_start_date'
6140: ,p_argument_value => p_validation_start_date
6141: );
6139: ,p_argument => 'validation_start_date'
6140: ,p_argument_value => p_validation_start_date
6141: );
6142: --
6143: hr_api.mandatory_arg_error
6144: (p_api_name => l_proc
6145: ,p_argument => 'validation_end_date'
6146: ,p_argument_value => p_validation_end_date
6147: );
6165: -- b) The value for job or grade has changed.
6166: --
6167: if (l_api_updating
6168: and
6169: ((nvl(per_asg_shd.g_old_rec.job_id, hr_api.g_number)
6170: <> nvl(p_job_id, hr_api.g_number))
6171: or
6172: (nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number)
6173: <> nvl(p_grade_id, hr_api.g_number))))
6166: --
6167: if (l_api_updating
6168: and
6169: ((nvl(per_asg_shd.g_old_rec.job_id, hr_api.g_number)
6170: <> nvl(p_job_id, hr_api.g_number))
6171: or
6172: (nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number)
6173: <> nvl(p_grade_id, hr_api.g_number))))
6174: or
6168: and
6169: ((nvl(per_asg_shd.g_old_rec.job_id, hr_api.g_number)
6170: <> nvl(p_job_id, hr_api.g_number))
6171: or
6172: (nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number)
6173: <> nvl(p_grade_id, hr_api.g_number))))
6174: or
6175: NOT l_api_updating then
6176: if g_debug then
6169: ((nvl(per_asg_shd.g_old_rec.job_id, hr_api.g_number)
6170: <> nvl(p_job_id, hr_api.g_number))
6171: or
6172: (nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number)
6173: <> nvl(p_grade_id, hr_api.g_number))))
6174: or
6175: NOT l_api_updating then
6176: if g_debug then
6177: hr_utility.set_location(l_proc, 40);
6277: --
6278: --
6279: -- Check mandatory parameters have been set
6280: --
6281: hr_api.mandatory_arg_error
6282: (p_api_name => l_proc
6283: ,p_argument => 'effective_date'
6284: ,p_argument_value => p_effective_date
6285: );
6283: ,p_argument => 'effective_date'
6284: ,p_argument_value => p_effective_date
6285: );
6286: --
6287: hr_api.mandatory_arg_error
6288: (p_api_name => l_proc
6289: ,p_argument => 'validation_start_date'
6290: ,p_argument_value => p_validation_start_date
6291: );
6289: ,p_argument => 'validation_start_date'
6290: ,p_argument_value => p_validation_start_date
6291: );
6292: --
6293: hr_api.mandatory_arg_error
6294: (p_api_name => l_proc
6295: ,p_argument => 'validation_end_date'
6296: ,p_argument_value => p_validation_end_date
6297: );
6312: hr_utility.set_location('Entering:'|| l_proc, 30);
6313: end if;
6314: --
6315: if ((l_api_updating and
6316: nvl(per_asg_shd.g_old_rec.location_id, hr_api.g_number) <>
6317: nvl(p_location_id, hr_api.g_number)) or
6318: (NOT l_api_updating))
6319: then
6320: --
6313: end if;
6314: --
6315: if ((l_api_updating and
6316: nvl(per_asg_shd.g_old_rec.location_id, hr_api.g_number) <>
6317: nvl(p_location_id, hr_api.g_number)) or
6318: (NOT l_api_updating))
6319: then
6320: --
6321: if g_debug then
6360: --
6361: -- Check if the assignment ESD is before the location inactive date
6362: -- on insert
6363: --
6364: if p_validation_start_date >= nvl(l_inactive_date,hr_api.g_eot)
6365: then
6366: --
6367: hr_utility.set_message(801, 'HR_51215_ASG_INACT_LOCATION');
6368: hr_multi_message.add
6409: end if;
6410: --
6411: -- Check mandatory parameters have been set
6412: --
6413: hr_api.mandatory_arg_error
6414: (p_api_name => l_proc
6415: ,p_argument => 'effective_date'
6416: ,p_argument_value => p_effective_date
6417: );
6415: ,p_argument => 'effective_date'
6416: ,p_argument_value => p_effective_date
6417: );
6418: --
6419: hr_api.mandatory_arg_error
6420: (p_api_name => l_proc
6421: ,p_argument => 'organization_id'
6422: ,p_argument_value => p_organization_id
6423: );
6438: hr_utility.set_location(l_proc, 30);
6439: end if;
6440: --
6441: if ((l_api_updating and
6442: nvl(per_asg_shd.g_old_rec.manager_flag, hr_api.g_varchar2) <>
6443: nvl(p_manager_flag, hr_api.g_varchar2))
6444: or
6445: (NOT l_api_updating))
6446: then
6439: end if;
6440: --
6441: if ((l_api_updating and
6442: nvl(per_asg_shd.g_old_rec.manager_flag, hr_api.g_varchar2) <>
6443: nvl(p_manager_flag, hr_api.g_varchar2))
6444: or
6445: (NOT l_api_updating))
6446: then
6447: if g_debug then
6577: ) then
6578: --
6579: -- Check mandatory parameters have been set
6580: --
6581: hr_api.mandatory_arg_error
6582: (p_api_name => l_proc
6583: ,p_argument => 'effective_date'
6584: ,p_argument_value => p_effective_date
6585: );
6600: hr_utility.set_location(l_proc, 30);
6601: end if;
6602: --
6603: if (l_api_updating and
6604: ((nvl(per_asg_shd.g_old_rec.frequency, hr_api.g_varchar2) <>
6605: nvl(p_frequency, hr_api.g_varchar2))
6606: or
6607: (nvl(per_asg_shd.g_old_rec.normal_hours, hr_api.g_number) <>
6608: nvl(p_normal_hours, hr_api.g_number))))
6601: end if;
6602: --
6603: if (l_api_updating and
6604: ((nvl(per_asg_shd.g_old_rec.frequency, hr_api.g_varchar2) <>
6605: nvl(p_frequency, hr_api.g_varchar2))
6606: or
6607: (nvl(per_asg_shd.g_old_rec.normal_hours, hr_api.g_number) <>
6608: nvl(p_normal_hours, hr_api.g_number))))
6609: or
6603: if (l_api_updating and
6604: ((nvl(per_asg_shd.g_old_rec.frequency, hr_api.g_varchar2) <>
6605: nvl(p_frequency, hr_api.g_varchar2))
6606: or
6607: (nvl(per_asg_shd.g_old_rec.normal_hours, hr_api.g_number) <>
6608: nvl(p_normal_hours, hr_api.g_number))))
6609: or
6610: (NOT l_api_updating)
6611: then
6604: ((nvl(per_asg_shd.g_old_rec.frequency, hr_api.g_varchar2) <>
6605: nvl(p_frequency, hr_api.g_varchar2))
6606: or
6607: (nvl(per_asg_shd.g_old_rec.normal_hours, hr_api.g_number) <>
6608: nvl(p_normal_hours, hr_api.g_number))))
6609: or
6610: (NOT l_api_updating)
6611: then
6612: if g_debug then
6712: --
6713: --
6714: -- Check mandatory parameters have been set
6715: --
6716: hr_api.mandatory_arg_error
6717: (p_api_name => l_proc
6718: ,p_argument => 'effective_date'
6719: ,p_argument_value => p_effective_date
6720: );
6718: ,p_argument => 'effective_date'
6719: ,p_argument_value => p_effective_date
6720: );
6721: --
6722: hr_api.mandatory_arg_error
6723: (p_api_name => l_proc
6724: ,p_argument => 'organization_id'
6725: ,p_argument_value => p_organization_id
6726: );
6724: ,p_argument => 'organization_id'
6725: ,p_argument_value => p_organization_id
6726: );
6727: --
6728: hr_api.mandatory_arg_error
6729: (p_api_name => l_proc
6730: ,p_argument => 'business_group_id'
6731: ,p_argument_value => p_business_group_id
6732: );
6730: ,p_argument => 'business_group_id'
6731: ,p_argument_value => p_business_group_id
6732: );
6733: --
6734: hr_api.mandatory_arg_error
6735: (p_api_name => l_proc
6736: ,p_argument => 'validation_start_date'
6737: ,p_argument_value => p_validation_start_date
6738: );
6736: ,p_argument => 'validation_start_date'
6737: ,p_argument_value => p_validation_start_date
6738: );
6739: --
6740: hr_api.mandatory_arg_error
6741: (p_api_name => l_proc
6742: ,p_argument => 'validation_end_date'
6743: ,p_argument_value => p_validation_end_date
6744: );
6940: end if;
6941: --
6942: -- Check mandatory parameters have been set
6943: --
6944: hr_api.mandatory_arg_error
6945: (p_api_name => l_proc
6946: ,p_argument => 'effective_date'
6947: ,p_argument_value => p_effective_date
6948: );
6950: hr_utility.set_location(l_proc, 20);
6951: end if;
6952: --
6953: if p_bargaining_unit_code is NOT NULL then
6954: if hr_api.not_exists_in_dt_hr_lookups
6955: (p_effective_date => p_effective_date
6956: ,p_validation_start_date => p_validation_start_date
6957: ,p_validation_end_date => p_validation_end_date
6958: ,p_lookup_type => 'BARGAINING_UNIT_CODE'
7045: --
7046: --
7047: -- Check mandatory parameters have been set
7048: --
7049: hr_api.mandatory_arg_error
7050: (p_api_name => l_proc
7051: ,p_argument => 'effective_date'
7052: ,p_argument_value => p_effective_date
7053: );
7066: --
7067: END IF;
7068: --
7069: if p_hourly_salaried_code is NOT NULL then
7070: if hr_api.not_exists_in_dt_hr_lookups
7071: (p_effective_date => p_effective_date
7072: ,p_validation_start_date => p_validation_start_date
7073: ,p_validation_end_date => p_validation_end_date
7074: ,p_lookup_type => 'HOURLY_SALARIED_CODE'
7142: end if;
7143: --
7144: -- Ensure that all the mandatory parameter are not null
7145: --
7146: hr_api.mandatory_arg_error(p_api_name => l_proc,
7147: p_argument => 'assignment_id',
7148: p_argument_value => p_assignment_id);
7149: --
7150: --
7147: p_argument => 'assignment_id',
7148: p_argument_value => p_assignment_id);
7149: --
7150: --
7151: if nvl(g_assignment_id, hr_api.g_number) = p_assignment_id then
7152: --
7153: -- The legislation code has already been found with a previous
7154: -- call to this function. Just return the value in the global
7155: -- variable.
7310: end if;
7311: --
7312: -- Check mandatory parameters have been set
7313: --
7314: hr_api.mandatory_arg_error
7315: (p_api_name => l_proc
7316: ,p_argument => 'effective_date'
7317: ,p_argument_value => p_effective_date
7318: );
7381: ) then
7382: --
7383: -- Check mandatory parameters have been set
7384: --
7385: hr_api.mandatory_arg_error
7386: (p_api_name => l_proc
7387: ,p_argument => 'effective_date'
7388: ,p_argument_value => p_effective_date
7389: );
7400: hr_utility.set_location(l_proc, 30);
7401: end if;
7402: --
7403: if (l_api_updating and
7404: (nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
7405: nvl(p_position_id, hr_api.g_number)))
7406: or
7407: (NOT l_api_updating)
7408: then
7401: end if;
7402: --
7403: if (l_api_updating and
7404: (nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
7405: nvl(p_position_id, hr_api.g_number)))
7406: or
7407: (NOT l_api_updating)
7408: then
7409: per_asg_bus1.chk_frozen_single_pos