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 115: FA_STD_TYPES.FAD_DBR_POLISH_1,

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

Line 117: FA_STD_TYPES.FAD_DBR_POLISH_2,

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

Line 119: FA_STD_TYPES.FAD_DBR_POLISH_3,

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

Line 121: FA_STD_TYPES.FAD_DBR_POLISH_4,

117: FA_STD_TYPES.FAD_DBR_POLISH_2,
118: 'POLISH DECLINING MODIFIED WITH A SWITCH TO DECLINING CLASSICAL AND FLAT RATE',
119: FA_STD_TYPES.FAD_DBR_POLISH_3,
120: 'POLISH DECLINING MODIFIED WITH A SWITCH TO FLAT RATE',
121: FA_STD_TYPES.FAD_DBR_POLISH_4,
122: 'POLISH STANDARD DECLINING WITH A SWITCH TO FLAT RATE',
123: FA_STD_TYPES.FAD_DBR_POLISH_5,
124: FA_STD_TYPES.FAD_DBR_POLISH_NONE)
125: , nvl(ds.impairment_reserve, 0) -- P2IAS36

Line 123: FA_STD_TYPES.FAD_DBR_POLISH_5,

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

Line 124: FA_STD_TYPES.FAD_DBR_POLISH_NONE)

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

Line 181: FA_STD_TYPES.FAD_DBR_POLISH_1,

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

Line 183: FA_STD_TYPES.FAD_DBR_POLISH_2,

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

Line 185: FA_STD_TYPES.FAD_DBR_POLISH_3,

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

Line 187: FA_STD_TYPES.FAD_DBR_POLISH_4,

183: FA_STD_TYPES.FAD_DBR_POLISH_2,
184: 'POLISH DECLINING MODIFIED WITH A SWITCH TO DECLINING CLASSICAL AND FLAT RATE',
185: FA_STD_TYPES.FAD_DBR_POLISH_3,
186: 'POLISH DECLINING MODIFIED WITH A SWITCH TO FLAT RATE',
187: FA_STD_TYPES.FAD_DBR_POLISH_4,
188: 'POLISH STANDARD DECLINING WITH A SWITCH TO FLAT RATE',
189: FA_STD_TYPES.FAD_DBR_POLISH_5,
190: FA_STD_TYPES.FAD_DBR_POLISH_NONE)
191: , nvl(ds.impairment_reserve, 0) -- P2IAS36

Line 189: FA_STD_TYPES.FAD_DBR_POLISH_5,

185: FA_STD_TYPES.FAD_DBR_POLISH_3,
186: 'POLISH DECLINING MODIFIED WITH A SWITCH TO FLAT RATE',
187: FA_STD_TYPES.FAD_DBR_POLISH_4,
188: 'POLISH STANDARD DECLINING WITH A SWITCH TO FLAT RATE',
189: FA_STD_TYPES.FAD_DBR_POLISH_5,
190: FA_STD_TYPES.FAD_DBR_POLISH_NONE)
191: , nvl(ds.impairment_reserve, 0) -- P2IAS36
192: , nvl(mt.guarantee_rate_method_flag, 'NO') -- Bug:5930979:Japan Tax Reform Project
193: from fa_mc_deprn_summary ds,

Line 190: FA_STD_TYPES.FAD_DBR_POLISH_NONE)

186: 'POLISH DECLINING MODIFIED WITH A SWITCH TO FLAT RATE',
187: FA_STD_TYPES.FAD_DBR_POLISH_4,
188: 'POLISH STANDARD DECLINING WITH A SWITCH TO FLAT RATE',
189: FA_STD_TYPES.FAD_DBR_POLISH_5,
190: FA_STD_TYPES.FAD_DBR_POLISH_NONE)
191: , nvl(ds.impairment_reserve, 0) -- P2IAS36
192: , nvl(mt.guarantee_rate_method_flag, 'NO') -- Bug:5930979:Japan Tax Reform Project
193: from fa_mc_deprn_summary ds,
194: fa_mc_books bks,

Line 503: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

499:
500: forall i IN 1..l_asset_id_tbl.count
501: update fa_mc_books
502: set adjusted_cost = decode (l_polish_rule_tbl(i),
503: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
504: nvl(l_new_adjusted_cost_tbl(i), 0),
505: l_old_adjusted_cost_tbl(i)),
506: formula_factor = decode (l_polish_rule_tbl(i),
507: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 507: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

503: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
504: nvl(l_new_adjusted_cost_tbl(i), 0),
505: l_old_adjusted_cost_tbl(i)),
506: formula_factor = decode (l_polish_rule_tbl(i),
507: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
508: nvl(l_new_formula_factor_tbl(i), 1),
509: l_old_formula_factor_tbl(i)),
510: eofy_adj_cost = decode (l_polish_rule_tbl(i),
511: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 511: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

507: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
508: nvl(l_new_formula_factor_tbl(i), 1),
509: l_old_formula_factor_tbl(i)),
510: eofy_adj_cost = decode (l_polish_rule_tbl(i),
511: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
512: l_old_adjusted_cost_tbl(i),
513: eofy_adj_cost),
514: eofy_formula_factor = decode (l_polish_rule_tbl(i),
515: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 515: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

511: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
512: l_old_adjusted_cost_tbl(i),
513: eofy_adj_cost),
514: eofy_formula_factor = decode (l_polish_rule_tbl(i),
515: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
516: l_new_formula_factor_tbl(i),
517: eofy_formula_factor),
518: eofy_reserve = decode (l_polish_rule_tbl(i),
519: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 519: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

515: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
516: l_new_formula_factor_tbl(i),
517: eofy_formula_factor),
518: eofy_reserve = decode (l_polish_rule_tbl(i),
519: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
520: nvl(l_current_total_rsv_tbl(i), 0),
521: eofy_reserve),
522: prior_eofy_reserve = decode (l_polish_rule_tbl(i),
523: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 523: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

519: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
520: nvl(l_current_total_rsv_tbl(i), 0),
521: eofy_reserve),
522: prior_eofy_reserve = decode (l_polish_rule_tbl(i),
523: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
524: nvl(l_eofy_reserve_tbl(i), 0),
525: prior_eofy_reserve),
526: eop_adj_cost = decode (l_polish_rule_tbl(i),
527: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 527: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

523: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
524: nvl(l_eofy_reserve_tbl(i), 0),
525: prior_eofy_reserve),
526: eop_adj_cost = decode (l_polish_rule_tbl(i),
527: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
528: decode (l_period_update_flag_tbl(i),
529: 'Y', nvl(l_old_adjusted_cost_tbl(i), 0),
530: decode (l_exclude_fully_rsv_flag_tbl(i),
531: 'Y', nvl(l_old_adjusted_cost_tbl(i), 0),

Line 535: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

531: 'Y', nvl(l_old_adjusted_cost_tbl(i), 0),
532: eop_adj_cost)),
533: eop_adj_cost),
534: eop_formula_factor = decode (l_polish_rule_tbl(i),
535: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
536: decode (l_period_update_flag_tbl(i),
537: 'Y', nvl(l_eofy_formula_factor_tbl(i), 1),
538: decode (l_exclude_fully_rsv_flag_tbl(i),
539: 'Y', nvl(l_eofy_formula_factor_tbl(i), 1),

Line 543: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

539: 'Y', nvl(l_eofy_formula_factor_tbl(i), 1),
540: eop_formula_factor)),
541: eop_formula_factor),
542: adjusted_capacity = decode (l_polish_rule_tbl(i),
543: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
544: decode (l_period_update_flag_tbl(i),
545: 'Y', nvl(l_new_adjusted_capacity_tbl(i), 0),
546: decode (l_exclude_fully_rsv_flag_tbl(i),
547: 'Y', nvl(l_new_adjusted_capacity_tbl(i), 0),

Line 557: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

553:
554: forall i IN 1..l_asset_id_tbl.count
555: update fa_mc_books
556: set adjusted_cost = decode (l_polish_rule_tbl(i),
557: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
558: nvl(l_new_adjusted_cost_tbl(i), 0),
559: l_old_adjusted_cost_tbl(i)),
560: formula_factor = decode (l_polish_rule_tbl(i),
561: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 561: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

557: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
558: nvl(l_new_adjusted_cost_tbl(i), 0),
559: l_old_adjusted_cost_tbl(i)),
560: formula_factor = decode (l_polish_rule_tbl(i),
561: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
562: nvl(l_new_formula_factor_tbl(i), 1),
563: l_old_formula_factor_tbl(i)),
564: prior_eofy_reserve = decode (l_polish_rule_tbl(i),
565: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 565: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

561: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
562: nvl(l_new_formula_factor_tbl(i), 1),
563: l_old_formula_factor_tbl(i)),
564: prior_eofy_reserve = decode (l_polish_rule_tbl(i),
565: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
566: nvl(l_eofy_reserve_tbl(i), 0),
567: prior_eofy_reserve),
568: eop_adj_cost = decode (l_polish_rule_tbl(i),
569: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 569: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

565: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
566: nvl(l_eofy_reserve_tbl(i), 0),
567: prior_eofy_reserve),
568: eop_adj_cost = decode (l_polish_rule_tbl(i),
569: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
570: decode (l_period_update_flag_tbl(i),
571: 'Y', nvl(l_old_adjusted_cost_tbl(i), 0),
572: decode (l_exclude_fully_rsv_flag_tbl(i),
573: 'Y', nvl(l_old_adjusted_cost_tbl(i), 0),

Line 577: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

573: 'Y', nvl(l_old_adjusted_cost_tbl(i), 0),
574: eop_adj_cost)),
575: eop_adj_cost),
576: eop_formula_factor = decode (l_polish_rule_tbl(i),
577: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
578: decode (l_period_update_flag_tbl(i),
579: 'Y', nvl(l_eofy_formula_factor_tbl(i), 1),
580: decode (l_exclude_fully_rsv_flag_tbl(i),
581: 'Y', nvl(l_eofy_formula_factor_tbl(i), 1),

Line 585: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

581: 'Y', nvl(l_eofy_formula_factor_tbl(i), 1),
582: eop_formula_factor)),
583: eop_formula_factor),
584: adjusted_capacity = decode (l_polish_rule_tbl(i),
585: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
586: decode (l_period_update_flag_tbl(i),
587: 'Y', nvl(l_new_adjusted_capacity_tbl(i), 0),
588: decode (l_exclude_fully_rsv_flag_tbl(i),
589: 'Y', nvl(l_new_adjusted_capacity_tbl(i), 0),

Line 605: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

601:
602: forall i IN 1..l_asset_id_tbl.count
603: update fa_books
604: set adjusted_cost = decode (l_polish_rule_tbl(i),
605: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
606: nvl(l_new_adjusted_cost_tbl(i), 0),
607: l_old_adjusted_cost_tbl(i)),
608: formula_factor = decode (l_polish_rule_tbl(i),
609: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 609: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

605: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
606: nvl(l_new_adjusted_cost_tbl(i), 0),
607: l_old_adjusted_cost_tbl(i)),
608: formula_factor = decode (l_polish_rule_tbl(i),
609: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
610: nvl(l_new_formula_factor_tbl(i), 1),
611: l_old_formula_factor_tbl(i)),
612: eofy_adj_cost = decode (l_polish_rule_tbl(i),
613: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 613: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

609: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
610: nvl(l_new_formula_factor_tbl(i), 1),
611: l_old_formula_factor_tbl(i)),
612: eofy_adj_cost = decode (l_polish_rule_tbl(i),
613: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
614: l_old_adjusted_cost_tbl(i),
615: eofy_adj_cost),
616: eofy_formula_factor = decode (l_polish_rule_tbl(i),
617: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 617: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

613: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
614: l_old_adjusted_cost_tbl(i),
615: eofy_adj_cost),
616: eofy_formula_factor = decode (l_polish_rule_tbl(i),
617: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
618: l_new_formula_factor_tbl(i),
619: eofy_formula_factor),
620: eofy_reserve = decode (l_polish_rule_tbl(i),
621: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 621: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

617: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
618: l_new_formula_factor_tbl(i),
619: eofy_formula_factor),
620: eofy_reserve = decode (l_polish_rule_tbl(i),
621: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
622: nvl(l_current_total_rsv_tbl(i), 0),
623: eofy_reserve),
624: prior_eofy_reserve = decode (l_polish_rule_tbl(i),
625: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 625: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

621: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
622: nvl(l_current_total_rsv_tbl(i), 0),
623: eofy_reserve),
624: prior_eofy_reserve = decode (l_polish_rule_tbl(i),
625: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
626: nvl(l_eofy_reserve_tbl(i), 0),
627: prior_eofy_reserve),
628: eop_adj_cost = decode (l_polish_rule_tbl(i),
629: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 629: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

625: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
626: nvl(l_eofy_reserve_tbl(i), 0),
627: prior_eofy_reserve),
628: eop_adj_cost = decode (l_polish_rule_tbl(i),
629: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
630: decode (l_period_update_flag_tbl(i),
631: 'Y', nvl(l_old_adjusted_cost_tbl(i), 0),
632: decode (l_exclude_fully_rsv_flag_tbl(i),
633: 'Y', nvl(l_old_adjusted_cost_tbl(i), 0),

Line 637: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

633: 'Y', nvl(l_old_adjusted_cost_tbl(i), 0),
634: eop_adj_cost)),
635: eop_adj_cost),
636: eop_formula_factor = decode (l_polish_rule_tbl(i),
637: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
638: decode (l_period_update_flag_tbl(i),
639: 'Y', nvl(l_eofy_formula_factor_tbl(i), 1),
640: decode (l_exclude_fully_rsv_flag_tbl(i),
641: 'Y', nvl(l_eofy_formula_factor_tbl(i), 1),

Line 645: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

641: 'Y', nvl(l_eofy_formula_factor_tbl(i), 1),
642: eop_formula_factor)),
643: eop_formula_factor),
644: adjusted_capacity = decode (l_polish_rule_tbl(i),
645: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
646: decode (l_period_update_flag_tbl(i),
647: 'Y', nvl(l_new_adjusted_capacity_tbl(i), 0),
648: decode (l_exclude_fully_rsv_flag_tbl(i),
649: 'Y', nvl(l_new_adjusted_capacity_tbl(i), 0),

Line 663: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

659:
660: forall i IN 1..l_asset_id_tbl.count
661: update fa_books
662: set adjusted_cost = decode (l_polish_rule_tbl(i),
663: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
664: nvl(l_new_adjusted_cost_tbl(i), 0),
665: l_old_adjusted_cost_tbl(i)),
666: formula_factor = decode (l_polish_rule_tbl(i),
667: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 667: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

663: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
664: nvl(l_new_adjusted_cost_tbl(i), 0),
665: l_old_adjusted_cost_tbl(i)),
666: formula_factor = decode (l_polish_rule_tbl(i),
667: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
668: nvl(l_new_formula_factor_tbl(i), 1),
669: l_old_formula_factor_tbl(i)),
670: prior_eofy_reserve = decode (l_polish_rule_tbl(i),
671: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 671: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

667: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
668: nvl(l_new_formula_factor_tbl(i), 1),
669: l_old_formula_factor_tbl(i)),
670: prior_eofy_reserve = decode (l_polish_rule_tbl(i),
671: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
672: nvl(l_eofy_reserve_tbl(i), 0),
673: prior_eofy_reserve),
674: eop_adj_cost = decode (l_polish_rule_tbl(i),
675: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

Line 675: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

671: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
672: nvl(l_eofy_reserve_tbl(i), 0),
673: prior_eofy_reserve),
674: eop_adj_cost = decode (l_polish_rule_tbl(i),
675: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
676: decode (l_period_update_flag_tbl(i),
677: 'Y', nvl(l_old_adjusted_cost_tbl(i), 0),
678: decode (l_exclude_fully_rsv_flag_tbl(i),
679: 'Y', nvl(l_old_adjusted_cost_tbl(i), 0),

Line 683: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

679: 'Y', nvl(l_old_adjusted_cost_tbl(i), 0),
680: eop_adj_cost)),
681: eop_adj_cost),
682: eop_formula_factor = decode (l_polish_rule_tbl(i),
683: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
684: decode (l_period_update_flag_tbl(i),
685: 'Y', nvl(l_eofy_formula_factor_tbl(i), 1),
686: decode (l_exclude_fully_rsv_flag_tbl(i),
687: 'Y', nvl(l_eofy_formula_factor_tbl(i), 1),

Line 691: FA_STD_TYPES.FAD_DBR_POLISH_NONE,

687: 'Y', nvl(l_eofy_formula_factor_tbl(i), 1),
688: eop_formula_factor)),
689: eop_formula_factor),
690: adjusted_capacity = decode (l_polish_rule_tbl(i),
691: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
692: decode (l_period_update_flag_tbl(i),
693: 'Y', nvl(l_new_adjusted_capacity_tbl(i), 0),
694: decode (l_exclude_fully_rsv_flag_tbl(i),
695: 'Y', nvl(l_new_adjusted_capacity_tbl(i), 0),