APPS.FA_DEPRN_SUMMARY_PKG dependencies on FND_API

Line 337: FND_API.G_MISS_CHAR, null,

333: UPDATE fa_mc_deprn_summary
334: SET
335: book_type_code = decode(X_Book_Type_Code,
336: NULL, book_type_code,
337: FND_API.G_MISS_CHAR, null,
338: X_Book_Type_Code),
339: asset_id = decode(X_Asset_Id,
340: NULL, asset_id,
341: FND_API.G_MISS_NUM, null,

Line 341: FND_API.G_MISS_NUM, null,

337: FND_API.G_MISS_CHAR, null,
338: X_Book_Type_Code),
339: asset_id = decode(X_Asset_Id,
340: NULL, asset_id,
341: FND_API.G_MISS_NUM, null,
342: X_Asset_Id),
343: deprn_run_date = decode(X_Deprn_Run_Date,
344: NULL, deprn_run_date,
345: X_Deprn_Run_Date),

Line 348: FND_API.G_MISS_NUM, null,

344: NULL, deprn_run_date,
345: X_Deprn_Run_Date),
346: deprn_amount = decode(X_Deprn_Amount,
347: NULL, deprn_amount,
348: FND_API.G_MISS_NUM, null,
349: X_Deprn_Amount),
350: ytd_deprn = decode(X_Ytd_Deprn,
351: NULL, ytd_deprn,
352: FND_API.G_MISS_NUM, null,

Line 352: FND_API.G_MISS_NUM, null,

348: FND_API.G_MISS_NUM, null,
349: X_Deprn_Amount),
350: ytd_deprn = decode(X_Ytd_Deprn,
351: NULL, ytd_deprn,
352: FND_API.G_MISS_NUM, null,
353: X_Ytd_Deprn),
354: deprn_reserve = decode(X_Deprn_Reserve,
355: NULL, deprn_reserve,
356: FND_API.G_MISS_NUM, null,

Line 356: FND_API.G_MISS_NUM, null,

352: FND_API.G_MISS_NUM, null,
353: X_Ytd_Deprn),
354: deprn_reserve = decode(X_Deprn_Reserve,
355: NULL, deprn_reserve,
356: FND_API.G_MISS_NUM, null,
357: X_Deprn_Reserve),
358: deprn_source_code = decode(X_Deprn_Source_Code,
359: NULL, deprn_source_code,
360: FND_API.G_MISS_CHAR, null,

Line 360: FND_API.G_MISS_CHAR, null,

356: FND_API.G_MISS_NUM, null,
357: X_Deprn_Reserve),
358: deprn_source_code = decode(X_Deprn_Source_Code,
359: NULL, deprn_source_code,
360: FND_API.G_MISS_CHAR, null,
361: X_Deprn_Source_Code),
362: adjusted_cost = decode(X_Adjusted_Cost,
363: NULL, adjusted_cost,
364: FND_API.G_MISS_NUM, null,

Line 364: FND_API.G_MISS_NUM, null,

360: FND_API.G_MISS_CHAR, null,
361: X_Deprn_Source_Code),
362: adjusted_cost = decode(X_Adjusted_Cost,
363: NULL, adjusted_cost,
364: FND_API.G_MISS_NUM, null,
365: X_Adjusted_Cost),
366: bonus_rate = decode(X_Bonus_Rate,
367: NULL, bonus_rate,
368: FND_API.G_MISS_NUM, null,

Line 368: FND_API.G_MISS_NUM, null,

364: FND_API.G_MISS_NUM, null,
365: X_Adjusted_Cost),
366: bonus_rate = decode(X_Bonus_Rate,
367: NULL, bonus_rate,
368: FND_API.G_MISS_NUM, null,
369: X_Bonus_Rate),
370: ltd_production = decode(X_Ltd_Production,
371: NULL, ltd_production,
372: FND_API.G_MISS_NUM, null,

Line 372: FND_API.G_MISS_NUM, null,

368: FND_API.G_MISS_NUM, null,
369: X_Bonus_Rate),
370: ltd_production = decode(X_Ltd_Production,
371: NULL, ltd_production,
372: FND_API.G_MISS_NUM, null,
373: X_Ltd_Production),
374: period_counter = decode(X_Period_Counter,
375: NULL, period_counter,
376: FND_API.G_MISS_NUM, null,

Line 376: FND_API.G_MISS_NUM, null,

372: FND_API.G_MISS_NUM, null,
373: X_Ltd_Production),
374: period_counter = decode(X_Period_Counter,
375: NULL, period_counter,
376: FND_API.G_MISS_NUM, null,
377: X_Period_Counter),
378: production = decode(X_Production,
379: NULL, production,
380: FND_API.G_MISS_NUM, null,

Line 380: FND_API.G_MISS_NUM, null,

376: FND_API.G_MISS_NUM, null,
377: X_Period_Counter),
378: production = decode(X_Production,
379: NULL, production,
380: FND_API.G_MISS_NUM, null,
381: X_Production),
382: reval_amortization = decode(X_Reval_Amortization,
383: NULL, reval_amortization,
384: FND_API.G_MISS_NUM, null,

Line 384: FND_API.G_MISS_NUM, null,

380: FND_API.G_MISS_NUM, null,
381: X_Production),
382: reval_amortization = decode(X_Reval_Amortization,
383: NULL, reval_amortization,
384: FND_API.G_MISS_NUM, null,
385: X_Reval_Amortization),
386: reval_amortization_basis = decode(X_Reval_Amortization_Basis,
387: NULL, reval_amortization_basis,
388: FND_API.G_MISS_NUM, null,

Line 388: FND_API.G_MISS_NUM, null,

384: FND_API.G_MISS_NUM, null,
385: X_Reval_Amortization),
386: reval_amortization_basis = decode(X_Reval_Amortization_Basis,
387: NULL, reval_amortization_basis,
388: FND_API.G_MISS_NUM, null,
389: X_Reval_Amortization_Basis),
390: reval_deprn_expense = decode(X_Reval_Deprn_Expense,
391: NULL, reval_deprn_expense,
392: FND_API.G_MISS_NUM, null,

Line 392: FND_API.G_MISS_NUM, null,

388: FND_API.G_MISS_NUM, null,
389: X_Reval_Amortization_Basis),
390: reval_deprn_expense = decode(X_Reval_Deprn_Expense,
391: NULL, reval_deprn_expense,
392: FND_API.G_MISS_NUM, null,
393: X_Reval_Deprn_Expense),
394: reval_reserve = decode(X_Reval_Reserve,
395: NULL, reval_reserve,
396: FND_API.G_MISS_NUM, null,

Line 396: FND_API.G_MISS_NUM, null,

392: FND_API.G_MISS_NUM, null,
393: X_Reval_Deprn_Expense),
394: reval_reserve = decode(X_Reval_Reserve,
395: NULL, reval_reserve,
396: FND_API.G_MISS_NUM, null,
397: X_Reval_Reserve),
398: ytd_production = decode(X_Ytd_Production,
399: NULL, ytd_production,
400: FND_API.G_MISS_NUM, null,

Line 400: FND_API.G_MISS_NUM, null,

396: FND_API.G_MISS_NUM, null,
397: X_Reval_Reserve),
398: ytd_production = decode(X_Ytd_Production,
399: NULL, ytd_production,
400: FND_API.G_MISS_NUM, null,
401: X_Ytd_Production),
402: ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
403: NULL, ytd_reval_deprn_expense,
404: FND_API.G_MISS_NUM, null,

