575:
576: -- Rohini 07-AUG-1972
577:
578: type special_information_type is record
579: (segment1 per_analysis_criteria.segment1%type
580: ,segment2 per_analysis_criteria.segment2%type
581: ,segment3 per_analysis_criteria.segment3%type
582: ,segment4 per_analysis_criteria.segment4%type
583: ,segment5 per_analysis_criteria.segment5%type
576: -- Rohini 07-AUG-1972
577:
578: type special_information_type is record
579: (segment1 per_analysis_criteria.segment1%type
580: ,segment2 per_analysis_criteria.segment2%type
581: ,segment3 per_analysis_criteria.segment3%type
582: ,segment4 per_analysis_criteria.segment4%type
583: ,segment5 per_analysis_criteria.segment5%type
584: ,segment6 per_analysis_criteria.segment6%type
577:
578: type special_information_type is record
579: (segment1 per_analysis_criteria.segment1%type
580: ,segment2 per_analysis_criteria.segment2%type
581: ,segment3 per_analysis_criteria.segment3%type
582: ,segment4 per_analysis_criteria.segment4%type
583: ,segment5 per_analysis_criteria.segment5%type
584: ,segment6 per_analysis_criteria.segment6%type
585: ,segment7 per_analysis_criteria.segment7%type
578: type special_information_type is record
579: (segment1 per_analysis_criteria.segment1%type
580: ,segment2 per_analysis_criteria.segment2%type
581: ,segment3 per_analysis_criteria.segment3%type
582: ,segment4 per_analysis_criteria.segment4%type
583: ,segment5 per_analysis_criteria.segment5%type
584: ,segment6 per_analysis_criteria.segment6%type
585: ,segment7 per_analysis_criteria.segment7%type
586: ,segment8 per_analysis_criteria.segment8%type
579: (segment1 per_analysis_criteria.segment1%type
580: ,segment2 per_analysis_criteria.segment2%type
581: ,segment3 per_analysis_criteria.segment3%type
582: ,segment4 per_analysis_criteria.segment4%type
583: ,segment5 per_analysis_criteria.segment5%type
584: ,segment6 per_analysis_criteria.segment6%type
585: ,segment7 per_analysis_criteria.segment7%type
586: ,segment8 per_analysis_criteria.segment8%type
587: ,segment9 per_analysis_criteria.segment9%type
580: ,segment2 per_analysis_criteria.segment2%type
581: ,segment3 per_analysis_criteria.segment3%type
582: ,segment4 per_analysis_criteria.segment4%type
583: ,segment5 per_analysis_criteria.segment5%type
584: ,segment6 per_analysis_criteria.segment6%type
585: ,segment7 per_analysis_criteria.segment7%type
586: ,segment8 per_analysis_criteria.segment8%type
587: ,segment9 per_analysis_criteria.segment9%type
588: ,segment10 per_analysis_criteria.segment10%type
581: ,segment3 per_analysis_criteria.segment3%type
582: ,segment4 per_analysis_criteria.segment4%type
583: ,segment5 per_analysis_criteria.segment5%type
584: ,segment6 per_analysis_criteria.segment6%type
585: ,segment7 per_analysis_criteria.segment7%type
586: ,segment8 per_analysis_criteria.segment8%type
587: ,segment9 per_analysis_criteria.segment9%type
588: ,segment10 per_analysis_criteria.segment10%type
589: ,segment11 per_analysis_criteria.segment11%type
582: ,segment4 per_analysis_criteria.segment4%type
583: ,segment5 per_analysis_criteria.segment5%type
584: ,segment6 per_analysis_criteria.segment6%type
585: ,segment7 per_analysis_criteria.segment7%type
586: ,segment8 per_analysis_criteria.segment8%type
587: ,segment9 per_analysis_criteria.segment9%type
588: ,segment10 per_analysis_criteria.segment10%type
589: ,segment11 per_analysis_criteria.segment11%type
590: ,segment12 per_analysis_criteria.segment12%type
583: ,segment5 per_analysis_criteria.segment5%type
584: ,segment6 per_analysis_criteria.segment6%type
585: ,segment7 per_analysis_criteria.segment7%type
586: ,segment8 per_analysis_criteria.segment8%type
587: ,segment9 per_analysis_criteria.segment9%type
588: ,segment10 per_analysis_criteria.segment10%type
589: ,segment11 per_analysis_criteria.segment11%type
590: ,segment12 per_analysis_criteria.segment12%type
591: ,segment13 per_analysis_criteria.segment13%type
584: ,segment6 per_analysis_criteria.segment6%type
585: ,segment7 per_analysis_criteria.segment7%type
586: ,segment8 per_analysis_criteria.segment8%type
587: ,segment9 per_analysis_criteria.segment9%type
588: ,segment10 per_analysis_criteria.segment10%type
589: ,segment11 per_analysis_criteria.segment11%type
590: ,segment12 per_analysis_criteria.segment12%type
591: ,segment13 per_analysis_criteria.segment13%type
592: ,segment14 per_analysis_criteria.segment14%type
585: ,segment7 per_analysis_criteria.segment7%type
586: ,segment8 per_analysis_criteria.segment8%type
587: ,segment9 per_analysis_criteria.segment9%type
588: ,segment10 per_analysis_criteria.segment10%type
589: ,segment11 per_analysis_criteria.segment11%type
590: ,segment12 per_analysis_criteria.segment12%type
591: ,segment13 per_analysis_criteria.segment13%type
592: ,segment14 per_analysis_criteria.segment14%type
593: ,segment15 per_analysis_criteria.segment15%type
586: ,segment8 per_analysis_criteria.segment8%type
587: ,segment9 per_analysis_criteria.segment9%type
588: ,segment10 per_analysis_criteria.segment10%type
589: ,segment11 per_analysis_criteria.segment11%type
590: ,segment12 per_analysis_criteria.segment12%type
591: ,segment13 per_analysis_criteria.segment13%type
592: ,segment14 per_analysis_criteria.segment14%type
593: ,segment15 per_analysis_criteria.segment15%type
594: ,segment16 per_analysis_criteria.segment16%type
587: ,segment9 per_analysis_criteria.segment9%type
588: ,segment10 per_analysis_criteria.segment10%type
589: ,segment11 per_analysis_criteria.segment11%type
590: ,segment12 per_analysis_criteria.segment12%type
591: ,segment13 per_analysis_criteria.segment13%type
592: ,segment14 per_analysis_criteria.segment14%type
593: ,segment15 per_analysis_criteria.segment15%type
594: ,segment16 per_analysis_criteria.segment16%type
595: ,segment17 per_analysis_criteria.segment17%type
588: ,segment10 per_analysis_criteria.segment10%type
589: ,segment11 per_analysis_criteria.segment11%type
590: ,segment12 per_analysis_criteria.segment12%type
591: ,segment13 per_analysis_criteria.segment13%type
592: ,segment14 per_analysis_criteria.segment14%type
593: ,segment15 per_analysis_criteria.segment15%type
594: ,segment16 per_analysis_criteria.segment16%type
595: ,segment17 per_analysis_criteria.segment17%type
596: ,segment18 per_analysis_criteria.segment18%type
589: ,segment11 per_analysis_criteria.segment11%type
590: ,segment12 per_analysis_criteria.segment12%type
591: ,segment13 per_analysis_criteria.segment13%type
592: ,segment14 per_analysis_criteria.segment14%type
593: ,segment15 per_analysis_criteria.segment15%type
594: ,segment16 per_analysis_criteria.segment16%type
595: ,segment17 per_analysis_criteria.segment17%type
596: ,segment18 per_analysis_criteria.segment18%type
597: ,segment19 per_analysis_criteria.segment19%type
590: ,segment12 per_analysis_criteria.segment12%type
591: ,segment13 per_analysis_criteria.segment13%type
592: ,segment14 per_analysis_criteria.segment14%type
593: ,segment15 per_analysis_criteria.segment15%type
594: ,segment16 per_analysis_criteria.segment16%type
595: ,segment17 per_analysis_criteria.segment17%type
596: ,segment18 per_analysis_criteria.segment18%type
597: ,segment19 per_analysis_criteria.segment19%type
598: ,segment20 per_analysis_criteria.segment20%type
591: ,segment13 per_analysis_criteria.segment13%type
592: ,segment14 per_analysis_criteria.segment14%type
593: ,segment15 per_analysis_criteria.segment15%type
594: ,segment16 per_analysis_criteria.segment16%type
595: ,segment17 per_analysis_criteria.segment17%type
596: ,segment18 per_analysis_criteria.segment18%type
597: ,segment19 per_analysis_criteria.segment19%type
598: ,segment20 per_analysis_criteria.segment20%type
599: ,segment21 per_analysis_criteria.segment21%type
592: ,segment14 per_analysis_criteria.segment14%type
593: ,segment15 per_analysis_criteria.segment15%type
594: ,segment16 per_analysis_criteria.segment16%type
595: ,segment17 per_analysis_criteria.segment17%type
596: ,segment18 per_analysis_criteria.segment18%type
597: ,segment19 per_analysis_criteria.segment19%type
598: ,segment20 per_analysis_criteria.segment20%type
599: ,segment21 per_analysis_criteria.segment21%type
600: ,segment22 per_analysis_criteria.segment22%type
593: ,segment15 per_analysis_criteria.segment15%type
594: ,segment16 per_analysis_criteria.segment16%type
595: ,segment17 per_analysis_criteria.segment17%type
596: ,segment18 per_analysis_criteria.segment18%type
597: ,segment19 per_analysis_criteria.segment19%type
598: ,segment20 per_analysis_criteria.segment20%type
599: ,segment21 per_analysis_criteria.segment21%type
600: ,segment22 per_analysis_criteria.segment22%type
601: ,segment23 per_analysis_criteria.segment23%type
594: ,segment16 per_analysis_criteria.segment16%type
595: ,segment17 per_analysis_criteria.segment17%type
596: ,segment18 per_analysis_criteria.segment18%type
597: ,segment19 per_analysis_criteria.segment19%type
598: ,segment20 per_analysis_criteria.segment20%type
599: ,segment21 per_analysis_criteria.segment21%type
600: ,segment22 per_analysis_criteria.segment22%type
601: ,segment23 per_analysis_criteria.segment23%type
602: ,segment24 per_analysis_criteria.segment24%type
595: ,segment17 per_analysis_criteria.segment17%type
596: ,segment18 per_analysis_criteria.segment18%type
597: ,segment19 per_analysis_criteria.segment19%type
598: ,segment20 per_analysis_criteria.segment20%type
599: ,segment21 per_analysis_criteria.segment21%type
600: ,segment22 per_analysis_criteria.segment22%type
601: ,segment23 per_analysis_criteria.segment23%type
602: ,segment24 per_analysis_criteria.segment24%type
603: ,segment25 per_analysis_criteria.segment25%type
596: ,segment18 per_analysis_criteria.segment18%type
597: ,segment19 per_analysis_criteria.segment19%type
598: ,segment20 per_analysis_criteria.segment20%type
599: ,segment21 per_analysis_criteria.segment21%type
600: ,segment22 per_analysis_criteria.segment22%type
601: ,segment23 per_analysis_criteria.segment23%type
602: ,segment24 per_analysis_criteria.segment24%type
603: ,segment25 per_analysis_criteria.segment25%type
604: ,segment26 per_analysis_criteria.segment26%type
597: ,segment19 per_analysis_criteria.segment19%type
598: ,segment20 per_analysis_criteria.segment20%type
599: ,segment21 per_analysis_criteria.segment21%type
600: ,segment22 per_analysis_criteria.segment22%type
601: ,segment23 per_analysis_criteria.segment23%type
602: ,segment24 per_analysis_criteria.segment24%type
603: ,segment25 per_analysis_criteria.segment25%type
604: ,segment26 per_analysis_criteria.segment26%type
605: ,segment27 per_analysis_criteria.segment27%type
598: ,segment20 per_analysis_criteria.segment20%type
599: ,segment21 per_analysis_criteria.segment21%type
600: ,segment22 per_analysis_criteria.segment22%type
601: ,segment23 per_analysis_criteria.segment23%type
602: ,segment24 per_analysis_criteria.segment24%type
603: ,segment25 per_analysis_criteria.segment25%type
604: ,segment26 per_analysis_criteria.segment26%type
605: ,segment27 per_analysis_criteria.segment27%type
606: ,segment28 per_analysis_criteria.segment28%type
599: ,segment21 per_analysis_criteria.segment21%type
600: ,segment22 per_analysis_criteria.segment22%type
601: ,segment23 per_analysis_criteria.segment23%type
602: ,segment24 per_analysis_criteria.segment24%type
603: ,segment25 per_analysis_criteria.segment25%type
604: ,segment26 per_analysis_criteria.segment26%type
605: ,segment27 per_analysis_criteria.segment27%type
606: ,segment28 per_analysis_criteria.segment28%type
607: ,segment29 per_analysis_criteria.segment29%type
600: ,segment22 per_analysis_criteria.segment22%type
601: ,segment23 per_analysis_criteria.segment23%type
602: ,segment24 per_analysis_criteria.segment24%type
603: ,segment25 per_analysis_criteria.segment25%type
604: ,segment26 per_analysis_criteria.segment26%type
605: ,segment27 per_analysis_criteria.segment27%type
606: ,segment28 per_analysis_criteria.segment28%type
607: ,segment29 per_analysis_criteria.segment29%type
608: ,segment30 per_analysis_criteria.segment30%type
601: ,segment23 per_analysis_criteria.segment23%type
602: ,segment24 per_analysis_criteria.segment24%type
603: ,segment25 per_analysis_criteria.segment25%type
604: ,segment26 per_analysis_criteria.segment26%type
605: ,segment27 per_analysis_criteria.segment27%type
606: ,segment28 per_analysis_criteria.segment28%type
607: ,segment29 per_analysis_criteria.segment29%type
608: ,segment30 per_analysis_criteria.segment30%type
609: ,person_analysis_id per_person_analyses.person_analysis_id%type
602: ,segment24 per_analysis_criteria.segment24%type
603: ,segment25 per_analysis_criteria.segment25%type
604: ,segment26 per_analysis_criteria.segment26%type
605: ,segment27 per_analysis_criteria.segment27%type
606: ,segment28 per_analysis_criteria.segment28%type
607: ,segment29 per_analysis_criteria.segment29%type
608: ,segment30 per_analysis_criteria.segment30%type
609: ,person_analysis_id per_person_analyses.person_analysis_id%type
610: ,object_version_number per_person_analyses.object_version_number%type );
603: ,segment25 per_analysis_criteria.segment25%type
604: ,segment26 per_analysis_criteria.segment26%type
605: ,segment27 per_analysis_criteria.segment27%type
606: ,segment28 per_analysis_criteria.segment28%type
607: ,segment29 per_analysis_criteria.segment29%type
608: ,segment30 per_analysis_criteria.segment30%type
609: ,person_analysis_id per_person_analyses.person_analysis_id%type
610: ,object_version_number per_person_analyses.object_version_number%type );
611:
604: ,segment26 per_analysis_criteria.segment26%type
605: ,segment27 per_analysis_criteria.segment27%type
606: ,segment28 per_analysis_criteria.segment28%type
607: ,segment29 per_analysis_criteria.segment29%type
608: ,segment30 per_analysis_criteria.segment30%type
609: ,person_analysis_id per_person_analyses.person_analysis_id%type
610: ,object_version_number per_person_analyses.object_version_number%type );
611:
612:
1484:
1485: Procedure return_education_Details
1486: (p_person_id in per_people_f.person_id%type,
1487: p_effective_date in date,
1488: p_education_level OUT NOCOPY per_analysis_criteria.segment1%type,
1489: p_academic_discipline OUT NOCOPY per_analysis_criteria.segment2%type,
1490: p_year_degree_attained OUT NOCOPY per_analysis_criteria.segment3%type
1491: );
1492:
1485: Procedure return_education_Details
1486: (p_person_id in per_people_f.person_id%type,
1487: p_effective_date in date,
1488: p_education_level OUT NOCOPY per_analysis_criteria.segment1%type,
1489: p_academic_discipline OUT NOCOPY per_analysis_criteria.segment2%type,
1490: p_year_degree_attained OUT NOCOPY per_analysis_criteria.segment3%type
1491: );
1492:
1493: ------------------------------------------------------------------------------
1486: (p_person_id in per_people_f.person_id%type,
1487: p_effective_date in date,
1488: p_education_level OUT NOCOPY per_analysis_criteria.segment1%type,
1489: p_academic_discipline OUT NOCOPY per_analysis_criteria.segment2%type,
1490: p_year_degree_attained OUT NOCOPY per_analysis_criteria.segment3%type
1491: );
1492:
1493: ------------------------------------------------------------------------------
1494: