eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_DEPRN_DETAIL_PKG dependencies on FND_API

Line 334: FND_API.G_MISS_CHAR, null,

330: UPDATE fa_deprn_detail_mrc_v
331: SET
332: book_type_code = decode(X_Book_Type_Code,
333: NULL, book_type_code,
334: FND_API.G_MISS_CHAR, null,
335: X_Book_Type_Code),
336: asset_id = decode(X_Asset_Id,
337: NULL, asset_id,
338: FND_API.G_MISS_NUM, null,

Line 338: FND_API.G_MISS_NUM, null,

334: FND_API.G_MISS_CHAR, null,
335: X_Book_Type_Code),
336: asset_id = decode(X_Asset_Id,
337: NULL, asset_id,
338: FND_API.G_MISS_NUM, null,
339: X_Asset_Id),
340: period_counter = decode(X_Period_Counter,
341: NULL, period_counter,
342: FND_API.G_MISS_NUM, null,

Line 342: FND_API.G_MISS_NUM, null,

338: FND_API.G_MISS_NUM, null,
339: X_Asset_Id),
340: period_counter = decode(X_Period_Counter,
341: NULL, period_counter,
342: FND_API.G_MISS_NUM, null,
343: X_Period_Counter),
344: distribution_id = decode(X_Distribution_Id,
345: NULL, distribution_id,
346: FND_API.G_MISS_NUM, null,

Line 346: FND_API.G_MISS_NUM, null,

342: FND_API.G_MISS_NUM, null,
343: X_Period_Counter),
344: distribution_id = decode(X_Distribution_Id,
345: NULL, distribution_id,
346: FND_API.G_MISS_NUM, null,
347: X_Distribution_Id),
348: deprn_source_code = decode(X_Deprn_Source_Code,
349: NULL, deprn_source_code,
350: FND_API.G_MISS_CHAR, null,

Line 350: FND_API.G_MISS_CHAR, null,

346: FND_API.G_MISS_NUM, null,
347: X_Distribution_Id),
348: deprn_source_code = decode(X_Deprn_Source_Code,
349: NULL, deprn_source_code,
350: FND_API.G_MISS_CHAR, null,
351: X_Deprn_Source_Code),
352: deprn_run_date = decode(X_Deprn_Run_Date,
353: NULL, deprn_run_date,
354: X_Deprn_Run_Date),

Line 357: FND_API.G_MISS_NUM, null,