Line 404: FND_API.G_MISS_NUM, null,

400: FND_API.G_MISS_NUM, null,
401: X_Ytd_Production),
402: ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
403: NULL, ytd_reval_deprn_expense,
404: FND_API.G_MISS_NUM, null,
405: X_Ytd_Reval_Deprn_Expense),
406: bonus_deprn_amount = decode(X_Bonus_Deprn_Amount,
407: NULL, bonus_deprn_amount,
408: FND_API.G_MISS_NUM, null,

Line 408: FND_API.G_MISS_NUM, null,

404: FND_API.G_MISS_NUM, null,
405: X_Ytd_Reval_Deprn_Expense),
406: bonus_deprn_amount = decode(X_Bonus_Deprn_Amount,
407: NULL, bonus_deprn_amount,
408: FND_API.G_MISS_NUM, null,
409: X_Bonus_Deprn_Amount),
410: bonus_ytd_deprn = decode(X_Bonus_Ytd_Deprn,
411: NULL, bonus_ytd_deprn,
412: FND_API.G_MISS_NUM, null,

Line 412: FND_API.G_MISS_NUM, null,

408: FND_API.G_MISS_NUM, null,
409: X_Bonus_Deprn_Amount),
410: bonus_ytd_deprn = decode(X_Bonus_Ytd_Deprn,
411: NULL, bonus_ytd_deprn,
412: FND_API.G_MISS_NUM, null,
413: X_Bonus_Ytd_Deprn),
414: bonus_deprn_reserve = decode(X_Bonus_Deprn_Reserve,
415: NULL, bonus_deprn_reserve,
416: FND_API.G_MISS_NUM, null,

Line 416: FND_API.G_MISS_NUM, null,

412: FND_API.G_MISS_NUM, null,
413: X_Bonus_Ytd_Deprn),
414: bonus_deprn_reserve = decode(X_Bonus_Deprn_Reserve,
415: NULL, bonus_deprn_reserve,
416: FND_API.G_MISS_NUM, null,
417: X_Bonus_Deprn_Reserve),
418: impairment_amount = decode(X_Impairment_Amount,
419: NULL, impairment_amount,
420: FND_API.G_MISS_NUM, null,

Line 420: FND_API.G_MISS_NUM, null,

416: FND_API.G_MISS_NUM, null,
417: X_Bonus_Deprn_Reserve),
418: impairment_amount = decode(X_Impairment_Amount,
419: NULL, impairment_amount,
420: FND_API.G_MISS_NUM, null,
421: X_Impairment_Amount),
422: ytd_impairment = decode(X_Ytd_Impairment,
423: NULL, ytd_impairment,
424: FND_API.G_MISS_NUM, null,

Line 424: FND_API.G_MISS_NUM, null,

420: FND_API.G_MISS_NUM, null,
421: X_Impairment_Amount),
422: ytd_impairment = decode(X_Ytd_Impairment,
423: NULL, ytd_impairment,
424: FND_API.G_MISS_NUM, null,
425: X_Ytd_Impairment),
426: impairment_reserve = decode(X_impairment_reserve,
427: NULL, impairment_reserve,
428: FND_API.G_MISS_NUM, null,

Line 428: FND_API.G_MISS_NUM, null,

424: FND_API.G_MISS_NUM, null,
425: X_Ytd_Impairment),
426: impairment_reserve = decode(X_impairment_reserve,
427: NULL, impairment_reserve,
428: FND_API.G_MISS_NUM, null,
429: X_impairment_reserve)
430: WHERE rowid = X_Rowid;
431:
432: else

