1 PACKAGE GMD_FORMULA_DETAIL_PUB AUTHID CURRENT_USER AS
2 /* $Header: GMDPFMDS.pls 120.1.12010000.1 2008/07/24 09:56:26 appldev ship $ */
3 /*#
4 * This interface is used to create, update and delete Formula details.
5 * This package defines and implements the procedures and datatypes
6 * required to create, update and delete Formula details information.
7 * @rep:scope public
8 * @rep:product GMD
9 * @rep:lifecycle active
10 * @rep:displayname Formula Details package
11 * @rep:compatibility S
12 * @rep:category BUSINESS_ENTITY GMD_FORMULA
13 */
14
15 TYPE formula_update_dtl_tbl_type IS TABLE OF GMD_FORMULA_COMMON_PUB.formula_update_rec_type
16 INDEX BY BINARY_INTEGER;
17
18 TYPE formula_insert_dtl_tbl_type IS TABLE OF GMD_FORMULA_COMMON_PUB.formula_insert_rec_type
19 INDEX BY BINARY_INTEGER;
20
21 /* Start of commments */
22 /* API name : Insert_FormulaDetail */
23 /* Type : Public */
24 /* Function : */
25 /* Paramaters : */
26 /* IN : p_api_version IN NUMBER Required */
27 /* p_init_msg_list IN Varchar2 Optional */
28 /* p_commit IN Varchar2 Optional */
29 /* p_formula_detail_tbl IN formula_detail_tbl_type Required */
30 /* */
31 /* OUT x_return_status OUT varchar2(1) */
32 /* x_msg_count OUT Number */
33 /* x_msg_data OUT varchar2(2000) */
34 /* */
35 /* Version : Current Version 1.0 */
36 /* */
37 /* Notes : */
38 /* */
39 /* End of comments */
40
41 /*#
42 * Inserts Formula Details
43 * This PL/SQL procedure is responsible for inserting a formula detail after proper validations.
44 * Call is made to Insert_FormulaDetail API of GMD_FORMULA_DETAIL_PVT package.
45 * @param p_api_version API version field
46 * @param p_init_msg_list Flag to check if message list intialized
47 * @param p_commit Flag to check for commit
48 * @param p_called_from_forms Flag to check if API is called from a form
49 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
50 * @param x_msg_count Number of msg's on message stack
51 * @param x_msg_data Actual message data on message stack
52 * @param p_formula_detail_tbl Table structure of Formula details
53 * @rep:scope public
54 * @rep:lifecycle active
55 * @rep:displayname Insert Formula Details procedure
56 * @rep:compatibility S
57 */
58 PROCEDURE Insert_FormulaDetail
59 ( p_api_version IN NUMBER ,
60 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
61 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
62 p_called_from_forms IN VARCHAR2 := 'NO' ,
63 x_return_status OUT NOCOPY VARCHAR2 ,
64 x_msg_count OUT NOCOPY NUMBER ,
65 x_msg_data OUT NOCOPY VARCHAR2 ,
66 p_formula_detail_tbl IN formula_insert_dtl_tbl_type
67 );
68
69 /* Start of commments */
70 /* API name : Update_FormulaDetail */
71 /* Type : Public */
72 /* Function : */
73 /* Paramaters : */
74 /* IN : p_api_version IN NUMBER Required */
75 /* p_init_msg_list IN Varchar2 Optional */
76 /* p_commit IN Varchar2 Optional */
77 /* p_formula_detail_tbl IN formula_detail_tbl_type Required */
78 /* */
79 /* OUT x_return_status OUT varchar2(1) */
80 /* x_msg_count OUT Number */
81 /* x_msg_data OUT varchar2(2000) */
82 /* */
83 /* Version : Current Version 1.0 */
84 /* */
85 /* Notes : */
86 /* */
87 /* End of comments */
88
89 /*#
90 * Updates Formula Details
91 * This PL/SQL procedure is responsible for updating formula details.
92 * Call is made to Update_FormulaDetail API of GMD_FORMULA_DETAIL_PVT package.
93 * @param p_api_version API version field
94 * @param p_init_msg_list Flag to check if message list intialized
95 * @param p_commit Flag to check for commit
96 * @param p_called_from_forms Flag to check if API is called from a form
97 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
98 * @param x_msg_count Number of msg's on message stack
99 * @param x_msg_data Actual message data on message stack
100 * @param p_formula_detail_tbl Table structure of Formula details
101 * @rep:scope public
102 * @rep:lifecycle active
103 * @rep:displayname Update Formula Details procedure
104 * @rep:compatibility S
105 */
106 PROCEDURE Update_FormulaDetail
107 ( p_api_version IN NUMBER ,
108 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
109 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
110 p_called_from_forms IN VARCHAR2 := 'NO' ,
111 x_return_status OUT NOCOPY VARCHAR2 ,
112 x_msg_count OUT NOCOPY NUMBER ,
113 x_msg_data OUT NOCOPY VARCHAR2 ,
114 p_formula_detail_tbl IN formula_update_dtl_tbl_type
115 );
116
117
118 /* Start of commments */
119 /* API name : Delete_FormulaDetail */
120 /* Type : Public */
121 /* Function : */
122 /* Paramaters : */
123 /* IN : p_api_version IN NUMBER Required */
124 /* p_init_msg_list IN Varchar2 Optional */
125 /* p_commit IN Varchar2 Optional */
126 /* p_formula_detail_tbl IN formula_detail_tbl_type Required */
127 /* */
128 /* OUT x_return_status OUT varchar2(1) */
129 /* x_msg_count OUT Number */
130 /* x_msg_data OUT varchar2(2000) */
131 /* */
132 /* Version : Current Version 1.0 */
133 /* */
134 /* Notes : */
135 /* */
136 /* End of comments */
137
138 /*#
139 * Deletes Formula Details
140 * This PL/SQL procedure is responsible for deleting formula details.
141 * Call is made to Delete_FormulaDetail API of GMD_FORMULA_DETAIL_PVT package.
142 * @param p_api_version API version field
143 * @param p_init_msg_list Flag to check if message list intialized
144 * @param p_commit Flag to check for commit
145 * @param p_called_from_forms Flag to check if API is called from a form
146 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
147 * @param x_msg_count Number of msg's on message stack
148 * @param x_msg_data Actual message data on message stack
149 * @param p_formula_detail_tbl Table structure of Formula details
150 * @rep:scope public
151 * @rep:lifecycle active
152 * @rep:displayname Delete Formula Details procedure
153 * @rep:compatibility S
154 */
155 PROCEDURE Delete_FormulaDetail
156 ( p_api_version IN NUMBER ,
157 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
158 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
159 p_called_from_forms IN VARCHAR2 := 'NO' ,
160 x_return_status OUT NOCOPY VARCHAR2 ,
161 x_msg_count OUT NOCOPY NUMBER ,
162 x_msg_data OUT NOCOPY VARCHAR2 ,
163 p_formula_detail_tbl IN formula_update_dtl_tbl_type
164 );
165
166
167
168 END GMD_FORMULA_DETAIL_PUB;