APPS.GHR_PDI_UPD dependencies on HR_API

Line 125: When hr_api.check_integrity_violated Then

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));

Line 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

Line 130: When hr_api.parent_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
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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

Line 135: When hr_api.unique_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
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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;

Line 331: when hr_api.cannot_find_prog_unit then

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: );

Line 332: hr_api.cannot_find_prog_unit_error

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;

Line 400: If (p_rec.routing_group_id = hr_api.g_number) then

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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:

Line 463: If (p_rec.supervisor_name = hr_api.g_varchar2) then

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

Line 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

Line 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:

Line 476: If (p_rec.manager_name = hr_api.g_varchar2) then

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

Line 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

Line 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:

Line 489: If (p_rec.classifier_name = hr_api.g_varchar2) then

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

Line 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

Line 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:

Line 504: If (p_rec.attribute_category = hr_api.g_varchar2) then

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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: --

Line 647: p_routing_group_id in number default hr_api.g_number,

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,

Line 648: p_date_from in date default hr_api.g_date,

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,

Line 649: p_date_to in date default hr_api.g_date,

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,

Line 650: p_opm_cert_num 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,

Line 651: p_flsa in varchar2 default hr_api.g_varchar2,

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,

Line 652: p_financial_statement 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,

Line 653: p_subject_to_ia_action 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,

Line 654: p_position_status in number default hr_api.g_number,

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,

Line 655: p_position_is 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,

Line 656: p_position_sensitivity 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,

Line 657: p_competitive_level 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,

Line 658: p_pd_remarks 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,

Line 659: p_position_class_std 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,

Line 660: p_category 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,

Line 661: p_career_ladder 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,
665: p_manager_name in varchar2 default hr_api.g_varchar2,

Line 662: p_supervisor_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,

Line 663: p_supervisor_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,

Line 664: p_supervisor_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,

Line 665: p_manager_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,

Line 666: p_manager_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,

Line 667: p_manager_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,

Line 668: p_classifier_name 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,

Line 669: p_classifier_title 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,

Line 670: p_classifier_date in date default hr_api.g_date,

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,

Line 671: p_attribute_category 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,

Line 672: p_attribute1 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,

Line 673: p_attribute2 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,

Line 674: p_attribute3 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,

Line 675: p_attribute4 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,

Line 676: p_attribute5 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,

Line 677: p_attribute6 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,

Line 678: p_attribute7 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,

Line 679: p_attribute8 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,

Line 680: p_attribute9 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,

Line 681: p_attribute10 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,

Line 682: p_attribute11 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,

Line 683: p_attribute12 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,

Line 684: p_attribute13 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,

Line 685: p_attribute14 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,

Line 686: p_attribute15 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,

Line 687: p_attribute16 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,

Line 688: p_attribute17 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,

Line 689: p_attribute18 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,
693: p_object_version_number in out nocopy number

Line 690: p_attribute19 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
694: ) is

Line 691: p_attribute20 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
695: --

Line 692: p_business_group_id in number default hr_api.g_number,

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;