APPS.JTF_GRID_DATASOURCES_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_GRID_DATASOURCE_NAME in VARCHAR2,
  X_DB_VIEW_NAME in VARCHAR2,
  X_APPLICATION_ID in NUMBER,
  X_DEFAULT_ROW_HEIGHT in NUMBER,
  X_MAX_QUERIED_ROWS in NUMBER,
  X_WHERE_CLAUSE in VARCHAR2,
  X_ALT_COLOR_CODE in VARCHAR2,
  X_ALT_COLOR_INTERVAL in NUMBER,
  X_TITLE_TEXT 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,
  X_FETCH_SIZE in NUMBER
) is
  cursor C is select ROWID from JTF_GRID_DATASOURCES_B
    where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME
    ;

Line: 25

  insert into JTF_GRID_DATASOURCES_B (
    GRID_DATASOURCE_NAME,
    DB_VIEW_NAME,
    APPLICATION_ID,
    DEFAULT_ROW_HEIGHT,
    MAX_QUERIED_ROWS,
    WHERE_CLAUSE,
    ALT_COLOR_CODE,
    ALT_COLOR_INTERVAL,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    FETCH_SIZE
  ) values (
    X_GRID_DATASOURCE_NAME,
    X_DB_VIEW_NAME,
    X_APPLICATION_ID,
    X_DEFAULT_ROW_HEIGHT,
    X_MAX_QUERIED_ROWS,
    X_WHERE_CLAUSE,
    X_ALT_COLOR_CODE,
    X_ALT_COLOR_INTERVAL,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_FETCH_SIZE
  );

Line: 57

  insert into JTF_GRID_DATASOURCES_TL (
    GRID_DATASOURCE_NAME,
    TITLE_TEXT,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_GRID_DATASOURCE_NAME,
    X_TITLE_TEXT,
    X_CREATED_BY,
    X_CREATION_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    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 JTF_GRID_DATASOURCES_TL T
    where T.GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 93

end INSERT_ROW;

Line: 107

  cursor c is select
      DB_VIEW_NAME,
      APPLICATION_ID,
      DEFAULT_ROW_HEIGHT,
      MAX_QUERIED_ROWS,
      WHERE_CLAUSE,
      ALT_COLOR_CODE,
      ALT_COLOR_INTERVAL,
      FETCH_SIZE
    from JTF_GRID_DATASOURCES_B
    where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME
    for update of GRID_DATASOURCE_NAME nowait;

Line: 121

  cursor c1 is select
      TITLE_TEXT,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from JTF_GRID_DATASOURCES_TL
    where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of GRID_DATASOURCE_NAME nowait;

Line: 133

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

Line: 171

procedure UPDATE_ROW (
  X_GRID_DATASOURCE_NAME in VARCHAR2,
  X_DB_VIEW_NAME in VARCHAR2,
  X_APPLICATION_ID in NUMBER,
  X_DEFAULT_ROW_HEIGHT in NUMBER,
  X_MAX_QUERIED_ROWS in NUMBER,
  X_WHERE_CLAUSE in VARCHAR2,
  X_ALT_COLOR_CODE in VARCHAR2,
  X_ALT_COLOR_INTERVAL in NUMBER,
  X_TITLE_TEXT in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_FETCH_SIZE in NUMBER
) is
begin
  update JTF_GRID_DATASOURCES_B set
    DB_VIEW_NAME = X_DB_VIEW_NAME,
    APPLICATION_ID = X_APPLICATION_ID,
    DEFAULT_ROW_HEIGHT = X_DEFAULT_ROW_HEIGHT,
    MAX_QUERIED_ROWS = X_MAX_QUERIED_ROWS,
    WHERE_CLAUSE = X_WHERE_CLAUSE,
    ALT_COLOR_CODE = X_ALT_COLOR_CODE,
    ALT_COLOR_INTERVAL = X_ALT_COLOR_INTERVAL,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    FETCH_SIZE = X_FETCH_SIZE
  where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME;

Line: 203

  update JTF_GRID_DATASOURCES_TL set
    TITLE_TEXT = X_TITLE_TEXT,
    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 GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 215

end UPDATE_ROW;

Line: 220

This procedure delete the metadata definition without deleting the customization data

This procedure should be invoked only from the LOAD_ROW procedure which will re-load the metadata
definition.
*/

procedure DELETE_ROW_PRESERVE_CUSTOM(
  X_GRID_DATASOURCE_NAME in VARCHAR2
) is
  cursor sort_cols(x_grid_datasource_name in varchar2) is
    select 'X'
    from jtf_grid_sort_cols
    where grid_datasource_name = x_grid_datasource_name;

Line: 238

    delete from JTF_GRID_SORT_COLS
    where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME;

Line: 242

  delete from JTF_GRID_DATASOURCES_TL
  where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME;

Line: 245

  delete from JTF_GRID_DATASOURCES_B
  where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME;

Line: 248

  delete from JTF_GRID_COLS_TL
  where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME ;

Line: 251

  delete from JTF_GRID_COLS_B
  where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME ;

Line: 257

end DELETE_ROW_PRESERVE_CUSTOM;

Line: 259

procedure DELETE_ROW (
  X_GRID_DATASOURCE_NAME in VARCHAR2
) is
  l_custom_grid_id jtf_custom_grids.custom_grid_id%TYPE;

Line: 265

    select custom_grid_id
    from jtf_custom_grids
    where grid_datasource_name = x_grid_datasource_name;

Line: 270

    select 'X'
    from jtf_grid_sort_cols
    where grid_datasource_name = x_grid_datasource_name;

Line: 280

    delete from JTF_CUSTOM_BIND_VALUES
    where CUSTOM_GRID_ID = l_custom_grid_id;

Line: 286

  delete from JTF_DEF_CUSTOM_GRIDS
  where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME;

Line: 289

  delete from JTF_CUSTOM_GRIDS
  where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME;

Line: 293

    delete from JTF_GRID_SORT_COLS
    where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME;

Line: 297

  delete from JTF_GRID_DATASOURCES_TL
  where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME;

Line: 300

  delete from JTF_GRID_DATASOURCES_B
  where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME;

Line: 306

end DELETE_ROW;

Line: 311

  delete from JTF_GRID_DATASOURCES_TL T
  where not exists
    (select NULL
    from JTF_GRID_DATASOURCES_B B
    where B.GRID_DATASOURCE_NAME = T.GRID_DATASOURCE_NAME
    );

Line: 318

  update JTF_GRID_DATASOURCES_TL T set (
      TITLE_TEXT
    ) = (select
      B.TITLE_TEXT
    from JTF_GRID_DATASOURCES_TL B
    where B.GRID_DATASOURCE_NAME = T.GRID_DATASOURCE_NAME
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.GRID_DATASOURCE_NAME,
      T.LANGUAGE
  ) in (select
      SUBT.GRID_DATASOURCE_NAME,
      SUBT.LANGUAGE
    from JTF_GRID_DATASOURCES_TL SUBB, JTF_GRID_DATASOURCES_TL SUBT
    where SUBB.GRID_DATASOURCE_NAME = SUBT.GRID_DATASOURCE_NAME
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.TITLE_TEXT <> SUBT.TITLE_TEXT
  ));

Line: 337

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

Line: 380

  X_LAST_UPDATE_DATE in VARCHAR2
) is
  row_id      varchar2(64);

Line: 385

  f_ludate  date;    -- entity update date in file

Line: 387

  db_ludate date;    -- entity update date in db

Line: 390

    select APPLICATION_ID
    into owner_appid
    from FND_APPLICATION
    where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME;

Line: 400

        f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);

Line: 404

          select LAST_UPDATED_BY, LAST_UPDATE_DATE
          into db_luby, db_ludate
          from JTF_GRID_DATASOURCES_B
          where GRID_DATASOURCE_NAME = x_grid_datasource_name;

Line: 417

            delete_row_preserve_custom(x_grid_datasource_name);

Line: 419

            INSERT_ROW (X_ROWID => row_id
                       ,X_GRID_DATASOURCE_NAME => X_GRID_DATASOURCE_NAME
                       ,X_DB_VIEW_NAME => X_DB_VIEW_NAME
                       ,X_APPLICATION_ID => owner_appid
                       ,X_DEFAULT_ROW_HEIGHT => X_DEFAULT_ROW_HEIGHT
                       ,X_MAX_QUERIED_ROWS => X_MAX_QUERIED_ROWS
                       ,X_WHERE_CLAUSE => X_WHERE_CLAUSE
                       ,X_ALT_COLOR_CODE => X_ALT_COLOR_CODE
                       ,X_ALT_COLOR_INTERVAL => X_ALT_COLOR_INTERVAL
                       ,X_TITLE_TEXT => X_TITLE_TEXT
                       ,X_CREATION_DATE => f_ludate
                       ,X_CREATED_BY => f_luby
                       ,X_LAST_UPDATE_DATE => f_ludate
                       ,X_LAST_UPDATED_BY => f_luby
                       ,X_LAST_UPDATE_LOGIN => 0
                       ,X_FETCH_SIZE => X_FETCH_SIZE);

