APPS.FND_ID_FLEX_SEGMENTS_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_APPLICATION_ID in NUMBER,
  X_ID_FLEX_CODE in VARCHAR2,
  X_ID_FLEX_NUM in NUMBER,
  X_APPLICATION_COLUMN_NAME in VARCHAR2,
  X_ADDITIONAL_WHERE_CLAUSE in VARCHAR2,
  X_SEGMENT_NAME in VARCHAR2,
  X_SEGMENT_NUM in NUMBER,
  X_APPLICATION_COLUMN_INDEX_FLA in VARCHAR2,
  X_ENABLED_FLAG in VARCHAR2,
  X_REQUIRED_FLAG in VARCHAR2,
  X_DISPLAY_FLAG in VARCHAR2,
  X_DISPLAY_SIZE in NUMBER,
  X_SECURITY_ENABLED_FLAG in VARCHAR2,
  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_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
  cursor C is select ROWID from FND_ID_FLEX_SEGMENTS
    where APPLICATION_ID = X_APPLICATION_ID
    and ID_FLEX_CODE = X_ID_FLEX_CODE
    and ID_FLEX_NUM = X_ID_FLEX_NUM
    and APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME
    ;

Line: 41

  insert into FND_ID_FLEX_SEGMENTS (
    ADDITIONAL_WHERE_CLAUSE,
    APPLICATION_ID,
    ID_FLEX_CODE,
    ID_FLEX_NUM,
    APPLICATION_COLUMN_NAME,
    SEGMENT_NAME,
    SEGMENT_NUM,
    APPLICATION_COLUMN_INDEX_FLAG,
    ENABLED_FLAG,
    REQUIRED_FLAG,
    DISPLAY_FLAG,
    DISPLAY_SIZE,
    SECURITY_ENABLED_FLAG,
    MAXIMUM_DESCRIPTION_LEN,
    CONCATENATION_DESCRIPTION_LEN,
    FLEX_VALUE_SET_ID,
    RANGE_CODE,
    DEFAULT_TYPE,
    DEFAULT_VALUE,
    RUNTIME_PROPERTY_FUNCTION,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_ADDITIONAL_WHERE_CLAUSE,
    X_APPLICATION_ID,
    X_ID_FLEX_CODE,
    X_ID_FLEX_NUM,
    X_APPLICATION_COLUMN_NAME,
    X_SEGMENT_NAME,
    X_SEGMENT_NUM,
    X_APPLICATION_COLUMN_INDEX_FLA,
    X_ENABLED_FLAG,
    X_REQUIRED_FLAG,
    X_DISPLAY_FLAG,
    X_DISPLAY_SIZE,
    X_SECURITY_ENABLED_FLAG,
    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_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 95

  insert into FND_ID_FLEX_SEGMENTS_TL (
    APPLICATION_ID,
    ID_FLEX_CODE,
    ID_FLEX_NUM,
    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_ID_FLEX_CODE,
    X_ID_FLEX_NUM,
    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_ID_FLEX_SEGMENTS_TL T
    where T.APPLICATION_ID = X_APPLICATION_ID
    and T.ID_FLEX_CODE = X_ID_FLEX_CODE
    and T.ID_FLEX_NUM = X_ID_FLEX_NUM
    and T.APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 144

end INSERT_ROW;

Line: 171

  cursor c is select
      ADDITIONAL_WHERE_CLAUSE,
      SEGMENT_NAME,
      SEGMENT_NUM,
      APPLICATION_COLUMN_INDEX_FLAG,
      ENABLED_FLAG,
      REQUIRED_FLAG,
      DISPLAY_FLAG,
      DISPLAY_SIZE,
      SECURITY_ENABLED_FLAG,
      MAXIMUM_DESCRIPTION_LEN,
      CONCATENATION_DESCRIPTION_LEN,
      FLEX_VALUE_SET_ID,
      RANGE_CODE,
      DEFAULT_TYPE,
      DEFAULT_VALUE,
      RUNTIME_PROPERTY_FUNCTION
    from FND_ID_FLEX_SEGMENTS
    where APPLICATION_ID = X_APPLICATION_ID
    and ID_FLEX_CODE = X_ID_FLEX_CODE
    and ID_FLEX_NUM = X_ID_FLEX_NUM
    and APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME
    for update of APPLICATION_ID nowait;

Line: 196

  cursor c1 is select
      FORM_LEFT_PROMPT,
      FORM_ABOVE_PROMPT,
      DESCRIPTION,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from FND_ID_FLEX_SEGMENTS_TL
    where APPLICATION_ID = X_APPLICATION_ID
    and ID_FLEX_CODE = X_ID_FLEX_CODE
    and ID_FLEX_NUM = X_ID_FLEX_NUM
    and APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of APPLICATION_ID nowait;

Line: 213

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

Line: 263

procedure UPDATE_ROW (
  X_APPLICATION_ID in NUMBER,
  X_ID_FLEX_CODE in VARCHAR2,
  X_ID_FLEX_NUM in NUMBER,
  X_APPLICATION_COLUMN_NAME in VARCHAR2,
  X_ADDITIONAL_WHERE_CLAUSE in VARCHAR2,
  X_SEGMENT_NAME in VARCHAR2,
  X_SEGMENT_NUM in NUMBER,
  X_APPLICATION_COLUMN_INDEX_FLA in VARCHAR2,
  X_ENABLED_FLAG in VARCHAR2,
  X_REQUIRED_FLAG in VARCHAR2,
  X_DISPLAY_FLAG in VARCHAR2,
  X_DISPLAY_SIZE in NUMBER,
  X_SECURITY_ENABLED_FLAG in VARCHAR2,
  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_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_ID_FLEX_SEGMENTS set
    ADDITIONAL_WHERE_CLAUSE = X_ADDITIONAL_WHERE_CLAUSE,
    SEGMENT_NAME = X_SEGMENT_NAME,
    SEGMENT_NUM = X_SEGMENT_NUM,
    APPLICATION_COLUMN_INDEX_FLAG = X_APPLICATION_COLUMN_INDEX_FLA,
    ENABLED_FLAG = X_ENABLED_FLAG,
    REQUIRED_FLAG = X_REQUIRED_FLAG,
    DISPLAY_FLAG = X_DISPLAY_FLAG,
    DISPLAY_SIZE = X_DISPLAY_SIZE,
    SECURITY_ENABLED_FLAG = X_SECURITY_ENABLED_FLAG,
    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,
    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 ID_FLEX_CODE = X_ID_FLEX_CODE
  and ID_FLEX_NUM = X_ID_FLEX_NUM
  and APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME;

Line: 321

  update FND_ID_FLEX_SEGMENTS_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 ID_FLEX_CODE = X_ID_FLEX_CODE
  and ID_FLEX_NUM = X_ID_FLEX_NUM
  and APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 338

end UPDATE_ROW;

Line: 340

procedure DELETE_ROW (
  X_APPLICATION_ID in NUMBER,
  X_ID_FLEX_CODE in VARCHAR2,
  X_ID_FLEX_NUM in NUMBER,
  X_APPLICATION_COLUMN_NAME in VARCHAR2
) is
begin
  delete from FND_ID_FLEX_SEGMENTS_TL
  where APPLICATION_ID = X_APPLICATION_ID
  and ID_FLEX_CODE = X_ID_FLEX_CODE
  and ID_FLEX_NUM = X_ID_FLEX_NUM
  and APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME;

Line: 357

  delete from FND_ID_FLEX_SEGMENTS
  where APPLICATION_ID = X_APPLICATION_ID
  and ID_FLEX_CODE = X_ID_FLEX_CODE
  and ID_FLEX_NUM = X_ID_FLEX_NUM
  and APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME;

Line: 370

  update fnd_flex_validation_rules
  set ERROR_SEGMENT_COLUMN_NAME=NULL
  where APPLICATION_ID = X_APPLICATION_ID
  and ID_FLEX_CODE = X_ID_FLEX_CODE
  and ID_FLEX_NUM = X_ID_FLEX_NUM
  and ERROR_SEGMENT_COLUMN_NAME=X_APPLICATION_COLUMN_NAME;

Line: 380

end DELETE_ROW;

Line: 386

/* 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_ID_FLEX_SEGMENTS_TL T
   where not exists
     (select NULL
     from FND_ID_FLEX_SEGMENTS B
     where B.APPLICATION_ID = T.APPLICATION_ID
     and B.ID_FLEX_CODE = T.ID_FLEX_CODE
     and B.ID_FLEX_NUM = T.ID_FLEX_NUM
     and B.APPLICATION_COLUMN_NAME = T.APPLICATION_COLUMN_NAME
     );

Line: 401

   update FND_ID_FLEX_SEGMENTS_TL T set (
       FORM_LEFT_PROMPT,
       FORM_ABOVE_PROMPT,
       DESCRIPTION
     ) = (select
       B.FORM_LEFT_PROMPT,
       B.FORM_ABOVE_PROMPT,
       B.DESCRIPTION
     from FND_ID_FLEX_SEGMENTS_TL B
     where B.APPLICATION_ID = T.APPLICATION_ID
     and B.ID_FLEX_CODE = T.ID_FLEX_CODE
     and B.ID_FLEX_NUM = T.ID_FLEX_NUM
     and B.APPLICATION_COLUMN_NAME = T.APPLICATION_COLUMN_NAME
     and B.LANGUAGE = T.SOURCE_LANG)
   where (
       T.APPLICATION_ID,
       T.ID_FLEX_CODE,
       T.ID_FLEX_NUM,
       T.APPLICATION_COLUMN_NAME,
       T.LANGUAGE
   ) in (select
       SUBT.APPLICATION_ID,
       SUBT.ID_FLEX_CODE,
       SUBT.ID_FLEX_NUM,
       SUBT.APPLICATION_COLUMN_NAME,
       SUBT.LANGUAGE
     from FND_ID_FLEX_SEGMENTS_TL SUBB, FND_ID_FLEX_SEGMENTS_TL SUBT
     where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
     and SUBB.ID_FLEX_CODE = SUBT.ID_FLEX_CODE
     and SUBB.ID_FLEX_NUM = SUBT.ID_FLEX_NUM
     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: 441

  insert into FND_ID_FLEX_SEGMENTS_TL (
    APPLICATION_ID,
    ID_FLEX_CODE,
    ID_FLEX_NUM,
    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 /*+ ORDERED */
    B.APPLICATION_ID,
    B.ID_FLEX_CODE,
    B.ID_FLEX_NUM,
    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_ID_FLEX_SEGMENTS_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from FND_ID_FLEX_SEGMENTS_TL T
    where T.APPLICATION_ID = B.APPLICATION_ID
    and T.ID_FLEX_CODE = B.ID_FLEX_CODE
    and T.ID_FLEX_NUM = B.ID_FLEX_NUM
    and T.APPLICATION_COLUMN_NAME = B.APPLICATION_COLUMN_NAME
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 516

   SELECT application_id
     INTO l_application_id
     FROM fnd_application
     WHERE application_short_name = x_application_short_name;

Line: 521

   SELECT id_flex_code
     INTO l_id_flex_code
     FROM fnd_id_flexs
     WHERE application_id = l_application_id
     AND id_flex_code = x_id_flex_code;

Line: 527

   SELECT id_flex_num
     INTO l_id_flex_num
     FROM fnd_id_flex_structures
     WHERE application_id = l_application_id
     AND id_flex_code = l_id_flex_code
     AND id_flex_structure_code = x_id_flex_structure_code;

Line: 535

      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: 542

      fnd_id_flex_segments_pkg.update_row
        (X_APPLICATION_ID               => l_application_id,
         X_ID_FLEX_CODE                 => l_id_flex_code,
         X_ID_FLEX_NUM                  => l_id_flex_num,
         X_APPLICATION_COLUMN_NAME      => x_application_column_name,
         X_SEGMENT_NAME                 => x_segment_name,
         X_SEGMENT_NUM                  => x_segment_num,
	 X_APPLICATION_COLUMN_INDEX_FLA => x_application_column_index_fla,
         X_ENABLED_FLAG                 => x_enabled_flag,
         X_REQUIRED_FLAG                => x_required_flag,
         X_DISPLAY_FLAG                 => x_display_flag,
         X_DISPLAY_SIZE                 => x_display_size,
         X_SECURITY_ENABLED_FLAG        => x_security_enabled_flag,
         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_ADDITIONAL_WHERE_CLAUSE      => x_additional_where_clause,
         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: 571

	 fnd_id_flex_segments_pkg.insert_row
	   (X_ROWID                        => l_rowid,
	    X_APPLICATION_ID               => l_application_id,
	    X_ID_FLEX_CODE                 => l_id_flex_code,
	    X_ID_FLEX_NUM                  => l_id_flex_num,
	    X_APPLICATION_COLUMN_NAME      => x_application_column_name,
	    X_SEGMENT_NAME                 => x_segment_name,
	    X_SEGMENT_NUM                  => x_segment_num,
	    X_APPLICATION_COLUMN_INDEX_FLA => x_application_column_index_fla,
	    X_ENABLED_FLAG                 => x_enabled_flag,
	    X_REQUIRED_FLAG                => x_required_flag,
	    X_DISPLAY_FLAG                 => x_display_flag,
	    X_DISPLAY_SIZE                 => x_display_size,
	    X_SECURITY_ENABLED_FLAG        => x_security_enabled_flag,
	    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_ADDITIONAL_WHERE_CLAUSE      => x_additional_where_clause,
	    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: 615

   UPDATE fnd_id_flex_segments_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, id_flex_code, id_flex_num) =
	    (SELECT application_id, id_flex_code, id_flex_num
	     FROM fnd_id_flex_structures
	     WHERE (application_id =
		    (SELECT application_id
		     FROM fnd_application
		     WHERE application_short_name = x_application_short_name))
	     AND id_flex_code = x_id_flex_code
	     AND id_flex_structure_code = x_id_flex_structure_code))
     AND application_column_name = x_application_column_name
     AND userenv('LANG') in (language, source_lang);