1 PACKAGE CSI_CUSTOMER_PRODUCTS_PKG AUTHID CURRENT_USER AS
2 /*$Header: CSIXCPTS.pls 115.9 2003/02/07 23:48:36 rmamidip noship $*/
3 -- Defining Global Parameters.
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSI_CUSTOMER_PRODUCTS_PKG';
5 --G_USER CONSTANT VARCHAR2(30) := FND_GLOBAL.USER_ID;
6
7 -- Procedure to convert Customer Products parameters to RecordType
8 PROCEDURE Convert_Cp_Prod_Param_To_Rec(
9 P_CUSTOMER_PRODUCT_ID IN NUMBER := FND_API.G_MISS_NUM,
10 P_CUSTOMER_ID IN NUMBER := FND_API.G_MISS_NUM,
11 P_INVENTORY_ITEM_ID IN NUMBER := FND_API.G_MISS_NUM,
12 P_CUSTOMER_PRODUCT_STATUS_ID IN NUMBER := FND_API.G_MISS_NUM,
13 P_INSTANCE_PARTY_ID IN NUMBER := FND_API.G_MISS_NUM,
14 P_IP_ACCOUNT_ID IN NUMBER := FND_API.G_MISS_NUM,
15 P_PRICING_ATTRIBUTE_ID IN NUMBER := FND_API.G_MISS_NUM,
16 P_RELATIONSHIP_ID IN NUMBER := FND_API.G_MISS_NUM,
17 P_START_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
18 P_END_DATE_ACTIVE IN DATE := FND_API.G_MISS_DATE,
19 P_ORIGINAL_ORDER_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
20 P_ORIGINAL_LINE_SERV_DETAIL_ID IN NUMBER := FND_API.G_MISS_NUM,
21 P_RETURN_BY_DATE IN DATE := FND_API.G_MISS_DATE,
22 P_RMA_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
23 P_ACTUAL_RETURNED_DATE IN DATE := FND_API.G_MISS_DATE,
24 P_QUANTITY IN NUMBER := FND_API.G_MISS_NUM,
25 P_UNIT_OF_MEASURE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
26 P_DELIVERED_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
27 P_SHIPPED_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
28 P_TYPE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
29 P_SYSTEM_ID IN NUMBER := FND_API.G_MISS_NUM,
30 P_PRODUCT_AGREEMENT_ID IN NUMBER := FND_API.G_MISS_NUM,
31 P_SHIP_TO_SITE_USE_ID IN NUMBER := FND_API.G_MISS_NUM,
32 P_BILL_TO_SITE_USE_ID IN NUMBER := FND_API.G_MISS_NUM,
33 P_INSTALL_SITE_USE_ID IN NUMBER := FND_API.G_MISS_NUM,
34 P_INSTALLATION_DATE IN DATE := FND_API.G_MISS_DATE,
35 P_CONFIG_TYPE IN VARCHAR2 := FND_API.G_MISS_CHAR,
36 P_CONFIG_START_DATE IN DATE := FND_API.G_MISS_DATE,
37 P_CONFIG_PARENT_ID IN NUMBER := FND_API.G_MISS_NUM,
38 P_PROJECT_ID IN NUMBER := FND_API.G_MISS_NUM,
39 P_TASK_ID IN NUMBER := FND_API.G_MISS_NUM,
40 P_PLATFORM_VERSION_ID IN NUMBER := FND_API.G_MISS_NUM,
41 P_MERCHANT_VIEW_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
42 P_CUSTOMER_VIEW_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
43 P_CURRENT_SERIAL_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
44 P_REVISION IN VARCHAR2 := FND_API.G_MISS_CHAR,
45 P_LOT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
46 P_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47 P_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48 P_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49 P_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50 P_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51 P_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52 P_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53 P_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54 P_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55 P_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56 P_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57 P_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58 P_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59 P_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60 P_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61 P_CONTEXT IN VARCHAR2 := FND_API.G_MISS_CHAR,
62 p_PRICING_CONTEXT IN VARCHAR2 := FND_API.G_MISS_CHAR,
63 p_PRICING_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
64 p_PRICING_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
65 p_PRICING_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
66 p_PRICING_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
67 p_PRICING_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
68 p_PRICING_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
69 p_PRICING_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
70 p_PRICING_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
71 p_PRICING_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
72 p_PRICING_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
73 p_PRICING_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
74 p_PRICING_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
75 p_PRICING_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
76 p_PRICING_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
77 p_PRICING_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
78 p_PRICING_ATTRIBUTE16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
79 p_PRICING_ATTRIBUTE17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
80 p_PRICING_ATTRIBUTE18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
81 p_PRICING_ATTRIBUTE19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
82 p_PRICING_ATTRIBUTE20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
83 p_PRICING_ATTRIBUTE21 IN VARCHAR2 := FND_API.G_MISS_CHAR,
84 p_PRICING_ATTRIBUTE22 IN VARCHAR2 := FND_API.G_MISS_CHAR,
85 p_PRICING_ATTRIBUTE23 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86 p_PRICING_ATTRIBUTE24 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87 p_PRICING_ATTRIBUTE25 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88 p_PRICING_ATTRIBUTE26 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89 p_PRICING_ATTRIBUTE27 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90 p_PRICING_ATTRIBUTE28 IN VARCHAR2 := FND_API.G_MISS_CHAR,
91 p_PRICING_ATTRIBUTE29 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92 p_PRICING_ATTRIBUTE30 IN VARCHAR2 := FND_API.G_MISS_CHAR,
93 p_PRICING_ATTRIBUTE31 IN VARCHAR2 := FND_API.G_MISS_CHAR,
94 p_PRICING_ATTRIBUTE32 IN VARCHAR2 := FND_API.G_MISS_CHAR,
95 p_PRICING_ATTRIBUTE33 IN VARCHAR2 := FND_API.G_MISS_CHAR,
96 p_PRICING_ATTRIBUTE34 IN VARCHAR2 := FND_API.G_MISS_CHAR,
97 p_PRICING_ATTRIBUTE35 IN VARCHAR2 := FND_API.G_MISS_CHAR,
98 p_PRICING_ATTRIBUTE36 IN VARCHAR2 := FND_API.G_MISS_CHAR,
99 p_PRICING_ATTRIBUTE37 IN VARCHAR2 := FND_API.G_MISS_CHAR,
100 p_PRICING_ATTRIBUTE38 IN VARCHAR2 := FND_API.G_MISS_CHAR,
101 p_PRICING_ATTRIBUTE39 IN VARCHAR2 := FND_API.G_MISS_CHAR,
102 p_PRICING_ATTRIBUTE40 IN VARCHAR2 := FND_API.G_MISS_CHAR,
103 p_PRICING_ATTRIBUTE41 IN VARCHAR2 := FND_API.G_MISS_CHAR,
104 p_PRICING_ATTRIBUTE42 IN VARCHAR2 := FND_API.G_MISS_CHAR,
105 p_PRICING_ATTRIBUTE43 IN VARCHAR2 := FND_API.G_MISS_CHAR,
106 p_PRICING_ATTRIBUTE44 IN VARCHAR2 := FND_API.G_MISS_CHAR,
107 p_PRICING_ATTRIBUTE45 IN VARCHAR2 := FND_API.G_MISS_CHAR,
108 p_PRICING_ATTRIBUTE46 IN VARCHAR2 := FND_API.G_MISS_CHAR,
109 p_PRICING_ATTRIBUTE47 IN VARCHAR2 := FND_API.G_MISS_CHAR,
110 p_PRICING_ATTRIBUTE48 IN VARCHAR2 := FND_API.G_MISS_CHAR,
111 p_PRICING_ATTRIBUTE49 IN VARCHAR2 := FND_API.G_MISS_CHAR,
112 p_PRICING_ATTRIBUTE50 IN VARCHAR2 := FND_API.G_MISS_CHAR,
113 p_PRICING_ATTRIBUTE51 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114 p_PRICING_ATTRIBUTE52 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115 p_PRICING_ATTRIBUTE53 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116 p_PRICING_ATTRIBUTE54 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117 p_PRICING_ATTRIBUTE55 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118 p_PRICING_ATTRIBUTE56 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119 p_PRICING_ATTRIBUTE57 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120 p_PRICING_ATTRIBUTE58 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121 p_PRICING_ATTRIBUTE59 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122 p_PRICING_ATTRIBUTE60 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123 p_PRICING_ATTRIBUTE61 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124 p_PRICING_ATTRIBUTE62 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125 p_PRICING_ATTRIBUTE63 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126 p_PRICING_ATTRIBUTE64 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127 p_PRICING_ATTRIBUTE65 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128 p_PRICING_ATTRIBUTE66 IN VARCHAR2 := FND_API.G_MISS_CHAR,
129 p_PRICING_ATTRIBUTE67 IN VARCHAR2 := FND_API.G_MISS_CHAR,
130 p_PRICING_ATTRIBUTE68 IN VARCHAR2 := FND_API.G_MISS_CHAR,
131 p_PRICING_ATTRIBUTE69 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132 p_PRICING_ATTRIBUTE70 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133 p_PRICING_ATTRIBUTE71 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134 p_PRICING_ATTRIBUTE72 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135 p_PRICING_ATTRIBUTE73 IN VARCHAR2 := FND_API.G_MISS_CHAR,
136 p_PRICING_ATTRIBUTE74 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137 p_PRICING_ATTRIBUTE75 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138 p_PRICING_ATTRIBUTE76 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139 p_PRICING_ATTRIBUTE77 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140 p_PRICING_ATTRIBUTE78 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141 p_PRICING_ATTRIBUTE79 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142 p_PRICING_ATTRIBUTE80 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143 p_PRICING_ATTRIBUTE81 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144 p_PRICING_ATTRIBUTE82 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145 p_PRICING_ATTRIBUTE83 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146 p_PRICING_ATTRIBUTE84 IN VARCHAR2 := FND_API.G_MISS_CHAR,
147 p_PRICING_ATTRIBUTE85 IN VARCHAR2 := FND_API.G_MISS_CHAR,
148 p_PRICING_ATTRIBUTE86 IN VARCHAR2 := FND_API.G_MISS_CHAR,
149 p_PRICING_ATTRIBUTE87 IN VARCHAR2 := FND_API.G_MISS_CHAR,
150 p_PRICING_ATTRIBUTE88 IN VARCHAR2 := FND_API.G_MISS_CHAR,
151 p_PRICING_ATTRIBUTE89 IN VARCHAR2 := FND_API.G_MISS_CHAR,
152 p_PRICING_ATTRIBUTE90 IN VARCHAR2 := FND_API.G_MISS_CHAR,
153 p_PRICING_ATTRIBUTE91 IN VARCHAR2 := FND_API.G_MISS_CHAR,
154 p_PRICING_ATTRIBUTE92 IN VARCHAR2 := FND_API.G_MISS_CHAR,
155 p_PRICING_ATTRIBUTE93 IN VARCHAR2 := FND_API.G_MISS_CHAR,
156 p_PRICING_ATTRIBUTE94 IN VARCHAR2 := FND_API.G_MISS_CHAR,
157 p_PRICING_ATTRIBUTE95 IN VARCHAR2 := FND_API.G_MISS_CHAR,
158 p_PRICING_ATTRIBUTE96 IN VARCHAR2 := FND_API.G_MISS_CHAR,
159 p_PRICING_ATTRIBUTE97 IN VARCHAR2 := FND_API.G_MISS_CHAR,
160 p_PRICING_ATTRIBUTE98 IN VARCHAR2 := FND_API.G_MISS_CHAR,
161 p_PRICING_ATTRIBUTE99 IN VARCHAR2 := FND_API.G_MISS_CHAR,
162 p_PRICING_ATTRIBUTE100 IN VARCHAR2 := FND_API.G_MISS_CHAR,
163 Px_Cp_Object_Version_Number IN OUT NOCOPY NUMBER, -- := FND_API.G_MISS_NUM,
164 Px_Ip_Object_Version_Number IN OUT NOCOPY NUMBER, -- := FND_API.G_MISS_NUM,
165 Px_Ipa_Object_Version_Number IN OUT NOCOPY NUMBER, -- := FND_API.G_MISS_NUM,
166 Px_pa_Object_Version_Number IN OUT NOCOPY NUMBER, -- := FND_API.G_MISS_NUM,
167 p_form_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
168 p_block IN VARCHAR2 := FND_API.G_MISS_CHAR,
169 x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
170 x_ext_attrib_values_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
171 x_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
172 x_party_account_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
173 x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
174 x_org_assignments_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
175 x_txn_rec OUT NOCOPY csi_datastructures_pub.transaction_rec,
176 x_asset_assignment_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_tbl,
177 x_ii_relationship_rec OUT NOCOPY csi_datastructures_pub.ii_relationship_rec
178 );
179
180 PROCEDURE Update_Row(
181 p_CUSTOMER_PRODUCT_ID IN NUMBER,
182 P_INSTANCE_PARTY_ID IN NUMBER,
183 p_IP_ACCOUNT_ID IN NUMBER,
184 p_PRICING_ATTRIBUTE_ID IN NUMBER,
185 p_RELATIONSHIP_ID IN NUMBER,
186 p_CUSTOMER_ID IN NUMBER,
187 p_INVENTORY_ITEM_ID IN NUMBER,
188 p_LOT_NUMBER IN VARCHAR2,
189 p_CREATED_MANUALLY_FLAG IN VARCHAR2,
190 p_MOST_RECENT_FLAG IN VARCHAR2,
191 p_REVISION IN VARCHAR2,
192 p_CURRENT_SERIAL_NUMBER IN VARCHAR2,
193 p_TYPE_CODE IN VARCHAR2,
194 p_SYSTEM_ID IN NUMBER,
195 p_PRODUCT_AGREEMENT_ID IN NUMBER,
196 p_INSTALLATION_DATE IN DATE,
197 p_ORIGINAL_ORDER_LINE_ID IN NUMBER,
198 p_ORIGINAL_LINE_SERV_DETAIL_ID IN NUMBER,
199 p_ORIGINAL_NET_AMOUNT IN NUMBER,
200 p_SHIP_TO_SITE_USE_ID IN NUMBER,
201 p_BILL_TO_SITE_USE_ID IN NUMBER,
202 p_INSTALL_SITE_USE_ID IN NUMBER,
203 p_QUANTITY IN NUMBER,
204 p_SHIPPED_FLAG IN VARCHAR2,
205 p_DELIVERED_FLAG IN VARCHAR2,
206 p_UNIT_OF_MEASURE_CODE IN VARCHAR2,
207 p_PARENT_CP_ID IN NUMBER,
208 p_CUSTOMER_PRODUCT_STATUS_ID IN NUMBER,
209 p_SHIPPED_DATE IN DATE,
210 p_ORG_ID IN NUMBER,
211 p_REFERENCE_NUMBER IN NUMBER,
212 p_RETURN_BY_DATE IN DATE,
213 p_ACTUAL_RETURNED_DATE IN DATE,
214 p_RMA_LINE_ID IN NUMBER,
215 p_SPLIT_FLAG IN VARCHAR2,
216 p_PROJECT_ID IN NUMBER,
217 p_TASK_ID IN NUMBER,
218 p_CONFIG_ENABLED_FLAG IN VARCHAR2,
219 p_CONFIG_START_DATE IN DATE,
220 p_CONFIG_END_DATE IN DATE,
221 p_CONFIG_ROOT_ID IN NUMBER,
222 p_CONFIG_PARENT_ID IN NUMBER,
223 p_CONFIG_TYPE IN VARCHAR2,
224 p_PLATFORM_VERSION_ID IN NUMBER,
225 p_START_DATE_ACTIVE IN DATE,
226 p_END_DATE_ACTIVE IN DATE,
227 p_MERCHANT_VIEW_FLAG IN VARCHAR2,
228 p_CUSTOMER_VIEW_FLAG IN VARCHAR2,
229 p_ATTRIBUTE1 IN VARCHAR2,
230 p_ATTRIBUTE2 IN VARCHAR2,
231 p_ATTRIBUTE3 IN VARCHAR2,
232 p_ATTRIBUTE4 IN VARCHAR2,
233 p_ATTRIBUTE5 IN VARCHAR2,
234 p_ATTRIBUTE6 IN VARCHAR2,
235 p_ATTRIBUTE7 IN VARCHAR2,
236 p_ATTRIBUTE8 IN VARCHAR2,
237 p_ATTRIBUTE9 IN VARCHAR2,
238 p_ATTRIBUTE10 IN VARCHAR2,
239 p_ATTRIBUTE11 IN VARCHAR2,
240 p_ATTRIBUTE12 IN VARCHAR2,
241 p_ATTRIBUTE13 IN VARCHAR2,
242 p_ATTRIBUTE14 IN VARCHAR2,
243 p_ATTRIBUTE15 IN VARCHAR2,
244 p_CONTEXT IN VARCHAR2,
245 p_COMMENTS IN VARCHAR2,
246 p_PRICING_CONTEXT IN VARCHAR2,
247 p_PRICING_ATTRIBUTE1 IN VARCHAR2,
248 p_PRICING_ATTRIBUTE2 IN VARCHAR2,
249 p_PRICING_ATTRIBUTE3 IN VARCHAR2,
250 p_PRICING_ATTRIBUTE4 IN VARCHAR2,
251 p_PRICING_ATTRIBUTE5 IN VARCHAR2,
252 p_PRICING_ATTRIBUTE6 IN VARCHAR2,
253 p_PRICING_ATTRIBUTE7 IN VARCHAR2,
254 p_PRICING_ATTRIBUTE8 IN VARCHAR2,
255 p_PRICING_ATTRIBUTE9 IN VARCHAR2,
256 p_PRICING_ATTRIBUTE10 IN VARCHAR2,
257 p_PRICING_ATTRIBUTE11 IN VARCHAR2,
258 p_PRICING_ATTRIBUTE12 IN VARCHAR2,
259 p_PRICING_ATTRIBUTE13 IN VARCHAR2,
260 p_PRICING_ATTRIBUTE14 IN VARCHAR2,
261 p_PRICING_ATTRIBUTE15 IN VARCHAR2,
262 p_PRICING_ATTRIBUTE16 IN VARCHAR2,
263 p_PRICING_ATTRIBUTE17 IN VARCHAR2,
264 p_PRICING_ATTRIBUTE18 IN VARCHAR2,
265 p_PRICING_ATTRIBUTE19 IN VARCHAR2,
266 p_PRICING_ATTRIBUTE20 IN VARCHAR2,
267 p_PRICING_ATTRIBUTE21 IN VARCHAR2,
268 p_PRICING_ATTRIBUTE22 IN VARCHAR2,
269 p_PRICING_ATTRIBUTE23 IN VARCHAR2,
270 p_PRICING_ATTRIBUTE24 IN VARCHAR2,
274 p_PRICING_ATTRIBUTE28 IN VARCHAR2,
271 p_PRICING_ATTRIBUTE25 IN VARCHAR2,
272 p_PRICING_ATTRIBUTE26 IN VARCHAR2,
273 p_PRICING_ATTRIBUTE27 IN VARCHAR2,
275 p_PRICING_ATTRIBUTE29 IN VARCHAR2,
276 p_PRICING_ATTRIBUTE30 IN VARCHAR2,
277 p_PRICING_ATTRIBUTE31 IN VARCHAR2,
278 p_PRICING_ATTRIBUTE32 IN VARCHAR2,
279 p_PRICING_ATTRIBUTE33 IN VARCHAR2,
280 p_PRICING_ATTRIBUTE34 IN VARCHAR2,
281 p_PRICING_ATTRIBUTE35 IN VARCHAR2,
282 p_PRICING_ATTRIBUTE36 IN VARCHAR2,
283 p_PRICING_ATTRIBUTE37 IN VARCHAR2,
284 p_PRICING_ATTRIBUTE38 IN VARCHAR2,
285 p_PRICING_ATTRIBUTE39 IN VARCHAR2,
286 p_PRICING_ATTRIBUTE40 IN VARCHAR2,
287 p_PRICING_ATTRIBUTE41 IN VARCHAR2,
288 p_PRICING_ATTRIBUTE42 IN VARCHAR2,
289 p_PRICING_ATTRIBUTE43 IN VARCHAR2,
290 p_PRICING_ATTRIBUTE44 IN VARCHAR2,
291 p_PRICING_ATTRIBUTE45 IN VARCHAR2,
292 p_PRICING_ATTRIBUTE46 IN VARCHAR2,
293 p_PRICING_ATTRIBUTE47 IN VARCHAR2,
294 p_PRICING_ATTRIBUTE48 IN VARCHAR2,
295 p_PRICING_ATTRIBUTE49 IN VARCHAR2,
296 p_PRICING_ATTRIBUTE50 IN VARCHAR2,
297 p_PRICING_ATTRIBUTE51 IN VARCHAR2,
298 p_PRICING_ATTRIBUTE52 IN VARCHAR2,
299 p_PRICING_ATTRIBUTE53 IN VARCHAR2,
300 p_PRICING_ATTRIBUTE54 IN VARCHAR2,
301 p_PRICING_ATTRIBUTE55 IN VARCHAR2,
302 p_PRICING_ATTRIBUTE56 IN VARCHAR2,
303 p_PRICING_ATTRIBUTE57 IN VARCHAR2,
304 p_PRICING_ATTRIBUTE58 IN VARCHAR2,
305 p_PRICING_ATTRIBUTE59 IN VARCHAR2,
306 p_PRICING_ATTRIBUTE60 IN VARCHAR2,
307 p_PRICING_ATTRIBUTE61 IN VARCHAR2,
308 p_PRICING_ATTRIBUTE62 IN VARCHAR2,
309 p_PRICING_ATTRIBUTE63 IN VARCHAR2,
310 p_PRICING_ATTRIBUTE64 IN VARCHAR2,
311 p_PRICING_ATTRIBUTE65 IN VARCHAR2,
312 p_PRICING_ATTRIBUTE66 IN VARCHAR2,
313 p_PRICING_ATTRIBUTE67 IN VARCHAR2,
314 p_PRICING_ATTRIBUTE68 IN VARCHAR2,
315 p_PRICING_ATTRIBUTE69 IN VARCHAR2,
316 p_PRICING_ATTRIBUTE70 IN VARCHAR2,
317 p_PRICING_ATTRIBUTE71 IN VARCHAR2,
318 p_PRICING_ATTRIBUTE72 IN VARCHAR2,
319 p_PRICING_ATTRIBUTE73 IN VARCHAR2,
320 p_PRICING_ATTRIBUTE74 IN VARCHAR2,
321 p_PRICING_ATTRIBUTE75 IN VARCHAR2,
322 p_PRICING_ATTRIBUTE76 IN VARCHAR2,
323 p_PRICING_ATTRIBUTE77 IN VARCHAR2,
324 p_PRICING_ATTRIBUTE78 IN VARCHAR2,
325 p_PRICING_ATTRIBUTE79 IN VARCHAR2,
326 p_PRICING_ATTRIBUTE80 IN VARCHAR2,
327 p_PRICING_ATTRIBUTE81 IN VARCHAR2,
328 p_PRICING_ATTRIBUTE82 IN VARCHAR2,
329 p_PRICING_ATTRIBUTE83 IN VARCHAR2,
330 p_PRICING_ATTRIBUTE84 IN VARCHAR2,
331 p_PRICING_ATTRIBUTE85 IN VARCHAR2,
332 p_PRICING_ATTRIBUTE86 IN VARCHAR2,
333 p_PRICING_ATTRIBUTE87 IN VARCHAR2,
334 p_PRICING_ATTRIBUTE88 IN VARCHAR2,
335 p_PRICING_ATTRIBUTE89 IN VARCHAR2,
336 p_PRICING_ATTRIBUTE90 IN VARCHAR2,
337 p_PRICING_ATTRIBUTE91 IN VARCHAR2,
338 p_PRICING_ATTRIBUTE92 IN VARCHAR2,
339 p_PRICING_ATTRIBUTE93 IN VARCHAR2,
340 p_PRICING_ATTRIBUTE94 IN VARCHAR2,
341 p_PRICING_ATTRIBUTE95 IN VARCHAR2,
342 p_PRICING_ATTRIBUTE96 IN VARCHAR2,
343 p_PRICING_ATTRIBUTE97 IN VARCHAR2,
344 p_PRICING_ATTRIBUTE98 IN VARCHAR2,
345 p_PRICING_ATTRIBUTE99 IN VARCHAR2,
346 p_PRICING_ATTRIBUTE100 IN VARCHAR2,
347 px_cp_object_version_number IN OUT NOCOPY NUMBER,
348 px_ip_object_version_number IN OUT NOCOPY NUMBER,
349 px_ipa_object_version_number IN OUT NOCOPY NUMBER,
350 px_pa_object_version_number IN OUT NOCOPY NUMBER,
351 p_form_mode IN VARCHAR2,
352 p_block IN VARCHAR2,
353 x_return_status OUT NOCOPY VARCHAR2,
354 x_msg_count OUT NOCOPY NUMBER,
355 x_msg_data OUT NOCOPY VARCHAR2 );
356
357 PROCEDURE Lock_Row(
358 p_CUSTOMER_PRODUCT_ID IN NUMBER,
359 P_INSTANCE_PARTY_ID IN NUMBER,
360 P_IP_ACCOUNT_ID IN NUMBER,
361 P_PRICING_ATTRIBUTE_ID IN NUMBER,
362 P_INSTANCE_OU_ID IN NUMBER,
363 P_RELATIONSHIP_ID IN NUMBER,
364 p_CUSTOMER_ID IN NUMBER,
365 p_INVENTORY_ITEM_ID IN NUMBER,
366 p_LOT_NUMBER IN VARCHAR2,
367 p_CREATED_MANUALLY_FLAG IN VARCHAR2,
368 p_MOST_RECENT_FLAG IN VARCHAR2,
369 p_CURRENT_CP_REVISION_ID IN NUMBER,
370 p_REVISION IN VARCHAR2,
371 p_CURRENT_SERIAL_NUMBER IN VARCHAR2,
372 p_TYPE_CODE IN VARCHAR2,
373 p_SYSTEM_ID IN NUMBER,
374 p_PRODUCT_AGREEMENT_ID IN NUMBER,
375 p_INSTALLATION_DATE IN DATE,
376 p_ORIGINAL_ORDER_LINE_ID IN NUMBER,
377 p_ORIGINAL_LINE_SERV_DETAIL_ID IN NUMBER,
378 p_ORIGINAL_NET_AMOUNT IN NUMBER,
379 p_SHIP_TO_SITE_USE_ID IN NUMBER,
380 p_BILL_TO_SITE_USE_ID IN NUMBER,
381 p_INSTALL_SITE_USE_ID IN NUMBER,
382 p_QUANTITY IN NUMBER,
383 p_SHIPPED_FLAG IN VARCHAR2,
384 p_DELIVERED_FLAG IN VARCHAR2,
385 p_UNIT_OF_MEASURE_CODE IN VARCHAR2,
386 p_PARENT_CP_ID IN NUMBER,
387 p_CUSTOMER_PRODUCT_STATUS_ID IN NUMBER,
388 p_SHIPPED_DATE IN DATE,
389 p_ORG_ID IN NUMBER,
390 p_REFERENCE_NUMBER IN NUMBER,
391 p_RETURN_BY_DATE IN DATE,
392 p_ACTUAL_RETURNED_DATE IN DATE,
393 p_RMA_LINE_ID IN NUMBER,
394 p_SPLIT_FLAG IN VARCHAR2,
395 p_PROJECT_ID IN NUMBER,
396 p_TASK_ID IN NUMBER,
397 p_CONFIG_ENABLED_FLAG IN VARCHAR2,
398 p_CONFIG_START_DATE IN DATE,
399 p_CONFIG_END_DATE IN DATE,
400 p_CONFIG_ROOT_ID IN NUMBER,
401 p_CONFIG_PARENT_ID IN NUMBER,
402 p_CONFIG_TYPE IN VARCHAR2,
403 p_PLATFORM_VERSION_ID IN NUMBER,
404 p_START_DATE_ACTIVE IN DATE,
405 p_END_DATE_ACTIVE IN DATE,
406 p_MERCHANT_VIEW_FLAG IN VARCHAR2,
407 p_CUSTOMER_VIEW_FLAG IN VARCHAR2,
408 p_ATTRIBUTE1 IN VARCHAR2,
409 p_ATTRIBUTE2 IN VARCHAR2,
410 p_ATTRIBUTE3 IN VARCHAR2,
411 p_ATTRIBUTE4 IN VARCHAR2,
412 p_ATTRIBUTE5 IN VARCHAR2,
413 p_ATTRIBUTE6 IN VARCHAR2,
414 p_ATTRIBUTE7 IN VARCHAR2,
415 p_ATTRIBUTE8 IN VARCHAR2,
416 p_ATTRIBUTE9 IN VARCHAR2,
417 p_ATTRIBUTE10 IN VARCHAR2,
418 p_ATTRIBUTE11 IN VARCHAR2,
422 p_ATTRIBUTE15 IN VARCHAR2,
419 p_ATTRIBUTE12 IN VARCHAR2,
420 p_ATTRIBUTE13 IN VARCHAR2,
421 p_ATTRIBUTE14 IN VARCHAR2,
423 p_CONTEXT IN VARCHAR2,
424 p_PRICING_CONTEXT IN VARCHAR2,
425 p_PRICING_ATTRIBUTE1 IN VARCHAR2,
426 p_PRICING_ATTRIBUTE2 IN VARCHAR2,
427 p_PRICING_ATTRIBUTE3 IN VARCHAR2,
428 p_PRICING_ATTRIBUTE4 IN VARCHAR2,
429 p_PRICING_ATTRIBUTE5 IN VARCHAR2,
430 p_PRICING_ATTRIBUTE6 IN VARCHAR2,
431 p_PRICING_ATTRIBUTE7 IN VARCHAR2,
432 p_PRICING_ATTRIBUTE8 IN VARCHAR2,
433 p_PRICING_ATTRIBUTE9 IN VARCHAR2,
434 p_PRICING_ATTRIBUTE10 IN VARCHAR2,
435 p_PRICING_ATTRIBUTE11 IN VARCHAR2,
436 p_PRICING_ATTRIBUTE12 IN VARCHAR2,
437 p_PRICING_ATTRIBUTE13 IN VARCHAR2,
438 p_PRICING_ATTRIBUTE14 IN VARCHAR2,
439 p_PRICING_ATTRIBUTE15 IN VARCHAR2,
440 p_PRICING_ATTRIBUTE16 IN VARCHAR2,
441 p_PRICING_ATTRIBUTE17 IN VARCHAR2,
442 p_PRICING_ATTRIBUTE18 IN VARCHAR2,
443 p_PRICING_ATTRIBUTE19 IN VARCHAR2,
444 p_PRICING_ATTRIBUTE20 IN VARCHAR2,
445 p_PRICING_ATTRIBUTE21 IN VARCHAR2,
446 p_PRICING_ATTRIBUTE22 IN VARCHAR2,
447 p_PRICING_ATTRIBUTE23 IN VARCHAR2,
448 p_PRICING_ATTRIBUTE24 IN VARCHAR2,
449 p_PRICING_ATTRIBUTE25 IN VARCHAR2,
450 p_PRICING_ATTRIBUTE26 IN VARCHAR2,
451 p_PRICING_ATTRIBUTE27 IN VARCHAR2,
452 p_PRICING_ATTRIBUTE28 IN VARCHAR2,
453 p_PRICING_ATTRIBUTE29 IN VARCHAR2,
454 p_PRICING_ATTRIBUTE30 IN VARCHAR2,
455 p_PRICING_ATTRIBUTE31 IN VARCHAR2,
456 p_PRICING_ATTRIBUTE32 IN VARCHAR2,
457 p_PRICING_ATTRIBUTE33 IN VARCHAR2,
458 p_PRICING_ATTRIBUTE34 IN VARCHAR2,
459 p_PRICING_ATTRIBUTE35 IN VARCHAR2,
460 p_PRICING_ATTRIBUTE36 IN VARCHAR2,
461 p_PRICING_ATTRIBUTE37 IN VARCHAR2,
462 p_PRICING_ATTRIBUTE38 IN VARCHAR2,
463 p_PRICING_ATTRIBUTE39 IN VARCHAR2,
464 p_PRICING_ATTRIBUTE40 IN VARCHAR2,
465 p_PRICING_ATTRIBUTE41 IN VARCHAR2,
466 p_PRICING_ATTRIBUTE42 IN VARCHAR2,
467 p_PRICING_ATTRIBUTE43 IN VARCHAR2,
468 p_PRICING_ATTRIBUTE44 IN VARCHAR2,
469 p_PRICING_ATTRIBUTE45 IN VARCHAR2,
470 p_PRICING_ATTRIBUTE46 IN VARCHAR2,
471 p_PRICING_ATTRIBUTE47 IN VARCHAR2,
472 p_PRICING_ATTRIBUTE48 IN VARCHAR2,
473 p_PRICING_ATTRIBUTE49 IN VARCHAR2,
474 p_PRICING_ATTRIBUTE50 IN VARCHAR2,
475 p_PRICING_ATTRIBUTE51 IN VARCHAR2,
476 p_PRICING_ATTRIBUTE52 IN VARCHAR2,
477 p_PRICING_ATTRIBUTE53 IN VARCHAR2,
478 p_PRICING_ATTRIBUTE54 IN VARCHAR2,
479 p_PRICING_ATTRIBUTE55 IN VARCHAR2,
480 p_PRICING_ATTRIBUTE56 IN VARCHAR2,
481 p_PRICING_ATTRIBUTE57 IN VARCHAR2,
482 p_PRICING_ATTRIBUTE58 IN VARCHAR2,
483 p_PRICING_ATTRIBUTE59 IN VARCHAR2,
484 p_PRICING_ATTRIBUTE60 IN VARCHAR2,
485 p_PRICING_ATTRIBUTE61 IN VARCHAR2,
486 p_PRICING_ATTRIBUTE62 IN VARCHAR2,
487 p_PRICING_ATTRIBUTE63 IN VARCHAR2,
488 p_PRICING_ATTRIBUTE64 IN VARCHAR2,
489 p_PRICING_ATTRIBUTE65 IN VARCHAR2,
490 p_PRICING_ATTRIBUTE66 IN VARCHAR2,
491 p_PRICING_ATTRIBUTE67 IN VARCHAR2,
492 p_PRICING_ATTRIBUTE68 IN VARCHAR2,
493 p_PRICING_ATTRIBUTE69 IN VARCHAR2,
494 p_PRICING_ATTRIBUTE70 IN VARCHAR2,
495 p_PRICING_ATTRIBUTE71 IN VARCHAR2,
496 p_PRICING_ATTRIBUTE72 IN VARCHAR2,
497 p_PRICING_ATTRIBUTE73 IN VARCHAR2,
498 p_PRICING_ATTRIBUTE74 IN VARCHAR2,
499 p_PRICING_ATTRIBUTE75 IN VARCHAR2,
500 p_PRICING_ATTRIBUTE76 IN VARCHAR2,
501 p_PRICING_ATTRIBUTE77 IN VARCHAR2,
502 p_PRICING_ATTRIBUTE78 IN VARCHAR2,
503 p_PRICING_ATTRIBUTE79 IN VARCHAR2,
504 p_PRICING_ATTRIBUTE80 IN VARCHAR2,
505 p_PRICING_ATTRIBUTE81 IN VARCHAR2,
506 p_PRICING_ATTRIBUTE82 IN VARCHAR2,
507 p_PRICING_ATTRIBUTE83 IN VARCHAR2,
508 p_PRICING_ATTRIBUTE84 IN VARCHAR2,
509 p_PRICING_ATTRIBUTE85 IN VARCHAR2,
510 p_PRICING_ATTRIBUTE86 IN VARCHAR2,
511 p_PRICING_ATTRIBUTE87 IN VARCHAR2,
512 p_PRICING_ATTRIBUTE88 IN VARCHAR2,
513 p_PRICING_ATTRIBUTE89 IN VARCHAR2,
514 p_PRICING_ATTRIBUTE90 IN VARCHAR2,
515 p_PRICING_ATTRIBUTE91 IN VARCHAR2,
516 p_PRICING_ATTRIBUTE92 IN VARCHAR2,
517 p_PRICING_ATTRIBUTE93 IN VARCHAR2,
518 p_PRICING_ATTRIBUTE94 IN VARCHAR2,
519 p_PRICING_ATTRIBUTE95 IN VARCHAR2,
520 p_PRICING_ATTRIBUTE96 IN VARCHAR2,
521 p_PRICING_ATTRIBUTE97 IN VARCHAR2,
522 p_PRICING_ATTRIBUTE98 IN VARCHAR2,
523 p_PRICING_ATTRIBUTE99 IN VARCHAR2,
524 p_PRICING_ATTRIBUTE100 IN VARCHAR2,
525 p_COMMENTS IN VARCHAR2
526 );
527 PROCEDURE Split_Product
528 (
529 p_api_version IN NUMBER,
530 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
531 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
532 x_return_status OUT NOCOPY VARCHAR2,
533 x_msg_count OUT NOCOPY NUMBER,
534 x_msg_data OUT NOCOPY VARCHAR2,
535 p_cp_id IN NUMBER,
536 p_qty1 IN NUMBER,
537 p_qty2 IN NUMBER,
538 p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
539 p_reason_code IN VARCHAR2,
540 x_new_parent_cp_id OUT NOCOPY NUMBER
541 ) ;
542 PROCEDURE Split_Product
543 (
544 p_api_version IN NUMBER,
545 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
546 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
547 x_return_status OUT NOCOPY VARCHAR2,
548 x_msg_count OUT NOCOPY NUMBER,
549 x_msg_data OUT NOCOPY VARCHAR2,
550 p_cp_id IN NUMBER,
551 p_reason_code IN VARCHAR2,
552 p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
553 );
554
555 END CSI_CUSTOMER_PRODUCTS_PKG;
[Home] [Help]