APPS.MSD_CS_DEFN_LOAD_DATA dependencies on MSD_CS_DEFINITIONS_TL

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