6414: UPDATE pn_var_periods_all
6415: SET end_date = v_new_periods_tbl(i).end_date,
6416: partial_period = l_partial_period, --Srini
6417: last_update_date = sysdate,
6418: last_updated_by = FND_GLOBAL.USER_ID,
6419: last_update_login = FND_GLOBAL.LOGIN_ID
6420: WHERE period_id = v_new_periods_tbl(i).period_id;
6421: put_log('updated period id '|| v_new_periods_tbl(i).period_id || ' with date = ' || v_new_periods_tbl(i).end_date);
6422: END IF;
6415: SET end_date = v_new_periods_tbl(i).end_date,
6416: partial_period = l_partial_period, --Srini
6417: last_update_date = sysdate,
6418: last_updated_by = FND_GLOBAL.USER_ID,
6419: last_update_login = FND_GLOBAL.LOGIN_ID
6420: WHERE period_id = v_new_periods_tbl(i).period_id;
6421: put_log('updated period id '|| v_new_periods_tbl(i).period_id || ' with date = ' || v_new_periods_tbl(i).end_date);
6422: END IF;
6423:
6864: UPDATE pn_var_grp_dates_all
6865: SET grp_end_date = vr_grp_dates(i).l_grp_end_date ,
6866: proration_factor = round(vr_grp_dates(i).l_proration_factor,10), --Chris.T. 20MAY2004
6867: last_update_date = sysdate,
6868: last_updated_by = FND_GLOBAL.USER_ID,
6869: last_update_login = FND_GLOBAL.LOGIN_ID
6870: WHERE grp_date_id = pn_var_grp_dates_rec.grp_date_id;
6871:
6872: /*UPDATE pn_var_transactions_all
6865: SET grp_end_date = vr_grp_dates(i).l_grp_end_date ,
6866: proration_factor = round(vr_grp_dates(i).l_proration_factor,10), --Chris.T. 20MAY2004
6867: last_update_date = sysdate,
6868: last_updated_by = FND_GLOBAL.USER_ID,
6869: last_update_login = FND_GLOBAL.LOGIN_ID
6870: WHERE grp_date_id = pn_var_grp_dates_rec.grp_date_id;
6871:
6872: /*UPDATE pn_var_transactions_all
6873: SET bkpt_end_date = vr_grp_dates(i).l_grp_end_date,
6871:
6872: /*UPDATE pn_var_transactions_all
6873: SET bkpt_end_date = vr_grp_dates(i).l_grp_end_date,
6874: last_update_date = SYSDATE,
6875: last_updated_by = FND_GLOBAL.USER_ID,
6876: last_update_login = FND_GLOBAL.LOGIN_ID
6877: WHERE grp_date_id = pn_var_grp_dates_rec.grp_date_id;*/
6878:
6879: END IF; -- end if of end date not being equal
6872: /*UPDATE pn_var_transactions_all
6873: SET bkpt_end_date = vr_grp_dates(i).l_grp_end_date,
6874: last_update_date = SYSDATE,
6875: last_updated_by = FND_GLOBAL.USER_ID,
6876: last_update_login = FND_GLOBAL.LOGIN_ID
6877: WHERE grp_date_id = pn_var_grp_dates_rec.grp_date_id;*/
6878:
6879: END IF; -- end if of end date not being equal
6880: END LOOP; -- end loop for groups table.