APPS.PER_ASG_BUS1 dependencies on HR_API

Line 50: hr_api.mandatory_arg_error(p_api_name => l_proc,

46: end if;
47: --
48: -- Ensure that all the mandatory parameter are not null
49: --
50: hr_api.mandatory_arg_error(p_api_name => l_proc,
51: p_argument => 'assignment_id',
52: p_argument_value => p_assignment_id);
53: --
54: open csr_sec_grp;

Line 72: hr_api.set_security_group_id

68: close csr_sec_grp;
69: --
70: -- Set the security_group_id in CLIENT_INFO
71: --
72: hr_api.set_security_group_id
73: (p_security_group_id => l_security_group_id
74: );
75: end if;
76: --

Line 79: hr_api.set_legislation_context(l_legislation_code);

75: end if;
76: --
77: -- Set the sessions legislation context in HR_SESSION_DATA
78: --
79: hr_api.set_legislation_context(l_legislation_code);
80: --
81: --
82: if g_debug then
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 143: if nvl(p_rec.business_group_id, hr_api.g_number) <>

139: if g_debug then
140: hr_utility.set_location(l_proc, 6);
141: end if;
142: --
143: if nvl(p_rec.business_group_id, hr_api.g_number) <>
144: nvl(per_asg_shd.g_old_rec.business_group_id, hr_api.g_number) then
145: hr_api.argument_changed_error
146: (p_api_name => l_proc
147: ,p_argument => 'BUSINESS_GROUP_ID'

Line 144: nvl(per_asg_shd.g_old_rec.business_group_id, hr_api.g_number) 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

Line 145: hr_api.argument_changed_error

141: end if;
142: --
143: if nvl(p_rec.business_group_id, hr_api.g_number) <>
144: nvl(per_asg_shd.g_old_rec.business_group_id, hr_api.g_number) then
145: hr_api.argument_changed_error
146: (p_api_name => l_proc
147: ,p_argument => 'BUSINESS_GROUP_ID'
148: ,p_base_table => per_asg_shd.g_tab_nam
149: );

Line 156: hr_api.argument_changed_error

152: hr_utility.set_location(l_proc, 7);
153: end if;
154: --
155: if p_rec.assignment_id <> per_asg_shd.g_old_rec.assignment_id then
156: hr_api.argument_changed_error
157: (p_api_name => l_proc
158: ,p_argument => 'ASSIGNMENT_ID'
159: ,p_base_table => per_asg_shd.g_tab_nam
160: );

Line 167: hr_api.argument_changed_error

163: hr_utility.set_location(l_proc, 8);
164: end if;
165: --
166: if p_rec.person_id <> per_asg_shd.g_old_rec.person_id then
167: hr_api.argument_changed_error
168: (p_api_name => l_proc
169: ,p_argument => 'PERSON_ID'
170: ,p_base_table => per_asg_shd.g_tab_nam
171: );

Line 178: hr_api.argument_changed_error

174: hr_utility.set_location(l_proc, 9);
175: end if;
176: --
177: if p_rec.assignment_sequence <> per_asg_shd.g_old_rec.assignment_sequence then
178: hr_api.argument_changed_error
179: (p_api_name => l_proc
180: ,p_argument => 'ASSIGNMENT_SEQUENCE'
181: ,p_base_table => per_asg_shd.g_tab_nam
182: );

Line 193: hr_api.argument_changed_error

189: -- Bug fix 3101091 starts. Commenting out the check that makes vendor_id
190: -- non updatable
191: /* if p_rec.vendor_id <> per_asg_shd.g_old_rec.vendor_id then
192: --
193: hr_api.argument_changed_error
194: (p_api_name => l_proc
195: ,p_argument => 'VENDOR_ID'
196: ,p_base_table => per_asg_shd.g_tab_nam);
197: --

Line 493: hr_api.mandatory_arg_error

489: -- Ensure that the p_datetrack_mode argument is not null
490: --
491: hr_utility.set_location(l_proc,10);
492:
493: hr_api.mandatory_arg_error
494: (p_api_name => l_proc,
495: p_argument => 'datetrack_mode',
496: p_argument_value => p_datetrack_mode);
497: --

Line 511: hr_api.mandatory_arg_error

507: -- Ensure the arguments are not null
508: --
509: hr_utility.set_location(l_proc,30);
510:
511: hr_api.mandatory_arg_error
512: (p_api_name => l_proc,
513: p_argument => 'validation_start_date',
514: p_argument_value => p_validation_start_date);
515: --

Line 518: hr_api.mandatory_arg_error

514: p_argument_value => p_validation_start_date);
515: --
516: hr_utility.set_location(l_proc,40);
517:
518: hr_api.mandatory_arg_error
519: (p_api_name => l_proc,
520: p_argument => 'validation_end_date',
521: p_argument_value => p_validation_end_date);
522: --

Line 525: hr_api.mandatory_arg_error

521: p_argument_value => p_validation_end_date);
522: --
523: hr_utility.set_location(l_proc,50);
524:
525: hr_api.mandatory_arg_error
526: (p_api_name => l_proc,
527: p_argument => 'assignment_id',
528: p_argument_value => p_assignment_id);
529: --

Line 702: (p_payroll_id in number default hr_api.g_number,

698: --
699: -- {End Of Comments}
700: -- ----------------------------------------------------------------------------
701: Procedure dt_update_validate
702: (p_payroll_id in number default hr_api.g_number,
703: p_person_id in number default hr_api.g_number,
704: p_datetrack_mode in varchar2,
705: p_validation_start_date in date,
706: p_validation_end_date in date) Is

Line 703: p_person_id in number default hr_api.g_number,

699: -- {End Of Comments}
700: -- ----------------------------------------------------------------------------
701: Procedure dt_update_validate
702: (p_payroll_id in number default hr_api.g_number,
703: p_person_id in number default hr_api.g_number,
704: p_datetrack_mode in varchar2,
705: p_validation_start_date in date,
706: p_validation_end_date in date) Is
707: --

Line 719: hr_api.mandatory_arg_error

715: end if;
716: --
717: -- Ensure that the p_datetrack_mode argument is not null
718: --
719: hr_api.mandatory_arg_error
720: (p_api_name => l_proc,
721: p_argument => 'datetrack_mode',
722: p_argument_value => p_datetrack_mode);
723: --

Line 730: hr_api.mandatory_arg_error

726: --
727: --
728: -- Ensure the arguments are not null
729: --
730: hr_api.mandatory_arg_error
731: (p_api_name => l_proc,
732: p_argument => 'validation_start_date',
733: p_argument_value => p_validation_start_date);
734: --

Line 735: hr_api.mandatory_arg_error

731: (p_api_name => l_proc,
732: p_argument => 'validation_start_date',
733: p_argument_value => p_validation_start_date);
734: --
735: hr_api.mandatory_arg_error
736: (p_api_name => l_proc,
737: p_argument => 'validation_end_date',
738: p_argument_value => p_validation_end_date);
739: --

Line 742: If ((nvl(p_payroll_id, hr_api.g_number) <> hr_api.g_number) and

738: p_argument_value => p_validation_end_date);
739: --
740: -- Start of fix 2535030
741: /*
742: If ((nvl(p_payroll_id, hr_api.g_number) <> hr_api.g_number) and
743: NOT (dt_api.check_min_max_dates
744: (p_base_table_name => 'pay_all_payrolls_f', -- bug fix 2679167
745: p_base_key_column => 'payroll_id',
746: p_base_key_value => p_payroll_id,

Line 755: If ((nvl(p_person_id, hr_api.g_number) <> hr_api.g_number) and

751: End If;
752: */
753: -- End of fix 2535030
754:
755: If ((nvl(p_person_id, hr_api.g_number) <> hr_api.g_number) and
756: NOT (dt_api.check_min_max_dates
757: (p_base_table_name => 'per_all_people_f',
758: p_base_key_column => 'person_id',
759: p_base_key_value => p_person_id,

Line 876: ( (nvl(per_asg_shd.g_old_rec.ass_attribute_category, hr_api.g_varchar2) <>

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) <>

Line 877: nvl(p_rec.ass_attribute_category, hr_api.g_varchar2) or

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) <>
881: nvl(p_rec.ass_attribute2, hr_api.g_varchar2) or

Line 878: nvl(per_asg_shd.g_old_rec.ass_attribute1, 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) <>

Line 879: nvl(p_rec.ass_attribute1, hr_api.g_varchar2) or

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) <>
883: nvl(p_rec.ass_attribute3, hr_api.g_varchar2) or

Line 880: nvl(per_asg_shd.g_old_rec.ass_attribute2, 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) <>

Line 881: nvl(p_rec.ass_attribute2, hr_api.g_varchar2) or

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) <>
885: nvl(p_rec.ass_attribute4, hr_api.g_varchar2) or

Line 882: nvl(per_asg_shd.g_old_rec.ass_attribute3, 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) <>

Line 883: nvl(p_rec.ass_attribute3, hr_api.g_varchar2) or

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) <>
887: nvl(p_rec.ass_attribute5, hr_api.g_varchar2) or

Line 884: nvl(per_asg_shd.g_old_rec.ass_attribute4, 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) <>

Line 885: nvl(p_rec.ass_attribute4, hr_api.g_varchar2) or

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) <>
889: nvl(p_rec.ass_attribute6, hr_api.g_varchar2) or

Line 886: nvl(per_asg_shd.g_old_rec.ass_attribute5, 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) <>

Line 887: nvl(p_rec.ass_attribute5, hr_api.g_varchar2) or

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) <>
891: nvl(p_rec.ass_attribute7, hr_api.g_varchar2) or

