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_DP_SCENARIO_PKG dependencies on MSD_DP_SCENARIOS

Line 61: from msd_dp_scenarios

57: f_ludate := nvl(to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
58: begin
59: select LAST_UPDATED_BY, LAST_UPDATE_DATE
60: into db_luby, db_ludate
61: from msd_dp_scenarios
62: where DEMAND_PLAN_ID = l_demand_plan_id
63: and SCENARIO_NAME = P_SCENARIO_NAME;
64:
65: -- Test for customization and version

Line 69: update msd_dp_scenarios

65: -- Test for customization and version
66: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
67: db_ludate, P_CUSTOM_MODE)) then
68: -- Update existing row
69: update msd_dp_scenarios
70: set supply_plan_flag = p_supply_plan_flag,
71: output_period_type = p_output_period_type
72: ,description = p_description
73: ,horizon_start_date = to_date(p_horizon_start_date, 'YYYY/MM/DD')

Line 103: from msd_dp_scenarios

99: begin
100:
101: select SCENARIO_ID
102: into l_scenario_id
103: from msd_dp_scenarios
104: where demand_plan_id = l_demand_Plan_id
105: and scenario_name = p_scenario_name;
106:
107: -- Update existing row

Line 108: update msd_dp_scenarios_tl

104: where demand_plan_id = l_demand_Plan_id
105: and scenario_name = p_scenario_name;
106:
107: -- Update existing row
108: update msd_dp_scenarios_tl
109: set description = p_description,
110: last_update_date = f_ludate,
111: last_updated_by = f_luby,
112: last_update_login = 0,

Line 121: insert into msd_dp_scenarios_tl

117:
118: exception
119: when no_data_found then
120: -- Record doesn't exist - insert in all cases
121: insert into msd_dp_scenarios_tl
122: (
123: demand_plan_id,
124: scenario_id,
125: description,

Line 154: select msd_dp_scenarios_s.nextval into l_scenario_id from dual;

150: end if;
151: exception
152: when no_data_found then
153:
154: select msd_dp_scenarios_s.nextval into l_scenario_id from dual;
155:
156: -- Record doesn't exist - insert in all cases
157: insert into msd_dp_scenarios
158: (DEMAND_PLAN_ID

Line 157: insert into msd_dp_scenarios

153:
154: select msd_dp_scenarios_s.nextval into l_scenario_id from dual;
155:
156: -- Record doesn't exist - insert in all cases
157: insert into msd_dp_scenarios
158: (DEMAND_PLAN_ID
159: ,SCENARIO_ID
160: ,SCENARIO_NAME
161: ,DESCRIPTION

Line 224: insert into msd_dp_scenarios_tl

220: P_SC_TYPE,
221: P_ASSOCIATE_PARAMETER
222: );
223:
224: insert into msd_dp_scenarios_tl
225: (
226: demand_plan_id,
227: scenario_id,
228: description,

Line 270: update msd_dp_scenarios_tl set

266: -- Translate owner to file_last_updated_by
267: f_luby := fnd_load_util.owner_id(P_OWNER);
268:
269:
270: update msd_dp_scenarios_tl set
271: description = p_description,
272: LAST_UPDATE_DATE = sysdate,
273: LAST_UPDATED_BY = f_luby,
274: LAST_UPDATE_LOGIN = 0,

Line 278: and scenario_id = (select scenario_id from msd_dp_scenarios where scenario_name = p_scenario_name

274: LAST_UPDATE_LOGIN = 0,
275: SOURCE_LANG = userenv('LANG')
276: where
277: demand_plan_id = (select demand_plan_id from msd_demand_plans where demand_plan_name = p_demand_plan_name)
278: and scenario_id = (select scenario_id from msd_dp_scenarios where scenario_name = p_scenario_name
279: and demand_plan_id = (select demand_plan_id from msd_demand_plans where demand_plan_name = p_demand_plan_name))
280: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
281: END;
282:

Line 286: delete from MSD_DP_SCENARIOS_TL T

282:
283: Procedure ADD_LANGUAGE
284: is
285: begin
286: delete from MSD_DP_SCENARIOS_TL T
287: where not exists
288: (select NULL
289: from MSD_DP_SCENARIOS B
290: where B.DEMAND_PLAN_ID = T.DEMAND_PLAN_ID

Line 289: from MSD_DP_SCENARIOS B

285: begin
286: delete from MSD_DP_SCENARIOS_TL T
287: where not exists
288: (select NULL
289: from MSD_DP_SCENARIOS B
290: where B.DEMAND_PLAN_ID = T.DEMAND_PLAN_ID
291: and B.SCENARIO_ID = T.SCENARIO_ID
292: );
293:

Line 294: update MSD_DP_SCENARIOS_TL T set (

290: where B.DEMAND_PLAN_ID = T.DEMAND_PLAN_ID
291: and B.SCENARIO_ID = T.SCENARIO_ID
292: );
293:
294: update MSD_DP_SCENARIOS_TL T set (
295: DESCRIPTION
296: ) = (select
297: B.DESCRIPTION
298: from MSD_DP_SCENARIOS_TL B

Line 298: from MSD_DP_SCENARIOS_TL B

294: update MSD_DP_SCENARIOS_TL T set (
295: DESCRIPTION
296: ) = (select
297: B.DESCRIPTION
298: from MSD_DP_SCENARIOS_TL B
299: where B.DEMAND_PLAN_ID = T.DEMAND_PLAN_ID
300: and B.SCENARIO_ID = T.SCENARIO_ID
301: and B.LANGUAGE = T.SOURCE_LANG)
302: where (

Line 308: from MSD_DP_SCENARIOS_TL SUBB, MSD_DP_SCENARIOS_TL SUBT

304: T.LANGUAGE
305: ) in (select
306: SUBT.DEMAND_PLAN_ID,
307: SUBT.LANGUAGE
308: from MSD_DP_SCENARIOS_TL SUBB, MSD_DP_SCENARIOS_TL SUBT
309: where SUBB.DEMAND_PLAN_ID = SUBT.DEMAND_PLAN_ID
310: and SUBB.SCENARIO_ID = SUBT.SCENARIO_ID
311: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
312: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 315: insert into MSD_DP_SCENARIOS_TL (

311: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
312: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
313: ));
314:
315: insert into MSD_DP_SCENARIOS_TL (
316: DEMAND_PLAN_ID,
317: SCENARIO_ID,
318: DESCRIPTION,
319: CREATION_DATE,

Line 345: from MSD_DP_SCENARIOS_TL B, FND_LANGUAGES L

341: B.PROGRAM_ID,
342: B.PROGRAM_UPDATE_DATE,
343: L.LANGUAGE_CODE,
344: B.SOURCE_LANG
345: from MSD_DP_SCENARIOS_TL B, FND_LANGUAGES L
346: where L.INSTALLED_FLAG in ('I', 'B')
347: and B.LANGUAGE = userenv('LANG')
348: and not exists
349: (select NULL

Line 350: from MSD_DP_SCENARIOS_TL T

346: where L.INSTALLED_FLAG in ('I', 'B')
347: and B.LANGUAGE = userenv('LANG')
348: and not exists
349: (select NULL
350: from MSD_DP_SCENARIOS_TL T
351: where T.DEMAND_PLAN_ID = B.DEMAND_PLAN_ID
352: and T.SCENARIO_ID = B.SCENARIO_ID
353: and T.LANGUAGE = L.LANGUAGE_CODE);
354: