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