1 PACKAGE WSH_CC_REQUEST_SETUPS_PKG AUTHID CURRENT_USER AS
2 /* $Header: WSHRSTHS.pls 115.4 2002/06/03 12:31:59 pkm ship $ */
3
4 /*----------------------------------------------------------*/
5 /* Insert_Row Procedure */
6 /*--------------------------------------------------------_-*/
7 /* --
8 -- Purpose
9 -- Insert a row into WSH_CC_REQUEST_SETUPS entity
10 --
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 request setup informations
24 --
25 -- Output Parameters
26 -- x_return_status
27 -- if the process succeeds, the value is
28 -- fnd_api.g_ret_sts_success;
29 -- if there is an expected error, the value is
30 -- fnd_api.g_ret_sts_error;
31 -- if there is an unexpected error, the value is
32 -- fnd_api.g_ret_sts_unexp_error;
33 -- x_msg_count
34 -- if there is one or more errors, the number of error messages
35 -- in the buffer
36 -- x_msg_data
37 -- if there is one and only one error, the error message
38 -- (See fnd_api package for more details about the above output parameters)
39 -- p_CC_REQUEST_SEQUENCE_ID - Clear Cross Request sequence Id ( PK)
40
41 --*/
42
43 PROCEDURE Insert_Row
44 (
45 p_api_version IN NUMBER ,
46 p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
47 p_commit IN VARCHAR2 := fnd_api.g_false ,
48 x_return_status OUT VARCHAR2 ,
49 x_msg_count OUT NUMBER ,
50 x_msg_data OUT VARCHAR2 ,
51 p_APPLICATION_ID IN NUMBER,
52 p_MASTER_ORGANIZATION_ID IN NUMBER,
53 p_ORGANIZATION_ID IN NUMBER default null,
54 p_APPLICATION_USER_ID IN NUMBER default null,
55 p_REQUEST_TYPE_CODE IN VARCHAR2,
56 p_REQUEST_VERSION IN VARCHAR2,
57 p_REQUEST_LANGUAGE IN VARCHAR2,
58 p_REQUEST_DATE_FORMAT IN VARCHAR2,
59 p_REQUEST_DEPLOYMENT_MODE IN VARCHAR2,
60 p_REQUEST_HANDLER IN VARCHAR2,
61 p_REQUEST_OUTPUT_TYPE IN VARCHAR2,
62 p_REQUEST_INCLUDE_FLAG IN VARCHAR2,
63 p_ECCN_CATG_SET_ID IN NUMBER,
64 p_HTS_CATG_SET_ID IN NUMBER,
65 p_ADDL_CATG_SET_ID IN NUMBER,
66 p_ADDITIONAL_ECE_COUNTRY_CHECK IN VARCHAR2,
67 p_CC_REQUEST_SEQUENCE_ID OUT NUMBER
68 );
69 /*----------------------------------------------------------*/
70 /* Update_Row Procedure */
71 /*--------------------------------------------------------_-*/
72 /* --
73 -- Purpose
74 -- Update a row into wsh_cc_request_setups entity
75 --
76 -- Input Parameters
77 -- p_api_version
78 -- API version number (current version is 1.0)
79 -- p_init_msg_list (optional, default FND_API.G_FALSE)
80 -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
81 -- if set to FND_API.G_TRUE
82 -- initialize error message list
83 -- if set to FND_API.G_FALSE - not initialize error
84 -- message list
85 -- p_commit (optional, default FND_API.G_FALSE)
86 -- whether or not to commit the changes to database
87 --
88 -- Input parameters for Clear Cross Request Setups Informations
89 --
90 --
91 -- Output Parameters
92 -- x_return_status
93 -- if the process succeeds, the value is
94 -- fnd_api.g_ret_sts_success;
95 -- if there is an expected error, the value is
96 -- fnd_api.g_ret_sts_error;
97 -- if there is an unexpected error, the value is
98 -- fnd_api.g_ret_sts_unexp_error;
99 -- x_msg_count
100 -- if there is one or more errors, the number of error messages
101 -- in the buffer
102 -- x_msg_data
103 -- if there is one and only one error, the error message
104 -- (See fnd_api package for more details about the above output parameters)
105 --*/
106
107 PROCEDURE Update_Row
108 (
109 p_api_version IN NUMBER ,
110 p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
111 p_commit IN VARCHAR2 := fnd_api.g_false ,
112 x_return_status OUT VARCHAR2 ,
113 x_msg_count OUT NUMBER ,
114 x_msg_data OUT VARCHAR2 ,
115 p_APPLICATION_ID IN NUMBER,
116 p_MASTER_ORGANIZATION_ID IN NUMBER,
117 p_ORGANIZATION_ID IN NUMBER default fnd_api.g_miss_num,
118 p_APPLICATION_USER_ID IN NUMBER default fnd_api.g_miss_num,
119 p_REQUEST_TYPE_CODE IN VARCHAR2,
120 p_REQUEST_VERSION IN VARCHAR2,
121 p_REQUEST_LANGUAGE IN VARCHAR2,
122 p_REQUEST_DATE_FORMAT IN VARCHAR2,
123 p_REQUEST_DEPLOYMENT_MODE IN VARCHAR2,
124 p_REQUEST_HANDLER IN VARCHAR2,
125 p_REQUEST_OUTPUT_TYPE IN VARCHAR2,
126 p_REQUEST_INCLUDE_FLAG IN VARCHAR2,
127 p_ECCN_CATG_SET_ID IN NUMBER,
128 p_HTS_CATG_SET_ID IN NUMBER,
129 p_ADDL_CATG_SET_ID IN NUMBER,
130 p_ADDITIONAL_ECE_COUNTRY_CHECK IN VARCHAR2,
131 p_CC_REQUEST_SEQUENCE_ID IN NUMBER
132 ) ;
133 /*----------------------------------------------------------*/
134 /* Delete_Row Procedure */
135 /*--------------------------------------------------------_-*/
136 /* --
137 -- Purpose
138 -- Delete a row from wsh_cc_users entity
139 --
140 -- Input Parameters
141 -- p_api_version
142 -- API version number (current version is 1.0)
143 -- p_init_msg_list (optional, default FND_API.G_FALSE)
144 -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
145 -- if set to FND_API.G_TRUE
146 -- initialize error message list
147 -- if set to FND_API.G_FALSE - not initialize error
148 -- message list
149 -- p_commit (optional, default FND_API.G_FALSE)
150 -- whether or not to commit the changes to database
151 --
152 -- Input parameters for Clear Cross Users Informations
153 -- p_CC_REQUEST_SEQUENCE_ID - Seq Id (PK)
154 --
155 --
156 -- Output Parameters
157 -- x_return_status
158 -- if the process succeeds, the value is
159 -- fnd_api.g_ret_sts_success;
160 -- if there is an expected error, the value is
161 -- fnd_api.g_ret_sts_error;
162 -- if there is an unexpected error, the value is
163 -- fnd_api.g_ret_sts_unexp_error;
164 -- x_msg_count
165 -- if there is one or more errors, the number of error messages
166 -- in the buffer
167 -- x_msg_data
168 -- if there is one and only one error, the error message
169 -- (See fnd_api package for more details about the above output parameters)
170 --*/
171
172 PROCEDURE Delete_Row
173 (
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_CC_REQUEST_SEQUENCE_ID IN NUMBER
181 );
182 /*----------------------------------------------------------*/
183 /* Lock_Row Procedure */
184 /*----------------------------------------------------------*/
185 /* --
186 -- Purpose
187 -- Check Lock a row of WSH_CC_REQUEST_SETUPS entity for the given cc seq id
188 --
189 -- Input Parameters
190 -- p_api_version
191 -- API version number (current version is 1.0)
192 -- p_init_msg_list (optional, default FND_API.G_FALSE)
193 -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
194 -- if set to FND_API.G_TRUE
195 -- initialize error message list
196 -- if set to FND_API.G_FALSE - not initialize error
197 -- message list
198 -- p_commit (optional, default FND_API.G_FALSE)
199 -- whether or not to commit the changes to database
200 --
201 -- Input parameters for clear cross request setups informations
202 --
203 --
204 -- Output Parameters
205 -- x_return_status
206 -- if the process succeeds, the value is
207 -- fnd_api.g_ret_sts_success;
208 -- if there is an expected error, the value is
209 -- fnd_api.g_ret_sts_error;
210 -- if there is an unexpected error, the value is
211 -- fnd_api.g_ret_sts_unexp_error;
212 -- x_msg_count
213 -- if there is one or more errors, the number of error messages
214 -- in the buffer
215 -- x_msg_data
216 -- if there is one and only one error, the error message
217 -- (See fnd_api package for more details about the above output parameters)
218
219 --*/
220 PROCEDURE Lock_Row
221 (
222 p_api_version IN NUMBER ,
223 p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
224 p_commit IN VARCHAR2 := fnd_api.g_false ,
225 x_return_status OUT VARCHAR2 ,
226 x_msg_count OUT NUMBER ,
227 x_msg_data OUT VARCHAR2 ,
228 p_APPLICATION_ID IN NUMBER,
229 p_MASTER_ORGANIZATION_ID IN NUMBER,
230 p_ORGANIZATION_ID IN NUMBER default fnd_api.g_miss_num,
231 p_APPLICATION_USER_ID IN NUMBER default fnd_api.g_miss_num,
232 p_REQUEST_TYPE_CODE IN VARCHAR2,
233 p_REQUEST_VERSION IN VARCHAR2,
234 p_REQUEST_LANGUAGE IN VARCHAR2,
235 p_REQUEST_DATE_FORMAT IN VARCHAR2,
236 p_REQUEST_DEPLOYMENT_MODE IN VARCHAR2,
237 p_REQUEST_HANDLER IN VARCHAR2,
238 p_REQUEST_OUTPUT_TYPE IN VARCHAR2,
239 p_REQUEST_INCLUDE_FLAG IN VARCHAR2,
240 p_ECCN_CATG_SET_ID IN NUMBER,
241 p_HTS_CATG_SET_ID IN NUMBER,
242 p_ADDL_CATG_SET_ID IN NUMBER,
243 p_ADDITIONAL_ECE_COUNTRY_CHECK IN VARCHAR2,
244 p_CC_REQUEST_SEQUENCE_ID IN NUMBER,
245 p_rowid IN VARCHAR2
246 );
247 END WSH_CC_REQUEST_SETUPS_PKG;