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_MASS_DEPRN_BASIS_PKG dependencies on FA_STD_TYPES

Line 116: FA_STD_TYPES.FAD_DBR_POLISH_1,

112: nvl(drd.period_update_flag, 'N'),
113: nvl(drd.use_eofy_reserve_flag, 'N'), -- Bug4940246
114: decode (drd.rule_name,
115: 'POLISH 30% WITH A SWITCH TO DECLINING CLASSICAL AND FLAT RATE',
116: FA_STD_TYPES.FAD_DBR_POLISH_1,
117: 'POLISH 30% WITH A SWITCH TO FLAT RATE',
118: FA_STD_TYPES.FAD_DBR_POLISH_2,
119: 'POLISH DECLINING MODIFIED WITH A SWITCH TO DECLINING CLASSICAL AND FLAT RATE',
120: FA_STD_TYPES.FAD_DBR_POLISH_3,

Line 118: FA_STD_TYPES.FAD_DBR_POLISH_2,

114: decode (drd.rule_name,
115: 'POLISH 30% WITH A SWITCH TO DECLINING CLASSICAL AND FLAT RATE',
116: FA_STD_TYPES.FAD_DBR_POLISH_1,
117: 'POLISH 30% WITH A SWITCH TO FLAT RATE',
118: FA_STD_TYPES.FAD_DBR_POLISH_2,
119: 'POLISH DECLINING MODIFIED WITH A SWITCH TO DECLINING CLASSICAL AND FLAT RATE',
120: FA_STD_TYPES.FAD_DBR_POLISH_3,
121: 'POLISH DECLINING MODIFIED WITH A SWITCH TO FLAT RATE',
122: FA_STD_TYPES.FAD_DBR_POLISH_4,

Line 120: FA_STD_TYPES.FAD_DBR_POLISH_3,

116: FA_STD_TYPES.FAD_DBR_POLISH_1,
117: 'POLISH 30% WITH A SWITCH TO FLAT RATE',
118: FA_STD_TYPES.FAD_DBR_POLISH_2,
119: 'POLISH DECLINING MODIFIED WITH A SWITCH TO DECLINING CLASSICAL AND FLAT RATE',
120: FA_STD_TYPES.FAD_DBR_POLISH_3,
121: 'POLISH DECLINING MODIFIED WITH A SWITCH TO FLAT RATE',
122: FA_STD_TYPES.FAD_DBR_POLISH_4,
123: 'POLISH STANDARD DECLINING WITH A SWITCH TO FLAT RATE',
124: FA_STD_TYPES.FAD_DBR_POLISH_5,

Line 122: FA_STD_TYPES.FAD_DBR_POLISH_4,

118: FA_STD_TYPES.FAD_DBR_POLISH_2,
119: 'POLISH DECLINING MODIFIED WITH A SWITCH TO DECLINING CLASSICAL AND FLAT RATE',
120: FA_STD_TYPES.FAD_DBR_POLISH_3,
121: 'POLISH DECLINING MODIFIED WITH A SWITCH TO FLAT RATE',
122: FA_STD_TYPES.FAD_DBR_POLISH_4,
123: 'POLISH STANDARD DECLINING WITH A SWITCH TO FLAT RATE',
124: FA_STD_TYPES.FAD_DBR_POLISH_5,
125: FA_STD_TYPES.FAD_DBR_POLISH_NONE)
126: , nvl(mt.guarantee_rate_method_flag, 'NO') -- Bug 6665510: FP: Japan Tax Reform Project

Line 124: FA_STD_TYPES.FAD_DBR_POLISH_5,

120: FA_STD_TYPES.FAD_DBR_POLISH_3,
121: 'POLISH DECLINING MODIFIED WITH A SWITCH TO FLAT RATE',
122: FA_STD_TYPES.FAD_DBR_POLISH_4,
123: 'POLISH STANDARD DECLINING WITH A SWITCH TO FLAT RATE',
124: FA_STD_TYPES.FAD_DBR_POLISH_5,
125: FA_STD_TYPES.FAD_DBR_POLISH_NONE)
126: , nvl(mt.guarantee_rate_method_flag, 'NO') -- Bug 6665510: FP: Japan Tax Reform Project
127: from fa_deprn_summary ds,
128: fa_books bks,

