APPS.AK_ATTRIBUTE_PVT SQL Statements

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

Line: 106

  /*** from UPDATE procedure, the columns are not missing            ***/
  if ((p_bold is null) or
      (p_bold = FND_API.G_MISS_CHAR and
       p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
    l_error := TRUE;

Line: 120

       p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
    l_error := TRUE;

Line: 131

       p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
  then
    l_error := TRUE;

Line: 143

       p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
  then
    l_error := TRUE;

Line: 155

       p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
    l_error := TRUE;

Line: 166

       p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
    l_error := TRUE;

Line: 344

    select 1
    from  AK_ATTRIBUTES
    where attribute_application_id = p_attribute_application_id
    and   attribute_code = p_attribute_code;

Line: 466

  p_last_updated_by	     IN      NUMBER := FND_API.G_MISS_NUM,
  p_last_update_date	     IN      DATE := FND_API.G_MISS_DATE,
  p_last_update_login	     IN      NUMBER := FND_API.G_MISS_NUM,
  p_loader_timestamp         IN      DATE := FND_API.G_MISS_DATE,
  p_pass                     IN      NUMBER,
  p_copy_redo_flag           IN OUT NOCOPY  BOOLEAN
) is
  l_api_version_number     CONSTANT number := 1.0;

Line: 502

  l_last_update_date       date;

Line: 503

  l_last_update_login      number;

Line: 504

  l_last_updated_by        number;

Line: 538

/* now if we hit that error the exception handling calls update_attribute */
/* --
  -- check to see if row already exists
  --
  if AK_ATTRIBUTE_PVT.ATTRIBUTE_EXISTS (
         p_api_version_number => 1.0,
         p_return_status => l_return_status,
         p_attribute_application_id => p_attribute_application_id,
         p_attribute_code => p_attribute_code) then
    if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
      FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_EXISTS');

Line: 622

	  -- insert the record
      if (p_pass = 1) then
        p_copy_redo_flag := TRUE;

Line: 788

  if (p_last_updated_by <> FND_API.G_MISS_NUM) then
    l_last_updated_by := p_last_updated_by;

Line: 792

  if (p_last_update_date <> FND_API.G_MISS_DATE) then
    l_last_update_date := p_last_update_date;

Line: 796

  if (p_last_update_login <> FND_API.G_MISS_NUM) then
    l_last_update_login := p_last_update_login;

Line: 808

  if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
       p_loader_timestamp => p_loader_timestamp,
       p_created_by => l_created_by,
       p_creation_date => l_creation_date,
       p_last_updated_by => l_last_updated_by,
       p_db_last_updated_by => null,
       p_last_update_date => l_last_update_date,
       p_db_last_update_date => null,
       p_last_update_login => l_last_update_login,
       p_create_or_update => 'CREATE') then
     null;

Line: 823

  select userenv('LANG') into l_lang
  from dual;

Line: 826

  insert into AK_ATTRIBUTES (
    ATTRIBUTE_APPLICATION_ID,
    ATTRIBUTE_CODE,
    ATTRIBUTE_LABEL_LENGTH,
    ATTRIBUTE_VALUE_LENGTH,
    BOLD,
    ITALIC,
    VERTICAL_ALIGNMENT,
    HORIZONTAL_ALIGNMENT,
    DATA_TYPE,
    UPPER_CASE_FLAG,
    DEFAULT_VALUE_VARCHAR2,
    DEFAULT_VALUE_NUMBER,
    DEFAULT_VALUE_DATE,
    LOV_REGION_APPLICATION_ID,
    LOV_REGION_CODE,
	ITEM_STYLE,
	DISPLAY_HEIGHT,
	CSS_CLASS_NAME,
	POPLIST_VIEWOBJECT,
	POPLIST_DISPLAY_ATTRIBUTE,
	POPLIST_VALUE_ATTRIBUTE,
	CSS_LABEL_CLASS_NAME,
	PRECISION,
 	EXPANSION,
	ALS_MAX_LENGTH,
	ATTRIBUTE_CATEGORY,
	ATTRIBUTE1,
	ATTRIBUTE2,
	ATTRIBUTE3,
	ATTRIBUTE4,
	ATTRIBUTE5,
	ATTRIBUTE6,
	ATTRIBUTE7,
	ATTRIBUTE8,
	ATTRIBUTE9,
	ATTRIBUTE10,
	ATTRIBUTE11,
	ATTRIBUTE12,
	ATTRIBUTE13,
	ATTRIBUTE14,
	ATTRIBUTE15,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    p_attribute_application_id,
    p_attribute_code,
    l_attribute_label_length,
    l_attribute_value_length,
    p_bold,
    p_italic,
    p_vertical_alignment,
    p_horizontal_alignment,
    p_data_type,
    l_upper_case_flag,
    l_default_value_varchar2,
    l_default_value_number,
    l_default_value_date,
    l_lov_region_application_id,
    l_lov_region_code,
	l_item_style,
	l_display_height,
	l_css_class_name,
	l_poplist_viewobject,
	l_poplist_display_attr,
	l_poplist_value_attr,
	l_css_label_class_name,
  	l_precision,
	l_expansion,
	l_als_max_length,
    l_attribute_category,
	l_attribute1,
	l_attribute2,
	l_attribute3,
	l_attribute4,
	l_attribute5,
	l_attribute6,
	l_attribute7,
	l_attribute8,
	l_attribute9,
	l_attribute10,
	l_attribute11,
	l_attribute12,
	l_attribute13,
	l_attribute14,
	l_attribute15,
    l_creation_date,
    l_created_by,
    l_last_update_date,
    l_last_updated_by,
    l_last_update_login
  );

Line: 931

      FND_MESSAGE.SET_NAME('AK','AK_INSERT_ATTRIBUTE_FAILED');

Line: 938

  insert into AK_ATTRIBUTES_TL (
    ATTRIBUTE_APPLICATION_ID,
    ATTRIBUTE_CODE,
    LANGUAGE,
    NAME,
    ATTRIBUTE_LABEL_LONG,
    ATTRIBUTE_LABEL_SHORT,
    DESCRIPTION,
    SOURCE_LANG,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN
  ) select
    p_attribute_application_id,
    p_attribute_code,
    L.LANGUAGE_CODE,
    p_name,
    l_attribute_label_long,
    l_attribute_label_short,
    l_description,
    l_lang,
    l_created_by,
    l_creation_date,
    l_last_updated_by,
    l_last_update_date,
    l_last_update_login
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from AK_ATTRIBUTES_TL T
    where T.ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
    and T.ATTRIBUTE_CODE = p_attribute_code
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 1025

        AK_ATTRIBUTE_PVT.UPDATE_ATTRIBUTE (
           p_validation_level => p_validation_level,
           p_api_version_number => 1.0,
           p_msg_count => p_msg_count,
           p_msg_data => p_msg_data,
           p_return_status => p_return_status,
           p_attribute_application_id => p_attribute_application_id,
           p_attribute_code => p_attribute_code,
           p_attribute_label_length => p_attribute_label_length,
           p_attribute_value_length => p_attribute_value_length,
           p_bold => p_bold,
           p_italic => p_italic,
           p_vertical_alignment => p_vertical_alignment,
           p_horizontal_alignment => p_horizontal_alignment,
           p_data_type => p_data_type,
           p_precision => p_precision,
           p_upper_case_flag => p_upper_case_flag,
           p_default_value_varchar2 => p_default_value_varchar2,
           p_default_value_number => p_default_value_number,
           p_default_value_date => p_default_value_date,
           p_lov_region_application_id => p_lov_region_application_id,
           p_lov_region_code => p_lov_region_code,
           p_item_style => p_item_style,
           p_display_height => p_display_height,
           p_css_class_name => p_css_class_name,
           p_poplist_viewobject => p_poplist_viewobject,
           p_poplist_display_attr => p_poplist_display_attr,
           p_poplist_value_attr => p_poplist_value_attr,
           p_css_label_class_name => p_css_label_class_name,
           p_attribute_category => p_attribute_category,
           p_expansion => p_expansion,
           p_als_max_length => p_als_max_length,
           p_attribute1 => p_attribute1,
           p_attribute2 => p_attribute2,
           p_attribute3 => p_attribute3,
           p_attribute4 => p_attribute4,
           p_attribute5 => p_attribute5,
           p_attribute6 => p_attribute6,
           p_attribute7 => p_attribute7,
           p_attribute8 => p_attribute8,
           p_attribute9 => p_attribute9,
           p_attribute10 => p_attribute10,
           p_attribute11 => p_attribute11,
           p_attribute12 => p_attribute12,
           p_attribute13 => p_attribute13,
           p_attribute14 => p_attribute14,
           p_attribute15 => p_attribute15,
           p_created_by => p_created_by,
           p_creation_date => p_creation_date,
           p_last_updated_by => p_last_updated_by,
           p_last_update_date => p_last_update_date,
           p_last_update_login => p_last_update_login,
           p_name => p_name,
           p_attribute_label_long => p_attribute_label_long,
           p_attribute_label_short =>p_attribute_label_short,
           p_description => p_description,
           p_loader_timestamp => p_loader_timestamp,
           p_pass => p_pass,
           p_copy_redo_flag => p_copy_redo_flag
           );

Line: 1122

procedure DELETE_ATTRIBUTE (
  p_validation_level         IN      NUMBER := FND_API.G_VALID_LEVEL_FULL,
  p_api_version_number       IN      NUMBER,
  p_init_msg_tbl             IN      BOOLEAN := FALSE,
  p_msg_count                OUT NOCOPY     NUMBER,
  p_msg_data                 OUT NOCOPY     VARCHAR2,
  p_return_status            OUT NOCOPY     VARCHAR2,
  p_attribute_application_id IN      NUMBER,
  p_attribute_code           IN      VARCHAR2,
  p_delete_cascade           IN      VARCHAR2
) is
  cursor l_get_obj_attr_csr is
    select DATABASE_OBJECT_NAME
    from  AK_OBJECT_ATTRIBUTES
    where ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
    and   ATTRIBUTE_CODE = p_attribute_code;

Line: 1139

    select REGION_APPLICATION_ID, REGION_CODE
    from  AK_REGION_ITEMS
    where ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
    and   ATTRIBUTE_CODE = p_attribute_code
    and   OBJECT_ATTRIBUTE_FLAG = 'N';

Line: 1145

  l_api_name              CONSTANT varchar2(30) := 'Delete_Attribute';

Line: 1167

  savepoint start_delete_attribute;

Line: 1184

  if (p_delete_cascade = 'N') then
    --
    -- If we are not deleting any referencing records, we cannot
    -- delete the attribute if it is being referenced in any of
    -- following tables.
    --
    -- AK_OBJECT_ATTRIBUTES
    --
    open l_get_obj_attr_csr;

Line: 1228

      AK_OBJECT_PVT.DELETE_ATTRIBUTE(
        p_validation_level => p_validation_level,
        p_api_version_number => 1.0,
        p_msg_count => l_msg_count,
        p_msg_data => l_msg_data,
        p_return_status => l_return_status,
	p_database_object_name => l_database_object_name,
        p_attribute_application_id => p_attribute_application_id,
        p_attribute_code => p_attribute_code,
        p_delete_cascade => p_delete_cascade
      );

Line: 1253

      AK_REGION_PVT.DELETE_ITEM (
        p_validation_level => p_validation_level,
        p_api_version_number => 1.0,
        p_msg_count => l_msg_count,
        p_msg_data => l_msg_data,
        p_return_status => l_return_status,
        p_region_application_id => l_region_application_id,
        p_region_code => l_region_code,
        p_attribute_application_id => p_attribute_application_id,
        p_attribute_code => p_attribute_code,
        p_delete_cascade => p_delete_cascade
      );

Line: 1279

  delete from ak_attributes
  where  attribute_application_id = p_attribute_application_id
  and    attribute_code = p_attribute_code;

Line: 1291

  delete from ak_attributes_tl
  where  attribute_application_id = p_attribute_application_id
  and    attribute_code = p_attribute_code;

Line: 1307

    FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_DELETED');

Line: 1322

      FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_NOT_DELETED');

Line: 1328

    rollback to start_delete_attribute;

Line: 1334

    rollback to start_delete_attribute;

Line: 1340

end DELETE_ATTRIBUTE;

Line: 1412

  l_databuffer_tbl.DELETE;

Line: 1698

           FND_LOAD_UTIL.OWNER_NAME(p_attributes_rec.last_updated_by) || '"';

Line: 1700

    l_databuffer_tbl(l_index) := '  LAST_UPDATE_DATE = "' ||
                to_char(p_attributes_rec.last_update_date,
                        AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

Line: 1704

    l_databuffer_tbl(l_index) := '  LAST_UPDATE_LOGIN = "' ||
                nvl(to_char(p_attributes_rec.last_update_login),'') || '"';

Line: 1837

    select *
    from AK_ATTRIBUTES
    where ATTRIBUTE_APPLICATION_ID = appl_id_parm;

Line: 1842

    select *
    from AK_ATTRIBUTES
    where ATTRIBUTE_APPLICATION_ID = appl_id_parm
    and   ATTRIBUTE_CODE = attr_code_parm;

Line: 1848

    select *
    from AK_ATTRIBUTES
    where ATTRIBUTE_APPLICATION_ID = appl_id_parm
    and   ATTRIBUTE_CODE like attr_code_parm;

Line: 1855

    select *
    from AK_ATTRIBUTES_TL
    where ATTRIBUTE_APPLICATION_ID = appl_id_parm
    and   ATTRIBUTE_CODE = attr_code_parm
    and   LANGUAGE = lang_parm;

Line: 1863

    select *
    from AK_ATTRIBUTES_TL
    where ATTRIBUTE_APPLICATION_ID = appl_id_parm
    and   ATTRIBUTE_CODE like attr_code_parm
    and   LANGUAGE = lang_parm;

Line: 1869

    select instr(attr_code_parm,'%')
    from dual;

Line: 1880

  l_select_by_appl_id  BOOLEAN;

Line: 1901

        FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');

Line: 1934

    l_select_by_appl_id := TRUE;

Line: 1936

    l_select_by_appl_id := FALSE;

Line: 1943

  if (l_select_by_appl_id) then
    --
    -- download by application ID
    --
    open l_get_attribute_1_csr(p_application_id);

Line: 2173

  l_update1                  DATE;

Line: 2174

  l_update2		     DATE;

Line: 2373

			(l_token = 'LAST_UPDATED_BY') or
                        (l_token = 'OWNER') or
			(l_token = 'LAST_UPDATE_DATE') or
			(l_token = 'LAST_UPDATE_LOGIN') or
            (l_token = 'ATTRIBUTE_LABEL_LONG') or
            (l_token = 'ATTRIBUTE_LABEL_SHORT') or
            (l_token = 'NAME') or
            (l_token = 'DESCRIPTION') then
        l_column := l_token;

Line: 2551

      elsif (l_column = 'LAST_UPDATED_BY') then
	 l_attribute_rec.last_updated_by := to_number(l_token);

Line: 2555

         l_attribute_rec.last_updated_by := FND_LOAD_UTIL.OWNER_ID(l_token);

Line: 2557

      elsif (l_column = 'LAST_UPDATE_DATE') then
	 l_attribute_rec.last_update_date := to_date(l_token,
					AK_ON_OBJECTS_PUB.G_DATE_FORMAT);

Line: 2561

      elsif (l_column = 'LAST_UPDATE_LOGIN') then
	 l_attribute_rec.last_update_login := to_number(l_token);

Line: 2611

		-- do not update customized data
		  if (AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE) then
			select aa.last_updated_by, aat.last_updated_by,
                               aa.last_update_date, aat.last_update_date
                        into l_user_id1, l_user_id2, l_update1, l_update2
			from ak_attributes aa, ak_attributes_tl aat
			where aa.attribute_code = l_attribute_rec.attribute_code
			and aa.attribute_application_id = l_attribute_rec.attribute_application_id
			and aa.attribute_code = aat.attribute_code
			and aa.attribute_application_id = aat.attribute_application_id
			and aat.language = userenv('LANG');

Line: 2625

		if (AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
		      p_loader_timestamp => p_loader_timestamp,
       	       	      p_created_by => l_attribute_rec.created_by,
                      p_creation_date => l_attribute_rec.creation_date,
                      p_last_updated_by => l_attribute_rec.last_updated_by,
                      p_db_last_updated_by => l_user_id1,
                      p_last_update_date => l_attribute_rec.last_update_date,
                      p_db_last_update_date => l_update1,
                      p_last_update_login => l_attribute_rec.last_update_login,
                      p_create_or_update => 'UPDATE') and

                   AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
                      p_loader_timestamp => p_loader_timestamp,
                      p_created_by => l_attribute_rec.created_by,
                      p_creation_date => l_attribute_rec.creation_date,
                      p_last_updated_by => l_attribute_rec.last_updated_by,
                      p_db_last_updated_by => l_user_id2,
                      p_last_update_date => l_attribute_rec.last_update_date,
                      p_db_last_update_date => l_update2,
                      p_last_update_login => l_attribute_rec.last_update_login,
                      p_create_or_update => 'UPDATE')) then

	            AK_ATTRIBUTE_PVT.UPDATE_ATTRIBUTE (
	              p_validation_level => p_validation_level,
		          p_api_version_number => 1.0,
	              p_msg_count => l_msg_count,
	              p_msg_data => l_msg_data,
	              p_return_status => l_return_status,
		          p_attribute_application_id =>
	                               l_attribute_rec.attribute_application_id,
	              p_attribute_code => l_attribute_rec.attribute_code,
		          p_attribute_label_length => l_attribute_rec.attribute_label_length,
		          p_attribute_value_length => l_attribute_rec.attribute_value_length,
		          p_bold => l_attribute_rec.bold,
		          p_italic => l_attribute_rec.italic,
		          p_vertical_alignment => l_attribute_rec.vertical_alignment,
		          p_horizontal_alignment => l_attribute_rec.horizontal_alignment,
		          p_data_type => l_attribute_rec.data_type,
			  p_precision => l_attribute_rec.precision,
		          p_upper_case_flag => l_attribute_rec.upper_case_flag,
	              p_default_value_varchar2 => l_attribute_rec.default_value_varchar2,
	              p_default_value_number => l_attribute_rec.default_value_number,
	              p_default_value_date => l_attribute_rec.default_value_date,
	              p_lov_region_application_id =>
	                                    l_attribute_rec.lov_region_application_id,
	              p_lov_region_code => l_attribute_rec.lov_region_code,
				  p_item_style => l_attribute_rec.item_style,
		p_display_height => l_attribute_rec.display_height,
		p_css_class_name => l_attribute_rec.css_class_name,
		p_poplist_viewobject => l_attribute_rec.poplist_viewobject,
		p_poplist_display_attr => l_attribute_rec.poplist_display_attribute,
		p_poplist_value_attr => l_attribute_rec.poplist_value_attribute,
		p_css_label_class_name => l_attribute_rec.css_label_class_name,
	              p_attribute_category => l_attribute_rec.attribute_category,
		p_expansion => l_attribute_rec.expansion,
		p_als_max_length => l_attribute_rec.als_max_length,
				  p_attribute1 => l_attribute_rec.attribute1,
				  p_attribute2 => l_attribute_rec.attribute2,
				  p_attribute3 => l_attribute_rec.attribute3,
				  p_attribute4 => l_attribute_rec.attribute4,
				  p_attribute5 => l_attribute_rec.attribute5,
				  p_attribute6 => l_attribute_rec.attribute6,
				  p_attribute7 => l_attribute_rec.attribute7,
				  p_attribute8 => l_attribute_rec.attribute8,
				  p_attribute9 => l_attribute_rec.attribute9,
				  p_attribute10 => l_attribute_rec.attribute10,
				  p_attribute11 => l_attribute_rec.attribute11,
				  p_attribute12 => l_attribute_rec.attribute12,
				  p_attribute13 => l_attribute_rec.attribute13,
				  p_attribute14 => l_attribute_rec.attribute14,
				  p_attribute15 => l_attribute_rec.attribute15,
				  p_created_by => l_attribute_rec.created_by,
				  p_creation_date => l_attribute_rec.creation_date,
				  p_last_updated_by => l_attribute_rec.last_updated_by,
				  p_last_update_date => l_attribute_rec.last_update_date,
				  p_last_update_login => l_attribute_rec.last_update_login,

		          p_name => l_attribute_tl_rec.name,
	              p_attribute_label_long => l_attribute_tl_rec.attribute_label_long,
		          p_attribute_label_short =>l_attribute_tl_rec.attribute_label_short,
		          p_description => l_attribute_tl_rec.description,
		          p_loader_timestamp => p_loader_timestamp,
			      p_pass => p_pass,
	              p_copy_redo_flag => l_copy_redo_flag
	              );

Line: 2711

		  -- update all records --
		  --
		  -- Update record only if Update mode is set to true
		  --
		  elsif (AK_UPLOAD_GRP.G_UPDATE_MODE) then
	            AK_ATTRIBUTE_PVT.UPDATE_ATTRIBUTE (
	              p_validation_level => p_validation_level,
		          p_api_version_number => 1.0,
	              p_msg_count => l_msg_count,
	              p_msg_data => l_msg_data,
	              p_return_status => l_return_status,
		          p_attribute_application_id =>
	                               l_attribute_rec.attribute_application_id,
	              p_attribute_code => l_attribute_rec.attribute_code,
		          p_attribute_label_length => l_attribute_rec.attribute_label_length,
		          p_attribute_value_length => l_attribute_rec.attribute_value_length,
		          p_bold => l_attribute_rec.bold,
		          p_italic => l_attribute_rec.italic,
		          p_vertical_alignment => l_attribute_rec.vertical_alignment,
		          p_horizontal_alignment => l_attribute_rec.horizontal_alignment,
		          p_data_type => l_attribute_rec.data_type,
			  p_precision => l_attribute_rec.precision,
		          p_upper_case_flag => l_attribute_rec.upper_case_flag,
	              p_default_value_varchar2 => l_attribute_rec.default_value_varchar2,
	              p_default_value_number => l_attribute_rec.default_value_number,
	              p_default_value_date => l_attribute_rec.default_value_date,
	              p_lov_region_application_id =>
	                                    l_attribute_rec.lov_region_application_id,
	              p_lov_region_code => l_attribute_rec.lov_region_code,
				  p_item_style => l_attribute_rec.item_style,
                p_display_height => l_attribute_rec.display_height,
                p_css_class_name => l_attribute_rec.css_class_name,
                p_poplist_viewobject => l_attribute_rec.poplist_viewobject,
                p_poplist_display_attr => l_attribute_rec.poplist_display_attribute,
                p_poplist_value_attr => l_attribute_rec.poplist_value_attribute,
                p_css_label_class_name => l_attribute_rec.css_label_class_name,
		p_expansion => l_attribute_rec.expansion,
		p_als_max_length => l_attribute_rec.als_max_length,
	              p_attribute_category => l_attribute_rec.attribute_category,
				  p_attribute1 => l_attribute_rec.attribute1,
				  p_attribute2 => l_attribute_rec.attribute2,
				  p_attribute3 => l_attribute_rec.attribute3,
				  p_attribute4 => l_attribute_rec.attribute4,
				  p_attribute5 => l_attribute_rec.attribute5,
				  p_attribute6 => l_attribute_rec.attribute6,
				  p_attribute7 => l_attribute_rec.attribute7,
				  p_attribute8 => l_attribute_rec.attribute8,
				  p_attribute9 => l_attribute_rec.attribute9,
				  p_attribute10 => l_attribute_rec.attribute10,
				  p_attribute11 => l_attribute_rec.attribute11,
				  p_attribute12 => l_attribute_rec.attribute12,
				  p_attribute13 => l_attribute_rec.attribute13,
				  p_attribute14 => l_attribute_rec.attribute14,
				  p_attribute15 => l_attribute_rec.attribute15,
				  p_created_by => l_attribute_rec.created_by,
				  p_creation_date => l_attribute_rec.creation_date,
				  p_last_updated_by => l_attribute_rec.last_updated_by,
				  p_last_update_date => l_attribute_rec.last_update_date,
			          p_last_update_login => l_attribute_rec.last_update_login,
		          p_name => l_attribute_tl_rec.name,
	              p_attribute_label_long => l_attribute_tl_rec.attribute_label_long,
		          p_attribute_label_short =>l_attribute_tl_rec.attribute_label_short,
		          p_description => l_attribute_tl_rec.description,
		          p_loader_timestamp => p_loader_timestamp,
			      p_pass => p_pass,
	              p_copy_redo_flag => l_copy_redo_flag
	              );

Line: 2778

		  end if; -- /* if G_UPDATE_MODE G_NC_UPDATE_MODE*/

Line: 2831

			p_last_updated_by => l_attribute_rec.last_updated_by,
			p_last_update_date => l_attribute_rec.last_update_date,
			p_last_update_login => l_attribute_rec.last_update_login,
	    p_name => l_attribute_tl_rec.name,
            p_attribute_label_long => l_attribute_tl_rec.attribute_label_long,
	    p_attribute_label_short =>l_attribute_tl_rec.attribute_label_short,
	    p_description => l_attribute_tl_rec.description,
	    p_loader_timestamp => p_loader_timestamp,
		p_pass => p_pass,
        p_copy_redo_flag => l_copy_redo_flag
          );

