213: --
214: procedure update_assessment
215: (
216: p_assessment_id in number,
217: p_assessment_type_id in number default hr_api.g_number,
218: p_assessment_group_id in number default hr_api.g_number,
219: p_assessment_period_start_date in date default hr_api.g_date,
220: p_assessment_period_end_date in date default hr_api.g_date,
221: p_assessment_date in date default hr_api.g_date,
214: procedure update_assessment
215: (
216: p_assessment_id in number,
217: p_assessment_type_id in number default hr_api.g_number,
218: p_assessment_group_id in number default hr_api.g_number,
219: p_assessment_period_start_date in date default hr_api.g_date,
220: p_assessment_period_end_date in date default hr_api.g_date,
221: p_assessment_date in date default hr_api.g_date,
222: p_comments in varchar2 default hr_api.g_varchar2,
215: (
216: p_assessment_id in number,
217: p_assessment_type_id in number default hr_api.g_number,
218: p_assessment_group_id in number default hr_api.g_number,
219: p_assessment_period_start_date in date default hr_api.g_date,
220: p_assessment_period_end_date in date default hr_api.g_date,
221: p_assessment_date in date default hr_api.g_date,
222: p_comments in varchar2 default hr_api.g_varchar2,
223: p_total_score in number default hr_api.g_number,
216: p_assessment_id in number,
217: p_assessment_type_id in number default hr_api.g_number,
218: p_assessment_group_id in number default hr_api.g_number,
219: p_assessment_period_start_date in date default hr_api.g_date,
220: p_assessment_period_end_date in date default hr_api.g_date,
221: p_assessment_date in date default hr_api.g_date,
222: p_comments in varchar2 default hr_api.g_varchar2,
223: p_total_score in number default hr_api.g_number,
224: p_status in varchar2 default hr_api.g_varchar2,
217: p_assessment_type_id in number default hr_api.g_number,
218: p_assessment_group_id in number default hr_api.g_number,
219: p_assessment_period_start_date in date default hr_api.g_date,
220: p_assessment_period_end_date in date default hr_api.g_date,
221: p_assessment_date in date default hr_api.g_date,
222: p_comments in varchar2 default hr_api.g_varchar2,
223: p_total_score in number default hr_api.g_number,
224: p_status in varchar2 default hr_api.g_varchar2,
225: --
218: p_assessment_group_id in number default hr_api.g_number,
219: p_assessment_period_start_date in date default hr_api.g_date,
220: p_assessment_period_end_date in date default hr_api.g_date,
221: p_assessment_date in date default hr_api.g_date,
222: p_comments in varchar2 default hr_api.g_varchar2,
223: p_total_score in number default hr_api.g_number,
224: p_status in varchar2 default hr_api.g_varchar2,
225: --
226: p_attribute_category in varchar2 default hr_api.g_varchar2,
219: p_assessment_period_start_date in date default hr_api.g_date,
220: p_assessment_period_end_date in date default hr_api.g_date,
221: p_assessment_date in date default hr_api.g_date,
222: p_comments in varchar2 default hr_api.g_varchar2,
223: p_total_score in number default hr_api.g_number,
224: p_status in varchar2 default hr_api.g_varchar2,
225: --
226: p_attribute_category in varchar2 default hr_api.g_varchar2,
227: p_attribute1 in varchar2 default hr_api.g_varchar2,
220: p_assessment_period_end_date in date default hr_api.g_date,
221: p_assessment_date in date default hr_api.g_date,
222: p_comments in varchar2 default hr_api.g_varchar2,
223: p_total_score in number default hr_api.g_number,
224: p_status in varchar2 default hr_api.g_varchar2,
225: --
226: p_attribute_category in varchar2 default hr_api.g_varchar2,
227: p_attribute1 in varchar2 default hr_api.g_varchar2,
228: p_attribute2 in varchar2 default hr_api.g_varchar2,
222: p_comments in varchar2 default hr_api.g_varchar2,
223: p_total_score in number default hr_api.g_number,
224: p_status in varchar2 default hr_api.g_varchar2,
225: --
226: p_attribute_category in varchar2 default hr_api.g_varchar2,
227: p_attribute1 in varchar2 default hr_api.g_varchar2,
228: p_attribute2 in varchar2 default hr_api.g_varchar2,
229: p_attribute3 in varchar2 default hr_api.g_varchar2,
230: p_attribute4 in varchar2 default hr_api.g_varchar2,
223: p_total_score in number default hr_api.g_number,
224: p_status in varchar2 default hr_api.g_varchar2,
225: --
226: p_attribute_category in varchar2 default hr_api.g_varchar2,
227: p_attribute1 in varchar2 default hr_api.g_varchar2,
228: p_attribute2 in varchar2 default hr_api.g_varchar2,
229: p_attribute3 in varchar2 default hr_api.g_varchar2,
230: p_attribute4 in varchar2 default hr_api.g_varchar2,
231: p_attribute5 in varchar2 default hr_api.g_varchar2,
224: p_status in varchar2 default hr_api.g_varchar2,
225: --
226: p_attribute_category in varchar2 default hr_api.g_varchar2,
227: p_attribute1 in varchar2 default hr_api.g_varchar2,
228: p_attribute2 in varchar2 default hr_api.g_varchar2,
229: p_attribute3 in varchar2 default hr_api.g_varchar2,
230: p_attribute4 in varchar2 default hr_api.g_varchar2,
231: p_attribute5 in varchar2 default hr_api.g_varchar2,
232: p_attribute6 in varchar2 default hr_api.g_varchar2,
225: --
226: p_attribute_category in varchar2 default hr_api.g_varchar2,
227: p_attribute1 in varchar2 default hr_api.g_varchar2,
228: p_attribute2 in varchar2 default hr_api.g_varchar2,
229: p_attribute3 in varchar2 default hr_api.g_varchar2,
230: p_attribute4 in varchar2 default hr_api.g_varchar2,
231: p_attribute5 in varchar2 default hr_api.g_varchar2,
232: p_attribute6 in varchar2 default hr_api.g_varchar2,
233: p_attribute7 in varchar2 default hr_api.g_varchar2,
226: p_attribute_category in varchar2 default hr_api.g_varchar2,
227: p_attribute1 in varchar2 default hr_api.g_varchar2,
228: p_attribute2 in varchar2 default hr_api.g_varchar2,
229: p_attribute3 in varchar2 default hr_api.g_varchar2,
230: p_attribute4 in varchar2 default hr_api.g_varchar2,
231: p_attribute5 in varchar2 default hr_api.g_varchar2,
232: p_attribute6 in varchar2 default hr_api.g_varchar2,
233: p_attribute7 in varchar2 default hr_api.g_varchar2,
234: p_attribute8 in varchar2 default hr_api.g_varchar2,
227: p_attribute1 in varchar2 default hr_api.g_varchar2,
228: p_attribute2 in varchar2 default hr_api.g_varchar2,
229: p_attribute3 in varchar2 default hr_api.g_varchar2,
230: p_attribute4 in varchar2 default hr_api.g_varchar2,
231: p_attribute5 in varchar2 default hr_api.g_varchar2,
232: p_attribute6 in varchar2 default hr_api.g_varchar2,
233: p_attribute7 in varchar2 default hr_api.g_varchar2,
234: p_attribute8 in varchar2 default hr_api.g_varchar2,
235: p_attribute9 in varchar2 default hr_api.g_varchar2,
228: p_attribute2 in varchar2 default hr_api.g_varchar2,
229: p_attribute3 in varchar2 default hr_api.g_varchar2,
230: p_attribute4 in varchar2 default hr_api.g_varchar2,
231: p_attribute5 in varchar2 default hr_api.g_varchar2,
232: p_attribute6 in varchar2 default hr_api.g_varchar2,
233: p_attribute7 in varchar2 default hr_api.g_varchar2,
234: p_attribute8 in varchar2 default hr_api.g_varchar2,
235: p_attribute9 in varchar2 default hr_api.g_varchar2,
236: p_attribute10 in varchar2 default hr_api.g_varchar2,
229: p_attribute3 in varchar2 default hr_api.g_varchar2,
230: p_attribute4 in varchar2 default hr_api.g_varchar2,
231: p_attribute5 in varchar2 default hr_api.g_varchar2,
232: p_attribute6 in varchar2 default hr_api.g_varchar2,
233: p_attribute7 in varchar2 default hr_api.g_varchar2,
234: p_attribute8 in varchar2 default hr_api.g_varchar2,
235: p_attribute9 in varchar2 default hr_api.g_varchar2,
236: p_attribute10 in varchar2 default hr_api.g_varchar2,
237: p_attribute11 in varchar2 default hr_api.g_varchar2,
230: p_attribute4 in varchar2 default hr_api.g_varchar2,
231: p_attribute5 in varchar2 default hr_api.g_varchar2,
232: p_attribute6 in varchar2 default hr_api.g_varchar2,
233: p_attribute7 in varchar2 default hr_api.g_varchar2,
234: p_attribute8 in varchar2 default hr_api.g_varchar2,
235: p_attribute9 in varchar2 default hr_api.g_varchar2,
236: p_attribute10 in varchar2 default hr_api.g_varchar2,
237: p_attribute11 in varchar2 default hr_api.g_varchar2,
238: p_attribute12 in varchar2 default hr_api.g_varchar2,
231: p_attribute5 in varchar2 default hr_api.g_varchar2,
232: p_attribute6 in varchar2 default hr_api.g_varchar2,
233: p_attribute7 in varchar2 default hr_api.g_varchar2,
234: p_attribute8 in varchar2 default hr_api.g_varchar2,
235: p_attribute9 in varchar2 default hr_api.g_varchar2,
236: p_attribute10 in varchar2 default hr_api.g_varchar2,
237: p_attribute11 in varchar2 default hr_api.g_varchar2,
238: p_attribute12 in varchar2 default hr_api.g_varchar2,
239: p_attribute13 in varchar2 default hr_api.g_varchar2,
232: p_attribute6 in varchar2 default hr_api.g_varchar2,
233: p_attribute7 in varchar2 default hr_api.g_varchar2,
234: p_attribute8 in varchar2 default hr_api.g_varchar2,
235: p_attribute9 in varchar2 default hr_api.g_varchar2,
236: p_attribute10 in varchar2 default hr_api.g_varchar2,
237: p_attribute11 in varchar2 default hr_api.g_varchar2,
238: p_attribute12 in varchar2 default hr_api.g_varchar2,
239: p_attribute13 in varchar2 default hr_api.g_varchar2,
240: p_attribute14 in varchar2 default hr_api.g_varchar2,
233: p_attribute7 in varchar2 default hr_api.g_varchar2,
234: p_attribute8 in varchar2 default hr_api.g_varchar2,
235: p_attribute9 in varchar2 default hr_api.g_varchar2,
236: p_attribute10 in varchar2 default hr_api.g_varchar2,
237: p_attribute11 in varchar2 default hr_api.g_varchar2,
238: p_attribute12 in varchar2 default hr_api.g_varchar2,
239: p_attribute13 in varchar2 default hr_api.g_varchar2,
240: p_attribute14 in varchar2 default hr_api.g_varchar2,
241: p_attribute15 in varchar2 default hr_api.g_varchar2,
234: p_attribute8 in varchar2 default hr_api.g_varchar2,
235: p_attribute9 in varchar2 default hr_api.g_varchar2,
236: p_attribute10 in varchar2 default hr_api.g_varchar2,
237: p_attribute11 in varchar2 default hr_api.g_varchar2,
238: p_attribute12 in varchar2 default hr_api.g_varchar2,
239: p_attribute13 in varchar2 default hr_api.g_varchar2,
240: p_attribute14 in varchar2 default hr_api.g_varchar2,
241: p_attribute15 in varchar2 default hr_api.g_varchar2,
242: p_attribute16 in varchar2 default hr_api.g_varchar2,
235: p_attribute9 in varchar2 default hr_api.g_varchar2,
236: p_attribute10 in varchar2 default hr_api.g_varchar2,
237: p_attribute11 in varchar2 default hr_api.g_varchar2,
238: p_attribute12 in varchar2 default hr_api.g_varchar2,
239: p_attribute13 in varchar2 default hr_api.g_varchar2,
240: p_attribute14 in varchar2 default hr_api.g_varchar2,
241: p_attribute15 in varchar2 default hr_api.g_varchar2,
242: p_attribute16 in varchar2 default hr_api.g_varchar2,
243: p_attribute17 in varchar2 default hr_api.g_varchar2,
236: p_attribute10 in varchar2 default hr_api.g_varchar2,
237: p_attribute11 in varchar2 default hr_api.g_varchar2,
238: p_attribute12 in varchar2 default hr_api.g_varchar2,
239: p_attribute13 in varchar2 default hr_api.g_varchar2,
240: p_attribute14 in varchar2 default hr_api.g_varchar2,
241: p_attribute15 in varchar2 default hr_api.g_varchar2,
242: p_attribute16 in varchar2 default hr_api.g_varchar2,
243: p_attribute17 in varchar2 default hr_api.g_varchar2,
244: p_attribute18 in varchar2 default hr_api.g_varchar2,
237: p_attribute11 in varchar2 default hr_api.g_varchar2,
238: p_attribute12 in varchar2 default hr_api.g_varchar2,
239: p_attribute13 in varchar2 default hr_api.g_varchar2,
240: p_attribute14 in varchar2 default hr_api.g_varchar2,
241: p_attribute15 in varchar2 default hr_api.g_varchar2,
242: p_attribute16 in varchar2 default hr_api.g_varchar2,
243: p_attribute17 in varchar2 default hr_api.g_varchar2,
244: p_attribute18 in varchar2 default hr_api.g_varchar2,
245: p_attribute19 in varchar2 default hr_api.g_varchar2,
238: p_attribute12 in varchar2 default hr_api.g_varchar2,
239: p_attribute13 in varchar2 default hr_api.g_varchar2,
240: p_attribute14 in varchar2 default hr_api.g_varchar2,
241: p_attribute15 in varchar2 default hr_api.g_varchar2,
242: p_attribute16 in varchar2 default hr_api.g_varchar2,
243: p_attribute17 in varchar2 default hr_api.g_varchar2,
244: p_attribute18 in varchar2 default hr_api.g_varchar2,
245: p_attribute19 in varchar2 default hr_api.g_varchar2,
246: p_attribute20 in varchar2 default hr_api.g_varchar2,
239: p_attribute13 in varchar2 default hr_api.g_varchar2,
240: p_attribute14 in varchar2 default hr_api.g_varchar2,
241: p_attribute15 in varchar2 default hr_api.g_varchar2,
242: p_attribute16 in varchar2 default hr_api.g_varchar2,
243: p_attribute17 in varchar2 default hr_api.g_varchar2,
244: p_attribute18 in varchar2 default hr_api.g_varchar2,
245: p_attribute19 in varchar2 default hr_api.g_varchar2,
246: p_attribute20 in varchar2 default hr_api.g_varchar2,
247: p_object_version_number in out nocopy number,
240: p_attribute14 in varchar2 default hr_api.g_varchar2,
241: p_attribute15 in varchar2 default hr_api.g_varchar2,
242: p_attribute16 in varchar2 default hr_api.g_varchar2,
243: p_attribute17 in varchar2 default hr_api.g_varchar2,
244: p_attribute18 in varchar2 default hr_api.g_varchar2,
245: p_attribute19 in varchar2 default hr_api.g_varchar2,
246: p_attribute20 in varchar2 default hr_api.g_varchar2,
247: p_object_version_number in out nocopy number,
248: p_validate in boolean default false,
241: p_attribute15 in varchar2 default hr_api.g_varchar2,
242: p_attribute16 in varchar2 default hr_api.g_varchar2,
243: p_attribute17 in varchar2 default hr_api.g_varchar2,
244: p_attribute18 in varchar2 default hr_api.g_varchar2,
245: p_attribute19 in varchar2 default hr_api.g_varchar2,
246: p_attribute20 in varchar2 default hr_api.g_varchar2,
247: p_object_version_number in out nocopy number,
248: p_validate in boolean default false,
249: p_effective_date in date
242: p_attribute16 in varchar2 default hr_api.g_varchar2,
243: p_attribute17 in varchar2 default hr_api.g_varchar2,
244: p_attribute18 in varchar2 default hr_api.g_varchar2,
245: p_attribute19 in varchar2 default hr_api.g_varchar2,
246: p_attribute20 in varchar2 default hr_api.g_varchar2,
247: p_object_version_number in out nocopy number,
248: p_validate in boolean default false,
249: p_effective_date in date
250: );