APPS.CLN_CH_DISPLAY_LABELS_DTL_PKG SQL Statements

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

Line: 22

   UPDATE CLN_CH_DISPLAY_LABELS_DTL_TL SET
     GUID          = X_GUID,
  DISPLAY_LABEL= X_DISPLAY_LABEL,
     LAST_UPDATE_DATE           = sysdate,
     LAST_UPDATED_BY            = Decode(X_OWNER, 'SEED', 1, 0),
     LAST_UPDATE_LOGIN          = 0,
     SOURCE_LANG                = userenv('LANG')
     WHERE GUID   = X_GUID AND userenv('LANG') IN (language, source_lang);

Line: 46

    cursor c is select * from CLN_CH_DISPLAY_LABELS_HDR where GUID=X_PARENT_GUID;

Line: 47

    cursor c1 is select * from CLN_CH_DISPLAY_LABELS_DTL_B where (PARENT_GUID=X_PARENT_GUID)
AND (GUID=X_GUID);

Line: 58

     select sysdate into l_sysdate from dual;

Line: 64

  UPDATE CLN_CH_DISPLAY_LABELS_DTL_B SET
             CLN_COLUMNS=X_CLN_COLUMNS,
             SEARCH_ENABLED=X_SEARCH_ENABLED,
             DISPLAY_ENABLED_EVENTS_SCREEN=X_DISPLAY_ENABLED_EVENTS_SCR,
             DISPLAY_ENABLED_RESULTS_TABLE=X_DISPLAY_ENABLED_RESULTS_TBL,
             LAST_UPDATE_DATE=l_sysdate,
             LAST_UPDATED_BY=l_user_id,
             LAST_UPDATE_LOGIN=0
                         WHERE  GUID= X_GUID and PARENT_GUID= X_PARENT_GUID;

Line: 73

   UPDATE CLN_CH_DISPLAY_LABELS_DTL_TL SET
            DISPLAY_LABEL=X_DISPLAY_LABEL,
             LAST_UPDATE_DATE=l_sysdate,
             LAST_UPDATED_BY=l_user_id,
             LAST_UPDATE_LOGIN=0,
           SOURCE_LANG=userenv('LANG')
       WHERE GUID = X_GUID and userenv('LANG') in (LANGUAGE,SOURCE_LANG) ;

Line: 82

       Insert into  CLN_CH_DISPLAY_LABELS_DTL_B(
             GUID,
             PARENT_GUID,
             CLN_COLUMNS,
             SEARCH_ENABLED,
             DISPLAY_ENABLED_EVENTS_SCREEN,
             DISPLAY_ENABLED_RESULTS_TABLE,
                         CREATION_DATE,
                         CREATED_BY,
             LAST_UPDATE_DATE,
             LAST_UPDATED_BY,
             LAST_UPDATE_LOGIN)
            values(
            X_GUID,
            X_PARENT_GUID,
            X_CLN_COLUMNS,
     X_SEARCH_ENABLED,
            X_DISPLAY_ENABLED_EVENTS_SCR,
            X_DISPLAY_ENABLED_RESULTS_TBL,
            l_sysdate,
            l_user_id,
            l_sysdate,
            l_user_id,
            0);

Line: 106

  INSERT into CLN_CH_DISPLAY_LABELS_DTL_TL(
       GUID,
       DISPLAY_LABEL,
       CREATION_DATE,
       CREATED_BY,
       LAST_UPDATE_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_LOGIN,
       LANGUAGE,
        SOURCE_LANG
       )select
             X_GUID,
             X_DISPLAY_LABEL,
            l_sysdate,
             l_user_id,
             l_sysdate,
             l_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 CLN_CH_DISPLAY_LABELS_DTL_TL T
                         where T.GUID = X_GUID
                         and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 140

