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

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

Line: 19


    x_last_update_date                  IN     DATE    ,
    x_last_updated_by                   IN     NUMBER  ,
    x_last_update_login                 IN     NUMBER  ,
    x_decision_make_id                  IN     NUMBER,
    x_decision_reason_id                IN     NUMBER,
    x_obsolete_outcome_status           IN     VARCHAR2,
    x_pending_outcome_status            IN     VARCHAR2,
    x_rejected_outcome_status           IN     VARCHAR2,
    x_system_code                       IN     VARCHAR2,
    x_ni_number_alt_pers_type           IN     VARCHAR2,
    x_application_type                  IN     VARCHAR2,
    -- smaddali added these cols for ucfd203 - multiple cycles build , bug#2669208
    x_name                              IN     VARCHAR2   ,
    x_description                       IN     VARCHAR2   ,
    x_ucas_security_key                 IN     VARCHAR2   ,
    x_current_cycle                     IN     VARCHAR2   ,
    x_configured_cycle                  IN     VARCHAR2,
    x_prev_inst_left_date               IN     DATE
  ) AS
  /*
  ||  Created By : rgopalan
  ||  Created On : 01-OCT-2001
  ||  Purpose : Initialises the Old and New references for the columns of the table.
  ||  Known limitations, enhancements or remarks :
  ||  Change History :
  ||  Who             When            What
  || smaddali  11-jun-03  removed calendar cols and added new cols for bug#2669208 , ucfd203 build
  ||  (reverse chronological order - newest change first)
  */

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

Line: 62


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

Line: 64


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

Line: 94


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

Line: 102


    new_references.last_update_date                  := x_last_update_date;

Line: 103


    new_references.last_updated_by                   := x_last_updated_by;

Line: 104


    new_references.last_update_login                 := x_last_update_login;

Line: 127


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

Line: 139


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

Line: 151


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

Line: 165


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

Line: 179


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

Line: 191


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

Line: 206


      SELECT   rowid
      FROM     IGS_UC_DEFAULTS
      WHERE  obsolete_outcome_status= x_adm_outcome_status ;

Line: 212


      SELECT   rowid
      FROM     IGS_UC_DEFAULTS
      WHERE   pending_outcome_status= x_adm_outcome_status;

Line: 218


      SELECT   rowid
      FROM     IGS_UC_DEFAULTS
      WHERE   rejected_outcome_status= x_adm_outcome_status ;

Line: 271


      SELECT   rowid
      FROM     IGS_UC_DEFAULTS
      WHERE    decision_reason_id = x_code_id;

Line: 298


      SELECT   rowid
      FROM     IGS_UC_DEFAULTS
      WHERE    application_type = x_application_type;

Line: 333


      SELECT   rowid
      FROM     igs_uc_defaults
      WHERE    system_code = x_system_code;

Line: 364


    x_last_update_date                  IN     DATE    ,
    x_last_updated_by                   IN     NUMBER  ,
    x_last_update_login                 IN     NUMBER  ,
    x_decision_make_id                  IN     NUMBER  ,
    x_decision_reason_id                IN     NUMBER  ,
    x_obsolete_outcome_status           IN     VARCHAR2,
    x_pending_outcome_status            IN     VARCHAR2,
    x_rejected_outcome_status           IN     VARCHAR2,
    x_system_code                       IN     VARCHAR2,
    x_ni_number_alt_pers_type           IN     VARCHAR2,
    x_application_type                  IN     VARCHAR2,
    -- smaddali added these cols for ucfd203 - multiple cycles build , bug#2669208
    x_name                              IN     VARCHAR2  ,
    x_description                       IN     VARCHAR2  ,
    x_ucas_security_key                 IN     VARCHAR2  ,
    x_current_cycle                     IN     VARCHAR2  ,
    x_configured_cycle                  IN     VARCHAR2,
    x_prev_inst_left_date               IN     DATE
  ) AS
  /*
  ||  Created By : rgopalan
  ||  Created On : 01-OCT-2001
  ||  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
  || smaddali  11-jun-03  removed calendar cols and added new cols for bug#2669208 , ucfd203 build
  ||  (reverse chronological order - newest change first)
  */
  BEGIN

 set_column_values (
      p_action,
      x_rowid,
      x_current_inst_code,
      x_ucas_id_format,
      x_test_app_no,
      x_test_choice_no,
      x_test_transaction_type,
      x_copy_ucas_id,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login,
      x_decision_make_id,
      x_decision_reason_id,
      x_obsolete_outcome_status,
      x_pending_outcome_status,
      x_rejected_outcome_status,
      x_system_code   ,
      x_ni_number_alt_pers_type   ,
      x_application_type   ,
      -- smaddali added these cols for ucfd203 - multiple cycles build , bug#2669208
      x_name         ,
      x_description  ,
      x_ucas_security_key  ,
      x_current_cycle   ,
      x_configured_cycle,
      x_prev_inst_left_date
    );

