304: UPDATE fa_deprn_summary_mrc_v
305: SET
306: book_type_code = decode(X_Book_Type_Code,
307: NULL, book_type_code,
308: FND_API.G_MISS_CHAR, null,
309: X_Book_Type_Code),
310: asset_id = decode(X_Asset_Id,
311: NULL, asset_id,
312: FND_API.G_MISS_NUM, null,
308: FND_API.G_MISS_CHAR, null,
309: X_Book_Type_Code),
310: asset_id = decode(X_Asset_Id,
311: NULL, asset_id,
312: FND_API.G_MISS_NUM, null,
313: X_Asset_Id),
314: deprn_run_date = decode(X_Deprn_Run_Date,
315: NULL, deprn_run_date,
316: X_Deprn_Run_Date),
315: NULL, deprn_run_date,
316: X_Deprn_Run_Date),
317: deprn_amount = decode(X_Deprn_Amount,
318: NULL, deprn_amount,
319: FND_API.G_MISS_NUM, null,
320: X_Deprn_Amount),
321: ytd_deprn = decode(X_Ytd_Deprn,
322: NULL, ytd_deprn,
323: FND_API.G_MISS_NUM, null,
319: FND_API.G_MISS_NUM, null,
320: X_Deprn_Amount),
321: ytd_deprn = decode(X_Ytd_Deprn,
322: NULL, ytd_deprn,
323: FND_API.G_MISS_NUM, null,
324: X_Ytd_Deprn),
325: deprn_reserve = decode(X_Deprn_Reserve,
326: NULL, deprn_reserve,
327: FND_API.G_MISS_NUM, null,
323: FND_API.G_MISS_NUM, null,
324: X_Ytd_Deprn),
325: deprn_reserve = decode(X_Deprn_Reserve,
326: NULL, deprn_reserve,
327: FND_API.G_MISS_NUM, null,
328: X_Deprn_Reserve),
329: deprn_source_code = decode(X_Deprn_Source_Code,
330: NULL, deprn_source_code,
331: FND_API.G_MISS_CHAR, null,
327: FND_API.G_MISS_NUM, null,
328: X_Deprn_Reserve),
329: deprn_source_code = decode(X_Deprn_Source_Code,
330: NULL, deprn_source_code,
331: FND_API.G_MISS_CHAR, null,
332: X_Deprn_Source_Code),
333: adjusted_cost = decode(X_Adjusted_Cost,
334: NULL, adjusted_cost,
335: FND_API.G_MISS_NUM, null,
331: FND_API.G_MISS_CHAR, null,
332: X_Deprn_Source_Code),
333: adjusted_cost = decode(X_Adjusted_Cost,
334: NULL, adjusted_cost,
335: FND_API.G_MISS_NUM, null,
336: X_Adjusted_Cost),
337: bonus_rate = decode(X_Bonus_Rate,
338: NULL, bonus_rate,
339: FND_API.G_MISS_NUM, null,
335: FND_API.G_MISS_NUM, null,
336: X_Adjusted_Cost),
337: bonus_rate = decode(X_Bonus_Rate,
338: NULL, bonus_rate,
339: FND_API.G_MISS_NUM, null,
340: X_Bonus_Rate),
341: ltd_production = decode(X_Ltd_Production,
342: NULL, ltd_production,
343: FND_API.G_MISS_NUM, null,
339: FND_API.G_MISS_NUM, null,
340: X_Bonus_Rate),
341: ltd_production = decode(X_Ltd_Production,
342: NULL, ltd_production,
343: FND_API.G_MISS_NUM, null,
344: X_Ltd_Production),
345: period_counter = decode(X_Period_Counter,
346: NULL, period_counter,
347: FND_API.G_MISS_NUM, null,
343: FND_API.G_MISS_NUM, null,
344: X_Ltd_Production),
345: period_counter = decode(X_Period_Counter,
346: NULL, period_counter,
347: FND_API.G_MISS_NUM, null,
348: X_Period_Counter),
349: production = decode(X_Production,
350: NULL, production,
351: FND_API.G_MISS_NUM, null,
347: FND_API.G_MISS_NUM, null,
348: X_Period_Counter),
349: production = decode(X_Production,
350: NULL, production,
351: FND_API.G_MISS_NUM, null,
352: X_Production),
353: reval_amortization = decode(X_Reval_Amortization,
354: NULL, reval_amortization,
355: FND_API.G_MISS_NUM, null,
351: FND_API.G_MISS_NUM, null,
352: X_Production),
353: reval_amortization = decode(X_Reval_Amortization,
354: NULL, reval_amortization,
355: FND_API.G_MISS_NUM, null,
356: X_Reval_Amortization),
357: reval_amortization_basis = decode(X_Reval_Amortization_Basis,
358: NULL, reval_amortization_basis,
359: FND_API.G_MISS_NUM, null,
355: FND_API.G_MISS_NUM, null,
356: X_Reval_Amortization),
357: reval_amortization_basis = decode(X_Reval_Amortization_Basis,
358: NULL, reval_amortization_basis,
359: FND_API.G_MISS_NUM, null,
360: X_Reval_Amortization_Basis),
361: reval_deprn_expense = decode(X_Reval_Deprn_Expense,
362: NULL, reval_deprn_expense,
363: FND_API.G_MISS_NUM, null,
359: FND_API.G_MISS_NUM, null,
360: X_Reval_Amortization_Basis),
361: reval_deprn_expense = decode(X_Reval_Deprn_Expense,
362: NULL, reval_deprn_expense,
363: FND_API.G_MISS_NUM, null,
364: X_Reval_Deprn_Expense),
365: reval_reserve = decode(X_Reval_Reserve,
366: NULL, reval_reserve,
367: FND_API.G_MISS_NUM, null,
363: FND_API.G_MISS_NUM, null,
364: X_Reval_Deprn_Expense),
365: reval_reserve = decode(X_Reval_Reserve,
366: NULL, reval_reserve,
367: FND_API.G_MISS_NUM, null,
368: X_Reval_Reserve),
369: ytd_production = decode(X_Ytd_Production,
370: NULL, ytd_production,
371: FND_API.G_MISS_NUM, null,
367: FND_API.G_MISS_NUM, null,
368: X_Reval_Reserve),
369: ytd_production = decode(X_Ytd_Production,
370: NULL, ytd_production,
371: FND_API.G_MISS_NUM, null,
372: X_Ytd_Production),
373: ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
374: NULL, ytd_reval_deprn_expense,
375: FND_API.G_MISS_NUM, null,
371: FND_API.G_MISS_NUM, null,
372: X_Ytd_Production),
373: ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
374: NULL, ytd_reval_deprn_expense,
375: FND_API.G_MISS_NUM, null,
376: X_Ytd_Reval_Deprn_Expense),
377: bonus_deprn_amount = decode(X_Bonus_Deprn_Amount,
378: NULL, bonus_deprn_amount,
379: FND_API.G_MISS_NUM, null,
375: FND_API.G_MISS_NUM, null,
376: X_Ytd_Reval_Deprn_Expense),
377: bonus_deprn_amount = decode(X_Bonus_Deprn_Amount,
378: NULL, bonus_deprn_amount,
379: FND_API.G_MISS_NUM, null,
380: X_Bonus_Deprn_Amount),
381: bonus_ytd_deprn = decode(X_Bonus_Ytd_Deprn,
382: NULL, bonus_ytd_deprn,
383: FND_API.G_MISS_NUM, null,
379: FND_API.G_MISS_NUM, null,
380: X_Bonus_Deprn_Amount),
381: bonus_ytd_deprn = decode(X_Bonus_Ytd_Deprn,
382: NULL, bonus_ytd_deprn,
383: FND_API.G_MISS_NUM, null,
384: X_Bonus_Ytd_Deprn),
385: bonus_deprn_reserve = decode(X_Bonus_Deprn_Reserve,
386: NULL, bonus_deprn_reserve,
387: FND_API.G_MISS_NUM, null,
383: FND_API.G_MISS_NUM, null,
384: X_Bonus_Ytd_Deprn),
385: bonus_deprn_reserve = decode(X_Bonus_Deprn_Reserve,
386: NULL, bonus_deprn_reserve,
387: FND_API.G_MISS_NUM, null,
388: X_Bonus_Deprn_Reserve)
389: WHERE rowid = X_Rowid;
390:
391: else
393: UPDATE fa_deprn_summary
394: SET
395: book_type_code = decode(X_Book_Type_Code,
396: NULL, book_type_code,
397: FND_API.G_MISS_CHAR, null,
398: X_Book_Type_Code),
399: asset_id = decode(X_Asset_Id,
400: NULL, asset_id,
401: FND_API.G_MISS_NUM, null,
397: FND_API.G_MISS_CHAR, null,
398: X_Book_Type_Code),
399: asset_id = decode(X_Asset_Id,
400: NULL, asset_id,
401: FND_API.G_MISS_NUM, null,
402: X_Asset_Id),
403: deprn_run_date = decode(X_Deprn_Run_Date,
404: NULL, deprn_run_date,
405: X_Deprn_Run_Date),
404: NULL, deprn_run_date,
405: X_Deprn_Run_Date),
406: deprn_amount = decode(X_Deprn_Amount,
407: NULL, deprn_amount,
408: FND_API.G_MISS_NUM, null,
409: X_Deprn_Amount),
410: ytd_deprn = decode(X_Ytd_Deprn,
411: NULL, ytd_deprn,
412: FND_API.G_MISS_NUM, null,
408: FND_API.G_MISS_NUM, null,
409: X_Deprn_Amount),
410: ytd_deprn = decode(X_Ytd_Deprn,
411: NULL, ytd_deprn,
412: FND_API.G_MISS_NUM, null,
413: X_Ytd_Deprn),
414: deprn_reserve = decode(X_Deprn_Reserve,
415: NULL, deprn_reserve,
416: FND_API.G_MISS_NUM, null,
412: FND_API.G_MISS_NUM, null,
413: X_Ytd_Deprn),
414: deprn_reserve = decode(X_Deprn_Reserve,
415: NULL, deprn_reserve,
416: FND_API.G_MISS_NUM, null,
417: X_Deprn_Reserve),
418: deprn_source_code = decode(X_Deprn_Source_Code,
419: NULL, deprn_source_code,
420: FND_API.G_MISS_CHAR, null,
416: FND_API.G_MISS_NUM, null,
417: X_Deprn_Reserve),
418: deprn_source_code = decode(X_Deprn_Source_Code,
419: NULL, deprn_source_code,
420: FND_API.G_MISS_CHAR, null,
421: X_Deprn_Source_Code),
422: adjusted_cost = decode(X_Adjusted_Cost,
423: NULL, adjusted_cost,
424: FND_API.G_MISS_NUM, null,
420: FND_API.G_MISS_CHAR, null,
421: X_Deprn_Source_Code),
422: adjusted_cost = decode(X_Adjusted_Cost,
423: NULL, adjusted_cost,
424: FND_API.G_MISS_NUM, null,
425: X_Adjusted_Cost),
426: bonus_rate = decode(X_Bonus_Rate,
427: NULL, bonus_rate,
428: FND_API.G_MISS_NUM, null,
424: FND_API.G_MISS_NUM, null,
425: X_Adjusted_Cost),
426: bonus_rate = decode(X_Bonus_Rate,
427: NULL, bonus_rate,
428: FND_API.G_MISS_NUM, null,
429: X_Bonus_Rate),
430: ltd_production = decode(X_Ltd_Production,
431: NULL, ltd_production,
432: FND_API.G_MISS_NUM, null,
428: FND_API.G_MISS_NUM, null,
429: X_Bonus_Rate),
430: ltd_production = decode(X_Ltd_Production,
431: NULL, ltd_production,
432: FND_API.G_MISS_NUM, null,
433: X_Ltd_Production),
434: period_counter = decode(X_Period_Counter,
435: NULL, period_counter,
436: FND_API.G_MISS_NUM, null,
432: FND_API.G_MISS_NUM, null,
433: X_Ltd_Production),
434: period_counter = decode(X_Period_Counter,
435: NULL, period_counter,
436: FND_API.G_MISS_NUM, null,
437: X_Period_Counter),
438: production = decode(X_Production,
439: NULL, production,
440: FND_API.G_MISS_NUM, null,
436: FND_API.G_MISS_NUM, null,
437: X_Period_Counter),
438: production = decode(X_Production,
439: NULL, production,
440: FND_API.G_MISS_NUM, null,
441: X_Production),
442: reval_amortization = decode(X_Reval_Amortization,
443: NULL, reval_amortization,
444: FND_API.G_MISS_NUM, null,
440: FND_API.G_MISS_NUM, null,
441: X_Production),
442: reval_amortization = decode(X_Reval_Amortization,
443: NULL, reval_amortization,
444: FND_API.G_MISS_NUM, null,
445: X_Reval_Amortization),
446: reval_amortization_basis = decode(X_Reval_Amortization_Basis,
447: NULL, reval_amortization_basis,
448: FND_API.G_MISS_NUM, null,
444: FND_API.G_MISS_NUM, null,
445: X_Reval_Amortization),
446: reval_amortization_basis = decode(X_Reval_Amortization_Basis,
447: NULL, reval_amortization_basis,
448: FND_API.G_MISS_NUM, null,
449: X_Reval_Amortization_Basis),
450: reval_deprn_expense = decode(X_Reval_Deprn_Expense,
451: NULL, reval_deprn_expense,
452: FND_API.G_MISS_NUM, null,
448: FND_API.G_MISS_NUM, null,
449: X_Reval_Amortization_Basis),
450: reval_deprn_expense = decode(X_Reval_Deprn_Expense,
451: NULL, reval_deprn_expense,
452: FND_API.G_MISS_NUM, null,
453: X_Reval_Deprn_Expense),
454: reval_reserve = decode(X_Reval_Reserve,
455: NULL, reval_reserve,
456: FND_API.G_MISS_NUM, null,
452: FND_API.G_MISS_NUM, null,
453: X_Reval_Deprn_Expense),
454: reval_reserve = decode(X_Reval_Reserve,
455: NULL, reval_reserve,
456: FND_API.G_MISS_NUM, null,
457: X_Reval_Reserve),
458: ytd_production = decode(X_Ytd_Production,
459: NULL, ytd_production,
460: FND_API.G_MISS_NUM, null,
456: FND_API.G_MISS_NUM, null,
457: X_Reval_Reserve),
458: ytd_production = decode(X_Ytd_Production,
459: NULL, ytd_production,
460: FND_API.G_MISS_NUM, null,
461: X_Ytd_Production),
462: ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
463: NULL, ytd_reval_deprn_expense,
464: FND_API.G_MISS_NUM, null,
460: FND_API.G_MISS_NUM, null,
461: X_Ytd_Production),
462: ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
463: NULL, ytd_reval_deprn_expense,
464: FND_API.G_MISS_NUM, null,
465: X_Ytd_Reval_Deprn_Expense),
466: bonus_deprn_amount = decode(X_Bonus_Deprn_Amount,
467: NULL, bonus_deprn_amount,
468: FND_API.G_MISS_NUM, null,
464: FND_API.G_MISS_NUM, null,
465: X_Ytd_Reval_Deprn_Expense),
466: bonus_deprn_amount = decode(X_Bonus_Deprn_Amount,
467: NULL, bonus_deprn_amount,
468: FND_API.G_MISS_NUM, null,
469: X_Bonus_Deprn_Amount),
470: bonus_ytd_deprn = decode(X_Bonus_Ytd_Deprn,
471: NULL, bonus_ytd_deprn,
472: FND_API.G_MISS_NUM, null,
468: FND_API.G_MISS_NUM, null,
469: X_Bonus_Deprn_Amount),
470: bonus_ytd_deprn = decode(X_Bonus_Ytd_Deprn,
471: NULL, bonus_ytd_deprn,
472: FND_API.G_MISS_NUM, null,
473: X_Bonus_Ytd_Deprn),
474: bonus_deprn_reserve = decode(X_Bonus_Deprn_Reserve,
475: NULL, bonus_deprn_reserve,
476: FND_API.G_MISS_NUM, null,
472: FND_API.G_MISS_NUM, null,
473: X_Bonus_Ytd_Deprn),
474: bonus_deprn_reserve = decode(X_Bonus_Deprn_Reserve,
475: NULL, bonus_deprn_reserve,
476: FND_API.G_MISS_NUM, null,
477: X_Bonus_Deprn_Reserve)
478:
479: WHERE rowid = X_Rowid;
480:
486: UPDATE fa_deprn_summary_mrc_v
487: SET
488: book_type_code = decode(X_Book_Type_Code,
489: NULL, book_type_code,
490: FND_API.G_MISS_CHAR, null,
491: X_Book_Type_Code),
492: asset_id = decode(X_Asset_Id,
493: NULL, asset_id,
494: FND_API.G_MISS_NUM, null,
490: FND_API.G_MISS_CHAR, null,
491: X_Book_Type_Code),
492: asset_id = decode(X_Asset_Id,
493: NULL, asset_id,
494: FND_API.G_MISS_NUM, null,
495: X_Asset_Id),
496: deprn_run_date = decode(X_Deprn_Run_Date,
497: NULL, deprn_run_date,
498: X_Deprn_Run_Date),
497: NULL, deprn_run_date,
498: X_Deprn_Run_Date),
499: deprn_amount = decode(X_Deprn_Amount,
500: NULL, deprn_amount,
501: FND_API.G_MISS_NUM, null,
502: X_Deprn_Amount),
503: ytd_deprn = decode(X_Ytd_Deprn,
504: NULL, ytd_deprn,
505: FND_API.G_MISS_NUM, null,
501: FND_API.G_MISS_NUM, null,
502: X_Deprn_Amount),
503: ytd_deprn = decode(X_Ytd_Deprn,
504: NULL, ytd_deprn,
505: FND_API.G_MISS_NUM, null,
506: X_Ytd_Deprn),
507: deprn_reserve = decode(X_Deprn_Reserve,
508: NULL, deprn_reserve,
509: FND_API.G_MISS_NUM, null,
505: FND_API.G_MISS_NUM, null,
506: X_Ytd_Deprn),
507: deprn_reserve = decode(X_Deprn_Reserve,
508: NULL, deprn_reserve,
509: FND_API.G_MISS_NUM, null,
510: X_Deprn_Reserve),
511: deprn_source_code = decode(X_Deprn_Source_Code,
512: NULL, deprn_source_code,
513: FND_API.G_MISS_CHAR, null,
509: FND_API.G_MISS_NUM, null,
510: X_Deprn_Reserve),
511: deprn_source_code = decode(X_Deprn_Source_Code,
512: NULL, deprn_source_code,
513: FND_API.G_MISS_CHAR, null,
514: X_Deprn_Source_Code),
515: adjusted_cost = decode(X_Adjusted_Cost,
516: NULL, adjusted_cost,
517: FND_API.G_MISS_NUM, null,
513: FND_API.G_MISS_CHAR, null,
514: X_Deprn_Source_Code),
515: adjusted_cost = decode(X_Adjusted_Cost,
516: NULL, adjusted_cost,
517: FND_API.G_MISS_NUM, null,
518: X_Adjusted_Cost),
519: bonus_rate = decode(X_Bonus_Rate,
520: NULL, bonus_rate,
521: FND_API.G_MISS_NUM, null,
517: FND_API.G_MISS_NUM, null,
518: X_Adjusted_Cost),
519: bonus_rate = decode(X_Bonus_Rate,
520: NULL, bonus_rate,
521: FND_API.G_MISS_NUM, null,
522: X_Bonus_Rate),
523: ltd_production = decode(X_Ltd_Production,
524: NULL, ltd_production,
525: FND_API.G_MISS_NUM, null,
521: FND_API.G_MISS_NUM, null,
522: X_Bonus_Rate),
523: ltd_production = decode(X_Ltd_Production,
524: NULL, ltd_production,
525: FND_API.G_MISS_NUM, null,
526: X_Ltd_Production),
527: period_counter = decode(X_Period_Counter,
528: NULL, period_counter,
529: FND_API.G_MISS_NUM, null,
525: FND_API.G_MISS_NUM, null,
526: X_Ltd_Production),
527: period_counter = decode(X_Period_Counter,
528: NULL, period_counter,
529: FND_API.G_MISS_NUM, null,
530: X_Period_Counter),
531: production = decode(X_Production,
532: NULL, production,
533: FND_API.G_MISS_NUM, null,
529: FND_API.G_MISS_NUM, null,
530: X_Period_Counter),
531: production = decode(X_Production,
532: NULL, production,
533: FND_API.G_MISS_NUM, null,
534: X_Production),
535: reval_amortization = decode(X_Reval_Amortization,
536: NULL, reval_amortization,
537: FND_API.G_MISS_NUM, null,
533: FND_API.G_MISS_NUM, null,
534: X_Production),
535: reval_amortization = decode(X_Reval_Amortization,
536: NULL, reval_amortization,
537: FND_API.G_MISS_NUM, null,
538: X_Reval_Amortization),
539: reval_amortization_basis = decode(X_Reval_Amortization_Basis,
540: NULL, reval_amortization_basis,
541: FND_API.G_MISS_NUM, null,
537: FND_API.G_MISS_NUM, null,
538: X_Reval_Amortization),
539: reval_amortization_basis = decode(X_Reval_Amortization_Basis,
540: NULL, reval_amortization_basis,
541: FND_API.G_MISS_NUM, null,
542: X_Reval_Amortization_Basis),
543: reval_deprn_expense = decode(X_Reval_Deprn_Expense,
544: NULL, reval_deprn_expense,
545: FND_API.G_MISS_NUM, null,
541: FND_API.G_MISS_NUM, null,
542: X_Reval_Amortization_Basis),
543: reval_deprn_expense = decode(X_Reval_Deprn_Expense,
544: NULL, reval_deprn_expense,
545: FND_API.G_MISS_NUM, null,
546: X_Reval_Deprn_Expense),
547: reval_reserve = decode(X_Reval_Reserve,
548: NULL, reval_reserve,
549: FND_API.G_MISS_NUM, null,
545: FND_API.G_MISS_NUM, null,
546: X_Reval_Deprn_Expense),
547: reval_reserve = decode(X_Reval_Reserve,
548: NULL, reval_reserve,
549: FND_API.G_MISS_NUM, null,
550: X_Reval_Reserve),
551: ytd_production = decode(X_Ytd_Production,
552: NULL, ytd_production,
553: FND_API.G_MISS_NUM, null,
549: FND_API.G_MISS_NUM, null,
550: X_Reval_Reserve),
551: ytd_production = decode(X_Ytd_Production,
552: NULL, ytd_production,
553: FND_API.G_MISS_NUM, null,
554: X_Ytd_Production),
555: ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
556: NULL, ytd_reval_deprn_expense,
557: FND_API.G_MISS_NUM, null,
553: FND_API.G_MISS_NUM, null,
554: X_Ytd_Production),
555: ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
556: NULL, ytd_reval_deprn_expense,
557: FND_API.G_MISS_NUM, null,
558: X_Ytd_Reval_Deprn_Expense),
559: bonus_deprn_amount = decode(X_Bonus_Deprn_Amount,
560: NULL, bonus_deprn_amount,
561: FND_API.G_MISS_NUM, null,
557: FND_API.G_MISS_NUM, null,
558: X_Ytd_Reval_Deprn_Expense),
559: bonus_deprn_amount = decode(X_Bonus_Deprn_Amount,
560: NULL, bonus_deprn_amount,
561: FND_API.G_MISS_NUM, null,
562: X_Bonus_Deprn_Amount),
563: bonus_ytd_deprn = decode(X_Bonus_Ytd_Deprn,
564: NULL, bonus_ytd_deprn,
565: FND_API.G_MISS_NUM, null,
561: FND_API.G_MISS_NUM, null,
562: X_Bonus_Deprn_Amount),
563: bonus_ytd_deprn = decode(X_Bonus_Ytd_Deprn,
564: NULL, bonus_ytd_deprn,
565: FND_API.G_MISS_NUM, null,
566: X_Bonus_Ytd_Deprn),
567: bonus_deprn_reserve = decode(X_Bonus_Deprn_Reserve,
568: NULL, bonus_deprn_reserve,
569: FND_API.G_MISS_NUM, null,
565: FND_API.G_MISS_NUM, null,
566: X_Bonus_Ytd_Deprn),
567: bonus_deprn_reserve = decode(X_Bonus_Deprn_Reserve,
568: NULL, bonus_deprn_reserve,
569: FND_API.G_MISS_NUM, null,
570: X_Bonus_Deprn_Reserve)
571:
572: WHERE book_type_code = X_Book_Type_Code
573: and asset_id = X_Asset_Id
578: UPDATE fa_deprn_summary
579: SET
580: book_type_code = decode(X_Book_Type_Code,
581: NULL, book_type_code,
582: FND_API.G_MISS_CHAR, null,
583: X_Book_Type_Code),
584: asset_id = decode(X_Asset_Id,
585: NULL, asset_id,
586: FND_API.G_MISS_NUM, null,
582: FND_API.G_MISS_CHAR, null,
583: X_Book_Type_Code),
584: asset_id = decode(X_Asset_Id,
585: NULL, asset_id,
586: FND_API.G_MISS_NUM, null,
587: X_Asset_Id),
588: deprn_run_date = decode(X_Deprn_Run_Date,
589: NULL, deprn_run_date,
590: X_Deprn_Run_Date),
589: NULL, deprn_run_date,
590: X_Deprn_Run_Date),
591: deprn_amount = decode(X_Deprn_Amount,
592: NULL, deprn_amount,
593: FND_API.G_MISS_NUM, null,
594: X_Deprn_Amount),
595: ytd_deprn = decode(X_Ytd_Deprn,
596: NULL, ytd_deprn,
597: FND_API.G_MISS_NUM, null,
593: FND_API.G_MISS_NUM, null,
594: X_Deprn_Amount),
595: ytd_deprn = decode(X_Ytd_Deprn,
596: NULL, ytd_deprn,
597: FND_API.G_MISS_NUM, null,
598: X_Ytd_Deprn),
599: deprn_reserve = decode(X_Deprn_Reserve,
600: NULL, deprn_reserve,
601: FND_API.G_MISS_NUM, null,
597: FND_API.G_MISS_NUM, null,
598: X_Ytd_Deprn),
599: deprn_reserve = decode(X_Deprn_Reserve,
600: NULL, deprn_reserve,
601: FND_API.G_MISS_NUM, null,
602: X_Deprn_Reserve),
603: deprn_source_code = decode(X_Deprn_Source_Code,
604: NULL, deprn_source_code,
605: FND_API.G_MISS_CHAR, null,
601: FND_API.G_MISS_NUM, null,
602: X_Deprn_Reserve),
603: deprn_source_code = decode(X_Deprn_Source_Code,
604: NULL, deprn_source_code,
605: FND_API.G_MISS_CHAR, null,
606: X_Deprn_Source_Code),
607: adjusted_cost = decode(X_Adjusted_Cost,
608: NULL, adjusted_cost,
609: FND_API.G_MISS_NUM, null,
605: FND_API.G_MISS_CHAR, null,
606: X_Deprn_Source_Code),
607: adjusted_cost = decode(X_Adjusted_Cost,
608: NULL, adjusted_cost,
609: FND_API.G_MISS_NUM, null,
610: X_Adjusted_Cost),
611: bonus_rate = decode(X_Bonus_Rate,
612: NULL, bonus_rate,
613: FND_API.G_MISS_NUM, null,
609: FND_API.G_MISS_NUM, null,
610: X_Adjusted_Cost),
611: bonus_rate = decode(X_Bonus_Rate,
612: NULL, bonus_rate,
613: FND_API.G_MISS_NUM, null,
614: X_Bonus_Rate),
615: ltd_production = decode(X_Ltd_Production,
616: NULL, ltd_production,
617: FND_API.G_MISS_NUM, null,
613: FND_API.G_MISS_NUM, null,
614: X_Bonus_Rate),
615: ltd_production = decode(X_Ltd_Production,
616: NULL, ltd_production,
617: FND_API.G_MISS_NUM, null,
618: X_Ltd_Production),
619: period_counter = decode(X_Period_Counter,
620: NULL, period_counter,
621: FND_API.G_MISS_NUM, null,
617: FND_API.G_MISS_NUM, null,
618: X_Ltd_Production),
619: period_counter = decode(X_Period_Counter,
620: NULL, period_counter,
621: FND_API.G_MISS_NUM, null,
622: X_Period_Counter),
623: production = decode(X_Production,
624: NULL, production,
625: FND_API.G_MISS_NUM, null,
621: FND_API.G_MISS_NUM, null,
622: X_Period_Counter),
623: production = decode(X_Production,
624: NULL, production,
625: FND_API.G_MISS_NUM, null,
626: X_Production),
627: reval_amortization = decode(X_Reval_Amortization,
628: NULL, reval_amortization,
629: FND_API.G_MISS_NUM, null,
625: FND_API.G_MISS_NUM, null,
626: X_Production),
627: reval_amortization = decode(X_Reval_Amortization,
628: NULL, reval_amortization,
629: FND_API.G_MISS_NUM, null,
630: X_Reval_Amortization),
631: reval_amortization_basis = decode(X_Reval_Amortization_Basis,
632: NULL, reval_amortization_basis,
633: FND_API.G_MISS_NUM, null,
629: FND_API.G_MISS_NUM, null,
630: X_Reval_Amortization),
631: reval_amortization_basis = decode(X_Reval_Amortization_Basis,
632: NULL, reval_amortization_basis,
633: FND_API.G_MISS_NUM, null,
634: X_Reval_Amortization_Basis),
635: reval_deprn_expense = decode(X_Reval_Deprn_Expense,
636: NULL, reval_deprn_expense,
637: FND_API.G_MISS_NUM, null,
633: FND_API.G_MISS_NUM, null,
634: X_Reval_Amortization_Basis),
635: reval_deprn_expense = decode(X_Reval_Deprn_Expense,
636: NULL, reval_deprn_expense,
637: FND_API.G_MISS_NUM, null,
638: X_Reval_Deprn_Expense),
639: reval_reserve = decode(X_Reval_Reserve,
640: NULL, reval_reserve,
641: FND_API.G_MISS_NUM, null,
637: FND_API.G_MISS_NUM, null,
638: X_Reval_Deprn_Expense),
639: reval_reserve = decode(X_Reval_Reserve,
640: NULL, reval_reserve,
641: FND_API.G_MISS_NUM, null,
642: X_Reval_Reserve),
643: ytd_production = decode(X_Ytd_Production,
644: NULL, ytd_production,
645: FND_API.G_MISS_NUM, null,
641: FND_API.G_MISS_NUM, null,
642: X_Reval_Reserve),
643: ytd_production = decode(X_Ytd_Production,
644: NULL, ytd_production,
645: FND_API.G_MISS_NUM, null,
646: X_Ytd_Production),
647: ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
648: NULL, ytd_reval_deprn_expense,
649: FND_API.G_MISS_NUM, null,
645: FND_API.G_MISS_NUM, null,
646: X_Ytd_Production),
647: ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
648: NULL, ytd_reval_deprn_expense,
649: FND_API.G_MISS_NUM, null,
650: X_Ytd_Reval_Deprn_Expense),
651: bonus_deprn_amount = decode(X_Bonus_Deprn_Amount,
652: NULL, bonus_deprn_amount,
653: FND_API.G_MISS_NUM, null,
649: FND_API.G_MISS_NUM, null,
650: X_Ytd_Reval_Deprn_Expense),
651: bonus_deprn_amount = decode(X_Bonus_Deprn_Amount,
652: NULL, bonus_deprn_amount,
653: FND_API.G_MISS_NUM, null,
654: X_Bonus_Deprn_Amount),
655: bonus_ytd_deprn = decode(X_Bonus_Ytd_Deprn,
656: NULL, bonus_ytd_deprn,
657: FND_API.G_MISS_NUM, null,
653: FND_API.G_MISS_NUM, null,
654: X_Bonus_Deprn_Amount),
655: bonus_ytd_deprn = decode(X_Bonus_Ytd_Deprn,
656: NULL, bonus_ytd_deprn,
657: FND_API.G_MISS_NUM, null,
658: X_Bonus_Ytd_Deprn),
659: bonus_deprn_reserve = decode(X_Bonus_Deprn_Reserve,
660: NULL, bonus_deprn_reserve,
661: FND_API.G_MISS_NUM, null,
657: FND_API.G_MISS_NUM, null,
658: X_Bonus_Ytd_Deprn),
659: bonus_deprn_reserve = decode(X_Bonus_Deprn_Reserve,
660: NULL, bonus_deprn_reserve,
661: FND_API.G_MISS_NUM, null,
662: X_Bonus_Deprn_Reserve)
663: WHERE book_type_code = X_Book_Type_Code
664: and asset_id = X_Asset_Id
665: and period_counter = X_Period_Counter;