APPS.BIS_RSS_PORTLETS_PUB dependencies on BIS_RSS_PORTLETS_TL

Line 14: REM | - BIS_RSS_PORTLETS_TL |

10: REM | |
11: REM | DESCRIPTION |
12: REM | Module: Public package for populating the RSS Portlets tables |
13: REM | - BIS_RSS_PORTLETS |
14: REM | - BIS_RSS_PORTLETS_TL |
15: REM | NOTES |
16: REM | 01/20/05 nbarik Initial Creation. |
17: REM | 10/27/05 ugodavar Bug.Fix.4700227 - Procedure Add_Language |
18: REM | |

Line 62: INSERT INTO BIS_RSS_PORTLETS_TL

58: , nvl(p_Rss_Portlet_Rec.Last_Update_Date, sysdate)
59: , nvl(p_Rss_Portlet_Rec.Last_Update_login, FND_GLOBAL.LOGIN_ID)
60: FROM DUAL;
61:
62: INSERT INTO BIS_RSS_PORTLETS_TL
63: ( PORTLET_SHORT_NAME
64: , NAME
65: , DESCRIPTION
66: , LANGUAGE

Line 89: FROM bis_rss_portlets_tl

85: FROM fnd_languages l
86: WHERE L.INSTALLED_FLAG IN ('I', 'B')
87: AND NOT EXISTS
88: (SELECT null
89: FROM bis_rss_portlets_tl
90: WHERE portlet_short_name = p_Rss_Portlet_Rec.Portlet_Short_Name
91: AND language = l.language_code);
92:
93: IF (l_commit = FND_API.G_TRUE) THEN

Line 134: UPDATE bis_rss_portlets_tl

130: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
131:
132: IF p_Rss_Portlet_Rec.Portlet_Short_Name IS NOT NULL THEN
133: BEGIN
134: UPDATE bis_rss_portlets_tl
135: SET name = p_Rss_Portlet_Rec.Name,
136: description = p_Rss_Portlet_Rec.Description,
137: created_by = nvl(p_Rss_Portlet_Rec.Created_By, FND_GLOBAL.USER_ID),
138: creation_date = nvl(p_Rss_Portlet_Rec.Creation_Date, sysdate),

Line 181: DELETE FROM BIS_RSS_PORTLETS_TL T

177: -- procedure to add a language. Bug.Fix.4700227
178: PROCEDURE Add_Language IS
179: BEGIN
180:
181: DELETE FROM BIS_RSS_PORTLETS_TL T
182: WHERE NOT EXISTS
183: (
184: SELECT NULL
185: FROM BIS_RSS_PORTLETS B

Line 189: UPDATE BIS_RSS_PORTLETS_TL T SET (

185: FROM BIS_RSS_PORTLETS B
186: WHERE B.PORTLET_SHORT_NAME = T.PORTLET_SHORT_NAME
187: );
188:
189: UPDATE BIS_RSS_PORTLETS_TL T SET (
190: NAME, DESCRIPTION
191: ) = (SELECT
192: B.NAME, B.DESCRIPTION
193: FROM BIS_RSS_PORTLETS_TL B

Line 193: FROM BIS_RSS_PORTLETS_TL B

189: UPDATE BIS_RSS_PORTLETS_TL T SET (
190: NAME, DESCRIPTION
191: ) = (SELECT
192: B.NAME, B.DESCRIPTION
193: FROM BIS_RSS_PORTLETS_TL B
194: WHERE B.PORTLET_SHORT_NAME = T.PORTLET_SHORT_NAME
195: AND B.LANGUAGE = T.SOURCE_LANG)
196: WHERE (
197: T.PORTLET_SHORT_NAME,

Line 202: FROM BIS_RSS_PORTLETS_TL SUBB, BIS_RSS_PORTLETS_TL SUBT

198: T.LANGUAGE
199: ) IN (SELECT
200: SUBT.PORTLET_SHORT_NAME,
201: SUBT.LANGUAGE
202: FROM BIS_RSS_PORTLETS_TL SUBB, BIS_RSS_PORTLETS_TL SUBT
203: WHERE SUBB.PORTLET_SHORT_NAME = SUBT.PORTLET_SHORT_NAME
204: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
205: AND (SUBB.NAME <> SUBT.NAME
206: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 211: INSERT INTO BIS_RSS_PORTLETS_TL

207: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
208: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
209: ));
210:
211: INSERT INTO BIS_RSS_PORTLETS_TL
212: (
213: PORTLET_SHORT_NAME,
214: NAME,
215: DESCRIPTION,

Line 235: FROM BIS_RSS_PORTLETS_TL B, FND_LANGUAGES L

231: B.CREATION_DATE,
232: B.LAST_UPDATED_BY,
233: B.LAST_UPDATE_DATE,
234: B.LAST_UPDATE_LOGIN
235: FROM BIS_RSS_PORTLETS_TL B, FND_LANGUAGES L
236: WHERE L.INSTALLED_FLAG IN ('I', 'B')
237: AND B.LANGUAGE = USERENV('LANG')
238: AND NOT EXISTS
239: (

Line 241: FROM BIS_RSS_PORTLETS_TL T

237: AND B.LANGUAGE = USERENV('LANG')
238: AND NOT EXISTS
239: (
240: SELECT NULL
241: FROM BIS_RSS_PORTLETS_TL T
242: WHERE T.PORTLET_SHORT_NAME = B.PORTLET_SHORT_NAME
243: AND T.LANGUAGE = L.LANGUAGE_CODE
244: );
245: