DBA Data[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;