[Home] [Help]
1: PACKAGE BODY GHR_EEOC_DYNAMICS_REPORT AS
2: /* $Header: ghreeocd.pkb 120.7 2011/08/16 12:21:22 vmididho noship $ */
3:
4: ---------------------------------------------------------------------------------------------
5: -- This is the procedure to populate values into the temporary table GHR_CPDF_TEMP
6: ---------------------------------------------------------------------------------------------
7: PROCEDURE Populate_Temp (p_business_group IN VARCHAR2
8: ,p_report_st_dt IN DATE
9: ,p_report_end_dt IN DATE
68: g_temp_rec.effective_date := l_par_rec.effective_date;
69: g_temp_rec.first_noa_code := l_par_rec.first_noa_code;
70: g_temp_rec.agency_code := NVL(l_par_rec.agency_code,l_par_rec.from_agency_code);
71: -- Bug # 12865107 Reporting Employee Number instead of Employee Id
72: -- as employee_number field not available in GHR_CPDF_TEMP using from national_identifier
73: g_temp_rec.from_national_identifier := l_emp_no;
74:
75:
76: l_peopei_data := null;
151:
152: BEGIN
153: hr_utility.set_location('Entering:'||l_proc,5);
154:
155: INSERT INTO ghr_cpdf_temp(report_type
156: ,session_id
157: ,agency_code
158: ,effective_date
159: ,from_national_identifier
206:
207: CURSOR c_eeoc_dynamics(c_session_id NUMBER)
208: IS
209: SELECT *
210: FROM GHR_CPDF_TEMP
211: WHERE SESSION_ID = c_session_id
212: AND REPORT_TYPE = 'EEOCDYNAMICS'
213: ORDER BY AGENCY_CODE,TO_NATIONAL_IDENTIFIER,EFFECTIVE_DATE;
214:
293: fnd_file.put_line(fnd_file.log,'-------------------------------------------');
294:
295: END WritetoFile;
296:
297: PROCEDURE WriteTagValues(p_eeoc_rec GHR_CPDF_TEMP%ROWTYPE,
298: p_tags OUT NOCOPY t_tags,
299: p_report_end_dt IN DATE,
300: p_sub_agency_subelement IN VARCHAR2)
301: IS