Line: 436

    UPDATE_ROW (X_GRID_DATASOURCE_NAME => X_GRID_DATASOURCE_NAME
    ,X_DB_VIEW_NAME => X_DB_VIEW_NAME
    ,X_APPLICATION_ID => owner_appid
    ,X_DEFAULT_ROW_HEIGHT => X_DEFAULT_ROW_HEIGHT
    ,X_MAX_QUERIED_ROWS => X_MAX_QUERIED_ROWS
    ,X_WHERE_CLAUSE => X_WHERE_CLAUSE
    ,X_ALT_COLOR_CODE => X_ALT_COLOR_CODE
    ,X_ALT_COLOR_INTERVAL => X_ALT_COLOR_INTERVAL
    ,X_TITLE_TEXT => X_TITLE_TEXT
    ,X_LAST_UPDATE_DATE => f_ludate
    ,X_LAST_UPDATED_BY =>  f_luby
    ,X_LAST_UPDATE_LOGIN => 0
    ,X_FETCH_SIZE => X_FETCH_SIZE);

Line: 456

            INSERT_ROW (X_ROWID => row_id
                       ,X_GRID_DATASOURCE_NAME => X_GRID_DATASOURCE_NAME
                       ,X_DB_VIEW_NAME => X_DB_VIEW_NAME
                       ,X_APPLICATION_ID => owner_appid
                       ,X_DEFAULT_ROW_HEIGHT => X_DEFAULT_ROW_HEIGHT
                       ,X_MAX_QUERIED_ROWS => X_MAX_QUERIED_ROWS
                       ,X_WHERE_CLAUSE => X_WHERE_CLAUSE
                       ,X_ALT_COLOR_CODE => X_ALT_COLOR_CODE
                       ,X_ALT_COLOR_INTERVAL => X_ALT_COLOR_INTERVAL
                       ,X_TITLE_TEXT => X_TITLE_TEXT
                       ,X_CREATION_DATE => f_ludate
                       ,X_CREATED_BY => f_luby
                       ,X_LAST_UPDATE_DATE => f_ludate
                       ,X_LAST_UPDATED_BY => f_luby
                       ,X_LAST_UPDATE_LOGIN => 0
                       ,X_FETCH_SIZE => X_FETCH_SIZE);

Line: 481

  X_LAST_UPDATE_DATE in VARCHAR2
) is

  f_luby    number;  -- entity owner in file

Line: 485

  f_ludate  date;    -- entity update date in file

Line: 487

  db_ludate date;    -- entity update date in db

Line: 495

    f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);

Line: 498

    select LAST_UPDATED_BY, LAST_UPDATE_DATE
    into db_luby, db_ludate
    from JTF_GRID_DATASOURCES_TL
    where GRID_DATASOURCE_NAME = x_grid_datasource_name
    and LANGUAGE = userenv('LANG');

Line: 509

         update JTF_GRID_DATASOURCES_TL
         set TITLE_TEXT = X_TITLE_TEXT
            ,LAST_UPDATE_DATE = f_ludate
            ,LAST_UPDATED_BY = f_luby
            ,LAST_UPDATE_LOGIN = 0
            ,SOURCE_LANG = userenv('LANG')
         where userenv('LANG') in (LANGUAGE,SOURCE_LANG)
         and GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME;

Line: 528

  SELECT COUNT(1)
  INTO DUMMY
  FROM jtf_grid_datasources_vl
  WHERE grid_datasource_name = X_GRID_DATASOURCE_NAME
  AND ((X_ROWID IS NULL) OR (ROWID <> X_ROWID));

Line: 551

 l_last_updated_by number;

Line: 558

    select last_updated_by
    into l_last_updated_by
    from jtf_grid_datasources_b
    where grid_datasource_name = p_datasource_name;

Line: 563

    if l_last_updated_by <> p_owner then
       return FALSE;

Line: 569

       select 'x'
       into l_custom_exists
       from jtf_custom_grids
       where grid_Datasource_name = p_datasource_name;