eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AK_ATTRIBUTES2_PKG SQL Statements

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

Line: 15


  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER)
IS
/* local variables */
  L_UNIQUE_KEY_NAME varchar2(30);

Line: 24


  select foreign_key_name
  from   ak_foreign_key_mapping_v
  where  database_object_name = x_database_object_name
  and    foreign_application_id = x_attribute_application_id
  and    foreign_attribute_code = x_attribute_code
  and    unique_key_name = L_UNIQUE_KEY_NAME;

Line: 55


	  X_LAST_UPDATE_DATE => x_last_update_date,
	  X_LAST_UPDATED_BY => x_last_updated_by,
	  X_LAST_UPDATE_LOGIN => x_last_update_login);

Line: 66


	AK_FOREIGN_KEYS_PKG.DELETE_AFKC_ROW(
	  X_FOREIGN_KEY_NAME => X_LOV_FOREIGN_KEY_NAME,
	  X_ATTRIBUTE_APPLICATION_ID => 702,
	  X_ATTRIBUTE_CODE => X_ATTRIBUTE_CODE,
	  X_FOREIGN_KEY_SEQUENCE => 1);

Line: 71


	AK_FOREIGN_KEYS_PKG.DELETE_ROW(
	  X_FOREIGN_KEY_NAME => X_LOV_FOREIGN_KEY_NAME);

Line: 93


	  X_LAST_UPDATE_DATE => x_last_update_date,
	  X_LAST_UPDATED_BY => x_last_updated_by,
	  X_LAST_UPDATE_LOGIN => x_last_update_login);

Line: 97


	AK_FOREIGN_KEYS_PKG.UPDATE_ROW(
	  X_FOREIGN_KEY_NAME => X_LOV_FOREIGN_KEY_NAME,
	  X_DATABASE_OBJECT_NAME => X_DATABASE_OBJECT_NAME,
	  X_UNIQUE_KEY_NAME => L_UNIQUE_KEY_NAME,
	  X_APPLICATION_ID => 702,
	  X_FROM_TO_NAME => 'CONFIGURATOR',
	  X_FROM_TO_DESCRIPTION => null,
	  X_TO_FROM_NAME => null,
	  X_TO_FROM_DESCRIPTION => null,
	  X_LAST_UPDATE_DATE => x_last_update_date,
	  X_LAST_UPDATED_BY => x_last_updated_by,
	  X_LAST_UPDATE_LOGIN => x_last_update_login,
	  X_ATTRIBUTE_CATEGORY => NULL,
	  X_ATTRIBUTE1 => NULL,
	  X_ATTRIBUTE2 => NULL,
	  X_ATTRIBUTE3 => NULL,
	  X_ATTRIBUTE4 => NULL,
	  X_ATTRIBUTE5 => NULL,
	  X_ATTRIBUTE6 => NULL,
	  X_ATTRIBUTE7 => NULL,
	  X_ATTRIBUTE8 => NULL,
	  X_ATTRIBUTE9 => NULL,
	  X_ATTRIBUTE10 => NULL,
	  X_ATTRIBUTE11 => NULL,
	  X_ATTRIBUTE12 => NULL,
	  X_ATTRIBUTE13 => NULL,
	  X_ATTRIBUTE14 => NULL,
	  X_ATTRIBUTE15 => NULL);

Line: 141


  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER)
IS
  row_id varchar2(30);

Line: 148


  select CZ_AUTOSELECTION_RANGES_S.NEXTVAL into L_sequence from dual;

