PACKAGE: APPS.PQH_PQHEEO4_XMLP_PKG

Source

1 PACKAGE PQH_PQHEEO4_XMLP_PKG AS
2 /* $Header: PQHEEO4S.pls 120.1 2007/12/07 06:48:30 vjaganat noship $ */
3   P_BUSINESS_GROUP_ID NUMBER;
4 
5   P_REPORT_YEAR VARCHAR2(4);
6 
7   P_CONC_REQUEST_ID NUMBER;
8 
9   P_MESSAGE_1 VARCHAR2(200);
10 
11   P_MESSAGE_2 VARCHAR2(200);
12 
13   P_MESSAGE_3 VARCHAR2(200);
14 
15   P_MESSAGE_4 VARCHAR2(200);
16 
17   P_MESSAGE_5 VARCHAR2(200);
18 
19   P_MESSAGE_6 VARCHAR2(200);
20 
21   P_MESSAGE_7 VARCHAR2(200);
22 
23   P_FUNCTION_DESC VARCHAR2(260);
24 
25   P_EEO4_QUERY VARCHAR2(20000) := 'SELECT  rpad(''ALL'',10,''*'')  Job_function_code, PQH_PQHEEO4_XMLP_PKG.CP_1_P CP_1,,CF_TOTAL_TITLEFORMULA0005(rpad(''FULL-TIME'',70,''*''))
26   CF_TOTAL_TITLE,PQH_PQHEEO4_XMLP_PKG.CF_SET_FUNCTION_DESCFORMULA(rpad(''ALL'',10,''*'')) CF_set_function_desc,
27   rpad(''FULL-TIME'',70,''*'')  Employment_category,  rpad(''Job Category'',10,''*'') job_category_code,  rpad(''Job cat Name'',60,''*'') Job_category_name,
28 			rpad(''0-100'',20,''*'')  Salary_range,  0  cons_total_category_emps,         0   no_cons_wmale_emps,
29 			0   no_cons_bmale_emps,         0  no_cons_hmale_emps,         0  no_cons_amale_emps,         0  no_cons_imale_emps,
30 			0  no_cons_wfemale_emps,         0  no_cons_bfemale_emps,         0  no_cons_hfemale_emps,         0  no_cons_afemale_emps,         0  no_cons_ifemale_emps FROM    Dual';
31 
32   P_REPORT_DAY_MONTH VARCHAR2(32767);
33 
34   P_BPT_FT_EMP_COUNT NUMBER;
35 
36   P_BPT_EMP_COUNT_FUNC NUMBER;
37 
38   CP_1 NUMBER := 1;
39 
40   C_BUSINESS_GROUP_NAME VARCHAR2(60);
41 
42   C_REPORT_TYPE VARCHAR2(30);
43 
44   C_ORGANIZATION_HIERARCHY VARCHAR2(30);
45 
46   C_EEO1_ORGANIZATION VARCHAR2(60);
47 
48   C_END_OF_TIME DATE;
49 
50   FUNCTION BEFOREREPORT RETURN BOOLEAN;
51 
52   FUNCTION CF_TOTAL_TITLEFORMULA0005(EMPLOYMENT_CATEGORY IN VARCHAR2) RETURN CHAR;
53 
54   FUNCTION CF_SET_FUNCTION_DESCFORMULA(JOB_FUNCTION_CODE IN VARCHAR2) RETURN VARCHAR2;
55 
56   FUNCTION AFTERREPORT RETURN BOOLEAN;
57 
58   FUNCTION CP_1_P RETURN NUMBER;
59 
60   FUNCTION C_BUSINESS_GROUP_NAME_P RETURN VARCHAR2;
61 
62   FUNCTION C_REPORT_TYPE_P RETURN VARCHAR2;
63 
64   FUNCTION C_ORGANIZATION_HIERARCHY_P RETURN VARCHAR2;
65 
66   FUNCTION C_EEO1_ORGANIZATION_P RETURN VARCHAR2;
67 
68   FUNCTION C_END_OF_TIME_P RETURN DATE;
69 
70   FUNCTION_DESC VARCHAR2(240);
71 
72 END PQH_PQHEEO4_XMLP_PKG;