8: -- ----------------------------------------------------------------------------
9: -- |---------------------------< create_scorecard >---------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_scorecard
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_scorecard_name in varchar2
15: ,p_assignment_id in number
16: ,p_start_date in date
84: --
85: -- Convert constant values to their corresponding boolean value
86: --
87: l_validate :=
88: hr_api.constant_to_boolean
89: (p_constant_value => p_validate);
90: --
91: -- Register Surrogate ID or user key values
92: --
206: -- ----------------------------------------------------------------------------
207: -- |---------------------------< delete_scorecard >---------------------------|
208: -- ----------------------------------------------------------------------------
209: PROCEDURE delete_scorecard
210: (p_validate in number default hr_api.g_false_num
211: ,p_scorecard_id in number
212: ,p_object_version_number in number
213: ,p_return_status out nocopy varchar2
214: ) is
237: --
238: -- Convert constant values to their corresponding boolean value
239: --
240: l_validate :=
241: hr_api.constant_to_boolean
242: (p_constant_value => p_validate);
243: --
244: -- Register Surrogate ID or user key values
245: --
307: -- ----------------------------------------------------------------------------
308: -- |---------------------------< update_scorecard >---------------------------|
309: -- ----------------------------------------------------------------------------
310: PROCEDURE update_scorecard
311: (p_validate in number default hr_api.g_false_num
312: ,p_effective_date in date
313: ,p_scorecard_id in number
314: ,p_object_version_number in out nocopy number
315: ,p_scorecard_name in varchar2 default hr_api.g_varchar2
311: (p_validate in number default hr_api.g_false_num
312: ,p_effective_date in date
313: ,p_scorecard_id in number
314: ,p_object_version_number in out nocopy number
315: ,p_scorecard_name in varchar2 default hr_api.g_varchar2
316: ,p_start_date in date default hr_api.g_date
317: ,p_end_date in date default hr_api.g_date
318: ,p_plan_id in number default hr_api.g_number
319: ,p_attribute_category in varchar2 default hr_api.g_varchar2
312: ,p_effective_date in date
313: ,p_scorecard_id in number
314: ,p_object_version_number in out nocopy number
315: ,p_scorecard_name in varchar2 default hr_api.g_varchar2
316: ,p_start_date in date default hr_api.g_date
317: ,p_end_date in date default hr_api.g_date
318: ,p_plan_id in number default hr_api.g_number
319: ,p_attribute_category in varchar2 default hr_api.g_varchar2
320: ,p_attribute1 in varchar2 default hr_api.g_varchar2
313: ,p_scorecard_id in number
314: ,p_object_version_number in out nocopy number
315: ,p_scorecard_name in varchar2 default hr_api.g_varchar2
316: ,p_start_date in date default hr_api.g_date
317: ,p_end_date in date default hr_api.g_date
318: ,p_plan_id in number default hr_api.g_number
319: ,p_attribute_category in varchar2 default hr_api.g_varchar2
320: ,p_attribute1 in varchar2 default hr_api.g_varchar2
321: ,p_attribute2 in varchar2 default hr_api.g_varchar2
314: ,p_object_version_number in out nocopy number
315: ,p_scorecard_name in varchar2 default hr_api.g_varchar2
316: ,p_start_date in date default hr_api.g_date
317: ,p_end_date in date default hr_api.g_date
318: ,p_plan_id in number default hr_api.g_number
319: ,p_attribute_category in varchar2 default hr_api.g_varchar2
320: ,p_attribute1 in varchar2 default hr_api.g_varchar2
321: ,p_attribute2 in varchar2 default hr_api.g_varchar2
322: ,p_attribute3 in varchar2 default hr_api.g_varchar2
315: ,p_scorecard_name in varchar2 default hr_api.g_varchar2
316: ,p_start_date in date default hr_api.g_date
317: ,p_end_date in date default hr_api.g_date
318: ,p_plan_id in number default hr_api.g_number
319: ,p_attribute_category in varchar2 default hr_api.g_varchar2
320: ,p_attribute1 in varchar2 default hr_api.g_varchar2
321: ,p_attribute2 in varchar2 default hr_api.g_varchar2
322: ,p_attribute3 in varchar2 default hr_api.g_varchar2
323: ,p_attribute4 in varchar2 default hr_api.g_varchar2
316: ,p_start_date in date default hr_api.g_date
317: ,p_end_date in date default hr_api.g_date
318: ,p_plan_id in number default hr_api.g_number
319: ,p_attribute_category in varchar2 default hr_api.g_varchar2
320: ,p_attribute1 in varchar2 default hr_api.g_varchar2
321: ,p_attribute2 in varchar2 default hr_api.g_varchar2
322: ,p_attribute3 in varchar2 default hr_api.g_varchar2
323: ,p_attribute4 in varchar2 default hr_api.g_varchar2
324: ,p_attribute5 in varchar2 default hr_api.g_varchar2
317: ,p_end_date in date default hr_api.g_date
318: ,p_plan_id in number default hr_api.g_number
319: ,p_attribute_category in varchar2 default hr_api.g_varchar2
320: ,p_attribute1 in varchar2 default hr_api.g_varchar2
321: ,p_attribute2 in varchar2 default hr_api.g_varchar2
322: ,p_attribute3 in varchar2 default hr_api.g_varchar2
323: ,p_attribute4 in varchar2 default hr_api.g_varchar2
324: ,p_attribute5 in varchar2 default hr_api.g_varchar2
325: ,p_attribute6 in varchar2 default hr_api.g_varchar2
318: ,p_plan_id in number default hr_api.g_number
319: ,p_attribute_category in varchar2 default hr_api.g_varchar2
320: ,p_attribute1 in varchar2 default hr_api.g_varchar2
321: ,p_attribute2 in varchar2 default hr_api.g_varchar2
322: ,p_attribute3 in varchar2 default hr_api.g_varchar2
323: ,p_attribute4 in varchar2 default hr_api.g_varchar2
324: ,p_attribute5 in varchar2 default hr_api.g_varchar2
325: ,p_attribute6 in varchar2 default hr_api.g_varchar2
326: ,p_attribute7 in varchar2 default hr_api.g_varchar2
319: ,p_attribute_category in varchar2 default hr_api.g_varchar2
320: ,p_attribute1 in varchar2 default hr_api.g_varchar2
321: ,p_attribute2 in varchar2 default hr_api.g_varchar2
322: ,p_attribute3 in varchar2 default hr_api.g_varchar2
323: ,p_attribute4 in varchar2 default hr_api.g_varchar2
324: ,p_attribute5 in varchar2 default hr_api.g_varchar2
325: ,p_attribute6 in varchar2 default hr_api.g_varchar2
326: ,p_attribute7 in varchar2 default hr_api.g_varchar2
327: ,p_attribute8 in varchar2 default hr_api.g_varchar2
320: ,p_attribute1 in varchar2 default hr_api.g_varchar2
321: ,p_attribute2 in varchar2 default hr_api.g_varchar2
322: ,p_attribute3 in varchar2 default hr_api.g_varchar2
323: ,p_attribute4 in varchar2 default hr_api.g_varchar2
324: ,p_attribute5 in varchar2 default hr_api.g_varchar2
325: ,p_attribute6 in varchar2 default hr_api.g_varchar2
326: ,p_attribute7 in varchar2 default hr_api.g_varchar2
327: ,p_attribute8 in varchar2 default hr_api.g_varchar2
328: ,p_attribute9 in varchar2 default hr_api.g_varchar2
321: ,p_attribute2 in varchar2 default hr_api.g_varchar2
322: ,p_attribute3 in varchar2 default hr_api.g_varchar2
323: ,p_attribute4 in varchar2 default hr_api.g_varchar2
324: ,p_attribute5 in varchar2 default hr_api.g_varchar2
325: ,p_attribute6 in varchar2 default hr_api.g_varchar2
326: ,p_attribute7 in varchar2 default hr_api.g_varchar2
327: ,p_attribute8 in varchar2 default hr_api.g_varchar2
328: ,p_attribute9 in varchar2 default hr_api.g_varchar2
329: ,p_attribute10 in varchar2 default hr_api.g_varchar2
322: ,p_attribute3 in varchar2 default hr_api.g_varchar2
323: ,p_attribute4 in varchar2 default hr_api.g_varchar2
324: ,p_attribute5 in varchar2 default hr_api.g_varchar2
325: ,p_attribute6 in varchar2 default hr_api.g_varchar2
326: ,p_attribute7 in varchar2 default hr_api.g_varchar2
327: ,p_attribute8 in varchar2 default hr_api.g_varchar2
328: ,p_attribute9 in varchar2 default hr_api.g_varchar2
329: ,p_attribute10 in varchar2 default hr_api.g_varchar2
330: ,p_attribute11 in varchar2 default hr_api.g_varchar2
323: ,p_attribute4 in varchar2 default hr_api.g_varchar2
324: ,p_attribute5 in varchar2 default hr_api.g_varchar2
325: ,p_attribute6 in varchar2 default hr_api.g_varchar2
326: ,p_attribute7 in varchar2 default hr_api.g_varchar2
327: ,p_attribute8 in varchar2 default hr_api.g_varchar2
328: ,p_attribute9 in varchar2 default hr_api.g_varchar2
329: ,p_attribute10 in varchar2 default hr_api.g_varchar2
330: ,p_attribute11 in varchar2 default hr_api.g_varchar2
331: ,p_attribute12 in varchar2 default hr_api.g_varchar2
324: ,p_attribute5 in varchar2 default hr_api.g_varchar2
325: ,p_attribute6 in varchar2 default hr_api.g_varchar2
326: ,p_attribute7 in varchar2 default hr_api.g_varchar2
327: ,p_attribute8 in varchar2 default hr_api.g_varchar2
328: ,p_attribute9 in varchar2 default hr_api.g_varchar2
329: ,p_attribute10 in varchar2 default hr_api.g_varchar2
330: ,p_attribute11 in varchar2 default hr_api.g_varchar2
331: ,p_attribute12 in varchar2 default hr_api.g_varchar2
332: ,p_attribute13 in varchar2 default hr_api.g_varchar2
325: ,p_attribute6 in varchar2 default hr_api.g_varchar2
326: ,p_attribute7 in varchar2 default hr_api.g_varchar2
327: ,p_attribute8 in varchar2 default hr_api.g_varchar2
328: ,p_attribute9 in varchar2 default hr_api.g_varchar2
329: ,p_attribute10 in varchar2 default hr_api.g_varchar2
330: ,p_attribute11 in varchar2 default hr_api.g_varchar2
331: ,p_attribute12 in varchar2 default hr_api.g_varchar2
332: ,p_attribute13 in varchar2 default hr_api.g_varchar2
333: ,p_attribute14 in varchar2 default hr_api.g_varchar2
326: ,p_attribute7 in varchar2 default hr_api.g_varchar2
327: ,p_attribute8 in varchar2 default hr_api.g_varchar2
328: ,p_attribute9 in varchar2 default hr_api.g_varchar2
329: ,p_attribute10 in varchar2 default hr_api.g_varchar2
330: ,p_attribute11 in varchar2 default hr_api.g_varchar2
331: ,p_attribute12 in varchar2 default hr_api.g_varchar2
332: ,p_attribute13 in varchar2 default hr_api.g_varchar2
333: ,p_attribute14 in varchar2 default hr_api.g_varchar2
334: ,p_attribute15 in varchar2 default hr_api.g_varchar2
327: ,p_attribute8 in varchar2 default hr_api.g_varchar2
328: ,p_attribute9 in varchar2 default hr_api.g_varchar2
329: ,p_attribute10 in varchar2 default hr_api.g_varchar2
330: ,p_attribute11 in varchar2 default hr_api.g_varchar2
331: ,p_attribute12 in varchar2 default hr_api.g_varchar2
332: ,p_attribute13 in varchar2 default hr_api.g_varchar2
333: ,p_attribute14 in varchar2 default hr_api.g_varchar2
334: ,p_attribute15 in varchar2 default hr_api.g_varchar2
335: ,p_attribute16 in varchar2 default hr_api.g_varchar2
328: ,p_attribute9 in varchar2 default hr_api.g_varchar2
329: ,p_attribute10 in varchar2 default hr_api.g_varchar2
330: ,p_attribute11 in varchar2 default hr_api.g_varchar2
331: ,p_attribute12 in varchar2 default hr_api.g_varchar2
332: ,p_attribute13 in varchar2 default hr_api.g_varchar2
333: ,p_attribute14 in varchar2 default hr_api.g_varchar2
334: ,p_attribute15 in varchar2 default hr_api.g_varchar2
335: ,p_attribute16 in varchar2 default hr_api.g_varchar2
336: ,p_attribute17 in varchar2 default hr_api.g_varchar2
329: ,p_attribute10 in varchar2 default hr_api.g_varchar2
330: ,p_attribute11 in varchar2 default hr_api.g_varchar2
331: ,p_attribute12 in varchar2 default hr_api.g_varchar2
332: ,p_attribute13 in varchar2 default hr_api.g_varchar2
333: ,p_attribute14 in varchar2 default hr_api.g_varchar2
334: ,p_attribute15 in varchar2 default hr_api.g_varchar2
335: ,p_attribute16 in varchar2 default hr_api.g_varchar2
336: ,p_attribute17 in varchar2 default hr_api.g_varchar2
337: ,p_attribute18 in varchar2 default hr_api.g_varchar2
330: ,p_attribute11 in varchar2 default hr_api.g_varchar2
331: ,p_attribute12 in varchar2 default hr_api.g_varchar2
332: ,p_attribute13 in varchar2 default hr_api.g_varchar2
333: ,p_attribute14 in varchar2 default hr_api.g_varchar2
334: ,p_attribute15 in varchar2 default hr_api.g_varchar2
335: ,p_attribute16 in varchar2 default hr_api.g_varchar2
336: ,p_attribute17 in varchar2 default hr_api.g_varchar2
337: ,p_attribute18 in varchar2 default hr_api.g_varchar2
338: ,p_attribute19 in varchar2 default hr_api.g_varchar2
331: ,p_attribute12 in varchar2 default hr_api.g_varchar2
332: ,p_attribute13 in varchar2 default hr_api.g_varchar2
333: ,p_attribute14 in varchar2 default hr_api.g_varchar2
334: ,p_attribute15 in varchar2 default hr_api.g_varchar2
335: ,p_attribute16 in varchar2 default hr_api.g_varchar2
336: ,p_attribute17 in varchar2 default hr_api.g_varchar2
337: ,p_attribute18 in varchar2 default hr_api.g_varchar2
338: ,p_attribute19 in varchar2 default hr_api.g_varchar2
339: ,p_attribute20 in varchar2 default hr_api.g_varchar2
332: ,p_attribute13 in varchar2 default hr_api.g_varchar2
333: ,p_attribute14 in varchar2 default hr_api.g_varchar2
334: ,p_attribute15 in varchar2 default hr_api.g_varchar2
335: ,p_attribute16 in varchar2 default hr_api.g_varchar2
336: ,p_attribute17 in varchar2 default hr_api.g_varchar2
337: ,p_attribute18 in varchar2 default hr_api.g_varchar2
338: ,p_attribute19 in varchar2 default hr_api.g_varchar2
339: ,p_attribute20 in varchar2 default hr_api.g_varchar2
340: ,p_attribute21 in varchar2 default hr_api.g_varchar2
333: ,p_attribute14 in varchar2 default hr_api.g_varchar2
334: ,p_attribute15 in varchar2 default hr_api.g_varchar2
335: ,p_attribute16 in varchar2 default hr_api.g_varchar2
336: ,p_attribute17 in varchar2 default hr_api.g_varchar2
337: ,p_attribute18 in varchar2 default hr_api.g_varchar2
338: ,p_attribute19 in varchar2 default hr_api.g_varchar2
339: ,p_attribute20 in varchar2 default hr_api.g_varchar2
340: ,p_attribute21 in varchar2 default hr_api.g_varchar2
341: ,p_attribute22 in varchar2 default hr_api.g_varchar2
334: ,p_attribute15 in varchar2 default hr_api.g_varchar2
335: ,p_attribute16 in varchar2 default hr_api.g_varchar2
336: ,p_attribute17 in varchar2 default hr_api.g_varchar2
337: ,p_attribute18 in varchar2 default hr_api.g_varchar2
338: ,p_attribute19 in varchar2 default hr_api.g_varchar2
339: ,p_attribute20 in varchar2 default hr_api.g_varchar2
340: ,p_attribute21 in varchar2 default hr_api.g_varchar2
341: ,p_attribute22 in varchar2 default hr_api.g_varchar2
342: ,p_attribute23 in varchar2 default hr_api.g_varchar2
335: ,p_attribute16 in varchar2 default hr_api.g_varchar2
336: ,p_attribute17 in varchar2 default hr_api.g_varchar2
337: ,p_attribute18 in varchar2 default hr_api.g_varchar2
338: ,p_attribute19 in varchar2 default hr_api.g_varchar2
339: ,p_attribute20 in varchar2 default hr_api.g_varchar2
340: ,p_attribute21 in varchar2 default hr_api.g_varchar2
341: ,p_attribute22 in varchar2 default hr_api.g_varchar2
342: ,p_attribute23 in varchar2 default hr_api.g_varchar2
343: ,p_attribute24 in varchar2 default hr_api.g_varchar2
336: ,p_attribute17 in varchar2 default hr_api.g_varchar2
337: ,p_attribute18 in varchar2 default hr_api.g_varchar2
338: ,p_attribute19 in varchar2 default hr_api.g_varchar2
339: ,p_attribute20 in varchar2 default hr_api.g_varchar2
340: ,p_attribute21 in varchar2 default hr_api.g_varchar2
341: ,p_attribute22 in varchar2 default hr_api.g_varchar2
342: ,p_attribute23 in varchar2 default hr_api.g_varchar2
343: ,p_attribute24 in varchar2 default hr_api.g_varchar2
344: ,p_attribute25 in varchar2 default hr_api.g_varchar2
337: ,p_attribute18 in varchar2 default hr_api.g_varchar2
338: ,p_attribute19 in varchar2 default hr_api.g_varchar2
339: ,p_attribute20 in varchar2 default hr_api.g_varchar2
340: ,p_attribute21 in varchar2 default hr_api.g_varchar2
341: ,p_attribute22 in varchar2 default hr_api.g_varchar2
342: ,p_attribute23 in varchar2 default hr_api.g_varchar2
343: ,p_attribute24 in varchar2 default hr_api.g_varchar2
344: ,p_attribute25 in varchar2 default hr_api.g_varchar2
345: ,p_attribute26 in varchar2 default hr_api.g_varchar2
338: ,p_attribute19 in varchar2 default hr_api.g_varchar2
339: ,p_attribute20 in varchar2 default hr_api.g_varchar2
340: ,p_attribute21 in varchar2 default hr_api.g_varchar2
341: ,p_attribute22 in varchar2 default hr_api.g_varchar2
342: ,p_attribute23 in varchar2 default hr_api.g_varchar2
343: ,p_attribute24 in varchar2 default hr_api.g_varchar2
344: ,p_attribute25 in varchar2 default hr_api.g_varchar2
345: ,p_attribute26 in varchar2 default hr_api.g_varchar2
346: ,p_attribute27 in varchar2 default hr_api.g_varchar2
339: ,p_attribute20 in varchar2 default hr_api.g_varchar2
340: ,p_attribute21 in varchar2 default hr_api.g_varchar2
341: ,p_attribute22 in varchar2 default hr_api.g_varchar2
342: ,p_attribute23 in varchar2 default hr_api.g_varchar2
343: ,p_attribute24 in varchar2 default hr_api.g_varchar2
344: ,p_attribute25 in varchar2 default hr_api.g_varchar2
345: ,p_attribute26 in varchar2 default hr_api.g_varchar2
346: ,p_attribute27 in varchar2 default hr_api.g_varchar2
347: ,p_attribute28 in varchar2 default hr_api.g_varchar2
340: ,p_attribute21 in varchar2 default hr_api.g_varchar2
341: ,p_attribute22 in varchar2 default hr_api.g_varchar2
342: ,p_attribute23 in varchar2 default hr_api.g_varchar2
343: ,p_attribute24 in varchar2 default hr_api.g_varchar2
344: ,p_attribute25 in varchar2 default hr_api.g_varchar2
345: ,p_attribute26 in varchar2 default hr_api.g_varchar2
346: ,p_attribute27 in varchar2 default hr_api.g_varchar2
347: ,p_attribute28 in varchar2 default hr_api.g_varchar2
348: ,p_attribute29 in varchar2 default hr_api.g_varchar2
341: ,p_attribute22 in varchar2 default hr_api.g_varchar2
342: ,p_attribute23 in varchar2 default hr_api.g_varchar2
343: ,p_attribute24 in varchar2 default hr_api.g_varchar2
344: ,p_attribute25 in varchar2 default hr_api.g_varchar2
345: ,p_attribute26 in varchar2 default hr_api.g_varchar2
346: ,p_attribute27 in varchar2 default hr_api.g_varchar2
347: ,p_attribute28 in varchar2 default hr_api.g_varchar2
348: ,p_attribute29 in varchar2 default hr_api.g_varchar2
349: ,p_attribute30 in varchar2 default hr_api.g_varchar2
342: ,p_attribute23 in varchar2 default hr_api.g_varchar2
343: ,p_attribute24 in varchar2 default hr_api.g_varchar2
344: ,p_attribute25 in varchar2 default hr_api.g_varchar2
345: ,p_attribute26 in varchar2 default hr_api.g_varchar2
346: ,p_attribute27 in varchar2 default hr_api.g_varchar2
347: ,p_attribute28 in varchar2 default hr_api.g_varchar2
348: ,p_attribute29 in varchar2 default hr_api.g_varchar2
349: ,p_attribute30 in varchar2 default hr_api.g_varchar2
350: ,p_status_code in varchar2 default hr_api.g_varchar2
343: ,p_attribute24 in varchar2 default hr_api.g_varchar2
344: ,p_attribute25 in varchar2 default hr_api.g_varchar2
345: ,p_attribute26 in varchar2 default hr_api.g_varchar2
346: ,p_attribute27 in varchar2 default hr_api.g_varchar2
347: ,p_attribute28 in varchar2 default hr_api.g_varchar2
348: ,p_attribute29 in varchar2 default hr_api.g_varchar2
349: ,p_attribute30 in varchar2 default hr_api.g_varchar2
350: ,p_status_code in varchar2 default hr_api.g_varchar2
351: ,p_return_status out nocopy varchar2
344: ,p_attribute25 in varchar2 default hr_api.g_varchar2
345: ,p_attribute26 in varchar2 default hr_api.g_varchar2
346: ,p_attribute27 in varchar2 default hr_api.g_varchar2
347: ,p_attribute28 in varchar2 default hr_api.g_varchar2
348: ,p_attribute29 in varchar2 default hr_api.g_varchar2
349: ,p_attribute30 in varchar2 default hr_api.g_varchar2
350: ,p_status_code in varchar2 default hr_api.g_varchar2
351: ,p_return_status out nocopy varchar2
352: ,p_obj_setting_deadline in date default hr_api.g_date
345: ,p_attribute26 in varchar2 default hr_api.g_varchar2
346: ,p_attribute27 in varchar2 default hr_api.g_varchar2
347: ,p_attribute28 in varchar2 default hr_api.g_varchar2
348: ,p_attribute29 in varchar2 default hr_api.g_varchar2
349: ,p_attribute30 in varchar2 default hr_api.g_varchar2
350: ,p_status_code in varchar2 default hr_api.g_varchar2
351: ,p_return_status out nocopy varchar2
352: ,p_obj_setting_deadline in date default hr_api.g_date
353: ,p_supervisor_id in number default hr_api.g_number
346: ,p_attribute27 in varchar2 default hr_api.g_varchar2
347: ,p_attribute28 in varchar2 default hr_api.g_varchar2
348: ,p_attribute29 in varchar2 default hr_api.g_varchar2
349: ,p_attribute30 in varchar2 default hr_api.g_varchar2
350: ,p_status_code in varchar2 default hr_api.g_varchar2
351: ,p_return_status out nocopy varchar2
352: ,p_obj_setting_deadline in date default hr_api.g_date
353: ,p_supervisor_id in number default hr_api.g_number
354: ,p_supervisor_assignment_id in number default hr_api.g_number
348: ,p_attribute29 in varchar2 default hr_api.g_varchar2
349: ,p_attribute30 in varchar2 default hr_api.g_varchar2
350: ,p_status_code in varchar2 default hr_api.g_varchar2
351: ,p_return_status out nocopy varchar2
352: ,p_obj_setting_deadline in date default hr_api.g_date
353: ,p_supervisor_id in number default hr_api.g_number
354: ,p_supervisor_assignment_id in number default hr_api.g_number
355: ,p_eligibility_status in varchar2 default hr_api.g_varchar2
356: ,p_eligibility_eval_date in date default hr_api.g_date
349: ,p_attribute30 in varchar2 default hr_api.g_varchar2
350: ,p_status_code in varchar2 default hr_api.g_varchar2
351: ,p_return_status out nocopy varchar2
352: ,p_obj_setting_deadline in date default hr_api.g_date
353: ,p_supervisor_id in number default hr_api.g_number
354: ,p_supervisor_assignment_id in number default hr_api.g_number
355: ,p_eligibility_status in varchar2 default hr_api.g_varchar2
356: ,p_eligibility_eval_date in date default hr_api.g_date
357: ) is
350: ,p_status_code in varchar2 default hr_api.g_varchar2
351: ,p_return_status out nocopy varchar2
352: ,p_obj_setting_deadline in date default hr_api.g_date
353: ,p_supervisor_id in number default hr_api.g_number
354: ,p_supervisor_assignment_id in number default hr_api.g_number
355: ,p_eligibility_status in varchar2 default hr_api.g_varchar2
356: ,p_eligibility_eval_date in date default hr_api.g_date
357: ) is
358: --
351: ,p_return_status out nocopy varchar2
352: ,p_obj_setting_deadline in date default hr_api.g_date
353: ,p_supervisor_id in number default hr_api.g_number
354: ,p_supervisor_assignment_id in number default hr_api.g_number
355: ,p_eligibility_status in varchar2 default hr_api.g_varchar2
356: ,p_eligibility_eval_date in date default hr_api.g_date
357: ) is
358: --
359: -- Variables for API Boolean parameters
352: ,p_obj_setting_deadline in date default hr_api.g_date
353: ,p_supervisor_id in number default hr_api.g_number
354: ,p_supervisor_assignment_id in number default hr_api.g_number
355: ,p_eligibility_status in varchar2 default hr_api.g_varchar2
356: ,p_eligibility_eval_date in date default hr_api.g_date
357: ) is
358: --
359: -- Variables for API Boolean parameters
360: l_validate boolean;
382: --
383: -- Convert constant values to their corresponding boolean value
384: --
385: l_validate :=
386: hr_api.constant_to_boolean
387: (p_constant_value => p_validate);
388: --
389: -- Register Surrogate ID or user key values
390: --
496: -- ----------------------------------------------------------------------------
497: -- |------------------------< update_scorecard_status >-----------------------|
498: -- ----------------------------------------------------------------------------
499: PROCEDURE update_scorecard_status
500: (p_validate in number default hr_api.g_false_num
501: ,p_effective_date in date
502: ,p_scorecard_id in number
503: ,p_object_version_number in out nocopy number
504: ,p_status_code in varchar2
530: --
531: -- Convert constant values to their corresponding boolean value
532: --
533: l_validate :=
534: hr_api.constant_to_boolean
535: (p_constant_value => p_validate);
536: --
537: -- Register Surrogate ID or user key values
538: --