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_QCR03USR_XMLP_PKG

Source


1 PACKAGE GMD_QCR03USR_XMLP_PKG AS
2 /* $Header: QCR03USRS.pls 120.0 2007/12/24 13:09:00 krreddy noship $ */
3   FROM_SAMPLE VARCHAR2(40);
4   TO_SAMPLE VARCHAR2(40);
5   FROM_BATCH VARCHAR2(40);
6   TO_BATCH VARCHAR2(40);
7   FROM_FORMULA VARCHAR2(40);
8   TO_FORMULA VARCHAR2(40);
9   FROM_ROUTING VARCHAR2(40);
10   TO_ROUTING VARCHAR2(40);
11   FROM_FORMULA_VERSION VARCHAR2(40);
12   TO_FORMULA_VERSION VARCHAR2(40);
13   FROM_ROUTING_VERSION VARCHAR2(40);
14   TO_ROUTING_VERSION VARCHAR2(40);
15   FROM_ROUTING_STEP_NO NUMBER;
16   TO_ROUTING_STEP_NO NUMBER;
17   FROM_OPERATION VARCHAR2(40);
18   TO_OPERATION VARCHAR2(40);
19   FROM_ITEM VARCHAR2(40);
20   TO_ITEM VARCHAR2(40);
21   FROM_RESULT_DATE DATE;
22   TO_RESULT_DATE DATE;
23   INCLUDE VARCHAR2(40);
24   PRINT_CONDITION VARCHAR2(30);
25   P_ORGN VARCHAR2(40);
26   SY_ALL VARCHAR2(3);
27   NONBLOCKSQL VARCHAR2(3);
28   FROM_LOTNO VARCHAR2(32);
29   TO_LOTNO VARCHAR2(32);
30   FROM_SUBLOT VARCHAR2(40);
31   TO_SUBLOT VARCHAR2(32);
32   P_ORGANIZATION_ID VARCHAR2(40);
33   P_CONC_REQUEST_ID NUMBER;
34   ASSAY_TYPECP VARCHAR2(1);
35   FINAL_CP VARCHAR2(32767);
36   ACCEPT_CP VARCHAR2(32767);
37   SAMPLECP VARCHAR2(300);
38   --BATCHCP VARCHAR2(300);
39   BATCHCP VARCHAR2(300):=' ';
40   --FORMULACP VARCHAR2(300);
41   FORMULACP VARCHAR2(300):=' ';
42   --FORMULA_VERSCP VARCHAR2(300);
43   FORMULA_VERSCP VARCHAR2(300):= ' ';
44   --ROUTINGCP VARCHAR2(300);
45   ROUTINGCP VARCHAR2(300):=' ';
46   --ROUTING_VERSCP VARCHAR2(300);
47   ROUTING_VERSCP VARCHAR2(300):= ' ';
48   --ITEMCP VARCHAR2(300);
49   ITEMCP VARCHAR2(300):=  ' ';
50   --DATE1CP VARCHAR2(300);
51   DATE1CP VARCHAR2(300):=' ';
52   OPRNNOCP VARCHAR2(100);
53   --OPRNTBLCP VARCHAR2(100);
54   OPRNTBLCP VARCHAR2(100):= ' ';
55   --OPRNCP VARCHAR2(300);
56   OPRNCP VARCHAR2(300):=' ';
57   ROUTSTEPCP VARCHAR2(100);
58   ROUTSTEPTBLCP VARCHAR2(100);
59   --ROUT_STEPNOCP VARCHAR2(300);
60   ROUT_STEPNOCP VARCHAR2(300):= ' ';
61   ORDERCP VARCHAR2(100);
62   --FINAL1CP VARCHAR2(200);
63   FINAL1CP VARCHAR2(200):= ' ';
64   FROM_ITEMCP VARCHAR2(32);
65   TO_ITEMCP VARCHAR2(32);
66   FROM_SAMPLECP VARCHAR2(32);
67   TO_SAMPLECP VARCHAR2(32);
68   FROM_RSLT_DTCP VARCHAR2(11);
69   TO_RSLT_DTCP VARCHAR2(11);
70   FROM_FORMULACP VARCHAR2(32);
71   TO_FORMULACP VARCHAR2(32);
72   FROM_BATCHCP VARCHAR2(32);
73   TO_BATCHCP VARCHAR2(32);
74   FROM_OPERATIONCP VARCHAR2(16);
75   TO_OPERATIONCP VARCHAR2(16);
76   FROM_ROUTINGCP VARCHAR2(32);
77   TO_ROUTINGCP VARCHAR2(32);
78   FROM_ROUTING_STEP_NOCP VARCHAR2(5);
79   TO_ROUTING_STEP_NOCP VARCHAR2(5);
80   FROM_ROUTING_VERSIONCP VARCHAR2(5);
81   TO_ROUTING_VERSIONCP VARCHAR2(5);
82   FROM_FORMULA_VERSIONCP VARCHAR2(5);
83   TO_FORMULA_VERSIONCP VARCHAR2(5);
84   --LOTNOCP VARCHAR2(500);
85   LOTNOCP VARCHAR2(500):=' ';
86   FROM_LOTNOCP VARCHAR2(32);
87   TO_LOTNOCP VARCHAR2(32);
88   ORGCP VARCHAR2(20);
89   FUNCTION SAMPLECFFORMULA RETURN VARCHAR2;
90   FUNCTION BATCHCFFORMULA RETURN VARCHAR2;
91   FUNCTION FORMULACFFORMULA RETURN VARCHAR2;
92   FUNCTION FORMULA_VERSCFFORMULA RETURN VARCHAR2;
93   FUNCTION ROUTINGCFFORMULA RETURN VARCHAR2;
94   FUNCTION ROUTING_VERSCFFORMULA RETURN VARCHAR2;
95   FUNCTION ITEMCFFORMULA RETURN VARCHAR2;
96   FUNCTION DATE1CFFORMULA RETURN VARCHAR2;
97   FUNCTION OPRNCFFORMULA RETURN VARCHAR2;
98   FUNCTION OPRNCFFORMULA0032 RETURN VARCHAR2;
99   FUNCTION OPRNTBLCFFORMULA RETURN VARCHAR2;
100   FUNCTION ROUTSTEPCFFORMULA RETURN VARCHAR2;
101   FUNCTION ROUTSTEPTBLCFFORMULA RETURN VARCHAR2;
102   FUNCTION ROUT_STEPNOCFFORMULA RETURN VARCHAR2;
103   FUNCTION ORDERCFFORMULA RETURN VARCHAR2;
104   FUNCTION FINAL1CFFORMULA RETURN VARCHAR2;
105   FUNCTION ASSAY_DESCCFFORMULA(ASSAY_CODE IN VARCHAR2) RETURN VARCHAR2;
106   FUNCTION TEXTCFFORMULA(TEXT_SPEC IN VARCHAR2) RETURN VARCHAR2;
107   FUNCTION TARGETCFFORMULA(TEXT_SPEC IN VARCHAR2
108                           ,TARGET_SPEC IN NUMBER
109                           ,TEST_TYPE IN VARCHAR2
110                           ,PRECISION IN NUMBER) RETURN CHAR;
111   FUNCTION QCUNIT_CODECFFORMULA(QC_SPEC_ID IN NUMBER
112                                ,ASSAY_CODE IN VARCHAR2
113                                ,QCASSY_TYP_ID IN NUMBER) RETURN VARCHAR2;
114   FUNCTION MIN_SPECCFFORMULA(MIN_CHAR IN VARCHAR2
115                             ,MIN_SPEC IN NUMBER
116                             ,TEST_TYPE IN VARCHAR2
117                             ,PRECISION IN NUMBER) RETURN CHAR;
118   FUNCTION MAX_SPECCFFORMULA(MAX_CHAR IN VARCHAR2
119                             ,MAX_SPEC IN NUMBER
120                             ,TEST_TYPE IN VARCHAR2
121                             ,PRECISION IN NUMBER) RETURN CHAR;
122   --FUNCTION FROM_DATECFFORMULA(SAMPLE_NO IN VARCHAR2) RETURN DATE;
123   FUNCTION FROM_DATECFFORMULA(SAMPLE_NO_V IN VARCHAR2) RETURN DATE;
124   --FUNCTION TO_DATECFFORMULA(SAMPLE_NO IN VARCHAR2) RETURN DATE;
125   FUNCTION TO_DATECFFORMULA(SAMPLE_NO_V IN VARCHAR2) RETURN DATE;
126   FUNCTION TEXTARRAYCFFORMULA(TEXTCODECF IN NUMBER) RETURN VARCHAR2;
127   FUNCTION TEXT_CODECFFORMULA(QC_SPEC_ID IN NUMBER) RETURN NUMBER;
128   --FUNCTION TEXTARRAY2CFFORMULA(TEXT_CODE IN NUMBER) RETURN VARCHAR2;
129   FUNCTION TEXTARRAY2CFFORMULA(TEXT_CODE_V IN NUMBER) RETURN VARCHAR2;
130  /* FUNCTION STEPCFFORMULA(ROUTING_ID IN NUMBER
131                         ,ROUTINGSTEP_ID IN NUMBER) RETURN NUMBER;*/
132  FUNCTION STEPCFFORMULA(ROUTING_ID_V IN NUMBER
133                         ,ROUTINGSTEP_ID_V IN NUMBER) RETURN NUMBER;
134   --FUNCTION OPERATIONCFFORMULA(OPRN_ID IN NUMBER) RETURN VARCHAR2;
135   FUNCTION OPERATIONCFFORMULA(OPRN_ID_V IN NUMBER) RETURN VARCHAR2;
136   FUNCTION FROM_ITEMCFFORMULA RETURN VARCHAR2;
137   FUNCTION TO_ITEMCFFORMULA RETURN VARCHAR2;
138   FUNCTION FROM_SAMPLECFFORMULA RETURN VARCHAR2;
139   FUNCTION TO_SAMPLECFFORMULA RETURN VARCHAR2;
140   FUNCTION FROM_RSLT_DTCFFORMULA RETURN VARCHAR2;
141   FUNCTION TO_RSLT_DTCFFORMULA RETURN VARCHAR2;
142   FUNCTION FROM_FORMULACFFORMULA RETURN VARCHAR2;
143   FUNCTION TO_FORMULACFFORMULA RETURN VARCHAR2;
144   FUNCTION FROM_BATCHCFFORMULA RETURN VARCHAR2;
145   FUNCTION TO_BATCHCFFORMULA RETURN VARCHAR2;
146   FUNCTION FROM_OPERATIONCFFORMULA RETURN VARCHAR2;
147   FUNCTION TO_OPERATIONCFFORMULA RETURN VARCHAR2;
148   FUNCTION FROM_ROUTINGCFFORMULA RETURN VARCHAR2;
149   FUNCTION TO_ROUTINGCFFORMULA RETURN VARCHAR2;
150   FUNCTION FROM_ROUTING_STEPNOCFFORMULA RETURN VARCHAR2;
151   FUNCTION TO_ROUTING_STEP_NOCFFORMULA RETURN VARCHAR2;
152   FUNCTION FROM_ROUTING_VERSIONCFFORMULA RETURN VARCHAR2;
153   FUNCTION TO_ROUTING_VERSIONCFFORMULA RETURN VARCHAR2;
154   FUNCTION FROM_FORMULA_VERSIONCFFORMULA RETURN VARCHAR2;
155   FUNCTION TO_FORMULA_VERSIONCFFORMULA RETURN VARCHAR2;
156   FUNCTION TEXTCODERSLTCFFORMULA(QC_RESULT_ID IN NUMBER
157                                 ,ASSAY_CODE IN VARCHAR2) RETURN NUMBER;
158   FUNCTION INCLUDE_TEXTCFFORMULA RETURN VARCHAR2;
159   FUNCTION PRINT_TEXTCFFORMULA RETURN VARCHAR2;
160   FUNCTION BEFOREREPORT RETURN BOOLEAN;
161   FUNCTION ACCEPT_CFFORMULA(ACCEPT_ANYWAY IN VARCHAR2) RETURN VARCHAR2;
162   FUNCTION FINAL_CFFORMULA(FINAL_MARK IN VARCHAR2) RETURN VARCHAR2 ;
163   PROCEDURE GMD_QCR03USR_XMLP_PKG_HEADER;
164   FUNCTION FROM_LOTNOCFFORMULA RETURN VARCHAR2;
165   FUNCTION LOTCFFORMULA RETURN VARCHAR2;
166   FUNCTION TO_LOTNOCFFORMULA RETURN VARCHAR2;
167   FUNCTION BEFOREPFORM RETURN BOOLEAN;
168   FUNCTION AFTERPFORM RETURN BOOLEAN;
169   --FUNCTION OPRN_VERSCFFORMULA0017(OPRN_ID IN NUMBER) RETURN NUMBER;
170   FUNCTION OPRN_VERSCFFORMULA0017(OPRN_ID_V IN NUMBER) RETURN NUMBER;
171   FUNCTION ORDERCPFORMULA RETURN CHAR;
172   FUNCTION ROUTSTEPCPFORMULA RETURN CHAR;
173   FUNCTION ROUT_STEPNOCPFORMULA RETURN CHAR;
174   FUNCTION ASSAY_DISPLAYCFFORMULA(ASSAY_CODE IN VARCHAR2
175                                  ,QCASSY_TYP_ID IN NUMBER
176                                  ,TARGETCF IN VARCHAR2) RETURN CHAR;
177   FUNCTION ASSAYMIN_DISPCFFORMULA(QCASSY_TYP_ID IN NUMBER
178                                  ,MIN_SPECCF IN VARCHAR2) RETURN CHAR;
179   FUNCTION ASSAYMAX_DISPCFFORMULA(QCASSY_TYP_ID IN NUMBER
180                                  ,MAX_SPECCF IN VARCHAR2) RETURN CHAR;
181   FUNCTION RESULT_DISPCFFORMULA(QCASSY_TYP_ID IN NUMBER
182                                ,NUM_RESULT IN NUMBER) RETURN CHAR;
183   FUNCTION MAX_CHARCFFORMULA(MAX_CHAR IN VARCHAR2) RETURN CHAR;
184   FUNCTION MIN_CHARCFFORMULA(MIN_CHAR IN VARCHAR2) RETURN CHAR;
185   FUNCTION RESULT_NUMCFFORMULA(TEXT_RESULT IN VARCHAR2
186                               ,NUM_RESULT IN NUMBER
187                               ,TEST_TYPE IN VARCHAR2
188                               ,PRECISION IN NUMBER) RETURN CHAR;
189   FUNCTION ORGCFFORMULA RETURN CHAR;
190   FUNCTION AFTERREPORT RETURN BOOLEAN;
191   FUNCTION ASSAY_TYPECP_P RETURN VARCHAR2;
192   FUNCTION SAMPLECP_P RETURN VARCHAR2;
193   FUNCTION BATCHCP_P RETURN VARCHAR2;
194   FUNCTION FORMULACP_P RETURN VARCHAR2;
195   FUNCTION FORMULA_VERSCP_P RETURN VARCHAR2;
196   FUNCTION ROUTINGCP_P RETURN VARCHAR2;
197   FUNCTION ROUTING_VERSCP_P RETURN VARCHAR2;
198   FUNCTION ITEMCP_P RETURN VARCHAR2;
199   FUNCTION DATE1CP_P RETURN VARCHAR2;
200   FUNCTION OPRNNOCP_P RETURN VARCHAR2;
201   FUNCTION OPRNTBLCP_P RETURN VARCHAR2;
202   FUNCTION OPRNCP_P RETURN VARCHAR2;
203   FUNCTION ROUTSTEPCP_P RETURN VARCHAR2;
204   FUNCTION ROUTSTEPTBLCP_P RETURN VARCHAR2;
205   FUNCTION ROUT_STEPNOCP_P RETURN VARCHAR2;
206   FUNCTION ORDERCP_P RETURN VARCHAR2;
207   FUNCTION FINAL1CP_P RETURN VARCHAR2;
208   FUNCTION FROM_ITEMCP_P RETURN VARCHAR2;
209   FUNCTION TO_ITEMCP_P RETURN VARCHAR2;
210   FUNCTION FROM_SAMPLECP_P RETURN VARCHAR2;
211   FUNCTION TO_SAMPLECP_P RETURN VARCHAR2;
212   FUNCTION FROM_RSLT_DTCP_P RETURN VARCHAR2;
213   FUNCTION TO_RSLT_DTCP_P RETURN VARCHAR2;
214   FUNCTION FROM_FORMULACP_P RETURN VARCHAR2;
215   FUNCTION TO_FORMULACP_P RETURN VARCHAR2;
216   FUNCTION FROM_BATCHCP_P RETURN VARCHAR2;
217   FUNCTION TO_BATCHCP_P RETURN VARCHAR2;
218   FUNCTION FROM_OPERATIONCP_P RETURN VARCHAR2;
219   FUNCTION TO_OPERATIONCP_P RETURN VARCHAR2;
220   FUNCTION FROM_ROUTINGCP_P RETURN VARCHAR2;
221   FUNCTION TO_ROUTINGCP_P RETURN VARCHAR2;
222   FUNCTION FROM_ROUTING_STEP_NOCP_P RETURN VARCHAR2;
223   FUNCTION TO_ROUTING_STEP_NOCP_P RETURN VARCHAR2;
224   FUNCTION FROM_ROUTING_VERSIONCP_P RETURN VARCHAR2;
225   FUNCTION TO_ROUTING_VERSIONCP_P RETURN VARCHAR2;
226   FUNCTION FROM_FORMULA_VERSIONCP_P RETURN VARCHAR2;
227   FUNCTION TO_FORMULA_VERSIONCP_P RETURN VARCHAR2;
228   FUNCTION LOTNOCP_P RETURN VARCHAR2;
229   FUNCTION FROM_LOTNOCP_P RETURN VARCHAR2;
230   FUNCTION TO_LOTNOCP_P RETURN VARCHAR2;
231   FUNCTION ORGCP_P RETURN VARCHAR2;
232 END GMD_QCR03USR_XMLP_PKG;
233