Line: 2983

procedure INSERT_ATTRIBUTE_PK_TABLE (
  p_return_status            OUT NOCOPY     VARCHAR2,
  p_attribute_application_id IN      NUMBER,
  p_attribute_code           IN      VARCHAR2,
  p_attribute_pk_tbl         IN OUT NOCOPY  AK_ATTRIBUTE_PUB.Attribute_PK_Tbl_Type
) is
  l_api_version_number CONSTANT number := 1.0;

Line: 2990

  l_api_name           CONSTANT varchar2(30) := 'Insert_Attribute_PK_Table';

Line: 3029

end INSERT_ATTRIBUTE_PK_TABLE;

Line: 3058

procedure UPDATE_ATTRIBUTE (
  p_validation_level         IN      NUMBER := FND_API.G_VALID_LEVEL_FULL,
  p_api_version_number       IN      NUMBER,
  p_init_msg_tbl             IN      BOOLEAN := FALSE,
  p_msg_count                OUT NOCOPY     NUMBER,
  p_msg_data                 OUT NOCOPY     VARCHAR2,
  p_return_status            OUT NOCOPY     VARCHAR2,
  p_attribute_application_id IN      NUMBER,
  p_attribute_code           IN      VARCHAR2,
  p_attribute_label_length   IN      NUMBER := FND_API.G_MISS_NUM,
  p_attribute_value_length   IN      NUMBER := FND_API.G_MISS_NUM,
  p_bold                     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_italic                   IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_vertical_alignment       IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_horizontal_alignment     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_data_type                IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_upper_case_flag          IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_default_value_varchar2   IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_default_value_number     IN      NUMBER := FND_API.G_MISS_NUM,
  p_default_value_date       IN      DATE := FND_API.G_MISS_DATE,
  p_lov_region_application_id IN     NUMBER := FND_API.G_MISS_NUM,
  p_lov_region_code          IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_item_style				 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
  p_display_height			 IN		 NUMBER := FND_API.G_MISS_NUM,
  p_css_class_name 			 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
  p_poplist_viewobject		 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
  p_poplist_display_attr	 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
  p_poplist_value_attr		 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
  p_css_label_class_name	 IN		 VARCHAR2 := FND_API.G_MISS_CHAR,
  p_precision			IN              NUMBER := FND_API.G_MISS_NUM,
  p_expansion			IN		NUMBER := FND_API.G_MISS_NUM,
  p_als_max_length		IN		NUMBER := FND_API.G_MISS_NUM,
  p_attribute_category       IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_attribute1               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_attribute2               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_attribute3               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_attribute4               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_attribute5               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_attribute6               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_attribute7               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_attribute8               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_attribute9               IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_attribute10              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_attribute11              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_attribute12              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_attribute13              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_attribute14              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_attribute15              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_name                     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_attribute_label_long     IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_attribute_label_short    IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_description              IN      VARCHAR2 := FND_API.G_MISS_CHAR,
  p_created_by               IN     NUMBER := FND_API.G_MISS_NUM,
  p_creation_date            IN      DATE := FND_API.G_MISS_DATE,
  p_last_updated_by          IN     NUMBER := FND_API.G_MISS_NUM,
  p_last_update_date         IN      DATE := FND_API.G_MISS_DATE,
  p_last_update_login        IN     NUMBER := FND_API.G_MISS_NUM,
  p_loader_timestamp         IN      DATE := FND_API.G_MISS_DATE,
  p_pass                     IN      NUMBER,
  p_copy_redo_flag           IN OUT NOCOPY  BOOLEAN
) is
  cursor l_get_row_csr is
    select *
    from  AK_ATTRIBUTES
    where ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
    and   ATTRIBUTE_CODE = p_attribute_code
    for update of ATTRIBUTE_APPLICATION_ID;