Line: 150


  AK_FOREIGN_KEYS_PKG.INSERT_ROW(
	  X_ROWID => row_id,
	  X_FOREIGN_KEY_NAME => X_FOREIGN_KEY_NAME,
	  X_DATABASE_OBJECT_NAME => X_DATABASE_OBJECT_NAME,
	  X_UNIQUE_KEY_NAME => X_UNIQUE_KEY_NAME,
	  X_APPLICATION_ID => 702,
	  X_FROM_TO_NAME => 'CONFIGURATOR',
	  X_FROM_TO_DESCRIPTION => null,
	  X_TO_FROM_NAME => null,
	  X_TO_FROM_DESCRIPTION => null,
	  X_CREATION_DATE => x_creation_date,
	  X_CREATED_BY => x_created_by,
	  X_LAST_UPDATE_DATE => x_last_update_date,
	  X_LAST_UPDATED_BY => x_last_updated_by,
	  X_LAST_UPDATE_LOGIN => x_last_update_login,
	  X_ATTRIBUTE_CATEGORY => NULL,
	  X_ATTRIBUTE1 => NULL,
	  X_ATTRIBUTE2 => NULL,
	  X_ATTRIBUTE3 => NULL,
	  X_ATTRIBUTE4 => NULL,
	  X_ATTRIBUTE5 => NULL,
	  X_ATTRIBUTE6 => NULL,
	  X_ATTRIBUTE7 => NULL,
	  X_ATTRIBUTE8 => NULL,
	  X_ATTRIBUTE9 => NULL,
	  X_ATTRIBUTE10 => NULL,
	  X_ATTRIBUTE11 => NULL,
	  X_ATTRIBUTE12 => NULL,
	  X_ATTRIBUTE13 => NULL,
	  X_ATTRIBUTE14 => NULL,
	  X_ATTRIBUTE15 => NULL);

Line: 182


  AK_FOREIGN_KEYS_PKG.INSERT_AFKC_ROW(
	  X_ROWID => row_id,

	  X_FOREIGN_KEY_NAME => X_FOREIGN_KEY_NAME,
	  X_ATTRIBUTE_APPLICATION_ID => X_ATTRIBUTE_APPLICATION_ID,
	  X_ATTRIBUTE_CODE => X_ATTRIBUTE_CODE,
	  X_FOREIGN_KEY_SEQUENCE => 1,
	  X_CREATION_DATE => x_creation_date,
	  X_CREATED_BY => x_created_by,
	  X_LAST_UPDATE_DATE => x_last_update_date,
	  X_LAST_UPDATED_BY => x_last_updated_by,
	  X_LAST_UPDATE_LOGIN => x_last_update_login,
	  X_ATTRIBUTE_CATEGORY => NULL,
	  X_ATTRIBUTE1 => NULL,
	  X_ATTRIBUTE2 => NULL,
	  X_ATTRIBUTE3 => NULL,
	  X_ATTRIBUTE4 => NULL,
	  X_ATTRIBUTE5 => NULL,
	  X_ATTRIBUTE6 => NULL,
	  X_ATTRIBUTE7 => NULL,
	  X_ATTRIBUTE8 => NULL,
	  X_ATTRIBUTE9 => NULL,
	  X_ATTRIBUTE10 => NULL,
	  X_ATTRIBUTE11 => NULL,
	  X_ATTRIBUTE12 => NULL,
	  X_ATTRIBUTE13 => NULL,
	  X_ATTRIBUTE14 => NULL,
	  X_ATTRIBUTE15 => NULL);

Line: 233


  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_REGION_APPLICATION_ID in NUMBER,
  X_REGION_CODE in VARCHAR2,
  X_DISPLAY_VALUE_LENGTH in NUMBER,
  X_TABLE_NAME in VARCHAR2,
  X_OBJ_ATTR_SUCCESS in out NOCOPY VARCHAR2,
  x_data_source_type in VARCHAR2,
  x_data_storage_type in VARCHAR2
) IS
-- * local variables * --
  L_LOV_REGION_CODE varchar2(30)		:= null;

Line: 257


  select 1
  from   ak_object_attributes
  where  database_object_name = x_database_object_name
  and    attribute_application_id = x_attribute_application_id
  and    attribute_code = x_attribute_code;

Line: 264


  select foreign_key_name
  from   ak_foreign_key_mapping_v
  where  database_object_name = x_database_object_name
  and    foreign_application_id = x_attribute_application_id
  and    foreign_attribute_code = x_attribute_code
  and    unique_key_name = L_UNIQUE_KEY_NAME;

Line: 272


	select unique_key_name from ak_unique_keys
	  where unique_key_name = L_UNIQUE_KEY_NAME;

Line: 292


	  -- * no need to insert foreign key if one already exists * --
	  open cz;

Line: 311


	  	X_LAST_UPDATE_DATE => x_last_update_date,
	  	X_LAST_UPDATED_BY => x_last_updated_by,
	  	X_LAST_UPDATE_LOGIN => x_last_update_login);

Line: 332


ak_object_attributes_pkg.insert_row(
  X_ROWID => row_id,
  X_DATABASE_OBJECT_NAME => x_database_object_name,
  X_ATTRIBUTE_APPLICATION_ID => x_attribute_application_id,
  X_ATTRIBUTE_CODE => x_attribute_code,
  X_COLUMN_NAME => column_name_default,
  X_ATTRIBUTE_LABEL_LENGTH => x_attribute_label_length,
  X_BOLD => x_bold,
  X_ITALIC => x_italic,
  X_VERTICAL_ALIGNMENT => x_vertical_alignment,
  X_HORIZONTAL_ALIGNMENT => x_horizontal_alignment,
  X_ATTRIBUTE_LABEL_LONG => x_attribute_label_long,
  X_DATA_SOURCE_TYPE => x_data_source_type,
  X_DATA_STORAGE_TYPE => x_data_storage_type,
  X_TABLE_NAME => x_table_name,
  X_BASE_TABLE_COLUMN_NAME => NULL,
  X_REQUIRED_FLAG => 'N',
  X_DISPLAY_VALUE_LENGTH => X_DISPLAY_VALUE_LENGTH,
  X_LOV_REGION_APPLICATION_ID => L_LOV_REGION_APPLICATION_ID,
  X_LOV_REGION_CODE => L_LOV_REGION_CODE,
  X_LOV_FOREIGN_KEY_NAME => L_LOV_FOREIGN_KEY_NAME,
  X_LOV_ATTRIBUTE_APPLICATION_ID => L_LOV_ATTRIBUTE_APPLICATION_ID,
  X_LOV_ATTRIBUTE_CODE => L_LOV_ATTRIBUTE_CODE,
  X_DEFAULTING_API_PKG => NULL,
  X_DEFAULTING_API_PROC => NULL,
  X_VALIDATION_API_PKG => NULL,
  X_VALIDATION_API_PROC => NULL,
  X_DEFAULT_VALUE_VARCHAR2 => X_DEFAULT_VALUE_VARCHAR2,
  X_DEFAULT_VALUE_NUMBER => X_DEFAULT_VALUE_NUMBER,
  X_DEFAULT_VALUE_DATE => X_DEFAULT_VALUE_DATE,
  X_CREATION_DATE => x_creation_date,
  X_CREATED_BY => x_created_by,
  X_LAST_UPDATE_DATE => x_last_update_date,
  X_LAST_UPDATED_BY => x_last_updated_by,
  X_LAST_UPDATE_LOGIN => x_last_update_login,
  X_ATTRIBUTE_CATEGORY => NULL,
  X_ATTRIBUTE1 => NULL,
  X_ATTRIBUTE2 => NULL,
  X_ATTRIBUTE3 => NULL,
  X_ATTRIBUTE4 => NULL,
  X_ATTRIBUTE5 => NULL,
  X_ATTRIBUTE6 => NULL,
  X_ATTRIBUTE7 => NULL,
  X_ATTRIBUTE8 => NULL,
  X_ATTRIBUTE9 => NULL,
  X_ATTRIBUTE10 => NULL,
  X_ATTRIBUTE11 => NULL,
  X_ATTRIBUTE12 => NULL,
  X_ATTRIBUTE13 => NULL,
  X_ATTRIBUTE14 => NULL,
  X_ATTRIBUTE15 => NULL
);

Line: 414


  X_LAST_UPDATE_DATE => x_last_update_date,
  X_LAST_UPDATED_BY => x_last_updated_by,
  X_LAST_UPDATE_LOGIN => x_last_update_login,
  x_display_value_length => x_display_value_length,
  X_COMMIT => 'Y'
);

