APPS.JTF_NAV_TABS_PKG SQL Statements

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

Line: 4

PROCEDURE INSERT_ROW (X_TAB_VALUE in VARCHAR2,
                      X_NAVIGATOR_TYPE IN VARCHAR2,
                      X_APPLICATION_ID in NUMBER,
                      X_ICON_NAME in VARCHAR2,
                      X_SEQUENCE_NUMBER in NUMBER,
                      X_TAB_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_tab_id number := 0;

Line: 23

   SELECT jtf_nav_tabs_s.nextval
     INTO l_tab_id
     FROM dual;

Line: 26

   insert into JTF_NAV_TABS_b
     (tab_id,
     TAB_VALUE,
     NAVIGATOR_TYPE,
     APPLICATION_ID,
     ICON_NAME,
     SEQUENCE_NUMBER,
     CREATION_DATE,
     CREATED_BY,
     LAST_UPDATE_DATE,
     LAST_UPDATED_BY,
     LAST_UPDATE_LOGIN
     ) values (
     l_tab_id,
     X_TAB_VALUE,
     x_navigator_type,
     X_APPLICATION_ID,
     X_ICON_NAME,
     X_SEQUENCE_NUMBER,
     X_CREATION_DATE,
     X_CREATED_BY,
     X_LAST_UPDATE_DATE,
     X_LAST_UPDATED_BY,
     X_LAST_UPDATE_LOGIN);

Line: 51

 insert into JTF_NAV_TABS_TL (
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATE_LOGIN,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    tab_id,
    TAB_LABEL,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_CREATED_BY,
    X_CREATION_DATE,
    X_LAST_UPDATE_LOGIN,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    l_tab_id,
    X_TAB_LABEL,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from JTF_NAV_TABS_TL T
    where T.TAB_id = l_tab_id
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 79

end INSERT_ROW;

Line: 81

procedure UPDATE_ROW
  (x_tab_id IN number,
   X_TAB_VALUE in VARCHAR2,
   X_NAVIGATOR_TYPE IN VARCHAR2,
   X_APPLICATION_ID in NUMBER,
   X_ICON_NAME in VARCHAR2,
   X_SEQUENCE_NUMBER in NUMBER,
   X_TAB_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_TABS_B SET
     tab_value = x_tab_value,
     NAVIGATOR_type = X_NAVIGATOR_TYPE,
     APPLICATION_ID = X_APPLICATION_ID,
     ICON_NAME = X_ICON_NAME,
     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 TAB_id = X_TAB_id;

Line: 108

  update JTF_NAV_TABS_TL set
    TAB_LABEL = X_TAB_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 TAB_id = X_TAB_id
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 120

end UPDATE_ROW;

Line: 131

     SELECT tab_value, APPLICATION_ID, ICON_NAME,
       sequence_number, navigator_type
       FROM JTF_NAV_TABS_B
       WHERE TAB_id = X_TAB_id
       FOR UPDATE OF TAB_ID nowait;

Line: 138

  cursor c1 is select
      TAB_LABEL,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from JTF_NAV_TABS_TL
    where TAB_id = X_TAB_id
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of TAB_id nowait;

Line: 150

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

Line: 181

procedure DELETE_ROW (X_TAB_id in NUMBER) IS
begin
  delete from JTF_NAV_TABS_TL
  where TAB_id = X_TAB_id;

Line: 190

  delete from JTF_NAV_TABS_B
  where TAB_id = X_TAB_id;

Line: 196

end DELETE_ROW;

Line: 201

  delete from JTF_NAV_TABS_TL T
  where not exists
    (select NULL
    from JTF_NAV_TABS_B B
    where B.TAB_id = T.TAB_id
    );

Line: 208

  update JTF_NAV_TABS_TL T set (
      TAB_LABEL
    ) = (select
      B.TAB_LABEL
    from JTF_NAV_TABS_TL B
    where B.TAB_id = T.TAB_id
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.TAB_id,
      T.LANGUAGE
  ) in (select
      SUBT.TAB_id,
      SUBT.LANGUAGE
    from JTF_NAV_TABS_TL SUBB, JTF_NAV_TABS_TL SUBT
    where SUBB.TAB_id = SUBT.TAB_id
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.TAB_LABEL <> SUBT.TAB_LABEL
  ));

Line: 227

  insert into JTF_NAV_TABS_TL (
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATE_LOGIN,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    TAB_id,
    TAB_LABEL,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.CREATED_BY,
    B.CREATION_DATE,
    B.LAST_UPDATE_LOGIN,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.TAB_id,
    B.TAB_LABEL,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from JTF_NAV_TABS_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_TABS_TL T
    where T.TAB_id = B.TAB_id
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 290

   UPDATE  jtf_nav_tabs_b SET
     navigator_type = x_navigator_type,
     application_id = x_application_id,
     icon_name = x_icon_name,
     sequence_number = x_sequence_number,
     last_update_date = sysdate,
     last_updated_by = user_id,
     last_update_login = 0
     WHERE tab_value = x_tab_value;

Line: 302

      SELECT jtf_nav_tabs_s.nextval
        INTO l_tab_id
        FROM dual;

Line: 306

      INSERT INTO jtf_nav_tabs_b
        (tab_id,
        tab_value,
        navigator_type,
        application_id,
        icon_name,
        sequence_number,
        creation_date,
        created_by,
        last_update_date,
        last_updated_by,
        last_update_login
        ) VALUES
        (l_tab_id,
        x_tab_value,
        x_navigator_type,
        x_application_id,
        x_icon_name,
        x_sequence_number,
        sysdate,
        user_id,
        sysdate,
        user_id,
        0
        );

Line: 333

   SELECT tab_id
     INTO l_tab_id
     FROM jtf_nav_tabs_b
     WHERE tab_value = x_tab_value;

Line: 339

   UPDATE jtf_nav_tabs_tl SET
     tab_label = x_tab_label,
     last_update_date = sysdate,
     last_updated_by = user_id,
     last_update_login = 0,
     source_lang = userenv('LANG')
     WHERE tab_id = l_tab_id
     AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);

Line: 350

      INSERT INTO jtf_nav_tabs_tl
        (tab_id,
         tab_label,
         creation_date,
         created_by,
         last_update_date,
         last_updated_by,
         last_update_login,
         language,
         source_lang)
        SELECT
        l_tab_id,
        x_tab_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_tabs_tl t
         WHERE t.tab_id = l_tab_id
         AND t.language = l.language_code);

Line: 410

   SELECT tab_id
     INTO l_tab_id
     FROM jtf_nav_tabs_b
     WHERE tab_value = x_tab_value;

Line: 416

   UPDATE jtf_nav_tabs_tl SET
     tab_label = x_tab_label,
     last_update_date = sysdate,
     last_updated_by = user_id,
     last_update_login = 0,
     source_lang = userenv('LANG')
     WHERE tab_id = l_tab_id
     AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);