14: ,p_effective_date IN DATE
15: ,p_datetrack_update_mode IN VARCHAR2
16: ,p_assignment_id IN NUMBER
17: ,p_object_version_number IN OUT NOCOPY NUMBER
18: ,p_grade_id IN NUMBER DEFAULT HR_API.G_NUMBER
19: ,p_position_id IN NUMBER DEFAULT HR_API.G_NUMBER
20: ,p_job_id IN NUMBER DEFAULT HR_API.G_NUMBER
21: ,p_location_id IN NUMBER DEFAULT HR_API.G_NUMBER
22: ,p_organization_id IN NUMBER DEFAULT HR_API.G_NUMBER
15: ,p_datetrack_update_mode IN VARCHAR2
16: ,p_assignment_id IN NUMBER
17: ,p_object_version_number IN OUT NOCOPY NUMBER
18: ,p_grade_id IN NUMBER DEFAULT HR_API.G_NUMBER
19: ,p_position_id IN NUMBER DEFAULT HR_API.G_NUMBER
20: ,p_job_id IN NUMBER DEFAULT HR_API.G_NUMBER
21: ,p_location_id IN NUMBER DEFAULT HR_API.G_NUMBER
22: ,p_organization_id IN NUMBER DEFAULT HR_API.G_NUMBER
23: ,p_people_group_name OUT NOCOPY VARCHAR2
16: ,p_assignment_id IN NUMBER
17: ,p_object_version_number IN OUT NOCOPY NUMBER
18: ,p_grade_id IN NUMBER DEFAULT HR_API.G_NUMBER
19: ,p_position_id IN NUMBER DEFAULT HR_API.G_NUMBER
20: ,p_job_id IN NUMBER DEFAULT HR_API.G_NUMBER
21: ,p_location_id IN NUMBER DEFAULT HR_API.G_NUMBER
22: ,p_organization_id IN NUMBER DEFAULT HR_API.G_NUMBER
23: ,p_people_group_name OUT NOCOPY VARCHAR2
24: ,p_effective_start_date OUT NOCOPY DATE
17: ,p_object_version_number IN OUT NOCOPY NUMBER
18: ,p_grade_id IN NUMBER DEFAULT HR_API.G_NUMBER
19: ,p_position_id IN NUMBER DEFAULT HR_API.G_NUMBER
20: ,p_job_id IN NUMBER DEFAULT HR_API.G_NUMBER
21: ,p_location_id IN NUMBER DEFAULT HR_API.G_NUMBER
22: ,p_organization_id IN NUMBER DEFAULT HR_API.G_NUMBER
23: ,p_people_group_name OUT NOCOPY VARCHAR2
24: ,p_effective_start_date OUT NOCOPY DATE
25: ,p_effective_end_date OUT NOCOPY DATE
18: ,p_grade_id IN NUMBER DEFAULT HR_API.G_NUMBER
19: ,p_position_id IN NUMBER DEFAULT HR_API.G_NUMBER
20: ,p_job_id IN NUMBER DEFAULT HR_API.G_NUMBER
21: ,p_location_id IN NUMBER DEFAULT HR_API.G_NUMBER
22: ,p_organization_id IN NUMBER DEFAULT HR_API.G_NUMBER
23: ,p_people_group_name OUT NOCOPY VARCHAR2
24: ,p_effective_start_date OUT NOCOPY DATE
25: ,p_effective_end_date OUT NOCOPY DATE
26: ,p_people_group_id OUT NOCOPY NUMBER
79: hr_utility.set_location(' Leaving:'||l_proc, 997);
80: --
81: EXCEPTION
82: --
83: WHEN hr_api.validate_enabled THEN
84: --
85: -- As the Validate_Enabled exception has been raised
86: -- we must rollback to the savepoint
87: --
134: -- ----------------------------------------------------------------------------
135: --
136: procedure move_emp_asg
137: (p_validate in boolean default false
138: ,p_mass_move_id in number default hr_api.g_number
139: ,p_effective_date in date
140: ,p_assignment_id in number
141: ,p_object_version_number in out nocopy number
142: ,p_grade_id in number default hr_api.g_number
138: ,p_mass_move_id in number default hr_api.g_number
139: ,p_effective_date in date
140: ,p_assignment_id in number
141: ,p_object_version_number in out nocopy number
142: ,p_grade_id in number default hr_api.g_number
143: ,p_position_id in number default hr_api.g_number
144: ,p_job_id in number default hr_api.g_number
145: ,p_organization_id in number default hr_api.g_number
146: ,p_location_id in number default hr_api.g_number
139: ,p_effective_date in date
140: ,p_assignment_id in number
141: ,p_object_version_number in out nocopy number
142: ,p_grade_id in number default hr_api.g_number
143: ,p_position_id in number default hr_api.g_number
144: ,p_job_id in number default hr_api.g_number
145: ,p_organization_id in number default hr_api.g_number
146: ,p_location_id in number default hr_api.g_number
147: ,p_frequency in varchar2 default hr_api.g_varchar2
140: ,p_assignment_id in number
141: ,p_object_version_number in out nocopy number
142: ,p_grade_id in number default hr_api.g_number
143: ,p_position_id in number default hr_api.g_number
144: ,p_job_id in number default hr_api.g_number
145: ,p_organization_id in number default hr_api.g_number
146: ,p_location_id in number default hr_api.g_number
147: ,p_frequency in varchar2 default hr_api.g_varchar2
148: ,p_normal_hours in number default hr_api.g_number
141: ,p_object_version_number in out nocopy number
142: ,p_grade_id in number default hr_api.g_number
143: ,p_position_id in number default hr_api.g_number
144: ,p_job_id in number default hr_api.g_number
145: ,p_organization_id in number default hr_api.g_number
146: ,p_location_id in number default hr_api.g_number
147: ,p_frequency in varchar2 default hr_api.g_varchar2
148: ,p_normal_hours in number default hr_api.g_number
149: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
142: ,p_grade_id in number default hr_api.g_number
143: ,p_position_id in number default hr_api.g_number
144: ,p_job_id in number default hr_api.g_number
145: ,p_organization_id in number default hr_api.g_number
146: ,p_location_id in number default hr_api.g_number
147: ,p_frequency in varchar2 default hr_api.g_varchar2
148: ,p_normal_hours in number default hr_api.g_number
149: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
150: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
143: ,p_position_id in number default hr_api.g_number
144: ,p_job_id in number default hr_api.g_number
145: ,p_organization_id in number default hr_api.g_number
146: ,p_location_id in number default hr_api.g_number
147: ,p_frequency in varchar2 default hr_api.g_varchar2
148: ,p_normal_hours in number default hr_api.g_number
149: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
150: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
151: ,p_segment1 in varchar2 default hr_api.g_varchar2
144: ,p_job_id in number default hr_api.g_number
145: ,p_organization_id in number default hr_api.g_number
146: ,p_location_id in number default hr_api.g_number
147: ,p_frequency in varchar2 default hr_api.g_varchar2
148: ,p_normal_hours in number default hr_api.g_number
149: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
150: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
151: ,p_segment1 in varchar2 default hr_api.g_varchar2
152: ,p_segment2 in varchar2 default hr_api.g_varchar2
145: ,p_organization_id in number default hr_api.g_number
146: ,p_location_id in number default hr_api.g_number
147: ,p_frequency in varchar2 default hr_api.g_varchar2
148: ,p_normal_hours in number default hr_api.g_number
149: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
150: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
151: ,p_segment1 in varchar2 default hr_api.g_varchar2
152: ,p_segment2 in varchar2 default hr_api.g_varchar2
153: ,p_segment3 in varchar2 default hr_api.g_varchar2
146: ,p_location_id in number default hr_api.g_number
147: ,p_frequency in varchar2 default hr_api.g_varchar2
148: ,p_normal_hours in number default hr_api.g_number
149: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
150: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
151: ,p_segment1 in varchar2 default hr_api.g_varchar2
152: ,p_segment2 in varchar2 default hr_api.g_varchar2
153: ,p_segment3 in varchar2 default hr_api.g_varchar2
154: ,p_segment4 in varchar2 default hr_api.g_varchar2
147: ,p_frequency in varchar2 default hr_api.g_varchar2
148: ,p_normal_hours in number default hr_api.g_number
149: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
150: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
151: ,p_segment1 in varchar2 default hr_api.g_varchar2
152: ,p_segment2 in varchar2 default hr_api.g_varchar2
153: ,p_segment3 in varchar2 default hr_api.g_varchar2
154: ,p_segment4 in varchar2 default hr_api.g_varchar2
155: ,p_segment5 in varchar2 default hr_api.g_varchar2
148: ,p_normal_hours in number default hr_api.g_number
149: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
150: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
151: ,p_segment1 in varchar2 default hr_api.g_varchar2
152: ,p_segment2 in varchar2 default hr_api.g_varchar2
153: ,p_segment3 in varchar2 default hr_api.g_varchar2
154: ,p_segment4 in varchar2 default hr_api.g_varchar2
155: ,p_segment5 in varchar2 default hr_api.g_varchar2
156: ,p_segment6 in varchar2 default hr_api.g_varchar2
149: ,p_time_normal_finish in varchar2 default hr_api.g_varchar2
150: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
151: ,p_segment1 in varchar2 default hr_api.g_varchar2
152: ,p_segment2 in varchar2 default hr_api.g_varchar2
153: ,p_segment3 in varchar2 default hr_api.g_varchar2
154: ,p_segment4 in varchar2 default hr_api.g_varchar2
155: ,p_segment5 in varchar2 default hr_api.g_varchar2
156: ,p_segment6 in varchar2 default hr_api.g_varchar2
157: ,p_segment7 in varchar2 default hr_api.g_varchar2
150: ,p_time_normal_start in varchar2 default hr_api.g_varchar2
151: ,p_segment1 in varchar2 default hr_api.g_varchar2
152: ,p_segment2 in varchar2 default hr_api.g_varchar2
153: ,p_segment3 in varchar2 default hr_api.g_varchar2
154: ,p_segment4 in varchar2 default hr_api.g_varchar2
155: ,p_segment5 in varchar2 default hr_api.g_varchar2
156: ,p_segment6 in varchar2 default hr_api.g_varchar2
157: ,p_segment7 in varchar2 default hr_api.g_varchar2
158: ,p_segment8 in varchar2 default hr_api.g_varchar2
151: ,p_segment1 in varchar2 default hr_api.g_varchar2
152: ,p_segment2 in varchar2 default hr_api.g_varchar2
153: ,p_segment3 in varchar2 default hr_api.g_varchar2
154: ,p_segment4 in varchar2 default hr_api.g_varchar2
155: ,p_segment5 in varchar2 default hr_api.g_varchar2
156: ,p_segment6 in varchar2 default hr_api.g_varchar2
157: ,p_segment7 in varchar2 default hr_api.g_varchar2
158: ,p_segment8 in varchar2 default hr_api.g_varchar2
159: ,p_segment9 in varchar2 default hr_api.g_varchar2
152: ,p_segment2 in varchar2 default hr_api.g_varchar2
153: ,p_segment3 in varchar2 default hr_api.g_varchar2
154: ,p_segment4 in varchar2 default hr_api.g_varchar2
155: ,p_segment5 in varchar2 default hr_api.g_varchar2
156: ,p_segment6 in varchar2 default hr_api.g_varchar2
157: ,p_segment7 in varchar2 default hr_api.g_varchar2
158: ,p_segment8 in varchar2 default hr_api.g_varchar2
159: ,p_segment9 in varchar2 default hr_api.g_varchar2
160: ,p_segment10 in varchar2 default hr_api.g_varchar2
153: ,p_segment3 in varchar2 default hr_api.g_varchar2
154: ,p_segment4 in varchar2 default hr_api.g_varchar2
155: ,p_segment5 in varchar2 default hr_api.g_varchar2
156: ,p_segment6 in varchar2 default hr_api.g_varchar2
157: ,p_segment7 in varchar2 default hr_api.g_varchar2
158: ,p_segment8 in varchar2 default hr_api.g_varchar2
159: ,p_segment9 in varchar2 default hr_api.g_varchar2
160: ,p_segment10 in varchar2 default hr_api.g_varchar2
161: ,p_segment11 in varchar2 default hr_api.g_varchar2
154: ,p_segment4 in varchar2 default hr_api.g_varchar2
155: ,p_segment5 in varchar2 default hr_api.g_varchar2
156: ,p_segment6 in varchar2 default hr_api.g_varchar2
157: ,p_segment7 in varchar2 default hr_api.g_varchar2
158: ,p_segment8 in varchar2 default hr_api.g_varchar2
159: ,p_segment9 in varchar2 default hr_api.g_varchar2
160: ,p_segment10 in varchar2 default hr_api.g_varchar2
161: ,p_segment11 in varchar2 default hr_api.g_varchar2
162: ,p_segment12 in varchar2 default hr_api.g_varchar2
155: ,p_segment5 in varchar2 default hr_api.g_varchar2
156: ,p_segment6 in varchar2 default hr_api.g_varchar2
157: ,p_segment7 in varchar2 default hr_api.g_varchar2
158: ,p_segment8 in varchar2 default hr_api.g_varchar2
159: ,p_segment9 in varchar2 default hr_api.g_varchar2
160: ,p_segment10 in varchar2 default hr_api.g_varchar2
161: ,p_segment11 in varchar2 default hr_api.g_varchar2
162: ,p_segment12 in varchar2 default hr_api.g_varchar2
163: ,p_segment13 in varchar2 default hr_api.g_varchar2
156: ,p_segment6 in varchar2 default hr_api.g_varchar2
157: ,p_segment7 in varchar2 default hr_api.g_varchar2
158: ,p_segment8 in varchar2 default hr_api.g_varchar2
159: ,p_segment9 in varchar2 default hr_api.g_varchar2
160: ,p_segment10 in varchar2 default hr_api.g_varchar2
161: ,p_segment11 in varchar2 default hr_api.g_varchar2
162: ,p_segment12 in varchar2 default hr_api.g_varchar2
163: ,p_segment13 in varchar2 default hr_api.g_varchar2
164: ,p_segment14 in varchar2 default hr_api.g_varchar2
157: ,p_segment7 in varchar2 default hr_api.g_varchar2
158: ,p_segment8 in varchar2 default hr_api.g_varchar2
159: ,p_segment9 in varchar2 default hr_api.g_varchar2
160: ,p_segment10 in varchar2 default hr_api.g_varchar2
161: ,p_segment11 in varchar2 default hr_api.g_varchar2
162: ,p_segment12 in varchar2 default hr_api.g_varchar2
163: ,p_segment13 in varchar2 default hr_api.g_varchar2
164: ,p_segment14 in varchar2 default hr_api.g_varchar2
165: ,p_segment15 in varchar2 default hr_api.g_varchar2
158: ,p_segment8 in varchar2 default hr_api.g_varchar2
159: ,p_segment9 in varchar2 default hr_api.g_varchar2
160: ,p_segment10 in varchar2 default hr_api.g_varchar2
161: ,p_segment11 in varchar2 default hr_api.g_varchar2
162: ,p_segment12 in varchar2 default hr_api.g_varchar2
163: ,p_segment13 in varchar2 default hr_api.g_varchar2
164: ,p_segment14 in varchar2 default hr_api.g_varchar2
165: ,p_segment15 in varchar2 default hr_api.g_varchar2
166: ,p_segment16 in varchar2 default hr_api.g_varchar2
159: ,p_segment9 in varchar2 default hr_api.g_varchar2
160: ,p_segment10 in varchar2 default hr_api.g_varchar2
161: ,p_segment11 in varchar2 default hr_api.g_varchar2
162: ,p_segment12 in varchar2 default hr_api.g_varchar2
163: ,p_segment13 in varchar2 default hr_api.g_varchar2
164: ,p_segment14 in varchar2 default hr_api.g_varchar2
165: ,p_segment15 in varchar2 default hr_api.g_varchar2
166: ,p_segment16 in varchar2 default hr_api.g_varchar2
167: ,p_segment17 in varchar2 default hr_api.g_varchar2
160: ,p_segment10 in varchar2 default hr_api.g_varchar2
161: ,p_segment11 in varchar2 default hr_api.g_varchar2
162: ,p_segment12 in varchar2 default hr_api.g_varchar2
163: ,p_segment13 in varchar2 default hr_api.g_varchar2
164: ,p_segment14 in varchar2 default hr_api.g_varchar2
165: ,p_segment15 in varchar2 default hr_api.g_varchar2
166: ,p_segment16 in varchar2 default hr_api.g_varchar2
167: ,p_segment17 in varchar2 default hr_api.g_varchar2
168: ,p_segment18 in varchar2 default hr_api.g_varchar2
161: ,p_segment11 in varchar2 default hr_api.g_varchar2
162: ,p_segment12 in varchar2 default hr_api.g_varchar2
163: ,p_segment13 in varchar2 default hr_api.g_varchar2
164: ,p_segment14 in varchar2 default hr_api.g_varchar2
165: ,p_segment15 in varchar2 default hr_api.g_varchar2
166: ,p_segment16 in varchar2 default hr_api.g_varchar2
167: ,p_segment17 in varchar2 default hr_api.g_varchar2
168: ,p_segment18 in varchar2 default hr_api.g_varchar2
169: ,p_segment19 in varchar2 default hr_api.g_varchar2
162: ,p_segment12 in varchar2 default hr_api.g_varchar2
163: ,p_segment13 in varchar2 default hr_api.g_varchar2
164: ,p_segment14 in varchar2 default hr_api.g_varchar2
165: ,p_segment15 in varchar2 default hr_api.g_varchar2
166: ,p_segment16 in varchar2 default hr_api.g_varchar2
167: ,p_segment17 in varchar2 default hr_api.g_varchar2
168: ,p_segment18 in varchar2 default hr_api.g_varchar2
169: ,p_segment19 in varchar2 default hr_api.g_varchar2
170: ,p_segment20 in varchar2 default hr_api.g_varchar2
163: ,p_segment13 in varchar2 default hr_api.g_varchar2
164: ,p_segment14 in varchar2 default hr_api.g_varchar2
165: ,p_segment15 in varchar2 default hr_api.g_varchar2
166: ,p_segment16 in varchar2 default hr_api.g_varchar2
167: ,p_segment17 in varchar2 default hr_api.g_varchar2
168: ,p_segment18 in varchar2 default hr_api.g_varchar2
169: ,p_segment19 in varchar2 default hr_api.g_varchar2
170: ,p_segment20 in varchar2 default hr_api.g_varchar2
171: ,p_segment21 in varchar2 default hr_api.g_varchar2
164: ,p_segment14 in varchar2 default hr_api.g_varchar2
165: ,p_segment15 in varchar2 default hr_api.g_varchar2
166: ,p_segment16 in varchar2 default hr_api.g_varchar2
167: ,p_segment17 in varchar2 default hr_api.g_varchar2
168: ,p_segment18 in varchar2 default hr_api.g_varchar2
169: ,p_segment19 in varchar2 default hr_api.g_varchar2
170: ,p_segment20 in varchar2 default hr_api.g_varchar2
171: ,p_segment21 in varchar2 default hr_api.g_varchar2
172: ,p_segment22 in varchar2 default hr_api.g_varchar2
165: ,p_segment15 in varchar2 default hr_api.g_varchar2
166: ,p_segment16 in varchar2 default hr_api.g_varchar2
167: ,p_segment17 in varchar2 default hr_api.g_varchar2
168: ,p_segment18 in varchar2 default hr_api.g_varchar2
169: ,p_segment19 in varchar2 default hr_api.g_varchar2
170: ,p_segment20 in varchar2 default hr_api.g_varchar2
171: ,p_segment21 in varchar2 default hr_api.g_varchar2
172: ,p_segment22 in varchar2 default hr_api.g_varchar2
173: ,p_segment23 in varchar2 default hr_api.g_varchar2
166: ,p_segment16 in varchar2 default hr_api.g_varchar2
167: ,p_segment17 in varchar2 default hr_api.g_varchar2
168: ,p_segment18 in varchar2 default hr_api.g_varchar2
169: ,p_segment19 in varchar2 default hr_api.g_varchar2
170: ,p_segment20 in varchar2 default hr_api.g_varchar2
171: ,p_segment21 in varchar2 default hr_api.g_varchar2
172: ,p_segment22 in varchar2 default hr_api.g_varchar2
173: ,p_segment23 in varchar2 default hr_api.g_varchar2
174: ,p_segment24 in varchar2 default hr_api.g_varchar2
167: ,p_segment17 in varchar2 default hr_api.g_varchar2
168: ,p_segment18 in varchar2 default hr_api.g_varchar2
169: ,p_segment19 in varchar2 default hr_api.g_varchar2
170: ,p_segment20 in varchar2 default hr_api.g_varchar2
171: ,p_segment21 in varchar2 default hr_api.g_varchar2
172: ,p_segment22 in varchar2 default hr_api.g_varchar2
173: ,p_segment23 in varchar2 default hr_api.g_varchar2
174: ,p_segment24 in varchar2 default hr_api.g_varchar2
175: ,p_segment25 in varchar2 default hr_api.g_varchar2
168: ,p_segment18 in varchar2 default hr_api.g_varchar2
169: ,p_segment19 in varchar2 default hr_api.g_varchar2
170: ,p_segment20 in varchar2 default hr_api.g_varchar2
171: ,p_segment21 in varchar2 default hr_api.g_varchar2
172: ,p_segment22 in varchar2 default hr_api.g_varchar2
173: ,p_segment23 in varchar2 default hr_api.g_varchar2
174: ,p_segment24 in varchar2 default hr_api.g_varchar2
175: ,p_segment25 in varchar2 default hr_api.g_varchar2
176: ,p_segment26 in varchar2 default hr_api.g_varchar2
169: ,p_segment19 in varchar2 default hr_api.g_varchar2
170: ,p_segment20 in varchar2 default hr_api.g_varchar2
171: ,p_segment21 in varchar2 default hr_api.g_varchar2
172: ,p_segment22 in varchar2 default hr_api.g_varchar2
173: ,p_segment23 in varchar2 default hr_api.g_varchar2
174: ,p_segment24 in varchar2 default hr_api.g_varchar2
175: ,p_segment25 in varchar2 default hr_api.g_varchar2
176: ,p_segment26 in varchar2 default hr_api.g_varchar2
177: ,p_segment27 in varchar2 default hr_api.g_varchar2
170: ,p_segment20 in varchar2 default hr_api.g_varchar2
171: ,p_segment21 in varchar2 default hr_api.g_varchar2
172: ,p_segment22 in varchar2 default hr_api.g_varchar2
173: ,p_segment23 in varchar2 default hr_api.g_varchar2
174: ,p_segment24 in varchar2 default hr_api.g_varchar2
175: ,p_segment25 in varchar2 default hr_api.g_varchar2
176: ,p_segment26 in varchar2 default hr_api.g_varchar2
177: ,p_segment27 in varchar2 default hr_api.g_varchar2
178: ,p_segment28 in varchar2 default hr_api.g_varchar2
171: ,p_segment21 in varchar2 default hr_api.g_varchar2
172: ,p_segment22 in varchar2 default hr_api.g_varchar2
173: ,p_segment23 in varchar2 default hr_api.g_varchar2
174: ,p_segment24 in varchar2 default hr_api.g_varchar2
175: ,p_segment25 in varchar2 default hr_api.g_varchar2
176: ,p_segment26 in varchar2 default hr_api.g_varchar2
177: ,p_segment27 in varchar2 default hr_api.g_varchar2
178: ,p_segment28 in varchar2 default hr_api.g_varchar2
179: ,p_segment29 in varchar2 default hr_api.g_varchar2
172: ,p_segment22 in varchar2 default hr_api.g_varchar2
173: ,p_segment23 in varchar2 default hr_api.g_varchar2
174: ,p_segment24 in varchar2 default hr_api.g_varchar2
175: ,p_segment25 in varchar2 default hr_api.g_varchar2
176: ,p_segment26 in varchar2 default hr_api.g_varchar2
177: ,p_segment27 in varchar2 default hr_api.g_varchar2
178: ,p_segment28 in varchar2 default hr_api.g_varchar2
179: ,p_segment29 in varchar2 default hr_api.g_varchar2
180: ,p_segment30 in varchar2 default hr_api.g_varchar2
173: ,p_segment23 in varchar2 default hr_api.g_varchar2
174: ,p_segment24 in varchar2 default hr_api.g_varchar2
175: ,p_segment25 in varchar2 default hr_api.g_varchar2
176: ,p_segment26 in varchar2 default hr_api.g_varchar2
177: ,p_segment27 in varchar2 default hr_api.g_varchar2
178: ,p_segment28 in varchar2 default hr_api.g_varchar2
179: ,p_segment29 in varchar2 default hr_api.g_varchar2
180: ,p_segment30 in varchar2 default hr_api.g_varchar2
181: ,p_soft_coding_keyflex_id out nocopy number
174: ,p_segment24 in varchar2 default hr_api.g_varchar2
175: ,p_segment25 in varchar2 default hr_api.g_varchar2
176: ,p_segment26 in varchar2 default hr_api.g_varchar2
177: ,p_segment27 in varchar2 default hr_api.g_varchar2
178: ,p_segment28 in varchar2 default hr_api.g_varchar2
179: ,p_segment29 in varchar2 default hr_api.g_varchar2
180: ,p_segment30 in varchar2 default hr_api.g_varchar2
181: ,p_soft_coding_keyflex_id out nocopy number
182: ,p_effective_start_date out nocopy date
175: ,p_segment25 in varchar2 default hr_api.g_varchar2
176: ,p_segment26 in varchar2 default hr_api.g_varchar2
177: ,p_segment27 in varchar2 default hr_api.g_varchar2
178: ,p_segment28 in varchar2 default hr_api.g_varchar2
179: ,p_segment29 in varchar2 default hr_api.g_varchar2
180: ,p_segment30 in varchar2 default hr_api.g_varchar2
181: ,p_soft_coding_keyflex_id out nocopy number
182: ,p_effective_start_date out nocopy date
183: ,p_effective_end_date out nocopy date
176: ,p_segment26 in varchar2 default hr_api.g_varchar2
177: ,p_segment27 in varchar2 default hr_api.g_varchar2
178: ,p_segment28 in varchar2 default hr_api.g_varchar2
179: ,p_segment29 in varchar2 default hr_api.g_varchar2
180: ,p_segment30 in varchar2 default hr_api.g_varchar2
181: ,p_soft_coding_keyflex_id out nocopy number
182: ,p_effective_start_date out nocopy date
183: ,p_effective_end_date out nocopy date
184: ,p_concatenated_segments out nocopy varchar2
194: l_api_updating boolean;
195: l_scl_api_updating boolean;
196: l_object_version_number number(15);
197: l_ovn number := p_object_version_number;
198: l_special_ceiling_step_id number(15) default hr_api.g_number;
199: l_people_group_id number(15);
200: l_group_name varchar2(240);
201: l_spp_delete_warning boolean;
202: l_tax_district_changed_warning boolean;
247: --
248: -- Validate that at least one of P_POSITION_ID, P_ORGANIZATION_ID,P_GRADE or
249: -- P_LOCATION_ID is being updated.
250: --
251: if ( ( (nvl(p_organization_id, hr_api.g_number) <> hr_api.g_number )
252: and nvl(per_asg_shd.g_old_rec.organization_id, hr_api.g_number) <>
253: nvl(p_organization_id, hr_api.g_number) )
254: or ( (nvl(p_position_id, hr_api.g_number) <> hr_api.g_number )
255: and nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <> nvl(p_position_id,hr_api.g_number) )
248: -- Validate that at least one of P_POSITION_ID, P_ORGANIZATION_ID,P_GRADE or
249: -- P_LOCATION_ID is being updated.
250: --
251: if ( ( (nvl(p_organization_id, hr_api.g_number) <> hr_api.g_number )
252: and nvl(per_asg_shd.g_old_rec.organization_id, hr_api.g_number) <>
253: nvl(p_organization_id, hr_api.g_number) )
254: or ( (nvl(p_position_id, hr_api.g_number) <> hr_api.g_number )
255: and nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <> nvl(p_position_id,hr_api.g_number) )
256: or ( (nvl(p_grade_id, hr_api.g_number) <> hr_api.g_number )
249: -- P_LOCATION_ID is being updated.
250: --
251: if ( ( (nvl(p_organization_id, hr_api.g_number) <> hr_api.g_number )
252: and nvl(per_asg_shd.g_old_rec.organization_id, hr_api.g_number) <>
253: nvl(p_organization_id, hr_api.g_number) )
254: or ( (nvl(p_position_id, hr_api.g_number) <> hr_api.g_number )
255: and nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <> nvl(p_position_id,hr_api.g_number) )
256: or ( (nvl(p_grade_id, hr_api.g_number) <> hr_api.g_number )
257: and nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>
250: --
251: if ( ( (nvl(p_organization_id, hr_api.g_number) <> hr_api.g_number )
252: and nvl(per_asg_shd.g_old_rec.organization_id, hr_api.g_number) <>
253: nvl(p_organization_id, hr_api.g_number) )
254: or ( (nvl(p_position_id, hr_api.g_number) <> hr_api.g_number )
255: and nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <> nvl(p_position_id,hr_api.g_number) )
256: or ( (nvl(p_grade_id, hr_api.g_number) <> hr_api.g_number )
257: and nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>
258: nvl(p_grade_id,hr_api.g_number) )
251: if ( ( (nvl(p_organization_id, hr_api.g_number) <> hr_api.g_number )
252: and nvl(per_asg_shd.g_old_rec.organization_id, hr_api.g_number) <>
253: nvl(p_organization_id, hr_api.g_number) )
254: or ( (nvl(p_position_id, hr_api.g_number) <> hr_api.g_number )
255: and nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <> nvl(p_position_id,hr_api.g_number) )
256: or ( (nvl(p_grade_id, hr_api.g_number) <> hr_api.g_number )
257: and nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>
258: nvl(p_grade_id,hr_api.g_number) )
259: or ( ( nvl(p_location_id, hr_api.g_number) <> hr_api.g_number )
252: and nvl(per_asg_shd.g_old_rec.organization_id, hr_api.g_number) <>
253: nvl(p_organization_id, hr_api.g_number) )
254: or ( (nvl(p_position_id, hr_api.g_number) <> hr_api.g_number )
255: and nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <> nvl(p_position_id,hr_api.g_number) )
256: or ( (nvl(p_grade_id, hr_api.g_number) <> hr_api.g_number )
257: and nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>
258: nvl(p_grade_id,hr_api.g_number) )
259: or ( ( nvl(p_location_id, hr_api.g_number) <> hr_api.g_number )
260: and nvl(per_asg_shd.g_old_rec.location_id, hr_api.g_number) <>
253: nvl(p_organization_id, hr_api.g_number) )
254: or ( (nvl(p_position_id, hr_api.g_number) <> hr_api.g_number )
255: and nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <> nvl(p_position_id,hr_api.g_number) )
256: or ( (nvl(p_grade_id, hr_api.g_number) <> hr_api.g_number )
257: and nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>
258: nvl(p_grade_id,hr_api.g_number) )
259: or ( ( nvl(p_location_id, hr_api.g_number) <> hr_api.g_number )
260: and nvl(per_asg_shd.g_old_rec.location_id, hr_api.g_number) <>
261: nvl(p_location_id, hr_api.g_number) ) ) then
254: or ( (nvl(p_position_id, hr_api.g_number) <> hr_api.g_number )
255: and nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <> nvl(p_position_id,hr_api.g_number) )
256: or ( (nvl(p_grade_id, hr_api.g_number) <> hr_api.g_number )
257: and nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>
258: nvl(p_grade_id,hr_api.g_number) )
259: or ( ( nvl(p_location_id, hr_api.g_number) <> hr_api.g_number )
260: and nvl(per_asg_shd.g_old_rec.location_id, hr_api.g_number) <>
261: nvl(p_location_id, hr_api.g_number) ) ) then
262: null;
255: and nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <> nvl(p_position_id,hr_api.g_number) )
256: or ( (nvl(p_grade_id, hr_api.g_number) <> hr_api.g_number )
257: and nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>
258: nvl(p_grade_id,hr_api.g_number) )
259: or ( ( nvl(p_location_id, hr_api.g_number) <> hr_api.g_number )
260: and nvl(per_asg_shd.g_old_rec.location_id, hr_api.g_number) <>
261: nvl(p_location_id, hr_api.g_number) ) ) then
262: null;
263: else
256: or ( (nvl(p_grade_id, hr_api.g_number) <> hr_api.g_number )
257: and nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>
258: nvl(p_grade_id,hr_api.g_number) )
259: or ( ( nvl(p_location_id, hr_api.g_number) <> hr_api.g_number )
260: and nvl(per_asg_shd.g_old_rec.location_id, hr_api.g_number) <>
261: nvl(p_location_id, hr_api.g_number) ) ) then
262: null;
263: else
264: hr_utility.set_message(801, 'HR_51104_MMV_MUST_UPD_ASG');
257: and nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>
258: nvl(p_grade_id,hr_api.g_number) )
259: or ( ( nvl(p_location_id, hr_api.g_number) <> hr_api.g_number )
260: and nvl(per_asg_shd.g_old_rec.location_id, hr_api.g_number) <>
261: nvl(p_location_id, hr_api.g_number) ) ) then
262: null;
263: else
264: hr_utility.set_message(801, 'HR_51104_MMV_MUST_UPD_ASG');
265: hr_utility.raise_error;
369: per_asg_shd.g_old_rec.soft_coding_keyflex_id);
370: --
371: -- Check whether any of the SCL segments are being updated.
372: --
373: if ( ( (nvl(p_segment1, hr_api.g_varchar2) <> hr_api.g_varchar2)
374: and nvl(hr_scl_shd.g_old_rec.segment1, hr_api.g_varchar2) <>
375: nvl(p_segment1, hr_api.g_varchar2) )
376: or ( (nvl(p_segment2, hr_api.g_varchar2) <> hr_api.g_varchar2)
377: and nvl(hr_scl_shd.g_old_rec.segment2, hr_api.g_varchar2) <>
370: --
371: -- Check whether any of the SCL segments are being updated.
372: --
373: if ( ( (nvl(p_segment1, hr_api.g_varchar2) <> hr_api.g_varchar2)
374: and nvl(hr_scl_shd.g_old_rec.segment1, hr_api.g_varchar2) <>
375: nvl(p_segment1, hr_api.g_varchar2) )
376: or ( (nvl(p_segment2, hr_api.g_varchar2) <> hr_api.g_varchar2)
377: and nvl(hr_scl_shd.g_old_rec.segment2, hr_api.g_varchar2) <>
378: nvl(p_segment2, hr_api.g_varchar2) )
371: -- Check whether any of the SCL segments are being updated.
372: --
373: if ( ( (nvl(p_segment1, hr_api.g_varchar2) <> hr_api.g_varchar2)
374: and nvl(hr_scl_shd.g_old_rec.segment1, hr_api.g_varchar2) <>
375: nvl(p_segment1, hr_api.g_varchar2) )
376: or ( (nvl(p_segment2, hr_api.g_varchar2) <> hr_api.g_varchar2)
377: and nvl(hr_scl_shd.g_old_rec.segment2, hr_api.g_varchar2) <>
378: nvl(p_segment2, hr_api.g_varchar2) )
379: or ( (nvl(p_segment3, hr_api.g_varchar2) <> hr_api.g_varchar2)
372: --
373: if ( ( (nvl(p_segment1, hr_api.g_varchar2) <> hr_api.g_varchar2)
374: and nvl(hr_scl_shd.g_old_rec.segment1, hr_api.g_varchar2) <>
375: nvl(p_segment1, hr_api.g_varchar2) )
376: or ( (nvl(p_segment2, hr_api.g_varchar2) <> hr_api.g_varchar2)
377: and nvl(hr_scl_shd.g_old_rec.segment2, hr_api.g_varchar2) <>
378: nvl(p_segment2, hr_api.g_varchar2) )
379: or ( (nvl(p_segment3, hr_api.g_varchar2) <> hr_api.g_varchar2)
380: and nvl(hr_scl_shd.g_old_rec.segment3, hr_api.g_varchar2) <>
373: if ( ( (nvl(p_segment1, hr_api.g_varchar2) <> hr_api.g_varchar2)
374: and nvl(hr_scl_shd.g_old_rec.segment1, hr_api.g_varchar2) <>
375: nvl(p_segment1, hr_api.g_varchar2) )
376: or ( (nvl(p_segment2, hr_api.g_varchar2) <> hr_api.g_varchar2)
377: and nvl(hr_scl_shd.g_old_rec.segment2, hr_api.g_varchar2) <>
378: nvl(p_segment2, hr_api.g_varchar2) )
379: or ( (nvl(p_segment3, hr_api.g_varchar2) <> hr_api.g_varchar2)
380: and nvl(hr_scl_shd.g_old_rec.segment3, hr_api.g_varchar2) <>
381: nvl(p_segment3, hr_api.g_varchar2) )
374: and nvl(hr_scl_shd.g_old_rec.segment1, hr_api.g_varchar2) <>
375: nvl(p_segment1, hr_api.g_varchar2) )
376: or ( (nvl(p_segment2, hr_api.g_varchar2) <> hr_api.g_varchar2)
377: and nvl(hr_scl_shd.g_old_rec.segment2, hr_api.g_varchar2) <>
378: nvl(p_segment2, hr_api.g_varchar2) )
379: or ( (nvl(p_segment3, hr_api.g_varchar2) <> hr_api.g_varchar2)
380: and nvl(hr_scl_shd.g_old_rec.segment3, hr_api.g_varchar2) <>
381: nvl(p_segment3, hr_api.g_varchar2) )
382: or ( (nvl(p_segment4, hr_api.g_varchar2) <> hr_api.g_varchar2)
375: nvl(p_segment1, hr_api.g_varchar2) )
376: or ( (nvl(p_segment2, hr_api.g_varchar2) <> hr_api.g_varchar2)
377: and nvl(hr_scl_shd.g_old_rec.segment2, hr_api.g_varchar2) <>
378: nvl(p_segment2, hr_api.g_varchar2) )
379: or ( (nvl(p_segment3, hr_api.g_varchar2) <> hr_api.g_varchar2)
380: and nvl(hr_scl_shd.g_old_rec.segment3, hr_api.g_varchar2) <>
381: nvl(p_segment3, hr_api.g_varchar2) )
382: or ( (nvl(p_segment4, hr_api.g_varchar2) <> hr_api.g_varchar2)
383: and nvl(hr_scl_shd.g_old_rec.segment4, hr_api.g_varchar2) <>
376: or ( (nvl(p_segment2, hr_api.g_varchar2) <> hr_api.g_varchar2)
377: and nvl(hr_scl_shd.g_old_rec.segment2, hr_api.g_varchar2) <>
378: nvl(p_segment2, hr_api.g_varchar2) )
379: or ( (nvl(p_segment3, hr_api.g_varchar2) <> hr_api.g_varchar2)
380: and nvl(hr_scl_shd.g_old_rec.segment3, hr_api.g_varchar2) <>
381: nvl(p_segment3, hr_api.g_varchar2) )
382: or ( (nvl(p_segment4, hr_api.g_varchar2) <> hr_api.g_varchar2)
383: and nvl(hr_scl_shd.g_old_rec.segment4, hr_api.g_varchar2) <>
384: nvl(p_segment4, hr_api.g_varchar2) )
377: and nvl(hr_scl_shd.g_old_rec.segment2, hr_api.g_varchar2) <>
378: nvl(p_segment2, hr_api.g_varchar2) )
379: or ( (nvl(p_segment3, hr_api.g_varchar2) <> hr_api.g_varchar2)
380: and nvl(hr_scl_shd.g_old_rec.segment3, hr_api.g_varchar2) <>
381: nvl(p_segment3, hr_api.g_varchar2) )
382: or ( (nvl(p_segment4, hr_api.g_varchar2) <> hr_api.g_varchar2)
383: and nvl(hr_scl_shd.g_old_rec.segment4, hr_api.g_varchar2) <>
384: nvl(p_segment4, hr_api.g_varchar2) )
385: or ( (nvl(p_segment5, hr_api.g_varchar2) <> hr_api.g_varchar2)
378: nvl(p_segment2, hr_api.g_varchar2) )
379: or ( (nvl(p_segment3, hr_api.g_varchar2) <> hr_api.g_varchar2)
380: and nvl(hr_scl_shd.g_old_rec.segment3, hr_api.g_varchar2) <>
381: nvl(p_segment3, hr_api.g_varchar2) )
382: or ( (nvl(p_segment4, hr_api.g_varchar2) <> hr_api.g_varchar2)
383: and nvl(hr_scl_shd.g_old_rec.segment4, hr_api.g_varchar2) <>
384: nvl(p_segment4, hr_api.g_varchar2) )
385: or ( (nvl(p_segment5, hr_api.g_varchar2) <> hr_api.g_varchar2)
386: and nvl(hr_scl_shd.g_old_rec.segment5, hr_api.g_varchar2) <>
379: or ( (nvl(p_segment3, hr_api.g_varchar2) <> hr_api.g_varchar2)
380: and nvl(hr_scl_shd.g_old_rec.segment3, hr_api.g_varchar2) <>
381: nvl(p_segment3, hr_api.g_varchar2) )
382: or ( (nvl(p_segment4, hr_api.g_varchar2) <> hr_api.g_varchar2)
383: and nvl(hr_scl_shd.g_old_rec.segment4, hr_api.g_varchar2) <>
384: nvl(p_segment4, hr_api.g_varchar2) )
385: or ( (nvl(p_segment5, hr_api.g_varchar2) <> hr_api.g_varchar2)
386: and nvl(hr_scl_shd.g_old_rec.segment5, hr_api.g_varchar2) <>
387: nvl(p_segment5, hr_api.g_varchar2) )
380: and nvl(hr_scl_shd.g_old_rec.segment3, hr_api.g_varchar2) <>
381: nvl(p_segment3, hr_api.g_varchar2) )
382: or ( (nvl(p_segment4, hr_api.g_varchar2) <> hr_api.g_varchar2)
383: and nvl(hr_scl_shd.g_old_rec.segment4, hr_api.g_varchar2) <>
384: nvl(p_segment4, hr_api.g_varchar2) )
385: or ( (nvl(p_segment5, hr_api.g_varchar2) <> hr_api.g_varchar2)
386: and nvl(hr_scl_shd.g_old_rec.segment5, hr_api.g_varchar2) <>
387: nvl(p_segment5, hr_api.g_varchar2) )
388: or ( (nvl(p_segment6, hr_api.g_varchar2) <> hr_api.g_varchar2)
381: nvl(p_segment3, hr_api.g_varchar2) )
382: or ( (nvl(p_segment4, hr_api.g_varchar2) <> hr_api.g_varchar2)
383: and nvl(hr_scl_shd.g_old_rec.segment4, hr_api.g_varchar2) <>
384: nvl(p_segment4, hr_api.g_varchar2) )
385: or ( (nvl(p_segment5, hr_api.g_varchar2) <> hr_api.g_varchar2)
386: and nvl(hr_scl_shd.g_old_rec.segment5, hr_api.g_varchar2) <>
387: nvl(p_segment5, hr_api.g_varchar2) )
388: or ( (nvl(p_segment6, hr_api.g_varchar2) <> hr_api.g_varchar2)
389: and nvl(hr_scl_shd.g_old_rec.segment6, hr_api.g_varchar2) <>
382: or ( (nvl(p_segment4, hr_api.g_varchar2) <> hr_api.g_varchar2)
383: and nvl(hr_scl_shd.g_old_rec.segment4, hr_api.g_varchar2) <>
384: nvl(p_segment4, hr_api.g_varchar2) )
385: or ( (nvl(p_segment5, hr_api.g_varchar2) <> hr_api.g_varchar2)
386: and nvl(hr_scl_shd.g_old_rec.segment5, hr_api.g_varchar2) <>
387: nvl(p_segment5, hr_api.g_varchar2) )
388: or ( (nvl(p_segment6, hr_api.g_varchar2) <> hr_api.g_varchar2)
389: and nvl(hr_scl_shd.g_old_rec.segment6, hr_api.g_varchar2) <>
390: nvl(p_segment6, hr_api.g_varchar2) )
383: and nvl(hr_scl_shd.g_old_rec.segment4, hr_api.g_varchar2) <>
384: nvl(p_segment4, hr_api.g_varchar2) )
385: or ( (nvl(p_segment5, hr_api.g_varchar2) <> hr_api.g_varchar2)
386: and nvl(hr_scl_shd.g_old_rec.segment5, hr_api.g_varchar2) <>
387: nvl(p_segment5, hr_api.g_varchar2) )
388: or ( (nvl(p_segment6, hr_api.g_varchar2) <> hr_api.g_varchar2)
389: and nvl(hr_scl_shd.g_old_rec.segment6, hr_api.g_varchar2) <>
390: nvl(p_segment6, hr_api.g_varchar2) )
391: or ( (nvl(p_segment7, hr_api.g_varchar2) <> hr_api.g_varchar2)
384: nvl(p_segment4, hr_api.g_varchar2) )
385: or ( (nvl(p_segment5, hr_api.g_varchar2) <> hr_api.g_varchar2)
386: and nvl(hr_scl_shd.g_old_rec.segment5, hr_api.g_varchar2) <>
387: nvl(p_segment5, hr_api.g_varchar2) )
388: or ( (nvl(p_segment6, hr_api.g_varchar2) <> hr_api.g_varchar2)
389: and nvl(hr_scl_shd.g_old_rec.segment6, hr_api.g_varchar2) <>
390: nvl(p_segment6, hr_api.g_varchar2) )
391: or ( (nvl(p_segment7, hr_api.g_varchar2) <> hr_api.g_varchar2)
392: and nvl(hr_scl_shd.g_old_rec.segment7, hr_api.g_varchar2) <>
385: or ( (nvl(p_segment5, hr_api.g_varchar2) <> hr_api.g_varchar2)
386: and nvl(hr_scl_shd.g_old_rec.segment5, hr_api.g_varchar2) <>
387: nvl(p_segment5, hr_api.g_varchar2) )
388: or ( (nvl(p_segment6, hr_api.g_varchar2) <> hr_api.g_varchar2)
389: and nvl(hr_scl_shd.g_old_rec.segment6, hr_api.g_varchar2) <>
390: nvl(p_segment6, hr_api.g_varchar2) )
391: or ( (nvl(p_segment7, hr_api.g_varchar2) <> hr_api.g_varchar2)
392: and nvl(hr_scl_shd.g_old_rec.segment7, hr_api.g_varchar2) <>
393: nvl(p_segment7, hr_api.g_varchar2) )
386: and nvl(hr_scl_shd.g_old_rec.segment5, hr_api.g_varchar2) <>
387: nvl(p_segment5, hr_api.g_varchar2) )
388: or ( (nvl(p_segment6, hr_api.g_varchar2) <> hr_api.g_varchar2)
389: and nvl(hr_scl_shd.g_old_rec.segment6, hr_api.g_varchar2) <>
390: nvl(p_segment6, hr_api.g_varchar2) )
391: or ( (nvl(p_segment7, hr_api.g_varchar2) <> hr_api.g_varchar2)
392: and nvl(hr_scl_shd.g_old_rec.segment7, hr_api.g_varchar2) <>
393: nvl(p_segment7, hr_api.g_varchar2) )
394: or ( (nvl(p_segment8, hr_api.g_varchar2) <> hr_api.g_varchar2)
387: nvl(p_segment5, hr_api.g_varchar2) )
388: or ( (nvl(p_segment6, hr_api.g_varchar2) <> hr_api.g_varchar2)
389: and nvl(hr_scl_shd.g_old_rec.segment6, hr_api.g_varchar2) <>
390: nvl(p_segment6, hr_api.g_varchar2) )
391: or ( (nvl(p_segment7, hr_api.g_varchar2) <> hr_api.g_varchar2)
392: and nvl(hr_scl_shd.g_old_rec.segment7, hr_api.g_varchar2) <>
393: nvl(p_segment7, hr_api.g_varchar2) )
394: or ( (nvl(p_segment8, hr_api.g_varchar2) <> hr_api.g_varchar2)
395: and nvl(hr_scl_shd.g_old_rec.segment8, hr_api.g_varchar2) <>
388: or ( (nvl(p_segment6, hr_api.g_varchar2) <> hr_api.g_varchar2)
389: and nvl(hr_scl_shd.g_old_rec.segment6, hr_api.g_varchar2) <>
390: nvl(p_segment6, hr_api.g_varchar2) )
391: or ( (nvl(p_segment7, hr_api.g_varchar2) <> hr_api.g_varchar2)
392: and nvl(hr_scl_shd.g_old_rec.segment7, hr_api.g_varchar2) <>
393: nvl(p_segment7, hr_api.g_varchar2) )
394: or ( (nvl(p_segment8, hr_api.g_varchar2) <> hr_api.g_varchar2)
395: and nvl(hr_scl_shd.g_old_rec.segment8, hr_api.g_varchar2) <>
396: nvl(p_segment8, hr_api.g_varchar2) )
389: and nvl(hr_scl_shd.g_old_rec.segment6, hr_api.g_varchar2) <>
390: nvl(p_segment6, hr_api.g_varchar2) )
391: or ( (nvl(p_segment7, hr_api.g_varchar2) <> hr_api.g_varchar2)
392: and nvl(hr_scl_shd.g_old_rec.segment7, hr_api.g_varchar2) <>
393: nvl(p_segment7, hr_api.g_varchar2) )
394: or ( (nvl(p_segment8, hr_api.g_varchar2) <> hr_api.g_varchar2)
395: and nvl(hr_scl_shd.g_old_rec.segment8, hr_api.g_varchar2) <>
396: nvl(p_segment8, hr_api.g_varchar2) )
397: or ( (nvl(p_segment9, hr_api.g_varchar2) <> hr_api.g_varchar2)
390: nvl(p_segment6, hr_api.g_varchar2) )
391: or ( (nvl(p_segment7, hr_api.g_varchar2) <> hr_api.g_varchar2)
392: and nvl(hr_scl_shd.g_old_rec.segment7, hr_api.g_varchar2) <>
393: nvl(p_segment7, hr_api.g_varchar2) )
394: or ( (nvl(p_segment8, hr_api.g_varchar2) <> hr_api.g_varchar2)
395: and nvl(hr_scl_shd.g_old_rec.segment8, hr_api.g_varchar2) <>
396: nvl(p_segment8, hr_api.g_varchar2) )
397: or ( (nvl(p_segment9, hr_api.g_varchar2) <> hr_api.g_varchar2)
398: and nvl(hr_scl_shd.g_old_rec.segment9, hr_api.g_varchar2) <>
391: or ( (nvl(p_segment7, hr_api.g_varchar2) <> hr_api.g_varchar2)
392: and nvl(hr_scl_shd.g_old_rec.segment7, hr_api.g_varchar2) <>
393: nvl(p_segment7, hr_api.g_varchar2) )
394: or ( (nvl(p_segment8, hr_api.g_varchar2) <> hr_api.g_varchar2)
395: and nvl(hr_scl_shd.g_old_rec.segment8, hr_api.g_varchar2) <>
396: nvl(p_segment8, hr_api.g_varchar2) )
397: or ( (nvl(p_segment9, hr_api.g_varchar2) <> hr_api.g_varchar2)
398: and nvl(hr_scl_shd.g_old_rec.segment9, hr_api.g_varchar2) <>
399: nvl(p_segment9, hr_api.g_varchar2) )
392: and nvl(hr_scl_shd.g_old_rec.segment7, hr_api.g_varchar2) <>
393: nvl(p_segment7, hr_api.g_varchar2) )
394: or ( (nvl(p_segment8, hr_api.g_varchar2) <> hr_api.g_varchar2)
395: and nvl(hr_scl_shd.g_old_rec.segment8, hr_api.g_varchar2) <>
396: nvl(p_segment8, hr_api.g_varchar2) )
397: or ( (nvl(p_segment9, hr_api.g_varchar2) <> hr_api.g_varchar2)
398: and nvl(hr_scl_shd.g_old_rec.segment9, hr_api.g_varchar2) <>
399: nvl(p_segment9, hr_api.g_varchar2) )
400: or ( (nvl(p_segment10, hr_api.g_varchar2) <> hr_api.g_varchar2)
393: nvl(p_segment7, hr_api.g_varchar2) )
394: or ( (nvl(p_segment8, hr_api.g_varchar2) <> hr_api.g_varchar2)
395: and nvl(hr_scl_shd.g_old_rec.segment8, hr_api.g_varchar2) <>
396: nvl(p_segment8, hr_api.g_varchar2) )
397: or ( (nvl(p_segment9, hr_api.g_varchar2) <> hr_api.g_varchar2)
398: and nvl(hr_scl_shd.g_old_rec.segment9, hr_api.g_varchar2) <>
399: nvl(p_segment9, hr_api.g_varchar2) )
400: or ( (nvl(p_segment10, hr_api.g_varchar2) <> hr_api.g_varchar2)
401: and nvl(hr_scl_shd.g_old_rec.segment10, hr_api.g_varchar2) <>
394: or ( (nvl(p_segment8, hr_api.g_varchar2) <> hr_api.g_varchar2)
395: and nvl(hr_scl_shd.g_old_rec.segment8, hr_api.g_varchar2) <>
396: nvl(p_segment8, hr_api.g_varchar2) )
397: or ( (nvl(p_segment9, hr_api.g_varchar2) <> hr_api.g_varchar2)
398: and nvl(hr_scl_shd.g_old_rec.segment9, hr_api.g_varchar2) <>
399: nvl(p_segment9, hr_api.g_varchar2) )
400: or ( (nvl(p_segment10, hr_api.g_varchar2) <> hr_api.g_varchar2)
401: and nvl(hr_scl_shd.g_old_rec.segment10, hr_api.g_varchar2) <>
402: nvl(p_segment10, hr_api.g_varchar2) )
395: and nvl(hr_scl_shd.g_old_rec.segment8, hr_api.g_varchar2) <>
396: nvl(p_segment8, hr_api.g_varchar2) )
397: or ( (nvl(p_segment9, hr_api.g_varchar2) <> hr_api.g_varchar2)
398: and nvl(hr_scl_shd.g_old_rec.segment9, hr_api.g_varchar2) <>
399: nvl(p_segment9, hr_api.g_varchar2) )
400: or ( (nvl(p_segment10, hr_api.g_varchar2) <> hr_api.g_varchar2)
401: and nvl(hr_scl_shd.g_old_rec.segment10, hr_api.g_varchar2) <>
402: nvl(p_segment10, hr_api.g_varchar2) )
403: or ( (nvl(p_segment11, hr_api.g_varchar2) <> hr_api.g_varchar2)
396: nvl(p_segment8, hr_api.g_varchar2) )
397: or ( (nvl(p_segment9, hr_api.g_varchar2) <> hr_api.g_varchar2)
398: and nvl(hr_scl_shd.g_old_rec.segment9, hr_api.g_varchar2) <>
399: nvl(p_segment9, hr_api.g_varchar2) )
400: or ( (nvl(p_segment10, hr_api.g_varchar2) <> hr_api.g_varchar2)
401: and nvl(hr_scl_shd.g_old_rec.segment10, hr_api.g_varchar2) <>
402: nvl(p_segment10, hr_api.g_varchar2) )
403: or ( (nvl(p_segment11, hr_api.g_varchar2) <> hr_api.g_varchar2)
404: and nvl(hr_scl_shd.g_old_rec.segment11, hr_api.g_varchar2) <>
397: or ( (nvl(p_segment9, hr_api.g_varchar2) <> hr_api.g_varchar2)
398: and nvl(hr_scl_shd.g_old_rec.segment9, hr_api.g_varchar2) <>
399: nvl(p_segment9, hr_api.g_varchar2) )
400: or ( (nvl(p_segment10, hr_api.g_varchar2) <> hr_api.g_varchar2)
401: and nvl(hr_scl_shd.g_old_rec.segment10, hr_api.g_varchar2) <>
402: nvl(p_segment10, hr_api.g_varchar2) )
403: or ( (nvl(p_segment11, hr_api.g_varchar2) <> hr_api.g_varchar2)
404: and nvl(hr_scl_shd.g_old_rec.segment11, hr_api.g_varchar2) <>
405: nvl(p_segment11, hr_api.g_varchar2) )
398: and nvl(hr_scl_shd.g_old_rec.segment9, hr_api.g_varchar2) <>
399: nvl(p_segment9, hr_api.g_varchar2) )
400: or ( (nvl(p_segment10, hr_api.g_varchar2) <> hr_api.g_varchar2)
401: and nvl(hr_scl_shd.g_old_rec.segment10, hr_api.g_varchar2) <>
402: nvl(p_segment10, hr_api.g_varchar2) )
403: or ( (nvl(p_segment11, hr_api.g_varchar2) <> hr_api.g_varchar2)
404: and nvl(hr_scl_shd.g_old_rec.segment11, hr_api.g_varchar2) <>
405: nvl(p_segment11, hr_api.g_varchar2) )
406: or ( (nvl(p_segment12, hr_api.g_varchar2) <> hr_api.g_varchar2)
399: nvl(p_segment9, hr_api.g_varchar2) )
400: or ( (nvl(p_segment10, hr_api.g_varchar2) <> hr_api.g_varchar2)
401: and nvl(hr_scl_shd.g_old_rec.segment10, hr_api.g_varchar2) <>
402: nvl(p_segment10, hr_api.g_varchar2) )
403: or ( (nvl(p_segment11, hr_api.g_varchar2) <> hr_api.g_varchar2)
404: and nvl(hr_scl_shd.g_old_rec.segment11, hr_api.g_varchar2) <>
405: nvl(p_segment11, hr_api.g_varchar2) )
406: or ( (nvl(p_segment12, hr_api.g_varchar2) <> hr_api.g_varchar2)
407: and nvl(hr_scl_shd.g_old_rec.segment12, hr_api.g_varchar2) <>
400: or ( (nvl(p_segment10, hr_api.g_varchar2) <> hr_api.g_varchar2)
401: and nvl(hr_scl_shd.g_old_rec.segment10, hr_api.g_varchar2) <>
402: nvl(p_segment10, hr_api.g_varchar2) )
403: or ( (nvl(p_segment11, hr_api.g_varchar2) <> hr_api.g_varchar2)
404: and nvl(hr_scl_shd.g_old_rec.segment11, hr_api.g_varchar2) <>
405: nvl(p_segment11, hr_api.g_varchar2) )
406: or ( (nvl(p_segment12, hr_api.g_varchar2) <> hr_api.g_varchar2)
407: and nvl(hr_scl_shd.g_old_rec.segment12, hr_api.g_varchar2) <>
408: nvl(p_segment12, hr_api.g_varchar2) )
401: and nvl(hr_scl_shd.g_old_rec.segment10, hr_api.g_varchar2) <>
402: nvl(p_segment10, hr_api.g_varchar2) )
403: or ( (nvl(p_segment11, hr_api.g_varchar2) <> hr_api.g_varchar2)
404: and nvl(hr_scl_shd.g_old_rec.segment11, hr_api.g_varchar2) <>
405: nvl(p_segment11, hr_api.g_varchar2) )
406: or ( (nvl(p_segment12, hr_api.g_varchar2) <> hr_api.g_varchar2)
407: and nvl(hr_scl_shd.g_old_rec.segment12, hr_api.g_varchar2) <>
408: nvl(p_segment12, hr_api.g_varchar2) )
409: or ( (nvl(p_segment13, hr_api.g_varchar2) <> hr_api.g_varchar2)
402: nvl(p_segment10, hr_api.g_varchar2) )
403: or ( (nvl(p_segment11, hr_api.g_varchar2) <> hr_api.g_varchar2)
404: and nvl(hr_scl_shd.g_old_rec.segment11, hr_api.g_varchar2) <>
405: nvl(p_segment11, hr_api.g_varchar2) )
406: or ( (nvl(p_segment12, hr_api.g_varchar2) <> hr_api.g_varchar2)
407: and nvl(hr_scl_shd.g_old_rec.segment12, hr_api.g_varchar2) <>
408: nvl(p_segment12, hr_api.g_varchar2) )
409: or ( (nvl(p_segment13, hr_api.g_varchar2) <> hr_api.g_varchar2)
410: and nvl(hr_scl_shd.g_old_rec.segment13, hr_api.g_varchar2) <>
403: or ( (nvl(p_segment11, hr_api.g_varchar2) <> hr_api.g_varchar2)
404: and nvl(hr_scl_shd.g_old_rec.segment11, hr_api.g_varchar2) <>
405: nvl(p_segment11, hr_api.g_varchar2) )
406: or ( (nvl(p_segment12, hr_api.g_varchar2) <> hr_api.g_varchar2)
407: and nvl(hr_scl_shd.g_old_rec.segment12, hr_api.g_varchar2) <>
408: nvl(p_segment12, hr_api.g_varchar2) )
409: or ( (nvl(p_segment13, hr_api.g_varchar2) <> hr_api.g_varchar2)
410: and nvl(hr_scl_shd.g_old_rec.segment13, hr_api.g_varchar2) <>
411: nvl(p_segment13, hr_api.g_varchar2) )
404: and nvl(hr_scl_shd.g_old_rec.segment11, hr_api.g_varchar2) <>
405: nvl(p_segment11, hr_api.g_varchar2) )
406: or ( (nvl(p_segment12, hr_api.g_varchar2) <> hr_api.g_varchar2)
407: and nvl(hr_scl_shd.g_old_rec.segment12, hr_api.g_varchar2) <>
408: nvl(p_segment12, hr_api.g_varchar2) )
409: or ( (nvl(p_segment13, hr_api.g_varchar2) <> hr_api.g_varchar2)
410: and nvl(hr_scl_shd.g_old_rec.segment13, hr_api.g_varchar2) <>
411: nvl(p_segment13, hr_api.g_varchar2) )
412: or ( (nvl(p_segment14, hr_api.g_varchar2) <> hr_api.g_varchar2)
405: nvl(p_segment11, hr_api.g_varchar2) )
406: or ( (nvl(p_segment12, hr_api.g_varchar2) <> hr_api.g_varchar2)
407: and nvl(hr_scl_shd.g_old_rec.segment12, hr_api.g_varchar2) <>
408: nvl(p_segment12, hr_api.g_varchar2) )
409: or ( (nvl(p_segment13, hr_api.g_varchar2) <> hr_api.g_varchar2)
410: and nvl(hr_scl_shd.g_old_rec.segment13, hr_api.g_varchar2) <>
411: nvl(p_segment13, hr_api.g_varchar2) )
412: or ( (nvl(p_segment14, hr_api.g_varchar2) <> hr_api.g_varchar2)
413: and nvl(hr_scl_shd.g_old_rec.segment14, hr_api.g_varchar2) <>
406: or ( (nvl(p_segment12, hr_api.g_varchar2) <> hr_api.g_varchar2)
407: and nvl(hr_scl_shd.g_old_rec.segment12, hr_api.g_varchar2) <>
408: nvl(p_segment12, hr_api.g_varchar2) )
409: or ( (nvl(p_segment13, hr_api.g_varchar2) <> hr_api.g_varchar2)
410: and nvl(hr_scl_shd.g_old_rec.segment13, hr_api.g_varchar2) <>
411: nvl(p_segment13, hr_api.g_varchar2) )
412: or ( (nvl(p_segment14, hr_api.g_varchar2) <> hr_api.g_varchar2)
413: and nvl(hr_scl_shd.g_old_rec.segment14, hr_api.g_varchar2) <>
414: nvl(p_segment14, hr_api.g_varchar2) )
407: and nvl(hr_scl_shd.g_old_rec.segment12, hr_api.g_varchar2) <>
408: nvl(p_segment12, hr_api.g_varchar2) )
409: or ( (nvl(p_segment13, hr_api.g_varchar2) <> hr_api.g_varchar2)
410: and nvl(hr_scl_shd.g_old_rec.segment13, hr_api.g_varchar2) <>
411: nvl(p_segment13, hr_api.g_varchar2) )
412: or ( (nvl(p_segment14, hr_api.g_varchar2) <> hr_api.g_varchar2)
413: and nvl(hr_scl_shd.g_old_rec.segment14, hr_api.g_varchar2) <>
414: nvl(p_segment14, hr_api.g_varchar2) )
415: or ( (nvl(p_segment15, hr_api.g_varchar2) <> hr_api.g_varchar2)
408: nvl(p_segment12, hr_api.g_varchar2) )
409: or ( (nvl(p_segment13, hr_api.g_varchar2) <> hr_api.g_varchar2)
410: and nvl(hr_scl_shd.g_old_rec.segment13, hr_api.g_varchar2) <>
411: nvl(p_segment13, hr_api.g_varchar2) )
412: or ( (nvl(p_segment14, hr_api.g_varchar2) <> hr_api.g_varchar2)
413: and nvl(hr_scl_shd.g_old_rec.segment14, hr_api.g_varchar2) <>
414: nvl(p_segment14, hr_api.g_varchar2) )
415: or ( (nvl(p_segment15, hr_api.g_varchar2) <> hr_api.g_varchar2)
416: and nvl(hr_scl_shd.g_old_rec.segment15, hr_api.g_varchar2) <>
409: or ( (nvl(p_segment13, hr_api.g_varchar2) <> hr_api.g_varchar2)
410: and nvl(hr_scl_shd.g_old_rec.segment13, hr_api.g_varchar2) <>
411: nvl(p_segment13, hr_api.g_varchar2) )
412: or ( (nvl(p_segment14, hr_api.g_varchar2) <> hr_api.g_varchar2)
413: and nvl(hr_scl_shd.g_old_rec.segment14, hr_api.g_varchar2) <>
414: nvl(p_segment14, hr_api.g_varchar2) )
415: or ( (nvl(p_segment15, hr_api.g_varchar2) <> hr_api.g_varchar2)
416: and nvl(hr_scl_shd.g_old_rec.segment15, hr_api.g_varchar2) <>
417: nvl(p_segment15, hr_api.g_varchar2) )
410: and nvl(hr_scl_shd.g_old_rec.segment13, hr_api.g_varchar2) <>
411: nvl(p_segment13, hr_api.g_varchar2) )
412: or ( (nvl(p_segment14, hr_api.g_varchar2) <> hr_api.g_varchar2)
413: and nvl(hr_scl_shd.g_old_rec.segment14, hr_api.g_varchar2) <>
414: nvl(p_segment14, hr_api.g_varchar2) )
415: or ( (nvl(p_segment15, hr_api.g_varchar2) <> hr_api.g_varchar2)
416: and nvl(hr_scl_shd.g_old_rec.segment15, hr_api.g_varchar2) <>
417: nvl(p_segment15, hr_api.g_varchar2) )
418: or ( (nvl(p_segment16, hr_api.g_varchar2) <> hr_api.g_varchar2)
411: nvl(p_segment13, hr_api.g_varchar2) )
412: or ( (nvl(p_segment14, hr_api.g_varchar2) <> hr_api.g_varchar2)
413: and nvl(hr_scl_shd.g_old_rec.segment14, hr_api.g_varchar2) <>
414: nvl(p_segment14, hr_api.g_varchar2) )
415: or ( (nvl(p_segment15, hr_api.g_varchar2) <> hr_api.g_varchar2)
416: and nvl(hr_scl_shd.g_old_rec.segment15, hr_api.g_varchar2) <>
417: nvl(p_segment15, hr_api.g_varchar2) )
418: or ( (nvl(p_segment16, hr_api.g_varchar2) <> hr_api.g_varchar2)
419: and nvl(hr_scl_shd.g_old_rec.segment16, hr_api.g_varchar2) <>
412: or ( (nvl(p_segment14, hr_api.g_varchar2) <> hr_api.g_varchar2)
413: and nvl(hr_scl_shd.g_old_rec.segment14, hr_api.g_varchar2) <>
414: nvl(p_segment14, hr_api.g_varchar2) )
415: or ( (nvl(p_segment15, hr_api.g_varchar2) <> hr_api.g_varchar2)
416: and nvl(hr_scl_shd.g_old_rec.segment15, hr_api.g_varchar2) <>
417: nvl(p_segment15, hr_api.g_varchar2) )
418: or ( (nvl(p_segment16, hr_api.g_varchar2) <> hr_api.g_varchar2)
419: and nvl(hr_scl_shd.g_old_rec.segment16, hr_api.g_varchar2) <>
420: nvl(p_segment16, hr_api.g_varchar2) )
413: and nvl(hr_scl_shd.g_old_rec.segment14, hr_api.g_varchar2) <>
414: nvl(p_segment14, hr_api.g_varchar2) )
415: or ( (nvl(p_segment15, hr_api.g_varchar2) <> hr_api.g_varchar2)
416: and nvl(hr_scl_shd.g_old_rec.segment15, hr_api.g_varchar2) <>
417: nvl(p_segment15, hr_api.g_varchar2) )
418: or ( (nvl(p_segment16, hr_api.g_varchar2) <> hr_api.g_varchar2)
419: and nvl(hr_scl_shd.g_old_rec.segment16, hr_api.g_varchar2) <>
420: nvl(p_segment16, hr_api.g_varchar2) )
421: or ( (nvl(p_segment17, hr_api.g_varchar2) <> hr_api.g_varchar2)
414: nvl(p_segment14, hr_api.g_varchar2) )
415: or ( (nvl(p_segment15, hr_api.g_varchar2) <> hr_api.g_varchar2)
416: and nvl(hr_scl_shd.g_old_rec.segment15, hr_api.g_varchar2) <>
417: nvl(p_segment15, hr_api.g_varchar2) )
418: or ( (nvl(p_segment16, hr_api.g_varchar2) <> hr_api.g_varchar2)
419: and nvl(hr_scl_shd.g_old_rec.segment16, hr_api.g_varchar2) <>
420: nvl(p_segment16, hr_api.g_varchar2) )
421: or ( (nvl(p_segment17, hr_api.g_varchar2) <> hr_api.g_varchar2)
422: and nvl(hr_scl_shd.g_old_rec.segment17, hr_api.g_varchar2) <>
415: or ( (nvl(p_segment15, hr_api.g_varchar2) <> hr_api.g_varchar2)
416: and nvl(hr_scl_shd.g_old_rec.segment15, hr_api.g_varchar2) <>
417: nvl(p_segment15, hr_api.g_varchar2) )
418: or ( (nvl(p_segment16, hr_api.g_varchar2) <> hr_api.g_varchar2)
419: and nvl(hr_scl_shd.g_old_rec.segment16, hr_api.g_varchar2) <>
420: nvl(p_segment16, hr_api.g_varchar2) )
421: or ( (nvl(p_segment17, hr_api.g_varchar2) <> hr_api.g_varchar2)
422: and nvl(hr_scl_shd.g_old_rec.segment17, hr_api.g_varchar2) <>
423: nvl(p_segment17, hr_api.g_varchar2) )
416: and nvl(hr_scl_shd.g_old_rec.segment15, hr_api.g_varchar2) <>
417: nvl(p_segment15, hr_api.g_varchar2) )
418: or ( (nvl(p_segment16, hr_api.g_varchar2) <> hr_api.g_varchar2)
419: and nvl(hr_scl_shd.g_old_rec.segment16, hr_api.g_varchar2) <>
420: nvl(p_segment16, hr_api.g_varchar2) )
421: or ( (nvl(p_segment17, hr_api.g_varchar2) <> hr_api.g_varchar2)
422: and nvl(hr_scl_shd.g_old_rec.segment17, hr_api.g_varchar2) <>
423: nvl(p_segment17, hr_api.g_varchar2) )
424: or ( (nvl(p_segment18, hr_api.g_varchar2) <> hr_api.g_varchar2)
417: nvl(p_segment15, hr_api.g_varchar2) )
418: or ( (nvl(p_segment16, hr_api.g_varchar2) <> hr_api.g_varchar2)
419: and nvl(hr_scl_shd.g_old_rec.segment16, hr_api.g_varchar2) <>
420: nvl(p_segment16, hr_api.g_varchar2) )
421: or ( (nvl(p_segment17, hr_api.g_varchar2) <> hr_api.g_varchar2)
422: and nvl(hr_scl_shd.g_old_rec.segment17, hr_api.g_varchar2) <>
423: nvl(p_segment17, hr_api.g_varchar2) )
424: or ( (nvl(p_segment18, hr_api.g_varchar2) <> hr_api.g_varchar2)
425: and nvl(hr_scl_shd.g_old_rec.segment18, hr_api.g_varchar2) <>
418: or ( (nvl(p_segment16, hr_api.g_varchar2) <> hr_api.g_varchar2)
419: and nvl(hr_scl_shd.g_old_rec.segment16, hr_api.g_varchar2) <>
420: nvl(p_segment16, hr_api.g_varchar2) )
421: or ( (nvl(p_segment17, hr_api.g_varchar2) <> hr_api.g_varchar2)
422: and nvl(hr_scl_shd.g_old_rec.segment17, hr_api.g_varchar2) <>
423: nvl(p_segment17, hr_api.g_varchar2) )
424: or ( (nvl(p_segment18, hr_api.g_varchar2) <> hr_api.g_varchar2)
425: and nvl(hr_scl_shd.g_old_rec.segment18, hr_api.g_varchar2) <>
426: nvl(p_segment18, hr_api.g_varchar2) )
419: and nvl(hr_scl_shd.g_old_rec.segment16, hr_api.g_varchar2) <>
420: nvl(p_segment16, hr_api.g_varchar2) )
421: or ( (nvl(p_segment17, hr_api.g_varchar2) <> hr_api.g_varchar2)
422: and nvl(hr_scl_shd.g_old_rec.segment17, hr_api.g_varchar2) <>
423: nvl(p_segment17, hr_api.g_varchar2) )
424: or ( (nvl(p_segment18, hr_api.g_varchar2) <> hr_api.g_varchar2)
425: and nvl(hr_scl_shd.g_old_rec.segment18, hr_api.g_varchar2) <>
426: nvl(p_segment18, hr_api.g_varchar2) )
427: or ( (nvl(p_segment19, hr_api.g_varchar2) <> hr_api.g_varchar2)
420: nvl(p_segment16, hr_api.g_varchar2) )
421: or ( (nvl(p_segment17, hr_api.g_varchar2) <> hr_api.g_varchar2)
422: and nvl(hr_scl_shd.g_old_rec.segment17, hr_api.g_varchar2) <>
423: nvl(p_segment17, hr_api.g_varchar2) )
424: or ( (nvl(p_segment18, hr_api.g_varchar2) <> hr_api.g_varchar2)
425: and nvl(hr_scl_shd.g_old_rec.segment18, hr_api.g_varchar2) <>
426: nvl(p_segment18, hr_api.g_varchar2) )
427: or ( (nvl(p_segment19, hr_api.g_varchar2) <> hr_api.g_varchar2)
428: and nvl(hr_scl_shd.g_old_rec.segment19, hr_api.g_varchar2) <>
421: or ( (nvl(p_segment17, hr_api.g_varchar2) <> hr_api.g_varchar2)
422: and nvl(hr_scl_shd.g_old_rec.segment17, hr_api.g_varchar2) <>
423: nvl(p_segment17, hr_api.g_varchar2) )
424: or ( (nvl(p_segment18, hr_api.g_varchar2) <> hr_api.g_varchar2)
425: and nvl(hr_scl_shd.g_old_rec.segment18, hr_api.g_varchar2) <>
426: nvl(p_segment18, hr_api.g_varchar2) )
427: or ( (nvl(p_segment19, hr_api.g_varchar2) <> hr_api.g_varchar2)
428: and nvl(hr_scl_shd.g_old_rec.segment19, hr_api.g_varchar2) <>
429: nvl(p_segment19, hr_api.g_varchar2) )
422: and nvl(hr_scl_shd.g_old_rec.segment17, hr_api.g_varchar2) <>
423: nvl(p_segment17, hr_api.g_varchar2) )
424: or ( (nvl(p_segment18, hr_api.g_varchar2) <> hr_api.g_varchar2)
425: and nvl(hr_scl_shd.g_old_rec.segment18, hr_api.g_varchar2) <>
426: nvl(p_segment18, hr_api.g_varchar2) )
427: or ( (nvl(p_segment19, hr_api.g_varchar2) <> hr_api.g_varchar2)
428: and nvl(hr_scl_shd.g_old_rec.segment19, hr_api.g_varchar2) <>
429: nvl(p_segment19, hr_api.g_varchar2) )
430: or ( (nvl(p_segment20, hr_api.g_varchar2) <> hr_api.g_varchar2)
423: nvl(p_segment17, hr_api.g_varchar2) )
424: or ( (nvl(p_segment18, hr_api.g_varchar2) <> hr_api.g_varchar2)
425: and nvl(hr_scl_shd.g_old_rec.segment18, hr_api.g_varchar2) <>
426: nvl(p_segment18, hr_api.g_varchar2) )
427: or ( (nvl(p_segment19, hr_api.g_varchar2) <> hr_api.g_varchar2)
428: and nvl(hr_scl_shd.g_old_rec.segment19, hr_api.g_varchar2) <>
429: nvl(p_segment19, hr_api.g_varchar2) )
430: or ( (nvl(p_segment20, hr_api.g_varchar2) <> hr_api.g_varchar2)
431: and nvl(hr_scl_shd.g_old_rec.segment20, hr_api.g_varchar2) <>
424: or ( (nvl(p_segment18, hr_api.g_varchar2) <> hr_api.g_varchar2)
425: and nvl(hr_scl_shd.g_old_rec.segment18, hr_api.g_varchar2) <>
426: nvl(p_segment18, hr_api.g_varchar2) )
427: or ( (nvl(p_segment19, hr_api.g_varchar2) <> hr_api.g_varchar2)
428: and nvl(hr_scl_shd.g_old_rec.segment19, hr_api.g_varchar2) <>
429: nvl(p_segment19, hr_api.g_varchar2) )
430: or ( (nvl(p_segment20, hr_api.g_varchar2) <> hr_api.g_varchar2)
431: and nvl(hr_scl_shd.g_old_rec.segment20, hr_api.g_varchar2) <>
432: nvl(p_segment20, hr_api.g_varchar2) )
425: and nvl(hr_scl_shd.g_old_rec.segment18, hr_api.g_varchar2) <>
426: nvl(p_segment18, hr_api.g_varchar2) )
427: or ( (nvl(p_segment19, hr_api.g_varchar2) <> hr_api.g_varchar2)
428: and nvl(hr_scl_shd.g_old_rec.segment19, hr_api.g_varchar2) <>
429: nvl(p_segment19, hr_api.g_varchar2) )
430: or ( (nvl(p_segment20, hr_api.g_varchar2) <> hr_api.g_varchar2)
431: and nvl(hr_scl_shd.g_old_rec.segment20, hr_api.g_varchar2) <>
432: nvl(p_segment20, hr_api.g_varchar2) )
433: or ( (nvl(p_segment21, hr_api.g_varchar2) <> hr_api.g_varchar2)
426: nvl(p_segment18, hr_api.g_varchar2) )
427: or ( (nvl(p_segment19, hr_api.g_varchar2) <> hr_api.g_varchar2)
428: and nvl(hr_scl_shd.g_old_rec.segment19, hr_api.g_varchar2) <>
429: nvl(p_segment19, hr_api.g_varchar2) )
430: or ( (nvl(p_segment20, hr_api.g_varchar2) <> hr_api.g_varchar2)
431: and nvl(hr_scl_shd.g_old_rec.segment20, hr_api.g_varchar2) <>
432: nvl(p_segment20, hr_api.g_varchar2) )
433: or ( (nvl(p_segment21, hr_api.g_varchar2) <> hr_api.g_varchar2)
434: and nvl(hr_scl_shd.g_old_rec.segment21, hr_api.g_varchar2) <>
427: or ( (nvl(p_segment19, hr_api.g_varchar2) <> hr_api.g_varchar2)
428: and nvl(hr_scl_shd.g_old_rec.segment19, hr_api.g_varchar2) <>
429: nvl(p_segment19, hr_api.g_varchar2) )
430: or ( (nvl(p_segment20, hr_api.g_varchar2) <> hr_api.g_varchar2)
431: and nvl(hr_scl_shd.g_old_rec.segment20, hr_api.g_varchar2) <>
432: nvl(p_segment20, hr_api.g_varchar2) )
433: or ( (nvl(p_segment21, hr_api.g_varchar2) <> hr_api.g_varchar2)
434: and nvl(hr_scl_shd.g_old_rec.segment21, hr_api.g_varchar2) <>
435: nvl(p_segment21, hr_api.g_varchar2) )
428: and nvl(hr_scl_shd.g_old_rec.segment19, hr_api.g_varchar2) <>
429: nvl(p_segment19, hr_api.g_varchar2) )
430: or ( (nvl(p_segment20, hr_api.g_varchar2) <> hr_api.g_varchar2)
431: and nvl(hr_scl_shd.g_old_rec.segment20, hr_api.g_varchar2) <>
432: nvl(p_segment20, hr_api.g_varchar2) )
433: or ( (nvl(p_segment21, hr_api.g_varchar2) <> hr_api.g_varchar2)
434: and nvl(hr_scl_shd.g_old_rec.segment21, hr_api.g_varchar2) <>
435: nvl(p_segment21, hr_api.g_varchar2) )
436: or ( (nvl(p_segment22, hr_api.g_varchar2) <> hr_api.g_varchar2)
429: nvl(p_segment19, hr_api.g_varchar2) )
430: or ( (nvl(p_segment20, hr_api.g_varchar2) <> hr_api.g_varchar2)
431: and nvl(hr_scl_shd.g_old_rec.segment20, hr_api.g_varchar2) <>
432: nvl(p_segment20, hr_api.g_varchar2) )
433: or ( (nvl(p_segment21, hr_api.g_varchar2) <> hr_api.g_varchar2)
434: and nvl(hr_scl_shd.g_old_rec.segment21, hr_api.g_varchar2) <>
435: nvl(p_segment21, hr_api.g_varchar2) )
436: or ( (nvl(p_segment22, hr_api.g_varchar2) <> hr_api.g_varchar2)
437: and nvl(hr_scl_shd.g_old_rec.segment22, hr_api.g_varchar2) <>
430: or ( (nvl(p_segment20, hr_api.g_varchar2) <> hr_api.g_varchar2)
431: and nvl(hr_scl_shd.g_old_rec.segment20, hr_api.g_varchar2) <>
432: nvl(p_segment20, hr_api.g_varchar2) )
433: or ( (nvl(p_segment21, hr_api.g_varchar2) <> hr_api.g_varchar2)
434: and nvl(hr_scl_shd.g_old_rec.segment21, hr_api.g_varchar2) <>
435: nvl(p_segment21, hr_api.g_varchar2) )
436: or ( (nvl(p_segment22, hr_api.g_varchar2) <> hr_api.g_varchar2)
437: and nvl(hr_scl_shd.g_old_rec.segment22, hr_api.g_varchar2) <>
438: nvl(p_segment22, hr_api.g_varchar2) )
431: and nvl(hr_scl_shd.g_old_rec.segment20, hr_api.g_varchar2) <>
432: nvl(p_segment20, hr_api.g_varchar2) )
433: or ( (nvl(p_segment21, hr_api.g_varchar2) <> hr_api.g_varchar2)
434: and nvl(hr_scl_shd.g_old_rec.segment21, hr_api.g_varchar2) <>
435: nvl(p_segment21, hr_api.g_varchar2) )
436: or ( (nvl(p_segment22, hr_api.g_varchar2) <> hr_api.g_varchar2)
437: and nvl(hr_scl_shd.g_old_rec.segment22, hr_api.g_varchar2) <>
438: nvl(p_segment22, hr_api.g_varchar2) )
439: or ( (nvl(p_segment23, hr_api.g_varchar2) <> hr_api.g_varchar2)
432: nvl(p_segment20, hr_api.g_varchar2) )
433: or ( (nvl(p_segment21, hr_api.g_varchar2) <> hr_api.g_varchar2)
434: and nvl(hr_scl_shd.g_old_rec.segment21, hr_api.g_varchar2) <>
435: nvl(p_segment21, hr_api.g_varchar2) )
436: or ( (nvl(p_segment22, hr_api.g_varchar2) <> hr_api.g_varchar2)
437: and nvl(hr_scl_shd.g_old_rec.segment22, hr_api.g_varchar2) <>
438: nvl(p_segment22, hr_api.g_varchar2) )
439: or ( (nvl(p_segment23, hr_api.g_varchar2) <> hr_api.g_varchar2)
440: and nvl(hr_scl_shd.g_old_rec.segment23, hr_api.g_varchar2) <>
433: or ( (nvl(p_segment21, hr_api.g_varchar2) <> hr_api.g_varchar2)
434: and nvl(hr_scl_shd.g_old_rec.segment21, hr_api.g_varchar2) <>
435: nvl(p_segment21, hr_api.g_varchar2) )
436: or ( (nvl(p_segment22, hr_api.g_varchar2) <> hr_api.g_varchar2)
437: and nvl(hr_scl_shd.g_old_rec.segment22, hr_api.g_varchar2) <>
438: nvl(p_segment22, hr_api.g_varchar2) )
439: or ( (nvl(p_segment23, hr_api.g_varchar2) <> hr_api.g_varchar2)
440: and nvl(hr_scl_shd.g_old_rec.segment23, hr_api.g_varchar2) <>
441: nvl(p_segment23, hr_api.g_varchar2) )
434: and nvl(hr_scl_shd.g_old_rec.segment21, hr_api.g_varchar2) <>
435: nvl(p_segment21, hr_api.g_varchar2) )
436: or ( (nvl(p_segment22, hr_api.g_varchar2) <> hr_api.g_varchar2)
437: and nvl(hr_scl_shd.g_old_rec.segment22, hr_api.g_varchar2) <>
438: nvl(p_segment22, hr_api.g_varchar2) )
439: or ( (nvl(p_segment23, hr_api.g_varchar2) <> hr_api.g_varchar2)
440: and nvl(hr_scl_shd.g_old_rec.segment23, hr_api.g_varchar2) <>
441: nvl(p_segment23, hr_api.g_varchar2) )
442: or ( (nvl(p_segment24, hr_api.g_varchar2) <> hr_api.g_varchar2)
435: nvl(p_segment21, hr_api.g_varchar2) )
436: or ( (nvl(p_segment22, hr_api.g_varchar2) <> hr_api.g_varchar2)
437: and nvl(hr_scl_shd.g_old_rec.segment22, hr_api.g_varchar2) <>
438: nvl(p_segment22, hr_api.g_varchar2) )
439: or ( (nvl(p_segment23, hr_api.g_varchar2) <> hr_api.g_varchar2)
440: and nvl(hr_scl_shd.g_old_rec.segment23, hr_api.g_varchar2) <>
441: nvl(p_segment23, hr_api.g_varchar2) )
442: or ( (nvl(p_segment24, hr_api.g_varchar2) <> hr_api.g_varchar2)
443: and nvl(hr_scl_shd.g_old_rec.segment24, hr_api.g_varchar2) <>
436: or ( (nvl(p_segment22, hr_api.g_varchar2) <> hr_api.g_varchar2)
437: and nvl(hr_scl_shd.g_old_rec.segment22, hr_api.g_varchar2) <>
438: nvl(p_segment22, hr_api.g_varchar2) )
439: or ( (nvl(p_segment23, hr_api.g_varchar2) <> hr_api.g_varchar2)
440: and nvl(hr_scl_shd.g_old_rec.segment23, hr_api.g_varchar2) <>
441: nvl(p_segment23, hr_api.g_varchar2) )
442: or ( (nvl(p_segment24, hr_api.g_varchar2) <> hr_api.g_varchar2)
443: and nvl(hr_scl_shd.g_old_rec.segment24, hr_api.g_varchar2) <>
444: nvl(p_segment24, hr_api.g_varchar2) )
437: and nvl(hr_scl_shd.g_old_rec.segment22, hr_api.g_varchar2) <>
438: nvl(p_segment22, hr_api.g_varchar2) )
439: or ( (nvl(p_segment23, hr_api.g_varchar2) <> hr_api.g_varchar2)
440: and nvl(hr_scl_shd.g_old_rec.segment23, hr_api.g_varchar2) <>
441: nvl(p_segment23, hr_api.g_varchar2) )
442: or ( (nvl(p_segment24, hr_api.g_varchar2) <> hr_api.g_varchar2)
443: and nvl(hr_scl_shd.g_old_rec.segment24, hr_api.g_varchar2) <>
444: nvl(p_segment24, hr_api.g_varchar2) )
445: or ( (nvl(p_segment25, hr_api.g_varchar2) <> hr_api.g_varchar2)
438: nvl(p_segment22, hr_api.g_varchar2) )
439: or ( (nvl(p_segment23, hr_api.g_varchar2) <> hr_api.g_varchar2)
440: and nvl(hr_scl_shd.g_old_rec.segment23, hr_api.g_varchar2) <>
441: nvl(p_segment23, hr_api.g_varchar2) )
442: or ( (nvl(p_segment24, hr_api.g_varchar2) <> hr_api.g_varchar2)
443: and nvl(hr_scl_shd.g_old_rec.segment24, hr_api.g_varchar2) <>
444: nvl(p_segment24, hr_api.g_varchar2) )
445: or ( (nvl(p_segment25, hr_api.g_varchar2) <> hr_api.g_varchar2)
446: and nvl(hr_scl_shd.g_old_rec.segment25, hr_api.g_varchar2) <>
439: or ( (nvl(p_segment23, hr_api.g_varchar2) <> hr_api.g_varchar2)
440: and nvl(hr_scl_shd.g_old_rec.segment23, hr_api.g_varchar2) <>
441: nvl(p_segment23, hr_api.g_varchar2) )
442: or ( (nvl(p_segment24, hr_api.g_varchar2) <> hr_api.g_varchar2)
443: and nvl(hr_scl_shd.g_old_rec.segment24, hr_api.g_varchar2) <>
444: nvl(p_segment24, hr_api.g_varchar2) )
445: or ( (nvl(p_segment25, hr_api.g_varchar2) <> hr_api.g_varchar2)
446: and nvl(hr_scl_shd.g_old_rec.segment25, hr_api.g_varchar2) <>
447: nvl(p_segment25, hr_api.g_varchar2) )
440: and nvl(hr_scl_shd.g_old_rec.segment23, hr_api.g_varchar2) <>
441: nvl(p_segment23, hr_api.g_varchar2) )
442: or ( (nvl(p_segment24, hr_api.g_varchar2) <> hr_api.g_varchar2)
443: and nvl(hr_scl_shd.g_old_rec.segment24, hr_api.g_varchar2) <>
444: nvl(p_segment24, hr_api.g_varchar2) )
445: or ( (nvl(p_segment25, hr_api.g_varchar2) <> hr_api.g_varchar2)
446: and nvl(hr_scl_shd.g_old_rec.segment25, hr_api.g_varchar2) <>
447: nvl(p_segment25, hr_api.g_varchar2) )
448: or ( (nvl(p_segment26, hr_api.g_varchar2) <> hr_api.g_varchar2)
441: nvl(p_segment23, hr_api.g_varchar2) )
442: or ( (nvl(p_segment24, hr_api.g_varchar2) <> hr_api.g_varchar2)
443: and nvl(hr_scl_shd.g_old_rec.segment24, hr_api.g_varchar2) <>
444: nvl(p_segment24, hr_api.g_varchar2) )
445: or ( (nvl(p_segment25, hr_api.g_varchar2) <> hr_api.g_varchar2)
446: and nvl(hr_scl_shd.g_old_rec.segment25, hr_api.g_varchar2) <>
447: nvl(p_segment25, hr_api.g_varchar2) )
448: or ( (nvl(p_segment26, hr_api.g_varchar2) <> hr_api.g_varchar2)
449: and nvl(hr_scl_shd.g_old_rec.segment26, hr_api.g_varchar2) <>
442: or ( (nvl(p_segment24, hr_api.g_varchar2) <> hr_api.g_varchar2)
443: and nvl(hr_scl_shd.g_old_rec.segment24, hr_api.g_varchar2) <>
444: nvl(p_segment24, hr_api.g_varchar2) )
445: or ( (nvl(p_segment25, hr_api.g_varchar2) <> hr_api.g_varchar2)
446: and nvl(hr_scl_shd.g_old_rec.segment25, hr_api.g_varchar2) <>
447: nvl(p_segment25, hr_api.g_varchar2) )
448: or ( (nvl(p_segment26, hr_api.g_varchar2) <> hr_api.g_varchar2)
449: and nvl(hr_scl_shd.g_old_rec.segment26, hr_api.g_varchar2) <>
450: nvl(p_segment26, hr_api.g_varchar2) )
443: and nvl(hr_scl_shd.g_old_rec.segment24, hr_api.g_varchar2) <>
444: nvl(p_segment24, hr_api.g_varchar2) )
445: or ( (nvl(p_segment25, hr_api.g_varchar2) <> hr_api.g_varchar2)
446: and nvl(hr_scl_shd.g_old_rec.segment25, hr_api.g_varchar2) <>
447: nvl(p_segment25, hr_api.g_varchar2) )
448: or ( (nvl(p_segment26, hr_api.g_varchar2) <> hr_api.g_varchar2)
449: and nvl(hr_scl_shd.g_old_rec.segment26, hr_api.g_varchar2) <>
450: nvl(p_segment26, hr_api.g_varchar2) )
451: or ( (nvl(p_segment27, hr_api.g_varchar2) <> hr_api.g_varchar2)
444: nvl(p_segment24, hr_api.g_varchar2) )
445: or ( (nvl(p_segment25, hr_api.g_varchar2) <> hr_api.g_varchar2)
446: and nvl(hr_scl_shd.g_old_rec.segment25, hr_api.g_varchar2) <>
447: nvl(p_segment25, hr_api.g_varchar2) )
448: or ( (nvl(p_segment26, hr_api.g_varchar2) <> hr_api.g_varchar2)
449: and nvl(hr_scl_shd.g_old_rec.segment26, hr_api.g_varchar2) <>
450: nvl(p_segment26, hr_api.g_varchar2) )
451: or ( (nvl(p_segment27, hr_api.g_varchar2) <> hr_api.g_varchar2)
452: and nvl(hr_scl_shd.g_old_rec.segment27, hr_api.g_varchar2) <>
445: or ( (nvl(p_segment25, hr_api.g_varchar2) <> hr_api.g_varchar2)
446: and nvl(hr_scl_shd.g_old_rec.segment25, hr_api.g_varchar2) <>
447: nvl(p_segment25, hr_api.g_varchar2) )
448: or ( (nvl(p_segment26, hr_api.g_varchar2) <> hr_api.g_varchar2)
449: and nvl(hr_scl_shd.g_old_rec.segment26, hr_api.g_varchar2) <>
450: nvl(p_segment26, hr_api.g_varchar2) )
451: or ( (nvl(p_segment27, hr_api.g_varchar2) <> hr_api.g_varchar2)
452: and nvl(hr_scl_shd.g_old_rec.segment27, hr_api.g_varchar2) <>
453: nvl(p_segment27, hr_api.g_varchar2) )
446: and nvl(hr_scl_shd.g_old_rec.segment25, hr_api.g_varchar2) <>
447: nvl(p_segment25, hr_api.g_varchar2) )
448: or ( (nvl(p_segment26, hr_api.g_varchar2) <> hr_api.g_varchar2)
449: and nvl(hr_scl_shd.g_old_rec.segment26, hr_api.g_varchar2) <>
450: nvl(p_segment26, hr_api.g_varchar2) )
451: or ( (nvl(p_segment27, hr_api.g_varchar2) <> hr_api.g_varchar2)
452: and nvl(hr_scl_shd.g_old_rec.segment27, hr_api.g_varchar2) <>
453: nvl(p_segment27, hr_api.g_varchar2) )
454: or ( (nvl(p_segment28, hr_api.g_varchar2) <> hr_api.g_varchar2)
447: nvl(p_segment25, hr_api.g_varchar2) )
448: or ( (nvl(p_segment26, hr_api.g_varchar2) <> hr_api.g_varchar2)
449: and nvl(hr_scl_shd.g_old_rec.segment26, hr_api.g_varchar2) <>
450: nvl(p_segment26, hr_api.g_varchar2) )
451: or ( (nvl(p_segment27, hr_api.g_varchar2) <> hr_api.g_varchar2)
452: and nvl(hr_scl_shd.g_old_rec.segment27, hr_api.g_varchar2) <>
453: nvl(p_segment27, hr_api.g_varchar2) )
454: or ( (nvl(p_segment28, hr_api.g_varchar2) <> hr_api.g_varchar2)
455: and nvl(hr_scl_shd.g_old_rec.segment28, hr_api.g_varchar2) <>
448: or ( (nvl(p_segment26, hr_api.g_varchar2) <> hr_api.g_varchar2)
449: and nvl(hr_scl_shd.g_old_rec.segment26, hr_api.g_varchar2) <>
450: nvl(p_segment26, hr_api.g_varchar2) )
451: or ( (nvl(p_segment27, hr_api.g_varchar2) <> hr_api.g_varchar2)
452: and nvl(hr_scl_shd.g_old_rec.segment27, hr_api.g_varchar2) <>
453: nvl(p_segment27, hr_api.g_varchar2) )
454: or ( (nvl(p_segment28, hr_api.g_varchar2) <> hr_api.g_varchar2)
455: and nvl(hr_scl_shd.g_old_rec.segment28, hr_api.g_varchar2) <>
456: nvl(p_segment28, hr_api.g_varchar2) )
449: and nvl(hr_scl_shd.g_old_rec.segment26, hr_api.g_varchar2) <>
450: nvl(p_segment26, hr_api.g_varchar2) )
451: or ( (nvl(p_segment27, hr_api.g_varchar2) <> hr_api.g_varchar2)
452: and nvl(hr_scl_shd.g_old_rec.segment27, hr_api.g_varchar2) <>
453: nvl(p_segment27, hr_api.g_varchar2) )
454: or ( (nvl(p_segment28, hr_api.g_varchar2) <> hr_api.g_varchar2)
455: and nvl(hr_scl_shd.g_old_rec.segment28, hr_api.g_varchar2) <>
456: nvl(p_segment28, hr_api.g_varchar2) )
457: or ( (nvl(p_segment29, hr_api.g_varchar2) <> hr_api.g_varchar2)
450: nvl(p_segment26, hr_api.g_varchar2) )
451: or ( (nvl(p_segment27, hr_api.g_varchar2) <> hr_api.g_varchar2)
452: and nvl(hr_scl_shd.g_old_rec.segment27, hr_api.g_varchar2) <>
453: nvl(p_segment27, hr_api.g_varchar2) )
454: or ( (nvl(p_segment28, hr_api.g_varchar2) <> hr_api.g_varchar2)
455: and nvl(hr_scl_shd.g_old_rec.segment28, hr_api.g_varchar2) <>
456: nvl(p_segment28, hr_api.g_varchar2) )
457: or ( (nvl(p_segment29, hr_api.g_varchar2) <> hr_api.g_varchar2)
458: and nvl(hr_scl_shd.g_old_rec.segment29, hr_api.g_varchar2) <>
451: or ( (nvl(p_segment27, hr_api.g_varchar2) <> hr_api.g_varchar2)
452: and nvl(hr_scl_shd.g_old_rec.segment27, hr_api.g_varchar2) <>
453: nvl(p_segment27, hr_api.g_varchar2) )
454: or ( (nvl(p_segment28, hr_api.g_varchar2) <> hr_api.g_varchar2)
455: and nvl(hr_scl_shd.g_old_rec.segment28, hr_api.g_varchar2) <>
456: nvl(p_segment28, hr_api.g_varchar2) )
457: or ( (nvl(p_segment29, hr_api.g_varchar2) <> hr_api.g_varchar2)
458: and nvl(hr_scl_shd.g_old_rec.segment29, hr_api.g_varchar2) <>
459: nvl(p_segment29, hr_api.g_varchar2) )
452: and nvl(hr_scl_shd.g_old_rec.segment27, hr_api.g_varchar2) <>
453: nvl(p_segment27, hr_api.g_varchar2) )
454: or ( (nvl(p_segment28, hr_api.g_varchar2) <> hr_api.g_varchar2)
455: and nvl(hr_scl_shd.g_old_rec.segment28, hr_api.g_varchar2) <>
456: nvl(p_segment28, hr_api.g_varchar2) )
457: or ( (nvl(p_segment29, hr_api.g_varchar2) <> hr_api.g_varchar2)
458: and nvl(hr_scl_shd.g_old_rec.segment29, hr_api.g_varchar2) <>
459: nvl(p_segment29, hr_api.g_varchar2) )
460: or ( (nvl(p_segment30, hr_api.g_varchar2) <> hr_api.g_varchar2)
453: nvl(p_segment27, hr_api.g_varchar2) )
454: or ( (nvl(p_segment28, hr_api.g_varchar2) <> hr_api.g_varchar2)
455: and nvl(hr_scl_shd.g_old_rec.segment28, hr_api.g_varchar2) <>
456: nvl(p_segment28, hr_api.g_varchar2) )
457: or ( (nvl(p_segment29, hr_api.g_varchar2) <> hr_api.g_varchar2)
458: and nvl(hr_scl_shd.g_old_rec.segment29, hr_api.g_varchar2) <>
459: nvl(p_segment29, hr_api.g_varchar2) )
460: or ( (nvl(p_segment30, hr_api.g_varchar2) <> hr_api.g_varchar2)
461: and nvl(hr_scl_shd.g_old_rec.segment30, hr_api.g_varchar2) <>
454: or ( (nvl(p_segment28, hr_api.g_varchar2) <> hr_api.g_varchar2)
455: and nvl(hr_scl_shd.g_old_rec.segment28, hr_api.g_varchar2) <>
456: nvl(p_segment28, hr_api.g_varchar2) )
457: or ( (nvl(p_segment29, hr_api.g_varchar2) <> hr_api.g_varchar2)
458: and nvl(hr_scl_shd.g_old_rec.segment29, hr_api.g_varchar2) <>
459: nvl(p_segment29, hr_api.g_varchar2) )
460: or ( (nvl(p_segment30, hr_api.g_varchar2) <> hr_api.g_varchar2)
461: and nvl(hr_scl_shd.g_old_rec.segment30, hr_api.g_varchar2) <>
462: nvl(p_segment30, hr_api.g_varchar2) )
455: and nvl(hr_scl_shd.g_old_rec.segment28, hr_api.g_varchar2) <>
456: nvl(p_segment28, hr_api.g_varchar2) )
457: or ( (nvl(p_segment29, hr_api.g_varchar2) <> hr_api.g_varchar2)
458: and nvl(hr_scl_shd.g_old_rec.segment29, hr_api.g_varchar2) <>
459: nvl(p_segment29, hr_api.g_varchar2) )
460: or ( (nvl(p_segment30, hr_api.g_varchar2) <> hr_api.g_varchar2)
461: and nvl(hr_scl_shd.g_old_rec.segment30, hr_api.g_varchar2) <>
462: nvl(p_segment30, hr_api.g_varchar2) )
463: ) then
456: nvl(p_segment28, hr_api.g_varchar2) )
457: or ( (nvl(p_segment29, hr_api.g_varchar2) <> hr_api.g_varchar2)
458: and nvl(hr_scl_shd.g_old_rec.segment29, hr_api.g_varchar2) <>
459: nvl(p_segment29, hr_api.g_varchar2) )
460: or ( (nvl(p_segment30, hr_api.g_varchar2) <> hr_api.g_varchar2)
461: and nvl(hr_scl_shd.g_old_rec.segment30, hr_api.g_varchar2) <>
462: nvl(p_segment30, hr_api.g_varchar2) )
463: ) then
464: --
457: or ( (nvl(p_segment29, hr_api.g_varchar2) <> hr_api.g_varchar2)
458: and nvl(hr_scl_shd.g_old_rec.segment29, hr_api.g_varchar2) <>
459: nvl(p_segment29, hr_api.g_varchar2) )
460: or ( (nvl(p_segment30, hr_api.g_varchar2) <> hr_api.g_varchar2)
461: and nvl(hr_scl_shd.g_old_rec.segment30, hr_api.g_varchar2) <>
462: nvl(p_segment30, hr_api.g_varchar2) )
463: ) then
464: --
465: hr_utility.set_location( l_proc, 60 );
458: and nvl(hr_scl_shd.g_old_rec.segment29, hr_api.g_varchar2) <>
459: nvl(p_segment29, hr_api.g_varchar2) )
460: or ( (nvl(p_segment30, hr_api.g_varchar2) <> hr_api.g_varchar2)
461: and nvl(hr_scl_shd.g_old_rec.segment30, hr_api.g_varchar2) <>
462: nvl(p_segment30, hr_api.g_varchar2) )
463: ) then
464: --
465: hr_utility.set_location( l_proc, 60 );
466: --
479: -- check whether any of the SCL segments are being set for the first time
480: --
481: hr_utility.set_location( l_proc, 70 );
482: --
483: if nvl(p_segment1, hr_api.g_varchar2) <> hr_api.g_varchar2
484: or nvl(p_segment2, hr_api.g_varchar2) <> hr_api.g_varchar2
485: or nvl(p_segment3, hr_api.g_varchar2) <> hr_api.g_varchar2
486: or nvl(p_segment4, hr_api.g_varchar2) <> hr_api.g_varchar2
487: or nvl(p_segment5, hr_api.g_varchar2) <> hr_api.g_varchar2
480: --
481: hr_utility.set_location( l_proc, 70 );
482: --
483: if nvl(p_segment1, hr_api.g_varchar2) <> hr_api.g_varchar2
484: or nvl(p_segment2, hr_api.g_varchar2) <> hr_api.g_varchar2
485: or nvl(p_segment3, hr_api.g_varchar2) <> hr_api.g_varchar2
486: or nvl(p_segment4, hr_api.g_varchar2) <> hr_api.g_varchar2
487: or nvl(p_segment5, hr_api.g_varchar2) <> hr_api.g_varchar2
488: or nvl(p_segment6, hr_api.g_varchar2) <> hr_api.g_varchar2
481: hr_utility.set_location( l_proc, 70 );
482: --
483: if nvl(p_segment1, hr_api.g_varchar2) <> hr_api.g_varchar2
484: or nvl(p_segment2, hr_api.g_varchar2) <> hr_api.g_varchar2
485: or nvl(p_segment3, hr_api.g_varchar2) <> hr_api.g_varchar2
486: or nvl(p_segment4, hr_api.g_varchar2) <> hr_api.g_varchar2
487: or nvl(p_segment5, hr_api.g_varchar2) <> hr_api.g_varchar2
488: or nvl(p_segment6, hr_api.g_varchar2) <> hr_api.g_varchar2
489: or nvl(p_segment7, hr_api.g_varchar2) <> hr_api.g_varchar2
482: --
483: if nvl(p_segment1, hr_api.g_varchar2) <> hr_api.g_varchar2
484: or nvl(p_segment2, hr_api.g_varchar2) <> hr_api.g_varchar2
485: or nvl(p_segment3, hr_api.g_varchar2) <> hr_api.g_varchar2
486: or nvl(p_segment4, hr_api.g_varchar2) <> hr_api.g_varchar2
487: or nvl(p_segment5, hr_api.g_varchar2) <> hr_api.g_varchar2
488: or nvl(p_segment6, hr_api.g_varchar2) <> hr_api.g_varchar2
489: or nvl(p_segment7, hr_api.g_varchar2) <> hr_api.g_varchar2
490: or nvl(p_segment8, hr_api.g_varchar2) <> hr_api.g_varchar2
483: if nvl(p_segment1, hr_api.g_varchar2) <> hr_api.g_varchar2
484: or nvl(p_segment2, hr_api.g_varchar2) <> hr_api.g_varchar2
485: or nvl(p_segment3, hr_api.g_varchar2) <> hr_api.g_varchar2
486: or nvl(p_segment4, hr_api.g_varchar2) <> hr_api.g_varchar2
487: or nvl(p_segment5, hr_api.g_varchar2) <> hr_api.g_varchar2
488: or nvl(p_segment6, hr_api.g_varchar2) <> hr_api.g_varchar2
489: or nvl(p_segment7, hr_api.g_varchar2) <> hr_api.g_varchar2
490: or nvl(p_segment8, hr_api.g_varchar2) <> hr_api.g_varchar2
491: or nvl(p_segment9, hr_api.g_varchar2) <> hr_api.g_varchar2
484: or nvl(p_segment2, hr_api.g_varchar2) <> hr_api.g_varchar2
485: or nvl(p_segment3, hr_api.g_varchar2) <> hr_api.g_varchar2
486: or nvl(p_segment4, hr_api.g_varchar2) <> hr_api.g_varchar2
487: or nvl(p_segment5, hr_api.g_varchar2) <> hr_api.g_varchar2
488: or nvl(p_segment6, hr_api.g_varchar2) <> hr_api.g_varchar2
489: or nvl(p_segment7, hr_api.g_varchar2) <> hr_api.g_varchar2
490: or nvl(p_segment8, hr_api.g_varchar2) <> hr_api.g_varchar2
491: or nvl(p_segment9, hr_api.g_varchar2) <> hr_api.g_varchar2
492: or nvl(p_segment10, hr_api.g_varchar2) <> hr_api.g_varchar2
485: or nvl(p_segment3, hr_api.g_varchar2) <> hr_api.g_varchar2
486: or nvl(p_segment4, hr_api.g_varchar2) <> hr_api.g_varchar2
487: or nvl(p_segment5, hr_api.g_varchar2) <> hr_api.g_varchar2
488: or nvl(p_segment6, hr_api.g_varchar2) <> hr_api.g_varchar2
489: or nvl(p_segment7, hr_api.g_varchar2) <> hr_api.g_varchar2
490: or nvl(p_segment8, hr_api.g_varchar2) <> hr_api.g_varchar2
491: or nvl(p_segment9, hr_api.g_varchar2) <> hr_api.g_varchar2
492: or nvl(p_segment10, hr_api.g_varchar2) <> hr_api.g_varchar2
493: or nvl(p_segment11, hr_api.g_varchar2) <> hr_api.g_varchar2
486: or nvl(p_segment4, hr_api.g_varchar2) <> hr_api.g_varchar2
487: or nvl(p_segment5, hr_api.g_varchar2) <> hr_api.g_varchar2
488: or nvl(p_segment6, hr_api.g_varchar2) <> hr_api.g_varchar2
489: or nvl(p_segment7, hr_api.g_varchar2) <> hr_api.g_varchar2
490: or nvl(p_segment8, hr_api.g_varchar2) <> hr_api.g_varchar2
491: or nvl(p_segment9, hr_api.g_varchar2) <> hr_api.g_varchar2
492: or nvl(p_segment10, hr_api.g_varchar2) <> hr_api.g_varchar2
493: or nvl(p_segment11, hr_api.g_varchar2) <> hr_api.g_varchar2
494: or nvl(p_segment12, hr_api.g_varchar2) <> hr_api.g_varchar2
487: or nvl(p_segment5, hr_api.g_varchar2) <> hr_api.g_varchar2
488: or nvl(p_segment6, hr_api.g_varchar2) <> hr_api.g_varchar2
489: or nvl(p_segment7, hr_api.g_varchar2) <> hr_api.g_varchar2
490: or nvl(p_segment8, hr_api.g_varchar2) <> hr_api.g_varchar2
491: or nvl(p_segment9, hr_api.g_varchar2) <> hr_api.g_varchar2
492: or nvl(p_segment10, hr_api.g_varchar2) <> hr_api.g_varchar2
493: or nvl(p_segment11, hr_api.g_varchar2) <> hr_api.g_varchar2
494: or nvl(p_segment12, hr_api.g_varchar2) <> hr_api.g_varchar2
495: or nvl(p_segment13, hr_api.g_varchar2) <> hr_api.g_varchar2
488: or nvl(p_segment6, hr_api.g_varchar2) <> hr_api.g_varchar2
489: or nvl(p_segment7, hr_api.g_varchar2) <> hr_api.g_varchar2
490: or nvl(p_segment8, hr_api.g_varchar2) <> hr_api.g_varchar2
491: or nvl(p_segment9, hr_api.g_varchar2) <> hr_api.g_varchar2
492: or nvl(p_segment10, hr_api.g_varchar2) <> hr_api.g_varchar2
493: or nvl(p_segment11, hr_api.g_varchar2) <> hr_api.g_varchar2
494: or nvl(p_segment12, hr_api.g_varchar2) <> hr_api.g_varchar2
495: or nvl(p_segment13, hr_api.g_varchar2) <> hr_api.g_varchar2
496: or nvl(p_segment14, hr_api.g_varchar2) <> hr_api.g_varchar2
489: or nvl(p_segment7, hr_api.g_varchar2) <> hr_api.g_varchar2
490: or nvl(p_segment8, hr_api.g_varchar2) <> hr_api.g_varchar2
491: or nvl(p_segment9, hr_api.g_varchar2) <> hr_api.g_varchar2
492: or nvl(p_segment10, hr_api.g_varchar2) <> hr_api.g_varchar2
493: or nvl(p_segment11, hr_api.g_varchar2) <> hr_api.g_varchar2
494: or nvl(p_segment12, hr_api.g_varchar2) <> hr_api.g_varchar2
495: or nvl(p_segment13, hr_api.g_varchar2) <> hr_api.g_varchar2
496: or nvl(p_segment14, hr_api.g_varchar2) <> hr_api.g_varchar2
497: or nvl(p_segment15, hr_api.g_varchar2) <> hr_api.g_varchar2
490: or nvl(p_segment8, hr_api.g_varchar2) <> hr_api.g_varchar2
491: or nvl(p_segment9, hr_api.g_varchar2) <> hr_api.g_varchar2
492: or nvl(p_segment10, hr_api.g_varchar2) <> hr_api.g_varchar2
493: or nvl(p_segment11, hr_api.g_varchar2) <> hr_api.g_varchar2
494: or nvl(p_segment12, hr_api.g_varchar2) <> hr_api.g_varchar2
495: or nvl(p_segment13, hr_api.g_varchar2) <> hr_api.g_varchar2
496: or nvl(p_segment14, hr_api.g_varchar2) <> hr_api.g_varchar2
497: or nvl(p_segment15, hr_api.g_varchar2) <> hr_api.g_varchar2
498: or nvl(p_segment16, hr_api.g_varchar2) <> hr_api.g_varchar2
491: or nvl(p_segment9, hr_api.g_varchar2) <> hr_api.g_varchar2
492: or nvl(p_segment10, hr_api.g_varchar2) <> hr_api.g_varchar2
493: or nvl(p_segment11, hr_api.g_varchar2) <> hr_api.g_varchar2
494: or nvl(p_segment12, hr_api.g_varchar2) <> hr_api.g_varchar2
495: or nvl(p_segment13, hr_api.g_varchar2) <> hr_api.g_varchar2
496: or nvl(p_segment14, hr_api.g_varchar2) <> hr_api.g_varchar2
497: or nvl(p_segment15, hr_api.g_varchar2) <> hr_api.g_varchar2
498: or nvl(p_segment16, hr_api.g_varchar2) <> hr_api.g_varchar2
499: or nvl(p_segment17, hr_api.g_varchar2) <> hr_api.g_varchar2
492: or nvl(p_segment10, hr_api.g_varchar2) <> hr_api.g_varchar2
493: or nvl(p_segment11, hr_api.g_varchar2) <> hr_api.g_varchar2
494: or nvl(p_segment12, hr_api.g_varchar2) <> hr_api.g_varchar2
495: or nvl(p_segment13, hr_api.g_varchar2) <> hr_api.g_varchar2
496: or nvl(p_segment14, hr_api.g_varchar2) <> hr_api.g_varchar2
497: or nvl(p_segment15, hr_api.g_varchar2) <> hr_api.g_varchar2
498: or nvl(p_segment16, hr_api.g_varchar2) <> hr_api.g_varchar2
499: or nvl(p_segment17, hr_api.g_varchar2) <> hr_api.g_varchar2
500: or nvl(p_segment18, hr_api.g_varchar2) <> hr_api.g_varchar2
493: or nvl(p_segment11, hr_api.g_varchar2) <> hr_api.g_varchar2
494: or nvl(p_segment12, hr_api.g_varchar2) <> hr_api.g_varchar2
495: or nvl(p_segment13, hr_api.g_varchar2) <> hr_api.g_varchar2
496: or nvl(p_segment14, hr_api.g_varchar2) <> hr_api.g_varchar2
497: or nvl(p_segment15, hr_api.g_varchar2) <> hr_api.g_varchar2
498: or nvl(p_segment16, hr_api.g_varchar2) <> hr_api.g_varchar2
499: or nvl(p_segment17, hr_api.g_varchar2) <> hr_api.g_varchar2
500: or nvl(p_segment18, hr_api.g_varchar2) <> hr_api.g_varchar2
501: or nvl(p_segment19, hr_api.g_varchar2) <> hr_api.g_varchar2
494: or nvl(p_segment12, hr_api.g_varchar2) <> hr_api.g_varchar2
495: or nvl(p_segment13, hr_api.g_varchar2) <> hr_api.g_varchar2
496: or nvl(p_segment14, hr_api.g_varchar2) <> hr_api.g_varchar2
497: or nvl(p_segment15, hr_api.g_varchar2) <> hr_api.g_varchar2
498: or nvl(p_segment16, hr_api.g_varchar2) <> hr_api.g_varchar2
499: or nvl(p_segment17, hr_api.g_varchar2) <> hr_api.g_varchar2
500: or nvl(p_segment18, hr_api.g_varchar2) <> hr_api.g_varchar2
501: or nvl(p_segment19, hr_api.g_varchar2) <> hr_api.g_varchar2
502: or nvl(p_segment20, hr_api.g_varchar2) <> hr_api.g_varchar2
495: or nvl(p_segment13, hr_api.g_varchar2) <> hr_api.g_varchar2
496: or nvl(p_segment14, hr_api.g_varchar2) <> hr_api.g_varchar2
497: or nvl(p_segment15, hr_api.g_varchar2) <> hr_api.g_varchar2
498: or nvl(p_segment16, hr_api.g_varchar2) <> hr_api.g_varchar2
499: or nvl(p_segment17, hr_api.g_varchar2) <> hr_api.g_varchar2
500: or nvl(p_segment18, hr_api.g_varchar2) <> hr_api.g_varchar2
501: or nvl(p_segment19, hr_api.g_varchar2) <> hr_api.g_varchar2
502: or nvl(p_segment20, hr_api.g_varchar2) <> hr_api.g_varchar2
503: or nvl(p_segment21, hr_api.g_varchar2) <> hr_api.g_varchar2
496: or nvl(p_segment14, hr_api.g_varchar2) <> hr_api.g_varchar2
497: or nvl(p_segment15, hr_api.g_varchar2) <> hr_api.g_varchar2
498: or nvl(p_segment16, hr_api.g_varchar2) <> hr_api.g_varchar2
499: or nvl(p_segment17, hr_api.g_varchar2) <> hr_api.g_varchar2
500: or nvl(p_segment18, hr_api.g_varchar2) <> hr_api.g_varchar2
501: or nvl(p_segment19, hr_api.g_varchar2) <> hr_api.g_varchar2
502: or nvl(p_segment20, hr_api.g_varchar2) <> hr_api.g_varchar2
503: or nvl(p_segment21, hr_api.g_varchar2) <> hr_api.g_varchar2
504: or nvl(p_segment22, hr_api.g_varchar2) <> hr_api.g_varchar2
497: or nvl(p_segment15, hr_api.g_varchar2) <> hr_api.g_varchar2
498: or nvl(p_segment16, hr_api.g_varchar2) <> hr_api.g_varchar2
499: or nvl(p_segment17, hr_api.g_varchar2) <> hr_api.g_varchar2
500: or nvl(p_segment18, hr_api.g_varchar2) <> hr_api.g_varchar2
501: or nvl(p_segment19, hr_api.g_varchar2) <> hr_api.g_varchar2
502: or nvl(p_segment20, hr_api.g_varchar2) <> hr_api.g_varchar2
503: or nvl(p_segment21, hr_api.g_varchar2) <> hr_api.g_varchar2
504: or nvl(p_segment22, hr_api.g_varchar2) <> hr_api.g_varchar2
505: or nvl(p_segment23, hr_api.g_varchar2) <> hr_api.g_varchar2
498: or nvl(p_segment16, hr_api.g_varchar2) <> hr_api.g_varchar2
499: or nvl(p_segment17, hr_api.g_varchar2) <> hr_api.g_varchar2
500: or nvl(p_segment18, hr_api.g_varchar2) <> hr_api.g_varchar2
501: or nvl(p_segment19, hr_api.g_varchar2) <> hr_api.g_varchar2
502: or nvl(p_segment20, hr_api.g_varchar2) <> hr_api.g_varchar2
503: or nvl(p_segment21, hr_api.g_varchar2) <> hr_api.g_varchar2
504: or nvl(p_segment22, hr_api.g_varchar2) <> hr_api.g_varchar2
505: or nvl(p_segment23, hr_api.g_varchar2) <> hr_api.g_varchar2
506: or nvl(p_segment24, hr_api.g_varchar2) <> hr_api.g_varchar2
499: or nvl(p_segment17, hr_api.g_varchar2) <> hr_api.g_varchar2
500: or nvl(p_segment18, hr_api.g_varchar2) <> hr_api.g_varchar2
501: or nvl(p_segment19, hr_api.g_varchar2) <> hr_api.g_varchar2
502: or nvl(p_segment20, hr_api.g_varchar2) <> hr_api.g_varchar2
503: or nvl(p_segment21, hr_api.g_varchar2) <> hr_api.g_varchar2
504: or nvl(p_segment22, hr_api.g_varchar2) <> hr_api.g_varchar2
505: or nvl(p_segment23, hr_api.g_varchar2) <> hr_api.g_varchar2
506: or nvl(p_segment24, hr_api.g_varchar2) <> hr_api.g_varchar2
507: or nvl(p_segment25, hr_api.g_varchar2) <> hr_api.g_varchar2
500: or nvl(p_segment18, hr_api.g_varchar2) <> hr_api.g_varchar2
501: or nvl(p_segment19, hr_api.g_varchar2) <> hr_api.g_varchar2
502: or nvl(p_segment20, hr_api.g_varchar2) <> hr_api.g_varchar2
503: or nvl(p_segment21, hr_api.g_varchar2) <> hr_api.g_varchar2
504: or nvl(p_segment22, hr_api.g_varchar2) <> hr_api.g_varchar2
505: or nvl(p_segment23, hr_api.g_varchar2) <> hr_api.g_varchar2
506: or nvl(p_segment24, hr_api.g_varchar2) <> hr_api.g_varchar2
507: or nvl(p_segment25, hr_api.g_varchar2) <> hr_api.g_varchar2
508: or nvl(p_segment26, hr_api.g_varchar2) <> hr_api.g_varchar2
501: or nvl(p_segment19, hr_api.g_varchar2) <> hr_api.g_varchar2
502: or nvl(p_segment20, hr_api.g_varchar2) <> hr_api.g_varchar2
503: or nvl(p_segment21, hr_api.g_varchar2) <> hr_api.g_varchar2
504: or nvl(p_segment22, hr_api.g_varchar2) <> hr_api.g_varchar2
505: or nvl(p_segment23, hr_api.g_varchar2) <> hr_api.g_varchar2
506: or nvl(p_segment24, hr_api.g_varchar2) <> hr_api.g_varchar2
507: or nvl(p_segment25, hr_api.g_varchar2) <> hr_api.g_varchar2
508: or nvl(p_segment26, hr_api.g_varchar2) <> hr_api.g_varchar2
509: or nvl(p_segment27, hr_api.g_varchar2) <> hr_api.g_varchar2
502: or nvl(p_segment20, hr_api.g_varchar2) <> hr_api.g_varchar2
503: or nvl(p_segment21, hr_api.g_varchar2) <> hr_api.g_varchar2
504: or nvl(p_segment22, hr_api.g_varchar2) <> hr_api.g_varchar2
505: or nvl(p_segment23, hr_api.g_varchar2) <> hr_api.g_varchar2
506: or nvl(p_segment24, hr_api.g_varchar2) <> hr_api.g_varchar2
507: or nvl(p_segment25, hr_api.g_varchar2) <> hr_api.g_varchar2
508: or nvl(p_segment26, hr_api.g_varchar2) <> hr_api.g_varchar2
509: or nvl(p_segment27, hr_api.g_varchar2) <> hr_api.g_varchar2
510: or nvl(p_segment28, hr_api.g_varchar2) <> hr_api.g_varchar2
503: or nvl(p_segment21, hr_api.g_varchar2) <> hr_api.g_varchar2
504: or nvl(p_segment22, hr_api.g_varchar2) <> hr_api.g_varchar2
505: or nvl(p_segment23, hr_api.g_varchar2) <> hr_api.g_varchar2
506: or nvl(p_segment24, hr_api.g_varchar2) <> hr_api.g_varchar2
507: or nvl(p_segment25, hr_api.g_varchar2) <> hr_api.g_varchar2
508: or nvl(p_segment26, hr_api.g_varchar2) <> hr_api.g_varchar2
509: or nvl(p_segment27, hr_api.g_varchar2) <> hr_api.g_varchar2
510: or nvl(p_segment28, hr_api.g_varchar2) <> hr_api.g_varchar2
511: or nvl(p_segment29, hr_api.g_varchar2) <> hr_api.g_varchar2
504: or nvl(p_segment22, hr_api.g_varchar2) <> hr_api.g_varchar2
505: or nvl(p_segment23, hr_api.g_varchar2) <> hr_api.g_varchar2
506: or nvl(p_segment24, hr_api.g_varchar2) <> hr_api.g_varchar2
507: or nvl(p_segment25, hr_api.g_varchar2) <> hr_api.g_varchar2
508: or nvl(p_segment26, hr_api.g_varchar2) <> hr_api.g_varchar2
509: or nvl(p_segment27, hr_api.g_varchar2) <> hr_api.g_varchar2
510: or nvl(p_segment28, hr_api.g_varchar2) <> hr_api.g_varchar2
511: or nvl(p_segment29, hr_api.g_varchar2) <> hr_api.g_varchar2
512: or nvl(p_segment30, hr_api.g_varchar2) <> hr_api.g_varchar2 then
505: or nvl(p_segment23, hr_api.g_varchar2) <> hr_api.g_varchar2
506: or nvl(p_segment24, hr_api.g_varchar2) <> hr_api.g_varchar2
507: or nvl(p_segment25, hr_api.g_varchar2) <> hr_api.g_varchar2
508: or nvl(p_segment26, hr_api.g_varchar2) <> hr_api.g_varchar2
509: or nvl(p_segment27, hr_api.g_varchar2) <> hr_api.g_varchar2
510: or nvl(p_segment28, hr_api.g_varchar2) <> hr_api.g_varchar2
511: or nvl(p_segment29, hr_api.g_varchar2) <> hr_api.g_varchar2
512: or nvl(p_segment30, hr_api.g_varchar2) <> hr_api.g_varchar2 then
513: --
506: or nvl(p_segment24, hr_api.g_varchar2) <> hr_api.g_varchar2
507: or nvl(p_segment25, hr_api.g_varchar2) <> hr_api.g_varchar2
508: or nvl(p_segment26, hr_api.g_varchar2) <> hr_api.g_varchar2
509: or nvl(p_segment27, hr_api.g_varchar2) <> hr_api.g_varchar2
510: or nvl(p_segment28, hr_api.g_varchar2) <> hr_api.g_varchar2
511: or nvl(p_segment29, hr_api.g_varchar2) <> hr_api.g_varchar2
512: or nvl(p_segment30, hr_api.g_varchar2) <> hr_api.g_varchar2 then
513: --
514: hr_utility.set_location( l_proc, 75 );
507: or nvl(p_segment25, hr_api.g_varchar2) <> hr_api.g_varchar2
508: or nvl(p_segment26, hr_api.g_varchar2) <> hr_api.g_varchar2
509: or nvl(p_segment27, hr_api.g_varchar2) <> hr_api.g_varchar2
510: or nvl(p_segment28, hr_api.g_varchar2) <> hr_api.g_varchar2
511: or nvl(p_segment29, hr_api.g_varchar2) <> hr_api.g_varchar2
512: or nvl(p_segment30, hr_api.g_varchar2) <> hr_api.g_varchar2 then
513: --
514: hr_utility.set_location( l_proc, 75 );
515: --
508: or nvl(p_segment26, hr_api.g_varchar2) <> hr_api.g_varchar2
509: or nvl(p_segment27, hr_api.g_varchar2) <> hr_api.g_varchar2
510: or nvl(p_segment28, hr_api.g_varchar2) <> hr_api.g_varchar2
511: or nvl(p_segment29, hr_api.g_varchar2) <> hr_api.g_varchar2
512: or nvl(p_segment30, hr_api.g_varchar2) <> hr_api.g_varchar2 then
513: --
514: hr_utility.set_location( l_proc, 75 );
515: --
516: l_scl_updated_flag := TRUE;
524: end if;
525: end if;
526: --
527: if ( l_scl_updated_flag
528: or ((nvl(p_frequency, hr_api.g_varchar2) <> hr_api.g_varchar2)
529: and nvl(per_asg_shd.g_old_rec.frequency, hr_api.g_varchar2) <>
530: nvl(p_frequency, hr_api.g_varchar2) )
531: or ((nvl(p_normal_hours, hr_api.g_number) <> hr_api.g_number)
532: and nvl(per_asg_shd.g_old_rec.normal_hours, hr_api.g_number) <>
525: end if;
526: --
527: if ( l_scl_updated_flag
528: or ((nvl(p_frequency, hr_api.g_varchar2) <> hr_api.g_varchar2)
529: and nvl(per_asg_shd.g_old_rec.frequency, hr_api.g_varchar2) <>
530: nvl(p_frequency, hr_api.g_varchar2) )
531: or ((nvl(p_normal_hours, hr_api.g_number) <> hr_api.g_number)
532: and nvl(per_asg_shd.g_old_rec.normal_hours, hr_api.g_number) <>
533: nvl(p_normal_hours, hr_api.g_number) )
526: --
527: if ( l_scl_updated_flag
528: or ((nvl(p_frequency, hr_api.g_varchar2) <> hr_api.g_varchar2)
529: and nvl(per_asg_shd.g_old_rec.frequency, hr_api.g_varchar2) <>
530: nvl(p_frequency, hr_api.g_varchar2) )
531: or ((nvl(p_normal_hours, hr_api.g_number) <> hr_api.g_number)
532: and nvl(per_asg_shd.g_old_rec.normal_hours, hr_api.g_number) <>
533: nvl(p_normal_hours, hr_api.g_number) )
534: or ((nvl(p_time_normal_finish, hr_api.g_varchar2) <> hr_api.g_varchar2)
527: if ( l_scl_updated_flag
528: or ((nvl(p_frequency, hr_api.g_varchar2) <> hr_api.g_varchar2)
529: and nvl(per_asg_shd.g_old_rec.frequency, hr_api.g_varchar2) <>
530: nvl(p_frequency, hr_api.g_varchar2) )
531: or ((nvl(p_normal_hours, hr_api.g_number) <> hr_api.g_number)
532: and nvl(per_asg_shd.g_old_rec.normal_hours, hr_api.g_number) <>
533: nvl(p_normal_hours, hr_api.g_number) )
534: or ((nvl(p_time_normal_finish, hr_api.g_varchar2) <> hr_api.g_varchar2)
535: and nvl(per_asg_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2) <>
528: or ((nvl(p_frequency, hr_api.g_varchar2) <> hr_api.g_varchar2)
529: and nvl(per_asg_shd.g_old_rec.frequency, hr_api.g_varchar2) <>
530: nvl(p_frequency, hr_api.g_varchar2) )
531: or ((nvl(p_normal_hours, hr_api.g_number) <> hr_api.g_number)
532: and nvl(per_asg_shd.g_old_rec.normal_hours, hr_api.g_number) <>
533: nvl(p_normal_hours, hr_api.g_number) )
534: or ((nvl(p_time_normal_finish, hr_api.g_varchar2) <> hr_api.g_varchar2)
535: and nvl(per_asg_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2) <>
536: nvl(p_time_normal_finish,hr_api.g_varchar2) )
529: and nvl(per_asg_shd.g_old_rec.frequency, hr_api.g_varchar2) <>
530: nvl(p_frequency, hr_api.g_varchar2) )
531: or ((nvl(p_normal_hours, hr_api.g_number) <> hr_api.g_number)
532: and nvl(per_asg_shd.g_old_rec.normal_hours, hr_api.g_number) <>
533: nvl(p_normal_hours, hr_api.g_number) )
534: or ((nvl(p_time_normal_finish, hr_api.g_varchar2) <> hr_api.g_varchar2)
535: and nvl(per_asg_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2) <>
536: nvl(p_time_normal_finish,hr_api.g_varchar2) )
537: or ((nvl(p_time_normal_start, hr_api.g_varchar2) <> hr_api.g_varchar2)
530: nvl(p_frequency, hr_api.g_varchar2) )
531: or ((nvl(p_normal_hours, hr_api.g_number) <> hr_api.g_number)
532: and nvl(per_asg_shd.g_old_rec.normal_hours, hr_api.g_number) <>
533: nvl(p_normal_hours, hr_api.g_number) )
534: or ((nvl(p_time_normal_finish, hr_api.g_varchar2) <> hr_api.g_varchar2)
535: and nvl(per_asg_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2) <>
536: nvl(p_time_normal_finish,hr_api.g_varchar2) )
537: or ((nvl(p_time_normal_start, hr_api.g_varchar2) <> hr_api.g_varchar2)
538: and nvl(per_asg_shd.g_old_rec.time_normal_start, hr_api.g_varchar2) <>
531: or ((nvl(p_normal_hours, hr_api.g_number) <> hr_api.g_number)
532: and nvl(per_asg_shd.g_old_rec.normal_hours, hr_api.g_number) <>
533: nvl(p_normal_hours, hr_api.g_number) )
534: or ((nvl(p_time_normal_finish, hr_api.g_varchar2) <> hr_api.g_varchar2)
535: and nvl(per_asg_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2) <>
536: nvl(p_time_normal_finish,hr_api.g_varchar2) )
537: or ((nvl(p_time_normal_start, hr_api.g_varchar2) <> hr_api.g_varchar2)
538: and nvl(per_asg_shd.g_old_rec.time_normal_start, hr_api.g_varchar2) <>
539: nvl(p_time_normal_start, hr_api.g_varchar2) )
532: and nvl(per_asg_shd.g_old_rec.normal_hours, hr_api.g_number) <>
533: nvl(p_normal_hours, hr_api.g_number) )
534: or ((nvl(p_time_normal_finish, hr_api.g_varchar2) <> hr_api.g_varchar2)
535: and nvl(per_asg_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2) <>
536: nvl(p_time_normal_finish,hr_api.g_varchar2) )
537: or ((nvl(p_time_normal_start, hr_api.g_varchar2) <> hr_api.g_varchar2)
538: and nvl(per_asg_shd.g_old_rec.time_normal_start, hr_api.g_varchar2) <>
539: nvl(p_time_normal_start, hr_api.g_varchar2) )
540: ) then
533: nvl(p_normal_hours, hr_api.g_number) )
534: or ((nvl(p_time_normal_finish, hr_api.g_varchar2) <> hr_api.g_varchar2)
535: and nvl(per_asg_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2) <>
536: nvl(p_time_normal_finish,hr_api.g_varchar2) )
537: or ((nvl(p_time_normal_start, hr_api.g_varchar2) <> hr_api.g_varchar2)
538: and nvl(per_asg_shd.g_old_rec.time_normal_start, hr_api.g_varchar2) <>
539: nvl(p_time_normal_start, hr_api.g_varchar2) )
540: ) then
541: --
534: or ((nvl(p_time_normal_finish, hr_api.g_varchar2) <> hr_api.g_varchar2)
535: and nvl(per_asg_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2) <>
536: nvl(p_time_normal_finish,hr_api.g_varchar2) )
537: or ((nvl(p_time_normal_start, hr_api.g_varchar2) <> hr_api.g_varchar2)
538: and nvl(per_asg_shd.g_old_rec.time_normal_start, hr_api.g_varchar2) <>
539: nvl(p_time_normal_start, hr_api.g_varchar2) )
540: ) then
541: --
542: hr_utility.set_location( l_proc, 85 );
535: and nvl(per_asg_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2) <>
536: nvl(p_time_normal_finish,hr_api.g_varchar2) )
537: or ((nvl(p_time_normal_start, hr_api.g_varchar2) <> hr_api.g_varchar2)
538: and nvl(per_asg_shd.g_old_rec.time_normal_start, hr_api.g_varchar2) <>
539: nvl(p_time_normal_start, hr_api.g_varchar2) )
540: ) then
541: --
542: hr_utility.set_location( l_proc, 85 );
543: --
612: --
613: -- When in validation only mode raise the Validate_Enabled exception
614: --
615: if p_validate then
616: raise hr_api.validate_enabled;
617: end if;
618: --
619: p_object_version_number := l_object_version_number;
620: p_soft_coding_keyflex_id := l_soft_coding_keyflex_id;
629: hr_utility.set_location(' Leaving:'||l_proc, 997);
630: --
631: exception
632: --
633: when hr_api.validate_enabled then
634: --
635: -- As the Validate_Enabled exception has been raised
636: -- we must rollback to the savepoint
637: --
1060: select null
1061: from per_vacancies vac
1062: where vac.position_id = p_position_id
1063: and p_date_effective between vac.date_from
1064: and nvl(vac.date_to, hr_api.g_eot);
1065: --
1066: cursor isdel is
1067: select pbg.position_structure
1068: from per_business_groups pbg
1109: l_object_version_number := p_object_version_number;
1110: --
1111: -- Make sure p_position_id is not null
1112: --
1113: hr_api.mandatory_arg_error(p_api_name => l_proc,
1114: p_argument => 'p_position_id',
1115: p_argument_value => p_position_id);
1116: --
1117: -- Get business_group_id, and all attributes of 'old' position.
1835: --
1836: -- When in validation only mode raise the Validate_Enabled exception
1837: --
1838: if p_validate then
1839: raise hr_api.validate_enabled;
1840: end if;
1841: --
1842: -- Set all out arguments
1843: --
1855: hr_utility.set_location(' Leaving:'||l_proc, 997);
1856: --
1857: exception
1858: --
1859: when hr_api.validate_enabled then
1860: --
1861: -- As the Validate_Enabled exception has been raised
1862: -- we must rollback to the savepoint
1863: --
2073: l_segment1 := to_char(mmasgrec.tax_unit_id);
2074: --
2075: else
2076: --
2077: l_segment1 := hr_api.g_varchar2;
2078: --
2079: end if;
2080: --
2081: if mmasgrec.default_from = 'B' then
2392: --
2393: end loop; -- for mmasgrec in cursor
2394: --
2395: if p_validate then
2396: raise hr_api.validate_enabled;
2397: end if;
2398: --
2399: hr_utility.set_location(' Leaving:'||l_proc, 997);
2400: --
2399: hr_utility.set_location(' Leaving:'||l_proc, 997);
2400: --
2401: exception
2402: --
2403: when hr_api.validate_enabled then
2404: --
2405: -- As the Validate_Enabled exception has been raised
2406: -- we must rollback to the savepoint
2407: --
2487: l_pos_vac_not_moved_warning boolean;
2488:
2489: --
2490: cursor csr_batch_run_number is
2491: select hr_api_batch_message_lines_s.nextval
2492: from dual;
2493: --
2494: cursor csr_lock_per_mass_moves is
2495: select null
2649: -- Check for errors at the end of the mass move
2650: --
2651: cursor csr_chk_errors is
2652: select 'Y'
2653: from hr_api_batch_message_lines
2654: where batch_run_number = l_batch_run_number
2655: and status = 'F';
2656: --
2657: cursor csr_chk_warnings is
2655: and status = 'F';
2656: --
2657: cursor csr_chk_warnings is
2658: select 'Y'
2659: from hr_api_batch_message_lines
2660: where batch_run_number = l_batch_run_number
2661: and status = 'S';
2662: --
2663: begin
2765: (p_mass_move_id => p_mass_move_id
2766: ,p_business_group_id => l_business_group_id
2767: );
2768: exception
2769: when hr_api.cannot_find_prog_unit then
2770: hr_api.cannot_find_prog_unit_error
2771: (p_module_name => 'MASS_MOVE'
2772: ,p_hook_type => 'BP'
2773: );
2766: ,p_business_group_id => l_business_group_id
2767: );
2768: exception
2769: when hr_api.cannot_find_prog_unit then
2770: hr_api.cannot_find_prog_unit_error
2771: (p_module_name => 'MASS_MOVE'
2772: ,p_hook_type => 'BP'
2773: );
2774: --
3175: (p_mass_move_id => p_mass_move_id
3176: ,p_business_group_id => l_business_group_id
3177: );
3178: exception
3179: when hr_api.cannot_find_prog_unit then
3180: hr_api.cannot_find_prog_unit_error
3181: (p_module_name => 'MASS_MOVE'
3182: ,p_hook_type => 'AP'
3183: );
3176: ,p_business_group_id => l_business_group_id
3177: );
3178: exception
3179: when hr_api.cannot_find_prog_unit then
3180: hr_api.cannot_find_prog_unit_error
3181: (p_module_name => 'MASS_MOVE'
3182: ,p_hook_type => 'AP'
3183: );
3184: --
3190: -- When in validation only mode raise the Validate_Enabled exception
3191: --
3192: if p_validate then
3193: --
3194: raise hr_api.validate_enabled;
3195: --
3196: end if;
3197: --
3198: hr_utility.set_location(' Leaving:'||l_proc, 997);
3198: hr_utility.set_location(' Leaving:'||l_proc, 997);
3199: --
3200: exception
3201: --
3202: when hr_api.validate_enabled then
3203: --
3204: hr_utility.set_location(' Leaving:'||l_proc, 998);
3205: --
3206: -- As the Validate_Enabled exception has been raised