Line 888: nvl(per_asg_shd.g_old_rec.ass_attribute6, 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) <>

Line 889: nvl(p_rec.ass_attribute6, hr_api.g_varchar2) or

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) <>
893: nvl(p_rec.ass_attribute8, hr_api.g_varchar2) or

Line 890: nvl(per_asg_shd.g_old_rec.ass_attribute7, 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) <>

Line 891: nvl(p_rec.ass_attribute7, hr_api.g_varchar2) or

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) <>
895: nvl(p_rec.ass_attribute9, hr_api.g_varchar2) or

Line 892: nvl(per_asg_shd.g_old_rec.ass_attribute8, 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) <>

Line 893: nvl(p_rec.ass_attribute8, hr_api.g_varchar2) or

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) <>
897: nvl(p_rec.ass_attribute10, hr_api.g_varchar2) or

Line 894: nvl(per_asg_shd.g_old_rec.ass_attribute9, 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) <>

Line 895: nvl(p_rec.ass_attribute9, hr_api.g_varchar2) or

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) <>
899: nvl(p_rec.ass_attribute11, hr_api.g_varchar2) or

Line 896: nvl(per_asg_shd.g_old_rec.ass_attribute10, 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) <>

Line 897: nvl(p_rec.ass_attribute10, hr_api.g_varchar2) or

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) <>
901: nvl(p_rec.ass_attribute12, hr_api.g_varchar2) or

Line 898: nvl(per_asg_shd.g_old_rec.ass_attribute11, 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) <>

Line 899: nvl(p_rec.ass_attribute11, hr_api.g_varchar2) or

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) <>
903: nvl(p_rec.ass_attribute13, hr_api.g_varchar2) or

Line 900: nvl(per_asg_shd.g_old_rec.ass_attribute12, 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) <>

Line 901: nvl(p_rec.ass_attribute12, hr_api.g_varchar2) or

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) <>
905: nvl(p_rec.ass_attribute14, hr_api.g_varchar2) or

Line 902: nvl(per_asg_shd.g_old_rec.ass_attribute13, 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) <>

Line 903: nvl(p_rec.ass_attribute13, hr_api.g_varchar2) or

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) <>
907: nvl(p_rec.ass_attribute15, hr_api.g_varchar2) or

Line 904: nvl(per_asg_shd.g_old_rec.ass_attribute14, 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) <>

Line 905: nvl(p_rec.ass_attribute14, hr_api.g_varchar2) or

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) <>
909: nvl(p_rec.ass_attribute16, hr_api.g_varchar2) or

Line 906: nvl(per_asg_shd.g_old_rec.ass_attribute15, 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) <>

Line 907: nvl(p_rec.ass_attribute15, hr_api.g_varchar2) or

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) <>
911: nvl(p_rec.ass_attribute17, hr_api.g_varchar2) or

