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_QC_TESTS_PVT

Source


1 PACKAGE gmd_qc_tests_pvt AUTHID CURRENT_USER AS
2 /* $Header: GMDVTSTS.pls 115.4 2004/05/05 09:46:51 rboddu noship $ */
3 
4 FUNCTION insert_row(p_qc_tests_rec IN OUT NOCOPY GMD_QC_TESTS%ROWTYPE) RETURN BOOLEAN;
5 
6 PROCEDURE insert_row (
7   X_ROWID in out NOCOPY ROWID,
8   X_TEST_ID in out NOCOPY NUMBER,
9   X_TEST_OPRN_LINE_ID in NUMBER,
10   X_TEST_PROVIDER_CODE in VARCHAR2,
11   X_DELETE_MARK in NUMBER,
12   X_TEXT_CODE in NUMBER,
13   X_ATTRIBUTE_CATEGORY in VARCHAR2,
14   X_ATTRIBUTE1 in VARCHAR2,
15   X_ATTRIBUTE2 in VARCHAR2,
16   X_ATTRIBUTE3 in VARCHAR2,
17   X_ATTRIBUTE4 in VARCHAR2,
18   X_ATTRIBUTE5 in VARCHAR2,
19   X_ATTRIBUTE6 in VARCHAR2,
20   X_ATTRIBUTE7 in VARCHAR2,
21   X_ATTRIBUTE8 in VARCHAR2,
22   X_ATTRIBUTE9 in VARCHAR2,
23   X_ATTRIBUTE10 in VARCHAR2,
24   X_ATTRIBUTE11 in VARCHAR2,
25   X_ATTRIBUTE12 in VARCHAR2,
26   X_ATTRIBUTE13 in VARCHAR2,
27   X_ATTRIBUTE14 in VARCHAR2,
28   X_ATTRIBUTE15 in VARCHAR2,
29   X_ATTRIBUTE16 in VARCHAR2,
30   X_ATTRIBUTE17 in VARCHAR2,
31   X_ATTRIBUTE18 in VARCHAR2,
32   X_ATTRIBUTE19 in VARCHAR2,
33   X_ATTRIBUTE20 in VARCHAR2,
34   X_ATTRIBUTE21 in VARCHAR2,
35   X_ATTRIBUTE22 in VARCHAR2,
36   X_ATTRIBUTE23 in VARCHAR2,
37   X_ATTRIBUTE24 in VARCHAR2,
38   X_ATTRIBUTE25 in VARCHAR2,
39   X_ATTRIBUTE26 in VARCHAR2,
40   X_ATTRIBUTE27 in VARCHAR2,
41   X_ATTRIBUTE28 in VARCHAR2,
42   X_ATTRIBUTE29 in VARCHAR2,
43   X_ATTRIBUTE30 in VARCHAR2,
44   X_TEST_CODE in VARCHAR2,
45   X_TEST_METHOD_ID in NUMBER,
46   X_TEST_CLASS in VARCHAR2,
47   X_TEST_TYPE in VARCHAR2,
48   X_TEST_UNIT in VARCHAR2,
49   X_MIN_VALUE_NUM in NUMBER,
50   X_MAX_VALUE_NUM in NUMBER,
51   X_EXP_ERROR_TYPE in VARCHAR2,
52   X_BELOW_SPEC_MIN in NUMBER,
53   X_ABOVE_SPEC_MIN in NUMBER,
54   X_BELOW_SPEC_MAX in NUMBER,
55   X_ABOVE_SPEC_MAX in NUMBER,
56   X_BELOW_MIN_ACTION_CODE in VARCHAR2,
57   X_ABOVE_MIN_ACTION_CODE in VARCHAR2,
58   X_BELOW_MAX_ACTION_CODE in VARCHAR2,
59   X_ABOVE_MAX_ACTION_CODE in VARCHAR2,
60   X_EXPRESSION in VARCHAR2,
61   X_DISPLAY_PRECISION in NUMBER,
62   X_REPORT_PRECISION in NUMBER,
63   X_PRIORITY in VARCHAR2,
64   X_TEST_OPRN_ID in NUMBER,
65   X_TEST_DESC in VARCHAR2,
66   X_CREATION_DATE in DATE,
67   X_CREATED_BY in NUMBER,
68   X_LAST_UPDATE_DATE in DATE,
69   X_LAST_UPDATED_BY in NUMBER,
70   X_LAST_UPDATE_LOGIN in NUMBER,
71   X_TEST_GROUP_ORDER IN NUMBER DEFAULT NULL);
72 
73 PROCEDURE lock_row (
74   X_TEST_ID in NUMBER,
75   X_TEST_OPRN_LINE_ID in NUMBER,
76   X_TEST_PROVIDER_CODE in VARCHAR2,
77   X_DELETE_MARK in NUMBER,
78   X_TEXT_CODE in NUMBER,
79   X_ATTRIBUTE_CATEGORY in VARCHAR2,
80   X_ATTRIBUTE1 in VARCHAR2,
81   X_ATTRIBUTE2 in VARCHAR2,
82   X_ATTRIBUTE3 in VARCHAR2,
83   X_ATTRIBUTE4 in VARCHAR2,
84   X_ATTRIBUTE5 in VARCHAR2,
85   X_ATTRIBUTE6 in VARCHAR2,
86   X_ATTRIBUTE7 in VARCHAR2,
87   X_ATTRIBUTE8 in VARCHAR2,
88   X_ATTRIBUTE9 in VARCHAR2,
89   X_ATTRIBUTE10 in VARCHAR2,
90   X_ATTRIBUTE11 in VARCHAR2,
91   X_ATTRIBUTE12 in VARCHAR2,
92   X_ATTRIBUTE13 in VARCHAR2,
93   X_ATTRIBUTE14 in VARCHAR2,
94   X_ATTRIBUTE15 in VARCHAR2,
95   X_ATTRIBUTE16 in VARCHAR2,
96   X_ATTRIBUTE17 in VARCHAR2,
97   X_ATTRIBUTE18 in VARCHAR2,
98   X_ATTRIBUTE19 in VARCHAR2,
99   X_ATTRIBUTE20 in VARCHAR2,
100   X_ATTRIBUTE21 in VARCHAR2,
101   X_ATTRIBUTE22 in VARCHAR2,
102   X_ATTRIBUTE23 in VARCHAR2,
103   X_ATTRIBUTE24 in VARCHAR2,
104   X_ATTRIBUTE25 in VARCHAR2,
105   X_ATTRIBUTE26 in VARCHAR2,
106   X_ATTRIBUTE27 in VARCHAR2,
107   X_ATTRIBUTE28 in VARCHAR2,
108   X_ATTRIBUTE29 in VARCHAR2,
109   X_ATTRIBUTE30 in VARCHAR2,
110   X_TEST_CODE in VARCHAR2,
111   X_TEST_METHOD_ID in NUMBER,
112   X_TEST_CLASS in VARCHAR2,
113   X_TEST_TYPE in VARCHAR2,
114   X_TEST_UNIT in VARCHAR2,
115   X_MIN_VALUE_NUM in NUMBER,
116   X_MAX_VALUE_NUM in NUMBER,
117   X_EXP_ERROR_TYPE in VARCHAR2,
118   X_BELOW_SPEC_MIN in NUMBER,
119   X_ABOVE_SPEC_MIN in NUMBER,
120   X_BELOW_SPEC_MAX in NUMBER,
121   X_ABOVE_SPEC_MAX in NUMBER,
122   X_BELOW_MIN_ACTION_CODE in VARCHAR2,
123   X_ABOVE_MIN_ACTION_CODE in VARCHAR2,
124   X_BELOW_MAX_ACTION_CODE in VARCHAR2,
125   X_ABOVE_MAX_ACTION_CODE in VARCHAR2,
126   X_EXPRESSION in VARCHAR2,
127   X_DISPLAY_PRECISION in NUMBER,
128   X_REPORT_PRECISION in NUMBER,
129   X_PRIORITY in VARCHAR2,
130   X_TEST_OPRN_ID in NUMBER,
131   X_TEST_DESC in VARCHAR2,
132   X_TEST_GROUP_ORDER IN NUMBER DEFAULT NULL
133 );
134 
135 PROCEDURE update_row (
136   X_TEST_ID in NUMBER,
137   X_TEST_OPRN_LINE_ID in NUMBER,
138   X_TEST_PROVIDER_CODE in VARCHAR2,
139   X_DELETE_MARK in NUMBER,
140   X_TEXT_CODE in NUMBER,
141   X_ATTRIBUTE_CATEGORY in VARCHAR2,
142   X_ATTRIBUTE1 in VARCHAR2,
143   X_ATTRIBUTE2 in VARCHAR2,
144   X_ATTRIBUTE3 in VARCHAR2,
145   X_ATTRIBUTE4 in VARCHAR2,
146   X_ATTRIBUTE5 in VARCHAR2,
147   X_ATTRIBUTE6 in VARCHAR2,
148   X_ATTRIBUTE7 in VARCHAR2,
149   X_ATTRIBUTE8 in VARCHAR2,
150   X_ATTRIBUTE9 in VARCHAR2,
151   X_ATTRIBUTE10 in VARCHAR2,
152   X_ATTRIBUTE11 in VARCHAR2,
153   X_ATTRIBUTE12 in VARCHAR2,
154   X_ATTRIBUTE13 in VARCHAR2,
155   X_ATTRIBUTE14 in VARCHAR2,
156   X_ATTRIBUTE15 in VARCHAR2,
157   X_ATTRIBUTE16 in VARCHAR2,
158   X_ATTRIBUTE17 in VARCHAR2,
159   X_ATTRIBUTE18 in VARCHAR2,
160   X_ATTRIBUTE19 in VARCHAR2,
161   X_ATTRIBUTE20 in VARCHAR2,
162   X_ATTRIBUTE21 in VARCHAR2,
163   X_ATTRIBUTE22 in VARCHAR2,
164   X_ATTRIBUTE23 in VARCHAR2,
165   X_ATTRIBUTE24 in VARCHAR2,
166   X_ATTRIBUTE25 in VARCHAR2,
167   X_ATTRIBUTE26 in VARCHAR2,
168   X_ATTRIBUTE27 in VARCHAR2,
169   X_ATTRIBUTE28 in VARCHAR2,
170   X_ATTRIBUTE29 in VARCHAR2,
171   X_ATTRIBUTE30 in VARCHAR2,
172   X_TEST_CODE in VARCHAR2,
173   X_TEST_METHOD_ID in NUMBER,
174   X_TEST_CLASS in VARCHAR2,
175   X_TEST_TYPE in VARCHAR2,
176   X_TEST_UNIT in VARCHAR2,
177   X_MIN_VALUE_NUM in NUMBER,
178   X_MAX_VALUE_NUM in NUMBER,
179   X_EXP_ERROR_TYPE in VARCHAR2,
180   X_BELOW_SPEC_MIN in NUMBER,
181   X_ABOVE_SPEC_MIN in NUMBER,
182   X_BELOW_SPEC_MAX in NUMBER,
183   X_ABOVE_SPEC_MAX in NUMBER,
184   X_BELOW_MIN_ACTION_CODE in VARCHAR2,
185   X_ABOVE_MIN_ACTION_CODE in VARCHAR2,
186   X_BELOW_MAX_ACTION_CODE in VARCHAR2,
187   X_ABOVE_MAX_ACTION_CODE in VARCHAR2,
188   X_EXPRESSION in VARCHAR2,
189   X_DISPLAY_PRECISION in NUMBER,
190   X_REPORT_PRECISION in NUMBER,
191   X_PRIORITY in VARCHAR2,
192   X_TEST_OPRN_ID in NUMBER,
193   X_TEST_DESC in VARCHAR2,
194   X_LAST_UPDATE_DATE in DATE,
195   X_LAST_UPDATED_BY in NUMBER,
196   X_LAST_UPDATE_LOGIN in NUMBER,
197   X_TEST_GROUP_ORDER IN NUMBER DEFAULT NULL
198 );
199 
200 PROCEDURE ADD_LANGUAGE;
201 
202 FUNCTION fetch_row (
203   p_gmd_qc_tests IN  gmd_qc_tests%ROWTYPE ,
204   x_gmd_qc_tests OUT NOCOPY gmd_qc_tests%ROWTYPE
205 ) RETURN BOOLEAN ;
206 
207 FUNCTION lock_row (
208   p_test_id   IN  NUMBER   DEFAULT NULL,
209   p_test_code IN  VARCHAR2 DEFAULT NULL
210 ) RETURN BOOLEAN ;
211 
212 FUNCTION mark_for_delete (
213   p_test_id   		IN  NUMBER   DEFAULT NULL,
214   p_test_code 		IN  VARCHAR2 DEFAULT NULL,
215   p_last_update_date 	IN  DATE     DEFAULT NULL,
216   p_last_updated_by 	IN  NUMBER   DEFAULT NULL,
217   p_last_update_login 	IN  NUMBER   DEFAULT NULL
218 ) RETURN BOOLEAN ;
219 
220 END gmd_qc_tests_pvt;