353: NULL, deprn_run_date,
354: X_Deprn_Run_Date),
355: deprn_amount = decode(X_Deprn_Amount,
356: NULL, deprn_amount,
357: FND_API.G_MISS_NUM, null,
358: X_Deprn_Amount),
359: ytd_deprn = decode(X_Ytd_Deprn,
360: NULL, ytd_deprn,
361: FND_API.G_MISS_NUM, null,

Line 361: FND_API.G_MISS_NUM, null,

357: FND_API.G_MISS_NUM, null,
358: X_Deprn_Amount),
359: ytd_deprn = decode(X_Ytd_Deprn,
360: NULL, ytd_deprn,
361: FND_API.G_MISS_NUM, null,
362: X_Ytd_Deprn),
363: deprn_reserve = decode(X_Deprn_Reserve,
364: NULL, deprn_reserve,
365: FND_API.G_MISS_NUM, null,

Line 365: FND_API.G_MISS_NUM, null,

361: FND_API.G_MISS_NUM, null,
362: X_Ytd_Deprn),
363: deprn_reserve = decode(X_Deprn_Reserve,
364: NULL, deprn_reserve,
365: FND_API.G_MISS_NUM, null,
366: X_Deprn_Reserve),
367: addition_cost_to_clear = decode(X_Addition_Cost_To_Clear,
368: NULL, addition_cost_to_clear,
369: FND_API.G_MISS_NUM, null,

Line 369: FND_API.G_MISS_NUM, null,

365: FND_API.G_MISS_NUM, null,
366: X_Deprn_Reserve),
367: addition_cost_to_clear = decode(X_Addition_Cost_To_Clear,
368: NULL, addition_cost_to_clear,
369: FND_API.G_MISS_NUM, null,
370: X_Addition_Cost_To_Clear),
371: cost = decode(X_Cost,
372: NULL, cost,
373: FND_API.G_MISS_NUM, null,

Line 373: FND_API.G_MISS_NUM, null,

369: FND_API.G_MISS_NUM, null,
370: X_Addition_Cost_To_Clear),
371: cost = decode(X_Cost,
372: NULL, cost,
373: FND_API.G_MISS_NUM, null,
374: X_Cost),
375: deprn_adjustment_amount = decode(X_Deprn_Adjustment_Amount,
376: NULL, deprn_adjustment_amount,
377: FND_API.G_MISS_NUM, null,

Line 377: FND_API.G_MISS_NUM, null,

373: FND_API.G_MISS_NUM, null,
374: X_Cost),
375: deprn_adjustment_amount = decode(X_Deprn_Adjustment_Amount,
376: NULL, deprn_adjustment_amount,
377: FND_API.G_MISS_NUM, null,
378: X_Deprn_Adjustment_Amount),
379: deprn_expense_je_line_num = decode(X_Deprn_Expense_Je_Line_Num,
380: NULL, deprn_expense_je_line_num,
381: FND_API.G_MISS_NUM, null,

Line 381: FND_API.G_MISS_NUM, null,

377: FND_API.G_MISS_NUM, null,
378: X_Deprn_Adjustment_Amount),
379: deprn_expense_je_line_num = decode(X_Deprn_Expense_Je_Line_Num,
380: NULL, deprn_expense_je_line_num,
381: FND_API.G_MISS_NUM, null,
382: X_Deprn_Expense_Je_Line_Num),
383: deprn_reserve_je_line_num = decode(X_Deprn_Reserve_Je_Line_Num,
384: NULL, deprn_reserve_je_line_num,
385: FND_API.G_MISS_NUM, null,

Line 385: FND_API.G_MISS_NUM, null,

381: FND_API.G_MISS_NUM, null,
382: X_Deprn_Expense_Je_Line_Num),
383: deprn_reserve_je_line_num = decode(X_Deprn_Reserve_Je_Line_Num,
384: NULL, deprn_reserve_je_line_num,
385: FND_API.G_MISS_NUM, null,
386: X_Deprn_Reserve_Je_Line_Num),
387: reval_amort_je_line_num = decode(X_Reval_Amort_Je_Line_Num,
388: NULL, reval_amort_je_line_num,
389: FND_API.G_MISS_NUM, null,

Line 389: FND_API.G_MISS_NUM, null,

385: FND_API.G_MISS_NUM, null,
386: X_Deprn_Reserve_Je_Line_Num),
387: reval_amort_je_line_num = decode(X_Reval_Amort_Je_Line_Num,
388: NULL, reval_amort_je_line_num,
389: FND_API.G_MISS_NUM, null,
390: X_Reval_Amort_Je_Line_Num),
391: reval_reserve_je_line_num = decode(X_Reval_Reserve_Je_Line_Num,
392: NULL, reval_reserve_je_line_num,
393: FND_API.G_MISS_NUM, null,

Line 393: FND_API.G_MISS_NUM, null,

389: FND_API.G_MISS_NUM, null,
390: X_Reval_Amort_Je_Line_Num),
391: reval_reserve_je_line_num = decode(X_Reval_Reserve_Je_Line_Num,
392: NULL, reval_reserve_je_line_num,
393: FND_API.G_MISS_NUM, null,
394: X_Reval_Reserve_Je_Line_Num),
395: je_header_id = decode(X_Je_Header_Id,
396: NULL, je_header_id,
397: FND_API.G_MISS_NUM, null,

Line 397: FND_API.G_MISS_NUM, null,

393: FND_API.G_MISS_NUM, null,
394: X_Reval_Reserve_Je_Line_Num),
395: je_header_id = decode(X_Je_Header_Id,
396: NULL, je_header_id,
397: FND_API.G_MISS_NUM, null,
398: X_Je_Header_Id),
399: reval_amortization = decode(X_Reval_Amortization,
400: NULL, reval_amortization,
401: FND_API.G_MISS_NUM, null,

Line 401: FND_API.G_MISS_NUM, null,

397: FND_API.G_MISS_NUM, null,
398: X_Je_Header_Id),
399: reval_amortization = decode(X_Reval_Amortization,
400: NULL, reval_amortization,
401: FND_API.G_MISS_NUM, null,
402: X_Reval_Amortization),
403: reval_deprn_expense = decode(X_Reval_Deprn_Expense,
404: NULL, reval_deprn_expense,
405: FND_API.G_MISS_NUM, null,

Line 405: FND_API.G_MISS_NUM, null,

401: FND_API.G_MISS_NUM, null,
402: X_Reval_Amortization),
403: reval_deprn_expense = decode(X_Reval_Deprn_Expense,
404: NULL, reval_deprn_expense,
405: FND_API.G_MISS_NUM, null,
406: X_Reval_Deprn_Expense),
407: reval_reserve = decode(X_Reval_Reserve,
408: NULL, reval_reserve,
409: FND_API.G_MISS_NUM, null,

Line 409: FND_API.G_MISS_NUM, null,

405: FND_API.G_MISS_NUM, null,
406: X_Reval_Deprn_Expense),
407: reval_reserve = decode(X_Reval_Reserve,
408: NULL, reval_reserve,
409: FND_API.G_MISS_NUM, null,
410: X_Reval_Reserve),
411: ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
412: NULL, ytd_reval_deprn_expense,
413: FND_API.G_MISS_NUM, null,

Line 413: FND_API.G_MISS_NUM, null,

409: FND_API.G_MISS_NUM, null,
410: X_Reval_Reserve),
411: ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
412: NULL, ytd_reval_deprn_expense,
413: FND_API.G_MISS_NUM, null,
414: X_Ytd_Reval_Deprn_Expense)
415: WHERE rowid = X_Rowid;
416:
417: else

