APPS.MSD_DEMAND_PLAN_PKG dependencies on MSD_DEMAND_PLANS_TL

Line 91: update msd_demand_plans_tl

87: from MSD_DEMAND_PLANS
88: where DEMAND_PLAN_NAME = P_DEMAND_PLAN_NAME;
89:
90: -- Update existing row
91: update msd_demand_plans_tl
92: set description = p_description,
93: last_update_date = f_ludate,
94: last_updated_by = f_luby,
95: last_update_login = 0,

Line 104: insert into msd_demand_plans_tl

100: exception
101: when no_data_found then
102:
103: -- Record doesn't exist - insert in all cases
104: insert into msd_demand_plans_tl
105: (
106: demand_plan_id,
107: description,
108: language,

Line 199: insert into msd_demand_plans_tl

195: f_luby ,
196: 0
197: );
198:
199: insert into msd_demand_plans_tl
200: (
201: demand_plan_id,
202: description,
203: language,

Line 242: update msd_demand_plans_tl set

238: -- Translate owner to file_last_updated_by
239: f_luby := fnd_load_util.owner_id(P_OWNER);
240:
241:
242: update msd_demand_plans_tl set
243: description = p_description,
244: LAST_UPDATE_DATE = sysdate,
245: LAST_UPDATED_BY = f_luby,
246: LAST_UPDATE_LOGIN = 0,

Line 256: delete from MSD_DEMAND_PLANS_TL T

252:
253: Procedure ADD_LANGUAGE
254: is
255: begin
256: delete from MSD_DEMAND_PLANS_TL T
257: where not exists
258: (select NULL
259: from MSD_DEMAND_PLANS B
260: where B.DEMAND_PLAN_ID = T.DEMAND_PLAN_ID

Line 263: update MSD_DEMAND_PLANS_TL T set (

259: from MSD_DEMAND_PLANS B
260: where B.DEMAND_PLAN_ID = T.DEMAND_PLAN_ID
261: );
262:
263: update MSD_DEMAND_PLANS_TL T set (
264: DESCRIPTION
265: ) = (select
266: B.DESCRIPTION
267: from MSD_DEMAND_PLANS_TL B

Line 267: from MSD_DEMAND_PLANS_TL B

263: update MSD_DEMAND_PLANS_TL T set (
264: DESCRIPTION
265: ) = (select
266: B.DESCRIPTION
267: from MSD_DEMAND_PLANS_TL B
268: where B.DEMAND_PLAN_ID = T.DEMAND_PLAN_ID
269: and B.LANGUAGE = T.SOURCE_LANG)
270: where (
271: T.DEMAND_PLAN_ID,

Line 276: from MSD_DEMAND_PLANS_TL SUBB, MSD_DEMAND_PLANS_TL SUBT

272: T.LANGUAGE
273: ) in (select
274: SUBT.DEMAND_PLAN_ID,
275: SUBT.LANGUAGE
276: from MSD_DEMAND_PLANS_TL SUBB, MSD_DEMAND_PLANS_TL SUBT
277: where SUBB.DEMAND_PLAN_ID = SUBT.DEMAND_PLAN_ID
278: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
279: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
280: ));

Line 282: insert into MSD_DEMAND_PLANS_TL (

278: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
279: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
280: ));
281:
282: insert into MSD_DEMAND_PLANS_TL (
283: DEMAND_PLAN_ID,
284: DESCRIPTION,
285: CREATION_DATE,
286: CREATED_BY,

Line 310: from MSD_DEMAND_PLANS_TL B, FND_LANGUAGES L

306: B.PROGRAM_ID,
307: B.PROGRAM_UPDATE_DATE,
308: L.LANGUAGE_CODE,
309: B.SOURCE_LANG
310: from MSD_DEMAND_PLANS_TL B, FND_LANGUAGES L
311: where L.INSTALLED_FLAG in ('I', 'B')
312: and B.LANGUAGE = userenv('LANG')
313: and not exists
314: (select NULL

Line 315: from MSD_DEMAND_PLANS_TL T

311: where L.INSTALLED_FLAG in ('I', 'B')
312: and B.LANGUAGE = userenv('LANG')
313: and not exists
314: (select NULL
315: from MSD_DEMAND_PLANS_TL T
316: where T.DEMAND_PLAN_ID = B.DEMAND_PLAN_ID
317: and T.LANGUAGE = L.LANGUAGE_CODE);
318:
319: End ADD_LANGUAGE;