eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_MASS_MOVE_API dependencies on HR_API

Line 18: ,p_grade_id IN NUMBER DEFAULT HR_API.G_NUMBER

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

Line 19: ,p_position_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

Line 20: ,p_job_id IN NUMBER DEFAULT HR_API.G_NUMBER

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

Line 21: ,p_location_id IN NUMBER DEFAULT HR_API.G_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
25: ,p_effective_end_date OUT NOCOPY DATE

Line 22: ,p_organization_id IN NUMBER DEFAULT HR_API.G_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
26: ,p_people_group_id OUT NOCOPY NUMBER

Line 83: WHEN hr_api.validate_enabled THEN

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

Line 138: ,p_mass_move_id in number default hr_api.g_number

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

Line 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

Line 143: ,p_position_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

Line 144: ,p_job_id in number default hr_api.g_number

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

Line 145: ,p_organization_id 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

Line 146: ,p_location_id in number default hr_api.g_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
150: ,p_time_normal_start in varchar2 default hr_api.g_varchar2

Line 147: ,p_frequency 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

Line 148: ,p_normal_hours 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
152: ,p_segment2 in varchar2 default hr_api.g_varchar2

Line 149: ,p_time_normal_finish 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

Line 150: ,p_time_normal_start 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

Line 151: ,p_segment1 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

Line 152: ,p_segment2 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

Line 153: ,p_segment3 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

Line 154: ,p_segment4 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

Line 155: ,p_segment5 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

Line 156: ,p_segment6 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

Line 157: ,p_segment7 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

Line 158: ,p_segment8 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

Line 159: ,p_segment9 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

Line 160: ,p_segment10 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

Line 161: ,p_segment11 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

Line 162: ,p_segment12 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

Line 163: ,p_segment13 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

Line 164: ,p_segment14 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

Line 165: ,p_segment15 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

Line 166: ,p_segment16 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

Line 167: ,p_segment17 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

Line 168: ,p_segment18 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

Line 169: ,p_segment19 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

Line 170: ,p_segment20 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

Line 171: ,p_segment21 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

Line 172: ,p_segment22 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

Line 173: ,p_segment23 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

Line 174: ,p_segment24 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

Line 175: ,p_segment25 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

Line 176: ,p_segment26 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

Line 177: ,p_segment27 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

Line 178: ,p_segment28 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
182: ,p_effective_start_date out nocopy date

Line 179: ,p_segment29 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
183: ,p_effective_end_date out nocopy date

Line 180: ,p_segment30 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
184: ,p_concatenated_segments out nocopy varchar2

Line 198: l_special_ceiling_step_id number(15) default hr_api.g_number;

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;

