eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.CS_INSTALLEDBASE_VUHK

Source


1 PACKAGE CS_InstalledBase_VUHK AUTHID CURRENT_USER AS
2 /* $Header: cshibs.pls 115.1 2002/12/11 20:25:40 epajaril ship $ */
3 
4 PROCEDURE Pre_Create_Base_Product
5 (
6 	p_api_version			IN	NUMBER,
7 	p_init_msg_list		IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
8 	p_commit				IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
9 	x_return_status		OUT NOCOPY	VARCHAR2,
10 	x_msg_count			OUT NOCOPY	NUMBER,
11 	x_msg_data			OUT NOCOPY	VARCHAR2,
12 	p_cp_rec				IN	CS_InstalledBase_PUB.CP_Prod_Rec_Type,
13 	x_cp_id				OUT NOCOPY	NUMBER,
14 	x_object_version_number	OUT NOCOPY	NUMBER
15 );
16 
17 PROCEDURE Pre_Record_Shipment_Info
18 (
19 	p_api_version			IN	NUMBER,
20 	p_init_msg_list		IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
21 	p_commit				IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
22 	x_return_status		OUT NOCOPY	VARCHAR2,
23 	x_msg_count			OUT NOCOPY	NUMBER,
24 	x_msg_data			OUT NOCOPY	VARCHAR2,
25 	p_ship_rec			IN	CS_InstalledBase_PUB.CP_Ship_Rec_Type,
26 	x_new_cp_id			OUT NOCOPY	NUMBER
27 );
28 
29 PROCEDURE Pre_Replace_Product
30 (
31 	p_api_version			IN	NUMBER,
32 	p_init_msg_list		IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
33 	p_commit				IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
34 	x_return_status		OUT NOCOPY	VARCHAR2,
35 	x_msg_count			OUT NOCOPY	NUMBER,
36 	x_msg_data			OUT NOCOPY	VARCHAR2,
37 	p_cp_id				IN	NUMBER,
38 	p_old_cp_status_id		IN   NUMBER,
39 	p_cp_rec				IN	CS_InstalledBase_PUB.CP_Prod_Rec_Type,
40 	p_inherit_contacts		IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
41 	p_upgrade				IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
42 	x_new_cp_id			OUT NOCOPY	NUMBER,
43 	p_qty_mismatch_ok		IN	VARCHAR2	DEFAULT FND_API.G_FALSE
44 );
45 
46 PROCEDURE Pre_Update_Product
47 (
48 	p_api_version					IN	NUMBER,
49 	p_init_msg_list				IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
50 	p_commit						IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
51 	x_return_status				OUT NOCOPY	VARCHAR2,
52 	x_msg_count					OUT NOCOPY	NUMBER,
53 	x_msg_data					OUT NOCOPY	VARCHAR2,
54 	p_cp_id						IN	NUMBER,
55 	p_as_of_date					IN	DATE	DEFAULT sysdate,
56 	p_cp_rec						IN	CS_InstalledBase_PUB.CP_Prod_Rec_Type,
57 	p_ship_rec					IN	CS_InstalledBase_PUB.CP_Ship_Rec_Type,
58 	p_abort_on_warn_flag			IN	CS_InstalledBase_PUB.Abort_Upd_On_Warn_Rec_Type,
59 	p_cascade_updates_flag			IN	CS_InstalledBase_PUB.Cascade_Upd_Flag_Rec_Type,
60 	p_cascade_inst_date_change_war	IN	VARCHAR2	DEFAULT FND_API.G_TRUE
61 );
62 
63 PROCEDURE Pre_Create_Revision
64 (
65 	p_api_version			IN	NUMBER,
66 	p_init_msg_list		IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
67 	p_commit				IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
68 	x_return_status		OUT NOCOPY	VARCHAR2,
69 	x_msg_count			OUT NOCOPY	NUMBER,
70 	x_msg_data			OUT NOCOPY	VARCHAR2,
71 	p_cp_id				IN	NUMBER,
72 	p_rev_inv_item_id		IN	NUMBER,
73 	p_order_info			IN	CS_InstalledBase_PUB.OrderInfo_Rec_Type,
74 	p_desc_flex			IN	CS_InstalledBase_PUB.DFF_Rec_Type,
75 	p_start_date_active		IN	DATE		,
76 	p_end_date_active		IN	DATE		,
77 	p_delivered_flag		IN	VARCHAR2	,
78 	x_cp_rev_id			OUT NOCOPY	NUMBER,
79 	x_curr_rev_of_cp_updtd	OUT NOCOPY	VARCHAR2,
80 	x_object_version_number	OUT NOCOPY	NUMBER
81 );
82 
83 PROCEDURE Pre_Update_Revision
84 (
85 	p_api_version			IN	NUMBER,
86 	p_init_msg_list		IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
87 	p_commit				IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
88 	x_return_status		OUT NOCOPY	VARCHAR2,
89 	x_msg_count			OUT NOCOPY	NUMBER,
90 	x_msg_data			OUT NOCOPY	VARCHAR2,
91 	p_cp_rev_id			IN	NUMBER,
92 	p_object_version_number	IN	NUMBER,
93 	p_start_date_active		IN	DATE		,
94 	p_end_date_active		IN	DATE		,
95 	p_desc_flex			IN	CS_InstalledBase_PUB.DFF_Rec_Type,
96 	x_object_version_number	OUT NOCOPY	NUMBER
97 );
98 
99 PROCEDURE Pre_Specify_Contact
100 (
101 	p_api_version			IN	NUMBER,
102 	p_init_msg_list		IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
103 	p_commit				IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
104 	x_return_status		OUT NOCOPY	VARCHAR2,
105 	x_msg_count			OUT NOCOPY	NUMBER,
106 	x_msg_data			OUT NOCOPY	VARCHAR2,
107 	p_contact_rec			IN	CS_InstalledBase_PUB.CP_Contact_Rec_Type,
108 	x_cs_contact_id		OUT NOCOPY	NUMBER,
109 	x_object_version_number	OUT NOCOPY	NUMBER
110 );
111 
112 PROCEDURE Pre_Update_Contact
113 (
114 	p_api_version			IN	NUMBER,
115 	p_init_msg_list		IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
116 	p_commit				IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
117 	x_return_status		OUT NOCOPY	VARCHAR2,
118 	x_msg_count			OUT NOCOPY	NUMBER,
119 	x_msg_data			OUT NOCOPY	VARCHAR2,
120 	p_cs_contact_id		IN	NUMBER,
121 	p_object_version_number	IN	NUMBER,
122 	p_contact_rec			IN	CS_InstalledBase_PUB.CP_Contact_Rec_Type,
123 	x_object_version_number	OUT NOCOPY	NUMBER
124 );
125 
126 PROCEDURE Pre_Delete_Contact
127 (
128 	p_api_version			IN	NUMBER,
129 	p_init_msg_list		IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
130 	p_commit				IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
131 	x_return_status		OUT NOCOPY	VARCHAR2,
132 	x_msg_count			OUT NOCOPY	NUMBER,
133 	x_msg_data			OUT NOCOPY	VARCHAR2,
134 	p_cs_contact_id		IN	NUMBER
135 );
136 
137 PROCEDURE Pre_Split_Product
138 (
139 	p_api_version			IN	NUMBER,
140 	p_init_msg_list		IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
141 	p_commit				IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
142 	x_return_status		OUT NOCOPY	VARCHAR2,
143 	x_msg_count			OUT NOCOPY	NUMBER,
144 	x_msg_data			OUT NOCOPY	VARCHAR2,
145 	p_cp_id				IN	NUMBER,
146 	p_qty1				IN	NUMBER,
147 	p_qty2				IN	NUMBER,
148 	p_reason_code			IN	VARCHAR2,
149 	x_new_parent_cp_id		OUT NOCOPY	NUMBER
150 ) ;
151 
152 PROCEDURE Pre_Create_Product_Parameters
153 (
154 	p_api_version		IN      NUMBER,
155 	p_init_msg_list     IN      VARCHAR2	DEFAULT FND_API.G_FALSE,
156 	p_commit            IN      VARCHAR2    DEFAULT FND_API.G_FALSE,
157 	x_return_status     OUT NOCOPY     VARCHAR2,
158 	x_msg_count         OUT NOCOPY     NUMBER,
159 	x_msg_data          OUT NOCOPY     VARCHAR2,
160 	p_cp_param_rec      IN      CS_InstalledBase_PUB.CP_Param_Rec_Type,
161 	x_cp_parameter_id   OUT NOCOPY     NUMBER,
162 	x_object_version_number	OUT NOCOPY	NUMBER
163 );
164 
165 
166 PROCEDURE Pre_Update_Product_Parameters
167 (
168 	p_api_version			IN      NUMBER,
169 	p_init_msg_list		IN      VARCHAR2	DEFAULT FND_API.G_FALSE,
170 	p_commit				IN      VARCHAR2    DEFAULT FND_API.G_FALSE,
171 	x_return_status		OUT NOCOPY     VARCHAR2,
172 	x_msg_count			OUT NOCOPY     NUMBER,
173 	x_msg_data			OUT NOCOPY     VARCHAR2,
174 	p_cp_parameter_id		IN      NUMBER,
175 	p_object_version_number	IN	   NUMBER,
176 	p_cp_param_rec			IN      CS_InstalledBase_PUB.CP_Param_Rec_Type,
177 	x_object_version_number	OUT NOCOPY	   NUMBER
178 );
179 
180 
181 PROCEDURE Pre_Delete_Product_Parameters
182 (
183 	p_api_version		IN      NUMBER,
184 	p_init_msg_list     IN      VARCHAR2	DEFAULT FND_API.G_FALSE,
185 	p_commit            IN      VARCHAR2    DEFAULT FND_API.G_FALSE,
186 	x_return_status     OUT NOCOPY     VARCHAR2,
187 	x_msg_count         OUT NOCOPY     NUMBER,
188 	x_msg_data          OUT NOCOPY     VARCHAR2,
189 	p_cp_parameter_id   IN      NUMBER
190 );
191 
192 
193 PROCEDURE Post_Create_Base_Product
194 (
195 	p_api_version			IN	NUMBER,
196 	p_init_msg_list		IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
197 	p_commit				IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
198 	x_return_status		OUT NOCOPY	VARCHAR2,
199 	x_msg_count			OUT NOCOPY	NUMBER,
200 	x_msg_data			OUT NOCOPY	VARCHAR2,
201 	p_cp_rec				IN	CS_InstalledBase_PUB.CP_Prod_Rec_Type,
202 	x_cp_id				OUT NOCOPY	NUMBER,
203 	x_object_version_number	OUT NOCOPY	NUMBER
204 );
205 
206 PROCEDURE Post_Record_Shipment_Info
207 (
208 	p_api_version			IN	NUMBER,
209 	p_init_msg_list		IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
210 	p_commit				IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
211 	x_return_status		OUT NOCOPY	VARCHAR2,
212 	x_msg_count			OUT NOCOPY	NUMBER,
213 	x_msg_data			OUT NOCOPY	VARCHAR2,
214 	p_ship_rec			IN	CS_InstalledBase_PUB.CP_Ship_Rec_Type,
215 	x_new_cp_id			OUT NOCOPY	NUMBER
216 );
217 
218 PROCEDURE Post_Replace_Product
219 (
220 	p_api_version			IN	NUMBER,
221 	p_init_msg_list		IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
222 	p_commit				IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
223 	x_return_status		OUT NOCOPY	VARCHAR2,
224 	x_msg_count			OUT NOCOPY	NUMBER,
225 	x_msg_data			OUT NOCOPY	VARCHAR2,
226 	p_cp_id				IN	NUMBER,
227 	p_old_cp_status_id		IN   NUMBER,
228 	p_cp_rec				IN	CS_InstalledBase_PUB.CP_Prod_Rec_Type,
229 	p_inherit_contacts		IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
230 	p_upgrade				IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
231 	x_new_cp_id			OUT NOCOPY	NUMBER,
232 	p_qty_mismatch_ok		IN	VARCHAR2	DEFAULT FND_API.G_FALSE
233 );
234 
235 PROCEDURE Post_Update_Product
236 (
237 	p_api_version					IN	NUMBER,
238 	p_init_msg_list				IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
239 	p_commit						IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
240 	x_return_status				OUT NOCOPY	VARCHAR2,
241 	x_msg_count					OUT NOCOPY	NUMBER,
242 	x_msg_data					OUT NOCOPY	VARCHAR2,
243 	p_cp_id						IN	NUMBER,
244 	p_as_of_date					IN	DATE	DEFAULT sysdate,
245 	p_cp_rec						IN	CS_InstalledBase_PUB.CP_Prod_Rec_Type,
246 	p_ship_rec					IN	CS_InstalledBase_PUB.CP_Ship_Rec_Type,
247 	p_abort_on_warn_flag			IN	CS_InstalledBase_PUB.Abort_Upd_On_Warn_Rec_Type,
248 	p_cascade_updates_flag			IN	CS_InstalledBase_PUB.Cascade_Upd_Flag_Rec_Type,
249 	p_cascade_inst_date_change_war	IN	VARCHAR2	DEFAULT FND_API.G_TRUE
250 );
251 
252 PROCEDURE Post_Create_Revision
253 (
254 	p_api_version			IN	NUMBER,
255 	p_init_msg_list		IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
256 	p_commit				IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
257 	x_return_status		OUT NOCOPY	VARCHAR2,
258 	x_msg_count			OUT NOCOPY	NUMBER,
259 	x_msg_data			OUT NOCOPY	VARCHAR2,
260 	p_cp_id				IN	NUMBER,
261 	p_rev_inv_item_id		IN	NUMBER,
262 	p_order_info			IN	CS_InstalledBase_PUB.OrderInfo_Rec_Type,
263 	p_desc_flex			IN	CS_InstalledBase_PUB.DFF_Rec_Type,
264 	p_start_date_active		IN	DATE		,
265 	p_end_date_active		IN	DATE		,
266 	p_delivered_flag		IN	VARCHAR2	,
267 	x_cp_rev_id			OUT NOCOPY	NUMBER,
268 	x_curr_rev_of_cp_updtd	OUT NOCOPY	VARCHAR2,
269 	x_object_version_number	OUT NOCOPY	NUMBER
270 );
271 
272 PROCEDURE Post_Update_Revision
273 (
274 	p_api_version			IN	NUMBER,
275 	p_init_msg_list		IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
276 	p_commit				IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
277 	x_return_status		OUT NOCOPY	VARCHAR2,
278 	x_msg_count			OUT NOCOPY	NUMBER,
279 	x_msg_data			OUT NOCOPY	VARCHAR2,
280 	p_cp_rev_id			IN	NUMBER,
281 	p_object_version_number	IN	NUMBER,
282 	p_start_date_active		IN	DATE		,
283 	p_end_date_active		IN	DATE		,
284 	p_desc_flex			IN	CS_InstalledBase_PUB.DFF_Rec_Type,
285 	x_object_version_number	OUT NOCOPY	NUMBER
286 );
287 
288 PROCEDURE Post_Specify_Contact
289 (
290 	p_api_version			IN	NUMBER,
291 	p_init_msg_list		IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
292 	p_commit				IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
293 	x_return_status		OUT NOCOPY	VARCHAR2,
294 	x_msg_count			OUT NOCOPY	NUMBER,
295 	x_msg_data			OUT NOCOPY	VARCHAR2,
296 	p_contact_rec			IN	CS_InstalledBase_PUB.CP_Contact_Rec_Type,
297 	x_cs_contact_id		OUT NOCOPY	NUMBER,
298 	x_object_version_number	OUT NOCOPY	NUMBER
299 );
300 
301 PROCEDURE Post_Update_Contact
302 (
303 	p_api_version			IN	NUMBER,
304 	p_init_msg_list		IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
305 	p_commit				IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
306 	x_return_status		OUT NOCOPY	VARCHAR2,
307 	x_msg_count			OUT NOCOPY	NUMBER,
308 	x_msg_data			OUT NOCOPY	VARCHAR2,
309 	p_cs_contact_id		IN	NUMBER,
310 	p_object_version_number	IN	NUMBER,
311 	p_contact_rec			IN	CS_InstalledBase_PUB.CP_Contact_Rec_Type,
312 	x_object_version_number	OUT NOCOPY	NUMBER
313 );
314 
315 PROCEDURE Post_Delete_Contact
316 (
317 	p_api_version			IN	NUMBER,
318 	p_init_msg_list		IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
319 	p_commit				IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
320 	x_return_status		OUT NOCOPY	VARCHAR2,
321 	x_msg_count			OUT NOCOPY	NUMBER,
322 	x_msg_data			OUT NOCOPY	VARCHAR2,
323 	p_cs_contact_id		IN	NUMBER
324 );
325 
326 PROCEDURE Post_Split_Product
327 (
328 	p_api_version			IN	NUMBER,
329 	p_init_msg_list		IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
330 	p_commit				IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
331 	x_return_status		OUT NOCOPY	VARCHAR2,
332 	x_msg_count			OUT NOCOPY	NUMBER,
333 	x_msg_data			OUT NOCOPY	VARCHAR2,
334 	p_cp_id				IN	NUMBER,
335 	p_qty1				IN	NUMBER,
336 	p_qty2				IN	NUMBER,
337 	p_reason_code			IN	VARCHAR2,
338 	x_new_parent_cp_id		OUT NOCOPY	NUMBER
339 ) ;
340 
341 PROCEDURE Post_Create_Product_Parameters
342 (
343 	p_api_version		IN      NUMBER,
344 	p_init_msg_list     IN      VARCHAR2	DEFAULT FND_API.G_FALSE,
345 	p_commit            IN      VARCHAR2    DEFAULT FND_API.G_FALSE,
346 	x_return_status     OUT NOCOPY     VARCHAR2,
347 	x_msg_count         OUT NOCOPY     NUMBER,
348 	x_msg_data          OUT NOCOPY     VARCHAR2,
349 	p_cp_param_rec      IN      CS_InstalledBase_PUB.CP_Param_Rec_Type,
350 	x_cp_parameter_id   OUT NOCOPY     NUMBER,
351 	x_object_version_number	OUT NOCOPY	NUMBER
352 );
353 
354 
355 PROCEDURE Post_Update_Product_Parameters
356 (
357 	p_api_version			IN      NUMBER,
358 	p_init_msg_list		IN      VARCHAR2	DEFAULT FND_API.G_FALSE,
359 	p_commit				IN      VARCHAR2    DEFAULT FND_API.G_FALSE,
360 	x_return_status		OUT NOCOPY     VARCHAR2,
361 	x_msg_count			OUT NOCOPY     NUMBER,
362 	x_msg_data			OUT NOCOPY     VARCHAR2,
363 	p_cp_parameter_id		IN      NUMBER,
364 	p_object_version_number	IN	   NUMBER,
365 	p_cp_param_rec			IN      CS_InstalledBase_PUB.CP_Param_Rec_Type,
366 	x_object_version_number	OUT NOCOPY	   NUMBER
367 );
368 
369 
373 	p_init_msg_list     IN      VARCHAR2	DEFAULT FND_API.G_FALSE,
370 PROCEDURE Post_Delete_Product_Parameters
371 (
372 	p_api_version		IN      NUMBER,
374 	p_commit            IN      VARCHAR2    DEFAULT FND_API.G_FALSE,
375 	x_return_status     OUT NOCOPY     VARCHAR2,
376 	x_msg_count         OUT NOCOPY     NUMBER,
377 	x_msg_data          OUT NOCOPY     VARCHAR2,
378 	p_cp_parameter_id   IN      NUMBER
379 );
380 
381 END CS_InstalledBase_VUHK;