APPS.OZF_ACTFORECAST_PVT dependencies on OZF_ACT_FORECASTS_ALL

Line 220: FROM ozf_act_forecasts_all

216: l_sql_err_msg varchar2(4000);
217:
218: CURSOR c_act_forecast_count(l_forecast_id IN NUMBER) IS
219: SELECT count(*)
220: FROM ozf_act_forecasts_all
221: WHERE forecast_id = l_forecast_id;
222:
223: CURSOR c_act_forecast_id IS
224: SELECT ozf_act_forecasts_all_s.NEXTVAL

Line 224: SELECT ozf_act_forecasts_all_s.NEXTVAL

220: FROM ozf_act_forecasts_all
221: WHERE forecast_id = l_forecast_id;
222:
223: CURSOR c_act_forecast_id IS
224: SELECT ozf_act_forecasts_all_s.NEXTVAL
225: FROM dual;
226:
227: BEGIN
228: --

Line 343: INSERT INTO ozf_act_forecasts_all

339: --
340: -- Insert into the base table.
341: --
342:
343: INSERT INTO ozf_act_forecasts_all
344: (forecast_id
345: ,forecast_type
346: ,arc_act_fcast_used_by
347: ,act_fcast_used_by_id

Line 560: -- Updates an entry in the OZF_ACT_FORECASTS_ALL table

556: -- NAME
557: -- Update_ActForecast
558: --
559: -- PURPOSE
560: -- Updates an entry in the OZF_ACT_FORECASTS_ALL table
561: --
562: -- NOTES
563: --
564: -- HISTORY

Line 723: UPDATE ozf_act_forecasts_all SET

719:
720: END IF;
721:
722:
723: UPDATE ozf_act_forecasts_all SET
724: object_version_number = object_version_number +1,
725: forecast_type = l_act_forecast_rec.forecast_type,
726: arc_act_fcast_used_by = l_act_forecast_rec.arc_act_fcast_used_by,
727: act_fcast_used_by_id = l_act_forecast_rec.act_fcast_used_by_id,

Line 851: -- Deletes an entry in the ozf_act_forecasts_all table.

847: -- NAME
848: -- Delete_ActForecast
849: --
850: -- PURPOSE
851: -- Deletes an entry in the ozf_act_forecasts_all table.
852: --
853: -- NOTES
854: --
855: -- HISTORY

Line 950: DELETE from ozf_act_forecasts_all

946: DELETE from ozf_act_metrics_all
947: WHERE act_metric_used_by_id = p_forecast_id
948: AND arc_act_metric_used_by = 'FCST';
949:
950: DELETE from ozf_act_forecasts_all
951: WHERE forecast_id = p_forecast_id;
952:
953: IF (SQL%NOTFOUND) THEN
954: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 1025: -- Lock the given row in OZF_ACT_FORECASTS_ALL table.

1021: -- NAME
1022: -- Lock_ActForecast
1023: --
1024: -- PURPOSE
1025: -- Lock the given row in OZF_ACT_FORECASTS_ALL table.
1026: --
1027: -- NOTES
1028: --
1029: -- HISTORY

Line 1054: FROM ozf_act_forecasts_all

1050: l_forecast_id NUMBER;
1051:
1052: CURSOR c_act_forecast_info IS
1053: SELECT forecast_id
1054: FROM ozf_act_forecasts_all
1055: WHERE forecast_id = p_forecast_id
1056: AND object_version_number = p_object_version_number
1057: FOR UPDATE OF forecast_id NOWAIT;
1058:

Line 1378: FROM ozf_act_forecasts_all

1374: )
1375: IS
1376: CURSOR c_act_forecast IS
1377: SELECT *
1378: FROM ozf_act_forecasts_all
1379: WHERE forecast_id = p_act_forecast_rec.forecast_id;
1380:
1381: l_act_forecast_rec c_act_forecast%ROWTYPE;
1382: BEGIN

Line 1823: p_table_name => 'ozf_act_forecasts_all',

1819: l_where_clause := l_where_clause ||
1820: ' last_scenario_id = '||p_act_forecast_rec.last_scenario_id ;
1821:
1822: IF OZF_Utility_PVT.Check_Uniqueness(
1823: p_table_name => 'ozf_act_forecasts_all',
1824: p_where_clause => l_where_clause
1825: ) = FND_API.g_false
1826: THEN
1827: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)