Line: 427


    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to Before Insert.
       IF ( get_pk_for_validation(
             new_references.system_code
           )
         ) THEN
        fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

Line: 439


    ELSIF (p_action = 'VALIDATE_INSERT') THEN
       IF ( get_pk_for_validation (
             new_references.system_code
           )
         ) THEN
        fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

Line: 454


  PROCEDURE insert_row (
    x_rowid                             IN OUT NOCOPY VARCHAR2,
    x_current_inst_code                 IN     VARCHAR2,
    x_ucas_id_format                    IN     VARCHAR2,
    x_test_app_no                       IN     NUMBER,
    x_test_choice_no                    IN     NUMBER,
    x_test_transaction_type             IN     VARCHAR2,
    x_copy_ucas_id                      IN     VARCHAR2,
    x_mode                              IN     VARCHAR2,
    x_decision_make_id                  IN     NUMBER,
    x_decision_reason_id                IN     NUMBER,
    x_obsolete_outcome_status           IN     VARCHAR2,
    x_pending_outcome_status            IN     VARCHAR2 ,
    x_rejected_outcome_status           IN     VARCHAR2,
    x_system_code                       IN     VARCHAR2,
    x_ni_number_alt_pers_type           IN     VARCHAR2,
    x_application_type                  IN     VARCHAR2,
    -- smaddali added these cols for ucfd203 - multiple cycles build , bug#2669208
    x_name                              IN     VARCHAR2  ,
    x_description                       IN     VARCHAR2  ,
    x_ucas_security_key                 IN     VARCHAR2  ,
    x_current_cycle                     IN     VARCHAR2  ,
    x_configured_cycle                  IN     VARCHAR2,
    x_prev_inst_left_date               IN     DATE
  ) AS
  /*
  ||  Created By : rgopalan
  ||  Created On : 01-OCT-2001
  ||  Purpose : Handles the INSERT DML logic for the table.
  ||  Known limitations, enhancements or remarks :
  ||  Change History :
  ||  Who             When            What
  || smaddali  11-jun-03  removed calendar cols and added new cols for bug#2669208 , ucfd203 build
  ||  (reverse chronological order - newest change first)
  */
    CURSOR c IS
      SELECT   rowid
      FROM     igs_uc_defaults
          ;

Line: 494


    x_last_update_date           DATE;

Line: 495


    x_last_updated_by            NUMBER;

Line: 496


    x_last_update_login          NUMBER;

Line: 500


    x_last_update_date := SYSDATE;

Line: 502


      x_last_updated_by := 1;

Line: 503


      x_last_update_login := 0;

Line: 505


      x_last_updated_by := fnd_global.user_id;

Line: 506


      IF (x_last_updated_by IS NULL) THEN
        x_last_updated_by := -1;

Line: 509


      x_last_update_login := fnd_global.login_id;

Line: 510


      IF (x_last_update_login IS NULL) THEN
        x_last_update_login := -1;

Line: 520


      p_action                            => 'INSERT',
      x_rowid                             => x_rowid,
      x_current_inst_code                 => x_current_inst_code,
      x_ucas_id_format                    => x_ucas_id_format,
      x_test_app_no                       => x_test_app_no,
      x_test_choice_no                    => x_test_choice_no,
      x_test_transaction_type             => x_test_transaction_type,
      x_copy_ucas_id                      => x_copy_ucas_id,
      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 ,
      x_decision_make_id                  => x_decision_make_id,
      x_decision_reason_id                => x_decision_reason_id,
      x_obsolete_outcome_status           => x_obsolete_outcome_status,
      x_pending_outcome_status            => x_pending_outcome_status,
      x_rejected_outcome_status           => x_rejected_outcome_status,
      x_system_code                       => x_system_code,
      x_ni_number_alt_pers_type           => x_ni_number_alt_pers_type,
      x_application_type                  => x_application_type,
      -- smaddali added these cols for ucfd203 - multiple cycles build , bug#2669208
      x_name                              => x_name ,
      x_description                       => x_description ,
      x_ucas_security_key                 => x_ucas_security_key ,
      x_current_cycle                     => x_current_cycle ,
      x_configured_cycle                  => x_configured_cycle,
      x_prev_inst_left_date               => x_prev_inst_left_date
    );

