PACKAGE: APPS.GHR_EEOC_DYNAMICS_REPORT

Source

1 PACKAGE GHR_EEOC_DYNAMICS_REPORT AUTHID CURRENT_USER AS
2 /* $Header: ghreeocd.pkh 120.2 2011/08/16 12:18:32 vmididho noship $ */
3 
4  g_temp_rec          GHR_CPDF_TEMP%ROWTYPE;
5  g_message_name      GHR_PROCESS_LOG.MESSAGE_NAME%TYPE;
6  EEOC_DYNAMICS_RPT_ERR EXCEPTION;
7  TYPE t_tag_type IS RECORD
8            (tagname VARCHAR2(240),
9             tagvalue VARCHAR2(4000));
10  TYPE t_tags IS TABLE OF t_tag_type INDEX BY BINARY_INTEGER;
11 
12   PROCEDURE Eeoc_Dynamics_Main( errbuf                OUT NOCOPY VARCHAR2
13                              ,retcode                 OUT NOCOPY NUMBER
14                              ,p_report_name           IN VARCHAR2
15                              ,p_report_st_dt          IN VARCHAR2
16                              ,p_report_end_dt         IN VARCHAR2
17                              ,p_agency_code           IN VARCHAR2
18                              ,p_agency_sub_code       IN VARCHAR2
19                              ,p_business_group        IN NUMBER
20                              ,p_gen_file              IN VARCHAR2 DEFAULT 'TEXT'
21 			       --Bug # 12867515 modified the order of parameter
22                              ,p_sub_agency_subelement IN VARCHAR2
23                            );
24 
25   PROCEDURE Insert_Row;
26 
27   PROCEDURE WritetoFile(p_input_file_name  IN  VARCHAR2
28                        ,p_gen_file         IN  VARCHAR2
29                        ,p_report_end_dt    IN  DATE
30                        ,p_sub_agency_subelement IN VARCHAR2);
31 
32  PROCEDURE WriteHeaderRow(p_l_fp     UTL_FILE.FILE_TYPE,
33                            p_tags     T_TAGS,
34                            p_gen_file IN VARCHAR2);
35 
36   PROCEDURE WriteTagValues(p_eeoc_rec  GHR_CPDF_TEMP%ROWTYPE,
37                            p_tags      OUT NOCOPY t_tags,
38                            p_report_end_dt         IN  DATE,
39                            p_sub_agency_subelement IN VARCHAR2);
40 
41   PROCEDURE WriteXMLvalues(p_l_fp   utl_file.file_type,
42                            p_tags   t_tags);
43 
44   PROCEDURE WriteAsciivalues(p_l_fp     utl_file.file_type,
45                            p_tags       t_tags,
46                            p_gen_file   IN VARCHAR2 );
47 
48   FUNCTION  Exclude_Noac (p_noa_code  IN VARCHAR2) RETURN VARCHAR2;
49 
50 END GHR_EEOC_DYNAMICS_REPORT;