APPS.FND_DESCRIPTIVE_FLEXS_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_CONCATENATED_SEGS_VIEW_NAME in VARCHAR2,
  X_APPLICATION_TABLE_NAME in VARCHAR2,
  X_TABLE_APPLICATION_ID in NUMBER,
  X_CONTEXT_REQUIRED_FLAG in VARCHAR2,
  X_CONTEXT_COLUMN_NAME in VARCHAR2,
  X_CONTEXT_USER_OVERRIDE_FLAG in VARCHAR2,
  X_CONCATENATED_SEGMENT_DELIMIT in VARCHAR2,
  X_FREEZE_FLEX_DEFINITION_FLAG in VARCHAR2,
  X_PROTECTED_FLAG in VARCHAR2,
  X_DEFAULT_CONTEXT_FIELD_NAME in VARCHAR2,
  X_DEFAULT_CONTEXT_VALUE in VARCHAR2,
  X_CONTEXT_DEFAULT_TYPE in VARCHAR2,
  X_CONTEXT_DEFAULT_VALUE in VARCHAR2,
  X_CONTEXT_OVERRIDE_VALUE_SET_I in NUMBER,
  X_CONTEXT_RUNTIME_PROPERTY_FUN in VARCHAR2,
  X_CONTEXT_SYNCHRONIZATION_FLAG in VARCHAR2 DEFAULT NULL,
  X_TITLE in VARCHAR2,
  X_FORM_CONTEXT_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
  cursor C is select ROWID from FND_DESCRIPTIVE_FLEXS
    where APPLICATION_ID = X_APPLICATION_ID
    and DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME
    ;

