[Home] [Help]
13: X_LAST_UPDATE_LOGIN IN NUMBER
14: ) IS
15: L_TAB NUMBER := -1;
16: BEGIN
17: SELECT COUNT(*) INTO L_TAB FROM BSC_TAB_VIEW_LABELS_TL WHERE TAB_ID = X_TAB_ID
18: AND TAB_VIEW_ID = X_TAB_VIEW_ID
19: AND LABEL_ID = X_LABEL_ID;
20: IF (L_TAB > 0) THEN
21: UPDATE BSC_TAB_VIEW_LABELS_TL SET
17: SELECT COUNT(*) INTO L_TAB FROM BSC_TAB_VIEW_LABELS_TL WHERE TAB_ID = X_TAB_ID
18: AND TAB_VIEW_ID = X_TAB_VIEW_ID
19: AND LABEL_ID = X_LABEL_ID;
20: IF (L_TAB > 0) THEN
21: UPDATE BSC_TAB_VIEW_LABELS_TL SET
22: NAME = NVL(X_NAME, NAME),
23: NOTE = NVL(X_NOTE, NOTE),
24: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE, SYSDATE),
25: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
95: X_LAST_UPDATED_BY ,
96: X_LAST_UPDATE_LOGIN
97: );
98:
99: insert into BSC_TAB_VIEW_LABELS_TL (
100: TAB_ID,
101: TAB_VIEW_ID,
102: LABEL_ID,
103: NAME,
143: from FND_LANGUAGES L
144: where L.INSTALLED_FLAG in ('I', 'B')
145: and not exists
146: (select NULL
147: from BSC_TAB_VIEW_LABELS_TL T
148: where T.TAB_ID = X_TAB_ID
149: and T.TAB_VIEW_ID = X_TAB_VIEW_ID
150: and T.LABEL_ID = X_LABEL_ID
151: and T.LANGUAGE = L.LANGUAGE_CODE);
200: FONT_STYLE,
201: FONT_COLOR,
202: URL,
203: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
204: from BSC_TAB_VIEW_LABELS_TL
205: where TAB_ID = X_TAB_ID
206: and TAB_VIEW_ID = X_TAB_VIEW_ID
207: and LABEL_ID = X_LABEL_ID
208: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
289: if (sql%notfound) then
290: raise no_data_found;
291: end if;
292:
293: update BSC_TAB_VIEW_LABELS_TL set
294: NAME = X_NAME,
295: NOTE = X_NOTE,
296: TEXT_FLAG = X_TEXT_FLAG,
297: LEFT_POSITION = X_LEFT_POSITION,
321: X_TAB_VIEW_ID in NUMBER,
322: X_LABEL_ID in NUMBER
323: ) is
324: begin
325: delete from BSC_TAB_VIEW_LABELS_TL
326: where TAB_ID = X_TAB_ID
327: and LABEL_ID = X_LABEL_ID
328: and TAB_VIEW_ID = X_TAB_VIEW_ID;
329:
347: SELECT VS.USER#
348: INTO l_user
349: FROM V$SESSION VS WHERE VS.AUDSID =USERENV('SESSIONID');
350:
351: delete from BSC_TAB_VIEW_LABELS_TL T
352: where not exists
353: (select NULL
354: from BSC_TAB_VIEW_LABELS_B B
355: where B.TAB_ID = T.TAB_ID
356: and B.LABEL_ID = T.LABEL_ID
357: and B.TAB_VIEW_ID = T.TAB_VIEW_ID
358: );
359:
360: update BSC_TAB_VIEW_LABELS_TL T set (
361: NAME,
362: NOTE,
363: TEXT_FLAG,
364: LEFT_POSITION,
380: B.FONT_SIZE,
381: B.FONT_STYLE,
382: B.FONT_COLOR,
383: B.URL
384: from BSC_TAB_VIEW_LABELS_TL B
385: where B.TAB_ID = T.TAB_ID
386: and B.LABEL_ID = T.LABEL_ID
387: and B.TAB_VIEW_ID = T.TAB_VIEW_ID
388: and B.LANGUAGE = T.SOURCE_LANG)
395: SUBT.TAB_ID,
396: SUBT.TAB_VIEW_ID,
397: SUBT.LABEL_ID,
398: SUBT.LANGUAGE
399: from BSC_TAB_VIEW_LABELS_TL SUBB, BSC_TAB_VIEW_LABELS_TL SUBT
400: where SUBB.TAB_ID = SUBT.TAB_ID
401: and SUBB.TAB_VIEW_ID = SUBT.TAB_VIEW_ID
402: and SUBB.LABEL_ID = SUBT.LABEL_ID
403: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
413: or SUBB.FONT_COLOR <> SUBT.FONT_COLOR
414: or SUBB.URL <> SUBT.URL
415: ));
416:
417: insert into BSC_TAB_VIEW_LABELS_TL (
418: TAB_ID,
419: TAB_VIEW_ID,
420: LABEL_ID,
421: NAME,
457: l_user,
458: l_user,
459: L.LANGUAGE_CODE,
460: B.SOURCE_LANG
461: from BSC_TAB_VIEW_LABELS_TL B, FND_LANGUAGES L
462: where L.INSTALLED_FLAG in ('I', 'B')
463: and B.LANGUAGE = userenv('LANG')
464: and not exists
465: (select NULL
462: where L.INSTALLED_FLAG in ('I', 'B')
463: and B.LANGUAGE = userenv('LANG')
464: and not exists
465: (select NULL
466: from BSC_TAB_VIEW_LABELS_TL T
467: where T.TAB_ID = B.TAB_ID
468: and T.TAB_VIEW_ID = B.TAB_VIEW_ID
469: and T.LABEL_ID = B.LABEL_ID
470: and T.LANGUAGE = L.LANGUAGE_CODE);