eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSD_ROLL_DEMAND_PLAN dependencies on MSD_DP_PARAMETERS

Line 52: UPDATE msd_dp_parameters

48:
49: OPEN latest_forecast_version;
50: FETCH latest_forecast_version into lv_forecast_name, lv_forecast_revision;
51:
52: UPDATE msd_dp_parameters
53: SET start_date = decode(p_period_type,G_DAY,(start_date + p_number_of_periods),G_WEEK,(start_date + p_number_of_periods*7),ADD_MONTHS(start_date,p_number_of_periods)),
54: end_date = decode(p_period_type,G_DAY,(end_date + p_number_of_periods), G_WEEK, (end_date + p_number_of_periods*7), ADD_MONTHS(end_date,p_number_of_periods)) ,
55: parameter_name = decode(lv_parameter_type,G_TYPE_INPUT_SCENARIO,(substr(parameter_name,1,instr( parameter_name,':',instr(parameter_name,':')+1))||lv_forecast_name),parameter_name),
56: revision = lv_forecast_revision

Line 155: lv_parameter_type MSD_DP_PARAMETERS.PARAMETER_TYPE%TYPE;

151:
152: lv_scenario_id MSD_DP_SCENARIOS.SCENARIO_ID%TYPE;
153: lv_scenario_name MSD_DP_SCENARIOS.SCENARIO_NAME%TYPE;
154:
155: lv_parameter_type MSD_DP_PARAMETERS.PARAMETER_TYPE%TYPE;
156: lv_exclude_flag MSD_DP_PARAMETERS.EXCLUDE_FROM_ROLLING_CYCLE%TYPE;
157: lv_parameter_id MSD_DP_PARAMETERS.PARAMETER_ID%TYPE;
158: lv_parameter_name MSD_DP_PARAMETERS.PARAMETER_NAME%TYPE;
159: lv_input_demand_plan_id MSD_DP_PARAMETERS.INPUT_DEMAND_PLAN_ID%TYPE;

Line 156: lv_exclude_flag MSD_DP_PARAMETERS.EXCLUDE_FROM_ROLLING_CYCLE%TYPE;

152: lv_scenario_id MSD_DP_SCENARIOS.SCENARIO_ID%TYPE;
153: lv_scenario_name MSD_DP_SCENARIOS.SCENARIO_NAME%TYPE;
154:
155: lv_parameter_type MSD_DP_PARAMETERS.PARAMETER_TYPE%TYPE;
156: lv_exclude_flag MSD_DP_PARAMETERS.EXCLUDE_FROM_ROLLING_CYCLE%TYPE;
157: lv_parameter_id MSD_DP_PARAMETERS.PARAMETER_ID%TYPE;
158: lv_parameter_name MSD_DP_PARAMETERS.PARAMETER_NAME%TYPE;
159: lv_input_demand_plan_id MSD_DP_PARAMETERS.INPUT_DEMAND_PLAN_ID%TYPE;
160: lv_input_scenario_id MSD_DP_PARAMETERS.INPUT_SCENARIO_ID%TYPE;

Line 157: lv_parameter_id MSD_DP_PARAMETERS.PARAMETER_ID%TYPE;

153: lv_scenario_name MSD_DP_SCENARIOS.SCENARIO_NAME%TYPE;
154:
155: lv_parameter_type MSD_DP_PARAMETERS.PARAMETER_TYPE%TYPE;
156: lv_exclude_flag MSD_DP_PARAMETERS.EXCLUDE_FROM_ROLLING_CYCLE%TYPE;
157: lv_parameter_id MSD_DP_PARAMETERS.PARAMETER_ID%TYPE;
158: lv_parameter_name MSD_DP_PARAMETERS.PARAMETER_NAME%TYPE;
159: lv_input_demand_plan_id MSD_DP_PARAMETERS.INPUT_DEMAND_PLAN_ID%TYPE;
160: lv_input_scenario_id MSD_DP_PARAMETERS.INPUT_SCENARIO_ID%TYPE;
161: lv_forecast_date_used MSD_DP_PARAMETERS.FORECAST_DATE_USED%TYPE;

Line 158: lv_parameter_name MSD_DP_PARAMETERS.PARAMETER_NAME%TYPE;

