[Home] [Help]
PACKAGE BODY: APPS.CS_CP_SERVICES_PKG
Source
1 PACKAGE BODY CS_CP_SERVICES_PKG as
2 /* $Header: csxsicsb.pls 115.1 99/07/16 09:08:48 porting s $ */
3
4 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
5 X_Cp_Service_Id NUMBER,
6 X_Customer_Product_Id NUMBER,
7 X_Service_Inventory_Item_Id NUMBER,
8 X_Service_Manufacturing_Org_Id NUMBER,
9 X_Start_Date_Active DATE,
10 X_End_Date_Active DATE,
11 X_Original_Start_Date DATE,
12 X_Original_End_Date DATE,
13 X_Service_Date_Change VARCHAR2,
14 X_Status_Code VARCHAR2,
15 X_Last_Cp_Service_Txn_Id NUMBER,
16 X_Invoice_Flag VARCHAR2,
17 X_Coverage_Schedule_Id NUMBER,
18 X_Prorate_Flag VARCHAR2,
19 X_Duration_Quantity NUMBER,
20 X_Unit_Of_Measure_Code VARCHAR2,
21 X_Starting_Delay NUMBER,
22 X_Bill_To_Site_Use_Id NUMBER,
23 X_Bill_To_Contact_Id NUMBER,
24 X_Service_Txn_Avail_Code VARCHAR2,
25 X_Next_Pm_Visit_Date DATE,
26 X_Pm_Visits_Completed NUMBER,
27 X_Last_Pm_Visit_Date DATE,
28 X_Pm_Schedule_Id NUMBER,
29 X_Pm_Schedule_Flag VARCHAR2,
30 X_Current_Max_Schedule_Date DATE,
31 X_Price_List_Id NUMBER,
32 X_Pricing_Attribute1 VARCHAR2,
33 X_Pricing_Attribute2 VARCHAR2,
34 X_Pricing_Attribute3 VARCHAR2,
35 X_Pricing_Attribute4 VARCHAR2,
36 X_Pricing_Attribute5 VARCHAR2,
37 X_Pricing_Attribute6 VARCHAR2,
38 X_Pricing_Attribute7 VARCHAR2,
39 X_Pricing_Attribute8 VARCHAR2,
40 X_Pricing_Attribute9 VARCHAR2,
41 X_Pricing_Attribute10 VARCHAR2,
42 X_Pricing_Attribute11 VARCHAR2,
43 X_Pricing_Attribute12 VARCHAR2,
44 X_Pricing_Attribute13 VARCHAR2,
45 X_Pricing_Attribute14 VARCHAR2,
46 X_Pricing_Attribute15 VARCHAR2,
47 X_Pricing_Context VARCHAR2,
48 X_Attribute1 VARCHAR2,
49 X_Attribute2 VARCHAR2,
50 X_Attribute3 VARCHAR2,
51 X_Attribute4 VARCHAR2,
52 X_Attribute5 VARCHAR2,
53 X_Attribute6 VARCHAR2,
54 X_Attribute7 VARCHAR2,
55 X_Attribute8 VARCHAR2,
56 X_Attribute9 VARCHAR2,
57 X_Attribute10 VARCHAR2,
58 X_Attribute11 VARCHAR2,
59 X_Attribute12 VARCHAR2,
60 X_Attribute13 VARCHAR2,
61 X_Attribute14 VARCHAR2,
62 X_Attribute15 VARCHAR2,
63 X_Context VARCHAR2,
64 X_Service_Order_Type VARCHAR2,
65 X_Invoice_Count NUMBER,
66 X_Currency_Code VARCHAR2,
67 X_Conversion_Type VARCHAR2,
68 X_Conversion_Rate NUMBER,
69 X_Conversion_Date DATE,
70 X_Original_Service_Line_Id NUMBER
71
72 ) IS
73 CURSOR C IS
74 SELECT *
75 FROM cs_cp_services
76 WHERE rowid = X_Rowid
77 FOR UPDATE of Cp_Service_Id NOWAIT;
78 Recinfo C%ROWTYPE;
79 BEGIN
80 OPEN C;
81 FETCH C INTO Recinfo;
82 if (C%NOTFOUND) then
83 CLOSE C;
84 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
85 APP_EXCEPTION.Raise_Exception;
86 end if;
87 CLOSE C;
88 if (
89
90 (Recinfo.cp_service_id = X_Cp_Service_Id)
91 AND (Recinfo.customer_product_id = X_Customer_Product_Id)
92 AND (Recinfo.service_inventory_item_id = X_Service_Inventory_Item_Id)
93 AND (Recinfo.service_manufacturing_org_id = X_Service_Manufacturing_Org_Id)
94 AND ( (trunc(Recinfo.start_date_active) =
95 trunc(X_Start_Date_Active))
96 OR ( (Recinfo.start_date_active IS NULL)
97 AND (X_Start_Date_Active IS NULL)))
98 AND ( (trunc(Recinfo.end_date_active) = trunc(X_End_Date_Active))
99 OR ( (Recinfo.end_date_active IS NULL)
100 AND (X_End_Date_Active IS NULL)))
101 AND ( (Recinfo.Original_Start_Date = X_Original_Start_Date)
102 OR ( (Recinfo.Original_Start_Date IS NULL)
103 AND (X_Original_Start_Date IS NULL)))
104 AND ( (Recinfo.Original_End_Date = X_Original_End_Date)
105 OR ( (Recinfo.Original_End_Date IS NULL)
106 AND (X_Original_End_Date IS NULL)))
107 AND ( (Recinfo.service_date_change = X_Service_Date_Change)
108 OR ( (Recinfo.service_date_change IS NULL)
109 AND (X_Service_Date_Change IS NULL)))
110 AND ( (Recinfo.status_code = X_Status_Code)
111 OR ( (Recinfo.status_code IS NULL)
112 AND (X_Status_Code IS NULL)))
113 AND (Recinfo.last_cp_service_transaction_id = X_Last_Cp_Service_Txn_Id)
114 AND ( (Recinfo.invoice_flag = X_Invoice_Flag)
115 OR ( (Recinfo.invoice_flag IS NULL)
116 AND (X_Invoice_Flag IS NULL)))
117 AND ( (Recinfo.coverage_schedule_id = X_Coverage_Schedule_Id)
118 OR ( (Recinfo.coverage_schedule_id IS NULL)
119 AND (X_Coverage_Schedule_Id IS NULL)))
120 AND ( (Recinfo.prorate_flag = X_Prorate_Flag)
121 OR ( (Recinfo.prorate_flag IS NULL)
122 AND (X_Prorate_Flag IS NULL)))
123 AND ( (Recinfo.duration_quantity = X_Duration_Quantity)
124 OR ( (Recinfo.duration_quantity IS NULL)
125 AND (X_Duration_Quantity IS NULL)))
126 AND ( (Recinfo.unit_of_measure_code = X_Unit_Of_Measure_Code)
127 OR ( (Recinfo.unit_of_measure_code IS NULL)
128 AND (X_Unit_Of_Measure_Code IS NULL)))
129 AND ( (Recinfo.starting_delay = X_Starting_Delay)
130 OR ( (Recinfo.starting_delay IS NULL)
131 AND (X_Starting_Delay IS NULL)))
132 AND ( (Recinfo.bill_to_site_use_id = X_Bill_To_Site_Use_Id)
133 OR ( (Recinfo.bill_to_site_use_id IS NULL)
134 AND (X_Bill_To_Site_Use_Id IS NULL)))
135 AND ( (Recinfo.bill_to_contact_id = X_Bill_To_Contact_Id)
136 OR ( (Recinfo.bill_to_contact_id IS NULL)
137 AND (X_Bill_To_Contact_Id IS NULL)))
138 AND ( (Recinfo.service_txn_availability_code = X_Service_Txn_Avail_Code)
139 OR ( (Recinfo.service_txn_availability_code IS NULL)
140 AND (X_Service_Txn_Avail_Code IS NULL)))
141 AND ( (Recinfo.next_pm_visit_date = X_Next_Pm_Visit_Date)
142 OR ( (Recinfo.next_pm_visit_date IS NULL)
143 AND (X_Next_Pm_Visit_Date IS NULL)))
144 AND ( (Recinfo.pm_visits_completed = X_Pm_Visits_Completed)
145 OR ( (Recinfo.pm_visits_completed IS NULL)
146 AND (X_Pm_Visits_Completed IS NULL)))
147 AND ( (Recinfo.last_pm_visit_date = X_Last_Pm_Visit_Date)
148 OR ( (Recinfo.last_pm_visit_date IS NULL)
149 AND (X_Last_Pm_Visit_Date IS NULL)))
150 AND ( (Recinfo.pm_schedule_id = X_Pm_Schedule_Id)
151 OR ( (Recinfo.pm_schedule_id IS NULL)
152 AND (X_Pm_Schedule_Id IS NULL)))
153 AND ( (Recinfo.pm_schedule_flag = X_Pm_Schedule_Flag)
154 OR ( (Recinfo.pm_schedule_flag IS NULL)
155 AND (X_Pm_Schedule_Flag IS NULL)))
156 AND ( (Recinfo.current_max_schedule_date = X_Current_Max_Schedule_Date)
157 OR ( (Recinfo.current_max_schedule_date IS NULL)
158 AND (X_Current_Max_Schedule_Date IS NULL)))
159 AND ( (Recinfo.price_list_id = X_Price_List_Id)
160 OR ( (Recinfo.price_list_id IS NULL)
161 AND (X_Price_List_Id IS NULL))) ) then
162 null;
163 else
164 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
165 APP_EXCEPTION.RAISE_EXCEPTION;
166 end if;
167
168 if (
169 ( (Recinfo.pricing_attribute1 = X_Pricing_Attribute1)
170 OR ( (Recinfo.pricing_attribute1 IS NULL)
171 AND (X_Pricing_Attribute1 IS NULL)))
172 AND ( (Recinfo.pricing_attribute2 = X_Pricing_Attribute2)
173 OR ( (Recinfo.pricing_attribute2 IS NULL)
174 AND (X_Pricing_Attribute2 IS NULL)))
175 AND ( (Recinfo.pricing_attribute3 = X_Pricing_Attribute3)
176 OR ( (Recinfo.pricing_attribute3 IS NULL)
177 AND (X_Pricing_Attribute3 IS NULL)))
178 AND ( (Recinfo.pricing_attribute4 = X_Pricing_Attribute4)
179 OR ( (Recinfo.pricing_attribute4 IS NULL)
180 AND (X_Pricing_Attribute4 IS NULL)))
181 AND ( (Recinfo.pricing_attribute5 = X_Pricing_Attribute5)
182 OR ( (Recinfo.pricing_attribute5 IS NULL)
183 AND (X_Pricing_Attribute5 IS NULL)))
184 AND ( (Recinfo.pricing_attribute6 = X_Pricing_Attribute6)
185 OR ( (Recinfo.pricing_attribute6 IS NULL)
186 AND (X_Pricing_Attribute6 IS NULL)))
187 AND ( (Recinfo.pricing_attribute7 = X_Pricing_Attribute7)
188 OR ( (Recinfo.pricing_attribute7 IS NULL)
189 AND (X_Pricing_Attribute7 IS NULL)))
190 AND ( (Recinfo.pricing_attribute8 = X_Pricing_Attribute8)
191 OR ( (Recinfo.pricing_attribute8 IS NULL)
192 AND (X_Pricing_Attribute8 IS NULL)))
193 AND ( (Recinfo.pricing_attribute9 = X_Pricing_Attribute9)
194 OR ( (Recinfo.pricing_attribute9 IS NULL)
195 AND (X_Pricing_Attribute9 IS NULL)))
196 AND ( (Recinfo.pricing_attribute10 = X_Pricing_Attribute10)
197 OR ( (Recinfo.pricing_attribute10 IS NULL)
198 AND (X_Pricing_Attribute10 IS NULL)))
199 AND ( (Recinfo.pricing_attribute11 = X_Pricing_Attribute11)
200 OR ( (Recinfo.pricing_attribute11 IS NULL)
201 AND (X_Pricing_Attribute11 IS NULL)))
202 AND ( (Recinfo.pricing_attribute12 = X_Pricing_Attribute12)
203 OR ( (Recinfo.pricing_attribute12 IS NULL)
204 AND (X_Pricing_Attribute12 IS NULL)))
205 AND ( (Recinfo.pricing_attribute13 = X_Pricing_Attribute13)
206 OR ( (Recinfo.pricing_attribute13 IS NULL)
207 AND (X_Pricing_Attribute13 IS NULL)))
208 AND ( (Recinfo.pricing_attribute14 = X_Pricing_Attribute14)
209 OR ( (Recinfo.pricing_attribute14 IS NULL)
210 AND (X_Pricing_Attribute14 IS NULL)))
211 AND ( (Recinfo.pricing_attribute15 = X_Pricing_Attribute15)
212 OR ( (Recinfo.pricing_attribute15 IS NULL)
213 AND (X_Pricing_Attribute15 IS NULL)))
214 AND ( (Recinfo.pricing_context = X_Pricing_Context)
215 OR ( (Recinfo.pricing_context IS NULL)
216 AND (X_Pricing_Context IS NULL)))
217 AND ( (Recinfo.attribute1 = X_Attribute1)
218 OR ( (Recinfo.attribute1 IS NULL)
219 AND (X_Attribute1 IS NULL)))
220 AND ( (Recinfo.attribute2 = X_Attribute2)
221 OR ( (Recinfo.attribute2 IS NULL)
222 AND (X_Attribute2 IS NULL)))
223 AND ( (Recinfo.attribute3 = X_Attribute3)
224 OR ( (Recinfo.attribute3 IS NULL)
225 AND (X_Attribute3 IS NULL)))
226 AND ( (Recinfo.attribute4 = X_Attribute4)
230 OR ( (Recinfo.attribute5 IS NULL)
227 OR ( (Recinfo.attribute4 IS NULL)
228 AND (X_Attribute4 IS NULL)))
229 AND ( (Recinfo.attribute5 = X_Attribute5)
231 AND (X_Attribute5 IS NULL)))
232 AND ( (Recinfo.attribute6 = X_Attribute6)
233 OR ( (Recinfo.attribute6 IS NULL)
234 AND (X_Attribute6 IS NULL)))
235 AND ( (Recinfo.attribute7 = X_Attribute7)
236 OR ( (Recinfo.attribute7 IS NULL)
237 AND (X_Attribute7 IS NULL)))
238 AND ( (Recinfo.attribute8 = X_Attribute8)
239 OR ( (Recinfo.attribute8 IS NULL)
240 AND (X_Attribute8 IS NULL)))
241 AND ( (Recinfo.attribute9 = X_Attribute9)
242 OR ( (Recinfo.attribute9 IS NULL)
243 AND (X_Attribute9 IS NULL)))
244 AND ( (Recinfo.attribute10 = X_Attribute10)
245 OR ( (Recinfo.attribute10 IS NULL)
246 AND (X_Attribute10 IS NULL)))
247 AND ( (Recinfo.attribute11 = X_Attribute11)
248 OR ( (Recinfo.attribute11 IS NULL)
249 AND (X_Attribute11 IS NULL)))
250 AND ( (Recinfo.attribute12 = X_Attribute12)
251 OR ( (Recinfo.attribute12 IS NULL)
252 AND (X_Attribute12 IS NULL)))
253 AND ( (Recinfo.attribute13 = X_Attribute13)
254 OR ( (Recinfo.attribute13 IS NULL)
255 AND (X_Attribute13 IS NULL)))
256 AND ( (Recinfo.attribute14 = X_Attribute14)
257 OR ( (Recinfo.attribute14 IS NULL)
258 AND (X_Attribute14 IS NULL)))
259 AND ( (Recinfo.attribute15 = X_Attribute15)
260 OR ( (Recinfo.attribute15 IS NULL)
261 AND (X_Attribute15 IS NULL)))
262 AND ( (Recinfo.context = X_Context)
263 OR ( (Recinfo.context IS NULL)
264 AND (X_Context IS NULL))) ) then
265 null;
266 else
267 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
268 APP_EXCEPTION.RAISE_EXCEPTION;
269 end if;
270
271
272 if (
273 ( (Recinfo.service_order_type = X_Service_Order_Type)
274 OR ( (Recinfo.service_order_type IS NULL)
275 AND (X_Service_Order_Type IS NULL)))
276 AND ( (Recinfo.invoice_count = X_Invoice_Count)
277 OR ( (Recinfo.invoice_count IS NULL)
278 AND (X_Invoice_Count IS NULL)))
279 AND ( (Recinfo.currency_code = X_Currency_Code)
280 OR ( (Recinfo.currency_code IS NULL)
281 AND (X_Currency_Code IS NULL)))
282 AND ( (Recinfo.conversion_type = X_Conversion_Type)
283 OR ( (Recinfo.conversion_type IS NULL)
284 AND (X_Conversion_Type IS NULL)))
285 AND ( (Recinfo.conversion_rate = X_Conversion_Rate)
286 OR ( (Recinfo.conversion_rate IS NULL)
287 AND (X_Conversion_Rate IS NULL)))
288 AND ( (Recinfo.conversion_date = X_Conversion_Date)
289 OR ( (Recinfo.conversion_date IS NULL)
290 AND (X_Conversion_Date IS NULL)))
291 AND ( (Recinfo.original_service_line_id = X_Original_Service_Line_Id)
292 OR ( (Recinfo.original_service_line_id IS NULL)
293 AND (X_Original_Service_Line_Id IS NULL)))
294
295 ) then
296 return;
297 else
298 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
299 APP_EXCEPTION.RAISE_EXCEPTION;
300 end if;
301 END Lock_Row;
302
303
304 PROCEDURE Update_Row(X_Rowid VARCHAR2,
305 X_Cp_Service_Id NUMBER,
306 X_Last_Update_Date DATE,
307 X_Last_Updated_By NUMBER,
308 X_Last_Update_Login NUMBER,
309 X_Customer_Product_Id NUMBER,
310 X_Service_Inventory_Item_Id NUMBER,
311 X_Service_Manufacturing_Org_Id NUMBER,
312 X_Start_Date_Active DATE,
313 X_End_Date_Active DATE,
314 X_Original_Start_Date DATE,
315 X_Original_End_Date DATE,
316 X_Service_Date_Change VARCHAR2,
317 X_Status_Code VARCHAR2,
318 X_Last_Cp_Service_Txn_Id NUMBER,
319 X_Invoice_Flag VARCHAR2,
320 X_Coverage_Schedule_Id NUMBER,
321 X_Prorate_Flag VARCHAR2,
322 X_Duration_Quantity NUMBER,
323 X_Unit_Of_Measure_Code VARCHAR2,
324 X_Starting_Delay NUMBER,
325 X_Bill_To_Site_Use_Id NUMBER,
326 X_Bill_To_Contact_Id NUMBER,
327 X_Service_Txn_Avail_Code VARCHAR2,
328 X_Next_Pm_Visit_Date DATE,
329 X_Pm_Visits_Completed NUMBER,
330 X_Last_Pm_Visit_Date DATE,
331 X_Pm_Schedule_Id NUMBER,
332 X_Pm_Schedule_Flag VARCHAR2,
333 X_Current_Max_Schedule_Date DATE,
334 X_Price_List_Id NUMBER,
335 X_Pricing_Attribute1 VARCHAR2,
339 X_Pricing_Attribute5 VARCHAR2,
336 X_Pricing_Attribute2 VARCHAR2,
337 X_Pricing_Attribute3 VARCHAR2,
338 X_Pricing_Attribute4 VARCHAR2,
340 X_Pricing_Attribute6 VARCHAR2,
341 X_Pricing_Attribute7 VARCHAR2,
342 X_Pricing_Attribute8 VARCHAR2,
343 X_Pricing_Attribute9 VARCHAR2,
344 X_Pricing_Attribute10 VARCHAR2,
345 X_Pricing_Attribute11 VARCHAR2,
346 X_Pricing_Attribute12 VARCHAR2,
347 X_Pricing_Attribute13 VARCHAR2,
348 X_Pricing_Attribute14 VARCHAR2,
349 X_Pricing_Attribute15 VARCHAR2,
350 X_Pricing_Context VARCHAR2,
351 X_Attribute1 VARCHAR2,
352 X_Attribute2 VARCHAR2,
353 X_Attribute3 VARCHAR2,
354 X_Attribute4 VARCHAR2,
355 X_Attribute5 VARCHAR2,
356 X_Attribute6 VARCHAR2,
357 X_Attribute7 VARCHAR2,
358 X_Attribute8 VARCHAR2,
359 X_Attribute9 VARCHAR2,
360 X_Attribute10 VARCHAR2,
361 X_Attribute11 VARCHAR2,
362 X_Attribute12 VARCHAR2,
363 X_Attribute13 VARCHAR2,
364 X_Attribute14 VARCHAR2,
365 X_Attribute15 VARCHAR2,
366 X_Context VARCHAR2,
367 X_Service_Order_Type VARCHAR2,
368 X_Invoice_Count NUMBER,
369 X_Currency_Code VARCHAR2,
370 X_Conversion_Type VARCHAR2,
371 X_Conversion_Rate NUMBER,
372 X_Conversion_Date DATE,
373 X_Original_Service_Line_Id NUMBER
374
375 ) IS
376 BEGIN
377 UPDATE cs_cp_services
378 SET
379 cp_service_id = X_Cp_Service_Id,
380 last_update_date = X_Last_Update_Date,
381 last_updated_by = X_Last_Updated_By,
382 last_update_login = X_Last_Update_Login,
383 customer_product_id = X_Customer_Product_Id,
384 service_inventory_item_id = X_Service_Inventory_Item_Id,
385 service_manufacturing_org_id = X_Service_Manufacturing_Org_Id,
386 start_date_active = X_Start_Date_Active,
387 end_date_active = X_End_Date_Active,
388 original_start_date = X_Original_Start_Date,
389 original_end_date = X_Original_End_Date,
390 service_date_change = X_Service_Date_Change,
391 status_code = X_Status_Code,
392 last_cp_service_transaction_id = X_Last_Cp_Service_Txn_Id,
393 invoice_flag = X_Invoice_Flag,
394 coverage_schedule_id = X_Coverage_Schedule_Id,
395 prorate_flag = X_Prorate_Flag,
396 duration_quantity = X_Duration_Quantity,
397 unit_of_measure_code = X_Unit_Of_Measure_Code,
398 starting_delay = X_Starting_Delay,
399 bill_to_site_use_id = X_Bill_To_Site_Use_Id,
400 bill_to_contact_id = X_Bill_To_Contact_Id,
401 service_txn_availability_code = X_Service_Txn_Avail_Code,
402 next_pm_visit_date = X_Next_Pm_Visit_Date,
403 pm_visits_completed = X_Pm_Visits_Completed,
404 last_pm_visit_date = X_Last_Pm_Visit_Date,
405 pm_schedule_id = X_Pm_Schedule_Id,
406 pm_schedule_flag = X_Pm_Schedule_Flag,
407 current_max_schedule_date = X_Current_Max_Schedule_Date,
408 price_list_id = X_Price_List_Id,
409 pricing_attribute1 = X_Pricing_Attribute1,
410 pricing_attribute2 = X_Pricing_Attribute2,
411 pricing_attribute3 = X_Pricing_Attribute3,
412 pricing_attribute4 = X_Pricing_Attribute4,
413 pricing_attribute5 = X_Pricing_Attribute5,
414 pricing_attribute6 = X_Pricing_Attribute6,
415 pricing_attribute7 = X_Pricing_Attribute7,
416 pricing_attribute8 = X_Pricing_Attribute8,
417 pricing_attribute9 = X_Pricing_Attribute9,
418 pricing_attribute10 = X_Pricing_Attribute10,
419 pricing_attribute11 = X_Pricing_Attribute11,
420 pricing_attribute12 = X_Pricing_Attribute12,
421 pricing_attribute13 = X_Pricing_Attribute13,
422 pricing_attribute14 = X_Pricing_Attribute14,
423 pricing_attribute15 = X_Pricing_Attribute15,
424 pricing_context = X_Pricing_Context,
425 attribute1 = X_Attribute1,
426 attribute2 = X_Attribute2,
427 attribute3 = X_Attribute3,
428 attribute4 = X_Attribute4,
432 attribute8 = X_Attribute8,
429 attribute5 = X_Attribute5,
430 attribute6 = X_Attribute6,
431 attribute7 = X_Attribute7,
433 attribute9 = X_Attribute9,
434 attribute10 = X_Attribute10,
435 attribute11 = X_Attribute11,
436 attribute12 = X_Attribute12,
437 attribute13 = X_Attribute13,
438 attribute14 = X_Attribute14,
439 attribute15 = X_Attribute15,
440 context = X_Context,
441 service_order_type = X_Service_Order_Type,
442 invoice_count = X_Invoice_Count,
443 currency_code = X_Currency_Code,
444 conversion_type = X_Conversion_Type,
445 conversion_rate = X_Conversion_Rate,
446 conversion_date = X_Conversion_Date,
447 original_service_line_id = X_Original_Service_Line_Id
448 WHERE rowid = X_rowid;
449
450 if (SQL%NOTFOUND) then
451 Raise NO_DATA_FOUND;
452 end if;
453
454 END Update_Row;
455
456
457 END CS_CP_SERVICES_PKG;