1 PACKAGE PER_US_EEO4_PKG AUTHID CURRENT_USER AS
2 /* $Header: peruseeo4.pkh 120.0.12000000.1 2007/02/06 14:47:36 appldev noship $ */
3 /* +======================================================================+
4 | Copyright (c) 2003 Oracle Corporation |
5 | Redwood Shores, California, USA |
6 | All rights reserved. |
7 +======================================================================+
8 Package Name : PER_US_EEO4_PKG
9
10 Package File Name : peruseeo4.pkh
11
12 Description : This package is used by 'EEO4 Report (XML)'
13 concurrent program.
14
15 Change List
16 -----------
17 Date Name Vers Bug No Description
18 ----------- ---------- ----- ------- -----------------------------------
19 27-JUN-2006 rpasumar 115.0 Created.
20 19-JUL-2006 rpasumar 115.1 Fixed GSCC Errors.
21 28-JUL-2006 rpasumar 115.2 5409988 Added the function check_function.
22 5415136 Added the function get_function_number.
23 31-JUL-2006 rpasumar 115.6 5414756 Added p_dynamic_where parameter to
24 the procedure generate_sql to handle
25 the salaries more than 70000 per annum.
26 ========================================================================*/
27
28 TYPE emp_rec IS RECORD (job_function VARCHAR2(280)
29 ,lookup_code VARCHAR2(30)
30 ,salary_range VARCHAR2(30)
31 ,cons_total_category_emps NUMBER
32 ,no_cons_wmale_emps NUMBER
33 ,no_cons_bmale_emps NUMBER
34 ,no_cons_hmale_emps NUMBER
35 ,no_cons_amale_emps NUMBER
36 ,no_cons_imale_emps NUMBER
37 ,no_cons_wfemale_emps NUMBER
38 ,no_cons_bfemale_emps NUMBER
39 ,no_cons_hfemale_emps NUMBER
40 ,no_cons_afemale_emps NUMBER
41 ,no_cons_ifemale_emps NUMBER);
42
43 TYPE func_rec IS RECORD (job_function VARCHAR2(30)
44 ,description VARCHAR2(80));
45
46 TYPE function_data IS TABLE OF func_rec
47 INDEX BY BINARY_INTEGER;
48
49 TYPE full_time_emp_data IS TABLE OF emp_rec
50 INDEX BY BINARY_INTEGER;
51 TYPE other_full_time_emp_data IS TABLE OF emp_rec
52 INDEX BY BINARY_INTEGER;
53 TYPE new_hire_emp_data IS TABLE OF emp_rec
54 INDEX BY BINARY_INTEGER;
55
56 PROCEDURE generate_xml_data(errbuf OUT NOCOPY VARCHAR2
57 ,retcode OUT NOCOPY NUMBER
58 ,p_reporting_year IN NUMBER
59 ,p_add_message1 IN VARCHAR2
60 ,p_add_message2 IN VARCHAR2
61 ,p_add_message3 IN VARCHAR2
62 ,p_add_message4 IN VARCHAR2
63 ,p_add_message5 IN VARCHAR2
64 ,p_add_message6 IN VARCHAR2
65 ,p_add_message7 IN VARCHAR2
66 ,p_business_group_id IN VARCHAR2
67 ,p_full_time_emp_count IN NUMBER
68 ,p_emp_count_for_function IN NUMBER
69 );
70 -- Bug# 5414756
71 PROCEDURE generate_sql(p_job_codes IN VARCHAR2 , p_dynamic_where IN VARCHAR2);
72
73 PROCEDURE populate_ft_emp_data(p_function_code IN VARCHAR2);
74 PROCEDURE populate_oft_emp_data(p_function_code IN VARCHAR2);
75 PROCEDURE populate_nh_emp_data(p_function_code IN VARCHAR2);
76
77 PROCEDURE generate_header_xml_data;
78 PROCEDURE generate_juris_cert_xml_data;
79 PROCEDURE create_xml(p_current_function IN VARCHAR2);
80 PROCEDURE generate_footer_xml_data;
81
82 PROCEDURE create_report(report_type NUMBER);
83
84
85 PROCEDURE generate_ft_xml_data(p_function_code IN VARCHAR2);
86 PROCEDURE generate_oft_xml_data(p_function_code IN VARCHAR2);
87 PROCEDURE generate_nh_xml_data(p_function_code IN VARCHAR2);
88
89 FUNCTION convert_into_xml( p_name IN VARCHAR2
90 ,p_value IN VARCHAR2
91 ,p_type IN char)
92 RETURN VARCHAR2;
93
94 FUNCTION get_lookup_meaning(p_emp_category IN NUMBER, p_lookup_code IN NUMBER)
95 RETURN VARCHAR2;
96
97 PROCEDURE write_to_concurrent_out(p_text IN varchar2);
98
99 -- Bug# 5409988
100 PROCEDURE check_function(p_function_code IN NUMBER);
101
102 -- Bug# 5415136
103 FUNCTION get_function_number(p_function_code IN NUMBER)
104 RETURN NUMBER;
105
106 END PER_US_EEO4_PKG;
107