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_CS_DEFN_LOAD_DATA dependencies on MSD_CS_DEFINITIONS

Line 156: from msd_cs_definitions

152:
153: if p_cs_definition_id is null then
154: select cs_definition_id, last_update_date, last_updated_by
155: into l_definition_id, db_ludate, db_luby
156: from msd_cs_definitions
157: where name = p_name;
158: end if;
159:
160: if ((p_custom_mode = 'FORCE') or

Line 164: update msd_cs_definitions set

160: if ((p_custom_mode = 'FORCE') or
161: ((l_user = 0) and (db_luby = 1)) or
162: ((l_user = db_luby) and (f_ludate > db_ludate))) then
163:
164: update msd_cs_definitions set
165: description = p_description,
166: cs_classification = p_cs_classification,
167: plan_type = p_plan_type ,
168: liability_user_flag= p_liability_user_flag,

Line 198: update msd_cs_definitions_TL set

194: last_update_login = fnd_global.login_id
195: where
196: cs_definition_id = l_definition_id;
197:
198: update msd_cs_definitions_TL set
199: description = p_description,
200: LAST_UPDATE_DATE = f_ludate,
201: LAST_UPDATED_BY = l_user,
202: LAST_UPDATE_LOGIN = fnd_global.login_id,

Line 210: update msd_cs_definitions set

206: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
207:
208: else
209:
210: update msd_cs_definitions set
211: cs_classification = p_cs_classification,
212: cs_type = p_cs_type,
213: plan_type = p_plan_type ,
214: liability_user_flag= p_liability_user_flag,

Line 254: from msd_cs_definitions where name = p_name;

250:
251: if (sql%notfound) then
252:
253: select cs_definition_id into l_definition_id
254: from msd_cs_definitions where name = p_name;
255:
256: insert into msd_cs_definitions_TL(
257: cs_definition_id,
258: description,

Line 256: insert into msd_cs_definitions_TL(

252:
253: select cs_definition_id into l_definition_id
254: from msd_cs_definitions where name = p_name;
255:
256: insert into msd_cs_definitions_TL(
257: cs_definition_id,
258: description,
259: language,
260: source_lang,

Line 280: from msd_cs_definitions_TL

276: fnd_global.login_id
277: from fnd_languages l
278: where l.installed_flag in ('I','B');
279: /* and not exists (select null
280: from msd_cs_definitions_TL
281: and rtl.language = l.language_code );
282: */
283: end if;
284:

Line 334: select msd_cs_definitions_s.nextval into l_definition_id from dual;

330:
331: -- Translate char last_update_date to date
332: f_ludate := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);
333:
334: select msd_cs_definitions_s.nextval into l_definition_id from dual;
335:
336: insert into msd_cs_definitions
337: (
338: cs_definition_id,

Line 336: insert into msd_cs_definitions

332: f_ludate := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);
333:
334: select msd_cs_definitions_s.nextval into l_definition_id from dual;
335:
336: insert into msd_cs_definitions
337: (
338: cs_definition_id,
339: name,
340: description,

Line 415: insert into msd_cs_definitions_TL(

411: l_user,
412: fnd_global.login_id
413: );
414:
415: insert into msd_cs_definitions_TL(
416: cs_definition_id,
417: description,
418: language,
419: source_lang,

Line 454: update msd_cs_definitions_TL set

450: else
451: l_user := 0;
452: end if;
453:
454: update msd_cs_definitions_TL set
455: description = p_description,
456: LAST_UPDATE_DATE = sysdate,
457: LAST_UPDATED_BY = l_user,
458: LAST_UPDATE_LOGIN = fnd_global.login_id,

Line 461: cs_definition_id = (select cs_definition_id from msd_cs_definitions where name = p_name)

457: LAST_UPDATED_BY = l_user,
458: LAST_UPDATE_LOGIN = fnd_global.login_id,
459: SOURCE_LANG = userenv('LANG')
460: where
461: cs_definition_id = (select cs_definition_id from msd_cs_definitions where name = p_name)
462: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
463:
464: End;
465:

Line 469: delete from MSD_CS_DEFINITIONS_TL T

465:
466: Procedure ADD_LANGUAGE
467: is
468: begin
469: delete from MSD_CS_DEFINITIONS_TL T
470: where not exists
471: (select NULL
472: from MSD_CS_DEFINITIONS B
473: where B.CS_DEFINITION_ID = T.CS_DEFINITION_ID

Line 472: from MSD_CS_DEFINITIONS B

468: begin
469: delete from MSD_CS_DEFINITIONS_TL T
470: where not exists
471: (select NULL
472: from MSD_CS_DEFINITIONS B
473: where B.CS_DEFINITION_ID = T.CS_DEFINITION_ID
474: );
475:
476: update MSD_CS_DEFINITIONS_TL T set (

Line 476: update MSD_CS_DEFINITIONS_TL T set (

472: from MSD_CS_DEFINITIONS B
473: where B.CS_DEFINITION_ID = T.CS_DEFINITION_ID
474: );
475:
476: update MSD_CS_DEFINITIONS_TL T set (
477: DESCRIPTION
478: ) = (select
479: B.DESCRIPTION
480: from MSD_CS_DEFINITIONS_TL B

Line 480: from MSD_CS_DEFINITIONS_TL B

476: update MSD_CS_DEFINITIONS_TL T set (
477: DESCRIPTION
478: ) = (select
479: B.DESCRIPTION
480: from MSD_CS_DEFINITIONS_TL B
481: where B.CS_DEFINITION_ID = T.CS_DEFINITION_ID
482: and B.LANGUAGE = T.SOURCE_LANG)
483: where (
484: T.CS_DEFINITION_ID,

Line 489: from MSD_CS_DEFINITIONS_TL SUBB, MSD_CS_DEFINITIONS_TL SUBT

485: T.LANGUAGE
486: ) in (select
487: SUBT.CS_DEFINITION_ID,
488: SUBT.LANGUAGE
489: from MSD_CS_DEFINITIONS_TL SUBB, MSD_CS_DEFINITIONS_TL SUBT
490: where SUBB.CS_DEFINITION_ID = SUBT.CS_DEFINITION_ID
491: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
492: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
493: ));

Line 495: insert into MSD_CS_DEFINITIONS_TL (

491: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
492: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
493: ));
494:
495: insert into MSD_CS_DEFINITIONS_TL (
496: CS_DEFINITION_ID,
497: DESCRIPTION,
498: CREATION_DATE,
499: CREATED_BY,

Line 523: from MSD_CS_DEFINITIONS_TL B, FND_LANGUAGES L

519: B.PROGRAM_ID,
520: B.PROGRAM_UPDATE_DATE,
521: L.LANGUAGE_CODE,
522: B.SOURCE_LANG
523: from MSD_CS_DEFINITIONS_TL B, FND_LANGUAGES L
524: where L.INSTALLED_FLAG in ('I', 'B')
525: and B.LANGUAGE = userenv('LANG')
526: and not exists
527: (select NULL

Line 528: from MSD_CS_DEFINITIONS_TL T

524: where L.INSTALLED_FLAG in ('I', 'B')
525: and B.LANGUAGE = userenv('LANG')
526: and not exists
527: (select NULL
528: from MSD_CS_DEFINITIONS_TL T
529: where T.CS_DEFINITION_ID = B.CS_DEFINITION_ID
530: and T.LANGUAGE = L.LANGUAGE_CODE);
531: End ADD_LANGUAGE;
532: