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_EN_ST_SPSHT_CTL_PKG SQL Statements

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

Line: 11


    x_delete_snapshot_ind IN VARCHAR2 DEFAULT NULL,
    x_comments IN VARCHAR2 DEFAULT NULL,
    x_creation_date IN DATE DEFAULT NULL,
    x_created_by IN NUMBER DEFAULT NULL,
    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_EN_ST_SPSHT_CTL
      WHERE    rowid = x_rowid;

Line: 33


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

Line: 35


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

Line: 44


    new_references.delete_snapshot_ind := x_delete_snapshot_ind;

Line: 46


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

Line: 53


    new_references.last_update_date := x_last_update_date;

Line: 54


    new_references.last_updated_by := x_last_updated_by;

Line: 55


    new_references.last_update_login := x_last_update_login;

Line: 64


  PROCEDURE BeforeRowUpdate1(
    p_inserting IN BOOLEAN DEFAULT FALSE,
    p_updating IN BOOLEAN DEFAULT FALSE,
    p_deleting IN BOOLEAN DEFAULT FALSE
    ) AS
      v_message_name  varchar2(30);

Line: 71


	-- Validate the Delete Snapshot Indicator.
	IF (old_references.delete_snapshot_ind <> new_references.delete_snapshot_ind) AND
	    (new_references.delete_snapshot_ind = 'Y') THEN
		IF IGS_ST_VAL_ESSC.stap_val_essc_delete (
				new_references.snapshot_dt_time,
				new_references.delete_snapshot_ind,
				v_message_name) = FALSE THEN

			    Fnd_Message.Set_Name('IGS', v_message_name);

Line: 86


  END BeforeRowUpdate1;

Line: 98


	ELSIF upper(column_name) = 'DELETE_SNAPSHOT_IND' THEN
	      new_references.delete_snapshot_ind := column_value;

Line: 102


	IF upper(column_name) = 'DELETE_SNAPSHOT_IND' OR
	       Column_name is null THEN
	       IF new_references.delete_snapshot_ind  NOT  IN ( 'Y' , 'N' )  THEN
		      Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');

Line: 131


      SELECT   rowid
      FROM     IGS_EN_ST_SPSHT_CTL
      WHERE    snapshot_dt_time = x_snapshot_dt_time
      FOR UPDATE NOWAIT;

Line: 156


    x_delete_snapshot_ind IN VARCHAR2 DEFAULT NULL,
    x_comments IN VARCHAR2 DEFAULT NULL,
    x_creation_date IN DATE DEFAULT NULL,
    x_created_by IN NUMBER DEFAULT NULL,
    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_snapshot_dt_time,
      x_delete_snapshot_ind,
      x_comments,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 179


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

Line: 190


    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to Before Update.
      BeforeRowUpdate1 ( p_updating => TRUE );

Line: 194


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

      Check_Child_Existance;

Line: 198


    ELSIF (p_action = 'VALIDATE_INSERT') THEN
      If Get_PK_For_Validation(
	new_references.snapshot_dt_time
         ) THEN
         FND_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

Line: 207


    ELSif (p_action = 'VALIDATE_UPDATE') THEN
      Check_constraints;

Line: 209


    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      CHECK_CHILD_EXISTANCE;

Line: 223


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

Line: 226


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

Line: 229


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

Line: 236


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_SNAPSHOT_DT_TIME in DATE,
  X_DELETE_SNAPSHOT_IND in VARCHAR2,
  X_COMMENTS in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    cursor C is select ROWID from IGS_EN_ST_SPSHT_CTL
      where SNAPSHOT_DT_TIME = X_SNAPSHOT_DT_TIME;

Line: 245


    X_LAST_UPDATE_DATE DATE;

Line: 246


    X_LAST_UPDATED_BY NUMBER;

Line: 247


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 251


    X_PROGRAM_UPDATE_DATE DATE;

Line: 253


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 255


    X_LAST_UPDATED_BY := 1;

Line: 256


    X_LAST_UPDATE_LOGIN := 0;

Line: 258


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 259


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 262


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 263


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 273


       X_PROGRAM_UPDATE_DATE := NULL;

Line: 275


       X_PROGRAM_UPDATE_DATE := SYSDATE;

