[Home] [Help]
PACKAGE: APPS.HXC_HXCMISTC_XMLP_PKG
Source
1 PACKAGE HXC_HXCMISTC_XMLP_PKG AS
2 /* $Header: HXCMISTCS.pls 120.0 2007/12/04 05:39:59 amakrish noship $ */
3 P_SORT_OPTION1 VARCHAR2(80);
4
5 P_SORT_OPTION2 VARCHAR2(80);
6
7 P_SORT_OPTION3 VARCHAR2(80);
8
9 P_SORT_OPTION4 VARCHAR2(80);
10
11 P_SORT1_LABEL VARCHAR2(100);
12
13 P_SORT2_LABEL VARCHAR2(100);
14
15 P_SORT3_LABEL VARCHAR2(100);
16
17 P_SORT4_LABEL VARCHAR2(100);
18
19 COL_1 VARCHAR2(100) := 'hou.name';
20
21 COL_2 VARCHAR2(100) := 'hl.location_code';
22
23 COL_3 VARCHAR2(80) := 'ppa.payroll_name';
24
25 COL_4 VARCHAR2(240) := 'ppf.full_name';
26
27 P_ORGANIZATION VARCHAR2(240);
28
29 P_DATE_TO DATE;
30
31 P_DATE_FROM DATE;
32
33 P_APPLICATION VARCHAR2(30);
34
35 P_DEFINE_MISSING VARCHAR2(80);
36
37 P_SELECT_CONDITION VARCHAR2(240);
38
39 P_BUSINESS_GROUP_ID NUMBER;
40
41 P_LOCATION VARCHAR2(80);
42
43 P_PAYROLL_ASSIGNMENT_SET VARCHAR2(80);
44
45 P_PAYROLL VARCHAR2(40);
46
47 P_PERSON_NAME VARCHAR2(80);
48
49 P_PERSON_NUMBER NUMBER;
50
51 P_SUPERVISOR VARCHAR2(40);
52
53 P_SELECT_CONDITION2 VARCHAR2(700);
54
55 P_DEFINE_LABEL VARCHAR2(80);
56
57 P_APPLICATION_LABEL VARCHAR2(80);
58
59 P_PERSON_NAME_LABEL VARCHAR2(80);
60
61 P_PERSON_NUMBER_LABEL VARCHAR2(80);
62
63 P_LOCATION_LABEL VARCHAR2(80);
64
65 P_ORGANIZATION_LABEL VARCHAR2(240);
66
67 P_PAYROLL_LABEL VARCHAR2(80);
68
69 P_ASSIGNMENT_SET_LABEL VARCHAR2(80);
70
71 P_SUPERVISOR_LABEL VARCHAR2(80);
72
73 P_SELECT_CONDITION3 VARCHAR2(40);
74
75 P_DEBUG VARCHAR2(32767);
76
77 P_CONC_REQUEST_ID NUMBER;
78
79 P_PERSON_TYPE VARCHAR2(32767);
80
81 PERSON_TYPE1 VARCHAR2(1000);
82
83 PERSON_TYPE2 VARCHAR2(1000);
84
85 ASSIGNMENT_TYPE1 VARCHAR2(1000);
86
87 P_ASSIGNMENT_TYPE VARCHAR2(1000);
88
89 P_VENDOR_ID VARCHAR2(40);
90
91 P_VENDOR_LABEL VARCHAR2(100);
92
93 P_PERSON_TYPE_LABEL VARCHAR2(80);
94
95 P_ASSIGNMENT_TYPE_LABEL VARCHAR2(80);
96
97 PERSON_TYPE3 VARCHAR2(1000);
98
99 CP_PAYROLL_NAME VARCHAR2(80);
100
101 CP_SCL_TCARD_REQ VARCHAR2(20);
102
103 CP_APPLICATION_SET_ID VARCHAR2(2000);
104
105 CP_TCARD_REQ_ATTR1 VARCHAR2(2000);
106
107 CP_TCARD_REQ_ATTR2 VARCHAR2(2000);
108
109 CP_TCARD_REQ_ATTR3 VARCHAR2(2000);
110
111 CP_TCARD_REQ_ATTR4 VARCHAR2(2000);
112
113 CP_TCARD_REQ_ATTR5 VARCHAR2(2000);
114
115 CP_TCARD_REQ_ATTR6 VARCHAR2(2000);
116
117 CP_TCARD_REQ_ATTR7 VARCHAR2(2000);
118
119 CP_TCARD_REQ_ATTR8 VARCHAR2(2000);
120
121 CP_TCARD_REQ_ATTR9 VARCHAR2(2000);
122
123 CP_TCARD_REQ_ATTR10 VARCHAR2(2000);
124
125 CP_TCARD_REQ_ATTR11 VARCHAR2(2000);
126
127 CP_TCARD_REQ_ATTR12 VARCHAR2(2000);
128
129 CP_TCARD_REQ_ATTR13 VARCHAR2(2000);
130
131 CP_TCARD_REQ_ATTR14 VARCHAR2(2000);
132
133 CP_TCARD_REQ_ATTR15 VARCHAR2(2000);
134
135 CP_TCARD_REQ_ATTR16 VARCHAR2(2000);
136
137 CP_TCARD_REQ_ATTR17 VARCHAR2(2000);
138
139 CP_TCARD_REQ_ATTR18 VARCHAR2(2000);
140
141 CP_TCARD_REQ_ATTR19 VARCHAR2(2000);
142
143 CP_TCARD_REQ_ATTR20 VARCHAR2(2000);
144
145 CP_TCARD_REQ_ATTR21 VARCHAR2(2000);
146
147 CP_TCARD_REQ_ATTR22 VARCHAR2(2000);
148
149 CP_TCARD_REQ_ATTR23 VARCHAR2(2000);
150
151 CP_TCARD_REQ_ATTR24 VARCHAR2(2000);
152
153 CP_TCARD_REQ_ATTR25 VARCHAR2(2000);
154
155 CP_TCARD_REQ_ATTR26 VARCHAR2(2000);
156
157 CP_TCARD_REQ_ATTR27 VARCHAR2(2000);
158
159 CP_TCARD_REQ_ATTR28 VARCHAR2(2000);
160
161 CP_TCARD_REQ_ATTR29 VARCHAR2(2000);
162
163 CP_TCARD_REQ_ATTR30 VARCHAR2(2000);
164
165 FUNCTION AFTERPFORM RETURN BOOLEAN;
166
167 FUNCTION CF_APPLICATIONFORMULA RETURN CHAR;
168
169 PROCEDURE SORT_OPTION(L_SORT_OPTION IN VARCHAR2
170 ,L_SORT_BY OUT NOCOPY VARCHAR2
171 ,L_SORT_LABEL OUT NOCOPY VARCHAR2);
172
173 FUNCTION CF_RESOURCE_PREFFORMULA(PERSON_ID1 IN NUMBER) RETURN CHAR;
174
175 FUNCTION G_START_TIMEGROUPFILTER(APPROVAL_STATUS IN VARCHAR2
176 ,P_COUNT IN NUMBER
177 ,RESOURCE_ID1 IN NUMBER) RETURN BOOLEAN;
178
179 FUNCTION G_ROWNUMGROUPFILTER(START_TIME1 IN DATE) RETURN BOOLEAN;
180
181 FUNCTION BEFOREREPORT RETURN BOOLEAN;
182
183 FUNCTION AFTERREPORT RETURN BOOLEAN;
184
185 FUNCTION CP_PAYROLL_NAME_P RETURN VARCHAR2;
186
187 FUNCTION CP_SCL_TCARD_REQ_P RETURN VARCHAR2;
188
189 FUNCTION CP_APPLICATION_SET_ID_P RETURN VARCHAR2;
190
191 FUNCTION CP_TCARD_REQ_ATTR1_P RETURN VARCHAR2;
192
193 FUNCTION CP_TCARD_REQ_ATTR2_P RETURN VARCHAR2;
194
195 FUNCTION CP_TCARD_REQ_ATTR3_P RETURN VARCHAR2;
196
197 FUNCTION CP_TCARD_REQ_ATTR4_P RETURN VARCHAR2;
198
199 FUNCTION CP_TCARD_REQ_ATTR5_P RETURN VARCHAR2;
200
201 FUNCTION CP_TCARD_REQ_ATTR6_P RETURN VARCHAR2;
202
203 FUNCTION CP_TCARD_REQ_ATTR7_P RETURN VARCHAR2;
204
205 FUNCTION CP_TCARD_REQ_ATTR8_P RETURN VARCHAR2;
206
207 FUNCTION CP_TCARD_REQ_ATTR9_P RETURN VARCHAR2;
208
209 FUNCTION CP_TCARD_REQ_ATTR10_P RETURN VARCHAR2;
210
211 FUNCTION CP_TCARD_REQ_ATTR11_P RETURN VARCHAR2;
212
213 FUNCTION CP_TCARD_REQ_ATTR12_P RETURN VARCHAR2;
214
215 FUNCTION CP_TCARD_REQ_ATTR13_P RETURN VARCHAR2;
216
217 FUNCTION CP_TCARD_REQ_ATTR14_P RETURN VARCHAR2;
218
219 FUNCTION CP_TCARD_REQ_ATTR15_P RETURN VARCHAR2;
220
221 FUNCTION CP_TCARD_REQ_ATTR16_P RETURN VARCHAR2;
222
223 FUNCTION CP_TCARD_REQ_ATTR17_P RETURN VARCHAR2;
224
225 FUNCTION CP_TCARD_REQ_ATTR18_P RETURN VARCHAR2;
226
227 FUNCTION CP_TCARD_REQ_ATTR19_P RETURN VARCHAR2;
228
229 FUNCTION CP_TCARD_REQ_ATTR20_P RETURN VARCHAR2;
230
231 FUNCTION CP_TCARD_REQ_ATTR21_P RETURN VARCHAR2;
232
233 FUNCTION CP_TCARD_REQ_ATTR22_P RETURN VARCHAR2;
234
235 FUNCTION CP_TCARD_REQ_ATTR23_P RETURN VARCHAR2;
236
237 FUNCTION CP_TCARD_REQ_ATTR24_P RETURN VARCHAR2;
238
239 FUNCTION CP_TCARD_REQ_ATTR25_P RETURN VARCHAR2;
240
241 FUNCTION CP_TCARD_REQ_ATTR26_P RETURN VARCHAR2;
242
243 FUNCTION CP_TCARD_REQ_ATTR27_P RETURN VARCHAR2;
244
245 FUNCTION CP_TCARD_REQ_ATTR28_P RETURN VARCHAR2;
246
247 FUNCTION CP_TCARD_REQ_ATTR29_P RETURN VARCHAR2;
248
249 FUNCTION CP_TCARD_REQ_ATTR30_P RETURN VARCHAR2;
250
251 END HXC_HXCMISTC_XMLP_PKG;