1 package GMD_OPTIMIZE_FETCH_PKG AUTHID CURRENT_USER as
2 /* $Header: GMDOPTMS.pls 120.1 2005/07/13 07:27:51 rajreddy noship $ */
3
4 PROCEDURE load_optimizer_details (V_entity_id IN NUMBER,V_maintain_type IN NUMBER,
5 X_return_status OUT NOCOPY VARCHAR2);
6
7 PROCEDURE calculate (V_entity_id IN NUMBER,V_orgn_id IN NUMBER,X_return_status OUT NOCOPY VARCHAR2) ;
8
9 PROCEDURE rollup_wt_pct (V_entity_id IN NUMBER,V_parm_name IN VARCHAR2,
10 V_parm_id IN NUMBER,X_return_status OUT NOCOPY VARCHAR2);
11
12 PROCEDURE rollup_vol_pct (V_entity_id IN NUMBER,V_parm_name IN VARCHAR2,
13 V_parm_id IN NUMBER,X_return_status OUT NOCOPY VARCHAR2);
14
15 PROCEDURE rollup_update (V_entity_id IN NUMBER,V_parm_name IN VARCHAR2,V_parm_id IN NUMBER,
16 X_return_status OUT NOCOPY VARCHAR2);
17
18 FUNCTION rollup_cost_units (V_entity_id IN NUMBER,V_parm_name IN VARCHAR2,
19 V_parm_id IN NUMBER,X_return_status OUT NOCOPY VARCHAR2) RETURN NUMBER;
20
21 PROCEDURE rollup_equiv_wt (V_entity_id IN NUMBER,V_parm_name IN VARCHAR2,
22 V_parm_id IN NUMBER,V_unit_code IN VARCHAR2,V_orgn_id IN NUMBER,
23 X_return_status OUT NOCOPY VARCHAR2);
24
25 FUNCTION is_lot_selected(V_parentline_id IN NUMBER) RETURN VARCHAR2;
26
27 FUNCTION consider_line(V_line_id IN NUMBER) RETURN VARCHAR2;
28
29 FUNCTION get_density_value (V_line_id IN NUMBER,V_density_parameter IN VARCHAR2) RETURN NUMBER;
30
31 PROCEDURE update_line_mass_vol_qty (V_orgn_id IN NUMBER,V_line_id IN NUMBER,
32 V_density_parameter IN VARCHAR2,V_mass_uom IN VARCHAR2,
33 V_vol_uom IN VARCHAR2,X_return_status OUT NOCOPY VARCHAR2);
34
35 PROCEDURE update_mass_vol_qty (V_orgn_id IN NUMBER,V_entity_id IN NUMBER,
36 V_density_parameter IN VARCHAR2,V_mass_uom IN VARCHAR2,
37 V_vol_uom IN VARCHAR2,X_return_status OUT NOCOPY VARCHAR2);
38
39 END GMD_OPTIMIZE_FETCH_PKG;