We walk in the dark places no others will enter
We stand on the bridge and no one may pass

DECLARE CURSOR_UPDATE_LIVE CURSOR
FOR
  SELECT ACTUAL_LINE_ID, TEMP_LINE_ID, ATTRIBUTE1, ATTRIBUTE2,
      CONVERT(VARCHAR(11), LTRIM(RTRIM(ATTRIBUTE3)), 106),
      CONVERT(VARCHAR(11), LTRIM(RTRIM(ATTRIBUTE4)), 106), ATTRIBUTE5,
      ATTRIBUTE6, ATTRIBUTE7
    FROM TEMP_table
    WHERE ACTION_FLAG = 'U'
      AND SESSION_ID = @PBI_SESSION_ID
      AND TRN = @PBI_TRN

OPEN CURSOR_UPDATE_LIVE
FETCH NEXT FROM CURSOR_UPDATE_LIVE INTO @li_actual_line_id, @li_temp_line_id,
  @li_calendar_header_id, @lvc_period_name, @ld_from_date_1, @ld_to_date_1,
  @li_quarter_num, @lvc_f_year, @li_adjusting_period

WHILE @@FETCH_STATUS = 0 
  BEGIN
    UPDATE GL_CALENDAR_LINES
      SET CAL_HEADER_ID = @PVC_CALENDAR_HEADER_ID,
          PERIOD_NAME = @lvc_period_name, FROM_DATE = @ld_from_date_1,
          TO_DATE = @ld_to_date_1, QUARTER_NUM = @li_quarter_num,
          F_YEAR = @lvc_f_year, ADJUSTING_PERIOD = @li_adjusting_period,
          TRN = @PBI_TRN, STATUS = 1, SESSION_ID = @PBI_SESSION_ID
      WHERE CAL_LINE_ID = @li_actual_line_id
    FETCH NEXT FROM CURSOR_UPDATE_LIVE INTO @li_actual_line_id,
      @li_temp_line_id, @li_calendar_header_id, @lvc_period_name,
      @ld_from_date_1, @ld_to_date_1, @li_quarter_num, @lvc_f_year,
      @li_adjusting_period
  END

CLOSE CURSOR_UPDATE_LIVE
DEALLOCATE CURSOR_UPDATE_LIVE

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

UPDATE l SET
		CAL_HEADER_ID	= @PVC_CALENDAR_HEADER_ID,
		PERIOD_NAME		= t.ATTRIBUTE2, --@lvc_period_name,
		FROM_DATE		= CONVERT(VARCHAR(11),LTRIM(RTRIM(t.ATTRIBUTE3)), 106), --@ld_from_date_1,
		TO_DATE			= CONVERT(VARCHAR(11),LTRIM(RTRIM(t.ATTRIBUTE4)), 106), --@ld_to_date_1,
		QUARTER_NUM		= t.ATTRIBUTE5, --@li_quarter_num,
		F_YEAR			= t.ATTRIBUTE6, --@lvc_f_year,
		ADJUSTING_PERIOD = t.ATTRIBUTE7, --@li_adjusting_period,
		TRN				= @PBI_TRN,
		STATUS			= 1,
		SESSION_ID		= @PBI_SESSION_ID
FROM GL_CALENDAR_LINES l
INNER JOIN TEMP_table t 
	ON t.ACTUAL_LINE_ID = l.CAL_LINE_ID
WHERE t.ACTION_FLAG = 'U' 
	AND t.SESSION_ID = @PBI_SESSION_ID 
	AND t.TRN=@PBI_TRN