Line 125: FA_STD_TYPES.FAD_DBR_POLISH_NONE)

121: 'POLISH DECLINING MODIFIED WITH A SWITCH TO FLAT RATE',
122: FA_STD_TYPES.FAD_DBR_POLISH_4,
123: 'POLISH STANDARD DECLINING WITH A SWITCH TO FLAT RATE',
124: FA_STD_TYPES.FAD_DBR_POLISH_5,
125: FA_STD_TYPES.FAD_DBR_POLISH_NONE)
126: , nvl(mt.guarantee_rate_method_flag, 'NO') -- Bug 6665510: FP: Japan Tax Reform Project
127: from fa_deprn_summary ds,
128: fa_books bks,
129: fa_methods mt,

Line 179: FA_STD_TYPES.FAD_DBR_POLISH_1,

175: nvl(drd.period_update_flag, 'N'),
176: nvl(drd.use_eofy_reserve_flag, 'N'), -- Bug4940246
177: decode (drd.rule_name,
178: 'POLISH 30% WITH A SWITCH TO DECLINING CLASSICAL AND FLAT RATE',
179: FA_STD_TYPES.FAD_DBR_POLISH_1,
180: 'POLISH 30% WITH A SWITCH TO FLAT RATE',
181: FA_STD_TYPES.FAD_DBR_POLISH_2,
182: 'POLISH DECLINING MODIFIED WITH A SWITCH TO DECLINING CLASSICAL AND FLAT RATE',
183: FA_STD_TYPES.FAD_DBR_POLISH_3,

Line 181: FA_STD_TYPES.FAD_DBR_POLISH_2,

177: decode (drd.rule_name,
178: 'POLISH 30% WITH A SWITCH TO DECLINING CLASSICAL AND FLAT RATE',
179: FA_STD_TYPES.FAD_DBR_POLISH_1,
180: 'POLISH 30% WITH A SWITCH TO FLAT RATE',
181: FA_STD_TYPES.FAD_DBR_POLISH_2,
182: 'POLISH DECLINING MODIFIED WITH A SWITCH TO DECLINING CLASSICAL AND FLAT RATE',
183: FA_STD_TYPES.FAD_DBR_POLISH_3,
184: 'POLISH DECLINING MODIFIED WITH A SWITCH TO FLAT RATE',
185: FA_STD_TYPES.FAD_DBR_POLISH_4,

Line 183: FA_STD_TYPES.FAD_DBR_POLISH_3,

179: FA_STD_TYPES.FAD_DBR_POLISH_1,
180: 'POLISH 30% WITH A SWITCH TO FLAT RATE',
181: FA_STD_TYPES.FAD_DBR_POLISH_2,
182: 'POLISH DECLINING MODIFIED WITH A SWITCH TO DECLINING CLASSICAL AND FLAT RATE',
183: FA_STD_TYPES.FAD_DBR_POLISH_3,
184: 'POLISH DECLINING MODIFIED WITH A SWITCH TO FLAT RATE',
185: FA_STD_TYPES.FAD_DBR_POLISH_4,
186: 'POLISH STANDARD DECLINING WITH A SWITCH TO FLAT RATE',
187: FA_STD_TYPES.FAD_DBR_POLISH_5,

Line 185: FA_STD_TYPES.FAD_DBR_POLISH_4,

181: FA_STD_TYPES.FAD_DBR_POLISH_2,
182: 'POLISH DECLINING MODIFIED WITH A SWITCH TO DECLINING CLASSICAL AND FLAT RATE',
183: FA_STD_TYPES.FAD_DBR_POLISH_3,
184: 'POLISH DECLINING MODIFIED WITH A SWITCH TO FLAT RATE',
185: FA_STD_TYPES.FAD_DBR_POLISH_4,
186: 'POLISH STANDARD DECLINING WITH A SWITCH TO FLAT RATE',
187: FA_STD_TYPES.FAD_DBR_POLISH_5,
188: FA_STD_TYPES.FAD_DBR_POLISH_NONE)
189: , nvl(mt.guarantee_rate_method_flag, 'NO') -- Bug 6665510: FP: Japan Tax Reform Project

Line 187: FA_STD_TYPES.FAD_DBR_POLISH_5,

183: FA_STD_TYPES.FAD_DBR_POLISH_3,
184: 'POLISH DECLINING MODIFIED WITH A SWITCH TO FLAT RATE',
185: FA_STD_TYPES.FAD_DBR_POLISH_4,
186: 'POLISH STANDARD DECLINING WITH A SWITCH TO FLAT RATE',
187: FA_STD_TYPES.FAD_DBR_POLISH_5,
188: FA_STD_TYPES.FAD_DBR_POLISH_NONE)
189: , nvl(mt.guarantee_rate_method_flag, 'NO') -- Bug 6665510: FP: Japan Tax Reform Project
190: from fa_deprn_summary_mrc_v ds,
191: fa_books_mrc_v bks,

