Java Code Examples for java.util.Calendar#AUGUST

The following examples show how to use java.util.Calendar#AUGUST . These examples are extracted from open source projects. You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may want to check out the right sidebar which shows the related API usage.
Example 1
private static int getDaysInMonth(int month, int year) {
    switch (month) {
        case Calendar.JANUARY:
        case Calendar.MARCH:
        case Calendar.MAY:
        case Calendar.JULY:
        case Calendar.AUGUST:
        case Calendar.OCTOBER:
        case Calendar.DECEMBER:
            return 31;
        case Calendar.APRIL:
        case Calendar.JUNE:
        case Calendar.SEPTEMBER:
        case Calendar.NOVEMBER:
            return 30;
        case Calendar.FEBRUARY:
            return (year % 4 == 0) ? 29 : 28;
        default:
            throw new IllegalArgumentException("Invalid Month");
    }
}
 
Example 2
Source Project: cathode   File: Utils.java    License: Apache License 2.0 6 votes vote down vote up
public static int getDaysInMonth(int month, int year) {
    switch (month) {
        case Calendar.JANUARY:
        case Calendar.MARCH:
        case Calendar.MAY:
        case Calendar.JULY:
        case Calendar.AUGUST:
        case Calendar.OCTOBER:
        case Calendar.DECEMBER:
            return 31;
        case Calendar.APRIL:
        case Calendar.JUNE:
        case Calendar.SEPTEMBER:
        case Calendar.NOVEMBER:
            return 30;
        case Calendar.FEBRUARY:
            return (year % 4 == 0) ? 29 : 28;
        default:
            throw new IllegalArgumentException("Invalid Month");
    }
}
 
Example 3
Source Project: CalendarListview   File: CalendarUtils.java    License: MIT License 6 votes vote down vote up
public static int getDaysInMonth(int month, int year) {
       switch (month) {
           case Calendar.JANUARY:
           case Calendar.MARCH:
           case Calendar.MAY:
           case Calendar.JULY:
           case Calendar.AUGUST:
           case Calendar.OCTOBER:
           case Calendar.DECEMBER:
               return 31;
           case Calendar.APRIL:
           case Calendar.JUNE:
           case Calendar.SEPTEMBER:
           case Calendar.NOVEMBER:
               return 30;
           case Calendar.FEBRUARY:
               return ((year % 4 == 0 && year % 100 != 0) || (year % 400 == 0)) ? 29 : 28;
           default:
               throw new IllegalArgumentException("Invalid Month");
       }
}
 
Example 4
Source Project: AirCalendar   File: CalendarUtils.java    License: MIT License 6 votes vote down vote up
public static int getDaysInMonth(int month, int year) {
       switch (month) {
           case Calendar.JANUARY:
           case Calendar.MARCH:
           case Calendar.MAY:
           case Calendar.JULY:
           case Calendar.AUGUST:
           case Calendar.OCTOBER:
           case Calendar.DECEMBER:
               return 31;
           case Calendar.APRIL:
           case Calendar.JUNE:
           case Calendar.SEPTEMBER:
           case Calendar.NOVEMBER:
               return 30;
           case Calendar.FEBRUARY:
               return ((year % 4 == 0 && year % 100 != 0) || (year % 400 == 0)) ? 28 : 29;
           default:
               throw new IllegalArgumentException("Invalid Month");
       }
}
 
Example 5
Source Project: BottomSheetPickers   File: Utils.java    License: Apache License 2.0 6 votes vote down vote up
public static int getDaysInMonth(int month, int year) {
    switch (month) {
        case Calendar.JANUARY:
        case Calendar.MARCH:
        case Calendar.MAY:
        case Calendar.JULY:
        case Calendar.AUGUST:
        case Calendar.OCTOBER:
        case Calendar.DECEMBER:
            return 31;
        case Calendar.APRIL:
        case Calendar.JUNE:
        case Calendar.SEPTEMBER:
        case Calendar.NOVEMBER:
            return 30;
        case Calendar.FEBRUARY:
            return (year % 4 == 0) ? 29 : 28;
        default:
            throw new IllegalArgumentException("Invalid Month");
    }
}
 
