APPS.GHR_EEOC_STATUS_REPORT dependencies on GHR_CPDF_TEMP

Line 6: -- This is the procedure to populate values into the temporary table GHR_CPDF_TEMP

2: /* $Header: ghreeocs.pkb 120.8.12020000.2 2012/07/05 14:53:03 amnaraya ship $ */
3:
4:
5: ---------------------------------------------------------------------------------------------
6: -- This is the procedure to populate values into the temporary table GHR_CPDF_TEMP
7: ---------------------------------------------------------------------------------------------
8: PROCEDURE populate_temp (p_business_group IN VARCHAR2
9: ,p_report_date IN DATE
10: ,p_agency_code IN VARCHAR2

Line 189: -- as employee_number field not available in GHR_CPDF_TEMP using from national_identifier

185: g_temp_rec.employee_date_of_birth := per_rec.date_of_birth;
186: l_full_name := per_rec.full_name;
187: l_employee_number := per_rec.employee_number;
188: -- Bug # 12865107 Reporting Employee Number instead of Employee Id
189: -- as employee_number field not available in GHR_CPDF_TEMP using from national_identifier
190: g_temp_rec.from_national_identifier := l_employee_number;
191: END LOOP;
192:
193: p_full_name := l_full_name;

Line 451: DELETE FROM ghr_cpdf_temp

447: PROCEDURE cleanup_table(p_type in VARCHAR2) IS
448: l_proc varchar2(30) := 'cleanup_table';
449: BEGIN
450: hr_utility.set_location('Entering:'||l_proc,5);
451: DELETE FROM ghr_cpdf_temp
452: WHERE report_type = p_type
453: AND session_id = userenv('SESSIONID');
454: END cleanup_table;
455:

Line 464: INSERT INTO ghr_cpdf_temp(report_type

460:
461: BEGIN
462: hr_utility.set_location('Entering:'||l_proc,5);
463:
464: INSERT INTO ghr_cpdf_temp(report_type
465: ,session_id
466: ,agency_code
467: ,bargaining_unit_status
468: ,education_level

Line 557: FROM GHR_CPDF_TEMP

553:
554: CURSOR c_eeoc_status(c_session_id NUMBER)
555: IS
556: SELECT *
557: FROM GHR_CPDF_TEMP
558: WHERE SESSION_ID = c_session_id
559: AND REPORT_TYPE = 'EEOCSTATUS';
560:
561: CURSOR c_get_dir

Line 645: PROCEDURE WriteTagValues(p_eeoc_rec GHR_CPDF_TEMP%ROWTYPE,

641: fnd_file.put_line(fnd_file.log,'-------------------------------------------');
642:
643: END WritetoFile;
644:
645: PROCEDURE WriteTagValues(p_eeoc_rec GHR_CPDF_TEMP%ROWTYPE,
646: p_tags OUT NOCOPY t_tags,
647: p_report_date IN DATE,
648: p_sub_agency_subelement IN VARCHAR2)
649: IS