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 51: UPDATE msd_dp_parameters

47:
48: OPEN latest_forecast_version;
49: FETCH latest_forecast_version into lv_forecast_name;
50:
51: UPDATE msd_dp_parameters
52: SET start_date = decode(p_period_type,G_DAY,(start_date + p_number_of_periods),ADD_MONTHS(start_date,p_number_of_periods)),
53: end_date = decode(p_period_type,G_DAY,(end_date + p_number_of_periods),ADD_MONTHS(end_date,p_number_of_periods)) ,
54: 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)
55: WHERE parameter_id = lv_parameter_id;

Line 149: lv_parameter_type MSD_DP_PARAMETERS.PARAMETER_TYPE%TYPE;

145:
146: lv_scenario_id MSD_DP_SCENARIOS.SCENARIO_ID%TYPE;
147: lv_scenario_name MSD_DP_SCENARIOS.SCENARIO_NAME%TYPE;
148:
149: lv_parameter_type MSD_DP_PARAMETERS.PARAMETER_TYPE%TYPE;
150: lv_exclude_flag MSD_DP_PARAMETERS.EXCLUDE_FROM_ROLLING_CYCLE%TYPE;
151: lv_parameter_id MSD_DP_PARAMETERS.PARAMETER_ID%TYPE;
152: lv_parameter_name MSD_DP_PARAMETERS.PARAMETER_NAME%TYPE;
153: lv_input_demand_plan_id MSD_DP_PARAMETERS.INPUT_DEMAND_PLAN_ID%TYPE;

Line 150: lv_exclude_flag MSD_DP_PARAMETERS.EXCLUDE_FROM_ROLLING_CYCLE%TYPE;

146: lv_scenario_id MSD_DP_SCENARIOS.SCENARIO_ID%TYPE;
147: lv_scenario_name MSD_DP_SCENARIOS.SCENARIO_NAME%TYPE;
148:
149: lv_parameter_type MSD_DP_PARAMETERS.PARAMETER_TYPE%TYPE;
150: lv_exclude_flag MSD_DP_PARAMETERS.EXCLUDE_FROM_ROLLING_CYCLE%TYPE;
151: lv_parameter_id MSD_DP_PARAMETERS.PARAMETER_ID%TYPE;
152: lv_parameter_name MSD_DP_PARAMETERS.PARAMETER_NAME%TYPE;
153: lv_input_demand_plan_id MSD_DP_PARAMETERS.INPUT_DEMAND_PLAN_ID%TYPE;
154: lv_input_scenario_id MSD_DP_PARAMETERS.INPUT_SCENARIO_ID%TYPE;

Line 151: lv_parameter_id MSD_DP_PARAMETERS.PARAMETER_ID%TYPE;

147: lv_scenario_name MSD_DP_SCENARIOS.SCENARIO_NAME%TYPE;
148:
149: lv_parameter_type MSD_DP_PARAMETERS.PARAMETER_TYPE%TYPE;
150: lv_exclude_flag MSD_DP_PARAMETERS.EXCLUDE_FROM_ROLLING_CYCLE%TYPE;
151: lv_parameter_id MSD_DP_PARAMETERS.PARAMETER_ID%TYPE;
152: lv_parameter_name MSD_DP_PARAMETERS.PARAMETER_NAME%TYPE;
153: lv_input_demand_plan_id MSD_DP_PARAMETERS.INPUT_DEMAND_PLAN_ID%TYPE;
154: lv_input_scenario_id MSD_DP_PARAMETERS.INPUT_SCENARIO_ID%TYPE;
155: lv_forecast_date_used MSD_DP_PARAMETERS.FORECAST_DATE_USED%TYPE;

Line 152: lv_parameter_name MSD_DP_PARAMETERS.PARAMETER_NAME%TYPE;

148:
149: lv_parameter_type MSD_DP_PARAMETERS.PARAMETER_TYPE%TYPE;
150: lv_exclude_flag MSD_DP_PARAMETERS.EXCLUDE_FROM_ROLLING_CYCLE%TYPE;
151: lv_parameter_id MSD_DP_PARAMETERS.PARAMETER_ID%TYPE;
152: lv_parameter_name MSD_DP_PARAMETERS.PARAMETER_NAME%TYPE;
153: lv_input_demand_plan_id MSD_DP_PARAMETERS.INPUT_DEMAND_PLAN_ID%TYPE;
154: lv_input_scenario_id MSD_DP_PARAMETERS.INPUT_SCENARIO_ID%TYPE;
155: lv_forecast_date_used MSD_DP_PARAMETERS.FORECAST_DATE_USED%TYPE;
156:

