[Home] [Help]
1009: UPDATE fa_books_mrc_v
1010: SET
1011: book_type_code = decode(X_Book_Type_Code,
1012: NULL, book_type_code,
1013: FND_API.G_MISS_CHAR, NULL,
1014: X_Book_Type_Code),
1015: asset_id = decode(X_Asset_Id,
1016: NULL, asset_id,
1017: FND_API.G_MISS_NUM, NULL,
1013: FND_API.G_MISS_CHAR, NULL,
1014: X_Book_Type_Code),
1015: asset_id = decode(X_Asset_Id,
1016: NULL, asset_id,
1017: FND_API.G_MISS_NUM, NULL,
1018: X_Asset_Id),
1019: date_placed_in_service = decode(X_Date_Placed_In_Service,
1020: NULL, date_placed_in_service ,
1021: X_Date_Placed_In_Service),
1026: NULL, deprn_start_date,
1027: X_Deprn_Start_Date),
1028: deprn_method_code = decode(X_Deprn_Method_Code,
1029: NULL, deprn_method_code,
1030: FND_API.G_MISS_CHAR, NULL,
1031: X_Deprn_Method_Code),
1032: life_in_months = decode(X_Life_In_Months,
1033: NULL, life_in_months,
1034: FND_API.G_MISS_NUM, NULL,
1030: FND_API.G_MISS_CHAR, NULL,
1031: X_Deprn_Method_Code),
1032: life_in_months = decode(X_Life_In_Months,
1033: NULL, life_in_months,
1034: FND_API.G_MISS_NUM, NULL,
1035: X_Life_In_Months),
1036: rate_adjustment_factor = decode(X_Rate_Adjustment_Factor,
1037: NULL, rate_adjustment_factor,
1038: FND_API.G_MISS_NUM, NULL,
1034: FND_API.G_MISS_NUM, NULL,
1035: X_Life_In_Months),
1036: rate_adjustment_factor = decode(X_Rate_Adjustment_Factor,
1037: NULL, rate_adjustment_factor,
1038: FND_API.G_MISS_NUM, NULL,
1039: X_Rate_Adjustment_Factor),
1040: adjusted_cost = decode(X_Adjusted_Cost,
1041: NULL, adjusted_cost,
1042: FND_API.G_MISS_NUM, NULL,
1038: FND_API.G_MISS_NUM, NULL,
1039: X_Rate_Adjustment_Factor),
1040: adjusted_cost = decode(X_Adjusted_Cost,
1041: NULL, adjusted_cost,
1042: FND_API.G_MISS_NUM, NULL,
1043: X_Adjusted_Cost),
1044: cost = decode(X_Cost,
1045: NULL, cost,
1046: FND_API.G_MISS_NUM, NULL,
1042: FND_API.G_MISS_NUM, NULL,
1043: X_Adjusted_Cost),
1044: cost = decode(X_Cost,
1045: NULL, cost,
1046: FND_API.G_MISS_NUM, NULL,
1047: X_Cost),
1048: original_cost = decode(X_Original_Cost,
1049: NULL, original_cost,
1050: FND_API.G_MISS_NUM, NULL,
1046: FND_API.G_MISS_NUM, NULL,
1047: X_Cost),
1048: original_cost = decode(X_Original_Cost,
1049: NULL, original_cost,
1050: FND_API.G_MISS_NUM, NULL,
1051: X_Original_Cost),
1052: salvage_value = decode(X_Salvage_Value,
1053: NULL, salvage_value,
1054: FND_API.G_MISS_NUM, NULL,
1050: FND_API.G_MISS_NUM, NULL,
1051: X_Original_Cost),
1052: salvage_value = decode(X_Salvage_Value,
1053: NULL, salvage_value,
1054: FND_API.G_MISS_NUM, NULL,
1055: X_Salvage_Value),
1056: prorate_convention_code = decode(X_Prorate_Convention_Code,
1057: NULL, prorate_convention_code,
1058: FND_API.G_MISS_CHAR, NULL,
1054: FND_API.G_MISS_NUM, NULL,
1055: X_Salvage_Value),
1056: prorate_convention_code = decode(X_Prorate_Convention_Code,
1057: NULL, prorate_convention_code,
1058: FND_API.G_MISS_CHAR, NULL,
1059: X_Prorate_Convention_Code),
1060: prorate_date = decode(X_Prorate_Date,
1061: NULL, prorate_date,
1062: X_Prorate_Date),
1061: NULL, prorate_date,
1062: X_Prorate_Date),
1063: cost_change_flag = decode(X_Cost_Change_Flag,
1064: NULL, cost_change_flag,
1065: FND_API.G_MISS_CHAR, NULL,
1066: X_Cost_Change_Flag),
1067: adjustment_required_status = decode(X_Adjustment_Required_Status,
1068: NULL, adjustment_required_status,
1069: FND_API.G_MISS_CHAR, NULL,
1065: FND_API.G_MISS_CHAR, NULL,
1066: X_Cost_Change_Flag),
1067: adjustment_required_status = decode(X_Adjustment_Required_Status,
1068: NULL, adjustment_required_status,
1069: FND_API.G_MISS_CHAR, NULL,
1070: X_Adjustment_Required_Status),
1071: capitalize_flag = decode(X_Capitalize_Flag,
1072: NULL, capitalize_flag,
1073: FND_API.G_MISS_CHAR, NULL,
1069: FND_API.G_MISS_CHAR, NULL,
1070: X_Adjustment_Required_Status),
1071: capitalize_flag = decode(X_Capitalize_Flag,
1072: NULL, capitalize_flag,
1073: FND_API.G_MISS_CHAR, NULL,
1074: X_Capitalize_Flag),
1075: retirement_pending_flag = decode(X_Retirement_Pending_Flag,
1076: NULL, retirement_pending_flag,
1077: FND_API.G_MISS_CHAR, NULL,
1073: FND_API.G_MISS_CHAR, NULL,
1074: X_Capitalize_Flag),
1075: retirement_pending_flag = decode(X_Retirement_Pending_Flag,
1076: NULL, retirement_pending_flag,
1077: FND_API.G_MISS_CHAR, NULL,
1078: X_Retirement_Pending_Flag),
1079: depreciate_flag = decode(X_Depreciate_Flag,
1080: NULL, depreciate_flag,
1081: FND_API.G_MISS_CHAR, NULL,
1077: FND_API.G_MISS_CHAR, NULL,
1078: X_Retirement_Pending_Flag),
1079: depreciate_flag = decode(X_Depreciate_Flag,
1080: NULL, depreciate_flag,
1081: FND_API.G_MISS_CHAR, NULL,
1082: X_Depreciate_Flag),
1083: --HH group ed.
1084: disabled_flag = decode(X_Disabled_Flag,
1085: NULL, disabled_flag,
1082: X_Depreciate_Flag),
1083: --HH group ed.
1084: disabled_flag = decode(X_Disabled_Flag,
1085: NULL, disabled_flag,
1086: FND_API.G_MISS_CHAR, NULL,
1087: X_Disabled_Flag),
1088: last_update_date = decode(X_Last_Update_Date,
1089: NULL, last_update_date,
1090: X_Last_Update_Date),
1089: NULL, last_update_date,
1090: X_Last_Update_Date),
1091: last_updated_by = decode(X_Last_Updated_By,
1092: NULL, last_updated_by,
1093: FND_API.G_MISS_NUM, NULL,
1094: X_Last_Updated_By),
1095: date_ineffective = decode(X_Date_Ineffective,
1096: NULL, date_ineffective,
1097: X_Date_Ineffective),
1096: NULL, date_ineffective,
1097: X_Date_Ineffective),
1098: transaction_header_id_in = decode(X_Transaction_Header_Id_In,
1099: NULL, transaction_header_id_in,
1100: FND_API.G_MISS_NUM, NULL,
1101: X_Transaction_Header_Id_In),
1102: transaction_header_id_out = decode(X_Transaction_Header_Id_Out,
1103: NULL, transaction_header_id_out,
1104: FND_API.G_MISS_NUM, NULL,
1100: FND_API.G_MISS_NUM, NULL,
1101: X_Transaction_Header_Id_In),
1102: transaction_header_id_out = decode(X_Transaction_Header_Id_Out,
1103: NULL, transaction_header_id_out,
1104: FND_API.G_MISS_NUM, NULL,
1105: X_Transaction_Header_Id_Out),
1106: itc_amount_id = decode(X_Itc_Amount_Id,
1107: NULL, itc_amount_id,
1108: FND_API.G_MISS_NUM, NULL,
1104: FND_API.G_MISS_NUM, NULL,
1105: X_Transaction_Header_Id_Out),
1106: itc_amount_id = decode(X_Itc_Amount_Id,
1107: NULL, itc_amount_id,
1108: FND_API.G_MISS_NUM, NULL,
1109: X_Itc_Amount_Id),
1110: itc_amount = decode(X_Itc_Amount,
1111: NULL, itc_amount,
1112: FND_API.G_MISS_NUM, NULL,
1108: FND_API.G_MISS_NUM, NULL,
1109: X_Itc_Amount_Id),
1110: itc_amount = decode(X_Itc_Amount,
1111: NULL, itc_amount,
1112: FND_API.G_MISS_NUM, NULL,
1113: X_Itc_Amount),
1114: retirement_id = decode(X_Retirement_Id,
1115: NULL, retirement_id,
1116: FND_API.G_MISS_NUM, NULL,
1112: FND_API.G_MISS_NUM, NULL,
1113: X_Itc_Amount),
1114: retirement_id = decode(X_Retirement_Id,
1115: NULL, retirement_id,
1116: FND_API.G_MISS_NUM, NULL,
1117: X_Retirement_Id),
1118: tax_request_id = decode(X_Tax_Request_Id,
1119: NULL, tax_request_id,
1120: FND_API.G_MISS_NUM, NULL,
1116: FND_API.G_MISS_NUM, NULL,
1117: X_Retirement_Id),
1118: tax_request_id = decode(X_Tax_Request_Id,
1119: NULL, tax_request_id,
1120: FND_API.G_MISS_NUM, NULL,
1121: X_Tax_Request_Id),
1122: itc_basis = decode(X_Itc_Basis,
1123: NULL, itc_basis,
1124: FND_API.G_MISS_NUM, NULL,
1120: FND_API.G_MISS_NUM, NULL,
1121: X_Tax_Request_Id),
1122: itc_basis = decode(X_Itc_Basis,
1123: NULL, itc_basis,
1124: FND_API.G_MISS_NUM, NULL,
1125: X_Itc_Basis),
1126: basic_rate = decode(X_Basic_Rate,
1127: NULL, basic_rate,
1128: FND_API.G_MISS_NUM, NULL,
1124: FND_API.G_MISS_NUM, NULL,
1125: X_Itc_Basis),
1126: basic_rate = decode(X_Basic_Rate,
1127: NULL, basic_rate,
1128: FND_API.G_MISS_NUM, NULL,
1129: X_Basic_Rate),
1130: adjusted_rate = decode(X_Adjusted_Rate,
1131: NULL, adjusted_rate,
1132: FND_API.G_MISS_NUM, NULL,
1128: FND_API.G_MISS_NUM, NULL,
1129: X_Basic_Rate),
1130: adjusted_rate = decode(X_Adjusted_Rate,
1131: NULL, adjusted_rate,
1132: FND_API.G_MISS_NUM, NULL,
1133: X_Adjusted_Rate),
1134: bonus_rule = decode(X_Bonus_Rule,
1135: NULL, bonus_rule,
1136: FND_API.G_MISS_CHAR, NULL,
1132: FND_API.G_MISS_NUM, NULL,
1133: X_Adjusted_Rate),
1134: bonus_rule = decode(X_Bonus_Rule,
1135: NULL, bonus_rule,
1136: FND_API.G_MISS_CHAR, NULL,
1137: X_Bonus_Rule),
1138: ceiling_name = decode(X_Ceiling_Name,
1139: NULL, ceiling_name,
1140: FND_API.G_MISS_CHAR, NULL,
1136: FND_API.G_MISS_CHAR, NULL,
1137: X_Bonus_Rule),
1138: ceiling_name = decode(X_Ceiling_Name,
1139: NULL, ceiling_name,
1140: FND_API.G_MISS_CHAR, NULL,
1141: X_Ceiling_Name),
1142: recoverable_cost = decode(X_Recoverable_Cost,
1143: NULL, recoverable_cost,
1144: FND_API.G_MISS_NUM, NULL,
1140: FND_API.G_MISS_CHAR, NULL,
1141: X_Ceiling_Name),
1142: recoverable_cost = decode(X_Recoverable_Cost,
1143: NULL, recoverable_cost,
1144: FND_API.G_MISS_NUM, NULL,
1145: X_Recoverable_Cost),
1146: last_update_login = decode(X_Last_Update_Login,
1147: NULL, last_update_login,
1148: FND_API.G_MISS_NUM, NULL,
1144: FND_API.G_MISS_NUM, NULL,
1145: X_Recoverable_Cost),
1146: last_update_login = decode(X_Last_Update_Login,
1147: NULL, last_update_login,
1148: FND_API.G_MISS_NUM, NULL,
1149: X_Last_Update_Login),
1150: adjusted_capacity = decode(X_Adjusted_Capacity,
1151: NULL, adjusted_capacity,
1152: FND_API.G_MISS_NUM, NULL,
1148: FND_API.G_MISS_NUM, NULL,
1149: X_Last_Update_Login),
1150: adjusted_capacity = decode(X_Adjusted_Capacity,
1151: NULL, adjusted_capacity,
1152: FND_API.G_MISS_NUM, NULL,
1153: X_Adjusted_Capacity),
1154: fully_rsvd_revals_counter = decode(X_Fully_Rsvd_Revals_Counter,
1155: NULL, fully_rsvd_revals_counter,
1156: FND_API.G_MISS_NUM, NULL,
1152: FND_API.G_MISS_NUM, NULL,
1153: X_Adjusted_Capacity),
1154: fully_rsvd_revals_counter = decode(X_Fully_Rsvd_Revals_Counter,
1155: NULL, fully_rsvd_revals_counter,
1156: FND_API.G_MISS_NUM, NULL,
1157: X_Fully_Rsvd_Revals_Counter),
1158: idled_flag = decode(X_Idled_Flag,
1159: NULL, idled_flag,
1160: FND_API.G_MISS_CHAR, NULL,
1156: FND_API.G_MISS_NUM, NULL,
1157: X_Fully_Rsvd_Revals_Counter),
1158: idled_flag = decode(X_Idled_Flag,
1159: NULL, idled_flag,
1160: FND_API.G_MISS_CHAR, NULL,
1161: X_Idled_Flag),
1162: period_counter_capitalized = decode(X_Period_Counter_Capitalized,
1163: NULL, period_counter_capitalized,
1164: FND_API.G_MISS_NUM, NULL,
1160: FND_API.G_MISS_CHAR, NULL,
1161: X_Idled_Flag),
1162: period_counter_capitalized = decode(X_Period_Counter_Capitalized,
1163: NULL, period_counter_capitalized,
1164: FND_API.G_MISS_NUM, NULL,
1165: X_Period_Counter_Capitalized),
1166: period_counter_fully_reserved = decode(X_PC_Fully_Reserved,
1167: NULL, period_counter_fully_reserved,
1168: FND_API.G_MISS_NUM, NULL,
1164: FND_API.G_MISS_NUM, NULL,
1165: X_Period_Counter_Capitalized),
1166: period_counter_fully_reserved = decode(X_PC_Fully_Reserved,
1167: NULL, period_counter_fully_reserved,
1168: FND_API.G_MISS_NUM, NULL,
1169: X_PC_Fully_Reserved),
1170: period_counter_fully_retired = decode(X_Period_Counter_Fully_Retired,
1171: NULL, period_counter_fully_retired,
1172: FND_API.G_MISS_NUM, NULL,
1168: FND_API.G_MISS_NUM, NULL,
1169: X_PC_Fully_Reserved),
1170: period_counter_fully_retired = decode(X_Period_Counter_Fully_Retired,
1171: NULL, period_counter_fully_retired,
1172: FND_API.G_MISS_NUM, NULL,
1173: X_Period_Counter_Fully_Retired),
1174: production_capacity = decode(X_Production_Capacity,
1175: NULL, production_capacity,
1176: FND_API.G_MISS_NUM, NULL,
1172: FND_API.G_MISS_NUM, NULL,
1173: X_Period_Counter_Fully_Retired),
1174: production_capacity = decode(X_Production_Capacity,
1175: NULL, production_capacity,
1176: FND_API.G_MISS_NUM, NULL,
1177: X_Production_Capacity),
1178: reval_amortization_basis = decode(X_Reval_Amortization_Basis,
1179: NULL, reval_amortization_basis,
1180: FND_API.G_MISS_NUM, NULL,
1176: FND_API.G_MISS_NUM, NULL,
1177: X_Production_Capacity),
1178: reval_amortization_basis = decode(X_Reval_Amortization_Basis,
1179: NULL, reval_amortization_basis,
1180: FND_API.G_MISS_NUM, NULL,
1181: X_Reval_Amortization_Basis),
1182: reval_ceiling = decode(X_Reval_Ceiling,
1183: NULL, reval_ceiling,
1184: FND_API.G_MISS_NUM, NULL,
1180: FND_API.G_MISS_NUM, NULL,
1181: X_Reval_Amortization_Basis),
1182: reval_ceiling = decode(X_Reval_Ceiling,
1183: NULL, reval_ceiling,
1184: FND_API.G_MISS_NUM, NULL,
1185: X_Reval_Ceiling),
1186: unit_of_measure = decode(X_Unit_Of_Measure,
1187: NULL, unit_of_measure,
1188: FND_API.G_MISS_CHAR, NULL,
1184: FND_API.G_MISS_NUM, NULL,
1185: X_Reval_Ceiling),
1186: unit_of_measure = decode(X_Unit_Of_Measure,
1187: NULL, unit_of_measure,
1188: FND_API.G_MISS_CHAR, NULL,
1189: X_Unit_Of_Measure),
1190: unrevalued_cost = decode(X_Unrevalued_Cost,
1191: NULL, unrevalued_cost,
1192: FND_API.G_MISS_NUM, NULL,
1188: FND_API.G_MISS_CHAR, NULL,
1189: X_Unit_Of_Measure),
1190: unrevalued_cost = decode(X_Unrevalued_Cost,
1191: NULL, unrevalued_cost,
1192: FND_API.G_MISS_NUM, NULL,
1193: X_Unrevalued_Cost),
1194: annual_deprn_rounding_flag = decode(X_Annual_Deprn_Rounding_Flag,
1195: NULL, annual_deprn_rounding_flag,
1196: FND_API.G_MISS_CHAR, NULL,
1192: FND_API.G_MISS_NUM, NULL,
1193: X_Unrevalued_Cost),
1194: annual_deprn_rounding_flag = decode(X_Annual_Deprn_Rounding_Flag,
1195: NULL, annual_deprn_rounding_flag,
1196: FND_API.G_MISS_CHAR, NULL,
1197: X_Annual_Deprn_Rounding_Flag),
1198: percent_salvage_value = decode(X_Percent_Salvage_Value,
1199: NULL, percent_salvage_value,
1200: FND_API.G_MISS_NUM, NULL,
1196: FND_API.G_MISS_CHAR, NULL,
1197: X_Annual_Deprn_Rounding_Flag),
1198: percent_salvage_value = decode(X_Percent_Salvage_Value,
1199: NULL, percent_salvage_value,
1200: FND_API.G_MISS_NUM, NULL,
1201: X_Percent_Salvage_Value),
1202: allowed_deprn_limit = decode(X_Allowed_Deprn_Limit,
1203: NULL, allowed_deprn_limit,
1204: FND_API.G_MISS_NUM, NULL,
1200: FND_API.G_MISS_NUM, NULL,
1201: X_Percent_Salvage_Value),
1202: allowed_deprn_limit = decode(X_Allowed_Deprn_Limit,
1203: NULL, allowed_deprn_limit,
1204: FND_API.G_MISS_NUM, NULL,
1205: X_Allowed_Deprn_Limit),
1206: allowed_deprn_limit_amount = decode(X_Allowed_Deprn_Limit_Amount,
1207: NULL, allowed_deprn_limit_amount,
1208: FND_API.G_MISS_NUM, NULL,
1204: FND_API.G_MISS_NUM, NULL,
1205: X_Allowed_Deprn_Limit),
1206: allowed_deprn_limit_amount = decode(X_Allowed_Deprn_Limit_Amount,
1207: NULL, allowed_deprn_limit_amount,
1208: FND_API.G_MISS_NUM, NULL,
1209: X_Allowed_Deprn_Limit_Amount),
1210: period_counter_life_complete = decode(X_Period_Counter_Life_Complete,
1211: NULL, period_counter_life_complete,
1212: FND_API.G_MISS_NUM, NULL,
1208: FND_API.G_MISS_NUM, NULL,
1209: X_Allowed_Deprn_Limit_Amount),
1210: period_counter_life_complete = decode(X_Period_Counter_Life_Complete,
1211: NULL, period_counter_life_complete,
1212: FND_API.G_MISS_NUM, NULL,
1213: X_Period_Counter_Life_Complete),
1214: adjusted_recoverable_cost = decode(X_Adjusted_Recoverable_Cost,
1215: NULL, adjusted_recoverable_cost,
1216: FND_API.G_MISS_NUM, NULL,
1212: FND_API.G_MISS_NUM, NULL,
1213: X_Period_Counter_Life_Complete),
1214: adjusted_recoverable_cost = decode(X_Adjusted_Recoverable_Cost,
1215: NULL, adjusted_recoverable_cost,
1216: FND_API.G_MISS_NUM, NULL,
1217: X_Adjusted_Recoverable_Cost),
1218: group_asset_id = decode(X_group_asset_id,
1219: NULL, group_asset_id,
1220: FND_API.G_MISS_NUM, NULL,
1216: FND_API.G_MISS_NUM, NULL,
1217: X_Adjusted_Recoverable_Cost),
1218: group_asset_id = decode(X_group_asset_id,
1219: NULL, group_asset_id,
1220: FND_API.G_MISS_NUM, NULL,
1221: X_group_asset_id),
1222: salvage_type = decode(X_salvage_type,
1223: NULL, salvage_type,
1224: FND_API.G_MISS_CHAR, NULL,
1220: FND_API.G_MISS_NUM, NULL,
1221: X_group_asset_id),
1222: salvage_type = decode(X_salvage_type,
1223: NULL, salvage_type,
1224: FND_API.G_MISS_CHAR, NULL,
1225: X_salvage_type),
1226: deprn_limit_type = decode(X_deprn_limit_type ,
1227: NULL, deprn_limit_type ,
1228: FND_API.G_MISS_CHAR, NULL,
1224: FND_API.G_MISS_CHAR, NULL,
1225: X_salvage_type),
1226: deprn_limit_type = decode(X_deprn_limit_type ,
1227: NULL, deprn_limit_type ,
1228: FND_API.G_MISS_CHAR, NULL,
1229: X_deprn_limit_type ),
1230: over_depreciate_option = decode(X_over_depreciate_option,
1231: NULL, over_depreciate_option,
1232: FND_API.G_MISS_CHAR, NULL,
1228: FND_API.G_MISS_CHAR, NULL,
1229: X_deprn_limit_type ),
1230: over_depreciate_option = decode(X_over_depreciate_option,
1231: NULL, over_depreciate_option,
1232: FND_API.G_MISS_CHAR, NULL,
1233: X_over_depreciate_option),
1234: super_group_id = decode(X_super_group_id,
1235: NULL, super_group_id,
1236: FND_API.G_MISS_NUM, NULL,
1232: FND_API.G_MISS_CHAR, NULL,
1233: X_over_depreciate_option),
1234: super_group_id = decode(X_super_group_id,
1235: NULL, super_group_id,
1236: FND_API.G_MISS_NUM, NULL,
1237: X_super_group_id),
1238: reduction_rate = decode(X_reduction_rate,
1239: NULL, reduction_rate,
1240: FND_API.G_MISS_NUM, NULL,
1236: FND_API.G_MISS_NUM, NULL,
1237: X_super_group_id),
1238: reduction_rate = decode(X_reduction_rate,
1239: NULL, reduction_rate,
1240: FND_API.G_MISS_NUM, NULL,
1241: X_reduction_rate),
1242: reduce_addition_flag = decode(X_reduce_addition_flag,
1243: NULL, reduce_addition_flag,
1244: FND_API.G_MISS_CHAR, NULL,
1240: FND_API.G_MISS_NUM, NULL,
1241: X_reduction_rate),
1242: reduce_addition_flag = decode(X_reduce_addition_flag,
1243: NULL, reduce_addition_flag,
1244: FND_API.G_MISS_CHAR, NULL,
1245: X_reduce_addition_flag),
1246: reduce_adjustment_flag = decode(X_reduce_adjustment_flag,
1247: NULL, reduce_adjustment_flag,
1248: FND_API.G_MISS_CHAR, NULL,
1244: FND_API.G_MISS_CHAR, NULL,
1245: X_reduce_addition_flag),
1246: reduce_adjustment_flag = decode(X_reduce_adjustment_flag,
1247: NULL, reduce_adjustment_flag,
1248: FND_API.G_MISS_CHAR, NULL,
1249: X_reduce_adjustment_flag),
1250: reduce_retirement_flag = decode(X_reduce_retirement_flag,
1251: NULL, reduce_retirement_flag,
1252: FND_API.G_MISS_CHAR, NULL,
1248: FND_API.G_MISS_CHAR, NULL,
1249: X_reduce_adjustment_flag),
1250: reduce_retirement_flag = decode(X_reduce_retirement_flag,
1251: NULL, reduce_retirement_flag,
1252: FND_API.G_MISS_CHAR, NULL,
1253: X_reduce_retirement_flag),
1254: recognize_gain_loss = decode(X_recognize_gain_loss,
1255: NULL, recognize_gain_loss,
1256: FND_API.G_MISS_CHAR, NULL,
1252: FND_API.G_MISS_CHAR, NULL,
1253: X_reduce_retirement_flag),
1254: recognize_gain_loss = decode(X_recognize_gain_loss,
1255: NULL, recognize_gain_loss,
1256: FND_API.G_MISS_CHAR, NULL,
1257: X_recognize_gain_loss),
1258: recapture_reserve_flag = decode(X_recapture_reserve_flag,
1259: NULL, recapture_reserve_flag,
1260: FND_API.G_MISS_CHAR, NULL,
1256: FND_API.G_MISS_CHAR, NULL,
1257: X_recognize_gain_loss),
1258: recapture_reserve_flag = decode(X_recapture_reserve_flag,
1259: NULL, recapture_reserve_flag,
1260: FND_API.G_MISS_CHAR, NULL,
1261: X_recapture_reserve_flag),
1262: limit_proceeds_flag = decode(X_limit_proceeds_flag,
1263: NULL, limit_proceeds_flag,
1264: FND_API.G_MISS_CHAR, NULL,
1260: FND_API.G_MISS_CHAR, NULL,
1261: X_recapture_reserve_flag),
1262: limit_proceeds_flag = decode(X_limit_proceeds_flag,
1263: NULL, limit_proceeds_flag,
1264: FND_API.G_MISS_CHAR, NULL,
1265: X_limit_proceeds_flag),
1266: terminal_gain_loss = decode(X_terminal_gain_loss,
1267: NULL, terminal_gain_loss,
1268: FND_API.G_MISS_CHAR, NULL,
1264: FND_API.G_MISS_CHAR, NULL,
1265: X_limit_proceeds_flag),
1266: terminal_gain_loss = decode(X_terminal_gain_loss,
1267: NULL, terminal_gain_loss,
1268: FND_API.G_MISS_CHAR, NULL,
1269: X_terminal_gain_loss),
1270: tracking_method = decode(X_tracking_method,
1271: NULL, tracking_method,
1272: FND_API.G_MISS_CHAR, NULL,
1268: FND_API.G_MISS_CHAR, NULL,
1269: X_terminal_gain_loss),
1270: tracking_method = decode(X_tracking_method,
1271: NULL, tracking_method,
1272: FND_API.G_MISS_CHAR, NULL,
1273: X_tracking_method),
1274: allocate_to_fully_rsv_flag = decode(X_allocate_to_fully_rsv_flag,
1275: NULL, allocate_to_fully_rsv_flag,
1276: FND_API.G_MISS_CHAR, NULL,
1272: FND_API.G_MISS_CHAR, NULL,
1273: X_tracking_method),
1274: allocate_to_fully_rsv_flag = decode(X_allocate_to_fully_rsv_flag,
1275: NULL, allocate_to_fully_rsv_flag,
1276: FND_API.G_MISS_CHAR, NULL,
1277: X_allocate_to_fully_rsv_flag),
1278: allocate_to_fully_ret_flag = decode(X_allocate_to_fully_ret_flag,
1279: NULL, allocate_to_fully_ret_flag,
1280: FND_API.G_MISS_CHAR, NULL,
1276: FND_API.G_MISS_CHAR, NULL,
1277: X_allocate_to_fully_rsv_flag),
1278: allocate_to_fully_ret_flag = decode(X_allocate_to_fully_ret_flag,
1279: NULL, allocate_to_fully_ret_flag,
1280: FND_API.G_MISS_CHAR, NULL,
1281: X_allocate_to_fully_ret_flag),
1282: exclude_fully_rsv_flag = decode(X_exclude_fully_rsv_flag,
1283: NULL, exclude_fully_rsv_flag,
1284: FND_API.G_MISS_CHAR, NULL,
1280: FND_API.G_MISS_CHAR, NULL,
1281: X_allocate_to_fully_ret_flag),
1282: exclude_fully_rsv_flag = decode(X_exclude_fully_rsv_flag,
1283: NULL, exclude_fully_rsv_flag,
1284: FND_API.G_MISS_CHAR, NULL,
1285: X_exclude_fully_rsv_flag),
1286: excess_allocation_option = decode(X_excess_allocation_option,
1287: NULL, excess_allocation_option,
1288: FND_API.G_MISS_CHAR, NULL,
1284: FND_API.G_MISS_CHAR, NULL,
1285: X_exclude_fully_rsv_flag),
1286: excess_allocation_option = decode(X_excess_allocation_option,
1287: NULL, excess_allocation_option,
1288: FND_API.G_MISS_CHAR, NULL,
1289: X_excess_allocation_option),
1290: depreciation_option = decode(X_depreciation_option,
1291: NULL, depreciation_option,
1292: FND_API.G_MISS_CHAR, NULL,
1288: FND_API.G_MISS_CHAR, NULL,
1289: X_excess_allocation_option),
1290: depreciation_option = decode(X_depreciation_option,
1291: NULL, depreciation_option,
1292: FND_API.G_MISS_CHAR, NULL,
1293: X_depreciation_option),
1294: member_rollup_flag = decode(X_member_rollup_flag,
1295: NULL, member_rollup_flag,
1296: FND_API.G_MISS_CHAR, NULL,
1292: FND_API.G_MISS_CHAR, NULL,
1293: X_depreciation_option),
1294: member_rollup_flag = decode(X_member_rollup_flag,
1295: NULL, member_rollup_flag,
1296: FND_API.G_MISS_CHAR, NULL,
1297: X_member_rollup_flag),
1298: ytd_proceeds = decode(X_ytd_proceeds,
1299: NULL, ytd_proceeds,
1300: FND_API.G_MISS_NUM, NULL,
1296: FND_API.G_MISS_CHAR, NULL,
1297: X_member_rollup_flag),
1298: ytd_proceeds = decode(X_ytd_proceeds,
1299: NULL, ytd_proceeds,
1300: FND_API.G_MISS_NUM, NULL,
1301: X_ytd_proceeds),
1302: ltd_proceeds = decode(X_ltd_proceeds,
1303: NULL, ltd_proceeds,
1304: FND_API.G_MISS_NUM, NULL,
1300: FND_API.G_MISS_NUM, NULL,
1301: X_ytd_proceeds),
1302: ltd_proceeds = decode(X_ltd_proceeds,
1303: NULL, ltd_proceeds,
1304: FND_API.G_MISS_NUM, NULL,
1305: X_ltd_proceeds),
1306: eofy_reserve = decode(X_eofy_reserve,
1307: NULL, eofy_reserve,
1308: FND_API.G_MISS_NUM, NULL,
1304: FND_API.G_MISS_NUM, NULL,
1305: X_ltd_proceeds),
1306: eofy_reserve = decode(X_eofy_reserve,
1307: NULL, eofy_reserve,
1308: FND_API.G_MISS_NUM, NULL,
1309: X_eofy_reserve),
1310: cip_cost = decode(X_cip_cost,
1311: NULL, cip_cost,
1312: FND_API.G_MISS_NUM, NULL,
1308: FND_API.G_MISS_NUM, NULL,
1309: X_eofy_reserve),
1310: cip_cost = decode(X_cip_cost,
1311: NULL, cip_cost,
1312: FND_API.G_MISS_NUM, NULL,
1313: X_cip_cost),
1314: terminal_gain_loss_amount = decode(X_terminal_gain_loss_amount,
1315: NULL, terminal_gain_loss_amount,
1316: FND_API.G_MISS_NUM, NULL,
1312: FND_API.G_MISS_NUM, NULL,
1313: X_cip_cost),
1314: terminal_gain_loss_amount = decode(X_terminal_gain_loss_amount,
1315: NULL, terminal_gain_loss_amount,
1316: FND_API.G_MISS_NUM, NULL,
1317: X_terminal_gain_loss_amount),
1318: ltd_cost_of_removal = decode(X_ltd_cost_of_removal,
1319: NULL, ltd_cost_of_removal,
1320: FND_API.G_MISS_NUM, NULL,
1316: FND_API.G_MISS_NUM, NULL,
1317: X_terminal_gain_loss_amount),
1318: ltd_cost_of_removal = decode(X_ltd_cost_of_removal,
1319: NULL, ltd_cost_of_removal,
1320: FND_API.G_MISS_NUM, NULL,
1321: X_ltd_cost_of_removal),
1322: exclude_proceeds_from_basis = decode(X_exclude_proceeds_from_basis,
1323: NULL, exclude_proceeds_from_basis,
1324: FND_API.G_MISS_CHAR, NULL,
1320: FND_API.G_MISS_NUM, NULL,
1321: X_ltd_cost_of_removal),
1322: exclude_proceeds_from_basis = decode(X_exclude_proceeds_from_basis,
1323: NULL, exclude_proceeds_from_basis,
1324: FND_API.G_MISS_CHAR, NULL,
1325: X_exclude_proceeds_from_basis),
1326: retirement_deprn_option = decode(X_retirement_deprn_option,
1327: NULL, retirement_deprn_option,
1328: FND_API.G_MISS_CHAR, NULL,
1324: FND_API.G_MISS_CHAR, NULL,
1325: X_exclude_proceeds_from_basis),
1326: retirement_deprn_option = decode(X_retirement_deprn_option,
1327: NULL, retirement_deprn_option,
1328: FND_API.G_MISS_CHAR, NULL,
1329: X_retirement_deprn_option),
1330: terminal_gain_loss_flag = decode(X_terminal_gain_loss_flag,
1331: NULL, terminal_gain_loss_flag,
1332: FND_API.G_MISS_CHAR, NULL,
1328: FND_API.G_MISS_CHAR, NULL,
1329: X_retirement_deprn_option),
1330: terminal_gain_loss_flag = decode(X_terminal_gain_loss_flag,
1331: NULL, terminal_gain_loss_flag,
1332: FND_API.G_MISS_CHAR, NULL,
1333: X_terminal_gain_loss_flag),
1334: formula_factor = decode(X_Formula_Factor,
1335: NULL, formula_factor,
1336: FND_API.G_MISS_CHAR, NULL,
1332: FND_API.G_MISS_CHAR, NULL,
1333: X_terminal_gain_loss_flag),
1334: formula_factor = decode(X_Formula_Factor,
1335: NULL, formula_factor,
1336: FND_API.G_MISS_CHAR, NULL,
1337: X_Formula_Factor)
1338: WHERE rowid = X_Rowid;
1339: else
1340: UPDATE fa_books_mrc_v
1340: UPDATE fa_books_mrc_v
1341: SET
1342: book_type_code = decode(X_Book_Type_Code,
1343: NULL, book_type_code,
1344: FND_API.G_MISS_CHAR, NULL,
1345: X_Book_Type_Code),
1346: asset_id = decode(X_Asset_Id,
1347: NULL, asset_id,
1348: FND_API.G_MISS_NUM, NULL,
1344: FND_API.G_MISS_CHAR, NULL,
1345: X_Book_Type_Code),
1346: asset_id = decode(X_Asset_Id,
1347: NULL, asset_id,
1348: FND_API.G_MISS_NUM, NULL,
1349: X_Asset_Id),
1350: date_placed_in_service = decode(X_Date_Placed_In_Service,
1351: NULL, date_placed_in_service ,
1352: X_Date_Placed_In_Service),
1357: NULL, deprn_start_date,
1358: X_Deprn_Start_Date),
1359: deprn_method_code = decode(X_Deprn_Method_Code,
1360: NULL, deprn_method_code,
1361: FND_API.G_MISS_CHAR, NULL,
1362: X_Deprn_Method_Code),
1363: life_in_months = decode(X_Life_In_Months,
1364: NULL, life_in_months,
1365: FND_API.G_MISS_NUM, NULL,
1361: FND_API.G_MISS_CHAR, NULL,
1362: X_Deprn_Method_Code),
1363: life_in_months = decode(X_Life_In_Months,
1364: NULL, life_in_months,
1365: FND_API.G_MISS_NUM, NULL,
1366: X_Life_In_Months),
1367: rate_adjustment_factor = decode(X_Rate_Adjustment_Factor,
1368: NULL, rate_adjustment_factor,
1369: FND_API.G_MISS_NUM, NULL,
1365: FND_API.G_MISS_NUM, NULL,
1366: X_Life_In_Months),
1367: rate_adjustment_factor = decode(X_Rate_Adjustment_Factor,
1368: NULL, rate_adjustment_factor,
1369: FND_API.G_MISS_NUM, NULL,
1370: X_Rate_Adjustment_Factor),
1371: adjusted_cost = decode(X_Adjusted_Cost,
1372: NULL, adjusted_cost,
1373: FND_API.G_MISS_NUM, NULL,
1369: FND_API.G_MISS_NUM, NULL,
1370: X_Rate_Adjustment_Factor),
1371: adjusted_cost = decode(X_Adjusted_Cost,
1372: NULL, adjusted_cost,
1373: FND_API.G_MISS_NUM, NULL,
1374: X_Adjusted_Cost),
1375: cost = decode(X_Cost,
1376: NULL, cost,
1377: FND_API.G_MISS_NUM, NULL,
1373: FND_API.G_MISS_NUM, NULL,
1374: X_Adjusted_Cost),
1375: cost = decode(X_Cost,
1376: NULL, cost,
1377: FND_API.G_MISS_NUM, NULL,
1378: X_Cost),
1379: original_cost = decode(X_Original_Cost,
1380: NULL, original_cost,
1381: FND_API.G_MISS_NUM, NULL,
1377: FND_API.G_MISS_NUM, NULL,
1378: X_Cost),
1379: original_cost = decode(X_Original_Cost,
1380: NULL, original_cost,
1381: FND_API.G_MISS_NUM, NULL,
1382: X_Original_Cost),
1383: salvage_value = decode(X_Salvage_Value,
1384: NULL, salvage_value,
1385: FND_API.G_MISS_NUM, NULL,
1381: FND_API.G_MISS_NUM, NULL,
1382: X_Original_Cost),
1383: salvage_value = decode(X_Salvage_Value,
1384: NULL, salvage_value,
1385: FND_API.G_MISS_NUM, NULL,
1386: X_Salvage_Value),
1387: prorate_convention_code = decode(X_Prorate_Convention_Code,
1388: NULL, prorate_convention_code,
1389: FND_API.G_MISS_CHAR, NULL,
1385: FND_API.G_MISS_NUM, NULL,
1386: X_Salvage_Value),
1387: prorate_convention_code = decode(X_Prorate_Convention_Code,
1388: NULL, prorate_convention_code,
1389: FND_API.G_MISS_CHAR, NULL,
1390: X_Prorate_Convention_Code),
1391: prorate_date = decode(X_Prorate_Date,
1392: NULL, prorate_date,
1393: X_Prorate_Date),
1392: NULL, prorate_date,
1393: X_Prorate_Date),
1394: cost_change_flag = decode(X_Cost_Change_Flag,
1395: NULL, cost_change_flag,
1396: FND_API.G_MISS_CHAR, NULL,
1397: X_Cost_Change_Flag),
1398: adjustment_required_status = decode(X_Adjustment_Required_Status,
1399: NULL, adjustment_required_status,
1400: FND_API.G_MISS_CHAR, NULL,
1396: FND_API.G_MISS_CHAR, NULL,
1397: X_Cost_Change_Flag),
1398: adjustment_required_status = decode(X_Adjustment_Required_Status,
1399: NULL, adjustment_required_status,
1400: FND_API.G_MISS_CHAR, NULL,
1401: X_Adjustment_Required_Status),
1402: capitalize_flag = decode(X_Capitalize_Flag,
1403: NULL, capitalize_flag,
1404: FND_API.G_MISS_CHAR, NULL,
1400: FND_API.G_MISS_CHAR, NULL,
1401: X_Adjustment_Required_Status),
1402: capitalize_flag = decode(X_Capitalize_Flag,
1403: NULL, capitalize_flag,
1404: FND_API.G_MISS_CHAR, NULL,
1405: X_Capitalize_Flag),
1406: retirement_pending_flag = decode(X_Retirement_Pending_Flag,
1407: NULL, retirement_pending_flag,
1408: FND_API.G_MISS_CHAR, NULL,
1404: FND_API.G_MISS_CHAR, NULL,
1405: X_Capitalize_Flag),
1406: retirement_pending_flag = decode(X_Retirement_Pending_Flag,
1407: NULL, retirement_pending_flag,
1408: FND_API.G_MISS_CHAR, NULL,
1409: X_Retirement_Pending_Flag),
1410: depreciate_flag = decode(X_Depreciate_Flag,
1411: NULL, depreciate_flag,
1412: FND_API.G_MISS_CHAR, NULL,
1408: FND_API.G_MISS_CHAR, NULL,
1409: X_Retirement_Pending_Flag),
1410: depreciate_flag = decode(X_Depreciate_Flag,
1411: NULL, depreciate_flag,
1412: FND_API.G_MISS_CHAR, NULL,
1413: X_Depreciate_Flag),
1414: --HH group ed.
1415: disabled_flag = decode(X_Disabled_Flag,
1416: NULL, disabled_flag,
1413: X_Depreciate_Flag),
1414: --HH group ed.
1415: disabled_flag = decode(X_Disabled_Flag,
1416: NULL, disabled_flag,
1417: FND_API.G_MISS_CHAR, NULL,
1418: X_Disabled_Flag),
1419: last_update_date = decode(X_Last_Update_Date,
1420: NULL, last_update_date,
1421: X_Last_Update_Date),
1420: NULL, last_update_date,
1421: X_Last_Update_Date),
1422: last_updated_by = decode(X_Last_Updated_By,
1423: NULL, last_updated_by,
1424: FND_API.G_MISS_NUM, NULL,
1425: X_Last_Updated_By),
1426: date_ineffective = decode(X_Date_Ineffective,
1427: NULL, date_ineffective,
1428: X_Date_Ineffective),
1427: NULL, date_ineffective,
1428: X_Date_Ineffective),
1429: transaction_header_id_in = decode(X_Transaction_Header_Id_In,
1430: NULL, transaction_header_id_in,
1431: FND_API.G_MISS_NUM, NULL,
1432: X_Transaction_Header_Id_In),
1433: transaction_header_id_out = decode(X_Transaction_Header_Id_Out,
1434: NULL, transaction_header_id_out,
1435: FND_API.G_MISS_NUM, NULL,
1431: FND_API.G_MISS_NUM, NULL,
1432: X_Transaction_Header_Id_In),
1433: transaction_header_id_out = decode(X_Transaction_Header_Id_Out,
1434: NULL, transaction_header_id_out,
1435: FND_API.G_MISS_NUM, NULL,
1436: X_Transaction_Header_Id_Out),
1437: itc_amount_id = decode(X_Itc_Amount_Id,
1438: NULL, itc_amount_id,
1439: FND_API.G_MISS_NUM, NULL,
1435: FND_API.G_MISS_NUM, NULL,
1436: X_Transaction_Header_Id_Out),
1437: itc_amount_id = decode(X_Itc_Amount_Id,
1438: NULL, itc_amount_id,
1439: FND_API.G_MISS_NUM, NULL,
1440: X_Itc_Amount_Id),
1441: itc_amount = decode(X_Itc_Amount,
1442: NULL, itc_amount,
1443: FND_API.G_MISS_NUM, NULL,
1439: FND_API.G_MISS_NUM, NULL,
1440: X_Itc_Amount_Id),
1441: itc_amount = decode(X_Itc_Amount,
1442: NULL, itc_amount,
1443: FND_API.G_MISS_NUM, NULL,
1444: X_Itc_Amount),
1445: retirement_id = decode(X_Retirement_Id,
1446: NULL, retirement_id,
1447: FND_API.G_MISS_NUM, NULL,
1443: FND_API.G_MISS_NUM, NULL,
1444: X_Itc_Amount),
1445: retirement_id = decode(X_Retirement_Id,
1446: NULL, retirement_id,
1447: FND_API.G_MISS_NUM, NULL,
1448: X_Retirement_Id),
1449: tax_request_id = decode(X_Tax_Request_Id,
1450: NULL, tax_request_id,
1451: FND_API.G_MISS_NUM, NULL,
1447: FND_API.G_MISS_NUM, NULL,
1448: X_Retirement_Id),
1449: tax_request_id = decode(X_Tax_Request_Id,
1450: NULL, tax_request_id,
1451: FND_API.G_MISS_NUM, NULL,
1452: X_Tax_Request_Id),
1453: itc_basis = decode(X_Itc_Basis,
1454: NULL, itc_basis,
1455: FND_API.G_MISS_NUM, NULL,
1451: FND_API.G_MISS_NUM, NULL,
1452: X_Tax_Request_Id),
1453: itc_basis = decode(X_Itc_Basis,
1454: NULL, itc_basis,
1455: FND_API.G_MISS_NUM, NULL,
1456: X_Itc_Basis),
1457: basic_rate = decode(X_Basic_Rate,
1458: NULL, basic_rate,
1459: FND_API.G_MISS_NUM, NULL,
1455: FND_API.G_MISS_NUM, NULL,
1456: X_Itc_Basis),
1457: basic_rate = decode(X_Basic_Rate,
1458: NULL, basic_rate,
1459: FND_API.G_MISS_NUM, NULL,
1460: X_Basic_Rate),
1461: adjusted_rate = decode(X_Adjusted_Rate,
1462: NULL, adjusted_rate,
1463: FND_API.G_MISS_NUM, NULL,
1459: FND_API.G_MISS_NUM, NULL,
1460: X_Basic_Rate),
1461: adjusted_rate = decode(X_Adjusted_Rate,
1462: NULL, adjusted_rate,
1463: FND_API.G_MISS_NUM, NULL,
1464: X_Adjusted_Rate),
1465: bonus_rule = decode(X_Bonus_Rule,
1466: NULL, bonus_rule,
1467: FND_API.G_MISS_CHAR, NULL,
1463: FND_API.G_MISS_NUM, NULL,
1464: X_Adjusted_Rate),
1465: bonus_rule = decode(X_Bonus_Rule,
1466: NULL, bonus_rule,
1467: FND_API.G_MISS_CHAR, NULL,
1468: X_Bonus_Rule),
1469: ceiling_name = decode(X_Ceiling_Name,
1470: NULL, ceiling_name,
1471: FND_API.G_MISS_CHAR, NULL,
1467: FND_API.G_MISS_CHAR, NULL,
1468: X_Bonus_Rule),
1469: ceiling_name = decode(X_Ceiling_Name,
1470: NULL, ceiling_name,
1471: FND_API.G_MISS_CHAR, NULL,
1472: X_Ceiling_Name),
1473: recoverable_cost = decode(X_Recoverable_Cost,
1474: NULL, recoverable_cost,
1475: FND_API.G_MISS_NUM, NULL,
1471: FND_API.G_MISS_CHAR, NULL,
1472: X_Ceiling_Name),
1473: recoverable_cost = decode(X_Recoverable_Cost,
1474: NULL, recoverable_cost,
1475: FND_API.G_MISS_NUM, NULL,
1476: X_Recoverable_Cost),
1477: last_update_login = decode(X_Last_Update_Login,
1478: NULL, last_update_login,
1479: FND_API.G_MISS_NUM, NULL,
1475: FND_API.G_MISS_NUM, NULL,
1476: X_Recoverable_Cost),
1477: last_update_login = decode(X_Last_Update_Login,
1478: NULL, last_update_login,
1479: FND_API.G_MISS_NUM, NULL,
1480: X_Last_Update_Login),
1481: adjusted_capacity = decode(X_Adjusted_Capacity,
1482: NULL, adjusted_capacity,
1483: FND_API.G_MISS_NUM, NULL,
1479: FND_API.G_MISS_NUM, NULL,
1480: X_Last_Update_Login),
1481: adjusted_capacity = decode(X_Adjusted_Capacity,
1482: NULL, adjusted_capacity,
1483: FND_API.G_MISS_NUM, NULL,
1484: X_Adjusted_Capacity),
1485: fully_rsvd_revals_counter = decode(X_Fully_Rsvd_Revals_Counter,
1486: NULL, fully_rsvd_revals_counter,
1487: FND_API.G_MISS_NUM, NULL,
1483: FND_API.G_MISS_NUM, NULL,
1484: X_Adjusted_Capacity),
1485: fully_rsvd_revals_counter = decode(X_Fully_Rsvd_Revals_Counter,
1486: NULL, fully_rsvd_revals_counter,
1487: FND_API.G_MISS_NUM, NULL,
1488: X_Fully_Rsvd_Revals_Counter),
1489: idled_flag = decode(X_Idled_Flag,
1490: NULL, idled_flag,
1491: FND_API.G_MISS_CHAR, NULL,
1487: FND_API.G_MISS_NUM, NULL,
1488: X_Fully_Rsvd_Revals_Counter),
1489: idled_flag = decode(X_Idled_Flag,
1490: NULL, idled_flag,
1491: FND_API.G_MISS_CHAR, NULL,
1492: X_Idled_Flag),
1493: period_counter_capitalized = decode(X_Period_Counter_Capitalized,
1494: NULL, period_counter_capitalized,
1495: FND_API.G_MISS_NUM, NULL,
1491: FND_API.G_MISS_CHAR, NULL,
1492: X_Idled_Flag),
1493: period_counter_capitalized = decode(X_Period_Counter_Capitalized,
1494: NULL, period_counter_capitalized,
1495: FND_API.G_MISS_NUM, NULL,
1496: X_Period_Counter_Capitalized),
1497: period_counter_fully_reserved = decode(X_PC_Fully_Reserved,
1498: NULL, period_counter_fully_reserved,
1499: FND_API.G_MISS_NUM, NULL,
1495: FND_API.G_MISS_NUM, NULL,
1496: X_Period_Counter_Capitalized),
1497: period_counter_fully_reserved = decode(X_PC_Fully_Reserved,
1498: NULL, period_counter_fully_reserved,
1499: FND_API.G_MISS_NUM, NULL,
1500: X_PC_Fully_Reserved),
1501: period_counter_fully_retired = decode(X_Period_Counter_Fully_Retired,
1502: NULL, period_counter_fully_retired,
1503: FND_API.G_MISS_NUM, NULL,
1499: FND_API.G_MISS_NUM, NULL,
1500: X_PC_Fully_Reserved),
1501: period_counter_fully_retired = decode(X_Period_Counter_Fully_Retired,
1502: NULL, period_counter_fully_retired,
1503: FND_API.G_MISS_NUM, NULL,
1504: X_Period_Counter_Fully_Retired),
1505: production_capacity = decode(X_Production_Capacity,
1506: NULL, production_capacity,
1507: FND_API.G_MISS_NUM, NULL,
1503: FND_API.G_MISS_NUM, NULL,
1504: X_Period_Counter_Fully_Retired),
1505: production_capacity = decode(X_Production_Capacity,
1506: NULL, production_capacity,
1507: FND_API.G_MISS_NUM, NULL,
1508: X_Production_Capacity),
1509: reval_amortization_basis = decode(X_Reval_Amortization_Basis,
1510: NULL, reval_amortization_basis,
1511: FND_API.G_MISS_NUM, NULL,
1507: FND_API.G_MISS_NUM, NULL,
1508: X_Production_Capacity),
1509: reval_amortization_basis = decode(X_Reval_Amortization_Basis,
1510: NULL, reval_amortization_basis,
1511: FND_API.G_MISS_NUM, NULL,
1512: X_Reval_Amortization_Basis),
1513: reval_ceiling = decode(X_Reval_Ceiling,
1514: NULL, reval_ceiling,
1515: FND_API.G_MISS_NUM, NULL,
1511: FND_API.G_MISS_NUM, NULL,
1512: X_Reval_Amortization_Basis),
1513: reval_ceiling = decode(X_Reval_Ceiling,
1514: NULL, reval_ceiling,
1515: FND_API.G_MISS_NUM, NULL,
1516: X_Reval_Ceiling),
1517: unit_of_measure = decode(X_Unit_Of_Measure,
1518: NULL, unit_of_measure,
1519: FND_API.G_MISS_CHAR, NULL,
1515: FND_API.G_MISS_NUM, NULL,
1516: X_Reval_Ceiling),
1517: unit_of_measure = decode(X_Unit_Of_Measure,
1518: NULL, unit_of_measure,
1519: FND_API.G_MISS_CHAR, NULL,
1520: X_Unit_Of_Measure),
1521: unrevalued_cost = decode(X_Unrevalued_Cost,
1522: NULL, unrevalued_cost,
1523: FND_API.G_MISS_NUM, NULL,
1519: FND_API.G_MISS_CHAR, NULL,
1520: X_Unit_Of_Measure),
1521: unrevalued_cost = decode(X_Unrevalued_Cost,
1522: NULL, unrevalued_cost,
1523: FND_API.G_MISS_NUM, NULL,
1524: X_Unrevalued_Cost),
1525: annual_deprn_rounding_flag = decode(X_Annual_Deprn_Rounding_Flag,
1526: NULL, annual_deprn_rounding_flag,
1527: FND_API.G_MISS_CHAR, NULL,
1523: FND_API.G_MISS_NUM, NULL,
1524: X_Unrevalued_Cost),
1525: annual_deprn_rounding_flag = decode(X_Annual_Deprn_Rounding_Flag,
1526: NULL, annual_deprn_rounding_flag,
1527: FND_API.G_MISS_CHAR, NULL,
1528: X_Annual_Deprn_Rounding_Flag),
1529: percent_salvage_value = decode(X_Percent_Salvage_Value,
1530: NULL, percent_salvage_value,
1531: FND_API.G_MISS_NUM, NULL,
1527: FND_API.G_MISS_CHAR, NULL,
1528: X_Annual_Deprn_Rounding_Flag),
1529: percent_salvage_value = decode(X_Percent_Salvage_Value,
1530: NULL, percent_salvage_value,
1531: FND_API.G_MISS_NUM, NULL,
1532: X_Percent_Salvage_Value),
1533: allowed_deprn_limit = decode(X_Allowed_Deprn_Limit,
1534: NULL, allowed_deprn_limit,
1535: FND_API.G_MISS_NUM, NULL,
1531: FND_API.G_MISS_NUM, NULL,
1532: X_Percent_Salvage_Value),
1533: allowed_deprn_limit = decode(X_Allowed_Deprn_Limit,
1534: NULL, allowed_deprn_limit,
1535: FND_API.G_MISS_NUM, NULL,
1536: X_Allowed_Deprn_Limit),
1537: allowed_deprn_limit_amount = decode(X_Allowed_Deprn_Limit_Amount,
1538: NULL, allowed_deprn_limit_amount,
1539: FND_API.G_MISS_NUM, NULL,
1535: FND_API.G_MISS_NUM, NULL,
1536: X_Allowed_Deprn_Limit),
1537: allowed_deprn_limit_amount = decode(X_Allowed_Deprn_Limit_Amount,
1538: NULL, allowed_deprn_limit_amount,
1539: FND_API.G_MISS_NUM, NULL,
1540: X_Allowed_Deprn_Limit_Amount),
1541: period_counter_life_complete = decode(X_Period_Counter_Life_Complete,
1542: NULL, period_counter_life_complete,
1543: FND_API.G_MISS_NUM, NULL,
1539: FND_API.G_MISS_NUM, NULL,
1540: X_Allowed_Deprn_Limit_Amount),
1541: period_counter_life_complete = decode(X_Period_Counter_Life_Complete,
1542: NULL, period_counter_life_complete,
1543: FND_API.G_MISS_NUM, NULL,
1544: X_Period_Counter_Life_Complete),
1545: adjusted_recoverable_cost = decode(X_Adjusted_Recoverable_Cost,
1546: NULL, adjusted_recoverable_cost,
1547: FND_API.G_MISS_NUM, NULL,
1543: FND_API.G_MISS_NUM, NULL,
1544: X_Period_Counter_Life_Complete),
1545: adjusted_recoverable_cost = decode(X_Adjusted_Recoverable_Cost,
1546: NULL, adjusted_recoverable_cost,
1547: FND_API.G_MISS_NUM, NULL,
1548: X_Adjusted_Recoverable_Cost),
1549: group_asset_id = decode(X_group_asset_id,
1550: NULL, group_asset_id,
1551: FND_API.G_MISS_NUM, NULL,
1547: FND_API.G_MISS_NUM, NULL,
1548: X_Adjusted_Recoverable_Cost),
1549: group_asset_id = decode(X_group_asset_id,
1550: NULL, group_asset_id,
1551: FND_API.G_MISS_NUM, NULL,
1552: X_group_asset_id),
1553: salvage_type = decode(X_salvage_type,
1554: NULL, salvage_type,
1555: FND_API.G_MISS_CHAR, NULL,
1551: FND_API.G_MISS_NUM, NULL,
1552: X_group_asset_id),
1553: salvage_type = decode(X_salvage_type,
1554: NULL, salvage_type,
1555: FND_API.G_MISS_CHAR, NULL,
1556: X_salvage_type),
1557: deprn_limit_type = decode(X_deprn_limit_type ,
1558: NULL, deprn_limit_type ,
1559: FND_API.G_MISS_CHAR, NULL,
1555: FND_API.G_MISS_CHAR, NULL,
1556: X_salvage_type),
1557: deprn_limit_type = decode(X_deprn_limit_type ,
1558: NULL, deprn_limit_type ,
1559: FND_API.G_MISS_CHAR, NULL,
1560: X_deprn_limit_type ),
1561: over_depreciate_option = decode(X_over_depreciate_option,
1562: NULL, over_depreciate_option,
1563: FND_API.G_MISS_CHAR, NULL,
1559: FND_API.G_MISS_CHAR, NULL,
1560: X_deprn_limit_type ),
1561: over_depreciate_option = decode(X_over_depreciate_option,
1562: NULL, over_depreciate_option,
1563: FND_API.G_MISS_CHAR, NULL,
1564: X_over_depreciate_option),
1565: super_group_id = decode(X_super_group_id,
1566: NULL, super_group_id,
1567: FND_API.G_MISS_NUM, NULL,
1563: FND_API.G_MISS_CHAR, NULL,
1564: X_over_depreciate_option),
1565: super_group_id = decode(X_super_group_id,
1566: NULL, super_group_id,
1567: FND_API.G_MISS_NUM, NULL,
1568: X_super_group_id),
1569: reduction_rate = decode(X_reduction_rate,
1570: NULL, reduction_rate,
1571: FND_API.G_MISS_NUM, NULL,
1567: FND_API.G_MISS_NUM, NULL,
1568: X_super_group_id),
1569: reduction_rate = decode(X_reduction_rate,
1570: NULL, reduction_rate,
1571: FND_API.G_MISS_NUM, NULL,
1572: X_reduction_rate),
1573: reduce_addition_flag = decode(X_reduce_addition_flag,
1574: NULL, reduce_addition_flag,
1575: FND_API.G_MISS_CHAR, NULL,
1571: FND_API.G_MISS_NUM, NULL,
1572: X_reduction_rate),
1573: reduce_addition_flag = decode(X_reduce_addition_flag,
1574: NULL, reduce_addition_flag,
1575: FND_API.G_MISS_CHAR, NULL,
1576: X_reduce_addition_flag),
1577: reduce_adjustment_flag = decode(X_reduce_adjustment_flag,
1578: NULL, reduce_adjustment_flag,
1579: FND_API.G_MISS_CHAR, NULL,
1575: FND_API.G_MISS_CHAR, NULL,
1576: X_reduce_addition_flag),
1577: reduce_adjustment_flag = decode(X_reduce_adjustment_flag,
1578: NULL, reduce_adjustment_flag,
1579: FND_API.G_MISS_CHAR, NULL,
1580: X_reduce_adjustment_flag),
1581: reduce_retirement_flag = decode(X_reduce_retirement_flag,
1582: NULL, reduce_retirement_flag,
1583: FND_API.G_MISS_CHAR, NULL,
1579: FND_API.G_MISS_CHAR, NULL,
1580: X_reduce_adjustment_flag),
1581: reduce_retirement_flag = decode(X_reduce_retirement_flag,
1582: NULL, reduce_retirement_flag,
1583: FND_API.G_MISS_CHAR, NULL,
1584: X_reduce_retirement_flag),
1585: recognize_gain_loss = decode(X_recognize_gain_loss,
1586: NULL, recognize_gain_loss,
1587: FND_API.G_MISS_CHAR, NULL,
1583: FND_API.G_MISS_CHAR, NULL,
1584: X_reduce_retirement_flag),
1585: recognize_gain_loss = decode(X_recognize_gain_loss,
1586: NULL, recognize_gain_loss,
1587: FND_API.G_MISS_CHAR, NULL,
1588: X_recognize_gain_loss),
1589: recapture_reserve_flag = decode(X_recapture_reserve_flag,
1590: NULL, recapture_reserve_flag,
1591: FND_API.G_MISS_CHAR, NULL,
1587: FND_API.G_MISS_CHAR, NULL,
1588: X_recognize_gain_loss),
1589: recapture_reserve_flag = decode(X_recapture_reserve_flag,
1590: NULL, recapture_reserve_flag,
1591: FND_API.G_MISS_CHAR, NULL,
1592: X_recapture_reserve_flag),
1593: limit_proceeds_flag = decode(X_limit_proceeds_flag,
1594: NULL, limit_proceeds_flag,
1595: FND_API.G_MISS_CHAR, NULL,
1591: FND_API.G_MISS_CHAR, NULL,
1592: X_recapture_reserve_flag),
1593: limit_proceeds_flag = decode(X_limit_proceeds_flag,
1594: NULL, limit_proceeds_flag,
1595: FND_API.G_MISS_CHAR, NULL,
1596: X_limit_proceeds_flag),
1597: terminal_gain_loss = decode(X_terminal_gain_loss,
1598: NULL, terminal_gain_loss,
1599: FND_API.G_MISS_CHAR, NULL,
1595: FND_API.G_MISS_CHAR, NULL,
1596: X_limit_proceeds_flag),
1597: terminal_gain_loss = decode(X_terminal_gain_loss,
1598: NULL, terminal_gain_loss,
1599: FND_API.G_MISS_CHAR, NULL,
1600: X_terminal_gain_loss),
1601: tracking_method = decode(X_tracking_method,
1602: NULL, tracking_method,
1603: FND_API.G_MISS_CHAR, NULL,
1599: FND_API.G_MISS_CHAR, NULL,
1600: X_terminal_gain_loss),
1601: tracking_method = decode(X_tracking_method,
1602: NULL, tracking_method,
1603: FND_API.G_MISS_CHAR, NULL,
1604: X_tracking_method),
1605: allocate_to_fully_rsv_flag = decode(X_allocate_to_fully_rsv_flag,
1606: NULL, allocate_to_fully_rsv_flag,
1607: FND_API.G_MISS_CHAR, NULL,
1603: FND_API.G_MISS_CHAR, NULL,
1604: X_tracking_method),
1605: allocate_to_fully_rsv_flag = decode(X_allocate_to_fully_rsv_flag,
1606: NULL, allocate_to_fully_rsv_flag,
1607: FND_API.G_MISS_CHAR, NULL,
1608: X_allocate_to_fully_rsv_flag),
1609: allocate_to_fully_ret_flag = decode(X_allocate_to_fully_ret_flag,
1610: NULL, allocate_to_fully_ret_flag,
1611: FND_API.G_MISS_CHAR, NULL,
1607: FND_API.G_MISS_CHAR, NULL,
1608: X_allocate_to_fully_rsv_flag),
1609: allocate_to_fully_ret_flag = decode(X_allocate_to_fully_ret_flag,
1610: NULL, allocate_to_fully_ret_flag,
1611: FND_API.G_MISS_CHAR, NULL,
1612: X_allocate_to_fully_ret_flag),
1613: exclude_fully_rsv_flag = decode(X_exclude_fully_rsv_flag,
1614: NULL, exclude_fully_rsv_flag,
1615: FND_API.G_MISS_CHAR, NULL,
1611: FND_API.G_MISS_CHAR, NULL,
1612: X_allocate_to_fully_ret_flag),
1613: exclude_fully_rsv_flag = decode(X_exclude_fully_rsv_flag,
1614: NULL, exclude_fully_rsv_flag,
1615: FND_API.G_MISS_CHAR, NULL,
1616: X_exclude_fully_rsv_flag),
1617: excess_allocation_option = decode(X_excess_allocation_option,
1618: NULL, excess_allocation_option,
1619: FND_API.G_MISS_CHAR, NULL,
1615: FND_API.G_MISS_CHAR, NULL,
1616: X_exclude_fully_rsv_flag),
1617: excess_allocation_option = decode(X_excess_allocation_option,
1618: NULL, excess_allocation_option,
1619: FND_API.G_MISS_CHAR, NULL,
1620: X_excess_allocation_option),
1621: depreciation_option = decode(X_depreciation_option,
1622: NULL, depreciation_option,
1623: FND_API.G_MISS_CHAR, NULL,
1619: FND_API.G_MISS_CHAR, NULL,
1620: X_excess_allocation_option),
1621: depreciation_option = decode(X_depreciation_option,
1622: NULL, depreciation_option,
1623: FND_API.G_MISS_CHAR, NULL,
1624: X_depreciation_option),
1625: member_rollup_flag = decode(X_member_rollup_flag,
1626: NULL, member_rollup_flag,
1627: FND_API.G_MISS_CHAR, NULL,
1623: FND_API.G_MISS_CHAR, NULL,
1624: X_depreciation_option),
1625: member_rollup_flag = decode(X_member_rollup_flag,
1626: NULL, member_rollup_flag,
1627: FND_API.G_MISS_CHAR, NULL,
1628: X_member_rollup_flag),
1629: ytd_proceeds = decode(X_ytd_proceeds,
1630: NULL, ytd_proceeds,
1631: FND_API.G_MISS_NUM, NULL,
1627: FND_API.G_MISS_CHAR, NULL,
1628: X_member_rollup_flag),
1629: ytd_proceeds = decode(X_ytd_proceeds,
1630: NULL, ytd_proceeds,
1631: FND_API.G_MISS_NUM, NULL,
1632: X_ytd_proceeds),
1633: ltd_proceeds = decode(X_ltd_proceeds,
1634: NULL, ltd_proceeds,
1635: FND_API.G_MISS_NUM, NULL,
1631: FND_API.G_MISS_NUM, NULL,
1632: X_ytd_proceeds),
1633: ltd_proceeds = decode(X_ltd_proceeds,
1634: NULL, ltd_proceeds,
1635: FND_API.G_MISS_NUM, NULL,
1636: X_ltd_proceeds),
1637: eofy_reserve = decode(X_eofy_reserve,
1638: NULL, eofy_reserve,
1639: FND_API.G_MISS_NUM, NULL,
1635: FND_API.G_MISS_NUM, NULL,
1636: X_ltd_proceeds),
1637: eofy_reserve = decode(X_eofy_reserve,
1638: NULL, eofy_reserve,
1639: FND_API.G_MISS_NUM, NULL,
1640: X_eofy_reserve),
1641: cip_cost = decode(X_cip_cost,
1642: NULL, cip_cost,
1643: FND_API.G_MISS_NUM, NULL,
1639: FND_API.G_MISS_NUM, NULL,
1640: X_eofy_reserve),
1641: cip_cost = decode(X_cip_cost,
1642: NULL, cip_cost,
1643: FND_API.G_MISS_NUM, NULL,
1644: X_cip_cost),
1645: terminal_gain_loss_amount = decode(X_terminal_gain_loss_amount,
1646: NULL, terminal_gain_loss_amount,
1647: FND_API.G_MISS_NUM, NULL,
1643: FND_API.G_MISS_NUM, NULL,
1644: X_cip_cost),
1645: terminal_gain_loss_amount = decode(X_terminal_gain_loss_amount,
1646: NULL, terminal_gain_loss_amount,
1647: FND_API.G_MISS_NUM, NULL,
1648: X_terminal_gain_loss_amount),
1649: ltd_cost_of_removal = decode(X_ltd_cost_of_removal,
1650: NULL, ltd_cost_of_removal,
1651: FND_API.G_MISS_NUM, NULL,
1647: FND_API.G_MISS_NUM, NULL,
1648: X_terminal_gain_loss_amount),
1649: ltd_cost_of_removal = decode(X_ltd_cost_of_removal,
1650: NULL, ltd_cost_of_removal,
1651: FND_API.G_MISS_NUM, NULL,
1652: X_ltd_cost_of_removal),
1653: exclude_proceeds_from_basis = decode(X_exclude_proceeds_from_basis,
1654: NULL, exclude_proceeds_from_basis,
1655: FND_API.G_MISS_CHAR, NULL,
1651: FND_API.G_MISS_NUM, NULL,
1652: X_ltd_cost_of_removal),
1653: exclude_proceeds_from_basis = decode(X_exclude_proceeds_from_basis,
1654: NULL, exclude_proceeds_from_basis,
1655: FND_API.G_MISS_CHAR, NULL,
1656: X_exclude_proceeds_from_basis),
1657: retirement_deprn_option = decode(X_retirement_deprn_option,
1658: NULL, retirement_deprn_option,
1659: FND_API.G_MISS_CHAR, NULL,
1655: FND_API.G_MISS_CHAR, NULL,
1656: X_exclude_proceeds_from_basis),
1657: retirement_deprn_option = decode(X_retirement_deprn_option,
1658: NULL, retirement_deprn_option,
1659: FND_API.G_MISS_CHAR, NULL,
1660: X_retirement_deprn_option),
1661: terminal_gain_loss_flag = decode(X_terminal_gain_loss_flag,
1662: NULL, terminal_gain_loss_flag,
1663: FND_API.G_MISS_CHAR, NULL,
1659: FND_API.G_MISS_CHAR, NULL,
1660: X_retirement_deprn_option),
1661: terminal_gain_loss_flag = decode(X_terminal_gain_loss_flag,
1662: NULL, terminal_gain_loss_flag,
1663: FND_API.G_MISS_CHAR, NULL,
1664: X_terminal_gain_loss_flag),
1665: formula_factor = decode(X_Formula_Factor,
1666: NULL, formula_factor,
1667: FND_API.G_MISS_CHAR, NULL,
1663: FND_API.G_MISS_CHAR, NULL,
1664: X_terminal_gain_loss_flag),
1665: formula_factor = decode(X_Formula_Factor,
1666: NULL, formula_factor,
1667: FND_API.G_MISS_CHAR, NULL,
1668: X_Formula_Factor)
1669: WHERE asset_id = X_Asset_Id
1670: AND book_type_code = X_Book_Type_Code
1671: AND transaction_header_id_out is null;
1675: UPDATE fa_books
1676: SET
1677: book_type_code = decode(X_Book_Type_Code,
1678: NULL, book_type_code,
1679: FND_API.G_MISS_CHAR, NULL,
1680: X_Book_Type_Code),
1681: asset_id = decode(X_Asset_Id,
1682: NULL, asset_id,
1683: FND_API.G_MISS_NUM, NULL,
1679: FND_API.G_MISS_CHAR, NULL,
1680: X_Book_Type_Code),
1681: asset_id = decode(X_Asset_Id,
1682: NULL, asset_id,
1683: FND_API.G_MISS_NUM, NULL,
1684: X_Asset_Id),
1685: date_placed_in_service = decode(X_Date_Placed_In_Service,
1686: NULL, date_placed_in_service ,
1687: X_Date_Placed_In_Service),
1692: NULL, deprn_start_date,
1693: X_Deprn_Start_Date),
1694: deprn_method_code = decode(X_Deprn_Method_Code,
1695: NULL, deprn_method_code,
1696: FND_API.G_MISS_CHAR, NULL,
1697: X_Deprn_Method_Code),
1698: life_in_months = decode(X_Life_In_Months,
1699: NULL, life_in_months,
1700: FND_API.G_MISS_NUM, NULL,
1696: FND_API.G_MISS_CHAR, NULL,
1697: X_Deprn_Method_Code),
1698: life_in_months = decode(X_Life_In_Months,
1699: NULL, life_in_months,
1700: FND_API.G_MISS_NUM, NULL,
1701: X_Life_In_Months),
1702: rate_adjustment_factor = decode(X_Rate_Adjustment_Factor,
1703: NULL, rate_adjustment_factor,
1704: FND_API.G_MISS_NUM, NULL,
1700: FND_API.G_MISS_NUM, NULL,
1701: X_Life_In_Months),
1702: rate_adjustment_factor = decode(X_Rate_Adjustment_Factor,
1703: NULL, rate_adjustment_factor,
1704: FND_API.G_MISS_NUM, NULL,
1705: X_Rate_Adjustment_Factor),
1706: adjusted_cost = decode(X_Adjusted_Cost,
1707: NULL, adjusted_cost,
1708: FND_API.G_MISS_NUM, NULL,
1704: FND_API.G_MISS_NUM, NULL,
1705: X_Rate_Adjustment_Factor),
1706: adjusted_cost = decode(X_Adjusted_Cost,
1707: NULL, adjusted_cost,
1708: FND_API.G_MISS_NUM, NULL,
1709: X_Adjusted_Cost),
1710: cost = decode(X_Cost,
1711: NULL, cost,
1712: FND_API.G_MISS_NUM, NULL,
1708: FND_API.G_MISS_NUM, NULL,
1709: X_Adjusted_Cost),
1710: cost = decode(X_Cost,
1711: NULL, cost,
1712: FND_API.G_MISS_NUM, NULL,
1713: X_Cost),
1714: original_cost = decode(X_Original_Cost,
1715: NULL, original_cost,
1716: FND_API.G_MISS_NUM, NULL,
1712: FND_API.G_MISS_NUM, NULL,
1713: X_Cost),
1714: original_cost = decode(X_Original_Cost,
1715: NULL, original_cost,
1716: FND_API.G_MISS_NUM, NULL,
1717: X_Original_Cost),
1718: salvage_value = decode(X_Salvage_Value,
1719: NULL, salvage_value,
1720: FND_API.G_MISS_NUM, NULL,
1716: FND_API.G_MISS_NUM, NULL,
1717: X_Original_Cost),
1718: salvage_value = decode(X_Salvage_Value,
1719: NULL, salvage_value,
1720: FND_API.G_MISS_NUM, NULL,
1721: X_Salvage_Value),
1722: prorate_convention_code = decode(X_Prorate_Convention_Code,
1723: NULL, prorate_convention_code,
1724: FND_API.G_MISS_CHAR, NULL,
1720: FND_API.G_MISS_NUM, NULL,
1721: X_Salvage_Value),
1722: prorate_convention_code = decode(X_Prorate_Convention_Code,
1723: NULL, prorate_convention_code,
1724: FND_API.G_MISS_CHAR, NULL,
1725: X_Prorate_Convention_Code),
1726: prorate_date = decode(X_Prorate_Date,
1727: NULL, prorate_date,
1728: X_Prorate_Date),
1727: NULL, prorate_date,
1728: X_Prorate_Date),
1729: cost_change_flag = decode(X_Cost_Change_Flag,
1730: NULL, cost_change_flag,
1731: FND_API.G_MISS_CHAR, NULL,
1732: X_Cost_Change_Flag),
1733: adjustment_required_status = decode(X_Adjustment_Required_Status,
1734: NULL, adjustment_required_status,
1735: FND_API.G_MISS_CHAR, NULL,
1731: FND_API.G_MISS_CHAR, NULL,
1732: X_Cost_Change_Flag),
1733: adjustment_required_status = decode(X_Adjustment_Required_Status,
1734: NULL, adjustment_required_status,
1735: FND_API.G_MISS_CHAR, NULL,
1736: X_Adjustment_Required_Status),
1737: capitalize_flag = decode(X_Capitalize_Flag,
1738: NULL, capitalize_flag,
1739: FND_API.G_MISS_CHAR, NULL,
1735: FND_API.G_MISS_CHAR, NULL,
1736: X_Adjustment_Required_Status),
1737: capitalize_flag = decode(X_Capitalize_Flag,
1738: NULL, capitalize_flag,
1739: FND_API.G_MISS_CHAR, NULL,
1740: X_Capitalize_Flag),
1741: retirement_pending_flag = decode(X_Retirement_Pending_Flag,
1742: NULL, retirement_pending_flag,
1743: FND_API.G_MISS_CHAR, NULL,
1739: FND_API.G_MISS_CHAR, NULL,
1740: X_Capitalize_Flag),
1741: retirement_pending_flag = decode(X_Retirement_Pending_Flag,
1742: NULL, retirement_pending_flag,
1743: FND_API.G_MISS_CHAR, NULL,
1744: X_Retirement_Pending_Flag),
1745: depreciate_flag = decode(X_Depreciate_Flag,
1746: NULL, depreciate_flag,
1747: FND_API.G_MISS_CHAR, NULL,
1743: FND_API.G_MISS_CHAR, NULL,
1744: X_Retirement_Pending_Flag),
1745: depreciate_flag = decode(X_Depreciate_Flag,
1746: NULL, depreciate_flag,
1747: FND_API.G_MISS_CHAR, NULL,
1748: X_Depreciate_Flag),
1749: --HH group ed.
1750: disabled_flag = decode(X_Disabled_Flag,
1751: NULL, disabled_flag,
1748: X_Depreciate_Flag),
1749: --HH group ed.
1750: disabled_flag = decode(X_Disabled_Flag,
1751: NULL, disabled_flag,
1752: FND_API.G_MISS_CHAR, NULL,
1753: X_Disabled_Flag),
1754: last_update_date = decode(X_Last_Update_Date,
1755: NULL, last_update_date,
1756: X_Last_Update_Date),
1755: NULL, last_update_date,
1756: X_Last_Update_Date),
1757: last_updated_by = decode(X_Last_Updated_By,
1758: NULL, last_updated_by,
1759: FND_API.G_MISS_NUM, NULL,
1760: X_Last_Updated_By),
1761: date_ineffective = decode(X_Date_Ineffective,
1762: NULL, date_ineffective,
1763: X_Date_Ineffective),
1762: NULL, date_ineffective,
1763: X_Date_Ineffective),
1764: transaction_header_id_in = decode(X_Transaction_Header_Id_In,
1765: NULL, transaction_header_id_in,
1766: FND_API.G_MISS_NUM, NULL,
1767: X_Transaction_Header_Id_In),
1768: transaction_header_id_out = decode(X_Transaction_Header_Id_Out,
1769: NULL, transaction_header_id_out,
1770: FND_API.G_MISS_NUM, NULL,
1766: FND_API.G_MISS_NUM, NULL,
1767: X_Transaction_Header_Id_In),
1768: transaction_header_id_out = decode(X_Transaction_Header_Id_Out,
1769: NULL, transaction_header_id_out,
1770: FND_API.G_MISS_NUM, NULL,
1771: X_Transaction_Header_Id_Out),
1772: itc_amount_id = decode(X_Itc_Amount_Id,
1773: NULL, itc_amount_id,
1774: FND_API.G_MISS_NUM, NULL,
1770: FND_API.G_MISS_NUM, NULL,
1771: X_Transaction_Header_Id_Out),
1772: itc_amount_id = decode(X_Itc_Amount_Id,
1773: NULL, itc_amount_id,
1774: FND_API.G_MISS_NUM, NULL,
1775: X_Itc_Amount_Id),
1776: itc_amount = decode(X_Itc_Amount,
1777: NULL, itc_amount,
1778: FND_API.G_MISS_NUM, NULL,
1774: FND_API.G_MISS_NUM, NULL,
1775: X_Itc_Amount_Id),
1776: itc_amount = decode(X_Itc_Amount,
1777: NULL, itc_amount,
1778: FND_API.G_MISS_NUM, NULL,
1779: X_Itc_Amount),
1780: retirement_id = decode(X_Retirement_Id,
1781: NULL, retirement_id,
1782: FND_API.G_MISS_NUM, NULL,
1778: FND_API.G_MISS_NUM, NULL,
1779: X_Itc_Amount),
1780: retirement_id = decode(X_Retirement_Id,
1781: NULL, retirement_id,
1782: FND_API.G_MISS_NUM, NULL,
1783: X_Retirement_Id),
1784: tax_request_id = decode(X_Tax_Request_Id,
1785: NULL, tax_request_id,
1786: FND_API.G_MISS_NUM, NULL,
1782: FND_API.G_MISS_NUM, NULL,
1783: X_Retirement_Id),
1784: tax_request_id = decode(X_Tax_Request_Id,
1785: NULL, tax_request_id,
1786: FND_API.G_MISS_NUM, NULL,
1787: X_Tax_Request_Id),
1788: itc_basis = decode(X_Itc_Basis,
1789: NULL, itc_basis,
1790: FND_API.G_MISS_NUM, NULL,
1786: FND_API.G_MISS_NUM, NULL,
1787: X_Tax_Request_Id),
1788: itc_basis = decode(X_Itc_Basis,
1789: NULL, itc_basis,
1790: FND_API.G_MISS_NUM, NULL,
1791: X_Itc_Basis),
1792: basic_rate = decode(X_Basic_Rate,
1793: NULL, basic_rate,
1794: FND_API.G_MISS_NUM, NULL,
1790: FND_API.G_MISS_NUM, NULL,
1791: X_Itc_Basis),
1792: basic_rate = decode(X_Basic_Rate,
1793: NULL, basic_rate,
1794: FND_API.G_MISS_NUM, NULL,
1795: X_Basic_Rate),
1796: adjusted_rate = decode(X_Adjusted_Rate,
1797: NULL, adjusted_rate,
1798: FND_API.G_MISS_NUM, NULL,
1794: FND_API.G_MISS_NUM, NULL,
1795: X_Basic_Rate),
1796: adjusted_rate = decode(X_Adjusted_Rate,
1797: NULL, adjusted_rate,
1798: FND_API.G_MISS_NUM, NULL,
1799: X_Adjusted_Rate),
1800: bonus_rule = decode(X_Bonus_Rule,
1801: NULL, bonus_rule,
1802: FND_API.G_MISS_CHAR, NULL,
1798: FND_API.G_MISS_NUM, NULL,
1799: X_Adjusted_Rate),
1800: bonus_rule = decode(X_Bonus_Rule,
1801: NULL, bonus_rule,
1802: FND_API.G_MISS_CHAR, NULL,
1803: X_Bonus_Rule),
1804: ceiling_name = decode(X_Ceiling_Name,
1805: NULL, ceiling_name,
1806: FND_API.G_MISS_CHAR, NULL,
1802: FND_API.G_MISS_CHAR, NULL,
1803: X_Bonus_Rule),
1804: ceiling_name = decode(X_Ceiling_Name,
1805: NULL, ceiling_name,
1806: FND_API.G_MISS_CHAR, NULL,
1807: X_Ceiling_Name),
1808: recoverable_cost = decode(X_Recoverable_Cost,
1809: NULL, recoverable_cost,
1810: FND_API.G_MISS_NUM, NULL,
1806: FND_API.G_MISS_CHAR, NULL,
1807: X_Ceiling_Name),
1808: recoverable_cost = decode(X_Recoverable_Cost,
1809: NULL, recoverable_cost,
1810: FND_API.G_MISS_NUM, NULL,
1811: X_Recoverable_Cost),
1812: last_update_login = decode(X_Last_Update_Login,
1813: NULL, last_update_login,
1814: FND_API.G_MISS_NUM, NULL,
1810: FND_API.G_MISS_NUM, NULL,
1811: X_Recoverable_Cost),
1812: last_update_login = decode(X_Last_Update_Login,
1813: NULL, last_update_login,
1814: FND_API.G_MISS_NUM, NULL,
1815: X_Last_Update_Login),
1816: adjusted_capacity = decode(X_Adjusted_Capacity,
1817: NULL, adjusted_capacity,
1818: FND_API.G_MISS_NUM, NULL,
1814: FND_API.G_MISS_NUM, NULL,
1815: X_Last_Update_Login),
1816: adjusted_capacity = decode(X_Adjusted_Capacity,
1817: NULL, adjusted_capacity,
1818: FND_API.G_MISS_NUM, NULL,
1819: X_Adjusted_Capacity),
1820: fully_rsvd_revals_counter = decode(X_Fully_Rsvd_Revals_Counter,
1821: NULL, fully_rsvd_revals_counter,
1822: FND_API.G_MISS_NUM, NULL,
1818: FND_API.G_MISS_NUM, NULL,
1819: X_Adjusted_Capacity),
1820: fully_rsvd_revals_counter = decode(X_Fully_Rsvd_Revals_Counter,
1821: NULL, fully_rsvd_revals_counter,
1822: FND_API.G_MISS_NUM, NULL,
1823: X_Fully_Rsvd_Revals_Counter),
1824: idled_flag = decode(X_Idled_Flag,
1825: NULL, idled_flag,
1826: FND_API.G_MISS_CHAR, NULL,
1822: FND_API.G_MISS_NUM, NULL,
1823: X_Fully_Rsvd_Revals_Counter),
1824: idled_flag = decode(X_Idled_Flag,
1825: NULL, idled_flag,
1826: FND_API.G_MISS_CHAR, NULL,
1827: X_Idled_Flag),
1828: period_counter_capitalized = decode(X_Period_Counter_Capitalized,
1829: NULL, period_counter_capitalized,
1830: FND_API.G_MISS_NUM, NULL,
1826: FND_API.G_MISS_CHAR, NULL,
1827: X_Idled_Flag),
1828: period_counter_capitalized = decode(X_Period_Counter_Capitalized,
1829: NULL, period_counter_capitalized,
1830: FND_API.G_MISS_NUM, NULL,
1831: X_Period_Counter_Capitalized),
1832: period_counter_fully_reserved = decode(X_PC_Fully_Reserved,
1833: NULL, period_counter_fully_reserved,
1834: FND_API.G_MISS_NUM, NULL,
1830: FND_API.G_MISS_NUM, NULL,
1831: X_Period_Counter_Capitalized),
1832: period_counter_fully_reserved = decode(X_PC_Fully_Reserved,
1833: NULL, period_counter_fully_reserved,
1834: FND_API.G_MISS_NUM, NULL,
1835: X_PC_Fully_Reserved),
1836: period_counter_fully_retired = decode(X_Period_Counter_Fully_Retired,
1837: NULL, period_counter_fully_retired,
1838: FND_API.G_MISS_NUM, NULL,
1834: FND_API.G_MISS_NUM, NULL,
1835: X_PC_Fully_Reserved),
1836: period_counter_fully_retired = decode(X_Period_Counter_Fully_Retired,
1837: NULL, period_counter_fully_retired,
1838: FND_API.G_MISS_NUM, NULL,
1839: X_Period_Counter_Fully_Retired),
1840: production_capacity = decode(X_Production_Capacity,
1841: NULL, production_capacity,
1842: FND_API.G_MISS_NUM, NULL,
1838: FND_API.G_MISS_NUM, NULL,
1839: X_Period_Counter_Fully_Retired),
1840: production_capacity = decode(X_Production_Capacity,
1841: NULL, production_capacity,
1842: FND_API.G_MISS_NUM, NULL,
1843: X_Production_Capacity),
1844: reval_amortization_basis = decode(X_Reval_Amortization_Basis,
1845: NULL, reval_amortization_basis,
1846: FND_API.G_MISS_NUM, NULL,
1842: FND_API.G_MISS_NUM, NULL,
1843: X_Production_Capacity),
1844: reval_amortization_basis = decode(X_Reval_Amortization_Basis,
1845: NULL, reval_amortization_basis,
1846: FND_API.G_MISS_NUM, NULL,
1847: X_Reval_Amortization_Basis),
1848: reval_ceiling = decode(X_Reval_Ceiling,
1849: NULL, reval_ceiling,
1850: FND_API.G_MISS_NUM, NULL,
1846: FND_API.G_MISS_NUM, NULL,
1847: X_Reval_Amortization_Basis),
1848: reval_ceiling = decode(X_Reval_Ceiling,
1849: NULL, reval_ceiling,
1850: FND_API.G_MISS_NUM, NULL,
1851: X_Reval_Ceiling),
1852: unit_of_measure = decode(X_Unit_Of_Measure,
1853: NULL, unit_of_measure,
1854: FND_API.G_MISS_CHAR, NULL,
1850: FND_API.G_MISS_NUM, NULL,
1851: X_Reval_Ceiling),
1852: unit_of_measure = decode(X_Unit_Of_Measure,
1853: NULL, unit_of_measure,
1854: FND_API.G_MISS_CHAR, NULL,
1855: X_Unit_Of_Measure),
1856: unrevalued_cost = decode(X_Unrevalued_Cost,
1857: NULL, unrevalued_cost,
1858: FND_API.G_MISS_NUM, NULL,
1854: FND_API.G_MISS_CHAR, NULL,
1855: X_Unit_Of_Measure),
1856: unrevalued_cost = decode(X_Unrevalued_Cost,
1857: NULL, unrevalued_cost,
1858: FND_API.G_MISS_NUM, NULL,
1859: X_Unrevalued_Cost),
1860: annual_deprn_rounding_flag = decode(X_Annual_Deprn_Rounding_Flag,
1861: NULL, annual_deprn_rounding_flag,
1862: FND_API.G_MISS_CHAR, NULL,
1858: FND_API.G_MISS_NUM, NULL,
1859: X_Unrevalued_Cost),
1860: annual_deprn_rounding_flag = decode(X_Annual_Deprn_Rounding_Flag,
1861: NULL, annual_deprn_rounding_flag,
1862: FND_API.G_MISS_CHAR, NULL,
1863: X_Annual_Deprn_Rounding_Flag),
1864: percent_salvage_value = decode(X_Percent_Salvage_Value,
1865: NULL, percent_salvage_value,
1866: FND_API.G_MISS_NUM, NULL,
1862: FND_API.G_MISS_CHAR, NULL,
1863: X_Annual_Deprn_Rounding_Flag),
1864: percent_salvage_value = decode(X_Percent_Salvage_Value,
1865: NULL, percent_salvage_value,
1866: FND_API.G_MISS_NUM, NULL,
1867: X_Percent_Salvage_Value),
1868: allowed_deprn_limit = decode(X_Allowed_Deprn_Limit,
1869: NULL, allowed_deprn_limit,
1870: FND_API.G_MISS_NUM, NULL,
1866: FND_API.G_MISS_NUM, NULL,
1867: X_Percent_Salvage_Value),
1868: allowed_deprn_limit = decode(X_Allowed_Deprn_Limit,
1869: NULL, allowed_deprn_limit,
1870: FND_API.G_MISS_NUM, NULL,
1871: X_Allowed_Deprn_Limit),
1872: allowed_deprn_limit_amount = decode(X_Allowed_Deprn_Limit_Amount,
1873: NULL, allowed_deprn_limit_amount,
1874: FND_API.G_MISS_NUM, NULL,
1870: FND_API.G_MISS_NUM, NULL,
1871: X_Allowed_Deprn_Limit),
1872: allowed_deprn_limit_amount = decode(X_Allowed_Deprn_Limit_Amount,
1873: NULL, allowed_deprn_limit_amount,
1874: FND_API.G_MISS_NUM, NULL,
1875: X_Allowed_Deprn_Limit_Amount),
1876: period_counter_life_complete = decode(X_Period_Counter_Life_Complete,
1877: NULL, period_counter_life_complete,
1878: FND_API.G_MISS_NUM, NULL,
1874: FND_API.G_MISS_NUM, NULL,
1875: X_Allowed_Deprn_Limit_Amount),
1876: period_counter_life_complete = decode(X_Period_Counter_Life_Complete,
1877: NULL, period_counter_life_complete,
1878: FND_API.G_MISS_NUM, NULL,
1879: X_Period_Counter_Life_Complete),
1880: adjusted_recoverable_cost = decode(X_Adjusted_Recoverable_Cost,
1881: NULL, adjusted_recoverable_cost,
1882: FND_API.G_MISS_NUM, NULL,
1878: FND_API.G_MISS_NUM, NULL,
1879: X_Period_Counter_Life_Complete),
1880: adjusted_recoverable_cost = decode(X_Adjusted_Recoverable_Cost,
1881: NULL, adjusted_recoverable_cost,
1882: FND_API.G_MISS_NUM, NULL,
1883: X_Adjusted_Recoverable_Cost),
1884: group_asset_id = decode(X_group_asset_id,
1885: NULL, group_asset_id,
1886: FND_API.G_MISS_NUM, NULL,
1882: FND_API.G_MISS_NUM, NULL,
1883: X_Adjusted_Recoverable_Cost),
1884: group_asset_id = decode(X_group_asset_id,
1885: NULL, group_asset_id,
1886: FND_API.G_MISS_NUM, NULL,
1887: X_group_asset_id),
1888: salvage_type = decode(X_salvage_type,
1889: NULL, salvage_type,
1890: FND_API.G_MISS_CHAR, NULL,
1886: FND_API.G_MISS_NUM, NULL,
1887: X_group_asset_id),
1888: salvage_type = decode(X_salvage_type,
1889: NULL, salvage_type,
1890: FND_API.G_MISS_CHAR, NULL,
1891: X_salvage_type),
1892: deprn_limit_type = decode(X_deprn_limit_type ,
1893: NULL, deprn_limit_type ,
1894: FND_API.G_MISS_CHAR, NULL,
1890: FND_API.G_MISS_CHAR, NULL,
1891: X_salvage_type),
1892: deprn_limit_type = decode(X_deprn_limit_type ,
1893: NULL, deprn_limit_type ,
1894: FND_API.G_MISS_CHAR, NULL,
1895: X_deprn_limit_type ),
1896: over_depreciate_option = decode(X_over_depreciate_option,
1897: NULL, over_depreciate_option,
1898: FND_API.G_MISS_CHAR, NULL,
1894: FND_API.G_MISS_CHAR, NULL,
1895: X_deprn_limit_type ),
1896: over_depreciate_option = decode(X_over_depreciate_option,
1897: NULL, over_depreciate_option,
1898: FND_API.G_MISS_CHAR, NULL,
1899: X_over_depreciate_option),
1900: super_group_id = decode(X_super_group_id,
1901: NULL, super_group_id,
1902: FND_API.G_MISS_NUM, NULL,
1898: FND_API.G_MISS_CHAR, NULL,
1899: X_over_depreciate_option),
1900: super_group_id = decode(X_super_group_id,
1901: NULL, super_group_id,
1902: FND_API.G_MISS_NUM, NULL,
1903: X_super_group_id),
1904: reduction_rate = decode(X_reduction_rate,
1905: NULL, reduction_rate,
1906: FND_API.G_MISS_NUM, NULL,
1902: FND_API.G_MISS_NUM, NULL,
1903: X_super_group_id),
1904: reduction_rate = decode(X_reduction_rate,
1905: NULL, reduction_rate,
1906: FND_API.G_MISS_NUM, NULL,
1907: X_reduction_rate),
1908: reduce_addition_flag = decode(X_reduce_addition_flag,
1909: NULL, reduce_addition_flag,
1910: FND_API.G_MISS_CHAR, NULL,
1906: FND_API.G_MISS_NUM, NULL,
1907: X_reduction_rate),
1908: reduce_addition_flag = decode(X_reduce_addition_flag,
1909: NULL, reduce_addition_flag,
1910: FND_API.G_MISS_CHAR, NULL,
1911: X_reduce_addition_flag),
1912: reduce_adjustment_flag = decode(X_reduce_adjustment_flag,
1913: NULL, reduce_adjustment_flag,
1914: FND_API.G_MISS_CHAR, NULL,
1910: FND_API.G_MISS_CHAR, NULL,
1911: X_reduce_addition_flag),
1912: reduce_adjustment_flag = decode(X_reduce_adjustment_flag,
1913: NULL, reduce_adjustment_flag,
1914: FND_API.G_MISS_CHAR, NULL,
1915: X_reduce_adjustment_flag),
1916: reduce_retirement_flag = decode(X_reduce_retirement_flag,
1917: NULL, reduce_retirement_flag,
1918: FND_API.G_MISS_CHAR, NULL,
1914: FND_API.G_MISS_CHAR, NULL,
1915: X_reduce_adjustment_flag),
1916: reduce_retirement_flag = decode(X_reduce_retirement_flag,
1917: NULL, reduce_retirement_flag,
1918: FND_API.G_MISS_CHAR, NULL,
1919: X_reduce_retirement_flag),
1920: recognize_gain_loss = decode(X_recognize_gain_loss,
1921: NULL, recognize_gain_loss,
1922: FND_API.G_MISS_CHAR, NULL,
1918: FND_API.G_MISS_CHAR, NULL,
1919: X_reduce_retirement_flag),
1920: recognize_gain_loss = decode(X_recognize_gain_loss,
1921: NULL, recognize_gain_loss,
1922: FND_API.G_MISS_CHAR, NULL,
1923: X_recognize_gain_loss),
1924: recapture_reserve_flag = decode(X_recapture_reserve_flag,
1925: NULL, recapture_reserve_flag,
1926: FND_API.G_MISS_CHAR, NULL,
1922: FND_API.G_MISS_CHAR, NULL,
1923: X_recognize_gain_loss),
1924: recapture_reserve_flag = decode(X_recapture_reserve_flag,
1925: NULL, recapture_reserve_flag,
1926: FND_API.G_MISS_CHAR, NULL,
1927: X_recapture_reserve_flag),
1928: limit_proceeds_flag = decode(X_limit_proceeds_flag,
1929: NULL, limit_proceeds_flag,
1930: FND_API.G_MISS_CHAR, NULL,
1926: FND_API.G_MISS_CHAR, NULL,
1927: X_recapture_reserve_flag),
1928: limit_proceeds_flag = decode(X_limit_proceeds_flag,
1929: NULL, limit_proceeds_flag,
1930: FND_API.G_MISS_CHAR, NULL,
1931: X_limit_proceeds_flag),
1932: terminal_gain_loss = decode(X_terminal_gain_loss,
1933: NULL, terminal_gain_loss,
1934: FND_API.G_MISS_CHAR, NULL,
1930: FND_API.G_MISS_CHAR, NULL,
1931: X_limit_proceeds_flag),
1932: terminal_gain_loss = decode(X_terminal_gain_loss,
1933: NULL, terminal_gain_loss,
1934: FND_API.G_MISS_CHAR, NULL,
1935: X_terminal_gain_loss),
1936: tracking_method = decode(X_tracking_method,
1937: NULL, tracking_method,
1938: FND_API.G_MISS_CHAR, NULL,
1934: FND_API.G_MISS_CHAR, NULL,
1935: X_terminal_gain_loss),
1936: tracking_method = decode(X_tracking_method,
1937: NULL, tracking_method,
1938: FND_API.G_MISS_CHAR, NULL,
1939: X_tracking_method),
1940: allocate_to_fully_rsv_flag = decode(X_allocate_to_fully_rsv_flag,
1941: NULL, allocate_to_fully_rsv_flag,
1942: FND_API.G_MISS_CHAR, NULL,
1938: FND_API.G_MISS_CHAR, NULL,
1939: X_tracking_method),
1940: allocate_to_fully_rsv_flag = decode(X_allocate_to_fully_rsv_flag,
1941: NULL, allocate_to_fully_rsv_flag,
1942: FND_API.G_MISS_CHAR, NULL,
1943: X_allocate_to_fully_rsv_flag),
1944: allocate_to_fully_ret_flag = decode(X_allocate_to_fully_ret_flag,
1945: NULL, allocate_to_fully_ret_flag,
1946: FND_API.G_MISS_CHAR, NULL,
1942: FND_API.G_MISS_CHAR, NULL,
1943: X_allocate_to_fully_rsv_flag),
1944: allocate_to_fully_ret_flag = decode(X_allocate_to_fully_ret_flag,
1945: NULL, allocate_to_fully_ret_flag,
1946: FND_API.G_MISS_CHAR, NULL,
1947: X_allocate_to_fully_ret_flag),
1948: exclude_fully_rsv_flag = decode(X_exclude_fully_rsv_flag,
1949: NULL, exclude_fully_rsv_flag,
1950: FND_API.G_MISS_CHAR, NULL,
1946: FND_API.G_MISS_CHAR, NULL,
1947: X_allocate_to_fully_ret_flag),
1948: exclude_fully_rsv_flag = decode(X_exclude_fully_rsv_flag,
1949: NULL, exclude_fully_rsv_flag,
1950: FND_API.G_MISS_CHAR, NULL,
1951: X_exclude_fully_rsv_flag),
1952: excess_allocation_option = decode(X_excess_allocation_option,
1953: NULL, excess_allocation_option,
1954: FND_API.G_MISS_CHAR, NULL,
1950: FND_API.G_MISS_CHAR, NULL,
1951: X_exclude_fully_rsv_flag),
1952: excess_allocation_option = decode(X_excess_allocation_option,
1953: NULL, excess_allocation_option,
1954: FND_API.G_MISS_CHAR, NULL,
1955: X_excess_allocation_option),
1956: depreciation_option = decode(X_depreciation_option,
1957: NULL, depreciation_option,
1958: FND_API.G_MISS_CHAR, NULL,
1954: FND_API.G_MISS_CHAR, NULL,
1955: X_excess_allocation_option),
1956: depreciation_option = decode(X_depreciation_option,
1957: NULL, depreciation_option,
1958: FND_API.G_MISS_CHAR, NULL,
1959: X_depreciation_option),
1960: member_rollup_flag = decode(X_member_rollup_flag,
1961: NULL, member_rollup_flag,
1962: FND_API.G_MISS_CHAR, NULL,
1958: FND_API.G_MISS_CHAR, NULL,
1959: X_depreciation_option),
1960: member_rollup_flag = decode(X_member_rollup_flag,
1961: NULL, member_rollup_flag,
1962: FND_API.G_MISS_CHAR, NULL,
1963: X_member_rollup_flag),
1964: ytd_proceeds = decode(X_ytd_proceeds,
1965: NULL, ytd_proceeds,
1966: FND_API.G_MISS_NUM, NULL,
1962: FND_API.G_MISS_CHAR, NULL,
1963: X_member_rollup_flag),
1964: ytd_proceeds = decode(X_ytd_proceeds,
1965: NULL, ytd_proceeds,
1966: FND_API.G_MISS_NUM, NULL,
1967: X_ytd_proceeds),
1968: ltd_proceeds = decode(X_ltd_proceeds,
1969: NULL, ltd_proceeds,
1970: FND_API.G_MISS_NUM, NULL,
1966: FND_API.G_MISS_NUM, NULL,
1967: X_ytd_proceeds),
1968: ltd_proceeds = decode(X_ltd_proceeds,
1969: NULL, ltd_proceeds,
1970: FND_API.G_MISS_NUM, NULL,
1971: X_ltd_proceeds),
1972: eofy_reserve = decode(X_eofy_reserve,
1973: NULL, eofy_reserve,
1974: FND_API.G_MISS_NUM, NULL,
1970: FND_API.G_MISS_NUM, NULL,
1971: X_ltd_proceeds),
1972: eofy_reserve = decode(X_eofy_reserve,
1973: NULL, eofy_reserve,
1974: FND_API.G_MISS_NUM, NULL,
1975: X_eofy_reserve),
1976: cip_cost = decode(X_cip_cost,
1977: NULL, cip_cost,
1978: FND_API.G_MISS_NUM, NULL,
1974: FND_API.G_MISS_NUM, NULL,
1975: X_eofy_reserve),
1976: cip_cost = decode(X_cip_cost,
1977: NULL, cip_cost,
1978: FND_API.G_MISS_NUM, NULL,
1979: X_cip_cost),
1980: terminal_gain_loss_amount = decode(X_terminal_gain_loss_amount,
1981: NULL, terminal_gain_loss_amount,
1982: FND_API.G_MISS_NUM, NULL,
1978: FND_API.G_MISS_NUM, NULL,
1979: X_cip_cost),
1980: terminal_gain_loss_amount = decode(X_terminal_gain_loss_amount,
1981: NULL, terminal_gain_loss_amount,
1982: FND_API.G_MISS_NUM, NULL,
1983: X_terminal_gain_loss_amount),
1984: ltd_cost_of_removal = decode(X_ltd_cost_of_removal,
1985: NULL, ltd_cost_of_removal,
1986: FND_API.G_MISS_NUM, NULL,
1982: FND_API.G_MISS_NUM, NULL,
1983: X_terminal_gain_loss_amount),
1984: ltd_cost_of_removal = decode(X_ltd_cost_of_removal,
1985: NULL, ltd_cost_of_removal,
1986: FND_API.G_MISS_NUM, NULL,
1987: X_ltd_cost_of_removal),
1988: exclude_proceeds_from_basis = decode(X_exclude_proceeds_from_basis,
1989: NULL, exclude_proceeds_from_basis,
1990: FND_API.G_MISS_CHAR, NULL,
1986: FND_API.G_MISS_NUM, NULL,
1987: X_ltd_cost_of_removal),
1988: exclude_proceeds_from_basis = decode(X_exclude_proceeds_from_basis,
1989: NULL, exclude_proceeds_from_basis,
1990: FND_API.G_MISS_CHAR, NULL,
1991: X_exclude_proceeds_from_basis),
1992: retirement_deprn_option = decode(X_retirement_deprn_option,
1993: NULL, retirement_deprn_option,
1994: FND_API.G_MISS_CHAR, NULL,
1990: FND_API.G_MISS_CHAR, NULL,
1991: X_exclude_proceeds_from_basis),
1992: retirement_deprn_option = decode(X_retirement_deprn_option,
1993: NULL, retirement_deprn_option,
1994: FND_API.G_MISS_CHAR, NULL,
1995: X_retirement_deprn_option),
1996: terminal_gain_loss_flag = decode(X_terminal_gain_loss_flag,
1997: NULL, terminal_gain_loss_flag,
1998: FND_API.G_MISS_CHAR, NULL,
1994: FND_API.G_MISS_CHAR, NULL,
1995: X_retirement_deprn_option),
1996: terminal_gain_loss_flag = decode(X_terminal_gain_loss_flag,
1997: NULL, terminal_gain_loss_flag,
1998: FND_API.G_MISS_CHAR, NULL,
1999: X_terminal_gain_loss_flag)
2000: WHERE rowid = X_Rowid;
2001: else
2002: UPDATE fa_books
2002: UPDATE fa_books
2003: SET
2004: book_type_code = decode(X_Book_Type_Code,
2005: NULL, book_type_code,
2006: FND_API.G_MISS_CHAR, NULL,
2007: X_Book_Type_Code),
2008: asset_id = decode(X_Asset_Id,
2009: NULL, asset_id,
2010: FND_API.G_MISS_NUM, NULL,
2006: FND_API.G_MISS_CHAR, NULL,
2007: X_Book_Type_Code),
2008: asset_id = decode(X_Asset_Id,
2009: NULL, asset_id,
2010: FND_API.G_MISS_NUM, NULL,
2011: X_Asset_Id),
2012: date_placed_in_service = decode(X_Date_Placed_In_Service,
2013: NULL, date_placed_in_service ,
2014: X_Date_Placed_In_Service),
2019: NULL, deprn_start_date,
2020: X_Deprn_Start_Date),
2021: deprn_method_code = decode(X_Deprn_Method_Code,
2022: NULL, deprn_method_code,
2023: FND_API.G_MISS_CHAR, NULL,
2024: X_Deprn_Method_Code),
2025: life_in_months = decode(X_Life_In_Months,
2026: NULL, life_in_months,
2027: FND_API.G_MISS_NUM, NULL,
2023: FND_API.G_MISS_CHAR, NULL,
2024: X_Deprn_Method_Code),
2025: life_in_months = decode(X_Life_In_Months,
2026: NULL, life_in_months,
2027: FND_API.G_MISS_NUM, NULL,
2028: X_Life_In_Months),
2029: rate_adjustment_factor = decode(X_Rate_Adjustment_Factor,
2030: NULL, rate_adjustment_factor,
2031: FND_API.G_MISS_NUM, NULL,
2027: FND_API.G_MISS_NUM, NULL,
2028: X_Life_In_Months),
2029: rate_adjustment_factor = decode(X_Rate_Adjustment_Factor,
2030: NULL, rate_adjustment_factor,
2031: FND_API.G_MISS_NUM, NULL,
2032: X_Rate_Adjustment_Factor),
2033: adjusted_cost = decode(X_Adjusted_Cost,
2034: NULL, adjusted_cost,
2035: FND_API.G_MISS_NUM, NULL,
2031: FND_API.G_MISS_NUM, NULL,
2032: X_Rate_Adjustment_Factor),
2033: adjusted_cost = decode(X_Adjusted_Cost,
2034: NULL, adjusted_cost,
2035: FND_API.G_MISS_NUM, NULL,
2036: X_Adjusted_Cost),
2037: cost = decode(X_Cost,
2038: NULL, cost,
2039: FND_API.G_MISS_NUM, NULL,
2035: FND_API.G_MISS_NUM, NULL,
2036: X_Adjusted_Cost),
2037: cost = decode(X_Cost,
2038: NULL, cost,
2039: FND_API.G_MISS_NUM, NULL,
2040: X_Cost),
2041: original_cost = decode(X_Original_Cost,
2042: NULL, original_cost,
2043: FND_API.G_MISS_NUM, NULL,
2039: FND_API.G_MISS_NUM, NULL,
2040: X_Cost),
2041: original_cost = decode(X_Original_Cost,
2042: NULL, original_cost,
2043: FND_API.G_MISS_NUM, NULL,
2044: X_Original_Cost),
2045: salvage_value = decode(X_Salvage_Value,
2046: NULL, salvage_value,
2047: FND_API.G_MISS_NUM, NULL,
2043: FND_API.G_MISS_NUM, NULL,
2044: X_Original_Cost),
2045: salvage_value = decode(X_Salvage_Value,
2046: NULL, salvage_value,
2047: FND_API.G_MISS_NUM, NULL,
2048: X_Salvage_Value),
2049: prorate_convention_code = decode(X_Prorate_Convention_Code,
2050: NULL, prorate_convention_code,
2051: FND_API.G_MISS_CHAR, NULL,
2047: FND_API.G_MISS_NUM, NULL,
2048: X_Salvage_Value),
2049: prorate_convention_code = decode(X_Prorate_Convention_Code,
2050: NULL, prorate_convention_code,
2051: FND_API.G_MISS_CHAR, NULL,
2052: X_Prorate_Convention_Code),
2053: prorate_date = decode(X_Prorate_Date,
2054: NULL, prorate_date,
2055: X_Prorate_Date),
2054: NULL, prorate_date,
2055: X_Prorate_Date),
2056: cost_change_flag = decode(X_Cost_Change_Flag,
2057: NULL, cost_change_flag,
2058: FND_API.G_MISS_CHAR, NULL,
2059: X_Cost_Change_Flag),
2060: adjustment_required_status = decode(X_Adjustment_Required_Status,
2061: NULL, adjustment_required_status,
2062: FND_API.G_MISS_CHAR, NULL,
2058: FND_API.G_MISS_CHAR, NULL,
2059: X_Cost_Change_Flag),
2060: adjustment_required_status = decode(X_Adjustment_Required_Status,
2061: NULL, adjustment_required_status,
2062: FND_API.G_MISS_CHAR, NULL,
2063: X_Adjustment_Required_Status),
2064: capitalize_flag = decode(X_Capitalize_Flag,
2065: NULL, capitalize_flag,
2066: FND_API.G_MISS_CHAR, NULL,
2062: FND_API.G_MISS_CHAR, NULL,
2063: X_Adjustment_Required_Status),
2064: capitalize_flag = decode(X_Capitalize_Flag,
2065: NULL, capitalize_flag,
2066: FND_API.G_MISS_CHAR, NULL,
2067: X_Capitalize_Flag),
2068: retirement_pending_flag = decode(X_Retirement_Pending_Flag,
2069: NULL, retirement_pending_flag,
2070: FND_API.G_MISS_CHAR, NULL,
2066: FND_API.G_MISS_CHAR, NULL,
2067: X_Capitalize_Flag),
2068: retirement_pending_flag = decode(X_Retirement_Pending_Flag,
2069: NULL, retirement_pending_flag,
2070: FND_API.G_MISS_CHAR, NULL,
2071: X_Retirement_Pending_Flag),
2072: depreciate_flag = decode(X_Depreciate_Flag,
2073: NULL, depreciate_flag,
2074: FND_API.G_MISS_CHAR, NULL,
2070: FND_API.G_MISS_CHAR, NULL,
2071: X_Retirement_Pending_Flag),
2072: depreciate_flag = decode(X_Depreciate_Flag,
2073: NULL, depreciate_flag,
2074: FND_API.G_MISS_CHAR, NULL,
2075: X_Depreciate_Flag),
2076: --HH group ed.
2077: disabled_flag = decode(X_Disabled_Flag,
2078: NULL, disabled_flag,
2075: X_Depreciate_Flag),
2076: --HH group ed.
2077: disabled_flag = decode(X_Disabled_Flag,
2078: NULL, disabled_flag,
2079: FND_API.G_MISS_CHAR, NULL,
2080: X_Disabled_Flag),
2081: last_update_date = decode(X_Last_Update_Date,
2082: NULL, last_update_date,
2083: X_Last_Update_Date),
2082: NULL, last_update_date,
2083: X_Last_Update_Date),
2084: last_updated_by = decode(X_Last_Updated_By,
2085: NULL, last_updated_by,
2086: FND_API.G_MISS_NUM, NULL,
2087: X_Last_Updated_By),
2088: date_ineffective = decode(X_Date_Ineffective,
2089: NULL, date_ineffective,
2090: X_Date_Ineffective),
2089: NULL, date_ineffective,
2090: X_Date_Ineffective),
2091: transaction_header_id_in = decode(X_Transaction_Header_Id_In,
2092: NULL, transaction_header_id_in,
2093: FND_API.G_MISS_NUM, NULL,
2094: X_Transaction_Header_Id_In),
2095: transaction_header_id_out = decode(X_Transaction_Header_Id_Out,
2096: NULL, transaction_header_id_out,
2097: FND_API.G_MISS_NUM, NULL,
2093: FND_API.G_MISS_NUM, NULL,
2094: X_Transaction_Header_Id_In),
2095: transaction_header_id_out = decode(X_Transaction_Header_Id_Out,
2096: NULL, transaction_header_id_out,
2097: FND_API.G_MISS_NUM, NULL,
2098: X_Transaction_Header_Id_Out),
2099: itc_amount_id = decode(X_Itc_Amount_Id,
2100: NULL, itc_amount_id,
2101: FND_API.G_MISS_NUM, NULL,
2097: FND_API.G_MISS_NUM, NULL,
2098: X_Transaction_Header_Id_Out),
2099: itc_amount_id = decode(X_Itc_Amount_Id,
2100: NULL, itc_amount_id,
2101: FND_API.G_MISS_NUM, NULL,
2102: X_Itc_Amount_Id),
2103: itc_amount = decode(X_Itc_Amount,
2104: NULL, itc_amount,
2105: FND_API.G_MISS_NUM, NULL,
2101: FND_API.G_MISS_NUM, NULL,
2102: X_Itc_Amount_Id),
2103: itc_amount = decode(X_Itc_Amount,
2104: NULL, itc_amount,
2105: FND_API.G_MISS_NUM, NULL,
2106: X_Itc_Amount),
2107: retirement_id = decode(X_Retirement_Id,
2108: NULL, retirement_id,
2109: FND_API.G_MISS_NUM, NULL,
2105: FND_API.G_MISS_NUM, NULL,
2106: X_Itc_Amount),
2107: retirement_id = decode(X_Retirement_Id,
2108: NULL, retirement_id,
2109: FND_API.G_MISS_NUM, NULL,
2110: X_Retirement_Id),
2111: tax_request_id = decode(X_Tax_Request_Id,
2112: NULL, tax_request_id,
2113: FND_API.G_MISS_NUM, NULL,
2109: FND_API.G_MISS_NUM, NULL,
2110: X_Retirement_Id),
2111: tax_request_id = decode(X_Tax_Request_Id,
2112: NULL, tax_request_id,
2113: FND_API.G_MISS_NUM, NULL,
2114: X_Tax_Request_Id),
2115: itc_basis = decode(X_Itc_Basis,
2116: NULL, itc_basis,
2117: FND_API.G_MISS_NUM, NULL,
2113: FND_API.G_MISS_NUM, NULL,
2114: X_Tax_Request_Id),
2115: itc_basis = decode(X_Itc_Basis,
2116: NULL, itc_basis,
2117: FND_API.G_MISS_NUM, NULL,
2118: X_Itc_Basis),
2119: basic_rate = decode(X_Basic_Rate,
2120: NULL, basic_rate,
2121: FND_API.G_MISS_NUM, NULL,
2117: FND_API.G_MISS_NUM, NULL,
2118: X_Itc_Basis),
2119: basic_rate = decode(X_Basic_Rate,
2120: NULL, basic_rate,
2121: FND_API.G_MISS_NUM, NULL,
2122: X_Basic_Rate),
2123: adjusted_rate = decode(X_Adjusted_Rate,
2124: NULL, adjusted_rate,
2125: FND_API.G_MISS_NUM, NULL,
2121: FND_API.G_MISS_NUM, NULL,
2122: X_Basic_Rate),
2123: adjusted_rate = decode(X_Adjusted_Rate,
2124: NULL, adjusted_rate,
2125: FND_API.G_MISS_NUM, NULL,
2126: X_Adjusted_Rate),
2127: bonus_rule = decode(X_Bonus_Rule,
2128: NULL, bonus_rule,
2129: FND_API.G_MISS_CHAR, NULL,
2125: FND_API.G_MISS_NUM, NULL,
2126: X_Adjusted_Rate),
2127: bonus_rule = decode(X_Bonus_Rule,
2128: NULL, bonus_rule,
2129: FND_API.G_MISS_CHAR, NULL,
2130: X_Bonus_Rule),
2131: ceiling_name = decode(X_Ceiling_Name,
2132: NULL, ceiling_name,
2133: FND_API.G_MISS_CHAR, NULL,
2129: FND_API.G_MISS_CHAR, NULL,
2130: X_Bonus_Rule),
2131: ceiling_name = decode(X_Ceiling_Name,
2132: NULL, ceiling_name,
2133: FND_API.G_MISS_CHAR, NULL,
2134: X_Ceiling_Name),
2135: recoverable_cost = decode(X_Recoverable_Cost,
2136: NULL, recoverable_cost,
2137: FND_API.G_MISS_NUM, NULL,
2133: FND_API.G_MISS_CHAR, NULL,
2134: X_Ceiling_Name),
2135: recoverable_cost = decode(X_Recoverable_Cost,
2136: NULL, recoverable_cost,
2137: FND_API.G_MISS_NUM, NULL,
2138: X_Recoverable_Cost),
2139: last_update_login = decode(X_Last_Update_Login,
2140: NULL, last_update_login,
2141: FND_API.G_MISS_NUM, NULL,
2137: FND_API.G_MISS_NUM, NULL,
2138: X_Recoverable_Cost),
2139: last_update_login = decode(X_Last_Update_Login,
2140: NULL, last_update_login,
2141: FND_API.G_MISS_NUM, NULL,
2142: X_Last_Update_Login),
2143: adjusted_capacity = decode(X_Adjusted_Capacity,
2144: NULL, adjusted_capacity,
2145: FND_API.G_MISS_NUM, NULL,
2141: FND_API.G_MISS_NUM, NULL,
2142: X_Last_Update_Login),
2143: adjusted_capacity = decode(X_Adjusted_Capacity,
2144: NULL, adjusted_capacity,
2145: FND_API.G_MISS_NUM, NULL,
2146: X_Adjusted_Capacity),
2147: fully_rsvd_revals_counter = decode(X_Fully_Rsvd_Revals_Counter,
2148: NULL, fully_rsvd_revals_counter,
2149: FND_API.G_MISS_NUM, NULL,
2145: FND_API.G_MISS_NUM, NULL,
2146: X_Adjusted_Capacity),
2147: fully_rsvd_revals_counter = decode(X_Fully_Rsvd_Revals_Counter,
2148: NULL, fully_rsvd_revals_counter,
2149: FND_API.G_MISS_NUM, NULL,
2150: X_Fully_Rsvd_Revals_Counter),
2151: idled_flag = decode(X_Idled_Flag,
2152: NULL, idled_flag,
2153: FND_API.G_MISS_CHAR, NULL,
2149: FND_API.G_MISS_NUM, NULL,
2150: X_Fully_Rsvd_Revals_Counter),
2151: idled_flag = decode(X_Idled_Flag,
2152: NULL, idled_flag,
2153: FND_API.G_MISS_CHAR, NULL,
2154: X_Idled_Flag),
2155: period_counter_capitalized = decode(X_Period_Counter_Capitalized,
2156: NULL, period_counter_capitalized,
2157: FND_API.G_MISS_NUM, NULL,
2153: FND_API.G_MISS_CHAR, NULL,
2154: X_Idled_Flag),
2155: period_counter_capitalized = decode(X_Period_Counter_Capitalized,
2156: NULL, period_counter_capitalized,
2157: FND_API.G_MISS_NUM, NULL,
2158: X_Period_Counter_Capitalized),
2159: period_counter_fully_reserved = decode(X_PC_Fully_Reserved,
2160: NULL, period_counter_fully_reserved,
2161: FND_API.G_MISS_NUM, NULL,
2157: FND_API.G_MISS_NUM, NULL,
2158: X_Period_Counter_Capitalized),
2159: period_counter_fully_reserved = decode(X_PC_Fully_Reserved,
2160: NULL, period_counter_fully_reserved,
2161: FND_API.G_MISS_NUM, NULL,
2162: X_PC_Fully_Reserved),
2163: period_counter_fully_retired = decode(X_Period_Counter_Fully_Retired,
2164: NULL, period_counter_fully_retired,
2165: FND_API.G_MISS_NUM, NULL,
2161: FND_API.G_MISS_NUM, NULL,
2162: X_PC_Fully_Reserved),
2163: period_counter_fully_retired = decode(X_Period_Counter_Fully_Retired,
2164: NULL, period_counter_fully_retired,
2165: FND_API.G_MISS_NUM, NULL,
2166: X_Period_Counter_Fully_Retired),
2167: production_capacity = decode(X_Production_Capacity,
2168: NULL, production_capacity,
2169: FND_API.G_MISS_NUM, NULL,
2165: FND_API.G_MISS_NUM, NULL,
2166: X_Period_Counter_Fully_Retired),
2167: production_capacity = decode(X_Production_Capacity,
2168: NULL, production_capacity,
2169: FND_API.G_MISS_NUM, NULL,
2170: X_Production_Capacity),
2171: reval_amortization_basis = decode(X_Reval_Amortization_Basis,
2172: NULL, reval_amortization_basis,
2173: FND_API.G_MISS_NUM, NULL,
2169: FND_API.G_MISS_NUM, NULL,
2170: X_Production_Capacity),
2171: reval_amortization_basis = decode(X_Reval_Amortization_Basis,
2172: NULL, reval_amortization_basis,
2173: FND_API.G_MISS_NUM, NULL,
2174: X_Reval_Amortization_Basis),
2175: reval_ceiling = decode(X_Reval_Ceiling,
2176: NULL, reval_ceiling,
2177: FND_API.G_MISS_NUM, NULL,
2173: FND_API.G_MISS_NUM, NULL,
2174: X_Reval_Amortization_Basis),
2175: reval_ceiling = decode(X_Reval_Ceiling,
2176: NULL, reval_ceiling,
2177: FND_API.G_MISS_NUM, NULL,
2178: X_Reval_Ceiling),
2179: unit_of_measure = decode(X_Unit_Of_Measure,
2180: NULL, unit_of_measure,
2181: FND_API.G_MISS_CHAR, NULL,
2177: FND_API.G_MISS_NUM, NULL,
2178: X_Reval_Ceiling),
2179: unit_of_measure = decode(X_Unit_Of_Measure,
2180: NULL, unit_of_measure,
2181: FND_API.G_MISS_CHAR, NULL,
2182: X_Unit_Of_Measure),
2183: unrevalued_cost = decode(X_Unrevalued_Cost,
2184: NULL, unrevalued_cost,
2185: FND_API.G_MISS_NUM, NULL,
2181: FND_API.G_MISS_CHAR, NULL,
2182: X_Unit_Of_Measure),
2183: unrevalued_cost = decode(X_Unrevalued_Cost,
2184: NULL, unrevalued_cost,
2185: FND_API.G_MISS_NUM, NULL,
2186: X_Unrevalued_Cost),
2187: annual_deprn_rounding_flag = decode(X_Annual_Deprn_Rounding_Flag,
2188: NULL, annual_deprn_rounding_flag,
2189: FND_API.G_MISS_CHAR, NULL,
2185: FND_API.G_MISS_NUM, NULL,
2186: X_Unrevalued_Cost),
2187: annual_deprn_rounding_flag = decode(X_Annual_Deprn_Rounding_Flag,
2188: NULL, annual_deprn_rounding_flag,
2189: FND_API.G_MISS_CHAR, NULL,
2190: X_Annual_Deprn_Rounding_Flag),
2191: percent_salvage_value = decode(X_Percent_Salvage_Value,
2192: NULL, percent_salvage_value,
2193: FND_API.G_MISS_NUM, NULL,
2189: FND_API.G_MISS_CHAR, NULL,
2190: X_Annual_Deprn_Rounding_Flag),
2191: percent_salvage_value = decode(X_Percent_Salvage_Value,
2192: NULL, percent_salvage_value,
2193: FND_API.G_MISS_NUM, NULL,
2194: X_Percent_Salvage_Value),
2195: allowed_deprn_limit = decode(X_Allowed_Deprn_Limit,
2196: NULL, allowed_deprn_limit,
2197: FND_API.G_MISS_NUM, NULL,
2193: FND_API.G_MISS_NUM, NULL,
2194: X_Percent_Salvage_Value),
2195: allowed_deprn_limit = decode(X_Allowed_Deprn_Limit,
2196: NULL, allowed_deprn_limit,
2197: FND_API.G_MISS_NUM, NULL,
2198: X_Allowed_Deprn_Limit),
2199: allowed_deprn_limit_amount = decode(X_Allowed_Deprn_Limit_Amount,
2200: NULL, allowed_deprn_limit_amount,
2201: FND_API.G_MISS_NUM, NULL,
2197: FND_API.G_MISS_NUM, NULL,
2198: X_Allowed_Deprn_Limit),
2199: allowed_deprn_limit_amount = decode(X_Allowed_Deprn_Limit_Amount,
2200: NULL, allowed_deprn_limit_amount,
2201: FND_API.G_MISS_NUM, NULL,
2202: X_Allowed_Deprn_Limit_Amount),
2203: period_counter_life_complete = decode(X_Period_Counter_Life_Complete,
2204: NULL, period_counter_life_complete,
2205: FND_API.G_MISS_NUM, NULL,
2201: FND_API.G_MISS_NUM, NULL,
2202: X_Allowed_Deprn_Limit_Amount),
2203: period_counter_life_complete = decode(X_Period_Counter_Life_Complete,
2204: NULL, period_counter_life_complete,
2205: FND_API.G_MISS_NUM, NULL,
2206: X_Period_Counter_Life_Complete),
2207: adjusted_recoverable_cost = decode(X_Adjusted_Recoverable_Cost,
2208: NULL, adjusted_recoverable_cost,
2209: FND_API.G_MISS_NUM, NULL,
2205: FND_API.G_MISS_NUM, NULL,
2206: X_Period_Counter_Life_Complete),
2207: adjusted_recoverable_cost = decode(X_Adjusted_Recoverable_Cost,
2208: NULL, adjusted_recoverable_cost,
2209: FND_API.G_MISS_NUM, NULL,
2210: X_Adjusted_Recoverable_Cost),
2211: group_asset_id = decode(X_group_asset_id,
2212: NULL, group_asset_id,
2213: FND_API.G_MISS_NUM, NULL,
2209: FND_API.G_MISS_NUM, NULL,
2210: X_Adjusted_Recoverable_Cost),
2211: group_asset_id = decode(X_group_asset_id,
2212: NULL, group_asset_id,
2213: FND_API.G_MISS_NUM, NULL,
2214: X_group_asset_id),
2215: salvage_type = decode(X_salvage_type,
2216: NULL, salvage_type,
2217: FND_API.G_MISS_CHAR, NULL,
2213: FND_API.G_MISS_NUM, NULL,
2214: X_group_asset_id),
2215: salvage_type = decode(X_salvage_type,
2216: NULL, salvage_type,
2217: FND_API.G_MISS_CHAR, NULL,
2218: X_salvage_type),
2219: deprn_limit_type = decode(X_deprn_limit_type ,
2220: NULL, deprn_limit_type ,
2221: FND_API.G_MISS_CHAR, NULL,
2217: FND_API.G_MISS_CHAR, NULL,
2218: X_salvage_type),
2219: deprn_limit_type = decode(X_deprn_limit_type ,
2220: NULL, deprn_limit_type ,
2221: FND_API.G_MISS_CHAR, NULL,
2222: X_deprn_limit_type ),
2223: over_depreciate_option = decode(X_over_depreciate_option,
2224: NULL, over_depreciate_option,
2225: FND_API.G_MISS_CHAR, NULL,
2221: FND_API.G_MISS_CHAR, NULL,
2222: X_deprn_limit_type ),
2223: over_depreciate_option = decode(X_over_depreciate_option,
2224: NULL, over_depreciate_option,
2225: FND_API.G_MISS_CHAR, NULL,
2226: X_over_depreciate_option),
2227: super_group_id = decode(X_super_group_id,
2228: NULL, super_group_id,
2229: FND_API.G_MISS_NUM, NULL,
2225: FND_API.G_MISS_CHAR, NULL,
2226: X_over_depreciate_option),
2227: super_group_id = decode(X_super_group_id,
2228: NULL, super_group_id,
2229: FND_API.G_MISS_NUM, NULL,
2230: X_super_group_id),
2231: reduction_rate = decode(X_reduction_rate,
2232: NULL, reduction_rate,
2233: FND_API.G_MISS_NUM, NULL,
2229: FND_API.G_MISS_NUM, NULL,
2230: X_super_group_id),
2231: reduction_rate = decode(X_reduction_rate,
2232: NULL, reduction_rate,
2233: FND_API.G_MISS_NUM, NULL,
2234: X_reduction_rate),
2235: reduce_addition_flag = decode(X_reduce_addition_flag,
2236: NULL, reduce_addition_flag,
2237: FND_API.G_MISS_CHAR, NULL,
2233: FND_API.G_MISS_NUM, NULL,
2234: X_reduction_rate),
2235: reduce_addition_flag = decode(X_reduce_addition_flag,
2236: NULL, reduce_addition_flag,
2237: FND_API.G_MISS_CHAR, NULL,
2238: X_reduce_addition_flag),
2239: reduce_adjustment_flag = decode(X_reduce_adjustment_flag,
2240: NULL, reduce_adjustment_flag,
2241: FND_API.G_MISS_CHAR, NULL,
2237: FND_API.G_MISS_CHAR, NULL,
2238: X_reduce_addition_flag),
2239: reduce_adjustment_flag = decode(X_reduce_adjustment_flag,
2240: NULL, reduce_adjustment_flag,
2241: FND_API.G_MISS_CHAR, NULL,
2242: X_reduce_adjustment_flag),
2243: reduce_retirement_flag = decode(X_reduce_retirement_flag,
2244: NULL, reduce_retirement_flag,
2245: FND_API.G_MISS_CHAR, NULL,
2241: FND_API.G_MISS_CHAR, NULL,
2242: X_reduce_adjustment_flag),
2243: reduce_retirement_flag = decode(X_reduce_retirement_flag,
2244: NULL, reduce_retirement_flag,
2245: FND_API.G_MISS_CHAR, NULL,
2246: X_reduce_retirement_flag),
2247: recognize_gain_loss = decode(X_recognize_gain_loss,
2248: NULL, recognize_gain_loss,
2249: FND_API.G_MISS_CHAR, NULL,
2245: FND_API.G_MISS_CHAR, NULL,
2246: X_reduce_retirement_flag),
2247: recognize_gain_loss = decode(X_recognize_gain_loss,
2248: NULL, recognize_gain_loss,
2249: FND_API.G_MISS_CHAR, NULL,
2250: X_recognize_gain_loss),
2251: recapture_reserve_flag = decode(X_recapture_reserve_flag,
2252: NULL, recapture_reserve_flag,
2253: FND_API.G_MISS_CHAR, NULL,
2249: FND_API.G_MISS_CHAR, NULL,
2250: X_recognize_gain_loss),
2251: recapture_reserve_flag = decode(X_recapture_reserve_flag,
2252: NULL, recapture_reserve_flag,
2253: FND_API.G_MISS_CHAR, NULL,
2254: X_recapture_reserve_flag),
2255: limit_proceeds_flag = decode(X_limit_proceeds_flag,
2256: NULL, limit_proceeds_flag,
2257: FND_API.G_MISS_CHAR, NULL,
2253: FND_API.G_MISS_CHAR, NULL,
2254: X_recapture_reserve_flag),
2255: limit_proceeds_flag = decode(X_limit_proceeds_flag,
2256: NULL, limit_proceeds_flag,
2257: FND_API.G_MISS_CHAR, NULL,
2258: X_limit_proceeds_flag),
2259: terminal_gain_loss = decode(X_terminal_gain_loss,
2260: NULL, terminal_gain_loss,
2261: FND_API.G_MISS_CHAR, NULL,
2257: FND_API.G_MISS_CHAR, NULL,
2258: X_limit_proceeds_flag),
2259: terminal_gain_loss = decode(X_terminal_gain_loss,
2260: NULL, terminal_gain_loss,
2261: FND_API.G_MISS_CHAR, NULL,
2262: X_terminal_gain_loss),
2263: tracking_method = decode(X_tracking_method,
2264: NULL, tracking_method,
2265: FND_API.G_MISS_CHAR, NULL,
2261: FND_API.G_MISS_CHAR, NULL,
2262: X_terminal_gain_loss),
2263: tracking_method = decode(X_tracking_method,
2264: NULL, tracking_method,
2265: FND_API.G_MISS_CHAR, NULL,
2266: X_tracking_method),
2267: allocate_to_fully_rsv_flag = decode(X_allocate_to_fully_rsv_flag,
2268: NULL, allocate_to_fully_rsv_flag,
2269: FND_API.G_MISS_CHAR, NULL,
2265: FND_API.G_MISS_CHAR, NULL,
2266: X_tracking_method),
2267: allocate_to_fully_rsv_flag = decode(X_allocate_to_fully_rsv_flag,
2268: NULL, allocate_to_fully_rsv_flag,
2269: FND_API.G_MISS_CHAR, NULL,
2270: X_allocate_to_fully_rsv_flag),
2271: allocate_to_fully_ret_flag = decode(X_allocate_to_fully_ret_flag,
2272: NULL, allocate_to_fully_ret_flag,
2273: FND_API.G_MISS_CHAR, NULL,
2269: FND_API.G_MISS_CHAR, NULL,
2270: X_allocate_to_fully_rsv_flag),
2271: allocate_to_fully_ret_flag = decode(X_allocate_to_fully_ret_flag,
2272: NULL, allocate_to_fully_ret_flag,
2273: FND_API.G_MISS_CHAR, NULL,
2274: X_allocate_to_fully_ret_flag),
2275: exclude_fully_rsv_flag = decode(X_exclude_fully_rsv_flag,
2276: NULL, exclude_fully_rsv_flag,
2277: FND_API.G_MISS_CHAR, NULL,
2273: FND_API.G_MISS_CHAR, NULL,
2274: X_allocate_to_fully_ret_flag),
2275: exclude_fully_rsv_flag = decode(X_exclude_fully_rsv_flag,
2276: NULL, exclude_fully_rsv_flag,
2277: FND_API.G_MISS_CHAR, NULL,
2278: X_exclude_fully_rsv_flag),
2279: excess_allocation_option = decode(X_excess_allocation_option,
2280: NULL, excess_allocation_option,
2281: FND_API.G_MISS_CHAR, NULL,
2277: FND_API.G_MISS_CHAR, NULL,
2278: X_exclude_fully_rsv_flag),
2279: excess_allocation_option = decode(X_excess_allocation_option,
2280: NULL, excess_allocation_option,
2281: FND_API.G_MISS_CHAR, NULL,
2282: X_excess_allocation_option),
2283: depreciation_option = decode(X_depreciation_option,
2284: NULL, depreciation_option,
2285: FND_API.G_MISS_CHAR, NULL,
2281: FND_API.G_MISS_CHAR, NULL,
2282: X_excess_allocation_option),
2283: depreciation_option = decode(X_depreciation_option,
2284: NULL, depreciation_option,
2285: FND_API.G_MISS_CHAR, NULL,
2286: X_depreciation_option),
2287: member_rollup_flag = decode(X_member_rollup_flag,
2288: NULL, member_rollup_flag,
2289: FND_API.G_MISS_CHAR, NULL,
2285: FND_API.G_MISS_CHAR, NULL,
2286: X_depreciation_option),
2287: member_rollup_flag = decode(X_member_rollup_flag,
2288: NULL, member_rollup_flag,
2289: FND_API.G_MISS_CHAR, NULL,
2290: X_member_rollup_flag),
2291: ytd_proceeds = decode(X_ytd_proceeds,
2292: NULL, ytd_proceeds,
2293: FND_API.G_MISS_NUM, NULL,
2289: FND_API.G_MISS_CHAR, NULL,
2290: X_member_rollup_flag),
2291: ytd_proceeds = decode(X_ytd_proceeds,
2292: NULL, ytd_proceeds,
2293: FND_API.G_MISS_NUM, NULL,
2294: X_ytd_proceeds),
2295: ltd_proceeds = decode(X_ltd_proceeds,
2296: NULL, ltd_proceeds,
2297: FND_API.G_MISS_NUM, NULL,
2293: FND_API.G_MISS_NUM, NULL,
2294: X_ytd_proceeds),
2295: ltd_proceeds = decode(X_ltd_proceeds,
2296: NULL, ltd_proceeds,
2297: FND_API.G_MISS_NUM, NULL,
2298: X_ltd_proceeds),
2299: eofy_reserve = decode(X_eofy_reserve,
2300: NULL, eofy_reserve,
2301: FND_API.G_MISS_NUM, NULL,
2297: FND_API.G_MISS_NUM, NULL,
2298: X_ltd_proceeds),
2299: eofy_reserve = decode(X_eofy_reserve,
2300: NULL, eofy_reserve,
2301: FND_API.G_MISS_NUM, NULL,
2302: X_eofy_reserve),
2303: cip_cost = decode(X_cip_cost,
2304: NULL, cip_cost,
2305: FND_API.G_MISS_NUM, NULL,
2301: FND_API.G_MISS_NUM, NULL,
2302: X_eofy_reserve),
2303: cip_cost = decode(X_cip_cost,
2304: NULL, cip_cost,
2305: FND_API.G_MISS_NUM, NULL,
2306: X_cip_cost),
2307: terminal_gain_loss_amount = decode(X_terminal_gain_loss_amount,
2308: NULL, terminal_gain_loss_amount,
2309: FND_API.G_MISS_NUM, NULL,
2305: FND_API.G_MISS_NUM, NULL,
2306: X_cip_cost),
2307: terminal_gain_loss_amount = decode(X_terminal_gain_loss_amount,
2308: NULL, terminal_gain_loss_amount,
2309: FND_API.G_MISS_NUM, NULL,
2310: X_terminal_gain_loss_amount),
2311: ltd_cost_of_removal = decode(X_ltd_cost_of_removal,
2312: NULL, ltd_cost_of_removal,
2313: FND_API.G_MISS_NUM, NULL,
2309: FND_API.G_MISS_NUM, NULL,
2310: X_terminal_gain_loss_amount),
2311: ltd_cost_of_removal = decode(X_ltd_cost_of_removal,
2312: NULL, ltd_cost_of_removal,
2313: FND_API.G_MISS_NUM, NULL,
2314: X_ltd_cost_of_removal),
2315: exclude_proceeds_from_basis = decode(X_exclude_proceeds_from_basis,
2316: NULL, exclude_proceeds_from_basis,
2317: FND_API.G_MISS_CHAR, NULL,
2313: FND_API.G_MISS_NUM, NULL,
2314: X_ltd_cost_of_removal),
2315: exclude_proceeds_from_basis = decode(X_exclude_proceeds_from_basis,
2316: NULL, exclude_proceeds_from_basis,
2317: FND_API.G_MISS_CHAR, NULL,
2318: X_exclude_proceeds_from_basis),
2319: retirement_deprn_option = decode(X_retirement_deprn_option,
2320: NULL, retirement_deprn_option,
2321: FND_API.G_MISS_CHAR, NULL,
2317: FND_API.G_MISS_CHAR, NULL,
2318: X_exclude_proceeds_from_basis),
2319: retirement_deprn_option = decode(X_retirement_deprn_option,
2320: NULL, retirement_deprn_option,
2321: FND_API.G_MISS_CHAR, NULL,
2322: X_retirement_deprn_option),
2323: terminal_gain_loss_flag = decode(X_terminal_gain_loss_flag,
2324: NULL, terminal_gain_loss_flag,
2325: FND_API.G_MISS_CHAR, NULL,
2321: FND_API.G_MISS_CHAR, NULL,
2322: X_retirement_deprn_option),
2323: terminal_gain_loss_flag = decode(X_terminal_gain_loss_flag,
2324: NULL, terminal_gain_loss_flag,
2325: FND_API.G_MISS_CHAR, NULL,
2326: X_terminal_gain_loss_flag)
2327: WHERE asset_id = X_Asset_Id
2328: AND book_type_code = X_Book_Type_Code
2329: AND transaction_header_id_out is null;