Example 6
Source Project: SublimePicker   File: SUtils.java    License: Apache License 2.0 6 votes vote down vote up
public static int getDaysInMonth(int month, int year) {
    switch (month) {
        case Calendar.JANUARY:
        case Calendar.MARCH:
        case Calendar.MAY:
        case Calendar.JULY:
        case Calendar.AUGUST:
        case Calendar.OCTOBER:
        case Calendar.DECEMBER:
            return 31;
        case Calendar.APRIL:
        case Calendar.JUNE:
        case Calendar.SEPTEMBER:
        case Calendar.NOVEMBER:
            return 30;
        case Calendar.FEBRUARY:
            // This is not correct. See isLeapYear(int) above
            //return (year % 4 == 0) ? 29 : 28;
            return isLeapYear(year) ? 29 : 28;
        default:
            throw new IllegalArgumentException("Invalid Month");
    }
}
 
Example 7
public void Test4278609() {
    SimpleTimeZone tz = new SimpleTimeZone(0, "MyTimeZone",
                           /* DST start day: August, 1, 0:00 */
                           Calendar.AUGUST, 1, 0, 0,
                           /* DST end day: January, 1, 0:00 (wall-clock)*/
                           Calendar.JANUARY, 1, 0, 0,
                           60 * 60 * 1000);

    Calendar cal = new GregorianCalendar(TimeZone.getTimeZone("GMT"));

    // setting a date using GMT zone just after the end rule of tz zone
    cal.clear();
    cal.set(Calendar.ERA, GregorianCalendar.AD);
    cal.set(1998, Calendar.DECEMBER, 31, 23, 01, 00);

    Date date = cal.getTime();

    int millis = cal.get(Calendar.HOUR_OF_DAY) * 3600000
                 + cal.get(Calendar.MINUTE) * 60000
                 + cal.get(Calendar.SECOND) * 1000
                 + cal.get(Calendar.MILLISECOND);
    /* we must use standard local time */
    millis += tz.getRawOffset();

    int offset = tz.getOffset(cal.get(Calendar.ERA),
                              cal.get(Calendar.YEAR),
                              cal.get(Calendar.MONTH),
                              cal.get(Calendar.DATE),
                              cal.get(Calendar.DAY_OF_WEEK),
                              millis);

    if (offset != 0) {
        SimpleDateFormat format = new SimpleDateFormat("dd MMM HH:mm:ss zzz",
                                                       Locale.US);
        format.setTimeZone(tz);
        errln("Wrong DST transition: " + tz
              + "\na date just after DST = " + format.format(date)
              + "\ngetOffset = " + offset);
    }
}
 
Example 8
public void Test4278609() {
    SimpleTimeZone tz = new SimpleTimeZone(0, "MyTimeZone",
                           /* DST start day: August, 1, 0:00 */
                           Calendar.AUGUST, 1, 0, 0,
                           /* DST end day: January, 1, 0:00 (wall-clock)*/
                           Calendar.JANUARY, 1, 0, 0,
                           60 * 60 * 1000);

    Calendar cal = new GregorianCalendar(TimeZone.getTimeZone("GMT"));

    // setting a date using GMT zone just after the end rule of tz zone
    cal.clear();
    cal.set(Calendar.ERA, GregorianCalendar.AD);
    cal.set(1998, Calendar.DECEMBER, 31, 23, 01, 00);

    Date date = cal.getTime();

    int millis = cal.get(Calendar.HOUR_OF_DAY) * 3600000
                 + cal.get(Calendar.MINUTE) * 60000
                 + cal.get(Calendar.SECOND) * 1000
                 + cal.get(Calendar.MILLISECOND);
    /* we must use standard local time */
    millis += tz.getRawOffset();

    int offset = tz.getOffset(cal.get(Calendar.ERA),
                              cal.get(Calendar.YEAR),
                              cal.get(Calendar.MONTH),
                              cal.get(Calendar.DATE),
                              cal.get(Calendar.DAY_OF_WEEK),
                              millis);

    if (offset != 0) {
        SimpleDateFormat format = new SimpleDateFormat("dd MMM HH:mm:ss zzz",
                                                       Locale.US);
        format.setTimeZone(tz);
        errln("Wrong DST transition: " + tz
              + "\na date just after DST = " + format.format(date)
              + "\ngetOffset = " + offset);
    }
}
 
