1 PACKAGE GMD_RECIPE_DATA_PUB AUTHID CURRENT_USER AS
2 /* $Header: GMDPRDTS.pls 120.1 2005/07/21 02:48:40 kkillams noship $ */
3
4 -- Start of commments
5 -- API name : get_recipe_data
6 -- Type :
7 -- Function :
8 -- Paramaters :
9 -- IN : p_api_version IN NUMBER Required
10 -- p_init_msg_list IN Varchar2 Optional
11 -- p_recipe_id IN NUMBER
12 -- x_return_status OUT varchar2(1)
13 -- x_msg_count OUT Number
14 -- x_msg_data OUT varchar2(2000)
15 -- x_recipe_validity_tbl OUT recipe_validity_tbl
16 -- x_recipe_rout_matl_tbl OUT recipe_rout_matl_tbl
17 -- x_recipe_step_out OUT recipe_step_tbl
18 -- x_routing_depd_tbl OUT routing_depd_tbl
19 -- x_oprn_act_out OUT oprn_act_tbl
20 -- X_oprn_resc_rec OUT oprn_resc_tbl
21
22 -- Version : Current Version 1.0
23 --
24 -- Notes :
25 --
26 -- End of comments
27
28 PROCEDURE get_recipe_data
29 ( p_api_version IN NUMBER ,
30 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
31 p_recipe_id IN NUMBER ,
32 p_organization_id IN NUMBER DEFAULT NULL ,
33 p_date IN DATE DEFAULT NULL , --Bug 4479101
34 x_return_status OUT NOCOPY VARCHAR2 ,
35 x_msg_count OUT NOCOPY NUMBER ,
36 x_msg_data OUT NOCOPY VARCHAR2 ,
37 x_return_code OUT NOCOPY NUMBER ,
38 x_recipe_rout_tbl OUT NOCOPY gmd_recipe_fetch_pub.recipe_rout_tbl ,
39 x_recipe_rout_matl_tbl OUT NOCOPY gmd_recipe_fetch_pub.recipe_rout_matl_tbl ,
40 x_recipe_step_out OUT NOCOPY gmd_recipe_fetch_pub.recipe_step_tbl ,
41 x_routing_depd_tbl OUT NOCOPY gmd_recipe_fetch_pub.routing_depd_tbl ,
42 x_oprn_act_out OUT NOCOPY gmd_recipe_fetch_pub.oprn_act_tbl ,
43 x_oprn_resc_rec OUT NOCOPY gmd_recipe_fetch_pub.oprn_resc_tbl ,
44 x_formula_header_rec OUT NOCOPY fm_form_mst%ROWTYPE ,
45 x_formula_dtl_tbl OUT NOCOPY gmdfmval_pub.formula_detail_tbl ,
46 x_recp_resc_proc_param_tbl OUT NOCOPY gmd_recipe_fetch_pub.recp_resc_proc_param_tbl
47 );
48
49 END GMD_RECIPE_DATA_PUB;