APPS.MSD_DP_SCENARIO_PKG dependencies on MSD_DP_SCENARIOS_TL

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