Example 9
Source Project: UnityOBBDownloader   File: HttpDateTime.java    License: Apache License 2.0 5 votes vote down vote up
private static int getMonth(String monthString) {
    int hash = Character.toLowerCase(monthString.charAt(0)) +
            Character.toLowerCase(monthString.charAt(1)) +
            Character.toLowerCase(monthString.charAt(2)) - 3 * 'a';
    switch (hash) {
        case 22:
            return Calendar.JANUARY;
        case 10:
            return Calendar.FEBRUARY;
        case 29:
            return Calendar.MARCH;
        case 32:
            return Calendar.APRIL;
        case 36:
            return Calendar.MAY;
        case 42:
            return Calendar.JUNE;
        case 40:
            return Calendar.JULY;
        case 26:
            return Calendar.AUGUST;
        case 37:
            return Calendar.SEPTEMBER;
        case 35:
            return Calendar.OCTOBER;
        case 48:
            return Calendar.NOVEMBER;
        case 9:
            return Calendar.DECEMBER;
        default:
            throw new IllegalArgumentException();
    }
}
 
Example 10
Source Project: JavaMainRepo   File: Shark.java    License: Apache License 2.0 5 votes vote down vote up
@Override
public double getPredisposition() throws Exception {

	Calendar date = GregorianCalendar.getInstance();
	if (date.get(Calendar.MONTH) == Calendar.AUGUST) {
		return 0.15;
	} else {
		return 0;
	}
}
 
Example 11
Source Project: QtAndroidTools   File: HttpDateTime.java    License: MIT License 5 votes vote down vote up
private static int getMonth(String monthString) {
    int hash = Character.toLowerCase(monthString.charAt(0)) +
            Character.toLowerCase(monthString.charAt(1)) +
            Character.toLowerCase(monthString.charAt(2)) - 3 * 'a';
    switch (hash) {
        case 22:
            return Calendar.JANUARY;
        case 10:
            return Calendar.FEBRUARY;
        case 29:
            return Calendar.MARCH;
        case 32:
            return Calendar.APRIL;
        case 36:
            return Calendar.MAY;
        case 42:
            return Calendar.JUNE;
        case 40:
            return Calendar.JULY;
        case 26:
            return Calendar.AUGUST;
        case 37:
            return Calendar.SEPTEMBER;
        case 35:
            return Calendar.OCTOBER;
        case 48:
            return Calendar.NOVEMBER;
        case 9:
            return Calendar.DECEMBER;
        default:
            throw new IllegalArgumentException();
    }
}
 
Example 12
public String getMonthString() {
	int w = getMonth();
	StringBuilder s = new StringBuilder();
	if (w == Calendar.JANUARY)
		s.append("Jan");
	else if (w == Calendar.FEBRUARY)
		s.append("Feb");
	else if (w == Calendar.MARCH)
		s.append("Mar");
	else if (w == Calendar.APRIL)
		s.append("Apr");
	else if (w == Calendar.MAY)
		s.append("May");
	else if (w == Calendar.JUNE)
		s.append("Jun");
	else if (w == Calendar.JULY)
		s.append("Jul");
	else if (w == Calendar.AUGUST)
		s.append("Aug");
	else if (w == Calendar.SEPTEMBER)
		s.append("Sep");
	else if (w == Calendar.OCTOBER)
		s.append("Oct");
	else if (w == Calendar.NOVEMBER)
		s.append("Nov");
	else if (w == Calendar.DECEMBER)
		s.append("Dec");
	return s.toString();
}
 
Example 13
Source Project: Travel-Mate   File: UpcomingWeekendsActivity.java    License: MIT License 5 votes vote down vote up
private int getMonthByString(String month) {
    switch (month) {
        case "January":
            return Calendar.JANUARY;
        case "February":
            return Calendar.FEBRUARY;
        case "March":
            return Calendar.MARCH;
        case "April":
            return Calendar.APRIL;
        case "May":
            return Calendar.MAY;
        case "June":
            return Calendar.JUNE;
        case "July":
            return Calendar.JULY;
        case "August":
            return Calendar.AUGUST;
        case "September":
            return Calendar.SEPTEMBER;
        case "October":
            return Calendar.OCTOBER;
        case "November":
            return Calendar.NOVEMBER;
        case "December":
            return Calendar.DECEMBER;
    }
    return -1;
}
 
Example 14
private static int getMonth(String monthString) {
	int hash = Character.toLowerCase(monthString.charAt(0))
			+ Character.toLowerCase(monthString.charAt(1))
			+ Character.toLowerCase(monthString.charAt(2)) - 3 * 'a';
	switch (hash) {
	case 22:
		return Calendar.JANUARY;
	case 10:
		return Calendar.FEBRUARY;
	case 29:
		return Calendar.MARCH;
	case 32:
		return Calendar.APRIL;
	case 36:
		return Calendar.MAY;
	case 42:
		return Calendar.JUNE;
	case 40:
		return Calendar.JULY;
	case 26:
		return Calendar.AUGUST;
	case 37:
		return Calendar.SEPTEMBER;
	case 35:
		return Calendar.OCTOBER;
	case 48:
		return Calendar.NOVEMBER;
	case 9:
		return Calendar.DECEMBER;
	default:
		throw new IllegalArgumentException();
	}
}
 
Example 15
Source Project: play-apk-expansion   File: HttpDateTime.java    License: Apache License 2.0 5 votes vote down vote up
private static int getMonth(String monthString) {
    int hash = Character.toLowerCase(monthString.charAt(0)) +
            Character.toLowerCase(monthString.charAt(1)) +
            Character.toLowerCase(monthString.charAt(2)) - 3 * 'a';
    switch (hash) {
        case 22:
            return Calendar.JANUARY;
        case 10:
            return Calendar.FEBRUARY;
        case 29:
            return Calendar.MARCH;
        case 32:
            return Calendar.APRIL;
        case 36:
            return Calendar.MAY;
        case 42:
            return Calendar.JUNE;
        case 40:
            return Calendar.JULY;
        case 26:
            return Calendar.AUGUST;
        case 37:
            return Calendar.SEPTEMBER;
        case 35:
            return Calendar.OCTOBER;
        case 48:
            return Calendar.NOVEMBER;
        case 9:
            return Calendar.DECEMBER;
        default:
            throw new IllegalArgumentException();
    }
}
 
Example 16
Source Project: JavaMainRepo   File: Shark.java    License: Apache License 2.0 5 votes vote down vote up
@Override
public double getPredisposition() throws Exception {

	Calendar date = GregorianCalendar.getInstance();
	if (date.get(Calendar.MONTH) == Calendar.AUGUST) {
		return 0.15;
	} else {
		return 0;
	}
}
 