Line 438: FND_API.G_MISS_CHAR, null,

434: UPDATE fa_deprn_summary
435: SET
436: book_type_code = decode(X_Book_Type_Code,
437: NULL, book_type_code,
438: FND_API.G_MISS_CHAR, null,
439: X_Book_Type_Code),
440: asset_id = decode(X_Asset_Id,
441: NULL, asset_id,
442: FND_API.G_MISS_NUM, null,

Line 442: FND_API.G_MISS_NUM, null,

438: FND_API.G_MISS_CHAR, null,
439: X_Book_Type_Code),
440: asset_id = decode(X_Asset_Id,
441: NULL, asset_id,
442: FND_API.G_MISS_NUM, null,
443: X_Asset_Id),
444: deprn_run_date = decode(X_Deprn_Run_Date,
445: NULL, deprn_run_date,
446: X_Deprn_Run_Date),

Line 449: FND_API.G_MISS_NUM, null,

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,

Line 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,

Line 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: deprn_source_code = decode(X_Deprn_Source_Code,
460: NULL, deprn_source_code,
461: FND_API.G_MISS_CHAR, null,

Line 461: FND_API.G_MISS_CHAR, null,

457: FND_API.G_MISS_NUM, null,
458: X_Deprn_Reserve),
459: deprn_source_code = decode(X_Deprn_Source_Code,
460: NULL, deprn_source_code,
461: FND_API.G_MISS_CHAR, null,
462: X_Deprn_Source_Code),
463: adjusted_cost = decode(X_Adjusted_Cost,
464: NULL, adjusted_cost,
465: FND_API.G_MISS_NUM, null,

Line 465: FND_API.G_MISS_NUM, null,

461: FND_API.G_MISS_CHAR, null,
462: X_Deprn_Source_Code),
463: adjusted_cost = decode(X_Adjusted_Cost,
464: NULL, adjusted_cost,
465: FND_API.G_MISS_NUM, null,
466: X_Adjusted_Cost),
467: bonus_rate = decode(X_Bonus_Rate,
468: NULL, bonus_rate,
469: FND_API.G_MISS_NUM, null,

Line 469: FND_API.G_MISS_NUM, null,

465: FND_API.G_MISS_NUM, null,
466: X_Adjusted_Cost),
467: bonus_rate = decode(X_Bonus_Rate,
468: NULL, bonus_rate,
469: FND_API.G_MISS_NUM, null,
470: X_Bonus_Rate),
471: ltd_production = decode(X_Ltd_Production,
472: NULL, ltd_production,
473: FND_API.G_MISS_NUM, null,

Line 473: FND_API.G_MISS_NUM, null,

469: FND_API.G_MISS_NUM, null,
470: X_Bonus_Rate),
471: ltd_production = decode(X_Ltd_Production,
472: NULL, ltd_production,
473: FND_API.G_MISS_NUM, null,
474: X_Ltd_Production),
475: period_counter = decode(X_Period_Counter,
476: NULL, period_counter,
477: FND_API.G_MISS_NUM, null,

Line 477: FND_API.G_MISS_NUM, null,

473: FND_API.G_MISS_NUM, null,
474: X_Ltd_Production),
475: period_counter = decode(X_Period_Counter,
476: NULL, period_counter,
477: FND_API.G_MISS_NUM, null,
478: X_Period_Counter),
479: production = decode(X_Production,
480: NULL, production,
481: FND_API.G_MISS_NUM, null,

Line 481: FND_API.G_MISS_NUM, null,

477: FND_API.G_MISS_NUM, null,
478: X_Period_Counter),
479: production = decode(X_Production,
480: NULL, production,
481: FND_API.G_MISS_NUM, null,
482: X_Production),
483: reval_amortization = decode(X_Reval_Amortization,
484: NULL, reval_amortization,
485: FND_API.G_MISS_NUM, null,

Line 485: FND_API.G_MISS_NUM, null,

481: FND_API.G_MISS_NUM, null,
482: X_Production),
483: reval_amortization = decode(X_Reval_Amortization,
484: NULL, reval_amortization,
485: FND_API.G_MISS_NUM, null,
486: X_Reval_Amortization),
487: reval_amortization_basis = decode(X_Reval_Amortization_Basis,
488: NULL, reval_amortization_basis,
489: FND_API.G_MISS_NUM, null,

Line 489: FND_API.G_MISS_NUM, null,

485: FND_API.G_MISS_NUM, null,
486: X_Reval_Amortization),
487: reval_amortization_basis = decode(X_Reval_Amortization_Basis,
488: NULL, reval_amortization_basis,
489: FND_API.G_MISS_NUM, null,
490: X_Reval_Amortization_Basis),
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_Basis),
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_production = decode(X_Ytd_Production,
500: NULL, ytd_production,
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_production = decode(X_Ytd_Production,
500: NULL, ytd_production,
501: FND_API.G_MISS_NUM, null,
502: X_Ytd_Production),
503: ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
504: NULL, ytd_reval_deprn_expense,
505: FND_API.G_MISS_NUM, null,

Line 505: FND_API.G_MISS_NUM, null,

501: FND_API.G_MISS_NUM, null,
502: X_Ytd_Production),
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: bonus_deprn_amount = decode(X_Bonus_Deprn_Amount,
508: NULL, bonus_deprn_amount,
509: FND_API.G_MISS_NUM, null,

Line 509: FND_API.G_MISS_NUM, null,

505: FND_API.G_MISS_NUM, null,
506: X_Ytd_Reval_Deprn_Expense),
507: bonus_deprn_amount = decode(X_Bonus_Deprn_Amount,
508: NULL, bonus_deprn_amount,
509: FND_API.G_MISS_NUM, null,
510: X_Bonus_Deprn_Amount),
511: bonus_ytd_deprn = decode(X_Bonus_Ytd_Deprn,
512: NULL, bonus_ytd_deprn,
513: FND_API.G_MISS_NUM, null,

Line 513: FND_API.G_MISS_NUM, null,

509: FND_API.G_MISS_NUM, null,
510: X_Bonus_Deprn_Amount),
511: bonus_ytd_deprn = decode(X_Bonus_Ytd_Deprn,
512: NULL, bonus_ytd_deprn,
513: FND_API.G_MISS_NUM, null,
514: X_Bonus_Ytd_Deprn),
515: bonus_deprn_reserve = decode(X_Bonus_Deprn_Reserve,
516: NULL, bonus_deprn_reserve,
517: FND_API.G_MISS_NUM, null,

Line 517: FND_API.G_MISS_NUM, null,

513: FND_API.G_MISS_NUM, null,
514: X_Bonus_Ytd_Deprn),
515: bonus_deprn_reserve = decode(X_Bonus_Deprn_Reserve,
516: NULL, bonus_deprn_reserve,
517: FND_API.G_MISS_NUM, null,
518: X_Bonus_Deprn_Reserve),
519: impairment_amount = decode(X_Impairment_Amount,
520: NULL, impairment_amount,
521: FND_API.G_MISS_NUM, null,

Line 521: FND_API.G_MISS_NUM, null,

517: FND_API.G_MISS_NUM, null,
518: X_Bonus_Deprn_Reserve),
519: impairment_amount = decode(X_Impairment_Amount,
520: NULL, impairment_amount,
521: FND_API.G_MISS_NUM, null,
522: X_Impairment_Amount),
523: ytd_impairment = decode(X_Ytd_Impairment,
524: NULL, ytd_impairment,
525: FND_API.G_MISS_NUM, null,

Line 525: FND_API.G_MISS_NUM, null,

521: FND_API.G_MISS_NUM, null,
522: X_Impairment_Amount),
523: ytd_impairment = decode(X_Ytd_Impairment,
524: NULL, ytd_impairment,
525: FND_API.G_MISS_NUM, null,
526: X_Ytd_Impairment),
527: impairment_reserve = decode(X_impairment_reserve,
528: NULL, impairment_reserve,
529: FND_API.G_MISS_NUM, null,

Line 529: FND_API.G_MISS_NUM, null,

525: FND_API.G_MISS_NUM, null,
526: X_Ytd_Impairment),
527: impairment_reserve = decode(X_impairment_reserve,
528: NULL, impairment_reserve,
529: FND_API.G_MISS_NUM, null,
530: X_impairment_reserve)
531: WHERE rowid = X_Rowid;
532:
533: end if; -- mrc

Line 542: FND_API.G_MISS_CHAR, null,

538: UPDATE fa_mc_deprn_summary
539: SET
540: book_type_code = decode(X_Book_Type_Code,
541: NULL, book_type_code,
542: FND_API.G_MISS_CHAR, null,
543: X_Book_Type_Code),
544: asset_id = decode(X_Asset_Id,
545: NULL, asset_id,
546: FND_API.G_MISS_NUM, null,

Line 546: FND_API.G_MISS_NUM, null,

542: FND_API.G_MISS_CHAR, null,
543: X_Book_Type_Code),
544: asset_id = decode(X_Asset_Id,
545: NULL, asset_id,
546: FND_API.G_MISS_NUM, null,
547: X_Asset_Id),
548: deprn_run_date = decode(X_Deprn_Run_Date,
549: NULL, deprn_run_date,
550: X_Deprn_Run_Date),

Line 553: FND_API.G_MISS_NUM, null,

549: NULL, deprn_run_date,
550: X_Deprn_Run_Date),
551: deprn_amount = decode(X_Deprn_Amount,
552: NULL, deprn_amount,
553: FND_API.G_MISS_NUM, null,
554: X_Deprn_Amount),
555: ytd_deprn = decode(X_Ytd_Deprn,
556: NULL, ytd_deprn,
557: FND_API.G_MISS_NUM, null,

Line 557: FND_API.G_MISS_NUM, null,

553: FND_API.G_MISS_NUM, null,
554: X_Deprn_Amount),
555: ytd_deprn = decode(X_Ytd_Deprn,
556: NULL, ytd_deprn,
557: FND_API.G_MISS_NUM, null,
558: X_Ytd_Deprn),
559: deprn_reserve = decode(X_Deprn_Reserve,
560: NULL, deprn_reserve,
561: FND_API.G_MISS_NUM, null,

Line 561: FND_API.G_MISS_NUM, null,

557: FND_API.G_MISS_NUM, null,
558: X_Ytd_Deprn),
559: deprn_reserve = decode(X_Deprn_Reserve,
560: NULL, deprn_reserve,
561: FND_API.G_MISS_NUM, null,
562: X_Deprn_Reserve),
563: deprn_source_code = decode(X_Deprn_Source_Code,
564: NULL, deprn_source_code,
565: FND_API.G_MISS_CHAR, null,

Line 565: FND_API.G_MISS_CHAR, null,

561: FND_API.G_MISS_NUM, null,
562: X_Deprn_Reserve),
563: deprn_source_code = decode(X_Deprn_Source_Code,
564: NULL, deprn_source_code,
565: FND_API.G_MISS_CHAR, null,
566: X_Deprn_Source_Code),
567: adjusted_cost = decode(X_Adjusted_Cost,
568: NULL, adjusted_cost,
569: FND_API.G_MISS_NUM, null,

Line 569: FND_API.G_MISS_NUM, null,

565: FND_API.G_MISS_CHAR, null,
566: X_Deprn_Source_Code),
567: adjusted_cost = decode(X_Adjusted_Cost,
568: NULL, adjusted_cost,
569: FND_API.G_MISS_NUM, null,
570: X_Adjusted_Cost),
571: bonus_rate = decode(X_Bonus_Rate,
572: NULL, bonus_rate,
573: FND_API.G_MISS_NUM, null,

Line 573: FND_API.G_MISS_NUM, null,

569: FND_API.G_MISS_NUM, null,
570: X_Adjusted_Cost),
571: bonus_rate = decode(X_Bonus_Rate,
572: NULL, bonus_rate,
573: FND_API.G_MISS_NUM, null,
574: X_Bonus_Rate),
575: ltd_production = decode(X_Ltd_Production,
576: NULL, ltd_production,
577: FND_API.G_MISS_NUM, null,

Line 577: FND_API.G_MISS_NUM, null,

573: FND_API.G_MISS_NUM, null,
574: X_Bonus_Rate),
575: ltd_production = decode(X_Ltd_Production,
576: NULL, ltd_production,
577: FND_API.G_MISS_NUM, null,
578: X_Ltd_Production),
579: period_counter = decode(X_Period_Counter,
580: NULL, period_counter,
581: FND_API.G_MISS_NUM, null,

Line 581: FND_API.G_MISS_NUM, null,

577: FND_API.G_MISS_NUM, null,
578: X_Ltd_Production),
579: period_counter = decode(X_Period_Counter,
580: NULL, period_counter,
581: FND_API.G_MISS_NUM, null,
582: X_Period_Counter),
583: production = decode(X_Production,
584: NULL, production,
585: FND_API.G_MISS_NUM, null,

Line 585: FND_API.G_MISS_NUM, null,

581: FND_API.G_MISS_NUM, null,
582: X_Period_Counter),
583: production = decode(X_Production,
584: NULL, production,
585: FND_API.G_MISS_NUM, null,
586: X_Production),
587: reval_amortization = decode(X_Reval_Amortization,
588: NULL, reval_amortization,
589: FND_API.G_MISS_NUM, null,

Line 589: FND_API.G_MISS_NUM, null,

585: FND_API.G_MISS_NUM, null,
586: X_Production),
587: reval_amortization = decode(X_Reval_Amortization,
588: NULL, reval_amortization,
589: FND_API.G_MISS_NUM, null,
590: X_Reval_Amortization),
591: reval_amortization_basis = decode(X_Reval_Amortization_Basis,
592: NULL, reval_amortization_basis,
593: FND_API.G_MISS_NUM, null,

Line 593: FND_API.G_MISS_NUM, null,

589: FND_API.G_MISS_NUM, null,
590: X_Reval_Amortization),
591: reval_amortization_basis = decode(X_Reval_Amortization_Basis,
592: NULL, reval_amortization_basis,
593: FND_API.G_MISS_NUM, null,
594: X_Reval_Amortization_Basis),
595: reval_deprn_expense = decode(X_Reval_Deprn_Expense,
596: NULL, reval_deprn_expense,
597: FND_API.G_MISS_NUM, null,

Line 597: FND_API.G_MISS_NUM, null,

593: FND_API.G_MISS_NUM, null,
594: X_Reval_Amortization_Basis),
595: reval_deprn_expense = decode(X_Reval_Deprn_Expense,
596: NULL, reval_deprn_expense,
597: FND_API.G_MISS_NUM, null,
598: X_Reval_Deprn_Expense),
599: reval_reserve = decode(X_Reval_Reserve,
600: NULL, reval_reserve,
601: FND_API.G_MISS_NUM, null,

Line 601: FND_API.G_MISS_NUM, null,

597: FND_API.G_MISS_NUM, null,
598: X_Reval_Deprn_Expense),
599: reval_reserve = decode(X_Reval_Reserve,
600: NULL, reval_reserve,
601: FND_API.G_MISS_NUM, null,
602: X_Reval_Reserve),
603: ytd_production = decode(X_Ytd_Production,
604: NULL, ytd_production,
605: FND_API.G_MISS_NUM, null,

Line 605: FND_API.G_MISS_NUM, null,

601: FND_API.G_MISS_NUM, null,
602: X_Reval_Reserve),
603: ytd_production = decode(X_Ytd_Production,
604: NULL, ytd_production,
605: FND_API.G_MISS_NUM, null,
606: X_Ytd_Production),
607: ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
608: NULL, ytd_reval_deprn_expense,
609: FND_API.G_MISS_NUM, null,

Line 609: FND_API.G_MISS_NUM, null,

605: FND_API.G_MISS_NUM, null,
606: X_Ytd_Production),
607: ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
608: NULL, ytd_reval_deprn_expense,
609: FND_API.G_MISS_NUM, null,
610: X_Ytd_Reval_Deprn_Expense),
611: bonus_deprn_amount = decode(X_Bonus_Deprn_Amount,
612: NULL, bonus_deprn_amount,
613: FND_API.G_MISS_NUM, null,

Line 613: FND_API.G_MISS_NUM, null,

609: FND_API.G_MISS_NUM, null,
610: X_Ytd_Reval_Deprn_Expense),
611: bonus_deprn_amount = decode(X_Bonus_Deprn_Amount,
612: NULL, bonus_deprn_amount,
613: FND_API.G_MISS_NUM, null,
614: X_Bonus_Deprn_Amount),
615: bonus_ytd_deprn = decode(X_Bonus_Ytd_Deprn,
616: NULL, bonus_ytd_deprn,
617: FND_API.G_MISS_NUM, null,

Line 617: FND_API.G_MISS_NUM, null,

613: FND_API.G_MISS_NUM, null,
614: X_Bonus_Deprn_Amount),
615: bonus_ytd_deprn = decode(X_Bonus_Ytd_Deprn,
616: NULL, bonus_ytd_deprn,
617: FND_API.G_MISS_NUM, null,
618: X_Bonus_Ytd_Deprn),
619: bonus_deprn_reserve = decode(X_Bonus_Deprn_Reserve,
620: NULL, bonus_deprn_reserve,
621: FND_API.G_MISS_NUM, null,

Line 621: FND_API.G_MISS_NUM, null,

617: FND_API.G_MISS_NUM, null,
618: X_Bonus_Ytd_Deprn),
619: bonus_deprn_reserve = decode(X_Bonus_Deprn_Reserve,
620: NULL, bonus_deprn_reserve,
621: FND_API.G_MISS_NUM, null,
622: X_Bonus_Deprn_Reserve),
623: impairment_amount = decode(X_Impairment_Amount,
624: NULL, impairment_amount,
625: FND_API.G_MISS_NUM, null,

Line 625: FND_API.G_MISS_NUM, null,

621: FND_API.G_MISS_NUM, null,
622: X_Bonus_Deprn_Reserve),
623: impairment_amount = decode(X_Impairment_Amount,
624: NULL, impairment_amount,
625: FND_API.G_MISS_NUM, null,
626: X_Impairment_Amount),
627: ytd_impairment = decode(X_Ytd_Impairment,
628: NULL, ytd_impairment,
629: FND_API.G_MISS_NUM, null,

Line 629: FND_API.G_MISS_NUM, null,

625: FND_API.G_MISS_NUM, null,
626: X_Impairment_Amount),
627: ytd_impairment = decode(X_Ytd_Impairment,
628: NULL, ytd_impairment,
629: FND_API.G_MISS_NUM, null,
630: X_Ytd_Impairment),
631: impairment_reserve = decode(X_impairment_reserve,
632: NULL, impairment_reserve,
633: FND_API.G_MISS_NUM, null,

Line 633: FND_API.G_MISS_NUM, null,

629: FND_API.G_MISS_NUM, null,
630: X_Ytd_Impairment),
631: impairment_reserve = decode(X_impairment_reserve,
632: NULL, impairment_reserve,
633: FND_API.G_MISS_NUM, null,
634: X_impairment_reserve)
635: WHERE book_type_code = X_Book_Type_Code
636: and asset_id = X_Asset_Id
637: and period_counter = X_Period_Counter

