1 PACKAGE PER_US_EEO4A_PKG AUTHID CURRENT_USER AS
2 /* $Header: peuseeo4a.pkh 120.0.12020000.1 2012/07/16 10:20:06 agarai noship $ */
3 /* +======================================================================+
4 | Copyright (c) 2003 Oracle Corporation |
5 | Redwood Shores, California, USA |
6 | All rights reserved. |
7 +======================================================================+
8 Package Name : PER_US_EEO4A_PKG
9
10 Package File Name : peuseeo4a.pkh
11
12 Description : This package is used by 'EEO4A Report (XML)'
13 concurrent program.
14
15 Change List
16 -----------
17 Date Name Vers Bug No Description
18 ----------- ---------- ----- ------- -----------------------------------
19 09-DEC-2011 agarai 115.0 13112110 Created the package for EEO4A
20 Report.
21
22 ========================================================================*/
23
24 TYPE emp_rec IS RECORD (job_function VARCHAR2(280)
25 ,lookup_code VARCHAR2(30)
26 ,salary_range VARCHAR2(30)
27 ,cons_total_category_emps NUMBER
28 ,no_cons_wmale_emps NUMBER
29 ,no_cons_hmale_emps NUMBER
30 ,no_cons_cmale_emps NUMBER
31 ,no_cons_fmale_emps NUMBER
32 ,no_cons_jmale_emps NUMBER
33 ,no_cons_omale_emps NUMBER
34 ,no_cons_wfemale_emps NUMBER
35 ,no_cons_hfemale_emps NUMBER
36 ,no_cons_cfemale_emps NUMBER
37 ,no_cons_ffemale_emps NUMBER
38 ,no_cons_jfemale_emps NUMBER
39 ,no_cons_ofemale_emps NUMBER);
40
41 TYPE func_rec IS RECORD (job_function VARCHAR2(30)
42 ,description VARCHAR2(80));
43
44 TYPE function_data IS TABLE OF func_rec
45 INDEX BY BINARY_INTEGER;
46
47 TYPE full_time_emp_data IS TABLE OF emp_rec
48 INDEX BY BINARY_INTEGER;
49 TYPE other_full_time_emp_data IS TABLE OF emp_rec
50 INDEX BY BINARY_INTEGER;
51 TYPE new_hire_emp_data IS TABLE OF emp_rec
52 INDEX BY BINARY_INTEGER;
53
54 FUNCTION derive_single_race(p_person_id NUMBER)
55 RETURN NUMBER;
56
57 FUNCTION convert_into_xml( p_name IN VARCHAR2
58 ,p_value IN VARCHAR2
59 ,p_type IN char)
60 RETURN VARCHAR2;
61
62 FUNCTION get_lookup_meaning(p_emp_category IN NUMBER, p_lookup_code IN NUMBER)
63 RETURN VARCHAR2;
64
65 FUNCTION get_function_number(p_function_code IN NUMBER)
66 RETURN NUMBER;
67
68 PROCEDURE check_function(p_function_code IN NUMBER);
69
70 PROCEDURE generate_sql(p_job_codes IN VARCHAR2 , p_dynamic_where IN VARCHAR2);
71
72 PROCEDURE populate_ft_emp_data(p_function_code IN VARCHAR2);
73 PROCEDURE populate_oft_emp_data(p_function_code IN VARCHAR2);
74 PROCEDURE populate_nh_emp_data(p_function_code IN VARCHAR2);
75
76 PROCEDURE generate_header_xml_data;
77 PROCEDURE generate_footer_xml_data;
78 PROCEDURE generate_juris_cert_xml_data;
79
80 PROCEDURE generate_ft_xml_data(p_function_code IN VARCHAR2);
81 PROCEDURE generate_oft_xml_data(p_function_code IN VARCHAR2);
82 PROCEDURE generate_nh_xml_data(p_function_code IN VARCHAR2);
83
84 PROCEDURE create_xml(p_current_function IN VARCHAR2);
85 PROCEDURE create_report(report_type NUMBER);
86
87 PROCEDURE generate_xml_data(errbuf OUT NOCOPY VARCHAR2
88 ,retcode OUT NOCOPY NUMBER
89 ,p_reporting_year IN NUMBER
90 ,p_add_message1 IN VARCHAR2
91 ,p_add_message2 IN VARCHAR2
92 ,p_add_message3 IN VARCHAR2
93 ,p_add_message4 IN VARCHAR2
94 ,p_add_message5 IN VARCHAR2
95 ,p_add_message6 IN VARCHAR2
96 ,p_add_message7 IN VARCHAR2
97 ,p_business_group_id IN VARCHAR2
98 ,p_full_time_emp_count IN NUMBER
99 ,p_emp_count_for_function IN NUMBER
100 );
101
102 PROCEDURE write_to_concurrent_out(p_text IN varchar2);
103
104 END PER_US_EEO4A_PKG;
105