1 package gmd_ebi_recipe_pub AUTHID CURRENT_USER AS
2 /* $Header: GMDEIPRS.pls 120.1.12020000.2 2012/07/26 09:48:09 rborpatl noship $ */
3 /*
4 *This interface is used to sync formula header, formula details and routing information
5 *This package defines and implements the procedures required to sync (i.e. create,update
6 *and delete) formula header,detail and routing informaton.
7 */
8 /* Start of comments */
9 /* API name : sync_recipe */
10 /* Type : Public */
11 /* Function : */
12 /* Paramaters : */
13 /* IN : p_api_version IN NUMBER Required */
14 /* p_commit IN Varchar2 Optional */
15 /* p_recipe_tbl IN gmd_ebi_recipe_tbl Required */
16 /* */
17
18 /* OUT x_recipe_tbl OUT gmd_ebi_recipe_output_tbl */
19 /* x_return_status OUT varchar2(1) */
20 /* x_msg_count OUT Number */
21 /* x_msg_data OUT varchar2(2000) */
22 /* */
23
24 /* Version : Current Version 1.0 */
25
26 /* */
27 /* */
28 /* End of comments */
29
30 /*#
31 * Syncs Formula, Formula Details and Routing information.
32 * This PL/SQL procedure is responsible for create,update and delete of formula
33 * Header,Formula Details and Routing Information created as an attachment.
34 * Call is made to insert/update/delete packages for formula header and detail.
35 */
36
37
38 PROCEDURE sync_recipe(
39 p_api_version IN VARCHAR2
40 ,p_commit IN VARCHAR2
41 ,p_recipe_tbl IN gmd_ebi_recipe_tbl
42 ,x_recipe_tbl OUT NOCOPY gmd_ebi_recipe_output_tbl
43 ,x_return_status OUT NOCOPY VARCHAR2
44 ,x_msg_count OUT NOCOPY NUMBER
45 ,x_msg_data OUT NOCOPY VARCHAR2
46 );
47
48 END gmd_ebi_recipe_pub;