[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: ;
169: l_proc varchar2(30) := 'get_from_history_asgnei';
170: l_ASGNEI_DATA PER_ASSIGNMENT_EXTRA_INFO%ROWTYPE;
171: l_ASGNEI_DATA_INIT PER_ASSIGNMENT_EXTRA_INFO%ROWTYPE;
172: BEGIN
173: hr_utility.set_location('Entering:'||l_proc,5);
174:
175: l_ASGNEI_DATA := l_ASGNEI_DATA_INIT;
176: -- Begin Bug# 4168162
177: g_message_name := 'Assignment EIT: Assigment RPA';
213:
214: l_PEOPLE_REC PEOPLE_CUR%ROWTYPE;
215:
216: BEGIN
217: hr_utility.set_location('Entering:'||l_proc,5);
218: OPEN PEOPLE_CUR;
219:
220: FETCH PEOPLE_CUR INTO l_PEOPLE_REC;
221:
251: AND per.effective_end_date;
252: BEGIN
253:
254: -- bug 749386 use ghr_api.return_education_details and ghr_api.return_special_information
255: hr_utility.set_location('Entering:'||l_proc,5);
256: -- Begin Bug# 4168162
257: g_message_name := 'Special Info: Education Dtls';
258: -- End Bug# 4168162
259: ghr_api.return_education_details(p_person_id => p_sr_person_id,
306: l_PEOPEI_DATA_INIT PER_PEOPLE_EXTRA_INFO%ROWTYPE;
307: l_type_of_employment per_people_extra_info.pei_information4%TYPE;
308: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
309: BEGIN
310: hr_utility.set_location('Entering:'||l_proc,5);
311:
312:
313: l_PEOPEI_DATA := l_PEOPEI_DATA_INIT;
314: -- Begin Bug# 4168162
547: l_proc varchar2(30) := 'get_from_history_posiei';
548: l_POSIEI_DATA PER_POSITION_EXTRA_INFO%ROWTYPE;
549: l_POSIEI_DATA_INIT PER_POSITION_EXTRA_INFO%ROWTYPE;
550: BEGIN
551: hr_utility.set_location('Entering:'||l_proc,5);
552:
553: l_POSIEI_DATA := l_POSIEI_DATA_INIT;
554: -- Begin Bug# 4168162
555: g_message_name := 'Position EIT: Position Group1';
628: WHERE GRADE_ID = g_grade_id);
629:
630: l_GRADEFREC GRADEFCUR%ROWTYPE;
631: BEGIN
632: hr_utility.set_location('Entering:'||l_proc,5);
633:
634: OPEN GRADEFCUR;
635:
636: FETCH GRADEFCUR INTO l_GRADEFREC;
664:
665: -- Declared record despite a "one column query" for future maintenance
666: l_JOBDEF_REC JOBDEF_CUR%ROWTYPE;
667: BEGIN
668: hr_utility.set_location('Entering:'||l_proc,5);
669:
670: OPEN JOBDEF_CUR;
671:
672: FETCH JOBDEF_CUR INTO l_JOBDEF_REC;
702:
703: -- Declared record despite a "one column query" for future maintenance
704: l_DUTSTAREC DUTSTACUR%ROWTYPE;
705: BEGIN
706: hr_utility.set_location('Entering:'||l_proc,5);
707: -- Begin Bug# 4168162
708: g_message_name := 'Duty Station Details';
709: -- End Bug# 4168162
710: OPEN DUTSTACUR;
730: l_proc varchar2(30) := 'get_from_history_payele';
731: l_scrn_ent_val_init PAY_ELEMENT_ENTRY_VALUES_F.SCREEN_ENTRY_VALUE%TYPE;
732: l_scrn_ent_val PAY_ELEMENT_ENTRY_VALUES_F.SCREEN_ENTRY_VALUE%TYPE;
733: BEGIN
734: hr_utility.set_location('Entering:'||l_proc,5);
735:
736:
737: l_scrn_ent_val := l_scrn_ent_val_init;
738: -- Begin Bug# 4168162
911:
912: l_STATE_CNTRY_CODE GHR_DUTY_STATIONS_F.STATE_OR_COUNTRY_CODE%TYPE;
913:
914: BEGIN
915: hr_utility.set_location('Entering:'||l_proc,5);
916:
917:
918: OPEN CALCDUTSTA_CUR;
919:
949: l_locality_pay_area ghr_locality_pay_areas_f.locality_pay_area_code%type;
950: l_equivalent_pay_plan ghr_pay_plans.equivalent_pay_plan%type;
951: -- End Bug 4542476
952: BEGIN
953: hr_utility.set_location('Entering:'||l_proc,5);
954: -- Bug#3231946 Added reference to parameters as the function definition is changed
955:
956: l_locality_pay_area := ghr_cpdf_dynrpt.get_loc_pay_area_code(p_duty_station_id => g_duty_station_id,
957: p_effective_date => g_ghr_cpdf_temp.effective_date);
1175: PROCEDURE purge_suppression
1176: IS
1177: l_proc varchar2(30) := 'purge_suppression';
1178: BEGIN
1179: hr_utility.set_location('Entering:'||l_proc,5);
1180:
1181: -- bug 743502 moved the checking of agency code matching the parameter passed in to
1182: -- to as soon as possible, not here at the end!
1183: DELETE FROM ghr_cpdf_temp
1222: LENGTH(p_last_name)),' ') = ' '||UPPER(LOOKUP_CODE)
1223: AND ROWNUM = 1;
1224: BEGIN
1225:
1226: hr_utility.set_location('Entering:'||l_proc,5);
1227:
1228: IF GET_SUFFIX%ISOPEN THEN
1229: CLOSE GET_SUFFIX;
1230: END IF;
1325: END pp_gs_equivalent;
1326:
1327: BEGIN
1328:
1329: hr_utility.set_location('Entering:'||l_proc,5);
1330: ghr_mto_int.set_log_program_name('GHR_CPDF_STATRPT');
1331: g_report_date := p_report_date;
1332: g_agency := p_agency;
1333: l_records_found:=FALSE;
1611: NULL;
1612:
1613: EXCEPTION
1614: WHEN CPDF_STATRPT_ERROR THEN
1615: hr_utility.set_location('Inside CPDF_STATRPT_ERROR exception ',30);
1616: ghr_mto_int.log_message(p_procedure => g_message_name, --Bug# 4168162
1617: p_message => l_log_text
1618: );
1619: COMMIT;