Line 251: if ( ( (nvl(p_organization_id, hr_api.g_number) <> hr_api.g_number )

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

Line 252: and nvl(per_asg_shd.g_old_rec.organization_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 )

Line 253: nvl(p_organization_id, 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) <>

Line 254: or ( (nvl(p_position_id, hr_api.g_number) <> 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) )

Line 255: and nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <> nvl(p_position_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 )

Line 256: or ( (nvl(p_grade_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) <>

Line 257: and nvl(per_asg_shd.g_old_rec.grade_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

Line 258: nvl(p_grade_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
262: null;

Line 259: or ( ( nvl(p_location_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;
263: else

Line 260: and nvl(per_asg_shd.g_old_rec.location_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
264: hr_utility.set_message(801, 'HR_51104_MMV_MUST_UPD_ASG');

Line 261: nvl(p_location_id, hr_api.g_number) ) ) then

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;

Line 373: if ( ( (nvl(p_segment1, hr_api.g_varchar2) <> hr_api.g_varchar2)

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

Line 374: and nvl(hr_scl_shd.g_old_rec.segment1, 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) )

Line 375: nvl(p_segment1, 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)

Line 376: or ( (nvl(p_segment2, 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) <>

Line 377: and nvl(hr_scl_shd.g_old_rec.segment2, 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) )

Line 378: nvl(p_segment2, 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)

Line 379: or ( (nvl(p_segment3, 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) <>

Line 380: and nvl(hr_scl_shd.g_old_rec.segment3, 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) )

Line 381: nvl(p_segment3, 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)

Line 382: or ( (nvl(p_segment4, 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) <>

Line 383: and nvl(hr_scl_shd.g_old_rec.segment4, 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) )

Line 384: nvl(p_segment4, 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)

Line 385: or ( (nvl(p_segment5, 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) <>

Line 386: and nvl(hr_scl_shd.g_old_rec.segment5, 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) )

Line 387: nvl(p_segment5, 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)

Line 388: or ( (nvl(p_segment6, 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) <>

Line 389: and nvl(hr_scl_shd.g_old_rec.segment6, 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) )

Line 390: nvl(p_segment6, 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)

Line 391: or ( (nvl(p_segment7, 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) <>

Line 392: and nvl(hr_scl_shd.g_old_rec.segment7, 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) )

Line 393: nvl(p_segment7, 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)

Line 394: or ( (nvl(p_segment8, 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) <>

Line 395: and nvl(hr_scl_shd.g_old_rec.segment8, 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) )

Line 396: nvl(p_segment8, 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)

Line 397: or ( (nvl(p_segment9, 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) <>

Line 398: and nvl(hr_scl_shd.g_old_rec.segment9, 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) )

Line 399: nvl(p_segment9, 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)

Line 400: or ( (nvl(p_segment10, 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) <>

Line 401: and nvl(hr_scl_shd.g_old_rec.segment10, 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) )

Line 402: nvl(p_segment10, 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)

Line 403: or ( (nvl(p_segment11, 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) <>

Line 404: and nvl(hr_scl_shd.g_old_rec.segment11, 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) )

Line 405: nvl(p_segment11, 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)

Line 406: or ( (nvl(p_segment12, 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) <>

Line 407: and nvl(hr_scl_shd.g_old_rec.segment12, 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) )

Line 408: nvl(p_segment12, 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)

Line 409: or ( (nvl(p_segment13, 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) <>

Line 410: and nvl(hr_scl_shd.g_old_rec.segment13, 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) )

Line 411: nvl(p_segment13, 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)

Line 412: or ( (nvl(p_segment14, 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) <>

Line 413: and nvl(hr_scl_shd.g_old_rec.segment14, 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) )

Line 414: nvl(p_segment14, 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)

Line 415: or ( (nvl(p_segment15, 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) <>

Line 416: and nvl(hr_scl_shd.g_old_rec.segment15, 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) )

Line 417: nvl(p_segment15, 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)

Line 418: or ( (nvl(p_segment16, 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) <>

Line 419: and nvl(hr_scl_shd.g_old_rec.segment16, 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) )

Line 420: nvl(p_segment16, 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)

Line 421: or ( (nvl(p_segment17, 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) <>

Line 422: and nvl(hr_scl_shd.g_old_rec.segment17, 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) )

Line 423: nvl(p_segment17, 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)

Line 424: or ( (nvl(p_segment18, 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) <>

Line 425: and nvl(hr_scl_shd.g_old_rec.segment18, 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) )

Line 426: nvl(p_segment18, 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)

Line 427: or ( (nvl(p_segment19, 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) <>

Line 428: and nvl(hr_scl_shd.g_old_rec.segment19, 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) )

Line 429: nvl(p_segment19, 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)

Line 430: or ( (nvl(p_segment20, 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) <>

Line 431: and nvl(hr_scl_shd.g_old_rec.segment20, 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) )

Line 432: nvl(p_segment20, 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)

Line 433: or ( (nvl(p_segment21, 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) <>

Line 434: and nvl(hr_scl_shd.g_old_rec.segment21, 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) )

Line 435: nvl(p_segment21, 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)

Line 436: or ( (nvl(p_segment22, 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) <>

Line 437: and nvl(hr_scl_shd.g_old_rec.segment22, 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) )

Line 438: nvl(p_segment22, 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)

Line 439: or ( (nvl(p_segment23, 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) <>

Line 440: and nvl(hr_scl_shd.g_old_rec.segment23, 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) )

Line 441: nvl(p_segment23, 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)

Line 442: or ( (nvl(p_segment24, 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) <>

Line 443: and nvl(hr_scl_shd.g_old_rec.segment24, 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) )

Line 444: nvl(p_segment24, 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)

Line 445: or ( (nvl(p_segment25, 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) <>

Line 446: and nvl(hr_scl_shd.g_old_rec.segment25, 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) )

Line 447: nvl(p_segment25, 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)

Line 448: or ( (nvl(p_segment26, 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) <>

Line 449: and nvl(hr_scl_shd.g_old_rec.segment26, 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) )

Line 450: nvl(p_segment26, 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)

Line 451: or ( (nvl(p_segment27, 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) <>

Line 452: and nvl(hr_scl_shd.g_old_rec.segment27, 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) )

Line 453: nvl(p_segment27, 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)

Line 454: or ( (nvl(p_segment28, 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) <>

Line 455: and nvl(hr_scl_shd.g_old_rec.segment28, 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) )

Line 456: nvl(p_segment28, 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)

Line 457: or ( (nvl(p_segment29, 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) <>

Line 458: and nvl(hr_scl_shd.g_old_rec.segment29, 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) )

Line 459: nvl(p_segment29, 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

Line 460: or ( (nvl(p_segment30, hr_api.g_varchar2) <> 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
464: --

Line 461: and nvl(hr_scl_shd.g_old_rec.segment30, 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: --
465: hr_utility.set_location( l_proc, 60 );

Line 462: nvl(p_segment30, 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 );
466: --

Line 483: if nvl(p_segment1, hr_api.g_varchar2) <> hr_api.g_varchar2

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

Line 484: or nvl(p_segment2, 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

Line 485: or nvl(p_segment3, 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

Line 486: or nvl(p_segment4, 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

Line 487: or nvl(p_segment5, 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

Line 488: or nvl(p_segment6, 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

Line 489: or nvl(p_segment7, 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

Line 490: or nvl(p_segment8, 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

Line 491: or nvl(p_segment9, 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

Line 492: or nvl(p_segment10, 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

Line 493: or nvl(p_segment11, 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

Line 494: or nvl(p_segment12, 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

Line 495: or nvl(p_segment13, 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

Line 496: or nvl(p_segment14, 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

Line 497: or nvl(p_segment15, 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

Line 498: or nvl(p_segment16, 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

Line 499: or nvl(p_segment17, 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

Line 500: or nvl(p_segment18, 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

Line 501: or nvl(p_segment19, 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

Line 502: or nvl(p_segment20, 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

Line 503: or nvl(p_segment21, 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

Line 504: or nvl(p_segment22, 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

Line 505: or nvl(p_segment23, 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

Line 506: or nvl(p_segment24, 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

Line 507: or nvl(p_segment25, 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

Line 508: or nvl(p_segment26, 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

Line 509: or nvl(p_segment27, 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
513: --

Line 510: or nvl(p_segment28, 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: --
514: hr_utility.set_location( l_proc, 75 );

Line 511: or nvl(p_segment29, 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 );
515: --

Line 512: or nvl(p_segment30, hr_api.g_varchar2) <> hr_api.g_varchar2 then

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;

Line 528: or ((nvl(p_frequency, hr_api.g_varchar2) <> hr_api.g_varchar2)

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

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

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

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

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)

Line 531: or ((nvl(p_normal_hours, hr_api.g_number) <> hr_api.g_number)

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

Line 532: and nvl(per_asg_shd.g_old_rec.normal_hours, hr_api.g_number) <>

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

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

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)

Line 534: or ((nvl(p_time_normal_finish, 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) <>

Line 535: and nvl(per_asg_shd.g_old_rec.time_normal_finish,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) )

Line 536: nvl(p_time_normal_finish,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

Line 537: or ((nvl(p_time_normal_start, hr_api.g_varchar2) <> hr_api.g_varchar2)

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

Line 538: and nvl(per_asg_shd.g_old_rec.time_normal_start, hr_api.g_varchar2) <>

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

Line 539: nvl(p_time_normal_start, 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 );
543: --

Line 616: raise hr_api.validate_enabled;

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;

Line 633: when hr_api.validate_enabled then

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

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

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

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

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.

Line 1841: raise hr_api.validate_enabled;

1837: --
1838: -- When in validation only mode raise the Validate_Enabled exception
1839: --
1840: if p_validate then
1841: raise hr_api.validate_enabled;
1842: end if;
1843: --
1844: -- Set all out arguments
1845: --

Line 1861: when hr_api.validate_enabled then

1857: hr_utility.set_location(' Leaving:'||l_proc, 997);
1858: --
1859: exception
1860: --
1861: when hr_api.validate_enabled then
1862: --
1863: -- As the Validate_Enabled exception has been raised
1864: -- we must rollback to the savepoint
1865: --

Line 2079: l_segment1 := hr_api.g_varchar2;

2075: l_segment1 := to_char(mmasgrec.tax_unit_id);
2076: --
2077: else
2078: --
2079: l_segment1 := hr_api.g_varchar2;
2080: --
2081: end if;
2082: --
2083: if mmasgrec.default_from = 'B' then

Line 2398: raise hr_api.validate_enabled;

2394: --
2395: end loop; -- for mmasgrec in cursor
2396: --
2397: if p_validate then
2398: raise hr_api.validate_enabled;
2399: end if;
2400: --
2401: hr_utility.set_location(' Leaving:'||l_proc, 997);
2402: --

Line 2405: when hr_api.validate_enabled then

2401: hr_utility.set_location(' Leaving:'||l_proc, 997);
2402: --
2403: exception
2404: --
2405: when hr_api.validate_enabled then
2406: --
2407: -- As the Validate_Enabled exception has been raised
2408: -- we must rollback to the savepoint
2409: --

Line 2493: select hr_api_batch_message_lines_s.nextval

2489: l_pos_vac_not_moved_warning boolean;
2490:
2491: --
2492: cursor csr_batch_run_number is
2493: select hr_api_batch_message_lines_s.nextval
2494: from dual;
2495: --
2496: cursor csr_lock_per_mass_moves is
2497: select null

Line 2655: from hr_api_batch_message_lines

2651: -- Check for errors at the end of the mass move
2652: --
2653: cursor csr_chk_errors is
2654: select 'Y'
2655: from hr_api_batch_message_lines
2656: where batch_run_number = l_batch_run_number
2657: and status = 'F';
2658: --
2659: cursor csr_chk_warnings is

Line 2661: from hr_api_batch_message_lines

2657: and status = 'F';
2658: --
2659: cursor csr_chk_warnings is
2660: select 'Y'
2661: from hr_api_batch_message_lines
2662: where batch_run_number = l_batch_run_number
2663: and status = 'S';
2664: --
2665: begin

Line 2771: when hr_api.cannot_find_prog_unit then

2767: (p_mass_move_id => p_mass_move_id
2768: ,p_business_group_id => l_business_group_id
2769: );
2770: exception
2771: when hr_api.cannot_find_prog_unit then
2772: hr_api.cannot_find_prog_unit_error
2773: (p_module_name => 'MASS_MOVE'
2774: ,p_hook_type => 'BP'
2775: );

Line 2772: hr_api.cannot_find_prog_unit_error

2768: ,p_business_group_id => l_business_group_id
2769: );
2770: exception
2771: when hr_api.cannot_find_prog_unit then
2772: hr_api.cannot_find_prog_unit_error
2773: (p_module_name => 'MASS_MOVE'
2774: ,p_hook_type => 'BP'
2775: );
2776: --

Line 3187: when hr_api.cannot_find_prog_unit then

3183: (p_mass_move_id => p_mass_move_id
3184: ,p_business_group_id => l_business_group_id
3185: );
3186: exception
3187: when hr_api.cannot_find_prog_unit then
3188: hr_api.cannot_find_prog_unit_error
3189: (p_module_name => 'MASS_MOVE'
3190: ,p_hook_type => 'AP'
3191: );

Line 3188: hr_api.cannot_find_prog_unit_error

3184: ,p_business_group_id => l_business_group_id
3185: );
3186: exception
3187: when hr_api.cannot_find_prog_unit then
3188: hr_api.cannot_find_prog_unit_error
3189: (p_module_name => 'MASS_MOVE'
3190: ,p_hook_type => 'AP'
3191: );
3192: --

Line 3202: raise hr_api.validate_enabled;

3198: -- When in validation only mode raise the Validate_Enabled exception
3199: --
3200: if p_validate then
3201: --
3202: raise hr_api.validate_enabled;
3203: --
3204: end if;
3205: --
3206: hr_utility.set_location(' Leaving:'||l_proc, 997);

Line 3210: when hr_api.validate_enabled then

3206: hr_utility.set_location(' Leaving:'||l_proc, 997);
3207: --
3208: exception
3209: --
3210: when hr_api.validate_enabled then
3211: --
3212: hr_utility.set_location(' Leaving:'||l_proc, 998);
3213: --
3214: -- As the Validate_Enabled exception has been raised