Line 422: FND_API.G_MISS_CHAR, null,

418: UPDATE fa_deprn_detail
419: SET
420: book_type_code = decode(X_Book_Type_Code,
421: NULL, book_type_code,
422: FND_API.G_MISS_CHAR, null,
423: X_Book_Type_Code),
424: asset_id = decode(X_Asset_Id,
425: NULL, asset_id,
426: FND_API.G_MISS_NUM, null,

Line 426: FND_API.G_MISS_NUM, null,

422: FND_API.G_MISS_CHAR, null,
423: X_Book_Type_Code),
424: asset_id = decode(X_Asset_Id,
425: NULL, asset_id,
426: FND_API.G_MISS_NUM, null,
427: X_Asset_Id),
428: period_counter = decode(X_Period_Counter,
429: NULL, period_counter,
430: FND_API.G_MISS_NUM, null,

Line 430: FND_API.G_MISS_NUM, null,

426: FND_API.G_MISS_NUM, null,
427: X_Asset_Id),
428: period_counter = decode(X_Period_Counter,
429: NULL, period_counter,
430: FND_API.G_MISS_NUM, null,
431: X_Period_Counter),
432: distribution_id = decode(X_Distribution_Id,
433: NULL, distribution_id,
434: FND_API.G_MISS_NUM, null,

Line 434: FND_API.G_MISS_NUM, null,

430: FND_API.G_MISS_NUM, null,
431: X_Period_Counter),
432: distribution_id = decode(X_Distribution_Id,
433: NULL, distribution_id,
434: FND_API.G_MISS_NUM, null,
435: X_Distribution_Id),
436: deprn_source_code = decode(X_Deprn_Source_Code,
437: NULL, deprn_source_code,
438: FND_API.G_MISS_CHAR, null,

Line 438: FND_API.G_MISS_CHAR, null,

434: FND_API.G_MISS_NUM, null,
435: X_Distribution_Id),
436: deprn_source_code = decode(X_Deprn_Source_Code,
437: NULL, deprn_source_code,
438: FND_API.G_MISS_CHAR, null,
439: X_Deprn_Source_Code),
440: deprn_run_date = decode(X_Deprn_Run_Date,
441: NULL, deprn_run_date,
442: X_Deprn_Run_Date),

Line 445: FND_API.G_MISS_NUM, null,

