1 package GMD_SPREAD_FETCH_PKG AUTHID CURRENT_USER as
2 /* $Header: GMDSPDFS.pls 120.6.12020000.2 2012/07/17 10:22:39 mtou ship $ */
3
4
5 PROCEDURE load_details (V_entity_id IN NUMBER,V_sprd_id IN NUMBER,
6 V_batch_id IN NUMBER,V_formula_id IN NUMBER, V_spec_id IN NUMBER DEFAULT NULL,
7 V_orgn_id IN NUMBER,V_update_inv_ind IN VARCHAR2,
8 V_plant_id IN NUMBER);
9
10 PROCEDURE load_spread_details (V_entity_id IN NUMBER,V_sprd_id IN NUMBER,V_orgn_id IN NUMBER);
11
12 PROCEDURE load_batch_details (V_entity_id IN NUMBER,V_batch_id IN NUMBER,V_orgn_id IN NUMBER,
13 V_update_inv_ind IN VARCHAR2,V_plant_id IN NUMBER);
14
15 PROCEDURE load_formula_details (V_entity_id IN NUMBER,V_formula_id IN NUMBER,V_orgn_id IN NUMBER,
16 V_plant_id IN NUMBER);
17
18 -- NPD Conv. Changed parameter V_orgn_code to V_orgn_id.
19 PROCEDURE load_tech_params (V_entity_id IN NUMBER,V_sprd_id IN NUMBER,V_batch_id IN NUMBER,
20 V_orgn_id IN NUMBER,V_folder_name IN VARCHAR2,
21 V_inv_item_id IN NUMBER DEFAULT NULL,V_formula_id IN NUMBER DEFAULT NULL);
22
23 PROCEDURE add_new_line (V_entity_id IN NUMBER, V_inv_item_id IN NUMBER, V_line_type IN NUMBER,
24 V_line_no IN NUMBER, V_source_ind IN NUMBER,
25 V_formula_id IN NUMBER, V_move_order_header_id IN NUMBER,
26 V_orgn_id IN NUMBER,X_line_id OUT NOCOPY NUMBER,
27 X_parent_line_id OUT NOCOPY NUMBER,
28 X_move_order_line_id OUT NOCOPY NUMBER,V_plant_id IN NUMBER);
29
30 PROCEDURE load_spread_values (V_entity_id IN NUMBER,V_sprd_id IN NUMBER,V_orgn_id IN NUMBER,
31 V_parent_line_id IN NUMBER);
32
33 PROCEDURE load_batch_values (V_entity_id IN NUMBER,V_batch_id IN NUMBER,V_orgn_id IN NUMBER,
34 V_matl_detl_id IN NUMBER,V_line_id IN NUMBER DEFAULT NULL,
35 V_plant_id IN NUMBER);
36
37 PROCEDURE load_formula_values (V_entity_id IN NUMBER,V_formula_id IN NUMBER,V_orgn_id IN NUMBER,
38 V_formulaline_id IN NUMBER,V_line_id IN NUMBER DEFAULT NULL,
39 V_plant_id IN NUMBER);
40
41 PROCEDURE save_spreadsheet (V_entity_id IN NUMBER,V_sprd_id IN NUMBER,
42 V_formula_id IN NUMBER,V_batch_id IN NUMBER,
43 V_orgn_id IN NUMBER,V_spread_name IN VARCHAR2,V_maintain_type NUMBER DEFAULT NULL,
44 V_text_code IN NUMBER,V_last_update_date IN DATE,V_move_order_header_id IN NUMBER);
45
46 FUNCTION get_density_value (V_line_id IN NUMBER,V_density_parameter IN VARCHAR2) RETURN NUMBER;
47
48 PROCEDURE update_line_mass_vol_qty (V_orgn_id IN NUMBER,V_line_id IN NUMBER,V_density_parameter IN VARCHAR2,
49 V_mass_uom IN VARCHAR2,V_vol_uom IN VARCHAR2,X_return_status OUT NOCOPY VARCHAR2);
50
51 PROCEDURE update_mass_vol_qty (V_orgn_id IN NUMBER, V_entity_id IN NUMBER,V_density_parameter IN VARCHAR2,
52 V_mass_uom IN VARCHAR2,V_vol_uom IN VARCHAR2,X_return_status OUT NOCOPY VARCHAR2);
53
54 PROCEDURE load_quality_data (V_line_id IN NUMBER, V_orgn_id IN NUMBER,V_plant_id IN NUMBER);
55
56 -- Sriram.S CAF Enhancement Bug# 3891067
57 PROCEDURE get_lot_density (P_orgn_id IN NUMBER, P_parent_detl_id NUMBER, P_entity_id NUMBER);
58
59 PROCEDURE load_lcf_details (V_entity_id IN NUMBER, V_orgn_id IN NUMBER,V_plant_id IN NUMBER);
60
61 PROCEDURE load_lcf_values (V_entity_id IN NUMBER,V_orgn_id IN NUMBER,
62 V_formulaline_id IN NUMBER,V_plant_id IN NUMBER,
63 V_line_id IN NUMBER DEFAULT NULL);
64
65 PROCEDURE load_derived_cost (V_entity_id IN NUMBER,V_orgn_id IN NUMBER,V_line_id IN NUMBER);
66
67 PROCEDURE update_formula_details (V_entity_id IN NUMBER, V_line_id IN NUMBER, V_formula_id IN NUMBER,V_line_type IN NUMBER, V_line_no IN NUMBER,
68 V_orgn_id IN number,V_plant_id IN number);
69
70 PROCEDURE Update_Formula_Values (V_entity_id IN NUMBER,V_formula_id IN NUMBER,
71 V_orgn_id IN number,V_formulaline_id IN NUMBER,
72 V_line_id IN NUMBER,V_item_id IN NUMBER,V_plant_id IN number);
73
74 end GMD_SPREAD_FETCH_PKG;