1 PACKAGE gmd_common_scale AUTHID CURRENT_USER AS
2 /* $Header: GMDVSCLS.pls 120.0 2005/05/25 19:47:24 appldev noship $ */
3
4 TYPE gme_material_details_tab IS TABLE OF gme_material_details%ROWTYPE index by binary_integer;
5
6
7 TYPE fm_matl_dtl_tab IS TABLE OF fm_matl_dtl%ROWTYPE index by binary_integer;
8 /*
9 TYPE lm_form_dtl_tab IS TABLE OF lm_form_dtl%ROWTYPE index by binary_integer;
10 */
11
12 -- NPD Convergence
13 -- G_profile_fm_yield_type VARCHAR2(80) DEFAULT FND_PROFILE.VALUE('FM_YIELD_TYPE') ;
14
15 /***************************************************************************
16 * V.Anitha 5-Mar-2004 BUG#3018432
17 * Modified the scale_multiple datatype to NUMBER
18 * from PLS_INTEGER to store decimal values also.
19 **************************************************************************/
20
21 TYPE scale_rec IS RECORD
22 ( line_no NUMBER
23 , line_type NUMBER
24 , inventory_item_id NUMBER -- NPD Convergence
25 , qty NUMBER
26 , detail_uom VARCHAR2(25) -- NPD Convergence
27 , scale_type NUMBER
28 , contribute_yield_ind VARCHAR2(1)
29 , scale_multiple NUMBER
30 , scale_rounding_variance NUMBER
31 , rounding_direction NUMBER
32 );
33 TYPE scale_tab IS TABLE OF scale_rec index by binary_integer ;
34
35 PROCEDURE scale
36 ( p_scale_tab IN scale_tab
37 , p_orgn_id IN NUMBER -- Added for NPD Conv.
38 , p_scale_factor IN NUMBER
39 , p_primaries IN VARCHAR2
40 , x_scale_tab OUT NOCOPY scale_tab
41 , x_return_status OUT NOCOPY VARCHAR2
42 );
43
44
45 PROCEDURE integer_multiple_scale
46 ( p_scale_rec IN scale_rec
47 , x_scale_rec OUT NOCOPY scale_rec
48 , x_return_status OUT NOCOPY VARCHAR2
49 );
50
51 /***************************************************************************
52 * V.Anitha 5-Mar-2004 BUG#3018432
53 * Modified the p_scale_multiple datatype to NUMBER
54 * from PLS_INTEGER to store decimal values also.
55 **************************************************************************/
56
57 PROCEDURE floor_down
58 ( p_a IN NUMBER
59 , p_scale_multiple IN NUMBER
60 , x_floor_qty OUT NOCOPY NUMBER
61 , x_return_status OUT NOCOPY VARCHAR2
62 );
63
64 /***************************************************************************
65 * V.Anitha 5-Mar-2004 BUG#3018432
66 * Modified the p_scale_multiple datatype to NUMBER
67 * from PLS_INTEGER to store decimal values also.
68 **************************************************************************/
69
70 PROCEDURE ceil_up
71 ( p_a IN NUMBER
72 , p_scale_multiple IN NUMBER
73 , x_ceil_qty OUT NOCOPY NUMBER
74 , x_return_status OUT NOCOPY VARCHAR2
75 );
76
77 PROCEDURE scale
78 ( p_fm_matl_dtl_tab IN fm_matl_dtl_tab
79 , p_orgn_id IN NUMBER -- Added for NPD Conv.
80 , p_scale_factor IN NUMBER
81 , p_primaries IN VARCHAR2
82 , x_fm_matl_dtl_tab OUT NOCOPY fm_matl_dtl_tab
83 , x_return_status OUT NOCOPY VARCHAR2
84 );
85
86 /*
87 --************************************************************
88 PROCEDURE scale
89 ( p_lm_form_dtl_tab IN lm_form_dtl_tab
90 , p_scale_factor IN NUMBER
91 , p_primaries IN VARCHAR2
92 , x_lm_form_dtl_tab OUT NOCOPY lm_form_dtl_tab
93 , x_return_status OUT NOCOPY VARCHAR2
94 );
95 --************************************************************
96 */
97
98 PROCEDURE theoretical_yield
99 ( p_scale_tab IN scale_tab
100 , p_orgn_id IN NUMBER -- Added for NPD Conv.
101 , p_scale_factor IN NUMBER
102 , x_scale_tab OUT NOCOPY scale_tab
103 , x_return_status OUT NOCOPY VARCHAR2
104 );
105
106
107
108 END gmd_common_scale;