eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.GMD_QCR02USR_XMLP_PKG

Source


1 PACKAGE GMD_QCR02USR_XMLP_PKG AS
2 /* $Header: QCR02USRS.pls 120.0 2007/12/24 13:07:54 krreddy noship $ */
3   INCLUDE VARCHAR2(32767);
4 
5   FROM_SAMPLE VARCHAR2(32);
6 
7   TO_SAMPLE VARCHAR2(32);
8 
9   FROM_ITEM VARCHAR2(32);
10 
11   TO_ITEM VARCHAR2(32);
12 
13   TO_LOTNO VARCHAR2(32);
14 
15   FROM_LOTNO VARCHAR2(32);
16 
17   PRINT_CONDITION VARCHAR2(30);
18 
19   FROM_RESULT_DATE DATE;
20 
21   TO_RESULT_DATE DATE;
22 
23   SY_ALL VARCHAR2(3);
24 
25   NONBLOCKSQL VARCHAR2(3);
26 
27   P_ORGANIZATION_ID NUMBER;
28 
29   FROM_SUBINVENTORY VARCHAR2(32767);
30 
31   FROM_LOCATOR VARCHAR2(32767);
32 
33   TO_SUBINVENTORY VARCHAR2(32767);
34 
35   TO_LOCATOR VARCHAR2(32767);
36 
37   P_CONC_REQUEST_ID NUMBER;
38 
39   ASSAY_TYPECP VARCHAR2(7);
40 
41   SPEC_CP VARCHAR2(5);
42 
43   ACCEPT_CP VARCHAR2(5);
44 
45   FINAL_CP VARCHAR2(5);
46 
47   --DATECP VARCHAR2(500);
48   DATECP VARCHAR2(500):= ' ';
49 
50   --INCLUDECP VARCHAR2(200);
51   INCLUDECP VARCHAR2(200):= ' ';
52 
53   --SAMPLECP VARCHAR2(400);
54   SAMPLECP VARCHAR2(400):= ' ';
55 
56   --ITEMCP VARCHAR2(500);
57   ITEMCP VARCHAR2(500):=' ';
58 
59   --LOTNOCP VARCHAR2(500);
60   LOTNOCP VARCHAR2(500):= ' ';
61 
62   --LOCATORCP VARCHAR2(200);
63   LOCATORCP VARCHAR2(200):= ' ';
64 
65   --SUBINVENTORYCP VARCHAR2(200);
66   SUBINVENTORYCP VARCHAR2(200):=' ';
67 
68   FROM_ITEMCP VARCHAR2(32);
69 
70   TO_ITEMCP VARCHAR2(32);
71 
72   FROM_SAMPLECP VARCHAR2(32);
73 
74   TO_SAMPLECP VARCHAR2(32);
75 
76   FROM_RSLT_DTCP VARCHAR2(11);
77 
78   TO_RSLT_DTCP VARCHAR2(11);
79 
80   FROM_LOCATORCP VARCHAR2(40);
81 
82   TO_LOCATORCP VARCHAR2(40);
83 
84   FROM_LOTNOCP VARCHAR2(32);
85 
86   TO_LOTNOCP VARCHAR2(32);
87 
88   FROM_SUBINVENTORYCP VARCHAR2(80);
89 
90   TO_SUBINVENTORYCP VARCHAR2(100);
91 
92   ORGCP VARCHAR2(20);
93 
94   function EFFECTIVITYCFFORMULACHR(SAMPLE_NO_V IN VARCHAR2) RETURN VARCHAR2;
95   FUNCTION TEXTCFFORMULA(TEXT_SPEC IN VARCHAR2) RETURN VARCHAR2;
96 
97   FUNCTION TARGETSPECFORMULA(TARGET_SPEC IN NUMBER
98                             ,TEST_TYPE IN VARCHAR2
99                             ,PRECISION IN NUMBER) RETURN CHAR;
100 
101   FUNCTION DATECFFORMULA RETURN VARCHAR2;
102 
103   FUNCTION ASSAY_DESCCFFORMULA(ASSAY_CODE IN VARCHAR2) RETURN VARCHAR2;
104 
105   FUNCTION TEXTARRAYCFFORMULA(TEXT_CODECF IN NUMBER) RETURN VARCHAR2;
106 
107   FUNCTION SAMPLECFFORMULA RETURN VARCHAR2;
108 
109   FUNCTION ITEMCFFORMULA RETURN VARCHAR2;
110 
111   FUNCTION LOTCFFORMULA RETURN VARCHAR2;
112 
113   FUNCTION SUBINVENTORYCFFORMULA RETURN VARCHAR2;
114 
115   FUNCTION LOCATORCFFORMULA RETURN VARCHAR2;
116 
117   FUNCTION INCLUDECFFORMULA RETURN VARCHAR2;
118 
119   FUNCTION SAMPLECPFORMULA(SAMPLECF IN VARCHAR2) RETURN VARCHAR2;
120 
121   FUNCTION ITEMCPFORMULA(ITEMCF IN VARCHAR2) RETURN VARCHAR2;
122 
123   FUNCTION LOTNOCPFORMULA(LOTNOCF IN VARCHAR2) RETURN VARCHAR2;
124 
125   FUNCTION DATECPFORMULA(DATECF IN VARCHAR2) RETURN VARCHAR2;
126 
127   FUNCTION INCLUDECPFORMULA(INCLUDECF IN VARCHAR2) RETURN VARCHAR2;
128 
129   FUNCTION WAREHOUSECPFORMULA RETURN VARCHAR2;
130 
131   FUNCTION LOCATIONCPFORMULA RETURN VARCHAR2;
132 
133   FUNCTION QCUNIT_CODECFFORMULA(SPEC IN NUMBER
134                                ,QCASSY_TYP_ID IN NUMBER) RETURN VARCHAR2;
135 
136   --FUNCTION TEXTARRAY2CFFORMULA(TEXT_CODE IN NUMBER) RETURN VARCHAR2;
137   FUNCTION TEXTARRAY2CFFORMULA(TEXT_CODE_V IN NUMBER) RETURN VARCHAR2;
138 
139   --FUNCTION EFFECTIVITYCFFORMULA(SAMPLE_NO IN VARCHAR2) RETURN DATE;
140   FUNCTION EFFECTIVITYCFFORMULA(SAMPLE_NO_V IN VARCHAR2) RETURN DATE;
141 
142   FUNCTION RESULTCFFORMULA(TEXT_RESULT IN VARCHAR2
143                           ,NUM_RESULT IN NUMBER) RETURN VARCHAR2;
144 
145   FUNCTION MIN_SPECCFFORMULA(MIN_CHAR IN VARCHAR2
146                             ,MIN_SPEC IN NUMBER) RETURN NUMBER;
147 
148   FUNCTION MAX_SPECCFFORMULA(MAX_CHAR IN VARCHAR2
149                             ,MAX_SPEC IN NUMBER) RETURN NUMBER;
150 
151   FUNCTION MIN_VAILDCFFORMULA(ASSAY_CODE IN VARCHAR2) RETURN NUMBER;
152 
153   FUNCTION MAX_VAILDCFFORMULA(ASSAY_CODE IN VARCHAR2) RETURN NUMBER;
154 
155   FUNCTION MINIMUMCFFORMULA(MIN_SPEC IN NUMBER
156                            ,TEST_TYPE IN VARCHAR2
157                            ,PRECISION IN NUMBER
158                            ,MIN_CHAR IN VARCHAR2) RETURN CHAR;
159 
160   FUNCTION MAXIMUMCFFORMULA(MAX_SPEC IN NUMBER
161                            ,TEST_TYPE IN VARCHAR2
162                            ,PRECISION IN NUMBER
163                            ,MAX_CHAR IN VARCHAR2) RETURN CHAR;
164 
165   --FUNCTION EFFECTIVITYCF1FORMULA(SAMPLE_NO IN VARCHAR2) RETURN DATE;
166   FUNCTION EFFECTIVITYCF1FORMULA(SAMPLE_NO_V IN VARCHAR2) RETURN DATE;
167 
168   FUNCTION FROM_ITEMCFFORMULA RETURN VARCHAR2;
169 
170   FUNCTION TO_ITEMCFFORMULA RETURN VARCHAR2;
171 
172   FUNCTION FROM_SAMPLECFFORMULA RETURN VARCHAR2;
173 
174   FUNCTION TO_SAMPLECFFORMULA RETURN VARCHAR2;
175 
176   FUNCTION FROM_RSLT_DTCFFORMULA RETURN VARCHAR2;
177 
178   FUNCTION TO_RSLT_DTCFFORMULA RETURN VARCHAR2;
179 
180   FUNCTION FROM_LOCATORCFFORMULA RETURN VARCHAR2;
181 
182   FUNCTION TO_LOCATORCFFORMULA RETURN VARCHAR2;
183 
184   FUNCTION FROM_LOTNOCFFORMULA RETURN VARCHAR2;
185 
186   FUNCTION TO_LOTNOCFFORMULA RETURN VARCHAR2;
187 
188   FUNCTION FROM_SUBINVENTORYCFFORMULA RETURN VARCHAR2;
189 
190   FUNCTION TO_SUBINVENTORYCFFORMULA RETURN VARCHAR2;
191 
192   FUNCTION INCLUDECFFORMULA0052 RETURN VARCHAR2;
193 
194   FUNCTION PRINT_TEXTCFFORMULA RETURN VARCHAR2;
195 
196   FUNCTION BEFOREREPORT RETURN BOOLEAN;
197 
198   FUNCTION ACCEPTCFFORMULA(ACCEPT_ANYWAY IN VARCHAR2
199                           ,FINAL_MARK IN VARCHAR2
200                           ,IN_SPEC_IND IN VARCHAR2) RETURN VARCHAR2;
201 
202   PROCEDURE GMD_QCR02USR_XMLP_PKG_HEADER;
203 
204   FUNCTION RESULT_DISPCFFORMULA(QCASSY_TYP_ID IN NUMBER
205                                ,NUM_RESULT IN NUMBER) RETURN CHAR;
206 
207   FUNCTION ASSAY_DISPCFFORMULA(ASSAY_CODE IN VARCHAR2
208                               ,QCASSY_TYP_ID IN NUMBER
209                               ,TARGETSPECCF IN VARCHAR2) RETURN CHAR;
210 
211   FUNCTION ASSAYMIN_DISPCFFORMULA(QCASSY_TYP_ID IN NUMBER
212                                  ,MIN_SPECCF IN NUMBER) RETURN CHAR;
213 
214   FUNCTION ASSAYMAX_DISPCFFORMULA(QCASSY_TYP_ID IN NUMBER
215                                  ,MAX_SPECCF IN NUMBER) RETURN CHAR;
216 
217   FUNCTION MIN_CHARCFFORMULA(MIN_CHAR IN VARCHAR2) RETURN CHAR;
218 
219   FUNCTION MAX_CHARCFFORMULA(MAX_CHAR IN VARCHAR2) RETURN CHAR;
220 
221   FUNCTION NUM_RESULTCFFORMULA(TEXT_RESULT IN VARCHAR2
222                               ,NUM_RESULT IN NUMBER
223                               ,TEST_TYPE IN VARCHAR2
224                               ,PRECISION IN NUMBER) RETURN CHAR;
225 
226   FUNCTION TEXT_CODECFFORMULA(SPEC IN NUMBER) RETURN NUMBER;
227 
228   FUNCTION ORGCFFORMULA RETURN CHAR;
229 
230   FUNCTION LOCATOR_NAMECFFORMULA(LOCATOR_ID IN NUMBER) RETURN CHAR;
231 
232   FUNCTION AFTERREPORT RETURN BOOLEAN;
233 
234   FUNCTION ASSAY_TYPECP_P RETURN VARCHAR2;
235 
236   FUNCTION SPEC_CP_P RETURN VARCHAR2;
237 
238   FUNCTION ACCEPT_CP_P RETURN VARCHAR2;
239 
240   FUNCTION FINAL_CP_P RETURN VARCHAR2;
241 
242   FUNCTION DATECP_P RETURN VARCHAR2;
243 
244   FUNCTION INCLUDECP_P RETURN VARCHAR2;
245 
246   FUNCTION SAMPLECP_P RETURN VARCHAR2;
247 
248   FUNCTION ITEMCP_P RETURN VARCHAR2;
249 
250   FUNCTION LOTNOCP_P RETURN VARCHAR2;
251 
252   FUNCTION LOCATORCP_P RETURN VARCHAR2;
253 
254   FUNCTION SUBINVENTORYCP_P RETURN VARCHAR2;
255 
256   FUNCTION FROM_ITEMCP_P RETURN VARCHAR2;
257 
258   FUNCTION TO_ITEMCP_P RETURN VARCHAR2;
259 
260   FUNCTION FROM_SAMPLECP_P RETURN VARCHAR2;
261 
262   FUNCTION TO_SAMPLECP_P RETURN VARCHAR2;
263 
264   FUNCTION FROM_RSLT_DTCP_P RETURN VARCHAR2;
265 
266   FUNCTION TO_RSLT_DTCP_P RETURN VARCHAR2;
267 
268   FUNCTION FROM_LOCATORCP_P RETURN VARCHAR2;
269 
270   FUNCTION TO_LOCATORCP_P RETURN VARCHAR2;
271 
272   FUNCTION FROM_LOTNOCP_P RETURN VARCHAR2;
273 
274   FUNCTION TO_LOTNOCP_P RETURN VARCHAR2;
275 
276   FUNCTION FROM_SUBINVENTORYCP_P RETURN VARCHAR2;
277 
278   FUNCTION TO_SUBINVENTORYCP_P RETURN VARCHAR2;
279 
280   FUNCTION ORGCP_P RETURN VARCHAR2;
281 
282 END GMD_QCR02USR_XMLP_PKG;
283 
284 
285