eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_KB_USED_SUM_DEFS_PKG SQL Statements

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

Line: 46


  select cs_kb_used_sum_defs_s.nextval into l_id from dual;

Line: 51


  CS_KB_USED_SUM_DEFS_PKG.Insert_Row(
    X_Rowid => l_rowid,
    X_Def_Id => l_id,
    X_days => p_days,
    X_Default_Flag => p_default_flag,
    X_Activated_Flag => p_activated_flag,
    X_Name => p_name,
    X_Description => p_desc,
    X_Creation_Date => l_date,
    X_Created_By => l_created_by,
    X_Last_Update_Date => l_date,
    X_Last_Updated_By => l_created_by,
    X_Last_Update_Login => l_login,
    X_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1 => P_ATTRIBUTE1,
    X_ATTRIBUTE2 => P_ATTRIBUTE2,
    X_ATTRIBUTE3 => P_ATTRIBUTE3,
    X_ATTRIBUTE4 => P_ATTRIBUTE4,
    X_ATTRIBUTE5 => P_ATTRIBUTE5,
    X_ATTRIBUTE6 => P_ATTRIBUTE6,
    X_ATTRIBUTE7 => P_ATTRIBUTE7,
    X_ATTRIBUTE8 => P_ATTRIBUTE8,
    X_ATTRIBUTE9 => P_ATTRIBUTE9,
    X_ATTRIBUTE10 => P_ATTRIBUTE10,
    X_ATTRIBUTE11 => P_ATTRIBUTE11,
    X_ATTRIBUTE12 => P_ATTRIBUTE12,
    X_ATTRIBUTE13 => P_ATTRIBUTE13,
    X_ATTRIBUTE14 => P_ATTRIBUTE14,
    X_ATTRIBUTE15 => P_ATTRIBUTE15
);

Line: 91


FUNCTION Update_Used_Sum_Def(
  p_def_id 	    in number,
  p_days            in NUMBER,
  p_default_flag    in VARCHAR2,
  p_activated_flag  in VARCHAR2,
  p_name            in varchar2,
  p_desc            in varchar2,
  P_ATTRIBUTE_CATEGORY in VARCHAR2,
  P_ATTRIBUTE1 in VARCHAR2,
  P_ATTRIBUTE2 in VARCHAR2,
  P_ATTRIBUTE3 in VARCHAR2,
  P_ATTRIBUTE4 in VARCHAR2,
  P_ATTRIBUTE5 in VARCHAR2,
  P_ATTRIBUTE6 in VARCHAR2,
  P_ATTRIBUTE7 in VARCHAR2,
  P_ATTRIBUTE8 in VARCHAR2,
  P_ATTRIBUTE9 in VARCHAR2,
  P_ATTRIBUTE10 in VARCHAR2,
  P_ATTRIBUTE11 in VARCHAR2,
  P_ATTRIBUTE12 in VARCHAR2,
  P_ATTRIBUTE13 in VARCHAR2,
  P_ATTRIBUTE14 in VARCHAR2,
  P_ATTRIBUTE15 in VARCHAR2
) return number is
  l_ret number;

Line: 117


  l_updated_by number;

Line: 129


  l_updated_by := fnd_global.user_id;

Line: 132


  CS_KB_USED_SUM_DEFS_PKG.Update_Row(
    X_def_Id => p_def_id,
    X_days => p_days,
    X_Default_Flag => p_default_flag,
    X_Activated_Flag => p_activated_flag,
    X_Name => p_name,
    X_Description => p_desc,
    X_Last_Update_Date => l_date,
    X_Last_Updated_By => l_updated_by,
    X_Last_Update_Login => l_login,
    X_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1 => P_ATTRIBUTE1,
    X_ATTRIBUTE2 => P_ATTRIBUTE2,
    X_ATTRIBUTE3 => P_ATTRIBUTE3,
    X_ATTRIBUTE4 => P_ATTRIBUTE4,
    X_ATTRIBUTE5 => P_ATTRIBUTE5,
    X_ATTRIBUTE6 => P_ATTRIBUTE6,
    X_ATTRIBUTE7 => P_ATTRIBUTE7,
    X_ATTRIBUTE8 => P_ATTRIBUTE8,
    X_ATTRIBUTE9 => P_ATTRIBUTE9,
    X_ATTRIBUTE10 => P_ATTRIBUTE10,
    X_ATTRIBUTE11 => P_ATTRIBUTE11,
    X_ATTRIBUTE12 => P_ATTRIBUTE12,
    X_ATTRIBUTE13 => P_ATTRIBUTE13,
    X_ATTRIBUTE14 => P_ATTRIBUTE14,
    X_ATTRIBUTE15 => P_ATTRIBUTE15);