Line: 550


    INSERT INTO igs_uc_defaults (
      current_inst_code,
      ucas_id_format,
      test_app_no,
      test_choice_no,
      test_transaction_type,
      copy_ucas_id,
      creation_date,
      created_by,
      last_update_date,
      last_updated_by,
      last_update_login,
      decision_make_id,
      decision_reason_id,
      obsolete_outcome_status,
      pending_outcome_status,
      rejected_outcome_status,
      system_code   ,
      ni_number_alt_pers_type   ,
      application_type ,
      -- smaddali added these cols for ucfd203 - multiple cycles build , bug#2669208
      name      ,
      description   ,
      ucas_security_key  ,
      current_cycle    ,
      configured_cycle,
      prev_inst_left_date
    ) VALUES (
      new_references.current_inst_code,
      new_references.ucas_id_format,
      new_references.test_app_no,
      new_references.test_choice_no,
      new_references.test_transaction_type,
      new_references.copy_ucas_id,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login ,
      new_references.decision_make_id,
      new_references.decision_reason_id,
      new_references.obsolete_outcome_status,
      new_references.pending_outcome_status,
      new_references.rejected_outcome_status,
      new_references.system_code   ,
      new_references.ni_number_alt_pers_type   ,
      new_references.application_type ,
      -- smaddali added these cols for ucfd203 - multiple cycles build , bug#2669208
      new_references.name        ,
      new_references.description    ,
      new_references.ucas_security_key   ,
      new_references.current_cycle      ,
      new_references.configured_cycle,
      new_references.prev_inst_left_date);

Line: 613


  END insert_row;

Line: 651


      SELECT
        current_inst_code,
        ucas_id_format,
        test_app_no,
        test_choice_no,
        test_transaction_type,
        copy_ucas_id,
        decision_make_id,
        decision_reason_id,
        obsolete_outcome_status,
        pending_outcome_status,
        rejected_outcome_status,
        system_code,
        ni_number_alt_pers_type,
        application_type  ,
        -- smaddali added these cols for ucfd203 - multiple cycles build , bug#2669208
        name      ,
        description      ,
        ucas_security_key     ,
        current_cycle     ,
        configured_cycle,
        prev_inst_left_date
      FROM  igs_uc_defaults
      WHERE rowid = x_rowid
      FOR UPDATE NOWAIT;

Line: 684


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

Line: 729


  PROCEDURE update_row (
    x_rowid                             IN     VARCHAR2,
    x_current_inst_code                 IN     VARCHAR2,
    x_ucas_id_format                    IN     VARCHAR2,
    x_test_app_no                       IN     NUMBER,
    x_test_choice_no                    IN     NUMBER,
    x_test_transaction_type             IN     VARCHAR2,
    x_copy_ucas_id                      IN     VARCHAR2,
    x_mode                              IN     VARCHAR2,
    x_decision_make_id                  IN     NUMBER ,
    x_decision_reason_id                IN     NUMBER ,
    x_obsolete_outcome_status           IN     VARCHAR2,
    x_pending_outcome_status            IN     VARCHAR2 ,
    x_rejected_outcome_status           IN     VARCHAR2,
    x_system_code                       IN     VARCHAR2,
    x_ni_number_alt_pers_type           IN     VARCHAR2,
    x_application_type                  IN     VARCHAR2,
    -- smaddali added these cols for ucfd203 - multiple cycles build , bug#2669208
    x_name                              IN     VARCHAR2  ,
    x_description                       IN     VARCHAR2  ,
    x_ucas_security_key                 IN     VARCHAR2  ,
    x_current_cycle                     IN     VARCHAR2  ,
    x_configured_cycle                  IN     VARCHAR2,
    x_prev_inst_left_date               IN     DATE
  ) AS
  /*
  ||  Created By : rgopalan
  ||  Created On : 01-OCT-2001
  ||  Purpose : Handles the UPDATE DML logic for the table.
  ||  Known limitations, enhancements or remarks :
  ||  Change History :
  ||  Who             When            What
  || smaddali  11-jun-03  removed calendar cols and added new cols for bug#2669208 , ucfd203 build
  ||  (reverse chronological order - newest change first)
  */
    x_last_update_date           DATE ;

Line: 765


    x_last_updated_by            NUMBER;

Line: 766


    x_last_update_login          NUMBER;

Line: 770


    x_last_update_date := SYSDATE;

Line: 772


      x_last_updated_by := 1;

Line: 773


      x_last_update_login := 0;

Line: 775


      x_last_updated_by := fnd_global.user_id;

Line: 776


      IF x_last_updated_by IS NULL THEN
        x_last_updated_by := -1;

Line: 779


      x_last_update_login := fnd_global.login_id;

Line: 780


      IF (x_last_update_login IS NULL) THEN
        x_last_update_login := -1;

