1 package WSH_ITM_PARAMETER_SETUPS_PKG AUTHID CURRENT_USER as
2 /* $Header: WSHITTHS.pls 120.0.12010000.1 2008/07/29 06:15:41 appldev ship $ */
3
4 /*----------------------------------------------------------*/
5 /* Insert_Row Procedure */
6 /*--------------------------------------------------------_-*/
7 /* --
8 -- Purpose
9 -- Insert a row into WSH_ITM_PARAMETER_SETUPS_B entity.
10 -- Insert a row into WSH_ITM_PARAMETER_SETUPS_TL entity.
11 -- Input Parameters
12 -- p_api_version
13 -- API version number (current version is 1.0)
14 -- p_init_msg_list (optional, default FND_API.G_FALSE)
15 -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
16 -- if set to FND_API.G_TRUE
17 -- initialize error message list
18 -- if set to FND_API.G_FALSE - not initialize error
19 -- message list
20 -- p_commit (optional, default FND_API.G_FALSE)
21 -- whether or not to commit the changes to database
22 --
23 -- Input parameters
24 -- P_PARAMETER_NAME Internal Name for the Parameter.
25 -- P_VALUE Parameter value.
26 -- P_DEFAULT_VALUE Parameter Default Value.
27 -- P_USER_SETTABLE User can Override.
28 -- P_USER_PARAMETER_NAME Parameter name identified by the user.
29 -- P_DESCRIPTION Brief Description of the Parameter.
30 --
31 -- Output Parameters
32 -- x_return_status
33 -- if the process succeeds, the value is
34 -- fnd_api.g_ret_sts_success;
35 -- if there is an expected error, the value is
36 -- fnd_api.g_ret_sts_error;
37 -- if there is an unexpected error, the value is
38 -- fnd_api.g_ret_sts_unexp_error;
39 -- x_msg_count
40 -- if there is one or more errors, the number of error messages
41 -- in the buffer
42 -- x_msg_data
43 -- if there is one and only one error, the error message
44 -- (See fnd_api package for more details about the above output parameters)
45
46 --*/
47
48
49 procedure INSERT_ROW (
50 p_api_version IN NUMBER ,
51 p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
52 p_commit IN VARCHAR2 := fnd_api.g_false ,
53 x_return_status OUT NOCOPY VARCHAR2 ,
54 x_msg_count OUT NOCOPY NUMBER ,
55 x_msg_data OUT NOCOPY VARCHAR2 ,
56 P_PARAMETER_ID OUT NOCOPY NUMBER ,
57 P_PARAMETER_NAME IN VARCHAR2 ,
58 P_VALUE IN VARCHAR2 ,
59 P_DEFAULT_VALUE IN VARCHAR2 ,
60 P_USER_SETTABLE IN VARCHAR2 ,
61 P_USER_PARAMETER_NAME IN VARCHAR2 ,
62 P_DESCRIPTION IN VARCHAR2
63 );
64
65 /*----------------------------------------------------------*/
66 /* Lock_Row Procedure */
67 /*----------------------------------------------------------*/
68 /* --
69 -- Purpose
70 -- Check Lock a row of WSH_ITM_PARAMETER_SETUPS_B entity.
71 -- Check Lock a row of WSH_ITM_PARAMETER_SETUPS_TL entity.
72 -- Input Parameters
73 -- p_api_version
74 -- API version number (current version is 1.0)
75 -- p_init_msg_list (optional, default FND_API.G_FALSE)
76 -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
77 -- if set to FND_API.G_TRUE
78 -- initialize error message list
79 -- if set to FND_API.G_FALSE - not initialize error
80 -- message list
81 -- p_commit (optional, default FND_API.G_FALSE)
82 -- whether or not to commit the changes to database
83 --
84 -- Input parameters
85 --
86 -- P_PARAMETER_ID Parameter ID
87 -- P_PARAMETER_NAME Internal Name for the Parameter.
88 -- P_VALUE Parameter value.
89 -- P_DEFAULT_VALUE Parameter Default Value.
90 -- P_USER_SETTABLE User can Override.
91 -- P_USER_PARAMETER_NAME Parameter name identified by the user.
92 -- P_DESCRIPTION Brief Description of the Parameter.
93 --
94 -- Output Parameters
95 -- x_return_status
96 -- if the process succeeds, the value is
97 -- fnd_api.g_ret_sts_success;
98 -- if there is an expected error, the value is
99 -- fnd_api.g_ret_sts_error;
100 -- if there is an unexpected error, the value is
101 -- fnd_api.g_ret_sts_unexp_error;
102 -- x_msg_count
103 -- if there is one or more errors, the number of error messages
104 -- in the buffer
105 -- x_msg_data
106 -- if there is one and only one error, the error message
107 -- (See fnd_api package for more details about the above output parameters)
108
109 --*/
110 procedure LOCK_ROW (
111 p_api_version IN NUMBER ,
112 p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
113 p_commit IN VARCHAR2 := fnd_api.g_false ,
114 x_return_status OUT NOCOPY VARCHAR2 ,
115 x_msg_count OUT NOCOPY NUMBER ,
116 x_msg_data OUT NOCOPY VARCHAR2 ,
117 P_PARAMETER_ID IN NUMBER,
118 P_PARAMETER_NAME IN VARCHAR2,
119 P_VALUE IN VARCHAR2,
120 P_DEFAULT_VALUE IN VARCHAR2,
121 P_USER_SETTABLE IN VARCHAR2,
122 P_USER_PARAMETER_NAME IN VARCHAR2,
123 P_DESCRIPTION IN VARCHAR2
124 );
125
126 /*----------------------------------------------------------*/
127 /* Update_Row Procedure */
128 /*--------------------------------------------------------_-*/
129 /* --
130 -- Purpose
131 -- Update a row into WSH_ITM_parameter_setups_b entity
132 -- Update a row into WSH_ITM_parameter_setups_tl entity
133 -- Input Parameters
134 -- p_api_version
135 -- API version number (current version is 1.0)
136 -- p_init_msg_list (optional, default FND_API.G_FALSE)
137 -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
138 -- if set to FND_API.G_TRUE
139 -- initialize error message list
140 -- if set to FND_API.G_FALSE - not initialize error
141 -- message list
142 -- p_commit (optional, default FND_API.G_FALSE)
143 -- whether or not to commit the changes to database
144 --
145 -- Input parameters
146 -- P_PARAMETER_ID Parameter ID.
147 -- P_PARAMETER_NAME Internal Name for the Parameter.
148 -- P_VALUE Parameter value.
149 -- P_DEFAULT_VALUE Parameter Default Value.
150 -- P_USER_SETTABLE User can Override.
151 -- P_USER_PARAMETER_NAME Parameter name identified by the user.
152 -- P_DESCRIPTION Brief Description of the Parameter.
153 --
154 -- Output Parameters
155 -- x_return_status
156 -- if the process succeeds, the value is
157 -- fnd_api.g_ret_sts_success;
158 -- if there is an expected error, the value is
159 -- fnd_api.g_ret_sts_error;
160 -- if there is an unexpected error, the value is
161 -- fnd_api.g_ret_sts_unexp_error;
162 -- x_msg_count
163 -- if there is one or more errors, the number of error messages
164 -- in the buffer
165 -- x_msg_data
166 -- if there is one and only one error, the error message
167 -- (See fnd_api package for more details about the above output parameters)
168 --*/
169
170
171
172 procedure UPDATE_ROW (
173 p_api_version IN NUMBER ,
174 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
175 p_commit IN VARCHAR2 := fnd_api.g_false,
176 x_return_status OUT NOCOPY VARCHAR2 ,
177 x_msg_count OUT NOCOPY NUMBER ,
178 x_msg_data OUT NOCOPY VARCHAR2 ,
179 P_PARAMETER_ID IN NUMBER ,
180 P_PARAMETER_NAME IN VARCHAR2 ,
181 P_VALUE IN VARCHAR2 ,
182 P_DEFAULT_VALUE IN VARCHAR2 ,
183 P_USER_SETTABLE IN VARCHAR2 ,
184 P_USER_PARAMETER_NAME IN VARCHAR2 ,
185 P_DESCRIPTION IN VARCHAR2
186 );
187
188 /*----------------------------------------------------------*/
189 /* Delete_Row Procedure */
190 /*--------------------------------------------------------_-*/
191 /* --
192 -- Purpose
193 -- Delete a row from WSH_ITM_parameter_setups_b entity
194 -- Delete a row from WSH_ITM_parameter_setups_tl entity
195 -- Input Parameters
196 -- p_api_version
197 -- API version number (current version is 1.0)
198 -- p_init_msg_list (optional, default FND_API.G_FALSE)
199 -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
200 -- if set to FND_API.G_TRUE
201 -- initialize error message list
202 -- if set to FND_API.G_FALSE - not initialize error
203 -- message list
204 -- p_commit (optional, default FND_API.G_FALSE)
205 -- whether or not to commit the changes to database
206 --
207 --
208 -- Output Parameters
209 -- x_return_status
210 -- if the process succeeds, the value is
211 -- fnd_api.g_ret_sts_success;
212 -- if there is an expected error, the value is
213 -- fnd_api.g_ret_sts_error;
214 -- if there is an unexpected error, the value is
215 -- fnd_api.g_ret_sts_unexp_error;
216 -- x_msg_count
217 -- if there is one or more errors, the number of error messages
218 -- in the buffer
219 -- x_msg_data
220 -- if there is one and only one error, the error message
221 -- (See fnd_api package for more details about the above output parameters)
222 --*/
223
224 procedure DELETE_ROW (
225 p_api_version IN NUMBER ,
226 p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
227 p_commit IN VARCHAR2 := fnd_api.g_false ,
228 x_return_status OUT NOCOPY VARCHAR2 ,
229 x_msg_count OUT NOCOPY NUMBER ,
230 x_msg_data OUT NOCOPY VARCHAR2 ,
231 P_PARAMETER_ID IN NUMBER
232 );
233
234 /*----------------------------------------------------------*/
235 /* Add_Language Procedure */
236 /*--------------------------------------------------------_-*/
237 procedure ADD_LANGUAGE;
238
239 /*----------------------------------------------------------*/
240 /* Translate_Row Procedure */
241 /*--------------------------------------------------------_-*/
242 PROCEDURE translate_row
243 (
244 x_parameter_id IN VARCHAR2 ,
245 x_owner IN VARCHAR2 ,
246 x_user_parameter_name IN VARCHAR2 ,
247 x_description IN VARCHAR2);
248
249 /*----------------------------------------------------------*/
250 /* Load_Row Procedure */
251 /*--------------------------------------------------------_-*/
252 PROCEDURE load_row
253 (
254 x_parameter_id IN VARCHAR2 ,
255 x_owner IN VARCHAR2 ,
256 x_parameter_name IN VARCHAR2 ,
257 x_user_parameter_name IN VARCHAR2 ,
258 x_value IN VARCHAR2 ,
259 x_user_settable IN VARCHAR2 ,
260 x_default_value IN VARCHAR2 ,
261 x_description IN VARCHAR2);
262
263 end WSH_ITM_PARAMETER_SETUPS_PKG;