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_SPEC_TESTS_PVT

Source


1 package GMD_SPEC_TESTS_PVT as
2 /* $Header: GMDVSPTS.pls 120.0 2005/05/25 19:14:48 appldev noship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_SPEC_ID in NUMBER,
6   X_TEST_ID in NUMBER,
7   X_ATTRIBUTE1 in VARCHAR2,
8   X_ATTRIBUTE2 in VARCHAR2,
9   X_MIN_VALUE_CHAR in VARCHAR2,
10   X_TEST_METHOD_ID in NUMBER,
11   X_SEQ in NUMBER,
12   X_FROM_BASE_IND in VARCHAR2,
13   X_EXCLUDE_IND in VARCHAR2,
14   X_MODIFIED_IND in VARCHAR2,
15   X_TEST_QTY in NUMBER,
16   X_TEST_QTY_UOM in VARCHAR2,
17   X_MIN_VALUE_NUM in NUMBER,
18   X_TARGET_VALUE_NUM in NUMBER,
19   X_MAX_VALUE_NUM in NUMBER,
20   X_ATTRIBUTE5 in VARCHAR2,
21   X_ATTRIBUTE6 in VARCHAR2,
22   X_ATTRIBUTE7 in VARCHAR2,
23   X_ATTRIBUTE8 in VARCHAR2,
24   X_ATTRIBUTE9 in VARCHAR2,
25   X_ATTRIBUTE10 in VARCHAR2,
26   X_ATTRIBUTE11 in VARCHAR2,
27   X_ATTRIBUTE12 in VARCHAR2,
28   X_ATTRIBUTE13 in VARCHAR2,
29   X_ATTRIBUTE14 in VARCHAR2,
30   X_ATTRIBUTE15 in VARCHAR2,
31   X_ATTRIBUTE16 in VARCHAR2,
32   X_ATTRIBUTE17 in VARCHAR2,
33   X_ATTRIBUTE18 in VARCHAR2,
34   X_USE_TO_CONTROL_STEP in VARCHAR2,
35   X_PRINT_SPEC_IND in VARCHAR2,
36   X_PRINT_RESULT_IND in VARCHAR2,
37   X_TEXT_CODE in NUMBER,
38   X_ATTRIBUTE_CATEGORY in VARCHAR2,
39   X_ATTRIBUTE3 in VARCHAR2,
40   X_RETEST_LOT_EXPIRY_IND in VARCHAR2,
41   X_ATTRIBUTE19 in VARCHAR2,
42   X_ATTRIBUTE20 in VARCHAR2,
43   X_MAX_VALUE_CHAR in VARCHAR2,
44   X_TEST_REPLICATE in NUMBER,
45   X_CHECK_RESULT_INTERVAL in NUMBER,
46   X_OUT_OF_SPEC_ACTION in VARCHAR2,
47   X_EXP_ERROR_TYPE in VARCHAR2,
48   X_BELOW_SPEC_MIN in NUMBER,
49   X_ABOVE_SPEC_MIN in NUMBER,
50   X_BELOW_SPEC_MAX in NUMBER,
51   X_ABOVE_SPEC_MAX in NUMBER,
52   X_BELOW_MIN_ACTION_CODE in VARCHAR2,
53   X_ABOVE_MIN_ACTION_CODE in VARCHAR2,
54   X_BELOW_MAX_ACTION_CODE in VARCHAR2,
55   X_ABOVE_MAX_ACTION_CODE in VARCHAR2,
56   X_OPTIONAL_IND in VARCHAR2,
57   X_DISPLAY_PRECISION in NUMBER,
58   X_REPORT_PRECISION in NUMBER,
59   X_TEST_PRIORITY in VARCHAR2,
60   X_PRINT_ON_COA_IND in VARCHAR2,
61   X_TARGET_VALUE_CHAR in VARCHAR2,
62   X_ATTRIBUTE4 in VARCHAR2,
63   X_ATTRIBUTE21 in VARCHAR2,
64   X_ATTRIBUTE22 in VARCHAR2,
65   X_ATTRIBUTE23 in VARCHAR2,
66   X_ATTRIBUTE24 in VARCHAR2,
67   X_ATTRIBUTE25 in VARCHAR2,
68   X_ATTRIBUTE26 in VARCHAR2,
69   X_ATTRIBUTE27 in VARCHAR2,
70   X_ATTRIBUTE28 in VARCHAR2,
71   X_ATTRIBUTE29 in VARCHAR2,
72   X_ATTRIBUTE30 in VARCHAR2,
73   X_TEST_DISPLAY in VARCHAR2,
74   X_CREATION_DATE in DATE,
75   X_CREATED_BY in NUMBER,
76   X_LAST_UPDATE_DATE in DATE,
77   X_LAST_UPDATED_BY in NUMBER,
78   X_LAST_UPDATE_LOGIN in NUMBER,
79   X_VIABILITY_DURATION in number,
80   X_TEST_EXPIRATION_DAYS in number,
81   X_TEST_EXPIRATION_HOURS in number,
82   X_TEST_EXPIRATION_MINUTES in number,
83   X_TEST_EXPIRATION_SECONDS in number,
84   X_CALC_UOM_CONV_IND in VARCHAR2,
85   X_TO_QTY_UOM in VARCHAR2
86 	);
87 
88 
89 procedure LOCK_ROW (
90   X_SPEC_ID in NUMBER,
91   X_TEST_ID in NUMBER,
92   X_ATTRIBUTE1 in VARCHAR2,
93   X_ATTRIBUTE2 in VARCHAR2,
94   X_MIN_VALUE_CHAR in VARCHAR2,
95   X_TEST_METHOD_ID in NUMBER,
96   X_SEQ in NUMBER,
97   X_FROM_BASE_IND in VARCHAR2,
98   X_EXCLUDE_IND in VARCHAR2,
99   X_MODIFIED_IND in VARCHAR2,
100   X_TEST_QTY in NUMBER,
101   X_TEST_QTY_UOM in VARCHAR2,
102   X_MIN_VALUE_NUM in NUMBER,
103   X_TARGET_VALUE_NUM in NUMBER,
104   X_MAX_VALUE_NUM in NUMBER,
105   X_ATTRIBUTE5 in VARCHAR2,
106   X_ATTRIBUTE6 in VARCHAR2,
107   X_ATTRIBUTE7 in VARCHAR2,
108   X_ATTRIBUTE8 in VARCHAR2,
109   X_ATTRIBUTE9 in VARCHAR2,
110   X_ATTRIBUTE10 in VARCHAR2,
111   X_ATTRIBUTE11 in VARCHAR2,
112   X_ATTRIBUTE12 in VARCHAR2,
113   X_ATTRIBUTE13 in VARCHAR2,
114   X_ATTRIBUTE14 in VARCHAR2,
115   X_ATTRIBUTE15 in VARCHAR2,
116   X_ATTRIBUTE16 in VARCHAR2,
117   X_ATTRIBUTE17 in VARCHAR2,
118   X_ATTRIBUTE18 in VARCHAR2,
119   X_USE_TO_CONTROL_STEP in VARCHAR2,
120   X_PRINT_SPEC_IND in VARCHAR2,
121   X_PRINT_RESULT_IND in VARCHAR2,
122   X_TEXT_CODE in NUMBER,
123   X_ATTRIBUTE_CATEGORY in VARCHAR2,
124   X_ATTRIBUTE3 in VARCHAR2,
125   X_RETEST_LOT_EXPIRY_IND in VARCHAR2,
126   X_ATTRIBUTE19 in VARCHAR2,
127   X_ATTRIBUTE20 in VARCHAR2,
128   X_MAX_VALUE_CHAR in VARCHAR2,
129   X_TEST_REPLICATE in NUMBER,
130   X_CHECK_RESULT_INTERVAL in NUMBER,
131   X_OUT_OF_SPEC_ACTION in VARCHAR2,
132   X_EXP_ERROR_TYPE in VARCHAR2,
133   X_BELOW_SPEC_MIN in NUMBER,
134   X_ABOVE_SPEC_MIN in NUMBER,
135   X_BELOW_SPEC_MAX in NUMBER,
136   X_ABOVE_SPEC_MAX in NUMBER,
137   X_BELOW_MIN_ACTION_CODE in VARCHAR2,
138   X_ABOVE_MIN_ACTION_CODE in VARCHAR2,
139   X_BELOW_MAX_ACTION_CODE in VARCHAR2,
140   X_ABOVE_MAX_ACTION_CODE in VARCHAR2,
141   X_OPTIONAL_IND in VARCHAR2,
142   X_DISPLAY_PRECISION in NUMBER,
143   X_REPORT_PRECISION in NUMBER,
144   X_TEST_PRIORITY in VARCHAR2,
145   X_PRINT_ON_COA_IND in VARCHAR2,
146   X_TARGET_VALUE_CHAR in VARCHAR2,
147   X_ATTRIBUTE4 in VARCHAR2,
148   X_ATTRIBUTE21 in VARCHAR2,
149   X_ATTRIBUTE22 in VARCHAR2,
150   X_ATTRIBUTE23 in VARCHAR2,
151   X_ATTRIBUTE24 in VARCHAR2,
152   X_ATTRIBUTE25 in VARCHAR2,
153   X_ATTRIBUTE26 in VARCHAR2,
154   X_ATTRIBUTE27 in VARCHAR2,
155   X_ATTRIBUTE28 in VARCHAR2,
156   X_ATTRIBUTE29 in VARCHAR2,
157   X_ATTRIBUTE30 in VARCHAR2,
158   X_TEST_DISPLAY in VARCHAR2,
159   X_VIABILITY_DURATION in number,
160   X_TEST_EXPIRATION_DAYS in number,
161   X_TEST_EXPIRATION_HOURS in number,
162   X_TEST_EXPIRATION_MINUTES in number,
163   X_TEST_EXPIRATION_SECONDS in number,
164   X_CALC_UOM_CONV_IND in VARCHAR2,
165   X_TO_QTY_UOM in VARCHAR2
166 );
167 
168 
169 procedure UPDATE_ROW (
170   X_SPEC_ID in NUMBER,
171   X_TEST_ID in NUMBER,
172   X_ATTRIBUTE1 in VARCHAR2,
173   X_ATTRIBUTE2 in VARCHAR2,
174   X_MIN_VALUE_CHAR in VARCHAR2,
175   X_TEST_METHOD_ID in NUMBER,
176   X_SEQ in NUMBER,
177   X_FROM_BASE_IND in VARCHAR2,
178   X_EXCLUDE_IND in VARCHAR2,
179   X_MODIFIED_IND in VARCHAR2,
180   X_TEST_QTY in NUMBER,
181   X_TEST_QTY_UOM in VARCHAR2,
182   X_MIN_VALUE_NUM in NUMBER,
183   X_TARGET_VALUE_NUM in NUMBER,
184   X_MAX_VALUE_NUM in NUMBER,
185   X_ATTRIBUTE5 in VARCHAR2,
186   X_ATTRIBUTE6 in VARCHAR2,
187   X_ATTRIBUTE7 in VARCHAR2,
188   X_ATTRIBUTE8 in VARCHAR2,
189   X_ATTRIBUTE9 in VARCHAR2,
190   X_ATTRIBUTE10 in VARCHAR2,
191   X_ATTRIBUTE11 in VARCHAR2,
192   X_ATTRIBUTE12 in VARCHAR2,
193   X_ATTRIBUTE13 in VARCHAR2,
194   X_ATTRIBUTE14 in VARCHAR2,
195   X_ATTRIBUTE15 in VARCHAR2,
196   X_ATTRIBUTE16 in VARCHAR2,
197   X_ATTRIBUTE17 in VARCHAR2,
198   X_ATTRIBUTE18 in VARCHAR2,
199   X_USE_TO_CONTROL_STEP in VARCHAR2,
200   X_PRINT_SPEC_IND in VARCHAR2,
201   X_PRINT_RESULT_IND in VARCHAR2,
202   X_TEXT_CODE in NUMBER,
203   X_ATTRIBUTE_CATEGORY in VARCHAR2,
204   X_ATTRIBUTE3 in VARCHAR2,
205   X_RETEST_LOT_EXPIRY_IND in VARCHAR2,
206   X_ATTRIBUTE19 in VARCHAR2,
207   X_ATTRIBUTE20 in VARCHAR2,
208   X_MAX_VALUE_CHAR in VARCHAR2,
209   X_TEST_REPLICATE in NUMBER,
210   X_CHECK_RESULT_INTERVAL in NUMBER,
211   X_OUT_OF_SPEC_ACTION in VARCHAR2,
212   X_EXP_ERROR_TYPE in VARCHAR2,
213   X_BELOW_SPEC_MIN in NUMBER,
214   X_ABOVE_SPEC_MIN in NUMBER,
215   X_BELOW_SPEC_MAX in NUMBER,
216   X_ABOVE_SPEC_MAX in NUMBER,
217   X_BELOW_MIN_ACTION_CODE in VARCHAR2,
218   X_ABOVE_MIN_ACTION_CODE in VARCHAR2,
219   X_BELOW_MAX_ACTION_CODE in VARCHAR2,
220   X_ABOVE_MAX_ACTION_CODE in VARCHAR2,
221   X_OPTIONAL_IND in VARCHAR2,
222   X_DISPLAY_PRECISION in NUMBER,
223   X_REPORT_PRECISION in NUMBER,
224   X_TEST_PRIORITY in VARCHAR2,
225   X_PRINT_ON_COA_IND in VARCHAR2,
226   X_TARGET_VALUE_CHAR in VARCHAR2,
227   X_ATTRIBUTE4 in VARCHAR2,
228   X_ATTRIBUTE21 in VARCHAR2,
229   X_ATTRIBUTE22 in VARCHAR2,
230   X_ATTRIBUTE23 in VARCHAR2,
231   X_ATTRIBUTE24 in VARCHAR2,
232   X_ATTRIBUTE25 in VARCHAR2,
233   X_ATTRIBUTE26 in VARCHAR2,
234   X_ATTRIBUTE27 in VARCHAR2,
235   X_ATTRIBUTE28 in VARCHAR2,
236   X_ATTRIBUTE29 in VARCHAR2,
237   X_ATTRIBUTE30 in VARCHAR2,
238   X_TEST_DISPLAY in VARCHAR2,
239   X_LAST_UPDATE_DATE in DATE,
240   X_LAST_UPDATED_BY in NUMBER,
241   X_LAST_UPDATE_LOGIN in NUMBER,
242   X_VIABILITY_DURATION in number,
243   X_TEST_EXPIRATION_DAYS in number,
244   X_TEST_EXPIRATION_HOURS in number,
245   X_TEST_EXPIRATION_MINUTES in number,
246   X_TEST_EXPIRATION_SECONDS in number,
247   X_CALC_UOM_CONV_IND in VARCHAR2,
248   X_TO_QTY_UOM in VARCHAR2
249 );
250 
251 
252 FUNCTION DELETE_ROW (
253   P_SPEC_ID in NUMBER,
254   P_TEST_ID in NUMBER
255 ) RETURN BOOLEAN ;
256 
257 procedure ADD_LANGUAGE;
258 
259 FUNCTION fetch_row (
260   p_spec_tests IN  gmd_spec_tests%ROWTYPE
261 , x_spec_tests OUT NOCOPY gmd_spec_tests%ROWTYPE
262 )
263 RETURN BOOLEAN;
264 
265 FUNCTION lock_row(
266   p_spec_id   IN  NUMBER
267 , p_test_id   IN  NUMBER
268 )
269 RETURN BOOLEAN;
270 
271 FUNCTION INSERT_ROW (
272 p_spec_tests IN OUT NOCOPY GMD_SPEC_TESTS%ROWTYPE
273 )
274 RETURN BOOLEAN;
275 end GMD_SPEC_TESTS_PVT;