Line 153: lv_input_demand_plan_id MSD_DP_PARAMETERS.INPUT_DEMAND_PLAN_ID%TYPE;

149: lv_parameter_type MSD_DP_PARAMETERS.PARAMETER_TYPE%TYPE;
150: lv_exclude_flag MSD_DP_PARAMETERS.EXCLUDE_FROM_ROLLING_CYCLE%TYPE;
151: lv_parameter_id MSD_DP_PARAMETERS.PARAMETER_ID%TYPE;
152: lv_parameter_name MSD_DP_PARAMETERS.PARAMETER_NAME%TYPE;
153: lv_input_demand_plan_id MSD_DP_PARAMETERS.INPUT_DEMAND_PLAN_ID%TYPE;
154: lv_input_scenario_id MSD_DP_PARAMETERS.INPUT_SCENARIO_ID%TYPE;
155: lv_forecast_date_used MSD_DP_PARAMETERS.FORECAST_DATE_USED%TYPE;
156:
157: -- This cursor is used to select all the dynamic parameters.

Line 154: lv_input_scenario_id MSD_DP_PARAMETERS.INPUT_SCENARIO_ID%TYPE;

150: lv_exclude_flag MSD_DP_PARAMETERS.EXCLUDE_FROM_ROLLING_CYCLE%TYPE;
151: lv_parameter_id MSD_DP_PARAMETERS.PARAMETER_ID%TYPE;
152: lv_parameter_name MSD_DP_PARAMETERS.PARAMETER_NAME%TYPE;
153: lv_input_demand_plan_id MSD_DP_PARAMETERS.INPUT_DEMAND_PLAN_ID%TYPE;
154: lv_input_scenario_id MSD_DP_PARAMETERS.INPUT_SCENARIO_ID%TYPE;
155: lv_forecast_date_used MSD_DP_PARAMETERS.FORECAST_DATE_USED%TYPE;
156:
157: -- This cursor is used to select all the dynamic parameters.
158: CURSOR parameters IS

Line 155: lv_forecast_date_used MSD_DP_PARAMETERS.FORECAST_DATE_USED%TYPE;

151: lv_parameter_id MSD_DP_PARAMETERS.PARAMETER_ID%TYPE;
152: lv_parameter_name MSD_DP_PARAMETERS.PARAMETER_NAME%TYPE;
153: lv_input_demand_plan_id MSD_DP_PARAMETERS.INPUT_DEMAND_PLAN_ID%TYPE;
154: lv_input_scenario_id MSD_DP_PARAMETERS.INPUT_SCENARIO_ID%TYPE;
155: lv_forecast_date_used MSD_DP_PARAMETERS.FORECAST_DATE_USED%TYPE;
156:
157: -- This cursor is used to select all the dynamic parameters.
158: CURSOR parameters IS
159: SELECT parameter_id,parameter_type,parameter_name,forecast_date_used,input_demand_plan_id,input_scenario_id

Line 160: FROM msd_dp_parameters

156:
157: -- This cursor is used to select all the dynamic parameters.
158: CURSOR parameters IS
159: SELECT parameter_id,parameter_type,parameter_name,forecast_date_used,input_demand_plan_id,input_scenario_id
160: FROM msd_dp_parameters
161: WHERE demand_plan_id= p_demand_plan_id
162: AND nvl(exclude_from_rolling_cycle,'N') = 'N'
163: FOR UPDATE ;
164:

Line 168: FROM msd_dp_scenarios s, msd_dp_parameters p

164:
165: -- This cursor is used to select all the scenarios that are attached to the demand plan.
166: CURSOR scenarios IS
167: SELECT s.scenario_id,s.scenario_name,p.exclude_from_rolling_cycle
168: FROM msd_dp_scenarios s, msd_dp_parameters p
169: WHERE s.demand_plan_id = p_demand_plan_id
170: AND p.demand_plan_id = p_demand_plan_id
171: AND nvl(s.parameter_name,NULL_CHAR) = nvl(p.parameter_name,NULL_CHAR)
172: AND nvl(s.forecast_based_on,NULL_CHAR) = p.parameter_type