254: l_exchange_rate cn_comm_lines_api.exchange_rate%type;
255: --
256: BEGIN
257:
258: IF (p_newtx_rec.exchange_rate <> FND_API.G_MISS_NUM) THEN
259: l_exchange_rate := p_newtx_rec.exchange_rate;
260: ELSE
261: IF ((p_newtx_rec.orig_currency_code = FND_API.G_MISS_CHAR) OR
262: (p_newtx_rec.orig_currency_code = p_old_adj_tbl(1).orig_currency_code))
257:
258: IF (p_newtx_rec.exchange_rate <> FND_API.G_MISS_NUM) THEN
259: l_exchange_rate := p_newtx_rec.exchange_rate;
260: ELSE
261: IF ((p_newtx_rec.orig_currency_code = FND_API.G_MISS_CHAR) OR
262: (p_newtx_rec.orig_currency_code = p_old_adj_tbl(1).orig_currency_code))
263: THEN
264: l_exchange_rate := p_old_adj_tbl(1).exchange_rate;
265: ELSE
268: END IF;
269:
270: SELECT
271:
272: DECODE(p_newtx_rec.direct_salesrep_id,FND_API.G_MISS_NUM,
273: p_old_adj_tbl(1).direct_salesrep_id,p_newtx_rec.direct_salesrep_id),
274: DECODE(p_newtx_rec.inventory_item_id,FND_API.G_MISS_NUM,
275: p_old_adj_tbl(1).inventory_item_id,p_newtx_rec.inventory_item_id),
276: -- Bug fix 5349170
270: SELECT
271:
272: DECODE(p_newtx_rec.direct_salesrep_id,FND_API.G_MISS_NUM,
273: p_old_adj_tbl(1).direct_salesrep_id,p_newtx_rec.direct_salesrep_id),
274: DECODE(p_newtx_rec.inventory_item_id,FND_API.G_MISS_NUM,
275: p_old_adj_tbl(1).inventory_item_id,p_newtx_rec.inventory_item_id),
276: -- Bug fix 5349170
277: DECODE(nvl(p_newtx_rec.source_trx_id,FND_API.G_MISS_num), FND_API.G_MISS_NUM,
278: p_old_adj_tbl(1).source_trx_id,p_newtx_rec.source_trx_id),
273: p_old_adj_tbl(1).direct_salesrep_id,p_newtx_rec.direct_salesrep_id),
274: DECODE(p_newtx_rec.inventory_item_id,FND_API.G_MISS_NUM,
275: p_old_adj_tbl(1).inventory_item_id,p_newtx_rec.inventory_item_id),
276: -- Bug fix 5349170
277: DECODE(nvl(p_newtx_rec.source_trx_id,FND_API.G_MISS_num), FND_API.G_MISS_NUM,
278: p_old_adj_tbl(1).source_trx_id,p_newtx_rec.source_trx_id),
279: DECODE(nvl(p_newtx_rec.source_trx_line_id,FND_API.G_MISS_num), FND_API.G_MISS_NUM,
280: p_old_adj_tbl(1).source_trx_line_id,p_newtx_rec.source_trx_line_id),
281: DECODE(nvl(p_newtx_rec.source_trx_sales_line_id,FND_API.G_MISS_num), FND_API.G_MISS_NUM,
275: p_old_adj_tbl(1).inventory_item_id,p_newtx_rec.inventory_item_id),
276: -- Bug fix 5349170
277: DECODE(nvl(p_newtx_rec.source_trx_id,FND_API.G_MISS_num), FND_API.G_MISS_NUM,
278: p_old_adj_tbl(1).source_trx_id,p_newtx_rec.source_trx_id),
279: DECODE(nvl(p_newtx_rec.source_trx_line_id,FND_API.G_MISS_num), FND_API.G_MISS_NUM,
280: p_old_adj_tbl(1).source_trx_line_id,p_newtx_rec.source_trx_line_id),
281: DECODE(nvl(p_newtx_rec.source_trx_sales_line_id,FND_API.G_MISS_num), FND_API.G_MISS_NUM,
282: p_old_adj_tbl(1).source_trx_sales_line_id,p_newtx_rec.source_trx_sales_line_id),
283: -- Bug fix 5349170
277: DECODE(nvl(p_newtx_rec.source_trx_id,FND_API.G_MISS_num), FND_API.G_MISS_NUM,
278: p_old_adj_tbl(1).source_trx_id,p_newtx_rec.source_trx_id),
279: DECODE(nvl(p_newtx_rec.source_trx_line_id,FND_API.G_MISS_num), FND_API.G_MISS_NUM,
280: p_old_adj_tbl(1).source_trx_line_id,p_newtx_rec.source_trx_line_id),
281: DECODE(nvl(p_newtx_rec.source_trx_sales_line_id,FND_API.G_MISS_num), FND_API.G_MISS_NUM,
282: p_old_adj_tbl(1).source_trx_sales_line_id,p_newtx_rec.source_trx_sales_line_id),
283: -- Bug fix 5349170
284: DECODE(p_newtx_rec.processed_date,FND_API.G_MISS_DATE,
285: p_old_adj_tbl(1).processed_date,p_newtx_rec.processed_date),
280: p_old_adj_tbl(1).source_trx_line_id,p_newtx_rec.source_trx_line_id),
281: DECODE(nvl(p_newtx_rec.source_trx_sales_line_id,FND_API.G_MISS_num), FND_API.G_MISS_NUM,
282: p_old_adj_tbl(1).source_trx_sales_line_id,p_newtx_rec.source_trx_sales_line_id),
283: -- Bug fix 5349170
284: DECODE(p_newtx_rec.processed_date,FND_API.G_MISS_DATE,
285: p_old_adj_tbl(1).processed_date,p_newtx_rec.processed_date),
286: DECODE(p_newtx_rec.transaction_amount,FND_API.G_MISS_NUM,
287: p_old_adj_tbl(1).transaction_amount,p_newtx_rec.transaction_amount),
288: DECODE(p_newtx_rec.trx_type,FND_API.G_MISS_CHAR,
282: p_old_adj_tbl(1).source_trx_sales_line_id,p_newtx_rec.source_trx_sales_line_id),
283: -- Bug fix 5349170
284: DECODE(p_newtx_rec.processed_date,FND_API.G_MISS_DATE,
285: p_old_adj_tbl(1).processed_date,p_newtx_rec.processed_date),
286: DECODE(p_newtx_rec.transaction_amount,FND_API.G_MISS_NUM,
287: p_old_adj_tbl(1).transaction_amount,p_newtx_rec.transaction_amount),
288: DECODE(p_newtx_rec.trx_type,FND_API.G_MISS_CHAR,
289: p_old_adj_tbl(1).trx_type,p_newtx_rec.trx_type),
290: DECODE(p_newtx_rec.revenue_class_id,FND_API.G_MISS_NUM,
284: DECODE(p_newtx_rec.processed_date,FND_API.G_MISS_DATE,
285: p_old_adj_tbl(1).processed_date,p_newtx_rec.processed_date),
286: DECODE(p_newtx_rec.transaction_amount,FND_API.G_MISS_NUM,
287: p_old_adj_tbl(1).transaction_amount,p_newtx_rec.transaction_amount),
288: DECODE(p_newtx_rec.trx_type,FND_API.G_MISS_CHAR,
289: p_old_adj_tbl(1).trx_type,p_newtx_rec.trx_type),
290: DECODE(p_newtx_rec.revenue_class_id,FND_API.G_MISS_NUM,
291: p_old_adj_tbl(1).revenue_class_id,p_newtx_rec.revenue_class_id),
292: 'UNLOADED',
286: DECODE(p_newtx_rec.transaction_amount,FND_API.G_MISS_NUM,
287: p_old_adj_tbl(1).transaction_amount,p_newtx_rec.transaction_amount),
288: DECODE(p_newtx_rec.trx_type,FND_API.G_MISS_CHAR,
289: p_old_adj_tbl(1).trx_type,p_newtx_rec.trx_type),
290: DECODE(p_newtx_rec.revenue_class_id,FND_API.G_MISS_NUM,
291: p_old_adj_tbl(1).revenue_class_id,p_newtx_rec.revenue_class_id),
292: 'UNLOADED',
293: DECODE(p_newtx_rec.attribute_category,FND_API.G_MISS_CHAR,
294: p_old_adj_tbl(1).attribute_category,p_newtx_rec.attribute_category),
289: p_old_adj_tbl(1).trx_type,p_newtx_rec.trx_type),
290: DECODE(p_newtx_rec.revenue_class_id,FND_API.G_MISS_NUM,
291: p_old_adj_tbl(1).revenue_class_id,p_newtx_rec.revenue_class_id),
292: 'UNLOADED',
293: DECODE(p_newtx_rec.attribute_category,FND_API.G_MISS_CHAR,
294: p_old_adj_tbl(1).attribute_category,p_newtx_rec.attribute_category),
295: DECODE(p_newtx_rec.attribute1,FND_API.G_MISS_CHAR,
296: p_old_adj_tbl(1).attribute1,p_newtx_rec.attribute1),
297: DECODE(p_newtx_rec.attribute2,FND_API.G_MISS_CHAR,
291: p_old_adj_tbl(1).revenue_class_id,p_newtx_rec.revenue_class_id),
292: 'UNLOADED',
293: DECODE(p_newtx_rec.attribute_category,FND_API.G_MISS_CHAR,
294: p_old_adj_tbl(1).attribute_category,p_newtx_rec.attribute_category),
295: DECODE(p_newtx_rec.attribute1,FND_API.G_MISS_CHAR,
296: p_old_adj_tbl(1).attribute1,p_newtx_rec.attribute1),
297: DECODE(p_newtx_rec.attribute2,FND_API.G_MISS_CHAR,
298: p_old_adj_tbl(1).attribute2,p_newtx_rec.attribute2),
299: DECODE(p_newtx_rec.attribute3,FND_API.G_MISS_CHAR,
293: DECODE(p_newtx_rec.attribute_category,FND_API.G_MISS_CHAR,
294: p_old_adj_tbl(1).attribute_category,p_newtx_rec.attribute_category),
295: DECODE(p_newtx_rec.attribute1,FND_API.G_MISS_CHAR,
296: p_old_adj_tbl(1).attribute1,p_newtx_rec.attribute1),
297: DECODE(p_newtx_rec.attribute2,FND_API.G_MISS_CHAR,
298: p_old_adj_tbl(1).attribute2,p_newtx_rec.attribute2),
299: DECODE(p_newtx_rec.attribute3,FND_API.G_MISS_CHAR,
300: p_old_adj_tbl(1).attribute3,p_newtx_rec.attribute3),
301: DECODE(p_newtx_rec.attribute4,FND_API.G_MISS_CHAR,
295: DECODE(p_newtx_rec.attribute1,FND_API.G_MISS_CHAR,
296: p_old_adj_tbl(1).attribute1,p_newtx_rec.attribute1),
297: DECODE(p_newtx_rec.attribute2,FND_API.G_MISS_CHAR,
298: p_old_adj_tbl(1).attribute2,p_newtx_rec.attribute2),
299: DECODE(p_newtx_rec.attribute3,FND_API.G_MISS_CHAR,
300: p_old_adj_tbl(1).attribute3,p_newtx_rec.attribute3),
301: DECODE(p_newtx_rec.attribute4,FND_API.G_MISS_CHAR,
302: p_old_adj_tbl(1).attribute4,p_newtx_rec.attribute4),
303: DECODE(p_newtx_rec.attribute5,FND_API.G_MISS_CHAR,
297: DECODE(p_newtx_rec.attribute2,FND_API.G_MISS_CHAR,
298: p_old_adj_tbl(1).attribute2,p_newtx_rec.attribute2),
299: DECODE(p_newtx_rec.attribute3,FND_API.G_MISS_CHAR,
300: p_old_adj_tbl(1).attribute3,p_newtx_rec.attribute3),
301: DECODE(p_newtx_rec.attribute4,FND_API.G_MISS_CHAR,
302: p_old_adj_tbl(1).attribute4,p_newtx_rec.attribute4),
303: DECODE(p_newtx_rec.attribute5,FND_API.G_MISS_CHAR,
304: p_old_adj_tbl(1).attribute5,p_newtx_rec.attribute5),
305: DECODE(p_newtx_rec.attribute6,FND_API.G_MISS_CHAR,
299: DECODE(p_newtx_rec.attribute3,FND_API.G_MISS_CHAR,
300: p_old_adj_tbl(1).attribute3,p_newtx_rec.attribute3),
301: DECODE(p_newtx_rec.attribute4,FND_API.G_MISS_CHAR,
302: p_old_adj_tbl(1).attribute4,p_newtx_rec.attribute4),
303: DECODE(p_newtx_rec.attribute5,FND_API.G_MISS_CHAR,
304: p_old_adj_tbl(1).attribute5,p_newtx_rec.attribute5),
305: DECODE(p_newtx_rec.attribute6,FND_API.G_MISS_CHAR,
306: p_old_adj_tbl(1).attribute6,p_newtx_rec.attribute6),
307: DECODE(p_newtx_rec.attribute7,FND_API.G_MISS_CHAR,
301: DECODE(p_newtx_rec.attribute4,FND_API.G_MISS_CHAR,
302: p_old_adj_tbl(1).attribute4,p_newtx_rec.attribute4),
303: DECODE(p_newtx_rec.attribute5,FND_API.G_MISS_CHAR,
304: p_old_adj_tbl(1).attribute5,p_newtx_rec.attribute5),
305: DECODE(p_newtx_rec.attribute6,FND_API.G_MISS_CHAR,
306: p_old_adj_tbl(1).attribute6,p_newtx_rec.attribute6),
307: DECODE(p_newtx_rec.attribute7,FND_API.G_MISS_CHAR,
308: p_old_adj_tbl(1).attribute7,p_newtx_rec.attribute7),
309: DECODE(p_newtx_rec.attribute8,FND_API.G_MISS_CHAR,
303: DECODE(p_newtx_rec.attribute5,FND_API.G_MISS_CHAR,
304: p_old_adj_tbl(1).attribute5,p_newtx_rec.attribute5),
305: DECODE(p_newtx_rec.attribute6,FND_API.G_MISS_CHAR,
306: p_old_adj_tbl(1).attribute6,p_newtx_rec.attribute6),
307: DECODE(p_newtx_rec.attribute7,FND_API.G_MISS_CHAR,
308: p_old_adj_tbl(1).attribute7,p_newtx_rec.attribute7),
309: DECODE(p_newtx_rec.attribute8,FND_API.G_MISS_CHAR,
310: p_old_adj_tbl(1).attribute8,p_newtx_rec.attribute8),
311: DECODE(p_newtx_rec.attribute9,FND_API.G_MISS_CHAR,
305: DECODE(p_newtx_rec.attribute6,FND_API.G_MISS_CHAR,
306: p_old_adj_tbl(1).attribute6,p_newtx_rec.attribute6),
307: DECODE(p_newtx_rec.attribute7,FND_API.G_MISS_CHAR,
308: p_old_adj_tbl(1).attribute7,p_newtx_rec.attribute7),
309: DECODE(p_newtx_rec.attribute8,FND_API.G_MISS_CHAR,
310: p_old_adj_tbl(1).attribute8,p_newtx_rec.attribute8),
311: DECODE(p_newtx_rec.attribute9,FND_API.G_MISS_CHAR,
312: p_old_adj_tbl(1).attribute9,p_newtx_rec.attribute9),
313: DECODE(p_newtx_rec.attribute10,FND_API.G_MISS_CHAR,
307: DECODE(p_newtx_rec.attribute7,FND_API.G_MISS_CHAR,
308: p_old_adj_tbl(1).attribute7,p_newtx_rec.attribute7),
309: DECODE(p_newtx_rec.attribute8,FND_API.G_MISS_CHAR,
310: p_old_adj_tbl(1).attribute8,p_newtx_rec.attribute8),
311: DECODE(p_newtx_rec.attribute9,FND_API.G_MISS_CHAR,
312: p_old_adj_tbl(1).attribute9,p_newtx_rec.attribute9),
313: DECODE(p_newtx_rec.attribute10,FND_API.G_MISS_CHAR,
314: p_old_adj_tbl(1).attribute10,p_newtx_rec.attribute10),
315: DECODE(p_newtx_rec.attribute11,FND_API.G_MISS_CHAR,
309: DECODE(p_newtx_rec.attribute8,FND_API.G_MISS_CHAR,
310: p_old_adj_tbl(1).attribute8,p_newtx_rec.attribute8),
311: DECODE(p_newtx_rec.attribute9,FND_API.G_MISS_CHAR,
312: p_old_adj_tbl(1).attribute9,p_newtx_rec.attribute9),
313: DECODE(p_newtx_rec.attribute10,FND_API.G_MISS_CHAR,
314: p_old_adj_tbl(1).attribute10,p_newtx_rec.attribute10),
315: DECODE(p_newtx_rec.attribute11,FND_API.G_MISS_CHAR,
316: p_old_adj_tbl(1).attribute11,p_newtx_rec.attribute11),
317: DECODE(p_newtx_rec.attribute12,FND_API.G_MISS_CHAR,
311: DECODE(p_newtx_rec.attribute9,FND_API.G_MISS_CHAR,
312: p_old_adj_tbl(1).attribute9,p_newtx_rec.attribute9),
313: DECODE(p_newtx_rec.attribute10,FND_API.G_MISS_CHAR,
314: p_old_adj_tbl(1).attribute10,p_newtx_rec.attribute10),
315: DECODE(p_newtx_rec.attribute11,FND_API.G_MISS_CHAR,
316: p_old_adj_tbl(1).attribute11,p_newtx_rec.attribute11),
317: DECODE(p_newtx_rec.attribute12,FND_API.G_MISS_CHAR,
318: p_old_adj_tbl(1).attribute12,p_newtx_rec.attribute12),
319: DECODE(p_newtx_rec.attribute13,FND_API.G_MISS_CHAR,
313: DECODE(p_newtx_rec.attribute10,FND_API.G_MISS_CHAR,
314: p_old_adj_tbl(1).attribute10,p_newtx_rec.attribute10),
315: DECODE(p_newtx_rec.attribute11,FND_API.G_MISS_CHAR,
316: p_old_adj_tbl(1).attribute11,p_newtx_rec.attribute11),
317: DECODE(p_newtx_rec.attribute12,FND_API.G_MISS_CHAR,
318: p_old_adj_tbl(1).attribute12,p_newtx_rec.attribute12),
319: DECODE(p_newtx_rec.attribute13,FND_API.G_MISS_CHAR,
320: p_old_adj_tbl(1).attribute13,p_newtx_rec.attribute13),
321: DECODE(p_newtx_rec.attribute14,FND_API.G_MISS_CHAR,
315: DECODE(p_newtx_rec.attribute11,FND_API.G_MISS_CHAR,
316: p_old_adj_tbl(1).attribute11,p_newtx_rec.attribute11),
317: DECODE(p_newtx_rec.attribute12,FND_API.G_MISS_CHAR,
318: p_old_adj_tbl(1).attribute12,p_newtx_rec.attribute12),
319: DECODE(p_newtx_rec.attribute13,FND_API.G_MISS_CHAR,
320: p_old_adj_tbl(1).attribute13,p_newtx_rec.attribute13),
321: DECODE(p_newtx_rec.attribute14,FND_API.G_MISS_CHAR,
322: p_old_adj_tbl(1).attribute14,p_newtx_rec.attribute14),
323: DECODE(p_newtx_rec.attribute15,FND_API.G_MISS_CHAR,
317: DECODE(p_newtx_rec.attribute12,FND_API.G_MISS_CHAR,
318: p_old_adj_tbl(1).attribute12,p_newtx_rec.attribute12),
319: DECODE(p_newtx_rec.attribute13,FND_API.G_MISS_CHAR,
320: p_old_adj_tbl(1).attribute13,p_newtx_rec.attribute13),
321: DECODE(p_newtx_rec.attribute14,FND_API.G_MISS_CHAR,
322: p_old_adj_tbl(1).attribute14,p_newtx_rec.attribute14),
323: DECODE(p_newtx_rec.attribute15,FND_API.G_MISS_CHAR,
324: p_old_adj_tbl(1).attribute15,p_newtx_rec.attribute15),
325: DECODE(p_newtx_rec.attribute16,FND_API.G_MISS_CHAR,
319: DECODE(p_newtx_rec.attribute13,FND_API.G_MISS_CHAR,
320: p_old_adj_tbl(1).attribute13,p_newtx_rec.attribute13),
321: DECODE(p_newtx_rec.attribute14,FND_API.G_MISS_CHAR,
322: p_old_adj_tbl(1).attribute14,p_newtx_rec.attribute14),
323: DECODE(p_newtx_rec.attribute15,FND_API.G_MISS_CHAR,
324: p_old_adj_tbl(1).attribute15,p_newtx_rec.attribute15),
325: DECODE(p_newtx_rec.attribute16,FND_API.G_MISS_CHAR,
326: p_old_adj_tbl(1).attribute16,p_newtx_rec.attribute16),
327: DECODE(p_newtx_rec.attribute17,FND_API.G_MISS_CHAR,
321: DECODE(p_newtx_rec.attribute14,FND_API.G_MISS_CHAR,
322: p_old_adj_tbl(1).attribute14,p_newtx_rec.attribute14),
323: DECODE(p_newtx_rec.attribute15,FND_API.G_MISS_CHAR,
324: p_old_adj_tbl(1).attribute15,p_newtx_rec.attribute15),
325: DECODE(p_newtx_rec.attribute16,FND_API.G_MISS_CHAR,
326: p_old_adj_tbl(1).attribute16,p_newtx_rec.attribute16),
327: DECODE(p_newtx_rec.attribute17,FND_API.G_MISS_CHAR,
328: p_old_adj_tbl(1).attribute17,p_newtx_rec.attribute17),
329: DECODE(p_newtx_rec.attribute18,FND_API.G_MISS_CHAR,
323: DECODE(p_newtx_rec.attribute15,FND_API.G_MISS_CHAR,
324: p_old_adj_tbl(1).attribute15,p_newtx_rec.attribute15),
325: DECODE(p_newtx_rec.attribute16,FND_API.G_MISS_CHAR,
326: p_old_adj_tbl(1).attribute16,p_newtx_rec.attribute16),
327: DECODE(p_newtx_rec.attribute17,FND_API.G_MISS_CHAR,
328: p_old_adj_tbl(1).attribute17,p_newtx_rec.attribute17),
329: DECODE(p_newtx_rec.attribute18,FND_API.G_MISS_CHAR,
330: p_old_adj_tbl(1).attribute18,p_newtx_rec.attribute18),
331: DECODE(p_newtx_rec.attribute19,FND_API.G_MISS_CHAR,
325: DECODE(p_newtx_rec.attribute16,FND_API.G_MISS_CHAR,
326: p_old_adj_tbl(1).attribute16,p_newtx_rec.attribute16),
327: DECODE(p_newtx_rec.attribute17,FND_API.G_MISS_CHAR,
328: p_old_adj_tbl(1).attribute17,p_newtx_rec.attribute17),
329: DECODE(p_newtx_rec.attribute18,FND_API.G_MISS_CHAR,
330: p_old_adj_tbl(1).attribute18,p_newtx_rec.attribute18),
331: DECODE(p_newtx_rec.attribute19,FND_API.G_MISS_CHAR,
332: p_old_adj_tbl(1).attribute19,p_newtx_rec.attribute19),
333: DECODE(p_newtx_rec.attribute20,FND_API.G_MISS_CHAR,
327: DECODE(p_newtx_rec.attribute17,FND_API.G_MISS_CHAR,
328: p_old_adj_tbl(1).attribute17,p_newtx_rec.attribute17),
329: DECODE(p_newtx_rec.attribute18,FND_API.G_MISS_CHAR,
330: p_old_adj_tbl(1).attribute18,p_newtx_rec.attribute18),
331: DECODE(p_newtx_rec.attribute19,FND_API.G_MISS_CHAR,
332: p_old_adj_tbl(1).attribute19,p_newtx_rec.attribute19),
333: DECODE(p_newtx_rec.attribute20,FND_API.G_MISS_CHAR,
334: p_old_adj_tbl(1).attribute20,p_newtx_rec.attribute20),
335: DECODE(p_newtx_rec.attribute21,FND_API.G_MISS_CHAR,
329: DECODE(p_newtx_rec.attribute18,FND_API.G_MISS_CHAR,
330: p_old_adj_tbl(1).attribute18,p_newtx_rec.attribute18),
331: DECODE(p_newtx_rec.attribute19,FND_API.G_MISS_CHAR,
332: p_old_adj_tbl(1).attribute19,p_newtx_rec.attribute19),
333: DECODE(p_newtx_rec.attribute20,FND_API.G_MISS_CHAR,
334: p_old_adj_tbl(1).attribute20,p_newtx_rec.attribute20),
335: DECODE(p_newtx_rec.attribute21,FND_API.G_MISS_CHAR,
336: p_old_adj_tbl(1).attribute21,p_newtx_rec.attribute21),
337: DECODE(p_newtx_rec.attribute22,FND_API.G_MISS_CHAR,
331: DECODE(p_newtx_rec.attribute19,FND_API.G_MISS_CHAR,
332: p_old_adj_tbl(1).attribute19,p_newtx_rec.attribute19),
333: DECODE(p_newtx_rec.attribute20,FND_API.G_MISS_CHAR,
334: p_old_adj_tbl(1).attribute20,p_newtx_rec.attribute20),
335: DECODE(p_newtx_rec.attribute21,FND_API.G_MISS_CHAR,
336: p_old_adj_tbl(1).attribute21,p_newtx_rec.attribute21),
337: DECODE(p_newtx_rec.attribute22,FND_API.G_MISS_CHAR,
338: p_old_adj_tbl(1).attribute22,p_newtx_rec.attribute22),
339: DECODE(p_newtx_rec.attribute23,FND_API.G_MISS_CHAR,
333: DECODE(p_newtx_rec.attribute20,FND_API.G_MISS_CHAR,
334: p_old_adj_tbl(1).attribute20,p_newtx_rec.attribute20),
335: DECODE(p_newtx_rec.attribute21,FND_API.G_MISS_CHAR,
336: p_old_adj_tbl(1).attribute21,p_newtx_rec.attribute21),
337: DECODE(p_newtx_rec.attribute22,FND_API.G_MISS_CHAR,
338: p_old_adj_tbl(1).attribute22,p_newtx_rec.attribute22),
339: DECODE(p_newtx_rec.attribute23,FND_API.G_MISS_CHAR,
340: p_old_adj_tbl(1).attribute23,p_newtx_rec.attribute23),
341: DECODE(p_newtx_rec.attribute24,FND_API.G_MISS_CHAR,
335: DECODE(p_newtx_rec.attribute21,FND_API.G_MISS_CHAR,
336: p_old_adj_tbl(1).attribute21,p_newtx_rec.attribute21),
337: DECODE(p_newtx_rec.attribute22,FND_API.G_MISS_CHAR,
338: p_old_adj_tbl(1).attribute22,p_newtx_rec.attribute22),
339: DECODE(p_newtx_rec.attribute23,FND_API.G_MISS_CHAR,
340: p_old_adj_tbl(1).attribute23,p_newtx_rec.attribute23),
341: DECODE(p_newtx_rec.attribute24,FND_API.G_MISS_CHAR,
342: p_old_adj_tbl(1).attribute24,p_newtx_rec.attribute24),
343: DECODE(p_newtx_rec.attribute25,FND_API.G_MISS_CHAR,
337: DECODE(p_newtx_rec.attribute22,FND_API.G_MISS_CHAR,
338: p_old_adj_tbl(1).attribute22,p_newtx_rec.attribute22),
339: DECODE(p_newtx_rec.attribute23,FND_API.G_MISS_CHAR,
340: p_old_adj_tbl(1).attribute23,p_newtx_rec.attribute23),
341: DECODE(p_newtx_rec.attribute24,FND_API.G_MISS_CHAR,
342: p_old_adj_tbl(1).attribute24,p_newtx_rec.attribute24),
343: DECODE(p_newtx_rec.attribute25,FND_API.G_MISS_CHAR,
344: p_old_adj_tbl(1).attribute25,p_newtx_rec.attribute25),
345: DECODE(p_newtx_rec.attribute26,FND_API.G_MISS_CHAR,
339: DECODE(p_newtx_rec.attribute23,FND_API.G_MISS_CHAR,
340: p_old_adj_tbl(1).attribute23,p_newtx_rec.attribute23),
341: DECODE(p_newtx_rec.attribute24,FND_API.G_MISS_CHAR,
342: p_old_adj_tbl(1).attribute24,p_newtx_rec.attribute24),
343: DECODE(p_newtx_rec.attribute25,FND_API.G_MISS_CHAR,
344: p_old_adj_tbl(1).attribute25,p_newtx_rec.attribute25),
345: DECODE(p_newtx_rec.attribute26,FND_API.G_MISS_CHAR,
346: p_old_adj_tbl(1).attribute26,p_newtx_rec.attribute26),
347: DECODE(p_newtx_rec.attribute27,FND_API.G_MISS_CHAR,
341: DECODE(p_newtx_rec.attribute24,FND_API.G_MISS_CHAR,
342: p_old_adj_tbl(1).attribute24,p_newtx_rec.attribute24),
343: DECODE(p_newtx_rec.attribute25,FND_API.G_MISS_CHAR,
344: p_old_adj_tbl(1).attribute25,p_newtx_rec.attribute25),
345: DECODE(p_newtx_rec.attribute26,FND_API.G_MISS_CHAR,
346: p_old_adj_tbl(1).attribute26,p_newtx_rec.attribute26),
347: DECODE(p_newtx_rec.attribute27,FND_API.G_MISS_CHAR,
348: p_old_adj_tbl(1).attribute27,p_newtx_rec.attribute27),
349: DECODE(p_newtx_rec.attribute28,FND_API.G_MISS_CHAR,
343: DECODE(p_newtx_rec.attribute25,FND_API.G_MISS_CHAR,
344: p_old_adj_tbl(1).attribute25,p_newtx_rec.attribute25),
345: DECODE(p_newtx_rec.attribute26,FND_API.G_MISS_CHAR,
346: p_old_adj_tbl(1).attribute26,p_newtx_rec.attribute26),
347: DECODE(p_newtx_rec.attribute27,FND_API.G_MISS_CHAR,
348: p_old_adj_tbl(1).attribute27,p_newtx_rec.attribute27),
349: DECODE(p_newtx_rec.attribute28,FND_API.G_MISS_CHAR,
350: p_old_adj_tbl(1).attribute28,p_newtx_rec.attribute28),
351: DECODE(p_newtx_rec.attribute29,FND_API.G_MISS_CHAR,
345: DECODE(p_newtx_rec.attribute26,FND_API.G_MISS_CHAR,
346: p_old_adj_tbl(1).attribute26,p_newtx_rec.attribute26),
347: DECODE(p_newtx_rec.attribute27,FND_API.G_MISS_CHAR,
348: p_old_adj_tbl(1).attribute27,p_newtx_rec.attribute27),
349: DECODE(p_newtx_rec.attribute28,FND_API.G_MISS_CHAR,
350: p_old_adj_tbl(1).attribute28,p_newtx_rec.attribute28),
351: DECODE(p_newtx_rec.attribute29,FND_API.G_MISS_CHAR,
352: p_old_adj_tbl(1).attribute29,p_newtx_rec.attribute29),
353: DECODE(p_newtx_rec.attribute30,FND_API.G_MISS_CHAR,
347: DECODE(p_newtx_rec.attribute27,FND_API.G_MISS_CHAR,
348: p_old_adj_tbl(1).attribute27,p_newtx_rec.attribute27),
349: DECODE(p_newtx_rec.attribute28,FND_API.G_MISS_CHAR,
350: p_old_adj_tbl(1).attribute28,p_newtx_rec.attribute28),
351: DECODE(p_newtx_rec.attribute29,FND_API.G_MISS_CHAR,
352: p_old_adj_tbl(1).attribute29,p_newtx_rec.attribute29),
353: DECODE(p_newtx_rec.attribute30,FND_API.G_MISS_CHAR,
354: p_old_adj_tbl(1).attribute30,p_newtx_rec.attribute30),
355: DECODE(p_newtx_rec.attribute31,FND_API.G_MISS_CHAR,
349: DECODE(p_newtx_rec.attribute28,FND_API.G_MISS_CHAR,
350: p_old_adj_tbl(1).attribute28,p_newtx_rec.attribute28),
351: DECODE(p_newtx_rec.attribute29,FND_API.G_MISS_CHAR,
352: p_old_adj_tbl(1).attribute29,p_newtx_rec.attribute29),
353: DECODE(p_newtx_rec.attribute30,FND_API.G_MISS_CHAR,
354: p_old_adj_tbl(1).attribute30,p_newtx_rec.attribute30),
355: DECODE(p_newtx_rec.attribute31,FND_API.G_MISS_CHAR,
356: p_old_adj_tbl(1).attribute31,p_newtx_rec.attribute31),
357: DECODE(p_newtx_rec.attribute32,FND_API.G_MISS_CHAR,
351: DECODE(p_newtx_rec.attribute29,FND_API.G_MISS_CHAR,
352: p_old_adj_tbl(1).attribute29,p_newtx_rec.attribute29),
353: DECODE(p_newtx_rec.attribute30,FND_API.G_MISS_CHAR,
354: p_old_adj_tbl(1).attribute30,p_newtx_rec.attribute30),
355: DECODE(p_newtx_rec.attribute31,FND_API.G_MISS_CHAR,
356: p_old_adj_tbl(1).attribute31,p_newtx_rec.attribute31),
357: DECODE(p_newtx_rec.attribute32,FND_API.G_MISS_CHAR,
358: p_old_adj_tbl(1).attribute32,p_newtx_rec.attribute32),
359: DECODE(p_newtx_rec.attribute33,FND_API.G_MISS_CHAR,
353: DECODE(p_newtx_rec.attribute30,FND_API.G_MISS_CHAR,
354: p_old_adj_tbl(1).attribute30,p_newtx_rec.attribute30),
355: DECODE(p_newtx_rec.attribute31,FND_API.G_MISS_CHAR,
356: p_old_adj_tbl(1).attribute31,p_newtx_rec.attribute31),
357: DECODE(p_newtx_rec.attribute32,FND_API.G_MISS_CHAR,
358: p_old_adj_tbl(1).attribute32,p_newtx_rec.attribute32),
359: DECODE(p_newtx_rec.attribute33,FND_API.G_MISS_CHAR,
360: p_old_adj_tbl(1).attribute33,p_newtx_rec.attribute33),
361: DECODE(p_newtx_rec.attribute34,FND_API.G_MISS_CHAR,
355: DECODE(p_newtx_rec.attribute31,FND_API.G_MISS_CHAR,
356: p_old_adj_tbl(1).attribute31,p_newtx_rec.attribute31),
357: DECODE(p_newtx_rec.attribute32,FND_API.G_MISS_CHAR,
358: p_old_adj_tbl(1).attribute32,p_newtx_rec.attribute32),
359: DECODE(p_newtx_rec.attribute33,FND_API.G_MISS_CHAR,
360: p_old_adj_tbl(1).attribute33,p_newtx_rec.attribute33),
361: DECODE(p_newtx_rec.attribute34,FND_API.G_MISS_CHAR,
362: p_old_adj_tbl(1).attribute34,p_newtx_rec.attribute34),
363: DECODE(p_newtx_rec.attribute35,FND_API.G_MISS_CHAR,
357: DECODE(p_newtx_rec.attribute32,FND_API.G_MISS_CHAR,
358: p_old_adj_tbl(1).attribute32,p_newtx_rec.attribute32),
359: DECODE(p_newtx_rec.attribute33,FND_API.G_MISS_CHAR,
360: p_old_adj_tbl(1).attribute33,p_newtx_rec.attribute33),
361: DECODE(p_newtx_rec.attribute34,FND_API.G_MISS_CHAR,
362: p_old_adj_tbl(1).attribute34,p_newtx_rec.attribute34),
363: DECODE(p_newtx_rec.attribute35,FND_API.G_MISS_CHAR,
364: p_old_adj_tbl(1).attribute35,p_newtx_rec.attribute35),
365: DECODE(p_newtx_rec.attribute36,FND_API.G_MISS_CHAR,
359: DECODE(p_newtx_rec.attribute33,FND_API.G_MISS_CHAR,
360: p_old_adj_tbl(1).attribute33,p_newtx_rec.attribute33),
361: DECODE(p_newtx_rec.attribute34,FND_API.G_MISS_CHAR,
362: p_old_adj_tbl(1).attribute34,p_newtx_rec.attribute34),
363: DECODE(p_newtx_rec.attribute35,FND_API.G_MISS_CHAR,
364: p_old_adj_tbl(1).attribute35,p_newtx_rec.attribute35),
365: DECODE(p_newtx_rec.attribute36,FND_API.G_MISS_CHAR,
366: p_old_adj_tbl(1).attribute36,p_newtx_rec.attribute36),
367: DECODE(p_newtx_rec.attribute37,FND_API.G_MISS_CHAR,
361: DECODE(p_newtx_rec.attribute34,FND_API.G_MISS_CHAR,
362: p_old_adj_tbl(1).attribute34,p_newtx_rec.attribute34),
363: DECODE(p_newtx_rec.attribute35,FND_API.G_MISS_CHAR,
364: p_old_adj_tbl(1).attribute35,p_newtx_rec.attribute35),
365: DECODE(p_newtx_rec.attribute36,FND_API.G_MISS_CHAR,
366: p_old_adj_tbl(1).attribute36,p_newtx_rec.attribute36),
367: DECODE(p_newtx_rec.attribute37,FND_API.G_MISS_CHAR,
368: p_old_adj_tbl(1).attribute37,p_newtx_rec.attribute37),
369: DECODE(p_newtx_rec.attribute38,FND_API.G_MISS_CHAR,
363: DECODE(p_newtx_rec.attribute35,FND_API.G_MISS_CHAR,
364: p_old_adj_tbl(1).attribute35,p_newtx_rec.attribute35),
365: DECODE(p_newtx_rec.attribute36,FND_API.G_MISS_CHAR,
366: p_old_adj_tbl(1).attribute36,p_newtx_rec.attribute36),
367: DECODE(p_newtx_rec.attribute37,FND_API.G_MISS_CHAR,
368: p_old_adj_tbl(1).attribute37,p_newtx_rec.attribute37),
369: DECODE(p_newtx_rec.attribute38,FND_API.G_MISS_CHAR,
370: p_old_adj_tbl(1).attribute38,p_newtx_rec.attribute38),
371: DECODE(p_newtx_rec.attribute39,FND_API.G_MISS_CHAR,
365: DECODE(p_newtx_rec.attribute36,FND_API.G_MISS_CHAR,
366: p_old_adj_tbl(1).attribute36,p_newtx_rec.attribute36),
367: DECODE(p_newtx_rec.attribute37,FND_API.G_MISS_CHAR,
368: p_old_adj_tbl(1).attribute37,p_newtx_rec.attribute37),
369: DECODE(p_newtx_rec.attribute38,FND_API.G_MISS_CHAR,
370: p_old_adj_tbl(1).attribute38,p_newtx_rec.attribute38),
371: DECODE(p_newtx_rec.attribute39,FND_API.G_MISS_CHAR,
372: p_old_adj_tbl(1).attribute39,p_newtx_rec.attribute39),
373: DECODE(p_newtx_rec.attribute40,FND_API.G_MISS_CHAR,
367: DECODE(p_newtx_rec.attribute37,FND_API.G_MISS_CHAR,
368: p_old_adj_tbl(1).attribute37,p_newtx_rec.attribute37),
369: DECODE(p_newtx_rec.attribute38,FND_API.G_MISS_CHAR,
370: p_old_adj_tbl(1).attribute38,p_newtx_rec.attribute38),
371: DECODE(p_newtx_rec.attribute39,FND_API.G_MISS_CHAR,
372: p_old_adj_tbl(1).attribute39,p_newtx_rec.attribute39),
373: DECODE(p_newtx_rec.attribute40,FND_API.G_MISS_CHAR,
374: p_old_adj_tbl(1).attribute40,p_newtx_rec.attribute40),
375: DECODE(p_newtx_rec.attribute41,FND_API.G_MISS_CHAR,
369: DECODE(p_newtx_rec.attribute38,FND_API.G_MISS_CHAR,
370: p_old_adj_tbl(1).attribute38,p_newtx_rec.attribute38),
371: DECODE(p_newtx_rec.attribute39,FND_API.G_MISS_CHAR,
372: p_old_adj_tbl(1).attribute39,p_newtx_rec.attribute39),
373: DECODE(p_newtx_rec.attribute40,FND_API.G_MISS_CHAR,
374: p_old_adj_tbl(1).attribute40,p_newtx_rec.attribute40),
375: DECODE(p_newtx_rec.attribute41,FND_API.G_MISS_CHAR,
376: p_old_adj_tbl(1).attribute41,p_newtx_rec.attribute41),
377: DECODE(p_newtx_rec.attribute42,FND_API.G_MISS_CHAR,
371: DECODE(p_newtx_rec.attribute39,FND_API.G_MISS_CHAR,
372: p_old_adj_tbl(1).attribute39,p_newtx_rec.attribute39),
373: DECODE(p_newtx_rec.attribute40,FND_API.G_MISS_CHAR,
374: p_old_adj_tbl(1).attribute40,p_newtx_rec.attribute40),
375: DECODE(p_newtx_rec.attribute41,FND_API.G_MISS_CHAR,
376: p_old_adj_tbl(1).attribute41,p_newtx_rec.attribute41),
377: DECODE(p_newtx_rec.attribute42,FND_API.G_MISS_CHAR,
378: p_old_adj_tbl(1).attribute42,p_newtx_rec.attribute42),
379: DECODE(p_newtx_rec.attribute43,FND_API.G_MISS_CHAR,
373: DECODE(p_newtx_rec.attribute40,FND_API.G_MISS_CHAR,
374: p_old_adj_tbl(1).attribute40,p_newtx_rec.attribute40),
375: DECODE(p_newtx_rec.attribute41,FND_API.G_MISS_CHAR,
376: p_old_adj_tbl(1).attribute41,p_newtx_rec.attribute41),
377: DECODE(p_newtx_rec.attribute42,FND_API.G_MISS_CHAR,
378: p_old_adj_tbl(1).attribute42,p_newtx_rec.attribute42),
379: DECODE(p_newtx_rec.attribute43,FND_API.G_MISS_CHAR,
380: p_old_adj_tbl(1).attribute43,p_newtx_rec.attribute43),
381: DECODE(p_newtx_rec.attribute44,FND_API.G_MISS_CHAR,
375: DECODE(p_newtx_rec.attribute41,FND_API.G_MISS_CHAR,
376: p_old_adj_tbl(1).attribute41,p_newtx_rec.attribute41),
377: DECODE(p_newtx_rec.attribute42,FND_API.G_MISS_CHAR,
378: p_old_adj_tbl(1).attribute42,p_newtx_rec.attribute42),
379: DECODE(p_newtx_rec.attribute43,FND_API.G_MISS_CHAR,
380: p_old_adj_tbl(1).attribute43,p_newtx_rec.attribute43),
381: DECODE(p_newtx_rec.attribute44,FND_API.G_MISS_CHAR,
382: p_old_adj_tbl(1).attribute44,p_newtx_rec.attribute44),
383: DECODE(p_newtx_rec.attribute45,FND_API.G_MISS_CHAR,
377: DECODE(p_newtx_rec.attribute42,FND_API.G_MISS_CHAR,
378: p_old_adj_tbl(1).attribute42,p_newtx_rec.attribute42),
379: DECODE(p_newtx_rec.attribute43,FND_API.G_MISS_CHAR,
380: p_old_adj_tbl(1).attribute43,p_newtx_rec.attribute43),
381: DECODE(p_newtx_rec.attribute44,FND_API.G_MISS_CHAR,
382: p_old_adj_tbl(1).attribute44,p_newtx_rec.attribute44),
383: DECODE(p_newtx_rec.attribute45,FND_API.G_MISS_CHAR,
384: p_old_adj_tbl(1).attribute45,p_newtx_rec.attribute45),
385: DECODE(p_newtx_rec.attribute46,FND_API.G_MISS_CHAR,
379: DECODE(p_newtx_rec.attribute43,FND_API.G_MISS_CHAR,
380: p_old_adj_tbl(1).attribute43,p_newtx_rec.attribute43),
381: DECODE(p_newtx_rec.attribute44,FND_API.G_MISS_CHAR,
382: p_old_adj_tbl(1).attribute44,p_newtx_rec.attribute44),
383: DECODE(p_newtx_rec.attribute45,FND_API.G_MISS_CHAR,
384: p_old_adj_tbl(1).attribute45,p_newtx_rec.attribute45),
385: DECODE(p_newtx_rec.attribute46,FND_API.G_MISS_CHAR,
386: p_old_adj_tbl(1).attribute46,p_newtx_rec.attribute46),
387: DECODE(p_newtx_rec.attribute47,FND_API.G_MISS_CHAR,
381: DECODE(p_newtx_rec.attribute44,FND_API.G_MISS_CHAR,
382: p_old_adj_tbl(1).attribute44,p_newtx_rec.attribute44),
383: DECODE(p_newtx_rec.attribute45,FND_API.G_MISS_CHAR,
384: p_old_adj_tbl(1).attribute45,p_newtx_rec.attribute45),
385: DECODE(p_newtx_rec.attribute46,FND_API.G_MISS_CHAR,
386: p_old_adj_tbl(1).attribute46,p_newtx_rec.attribute46),
387: DECODE(p_newtx_rec.attribute47,FND_API.G_MISS_CHAR,
388: p_old_adj_tbl(1).attribute47,p_newtx_rec.attribute47),
389: DECODE(p_newtx_rec.attribute48,FND_API.G_MISS_CHAR,
383: DECODE(p_newtx_rec.attribute45,FND_API.G_MISS_CHAR,
384: p_old_adj_tbl(1).attribute45,p_newtx_rec.attribute45),
385: DECODE(p_newtx_rec.attribute46,FND_API.G_MISS_CHAR,
386: p_old_adj_tbl(1).attribute46,p_newtx_rec.attribute46),
387: DECODE(p_newtx_rec.attribute47,FND_API.G_MISS_CHAR,
388: p_old_adj_tbl(1).attribute47,p_newtx_rec.attribute47),
389: DECODE(p_newtx_rec.attribute48,FND_API.G_MISS_CHAR,
390: p_old_adj_tbl(1).attribute48,p_newtx_rec.attribute48),
391: DECODE(p_newtx_rec.attribute49,FND_API.G_MISS_CHAR,
385: DECODE(p_newtx_rec.attribute46,FND_API.G_MISS_CHAR,
386: p_old_adj_tbl(1).attribute46,p_newtx_rec.attribute46),
387: DECODE(p_newtx_rec.attribute47,FND_API.G_MISS_CHAR,
388: p_old_adj_tbl(1).attribute47,p_newtx_rec.attribute47),
389: DECODE(p_newtx_rec.attribute48,FND_API.G_MISS_CHAR,
390: p_old_adj_tbl(1).attribute48,p_newtx_rec.attribute48),
391: DECODE(p_newtx_rec.attribute49,FND_API.G_MISS_CHAR,
392: p_old_adj_tbl(1).attribute49,p_newtx_rec.attribute49),
393: DECODE(p_newtx_rec.attribute50,FND_API.G_MISS_CHAR,
387: DECODE(p_newtx_rec.attribute47,FND_API.G_MISS_CHAR,
388: p_old_adj_tbl(1).attribute47,p_newtx_rec.attribute47),
389: DECODE(p_newtx_rec.attribute48,FND_API.G_MISS_CHAR,
390: p_old_adj_tbl(1).attribute48,p_newtx_rec.attribute48),
391: DECODE(p_newtx_rec.attribute49,FND_API.G_MISS_CHAR,
392: p_old_adj_tbl(1).attribute49,p_newtx_rec.attribute49),
393: DECODE(p_newtx_rec.attribute50,FND_API.G_MISS_CHAR,
394: p_old_adj_tbl(1).attribute50,p_newtx_rec.attribute50),
395: DECODE(p_newtx_rec.attribute51,FND_API.G_MISS_CHAR,
389: DECODE(p_newtx_rec.attribute48,FND_API.G_MISS_CHAR,
390: p_old_adj_tbl(1).attribute48,p_newtx_rec.attribute48),
391: DECODE(p_newtx_rec.attribute49,FND_API.G_MISS_CHAR,
392: p_old_adj_tbl(1).attribute49,p_newtx_rec.attribute49),
393: DECODE(p_newtx_rec.attribute50,FND_API.G_MISS_CHAR,
394: p_old_adj_tbl(1).attribute50,p_newtx_rec.attribute50),
395: DECODE(p_newtx_rec.attribute51,FND_API.G_MISS_CHAR,
396: p_old_adj_tbl(1).attribute51,p_newtx_rec.attribute51),
397: DECODE(p_newtx_rec.attribute52,FND_API.G_MISS_CHAR,
391: DECODE(p_newtx_rec.attribute49,FND_API.G_MISS_CHAR,
392: p_old_adj_tbl(1).attribute49,p_newtx_rec.attribute49),
393: DECODE(p_newtx_rec.attribute50,FND_API.G_MISS_CHAR,
394: p_old_adj_tbl(1).attribute50,p_newtx_rec.attribute50),
395: DECODE(p_newtx_rec.attribute51,FND_API.G_MISS_CHAR,
396: p_old_adj_tbl(1).attribute51,p_newtx_rec.attribute51),
397: DECODE(p_newtx_rec.attribute52,FND_API.G_MISS_CHAR,
398: p_old_adj_tbl(1).attribute52,p_newtx_rec.attribute52),
399: DECODE(p_newtx_rec.attribute53,FND_API.G_MISS_CHAR,
393: DECODE(p_newtx_rec.attribute50,FND_API.G_MISS_CHAR,
394: p_old_adj_tbl(1).attribute50,p_newtx_rec.attribute50),
395: DECODE(p_newtx_rec.attribute51,FND_API.G_MISS_CHAR,
396: p_old_adj_tbl(1).attribute51,p_newtx_rec.attribute51),
397: DECODE(p_newtx_rec.attribute52,FND_API.G_MISS_CHAR,
398: p_old_adj_tbl(1).attribute52,p_newtx_rec.attribute52),
399: DECODE(p_newtx_rec.attribute53,FND_API.G_MISS_CHAR,
400: p_old_adj_tbl(1).attribute53,p_newtx_rec.attribute53),
401: DECODE(p_newtx_rec.attribute54,FND_API.G_MISS_CHAR,
395: DECODE(p_newtx_rec.attribute51,FND_API.G_MISS_CHAR,
396: p_old_adj_tbl(1).attribute51,p_newtx_rec.attribute51),
397: DECODE(p_newtx_rec.attribute52,FND_API.G_MISS_CHAR,
398: p_old_adj_tbl(1).attribute52,p_newtx_rec.attribute52),
399: DECODE(p_newtx_rec.attribute53,FND_API.G_MISS_CHAR,
400: p_old_adj_tbl(1).attribute53,p_newtx_rec.attribute53),
401: DECODE(p_newtx_rec.attribute54,FND_API.G_MISS_CHAR,
402: p_old_adj_tbl(1).attribute54,p_newtx_rec.attribute54),
403: DECODE(p_newtx_rec.attribute55,FND_API.G_MISS_CHAR,
397: DECODE(p_newtx_rec.attribute52,FND_API.G_MISS_CHAR,
398: p_old_adj_tbl(1).attribute52,p_newtx_rec.attribute52),
399: DECODE(p_newtx_rec.attribute53,FND_API.G_MISS_CHAR,
400: p_old_adj_tbl(1).attribute53,p_newtx_rec.attribute53),
401: DECODE(p_newtx_rec.attribute54,FND_API.G_MISS_CHAR,
402: p_old_adj_tbl(1).attribute54,p_newtx_rec.attribute54),
403: DECODE(p_newtx_rec.attribute55,FND_API.G_MISS_CHAR,
404: p_old_adj_tbl(1).attribute55,p_newtx_rec.attribute55),
405: DECODE(p_newtx_rec.attribute56,FND_API.G_MISS_CHAR,
399: DECODE(p_newtx_rec.attribute53,FND_API.G_MISS_CHAR,
400: p_old_adj_tbl(1).attribute53,p_newtx_rec.attribute53),
401: DECODE(p_newtx_rec.attribute54,FND_API.G_MISS_CHAR,
402: p_old_adj_tbl(1).attribute54,p_newtx_rec.attribute54),
403: DECODE(p_newtx_rec.attribute55,FND_API.G_MISS_CHAR,
404: p_old_adj_tbl(1).attribute55,p_newtx_rec.attribute55),
405: DECODE(p_newtx_rec.attribute56,FND_API.G_MISS_CHAR,
406: p_old_adj_tbl(1).attribute56,p_newtx_rec.attribute56),
407: DECODE(p_newtx_rec.attribute57,FND_API.G_MISS_CHAR,
401: DECODE(p_newtx_rec.attribute54,FND_API.G_MISS_CHAR,
402: p_old_adj_tbl(1).attribute54,p_newtx_rec.attribute54),
403: DECODE(p_newtx_rec.attribute55,FND_API.G_MISS_CHAR,
404: p_old_adj_tbl(1).attribute55,p_newtx_rec.attribute55),
405: DECODE(p_newtx_rec.attribute56,FND_API.G_MISS_CHAR,
406: p_old_adj_tbl(1).attribute56,p_newtx_rec.attribute56),
407: DECODE(p_newtx_rec.attribute57,FND_API.G_MISS_CHAR,
408: p_old_adj_tbl(1).attribute57,p_newtx_rec.attribute57),
409: DECODE(p_newtx_rec.attribute58,FND_API.G_MISS_CHAR,
403: DECODE(p_newtx_rec.attribute55,FND_API.G_MISS_CHAR,
404: p_old_adj_tbl(1).attribute55,p_newtx_rec.attribute55),
405: DECODE(p_newtx_rec.attribute56,FND_API.G_MISS_CHAR,
406: p_old_adj_tbl(1).attribute56,p_newtx_rec.attribute56),
407: DECODE(p_newtx_rec.attribute57,FND_API.G_MISS_CHAR,
408: p_old_adj_tbl(1).attribute57,p_newtx_rec.attribute57),
409: DECODE(p_newtx_rec.attribute58,FND_API.G_MISS_CHAR,
410: p_old_adj_tbl(1).attribute58,p_newtx_rec.attribute58),
411: DECODE(p_newtx_rec.attribute59,FND_API.G_MISS_CHAR,
405: DECODE(p_newtx_rec.attribute56,FND_API.G_MISS_CHAR,
406: p_old_adj_tbl(1).attribute56,p_newtx_rec.attribute56),
407: DECODE(p_newtx_rec.attribute57,FND_API.G_MISS_CHAR,
408: p_old_adj_tbl(1).attribute57,p_newtx_rec.attribute57),
409: DECODE(p_newtx_rec.attribute58,FND_API.G_MISS_CHAR,
410: p_old_adj_tbl(1).attribute58,p_newtx_rec.attribute58),
411: DECODE(p_newtx_rec.attribute59,FND_API.G_MISS_CHAR,
412: p_old_adj_tbl(1).attribute59,p_newtx_rec.attribute59),
413: DECODE(p_newtx_rec.attribute60,FND_API.G_MISS_CHAR,
407: DECODE(p_newtx_rec.attribute57,FND_API.G_MISS_CHAR,
408: p_old_adj_tbl(1).attribute57,p_newtx_rec.attribute57),
409: DECODE(p_newtx_rec.attribute58,FND_API.G_MISS_CHAR,
410: p_old_adj_tbl(1).attribute58,p_newtx_rec.attribute58),
411: DECODE(p_newtx_rec.attribute59,FND_API.G_MISS_CHAR,
412: p_old_adj_tbl(1).attribute59,p_newtx_rec.attribute59),
413: DECODE(p_newtx_rec.attribute60,FND_API.G_MISS_CHAR,
414: p_old_adj_tbl(1).attribute60,p_newtx_rec.attribute60),
415: DECODE(p_newtx_rec.attribute61,FND_API.G_MISS_CHAR,
409: DECODE(p_newtx_rec.attribute58,FND_API.G_MISS_CHAR,
410: p_old_adj_tbl(1).attribute58,p_newtx_rec.attribute58),
411: DECODE(p_newtx_rec.attribute59,FND_API.G_MISS_CHAR,
412: p_old_adj_tbl(1).attribute59,p_newtx_rec.attribute59),
413: DECODE(p_newtx_rec.attribute60,FND_API.G_MISS_CHAR,
414: p_old_adj_tbl(1).attribute60,p_newtx_rec.attribute60),
415: DECODE(p_newtx_rec.attribute61,FND_API.G_MISS_CHAR,
416: p_old_adj_tbl(1).attribute61,p_newtx_rec.attribute61),
417: DECODE(p_newtx_rec.attribute62,FND_API.G_MISS_CHAR,
411: DECODE(p_newtx_rec.attribute59,FND_API.G_MISS_CHAR,
412: p_old_adj_tbl(1).attribute59,p_newtx_rec.attribute59),
413: DECODE(p_newtx_rec.attribute60,FND_API.G_MISS_CHAR,
414: p_old_adj_tbl(1).attribute60,p_newtx_rec.attribute60),
415: DECODE(p_newtx_rec.attribute61,FND_API.G_MISS_CHAR,
416: p_old_adj_tbl(1).attribute61,p_newtx_rec.attribute61),
417: DECODE(p_newtx_rec.attribute62,FND_API.G_MISS_CHAR,
418: p_old_adj_tbl(1).attribute62,p_newtx_rec.attribute62),
419: DECODE(p_newtx_rec.attribute63,FND_API.G_MISS_CHAR,
413: DECODE(p_newtx_rec.attribute60,FND_API.G_MISS_CHAR,
414: p_old_adj_tbl(1).attribute60,p_newtx_rec.attribute60),
415: DECODE(p_newtx_rec.attribute61,FND_API.G_MISS_CHAR,
416: p_old_adj_tbl(1).attribute61,p_newtx_rec.attribute61),
417: DECODE(p_newtx_rec.attribute62,FND_API.G_MISS_CHAR,
418: p_old_adj_tbl(1).attribute62,p_newtx_rec.attribute62),
419: DECODE(p_newtx_rec.attribute63,FND_API.G_MISS_CHAR,
420: p_old_adj_tbl(1).attribute63,p_newtx_rec.attribute63),
421: DECODE(p_newtx_rec.attribute64,FND_API.G_MISS_CHAR,
415: DECODE(p_newtx_rec.attribute61,FND_API.G_MISS_CHAR,
416: p_old_adj_tbl(1).attribute61,p_newtx_rec.attribute61),
417: DECODE(p_newtx_rec.attribute62,FND_API.G_MISS_CHAR,
418: p_old_adj_tbl(1).attribute62,p_newtx_rec.attribute62),
419: DECODE(p_newtx_rec.attribute63,FND_API.G_MISS_CHAR,
420: p_old_adj_tbl(1).attribute63,p_newtx_rec.attribute63),
421: DECODE(p_newtx_rec.attribute64,FND_API.G_MISS_CHAR,
422: p_old_adj_tbl(1).attribute64,p_newtx_rec.attribute64),
423: DECODE(p_newtx_rec.attribute65,FND_API.G_MISS_CHAR,
417: DECODE(p_newtx_rec.attribute62,FND_API.G_MISS_CHAR,
418: p_old_adj_tbl(1).attribute62,p_newtx_rec.attribute62),
419: DECODE(p_newtx_rec.attribute63,FND_API.G_MISS_CHAR,
420: p_old_adj_tbl(1).attribute63,p_newtx_rec.attribute63),
421: DECODE(p_newtx_rec.attribute64,FND_API.G_MISS_CHAR,
422: p_old_adj_tbl(1).attribute64,p_newtx_rec.attribute64),
423: DECODE(p_newtx_rec.attribute65,FND_API.G_MISS_CHAR,
424: p_old_adj_tbl(1).attribute65,p_newtx_rec.attribute65),
425: DECODE(p_newtx_rec.attribute66,FND_API.G_MISS_CHAR,
419: DECODE(p_newtx_rec.attribute63,FND_API.G_MISS_CHAR,
420: p_old_adj_tbl(1).attribute63,p_newtx_rec.attribute63),
421: DECODE(p_newtx_rec.attribute64,FND_API.G_MISS_CHAR,
422: p_old_adj_tbl(1).attribute64,p_newtx_rec.attribute64),
423: DECODE(p_newtx_rec.attribute65,FND_API.G_MISS_CHAR,
424: p_old_adj_tbl(1).attribute65,p_newtx_rec.attribute65),
425: DECODE(p_newtx_rec.attribute66,FND_API.G_MISS_CHAR,
426: p_old_adj_tbl(1).attribute66,p_newtx_rec.attribute66),
427: DECODE(p_newtx_rec.attribute67,FND_API.G_MISS_CHAR,
421: DECODE(p_newtx_rec.attribute64,FND_API.G_MISS_CHAR,
422: p_old_adj_tbl(1).attribute64,p_newtx_rec.attribute64),
423: DECODE(p_newtx_rec.attribute65,FND_API.G_MISS_CHAR,
424: p_old_adj_tbl(1).attribute65,p_newtx_rec.attribute65),
425: DECODE(p_newtx_rec.attribute66,FND_API.G_MISS_CHAR,
426: p_old_adj_tbl(1).attribute66,p_newtx_rec.attribute66),
427: DECODE(p_newtx_rec.attribute67,FND_API.G_MISS_CHAR,
428: p_old_adj_tbl(1).attribute67,p_newtx_rec.attribute67),
429: DECODE(p_newtx_rec.attribute68,FND_API.G_MISS_CHAR,
423: DECODE(p_newtx_rec.attribute65,FND_API.G_MISS_CHAR,
424: p_old_adj_tbl(1).attribute65,p_newtx_rec.attribute65),
425: DECODE(p_newtx_rec.attribute66,FND_API.G_MISS_CHAR,
426: p_old_adj_tbl(1).attribute66,p_newtx_rec.attribute66),
427: DECODE(p_newtx_rec.attribute67,FND_API.G_MISS_CHAR,
428: p_old_adj_tbl(1).attribute67,p_newtx_rec.attribute67),
429: DECODE(p_newtx_rec.attribute68,FND_API.G_MISS_CHAR,
430: p_old_adj_tbl(1).attribute68,p_newtx_rec.attribute68),
431: DECODE(p_newtx_rec.attribute69,FND_API.G_MISS_CHAR,
425: DECODE(p_newtx_rec.attribute66,FND_API.G_MISS_CHAR,
426: p_old_adj_tbl(1).attribute66,p_newtx_rec.attribute66),
427: DECODE(p_newtx_rec.attribute67,FND_API.G_MISS_CHAR,
428: p_old_adj_tbl(1).attribute67,p_newtx_rec.attribute67),
429: DECODE(p_newtx_rec.attribute68,FND_API.G_MISS_CHAR,
430: p_old_adj_tbl(1).attribute68,p_newtx_rec.attribute68),
431: DECODE(p_newtx_rec.attribute69,FND_API.G_MISS_CHAR,
432: p_old_adj_tbl(1).attribute69,p_newtx_rec.attribute69),
433: DECODE(p_newtx_rec.attribute70,FND_API.G_MISS_CHAR,
427: DECODE(p_newtx_rec.attribute67,FND_API.G_MISS_CHAR,
428: p_old_adj_tbl(1).attribute67,p_newtx_rec.attribute67),
429: DECODE(p_newtx_rec.attribute68,FND_API.G_MISS_CHAR,
430: p_old_adj_tbl(1).attribute68,p_newtx_rec.attribute68),
431: DECODE(p_newtx_rec.attribute69,FND_API.G_MISS_CHAR,
432: p_old_adj_tbl(1).attribute69,p_newtx_rec.attribute69),
433: DECODE(p_newtx_rec.attribute70,FND_API.G_MISS_CHAR,
434: p_old_adj_tbl(1).attribute70,p_newtx_rec.attribute70),
435: DECODE(p_newtx_rec.attribute71,FND_API.G_MISS_CHAR,
429: DECODE(p_newtx_rec.attribute68,FND_API.G_MISS_CHAR,
430: p_old_adj_tbl(1).attribute68,p_newtx_rec.attribute68),
431: DECODE(p_newtx_rec.attribute69,FND_API.G_MISS_CHAR,
432: p_old_adj_tbl(1).attribute69,p_newtx_rec.attribute69),
433: DECODE(p_newtx_rec.attribute70,FND_API.G_MISS_CHAR,
434: p_old_adj_tbl(1).attribute70,p_newtx_rec.attribute70),
435: DECODE(p_newtx_rec.attribute71,FND_API.G_MISS_CHAR,
436: p_old_adj_tbl(1).attribute71,p_newtx_rec.attribute71),
437: DECODE(p_newtx_rec.attribute72,FND_API.G_MISS_CHAR,
431: DECODE(p_newtx_rec.attribute69,FND_API.G_MISS_CHAR,
432: p_old_adj_tbl(1).attribute69,p_newtx_rec.attribute69),
433: DECODE(p_newtx_rec.attribute70,FND_API.G_MISS_CHAR,
434: p_old_adj_tbl(1).attribute70,p_newtx_rec.attribute70),
435: DECODE(p_newtx_rec.attribute71,FND_API.G_MISS_CHAR,
436: p_old_adj_tbl(1).attribute71,p_newtx_rec.attribute71),
437: DECODE(p_newtx_rec.attribute72,FND_API.G_MISS_CHAR,
438: p_old_adj_tbl(1).attribute72,p_newtx_rec.attribute72),
439: DECODE(p_newtx_rec.attribute73,FND_API.G_MISS_CHAR,
433: DECODE(p_newtx_rec.attribute70,FND_API.G_MISS_CHAR,
434: p_old_adj_tbl(1).attribute70,p_newtx_rec.attribute70),
435: DECODE(p_newtx_rec.attribute71,FND_API.G_MISS_CHAR,
436: p_old_adj_tbl(1).attribute71,p_newtx_rec.attribute71),
437: DECODE(p_newtx_rec.attribute72,FND_API.G_MISS_CHAR,
438: p_old_adj_tbl(1).attribute72,p_newtx_rec.attribute72),
439: DECODE(p_newtx_rec.attribute73,FND_API.G_MISS_CHAR,
440: p_old_adj_tbl(1).attribute73,p_newtx_rec.attribute73),
441: DECODE(p_newtx_rec.attribute74,FND_API.G_MISS_CHAR,
435: DECODE(p_newtx_rec.attribute71,FND_API.G_MISS_CHAR,
436: p_old_adj_tbl(1).attribute71,p_newtx_rec.attribute71),
437: DECODE(p_newtx_rec.attribute72,FND_API.G_MISS_CHAR,
438: p_old_adj_tbl(1).attribute72,p_newtx_rec.attribute72),
439: DECODE(p_newtx_rec.attribute73,FND_API.G_MISS_CHAR,
440: p_old_adj_tbl(1).attribute73,p_newtx_rec.attribute73),
441: DECODE(p_newtx_rec.attribute74,FND_API.G_MISS_CHAR,
442: p_old_adj_tbl(1).attribute74,p_newtx_rec.attribute74),
443: DECODE(p_newtx_rec.attribute75,FND_API.G_MISS_CHAR,
437: DECODE(p_newtx_rec.attribute72,FND_API.G_MISS_CHAR,
438: p_old_adj_tbl(1).attribute72,p_newtx_rec.attribute72),
439: DECODE(p_newtx_rec.attribute73,FND_API.G_MISS_CHAR,
440: p_old_adj_tbl(1).attribute73,p_newtx_rec.attribute73),
441: DECODE(p_newtx_rec.attribute74,FND_API.G_MISS_CHAR,
442: p_old_adj_tbl(1).attribute74,p_newtx_rec.attribute74),
443: DECODE(p_newtx_rec.attribute75,FND_API.G_MISS_CHAR,
444: p_old_adj_tbl(1).attribute75,p_newtx_rec.attribute75),
445: DECODE(p_newtx_rec.attribute76,FND_API.G_MISS_CHAR,
439: DECODE(p_newtx_rec.attribute73,FND_API.G_MISS_CHAR,
440: p_old_adj_tbl(1).attribute73,p_newtx_rec.attribute73),
441: DECODE(p_newtx_rec.attribute74,FND_API.G_MISS_CHAR,
442: p_old_adj_tbl(1).attribute74,p_newtx_rec.attribute74),
443: DECODE(p_newtx_rec.attribute75,FND_API.G_MISS_CHAR,
444: p_old_adj_tbl(1).attribute75,p_newtx_rec.attribute75),
445: DECODE(p_newtx_rec.attribute76,FND_API.G_MISS_CHAR,
446: p_old_adj_tbl(1).attribute76,p_newtx_rec.attribute76),
447: DECODE(p_newtx_rec.attribute77,FND_API.G_MISS_CHAR,
441: DECODE(p_newtx_rec.attribute74,FND_API.G_MISS_CHAR,
442: p_old_adj_tbl(1).attribute74,p_newtx_rec.attribute74),
443: DECODE(p_newtx_rec.attribute75,FND_API.G_MISS_CHAR,
444: p_old_adj_tbl(1).attribute75,p_newtx_rec.attribute75),
445: DECODE(p_newtx_rec.attribute76,FND_API.G_MISS_CHAR,
446: p_old_adj_tbl(1).attribute76,p_newtx_rec.attribute76),
447: DECODE(p_newtx_rec.attribute77,FND_API.G_MISS_CHAR,
448: p_old_adj_tbl(1).attribute77,p_newtx_rec.attribute77),
449: DECODE(p_newtx_rec.attribute78,FND_API.G_MISS_CHAR,
443: DECODE(p_newtx_rec.attribute75,FND_API.G_MISS_CHAR,
444: p_old_adj_tbl(1).attribute75,p_newtx_rec.attribute75),
445: DECODE(p_newtx_rec.attribute76,FND_API.G_MISS_CHAR,
446: p_old_adj_tbl(1).attribute76,p_newtx_rec.attribute76),
447: DECODE(p_newtx_rec.attribute77,FND_API.G_MISS_CHAR,
448: p_old_adj_tbl(1).attribute77,p_newtx_rec.attribute77),
449: DECODE(p_newtx_rec.attribute78,FND_API.G_MISS_CHAR,
450: p_old_adj_tbl(1).attribute78,p_newtx_rec.attribute78),
451: DECODE(p_newtx_rec.attribute79,FND_API.G_MISS_CHAR,
445: DECODE(p_newtx_rec.attribute76,FND_API.G_MISS_CHAR,
446: p_old_adj_tbl(1).attribute76,p_newtx_rec.attribute76),
447: DECODE(p_newtx_rec.attribute77,FND_API.G_MISS_CHAR,
448: p_old_adj_tbl(1).attribute77,p_newtx_rec.attribute77),
449: DECODE(p_newtx_rec.attribute78,FND_API.G_MISS_CHAR,
450: p_old_adj_tbl(1).attribute78,p_newtx_rec.attribute78),
451: DECODE(p_newtx_rec.attribute79,FND_API.G_MISS_CHAR,
452: p_old_adj_tbl(1).attribute79,p_newtx_rec.attribute79),
453: DECODE(p_newtx_rec.attribute80,FND_API.G_MISS_CHAR,
447: DECODE(p_newtx_rec.attribute77,FND_API.G_MISS_CHAR,
448: p_old_adj_tbl(1).attribute77,p_newtx_rec.attribute77),
449: DECODE(p_newtx_rec.attribute78,FND_API.G_MISS_CHAR,
450: p_old_adj_tbl(1).attribute78,p_newtx_rec.attribute78),
451: DECODE(p_newtx_rec.attribute79,FND_API.G_MISS_CHAR,
452: p_old_adj_tbl(1).attribute79,p_newtx_rec.attribute79),
453: DECODE(p_newtx_rec.attribute80,FND_API.G_MISS_CHAR,
454: p_old_adj_tbl(1).attribute80,p_newtx_rec.attribute80),
455: DECODE(p_newtx_rec.attribute81,FND_API.G_MISS_CHAR,
449: DECODE(p_newtx_rec.attribute78,FND_API.G_MISS_CHAR,
450: p_old_adj_tbl(1).attribute78,p_newtx_rec.attribute78),
451: DECODE(p_newtx_rec.attribute79,FND_API.G_MISS_CHAR,
452: p_old_adj_tbl(1).attribute79,p_newtx_rec.attribute79),
453: DECODE(p_newtx_rec.attribute80,FND_API.G_MISS_CHAR,
454: p_old_adj_tbl(1).attribute80,p_newtx_rec.attribute80),
455: DECODE(p_newtx_rec.attribute81,FND_API.G_MISS_CHAR,
456: p_old_adj_tbl(1).attribute81,p_newtx_rec.attribute81),
457: DECODE(p_newtx_rec.attribute82,FND_API.G_MISS_CHAR,
451: DECODE(p_newtx_rec.attribute79,FND_API.G_MISS_CHAR,
452: p_old_adj_tbl(1).attribute79,p_newtx_rec.attribute79),
453: DECODE(p_newtx_rec.attribute80,FND_API.G_MISS_CHAR,
454: p_old_adj_tbl(1).attribute80,p_newtx_rec.attribute80),
455: DECODE(p_newtx_rec.attribute81,FND_API.G_MISS_CHAR,
456: p_old_adj_tbl(1).attribute81,p_newtx_rec.attribute81),
457: DECODE(p_newtx_rec.attribute82,FND_API.G_MISS_CHAR,
458: p_old_adj_tbl(1).attribute82,p_newtx_rec.attribute82),
459: DECODE(p_newtx_rec.attribute83,FND_API.G_MISS_CHAR,
453: DECODE(p_newtx_rec.attribute80,FND_API.G_MISS_CHAR,
454: p_old_adj_tbl(1).attribute80,p_newtx_rec.attribute80),
455: DECODE(p_newtx_rec.attribute81,FND_API.G_MISS_CHAR,
456: p_old_adj_tbl(1).attribute81,p_newtx_rec.attribute81),
457: DECODE(p_newtx_rec.attribute82,FND_API.G_MISS_CHAR,
458: p_old_adj_tbl(1).attribute82,p_newtx_rec.attribute82),
459: DECODE(p_newtx_rec.attribute83,FND_API.G_MISS_CHAR,
460: p_old_adj_tbl(1).attribute83,p_newtx_rec.attribute83),
461: DECODE(p_newtx_rec.attribute84,FND_API.G_MISS_CHAR,
455: DECODE(p_newtx_rec.attribute81,FND_API.G_MISS_CHAR,
456: p_old_adj_tbl(1).attribute81,p_newtx_rec.attribute81),
457: DECODE(p_newtx_rec.attribute82,FND_API.G_MISS_CHAR,
458: p_old_adj_tbl(1).attribute82,p_newtx_rec.attribute82),
459: DECODE(p_newtx_rec.attribute83,FND_API.G_MISS_CHAR,
460: p_old_adj_tbl(1).attribute83,p_newtx_rec.attribute83),
461: DECODE(p_newtx_rec.attribute84,FND_API.G_MISS_CHAR,
462: p_old_adj_tbl(1).attribute84,p_newtx_rec.attribute84),
463: DECODE(p_newtx_rec.attribute85,FND_API.G_MISS_CHAR,
457: DECODE(p_newtx_rec.attribute82,FND_API.G_MISS_CHAR,
458: p_old_adj_tbl(1).attribute82,p_newtx_rec.attribute82),
459: DECODE(p_newtx_rec.attribute83,FND_API.G_MISS_CHAR,
460: p_old_adj_tbl(1).attribute83,p_newtx_rec.attribute83),
461: DECODE(p_newtx_rec.attribute84,FND_API.G_MISS_CHAR,
462: p_old_adj_tbl(1).attribute84,p_newtx_rec.attribute84),
463: DECODE(p_newtx_rec.attribute85,FND_API.G_MISS_CHAR,
464: p_old_adj_tbl(1).attribute85,p_newtx_rec.attribute85),
465: DECODE(p_newtx_rec.attribute86,FND_API.G_MISS_CHAR,
459: DECODE(p_newtx_rec.attribute83,FND_API.G_MISS_CHAR,
460: p_old_adj_tbl(1).attribute83,p_newtx_rec.attribute83),
461: DECODE(p_newtx_rec.attribute84,FND_API.G_MISS_CHAR,
462: p_old_adj_tbl(1).attribute84,p_newtx_rec.attribute84),
463: DECODE(p_newtx_rec.attribute85,FND_API.G_MISS_CHAR,
464: p_old_adj_tbl(1).attribute85,p_newtx_rec.attribute85),
465: DECODE(p_newtx_rec.attribute86,FND_API.G_MISS_CHAR,
466: p_old_adj_tbl(1).attribute86,p_newtx_rec.attribute86),
467: DECODE(p_newtx_rec.attribute87,FND_API.G_MISS_CHAR,
461: DECODE(p_newtx_rec.attribute84,FND_API.G_MISS_CHAR,
462: p_old_adj_tbl(1).attribute84,p_newtx_rec.attribute84),
463: DECODE(p_newtx_rec.attribute85,FND_API.G_MISS_CHAR,
464: p_old_adj_tbl(1).attribute85,p_newtx_rec.attribute85),
465: DECODE(p_newtx_rec.attribute86,FND_API.G_MISS_CHAR,
466: p_old_adj_tbl(1).attribute86,p_newtx_rec.attribute86),
467: DECODE(p_newtx_rec.attribute87,FND_API.G_MISS_CHAR,
468: p_old_adj_tbl(1).attribute87,p_newtx_rec.attribute87),
469: DECODE(p_newtx_rec.attribute88,FND_API.G_MISS_CHAR,
463: DECODE(p_newtx_rec.attribute85,FND_API.G_MISS_CHAR,
464: p_old_adj_tbl(1).attribute85,p_newtx_rec.attribute85),
465: DECODE(p_newtx_rec.attribute86,FND_API.G_MISS_CHAR,
466: p_old_adj_tbl(1).attribute86,p_newtx_rec.attribute86),
467: DECODE(p_newtx_rec.attribute87,FND_API.G_MISS_CHAR,
468: p_old_adj_tbl(1).attribute87,p_newtx_rec.attribute87),
469: DECODE(p_newtx_rec.attribute88,FND_API.G_MISS_CHAR,
470: p_old_adj_tbl(1).attribute88,p_newtx_rec.attribute88),
471: DECODE(p_newtx_rec.attribute89,FND_API.G_MISS_CHAR,
465: DECODE(p_newtx_rec.attribute86,FND_API.G_MISS_CHAR,
466: p_old_adj_tbl(1).attribute86,p_newtx_rec.attribute86),
467: DECODE(p_newtx_rec.attribute87,FND_API.G_MISS_CHAR,
468: p_old_adj_tbl(1).attribute87,p_newtx_rec.attribute87),
469: DECODE(p_newtx_rec.attribute88,FND_API.G_MISS_CHAR,
470: p_old_adj_tbl(1).attribute88,p_newtx_rec.attribute88),
471: DECODE(p_newtx_rec.attribute89,FND_API.G_MISS_CHAR,
472: p_old_adj_tbl(1).attribute89,p_newtx_rec.attribute89),
473: DECODE(p_newtx_rec.attribute90,FND_API.G_MISS_CHAR,
467: DECODE(p_newtx_rec.attribute87,FND_API.G_MISS_CHAR,
468: p_old_adj_tbl(1).attribute87,p_newtx_rec.attribute87),
469: DECODE(p_newtx_rec.attribute88,FND_API.G_MISS_CHAR,
470: p_old_adj_tbl(1).attribute88,p_newtx_rec.attribute88),
471: DECODE(p_newtx_rec.attribute89,FND_API.G_MISS_CHAR,
472: p_old_adj_tbl(1).attribute89,p_newtx_rec.attribute89),
473: DECODE(p_newtx_rec.attribute90,FND_API.G_MISS_CHAR,
474: p_old_adj_tbl(1).attribute90,p_newtx_rec.attribute90),
475: DECODE(p_newtx_rec.attribute91,FND_API.G_MISS_CHAR,
469: DECODE(p_newtx_rec.attribute88,FND_API.G_MISS_CHAR,
470: p_old_adj_tbl(1).attribute88,p_newtx_rec.attribute88),
471: DECODE(p_newtx_rec.attribute89,FND_API.G_MISS_CHAR,
472: p_old_adj_tbl(1).attribute89,p_newtx_rec.attribute89),
473: DECODE(p_newtx_rec.attribute90,FND_API.G_MISS_CHAR,
474: p_old_adj_tbl(1).attribute90,p_newtx_rec.attribute90),
475: DECODE(p_newtx_rec.attribute91,FND_API.G_MISS_CHAR,
476: p_old_adj_tbl(1).attribute91,p_newtx_rec.attribute91),
477: DECODE(p_newtx_rec.attribute92,FND_API.G_MISS_CHAR,
471: DECODE(p_newtx_rec.attribute89,FND_API.G_MISS_CHAR,
472: p_old_adj_tbl(1).attribute89,p_newtx_rec.attribute89),
473: DECODE(p_newtx_rec.attribute90,FND_API.G_MISS_CHAR,
474: p_old_adj_tbl(1).attribute90,p_newtx_rec.attribute90),
475: DECODE(p_newtx_rec.attribute91,FND_API.G_MISS_CHAR,
476: p_old_adj_tbl(1).attribute91,p_newtx_rec.attribute91),
477: DECODE(p_newtx_rec.attribute92,FND_API.G_MISS_CHAR,
478: p_old_adj_tbl(1).attribute92,p_newtx_rec.attribute92),
479: DECODE(p_newtx_rec.attribute93,FND_API.G_MISS_CHAR,
473: DECODE(p_newtx_rec.attribute90,FND_API.G_MISS_CHAR,
474: p_old_adj_tbl(1).attribute90,p_newtx_rec.attribute90),
475: DECODE(p_newtx_rec.attribute91,FND_API.G_MISS_CHAR,
476: p_old_adj_tbl(1).attribute91,p_newtx_rec.attribute91),
477: DECODE(p_newtx_rec.attribute92,FND_API.G_MISS_CHAR,
478: p_old_adj_tbl(1).attribute92,p_newtx_rec.attribute92),
479: DECODE(p_newtx_rec.attribute93,FND_API.G_MISS_CHAR,
480: p_old_adj_tbl(1).attribute93,p_newtx_rec.attribute93),
481: DECODE(p_newtx_rec.attribute94,FND_API.G_MISS_CHAR,
475: DECODE(p_newtx_rec.attribute91,FND_API.G_MISS_CHAR,
476: p_old_adj_tbl(1).attribute91,p_newtx_rec.attribute91),
477: DECODE(p_newtx_rec.attribute92,FND_API.G_MISS_CHAR,
478: p_old_adj_tbl(1).attribute92,p_newtx_rec.attribute92),
479: DECODE(p_newtx_rec.attribute93,FND_API.G_MISS_CHAR,
480: p_old_adj_tbl(1).attribute93,p_newtx_rec.attribute93),
481: DECODE(p_newtx_rec.attribute94,FND_API.G_MISS_CHAR,
482: p_old_adj_tbl(1).attribute94,p_newtx_rec.attribute94),
483: DECODE(p_newtx_rec.attribute95,FND_API.G_MISS_CHAR,
477: DECODE(p_newtx_rec.attribute92,FND_API.G_MISS_CHAR,
478: p_old_adj_tbl(1).attribute92,p_newtx_rec.attribute92),
479: DECODE(p_newtx_rec.attribute93,FND_API.G_MISS_CHAR,
480: p_old_adj_tbl(1).attribute93,p_newtx_rec.attribute93),
481: DECODE(p_newtx_rec.attribute94,FND_API.G_MISS_CHAR,
482: p_old_adj_tbl(1).attribute94,p_newtx_rec.attribute94),
483: DECODE(p_newtx_rec.attribute95,FND_API.G_MISS_CHAR,
484: p_old_adj_tbl(1).attribute95,p_newtx_rec.attribute95),
485: DECODE(p_newtx_rec.attribute96,FND_API.G_MISS_CHAR,
479: DECODE(p_newtx_rec.attribute93,FND_API.G_MISS_CHAR,
480: p_old_adj_tbl(1).attribute93,p_newtx_rec.attribute93),
481: DECODE(p_newtx_rec.attribute94,FND_API.G_MISS_CHAR,
482: p_old_adj_tbl(1).attribute94,p_newtx_rec.attribute94),
483: DECODE(p_newtx_rec.attribute95,FND_API.G_MISS_CHAR,
484: p_old_adj_tbl(1).attribute95,p_newtx_rec.attribute95),
485: DECODE(p_newtx_rec.attribute96,FND_API.G_MISS_CHAR,
486: p_old_adj_tbl(1).attribute96,p_newtx_rec.attribute96),
487: DECODE(p_newtx_rec.attribute97,FND_API.G_MISS_CHAR,
481: DECODE(p_newtx_rec.attribute94,FND_API.G_MISS_CHAR,
482: p_old_adj_tbl(1).attribute94,p_newtx_rec.attribute94),
483: DECODE(p_newtx_rec.attribute95,FND_API.G_MISS_CHAR,
484: p_old_adj_tbl(1).attribute95,p_newtx_rec.attribute95),
485: DECODE(p_newtx_rec.attribute96,FND_API.G_MISS_CHAR,
486: p_old_adj_tbl(1).attribute96,p_newtx_rec.attribute96),
487: DECODE(p_newtx_rec.attribute97,FND_API.G_MISS_CHAR,
488: p_old_adj_tbl(1).attribute97,p_newtx_rec.attribute97),
489: DECODE(p_newtx_rec.attribute98,FND_API.G_MISS_CHAR,
483: DECODE(p_newtx_rec.attribute95,FND_API.G_MISS_CHAR,
484: p_old_adj_tbl(1).attribute95,p_newtx_rec.attribute95),
485: DECODE(p_newtx_rec.attribute96,FND_API.G_MISS_CHAR,
486: p_old_adj_tbl(1).attribute96,p_newtx_rec.attribute96),
487: DECODE(p_newtx_rec.attribute97,FND_API.G_MISS_CHAR,
488: p_old_adj_tbl(1).attribute97,p_newtx_rec.attribute97),
489: DECODE(p_newtx_rec.attribute98,FND_API.G_MISS_CHAR,
490: p_old_adj_tbl(1).attribute98,p_newtx_rec.attribute98),
491: DECODE(p_newtx_rec.attribute99,FND_API.G_MISS_CHAR,
485: DECODE(p_newtx_rec.attribute96,FND_API.G_MISS_CHAR,
486: p_old_adj_tbl(1).attribute96,p_newtx_rec.attribute96),
487: DECODE(p_newtx_rec.attribute97,FND_API.G_MISS_CHAR,
488: p_old_adj_tbl(1).attribute97,p_newtx_rec.attribute97),
489: DECODE(p_newtx_rec.attribute98,FND_API.G_MISS_CHAR,
490: p_old_adj_tbl(1).attribute98,p_newtx_rec.attribute98),
491: DECODE(p_newtx_rec.attribute99,FND_API.G_MISS_CHAR,
492: p_old_adj_tbl(1).attribute99,p_newtx_rec.attribute99),
493: DECODE(p_newtx_rec.attribute100,FND_API.G_MISS_CHAR,
487: DECODE(p_newtx_rec.attribute97,FND_API.G_MISS_CHAR,
488: p_old_adj_tbl(1).attribute97,p_newtx_rec.attribute97),
489: DECODE(p_newtx_rec.attribute98,FND_API.G_MISS_CHAR,
490: p_old_adj_tbl(1).attribute98,p_newtx_rec.attribute98),
491: DECODE(p_newtx_rec.attribute99,FND_API.G_MISS_CHAR,
492: p_old_adj_tbl(1).attribute99,p_newtx_rec.attribute99),
493: DECODE(p_newtx_rec.attribute100,FND_API.G_MISS_CHAR,
494: p_old_adj_tbl(1).attribute100,p_newtx_rec.attribute100),
495: DECODE(p_newtx_rec.rollup_date,FND_API.G_MISS_DATE,
489: DECODE(p_newtx_rec.attribute98,FND_API.G_MISS_CHAR,
490: p_old_adj_tbl(1).attribute98,p_newtx_rec.attribute98),
491: DECODE(p_newtx_rec.attribute99,FND_API.G_MISS_CHAR,
492: p_old_adj_tbl(1).attribute99,p_newtx_rec.attribute99),
493: DECODE(p_newtx_rec.attribute100,FND_API.G_MISS_CHAR,
494: p_old_adj_tbl(1).attribute100,p_newtx_rec.attribute100),
495: DECODE(p_newtx_rec.rollup_date,FND_API.G_MISS_DATE,
496: p_old_adj_tbl(1).rollup_date,p_newtx_rec.rollup_date),
497: DECODE(p_newtx_rec.source_doc_type,FND_API.G_MISS_CHAR,
491: DECODE(p_newtx_rec.attribute99,FND_API.G_MISS_CHAR,
492: p_old_adj_tbl(1).attribute99,p_newtx_rec.attribute99),
493: DECODE(p_newtx_rec.attribute100,FND_API.G_MISS_CHAR,
494: p_old_adj_tbl(1).attribute100,p_newtx_rec.attribute100),
495: DECODE(p_newtx_rec.rollup_date,FND_API.G_MISS_DATE,
496: p_old_adj_tbl(1).rollup_date,p_newtx_rec.rollup_date),
497: DECODE(p_newtx_rec.source_doc_type,FND_API.G_MISS_CHAR,
498: p_old_adj_tbl(1).source_doc_type,p_newtx_rec.source_doc_type),
499: DECODE(p_newtx_rec.orig_currency_code,FND_API.G_MISS_CHAR,
493: DECODE(p_newtx_rec.attribute100,FND_API.G_MISS_CHAR,
494: p_old_adj_tbl(1).attribute100,p_newtx_rec.attribute100),
495: DECODE(p_newtx_rec.rollup_date,FND_API.G_MISS_DATE,
496: p_old_adj_tbl(1).rollup_date,p_newtx_rec.rollup_date),
497: DECODE(p_newtx_rec.source_doc_type,FND_API.G_MISS_CHAR,
498: p_old_adj_tbl(1).source_doc_type,p_newtx_rec.source_doc_type),
499: DECODE(p_newtx_rec.orig_currency_code,FND_API.G_MISS_CHAR,
500: p_old_adj_tbl(1).orig_currency_code,
501: p_newtx_rec.orig_currency_code),
495: DECODE(p_newtx_rec.rollup_date,FND_API.G_MISS_DATE,
496: p_old_adj_tbl(1).rollup_date,p_newtx_rec.rollup_date),
497: DECODE(p_newtx_rec.source_doc_type,FND_API.G_MISS_CHAR,
498: p_old_adj_tbl(1).source_doc_type,p_newtx_rec.source_doc_type),
499: DECODE(p_newtx_rec.orig_currency_code,FND_API.G_MISS_CHAR,
500: p_old_adj_tbl(1).orig_currency_code,
501: p_newtx_rec.orig_currency_code),
502:
503: l_exchange_rate,
501: p_newtx_rec.orig_currency_code),
502:
503: l_exchange_rate,
504:
505: DECODE(p_newtx_rec.transaction_amount_orig,FND_API.G_MISS_NUM,
506: p_old_adj_tbl(1).transaction_amount_orig,
507: p_newtx_rec.transaction_amount_orig),
508: -- Bug fix 5220393. Changed decode statement to just null value check.
509: decode(nvl(p_newtx_rec.trx_id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,
505: DECODE(p_newtx_rec.transaction_amount_orig,FND_API.G_MISS_NUM,
506: p_old_adj_tbl(1).transaction_amount_orig,
507: p_newtx_rec.transaction_amount_orig),
508: -- Bug fix 5220393. Changed decode statement to just null value check.
509: decode(nvl(p_newtx_rec.trx_id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,
510: p_old_adj_tbl(1).trx_id, p_newtx_rec.trx_id),
511: decode(nvl(p_newtx_rec.trx_line_id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,
512: p_old_adj_tbl(1).trx_line_id, p_newtx_rec.trx_line_id),
513: decode(nvl(p_newtx_rec.trx_sales_line_id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,
507: p_newtx_rec.transaction_amount_orig),
508: -- Bug fix 5220393. Changed decode statement to just null value check.
509: decode(nvl(p_newtx_rec.trx_id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,
510: p_old_adj_tbl(1).trx_id, p_newtx_rec.trx_id),
511: decode(nvl(p_newtx_rec.trx_line_id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,
512: p_old_adj_tbl(1).trx_line_id, p_newtx_rec.trx_line_id),
513: decode(nvl(p_newtx_rec.trx_sales_line_id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,
514: p_old_adj_tbl(1).trx_sales_line_id, p_newtx_rec.trx_sales_line_id),
515: -- Bug fix 5220393. Changed decode statement to just null value check.
509: decode(nvl(p_newtx_rec.trx_id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,
510: p_old_adj_tbl(1).trx_id, p_newtx_rec.trx_id),
511: decode(nvl(p_newtx_rec.trx_line_id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,
512: p_old_adj_tbl(1).trx_line_id, p_newtx_rec.trx_line_id),
513: decode(nvl(p_newtx_rec.trx_sales_line_id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,
514: p_old_adj_tbl(1).trx_sales_line_id, p_newtx_rec.trx_sales_line_id),
515: -- Bug fix 5220393. Changed decode statement to just null value check.
516: DECODE(p_newtx_rec.quantity,FND_API.G_MISS_NUM,
517: p_old_adj_tbl(1).quantity,p_newtx_rec.quantity),
512: p_old_adj_tbl(1).trx_line_id, p_newtx_rec.trx_line_id),
513: decode(nvl(p_newtx_rec.trx_sales_line_id, FND_API.G_MISS_NUM),FND_API.G_MISS_NUM,
514: p_old_adj_tbl(1).trx_sales_line_id, p_newtx_rec.trx_sales_line_id),
515: -- Bug fix 5220393. Changed decode statement to just null value check.
516: DECODE(p_newtx_rec.quantity,FND_API.G_MISS_NUM,
517: p_old_adj_tbl(1).quantity,p_newtx_rec.quantity),
518: DECODE(p_newtx_rec.source_trx_number,FND_API.G_MISS_CHAR,
519: p_old_adj_tbl(1).source_trx_number,p_newtx_rec.source_trx_number),
520: DECODE(p_newtx_rec.discount_percentage,FND_API.G_MISS_NUM,
514: p_old_adj_tbl(1).trx_sales_line_id, p_newtx_rec.trx_sales_line_id),
515: -- Bug fix 5220393. Changed decode statement to just null value check.
516: DECODE(p_newtx_rec.quantity,FND_API.G_MISS_NUM,
517: p_old_adj_tbl(1).quantity,p_newtx_rec.quantity),
518: DECODE(p_newtx_rec.source_trx_number,FND_API.G_MISS_CHAR,
519: p_old_adj_tbl(1).source_trx_number,p_newtx_rec.source_trx_number),
520: DECODE(p_newtx_rec.discount_percentage,FND_API.G_MISS_NUM,
521: p_old_adj_tbl(1).discount_percentage,p_newtx_rec.discount_percentage),
522: DECODE(p_newtx_rec.margin_percentage,FND_API.G_MISS_NUM,
516: DECODE(p_newtx_rec.quantity,FND_API.G_MISS_NUM,
517: p_old_adj_tbl(1).quantity,p_newtx_rec.quantity),
518: DECODE(p_newtx_rec.source_trx_number,FND_API.G_MISS_CHAR,
519: p_old_adj_tbl(1).source_trx_number,p_newtx_rec.source_trx_number),
520: DECODE(p_newtx_rec.discount_percentage,FND_API.G_MISS_NUM,
521: p_old_adj_tbl(1).discount_percentage,p_newtx_rec.discount_percentage),
522: DECODE(p_newtx_rec.margin_percentage,FND_API.G_MISS_NUM,
523: p_old_adj_tbl(1).margin_percentage,p_newtx_rec.margin_percentage),
524: DECODE(p_newtx_rec.customer_id,FND_API.G_MISS_NUM,
518: DECODE(p_newtx_rec.source_trx_number,FND_API.G_MISS_CHAR,
519: p_old_adj_tbl(1).source_trx_number,p_newtx_rec.source_trx_number),
520: DECODE(p_newtx_rec.discount_percentage,FND_API.G_MISS_NUM,
521: p_old_adj_tbl(1).discount_percentage,p_newtx_rec.discount_percentage),
522: DECODE(p_newtx_rec.margin_percentage,FND_API.G_MISS_NUM,
523: p_old_adj_tbl(1).margin_percentage,p_newtx_rec.margin_percentage),
524: DECODE(p_newtx_rec.customer_id,FND_API.G_MISS_NUM,
525: p_old_adj_tbl(1).customer_id,p_newtx_rec.customer_id),
526: DECODE(p_newtx_rec.order_number,FND_API.G_MISS_NUM,
520: DECODE(p_newtx_rec.discount_percentage,FND_API.G_MISS_NUM,
521: p_old_adj_tbl(1).discount_percentage,p_newtx_rec.discount_percentage),
522: DECODE(p_newtx_rec.margin_percentage,FND_API.G_MISS_NUM,
523: p_old_adj_tbl(1).margin_percentage,p_newtx_rec.margin_percentage),
524: DECODE(p_newtx_rec.customer_id,FND_API.G_MISS_NUM,
525: p_old_adj_tbl(1).customer_id,p_newtx_rec.customer_id),
526: DECODE(p_newtx_rec.order_number,FND_API.G_MISS_NUM,
527: p_old_adj_tbl(1).order_number,p_newtx_rec.order_number),
528: p_newtx_rec.order_date,
522: DECODE(p_newtx_rec.margin_percentage,FND_API.G_MISS_NUM,
523: p_old_adj_tbl(1).margin_percentage,p_newtx_rec.margin_percentage),
524: DECODE(p_newtx_rec.customer_id,FND_API.G_MISS_NUM,
525: p_old_adj_tbl(1).customer_id,p_newtx_rec.customer_id),
526: DECODE(p_newtx_rec.order_number,FND_API.G_MISS_NUM,
527: p_old_adj_tbl(1).order_number,p_newtx_rec.order_number),
528: p_newtx_rec.order_date,
529: DECODE(p_newtx_rec.invoice_number,FND_API.G_MISS_CHAR,
530: p_old_adj_tbl(1).invoice_number,p_newtx_rec.invoice_number),
525: p_old_adj_tbl(1).customer_id,p_newtx_rec.customer_id),
526: DECODE(p_newtx_rec.order_number,FND_API.G_MISS_NUM,
527: p_old_adj_tbl(1).order_number,p_newtx_rec.order_number),
528: p_newtx_rec.order_date,
529: DECODE(p_newtx_rec.invoice_number,FND_API.G_MISS_CHAR,
530: p_old_adj_tbl(1).invoice_number,p_newtx_rec.invoice_number),
531: p_newtx_rec.invoice_date,
532: SYSDATE,
533: DECODE(p_newtx_rec.revenue_type,FND_API.G_MISS_CHAR,
529: DECODE(p_newtx_rec.invoice_number,FND_API.G_MISS_CHAR,
530: p_old_adj_tbl(1).invoice_number,p_newtx_rec.invoice_number),
531: p_newtx_rec.invoice_date,
532: SYSDATE,
533: DECODE(p_newtx_rec.revenue_type,FND_API.G_MISS_CHAR,
534: p_old_adj_tbl(1).revenue_type,p_newtx_rec.revenue_type),
535: DECODE(p_newtx_rec.adjust_comments,FND_API.G_MISS_CHAR,
536: p_old_adj_tbl(1).adjust_comments,p_newtx_rec.adjust_comments),
537: DECODE(p_newtx_rec.adjust_status,FND_API.G_MISS_CHAR,
531: p_newtx_rec.invoice_date,
532: SYSDATE,
533: DECODE(p_newtx_rec.revenue_type,FND_API.G_MISS_CHAR,
534: p_old_adj_tbl(1).revenue_type,p_newtx_rec.revenue_type),
535: DECODE(p_newtx_rec.adjust_comments,FND_API.G_MISS_CHAR,
536: p_old_adj_tbl(1).adjust_comments,p_newtx_rec.adjust_comments),
537: DECODE(p_newtx_rec.adjust_status,FND_API.G_MISS_CHAR,
538: p_old_adj_tbl(1).adjust_status,p_newtx_rec.adjust_status),
539: DECODE(p_newtx_rec.line_number,FND_API.G_MISS_NUM,
533: DECODE(p_newtx_rec.revenue_type,FND_API.G_MISS_CHAR,
534: p_old_adj_tbl(1).revenue_type,p_newtx_rec.revenue_type),
535: DECODE(p_newtx_rec.adjust_comments,FND_API.G_MISS_CHAR,
536: p_old_adj_tbl(1).adjust_comments,p_newtx_rec.adjust_comments),
537: DECODE(p_newtx_rec.adjust_status,FND_API.G_MISS_CHAR,
538: p_old_adj_tbl(1).adjust_status,p_newtx_rec.adjust_status),
539: DECODE(p_newtx_rec.line_number,FND_API.G_MISS_NUM,
540: p_old_adj_tbl(1).line_number,p_newtx_rec.line_number),
541: DECODE(p_newtx_rec.bill_to_address_id,FND_API.G_MISS_NUM,
535: DECODE(p_newtx_rec.adjust_comments,FND_API.G_MISS_CHAR,
536: p_old_adj_tbl(1).adjust_comments,p_newtx_rec.adjust_comments),
537: DECODE(p_newtx_rec.adjust_status,FND_API.G_MISS_CHAR,
538: p_old_adj_tbl(1).adjust_status,p_newtx_rec.adjust_status),
539: DECODE(p_newtx_rec.line_number,FND_API.G_MISS_NUM,
540: p_old_adj_tbl(1).line_number,p_newtx_rec.line_number),
541: DECODE(p_newtx_rec.bill_to_address_id,FND_API.G_MISS_NUM,
542: p_old_adj_tbl(1).bill_to_address_id,p_newtx_rec.bill_to_address_id),
543: DECODE(p_newtx_rec.ship_to_address_id,FND_API.G_MISS_NUM,
537: DECODE(p_newtx_rec.adjust_status,FND_API.G_MISS_CHAR,
538: p_old_adj_tbl(1).adjust_status,p_newtx_rec.adjust_status),
539: DECODE(p_newtx_rec.line_number,FND_API.G_MISS_NUM,
540: p_old_adj_tbl(1).line_number,p_newtx_rec.line_number),
541: DECODE(p_newtx_rec.bill_to_address_id,FND_API.G_MISS_NUM,
542: p_old_adj_tbl(1).bill_to_address_id,p_newtx_rec.bill_to_address_id),
543: DECODE(p_newtx_rec.ship_to_address_id,FND_API.G_MISS_NUM,
544: p_old_adj_tbl(1).ship_to_address_id,p_newtx_rec.ship_to_address_id),
545: DECODE(p_newtx_rec.bill_to_contact_id,FND_API.G_MISS_NUM,
539: DECODE(p_newtx_rec.line_number,FND_API.G_MISS_NUM,
540: p_old_adj_tbl(1).line_number,p_newtx_rec.line_number),
541: DECODE(p_newtx_rec.bill_to_address_id,FND_API.G_MISS_NUM,
542: p_old_adj_tbl(1).bill_to_address_id,p_newtx_rec.bill_to_address_id),
543: DECODE(p_newtx_rec.ship_to_address_id,FND_API.G_MISS_NUM,
544: p_old_adj_tbl(1).ship_to_address_id,p_newtx_rec.ship_to_address_id),
545: DECODE(p_newtx_rec.bill_to_contact_id,FND_API.G_MISS_NUM,
546: p_old_adj_tbl(1).bill_to_contact_id,p_newtx_rec.bill_to_contact_id),
547: DECODE(p_newtx_rec.ship_to_contact_id,FND_API.G_MISS_NUM,
541: DECODE(p_newtx_rec.bill_to_address_id,FND_API.G_MISS_NUM,
542: p_old_adj_tbl(1).bill_to_address_id,p_newtx_rec.bill_to_address_id),
543: DECODE(p_newtx_rec.ship_to_address_id,FND_API.G_MISS_NUM,
544: p_old_adj_tbl(1).ship_to_address_id,p_newtx_rec.ship_to_address_id),
545: DECODE(p_newtx_rec.bill_to_contact_id,FND_API.G_MISS_NUM,
546: p_old_adj_tbl(1).bill_to_contact_id,p_newtx_rec.bill_to_contact_id),
547: DECODE(p_newtx_rec.ship_to_contact_id,FND_API.G_MISS_NUM,
548: p_old_adj_tbl(1).ship_to_contact_id,p_newtx_rec.ship_to_contact_id),
549: DECODE(p_newtx_rec.reason_code,FND_API.G_MISS_CHAR,
543: DECODE(p_newtx_rec.ship_to_address_id,FND_API.G_MISS_NUM,
544: p_old_adj_tbl(1).ship_to_address_id,p_newtx_rec.ship_to_address_id),
545: DECODE(p_newtx_rec.bill_to_contact_id,FND_API.G_MISS_NUM,
546: p_old_adj_tbl(1).bill_to_contact_id,p_newtx_rec.bill_to_contact_id),
547: DECODE(p_newtx_rec.ship_to_contact_id,FND_API.G_MISS_NUM,
548: p_old_adj_tbl(1).ship_to_contact_id,p_newtx_rec.ship_to_contact_id),
549: DECODE(p_newtx_rec.reason_code,FND_API.G_MISS_CHAR,
550: p_old_adj_tbl(1).reason_code,p_newtx_rec.reason_code),
551: DECODE(p_newtx_rec.quota_id,FND_API.G_MISS_NUM,
545: DECODE(p_newtx_rec.bill_to_contact_id,FND_API.G_MISS_NUM,
546: p_old_adj_tbl(1).bill_to_contact_id,p_newtx_rec.bill_to_contact_id),
547: DECODE(p_newtx_rec.ship_to_contact_id,FND_API.G_MISS_NUM,
548: p_old_adj_tbl(1).ship_to_contact_id,p_newtx_rec.ship_to_contact_id),
549: DECODE(p_newtx_rec.reason_code,FND_API.G_MISS_CHAR,
550: p_old_adj_tbl(1).reason_code,p_newtx_rec.reason_code),
551: DECODE(p_newtx_rec.quota_id,FND_API.G_MISS_NUM,
552: p_old_adj_tbl(1).quota_id,p_newtx_rec.quota_id),
553: p_newtx_rec.comp_group_id,
547: DECODE(p_newtx_rec.ship_to_contact_id,FND_API.G_MISS_NUM,
548: p_old_adj_tbl(1).ship_to_contact_id,p_newtx_rec.ship_to_contact_id),
549: DECODE(p_newtx_rec.reason_code,FND_API.G_MISS_CHAR,
550: p_old_adj_tbl(1).reason_code,p_newtx_rec.reason_code),
551: DECODE(p_newtx_rec.quota_id,FND_API.G_MISS_NUM,
552: p_old_adj_tbl(1).quota_id,p_newtx_rec.quota_id),
553: p_newtx_rec.comp_group_id,
554: DECODE(p_newtx_rec.direct_salesrep_number,FND_API.G_MISS_CHAR,
555: p_old_adj_tbl(1).direct_salesrep_number,
550: p_old_adj_tbl(1).reason_code,p_newtx_rec.reason_code),
551: DECODE(p_newtx_rec.quota_id,FND_API.G_MISS_NUM,
552: p_old_adj_tbl(1).quota_id,p_newtx_rec.quota_id),
553: p_newtx_rec.comp_group_id,
554: DECODE(p_newtx_rec.direct_salesrep_number,FND_API.G_MISS_CHAR,
555: p_old_adj_tbl(1).direct_salesrep_number,
556: p_newtx_rec.direct_salesrep_number),
557: DECODE(p_newtx_rec.sales_channel,FND_API.G_MISS_CHAR,
558: p_old_adj_tbl(1).sales_channel,p_newtx_rec.sales_channel),
553: p_newtx_rec.comp_group_id,
554: DECODE(p_newtx_rec.direct_salesrep_number,FND_API.G_MISS_CHAR,
555: p_old_adj_tbl(1).direct_salesrep_number,
556: p_newtx_rec.direct_salesrep_number),
557: DECODE(p_newtx_rec.sales_channel,FND_API.G_MISS_CHAR,
558: p_old_adj_tbl(1).sales_channel,p_newtx_rec.sales_channel),
559: DECODE(p_newtx_rec.split_pct,FND_API.G_MISS_NUM,
560: p_old_adj_tbl(1).split_pct,p_newtx_rec.split_pct),
561: DECODE(p_newtx_rec.split_status,FND_API.G_MISS_CHAR,
555: p_old_adj_tbl(1).direct_salesrep_number,
556: p_newtx_rec.direct_salesrep_number),
557: DECODE(p_newtx_rec.sales_channel,FND_API.G_MISS_CHAR,
558: p_old_adj_tbl(1).sales_channel,p_newtx_rec.sales_channel),
559: DECODE(p_newtx_rec.split_pct,FND_API.G_MISS_NUM,
560: p_old_adj_tbl(1).split_pct,p_newtx_rec.split_pct),
561: DECODE(p_newtx_rec.split_status,FND_API.G_MISS_CHAR,
562: p_old_adj_tbl(1).split_status,p_newtx_rec.split_status),
563: DECODE(p_newtx_rec.commission_amount,FND_API.G_MISS_CHAR,
557: DECODE(p_newtx_rec.sales_channel,FND_API.G_MISS_CHAR,
558: p_old_adj_tbl(1).sales_channel,p_newtx_rec.sales_channel),
559: DECODE(p_newtx_rec.split_pct,FND_API.G_MISS_NUM,
560: p_old_adj_tbl(1).split_pct,p_newtx_rec.split_pct),
561: DECODE(p_newtx_rec.split_status,FND_API.G_MISS_CHAR,
562: p_old_adj_tbl(1).split_status,p_newtx_rec.split_status),
563: DECODE(p_newtx_rec.commission_amount,FND_API.G_MISS_CHAR,
564: p_old_adj_tbl(1).commission_amount,p_newtx_rec.commission_amount),
565: DECODE(p_newtx_rec.role_id,FND_API.G_MISS_NUM,
559: DECODE(p_newtx_rec.split_pct,FND_API.G_MISS_NUM,
560: p_old_adj_tbl(1).split_pct,p_newtx_rec.split_pct),
561: DECODE(p_newtx_rec.split_status,FND_API.G_MISS_CHAR,
562: p_old_adj_tbl(1).split_status,p_newtx_rec.split_status),
563: DECODE(p_newtx_rec.commission_amount,FND_API.G_MISS_CHAR,
564: p_old_adj_tbl(1).commission_amount,p_newtx_rec.commission_amount),
565: DECODE(p_newtx_rec.role_id,FND_API.G_MISS_NUM,
566: p_old_adj_tbl(1).role_id,p_newtx_rec.role_id),
567: DECODE(p_newtx_rec.pre_processed_code,FND_API.G_MISS_CHAR,
561: DECODE(p_newtx_rec.split_status,FND_API.G_MISS_CHAR,
562: p_old_adj_tbl(1).split_status,p_newtx_rec.split_status),
563: DECODE(p_newtx_rec.commission_amount,FND_API.G_MISS_CHAR,
564: p_old_adj_tbl(1).commission_amount,p_newtx_rec.commission_amount),
565: DECODE(p_newtx_rec.role_id,FND_API.G_MISS_NUM,
566: p_old_adj_tbl(1).role_id,p_newtx_rec.role_id),
567: DECODE(p_newtx_rec.pre_processed_code,FND_API.G_MISS_CHAR,
568: p_old_adj_tbl(1).pre_processed_code,p_newtx_rec.pre_processed_code),
569: DECODE(p_newtx_rec.org_id,FND_API.G_MISS_NUM,
563: DECODE(p_newtx_rec.commission_amount,FND_API.G_MISS_CHAR,
564: p_old_adj_tbl(1).commission_amount,p_newtx_rec.commission_amount),
565: DECODE(p_newtx_rec.role_id,FND_API.G_MISS_NUM,
566: p_old_adj_tbl(1).role_id,p_newtx_rec.role_id),
567: DECODE(p_newtx_rec.pre_processed_code,FND_API.G_MISS_CHAR,
568: p_old_adj_tbl(1).pre_processed_code,p_newtx_rec.pre_processed_code),
569: DECODE(p_newtx_rec.org_id,FND_API.G_MISS_NUM,
570: p_old_adj_tbl(1).org_id,p_newtx_rec.org_id),
571: /* Added for Crediting Bug */
565: DECODE(p_newtx_rec.role_id,FND_API.G_MISS_NUM,
566: p_old_adj_tbl(1).role_id,p_newtx_rec.role_id),
567: DECODE(p_newtx_rec.pre_processed_code,FND_API.G_MISS_CHAR,
568: p_old_adj_tbl(1).pre_processed_code,p_newtx_rec.pre_processed_code),
569: DECODE(p_newtx_rec.org_id,FND_API.G_MISS_NUM,
570: p_old_adj_tbl(1).org_id,p_newtx_rec.org_id),
571: /* Added for Crediting Bug */
572: DECODE(p_newtx_rec.terr_id,FND_API.G_MISS_NUM,
573: p_old_adj_tbl(1).terr_id,p_newtx_rec.terr_id),
568: p_old_adj_tbl(1).pre_processed_code,p_newtx_rec.pre_processed_code),
569: DECODE(p_newtx_rec.org_id,FND_API.G_MISS_NUM,
570: p_old_adj_tbl(1).org_id,p_newtx_rec.org_id),
571: /* Added for Crediting Bug */
572: DECODE(p_newtx_rec.terr_id,FND_API.G_MISS_NUM,
573: p_old_adj_tbl(1).terr_id,p_newtx_rec.terr_id),
574: DECODE(p_newtx_rec.terr_name,FND_API.G_MISS_CHAR,
575: p_old_adj_tbl(1).terr_name,p_newtx_rec.terr_name) ,
576: DECODE(p_newtx_rec.preserve_credit_override_flag,FND_API.G_MISS_CHAR,
570: p_old_adj_tbl(1).org_id,p_newtx_rec.org_id),
571: /* Added for Crediting Bug */
572: DECODE(p_newtx_rec.terr_id,FND_API.G_MISS_NUM,
573: p_old_adj_tbl(1).terr_id,p_newtx_rec.terr_id),
574: DECODE(p_newtx_rec.terr_name,FND_API.G_MISS_CHAR,
575: p_old_adj_tbl(1).terr_name,p_newtx_rec.terr_name) ,
576: DECODE(p_newtx_rec.preserve_credit_override_flag,FND_API.G_MISS_CHAR,
577: p_old_adj_tbl(1).preserve_credit_override_flag,p_newtx_rec.preserve_credit_override_flag)
578: INTO x_final_trx_rec.direct_salesrep_id, x_final_trx_rec.inventory_item_id,
572: DECODE(p_newtx_rec.terr_id,FND_API.G_MISS_NUM,
573: p_old_adj_tbl(1).terr_id,p_newtx_rec.terr_id),
574: DECODE(p_newtx_rec.terr_name,FND_API.G_MISS_CHAR,
575: p_old_adj_tbl(1).terr_name,p_newtx_rec.terr_name) ,
576: DECODE(p_newtx_rec.preserve_credit_override_flag,FND_API.G_MISS_CHAR,
577: p_old_adj_tbl(1).preserve_credit_override_flag,p_newtx_rec.preserve_credit_override_flag)
578: INTO x_final_trx_rec.direct_salesrep_id, x_final_trx_rec.inventory_item_id,
579: x_final_trx_rec.source_trx_id, x_final_trx_rec.source_trx_line_id,
580: x_final_trx_rec.source_trx_sales_line_id ,
653: x_final_trx_rec.pre_processed_code, x_final_trx_rec.org_id,
654: x_final_trx_rec.terr_id, x_final_trx_rec.terr_name,
655: x_final_trx_rec.preserve_credit_override_flag
656: FROM dual;
657: x_return_status := FND_API.G_RET_STS_SUCCESS;
658: EXCEPTION
659: WHEN OTHERS THEN
660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
661: END;
656: FROM dual;
657: x_return_status := FND_API.G_RET_STS_SUCCESS;
658: EXCEPTION
659: WHEN OTHERS THEN
660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
661: END;
662: --
663: PROCEDURE update_invoice_changes(
664: p_api_version IN NUMBER,
661: END;
662: --
663: PROCEDURE update_invoice_changes(
664: p_api_version IN NUMBER,
665: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
666: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
667: p_existing_data IN invoice_tbl,
668: p_new_data IN invoice_tbl,
669: p_exist_data_check IN VARCHAR2 DEFAULT NULL,
662: --
663: PROCEDURE update_invoice_changes(
664: p_api_version IN NUMBER,
665: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
666: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
667: p_existing_data IN invoice_tbl,
668: p_new_data IN invoice_tbl,
669: p_exist_data_check IN VARCHAR2 DEFAULT NULL,
670: p_new_data_check IN VARCHAR2 DEFAULT NULL,
689: BEGIN
690: -- Standard Start of API savepoint
691: SAVEPOINT update_invoice_changes;
692: -- Standard call to check for call compatibility.
693: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
694: p_api_version ,
695: l_api_name,
696: G_PKG_NAME ) THEN
697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
693: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
694: p_api_version ,
695: l_api_name,
696: G_PKG_NAME ) THEN
697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
698: END IF;
699: -- Initialize message list if p_init_msg_list is set to TRUE.
700: IF FND_API.to_Boolean( p_init_msg_list ) THEN
701: FND_MSG_PUB.initialize;
696: G_PKG_NAME ) THEN
697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
698: END IF;
699: -- Initialize message list if p_init_msg_list is set to TRUE.
700: IF FND_API.to_Boolean( p_init_msg_list ) THEN
701: FND_MSG_PUB.initialize;
702: END IF;
703: -- Initialize API return status to success
704: x_return_status := FND_API.G_RET_STS_SUCCESS;
700: IF FND_API.to_Boolean( p_init_msg_list ) THEN
701: FND_MSG_PUB.initialize;
702: END IF;
703: -- Initialize API return status to success
704: x_return_status := FND_API.G_RET_STS_SUCCESS;
705: x_loading_status := 'CN_INSERTED';
706: -- API body
707: -- Delete the existing records in cn_invoice_changes table.
708: -- apiId: I need to change here. update_api is OK with api_id.
739: END LOOP;
740: END IF;
741: --
742: EXCEPTION
743: WHEN FND_API.G_EXC_ERROR THEN
744: ROLLBACK TO update_invoice_changes;
745: x_return_status := FND_API.G_RET_STS_ERROR ;
746: FND_MSG_PUB.Count_And_Get(
747: p_count => x_msg_count ,
741: --
742: EXCEPTION
743: WHEN FND_API.G_EXC_ERROR THEN
744: ROLLBACK TO update_invoice_changes;
745: x_return_status := FND_API.G_RET_STS_ERROR ;
746: FND_MSG_PUB.Count_And_Get(
747: p_count => x_msg_count ,
748: p_data => x_msg_data ,
749: p_encoded => FND_API.G_FALSE);
745: x_return_status := FND_API.G_RET_STS_ERROR ;
746: FND_MSG_PUB.Count_And_Get(
747: p_count => x_msg_count ,
748: p_data => x_msg_data ,
749: p_encoded => FND_API.G_FALSE);
750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
751: ROLLBACK TO update_invoice_changes;
752: x_loading_status := 'UNEXPECTED_ERR';
753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
746: FND_MSG_PUB.Count_And_Get(
747: p_count => x_msg_count ,
748: p_data => x_msg_data ,
749: p_encoded => FND_API.G_FALSE);
750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
751: ROLLBACK TO update_invoice_changes;
752: x_loading_status := 'UNEXPECTED_ERR';
753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
754: FND_MSG_PUB.Count_And_Get(
749: p_encoded => FND_API.G_FALSE);
750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
751: ROLLBACK TO update_invoice_changes;
752: x_loading_status := 'UNEXPECTED_ERR';
753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
754: FND_MSG_PUB.Count_And_Get(
755: p_count => x_msg_count ,
756: p_data => x_msg_data ,
757: p_encoded => FND_API.G_FALSE);
753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
754: FND_MSG_PUB.Count_And_Get(
755: p_count => x_msg_count ,
756: p_data => x_msg_data ,
757: p_encoded => FND_API.G_FALSE);
758: WHEN OTHERS THEN
759: ROLLBACK TO update_invoice_changes;
760: x_loading_status := 'UNEXPECTED_ERR';
761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
757: p_encoded => FND_API.G_FALSE);
758: WHEN OTHERS THEN
759: ROLLBACK TO update_invoice_changes;
760: x_loading_status := 'UNEXPECTED_ERR';
761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
762: IF FND_MSG_PUB.Check_Msg_Level(
763: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
764: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
765: END IF;
765: END IF;
766: FND_MSG_PUB.Count_And_Get(
767: p_count => x_msg_count ,
768: p_data => x_msg_data ,
769: p_encoded => FND_API.G_FALSE);
770: END;
771: --
772: /*-----------------------------------------------------------------------------
773: update_credit_memo logic:
782: Step 9: Call cn_get_tx_data_pub.insert_api_record to create a new record.
783: -----------------------------------------------------------------------------*/
784: PROCEDURE update_credit_memo(
785: p_api_version IN NUMBER,
786: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
787: p_validation_level IN VARCHAR2:= FND_API.G_VALID_LEVEL_FULL,
788: p_existing_data IN invoice_tbl,
789: p_new_data IN invoice_tbl,
790: p_to_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
783: -----------------------------------------------------------------------------*/
784: PROCEDURE update_credit_memo(
785: p_api_version IN NUMBER,
786: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
787: p_validation_level IN VARCHAR2:= FND_API.G_VALID_LEVEL_FULL,
788: p_existing_data IN invoice_tbl,
789: p_new_data IN invoice_tbl,
790: p_to_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
791: p_to_salesrep_number IN VARCHAR2:= FND_API.G_MISS_CHAR,
786: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
787: p_validation_level IN VARCHAR2:= FND_API.G_VALID_LEVEL_FULL,
788: p_existing_data IN invoice_tbl,
789: p_new_data IN invoice_tbl,
790: p_to_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
791: p_to_salesrep_number IN VARCHAR2:= FND_API.G_MISS_CHAR,
792: p_called_from IN VARCHAR2,
793: p_adjust_status IN VARCHAR2,
794: x_return_status OUT NOCOPY VARCHAR2,
787: p_validation_level IN VARCHAR2:= FND_API.G_VALID_LEVEL_FULL,
788: p_existing_data IN invoice_tbl,
789: p_new_data IN invoice_tbl,
790: p_to_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
791: p_to_salesrep_number IN VARCHAR2:= FND_API.G_MISS_CHAR,
792: p_called_from IN VARCHAR2,
793: p_adjust_status IN VARCHAR2,
794: x_return_status OUT NOCOPY VARCHAR2,
795: x_msg_count OUT NOCOPY NUMBER,
854: BEGIN
855: -- Standard Start of API savepoint
856: SAVEPOINT update_credit_memo;
857: -- Standard call to check for call compatibility.
858: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
859: p_api_version ,
860: l_api_name,
861: G_PKG_NAME ) THEN
862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
858: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
859: p_api_version ,
860: l_api_name,
861: G_PKG_NAME ) THEN
862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
863: END IF;
864: -- Initialize message list if p_init_msg_list is set to TRUE.
865: IF FND_API.to_Boolean( p_init_msg_list ) THEN
866: FND_MSG_PUB.initialize;
861: G_PKG_NAME ) THEN
862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
863: END IF;
864: -- Initialize message list if p_init_msg_list is set to TRUE.
865: IF FND_API.to_Boolean( p_init_msg_list ) THEN
866: FND_MSG_PUB.initialize;
867: END IF;
868: -- Initialize API return status to success
869: x_return_status := FND_API.G_RET_STS_SUCCESS;
865: IF FND_API.to_Boolean( p_init_msg_list ) THEN
866: FND_MSG_PUB.initialize;
867: END IF;
868: -- Initialize API return status to success
869: x_return_status := FND_API.G_RET_STS_SUCCESS;
870: x_loading_status := 'CN_INSERTED';
871: -- API body
872: -- Based on the input criteria get all the records
873: FOR i IN p_existing_data.FIRST..p_existing_data.LAST
1355: --
1356: END LOOP;
1357: -- Create new records in the same table.
1358: EXCEPTION
1359: WHEN FND_API.G_EXC_ERROR THEN
1360: ROLLBACK TO update_credit_memo;
1361: x_return_status := FND_API.G_RET_STS_ERROR ;
1362: FND_MSG_PUB.Count_And_Get(
1363: p_count => x_msg_count ,
1357: -- Create new records in the same table.
1358: EXCEPTION
1359: WHEN FND_API.G_EXC_ERROR THEN
1360: ROLLBACK TO update_credit_memo;
1361: x_return_status := FND_API.G_RET_STS_ERROR ;
1362: FND_MSG_PUB.Count_And_Get(
1363: p_count => x_msg_count ,
1364: p_data => x_msg_data ,
1365: p_encoded => FND_API.G_FALSE);
1361: x_return_status := FND_API.G_RET_STS_ERROR ;
1362: FND_MSG_PUB.Count_And_Get(
1363: p_count => x_msg_count ,
1364: p_data => x_msg_data ,
1365: p_encoded => FND_API.G_FALSE);
1366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1367: ROLLBACK TO update_credit_memo;
1368: x_loading_status := 'UNEXPECTED_ERR';
1369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1362: FND_MSG_PUB.Count_And_Get(
1363: p_count => x_msg_count ,
1364: p_data => x_msg_data ,
1365: p_encoded => FND_API.G_FALSE);
1366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1367: ROLLBACK TO update_credit_memo;
1368: x_loading_status := 'UNEXPECTED_ERR';
1369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1370: FND_MSG_PUB.Count_And_Get(
1365: p_encoded => FND_API.G_FALSE);
1366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1367: ROLLBACK TO update_credit_memo;
1368: x_loading_status := 'UNEXPECTED_ERR';
1369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1370: FND_MSG_PUB.Count_And_Get(
1371: p_count => x_msg_count ,
1372: p_data => x_msg_data ,
1373: p_encoded => FND_API.G_FALSE);
1369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1370: FND_MSG_PUB.Count_And_Get(
1371: p_count => x_msg_count ,
1372: p_data => x_msg_data ,
1373: p_encoded => FND_API.G_FALSE);
1374: WHEN OTHERS THEN
1375: ROLLBACK TO update_credit_memo;
1376: x_loading_status := 'UNEXPECTED_ERR';
1377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1373: p_encoded => FND_API.G_FALSE);
1374: WHEN OTHERS THEN
1375: ROLLBACK TO update_credit_memo;
1376: x_loading_status := 'UNEXPECTED_ERR';
1377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1378: IF FND_MSG_PUB.Check_Msg_Level(
1379: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1380: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1381: END IF;
1381: END IF;
1382: FND_MSG_PUB.Count_And_Get(
1383: p_count => x_msg_count ,
1384: p_data => x_msg_data ,
1385: p_encoded => FND_API.G_FALSE);
1386: END;
1387: --
1388: PROCEDURE update_mass_invoices (
1389: p_api_version IN NUMBER,
1386: END;
1387: --
1388: PROCEDURE update_mass_invoices (
1389: p_api_version IN NUMBER,
1390: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
1391: p_validation_level IN VARCHAR2:= FND_API.G_VALID_LEVEL_FULL,
1392: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
1393: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
1394: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
1387: --
1388: PROCEDURE update_mass_invoices (
1389: p_api_version IN NUMBER,
1390: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
1391: p_validation_level IN VARCHAR2:= FND_API.G_VALID_LEVEL_FULL,
1392: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
1393: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
1394: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
1395: p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
1388: PROCEDURE update_mass_invoices (
1389: p_api_version IN NUMBER,
1390: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
1391: p_validation_level IN VARCHAR2:= FND_API.G_VALID_LEVEL_FULL,
1392: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
1393: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
1394: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
1395: p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
1396: p_invoice_num IN VARCHAR2:= FND_API.G_MISS_CHAR,
1389: p_api_version IN NUMBER,
1390: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
1391: p_validation_level IN VARCHAR2:= FND_API.G_VALID_LEVEL_FULL,
1392: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
1393: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
1394: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
1395: p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
1396: p_invoice_num IN VARCHAR2:= FND_API.G_MISS_CHAR,
1397: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
1390: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
1391: p_validation_level IN VARCHAR2:= FND_API.G_VALID_LEVEL_FULL,
1392: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
1393: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
1394: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
1395: p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
1396: p_invoice_num IN VARCHAR2:= FND_API.G_MISS_CHAR,
1397: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
1398: p_srch_attr_rec IN cn_get_tx_data_pub.adj_rec_type,
1391: p_validation_level IN VARCHAR2:= FND_API.G_VALID_LEVEL_FULL,
1392: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
1393: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
1394: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
1395: p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
1396: p_invoice_num IN VARCHAR2:= FND_API.G_MISS_CHAR,
1397: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
1398: p_srch_attr_rec IN cn_get_tx_data_pub.adj_rec_type,
1399: p_to_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
1392: p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
1393: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
1394: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
1395: p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
1396: p_invoice_num IN VARCHAR2:= FND_API.G_MISS_CHAR,
1397: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
1398: p_srch_attr_rec IN cn_get_tx_data_pub.adj_rec_type,
1399: p_to_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
1400: p_to_salesrep_number IN VARCHAR2:= FND_API.G_MISS_CHAR,
1393: p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
1394: p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
1395: p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
1396: p_invoice_num IN VARCHAR2:= FND_API.G_MISS_CHAR,
1397: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
1398: p_srch_attr_rec IN cn_get_tx_data_pub.adj_rec_type,
1399: p_to_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
1400: p_to_salesrep_number IN VARCHAR2:= FND_API.G_MISS_CHAR,
1401: x_return_status OUT NOCOPY VARCHAR2,
1395: p_calc_status IN VARCHAR2:= FND_API.G_MISS_CHAR,
1396: p_invoice_num IN VARCHAR2:= FND_API.G_MISS_CHAR,
1397: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
1398: p_srch_attr_rec IN cn_get_tx_data_pub.adj_rec_type,
1399: p_to_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
1400: p_to_salesrep_number IN VARCHAR2:= FND_API.G_MISS_CHAR,
1401: x_return_status OUT NOCOPY VARCHAR2,
1402: x_msg_count OUT NOCOPY NUMBER,
1403: x_msg_data OUT NOCOPY VARCHAR2,
1396: p_invoice_num IN VARCHAR2:= FND_API.G_MISS_CHAR,
1397: p_order_num IN NUMBER := FND_API.G_MISS_NUM,
1398: p_srch_attr_rec IN cn_get_tx_data_pub.adj_rec_type,
1399: p_to_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
1400: p_to_salesrep_number IN VARCHAR2:= FND_API.G_MISS_CHAR,
1401: x_return_status OUT NOCOPY VARCHAR2,
1402: x_msg_count OUT NOCOPY NUMBER,
1403: x_msg_data OUT NOCOPY VARCHAR2,
1404: x_loading_status OUT NOCOPY VARCHAR2,
1432: BEGIN
1433: -- Standard Start of API savepoint
1434: SAVEPOINT update_mass_invoices;
1435: -- Standard call to check for call compatibility.
1436: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1437: p_api_version ,
1438: l_api_name,
1439: G_PKG_NAME ) THEN
1440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1436: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1437: p_api_version ,
1438: l_api_name,
1439: G_PKG_NAME ) THEN
1440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1441: END IF;
1442: -- Initialize message list if p_init_msg_list is set to TRUE.
1443: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1444: FND_MSG_PUB.initialize;
1439: G_PKG_NAME ) THEN
1440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1441: END IF;
1442: -- Initialize message list if p_init_msg_list is set to TRUE.
1443: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1444: FND_MSG_PUB.initialize;
1445: END IF;
1446: -- Initialize API return status to success
1447: x_return_status := FND_API.G_RET_STS_SUCCESS;
1443: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1444: FND_MSG_PUB.initialize;
1445: END IF;
1446: -- Initialize API return status to success
1447: x_return_status := FND_API.G_RET_STS_SUCCESS;
1448: x_loading_status := 'CN_INSERTED';
1449: -- API body
1450: l_handle := DBMS_SQL.open_cursor;
1451: l_sql :=
1479: 'AND CCH.trx_batch_id = CTB.trx_batch_id(+) '||
1480: 'AND CCH.trx_type = ''INV'' '||
1481: 'AND ((CCH.adjust_status NOT IN (''REVERSAL'',''FROZEN'')) '||
1482: 'OR (CCH.adjust_status IS NULL)) ';
1483: IF (p_salesrep_id <> FND_API.G_MISS_NUM) THEN
1484: l_sql := l_sql|| ' AND CCH.direct_salesrep_id = :p_salesrep_id';
1485: END IF;
1486: IF (p_pr_date_from <> FND_API.G_MISS_DATE) THEN
1487: l_sql := l_sql|| ' AND CCH.processed_date >= :p_pr_date_from';
1482: 'OR (CCH.adjust_status IS NULL)) ';
1483: IF (p_salesrep_id <> FND_API.G_MISS_NUM) THEN
1484: l_sql := l_sql|| ' AND CCH.direct_salesrep_id = :p_salesrep_id';
1485: END IF;
1486: IF (p_pr_date_from <> FND_API.G_MISS_DATE) THEN
1487: l_sql := l_sql|| ' AND CCH.processed_date >= :p_pr_date_from';
1488: END IF;
1489: IF (p_pr_date_to <> FND_API.G_MISS_DATE) THEN
1490: l_sql := l_sql|| ' AND CCH.processed_date <= :p_pr_date_to';
1485: END IF;
1486: IF (p_pr_date_from <> FND_API.G_MISS_DATE) THEN
1487: l_sql := l_sql|| ' AND CCH.processed_date >= :p_pr_date_from';
1488: END IF;
1489: IF (p_pr_date_to <> FND_API.G_MISS_DATE) THEN
1490: l_sql := l_sql|| ' AND CCH.processed_date <= :p_pr_date_to';
1491: END IF;
1492: IF (p_invoice_num <> FND_API.G_MISS_CHAR) THEN
1493: l_sql := l_sql|| ' AND CCH.invoice_number LIKE :p_invoice_num';
1488: END IF;
1489: IF (p_pr_date_to <> FND_API.G_MISS_DATE) THEN
1490: l_sql := l_sql|| ' AND CCH.processed_date <= :p_pr_date_to';
1491: END IF;
1492: IF (p_invoice_num <> FND_API.G_MISS_CHAR) THEN
1493: l_sql := l_sql|| ' AND CCH.invoice_number LIKE :p_invoice_num';
1494: END IF;
1495: IF (p_order_num <> FND_API.G_MISS_NUM AND p_order_num <> 0) THEN
1496: l_sql := l_sql|| ' AND CCH.order_number = :p_order_num';
1491: END IF;
1492: IF (p_invoice_num <> FND_API.G_MISS_CHAR) THEN
1493: l_sql := l_sql|| ' AND CCH.invoice_number LIKE :p_invoice_num';
1494: END IF;
1495: IF (p_order_num <> FND_API.G_MISS_NUM AND p_order_num <> 0) THEN
1496: l_sql := l_sql|| ' AND CCH.order_number = :p_order_num';
1497: END IF;
1498: IF (p_calc_status <> 'ALL') THEN
1499: l_sql := l_sql|| ' AND CCH.status = :p_calc_status';
1509: l_sql := l_sql|| ' AND API.terr_id IS NULL';
1510: END IF;
1511:
1512: l_keep_flag := p_srch_attr_rec.preserve_credit_override_flag;
1513: IF (l_keep_flag <> FND_API.G_MISS_CHAR AND l_keep_flag IS NOT NULL) THEN
1514: l_sql := l_sql|| ' AND API.preserve_credit_override_flag = :l_keep_flag';
1515: END IF;
1516:
1517: l_sql := l_sql||' GROUP BY CCH.direct_salesrep_id, '||
1542: 'AND nvl(CCLA.load_status,''X'') <> ''LOADED'' '||
1543: 'AND CCLA.trx_type = ''INV'' '||
1544: 'AND ((CCLA.adjust_status NOT IN (''REVERSAL'',''FROZEN'',''SCA_PENDING'')) '||
1545: 'OR (CCLA.adjust_status IS NULL)) ';
1546: IF (p_salesrep_id <> FND_API.G_MISS_NUM) THEN
1547: l_sql := l_sql|| ' AND CCLA.salesrep_id = :p_salesrep_id';
1548: END IF;
1549: IF (p_pr_date_from <> FND_API.G_MISS_DATE) THEN
1550: l_sql := l_sql|| ' AND CCLA.processed_date >= :p_pr_date_from';
1545: 'OR (CCLA.adjust_status IS NULL)) ';
1546: IF (p_salesrep_id <> FND_API.G_MISS_NUM) THEN
1547: l_sql := l_sql|| ' AND CCLA.salesrep_id = :p_salesrep_id';
1548: END IF;
1549: IF (p_pr_date_from <> FND_API.G_MISS_DATE) THEN
1550: l_sql := l_sql|| ' AND CCLA.processed_date >= :p_pr_date_from';
1551: END IF;
1552: IF (p_pr_date_to <> FND_API.G_MISS_DATE) THEN
1553: l_sql := l_sql|| ' AND CCLA.processed_date <= :p_pr_date_to';
1548: END IF;
1549: IF (p_pr_date_from <> FND_API.G_MISS_DATE) THEN
1550: l_sql := l_sql|| ' AND CCLA.processed_date >= :p_pr_date_from';
1551: END IF;
1552: IF (p_pr_date_to <> FND_API.G_MISS_DATE) THEN
1553: l_sql := l_sql|| ' AND CCLA.processed_date <= :p_pr_date_to';
1554: END IF;
1555: IF (p_invoice_num <> FND_API.G_MISS_CHAR) THEN
1556: l_sql := l_sql|| ' AND CCLA.invoice_number LIKE :p_invoice_num';
1551: END IF;
1552: IF (p_pr_date_to <> FND_API.G_MISS_DATE) THEN
1553: l_sql := l_sql|| ' AND CCLA.processed_date <= :p_pr_date_to';
1554: END IF;
1555: IF (p_invoice_num <> FND_API.G_MISS_CHAR) THEN
1556: l_sql := l_sql|| ' AND CCLA.invoice_number LIKE :p_invoice_num';
1557: END IF;
1558: IF (p_order_num <> FND_API.G_MISS_NUM AND p_order_num <> 0) THEN
1559: l_sql := l_sql|| ' AND CCLA.order_number = :p_order_num';
1554: END IF;
1555: IF (p_invoice_num <> FND_API.G_MISS_CHAR) THEN
1556: l_sql := l_sql|| ' AND CCLA.invoice_number LIKE :p_invoice_num';
1557: END IF;
1558: IF (p_order_num <> FND_API.G_MISS_NUM AND p_order_num <> 0) THEN
1559: l_sql := l_sql|| ' AND CCLA.order_number = :p_order_num';
1560: END IF;
1561:
1562: --Added for Crediting
1568: l_sql := l_sql|| ' AND CCLA.terr_id IS NULL';
1569: END IF;
1570:
1571: l_keep_flag := p_srch_attr_rec.preserve_credit_override_flag;
1572: IF (l_keep_flag <> FND_API.G_MISS_CHAR AND l_keep_flag IS NOT NULL) THEN
1573: l_sql := l_sql|| ' AND CCLA.preserve_credit_override_flag = :l_keep_flag';
1574: END IF;
1575:
1576: l_sql := l_sql||' GROUP BY CCLA.salesrep_id, '||
1580: END IF;
1581: --insert into rao_debug values(l_sql);
1582: --commit;
1583: DBMS_SQL.PARSE(l_handle,l_sql,DBMS_SQL.NATIVE);
1584: IF (p_salesrep_id <> FND_API.G_MISS_NUM) THEN
1585: DBMS_SQL.BIND_VARIABLE(l_handle,'p_salesrep_id',p_salesrep_id);
1586: END IF;
1587: IF (p_pr_date_from <> FND_API.G_MISS_DATE) THEN
1588: DBMS_SQL.BIND_VARIABLE(l_handle,'p_pr_date_from',p_pr_date_from);
1583: DBMS_SQL.PARSE(l_handle,l_sql,DBMS_SQL.NATIVE);
1584: IF (p_salesrep_id <> FND_API.G_MISS_NUM) THEN
1585: DBMS_SQL.BIND_VARIABLE(l_handle,'p_salesrep_id',p_salesrep_id);
1586: END IF;
1587: IF (p_pr_date_from <> FND_API.G_MISS_DATE) THEN
1588: DBMS_SQL.BIND_VARIABLE(l_handle,'p_pr_date_from',p_pr_date_from);
1589: END IF;
1590: IF (p_pr_date_to <> FND_API.G_MISS_DATE) THEN
1591: DBMS_SQL.BIND_VARIABLE(l_handle,'p_pr_date_to',p_pr_date_to);
1586: END IF;
1587: IF (p_pr_date_from <> FND_API.G_MISS_DATE) THEN
1588: DBMS_SQL.BIND_VARIABLE(l_handle,'p_pr_date_from',p_pr_date_from);
1589: END IF;
1590: IF (p_pr_date_to <> FND_API.G_MISS_DATE) THEN
1591: DBMS_SQL.BIND_VARIABLE(l_handle,'p_pr_date_to',p_pr_date_to);
1592: END IF;
1593: IF (p_invoice_num <> FND_API.G_MISS_CHAR) THEN
1594: DBMS_SQL.BIND_VARIABLE(l_handle,'p_invoice_num',p_invoice_num);
1589: END IF;
1590: IF (p_pr_date_to <> FND_API.G_MISS_DATE) THEN
1591: DBMS_SQL.BIND_VARIABLE(l_handle,'p_pr_date_to',p_pr_date_to);
1592: END IF;
1593: IF (p_invoice_num <> FND_API.G_MISS_CHAR) THEN
1594: DBMS_SQL.BIND_VARIABLE(l_handle,'p_invoice_num',p_invoice_num);
1595: END IF;
1596: IF (p_order_num <> FND_API.G_MISS_NUM AND p_order_num <> 0) THEN
1597: DBMS_SQL.BIND_VARIABLE(l_handle,'p_order_num',p_order_num);
1592: END IF;
1593: IF (p_invoice_num <> FND_API.G_MISS_CHAR) THEN
1594: DBMS_SQL.BIND_VARIABLE(l_handle,'p_invoice_num',p_invoice_num);
1595: END IF;
1596: IF (p_order_num <> FND_API.G_MISS_NUM AND p_order_num <> 0) THEN
1597: DBMS_SQL.BIND_VARIABLE(l_handle,'p_order_num',p_order_num);
1598: END IF;
1599: IF (p_calc_status <> 'ALL') THEN
1600: DBMS_SQL.BIND_VARIABLE(l_handle,'p_calc_status',p_calc_status);
1600: DBMS_SQL.BIND_VARIABLE(l_handle,'p_calc_status',p_calc_status);
1601: END IF;
1602:
1603: -- Added for Crediting
1604: IF (l_keep_flag <> FND_API.G_MISS_CHAR AND l_keep_flag <> NULL) THEN
1605: DBMS_SQL.BIND_VARIABLE(l_handle,'l_keep_flag',l_keep_flag);
1606: END IF;
1607:
1608:
1658: x_msg_count => x_msg_count,
1659: x_msg_data => x_msg_data,
1660: x_loading_status => x_loading_status);
1661: END IF;
1662: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1663: FND_MESSAGE.Set_Name('CN', 'CN_UPD_INV_CHANGES');
1664: FND_MSG_PUB.Add;
1665: x_loading_status := 'CN_UPD_INV_CHANGES';
1666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1662: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1663: FND_MESSAGE.Set_Name('CN', 'CN_UPD_INV_CHANGES');
1664: FND_MSG_PUB.Add;
1665: x_loading_status := 'CN_UPD_INV_CHANGES';
1666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1667: END IF;
1668: x_existing_data := l_existing_data;
1669: EXCEPTION
1670: WHEN FND_API.G_EXC_ERROR THEN
1666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1667: END IF;
1668: x_existing_data := l_existing_data;
1669: EXCEPTION
1670: WHEN FND_API.G_EXC_ERROR THEN
1671: ROLLBACK TO update_mass_invoices;
1672: x_return_status := FND_API.G_RET_STS_ERROR ;
1673: FND_MSG_PUB.Count_And_Get(
1674: p_count => x_msg_count ,
1668: x_existing_data := l_existing_data;
1669: EXCEPTION
1670: WHEN FND_API.G_EXC_ERROR THEN
1671: ROLLBACK TO update_mass_invoices;
1672: x_return_status := FND_API.G_RET_STS_ERROR ;
1673: FND_MSG_PUB.Count_And_Get(
1674: p_count => x_msg_count ,
1675: p_data => x_msg_data ,
1676: p_encoded => FND_API.G_FALSE);
1672: x_return_status := FND_API.G_RET_STS_ERROR ;
1673: FND_MSG_PUB.Count_And_Get(
1674: p_count => x_msg_count ,
1675: p_data => x_msg_data ,
1676: p_encoded => FND_API.G_FALSE);
1677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1678: ROLLBACK TO update_mass_invoices;
1679: x_loading_status := 'UNEXPECTED_ERR';
1680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1673: FND_MSG_PUB.Count_And_Get(
1674: p_count => x_msg_count ,
1675: p_data => x_msg_data ,
1676: p_encoded => FND_API.G_FALSE);
1677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1678: ROLLBACK TO update_mass_invoices;
1679: x_loading_status := 'UNEXPECTED_ERR';
1680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1681: FND_MSG_PUB.Count_And_Get(
1676: p_encoded => FND_API.G_FALSE);
1677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1678: ROLLBACK TO update_mass_invoices;
1679: x_loading_status := 'UNEXPECTED_ERR';
1680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1681: FND_MSG_PUB.Count_And_Get(
1682: p_count => x_msg_count ,
1683: p_data => x_msg_data ,
1684: p_encoded => FND_API.G_FALSE);
1680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1681: FND_MSG_PUB.Count_And_Get(
1682: p_count => x_msg_count ,
1683: p_data => x_msg_data ,
1684: p_encoded => FND_API.G_FALSE);
1685: WHEN OTHERS THEN
1686: ROLLBACK TO update_mass_invoices;
1687: x_loading_status := 'UNEXPECTED_ERR';
1688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1684: p_encoded => FND_API.G_FALSE);
1685: WHEN OTHERS THEN
1686: ROLLBACK TO update_mass_invoices;
1687: x_loading_status := 'UNEXPECTED_ERR';
1688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1689: IF FND_MSG_PUB.Check_Msg_Level(
1690: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1691: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1692: END IF;
1692: END IF;
1693: FND_MSG_PUB.Count_And_Get(
1694: p_count => x_msg_count ,
1695: p_data => x_msg_data ,
1696: p_encoded => FND_API.G_FALSE);
1697: END;
1698: --
1699: PROCEDURE capture_deal_invoice(
1700: p_api_version IN NUMBER,
1697: END;
1698: --
1699: PROCEDURE capture_deal_invoice(
1700: p_api_version IN NUMBER,
1701: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
1702: p_validation_level IN VARCHAR2:= FND_API.G_VALID_LEVEL_FULL,
1703: p_trx_type IN VARCHAR2,
1704: p_split_nonrevenue_line IN VARCHAR2,
1705: p_invoice_number IN VARCHAR2,
1698: --
1699: PROCEDURE capture_deal_invoice(
1700: p_api_version IN NUMBER,
1701: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
1702: p_validation_level IN VARCHAR2:= FND_API.G_VALID_LEVEL_FULL,
1703: p_trx_type IN VARCHAR2,
1704: p_split_nonrevenue_line IN VARCHAR2,
1705: p_invoice_number IN VARCHAR2,
1706: p_org_id IN NUMBER,
1751: BEGIN
1752: -- Standard Start of API savepoint
1753: SAVEPOINT capture_deal_invoice;
1754: -- Standard call to check for call compatibility.
1755: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1756: p_api_version ,
1757: l_api_name,
1758: G_PKG_NAME ) THEN
1759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1755: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1756: p_api_version ,
1757: l_api_name,
1758: G_PKG_NAME ) THEN
1759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1760: END IF;
1761: -- Initialize message list if p_init_msg_list is set to TRUE.
1762: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1763: FND_MSG_PUB.initialize;
1758: G_PKG_NAME ) THEN
1759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1760: END IF;
1761: -- Initialize message list if p_init_msg_list is set to TRUE.
1762: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1763: FND_MSG_PUB.initialize;
1764: END IF;
1765: -- Initialize API return status to success
1766: x_return_status := FND_API.G_RET_STS_SUCCESS;
1762: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1763: FND_MSG_PUB.initialize;
1764: END IF;
1765: -- Initialize API return status to success
1766: x_return_status := FND_API.G_RET_STS_SUCCESS;
1767: x_loading_status := 'CN_INSERTED';
1768: -- API body
1769: IF ((g_track_invoice = 'Y') AND (p_trx_type = 'INV'))THEN
1770: FOR c2_rec IN c2
1790: END IF;
1791:
1792: END LOOP;
1793: EXCEPTION
1794: WHEN FND_API.G_EXC_ERROR THEN
1795: ROLLBACK TO capture_deal_invoice;
1796: x_return_status := FND_API.G_RET_STS_ERROR ;
1797: FND_MSG_PUB.Count_And_Get(
1798: p_count => x_msg_count ,
1792: END LOOP;
1793: EXCEPTION
1794: WHEN FND_API.G_EXC_ERROR THEN
1795: ROLLBACK TO capture_deal_invoice;
1796: x_return_status := FND_API.G_RET_STS_ERROR ;
1797: FND_MSG_PUB.Count_And_Get(
1798: p_count => x_msg_count ,
1799: p_data => x_msg_data ,
1800: p_encoded => FND_API.G_FALSE);
1796: x_return_status := FND_API.G_RET_STS_ERROR ;
1797: FND_MSG_PUB.Count_And_Get(
1798: p_count => x_msg_count ,
1799: p_data => x_msg_data ,
1800: p_encoded => FND_API.G_FALSE);
1801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1802: ROLLBACK TO capture_deal_invoice;
1803: x_loading_status := 'UNEXPECTED_ERR';
1804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1797: FND_MSG_PUB.Count_And_Get(
1798: p_count => x_msg_count ,
1799: p_data => x_msg_data ,
1800: p_encoded => FND_API.G_FALSE);
1801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1802: ROLLBACK TO capture_deal_invoice;
1803: x_loading_status := 'UNEXPECTED_ERR';
1804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1805: FND_MSG_PUB.Count_And_Get(
1800: p_encoded => FND_API.G_FALSE);
1801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1802: ROLLBACK TO capture_deal_invoice;
1803: x_loading_status := 'UNEXPECTED_ERR';
1804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1805: FND_MSG_PUB.Count_And_Get(
1806: p_count => x_msg_count ,
1807: p_data => x_msg_data ,
1808: p_encoded => FND_API.G_FALSE);
1804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1805: FND_MSG_PUB.Count_And_Get(
1806: p_count => x_msg_count ,
1807: p_data => x_msg_data ,
1808: p_encoded => FND_API.G_FALSE);
1809: WHEN OTHERS THEN
1810: ROLLBACK TO capture_deal_invoice;
1811: x_loading_status := 'UNEXPECTED_ERR';
1812: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1808: p_encoded => FND_API.G_FALSE);
1809: WHEN OTHERS THEN
1810: ROLLBACK TO capture_deal_invoice;
1811: x_loading_status := 'UNEXPECTED_ERR';
1812: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1813: IF FND_MSG_PUB.Check_Msg_Level(
1814: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1815: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1816: END IF;
1816: END IF;
1817: FND_MSG_PUB.Count_And_Get(
1818: p_count => x_msg_count ,
1819: p_data => x_msg_data ,
1820: p_encoded => FND_API.G_FALSE);
1821: END;
1822: --
1823: /*-----------------------------------------------------------------------------
1824: Batch Program Logic: