DBA Data[Home] [Help]

APPS.FA_DEPRN_SUMMARY_PKG dependencies on FND_API

Line 308: FND_API.G_MISS_CHAR, null,

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,

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

Line 319: FND_API.G_MISS_NUM, null,

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,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 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

Line 397: FND_API.G_MISS_CHAR, null,

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,

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

Line 408: FND_API.G_MISS_NUM, null,

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,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 490: FND_API.G_MISS_CHAR, null,

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,

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

Line 501: FND_API.G_MISS_NUM, null,

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,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 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

Line 582: FND_API.G_MISS_CHAR, null,

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,

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

Line 593: FND_API.G_MISS_NUM, null,

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,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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