private int deleteCostDetail(
IDocumentLine model, I_C_AcctSchema as, int M_CostElement_ID, int M_AttributeSetInstance_ID) {
// Delete Unprocessed zero Differences
String sql =
"DELETE FROM "
+ MCostDetail.Table_Name
+ " WHERE Processed='N' AND COALESCE(DeltaAmt,0)=0 AND COALESCE(DeltaQty,0)=0"
+ " AND "
+ model.get_TableName()
+ "_ID=?"
+ " AND "
+ MCostDetail.COLUMNNAME_C_AcctSchema_ID
+ "=?"
+ " AND "
+ MCostDetail.COLUMNNAME_M_AttributeSetInstance_ID
+ "=?"
// + " AND "+MCostDetail.COLUMNNAME_M_CostType_ID+"=?"
+ " AND "
+ MCostDetail.COLUMNNAME_M_CostElement_ID
+ "=?";
Object[] parameters =
new Object[] {
model.get_ID(),
as.getC_AcctSchema_ID(),
M_AttributeSetInstance_ID,
// as.getM_CostType_ID(),
M_CostElement_ID
};
int no = DB.executeUpdateEx(sql, parameters, model.get_TrxName());
if (no != 0) log.info("Deleted #" + no);
return no;
}
