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
79: --
80: -- Convert constant values to their corresponding boolean value
81: --
82: l_validate :=
83: hr_api.constant_to_boolean
84: (p_constant_value => p_validate);
85: --
86: -- Register Surrogate ID or user key values
87: --
196: -- ----------------------------------------------------------------------------
197: -- |---------------------------< delete_scorecard >---------------------------|
198: -- ----------------------------------------------------------------------------
199: PROCEDURE delete_scorecard
200: (p_validate in number default hr_api.g_false_num
201: ,p_scorecard_id in number
202: ,p_object_version_number in number
203: ,p_return_status out nocopy varchar2
204: ) is
227: --
228: -- Convert constant values to their corresponding boolean value
229: --
230: l_validate :=
231: hr_api.constant_to_boolean
232: (p_constant_value => p_validate);
233: --
234: -- Register Surrogate ID or user key values
235: --
297: -- ----------------------------------------------------------------------------
298: -- |---------------------------< update_scorecard >---------------------------|
299: -- ----------------------------------------------------------------------------
300: PROCEDURE update_scorecard
301: (p_validate in number default hr_api.g_false_num
302: ,p_effective_date in date
303: ,p_scorecard_id in number
304: ,p_object_version_number in out nocopy number
305: ,p_scorecard_name in varchar2 default hr_api.g_varchar2
301: (p_validate in number default hr_api.g_false_num
302: ,p_effective_date in date
303: ,p_scorecard_id in number
304: ,p_object_version_number in out nocopy number
305: ,p_scorecard_name in varchar2 default hr_api.g_varchar2
306: ,p_start_date in date default hr_api.g_date
307: ,p_end_date in date default hr_api.g_date
308: ,p_plan_id in number default hr_api.g_number
309: ,p_attribute_category in varchar2 default hr_api.g_varchar2
302: ,p_effective_date in date
303: ,p_scorecard_id in number
304: ,p_object_version_number in out nocopy number
305: ,p_scorecard_name in varchar2 default hr_api.g_varchar2
306: ,p_start_date in date default hr_api.g_date
307: ,p_end_date in date default hr_api.g_date
308: ,p_plan_id in number default hr_api.g_number
309: ,p_attribute_category in varchar2 default hr_api.g_varchar2
310: ,p_attribute1 in varchar2 default hr_api.g_varchar2
303: ,p_scorecard_id in number
304: ,p_object_version_number in out nocopy number
305: ,p_scorecard_name in varchar2 default hr_api.g_varchar2
306: ,p_start_date in date default hr_api.g_date
307: ,p_end_date in date default hr_api.g_date
308: ,p_plan_id in number default hr_api.g_number
309: ,p_attribute_category in varchar2 default hr_api.g_varchar2
310: ,p_attribute1 in varchar2 default hr_api.g_varchar2
311: ,p_attribute2 in varchar2 default hr_api.g_varchar2
304: ,p_object_version_number in out nocopy number
305: ,p_scorecard_name in varchar2 default hr_api.g_varchar2
306: ,p_start_date in date default hr_api.g_date
307: ,p_end_date in date default hr_api.g_date
308: ,p_plan_id in number default hr_api.g_number
309: ,p_attribute_category in varchar2 default hr_api.g_varchar2
310: ,p_attribute1 in varchar2 default hr_api.g_varchar2
311: ,p_attribute2 in varchar2 default hr_api.g_varchar2
312: ,p_attribute3 in varchar2 default hr_api.g_varchar2
305: ,p_scorecard_name in varchar2 default hr_api.g_varchar2
306: ,p_start_date in date default hr_api.g_date
307: ,p_end_date in date default hr_api.g_date
308: ,p_plan_id in number default hr_api.g_number
309: ,p_attribute_category in varchar2 default hr_api.g_varchar2
310: ,p_attribute1 in varchar2 default hr_api.g_varchar2
311: ,p_attribute2 in varchar2 default hr_api.g_varchar2
312: ,p_attribute3 in varchar2 default hr_api.g_varchar2
313: ,p_attribute4 in varchar2 default hr_api.g_varchar2
306: ,p_start_date in date default hr_api.g_date
307: ,p_end_date in date default hr_api.g_date
308: ,p_plan_id in number default hr_api.g_number
309: ,p_attribute_category in varchar2 default hr_api.g_varchar2
310: ,p_attribute1 in varchar2 default hr_api.g_varchar2
311: ,p_attribute2 in varchar2 default hr_api.g_varchar2
312: ,p_attribute3 in varchar2 default hr_api.g_varchar2
313: ,p_attribute4 in varchar2 default hr_api.g_varchar2
314: ,p_attribute5 in varchar2 default hr_api.g_varchar2
307: ,p_end_date in date default hr_api.g_date
308: ,p_plan_id in number default hr_api.g_number
309: ,p_attribute_category in varchar2 default hr_api.g_varchar2
310: ,p_attribute1 in varchar2 default hr_api.g_varchar2
311: ,p_attribute2 in varchar2 default hr_api.g_varchar2
312: ,p_attribute3 in varchar2 default hr_api.g_varchar2
313: ,p_attribute4 in varchar2 default hr_api.g_varchar2
314: ,p_attribute5 in varchar2 default hr_api.g_varchar2
315: ,p_attribute6 in varchar2 default hr_api.g_varchar2
308: ,p_plan_id in number default hr_api.g_number
309: ,p_attribute_category in varchar2 default hr_api.g_varchar2
310: ,p_attribute1 in varchar2 default hr_api.g_varchar2
311: ,p_attribute2 in varchar2 default hr_api.g_varchar2
312: ,p_attribute3 in varchar2 default hr_api.g_varchar2
313: ,p_attribute4 in varchar2 default hr_api.g_varchar2
314: ,p_attribute5 in varchar2 default hr_api.g_varchar2
315: ,p_attribute6 in varchar2 default hr_api.g_varchar2
316: ,p_attribute7 in varchar2 default hr_api.g_varchar2
309: ,p_attribute_category in varchar2 default hr_api.g_varchar2
310: ,p_attribute1 in varchar2 default hr_api.g_varchar2
311: ,p_attribute2 in varchar2 default hr_api.g_varchar2
312: ,p_attribute3 in varchar2 default hr_api.g_varchar2
313: ,p_attribute4 in varchar2 default hr_api.g_varchar2
314: ,p_attribute5 in varchar2 default hr_api.g_varchar2
315: ,p_attribute6 in varchar2 default hr_api.g_varchar2
316: ,p_attribute7 in varchar2 default hr_api.g_varchar2
317: ,p_attribute8 in varchar2 default hr_api.g_varchar2
310: ,p_attribute1 in varchar2 default hr_api.g_varchar2
311: ,p_attribute2 in varchar2 default hr_api.g_varchar2
312: ,p_attribute3 in varchar2 default hr_api.g_varchar2
313: ,p_attribute4 in varchar2 default hr_api.g_varchar2
314: ,p_attribute5 in varchar2 default hr_api.g_varchar2
315: ,p_attribute6 in varchar2 default hr_api.g_varchar2
316: ,p_attribute7 in varchar2 default hr_api.g_varchar2
317: ,p_attribute8 in varchar2 default hr_api.g_varchar2
318: ,p_attribute9 in varchar2 default hr_api.g_varchar2
311: ,p_attribute2 in varchar2 default hr_api.g_varchar2
312: ,p_attribute3 in varchar2 default hr_api.g_varchar2
313: ,p_attribute4 in varchar2 default hr_api.g_varchar2
314: ,p_attribute5 in varchar2 default hr_api.g_varchar2
315: ,p_attribute6 in varchar2 default hr_api.g_varchar2
316: ,p_attribute7 in varchar2 default hr_api.g_varchar2
317: ,p_attribute8 in varchar2 default hr_api.g_varchar2
318: ,p_attribute9 in varchar2 default hr_api.g_varchar2
319: ,p_attribute10 in varchar2 default hr_api.g_varchar2
312: ,p_attribute3 in varchar2 default hr_api.g_varchar2
313: ,p_attribute4 in varchar2 default hr_api.g_varchar2
314: ,p_attribute5 in varchar2 default hr_api.g_varchar2
315: ,p_attribute6 in varchar2 default hr_api.g_varchar2
316: ,p_attribute7 in varchar2 default hr_api.g_varchar2
317: ,p_attribute8 in varchar2 default hr_api.g_varchar2
318: ,p_attribute9 in varchar2 default hr_api.g_varchar2
319: ,p_attribute10 in varchar2 default hr_api.g_varchar2
320: ,p_attribute11 in varchar2 default hr_api.g_varchar2
313: ,p_attribute4 in varchar2 default hr_api.g_varchar2
314: ,p_attribute5 in varchar2 default hr_api.g_varchar2
315: ,p_attribute6 in varchar2 default hr_api.g_varchar2
316: ,p_attribute7 in varchar2 default hr_api.g_varchar2
317: ,p_attribute8 in varchar2 default hr_api.g_varchar2
318: ,p_attribute9 in varchar2 default hr_api.g_varchar2
319: ,p_attribute10 in varchar2 default hr_api.g_varchar2
320: ,p_attribute11 in varchar2 default hr_api.g_varchar2
321: ,p_attribute12 in varchar2 default hr_api.g_varchar2
314: ,p_attribute5 in varchar2 default hr_api.g_varchar2
315: ,p_attribute6 in varchar2 default hr_api.g_varchar2
316: ,p_attribute7 in varchar2 default hr_api.g_varchar2
317: ,p_attribute8 in varchar2 default hr_api.g_varchar2
318: ,p_attribute9 in varchar2 default hr_api.g_varchar2
319: ,p_attribute10 in varchar2 default hr_api.g_varchar2
320: ,p_attribute11 in varchar2 default hr_api.g_varchar2
321: ,p_attribute12 in varchar2 default hr_api.g_varchar2
322: ,p_attribute13 in varchar2 default hr_api.g_varchar2
315: ,p_attribute6 in varchar2 default hr_api.g_varchar2
316: ,p_attribute7 in varchar2 default hr_api.g_varchar2
317: ,p_attribute8 in varchar2 default hr_api.g_varchar2
318: ,p_attribute9 in varchar2 default hr_api.g_varchar2
319: ,p_attribute10 in varchar2 default hr_api.g_varchar2
320: ,p_attribute11 in varchar2 default hr_api.g_varchar2
321: ,p_attribute12 in varchar2 default hr_api.g_varchar2
322: ,p_attribute13 in varchar2 default hr_api.g_varchar2
323: ,p_attribute14 in varchar2 default hr_api.g_varchar2
316: ,p_attribute7 in varchar2 default hr_api.g_varchar2
317: ,p_attribute8 in varchar2 default hr_api.g_varchar2
318: ,p_attribute9 in varchar2 default hr_api.g_varchar2
319: ,p_attribute10 in varchar2 default hr_api.g_varchar2
320: ,p_attribute11 in varchar2 default hr_api.g_varchar2
321: ,p_attribute12 in varchar2 default hr_api.g_varchar2
322: ,p_attribute13 in varchar2 default hr_api.g_varchar2
323: ,p_attribute14 in varchar2 default hr_api.g_varchar2
324: ,p_attribute15 in varchar2 default hr_api.g_varchar2
317: ,p_attribute8 in varchar2 default hr_api.g_varchar2
318: ,p_attribute9 in varchar2 default hr_api.g_varchar2
319: ,p_attribute10 in varchar2 default hr_api.g_varchar2
320: ,p_attribute11 in varchar2 default hr_api.g_varchar2
321: ,p_attribute12 in varchar2 default hr_api.g_varchar2
322: ,p_attribute13 in varchar2 default hr_api.g_varchar2
323: ,p_attribute14 in varchar2 default hr_api.g_varchar2
324: ,p_attribute15 in varchar2 default hr_api.g_varchar2
325: ,p_attribute16 in varchar2 default hr_api.g_varchar2
318: ,p_attribute9 in varchar2 default hr_api.g_varchar2
319: ,p_attribute10 in varchar2 default hr_api.g_varchar2
320: ,p_attribute11 in varchar2 default hr_api.g_varchar2
321: ,p_attribute12 in varchar2 default hr_api.g_varchar2
322: ,p_attribute13 in varchar2 default hr_api.g_varchar2
323: ,p_attribute14 in varchar2 default hr_api.g_varchar2
324: ,p_attribute15 in varchar2 default hr_api.g_varchar2
325: ,p_attribute16 in varchar2 default hr_api.g_varchar2
326: ,p_attribute17 in varchar2 default hr_api.g_varchar2
319: ,p_attribute10 in varchar2 default hr_api.g_varchar2
320: ,p_attribute11 in varchar2 default hr_api.g_varchar2
321: ,p_attribute12 in varchar2 default hr_api.g_varchar2
322: ,p_attribute13 in varchar2 default hr_api.g_varchar2
323: ,p_attribute14 in varchar2 default hr_api.g_varchar2
324: ,p_attribute15 in varchar2 default hr_api.g_varchar2
325: ,p_attribute16 in varchar2 default hr_api.g_varchar2
326: ,p_attribute17 in varchar2 default hr_api.g_varchar2
327: ,p_attribute18 in varchar2 default hr_api.g_varchar2
320: ,p_attribute11 in varchar2 default hr_api.g_varchar2
321: ,p_attribute12 in varchar2 default hr_api.g_varchar2
322: ,p_attribute13 in varchar2 default hr_api.g_varchar2
323: ,p_attribute14 in varchar2 default hr_api.g_varchar2
324: ,p_attribute15 in varchar2 default hr_api.g_varchar2
325: ,p_attribute16 in varchar2 default hr_api.g_varchar2
326: ,p_attribute17 in varchar2 default hr_api.g_varchar2
327: ,p_attribute18 in varchar2 default hr_api.g_varchar2
328: ,p_attribute19 in varchar2 default hr_api.g_varchar2
321: ,p_attribute12 in varchar2 default hr_api.g_varchar2
322: ,p_attribute13 in varchar2 default hr_api.g_varchar2
323: ,p_attribute14 in varchar2 default hr_api.g_varchar2
324: ,p_attribute15 in varchar2 default hr_api.g_varchar2
325: ,p_attribute16 in varchar2 default hr_api.g_varchar2
326: ,p_attribute17 in varchar2 default hr_api.g_varchar2
327: ,p_attribute18 in varchar2 default hr_api.g_varchar2
328: ,p_attribute19 in varchar2 default hr_api.g_varchar2
329: ,p_attribute20 in varchar2 default hr_api.g_varchar2
322: ,p_attribute13 in varchar2 default hr_api.g_varchar2
323: ,p_attribute14 in varchar2 default hr_api.g_varchar2
324: ,p_attribute15 in varchar2 default hr_api.g_varchar2
325: ,p_attribute16 in varchar2 default hr_api.g_varchar2
326: ,p_attribute17 in varchar2 default hr_api.g_varchar2
327: ,p_attribute18 in varchar2 default hr_api.g_varchar2
328: ,p_attribute19 in varchar2 default hr_api.g_varchar2
329: ,p_attribute20 in varchar2 default hr_api.g_varchar2
330: ,p_attribute21 in varchar2 default hr_api.g_varchar2
323: ,p_attribute14 in varchar2 default hr_api.g_varchar2
324: ,p_attribute15 in varchar2 default hr_api.g_varchar2
325: ,p_attribute16 in varchar2 default hr_api.g_varchar2
326: ,p_attribute17 in varchar2 default hr_api.g_varchar2
327: ,p_attribute18 in varchar2 default hr_api.g_varchar2
328: ,p_attribute19 in varchar2 default hr_api.g_varchar2
329: ,p_attribute20 in varchar2 default hr_api.g_varchar2
330: ,p_attribute21 in varchar2 default hr_api.g_varchar2
331: ,p_attribute22 in varchar2 default hr_api.g_varchar2
324: ,p_attribute15 in varchar2 default hr_api.g_varchar2
325: ,p_attribute16 in varchar2 default hr_api.g_varchar2
326: ,p_attribute17 in varchar2 default hr_api.g_varchar2
327: ,p_attribute18 in varchar2 default hr_api.g_varchar2
328: ,p_attribute19 in varchar2 default hr_api.g_varchar2
329: ,p_attribute20 in varchar2 default hr_api.g_varchar2
330: ,p_attribute21 in varchar2 default hr_api.g_varchar2
331: ,p_attribute22 in varchar2 default hr_api.g_varchar2
332: ,p_attribute23 in varchar2 default hr_api.g_varchar2
325: ,p_attribute16 in varchar2 default hr_api.g_varchar2
326: ,p_attribute17 in varchar2 default hr_api.g_varchar2
327: ,p_attribute18 in varchar2 default hr_api.g_varchar2
328: ,p_attribute19 in varchar2 default hr_api.g_varchar2
329: ,p_attribute20 in varchar2 default hr_api.g_varchar2
330: ,p_attribute21 in varchar2 default hr_api.g_varchar2
331: ,p_attribute22 in varchar2 default hr_api.g_varchar2
332: ,p_attribute23 in varchar2 default hr_api.g_varchar2
333: ,p_attribute24 in varchar2 default hr_api.g_varchar2
326: ,p_attribute17 in varchar2 default hr_api.g_varchar2
327: ,p_attribute18 in varchar2 default hr_api.g_varchar2
328: ,p_attribute19 in varchar2 default hr_api.g_varchar2
329: ,p_attribute20 in varchar2 default hr_api.g_varchar2
330: ,p_attribute21 in varchar2 default hr_api.g_varchar2
331: ,p_attribute22 in varchar2 default hr_api.g_varchar2
332: ,p_attribute23 in varchar2 default hr_api.g_varchar2
333: ,p_attribute24 in varchar2 default hr_api.g_varchar2
334: ,p_attribute25 in varchar2 default hr_api.g_varchar2
327: ,p_attribute18 in varchar2 default hr_api.g_varchar2
328: ,p_attribute19 in varchar2 default hr_api.g_varchar2
329: ,p_attribute20 in varchar2 default hr_api.g_varchar2
330: ,p_attribute21 in varchar2 default hr_api.g_varchar2
331: ,p_attribute22 in varchar2 default hr_api.g_varchar2
332: ,p_attribute23 in varchar2 default hr_api.g_varchar2
333: ,p_attribute24 in varchar2 default hr_api.g_varchar2
334: ,p_attribute25 in varchar2 default hr_api.g_varchar2
335: ,p_attribute26 in varchar2 default hr_api.g_varchar2
328: ,p_attribute19 in varchar2 default hr_api.g_varchar2
329: ,p_attribute20 in varchar2 default hr_api.g_varchar2
330: ,p_attribute21 in varchar2 default hr_api.g_varchar2
331: ,p_attribute22 in varchar2 default hr_api.g_varchar2
332: ,p_attribute23 in varchar2 default hr_api.g_varchar2
333: ,p_attribute24 in varchar2 default hr_api.g_varchar2
334: ,p_attribute25 in varchar2 default hr_api.g_varchar2
335: ,p_attribute26 in varchar2 default hr_api.g_varchar2
336: ,p_attribute27 in varchar2 default hr_api.g_varchar2
329: ,p_attribute20 in varchar2 default hr_api.g_varchar2
330: ,p_attribute21 in varchar2 default hr_api.g_varchar2
331: ,p_attribute22 in varchar2 default hr_api.g_varchar2
332: ,p_attribute23 in varchar2 default hr_api.g_varchar2
333: ,p_attribute24 in varchar2 default hr_api.g_varchar2
334: ,p_attribute25 in varchar2 default hr_api.g_varchar2
335: ,p_attribute26 in varchar2 default hr_api.g_varchar2
336: ,p_attribute27 in varchar2 default hr_api.g_varchar2
337: ,p_attribute28 in varchar2 default hr_api.g_varchar2
330: ,p_attribute21 in varchar2 default hr_api.g_varchar2
331: ,p_attribute22 in varchar2 default hr_api.g_varchar2
332: ,p_attribute23 in varchar2 default hr_api.g_varchar2
333: ,p_attribute24 in varchar2 default hr_api.g_varchar2
334: ,p_attribute25 in varchar2 default hr_api.g_varchar2
335: ,p_attribute26 in varchar2 default hr_api.g_varchar2
336: ,p_attribute27 in varchar2 default hr_api.g_varchar2
337: ,p_attribute28 in varchar2 default hr_api.g_varchar2
338: ,p_attribute29 in varchar2 default hr_api.g_varchar2
331: ,p_attribute22 in varchar2 default hr_api.g_varchar2
332: ,p_attribute23 in varchar2 default hr_api.g_varchar2
333: ,p_attribute24 in varchar2 default hr_api.g_varchar2
334: ,p_attribute25 in varchar2 default hr_api.g_varchar2
335: ,p_attribute26 in varchar2 default hr_api.g_varchar2
336: ,p_attribute27 in varchar2 default hr_api.g_varchar2
337: ,p_attribute28 in varchar2 default hr_api.g_varchar2
338: ,p_attribute29 in varchar2 default hr_api.g_varchar2
339: ,p_attribute30 in varchar2 default hr_api.g_varchar2
332: ,p_attribute23 in varchar2 default hr_api.g_varchar2
333: ,p_attribute24 in varchar2 default hr_api.g_varchar2
334: ,p_attribute25 in varchar2 default hr_api.g_varchar2
335: ,p_attribute26 in varchar2 default hr_api.g_varchar2
336: ,p_attribute27 in varchar2 default hr_api.g_varchar2
337: ,p_attribute28 in varchar2 default hr_api.g_varchar2
338: ,p_attribute29 in varchar2 default hr_api.g_varchar2
339: ,p_attribute30 in varchar2 default hr_api.g_varchar2
340: ,p_status_code in varchar2 default hr_api.g_varchar2
333: ,p_attribute24 in varchar2 default hr_api.g_varchar2
334: ,p_attribute25 in varchar2 default hr_api.g_varchar2
335: ,p_attribute26 in varchar2 default hr_api.g_varchar2
336: ,p_attribute27 in varchar2 default hr_api.g_varchar2
337: ,p_attribute28 in varchar2 default hr_api.g_varchar2
338: ,p_attribute29 in varchar2 default hr_api.g_varchar2
339: ,p_attribute30 in varchar2 default hr_api.g_varchar2
340: ,p_status_code in varchar2 default hr_api.g_varchar2
341: ,p_return_status out nocopy varchar2
334: ,p_attribute25 in varchar2 default hr_api.g_varchar2
335: ,p_attribute26 in varchar2 default hr_api.g_varchar2
336: ,p_attribute27 in varchar2 default hr_api.g_varchar2
337: ,p_attribute28 in varchar2 default hr_api.g_varchar2
338: ,p_attribute29 in varchar2 default hr_api.g_varchar2
339: ,p_attribute30 in varchar2 default hr_api.g_varchar2
340: ,p_status_code in varchar2 default hr_api.g_varchar2
341: ,p_return_status out nocopy varchar2
342: ) is
335: ,p_attribute26 in varchar2 default hr_api.g_varchar2
336: ,p_attribute27 in varchar2 default hr_api.g_varchar2
337: ,p_attribute28 in varchar2 default hr_api.g_varchar2
338: ,p_attribute29 in varchar2 default hr_api.g_varchar2
339: ,p_attribute30 in varchar2 default hr_api.g_varchar2
340: ,p_status_code in varchar2 default hr_api.g_varchar2
341: ,p_return_status out nocopy varchar2
342: ) is
343: --
336: ,p_attribute27 in varchar2 default hr_api.g_varchar2
337: ,p_attribute28 in varchar2 default hr_api.g_varchar2
338: ,p_attribute29 in varchar2 default hr_api.g_varchar2
339: ,p_attribute30 in varchar2 default hr_api.g_varchar2
340: ,p_status_code in varchar2 default hr_api.g_varchar2
341: ,p_return_status out nocopy varchar2
342: ) is
343: --
344: -- Variables for API Boolean parameters
367: --
368: -- Convert constant values to their corresponding boolean value
369: --
370: l_validate :=
371: hr_api.constant_to_boolean
372: (p_constant_value => p_validate);
373: --
374: -- Register Surrogate ID or user key values
375: --
476: -- ----------------------------------------------------------------------------
477: -- |------------------------< update_scorecard_status >-----------------------|
478: -- ----------------------------------------------------------------------------
479: PROCEDURE update_scorecard_status
480: (p_validate in number default hr_api.g_false_num
481: ,p_effective_date in date
482: ,p_scorecard_id in number
483: ,p_object_version_number in out nocopy number
484: ,p_status_code in varchar2
510: --
511: -- Convert constant values to their corresponding boolean value
512: --
513: l_validate :=
514: hr_api.constant_to_boolean
515: (p_constant_value => p_validate);
516: --
517: -- Register Surrogate ID or user key values
518: --