121: --
122: hr_utility.set_location(' Leaving:'||l_proc, 10);
123: --
124: Exception
125: When hr_api.check_integrity_violated Then
126: -- A check constraint has been violated
127: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status
128: ghr_pdi_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When hr_api.check_integrity_violated Then
126: -- A check constraint has been violated
127: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status
128: ghr_pdi_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.parent_integrity_violated Then
131: -- Parent integrity has been violated
132: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status
133: ghr_pdi_shd.constraint_error
126: -- A check constraint has been violated
127: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status
128: ghr_pdi_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.parent_integrity_violated Then
131: -- Parent integrity has been violated
132: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status
133: ghr_pdi_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.parent_integrity_violated Then
131: -- Parent integrity has been violated
132: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status
133: ghr_pdi_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.unique_integrity_violated Then
136: -- Unique integrity has been violated
137: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status
138: ghr_pdi_shd.constraint_error
131: -- Parent integrity has been violated
132: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status
133: ghr_pdi_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.unique_integrity_violated Then
136: -- Unique integrity has been violated
137: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status
138: ghr_pdi_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.unique_integrity_violated Then
136: -- Unique integrity has been violated
137: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status
138: ghr_pdi_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When Others Then
141: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status
142: Raise;
143: End update_dml;
327: p_object_version_number_o => ghr_pdi_shd.g_old_rec.object_version_number
328: );
329:
330: exception
331: when hr_api.cannot_find_prog_unit then
332: hr_api.cannot_find_prog_unit_error
333: ( p_module_name => 'GHR_POSITION_DESCRIPTIONS'
334: ,p_hook_type => 'AU'
335: );
328: );
329:
330: exception
331: when hr_api.cannot_find_prog_unit then
332: hr_api.cannot_find_prog_unit_error
333: ( p_module_name => 'GHR_POSITION_DESCRIPTIONS'
334: ,p_hook_type => 'AU'
335: );
336: end;
396: -- p_rec plsql record structure
397: -- to see if a system default is being used. If a system default
398: -- is being used then we must set to the 'current' argument value.
399: --
400: If (p_rec.routing_group_id = hr_api.g_number) then
401: p_rec.routing_group_id :=
402: ghr_pdi_shd.g_old_rec.routing_group_id;
403: End If;
404: If (p_rec.date_from = hr_api.g_date) then
400: If (p_rec.routing_group_id = hr_api.g_number) then
401: p_rec.routing_group_id :=
402: ghr_pdi_shd.g_old_rec.routing_group_id;
403: End If;
404: If (p_rec.date_from = hr_api.g_date) then
405: p_rec.date_from :=
406: ghr_pdi_shd.g_old_rec.date_from;
407: End If;
408: If (p_rec.date_to = hr_api.g_date) then
404: If (p_rec.date_from = hr_api.g_date) then
405: p_rec.date_from :=
406: ghr_pdi_shd.g_old_rec.date_from;
407: End If;
408: If (p_rec.date_to = hr_api.g_date) then
409: p_rec.date_to :=
410: ghr_pdi_shd.g_old_rec.date_to;
411: End If;
412: If (p_rec.opm_cert_num = hr_api.g_varchar2) then
408: If (p_rec.date_to = hr_api.g_date) then
409: p_rec.date_to :=
410: ghr_pdi_shd.g_old_rec.date_to;
411: End If;
412: If (p_rec.opm_cert_num = hr_api.g_varchar2) then
413: p_rec.opm_cert_num :=
414: ghr_pdi_shd.g_old_rec.opm_cert_num;
415: End If;
416: If (p_rec.flsa = hr_api.g_varchar2) then
412: If (p_rec.opm_cert_num = hr_api.g_varchar2) then
413: p_rec.opm_cert_num :=
414: ghr_pdi_shd.g_old_rec.opm_cert_num;
415: End If;
416: If (p_rec.flsa = hr_api.g_varchar2) then
417: p_rec.flsa :=
418: ghr_pdi_shd.g_old_rec.flsa;
419: End If;
420: If (p_rec.financial_statement = hr_api.g_varchar2) then
416: If (p_rec.flsa = hr_api.g_varchar2) then
417: p_rec.flsa :=
418: ghr_pdi_shd.g_old_rec.flsa;
419: End If;
420: If (p_rec.financial_statement = hr_api.g_varchar2) then
421: p_rec.financial_statement :=
422: ghr_pdi_shd.g_old_rec.financial_statement;
423: End If;
424: If (p_rec.subject_to_ia_action = hr_api.g_varchar2) then
420: If (p_rec.financial_statement = hr_api.g_varchar2) then
421: p_rec.financial_statement :=
422: ghr_pdi_shd.g_old_rec.financial_statement;
423: End If;
424: If (p_rec.subject_to_ia_action = hr_api.g_varchar2) then
425: p_rec.subject_to_ia_action :=
426: ghr_pdi_shd.g_old_rec.subject_to_ia_action;
427: End If;
428: If (p_rec.position_status = hr_api.g_number) then
424: If (p_rec.subject_to_ia_action = hr_api.g_varchar2) then
425: p_rec.subject_to_ia_action :=
426: ghr_pdi_shd.g_old_rec.subject_to_ia_action;
427: End If;
428: If (p_rec.position_status = hr_api.g_number) then
429: p_rec.position_status :=
430: ghr_pdi_shd.g_old_rec.position_status;
431: End If;
432: If (p_rec.position_is = hr_api.g_varchar2) then
428: If (p_rec.position_status = hr_api.g_number) then
429: p_rec.position_status :=
430: ghr_pdi_shd.g_old_rec.position_status;
431: End If;
432: If (p_rec.position_is = hr_api.g_varchar2) then
433: p_rec.position_is :=
434: ghr_pdi_shd.g_old_rec.position_is;
435: End If;
436: If (p_rec.position_sensitivity = hr_api.g_varchar2) then
432: If (p_rec.position_is = hr_api.g_varchar2) then
433: p_rec.position_is :=
434: ghr_pdi_shd.g_old_rec.position_is;
435: End If;
436: If (p_rec.position_sensitivity = hr_api.g_varchar2) then
437: p_rec.position_sensitivity :=
438: ghr_pdi_shd.g_old_rec.position_sensitivity;
439: End If;
440: If (p_rec.competitive_level = hr_api.g_varchar2) then
436: If (p_rec.position_sensitivity = hr_api.g_varchar2) then
437: p_rec.position_sensitivity :=
438: ghr_pdi_shd.g_old_rec.position_sensitivity;
439: End If;
440: If (p_rec.competitive_level = hr_api.g_varchar2) then
441: p_rec.competitive_level :=
442: ghr_pdi_shd.g_old_rec.competitive_level;
443: End If;
444: If (p_rec.pd_remarks = hr_api.g_varchar2) then
440: If (p_rec.competitive_level = hr_api.g_varchar2) then
441: p_rec.competitive_level :=
442: ghr_pdi_shd.g_old_rec.competitive_level;
443: End If;
444: If (p_rec.pd_remarks = hr_api.g_varchar2) then
445: p_rec.pd_remarks :=
446: ghr_pdi_shd.g_old_rec.pd_remarks;
447: End If;
448: If (p_rec.position_class_std = hr_api.g_varchar2) then
444: If (p_rec.pd_remarks = hr_api.g_varchar2) then
445: p_rec.pd_remarks :=
446: ghr_pdi_shd.g_old_rec.pd_remarks;
447: End If;
448: If (p_rec.position_class_std = hr_api.g_varchar2) then
449: p_rec.position_class_std :=
450: ghr_pdi_shd.g_old_rec.position_class_std;
451: End If;
452: If (p_rec.category = hr_api.g_varchar2) then
448: If (p_rec.position_class_std = hr_api.g_varchar2) then
449: p_rec.position_class_std :=
450: ghr_pdi_shd.g_old_rec.position_class_std;
451: End If;
452: If (p_rec.category = hr_api.g_varchar2) then
453: p_rec.category :=
454: ghr_pdi_shd.g_old_rec.category;
455: End If;
456: If (p_rec.career_ladder = hr_api.g_varchar2) then
452: If (p_rec.category = hr_api.g_varchar2) then
453: p_rec.category :=
454: ghr_pdi_shd.g_old_rec.category;
455: End If;
456: If (p_rec.career_ladder = hr_api.g_varchar2) then
457: p_rec.career_ladder :=
458: ghr_pdi_shd.g_old_rec.career_ladder;
459: End If;
460:
459: End If;
460:
461: /* Added by Dinkar. Karumuri for PD Phase II */
462:
463: If (p_rec.supervisor_name = hr_api.g_varchar2) then
464: p_rec.supervisor_name :=
465: ghr_pdi_shd.g_old_rec.supervisor_name;
466: End If;
467: If (p_rec.supervisor_title = hr_api.g_varchar2) then
463: If (p_rec.supervisor_name = hr_api.g_varchar2) then
464: p_rec.supervisor_name :=
465: ghr_pdi_shd.g_old_rec.supervisor_name;
466: End If;
467: If (p_rec.supervisor_title = hr_api.g_varchar2) then
468: p_rec.supervisor_title :=
469: ghr_pdi_shd.g_old_rec.supervisor_title;
470: End If;
471: If (p_rec.supervisor_date = hr_api.g_date) then
467: If (p_rec.supervisor_title = hr_api.g_varchar2) then
468: p_rec.supervisor_title :=
469: ghr_pdi_shd.g_old_rec.supervisor_title;
470: End If;
471: If (p_rec.supervisor_date = hr_api.g_date) then
472: p_rec.supervisor_date :=
473: ghr_pdi_shd.g_old_rec.supervisor_date;
474: End If;
475:
472: p_rec.supervisor_date :=
473: ghr_pdi_shd.g_old_rec.supervisor_date;
474: End If;
475:
476: If (p_rec.manager_name = hr_api.g_varchar2) then
477: p_rec.manager_name :=
478: ghr_pdi_shd.g_old_rec.manager_name;
479: End If;
480: If (p_rec.manager_title = hr_api.g_varchar2) then
476: If (p_rec.manager_name = hr_api.g_varchar2) then
477: p_rec.manager_name :=
478: ghr_pdi_shd.g_old_rec.manager_name;
479: End If;
480: If (p_rec.manager_title = hr_api.g_varchar2) then
481: p_rec.manager_title :=
482: ghr_pdi_shd.g_old_rec.manager_title;
483: End If;
484: If (p_rec.manager_date = hr_api.g_date) then
480: If (p_rec.manager_title = hr_api.g_varchar2) then
481: p_rec.manager_title :=
482: ghr_pdi_shd.g_old_rec.manager_title;
483: End If;
484: If (p_rec.manager_date = hr_api.g_date) then
485: p_rec.manager_date :=
486: ghr_pdi_shd.g_old_rec.manager_date;
487: End If;
488:
485: p_rec.manager_date :=
486: ghr_pdi_shd.g_old_rec.manager_date;
487: End If;
488:
489: If (p_rec.classifier_name = hr_api.g_varchar2) then
490: p_rec.classifier_name :=
491: ghr_pdi_shd.g_old_rec.classifier_name;
492: End If;
493: If (p_rec.classifier_title = hr_api.g_varchar2) then
489: If (p_rec.classifier_name = hr_api.g_varchar2) then
490: p_rec.classifier_name :=
491: ghr_pdi_shd.g_old_rec.classifier_name;
492: End If;
493: If (p_rec.classifier_title = hr_api.g_varchar2) then
494: p_rec.classifier_title :=
495: ghr_pdi_shd.g_old_rec.classifier_title;
496: End If;
497: If (p_rec.classifier_date = hr_api.g_date) then
493: If (p_rec.classifier_title = hr_api.g_varchar2) then
494: p_rec.classifier_title :=
495: ghr_pdi_shd.g_old_rec.classifier_title;
496: End If;
497: If (p_rec.classifier_date = hr_api.g_date) then
498: p_rec.classifier_date :=
499: ghr_pdi_shd.g_old_rec.classifier_date;
500: End If;
501:
500: End If;
501:
502: ---------------------------------------------------------------------------
503:
504: If (p_rec.attribute_category = hr_api.g_varchar2) then
505: p_rec.attribute_category :=
506: ghr_pdi_shd.g_old_rec.attribute_category;
507: End If;
508: If (p_rec.attribute1 = hr_api.g_varchar2) then
504: If (p_rec.attribute_category = hr_api.g_varchar2) then
505: p_rec.attribute_category :=
506: ghr_pdi_shd.g_old_rec.attribute_category;
507: End If;
508: If (p_rec.attribute1 = hr_api.g_varchar2) then
509: p_rec.attribute1 :=
510: ghr_pdi_shd.g_old_rec.attribute1;
511: End If;
512: If (p_rec.attribute2 = hr_api.g_varchar2) then
508: If (p_rec.attribute1 = hr_api.g_varchar2) then
509: p_rec.attribute1 :=
510: ghr_pdi_shd.g_old_rec.attribute1;
511: End If;
512: If (p_rec.attribute2 = hr_api.g_varchar2) then
513: p_rec.attribute2 :=
514: ghr_pdi_shd.g_old_rec.attribute2;
515: End If;
516: If (p_rec.attribute3 = hr_api.g_varchar2) then
512: If (p_rec.attribute2 = hr_api.g_varchar2) then
513: p_rec.attribute2 :=
514: ghr_pdi_shd.g_old_rec.attribute2;
515: End If;
516: If (p_rec.attribute3 = hr_api.g_varchar2) then
517: p_rec.attribute3 :=
518: ghr_pdi_shd.g_old_rec.attribute3;
519: End If;
520: If (p_rec.attribute4 = hr_api.g_varchar2) then
516: If (p_rec.attribute3 = hr_api.g_varchar2) then
517: p_rec.attribute3 :=
518: ghr_pdi_shd.g_old_rec.attribute3;
519: End If;
520: If (p_rec.attribute4 = hr_api.g_varchar2) then
521: p_rec.attribute4 :=
522: ghr_pdi_shd.g_old_rec.attribute4;
523: End If;
524: If (p_rec.attribute5 = hr_api.g_varchar2) then
520: If (p_rec.attribute4 = hr_api.g_varchar2) then
521: p_rec.attribute4 :=
522: ghr_pdi_shd.g_old_rec.attribute4;
523: End If;
524: If (p_rec.attribute5 = hr_api.g_varchar2) then
525: p_rec.attribute5 :=
526: ghr_pdi_shd.g_old_rec.attribute5;
527: End If;
528: If (p_rec.attribute6 = hr_api.g_varchar2) then
524: If (p_rec.attribute5 = hr_api.g_varchar2) then
525: p_rec.attribute5 :=
526: ghr_pdi_shd.g_old_rec.attribute5;
527: End If;
528: If (p_rec.attribute6 = hr_api.g_varchar2) then
529: p_rec.attribute6 :=
530: ghr_pdi_shd.g_old_rec.attribute6;
531: End If;
532: If (p_rec.attribute7 = hr_api.g_varchar2) then
528: If (p_rec.attribute6 = hr_api.g_varchar2) then
529: p_rec.attribute6 :=
530: ghr_pdi_shd.g_old_rec.attribute6;
531: End If;
532: If (p_rec.attribute7 = hr_api.g_varchar2) then
533: p_rec.attribute7 :=
534: ghr_pdi_shd.g_old_rec.attribute7;
535: End If;
536: If (p_rec.attribute8 = hr_api.g_varchar2) then
532: If (p_rec.attribute7 = hr_api.g_varchar2) then
533: p_rec.attribute7 :=
534: ghr_pdi_shd.g_old_rec.attribute7;
535: End If;
536: If (p_rec.attribute8 = hr_api.g_varchar2) then
537: p_rec.attribute8 :=
538: ghr_pdi_shd.g_old_rec.attribute8;
539: End If;
540: If (p_rec.attribute9 = hr_api.g_varchar2) then
536: If (p_rec.attribute8 = hr_api.g_varchar2) then
537: p_rec.attribute8 :=
538: ghr_pdi_shd.g_old_rec.attribute8;
539: End If;
540: If (p_rec.attribute9 = hr_api.g_varchar2) then
541: p_rec.attribute9 :=
542: ghr_pdi_shd.g_old_rec.attribute9;
543: End If;
544: If (p_rec.attribute10 = hr_api.g_varchar2) then
540: If (p_rec.attribute9 = hr_api.g_varchar2) then
541: p_rec.attribute9 :=
542: ghr_pdi_shd.g_old_rec.attribute9;
543: End If;
544: If (p_rec.attribute10 = hr_api.g_varchar2) then
545: p_rec.attribute10 :=
546: ghr_pdi_shd.g_old_rec.attribute10;
547: End If;
548: If (p_rec.attribute11 = hr_api.g_varchar2) then
544: If (p_rec.attribute10 = hr_api.g_varchar2) then
545: p_rec.attribute10 :=
546: ghr_pdi_shd.g_old_rec.attribute10;
547: End If;
548: If (p_rec.attribute11 = hr_api.g_varchar2) then
549: p_rec.attribute11 :=
550: ghr_pdi_shd.g_old_rec.attribute11;
551: End If;
552: If (p_rec.attribute12 = hr_api.g_varchar2) then
548: If (p_rec.attribute11 = hr_api.g_varchar2) then
549: p_rec.attribute11 :=
550: ghr_pdi_shd.g_old_rec.attribute11;
551: End If;
552: If (p_rec.attribute12 = hr_api.g_varchar2) then
553: p_rec.attribute12 :=
554: ghr_pdi_shd.g_old_rec.attribute12;
555: End If;
556: If (p_rec.attribute13 = hr_api.g_varchar2) then
552: If (p_rec.attribute12 = hr_api.g_varchar2) then
553: p_rec.attribute12 :=
554: ghr_pdi_shd.g_old_rec.attribute12;
555: End If;
556: If (p_rec.attribute13 = hr_api.g_varchar2) then
557: p_rec.attribute13 :=
558: ghr_pdi_shd.g_old_rec.attribute13;
559: End If;
560: If (p_rec.attribute14 = hr_api.g_varchar2) then
556: If (p_rec.attribute13 = hr_api.g_varchar2) then
557: p_rec.attribute13 :=
558: ghr_pdi_shd.g_old_rec.attribute13;
559: End If;
560: If (p_rec.attribute14 = hr_api.g_varchar2) then
561: p_rec.attribute14 :=
562: ghr_pdi_shd.g_old_rec.attribute14;
563: End If;
564: If (p_rec.attribute15 = hr_api.g_varchar2) then
560: If (p_rec.attribute14 = hr_api.g_varchar2) then
561: p_rec.attribute14 :=
562: ghr_pdi_shd.g_old_rec.attribute14;
563: End If;
564: If (p_rec.attribute15 = hr_api.g_varchar2) then
565: p_rec.attribute15 :=
566: ghr_pdi_shd.g_old_rec.attribute15;
567: End If;
568: If (p_rec.attribute16 = hr_api.g_varchar2) then
564: If (p_rec.attribute15 = hr_api.g_varchar2) then
565: p_rec.attribute15 :=
566: ghr_pdi_shd.g_old_rec.attribute15;
567: End If;
568: If (p_rec.attribute16 = hr_api.g_varchar2) then
569: p_rec.attribute16 :=
570: ghr_pdi_shd.g_old_rec.attribute16;
571: End If;
572: If (p_rec.attribute17 = hr_api.g_varchar2) then
568: If (p_rec.attribute16 = hr_api.g_varchar2) then
569: p_rec.attribute16 :=
570: ghr_pdi_shd.g_old_rec.attribute16;
571: End If;
572: If (p_rec.attribute17 = hr_api.g_varchar2) then
573: p_rec.attribute17 :=
574: ghr_pdi_shd.g_old_rec.attribute17;
575: End If;
576: If (p_rec.attribute18 = hr_api.g_varchar2) then
572: If (p_rec.attribute17 = hr_api.g_varchar2) then
573: p_rec.attribute17 :=
574: ghr_pdi_shd.g_old_rec.attribute17;
575: End If;
576: If (p_rec.attribute18 = hr_api.g_varchar2) then
577: p_rec.attribute18 :=
578: ghr_pdi_shd.g_old_rec.attribute18;
579: End If;
580: If (p_rec.attribute19 = hr_api.g_varchar2) then
576: If (p_rec.attribute18 = hr_api.g_varchar2) then
577: p_rec.attribute18 :=
578: ghr_pdi_shd.g_old_rec.attribute18;
579: End If;
580: If (p_rec.attribute19 = hr_api.g_varchar2) then
581: p_rec.attribute19 :=
582: ghr_pdi_shd.g_old_rec.attribute19;
583: End If;
584: If (p_rec.attribute20 = hr_api.g_varchar2) then
580: If (p_rec.attribute19 = hr_api.g_varchar2) then
581: p_rec.attribute19 :=
582: ghr_pdi_shd.g_old_rec.attribute19;
583: End If;
584: If (p_rec.attribute20 = hr_api.g_varchar2) then
585: p_rec.attribute20 :=
586: ghr_pdi_shd.g_old_rec.attribute20;
587: End If;
588: If (p_rec.business_group_id = hr_api.g_number) then
584: If (p_rec.attribute20 = hr_api.g_varchar2) then
585: p_rec.attribute20 :=
586: ghr_pdi_shd.g_old_rec.attribute20;
587: End If;
588: If (p_rec.business_group_id = hr_api.g_number) then
589: p_rec.business_group_id :=
590: ghr_pdi_shd.g_old_rec.business_group_id;
591: End If;
592: --
643: -- ----------------------------------------------------------------------------
644: Procedure upd
645: (
646: p_position_description_id in number,
647: p_routing_group_id in number default hr_api.g_number,
648: p_date_from in date default hr_api.g_date,
649: p_date_to in date default hr_api.g_date,
650: p_opm_cert_num in varchar2 default hr_api.g_varchar2,
651: p_flsa in varchar2 default hr_api.g_varchar2,
644: Procedure upd
645: (
646: p_position_description_id in number,
647: p_routing_group_id in number default hr_api.g_number,
648: p_date_from in date default hr_api.g_date,
649: p_date_to in date default hr_api.g_date,
650: p_opm_cert_num in varchar2 default hr_api.g_varchar2,
651: p_flsa in varchar2 default hr_api.g_varchar2,
652: p_financial_statement in varchar2 default hr_api.g_varchar2,
645: (
646: p_position_description_id in number,
647: p_routing_group_id in number default hr_api.g_number,
648: p_date_from in date default hr_api.g_date,
649: p_date_to in date default hr_api.g_date,
650: p_opm_cert_num in varchar2 default hr_api.g_varchar2,
651: p_flsa in varchar2 default hr_api.g_varchar2,
652: p_financial_statement in varchar2 default hr_api.g_varchar2,
653: p_subject_to_ia_action in varchar2 default hr_api.g_varchar2,
646: p_position_description_id in number,
647: p_routing_group_id in number default hr_api.g_number,
648: p_date_from in date default hr_api.g_date,
649: p_date_to in date default hr_api.g_date,
650: p_opm_cert_num in varchar2 default hr_api.g_varchar2,
651: p_flsa in varchar2 default hr_api.g_varchar2,
652: p_financial_statement in varchar2 default hr_api.g_varchar2,
653: p_subject_to_ia_action in varchar2 default hr_api.g_varchar2,
654: p_position_status in number default hr_api.g_number,
647: p_routing_group_id in number default hr_api.g_number,
648: p_date_from in date default hr_api.g_date,
649: p_date_to in date default hr_api.g_date,
650: p_opm_cert_num in varchar2 default hr_api.g_varchar2,
651: p_flsa in varchar2 default hr_api.g_varchar2,
652: p_financial_statement in varchar2 default hr_api.g_varchar2,
653: p_subject_to_ia_action in varchar2 default hr_api.g_varchar2,
654: p_position_status in number default hr_api.g_number,
655: p_position_is in varchar2 default hr_api.g_varchar2,
648: p_date_from in date default hr_api.g_date,
649: p_date_to in date default hr_api.g_date,
650: p_opm_cert_num in varchar2 default hr_api.g_varchar2,
651: p_flsa in varchar2 default hr_api.g_varchar2,
652: p_financial_statement in varchar2 default hr_api.g_varchar2,
653: p_subject_to_ia_action in varchar2 default hr_api.g_varchar2,
654: p_position_status in number default hr_api.g_number,
655: p_position_is in varchar2 default hr_api.g_varchar2,
656: p_position_sensitivity in varchar2 default hr_api.g_varchar2,
649: p_date_to in date default hr_api.g_date,
650: p_opm_cert_num in varchar2 default hr_api.g_varchar2,
651: p_flsa in varchar2 default hr_api.g_varchar2,
652: p_financial_statement in varchar2 default hr_api.g_varchar2,
653: p_subject_to_ia_action in varchar2 default hr_api.g_varchar2,
654: p_position_status in number default hr_api.g_number,
655: p_position_is in varchar2 default hr_api.g_varchar2,
656: p_position_sensitivity in varchar2 default hr_api.g_varchar2,
657: p_competitive_level in varchar2 default hr_api.g_varchar2,
650: p_opm_cert_num in varchar2 default hr_api.g_varchar2,
651: p_flsa in varchar2 default hr_api.g_varchar2,
652: p_financial_statement in varchar2 default hr_api.g_varchar2,
653: p_subject_to_ia_action in varchar2 default hr_api.g_varchar2,
654: p_position_status in number default hr_api.g_number,
655: p_position_is in varchar2 default hr_api.g_varchar2,
656: p_position_sensitivity in varchar2 default hr_api.g_varchar2,
657: p_competitive_level in varchar2 default hr_api.g_varchar2,
658: p_pd_remarks in varchar2 default hr_api.g_varchar2,
651: p_flsa in varchar2 default hr_api.g_varchar2,
652: p_financial_statement in varchar2 default hr_api.g_varchar2,
653: p_subject_to_ia_action in varchar2 default hr_api.g_varchar2,
654: p_position_status in number default hr_api.g_number,
655: p_position_is in varchar2 default hr_api.g_varchar2,
656: p_position_sensitivity in varchar2 default hr_api.g_varchar2,
657: p_competitive_level in varchar2 default hr_api.g_varchar2,
658: p_pd_remarks in varchar2 default hr_api.g_varchar2,
659: p_position_class_std in varchar2 default hr_api.g_varchar2,
652: p_financial_statement in varchar2 default hr_api.g_varchar2,
653: p_subject_to_ia_action in varchar2 default hr_api.g_varchar2,
654: p_position_status in number default hr_api.g_number,
655: p_position_is in varchar2 default hr_api.g_varchar2,
656: p_position_sensitivity in varchar2 default hr_api.g_varchar2,
657: p_competitive_level in varchar2 default hr_api.g_varchar2,
658: p_pd_remarks in varchar2 default hr_api.g_varchar2,
659: p_position_class_std in varchar2 default hr_api.g_varchar2,
660: p_category in varchar2 default hr_api.g_varchar2,
653: p_subject_to_ia_action in varchar2 default hr_api.g_varchar2,
654: p_position_status in number default hr_api.g_number,
655: p_position_is in varchar2 default hr_api.g_varchar2,
656: p_position_sensitivity in varchar2 default hr_api.g_varchar2,
657: p_competitive_level in varchar2 default hr_api.g_varchar2,
658: p_pd_remarks in varchar2 default hr_api.g_varchar2,
659: p_position_class_std in varchar2 default hr_api.g_varchar2,
660: p_category in varchar2 default hr_api.g_varchar2,
661: p_career_ladder in varchar2 default hr_api.g_varchar2,
654: p_position_status in number default hr_api.g_number,
655: p_position_is in varchar2 default hr_api.g_varchar2,
656: p_position_sensitivity in varchar2 default hr_api.g_varchar2,
657: p_competitive_level in varchar2 default hr_api.g_varchar2,
658: p_pd_remarks in varchar2 default hr_api.g_varchar2,
659: p_position_class_std in varchar2 default hr_api.g_varchar2,
660: p_category in varchar2 default hr_api.g_varchar2,
661: p_career_ladder in varchar2 default hr_api.g_varchar2,
662: p_supervisor_name in varchar2 default hr_api.g_varchar2,
655: p_position_is in varchar2 default hr_api.g_varchar2,
656: p_position_sensitivity in varchar2 default hr_api.g_varchar2,
657: p_competitive_level in varchar2 default hr_api.g_varchar2,
658: p_pd_remarks in varchar2 default hr_api.g_varchar2,
659: p_position_class_std in varchar2 default hr_api.g_varchar2,
660: p_category in varchar2 default hr_api.g_varchar2,
661: p_career_ladder in varchar2 default hr_api.g_varchar2,
662: p_supervisor_name in varchar2 default hr_api.g_varchar2,
663: p_supervisor_title in varchar2 default hr_api.g_varchar2,
656: p_position_sensitivity in varchar2 default hr_api.g_varchar2,
657: p_competitive_level in varchar2 default hr_api.g_varchar2,
658: p_pd_remarks in varchar2 default hr_api.g_varchar2,
659: p_position_class_std in varchar2 default hr_api.g_varchar2,
660: p_category in varchar2 default hr_api.g_varchar2,
661: p_career_ladder in varchar2 default hr_api.g_varchar2,
662: p_supervisor_name in varchar2 default hr_api.g_varchar2,
663: p_supervisor_title in varchar2 default hr_api.g_varchar2,
664: p_supervisor_date in date default hr_api.g_date,
657: p_competitive_level in varchar2 default hr_api.g_varchar2,
658: p_pd_remarks in varchar2 default hr_api.g_varchar2,
659: p_position_class_std in varchar2 default hr_api.g_varchar2,
660: p_category in varchar2 default hr_api.g_varchar2,
661: p_career_ladder in varchar2 default hr_api.g_varchar2,
662: p_supervisor_name in varchar2 default hr_api.g_varchar2,
663: p_supervisor_title in varchar2 default hr_api.g_varchar2,
664: p_supervisor_date in date default hr_api.g_date,
665: p_manager_name in varchar2 default hr_api.g_varchar2,
658: p_pd_remarks in varchar2 default hr_api.g_varchar2,
659: p_position_class_std in varchar2 default hr_api.g_varchar2,
660: p_category in varchar2 default hr_api.g_varchar2,
661: p_career_ladder in varchar2 default hr_api.g_varchar2,
662: p_supervisor_name in varchar2 default hr_api.g_varchar2,
663: p_supervisor_title in varchar2 default hr_api.g_varchar2,
664: p_supervisor_date in date default hr_api.g_date,
665: p_manager_name in varchar2 default hr_api.g_varchar2,
666: p_manager_title in varchar2 default hr_api.g_varchar2,
659: p_position_class_std in varchar2 default hr_api.g_varchar2,
660: p_category in varchar2 default hr_api.g_varchar2,
661: p_career_ladder in varchar2 default hr_api.g_varchar2,
662: p_supervisor_name in varchar2 default hr_api.g_varchar2,
663: p_supervisor_title in varchar2 default hr_api.g_varchar2,
664: p_supervisor_date in date default hr_api.g_date,
665: p_manager_name in varchar2 default hr_api.g_varchar2,
666: p_manager_title in varchar2 default hr_api.g_varchar2,
667: p_manager_date in date default hr_api.g_date,
660: p_category in varchar2 default hr_api.g_varchar2,
661: p_career_ladder in varchar2 default hr_api.g_varchar2,
662: p_supervisor_name in varchar2 default hr_api.g_varchar2,
663: p_supervisor_title in varchar2 default hr_api.g_varchar2,
664: p_supervisor_date in date default hr_api.g_date,
665: p_manager_name in varchar2 default hr_api.g_varchar2,
666: p_manager_title in varchar2 default hr_api.g_varchar2,
667: p_manager_date in date default hr_api.g_date,
668: p_classifier_name in varchar2 default hr_api.g_varchar2,
661: p_career_ladder in varchar2 default hr_api.g_varchar2,
662: p_supervisor_name in varchar2 default hr_api.g_varchar2,
663: p_supervisor_title in varchar2 default hr_api.g_varchar2,
664: p_supervisor_date in date default hr_api.g_date,
665: p_manager_name in varchar2 default hr_api.g_varchar2,
666: p_manager_title in varchar2 default hr_api.g_varchar2,
667: p_manager_date in date default hr_api.g_date,
668: p_classifier_name in varchar2 default hr_api.g_varchar2,
669: p_classifier_title in varchar2 default hr_api.g_varchar2,
662: p_supervisor_name in varchar2 default hr_api.g_varchar2,
663: p_supervisor_title in varchar2 default hr_api.g_varchar2,
664: p_supervisor_date in date default hr_api.g_date,
665: p_manager_name in varchar2 default hr_api.g_varchar2,
666: p_manager_title in varchar2 default hr_api.g_varchar2,
667: p_manager_date in date default hr_api.g_date,
668: p_classifier_name in varchar2 default hr_api.g_varchar2,
669: p_classifier_title in varchar2 default hr_api.g_varchar2,
670: p_classifier_date in date default hr_api.g_date,
663: p_supervisor_title in varchar2 default hr_api.g_varchar2,
664: p_supervisor_date in date default hr_api.g_date,
665: p_manager_name in varchar2 default hr_api.g_varchar2,
666: p_manager_title in varchar2 default hr_api.g_varchar2,
667: p_manager_date in date default hr_api.g_date,
668: p_classifier_name in varchar2 default hr_api.g_varchar2,
669: p_classifier_title in varchar2 default hr_api.g_varchar2,
670: p_classifier_date in date default hr_api.g_date,
671: p_attribute_category in varchar2 default hr_api.g_varchar2,
664: p_supervisor_date in date default hr_api.g_date,
665: p_manager_name in varchar2 default hr_api.g_varchar2,
666: p_manager_title in varchar2 default hr_api.g_varchar2,
667: p_manager_date in date default hr_api.g_date,
668: p_classifier_name in varchar2 default hr_api.g_varchar2,
669: p_classifier_title in varchar2 default hr_api.g_varchar2,
670: p_classifier_date in date default hr_api.g_date,
671: p_attribute_category in varchar2 default hr_api.g_varchar2,
672: p_attribute1 in varchar2 default hr_api.g_varchar2,
665: p_manager_name in varchar2 default hr_api.g_varchar2,
666: p_manager_title in varchar2 default hr_api.g_varchar2,
667: p_manager_date in date default hr_api.g_date,
668: p_classifier_name in varchar2 default hr_api.g_varchar2,
669: p_classifier_title in varchar2 default hr_api.g_varchar2,
670: p_classifier_date in date default hr_api.g_date,
671: p_attribute_category in varchar2 default hr_api.g_varchar2,
672: p_attribute1 in varchar2 default hr_api.g_varchar2,
673: p_attribute2 in varchar2 default hr_api.g_varchar2,
666: p_manager_title in varchar2 default hr_api.g_varchar2,
667: p_manager_date in date default hr_api.g_date,
668: p_classifier_name in varchar2 default hr_api.g_varchar2,
669: p_classifier_title in varchar2 default hr_api.g_varchar2,
670: p_classifier_date in date default hr_api.g_date,
671: p_attribute_category in varchar2 default hr_api.g_varchar2,
672: p_attribute1 in varchar2 default hr_api.g_varchar2,
673: p_attribute2 in varchar2 default hr_api.g_varchar2,
674: p_attribute3 in varchar2 default hr_api.g_varchar2,
667: p_manager_date in date default hr_api.g_date,
668: p_classifier_name in varchar2 default hr_api.g_varchar2,
669: p_classifier_title in varchar2 default hr_api.g_varchar2,
670: p_classifier_date in date default hr_api.g_date,
671: p_attribute_category in varchar2 default hr_api.g_varchar2,
672: p_attribute1 in varchar2 default hr_api.g_varchar2,
673: p_attribute2 in varchar2 default hr_api.g_varchar2,
674: p_attribute3 in varchar2 default hr_api.g_varchar2,
675: p_attribute4 in varchar2 default hr_api.g_varchar2,
668: p_classifier_name in varchar2 default hr_api.g_varchar2,
669: p_classifier_title in varchar2 default hr_api.g_varchar2,
670: p_classifier_date in date default hr_api.g_date,
671: p_attribute_category in varchar2 default hr_api.g_varchar2,
672: p_attribute1 in varchar2 default hr_api.g_varchar2,
673: p_attribute2 in varchar2 default hr_api.g_varchar2,
674: p_attribute3 in varchar2 default hr_api.g_varchar2,
675: p_attribute4 in varchar2 default hr_api.g_varchar2,
676: p_attribute5 in varchar2 default hr_api.g_varchar2,
669: p_classifier_title in varchar2 default hr_api.g_varchar2,
670: p_classifier_date in date default hr_api.g_date,
671: p_attribute_category in varchar2 default hr_api.g_varchar2,
672: p_attribute1 in varchar2 default hr_api.g_varchar2,
673: p_attribute2 in varchar2 default hr_api.g_varchar2,
674: p_attribute3 in varchar2 default hr_api.g_varchar2,
675: p_attribute4 in varchar2 default hr_api.g_varchar2,
676: p_attribute5 in varchar2 default hr_api.g_varchar2,
677: p_attribute6 in varchar2 default hr_api.g_varchar2,
670: p_classifier_date in date default hr_api.g_date,
671: p_attribute_category in varchar2 default hr_api.g_varchar2,
672: p_attribute1 in varchar2 default hr_api.g_varchar2,
673: p_attribute2 in varchar2 default hr_api.g_varchar2,
674: p_attribute3 in varchar2 default hr_api.g_varchar2,
675: p_attribute4 in varchar2 default hr_api.g_varchar2,
676: p_attribute5 in varchar2 default hr_api.g_varchar2,
677: p_attribute6 in varchar2 default hr_api.g_varchar2,
678: p_attribute7 in varchar2 default hr_api.g_varchar2,
671: p_attribute_category in varchar2 default hr_api.g_varchar2,
672: p_attribute1 in varchar2 default hr_api.g_varchar2,
673: p_attribute2 in varchar2 default hr_api.g_varchar2,
674: p_attribute3 in varchar2 default hr_api.g_varchar2,
675: p_attribute4 in varchar2 default hr_api.g_varchar2,
676: p_attribute5 in varchar2 default hr_api.g_varchar2,
677: p_attribute6 in varchar2 default hr_api.g_varchar2,
678: p_attribute7 in varchar2 default hr_api.g_varchar2,
679: p_attribute8 in varchar2 default hr_api.g_varchar2,
672: p_attribute1 in varchar2 default hr_api.g_varchar2,
673: p_attribute2 in varchar2 default hr_api.g_varchar2,
674: p_attribute3 in varchar2 default hr_api.g_varchar2,
675: p_attribute4 in varchar2 default hr_api.g_varchar2,
676: p_attribute5 in varchar2 default hr_api.g_varchar2,
677: p_attribute6 in varchar2 default hr_api.g_varchar2,
678: p_attribute7 in varchar2 default hr_api.g_varchar2,
679: p_attribute8 in varchar2 default hr_api.g_varchar2,
680: p_attribute9 in varchar2 default hr_api.g_varchar2,
673: p_attribute2 in varchar2 default hr_api.g_varchar2,
674: p_attribute3 in varchar2 default hr_api.g_varchar2,
675: p_attribute4 in varchar2 default hr_api.g_varchar2,
676: p_attribute5 in varchar2 default hr_api.g_varchar2,
677: p_attribute6 in varchar2 default hr_api.g_varchar2,
678: p_attribute7 in varchar2 default hr_api.g_varchar2,
679: p_attribute8 in varchar2 default hr_api.g_varchar2,
680: p_attribute9 in varchar2 default hr_api.g_varchar2,
681: p_attribute10 in varchar2 default hr_api.g_varchar2,
674: p_attribute3 in varchar2 default hr_api.g_varchar2,
675: p_attribute4 in varchar2 default hr_api.g_varchar2,
676: p_attribute5 in varchar2 default hr_api.g_varchar2,
677: p_attribute6 in varchar2 default hr_api.g_varchar2,
678: p_attribute7 in varchar2 default hr_api.g_varchar2,
679: p_attribute8 in varchar2 default hr_api.g_varchar2,
680: p_attribute9 in varchar2 default hr_api.g_varchar2,
681: p_attribute10 in varchar2 default hr_api.g_varchar2,
682: p_attribute11 in varchar2 default hr_api.g_varchar2,
675: p_attribute4 in varchar2 default hr_api.g_varchar2,
676: p_attribute5 in varchar2 default hr_api.g_varchar2,
677: p_attribute6 in varchar2 default hr_api.g_varchar2,
678: p_attribute7 in varchar2 default hr_api.g_varchar2,
679: p_attribute8 in varchar2 default hr_api.g_varchar2,
680: p_attribute9 in varchar2 default hr_api.g_varchar2,
681: p_attribute10 in varchar2 default hr_api.g_varchar2,
682: p_attribute11 in varchar2 default hr_api.g_varchar2,
683: p_attribute12 in varchar2 default hr_api.g_varchar2,
676: p_attribute5 in varchar2 default hr_api.g_varchar2,
677: p_attribute6 in varchar2 default hr_api.g_varchar2,
678: p_attribute7 in varchar2 default hr_api.g_varchar2,
679: p_attribute8 in varchar2 default hr_api.g_varchar2,
680: p_attribute9 in varchar2 default hr_api.g_varchar2,
681: p_attribute10 in varchar2 default hr_api.g_varchar2,
682: p_attribute11 in varchar2 default hr_api.g_varchar2,
683: p_attribute12 in varchar2 default hr_api.g_varchar2,
684: p_attribute13 in varchar2 default hr_api.g_varchar2,
677: p_attribute6 in varchar2 default hr_api.g_varchar2,
678: p_attribute7 in varchar2 default hr_api.g_varchar2,
679: p_attribute8 in varchar2 default hr_api.g_varchar2,
680: p_attribute9 in varchar2 default hr_api.g_varchar2,
681: p_attribute10 in varchar2 default hr_api.g_varchar2,
682: p_attribute11 in varchar2 default hr_api.g_varchar2,
683: p_attribute12 in varchar2 default hr_api.g_varchar2,
684: p_attribute13 in varchar2 default hr_api.g_varchar2,
685: p_attribute14 in varchar2 default hr_api.g_varchar2,
678: p_attribute7 in varchar2 default hr_api.g_varchar2,
679: p_attribute8 in varchar2 default hr_api.g_varchar2,
680: p_attribute9 in varchar2 default hr_api.g_varchar2,
681: p_attribute10 in varchar2 default hr_api.g_varchar2,
682: p_attribute11 in varchar2 default hr_api.g_varchar2,
683: p_attribute12 in varchar2 default hr_api.g_varchar2,
684: p_attribute13 in varchar2 default hr_api.g_varchar2,
685: p_attribute14 in varchar2 default hr_api.g_varchar2,
686: p_attribute15 in varchar2 default hr_api.g_varchar2,
679: p_attribute8 in varchar2 default hr_api.g_varchar2,
680: p_attribute9 in varchar2 default hr_api.g_varchar2,
681: p_attribute10 in varchar2 default hr_api.g_varchar2,
682: p_attribute11 in varchar2 default hr_api.g_varchar2,
683: p_attribute12 in varchar2 default hr_api.g_varchar2,
684: p_attribute13 in varchar2 default hr_api.g_varchar2,
685: p_attribute14 in varchar2 default hr_api.g_varchar2,
686: p_attribute15 in varchar2 default hr_api.g_varchar2,
687: p_attribute16 in varchar2 default hr_api.g_varchar2,
680: p_attribute9 in varchar2 default hr_api.g_varchar2,
681: p_attribute10 in varchar2 default hr_api.g_varchar2,
682: p_attribute11 in varchar2 default hr_api.g_varchar2,
683: p_attribute12 in varchar2 default hr_api.g_varchar2,
684: p_attribute13 in varchar2 default hr_api.g_varchar2,
685: p_attribute14 in varchar2 default hr_api.g_varchar2,
686: p_attribute15 in varchar2 default hr_api.g_varchar2,
687: p_attribute16 in varchar2 default hr_api.g_varchar2,
688: p_attribute17 in varchar2 default hr_api.g_varchar2,
681: p_attribute10 in varchar2 default hr_api.g_varchar2,
682: p_attribute11 in varchar2 default hr_api.g_varchar2,
683: p_attribute12 in varchar2 default hr_api.g_varchar2,
684: p_attribute13 in varchar2 default hr_api.g_varchar2,
685: p_attribute14 in varchar2 default hr_api.g_varchar2,
686: p_attribute15 in varchar2 default hr_api.g_varchar2,
687: p_attribute16 in varchar2 default hr_api.g_varchar2,
688: p_attribute17 in varchar2 default hr_api.g_varchar2,
689: p_attribute18 in varchar2 default hr_api.g_varchar2,
682: p_attribute11 in varchar2 default hr_api.g_varchar2,
683: p_attribute12 in varchar2 default hr_api.g_varchar2,
684: p_attribute13 in varchar2 default hr_api.g_varchar2,
685: p_attribute14 in varchar2 default hr_api.g_varchar2,
686: p_attribute15 in varchar2 default hr_api.g_varchar2,
687: p_attribute16 in varchar2 default hr_api.g_varchar2,
688: p_attribute17 in varchar2 default hr_api.g_varchar2,
689: p_attribute18 in varchar2 default hr_api.g_varchar2,
690: p_attribute19 in varchar2 default hr_api.g_varchar2,
683: p_attribute12 in varchar2 default hr_api.g_varchar2,
684: p_attribute13 in varchar2 default hr_api.g_varchar2,
685: p_attribute14 in varchar2 default hr_api.g_varchar2,
686: p_attribute15 in varchar2 default hr_api.g_varchar2,
687: p_attribute16 in varchar2 default hr_api.g_varchar2,
688: p_attribute17 in varchar2 default hr_api.g_varchar2,
689: p_attribute18 in varchar2 default hr_api.g_varchar2,
690: p_attribute19 in varchar2 default hr_api.g_varchar2,
691: p_attribute20 in varchar2 default hr_api.g_varchar2,
684: p_attribute13 in varchar2 default hr_api.g_varchar2,
685: p_attribute14 in varchar2 default hr_api.g_varchar2,
686: p_attribute15 in varchar2 default hr_api.g_varchar2,
687: p_attribute16 in varchar2 default hr_api.g_varchar2,
688: p_attribute17 in varchar2 default hr_api.g_varchar2,
689: p_attribute18 in varchar2 default hr_api.g_varchar2,
690: p_attribute19 in varchar2 default hr_api.g_varchar2,
691: p_attribute20 in varchar2 default hr_api.g_varchar2,
692: p_business_group_id in number default hr_api.g_number,
685: p_attribute14 in varchar2 default hr_api.g_varchar2,
686: p_attribute15 in varchar2 default hr_api.g_varchar2,
687: p_attribute16 in varchar2 default hr_api.g_varchar2,
688: p_attribute17 in varchar2 default hr_api.g_varchar2,
689: p_attribute18 in varchar2 default hr_api.g_varchar2,
690: p_attribute19 in varchar2 default hr_api.g_varchar2,
691: p_attribute20 in varchar2 default hr_api.g_varchar2,
692: p_business_group_id in number default hr_api.g_number,
693: p_object_version_number in out nocopy number
686: p_attribute15 in varchar2 default hr_api.g_varchar2,
687: p_attribute16 in varchar2 default hr_api.g_varchar2,
688: p_attribute17 in varchar2 default hr_api.g_varchar2,
689: p_attribute18 in varchar2 default hr_api.g_varchar2,
690: p_attribute19 in varchar2 default hr_api.g_varchar2,
691: p_attribute20 in varchar2 default hr_api.g_varchar2,
692: p_business_group_id in number default hr_api.g_number,
693: p_object_version_number in out nocopy number
694: ) is
687: p_attribute16 in varchar2 default hr_api.g_varchar2,
688: p_attribute17 in varchar2 default hr_api.g_varchar2,
689: p_attribute18 in varchar2 default hr_api.g_varchar2,
690: p_attribute19 in varchar2 default hr_api.g_varchar2,
691: p_attribute20 in varchar2 default hr_api.g_varchar2,
692: p_business_group_id in number default hr_api.g_number,
693: p_object_version_number in out nocopy number
694: ) is
695: --
688: p_attribute17 in varchar2 default hr_api.g_varchar2,
689: p_attribute18 in varchar2 default hr_api.g_varchar2,
690: p_attribute19 in varchar2 default hr_api.g_varchar2,
691: p_attribute20 in varchar2 default hr_api.g_varchar2,
692: p_business_group_id in number default hr_api.g_number,
693: p_object_version_number in out nocopy number
694: ) is
695: --
696: l_rec ghr_pdi_shd.g_rec_type;