APPS.IGS_UC_PROSPECTIVE_PKG SQL Statements

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

Line: 23

    x_last_update_date                  IN     DATE        ,
    x_last_updated_by                   IN     NUMBER      ,
    x_last_update_login                 IN     NUMBER
  ) AS

  BEGIN
     NULL;

Line: 74

    x_last_update_date                  IN     DATE        ,
    x_last_updated_by                   IN     NUMBER      ,
    x_last_update_login                 IN     NUMBER
  ) AS
  BEGIN
     NULL;

Line: 83

  PROCEDURE insert_row (
    x_rowid                             IN OUT NOCOPY VARCHAR2,
    x_prospective_id                    IN OUT NOCOPY NUMBER,
    x_app_no                            IN     NUMBER,
    x_datetimestamp                     IN     DATE,
    x_check_digit                       IN     NUMBER,
    x_name_change_date                  IN     DATE,
    x_title                             IN     VARCHAR2,
    x_forenames                         IN     VARCHAR2,
    x_surname                           IN     VARCHAR2,
    x_index_surname                     IN     VARCHAR2,
    x_cancelled                         IN     VARCHAR2,
    x_withdrawn                         IN     VARCHAR2,
    x_status                            IN     VARCHAR2,
    x_birth_date                        IN     DATE,
    x_sex                               IN     VARCHAR2,
    x_mode                              IN     VARCHAR2
  ) AS
  BEGIN
     NULL;

Line: 103

  END insert_row;

Line: 128

  PROCEDURE update_row (
    x_rowid                             IN     VARCHAR2,
    x_prospective_id                    IN     NUMBER,
    x_app_no                            IN     NUMBER,
    x_datetimestamp                     IN     DATE,
    x_check_digit                       IN     NUMBER,
    x_name_change_date                  IN     DATE,
    x_title                             IN     VARCHAR2,
    x_forenames                         IN     VARCHAR2,
    x_surname                           IN     VARCHAR2,
    x_index_surname                     IN     VARCHAR2,
    x_cancelled                         IN     VARCHAR2,
    x_withdrawn                         IN     VARCHAR2,
    x_status                            IN     VARCHAR2,
    x_birth_date                        IN     DATE,
    x_sex                               IN     VARCHAR2,
    x_mode                              IN     VARCHAR2
  ) AS
  BEGIN
     NULL;

Line: 148

  END update_row;

Line: 174

  PROCEDURE delete_row (
    x_rowid IN VARCHAR2
  ) AS
  BEGIN
     NULL;

Line: 179

  END delete_row;