DBA Data[Home] [Help]

APPS.PN_VAR_RENT_PKG dependencies on FND_GLOBAL

Line 6414: last_updated_by = FND_GLOBAL.USER_ID,

6410: UPDATE pn_var_periods_all
6411: SET end_date = v_new_periods_tbl(i).end_date,
6412: partial_period = l_partial_period, --Srini
6413: last_update_date = sysdate,
6414: last_updated_by = FND_GLOBAL.USER_ID,
6415: last_update_login = FND_GLOBAL.LOGIN_ID
6416: WHERE period_id = v_new_periods_tbl(i).period_id;
6417: put_log('updated period id '|| v_new_periods_tbl(i).period_id || ' with date = ' || v_new_periods_tbl(i).end_date);
6418: END IF;

Line 6415: last_update_login = FND_GLOBAL.LOGIN_ID

6411: SET end_date = v_new_periods_tbl(i).end_date,
6412: partial_period = l_partial_period, --Srini
6413: last_update_date = sysdate,
6414: last_updated_by = FND_GLOBAL.USER_ID,
6415: last_update_login = FND_GLOBAL.LOGIN_ID
6416: WHERE period_id = v_new_periods_tbl(i).period_id;
6417: put_log('updated period id '|| v_new_periods_tbl(i).period_id || ' with date = ' || v_new_periods_tbl(i).end_date);
6418: END IF;
6419:

Line 6864: last_updated_by = FND_GLOBAL.USER_ID,

6860: UPDATE pn_var_grp_dates_all
6861: SET grp_end_date = vr_grp_dates(i).l_grp_end_date ,
6862: proration_factor = round(vr_grp_dates(i).l_proration_factor,10), --Chris.T. 20MAY2004
6863: last_update_date = sysdate,
6864: last_updated_by = FND_GLOBAL.USER_ID,
6865: last_update_login = FND_GLOBAL.LOGIN_ID
6866: WHERE grp_date_id = pn_var_grp_dates_rec.grp_date_id;
6867:
6868: /*UPDATE pn_var_transactions_all

Line 6865: last_update_login = FND_GLOBAL.LOGIN_ID

6861: SET grp_end_date = vr_grp_dates(i).l_grp_end_date ,
6862: proration_factor = round(vr_grp_dates(i).l_proration_factor,10), --Chris.T. 20MAY2004
6863: last_update_date = sysdate,
6864: last_updated_by = FND_GLOBAL.USER_ID,
6865: last_update_login = FND_GLOBAL.LOGIN_ID
6866: WHERE grp_date_id = pn_var_grp_dates_rec.grp_date_id;
6867:
6868: /*UPDATE pn_var_transactions_all
6869: SET bkpt_end_date = vr_grp_dates(i).l_grp_end_date,

Line 6871: last_updated_by = FND_GLOBAL.USER_ID,

6867:
6868: /*UPDATE pn_var_transactions_all
6869: SET bkpt_end_date = vr_grp_dates(i).l_grp_end_date,
6870: last_update_date = SYSDATE,
6871: last_updated_by = FND_GLOBAL.USER_ID,
6872: last_update_login = FND_GLOBAL.LOGIN_ID
6873: WHERE grp_date_id = pn_var_grp_dates_rec.grp_date_id;*/
6874:
6875: END IF; -- end if of end date not being equal

Line 6872: last_update_login = FND_GLOBAL.LOGIN_ID

6868: /*UPDATE pn_var_transactions_all
6869: SET bkpt_end_date = vr_grp_dates(i).l_grp_end_date,
6870: last_update_date = SYSDATE,
6871: last_updated_by = FND_GLOBAL.USER_ID,
6872: last_update_login = FND_GLOBAL.LOGIN_ID
6873: WHERE grp_date_id = pn_var_grp_dates_rec.grp_date_id;*/
6874:
6875: END IF; -- end if of end date not being equal
6876: END LOOP; -- end loop for groups table.