441: NULL, deprn_run_date,
442: X_Deprn_Run_Date),
443: deprn_amount = decode(X_Deprn_Amount,
444: NULL, deprn_amount,
445: FND_API.G_MISS_NUM, null,
446: X_Deprn_Amount),
447: ytd_deprn = decode(X_Ytd_Deprn,
448: NULL, ytd_deprn,
449: FND_API.G_MISS_NUM, null,

Line 449: FND_API.G_MISS_NUM, null,

445: FND_API.G_MISS_NUM, null,
446: X_Deprn_Amount),
447: ytd_deprn = decode(X_Ytd_Deprn,
448: NULL, ytd_deprn,
449: FND_API.G_MISS_NUM, null,
450: X_Ytd_Deprn),
451: deprn_reserve = decode(X_Deprn_Reserve,
452: NULL, deprn_reserve,
453: FND_API.G_MISS_NUM, null,

Line 453: FND_API.G_MISS_NUM, null,

449: FND_API.G_MISS_NUM, null,
450: X_Ytd_Deprn),
451: deprn_reserve = decode(X_Deprn_Reserve,
452: NULL, deprn_reserve,
453: FND_API.G_MISS_NUM, null,
454: X_Deprn_Reserve),
455: addition_cost_to_clear = decode(X_Addition_Cost_To_Clear,
456: NULL, addition_cost_to_clear,
457: FND_API.G_MISS_NUM, null,

Line 457: FND_API.G_MISS_NUM, null,

453: FND_API.G_MISS_NUM, null,
454: X_Deprn_Reserve),
455: addition_cost_to_clear = decode(X_Addition_Cost_To_Clear,
456: NULL, addition_cost_to_clear,
457: FND_API.G_MISS_NUM, null,
458: X_Addition_Cost_To_Clear),
459: cost = decode(X_Cost,
460: NULL, cost,
461: FND_API.G_MISS_NUM, null,

Line 461: FND_API.G_MISS_NUM, null,

457: FND_API.G_MISS_NUM, null,
458: X_Addition_Cost_To_Clear),
459: cost = decode(X_Cost,
460: NULL, cost,
461: FND_API.G_MISS_NUM, null,
462: X_Cost),
463: deprn_adjustment_amount = decode(X_Deprn_Adjustment_Amount,
464: NULL, deprn_adjustment_amount,
465: FND_API.G_MISS_NUM, null,

Line 465: FND_API.G_MISS_NUM, null,

461: FND_API.G_MISS_NUM, null,
462: X_Cost),
463: deprn_adjustment_amount = decode(X_Deprn_Adjustment_Amount,
464: NULL, deprn_adjustment_amount,
465: FND_API.G_MISS_NUM, null,
466: X_Deprn_Adjustment_Amount),
467: deprn_expense_je_line_num = decode(X_Deprn_Expense_Je_Line_Num,
468: NULL, deprn_expense_je_line_num,
469: FND_API.G_MISS_NUM, null,

Line 469: FND_API.G_MISS_NUM, null,

465: FND_API.G_MISS_NUM, null,
466: X_Deprn_Adjustment_Amount),
467: deprn_expense_je_line_num = decode(X_Deprn_Expense_Je_Line_Num,
468: NULL, deprn_expense_je_line_num,
469: FND_API.G_MISS_NUM, null,
470: X_Deprn_Expense_Je_Line_Num),
471: deprn_reserve_je_line_num = decode(X_Deprn_Reserve_Je_Line_Num,
472: NULL, deprn_reserve_je_line_num,
473: FND_API.G_MISS_NUM, null,

Line 473: FND_API.G_MISS_NUM, null,

469: FND_API.G_MISS_NUM, null,
470: X_Deprn_Expense_Je_Line_Num),
471: deprn_reserve_je_line_num = decode(X_Deprn_Reserve_Je_Line_Num,
472: NULL, deprn_reserve_je_line_num,
473: FND_API.G_MISS_NUM, null,
474: X_Deprn_Reserve_Je_Line_Num),
475: reval_amort_je_line_num = decode(X_Reval_Amort_Je_Line_Num,
476: NULL, reval_amort_je_line_num,
477: FND_API.G_MISS_NUM, null,

Line 477: FND_API.G_MISS_NUM, null,

473: FND_API.G_MISS_NUM, null,
474: X_Deprn_Reserve_Je_Line_Num),
475: reval_amort_je_line_num = decode(X_Reval_Amort_Je_Line_Num,
476: NULL, reval_amort_je_line_num,
477: FND_API.G_MISS_NUM, null,
478: X_Reval_Amort_Je_Line_Num),
479: reval_reserve_je_line_num = decode(X_Reval_Reserve_Je_Line_Num,
480: NULL, reval_reserve_je_line_num,
481: FND_API.G_MISS_NUM, null,

Line 481: FND_API.G_MISS_NUM, null,

477: FND_API.G_MISS_NUM, null,
478: X_Reval_Amort_Je_Line_Num),
479: reval_reserve_je_line_num = decode(X_Reval_Reserve_Je_Line_Num,
480: NULL, reval_reserve_je_line_num,
481: FND_API.G_MISS_NUM, null,
482: X_Reval_Reserve_Je_Line_Num),
483: je_header_id = decode(X_Je_Header_Id,
484: NULL, je_header_id,
485: FND_API.G_MISS_NUM, null,

Line 485: FND_API.G_MISS_NUM, null,

481: FND_API.G_MISS_NUM, null,
482: X_Reval_Reserve_Je_Line_Num),
483: je_header_id = decode(X_Je_Header_Id,
484: NULL, je_header_id,
485: FND_API.G_MISS_NUM, null,
486: X_Je_Header_Id),
487: reval_amortization = decode(X_Reval_Amortization,
488: NULL, reval_amortization,
489: FND_API.G_MISS_NUM, null,

Line 489: FND_API.G_MISS_NUM, null,

485: FND_API.G_MISS_NUM, null,
486: X_Je_Header_Id),
487: reval_amortization = decode(X_Reval_Amortization,
488: NULL, reval_amortization,
489: FND_API.G_MISS_NUM, null,
490: X_Reval_Amortization),
491: reval_deprn_expense = decode(X_Reval_Deprn_Expense,
492: NULL, reval_deprn_expense,
493: FND_API.G_MISS_NUM, null,

Line 493: FND_API.G_MISS_NUM, null,

489: FND_API.G_MISS_NUM, null,
490: X_Reval_Amortization),
491: reval_deprn_expense = decode(X_Reval_Deprn_Expense,
492: NULL, reval_deprn_expense,
493: FND_API.G_MISS_NUM, null,
494: X_Reval_Deprn_Expense),
495: reval_reserve = decode(X_Reval_Reserve,
496: NULL, reval_reserve,
497: FND_API.G_MISS_NUM, null,

Line 497: FND_API.G_MISS_NUM, null,

493: FND_API.G_MISS_NUM, null,
494: X_Reval_Deprn_Expense),
495: reval_reserve = decode(X_Reval_Reserve,
496: NULL, reval_reserve,
497: FND_API.G_MISS_NUM, null,
498: X_Reval_Reserve),
499: ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
500: NULL, ytd_reval_deprn_expense,
501: FND_API.G_MISS_NUM, null,

Line 501: FND_API.G_MISS_NUM, null,

497: FND_API.G_MISS_NUM, null,
498: X_Reval_Reserve),
499: ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
500: NULL, ytd_reval_deprn_expense,
501: FND_API.G_MISS_NUM, null,
502: X_Ytd_Reval_Deprn_Expense)
503: WHERE rowid = X_Rowid;
504: end if;
505: else

Line 511: FND_API.G_MISS_CHAR, null,

507: UPDATE fa_deprn_detail_mrc_v
508: SET
509: book_type_code = decode(X_Book_Type_Code,
510: NULL, book_type_code,
511: FND_API.G_MISS_CHAR, null,
512: X_Book_Type_Code),
513: asset_id = decode(X_Asset_Id,
514: NULL, asset_id,
515: FND_API.G_MISS_NUM, null,

Line 515: FND_API.G_MISS_NUM, null,

511: FND_API.G_MISS_CHAR, null,
512: X_Book_Type_Code),
513: asset_id = decode(X_Asset_Id,
514: NULL, asset_id,
515: FND_API.G_MISS_NUM, null,
516: X_Asset_Id),
517: period_counter = decode(X_Period_Counter,
518: NULL, period_counter,
519: FND_API.G_MISS_NUM, null,

Line 519: FND_API.G_MISS_NUM, null,

515: FND_API.G_MISS_NUM, null,
516: X_Asset_Id),
517: period_counter = decode(X_Period_Counter,
518: NULL, period_counter,
519: FND_API.G_MISS_NUM, null,
520: X_Period_Counter),
521: distribution_id = decode(X_Distribution_Id,
522: NULL, distribution_id,
523: FND_API.G_MISS_NUM, null,

Line 523: FND_API.G_MISS_NUM, null,

519: FND_API.G_MISS_NUM, null,
520: X_Period_Counter),
521: distribution_id = decode(X_Distribution_Id,
522: NULL, distribution_id,
523: FND_API.G_MISS_NUM, null,
524: X_Distribution_Id),
525: deprn_source_code = decode(X_Deprn_Source_Code,
526: NULL, deprn_source_code,
527: FND_API.G_MISS_CHAR, null,

Line 527: FND_API.G_MISS_CHAR, null,

523: FND_API.G_MISS_NUM, null,
524: X_Distribution_Id),
525: deprn_source_code = decode(X_Deprn_Source_Code,
526: NULL, deprn_source_code,
527: FND_API.G_MISS_CHAR, null,
528: X_Deprn_Source_Code),
529: deprn_run_date = decode(X_Deprn_Run_Date,
530: NULL, deprn_run_date,
531: X_Deprn_Run_Date),

Line 534: FND_API.G_MISS_NUM, null,

530: NULL, deprn_run_date,
531: X_Deprn_Run_Date),
532: deprn_amount = decode(X_Deprn_Amount,
533: NULL, deprn_amount,
534: FND_API.G_MISS_NUM, null,
535: X_Deprn_Amount),
536: ytd_deprn = decode(X_Ytd_Deprn,
537: NULL, ytd_deprn,
538: FND_API.G_MISS_NUM, null,

Line 538: FND_API.G_MISS_NUM, null,

534: FND_API.G_MISS_NUM, null,
535: X_Deprn_Amount),
536: ytd_deprn = decode(X_Ytd_Deprn,
537: NULL, ytd_deprn,
538: FND_API.G_MISS_NUM, null,
539: X_Ytd_Deprn),
540: deprn_reserve = decode(X_Deprn_Reserve,
541: NULL, deprn_reserve,
542: FND_API.G_MISS_NUM, null,

Line 542: FND_API.G_MISS_NUM, null,

538: FND_API.G_MISS_NUM, null,
539: X_Ytd_Deprn),
540: deprn_reserve = decode(X_Deprn_Reserve,
541: NULL, deprn_reserve,
542: FND_API.G_MISS_NUM, null,
543: X_Deprn_Reserve),
544: addition_cost_to_clear = decode(X_Addition_Cost_To_Clear,
545: NULL, addition_cost_to_clear,
546: FND_API.G_MISS_NUM, null,

Line 546: FND_API.G_MISS_NUM, null,

542: FND_API.G_MISS_NUM, null,
543: X_Deprn_Reserve),
544: addition_cost_to_clear = decode(X_Addition_Cost_To_Clear,
545: NULL, addition_cost_to_clear,
546: FND_API.G_MISS_NUM, null,
547: X_Addition_Cost_To_Clear),
548: cost = decode(X_Cost,
549: NULL, cost,
550: FND_API.G_MISS_NUM, null,

Line 550: FND_API.G_MISS_NUM, null,

546: FND_API.G_MISS_NUM, null,
547: X_Addition_Cost_To_Clear),
548: cost = decode(X_Cost,
549: NULL, cost,
550: FND_API.G_MISS_NUM, null,
551: X_Cost),
552: deprn_adjustment_amount = decode(X_Deprn_Adjustment_Amount,
553: NULL, deprn_adjustment_amount,
554: FND_API.G_MISS_NUM, null,

Line 554: FND_API.G_MISS_NUM, null,

550: FND_API.G_MISS_NUM, null,
551: X_Cost),
552: deprn_adjustment_amount = decode(X_Deprn_Adjustment_Amount,
553: NULL, deprn_adjustment_amount,
554: FND_API.G_MISS_NUM, null,
555: X_Deprn_Adjustment_Amount),
556: deprn_expense_je_line_num = decode(X_Deprn_Expense_Je_Line_Num,
557: NULL, deprn_expense_je_line_num,
558: FND_API.G_MISS_NUM, null,

Line 558: FND_API.G_MISS_NUM, null,

554: FND_API.G_MISS_NUM, null,
555: X_Deprn_Adjustment_Amount),
556: deprn_expense_je_line_num = decode(X_Deprn_Expense_Je_Line_Num,
557: NULL, deprn_expense_je_line_num,
558: FND_API.G_MISS_NUM, null,
559: X_Deprn_Expense_Je_Line_Num),
560: deprn_reserve_je_line_num = decode(X_Deprn_Reserve_Je_Line_Num,
561: NULL, deprn_reserve_je_line_num,
562: FND_API.G_MISS_NUM, null,

Line 562: FND_API.G_MISS_NUM, null,

558: FND_API.G_MISS_NUM, null,
559: X_Deprn_Expense_Je_Line_Num),
560: deprn_reserve_je_line_num = decode(X_Deprn_Reserve_Je_Line_Num,
561: NULL, deprn_reserve_je_line_num,
562: FND_API.G_MISS_NUM, null,
563: X_Deprn_Reserve_Je_Line_Num),
564: reval_amort_je_line_num = decode(X_Reval_Amort_Je_Line_Num,
565: NULL, reval_amort_je_line_num,
566: FND_API.G_MISS_NUM, null,

Line 566: FND_API.G_MISS_NUM, null,

562: FND_API.G_MISS_NUM, null,
563: X_Deprn_Reserve_Je_Line_Num),
564: reval_amort_je_line_num = decode(X_Reval_Amort_Je_Line_Num,
565: NULL, reval_amort_je_line_num,
566: FND_API.G_MISS_NUM, null,
567: X_Reval_Amort_Je_Line_Num),
568: reval_reserve_je_line_num = decode(X_Reval_Reserve_Je_Line_Num,
569: NULL, reval_reserve_je_line_num,
570: FND_API.G_MISS_NUM, null,

Line 570: FND_API.G_MISS_NUM, null,

566: FND_API.G_MISS_NUM, null,
567: X_Reval_Amort_Je_Line_Num),
568: reval_reserve_je_line_num = decode(X_Reval_Reserve_Je_Line_Num,
569: NULL, reval_reserve_je_line_num,
570: FND_API.G_MISS_NUM, null,
571: X_Reval_Reserve_Je_Line_Num),
572: je_header_id = decode(X_Je_Header_Id,
573: NULL, je_header_id,
574: FND_API.G_MISS_NUM, null,

Line 574: FND_API.G_MISS_NUM, null,

570: FND_API.G_MISS_NUM, null,
571: X_Reval_Reserve_Je_Line_Num),
572: je_header_id = decode(X_Je_Header_Id,
573: NULL, je_header_id,
574: FND_API.G_MISS_NUM, null,
575: X_Je_Header_Id),
576: reval_amortization = decode(X_Reval_Amortization,
577: NULL, reval_amortization,
578: FND_API.G_MISS_NUM, null,

Line 578: FND_API.G_MISS_NUM, null,

574: FND_API.G_MISS_NUM, null,
575: X_Je_Header_Id),
576: reval_amortization = decode(X_Reval_Amortization,
577: NULL, reval_amortization,
578: FND_API.G_MISS_NUM, null,
579: X_Reval_Amortization),
580: reval_deprn_expense = decode(X_Reval_Deprn_Expense,
581: NULL, reval_deprn_expense,
582: FND_API.G_MISS_NUM, null,

Line 582: FND_API.G_MISS_NUM, null,

578: FND_API.G_MISS_NUM, null,
579: X_Reval_Amortization),
580: reval_deprn_expense = decode(X_Reval_Deprn_Expense,
581: NULL, reval_deprn_expense,
582: FND_API.G_MISS_NUM, null,
583: X_Reval_Deprn_Expense),
584: reval_reserve = decode(X_Reval_Reserve,
585: NULL, reval_reserve,
586: FND_API.G_MISS_NUM, null,

Line 586: FND_API.G_MISS_NUM, null,

582: FND_API.G_MISS_NUM, null,
583: X_Reval_Deprn_Expense),
584: reval_reserve = decode(X_Reval_Reserve,
585: NULL, reval_reserve,
586: FND_API.G_MISS_NUM, null,
587: X_Reval_Reserve),
588: ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
589: NULL, ytd_reval_deprn_expense,
590: FND_API.G_MISS_NUM, null,

Line 590: FND_API.G_MISS_NUM, null,

586: FND_API.G_MISS_NUM, null,
587: X_Reval_Reserve),
588: ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
589: NULL, ytd_reval_deprn_expense,
590: FND_API.G_MISS_NUM, null,
591: X_Ytd_Reval_Deprn_Expense)
592: WHERE book_type_code = X_Book_Type_Code
593: and asset_id = X_Asset_Id
594: and period_counter = X_Period_Counter

