APPS.IGS_SS_TEST_CONF_PKG SQL Statements

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

Line: 15

    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
  /*
  ||  Created By : ssomani
  ||  Created On : 18-DEC-2000
  ||  Obsoleted on / by : 17-DEC-2001 by vdixit per enh 2138615
  ||  Purpose : Initialises the Old and New references for the columns of the table.
  ||  Known limitations, enhancements or remarks :
  ||  Change History :
  ||  Who             When            What
  ||  (reverse chronological order - newest change first)
  */



  BEGIN

	NULL;

Line: 110

    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
  /*
  ||  Created By : ssomani
  ||  Created On : 18-DEC-2000
  ||  Obsoleted on / by : 17-DEC-2001 by vdixit per enh 2138615
  ||  Purpose : Initialises the columns, Checks Constraints, Calls the
  ||            Trigger Handlers for the table, before any DML operation.
  ||  Known limitations, enhancements or remarks :
  ||  Change History :
  ||  Who             When            What
  ||  (reverse chronological order - newest change first)
  */
  BEGIN

	NULL;

Line: 132

  PROCEDURE insert_row (
    x_rowid                             IN OUT NOCOPY VARCHAR2,
    x_test_config_id                    IN OUT NOCOPY NUMBER,
    x_source_type_id                    IN     NUMBER,
    x_admission_test_type               IN     VARCHAR2,
    x_inactive                          IN     VARCHAR2,
    x_mode                              IN     VARCHAR2 DEFAULT 'R'
  ) AS
  /*
  ||  Created By : ssomani
  ||  Created On : 18-DEC-2000
  ||  Obsoleted on / by : 17-DEC-2001 by vdixit per enh 2138615
  ||  Purpose : Handles the INSERT DML logic for the table.
  ||  Known limitations, enhancements or remarks :
  ||  Change History :
  ||  Who             When            What
  ||  (reverse chronological order - newest change first)
  */


  BEGIN

	NULL;

Line: 155

  END insert_row;

Line: 182

  PROCEDURE update_row (
    x_rowid                             IN     VARCHAR2,
    x_test_config_id                    IN     NUMBER,
    x_source_type_id                    IN     NUMBER,
    x_admission_test_type               IN     VARCHAR2,
    x_inactive                          IN     VARCHAR2,
    x_mode                              IN     VARCHAR2 DEFAULT 'R'
  ) AS
  /*
  ||  Created By : ssomani
  ||  Created On : 18-DEC-2000
  ||  Obsoleted on / by : 17-DEC-2001 by vdixit per enh 2138615
  ||  Purpose : Handles the UPDATE DML logic for the table.
  ||  Known limitations, enhancements or remarks :
  ||  Change History :
  ||  Who             When            What
  ||  (reverse chronological order - newest change first)
  */


  BEGIN

	NULL;

Line: 205

  END update_row;

Line: 220

  ||  Purpose : Adds a row if there is no existing row, otherwise updates existing row in the table.
  ||  Known limitations, enhancements or remarks :
  ||  Change History :
  ||  Who             When            What
  ||  (reverse chronological order - newest change first)
  */

  BEGIN

	NULL;

Line: 233

  PROCEDURE delete_row (
    x_rowid IN VARCHAR2
  ) AS
  /*
  ||  Created By : ssomani
  ||  Created On : 18-DEC-2000
  ||  Obsoleted on / by : 17-DEC-2001 by vdixit per enh 2138615
  ||  Purpose : Handles the DELETE DML logic for the table.
  ||  Known limitations, enhancements or remarks :
  ||  Change History :
  ||  Who             When            What
  ||  (reverse chronological order - newest change first)
  */
  BEGIN

	   NULL;

Line: 249

  END delete_row;