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;