Line 646: FND_API.G_MISS_CHAR, null,

642: UPDATE fa_deprn_summary
643: SET
644: book_type_code = decode(X_Book_Type_Code,
645: NULL, book_type_code,
646: FND_API.G_MISS_CHAR, null,
647: X_Book_Type_Code),
648: asset_id = decode(X_Asset_Id,
649: NULL, asset_id,
650: FND_API.G_MISS_NUM, null,

Line 650: FND_API.G_MISS_NUM, null,

646: FND_API.G_MISS_CHAR, null,
647: X_Book_Type_Code),
648: asset_id = decode(X_Asset_Id,
649: NULL, asset_id,
650: FND_API.G_MISS_NUM, null,
651: X_Asset_Id),
652: deprn_run_date = decode(X_Deprn_Run_Date,
653: NULL, deprn_run_date,
654: X_Deprn_Run_Date),

Line 657: FND_API.G_MISS_NUM, null,

653: NULL, deprn_run_date,
654: X_Deprn_Run_Date),
655: deprn_amount = decode(X_Deprn_Amount,
656: NULL, deprn_amount,
657: FND_API.G_MISS_NUM, null,
658: X_Deprn_Amount),
659: ytd_deprn = decode(X_Ytd_Deprn,
660: NULL, ytd_deprn,
661: FND_API.G_MISS_NUM, null,

Line 661: FND_API.G_MISS_NUM, null,

657: FND_API.G_MISS_NUM, null,
658: X_Deprn_Amount),
659: ytd_deprn = decode(X_Ytd_Deprn,
660: NULL, ytd_deprn,
661: FND_API.G_MISS_NUM, null,
662: X_Ytd_Deprn),
663: deprn_reserve = decode(X_Deprn_Reserve,
664: NULL, deprn_reserve,
665: FND_API.G_MISS_NUM, null,

Line 665: FND_API.G_MISS_NUM, null,

661: FND_API.G_MISS_NUM, null,
662: X_Ytd_Deprn),
663: deprn_reserve = decode(X_Deprn_Reserve,
664: NULL, deprn_reserve,
665: FND_API.G_MISS_NUM, null,
666: X_Deprn_Reserve),
667: deprn_source_code = decode(X_Deprn_Source_Code,
668: NULL, deprn_source_code,
669: FND_API.G_MISS_CHAR, null,

Line 669: FND_API.G_MISS_CHAR, null,

665: FND_API.G_MISS_NUM, null,
666: X_Deprn_Reserve),
667: deprn_source_code = decode(X_Deprn_Source_Code,
668: NULL, deprn_source_code,
669: FND_API.G_MISS_CHAR, null,
670: X_Deprn_Source_Code),
671: adjusted_cost = decode(X_Adjusted_Cost,
672: NULL, adjusted_cost,
673: FND_API.G_MISS_NUM, null,

Line 673: FND_API.G_MISS_NUM, null,

669: FND_API.G_MISS_CHAR, null,
670: X_Deprn_Source_Code),
671: adjusted_cost = decode(X_Adjusted_Cost,
672: NULL, adjusted_cost,
673: FND_API.G_MISS_NUM, null,
674: X_Adjusted_Cost),
675: bonus_rate = decode(X_Bonus_Rate,
676: NULL, bonus_rate,
677: FND_API.G_MISS_NUM, null,

Line 677: FND_API.G_MISS_NUM, null,

673: FND_API.G_MISS_NUM, null,
674: X_Adjusted_Cost),
675: bonus_rate = decode(X_Bonus_Rate,
676: NULL, bonus_rate,
677: FND_API.G_MISS_NUM, null,
678: X_Bonus_Rate),
679: ltd_production = decode(X_Ltd_Production,
680: NULL, ltd_production,
681: FND_API.G_MISS_NUM, null,

Line 681: FND_API.G_MISS_NUM, null,

677: FND_API.G_MISS_NUM, null,
678: X_Bonus_Rate),
679: ltd_production = decode(X_Ltd_Production,
680: NULL, ltd_production,
681: FND_API.G_MISS_NUM, null,
682: X_Ltd_Production),
683: period_counter = decode(X_Period_Counter,
684: NULL, period_counter,
685: FND_API.G_MISS_NUM, null,

Line 685: FND_API.G_MISS_NUM, null,

681: FND_API.G_MISS_NUM, null,
682: X_Ltd_Production),
683: period_counter = decode(X_Period_Counter,
684: NULL, period_counter,
685: FND_API.G_MISS_NUM, null,
686: X_Period_Counter),
687: production = decode(X_Production,
688: NULL, production,
689: FND_API.G_MISS_NUM, null,

Line 689: FND_API.G_MISS_NUM, null,

685: FND_API.G_MISS_NUM, null,
686: X_Period_Counter),
687: production = decode(X_Production,
688: NULL, production,
689: FND_API.G_MISS_NUM, null,
690: X_Production),
691: reval_amortization = decode(X_Reval_Amortization,
692: NULL, reval_amortization,
693: FND_API.G_MISS_NUM, null,

Line 693: FND_API.G_MISS_NUM, null,

689: FND_API.G_MISS_NUM, null,
690: X_Production),
691: reval_amortization = decode(X_Reval_Amortization,
692: NULL, reval_amortization,
693: FND_API.G_MISS_NUM, null,
694: X_Reval_Amortization),
695: reval_amortization_basis = decode(X_Reval_Amortization_Basis,
696: NULL, reval_amortization_basis,
697: FND_API.G_MISS_NUM, null,

Line 697: FND_API.G_MISS_NUM, null,

693: FND_API.G_MISS_NUM, null,
694: X_Reval_Amortization),
695: reval_amortization_basis = decode(X_Reval_Amortization_Basis,
696: NULL, reval_amortization_basis,
697: FND_API.G_MISS_NUM, null,
698: X_Reval_Amortization_Basis),
699: reval_deprn_expense = decode(X_Reval_Deprn_Expense,
700: NULL, reval_deprn_expense,
701: FND_API.G_MISS_NUM, null,

Line 701: FND_API.G_MISS_NUM, null,

697: FND_API.G_MISS_NUM, null,
698: X_Reval_Amortization_Basis),
699: reval_deprn_expense = decode(X_Reval_Deprn_Expense,
700: NULL, reval_deprn_expense,
701: FND_API.G_MISS_NUM, null,
702: X_Reval_Deprn_Expense),
703: reval_reserve = decode(X_Reval_Reserve,
704: NULL, reval_reserve,
705: FND_API.G_MISS_NUM, null,

Line 705: FND_API.G_MISS_NUM, null,

701: FND_API.G_MISS_NUM, null,
702: X_Reval_Deprn_Expense),
703: reval_reserve = decode(X_Reval_Reserve,
704: NULL, reval_reserve,
705: FND_API.G_MISS_NUM, null,
706: X_Reval_Reserve),
707: ytd_production = decode(X_Ytd_Production,
708: NULL, ytd_production,
709: FND_API.G_MISS_NUM, null,

Line 709: FND_API.G_MISS_NUM, null,

705: FND_API.G_MISS_NUM, null,
706: X_Reval_Reserve),
707: ytd_production = decode(X_Ytd_Production,
708: NULL, ytd_production,
709: FND_API.G_MISS_NUM, null,
710: X_Ytd_Production),
711: ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
712: NULL, ytd_reval_deprn_expense,
713: FND_API.G_MISS_NUM, null,

