APPS.BIS_RSS_PORTLETS_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 41

	INSERT INTO BIS_RSS_PORTLETS
	  (    PORTLET_SHORT_NAME
	     , XML_URL
	     , XSL_URL
	     , CREATED_BY
	     , CREATION_DATE
	     , LAST_UPDATED_BY
	     , LAST_UPDATE_DATE
         , LAST_UPDATE_LOGIN
       )
	  SELECT
	       p_Rss_Portlet_Rec.Portlet_Short_Name
	     , p_Rss_Portlet_Rec.Xml_Url
	     , p_Rss_Portlet_Rec.Xsl_Url
	     , nvl(p_Rss_Portlet_Rec.Created_By, FND_GLOBAL.USER_ID)
	     , nvl(p_Rss_Portlet_Rec.Creation_Date, sysdate)
	     , nvl(p_Rss_Portlet_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)
	     , nvl(p_Rss_Portlet_Rec.Last_Update_Date, sysdate)
	     , nvl(p_Rss_Portlet_Rec.Last_Update_login, FND_GLOBAL.LOGIN_ID)
   	FROM DUAL;

Line: 62

	INSERT INTO BIS_RSS_PORTLETS_TL
	  (    PORTLET_SHORT_NAME
	     , NAME
	     , DESCRIPTION
	     , LANGUAGE
	     , SOURCE_LANG
	     , CREATED_BY
	     , CREATION_DATE
	     , LAST_UPDATED_BY
	     , LAST_UPDATE_DATE
         , LAST_UPDATE_LOGIN
       )
	  SELECT
	       p_Rss_Portlet_Rec.Portlet_Short_Name
	     , p_Rss_Portlet_Rec.Name
	     , p_Rss_Portlet_Rec.Description
	     , language_code
	     , userenv('LANG')
	     , nvl(p_Rss_Portlet_Rec.Created_By, FND_GLOBAL.USER_ID)
	     , nvl(p_Rss_Portlet_Rec.Creation_Date, sysdate)
	     , nvl(p_Rss_Portlet_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)
	     , nvl(p_Rss_Portlet_Rec.Last_Update_Date, sysdate)
	     , nvl(p_Rss_Portlet_Rec.Last_Update_login, FND_GLOBAL.LOGIN_ID)
	FROM fnd_languages l
  	WHERE L.INSTALLED_FLAG IN ('I', 'B')
	AND NOT EXISTS
		(SELECT null
		FROM bis_rss_portlets_tl
		WHERE portlet_short_name = p_Rss_Portlet_Rec.Portlet_Short_Name
		AND language = l.language_code);

Line: 134

			UPDATE bis_rss_portlets_tl
			SET name = p_Rss_Portlet_Rec.Name,
			    description = p_Rss_Portlet_Rec.Description,
			    created_by = nvl(p_Rss_Portlet_Rec.Created_By, FND_GLOBAL.USER_ID),
			    creation_date = nvl(p_Rss_Portlet_Rec.Creation_Date, sysdate),
			    last_updated_by = nvl(p_Rss_Portlet_Rec.Last_Updated_By, FND_GLOBAL.USER_ID),
			    last_update_date = nvl(p_Rss_Portlet_Rec.Last_Update_Date, sysdate),
			    last_update_login = nvl(p_Rss_Portlet_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID),
        		source_lang = userenv('LANG')
			WHERE portlet_short_name = p_Rss_Portlet_Rec.Portlet_Short_Name
			AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);

Line: 181

    DELETE FROM BIS_RSS_PORTLETS_TL T
    WHERE NOT EXISTS
    (
      SELECT NULL
      FROM   BIS_RSS_PORTLETS B
      WHERE  B.PORTLET_SHORT_NAME = T.PORTLET_SHORT_NAME
    );

Line: 189

    UPDATE BIS_RSS_PORTLETS_TL T SET (
        NAME, DESCRIPTION
    ) = (SELECT
            B.NAME, B.DESCRIPTION
         FROM  BIS_RSS_PORTLETS_TL B
         WHERE B.PORTLET_SHORT_NAME = T.PORTLET_SHORT_NAME
         AND   B.LANGUAGE           = T.SOURCE_LANG)
         WHERE (
            T.PORTLET_SHORT_NAME,
            T.LANGUAGE
         ) IN (SELECT
                SUBT.PORTLET_SHORT_NAME,
                SUBT.LANGUAGE
                FROM  BIS_RSS_PORTLETS_TL SUBB, BIS_RSS_PORTLETS_TL SUBT
                WHERE SUBB.PORTLET_SHORT_NAME = SUBT.PORTLET_SHORT_NAME
                AND   SUBB.LANGUAGE           = SUBT.SOURCE_LANG
                AND (SUBB.NAME <> SUBT.NAME
		      or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
		      or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
		      or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
		  ));

Line: 211

    INSERT INTO BIS_RSS_PORTLETS_TL
    (
      PORTLET_SHORT_NAME,
      NAME,
      DESCRIPTION,
      LANGUAGE,
      SOURCE_LANG,
      CREATED_BY,
      CREATION_DATE,
      LAST_UPDATED_BY,
      LAST_UPDATE_DATE,
      LAST_UPDATE_LOGIN
    )
    SELECT
       B.PORTLET_SHORT_NAME,
       B.NAME,
       B.DESCRIPTION,
       L.LANGUAGE_CODE,
       B.SOURCE_LANG,
       B.CREATED_BY,
       B.CREATION_DATE,
       B.LAST_UPDATED_BY,
       B.LAST_UPDATE_DATE,
       B.LAST_UPDATE_LOGIN
   FROM  BIS_RSS_PORTLETS_TL B, FND_LANGUAGES L
   WHERE L.INSTALLED_FLAG IN ('I', 'B')
   AND   B.LANGUAGE = USERENV('LANG')
   AND   NOT EXISTS
        (
          SELECT NULL
          FROM   BIS_RSS_PORTLETS_TL T
          WHERE  T.PORTLET_SHORT_NAME = B.PORTLET_SHORT_NAME
          AND    T.LANGUAGE           = L.LANGUAGE_CODE
        );