APPS.OZF_FORECAST_UTIL_PVT dependencies on OZF_ACT_METRICS_ALL

Line 281: SELECT ozf_act_metrics_all_s.NEXTVAL

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:

Line 362: INSERT INTO ozf_act_metrics_all (

358: FETCH c_act_met_id INTO l_activity_metric_id;
359: CLOSE c_act_met_id;
360: ----dbms_output.put_line( '-- 1.3 --' || l_activity_metric_id );
361:
362: INSERT INTO ozf_act_metrics_all (
363: ACTIVITY_METRIC_ID , LAST_UPDATE_DATE,
364: LAST_UPDATED_BY , CREATION_DATE,
365: CREATED_BY , LAST_UPDATE_LOGIN,
366: OBJECT_VERSION_NUMBER , ACT_METRIC_USED_BY_ID,

Line 4668: FROM ozf_act_metrics_all

4664: -- AND offer_type = 'OFFR' ;
4665:
4666: CURSOR c_get_activity_metric_id(p_fcast_id IN NUMBER) IS
4667: SELECT activity_metric_id
4668: FROM ozf_act_metrics_all
4669: WHERE arc_act_metric_used_by = 'FCST'
4670: AND act_metric_used_by_id = p_fcast_id;
4671:
4672: BEGIN

Line 5814: SELECT ozf_act_metrics_all_s.NEXTVAL

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

Line 5820: FROM ozf_act_metrics_all

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
5819: SELECT activity_metric_id
5820: FROM ozf_act_metrics_all
5821: WHERE arc_act_metric_used_by = 'FCST'
5822: AND act_metric_used_by_id = p_fcast_id;
5823:
5824:

Line 6027: -- Insert a new activity metric record in the ozf_act_metrics_all table taking the given forecastId as input

6023: FROM ozf_act_forecasts_all a
6024: WHERE forecast_id = p_forecast_id;
6025:
6026:
6027: -- Insert a new activity metric record in the ozf_act_metrics_all table taking the given forecastId as input
6028:
6029: OPEN c_act_metric_id;
6030: FETCH c_act_metric_id INTO l_activity_metric_id;
6031: CLOSE c_act_metric_id;

Line 6033: INSERT INTO ozf_act_metrics_all (

6029: OPEN c_act_metric_id;
6030: FETCH c_act_metric_id INTO l_activity_metric_id;
6031: CLOSE c_act_metric_id;
6032:
6033: INSERT INTO ozf_act_metrics_all (
6034: activity_metric_id,
6035: creation_date,
6036: created_by,
6037: last_update_date,

Line 6172: FROM ozf_act_metrics_all b

6168: b.attribute15,
6169: b.description,
6170: b.act_metric_date,
6171: b.depend_act_metric
6172: FROM ozf_act_metrics_all b
6173: WHERE act_metric_used_by_id = p_forecast_id
6174: AND arc_act_metric_used_by = 'FCST';
6175:
6176: -- Insert new row in the ozf_act_metric_facts_all table for