APPS.FND_DESCR_FLEX_COL_USAGE_PKG SQL Statements

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

Line: 4

procedure INSERT_ROW (
  X_ROWID in out nocopy VARCHAR2,
  X_APPLICATION_ID in NUMBER,
  X_DESCRIPTIVE_FLEXFIELD_NAME in VARCHAR2,
  X_DESCRIPTIVE_FLEX_CONTEXT_COD in VARCHAR2,
  X_APPLICATION_COLUMN_NAME in VARCHAR2,
  X_END_USER_COLUMN_NAME in VARCHAR2,
  X_COLUMN_SEQ_NUM in NUMBER,
  X_ENABLED_FLAG in VARCHAR2,
  X_REQUIRED_FLAG in VARCHAR2,
  X_SECURITY_ENABLED_FLAG in VARCHAR2,
  X_DISPLAY_FLAG in VARCHAR2,
  X_DISPLAY_SIZE in NUMBER,
  X_MAXIMUM_DESCRIPTION_LEN in NUMBER,
  X_CONCATENATION_DESCRIPTION_LE in NUMBER,
  X_FLEX_VALUE_SET_ID in NUMBER,
  X_RANGE_CODE in VARCHAR2,
  X_DEFAULT_TYPE in VARCHAR2,
  X_DEFAULT_VALUE in VARCHAR2,
  X_RUNTIME_PROPERTY_FUNCTION in VARCHAR2,
  X_SRW_PARAM in VARCHAR2,
  X_FORM_LEFT_PROMPT in VARCHAR2,
  X_FORM_ABOVE_PROMPT 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
    l_application_column_name     VARCHAR2(30);

Line: 36

  cursor C is select ROWID from FND_DESCR_FLEX_COLUMN_USAGES
    where APPLICATION_ID = X_APPLICATION_ID
    and DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME
    and DESCRIPTIVE_FLEX_CONTEXT_CODE = X_DESCRIPTIVE_FLEX_CONTEXT_COD
    and APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME
    ;

Line: 44

/* Bug 1732116 - Remove row level delete of report parameters from here. */

  insert into FND_DESCR_FLEX_COLUMN_USAGES (
    APPLICATION_ID,
    DESCRIPTIVE_FLEXFIELD_NAME,
    DESCRIPTIVE_FLEX_CONTEXT_CODE,
    APPLICATION_COLUMN_NAME,
    END_USER_COLUMN_NAME,
    COLUMN_SEQ_NUM,
    ENABLED_FLAG,
    REQUIRED_FLAG,
    SECURITY_ENABLED_FLAG,
    DISPLAY_FLAG,
    DISPLAY_SIZE,
    MAXIMUM_DESCRIPTION_LEN,
    CONCATENATION_DESCRIPTION_LEN,
    FLEX_VALUE_SET_ID,
    RANGE_CODE,
    DEFAULT_TYPE,
    DEFAULT_VALUE,
    RUNTIME_PROPERTY_FUNCTION,
    SRW_PARAM,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_APPLICATION_ID,
    X_DESCRIPTIVE_FLEXFIELD_NAME,
    X_DESCRIPTIVE_FLEX_CONTEXT_COD,
    X_APPLICATION_COLUMN_NAME,
    X_END_USER_COLUMN_NAME,
    X_COLUMN_SEQ_NUM,
    X_ENABLED_FLAG,
    X_REQUIRED_FLAG,
    X_SECURITY_ENABLED_FLAG,
    X_DISPLAY_FLAG,
    X_DISPLAY_SIZE,
    X_MAXIMUM_DESCRIPTION_LEN,
    X_CONCATENATION_DESCRIPTION_LE,
    X_FLEX_VALUE_SET_ID,
    X_RANGE_CODE,
    X_DEFAULT_TYPE,
    X_DEFAULT_VALUE,
    X_RUNTIME_PROPERTY_FUNCTION,
    X_SRW_PARAM,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 98

  insert into FND_DESCR_FLEX_COL_USAGE_TL (
    APPLICATION_ID,
    DESCRIPTIVE_FLEXFIELD_NAME,
    DESCRIPTIVE_FLEX_CONTEXT_CODE,
    APPLICATION_COLUMN_NAME,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    FORM_LEFT_PROMPT,
    FORM_ABOVE_PROMPT,
    DESCRIPTION,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_APPLICATION_ID,
    X_DESCRIPTIVE_FLEXFIELD_NAME,
    X_DESCRIPTIVE_FLEX_CONTEXT_COD,
    X_APPLICATION_COLUMN_NAME,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_FORM_LEFT_PROMPT,
    X_FORM_ABOVE_PROMPT,
    X_DESCRIPTION,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from FND_DESCR_FLEX_COL_USAGE_TL T
    where T.APPLICATION_ID = X_APPLICATION_ID
    and T.DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME
    and T.DESCRIPTIVE_FLEX_CONTEXT_CODE = X_DESCRIPTIVE_FLEX_CONTEXT_COD
    and T.APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 147

end INSERT_ROW;

Line: 173

  cursor c is select
      END_USER_COLUMN_NAME,
      COLUMN_SEQ_NUM,
      ENABLED_FLAG,
      REQUIRED_FLAG,
      SECURITY_ENABLED_FLAG,
      DISPLAY_FLAG,
      DISPLAY_SIZE,
      MAXIMUM_DESCRIPTION_LEN,
      CONCATENATION_DESCRIPTION_LEN,
      FLEX_VALUE_SET_ID,
      RANGE_CODE,
      DEFAULT_TYPE,
      DEFAULT_VALUE,
      RUNTIME_PROPERTY_FUNCTION,
      SRW_PARAM
    from FND_DESCR_FLEX_COLUMN_USAGES
    where APPLICATION_ID = X_APPLICATION_ID
    and DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME
    and DESCRIPTIVE_FLEX_CONTEXT_CODE = X_DESCRIPTIVE_FLEX_CONTEXT_COD
    and APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME
    for update of APPLICATION_ID nowait;

Line: 197

  cursor c1 is select
      FORM_LEFT_PROMPT,
      FORM_ABOVE_PROMPT,
      DESCRIPTION,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from FND_DESCR_FLEX_COL_USAGE_TL
    where APPLICATION_ID = X_APPLICATION_ID
    and DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME
    and DESCRIPTIVE_FLEX_CONTEXT_CODE = X_DESCRIPTIVE_FLEX_CONTEXT_COD
    and APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of APPLICATION_ID nowait;

Line: 214

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

Line: 263

procedure UPDATE_ROW (
  X_APPLICATION_ID in NUMBER,
  X_DESCRIPTIVE_FLEXFIELD_NAME in VARCHAR2,
  X_DESCRIPTIVE_FLEX_CONTEXT_COD in VARCHAR2,
  X_APPLICATION_COLUMN_NAME in VARCHAR2,
  X_END_USER_COLUMN_NAME in VARCHAR2,
  X_COLUMN_SEQ_NUM in NUMBER,
  X_ENABLED_FLAG in VARCHAR2,
  X_REQUIRED_FLAG in VARCHAR2,
  X_SECURITY_ENABLED_FLAG in VARCHAR2,
  X_DISPLAY_FLAG in VARCHAR2,
  X_DISPLAY_SIZE in NUMBER,
  X_MAXIMUM_DESCRIPTION_LEN in NUMBER,
  X_CONCATENATION_DESCRIPTION_LE in NUMBER,
  X_FLEX_VALUE_SET_ID in NUMBER,
  X_RANGE_CODE in VARCHAR2,
  X_DEFAULT_TYPE in VARCHAR2,
  X_DEFAULT_VALUE in VARCHAR2,
  X_RUNTIME_PROPERTY_FUNCTION in VARCHAR2,
  X_SRW_PARAM in VARCHAR2,
  X_FORM_LEFT_PROMPT in VARCHAR2,
  X_FORM_ABOVE_PROMPT 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 FND_DESCR_FLEX_COLUMN_USAGES set
    END_USER_COLUMN_NAME = X_END_USER_COLUMN_NAME,
    COLUMN_SEQ_NUM = X_COLUMN_SEQ_NUM,
    ENABLED_FLAG = X_ENABLED_FLAG,
    REQUIRED_FLAG = X_REQUIRED_FLAG,
    SECURITY_ENABLED_FLAG = X_SECURITY_ENABLED_FLAG,
    DISPLAY_FLAG = X_DISPLAY_FLAG,
    DISPLAY_SIZE = X_DISPLAY_SIZE,
    MAXIMUM_DESCRIPTION_LEN = X_MAXIMUM_DESCRIPTION_LEN,
    CONCATENATION_DESCRIPTION_LEN = X_CONCATENATION_DESCRIPTION_LE,
    FLEX_VALUE_SET_ID = X_FLEX_VALUE_SET_ID,
    RANGE_CODE = X_RANGE_CODE,
    DEFAULT_TYPE = X_DEFAULT_TYPE,
    DEFAULT_VALUE = X_DEFAULT_VALUE,
    RUNTIME_PROPERTY_FUNCTION = X_RUNTIME_PROPERTY_FUNCTION,
    SRW_PARAM = X_SRW_PARAM,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where APPLICATION_ID = X_APPLICATION_ID
  and DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME
  and DESCRIPTIVE_FLEX_CONTEXT_CODE = X_DESCRIPTIVE_FLEX_CONTEXT_COD
  and APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME;

Line: 319

  update FND_DESCR_FLEX_COL_USAGE_TL set
    FORM_LEFT_PROMPT = X_FORM_LEFT_PROMPT,
    FORM_ABOVE_PROMPT = X_FORM_ABOVE_PROMPT,
    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 APPLICATION_ID = X_APPLICATION_ID
  and DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME
  and DESCRIPTIVE_FLEX_CONTEXT_CODE = X_DESCRIPTIVE_FLEX_CONTEXT_COD
  and APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 336

end UPDATE_ROW;

Line: 338

procedure DELETE_ROW (
  X_APPLICATION_ID in NUMBER,
  X_DESCRIPTIVE_FLEXFIELD_NAME in VARCHAR2,
  X_DESCRIPTIVE_FLEX_CONTEXT_COD in VARCHAR2,
  X_APPLICATION_COLUMN_NAME in VARCHAR2
) is
begin
  delete from FND_DESCR_FLEX_COL_USAGE_TL
  where APPLICATION_ID = X_APPLICATION_ID
  and DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME
  and DESCRIPTIVE_FLEX_CONTEXT_CODE = X_DESCRIPTIVE_FLEX_CONTEXT_COD
  and APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME;

Line: 355

  delete from FND_DESCR_FLEX_COLUMN_USAGES
  where APPLICATION_ID = X_APPLICATION_ID
  and DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME
  and DESCRIPTIVE_FLEX_CONTEXT_CODE = X_DESCRIPTIVE_FLEX_CONTEXT_COD
  and APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME;

Line: 364

end DELETE_ROW;

Line: 371

/* The following delete and update statements are commented out */
/* as a quick workaround to fix the time-consuming table handler issue */
/* Eventually we'll need to turn them into a separate fix_language procedure */
/*
   delete from FND_DESCR_FLEX_COL_USAGE_TL T
   where not exists
     (select NULL
     from FND_DESCR_FLEX_COLUMN_USAGES B
     where B.APPLICATION_ID = T.APPLICATION_ID
     and B.DESCRIPTIVE_FLEXFIELD_NAME = T.DESCRIPTIVE_FLEXFIELD_NAME
     and B.DESCRIPTIVE_FLEX_CONTEXT_CODE = T.DESCRIPTIVE_FLEX_CONTEXT_CODE
     and B.APPLICATION_COLUMN_NAME = T.APPLICATION_COLUMN_NAME
     );

Line: 385

   update FND_DESCR_FLEX_COL_USAGE_TL T set (
       FORM_LEFT_PROMPT,
       FORM_ABOVE_PROMPT,
       DESCRIPTION
     ) = (select
       B.FORM_LEFT_PROMPT,
       B.FORM_ABOVE_PROMPT,
       B.DESCRIPTION
     from FND_DESCR_FLEX_COL_USAGE_TL B
     where B.APPLICATION_ID = T.APPLICATION_ID
     and B.DESCRIPTIVE_FLEXFIELD_NAME = T.DESCRIPTIVE_FLEXFIELD_NAME
     and B.DESCRIPTIVE_FLEX_CONTEXT_CODE = T.DESCRIPTIVE_FLEX_CONTEXT_CODE
     and B.APPLICATION_COLUMN_NAME = T.APPLICATION_COLUMN_NAME
     and B.LANGUAGE = T.SOURCE_LANG)
   where (
       T.APPLICATION_ID,
       T.DESCRIPTIVE_FLEXFIELD_NAME,
       T.DESCRIPTIVE_FLEX_CONTEXT_CODE,
       T.APPLICATION_COLUMN_NAME,
       T.LANGUAGE
   ) in (select
       SUBT.APPLICATION_ID,
       SUBT.DESCRIPTIVE_FLEXFIELD_NAME,
       SUBT.DESCRIPTIVE_FLEX_CONTEXT_CODE,
       SUBT.APPLICATION_COLUMN_NAME,
       SUBT.LANGUAGE
     from FND_DESCR_FLEX_COL_USAGE_TL SUBB, FND_DESCR_FLEX_COL_USAGE_TL SUBT
     where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
     and SUBB.DESCRIPTIVE_FLEXFIELD_NAME = SUBT.DESCRIPTIVE_FLEXFIELD_NAME
     and SUBB.DESCRIPTIVE_FLEX_CONTEXT_CODE = SUBT.DESCRIPTIVE_FLEX_CONTEXT_CODE
     and SUBB.APPLICATION_COLUMN_NAME = SUBT.APPLICATION_COLUMN_NAME
     and SUBB.LANGUAGE = SUBT.SOURCE_LANG
     and (SUBB.FORM_LEFT_PROMPT <> SUBT.FORM_LEFT_PROMPT
       or SUBB.FORM_ABOVE_PROMPT <> SUBT.FORM_ABOVE_PROMPT
       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: 425

   insert /*+ append parallel(tt) */ into FND_DESCR_FLEX_COL_USAGE_TL tt (
     APPLICATION_ID,
     DESCRIPTIVE_FLEXFIELD_NAME,
     DESCRIPTIVE_FLEX_CONTEXT_CODE,
     APPLICATION_COLUMN_NAME,
     LAST_UPDATE_DATE,
     LAST_UPDATED_BY,
     CREATION_DATE,
     CREATED_BY,
     LAST_UPDATE_LOGIN,
     FORM_LEFT_PROMPT,
     FORM_ABOVE_PROMPT,
     DESCRIPTION,
     LANGUAGE,
     SOURCE_LANG
   )
     select /*+ parallel(v) parallel(t) use_nl(t)  */ v.* from
        (select /*+ no_merge ordered parallel(b) */
     B.APPLICATION_ID,
     B.DESCRIPTIVE_FLEXFIELD_NAME,
     B.DESCRIPTIVE_FLEX_CONTEXT_CODE,
     B.APPLICATION_COLUMN_NAME,
     B.LAST_UPDATE_DATE,
     B.LAST_UPDATED_BY,
     B.CREATION_DATE,
     B.CREATED_BY,
     B.LAST_UPDATE_LOGIN,
     B.FORM_LEFT_PROMPT,
     B.FORM_ABOVE_PROMPT,
     B.DESCRIPTION,
     L.LANGUAGE_CODE,
     B.SOURCE_LANG
   from FND_DESCR_FLEX_COL_USAGE_TL B, FND_LANGUAGES L
   where L.INSTALLED_FLAG in ('I', 'B')
   and B.LANGUAGE = userenv('LANG')
   ) v, FND_DESCR_FLEX_COL_USAGE_TL t
   where t.application_id(+) = v.application_id
   and t.descriptive_flexfield_name(+) =  v.descriptive_flexfield_name
   and t.descriptive_flex_context_code(+) =  v.descriptive_flex_context_code
   and t.application_column_name(+) =  v.application_column_name
   and t.language(+) = v.language_code
   and t.application_id is NULL
   and t.descriptive_flexfield_name is NULL
   and t.descriptive_flex_context_code is NULL
   and t.application_column_name is NULL;

Line: 503

   SELECT application_id
     INTO l_application_id
     FROM fnd_application
     WHERE application_short_name = x_application_short_name;

Line: 508

   SELECT descriptive_flexfield_name
     INTO l_vc2
     FROM fnd_descriptive_flexs
     WHERE application_id = l_application_id
     AND descriptive_flexfield_name = x_descriptive_flexfield_name;

Line: 514

   SELECT descriptive_flex_context_code
     INTO l_vc2
     FROM fnd_descr_flex_contexts
     WHERE application_id = l_application_id
     AND descriptive_flexfield_name = x_descriptive_flexfield_name
     AND descriptive_flex_context_code = x_descriptive_flex_context_cod;

Line: 522

      SELECT flex_value_set_id
        INTO l_flex_value_set_id
        FROM fnd_flex_value_sets
        WHERE flex_value_set_name = x_flex_value_set_name;

Line: 529

      fnd_descr_flex_col_usage_pkg.update_row
        (X_APPLICATION_ID               => l_application_id,
         X_DESCRIPTIVE_FLEXFIELD_NAME   => x_descriptive_flexfield_name,
         X_DESCRIPTIVE_FLEX_CONTEXT_COD => x_descriptive_flex_context_cod,
         X_APPLICATION_COLUMN_NAME      => x_application_column_name,
         X_END_USER_COLUMN_NAME         => x_end_user_column_name,
         X_COLUMN_SEQ_NUM               => x_column_seq_num,
         X_ENABLED_FLAG                 => x_enabled_flag,
         X_REQUIRED_FLAG                => x_required_flag,
         X_SECURITY_ENABLED_FLAG        => x_security_enabled_flag,
         X_DISPLAY_FLAG                 => x_display_flag,
         X_DISPLAY_SIZE                 => x_display_size,
         X_MAXIMUM_DESCRIPTION_LEN      => x_maximum_description_len,
         X_CONCATENATION_DESCRIPTION_LE => x_concatenation_description_le,
         X_FLEX_VALUE_SET_ID            => l_flex_value_set_id,
         X_RANGE_CODE                   => x_range_code,
         X_DEFAULT_TYPE                 => x_default_type,
         X_DEFAULT_VALUE                => x_default_value,
         X_RUNTIME_PROPERTY_FUNCTION    => x_runtime_property_function,
         X_SRW_PARAM                    => x_srw_param,
         X_FORM_LEFT_PROMPT             => x_form_left_prompt,
         X_FORM_ABOVE_PROMPT            => x_form_above_prompt,
         X_DESCRIPTION                  => x_description,
         X_LAST_UPDATE_DATE             => x_who.last_update_date,
         X_LAST_UPDATED_BY              => x_who.last_updated_by,
         X_LAST_UPDATE_LOGIN            => x_who.last_update_login);

Line: 557

         fnd_descr_flex_col_usage_pkg.insert_row
           (X_ROWID                        => l_rowid,
            X_APPLICATION_ID               => l_application_id,
            X_DESCRIPTIVE_FLEXFIELD_NAME   => x_descriptive_flexfield_name,
            X_DESCRIPTIVE_FLEX_CONTEXT_COD => x_descriptive_flex_context_cod,
            X_APPLICATION_COLUMN_NAME      => x_application_column_name,
            X_END_USER_COLUMN_NAME         => x_end_user_column_name,
            X_COLUMN_SEQ_NUM               => x_column_seq_num,
            X_ENABLED_FLAG                 => x_enabled_flag,
            X_REQUIRED_FLAG                => x_required_flag,
            X_SECURITY_ENABLED_FLAG        => x_security_enabled_flag,
            X_DISPLAY_FLAG                 => x_display_flag,
            X_DISPLAY_SIZE                 => x_display_size,
            X_MAXIMUM_DESCRIPTION_LEN      => x_maximum_description_len,
            X_CONCATENATION_DESCRIPTION_LE => x_concatenation_description_le,
            X_FLEX_VALUE_SET_ID            => l_flex_value_set_id,
            X_RANGE_CODE                   => x_range_code,
            X_DEFAULT_TYPE                 => x_default_type,
            X_DEFAULT_VALUE                => x_default_value,
            X_RUNTIME_PROPERTY_FUNCTION    => x_runtime_property_function,
            X_SRW_PARAM                    => x_srw_param,
            X_FORM_LEFT_PROMPT             => x_form_left_prompt,
            X_FORM_ABOVE_PROMPT            => x_form_above_prompt,
            X_DESCRIPTION                  => x_description,
            X_CREATION_DATE                => x_who.creation_date,
            X_CREATED_BY                   => x_who.created_by,
            X_LAST_UPDATE_DATE             => x_who.last_update_date,
            X_LAST_UPDATED_BY              => x_who.last_updated_by,
            X_LAST_UPDATE_LOGIN            => x_who.last_update_login);

Line: 600

   UPDATE fnd_descr_flex_col_usage_tl SET
     form_left_prompt  = Nvl(x_form_left_prompt, form_left_prompt),
     form_above_prompt = Nvl(x_form_above_prompt, form_above_prompt),
     description       = Nvl(x_description, description),
     last_update_date  = x_who.last_update_date,
     last_updated_by   = x_who.last_updated_by,
     last_update_login = x_who.last_update_login,
     source_lang       = userenv('LANG')
     WHERE application_id = (SELECT application_id
                             FROM fnd_application
                             WHERE application_short_name = x_application_short_name)
     AND descriptive_flexfield_name = x_descriptive_flexfield_name
     AND descriptive_flex_context_code = x_descriptive_flex_context_cod
     AND application_column_name = x_application_column_name
     AND userenv('LANG') in (language, source_lang);