154:
155: lv_parameter_type MSD_DP_PARAMETERS.PARAMETER_TYPE%TYPE;
156: lv_exclude_flag MSD_DP_PARAMETERS.EXCLUDE_FROM_ROLLING_CYCLE%TYPE;
157: lv_parameter_id MSD_DP_PARAMETERS.PARAMETER_ID%TYPE;
158: lv_parameter_name MSD_DP_PARAMETERS.PARAMETER_NAME%TYPE;
159: lv_input_demand_plan_id MSD_DP_PARAMETERS.INPUT_DEMAND_PLAN_ID%TYPE;
160: lv_input_scenario_id MSD_DP_PARAMETERS.INPUT_SCENARIO_ID%TYPE;
161: lv_forecast_date_used MSD_DP_PARAMETERS.FORECAST_DATE_USED%TYPE;
162:

Line 159: lv_input_demand_plan_id MSD_DP_PARAMETERS.INPUT_DEMAND_PLAN_ID%TYPE;

155: lv_parameter_type MSD_DP_PARAMETERS.PARAMETER_TYPE%TYPE;
156: lv_exclude_flag MSD_DP_PARAMETERS.EXCLUDE_FROM_ROLLING_CYCLE%TYPE;
157: lv_parameter_id MSD_DP_PARAMETERS.PARAMETER_ID%TYPE;
158: lv_parameter_name MSD_DP_PARAMETERS.PARAMETER_NAME%TYPE;
159: lv_input_demand_plan_id MSD_DP_PARAMETERS.INPUT_DEMAND_PLAN_ID%TYPE;
160: lv_input_scenario_id MSD_DP_PARAMETERS.INPUT_SCENARIO_ID%TYPE;
161: lv_forecast_date_used MSD_DP_PARAMETERS.FORECAST_DATE_USED%TYPE;
162:
163: -- This cursor is used to select all the dynamic parameters.

Line 160: lv_input_scenario_id MSD_DP_PARAMETERS.INPUT_SCENARIO_ID%TYPE;

156: lv_exclude_flag MSD_DP_PARAMETERS.EXCLUDE_FROM_ROLLING_CYCLE%TYPE;
157: lv_parameter_id MSD_DP_PARAMETERS.PARAMETER_ID%TYPE;
158: lv_parameter_name MSD_DP_PARAMETERS.PARAMETER_NAME%TYPE;
159: lv_input_demand_plan_id MSD_DP_PARAMETERS.INPUT_DEMAND_PLAN_ID%TYPE;
160: lv_input_scenario_id MSD_DP_PARAMETERS.INPUT_SCENARIO_ID%TYPE;
161: lv_forecast_date_used MSD_DP_PARAMETERS.FORECAST_DATE_USED%TYPE;
162:
163: -- This cursor is used to select all the dynamic parameters.
164: CURSOR parameters IS

Line 161: lv_forecast_date_used MSD_DP_PARAMETERS.FORECAST_DATE_USED%TYPE;

157: lv_parameter_id MSD_DP_PARAMETERS.PARAMETER_ID%TYPE;
158: lv_parameter_name MSD_DP_PARAMETERS.PARAMETER_NAME%TYPE;
159: lv_input_demand_plan_id MSD_DP_PARAMETERS.INPUT_DEMAND_PLAN_ID%TYPE;
160: lv_input_scenario_id MSD_DP_PARAMETERS.INPUT_SCENARIO_ID%TYPE;
161: lv_forecast_date_used MSD_DP_PARAMETERS.FORECAST_DATE_USED%TYPE;
162:
163: -- This cursor is used to select all the dynamic parameters.
164: CURSOR parameters IS
165: SELECT parameter_id,parameter_type,parameter_name,forecast_date_used,input_demand_plan_id,input_scenario_id

Line 166: FROM msd_dp_parameters

162:
163: -- This cursor is used to select all the dynamic parameters.
164: CURSOR parameters IS
165: SELECT parameter_id,parameter_type,parameter_name,forecast_date_used,input_demand_plan_id,input_scenario_id
166: FROM msd_dp_parameters
167: WHERE demand_plan_id= p_demand_plan_id
168: AND nvl(exclude_from_rolling_cycle,'N') = 'N'
169: FOR UPDATE ;
170:

Line 174: FROM msd_dp_scenarios s, msd_dp_parameters p

170:
171: -- This cursor is used to select all the scenarios that are attached to the demand plan.
172: CURSOR scenarios IS
173: SELECT s.scenario_id,s.scenario_name,p.exclude_from_rolling_cycle
174: FROM msd_dp_scenarios s, msd_dp_parameters p
175: WHERE s.demand_plan_id = p_demand_plan_id
176: AND p.demand_plan_id = p_demand_plan_id
177: AND nvl(s.parameter_name,NULL_CHAR) = nvl(p.parameter_name,NULL_CHAR)
178: AND nvl(s.forecast_based_on,NULL_CHAR) = p.parameter_type