Line: 49

  insert into FND_DESCRIPTIVE_FLEXS (
    CONCATENATED_SEGS_VIEW_NAME,
    APPLICATION_ID,
    APPLICATION_TABLE_NAME,
    DESCRIPTIVE_FLEXFIELD_NAME,
    TABLE_APPLICATION_ID,
    CONTEXT_REQUIRED_FLAG,
    CONTEXT_COLUMN_NAME,
    CONTEXT_USER_OVERRIDE_FLAG,
    CONCATENATED_SEGMENT_DELIMITER,
    FREEZE_FLEX_DEFINITION_FLAG,
    PROTECTED_FLAG,
    DEFAULT_CONTEXT_FIELD_NAME,
    DEFAULT_CONTEXT_VALUE,
    CONTEXT_DEFAULT_TYPE,
    CONTEXT_DEFAULT_VALUE,
    CONTEXT_OVERRIDE_VALUE_SET_ID,
    CONTEXT_RUNTIME_PROPERTY_FUNCT,
    CONTEXT_SYNCHRONIZATION_FLAG,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_CONCATENATED_SEGS_VIEW_NAME,
    X_APPLICATION_ID,
    X_APPLICATION_TABLE_NAME,
    X_DESCRIPTIVE_FLEXFIELD_NAME,
    X_TABLE_APPLICATION_ID,
    X_CONTEXT_REQUIRED_FLAG,
    X_CONTEXT_COLUMN_NAME,
    X_CONTEXT_USER_OVERRIDE_FLAG,
    X_CONCATENATED_SEGMENT_DELIMIT,
    X_FREEZE_FLEX_DEFINITION_FLAG,
    X_PROTECTED_FLAG,
    X_DEFAULT_CONTEXT_FIELD_NAME,
    X_DEFAULT_CONTEXT_VALUE,
    X_CONTEXT_DEFAULT_TYPE,
    X_CONTEXT_DEFAULT_VALUE,
    X_CONTEXT_OVERRIDE_VALUE_SET_I,
    X_CONTEXT_RUNTIME_PROPERTY_FUN,
    l_context_synchronization_flag,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 99

  insert into FND_DESCRIPTIVE_FLEXS_TL (
    APPLICATION_ID,
    DESCRIPTIVE_FLEXFIELD_NAME,
    TITLE,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    FORM_CONTEXT_PROMPT,
    DESCRIPTION,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_APPLICATION_ID,
    X_DESCRIPTIVE_FLEXFIELD_NAME,
    X_TITLE,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_FORM_CONTEXT_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_DESCRIPTIVE_FLEXS_TL T
    where T.APPLICATION_ID = X_APPLICATION_ID
    and T.DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 142

end INSERT_ROW;

Line: 167

  cursor c is select
      CONCATENATED_SEGS_VIEW_NAME,
      APPLICATION_TABLE_NAME,
      TABLE_APPLICATION_ID,
      CONTEXT_REQUIRED_FLAG,
      CONTEXT_COLUMN_NAME,
      CONTEXT_USER_OVERRIDE_FLAG,
      CONCATENATED_SEGMENT_DELIMITER,
      FREEZE_FLEX_DEFINITION_FLAG,
      PROTECTED_FLAG,
      DEFAULT_CONTEXT_FIELD_NAME,
      DEFAULT_CONTEXT_VALUE,
      CONTEXT_DEFAULT_TYPE,
      CONTEXT_DEFAULT_VALUE,
      CONTEXT_OVERRIDE_VALUE_SET_ID,
      CONTEXT_RUNTIME_PROPERTY_FUNCT,
      CONTEXT_SYNCHRONIZATION_FLAG
    from FND_DESCRIPTIVE_FLEXS
    where APPLICATION_ID = X_APPLICATION_ID
    and DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME
    for update of APPLICATION_ID nowait;

Line: 190

  cursor c1 is select
      TITLE,
      FORM_CONTEXT_PROMPT,
      DESCRIPTION,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from FND_DESCRIPTIVE_FLEXS_TL
    where APPLICATION_ID = X_APPLICATION_ID
    and DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of APPLICATION_ID nowait;

Line: 205

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

Line: 257

procedure UPDATE_ROW (
  X_APPLICATION_ID in NUMBER,
  X_DESCRIPTIVE_FLEXFIELD_NAME in VARCHAR2,
  X_CONCATENATED_SEGS_VIEW_NAME in VARCHAR2,
  X_APPLICATION_TABLE_NAME in VARCHAR2,
  X_TABLE_APPLICATION_ID in NUMBER,
  X_CONTEXT_REQUIRED_FLAG in VARCHAR2,
  X_CONTEXT_COLUMN_NAME in VARCHAR2,
  X_CONTEXT_USER_OVERRIDE_FLAG in VARCHAR2,
  X_CONCATENATED_SEGMENT_DELIMIT in VARCHAR2,
  X_FREEZE_FLEX_DEFINITION_FLAG in VARCHAR2,
  X_PROTECTED_FLAG in VARCHAR2,
  X_DEFAULT_CONTEXT_FIELD_NAME in VARCHAR2,
  X_DEFAULT_CONTEXT_VALUE in VARCHAR2,
  X_CONTEXT_DEFAULT_TYPE in VARCHAR2,
  X_CONTEXT_DEFAULT_VALUE in VARCHAR2,
  X_CONTEXT_OVERRIDE_VALUE_SET_I in NUMBER,
  X_CONTEXT_RUNTIME_PROPERTY_FUN in VARCHAR2,
  X_CONTEXT_SYNCHRONIZATION_FLAG in VARCHAR2 DEFAULT NULL,
  X_TITLE in VARCHAR2,
  X_FORM_CONTEXT_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
  l_context_synchronization_flag	VARCHAR2(1);

Line: 294

  update FND_DESCRIPTIVE_FLEXS set
    CONCATENATED_SEGS_VIEW_NAME = X_CONCATENATED_SEGS_VIEW_NAME,
    APPLICATION_TABLE_NAME = X_APPLICATION_TABLE_NAME,
    TABLE_APPLICATION_ID = X_TABLE_APPLICATION_ID,
    CONTEXT_REQUIRED_FLAG = X_CONTEXT_REQUIRED_FLAG,
    CONTEXT_COLUMN_NAME = X_CONTEXT_COLUMN_NAME,
    CONTEXT_USER_OVERRIDE_FLAG = X_CONTEXT_USER_OVERRIDE_FLAG,
    CONCATENATED_SEGMENT_DELIMITER = X_CONCATENATED_SEGMENT_DELIMIT,
    FREEZE_FLEX_DEFINITION_FLAG = X_FREEZE_FLEX_DEFINITION_FLAG,
    PROTECTED_FLAG = X_PROTECTED_FLAG,
    DEFAULT_CONTEXT_FIELD_NAME = X_DEFAULT_CONTEXT_FIELD_NAME,
    DEFAULT_CONTEXT_VALUE = X_DEFAULT_CONTEXT_VALUE,
    CONTEXT_DEFAULT_TYPE = X_CONTEXT_DEFAULT_TYPE,
    CONTEXT_DEFAULT_VALUE = X_CONTEXT_DEFAULT_VALUE,
    CONTEXT_OVERRIDE_VALUE_SET_ID = X_CONTEXT_OVERRIDE_VALUE_SET_I,
    CONTEXT_RUNTIME_PROPERTY_FUNCT = X_CONTEXT_RUNTIME_PROPERTY_FUN,
    CONTEXT_SYNCHRONIZATION_FLAG = l_context_synchronization_flag,
    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;

Line: 321

  update FND_DESCRIPTIVE_FLEXS_TL set
    TITLE = X_TITLE,
    FORM_CONTEXT_PROMPT = X_FORM_CONTEXT_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 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
) is
begin
  delete from FND_DESCRIPTIVE_FLEXS_TL
  where APPLICATION_ID = X_APPLICATION_ID
  and DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME;

Line: 351

  delete from FND_DESCRIPTIVE_FLEXS
  where APPLICATION_ID = X_APPLICATION_ID
  and DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME;

Line: 358

end DELETE_ROW;

Line: 365

/* 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_DESCRIPTIVE_FLEXS_TL T
   where not exists
     (select NULL
     from FND_DESCRIPTIVE_FLEXS B
     where B.APPLICATION_ID = T.APPLICATION_ID
     and B.DESCRIPTIVE_FLEXFIELD_NAME = T.DESCRIPTIVE_FLEXFIELD_NAME
     );

Line: 377

   update FND_DESCRIPTIVE_FLEXS_TL T set (
       TITLE,
       FORM_CONTEXT_PROMPT,
       DESCRIPTION
     ) = (select
       B.TITLE,
       B.FORM_CONTEXT_PROMPT,
       B.DESCRIPTION
     from FND_DESCRIPTIVE_FLEXS_TL B
     where B.APPLICATION_ID = T.APPLICATION_ID
     and B.DESCRIPTIVE_FLEXFIELD_NAME = T.DESCRIPTIVE_FLEXFIELD_NAME
     and B.LANGUAGE = T.SOURCE_LANG)
   where (
       T.APPLICATION_ID,
       T.DESCRIPTIVE_FLEXFIELD_NAME,
       T.LANGUAGE
   ) in (select
       SUBT.APPLICATION_ID,
       SUBT.DESCRIPTIVE_FLEXFIELD_NAME,
       SUBT.LANGUAGE
     from FND_DESCRIPTIVE_FLEXS_TL SUBB, FND_DESCRIPTIVE_FLEXS_TL SUBT
     where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
     and SUBB.DESCRIPTIVE_FLEXFIELD_NAME = SUBT.DESCRIPTIVE_FLEXFIELD_NAME
     and SUBB.LANGUAGE = SUBT.SOURCE_LANG
     and (SUBB.TITLE <> SUBT.TITLE
       or SUBB.FORM_CONTEXT_PROMPT <> SUBT.FORM_CONTEXT_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: 409

  insert into FND_DESCRIPTIVE_FLEXS_TL (
    APPLICATION_ID,
    DESCRIPTIVE_FLEXFIELD_NAME,
    TITLE,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    FORM_CONTEXT_PROMPT,
    DESCRIPTION,
    LANGUAGE,
    SOURCE_LANG
  ) select /*+ ORDERED */
    B.APPLICATION_ID,
    B.DESCRIPTIVE_FLEXFIELD_NAME,
    B.TITLE,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.CREATION_DATE,
    B.CREATED_BY,
    B.LAST_UPDATE_LOGIN,
    B.FORM_CONTEXT_PROMPT,
    B.DESCRIPTION,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from FND_DESCRIPTIVE_FLEXS_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from FND_DESCRIPTIVE_FLEXS_TL T
    where T.APPLICATION_ID = B.APPLICATION_ID
    and T.DESCRIPTIVE_FLEXFIELD_NAME = B.DESCRIPTIVE_FLEXFIELD_NAME
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 475

   SELECT application_id
     INTO l_application_id
     FROM fnd_application
     WHERE application_short_name = x_application_short_name;

Line: 480

   SELECT application_id
     INTO l_table_application_id
     FROM fnd_application
     WHERE application_short_name = x_table_application_short_name;

Line: 486

      SELECT flex_value_set_id
	INTO l_context_override_value_set_i
	FROM fnd_flex_value_sets
	WHERE flex_value_set_name = x_context_override_value_set_n;

Line: 493

      fnd_descriptive_flexs_pkg.update_row
	(X_APPLICATION_ID               => l_application_id,
	 X_DESCRIPTIVE_FLEXFIELD_NAME   => x_descriptive_flexfield_name,
	 X_APPLICATION_TABLE_NAME       => x_application_table_name,
	 X_TABLE_APPLICATION_ID         => l_table_application_id,
         X_CONCATENATED_SEGS_VIEW_NAME  => x_concatenated_segs_view_name,
	 X_CONTEXT_REQUIRED_FLAG        => x_context_required_flag,
	 X_CONTEXT_COLUMN_NAME          => x_context_column_name,
	 X_CONTEXT_USER_OVERRIDE_FLAG   => x_context_user_override_flag,
	 X_CONCATENATED_SEGMENT_DELIMIT => x_concatenated_segment_delimit,
	 X_FREEZE_FLEX_DEFINITION_FLAG  => x_freeze_flex_definition_flag,
	 X_PROTECTED_FLAG               => x_protected_flag,
	 X_DEFAULT_CONTEXT_FIELD_NAME   => x_default_context_field_name,
	 X_DEFAULT_CONTEXT_VALUE        => x_default_context_value,
	 X_CONTEXT_DEFAULT_TYPE         => x_context_default_type,
	 X_CONTEXT_DEFAULT_VALUE        => x_context_default_value,
	 X_CONTEXT_OVERRIDE_VALUE_SET_I => l_context_override_value_set_i,
	 X_CONTEXT_RUNTIME_PROPERTY_FUN => x_context_runtime_property_fun,
	 X_CONTEXT_SYNCHRONIZATION_FLAG => x_context_synchronization_flag,
	 X_TITLE                        => x_title,
	 X_FORM_CONTEXT_PROMPT          => x_form_context_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: 520

	 fnd_descriptive_flexs_pkg.insert_row
	   (X_ROWID                        => l_rowid,
	    X_APPLICATION_ID               => l_application_id,
	    X_DESCRIPTIVE_FLEXFIELD_NAME   => x_descriptive_flexfield_name,
	    X_APPLICATION_TABLE_NAME       => x_application_table_name,
	    X_TABLE_APPLICATION_ID         => l_table_application_id,
            X_CONCATENATED_SEGS_VIEW_NAME  => x_concatenated_segs_view_name,
	    X_CONTEXT_REQUIRED_FLAG        => x_context_required_flag,
	    X_CONTEXT_COLUMN_NAME          => x_context_column_name,
	    X_CONTEXT_USER_OVERRIDE_FLAG   => x_context_user_override_flag,
	    X_CONCATENATED_SEGMENT_DELIMIT => x_concatenated_segment_delimit,
	    X_FREEZE_FLEX_DEFINITION_FLAG  => x_freeze_flex_definition_flag,
	    X_PROTECTED_FLAG               => x_protected_flag,
	    X_DEFAULT_CONTEXT_FIELD_NAME   => x_default_context_field_name,
	    X_DEFAULT_CONTEXT_VALUE        => x_default_context_value,
	    X_CONTEXT_DEFAULT_TYPE         => x_context_default_type,
	    X_CONTEXT_DEFAULT_VALUE        => x_context_default_value,
	    X_CONTEXT_OVERRIDE_VALUE_SET_I => l_context_override_value_set_i,
	    X_CONTEXT_RUNTIME_PROPERTY_FUN => x_context_runtime_property_fun,
	    X_CONTEXT_SYNCHRONIZATION_FLAG => x_context_synchronization_flag,
	    X_TITLE                        => x_title,
	    X_FORM_CONTEXT_PROMPT          => x_form_context_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: 560

   UPDATE fnd_descriptive_flexs_tl SET
     title               = Nvl(x_title, title),
     form_context_prompt = Nvl(x_form_context_prompt, form_context_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 userenv('LANG') in (language, source_lang);