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