[Home] [Help]
904: UPDATE fa_mc_books_summary
905: SET
906: book_type_code = decode(X_Book_Type_Code,
907: NULL, book_type_code,
908: FND_API.G_MISS_CHAR, NULL,
909: X_Book_Type_Code),
910: asset_id = decode(X_Asset_Id,
911: NULL, asset_id,
912: FND_API.G_MISS_NUM, NULL,
908: FND_API.G_MISS_CHAR, NULL,
909: X_Book_Type_Code),
910: asset_id = decode(X_Asset_Id,
911: NULL, asset_id,
912: FND_API.G_MISS_NUM, NULL,
913: X_Asset_Id),
914: period_counter = decode(X_period_counter,
915: NULL, period_counter,
916: FND_API.G_MISS_NUM, NULL,
912: FND_API.G_MISS_NUM, NULL,
913: X_Asset_Id),
914: period_counter = decode(X_period_counter,
915: NULL, period_counter,
916: FND_API.G_MISS_NUM, NULL,
917: X_Period_Counter),
918: fiscal_year = decode(X_fiscal_year,
919: NULL, fiscal_year,
920: FND_API.G_MISS_NUM, NULL,
916: FND_API.G_MISS_NUM, NULL,
917: X_Period_Counter),
918: fiscal_year = decode(X_fiscal_year,
919: NULL, fiscal_year,
920: FND_API.G_MISS_NUM, NULL,
921: X_Fiscal_Year),
922: period_num = decode(X_period_num,
923: NULL, period_num,
924: FND_API.G_MISS_NUM, NULL,
920: FND_API.G_MISS_NUM, NULL,
921: X_Fiscal_Year),
922: period_num = decode(X_period_num,
923: NULL, period_num,
924: FND_API.G_MISS_NUM, NULL,
925: X_Period_Num),
926: calendar_period_open_date = decode(X_calendar_period_open_date,
927: NULL, calendar_period_open_date,
928: X_Calendar_Period_Open_Date),
930: NULL, calendar_period_close_date,
931: X_Calendar_Period_Close_Date),
932: reset_adjusted_cost_flag = decode(X_reset_adjusted_cost_flag,
933: NULL, reset_adjusted_cost_flag,
934: FND_API.G_MISS_CHAR, NULL,
935: X_Reset_Adjusted_Cost_Flag),
936: change_in_cost = decode(X_change_in_cost,
937: NULL, change_in_cost,
938: FND_API.G_MISS_NUM, NULL,
934: FND_API.G_MISS_CHAR, NULL,
935: X_Reset_Adjusted_Cost_Flag),
936: change_in_cost = decode(X_change_in_cost,
937: NULL, change_in_cost,
938: FND_API.G_MISS_NUM, NULL,
939: X_Change_In_Cost),
940: change_in_additions_cost = decode(X_change_in_additions_cost,
941: NULL, change_in_additions_cost,
942: FND_API.G_MISS_NUM, NULL,
938: FND_API.G_MISS_NUM, NULL,
939: X_Change_In_Cost),
940: change_in_additions_cost = decode(X_change_in_additions_cost,
941: NULL, change_in_additions_cost,
942: FND_API.G_MISS_NUM, NULL,
943: X_Change_In_Additions_Cost),
944: change_in_adjustments_cost = decode(X_change_in_adjustments_cost,
945: NULL, change_in_adjustments_cost,
946: FND_API.G_MISS_NUM, NULL,
942: FND_API.G_MISS_NUM, NULL,
943: X_Change_In_Additions_Cost),
944: change_in_adjustments_cost = decode(X_change_in_adjustments_cost,
945: NULL, change_in_adjustments_cost,
946: FND_API.G_MISS_NUM, NULL,
947: X_Change_In_Adjustments_Cost),
948: change_in_retirements_cost = decode(X_change_in_retirements_cost,
949: NULL, change_in_retirements_cost,
950: FND_API.G_MISS_NUM, NULL,
946: FND_API.G_MISS_NUM, NULL,
947: X_Change_In_Adjustments_Cost),
948: change_in_retirements_cost = decode(X_change_in_retirements_cost,
949: NULL, change_in_retirements_cost,
950: FND_API.G_MISS_NUM, NULL,
951: X_Change_In_Retirements_Cost),
952: change_in_group_rec_cost = decode(X_change_in_group_rec_cost,
953: NULL, change_in_group_rec_cost,
954: FND_API.G_MISS_NUM, NULL,
950: FND_API.G_MISS_NUM, NULL,
951: X_Change_In_Retirements_Cost),
952: change_in_group_rec_cost = decode(X_change_in_group_rec_cost,
953: NULL, change_in_group_rec_cost,
954: FND_API.G_MISS_NUM, NULL,
955: X_Change_In_Group_Rec_Cost),
956: change_in_cip_cost = decode(X_change_in_cip_cost,
957: NULL, change_in_cip_cost,
958: FND_API.G_MISS_NUM, NULL,
954: FND_API.G_MISS_NUM, NULL,
955: X_Change_In_Group_Rec_Cost),
956: change_in_cip_cost = decode(X_change_in_cip_cost,
957: NULL, change_in_cip_cost,
958: FND_API.G_MISS_NUM, NULL,
959: X_Change_In_CIP_Cost),
960: cost = decode(X_cost,
961: NULL, cost,
962: FND_API.G_MISS_NUM, NULL,
958: FND_API.G_MISS_NUM, NULL,
959: X_Change_In_CIP_Cost),
960: cost = decode(X_cost,
961: NULL, cost,
962: FND_API.G_MISS_NUM, NULL,
963: X_Cost),
964: cip_cost = decode(X_cip_cost,
965: NULL, cip_cost,
966: FND_API.G_MISS_NUM, NULL,
962: FND_API.G_MISS_NUM, NULL,
963: X_Cost),
964: cip_cost = decode(X_cip_cost,
965: NULL, cip_cost,
966: FND_API.G_MISS_NUM, NULL,
967: X_CIP_Cost),
968: salvage_type = decode(X_salvage_type,
969: NULL, salvage_type,
970: FND_API.G_MISS_CHAR, NULL,
966: FND_API.G_MISS_NUM, NULL,
967: X_CIP_Cost),
968: salvage_type = decode(X_salvage_type,
969: NULL, salvage_type,
970: FND_API.G_MISS_CHAR, NULL,
971: X_Salvage_Type),
972: percent_salvage_value = decode(X_percent_salvage_value,
973: NULL, percent_salvage_value,
974: FND_API.G_MISS_NUM, NULL,
970: FND_API.G_MISS_CHAR, NULL,
971: X_Salvage_Type),
972: percent_salvage_value = decode(X_percent_salvage_value,
973: NULL, percent_salvage_value,
974: FND_API.G_MISS_NUM, NULL,
975: X_Percent_Salvage_Value),
976: salvage_value = decode(X_salvage_value,
977: NULL, salvage_value,
978: FND_API.G_MISS_NUM, NULL,
974: FND_API.G_MISS_NUM, NULL,
975: X_Percent_Salvage_Value),
976: salvage_value = decode(X_salvage_value,
977: NULL, salvage_value,
978: FND_API.G_MISS_NUM, NULL,
979: X_Salvage_Value),
980: member_salvage_value = decode(X_member_salvage_value,
981: NULL, member_salvage_value,
982: FND_API.G_MISS_NUM, NULL,
978: FND_API.G_MISS_NUM, NULL,
979: X_Salvage_Value),
980: member_salvage_value = decode(X_member_salvage_value,
981: NULL, member_salvage_value,
982: FND_API.G_MISS_NUM, NULL,
983: X_Member_Salvage_Value),
984: recoverable_cost = decode(X_recoverable_cost,
985: NULL, recoverable_cost,
986: FND_API.G_MISS_NUM, NULL,
982: FND_API.G_MISS_NUM, NULL,
983: X_Member_Salvage_Value),
984: recoverable_cost = decode(X_recoverable_cost,
985: NULL, recoverable_cost,
986: FND_API.G_MISS_NUM, NULL,
987: X_Recoverable_Cost),
988: deprn_limit_type = decode(X_deprn_limit_type,
989: NULL, deprn_limit_type,
990: FND_API.G_MISS_CHAR, NULL,
986: FND_API.G_MISS_NUM, NULL,
987: X_Recoverable_Cost),
988: deprn_limit_type = decode(X_deprn_limit_type,
989: NULL, deprn_limit_type,
990: FND_API.G_MISS_CHAR, NULL,
991: X_Deprn_Limit_Type),
992: allowed_deprn_limit = decode(X_allowed_deprn_limit,
993: NULL, allowed_deprn_limit,
994: FND_API.G_MISS_NUM, NULL,
990: FND_API.G_MISS_CHAR, NULL,
991: X_Deprn_Limit_Type),
992: allowed_deprn_limit = decode(X_allowed_deprn_limit,
993: NULL, allowed_deprn_limit,
994: FND_API.G_MISS_NUM, NULL,
995: X_Allowed_Deprn_Limit),
996: allowed_deprn_limit_amount = decode(X_allowed_deprn_limit_amount,
997: NULL, allowed_deprn_limit_amount,
998: FND_API.G_MISS_NUM, NULL,
994: FND_API.G_MISS_NUM, NULL,
995: X_Allowed_Deprn_Limit),
996: allowed_deprn_limit_amount = decode(X_allowed_deprn_limit_amount,
997: NULL, allowed_deprn_limit_amount,
998: FND_API.G_MISS_NUM, NULL,
999: X_Allowed_Deprn_Limit_Amount),
1000: member_deprn_limit_amount = decode(X_member_deprn_limit_amount,
1001: NULL, member_deprn_limit_amount,
1002: FND_API.G_MISS_NUM, NULL,
998: FND_API.G_MISS_NUM, NULL,
999: X_Allowed_Deprn_Limit_Amount),
1000: member_deprn_limit_amount = decode(X_member_deprn_limit_amount,
1001: NULL, member_deprn_limit_amount,
1002: FND_API.G_MISS_NUM, NULL,
1003: X_Member_Deprn_Limit_Amount),
1004: adjusted_recoverable_cost = decode(X_adjusted_recoverable_cost,
1005: NULL, adjusted_recoverable_cost,
1006: FND_API.G_MISS_NUM, NULL,
1002: FND_API.G_MISS_NUM, NULL,
1003: X_Member_Deprn_Limit_Amount),
1004: adjusted_recoverable_cost = decode(X_adjusted_recoverable_cost,
1005: NULL, adjusted_recoverable_cost,
1006: FND_API.G_MISS_NUM, NULL,
1007: X_Adjusted_Recoverable_Cost),
1008: adjusted_cost = decode(X_adjusted_cost,
1009: NULL, adjusted_cost,
1010: FND_API.G_MISS_NUM, NULL,
1006: FND_API.G_MISS_NUM, NULL,
1007: X_Adjusted_Recoverable_Cost),
1008: adjusted_cost = decode(X_adjusted_cost,
1009: NULL, adjusted_cost,
1010: FND_API.G_MISS_NUM, NULL,
1011: X_Adjusted_Cost),
1012: depreciate_flag = decode(X_depreciate_flag,
1013: NULL, depreciate_flag,
1014: FND_API.G_MISS_CHAR, NULL,
1010: FND_API.G_MISS_NUM, NULL,
1011: X_Adjusted_Cost),
1012: depreciate_flag = decode(X_depreciate_flag,
1013: NULL, depreciate_flag,
1014: FND_API.G_MISS_CHAR, NULL,
1015: X_Depreciate_Flag),
1016: disabled_flag = decode(X_disabled_flag,
1017: NULL, disabled_flag,
1018: FND_API.G_MISS_CHAR, NULL,
1014: FND_API.G_MISS_CHAR, NULL,
1015: X_Depreciate_Flag),
1016: disabled_flag = decode(X_disabled_flag,
1017: NULL, disabled_flag,
1018: FND_API.G_MISS_CHAR, NULL,
1019: X_Disabled_Flag),
1020: date_placed_in_service = decode(X_date_placed_in_service,
1021: NULL, date_placed_in_service,
1022: X_Date_Placed_In_Service),
1021: NULL, date_placed_in_service,
1022: X_Date_Placed_In_Service),
1023: deprn_method_code = decode(X_deprn_method_code,
1024: NULL, deprn_method_code,
1025: FND_API.G_MISS_CHAR, NULL,
1026: X_Deprn_Method_Code),
1027: life_in_months = decode(X_life_in_months,
1028: NULL, life_in_months,
1029: FND_API.G_MISS_NUM, NULL,
1025: FND_API.G_MISS_CHAR, NULL,
1026: X_Deprn_Method_Code),
1027: life_in_months = decode(X_life_in_months,
1028: NULL, life_in_months,
1029: FND_API.G_MISS_NUM, NULL,
1030: X_Life_In_Months),
1031: rate_adjustment_factor = decode(X_rate_adjustment_factor,
1032: NULL, rate_adjustment_factor,
1033: FND_API.G_MISS_NUM, NULL,
1029: FND_API.G_MISS_NUM, NULL,
1030: X_Life_In_Months),
1031: rate_adjustment_factor = decode(X_rate_adjustment_factor,
1032: NULL, rate_adjustment_factor,
1033: FND_API.G_MISS_NUM, NULL,
1034: X_Rate_Adjustment_Factor),
1035: adjusted_rate = decode(X_adjusted_rate,
1036: NULL, adjusted_rate,
1037: FND_API.G_MISS_NUM, NULL,
1033: FND_API.G_MISS_NUM, NULL,
1034: X_Rate_Adjustment_Factor),
1035: adjusted_rate = decode(X_adjusted_rate,
1036: NULL, adjusted_rate,
1037: FND_API.G_MISS_NUM, NULL,
1038: X_Adjusted_Rate),
1039: bonus_rule = decode(X_bonus_rule,
1040: NULL, bonus_rule,
1041: FND_API.G_MISS_CHAR, NULL,
1037: FND_API.G_MISS_NUM, NULL,
1038: X_Adjusted_Rate),
1039: bonus_rule = decode(X_bonus_rule,
1040: NULL, bonus_rule,
1041: FND_API.G_MISS_CHAR, NULL,
1042: X_Bonus_Rule),
1043: adjusted_capacity = decode(X_adjusted_capacity,
1044: NULL, adjusted_capacity,
1045: FND_API.G_MISS_NUM, NULL,
1041: FND_API.G_MISS_CHAR, NULL,
1042: X_Bonus_Rule),
1043: adjusted_capacity = decode(X_adjusted_capacity,
1044: NULL, adjusted_capacity,
1045: FND_API.G_MISS_NUM, NULL,
1046: X_Adjusted_Capacity),
1047: production_capacity = decode(X_production_capacity,
1048: NULL, production_capacity,
1049: FND_API.G_MISS_NUM, NULL,
1045: FND_API.G_MISS_NUM, NULL,
1046: X_Adjusted_Capacity),
1047: production_capacity = decode(X_production_capacity,
1048: NULL, production_capacity,
1049: FND_API.G_MISS_NUM, NULL,
1050: X_Production_Capacity),
1051: unit_of_measure = decode(X_unit_of_measure,
1052: NULL, unit_of_measure,
1053: FND_API.G_MISS_CHAR, NULL,
1049: FND_API.G_MISS_NUM, NULL,
1050: X_Production_Capacity),
1051: unit_of_measure = decode(X_unit_of_measure,
1052: NULL, unit_of_measure,
1053: FND_API.G_MISS_CHAR, NULL,
1054: X_Unit_Of_Measure),
1055: remaining_life1 = decode(X_remaining_life1,
1056: NULL, remaining_life1,
1057: FND_API.G_MISS_NUM, NULL,
1053: FND_API.G_MISS_CHAR, NULL,
1054: X_Unit_Of_Measure),
1055: remaining_life1 = decode(X_remaining_life1,
1056: NULL, remaining_life1,
1057: FND_API.G_MISS_NUM, NULL,
1058: X_Remaining_Life1),
1059: remaining_life2 = decode(X_remaining_life2,
1060: NULL, remaining_life2,
1061: FND_API.G_MISS_NUM, NULL,
1057: FND_API.G_MISS_NUM, NULL,
1058: X_Remaining_Life1),
1059: remaining_life2 = decode(X_remaining_life2,
1060: NULL, remaining_life2,
1061: FND_API.G_MISS_NUM, NULL,
1062: X_Remaining_Life2),
1063: formula_factor = decode(X_formula_factor,
1064: NULL, formula_factor,
1065: FND_API.G_MISS_NUM, NULL,
1061: FND_API.G_MISS_NUM, NULL,
1062: X_Remaining_Life2),
1063: formula_factor = decode(X_formula_factor,
1064: NULL, formula_factor,
1065: FND_API.G_MISS_NUM, NULL,
1066: X_Formula_Factor),
1067: unrevalued_cost = decode(X_unrevalued_cost,
1068: NULL, unrevalued_cost,
1069: FND_API.G_MISS_NUM, NULL,
1065: FND_API.G_MISS_NUM, NULL,
1066: X_Formula_Factor),
1067: unrevalued_cost = decode(X_unrevalued_cost,
1068: NULL, unrevalued_cost,
1069: FND_API.G_MISS_NUM, NULL,
1070: X_Unrevalued_Cost),
1071: reval_amortization_basis = decode(X_reval_amortization_basis,
1072: NULL, reval_amortization_basis,
1073: FND_API.G_MISS_NUM, NULL,
1069: FND_API.G_MISS_NUM, NULL,
1070: X_Unrevalued_Cost),
1071: reval_amortization_basis = decode(X_reval_amortization_basis,
1072: NULL, reval_amortization_basis,
1073: FND_API.G_MISS_NUM, NULL,
1074: X_Reval_Amortization_Basis),
1075: reval_ceiling = decode(X_reval_ceiling,
1076: NULL, reval_ceiling,
1077: FND_API.G_MISS_NUM, NULL,
1073: FND_API.G_MISS_NUM, NULL,
1074: X_Reval_Amortization_Basis),
1075: reval_ceiling = decode(X_reval_ceiling,
1076: NULL, reval_ceiling,
1077: FND_API.G_MISS_NUM, NULL,
1078: X_Reval_Ceiling),
1079: ceiling_name = decode(X_ceiling_name,
1080: NULL, ceiling_name,
1081: FND_API.G_MISS_CHAR, NULL,
1077: FND_API.G_MISS_NUM, NULL,
1078: X_Reval_Ceiling),
1079: ceiling_name = decode(X_ceiling_name,
1080: NULL, ceiling_name,
1081: FND_API.G_MISS_CHAR, NULL,
1082: X_Ceiling_Name),
1083: eofy_adj_cost = decode(X_eofy_adj_cost,
1084: NULL, eofy_adj_cost,
1085: FND_API.G_MISS_NUM, NULL,
1081: FND_API.G_MISS_CHAR, NULL,
1082: X_Ceiling_Name),
1083: eofy_adj_cost = decode(X_eofy_adj_cost,
1084: NULL, eofy_adj_cost,
1085: FND_API.G_MISS_NUM, NULL,
1086: X_Eofy_Adj_Cost),
1087: eofy_formula_factor = decode(X_eofy_formula_factor,
1088: NULL, eofy_formula_factor,
1089: FND_API.G_MISS_NUM, NULL,
1085: FND_API.G_MISS_NUM, NULL,
1086: X_Eofy_Adj_Cost),
1087: eofy_formula_factor = decode(X_eofy_formula_factor,
1088: NULL, eofy_formula_factor,
1089: FND_API.G_MISS_NUM, NULL,
1090: X_Eofy_Formula_Factor),
1091: eofy_reserve = decode(X_eofy_reserve,
1092: NULL, eofy_reserve,
1093: FND_API.G_MISS_NUM, NULL,
1089: FND_API.G_MISS_NUM, NULL,
1090: X_Eofy_Formula_Factor),
1091: eofy_reserve = decode(X_eofy_reserve,
1092: NULL, eofy_reserve,
1093: FND_API.G_MISS_NUM, NULL,
1094: X_Eofy_Reserve),
1095: eop_adj_cost = decode(X_eop_adj_cost,
1096: NULL, eop_adj_cost,
1097: FND_API.G_MISS_NUM, NULL,
1093: FND_API.G_MISS_NUM, NULL,
1094: X_Eofy_Reserve),
1095: eop_adj_cost = decode(X_eop_adj_cost,
1096: NULL, eop_adj_cost,
1097: FND_API.G_MISS_NUM, NULL,
1098: X_Eop_Adj_Cost),
1099: eop_formula_factor = decode(X_eop_formula_factor,
1100: NULL, eop_formula_factor,
1101: FND_API.G_MISS_NUM, NULL,
1097: FND_API.G_MISS_NUM, NULL,
1098: X_Eop_Adj_Cost),
1099: eop_formula_factor = decode(X_eop_formula_factor,
1100: NULL, eop_formula_factor,
1101: FND_API.G_MISS_NUM, NULL,
1102: X_Eop_Formula_Factor),
1103: short_fiscal_year_flag = decode(X_short_fiscal_year_flag,
1104: NULL, short_fiscal_year_flag,
1105: FND_API.G_MISS_CHAR, NULL,
1101: FND_API.G_MISS_NUM, NULL,
1102: X_Eop_Formula_Factor),
1103: short_fiscal_year_flag = decode(X_short_fiscal_year_flag,
1104: NULL, short_fiscal_year_flag,
1105: FND_API.G_MISS_CHAR, NULL,
1106: X_Short_Fiscal_Year_Flag),
1107: group_asset_id = decode(X_group_asset_id,
1108: NULL, group_asset_id,
1109: FND_API.G_MISS_NUM, NULL,
1105: FND_API.G_MISS_CHAR, NULL,
1106: X_Short_Fiscal_Year_Flag),
1107: group_asset_id = decode(X_group_asset_id,
1108: NULL, group_asset_id,
1109: FND_API.G_MISS_NUM, NULL,
1110: X_Group_Asset_ID),
1111: super_group_id = decode(X_super_group_id,
1112: NULL, super_group_id,
1113: FND_API.G_MISS_NUM, NULL,
1109: FND_API.G_MISS_NUM, NULL,
1110: X_Group_Asset_ID),
1111: super_group_id = decode(X_super_group_id,
1112: NULL, super_group_id,
1113: FND_API.G_MISS_NUM, NULL,
1114: X_Super_Group_ID),
1115: over_depreciate_option = decode(X_over_depreciate_option,
1116: NULL, over_depreciate_option,
1117: FND_API.G_MISS_CHAR, NULL,
1113: FND_API.G_MISS_NUM, NULL,
1114: X_Super_Group_ID),
1115: over_depreciate_option = decode(X_over_depreciate_option,
1116: NULL, over_depreciate_option,
1117: FND_API.G_MISS_CHAR, NULL,
1118: X_Over_Depreciate_Option),
1119: fully_rsvd_revals_counter = decode(X_fully_rsvd_revals_counter,
1120: NULL, fully_rsvd_revals_counter,
1121: FND_API.G_MISS_NUM, NULL,
1117: FND_API.G_MISS_CHAR, NULL,
1118: X_Over_Depreciate_Option),
1119: fully_rsvd_revals_counter = decode(X_fully_rsvd_revals_counter,
1120: NULL, fully_rsvd_revals_counter,
1121: FND_API.G_MISS_NUM, NULL,
1122: X_Fully_Rsvd_Revals_Counter),
1123: capitalized_flag = decode(X_capitalized_flag,
1124: NULL, capitalized_flag,
1125: FND_API.G_MISS_CHAR, NULL,
1121: FND_API.G_MISS_NUM, NULL,
1122: X_Fully_Rsvd_Revals_Counter),
1123: capitalized_flag = decode(X_capitalized_flag,
1124: NULL, capitalized_flag,
1125: FND_API.G_MISS_CHAR, NULL,
1126: X_Capitalized_Flag),
1127: fully_reserved_flag = decode(X_fully_reserved_flag,
1128: NULL, fully_reserved_flag,
1129: FND_API.G_MISS_CHAR, NULL,
1125: FND_API.G_MISS_CHAR, NULL,
1126: X_Capitalized_Flag),
1127: fully_reserved_flag = decode(X_fully_reserved_flag,
1128: NULL, fully_reserved_flag,
1129: FND_API.G_MISS_CHAR, NULL,
1130: X_Fully_Reserved_Flag),
1131: fully_retired_flag = decode(X_fully_retired_flag,
1132: NULL, fully_retired_flag,
1133: FND_API.G_MISS_CHAR, NULL,
1129: FND_API.G_MISS_CHAR, NULL,
1130: X_Fully_Reserved_Flag),
1131: fully_retired_flag = decode(X_fully_retired_flag,
1132: NULL, fully_retired_flag,
1133: FND_API.G_MISS_CHAR, NULL,
1134: X_Fully_Retired_Flag),
1135: life_complete_flag = decode(X_life_complete_flag,
1136: NULL, life_complete_flag,
1137: FND_API.G_MISS_CHAR, NULL,
1133: FND_API.G_MISS_CHAR, NULL,
1134: X_Fully_Retired_Flag),
1135: life_complete_flag = decode(X_life_complete_flag,
1136: NULL, life_complete_flag,
1137: FND_API.G_MISS_CHAR, NULL,
1138: X_Life_Complete_Flag),
1139: terminal_gain_loss_amount = decode(X_terminal_gain_loss_amount,
1140: NULL, terminal_gain_loss_amount,
1141: FND_API.G_MISS_NUM, NULL,
1137: FND_API.G_MISS_CHAR, NULL,
1138: X_Life_Complete_Flag),
1139: terminal_gain_loss_amount = decode(X_terminal_gain_loss_amount,
1140: NULL, terminal_gain_loss_amount,
1141: FND_API.G_MISS_NUM, NULL,
1142: X_Terminal_Gain_Loss_Amount),
1143: terminal_gain_loss_flag = decode(X_terminal_gain_loss_flag,
1144: NULL, terminal_gain_loss_flag,
1145: FND_API.G_MISS_CHAR, NULL,
1141: FND_API.G_MISS_NUM, NULL,
1142: X_Terminal_Gain_Loss_Amount),
1143: terminal_gain_loss_flag = decode(X_terminal_gain_loss_flag,
1144: NULL, terminal_gain_loss_flag,
1145: FND_API.G_MISS_CHAR, NULL,
1146: X_Terminal_Gain_Loss_Flag),
1147: deprn_amount = decode(X_deprn_amount,
1148: NULL, deprn_amount,
1149: FND_API.G_MISS_NUM, NULL,
1145: FND_API.G_MISS_CHAR, NULL,
1146: X_Terminal_Gain_Loss_Flag),
1147: deprn_amount = decode(X_deprn_amount,
1148: NULL, deprn_amount,
1149: FND_API.G_MISS_NUM, NULL,
1150: X_Deprn_Amount),
1151: ytd_deprn = decode(X_ytd_deprn,
1152: NULL, ytd_deprn,
1153: FND_API.G_MISS_NUM, NULL,
1149: FND_API.G_MISS_NUM, NULL,
1150: X_Deprn_Amount),
1151: ytd_deprn = decode(X_ytd_deprn,
1152: NULL, ytd_deprn,
1153: FND_API.G_MISS_NUM, NULL,
1154: X_Ytd_Deprn),
1155: deprn_reserve = decode(X_deprn_reserve,
1156: NULL, deprn_reserve,
1157: FND_API.G_MISS_NUM, NULL,
1153: FND_API.G_MISS_NUM, NULL,
1154: X_Ytd_Deprn),
1155: deprn_reserve = decode(X_deprn_reserve,
1156: NULL, deprn_reserve,
1157: FND_API.G_MISS_NUM, NULL,
1158: X_Deprn_Reserve),
1159: bonus_deprn_amount = decode(X_bonus_deprn_amount,
1160: NULL, bonus_deprn_amount,
1161: FND_API.G_MISS_NUM, NULL,
1157: FND_API.G_MISS_NUM, NULL,
1158: X_Deprn_Reserve),
1159: bonus_deprn_amount = decode(X_bonus_deprn_amount,
1160: NULL, bonus_deprn_amount,
1161: FND_API.G_MISS_NUM, NULL,
1162: X_Bonus_Deprn_Amount),
1163: bonus_ytd_deprn = decode(X_bonus_ytd_deprn,
1164: NULL, bonus_ytd_deprn,
1165: FND_API.G_MISS_NUM, NULL,
1161: FND_API.G_MISS_NUM, NULL,
1162: X_Bonus_Deprn_Amount),
1163: bonus_ytd_deprn = decode(X_bonus_ytd_deprn,
1164: NULL, bonus_ytd_deprn,
1165: FND_API.G_MISS_NUM, NULL,
1166: X_Bonus_Ytd_Deprn),
1167: bonus_deprn_reserve = decode(X_bonus_deprn_reserve,
1168: NULL, bonus_deprn_reserve,
1169: FND_API.G_MISS_NUM, NULL,
1165: FND_API.G_MISS_NUM, NULL,
1166: X_Bonus_Ytd_Deprn),
1167: bonus_deprn_reserve = decode(X_bonus_deprn_reserve,
1168: NULL, bonus_deprn_reserve,
1169: FND_API.G_MISS_NUM, NULL,
1170: X_Bonus_Deprn_Reserve),
1171: bonus_rate = decode(X_bonus_rate,
1172: NULL, bonus_rate,
1173: FND_API.G_MISS_NUM, NULL,
1169: FND_API.G_MISS_NUM, NULL,
1170: X_Bonus_Deprn_Reserve),
1171: bonus_rate = decode(X_bonus_rate,
1172: NULL, bonus_rate,
1173: FND_API.G_MISS_NUM, NULL,
1174: X_Bonus_Rate),
1175: ltd_production = decode(X_ltd_production,
1176: NULL, ltd_production,
1177: FND_API.G_MISS_NUM, NULL,
1173: FND_API.G_MISS_NUM, NULL,
1174: X_Bonus_Rate),
1175: ltd_production = decode(X_ltd_production,
1176: NULL, ltd_production,
1177: FND_API.G_MISS_NUM, NULL,
1178: X_Ltd_Production),
1179: ytd_production = decode(X_ytd_production,
1180: NULL, ytd_production,
1181: FND_API.G_MISS_NUM, NULL,
1177: FND_API.G_MISS_NUM, NULL,
1178: X_Ltd_Production),
1179: ytd_production = decode(X_ytd_production,
1180: NULL, ytd_production,
1181: FND_API.G_MISS_NUM, NULL,
1182: X_Ytd_Production),
1183: production = decode(X_production,
1184: NULL, production,
1185: FND_API.G_MISS_NUM, NULL,
1181: FND_API.G_MISS_NUM, NULL,
1182: X_Ytd_Production),
1183: production = decode(X_production,
1184: NULL, production,
1185: FND_API.G_MISS_NUM, NULL,
1186: X_Production),
1187: reval_amortization = decode(X_reval_amortization,
1188: NULL, reval_amortization,
1189: FND_API.G_MISS_NUM, NULL,
1185: FND_API.G_MISS_NUM, NULL,
1186: X_Production),
1187: reval_amortization = decode(X_reval_amortization,
1188: NULL, reval_amortization,
1189: FND_API.G_MISS_NUM, NULL,
1190: X_Reval_Amortization),
1191: reval_deprn_expense = decode(X_reval_deprn_expense,
1192: NULL, reval_deprn_expense,
1193: FND_API.G_MISS_NUM, NULL,
1189: FND_API.G_MISS_NUM, NULL,
1190: X_Reval_Amortization),
1191: reval_deprn_expense = decode(X_reval_deprn_expense,
1192: NULL, reval_deprn_expense,
1193: FND_API.G_MISS_NUM, NULL,
1194: X_Reval_Deprn_Expense),
1195: reval_reserve = decode(X_reval_reserve,
1196: NULL, reval_reserve,
1197: FND_API.G_MISS_NUM, NULL,
1193: FND_API.G_MISS_NUM, NULL,
1194: X_Reval_Deprn_Expense),
1195: reval_reserve = decode(X_reval_reserve,
1196: NULL, reval_reserve,
1197: FND_API.G_MISS_NUM, NULL,
1198: X_Reval_Reserve),
1199: ytd_reval_deprn_expense = decode(X_ytd_reval_deprn_expense,
1200: NULL, ytd_reval_deprn_expense,
1201: FND_API.G_MISS_NUM, NULL,
1197: FND_API.G_MISS_NUM, NULL,
1198: X_Reval_Reserve),
1199: ytd_reval_deprn_expense = decode(X_ytd_reval_deprn_expense,
1200: NULL, ytd_reval_deprn_expense,
1201: FND_API.G_MISS_NUM, NULL,
1202: X_Ytd_Reval_Deprn_Expense),
1203: deprn_override_flag = decode(X_deprn_override_flag,
1204: NULL, deprn_override_flag,
1205: FND_API.G_MISS_CHAR, NULL,
1201: FND_API.G_MISS_NUM, NULL,
1202: X_Ytd_Reval_Deprn_Expense),
1203: deprn_override_flag = decode(X_deprn_override_flag,
1204: NULL, deprn_override_flag,
1205: FND_API.G_MISS_CHAR, NULL,
1206: X_Deprn_Override_Flag),
1207: system_deprn_amount = decode(X_system_deprn_amount,
1208: NULL, system_deprn_amount,
1209: FND_API.G_MISS_NUM, NULL,
1205: FND_API.G_MISS_CHAR, NULL,
1206: X_Deprn_Override_Flag),
1207: system_deprn_amount = decode(X_system_deprn_amount,
1208: NULL, system_deprn_amount,
1209: FND_API.G_MISS_NUM, NULL,
1210: X_System_Deprn_Amount),
1211: system_bonus_deprn_amount = decode(X_system_bonus_deprn_amount,
1212: NULL, system_bonus_deprn_amount,
1213: FND_API.G_MISS_NUM, NULL,
1209: FND_API.G_MISS_NUM, NULL,
1210: X_System_Deprn_Amount),
1211: system_bonus_deprn_amount = decode(X_system_bonus_deprn_amount,
1212: NULL, system_bonus_deprn_amount,
1213: FND_API.G_MISS_NUM, NULL,
1214: X_System_Bonus_Deprn_Amount),
1215: ytd_proceeds_of_sale = decode(X_ytd_proceeds_of_sale,
1216: NULL, ytd_proceeds_of_sale,
1217: FND_API.G_MISS_NUM, NULL,
1213: FND_API.G_MISS_NUM, NULL,
1214: X_System_Bonus_Deprn_Amount),
1215: ytd_proceeds_of_sale = decode(X_ytd_proceeds_of_sale,
1216: NULL, ytd_proceeds_of_sale,
1217: FND_API.G_MISS_NUM, NULL,
1218: X_Ytd_Proceeds_Of_Sale),
1219: ltd_proceeds_of_sale = decode(X_ltd_proceeds_of_sale,
1220: NULL, ltd_proceeds_of_sale,
1221: FND_API.G_MISS_NUM, NULL,
1217: FND_API.G_MISS_NUM, NULL,
1218: X_Ytd_Proceeds_Of_Sale),
1219: ltd_proceeds_of_sale = decode(X_ltd_proceeds_of_sale,
1220: NULL, ltd_proceeds_of_sale,
1221: FND_API.G_MISS_NUM, NULL,
1222: X_Ltd_Proceeds_Of_Sale),
1223: ytd_cost_of_removal = decode(X_ytd_cost_of_removal,
1224: NULL, ytd_cost_of_removal,
1225: FND_API.G_MISS_NUM, NULL,
1221: FND_API.G_MISS_NUM, NULL,
1222: X_Ltd_Proceeds_Of_Sale),
1223: ytd_cost_of_removal = decode(X_ytd_cost_of_removal,
1224: NULL, ytd_cost_of_removal,
1225: FND_API.G_MISS_NUM, NULL,
1226: X_Ytd_Cost_Of_Removal),
1227: ltd_cost_of_removal = decode(X_ltd_cost_of_removal,
1228: NULL, ltd_cost_of_removal,
1229: FND_API.G_MISS_NUM, NULL,
1225: FND_API.G_MISS_NUM, NULL,
1226: X_Ytd_Cost_Of_Removal),
1227: ltd_cost_of_removal = decode(X_ltd_cost_of_removal,
1228: NULL, ltd_cost_of_removal,
1229: FND_API.G_MISS_NUM, NULL,
1230: X_Ltd_Cost_Of_Removal),
1231: deprn_adjustment_amount = decode(X_deprn_adjustment_amount,
1232: NULL, deprn_adjustment_amount,
1233: FND_API.G_MISS_NUM, NULL,
1229: FND_API.G_MISS_NUM, NULL,
1230: X_Ltd_Cost_Of_Removal),
1231: deprn_adjustment_amount = decode(X_deprn_adjustment_amount,
1232: NULL, deprn_adjustment_amount,
1233: FND_API.G_MISS_NUM, NULL,
1234: X_Deprn_Adjustment_Amount),
1235: expense_adjustment_amount = decode(X_expense_adjustment_amount,
1236: NULL, expense_adjustment_amount,
1237: FND_API.G_MISS_NUM, NULL,
1233: FND_API.G_MISS_NUM, NULL,
1234: X_Deprn_Adjustment_Amount),
1235: expense_adjustment_amount = decode(X_expense_adjustment_amount,
1236: NULL, expense_adjustment_amount,
1237: FND_API.G_MISS_NUM, NULL,
1238: X_Expense_Adjustment_Amount),
1239: unplanned_amount = decode(X_unplanned_amount,
1240: NULL, unplanned_amount,
1241: FND_API.G_MISS_NUM, NULL,
1237: FND_API.G_MISS_NUM, NULL,
1238: X_Expense_Adjustment_Amount),
1239: unplanned_amount = decode(X_unplanned_amount,
1240: NULL, unplanned_amount,
1241: FND_API.G_MISS_NUM, NULL,
1242: X_Unplanned_Amount),
1243: reserve_adjustment_amount = decode(X_reserve_adjustment_amount,
1244: NULL, reserve_adjustment_amount,
1245: FND_API.G_MISS_NUM, NULL,
1241: FND_API.G_MISS_NUM, NULL,
1242: X_Unplanned_Amount),
1243: reserve_adjustment_amount = decode(X_reserve_adjustment_amount,
1244: NULL, reserve_adjustment_amount,
1245: FND_API.G_MISS_NUM, NULL,
1246: X_Reserve_Adjustment_Amount),
1247: creation_date = decode(X_creation_date,
1248: NULL, creation_date,
1249: X_Creation_Date),
1248: NULL, creation_date,
1249: X_Creation_Date),
1250: created_by = decode(X_created_by,
1251: NULL, created_by,
1252: FND_API.G_MISS_NUM, NULL,
1253: X_Created_By),
1254: last_update_date = decode(X_last_update_date,
1255: NULL, last_update_date,
1256: X_Last_Update_Date),
1255: NULL, last_update_date,
1256: X_Last_Update_Date),
1257: last_updated_by = decode(X_last_updated_by,
1258: NULL, last_updated_by,
1259: FND_API.G_MISS_NUM, NULL,
1260: X_Last_Updated_By),
1261: last_update_login = decode(X_last_update_login,
1262: NULL, last_update_login,
1263: FND_API.G_MISS_NUM, NULL,
1259: FND_API.G_MISS_NUM, NULL,
1260: X_Last_Updated_By),
1261: last_update_login = decode(X_last_update_login,
1262: NULL, last_update_login,
1263: FND_API.G_MISS_NUM, NULL,
1264: X_Last_Update_Login),
1265: change_in_eofy_reserve = decode(X_change_in_eofy_reserve,
1266: NULL, change_in_eofy_reserve,
1267: FND_API.G_MISS_NUM, NULL,
1263: FND_API.G_MISS_NUM, NULL,
1264: X_Last_Update_Login),
1265: change_in_eofy_reserve = decode(X_change_in_eofy_reserve,
1266: NULL, change_in_eofy_reserve,
1267: FND_API.G_MISS_NUM, NULL,
1268: X_Change_In_Eofy_Reserve),
1269: switch_code = decode(X_switch_code,
1270: NULL, switch_code,
1271: FND_API.G_MISS_CHAR, NULL,
1267: FND_API.G_MISS_NUM, NULL,
1268: X_Change_In_Eofy_Reserve),
1269: switch_code = decode(X_switch_code,
1270: NULL, switch_code,
1271: FND_API.G_MISS_CHAR, NULL,
1272: X_Switch_Code),
1273: transaction_header_id_in = decode(X_transaction_header_id_in,
1274: NULL, transaction_header_id_in,
1275: FND_API.G_MISS_NUM, NULL,
1271: FND_API.G_MISS_CHAR, NULL,
1272: X_Switch_Code),
1273: transaction_header_id_in = decode(X_transaction_header_id_in,
1274: NULL, transaction_header_id_in,
1275: FND_API.G_MISS_NUM, NULL,
1276: X_transaction_header_id_in),
1277: transaction_header_id_out = decode(X_transaction_header_id_out,
1278: NULL, transaction_header_id_out,
1279: FND_API.G_MISS_NUM, NULL,
1275: FND_API.G_MISS_NUM, NULL,
1276: X_transaction_header_id_in),
1277: transaction_header_id_out = decode(X_transaction_header_id_out,
1278: NULL, transaction_header_id_out,
1279: FND_API.G_MISS_NUM, NULL,
1280: X_transaction_header_id_out),
1281: polish_deprn_basis = decode(X_Polish_Deprn_Basis,
1282: NULL, polish_deprn_basis,
1283: FND_API.G_MISS_NUM, NULL,
1279: FND_API.G_MISS_NUM, NULL,
1280: X_transaction_header_id_out),
1281: polish_deprn_basis = decode(X_Polish_Deprn_Basis,
1282: NULL, polish_deprn_basis,
1283: FND_API.G_MISS_NUM, NULL,
1284: X_polish_deprn_basis),
1285: polish_adj_rec_cost = decode(X_Polish_Adj_Rec_Cost,
1286: NULL, polish_adj_rec_cost,
1287: FND_API.G_MISS_NUM, NULL,
1283: FND_API.G_MISS_NUM, NULL,
1284: X_polish_deprn_basis),
1285: polish_adj_rec_cost = decode(X_Polish_Adj_Rec_Cost,
1286: NULL, polish_adj_rec_cost,
1287: FND_API.G_MISS_NUM, NULL,
1288: X_Polish_Adj_Rec_Cost),
1289: impairment_amount = decode(X_impairment_amount,
1290: NULL, impairment_amount,
1291: FND_API.G_MISS_NUM, NULL,
1287: FND_API.G_MISS_NUM, NULL,
1288: X_Polish_Adj_Rec_Cost),
1289: impairment_amount = decode(X_impairment_amount,
1290: NULL, impairment_amount,
1291: FND_API.G_MISS_NUM, NULL,
1292: X_Impairment_Amount),
1293: ytd_impairment = decode(X_ytd_impairment,
1294: NULL, ytd_impairment,
1295: FND_API.G_MISS_NUM, NULL,
1291: FND_API.G_MISS_NUM, NULL,
1292: X_Impairment_Amount),
1293: ytd_impairment = decode(X_ytd_impairment,
1294: NULL, ytd_impairment,
1295: FND_API.G_MISS_NUM, NULL,
1296: X_Ytd_Impairment),
1297: impairment_reserve = decode(X_impairment_reserve,
1298: NULL, impairment_reserve,
1299: FND_API.G_MISS_NUM, NULL,
1295: FND_API.G_MISS_NUM, NULL,
1296: X_Ytd_Impairment),
1297: impairment_reserve = decode(X_impairment_reserve,
1298: NULL, impairment_reserve,
1299: FND_API.G_MISS_NUM, NULL,
1300: X_impairment_reserve)
1301: WHERE asset_id = X_Asset_Id
1302: AND book_type_code = X_Book_Type_Code
1303: AND period_counter = X_Period_Counter
1308: UPDATE fa_books_summary
1309: SET
1310: book_type_code = decode(X_Book_Type_Code,
1311: NULL, book_type_code,
1312: FND_API.G_MISS_CHAR, NULL,
1313: X_Book_Type_Code),
1314: asset_id = decode(X_Asset_Id,
1315: NULL, asset_id,
1316: FND_API.G_MISS_NUM, NULL,
1312: FND_API.G_MISS_CHAR, NULL,
1313: X_Book_Type_Code),
1314: asset_id = decode(X_Asset_Id,
1315: NULL, asset_id,
1316: FND_API.G_MISS_NUM, NULL,
1317: X_Asset_Id),
1318: period_counter = decode(X_period_counter,
1319: NULL, period_counter,
1320: FND_API.G_MISS_NUM, NULL,
1316: FND_API.G_MISS_NUM, NULL,
1317: X_Asset_Id),
1318: period_counter = decode(X_period_counter,
1319: NULL, period_counter,
1320: FND_API.G_MISS_NUM, NULL,
1321: X_Period_Counter),
1322: fiscal_year = decode(X_fiscal_year,
1323: NULL, fiscal_year,
1324: FND_API.G_MISS_NUM, NULL,
1320: FND_API.G_MISS_NUM, NULL,
1321: X_Period_Counter),
1322: fiscal_year = decode(X_fiscal_year,
1323: NULL, fiscal_year,
1324: FND_API.G_MISS_NUM, NULL,
1325: X_Fiscal_Year),
1326: period_num = decode(X_period_num,
1327: NULL, period_num,
1328: FND_API.G_MISS_NUM, NULL,
1324: FND_API.G_MISS_NUM, NULL,
1325: X_Fiscal_Year),
1326: period_num = decode(X_period_num,
1327: NULL, period_num,
1328: FND_API.G_MISS_NUM, NULL,
1329: X_Period_Num),
1330: calendar_period_open_date = decode(X_calendar_period_open_date,
1331: NULL, calendar_period_open_date,
1332: X_Calendar_Period_Open_Date),
1334: NULL, calendar_period_close_date,
1335: X_Calendar_Period_Close_Date),
1336: reset_adjusted_cost_flag = decode(X_reset_adjusted_cost_flag,
1337: NULL, reset_adjusted_cost_flag,
1338: FND_API.G_MISS_CHAR, NULL,
1339: X_Reset_Adjusted_Cost_Flag),
1340: change_in_cost = decode(X_change_in_cost,
1341: NULL, change_in_cost,
1342: FND_API.G_MISS_NUM, NULL,
1338: FND_API.G_MISS_CHAR, NULL,
1339: X_Reset_Adjusted_Cost_Flag),
1340: change_in_cost = decode(X_change_in_cost,
1341: NULL, change_in_cost,
1342: FND_API.G_MISS_NUM, NULL,
1343: X_Change_In_Cost),
1344: change_in_additions_cost = decode(X_change_in_additions_cost,
1345: NULL, change_in_additions_cost,
1346: FND_API.G_MISS_NUM, NULL,
1342: FND_API.G_MISS_NUM, NULL,
1343: X_Change_In_Cost),
1344: change_in_additions_cost = decode(X_change_in_additions_cost,
1345: NULL, change_in_additions_cost,
1346: FND_API.G_MISS_NUM, NULL,
1347: X_Change_In_Additions_Cost),
1348: change_in_adjustments_cost = decode(X_change_in_adjustments_cost,
1349: NULL, change_in_adjustments_cost,
1350: FND_API.G_MISS_NUM, NULL,
1346: FND_API.G_MISS_NUM, NULL,
1347: X_Change_In_Additions_Cost),
1348: change_in_adjustments_cost = decode(X_change_in_adjustments_cost,
1349: NULL, change_in_adjustments_cost,
1350: FND_API.G_MISS_NUM, NULL,
1351: X_Change_In_Adjustments_Cost),
1352: change_in_retirements_cost = decode(X_change_in_retirements_cost,
1353: NULL, change_in_retirements_cost,
1354: FND_API.G_MISS_NUM, NULL,
1350: FND_API.G_MISS_NUM, NULL,
1351: X_Change_In_Adjustments_Cost),
1352: change_in_retirements_cost = decode(X_change_in_retirements_cost,
1353: NULL, change_in_retirements_cost,
1354: FND_API.G_MISS_NUM, NULL,
1355: X_Change_In_Retirements_Cost),
1356: change_in_group_rec_cost = decode(X_change_in_group_rec_cost,
1357: NULL, change_in_group_rec_cost,
1358: FND_API.G_MISS_NUM, NULL,
1354: FND_API.G_MISS_NUM, NULL,
1355: X_Change_In_Retirements_Cost),
1356: change_in_group_rec_cost = decode(X_change_in_group_rec_cost,
1357: NULL, change_in_group_rec_cost,
1358: FND_API.G_MISS_NUM, NULL,
1359: X_Change_In_Group_Rec_Cost),
1360: change_in_cip_cost = decode(X_change_in_cip_cost,
1361: NULL, change_in_cip_cost,
1362: FND_API.G_MISS_NUM, NULL,
1358: FND_API.G_MISS_NUM, NULL,
1359: X_Change_In_Group_Rec_Cost),
1360: change_in_cip_cost = decode(X_change_in_cip_cost,
1361: NULL, change_in_cip_cost,
1362: FND_API.G_MISS_NUM, NULL,
1363: X_Change_In_CIP_Cost),
1364: cost = decode(X_cost,
1365: NULL, cost,
1366: FND_API.G_MISS_NUM, NULL,
1362: FND_API.G_MISS_NUM, NULL,
1363: X_Change_In_CIP_Cost),
1364: cost = decode(X_cost,
1365: NULL, cost,
1366: FND_API.G_MISS_NUM, NULL,
1367: X_Cost),
1368: cip_cost = decode(X_cip_cost,
1369: NULL, cip_cost,
1370: FND_API.G_MISS_NUM, NULL,
1366: FND_API.G_MISS_NUM, NULL,
1367: X_Cost),
1368: cip_cost = decode(X_cip_cost,
1369: NULL, cip_cost,
1370: FND_API.G_MISS_NUM, NULL,
1371: X_CIP_Cost),
1372: salvage_type = decode(X_salvage_type,
1373: NULL, salvage_type,
1374: FND_API.G_MISS_CHAR, NULL,
1370: FND_API.G_MISS_NUM, NULL,
1371: X_CIP_Cost),
1372: salvage_type = decode(X_salvage_type,
1373: NULL, salvage_type,
1374: FND_API.G_MISS_CHAR, NULL,
1375: X_Salvage_Type),
1376: percent_salvage_value = decode(X_percent_salvage_value,
1377: NULL, percent_salvage_value,
1378: FND_API.G_MISS_NUM, NULL,
1374: FND_API.G_MISS_CHAR, NULL,
1375: X_Salvage_Type),
1376: percent_salvage_value = decode(X_percent_salvage_value,
1377: NULL, percent_salvage_value,
1378: FND_API.G_MISS_NUM, NULL,
1379: X_Percent_Salvage_Value),
1380: salvage_value = decode(X_salvage_value,
1381: NULL, salvage_value,
1382: FND_API.G_MISS_NUM, NULL,
1378: FND_API.G_MISS_NUM, NULL,
1379: X_Percent_Salvage_Value),
1380: salvage_value = decode(X_salvage_value,
1381: NULL, salvage_value,
1382: FND_API.G_MISS_NUM, NULL,
1383: X_Salvage_Value),
1384: member_salvage_value = decode(X_member_salvage_value,
1385: NULL, member_salvage_value,
1386: FND_API.G_MISS_NUM, NULL,
1382: FND_API.G_MISS_NUM, NULL,
1383: X_Salvage_Value),
1384: member_salvage_value = decode(X_member_salvage_value,
1385: NULL, member_salvage_value,
1386: FND_API.G_MISS_NUM, NULL,
1387: X_Member_Salvage_Value),
1388: recoverable_cost = decode(X_recoverable_cost,
1389: NULL, recoverable_cost,
1390: FND_API.G_MISS_NUM, NULL,
1386: FND_API.G_MISS_NUM, NULL,
1387: X_Member_Salvage_Value),
1388: recoverable_cost = decode(X_recoverable_cost,
1389: NULL, recoverable_cost,
1390: FND_API.G_MISS_NUM, NULL,
1391: X_Recoverable_Cost),
1392: deprn_limit_type = decode(X_deprn_limit_type,
1393: NULL, deprn_limit_type,
1394: FND_API.G_MISS_CHAR, NULL,
1390: FND_API.G_MISS_NUM, NULL,
1391: X_Recoverable_Cost),
1392: deprn_limit_type = decode(X_deprn_limit_type,
1393: NULL, deprn_limit_type,
1394: FND_API.G_MISS_CHAR, NULL,
1395: X_Deprn_Limit_Type),
1396: allowed_deprn_limit = decode(X_allowed_deprn_limit,
1397: NULL, allowed_deprn_limit,
1398: FND_API.G_MISS_NUM, NULL,
1394: FND_API.G_MISS_CHAR, NULL,
1395: X_Deprn_Limit_Type),
1396: allowed_deprn_limit = decode(X_allowed_deprn_limit,
1397: NULL, allowed_deprn_limit,
1398: FND_API.G_MISS_NUM, NULL,
1399: X_Allowed_Deprn_Limit),
1400: allowed_deprn_limit_amount = decode(X_allowed_deprn_limit_amount,
1401: NULL, allowed_deprn_limit_amount,
1402: FND_API.G_MISS_NUM, NULL,
1398: FND_API.G_MISS_NUM, NULL,
1399: X_Allowed_Deprn_Limit),
1400: allowed_deprn_limit_amount = decode(X_allowed_deprn_limit_amount,
1401: NULL, allowed_deprn_limit_amount,
1402: FND_API.G_MISS_NUM, NULL,
1403: X_Allowed_Deprn_Limit_Amount),
1404: member_deprn_limit_amount = decode(X_member_deprn_limit_amount,
1405: NULL, member_deprn_limit_amount,
1406: FND_API.G_MISS_NUM, NULL,
1402: FND_API.G_MISS_NUM, NULL,
1403: X_Allowed_Deprn_Limit_Amount),
1404: member_deprn_limit_amount = decode(X_member_deprn_limit_amount,
1405: NULL, member_deprn_limit_amount,
1406: FND_API.G_MISS_NUM, NULL,
1407: X_Member_Deprn_Limit_Amount),
1408: adjusted_recoverable_cost = decode(X_adjusted_recoverable_cost,
1409: NULL, adjusted_recoverable_cost,
1410: FND_API.G_MISS_NUM, NULL,
1406: FND_API.G_MISS_NUM, NULL,
1407: X_Member_Deprn_Limit_Amount),
1408: adjusted_recoverable_cost = decode(X_adjusted_recoverable_cost,
1409: NULL, adjusted_recoverable_cost,
1410: FND_API.G_MISS_NUM, NULL,
1411: X_Adjusted_Recoverable_Cost),
1412: adjusted_cost = decode(X_adjusted_cost,
1413: NULL, adjusted_cost,
1414: FND_API.G_MISS_NUM, NULL,
1410: FND_API.G_MISS_NUM, NULL,
1411: X_Adjusted_Recoverable_Cost),
1412: adjusted_cost = decode(X_adjusted_cost,
1413: NULL, adjusted_cost,
1414: FND_API.G_MISS_NUM, NULL,
1415: X_Adjusted_Cost),
1416: depreciate_flag = decode(X_depreciate_flag,
1417: NULL, depreciate_flag,
1418: FND_API.G_MISS_CHAR, NULL,
1414: FND_API.G_MISS_NUM, NULL,
1415: X_Adjusted_Cost),
1416: depreciate_flag = decode(X_depreciate_flag,
1417: NULL, depreciate_flag,
1418: FND_API.G_MISS_CHAR, NULL,
1419: X_Depreciate_Flag),
1420: disabled_flag = decode(X_disabled_flag,
1421: NULL, disabled_flag,
1422: FND_API.G_MISS_CHAR, NULL,
1418: FND_API.G_MISS_CHAR, NULL,
1419: X_Depreciate_Flag),
1420: disabled_flag = decode(X_disabled_flag,
1421: NULL, disabled_flag,
1422: FND_API.G_MISS_CHAR, NULL,
1423: X_Disabled_Flag),
1424: date_placed_in_service = decode(X_date_placed_in_service,
1425: NULL, date_placed_in_service,
1426: X_Date_Placed_In_Service),
1425: NULL, date_placed_in_service,
1426: X_Date_Placed_In_Service),
1427: deprn_method_code = decode(X_deprn_method_code,
1428: NULL, deprn_method_code,
1429: FND_API.G_MISS_CHAR, NULL,
1430: X_Deprn_Method_Code),
1431: life_in_months = decode(X_life_in_months,
1432: NULL, life_in_months,
1433: FND_API.G_MISS_NUM, NULL,
1429: FND_API.G_MISS_CHAR, NULL,
1430: X_Deprn_Method_Code),
1431: life_in_months = decode(X_life_in_months,
1432: NULL, life_in_months,
1433: FND_API.G_MISS_NUM, NULL,
1434: X_Life_In_Months),
1435: rate_adjustment_factor = decode(X_rate_adjustment_factor,
1436: NULL, rate_adjustment_factor,
1437: FND_API.G_MISS_NUM, NULL,
1433: FND_API.G_MISS_NUM, NULL,
1434: X_Life_In_Months),
1435: rate_adjustment_factor = decode(X_rate_adjustment_factor,
1436: NULL, rate_adjustment_factor,
1437: FND_API.G_MISS_NUM, NULL,
1438: X_Rate_Adjustment_Factor),
1439: adjusted_rate = decode(X_adjusted_rate,
1440: NULL, adjusted_rate,
1441: FND_API.G_MISS_NUM, NULL,
1437: FND_API.G_MISS_NUM, NULL,
1438: X_Rate_Adjustment_Factor),
1439: adjusted_rate = decode(X_adjusted_rate,
1440: NULL, adjusted_rate,
1441: FND_API.G_MISS_NUM, NULL,
1442: X_Adjusted_Rate),
1443: bonus_rule = decode(X_bonus_rule,
1444: NULL, bonus_rule,
1445: FND_API.G_MISS_CHAR, NULL,
1441: FND_API.G_MISS_NUM, NULL,
1442: X_Adjusted_Rate),
1443: bonus_rule = decode(X_bonus_rule,
1444: NULL, bonus_rule,
1445: FND_API.G_MISS_CHAR, NULL,
1446: X_Bonus_Rule),
1447: adjusted_capacity = decode(X_adjusted_capacity,
1448: NULL, adjusted_capacity,
1449: FND_API.G_MISS_NUM, NULL,
1445: FND_API.G_MISS_CHAR, NULL,
1446: X_Bonus_Rule),
1447: adjusted_capacity = decode(X_adjusted_capacity,
1448: NULL, adjusted_capacity,
1449: FND_API.G_MISS_NUM, NULL,
1450: X_Adjusted_Capacity),
1451: production_capacity = decode(X_production_capacity,
1452: NULL, production_capacity,
1453: FND_API.G_MISS_NUM, NULL,
1449: FND_API.G_MISS_NUM, NULL,
1450: X_Adjusted_Capacity),
1451: production_capacity = decode(X_production_capacity,
1452: NULL, production_capacity,
1453: FND_API.G_MISS_NUM, NULL,
1454: X_Production_Capacity),
1455: unit_of_measure = decode(X_unit_of_measure,
1456: NULL, unit_of_measure,
1457: FND_API.G_MISS_CHAR, NULL,
1453: FND_API.G_MISS_NUM, NULL,
1454: X_Production_Capacity),
1455: unit_of_measure = decode(X_unit_of_measure,
1456: NULL, unit_of_measure,
1457: FND_API.G_MISS_CHAR, NULL,
1458: X_Unit_Of_Measure),
1459: remaining_life1 = decode(X_remaining_life1,
1460: NULL, remaining_life1,
1461: FND_API.G_MISS_NUM, NULL,
1457: FND_API.G_MISS_CHAR, NULL,
1458: X_Unit_Of_Measure),
1459: remaining_life1 = decode(X_remaining_life1,
1460: NULL, remaining_life1,
1461: FND_API.G_MISS_NUM, NULL,
1462: X_Remaining_Life1),
1463: remaining_life2 = decode(X_remaining_life2,
1464: NULL, remaining_life2,
1465: FND_API.G_MISS_NUM, NULL,
1461: FND_API.G_MISS_NUM, NULL,
1462: X_Remaining_Life1),
1463: remaining_life2 = decode(X_remaining_life2,
1464: NULL, remaining_life2,
1465: FND_API.G_MISS_NUM, NULL,
1466: X_Remaining_Life2),
1467: formula_factor = decode(X_formula_factor,
1468: NULL, formula_factor,
1469: FND_API.G_MISS_NUM, NULL,
1465: FND_API.G_MISS_NUM, NULL,
1466: X_Remaining_Life2),
1467: formula_factor = decode(X_formula_factor,
1468: NULL, formula_factor,
1469: FND_API.G_MISS_NUM, NULL,
1470: X_Formula_Factor),
1471: unrevalued_cost = decode(X_unrevalued_cost,
1472: NULL, unrevalued_cost,
1473: FND_API.G_MISS_NUM, NULL,
1469: FND_API.G_MISS_NUM, NULL,
1470: X_Formula_Factor),
1471: unrevalued_cost = decode(X_unrevalued_cost,
1472: NULL, unrevalued_cost,
1473: FND_API.G_MISS_NUM, NULL,
1474: X_Unrevalued_Cost),
1475: reval_amortization_basis = decode(X_reval_amortization_basis,
1476: NULL, reval_amortization_basis,
1477: FND_API.G_MISS_NUM, NULL,
1473: FND_API.G_MISS_NUM, NULL,
1474: X_Unrevalued_Cost),
1475: reval_amortization_basis = decode(X_reval_amortization_basis,
1476: NULL, reval_amortization_basis,
1477: FND_API.G_MISS_NUM, NULL,
1478: X_Reval_Amortization_Basis),
1479: reval_ceiling = decode(X_reval_ceiling,
1480: NULL, reval_ceiling,
1481: FND_API.G_MISS_NUM, NULL,
1477: FND_API.G_MISS_NUM, NULL,
1478: X_Reval_Amortization_Basis),
1479: reval_ceiling = decode(X_reval_ceiling,
1480: NULL, reval_ceiling,
1481: FND_API.G_MISS_NUM, NULL,
1482: X_Reval_Ceiling),
1483: ceiling_name = decode(X_ceiling_name,
1484: NULL, ceiling_name,
1485: FND_API.G_MISS_CHAR, NULL,
1481: FND_API.G_MISS_NUM, NULL,
1482: X_Reval_Ceiling),
1483: ceiling_name = decode(X_ceiling_name,
1484: NULL, ceiling_name,
1485: FND_API.G_MISS_CHAR, NULL,
1486: X_Ceiling_Name),
1487: eofy_adj_cost = decode(X_eofy_adj_cost,
1488: NULL, eofy_adj_cost,
1489: FND_API.G_MISS_NUM, NULL,
1485: FND_API.G_MISS_CHAR, NULL,
1486: X_Ceiling_Name),
1487: eofy_adj_cost = decode(X_eofy_adj_cost,
1488: NULL, eofy_adj_cost,
1489: FND_API.G_MISS_NUM, NULL,
1490: X_Eofy_Adj_Cost),
1491: eofy_formula_factor = decode(X_eofy_formula_factor,
1492: NULL, eofy_formula_factor,
1493: FND_API.G_MISS_NUM, NULL,
1489: FND_API.G_MISS_NUM, NULL,
1490: X_Eofy_Adj_Cost),
1491: eofy_formula_factor = decode(X_eofy_formula_factor,
1492: NULL, eofy_formula_factor,
1493: FND_API.G_MISS_NUM, NULL,
1494: X_Eofy_Formula_Factor),
1495: eofy_reserve = decode(X_eofy_reserve,
1496: NULL, eofy_reserve,
1497: FND_API.G_MISS_NUM, NULL,
1493: FND_API.G_MISS_NUM, NULL,
1494: X_Eofy_Formula_Factor),
1495: eofy_reserve = decode(X_eofy_reserve,
1496: NULL, eofy_reserve,
1497: FND_API.G_MISS_NUM, NULL,
1498: X_Eofy_Reserve),
1499: eop_adj_cost = decode(X_eop_adj_cost,
1500: NULL, eop_adj_cost,
1501: FND_API.G_MISS_NUM, NULL,
1497: FND_API.G_MISS_NUM, NULL,
1498: X_Eofy_Reserve),
1499: eop_adj_cost = decode(X_eop_adj_cost,
1500: NULL, eop_adj_cost,
1501: FND_API.G_MISS_NUM, NULL,
1502: X_Eop_Adj_Cost),
1503: eop_formula_factor = decode(X_eop_formula_factor,
1504: NULL, eop_formula_factor,
1505: FND_API.G_MISS_NUM, NULL,
1501: FND_API.G_MISS_NUM, NULL,
1502: X_Eop_Adj_Cost),
1503: eop_formula_factor = decode(X_eop_formula_factor,
1504: NULL, eop_formula_factor,
1505: FND_API.G_MISS_NUM, NULL,
1506: X_Eop_Formula_Factor),
1507: short_fiscal_year_flag = decode(X_short_fiscal_year_flag,
1508: NULL, short_fiscal_year_flag,
1509: FND_API.G_MISS_CHAR, NULL,
1505: FND_API.G_MISS_NUM, NULL,
1506: X_Eop_Formula_Factor),
1507: short_fiscal_year_flag = decode(X_short_fiscal_year_flag,
1508: NULL, short_fiscal_year_flag,
1509: FND_API.G_MISS_CHAR, NULL,
1510: X_Short_Fiscal_Year_Flag),
1511: group_asset_id = decode(X_group_asset_id,
1512: NULL, group_asset_id,
1513: FND_API.G_MISS_NUM, NULL,
1509: FND_API.G_MISS_CHAR, NULL,
1510: X_Short_Fiscal_Year_Flag),
1511: group_asset_id = decode(X_group_asset_id,
1512: NULL, group_asset_id,
1513: FND_API.G_MISS_NUM, NULL,
1514: X_Group_Asset_ID),
1515: super_group_id = decode(X_super_group_id,
1516: NULL, super_group_id,
1517: FND_API.G_MISS_NUM, NULL,
1513: FND_API.G_MISS_NUM, NULL,
1514: X_Group_Asset_ID),
1515: super_group_id = decode(X_super_group_id,
1516: NULL, super_group_id,
1517: FND_API.G_MISS_NUM, NULL,
1518: X_Super_Group_ID),
1519: over_depreciate_option = decode(X_over_depreciate_option,
1520: NULL, over_depreciate_option,
1521: FND_API.G_MISS_CHAR, NULL,
1517: FND_API.G_MISS_NUM, NULL,
1518: X_Super_Group_ID),
1519: over_depreciate_option = decode(X_over_depreciate_option,
1520: NULL, over_depreciate_option,
1521: FND_API.G_MISS_CHAR, NULL,
1522: X_Over_Depreciate_Option),
1523: fully_rsvd_revals_counter = decode(X_fully_rsvd_revals_counter,
1524: NULL, fully_rsvd_revals_counter,
1525: FND_API.G_MISS_NUM, NULL,
1521: FND_API.G_MISS_CHAR, NULL,
1522: X_Over_Depreciate_Option),
1523: fully_rsvd_revals_counter = decode(X_fully_rsvd_revals_counter,
1524: NULL, fully_rsvd_revals_counter,
1525: FND_API.G_MISS_NUM, NULL,
1526: X_Fully_Rsvd_Revals_Counter),
1527: capitalized_flag = decode(X_capitalized_flag,
1528: NULL, capitalized_flag,
1529: FND_API.G_MISS_CHAR, NULL,
1525: FND_API.G_MISS_NUM, NULL,
1526: X_Fully_Rsvd_Revals_Counter),
1527: capitalized_flag = decode(X_capitalized_flag,
1528: NULL, capitalized_flag,
1529: FND_API.G_MISS_CHAR, NULL,
1530: X_Capitalized_Flag),
1531: fully_reserved_flag = decode(X_fully_reserved_flag,
1532: NULL, fully_reserved_flag,
1533: FND_API.G_MISS_CHAR, NULL,
1529: FND_API.G_MISS_CHAR, NULL,
1530: X_Capitalized_Flag),
1531: fully_reserved_flag = decode(X_fully_reserved_flag,
1532: NULL, fully_reserved_flag,
1533: FND_API.G_MISS_CHAR, NULL,
1534: X_Fully_Reserved_Flag),
1535: fully_retired_flag = decode(X_fully_retired_flag,
1536: NULL, fully_retired_flag,
1537: FND_API.G_MISS_CHAR, NULL,
1533: FND_API.G_MISS_CHAR, NULL,
1534: X_Fully_Reserved_Flag),
1535: fully_retired_flag = decode(X_fully_retired_flag,
1536: NULL, fully_retired_flag,
1537: FND_API.G_MISS_CHAR, NULL,
1538: X_Fully_Retired_Flag),
1539: life_complete_flag = decode(X_life_complete_flag,
1540: NULL, life_complete_flag,
1541: FND_API.G_MISS_CHAR, NULL,
1537: FND_API.G_MISS_CHAR, NULL,
1538: X_Fully_Retired_Flag),
1539: life_complete_flag = decode(X_life_complete_flag,
1540: NULL, life_complete_flag,
1541: FND_API.G_MISS_CHAR, NULL,
1542: X_Life_Complete_Flag),
1543: terminal_gain_loss_amount = decode(X_terminal_gain_loss_amount,
1544: NULL, terminal_gain_loss_amount,
1545: FND_API.G_MISS_NUM, NULL,
1541: FND_API.G_MISS_CHAR, NULL,
1542: X_Life_Complete_Flag),
1543: terminal_gain_loss_amount = decode(X_terminal_gain_loss_amount,
1544: NULL, terminal_gain_loss_amount,
1545: FND_API.G_MISS_NUM, NULL,
1546: X_Terminal_Gain_Loss_Amount),
1547: terminal_gain_loss_flag = decode(X_terminal_gain_loss_flag,
1548: NULL, terminal_gain_loss_flag,
1549: FND_API.G_MISS_CHAR, NULL,
1545: FND_API.G_MISS_NUM, NULL,
1546: X_Terminal_Gain_Loss_Amount),
1547: terminal_gain_loss_flag = decode(X_terminal_gain_loss_flag,
1548: NULL, terminal_gain_loss_flag,
1549: FND_API.G_MISS_CHAR, NULL,
1550: X_Terminal_Gain_Loss_Flag),
1551: deprn_amount = decode(X_deprn_amount,
1552: NULL, deprn_amount,
1553: FND_API.G_MISS_NUM, NULL,
1549: FND_API.G_MISS_CHAR, NULL,
1550: X_Terminal_Gain_Loss_Flag),
1551: deprn_amount = decode(X_deprn_amount,
1552: NULL, deprn_amount,
1553: FND_API.G_MISS_NUM, NULL,
1554: X_Deprn_Amount),
1555: ytd_deprn = decode(X_ytd_deprn,
1556: NULL, ytd_deprn,
1557: FND_API.G_MISS_NUM, NULL,
1553: FND_API.G_MISS_NUM, NULL,
1554: X_Deprn_Amount),
1555: ytd_deprn = decode(X_ytd_deprn,
1556: NULL, ytd_deprn,
1557: FND_API.G_MISS_NUM, NULL,
1558: X_Ytd_Deprn),
1559: deprn_reserve = decode(X_deprn_reserve,
1560: NULL, deprn_reserve,
1561: FND_API.G_MISS_NUM, NULL,
1557: FND_API.G_MISS_NUM, NULL,
1558: X_Ytd_Deprn),
1559: deprn_reserve = decode(X_deprn_reserve,
1560: NULL, deprn_reserve,
1561: FND_API.G_MISS_NUM, NULL,
1562: X_Deprn_Reserve),
1563: bonus_deprn_amount = decode(X_bonus_deprn_amount,
1564: NULL, bonus_deprn_amount,
1565: FND_API.G_MISS_NUM, NULL,
1561: FND_API.G_MISS_NUM, NULL,
1562: X_Deprn_Reserve),
1563: bonus_deprn_amount = decode(X_bonus_deprn_amount,
1564: NULL, bonus_deprn_amount,
1565: FND_API.G_MISS_NUM, NULL,
1566: X_Bonus_Deprn_Amount),
1567: bonus_ytd_deprn = decode(X_bonus_ytd_deprn,
1568: NULL, bonus_ytd_deprn,
1569: FND_API.G_MISS_NUM, NULL,
1565: FND_API.G_MISS_NUM, NULL,
1566: X_Bonus_Deprn_Amount),
1567: bonus_ytd_deprn = decode(X_bonus_ytd_deprn,
1568: NULL, bonus_ytd_deprn,
1569: FND_API.G_MISS_NUM, NULL,
1570: X_Bonus_Ytd_Deprn),
1571: bonus_deprn_reserve = decode(X_bonus_deprn_reserve,
1572: NULL, bonus_deprn_reserve,
1573: FND_API.G_MISS_NUM, NULL,
1569: FND_API.G_MISS_NUM, NULL,
1570: X_Bonus_Ytd_Deprn),
1571: bonus_deprn_reserve = decode(X_bonus_deprn_reserve,
1572: NULL, bonus_deprn_reserve,
1573: FND_API.G_MISS_NUM, NULL,
1574: X_Bonus_Deprn_Reserve),
1575: bonus_rate = decode(X_bonus_rate,
1576: NULL, bonus_rate,
1577: FND_API.G_MISS_NUM, NULL,
1573: FND_API.G_MISS_NUM, NULL,
1574: X_Bonus_Deprn_Reserve),
1575: bonus_rate = decode(X_bonus_rate,
1576: NULL, bonus_rate,
1577: FND_API.G_MISS_NUM, NULL,
1578: X_Bonus_Rate),
1579: ltd_production = decode(X_ltd_production,
1580: NULL, ltd_production,
1581: FND_API.G_MISS_NUM, NULL,
1577: FND_API.G_MISS_NUM, NULL,
1578: X_Bonus_Rate),
1579: ltd_production = decode(X_ltd_production,
1580: NULL, ltd_production,
1581: FND_API.G_MISS_NUM, NULL,
1582: X_Ltd_Production),
1583: ytd_production = decode(X_ytd_production,
1584: NULL, ytd_production,
1585: FND_API.G_MISS_NUM, NULL,
1581: FND_API.G_MISS_NUM, NULL,
1582: X_Ltd_Production),
1583: ytd_production = decode(X_ytd_production,
1584: NULL, ytd_production,
1585: FND_API.G_MISS_NUM, NULL,
1586: X_Ytd_Production),
1587: production = decode(X_production,
1588: NULL, production,
1589: FND_API.G_MISS_NUM, NULL,
1585: FND_API.G_MISS_NUM, NULL,
1586: X_Ytd_Production),
1587: production = decode(X_production,
1588: NULL, production,
1589: FND_API.G_MISS_NUM, NULL,
1590: X_Production),
1591: reval_amortization = decode(X_reval_amortization,
1592: NULL, reval_amortization,
1593: FND_API.G_MISS_NUM, NULL,
1589: FND_API.G_MISS_NUM, NULL,
1590: X_Production),
1591: reval_amortization = decode(X_reval_amortization,
1592: NULL, reval_amortization,
1593: FND_API.G_MISS_NUM, NULL,
1594: X_Reval_Amortization),
1595: reval_deprn_expense = decode(X_reval_deprn_expense,
1596: NULL, reval_deprn_expense,
1597: FND_API.G_MISS_NUM, NULL,
1593: FND_API.G_MISS_NUM, NULL,
1594: X_Reval_Amortization),
1595: reval_deprn_expense = decode(X_reval_deprn_expense,
1596: NULL, reval_deprn_expense,
1597: FND_API.G_MISS_NUM, NULL,
1598: X_Reval_Deprn_Expense),
1599: reval_reserve = decode(X_reval_reserve,
1600: NULL, reval_reserve,
1601: FND_API.G_MISS_NUM, NULL,
1597: FND_API.G_MISS_NUM, NULL,
1598: X_Reval_Deprn_Expense),
1599: reval_reserve = decode(X_reval_reserve,
1600: NULL, reval_reserve,
1601: FND_API.G_MISS_NUM, NULL,
1602: X_Reval_Reserve),
1603: ytd_reval_deprn_expense = decode(X_ytd_reval_deprn_expense,
1604: NULL, ytd_reval_deprn_expense,
1605: FND_API.G_MISS_NUM, NULL,
1601: FND_API.G_MISS_NUM, NULL,
1602: X_Reval_Reserve),
1603: ytd_reval_deprn_expense = decode(X_ytd_reval_deprn_expense,
1604: NULL, ytd_reval_deprn_expense,
1605: FND_API.G_MISS_NUM, NULL,
1606: X_Ytd_Reval_Deprn_Expense),
1607: deprn_override_flag = decode(X_deprn_override_flag,
1608: NULL, deprn_override_flag,
1609: FND_API.G_MISS_CHAR, NULL,
1605: FND_API.G_MISS_NUM, NULL,
1606: X_Ytd_Reval_Deprn_Expense),
1607: deprn_override_flag = decode(X_deprn_override_flag,
1608: NULL, deprn_override_flag,
1609: FND_API.G_MISS_CHAR, NULL,
1610: X_Deprn_Override_Flag),
1611: system_deprn_amount = decode(X_system_deprn_amount,
1612: NULL, system_deprn_amount,
1613: FND_API.G_MISS_NUM, NULL,
1609: FND_API.G_MISS_CHAR, NULL,
1610: X_Deprn_Override_Flag),
1611: system_deprn_amount = decode(X_system_deprn_amount,
1612: NULL, system_deprn_amount,
1613: FND_API.G_MISS_NUM, NULL,
1614: X_System_Deprn_Amount),
1615: system_bonus_deprn_amount = decode(X_system_bonus_deprn_amount,
1616: NULL, system_bonus_deprn_amount,
1617: FND_API.G_MISS_NUM, NULL,
1613: FND_API.G_MISS_NUM, NULL,
1614: X_System_Deprn_Amount),
1615: system_bonus_deprn_amount = decode(X_system_bonus_deprn_amount,
1616: NULL, system_bonus_deprn_amount,
1617: FND_API.G_MISS_NUM, NULL,
1618: X_System_Bonus_Deprn_Amount),
1619: ytd_proceeds_of_sale = decode(X_ytd_proceeds_of_sale,
1620: NULL, ytd_proceeds_of_sale,
1621: FND_API.G_MISS_NUM, NULL,
1617: FND_API.G_MISS_NUM, NULL,
1618: X_System_Bonus_Deprn_Amount),
1619: ytd_proceeds_of_sale = decode(X_ytd_proceeds_of_sale,
1620: NULL, ytd_proceeds_of_sale,
1621: FND_API.G_MISS_NUM, NULL,
1622: X_Ytd_Proceeds_Of_Sale),
1623: ltd_proceeds_of_sale = decode(X_ltd_proceeds_of_sale,
1624: NULL, ltd_proceeds_of_sale,
1625: FND_API.G_MISS_NUM, NULL,
1621: FND_API.G_MISS_NUM, NULL,
1622: X_Ytd_Proceeds_Of_Sale),
1623: ltd_proceeds_of_sale = decode(X_ltd_proceeds_of_sale,
1624: NULL, ltd_proceeds_of_sale,
1625: FND_API.G_MISS_NUM, NULL,
1626: X_Ltd_Proceeds_Of_Sale),
1627: ytd_cost_of_removal = decode(X_ytd_cost_of_removal,
1628: NULL, ytd_cost_of_removal,
1629: FND_API.G_MISS_NUM, NULL,
1625: FND_API.G_MISS_NUM, NULL,
1626: X_Ltd_Proceeds_Of_Sale),
1627: ytd_cost_of_removal = decode(X_ytd_cost_of_removal,
1628: NULL, ytd_cost_of_removal,
1629: FND_API.G_MISS_NUM, NULL,
1630: X_Ytd_Cost_Of_Removal),
1631: ltd_cost_of_removal = decode(X_ltd_cost_of_removal,
1632: NULL, ltd_cost_of_removal,
1633: FND_API.G_MISS_NUM, NULL,
1629: FND_API.G_MISS_NUM, NULL,
1630: X_Ytd_Cost_Of_Removal),
1631: ltd_cost_of_removal = decode(X_ltd_cost_of_removal,
1632: NULL, ltd_cost_of_removal,
1633: FND_API.G_MISS_NUM, NULL,
1634: X_Ltd_Cost_Of_Removal),
1635: deprn_adjustment_amount = decode(X_deprn_adjustment_amount,
1636: NULL, deprn_adjustment_amount,
1637: FND_API.G_MISS_NUM, NULL,
1633: FND_API.G_MISS_NUM, NULL,
1634: X_Ltd_Cost_Of_Removal),
1635: deprn_adjustment_amount = decode(X_deprn_adjustment_amount,
1636: NULL, deprn_adjustment_amount,
1637: FND_API.G_MISS_NUM, NULL,
1638: X_Deprn_Adjustment_Amount),
1639: expense_adjustment_amount = decode(X_expense_adjustment_amount,
1640: NULL, expense_adjustment_amount,
1641: FND_API.G_MISS_NUM, NULL,
1637: FND_API.G_MISS_NUM, NULL,
1638: X_Deprn_Adjustment_Amount),
1639: expense_adjustment_amount = decode(X_expense_adjustment_amount,
1640: NULL, expense_adjustment_amount,
1641: FND_API.G_MISS_NUM, NULL,
1642: X_Expense_Adjustment_Amount),
1643: unplanned_amount = decode(X_unplanned_amount,
1644: NULL, unplanned_amount,
1645: FND_API.G_MISS_NUM, NULL,
1641: FND_API.G_MISS_NUM, NULL,
1642: X_Expense_Adjustment_Amount),
1643: unplanned_amount = decode(X_unplanned_amount,
1644: NULL, unplanned_amount,
1645: FND_API.G_MISS_NUM, NULL,
1646: X_Unplanned_Amount),
1647: reserve_adjustment_amount = decode(X_reserve_adjustment_amount,
1648: NULL, reserve_adjustment_amount,
1649: FND_API.G_MISS_NUM, NULL,
1645: FND_API.G_MISS_NUM, NULL,
1646: X_Unplanned_Amount),
1647: reserve_adjustment_amount = decode(X_reserve_adjustment_amount,
1648: NULL, reserve_adjustment_amount,
1649: FND_API.G_MISS_NUM, NULL,
1650: X_Reserve_Adjustment_Amount),
1651: creation_date = decode(X_creation_date,
1652: NULL, creation_date,
1653: X_Creation_Date),
1652: NULL, creation_date,
1653: X_Creation_Date),
1654: created_by = decode(X_created_by,
1655: NULL, created_by,
1656: FND_API.G_MISS_NUM, NULL,
1657: X_Created_By),
1658: last_update_date = decode(X_last_update_date,
1659: NULL, last_update_date,
1660: X_Last_Update_Date),
1659: NULL, last_update_date,
1660: X_Last_Update_Date),
1661: last_updated_by = decode(X_last_updated_by,
1662: NULL, last_updated_by,
1663: FND_API.G_MISS_NUM, NULL,
1664: X_Last_Updated_By),
1665: last_update_login = decode(X_last_update_login,
1666: NULL, last_update_login,
1667: FND_API.G_MISS_NUM, NULL,
1663: FND_API.G_MISS_NUM, NULL,
1664: X_Last_Updated_By),
1665: last_update_login = decode(X_last_update_login,
1666: NULL, last_update_login,
1667: FND_API.G_MISS_NUM, NULL,
1668: X_Last_Update_Login),
1669: change_in_eofy_reserve = decode(X_change_in_eofy_reserve,
1670: NULL, change_in_eofy_reserve,
1671: FND_API.G_MISS_NUM, NULL,
1667: FND_API.G_MISS_NUM, NULL,
1668: X_Last_Update_Login),
1669: change_in_eofy_reserve = decode(X_change_in_eofy_reserve,
1670: NULL, change_in_eofy_reserve,
1671: FND_API.G_MISS_NUM, NULL,
1672: X_Change_In_Eofy_Reserve),
1673: switch_code = decode(X_switch_code,
1674: NULL, switch_code,
1675: FND_API.G_MISS_CHAR, NULL,
1671: FND_API.G_MISS_NUM, NULL,
1672: X_Change_In_Eofy_Reserve),
1673: switch_code = decode(X_switch_code,
1674: NULL, switch_code,
1675: FND_API.G_MISS_CHAR, NULL,
1676: X_Switch_Code),
1677: transaction_header_id_in = decode(X_transaction_header_id_in,
1678: NULL, transaction_header_id_in,
1679: FND_API.G_MISS_NUM, NULL,
1675: FND_API.G_MISS_CHAR, NULL,
1676: X_Switch_Code),
1677: transaction_header_id_in = decode(X_transaction_header_id_in,
1678: NULL, transaction_header_id_in,
1679: FND_API.G_MISS_NUM, NULL,
1680: X_transaction_header_id_in),
1681: transaction_header_id_out = decode(X_transaction_header_id_out,
1682: NULL, transaction_header_id_out,
1683: FND_API.G_MISS_NUM, NULL,
1679: FND_API.G_MISS_NUM, NULL,
1680: X_transaction_header_id_in),
1681: transaction_header_id_out = decode(X_transaction_header_id_out,
1682: NULL, transaction_header_id_out,
1683: FND_API.G_MISS_NUM, NULL,
1684: X_transaction_header_id_out),
1685: polish_deprn_basis = decode(X_Polish_Deprn_Basis,
1686: NULL, polish_deprn_basis,
1687: FND_API.G_MISS_NUM, NULL,
1683: FND_API.G_MISS_NUM, NULL,
1684: X_transaction_header_id_out),
1685: polish_deprn_basis = decode(X_Polish_Deprn_Basis,
1686: NULL, polish_deprn_basis,
1687: FND_API.G_MISS_NUM, NULL,
1688: X_polish_deprn_basis),
1689: polish_adj_rec_cost = decode(X_Polish_Adj_Rec_Cost,
1690: NULL, polish_adj_rec_cost,
1691: FND_API.G_MISS_NUM, NULL,
1687: FND_API.G_MISS_NUM, NULL,
1688: X_polish_deprn_basis),
1689: polish_adj_rec_cost = decode(X_Polish_Adj_Rec_Cost,
1690: NULL, polish_adj_rec_cost,
1691: FND_API.G_MISS_NUM, NULL,
1692: X_Polish_Adj_Rec_Cost),
1693: impairment_amount = decode(X_impairment_amount,
1694: NULL, impairment_amount,
1695: FND_API.G_MISS_NUM, NULL,
1691: FND_API.G_MISS_NUM, NULL,
1692: X_Polish_Adj_Rec_Cost),
1693: impairment_amount = decode(X_impairment_amount,
1694: NULL, impairment_amount,
1695: FND_API.G_MISS_NUM, NULL,
1696: X_Impairment_Amount),
1697: ytd_impairment = decode(X_ytd_impairment,
1698: NULL, ytd_impairment,
1699: FND_API.G_MISS_NUM, NULL,
1695: FND_API.G_MISS_NUM, NULL,
1696: X_Impairment_Amount),
1697: ytd_impairment = decode(X_ytd_impairment,
1698: NULL, ytd_impairment,
1699: FND_API.G_MISS_NUM, NULL,
1700: X_Ytd_Impairment),
1701: impairment_reserve = decode(X_impairment_reserve,
1702: NULL, impairment_reserve,
1703: FND_API.G_MISS_NUM, NULL,
1699: FND_API.G_MISS_NUM, NULL,
1700: X_Ytd_Impairment),
1701: impairment_reserve = decode(X_impairment_reserve,
1702: NULL, impairment_reserve,
1703: FND_API.G_MISS_NUM, NULL,
1704: X_impairment_reserve)
1705: WHERE asset_id = X_Asset_Id
1706: AND book_type_code = X_Book_Type_Code
1707: AND period_counter = X_Period_Counter;