APPS.AMS_DM_MODELS_B_PKG dependencies on AMS_DM_MODELS_ALL_TL

Line 198: INSERT INTO ams_dm_models_all_tl(

194: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
195: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
196: );
197:
198: INSERT INTO ams_dm_models_all_tl(
199: model_id,
200: language,
201: last_update_date,
202: last_updated_by,

Line 225: FROM ams_dm_models_all_tl t

221: FROM fnd_languages l
222: WHERE l.installed_flag in ('I', 'B')
223: AND NOT EXISTS(
224: SELECT NULL
225: FROM ams_dm_models_all_tl t
226: WHERE t.model_id = decode( p_MODEL_ID, FND_API.G_MISS_NUM, NULL, p_MODEL_ID)
227: AND t.language = l.language_code );
228:
229: End Insert_Row;

Line 348: update ams_dm_models_all_tl set

344: -- number.
345: RAISE NO_DATA_FOUND;
346: END IF;
347:
348: update ams_dm_models_all_tl set
349: model_name = decode( p_MODEL_NAME, FND_API.G_MISS_CHAR, MODEL_NAME, p_MODEL_NAME),
350: description = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
351: last_update_date = SYSDATE,
352: last_updated_by = FND_GLOBAL.user_id,

Line 370: DELETE FROM ams_dm_models_all_tl

366: If (SQL%NOTFOUND) then
367: RAISE NO_DATA_FOUND;
368: End If;
369:
370: DELETE FROM ams_dm_models_all_tl
371: WHERE MODEL_ID = p_MODEL_ID;
372: If (SQL%NOTFOUND) then
373: RAISE NO_DATA_FOUND;
374: End If;

Line 492: delete from AMS_DM_MODELS_ALL_TL T

488:
489: PROCEDURE add_language
490: IS
491: BEGIN
492: delete from AMS_DM_MODELS_ALL_TL T
493: where not exists
494: (select NULL
495: from AMS_DM_MODELS_ALL_B B
496: where B.MODEL_ID = T.MODEL_ID

Line 499: update AMS_DM_MODELS_ALL_TL T set (

495: from AMS_DM_MODELS_ALL_B B
496: where B.MODEL_ID = T.MODEL_ID
497: );
498:
499: update AMS_DM_MODELS_ALL_TL T set (
500: MODEL_NAME,
501: DESCRIPTION
502: ) = (select
503: B.MODEL_NAME,

Line 505: from AMS_DM_MODELS_ALL_TL B

501: DESCRIPTION
502: ) = (select
503: B.MODEL_NAME,
504: B.DESCRIPTION
505: from AMS_DM_MODELS_ALL_TL B
506: where B.MODEL_ID = T.MODEL_ID
507: and B.LANGUAGE = T.SOURCE_LANG)
508: where (
509: T.MODEL_ID,

Line 514: from AMS_DM_MODELS_ALL_TL SUBB, AMS_DM_MODELS_ALL_TL SUBT

510: T.LANGUAGE
511: ) in (select
512: SUBT.MODEL_ID,
513: SUBT.LANGUAGE
514: from AMS_DM_MODELS_ALL_TL SUBB, AMS_DM_MODELS_ALL_TL SUBT
515: where SUBB.MODEL_ID = SUBT.MODEL_ID
516: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
517: and (SUBB.MODEL_NAME <> SUBT.MODEL_NAME
518: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 523: insert into AMS_DM_MODELS_ALL_TL (

519: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
520: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
521: ));
522:
523: insert into AMS_DM_MODELS_ALL_TL (
524: MODEL_ID,
525: LAST_UPDATE_DATE,
526: LAST_UPDATED_BY,
527: CREATION_DATE,

Line 545: from AMS_DM_MODELS_ALL_TL B, FND_LANGUAGES L

541: B.MODEL_NAME,
542: B.DESCRIPTION,
543: L.LANGUAGE_CODE,
544: B.SOURCE_LANG
545: from AMS_DM_MODELS_ALL_TL B, FND_LANGUAGES L
546: where L.INSTALLED_FLAG in ('I', 'B')
547: and B.LANGUAGE = userenv('LANG')
548: and not exists
549: (select NULL

Line 550: from AMS_DM_MODELS_ALL_TL T

546: where L.INSTALLED_FLAG in ('I', 'B')
547: and B.LANGUAGE = userenv('LANG')
548: and not exists
549: (select NULL
550: from AMS_DM_MODELS_ALL_TL T
551: where T.MODEL_ID = B.MODEL_ID
552: and T.LANGUAGE = L.LANGUAGE_CODE);
553: END add_language;
554:

Line 563: update ams_dm_models_all_tl set

559: x_owner IN VARCHAR2
560: )
561: IS
562: BEGIN
563: update ams_dm_models_all_tl set
564: model_name = nvl(x_model_name, model_name),
565: description = nvl(x_description, description),
566: source_lang = userenv('LANG'),
567: last_update_date = sysdate,