1 package GMD_SPREAD_CALCULATE_PKG AUTHID CURRENT_USER as
2 /* $Header: GMDSPDCS.pls 120.2.12010000.1 2008/07/24 09:59:54 appldev ship $ */
3
4 PROCEDURE calculate (V_entity_id IN NUMBER,V_orgn_id IN NUMBER,X_return_status OUT NOCOPY VARCHAR2) ;
5
6 PROCEDURE rollup_wt_pct (V_entity_id IN NUMBER,V_line_id IN NUMBER,V_parm_name IN VARCHAR2,
7 V_parm_id IN NUMBER,V_sort_seq IN NUMBER,X_return_status OUT NOCOPY VARCHAR2);
8
9 PROCEDURE evaluate_expression (V_entity_id IN NUMBER,V_line_id IN NUMBER,V_parm_name IN VARCHAR2,V_parm_id IN NUMBER,
10 V_sort_seq IN NUMBER,X_expression OUT NOCOPY VARCHAR2,X_return_status OUT NOCOPY VARCHAR2);
11
15 PROCEDURE rollup_cost_update(V_entity_id IN NUMBER,V_line_id IN NUMBER,V_parm_name IN VARCHAR2,V_parm_id IN NUMBER,
12 PROCEDURE rollup_vol_pct (V_entity_id IN NUMBER,V_orgn_id IN NUMBER, V_line_id IN NUMBER,V_parm_name IN VARCHAR2,V_parm_id IN NUMBER,
13 V_sort_seq IN NUMBER,X_return_status OUT NOCOPY VARCHAR2);
14
16 V_primary_qty IN VARCHAR2,V_sort_seq IN NUMBER,X_return_status OUT NOCOPY VARCHAR2);
17
18 PROCEDURE rollup_update(V_entity_id IN NUMBER,V_line_id IN NUMBER,V_parm_name IN VARCHAR2,V_parm_id IN NUMBER,
19 V_sort_seq IN NUMBER,X_return_status OUT NOCOPY VARCHAR2);
20
21 FUNCTION rollup_cost_units (V_entity_id IN NUMBER,V_line_id IN NUMBER,V_parm_name IN VARCHAR2,V_parm_id IN NUMBER,
22 X_return_status OUT NOCOPY VARCHAR2) RETURN NUMBER;
23
24 PROCEDURE rollup_equiv_wt (V_entity_id IN NUMBER,V_line_id IN NUMBER,V_parm_name IN VARCHAR2,V_parm_id IN NUMBER,
25 V_unit_code IN VARCHAR2,V_orgn_id IN NUMBER,V_sort_seq IN NUMBER,
26 X_return_status OUT NOCOPY VARCHAR2);
27
28 procedure temp_dump (V_entity_id IN NUMBER);
29 procedure temp_param (V_entity_id IN NUMBER,V_line_id IN NUMBER default null);
30
31 procedure auto_calc_product(V_entity_id IN NUMBER,
32 x_return_status OUT NOCOPY VARCHAR2,
33 x_msg_count OUT NOCOPY NUMBER,
34 x_msg_data OUT NOCOPY VARCHAR2 );
35
36 end GMD_SPREAD_CALCULATE_PKG;