334: UPDATE fa_mc_deprn_detail
335: SET
336: book_type_code = decode(X_Book_Type_Code,
337: NULL, book_type_code,
338: FND_API.G_MISS_CHAR, null,
339: X_Book_Type_Code),
340: asset_id = decode(X_Asset_Id,
341: NULL, asset_id,
342: FND_API.G_MISS_NUM, null,
338: FND_API.G_MISS_CHAR, null,
339: X_Book_Type_Code),
340: asset_id = decode(X_Asset_Id,
341: NULL, asset_id,
342: FND_API.G_MISS_NUM, null,
343: X_Asset_Id),
344: period_counter = decode(X_Period_Counter,
345: NULL, period_counter,
346: FND_API.G_MISS_NUM, null,
342: FND_API.G_MISS_NUM, null,
343: X_Asset_Id),
344: period_counter = decode(X_Period_Counter,
345: NULL, period_counter,
346: FND_API.G_MISS_NUM, null,
347: X_Period_Counter),
348: distribution_id = decode(X_Distribution_Id,
349: NULL, distribution_id,
350: FND_API.G_MISS_NUM, null,
346: FND_API.G_MISS_NUM, null,
347: X_Period_Counter),
348: distribution_id = decode(X_Distribution_Id,
349: NULL, distribution_id,
350: FND_API.G_MISS_NUM, null,
351: X_Distribution_Id),
352: deprn_source_code = decode(X_Deprn_Source_Code,
353: NULL, deprn_source_code,
354: FND_API.G_MISS_CHAR, null,
350: FND_API.G_MISS_NUM, null,
351: X_Distribution_Id),
352: deprn_source_code = decode(X_Deprn_Source_Code,
353: NULL, deprn_source_code,
354: FND_API.G_MISS_CHAR, null,
355: X_Deprn_Source_Code),
356: deprn_run_date = decode(X_Deprn_Run_Date,
357: NULL, deprn_run_date,
358: X_Deprn_Run_Date),
357: NULL, deprn_run_date,
358: X_Deprn_Run_Date),
359: deprn_amount = decode(X_Deprn_Amount,
360: NULL, deprn_amount,
361: FND_API.G_MISS_NUM, null,
362: X_Deprn_Amount),
363: ytd_deprn = decode(X_Ytd_Deprn,
364: NULL, ytd_deprn,
365: FND_API.G_MISS_NUM, null,
361: FND_API.G_MISS_NUM, null,
362: X_Deprn_Amount),
363: ytd_deprn = decode(X_Ytd_Deprn,
364: NULL, ytd_deprn,
365: FND_API.G_MISS_NUM, null,
366: X_Ytd_Deprn),
367: deprn_reserve = decode(X_Deprn_Reserve,
368: NULL, deprn_reserve,
369: FND_API.G_MISS_NUM, null,
365: FND_API.G_MISS_NUM, null,
366: X_Ytd_Deprn),
367: deprn_reserve = decode(X_Deprn_Reserve,
368: NULL, deprn_reserve,
369: FND_API.G_MISS_NUM, null,
370: X_Deprn_Reserve),
371: addition_cost_to_clear = decode(X_Addition_Cost_To_Clear,
372: NULL, addition_cost_to_clear,
373: FND_API.G_MISS_NUM, null,
369: FND_API.G_MISS_NUM, null,
370: X_Deprn_Reserve),
371: addition_cost_to_clear = decode(X_Addition_Cost_To_Clear,
372: NULL, addition_cost_to_clear,
373: FND_API.G_MISS_NUM, null,
374: X_Addition_Cost_To_Clear),
375: cost = decode(X_Cost,
376: NULL, cost,
377: FND_API.G_MISS_NUM, null,
373: FND_API.G_MISS_NUM, null,
374: X_Addition_Cost_To_Clear),
375: cost = decode(X_Cost,
376: NULL, cost,
377: FND_API.G_MISS_NUM, null,
378: X_Cost),
379: deprn_adjustment_amount = decode(X_Deprn_Adjustment_Amount,
380: NULL, deprn_adjustment_amount,
381: FND_API.G_MISS_NUM, null,
377: FND_API.G_MISS_NUM, null,
378: X_Cost),
379: deprn_adjustment_amount = decode(X_Deprn_Adjustment_Amount,
380: NULL, deprn_adjustment_amount,
381: FND_API.G_MISS_NUM, null,
382: X_Deprn_Adjustment_Amount),
383: deprn_expense_je_line_num = decode(X_Deprn_Expense_Je_Line_Num,
384: NULL, deprn_expense_je_line_num,
385: FND_API.G_MISS_NUM, null,
381: FND_API.G_MISS_NUM, null,
382: X_Deprn_Adjustment_Amount),
383: deprn_expense_je_line_num = decode(X_Deprn_Expense_Je_Line_Num,
384: NULL, deprn_expense_je_line_num,
385: FND_API.G_MISS_NUM, null,
386: X_Deprn_Expense_Je_Line_Num),
387: deprn_reserve_je_line_num = decode(X_Deprn_Reserve_Je_Line_Num,
388: NULL, deprn_reserve_je_line_num,
389: FND_API.G_MISS_NUM, null,
385: FND_API.G_MISS_NUM, null,
386: X_Deprn_Expense_Je_Line_Num),
387: deprn_reserve_je_line_num = decode(X_Deprn_Reserve_Je_Line_Num,
388: NULL, deprn_reserve_je_line_num,
389: FND_API.G_MISS_NUM, null,
390: X_Deprn_Reserve_Je_Line_Num),
391: reval_amort_je_line_num = decode(X_Reval_Amort_Je_Line_Num,
392: NULL, reval_amort_je_line_num,
393: FND_API.G_MISS_NUM, null,
389: FND_API.G_MISS_NUM, null,
390: X_Deprn_Reserve_Je_Line_Num),
391: reval_amort_je_line_num = decode(X_Reval_Amort_Je_Line_Num,
392: NULL, reval_amort_je_line_num,
393: FND_API.G_MISS_NUM, null,
394: X_Reval_Amort_Je_Line_Num),
395: reval_reserve_je_line_num = decode(X_Reval_Reserve_Je_Line_Num,
396: NULL, reval_reserve_je_line_num,
397: FND_API.G_MISS_NUM, null,
393: FND_API.G_MISS_NUM, null,
394: X_Reval_Amort_Je_Line_Num),
395: reval_reserve_je_line_num = decode(X_Reval_Reserve_Je_Line_Num,
396: NULL, reval_reserve_je_line_num,
397: FND_API.G_MISS_NUM, null,
398: X_Reval_Reserve_Je_Line_Num),
399: je_header_id = decode(X_Je_Header_Id,
400: NULL, je_header_id,
401: FND_API.G_MISS_NUM, null,
397: FND_API.G_MISS_NUM, null,
398: X_Reval_Reserve_Je_Line_Num),
399: je_header_id = decode(X_Je_Header_Id,
400: NULL, je_header_id,
401: FND_API.G_MISS_NUM, null,
402: X_Je_Header_Id),
403: reval_amortization = decode(X_Reval_Amortization,
404: NULL, reval_amortization,
405: FND_API.G_MISS_NUM, null,
401: FND_API.G_MISS_NUM, null,
402: X_Je_Header_Id),
403: reval_amortization = decode(X_Reval_Amortization,
404: NULL, reval_amortization,
405: FND_API.G_MISS_NUM, null,
406: X_Reval_Amortization),
407: reval_deprn_expense = decode(X_Reval_Deprn_Expense,
408: NULL, reval_deprn_expense,
409: FND_API.G_MISS_NUM, null,
405: FND_API.G_MISS_NUM, null,
406: X_Reval_Amortization),
407: reval_deprn_expense = decode(X_Reval_Deprn_Expense,
408: NULL, reval_deprn_expense,
409: FND_API.G_MISS_NUM, null,
410: X_Reval_Deprn_Expense),
411: reval_reserve = decode(X_Reval_Reserve,
412: NULL, reval_reserve,
413: FND_API.G_MISS_NUM, null,
409: FND_API.G_MISS_NUM, null,
410: X_Reval_Deprn_Expense),
411: reval_reserve = decode(X_Reval_Reserve,
412: NULL, reval_reserve,
413: FND_API.G_MISS_NUM, null,
414: X_Reval_Reserve),
415: ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
416: NULL, ytd_reval_deprn_expense,
417: FND_API.G_MISS_NUM, null,
413: FND_API.G_MISS_NUM, null,
414: X_Reval_Reserve),
415: ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
416: NULL, ytd_reval_deprn_expense,
417: FND_API.G_MISS_NUM, null,
418: X_Ytd_Reval_Deprn_Expense)
419: WHERE rowid = X_Rowid;
420:
421: else
422: UPDATE fa_deprn_detail
423: SET
424: book_type_code = decode(X_Book_Type_Code,
425: NULL, book_type_code,
426: FND_API.G_MISS_CHAR, null,
427: X_Book_Type_Code),
428: asset_id = decode(X_Asset_Id,
429: NULL, asset_id,
430: FND_API.G_MISS_NUM, null,
426: FND_API.G_MISS_CHAR, null,
427: X_Book_Type_Code),
428: asset_id = decode(X_Asset_Id,
429: NULL, asset_id,
430: FND_API.G_MISS_NUM, null,
431: X_Asset_Id),
432: period_counter = decode(X_Period_Counter,
433: NULL, period_counter,
434: FND_API.G_MISS_NUM, null,
430: FND_API.G_MISS_NUM, null,
431: X_Asset_Id),
432: period_counter = decode(X_Period_Counter,
433: NULL, period_counter,
434: FND_API.G_MISS_NUM, null,
435: X_Period_Counter),
436: distribution_id = decode(X_Distribution_Id,
437: NULL, distribution_id,
438: FND_API.G_MISS_NUM, null,
434: FND_API.G_MISS_NUM, null,
435: X_Period_Counter),
436: distribution_id = decode(X_Distribution_Id,
437: NULL, distribution_id,
438: FND_API.G_MISS_NUM, null,
439: X_Distribution_Id),
440: deprn_source_code = decode(X_Deprn_Source_Code,
441: NULL, deprn_source_code,
442: FND_API.G_MISS_CHAR, null,
438: FND_API.G_MISS_NUM, null,
439: X_Distribution_Id),
440: deprn_source_code = decode(X_Deprn_Source_Code,
441: NULL, deprn_source_code,
442: FND_API.G_MISS_CHAR, null,
443: X_Deprn_Source_Code),
444: deprn_run_date = decode(X_Deprn_Run_Date,
445: NULL, deprn_run_date,
446: X_Deprn_Run_Date),
445: NULL, deprn_run_date,
446: X_Deprn_Run_Date),
447: deprn_amount = decode(X_Deprn_Amount,
448: NULL, deprn_amount,
449: FND_API.G_MISS_NUM, null,
450: X_Deprn_Amount),
451: ytd_deprn = decode(X_Ytd_Deprn,
452: NULL, ytd_deprn,
453: FND_API.G_MISS_NUM, null,
449: FND_API.G_MISS_NUM, null,
450: X_Deprn_Amount),
451: ytd_deprn = decode(X_Ytd_Deprn,
452: NULL, ytd_deprn,
453: FND_API.G_MISS_NUM, null,
454: X_Ytd_Deprn),
455: deprn_reserve = decode(X_Deprn_Reserve,
456: NULL, deprn_reserve,
457: FND_API.G_MISS_NUM, null,
453: FND_API.G_MISS_NUM, null,
454: X_Ytd_Deprn),
455: deprn_reserve = decode(X_Deprn_Reserve,
456: NULL, deprn_reserve,
457: FND_API.G_MISS_NUM, null,
458: X_Deprn_Reserve),
459: addition_cost_to_clear = decode(X_Addition_Cost_To_Clear,
460: NULL, addition_cost_to_clear,
461: FND_API.G_MISS_NUM, null,
457: FND_API.G_MISS_NUM, null,
458: X_Deprn_Reserve),
459: addition_cost_to_clear = decode(X_Addition_Cost_To_Clear,
460: NULL, addition_cost_to_clear,
461: FND_API.G_MISS_NUM, null,
462: X_Addition_Cost_To_Clear),
463: cost = decode(X_Cost,
464: NULL, cost,
465: FND_API.G_MISS_NUM, null,
461: FND_API.G_MISS_NUM, null,
462: X_Addition_Cost_To_Clear),
463: cost = decode(X_Cost,
464: NULL, cost,
465: FND_API.G_MISS_NUM, null,
466: X_Cost),
467: deprn_adjustment_amount = decode(X_Deprn_Adjustment_Amount,
468: NULL, deprn_adjustment_amount,
469: FND_API.G_MISS_NUM, null,
465: FND_API.G_MISS_NUM, null,
466: X_Cost),
467: deprn_adjustment_amount = decode(X_Deprn_Adjustment_Amount,
468: NULL, deprn_adjustment_amount,
469: FND_API.G_MISS_NUM, null,
470: X_Deprn_Adjustment_Amount),
471: deprn_expense_je_line_num = decode(X_Deprn_Expense_Je_Line_Num,
472: NULL, deprn_expense_je_line_num,
473: FND_API.G_MISS_NUM, null,
469: FND_API.G_MISS_NUM, null,
470: X_Deprn_Adjustment_Amount),
471: deprn_expense_je_line_num = decode(X_Deprn_Expense_Je_Line_Num,
472: NULL, deprn_expense_je_line_num,
473: FND_API.G_MISS_NUM, null,
474: X_Deprn_Expense_Je_Line_Num),
475: deprn_reserve_je_line_num = decode(X_Deprn_Reserve_Je_Line_Num,
476: NULL, deprn_reserve_je_line_num,
477: FND_API.G_MISS_NUM, null,
473: FND_API.G_MISS_NUM, null,
474: X_Deprn_Expense_Je_Line_Num),
475: deprn_reserve_je_line_num = decode(X_Deprn_Reserve_Je_Line_Num,
476: NULL, deprn_reserve_je_line_num,
477: FND_API.G_MISS_NUM, null,
478: X_Deprn_Reserve_Je_Line_Num),
479: reval_amort_je_line_num = decode(X_Reval_Amort_Je_Line_Num,
480: NULL, reval_amort_je_line_num,
481: FND_API.G_MISS_NUM, null,
477: FND_API.G_MISS_NUM, null,
478: X_Deprn_Reserve_Je_Line_Num),
479: reval_amort_je_line_num = decode(X_Reval_Amort_Je_Line_Num,
480: NULL, reval_amort_je_line_num,
481: FND_API.G_MISS_NUM, null,
482: X_Reval_Amort_Je_Line_Num),
483: reval_reserve_je_line_num = decode(X_Reval_Reserve_Je_Line_Num,
484: NULL, reval_reserve_je_line_num,
485: FND_API.G_MISS_NUM, null,
481: FND_API.G_MISS_NUM, null,
482: X_Reval_Amort_Je_Line_Num),
483: reval_reserve_je_line_num = decode(X_Reval_Reserve_Je_Line_Num,
484: NULL, reval_reserve_je_line_num,
485: FND_API.G_MISS_NUM, null,
486: X_Reval_Reserve_Je_Line_Num),
487: je_header_id = decode(X_Je_Header_Id,
488: NULL, je_header_id,
489: FND_API.G_MISS_NUM, null,
485: FND_API.G_MISS_NUM, null,
486: X_Reval_Reserve_Je_Line_Num),
487: je_header_id = decode(X_Je_Header_Id,
488: NULL, je_header_id,
489: FND_API.G_MISS_NUM, null,
490: X_Je_Header_Id),
491: reval_amortization = decode(X_Reval_Amortization,
492: NULL, reval_amortization,
493: FND_API.G_MISS_NUM, null,
489: FND_API.G_MISS_NUM, null,
490: X_Je_Header_Id),
491: reval_amortization = decode(X_Reval_Amortization,
492: NULL, reval_amortization,
493: FND_API.G_MISS_NUM, null,
494: X_Reval_Amortization),
495: reval_deprn_expense = decode(X_Reval_Deprn_Expense,
496: NULL, reval_deprn_expense,
497: FND_API.G_MISS_NUM, null,
493: FND_API.G_MISS_NUM, null,
494: X_Reval_Amortization),
495: reval_deprn_expense = decode(X_Reval_Deprn_Expense,
496: NULL, reval_deprn_expense,
497: FND_API.G_MISS_NUM, null,
498: X_Reval_Deprn_Expense),
499: reval_reserve = decode(X_Reval_Reserve,
500: NULL, reval_reserve,
501: FND_API.G_MISS_NUM, null,
497: FND_API.G_MISS_NUM, null,
498: X_Reval_Deprn_Expense),
499: reval_reserve = decode(X_Reval_Reserve,
500: NULL, reval_reserve,
501: FND_API.G_MISS_NUM, null,
502: X_Reval_Reserve),
503: ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
504: NULL, ytd_reval_deprn_expense,
505: FND_API.G_MISS_NUM, null,
501: FND_API.G_MISS_NUM, null,
502: X_Reval_Reserve),
503: ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
504: NULL, ytd_reval_deprn_expense,
505: FND_API.G_MISS_NUM, null,
506: X_Ytd_Reval_Deprn_Expense)
507: WHERE rowid = X_Rowid;
508: end if;
509: else
511: UPDATE fa_mc_deprn_detail
512: SET
513: book_type_code = decode(X_Book_Type_Code,
514: NULL, book_type_code,
515: FND_API.G_MISS_CHAR, null,
516: X_Book_Type_Code),
517: asset_id = decode(X_Asset_Id,
518: NULL, asset_id,
519: FND_API.G_MISS_NUM, null,
515: FND_API.G_MISS_CHAR, null,
516: X_Book_Type_Code),
517: asset_id = decode(X_Asset_Id,
518: NULL, asset_id,
519: FND_API.G_MISS_NUM, null,
520: X_Asset_Id),
521: period_counter = decode(X_Period_Counter,
522: NULL, period_counter,
523: FND_API.G_MISS_NUM, null,
519: FND_API.G_MISS_NUM, null,
520: X_Asset_Id),
521: period_counter = decode(X_Period_Counter,
522: NULL, period_counter,
523: FND_API.G_MISS_NUM, null,
524: X_Period_Counter),
525: distribution_id = decode(X_Distribution_Id,
526: NULL, distribution_id,
527: FND_API.G_MISS_NUM, null,
523: FND_API.G_MISS_NUM, null,
524: X_Period_Counter),
525: distribution_id = decode(X_Distribution_Id,
526: NULL, distribution_id,
527: FND_API.G_MISS_NUM, null,
528: X_Distribution_Id),
529: deprn_source_code = decode(X_Deprn_Source_Code,
530: NULL, deprn_source_code,
531: FND_API.G_MISS_CHAR, null,
527: FND_API.G_MISS_NUM, null,
528: X_Distribution_Id),
529: deprn_source_code = decode(X_Deprn_Source_Code,
530: NULL, deprn_source_code,
531: FND_API.G_MISS_CHAR, null,
532: X_Deprn_Source_Code),
533: deprn_run_date = decode(X_Deprn_Run_Date,
534: NULL, deprn_run_date,
535: X_Deprn_Run_Date),
534: NULL, deprn_run_date,
535: X_Deprn_Run_Date),
536: deprn_amount = decode(X_Deprn_Amount,
537: NULL, deprn_amount,
538: FND_API.G_MISS_NUM, null,
539: X_Deprn_Amount),
540: ytd_deprn = decode(X_Ytd_Deprn,
541: NULL, ytd_deprn,
542: FND_API.G_MISS_NUM, null,
538: FND_API.G_MISS_NUM, null,
539: X_Deprn_Amount),
540: ytd_deprn = decode(X_Ytd_Deprn,
541: NULL, ytd_deprn,
542: FND_API.G_MISS_NUM, null,
543: X_Ytd_Deprn),
544: deprn_reserve = decode(X_Deprn_Reserve,
545: NULL, deprn_reserve,
546: FND_API.G_MISS_NUM, null,
542: FND_API.G_MISS_NUM, null,
543: X_Ytd_Deprn),
544: deprn_reserve = decode(X_Deprn_Reserve,
545: NULL, deprn_reserve,
546: FND_API.G_MISS_NUM, null,
547: X_Deprn_Reserve),
548: addition_cost_to_clear = decode(X_Addition_Cost_To_Clear,
549: NULL, addition_cost_to_clear,
550: FND_API.G_MISS_NUM, null,
546: FND_API.G_MISS_NUM, null,
547: X_Deprn_Reserve),
548: addition_cost_to_clear = decode(X_Addition_Cost_To_Clear,
549: NULL, addition_cost_to_clear,
550: FND_API.G_MISS_NUM, null,
551: X_Addition_Cost_To_Clear),
552: cost = decode(X_Cost,
553: NULL, cost,
554: FND_API.G_MISS_NUM, null,
550: FND_API.G_MISS_NUM, null,
551: X_Addition_Cost_To_Clear),
552: cost = decode(X_Cost,
553: NULL, cost,
554: FND_API.G_MISS_NUM, null,
555: X_Cost),
556: deprn_adjustment_amount = decode(X_Deprn_Adjustment_Amount,
557: NULL, deprn_adjustment_amount,
558: FND_API.G_MISS_NUM, null,
554: FND_API.G_MISS_NUM, null,
555: X_Cost),
556: deprn_adjustment_amount = decode(X_Deprn_Adjustment_Amount,
557: NULL, deprn_adjustment_amount,
558: FND_API.G_MISS_NUM, null,
559: X_Deprn_Adjustment_Amount),
560: deprn_expense_je_line_num = decode(X_Deprn_Expense_Je_Line_Num,
561: NULL, deprn_expense_je_line_num,
562: FND_API.G_MISS_NUM, null,
558: FND_API.G_MISS_NUM, null,
559: X_Deprn_Adjustment_Amount),
560: deprn_expense_je_line_num = decode(X_Deprn_Expense_Je_Line_Num,
561: NULL, deprn_expense_je_line_num,
562: FND_API.G_MISS_NUM, null,
563: X_Deprn_Expense_Je_Line_Num),
564: deprn_reserve_je_line_num = decode(X_Deprn_Reserve_Je_Line_Num,
565: NULL, deprn_reserve_je_line_num,
566: FND_API.G_MISS_NUM, null,
562: FND_API.G_MISS_NUM, null,
563: X_Deprn_Expense_Je_Line_Num),
564: deprn_reserve_je_line_num = decode(X_Deprn_Reserve_Je_Line_Num,
565: NULL, deprn_reserve_je_line_num,
566: FND_API.G_MISS_NUM, null,
567: X_Deprn_Reserve_Je_Line_Num),
568: reval_amort_je_line_num = decode(X_Reval_Amort_Je_Line_Num,
569: NULL, reval_amort_je_line_num,
570: FND_API.G_MISS_NUM, null,
566: FND_API.G_MISS_NUM, null,
567: X_Deprn_Reserve_Je_Line_Num),
568: reval_amort_je_line_num = decode(X_Reval_Amort_Je_Line_Num,
569: NULL, reval_amort_je_line_num,
570: FND_API.G_MISS_NUM, null,
571: X_Reval_Amort_Je_Line_Num),
572: reval_reserve_je_line_num = decode(X_Reval_Reserve_Je_Line_Num,
573: NULL, reval_reserve_je_line_num,
574: FND_API.G_MISS_NUM, null,
570: FND_API.G_MISS_NUM, null,
571: X_Reval_Amort_Je_Line_Num),
572: reval_reserve_je_line_num = decode(X_Reval_Reserve_Je_Line_Num,
573: NULL, reval_reserve_je_line_num,
574: FND_API.G_MISS_NUM, null,
575: X_Reval_Reserve_Je_Line_Num),
576: je_header_id = decode(X_Je_Header_Id,
577: NULL, je_header_id,
578: FND_API.G_MISS_NUM, null,
574: FND_API.G_MISS_NUM, null,
575: X_Reval_Reserve_Je_Line_Num),
576: je_header_id = decode(X_Je_Header_Id,
577: NULL, je_header_id,
578: FND_API.G_MISS_NUM, null,
579: X_Je_Header_Id),
580: reval_amortization = decode(X_Reval_Amortization,
581: NULL, reval_amortization,
582: FND_API.G_MISS_NUM, null,
578: FND_API.G_MISS_NUM, null,
579: X_Je_Header_Id),
580: reval_amortization = decode(X_Reval_Amortization,
581: NULL, reval_amortization,
582: FND_API.G_MISS_NUM, null,
583: X_Reval_Amortization),
584: reval_deprn_expense = decode(X_Reval_Deprn_Expense,
585: NULL, reval_deprn_expense,
586: FND_API.G_MISS_NUM, null,
582: FND_API.G_MISS_NUM, null,
583: X_Reval_Amortization),
584: reval_deprn_expense = decode(X_Reval_Deprn_Expense,
585: NULL, reval_deprn_expense,
586: FND_API.G_MISS_NUM, null,
587: X_Reval_Deprn_Expense),
588: reval_reserve = decode(X_Reval_Reserve,
589: NULL, reval_reserve,
590: FND_API.G_MISS_NUM, null,
586: FND_API.G_MISS_NUM, null,
587: X_Reval_Deprn_Expense),
588: reval_reserve = decode(X_Reval_Reserve,
589: NULL, reval_reserve,
590: FND_API.G_MISS_NUM, null,
591: X_Reval_Reserve),
592: ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
593: NULL, ytd_reval_deprn_expense,
594: FND_API.G_MISS_NUM, null,
590: FND_API.G_MISS_NUM, null,
591: X_Reval_Reserve),
592: ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
593: NULL, ytd_reval_deprn_expense,
594: FND_API.G_MISS_NUM, null,
595: X_Ytd_Reval_Deprn_Expense)
596: WHERE book_type_code = X_Book_Type_Code
597: and asset_id = X_Asset_Id
598: and period_counter = X_Period_Counter
605: UPDATE fa_deprn_detail
606: SET
607: book_type_code = decode(X_Book_Type_Code,
608: NULL, book_type_code,
609: FND_API.G_MISS_CHAR, null,
610: X_Book_Type_Code),
611: asset_id = decode(X_Asset_Id,
612: NULL, asset_id,
613: FND_API.G_MISS_NUM, null,
609: FND_API.G_MISS_CHAR, null,
610: X_Book_Type_Code),
611: asset_id = decode(X_Asset_Id,
612: NULL, asset_id,
613: FND_API.G_MISS_NUM, null,
614: X_Asset_Id),
615: period_counter = decode(X_Period_Counter,
616: NULL, period_counter,
617: FND_API.G_MISS_NUM, null,
613: FND_API.G_MISS_NUM, null,
614: X_Asset_Id),
615: period_counter = decode(X_Period_Counter,
616: NULL, period_counter,
617: FND_API.G_MISS_NUM, null,
618: X_Period_Counter),
619: distribution_id = decode(X_Distribution_Id,
620: NULL, distribution_id,
621: FND_API.G_MISS_NUM, null,
617: FND_API.G_MISS_NUM, null,
618: X_Period_Counter),
619: distribution_id = decode(X_Distribution_Id,
620: NULL, distribution_id,
621: FND_API.G_MISS_NUM, null,
622: X_Distribution_Id),
623: deprn_source_code = decode(X_Deprn_Source_Code,
624: NULL, deprn_source_code,
625: FND_API.G_MISS_CHAR, null,
621: FND_API.G_MISS_NUM, null,
622: X_Distribution_Id),
623: deprn_source_code = decode(X_Deprn_Source_Code,
624: NULL, deprn_source_code,
625: FND_API.G_MISS_CHAR, null,
626: X_Deprn_Source_Code),
627: deprn_run_date = decode(X_Deprn_Run_Date,
628: NULL, deprn_run_date,
629: X_Deprn_Run_Date),
628: NULL, deprn_run_date,
629: X_Deprn_Run_Date),
630: deprn_amount = decode(X_Deprn_Amount,
631: NULL, deprn_amount,
632: FND_API.G_MISS_NUM, null,
633: X_Deprn_Amount),
634: ytd_deprn = decode(X_Ytd_Deprn,
635: NULL, ytd_deprn,
636: FND_API.G_MISS_NUM, null,
632: FND_API.G_MISS_NUM, null,
633: X_Deprn_Amount),
634: ytd_deprn = decode(X_Ytd_Deprn,
635: NULL, ytd_deprn,
636: FND_API.G_MISS_NUM, null,
637: X_Ytd_Deprn),
638: deprn_reserve = decode(X_Deprn_Reserve,
639: NULL, deprn_reserve,
640: FND_API.G_MISS_NUM, null,
636: FND_API.G_MISS_NUM, null,
637: X_Ytd_Deprn),
638: deprn_reserve = decode(X_Deprn_Reserve,
639: NULL, deprn_reserve,
640: FND_API.G_MISS_NUM, null,
641: X_Deprn_Reserve),
642: addition_cost_to_clear = decode(X_Addition_Cost_To_Clear,
643: NULL, addition_cost_to_clear,
644: FND_API.G_MISS_NUM, null,
640: FND_API.G_MISS_NUM, null,
641: X_Deprn_Reserve),
642: addition_cost_to_clear = decode(X_Addition_Cost_To_Clear,
643: NULL, addition_cost_to_clear,
644: FND_API.G_MISS_NUM, null,
645: X_Addition_Cost_To_Clear),
646: cost = decode(X_Cost,
647: NULL, cost,
648: FND_API.G_MISS_NUM, null,
644: FND_API.G_MISS_NUM, null,
645: X_Addition_Cost_To_Clear),
646: cost = decode(X_Cost,
647: NULL, cost,
648: FND_API.G_MISS_NUM, null,
649: X_Cost),
650: deprn_adjustment_amount = decode(X_Deprn_Adjustment_Amount,
651: NULL, deprn_adjustment_amount,
652: FND_API.G_MISS_NUM, null,
648: FND_API.G_MISS_NUM, null,
649: X_Cost),
650: deprn_adjustment_amount = decode(X_Deprn_Adjustment_Amount,
651: NULL, deprn_adjustment_amount,
652: FND_API.G_MISS_NUM, null,
653: X_Deprn_Adjustment_Amount),
654: deprn_expense_je_line_num = decode(X_Deprn_Expense_Je_Line_Num,
655: NULL, deprn_expense_je_line_num,
656: FND_API.G_MISS_NUM, null,
652: FND_API.G_MISS_NUM, null,
653: X_Deprn_Adjustment_Amount),
654: deprn_expense_je_line_num = decode(X_Deprn_Expense_Je_Line_Num,
655: NULL, deprn_expense_je_line_num,
656: FND_API.G_MISS_NUM, null,
657: X_Deprn_Expense_Je_Line_Num),
658: deprn_reserve_je_line_num = decode(X_Deprn_Reserve_Je_Line_Num,
659: NULL, deprn_reserve_je_line_num,
660: FND_API.G_MISS_NUM, null,
656: FND_API.G_MISS_NUM, null,
657: X_Deprn_Expense_Je_Line_Num),
658: deprn_reserve_je_line_num = decode(X_Deprn_Reserve_Je_Line_Num,
659: NULL, deprn_reserve_je_line_num,
660: FND_API.G_MISS_NUM, null,
661: X_Deprn_Reserve_Je_Line_Num),
662: reval_amort_je_line_num = decode(X_Reval_Amort_Je_Line_Num,
663: NULL, reval_amort_je_line_num,
664: FND_API.G_MISS_NUM, null,
660: FND_API.G_MISS_NUM, null,
661: X_Deprn_Reserve_Je_Line_Num),
662: reval_amort_je_line_num = decode(X_Reval_Amort_Je_Line_Num,
663: NULL, reval_amort_je_line_num,
664: FND_API.G_MISS_NUM, null,
665: X_Reval_Amort_Je_Line_Num),
666: reval_reserve_je_line_num = decode(X_Reval_Reserve_Je_Line_Num,
667: NULL, reval_reserve_je_line_num,
668: FND_API.G_MISS_NUM, null,
664: FND_API.G_MISS_NUM, null,
665: X_Reval_Amort_Je_Line_Num),
666: reval_reserve_je_line_num = decode(X_Reval_Reserve_Je_Line_Num,
667: NULL, reval_reserve_je_line_num,
668: FND_API.G_MISS_NUM, null,
669: X_Reval_Reserve_Je_Line_Num),
670: je_header_id = decode(X_Je_Header_Id,
671: NULL, je_header_id,
672: FND_API.G_MISS_NUM, null,
668: FND_API.G_MISS_NUM, null,
669: X_Reval_Reserve_Je_Line_Num),
670: je_header_id = decode(X_Je_Header_Id,
671: NULL, je_header_id,
672: FND_API.G_MISS_NUM, null,
673: X_Je_Header_Id),
674: reval_amortization = decode(X_Reval_Amortization,
675: NULL, reval_amortization,
676: FND_API.G_MISS_NUM, null,
672: FND_API.G_MISS_NUM, null,
673: X_Je_Header_Id),
674: reval_amortization = decode(X_Reval_Amortization,
675: NULL, reval_amortization,
676: FND_API.G_MISS_NUM, null,
677: X_Reval_Amortization),
678: reval_deprn_expense = decode(X_Reval_Deprn_Expense,
679: NULL, reval_deprn_expense,
680: FND_API.G_MISS_NUM, null,
676: FND_API.G_MISS_NUM, null,
677: X_Reval_Amortization),
678: reval_deprn_expense = decode(X_Reval_Deprn_Expense,
679: NULL, reval_deprn_expense,
680: FND_API.G_MISS_NUM, null,
681: X_Reval_Deprn_Expense),
682: reval_reserve = decode(X_Reval_Reserve,
683: NULL, reval_reserve,
684: FND_API.G_MISS_NUM, null,
680: FND_API.G_MISS_NUM, null,
681: X_Reval_Deprn_Expense),
682: reval_reserve = decode(X_Reval_Reserve,
683: NULL, reval_reserve,
684: FND_API.G_MISS_NUM, null,
685: X_Reval_Reserve),
686: ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
687: NULL, ytd_reval_deprn_expense,
688: FND_API.G_MISS_NUM, null,
684: FND_API.G_MISS_NUM, null,
685: X_Reval_Reserve),
686: ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
687: NULL, ytd_reval_deprn_expense,
688: FND_API.G_MISS_NUM, null,
689: X_Ytd_Reval_Deprn_Expense)
690: WHERE book_type_code = X_Book_Type_Code
691: and asset_id = X_Asset_Id
692: and period_counter = X_Period_Counter