Line: 3126

    select *
    from  AK_ATTRIBUTES_TL
    where ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
    and   ATTRIBUTE_CODE = p_attribute_code
    and   LANGUAGE = lang_parm
    for update of ATTRIBUTE_APPLICATION_ID;

Line: 3133

    select 1
    from  AK_OBJECT_ATTRIBUTE_NAVIGATION
    where ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
    and   ATTRIBUTE_CODE = p_attribute_code;

Line: 3138

    select 1
    from  AK_INST_ATTRIBUTE_VALUES
    where ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
    and   ATTRIBUTE_CODE = p_attribute_code;

Line: 3143

    select 1
    from   AK_FLOW_PAGE_REGION_ITEMS ri
    where ri.to_url_attribute_appl_id = p_attribute_application_id
    and   ri.to_url_attribute_code = p_attribute_code;

Line: 3148

  l_api_name           CONSTANT varchar2(30) := 'Update_Attribute';

Line: 3156

  l_last_update_date   date;

Line: 3157

  l_last_update_login  number;

Line: 3158

  l_last_updated_by    number;

Line: 3176

  savepoint start_update_attribute;

Line: 3178

  select userenv('LANG') into l_lang
  from dual;

Line: 3239

            p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
			p_pass => p_pass
          ) then
      if (p_pass = 1) then
        p_copy_redo_flag := TRUE;

