DBA Data[Home] [Help]

PACKAGE: APPS.GMD_SCALE

Source


1 PACKAGE gmd_scale AUTHID CURRENT_USER AS
2 /* $Header: GMDSCALS.pls 115.1 2002/10/25 20:00:52 santunes noship $ */
3 
4   TYPE fm_matl_dtl_tab IS TABLE OF fm_matl_dtl%ROWTYPE INDEX BY BINARY_INTEGER;
5   TYPE scale_rec IS RECORD
6   (  line_no	NUMBER
7   ,  line_type  NUMBER
8   ,  item_id    NUMBER
9   ,  qty        NUMBER
10   ,  item_um    VARCHAR2(4)
11   ,  scale_type NUMBER
12   );
13   TYPE scale_tab IS TABLE OF scale_rec;
14 
15   PROCEDURE scale
16   (  p_scale_tab    IN scale_tab
17   ,  p_scale_factor IN NUMBER
18   ,  p_primaries          IN VARCHAR2
19   ,  x_scale_tab    OUT NOCOPY scale_tab
20   ,  x_return_status      OUT NOCOPY VARCHAR2
21   );
22 
23   PROCEDURE scale
24   (  p_fm_matl_dtl_tab    IN fm_matl_dtl_tab
25   ,  p_scale_factor       IN NUMBER
26   ,  p_primaries          IN VARCHAR2
27   ,  x_fm_matl_dtl_tab    OUT NOCOPY fm_matl_dtl_tab
28   ,  x_return_status      OUT NOCOPY VARCHAR2
29   );
30 END gmd_scale;