Line: 446


  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER)
IS
-- * local variables * --
  L_LOV_FOREIGN_KEY_NAME varchar2(30)	:= null;

Line: 464


  select region_application_id,region_code
  from   ak_regions
  where  database_object_name = x_database_object_name;

Line: 469


	select unique_key_name from ak_unique_keys
	  where unique_key_name = L_UNIQUE_KEY_NAME;

Line: 502


	  X_LAST_UPDATE_DATE => x_last_update_date,
	  X_LAST_UPDATED_BY => x_last_updated_by,
	  X_LAST_UPDATE_LOGIN => x_last_update_login);

Line: 509


  update ak_object_attributes set
	BOLD = X_BOLD,
	ITALIC = X_ITALIC,
	VERTICAL_ALIGNMENT = X_VERTICAL_ALIGNMENT,
	HORIZONTAL_ALIGNMENT = X_HORIZONTAL_ALIGNMENT,
	DEFAULT_VALUE_VARCHAR2 = X_DEFAULT_VALUE_VARCHAR2,
	DEFAULT_VALUE_NUMBER = X_DEFAULT_VALUE_NUMBER,
	DEFAULT_VALUE_DATE = X_DEFAULT_VALUE_DATE,
	ATTRIBUTE_LABEL_LENGTH = X_ATTRIBUTE_LABEL_LENGTH,
	LOV_FOREIGN_KEY_NAME = L_LOV_FOREIGN_KEY_NAME,
	LOV_REGION_APPLICATION_ID = L_LOV_REGION_APPLICATION_ID,
	LOV_REGION_CODE = L_LOV_REGION_CODE,
	LOV_ATTRIBUTE_APPLICATION_ID = L_LOV_ATTRIBUTE_APPLICATION_ID,
	LOV_ATTRIBUTE_CODE = L_LOV_ATTRIBUTE_CODE,
	LAST_UPDATE_DATE = x_last_update_date,
	LAST_UPDATED_BY = x_last_updated_by,
	LAST_UPDATE_LOGIN = x_last_update_login
    where DATABASE_OBJECT_NAME = x_database_object_name
	and ATTRIBUTE_APPLICATION_ID = x_attribute_application_id
	and ATTRIBUTE_CODE = x_attribute_code;

Line: 533


  update ak_object_attributes_tl set
	ATTRIBUTE_LABEL_LONG = X_ATTRIBUTE_LABEL_LONG,
	LAST_UPDATE_DATE = x_last_update_date,
	LAST_UPDATED_BY = x_last_updated_by,
	LAST_UPDATE_LOGIN = x_last_update_login
    where DATABASE_OBJECT_NAME = X_DATABASE_OBJECT_NAME
	and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
	and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
	and LANGUAGE = lang;

Line: 549


    update ak_region_items set
	  DEFAULT_VALUE_VARCHAR2 = X_DEFAULT_VALUE_VARCHAR2,
	  DEFAULT_VALUE_NUMBER = X_DEFAULT_VALUE_NUMBER,
	  DEFAULT_VALUE_DATE = X_DEFAULT_VALUE_DATE,
	  LOV_FOREIGN_KEY_NAME = L_LOV_FOREIGN_KEY_NAME,
	  LOV_REGION_APPLICATION_ID = L_LOV_REGION_APPLICATION_ID,
	  LOV_REGION_CODE = L_LOV_REGION_CODE,
	  LOV_ATTRIBUTE_APPLICATION_ID = L_LOV_ATTRIBUTE_APPLICATION_ID,
	  LOV_ATTRIBUTE_CODE = L_LOV_ATTRIBUTE_CODE,
	  LOV_DEFAULT_FLAG = L_LOV_DEFAULT_FLAG,
	  LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
	  LAST_UPDATED_BY = X_LAST_UPDATED_BY,
	  LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
	where REGION_APPLICATION_ID = L_REGION_APPLICATION_ID
	  and REGION_CODE = L_REGION_CODE
	  and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
	  and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE;