APPS.JTF_NAV_VIEWBYS_PKG SQL Statements

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

Line: 4

procedure INSERT_ROW (
  X_VIEWBY_VALUE in VARCHAR2,
  X_TAB_id in number,
  X_SEQUENCE_NUMBER in NUMBER,
  X_VIEWBY_LABEL 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

   l_viewby_id number := 0;

Line: 18

   SELECT jtf_nav_viewbys_s.nextval
     INTO l_viewby_id
     FROM dual;

Line: 21

   insert into JTF_NAV_VIEWBYS_B
     (viewby_id,
     VIEWBY_VALUE,
     TAB_id,
     SEQUENCE_NUMBER,
     CREATION_DATE,
     CREATED_BY,
     LAST_UPDATE_DATE,
     LAST_UPDATED_BY,
     LAST_UPDATE_LOGIN
     ) values (
     l_viewby_id,
     X_VIEWBY_VALUE,
     X_TAB_id,
     X_SEQUENCE_NUMBER,
     X_CREATION_DATE,
     X_CREATED_BY,
     X_LAST_UPDATE_DATE,
     X_LAST_UPDATED_BY,
     X_LAST_UPDATE_LOGIN);

Line: 42

   insert into JTF_NAV_VIEWBYS_TL (
     viewby_id,
     VIEWBY_LABEL,
     CREATED_BY,
     CREATION_DATE,
     LAST_UPDATE_LOGIN,
     LAST_UPDATE_DATE,
     LAST_UPDATED_BY,
     LANGUAGE,
     SOURCE_LANG)
     select
     l_viewby_id,
       X_VIEWBY_LABEL,
       X_CREATED_BY,
       X_CREATION_DATE,
       X_LAST_UPDATE_LOGIN,
       X_LAST_UPDATE_DATE,
       X_LAST_UPDATED_BY,
       L.LANGUAGE_CODE,
       userenv('LANG')
       from FND_LANGUAGES L
       where L.INSTALLED_FLAG in ('I', 'B')
       and not exists
       (select NULL
       from JTF_NAV_VIEWBYS_TL T
       where T.VIEWBY_id = l_viewby_id
       and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 70

end INSERT_ROW;

Line: 72

procedure UPDATE_ROW
  (x_viewby_id IN number,
  X_VIEWBY_VALUE in VARCHAR2,
  X_TAB_id in number,
  X_SEQUENCE_NUMBER in NUMBER,
  X_VIEWBY_LABEL in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER) is
begin
   update JTF_NAV_VIEWBYS_B SET
     viewby_value = x_viewby_value,
     TAB_id = X_TAB_id,
     SEQUENCE_NUMBER = X_SEQUENCE_NUMBER,
     LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
     LAST_UPDATED_BY = X_LAST_UPDATED_BY,
     LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
     where VIEWBY_id = X_VIEWBY_id;

Line: 95

  update JTF_NAV_VIEWBYS_TL set
    VIEWBY_LABEL = X_VIEWBY_LABEL,
    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 VIEWBY_id = X_VIEWBY_id
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 107

end UPDATE_ROW;

Line: 117

     select viewby_value, TAB_id, SEQUENCE_NUMBER
       from JTF_NAV_VIEWBYS_B
       where VIEWBY_id = X_VIEWBY_id
       for update of VIEWBY_id nowait;

Line: 123

  cursor c1 is select
      VIEWBY_LABEL,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from JTF_NAV_VIEWBYS_TL
    where VIEWBY_id = X_VIEWBY_id
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of VIEWBY_id nowait;

Line: 135

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

Line: 164

procedure DELETE_ROW (
  X_VIEWBY_id in number) is
begin
  delete from JTF_NAV_VIEWBYS_TL
  where VIEWBY_id = X_VIEWBY_id;

Line: 174

  delete from JTF_NAV_VIEWBYS_B
  where VIEWBY_id = X_VIEWBY_id;

Line: 180

end DELETE_ROW;

Line: 185

  delete from JTF_NAV_VIEWBYS_TL T
  where not exists
    (select NULL
    from JTF_NAV_VIEWBYS_B B
    where B.VIEWBY_id = T.VIEWBY_id
    );

Line: 192

  update JTF_NAV_VIEWBYS_TL T set (
      VIEWBY_LABEL
    ) = (select
      B.VIEWBY_LABEL
    from JTF_NAV_VIEWBYS_TL B
    where B.VIEWBY_id = T.VIEWBY_id
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.VIEWBY_id,
      T.LANGUAGE
  ) in (select
      SUBT.VIEWBY_id,
      SUBT.LANGUAGE
    from JTF_NAV_VIEWBYS_TL SUBB, JTF_NAV_VIEWBYS_TL SUBT
    where SUBB.VIEWBY_id = SUBT.VIEWBY_id
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.VIEWBY_LABEL <> SUBT.VIEWBY_LABEL
  ));

Line: 211

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

Line: 273

   SELECT tab_id
     INTO l_tab_id
     FROM jtf_nav_tabs_b
     WHERE tab_value = x_tab_value;

Line: 279

   UPDATE  jtf_nav_viewbys_b SET
     tab_id = l_tab_id,
     sequence_number = x_sequence_number,
     last_update_date = sysdate,
     last_updated_by = user_id,
     last_update_login = 0
     WHERE viewby_value = x_viewby_value;

Line: 289

      SELECT jtf_nav_viewbys_s.nextval
        INTO l_viewby_id
        FROM dual;

Line: 293

      INSERT INTO jtf_nav_viewbys_b
        (viewby_id,
        viewby_value,
        tab_id,
        sequence_number,
        creation_date,
        created_by,
        last_update_date,
        last_updated_by,
        last_update_login
        ) VALUES
        (l_viewby_id,
        x_viewby_value,
        l_tab_id,
        x_sequence_number,
        sysdate,
        user_id,
        sysdate,
        user_id,
        0
        );

Line: 317

   SELECT viewby_id
     INTO l_viewby_id
     FROM jtf_nav_viewbys_b
     WHERE viewby_value = x_viewby_value;

Line: 323

   UPDATE jtf_nav_viewbys_tl SET
     viewby_label = x_viewby_label,
     last_update_date = sysdate,
     last_updated_by = user_id,
     last_update_login = 0,
     source_lang = userenv('LANG')
     WHERE viewby_id = l_viewby_id
     AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);

Line: 334

      INSERT INTO jtf_nav_viewbys_tl
        (viewby_id,
         viewby_label,
         creation_date,
         created_by,
         last_update_date,
         last_updated_by,
         last_update_login,
         language,
         source_lang)
        SELECT
        l_viewby_id,
        x_viewby_label,
        sysdate,
        user_id,
        sysdate,
        user_id,
        0,
        l.language_code,
        userenv('LANG')
        FROM fnd_languages l
        WHERE l.installed_flag IN ('I', 'B')
        AND NOT EXISTS
        (SELECT NULL
         FROM jtf_nav_viewbys_tl t
         WHERE t.viewby_id = l_viewby_id
         AND t.language = l.language_code);

Line: 394

   SELECT viewby_id
     INTO l_viewby_id
     FROM jtf_nav_viewbys_b
     WHERE viewby_value = x_viewby_value;

Line: 400

   UPDATE jtf_nav_viewbys_tl SET
     viewby_label = x_viewby_label,
     last_update_date = sysdate,
     last_updated_by = user_id,
     last_update_login = 0,
     source_lang = userenv('LANG')
     WHERE viewby_id = l_viewby_id
     AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);