1 package qa_ss_lov AUTHID CURRENT_USER as
2 /* $Header: qltsslvb.pls 115.10 2002/11/27 19:33:05 jezheng ship $ */
3
4
5 procedure gen_list (
6 vchar_id IN qa_chars.char_id%TYPE,
7 rnumb IN NUMBER,
8 cnumb IN NUMBER,
9 find1 IN VARCHAR2
10 );
11
12 procedure LOV_Header (
13 vchar_id IN qa_chars.char_id%TYPE,
14 rnumb IN NUMBER,
15 cnumb IN NUMBER,
16 find_str IN VARCHAR2
17 );
18
19 procedure LOV_Values (
20 vchar_id IN qa_chars.char_id%TYPE DEFAULT NULL,
21 rnumb IN NUMBER DEFAULT NULL,
22 cnumb IN NUMBER DEFAULT NULL,
23 start_row IN NUMBER DEFAULT 1,
24 p_end_row IN NUMBER DEFAULT NULL,
25 orgz_id IN NUMBER DEFAULT NULL,
26 plan_id_i IN NUMBER DEFAULT NULL,
27 x_txn_num IN NUMBER DEFAULT NULL,
28 x_wip_entity_type IN NUMBER DEFAULT NULL,
29 x_wip_rep_sch_id IN NUMBER DEFAULT NULL,
30 x_po_header_id IN NUMBER DEFAULT NULL,
31 x_po_release_id IN NUMBER DEFAULT NULL,
32 x_po_line_id IN NUMBER DEFAULT NULL,
33 x_line_location_id IN NUMBER DEFAULT NULL,
34 x_po_distribution_id IN NUMBER DEFAULT NULL,
35 x_item_id IN NUMBER DEFAULT NULL,
36 x_wip_entity_id IN NUMBER DEFAULT NULL,
37 x_wip_line_id IN NUMBER DEFAULT NULL,
38 x_po_shipment_id IN NUMBER DEFAULT NULL,
39 p1 IN VARCHAR2 DEFAULT NULL,
40 p2 IN VARCHAR2 DEFAULT NULL,
41 p3 IN VARCHAR2 DEFAULT NULL,
42 p4 IN VARCHAR2 DEFAULT NULL,
43 p5 IN VARCHAR2 DEFAULT NULL,
44 p6 IN VARCHAR2 DEFAULT NULL,
45 p7 IN VARCHAR2 DEFAULT NULL,
46 p8 IN VARCHAR2 DEFAULT NULL,
47 p9 IN VARCHAR2 DEFAULT NULL,
48 p10 IN VARCHAR2 DEFAULT NULL,
49 p11 IN VARCHAR2 DEFAULT NULL,
50 p12 IN VARCHAR2 DEFAULT NULL,
51 p13 IN VARCHAR2 DEFAULT NULL,
52 p14 IN VARCHAR2 DEFAULT NULL,
53 p15 IN VARCHAR2 DEFAULT NULL,
54 p16 IN VARCHAR2 DEFAULT NULL,
55 p17 IN VARCHAR2 DEFAULT NULL,
56 p18 IN VARCHAR2 DEFAULT NULL,
57 p19 IN VARCHAR2 DEFAULT NULL,
58 p20 IN VARCHAR2 DEFAULT NULL,
59 p21 IN VARCHAR2 DEFAULT NULL,
60 p22 IN VARCHAR2 DEFAULT NULL,
61 p23 IN VARCHAR2 DEFAULT NULL,
62 p24 IN VARCHAR2 DEFAULT NULL,
63 p25 IN VARCHAR2 DEFAULT NULL,
64 p26 IN VARCHAR2 DEFAULT NULL,
65 p27 IN VARCHAR2 DEFAULT NULL,
66 p28 IN VARCHAR2 DEFAULT NULL,
67 p29 IN VARCHAR2 DEFAULT NULL,
68 p30 IN VARCHAR2 DEFAULT NULL,
69 p31 IN VARCHAR2 DEFAULT NULL,
70 p32 IN VARCHAR2 DEFAULT NULL,
71 p33 IN VARCHAR2 DEFAULT NULL,
72 p34 IN VARCHAR2 DEFAULT NULL,
73 p35 IN VARCHAR2 DEFAULT NULL,
74 p36 IN VARCHAR2 DEFAULT NULL,
75 p37 IN VARCHAR2 DEFAULT NULL,
76 p38 IN VARCHAR2 DEFAULT NULL,
77 p39 IN VARCHAR2 DEFAULT NULL,
78 p40 IN VARCHAR2 DEFAULT NULL,
79 p41 IN VARCHAR2 DEFAULT NULL,
80 p42 IN VARCHAR2 DEFAULT NULL,
81 p43 IN VARCHAR2 DEFAULT NULL,
82 p44 IN VARCHAR2 DEFAULT NULL,
83 p45 IN VARCHAR2 DEFAULT NULL,
84 p46 IN VARCHAR2 DEFAULT NULL,
85 p47 IN VARCHAR2 DEFAULT NULL,
86 p48 IN VARCHAR2 DEFAULT NULL,
87 p49 IN VARCHAR2 DEFAULT NULL,
88 p50 IN VARCHAR2 DEFAULT NULL,
89 p51 IN VARCHAR2 DEFAULT NULL,
90 p52 IN VARCHAR2 DEFAULT NULL,
91 p53 IN VARCHAR2 DEFAULT NULL,
92 p54 IN VARCHAR2 DEFAULT NULL,
93 p55 IN VARCHAR2 DEFAULT NULL,
94 p56 IN VARCHAR2 DEFAULT NULL,
95 p57 IN VARCHAR2 DEFAULT NULL,
96 p58 IN VARCHAR2 DEFAULT NULL,
97 p59 IN VARCHAR2 DEFAULT NULL,
98 p60 IN VARCHAR2 DEFAULT NULL,
99 p61 IN VARCHAR2 DEFAULT NULL,
100 p62 IN VARCHAR2 DEFAULT NULL,
101 p63 IN VARCHAR2 DEFAULT NULL,
102 p64 IN VARCHAR2 DEFAULT NULL,
103 p65 IN VARCHAR2 DEFAULT NULL,
104 p66 IN VARCHAR2 DEFAULT NULL,
105 p67 IN VARCHAR2 DEFAULT NULL,
106 p68 IN VARCHAR2 DEFAULT NULL,
107 p69 IN VARCHAR2 DEFAULT NULL,
108 p70 IN VARCHAR2 DEFAULT NULL,
109 p71 IN VARCHAR2 DEFAULT NULL,
110 p72 IN VARCHAR2 DEFAULT NULL,
111 p73 IN VARCHAR2 DEFAULT NULL,
112 p74 IN VARCHAR2 DEFAULT NULL,
113 p75 IN VARCHAR2 DEFAULT NULL,
114 p76 IN VARCHAR2 DEFAULT NULL,
115 p77 IN VARCHAR2 DEFAULT NULL,
116 p78 IN VARCHAR2 DEFAULT NULL,
117 p79 IN VARCHAR2 DEFAULT NULL,
118 p80 IN VARCHAR2 DEFAULT NULL,
119 p81 IN VARCHAR2 DEFAULT NULL,
120 p82 IN VARCHAR2 DEFAULT NULL,
121 p83 IN VARCHAR2 DEFAULT NULL,
122 p84 IN VARCHAR2 DEFAULT NULL,
123 p85 IN VARCHAR2 DEFAULT NULL,
124 p86 IN VARCHAR2 DEFAULT NULL,
125 p87 IN VARCHAR2 DEFAULT NULL,
126 p88 IN VARCHAR2 DEFAULT NULL,
127 p89 IN VARCHAR2 DEFAULT NULL,
128 p90 IN VARCHAR2 DEFAULT NULL,
129 p91 IN VARCHAR2 DEFAULT NULL,
130 p92 IN VARCHAR2 DEFAULT NULL,
131 p93 IN VARCHAR2 DEFAULT NULL,
132 p94 IN VARCHAR2 DEFAULT NULL,
133 p95 IN VARCHAR2 DEFAULT NULL,
134 p96 IN VARCHAR2 DEFAULT NULL,
135 p97 IN VARCHAR2 DEFAULT NULL,
136 p98 IN VARCHAR2 DEFAULT NULL,
137 p99 IN VARCHAR2 DEFAULT NULL,
138 p100 IN VARCHAR2 DEFAULT NULL,
139 p101 IN VARCHAR2 DEFAULT NULL,
140 p102 IN VARCHAR2 DEFAULT NULL,
141 p103 IN VARCHAR2 DEFAULT NULL,
142 p104 IN VARCHAR2 DEFAULT NULL,
143 p105 IN VARCHAR2 DEFAULT NULL,
144 p106 IN VARCHAR2 DEFAULT NULL,
145 p107 IN VARCHAR2 DEFAULT NULL,
146 p108 IN VARCHAR2 DEFAULT NULL,
147 p109 IN VARCHAR2 DEFAULT NULL,
148 p110 IN VARCHAR2 DEFAULT NULL,
149 p111 IN VARCHAR2 DEFAULT NULL,
150 p112 IN VARCHAR2 DEFAULT NULL,
151 p113 IN VARCHAR2 DEFAULT NULL,
152 p114 IN VARCHAR2 DEFAULT NULL,
153 p115 IN VARCHAR2 DEFAULT NULL,
154 p116 IN VARCHAR2 DEFAULT NULL,
155 p117 IN VARCHAR2 DEFAULT NULL,
156 p118 IN VARCHAR2 DEFAULT NULL,
157 p119 IN VARCHAR2 DEFAULT NULL,
158 p120 IN VARCHAR2 DEFAULT NULL,
159 p121 IN VARCHAR2 DEFAULT NULL,
160 p122 IN VARCHAR2 DEFAULT NULL,
161 p123 IN VARCHAR2 DEFAULT NULL,
162 p124 IN VARCHAR2 DEFAULT NULL,
163 p125 IN VARCHAR2 DEFAULT NULL,
164 p126 IN VARCHAR2 DEFAULT NULL,
165 p127 IN VARCHAR2 DEFAULT NULL,
166 p128 IN VARCHAR2 DEFAULT NULL,
167 p129 IN VARCHAR2 DEFAULT NULL,
168 p130 IN VARCHAR2 DEFAULT NULL,
169 p131 IN VARCHAR2 DEFAULT NULL,
170 p132 IN VARCHAR2 DEFAULT NULL,
171 p133 IN VARCHAR2 DEFAULT NULL,
172 p134 IN VARCHAR2 DEFAULT NULL,
173 p135 IN VARCHAR2 DEFAULT NULL,
174 p136 IN VARCHAR2 DEFAULT NULL,
175 p137 IN VARCHAR2 DEFAULT NULL,
176 p138 IN VARCHAR2 DEFAULT NULL,
177 p139 IN VARCHAR2 DEFAULT NULL,
178 p140 IN VARCHAR2 DEFAULT NULL,
179 p141 IN VARCHAR2 DEFAULT NULL,
180 p142 IN VARCHAR2 DEFAULT NULL,
181 p143 IN VARCHAR2 DEFAULT NULL,
182 p144 IN VARCHAR2 DEFAULT NULL,
183 p145 IN VARCHAR2 DEFAULT NULL,
184 p146 IN VARCHAR2 DEFAULT NULL,
185 p147 IN VARCHAR2 DEFAULT NULL,
186 p148 IN VARCHAR2 DEFAULT NULL,
187 p149 IN VARCHAR2 DEFAULT NULL,
188 p150 IN VARCHAR2 DEFAULT NULL,
189 p151 IN VARCHAR2 DEFAULT NULL,
190 p152 IN VARCHAR2 DEFAULT NULL,
191 p153 IN VARCHAR2 DEFAULT NULL,
192 p154 IN VARCHAR2 DEFAULT NULL,
193 p155 IN VARCHAR2 DEFAULT NULL,
194 p156 IN VARCHAR2 DEFAULT NULL,
195 p157 IN VARCHAR2 DEFAULT NULL,
196 p158 IN VARCHAR2 DEFAULT NULL,
197 p159 IN VARCHAR2 DEFAULT NULL,
198 p160 IN VARCHAR2 DEFAULT NULL,
199 i_1 IN VARCHAR2 DEFAULT NULL, -- find_str
200 a_1 IN VARCHAR2 DEFAULT NULL, -- search on
201 c_1 IN VARCHAR2 DEFAULT NULL, -- condition
202 case_sensitive IN VARCHAR2 DEFAULT NULL,
203 Flag IN NUMBER DEFAULT NULL
204 );
205
206 function return_col_num ( x_char_id IN NUMBER, x_plan_id IN NUMBER )
207 RETURN NUMBER;
208
209
210 function value_to_id ( charid IN NUMBER, val IN VARCHAR2, orgz_id IN NUMBER DEFAULT NULL )
211 RETURN NUMBER;
212 -- eg, pass in Project Number as val, will return Project Id
213
214
215 -- commenting out some of the below functions
216 -- becos they are actually private to this pkg
217 -- and need not be in the pkg SPEC file (viz. this .pls file)
218
219 /*
220 function Q_Comp_Revision ( Elmt_tab qa_ss_const.var150_table,
221 plan_id_i IN NUMBER DEFAULT NULL,
222 vcharid IN NUMBER DEFAULT NULL,
223 orgz_id IN NUMBER DEFAULT NULL )
224 Return VARCHAR2;
225
226 function Q_Comp_Subinventory ( Elmt_tab qa_ss_const.var150_table,
227 plan_id_i IN NUMBER DEFAULT NULL,
228 vcharid IN NUMBER DEFAULT NULL,
229 orgz_id IN NUMBER DEFAULT NULL )
230 Return VARCHAR2;
231
232 function Q_Comp_UOM ( Elmt_tab qa_ss_const.var150_table,
233 plan_id_i IN NUMBER DEFAULT NULL,
234 vcharid IN NUMBER DEFAULT NULL,
235 orgz_id IN NUMBER DEFAULT NULL )
236 Return VARCHAR2;
237
238 function Q_Customers ( Elmt_tab qa_ss_const.var150_table,
239 plan_id_i IN NUMBER DEFAULT NULL,
240 vcharid IN NUMBER DEFAULT NULL,
241 orgz_id IN NUMBER DEFAULT NULL )
242 Return VARCHAR2;
243
244 function Q_Department ( Elmt_tab qa_ss_const.var150_table,
245 plan_id_i IN NUMBER DEFAULT NULL,
246 vcharid IN NUMBER DEFAULT NULL,
247 orgz_id IN NUMBER DEFAULT NULL )
248 Return VARCHAR2;
249
250 function Q_From_Op_Seq_Num ( Elmt_tab qa_ss_const.var150_table,
251 plan_id_i IN NUMBER DEFAULT NULL,
252 vcharid IN NUMBER DEFAULT NULL,
253 orgz_id IN NUMBER DEFAULT NULL )
254 Return VARCHAR2;
255
256 function Q_Line ( Elmt_tab qa_ss_const.var150_table,
257 plan_id_i IN NUMBER DEFAULT NULL,
258 vcharid IN NUMBER DEFAULT NULL,
259 orgz_id IN NUMBER DEFAULT NULL )
260 Return VARCHAR2;
261
262 function Q_Lot_Number ( Elmt_tab qa_ss_const.var150_table,
263 plan_id_i IN NUMBER DEFAULT NULL,
264 vcharid IN NUMBER DEFAULT NULL,
265 orgz_id IN NUMBER DEFAULT NULL )
266 Return VARCHAR2;
267
268 function Q_Po_Headers ( Elmt_tab qa_ss_const.var150_table,
269 plan_id_i IN NUMBER DEFAULT NULL,
270 vcharid IN NUMBER DEFAULT NULL,
271 orgz_id IN NUMBER DEFAULT NULL )
272 Return VARCHAR2;
273
274 function Q_Po_Lines ( Elmt_tab qa_ss_const.var150_table,
275 plan_id_i IN NUMBER DEFAULT NULL,
276 vcharid IN NUMBER DEFAULT NULL,
277 orgz_id IN NUMBER DEFAULT NULL )
278 Return VARCHAR2;
279
280 function Q_Po_Release_Nums ( Elmt_tab qa_ss_const.var150_table,
281 plan_id_i IN NUMBER DEFAULT NULL,
282 vcharid IN NUMBER DEFAULT NULL,
283 orgz_id IN NUMBER DEFAULT NULL )
284 Return VARCHAR2;
285
286 function Q_Po_Shipments ( Elmt_tab qa_ss_const.var150_table,
287 plan_id_i IN NUMBER DEFAULT NULL,
288 vcharid IN NUMBER DEFAULT NULL,
289 orgz_id IN NUMBER DEFAULT NULL )
290 Return VARCHAR2;
291
292 function Q_Project ( Elmt_tab qa_ss_const.var150_table,
293 plan_id_i IN NUMBER DEFAULT NULL,
294 vcharid IN NUMBER DEFAULT NULL,
295 orgz_id IN NUMBER DEFAULT NULL )
296 Return VARCHAR2;
297
298 function Q_Receipt_Nums ( Elmt_tab qa_ss_const.var150_table,
299 plan_id_i IN NUMBER DEFAULT NULL,
300 vcharid IN NUMBER DEFAULT NULL,
301 orgz_id IN NUMBER DEFAULT NULL )
302 Return VARCHAR2;
303
304 function Q_Resource ( Elmt_tab qa_ss_const.var150_table,
305 plan_id_i IN NUMBER DEFAULT NULL,
306 vcharid IN NUMBER DEFAULT NULL,
307 orgz_id IN NUMBER DEFAULT NULL )
308 Return VARCHAR2;
309
310 function Q_Revision ( Elmt_tab qa_ss_const.var150_table,
311 plan_id_i IN NUMBER DEFAULT NULL,
312 vcharid IN NUMBER DEFAULT NULL,
313 orgz_id IN NUMBER DEFAULT NULL )
314 Return VARCHAR2;
315
316 function Q_Rma_Number ( Elmt_tab qa_ss_const.var150_table,
317 plan_id_i IN NUMBER DEFAULT NULL,
318 vcharid IN NUMBER DEFAULT NULL,
319 orgz_id IN NUMBER DEFAULT NULL )
320 Return VARCHAR2;
321
322 function Q_Serial_Number ( Elmt_tab qa_ss_const.var150_table,
323 plan_id_i IN NUMBER DEFAULT NULL,
324 vcharid IN NUMBER DEFAULT NULL,
325 orgz_id IN NUMBER DEFAULT NULL )
326 Return VARCHAR2;
327
328 function Q_Sales_Orders ( Elmt_tab qa_ss_const.var150_table,
329 plan_id_i IN NUMBER DEFAULT NULL,
330 vcharid IN NUMBER DEFAULT NULL,
331 orgz_id IN NUMBER DEFAULT NULL )
332 Return VARCHAR2;
333
334 function Q_Subinventory ( Elmt_tab qa_ss_const.var150_table,
335 plan_id_i IN NUMBER DEFAULT NULL,
336 vcharid IN NUMBER DEFAULT NULL,
337 orgz_id IN NUMBER DEFAULT NULL )
338 Return VARCHAR2;
339
340 function Q_To_Op_Seq_Num ( Elmt_tab qa_ss_const.var150_table,
341 plan_id_i IN NUMBER DEFAULT NULL,
342 vcharid IN NUMBER DEFAULT NULL,
343 orgz_id IN NUMBER DEFAULT NULL )
344 Return VARCHAR2;
345
346 function Q_UOM ( Elmt_tab qa_ss_const.var150_table,
347 plan_id_i IN NUMBER DEFAULT NULL,
348 vcharid IN NUMBER DEFAULT NULL,
349 orgz_id IN NUMBER DEFAULT NULL )
350 Return VARCHAR2;
351
352 function Q_Vendors ( Elmt_tab qa_ss_const.var150_table,
353 plan_id_i IN NUMBER DEFAULT NULL,
354 vcharid IN NUMBER DEFAULT NULL,
355 orgz_id IN NUMBER DEFAULT NULL )
356 Return VARCHAR2;
357
358 function Q_Job ( Elmt_tab qa_ss_const.var150_table,
359 plan_id_i IN NUMBER DEFAULT NULL,
360 vcharid IN NUMBER DEFAULT NULL,
361 orgz_id IN NUMBER DEFAULT NULL )
362 Return VARCHAR2;
363
364 function Q_Task ( Elmt_tab qa_ss_const.var150_table,
365 plan_id_i IN NUMBER DEFAULT NULL,
366 vcharid IN NUMBER DEFAULT NULL,
367 orgz_id IN NUMBER DEFAULT NULL )
368 Return VARCHAR2;
369
370 function Q_Item ( Elmt_tab qa_ss_const.var150_table,
371 plan_id_i IN NUMBER DEFAULT NULL,
372 vcharid IN NUMBER DEFAULT NULL,
373 orgz_id IN NUMBER DEFAULT NULL )
374 Return VARCHAR2;
375 */
376
377 -- Define Package Global Variables
378 -- GV stands for Global Variable
379 GV_Wip_Entity_Type NUMBER;
380 GV_Wip_Rep_Sch_Id NUMBER;
381 GV_Po_Header_Id NUMBER;
382 GV_Po_Release_Id NUMBER;
383 GV_Po_Line_Id NUMBER;
384 GV_Line_Location_Id NUMBER;
385 GV_Po_Distribution_Id NUMBER;
386 GV_Organization_Id NUMBER;
387 GV_Item_Id NUMBER;
388 GV_Wip_Entity_Id NUMBER;
389 GV_Wip_Line_Id NUMBER;
390 GV_Po_Shipment_Id NUMBER;
391 GV_Txn_Num NUMBER;
392 GV_Elmt_tab qa_ss_const.var150_table;
393
394 end qa_ss_lov;
395