Line 188: FA_STD_TYPES.FAD_DBR_POLISH_NONE)

184: 'POLISH DECLINING MODIFIED WITH A SWITCH TO FLAT RATE',
185: FA_STD_TYPES.FAD_DBR_POLISH_4,
186: 'POLISH STANDARD DECLINING WITH A SWITCH TO FLAT RATE',
187: FA_STD_TYPES.FAD_DBR_POLISH_5,
188: FA_STD_TYPES.FAD_DBR_POLISH_NONE)
189: , nvl(mt.guarantee_rate_method_flag, 'NO') -- Bug 6665510: FP: Japan Tax Reform Project
190: from fa_deprn_summary_mrc_v ds,
191: fa_books_mrc_v bks,
192: fa_methods mt,

Line 480: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

476:
477: forall i IN 1..l_asset_id_tbl.count
478: update fa_books_mrc_v
479: set adjusted_cost = decode (l_polish_rule_tbl(i),
480: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
481: nvl(l_new_adjusted_cost_tbl(i), 0),
482: l_old_adjusted_cost_tbl(i)),
483: formula_factor = decode (l_polish_rule_tbl(i),
484: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 484: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

480: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
481: nvl(l_new_adjusted_cost_tbl(i), 0),
482: l_old_adjusted_cost_tbl(i)),
483: formula_factor = decode (l_polish_rule_tbl(i),
484: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
485: nvl(l_new_formula_factor_tbl(i), 1),
486: l_old_formula_factor_tbl(i)),
487: eofy_adj_cost = decode (l_polish_rule_tbl(i),
488: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 488: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

484: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
485: nvl(l_new_formula_factor_tbl(i), 1),
486: l_old_formula_factor_tbl(i)),
487: eofy_adj_cost = decode (l_polish_rule_tbl(i),
488: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
489: l_old_adjusted_cost_tbl(i),
490: eofy_adj_cost),
491: eofy_formula_factor = decode (l_polish_rule_tbl(i),
492: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 492: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

488: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
489: l_old_adjusted_cost_tbl(i),
490: eofy_adj_cost),
491: eofy_formula_factor = decode (l_polish_rule_tbl(i),
492: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
493: l_new_formula_factor_tbl(i),
494: eofy_formula_factor),
495: eofy_reserve = decode (l_polish_rule_tbl(i),
496: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 496: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

492: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
493: l_new_formula_factor_tbl(i),
494: eofy_formula_factor),
495: eofy_reserve = decode (l_polish_rule_tbl(i),
496: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
497: nvl(l_current_total_rsv_tbl(i), 0),
498: eofy_reserve),
499: prior_eofy_reserve = decode (l_polish_rule_tbl(i),
500: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 500: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

496: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
497: nvl(l_current_total_rsv_tbl(i), 0),
498: eofy_reserve),
499: prior_eofy_reserve = decode (l_polish_rule_tbl(i),
500: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
501: nvl(l_eofy_reserve_tbl(i), 0),
502: prior_eofy_reserve),
503: eop_adj_cost = decode (l_polish_rule_tbl(i),
504: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 504: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

500: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
501: nvl(l_eofy_reserve_tbl(i), 0),
502: prior_eofy_reserve),
503: eop_adj_cost = decode (l_polish_rule_tbl(i),
504: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
505: decode (l_period_update_flag_tbl(i),
506: 'Y', nvl(l_old_adjusted_cost_tbl(i), 0),
507: decode (l_exclude_fully_rsv_flag_tbl(i),
508: 'Y', nvl(l_old_adjusted_cost_tbl(i), 0),

Line 512: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

508: 'Y', nvl(l_old_adjusted_cost_tbl(i), 0),
509: eop_adj_cost)),
510: eop_adj_cost),
511: eop_formula_factor = decode (l_polish_rule_tbl(i),
512: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
513: decode (l_period_update_flag_tbl(i),
514: 'Y', nvl(l_eofy_formula_factor_tbl(i), 1),
515: decode (l_exclude_fully_rsv_flag_tbl(i),
516: 'Y', nvl(l_eofy_formula_factor_tbl(i), 1),

Line 520: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

516: 'Y', nvl(l_eofy_formula_factor_tbl(i), 1),
517: eop_formula_factor)),
518: eop_formula_factor),
519: adjusted_capacity = decode (l_polish_rule_tbl(i),
520: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
521: decode (l_period_update_flag_tbl(i),
522: 'Y', nvl(l_new_adjusted_capacity_tbl(i), 0),
523: decode (l_exclude_fully_rsv_flag_tbl(i),
524: 'Y', nvl(l_new_adjusted_capacity_tbl(i), 0),

Line 534: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

530:
531: forall i IN 1..l_asset_id_tbl.count
532: update fa_books_mrc_v
533: set adjusted_cost = decode (l_polish_rule_tbl(i),
534: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
535: nvl(l_new_adjusted_cost_tbl(i), 0),
536: l_old_adjusted_cost_tbl(i)),
537: formula_factor = decode (l_polish_rule_tbl(i),
538: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 538: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

534: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
535: nvl(l_new_adjusted_cost_tbl(i), 0),
536: l_old_adjusted_cost_tbl(i)),
537: formula_factor = decode (l_polish_rule_tbl(i),
538: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
539: nvl(l_new_formula_factor_tbl(i), 1),
540: l_old_formula_factor_tbl(i)),
541: prior_eofy_reserve = decode (l_polish_rule_tbl(i),
542: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 542: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

538: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
539: nvl(l_new_formula_factor_tbl(i), 1),
540: l_old_formula_factor_tbl(i)),
541: prior_eofy_reserve = decode (l_polish_rule_tbl(i),
542: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
543: nvl(l_eofy_reserve_tbl(i), 0),
544: prior_eofy_reserve),
545: eop_adj_cost = decode (l_polish_rule_tbl(i),
546: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 546: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

542: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
543: nvl(l_eofy_reserve_tbl(i), 0),
544: prior_eofy_reserve),
545: eop_adj_cost = decode (l_polish_rule_tbl(i),
546: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
547: decode (l_period_update_flag_tbl(i),
548: 'Y', nvl(l_old_adjusted_cost_tbl(i), 0),
549: decode (l_exclude_fully_rsv_flag_tbl(i),
550: 'Y', nvl(l_old_adjusted_cost_tbl(i), 0),

Line 554: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

550: 'Y', nvl(l_old_adjusted_cost_tbl(i), 0),
551: eop_adj_cost)),
552: eop_adj_cost),
553: eop_formula_factor = decode (l_polish_rule_tbl(i),
554: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
555: decode (l_period_update_flag_tbl(i),
556: 'Y', nvl(l_eofy_formula_factor_tbl(i), 1),
557: decode (l_exclude_fully_rsv_flag_tbl(i),
558: 'Y', nvl(l_eofy_formula_factor_tbl(i), 1),

Line 562: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

558: 'Y', nvl(l_eofy_formula_factor_tbl(i), 1),
559: eop_formula_factor)),
560: eop_formula_factor),
561: adjusted_capacity = decode (l_polish_rule_tbl(i),
562: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
563: decode (l_period_update_flag_tbl(i),
564: 'Y', nvl(l_new_adjusted_capacity_tbl(i), 0),
565: decode (l_exclude_fully_rsv_flag_tbl(i),
566: 'Y', nvl(l_new_adjusted_capacity_tbl(i), 0),

Line 583: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

579:
580: forall i IN 1..l_asset_id_tbl.count
581: update fa_books
582: set adjusted_cost = decode (l_polish_rule_tbl(i),
583: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
584: nvl(l_new_adjusted_cost_tbl(i), 0),
585: l_old_adjusted_cost_tbl(i)),
586: formula_factor = decode (l_polish_rule_tbl(i),
587: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 587: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

583: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
584: nvl(l_new_adjusted_cost_tbl(i), 0),
585: l_old_adjusted_cost_tbl(i)),
586: formula_factor = decode (l_polish_rule_tbl(i),
587: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
588: nvl(l_new_formula_factor_tbl(i), 1),
589: l_old_formula_factor_tbl(i)),
590: eofy_adj_cost = decode (l_polish_rule_tbl(i),
591: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 591: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

587: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
588: nvl(l_new_formula_factor_tbl(i), 1),
589: l_old_formula_factor_tbl(i)),
590: eofy_adj_cost = decode (l_polish_rule_tbl(i),
591: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
592: l_old_adjusted_cost_tbl(i),
593: eofy_adj_cost),
594: eofy_formula_factor = decode (l_polish_rule_tbl(i),
595: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 595: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

591: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
592: l_old_adjusted_cost_tbl(i),
593: eofy_adj_cost),
594: eofy_formula_factor = decode (l_polish_rule_tbl(i),
595: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
596: l_new_formula_factor_tbl(i),
597: eofy_formula_factor),
598: eofy_reserve = decode (l_polish_rule_tbl(i),
599: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 599: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

595: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
596: l_new_formula_factor_tbl(i),
597: eofy_formula_factor),
598: eofy_reserve = decode (l_polish_rule_tbl(i),
599: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
600: nvl(l_current_total_rsv_tbl(i), 0),
601: eofy_reserve),
602: prior_eofy_reserve = decode (l_polish_rule_tbl(i),
603: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 603: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

599: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
600: nvl(l_current_total_rsv_tbl(i), 0),
601: eofy_reserve),
602: prior_eofy_reserve = decode (l_polish_rule_tbl(i),
603: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
604: nvl(l_eofy_reserve_tbl(i), 0),
605: prior_eofy_reserve),
606: eop_adj_cost = decode (l_polish_rule_tbl(i),
607: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 607: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

603: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
604: nvl(l_eofy_reserve_tbl(i), 0),
605: prior_eofy_reserve),
606: eop_adj_cost = decode (l_polish_rule_tbl(i),
607: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
608: decode (l_period_update_flag_tbl(i),
609: 'Y', nvl(l_old_adjusted_cost_tbl(i), 0),
610: decode (l_exclude_fully_rsv_flag_tbl(i),
611: 'Y', nvl(l_old_adjusted_cost_tbl(i), 0),

Line 615: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

611: 'Y', nvl(l_old_adjusted_cost_tbl(i), 0),
612: eop_adj_cost)),
613: eop_adj_cost),
614: eop_formula_factor = decode (l_polish_rule_tbl(i),
615: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
616: decode (l_period_update_flag_tbl(i),
617: 'Y', nvl(l_eofy_formula_factor_tbl(i), 1),
618: decode (l_exclude_fully_rsv_flag_tbl(i),
619: 'Y', nvl(l_eofy_formula_factor_tbl(i), 1),

Line 623: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

619: 'Y', nvl(l_eofy_formula_factor_tbl(i), 1),
620: eop_formula_factor)),
621: eop_formula_factor),
622: adjusted_capacity = decode (l_polish_rule_tbl(i),
623: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
624: decode (l_period_update_flag_tbl(i),
625: 'Y', nvl(l_new_adjusted_capacity_tbl(i), 0),
626: decode (l_exclude_fully_rsv_flag_tbl(i),
627: 'Y', nvl(l_new_adjusted_capacity_tbl(i), 0),

Line 642: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

638:
639: forall i IN 1..l_asset_id_tbl.count
640: update fa_books
641: set adjusted_cost = decode (l_polish_rule_tbl(i),
642: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
643: nvl(l_new_adjusted_cost_tbl(i), 0),
644: l_old_adjusted_cost_tbl(i)),
645: formula_factor = decode (l_polish_rule_tbl(i),
646: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 646: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

642: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
643: nvl(l_new_adjusted_cost_tbl(i), 0),
644: l_old_adjusted_cost_tbl(i)),
645: formula_factor = decode (l_polish_rule_tbl(i),
646: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
647: nvl(l_new_formula_factor_tbl(i), 1),
648: l_old_formula_factor_tbl(i)),
649: prior_eofy_reserve = decode (l_polish_rule_tbl(i),
650: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 650: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

646: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
647: nvl(l_new_formula_factor_tbl(i), 1),
648: l_old_formula_factor_tbl(i)),
649: prior_eofy_reserve = decode (l_polish_rule_tbl(i),
650: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
651: nvl(l_eofy_reserve_tbl(i), 0),
652: prior_eofy_reserve),
653: eop_adj_cost = decode (l_polish_rule_tbl(i),
654: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 654: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

650: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
651: nvl(l_eofy_reserve_tbl(i), 0),
652: prior_eofy_reserve),
653: eop_adj_cost = decode (l_polish_rule_tbl(i),
654: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
655: decode (l_period_update_flag_tbl(i),
656: 'Y', nvl(l_old_adjusted_cost_tbl(i), 0),
657: decode (l_exclude_fully_rsv_flag_tbl(i),
658: 'Y', nvl(l_old_adjusted_cost_tbl(i), 0),

Line 662: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

658: 'Y', nvl(l_old_adjusted_cost_tbl(i), 0),
659: eop_adj_cost)),
660: eop_adj_cost),
661: eop_formula_factor = decode (l_polish_rule_tbl(i),
662: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
663: decode (l_period_update_flag_tbl(i),
664: 'Y', nvl(l_eofy_formula_factor_tbl(i), 1),
665: decode (l_exclude_fully_rsv_flag_tbl(i),
666: 'Y', nvl(l_eofy_formula_factor_tbl(i), 1),

Line 670: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

666: 'Y', nvl(l_eofy_formula_factor_tbl(i), 1),
667: eop_formula_factor)),
668: eop_formula_factor),
669: adjusted_capacity = decode (l_polish_rule_tbl(i),
670: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
671: decode (l_period_update_flag_tbl(i),
672: 'Y', nvl(l_new_adjusted_capacity_tbl(i), 0),
673: decode (l_exclude_fully_rsv_flag_tbl(i),
674: 'Y', nvl(l_new_adjusted_capacity_tbl(i), 0),