100: --
101: hr_utility.set_location(' Leaving:'||l_proc, 10);
102: --
103: Exception
104: When hr_api.check_integrity_violated Then
105: -- A check constraint has been violated
106: per_grs_shd.g_api_dml := false; -- Unset the api dml status
107: per_grs_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.check_integrity_violated Then
105: -- A check constraint has been violated
106: per_grs_shd.g_api_dml := false; -- Unset the api dml status
107: per_grs_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: per_grs_shd.g_api_dml := false; -- Unset the api dml status
112: per_grs_shd.constraint_error
105: -- A check constraint has been violated
106: per_grs_shd.g_api_dml := false; -- Unset the api dml status
107: per_grs_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: per_grs_shd.g_api_dml := false; -- Unset the api dml status
112: per_grs_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: per_grs_shd.g_api_dml := false; -- Unset the api dml status
112: per_grs_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: per_grs_shd.g_api_dml := false; -- Unset the api dml status
117: per_grs_shd.constraint_error
110: -- Parent integrity has been violated
111: per_grs_shd.g_api_dml := false; -- Unset the api dml status
112: per_grs_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: per_grs_shd.g_api_dml := false; -- Unset the api dml status
117: per_grs_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: per_grs_shd.g_api_dml := false; -- Unset the api dml status
117: per_grs_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When Others Then
120: per_grs_shd.g_api_dml := false; -- Unset the api dml status
121: Raise;
122: End update_dml;
266: );
267: --
268: exception
269: --
270: when hr_api.cannot_find_prog_unit then
271: --
272: hr_api.cannot_find_prog_unit_error
273: (p_module_name => 'per_cagr_grade_structures'
274: ,p_hook_type => 'AU');
268: exception
269: --
270: when hr_api.cannot_find_prog_unit then
271: --
272: hr_api.cannot_find_prog_unit_error
273: (p_module_name => 'per_cagr_grade_structures'
274: ,p_hook_type => 'AU');
275: --
276: end;
336: -- p_rec plsql record structure
337: -- to see if a system default is being used. If a system default
338: -- is being used then we must set to the 'current' argument value.
339: --
340: If (p_rec.collective_agreement_id = hr_api.g_number) then
341: p_rec.collective_agreement_id :=
342: per_grs_shd.g_old_rec.collective_agreement_id;
343: End If;
344: If (p_rec.id_flex_num = hr_api.g_number) then
340: If (p_rec.collective_agreement_id = hr_api.g_number) then
341: p_rec.collective_agreement_id :=
342: per_grs_shd.g_old_rec.collective_agreement_id;
343: End If;
344: If (p_rec.id_flex_num = hr_api.g_number) then
345: p_rec.id_flex_num :=
346: per_grs_shd.g_old_rec.id_flex_num;
347: End If;
348: If (p_rec.dynamic_insert_allowed = hr_api.g_varchar2) then
344: If (p_rec.id_flex_num = hr_api.g_number) then
345: p_rec.id_flex_num :=
346: per_grs_shd.g_old_rec.id_flex_num;
347: End If;
348: If (p_rec.dynamic_insert_allowed = hr_api.g_varchar2) then
349: p_rec.dynamic_insert_allowed :=
350: per_grs_shd.g_old_rec.dynamic_insert_allowed;
351: End If;
352: If (p_rec.attribute_category = hr_api.g_varchar2) then
348: If (p_rec.dynamic_insert_allowed = hr_api.g_varchar2) then
349: p_rec.dynamic_insert_allowed :=
350: per_grs_shd.g_old_rec.dynamic_insert_allowed;
351: End If;
352: If (p_rec.attribute_category = hr_api.g_varchar2) then
353: p_rec.attribute_category :=
354: per_grs_shd.g_old_rec.attribute_category;
355: End If;
356: If (p_rec.attribute1 = hr_api.g_varchar2) then
352: If (p_rec.attribute_category = hr_api.g_varchar2) then
353: p_rec.attribute_category :=
354: per_grs_shd.g_old_rec.attribute_category;
355: End If;
356: If (p_rec.attribute1 = hr_api.g_varchar2) then
357: p_rec.attribute1 :=
358: per_grs_shd.g_old_rec.attribute1;
359: End If;
360: If (p_rec.attribute2 = hr_api.g_varchar2) then
356: If (p_rec.attribute1 = hr_api.g_varchar2) then
357: p_rec.attribute1 :=
358: per_grs_shd.g_old_rec.attribute1;
359: End If;
360: If (p_rec.attribute2 = hr_api.g_varchar2) then
361: p_rec.attribute2 :=
362: per_grs_shd.g_old_rec.attribute2;
363: End If;
364: If (p_rec.attribute3 = hr_api.g_varchar2) then
360: If (p_rec.attribute2 = hr_api.g_varchar2) then
361: p_rec.attribute2 :=
362: per_grs_shd.g_old_rec.attribute2;
363: End If;
364: If (p_rec.attribute3 = hr_api.g_varchar2) then
365: p_rec.attribute3 :=
366: per_grs_shd.g_old_rec.attribute3;
367: End If;
368: If (p_rec.attribute4 = hr_api.g_varchar2) then
364: If (p_rec.attribute3 = hr_api.g_varchar2) then
365: p_rec.attribute3 :=
366: per_grs_shd.g_old_rec.attribute3;
367: End If;
368: If (p_rec.attribute4 = hr_api.g_varchar2) then
369: p_rec.attribute4 :=
370: per_grs_shd.g_old_rec.attribute4;
371: End If;
372: If (p_rec.attribute5 = hr_api.g_varchar2) then
368: If (p_rec.attribute4 = hr_api.g_varchar2) then
369: p_rec.attribute4 :=
370: per_grs_shd.g_old_rec.attribute4;
371: End If;
372: If (p_rec.attribute5 = hr_api.g_varchar2) then
373: p_rec.attribute5 :=
374: per_grs_shd.g_old_rec.attribute5;
375: End If;
376: If (p_rec.attribute6 = hr_api.g_varchar2) then
372: If (p_rec.attribute5 = hr_api.g_varchar2) then
373: p_rec.attribute5 :=
374: per_grs_shd.g_old_rec.attribute5;
375: End If;
376: If (p_rec.attribute6 = hr_api.g_varchar2) then
377: p_rec.attribute6 :=
378: per_grs_shd.g_old_rec.attribute6;
379: End If;
380: If (p_rec.attribute7 = hr_api.g_varchar2) then
376: If (p_rec.attribute6 = hr_api.g_varchar2) then
377: p_rec.attribute6 :=
378: per_grs_shd.g_old_rec.attribute6;
379: End If;
380: If (p_rec.attribute7 = hr_api.g_varchar2) then
381: p_rec.attribute7 :=
382: per_grs_shd.g_old_rec.attribute7;
383: End If;
384: If (p_rec.attribute8 = hr_api.g_varchar2) then
380: If (p_rec.attribute7 = hr_api.g_varchar2) then
381: p_rec.attribute7 :=
382: per_grs_shd.g_old_rec.attribute7;
383: End If;
384: If (p_rec.attribute8 = hr_api.g_varchar2) then
385: p_rec.attribute8 :=
386: per_grs_shd.g_old_rec.attribute8;
387: End If;
388: If (p_rec.attribute9 = hr_api.g_varchar2) then
384: If (p_rec.attribute8 = hr_api.g_varchar2) then
385: p_rec.attribute8 :=
386: per_grs_shd.g_old_rec.attribute8;
387: End If;
388: If (p_rec.attribute9 = hr_api.g_varchar2) then
389: p_rec.attribute9 :=
390: per_grs_shd.g_old_rec.attribute9;
391: End If;
392: If (p_rec.attribute10 = hr_api.g_varchar2) then
388: If (p_rec.attribute9 = hr_api.g_varchar2) then
389: p_rec.attribute9 :=
390: per_grs_shd.g_old_rec.attribute9;
391: End If;
392: If (p_rec.attribute10 = hr_api.g_varchar2) then
393: p_rec.attribute10 :=
394: per_grs_shd.g_old_rec.attribute10;
395: End If;
396: If (p_rec.attribute11 = hr_api.g_varchar2) then
392: If (p_rec.attribute10 = hr_api.g_varchar2) then
393: p_rec.attribute10 :=
394: per_grs_shd.g_old_rec.attribute10;
395: End If;
396: If (p_rec.attribute11 = hr_api.g_varchar2) then
397: p_rec.attribute11 :=
398: per_grs_shd.g_old_rec.attribute11;
399: End If;
400: If (p_rec.attribute12 = hr_api.g_varchar2) then
396: If (p_rec.attribute11 = hr_api.g_varchar2) then
397: p_rec.attribute11 :=
398: per_grs_shd.g_old_rec.attribute11;
399: End If;
400: If (p_rec.attribute12 = hr_api.g_varchar2) then
401: p_rec.attribute12 :=
402: per_grs_shd.g_old_rec.attribute12;
403: End If;
404: If (p_rec.attribute13 = hr_api.g_varchar2) then
400: If (p_rec.attribute12 = hr_api.g_varchar2) then
401: p_rec.attribute12 :=
402: per_grs_shd.g_old_rec.attribute12;
403: End If;
404: If (p_rec.attribute13 = hr_api.g_varchar2) then
405: p_rec.attribute13 :=
406: per_grs_shd.g_old_rec.attribute13;
407: End If;
408: If (p_rec.attribute14 = hr_api.g_varchar2) then
404: If (p_rec.attribute13 = hr_api.g_varchar2) then
405: p_rec.attribute13 :=
406: per_grs_shd.g_old_rec.attribute13;
407: End If;
408: If (p_rec.attribute14 = hr_api.g_varchar2) then
409: p_rec.attribute14 :=
410: per_grs_shd.g_old_rec.attribute14;
411: End If;
412: If (p_rec.attribute15 = hr_api.g_varchar2) then
408: If (p_rec.attribute14 = hr_api.g_varchar2) then
409: p_rec.attribute14 :=
410: per_grs_shd.g_old_rec.attribute14;
411: End If;
412: If (p_rec.attribute15 = hr_api.g_varchar2) then
413: p_rec.attribute15 :=
414: per_grs_shd.g_old_rec.attribute15;
415: End If;
416: If (p_rec.attribute16 = hr_api.g_varchar2) then
412: If (p_rec.attribute15 = hr_api.g_varchar2) then
413: p_rec.attribute15 :=
414: per_grs_shd.g_old_rec.attribute15;
415: End If;
416: If (p_rec.attribute16 = hr_api.g_varchar2) then
417: p_rec.attribute16 :=
418: per_grs_shd.g_old_rec.attribute16;
419: End If;
420: If (p_rec.attribute17 = hr_api.g_varchar2) then
416: If (p_rec.attribute16 = hr_api.g_varchar2) then
417: p_rec.attribute16 :=
418: per_grs_shd.g_old_rec.attribute16;
419: End If;
420: If (p_rec.attribute17 = hr_api.g_varchar2) then
421: p_rec.attribute17 :=
422: per_grs_shd.g_old_rec.attribute17;
423: End If;
424: If (p_rec.attribute18 = hr_api.g_varchar2) then
420: If (p_rec.attribute17 = hr_api.g_varchar2) then
421: p_rec.attribute17 :=
422: per_grs_shd.g_old_rec.attribute17;
423: End If;
424: If (p_rec.attribute18 = hr_api.g_varchar2) then
425: p_rec.attribute18 :=
426: per_grs_shd.g_old_rec.attribute18;
427: End If;
428: If (p_rec.attribute19 = hr_api.g_varchar2) then
424: If (p_rec.attribute18 = hr_api.g_varchar2) then
425: p_rec.attribute18 :=
426: per_grs_shd.g_old_rec.attribute18;
427: End If;
428: If (p_rec.attribute19 = hr_api.g_varchar2) then
429: p_rec.attribute19 :=
430: per_grs_shd.g_old_rec.attribute19;
431: End If;
432: If (p_rec.attribute20 = hr_api.g_varchar2) then
428: If (p_rec.attribute19 = hr_api.g_varchar2) then
429: p_rec.attribute19 :=
430: per_grs_shd.g_old_rec.attribute19;
431: End If;
432: If (p_rec.attribute20 = hr_api.g_varchar2) then
433: p_rec.attribute20 :=
434: per_grs_shd.g_old_rec.attribute20;
435: End If;
436: --
492: -- ----------------------------------------------------------------------------
493: Procedure upd
494: (
495: p_cagr_grade_structure_id in number,
496: p_collective_agreement_id in number default hr_api.g_number,
497: p_object_version_number in out nocopy number,
498: p_id_flex_num in number default hr_api.g_number,
499: p_dynamic_insert_allowed in varchar2 default hr_api.g_varchar2,
500: p_attribute_category in varchar2 default hr_api.g_varchar2,
494: (
495: p_cagr_grade_structure_id in number,
496: p_collective_agreement_id in number default hr_api.g_number,
497: p_object_version_number in out nocopy number,
498: p_id_flex_num in number default hr_api.g_number,
499: p_dynamic_insert_allowed in varchar2 default hr_api.g_varchar2,
500: p_attribute_category in varchar2 default hr_api.g_varchar2,
501: p_attribute1 in varchar2 default hr_api.g_varchar2,
502: p_attribute2 in varchar2 default hr_api.g_varchar2,
495: p_cagr_grade_structure_id in number,
496: p_collective_agreement_id in number default hr_api.g_number,
497: p_object_version_number in out nocopy number,
498: p_id_flex_num in number default hr_api.g_number,
499: p_dynamic_insert_allowed in varchar2 default hr_api.g_varchar2,
500: p_attribute_category in varchar2 default hr_api.g_varchar2,
501: p_attribute1 in varchar2 default hr_api.g_varchar2,
502: p_attribute2 in varchar2 default hr_api.g_varchar2,
503: p_attribute3 in varchar2 default hr_api.g_varchar2,
496: p_collective_agreement_id in number default hr_api.g_number,
497: p_object_version_number in out nocopy number,
498: p_id_flex_num in number default hr_api.g_number,
499: p_dynamic_insert_allowed in varchar2 default hr_api.g_varchar2,
500: p_attribute_category in varchar2 default hr_api.g_varchar2,
501: p_attribute1 in varchar2 default hr_api.g_varchar2,
502: p_attribute2 in varchar2 default hr_api.g_varchar2,
503: p_attribute3 in varchar2 default hr_api.g_varchar2,
504: p_attribute4 in varchar2 default hr_api.g_varchar2,
497: p_object_version_number in out nocopy number,
498: p_id_flex_num in number default hr_api.g_number,
499: p_dynamic_insert_allowed in varchar2 default hr_api.g_varchar2,
500: p_attribute_category in varchar2 default hr_api.g_varchar2,
501: p_attribute1 in varchar2 default hr_api.g_varchar2,
502: p_attribute2 in varchar2 default hr_api.g_varchar2,
503: p_attribute3 in varchar2 default hr_api.g_varchar2,
504: p_attribute4 in varchar2 default hr_api.g_varchar2,
505: p_attribute5 in varchar2 default hr_api.g_varchar2,
498: p_id_flex_num in number default hr_api.g_number,
499: p_dynamic_insert_allowed in varchar2 default hr_api.g_varchar2,
500: p_attribute_category in varchar2 default hr_api.g_varchar2,
501: p_attribute1 in varchar2 default hr_api.g_varchar2,
502: p_attribute2 in varchar2 default hr_api.g_varchar2,
503: p_attribute3 in varchar2 default hr_api.g_varchar2,
504: p_attribute4 in varchar2 default hr_api.g_varchar2,
505: p_attribute5 in varchar2 default hr_api.g_varchar2,
506: p_attribute6 in varchar2 default hr_api.g_varchar2,
499: p_dynamic_insert_allowed in varchar2 default hr_api.g_varchar2,
500: p_attribute_category in varchar2 default hr_api.g_varchar2,
501: p_attribute1 in varchar2 default hr_api.g_varchar2,
502: p_attribute2 in varchar2 default hr_api.g_varchar2,
503: p_attribute3 in varchar2 default hr_api.g_varchar2,
504: p_attribute4 in varchar2 default hr_api.g_varchar2,
505: p_attribute5 in varchar2 default hr_api.g_varchar2,
506: p_attribute6 in varchar2 default hr_api.g_varchar2,
507: p_attribute7 in varchar2 default hr_api.g_varchar2,
500: p_attribute_category in varchar2 default hr_api.g_varchar2,
501: p_attribute1 in varchar2 default hr_api.g_varchar2,
502: p_attribute2 in varchar2 default hr_api.g_varchar2,
503: p_attribute3 in varchar2 default hr_api.g_varchar2,
504: p_attribute4 in varchar2 default hr_api.g_varchar2,
505: p_attribute5 in varchar2 default hr_api.g_varchar2,
506: p_attribute6 in varchar2 default hr_api.g_varchar2,
507: p_attribute7 in varchar2 default hr_api.g_varchar2,
508: p_attribute8 in varchar2 default hr_api.g_varchar2,
501: p_attribute1 in varchar2 default hr_api.g_varchar2,
502: p_attribute2 in varchar2 default hr_api.g_varchar2,
503: p_attribute3 in varchar2 default hr_api.g_varchar2,
504: p_attribute4 in varchar2 default hr_api.g_varchar2,
505: p_attribute5 in varchar2 default hr_api.g_varchar2,
506: p_attribute6 in varchar2 default hr_api.g_varchar2,
507: p_attribute7 in varchar2 default hr_api.g_varchar2,
508: p_attribute8 in varchar2 default hr_api.g_varchar2,
509: p_attribute9 in varchar2 default hr_api.g_varchar2,
502: p_attribute2 in varchar2 default hr_api.g_varchar2,
503: p_attribute3 in varchar2 default hr_api.g_varchar2,
504: p_attribute4 in varchar2 default hr_api.g_varchar2,
505: p_attribute5 in varchar2 default hr_api.g_varchar2,
506: p_attribute6 in varchar2 default hr_api.g_varchar2,
507: p_attribute7 in varchar2 default hr_api.g_varchar2,
508: p_attribute8 in varchar2 default hr_api.g_varchar2,
509: p_attribute9 in varchar2 default hr_api.g_varchar2,
510: p_attribute10 in varchar2 default hr_api.g_varchar2,
503: p_attribute3 in varchar2 default hr_api.g_varchar2,
504: p_attribute4 in varchar2 default hr_api.g_varchar2,
505: p_attribute5 in varchar2 default hr_api.g_varchar2,
506: p_attribute6 in varchar2 default hr_api.g_varchar2,
507: p_attribute7 in varchar2 default hr_api.g_varchar2,
508: p_attribute8 in varchar2 default hr_api.g_varchar2,
509: p_attribute9 in varchar2 default hr_api.g_varchar2,
510: p_attribute10 in varchar2 default hr_api.g_varchar2,
511: p_attribute11 in varchar2 default hr_api.g_varchar2,
504: p_attribute4 in varchar2 default hr_api.g_varchar2,
505: p_attribute5 in varchar2 default hr_api.g_varchar2,
506: p_attribute6 in varchar2 default hr_api.g_varchar2,
507: p_attribute7 in varchar2 default hr_api.g_varchar2,
508: p_attribute8 in varchar2 default hr_api.g_varchar2,
509: p_attribute9 in varchar2 default hr_api.g_varchar2,
510: p_attribute10 in varchar2 default hr_api.g_varchar2,
511: p_attribute11 in varchar2 default hr_api.g_varchar2,
512: p_attribute12 in varchar2 default hr_api.g_varchar2,
505: p_attribute5 in varchar2 default hr_api.g_varchar2,
506: p_attribute6 in varchar2 default hr_api.g_varchar2,
507: p_attribute7 in varchar2 default hr_api.g_varchar2,
508: p_attribute8 in varchar2 default hr_api.g_varchar2,
509: p_attribute9 in varchar2 default hr_api.g_varchar2,
510: p_attribute10 in varchar2 default hr_api.g_varchar2,
511: p_attribute11 in varchar2 default hr_api.g_varchar2,
512: p_attribute12 in varchar2 default hr_api.g_varchar2,
513: p_attribute13 in varchar2 default hr_api.g_varchar2,
506: p_attribute6 in varchar2 default hr_api.g_varchar2,
507: p_attribute7 in varchar2 default hr_api.g_varchar2,
508: p_attribute8 in varchar2 default hr_api.g_varchar2,
509: p_attribute9 in varchar2 default hr_api.g_varchar2,
510: p_attribute10 in varchar2 default hr_api.g_varchar2,
511: p_attribute11 in varchar2 default hr_api.g_varchar2,
512: p_attribute12 in varchar2 default hr_api.g_varchar2,
513: p_attribute13 in varchar2 default hr_api.g_varchar2,
514: p_attribute14 in varchar2 default hr_api.g_varchar2,
507: p_attribute7 in varchar2 default hr_api.g_varchar2,
508: p_attribute8 in varchar2 default hr_api.g_varchar2,
509: p_attribute9 in varchar2 default hr_api.g_varchar2,
510: p_attribute10 in varchar2 default hr_api.g_varchar2,
511: p_attribute11 in varchar2 default hr_api.g_varchar2,
512: p_attribute12 in varchar2 default hr_api.g_varchar2,
513: p_attribute13 in varchar2 default hr_api.g_varchar2,
514: p_attribute14 in varchar2 default hr_api.g_varchar2,
515: p_attribute15 in varchar2 default hr_api.g_varchar2,
508: p_attribute8 in varchar2 default hr_api.g_varchar2,
509: p_attribute9 in varchar2 default hr_api.g_varchar2,
510: p_attribute10 in varchar2 default hr_api.g_varchar2,
511: p_attribute11 in varchar2 default hr_api.g_varchar2,
512: p_attribute12 in varchar2 default hr_api.g_varchar2,
513: p_attribute13 in varchar2 default hr_api.g_varchar2,
514: p_attribute14 in varchar2 default hr_api.g_varchar2,
515: p_attribute15 in varchar2 default hr_api.g_varchar2,
516: p_attribute16 in varchar2 default hr_api.g_varchar2,
509: p_attribute9 in varchar2 default hr_api.g_varchar2,
510: p_attribute10 in varchar2 default hr_api.g_varchar2,
511: p_attribute11 in varchar2 default hr_api.g_varchar2,
512: p_attribute12 in varchar2 default hr_api.g_varchar2,
513: p_attribute13 in varchar2 default hr_api.g_varchar2,
514: p_attribute14 in varchar2 default hr_api.g_varchar2,
515: p_attribute15 in varchar2 default hr_api.g_varchar2,
516: p_attribute16 in varchar2 default hr_api.g_varchar2,
517: p_attribute17 in varchar2 default hr_api.g_varchar2,
510: p_attribute10 in varchar2 default hr_api.g_varchar2,
511: p_attribute11 in varchar2 default hr_api.g_varchar2,
512: p_attribute12 in varchar2 default hr_api.g_varchar2,
513: p_attribute13 in varchar2 default hr_api.g_varchar2,
514: p_attribute14 in varchar2 default hr_api.g_varchar2,
515: p_attribute15 in varchar2 default hr_api.g_varchar2,
516: p_attribute16 in varchar2 default hr_api.g_varchar2,
517: p_attribute17 in varchar2 default hr_api.g_varchar2,
518: p_attribute18 in varchar2 default hr_api.g_varchar2,
511: p_attribute11 in varchar2 default hr_api.g_varchar2,
512: p_attribute12 in varchar2 default hr_api.g_varchar2,
513: p_attribute13 in varchar2 default hr_api.g_varchar2,
514: p_attribute14 in varchar2 default hr_api.g_varchar2,
515: p_attribute15 in varchar2 default hr_api.g_varchar2,
516: p_attribute16 in varchar2 default hr_api.g_varchar2,
517: p_attribute17 in varchar2 default hr_api.g_varchar2,
518: p_attribute18 in varchar2 default hr_api.g_varchar2,
519: p_attribute19 in varchar2 default hr_api.g_varchar2,
512: p_attribute12 in varchar2 default hr_api.g_varchar2,
513: p_attribute13 in varchar2 default hr_api.g_varchar2,
514: p_attribute14 in varchar2 default hr_api.g_varchar2,
515: p_attribute15 in varchar2 default hr_api.g_varchar2,
516: p_attribute16 in varchar2 default hr_api.g_varchar2,
517: p_attribute17 in varchar2 default hr_api.g_varchar2,
518: p_attribute18 in varchar2 default hr_api.g_varchar2,
519: p_attribute19 in varchar2 default hr_api.g_varchar2,
520: p_attribute20 in varchar2 default hr_api.g_varchar2,
513: p_attribute13 in varchar2 default hr_api.g_varchar2,
514: p_attribute14 in varchar2 default hr_api.g_varchar2,
515: p_attribute15 in varchar2 default hr_api.g_varchar2,
516: p_attribute16 in varchar2 default hr_api.g_varchar2,
517: p_attribute17 in varchar2 default hr_api.g_varchar2,
518: p_attribute18 in varchar2 default hr_api.g_varchar2,
519: p_attribute19 in varchar2 default hr_api.g_varchar2,
520: p_attribute20 in varchar2 default hr_api.g_varchar2,
521: p_effective_date in date
514: p_attribute14 in varchar2 default hr_api.g_varchar2,
515: p_attribute15 in varchar2 default hr_api.g_varchar2,
516: p_attribute16 in varchar2 default hr_api.g_varchar2,
517: p_attribute17 in varchar2 default hr_api.g_varchar2,
518: p_attribute18 in varchar2 default hr_api.g_varchar2,
519: p_attribute19 in varchar2 default hr_api.g_varchar2,
520: p_attribute20 in varchar2 default hr_api.g_varchar2,
521: p_effective_date in date
522: ) is
515: p_attribute15 in varchar2 default hr_api.g_varchar2,
516: p_attribute16 in varchar2 default hr_api.g_varchar2,
517: p_attribute17 in varchar2 default hr_api.g_varchar2,
518: p_attribute18 in varchar2 default hr_api.g_varchar2,
519: p_attribute19 in varchar2 default hr_api.g_varchar2,
520: p_attribute20 in varchar2 default hr_api.g_varchar2,
521: p_effective_date in date
522: ) is
523: --
516: p_attribute16 in varchar2 default hr_api.g_varchar2,
517: p_attribute17 in varchar2 default hr_api.g_varchar2,
518: p_attribute18 in varchar2 default hr_api.g_varchar2,
519: p_attribute19 in varchar2 default hr_api.g_varchar2,
520: p_attribute20 in varchar2 default hr_api.g_varchar2,
521: p_effective_date in date
522: ) is
523: --
524: l_rec per_grs_shd.g_rec_type;