Example 17
/**
    Appends a date in the format "YYYY-mm-dd HH:mm:ss,SSS"
    to <code>sbuf</code>. For example: "1999-11-27 15:49:37,459".

    @param sbuf the <code>StringBuffer</code> to write to
 */
 public
 StringBuffer format(Date date, StringBuffer sbuf,
	      FieldPosition fieldPosition) {

   long now = date.getTime();
   int millis = (int)(now % 1000);

   if ((now - millis) != lastTime) {
     // We reach this point at most once per second
     // across all threads instead of each time format()
     // is called. This saves considerable CPU time.

     calendar.setTime(date);

     int start = sbuf.length();

     int year =  calendar.get(Calendar.YEAR);
     sbuf.append(year);

     String month;
     switch(calendar.get(Calendar.MONTH)) {
     case Calendar.JANUARY: month = "-01-"; break;
     case Calendar.FEBRUARY: month = "-02-";  break;
     case Calendar.MARCH: month = "-03-"; break;
     case Calendar.APRIL: month = "-04-";  break;
     case Calendar.MAY: month = "-05-"; break;
     case Calendar.JUNE: month = "-06-";  break;
     case Calendar.JULY: month = "-07-"; break;
     case Calendar.AUGUST: month = "-08-";  break;
     case Calendar.SEPTEMBER: month = "-09-"; break;
     case Calendar.OCTOBER: month = "-10-"; break;
     case Calendar.NOVEMBER: month = "-11-";  break;
     case Calendar.DECEMBER: month = "-12-";  break;
     default: month = "-NA-"; break;
     }
     sbuf.append(month);

     int day = calendar.get(Calendar.DAY_OF_MONTH);
     if(day < 10)
sbuf.append('0');
     sbuf.append(day);

     sbuf.append(' ');

     int hour = calendar.get(Calendar.HOUR_OF_DAY);
     if(hour < 10) {
sbuf.append('0');
     }
     sbuf.append(hour);
     sbuf.append(':');

     int mins = calendar.get(Calendar.MINUTE);
     if(mins < 10) {
sbuf.append('0');
     }
     sbuf.append(mins);
     sbuf.append(':');

     int secs = calendar.get(Calendar.SECOND);
     if(secs < 10) {
sbuf.append('0');
     }
     sbuf.append(secs);

     sbuf.append(',');

     // store the time string for next time to avoid recomputation
     sbuf.getChars(start, sbuf.length(), lastTimeString, 0);
     lastTime = now - millis;
   }
   else {
     sbuf.append(lastTimeString);
   }


   if (millis < 100)
     sbuf.append('0');
   if (millis < 10)
     sbuf.append('0');

   sbuf.append(millis);
   return sbuf;
 }
 
Example 18
public static Date floorSeason(Date date, Integer adjust) throws Exception {
	Calendar cal = DateUtils.toCalendar(date);
	switch (cal.get(Calendar.MONTH)) {
	case Calendar.JANUARY:
		cal.set(Calendar.MONTH, Calendar.JANUARY);
		break;
	case Calendar.FEBRUARY:
		cal.set(Calendar.MONTH, Calendar.JANUARY);
		break;
	case Calendar.MARCH:
		cal.set(Calendar.MONTH, Calendar.JANUARY);
		break;
	case Calendar.APRIL:
		cal.set(Calendar.MONTH, Calendar.APRIL);
		break;
	case Calendar.MAY:
		cal.set(Calendar.MONTH, Calendar.APRIL);
		break;
	case Calendar.JUNE:
		cal.set(Calendar.MONTH, Calendar.APRIL);
		break;
	case Calendar.JULY:
		cal.set(Calendar.MONTH, Calendar.JULY);
		break;
	case Calendar.AUGUST:
		cal.set(Calendar.MONTH, Calendar.JULY);
		break;
	case Calendar.SEPTEMBER:
		cal.set(Calendar.MONTH, Calendar.JULY);
		break;
	case Calendar.OCTOBER:
		cal.set(Calendar.MONTH, Calendar.OCTOBER);
		break;
	case Calendar.NOVEMBER:
		cal.set(Calendar.MONTH, Calendar.OCTOBER);
		break;
	case Calendar.DECEMBER:
		cal.set(Calendar.MONTH, Calendar.OCTOBER);
		break;
	default:
	}
	if ((null != adjust) && (adjust != 0)) {
		cal.add(Calendar.MONTH, (adjust * 3));
	}
	cal.set(Calendar.DAY_OF_MONTH, 1);
	cal.set(Calendar.HOUR_OF_DAY, 0);
	cal.set(Calendar.MINUTE, 0);
	cal.set(Calendar.SECOND, 0);
	cal.set(Calendar.MILLISECOND, 0);
	return cal.getTime();
}
 
