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.AMS_COLUMNS_METADATA_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_COLUMNS_METADATA_ID in NUMBER,
  X_SEARCH_EXCLUSION_GROUP in VARCHAR2,
  X_SEARCH_OPERATOR_EXCLUSION_ID in NUMBER,
  X_SEARCH_COLSPAN in VARCHAR2,
  X_APPLICATION_ID in NUMBER,
  X_SEARCH_CONDITION_ALLOWED_FLA in VARCHAR2,
  X_HTML_FORM_PARAM in VARCHAR2,
  X_DB_TABLE_NAME in VARCHAR2,
  X_DB_COLUMN_NAME in VARCHAR2,
  X_SEARCH_TYPE in VARCHAR2,
  X_SEARCH_QUERY in VARCHAR2,
  X_SEARCH_PARAM1 in VARCHAR2,
  X_SECURITY_GROUP_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_OBJECT_ATTRIBUTE in VARCHAR2,
  X_OBJECT_TYPE in VARCHAR2,
  X_ACTIVITY_TYPE_CODE in VARCHAR2,
  X_AK_REGION_CODE in VARCHAR2,
  X_AK_ATTRIBUTE_CODE in VARCHAR2,
  X_SEEDED_FLAG in VARCHAR2,
  X_SEARCH_DISPLAY_ALLOWED_FLAG in VARCHAR2,
  X_SEARCH_GROUP in VARCHAR2,
  X_SEARCH_PARAM11 in VARCHAR2,
  X_SEARCH_PARAM12 in VARCHAR2,
  X_SEARCH_PARAM13 in VARCHAR2,
  X_SEARCH_PARAM14 in VARCHAR2,
  X_SEARCH_PARAM15 in VARCHAR2,
  X_OBJECT_RULE_ID in NUMBER,
  X_SEARCH_PARAM2 in VARCHAR2,
  X_SEARCH_PARAM3 in VARCHAR2,
  X_SEARCH_PARAM4 in VARCHAR2,
  X_SEARCH_PARAM5 in VARCHAR2,
  X_SEARCH_PARAM6 in VARCHAR2,
  X_SEARCH_PARAM7 in VARCHAR2,
  X_SEARCH_PARAM8 in VARCHAR2,
  X_SEARCH_PARAM9 in VARCHAR2,
  X_SEARCH_PARAM10 in VARCHAR2,
  X_SEARCH_DISPLAY_SCALE 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

begin
  insert into AMS_COLUMNS_METADATA (
    SEARCH_EXCLUSION_GROUP,
    SEARCH_OPERATOR_EXCLUSION_ID,
    SEARCH_COLSPAN,
    APPLICATION_ID,
    SEARCH_CONDITION_ALLOWED_FLAG,
    HTML_FORM_PARAM,
    DB_TABLE_NAME,
    DB_COLUMN_NAME,
    SEARCH_TYPE,
    SEARCH_QUERY,
    SEARCH_PARAM1,
    LAST_UPDATE_DATE,
    --SECURITY_GROUP_ID,
    OBJECT_VERSION_NUMBER,
    OBJECT_ATTRIBUTE,
    OBJECT_TYPE,
    ACTIVITY_TYPE_CODE,
    AK_REGION_CODE,
    AK_ATTRIBUTE_CODE,
    SEEDED_FLAG,
    SEARCH_DISPLAY_ALLOWED_FLAG,
    SEARCH_GROUP,
    COLUMNS_METADATA_ID,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    SEARCH_PARAM11,
    SEARCH_PARAM12,
    SEARCH_PARAM13,
    SEARCH_PARAM14,
    SEARCH_PARAM15,
    OBJECT_RULE_ID,
    SEARCH_PARAM2,
    SEARCH_PARAM3,
    SEARCH_PARAM4,
    SEARCH_PARAM5,
    SEARCH_PARAM6,
    SEARCH_PARAM7,
    SEARCH_PARAM8,
    SEARCH_PARAM9,
    SEARCH_PARAM10,
    SEARCH_DISPLAY_SCALE
  ) values (
    X_SEARCH_EXCLUSION_GROUP,
    X_SEARCH_OPERATOR_EXCLUSION_ID,
    X_SEARCH_COLSPAN,
    X_APPLICATION_ID,
    X_SEARCH_CONDITION_ALLOWED_FLA,
    X_HTML_FORM_PARAM,
    X_DB_TABLE_NAME,
    X_DB_COLUMN_NAME,
    X_SEARCH_TYPE,
    X_SEARCH_QUERY,
    X_SEARCH_PARAM1,
    X_LAST_UPDATE_DATE,
    --X_SECURITY_GROUP_ID,
    X_OBJECT_VERSION_NUMBER,
    X_OBJECT_ATTRIBUTE,
    X_OBJECT_TYPE,
    X_ACTIVITY_TYPE_CODE,
    X_AK_REGION_CODE,
    X_AK_ATTRIBUTE_CODE,
    X_SEEDED_FLAG,
    X_SEARCH_DISPLAY_ALLOWED_FLAG,
    X_SEARCH_GROUP,
    X_COLUMNS_METADATA_ID,
    X_LAST_UPDATED_BY,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_SEARCH_PARAM11,
    X_SEARCH_PARAM12,
    X_SEARCH_PARAM13,
    X_SEARCH_PARAM14,
    X_SEARCH_PARAM15,
    X_OBJECT_RULE_ID,
    X_SEARCH_PARAM2,
    X_SEARCH_PARAM3,
    X_SEARCH_PARAM4,
    X_SEARCH_PARAM5,
    X_SEARCH_PARAM6,
    X_SEARCH_PARAM7,
    X_SEARCH_PARAM8,
    X_SEARCH_PARAM9,
    X_SEARCH_PARAM10,
    X_SEARCH_DISPLAY_SCALE
 );

