APPS.AMS_MET_TPL_HEADERS_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
  X_ROWID in out VARCHAR2,
  X_METRIC_TPL_HEADER_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_METRIC_TPL_HEADER_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_ARC_ACT_METRIC_USED_BY in VARCHAR2,
  X_ACT_METRIC_USED_BY_TYPE in VARCHAR2,
  X_ACT_METRIC_USED_BY_SUBTYPE 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 AMS_MET_TPL_HEADERS
    where METRIC_TPL_HEADER_ID = X_METRIC_TPL_HEADER_ID;

Line: 21

  insert into AMS_MET_TPL_HEADERS (
    METRIC_TPL_HEADER_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    OBJECT_VERSION_NUMBER,
    METRIC_TPL_HEADER_NAME,
    DESCRIPTION,
    ARC_ACT_METRIC_USED_BY,
    ACT_METRIC_USED_BY_TYPE,
    ACT_METRIC_USED_BY_SUBTYPE
  ) values(
    X_METRIC_TPL_HEADER_ID,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_OBJECT_VERSION_NUMBER,
    X_METRIC_TPL_HEADER_NAME,
    X_DESCRIPTION,
    X_ARC_ACT_METRIC_USED_BY,
    X_ACT_METRIC_USED_BY_TYPE,
    X_ACT_METRIC_USED_BY_SUBTYPE);

Line: 56

end INSERT_ROW;

Line: 58

procedure UPDATE_ROW (
  X_METRIC_TPL_HEADER_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_METRIC_TPL_HEADER_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_ARC_ACT_METRIC_USED_BY in VARCHAR2,
  X_ACT_METRIC_USED_BY_TYPE in VARCHAR2,
  X_ACT_METRIC_USED_BY_SUBTYPE in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update AMS_MET_TPL_HEADERS set
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    METRIC_TPL_HEADER_NAME = X_METRIC_TPL_HEADER_NAME,
    DESCRIPTION = X_DESCRIPTION,
    ARC_ACT_METRIC_USED_BY = X_ARC_ACT_METRIC_USED_BY,
    ACT_METRIC_USED_BY_TYPE = X_ACT_METRIC_USED_BY_TYPE,
    ACT_METRIC_USED_BY_SUBTYPE = X_ACT_METRIC_USED_BY_SUBTYPE,
    METRIC_TPL_HEADER_ID = X_METRIC_TPL_HEADER_ID,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where METRIC_TPL_HEADER_ID = X_METRIC_TPL_HEADER_ID;

Line: 87

end UPDATE_ROW;

Line: 89

procedure DELETE_ROW (
  X_METRIC_TPL_HEADER_ID in NUMBER
) is
begin
  delete from AMS_MET_TPL_HEADERS
  where METRIC_TPL_HEADER_ID = X_METRIC_TPL_HEADER_ID;

Line: 100

end DELETE_ROW;

Line: 120

  select object_version_number
  from    AMS_MET_TPL_HEADERS
  where  METRIC_TPL_HEADER_ID =  X_METRIC_TPL_HEADER_ID;

Line: 125

  select 'x'
  from    AMS_MET_TPL_HEADERS
  where  METRIC_TPL_HEADER_ID =  X_METRIC_TPL_HEADER_ID;

Line: 130

   select AMS_MET_TPL_HEADERS_ALL_S.nextval
   from dual;

Line: 153

    AMS_MET_TPL_HEADERS_PKG.INSERT_ROW(
	  X_ROWID   =>   l_row_id,
	  X_METRIC_TPL_HEADER_ID  =>  l_met_tpl_hdr_id,
	  X_OBJECT_VERSION_NUMBER  => l_obj_verno,
	  X_METRIC_TPL_HEADER_NAME  => X_METRIC_TPL_HEADER_NAME,
	  X_DESCRIPTION  => X_DESCRIPTION,
	  X_ARC_ACT_METRIC_USED_BY  => X_ARC_ACT_METRIC_USED_BY,
	  X_ACT_METRIC_USED_BY_TYPE  => X_ACT_METRIC_USED_BY_TYPE,
	  X_ACT_METRIC_USED_BY_SUBTYPE  => X_ACT_METRIC_USED_BY_SUBTYPE,
	  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: 173

    AMS_MET_TPL_HEADERS_PKG.UPDATE_ROW(
	  X_METRIC_TPL_HEADER_ID  =>  X_METRIC_TPL_HEADER_ID,
	  X_OBJECT_VERSION_NUMBER  => l_obj_verno + 1,
	  X_METRIC_TPL_HEADER_NAME  => X_METRIC_TPL_HEADER_NAME,
	  X_DESCRIPTION  => X_DESCRIPTION,
	  X_ARC_ACT_METRIC_USED_BY  => X_ARC_ACT_METRIC_USED_BY,
	  X_ACT_METRIC_USED_BY_TYPE  => X_ACT_METRIC_USED_BY_TYPE,
	  X_ACT_METRIC_USED_BY_SUBTYPE  => X_ACT_METRIC_USED_BY_SUBTYPE,
	  X_LAST_UPDATE_DATE	=>  SYSDATE,
	  X_LAST_UPDATED_BY =>  l_user_id,
	  X_LAST_UPDATE_LOGIN =>  0
	  );