[Home] [Help]
1024:
1025: l_proc varchar2(72) := 'Generic Sit';
1026: l_business_group_id per_people_f.business_group_id%type;
1027: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
1028: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;
1029: l_personal_analysis_id per_person_analyses.person_analysis_id%type;
1030: l_education_level ghr_pa_requests.education_level%type;
1031: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;
1032: l_academic_discipline ghr_pa_requests.academic_discipline%type;
1065: pea.segment2 academic_discipline,
1066: pea.segment3 year_degree_attained,
1067: pan.person_analysis_id,
1068: pan.object_version_number
1069: from per_analysis_criteria pea,
1070: per_person_analyses pan
1071: where pan.person_id = p_pa_request_rec.person_id
1072: and pan.id_flex_num = l_id_flex_num
1073: and pea.id_flex_num = pan.id_flex_num
1085: Cursor c_edu_sit is
1086: select segment1 education_level,
1087: segment2 academic_discipline,
1088: segment3 year_degree_attained
1089: from per_analysis_criteria
1090: where analysis_criteria_id = l_analysis_criteria_id
1091: and id_flex_num = l_id_flex_num;
1092:
1093: -- Cursor to select the business_group_id that the person belongs to
8516: l_proc varchar2(72) := 'Generic Update SIT';
8517: l_object_version_number per_people_f.object_version_number%type;
8518: l_session ghr_history_api.g_session_var_type;
8519: l_multiple varchar2(1);
8520: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;
8521: l_person_analysis_id per_person_analyses.person_analysis_id%type;
8522: l_business_group_id per_people_f.business_group_id%type;
8523: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
8524: -- Bug#4054110,4069798 Added l_date_from variable