Example 19
/**
 * Get the title for the current position
 *
 * @param position - The position in the ViewPager
 * @return Title: MONTH YEAR -> MARCH 2013
 */
@Override
public String getTitle(final int position) {
    final Context context = mContext;
    final Calendar date = Calendar.getInstance();
    date.setTimeInMillis((mCalendarView.getFirstValidDay().getTimeInMillis()));
    date.add(Calendar.MONTH, position);

    final String month;
    switch(date.get(Calendar.MONTH)) {
        case Calendar.JANUARY:
            month = context.getString(R.string.lib_month_january);
            break;
        case Calendar.FEBRUARY:
            month = context.getString(R.string.lib_month_february);
            break;
        case Calendar.MARCH:
            month = context.getString(R.string.lib_month_march);
            break;
        case Calendar.APRIL:
            month = context.getString(R.string.lib_month_april);
            break;
        case Calendar.MAY:
            month = context.getString(R.string.lib_month_may);
            break;
        case Calendar.JUNE:
            month = context.getString(R.string.lib_month_june);
            break;
        case Calendar.JULY:
            month = context.getString(R.string.lib_month_july);
            break;
        case Calendar.AUGUST:
            month = context.getString(R.string.lib_month_august);
            break;
        case Calendar.SEPTEMBER:
            month = context.getString(R.string.lib_month_september);
            break;
        case Calendar.OCTOBER:
            month = context.getString(R.string.lib_month_october);
            break;
        case Calendar.NOVEMBER:
            month = context.getString(R.string.lib_month_november);
            break;
        default:
        case Calendar.DECEMBER:
            month = context.getString(R.string.lib_month_december);
            break;
    }

    return month + " " + date.get(Calendar.YEAR);
}
 
Example 20
/**
 * 
 * @see org.kuali.kfs.module.bc.batch.dataaccess.BudgetConstructionHumanResourcesPayrollInterfaceDao#buildBudgetConstructionPositonRequestYear(java.lang.Integer)
 */
