1 PACKAGE GMD_VAL_DATA_PUB AS
2 /* $Header: GMDPVRDS.pls 120.1 2005/07/25 10:07:27 srsriran noship $ */
3
4
5
6
7 PROCEDURE get_val_data
8 ( p_api_version IN NUMBER ,
9 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
10 p_object_type IN VARCHAR2 ,
11 p_recipe_no IN VARCHAR2 := NULL ,
12 p_recipe_version IN NUMBER := NULL ,
13 p_recipe_id IN NUMBER := NULL ,
14 p_total_input IN NUMBER := NULL ,
15 p_total_output IN NUMBER := NULL ,
16 p_formula_id IN NUMBER := NULL ,
17 p_item_id IN NUMBER := NULL ,
18 p_revision IN VARCHAR2 := NULL ,
19 p_item_no IN VARCHAR2 := NULL ,
20 p_product_qty IN NUMBER := NULL ,
21 p_uom IN VARCHAR2 := NULL ,
22 p_recipe_use IN VARCHAR2 := NULL ,
23 p_orgn_code IN VARCHAR2 := NULL ,
24 p_organization_id IN NUMBER := NULL ,
25 p_least_cost_validity IN VARCHAR2 := 'F' ,
26 p_start_date IN DATE := NULL ,
27 p_end_date IN DATE := NULL ,
28 p_status_type IN VARCHAR2 := NULL ,
29 p_validity_rule_id IN NUMBER := NULL ,
30 x_return_status OUT NOCOPY VARCHAR2 ,
31 x_msg_count OUT NOCOPY NUMBER ,
32 x_msg_data OUT NOCOPY VARCHAR2 ,
33 x_return_code OUT NOCOPY NUMBER ,
34 X_recipe_validity_out OUT NOCOPY GMD_VALIDITY_RULES.recipe_validity_tbl);
35
36 END GMD_VAL_DATA_PUB;