1 PACKAGE GMD_QCR01USR_XMLP_PKG AS
2 /* $Header: QCR01USRS.pls 120.0 2007/12/24 13:06:39 krreddy noship $ */
3 FROM_ITEM VARCHAR2(40);
4 TO_ITEM VARCHAR2(40);
5 FROM_RESULT_DATE DATE;
6 TO_RESULT_DATE DATE;
7 FROM_CUST_VEND VARCHAR2(40);
8 TO_CUST_VEND VARCHAR2(40);
9 INCLUDE VARCHAR2(40);
10 PRINT_CONDITION VARCHAR2(30);
11 FROM_SAMPLE VARCHAR2(40);
12 TO_SAMPLE VARCHAR2(40);
13 SY_ALL VARCHAR2(3);
14 NONBLOCKSQL VARCHAR2(3);
15 REPORT_TYPE NUMBER;
16 FROM_LOTNO VARCHAR2(32);
17 TO_LOTNO VARCHAR2(32);
18 SUBLOTNOCP VARCHAR2(40);
19 P_ORGANIZATION_ID VARCHAR2(40);
20 P_CONC_REQUEST_ID NUMBER;
21 ORDER_TYPECP VARCHAR2(30);
22 ASSAY_TYPECP VARCHAR2(7);
23 ACCEPT_CP VARCHAR2(32767);
24 FINAL_CP VARCHAR2(32767);
25 ASSAY_TYPE1CP VARCHAR2(7);
26 ACCEPT1_CP VARCHAR2(32767);
27 FINAL1_CP VARCHAR2(32767);
28 DATE1CP VARCHAR2(200);
29 FINAL1CP VARCHAR2(200);
30 CUST_VENDCP VARCHAR2(300):=' ';
31 CUST_VENDCP_1 VARCHAR2(300):=' ';
32 ITEMCP VARCHAR2(300);
33 SAMPLECP VARCHAR2(300);
34 FROM_ITEMCP VARCHAR2(32);
35 TO_ITEMCP VARCHAR2(32);
36 FROM_SAMPLECP VARCHAR2(32);
37 TO_SAMPLECP VARCHAR2(32);
38 FROM_CUST_VENDCP VARCHAR2(32);
39 TO_CUST_VENDCP VARCHAR2(32);
40 FROM_RSLT_DTCP VARCHAR2(11);
41 TO_RSLT_DTCP VARCHAR2(11);
42 LOTNOCP VARCHAR2(500);
43 FROM_LOTNOCP VARCHAR2(32);
44 TO_LOTNOCP VARCHAR2(32);
45 ORG_CP VARCHAR2(20);
46 FUNCTION DATE1CFFORMULA RETURN VARCHAR2;
47 FUNCTION FINALCFFORMULA RETURN VARCHAR2;
48 FUNCTION QCUNIT_CODECFFORMULA(QC_SPEC_ID IN NUMBER
49 ,ASSAY_CODE IN VARCHAR2
50 ,QCASSY_TYP_ID IN NUMBER) RETURN VARCHAR2;
51 FUNCTION ASSAY_DESCCFFORMULA(ASSAY_CODE IN VARCHAR2) RETURN VARCHAR2;
52 FUNCTION MIN_SPECCFFORMULA(QC_SPEC_ID IN NUMBER
53 ,ASSAY_CODE IN VARCHAR2
54 ,MIN_CHAR IN VARCHAR2
55 ,MIN_SPEC IN NUMBER) RETURN NUMBER;
56 FUNCTION MAX_SPECFORMULA(MAX_CHAR IN VARCHAR2
57 ,QC_SPEC_ID IN NUMBER
58 ,ASSAY_CODE IN VARCHAR2
59 ,MAX_SPEC IN NUMBER) RETURN NUMBER;
60 FUNCTION FROM_DATECFFORMULA(SAMPLE_NO_1 IN VARCHAR2) RETURN DATE;
61 FUNCTION TODATEFORMULA(SAMPLE_NO_1 IN VARCHAR2) RETURN DATE;
62 FUNCTION ASSAY_DESC1CFFORMULA(ASSAY_CODE2 IN VARCHAR2) RETURN VARCHAR2;
63 FUNCTION QCUNIT_CODE1CFFORMULA(QC_SPEC_ID2 IN NUMBER
64 ,ASSAY_CODE2 IN VARCHAR2
65 ,QCASSY_TYP_ID1 IN NUMBER) RETURN VARCHAR2;
66 FUNCTION MIN_SPEC1CFFORMULA(QC_SPEC_ID2 IN NUMBER
67 ,ASSAY_CODE2 IN VARCHAR2
68 ,MIN_CHAR1 IN VARCHAR2
69 ,MIN_SPEC1 IN NUMBER) RETURN NUMBER;
70 FUNCTION MAX_SPEC1CFFORMULA(MAX_CHAR1 IN VARCHAR2
71 ,QC_SPEC_ID2 IN NUMBER
72 ,ASSAY_CODE2 IN VARCHAR2
73 ,MAX_SPEC1 IN NUMBER) RETURN NUMBER;
74 FUNCTION FROM_DATE1CFFORMULA(SAMPLE_NO2 IN VARCHAR2) RETURN DATE;
75 FUNCTION TO_DATE1CFFORMULA(SAMPLE_NO2 IN VARCHAR2) RETURN DATE;
76 FUNCTION TEXTCFFORMULA(TEXT_SPEC IN VARCHAR2) RETURN VARCHAR2;
77 FUNCTION TARGETCFFORMULA(TEXT_SPEC IN VARCHAR2
78 ,TARGET_SPEC IN NUMBER
79 ,TEST_TYPE IN VARCHAR2
80 ,PRECISION IN NUMBER) RETURN CHAR;
81 FUNCTION TEXT1CFFORMULA(TEXT_SPEC1 IN VARCHAR2) RETURN VARCHAR2;
82 FUNCTION TARGET1CFFORMULA(TEXT_SPEC1 IN VARCHAR2
83 ,TARGET_SPEC1 IN NUMBER
84 ,TEST_TYPE1 IN VARCHAR2
85 ,PRECISION1 IN NUMBER) RETURN CHAR;
86 FUNCTION TEXTTARGETFORMULA(TEXTCF IN VARCHAR2
87 ,TARGETCF IN VARCHAR2) RETURN VARCHAR2;
88 FUNCTION TEXTTARGET1CFFORMULA(TEXT1CF IN VARCHAR2
89 ,TARGET1CF IN VARCHAR2) RETURN VARCHAR2;
90 FUNCTION TEXTARRAYCFFORMULA(TEXTCODECF IN NUMBER) RETURN VARCHAR2;
91 FUNCTION TEXTARRAY1CFFORMULA(TEXTCODE1CF IN NUMBER) RETURN VARCHAR2;
92 FUNCTION RESULT1CFFORMULA(TEXT_RESULT IN VARCHAR2
93 ,NUM_RESULT IN NUMBER) RETURN VARCHAR2;
94 FUNCTION RESULT2CFFORMULA(TEXT_RESULT2 IN VARCHAR2
95 ,NUM_RESULT2 IN NUMBER) RETURN VARCHAR2;
96 FUNCTION TEXTARRAY2CFFORMULA(TEXT_CODE_1 IN NUMBER) RETURN VARCHAR2;
97 FUNCTION TEXTARRAY3CFFORMULA(TEXT_CODE2 IN NUMBER) RETURN VARCHAR2;
98 FUNCTION ITEMCFFORMULA RETURN VARCHAR2;
99 FUNCTION SAMPLECFFORMULA RETURN VARCHAR2;
100 FUNCTION CUST_VENDCFFORMULA RETURN VARCHAR2;
101 FUNCTION TEXTCODECFFORMULA(QC_SPEC_ID IN NUMBER) RETURN NUMBER;
102 FUNCTION TEXTCODE1CFFORMULA(QC_SPEC_ID2 IN NUMBER) RETURN NUMBER;
103 FUNCTION BEFOREREPORT RETURN BOOLEAN;
104 FUNCTION FROM_ITEMCFFORMULA RETURN VARCHAR2;
105 FUNCTION TO_ITEMCFFORMULA RETURN VARCHAR2;
106 FUNCTION FROM_SAMPLECFFORMULA RETURN VARCHAR2;
107 FUNCTION TO_SAMPLECFFORMULA RETURN VARCHAR2;
108 FUNCTION FROM_CUST_VENDCFFORMULA RETURN VARCHAR2;
109 FUNCTION TO_CUST_VENDCFFORMULA RETURN VARCHAR2;
110 FUNCTION FROM_RSLT_DTCFFORMULA RETURN VARCHAR2;
111 FUNCTION TO_RSLT_DTCFFORMULA RETURN VARCHAR2;
112 FUNCTION INCLUDECFFORMULA RETURN VARCHAR2;
113 FUNCTION PRINTCFFORMULA RETURN VARCHAR2;
114 FUNCTION ACCEPT_FINALCFFORMULA(ACCEPT_ANYWAY IN VARCHAR2
115 ,FINAL_MARK IN VARCHAR2) RETURN VARCHAR2;
116 FUNCTION ACCEPT_FINALCFFORMULA0037(ACCEPT_ANYWAY1 IN VARCHAR2
117 ,FINAL_MARK1 IN VARCHAR2) RETURN VARCHAR2;
118 PROCEDURE GMD_QCR01USR_XMLP_PKG_HEADER;
119 FUNCTION LOTNOCFFORMULA RETURN CHAR;
120 FUNCTION FROM_LOTNOCFFORMULA RETURN VARCHAR2;
121 FUNCTION TO_LOTNOCFFORMULA RETURN VARCHAR2;
122 FUNCTION BEFOREPFORM RETURN BOOLEAN;
123 FUNCTION TARGET_DISPCFFORMULA(ASSAY_CODE IN VARCHAR2
124 ,QCASSY_TYP_ID IN NUMBER
125 ,TARGETCF IN VARCHAR2) RETURN CHAR;
126 FUNCTION MIN_DISPCFFORMULA(QCASSY_TYP_ID IN NUMBER
127 ,MIN_SPECCF IN NUMBER) RETURN CHAR;
128 FUNCTION MAX_DISPCFFORMULA(QCASSY_TYP_ID IN NUMBER
129 ,MAX_SPECCF IN NUMBER) RETURN CHAR;
130 FUNCTION MAX_DISP1CFFORMULA(QCASSY_TYP_ID1 IN NUMBER
131 ,MAX_SPEC1CF IN NUMBER) RETURN CHAR;
132 FUNCTION MIN_DISP1CFFORMULA(QCASSY_TYP_ID1 IN NUMBER
133 ,MIN_SPEC1CF IN NUMBER) RETURN CHAR;
134 FUNCTION TARGET_DISP1CFFORMULA(ASSAY_CODE2 IN VARCHAR2
135 ,QCASSY_TYP_ID1 IN NUMBER
136 ,TARGET1CF IN VARCHAR2) RETURN CHAR;
137 FUNCTION RESULT_DISP1CFFORMULA(QCASSY_TYP_ID1 IN NUMBER
138 ,NUM_RESULT2 IN NUMBER) RETURN CHAR;
139 FUNCTION RESULT_DISPCFFORMULA(QCASSY_TYP_ID IN NUMBER
140 ,NUM_RESULT IN NUMBER) RETURN CHAR;
141 FUNCTION MIN_CHARCFFORMULA(MIN_CHAR IN VARCHAR2) RETURN CHAR;
142 FUNCTION MIN_CHAR1CFFORMULA(MIN_CHAR1 IN VARCHAR2) RETURN CHAR;
143 FUNCTION MAX_CHARCFFORMULA(MAX_CHAR IN VARCHAR2) RETURN CHAR;
144 FUNCTION MAX_CHAR1CFFORMULA(MAX_CHAR1 IN VARCHAR2) RETURN CHAR;
145 FUNCTION NUM_RESULT2CFFORMULA(TEXT_RESULT2 IN VARCHAR2
146 ,NUM_RESULT2 IN NUMBER
147 ,TEST_TYPE1 IN VARCHAR2
148 ,PRECISION1 IN NUMBER) RETURN CHAR;
149 FUNCTION TEXT_RESULT2CFFORMULA(TEXT_RESULT2 IN VARCHAR2) RETURN CHAR;
150 FUNCTION TEXT_RESULTCFFORMULA(TEXT_RESULT IN VARCHAR2) RETURN CHAR;
151 FUNCTION NUM_RESULTCFFORMULA(TEXT_RESULT IN VARCHAR2
152 ,NUM_RESULT IN NUMBER
153 ,TEST_TYPE IN VARCHAR2
154 ,PRECISION IN NUMBER) RETURN CHAR;
155 FUNCTION AFTERPFORM RETURN BOOLEAN;
156 FUNCTION BETWEENPAGE RETURN BOOLEAN;
157 FUNCTION AFTERREPORT RETURN BOOLEAN;
158 FUNCTION SHIP_TO_SITECFFORMULA(SHIP_TO_SITE_ID IN NUMBER) RETURN CHAR;
159 FUNCTION ORDER_HEADERCFFORMULA(ORDER_HEADER_ID IN NUMBER) RETURN NUMBER;
160 FUNCTION OPERATING_UNITCFFORMULA(ORDER_ORG_ID IN NUMBER) RETURN CHAR;
161 FUNCTION CF_MINFORMULA(TEST_TYPE IN VARCHAR2
162 ,PRECISION IN NUMBER
163 ,MIN_SPEC IN NUMBER
164 ,MIN_CHAR IN VARCHAR2) RETURN CHAR;
165 FUNCTION CF_MAXFORMULA(TEST_TYPE IN VARCHAR2
166 ,PRECISION IN NUMBER
167 ,MAX_SPEC IN NUMBER
168 ,MAX_CHAR IN VARCHAR2) RETURN CHAR;
169 FUNCTION CF_MIN1FORMULA(TEST_TYPE1 IN VARCHAR2
170 ,PRECISION1 IN NUMBER
171 ,MIN_SPEC1 IN NUMBER
172 ,MIN_CHAR1 IN VARCHAR2) RETURN CHAR;
173 FUNCTION CF_MAX1FORMULA(TEST_TYPE1 IN VARCHAR2
174 ,PRECISION1 IN NUMBER
175 ,MAX_SPEC1 IN NUMBER
176 ,MAX_CHAR1 IN VARCHAR2) RETURN CHAR;
177 FUNCTION ORG_CFFORMULA RETURN CHAR;
178 FUNCTION ORDER_TYPECP_P RETURN VARCHAR2;
179 FUNCTION ASSAY_TYPECP_P RETURN VARCHAR2;
180 FUNCTION ACCEPT_CP_P RETURN VARCHAR2;
181 FUNCTION FINAL_CP_P RETURN VARCHAR2;
182 FUNCTION ASSAY_TYPE1CP_P RETURN VARCHAR2;
183 FUNCTION ACCEPT1_CP_P RETURN VARCHAR2;
184 FUNCTION FINAL1_CP_P RETURN VARCHAR2;
185 FUNCTION DATE1CP_P RETURN VARCHAR2;
186 FUNCTION FINAL1CP_P RETURN VARCHAR2;
187 FUNCTION CUST_VENDCP_P RETURN VARCHAR2;
188 FUNCTION CUST_VENDCP_1_P RETURN VARCHAR2;
189 FUNCTION ITEMCP_P RETURN VARCHAR2;
190 FUNCTION SAMPLECP_P RETURN VARCHAR2;
191 FUNCTION FROM_ITEMCP_P RETURN VARCHAR2;
192 FUNCTION TO_ITEMCP_P RETURN VARCHAR2;
193 FUNCTION FROM_SAMPLECP_P RETURN VARCHAR2;
194 FUNCTION TO_SAMPLECP_P RETURN VARCHAR2;
195 FUNCTION FROM_CUST_VENDCP_P RETURN VARCHAR2;
196 FUNCTION TO_CUST_VENDCP_P RETURN VARCHAR2;
197 FUNCTION FROM_RSLT_DTCP_P RETURN VARCHAR2;
198 FUNCTION TO_RSLT_DTCP_P RETURN VARCHAR2;
199 FUNCTION LOTNOCP_P RETURN VARCHAR2;
200 FUNCTION FROM_LOTNOCP_P RETURN VARCHAR2;
201 FUNCTION TO_LOTNOCP_P RETURN VARCHAR2;
202 FUNCTION ORG_CP_P RETURN VARCHAR2;
203 P_ROWS NUMBER(10);
204 END GMD_QCR01USR_XMLP_PKG;
205
206