Line: 790


      p_action                            => 'UPDATE',
      x_rowid                             => x_rowid,
      x_current_inst_code                 => x_current_inst_code,
      x_ucas_id_format                    => x_ucas_id_format,
      x_test_app_no                       => x_test_app_no,
      x_test_choice_no                    => x_test_choice_no,
      x_test_transaction_type             => x_test_transaction_type,
      x_copy_ucas_id                      => x_copy_ucas_id,
      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,
      x_decision_make_id                  => x_decision_make_id,
      x_decision_reason_id                => x_decision_reason_id,
      x_obsolete_outcome_status           => x_obsolete_outcome_status,
      x_pending_outcome_status            => x_pending_outcome_status,
      x_rejected_outcome_status           => x_rejected_outcome_status,
      x_system_code                       => x_system_code,
      x_ni_number_alt_pers_type           => x_ni_number_alt_pers_type,
      x_application_type                  => x_application_type,
      -- smaddali added these cols for ucfd203 - multiple cycles build , bug#2669208
      x_name                              => x_name          ,
      x_description                       => x_description   ,
      x_ucas_security_key                 => x_ucas_security_key  ,
      x_current_cycle                     => x_current_cycle      ,
      x_configured_cycle                  => x_configured_cycle,
      x_prev_inst_left_date               => x_prev_inst_left_date
    );

Line: 820


    UPDATE igs_uc_defaults
      SET
        current_inst_code                 = new_references.current_inst_code,
        ucas_id_format                    = new_references.ucas_id_format,
        test_app_no                       = new_references.test_app_no,
        test_choice_no                    = new_references.test_choice_no,
        test_transaction_type             = new_references.test_transaction_type,
        copy_ucas_id                      = new_references.copy_ucas_id,
        last_update_date                  = x_last_update_date,
        last_updated_by                   = x_last_updated_by,
        last_update_login                 = x_last_update_login ,
        decision_make_id                  = new_references.decision_make_id,
        decision_reason_id                = new_references.decision_reason_id,
        obsolete_outcome_status           = new_references.obsolete_outcome_status,
        pending_outcome_status            = new_references.pending_outcome_status,
        rejected_outcome_status           = new_references.rejected_outcome_status,
        ni_number_alt_pers_type           = new_references.ni_number_alt_pers_type,
        application_type                  = new_references.application_type,
        -- smaddali added these cols for ucfd203 - multiple cycles build , bug#2669208
        name                              = new_references.name          ,
        description                       = new_references.description   ,
        ucas_security_key                 = new_references.ucas_security_key  ,
        current_cycle                     = new_references.current_cycle      ,
        configured_cycle                  = new_references.configured_cycle,
        prev_inst_left_date               = new_references.prev_inst_left_date
      WHERE rowid = x_rowid;

Line: 851


  END update_row;

Line: 882


  ||  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
  || smaddali  11-jun-03  removed calendar cols and added new cols for bug#2669208 , ucfd203 build
  ||  (reverse chronological order - newest change first)
  */
    CURSOR c1 IS
      SELECT   rowid
      FROM     igs_uc_defaults
        ;

Line: 901


      insert_row (
        x_rowid,
        x_current_inst_code,
        x_ucas_id_format,
        x_test_app_no,
        x_test_choice_no,
        x_test_transaction_type,
        x_copy_ucas_id,
        x_mode,
        x_decision_make_id,
        x_decision_reason_id,
        x_obsolete_outcome_status,
        x_pending_outcome_status,
        x_rejected_outcome_status,
        x_system_code  ,
        x_ni_number_alt_pers_type    ,
        x_application_type ,
        -- smaddali added these cols for ucfd203 - multiple cycles build , bug#2669208
        x_name          ,
        x_description   ,
        x_ucas_security_key  ,
        x_current_cycle      ,
        x_configured_cycle,
        x_prev_inst_left_date
      );

Line: 930


    update_row (
      x_rowid,
      x_current_inst_code,
      x_ucas_id_format,
      x_test_app_no,
      x_test_choice_no,
      x_test_transaction_type,
      x_copy_ucas_id,
      x_mode,
      x_decision_make_id,
      x_decision_reason_id,
      x_obsolete_outcome_status,
      x_pending_outcome_status,
      x_rejected_outcome_status,
      x_system_code  ,
      x_ni_number_alt_pers_type    ,
      x_application_type,
      -- smaddali added these cols for ucfd203 - multiple cycles build , bug#2669208
      x_name          ,
      x_description   ,
      x_ucas_security_key  ,
      x_current_cycle      ,
      x_configured_cycle,
      x_prev_inst_left_date
    );