Line: 141


end INSERT_ROW;

Line: 183


  cursor c1 is select
      SEARCH_EXCLUSION_GROUP,
      SEARCH_OPERATOR_EXCLUSION_ID,
      SEARCH_COLSPAN,
      APPLICATION_ID,
      SEARCH_CONDITION_ALLOWED_FLAG,
      HTML_FORM_PARAM,
      DB_TABLE_NAME,
      DB_COLUMN_NAME,
      SEARCH_TYPE,
      SEARCH_QUERY,
      SEARCH_PARAM1,
      SECURITY_GROUP_ID,
      OBJECT_VERSION_NUMBER,
      OBJECT_ATTRIBUTE,
      OBJECT_TYPE,
      ACTIVITY_TYPE_CODE,
      AK_REGION_CODE,
      AK_ATTRIBUTE_CODE,
      SEEDED_FLAG,
      SEARCH_DISPLAY_ALLOWED_FLAG,
      SEARCH_GROUP,
      SEARCH_PARAM11,
      SEARCH_PARAM12,
      SEARCH_PARAM13,
      SEARCH_PARAM14,
      SEARCH_PARAM15,
      OBJECT_RULE_ID,
      SEARCH_PARAM2,
      SEARCH_PARAM3,
      SEARCH_PARAM4,
      SEARCH_PARAM5,
      SEARCH_PARAM6,
      SEARCH_PARAM7,
      SEARCH_PARAM8,
      SEARCH_PARAM9,
      SEARCH_PARAM10,
      SEARCH_DISPLAY_SCALE,
      COLUMNS_METADATA_ID
    from AMS_COLUMNS_METADATA
    where COLUMNS_METADATA_ID = X_COLUMNS_METADATA_ID
    for update of COLUMNS_METADATA_ID nowait;

Line: 312