Line 604: FND_API.G_MISS_CHAR, null,

600: UPDATE fa_deprn_detail
601: SET
602: book_type_code = decode(X_Book_Type_Code,
603: NULL, book_type_code,
604: FND_API.G_MISS_CHAR, null,
605: X_Book_Type_Code),
606: asset_id = decode(X_Asset_Id,
607: NULL, asset_id,
608: FND_API.G_MISS_NUM, null,

Line 608: FND_API.G_MISS_NUM, null,

604: FND_API.G_MISS_CHAR, null,
605: X_Book_Type_Code),
606: asset_id = decode(X_Asset_Id,
607: NULL, asset_id,
608: FND_API.G_MISS_NUM, null,
609: X_Asset_Id),
610: period_counter = decode(X_Period_Counter,
611: NULL, period_counter,
612: FND_API.G_MISS_NUM, null,

Line 612: FND_API.G_MISS_NUM, null,

608: FND_API.G_MISS_NUM, null,
609: X_Asset_Id),
610: period_counter = decode(X_Period_Counter,
611: NULL, period_counter,
612: FND_API.G_MISS_NUM, null,
613: X_Period_Counter),
614: distribution_id = decode(X_Distribution_Id,
615: NULL, distribution_id,
616: FND_API.G_MISS_NUM, null,

Line 616: FND_API.G_MISS_NUM, null,

612: FND_API.G_MISS_NUM, null,
613: X_Period_Counter),
614: distribution_id = decode(X_Distribution_Id,
615: NULL, distribution_id,
616: FND_API.G_MISS_NUM, null,
617: X_Distribution_Id),
618: deprn_source_code = decode(X_Deprn_Source_Code,
619: NULL, deprn_source_code,
620: FND_API.G_MISS_CHAR, null,

Line 620: FND_API.G_MISS_CHAR, null,

616: FND_API.G_MISS_NUM, null,
617: X_Distribution_Id),
618: deprn_source_code = decode(X_Deprn_Source_Code,
619: NULL, deprn_source_code,
620: FND_API.G_MISS_CHAR, null,
621: X_Deprn_Source_Code),
622: deprn_run_date = decode(X_Deprn_Run_Date,
623: NULL, deprn_run_date,
624: X_Deprn_Run_Date),

Line 627: FND_API.G_MISS_NUM, null,