Line: 3495

  if (p_last_updated_by <> FND_API.G_MISS_NUM) then
    l_last_updated_by := p_last_updated_by;

Line: 3498

  if (p_last_update_date <> FND_API.G_MISS_DATE) then
    l_last_update_date := p_last_update_date;

Line: 3501

  if (p_last_update_login <> FND_API.G_MISS_NUM) then
    l_last_update_login := p_last_update_login;

Line: 3505

  if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
       p_loader_timestamp => p_loader_timestamp,
       p_created_by => l_created_by,
       p_creation_date => l_creation_date,
       p_last_updated_by => l_last_updated_by,
       p_db_last_updated_by => l_attributes_rec.last_updated_by,
       p_last_update_date => l_last_update_date,
       p_db_last_update_date => l_attributes_rec.last_update_date,
       p_last_update_login => l_last_update_login,
       p_create_or_update => 'UPDATE') then

  update AK_ATTRIBUTES set
      ATTRIBUTE_LABEL_LENGTH = l_attributes_rec.attribute_label_length,
      ATTRIBUTE_VALUE_LENGTH = l_attributes_rec.attribute_value_length,
      BOLD = l_attributes_rec.bold,
      ITALIC = l_attributes_rec.italic,
      VERTICAL_ALIGNMENT = l_attributes_rec.vertical_alignment,
      HORIZONTAL_ALIGNMENT = l_attributes_rec.horizontal_alignment,
      DATA_TYPE = l_attributes_rec.data_type,
      UPPER_CASE_FLAG = l_attributes_rec.upper_case_flag,
      DEFAULT_VALUE_VARCHAR2 = l_attributes_rec.default_value_varchar2,
      DEFAULT_VALUE_NUMBER = l_attributes_rec.default_value_number,
      DEFAULT_VALUE_DATE = l_attributes_rec.default_value_date,
      LOV_REGION_APPLICATION_ID = l_attributes_rec.lov_region_application_id,
      LOV_REGION_CODE = l_attributes_rec.lov_region_code,
      ITEM_STYLE = l_attributes_rec.item_style,
      DISPLAY_HEIGHT = l_attributes_rec.display_height,
      CSS_CLASS_NAME = l_attributes_rec.css_class_name,
      POPLIST_VIEWOBJECT = l_attributes_rec.poplist_viewobject,
      POPLIST_DISPLAY_ATTRIBUTE = l_attributes_rec.poplist_display_attribute,
      POPLIST_VALUE_ATTRIBUTE = l_attributes_rec.poplist_value_attribute,
	  CSS_LABEL_CLASS_NAME = l_attributes_rec.css_label_class_name,
	  PRECISION = l_attributes_rec.precision,
	  EXPANSION = l_attributes_rec.expansion,
	  ALS_MAX_LENGTH = l_attributes_rec.als_max_length,
	  ATTRIBUTE_CATEGORY = l_attributes_rec.attribute_category,
	  ATTRIBUTE1 = l_attributes_rec.attribute1,
	  ATTRIBUTE2 = l_attributes_rec.attribute2,
	  ATTRIBUTE3 = l_attributes_rec.attribute3,
	  ATTRIBUTE4 = l_attributes_rec.attribute4,
	  ATTRIBUTE5 = l_attributes_rec.attribute5,
	  ATTRIBUTE6 = l_attributes_rec.attribute6,
	  ATTRIBUTE7 = l_attributes_rec.attribute7,
	  ATTRIBUTE8 = l_attributes_rec.attribute8,
	  ATTRIBUTE9 = l_attributes_rec.attribute9,
	  ATTRIBUTE10 = l_attributes_rec.attribute10,
	  ATTRIBUTE11 = l_attributes_rec.attribute11,
	  ATTRIBUTE12 = l_attributes_rec.attribute12,
	  ATTRIBUTE13 = l_attributes_rec.attribute13,
	  ATTRIBUTE14 = l_attributes_rec.attribute14,
	  ATTRIBUTE15 = l_attributes_rec.attribute15,
      LAST_UPDATE_DATE = l_last_update_date,
      LAST_UPDATED_BY = l_last_updated_by,
      LAST_UPDATE_LOGIN = l_last_update_login
  where attribute_application_id = p_attribute_application_id
  and   attribute_code = p_attribute_code;

