[Home] [Help]
PACKAGE: APPS.GMD_FORMULA_ANALYSIS
Source
1 PACKAGE gmd_formula_analysis AS
2 /* $Header: GMDFANLS.pls 120.0 2005/05/26 00:54:54 appldev noship $ */
3
4 TYPE form_anlys_tab IS TABLE OF gmd_formula_analysis_dtl%ROWTYPE INDEX BY BINARY_INTEGER;
5 P_dtl_tab form_anlys_tab;
6
7 TYPE ing_rec IS RECORD (item_id NUMBER,
8 line_no NUMBER,
9 item_no VARCHAR2(32),
10 qty NUMBER,
11 item_um VARCHAR2(4),
12 iaformula_id NUMBER,
13 tpformula_id NUMBER,
14 formula_id NUMBER,
15 exp_ind NUMBER,
16 mass_qty NUMBER,
17 vol_qty NUMBER,
18 technical_class VARCHAR2(240),
19 technical_sub_class VARCHAR2(240));
20
21 TYPE ing_tab IS TABLE OF ing_rec INDEX BY BINARY_INTEGER;
22 TYPE formula_rec IS RECORD (formula_id NUMBER);
23 TYPE formula_tab IS TABLE OF formula_rec INDEX BY BINARY_INTEGER;
24 P_ingred_tab ing_tab;
25 P_form_tab formula_tab;
26 P_density VARCHAR2(40);
27 P_vol_um mtl_units_of_measure.unit_of_measure%TYPE;
28 P_vol_um_type mtl_units_of_measure.unit_of_measure%TYPE;
29 P_mass_um mtl_units_of_measure.unit_of_measure%TYPE;
30 P_mass_um_type mtl_units_of_measure.unit_of_measure%TYPE;
31 P_space VARCHAR2(100);
32 P_error VARCHAR2(100);
33 P_warning VARCHAR2(100);
34 P_vrules_tab gmd_fetch_validity_rules.recipe_validity_tbl;
35
36 PROCEDURE analyze_formula(err_buf OUT NOCOPY VARCHAR2,
37 ret_code OUT NOCOPY VARCHAR2,
38 p_organization_id IN NUMBER,
39 p_laboratory_id IN NUMBER,
40 p_formula_no IN VARCHAR2,
41 p_formula_vers IN NUMBER,
42 p_formula_id IN NUMBER,
43 p_analysis_qty IN NUMBER,
44 p_rep_um IN VARCHAR2,
45 p_explosion_rule IN NUMBER,
46 x_return_status OUT NOCOPY VARCHAR2,
47 x_msg_count OUT NOCOPY NUMBER,
48 x_msg_data OUT NOCOPY VARCHAR2);
49 PROCEDURE calc_percent(p_orgn_id IN NUMBER, x_return_status OUT NOCOPY VARCHAR2);
50
51 PROCEDURE check_explosion(p_formula_id NUMBER, p_organization_id NUMBER, p_laboratory_id NUMBER, p_rec IN OUT NOCOPY ing_rec,
52 p_explosion_rule NUMBER, x_return_status OUT NOCOPY VARCHAR2);
53 PROCEDURE get_valid_formula(p_recipe_use NUMBER, p_vr_status VARCHAR2, p_status VARCHAR2, x_formula_id OUT NOCOPY NUMBER,
54 x_formula_no OUT NOCOPY VARCHAR2, x_formula_vers OUT NOCOPY NUMBER, x_found OUT NOCOPY NUMBER);
55 PROCEDURE scale_table(p_formula_id NUMBER, p_orgn_id NUMBER, p_scale_factor NUMBER, p_table IN OUT NOCOPY ing_tab);
56 PROCEDURE try_validity_rules(p_item_id NUMBER, p_organization_id NUMBER,
57 p_qty NUMBER, p_uom VARCHAR2,
58 X_vr_tbl OUT NOCOPY gmd_fetch_validity_rules.recipe_validity_tbl);
59 PROCEDURE load_ingreds(p_formula_id NUMBER, x_ing_tab OUT NOCOPY ing_tab,
60 x_return_status OUT NOCOPY VARCHAR2);
61
62 PROCEDURE calc_mass_vol_qty(p_rec IN OUT NOCOPY ing_rec, p_organization_id NUMBER, p_laboratory_id NUMBER, x_return_status OUT NOCOPY VARCHAR2);
63 PROCEDURE get_formula(p_recipe_id IN NUMBER, x_form_mst_rec OUT NOCOPY fm_form_mst%ROWTYPE);
64 PROCEDURE get_recipe(p_recipe_id IN NUMBER, x_recipe_rec OUT NOCOPY gmd_recipes%ROWTYPE);
65
66 PROCEDURE get_density(p_ing_rec ing_rec, p_organization_id NUMBER, p_laboratory_id NUMBER, p_tech_parm_name VARCHAR2,
67 x_value OUT NOCOPY NUMBER, x_return_status OUT NOCOPY VARCHAR2);
68
69 END gmd_formula_analysis;