623: NULL, deprn_run_date,
624: X_Deprn_Run_Date),
625: deprn_amount = decode(X_Deprn_Amount,
626: NULL, deprn_amount,
627: FND_API.G_MISS_NUM, null,
628: X_Deprn_Amount),
629: ytd_deprn = decode(X_Ytd_Deprn,
630: NULL, ytd_deprn,
631: FND_API.G_MISS_NUM, null,

Line 631: FND_API.G_MISS_NUM, null,

627: FND_API.G_MISS_NUM, null,
628: X_Deprn_Amount),
629: ytd_deprn = decode(X_Ytd_Deprn,
630: NULL, ytd_deprn,
631: FND_API.G_MISS_NUM, null,
632: X_Ytd_Deprn),
633: deprn_reserve = decode(X_Deprn_Reserve,
634: NULL, deprn_reserve,
635: FND_API.G_MISS_NUM, null,

Line 635: FND_API.G_MISS_NUM, null,

631: FND_API.G_MISS_NUM, null,
632: X_Ytd_Deprn),
633: deprn_reserve = decode(X_Deprn_Reserve,
634: NULL, deprn_reserve,
635: FND_API.G_MISS_NUM, null,
636: X_Deprn_Reserve),
637: addition_cost_to_clear = decode(X_Addition_Cost_To_Clear,
638: NULL, addition_cost_to_clear,
639: FND_API.G_MISS_NUM, null,

Line 639: FND_API.G_MISS_NUM, null,

635: FND_API.G_MISS_NUM, null,
636: X_Deprn_Reserve),
637: addition_cost_to_clear = decode(X_Addition_Cost_To_Clear,
638: NULL, addition_cost_to_clear,
639: FND_API.G_MISS_NUM, null,
640: X_Addition_Cost_To_Clear),
641: cost = decode(X_Cost,
642: NULL, cost,
643: FND_API.G_MISS_NUM, null,

Line 643: FND_API.G_MISS_NUM, null,

639: FND_API.G_MISS_NUM, null,
640: X_Addition_Cost_To_Clear),
641: cost = decode(X_Cost,
642: NULL, cost,
643: FND_API.G_MISS_NUM, null,
644: X_Cost),
645: deprn_adjustment_amount = decode(X_Deprn_Adjustment_Amount,
646: NULL, deprn_adjustment_amount,
647: FND_API.G_MISS_NUM, null,

Line 647: FND_API.G_MISS_NUM, null,

643: FND_API.G_MISS_NUM, null,
644: X_Cost),
645: deprn_adjustment_amount = decode(X_Deprn_Adjustment_Amount,
646: NULL, deprn_adjustment_amount,
647: FND_API.G_MISS_NUM, null,
648: X_Deprn_Adjustment_Amount),
649: deprn_expense_je_line_num = decode(X_Deprn_Expense_Je_Line_Num,
650: NULL, deprn_expense_je_line_num,
651: FND_API.G_MISS_NUM, null,

Line 651: FND_API.G_MISS_NUM, null,

647: FND_API.G_MISS_NUM, null,
648: X_Deprn_Adjustment_Amount),
649: deprn_expense_je_line_num = decode(X_Deprn_Expense_Je_Line_Num,
650: NULL, deprn_expense_je_line_num,
651: FND_API.G_MISS_NUM, null,
652: X_Deprn_Expense_Je_Line_Num),
653: deprn_reserve_je_line_num = decode(X_Deprn_Reserve_Je_Line_Num,
654: NULL, deprn_reserve_je_line_num,
655: FND_API.G_MISS_NUM, null,

Line 655: FND_API.G_MISS_NUM, null,

651: FND_API.G_MISS_NUM, null,
652: X_Deprn_Expense_Je_Line_Num),
653: deprn_reserve_je_line_num = decode(X_Deprn_Reserve_Je_Line_Num,
654: NULL, deprn_reserve_je_line_num,
655: FND_API.G_MISS_NUM, null,
656: X_Deprn_Reserve_Je_Line_Num),
657: reval_amort_je_line_num = decode(X_Reval_Amort_Je_Line_Num,
658: NULL, reval_amort_je_line_num,
659: FND_API.G_MISS_NUM, null,

Line 659: FND_API.G_MISS_NUM, null,

655: FND_API.G_MISS_NUM, null,
656: X_Deprn_Reserve_Je_Line_Num),
657: reval_amort_je_line_num = decode(X_Reval_Amort_Je_Line_Num,
658: NULL, reval_amort_je_line_num,
659: FND_API.G_MISS_NUM, null,
660: X_Reval_Amort_Je_Line_Num),
661: reval_reserve_je_line_num = decode(X_Reval_Reserve_Je_Line_Num,
662: NULL, reval_reserve_je_line_num,
663: FND_API.G_MISS_NUM, null,

Line 663: FND_API.G_MISS_NUM, null,

659: FND_API.G_MISS_NUM, null,
660: X_Reval_Amort_Je_Line_Num),
661: reval_reserve_je_line_num = decode(X_Reval_Reserve_Je_Line_Num,
662: NULL, reval_reserve_je_line_num,
663: FND_API.G_MISS_NUM, null,
664: X_Reval_Reserve_Je_Line_Num),
665: je_header_id = decode(X_Je_Header_Id,
666: NULL, je_header_id,
667: FND_API.G_MISS_NUM, null,

Line 667: FND_API.G_MISS_NUM, null,

663: FND_API.G_MISS_NUM, null,
664: X_Reval_Reserve_Je_Line_Num),
665: je_header_id = decode(X_Je_Header_Id,
666: NULL, je_header_id,
667: FND_API.G_MISS_NUM, null,
668: X_Je_Header_Id),
669: reval_amortization = decode(X_Reval_Amortization,
670: NULL, reval_amortization,
671: FND_API.G_MISS_NUM, null,

Line 671: FND_API.G_MISS_NUM, null,

667: FND_API.G_MISS_NUM, null,
668: X_Je_Header_Id),
669: reval_amortization = decode(X_Reval_Amortization,
670: NULL, reval_amortization,
671: FND_API.G_MISS_NUM, null,
672: X_Reval_Amortization),
673: reval_deprn_expense = decode(X_Reval_Deprn_Expense,
674: NULL, reval_deprn_expense,
675: FND_API.G_MISS_NUM, null,

Line 675: FND_API.G_MISS_NUM, null,

671: FND_API.G_MISS_NUM, null,
672: X_Reval_Amortization),
673: reval_deprn_expense = decode(X_Reval_Deprn_Expense,
674: NULL, reval_deprn_expense,
675: FND_API.G_MISS_NUM, null,
676: X_Reval_Deprn_Expense),
677: reval_reserve = decode(X_Reval_Reserve,
678: NULL, reval_reserve,
679: FND_API.G_MISS_NUM, null,

Line 679: FND_API.G_MISS_NUM, null,

675: FND_API.G_MISS_NUM, null,
676: X_Reval_Deprn_Expense),
677: reval_reserve = decode(X_Reval_Reserve,
678: NULL, reval_reserve,
679: FND_API.G_MISS_NUM, null,
680: X_Reval_Reserve),
681: ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
682: NULL, ytd_reval_deprn_expense,
683: FND_API.G_MISS_NUM, null,

Line 683: FND_API.G_MISS_NUM, null,

679: FND_API.G_MISS_NUM, null,
680: X_Reval_Reserve),
681: ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
682: NULL, ytd_reval_deprn_expense,
683: FND_API.G_MISS_NUM, null,
684: X_Ytd_Reval_Deprn_Expense)
685: WHERE book_type_code = X_Book_Type_Code
686: and asset_id = X_Asset_Id
687: and period_counter = X_Period_Counter