Line: 3563

      FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_UPDATE_FAILED');

Line: 3569

  update AK_ATTRIBUTES_TL set
      NAME = l_attributes_tl_rec.name,
      ATTRIBUTE_LABEL_LONG = l_attributes_tl_rec.attribute_label_long,
      ATTRIBUTE_LABEL_SHORT = l_attributes_tl_rec.attribute_label_short,
      DESCRIPTION = l_attributes_tl_rec.description,
      LAST_UPDATED_BY = l_last_updated_by,
      LAST_UPDATE_DATE = l_last_update_date,
      LAST_UPDATE_LOGIN = l_last_update_login,
	  SOURCE_LANG = l_lang
  where attribute_application_id = p_attribute_application_id
  and   attribute_code = p_attribute_code
  and   l_lang in (LANGUAGE, SOURCE_LANG);

Line: 3583

      FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_UPDATE_FAILED');

Line: 3594

    FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_UPDATED');

Line: 3618

      FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_NOT_UPDATED');

Line: 3624

    rollback to start_update_attribute;

Line: 3630

      FND_MESSAGE.SET_NAME('AK','AK_ATTRIBUTE_NOT_UPDATED');

Line: 3636

    rollback to start_update_attribute;

Line: 3642

    rollback to start_update_attribute;

Line: 3648

