[Home] [Help]
PACKAGE: APPS.PER_PERUSEO1_XMLP_PKG
Source
1 PACKAGE PER_PERUSEO1_XMLP_PKG AS
2 /* $Header: PERUSEO1S.pls 120.1 2008/01/07 13:25:45 srikrish noship $ */
3 P_HIERARCHY_VERSION_ID NUMBER;
4
5 P_PAYROLL_PERIOD_DATE_START VARCHAR2(32767);
6 P_PAYROLL_PERIOD_DATE_START_T VARCHAR2(32767);
7
8 P_BUSINESS_GROUP_ID NUMBER;
9
10 P_HIERARCHY_ID NUMBER;
11
12 P_MINIMUM_NO_OF_EMPLOYEES NUMBER;
13
14 P_REPORT_YEAR VARCHAR2(4);
15
16 P_PAYROLL_PERIOD_DATE_END VARCHAR2(32767);
17 P_PAYROLL_PERIOD_DATE_END_T VARCHAR2(32767);
18
19 P_PAYROLL_PERIOD_DATE VARCHAR2(32767);
20
21 P_CONC_REQUEST_ID NUMBER;
22
23 P_REPORT_MODE VARCHAR2(1);
24
25 P_AUDIT_REPORT VARCHAR2(1);
26
27 C_DEF_SIC VARCHAR2(20);
28
29 C_DEF_NAICS VARCHAR2(20);
30
31 C_DEF_GRE VARCHAR2(20);
32
33 C_DEF_DUNS VARCHAR2(20);
34
35 C_DEF_GOV_CON VARCHAR2(3);
36
37 C_DEF_APPRENT VARCHAR2(3);
38
39 C_DEF_ACTIV_1 VARCHAR2(80);
40
41 C_DEF_ACTIV_2 VARCHAR2(80);
42
43 C_DEF_ACTIV_3 VARCHAR2(80);
44
45 C_DEF_ACTIV_4 VARCHAR2(80);
46
47 CP_REPORT_YEAR VARCHAR2(4);
48
49 CP_TOT_EMPS NUMBER;
50
51 C_100_EMPS VARCHAR2(1);
52
53 C_EST_ACTIV_1 VARCHAR2(80);
54
55 C_EST_ACTIV_2 VARCHAR2(80);
56
57 C_EST_ACTIV_3 VARCHAR2(80);
58
59 C_EST_ACTIV_4 VARCHAR2(80);
60
61 C_AFFILIATED VARCHAR2(1);
62
63 CP_PAYROLL_PERIOD_DATE_START DATE;
64
65 CP_PAYROLL_PERIOD_DATE_END DATE;
66
67 CP_REPORT_TYPE VARCHAR2(80);
68
69 CP_HW_AUD_MALE NUMBER;
70
71 CP_HW_AUD_FEMALE NUMBER;
72
73 CP_HW_AUD_TOT NUMBER;
74
75 CP_HW_CAT NUMBER;
76
77 CP_HW_FEMALE NUMBER;
78
79 CP_HW_MALE NUMBER;
80
81 C_BUSINESS_GROUP_NAME VARCHAR2(60);
82
83 C_HIERARCHY_NAME VARCHAR2(40);
84
85 C_HIERARCHY_VERSION_NUM NUMBER;
86
87 C_PARENT_ORG_ID NUMBER;
88
89 C_PARENT_NODE_ID NUMBER;
90
91 CP_PREV_YEAR_FILED VARCHAR2(4) := '0';
92
93 C_PRIOD_END_DATE DATE;
94
95 C_ALL_TOTAL NUMBER := 0;
96
97 C_NO_OF_ESTABLISHMENTS NUMBER;
98
99 C_PAYROLL_PERIOD_DATE_START DATE;
100
101 C_PAYROLL_PERIOD_DATE_END DATE;
102
103 C_REPORT_MODE VARCHAR2(1);
104
105 C_REPORT_YEAR NUMBER;
106
107 FUNCTION BEFOREREPORT RETURN BOOLEAN;
108
109 FUNCTION P_REPORT_YEARVALIDTRIGGER RETURN BOOLEAN;
110
111 FUNCTION AFTERREPORT RETURN BOOLEAN;
112
113 FUNCTION CF_SET_DEFAULTSFORMULA RETURN NUMBER;
114
115 FUNCTION C_TOT_EMPSFORMULA(EST_NODE_ID IN NUMBER
116 ,AFFILIATED IN VARCHAR2
117 ,EST_REP_NAME IN VARCHAR2) RETURN NUMBER;
118
119 FUNCTION CF_SET_EST_ACTIVFORMULA(EST_NODE_ID IN NUMBER) RETURN NUMBER;
120
121 FUNCTION C_TOT_CATFORMULA(C_TOT_HLMALE IN NUMBER
122 ,C_TOT_HLFEMALE IN NUMBER
123 ,C_TOT_TMRACESMALE IN NUMBER
124 ,C_TOT_TMRACESFEMALE IN NUMBER
125 ,C_TOT_WMALE IN NUMBER
126 ,C_TOT_BMALE IN NUMBER
127 ,C_TOT_HMALE IN NUMBER
128 ,C_TOT_AMALE IN NUMBER
129 ,C_TOT_IMALE IN NUMBER
130 ,C_TOT_WFEMALE IN NUMBER
131 ,C_TOT_BFEMALE IN NUMBER
132 ,C_TOT_HFEMALE IN NUMBER
133 ,C_TOT_AFEMALE IN NUMBER
134 ,C_TOT_IFEMALE IN NUMBER) RETURN NUMBER;
135
136 FUNCTION CF_SET_REPFORMULA(HEADQUARTERS IN VARCHAR2
137 ,EST_UNIT IN VARCHAR2) RETURN NUMBER;
138
139 FUNCTION CF_SET_CURR_HWFORMULA(ESTAB_STATE IN VARCHAR2
140 ,CONS_JOB_CATEGORY_CODE IN VARCHAR2
141 ,EST_NODE_ID IN NUMBER) RETURN NUMBER;
142
143 FUNCTION CF_SET_AUD_HWFORMULA(ESTAB_STATE IN VARCHAR2
144 ,EST_NODE_ID IN NUMBER) RETURN NUMBER;
145
146 FUNCTION CF_100_EMPSFORMULA RETURN CHAR;
147
148 FUNCTION CF_CREATEUPD_ARCHEITFORMULA(EST_NODE_ID IN NUMBER
149 ,C_TOT_CAT IN NUMBER
150 ,C_TOT_WMALE IN NUMBER
151 ,C_TOT_BMALE IN NUMBER
152 ,C_TOT_HMALE IN NUMBER
153 ,C_TOT_AMALE IN NUMBER
154 ,C_TOT_IMALE IN NUMBER
155 ,C_TOT_WFEMALE IN NUMBER
156 ,C_TOT_BFEMALE IN NUMBER
157 ,C_TOT_HFEMALE IN NUMBER
158 ,C_TOT_AFEMALE IN NUMBER
159 ,C_TOT_IFEMALE IN NUMBER
160 ,C_TOT_HLMALE IN NUMBER
161 ,C_TOT_HLFEMALE IN NUMBER
162 ,C_TOT_TMRACESMALE IN NUMBER
163 ,C_TOT_TMRACESFEMALE IN NUMBER) RETURN NUMBER;
164
165 FUNCTION CF_AUDIT_REPORT(CONS_JOB_CATEGORY_CODE IN VARCHAR2
166 ,EST_NODE_ID IN NUMBER) RETURN NUMBER;
167
168 FUNCTION C_DEF_SIC_P RETURN VARCHAR2;
169
170 FUNCTION C_DEF_NAICS_P RETURN VARCHAR2;
171
172 FUNCTION C_DEF_GRE_P RETURN VARCHAR2;
173
174 FUNCTION C_DEF_DUNS_P RETURN VARCHAR2;
175
176 FUNCTION C_DEF_GOV_CON_P RETURN VARCHAR2;
177
178 FUNCTION C_DEF_APPRENT_P RETURN VARCHAR2;
179
180 FUNCTION C_DEF_ACTIV_1_P RETURN VARCHAR2;
181
182 FUNCTION C_DEF_ACTIV_2_P RETURN VARCHAR2;
183
184 FUNCTION C_DEF_ACTIV_3_P RETURN VARCHAR2;
185
186 FUNCTION C_DEF_ACTIV_4_P RETURN VARCHAR2;
187
188 FUNCTION CP_REPORT_YEAR_P RETURN VARCHAR2;
189
190 FUNCTION CP_TOT_EMPS_P RETURN NUMBER;
191
192 FUNCTION C_100_EMPS_P RETURN VARCHAR2;
193
194 FUNCTION C_EST_ACTIV_1_P RETURN VARCHAR2;
195
196 FUNCTION C_EST_ACTIV_2_P RETURN VARCHAR2;
197
198 FUNCTION C_EST_ACTIV_3_P RETURN VARCHAR2;
199
200 FUNCTION C_EST_ACTIV_4_P RETURN VARCHAR2;
201
202 FUNCTION C_AFFILIATED_P RETURN VARCHAR2;
203
204 FUNCTION CP_PAYROLL_PERIOD_DATE_START_P RETURN DATE;
205
206 FUNCTION CP_PAYROLL_PERIOD_DATE_END_P RETURN DATE;
207
208 FUNCTION CP_REPORT_TYPE_P RETURN VARCHAR2;
209
210 FUNCTION CP_HW_AUD_MALE_P RETURN NUMBER;
211
212 FUNCTION CP_HW_AUD_FEMALE_P RETURN NUMBER;
213
214 FUNCTION CP_HW_AUD_TOT_P RETURN NUMBER;
215
216 FUNCTION CP_HW_CAT_P RETURN NUMBER;
217
218 FUNCTION CP_HW_FEMALE_P RETURN NUMBER;
219
220 FUNCTION CP_HW_MALE_P RETURN NUMBER;
221
222 FUNCTION C_BUSINESS_GROUP_NAME_P RETURN VARCHAR2;
223
224 FUNCTION C_HIERARCHY_NAME_P RETURN VARCHAR2;
225
226 FUNCTION C_HIERARCHY_VERSION_NUM_P RETURN NUMBER;
227
228 FUNCTION C_PARENT_ORG_ID_P RETURN NUMBER;
229
230 FUNCTION C_PARENT_NODE_ID_P RETURN NUMBER;
231
232 FUNCTION CP_PREV_YEAR_FILED_P RETURN VARCHAR2;
233
234 FUNCTION C_PRIOD_END_DATE_P RETURN DATE;
235
236 FUNCTION C_ALL_TOTAL_P RETURN NUMBER;
237
238 FUNCTION C_NO_OF_ESTABLISHMENTS_P RETURN NUMBER;
239
240 FUNCTION C_PAYROLL_PERIOD_DATE_START_P RETURN DATE;
241
242 FUNCTION C_PAYROLL_PERIOD_DATE_END_P RETURN DATE;
243
244 FUNCTION C_REPORT_MODE_P RETURN VARCHAR2;
245
246 FUNCTION C_REPORT_YEAR_P RETURN NUMBER;
247
248 FUNCTION GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2;
249
250 --PROCEDURE OPEN;
251
252 --PROCEDURE PUT(P_CHAR IN VARCHAR2);
253
254 --PROCEDURE CLOSE;
255
256 END PER_PERUSEO1_XMLP_PKG;