PACKAGE: APPS.GHR_EEOC_STATUS_REPORT

Source

1 PACKAGE GHR_EEOC_STATUS_REPORT AUTHID CURRENT_USER AS
2 /* $Header: ghreeocs.pkh 120.2.12020000.2 2012/07/05 14:53:58 amnaraya ship $ */
3 
4  g_temp_rec          GHR_CPDF_TEMP%ROWTYPE;
5  g_message_name      GHR_PROCESS_LOG.MESSAGE_NAME%TYPE;
6  g_appointment_date  DATE;
7 
8  EEOC_STATUS_RPT_ERR EXCEPTION;
9  TYPE t_tag_type IS RECORD
10            (tagname VARCHAR2(240),
11   	    tagvalue VARCHAR2(4000));
12  TYPE t_tags IS TABLE OF t_tag_type INDEX BY BINARY_INTEGER;
13 
14  PROCEDURE cleanup_table(p_type IN VARCHAR2);
15  PROCEDURE eeoc_status_main
16   ( errbuf                  OUT NOCOPY VARCHAR2
17    ,retcode                 OUT NOCOPY NUMBER
18    ,p_report_name           IN VARCHAR2
19    ,p_report_date           IN VARCHAR2
20    ,p_agency_code           IN VARCHAR2
21    ,p_agency_sub_code       IN VARCHAR2
22    ,p_business_group        IN NUMBER
23    ,p_gen_file              IN VARCHAR2 DEFAULT 'TEXT'
24    --Bug # 12867515 modified the order of parameter
25    ,p_sub_agency_subelement IN VARCHAR2
26    );
27 
28   PROCEDURE FETCH_PEOPLE_DETAILS(p_person_id         IN NUMBER,
29                                  p_report_date       IN DATE,
30    			         p_full_name         OUT NOCOPY VARCHAR2,
31 			         p_employee_no       OUT NOCOPY VARCHAR2);
32 
33   PROCEDURE FETCH_GRADE_DETAILS(p_grade_id       in NUMBER);
34   PROCEDURE FETCH_PEREI_DETAILS(p_person_id   in  NUMBER,
35                                 p_report_date in  DATE);
36 
37   PROCEDURE FETCH_POSEI_DETAILS(p_position_id IN NUMBER,
38                                 p_report_date IN DATE);
39 
40   PROCEDURE FETCH_ASGEI_DETAILS(p_assignment_id   in NUMBER,
41                                 p_report_date     in DATE);
42 
43   PROCEDURE FETCH_ELEMENT_DETAILS(p_assignment_id     IN NUMBER,
44                                   p_report_date       IN DATE,
45   			          p_business_group    IN NUMBER);
46 
47   PROCEDURE get_appointment_date(p_person_id        IN  NUMBER
48                                 ,p_report_date      IN  DATE
49                                 ,p_appointment_date OUT NOCOPY DATE);
50 
51   PROCEDURE insert_row;
52 
53   PROCEDURE WritetoFile(p_input_file_name  IN  VARCHAR2
54   		       ,p_gen_file         IN  VARCHAR2
55 		       ,p_report_date      IN  DATE
56 		       ,p_sub_agency_subelement IN VARCHAR2);
57 
58   PROCEDURE WriteHeaderRow(p_l_fp     UTL_FILE.FILE_TYPE,
59                            p_tags     T_TAGS,
60 			   p_gen_file IN VARCHAR2);
61 
62   PROCEDURE WriteTagValues(p_eeoc_rec  GHR_CPDF_TEMP%ROWTYPE,
63                            p_tags      OUT NOCOPY t_tags,
64 	  		   p_report_date           IN  DATE,
65 			   p_sub_agency_subelement IN VARCHAR2);
66 
67   PROCEDURE WriteXMLvalues(p_l_fp   utl_file.file_type,
68                            p_tags   t_tags);
69 
70   PROCEDURE WriteAsciivalues(p_l_fp     utl_file.file_type,
71                            p_tags       t_tags,
72 			   p_gen_file   IN VARCHAR2 );
73 
74 END GHR_EEOC_STATUS_REPORT;