APPS.AS_FORECAST_CATEGORIES_PKG SQL Statements

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

Line: 14

PROCEDURE Insert_Row(
          px_FORECAST_CATEGORY_ID   IN OUT NOCOPY NUMBER,
          p_CREATED_BY    NUMBER,
          p_CREATION_DATE    DATE,
          p_LAST_UPDATED_BY    NUMBER,
          p_LAST_UPDATE_DATE    DATE,
          p_LAST_UPDATE_LOGIN    NUMBER,
          p_FORECAST_CATEGORY_NAME    VARCHAR2,
          p_START_DATE_ACTIVE    DATE,
          p_END_DATE_ACTIVE    DATE)

 IS
   CURSOR C2 IS SELECT AS_FORECAST_CATEGORIES_S.nextval FROM sys.dual;

Line: 34

   INSERT INTO AS_FORECAST_CATEGORIES_B(
           FORECAST_CATEGORY_ID,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATE_LOGIN,
           START_DATE_ACTIVE,
           END_DATE_ACTIVE
          ) VALUES (
           px_FORECAST_CATEGORY_ID,
           decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
           decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
           decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
           decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
           decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
           decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE_ACTIVE),
           decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE_ACTIVE));

Line: 53

    INSERT INTO AS_FORECAST_CATEGORIES_TL(
           FORECAST_CATEGORY_ID,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATE_LOGIN,
           FORECAST_CATEGORY_NAME,
     		LANGUAGE,
    		SOURCE_LANG
  	  ) select
           px_FORECAST_CATEGORY_ID,
           decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
           decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
           decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
           decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
           decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
           decode( p_FORECAST_CATEGORY_NAME, FND_API.G_MISS_CHAR, NULL, p_FORECAST_CATEGORY_NAME),
    		L.LANGUAGE_CODE,
    		userenv('LANG')
  	from FND_LANGUAGES L
  	where L.INSTALLED_FLAG in ('I', 'B')
  	and not exists
    	(select NULL
    		from AS_FORECAST_CATEGORIES_TL T
    		where T.FORECAST_CATEGORY_ID = px_FORECAST_CATEGORY_ID
    		and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 82

End Insert_Row;

Line: 84

PROCEDURE Update_Row(
          p_FORECAST_CATEGORY_ID    NUMBER,
          p_CREATED_BY    NUMBER,
          p_CREATION_DATE    DATE,
          p_LAST_UPDATED_BY    NUMBER,
          p_LAST_UPDATE_DATE    DATE,
          p_LAST_UPDATE_LOGIN    NUMBER,
          p_FORECAST_CATEGORY_NAME    VARCHAR2,
          p_START_DATE_ACTIVE    DATE,
          p_END_DATE_ACTIVE    DATE)

 IS
 BEGIN
    Update AS_FORECAST_CATEGORIES_B
    SET
              CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
              CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
              LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
              LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
              LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
              START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, START_DATE_ACTIVE, p_START_DATE_ACTIVE),
              END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, END_DATE_ACTIVE, p_END_DATE_ACTIVE)
    where FORECAST_CATEGORY_ID = p_FORECAST_CATEGORY_ID;

Line: 112

    Update AS_FORECAST_CATEGORIES_TL
    SET
              CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
              CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
              LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
              LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
              LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
              FORECAST_CATEGORY_NAME = decode( p_FORECAST_CATEGORY_NAME, FND_API.G_MISS_CHAR, FORECAST_CATEGORY_NAME, p_FORECAST_CATEGORY_NAME),
              SOURCE_LANG = userenv('LANG')
    where FORECAST_CATEGORY_ID = p_FORECAST_CATEGORY_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 128

END Update_Row;

Line: 130

PROCEDURE Delete_Row(
    p_FORECAST_CATEGORY_ID  NUMBER)
 IS
 BEGIN
   DELETE FROM AS_FORECAST_CATEGORIES_B
    WHERE FORECAST_CATEGORY_ID = p_FORECAST_CATEGORY_ID;

Line: 141

   DELETE FROM AS_FORECAST_CATEGORIES_TL
    WHERE FORECAST_CATEGORY_ID = p_FORECAST_CATEGORY_ID;

Line: 148

 END Delete_Row;

Line: 154

          p_LAST_UPDATED_BY    NUMBER,
          p_LAST_UPDATE_DATE    DATE,
          p_LAST_UPDATE_LOGIN    NUMBER,
          p_FORECAST_CATEGORY_NAME    VARCHAR2,
          p_START_DATE_ACTIVE    DATE,
          p_END_DATE_ACTIVE    DATE)

 IS
   CURSOR C IS
        SELECT *
         FROM AS_FORECAST_CATEGORIES_B
        WHERE FORECAST_CATEGORY_ID =  p_FORECAST_CATEGORY_ID
        FOR UPDATE of FORECAST_CATEGORY_ID NOWAIT;

Line: 171

        SELECT   FORECAST_CATEGORY_NAME,
          decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG

         FROM AS_FORECAST_CATEGORIES_TL
        WHERE FORECAST_CATEGORY_ID =  p_FORECAST_CATEGORY_ID
       and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
       FOR UPDATE of FORECAST_CATEGORY_ID NOWAIT;

