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_DEMAND_PLAN_PKG dependencies on MSD_DEMAND_PLANS

Line 50: from msd_demand_plans

46: f_ludate := nvl(to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
47: begin
48: select LAST_UPDATED_BY, LAST_UPDATE_DATE
49: into db_luby, db_ludate
50: from msd_demand_plans
51: where DEMAND_PLAN_NAME = p_demand_plan_name;
52:
53: -- Test for customization and version
54: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 57: update msd_demand_plans

53: -- Test for customization and version
54: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
55: db_ludate, P_CUSTOM_MODE)) then
56: -- Update existing row
57: update msd_demand_plans
58: set organization_id = p_organization_id,
59: sr_instance_id = p_sr_instance_id,
60: plan_type = p_plan_type,
61: default_template = p_default_template,

Line 87: from MSD_DEMAND_PLANS

83: begin
84: -- translate values to IDs
85: select DEMAND_PLAN_ID
86: into l_demand_plan_id
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

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 138: insert into msd_demand_plans

134:
135: select msd_demand_plan_s.nextval into l_demand_plan_id from dual;
136:
137: -- Record doesn't exist - insert in all cases
138: insert into msd_demand_plans
139: (DEMAND_PLAN_ID ,
140: TEMPLATE_ID,
141: DEMAND_PLAN_NAME ,
142: DESCRIPTION ,

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 249: demand_plan_id = (select demand_plan_id from msd_demand_plans where demand_plan_name = p_demand_plan_name)

245: LAST_UPDATED_BY = f_luby,
246: LAST_UPDATE_LOGIN = 0,
247: SOURCE_LANG = userenv('LANG')
248: where
249: demand_plan_id = (select demand_plan_id from msd_demand_plans where demand_plan_name = p_demand_plan_name)
250: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
251: END;
252:
253: Procedure ADD_LANGUAGE

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 259: from MSD_DEMAND_PLANS B

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
261: );
262:
263: update MSD_DEMAND_PLANS_TL T set (

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;