[Home] [Help]
112: --
113: -- Access Status:
114: -- Internal Table Handler Use Only.
115: --
116: Procedure check_non_updateable_args(p_rec in per_asg_shd.g_rec_type
117: ,p_effective_date in date) is
118: --
119: l_proc varchar2(72) := g_package||'check_non_updateable_args';
120: --
125: --
126: -- Only proceed with validation if a row exists for
127: -- the current record in the HR Schema
128: --
129: if not per_asg_shd.api_updating
130: (p_assignment_id => p_rec.assignment_id
131: ,p_object_version_number => p_rec.object_version_number
132: ,p_effective_date => p_effective_date
133: ) 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'
148: ,p_base_table => per_asg_shd.g_tab_nam
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: );
150: end if;
151: if g_debug then
152: hr_utility.set_location(l_proc, 7);
151: if g_debug then
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
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: );
161: end if;
162: if g_debug then
163: hr_utility.set_location(l_proc, 8);
162: if g_debug then
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
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: );
172: end if;
173: if g_debug then
174: hr_utility.set_location(l_proc, 9);
173: if g_debug then
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
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: );
183: end if;
184: --
185: if g_debug then
187: end if;
188: --
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'
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: --
198: end if; */
199: -- End fix 3101091.
200: --
207: -- ----------------------------------------------------------------------------
208: -- |---------------------------< delete_validate >----------------------------|
209: -- ----------------------------------------------------------------------------
210: Procedure delete_validate
211: (p_rec in per_asg_shd.g_rec_type,
212: p_effective_date in date,
213: p_datetrack_mode in varchar2,
214: p_validation_start_date in date,
215: p_validation_end_date in date,
258: --
259: -- 4888485 starts here
260: --
261: -- Bug 5012157 : Commented out BEN type assgt checks and moved the logic to API.
262: /* if per_asg_shd.g_old_rec.assignment_type = 'B' then
263: if g_debug then
264: hr_utility.set_location('Selected assignment is of type Benifits', 10);
265: end if;
266: --
307: --
308: -- 4888485 Ends here
309: --
310: per_asg_bus2.chk_system_pers_type
311: (p_person_id => per_asg_shd.g_old_rec.person_id
312: ,p_validation_start_date => p_validation_start_date
313: ,p_validation_end_date => p_validation_end_date
314: ,p_datetrack_mode => p_datetrack_mode
315: ,p_effective_date => p_effective_date
335: end if;
336: --
337: per_asg_bus1.chk_future_primary
338: (p_assignment_id => p_rec.assignment_id
339: ,p_primary_flag => per_asg_shd.g_old_rec.primary_flag
340: ,p_datetrack_mode => p_datetrack_mode
341: ,p_effective_date => p_effective_date
342:
343: );
368: end if;
369: --
370: per_asg_bus2.chk_payroll_id
371: (p_assignment_id => p_rec.assignment_id
372: ,p_business_group_id => per_asg_shd.g_old_rec.business_group_id
373: ,p_person_id => per_asg_shd.g_old_rec.person_id
374: ,p_payroll_id => per_asg_shd.g_old_rec.payroll_id
375: ,p_assignment_type => per_asg_shd.g_old_rec.assignment_type
376: ,p_validation_start_date => p_validation_start_date
369: --
370: per_asg_bus2.chk_payroll_id
371: (p_assignment_id => p_rec.assignment_id
372: ,p_business_group_id => per_asg_shd.g_old_rec.business_group_id
373: ,p_person_id => per_asg_shd.g_old_rec.person_id
374: ,p_payroll_id => per_asg_shd.g_old_rec.payroll_id
375: ,p_assignment_type => per_asg_shd.g_old_rec.assignment_type
376: ,p_validation_start_date => p_validation_start_date
377: ,p_validation_end_date => p_validation_end_date
370: per_asg_bus2.chk_payroll_id
371: (p_assignment_id => p_rec.assignment_id
372: ,p_business_group_id => per_asg_shd.g_old_rec.business_group_id
373: ,p_person_id => per_asg_shd.g_old_rec.person_id
374: ,p_payroll_id => per_asg_shd.g_old_rec.payroll_id
375: ,p_assignment_type => per_asg_shd.g_old_rec.assignment_type
376: ,p_validation_start_date => p_validation_start_date
377: ,p_validation_end_date => p_validation_end_date
378: ,p_effective_date => p_effective_date
371: (p_assignment_id => p_rec.assignment_id
372: ,p_business_group_id => per_asg_shd.g_old_rec.business_group_id
373: ,p_person_id => per_asg_shd.g_old_rec.person_id
374: ,p_payroll_id => per_asg_shd.g_old_rec.payroll_id
375: ,p_assignment_type => per_asg_shd.g_old_rec.assignment_type
376: ,p_validation_start_date => p_validation_start_date
377: ,p_validation_end_date => p_validation_end_date
378: ,p_effective_date => p_effective_date
379: ,p_datetrack_mode => p_datetrack_mode
732: -- Internal Row Handler Use Only.
733: --
734: -- ---------------------------------------------------------------------------
735: procedure chk_df
736: (p_rec in per_asg_shd.g_rec_type
737: ,p_validate_df_flex in boolean default true) is
738: --
739: l_proc varchar2(72);
740: --
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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: )
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: (
982: -- ----------------------------------------------------------------------------
983: -- |---------------------------< insert_validate >----------------------------|
984: -- ----------------------------------------------------------------------------
985: Procedure insert_validate
986: (p_rec in out nocopy per_asg_shd.g_rec_type,
987: p_effective_date in date,
988: p_datetrack_mode in varchar2,
989: p_validation_start_date in date,
990: p_validation_end_date in date,
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: );
1025: --
1026: hr_multi_message.end_validation_set;
2071: -- ----------------------------------------------------------------------------
2072: -- |---------------------------< update_validate >----------------------------|
2073: -- ----------------------------------------------------------------------------
2074: Procedure update_validate
2075: (p_rec in out nocopy per_asg_shd.g_rec_type,
2076:
2077: p_effective_date in date,
2078: p_datetrack_mode in varchar2,
2079: p_validation_start_date in date,
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
2124: --
2125: hr_multi_message.end_validation_set;
2710: hr_utility.set_location(l_proc, 385);
2711: end if;
2712: --
2713: -- bug 5404529
2714: l_api_updating := per_asg_shd.api_updating
2715: (p_assignment_id => p_rec.assignment_id
2716: ,p_effective_date => p_effective_date
2717: ,p_object_version_number => p_rec.object_version_number
2718: );
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
3304: end if;
3305: --
3306: -- Check if the assignment is being updated.
3307: --
3308: l_api_updating := per_asg_shd.api_updating
3309: (p_assignment_id => p_assignment_id
3310: ,p_effective_date => p_effective_date
3311: ,p_object_version_number => p_object_version_number);
3312: if g_debug then
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
3353: end if;
3354: --
3355: -- Check if the existing application is set
3356: --
3357: If per_asg_shd.g_old_rec.application_id is not null then
3358: --
3359: hr_utility.set_message(801, 'HR_51213_ASG_INV_UPD_APL');
3360: hr_utility.raise_error;
3361: /*hr_multi_message.add
3528: -- a) The current g_old_rec is current and
3529: -- b) The value for assignment number has changed
3530: -- to a not null value
3531: --
3532: l_api_updating := per_asg_shd.api_updating
3533: (p_assignment_id => p_assignment_id
3534: ,p_effective_date => p_effective_date
3535: ,p_object_version_number => p_object_version_number
3536: );
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
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
3712: end if;
3713: --
3714: -- Check if inserting or updating the assignment
3715: --
3716: l_api_updating := per_asg_shd.api_updating
3717: (p_assignment_id => p_assignment_id
3718: ,p_effective_date => p_effective_date
3719: ,p_object_version_number => p_object_version_number);
3720: --
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
3947: -- |--------------------< chk_assignment_status_type_id >--------------------|
3948: -- ---------------------------------------------------------------------------
3949: --
3950: procedure chk_assignment_status_type_id
3951: (p_rec in per_asg_shd.g_rec_type
3952: ,p_effective_date in per_all_assignments_f.effective_start_date%TYPE
3953: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
3954: )
3955: is
4003: cursor csr_get_old_per_system_type is
4004: select per_system_status
4005: from per_assignment_status_types
4006: where assignment_status_type_id =
4007: per_asg_shd.g_old_rec.assignment_status_type_id;
4008: --
4009: -- Cursor to retrieve the effective start date of
4010: -- the first assignment datetracked instance with assignment
4011: -- status type PER_SYSTEM_STATUS of 'ACTIVE_ASSIGN'
4076: end if;
4077: --
4078: -- Check if the assignment is being updated.
4079: --
4080: l_api_updating := per_asg_shd.api_updating
4081: (p_assignment_id => p_rec.assignment_id
4082: ,p_effective_date => p_effective_date
4083: ,p_object_version_number => p_rec.object_version_number);
4084: if g_debug then
4113: -- Note that the if ... statement has to be split because of server
4114: -- parser limitations.
4115: --
4116: if (p_rec.recruiter_id <>
4117: per_asg_shd.g_old_rec.recruiter_id
4118: or p_rec.grade_id <>
4119: per_asg_shd.g_old_rec.grade_id
4120: or p_rec.position_id <>
4121: per_asg_shd.g_old_rec.position_id
4115: --
4116: if (p_rec.recruiter_id <>
4117: per_asg_shd.g_old_rec.recruiter_id
4118: or p_rec.grade_id <>
4119: per_asg_shd.g_old_rec.grade_id
4120: or p_rec.position_id <>
4121: per_asg_shd.g_old_rec.position_id
4122: or p_rec.job_id <>
4123: per_asg_shd.g_old_rec.job_id
4117: per_asg_shd.g_old_rec.recruiter_id
4118: or p_rec.grade_id <>
4119: per_asg_shd.g_old_rec.grade_id
4120: or p_rec.position_id <>
4121: per_asg_shd.g_old_rec.position_id
4122: or p_rec.job_id <>
4123: per_asg_shd.g_old_rec.job_id
4124: or p_rec.payroll_id <>
4125: per_asg_shd.g_old_rec.payroll_id
4119: per_asg_shd.g_old_rec.grade_id
4120: or p_rec.position_id <>
4121: per_asg_shd.g_old_rec.position_id
4122: or p_rec.job_id <>
4123: per_asg_shd.g_old_rec.job_id
4124: or p_rec.payroll_id <>
4125: per_asg_shd.g_old_rec.payroll_id
4126: or p_rec.location_id <>
4127: per_asg_shd.g_old_rec.location_id
4121: per_asg_shd.g_old_rec.position_id
4122: or p_rec.job_id <>
4123: per_asg_shd.g_old_rec.job_id
4124: or p_rec.payroll_id <>
4125: per_asg_shd.g_old_rec.payroll_id
4126: or p_rec.location_id <>
4127: per_asg_shd.g_old_rec.location_id
4128: or p_rec.person_referred_by_id <>
4129: per_asg_shd.g_old_rec.person_referred_by_id
4123: per_asg_shd.g_old_rec.job_id
4124: or p_rec.payroll_id <>
4125: per_asg_shd.g_old_rec.payroll_id
4126: or p_rec.location_id <>
4127: per_asg_shd.g_old_rec.location_id
4128: or p_rec.person_referred_by_id <>
4129: per_asg_shd.g_old_rec.person_referred_by_id
4130: --
4131: -- Fix for bug 3499996 starts here. coment out code.
4125: per_asg_shd.g_old_rec.payroll_id
4126: or p_rec.location_id <>
4127: per_asg_shd.g_old_rec.location_id
4128: or p_rec.person_referred_by_id <>
4129: per_asg_shd.g_old_rec.person_referred_by_id
4130: --
4131: -- Fix for bug 3499996 starts here. coment out code.
4132: --
4133: -- or p_rec.supervisor_id <>
4130: --
4131: -- Fix for bug 3499996 starts here. coment out code.
4132: --
4133: -- or p_rec.supervisor_id <>
4134: -- per_asg_shd.g_old_rec.supervisor_id
4135: --
4136: -- Fix for bug 3499996 ends here.
4137: --
4138: or p_rec.special_ceiling_step_id <>
4135: --
4136: -- Fix for bug 3499996 ends here.
4137: --
4138: or p_rec.special_ceiling_step_id <>
4139: per_asg_shd.g_old_rec.special_ceiling_step_id
4140: or p_rec.recruitment_activity_id <>
4141: per_asg_shd.g_old_rec.recruitment_activity_id
4142: or p_rec.source_organization_id <>
4143: per_asg_shd.g_old_rec.source_organization_id
4137: --
4138: or p_rec.special_ceiling_step_id <>
4139: per_asg_shd.g_old_rec.special_ceiling_step_id
4140: or p_rec.recruitment_activity_id <>
4141: per_asg_shd.g_old_rec.recruitment_activity_id
4142: or p_rec.source_organization_id <>
4143: per_asg_shd.g_old_rec.source_organization_id
4144: or p_rec.organization_id <>
4145: per_asg_shd.g_old_rec.organization_id
4139: per_asg_shd.g_old_rec.special_ceiling_step_id
4140: or p_rec.recruitment_activity_id <>
4141: per_asg_shd.g_old_rec.recruitment_activity_id
4142: or p_rec.source_organization_id <>
4143: per_asg_shd.g_old_rec.source_organization_id
4144: or p_rec.organization_id <>
4145: per_asg_shd.g_old_rec.organization_id
4146: or p_rec.people_group_id <>
4147: per_asg_shd.g_old_rec.people_group_id
4141: per_asg_shd.g_old_rec.recruitment_activity_id
4142: or p_rec.source_organization_id <>
4143: per_asg_shd.g_old_rec.source_organization_id
4144: or p_rec.organization_id <>
4145: per_asg_shd.g_old_rec.organization_id
4146: or p_rec.people_group_id <>
4147: per_asg_shd.g_old_rec.people_group_id
4148: -- Bug 4190473
4149: --or p_rec.soft_coding_keyflex_id <>
4143: per_asg_shd.g_old_rec.source_organization_id
4144: or p_rec.organization_id <>
4145: per_asg_shd.g_old_rec.organization_id
4146: or p_rec.people_group_id <>
4147: per_asg_shd.g_old_rec.people_group_id
4148: -- Bug 4190473
4149: --or p_rec.soft_coding_keyflex_id <>
4150: -- per_asg_shd.g_old_rec.soft_coding_keyflex_id
4151: or p_rec.vacancy_id <>
4146: or p_rec.people_group_id <>
4147: per_asg_shd.g_old_rec.people_group_id
4148: -- Bug 4190473
4149: --or p_rec.soft_coding_keyflex_id <>
4150: -- per_asg_shd.g_old_rec.soft_coding_keyflex_id
4151: or p_rec.vacancy_id <>
4152: per_asg_shd.g_old_rec.vacancy_id
4153: or p_rec.pay_basis_id <>
4154: per_asg_shd.g_old_rec.pay_basis_id
4148: -- Bug 4190473
4149: --or p_rec.soft_coding_keyflex_id <>
4150: -- per_asg_shd.g_old_rec.soft_coding_keyflex_id
4151: or p_rec.vacancy_id <>
4152: per_asg_shd.g_old_rec.vacancy_id
4153: or p_rec.pay_basis_id <>
4154: per_asg_shd.g_old_rec.pay_basis_id
4155: or p_rec.application_id <>
4156: per_asg_shd.g_old_rec.application_id
4150: -- per_asg_shd.g_old_rec.soft_coding_keyflex_id
4151: or p_rec.vacancy_id <>
4152: per_asg_shd.g_old_rec.vacancy_id
4153: or p_rec.pay_basis_id <>
4154: per_asg_shd.g_old_rec.pay_basis_id
4155: or p_rec.application_id <>
4156: per_asg_shd.g_old_rec.application_id
4157: or p_rec.assignment_number <>
4158: per_asg_shd.g_old_rec.assignment_number
4152: per_asg_shd.g_old_rec.vacancy_id
4153: or p_rec.pay_basis_id <>
4154: per_asg_shd.g_old_rec.pay_basis_id
4155: or p_rec.application_id <>
4156: per_asg_shd.g_old_rec.application_id
4157: or p_rec.assignment_number <>
4158: per_asg_shd.g_old_rec.assignment_number
4159: or p_rec.change_reason <>
4160: per_asg_shd.g_old_rec.change_reason
4154: per_asg_shd.g_old_rec.pay_basis_id
4155: or p_rec.application_id <>
4156: per_asg_shd.g_old_rec.application_id
4157: or p_rec.assignment_number <>
4158: per_asg_shd.g_old_rec.assignment_number
4159: or p_rec.change_reason <>
4160: per_asg_shd.g_old_rec.change_reason
4161: or p_rec.comment_text <>
4162: per_asg_shd.g_old_rec.comment_text
4156: per_asg_shd.g_old_rec.application_id
4157: or p_rec.assignment_number <>
4158: per_asg_shd.g_old_rec.assignment_number
4159: or p_rec.change_reason <>
4160: per_asg_shd.g_old_rec.change_reason
4161: or p_rec.comment_text <>
4162: per_asg_shd.g_old_rec.comment_text
4163: or p_rec.date_probation_end <>
4164: per_asg_shd.g_old_rec.date_probation_end
4158: per_asg_shd.g_old_rec.assignment_number
4159: or p_rec.change_reason <>
4160: per_asg_shd.g_old_rec.change_reason
4161: or p_rec.comment_text <>
4162: per_asg_shd.g_old_rec.comment_text
4163: or p_rec.date_probation_end <>
4164: per_asg_shd.g_old_rec.date_probation_end
4165: or p_rec.default_code_comb_id <>
4166: per_asg_shd.g_old_rec.default_code_comb_id
4160: per_asg_shd.g_old_rec.change_reason
4161: or p_rec.comment_text <>
4162: per_asg_shd.g_old_rec.comment_text
4163: or p_rec.date_probation_end <>
4164: per_asg_shd.g_old_rec.date_probation_end
4165: or p_rec.default_code_comb_id <>
4166: per_asg_shd.g_old_rec.default_code_comb_id
4167: or p_rec.employment_category <>
4168: per_asg_shd.g_old_rec.employment_category
4162: per_asg_shd.g_old_rec.comment_text
4163: or p_rec.date_probation_end <>
4164: per_asg_shd.g_old_rec.date_probation_end
4165: or p_rec.default_code_comb_id <>
4166: per_asg_shd.g_old_rec.default_code_comb_id
4167: or p_rec.employment_category <>
4168: per_asg_shd.g_old_rec.employment_category
4169: or p_rec.frequency <>
4170: per_asg_shd.g_old_rec.frequency
4164: per_asg_shd.g_old_rec.date_probation_end
4165: or p_rec.default_code_comb_id <>
4166: per_asg_shd.g_old_rec.default_code_comb_id
4167: or p_rec.employment_category <>
4168: per_asg_shd.g_old_rec.employment_category
4169: or p_rec.frequency <>
4170: per_asg_shd.g_old_rec.frequency
4171: or p_rec.internal_address_line <>
4172: per_asg_shd.g_old_rec.internal_address_line
4166: per_asg_shd.g_old_rec.default_code_comb_id
4167: or p_rec.employment_category <>
4168: per_asg_shd.g_old_rec.employment_category
4169: or p_rec.frequency <>
4170: per_asg_shd.g_old_rec.frequency
4171: or p_rec.internal_address_line <>
4172: per_asg_shd.g_old_rec.internal_address_line
4173: or p_rec.manager_flag <>
4174: per_asg_shd.g_old_rec.manager_flag
4168: per_asg_shd.g_old_rec.employment_category
4169: or p_rec.frequency <>
4170: per_asg_shd.g_old_rec.frequency
4171: or p_rec.internal_address_line <>
4172: per_asg_shd.g_old_rec.internal_address_line
4173: or p_rec.manager_flag <>
4174: per_asg_shd.g_old_rec.manager_flag
4175: or p_rec.normal_hours <>
4176: per_asg_shd.g_old_rec.normal_hours
4170: per_asg_shd.g_old_rec.frequency
4171: or p_rec.internal_address_line <>
4172: per_asg_shd.g_old_rec.internal_address_line
4173: or p_rec.manager_flag <>
4174: per_asg_shd.g_old_rec.manager_flag
4175: or p_rec.normal_hours <>
4176: per_asg_shd.g_old_rec.normal_hours
4177: or p_rec.perf_review_period <>
4178: per_asg_shd.g_old_rec.perf_review_period
4172: per_asg_shd.g_old_rec.internal_address_line
4173: or p_rec.manager_flag <>
4174: per_asg_shd.g_old_rec.manager_flag
4175: or p_rec.normal_hours <>
4176: per_asg_shd.g_old_rec.normal_hours
4177: or p_rec.perf_review_period <>
4178: per_asg_shd.g_old_rec.perf_review_period
4179: or p_rec.perf_review_period_frequency <>
4180: per_asg_shd.g_old_rec.perf_review_period_frequency
4174: per_asg_shd.g_old_rec.manager_flag
4175: or p_rec.normal_hours <>
4176: per_asg_shd.g_old_rec.normal_hours
4177: or p_rec.perf_review_period <>
4178: per_asg_shd.g_old_rec.perf_review_period
4179: or p_rec.perf_review_period_frequency <>
4180: per_asg_shd.g_old_rec.perf_review_period_frequency
4181: or p_rec.probation_period <>
4182: per_asg_shd.g_old_rec.probation_period
4176: per_asg_shd.g_old_rec.normal_hours
4177: or p_rec.perf_review_period <>
4178: per_asg_shd.g_old_rec.perf_review_period
4179: or p_rec.perf_review_period_frequency <>
4180: per_asg_shd.g_old_rec.perf_review_period_frequency
4181: or p_rec.probation_period <>
4182: per_asg_shd.g_old_rec.probation_period
4183: or p_rec.probation_unit <>
4184: per_asg_shd.g_old_rec.probation_unit
4178: per_asg_shd.g_old_rec.perf_review_period
4179: or p_rec.perf_review_period_frequency <>
4180: per_asg_shd.g_old_rec.perf_review_period_frequency
4181: or p_rec.probation_period <>
4182: per_asg_shd.g_old_rec.probation_period
4183: or p_rec.probation_unit <>
4184: per_asg_shd.g_old_rec.probation_unit
4185: or p_rec.sal_review_period <>
4186: per_asg_shd.g_old_rec.sal_review_period
4180: per_asg_shd.g_old_rec.perf_review_period_frequency
4181: or p_rec.probation_period <>
4182: per_asg_shd.g_old_rec.probation_period
4183: or p_rec.probation_unit <>
4184: per_asg_shd.g_old_rec.probation_unit
4185: or p_rec.sal_review_period <>
4186: per_asg_shd.g_old_rec.sal_review_period
4187: or p_rec.sal_review_period_frequency <>
4188: per_asg_shd.g_old_rec.sal_review_period_frequency
4182: per_asg_shd.g_old_rec.probation_period
4183: or p_rec.probation_unit <>
4184: per_asg_shd.g_old_rec.probation_unit
4185: or p_rec.sal_review_period <>
4186: per_asg_shd.g_old_rec.sal_review_period
4187: or p_rec.sal_review_period_frequency <>
4188: per_asg_shd.g_old_rec.sal_review_period_frequency
4189: or p_rec.set_of_books_id <>
4190: per_asg_shd.g_old_rec.set_of_books_id
4184: per_asg_shd.g_old_rec.probation_unit
4185: or p_rec.sal_review_period <>
4186: per_asg_shd.g_old_rec.sal_review_period
4187: or p_rec.sal_review_period_frequency <>
4188: per_asg_shd.g_old_rec.sal_review_period_frequency
4189: or p_rec.set_of_books_id <>
4190: per_asg_shd.g_old_rec.set_of_books_id
4191: or p_rec.source_type <>
4192: per_asg_shd.g_old_rec.source_type
4186: per_asg_shd.g_old_rec.sal_review_period
4187: or p_rec.sal_review_period_frequency <>
4188: per_asg_shd.g_old_rec.sal_review_period_frequency
4189: or p_rec.set_of_books_id <>
4190: per_asg_shd.g_old_rec.set_of_books_id
4191: or p_rec.source_type <>
4192: per_asg_shd.g_old_rec.source_type
4193: or p_rec.time_normal_finish <>
4194: per_asg_shd.g_old_rec.time_normal_finish
4188: per_asg_shd.g_old_rec.sal_review_period_frequency
4189: or p_rec.set_of_books_id <>
4190: per_asg_shd.g_old_rec.set_of_books_id
4191: or p_rec.source_type <>
4192: per_asg_shd.g_old_rec.source_type
4193: or p_rec.time_normal_finish <>
4194: per_asg_shd.g_old_rec.time_normal_finish
4195: or p_rec.time_normal_start <>
4196: per_asg_shd.g_old_rec.time_normal_start
4190: per_asg_shd.g_old_rec.set_of_books_id
4191: or p_rec.source_type <>
4192: per_asg_shd.g_old_rec.source_type
4193: or p_rec.time_normal_finish <>
4194: per_asg_shd.g_old_rec.time_normal_finish
4195: or p_rec.time_normal_start <>
4196: per_asg_shd.g_old_rec.time_normal_start
4197: or p_rec.bargaining_unit_code <>
4198: per_asg_shd.g_old_rec.bargaining_unit_code
4192: per_asg_shd.g_old_rec.source_type
4193: or p_rec.time_normal_finish <>
4194: per_asg_shd.g_old_rec.time_normal_finish
4195: or p_rec.time_normal_start <>
4196: per_asg_shd.g_old_rec.time_normal_start
4197: or p_rec.bargaining_unit_code <>
4198: per_asg_shd.g_old_rec.bargaining_unit_code
4199: or p_rec.labour_union_member_flag <>
4200: per_asg_shd.g_old_rec.labour_union_member_flag
4194: per_asg_shd.g_old_rec.time_normal_finish
4195: or p_rec.time_normal_start <>
4196: per_asg_shd.g_old_rec.time_normal_start
4197: or p_rec.bargaining_unit_code <>
4198: per_asg_shd.g_old_rec.bargaining_unit_code
4199: or p_rec.labour_union_member_flag <>
4200: per_asg_shd.g_old_rec.labour_union_member_flag
4201: or p_rec.hourly_salaried_code <>
4202: per_asg_shd.g_old_rec.hourly_salaried_code
4196: per_asg_shd.g_old_rec.time_normal_start
4197: or p_rec.bargaining_unit_code <>
4198: per_asg_shd.g_old_rec.bargaining_unit_code
4199: or p_rec.labour_union_member_flag <>
4200: per_asg_shd.g_old_rec.labour_union_member_flag
4201: or p_rec.hourly_salaried_code <>
4202: per_asg_shd.g_old_rec.hourly_salaried_code
4203: or p_rec.request_id <>
4204: per_asg_shd.g_old_rec.request_id
4198: per_asg_shd.g_old_rec.bargaining_unit_code
4199: or p_rec.labour_union_member_flag <>
4200: per_asg_shd.g_old_rec.labour_union_member_flag
4201: or p_rec.hourly_salaried_code <>
4202: per_asg_shd.g_old_rec.hourly_salaried_code
4203: or p_rec.request_id <>
4204: per_asg_shd.g_old_rec.request_id
4205: or p_rec.program_application_id <>
4206: per_asg_shd.g_old_rec.program_application_id
4200: per_asg_shd.g_old_rec.labour_union_member_flag
4201: or p_rec.hourly_salaried_code <>
4202: per_asg_shd.g_old_rec.hourly_salaried_code
4203: or p_rec.request_id <>
4204: per_asg_shd.g_old_rec.request_id
4205: or p_rec.program_application_id <>
4206: per_asg_shd.g_old_rec.program_application_id
4207: or p_rec.program_id <>
4208: per_asg_shd.g_old_rec.program_id
4202: per_asg_shd.g_old_rec.hourly_salaried_code
4203: or p_rec.request_id <>
4204: per_asg_shd.g_old_rec.request_id
4205: or p_rec.program_application_id <>
4206: per_asg_shd.g_old_rec.program_application_id
4207: or p_rec.program_id <>
4208: per_asg_shd.g_old_rec.program_id
4209: or p_rec.program_update_date <>
4210: per_asg_shd.g_old_rec.program_update_date
4204: per_asg_shd.g_old_rec.request_id
4205: or p_rec.program_application_id <>
4206: per_asg_shd.g_old_rec.program_application_id
4207: or p_rec.program_id <>
4208: per_asg_shd.g_old_rec.program_id
4209: or p_rec.program_update_date <>
4210: per_asg_shd.g_old_rec.program_update_date
4211: or p_rec.ass_attribute_category <>
4212: per_asg_shd.g_old_rec.ass_attribute_category
4206: per_asg_shd.g_old_rec.program_application_id
4207: or p_rec.program_id <>
4208: per_asg_shd.g_old_rec.program_id
4209: or p_rec.program_update_date <>
4210: per_asg_shd.g_old_rec.program_update_date
4211: or p_rec.ass_attribute_category <>
4212: per_asg_shd.g_old_rec.ass_attribute_category
4213: )
4214: then
4208: per_asg_shd.g_old_rec.program_id
4209: or p_rec.program_update_date <>
4210: per_asg_shd.g_old_rec.program_update_date
4211: or p_rec.ass_attribute_category <>
4212: per_asg_shd.g_old_rec.ass_attribute_category
4213: )
4214: then
4215: --
4216: hr_utility.set_message(801, 'HR_7946_ASG_INV_TERM_ASS_UPD');
4219: );
4220: --
4221: -- fix for bug 4557189. Commented out code.
4222: elsif (
4223: /*p_rec.ass_attribute1 <> per_asg_shd.g_old_rec.ass_attribute1
4224: or p_rec.ass_attribute2 <> per_asg_shd.g_old_rec.ass_attribute2
4225: or p_rec.ass_attribute3 <> per_asg_shd.g_old_rec.ass_attribute3
4226: or p_rec.ass_attribute4 <> per_asg_shd.g_old_rec.ass_attribute4
4227: or p_rec.ass_attribute5 <> per_asg_shd.g_old_rec.ass_attribute5
4220: --
4221: -- fix for bug 4557189. Commented out code.
4222: elsif (
4223: /*p_rec.ass_attribute1 <> per_asg_shd.g_old_rec.ass_attribute1
4224: or p_rec.ass_attribute2 <> per_asg_shd.g_old_rec.ass_attribute2
4225: or p_rec.ass_attribute3 <> per_asg_shd.g_old_rec.ass_attribute3
4226: or p_rec.ass_attribute4 <> per_asg_shd.g_old_rec.ass_attribute4
4227: or p_rec.ass_attribute5 <> per_asg_shd.g_old_rec.ass_attribute5
4228: or p_rec.ass_attribute6 <> per_asg_shd.g_old_rec.ass_attribute6
4221: -- fix for bug 4557189. Commented out code.
4222: elsif (
4223: /*p_rec.ass_attribute1 <> per_asg_shd.g_old_rec.ass_attribute1
4224: or p_rec.ass_attribute2 <> per_asg_shd.g_old_rec.ass_attribute2
4225: or p_rec.ass_attribute3 <> per_asg_shd.g_old_rec.ass_attribute3
4226: or p_rec.ass_attribute4 <> per_asg_shd.g_old_rec.ass_attribute4
4227: or p_rec.ass_attribute5 <> per_asg_shd.g_old_rec.ass_attribute5
4228: or p_rec.ass_attribute6 <> per_asg_shd.g_old_rec.ass_attribute6
4229: or p_rec.ass_attribute7 <> per_asg_shd.g_old_rec.ass_attribute7
4222: elsif (
4223: /*p_rec.ass_attribute1 <> per_asg_shd.g_old_rec.ass_attribute1
4224: or p_rec.ass_attribute2 <> per_asg_shd.g_old_rec.ass_attribute2
4225: or p_rec.ass_attribute3 <> per_asg_shd.g_old_rec.ass_attribute3
4226: or p_rec.ass_attribute4 <> per_asg_shd.g_old_rec.ass_attribute4
4227: or p_rec.ass_attribute5 <> per_asg_shd.g_old_rec.ass_attribute5
4228: or p_rec.ass_attribute6 <> per_asg_shd.g_old_rec.ass_attribute6
4229: or p_rec.ass_attribute7 <> per_asg_shd.g_old_rec.ass_attribute7
4230: or p_rec.ass_attribute8 <> per_asg_shd.g_old_rec.ass_attribute8
4223: /*p_rec.ass_attribute1 <> per_asg_shd.g_old_rec.ass_attribute1
4224: or p_rec.ass_attribute2 <> per_asg_shd.g_old_rec.ass_attribute2
4225: or p_rec.ass_attribute3 <> per_asg_shd.g_old_rec.ass_attribute3
4226: or p_rec.ass_attribute4 <> per_asg_shd.g_old_rec.ass_attribute4
4227: or p_rec.ass_attribute5 <> per_asg_shd.g_old_rec.ass_attribute5
4228: or p_rec.ass_attribute6 <> per_asg_shd.g_old_rec.ass_attribute6
4229: or p_rec.ass_attribute7 <> per_asg_shd.g_old_rec.ass_attribute7
4230: or p_rec.ass_attribute8 <> per_asg_shd.g_old_rec.ass_attribute8
4231: or p_rec.ass_attribute9 <> per_asg_shd.g_old_rec.ass_attribute9
4224: or p_rec.ass_attribute2 <> per_asg_shd.g_old_rec.ass_attribute2
4225: or p_rec.ass_attribute3 <> per_asg_shd.g_old_rec.ass_attribute3
4226: or p_rec.ass_attribute4 <> per_asg_shd.g_old_rec.ass_attribute4
4227: or p_rec.ass_attribute5 <> per_asg_shd.g_old_rec.ass_attribute5
4228: or p_rec.ass_attribute6 <> per_asg_shd.g_old_rec.ass_attribute6
4229: or p_rec.ass_attribute7 <> per_asg_shd.g_old_rec.ass_attribute7
4230: or p_rec.ass_attribute8 <> per_asg_shd.g_old_rec.ass_attribute8
4231: or p_rec.ass_attribute9 <> per_asg_shd.g_old_rec.ass_attribute9
4232: or p_rec.ass_attribute10 <> per_asg_shd.g_old_rec.ass_attribute10
4225: or p_rec.ass_attribute3 <> per_asg_shd.g_old_rec.ass_attribute3
4226: or p_rec.ass_attribute4 <> per_asg_shd.g_old_rec.ass_attribute4
4227: or p_rec.ass_attribute5 <> per_asg_shd.g_old_rec.ass_attribute5
4228: or p_rec.ass_attribute6 <> per_asg_shd.g_old_rec.ass_attribute6
4229: or p_rec.ass_attribute7 <> per_asg_shd.g_old_rec.ass_attribute7
4230: or p_rec.ass_attribute8 <> per_asg_shd.g_old_rec.ass_attribute8
4231: or p_rec.ass_attribute9 <> per_asg_shd.g_old_rec.ass_attribute9
4232: or p_rec.ass_attribute10 <> per_asg_shd.g_old_rec.ass_attribute10
4233: or p_rec.ass_attribute11 <> per_asg_shd.g_old_rec.ass_attribute11
4226: or p_rec.ass_attribute4 <> per_asg_shd.g_old_rec.ass_attribute4
4227: or p_rec.ass_attribute5 <> per_asg_shd.g_old_rec.ass_attribute5
4228: or p_rec.ass_attribute6 <> per_asg_shd.g_old_rec.ass_attribute6
4229: or p_rec.ass_attribute7 <> per_asg_shd.g_old_rec.ass_attribute7
4230: or p_rec.ass_attribute8 <> per_asg_shd.g_old_rec.ass_attribute8
4231: or p_rec.ass_attribute9 <> per_asg_shd.g_old_rec.ass_attribute9
4232: or p_rec.ass_attribute10 <> per_asg_shd.g_old_rec.ass_attribute10
4233: or p_rec.ass_attribute11 <> per_asg_shd.g_old_rec.ass_attribute11
4234: or p_rec.ass_attribute12 <> per_asg_shd.g_old_rec.ass_attribute12
4227: or p_rec.ass_attribute5 <> per_asg_shd.g_old_rec.ass_attribute5
4228: or p_rec.ass_attribute6 <> per_asg_shd.g_old_rec.ass_attribute6
4229: or p_rec.ass_attribute7 <> per_asg_shd.g_old_rec.ass_attribute7
4230: or p_rec.ass_attribute8 <> per_asg_shd.g_old_rec.ass_attribute8
4231: or p_rec.ass_attribute9 <> per_asg_shd.g_old_rec.ass_attribute9
4232: or p_rec.ass_attribute10 <> per_asg_shd.g_old_rec.ass_attribute10
4233: or p_rec.ass_attribute11 <> per_asg_shd.g_old_rec.ass_attribute11
4234: or p_rec.ass_attribute12 <> per_asg_shd.g_old_rec.ass_attribute12
4235: or p_rec.ass_attribute13 <> per_asg_shd.g_old_rec.ass_attribute13
4228: or p_rec.ass_attribute6 <> per_asg_shd.g_old_rec.ass_attribute6
4229: or p_rec.ass_attribute7 <> per_asg_shd.g_old_rec.ass_attribute7
4230: or p_rec.ass_attribute8 <> per_asg_shd.g_old_rec.ass_attribute8
4231: or p_rec.ass_attribute9 <> per_asg_shd.g_old_rec.ass_attribute9
4232: or p_rec.ass_attribute10 <> per_asg_shd.g_old_rec.ass_attribute10
4233: or p_rec.ass_attribute11 <> per_asg_shd.g_old_rec.ass_attribute11
4234: or p_rec.ass_attribute12 <> per_asg_shd.g_old_rec.ass_attribute12
4235: or p_rec.ass_attribute13 <> per_asg_shd.g_old_rec.ass_attribute13
4236: or p_rec.ass_attribute14 <> per_asg_shd.g_old_rec.ass_attribute14
4229: or p_rec.ass_attribute7 <> per_asg_shd.g_old_rec.ass_attribute7
4230: or p_rec.ass_attribute8 <> per_asg_shd.g_old_rec.ass_attribute8
4231: or p_rec.ass_attribute9 <> per_asg_shd.g_old_rec.ass_attribute9
4232: or p_rec.ass_attribute10 <> per_asg_shd.g_old_rec.ass_attribute10
4233: or p_rec.ass_attribute11 <> per_asg_shd.g_old_rec.ass_attribute11
4234: or p_rec.ass_attribute12 <> per_asg_shd.g_old_rec.ass_attribute12
4235: or p_rec.ass_attribute13 <> per_asg_shd.g_old_rec.ass_attribute13
4236: or p_rec.ass_attribute14 <> per_asg_shd.g_old_rec.ass_attribute14
4237: or p_rec.ass_attribute15 <> per_asg_shd.g_old_rec.ass_attribute15
4230: or p_rec.ass_attribute8 <> per_asg_shd.g_old_rec.ass_attribute8
4231: or p_rec.ass_attribute9 <> per_asg_shd.g_old_rec.ass_attribute9
4232: or p_rec.ass_attribute10 <> per_asg_shd.g_old_rec.ass_attribute10
4233: or p_rec.ass_attribute11 <> per_asg_shd.g_old_rec.ass_attribute11
4234: or p_rec.ass_attribute12 <> per_asg_shd.g_old_rec.ass_attribute12
4235: or p_rec.ass_attribute13 <> per_asg_shd.g_old_rec.ass_attribute13
4236: or p_rec.ass_attribute14 <> per_asg_shd.g_old_rec.ass_attribute14
4237: or p_rec.ass_attribute15 <> per_asg_shd.g_old_rec.ass_attribute15
4238: or p_rec.ass_attribute16 <> per_asg_shd.g_old_rec.ass_attribute16
4231: or p_rec.ass_attribute9 <> per_asg_shd.g_old_rec.ass_attribute9
4232: or p_rec.ass_attribute10 <> per_asg_shd.g_old_rec.ass_attribute10
4233: or p_rec.ass_attribute11 <> per_asg_shd.g_old_rec.ass_attribute11
4234: or p_rec.ass_attribute12 <> per_asg_shd.g_old_rec.ass_attribute12
4235: or p_rec.ass_attribute13 <> per_asg_shd.g_old_rec.ass_attribute13
4236: or p_rec.ass_attribute14 <> per_asg_shd.g_old_rec.ass_attribute14
4237: or p_rec.ass_attribute15 <> per_asg_shd.g_old_rec.ass_attribute15
4238: or p_rec.ass_attribute16 <> per_asg_shd.g_old_rec.ass_attribute16
4239: or p_rec.ass_attribute17 <> per_asg_shd.g_old_rec.ass_attribute17
4232: or p_rec.ass_attribute10 <> per_asg_shd.g_old_rec.ass_attribute10
4233: or p_rec.ass_attribute11 <> per_asg_shd.g_old_rec.ass_attribute11
4234: or p_rec.ass_attribute12 <> per_asg_shd.g_old_rec.ass_attribute12
4235: or p_rec.ass_attribute13 <> per_asg_shd.g_old_rec.ass_attribute13
4236: or p_rec.ass_attribute14 <> per_asg_shd.g_old_rec.ass_attribute14
4237: or p_rec.ass_attribute15 <> per_asg_shd.g_old_rec.ass_attribute15
4238: or p_rec.ass_attribute16 <> per_asg_shd.g_old_rec.ass_attribute16
4239: or p_rec.ass_attribute17 <> per_asg_shd.g_old_rec.ass_attribute17
4240: or p_rec.ass_attribute18 <> per_asg_shd.g_old_rec.ass_attribute18
4233: or p_rec.ass_attribute11 <> per_asg_shd.g_old_rec.ass_attribute11
4234: or p_rec.ass_attribute12 <> per_asg_shd.g_old_rec.ass_attribute12
4235: or p_rec.ass_attribute13 <> per_asg_shd.g_old_rec.ass_attribute13
4236: or p_rec.ass_attribute14 <> per_asg_shd.g_old_rec.ass_attribute14
4237: or p_rec.ass_attribute15 <> per_asg_shd.g_old_rec.ass_attribute15
4238: or p_rec.ass_attribute16 <> per_asg_shd.g_old_rec.ass_attribute16
4239: or p_rec.ass_attribute17 <> per_asg_shd.g_old_rec.ass_attribute17
4240: or p_rec.ass_attribute18 <> per_asg_shd.g_old_rec.ass_attribute18
4241: or p_rec.ass_attribute19 <> per_asg_shd.g_old_rec.ass_attribute19
4234: or p_rec.ass_attribute12 <> per_asg_shd.g_old_rec.ass_attribute12
4235: or p_rec.ass_attribute13 <> per_asg_shd.g_old_rec.ass_attribute13
4236: or p_rec.ass_attribute14 <> per_asg_shd.g_old_rec.ass_attribute14
4237: or p_rec.ass_attribute15 <> per_asg_shd.g_old_rec.ass_attribute15
4238: or p_rec.ass_attribute16 <> per_asg_shd.g_old_rec.ass_attribute16
4239: or p_rec.ass_attribute17 <> per_asg_shd.g_old_rec.ass_attribute17
4240: or p_rec.ass_attribute18 <> per_asg_shd.g_old_rec.ass_attribute18
4241: or p_rec.ass_attribute19 <> per_asg_shd.g_old_rec.ass_attribute19
4242: or p_rec.ass_attribute20 <> per_asg_shd.g_old_rec.ass_attribute20
4235: or p_rec.ass_attribute13 <> per_asg_shd.g_old_rec.ass_attribute13
4236: or p_rec.ass_attribute14 <> per_asg_shd.g_old_rec.ass_attribute14
4237: or p_rec.ass_attribute15 <> per_asg_shd.g_old_rec.ass_attribute15
4238: or p_rec.ass_attribute16 <> per_asg_shd.g_old_rec.ass_attribute16
4239: or p_rec.ass_attribute17 <> per_asg_shd.g_old_rec.ass_attribute17
4240: or p_rec.ass_attribute18 <> per_asg_shd.g_old_rec.ass_attribute18
4241: or p_rec.ass_attribute19 <> per_asg_shd.g_old_rec.ass_attribute19
4242: or p_rec.ass_attribute20 <> per_asg_shd.g_old_rec.ass_attribute20
4243: or p_rec.ass_attribute21 <> per_asg_shd.g_old_rec.ass_attribute21
4236: or p_rec.ass_attribute14 <> per_asg_shd.g_old_rec.ass_attribute14
4237: or p_rec.ass_attribute15 <> per_asg_shd.g_old_rec.ass_attribute15
4238: or p_rec.ass_attribute16 <> per_asg_shd.g_old_rec.ass_attribute16
4239: or p_rec.ass_attribute17 <> per_asg_shd.g_old_rec.ass_attribute17
4240: or p_rec.ass_attribute18 <> per_asg_shd.g_old_rec.ass_attribute18
4241: or p_rec.ass_attribute19 <> per_asg_shd.g_old_rec.ass_attribute19
4242: or p_rec.ass_attribute20 <> per_asg_shd.g_old_rec.ass_attribute20
4243: or p_rec.ass_attribute21 <> per_asg_shd.g_old_rec.ass_attribute21
4244: or p_rec.ass_attribute22 <> per_asg_shd.g_old_rec.ass_attribute22
4237: or p_rec.ass_attribute15 <> per_asg_shd.g_old_rec.ass_attribute15
4238: or p_rec.ass_attribute16 <> per_asg_shd.g_old_rec.ass_attribute16
4239: or p_rec.ass_attribute17 <> per_asg_shd.g_old_rec.ass_attribute17
4240: or p_rec.ass_attribute18 <> per_asg_shd.g_old_rec.ass_attribute18
4241: or p_rec.ass_attribute19 <> per_asg_shd.g_old_rec.ass_attribute19
4242: or p_rec.ass_attribute20 <> per_asg_shd.g_old_rec.ass_attribute20
4243: or p_rec.ass_attribute21 <> per_asg_shd.g_old_rec.ass_attribute21
4244: or p_rec.ass_attribute22 <> per_asg_shd.g_old_rec.ass_attribute22
4245: or p_rec.ass_attribute23 <> per_asg_shd.g_old_rec.ass_attribute23
4238: or p_rec.ass_attribute16 <> per_asg_shd.g_old_rec.ass_attribute16
4239: or p_rec.ass_attribute17 <> per_asg_shd.g_old_rec.ass_attribute17
4240: or p_rec.ass_attribute18 <> per_asg_shd.g_old_rec.ass_attribute18
4241: or p_rec.ass_attribute19 <> per_asg_shd.g_old_rec.ass_attribute19
4242: or p_rec.ass_attribute20 <> per_asg_shd.g_old_rec.ass_attribute20
4243: or p_rec.ass_attribute21 <> per_asg_shd.g_old_rec.ass_attribute21
4244: or p_rec.ass_attribute22 <> per_asg_shd.g_old_rec.ass_attribute22
4245: or p_rec.ass_attribute23 <> per_asg_shd.g_old_rec.ass_attribute23
4246: or p_rec.ass_attribute24 <> per_asg_shd.g_old_rec.ass_attribute24
4239: or p_rec.ass_attribute17 <> per_asg_shd.g_old_rec.ass_attribute17
4240: or p_rec.ass_attribute18 <> per_asg_shd.g_old_rec.ass_attribute18
4241: or p_rec.ass_attribute19 <> per_asg_shd.g_old_rec.ass_attribute19
4242: or p_rec.ass_attribute20 <> per_asg_shd.g_old_rec.ass_attribute20
4243: or p_rec.ass_attribute21 <> per_asg_shd.g_old_rec.ass_attribute21
4244: or p_rec.ass_attribute22 <> per_asg_shd.g_old_rec.ass_attribute22
4245: or p_rec.ass_attribute23 <> per_asg_shd.g_old_rec.ass_attribute23
4246: or p_rec.ass_attribute24 <> per_asg_shd.g_old_rec.ass_attribute24
4247: or p_rec.ass_attribute25 <> per_asg_shd.g_old_rec.ass_attribute25
4240: or p_rec.ass_attribute18 <> per_asg_shd.g_old_rec.ass_attribute18
4241: or p_rec.ass_attribute19 <> per_asg_shd.g_old_rec.ass_attribute19
4242: or p_rec.ass_attribute20 <> per_asg_shd.g_old_rec.ass_attribute20
4243: or p_rec.ass_attribute21 <> per_asg_shd.g_old_rec.ass_attribute21
4244: or p_rec.ass_attribute22 <> per_asg_shd.g_old_rec.ass_attribute22
4245: or p_rec.ass_attribute23 <> per_asg_shd.g_old_rec.ass_attribute23
4246: or p_rec.ass_attribute24 <> per_asg_shd.g_old_rec.ass_attribute24
4247: or p_rec.ass_attribute25 <> per_asg_shd.g_old_rec.ass_attribute25
4248: or p_rec.ass_attribute26 <> per_asg_shd.g_old_rec.ass_attribute26
4241: or p_rec.ass_attribute19 <> per_asg_shd.g_old_rec.ass_attribute19
4242: or p_rec.ass_attribute20 <> per_asg_shd.g_old_rec.ass_attribute20
4243: or p_rec.ass_attribute21 <> per_asg_shd.g_old_rec.ass_attribute21
4244: or p_rec.ass_attribute22 <> per_asg_shd.g_old_rec.ass_attribute22
4245: or p_rec.ass_attribute23 <> per_asg_shd.g_old_rec.ass_attribute23
4246: or p_rec.ass_attribute24 <> per_asg_shd.g_old_rec.ass_attribute24
4247: or p_rec.ass_attribute25 <> per_asg_shd.g_old_rec.ass_attribute25
4248: or p_rec.ass_attribute26 <> per_asg_shd.g_old_rec.ass_attribute26
4249: or p_rec.ass_attribute27 <> per_asg_shd.g_old_rec.ass_attribute27
4242: or p_rec.ass_attribute20 <> per_asg_shd.g_old_rec.ass_attribute20
4243: or p_rec.ass_attribute21 <> per_asg_shd.g_old_rec.ass_attribute21
4244: or p_rec.ass_attribute22 <> per_asg_shd.g_old_rec.ass_attribute22
4245: or p_rec.ass_attribute23 <> per_asg_shd.g_old_rec.ass_attribute23
4246: or p_rec.ass_attribute24 <> per_asg_shd.g_old_rec.ass_attribute24
4247: or p_rec.ass_attribute25 <> per_asg_shd.g_old_rec.ass_attribute25
4248: or p_rec.ass_attribute26 <> per_asg_shd.g_old_rec.ass_attribute26
4249: or p_rec.ass_attribute27 <> per_asg_shd.g_old_rec.ass_attribute27
4250: or p_rec.ass_attribute28 <> per_asg_shd.g_old_rec.ass_attribute28
4243: or p_rec.ass_attribute21 <> per_asg_shd.g_old_rec.ass_attribute21
4244: or p_rec.ass_attribute22 <> per_asg_shd.g_old_rec.ass_attribute22
4245: or p_rec.ass_attribute23 <> per_asg_shd.g_old_rec.ass_attribute23
4246: or p_rec.ass_attribute24 <> per_asg_shd.g_old_rec.ass_attribute24
4247: or p_rec.ass_attribute25 <> per_asg_shd.g_old_rec.ass_attribute25
4248: or p_rec.ass_attribute26 <> per_asg_shd.g_old_rec.ass_attribute26
4249: or p_rec.ass_attribute27 <> per_asg_shd.g_old_rec.ass_attribute27
4250: or p_rec.ass_attribute28 <> per_asg_shd.g_old_rec.ass_attribute28
4251: or p_rec.ass_attribute29 <> per_asg_shd.g_old_rec.ass_attribute29
4244: or p_rec.ass_attribute22 <> per_asg_shd.g_old_rec.ass_attribute22
4245: or p_rec.ass_attribute23 <> per_asg_shd.g_old_rec.ass_attribute23
4246: or p_rec.ass_attribute24 <> per_asg_shd.g_old_rec.ass_attribute24
4247: or p_rec.ass_attribute25 <> per_asg_shd.g_old_rec.ass_attribute25
4248: or p_rec.ass_attribute26 <> per_asg_shd.g_old_rec.ass_attribute26
4249: or p_rec.ass_attribute27 <> per_asg_shd.g_old_rec.ass_attribute27
4250: or p_rec.ass_attribute28 <> per_asg_shd.g_old_rec.ass_attribute28
4251: or p_rec.ass_attribute29 <> per_asg_shd.g_old_rec.ass_attribute29
4252: or p_rec.ass_attribute30 <> per_asg_shd.g_old_rec.ass_attribute30
4245: or p_rec.ass_attribute23 <> per_asg_shd.g_old_rec.ass_attribute23
4246: or p_rec.ass_attribute24 <> per_asg_shd.g_old_rec.ass_attribute24
4247: or p_rec.ass_attribute25 <> per_asg_shd.g_old_rec.ass_attribute25
4248: or p_rec.ass_attribute26 <> per_asg_shd.g_old_rec.ass_attribute26
4249: or p_rec.ass_attribute27 <> per_asg_shd.g_old_rec.ass_attribute27
4250: or p_rec.ass_attribute28 <> per_asg_shd.g_old_rec.ass_attribute28
4251: or p_rec.ass_attribute29 <> per_asg_shd.g_old_rec.ass_attribute29
4252: or p_rec.ass_attribute30 <> per_asg_shd.g_old_rec.ass_attribute30
4253: or */
4246: or p_rec.ass_attribute24 <> per_asg_shd.g_old_rec.ass_attribute24
4247: or p_rec.ass_attribute25 <> per_asg_shd.g_old_rec.ass_attribute25
4248: or p_rec.ass_attribute26 <> per_asg_shd.g_old_rec.ass_attribute26
4249: or p_rec.ass_attribute27 <> per_asg_shd.g_old_rec.ass_attribute27
4250: or p_rec.ass_attribute28 <> per_asg_shd.g_old_rec.ass_attribute28
4251: or p_rec.ass_attribute29 <> per_asg_shd.g_old_rec.ass_attribute29
4252: or p_rec.ass_attribute30 <> per_asg_shd.g_old_rec.ass_attribute30
4253: or */
4254: p_rec.title <> per_asg_shd.g_old_rec.title
4247: or p_rec.ass_attribute25 <> per_asg_shd.g_old_rec.ass_attribute25
4248: or p_rec.ass_attribute26 <> per_asg_shd.g_old_rec.ass_attribute26
4249: or p_rec.ass_attribute27 <> per_asg_shd.g_old_rec.ass_attribute27
4250: or p_rec.ass_attribute28 <> per_asg_shd.g_old_rec.ass_attribute28
4251: or p_rec.ass_attribute29 <> per_asg_shd.g_old_rec.ass_attribute29
4252: or p_rec.ass_attribute30 <> per_asg_shd.g_old_rec.ass_attribute30
4253: or */
4254: p_rec.title <> per_asg_shd.g_old_rec.title
4255: )
4248: or p_rec.ass_attribute26 <> per_asg_shd.g_old_rec.ass_attribute26
4249: or p_rec.ass_attribute27 <> per_asg_shd.g_old_rec.ass_attribute27
4250: or p_rec.ass_attribute28 <> per_asg_shd.g_old_rec.ass_attribute28
4251: or p_rec.ass_attribute29 <> per_asg_shd.g_old_rec.ass_attribute29
4252: or p_rec.ass_attribute30 <> per_asg_shd.g_old_rec.ass_attribute30
4253: or */
4254: p_rec.title <> per_asg_shd.g_old_rec.title
4255: )
4256: then
4250: or p_rec.ass_attribute28 <> per_asg_shd.g_old_rec.ass_attribute28
4251: or p_rec.ass_attribute29 <> per_asg_shd.g_old_rec.ass_attribute29
4252: or p_rec.ass_attribute30 <> per_asg_shd.g_old_rec.ass_attribute30
4253: or */
4254: p_rec.title <> per_asg_shd.g_old_rec.title
4255: )
4256: then
4257: --
4258: hr_utility.set_message(801, 'HR_7946_ASG_INV_TERM_ASS_UPD');
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
4650: end if;
4651: --
4652: -- Check if inserting or updating the assignment
4653: --
4654: l_api_updating := per_asg_shd.api_updating
4655: (p_assignment_id => p_assignment_id
4656: ,p_effective_date => p_effective_date
4657: ,p_object_version_number => p_object_version_number
4658: );
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
4679: -- Extend restriction to allow assignment type 'O' (Offers)
4680: --
4681: If p_assignment_type not in('E','A','B','C','O') then
4682: --
4683: per_asg_shd.constraint_error
4684: (p_constraint_name => 'PER_ASS_ASSIGNMENT_TYPE_CHK');
4685: --
4686: end if;
4687: if g_debug then
4830: if g_debug then
4831: hr_utility.set_location(l_proc, 20);
4832: end if;
4833: --
4834: l_api_updating := per_asg_shd.api_updating
4835: (p_assignment_id => p_assignment_id
4836: ,p_effective_date => p_effective_date
4837: ,p_object_version_number => p_object_version_number
4838: );
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
5122: -- Only proceed with validation if :
5123: -- a) The current g_old_rec is current and
5124: -- b) The value for date probation end has changed
5125: --
5126: l_api_updating := per_asg_shd.api_updating
5127: (p_assignment_id => p_assignment_id
5128: ,p_effective_date => p_effective_date
5129: ,p_object_version_number => p_object_version_number);
5130: --
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
5251: -- Only proceed with validation if :
5252: -- a) The current g_old_rec is current and
5253: -- b) The value for default code comb has changed
5254: --
5255: l_api_updating := per_asg_shd.api_updating
5256: (p_assignment_id => p_assignment_id
5257: ,p_effective_date => p_effective_date
5258: ,p_object_version_number => p_object_version_number
5259: );
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
5439: if g_debug then
5440: hr_utility.set_location(l_proc, 20);
5441: end if;
5442: --
5443: l_api_updating := per_asg_shd.api_updating
5444: (p_assignment_id => p_assignment_id
5445: ,p_effective_date => p_effective_date
5446: ,p_object_version_number => p_object_version_number
5447: );
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
5608: -- Only proceed with validation if :
5609: -- a) The current g_old_rec is current and
5610: -- b) The value for frequency has changed
5611: --
5612: l_api_updating := per_asg_shd.api_updating
5613: (p_assignment_id => p_assignment_id
5614: ,p_effective_date => p_effective_date
5615: ,p_object_version_number => p_object_version_number
5616: );
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
5839: -- Only proceed with validation if :
5840: -- a) The current g_old_rec is current and
5841: -- b) The value for grade has changed
5842: --
5843: l_api_updating := per_asg_shd.api_updating
5844: (p_assignment_id => p_assignment_id
5845: ,p_effective_date => p_effective_date
5846: ,p_object_version_number => p_object_version_number
5847: );
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);
5997: end if;
5998: --
5999: -- Check if the assignment is being updated.
6000: --
6001: l_api_updating := per_asg_shd.api_updating
6002: (p_assignment_id => p_assignment_id
6003: ,p_effective_date => p_effective_date
6004: ,p_object_version_number => p_object_version_number
6005: );
6011: -- a) The current g_old_rec is current and
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
6150: end if;
6151: --
6152: -- Check if the assignment is being updated.
6153: --
6154: l_api_updating := per_asg_shd.api_updating
6155: (p_assignment_id => p_assignment_id
6156: ,p_effective_date => p_effective_date
6157: ,p_object_version_number => p_object_version_number
6158: );
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))))
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
6302: -- Only proceed with validation if :
6303: -- a) The current g_old_rec is current and
6304: -- b) The value for location_id has changed
6305: --
6306: l_api_updating := per_asg_shd.api_updating
6307: (p_assignment_id => p_assignment_id
6308: ,p_effective_date => p_effective_date
6309: ,p_object_version_number => p_object_version_number
6310: );
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: --
6428: -- Only proceed with validation if :
6429: -- a) The current g_old_rec is current and
6430: -- b) The value for manager flag has changed
6431: --
6432: l_api_updating := per_asg_shd.api_updating
6433: (p_assignment_id => p_assignment_id
6434: ,p_effective_date => p_effective_date
6435: ,p_object_version_number => p_object_version_number
6436: );
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
6453: If p_manager_flag is not null
6454: and p_manager_flag not in('Y','N')
6455: then
6456: --
6457: per_asg_shd.constraint_error
6458: (p_constraint_name => 'PER_ASS_MANAGER_FLAG_CHK');
6459: if g_debug then
6460: hr_utility.set_location(l_proc, 50);
6461: end if;
6530: -- Check if employee is being changed from
6531: -- a manager to a non-manager
6532: --
6533: if p_manager_flag = 'N' and
6534: per_asg_shd.g_old_rec.manager_flag = 'Y' then
6535: --
6536: p_no_managers_warning := TRUE;
6537: --
6538: end if;
6590: -- Only proceed with validation if :
6591: -- a) The current g_old_rec is current and
6592: -- b) The value for normal hours has changed
6593: --
6594: l_api_updating := per_asg_shd.api_updating
6595: (p_assignment_id => p_assignment_id
6596: ,p_effective_date => p_effective_date
6597: ,p_object_version_number => p_object_version_number
6598: );
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))))
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
6749: -- Only proceed with validation if :
6750: -- a) The current g_old_rec is current and
6751: -- b) The value for organization_id has changed
6752: --
6753: l_api_updating := per_asg_shd.api_updating
6754: (p_assignment_id => p_assignment_id
6755: ,p_effective_date => p_effective_date
6756: ,p_object_version_number => p_object_version_number
6757: );
6759: hr_utility.set_location(l_proc, 30);
6760: end if;
6761: --
6762: if (l_api_updating and
6763: per_asg_shd.g_old_rec.organization_id <> p_organization_id)
6764: or
6765: NOT l_api_updating
6766: then
6767: if g_debug then
7390: if g_debug then
7391: hr_utility.set_location(l_proc, 20);
7392: end if;
7393: --
7394: l_api_updating := per_asg_shd.api_updating
7395: (p_assignment_id => p_assignment_id
7396: ,p_effective_date => p_effective_date
7397: ,p_object_version_number => p_object_version_number
7398: );
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