[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: );
386: end if;
387: --
388: per_asg_bus2.chk_payroll_id
389: (p_assignment_id => p_rec.assignment_id
390: ,p_business_group_id => per_asg_shd.g_old_rec.business_group_id
391: ,p_person_id => per_asg_shd.g_old_rec.person_id
392: ,p_payroll_id => per_asg_shd.g_old_rec.payroll_id
393: ,p_assignment_type => per_asg_shd.g_old_rec.assignment_type
394: ,p_validation_start_date => p_validation_start_date
387: --
388: per_asg_bus2.chk_payroll_id
389: (p_assignment_id => p_rec.assignment_id
390: ,p_business_group_id => per_asg_shd.g_old_rec.business_group_id
391: ,p_person_id => per_asg_shd.g_old_rec.person_id
392: ,p_payroll_id => per_asg_shd.g_old_rec.payroll_id
393: ,p_assignment_type => per_asg_shd.g_old_rec.assignment_type
394: ,p_validation_start_date => p_validation_start_date
395: ,p_validation_end_date => p_validation_end_date
388: per_asg_bus2.chk_payroll_id
389: (p_assignment_id => p_rec.assignment_id
390: ,p_business_group_id => per_asg_shd.g_old_rec.business_group_id
391: ,p_person_id => per_asg_shd.g_old_rec.person_id
392: ,p_payroll_id => per_asg_shd.g_old_rec.payroll_id
393: ,p_assignment_type => per_asg_shd.g_old_rec.assignment_type
394: ,p_validation_start_date => p_validation_start_date
395: ,p_validation_end_date => p_validation_end_date
396: ,p_effective_date => p_effective_date
389: (p_assignment_id => p_rec.assignment_id
390: ,p_business_group_id => per_asg_shd.g_old_rec.business_group_id
391: ,p_person_id => per_asg_shd.g_old_rec.person_id
392: ,p_payroll_id => per_asg_shd.g_old_rec.payroll_id
393: ,p_assignment_type => per_asg_shd.g_old_rec.assignment_type
394: ,p_validation_start_date => p_validation_start_date
395: ,p_validation_end_date => p_validation_end_date
396: ,p_effective_date => p_effective_date
397: ,p_datetrack_mode => p_datetrack_mode
805: -- Internal Row Handler Use Only.
806: --
807: -- ---------------------------------------------------------------------------
808: procedure chk_df
809: (p_rec in per_asg_shd.g_rec_type
810: ,p_validate_df_flex in boolean default true) is
811: --
812: l_proc varchar2(72);
813: --
872: --
873: --
874: If ( (p_rec.assignment_id is not null)
875: and
876: ( (nvl(per_asg_shd.g_old_rec.ass_attribute_category, hr_api.g_varchar2) <>
877: nvl(p_rec.ass_attribute_category, hr_api.g_varchar2) or
878: nvl(per_asg_shd.g_old_rec.ass_attribute1, hr_api.g_varchar2) <>
879: nvl(p_rec.ass_attribute1, hr_api.g_varchar2) or
880: nvl(per_asg_shd.g_old_rec.ass_attribute2, hr_api.g_varchar2) <>
874: If ( (p_rec.assignment_id is not null)
875: and
876: ( (nvl(per_asg_shd.g_old_rec.ass_attribute_category, hr_api.g_varchar2) <>
877: nvl(p_rec.ass_attribute_category, hr_api.g_varchar2) or
878: nvl(per_asg_shd.g_old_rec.ass_attribute1, hr_api.g_varchar2) <>
879: nvl(p_rec.ass_attribute1, hr_api.g_varchar2) or
880: nvl(per_asg_shd.g_old_rec.ass_attribute2, hr_api.g_varchar2) <>
881: nvl(p_rec.ass_attribute2, hr_api.g_varchar2) or
882: nvl(per_asg_shd.g_old_rec.ass_attribute3, hr_api.g_varchar2) <>
876: ( (nvl(per_asg_shd.g_old_rec.ass_attribute_category, hr_api.g_varchar2) <>
877: nvl(p_rec.ass_attribute_category, hr_api.g_varchar2) or
878: nvl(per_asg_shd.g_old_rec.ass_attribute1, hr_api.g_varchar2) <>
879: nvl(p_rec.ass_attribute1, hr_api.g_varchar2) or
880: nvl(per_asg_shd.g_old_rec.ass_attribute2, hr_api.g_varchar2) <>
881: nvl(p_rec.ass_attribute2, hr_api.g_varchar2) or
882: nvl(per_asg_shd.g_old_rec.ass_attribute3, hr_api.g_varchar2) <>
883: nvl(p_rec.ass_attribute3, hr_api.g_varchar2) or
884: nvl(per_asg_shd.g_old_rec.ass_attribute4, hr_api.g_varchar2) <>
878: nvl(per_asg_shd.g_old_rec.ass_attribute1, hr_api.g_varchar2) <>
879: nvl(p_rec.ass_attribute1, hr_api.g_varchar2) or
880: nvl(per_asg_shd.g_old_rec.ass_attribute2, hr_api.g_varchar2) <>
881: nvl(p_rec.ass_attribute2, hr_api.g_varchar2) or
882: nvl(per_asg_shd.g_old_rec.ass_attribute3, hr_api.g_varchar2) <>
883: nvl(p_rec.ass_attribute3, hr_api.g_varchar2) or
884: nvl(per_asg_shd.g_old_rec.ass_attribute4, hr_api.g_varchar2) <>
885: nvl(p_rec.ass_attribute4, hr_api.g_varchar2) or
886: nvl(per_asg_shd.g_old_rec.ass_attribute5, hr_api.g_varchar2) <>
880: nvl(per_asg_shd.g_old_rec.ass_attribute2, hr_api.g_varchar2) <>
881: nvl(p_rec.ass_attribute2, hr_api.g_varchar2) or
882: nvl(per_asg_shd.g_old_rec.ass_attribute3, hr_api.g_varchar2) <>
883: nvl(p_rec.ass_attribute3, hr_api.g_varchar2) or
884: nvl(per_asg_shd.g_old_rec.ass_attribute4, hr_api.g_varchar2) <>
885: nvl(p_rec.ass_attribute4, hr_api.g_varchar2) or
886: nvl(per_asg_shd.g_old_rec.ass_attribute5, hr_api.g_varchar2) <>
887: nvl(p_rec.ass_attribute5, hr_api.g_varchar2) or
888: nvl(per_asg_shd.g_old_rec.ass_attribute6, hr_api.g_varchar2) <>
882: nvl(per_asg_shd.g_old_rec.ass_attribute3, hr_api.g_varchar2) <>
883: nvl(p_rec.ass_attribute3, hr_api.g_varchar2) or
884: nvl(per_asg_shd.g_old_rec.ass_attribute4, hr_api.g_varchar2) <>
885: nvl(p_rec.ass_attribute4, hr_api.g_varchar2) or
886: nvl(per_asg_shd.g_old_rec.ass_attribute5, hr_api.g_varchar2) <>
887: nvl(p_rec.ass_attribute5, hr_api.g_varchar2) or
888: nvl(per_asg_shd.g_old_rec.ass_attribute6, hr_api.g_varchar2) <>
889: nvl(p_rec.ass_attribute6, hr_api.g_varchar2) or
890: nvl(per_asg_shd.g_old_rec.ass_attribute7, hr_api.g_varchar2) <>
884: nvl(per_asg_shd.g_old_rec.ass_attribute4, hr_api.g_varchar2) <>
885: nvl(p_rec.ass_attribute4, hr_api.g_varchar2) or
886: nvl(per_asg_shd.g_old_rec.ass_attribute5, hr_api.g_varchar2) <>
887: nvl(p_rec.ass_attribute5, hr_api.g_varchar2) or
888: nvl(per_asg_shd.g_old_rec.ass_attribute6, hr_api.g_varchar2) <>
889: nvl(p_rec.ass_attribute6, hr_api.g_varchar2) or
890: nvl(per_asg_shd.g_old_rec.ass_attribute7, hr_api.g_varchar2) <>
891: nvl(p_rec.ass_attribute7, hr_api.g_varchar2) or
892: nvl(per_asg_shd.g_old_rec.ass_attribute8, hr_api.g_varchar2) <>
886: nvl(per_asg_shd.g_old_rec.ass_attribute5, hr_api.g_varchar2) <>
887: nvl(p_rec.ass_attribute5, hr_api.g_varchar2) or
888: nvl(per_asg_shd.g_old_rec.ass_attribute6, hr_api.g_varchar2) <>
889: nvl(p_rec.ass_attribute6, hr_api.g_varchar2) or
890: nvl(per_asg_shd.g_old_rec.ass_attribute7, hr_api.g_varchar2) <>
891: nvl(p_rec.ass_attribute7, hr_api.g_varchar2) or
892: nvl(per_asg_shd.g_old_rec.ass_attribute8, hr_api.g_varchar2) <>
893: nvl(p_rec.ass_attribute8, hr_api.g_varchar2) or
894: nvl(per_asg_shd.g_old_rec.ass_attribute9, hr_api.g_varchar2) <>
888: nvl(per_asg_shd.g_old_rec.ass_attribute6, hr_api.g_varchar2) <>
889: nvl(p_rec.ass_attribute6, hr_api.g_varchar2) or
890: nvl(per_asg_shd.g_old_rec.ass_attribute7, hr_api.g_varchar2) <>
891: nvl(p_rec.ass_attribute7, hr_api.g_varchar2) or
892: nvl(per_asg_shd.g_old_rec.ass_attribute8, hr_api.g_varchar2) <>
893: nvl(p_rec.ass_attribute8, hr_api.g_varchar2) or
894: nvl(per_asg_shd.g_old_rec.ass_attribute9, hr_api.g_varchar2) <>
895: nvl(p_rec.ass_attribute9, hr_api.g_varchar2) or
896: nvl(per_asg_shd.g_old_rec.ass_attribute10, hr_api.g_varchar2) <>
890: nvl(per_asg_shd.g_old_rec.ass_attribute7, hr_api.g_varchar2) <>
891: nvl(p_rec.ass_attribute7, hr_api.g_varchar2) or
892: nvl(per_asg_shd.g_old_rec.ass_attribute8, hr_api.g_varchar2) <>
893: nvl(p_rec.ass_attribute8, hr_api.g_varchar2) or
894: nvl(per_asg_shd.g_old_rec.ass_attribute9, hr_api.g_varchar2) <>
895: nvl(p_rec.ass_attribute9, hr_api.g_varchar2) or
896: nvl(per_asg_shd.g_old_rec.ass_attribute10, hr_api.g_varchar2) <>
897: nvl(p_rec.ass_attribute10, hr_api.g_varchar2) or
898: nvl(per_asg_shd.g_old_rec.ass_attribute11, hr_api.g_varchar2) <>
892: nvl(per_asg_shd.g_old_rec.ass_attribute8, hr_api.g_varchar2) <>
893: nvl(p_rec.ass_attribute8, hr_api.g_varchar2) or
894: nvl(per_asg_shd.g_old_rec.ass_attribute9, hr_api.g_varchar2) <>
895: nvl(p_rec.ass_attribute9, hr_api.g_varchar2) or
896: nvl(per_asg_shd.g_old_rec.ass_attribute10, hr_api.g_varchar2) <>
897: nvl(p_rec.ass_attribute10, hr_api.g_varchar2) or
898: nvl(per_asg_shd.g_old_rec.ass_attribute11, hr_api.g_varchar2) <>
899: nvl(p_rec.ass_attribute11, hr_api.g_varchar2) or
900: nvl(per_asg_shd.g_old_rec.ass_attribute12, hr_api.g_varchar2) <>
894: nvl(per_asg_shd.g_old_rec.ass_attribute9, hr_api.g_varchar2) <>
895: nvl(p_rec.ass_attribute9, hr_api.g_varchar2) or
896: nvl(per_asg_shd.g_old_rec.ass_attribute10, hr_api.g_varchar2) <>
897: nvl(p_rec.ass_attribute10, hr_api.g_varchar2) or
898: nvl(per_asg_shd.g_old_rec.ass_attribute11, hr_api.g_varchar2) <>
899: nvl(p_rec.ass_attribute11, hr_api.g_varchar2) or
900: nvl(per_asg_shd.g_old_rec.ass_attribute12, hr_api.g_varchar2) <>
901: nvl(p_rec.ass_attribute12, hr_api.g_varchar2) or
902: nvl(per_asg_shd.g_old_rec.ass_attribute13, hr_api.g_varchar2) <>
896: nvl(per_asg_shd.g_old_rec.ass_attribute10, hr_api.g_varchar2) <>
897: nvl(p_rec.ass_attribute10, hr_api.g_varchar2) or
898: nvl(per_asg_shd.g_old_rec.ass_attribute11, hr_api.g_varchar2) <>
899: nvl(p_rec.ass_attribute11, hr_api.g_varchar2) or
900: nvl(per_asg_shd.g_old_rec.ass_attribute12, hr_api.g_varchar2) <>
901: nvl(p_rec.ass_attribute12, hr_api.g_varchar2) or
902: nvl(per_asg_shd.g_old_rec.ass_attribute13, hr_api.g_varchar2) <>
903: nvl(p_rec.ass_attribute13, hr_api.g_varchar2) or
904: nvl(per_asg_shd.g_old_rec.ass_attribute14, hr_api.g_varchar2) <>
898: nvl(per_asg_shd.g_old_rec.ass_attribute11, hr_api.g_varchar2) <>
899: nvl(p_rec.ass_attribute11, hr_api.g_varchar2) or
900: nvl(per_asg_shd.g_old_rec.ass_attribute12, hr_api.g_varchar2) <>
901: nvl(p_rec.ass_attribute12, hr_api.g_varchar2) or
902: nvl(per_asg_shd.g_old_rec.ass_attribute13, hr_api.g_varchar2) <>
903: nvl(p_rec.ass_attribute13, hr_api.g_varchar2) or
904: nvl(per_asg_shd.g_old_rec.ass_attribute14, hr_api.g_varchar2) <>
905: nvl(p_rec.ass_attribute14, hr_api.g_varchar2) or
906: nvl(per_asg_shd.g_old_rec.ass_attribute15, hr_api.g_varchar2) <>
900: nvl(per_asg_shd.g_old_rec.ass_attribute12, hr_api.g_varchar2) <>
901: nvl(p_rec.ass_attribute12, hr_api.g_varchar2) or
902: nvl(per_asg_shd.g_old_rec.ass_attribute13, hr_api.g_varchar2) <>
903: nvl(p_rec.ass_attribute13, hr_api.g_varchar2) or
904: nvl(per_asg_shd.g_old_rec.ass_attribute14, hr_api.g_varchar2) <>
905: nvl(p_rec.ass_attribute14, hr_api.g_varchar2) or
906: nvl(per_asg_shd.g_old_rec.ass_attribute15, hr_api.g_varchar2) <>
907: nvl(p_rec.ass_attribute15, hr_api.g_varchar2) or
908: nvl(per_asg_shd.g_old_rec.ass_attribute16, hr_api.g_varchar2) <>
902: nvl(per_asg_shd.g_old_rec.ass_attribute13, hr_api.g_varchar2) <>
903: nvl(p_rec.ass_attribute13, hr_api.g_varchar2) or
904: nvl(per_asg_shd.g_old_rec.ass_attribute14, hr_api.g_varchar2) <>
905: nvl(p_rec.ass_attribute14, hr_api.g_varchar2) or
906: nvl(per_asg_shd.g_old_rec.ass_attribute15, hr_api.g_varchar2) <>
907: nvl(p_rec.ass_attribute15, hr_api.g_varchar2) or
908: nvl(per_asg_shd.g_old_rec.ass_attribute16, hr_api.g_varchar2) <>
909: nvl(p_rec.ass_attribute16, hr_api.g_varchar2) or
910: nvl(per_asg_shd.g_old_rec.ass_attribute17, hr_api.g_varchar2) <>
904: nvl(per_asg_shd.g_old_rec.ass_attribute14, hr_api.g_varchar2) <>
905: nvl(p_rec.ass_attribute14, hr_api.g_varchar2) or
906: nvl(per_asg_shd.g_old_rec.ass_attribute15, hr_api.g_varchar2) <>
907: nvl(p_rec.ass_attribute15, hr_api.g_varchar2) or
908: nvl(per_asg_shd.g_old_rec.ass_attribute16, hr_api.g_varchar2) <>
909: nvl(p_rec.ass_attribute16, hr_api.g_varchar2) or
910: nvl(per_asg_shd.g_old_rec.ass_attribute17, hr_api.g_varchar2) <>
911: nvl(p_rec.ass_attribute17, hr_api.g_varchar2) or
912: nvl(per_asg_shd.g_old_rec.ass_attribute18, hr_api.g_varchar2) <>
906: nvl(per_asg_shd.g_old_rec.ass_attribute15, hr_api.g_varchar2) <>
907: nvl(p_rec.ass_attribute15, hr_api.g_varchar2) or
908: nvl(per_asg_shd.g_old_rec.ass_attribute16, hr_api.g_varchar2) <>
909: nvl(p_rec.ass_attribute16, hr_api.g_varchar2) or
910: nvl(per_asg_shd.g_old_rec.ass_attribute17, hr_api.g_varchar2) <>
911: nvl(p_rec.ass_attribute17, hr_api.g_varchar2) or
912: nvl(per_asg_shd.g_old_rec.ass_attribute18, hr_api.g_varchar2) <>
913: nvl(p_rec.ass_attribute18, hr_api.g_varchar2) or
914: nvl(per_asg_shd.g_old_rec.ass_attribute19, hr_api.g_varchar2) <>
908: nvl(per_asg_shd.g_old_rec.ass_attribute16, hr_api.g_varchar2) <>
909: nvl(p_rec.ass_attribute16, hr_api.g_varchar2) or
910: nvl(per_asg_shd.g_old_rec.ass_attribute17, hr_api.g_varchar2) <>
911: nvl(p_rec.ass_attribute17, hr_api.g_varchar2) or
912: nvl(per_asg_shd.g_old_rec.ass_attribute18, hr_api.g_varchar2) <>
913: nvl(p_rec.ass_attribute18, hr_api.g_varchar2) or
914: nvl(per_asg_shd.g_old_rec.ass_attribute19, hr_api.g_varchar2) <>
915: nvl(p_rec.ass_attribute19, hr_api.g_varchar2) or
916: nvl(per_asg_shd.g_old_rec.ass_attribute20, hr_api.g_varchar2) <>
910: nvl(per_asg_shd.g_old_rec.ass_attribute17, hr_api.g_varchar2) <>
911: nvl(p_rec.ass_attribute17, hr_api.g_varchar2) or
912: nvl(per_asg_shd.g_old_rec.ass_attribute18, hr_api.g_varchar2) <>
913: nvl(p_rec.ass_attribute18, hr_api.g_varchar2) or
914: nvl(per_asg_shd.g_old_rec.ass_attribute19, hr_api.g_varchar2) <>
915: nvl(p_rec.ass_attribute19, hr_api.g_varchar2) or
916: nvl(per_asg_shd.g_old_rec.ass_attribute20, hr_api.g_varchar2) <>
917: nvl(p_rec.ass_attribute20, hr_api.g_varchar2) or
918: nvl(per_asg_shd.g_old_rec.ass_attribute21, hr_api.g_varchar2) <>
912: nvl(per_asg_shd.g_old_rec.ass_attribute18, hr_api.g_varchar2) <>
913: nvl(p_rec.ass_attribute18, hr_api.g_varchar2) or
914: nvl(per_asg_shd.g_old_rec.ass_attribute19, hr_api.g_varchar2) <>
915: nvl(p_rec.ass_attribute19, hr_api.g_varchar2) or
916: nvl(per_asg_shd.g_old_rec.ass_attribute20, hr_api.g_varchar2) <>
917: nvl(p_rec.ass_attribute20, hr_api.g_varchar2) or
918: nvl(per_asg_shd.g_old_rec.ass_attribute21, hr_api.g_varchar2) <>
919: nvl(p_rec.ass_attribute21, hr_api.g_varchar2) or
920: nvl(per_asg_shd.g_old_rec.ass_attribute22, hr_api.g_varchar2) <>
914: nvl(per_asg_shd.g_old_rec.ass_attribute19, hr_api.g_varchar2) <>
915: nvl(p_rec.ass_attribute19, hr_api.g_varchar2) or
916: nvl(per_asg_shd.g_old_rec.ass_attribute20, hr_api.g_varchar2) <>
917: nvl(p_rec.ass_attribute20, hr_api.g_varchar2) or
918: nvl(per_asg_shd.g_old_rec.ass_attribute21, hr_api.g_varchar2) <>
919: nvl(p_rec.ass_attribute21, hr_api.g_varchar2) or
920: nvl(per_asg_shd.g_old_rec.ass_attribute22, hr_api.g_varchar2) <>
921: nvl(p_rec.ass_attribute22, hr_api.g_varchar2) or
922: nvl(per_asg_shd.g_old_rec.ass_attribute23, hr_api.g_varchar2) <>
916: nvl(per_asg_shd.g_old_rec.ass_attribute20, hr_api.g_varchar2) <>
917: nvl(p_rec.ass_attribute20, hr_api.g_varchar2) or
918: nvl(per_asg_shd.g_old_rec.ass_attribute21, hr_api.g_varchar2) <>
919: nvl(p_rec.ass_attribute21, hr_api.g_varchar2) or
920: nvl(per_asg_shd.g_old_rec.ass_attribute22, hr_api.g_varchar2) <>
921: nvl(p_rec.ass_attribute22, hr_api.g_varchar2) or
922: nvl(per_asg_shd.g_old_rec.ass_attribute23, hr_api.g_varchar2) <>
923: nvl(p_rec.ass_attribute23, hr_api.g_varchar2) or
924: nvl(per_asg_shd.g_old_rec.ass_attribute24, hr_api.g_varchar2) <>
918: nvl(per_asg_shd.g_old_rec.ass_attribute21, hr_api.g_varchar2) <>
919: nvl(p_rec.ass_attribute21, hr_api.g_varchar2) or
920: nvl(per_asg_shd.g_old_rec.ass_attribute22, hr_api.g_varchar2) <>
921: nvl(p_rec.ass_attribute22, hr_api.g_varchar2) or
922: nvl(per_asg_shd.g_old_rec.ass_attribute23, hr_api.g_varchar2) <>
923: nvl(p_rec.ass_attribute23, hr_api.g_varchar2) or
924: nvl(per_asg_shd.g_old_rec.ass_attribute24, hr_api.g_varchar2) <>
925: nvl(p_rec.ass_attribute24, hr_api.g_varchar2) or
926: nvl(per_asg_shd.g_old_rec.ass_attribute25, hr_api.g_varchar2) <>
920: nvl(per_asg_shd.g_old_rec.ass_attribute22, hr_api.g_varchar2) <>
921: nvl(p_rec.ass_attribute22, hr_api.g_varchar2) or
922: nvl(per_asg_shd.g_old_rec.ass_attribute23, hr_api.g_varchar2) <>
923: nvl(p_rec.ass_attribute23, hr_api.g_varchar2) or
924: nvl(per_asg_shd.g_old_rec.ass_attribute24, hr_api.g_varchar2) <>
925: nvl(p_rec.ass_attribute24, hr_api.g_varchar2) or
926: nvl(per_asg_shd.g_old_rec.ass_attribute25, hr_api.g_varchar2) <>
927: nvl(p_rec.ass_attribute25, hr_api.g_varchar2) or
928: nvl(per_asg_shd.g_old_rec.ass_attribute26, hr_api.g_varchar2) <>
922: nvl(per_asg_shd.g_old_rec.ass_attribute23, hr_api.g_varchar2) <>
923: nvl(p_rec.ass_attribute23, hr_api.g_varchar2) or
924: nvl(per_asg_shd.g_old_rec.ass_attribute24, hr_api.g_varchar2) <>
925: nvl(p_rec.ass_attribute24, hr_api.g_varchar2) or
926: nvl(per_asg_shd.g_old_rec.ass_attribute25, hr_api.g_varchar2) <>
927: nvl(p_rec.ass_attribute25, hr_api.g_varchar2) or
928: nvl(per_asg_shd.g_old_rec.ass_attribute26, hr_api.g_varchar2) <>
929: nvl(p_rec.ass_attribute26, hr_api.g_varchar2) or
930: nvl(per_asg_shd.g_old_rec.ass_attribute27, hr_api.g_varchar2) <>
924: nvl(per_asg_shd.g_old_rec.ass_attribute24, hr_api.g_varchar2) <>
925: nvl(p_rec.ass_attribute24, hr_api.g_varchar2) or
926: nvl(per_asg_shd.g_old_rec.ass_attribute25, hr_api.g_varchar2) <>
927: nvl(p_rec.ass_attribute25, hr_api.g_varchar2) or
928: nvl(per_asg_shd.g_old_rec.ass_attribute26, hr_api.g_varchar2) <>
929: nvl(p_rec.ass_attribute26, hr_api.g_varchar2) or
930: nvl(per_asg_shd.g_old_rec.ass_attribute27, hr_api.g_varchar2) <>
931: nvl(p_rec.ass_attribute27, hr_api.g_varchar2) or
932: nvl(per_asg_shd.g_old_rec.ass_attribute28, hr_api.g_varchar2) <>
926: nvl(per_asg_shd.g_old_rec.ass_attribute25, hr_api.g_varchar2) <>
927: nvl(p_rec.ass_attribute25, hr_api.g_varchar2) or
928: nvl(per_asg_shd.g_old_rec.ass_attribute26, hr_api.g_varchar2) <>
929: nvl(p_rec.ass_attribute26, hr_api.g_varchar2) or
930: nvl(per_asg_shd.g_old_rec.ass_attribute27, hr_api.g_varchar2) <>
931: nvl(p_rec.ass_attribute27, hr_api.g_varchar2) or
932: nvl(per_asg_shd.g_old_rec.ass_attribute28, hr_api.g_varchar2) <>
933: nvl(p_rec.ass_attribute28, hr_api.g_varchar2) or
934: nvl(per_asg_shd.g_old_rec.ass_attribute29, hr_api.g_varchar2) <>
928: nvl(per_asg_shd.g_old_rec.ass_attribute26, hr_api.g_varchar2) <>
929: nvl(p_rec.ass_attribute26, hr_api.g_varchar2) or
930: nvl(per_asg_shd.g_old_rec.ass_attribute27, hr_api.g_varchar2) <>
931: nvl(p_rec.ass_attribute27, hr_api.g_varchar2) or
932: nvl(per_asg_shd.g_old_rec.ass_attribute28, hr_api.g_varchar2) <>
933: nvl(p_rec.ass_attribute28, hr_api.g_varchar2) or
934: nvl(per_asg_shd.g_old_rec.ass_attribute29, hr_api.g_varchar2) <>
935: nvl(p_rec.ass_attribute29, hr_api.g_varchar2) or
936: nvl(per_asg_shd.g_old_rec.ass_attribute30, hr_api.g_varchar2) <>
930: nvl(per_asg_shd.g_old_rec.ass_attribute27, hr_api.g_varchar2) <>
931: nvl(p_rec.ass_attribute27, hr_api.g_varchar2) or
932: nvl(per_asg_shd.g_old_rec.ass_attribute28, hr_api.g_varchar2) <>
933: nvl(p_rec.ass_attribute28, hr_api.g_varchar2) or
934: nvl(per_asg_shd.g_old_rec.ass_attribute29, hr_api.g_varchar2) <>
935: nvl(p_rec.ass_attribute29, hr_api.g_varchar2) or
936: nvl(per_asg_shd.g_old_rec.ass_attribute30, hr_api.g_varchar2) <>
937: nvl(p_rec.ass_attribute30, hr_api.g_varchar2)
938: )
932: nvl(per_asg_shd.g_old_rec.ass_attribute28, hr_api.g_varchar2) <>
933: nvl(p_rec.ass_attribute28, hr_api.g_varchar2) or
934: nvl(per_asg_shd.g_old_rec.ass_attribute29, hr_api.g_varchar2) <>
935: nvl(p_rec.ass_attribute29, hr_api.g_varchar2) or
936: nvl(per_asg_shd.g_old_rec.ass_attribute30, hr_api.g_varchar2) <>
937: nvl(p_rec.ass_attribute30, hr_api.g_varchar2)
938: )
939: or
940: (
1055: -- ----------------------------------------------------------------------------
1056: -- |---------------------------< insert_validate >----------------------------|
1057: -- ----------------------------------------------------------------------------
1058: Procedure insert_validate
1059: (p_rec in out nocopy per_asg_shd.g_rec_type,
1060: p_effective_date in date,
1061: p_datetrack_mode in varchar2,
1062: p_validation_start_date in date,
1063: p_validation_end_date in date,
1091: l_hourly_salaried_warning := FALSE;
1092: --
1093: hr_api.validate_bus_grp_id
1094: (p_business_group_id => p_rec.business_group_id
1095: ,p_associated_column1 => per_asg_shd.g_tab_nam ||
1096: '.BUSINESS_GROUP_ID'
1097: );
1098: --
1099: hr_multi_message.end_validation_set;
2169: -- ----------------------------------------------------------------------------
2170: -- |---------------------------< update_validate >----------------------------|
2171: -- ----------------------------------------------------------------------------
2172: Procedure update_validate
2173: (p_rec in out nocopy per_asg_shd.g_rec_type,
2174:
2175: p_effective_date in date,
2176: p_datetrack_mode in varchar2,
2177: p_validation_start_date in date,
2215: l_org_now_no_manager_warning := FALSE;
2216: --
2217: hr_api.validate_bus_grp_id
2218: (p_business_group_id => p_rec.business_group_id
2219: ,p_associated_column1 => per_asg_shd.g_tab_nam ||
2220: '.BUSINESS_GROUP_ID'
2221: ); -- chk business group id
2222: --
2223: hr_multi_message.end_validation_set;
2831: hr_utility.set_location(l_proc, 385);
2832: end if;
2833: --
2834: -- bug 5404529
2835: l_api_updating := per_asg_shd.api_updating
2836: (p_assignment_id => p_rec.assignment_id
2837: ,p_effective_date => p_effective_date
2838: ,p_object_version_number => p_rec.object_version_number
2839: );
2838: ,p_object_version_number => p_rec.object_version_number
2839: );
2840:
2841: if(l_api_updating and
2842: nvl(per_asg_shd.g_old_rec.assignment_type, hr_api.g_varchar2)
2843: = 'A' and p_rec.assignment_type = 'E') THEN
2844:
2845: hr_assignment.gen_new_ass_sequence
2846: ( p_rec.person_id
3426: end if;
3427: --
3428: -- Check if the assignment is being updated.
3429: --
3430: l_api_updating := per_asg_shd.api_updating
3431: (p_assignment_id => p_assignment_id
3432: ,p_effective_date => p_effective_date
3433: ,p_object_version_number => p_object_version_number);
3434: if g_debug then
3437: --
3438: -- Check if the assignment is being inserted or updated.
3439: --
3440: if ((l_api_updating and
3441: nvl(per_asg_shd.g_old_rec.application_id, hr_api.g_number)
3442: <> nvl(p_application_id, hr_api.g_number))
3443: or (NOT l_api_updating))
3444: then
3445: if g_debug then
3475: end if;
3476: --
3477: -- Check if the existing application is set
3478: --
3479: If per_asg_shd.g_old_rec.application_id is not null then
3480: --
3481: hr_utility.set_message(801, 'HR_51213_ASG_INV_UPD_APL');
3482: hr_utility.raise_error;
3483: /*hr_multi_message.add
3650: -- a) The current g_old_rec is current and
3651: -- b) The value for assignment number has changed
3652: -- to a not null value
3653: --
3654: l_api_updating := per_asg_shd.api_updating
3655: (p_assignment_id => p_assignment_id
3656: ,p_effective_date => p_effective_date
3657: ,p_object_version_number => p_object_version_number
3658: );
3664: -- Removed p_assignment_number is not null from the check condition
3665: -- of the top level if statement
3666: --
3667: if ((l_api_updating and
3668: nvl(per_asg_shd.g_old_rec.assignment_number, hr_api.g_varchar2) <>
3669: nvl(p_assignment_number, hr_api.g_varchar2)) or
3670: (NOT l_api_updating)) then
3671: --
3672: if g_debug then
3751: -- Check if the applicant assignment is being converted to an employee
3752: -- assignment.
3753: --
3754: elsif (l_api_updating and
3755: nvl(per_asg_shd.g_old_rec.assignment_type, hr_api.g_varchar2)
3756: = 'A' and p_assignment_type = 'E') then
3757: --
3758: if hr_multi_message.no_exclusive_error
3759: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID') then
3834: end if;
3835: --
3836: -- Check if inserting or updating the assignment
3837: --
3838: l_api_updating := per_asg_shd.api_updating
3839: (p_assignment_id => p_assignment_id
3840: ,p_effective_date => p_effective_date
3841: ,p_object_version_number => p_object_version_number);
3842: --
3846: --
3847: -- Check if inserting or assignment type has changed
3848: --
3849: IF ((l_api_updating AND
3850: nvl(per_asg_shd.g_old_rec.assignment_category, hr_api.g_varchar2) <>
3851: nvl(p_assignment_category, hr_api.g_varchar2)) OR
3852: (NOT l_api_updating)) THEN
3853: --
3854: if g_debug then
4069: -- |--------------------< chk_assignment_status_type_id >--------------------|
4070: -- ---------------------------------------------------------------------------
4071: --
4072: procedure chk_assignment_status_type_id
4073: (p_rec in per_asg_shd.g_rec_type
4074: ,p_effective_date in per_all_assignments_f.effective_start_date%TYPE
4075: ,p_validation_start_date in per_all_assignments_f.effective_start_date%TYPE
4076: )
4077: is
4125: cursor csr_get_old_per_system_type is
4126: select per_system_status
4127: from per_assignment_status_types
4128: where assignment_status_type_id =
4129: per_asg_shd.g_old_rec.assignment_status_type_id;
4130: --
4131: -- Cursor to retrieve the effective start date of
4132: -- the first assignment datetracked instance with assignment
4133: -- status type PER_SYSTEM_STATUS of 'ACTIVE_ASSIGN'
4198: end if;
4199: --
4200: -- Check if the assignment is being updated.
4201: --
4202: l_api_updating := per_asg_shd.api_updating
4203: (p_assignment_id => p_rec.assignment_id
4204: ,p_effective_date => p_effective_date
4205: ,p_object_version_number => p_rec.object_version_number);
4206: if g_debug then
4235: -- Note that the if ... statement has to be split because of server
4236: -- parser limitations.
4237: --
4238: if (p_rec.recruiter_id <>
4239: per_asg_shd.g_old_rec.recruiter_id
4240: or p_rec.grade_id <>
4241: per_asg_shd.g_old_rec.grade_id
4242: or p_rec.position_id <>
4243: per_asg_shd.g_old_rec.position_id
4237: --
4238: if (p_rec.recruiter_id <>
4239: per_asg_shd.g_old_rec.recruiter_id
4240: or p_rec.grade_id <>
4241: per_asg_shd.g_old_rec.grade_id
4242: or p_rec.position_id <>
4243: per_asg_shd.g_old_rec.position_id
4244: or p_rec.job_id <>
4245: per_asg_shd.g_old_rec.job_id
4239: per_asg_shd.g_old_rec.recruiter_id
4240: or p_rec.grade_id <>
4241: per_asg_shd.g_old_rec.grade_id
4242: or p_rec.position_id <>
4243: per_asg_shd.g_old_rec.position_id
4244: or p_rec.job_id <>
4245: per_asg_shd.g_old_rec.job_id
4246: -- Fix for bug# 9482545 relaxing payroll_id change
4247: -- or p_rec.payroll_id <>
4241: per_asg_shd.g_old_rec.grade_id
4242: or p_rec.position_id <>
4243: per_asg_shd.g_old_rec.position_id
4244: or p_rec.job_id <>
4245: per_asg_shd.g_old_rec.job_id
4246: -- Fix for bug# 9482545 relaxing payroll_id change
4247: -- or p_rec.payroll_id <>
4248: -- per_asg_shd.g_old_rec.payroll_id
4249: -- end of fix for bug 9482545
4244: or p_rec.job_id <>
4245: per_asg_shd.g_old_rec.job_id
4246: -- Fix for bug# 9482545 relaxing payroll_id change
4247: -- or p_rec.payroll_id <>
4248: -- per_asg_shd.g_old_rec.payroll_id
4249: -- end of fix for bug 9482545
4250: or p_rec.location_id <>
4251: per_asg_shd.g_old_rec.location_id
4252: or p_rec.person_referred_by_id <>
4247: -- or p_rec.payroll_id <>
4248: -- per_asg_shd.g_old_rec.payroll_id
4249: -- end of fix for bug 9482545
4250: or p_rec.location_id <>
4251: per_asg_shd.g_old_rec.location_id
4252: or p_rec.person_referred_by_id <>
4253: per_asg_shd.g_old_rec.person_referred_by_id
4254: --
4255: -- Fix for bug 3499996 starts here. coment out code.
4249: -- end of fix for bug 9482545
4250: or p_rec.location_id <>
4251: per_asg_shd.g_old_rec.location_id
4252: or p_rec.person_referred_by_id <>
4253: per_asg_shd.g_old_rec.person_referred_by_id
4254: --
4255: -- Fix for bug 3499996 starts here. coment out code.
4256: --
4257: -- or p_rec.supervisor_id <>
4254: --
4255: -- Fix for bug 3499996 starts here. coment out code.
4256: --
4257: -- or p_rec.supervisor_id <>
4258: -- per_asg_shd.g_old_rec.supervisor_id
4259: --
4260: -- Fix for bug 3499996 ends here.
4261: --
4262: or p_rec.special_ceiling_step_id <>
4259: --
4260: -- Fix for bug 3499996 ends here.
4261: --
4262: or p_rec.special_ceiling_step_id <>
4263: per_asg_shd.g_old_rec.special_ceiling_step_id
4264: or p_rec.recruitment_activity_id <>
4265: per_asg_shd.g_old_rec.recruitment_activity_id
4266: or p_rec.source_organization_id <>
4267: per_asg_shd.g_old_rec.source_organization_id
4261: --
4262: or p_rec.special_ceiling_step_id <>
4263: per_asg_shd.g_old_rec.special_ceiling_step_id
4264: or p_rec.recruitment_activity_id <>
4265: per_asg_shd.g_old_rec.recruitment_activity_id
4266: or p_rec.source_organization_id <>
4267: per_asg_shd.g_old_rec.source_organization_id
4268: or p_rec.organization_id <>
4269: per_asg_shd.g_old_rec.organization_id
4263: per_asg_shd.g_old_rec.special_ceiling_step_id
4264: or p_rec.recruitment_activity_id <>
4265: per_asg_shd.g_old_rec.recruitment_activity_id
4266: or p_rec.source_organization_id <>
4267: per_asg_shd.g_old_rec.source_organization_id
4268: or p_rec.organization_id <>
4269: per_asg_shd.g_old_rec.organization_id
4270: --Fix for bug# 10135334 relaxing payroll_id change
4271: -- or p_rec.people_group_id <>
4265: per_asg_shd.g_old_rec.recruitment_activity_id
4266: or p_rec.source_organization_id <>
4267: per_asg_shd.g_old_rec.source_organization_id
4268: or p_rec.organization_id <>
4269: per_asg_shd.g_old_rec.organization_id
4270: --Fix for bug# 10135334 relaxing payroll_id change
4271: -- or p_rec.people_group_id <>
4272: -- per_asg_shd.g_old_rec.people_group_id
4273: --End of fix for bug# 10135334
4268: or p_rec.organization_id <>
4269: per_asg_shd.g_old_rec.organization_id
4270: --Fix for bug# 10135334 relaxing payroll_id change
4271: -- or p_rec.people_group_id <>
4272: -- per_asg_shd.g_old_rec.people_group_id
4273: --End of fix for bug# 10135334
4274: -- Bug 4190473
4275: --or p_rec.soft_coding_keyflex_id <>
4276: -- per_asg_shd.g_old_rec.soft_coding_keyflex_id
4272: -- per_asg_shd.g_old_rec.people_group_id
4273: --End of fix for bug# 10135334
4274: -- Bug 4190473
4275: --or p_rec.soft_coding_keyflex_id <>
4276: -- per_asg_shd.g_old_rec.soft_coding_keyflex_id
4277: or p_rec.vacancy_id <>
4278: per_asg_shd.g_old_rec.vacancy_id
4279: or p_rec.pay_basis_id <>
4280: per_asg_shd.g_old_rec.pay_basis_id
4274: -- Bug 4190473
4275: --or p_rec.soft_coding_keyflex_id <>
4276: -- per_asg_shd.g_old_rec.soft_coding_keyflex_id
4277: or p_rec.vacancy_id <>
4278: per_asg_shd.g_old_rec.vacancy_id
4279: or p_rec.pay_basis_id <>
4280: per_asg_shd.g_old_rec.pay_basis_id
4281: or p_rec.application_id <>
4282: per_asg_shd.g_old_rec.application_id
4276: -- per_asg_shd.g_old_rec.soft_coding_keyflex_id
4277: or p_rec.vacancy_id <>
4278: per_asg_shd.g_old_rec.vacancy_id
4279: or p_rec.pay_basis_id <>
4280: per_asg_shd.g_old_rec.pay_basis_id
4281: or p_rec.application_id <>
4282: per_asg_shd.g_old_rec.application_id
4283: or p_rec.assignment_number <>
4284: per_asg_shd.g_old_rec.assignment_number
4278: per_asg_shd.g_old_rec.vacancy_id
4279: or p_rec.pay_basis_id <>
4280: per_asg_shd.g_old_rec.pay_basis_id
4281: or p_rec.application_id <>
4282: per_asg_shd.g_old_rec.application_id
4283: or p_rec.assignment_number <>
4284: per_asg_shd.g_old_rec.assignment_number
4285: or p_rec.change_reason <>
4286: per_asg_shd.g_old_rec.change_reason
4280: per_asg_shd.g_old_rec.pay_basis_id
4281: or p_rec.application_id <>
4282: per_asg_shd.g_old_rec.application_id
4283: or p_rec.assignment_number <>
4284: per_asg_shd.g_old_rec.assignment_number
4285: or p_rec.change_reason <>
4286: per_asg_shd.g_old_rec.change_reason
4287: or p_rec.comment_text <>
4288: per_asg_shd.g_old_rec.comment_text
4282: per_asg_shd.g_old_rec.application_id
4283: or p_rec.assignment_number <>
4284: per_asg_shd.g_old_rec.assignment_number
4285: or p_rec.change_reason <>
4286: per_asg_shd.g_old_rec.change_reason
4287: or p_rec.comment_text <>
4288: per_asg_shd.g_old_rec.comment_text
4289: or p_rec.date_probation_end <>
4290: per_asg_shd.g_old_rec.date_probation_end
4284: per_asg_shd.g_old_rec.assignment_number
4285: or p_rec.change_reason <>
4286: per_asg_shd.g_old_rec.change_reason
4287: or p_rec.comment_text <>
4288: per_asg_shd.g_old_rec.comment_text
4289: or p_rec.date_probation_end <>
4290: per_asg_shd.g_old_rec.date_probation_end
4291: or p_rec.default_code_comb_id <>
4292: per_asg_shd.g_old_rec.default_code_comb_id
4286: per_asg_shd.g_old_rec.change_reason
4287: or p_rec.comment_text <>
4288: per_asg_shd.g_old_rec.comment_text
4289: or p_rec.date_probation_end <>
4290: per_asg_shd.g_old_rec.date_probation_end
4291: or p_rec.default_code_comb_id <>
4292: per_asg_shd.g_old_rec.default_code_comb_id
4293: or p_rec.employment_category <>
4294: per_asg_shd.g_old_rec.employment_category
4288: per_asg_shd.g_old_rec.comment_text
4289: or p_rec.date_probation_end <>
4290: per_asg_shd.g_old_rec.date_probation_end
4291: or p_rec.default_code_comb_id <>
4292: per_asg_shd.g_old_rec.default_code_comb_id
4293: or p_rec.employment_category <>
4294: per_asg_shd.g_old_rec.employment_category
4295: or p_rec.frequency <>
4296: per_asg_shd.g_old_rec.frequency
4290: per_asg_shd.g_old_rec.date_probation_end
4291: or p_rec.default_code_comb_id <>
4292: per_asg_shd.g_old_rec.default_code_comb_id
4293: or p_rec.employment_category <>
4294: per_asg_shd.g_old_rec.employment_category
4295: or p_rec.frequency <>
4296: per_asg_shd.g_old_rec.frequency
4297: or p_rec.internal_address_line <>
4298: per_asg_shd.g_old_rec.internal_address_line
4292: per_asg_shd.g_old_rec.default_code_comb_id
4293: or p_rec.employment_category <>
4294: per_asg_shd.g_old_rec.employment_category
4295: or p_rec.frequency <>
4296: per_asg_shd.g_old_rec.frequency
4297: or p_rec.internal_address_line <>
4298: per_asg_shd.g_old_rec.internal_address_line
4299: or p_rec.manager_flag <>
4300: per_asg_shd.g_old_rec.manager_flag
4294: per_asg_shd.g_old_rec.employment_category
4295: or p_rec.frequency <>
4296: per_asg_shd.g_old_rec.frequency
4297: or p_rec.internal_address_line <>
4298: per_asg_shd.g_old_rec.internal_address_line
4299: or p_rec.manager_flag <>
4300: per_asg_shd.g_old_rec.manager_flag
4301: or p_rec.normal_hours <>
4302: per_asg_shd.g_old_rec.normal_hours
4296: per_asg_shd.g_old_rec.frequency
4297: or p_rec.internal_address_line <>
4298: per_asg_shd.g_old_rec.internal_address_line
4299: or p_rec.manager_flag <>
4300: per_asg_shd.g_old_rec.manager_flag
4301: or p_rec.normal_hours <>
4302: per_asg_shd.g_old_rec.normal_hours
4303: or p_rec.perf_review_period <>
4304: per_asg_shd.g_old_rec.perf_review_period
4298: per_asg_shd.g_old_rec.internal_address_line
4299: or p_rec.manager_flag <>
4300: per_asg_shd.g_old_rec.manager_flag
4301: or p_rec.normal_hours <>
4302: per_asg_shd.g_old_rec.normal_hours
4303: or p_rec.perf_review_period <>
4304: per_asg_shd.g_old_rec.perf_review_period
4305: or p_rec.perf_review_period_frequency <>
4306: per_asg_shd.g_old_rec.perf_review_period_frequency
4300: per_asg_shd.g_old_rec.manager_flag
4301: or p_rec.normal_hours <>
4302: per_asg_shd.g_old_rec.normal_hours
4303: or p_rec.perf_review_period <>
4304: per_asg_shd.g_old_rec.perf_review_period
4305: or p_rec.perf_review_period_frequency <>
4306: per_asg_shd.g_old_rec.perf_review_period_frequency
4307: or p_rec.probation_period <>
4308: per_asg_shd.g_old_rec.probation_period
4302: per_asg_shd.g_old_rec.normal_hours
4303: or p_rec.perf_review_period <>
4304: per_asg_shd.g_old_rec.perf_review_period
4305: or p_rec.perf_review_period_frequency <>
4306: per_asg_shd.g_old_rec.perf_review_period_frequency
4307: or p_rec.probation_period <>
4308: per_asg_shd.g_old_rec.probation_period
4309: or p_rec.probation_unit <>
4310: per_asg_shd.g_old_rec.probation_unit
4304: per_asg_shd.g_old_rec.perf_review_period
4305: or p_rec.perf_review_period_frequency <>
4306: per_asg_shd.g_old_rec.perf_review_period_frequency
4307: or p_rec.probation_period <>
4308: per_asg_shd.g_old_rec.probation_period
4309: or p_rec.probation_unit <>
4310: per_asg_shd.g_old_rec.probation_unit
4311: or p_rec.sal_review_period <>
4312: per_asg_shd.g_old_rec.sal_review_period
4306: per_asg_shd.g_old_rec.perf_review_period_frequency
4307: or p_rec.probation_period <>
4308: per_asg_shd.g_old_rec.probation_period
4309: or p_rec.probation_unit <>
4310: per_asg_shd.g_old_rec.probation_unit
4311: or p_rec.sal_review_period <>
4312: per_asg_shd.g_old_rec.sal_review_period
4313: or p_rec.sal_review_period_frequency <>
4314: per_asg_shd.g_old_rec.sal_review_period_frequency
4308: per_asg_shd.g_old_rec.probation_period
4309: or p_rec.probation_unit <>
4310: per_asg_shd.g_old_rec.probation_unit
4311: or p_rec.sal_review_period <>
4312: per_asg_shd.g_old_rec.sal_review_period
4313: or p_rec.sal_review_period_frequency <>
4314: per_asg_shd.g_old_rec.sal_review_period_frequency
4315: or p_rec.set_of_books_id <>
4316: per_asg_shd.g_old_rec.set_of_books_id
4310: per_asg_shd.g_old_rec.probation_unit
4311: or p_rec.sal_review_period <>
4312: per_asg_shd.g_old_rec.sal_review_period
4313: or p_rec.sal_review_period_frequency <>
4314: per_asg_shd.g_old_rec.sal_review_period_frequency
4315: or p_rec.set_of_books_id <>
4316: per_asg_shd.g_old_rec.set_of_books_id
4317: or p_rec.source_type <>
4318: per_asg_shd.g_old_rec.source_type
4312: per_asg_shd.g_old_rec.sal_review_period
4313: or p_rec.sal_review_period_frequency <>
4314: per_asg_shd.g_old_rec.sal_review_period_frequency
4315: or p_rec.set_of_books_id <>
4316: per_asg_shd.g_old_rec.set_of_books_id
4317: or p_rec.source_type <>
4318: per_asg_shd.g_old_rec.source_type
4319: or p_rec.time_normal_finish <>
4320: per_asg_shd.g_old_rec.time_normal_finish
4314: per_asg_shd.g_old_rec.sal_review_period_frequency
4315: or p_rec.set_of_books_id <>
4316: per_asg_shd.g_old_rec.set_of_books_id
4317: or p_rec.source_type <>
4318: per_asg_shd.g_old_rec.source_type
4319: or p_rec.time_normal_finish <>
4320: per_asg_shd.g_old_rec.time_normal_finish
4321: or p_rec.time_normal_start <>
4322: per_asg_shd.g_old_rec.time_normal_start
4316: per_asg_shd.g_old_rec.set_of_books_id
4317: or p_rec.source_type <>
4318: per_asg_shd.g_old_rec.source_type
4319: or p_rec.time_normal_finish <>
4320: per_asg_shd.g_old_rec.time_normal_finish
4321: or p_rec.time_normal_start <>
4322: per_asg_shd.g_old_rec.time_normal_start
4323: or p_rec.bargaining_unit_code <>
4324: per_asg_shd.g_old_rec.bargaining_unit_code
4318: per_asg_shd.g_old_rec.source_type
4319: or p_rec.time_normal_finish <>
4320: per_asg_shd.g_old_rec.time_normal_finish
4321: or p_rec.time_normal_start <>
4322: per_asg_shd.g_old_rec.time_normal_start
4323: or p_rec.bargaining_unit_code <>
4324: per_asg_shd.g_old_rec.bargaining_unit_code
4325: or p_rec.labour_union_member_flag <>
4326: per_asg_shd.g_old_rec.labour_union_member_flag
4320: per_asg_shd.g_old_rec.time_normal_finish
4321: or p_rec.time_normal_start <>
4322: per_asg_shd.g_old_rec.time_normal_start
4323: or p_rec.bargaining_unit_code <>
4324: per_asg_shd.g_old_rec.bargaining_unit_code
4325: or p_rec.labour_union_member_flag <>
4326: per_asg_shd.g_old_rec.labour_union_member_flag
4327: or p_rec.hourly_salaried_code <>
4328: per_asg_shd.g_old_rec.hourly_salaried_code
4322: per_asg_shd.g_old_rec.time_normal_start
4323: or p_rec.bargaining_unit_code <>
4324: per_asg_shd.g_old_rec.bargaining_unit_code
4325: or p_rec.labour_union_member_flag <>
4326: per_asg_shd.g_old_rec.labour_union_member_flag
4327: or p_rec.hourly_salaried_code <>
4328: per_asg_shd.g_old_rec.hourly_salaried_code
4329: or p_rec.request_id <>
4330: per_asg_shd.g_old_rec.request_id
4324: per_asg_shd.g_old_rec.bargaining_unit_code
4325: or p_rec.labour_union_member_flag <>
4326: per_asg_shd.g_old_rec.labour_union_member_flag
4327: or p_rec.hourly_salaried_code <>
4328: per_asg_shd.g_old_rec.hourly_salaried_code
4329: or p_rec.request_id <>
4330: per_asg_shd.g_old_rec.request_id
4331: or p_rec.program_application_id <>
4332: per_asg_shd.g_old_rec.program_application_id
4326: per_asg_shd.g_old_rec.labour_union_member_flag
4327: or p_rec.hourly_salaried_code <>
4328: per_asg_shd.g_old_rec.hourly_salaried_code
4329: or p_rec.request_id <>
4330: per_asg_shd.g_old_rec.request_id
4331: or p_rec.program_application_id <>
4332: per_asg_shd.g_old_rec.program_application_id
4333: or p_rec.program_id <>
4334: per_asg_shd.g_old_rec.program_id
4328: per_asg_shd.g_old_rec.hourly_salaried_code
4329: or p_rec.request_id <>
4330: per_asg_shd.g_old_rec.request_id
4331: or p_rec.program_application_id <>
4332: per_asg_shd.g_old_rec.program_application_id
4333: or p_rec.program_id <>
4334: per_asg_shd.g_old_rec.program_id
4335: or p_rec.program_update_date <>
4336: per_asg_shd.g_old_rec.program_update_date
4330: per_asg_shd.g_old_rec.request_id
4331: or p_rec.program_application_id <>
4332: per_asg_shd.g_old_rec.program_application_id
4333: or p_rec.program_id <>
4334: per_asg_shd.g_old_rec.program_id
4335: or p_rec.program_update_date <>
4336: per_asg_shd.g_old_rec.program_update_date
4337: or p_rec.ass_attribute_category <>
4338: per_asg_shd.g_old_rec.ass_attribute_category
4332: per_asg_shd.g_old_rec.program_application_id
4333: or p_rec.program_id <>
4334: per_asg_shd.g_old_rec.program_id
4335: or p_rec.program_update_date <>
4336: per_asg_shd.g_old_rec.program_update_date
4337: or p_rec.ass_attribute_category <>
4338: per_asg_shd.g_old_rec.ass_attribute_category
4339: )
4340: then
4334: per_asg_shd.g_old_rec.program_id
4335: or p_rec.program_update_date <>
4336: per_asg_shd.g_old_rec.program_update_date
4337: or p_rec.ass_attribute_category <>
4338: per_asg_shd.g_old_rec.ass_attribute_category
4339: )
4340: then
4341: --
4342: hr_utility.set_message(801, 'HR_7946_ASG_INV_TERM_ASS_UPD');
4345: );
4346: --
4347: -- fix for bug 4557189. Commented out code.
4348: elsif (
4349: /*p_rec.ass_attribute1 <> per_asg_shd.g_old_rec.ass_attribute1
4350: or p_rec.ass_attribute2 <> per_asg_shd.g_old_rec.ass_attribute2
4351: or p_rec.ass_attribute3 <> per_asg_shd.g_old_rec.ass_attribute3
4352: or p_rec.ass_attribute4 <> per_asg_shd.g_old_rec.ass_attribute4
4353: or p_rec.ass_attribute5 <> per_asg_shd.g_old_rec.ass_attribute5
4346: --
4347: -- fix for bug 4557189. Commented out code.
4348: elsif (
4349: /*p_rec.ass_attribute1 <> per_asg_shd.g_old_rec.ass_attribute1
4350: or p_rec.ass_attribute2 <> per_asg_shd.g_old_rec.ass_attribute2
4351: or p_rec.ass_attribute3 <> per_asg_shd.g_old_rec.ass_attribute3
4352: or p_rec.ass_attribute4 <> per_asg_shd.g_old_rec.ass_attribute4
4353: or p_rec.ass_attribute5 <> per_asg_shd.g_old_rec.ass_attribute5
4354: or p_rec.ass_attribute6 <> per_asg_shd.g_old_rec.ass_attribute6
4347: -- fix for bug 4557189. Commented out code.
4348: elsif (
4349: /*p_rec.ass_attribute1 <> per_asg_shd.g_old_rec.ass_attribute1
4350: or p_rec.ass_attribute2 <> per_asg_shd.g_old_rec.ass_attribute2
4351: or p_rec.ass_attribute3 <> per_asg_shd.g_old_rec.ass_attribute3
4352: or p_rec.ass_attribute4 <> per_asg_shd.g_old_rec.ass_attribute4
4353: or p_rec.ass_attribute5 <> per_asg_shd.g_old_rec.ass_attribute5
4354: or p_rec.ass_attribute6 <> per_asg_shd.g_old_rec.ass_attribute6
4355: or p_rec.ass_attribute7 <> per_asg_shd.g_old_rec.ass_attribute7
4348: elsif (
4349: /*p_rec.ass_attribute1 <> per_asg_shd.g_old_rec.ass_attribute1
4350: or p_rec.ass_attribute2 <> per_asg_shd.g_old_rec.ass_attribute2
4351: or p_rec.ass_attribute3 <> per_asg_shd.g_old_rec.ass_attribute3
4352: or p_rec.ass_attribute4 <> per_asg_shd.g_old_rec.ass_attribute4
4353: or p_rec.ass_attribute5 <> per_asg_shd.g_old_rec.ass_attribute5
4354: or p_rec.ass_attribute6 <> per_asg_shd.g_old_rec.ass_attribute6
4355: or p_rec.ass_attribute7 <> per_asg_shd.g_old_rec.ass_attribute7
4356: or p_rec.ass_attribute8 <> per_asg_shd.g_old_rec.ass_attribute8
4349: /*p_rec.ass_attribute1 <> per_asg_shd.g_old_rec.ass_attribute1
4350: or p_rec.ass_attribute2 <> per_asg_shd.g_old_rec.ass_attribute2
4351: or p_rec.ass_attribute3 <> per_asg_shd.g_old_rec.ass_attribute3
4352: or p_rec.ass_attribute4 <> per_asg_shd.g_old_rec.ass_attribute4
4353: or p_rec.ass_attribute5 <> per_asg_shd.g_old_rec.ass_attribute5
4354: or p_rec.ass_attribute6 <> per_asg_shd.g_old_rec.ass_attribute6
4355: or p_rec.ass_attribute7 <> per_asg_shd.g_old_rec.ass_attribute7
4356: or p_rec.ass_attribute8 <> per_asg_shd.g_old_rec.ass_attribute8
4357: or p_rec.ass_attribute9 <> per_asg_shd.g_old_rec.ass_attribute9
4350: or p_rec.ass_attribute2 <> per_asg_shd.g_old_rec.ass_attribute2
4351: or p_rec.ass_attribute3 <> per_asg_shd.g_old_rec.ass_attribute3
4352: or p_rec.ass_attribute4 <> per_asg_shd.g_old_rec.ass_attribute4
4353: or p_rec.ass_attribute5 <> per_asg_shd.g_old_rec.ass_attribute5
4354: or p_rec.ass_attribute6 <> per_asg_shd.g_old_rec.ass_attribute6
4355: or p_rec.ass_attribute7 <> per_asg_shd.g_old_rec.ass_attribute7
4356: or p_rec.ass_attribute8 <> per_asg_shd.g_old_rec.ass_attribute8
4357: or p_rec.ass_attribute9 <> per_asg_shd.g_old_rec.ass_attribute9
4358: or p_rec.ass_attribute10 <> per_asg_shd.g_old_rec.ass_attribute10
4351: or p_rec.ass_attribute3 <> per_asg_shd.g_old_rec.ass_attribute3
4352: or p_rec.ass_attribute4 <> per_asg_shd.g_old_rec.ass_attribute4
4353: or p_rec.ass_attribute5 <> per_asg_shd.g_old_rec.ass_attribute5
4354: or p_rec.ass_attribute6 <> per_asg_shd.g_old_rec.ass_attribute6
4355: or p_rec.ass_attribute7 <> per_asg_shd.g_old_rec.ass_attribute7
4356: or p_rec.ass_attribute8 <> per_asg_shd.g_old_rec.ass_attribute8
4357: or p_rec.ass_attribute9 <> per_asg_shd.g_old_rec.ass_attribute9
4358: or p_rec.ass_attribute10 <> per_asg_shd.g_old_rec.ass_attribute10
4359: or p_rec.ass_attribute11 <> per_asg_shd.g_old_rec.ass_attribute11
4352: or p_rec.ass_attribute4 <> per_asg_shd.g_old_rec.ass_attribute4
4353: or p_rec.ass_attribute5 <> per_asg_shd.g_old_rec.ass_attribute5
4354: or p_rec.ass_attribute6 <> per_asg_shd.g_old_rec.ass_attribute6
4355: or p_rec.ass_attribute7 <> per_asg_shd.g_old_rec.ass_attribute7
4356: or p_rec.ass_attribute8 <> per_asg_shd.g_old_rec.ass_attribute8
4357: or p_rec.ass_attribute9 <> per_asg_shd.g_old_rec.ass_attribute9
4358: or p_rec.ass_attribute10 <> per_asg_shd.g_old_rec.ass_attribute10
4359: or p_rec.ass_attribute11 <> per_asg_shd.g_old_rec.ass_attribute11
4360: or p_rec.ass_attribute12 <> per_asg_shd.g_old_rec.ass_attribute12
4353: or p_rec.ass_attribute5 <> per_asg_shd.g_old_rec.ass_attribute5
4354: or p_rec.ass_attribute6 <> per_asg_shd.g_old_rec.ass_attribute6
4355: or p_rec.ass_attribute7 <> per_asg_shd.g_old_rec.ass_attribute7
4356: or p_rec.ass_attribute8 <> per_asg_shd.g_old_rec.ass_attribute8
4357: or p_rec.ass_attribute9 <> per_asg_shd.g_old_rec.ass_attribute9
4358: or p_rec.ass_attribute10 <> per_asg_shd.g_old_rec.ass_attribute10
4359: or p_rec.ass_attribute11 <> per_asg_shd.g_old_rec.ass_attribute11
4360: or p_rec.ass_attribute12 <> per_asg_shd.g_old_rec.ass_attribute12
4361: or p_rec.ass_attribute13 <> per_asg_shd.g_old_rec.ass_attribute13
4354: or p_rec.ass_attribute6 <> per_asg_shd.g_old_rec.ass_attribute6
4355: or p_rec.ass_attribute7 <> per_asg_shd.g_old_rec.ass_attribute7
4356: or p_rec.ass_attribute8 <> per_asg_shd.g_old_rec.ass_attribute8
4357: or p_rec.ass_attribute9 <> per_asg_shd.g_old_rec.ass_attribute9
4358: or p_rec.ass_attribute10 <> per_asg_shd.g_old_rec.ass_attribute10
4359: or p_rec.ass_attribute11 <> per_asg_shd.g_old_rec.ass_attribute11
4360: or p_rec.ass_attribute12 <> per_asg_shd.g_old_rec.ass_attribute12
4361: or p_rec.ass_attribute13 <> per_asg_shd.g_old_rec.ass_attribute13
4362: or p_rec.ass_attribute14 <> per_asg_shd.g_old_rec.ass_attribute14
4355: or p_rec.ass_attribute7 <> per_asg_shd.g_old_rec.ass_attribute7
4356: or p_rec.ass_attribute8 <> per_asg_shd.g_old_rec.ass_attribute8
4357: or p_rec.ass_attribute9 <> per_asg_shd.g_old_rec.ass_attribute9
4358: or p_rec.ass_attribute10 <> per_asg_shd.g_old_rec.ass_attribute10
4359: or p_rec.ass_attribute11 <> per_asg_shd.g_old_rec.ass_attribute11
4360: or p_rec.ass_attribute12 <> per_asg_shd.g_old_rec.ass_attribute12
4361: or p_rec.ass_attribute13 <> per_asg_shd.g_old_rec.ass_attribute13
4362: or p_rec.ass_attribute14 <> per_asg_shd.g_old_rec.ass_attribute14
4363: or p_rec.ass_attribute15 <> per_asg_shd.g_old_rec.ass_attribute15
4356: or p_rec.ass_attribute8 <> per_asg_shd.g_old_rec.ass_attribute8
4357: or p_rec.ass_attribute9 <> per_asg_shd.g_old_rec.ass_attribute9
4358: or p_rec.ass_attribute10 <> per_asg_shd.g_old_rec.ass_attribute10
4359: or p_rec.ass_attribute11 <> per_asg_shd.g_old_rec.ass_attribute11
4360: or p_rec.ass_attribute12 <> per_asg_shd.g_old_rec.ass_attribute12
4361: or p_rec.ass_attribute13 <> per_asg_shd.g_old_rec.ass_attribute13
4362: or p_rec.ass_attribute14 <> per_asg_shd.g_old_rec.ass_attribute14
4363: or p_rec.ass_attribute15 <> per_asg_shd.g_old_rec.ass_attribute15
4364: or p_rec.ass_attribute16 <> per_asg_shd.g_old_rec.ass_attribute16
4357: or p_rec.ass_attribute9 <> per_asg_shd.g_old_rec.ass_attribute9
4358: or p_rec.ass_attribute10 <> per_asg_shd.g_old_rec.ass_attribute10
4359: or p_rec.ass_attribute11 <> per_asg_shd.g_old_rec.ass_attribute11
4360: or p_rec.ass_attribute12 <> per_asg_shd.g_old_rec.ass_attribute12
4361: or p_rec.ass_attribute13 <> per_asg_shd.g_old_rec.ass_attribute13
4362: or p_rec.ass_attribute14 <> per_asg_shd.g_old_rec.ass_attribute14
4363: or p_rec.ass_attribute15 <> per_asg_shd.g_old_rec.ass_attribute15
4364: or p_rec.ass_attribute16 <> per_asg_shd.g_old_rec.ass_attribute16
4365: or p_rec.ass_attribute17 <> per_asg_shd.g_old_rec.ass_attribute17
4358: or p_rec.ass_attribute10 <> per_asg_shd.g_old_rec.ass_attribute10
4359: or p_rec.ass_attribute11 <> per_asg_shd.g_old_rec.ass_attribute11
4360: or p_rec.ass_attribute12 <> per_asg_shd.g_old_rec.ass_attribute12
4361: or p_rec.ass_attribute13 <> per_asg_shd.g_old_rec.ass_attribute13
4362: or p_rec.ass_attribute14 <> per_asg_shd.g_old_rec.ass_attribute14
4363: or p_rec.ass_attribute15 <> per_asg_shd.g_old_rec.ass_attribute15
4364: or p_rec.ass_attribute16 <> per_asg_shd.g_old_rec.ass_attribute16
4365: or p_rec.ass_attribute17 <> per_asg_shd.g_old_rec.ass_attribute17
4366: or p_rec.ass_attribute18 <> per_asg_shd.g_old_rec.ass_attribute18
4359: or p_rec.ass_attribute11 <> per_asg_shd.g_old_rec.ass_attribute11
4360: or p_rec.ass_attribute12 <> per_asg_shd.g_old_rec.ass_attribute12
4361: or p_rec.ass_attribute13 <> per_asg_shd.g_old_rec.ass_attribute13
4362: or p_rec.ass_attribute14 <> per_asg_shd.g_old_rec.ass_attribute14
4363: or p_rec.ass_attribute15 <> per_asg_shd.g_old_rec.ass_attribute15
4364: or p_rec.ass_attribute16 <> per_asg_shd.g_old_rec.ass_attribute16
4365: or p_rec.ass_attribute17 <> per_asg_shd.g_old_rec.ass_attribute17
4366: or p_rec.ass_attribute18 <> per_asg_shd.g_old_rec.ass_attribute18
4367: or p_rec.ass_attribute19 <> per_asg_shd.g_old_rec.ass_attribute19
4360: or p_rec.ass_attribute12 <> per_asg_shd.g_old_rec.ass_attribute12
4361: or p_rec.ass_attribute13 <> per_asg_shd.g_old_rec.ass_attribute13
4362: or p_rec.ass_attribute14 <> per_asg_shd.g_old_rec.ass_attribute14
4363: or p_rec.ass_attribute15 <> per_asg_shd.g_old_rec.ass_attribute15
4364: or p_rec.ass_attribute16 <> per_asg_shd.g_old_rec.ass_attribute16
4365: or p_rec.ass_attribute17 <> per_asg_shd.g_old_rec.ass_attribute17
4366: or p_rec.ass_attribute18 <> per_asg_shd.g_old_rec.ass_attribute18
4367: or p_rec.ass_attribute19 <> per_asg_shd.g_old_rec.ass_attribute19
4368: or p_rec.ass_attribute20 <> per_asg_shd.g_old_rec.ass_attribute20
4361: or p_rec.ass_attribute13 <> per_asg_shd.g_old_rec.ass_attribute13
4362: or p_rec.ass_attribute14 <> per_asg_shd.g_old_rec.ass_attribute14
4363: or p_rec.ass_attribute15 <> per_asg_shd.g_old_rec.ass_attribute15
4364: or p_rec.ass_attribute16 <> per_asg_shd.g_old_rec.ass_attribute16
4365: or p_rec.ass_attribute17 <> per_asg_shd.g_old_rec.ass_attribute17
4366: or p_rec.ass_attribute18 <> per_asg_shd.g_old_rec.ass_attribute18
4367: or p_rec.ass_attribute19 <> per_asg_shd.g_old_rec.ass_attribute19
4368: or p_rec.ass_attribute20 <> per_asg_shd.g_old_rec.ass_attribute20
4369: or p_rec.ass_attribute21 <> per_asg_shd.g_old_rec.ass_attribute21
4362: or p_rec.ass_attribute14 <> per_asg_shd.g_old_rec.ass_attribute14
4363: or p_rec.ass_attribute15 <> per_asg_shd.g_old_rec.ass_attribute15
4364: or p_rec.ass_attribute16 <> per_asg_shd.g_old_rec.ass_attribute16
4365: or p_rec.ass_attribute17 <> per_asg_shd.g_old_rec.ass_attribute17
4366: or p_rec.ass_attribute18 <> per_asg_shd.g_old_rec.ass_attribute18
4367: or p_rec.ass_attribute19 <> per_asg_shd.g_old_rec.ass_attribute19
4368: or p_rec.ass_attribute20 <> per_asg_shd.g_old_rec.ass_attribute20
4369: or p_rec.ass_attribute21 <> per_asg_shd.g_old_rec.ass_attribute21
4370: or p_rec.ass_attribute22 <> per_asg_shd.g_old_rec.ass_attribute22
4363: or p_rec.ass_attribute15 <> per_asg_shd.g_old_rec.ass_attribute15
4364: or p_rec.ass_attribute16 <> per_asg_shd.g_old_rec.ass_attribute16
4365: or p_rec.ass_attribute17 <> per_asg_shd.g_old_rec.ass_attribute17
4366: or p_rec.ass_attribute18 <> per_asg_shd.g_old_rec.ass_attribute18
4367: or p_rec.ass_attribute19 <> per_asg_shd.g_old_rec.ass_attribute19
4368: or p_rec.ass_attribute20 <> per_asg_shd.g_old_rec.ass_attribute20
4369: or p_rec.ass_attribute21 <> per_asg_shd.g_old_rec.ass_attribute21
4370: or p_rec.ass_attribute22 <> per_asg_shd.g_old_rec.ass_attribute22
4371: or p_rec.ass_attribute23 <> per_asg_shd.g_old_rec.ass_attribute23
4364: or p_rec.ass_attribute16 <> per_asg_shd.g_old_rec.ass_attribute16
4365: or p_rec.ass_attribute17 <> per_asg_shd.g_old_rec.ass_attribute17
4366: or p_rec.ass_attribute18 <> per_asg_shd.g_old_rec.ass_attribute18
4367: or p_rec.ass_attribute19 <> per_asg_shd.g_old_rec.ass_attribute19
4368: or p_rec.ass_attribute20 <> per_asg_shd.g_old_rec.ass_attribute20
4369: or p_rec.ass_attribute21 <> per_asg_shd.g_old_rec.ass_attribute21
4370: or p_rec.ass_attribute22 <> per_asg_shd.g_old_rec.ass_attribute22
4371: or p_rec.ass_attribute23 <> per_asg_shd.g_old_rec.ass_attribute23
4372: or p_rec.ass_attribute24 <> per_asg_shd.g_old_rec.ass_attribute24
4365: or p_rec.ass_attribute17 <> per_asg_shd.g_old_rec.ass_attribute17
4366: or p_rec.ass_attribute18 <> per_asg_shd.g_old_rec.ass_attribute18
4367: or p_rec.ass_attribute19 <> per_asg_shd.g_old_rec.ass_attribute19
4368: or p_rec.ass_attribute20 <> per_asg_shd.g_old_rec.ass_attribute20
4369: or p_rec.ass_attribute21 <> per_asg_shd.g_old_rec.ass_attribute21
4370: or p_rec.ass_attribute22 <> per_asg_shd.g_old_rec.ass_attribute22
4371: or p_rec.ass_attribute23 <> per_asg_shd.g_old_rec.ass_attribute23
4372: or p_rec.ass_attribute24 <> per_asg_shd.g_old_rec.ass_attribute24
4373: or p_rec.ass_attribute25 <> per_asg_shd.g_old_rec.ass_attribute25
4366: or p_rec.ass_attribute18 <> per_asg_shd.g_old_rec.ass_attribute18
4367: or p_rec.ass_attribute19 <> per_asg_shd.g_old_rec.ass_attribute19
4368: or p_rec.ass_attribute20 <> per_asg_shd.g_old_rec.ass_attribute20
4369: or p_rec.ass_attribute21 <> per_asg_shd.g_old_rec.ass_attribute21
4370: or p_rec.ass_attribute22 <> per_asg_shd.g_old_rec.ass_attribute22
4371: or p_rec.ass_attribute23 <> per_asg_shd.g_old_rec.ass_attribute23
4372: or p_rec.ass_attribute24 <> per_asg_shd.g_old_rec.ass_attribute24
4373: or p_rec.ass_attribute25 <> per_asg_shd.g_old_rec.ass_attribute25
4374: or p_rec.ass_attribute26 <> per_asg_shd.g_old_rec.ass_attribute26
4367: or p_rec.ass_attribute19 <> per_asg_shd.g_old_rec.ass_attribute19
4368: or p_rec.ass_attribute20 <> per_asg_shd.g_old_rec.ass_attribute20
4369: or p_rec.ass_attribute21 <> per_asg_shd.g_old_rec.ass_attribute21
4370: or p_rec.ass_attribute22 <> per_asg_shd.g_old_rec.ass_attribute22
4371: or p_rec.ass_attribute23 <> per_asg_shd.g_old_rec.ass_attribute23
4372: or p_rec.ass_attribute24 <> per_asg_shd.g_old_rec.ass_attribute24
4373: or p_rec.ass_attribute25 <> per_asg_shd.g_old_rec.ass_attribute25
4374: or p_rec.ass_attribute26 <> per_asg_shd.g_old_rec.ass_attribute26
4375: or p_rec.ass_attribute27 <> per_asg_shd.g_old_rec.ass_attribute27
4368: or p_rec.ass_attribute20 <> per_asg_shd.g_old_rec.ass_attribute20
4369: or p_rec.ass_attribute21 <> per_asg_shd.g_old_rec.ass_attribute21
4370: or p_rec.ass_attribute22 <> per_asg_shd.g_old_rec.ass_attribute22
4371: or p_rec.ass_attribute23 <> per_asg_shd.g_old_rec.ass_attribute23
4372: or p_rec.ass_attribute24 <> per_asg_shd.g_old_rec.ass_attribute24
4373: or p_rec.ass_attribute25 <> per_asg_shd.g_old_rec.ass_attribute25
4374: or p_rec.ass_attribute26 <> per_asg_shd.g_old_rec.ass_attribute26
4375: or p_rec.ass_attribute27 <> per_asg_shd.g_old_rec.ass_attribute27
4376: or p_rec.ass_attribute28 <> per_asg_shd.g_old_rec.ass_attribute28
4369: or p_rec.ass_attribute21 <> per_asg_shd.g_old_rec.ass_attribute21
4370: or p_rec.ass_attribute22 <> per_asg_shd.g_old_rec.ass_attribute22
4371: or p_rec.ass_attribute23 <> per_asg_shd.g_old_rec.ass_attribute23
4372: or p_rec.ass_attribute24 <> per_asg_shd.g_old_rec.ass_attribute24
4373: or p_rec.ass_attribute25 <> per_asg_shd.g_old_rec.ass_attribute25
4374: or p_rec.ass_attribute26 <> per_asg_shd.g_old_rec.ass_attribute26
4375: or p_rec.ass_attribute27 <> per_asg_shd.g_old_rec.ass_attribute27
4376: or p_rec.ass_attribute28 <> per_asg_shd.g_old_rec.ass_attribute28
4377: or p_rec.ass_attribute29 <> per_asg_shd.g_old_rec.ass_attribute29
4370: or p_rec.ass_attribute22 <> per_asg_shd.g_old_rec.ass_attribute22
4371: or p_rec.ass_attribute23 <> per_asg_shd.g_old_rec.ass_attribute23
4372: or p_rec.ass_attribute24 <> per_asg_shd.g_old_rec.ass_attribute24
4373: or p_rec.ass_attribute25 <> per_asg_shd.g_old_rec.ass_attribute25
4374: or p_rec.ass_attribute26 <> per_asg_shd.g_old_rec.ass_attribute26
4375: or p_rec.ass_attribute27 <> per_asg_shd.g_old_rec.ass_attribute27
4376: or p_rec.ass_attribute28 <> per_asg_shd.g_old_rec.ass_attribute28
4377: or p_rec.ass_attribute29 <> per_asg_shd.g_old_rec.ass_attribute29
4378: or p_rec.ass_attribute30 <> per_asg_shd.g_old_rec.ass_attribute30
4371: or p_rec.ass_attribute23 <> per_asg_shd.g_old_rec.ass_attribute23
4372: or p_rec.ass_attribute24 <> per_asg_shd.g_old_rec.ass_attribute24
4373: or p_rec.ass_attribute25 <> per_asg_shd.g_old_rec.ass_attribute25
4374: or p_rec.ass_attribute26 <> per_asg_shd.g_old_rec.ass_attribute26
4375: or p_rec.ass_attribute27 <> per_asg_shd.g_old_rec.ass_attribute27
4376: or p_rec.ass_attribute28 <> per_asg_shd.g_old_rec.ass_attribute28
4377: or p_rec.ass_attribute29 <> per_asg_shd.g_old_rec.ass_attribute29
4378: or p_rec.ass_attribute30 <> per_asg_shd.g_old_rec.ass_attribute30
4379: or */
4372: or p_rec.ass_attribute24 <> per_asg_shd.g_old_rec.ass_attribute24
4373: or p_rec.ass_attribute25 <> per_asg_shd.g_old_rec.ass_attribute25
4374: or p_rec.ass_attribute26 <> per_asg_shd.g_old_rec.ass_attribute26
4375: or p_rec.ass_attribute27 <> per_asg_shd.g_old_rec.ass_attribute27
4376: or p_rec.ass_attribute28 <> per_asg_shd.g_old_rec.ass_attribute28
4377: or p_rec.ass_attribute29 <> per_asg_shd.g_old_rec.ass_attribute29
4378: or p_rec.ass_attribute30 <> per_asg_shd.g_old_rec.ass_attribute30
4379: or */
4380: p_rec.title <> per_asg_shd.g_old_rec.title
4373: or p_rec.ass_attribute25 <> per_asg_shd.g_old_rec.ass_attribute25
4374: or p_rec.ass_attribute26 <> per_asg_shd.g_old_rec.ass_attribute26
4375: or p_rec.ass_attribute27 <> per_asg_shd.g_old_rec.ass_attribute27
4376: or p_rec.ass_attribute28 <> per_asg_shd.g_old_rec.ass_attribute28
4377: or p_rec.ass_attribute29 <> per_asg_shd.g_old_rec.ass_attribute29
4378: or p_rec.ass_attribute30 <> per_asg_shd.g_old_rec.ass_attribute30
4379: or */
4380: p_rec.title <> per_asg_shd.g_old_rec.title
4381: )
4374: or p_rec.ass_attribute26 <> per_asg_shd.g_old_rec.ass_attribute26
4375: or p_rec.ass_attribute27 <> per_asg_shd.g_old_rec.ass_attribute27
4376: or p_rec.ass_attribute28 <> per_asg_shd.g_old_rec.ass_attribute28
4377: or p_rec.ass_attribute29 <> per_asg_shd.g_old_rec.ass_attribute29
4378: or p_rec.ass_attribute30 <> per_asg_shd.g_old_rec.ass_attribute30
4379: or */
4380: p_rec.title <> per_asg_shd.g_old_rec.title
4381: )
4382: then
4376: or p_rec.ass_attribute28 <> per_asg_shd.g_old_rec.ass_attribute28
4377: or p_rec.ass_attribute29 <> per_asg_shd.g_old_rec.ass_attribute29
4378: or p_rec.ass_attribute30 <> per_asg_shd.g_old_rec.ass_attribute30
4379: or */
4380: p_rec.title <> per_asg_shd.g_old_rec.title
4381: )
4382: then
4383: --
4384: hr_utility.set_message(801, 'HR_7946_ASG_INV_TERM_ASS_UPD');
4434: -- a) The current g_old_rec is current and
4435: -- b) The value for assignment status type has changed
4436: --
4437: if (l_api_updating
4438: and nvl(per_asg_shd.g_old_rec.assignment_status_type_id, hr_api.g_number)
4439: <> nvl(p_rec.assignment_status_type_id, hr_api.g_number)
4440: )
4441: or not l_api_updating
4442: then
4776: end if;
4777: --
4778: -- Check if inserting or updating the assignment
4779: --
4780: l_api_updating := per_asg_shd.api_updating
4781: (p_assignment_id => p_assignment_id
4782: ,p_effective_date => p_effective_date
4783: ,p_object_version_number => p_object_version_number
4784: );
4788: --
4789: -- Check if inserting or assignment type has changed
4790: --
4791: if ((l_api_updating and
4792: nvl(per_asg_shd.g_old_rec.assignment_type, hr_api.g_varchar2) <>
4793: nvl(p_assignment_type, hr_api.g_varchar2))
4794: or
4795: (NOT l_api_updating))
4796: then
4805: -- Extend restriction to allow assignment type 'O' (Offers)
4806: --
4807: If p_assignment_type not in('E','A','B','C','O') then
4808: --
4809: per_asg_shd.constraint_error
4810: (p_constraint_name => 'PER_ASS_ASSIGNMENT_TYPE_CHK');
4811: --
4812: end if;
4813: if g_debug then
4956: if g_debug then
4957: hr_utility.set_location(l_proc, 20);
4958: end if;
4959: --
4960: l_api_updating := per_asg_shd.api_updating
4961: (p_assignment_id => p_assignment_id
4962: ,p_effective_date => p_effective_date
4963: ,p_object_version_number => p_object_version_number
4964: );
4966: hr_utility.set_location(l_proc, 30);
4967: end if;
4968: --
4969: if ((l_api_updating and
4970: nvl(per_asg_shd.g_old_rec.change_reason, hr_api.g_varchar2) <>
4971: nvl(p_change_reason, hr_api.g_varchar2))
4972: or
4973: (NOT l_api_updating))
4974: then
5248: -- Only proceed with validation if :
5249: -- a) The current g_old_rec is current and
5250: -- b) The value for date probation end has changed
5251: --
5252: l_api_updating := per_asg_shd.api_updating
5253: (p_assignment_id => p_assignment_id
5254: ,p_effective_date => p_effective_date
5255: ,p_object_version_number => p_object_version_number);
5256: --
5254: ,p_effective_date => p_effective_date
5255: ,p_object_version_number => p_object_version_number);
5256: --
5257: if ((l_api_updating and
5258: nvl(per_asg_shd.g_old_rec.date_probation_end, hr_api.g_date)
5259: <> nvl(p_date_probation_end, hr_api.g_date))
5260: or
5261: (NOT l_api_updating))
5262: then
5377: -- Only proceed with validation if :
5378: -- a) The current g_old_rec is current and
5379: -- b) The value for default code comb has changed
5380: --
5381: l_api_updating := per_asg_shd.api_updating
5382: (p_assignment_id => p_assignment_id
5383: ,p_effective_date => p_effective_date
5384: ,p_object_version_number => p_object_version_number
5385: );
5387: hr_utility.set_location(l_proc, 30);
5388: end if;
5389: --
5390: if ((l_api_updating and
5391: nvl(per_asg_shd.g_old_rec.default_code_comb_id, hr_api.g_number) <>
5392: nvl(p_default_code_comb_id, hr_api.g_number)) or
5393: (NOT l_api_updating))
5394: then
5395: if g_debug then
5565: if g_debug then
5566: hr_utility.set_location(l_proc, 20);
5567: end if;
5568: --
5569: l_api_updating := per_asg_shd.api_updating
5570: (p_assignment_id => p_assignment_id
5571: ,p_effective_date => p_effective_date
5572: ,p_object_version_number => p_object_version_number
5573: );
5575: hr_utility.set_location(l_proc, 30);
5576: end if;
5577: --
5578: if ((l_api_updating and
5579: nvl(per_asg_shd.g_old_rec.employment_category, hr_api.g_varchar2) <>
5580: nvl(p_employment_category, hr_api.g_varchar2))
5581: or (NOT l_api_updating))
5582: then
5583: if g_debug then
5734: -- Only proceed with validation if :
5735: -- a) The current g_old_rec is current and
5736: -- b) The value for frequency has changed
5737: --
5738: l_api_updating := per_asg_shd.api_updating
5739: (p_assignment_id => p_assignment_id
5740: ,p_effective_date => p_effective_date
5741: ,p_object_version_number => p_object_version_number
5742: );
5744: hr_utility.set_location(l_proc, 30);
5745: end if;
5746: --
5747: if ((l_api_updating and
5748: nvl(per_asg_shd.g_old_rec.frequency, hr_api.g_varchar2) <>
5749: nvl(p_frequency, hr_api.g_varchar2)) or
5750: (NOT l_api_updating))
5751: then
5752: if g_debug then
5965: -- Only proceed with validation if :
5966: -- a) The current g_old_rec is current and
5967: -- b) The value for grade has changed
5968: --
5969: l_api_updating := per_asg_shd.api_updating
5970: (p_assignment_id => p_assignment_id
5971: ,p_effective_date => p_effective_date
5972: ,p_object_version_number => p_object_version_number
5973: );
5975: hr_utility.set_location(l_proc, 30);
5976: end if;
5977: --
5978: if ((l_api_updating and
5979: nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>
5980: nvl(p_grade_id, hr_api.g_number)) or
5981: (NOT l_api_updating)) then
5982: if g_debug then
5983: hr_utility.set_location(l_proc, 40);
6123: end if;
6124: --
6125: -- Check if the assignment is being updated.
6126: --
6127: l_api_updating := per_asg_shd.api_updating
6128: (p_assignment_id => p_assignment_id
6129: ,p_effective_date => p_effective_date
6130: ,p_object_version_number => p_object_version_number
6131: );
6137: -- a) The current g_old_rec is current and
6138: -- b) The value for job has changed
6139: --
6140: if ((l_api_updating and
6141: nvl(per_asg_shd.g_old_rec.job_id,
6142: hr_api.g_number) <> nvl(p_job_id, hr_api.g_number))
6143: or
6144: NOT l_api_updating) then
6145: if g_debug then
6285: end if;
6286: --
6287: -- Check if the assignment is being updated.
6288: --
6289: l_api_updating := per_asg_shd.api_updating
6290: (p_assignment_id => p_assignment_id
6291: ,p_effective_date => p_effective_date
6292: ,p_object_version_number => p_object_version_number
6293: );
6300: -- b) The value for job or grade has changed.
6301: --
6302: if (l_api_updating
6303: and
6304: ((nvl(per_asg_shd.g_old_rec.job_id, hr_api.g_number)
6305: <> nvl(p_job_id, hr_api.g_number))
6306: or
6307: (nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number)
6308: <> nvl(p_grade_id, hr_api.g_number))))
6303: and
6304: ((nvl(per_asg_shd.g_old_rec.job_id, hr_api.g_number)
6305: <> nvl(p_job_id, hr_api.g_number))
6306: or
6307: (nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number)
6308: <> nvl(p_grade_id, hr_api.g_number))))
6309: or
6310: NOT l_api_updating then
6311: if g_debug then
6488: -- Only proceed with validation if :
6489: -- a) The current g_old_rec is current and
6490: -- b) The value for location_id has changed
6491: --
6492: l_api_updating := per_asg_shd.api_updating
6493: (p_assignment_id => p_assignment_id
6494: ,p_effective_date => p_effective_date
6495: ,p_object_version_number => p_object_version_number
6496: );
6498: hr_utility.set_location('Entering:'|| l_proc, 30);
6499: end if;
6500: --
6501: if ((l_api_updating and
6502: nvl(per_asg_shd.g_old_rec.location_id, hr_api.g_number) <>
6503: nvl(p_location_id, hr_api.g_number)) or
6504: (NOT l_api_updating))
6505: then
6506: --
6614: -- Only proceed with validation if :
6615: -- a) The current g_old_rec is current and
6616: -- b) The value for manager flag has changed
6617: --
6618: l_api_updating := per_asg_shd.api_updating
6619: (p_assignment_id => p_assignment_id
6620: ,p_effective_date => p_effective_date
6621: ,p_object_version_number => p_object_version_number
6622: );
6624: hr_utility.set_location(l_proc, 30);
6625: end if;
6626: --
6627: if ((l_api_updating and
6628: nvl(per_asg_shd.g_old_rec.manager_flag, hr_api.g_varchar2) <>
6629: nvl(p_manager_flag, hr_api.g_varchar2))
6630: or
6631: (NOT l_api_updating))
6632: then
6639: If p_manager_flag is not null
6640: and p_manager_flag not in('Y','N')
6641: then
6642: --
6643: per_asg_shd.constraint_error
6644: (p_constraint_name => 'PER_ASS_MANAGER_FLAG_CHK');
6645: if g_debug then
6646: hr_utility.set_location(l_proc, 50);
6647: end if;
6716: -- Check if employee is being changed from
6717: -- a manager to a non-manager
6718: --
6719: if p_manager_flag = 'N' and
6720: per_asg_shd.g_old_rec.manager_flag = 'Y' then
6721: --
6722: p_no_managers_warning := TRUE;
6723: --
6724: end if;
6776: -- Only proceed with validation if :
6777: -- a) The current g_old_rec is current and
6778: -- b) The value for normal hours has changed
6779: --
6780: l_api_updating := per_asg_shd.api_updating
6781: (p_assignment_id => p_assignment_id
6782: ,p_effective_date => p_effective_date
6783: ,p_object_version_number => p_object_version_number
6784: );
6786: hr_utility.set_location(l_proc, 30);
6787: end if;
6788: --
6789: if (l_api_updating and
6790: ((nvl(per_asg_shd.g_old_rec.frequency, hr_api.g_varchar2) <>
6791: nvl(p_frequency, hr_api.g_varchar2))
6792: or
6793: (nvl(per_asg_shd.g_old_rec.normal_hours, hr_api.g_number) <>
6794: nvl(p_normal_hours, hr_api.g_number))))
6789: if (l_api_updating and
6790: ((nvl(per_asg_shd.g_old_rec.frequency, hr_api.g_varchar2) <>
6791: nvl(p_frequency, hr_api.g_varchar2))
6792: or
6793: (nvl(per_asg_shd.g_old_rec.normal_hours, hr_api.g_number) <>
6794: nvl(p_normal_hours, hr_api.g_number))))
6795: or
6796: (NOT l_api_updating)
6797: then
6935: -- Only proceed with validation if :
6936: -- a) The current g_old_rec is current and
6937: -- b) The value for organization_id has changed
6938: --
6939: l_api_updating := per_asg_shd.api_updating
6940: (p_assignment_id => p_assignment_id
6941: ,p_effective_date => p_effective_date
6942: ,p_object_version_number => p_object_version_number
6943: );
6945: hr_utility.set_location(l_proc, 30);
6946: end if;
6947: --
6948: if (l_api_updating and
6949: per_asg_shd.g_old_rec.organization_id <> p_organization_id)
6950: or
6951: NOT l_api_updating
6952: then
6953: if g_debug then
7762: if g_debug then
7763: hr_utility.set_location(l_proc, 20);
7764: end if;
7765: --
7766: l_api_updating := per_asg_shd.api_updating
7767: (p_assignment_id => p_assignment_id
7768: ,p_effective_date => p_effective_date
7769: ,p_object_version_number => p_object_version_number
7770: );
7774: --
7775: -- Modified the if condition for Bug #12615314
7776: if (l_api_updating and
7777: (
7778: (nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
7779: nvl(p_position_id, hr_api.g_number))
7780: or
7781: (nvl(per_asg_shd.g_old_rec.assignment_type, hr_api.g_varchar2) <>
7782: nvl(p_assignment_type, hr_api.g_varchar2))
7777: (
7778: (nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
7779: nvl(p_position_id, hr_api.g_number))
7780: or
7781: (nvl(per_asg_shd.g_old_rec.assignment_type, hr_api.g_varchar2) <>
7782: nvl(p_assignment_type, hr_api.g_varchar2))
7783: )
7784: )
7785: or