1 package GMD_LCF_FETCH_PKG as
2 /* $Header: GMDLCFMS.pls 120.5 2005/11/22 11:42 rajreddy noship $ */
3 G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMD_LCF_FETCH_PKG';
4
5 PROCEDURE calculate (V_formulation_spec_id IN NUMBER, V_line_id IN NUMBER, X_return_status OUT NOCOPY VARCHAR2) ;
6
7 PROCEDURE rollup_wt_pct (V_parm_name IN VARCHAR2,V_line_id IN NUMBER,
8 V_parm_id IN NUMBER,X_return_status OUT NOCOPY VARCHAR2);
9
10 PROCEDURE rollup_vol_pct (V_parm_name IN VARCHAR2,V_line_id IN NUMBER,
11 V_parm_id IN NUMBER,X_return_status OUT NOCOPY VARCHAR2);
12
13 FUNCTION get_density_value (V_line_id IN NUMBER,V_density_parameter IN VARCHAR2) RETURN NUMBER;
14
15 PROCEDURE update_line_mass_vol_qty (V_orgn_id IN NUMBER,V_line_id IN NUMBER,
16 V_density_parameter IN VARCHAR2,V_mass_uom IN VARCHAR2,
17 V_vol_uom IN VARCHAR2,X_return_status OUT NOCOPY VARCHAR2);
18
19 PROCEDURE update_mass_vol_qty (V_orgn_id IN NUMBER,V_entity_id IN NUMBER,
20 V_density_parameter IN VARCHAR2,V_mass_uom IN VARCHAR2,
21 V_vol_uom IN VARCHAR2,X_return_status OUT NOCOPY VARCHAR2);
22
23 PROCEDURE load_cost_values (V_orgn_id IN NUMBER, V_inv_item_id IN NUMBER, V_cost_type IN VARCHAR2,
24 V_date IN DATE, V_cost_orgn IN VARCHAR2, V_source IN NUMBER, X_value OUT NOCOPY NUMBER);
25
26 PROCEDURE load_tech_values (V_orgn_id IN NUMBER, V_formulation_spec_id IN NUMBER, V_date IN DATE);
27
28 PROCEDURE load_items (V_formulation_spec_id IN NUMBER, V_organization_id IN NUMBER,V_ingred_pick_base IN VARCHAR2,
29 V_formula_no IN VARCHAR2, V_batch_no IN VARCHAR2, V_date IN DATE);
30
31 PROCEDURE load_categories (V_formulation_spec_id IN NUMBER);
32
33 PROCEDURE get_category_value (V_inventory_item_id IN NUMBER, V_organization_id IN NUMBER,
34 V_line_id IN NUMBER);
35
36 PROCEDURE load_quality_data (V_line_id IN NUMBER, V_orgn_id IN NUMBER,
37 V_qcassy_typ_id IN NUMBER, V_tech_parm_id IN NUMBER);
38
39 PROCEDURE generate_lcf_data (V_formulation_spec_id IN NUMBER, V_organization_id IN NUMBER,
40 V_formula_no IN VARCHAR2, V_batch_no IN VARCHAR2, V_date IN DATE,
41 X_return_code OUT NOCOPY NUMBER);
42
43 --debug procedures.
44 PROCEDURE temp_dump;
45 PROCEDURE temp_param;
46 PROCEDURE temp_category;
47
48
49 END GMD_LCF_FETCH_PKG;