DBA Data[Home] [Help]

APPS.QA_SS_LOV dependencies on QA_SS_CONST

Line 220: function Q_Comp_Revision ( Elmt_tab qa_ss_const.var150_table,

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;

Line 226: function Q_Comp_Subinventory ( Elmt_tab qa_ss_const.var150_table,

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;

Line 232: function Q_Comp_UOM ( Elmt_tab qa_ss_const.var150_table,

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;

Line 238: function Q_Customers ( Elmt_tab qa_ss_const.var150_table,

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;

Line 244: function Q_Department ( Elmt_tab qa_ss_const.var150_table,

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;

Line 250: function Q_From_Op_Seq_Num ( Elmt_tab qa_ss_const.var150_table,

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;

Line 256: function Q_Line ( Elmt_tab qa_ss_const.var150_table,

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;

Line 262: function Q_Lot_Number ( Elmt_tab qa_ss_const.var150_table,

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;

Line 268: function Q_Po_Headers ( Elmt_tab qa_ss_const.var150_table,

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;

Line 274: function Q_Po_Lines ( Elmt_tab qa_ss_const.var150_table,

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;

Line 280: function Q_Po_Release_Nums ( Elmt_tab qa_ss_const.var150_table,

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;

Line 286: function Q_Po_Shipments ( Elmt_tab qa_ss_const.var150_table,

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;

Line 292: function Q_Project ( Elmt_tab qa_ss_const.var150_table,

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;

Line 298: function Q_Receipt_Nums ( Elmt_tab qa_ss_const.var150_table,

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;

Line 304: function Q_Resource ( Elmt_tab qa_ss_const.var150_table,

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;

Line 310: function Q_Revision ( Elmt_tab qa_ss_const.var150_table,

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;

Line 316: function Q_Rma_Number ( Elmt_tab qa_ss_const.var150_table,

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;

Line 322: function Q_Serial_Number ( Elmt_tab qa_ss_const.var150_table,

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;

Line 328: function Q_Sales_Orders ( Elmt_tab qa_ss_const.var150_table,

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;

Line 334: function Q_Subinventory ( Elmt_tab qa_ss_const.var150_table,

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;

Line 340: function Q_To_Op_Seq_Num ( Elmt_tab qa_ss_const.var150_table,

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;

Line 346: function Q_UOM ( Elmt_tab qa_ss_const.var150_table,

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;

Line 352: function Q_Vendors ( Elmt_tab qa_ss_const.var150_table,

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;

Line 358: function Q_Job ( Elmt_tab qa_ss_const.var150_table,

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;

Line 364: function Q_Task ( Elmt_tab qa_ss_const.var150_table,

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;

Line 370: function Q_Item ( Elmt_tab qa_ss_const.var150_table,

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;

Line 392: GV_Elmt_tab qa_ss_const.var150_table;

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: