[Home] [Help]
277: -- 11510
278: l_activity_metric_id NUMBER;
279:
280: CURSOR c_act_met_id IS
281: SELECT ozf_act_metrics_all_s.NEXTVAL
282: FROM dual;
283:
284: BEGIN
285:
5810: FROM dual;
5811:
5812: -- cursor to generate new Activity Metric ID's
5813: CURSOR c_act_metric_id IS
5814: SELECT ozf_act_metrics_all_s.NEXTVAL
5815: FROM dual;
5816:
5817: -- obtain the activity_metric_id based on a given forecast_id
5818: CURSOR c_get_activity_metric_id(p_fcast_id IN NUMBER) IS