procedure UPDATE_ROW (
  X_COLUMNS_METADATA_ID in NUMBER,
  X_SEARCH_EXCLUSION_GROUP in VARCHAR2,
  X_SEARCH_OPERATOR_EXCLUSION_ID in NUMBER,
  X_SEARCH_COLSPAN in VARCHAR2,
  X_APPLICATION_ID in NUMBER,
  X_SEARCH_CONDITION_ALLOWED_FLA in VARCHAR2,
  X_HTML_FORM_PARAM in VARCHAR2,
  X_DB_TABLE_NAME in VARCHAR2,
  X_DB_COLUMN_NAME in VARCHAR2,
  X_SEARCH_TYPE in VARCHAR2,
  X_SEARCH_QUERY in VARCHAR2,
  X_SEARCH_PARAM1 in VARCHAR2,
  X_SECURITY_GROUP_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_OBJECT_ATTRIBUTE in VARCHAR2,
  X_OBJECT_TYPE in VARCHAR2,
  X_ACTIVITY_TYPE_CODE in VARCHAR2,
  X_AK_REGION_CODE in VARCHAR2,
  X_AK_ATTRIBUTE_CODE in VARCHAR2,
  X_SEEDED_FLAG in VARCHAR2,
  X_SEARCH_DISPLAY_ALLOWED_FLAG in VARCHAR2,
  X_SEARCH_GROUP in VARCHAR2,
  X_SEARCH_PARAM11 in VARCHAR2,
  X_SEARCH_PARAM12 in VARCHAR2,
  X_SEARCH_PARAM13 in VARCHAR2,
  X_SEARCH_PARAM14 in VARCHAR2,
  X_SEARCH_PARAM15 in VARCHAR2,
  X_OBJECT_RULE_ID in NUMBER,
  X_SEARCH_PARAM2 in VARCHAR2,
  X_SEARCH_PARAM3 in VARCHAR2,
  X_SEARCH_PARAM4 in VARCHAR2,
  X_SEARCH_PARAM5 in VARCHAR2,
  X_SEARCH_PARAM6 in VARCHAR2,
  X_SEARCH_PARAM7 in VARCHAR2,
  X_SEARCH_PARAM8 in VARCHAR2,
  X_SEARCH_PARAM9 in VARCHAR2,
  X_SEARCH_PARAM10 in VARCHAR2,
  X_SEARCH_DISPLAY_SCALE in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update AMS_COLUMNS_METADATA set
    SEARCH_EXCLUSION_GROUP = X_SEARCH_EXCLUSION_GROUP,
    SEARCH_OPERATOR_EXCLUSION_ID = X_SEARCH_OPERATOR_EXCLUSION_ID,
    SEARCH_COLSPAN = X_SEARCH_COLSPAN,
    APPLICATION_ID = X_APPLICATION_ID,
    SEARCH_CONDITION_ALLOWED_FLAG = X_SEARCH_CONDITION_ALLOWED_FLA,
    HTML_FORM_PARAM = X_HTML_FORM_PARAM,
    DB_TABLE_NAME = X_DB_TABLE_NAME,
    DB_COLUMN_NAME = X_DB_COLUMN_NAME,
    SEARCH_TYPE = X_SEARCH_TYPE,
    SEARCH_QUERY = X_SEARCH_QUERY,
    SEARCH_PARAM1 = X_SEARCH_PARAM1,
    --SECURITY_GROUP_ID = X_SECURITY_GROUP_ID,
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    OBJECT_ATTRIBUTE = X_OBJECT_ATTRIBUTE,
    OBJECT_TYPE = X_OBJECT_TYPE,
    ACTIVITY_TYPE_CODE = X_ACTIVITY_TYPE_CODE,
    AK_REGION_CODE = X_AK_REGION_CODE,
    AK_ATTRIBUTE_CODE = X_AK_ATTRIBUTE_CODE,
    SEEDED_FLAG = X_SEEDED_FLAG,
    SEARCH_DISPLAY_ALLOWED_FLAG = X_SEARCH_DISPLAY_ALLOWED_FLAG,
    SEARCH_GROUP = X_SEARCH_GROUP,
    SEARCH_PARAM11 = X_SEARCH_PARAM11,
    SEARCH_PARAM12 = X_SEARCH_PARAM12,
    SEARCH_PARAM13 = X_SEARCH_PARAM13,
    SEARCH_PARAM14 = X_SEARCH_PARAM14,
    SEARCH_PARAM15 = X_SEARCH_PARAM15,
    OBJECT_RULE_ID = X_OBJECT_RULE_ID,
    SEARCH_PARAM2 = X_SEARCH_PARAM2,
    SEARCH_PARAM3 = X_SEARCH_PARAM3,
    SEARCH_PARAM4 = X_SEARCH_PARAM4,
    SEARCH_PARAM5 = X_SEARCH_PARAM5,
    SEARCH_PARAM6 = X_SEARCH_PARAM6,
    SEARCH_PARAM7 = X_SEARCH_PARAM7,
    SEARCH_PARAM8 = X_SEARCH_PARAM8,
    SEARCH_PARAM9 = X_SEARCH_PARAM9,
    SEARCH_PARAM10 = X_SEARCH_PARAM10,
    SEARCH_DISPLAY_SCALE = X_SEARCH_DISPLAY_SCALE,
    COLUMNS_METADATA_ID = X_COLUMNS_METADATA_ID,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where COLUMNS_METADATA_ID = X_COLUMNS_METADATA_ID;

Line: 403


end UPDATE_ROW;

Line: 405


procedure DELETE_ROW (
  X_COLUMNS_METADATA_ID in NUMBER
) is
begin
  delete from AMS_COLUMNS_METADATA
  where COLUMNS_METADATA_ID = X_COLUMNS_METADATA_ID;

Line: 416


end DELETE_ROW;

Line: 468


 select object_version_number, columns_metadata_id
  from    AMS_COLUMNS_METADATA
--  where OBJECT_TYPE = X_OBJECT_TYPE
--  and OBJECT_ATTRIBUTE = X_OBJECT_ATTRIBUTE
--  and nvl(ACTIVITY_TYPE_CODE,0) = nvl(X_ACTIVITY_TYPE_CODE, 0)
--  and HTML_FORM_PARAM = X_HTML_FORM_PARAM
--  and APPLICATION_ID = X_APPLICATION_ID;

Line: 479


  select 'x'
  from  AMS_COLUMNS_METADATA
--  where OBJECT_TYPE = X_OBJECT_TYPE
--  and OBJECT_ATTRIBUTE = X_OBJECT_ATTRIBUTE
--  and nvl(ACTIVITY_TYPE_CODE,0) = nvl(X_ACTIVITY_TYPE_CODE, 0)
--  and HTML_FORM_PARAM = X_HTML_FORM_PARAM
--  and APPLICATION_ID = X_APPLICATION_ID;

Line: 489


  select AMS_COLUMNS_METADATA_S.nextval
  from dual;

Line: 511


		AMS_COLUMNS_METADATA_PKG.INSERT_ROW (
			X_ROWID => l_row_id,
			X_COLUMNS_METADATA_ID => l_COLUMNS_METADATA_ID,
			X_SEARCH_EXCLUSION_GROUP => X_SEARCH_EXCLUSION_GROUP,
			X_SEARCH_OPERATOR_EXCLUSION_ID => X_SEARCH_OPERATOR_EXCLUSION_ID,
			X_SEARCH_COLSPAN => X_SEARCH_COLSPAN,
			X_APPLICATION_ID => X_APPLICATION_ID,
			X_SEEDED_FLAG => X_SEEDED_FLAG,
			X_SEARCH_CONDITION_ALLOWED_FLA => X_SEARCH_CONDITION_ALLOWED_FLA,
			X_HTML_FORM_PARAM => X_HTML_FORM_PARAM,
			X_DB_TABLE_NAME => X_DB_TABLE_NAME,
			X_DB_COLUMN_NAME => X_DB_COLUMN_NAME,
			X_SEARCH_TYPE => X_SEARCH_TYPE,
			X_SEARCH_QUERY => X_SEARCH_QUERY,
			X_SEARCH_PARAM1 => X_SEARCH_PARAM1,
			X_SECURITY_GROUP_ID => X_SECURITY_GROUP_ID,
			X_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER,
			X_OBJECT_ATTRIBUTE => X_OBJECT_ATTRIBUTE,
			X_OBJECT_TYPE => X_OBJECT_TYPE,
			X_ACTIVITY_TYPE_CODE => X_ACTIVITY_TYPE_CODE,
			X_AK_REGION_CODE => X_AK_REGION_CODE,
			X_AK_ATTRIBUTE_CODE => X_AK_ATTRIBUTE_CODE,
			X_SEARCH_DISPLAY_ALLOWED_FLAG => X_SEARCH_DISPLAY_ALLOWED_FLAG,
			X_SEARCH_GROUP => X_SEARCH_GROUP,
			X_SEARCH_PARAM11 => X_SEARCH_PARAM11,
			X_SEARCH_PARAM12 => X_SEARCH_PARAM12,
			X_SEARCH_PARAM13 => X_SEARCH_PARAM13,
			X_SEARCH_PARAM14 => X_SEARCH_PARAM14,
			X_SEARCH_PARAM15 => X_SEARCH_PARAM15,
			X_OBJECT_RULE_ID => X_OBJECT_RULE_ID,
			X_SEARCH_PARAM2 => X_SEARCH_PARAM2,
			X_SEARCH_PARAM3 => X_SEARCH_PARAM3,
			X_SEARCH_PARAM4 => X_SEARCH_PARAM4,
			X_SEARCH_PARAM5 => X_SEARCH_PARAM5,
			X_SEARCH_PARAM6 => X_SEARCH_PARAM6,
			X_SEARCH_PARAM7 => X_SEARCH_PARAM7,
			X_SEARCH_PARAM8 => X_SEARCH_PARAM8,
			X_SEARCH_PARAM9 => X_SEARCH_PARAM9,
			X_SEARCH_PARAM10 => X_SEARCH_PARAM10,
			X_SEARCH_DISPLAY_SCALE => X_SEARCH_DISPLAY_SCALE,
			X_CREATION_DATE => sysdate,
			X_CREATED_BY => l_user_id,
			X_LAST_UPDATE_DATE => sysdate,
			X_LAST_UPDATED_BY => l_user_id,
			X_LAST_UPDATE_LOGIN => 0
			);

Line: 564


		AMS_COLUMNS_METADATA_PKG.UPDATE_ROW(
			X_COLUMNS_METADATA_ID => l_COLUMNS_METADATA_ID,
			X_SEARCH_EXCLUSION_GROUP => X_SEARCH_EXCLUSION_GROUP,
			X_SEARCH_OPERATOR_EXCLUSION_ID => X_SEARCH_OPERATOR_EXCLUSION_ID,
			X_SEARCH_COLSPAN => X_SEARCH_COLSPAN,
			X_APPLICATION_ID => X_APPLICATION_ID,
			X_SEEDED_FLAG => X_SEEDED_FLAG,
			X_SEARCH_CONDITION_ALLOWED_FLA => X_SEARCH_CONDITION_ALLOWED_FLA,
			X_HTML_FORM_PARAM => X_HTML_FORM_PARAM,
			X_DB_TABLE_NAME => X_DB_TABLE_NAME,
			X_DB_COLUMN_NAME => X_DB_COLUMN_NAME,
			X_SEARCH_TYPE => X_SEARCH_TYPE,
			X_SEARCH_QUERY => X_SEARCH_QUERY,
			X_SEARCH_PARAM1 => X_SEARCH_PARAM1,
			X_SECURITY_GROUP_ID => X_SECURITY_GROUP_ID,
			X_OBJECT_VERSION_NUMBER => l_obj_verno,
			X_OBJECT_ATTRIBUTE => X_OBJECT_ATTRIBUTE,
			X_OBJECT_TYPE => X_OBJECT_TYPE,
			X_ACTIVITY_TYPE_CODE => X_ACTIVITY_TYPE_CODE,
			X_AK_REGION_CODE => X_AK_REGION_CODE,
			X_AK_ATTRIBUTE_CODE => X_AK_ATTRIBUTE_CODE,
			X_SEARCH_DISPLAY_ALLOWED_FLAG => X_SEARCH_DISPLAY_ALLOWED_FLAG,
			X_SEARCH_GROUP => X_SEARCH_GROUP,
			X_SEARCH_PARAM11 => X_SEARCH_PARAM11,
			X_SEARCH_PARAM12 => X_SEARCH_PARAM12,
			X_SEARCH_PARAM13 => X_SEARCH_PARAM13,
			X_SEARCH_PARAM14 => X_SEARCH_PARAM14,
			X_SEARCH_PARAM15 => X_SEARCH_PARAM15,
			X_OBJECT_RULE_ID => X_OBJECT_RULE_ID,
			X_SEARCH_PARAM2 => X_SEARCH_PARAM2,
			X_SEARCH_PARAM3 => X_SEARCH_PARAM3,
			X_SEARCH_PARAM4 => X_SEARCH_PARAM4,
			X_SEARCH_PARAM5 => X_SEARCH_PARAM5,
			X_SEARCH_PARAM6 => X_SEARCH_PARAM6,
			X_SEARCH_PARAM7 => X_SEARCH_PARAM7,
			X_SEARCH_PARAM8 => X_SEARCH_PARAM8,
			X_SEARCH_PARAM9 => X_SEARCH_PARAM9,
			X_SEARCH_PARAM10 => X_SEARCH_PARAM10,
			X_SEARCH_DISPLAY_SCALE => X_SEARCH_DISPLAY_SCALE,
			X_LAST_UPDATE_DATE => SYSDATE,
			X_LAST_UPDATED_BY => l_user_id,
			X_LAST_UPDATE_LOGIN => 0
			);