APPS.IGS_GE_S_ERROR_LOG_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_S_ERROR_LOG
      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: 50

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

Line: 57

    new_references.last_update_date := x_last_update_date;

Line: 58

    new_references.last_updated_by := x_last_updated_by;

Line: 59

    new_references.last_update_login := x_last_update_login;

Line: 68

      SELECT   rowid
      FROM     IGS_GE_S_ERROR_LOG
      WHERE    sequence_number = x_sequence_number
      FOR UPDATE NOWAIT;

Line: 99

    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_sequence_number,
      x_program_unit,
      x_sql_error_num,
      x_sql_error_message,
      x_other_detail,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 120

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

Line: 129

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

Line: 132

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

Line: 135

    ELSIF (p_action = 'VALIDATE_INSERT') THEN
	IF Get_PK_For_Validation(
		new_references.sequence_number
	)THEN
		Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

Line: 143

    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      Null;

Line: 145

    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      Null;

Line: 159

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

Line: 162

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

Line: 165

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

Line: 173

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_SEQUENCE_NUMBER in NUMBER,
  X_PROGRAM_UNIT in VARCHAR2,
  X_SQL_ERROR_NUM in NUMBER,
  X_SQL_ERROR_MESSAGE in VARCHAR2,
  X_OTHER_DETAIL 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 ,
  X_REQUEST_ID IN NUMBER ,
  X_PROGRAM_ID IN NUMBER ,
  X_PROGRAM_APPLICATION_ID IN NUMBER ,
  X_PROGRAM_UPDATE_DATE IN DATE ,
  X_MODE in VARCHAR2 default 'R'
  ) as
    cursor C is select ROWID from IGS_GE_S_ERROR_LOG
      where SEQUENCE_NUMBER = X_SEQUENCE_NUMBER;

Line: 198

    p_action => 'INSERT',
    x_rowid => X_ROWID,
    x_sequence_number => X_SEQUENCE_NUMBER,
    x_program_unit => X_PROGRAM_UNIT,
    x_sql_error_num => X_SQL_ERROR_NUM,
    x_sql_error_message => X_SQL_ERROR_MESSAGE,
    x_other_detail => X_OTHER_DETAIL,
    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: 213

  insert into IGS_GE_S_ERROR_LOG (
    SEQUENCE_NUMBER,
    PROGRAM_UNIT,
    SQL_ERROR_NUM,
    SQL_ERROR_MESSAGE,
    OTHER_DETAIL,
    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.SEQUENCE_NUMBER,
    NEW_REFERENCES.PROGRAM_UNIT,
    NEW_REFERENCES.SQL_ERROR_NUM,
    NEW_REFERENCES.SQL_ERROR_MESSAGE,
    NEW_REFERENCES.OTHER_DETAIL,
    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: 254

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

Line: 257

end INSERT_ROW;

Line: 267

  cursor c1 is select
      PROGRAM_UNIT,
      SQL_ERROR_NUM,
      SQL_ERROR_MESSAGE,
      OTHER_DETAIL
    from IGS_GE_S_ERROR_LOG
        where ROWID = X_ROWID
    for update  nowait;

Line: 282

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

Line: 311

procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_SEQUENCE_NUMBER in NUMBER,
  X_PROGRAM_UNIT in VARCHAR2,
  X_SQL_ERROR_NUM in NUMBER,
  X_SQL_ERROR_MESSAGE in VARCHAR2,
  X_OTHER_DETAIL 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 ,
  X_REQUEST_ID IN NUMBER ,
  X_PROGRAM_ID IN NUMBER ,
  X_PROGRAM_APPLICATION_ID IN NUMBER ,
  X_PROGRAM_UPDATE_DATE IN DATE ,
  X_MODE in VARCHAR2 default 'R'
  ) as

begin

  Before_DML (
    p_action => 'UPDATE',
    x_rowid => X_ROWID,
    x_sequence_number => X_SEQUENCE_NUMBER,
    x_program_unit => X_PROGRAM_UNIT,
    x_sql_error_num => X_SQL_ERROR_NUM,
    x_sql_error_message => X_SQL_ERROR_MESSAGE,
    x_other_detail => X_OTHER_DETAIL,
    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: 347

  update IGS_GE_S_ERROR_LOG set
    PROGRAM_UNIT =   NEW_REFERENCES.PROGRAM_UNIT,
    SQL_ERROR_NUM =   NEW_REFERENCES.SQL_ERROR_NUM,
    SQL_ERROR_MESSAGE =   NEW_REFERENCES.SQL_ERROR_MESSAGE,
    OTHER_DETAIL =   NEW_REFERENCES.OTHER_DETAIL,
    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: 365

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

Line: 368

end UPDATE_ROW;

Line: 379

  X_LAST_UPDATE_DATE IN DATE ,
  X_LAST_UPDATED_BY IN NUMBER ,
  X_LAST_UPDATE_LOGIN IN NUMBER ,
  X_REQUEST_ID IN NUMBER ,
  X_PROGRAM_ID IN NUMBER ,
  X_PROGRAM_APPLICATION_ID IN NUMBER ,
  X_PROGRAM_UPDATE_DATE IN DATE ,
  X_MODE in VARCHAR2 default 'R'
  ) as
  cursor c1 is select rowid from IGS_GE_S_ERROR_LOG
     where SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
  ;

Line: 397

    INSERT_ROW (
     X_ROWID,
     X_SEQUENCE_NUMBER,
     X_PROGRAM_UNIT,
     X_SQL_ERROR_NUM,
     X_SQL_ERROR_MESSAGE,
     X_OTHER_DETAIL,
     x_creation_date  ,
     x_created_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 ,
     X_MODE);

Line: 417

  UPDATE_ROW (
  X_ROWID,
   X_SEQUENCE_NUMBER,
   X_PROGRAM_UNIT,
   X_SQL_ERROR_NUM,
   X_SQL_ERROR_MESSAGE,
   X_OTHER_DETAIL,
     x_creation_date  ,
     x_created_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 ,
     X_MODE);

Line: 436

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

Line: 445

  delete from IGS_GE_S_ERROR_LOG
  where ROWID = X_ROWID;

Line: 451

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

Line: 455

end DELETE_ROW;