[Home] [Help]
7: PROCEDURE initialize_record
8: IS
9: l_proc varchar2(30) := 'initialize_record';
10: BEGIN
11: hr_utility.set_location('Entering:'||l_proc,5);
12: g_ghr_cpdf_temp.academic_discipline := NULL;
13: g_ghr_cpdf_temp.agency_code := NULL;
14: g_ghr_cpdf_temp.annuitant_indicator := NULL;
15: g_ghr_cpdf_temp.award_amount := NULL;
99: PROCEDURE cleanup_table
100: IS
101: l_proc varchar2(30) := 'cleanup_table';
102: BEGIN
103: hr_utility.set_location('Entering:'||l_proc,5);
104: DELETE FROM ghr_cpdf_temp
105: WHERE report_type = 'STATUS'
106: AND session_id = userenv('SESSIONID')
107: ;
165: l_proc varchar2(30) := 'get_from_history_asgnei';
166: l_ASGNEI_DATA PER_ASSIGNMENT_EXTRA_INFO%ROWTYPE;
167: l_ASGNEI_DATA_INIT PER_ASSIGNMENT_EXTRA_INFO%ROWTYPE;
168: BEGIN
169: hr_utility.set_location('Entering:'||l_proc,5);
170:
171: l_ASGNEI_DATA := l_ASGNEI_DATA_INIT;
172: -- Begin Bug# 4168162
173: g_message_name := 'Assignment EIT: Assigment RPA';
209:
210: l_PEOPLE_REC PEOPLE_CUR%ROWTYPE;
211:
212: BEGIN
213: hr_utility.set_location('Entering:'||l_proc,5);
214: OPEN PEOPLE_CUR;
215:
216: FETCH PEOPLE_CUR INTO l_PEOPLE_REC;
217:
247: AND per.effective_end_date;
248: BEGIN
249:
250: -- bug 749386 use ghr_api.return_education_details and ghr_api.return_special_information
251: hr_utility.set_location('Entering:'||l_proc,5);
252: -- Begin Bug# 4168162
253: g_message_name := 'Special Info: Education Dtls';
254: -- End Bug# 4168162
255: ghr_api.return_education_details(p_person_id => p_sr_person_id,
302: l_PEOPEI_DATA_INIT PER_PEOPLE_EXTRA_INFO%ROWTYPE;
303: l_type_of_employment per_people_extra_info.pei_information4%TYPE;
304: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
305: BEGIN
306: hr_utility.set_location('Entering:'||l_proc,5);
307:
308:
309: l_PEOPEI_DATA := l_PEOPEI_DATA_INIT;
310: -- Begin Bug# 4168162
517: l_proc varchar2(30) := 'get_from_history_posiei';
518: l_POSIEI_DATA PER_POSITION_EXTRA_INFO%ROWTYPE;
519: l_POSIEI_DATA_INIT PER_POSITION_EXTRA_INFO%ROWTYPE;
520: BEGIN
521: hr_utility.set_location('Entering:'||l_proc,5);
522:
523: l_POSIEI_DATA := l_POSIEI_DATA_INIT;
524: -- Begin Bug# 4168162
525: g_message_name := 'Position EIT: Position Group1';
598: WHERE GRADE_ID = g_grade_id);
599:
600: l_GRADEFREC GRADEFCUR%ROWTYPE;
601: BEGIN
602: hr_utility.set_location('Entering:'||l_proc,5);
603:
604: OPEN GRADEFCUR;
605:
606: FETCH GRADEFCUR INTO l_GRADEFREC;
634:
635: -- Declared record despite a "one column query" for future maintenance
636: l_JOBDEF_REC JOBDEF_CUR%ROWTYPE;
637: BEGIN
638: hr_utility.set_location('Entering:'||l_proc,5);
639:
640: OPEN JOBDEF_CUR;
641:
642: FETCH JOBDEF_CUR INTO l_JOBDEF_REC;
672:
673: -- Declared record despite a "one column query" for future maintenance
674: l_DUTSTAREC DUTSTACUR%ROWTYPE;
675: BEGIN
676: hr_utility.set_location('Entering:'||l_proc,5);
677: -- Begin Bug# 4168162
678: g_message_name := 'Duty Station Details';
679: -- End Bug# 4168162
680: OPEN DUTSTACUR;
700: l_proc varchar2(30) := 'get_from_history_payele';
701: l_scrn_ent_val_init PAY_ELEMENT_ENTRY_VALUES_F.SCREEN_ENTRY_VALUE%TYPE;
702: l_scrn_ent_val PAY_ELEMENT_ENTRY_VALUES_F.SCREEN_ENTRY_VALUE%TYPE;
703: BEGIN
704: hr_utility.set_location('Entering:'||l_proc,5);
705:
706:
707: l_scrn_ent_val := l_scrn_ent_val_init;
708: -- Begin Bug# 4168162
881:
882: l_STATE_CNTRY_CODE GHR_DUTY_STATIONS_F.STATE_OR_COUNTRY_CODE%TYPE;
883:
884: BEGIN
885: hr_utility.set_location('Entering:'||l_proc,5);
886:
887:
888: OPEN CALCDUTSTA_CUR;
889:
919: l_locality_pay_area ghr_locality_pay_areas_f.locality_pay_area_code%type;
920: l_equivalent_pay_plan ghr_pay_plans.equivalent_pay_plan%type;
921: -- End Bug 4542476
922: BEGIN
923: hr_utility.set_location('Entering:'||l_proc,5);
924: -- Bug#3231946 Added reference to parameters as the function definition is changed
925:
926: l_locality_pay_area := ghr_cpdf_dynrpt.get_loc_pay_area_code(p_duty_station_id => g_duty_station_id,
927: p_effective_date => g_ghr_cpdf_temp.effective_date);
1145: PROCEDURE purge_suppression
1146: IS
1147: l_proc varchar2(30) := 'purge_suppression';
1148: BEGIN
1149: hr_utility.set_location('Entering:'||l_proc,5);
1150:
1151: -- bug 743502 moved the checking of agency code matching the parameter passed in to
1152: -- to as soon as possible, not here at the end!
1153: DELETE FROM ghr_cpdf_temp
1192: LENGTH(p_last_name)),' ') = ' '||UPPER(LOOKUP_CODE)
1193: AND ROWNUM = 1;
1194: BEGIN
1195:
1196: hr_utility.set_location('Entering:'||l_proc,5);
1197:
1198: IF GET_SUFFIX%ISOPEN THEN
1199: CLOSE GET_SUFFIX;
1200: END IF;
1290: END pp_gs_equivalent;
1291:
1292: BEGIN
1293:
1294: hr_utility.set_location('Entering:'||l_proc,5);
1295: ghr_mto_int.set_log_program_name('GHR_CPDF_STATRPT');
1296: g_report_date := p_report_date;
1297: g_agency := p_agency;
1298: l_records_found:=FALSE;
1557: NULL;
1558:
1559: EXCEPTION
1560: WHEN CPDF_STATRPT_ERROR THEN
1561: hr_utility.set_location('Inside CPDF_STATRPT_ERROR exception ',30);
1562: ghr_mto_int.log_message(p_procedure => g_message_name, --Bug# 4168162
1563: p_message => l_log_text
1564: );
1565: COMMIT;