end UPDATE_ATTRIBUTE;

Line: 3699

            AK_ATTRIBUTE_PVT.UPDATE_ATTRIBUTE (
              p_validation_level => p_validation_level,
	          p_api_version_number => 1.0,
              p_msg_count => l_msg_count,
              p_msg_data => l_msg_data,
              p_return_status => l_return_status,
	          p_attribute_application_id =>
                               G_ATTRIBUTE_REDO_TBL(l_rec_index).attribute_application_id,
              p_attribute_code => G_ATTRIBUTE_REDO_TBL(l_rec_index).attribute_code,
	          p_attribute_label_length => G_ATTRIBUTE_REDO_TBL(l_rec_index).attribute_label_length,
	          p_attribute_value_length => G_ATTRIBUTE_REDO_TBL(l_rec_index).attribute_value_length,
	          p_bold => G_ATTRIBUTE_REDO_TBL(l_rec_index).bold,
	          p_italic => G_ATTRIBUTE_REDO_TBL(l_rec_index).italic,
	          p_vertical_alignment => G_ATTRIBUTE_REDO_TBL(l_rec_index).vertical_alignment,
	          p_horizontal_alignment => G_ATTRIBUTE_REDO_TBL(l_rec_index).horizontal_alignment,
	          p_data_type => G_ATTRIBUTE_REDO_TBL(l_rec_index).data_type,
	          p_upper_case_flag => G_ATTRIBUTE_REDO_TBL(l_rec_index).upper_case_flag,
              p_default_value_varchar2 => G_ATTRIBUTE_REDO_TBL(l_rec_index).default_value_varchar2,
              p_default_value_number => G_ATTRIBUTE_REDO_TBL(l_rec_index).default_value_number,
              p_default_value_date => G_ATTRIBUTE_REDO_TBL(l_rec_index).default_value_date,
              p_lov_region_application_id =>
                                    G_ATTRIBUTE_REDO_TBL(l_rec_index).lov_region_application_id,
              p_lov_region_code => G_ATTRIBUTE_REDO_TBL(l_rec_index).lov_region_code,
              p_item_style => G_ATTRIBUTE_REDO_TBL(l_rec_index).item_style,
              p_display_height => G_ATTRIBUTE_REDO_TBL(l_rec_index).display_height,
              p_css_class_name => G_ATTRIBUTE_REDO_TBL(l_rec_index).css_class_name,
              p_poplist_viewobject => G_ATTRIBUTE_REDO_TBL(l_rec_index).poplist_viewobject,
              p_poplist_display_attr => G_ATTRIBUTE_REDO_TBL(l_rec_index).poplist_display_attribute,
              p_poplist_value_attr => G_ATTRIBUTE_REDO_TBL(l_rec_index).poplist_value_attribute,
              p_css_label_class_name => G_ATTRIBUTE_REDO_TBL(l_rec_index).css_label_class_name,
	      p_precision => G_ATTRIBUTE_REDO_TBL(l_rec_index).precision,
	      p_expansion => G_ATTRIBUTE_REDO_TBL(l_rec_index).expansion,
	      p_als_max_length => G_ATTRIBUTE_REDO_TBL(l_rec_index).als_max_length,
              p_attribute_category => G_ATTRIBUTE_REDO_TBL(l_rec_index).attribute_category,
			  p_attribute1 => G_ATTRIBUTE_REDO_TBL(l_rec_index).attribute1,
			  p_attribute2 => G_ATTRIBUTE_REDO_TBL(l_rec_index).attribute2,
			  p_attribute3 => G_ATTRIBUTE_REDO_TBL(l_rec_index).attribute3,
			  p_attribute4 => G_ATTRIBUTE_REDO_TBL(l_rec_index).attribute4,
			  p_attribute5 => G_ATTRIBUTE_REDO_TBL(l_rec_index).attribute5,
			  p_attribute6 => G_ATTRIBUTE_REDO_TBL(l_rec_index).attribute6,
			  p_attribute7 => G_ATTRIBUTE_REDO_TBL(l_rec_index).attribute7,
			  p_attribute8 => G_ATTRIBUTE_REDO_TBL(l_rec_index).attribute8,
			  p_attribute9 => G_ATTRIBUTE_REDO_TBL(l_rec_index).attribute9,
			  p_attribute10 => G_ATTRIBUTE_REDO_TBL(l_rec_index).attribute10,
			  p_attribute11 => G_ATTRIBUTE_REDO_TBL(l_rec_index).attribute11,
			  p_attribute12 => G_ATTRIBUTE_REDO_TBL(l_rec_index).attribute12,
			  p_attribute13 => G_ATTRIBUTE_REDO_TBL(l_rec_index).attribute13,
			  p_attribute14 => G_ATTRIBUTE_REDO_TBL(l_rec_index).attribute14,
			  p_attribute15 => G_ATTRIBUTE_REDO_TBL(l_rec_index).attribute15,
	          p_name => G_ATTRIBUTE_TL_REDO_TBL(l_rec_index).name,
              p_attribute_label_long => G_ATTRIBUTE_TL_REDO_TBL(l_rec_index).attribute_label_long,
	          p_attribute_label_short => G_ATTRIBUTE_TL_REDO_TBL(l_rec_index).attribute_label_short,
	          p_description => G_ATTRIBUTE_TL_REDO_TBL(l_rec_index).description,
		p_created_by => G_ATTRIBUTE_REDO_TBL(l_rec_index).created_by,
		p_creation_date => G_ATTRIBUTE_REDO_TBL(l_rec_index).creation_date,
		p_last_updated_by => G_ATTRIBUTE_REDO_TBL(l_rec_index).last_updated_by,
		p_last_update_date => G_ATTRIBUTE_REDO_TBL(l_rec_index).last_update_date,
		p_last_update_login => G_ATTRIBUTE_REDO_TBL(l_rec_index).last_update_login,
	          p_loader_timestamp => p_loader_timestamp,
		      p_pass => p_pass,
              p_copy_redo_flag => l_copy_redo_flag
              );

Line: 3816

		p_last_updated_by => G_ATTRIBUTE_REDO_TBL(l_rec_index).last_updated_by,
		p_last_update_date => G_ATTRIBUTE_REDO_TBL(l_rec_index).last_update_date,
		p_last_update_login => G_ATTRIBUTE_REDO_TBL(l_rec_index).last_update_login,
	        p_loader_timestamp => p_loader_timestamp,
		    p_pass => p_pass,
            p_copy_redo_flag => l_copy_redo_flag
          );

Line: 3832

    G_ATTRIBUTE_REDO_TBL.DELETE;

Line: 3843

G_ATTRIBUTE_REDO_TBL.DELETE;

Line: 3851

G_ATTRIBUTE_REDO_TBL.DELETE;