8: REM | FILENAME |
9: REM | BISPRLKB.pls |
10: REM | |
11: REM | DESCRIPTION |
12: REM | Module: Private for populating the table BIS_RELATED_LINKS_TL |
13: REM | |
14: REM | NOTES |
15: REM | 14-OCT-2005 Seema Rao Created. |
16: REM +=======================================================================+
24: -- procedure to add a language.
25: PROCEDURE Add_Language IS
26: BEGIN
27:
28: DELETE FROM BIS_RELATED_LINKS_TL T
29: WHERE NOT EXISTS
30: (
31: SELECT NULL
32: FROM BIS_RELATED_LINKS B
32: FROM BIS_RELATED_LINKS B
33: WHERE B.RELATED_LINK_ID = T.RELATED_LINK_ID
34: );
35:
36: UPDATE BIS_RELATED_LINKS_TL T SET (
37: USER_LINK_NAME
38: ) = (SELECT
39: B.USER_LINK_NAME
40: FROM BIS_RELATED_LINKS_TL B
36: UPDATE BIS_RELATED_LINKS_TL T SET (
37: USER_LINK_NAME
38: ) = (SELECT
39: B.USER_LINK_NAME
40: FROM BIS_RELATED_LINKS_TL B
41: WHERE B.RELATED_LINK_ID = T.RELATED_LINK_ID
42: AND B.LANGUAGE = T.SOURCE_LANG)
43: WHERE (
44: T.RELATED_LINK_ID,
45: T.LANGUAGE
46: ) IN (SELECT
47: SUBT.RELATED_LINK_ID,
48: SUBT.LANGUAGE
49: FROM BIS_RELATED_LINKS_TL SUBB, BIS_RELATED_LINKS_TL SUBT
50: WHERE SUBB.RELATED_LINK_ID = SUBT.RELATED_LINK_ID
51: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
52: AND (
53: SUBB.USER_LINK_NAME <> SUBT.USER_LINK_NAME
53: SUBB.USER_LINK_NAME <> SUBT.USER_LINK_NAME
54: )
55: );
56:
57: INSERT INTO BIS_RELATED_LINKS_TL
58: (
59: RELATED_LINK_ID
60: , USER_LINK_NAME
61: , LANGUAGE
75: , B.CREATION_DATE
76: , B.LAST_UPDATED_BY
77: , B.LAST_UPDATE_DATE
78: , B.LAST_UPDATE_LOGIN
79: FROM BIS_RELATED_LINKS_TL B, FND_LANGUAGES L
80: WHERE L.INSTALLED_FLAG IN ('I', 'B')
81: AND B.LANGUAGE = USERENV('LANG')
82: AND NOT EXISTS
83: (
81: AND B.LANGUAGE = USERENV('LANG')
82: AND NOT EXISTS
83: (
84: SELECT NULL
85: FROM BIS_RELATED_LINKS_TL T
86: WHERE T.RELATED_LINK_ID = B.RELATED_LINK_ID
87: AND T.LANGUAGE = L.LANGUAGE_CODE
88: );
89: