1 PACKAGE WSH_CC_SERVICE_SETUPS_PKG AUTHID CURRENT_USER AS
2 /* $Header: WSHSSTHS.pls 115.3 2002/06/03 12:32:06 pkm ship $ */
3
4 /*----------------------------------------------------------*/
5 /* Insert_Row Procedure */
6 /*--------------------------------------------------------_-*/
7 /* --
8 -- Purpose
9 -- Insert a row into WSH_CC_SERVICE_SETUPS_PKG 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 service 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_SERVICE_SEQUENCE_ID - Clear Cross Service 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_SERVICE_TYPE_CODE IN VARCHAR2,
56 p_SERVICE_VERSION IN VARCHAR2 default null,
57 p_SERVICE_HANDLER IN VARCHAR2,
58 p_SERVICE_DEFAULT_THRESHOLD IN NUMBER default null,
59 p_COUNTRY_MATCH_FLAG IN VARCHAR2 default null,
60 p_RED_FLAG IN VARCHAR2 default null,
61 p_SHIP_FROM_COUNTRY_SCHEME IN VARCHAR2 default null,
62 p_SHIP_FROM_COUNTRY_DOMAIN IN VARCHAR2 default null,
63 p_SHIP_TO_COUNTRY_SCHEME IN VARCHAR2 default null,
64 p_SHIP_TO_COUNTRY_DOMAIN IN VARCHAR2 default null,
65 p_CHARGE_SCHEME IN VARCHAR2 default null,
66 p_CHARGE_DOMAIN IN VARCHAR2 default null,
67 p_SERVICE_PRIORITY IN NUMBER default null,
68 p_WF_ITEM_TYPE IN VARCHAR2 default null,
69 p_WF_ACTIVITY IN VARCHAR2 default null,
70 p_CC_SERVICE_SEQUENCE_ID OUT NUMBER
71 );
72 /*----------------------------------------------------------*/
73 /* Update_Row Procedure */
74 /*--------------------------------------------------------_-*/
75 /* --
76 -- Purpose
77 -- Update a row into wsh_cc_service_setups entity
78 --
79 -- Input Parameters
80 -- p_api_version
81 -- API version number (current version is 1.0)
82 -- p_init_msg_list (optional, default FND_API.G_FALSE)
83 -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
84 -- if set to FND_API.G_TRUE
85 -- initialize error message list
86 -- if set to FND_API.G_FALSE - not initialize error
87 -- message list
88 -- p_commit (optional, default FND_API.G_FALSE)
89 -- whether or not to commit the changes to database
90 --
91 -- Input parameters for Clear Cross Service Setups Informations
92 --
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 Update_Row
111 (
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_APPLICATION_ID IN NUMBER,
119 p_MASTER_ORGANIZATION_ID IN NUMBER,
120 p_ORGANIZATION_ID IN NUMBER default fnd_api.g_miss_num,
121 p_APPLICATION_USER_ID IN NUMBER default fnd_api.g_miss_num,
122 p_SERVICE_TYPE_CODE IN VARCHAR2,
123 p_SERVICE_VERSION IN VARCHAR2 default null,
124 p_SERVICE_HANDLER IN VARCHAR2,
125 p_SERVICE_DEFAULT_THRESHOLD IN NUMBER,
126 p_COUNTRY_MATCH_FLAG IN VARCHAR2,
127 p_RED_FLAG IN VARCHAR2,
128 p_SHIP_FROM_COUNTRY_SCHEME IN VARCHAR2,
129 p_SHIP_FROM_COUNTRY_DOMAIN IN VARCHAR2,
130 p_SHIP_TO_COUNTRY_SCHEME IN VARCHAR2,
131 p_SHIP_TO_COUNTRY_DOMAIN IN VARCHAR2,
132 p_CHARGE_SCHEME IN VARCHAR2,
133 p_CHARGE_DOMAIN IN VARCHAR2,
134 p_SERVICE_PRIORITY IN NUMBER,
135 p_WF_ITEM_TYPE IN VARCHAR2,
136 p_WF_ACTIVITY IN VARCHAR2,
137 p_CC_SERVICE_SEQUENCE_ID IN NUMBER
138 ) ;
139 /*----------------------------------------------------------*/
140 /* Delete_Row Procedure */
141 /*--------------------------------------------------------_-*/
142 /* --
143 -- Purpose
144 -- Delete a row from wsh_cc_users entity
145 --
146 -- Input Parameters
147 -- p_api_version
148 -- API version number (current version is 1.0)
149 -- p_init_msg_list (optional, default FND_API.G_FALSE)
150 -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
151 -- if set to FND_API.G_TRUE
152 -- initialize error message list
153 -- if set to FND_API.G_FALSE - not initialize error
154 -- message list
155 -- p_commit (optional, default FND_API.G_FALSE)
156 -- whether or not to commit the changes to database
157 --
158 -- Input parameters for Clear Cross Users Informations
159 -- p_CC_SERVICE_SEQUENCE_ID - Seq Id (PK)
160 --
161 --
162 -- Output Parameters
163 -- x_return_status
164 -- if the process succeeds, the value is
165 -- fnd_api.g_ret_sts_success;
166 -- if there is an expected error, the value is
167 -- fnd_api.g_ret_sts_error;
168 -- if there is an unexpected error, the value is
169 -- fnd_api.g_ret_sts_unexp_error;
170 -- x_msg_count
171 -- if there is one or more errors, the number of error messages
172 -- in the buffer
173 -- x_msg_data
174 -- if there is one and only one error, the error message
175 -- (See fnd_api package for more details about the above output parameters)
176 --*/
177
178 PROCEDURE Delete_Row
179 (
180 p_api_version IN NUMBER ,
181 p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
182 p_commit IN VARCHAR2 := fnd_api.g_false ,
183 x_return_status OUT VARCHAR2 ,
184 x_msg_count OUT NUMBER ,
185 x_msg_data OUT VARCHAR2 ,
186 p_CC_SERVICE_SEQUENCE_ID IN NUMBER
187 );
188 /*----------------------------------------------------------*/
189 /* Lock_Row Procedure */
190 /*----------------------------------------------------------*/
191 /* --
192 -- Purpose
193 -- Check Lock a row of WSH_CC_SERVICE_SETUPS entity for the given cc seq id
194 --
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 -- Input parameters for clear cross service setups informations
208 --
209 --
210 -- Output Parameters
211 -- x_return_status
212 -- if the process succeeds, the value is
213 -- fnd_api.g_ret_sts_success;
214 -- if there is an expected error, the value is
215 -- fnd_api.g_ret_sts_error;
216 -- if there is an unexpected error, the value is
217 -- fnd_api.g_ret_sts_unexp_error;
218 -- x_msg_count
219 -- if there is one or more errors, the number of error messages
220 -- in the buffer
221 -- x_msg_data
222 -- if there is one and only one error, the error message
223 -- (See fnd_api package for more details about the above output parameters)
224
225 --*/
226 PROCEDURE Lock_Row
227 (
228 p_api_version IN NUMBER ,
229 p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
230 p_commit IN VARCHAR2 := fnd_api.g_false ,
231 x_return_status OUT VARCHAR2 ,
232 x_msg_count OUT NUMBER ,
233 x_msg_data OUT VARCHAR2 ,
234 p_APPLICATION_ID IN NUMBER,
235 p_MASTER_ORGANIZATION_ID IN NUMBER,
236 p_ORGANIZATION_ID IN NUMBER default fnd_api.g_miss_num,
237 p_APPLICATION_USER_ID IN NUMBER default fnd_api.g_miss_num,
238 p_SERVICE_TYPE_CODE IN VARCHAR2,
239 p_SERVICE_VERSION IN VARCHAR2 default null,
240 p_SERVICE_HANDLER IN VARCHAR2,
241 p_SERVICE_DEFAULT_THRESHOLD IN NUMBER,
242 p_COUNTRY_MATCH_FLAG IN VARCHAR2,
243 p_RED_FLAG IN VARCHAR2,
244 p_SHIP_FROM_COUNTRY_SCHEME IN VARCHAR2,
245 p_SHIP_FROM_COUNTRY_DOMAIN IN VARCHAR2,
246 p_SHIP_TO_COUNTRY_SCHEME IN VARCHAR2,
247 p_SHIP_TO_COUNTRY_DOMAIN IN VARCHAR2,
248 p_CHARGE_SCHEME IN VARCHAR2,
249 P_CHARGE_DOMAIN IN VARCHAR2,
250 P_SERVICE_PRIORITY IN NUMBER,
251 P_WF_ITEM_TYPE IN VARCHAR2,
252 P_WF_ACTIVITY IN VARCHAR2,
253 p_CC_SERVICE_SEQUENCE_ID IN NUMBER,
254 p_rowid IN VARCHAR2
255 );
256 END WSH_CC_SERVICE_SETUPS_PKG;