APPS.AMS_DM_SCORES_B_PKG dependencies on AMS_DM_SCORES_ALL_TL

Line 170: INSERT INTO ams_dm_scores_all_tl(

166: decode( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
167: decode( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
168: decode( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
169:
170: INSERT INTO ams_dm_scores_all_tl(
171: score_id,
172: language,
173: last_update_date,
174: last_updated_by,

Line 197: FROM ams_dm_scores_all_tl t

193: FROM fnd_languages l
194: WHERE l.installed_flag in ('I', 'B')
195: AND NOT EXISTS(
196: SELECT NULL
197: FROM ams_dm_scores_all_tl t
198: WHERE t.score_id = decode( p_score_ID, FND_API.G_MISS_NUM, NULL, p_score_ID)
199: AND t.language = l.language_code );
200:
201: End Insert_Row;

Line 304: update ams_dm_scores_all_tl set

300: -- number.
301: RAISE NO_DATA_FOUND;
302: END IF;
303:
304: update ams_dm_scores_all_tl set
305: score_name = decode( p_score_NAME, FND_API.G_MISS_CHAR, score_NAME, p_score_NAME),
306: description = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
307: last_update_date = SYSDATE,
308: last_updated_by = FND_GLOBAL.user_id,

Line 326: DELETE FROM ams_dm_scores_all_tl

322: If (SQL%NOTFOUND) then
323: RAISE NO_DATA_FOUND;
324: End If;
325:
326: DELETE FROM ams_dm_scores_all_tl
327: WHERE score_ID = p_score_ID;
328: If (SQL%NOTFOUND) then
329: RAISE NO_DATA_FOUND;
330: End If;

Line 496: delete from AMS_DM_SCORES_ALL_TL T

492:
493: procedure ADD_LANGUAGE
494: is
495: begin
496: delete from AMS_DM_SCORES_ALL_TL T
497: where not exists
498: (select NULL
499: from AMS_DM_SCORES_ALL_B B
500: where B.SCORE_ID = T.SCORE_ID

Line 503: update AMS_DM_SCORES_ALL_TL T set (

499: from AMS_DM_SCORES_ALL_B B
500: where B.SCORE_ID = T.SCORE_ID
501: );
502:
503: update AMS_DM_SCORES_ALL_TL T set (
504: SCORE_NAME,
505: DESCRIPTION
506: ) = (select
507: B.SCORE_NAME,

Line 509: from AMS_DM_SCORES_ALL_TL B

505: DESCRIPTION
506: ) = (select
507: B.SCORE_NAME,
508: B.DESCRIPTION
509: from AMS_DM_SCORES_ALL_TL B
510: where B.SCORE_ID = T.SCORE_ID
511: and B.LANGUAGE = T.SOURCE_LANG)
512: where (
513: T.SCORE_ID,

Line 518: from AMS_DM_SCORES_ALL_TL SUBB, AMS_DM_SCORES_ALL_TL SUBT

514: T.LANGUAGE
515: ) in (select
516: SUBT.SCORE_ID,
517: SUBT.LANGUAGE
518: from AMS_DM_SCORES_ALL_TL SUBB, AMS_DM_SCORES_ALL_TL SUBT
519: where SUBB.SCORE_ID = SUBT.SCORE_ID
520: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
521: and (SUBB.SCORE_NAME <> SUBT.SCORE_NAME
522: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 527: insert into AMS_DM_SCORES_ALL_TL (

523: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
524: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
525: ));
526:
527: insert into AMS_DM_SCORES_ALL_TL (
528: SCORE_ID,
529: LAST_UPDATE_DATE,
530: LAST_UPDATED_BY,
531: CREATION_DATE,

Line 549: from AMS_DM_SCORES_ALL_TL B, FND_LANGUAGES L

545: B.SCORE_NAME,
546: B.DESCRIPTION,
547: L.LANGUAGE_CODE,
548: B.SOURCE_LANG
549: from AMS_DM_SCORES_ALL_TL B, FND_LANGUAGES L
550: where L.INSTALLED_FLAG in ('I', 'B')
551: and B.LANGUAGE = userenv('LANG')
552: and not exists
553: (select NULL

Line 554: from AMS_DM_SCORES_ALL_TL T

550: where L.INSTALLED_FLAG in ('I', 'B')
551: and B.LANGUAGE = userenv('LANG')
552: and not exists
553: (select NULL
554: from AMS_DM_SCORES_ALL_TL T
555: where T.SCORE_ID = B.SCORE_ID
556: and T.LANGUAGE = L.LANGUAGE_CODE);
557: end ADD_LANGUAGE;
558:

Line 568: update ams_dm_scores_all_tl set

564: x_owner IN VARCHAR2
565: )
566: IS
567: BEGIN
568: update ams_dm_scores_all_tl set
569: score_name = nvl(x_score_name, score_name),
570: description = nvl(x_description, description),
571: source_lang = userenv('LANG'),
572: last_update_date = sysdate,