[Home] [Help]
1009:
1010: l_proc varchar2(72) := 'Generic Sit';
1011: l_business_group_id per_people_f.business_group_id%type;
1012: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
1013: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;
1014: l_personal_analysis_id per_person_analyses.person_analysis_id%type;
1015: l_education_level ghr_pa_requests.education_level%type;
1016: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;
1017: l_academic_discipline ghr_pa_requests.academic_discipline%type;
1050: pea.segment2 academic_discipline,
1051: pea.segment3 year_degree_attained,
1052: pan.person_analysis_id,
1053: pan.object_version_number
1054: from per_analysis_criteria pea,
1055: per_person_analyses pan
1056: where pan.person_id = p_pa_request_rec.person_id
1057: and pan.id_flex_num = l_id_flex_num
1058: and pea.id_flex_num = pan.id_flex_num
1070: Cursor c_edu_sit is
1071: select segment1 education_level,
1072: segment2 academic_discipline,
1073: segment3 year_degree_attained
1074: from per_analysis_criteria
1075: where analysis_criteria_id = l_analysis_criteria_id
1076: and id_flex_num = l_id_flex_num;
1077:
1078: -- Cursor to select the business_group_id that the person belongs to
8213: l_proc varchar2(72) := 'Generic Update SIT';
8214: l_object_version_number per_people_f.object_version_number%type;
8215: l_session ghr_history_api.g_session_var_type;
8216: l_multiple varchar2(1);
8217: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;
8218: l_person_analysis_id per_person_analyses.person_analysis_id%type;
8219: l_business_group_id per_people_f.business_group_id%type;
8220: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
8221: -- Bug#4054110,4069798 Added l_date_from variable