250: l_group_id_str VARCHAR2(50);
251: l_val VARCHAR2(1);
252: l_temp_bool BOOLEAN;
253: l_win_probability NUMBER;
254: l_win_loss_indicator as_statuses_b.win_loss_indicator%Type;
255: l_forecast_rollup_flag as_statuses_b.forecast_rollup_flag%Type;
256: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
257:
258: l_upd_access_id NUMBER;
251: l_val VARCHAR2(1);
252: l_temp_bool BOOLEAN;
253: l_win_probability NUMBER;
254: l_win_loss_indicator as_statuses_b.win_loss_indicator%Type;
255: l_forecast_rollup_flag as_statuses_b.forecast_rollup_flag%Type;
256: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
257:
258: l_upd_access_id NUMBER;
259: l_upd_team_flag VARCHAR2(1);
940: l_address_id NUMBER;
941: l_val VARCHAR2(1);
942: l_temp_bool BOOLEAN;
943: l_win_probability NUMBER;
944: l_win_loss_indicator as_statuses_b.win_loss_indicator%Type;
945: l_forecast_rollup_flag as_statuses_b.forecast_rollup_flag%Type;
946:
947: l_upd_access_id NUMBER;
948: l_upd_team_flag VARCHAR2(1);
941: l_val VARCHAR2(1);
942: l_temp_bool BOOLEAN;
943: l_win_probability NUMBER;
944: l_win_loss_indicator as_statuses_b.win_loss_indicator%Type;
945: l_forecast_rollup_flag as_statuses_b.forecast_rollup_flag%Type;
946:
947: l_upd_access_id NUMBER;
948: l_upd_team_flag VARCHAR2(1);
949: l_upd_date DATE;