procedure INSERT_ROW (
  X_ROWID in out nocopy VARCHAR2,
  X_GUID in RAW,
  X_PARENT_GUID in RAW,
  X_CLN_COLUMNS in VARCHAR2,
  X_SEARCH_ENABLED in VARCHAR2,
  X_DISPLAY_ENABLED_EVENTS_SCREE in VARCHAR2,
  X_DISPLAY_ENABLED_RESULTS_TABL in VARCHAR2,
  X_DISPLAY_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
  cursor C is select ROWID from CLN_CH_DISPLAY_LABELS_DTL_B
    where GUID = X_GUID
    ;

Line: 159

  insert into CLN_CH_DISPLAY_LABELS_DTL_B (
    GUID,
    PARENT_GUID,
    CLN_COLUMNS,
    SEARCH_ENABLED,
    DISPLAY_ENABLED_EVENTS_SCREEN,
    DISPLAY_ENABLED_RESULTS_TABLE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_GUID,
    X_PARENT_GUID,
    X_CLN_COLUMNS,
    X_SEARCH_ENABLED,
    X_DISPLAY_ENABLED_EVENTS_SCREE,
    X_DISPLAY_ENABLED_RESULTS_TABL,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 185

  insert into CLN_CH_DISPLAY_LABELS_DTL_TL (
    GUID,
    DISPLAY_LABEL,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_GUID,
    X_DISPLAY_LABEL,
    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 CLN_CH_DISPLAY_LABELS_DTL_TL T
    where T.GUID = X_GUID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 221

end INSERT_ROW;

Line: 232

  cursor c is select
      PARENT_GUID,
      CLN_COLUMNS,
      SEARCH_ENABLED,
      DISPLAY_ENABLED_EVENTS_SCREEN,
      DISPLAY_ENABLED_RESULTS_TABLE
    from CLN_CH_DISPLAY_LABELS_DTL_B
    where GUID = X_GUID
    for update of GUID nowait;

Line: 243

  cursor c1 is select
      DISPLAY_LABEL,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from CLN_CH_DISPLAY_LABELS_DTL_TL
    where GUID = X_GUID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of GUID nowait;

Line: 255

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

Line: 290

procedure UPDATE_ROW (
  X_GUID in RAW,
  X_PARENT_GUID in RAW,
  X_CLN_COLUMNS in VARCHAR2,
  X_SEARCH_ENABLED in VARCHAR2,
  X_DISPLAY_ENABLED_EVENTS_SCREE in VARCHAR2,
  X_DISPLAY_ENABLED_RESULTS_TABL in VARCHAR2,
  X_DISPLAY_LABEL in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update CLN_CH_DISPLAY_LABELS_DTL_B set
    PARENT_GUID = X_PARENT_GUID,
    CLN_COLUMNS = X_CLN_COLUMNS,
    SEARCH_ENABLED = X_SEARCH_ENABLED,
    DISPLAY_ENABLED_EVENTS_SCREEN = X_DISPLAY_ENABLED_EVENTS_SCREE,
    DISPLAY_ENABLED_RESULTS_TABLE = X_DISPLAY_ENABLED_RESULTS_TABL,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where GUID = X_GUID;

Line: 318

  update CLN_CH_DISPLAY_LABELS_DTL_TL set
    DISPLAY_LABEL = X_DISPLAY_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 GUID = X_GUID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 330

end UPDATE_ROW;

Line: 332

procedure DELETE_ROW (
  X_GUID in RAW
) is
begin
  delete from CLN_CH_DISPLAY_LABELS_DTL_TL
  where GUID = X_GUID;

Line: 343

  delete from CLN_CH_DISPLAY_LABELS_DTL_B
  where GUID = X_GUID;

Line: 349

end DELETE_ROW;

Line: 354

  delete from CLN_CH_DISPLAY_LABELS_DTL_TL T
  where not exists
    (select NULL
    from CLN_CH_DISPLAY_LABELS_DTL_B B
    where B.GUID = T.GUID
    );

Line: 361

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

Line: 382

  insert into CLN_CH_DISPLAY_LABELS_DTL_TL (
    GUID,
    DISPLAY_LABEL,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select /*+ ORDERED */
    B.GUID,
    B.DISPLAY_LABEL,
    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 CLN_CH_DISPLAY_LABELS_DTL_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from CLN_CH_DISPLAY_LABELS_DTL_TL T
    where T.GUID = B.GUID
    and T.LANGUAGE = L.LANGUAGE_CODE);