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.IGS_GE_MEASUREMENT_PKG SQL Statements

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

Line: 17


    x_last_update_date IN DATE DEFAULT NULL,
    x_last_updated_by IN NUMBER DEFAULT NULL,
    x_last_update_login IN NUMBER DEFAULT NULL
  ) as

    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     IGS_GE_MEASUREMENT
      WHERE    rowid = x_rowid;

Line: 35


    IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
		Close cur_old_ref_values;

Line: 37


	      Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

Line: 49


    IF (p_action = 'UPDATE') THEN
      new_references.creation_date := old_references.creation_date;

Line: 56


    new_references.last_update_date := x_last_update_date;

Line: 57


    new_references.last_updated_by := x_last_updated_by;

Line: 58


    new_references.last_update_login := x_last_update_login;

Line: 115


      SELECT   rowid
      FROM     IGS_GE_MEASUREMENT
      WHERE    measurement_cd = x_measurement_cd
      FOR UPDATE NOWAIT;

Line: 144


    x_last_update_date IN DATE DEFAULT NULL,
    x_last_updated_by IN NUMBER DEFAULT NULL,
    x_last_update_login IN NUMBER DEFAULT NULL
  ) as
  BEGIN

    Set_Column_Values (
      p_action,
      x_rowid,
      x_measurement_cd,
      x_description,
      x_measurement_type,
      x_closed_ind,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 164


    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to Before Insert.
	 IF GET_PK_FOR_VALIDATION ( new_references.measurement_cd ) THEN
		Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

Line: 172


    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to Before Update.
      Check_Constraints;

Line: 176


    ELSIF (p_action = 'DELETE') THEN
      -- Call all the procedures related to Before Delete.
      Check_Child_Existance;

Line: 179


    ELSIF (p_action = 'VALIDATE_INSERT') THEN
      -- Call all the procedures related to Before Insert.
	 IF GET_PK_FOR_VALIDATION ( new_references.measurement_cd ) THEN
		Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

Line: 187


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      -- Call all the procedures related to Before Update.
      Check_Constraints;

Line: 190


    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      -- Call all the procedures related to Before Delete.
      Check_Child_Existance;

Line: 205


    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to After Insert.
      Null;

Line: 208


    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to After Update.
      Null;

Line: 211


    ELSIF (p_action = 'DELETE') THEN
      -- Call all the procedures related to After Delete.
      Null;

Line: 219


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_MEASUREMENT_CD in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_MEASUREMENT_TYPE in VARCHAR2,
  X_CLOSED_IND in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) as
    cursor C is select ROWID from IGS_GE_MEASUREMENT
      where MEASUREMENT_CD = X_MEASUREMENT_CD;

Line: 229


    X_LAST_UPDATE_DATE DATE;

Line: 230


    X_LAST_UPDATED_BY NUMBER;

Line: 231


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 233


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 235


    X_LAST_UPDATED_BY := 1;

Line: 236


    X_LAST_UPDATE_LOGIN := 0;

Line: 238


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 239


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 242


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 243


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 253


  p_action => 'INSERT',
  x_rowid => X_ROWID,
  x_measurement_cd => X_MEASUREMENT_CD,
  x_description => X_DESCRIPTION,
  x_measurement_type => X_MEASUREMENT_TYPE,
  x_closed_ind => NVL(X_CLOSED_IND,'N'),
  x_created_by => X_LAST_UPDATED_BY,
  x_creation_date => X_LAST_UPDATE_DATE,
  x_last_updated_by => X_LAST_UPDATED_BY,
  x_last_update_date => X_LAST_UPDATE_DATE,
  x_last_update_login => X_LAST_UPDATE_LOGIN
);

Line: 266


  insert into IGS_GE_MEASUREMENT (
    MEASUREMENT_CD,
    DESCRIPTION,
    MEASUREMENT_TYPE,
    CLOSED_IND,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    NEW_REFERENCES.MEASUREMENT_CD,
    NEW_REFERENCES.DESCRIPTION,
    NEW_REFERENCES.MEASUREMENT_TYPE,
    NEW_REFERENCES.CLOSED_IND,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 297


    p_action => 'INSERT',
    x_rowid => X_ROWID
);

Line: 300


end INSERT_ROW;

Line: 309


  cursor c1 is select
      DESCRIPTION,
      MEASUREMENT_TYPE,
      CLOSED_IND
    from IGS_GE_MEASUREMENT
    where ROWID = X_ROWID
    for update nowait;

Line: 323


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

Line: 343


procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_MEASUREMENT_CD in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_MEASUREMENT_TYPE in VARCHAR2,
  X_CLOSED_IND in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) as
    X_LAST_UPDATE_DATE DATE;

Line: 352


    X_LAST_UPDATED_BY NUMBER;

Line: 353


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 355


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 357


    X_LAST_UPDATED_BY := 1;

Line: 358


    X_LAST_UPDATE_LOGIN := 0;

Line: 360


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 361


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 364


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 365


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 375


    p_action => 'UPDATE',
    x_rowid => X_ROWID,
    x_measurement_cd => X_MEASUREMENT_CD,
    x_description => X_DESCRIPTION,
    x_measurement_type => X_MEASUREMENT_TYPE,
    x_closed_ind => X_CLOSED_IND,
    x_created_by => X_LAST_UPDATED_BY,
    x_creation_date => X_LAST_UPDATE_DATE,
    x_last_updated_by => X_LAST_UPDATED_BY,
    x_last_update_date => X_LAST_UPDATE_DATE,
    x_last_update_login => X_LAST_UPDATE_LOGIN
);

Line: 388


  update IGS_GE_MEASUREMENT set
    DESCRIPTION =   NEW_REFERENCES.DESCRIPTION,
    MEASUREMENT_TYPE =   NEW_REFERENCES.MEASUREMENT_TYPE,
    CLOSED_IND =   NEW_REFERENCES.CLOSED_IND,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
    where ROWID = X_ROWID
  ;

Line: 402


    p_action => 'UPDATE',
    x_rowid => X_ROWID
);

Line: 406


end UPDATE_ROW;

Line: 416


  cursor c1 is select rowid from IGS_GE_MEASUREMENT
     where MEASUREMENT_CD = X_MEASUREMENT_CD
  ;

Line: 425


    INSERT_ROW (
     X_ROWID,
     X_MEASUREMENT_CD,
     X_DESCRIPTION,
     X_MEASUREMENT_TYPE,
     X_CLOSED_IND,
     X_MODE);

Line: 435


  UPDATE_ROW (
   X_ROWID,
   X_MEASUREMENT_CD,
   X_DESCRIPTION,
   X_MEASUREMENT_TYPE,
   X_CLOSED_IND,
   X_MODE);

Line: 444


procedure DELETE_ROW (
  X_ROWID in VARCHAR2
) as
begin
Before_DML (
    p_action => 'DELETE',
    x_rowid => X_ROWID
);

Line: 453


  delete from IGS_GE_MEASUREMENT
    where ROWID = X_ROWID;

Line: 459


    p_action => 'DELETE',
    x_rowid => X_ROWID
);

Line: 462


end DELETE_ROW;