public void buildBudgetConstructionPositonRequestYear(Integer requestFiscalYear) {
    StringBuilder sqlBuilder = new StringBuilder(2500);
    // we build constants for DB independence.  we let the library decide how they should be represented in what is passed to the DB server
    String defaultRCCd = new String("--");
    String orgSeparator = new String("-");
    Integer baseFiscalYear = requestFiscalYear-1;
    GregorianCalendar calendarJuly1 = new GregorianCalendar(baseFiscalYear, Calendar.JULY, 1);
    GregorianCalendar calendarAugust1 = new GregorianCalendar(baseFiscalYear, Calendar.AUGUST, 1);
    Date julyFirst = new Date(calendarJuly1.getTimeInMillis());
    Date augustFirst = new Date(calendarAugust1.getTimeInMillis());
    String academicPositionType = new String("AC");
    String academicTenureTrackSalaryPlan = new String("AC1");   
    
    sqlBuilder.append("INSERT INTO LD_BCN_POS_T\n");
    sqlBuilder.append("(POSITION_NBR, UNIV_FISCAL_YR, POS_EFFDT, POS_EFF_STATUS, POSN_STATUS,\n");
    sqlBuilder.append(" BUDGETED_POSN, CONFIDENTIAL_POSN, POS_STD_HRS_DFLT, POS_REG_TEMP, POS_FTE, POS_DESCR, SETID_DEPT, POS_DEPTID,\n"); 
    sqlBuilder.append(" RC_CD, POS_SAL_PLAN_DFLT, POS_GRADE_DFLT, SETID_JOBCODE, JOBCODE, SETID_SALARY,\n");
    sqlBuilder.append(" POS_LOCK_USR_ID)\n");
    sqlBuilder.append("(SELECT px.POSITION_NBR,\n");
    sqlBuilder.append("        ?, px.EFFDT, px.POS_EFF_STATUS,\n");
    sqlBuilder.append("        px.POSN_STATUS, px.BUDGETED_POSN, 'N',\n");
    sqlBuilder.append("        px.STD_HRS_DEFAULT, px.POS_REG_TEMP, px.POS_FTE, px.DESCR, px.BUSINESS_UNIT,\n");
    sqlBuilder.append("        px.DEPTID, COALESCE(org.RC_CD,?),\n");
    sqlBuilder.append("        px.POS_SAL_PLAN_DFLT, px.POS_GRADE_DFLT, px.BUSINESS_UNIT, px.JOBCODE,\n");
    sqlBuilder.append("        px.BUSINESS_UNIT, ?\n");
    sqlBuilder.append(" FROM PS_POSITION_DATA px LEFT OUTER JOIN LD_BCN_ORG_RPTS_T org\n"); 
    sqlBuilder.append("      ON (CONCAT(CONCAT(org.FIN_COA_CD,?),org.ORG_CD) = px.DEPTID)\n");
    sqlBuilder.append(" WHERE ((px.EFFDT <= ?) OR ((px.EFFDT = ?) AND (px.POS_SAL_PLAN_DFLT = ?)))\n");
    sqlBuilder.append("   AND (NOT EXISTS (SELECT 1\n");
    sqlBuilder.append("                    FROM LD_BCN_POS_T\n");
    sqlBuilder.append("                    WHERE (LD_BCN_POS_T.UNIV_FISCAL_YR = ?)\n");
    sqlBuilder.append("                      AND (px.POSITION_NBR = LD_BCN_POS_T.POSITION_NBR)))\n");
    sqlBuilder.append("   AND (NOT EXISTS (SELECT 1\n");
    sqlBuilder.append("                    FROM PS_POSITION_DATA py\n");
    sqlBuilder.append("                    WHERE (px.POSITION_NBR = py.POSITION_NBR)\n");
    sqlBuilder.append("                      AND ((py.EFFDT <= ?) OR ((py.EFFDT = ?) AND (px.POS_SAL_PLAN_DFLT = ?)))\n");
    sqlBuilder.append("                      AND (px.EFFDT < py.EFFDT)))\n");
    sqlBuilder.append("   AND (EXISTS (SELECT 1\n");
    sqlBuilder.append("                FROM LD_CSF_TRACKER_T csf\n");
    sqlBuilder.append("                WHERE (csf.UNIV_FISCAL_YR = ?)\n");
    sqlBuilder.append("                  AND (csf.POS_CSF_DELETE_CD = ?)\n");
    sqlBuilder.append("                  AND (csf.POSITION_NBR = px.POSITION_NBR))))\n");
    String sqlString = sqlBuilder.toString();
    getSimpleJdbcTemplate().update(sqlString,requestFiscalYear,defaultRCCd,BCConstants.DEFAULT_BUDGET_HEADER_LOCK_IDS,orgSeparator,julyFirst,augustFirst,academicTenureTrackSalaryPlan,requestFiscalYear,julyFirst,augustFirst,academicTenureTrackSalaryPlan,baseFiscalYear,BCConstants.ACTIVE_CSF_DELETE_CODE);
    // set the things that we'll need for testing but which we don't have enough information to set from the Kuali DB
    // this code is obviously somewhat arbitrary--it should be replaced with institution-specific algorithms
    setAcademicDefaultObjectClass(requestFiscalYear);
    setMonthlyStaffOvertimeEligibleDefaultObjectClass(requestFiscalYear);
    setMonthlyStaffOvertimeExemptDefaultObjectClass(requestFiscalYear);
    setBiweeklyStaffDefaultObjectClass(requestFiscalYear);
}