[Home] [Help]
PACKAGE BODY: APPS.CN_COMM_LINES_API_PKG
Source
3 -- +======================================================================+
1 PACKAGE BODY CN_COMM_LINES_API_PKG AS
2 /* $Header: cncmapib.pls 120.5.12010000.2 2009/01/28 12:18:27 gmarwah ship $*/
4 -- | Copyright (c) 1998 Oracle Corporation |
5 -- | Redwood Shores, California, USA |
6 -- | All rights reserved. |
7 -- +======================================================================+
8 --
9 -- FILENAME
10 -- cncmapib.pls
11 --
12 -- PURPOSE
13 -- Package Body -- Table Handler for Table CN_COMM_LINES_API
14 --
15 -- NOTES
16 -- This file is generated by tblHandlerGen.pl *** DO NOT MODIFY ***
17 --
18 -- HISTORY
19 -- 19-AUG-2001 Created
20 --
24 -- * -------------------------------------------------------------------------*
21 --
22 -- +======================================================================+
23
25 -- Procedure Name
26 -- Insert_row
27 -- Purpose
28 -- Main insert procedure
29 -- Note
30 -- 1. Primary key should be populated from sequence before call
31 -- this procedure. No refernece to sequence in this procedure.
32 -- 2. All paramaters are IN parameter.
33 -- * -------------------------------------------------------------------------*
34 PROCEDURE insert_row
35 ( p_comm_lines_api_rec IN COMM_LINES_API_REC_TYPE) IS
36
37 l_err VARCHAR2(500);
38
39 BEGIN
40
41 INSERT into CN_COMM_LINES_API_ALL
42 ( SALESREP_ID,
43 PROCESSED_DATE,
44 PROCESSED_PERIOD_ID,
45 TRANSACTION_AMOUNT,
46 TRX_TYPE,
47 REVENUE_CLASS_ID,
48 LOAD_STATUS,
49 ATTRIBUTE_CATEGORY,
50 ATTRIBUTE1,
51 ATTRIBUTE2,
52 ATTRIBUTE3,
53 ATTRIBUTE4,
54 ATTRIBUTE5,
55 ATTRIBUTE6,
56 ATTRIBUTE7,
57 ATTRIBUTE8,
58 ATTRIBUTE9,
59 ATTRIBUTE10,
60 ATTRIBUTE11,
61 ATTRIBUTE12,
62 ATTRIBUTE13,
63 ATTRIBUTE14,
64 ATTRIBUTE15,
65 ATTRIBUTE16,
66 ATTRIBUTE17,
67 ATTRIBUTE18,
68 ATTRIBUTE19,
69 ATTRIBUTE20,
70 ATTRIBUTE21,
71 ATTRIBUTE22,
72 ATTRIBUTE23,
73 ATTRIBUTE24,
74 ATTRIBUTE25,
75 ATTRIBUTE26,
76 ATTRIBUTE27,
77 ATTRIBUTE28,
78 ATTRIBUTE29,
79 ATTRIBUTE30,
80 ATTRIBUTE31,
81 ATTRIBUTE32,
82 ATTRIBUTE33,
83 ATTRIBUTE34,
84 ATTRIBUTE35,
85 ATTRIBUTE36,
86 ATTRIBUTE37,
87 ATTRIBUTE38,
88 ATTRIBUTE39,
89 ATTRIBUTE40,
90 ATTRIBUTE41,
91 ATTRIBUTE42,
92 ATTRIBUTE43,
93 ATTRIBUTE44,
94 ATTRIBUTE45,
95 ATTRIBUTE46,
96 ATTRIBUTE47,
97 ATTRIBUTE48,
98 ATTRIBUTE49,
99 ATTRIBUTE50,
100 ATTRIBUTE51,
101 ATTRIBUTE52,
102 ATTRIBUTE53,
103 ATTRIBUTE54,
104 ATTRIBUTE55,
105 ATTRIBUTE56,
106 ATTRIBUTE57,
107 ATTRIBUTE58,
108 ATTRIBUTE59,
109 ATTRIBUTE60,
110 ATTRIBUTE61,
111 ATTRIBUTE62,
112 ATTRIBUTE63,
113 ATTRIBUTE64,
114 ATTRIBUTE65,
115 ATTRIBUTE66,
116 ATTRIBUTE67,
117 ATTRIBUTE68,
118 ATTRIBUTE69,
119 ATTRIBUTE70,
120 ATTRIBUTE71,
121 ATTRIBUTE72,
122 ATTRIBUTE73,
123 ATTRIBUTE74,
124 ATTRIBUTE75,
125 ATTRIBUTE76,
126 ATTRIBUTE77,
127 ATTRIBUTE78,
128 ATTRIBUTE79,
129 ATTRIBUTE80,
130 ATTRIBUTE81,
131 ATTRIBUTE82,
132 ATTRIBUTE83,
133 ATTRIBUTE84,
134 ATTRIBUTE85,
135 ATTRIBUTE86,
136 ATTRIBUTE87,
137 ATTRIBUTE88,
138 ATTRIBUTE89,
139 ATTRIBUTE90,
140 ATTRIBUTE91,
141 ATTRIBUTE92,
142 ATTRIBUTE93,
143 ATTRIBUTE94,
144 ATTRIBUTE95,
145 ATTRIBUTE96,
146 ATTRIBUTE97,
147 ATTRIBUTE98,
148 ATTRIBUTE99,
149 ATTRIBUTE100,
150 COMM_LINES_API_ID,
151 CONC_BATCH_ID,
152 PROCESS_BATCH_ID,
153 SALESREP_NUMBER,
154 ROLLUP_DATE,
155 SOURCE_DOC_ID,
156 SOURCE_DOC_TYPE,
157 CREATED_BY,
158 CREATION_DATE,
159 LAST_UPDATED_BY,
160 LAST_UPDATE_DATE,
161 LAST_UPDATE_LOGIN,
162 TRANSACTION_CURRENCY_CODE,
163 EXCHANGE_RATE,
164 ACCTD_TRANSACTION_AMOUNT,
165 TRX_ID,
166 TRX_LINE_ID,
167 TRX_SALES_LINE_ID,
168 QUANTITY,
169 SOURCE_TRX_NUMBER,
170 DISCOUNT_PERCENTAGE,
171 MARGIN_PERCENTAGE,
172 SOURCE_TRX_ID,
173 SOURCE_TRX_LINE_ID,
174 SOURCE_TRX_SALES_LINE_ID,
175 NEGATED_FLAG,
176 CUSTOMER_ID,
177 INVENTORY_ITEM_ID,
178 ORDER_NUMBER,
179 BOOKED_DATE,
180 INVOICE_NUMBER,
181 INVOICE_DATE,
182 ADJUST_DATE,
183 ADJUSTED_BY,
184 REVENUE_TYPE,
185 ADJUST_ROLLUP_FLAG,
186 ADJUST_COMMENTS,
187 ADJUST_STATUS,
188 LINE_NUMBER,
189 BILL_TO_ADDRESS_ID,
190 SHIP_TO_ADDRESS_ID,
191 BILL_TO_CONTACT_ID,
192 SHIP_TO_CONTACT_ID,
193 ADJ_COMM_LINES_API_ID,
194 PRE_DEFINED_RC_FLAG,
195 ROLLUP_FLAG,
196 FORECAST_ID,
197 UPSIDE_QUANTITY,
198 UPSIDE_AMOUNT,
199 UOM_CODE,
200 REASON_CODE,
201 TYPE,
202 PRE_PROCESSED_CODE,
203 QUOTA_ID,
204 SRP_PLAN_ASSIGN_ID,
205 ROLE_ID,
206 COMP_GROUP_ID,
210 REVERSAL_HEADER_ID,
207 COMMISSION_AMOUNT,
208 EMPLOYEE_NUMBER,
209 REVERSAL_FLAG,
211 SALES_CHANNEL,
212 OBJECT_VERSION_NUMBER,
213 SPLIT_PCT,
214 SPLIT_STATUS,
215 ORG_ID,
216 TERR_ID,
217 TERR_NAME,
218 PRESERVE_CREDIT_OVERRIDE_FLAG
219 )
220 select
221 DECODE(p_comm_lines_api_rec.SALESREP_ID, FND_API.G_MISS_NUM, NULL,
222 p_comm_lines_api_rec.SALESREP_ID),
223 DECODE(p_comm_lines_api_rec.PROCESSED_DATE, FND_API.G_MISS_DATE, NULL,
224 trunc(p_comm_lines_api_rec.processed_date)),
225 DECODE(p_comm_lines_api_rec.PROCESSED_PERIOD_ID, FND_API.G_MISS_NUM, NULL,
226 p_comm_lines_api_rec.PROCESSED_PERIOD_ID),
227 DECODE(p_comm_lines_api_rec.TRANSACTION_AMOUNT, FND_API.G_MISS_NUM, NULL,
228 p_comm_lines_api_rec.TRANSACTION_AMOUNT),
229 DECODE(p_comm_lines_api_rec.TRX_TYPE, FND_API.G_MISS_CHAR, NULL,
230 p_comm_lines_api_rec.TRX_TYPE),
231 DECODE(p_comm_lines_api_rec.REVENUE_CLASS_ID, FND_API.G_MISS_NUM, NULL,
232 p_comm_lines_api_rec.REVENUE_CLASS_ID),
233 DECODE(p_comm_lines_api_rec.LOAD_STATUS, FND_API.G_MISS_CHAR, NULL,
234 p_comm_lines_api_rec.LOAD_STATUS),
235 DECODE(p_comm_lines_api_rec.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
236 p_comm_lines_api_rec.ATTRIBUTE_CATEGORY),
237 DECODE(p_comm_lines_api_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,
238 p_comm_lines_api_rec.ATTRIBUTE1),
239 DECODE(p_comm_lines_api_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,
240 p_comm_lines_api_rec.ATTRIBUTE2),
241 DECODE(p_comm_lines_api_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,
242 p_comm_lines_api_rec.ATTRIBUTE3),
243 DECODE(p_comm_lines_api_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,
244 p_comm_lines_api_rec.ATTRIBUTE4),
245 DECODE(p_comm_lines_api_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,
246 p_comm_lines_api_rec.ATTRIBUTE5),
247 DECODE(p_comm_lines_api_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,
248 p_comm_lines_api_rec.ATTRIBUTE6),
249 DECODE(p_comm_lines_api_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,
250 p_comm_lines_api_rec.ATTRIBUTE7),
251 DECODE(p_comm_lines_api_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,
252 p_comm_lines_api_rec.ATTRIBUTE8),
253 DECODE(p_comm_lines_api_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,
254 p_comm_lines_api_rec.ATTRIBUTE9),
255 DECODE(p_comm_lines_api_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,
256 p_comm_lines_api_rec.ATTRIBUTE10),
257 DECODE(p_comm_lines_api_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,
258 p_comm_lines_api_rec.ATTRIBUTE11),
259 DECODE(p_comm_lines_api_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,
260 p_comm_lines_api_rec.ATTRIBUTE12),
261 DECODE(p_comm_lines_api_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,
262 p_comm_lines_api_rec.ATTRIBUTE13),
263 DECODE(p_comm_lines_api_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,
264 p_comm_lines_api_rec.ATTRIBUTE14),
265 DECODE(p_comm_lines_api_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,
266 p_comm_lines_api_rec.ATTRIBUTE15),
267 DECODE(p_comm_lines_api_rec.ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL,
268 p_comm_lines_api_rec.ATTRIBUTE16),
269 DECODE(p_comm_lines_api_rec.ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL,
270 p_comm_lines_api_rec.ATTRIBUTE17),
271 DECODE(p_comm_lines_api_rec.ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL,
272 p_comm_lines_api_rec.ATTRIBUTE18),
273 DECODE(p_comm_lines_api_rec.ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL,
274 p_comm_lines_api_rec.ATTRIBUTE19),
275 DECODE(p_comm_lines_api_rec.ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL,
276 p_comm_lines_api_rec.ATTRIBUTE20),
277 DECODE(p_comm_lines_api_rec.ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL,
278 p_comm_lines_api_rec.ATTRIBUTE21),
279 DECODE(p_comm_lines_api_rec.ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL,
280 p_comm_lines_api_rec.ATTRIBUTE22),
281 DECODE(p_comm_lines_api_rec.ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL,
282 p_comm_lines_api_rec.ATTRIBUTE23),
283 DECODE(p_comm_lines_api_rec.ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL,
284 p_comm_lines_api_rec.ATTRIBUTE24),
285 DECODE(p_comm_lines_api_rec.ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL,
286 p_comm_lines_api_rec.ATTRIBUTE25),
287 DECODE(p_comm_lines_api_rec.ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL,
288 p_comm_lines_api_rec.ATTRIBUTE26),
289 DECODE(p_comm_lines_api_rec.ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL,
290 p_comm_lines_api_rec.ATTRIBUTE27),
291 DECODE(p_comm_lines_api_rec.ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL,
292 p_comm_lines_api_rec.ATTRIBUTE28),
293 DECODE(p_comm_lines_api_rec.ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL,
294 p_comm_lines_api_rec.ATTRIBUTE29),
295 DECODE(p_comm_lines_api_rec.ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL,
296 p_comm_lines_api_rec.ATTRIBUTE30),
297 DECODE(p_comm_lines_api_rec.ATTRIBUTE31, FND_API.G_MISS_CHAR, NULL,
298 p_comm_lines_api_rec.ATTRIBUTE31),
299 DECODE(p_comm_lines_api_rec.ATTRIBUTE32, FND_API.G_MISS_CHAR, NULL,
300 p_comm_lines_api_rec.ATTRIBUTE32),
301 DECODE(p_comm_lines_api_rec.ATTRIBUTE33, FND_API.G_MISS_CHAR, NULL,
302 p_comm_lines_api_rec.ATTRIBUTE33),
303 DECODE(p_comm_lines_api_rec.ATTRIBUTE34, FND_API.G_MISS_CHAR, NULL,
304 p_comm_lines_api_rec.ATTRIBUTE34),
305 DECODE(p_comm_lines_api_rec.ATTRIBUTE35, FND_API.G_MISS_CHAR, NULL,
306 p_comm_lines_api_rec.ATTRIBUTE35),
310 p_comm_lines_api_rec.ATTRIBUTE37),
307 DECODE(p_comm_lines_api_rec.ATTRIBUTE36, FND_API.G_MISS_CHAR, NULL,
308 p_comm_lines_api_rec.ATTRIBUTE36),
309 DECODE(p_comm_lines_api_rec.ATTRIBUTE37, FND_API.G_MISS_CHAR, NULL,
311 DECODE(p_comm_lines_api_rec.ATTRIBUTE38, FND_API.G_MISS_CHAR, NULL,
312 p_comm_lines_api_rec.ATTRIBUTE38),
313 DECODE(p_comm_lines_api_rec.ATTRIBUTE39, FND_API.G_MISS_CHAR, NULL,
314 p_comm_lines_api_rec.ATTRIBUTE39),
315 DECODE(p_comm_lines_api_rec.ATTRIBUTE40, FND_API.G_MISS_CHAR, NULL,
316 p_comm_lines_api_rec.ATTRIBUTE40),
317 DECODE(p_comm_lines_api_rec.ATTRIBUTE41, FND_API.G_MISS_CHAR, NULL,
318 p_comm_lines_api_rec.ATTRIBUTE41),
319 DECODE(p_comm_lines_api_rec.ATTRIBUTE42, FND_API.G_MISS_CHAR, NULL,
320 p_comm_lines_api_rec.ATTRIBUTE42),
321 DECODE(p_comm_lines_api_rec.ATTRIBUTE43, FND_API.G_MISS_CHAR, NULL,
322 p_comm_lines_api_rec.ATTRIBUTE43),
323 DECODE(p_comm_lines_api_rec.ATTRIBUTE44, FND_API.G_MISS_CHAR, NULL,
324 p_comm_lines_api_rec.ATTRIBUTE44),
325 DECODE(p_comm_lines_api_rec.ATTRIBUTE45, FND_API.G_MISS_CHAR, NULL,
326 p_comm_lines_api_rec.ATTRIBUTE45),
327 DECODE(p_comm_lines_api_rec.ATTRIBUTE46, FND_API.G_MISS_CHAR, NULL,
328 p_comm_lines_api_rec.ATTRIBUTE46),
329 DECODE(p_comm_lines_api_rec.ATTRIBUTE47, FND_API.G_MISS_CHAR, NULL,
330 p_comm_lines_api_rec.ATTRIBUTE47),
331 DECODE(p_comm_lines_api_rec.ATTRIBUTE48, FND_API.G_MISS_CHAR, NULL,
332 p_comm_lines_api_rec.ATTRIBUTE48),
333 DECODE(p_comm_lines_api_rec.ATTRIBUTE49, FND_API.G_MISS_CHAR, NULL,
334 p_comm_lines_api_rec.ATTRIBUTE49),
335 DECODE(p_comm_lines_api_rec.ATTRIBUTE50, FND_API.G_MISS_CHAR, NULL,
336 p_comm_lines_api_rec.ATTRIBUTE50),
337 DECODE(p_comm_lines_api_rec.ATTRIBUTE51, FND_API.G_MISS_CHAR, NULL,
338 p_comm_lines_api_rec.ATTRIBUTE51),
339 DECODE(p_comm_lines_api_rec.ATTRIBUTE52, FND_API.G_MISS_CHAR, NULL,
340 p_comm_lines_api_rec.ATTRIBUTE52),
341 DECODE(p_comm_lines_api_rec.ATTRIBUTE53, FND_API.G_MISS_CHAR, NULL,
342 p_comm_lines_api_rec.ATTRIBUTE53),
343 DECODE(p_comm_lines_api_rec.ATTRIBUTE54, FND_API.G_MISS_CHAR, NULL,
344 p_comm_lines_api_rec.ATTRIBUTE54),
345 DECODE(p_comm_lines_api_rec.ATTRIBUTE55, FND_API.G_MISS_CHAR, NULL,
346 p_comm_lines_api_rec.ATTRIBUTE55),
347 DECODE(p_comm_lines_api_rec.ATTRIBUTE56, FND_API.G_MISS_CHAR, NULL,
348 p_comm_lines_api_rec.ATTRIBUTE56),
349 DECODE(p_comm_lines_api_rec.ATTRIBUTE57, FND_API.G_MISS_CHAR, NULL,
350 p_comm_lines_api_rec.ATTRIBUTE57),
351 DECODE(p_comm_lines_api_rec.ATTRIBUTE58, FND_API.G_MISS_CHAR, NULL,
352 p_comm_lines_api_rec.ATTRIBUTE58),
353 DECODE(p_comm_lines_api_rec.ATTRIBUTE59, FND_API.G_MISS_CHAR, NULL,
354 p_comm_lines_api_rec.ATTRIBUTE59),
355 DECODE(p_comm_lines_api_rec.ATTRIBUTE60, FND_API.G_MISS_CHAR, NULL,
356 p_comm_lines_api_rec.ATTRIBUTE60),
357 DECODE(p_comm_lines_api_rec.ATTRIBUTE61, FND_API.G_MISS_CHAR, NULL,
358 p_comm_lines_api_rec.ATTRIBUTE61),
359 DECODE(p_comm_lines_api_rec.ATTRIBUTE62, FND_API.G_MISS_CHAR, NULL,
360 p_comm_lines_api_rec.ATTRIBUTE62),
361 DECODE(p_comm_lines_api_rec.ATTRIBUTE63, FND_API.G_MISS_CHAR, NULL,
362 p_comm_lines_api_rec.ATTRIBUTE63),
363 DECODE(p_comm_lines_api_rec.ATTRIBUTE64, FND_API.G_MISS_CHAR, NULL,
364 p_comm_lines_api_rec.ATTRIBUTE64),
365 DECODE(p_comm_lines_api_rec.ATTRIBUTE65, FND_API.G_MISS_CHAR, NULL,
366 p_comm_lines_api_rec.ATTRIBUTE65),
367 DECODE(p_comm_lines_api_rec.ATTRIBUTE66, FND_API.G_MISS_CHAR, NULL,
368 p_comm_lines_api_rec.ATTRIBUTE66),
369 DECODE(p_comm_lines_api_rec.ATTRIBUTE67, FND_API.G_MISS_CHAR, NULL,
370 p_comm_lines_api_rec.ATTRIBUTE67),
371 DECODE(p_comm_lines_api_rec.ATTRIBUTE68, FND_API.G_MISS_CHAR, NULL,
372 p_comm_lines_api_rec.ATTRIBUTE68),
373 DECODE(p_comm_lines_api_rec.ATTRIBUTE69, FND_API.G_MISS_CHAR, NULL,
374 p_comm_lines_api_rec.ATTRIBUTE69),
375 DECODE(p_comm_lines_api_rec.ATTRIBUTE70, FND_API.G_MISS_CHAR, NULL,
376 p_comm_lines_api_rec.ATTRIBUTE70),
377 DECODE(p_comm_lines_api_rec.ATTRIBUTE71, FND_API.G_MISS_CHAR, NULL,
378 p_comm_lines_api_rec.ATTRIBUTE71),
379 DECODE(p_comm_lines_api_rec.ATTRIBUTE72, FND_API.G_MISS_CHAR, NULL,
380 p_comm_lines_api_rec.ATTRIBUTE72),
381 DECODE(p_comm_lines_api_rec.ATTRIBUTE73, FND_API.G_MISS_CHAR, NULL,
382 p_comm_lines_api_rec.ATTRIBUTE73),
383 DECODE(p_comm_lines_api_rec.ATTRIBUTE74, FND_API.G_MISS_CHAR, NULL,
384 p_comm_lines_api_rec.ATTRIBUTE74),
385 DECODE(p_comm_lines_api_rec.ATTRIBUTE75, FND_API.G_MISS_CHAR, NULL,
386 p_comm_lines_api_rec.ATTRIBUTE75),
387 DECODE(p_comm_lines_api_rec.ATTRIBUTE76, FND_API.G_MISS_CHAR, NULL,
388 p_comm_lines_api_rec.ATTRIBUTE76),
389 DECODE(p_comm_lines_api_rec.ATTRIBUTE77, FND_API.G_MISS_CHAR, NULL,
390 p_comm_lines_api_rec.ATTRIBUTE77),
391 DECODE(p_comm_lines_api_rec.ATTRIBUTE78, FND_API.G_MISS_CHAR, NULL,
392 p_comm_lines_api_rec.ATTRIBUTE78),
393 DECODE(p_comm_lines_api_rec.ATTRIBUTE79, FND_API.G_MISS_CHAR, NULL,
394 p_comm_lines_api_rec.ATTRIBUTE79),
395 DECODE(p_comm_lines_api_rec.ATTRIBUTE80, FND_API.G_MISS_CHAR, NULL,
396 p_comm_lines_api_rec.ATTRIBUTE80),
397 DECODE(p_comm_lines_api_rec.ATTRIBUTE81, FND_API.G_MISS_CHAR, NULL,
398 p_comm_lines_api_rec.ATTRIBUTE81),
399 DECODE(p_comm_lines_api_rec.ATTRIBUTE82, FND_API.G_MISS_CHAR, NULL,
400 p_comm_lines_api_rec.ATTRIBUTE82),
404 p_comm_lines_api_rec.ATTRIBUTE84),
401 DECODE(p_comm_lines_api_rec.ATTRIBUTE83, FND_API.G_MISS_CHAR, NULL,
402 p_comm_lines_api_rec.ATTRIBUTE83),
403 DECODE(p_comm_lines_api_rec.ATTRIBUTE84, FND_API.G_MISS_CHAR, NULL,
405 DECODE(p_comm_lines_api_rec.ATTRIBUTE85, FND_API.G_MISS_CHAR, NULL,
406 p_comm_lines_api_rec.ATTRIBUTE85),
407 DECODE(p_comm_lines_api_rec.ATTRIBUTE86, FND_API.G_MISS_CHAR, NULL,
408 p_comm_lines_api_rec.ATTRIBUTE86),
409 DECODE(p_comm_lines_api_rec.ATTRIBUTE87, FND_API.G_MISS_CHAR, NULL,
410 p_comm_lines_api_rec.ATTRIBUTE87),
411 DECODE(p_comm_lines_api_rec.ATTRIBUTE88, FND_API.G_MISS_CHAR, NULL,
412 p_comm_lines_api_rec.ATTRIBUTE88),
413 DECODE(p_comm_lines_api_rec.ATTRIBUTE89, FND_API.G_MISS_CHAR, NULL,
414 p_comm_lines_api_rec.ATTRIBUTE89),
415 DECODE(p_comm_lines_api_rec.ATTRIBUTE90, FND_API.G_MISS_CHAR, NULL,
416 p_comm_lines_api_rec.ATTRIBUTE90),
417 DECODE(p_comm_lines_api_rec.ATTRIBUTE91, FND_API.G_MISS_CHAR, NULL,
418 p_comm_lines_api_rec.ATTRIBUTE91),
419 DECODE(p_comm_lines_api_rec.ATTRIBUTE92, FND_API.G_MISS_CHAR, NULL,
420 p_comm_lines_api_rec.ATTRIBUTE92),
421 DECODE(p_comm_lines_api_rec.ATTRIBUTE93, FND_API.G_MISS_CHAR, NULL,
422 p_comm_lines_api_rec.ATTRIBUTE93),
423 DECODE(p_comm_lines_api_rec.ATTRIBUTE94, FND_API.G_MISS_CHAR, NULL,
424 p_comm_lines_api_rec.ATTRIBUTE94),
425 DECODE(p_comm_lines_api_rec.ATTRIBUTE95, FND_API.G_MISS_CHAR, NULL,
426 p_comm_lines_api_rec.ATTRIBUTE95),
427 DECODE(p_comm_lines_api_rec.ATTRIBUTE96, FND_API.G_MISS_CHAR, NULL,
428 p_comm_lines_api_rec.ATTRIBUTE96),
429 DECODE(p_comm_lines_api_rec.ATTRIBUTE97, FND_API.G_MISS_CHAR, NULL,
430 p_comm_lines_api_rec.ATTRIBUTE97),
431 DECODE(p_comm_lines_api_rec.ATTRIBUTE98, FND_API.G_MISS_CHAR, NULL,
432 p_comm_lines_api_rec.ATTRIBUTE98),
433 DECODE(p_comm_lines_api_rec.ATTRIBUTE99, FND_API.G_MISS_CHAR, NULL,
434 p_comm_lines_api_rec.ATTRIBUTE99),
435 DECODE(p_comm_lines_api_rec.ATTRIBUTE100, FND_API.G_MISS_CHAR, NULL,
436 p_comm_lines_api_rec.ATTRIBUTE100),
437 DECODE(p_comm_lines_api_rec.COMM_LINES_API_ID, FND_API.G_MISS_NUM, NULL,
438 p_comm_lines_api_rec.COMM_LINES_API_ID),
439 DECODE(p_comm_lines_api_rec.CONC_BATCH_ID, FND_API.G_MISS_NUM, NULL,
440 p_comm_lines_api_rec.CONC_BATCH_ID),
441 DECODE(p_comm_lines_api_rec.PROCESS_BATCH_ID, FND_API.G_MISS_NUM, NULL,
442 p_comm_lines_api_rec.PROCESS_BATCH_ID),
443 DECODE(p_comm_lines_api_rec.SALESREP_NUMBER, FND_API.G_MISS_NUM, NULL,
444 p_comm_lines_api_rec.SALESREP_NUMBER),
445 DECODE(p_comm_lines_api_rec.ROLLUP_DATE, FND_API.G_MISS_DATE, NULL,
446 p_comm_lines_api_rec.ROLLUP_DATE),
447 DECODE(p_comm_lines_api_rec.SOURCE_DOC_ID, FND_API.G_MISS_NUM, NULL,
448 p_comm_lines_api_rec.SOURCE_DOC_ID),
449 DECODE(p_comm_lines_api_rec.SOURCE_DOC_TYPE, FND_API.G_MISS_CHAR, NULL,
450 p_comm_lines_api_rec.SOURCE_DOC_TYPE),
451 fnd_global.user_id,
452 Sysdate,
453 fnd_global.user_id,
454 Sysdate,
455 fnd_global.login_id,
456 DECODE(p_comm_lines_api_rec.TRANSACTION_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL,
457 p_comm_lines_api_rec.TRANSACTION_CURRENCY_CODE),
458 DECODE(p_comm_lines_api_rec.EXCHANGE_RATE, FND_API.G_MISS_NUM, NULL,
459 p_comm_lines_api_rec.EXCHANGE_RATE),
460 DECODE(p_comm_lines_api_rec.ACCTD_TRANSACTION_AMOUNT, FND_API.G_MISS_NUM, NULL,
461 p_comm_lines_api_rec.ACCTD_TRANSACTION_AMOUNT),
462 DECODE(p_comm_lines_api_rec.TRX_ID, FND_API.G_MISS_NUM, NULL,
463 p_comm_lines_api_rec.TRX_ID),
464 DECODE(p_comm_lines_api_rec.TRX_LINE_ID, FND_API.G_MISS_NUM, NULL,
465 p_comm_lines_api_rec.TRX_LINE_ID),
466 DECODE(p_comm_lines_api_rec.TRX_SALES_LINE_ID, FND_API.G_MISS_NUM, NULL,
467 p_comm_lines_api_rec.TRX_SALES_LINE_ID),
468 DECODE(p_comm_lines_api_rec.QUANTITY, FND_API.G_MISS_NUM, NULL,
469 p_comm_lines_api_rec.QUANTITY),
470 DECODE(p_comm_lines_api_rec.SOURCE_TRX_NUMBER, FND_API.G_MISS_CHAR, NULL,
471 p_comm_lines_api_rec.SOURCE_TRX_NUMBER),
472 DECODE(p_comm_lines_api_rec.DISCOUNT_PERCENTAGE, FND_API.G_MISS_NUM, NULL,
473 p_comm_lines_api_rec.DISCOUNT_PERCENTAGE),
474 DECODE(p_comm_lines_api_rec.MARGIN_PERCENTAGE, FND_API.G_MISS_NUM, NULL,
475 p_comm_lines_api_rec.MARGIN_PERCENTAGE),
476 DECODE(p_comm_lines_api_rec.SOURCE_TRX_ID, FND_API.G_MISS_NUM, NULL,
477 p_comm_lines_api_rec.SOURCE_TRX_ID),
478 DECODE(p_comm_lines_api_rec.SOURCE_TRX_LINE_ID, FND_API.G_MISS_NUM, NULL,
479 p_comm_lines_api_rec.SOURCE_TRX_LINE_ID),
480 DECODE(p_comm_lines_api_rec.SOURCE_TRX_SALES_LINE_ID, FND_API.G_MISS_NUM, NULL,
481 p_comm_lines_api_rec.SOURCE_TRX_SALES_LINE_ID),
482 DECODE(p_comm_lines_api_rec.NEGATED_FLAG, FND_API.G_MISS_CHAR, NULL,
483 p_comm_lines_api_rec.NEGATED_FLAG),
484 DECODE(p_comm_lines_api_rec.CUSTOMER_ID, FND_API.G_MISS_NUM, NULL,
485 p_comm_lines_api_rec.CUSTOMER_ID),
486 DECODE(p_comm_lines_api_rec.INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL,
487 p_comm_lines_api_rec.INVENTORY_ITEM_ID),
488 DECODE(p_comm_lines_api_rec.ORDER_NUMBER, FND_API.G_MISS_NUM, NULL,
489 p_comm_lines_api_rec.ORDER_NUMBER),
490 DECODE(p_comm_lines_api_rec.BOOKED_DATE, FND_API.G_MISS_DATE, NULL,
491 p_comm_lines_api_rec.BOOKED_DATE),
492 DECODE(p_comm_lines_api_rec.INVOICE_NUMBER, FND_API.G_MISS_CHAR, NULL,
493 p_comm_lines_api_rec.INVOICE_NUMBER),
497 p_comm_lines_api_rec.ADJUST_DATE),
494 DECODE(p_comm_lines_api_rec.INVOICE_DATE, FND_API.G_MISS_DATE, NULL,
495 p_comm_lines_api_rec.INVOICE_DATE),
496 DECODE(p_comm_lines_api_rec.ADJUST_DATE, FND_API.G_MISS_DATE, NULL,
498 DECODE(p_comm_lines_api_rec.ADJUSTED_BY, FND_API.G_MISS_CHAR, NULL,
499 p_comm_lines_api_rec.ADJUSTED_BY),
500 DECODE(p_comm_lines_api_rec.REVENUE_TYPE, FND_API.G_MISS_CHAR, NULL,
501 p_comm_lines_api_rec.REVENUE_TYPE),
502 DECODE(p_comm_lines_api_rec.ADJUST_ROLLUP_FLAG, FND_API.G_MISS_CHAR, NULL,
503 p_comm_lines_api_rec.ADJUST_ROLLUP_FLAG),
504 DECODE(p_comm_lines_api_rec.ADJUST_COMMENTS, FND_API.G_MISS_CHAR, NULL,
505 p_comm_lines_api_rec.ADJUST_COMMENTS),
506 NVL(DECODE(p_comm_lines_api_rec.ADJUST_STATUS, FND_API.G_MISS_CHAR, NULL, p_comm_lines_api_rec.ADJUST_STATUS),'NEW'),
507 DECODE(p_comm_lines_api_rec.LINE_NUMBER, FND_API.G_MISS_NUM, NULL,
508 p_comm_lines_api_rec.LINE_NUMBER),
509 DECODE(p_comm_lines_api_rec.BILL_TO_ADDRESS_ID, FND_API.G_MISS_NUM, NULL,
510 p_comm_lines_api_rec.BILL_TO_ADDRESS_ID),
511 DECODE(p_comm_lines_api_rec.SHIP_TO_ADDRESS_ID, FND_API.G_MISS_NUM, NULL,
512 p_comm_lines_api_rec.SHIP_TO_ADDRESS_ID),
513 DECODE(p_comm_lines_api_rec.BILL_TO_CONTACT_ID, FND_API.G_MISS_NUM, NULL,
514 p_comm_lines_api_rec.BILL_TO_CONTACT_ID),
515 DECODE(p_comm_lines_api_rec.SHIP_TO_CONTACT_ID, FND_API.G_MISS_NUM, NULL,
516 p_comm_lines_api_rec.SHIP_TO_CONTACT_ID),
517 DECODE(p_comm_lines_api_rec.ADJ_COMM_LINES_API_ID, FND_API.G_MISS_NUM, NULL,
518 p_comm_lines_api_rec.ADJ_COMM_LINES_API_ID),
519 DECODE(p_comm_lines_api_rec.PRE_DEFINED_RC_FLAG, FND_API.G_MISS_CHAR, NULL,
520 p_comm_lines_api_rec.PRE_DEFINED_RC_FLAG),
521 DECODE(p_comm_lines_api_rec.ROLLUP_FLAG, FND_API.G_MISS_CHAR, NULL,
522 p_comm_lines_api_rec.ROLLUP_FLAG),
523 DECODE(p_comm_lines_api_rec.FORECAST_ID, FND_API.G_MISS_NUM, NULL,
524 p_comm_lines_api_rec.FORECAST_ID),
525 DECODE(p_comm_lines_api_rec.UPSIDE_QUANTITY, FND_API.G_MISS_NUM, NULL,
526 p_comm_lines_api_rec.UPSIDE_QUANTITY),
527 DECODE(p_comm_lines_api_rec.UPSIDE_AMOUNT, FND_API.G_MISS_NUM, NULL,
528 p_comm_lines_api_rec.UPSIDE_AMOUNT),
529 DECODE(p_comm_lines_api_rec.UOM_CODE, FND_API.G_MISS_CHAR, NULL,
530 p_comm_lines_api_rec.UOM_CODE),
531 DECODE(p_comm_lines_api_rec.REASON_CODE, FND_API.G_MISS_CHAR, NULL,
532 p_comm_lines_api_rec.REASON_CODE),
533 DECODE(p_comm_lines_api_rec.TYPE, FND_API.G_MISS_CHAR, NULL,
534 p_comm_lines_api_rec.TYPE),
535 DECODE(p_comm_lines_api_rec.PRE_PROCESSED_CODE, FND_API.G_MISS_CHAR, NULL,
536 p_comm_lines_api_rec.PRE_PROCESSED_CODE),
537 DECODE(p_comm_lines_api_rec.QUOTA_ID, FND_API.G_MISS_NUM, NULL,
538 p_comm_lines_api_rec.QUOTA_ID),
539 DECODE(p_comm_lines_api_rec.SRP_PLAN_ASSIGN_ID, FND_API.G_MISS_NUM, NULL,
540 p_comm_lines_api_rec.SRP_PLAN_ASSIGN_ID),
541 DECODE(p_comm_lines_api_rec.ROLE_ID, FND_API.G_MISS_NUM, NULL,
542 p_comm_lines_api_rec.ROLE_ID),
543 DECODE(p_comm_lines_api_rec.COMP_GROUP_ID, FND_API.G_MISS_NUM, NULL,
544 p_comm_lines_api_rec.COMP_GROUP_ID),
545 DECODE(p_comm_lines_api_rec.COMMISSION_AMOUNT, FND_API.G_MISS_NUM, NULL,
546 p_comm_lines_api_rec.COMMISSION_AMOUNT),
547 DECODE(p_comm_lines_api_rec.EMPLOYEE_NUMBER, FND_API.G_MISS_CHAR, NULL,
548 p_comm_lines_api_rec.EMPLOYEE_NUMBER),
549 DECODE(p_comm_lines_api_rec.REVERSAL_FLAG, FND_API.G_MISS_CHAR, NULL,
550 p_comm_lines_api_rec.REVERSAL_FLAG),
551 DECODE(p_comm_lines_api_rec.REVERSAL_HEADER_ID, FND_API.G_MISS_NUM, NULL,
552 p_comm_lines_api_rec.REVERSAL_HEADER_ID),
553 DECODE(p_comm_lines_api_rec.SALES_CHANNEL, FND_API.G_MISS_CHAR, NULL,
554 p_comm_lines_api_rec.SALES_CHANNEL),
555 1,
556 DECODE(p_comm_lines_api_rec.SPLIT_PCT, FND_API.G_MISS_NUM, NULL,
557 p_comm_lines_api_rec.SPLIT_PCT),
558 DECODE(p_comm_lines_api_rec.SPLIT_STATUS, FND_API.G_MISS_CHAR, NULL,
559 p_comm_lines_api_rec.SPLIT_STATUS),
560 DECODE(p_comm_lines_api_rec.ORG_ID, FND_API.G_MISS_NUM, NULL,
561 p_comm_lines_api_rec.ORG_ID),
562 /* Added for Crediting Bug */
563 DECODE(p_comm_lines_api_rec.TERR_ID, FND_API.G_MISS_NUM, NULL,
564 p_comm_lines_api_rec.TERR_ID),
565 DECODE(p_comm_lines_api_rec.TERR_NAME, FND_API.G_MISS_CHAR, NULL,
566 p_comm_lines_api_rec.TERR_NAME),
567 DECODE(p_comm_lines_api_rec.PRESERVE_CREDIT_OVERRIDE_FLAG, FND_API.G_MISS_CHAR, NULL,
568 p_comm_lines_api_rec.PRESERVE_CREDIT_OVERRIDE_FLAG)
569 from dual;
570
571 l_err := SQLERRM;
572
573 END insert_row;
574
575
576 -- * -------------------------------------------------------------------------*
577 -- Procedure Name
578 -- update_row
579 -- Purpose
580 -- Main update procedure
581 -- Note
582 -- 1. No object version checking, overwrite may happen
583 -- 2. Calling lock_update for object version checking
584 -- 3. All paramaters are IN parameter.
585 -- 4. Raise NO_DATA_FOUND exception if no reocrd updated (??)
586 -- * -------------------------------------------------------------------------*
587 PROCEDURE update_row
588 ( p_comm_lines_api_rec IN COMM_LINES_API_REC_TYPE) IS
589
590 BEGIN
591
592 UPDATE CN_COMM_LINES_API oldrec
593 SET
594 SALESREP_ID = DECODE(p_comm_lines_api_rec.SALESREP_ID,
595 FND_API.G_MISS_NUM,
596 oldrec.SALESREP_ID,
597 p_comm_lines_api_rec.SALESREP_ID),
598 PROCESSED_DATE = DECODE(p_comm_lines_api_rec.PROCESSED_DATE,
599 FND_API.G_MISS_DATE,
600 oldrec.PROCESSED_DATE,
601 p_comm_lines_api_rec.PROCESSED_DATE),
602 PROCESSED_PERIOD_ID = DECODE(p_comm_lines_api_rec.PROCESSED_PERIOD_ID,
603 FND_API.G_MISS_NUM,
604 oldrec.PROCESSED_PERIOD_ID,
605 p_comm_lines_api_rec.PROCESSED_PERIOD_ID),
606 TRANSACTION_AMOUNT = DECODE(p_comm_lines_api_rec.TRANSACTION_AMOUNT,
607 FND_API.G_MISS_NUM,
608 oldrec.TRANSACTION_AMOUNT,
609 p_comm_lines_api_rec.TRANSACTION_AMOUNT),
610 TRX_TYPE = DECODE(p_comm_lines_api_rec.TRX_TYPE,
611 FND_API.G_MISS_CHAR,
612 oldrec.TRX_TYPE,
613 p_comm_lines_api_rec.TRX_TYPE),
614 REVENUE_CLASS_ID = DECODE(p_comm_lines_api_rec.REVENUE_CLASS_ID,
615 FND_API.G_MISS_NUM,
616 oldrec.REVENUE_CLASS_ID,
617 p_comm_lines_api_rec.REVENUE_CLASS_ID),
618 LOAD_STATUS = DECODE(p_comm_lines_api_rec.LOAD_STATUS,
619 FND_API.G_MISS_CHAR,
620 oldrec.LOAD_STATUS,
621 p_comm_lines_api_rec.LOAD_STATUS),
622 ATTRIBUTE_CATEGORY = DECODE(p_comm_lines_api_rec.ATTRIBUTE_CATEGORY,
623 FND_API.G_MISS_CHAR,
624 oldrec.ATTRIBUTE_CATEGORY,
625 p_comm_lines_api_rec.ATTRIBUTE_CATEGORY),
626 ATTRIBUTE1 = DECODE(p_comm_lines_api_rec.ATTRIBUTE1,
627 FND_API.G_MISS_CHAR,
628 oldrec.ATTRIBUTE1,
629 p_comm_lines_api_rec.ATTRIBUTE1),
630 ATTRIBUTE2 = DECODE(p_comm_lines_api_rec.ATTRIBUTE2,
631 FND_API.G_MISS_CHAR,
632 oldrec.ATTRIBUTE2,
633 p_comm_lines_api_rec.ATTRIBUTE2),
634 ATTRIBUTE3 = DECODE(p_comm_lines_api_rec.ATTRIBUTE3,
635 FND_API.G_MISS_CHAR,
636 oldrec.ATTRIBUTE3,
637 p_comm_lines_api_rec.ATTRIBUTE3),
638 ATTRIBUTE4 = DECODE(p_comm_lines_api_rec.ATTRIBUTE4,
639 FND_API.G_MISS_CHAR,
640 oldrec.ATTRIBUTE4,
641 p_comm_lines_api_rec.ATTRIBUTE4),
642 ATTRIBUTE5 = DECODE(p_comm_lines_api_rec.ATTRIBUTE5,
643 FND_API.G_MISS_CHAR,
644 oldrec.ATTRIBUTE5,
645 p_comm_lines_api_rec.ATTRIBUTE5),
646 ATTRIBUTE6 = DECODE(p_comm_lines_api_rec.ATTRIBUTE6,
647 FND_API.G_MISS_CHAR,
648 oldrec.ATTRIBUTE6,
649 p_comm_lines_api_rec.ATTRIBUTE6),
650 ATTRIBUTE7 = DECODE(p_comm_lines_api_rec.ATTRIBUTE7,
651 FND_API.G_MISS_CHAR,
652 oldrec.ATTRIBUTE7,
653 p_comm_lines_api_rec.ATTRIBUTE7),
654 ATTRIBUTE8 = DECODE(p_comm_lines_api_rec.ATTRIBUTE8,
655 FND_API.G_MISS_CHAR,
656 oldrec.ATTRIBUTE8,
657 p_comm_lines_api_rec.ATTRIBUTE8),
658 ATTRIBUTE9 = DECODE(p_comm_lines_api_rec.ATTRIBUTE9,
659 FND_API.G_MISS_CHAR,
660 oldrec.ATTRIBUTE9,
661 p_comm_lines_api_rec.ATTRIBUTE9),
662 ATTRIBUTE10 = DECODE(p_comm_lines_api_rec.ATTRIBUTE10,
663 FND_API.G_MISS_CHAR,
664 oldrec.ATTRIBUTE10,
665 p_comm_lines_api_rec.ATTRIBUTE10),
669 p_comm_lines_api_rec.ATTRIBUTE11),
666 ATTRIBUTE11 = DECODE(p_comm_lines_api_rec.ATTRIBUTE11,
667 FND_API.G_MISS_CHAR,
668 oldrec.ATTRIBUTE11,
670 ATTRIBUTE12 = DECODE(p_comm_lines_api_rec.ATTRIBUTE12,
671 FND_API.G_MISS_CHAR,
672 oldrec.ATTRIBUTE12,
673 p_comm_lines_api_rec.ATTRIBUTE12),
674 ATTRIBUTE13 = DECODE(p_comm_lines_api_rec.ATTRIBUTE13,
675 FND_API.G_MISS_CHAR,
676 oldrec.ATTRIBUTE13,
677 p_comm_lines_api_rec.ATTRIBUTE13),
678 ATTRIBUTE14 = DECODE(p_comm_lines_api_rec.ATTRIBUTE14,
679 FND_API.G_MISS_CHAR,
680 oldrec.ATTRIBUTE14,
681 p_comm_lines_api_rec.ATTRIBUTE14),
682 ATTRIBUTE15 = DECODE(p_comm_lines_api_rec.ATTRIBUTE15,
683 FND_API.G_MISS_CHAR,
684 oldrec.ATTRIBUTE15,
685 p_comm_lines_api_rec.ATTRIBUTE15),
686 ATTRIBUTE16 = DECODE(p_comm_lines_api_rec.ATTRIBUTE16,
687 FND_API.G_MISS_CHAR,
688 oldrec.ATTRIBUTE16,
689 p_comm_lines_api_rec.ATTRIBUTE16),
690 ATTRIBUTE17 = DECODE(p_comm_lines_api_rec.ATTRIBUTE17,
691 FND_API.G_MISS_CHAR,
692 oldrec.ATTRIBUTE17,
693 p_comm_lines_api_rec.ATTRIBUTE17),
694 ATTRIBUTE18 = DECODE(p_comm_lines_api_rec.ATTRIBUTE18,
695 FND_API.G_MISS_CHAR,
696 oldrec.ATTRIBUTE18,
697 p_comm_lines_api_rec.ATTRIBUTE18),
698 ATTRIBUTE19 = DECODE(p_comm_lines_api_rec.ATTRIBUTE19,
699 FND_API.G_MISS_CHAR,
700 oldrec.ATTRIBUTE19,
701 p_comm_lines_api_rec.ATTRIBUTE19),
702 ATTRIBUTE20 = DECODE(p_comm_lines_api_rec.ATTRIBUTE20,
703 FND_API.G_MISS_CHAR,
704 oldrec.ATTRIBUTE20,
705 p_comm_lines_api_rec.ATTRIBUTE20),
706 ATTRIBUTE21 = DECODE(p_comm_lines_api_rec.ATTRIBUTE21,
707 FND_API.G_MISS_CHAR,
708 oldrec.ATTRIBUTE21,
709 p_comm_lines_api_rec.ATTRIBUTE21),
710 ATTRIBUTE22 = DECODE(p_comm_lines_api_rec.ATTRIBUTE22,
711 FND_API.G_MISS_CHAR,
712 oldrec.ATTRIBUTE22,
713 p_comm_lines_api_rec.ATTRIBUTE22),
714 ATTRIBUTE23 = DECODE(p_comm_lines_api_rec.ATTRIBUTE23,
715 FND_API.G_MISS_CHAR,
716 oldrec.ATTRIBUTE23,
717 p_comm_lines_api_rec.ATTRIBUTE23),
718 ATTRIBUTE24 = DECODE(p_comm_lines_api_rec.ATTRIBUTE24,
719 FND_API.G_MISS_CHAR,
720 oldrec.ATTRIBUTE24,
721 p_comm_lines_api_rec.ATTRIBUTE24),
722 ATTRIBUTE25 = DECODE(p_comm_lines_api_rec.ATTRIBUTE25,
723 FND_API.G_MISS_CHAR,
724 oldrec.ATTRIBUTE25,
725 p_comm_lines_api_rec.ATTRIBUTE25),
726 ATTRIBUTE26 = DECODE(p_comm_lines_api_rec.ATTRIBUTE26,
727 FND_API.G_MISS_CHAR,
728 oldrec.ATTRIBUTE26,
729 p_comm_lines_api_rec.ATTRIBUTE26),
730 ATTRIBUTE27 = DECODE(p_comm_lines_api_rec.ATTRIBUTE27,
731 FND_API.G_MISS_CHAR,
732 oldrec.ATTRIBUTE27,
733 p_comm_lines_api_rec.ATTRIBUTE27),
734 ATTRIBUTE28 = DECODE(p_comm_lines_api_rec.ATTRIBUTE28,
735 FND_API.G_MISS_CHAR,
736 oldrec.ATTRIBUTE28,
737 p_comm_lines_api_rec.ATTRIBUTE28),
738 ATTRIBUTE29 = DECODE(p_comm_lines_api_rec.ATTRIBUTE29,
739 FND_API.G_MISS_CHAR,
740 oldrec.ATTRIBUTE29,
741 p_comm_lines_api_rec.ATTRIBUTE29),
742 ATTRIBUTE30 = DECODE(p_comm_lines_api_rec.ATTRIBUTE30,
743 FND_API.G_MISS_CHAR,
744 oldrec.ATTRIBUTE30,
745 p_comm_lines_api_rec.ATTRIBUTE30),
746 ATTRIBUTE31 = DECODE(p_comm_lines_api_rec.ATTRIBUTE31,
747 FND_API.G_MISS_CHAR,
748 oldrec.ATTRIBUTE31,
749 p_comm_lines_api_rec.ATTRIBUTE31),
750 ATTRIBUTE32 = DECODE(p_comm_lines_api_rec.ATTRIBUTE32,
751 FND_API.G_MISS_CHAR,
752 oldrec.ATTRIBUTE32,
753 p_comm_lines_api_rec.ATTRIBUTE32),
754 ATTRIBUTE33 = DECODE(p_comm_lines_api_rec.ATTRIBUTE33,
758 ATTRIBUTE34 = DECODE(p_comm_lines_api_rec.ATTRIBUTE34,
755 FND_API.G_MISS_CHAR,
756 oldrec.ATTRIBUTE33,
757 p_comm_lines_api_rec.ATTRIBUTE33),
759 FND_API.G_MISS_CHAR,
760 oldrec.ATTRIBUTE34,
761 p_comm_lines_api_rec.ATTRIBUTE34),
762 ATTRIBUTE35 = DECODE(p_comm_lines_api_rec.ATTRIBUTE35,
763 FND_API.G_MISS_CHAR,
764 oldrec.ATTRIBUTE35,
765 p_comm_lines_api_rec.ATTRIBUTE35),
766 ATTRIBUTE36 = DECODE(p_comm_lines_api_rec.ATTRIBUTE36,
767 FND_API.G_MISS_CHAR,
768 oldrec.ATTRIBUTE36,
769 p_comm_lines_api_rec.ATTRIBUTE36),
770 ATTRIBUTE37 = DECODE(p_comm_lines_api_rec.ATTRIBUTE37,
771 FND_API.G_MISS_CHAR,
772 oldrec.ATTRIBUTE37,
773 p_comm_lines_api_rec.ATTRIBUTE37),
774 ATTRIBUTE38 = DECODE(p_comm_lines_api_rec.ATTRIBUTE38,
775 FND_API.G_MISS_CHAR,
776 oldrec.ATTRIBUTE38,
777 p_comm_lines_api_rec.ATTRIBUTE38),
778 ATTRIBUTE39 = DECODE(p_comm_lines_api_rec.ATTRIBUTE39,
779 FND_API.G_MISS_CHAR,
780 oldrec.ATTRIBUTE39,
781 p_comm_lines_api_rec.ATTRIBUTE39),
782 ATTRIBUTE40 = DECODE(p_comm_lines_api_rec.ATTRIBUTE40,
783 FND_API.G_MISS_CHAR,
784 oldrec.ATTRIBUTE40,
785 p_comm_lines_api_rec.ATTRIBUTE40),
786 ATTRIBUTE41 = DECODE(p_comm_lines_api_rec.ATTRIBUTE41,
787 FND_API.G_MISS_CHAR,
788 oldrec.ATTRIBUTE41,
789 p_comm_lines_api_rec.ATTRIBUTE41),
790 ATTRIBUTE42 = DECODE(p_comm_lines_api_rec.ATTRIBUTE42,
791 FND_API.G_MISS_CHAR,
792 oldrec.ATTRIBUTE42,
793 p_comm_lines_api_rec.ATTRIBUTE42),
794 ATTRIBUTE43 = DECODE(p_comm_lines_api_rec.ATTRIBUTE43,
795 FND_API.G_MISS_CHAR,
796 oldrec.ATTRIBUTE43,
797 p_comm_lines_api_rec.ATTRIBUTE43),
798 ATTRIBUTE44 = DECODE(p_comm_lines_api_rec.ATTRIBUTE44,
799 FND_API.G_MISS_CHAR,
800 oldrec.ATTRIBUTE44,
801 p_comm_lines_api_rec.ATTRIBUTE44),
802 ATTRIBUTE45 = DECODE(p_comm_lines_api_rec.ATTRIBUTE45,
803 FND_API.G_MISS_CHAR,
804 oldrec.ATTRIBUTE45,
805 p_comm_lines_api_rec.ATTRIBUTE45),
806 ATTRIBUTE46 = DECODE(p_comm_lines_api_rec.ATTRIBUTE46,
807 FND_API.G_MISS_CHAR,
808 oldrec.ATTRIBUTE46,
809 p_comm_lines_api_rec.ATTRIBUTE46),
810 ATTRIBUTE47 = DECODE(p_comm_lines_api_rec.ATTRIBUTE47,
811 FND_API.G_MISS_CHAR,
812 oldrec.ATTRIBUTE47,
813 p_comm_lines_api_rec.ATTRIBUTE47),
814 ATTRIBUTE48 = DECODE(p_comm_lines_api_rec.ATTRIBUTE48,
815 FND_API.G_MISS_CHAR,
816 oldrec.ATTRIBUTE48,
817 p_comm_lines_api_rec.ATTRIBUTE48),
818 ATTRIBUTE49 = DECODE(p_comm_lines_api_rec.ATTRIBUTE49,
819 FND_API.G_MISS_CHAR,
820 oldrec.ATTRIBUTE49,
821 p_comm_lines_api_rec.ATTRIBUTE49),
822 ATTRIBUTE50 = DECODE(p_comm_lines_api_rec.ATTRIBUTE50,
823 FND_API.G_MISS_CHAR,
824 oldrec.ATTRIBUTE50,
825 p_comm_lines_api_rec.ATTRIBUTE50),
826 ATTRIBUTE51 = DECODE(p_comm_lines_api_rec.ATTRIBUTE51,
827 FND_API.G_MISS_CHAR,
828 oldrec.ATTRIBUTE51,
829 p_comm_lines_api_rec.ATTRIBUTE51),
830 ATTRIBUTE52 = DECODE(p_comm_lines_api_rec.ATTRIBUTE52,
831 FND_API.G_MISS_CHAR,
832 oldrec.ATTRIBUTE52,
833 p_comm_lines_api_rec.ATTRIBUTE52),
834 ATTRIBUTE53 = DECODE(p_comm_lines_api_rec.ATTRIBUTE53,
835 FND_API.G_MISS_CHAR,
836 oldrec.ATTRIBUTE53,
837 p_comm_lines_api_rec.ATTRIBUTE53),
838 ATTRIBUTE54 = DECODE(p_comm_lines_api_rec.ATTRIBUTE54,
839 FND_API.G_MISS_CHAR,
840 oldrec.ATTRIBUTE54,
841 p_comm_lines_api_rec.ATTRIBUTE54),
842 ATTRIBUTE55 = DECODE(p_comm_lines_api_rec.ATTRIBUTE55,
843 FND_API.G_MISS_CHAR,
844 oldrec.ATTRIBUTE55,
845 p_comm_lines_api_rec.ATTRIBUTE55),
849 p_comm_lines_api_rec.ATTRIBUTE56),
846 ATTRIBUTE56 = DECODE(p_comm_lines_api_rec.ATTRIBUTE56,
847 FND_API.G_MISS_CHAR,
848 oldrec.ATTRIBUTE56,
850 ATTRIBUTE57 = DECODE(p_comm_lines_api_rec.ATTRIBUTE57,
851 FND_API.G_MISS_CHAR,
852 oldrec.ATTRIBUTE57,
853 p_comm_lines_api_rec.ATTRIBUTE57),
854 ATTRIBUTE58 = DECODE(p_comm_lines_api_rec.ATTRIBUTE58,
855 FND_API.G_MISS_CHAR,
856 oldrec.ATTRIBUTE58,
857 p_comm_lines_api_rec.ATTRIBUTE58),
858 ATTRIBUTE59 = DECODE(p_comm_lines_api_rec.ATTRIBUTE59,
859 FND_API.G_MISS_CHAR,
860 oldrec.ATTRIBUTE59,
861 p_comm_lines_api_rec.ATTRIBUTE59),
862 ATTRIBUTE60 = DECODE(p_comm_lines_api_rec.ATTRIBUTE60,
863 FND_API.G_MISS_CHAR,
864 oldrec.ATTRIBUTE60,
865 p_comm_lines_api_rec.ATTRIBUTE60),
866 ATTRIBUTE61 = DECODE(p_comm_lines_api_rec.ATTRIBUTE61,
867 FND_API.G_MISS_CHAR,
868 oldrec.ATTRIBUTE61,
869 p_comm_lines_api_rec.ATTRIBUTE61),
870 ATTRIBUTE62 = DECODE(p_comm_lines_api_rec.ATTRIBUTE62,
871 FND_API.G_MISS_CHAR,
872 oldrec.ATTRIBUTE62,
873 p_comm_lines_api_rec.ATTRIBUTE62),
874 ATTRIBUTE63 = DECODE(p_comm_lines_api_rec.ATTRIBUTE63,
875 FND_API.G_MISS_CHAR,
876 oldrec.ATTRIBUTE63,
877 p_comm_lines_api_rec.ATTRIBUTE63),
878 ATTRIBUTE64 = DECODE(p_comm_lines_api_rec.ATTRIBUTE64,
879 FND_API.G_MISS_CHAR,
880 oldrec.ATTRIBUTE64,
881 p_comm_lines_api_rec.ATTRIBUTE64),
882 ATTRIBUTE65 = DECODE(p_comm_lines_api_rec.ATTRIBUTE65,
883 FND_API.G_MISS_CHAR,
884 oldrec.ATTRIBUTE65,
885 p_comm_lines_api_rec.ATTRIBUTE65),
886 ATTRIBUTE66 = DECODE(p_comm_lines_api_rec.ATTRIBUTE66,
887 FND_API.G_MISS_CHAR,
888 oldrec.ATTRIBUTE66,
889 p_comm_lines_api_rec.ATTRIBUTE66),
890 ATTRIBUTE67 = DECODE(p_comm_lines_api_rec.ATTRIBUTE67,
891 FND_API.G_MISS_CHAR,
892 oldrec.ATTRIBUTE67,
893 p_comm_lines_api_rec.ATTRIBUTE67),
894 ATTRIBUTE68 = DECODE(p_comm_lines_api_rec.ATTRIBUTE68,
895 FND_API.G_MISS_CHAR,
896 oldrec.ATTRIBUTE68,
897 p_comm_lines_api_rec.ATTRIBUTE68),
898 ATTRIBUTE69 = DECODE(p_comm_lines_api_rec.ATTRIBUTE69,
899 FND_API.G_MISS_CHAR,
900 oldrec.ATTRIBUTE69,
901 p_comm_lines_api_rec.ATTRIBUTE69),
902 ATTRIBUTE70 = DECODE(p_comm_lines_api_rec.ATTRIBUTE70,
903 FND_API.G_MISS_CHAR,
904 oldrec.ATTRIBUTE70,
905 p_comm_lines_api_rec.ATTRIBUTE70),
906 ATTRIBUTE71 = DECODE(p_comm_lines_api_rec.ATTRIBUTE71,
907 FND_API.G_MISS_CHAR,
908 oldrec.ATTRIBUTE71,
909 p_comm_lines_api_rec.ATTRIBUTE71),
910 ATTRIBUTE72 = DECODE(p_comm_lines_api_rec.ATTRIBUTE72,
911 FND_API.G_MISS_CHAR,
912 oldrec.ATTRIBUTE72,
913 p_comm_lines_api_rec.ATTRIBUTE72),
914 ATTRIBUTE73 = DECODE(p_comm_lines_api_rec.ATTRIBUTE73,
915 FND_API.G_MISS_CHAR,
916 oldrec.ATTRIBUTE73,
917 p_comm_lines_api_rec.ATTRIBUTE73),
918 ATTRIBUTE74 = DECODE(p_comm_lines_api_rec.ATTRIBUTE74,
919 FND_API.G_MISS_CHAR,
920 oldrec.ATTRIBUTE74,
921 p_comm_lines_api_rec.ATTRIBUTE74),
922 ATTRIBUTE75 = DECODE(p_comm_lines_api_rec.ATTRIBUTE75,
923 FND_API.G_MISS_CHAR,
924 oldrec.ATTRIBUTE75,
925 p_comm_lines_api_rec.ATTRIBUTE75),
926 ATTRIBUTE76 = DECODE(p_comm_lines_api_rec.ATTRIBUTE76,
927 FND_API.G_MISS_CHAR,
928 oldrec.ATTRIBUTE76,
929 p_comm_lines_api_rec.ATTRIBUTE76),
930 ATTRIBUTE77 = DECODE(p_comm_lines_api_rec.ATTRIBUTE77,
931 FND_API.G_MISS_CHAR,
932 oldrec.ATTRIBUTE77,
933 p_comm_lines_api_rec.ATTRIBUTE77),
934 ATTRIBUTE78 = DECODE(p_comm_lines_api_rec.ATTRIBUTE78,
935 FND_API.G_MISS_CHAR,
936 oldrec.ATTRIBUTE78,
940 oldrec.ATTRIBUTE79,
937 p_comm_lines_api_rec.ATTRIBUTE78),
938 ATTRIBUTE79 = DECODE(p_comm_lines_api_rec.ATTRIBUTE79,
939 FND_API.G_MISS_CHAR,
941 p_comm_lines_api_rec.ATTRIBUTE79),
942 ATTRIBUTE80 = DECODE(p_comm_lines_api_rec.ATTRIBUTE80,
943 FND_API.G_MISS_CHAR,
944 oldrec.ATTRIBUTE80,
945 p_comm_lines_api_rec.ATTRIBUTE80),
946 ATTRIBUTE81 = DECODE(p_comm_lines_api_rec.ATTRIBUTE81,
947 FND_API.G_MISS_CHAR,
948 oldrec.ATTRIBUTE81,
949 p_comm_lines_api_rec.ATTRIBUTE81),
950 ATTRIBUTE82 = DECODE(p_comm_lines_api_rec.ATTRIBUTE82,
951 FND_API.G_MISS_CHAR,
952 oldrec.ATTRIBUTE82,
953 p_comm_lines_api_rec.ATTRIBUTE82),
954 ATTRIBUTE83 = DECODE(p_comm_lines_api_rec.ATTRIBUTE83,
955 FND_API.G_MISS_CHAR,
956 oldrec.ATTRIBUTE83,
957 p_comm_lines_api_rec.ATTRIBUTE83),
958 ATTRIBUTE84 = DECODE(p_comm_lines_api_rec.ATTRIBUTE84,
959 FND_API.G_MISS_CHAR,
960 oldrec.ATTRIBUTE84,
961 p_comm_lines_api_rec.ATTRIBUTE84),
962 ATTRIBUTE85 = DECODE(p_comm_lines_api_rec.ATTRIBUTE85,
963 FND_API.G_MISS_CHAR,
964 oldrec.ATTRIBUTE85,
965 p_comm_lines_api_rec.ATTRIBUTE85),
966 ATTRIBUTE86 = DECODE(p_comm_lines_api_rec.ATTRIBUTE86,
967 FND_API.G_MISS_CHAR,
968 oldrec.ATTRIBUTE86,
969 p_comm_lines_api_rec.ATTRIBUTE86),
970 ATTRIBUTE87 = DECODE(p_comm_lines_api_rec.ATTRIBUTE87,
971 FND_API.G_MISS_CHAR,
972 oldrec.ATTRIBUTE87,
973 p_comm_lines_api_rec.ATTRIBUTE87),
974 ATTRIBUTE88 = DECODE(p_comm_lines_api_rec.ATTRIBUTE88,
975 FND_API.G_MISS_CHAR,
976 oldrec.ATTRIBUTE88,
977 p_comm_lines_api_rec.ATTRIBUTE88),
978 ATTRIBUTE89 = DECODE(p_comm_lines_api_rec.ATTRIBUTE89,
979 FND_API.G_MISS_CHAR,
980 oldrec.ATTRIBUTE89,
981 p_comm_lines_api_rec.ATTRIBUTE89),
982 ATTRIBUTE90 = DECODE(p_comm_lines_api_rec.ATTRIBUTE90,
983 FND_API.G_MISS_CHAR,
984 oldrec.ATTRIBUTE90,
985 p_comm_lines_api_rec.ATTRIBUTE90),
986 ATTRIBUTE91 = DECODE(p_comm_lines_api_rec.ATTRIBUTE91,
987 FND_API.G_MISS_CHAR,
988 oldrec.ATTRIBUTE91,
989 p_comm_lines_api_rec.ATTRIBUTE91),
990 ATTRIBUTE92 = DECODE(p_comm_lines_api_rec.ATTRIBUTE92,
991 FND_API.G_MISS_CHAR,
992 oldrec.ATTRIBUTE92,
993 p_comm_lines_api_rec.ATTRIBUTE92),
994 ATTRIBUTE93 = DECODE(p_comm_lines_api_rec.ATTRIBUTE93,
995 FND_API.G_MISS_CHAR,
996 oldrec.ATTRIBUTE93,
997 p_comm_lines_api_rec.ATTRIBUTE93),
998 ATTRIBUTE94 = DECODE(p_comm_lines_api_rec.ATTRIBUTE94,
999 FND_API.G_MISS_CHAR,
1000 oldrec.ATTRIBUTE94,
1001 p_comm_lines_api_rec.ATTRIBUTE94),
1002 ATTRIBUTE95 = DECODE(p_comm_lines_api_rec.ATTRIBUTE95,
1003 FND_API.G_MISS_CHAR,
1004 oldrec.ATTRIBUTE95,
1005 p_comm_lines_api_rec.ATTRIBUTE95),
1006 ATTRIBUTE96 = DECODE(p_comm_lines_api_rec.ATTRIBUTE96,
1007 FND_API.G_MISS_CHAR,
1008 oldrec.ATTRIBUTE96,
1009 p_comm_lines_api_rec.ATTRIBUTE96),
1010 ATTRIBUTE97 = DECODE(p_comm_lines_api_rec.ATTRIBUTE97,
1011 FND_API.G_MISS_CHAR,
1012 oldrec.ATTRIBUTE97,
1013 p_comm_lines_api_rec.ATTRIBUTE97),
1014 ATTRIBUTE98 = DECODE(p_comm_lines_api_rec.ATTRIBUTE98,
1015 FND_API.G_MISS_CHAR,
1016 oldrec.ATTRIBUTE98,
1017 p_comm_lines_api_rec.ATTRIBUTE98),
1018 ATTRIBUTE99 = DECODE(p_comm_lines_api_rec.ATTRIBUTE99,
1019 FND_API.G_MISS_CHAR,
1020 oldrec.ATTRIBUTE99,
1021 p_comm_lines_api_rec.ATTRIBUTE99),
1022 ATTRIBUTE100 = DECODE(p_comm_lines_api_rec.ATTRIBUTE100,
1023 FND_API.G_MISS_CHAR,
1024 oldrec.ATTRIBUTE100,
1025 p_comm_lines_api_rec.ATTRIBUTE100),
1026 CONC_BATCH_ID = DECODE(p_comm_lines_api_rec.CONC_BATCH_ID,
1027 FND_API.G_MISS_NUM,
1028 oldrec.CONC_BATCH_ID,
1029 p_comm_lines_api_rec.CONC_BATCH_ID),
1030 PROCESS_BATCH_ID = DECODE(p_comm_lines_api_rec.PROCESS_BATCH_ID,
1031 FND_API.G_MISS_NUM,
1032 oldrec.PROCESS_BATCH_ID,
1033 p_comm_lines_api_rec.PROCESS_BATCH_ID),
1034 SALESREP_NUMBER = DECODE(p_comm_lines_api_rec.SALESREP_NUMBER,
1035 FND_API.G_MISS_NUM,
1036 oldrec.SALESREP_NUMBER,
1037 p_comm_lines_api_rec.SALESREP_NUMBER),
1038 ROLLUP_DATE = DECODE(p_comm_lines_api_rec.ROLLUP_DATE,
1039 FND_API.G_MISS_DATE,
1040 oldrec.ROLLUP_DATE,
1041 p_comm_lines_api_rec.ROLLUP_DATE),
1042 SOURCE_DOC_ID = DECODE(p_comm_lines_api_rec.SOURCE_DOC_ID,
1043 FND_API.G_MISS_NUM,
1044 oldrec.SOURCE_DOC_ID,
1045 p_comm_lines_api_rec.SOURCE_DOC_ID),
1046 SOURCE_DOC_TYPE = DECODE(p_comm_lines_api_rec.SOURCE_DOC_TYPE,
1047 FND_API.G_MISS_CHAR,
1048 oldrec.SOURCE_DOC_TYPE,
1049 p_comm_lines_api_rec.SOURCE_DOC_TYPE),
1050 LAST_UPDATED_BY = fnd_global.user_id,
1051 LAST_UPDATE_DATE = Sysdate,
1052 LAST_UPDATE_LOGIN = fnd_global.login_id,
1053 TRANSACTION_CURRENCY_CODE = DECODE(p_comm_lines_api_rec.TRANSACTION_CURRENCY_CODE,
1054 FND_API.G_MISS_CHAR,
1055 oldrec.TRANSACTION_CURRENCY_CODE,
1056 p_comm_lines_api_rec.TRANSACTION_CURRENCY_CODE),
1057 EXCHANGE_RATE = DECODE(p_comm_lines_api_rec.EXCHANGE_RATE,
1058 FND_API.G_MISS_NUM,
1059 oldrec.EXCHANGE_RATE,
1060 p_comm_lines_api_rec.EXCHANGE_RATE),
1061 ACCTD_TRANSACTION_AMOUNT = DECODE(p_comm_lines_api_rec.ACCTD_TRANSACTION_AMOUNT,
1062 FND_API.G_MISS_NUM,
1063 oldrec.ACCTD_TRANSACTION_AMOUNT,
1064 p_comm_lines_api_rec.ACCTD_TRANSACTION_AMOUNT),
1065 TRX_ID = DECODE(p_comm_lines_api_rec.TRX_ID,
1066 FND_API.G_MISS_NUM,
1067 oldrec.TRX_ID,
1068 p_comm_lines_api_rec.TRX_ID),
1069 TRX_LINE_ID = DECODE(p_comm_lines_api_rec.TRX_LINE_ID,
1070 FND_API.G_MISS_NUM,
1071 oldrec.TRX_LINE_ID,
1072 p_comm_lines_api_rec.TRX_LINE_ID),
1073 TRX_SALES_LINE_ID = DECODE(p_comm_lines_api_rec.TRX_SALES_LINE_ID,
1074 FND_API.G_MISS_NUM,
1075 oldrec.TRX_SALES_LINE_ID,
1076 p_comm_lines_api_rec.TRX_SALES_LINE_ID),
1077 QUANTITY = DECODE(p_comm_lines_api_rec.QUANTITY,
1078 FND_API.G_MISS_NUM,
1079 oldrec.QUANTITY,
1080 p_comm_lines_api_rec.QUANTITY),
1081 SOURCE_TRX_NUMBER = DECODE(p_comm_lines_api_rec.SOURCE_TRX_NUMBER,
1082 FND_API.G_MISS_CHAR,
1083 oldrec.SOURCE_TRX_NUMBER,
1084 p_comm_lines_api_rec.SOURCE_TRX_NUMBER),
1085 DISCOUNT_PERCENTAGE = DECODE(p_comm_lines_api_rec.DISCOUNT_PERCENTAGE,
1086 FND_API.G_MISS_NUM,
1087 oldrec.DISCOUNT_PERCENTAGE,
1088 p_comm_lines_api_rec.DISCOUNT_PERCENTAGE),
1089 MARGIN_PERCENTAGE = DECODE(p_comm_lines_api_rec.MARGIN_PERCENTAGE,
1090 FND_API.G_MISS_NUM,
1091 oldrec.MARGIN_PERCENTAGE,
1092 p_comm_lines_api_rec.MARGIN_PERCENTAGE),
1093 SOURCE_TRX_ID = DECODE(p_comm_lines_api_rec.SOURCE_TRX_ID,
1094 FND_API.G_MISS_NUM,
1095 oldrec.SOURCE_TRX_ID,
1096 p_comm_lines_api_rec.SOURCE_TRX_ID),
1097 SOURCE_TRX_LINE_ID = DECODE(p_comm_lines_api_rec.SOURCE_TRX_LINE_ID,
1098 FND_API.G_MISS_NUM,
1099 oldrec.SOURCE_TRX_LINE_ID,
1100 p_comm_lines_api_rec.SOURCE_TRX_LINE_ID),
1101 SOURCE_TRX_SALES_LINE_ID = DECODE(p_comm_lines_api_rec.SOURCE_TRX_SALES_LINE_ID,
1102 FND_API.G_MISS_NUM,
1103 oldrec.SOURCE_TRX_SALES_LINE_ID,
1104 p_comm_lines_api_rec.SOURCE_TRX_SALES_LINE_ID),
1105 NEGATED_FLAG = DECODE(p_comm_lines_api_rec.NEGATED_FLAG,
1106 FND_API.G_MISS_CHAR,
1107 oldrec.NEGATED_FLAG,
1108 p_comm_lines_api_rec.NEGATED_FLAG),
1109 CUSTOMER_ID = DECODE(p_comm_lines_api_rec.CUSTOMER_ID,
1110 FND_API.G_MISS_NUM,
1111 oldrec.CUSTOMER_ID,
1112 p_comm_lines_api_rec.CUSTOMER_ID),
1113 INVENTORY_ITEM_ID = DECODE(p_comm_lines_api_rec.INVENTORY_ITEM_ID,
1114 FND_API.G_MISS_NUM,
1115 oldrec.INVENTORY_ITEM_ID,
1116 p_comm_lines_api_rec.INVENTORY_ITEM_ID),
1117 ORDER_NUMBER = DECODE(p_comm_lines_api_rec.ORDER_NUMBER,
1118 FND_API.G_MISS_NUM,
1119 oldrec.ORDER_NUMBER,
1120 p_comm_lines_api_rec.ORDER_NUMBER),
1121 BOOKED_DATE = DECODE(p_comm_lines_api_rec.BOOKED_DATE,
1122 FND_API.G_MISS_DATE,
1123 oldrec.BOOKED_DATE,
1124 p_comm_lines_api_rec.BOOKED_DATE),
1125 INVOICE_NUMBER = DECODE(p_comm_lines_api_rec.INVOICE_NUMBER,
1126 FND_API.G_MISS_CHAR,
1127 oldrec.INVOICE_NUMBER,
1128 p_comm_lines_api_rec.INVOICE_NUMBER),
1129 INVOICE_DATE = DECODE(p_comm_lines_api_rec.INVOICE_DATE,
1130 FND_API.G_MISS_DATE,
1131 oldrec.INVOICE_DATE,
1132 p_comm_lines_api_rec.INVOICE_DATE),
1133 ADJUST_DATE = DECODE(p_comm_lines_api_rec.ADJUST_DATE,
1134 FND_API.G_MISS_DATE,
1135 oldrec.ADJUST_DATE,
1136 p_comm_lines_api_rec.ADJUST_DATE),
1137 ADJUSTED_BY = DECODE(p_comm_lines_api_rec.ADJUSTED_BY,
1138 FND_API.G_MISS_CHAR,
1139 oldrec.ADJUSTED_BY,
1140 p_comm_lines_api_rec.ADJUSTED_BY),
1141 REVENUE_TYPE = DECODE(p_comm_lines_api_rec.REVENUE_TYPE,
1142 FND_API.G_MISS_CHAR,
1143 oldrec.REVENUE_TYPE,
1144 p_comm_lines_api_rec.REVENUE_TYPE),
1145 ADJUST_ROLLUP_FLAG = DECODE(p_comm_lines_api_rec.ADJUST_ROLLUP_FLAG,
1146 FND_API.G_MISS_CHAR,
1147 oldrec.ADJUST_ROLLUP_FLAG,
1148 p_comm_lines_api_rec.ADJUST_ROLLUP_FLAG),
1149 ADJUST_COMMENTS = DECODE(p_comm_lines_api_rec.ADJUST_COMMENTS,
1150 FND_API.G_MISS_CHAR,
1151 oldrec.ADJUST_COMMENTS,
1152 p_comm_lines_api_rec.ADJUST_COMMENTS),
1153 ADJUST_STATUS = NVL(DECODE(p_comm_lines_api_rec.ADJUST_STATUS,
1154 FND_API.G_MISS_CHAR,
1155 oldrec.ADJUST_STATUS,
1156 p_comm_lines_api_rec.ADJUST_STATUS),'NEW'),
1157 LINE_NUMBER = DECODE(p_comm_lines_api_rec.LINE_NUMBER,
1158 FND_API.G_MISS_NUM,
1159 oldrec.LINE_NUMBER,
1160 p_comm_lines_api_rec.LINE_NUMBER),
1161 BILL_TO_ADDRESS_ID = DECODE(p_comm_lines_api_rec.BILL_TO_ADDRESS_ID,
1162 FND_API.G_MISS_NUM,
1163 oldrec.BILL_TO_ADDRESS_ID,
1164 p_comm_lines_api_rec.BILL_TO_ADDRESS_ID),
1165 SHIP_TO_ADDRESS_ID = DECODE(p_comm_lines_api_rec.SHIP_TO_ADDRESS_ID,
1166 FND_API.G_MISS_NUM,
1167 oldrec.SHIP_TO_ADDRESS_ID,
1168 p_comm_lines_api_rec.SHIP_TO_ADDRESS_ID),
1169 BILL_TO_CONTACT_ID = DECODE(p_comm_lines_api_rec.BILL_TO_CONTACT_ID,
1170 FND_API.G_MISS_NUM,
1171 oldrec.BILL_TO_CONTACT_ID,
1172 p_comm_lines_api_rec.BILL_TO_CONTACT_ID),
1173 SHIP_TO_CONTACT_ID = DECODE(p_comm_lines_api_rec.SHIP_TO_CONTACT_ID,
1174 FND_API.G_MISS_NUM,
1175 oldrec.SHIP_TO_CONTACT_ID,
1176 p_comm_lines_api_rec.SHIP_TO_CONTACT_ID),
1177 ADJ_COMM_LINES_API_ID = DECODE(p_comm_lines_api_rec.ADJ_COMM_LINES_API_ID,
1178 FND_API.G_MISS_NUM,
1179 oldrec.ADJ_COMM_LINES_API_ID,
1180 p_comm_lines_api_rec.ADJ_COMM_LINES_API_ID),
1181 PRE_DEFINED_RC_FLAG = DECODE(p_comm_lines_api_rec.PRE_DEFINED_RC_FLAG,
1182 FND_API.G_MISS_CHAR,
1183 oldrec.PRE_DEFINED_RC_FLAG,
1184 p_comm_lines_api_rec.PRE_DEFINED_RC_FLAG),
1185 ROLLUP_FLAG = DECODE(p_comm_lines_api_rec.ROLLUP_FLAG,
1186 FND_API.G_MISS_CHAR,
1187 oldrec.ROLLUP_FLAG,
1191 oldrec.FORECAST_ID,
1188 p_comm_lines_api_rec.ROLLUP_FLAG),
1189 FORECAST_ID = DECODE(p_comm_lines_api_rec.FORECAST_ID,
1190 FND_API.G_MISS_NUM,
1192 p_comm_lines_api_rec.FORECAST_ID),
1193 UPSIDE_QUANTITY = DECODE(p_comm_lines_api_rec.UPSIDE_QUANTITY,
1194 FND_API.G_MISS_NUM,
1195 oldrec.UPSIDE_QUANTITY,
1196 p_comm_lines_api_rec.UPSIDE_QUANTITY),
1197 UPSIDE_AMOUNT = DECODE(p_comm_lines_api_rec.UPSIDE_AMOUNT,
1198 FND_API.G_MISS_NUM,
1199 oldrec.UPSIDE_AMOUNT,
1200 p_comm_lines_api_rec.UPSIDE_AMOUNT),
1201 UOM_CODE = DECODE(p_comm_lines_api_rec.UOM_CODE,
1202 FND_API.G_MISS_CHAR,
1203 oldrec.UOM_CODE,
1204 p_comm_lines_api_rec.UOM_CODE),
1205 REASON_CODE = DECODE(p_comm_lines_api_rec.REASON_CODE,
1206 FND_API.G_MISS_CHAR,
1207 oldrec.REASON_CODE,
1208 p_comm_lines_api_rec.REASON_CODE),
1209 TYPE = DECODE(p_comm_lines_api_rec.TYPE,
1210 FND_API.G_MISS_CHAR,
1211 oldrec.TYPE,
1212 p_comm_lines_api_rec.TYPE),
1213 PRE_PROCESSED_CODE = DECODE(p_comm_lines_api_rec.PRE_PROCESSED_CODE,
1214 FND_API.G_MISS_CHAR,
1215 oldrec.PRE_PROCESSED_CODE,
1216 p_comm_lines_api_rec.PRE_PROCESSED_CODE),
1217 QUOTA_ID = DECODE(p_comm_lines_api_rec.QUOTA_ID,
1218 FND_API.G_MISS_NUM,
1219 oldrec.QUOTA_ID,
1220 p_comm_lines_api_rec.QUOTA_ID),
1221 SRP_PLAN_ASSIGN_ID = DECODE(p_comm_lines_api_rec.SRP_PLAN_ASSIGN_ID,
1222 FND_API.G_MISS_NUM,
1223 oldrec.SRP_PLAN_ASSIGN_ID,
1224 p_comm_lines_api_rec.SRP_PLAN_ASSIGN_ID),
1225 ROLE_ID = DECODE(p_comm_lines_api_rec.ROLE_ID,
1226 FND_API.G_MISS_NUM,
1227 oldrec.ROLE_ID,
1228 p_comm_lines_api_rec.ROLE_ID),
1229 COMP_GROUP_ID = DECODE(p_comm_lines_api_rec.COMP_GROUP_ID,
1230 FND_API.G_MISS_NUM,
1231 oldrec.COMP_GROUP_ID,
1232 p_comm_lines_api_rec.COMP_GROUP_ID),
1233 COMMISSION_AMOUNT = DECODE(p_comm_lines_api_rec.COMMISSION_AMOUNT,
1234 FND_API.G_MISS_NUM,
1235 oldrec.COMMISSION_AMOUNT,
1236 p_comm_lines_api_rec.COMMISSION_AMOUNT),
1237 EMPLOYEE_NUMBER = DECODE(p_comm_lines_api_rec.EMPLOYEE_NUMBER,
1238 FND_API.G_MISS_CHAR,
1239 oldrec.EMPLOYEE_NUMBER,
1240 p_comm_lines_api_rec.EMPLOYEE_NUMBER),
1241 REVERSAL_FLAG = DECODE(p_comm_lines_api_rec.REVERSAL_FLAG,
1242 FND_API.G_MISS_CHAR,
1243 oldrec.REVERSAL_FLAG,
1244 p_comm_lines_api_rec.REVERSAL_FLAG),
1245 REVERSAL_HEADER_ID = DECODE(p_comm_lines_api_rec.REVERSAL_HEADER_ID,
1246 FND_API.G_MISS_NUM,
1247 oldrec.REVERSAL_HEADER_ID,
1248 p_comm_lines_api_rec.REVERSAL_HEADER_ID),
1249 SALES_CHANNEL = DECODE(p_comm_lines_api_rec.SALES_CHANNEL,
1250 FND_API.G_MISS_CHAR,
1251 oldrec.SALES_CHANNEL,
1252 p_comm_lines_api_rec.SALES_CHANNEL),
1253 OBJECT_VERSION_NUMBER = oldrec.OBJECT_VERSION_NUMBER + 1,
1254 SPLIT_PCT = DECODE(p_comm_lines_api_rec.SPLIT_PCT,
1255 FND_API.G_MISS_NUM,
1256 oldrec.SPLIT_PCT,
1257 p_comm_lines_api_rec.SPLIT_PCT),
1258 SPLIT_STATUS = DECODE(p_comm_lines_api_rec.SPLIT_STATUS,
1259 FND_API.G_MISS_CHAR,
1260 oldrec.SPLIT_STATUS,
1261 p_comm_lines_api_rec.SPLIT_STATUS)
1262 WHERE comm_lines_api_id = p_comm_lines_api_rec.comm_lines_api_id;
1263
1264 IF (SQL%ROWCOUNT=0) THEN
1265 RAISE NO_DATA_FOUND;
1266 END IF;
1267
1268 END update_row;
1269
1270
1271 -- * -------------------------------------------------------------------------*
1272 -- Procedure Name
1273 -- lock_update_row
1274 -- Purpose
1275 -- Main lcok and update procedure
1276 -- Note
1277 -- 1. Object version checking is performed before checking
1278 -- 2. Calling update_row if you don not want object version checking
1279 -- 3. All paramaters are IN parameter.
1280 -- 4. Raise NO_DATA_FOUND exception if no reocrd updated (??)
1281 -- * -------------------------------------------------------------------------*
1282 PROCEDURE lock_update_row
1283 ( p_comm_lines_api_rec IN COMM_LINES_API_REC_TYPE) IS
1284
1285 CURSOR c IS
1286 SELECT object_version_number
1287 FROM CN_COMM_LINES_API
1288 WHERE comm_lines_api_id = p_comm_lines_api_rec.comm_lines_api_id;
1289
1290 tlinfo c%ROWTYPE ;
1291 BEGIN
1292
1293 open c;
1294 fetch c into tlinfo;
1295 if (c%notfound) then
1296 close c;
1297 fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1298 fnd_msg_pub.add;
1299 raise fnd_api.g_exc_unexpected_error;
1300 end if;
1301 close c;
1302
1303 if (tlinfo.object_version_number <> p_comm_lines_api_rec.object_version_number) then
1304 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1305 fnd_msg_pub.add;
1306 raise fnd_api.g_exc_unexpected_error;
1307 end if;
1308 UPDATE CN_COMM_LINES_API oldrec
1309 SET
1310 SALESREP_ID = DECODE(p_comm_lines_api_rec.SALESREP_ID,
1311 FND_API.G_MISS_NUM,
1312 oldrec.SALESREP_ID,
1313 p_comm_lines_api_rec.SALESREP_ID),
1314 PROCESSED_DATE = DECODE(p_comm_lines_api_rec.PROCESSED_DATE,
1315 FND_API.G_MISS_DATE,
1316 oldrec.PROCESSED_DATE,
1317 p_comm_lines_api_rec.PROCESSED_DATE),
1318 PROCESSED_PERIOD_ID = DECODE(p_comm_lines_api_rec.PROCESSED_PERIOD_ID,
1319 FND_API.G_MISS_NUM,
1320 oldrec.PROCESSED_PERIOD_ID,
1321 p_comm_lines_api_rec.PROCESSED_PERIOD_ID),
1322 TRANSACTION_AMOUNT = DECODE(p_comm_lines_api_rec.TRANSACTION_AMOUNT,
1323 FND_API.G_MISS_NUM,
1324 oldrec.TRANSACTION_AMOUNT,
1325 p_comm_lines_api_rec.TRANSACTION_AMOUNT),
1326 TRX_TYPE = DECODE(p_comm_lines_api_rec.TRX_TYPE,
1327 FND_API.G_MISS_CHAR,
1328 oldrec.TRX_TYPE,
1329 p_comm_lines_api_rec.TRX_TYPE),
1330 REVENUE_CLASS_ID = DECODE(p_comm_lines_api_rec.REVENUE_CLASS_ID,
1331 FND_API.G_MISS_NUM,
1332 oldrec.REVENUE_CLASS_ID,
1333 p_comm_lines_api_rec.REVENUE_CLASS_ID),
1334 LOAD_STATUS = DECODE(p_comm_lines_api_rec.LOAD_STATUS,
1335 FND_API.G_MISS_CHAR,
1336 oldrec.LOAD_STATUS,
1337 p_comm_lines_api_rec.LOAD_STATUS),
1338 ATTRIBUTE_CATEGORY = DECODE(p_comm_lines_api_rec.ATTRIBUTE_CATEGORY,
1339 FND_API.G_MISS_CHAR,
1340 oldrec.ATTRIBUTE_CATEGORY,
1341 p_comm_lines_api_rec.ATTRIBUTE_CATEGORY),
1342 ATTRIBUTE1 = DECODE(p_comm_lines_api_rec.ATTRIBUTE1,
1343 FND_API.G_MISS_CHAR,
1344 oldrec.ATTRIBUTE1,
1345 p_comm_lines_api_rec.ATTRIBUTE1),
1346 ATTRIBUTE2 = DECODE(p_comm_lines_api_rec.ATTRIBUTE2,
1347 FND_API.G_MISS_CHAR,
1348 oldrec.ATTRIBUTE2,
1349 p_comm_lines_api_rec.ATTRIBUTE2),
1350 ATTRIBUTE3 = DECODE(p_comm_lines_api_rec.ATTRIBUTE3,
1351 FND_API.G_MISS_CHAR,
1352 oldrec.ATTRIBUTE3,
1353 p_comm_lines_api_rec.ATTRIBUTE3),
1354 ATTRIBUTE4 = DECODE(p_comm_lines_api_rec.ATTRIBUTE4,
1355 FND_API.G_MISS_CHAR,
1356 oldrec.ATTRIBUTE4,
1357 p_comm_lines_api_rec.ATTRIBUTE4),
1358 ATTRIBUTE5 = DECODE(p_comm_lines_api_rec.ATTRIBUTE5,
1359 FND_API.G_MISS_CHAR,
1360 oldrec.ATTRIBUTE5,
1361 p_comm_lines_api_rec.ATTRIBUTE5),
1362 ATTRIBUTE6 = DECODE(p_comm_lines_api_rec.ATTRIBUTE6,
1363 FND_API.G_MISS_CHAR,
1364 oldrec.ATTRIBUTE6,
1365 p_comm_lines_api_rec.ATTRIBUTE6),
1366 ATTRIBUTE7 = DECODE(p_comm_lines_api_rec.ATTRIBUTE7,
1367 FND_API.G_MISS_CHAR,
1368 oldrec.ATTRIBUTE7,
1369 p_comm_lines_api_rec.ATTRIBUTE7),
1370 ATTRIBUTE8 = DECODE(p_comm_lines_api_rec.ATTRIBUTE8,
1374 ATTRIBUTE9 = DECODE(p_comm_lines_api_rec.ATTRIBUTE9,
1371 FND_API.G_MISS_CHAR,
1372 oldrec.ATTRIBUTE8,
1373 p_comm_lines_api_rec.ATTRIBUTE8),
1375 FND_API.G_MISS_CHAR,
1376 oldrec.ATTRIBUTE9,
1377 p_comm_lines_api_rec.ATTRIBUTE9),
1378 ATTRIBUTE10 = DECODE(p_comm_lines_api_rec.ATTRIBUTE10,
1379 FND_API.G_MISS_CHAR,
1380 oldrec.ATTRIBUTE10,
1381 p_comm_lines_api_rec.ATTRIBUTE10),
1382 ATTRIBUTE11 = DECODE(p_comm_lines_api_rec.ATTRIBUTE11,
1383 FND_API.G_MISS_CHAR,
1384 oldrec.ATTRIBUTE11,
1385 p_comm_lines_api_rec.ATTRIBUTE11),
1386 ATTRIBUTE12 = DECODE(p_comm_lines_api_rec.ATTRIBUTE12,
1387 FND_API.G_MISS_CHAR,
1388 oldrec.ATTRIBUTE12,
1389 p_comm_lines_api_rec.ATTRIBUTE12),
1390 ATTRIBUTE13 = DECODE(p_comm_lines_api_rec.ATTRIBUTE13,
1391 FND_API.G_MISS_CHAR,
1392 oldrec.ATTRIBUTE13,
1393 p_comm_lines_api_rec.ATTRIBUTE13),
1394 ATTRIBUTE14 = DECODE(p_comm_lines_api_rec.ATTRIBUTE14,
1395 FND_API.G_MISS_CHAR,
1396 oldrec.ATTRIBUTE14,
1397 p_comm_lines_api_rec.ATTRIBUTE14),
1398 ATTRIBUTE15 = DECODE(p_comm_lines_api_rec.ATTRIBUTE15,
1399 FND_API.G_MISS_CHAR,
1400 oldrec.ATTRIBUTE15,
1401 p_comm_lines_api_rec.ATTRIBUTE15),
1402 ATTRIBUTE16 = DECODE(p_comm_lines_api_rec.ATTRIBUTE16,
1403 FND_API.G_MISS_CHAR,
1404 oldrec.ATTRIBUTE16,
1405 p_comm_lines_api_rec.ATTRIBUTE16),
1406 ATTRIBUTE17 = DECODE(p_comm_lines_api_rec.ATTRIBUTE17,
1407 FND_API.G_MISS_CHAR,
1408 oldrec.ATTRIBUTE17,
1409 p_comm_lines_api_rec.ATTRIBUTE17),
1410 ATTRIBUTE18 = DECODE(p_comm_lines_api_rec.ATTRIBUTE18,
1411 FND_API.G_MISS_CHAR,
1412 oldrec.ATTRIBUTE18,
1413 p_comm_lines_api_rec.ATTRIBUTE18),
1414 ATTRIBUTE19 = DECODE(p_comm_lines_api_rec.ATTRIBUTE19,
1415 FND_API.G_MISS_CHAR,
1416 oldrec.ATTRIBUTE19,
1417 p_comm_lines_api_rec.ATTRIBUTE19),
1418 ATTRIBUTE20 = DECODE(p_comm_lines_api_rec.ATTRIBUTE20,
1419 FND_API.G_MISS_CHAR,
1420 oldrec.ATTRIBUTE20,
1421 p_comm_lines_api_rec.ATTRIBUTE20),
1422 ATTRIBUTE21 = DECODE(p_comm_lines_api_rec.ATTRIBUTE21,
1423 FND_API.G_MISS_CHAR,
1424 oldrec.ATTRIBUTE21,
1425 p_comm_lines_api_rec.ATTRIBUTE21),
1426 ATTRIBUTE22 = DECODE(p_comm_lines_api_rec.ATTRIBUTE22,
1427 FND_API.G_MISS_CHAR,
1428 oldrec.ATTRIBUTE22,
1429 p_comm_lines_api_rec.ATTRIBUTE22),
1430 ATTRIBUTE23 = DECODE(p_comm_lines_api_rec.ATTRIBUTE23,
1431 FND_API.G_MISS_CHAR,
1432 oldrec.ATTRIBUTE23,
1433 p_comm_lines_api_rec.ATTRIBUTE23),
1434 ATTRIBUTE24 = DECODE(p_comm_lines_api_rec.ATTRIBUTE24,
1435 FND_API.G_MISS_CHAR,
1436 oldrec.ATTRIBUTE24,
1437 p_comm_lines_api_rec.ATTRIBUTE24),
1438 ATTRIBUTE25 = DECODE(p_comm_lines_api_rec.ATTRIBUTE25,
1439 FND_API.G_MISS_CHAR,
1440 oldrec.ATTRIBUTE25,
1441 p_comm_lines_api_rec.ATTRIBUTE25),
1442 ATTRIBUTE26 = DECODE(p_comm_lines_api_rec.ATTRIBUTE26,
1443 FND_API.G_MISS_CHAR,
1444 oldrec.ATTRIBUTE26,
1445 p_comm_lines_api_rec.ATTRIBUTE26),
1446 ATTRIBUTE27 = DECODE(p_comm_lines_api_rec.ATTRIBUTE27,
1447 FND_API.G_MISS_CHAR,
1448 oldrec.ATTRIBUTE27,
1449 p_comm_lines_api_rec.ATTRIBUTE27),
1450 ATTRIBUTE28 = DECODE(p_comm_lines_api_rec.ATTRIBUTE28,
1451 FND_API.G_MISS_CHAR,
1452 oldrec.ATTRIBUTE28,
1453 p_comm_lines_api_rec.ATTRIBUTE28),
1454 ATTRIBUTE29 = DECODE(p_comm_lines_api_rec.ATTRIBUTE29,
1455 FND_API.G_MISS_CHAR,
1456 oldrec.ATTRIBUTE29,
1457 p_comm_lines_api_rec.ATTRIBUTE29),
1458 ATTRIBUTE30 = DECODE(p_comm_lines_api_rec.ATTRIBUTE30,
1459 FND_API.G_MISS_CHAR,
1460 oldrec.ATTRIBUTE30,
1461 p_comm_lines_api_rec.ATTRIBUTE30),
1462 ATTRIBUTE31 = DECODE(p_comm_lines_api_rec.ATTRIBUTE31,
1463 FND_API.G_MISS_CHAR,
1464 oldrec.ATTRIBUTE31,
1465 p_comm_lines_api_rec.ATTRIBUTE31),
1466 ATTRIBUTE32 = DECODE(p_comm_lines_api_rec.ATTRIBUTE32,
1467 FND_API.G_MISS_CHAR,
1468 oldrec.ATTRIBUTE32,
1469 p_comm_lines_api_rec.ATTRIBUTE32),
1470 ATTRIBUTE33 = DECODE(p_comm_lines_api_rec.ATTRIBUTE33,
1471 FND_API.G_MISS_CHAR,
1472 oldrec.ATTRIBUTE33,
1473 p_comm_lines_api_rec.ATTRIBUTE33),
1474 ATTRIBUTE34 = DECODE(p_comm_lines_api_rec.ATTRIBUTE34,
1475 FND_API.G_MISS_CHAR,
1476 oldrec.ATTRIBUTE34,
1477 p_comm_lines_api_rec.ATTRIBUTE34),
1478 ATTRIBUTE35 = DECODE(p_comm_lines_api_rec.ATTRIBUTE35,
1479 FND_API.G_MISS_CHAR,
1480 oldrec.ATTRIBUTE35,
1481 p_comm_lines_api_rec.ATTRIBUTE35),
1482 ATTRIBUTE36 = DECODE(p_comm_lines_api_rec.ATTRIBUTE36,
1483 FND_API.G_MISS_CHAR,
1484 oldrec.ATTRIBUTE36,
1485 p_comm_lines_api_rec.ATTRIBUTE36),
1486 ATTRIBUTE37 = DECODE(p_comm_lines_api_rec.ATTRIBUTE37,
1487 FND_API.G_MISS_CHAR,
1488 oldrec.ATTRIBUTE37,
1489 p_comm_lines_api_rec.ATTRIBUTE37),
1490 ATTRIBUTE38 = DECODE(p_comm_lines_api_rec.ATTRIBUTE38,
1491 FND_API.G_MISS_CHAR,
1492 oldrec.ATTRIBUTE38,
1493 p_comm_lines_api_rec.ATTRIBUTE38),
1494 ATTRIBUTE39 = DECODE(p_comm_lines_api_rec.ATTRIBUTE39,
1495 FND_API.G_MISS_CHAR,
1496 oldrec.ATTRIBUTE39,
1497 p_comm_lines_api_rec.ATTRIBUTE39),
1498 ATTRIBUTE40 = DECODE(p_comm_lines_api_rec.ATTRIBUTE40,
1499 FND_API.G_MISS_CHAR,
1500 oldrec.ATTRIBUTE40,
1501 p_comm_lines_api_rec.ATTRIBUTE40),
1502 ATTRIBUTE41 = DECODE(p_comm_lines_api_rec.ATTRIBUTE41,
1503 FND_API.G_MISS_CHAR,
1504 oldrec.ATTRIBUTE41,
1505 p_comm_lines_api_rec.ATTRIBUTE41),
1506 ATTRIBUTE42 = DECODE(p_comm_lines_api_rec.ATTRIBUTE42,
1507 FND_API.G_MISS_CHAR,
1508 oldrec.ATTRIBUTE42,
1509 p_comm_lines_api_rec.ATTRIBUTE42),
1510 ATTRIBUTE43 = DECODE(p_comm_lines_api_rec.ATTRIBUTE43,
1511 FND_API.G_MISS_CHAR,
1512 oldrec.ATTRIBUTE43,
1513 p_comm_lines_api_rec.ATTRIBUTE43),
1514 ATTRIBUTE44 = DECODE(p_comm_lines_api_rec.ATTRIBUTE44,
1515 FND_API.G_MISS_CHAR,
1516 oldrec.ATTRIBUTE44,
1517 p_comm_lines_api_rec.ATTRIBUTE44),
1518 ATTRIBUTE45 = DECODE(p_comm_lines_api_rec.ATTRIBUTE45,
1519 FND_API.G_MISS_CHAR,
1520 oldrec.ATTRIBUTE45,
1521 p_comm_lines_api_rec.ATTRIBUTE45),
1522 ATTRIBUTE46 = DECODE(p_comm_lines_api_rec.ATTRIBUTE46,
1523 FND_API.G_MISS_CHAR,
1524 oldrec.ATTRIBUTE46,
1525 p_comm_lines_api_rec.ATTRIBUTE46),
1526 ATTRIBUTE47 = DECODE(p_comm_lines_api_rec.ATTRIBUTE47,
1527 FND_API.G_MISS_CHAR,
1528 oldrec.ATTRIBUTE47,
1529 p_comm_lines_api_rec.ATTRIBUTE47),
1530 ATTRIBUTE48 = DECODE(p_comm_lines_api_rec.ATTRIBUTE48,
1531 FND_API.G_MISS_CHAR,
1532 oldrec.ATTRIBUTE48,
1533 p_comm_lines_api_rec.ATTRIBUTE48),
1534 ATTRIBUTE49 = DECODE(p_comm_lines_api_rec.ATTRIBUTE49,
1535 FND_API.G_MISS_CHAR,
1536 oldrec.ATTRIBUTE49,
1537 p_comm_lines_api_rec.ATTRIBUTE49),
1538 ATTRIBUTE50 = DECODE(p_comm_lines_api_rec.ATTRIBUTE50,
1539 FND_API.G_MISS_CHAR,
1540 oldrec.ATTRIBUTE50,
1541 p_comm_lines_api_rec.ATTRIBUTE50),
1542 ATTRIBUTE51 = DECODE(p_comm_lines_api_rec.ATTRIBUTE51,
1543 FND_API.G_MISS_CHAR,
1544 oldrec.ATTRIBUTE51,
1545 p_comm_lines_api_rec.ATTRIBUTE51),
1546 ATTRIBUTE52 = DECODE(p_comm_lines_api_rec.ATTRIBUTE52,
1547 FND_API.G_MISS_CHAR,
1548 oldrec.ATTRIBUTE52,
1549 p_comm_lines_api_rec.ATTRIBUTE52),
1550 ATTRIBUTE53 = DECODE(p_comm_lines_api_rec.ATTRIBUTE53,
1551 FND_API.G_MISS_CHAR,
1552 oldrec.ATTRIBUTE53,
1553 p_comm_lines_api_rec.ATTRIBUTE53),
1554 ATTRIBUTE54 = DECODE(p_comm_lines_api_rec.ATTRIBUTE54,
1555 FND_API.G_MISS_CHAR,
1556 oldrec.ATTRIBUTE54,
1557 p_comm_lines_api_rec.ATTRIBUTE54),
1558 ATTRIBUTE55 = DECODE(p_comm_lines_api_rec.ATTRIBUTE55,
1559 FND_API.G_MISS_CHAR,
1560 oldrec.ATTRIBUTE55,
1561 p_comm_lines_api_rec.ATTRIBUTE55),
1562 ATTRIBUTE56 = DECODE(p_comm_lines_api_rec.ATTRIBUTE56,
1563 FND_API.G_MISS_CHAR,
1564 oldrec.ATTRIBUTE56,
1565 p_comm_lines_api_rec.ATTRIBUTE56),
1566 ATTRIBUTE57 = DECODE(p_comm_lines_api_rec.ATTRIBUTE57,
1567 FND_API.G_MISS_CHAR,
1568 oldrec.ATTRIBUTE57,
1569 p_comm_lines_api_rec.ATTRIBUTE57),
1570 ATTRIBUTE58 = DECODE(p_comm_lines_api_rec.ATTRIBUTE58,
1571 FND_API.G_MISS_CHAR,
1572 oldrec.ATTRIBUTE58,
1573 p_comm_lines_api_rec.ATTRIBUTE58),
1574 ATTRIBUTE59 = DECODE(p_comm_lines_api_rec.ATTRIBUTE59,
1575 FND_API.G_MISS_CHAR,
1576 oldrec.ATTRIBUTE59,
1577 p_comm_lines_api_rec.ATTRIBUTE59),
1578 ATTRIBUTE60 = DECODE(p_comm_lines_api_rec.ATTRIBUTE60,
1579 FND_API.G_MISS_CHAR,
1580 oldrec.ATTRIBUTE60,
1581 p_comm_lines_api_rec.ATTRIBUTE60),
1582 ATTRIBUTE61 = DECODE(p_comm_lines_api_rec.ATTRIBUTE61,
1583 FND_API.G_MISS_CHAR,
1584 oldrec.ATTRIBUTE61,
1585 p_comm_lines_api_rec.ATTRIBUTE61),
1586 ATTRIBUTE62 = DECODE(p_comm_lines_api_rec.ATTRIBUTE62,
1587 FND_API.G_MISS_CHAR,
1588 oldrec.ATTRIBUTE62,
1589 p_comm_lines_api_rec.ATTRIBUTE62),
1590 ATTRIBUTE63 = DECODE(p_comm_lines_api_rec.ATTRIBUTE63,
1591 FND_API.G_MISS_CHAR,
1592 oldrec.ATTRIBUTE63,
1593 p_comm_lines_api_rec.ATTRIBUTE63),
1594 ATTRIBUTE64 = DECODE(p_comm_lines_api_rec.ATTRIBUTE64,
1595 FND_API.G_MISS_CHAR,
1596 oldrec.ATTRIBUTE64,
1597 p_comm_lines_api_rec.ATTRIBUTE64),
1598 ATTRIBUTE65 = DECODE(p_comm_lines_api_rec.ATTRIBUTE65,
1599 FND_API.G_MISS_CHAR,
1600 oldrec.ATTRIBUTE65,
1601 p_comm_lines_api_rec.ATTRIBUTE65),
1602 ATTRIBUTE66 = DECODE(p_comm_lines_api_rec.ATTRIBUTE66,
1603 FND_API.G_MISS_CHAR,
1604 oldrec.ATTRIBUTE66,
1605 p_comm_lines_api_rec.ATTRIBUTE66),
1606 ATTRIBUTE67 = DECODE(p_comm_lines_api_rec.ATTRIBUTE67,
1607 FND_API.G_MISS_CHAR,
1608 oldrec.ATTRIBUTE67,
1612 oldrec.ATTRIBUTE68,
1609 p_comm_lines_api_rec.ATTRIBUTE67),
1610 ATTRIBUTE68 = DECODE(p_comm_lines_api_rec.ATTRIBUTE68,
1611 FND_API.G_MISS_CHAR,
1613 p_comm_lines_api_rec.ATTRIBUTE68),
1614 ATTRIBUTE69 = DECODE(p_comm_lines_api_rec.ATTRIBUTE69,
1615 FND_API.G_MISS_CHAR,
1616 oldrec.ATTRIBUTE69,
1617 p_comm_lines_api_rec.ATTRIBUTE69),
1618 ATTRIBUTE70 = DECODE(p_comm_lines_api_rec.ATTRIBUTE70,
1619 FND_API.G_MISS_CHAR,
1620 oldrec.ATTRIBUTE70,
1621 p_comm_lines_api_rec.ATTRIBUTE70),
1622 ATTRIBUTE71 = DECODE(p_comm_lines_api_rec.ATTRIBUTE71,
1623 FND_API.G_MISS_CHAR,
1624 oldrec.ATTRIBUTE71,
1625 p_comm_lines_api_rec.ATTRIBUTE71),
1626 ATTRIBUTE72 = DECODE(p_comm_lines_api_rec.ATTRIBUTE72,
1627 FND_API.G_MISS_CHAR,
1628 oldrec.ATTRIBUTE72,
1629 p_comm_lines_api_rec.ATTRIBUTE72),
1630 ATTRIBUTE73 = DECODE(p_comm_lines_api_rec.ATTRIBUTE73,
1631 FND_API.G_MISS_CHAR,
1632 oldrec.ATTRIBUTE73,
1633 p_comm_lines_api_rec.ATTRIBUTE73),
1634 ATTRIBUTE74 = DECODE(p_comm_lines_api_rec.ATTRIBUTE74,
1635 FND_API.G_MISS_CHAR,
1636 oldrec.ATTRIBUTE74,
1637 p_comm_lines_api_rec.ATTRIBUTE74),
1638 ATTRIBUTE75 = DECODE(p_comm_lines_api_rec.ATTRIBUTE75,
1639 FND_API.G_MISS_CHAR,
1640 oldrec.ATTRIBUTE75,
1641 p_comm_lines_api_rec.ATTRIBUTE75),
1642 ATTRIBUTE76 = DECODE(p_comm_lines_api_rec.ATTRIBUTE76,
1643 FND_API.G_MISS_CHAR,
1644 oldrec.ATTRIBUTE76,
1645 p_comm_lines_api_rec.ATTRIBUTE76),
1646 ATTRIBUTE77 = DECODE(p_comm_lines_api_rec.ATTRIBUTE77,
1647 FND_API.G_MISS_CHAR,
1648 oldrec.ATTRIBUTE77,
1649 p_comm_lines_api_rec.ATTRIBUTE77),
1650 ATTRIBUTE78 = DECODE(p_comm_lines_api_rec.ATTRIBUTE78,
1651 FND_API.G_MISS_CHAR,
1652 oldrec.ATTRIBUTE78,
1653 p_comm_lines_api_rec.ATTRIBUTE78),
1654 ATTRIBUTE79 = DECODE(p_comm_lines_api_rec.ATTRIBUTE79,
1655 FND_API.G_MISS_CHAR,
1656 oldrec.ATTRIBUTE79,
1657 p_comm_lines_api_rec.ATTRIBUTE79),
1658 ATTRIBUTE80 = DECODE(p_comm_lines_api_rec.ATTRIBUTE80,
1659 FND_API.G_MISS_CHAR,
1660 oldrec.ATTRIBUTE80,
1661 p_comm_lines_api_rec.ATTRIBUTE80),
1662 ATTRIBUTE81 = DECODE(p_comm_lines_api_rec.ATTRIBUTE81,
1663 FND_API.G_MISS_CHAR,
1664 oldrec.ATTRIBUTE81,
1665 p_comm_lines_api_rec.ATTRIBUTE81),
1666 ATTRIBUTE82 = DECODE(p_comm_lines_api_rec.ATTRIBUTE82,
1667 FND_API.G_MISS_CHAR,
1668 oldrec.ATTRIBUTE82,
1669 p_comm_lines_api_rec.ATTRIBUTE82),
1670 ATTRIBUTE83 = DECODE(p_comm_lines_api_rec.ATTRIBUTE83,
1671 FND_API.G_MISS_CHAR,
1672 oldrec.ATTRIBUTE83,
1673 p_comm_lines_api_rec.ATTRIBUTE83),
1674 ATTRIBUTE84 = DECODE(p_comm_lines_api_rec.ATTRIBUTE84,
1675 FND_API.G_MISS_CHAR,
1676 oldrec.ATTRIBUTE84,
1677 p_comm_lines_api_rec.ATTRIBUTE84),
1678 ATTRIBUTE85 = DECODE(p_comm_lines_api_rec.ATTRIBUTE85,
1679 FND_API.G_MISS_CHAR,
1680 oldrec.ATTRIBUTE85,
1681 p_comm_lines_api_rec.ATTRIBUTE85),
1682 ATTRIBUTE86 = DECODE(p_comm_lines_api_rec.ATTRIBUTE86,
1683 FND_API.G_MISS_CHAR,
1684 oldrec.ATTRIBUTE86,
1685 p_comm_lines_api_rec.ATTRIBUTE86),
1686 ATTRIBUTE87 = DECODE(p_comm_lines_api_rec.ATTRIBUTE87,
1687 FND_API.G_MISS_CHAR,
1688 oldrec.ATTRIBUTE87,
1689 p_comm_lines_api_rec.ATTRIBUTE87),
1690 ATTRIBUTE88 = DECODE(p_comm_lines_api_rec.ATTRIBUTE88,
1691 FND_API.G_MISS_CHAR,
1692 oldrec.ATTRIBUTE88,
1693 p_comm_lines_api_rec.ATTRIBUTE88),
1694 ATTRIBUTE89 = DECODE(p_comm_lines_api_rec.ATTRIBUTE89,
1695 FND_API.G_MISS_CHAR,
1696 oldrec.ATTRIBUTE89,
1697 p_comm_lines_api_rec.ATTRIBUTE89),
1698 ATTRIBUTE90 = DECODE(p_comm_lines_api_rec.ATTRIBUTE90,
1699 FND_API.G_MISS_CHAR,
1700 oldrec.ATTRIBUTE90,
1701 p_comm_lines_api_rec.ATTRIBUTE90),
1702 ATTRIBUTE91 = DECODE(p_comm_lines_api_rec.ATTRIBUTE91,
1703 FND_API.G_MISS_CHAR,
1704 oldrec.ATTRIBUTE91,
1705 p_comm_lines_api_rec.ATTRIBUTE91),
1706 ATTRIBUTE92 = DECODE(p_comm_lines_api_rec.ATTRIBUTE92,
1707 FND_API.G_MISS_CHAR,
1708 oldrec.ATTRIBUTE92,
1709 p_comm_lines_api_rec.ATTRIBUTE92),
1710 ATTRIBUTE93 = DECODE(p_comm_lines_api_rec.ATTRIBUTE93,
1711 FND_API.G_MISS_CHAR,
1712 oldrec.ATTRIBUTE93,
1713 p_comm_lines_api_rec.ATTRIBUTE93),
1714 ATTRIBUTE94 = DECODE(p_comm_lines_api_rec.ATTRIBUTE94,
1715 FND_API.G_MISS_CHAR,
1716 oldrec.ATTRIBUTE94,
1717 p_comm_lines_api_rec.ATTRIBUTE94),
1718 ATTRIBUTE95 = DECODE(p_comm_lines_api_rec.ATTRIBUTE95,
1719 FND_API.G_MISS_CHAR,
1720 oldrec.ATTRIBUTE95,
1721 p_comm_lines_api_rec.ATTRIBUTE95),
1722 ATTRIBUTE96 = DECODE(p_comm_lines_api_rec.ATTRIBUTE96,
1723 FND_API.G_MISS_CHAR,
1724 oldrec.ATTRIBUTE96,
1725 p_comm_lines_api_rec.ATTRIBUTE96),
1726 ATTRIBUTE97 = DECODE(p_comm_lines_api_rec.ATTRIBUTE97,
1727 FND_API.G_MISS_CHAR,
1728 oldrec.ATTRIBUTE97,
1729 p_comm_lines_api_rec.ATTRIBUTE97),
1730 ATTRIBUTE98 = DECODE(p_comm_lines_api_rec.ATTRIBUTE98,
1731 FND_API.G_MISS_CHAR,
1732 oldrec.ATTRIBUTE98,
1733 p_comm_lines_api_rec.ATTRIBUTE98),
1734 ATTRIBUTE99 = DECODE(p_comm_lines_api_rec.ATTRIBUTE99,
1735 FND_API.G_MISS_CHAR,
1736 oldrec.ATTRIBUTE99,
1737 p_comm_lines_api_rec.ATTRIBUTE99),
1738 ATTRIBUTE100 = DECODE(p_comm_lines_api_rec.ATTRIBUTE100,
1739 FND_API.G_MISS_CHAR,
1740 oldrec.ATTRIBUTE100,
1741 p_comm_lines_api_rec.ATTRIBUTE100),
1742 CONC_BATCH_ID = DECODE(p_comm_lines_api_rec.CONC_BATCH_ID,
1743 FND_API.G_MISS_NUM,
1744 oldrec.CONC_BATCH_ID,
1745 p_comm_lines_api_rec.CONC_BATCH_ID),
1746 PROCESS_BATCH_ID = DECODE(p_comm_lines_api_rec.PROCESS_BATCH_ID,
1747 FND_API.G_MISS_NUM,
1748 oldrec.PROCESS_BATCH_ID,
1749 p_comm_lines_api_rec.PROCESS_BATCH_ID),
1750 SALESREP_NUMBER = DECODE(p_comm_lines_api_rec.SALESREP_NUMBER,
1751 FND_API.G_MISS_NUM,
1752 oldrec.SALESREP_NUMBER,
1753 p_comm_lines_api_rec.SALESREP_NUMBER),
1754 ROLLUP_DATE = DECODE(p_comm_lines_api_rec.ROLLUP_DATE,
1755 FND_API.G_MISS_DATE,
1756 oldrec.ROLLUP_DATE,
1757 p_comm_lines_api_rec.ROLLUP_DATE),
1758 SOURCE_DOC_ID = DECODE(p_comm_lines_api_rec.SOURCE_DOC_ID,
1759 FND_API.G_MISS_NUM,
1760 oldrec.SOURCE_DOC_ID,
1761 p_comm_lines_api_rec.SOURCE_DOC_ID),
1762 SOURCE_DOC_TYPE = DECODE(p_comm_lines_api_rec.SOURCE_DOC_TYPE,
1763 FND_API.G_MISS_CHAR,
1764 oldrec.SOURCE_DOC_TYPE,
1765 p_comm_lines_api_rec.SOURCE_DOC_TYPE),
1766 LAST_UPDATED_BY = fnd_global.user_id,
1767 LAST_UPDATE_DATE = Sysdate,
1768 LAST_UPDATE_LOGIN = fnd_global.login_id,
1769 TRANSACTION_CURRENCY_CODE = DECODE(p_comm_lines_api_rec.TRANSACTION_CURRENCY_CODE,
1770 FND_API.G_MISS_CHAR,
1771 oldrec.TRANSACTION_CURRENCY_CODE,
1772 p_comm_lines_api_rec.TRANSACTION_CURRENCY_CODE),
1773 EXCHANGE_RATE = DECODE(p_comm_lines_api_rec.EXCHANGE_RATE,
1774 FND_API.G_MISS_NUM,
1775 oldrec.EXCHANGE_RATE,
1776 p_comm_lines_api_rec.EXCHANGE_RATE),
1777 ACCTD_TRANSACTION_AMOUNT = DECODE(p_comm_lines_api_rec.ACCTD_TRANSACTION_AMOUNT,
1778 FND_API.G_MISS_NUM,
1779 oldrec.ACCTD_TRANSACTION_AMOUNT,
1780 p_comm_lines_api_rec.ACCTD_TRANSACTION_AMOUNT),
1781 TRX_ID = DECODE(p_comm_lines_api_rec.TRX_ID,
1782 FND_API.G_MISS_NUM,
1783 oldrec.TRX_ID,
1784 p_comm_lines_api_rec.TRX_ID),
1785 TRX_LINE_ID = DECODE(p_comm_lines_api_rec.TRX_LINE_ID,
1786 FND_API.G_MISS_NUM,
1787 oldrec.TRX_LINE_ID,
1788 p_comm_lines_api_rec.TRX_LINE_ID),
1789 TRX_SALES_LINE_ID = DECODE(p_comm_lines_api_rec.TRX_SALES_LINE_ID,
1790 FND_API.G_MISS_NUM,
1791 oldrec.TRX_SALES_LINE_ID,
1792 p_comm_lines_api_rec.TRX_SALES_LINE_ID),
1793 QUANTITY = DECODE(p_comm_lines_api_rec.QUANTITY,
1794 FND_API.G_MISS_NUM,
1795 oldrec.QUANTITY,
1796 p_comm_lines_api_rec.QUANTITY),
1797 SOURCE_TRX_NUMBER = DECODE(p_comm_lines_api_rec.SOURCE_TRX_NUMBER,
1798 FND_API.G_MISS_CHAR,
1799 oldrec.SOURCE_TRX_NUMBER,
1800 p_comm_lines_api_rec.SOURCE_TRX_NUMBER),
1801 DISCOUNT_PERCENTAGE = DECODE(p_comm_lines_api_rec.DISCOUNT_PERCENTAGE,
1802 FND_API.G_MISS_NUM,
1803 oldrec.DISCOUNT_PERCENTAGE,
1804 p_comm_lines_api_rec.DISCOUNT_PERCENTAGE),
1805 MARGIN_PERCENTAGE = DECODE(p_comm_lines_api_rec.MARGIN_PERCENTAGE,
1806 FND_API.G_MISS_NUM,
1807 oldrec.MARGIN_PERCENTAGE,
1808 p_comm_lines_api_rec.MARGIN_PERCENTAGE),
1809 SOURCE_TRX_ID = DECODE(p_comm_lines_api_rec.SOURCE_TRX_ID,
1810 FND_API.G_MISS_NUM,
1811 oldrec.SOURCE_TRX_ID,
1812 p_comm_lines_api_rec.SOURCE_TRX_ID),
1813 SOURCE_TRX_LINE_ID = DECODE(p_comm_lines_api_rec.SOURCE_TRX_LINE_ID,
1814 FND_API.G_MISS_NUM,
1815 oldrec.SOURCE_TRX_LINE_ID,
1816 p_comm_lines_api_rec.SOURCE_TRX_LINE_ID),
1817 SOURCE_TRX_SALES_LINE_ID = DECODE(p_comm_lines_api_rec.SOURCE_TRX_SALES_LINE_ID,
1818 FND_API.G_MISS_NUM,
1819 oldrec.SOURCE_TRX_SALES_LINE_ID,
1820 p_comm_lines_api_rec.SOURCE_TRX_SALES_LINE_ID),
1821 NEGATED_FLAG = DECODE(p_comm_lines_api_rec.NEGATED_FLAG,
1822 FND_API.G_MISS_CHAR,
1823 oldrec.NEGATED_FLAG,
1824 p_comm_lines_api_rec.NEGATED_FLAG),
1825 CUSTOMER_ID = DECODE(p_comm_lines_api_rec.CUSTOMER_ID,
1826 FND_API.G_MISS_NUM,
1827 oldrec.CUSTOMER_ID,
1828 p_comm_lines_api_rec.CUSTOMER_ID),
1829 INVENTORY_ITEM_ID = DECODE(p_comm_lines_api_rec.INVENTORY_ITEM_ID,
1830 FND_API.G_MISS_NUM,
1831 oldrec.INVENTORY_ITEM_ID,
1832 p_comm_lines_api_rec.INVENTORY_ITEM_ID),
1833 ORDER_NUMBER = DECODE(p_comm_lines_api_rec.ORDER_NUMBER,
1834 FND_API.G_MISS_NUM,
1835 oldrec.ORDER_NUMBER,
1836 p_comm_lines_api_rec.ORDER_NUMBER),
1837 BOOKED_DATE = DECODE(p_comm_lines_api_rec.BOOKED_DATE,
1838 FND_API.G_MISS_DATE,
1839 oldrec.BOOKED_DATE,
1840 p_comm_lines_api_rec.BOOKED_DATE),
1841 INVOICE_NUMBER = DECODE(p_comm_lines_api_rec.INVOICE_NUMBER,
1842 FND_API.G_MISS_CHAR,
1846 FND_API.G_MISS_DATE,
1843 oldrec.INVOICE_NUMBER,
1844 p_comm_lines_api_rec.INVOICE_NUMBER),
1845 INVOICE_DATE = DECODE(p_comm_lines_api_rec.INVOICE_DATE,
1847 oldrec.INVOICE_DATE,
1848 p_comm_lines_api_rec.INVOICE_DATE),
1849 ADJUST_DATE = DECODE(p_comm_lines_api_rec.ADJUST_DATE,
1850 FND_API.G_MISS_DATE,
1851 oldrec.ADJUST_DATE,
1852 p_comm_lines_api_rec.ADJUST_DATE),
1853 ADJUSTED_BY = DECODE(p_comm_lines_api_rec.ADJUSTED_BY,
1854 FND_API.G_MISS_CHAR,
1855 oldrec.ADJUSTED_BY,
1856 p_comm_lines_api_rec.ADJUSTED_BY),
1857 REVENUE_TYPE = DECODE(p_comm_lines_api_rec.REVENUE_TYPE,
1858 FND_API.G_MISS_CHAR,
1859 oldrec.REVENUE_TYPE,
1860 p_comm_lines_api_rec.REVENUE_TYPE),
1861 ADJUST_ROLLUP_FLAG = DECODE(p_comm_lines_api_rec.ADJUST_ROLLUP_FLAG,
1862 FND_API.G_MISS_CHAR,
1863 oldrec.ADJUST_ROLLUP_FLAG,
1864 p_comm_lines_api_rec.ADJUST_ROLLUP_FLAG),
1865 ADJUST_COMMENTS = DECODE(p_comm_lines_api_rec.ADJUST_COMMENTS,
1866 FND_API.G_MISS_CHAR,
1867 oldrec.ADJUST_COMMENTS,
1868 p_comm_lines_api_rec.ADJUST_COMMENTS),
1869 ADJUST_STATUS = NVL(DECODE(p_comm_lines_api_rec.ADJUST_STATUS,
1870 FND_API.G_MISS_CHAR,
1871 oldrec.ADJUST_STATUS,
1872 p_comm_lines_api_rec.ADJUST_STATUS),'NEW'),
1873 LINE_NUMBER = DECODE(p_comm_lines_api_rec.LINE_NUMBER,
1874 FND_API.G_MISS_NUM,
1875 oldrec.LINE_NUMBER,
1876 p_comm_lines_api_rec.LINE_NUMBER),
1877 BILL_TO_ADDRESS_ID = DECODE(p_comm_lines_api_rec.BILL_TO_ADDRESS_ID,
1878 FND_API.G_MISS_NUM,
1879 oldrec.BILL_TO_ADDRESS_ID,
1880 p_comm_lines_api_rec.BILL_TO_ADDRESS_ID),
1881 SHIP_TO_ADDRESS_ID = DECODE(p_comm_lines_api_rec.SHIP_TO_ADDRESS_ID,
1882 FND_API.G_MISS_NUM,
1883 oldrec.SHIP_TO_ADDRESS_ID,
1884 p_comm_lines_api_rec.SHIP_TO_ADDRESS_ID),
1885 BILL_TO_CONTACT_ID = DECODE(p_comm_lines_api_rec.BILL_TO_CONTACT_ID,
1886 FND_API.G_MISS_NUM,
1887 oldrec.BILL_TO_CONTACT_ID,
1888 p_comm_lines_api_rec.BILL_TO_CONTACT_ID),
1889 SHIP_TO_CONTACT_ID = DECODE(p_comm_lines_api_rec.SHIP_TO_CONTACT_ID,
1890 FND_API.G_MISS_NUM,
1891 oldrec.SHIP_TO_CONTACT_ID,
1892 p_comm_lines_api_rec.SHIP_TO_CONTACT_ID),
1893 ADJ_COMM_LINES_API_ID = DECODE(p_comm_lines_api_rec.ADJ_COMM_LINES_API_ID,
1894 FND_API.G_MISS_NUM,
1895 oldrec.ADJ_COMM_LINES_API_ID,
1896 p_comm_lines_api_rec.ADJ_COMM_LINES_API_ID),
1897 PRE_DEFINED_RC_FLAG = DECODE(p_comm_lines_api_rec.PRE_DEFINED_RC_FLAG,
1898 FND_API.G_MISS_CHAR,
1899 oldrec.PRE_DEFINED_RC_FLAG,
1900 p_comm_lines_api_rec.PRE_DEFINED_RC_FLAG),
1901 ROLLUP_FLAG = DECODE(p_comm_lines_api_rec.ROLLUP_FLAG,
1902 FND_API.G_MISS_CHAR,
1903 oldrec.ROLLUP_FLAG,
1904 p_comm_lines_api_rec.ROLLUP_FLAG),
1905 FORECAST_ID = DECODE(p_comm_lines_api_rec.FORECAST_ID,
1906 FND_API.G_MISS_NUM,
1907 oldrec.FORECAST_ID,
1908 p_comm_lines_api_rec.FORECAST_ID),
1909 UPSIDE_QUANTITY = DECODE(p_comm_lines_api_rec.UPSIDE_QUANTITY,
1910 FND_API.G_MISS_NUM,
1911 oldrec.UPSIDE_QUANTITY,
1912 p_comm_lines_api_rec.UPSIDE_QUANTITY),
1913 UPSIDE_AMOUNT = DECODE(p_comm_lines_api_rec.UPSIDE_AMOUNT,
1914 FND_API.G_MISS_NUM,
1915 oldrec.UPSIDE_AMOUNT,
1916 p_comm_lines_api_rec.UPSIDE_AMOUNT),
1917 UOM_CODE = DECODE(p_comm_lines_api_rec.UOM_CODE,
1918 FND_API.G_MISS_CHAR,
1919 oldrec.UOM_CODE,
1920 p_comm_lines_api_rec.UOM_CODE),
1921 REASON_CODE = DECODE(p_comm_lines_api_rec.REASON_CODE,
1922 FND_API.G_MISS_CHAR,
1923 oldrec.REASON_CODE,
1924 p_comm_lines_api_rec.REASON_CODE),
1925 TYPE = DECODE(p_comm_lines_api_rec.TYPE,
1926 FND_API.G_MISS_CHAR,
1927 oldrec.TYPE,
1928 p_comm_lines_api_rec.TYPE),
1929 PRE_PROCESSED_CODE = DECODE(p_comm_lines_api_rec.PRE_PROCESSED_CODE,
1930 FND_API.G_MISS_CHAR,
1931 oldrec.PRE_PROCESSED_CODE,
1932 p_comm_lines_api_rec.PRE_PROCESSED_CODE),
1933 QUOTA_ID = DECODE(p_comm_lines_api_rec.QUOTA_ID,
1934 FND_API.G_MISS_NUM,
1935 oldrec.QUOTA_ID,
1936 p_comm_lines_api_rec.QUOTA_ID),
1937 SRP_PLAN_ASSIGN_ID = DECODE(p_comm_lines_api_rec.SRP_PLAN_ASSIGN_ID,
1938 FND_API.G_MISS_NUM,
1939 oldrec.SRP_PLAN_ASSIGN_ID,
1940 p_comm_lines_api_rec.SRP_PLAN_ASSIGN_ID),
1941 ROLE_ID = DECODE(p_comm_lines_api_rec.ROLE_ID,
1942 FND_API.G_MISS_NUM,
1943 oldrec.ROLE_ID,
1944 p_comm_lines_api_rec.ROLE_ID),
1945 COMP_GROUP_ID = DECODE(p_comm_lines_api_rec.COMP_GROUP_ID,
1946 FND_API.G_MISS_NUM,
1947 oldrec.COMP_GROUP_ID,
1948 p_comm_lines_api_rec.COMP_GROUP_ID),
1949 COMMISSION_AMOUNT = DECODE(p_comm_lines_api_rec.COMMISSION_AMOUNT,
1950 FND_API.G_MISS_NUM,
1951 oldrec.COMMISSION_AMOUNT,
1952 p_comm_lines_api_rec.COMMISSION_AMOUNT),
1953 EMPLOYEE_NUMBER = DECODE(p_comm_lines_api_rec.EMPLOYEE_NUMBER,
1954 FND_API.G_MISS_CHAR,
1955 oldrec.EMPLOYEE_NUMBER,
1956 p_comm_lines_api_rec.EMPLOYEE_NUMBER),
1957 REVERSAL_FLAG = DECODE(p_comm_lines_api_rec.REVERSAL_FLAG,
1958 FND_API.G_MISS_CHAR,
1959 oldrec.REVERSAL_FLAG,
1960 p_comm_lines_api_rec.REVERSAL_FLAG),
1961 REVERSAL_HEADER_ID = DECODE(p_comm_lines_api_rec.REVERSAL_HEADER_ID,
1962 FND_API.G_MISS_NUM,
1963 oldrec.REVERSAL_HEADER_ID,
1964 p_comm_lines_api_rec.REVERSAL_HEADER_ID),
1965 SALES_CHANNEL = DECODE(p_comm_lines_api_rec.SALES_CHANNEL,
1966 FND_API.G_MISS_CHAR,
1967 oldrec.SALES_CHANNEL,
1968 p_comm_lines_api_rec.SALES_CHANNEL),
1969 OBJECT_VERSION_NUMBER = oldrec.OBJECT_VERSION_NUMBER + 1,
1970 SPLIT_PCT = DECODE(p_comm_lines_api_rec.SPLIT_PCT,
1971 FND_API.G_MISS_NUM,
1972 oldrec.SPLIT_PCT,
1973 p_comm_lines_api_rec.SPLIT_PCT),
1974 SPLIT_STATUS = DECODE(p_comm_lines_api_rec.SPLIT_STATUS,
1975 FND_API.G_MISS_CHAR,
1976 oldrec.SPLIT_STATUS,
1977 p_comm_lines_api_rec.SPLIT_STATUS)
1978 WHERE comm_lines_api_id = p_comm_lines_api_rec.comm_lines_api_id;
1979
1980 IF (SQL%ROWCOUNT=0) THEN
1981 RAISE NO_DATA_FOUND;
1982 END IF;
1983
1984 END lock_update_row;
1985 -- * -------------------------------------------------------------------------*
1986 -- Procedure Name
1987 -- delete_row
1988 -- Purpose
1989 -- Main lcok and update procedure
1990 -- Note
1991 -- 1. All paramaters are IN parameter.
1992 -- 2. Raise NO_DATA_FOUND exception if no reocrd deleted (??)
1993 -- * -------------------------------------------------------------------------*
1994 PROCEDURE delete_row
1995 (
1996 p_comm_lines_api_id NUMBER
1997 ) IS
1998
1999 BEGIN
2000
2001 DELETE FROM CN_COMM_LINES_API
2002 WHERE comm_lines_api_id = p_comm_lines_api_id;
2003
2004 IF (SQL%ROWCOUNT=0) THEN
2005 RAISE NO_DATA_FOUND;
2006 END IF;
2007
2008 END Delete_row;
2009 --
2010
2011 PROCEDURE negate_record (X_source_trx_id NUMBER,
2012 X_source_trx_line_id NUMBER,
2013 X_source_doc_type VARCHAR2,
2014 x_org_id NUMBER ) IS
2015 --
2016
2017 CURSOR header_cur (l_commission_header_id NUMBER) IS
2018 SELECT a.*,
2019 b.salesrep_number employee_number
2020 FROM cn_commission_headers a,
2021 cn_rs_salesreps b
2022 WHERE a.direct_salesrep_id = b.salesrep_id AND
2026
2023 a.commission_header_id = l_commission_header_id
2024 AND a.org_id = x_org_id
2025 AND a.org_id = b.org_id;
2027 CURSOR api_lines (hid NUMBER,
2028 lid NUMBER,
2029 sd_type VARCHAR2) IS
2030 SELECT *
2031 FROM cn_comm_lines_api
2032 WHERE source_trx_line_id = lid
2033 AND NVL(source_trx_id,-99) = NVL(hid,-99)
2034 AND NVL(source_doc_type,'DUMMY') = NVL(sd_type,'DUMMY')
2035 AND negated_flag IS NULL
2036 AND org_id = x_org_id;
2037
2038 -- PL/SQL tables and records
2039 api_line_rec api_lines%ROWTYPE;
2040 l_api_rec COMM_LINES_API_REC_TYPE;
2041 -- Local variables
2042 x_api_id NUMBER;
2043 l_comm_lines_api_id NUMBER;
2044 l_reversal_header_id NUMBER;
2045 l_adjust_status VARCHAR2(20);
2046 l_quantity NUMBER;
2047 l_trx_type cn_commission_headers.trx_type%TYPE;
2048 l_transaction_amount NUMBER;
2049 l_transaction_amount_orig cn_commission_headers.transaction_amount_orig%TYPE;
2050 l_src_transaction_amount NUMBER;
2051 l_acctd_transaction_amount NUMBER;
2052 l_negate_flag VARCHAR2(1);
2053 l_reversal_flag VARCHAR2(1);
2054 l_adjust_date DATE := SYSDATE;
2055
2056 --
2057 BEGIN
2058
2059 FOR api_line_rec IN api_lines (X_source_trx_id,
2060 X_source_trx_line_id,
2061 X_source_doc_type)
2062 LOOP
2063 --
2064
2065 IF (api_line_rec.load_status = 'LOADED') THEN
2066
2067 BEGIN
2068 SELECT commission_header_id,adjust_status,quantity,trx_type,
2069 transaction_amount,transaction_amount_orig
2070 INTO l_reversal_header_id,l_adjust_status,l_quantity,l_trx_type,
2071 l_transaction_amount,l_transaction_amount_orig
2072 FROM cn_commission_headers
2073 WHERE comm_lines_api_id = api_line_rec.comm_lines_api_id
2074 AND org_id = x_org_id
2075 AND (adjust_status NOT IN ('FROZEN','REVERSAL'))-- OR
2076 -- adjust_status IS NULL)
2077 AND trx_type NOT IN ('ITD','GRP','THR');
2078 --
2079 l_quantity := -1 * l_quantity;
2080 l_src_transaction_amount := -1 * NVL(l_transaction_amount_orig,0);
2081 l_acctd_transaction_amount := -1 * NVL(l_transaction_amount,0);
2082 l_negate_flag := 'Y';
2083 l_adjust_status := 'REVERSAL';
2084 l_reversal_flag := 'Y';
2085 --
2086 UPDATE cn_commission_headers
2087 SET adjust_status = 'FROZEN',
2088 reversal_header_id = l_reversal_header_id,
2089 reversal_flag = l_reversal_flag,
2090 adjust_date = l_adjust_date,
2091 -- clku, update the last updated info
2092 last_update_date = sysdate,
2093 last_updated_by = fnd_global.user_id,
2094 last_update_login = fnd_global.login_id
2095 WHERE comm_lines_api_id = api_line_rec.comm_lines_api_id
2096 AND org_id = x_org_id;
2097
2098 FOR api_curs_rec IN header_cur(l_reversal_header_id)
2099 LOOP
2100 --
2101 SELECT cn_comm_lines_api_s.NEXTVAL
2102 INTO l_comm_lines_api_id
2103 FROM dual;
2104 --
2105 l_api_rec.salesrep_id := api_curs_rec.direct_salesrep_id;
2106 l_api_rec.processed_date := api_curs_rec.processed_date;
2107 l_api_rec.processed_period_id := api_curs_rec.processed_period_id;
2108 l_api_rec.transaction_amount := l_src_transaction_amount;
2109 l_api_rec.trx_type := api_curs_rec.trx_type;
2110 l_api_rec.revenue_class_id := api_curs_rec.revenue_class_id;
2111 l_api_rec.load_status := 'UNLOADED';
2112 l_api_rec.attribute1 := api_curs_rec.attribute1;
2113 l_api_rec.attribute2 := api_curs_rec.attribute2;
2114 l_api_rec.attribute3 := api_curs_rec.attribute3;
2115 l_api_rec.attribute4 := api_curs_rec.attribute4;
2116 l_api_rec.attribute5 := api_curs_rec.attribute5;
2117 l_api_rec.attribute6 := api_curs_rec.attribute6;
2118 l_api_rec.attribute7 := api_curs_rec.attribute7;
2119 l_api_rec.attribute8 := api_curs_rec.attribute8;
2120 l_api_rec.attribute9 := api_curs_rec.attribute9;
2121 l_api_rec.attribute10 := api_curs_rec.attribute10;
2122 l_api_rec.attribute11 := api_curs_rec.attribute11;
2123 l_api_rec.attribute12 := api_curs_rec.attribute12;
2124 l_api_rec.attribute13 := api_curs_rec.attribute13;
2125 l_api_rec.attribute14 := api_curs_rec.attribute14;
2126 l_api_rec.attribute15 := api_curs_rec.attribute15;
2127 l_api_rec.attribute16 := api_curs_rec.attribute16;
2128 l_api_rec.attribute17 := api_curs_rec.attribute17;
2129 l_api_rec.attribute18 := api_curs_rec.attribute18;
2130 l_api_rec.attribute19 := api_curs_rec.attribute19;
2131 l_api_rec.attribute20 := api_curs_rec.attribute20;
2132 l_api_rec.attribute21 := api_curs_rec.attribute21;
2133 l_api_rec.attribute22 := api_curs_rec.attribute22;
2134 l_api_rec.attribute23 := api_curs_rec.attribute23;
2135 l_api_rec.attribute24 := api_curs_rec.attribute24;
2136 l_api_rec.attribute25 := api_curs_rec.attribute25;
2137 l_api_rec.attribute26 := api_curs_rec.attribute26;
2138 l_api_rec.attribute27 := api_curs_rec.attribute27;
2139 l_api_rec.attribute28 := api_curs_rec.attribute28;
2143 l_api_rec.attribute32 := api_curs_rec.attribute32;
2140 l_api_rec.attribute29 := api_curs_rec.attribute29;
2141 l_api_rec.attribute30 := api_curs_rec.attribute30;
2142 l_api_rec.attribute31 := api_curs_rec.attribute31;
2144 l_api_rec.attribute33 := api_curs_rec.attribute33;
2145 l_api_rec.attribute34 := api_curs_rec.attribute34;
2146 l_api_rec.attribute35 := api_curs_rec.attribute35;
2147 l_api_rec.attribute36 := api_curs_rec.attribute36;
2148 l_api_rec.attribute37 := api_curs_rec.attribute37;
2149 l_api_rec.attribute38 := api_curs_rec.attribute38;
2150 l_api_rec.attribute39 := api_curs_rec.attribute39;
2151 l_api_rec.attribute40 := api_curs_rec.attribute40;
2152 l_api_rec.attribute41 := api_curs_rec.attribute41;
2153 l_api_rec.attribute42 := api_curs_rec.attribute42;
2154 l_api_rec.attribute43 := api_curs_rec.attribute43;
2155 l_api_rec.attribute44 := api_curs_rec.attribute44;
2156 l_api_rec.attribute45 := api_curs_rec.attribute45;
2157 l_api_rec.attribute46 := api_curs_rec.attribute46;
2158 l_api_rec.attribute47 := api_curs_rec.attribute47;
2159 l_api_rec.attribute48 := api_curs_rec.attribute48;
2160 l_api_rec.attribute49 := api_curs_rec.attribute49;
2161 l_api_rec.attribute50 := api_curs_rec.attribute50;
2162 l_api_rec.attribute51 := api_curs_rec.attribute51;
2163 l_api_rec.attribute52 := api_curs_rec.attribute52;
2164 l_api_rec.attribute53 := api_curs_rec.attribute53;
2165 l_api_rec.attribute54 := api_curs_rec.attribute54;
2166 l_api_rec.attribute55 := api_curs_rec.attribute55;
2167 l_api_rec.attribute56 := api_curs_rec.attribute56;
2168 l_api_rec.attribute57 := api_curs_rec.attribute57;
2169 l_api_rec.attribute58 := api_curs_rec.attribute58;
2170 l_api_rec.attribute59 := api_curs_rec.attribute59;
2171 l_api_rec.attribute60 := api_curs_rec.attribute60;
2172 l_api_rec.attribute61 := api_curs_rec.attribute61;
2173 l_api_rec.attribute62 := api_curs_rec.attribute62;
2174 l_api_rec.attribute63 := api_curs_rec.attribute63;
2175 l_api_rec.attribute64 := api_curs_rec.attribute64;
2176 l_api_rec.attribute65 := api_curs_rec.attribute65;
2177 l_api_rec.attribute66 := api_curs_rec.attribute66;
2178 l_api_rec.attribute67 := api_curs_rec.attribute67;
2179 l_api_rec.attribute68 := api_curs_rec.attribute68;
2180 l_api_rec.attribute69 := api_curs_rec.attribute69;
2181 l_api_rec.attribute70 := api_curs_rec.attribute70;
2182 l_api_rec.attribute71 := api_curs_rec.attribute71;
2183 l_api_rec.attribute72 := api_curs_rec.attribute72;
2184 l_api_rec.attribute73 := api_curs_rec.attribute73;
2185 l_api_rec.attribute74 := api_curs_rec.attribute74;
2186 l_api_rec.attribute75 := api_curs_rec.attribute75;
2187 l_api_rec.attribute76 := api_curs_rec.attribute76;
2188 l_api_rec.attribute77 := api_curs_rec.attribute77;
2189 l_api_rec.attribute78 := api_curs_rec.attribute78;
2190 l_api_rec.attribute79 := api_curs_rec.attribute79;
2191 l_api_rec.attribute80 := api_curs_rec.attribute80;
2192 l_api_rec.attribute81 := api_curs_rec.attribute81;
2193 l_api_rec.attribute82 := api_curs_rec.attribute82;
2194 l_api_rec.attribute83 := api_curs_rec.attribute83;
2195 l_api_rec.attribute84 := api_curs_rec.attribute84;
2196 l_api_rec.attribute85 := api_curs_rec.attribute85;
2197 l_api_rec.attribute86 := api_curs_rec.attribute86;
2198 l_api_rec.attribute87 := api_curs_rec.attribute87;
2199 l_api_rec.attribute88 := api_curs_rec.attribute88;
2200 l_api_rec.attribute89 := api_curs_rec.attribute89;
2201 l_api_rec.attribute90 := api_curs_rec.attribute90;
2202 l_api_rec.attribute91 := api_curs_rec.attribute91;
2203 l_api_rec.attribute92 := api_curs_rec.attribute92;
2204 l_api_rec.attribute93 := api_curs_rec.attribute93;
2205 l_api_rec.attribute94 := api_curs_rec.attribute94;
2206 l_api_rec.attribute95 := api_curs_rec.attribute95;
2207 l_api_rec.attribute96 := api_curs_rec.attribute96;
2208 l_api_rec.attribute97 := api_curs_rec.attribute97;
2209 l_api_rec.attribute98 := api_curs_rec.attribute98;
2210 l_api_rec.attribute99 := api_curs_rec.attribute99;
2211 l_api_rec.attribute100 := api_curs_rec.attribute100;
2212 l_api_rec.employee_number := api_curs_rec.employee_number;
2213 l_api_rec.comm_lines_api_id := l_comm_lines_api_id;
2214 l_api_rec.conc_batch_id := NULL;
2215 l_api_rec.process_batch_id := NULL;
2216 l_api_rec.salesrep_number := null;
2217 l_api_rec.rollup_date := api_curs_rec.rollup_date;
2218 --l_api_rec.rollup_period_id := NULL;
2219 l_api_rec.source_doc_id := NULL;
2220 l_api_rec.source_doc_type := api_curs_rec.source_doc_type;
2221 l_api_rec.transaction_currency_code := api_curs_rec.orig_currency_code;
2222 l_api_rec.exchange_rate := api_curs_rec.exchange_rate;
2223 l_api_rec.acctd_transaction_amount := l_acctd_transaction_amount;
2224 l_api_rec.trx_id := NULL;
2225 l_api_rec.trx_line_id := NULL;
2226 l_api_rec.trx_sales_line_id := NULL;
2227 l_api_rec.quantity := l_quantity;
2228 l_api_rec.source_trx_number := api_curs_rec.source_trx_number;
2229 l_api_rec.discount_percentage := api_curs_rec.discount_percentage;
2230 l_api_rec.margin_percentage := api_curs_rec.margin_percentage;
2231 l_api_rec.pre_defined_rc_flag := NULL;
2232 l_api_rec.rollup_flag := NULL;
2233 l_api_rec.forecast_id := api_curs_rec.forecast_id;
2234 l_api_rec.upside_quantity := api_curs_rec.upside_quantity;
2235 l_api_rec.upside_amount := api_curs_rec.upside_amount;
2236 l_api_rec.uom_code := api_curs_rec.uom_code;
2237 l_api_rec.source_trx_id := api_curs_rec.source_trx_id;
2238 l_api_rec.source_trx_line_id := api_curs_rec.source_trx_line_id;
2239 l_api_rec.source_trx_sales_line_id := api_curs_rec.source_trx_sales_line_id;
2240 l_api_rec.negated_flag := l_negate_flag;
2241 l_api_rec.customer_id := api_curs_rec.customer_id;
2242 l_api_rec.inventory_item_id := api_curs_rec.inventory_item_id;
2243 l_api_rec.order_number := api_curs_rec.order_number;
2244 l_api_rec.booked_date := api_curs_rec.booked_date;
2245 l_api_rec.invoice_number := api_curs_rec.invoice_number;
2246 l_api_rec.invoice_date := api_curs_rec.invoice_date;
2247 l_api_rec.bill_to_address_id := api_curs_rec.bill_to_address_id;
2248 l_api_rec.ship_to_address_id := api_curs_rec.ship_to_address_id;
2249 l_api_rec.bill_to_contact_id := api_curs_rec.bill_to_contact_id;
2250 l_api_rec.ship_to_contact_id := api_curs_rec.ship_to_contact_id;
2251 l_api_rec.adj_comm_lines_api_id := api_curs_rec.comm_lines_api_id;
2252 l_api_rec.adjust_date := l_adjust_date;
2253 l_api_rec.adjusted_by := api_curs_rec.adjusted_by;
2254 l_api_rec.revenue_type := api_curs_rec.revenue_type;
2255 l_api_rec.adjust_rollup_flag := api_curs_rec.adjust_rollup_flag;
2256 l_api_rec.adjust_comments := api_curs_rec.adjust_comments;
2257 l_api_rec.adjust_status := NVL(l_adjust_status,'NEW');
2258 l_api_rec.line_number := api_curs_rec.line_number;
2259 l_api_rec.reason_code := api_curs_rec.reason_code;
2260 l_api_rec.attribute_category := api_curs_rec.attribute_category;
2261 l_api_rec.type := api_curs_rec.type;
2262 l_api_rec.pre_processed_code := api_curs_rec.pre_processed_code;
2263 l_api_rec.quota_id := api_curs_rec.quota_id;
2264 l_api_rec.srp_plan_assign_id := api_curs_rec.srp_plan_assign_id;
2265 l_api_rec.role_id := api_curs_rec.role_id;
2266 l_api_rec.comp_group_id := api_curs_rec.comp_group_id;
2267 l_api_rec.commission_amount := NULL;
2268 l_api_rec.reversal_flag := l_reversal_flag;
2269 l_api_rec.reversal_header_id := l_reversal_header_id;
2270 l_api_rec.sales_channel := api_curs_rec.sales_channel;
2271 l_api_rec.split_pct := api_curs_rec.split_pct;
2272 l_api_rec.split_status := api_curs_rec.split_status;
2273 l_api_rec.org_id := x_org_id;
2274 --
2275 cn_comm_lines_api_pkg.insert_row(l_api_rec);
2276 --
2277 END LOOP;
2278 EXCEPTION
2279 WHEN OTHERS THEN
2280 NULL;
2281 END;
2282 ELSE
2283 UPDATE cn_comm_lines_api
2284 SET load_status = 'OBSOLETE',
2285 adjust_status = 'FROZEN'
2286 WHERE comm_lines_api_id = api_line_rec.comm_lines_api_id
2287 AND org_id = x_org_id;
2288 END IF;
2289
2290 END LOOP;
2291 END negate_record;
2292 --
2293 END CN_COMM_LINES_API_PKG;
2294
2295