Line: 283


    p_action => 'INSERT',
    x_rowid => X_ROWID,
    x_snapshot_dt_time => X_SNAPSHOT_DT_TIME,
    x_delete_snapshot_ind => NVL(X_DELETE_SNAPSHOT_IND,'Y'),
    x_comments => X_COMMENTS,
    x_creation_date => X_LAST_UPDATE_DATE ,
    x_created_by => X_LAST_UPDATED_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
  );

Line: 294


  insert into IGS_EN_ST_SPSHT_CTL (
    SNAPSHOT_DT_TIME,
    DELETE_SNAPSHOT_IND,
    COMMENTS,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    REQUEST_ID,
    PROGRAM_ID,
    PROGRAM_APPLICATION_ID,
    PROGRAM_UPDATE_DATE
  ) values (
    NEW_REFERENCES.SNAPSHOT_DT_TIME,
    NEW_REFERENCES.DELETE_SNAPSHOT_IND,
    NEW_REFERENCES.COMMENTS,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_REQUEST_ID,
    X_PROGRAM_ID,
    X_PROGRAM_APPLICATION_ID,
    X_PROGRAM_UPDATE_DATE
  );

Line: 330


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

Line: 333


end INSERT_ROW;

Line: 338


  X_DELETE_SNAPSHOT_IND in VARCHAR2,
  X_COMMENTS in VARCHAR2
) AS
  cursor c1 is select
      DELETE_SNAPSHOT_IND,
      COMMENTS
    from IGS_EN_ST_SPSHT_CTL
   where ROWID = X_ROWID
    for update nowait;

Line: 354


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

Line: 361


  if ( (tlinfo.DELETE_SNAPSHOT_IND = X_DELETE_SNAPSHOT_IND)
      AND ((tlinfo.COMMENTS = X_COMMENTS)
           OR ((tlinfo.COMMENTS is null)
               AND (X_COMMENTS is null)))
  ) then
    null;

Line: 375


procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_SNAPSHOT_DT_TIME in DATE,
  X_DELETE_SNAPSHOT_IND in VARCHAR2,
  X_COMMENTS in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    X_LAST_UPDATE_DATE DATE;

Line: 383


    X_LAST_UPDATED_BY NUMBER;

Line: 384


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 388


    X_PROGRAM_UPDATE_DATE DATE;

Line: 390


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 392


    X_LAST_UPDATED_BY := 1;

Line: 393


    X_LAST_UPDATE_LOGIN := 0;

Line: 395


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 396


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 399


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 400


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 409


    p_action => 'UPDATE',
    x_rowid => X_ROWID,
    x_snapshot_dt_time => X_SNAPSHOT_DT_TIME,
    x_delete_snapshot_ind => X_DELETE_SNAPSHOT_IND,
    x_comments => X_COMMENTS,
    x_creation_date => X_LAST_UPDATE_DATE ,
    x_created_by => X_LAST_UPDATED_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
  );

Line: 429


       X_PROGRAM_UPDATE_DATE :=
            OLD_REFERENCES.PROGRAM_UPDATE_DATE;

Line: 432


       X_PROGRAM_UPDATE_DATE := SYSDATE;

Line: 435


  update IGS_EN_ST_SPSHT_CTL set
    DELETE_SNAPSHOT_IND = NEW_REFERENCES.DELETE_SNAPSHOT_IND,
    COMMENTS = NEW_REFERENCES.COMMENTS,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    REQUEST_ID = X_REQUEST_ID,
    PROGRAM_ID = X_PROGRAM_ID,
    PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID,
    PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE
  where ROWID = X_ROWID
  ;

Line: 451


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

Line: 454


end UPDATE_ROW;

Line: 459


  X_DELETE_SNAPSHOT_IND in VARCHAR2,
  X_COMMENTS in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) AS
  cursor c1 is select rowid from IGS_EN_ST_SPSHT_CTL
     where SNAPSHOT_DT_TIME = X_SNAPSHOT_DT_TIME
  ;

Line: 472


    INSERT_ROW (
     X_ROWID,
     X_SNAPSHOT_DT_TIME,
     X_DELETE_SNAPSHOT_IND,
     X_COMMENTS,
     X_MODE);

Line: 481


  UPDATE_ROW (
   X_ROWID,
   X_SNAPSHOT_DT_TIME,
   X_DELETE_SNAPSHOT_IND,
   X_COMMENTS,
   X_MODE);

Line: 489


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

Line: 497


  delete from IGS_EN_ST_SPSHT_CTL
  where ROWID = X_ROWID;

Line: 503


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

Line: 506


end DELETE_ROW;