Line 908: nvl(per_asg_shd.g_old_rec.ass_attribute16, 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) <>

Line 909: nvl(p_rec.ass_attribute16, hr_api.g_varchar2) or

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) <>
913: nvl(p_rec.ass_attribute18, hr_api.g_varchar2) or

Line 910: nvl(per_asg_shd.g_old_rec.ass_attribute17, 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) <>

Line 911: nvl(p_rec.ass_attribute17, hr_api.g_varchar2) or

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) <>
915: nvl(p_rec.ass_attribute19, hr_api.g_varchar2) or

Line 912: nvl(per_asg_shd.g_old_rec.ass_attribute18, 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) <>

Line 913: nvl(p_rec.ass_attribute18, hr_api.g_varchar2) or

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) <>
917: nvl(p_rec.ass_attribute20, hr_api.g_varchar2) or

Line 914: nvl(per_asg_shd.g_old_rec.ass_attribute19, 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) <>

Line 915: nvl(p_rec.ass_attribute19, hr_api.g_varchar2) or

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) <>
919: nvl(p_rec.ass_attribute21, hr_api.g_varchar2) or

Line 916: nvl(per_asg_shd.g_old_rec.ass_attribute20, 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) <>

Line 917: nvl(p_rec.ass_attribute20, hr_api.g_varchar2) or

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) <>
921: nvl(p_rec.ass_attribute22, hr_api.g_varchar2) or

Line 918: nvl(per_asg_shd.g_old_rec.ass_attribute21, 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) <>

Line 919: nvl(p_rec.ass_attribute21, hr_api.g_varchar2) or

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) <>
923: nvl(p_rec.ass_attribute23, hr_api.g_varchar2) or

Line 920: nvl(per_asg_shd.g_old_rec.ass_attribute22, 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) <>

Line 921: nvl(p_rec.ass_attribute22, hr_api.g_varchar2) or

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) <>
925: nvl(p_rec.ass_attribute24, hr_api.g_varchar2) or

Line 922: nvl(per_asg_shd.g_old_rec.ass_attribute23, 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) <>

Line 923: nvl(p_rec.ass_attribute23, hr_api.g_varchar2) or

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) <>
927: nvl(p_rec.ass_attribute25, hr_api.g_varchar2) or

Line 924: nvl(per_asg_shd.g_old_rec.ass_attribute24, 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) <>

Line 925: nvl(p_rec.ass_attribute24, hr_api.g_varchar2) or

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) <>
929: nvl(p_rec.ass_attribute26, hr_api.g_varchar2) or

Line 926: nvl(per_asg_shd.g_old_rec.ass_attribute25, 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) <>

Line 927: nvl(p_rec.ass_attribute25, hr_api.g_varchar2) or

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) <>
931: nvl(p_rec.ass_attribute27, hr_api.g_varchar2) or

Line 928: nvl(per_asg_shd.g_old_rec.ass_attribute26, 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) <>

Line 929: nvl(p_rec.ass_attribute26, hr_api.g_varchar2) or

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) <>
933: nvl(p_rec.ass_attribute28, hr_api.g_varchar2) or

Line 930: nvl(per_asg_shd.g_old_rec.ass_attribute27, 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) <>

Line 931: nvl(p_rec.ass_attribute27, hr_api.g_varchar2) or

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) <>
935: nvl(p_rec.ass_attribute29, hr_api.g_varchar2) or

Line 932: nvl(per_asg_shd.g_old_rec.ass_attribute28, 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) <>

Line 933: nvl(p_rec.ass_attribute28, hr_api.g_varchar2) or

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) <>
937: nvl(p_rec.ass_attribute30, hr_api.g_varchar2)

Line 934: nvl(per_asg_shd.g_old_rec.ass_attribute29, 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: )

Line 935: nvl(p_rec.ass_attribute29, hr_api.g_varchar2) or

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: )
939: or

Line 936: nvl(per_asg_shd.g_old_rec.ass_attribute30, hr_api.g_varchar2) <>

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: (

Line 937: nvl(p_rec.ass_attribute30, 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: (
941: (p_rec.ass_attribute_category is null) and

Line 1093: hr_api.validate_bus_grp_id

1089: --
1090: l_other_manager_warning := FALSE;
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: );

Line 2217: hr_api.validate_bus_grp_id

2213: l_no_managers_warning := FALSE;
2214:
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

Line 2842: nvl(per_asg_shd.g_old_rec.assignment_type, hr_api.g_varchar2)

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

Line 3403: and nvl(date_end,hr_api.g_eot);

3399: from per_applications
3400: where application_id = p_application_id
3401: and p_validation_start_date
3402: between date_received
3403: and nvl(date_end,hr_api.g_eot);
3404: --
3405: begin
3406: if g_debug then
3407: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 3413: hr_api.mandatory_arg_error

3409: --
3410: --
3411: -- Check mandatory parameters have been set
3412: --
3413: hr_api.mandatory_arg_error
3414: (p_api_name => l_proc
3415: ,p_argument => 'effective_date'
3416: ,p_argument_value => p_effective_date
3417: );

Line 3419: hr_api.mandatory_arg_error

3415: ,p_argument => 'effective_date'
3416: ,p_argument_value => p_effective_date
3417: );
3418: --
3419: hr_api.mandatory_arg_error
3420: (p_api_name => l_proc
3421: ,p_argument => 'validation_start_date'
3422: ,p_argument_value => p_validation_start_date
3423: );

Line 3441: nvl(per_asg_shd.g_old_rec.application_id, hr_api.g_number)

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

Line 3442: <> nvl(p_application_id, hr_api.g_number))

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
3446: hr_utility.set_location(l_proc, 40);

Line 3622: hr_api.mandatory_arg_error

3618: if g_debug then
3619: hr_utility.set_location('Entering: '|| l_proc, 10);
3620: end if;
3621: --
3622: hr_api.mandatory_arg_error
3623: (p_api_name => l_proc
3624: ,p_argument => 'person_id'
3625: ,p_argument_value => p_person_id
3626: );

Line 3628: hr_api.mandatory_arg_error

3624: ,p_argument => 'person_id'
3625: ,p_argument_value => p_person_id
3626: );
3627: --
3628: hr_api.mandatory_arg_error
3629: (p_api_name => l_proc
3630: ,p_argument => 'business_group_id'
3631: ,p_argument_value => p_business_group_id
3632: );

Line 3634: hr_api.mandatory_arg_error

3630: ,p_argument => 'business_group_id'
3631: ,p_argument_value => p_business_group_id
3632: );
3633: --
3634: hr_api.mandatory_arg_error
3635: (p_api_name => l_proc
3636: ,p_argument => 'assignment_type'
3637: ,p_argument_value => p_assignment_type
3638: );

Line 3640: hr_api.mandatory_arg_error

3636: ,p_argument => 'assignment_type'
3637: ,p_argument_value => p_assignment_type
3638: );
3639: --
3640: hr_api.mandatory_arg_error
3641: (p_api_name => l_proc
3642: ,p_argument => 'assignment_sequence'
3643: ,p_argument_value => p_assignment_sequence
3644: );

Line 3668: nvl(per_asg_shd.g_old_rec.assignment_number, hr_api.g_varchar2) <>

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

Line 3669: nvl(p_assignment_number, hr_api.g_varchar2)) or

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
3673: hr_utility.set_location(l_proc, 40);

Line 3755: nvl(per_asg_shd.g_old_rec.assignment_type, hr_api.g_varchar2)

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

Line 3850: nvl(per_asg_shd.g_old_rec.assignment_category, hr_api.g_varchar2) <>

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

Line 3851: nvl(p_assignment_category, hr_api.g_varchar2)) OR

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
3855: hr_utility.set_location(l_proc, 40);

Line 3864: IF hr_api.not_exists_in_dt_hr_lookups

3860: --
3861: IF p_assignment_type = 'C' AND
3862: p_assignment_category IS NOT NULL THEN
3863: --
3864: IF hr_api.not_exists_in_dt_hr_lookups
3865: (p_effective_date => p_effective_date
3866: ,p_validation_start_date => p_validation_start_date
3867: ,p_validation_end_date => p_validation_end_date
3868: ,p_lookup_type => 'CWK_ASG_CATEGORY'

Line 3977: if nvl(p_assignment_status_type_id, hr_api.g_number) = hr_api.g_number then

3973: ) then
3974: --
3975: -- If p_assignment_status_type_id is g_number then derive it's default value.
3976: --
3977: if nvl(p_assignment_status_type_id, hr_api.g_number) = hr_api.g_number then
3978: --
3979: if g_debug then
3980: hr_utility.set_location(l_proc, 10);
3981: end if;

Line 4136: select nvl(min(asg.effective_start_date), hr_api.g_eot)

4132: -- the first assignment datetracked instance with assignment
4133: -- status type PER_SYSTEM_STATUS of 'ACTIVE_ASSIGN'
4134: --
4135: cursor csr_get_initial_ins_date is
4136: select nvl(min(asg.effective_start_date), hr_api.g_eot)
4137: from per_all_assignments_f asg
4138: ,per_assignment_status_types ast
4139: where asg.assignment_id = p_rec.assignment_id
4140: and ast.assignment_status_type_id = asg.assignment_status_type_id

Line 4172: hr_api.mandatory_arg_error

4168: end if;
4169: --
4170: -- Check mandatory parameters have been set.
4171: --
4172: hr_api.mandatory_arg_error
4173: (p_api_name => l_proc
4174: ,p_argument => 'assignment_status_type_id'
4175: ,p_argument_value => p_rec.assignment_status_type_id
4176: );

Line 4178: hr_api.mandatory_arg_error

4174: ,p_argument => 'assignment_status_type_id'
4175: ,p_argument_value => p_rec.assignment_status_type_id
4176: );
4177: --
4178: hr_api.mandatory_arg_error
4179: (p_api_name => l_proc
4180: ,p_argument => 'effective_date'
4181: ,p_argument_value => p_effective_date
4182: );

Line 4184: hr_api.mandatory_arg_error

4180: ,p_argument => 'effective_date'
4181: ,p_argument_value => p_effective_date
4182: );
4183: --
4184: hr_api.mandatory_arg_error
4185: (p_api_name => l_proc
4186: ,p_argument => 'validation_start_date'
4187: ,p_argument_value => p_validation_start_date
4188: );

Line 4190: hr_api.mandatory_arg_error

4186: ,p_argument => 'validation_start_date'
4187: ,p_argument_value => p_validation_start_date
4188: );
4189: --
4190: hr_api.mandatory_arg_error
4191: (p_api_name => l_proc
4192: ,p_argument => 'business_group_id'
4193: ,p_argument_value => p_rec.business_group_id
4194: );

Line 4438: and nvl(per_asg_shd.g_old_rec.assignment_status_type_id, hr_api.g_number)

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

Line 4439: <> nvl(p_rec.assignment_status_type_id, hr_api.g_number)

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
4443: if g_debug then

Line 4768: hr_api.mandatory_arg_error

4764: end if;
4765: --
4766: -- Check mandatory parameters have been set
4767: --
4768: hr_api.mandatory_arg_error
4769: (p_api_name => l_proc
4770: ,p_argument => 'assignment_type'
4771:
4772: ,p_argument_value => p_assignment_type

Line 4792: nvl(per_asg_shd.g_old_rec.assignment_type, hr_api.g_varchar2) <>

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

Line 4793: nvl(p_assignment_type, hr_api.g_varchar2))

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
4797: if g_debug then

Line 4939: hr_api.mandatory_arg_error

4935: end if;
4936: --
4937: -- Check mandatory arguments
4938: --
4939: hr_api.mandatory_arg_error
4940: (p_api_name => l_proc
4941: ,p_argument => 'effective_date'
4942: ,p_argument_value => p_effective_date
4943: );

Line 4945: hr_api.mandatory_arg_error

4941: ,p_argument => 'effective_date'
4942: ,p_argument_value => p_effective_date
4943: );
4944: --
4945: hr_api.mandatory_arg_error
4946: (p_api_name => l_proc
4947: ,p_argument => 'validation_start_date'
4948: ,p_argument_value => p_validation_start_date
4949: );

Line 4951: hr_api.mandatory_arg_error

4947: ,p_argument => 'validation_start_date'
4948: ,p_argument_value => p_validation_start_date
4949: );
4950: --
4951: hr_api.mandatory_arg_error
4952: (p_api_name => l_proc
4953: ,p_argument => 'validation_end_date'
4954: ,p_argument_value => p_validation_end_date
4955: );

Line 4970: nvl(per_asg_shd.g_old_rec.change_reason, hr_api.g_varchar2) <>

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

Line 4971: nvl(p_change_reason, hr_api.g_varchar2))

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
4975: if g_debug then

Line 4992: if hr_api.not_exists_in_dt_hr_lookups

4988: -- lookup type 'EMP_ASSIGN_REASON' with an enabled flag set to 'Y'
4989: -- and that the effective strt date of the assignment is between
4990: -- start date active and end date active in hr_lookups.
4991: --
4992: if hr_api.not_exists_in_dt_hr_lookups
4993: (p_effective_date => p_effective_date
4994: ,p_validation_start_date => p_validation_start_date
4995: ,p_validation_end_date => p_validation_end_date
4996: ,p_lookup_type => 'EMP_ASSIGN_REASON'

Line 5020: IF hr_api.not_exists_in_dt_hr_lookups

5016: -- lookup type 'CWK_ASSIGN_REASON' with an enabled flag set to 'Y'
5017: -- and that the effective start date of the assignment is between
5018: -- start date active and end date active in hr_lookups.
5019: --
5020: IF hr_api.not_exists_in_dt_hr_lookups
5021: (p_effective_date => p_effective_date
5022: ,p_validation_start_date => p_validation_start_date
5023: ,p_validation_end_date => p_validation_end_date
5024: ,p_lookup_type => 'CWK_ASSIGN_REASON'

Line 5043: if hr_api.not_exists_in_dt_hr_lookups

5039: -- lookup type 'APL_ASSIGN_REASON' with an enabled flag set to 'Y'
5040: -- and that the effective strt date of the assignment is between
5041: -- start date active and end date active in hr_lookups.
5042: --
5043: if hr_api.not_exists_in_dt_hr_lookups
5044: (p_effective_date => p_effective_date
5045: ,p_validation_start_date => p_validation_start_date
5046: ,p_validation_end_date => p_validation_end_date
5047: ,p_lookup_type => 'APL_ASSIGN_REASON'

Line 5141: nvl(ppos2.actual_termination_date, hr_api.g_eot)

5137: and (exists(select null
5138: from per_all_assignments_f pas2
5139: , per_periods_of_service ppos2
5140: where pas2.effective_end_date =
5141: nvl(ppos2.actual_termination_date, hr_api.g_eot)
5142: and pas.assignment_id = pas2.assignment_id
5143: and pas2.period_of_service_id = ppos2.period_of_service_id ))); -- Added this last filter for Bug 4300591.
5144: --
5145: begin

Line 5152: hr_api.mandatory_arg_error

5148: end if;
5149: --
5150: -- Check mandatory parameters have been set
5151: --
5152: hr_api.mandatory_arg_error
5153: (p_api_name => l_proc
5154: ,p_argument => 'primary_flag'
5155: ,p_argument_value => p_primary_flag
5156: );

Line 5227: hr_api.mandatory_arg_error

5223: end if;
5224: --
5225: -- Check mandatory parameters have been set
5226: --
5227: hr_api.mandatory_arg_error
5228: (p_api_name => l_proc
5229: ,p_argument => 'assignment_type'
5230: ,p_argument_value => p_assignment_type
5231: );

Line 5233: hr_api.mandatory_arg_error

5229: ,p_argument => 'assignment_type'
5230: ,p_argument_value => p_assignment_type
5231: );
5232: --
5233: hr_api.mandatory_arg_error
5234: (p_api_name => l_proc
5235: ,p_argument => 'validation_start_date'
5236: ,p_argument_value => p_validation_start_date
5237: );

Line 5239: hr_api.mandatory_arg_error

5235: ,p_argument => 'validation_start_date'
5236: ,p_argument_value => p_validation_start_date
5237: );
5238: --
5239: hr_api.mandatory_arg_error
5240: (p_api_name => l_proc
5241: ,p_argument => 'effective_date'
5242: ,p_argument_value => p_effective_date
5243: );

Line 5258: nvl(per_asg_shd.g_old_rec.date_probation_end, hr_api.g_date)

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

Line 5259: <> nvl(p_date_probation_end, hr_api.g_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
5263: if g_debug then

Line 5358: between nvl(start_date_active,hr_api.g_sot)

5354: from gl_code_combinations
5355: where code_combination_id = p_default_code_comb_id
5356: and enabled_flag = 'Y'
5357: and p_validation_start_date
5358: between nvl(start_date_active,hr_api.g_sot)
5359: and nvl(end_date_active,hr_api.g_eot);
5360: --
5361: begin
5362: if g_debug then

Line 5359: and nvl(end_date_active,hr_api.g_eot);

5355: where code_combination_id = p_default_code_comb_id
5356: and enabled_flag = 'Y'
5357: and p_validation_start_date
5358: between nvl(start_date_active,hr_api.g_sot)
5359: and nvl(end_date_active,hr_api.g_eot);
5360: --
5361: begin
5362: if g_debug then
5363: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 5368: hr_api.mandatory_arg_error

5364: end if;
5365: --
5366: -- Check mandatory parameters have been set
5367: --
5368: hr_api.mandatory_arg_error
5369: (p_api_name => l_proc
5370: ,p_argument => 'effective_date'
5371: ,p_argument_value => p_effective_date
5372: );

Line 5391: nvl(per_asg_shd.g_old_rec.default_code_comb_id, hr_api.g_number) <>

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

Line 5392: nvl(p_default_code_comb_id, hr_api.g_number)) or

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
5396: hr_utility.set_location(l_proc, 40);

Line 5548: hr_api.mandatory_arg_error

5544: end if;
5545: --
5546: -- Check mandatory parameters have been set
5547: --
5548: hr_api.mandatory_arg_error
5549: (p_api_name => l_proc
5550: ,p_argument => 'effective_date'
5551: ,p_argument_value => p_effective_date
5552: );

Line 5554: hr_api.mandatory_arg_error