Line: 184

        FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

Line: 196

       AND (    ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
            OR (    ( Recinfo.LAST_UPDATED_BY IS NULL )
                AND (  p_LAST_UPDATED_BY IS NULL )))
       AND (    ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
            OR (    ( Recinfo.LAST_UPDATE_DATE IS NULL )
                AND (  p_LAST_UPDATE_DATE IS NULL )))
       AND (    ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
            OR (    ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
                AND (  p_LAST_UPDATE_LOGIN IS NULL )))
       AND (    ( Recinfo.START_DATE_ACTIVE = p_START_DATE_ACTIVE)
            OR (    ( Recinfo.START_DATE_ACTIVE IS NULL )
                AND (  p_START_DATE_ACTIVE IS NULL )))
       AND (    ( Recinfo.END_DATE_ACTIVE = p_END_DATE_ACTIVE)
            OR (    ( Recinfo.END_DATE_ACTIVE IS NULL )
                AND (  p_END_DATE_ACTIVE IS NULL )))
       ) then
       return;

Line: 238

  delete from AS_FORECAST_CATEGORIES_TL T
  where not exists
    (select NULL
    from AS_FORECAST_CATEGORIES_B B
    where B.FORECAST_CATEGORY_ID = T.FORECAST_CATEGORY_ID
    );

Line: 245

  update AS_FORECAST_CATEGORIES_TL T set (
      FORECAST_CATEGORY_NAME
    ) = (select
      FORECAST_CATEGORY_NAME
    from AS_FORECAST_CATEGORIES_TL B
    where B.FORECAST_CATEGORY_ID = T.FORECAST_CATEGORY_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.FORECAST_CATEGORY_ID,
      T.LANGUAGE
  ) in (select
      SUBT.FORECAST_CATEGORY_ID,
      SUBT.LANGUAGE
    from AS_FORECAST_CATEGORIES_TL SUBB, AS_FORECAST_CATEGORIES_TL SUBT
    where SUBB.FORECAST_CATEGORY_ID = SUBT.FORECAST_CATEGORY_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and ( SUBB.FORECAST_CATEGORY_NAME <> SUBT.FORECAST_CATEGORY_NAME
      or (SUBB.FORECAST_CATEGORY_NAME is null and SUBT.FORECAST_CATEGORY_NAME is not null)
      or (SUBB.FORECAST_CATEGORY_NAME is not null and SUBT.FORECAST_CATEGORY_NAME is null)
  ));

Line: 266

  insert into AS_FORECAST_CATEGORIES_TL (
    FORECAST_CATEGORY_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    FORECAST_CATEGORY_NAME,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.FORECAST_CATEGORY_ID,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.CREATION_DATE,
    B.CREATED_BY,
    B.LAST_UPDATE_LOGIN,
    B.FORECAST_CATEGORY_NAME,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from AS_FORECAST_CATEGORIES_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from AS_FORECAST_CATEGORIES_TL T
    where T.FORECAST_CATEGORY_ID = B.FORECAST_CATEGORY_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 313

	 select 'Y'
	 from AS_FORECAST_CATEGORIES_B
	 where last_updated_by <> 1
	 and FORECAST_CATEGORY_ID = p_forecast_category_id;

Line: 335

      AS_FORECAST_CATEGORIES_PKG.UPDATE_ROW(
          p_FORECAST_CATEGORY_ID     => X_FORECAST_CATEGORY_ID,
          p_CREATED_BY               => 0,
          p_CREATION_DATE            => sysdate,
          p_LAST_UPDATED_BY          => user_id,
          p_LAST_UPDATE_DATE         => sysdate,
          p_LAST_UPDATE_LOGIN        =>  0,
          p_FORECAST_CATEGORY_NAME   => X_FORECAST_CATEGORY_NAME,--FND_API.G_MISS_CHAR,
          p_START_DATE_ACTIVE        => x_start_date_active,
          p_END_DATE_ACTIVE          => x_end_date_active
      );

Line: 350

	 AS_FORECAST_CATEGORIES_PKG.INSERT_ROW(
          px_FORECAST_CATEGORY_ID    => l_FORECAST_CATEGORY_ID,
          p_CREATED_BY               => 0,
          p_CREATION_DATE            => sysdate,
          p_LAST_UPDATED_BY          => user_id,
          p_LAST_UPDATE_DATE         => sysdate,
          p_LAST_UPDATE_LOGIN        => 0 ,
          p_FORECAST_CATEGORY_NAME   => X_FORECAST_CATEGORY_NAME,
          p_START_DATE_ACTIVE        => x_start_date_active,
          p_END_DATE_ACTIVE          => x_end_date_active
 	  );

Line: 376

   update AS_FORECAST_CATEGORIES_TL
     set FORECAST_CATEGORY_NAME  = p_FORECAST_CATEGORY_NAME,
         source_lang = userenv('LANG'),
	    last_update_date = sysdate,
	    last_updated_by = decode(p_OWNER, 'SEED', 1, 0),
	    last_update_login = 0
      where  FORECAST_CATEGORY_ID = p_FORECAST_CATEGORY_ID
	 and userenv('LANG') in (language, source_lang);