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