Line 713: FND_API.G_MISS_NUM, null,

709: FND_API.G_MISS_NUM, null,
710: X_Ytd_Production),
711: ytd_reval_deprn_expense = decode(X_Ytd_Reval_Deprn_Expense,
712: NULL, ytd_reval_deprn_expense,
713: FND_API.G_MISS_NUM, null,
714: X_Ytd_Reval_Deprn_Expense),
715: bonus_deprn_amount = decode(X_Bonus_Deprn_Amount,
716: NULL, bonus_deprn_amount,
717: FND_API.G_MISS_NUM, null,

Line 717: FND_API.G_MISS_NUM, null,

713: FND_API.G_MISS_NUM, null,
714: X_Ytd_Reval_Deprn_Expense),
715: bonus_deprn_amount = decode(X_Bonus_Deprn_Amount,
716: NULL, bonus_deprn_amount,
717: FND_API.G_MISS_NUM, null,
718: X_Bonus_Deprn_Amount),
719: bonus_ytd_deprn = decode(X_Bonus_Ytd_Deprn,
720: NULL, bonus_ytd_deprn,
721: FND_API.G_MISS_NUM, null,

Line 721: FND_API.G_MISS_NUM, null,

717: FND_API.G_MISS_NUM, null,
718: X_Bonus_Deprn_Amount),
719: bonus_ytd_deprn = decode(X_Bonus_Ytd_Deprn,
720: NULL, bonus_ytd_deprn,
721: FND_API.G_MISS_NUM, null,
722: X_Bonus_Ytd_Deprn),
723: bonus_deprn_reserve = decode(X_Bonus_Deprn_Reserve,
724: NULL, bonus_deprn_reserve,
725: FND_API.G_MISS_NUM, null,

Line 725: FND_API.G_MISS_NUM, null,

721: FND_API.G_MISS_NUM, null,
722: X_Bonus_Ytd_Deprn),
723: bonus_deprn_reserve = decode(X_Bonus_Deprn_Reserve,
724: NULL, bonus_deprn_reserve,
725: FND_API.G_MISS_NUM, null,
726: X_Bonus_Deprn_Reserve),
727: impairment_amount = decode(X_Impairment_Amount,
728: NULL, impairment_amount,
729: FND_API.G_MISS_NUM, null,

Line 729: FND_API.G_MISS_NUM, null,

725: FND_API.G_MISS_NUM, null,
726: X_Bonus_Deprn_Reserve),
727: impairment_amount = decode(X_Impairment_Amount,
728: NULL, impairment_amount,
729: FND_API.G_MISS_NUM, null,
730: X_Impairment_Amount),
731: ytd_impairment = decode(X_Ytd_Impairment,
732: NULL, ytd_impairment,
733: FND_API.G_MISS_NUM, null,

Line 733: FND_API.G_MISS_NUM, null,

729: FND_API.G_MISS_NUM, null,
730: X_Impairment_Amount),
731: ytd_impairment = decode(X_Ytd_Impairment,
732: NULL, ytd_impairment,
733: FND_API.G_MISS_NUM, null,
734: X_Ytd_Impairment),
735: impairment_reserve = decode(X_impairment_reserve,
736: NULL, impairment_reserve,
737: FND_API.G_MISS_NUM, null,

Line 737: FND_API.G_MISS_NUM, null,

733: FND_API.G_MISS_NUM, null,
734: X_Ytd_Impairment),
735: impairment_reserve = decode(X_impairment_reserve,
736: NULL, impairment_reserve,
737: FND_API.G_MISS_NUM, null,
738: X_impairment_reserve)
739: WHERE book_type_code = X_Book_Type_Code
740: and asset_id = X_Asset_Id
741: and period_counter = X_Period_Counter;