APPS.OZF_FORECAST_UTIL_PVT dependencies on DUAL

Line 282: FROM dual;

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:
286: --

Line 5810: FROM dual;

5806:
5807: -- cursor to generate new Forecast ID's
5808: CURSOR c_act_forecast_id IS
5809: SELECT ozf_act_forecasts_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

Line 5815: 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
5819: SELECT activity_metric_id

Line 6191: SELECT ozf_act_metric_facts_all_s.nextval INTO l_act_metric_fact_id_level_1 FROM dual;

6187: )
6188: LOOP
6189: -- generating activity_metric_fact_id for each record in Level One with the sequence
6190: --l_act_metric_fact_id_level_1 := ozf_act_metric_facts_all_s.nextval;
6191: SELECT ozf_act_metric_facts_all_s.nextval INTO l_act_metric_fact_id_level_1 FROM dual;
6192:
6193: INSERT INTO ozf_act_metric_facts_all (
6194: ACTIVITY_METRIC_FACT_ID ,
6195: LAST_UPDATE_DATE ,

Line 6266: SELECT ozf_act_metric_facts_all_s.nextval INTO l_act_metric_fact_id_level_2 FROM dual;

6262: LOOP
6263:
6264: -- generating activity_metric_fact_id for each record in Level Two with the sequence
6265: --l_act_metric_fact_id_level_2 := ozf_act_metric_facts_all_s.nextval;
6266: SELECT ozf_act_metric_facts_all_s.nextval INTO l_act_metric_fact_id_level_2 FROM dual;
6267:
6268: INSERT INTO ozf_act_metric_facts_all (
6269: ACTIVITY_METRIC_FACT_ID ,
6270: LAST_UPDATE_DATE ,

Line 6343: SELECT ozf_act_metric_facts_all_s.nextval INTO l_act_metric_fact_id_level_3 FROM dual;

6339: LOOP
6340:
6341: -- generating activity_metric_fact_id for each new record in Level Three with the sequence
6342: --l_act_metric_fact_id_level_3 := ozf_act_metric_facts_all_s.nextval;
6343: SELECT ozf_act_metric_facts_all_s.nextval INTO l_act_metric_fact_id_level_3 FROM dual;
6344:
6345: INSERT INTO ozf_act_metric_facts_all (
6346: ACTIVITY_METRIC_FACT_ID ,
6347: LAST_UPDATE_DATE ,

Line 9761: from dual;

9757: null,
9758: l_fcst_qty,
9759: l_fcst_uom,
9760: l_voloffr_uom, null, null) converted_qty
9761: from dual;
9762:
9763: l_api_version CONSTANT NUMBER := 1.0;
9764: l_api_name CONSTANT VARCHAR2(30) := 'get_volume_offer_discount';
9765: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;