46: -- default is false. The validation is controlled by a savepoint and
47: -- rollback mechanism. The savepoint is issued at the beginning of the
48: -- process and is rollbacked at the end of the process
49: -- when all the processing has been completed. The rollback is controlled
50: -- by raising and handling the exception hr_api.validate_enabled. We use
51: -- the exception because, by raising the exception with the
52: -- process, we can exit successfully without having any of the 'OUT'
53: -- parameters being set.
54: -- p_validation_strength
138: -- ----------------------------------------------------------------------------
139: Procedure upd
140: (
141: p_component_id in number,
142: p_approved in varchar2 default hr_api.g_varchar2,
143: p_component_reason in varchar2 default hr_api.g_varchar2,
144: p_change_amount_n in number default hr_api.g_number,
145: p_change_percentage in number default hr_api.g_number,
146: p_comments in varchar2 default hr_api.g_varchar2,
139: Procedure upd
140: (
141: p_component_id in number,
142: p_approved in varchar2 default hr_api.g_varchar2,
143: p_component_reason in varchar2 default hr_api.g_varchar2,
144: p_change_amount_n in number default hr_api.g_number,
145: p_change_percentage in number default hr_api.g_number,
146: p_comments in varchar2 default hr_api.g_varchar2,
147: p_attribute_category in varchar2 default hr_api.g_varchar2,
140: (
141: p_component_id in number,
142: p_approved in varchar2 default hr_api.g_varchar2,
143: p_component_reason in varchar2 default hr_api.g_varchar2,
144: p_change_amount_n in number default hr_api.g_number,
145: p_change_percentage in number default hr_api.g_number,
146: p_comments in varchar2 default hr_api.g_varchar2,
147: p_attribute_category in varchar2 default hr_api.g_varchar2,
148: p_attribute1 in varchar2 default hr_api.g_varchar2,
141: p_component_id in number,
142: p_approved in varchar2 default hr_api.g_varchar2,
143: p_component_reason in varchar2 default hr_api.g_varchar2,
144: p_change_amount_n in number default hr_api.g_number,
145: p_change_percentage in number default hr_api.g_number,
146: p_comments in varchar2 default hr_api.g_varchar2,
147: p_attribute_category in varchar2 default hr_api.g_varchar2,
148: p_attribute1 in varchar2 default hr_api.g_varchar2,
149: p_attribute2 in varchar2 default hr_api.g_varchar2,
142: p_approved in varchar2 default hr_api.g_varchar2,
143: p_component_reason in varchar2 default hr_api.g_varchar2,
144: p_change_amount_n in number default hr_api.g_number,
145: p_change_percentage in number default hr_api.g_number,
146: p_comments in varchar2 default hr_api.g_varchar2,
147: p_attribute_category in varchar2 default hr_api.g_varchar2,
148: p_attribute1 in varchar2 default hr_api.g_varchar2,
149: p_attribute2 in varchar2 default hr_api.g_varchar2,
150: p_attribute3 in varchar2 default hr_api.g_varchar2,
143: p_component_reason in varchar2 default hr_api.g_varchar2,
144: p_change_amount_n in number default hr_api.g_number,
145: p_change_percentage in number default hr_api.g_number,
146: p_comments in varchar2 default hr_api.g_varchar2,
147: p_attribute_category in varchar2 default hr_api.g_varchar2,
148: p_attribute1 in varchar2 default hr_api.g_varchar2,
149: p_attribute2 in varchar2 default hr_api.g_varchar2,
150: p_attribute3 in varchar2 default hr_api.g_varchar2,
151: p_attribute4 in varchar2 default hr_api.g_varchar2,
144: p_change_amount_n in number default hr_api.g_number,
145: p_change_percentage in number default hr_api.g_number,
146: p_comments in varchar2 default hr_api.g_varchar2,
147: p_attribute_category in varchar2 default hr_api.g_varchar2,
148: p_attribute1 in varchar2 default hr_api.g_varchar2,
149: p_attribute2 in varchar2 default hr_api.g_varchar2,
150: p_attribute3 in varchar2 default hr_api.g_varchar2,
151: p_attribute4 in varchar2 default hr_api.g_varchar2,
152: p_attribute5 in varchar2 default hr_api.g_varchar2,
145: p_change_percentage in number default hr_api.g_number,
146: p_comments in varchar2 default hr_api.g_varchar2,
147: p_attribute_category in varchar2 default hr_api.g_varchar2,
148: p_attribute1 in varchar2 default hr_api.g_varchar2,
149: p_attribute2 in varchar2 default hr_api.g_varchar2,
150: p_attribute3 in varchar2 default hr_api.g_varchar2,
151: p_attribute4 in varchar2 default hr_api.g_varchar2,
152: p_attribute5 in varchar2 default hr_api.g_varchar2,
153: p_attribute6 in varchar2 default hr_api.g_varchar2,
146: p_comments in varchar2 default hr_api.g_varchar2,
147: p_attribute_category in varchar2 default hr_api.g_varchar2,
148: p_attribute1 in varchar2 default hr_api.g_varchar2,
149: p_attribute2 in varchar2 default hr_api.g_varchar2,
150: p_attribute3 in varchar2 default hr_api.g_varchar2,
151: p_attribute4 in varchar2 default hr_api.g_varchar2,
152: p_attribute5 in varchar2 default hr_api.g_varchar2,
153: p_attribute6 in varchar2 default hr_api.g_varchar2,
154: p_attribute7 in varchar2 default hr_api.g_varchar2,
147: p_attribute_category in varchar2 default hr_api.g_varchar2,
148: p_attribute1 in varchar2 default hr_api.g_varchar2,
149: p_attribute2 in varchar2 default hr_api.g_varchar2,
150: p_attribute3 in varchar2 default hr_api.g_varchar2,
151: p_attribute4 in varchar2 default hr_api.g_varchar2,
152: p_attribute5 in varchar2 default hr_api.g_varchar2,
153: p_attribute6 in varchar2 default hr_api.g_varchar2,
154: p_attribute7 in varchar2 default hr_api.g_varchar2,
155: p_attribute8 in varchar2 default hr_api.g_varchar2,
148: p_attribute1 in varchar2 default hr_api.g_varchar2,
149: p_attribute2 in varchar2 default hr_api.g_varchar2,
150: p_attribute3 in varchar2 default hr_api.g_varchar2,
151: p_attribute4 in varchar2 default hr_api.g_varchar2,
152: p_attribute5 in varchar2 default hr_api.g_varchar2,
153: p_attribute6 in varchar2 default hr_api.g_varchar2,
154: p_attribute7 in varchar2 default hr_api.g_varchar2,
155: p_attribute8 in varchar2 default hr_api.g_varchar2,
156: p_attribute9 in varchar2 default hr_api.g_varchar2,
149: p_attribute2 in varchar2 default hr_api.g_varchar2,
150: p_attribute3 in varchar2 default hr_api.g_varchar2,
151: p_attribute4 in varchar2 default hr_api.g_varchar2,
152: p_attribute5 in varchar2 default hr_api.g_varchar2,
153: p_attribute6 in varchar2 default hr_api.g_varchar2,
154: p_attribute7 in varchar2 default hr_api.g_varchar2,
155: p_attribute8 in varchar2 default hr_api.g_varchar2,
156: p_attribute9 in varchar2 default hr_api.g_varchar2,
157: p_attribute10 in varchar2 default hr_api.g_varchar2,
150: p_attribute3 in varchar2 default hr_api.g_varchar2,
151: p_attribute4 in varchar2 default hr_api.g_varchar2,
152: p_attribute5 in varchar2 default hr_api.g_varchar2,
153: p_attribute6 in varchar2 default hr_api.g_varchar2,
154: p_attribute7 in varchar2 default hr_api.g_varchar2,
155: p_attribute8 in varchar2 default hr_api.g_varchar2,
156: p_attribute9 in varchar2 default hr_api.g_varchar2,
157: p_attribute10 in varchar2 default hr_api.g_varchar2,
158: p_attribute11 in varchar2 default hr_api.g_varchar2,
151: p_attribute4 in varchar2 default hr_api.g_varchar2,
152: p_attribute5 in varchar2 default hr_api.g_varchar2,
153: p_attribute6 in varchar2 default hr_api.g_varchar2,
154: p_attribute7 in varchar2 default hr_api.g_varchar2,
155: p_attribute8 in varchar2 default hr_api.g_varchar2,
156: p_attribute9 in varchar2 default hr_api.g_varchar2,
157: p_attribute10 in varchar2 default hr_api.g_varchar2,
158: p_attribute11 in varchar2 default hr_api.g_varchar2,
159: p_attribute12 in varchar2 default hr_api.g_varchar2,
152: p_attribute5 in varchar2 default hr_api.g_varchar2,
153: p_attribute6 in varchar2 default hr_api.g_varchar2,
154: p_attribute7 in varchar2 default hr_api.g_varchar2,
155: p_attribute8 in varchar2 default hr_api.g_varchar2,
156: p_attribute9 in varchar2 default hr_api.g_varchar2,
157: p_attribute10 in varchar2 default hr_api.g_varchar2,
158: p_attribute11 in varchar2 default hr_api.g_varchar2,
159: p_attribute12 in varchar2 default hr_api.g_varchar2,
160: p_attribute13 in varchar2 default hr_api.g_varchar2,
153: p_attribute6 in varchar2 default hr_api.g_varchar2,
154: p_attribute7 in varchar2 default hr_api.g_varchar2,
155: p_attribute8 in varchar2 default hr_api.g_varchar2,
156: p_attribute9 in varchar2 default hr_api.g_varchar2,
157: p_attribute10 in varchar2 default hr_api.g_varchar2,
158: p_attribute11 in varchar2 default hr_api.g_varchar2,
159: p_attribute12 in varchar2 default hr_api.g_varchar2,
160: p_attribute13 in varchar2 default hr_api.g_varchar2,
161: p_attribute14 in varchar2 default hr_api.g_varchar2,
154: p_attribute7 in varchar2 default hr_api.g_varchar2,
155: p_attribute8 in varchar2 default hr_api.g_varchar2,
156: p_attribute9 in varchar2 default hr_api.g_varchar2,
157: p_attribute10 in varchar2 default hr_api.g_varchar2,
158: p_attribute11 in varchar2 default hr_api.g_varchar2,
159: p_attribute12 in varchar2 default hr_api.g_varchar2,
160: p_attribute13 in varchar2 default hr_api.g_varchar2,
161: p_attribute14 in varchar2 default hr_api.g_varchar2,
162: p_attribute15 in varchar2 default hr_api.g_varchar2,
155: p_attribute8 in varchar2 default hr_api.g_varchar2,
156: p_attribute9 in varchar2 default hr_api.g_varchar2,
157: p_attribute10 in varchar2 default hr_api.g_varchar2,
158: p_attribute11 in varchar2 default hr_api.g_varchar2,
159: p_attribute12 in varchar2 default hr_api.g_varchar2,
160: p_attribute13 in varchar2 default hr_api.g_varchar2,
161: p_attribute14 in varchar2 default hr_api.g_varchar2,
162: p_attribute15 in varchar2 default hr_api.g_varchar2,
163: p_attribute16 in varchar2 default hr_api.g_varchar2,
156: p_attribute9 in varchar2 default hr_api.g_varchar2,
157: p_attribute10 in varchar2 default hr_api.g_varchar2,
158: p_attribute11 in varchar2 default hr_api.g_varchar2,
159: p_attribute12 in varchar2 default hr_api.g_varchar2,
160: p_attribute13 in varchar2 default hr_api.g_varchar2,
161: p_attribute14 in varchar2 default hr_api.g_varchar2,
162: p_attribute15 in varchar2 default hr_api.g_varchar2,
163: p_attribute16 in varchar2 default hr_api.g_varchar2,
164: p_attribute17 in varchar2 default hr_api.g_varchar2,
157: p_attribute10 in varchar2 default hr_api.g_varchar2,
158: p_attribute11 in varchar2 default hr_api.g_varchar2,
159: p_attribute12 in varchar2 default hr_api.g_varchar2,
160: p_attribute13 in varchar2 default hr_api.g_varchar2,
161: p_attribute14 in varchar2 default hr_api.g_varchar2,
162: p_attribute15 in varchar2 default hr_api.g_varchar2,
163: p_attribute16 in varchar2 default hr_api.g_varchar2,
164: p_attribute17 in varchar2 default hr_api.g_varchar2,
165: p_attribute18 in varchar2 default hr_api.g_varchar2,
158: p_attribute11 in varchar2 default hr_api.g_varchar2,
159: p_attribute12 in varchar2 default hr_api.g_varchar2,
160: p_attribute13 in varchar2 default hr_api.g_varchar2,
161: p_attribute14 in varchar2 default hr_api.g_varchar2,
162: p_attribute15 in varchar2 default hr_api.g_varchar2,
163: p_attribute16 in varchar2 default hr_api.g_varchar2,
164: p_attribute17 in varchar2 default hr_api.g_varchar2,
165: p_attribute18 in varchar2 default hr_api.g_varchar2,
166: p_attribute19 in varchar2 default hr_api.g_varchar2,
159: p_attribute12 in varchar2 default hr_api.g_varchar2,
160: p_attribute13 in varchar2 default hr_api.g_varchar2,
161: p_attribute14 in varchar2 default hr_api.g_varchar2,
162: p_attribute15 in varchar2 default hr_api.g_varchar2,
163: p_attribute16 in varchar2 default hr_api.g_varchar2,
164: p_attribute17 in varchar2 default hr_api.g_varchar2,
165: p_attribute18 in varchar2 default hr_api.g_varchar2,
166: p_attribute19 in varchar2 default hr_api.g_varchar2,
167: p_attribute20 in varchar2 default hr_api.g_varchar2,
160: p_attribute13 in varchar2 default hr_api.g_varchar2,
161: p_attribute14 in varchar2 default hr_api.g_varchar2,
162: p_attribute15 in varchar2 default hr_api.g_varchar2,
163: p_attribute16 in varchar2 default hr_api.g_varchar2,
164: p_attribute17 in varchar2 default hr_api.g_varchar2,
165: p_attribute18 in varchar2 default hr_api.g_varchar2,
166: p_attribute19 in varchar2 default hr_api.g_varchar2,
167: p_attribute20 in varchar2 default hr_api.g_varchar2,
168: p_object_version_number in out nocopy number,
161: p_attribute14 in varchar2 default hr_api.g_varchar2,
162: p_attribute15 in varchar2 default hr_api.g_varchar2,
163: p_attribute16 in varchar2 default hr_api.g_varchar2,
164: p_attribute17 in varchar2 default hr_api.g_varchar2,
165: p_attribute18 in varchar2 default hr_api.g_varchar2,
166: p_attribute19 in varchar2 default hr_api.g_varchar2,
167: p_attribute20 in varchar2 default hr_api.g_varchar2,
168: p_object_version_number in out nocopy number,
169: p_validation_strength in varchar2 default 'STRONG',
162: p_attribute15 in varchar2 default hr_api.g_varchar2,
163: p_attribute16 in varchar2 default hr_api.g_varchar2,
164: p_attribute17 in varchar2 default hr_api.g_varchar2,
165: p_attribute18 in varchar2 default hr_api.g_varchar2,
166: p_attribute19 in varchar2 default hr_api.g_varchar2,
167: p_attribute20 in varchar2 default hr_api.g_varchar2,
168: p_object_version_number in out nocopy number,
169: p_validation_strength in varchar2 default 'STRONG',
170: p_validate in boolean default false
163: p_attribute16 in varchar2 default hr_api.g_varchar2,
164: p_attribute17 in varchar2 default hr_api.g_varchar2,
165: p_attribute18 in varchar2 default hr_api.g_varchar2,
166: p_attribute19 in varchar2 default hr_api.g_varchar2,
167: p_attribute20 in varchar2 default hr_api.g_varchar2,
168: p_object_version_number in out nocopy number,
169: p_validation_strength in varchar2 default 'STRONG',
170: p_validate in boolean default false
171: );