DBA Data[Home] [Help]

APPS.FA_DEPRN_DETAIL_PKG dependencies on FND_API

Line 338: FND_API.G_MISS_CHAR, null,

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,

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

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

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

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

Line 361: FND_API.G_MISS_NUM, null,

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,

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 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

Line 426: FND_API.G_MISS_CHAR, null,

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,

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

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

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

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

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: addition_cost_to_clear = decode(X_Addition_Cost_To_Clear,
460: NULL, addition_cost_to_clear,
461: FND_API.G_MISS_NUM, null,

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

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

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

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

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

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

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

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

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

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

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

Line 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

Line 515: FND_API.G_MISS_CHAR, null,

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,

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

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

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

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

Line 538: FND_API.G_MISS_NUM, null,

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,

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 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

Line 609: FND_API.G_MISS_CHAR, null,

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,

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

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

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

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

Line 632: FND_API.G_MISS_NUM, null,

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,

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 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