1 PACKAGE per_us_eeo5_pkg AUTHID CURRENT_USER AS
2 /* $Header: peuseeo5.pkh 120.1.12000000.1 2007/02/06 14:47:40 appldev noship $ */
3
4 /*****************************************************************************
5 Name : get_sum
6 Purpose : function to sum of the employees.
7 *****************************************************************************/
8 FUNCTION get_sum(p_no_cons_wmale_emps IN NUMBER
9 ,p_no_cons_bmale_emps IN NUMBER
10 ,p_no_cons_hmale_emps IN NUMBER
11 ,p_no_cons_amale_emps IN NUMBER
12 ,p_no_cons_imale_emps IN NUMBER
13 ,p_no_cons_wfemale_emps IN NUMBER
14 ,p_no_cons_bfemale_emps IN NUMBER
15 ,p_no_cons_hfemale_emps IN NUMBER
16 ,p_no_cons_afemale_emps IN NUMBER
17 ,p_no_cons_ifemale_emps IN NUMBER) RETURN NUMBER;
18
19 /*****************************************************************************
20 Name : generate_xml_data
21 Purpose : Procedure is called from concurrent program EEO5 Reporting.
22 *****************************************************************************/
23 PROCEDURE generate_xml_data(errbuf OUT NOCOPY VARCHAR2
24 ,retcode OUT NOCOPY NUMBER
25 ,p_reporting_year IN NUMBER
26 ,p_type_agency IN VARCHAR2
27 ,p_total_enrollments IN NUMBER
28 ,p_business_group_id IN NUMBER
29 );
30
31
32 END per_us_eeo5_pkg;