Line: 165


end Update_Used_Sum_Def;

Line: 170


FUNCTION Delete_Used_Sum_Def(
  p_def_id in number
) return number is
  l_ret number;

Line: 178


  select count(*) into l_count
    from cs_kb_used_sum_defs_b
    where def_id = p_def_id;

Line: 183


  CS_KB_USED_SUM_DEFS_PKG.Delete_Row(
    X_Def_Id => p_def_id);

Line: 193


end Delete_Used_Sum_Def;

Line: 196


procedure INSERT_ROW (
  X_ROWID in OUT NOCOPY VARCHAR2,
  X_DEF_ID in NUMBER,
  X_DAYS in NUMBER,
  X_DEFAULT_FLAG in VARCHAR2,
  X_ACTIVATED_FLAG in VARCHAR2,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
  cursor C is select ROWID from CS_KB_USED_SUM_DEFS_B
    where DEF_ID = X_DEF_ID
    ;

Line: 230


  insert into CS_KB_USED_SUM_DEFS_B (
    DEF_ID,
    DAYS,
    DEFAULT_FLAG,
    ACTIVATED_FLAG,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_DEF_ID,
    X_DAYS,
    X_DEFAULT_FLAG,
    X_ACTIVATED_FLAG,
    X_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1,
    X_ATTRIBUTE2,
    X_ATTRIBUTE3,
    X_ATTRIBUTE4,
    X_ATTRIBUTE5,
    X_ATTRIBUTE6,
    X_ATTRIBUTE7,
    X_ATTRIBUTE8,
    X_ATTRIBUTE9,
    X_ATTRIBUTE10,
    X_ATTRIBUTE11,
    X_ATTRIBUTE12,
    X_ATTRIBUTE13,
    X_ATTRIBUTE14,
    X_ATTRIBUTE15,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 284


  insert into CS_KB_USED_SUM_DEFS_TL (
    DEF_ID,
    NAME,
    DESCRIPTION,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_DEF_ID,
    X_NAME,
    X_DESCRIPTION,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from CS_KB_USED_SUM_DEFS_TL T
    where T.DEF_ID = X_DEF_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 322


end INSERT_ROW;

Line: 348


  cursor c is select
      DAYS,
      DEFAULT_FLAG,
      ACTIVATED_FLAG,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15
    from CS_KB_USED_SUM_DEFS_B
    where DEF_ID = X_DEF_ID
    for update of DEF_ID nowait;

Line: 373


  cursor c1 is select
      NAME,
      DESCRIPTION,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from CS_KB_USED_SUM_DEFS_TL
    where DEF_ID = X_DEF_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of DEF_ID nowait;

Line: 386


    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 452


procedure UPDATE_ROW (
  X_DEF_ID in NUMBER,
  X_DAYS in NUMBER,
  X_DEFAULT_FLAG in VARCHAR2,
  X_ACTIVATED_FLAG in VARCHAR2,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update CS_KB_USED_SUM_DEFS_B set
    DAYS = X_DAYS,
    DEFAULT_FLAG = X_DEFAULT_FLAG,
    ACTIVATED_FLAG = X_ACTIVATED_FLAG,
    ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
    ATTRIBUTE1 = X_ATTRIBUTE1,
    ATTRIBUTE2 = X_ATTRIBUTE2,
    ATTRIBUTE3 = X_ATTRIBUTE3,
    ATTRIBUTE4 = X_ATTRIBUTE4,
    ATTRIBUTE5 = X_ATTRIBUTE5,
    ATTRIBUTE6 = X_ATTRIBUTE6,
    ATTRIBUTE7 = X_ATTRIBUTE7,
    ATTRIBUTE8 = X_ATTRIBUTE8,
    ATTRIBUTE9 = X_ATTRIBUTE9,
    ATTRIBUTE10 = X_ATTRIBUTE10,
    ATTRIBUTE11 = X_ATTRIBUTE11,
    ATTRIBUTE12 = X_ATTRIBUTE12,
    ATTRIBUTE13 = X_ATTRIBUTE13,
    ATTRIBUTE14 = X_ATTRIBUTE14,
    ATTRIBUTE15 = X_ATTRIBUTE15,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where DEF_ID = X_DEF_ID;

Line: 509


  update CS_KB_USED_SUM_DEFS_TL set
    NAME = X_NAME,
    DESCRIPTION = X_DESCRIPTION,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    SOURCE_LANG = userenv('LANG')
  where DEF_ID = X_DEF_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 522


end UPDATE_ROW;

Line: 524


procedure DELETE_ROW (
  X_DEF_ID in NUMBER
) is
begin
  delete from CS_KB_USED_SUM_DEFS_TL
  where DEF_ID = X_DEF_ID;

Line: 535


  delete from CS_KB_USED_SUM_DEFS_B
  where DEF_ID = X_DEF_ID;

Line: 541


end DELETE_ROW;

Line: 546


  delete from CS_KB_USED_SUM_DEFS_TL T
  where not exists
    (select NULL
    from CS_KB_USED_SUM_DEFS_B B
    where B.DEF_ID = T.DEF_ID
    );

Line: 553


  update CS_KB_USED_SUM_DEFS_TL T set (
      NAME,
      DESCRIPTION
    ) = (select
      B.NAME,
      B.DESCRIPTION
    from CS_KB_USED_SUM_DEFS_TL B
    where B.DEF_ID = T.DEF_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.DEF_ID,
      T.LANGUAGE
  ) in (select
      SUBT.DEF_ID,
      SUBT.LANGUAGE
    from CS_KB_USED_SUM_DEFS_TL SUBB, CS_KB_USED_SUM_DEFS_TL SUBT
    where SUBB.DEF_ID = SUBT.DEF_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.NAME <> SUBT.NAME
      or (SUBB.NAME is null and SUBT.NAME is not null)
      or (SUBB.NAME is not null and SUBT.NAME is null)
      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: 579


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

Line: 622


    update CS_KB_USED_SUM_DEFS_TL set
            NAME = x_name,
            DESCRIPTION = x_description,
            LAST_UPDATE_DATE = sysdate,
            LAST_UPDATED_BY = decode(x_owner, 'SEED',1, 0),
            LAST_UPDATE_LOGIN = 0,
            SOURCE_LANG = userenv('LANG')

          where userenv('LANG') in (LANGUAGE,SOURCE_LANG)
          and DEF_ID = X_DEF_ID;

Line: 658


    CS_KB_USED_SUM_DEFS_PKG.Update_Row(
    X_Def_Id => x_def_id,
    X_Days => x_days,
    X_Default_Flag => x_default_flag,
    X_Activated_Flag => x_activated_flag,
    X_Attribute_Category => null,
    X_Attribute1 => null,
    X_Attribute2 => null,
    X_Attribute3 => null,
    X_Attribute4 => null,
    X_Attribute5 => null,
    X_Attribute6 => null,
    X_Attribute7 => null,
    X_Attribute8 => null,
    X_Attribute9 => null,
    X_Attribute10 => null,
    X_Attribute11 => null,
    X_Attribute12 => null,
    X_Attribute13 => null,
    X_Attribute14 => null,
    X_Attribute15 => null,
    X_Name => x_name,
    X_Description => x_description,
    X_Last_Update_Date => sysdate,
    X_Last_Updated_By => l_user_id,
    X_Last_Update_Login => 0);

Line: 687


        	CS_KB_USED_SUM_DEFS_PKG.Insert_Row(
       		X_Rowid => l_rowid,
            X_Def_Id => x_def_id,
            X_Days => x_days,
            X_Default_Flag => x_default_flag,
            X_Activated_Flag => x_activated_flag,
            X_Attribute_Category => null,
            X_Attribute1 => null,
            X_Attribute2 => null,
            X_Attribute3 => null,
            X_Attribute4 => null,
            X_Attribute5 => null,
            X_Attribute6 => null,
            X_Attribute7 => null,
            X_Attribute8 => null,
            X_Attribute9 => null,
            X_Attribute10 => null,
            X_Attribute11 => null,
            X_Attribute12 => null,
            X_Attribute13 => null,
            X_Attribute14 => null,
            X_Attribute15 => null,
            X_Name => x_name,
            X_Description => x_description,
    		X_Creation_Date => sysdate,
    		X_Created_By => l_user_id,
    		X_Last_Update_Date => sysdate,
    		X_Last_Updated_By => l_user_id,
    		X_Last_Update_Login => 0);