5550: ,p_argument => 'effective_date'
5551: ,p_argument_value => p_effective_date
5552: );
5553: --
5554: hr_api.mandatory_arg_error
5555: (p_api_name => l_proc
5556: ,p_argument => 'validation_start_date'
5557: ,p_argument_value => p_validation_start_date
5558: );

Line 5560: hr_api.mandatory_arg_error

5556: ,p_argument => 'validation_start_date'
5557: ,p_argument_value => p_validation_start_date
5558: );
5559: --
5560: hr_api.mandatory_arg_error
5561: (p_api_name => l_proc
5562: ,p_argument => 'validation_end_date'
5563: ,p_argument_value => p_validation_end_date
5564: );

Line 5579: nvl(per_asg_shd.g_old_rec.employment_category, hr_api.g_varchar2) <>

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

Line 5580: nvl(p_employment_category, hr_api.g_varchar2))

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
5584: hr_utility.set_location(l_proc, 40);

Line 5609: if hr_api.not_exists_in_dt_hr_lookups

5605: --
5606: -- Bug 1472162.
5607: --
5608: /*
5609: if hr_api.not_exists_in_dt_hr_lookups
5610: (p_effective_date => p_effective_date
5611: ,p_validation_start_date => p_validation_start_date
5612: ,p_validation_end_date => p_validation_end_date
5613: ,p_lookup_type => 'EMP_CAT'

Line 5626: if hr_api.not_exists_in_leg_lookups

5622: if g_debug then
5623: hr_utility.set_location(l_proc, 60);
5624: end if;
5625:
5626: if hr_api.not_exists_in_leg_lookups
5627: (p_effective_date => p_effective_date
5628: ,p_lookup_type => 'EMP_CAT'
5629: ,p_lookup_code => p_employment_category
5630: )

Line 5713: hr_api.mandatory_arg_error

5709: end if;
5710: --
5711: -- Check mandatory parameters
5712: --
5713: hr_api.mandatory_arg_error
5714: (p_api_name => l_proc
5715: ,p_argument => 'effective_date'
5716: ,p_argument_value => p_effective_date
5717: );

Line 5719: hr_api.mandatory_arg_error

5715: ,p_argument => 'effective_date'
5716: ,p_argument_value => p_effective_date
5717: );
5718: --
5719: hr_api.mandatory_arg_error
5720: (p_api_name => l_proc
5721: ,p_argument => 'validation_start_date'
5722: ,p_argument_value => p_validation_start_date
5723: );

Line 5725: hr_api.mandatory_arg_error

5721: ,p_argument => 'validation_start_date'
5722: ,p_argument_value => p_validation_start_date
5723: );
5724: --
5725: hr_api.mandatory_arg_error
5726: (p_api_name => l_proc
5727: ,p_argument => 'validation_end_date'
5728: ,p_argument_value => p_validation_end_date
5729: );

Line 5748: nvl(per_asg_shd.g_old_rec.frequency, hr_api.g_varchar2) <>

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

Line 5749: nvl(p_frequency, hr_api.g_varchar2)) or

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
5753: hr_utility.set_location(l_proc||' '||p_frequency, 40);

Line 5765: if hr_api.not_exists_in_dt_hr_lookups

5761: -- type 'FREQUENCY' with an enabled flag set to 'Y' and that the
5762: -- effective start date of the assignment is between start date
5763: -- active and end date active in hr_lookups.
5764: --
5765: if hr_api.not_exists_in_dt_hr_lookups
5766: (p_effective_date => p_effective_date
5767: ,p_validation_start_date => p_validation_start_date
5768: ,p_validation_end_date => p_validation_end_date
5769: ,p_lookup_type => 'FREQUENCY'

Line 5859: hr_api.mandatory_arg_error

5855: end if;
5856: --
5857: -- Check mandatory parameters have been set
5858: --
5859: hr_api.mandatory_arg_error
5860: (p_api_name => l_proc
5861: ,p_argument => 'primary flag'
5862: ,p_argument_value => p_primary_flag
5863: );

Line 5928: between date_from and nvl(date_to, hr_api.g_eot);

5924: select business_group_id
5925: from per_grades
5926: where grade_id = p_grade_id
5927: and p_validation_start_date
5928: between date_from and nvl(date_to, hr_api.g_eot);
5929: --
5930: begin
5931: if g_debug then
5932: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 5938: hr_api.mandatory_arg_error

5934: --
5935: --
5936: -- Check mandatory parameters have been set
5937: --
5938: hr_api.mandatory_arg_error
5939: (p_api_name => l_proc
5940: ,p_argument => 'effective_date'
5941: ,p_argument_value => p_effective_date
5942: );

Line 5944: hr_api.mandatory_arg_error

5940: ,p_argument => 'effective_date'
5941: ,p_argument_value => p_effective_date
5942: );
5943: --
5944: hr_api.mandatory_arg_error
5945: (p_api_name => l_proc
5946: ,p_argument => 'validation_start_date'
5947: ,p_argument_value => p_validation_start_date
5948: );

Line 5950: hr_api.mandatory_arg_error

5946: ,p_argument => 'validation_start_date'
5947: ,p_argument_value => p_validation_start_date
5948: );
5949: --
5950: hr_api.mandatory_arg_error
5951: (p_api_name => l_proc
5952: ,p_argument => 'validation_end_date'
5953: ,p_argument_value => p_validation_end_date
5954: );

Line 5956: hr_api.mandatory_arg_error

5952: ,p_argument => 'validation_end_date'
5953: ,p_argument_value => p_validation_end_date
5954: );
5955: --
5956: hr_api.mandatory_arg_error
5957: (p_api_name => l_proc
5958: ,p_argument => 'business_group_id'
5959: ,p_argument_value => p_business_group_id
5960: );

Line 5979: nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>

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);

Line 5980: nvl(p_grade_id, hr_api.g_number)) or

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);
5984: end if;

Line 6079: and nvl(date_to, hr_api.g_eot);

6075: from per_jobs_v
6076: where job_id = p_job_id
6077: and p_validation_start_date
6078: between date_from
6079: and nvl(date_to, hr_api.g_eot);
6080: */
6081: cursor csr_valid_job is
6082: select job.business_group_id
6083: from per_jobs job

Line 6088: and nvl(job.date_to, hr_api.g_eot))

6084: , per_job_groups jgr
6085: where job.job_id = p_job_id
6086: and (p_validation_start_date
6087: between job.date_from
6088: and nvl(job.date_to, hr_api.g_eot))
6089: and job.job_group_id = jgr.job_group_id
6090: and jgr.internal_name = 'HR_'||jgr.business_group_id
6091: and (jgr.business_group_id = job.business_group_id
6092: or jgr.business_group_id is null);

Line 6104: hr_api.mandatory_arg_error

6100: --
6101: --
6102: -- Check mandatory arguments
6103: --
6104: hr_api.mandatory_arg_error
6105: (p_api_name => l_proc
6106: ,p_argument => 'effective_date'
6107: ,p_argument_value => p_effective_date
6108: );

Line 6110: hr_api.mandatory_arg_error

6106: ,p_argument => 'effective_date'
6107: ,p_argument_value => p_effective_date
6108: );
6109: --
6110: hr_api.mandatory_arg_error
6111: (p_api_name => l_proc
6112: ,p_argument => 'validation_start_date'
6113: ,p_argument_value => p_validation_start_date
6114: );

Line 6116: hr_api.mandatory_arg_error

6112: ,p_argument => 'validation_start_date'
6113: ,p_argument_value => p_validation_start_date
6114: );
6115: --
6116: hr_api.mandatory_arg_error
6117: (p_api_name => l_proc
6118: ,p_argument => 'validation_end_date'
6119: ,p_argument_value => p_validation_end_date
6120: );

Line 6142: hr_api.g_number) <> nvl(p_job_id, hr_api.g_number))

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
6146: hr_utility.set_location(l_proc, 40);

Line 6233: and nvl(date_to, hr_api.g_eot);

6229: from per_valid_grades
6230: where job_id = p_job_id
6231: and p_validation_start_date
6232: between date_from
6233: and nvl(date_to, hr_api.g_eot);
6234: --
6235: -- Bug 3566686 Ends Here
6236: --
6237: cursor csr_val_job_grade is

Line 6244: and nvl(date_to, hr_api.g_eot);

6240: where job_id = p_job_id
6241: and grade_id = p_grade_id
6242: and p_validation_start_date
6243: between date_from
6244: and nvl(date_to, hr_api.g_eot);
6245: --
6246:
6247: -- Bug13041074 fix
6248: cursor csr_assignment_type is

Line 6266: hr_api.mandatory_arg_error

6262: ) then
6263: --
6264: -- Check mandatory arguments
6265: --
6266: hr_api.mandatory_arg_error
6267: (p_api_name => l_proc
6268: ,p_argument => 'effective_date'
6269: ,p_argument_value => p_effective_date
6270: );

Line 6272: hr_api.mandatory_arg_error

6268: ,p_argument => 'effective_date'
6269: ,p_argument_value => p_effective_date
6270: );
6271: --
6272: hr_api.mandatory_arg_error
6273: (p_api_name => l_proc
6274: ,p_argument => 'validation_start_date'
6275: ,p_argument_value => p_validation_start_date
6276: );

Line 6278: hr_api.mandatory_arg_error

6274: ,p_argument => 'validation_start_date'
6275: ,p_argument_value => p_validation_start_date
6276: );
6277: --
6278: hr_api.mandatory_arg_error
6279: (p_api_name => l_proc
6280: ,p_argument => 'validation_end_date'
6281: ,p_argument_value => p_validation_end_date
6282: );

Line 6304: ((nvl(per_asg_shd.g_old_rec.job_id, hr_api.g_number)

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))))

Line 6305: <> nvl(p_job_id, hr_api.g_number))

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))))
6309: or

Line 6307: (nvl(per_asg_shd.g_old_rec.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

Line 6308: <> nvl(p_grade_id, hr_api.g_number))))

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
6312: hr_utility.set_location(l_proc, 40);

Line 6467: hr_api.mandatory_arg_error

6463: --
6464: --
6465: -- Check mandatory parameters have been set
6466: --
6467: hr_api.mandatory_arg_error
6468: (p_api_name => l_proc
6469: ,p_argument => 'effective_date'
6470: ,p_argument_value => p_effective_date
6471: );

Line 6473: hr_api.mandatory_arg_error

6469: ,p_argument => 'effective_date'
6470: ,p_argument_value => p_effective_date
6471: );
6472: --
6473: hr_api.mandatory_arg_error
6474: (p_api_name => l_proc
6475: ,p_argument => 'validation_start_date'
6476: ,p_argument_value => p_validation_start_date
6477: );

Line 6479: hr_api.mandatory_arg_error

6475: ,p_argument => 'validation_start_date'
6476: ,p_argument_value => p_validation_start_date
6477: );
6478: --
6479: hr_api.mandatory_arg_error
6480: (p_api_name => l_proc
6481: ,p_argument => 'validation_end_date'
6482: ,p_argument_value => p_validation_end_date
6483: );

Line 6502: nvl(per_asg_shd.g_old_rec.location_id, hr_api.g_number) <>

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: --

Line 6503: nvl(p_location_id, hr_api.g_number)) or

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: --
6507: if g_debug then

Line 6550: if p_validation_start_date >= nvl(l_inactive_date,hr_api.g_eot)

6546: --
6547: -- Check if the assignment ESD is before the location inactive date
6548: -- on insert
6549: --
6550: if p_validation_start_date >= nvl(l_inactive_date,hr_api.g_eot)
6551: then
6552: --
6553: hr_utility.set_message(801, 'HR_51215_ASG_INACT_LOCATION');
6554: hr_multi_message.add

Line 6599: hr_api.mandatory_arg_error

6595: end if;
6596: --
6597: -- Check mandatory parameters have been set
6598: --
6599: hr_api.mandatory_arg_error
6600: (p_api_name => l_proc
6601: ,p_argument => 'effective_date'
6602: ,p_argument_value => p_effective_date
6603: );

Line 6605: hr_api.mandatory_arg_error

6601: ,p_argument => 'effective_date'
6602: ,p_argument_value => p_effective_date
6603: );
6604: --
6605: hr_api.mandatory_arg_error
6606: (p_api_name => l_proc
6607: ,p_argument => 'organization_id'
6608: ,p_argument_value => p_organization_id
6609: );

Line 6628: nvl(per_asg_shd.g_old_rec.manager_flag, hr_api.g_varchar2) <>

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

Line 6629: nvl(p_manager_flag, hr_api.g_varchar2))

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
6633: if g_debug then

Line 6767: hr_api.mandatory_arg_error

6763: ) then
6764: --
6765: -- Check mandatory parameters have been set
6766: --
6767: hr_api.mandatory_arg_error
6768: (p_api_name => l_proc
6769: ,p_argument => 'effective_date'
6770: ,p_argument_value => p_effective_date
6771: );

Line 6790: ((nvl(per_asg_shd.g_old_rec.frequency, hr_api.g_varchar2) <>

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))))

Line 6791: nvl(p_frequency, hr_api.g_varchar2))

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))))
6795: or

Line 6793: (nvl(per_asg_shd.g_old_rec.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

Line 6794: nvl(p_normal_hours, hr_api.g_number))))

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
6798: if g_debug then

Line 6902: hr_api.mandatory_arg_error

6898: --
6899: --
6900: -- Check mandatory parameters have been set
6901: --
6902: hr_api.mandatory_arg_error
6903: (p_api_name => l_proc
6904: ,p_argument => 'effective_date'
6905: ,p_argument_value => p_effective_date
6906: );

Line 6908: hr_api.mandatory_arg_error

6904: ,p_argument => 'effective_date'
6905: ,p_argument_value => p_effective_date
6906: );
6907: --
6908: hr_api.mandatory_arg_error
6909: (p_api_name => l_proc
6910: ,p_argument => 'organization_id'
6911: ,p_argument_value => p_organization_id
6912: );

Line 6914: hr_api.mandatory_arg_error

6910: ,p_argument => 'organization_id'
6911: ,p_argument_value => p_organization_id
6912: );
6913: --
6914: hr_api.mandatory_arg_error
6915: (p_api_name => l_proc
6916: ,p_argument => 'business_group_id'
6917: ,p_argument_value => p_business_group_id
6918: );

Line 6920: hr_api.mandatory_arg_error

6916: ,p_argument => 'business_group_id'
6917: ,p_argument_value => p_business_group_id
6918: );
6919: --
6920: hr_api.mandatory_arg_error
6921: (p_api_name => l_proc
6922: ,p_argument => 'validation_start_date'
6923: ,p_argument_value => p_validation_start_date
6924: );

Line 6926: hr_api.mandatory_arg_error

6922: ,p_argument => 'validation_start_date'
6923: ,p_argument_value => p_validation_start_date
6924: );
6925: --
6926: hr_api.mandatory_arg_error
6927: (p_api_name => l_proc
6928: ,p_argument => 'validation_end_date'
6929: ,p_argument_value => p_validation_end_date
6930: );

Line 7130: hr_api.mandatory_arg_error

7126: end if;
7127: --
7128: -- Check mandatory parameters have been set
7129: --
7130: hr_api.mandatory_arg_error
7131: (p_api_name => l_proc
7132: ,p_argument => 'effective_date'
7133: ,p_argument_value => p_effective_date
7134: );

Line 7140: if hr_api.not_exists_in_dt_hr_lookups

7136: hr_utility.set_location(l_proc, 20);
7137: end if;
7138: --
7139: if p_bargaining_unit_code is NOT NULL then
7140: if hr_api.not_exists_in_dt_hr_lookups
7141: (p_effective_date => p_effective_date
7142: ,p_validation_start_date => p_validation_start_date
7143: ,p_validation_end_date => p_validation_end_date
7144: ,p_lookup_type => 'BARGAINING_UNIT_CODE'

Line 7235: hr_api.mandatory_arg_error

7231: --
7232: --
7233: -- Check mandatory parameters have been set
7234: --
7235: hr_api.mandatory_arg_error
7236: (p_api_name => l_proc
7237: ,p_argument => 'effective_date'
7238: ,p_argument_value => p_effective_date
7239: );

Line 7256: if hr_api.not_exists_in_dt_hr_lookups

7252: --
7253: END IF;
7254: --
7255: if p_hourly_salaried_code is NOT NULL then
7256: if hr_api.not_exists_in_dt_hr_lookups
7257: (p_effective_date => p_effective_date
7258: ,p_validation_start_date => p_validation_start_date
7259: ,p_validation_end_date => p_validation_end_date
7260: ,p_lookup_type => 'HOURLY_SALARIED_CODE'

Line 7332: hr_api.mandatory_arg_error(p_api_name => l_proc,

7328: end if;
7329: --
7330: -- Ensure that all the mandatory parameter are not null
7331: --
7332: hr_api.mandatory_arg_error(p_api_name => l_proc,
7333: p_argument => 'assignment_id',
7334: p_argument_value => p_assignment_id);
7335: --
7336: --

Line 7337: if nvl(g_assignment_id, hr_api.g_number) = p_assignment_id then

7333: p_argument => 'assignment_id',
7334: p_argument_value => p_assignment_id);
7335: --
7336: --
7337: if nvl(g_assignment_id, hr_api.g_number) = p_assignment_id then
7338: --
7339: -- The legislation code has already been found with a previous
7340: -- call to this function. Just return the value in the global
7341: -- variable.

Line 7657: hr_api.mandatory_arg_error

7653: end if;
7654: --
7655: -- Check mandatory parameters have been set
7656: --
7657: hr_api.mandatory_arg_error
7658: (p_api_name => l_proc
7659: ,p_argument => 'effective_date'
7660: ,p_argument_value => p_effective_date
7661: );

Line 7757: hr_api.mandatory_arg_error

7753: ) then
7754: --
7755: -- Check mandatory parameters have been set
7756: --
7757: hr_api.mandatory_arg_error
7758: (p_api_name => l_proc
7759: ,p_argument => 'effective_date'
7760: ,p_argument_value => p_effective_date
7761: );

Line 7778: (nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>

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))

Line 7779: nvl(p_position_id, hr_api.g_number))

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))
7783: )

Line 7781: (nvl(per_asg_shd.g_old_rec.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

Line 7782: nvl(p_assignment_type, hr_api.g_varchar2))

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
7786: (NOT l_api_updating)