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

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

Line: 59


    x_last_update_date                  IN     DATE      ,--  DEFAULT NULL,
    x_last_updated_by                   IN     NUMBER    ,--  DEFAULT NULL,
    x_last_update_login                 IN     NUMBER    ,--  DEFAULT NULL ,
    X_ATTRIBUTE_CATEGORY 		IN VARCHAR2 ,--DEFAULT NULL,
    X_ATTRIBUTE1 			  IN VARCHAR2  ,--DEFAULT NULL,
    X_ATTRIBUTE2 			  IN VARCHAR2 ,--DEFAULT NULL,
    X_ATTRIBUTE3 			  IN VARCHAR2 ,--DEFAULT NULL,
    X_ATTRIBUTE4 			  IN VARCHAR2 ,--DEFAULT NULL,
    X_ATTRIBUTE5  			IN VARCHAR2 ,--DEFAULT NULL,
    X_ATTRIBUTE6  			IN VARCHAR2 ,--DEFAULT NULL,
   	X_ATTRIBUTE7  			IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE8  			IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE9 		  	IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE10 			IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE11  			IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE12  			IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE13  			IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE14  			IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE15  			IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE16  			IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE17  			IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE18  			IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE19  			IN VARCHAR2 ,--DEFAULT NULL,
  	X_ATTRIBUTE20  			IN VARCHAR2, --DEFAULT NULL
	X_BIRTH_CNTRY_RESN_CODE		IN     VARCHAR2 --DEFAULT NULL
  ) AS
  /*
  ||  Created By : bshankar
  ||  Created On : 28-AUG-2000
  ||  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)
  */

    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     IGS_PE_STAT_DETAILS
      WHERE    ROWID = x_rowid;

Line: 108


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

Line: 110


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

Line: 166


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

Line: 174


    new_references.last_update_date                  := x_last_update_date;

Line: 175


    new_references.last_updated_by                   := x_last_updated_by;

Line: 176


    new_references.last_update_login                 := x_last_update_login;

Line: 196


      SELECT   ROWID
      FROM     igs_pe_stat_details
      --  WHERE    person_profile_id = x_person_profile_id
      WHERE    person_id = x_person_id
      FOR UPDATE NOWAIT;

Line: 223


      SELECT   rowid
      FROM     IGS_PE_STAT_DETAILS
      WHERE   (
                 ( MATR_CAL_TYPE = X_CAL_TYPE AND MATR_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER ) OR
                 ( INIT_CAL_TYPE = X_CAL_TYPE AND INIT_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER ) OR
                 ( RECENT_CAL_TYPE = X_CAL_TYPE AND RECENT_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER ) OR
                 ( CATALOG_CAL_TYPE = X_CAL_TYPE AND CATALOG_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER )
	  );

Line: 248


         SELECT   ROWID
         FROM     HZ_PARTIES
         WHERE    PARTY_ID = new_references.PERSON_ID ;

Line: 276


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

Line: 293


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

Line: 307


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

Line: 321


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

Line: 335


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

Line: 373


    x_last_update_date                  IN     DATE      ,--  DEFAULT NULL,
    x_last_updated_by                   IN     NUMBER    ,--  DEFAULT NULL,
    x_last_update_login                 IN     NUMBER    ,--  DEFAULT NULL ,
    X_ATTRIBUTE_CATEGORY 		IN VARCHAR2 ,--DEFAULT NULL,
    X_ATTRIBUTE1 			  IN VARCHAR2 ,-- DEFAULT NULL,
    X_ATTRIBUTE2 			  IN VARCHAR2 ,--DEFAULT NULL,
    X_ATTRIBUTE3 			  IN VARCHAR2 ,--DEFAULT NULL,
    X_ATTRIBUTE4 			  IN VARCHAR2 ,--DEFAULT NULL,
    X_ATTRIBUTE5  			IN VARCHAR2 ,--DEFAULT NULL,
    X_ATTRIBUTE6  			IN VARCHAR2 ,--DEFAULT NULL,
   	X_ATTRIBUTE7  			IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE8  			IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE9 		  	IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE10 			IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE11  			IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE12  			IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE13  			IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE14  			IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE15  			IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE16  			IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE17  			IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE18  			IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE19  			IN VARCHAR2 ,--DEFAULT NULL,
  	X_ATTRIBUTE20  			IN VARCHAR2 ,--DEFAULT NULL
	X_BIRTH_CNTRY_RESN_CODE		IN VARCHAR2
  ) AS
  /*
  ||  Created By : bshankar
  ||  Created On : 28-AUG-2000
  ||  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
  ||  Bayadav  31-Jan-2002  Bug number 2203778 .addded descriptive flexfield columns (IGS_PE_PERS_STAT )
  ||  (reverse chronological order - newest change first)
  */
  BEGIN

    set_column_values (
      p_action,
      x_rowid,
     -- x_person_profile_id,
      x_person_id,
      x_effective_start_date,
      x_effective_end_date,
      x_religion_cd,
      --x_criminal_convict,
      --x_acad_dismissal,
      --x_non_acad_dismissal,
      --x_country_cd3,
      --x_state_of_residence,
      --x_resid_stat_id,
      x_socio_eco_cd,
      x_next_to_kin,
      x_in_state_tuition,
      x_tuition_st_date,
      x_tuition_end_date,
      x_further_education_cd,
      X_MATR_CAL_TYPE,
      X_MATR_SEQUENCE_NUMBER,
      X_INIT_CAL_TYPE,
      X_INIT_SEQUENCE_NUMBER,
      X_RECENT_CAL_TYPE,
      X_RECENT_SEQUENCE_NUMBER,
      X_CATALOG_CAL_TYPE,
      X_CATALOG_SEQUENCE_NUMBER,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login ,
       x_ATTRIBUTE_CATEGORY,
      x_ATTRIBUTE1        ,
      x_ATTRIBUTE2        ,
      x_ATTRIBUTE3        ,
      x_ATTRIBUTE4        ,
      x_ATTRIBUTE5        ,
      x_ATTRIBUTE6        ,
      x_ATTRIBUTE7        ,
      x_ATTRIBUTE8        ,
      x_ATTRIBUTE9        ,
      x_ATTRIBUTE10       ,
      x_ATTRIBUTE11       ,
      x_ATTRIBUTE12       ,
      x_ATTRIBUTE13       ,
      x_ATTRIBUTE14       ,
      x_ATTRIBUTE15       ,
      x_ATTRIBUTE16       ,
      x_ATTRIBUTE17       ,
      x_ATTRIBUTE18       ,
      x_ATTRIBUTE19       ,
      x_ATTRIBUTE20	  ,
      X_BIRTH_CNTRY_RESN_CODE
    );

Line: 469


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

Line: 480


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

Line: 483


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

Line: 497


  PROCEDURE insert_row (
    x_rowid                             IN OUT NOCOPY VARCHAR2,
   --  x_person_profile_id                 IN     NUMBER,
    x_person_id                         IN NUMBER,
    x_effective_start_date              IN     DATE,
    x_effective_end_date                IN     DATE,
    x_religion_cd                       IN     VARCHAR2,
    --x_criminal_convict                  IN     VARCHAR2 DEFAULT NULL,
    --x_acad_dismissal                    IN     VARCHAR2 DEFAULT NULL,
    -- x_non_acad_dismissal                IN     VARCHAR2 DEFAULT NULL,
    --x_country_cd3                       IN     VARCHAR2 DEFAULT NULL,
    -- x_state_of_residence                IN     VARCHAR2 DEFAULT NULL,
    -- x_resid_stat_id                     IN     NUMBER DEFAULT NULL,
    x_socio_eco_cd                      IN     VARCHAR2,
    x_next_to_kin                       IN     VARCHAR2,
    x_in_state_tuition                  IN     VARCHAR2,
    x_tuition_st_date                   IN     DATE,
    x_tuition_end_date                  IN     DATE,
    x_further_education_cd              IN     VARCHAR2 ,
    X_MATR_CAL_TYPE                     IN     VARCHAR2  ,--  DEFAULT NULL ,
    X_MATR_SEQUENCE_NUMBER              IN     NUMBER    ,--  DEFAULT NULL,
    X_INIT_CAL_TYPE                     IN     VARCHAR2  ,--  DEFAULT NULL ,
    X_INIT_SEQUENCE_NUMBER             IN     NUMBER     ,-- DEFAULT NULL,
    X_RECENT_CAL_TYPE                   IN     VARCHAR2  ,--  DEFAULT NULL ,
    X_RECENT_SEQUENCE_NUMBER           IN     NUMBER     ,-- DEFAULT NULL,
    X_CATALOG_CAL_TYPE                  IN     VARCHAR2  ,--  DEFAULT NULL ,
    X_CATALOG_SEQUENCE_NUMBER          IN     NUMBER     ,-- DEFAULT NULL,
    x_mode                              IN     VARCHAR2,-- DEFAULT 'R' ,
    X_ATTRIBUTE_CATEGORY 		IN VARCHAR2 ,--DEFAULT NULL,
    X_ATTRIBUTE1 			  IN VARCHAR2,--  DEFAULT NULL,
    X_ATTRIBUTE2 			  IN VARCHAR2,-- DEFAULT NULL,
    X_ATTRIBUTE3 			  IN VARCHAR2,-- DEFAULT NULL,
    X_ATTRIBUTE4 			  IN VARCHAR2,-- DEFAULT NULL,
    X_ATTRIBUTE5  			IN VARCHAR2 ,--DEFAULT NULL,
    X_ATTRIBUTE6  			IN VARCHAR2 ,--DEFAULT NULL,
   	X_ATTRIBUTE7  			IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE8  			IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE9 		  	IN VARCHAR2,-- DEFAULT NULL,
	  X_ATTRIBUTE10 			IN VARCHAR2,-- DEFAULT NULL,
	  X_ATTRIBUTE11  			IN VARCHAR2,-- DEFAULT NULL,
	  X_ATTRIBUTE12  			IN VARCHAR2,-- DEFAULT NULL,
	  X_ATTRIBUTE13  			IN VARCHAR2,-- DEFAULT NULL,
	  X_ATTRIBUTE14  			IN VARCHAR2,-- DEFAULT NULL,
	  X_ATTRIBUTE15  			IN VARCHAR2,-- DEFAULT NULL,
	  X_ATTRIBUTE16  			IN VARCHAR2,-- DEFAULT NULL,
	  X_ATTRIBUTE17  			IN VARCHAR2,-- DEFAULT NULL,
	  X_ATTRIBUTE18  			IN VARCHAR2,-- DEFAULT NULL,
	  X_ATTRIBUTE19  			IN VARCHAR2,-- DEFAULT NULL,
  	X_ATTRIBUTE20  			IN VARCHAR2, --DEFAULT NULL
	X_BIRTH_CNTRY_RESN_CODE		IN VARCHAR2
  ) AS
  /*
  ||  Created By : bshankar
  ||  Created On : 28-AUG-2000
  ||  Purpose : Handles the INSERT DML logic for the table.
  ||  Known limitations, enhancements or remarks :
  ||  Change History :
  ||  Who             When            What
  ||  Bayadav  31-Jan-2002  Bug number 2203778 .addded descriptive flexfield columns (IGS_PE_PERS_STAT )
  ||  (reverse chronological order - newest change first)
  ||  ssawhney 2203778    person_id replaces person_profile_id
  */
    CURSOR c IS
      SELECT   ROWID
      FROM     igs_pe_stat_details
      WHERE    person_id                 = x_person_id;

Line: 564


    x_last_update_date           DATE;

Line: 565


    x_last_updated_by            NUMBER;

Line: 566


    x_last_update_login          NUMBER;

Line: 570


    x_program_update_date        DATE;

Line: 574


    x_last_update_date := SYSDATE;

Line: 576


      x_last_updated_by := 1;

Line: 577


      x_last_update_login := 0;

Line: 579


      x_last_updated_by := fnd_global.user_id;

Line: 580


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

Line: 583


      x_last_update_login := fnd_global.login_id;

Line: 584


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

Line: 595


        x_program_update_date    := NULL;

Line: 597


        x_program_update_date    := SYSDATE;

Line: 606


      p_action                            => 'INSERT',
      x_rowid                             => x_rowid,
     --x_person_profile_id                 => x_person_profile_id,
      x_person_id                         => x_person_id,
      x_effective_start_date              => x_effective_start_date,
      x_effective_end_date                => x_effective_end_date,
      x_religion_cd                       => x_religion_cd,
      --x_criminal_convict                  => x_criminal_convict,
      --x_acad_dismissal                    => x_acad_dismissal,
      --x_non_acad_dismissal                => x_non_acad_dismissal,
      --x_country_cd3                       => x_country_cd3,
      -- x_state_of_residence                => x_state_of_residence,
      --x_resid_stat_id                     => x_resid_stat_id,
      x_socio_eco_cd                      => x_socio_eco_cd,
      x_next_to_kin                       => x_next_to_kin,
      x_in_state_tuition                  => x_in_state_tuition,
      x_tuition_st_date                   => x_tuition_st_date,
      x_tuition_end_date                  => x_tuition_end_date,
      x_further_education_cd                 => x_further_education_cd,
      X_MATR_CAL_TYPE                     => X_MATR_CAL_TYPE,
      X_MATR_SEQUENCE_NUMBER              => X_MATR_SEQUENCE_NUMBER,
      X_INIT_CAL_TYPE                     => X_INIT_CAL_TYPE,
      X_INIT_SEQUENCE_NUMBER             => X_INIT_SEQUENCE_NUMBER,
      X_RECENT_CAL_TYPE                   => X_RECENT_CAL_TYPE,
      X_RECENT_SEQUENCE_NUMBER           => X_RECENT_SEQUENCE_NUMBER,
      X_CATALOG_CAL_TYPE                  => X_CATALOG_CAL_TYPE,
      X_CATALOG_SEQUENCE_NUMBER          => X_CATALOG_SEQUENCE_NUMBER,
      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_ATTRIBUTE_CATEGORY 		=>X_ATTRIBUTE_CATEGORY,
      X_ATTRIBUTE1 		  	=>X_ATTRIBUTE1,
      X_ATTRIBUTE2 		  	=>X_ATTRIBUTE2,
      X_ATTRIBUTE3 		  	=>X_ATTRIBUTE3,
      X_ATTRIBUTE4 	  		=>X_ATTRIBUTE4,
      X_ATTRIBUTE5  			=>X_ATTRIBUTE5,
      X_ATTRIBUTE6  			=>X_ATTRIBUTE6,
   	  X_ATTRIBUTE7  			=>X_ATTRIBUTE7,
	    X_ATTRIBUTE8  			=>X_ATTRIBUTE8,
	    X_ATTRIBUTE9  			=>X_ATTRIBUTE9,
	    X_ATTRIBUTE10 			=>X_ATTRIBUTE10,
	    X_ATTRIBUTE11  			=>X_ATTRIBUTE11,
	    X_ATTRIBUTE12  			=>X_ATTRIBUTE12,
	    X_ATTRIBUTE13  			=>X_ATTRIBUTE13,
	    X_ATTRIBUTE14  			=>X_ATTRIBUTE14,
	    X_ATTRIBUTE15  			=>X_ATTRIBUTE15,
	    X_ATTRIBUTE16  			=>X_ATTRIBUTE16,
	    X_ATTRIBUTE17  			=>X_ATTRIBUTE17,
	    X_ATTRIBUTE18  			=>X_ATTRIBUTE18,
	    X_ATTRIBUTE19  			=>X_ATTRIBUTE19,
  	  X_ATTRIBUTE20  			=>X_ATTRIBUTE20,
	  X_BIRTH_CNTRY_RESN_CODE		=>X_BIRTH_CNTRY_RESN_CODE
    );

Line: 665


   INSERT INTO igs_pe_stat_details (
      -- person_profile_id,
      person_id,
      effective_start_date,
      effective_end_date,
      religion_cd,
      --criminal_convict,
      --acad_dismissal,
      --non_acad_dismissal,
      --country_cd3,
      --state_of_residence,
      --resid_stat_id,
      socio_eco_cd,
      next_to_kin,
      in_state_tuition,
      tuition_st_date,
      tuition_end_date,
      further_education_cd,
      MATR_CAL_TYPE,
      MATR_SEQUENCE_NUMBER,
      INIT_CAL_TYPE,
      INIT_SEQUENCE_NUMBER,
      RECENT_CAL_TYPE,
      RECENT_SEQUENCE_NUMBER,
      CATALOG_CAL_TYPE,
      CATALOG_SEQUENCE_NUMBER,
      creation_date,
      created_by,
      last_update_date,
      last_updated_by,
      last_update_login,
      request_id,
      program_id,
      program_application_id,
      program_update_date ,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      ATTRIBUTE16,
      ATTRIBUTE17,
      ATTRIBUTE18,
      ATTRIBUTE19,
      ATTRIBUTE20,
      BIRTH_CNTRY_RESN_CODE)
      VALUES
      (
     -- new_references.person_profile_id,
      new_references.person_id,
      new_references.effective_start_date,
      new_references.effective_end_date,
      new_references.religion_cd,
      --new_references.criminal_convict,
      --new_references.acad_dismissal,
      --new_references.non_acad_dismissal,
      --new_references.country_cd3,
      --new_references.state_of_residence,
      --new_references.resid_stat_id,
      new_references.socio_eco_cd,
      new_references.next_to_kin,
      new_references.in_state_tuition,
      new_references.tuition_st_date,
      new_references.tuition_end_date,
      new_references.further_education_cd,
      new_references.MATR_CAL_TYPE,
      new_references.MATR_SEQUENCE_NUMBER,
      new_references.INIT_CAL_TYPE,
      new_references.INIT_SEQUENCE_NUMBER,
      new_references.RECENT_CAL_TYPE,
      new_references.RECENT_SEQUENCE_NUMBER,
      new_references.CATALOG_CAL_TYPE,
      new_references.CATALOG_SEQUENCE_NUMBER,
      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 ,
      new_references.ATTRIBUTE_CATEGORY,
      new_references.ATTRIBUTE1,
      new_references.ATTRIBUTE2,
      new_references.ATTRIBUTE3,
      new_references.ATTRIBUTE4,
      new_references.ATTRIBUTE5,
      new_references.ATTRIBUTE6,
      new_references.ATTRIBUTE7,
      new_references.ATTRIBUTE8,
      new_references.ATTRIBUTE9,
      new_references.ATTRIBUTE10,
      new_references.ATTRIBUTE11,
      new_references.ATTRIBUTE12,
      new_references.ATTRIBUTE13,
      new_references.ATTRIBUTE14,
      new_references.ATTRIBUTE15,
      new_references.ATTRIBUTE16,
      new_references.ATTRIBUTE17,
      new_references.ATTRIBUTE18,
      new_references.ATTRIBUTE19,
      new_references.ATTRIBUTE20,
      new_references.birth_cntry_resn_code
       );

Line: 807


 END insert_row;

Line: 872


      SELECT
        effective_start_date,
        effective_end_date,
        religion_cd,
        --criminal_convict,
        --acad_dismissal,
        --non_acad_dismissal,
        --country_cd3,
        --state_of_residence,
        --resid_stat_id,
        socio_eco_cd,
        next_to_kin,
        in_state_tuition,
        tuition_st_date,
        tuition_end_date,
        further_education_cd,
        MATR_CAL_TYPE,
        MATR_SEQUENCE_NUMBER,
        INIT_CAL_TYPE,
        INIT_SEQUENCE_NUMBER,
        RECENT_CAL_TYPE,
        RECENT_SEQUENCE_NUMBER,
        CATALOG_CAL_TYPE,
        CATALOG_SEQUENCE_NUMBER,
        ATTRIBUTE_CATEGORY,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15,
        ATTRIBUTE16,
        ATTRIBUTE17,
        ATTRIBUTE18,
        ATTRIBUTE19,
        ATTRIBUTE20,
	BIRTH_CNTRY_RESN_CODE
      FROM  igs_pe_stat_details
      WHERE ROWID = x_rowid
      FOR UPDATE NOWAIT;

Line: 928


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

Line: 1038


  PROCEDURE update_row (
    x_rowid                             IN     VARCHAR2,
   -- x_person_profile_id                 IN     NUMBER,
    x_person_id                         IN     NUMBER,
    x_effective_start_date              IN     DATE,
    x_effective_end_date                IN     DATE,
    x_religion_cd                       IN     VARCHAR2,
    --x_criminal_convict                  IN     VARCHAR2 DEFAULT NULL,
    --x_acad_dismissal                    IN     VARCHAR2 DEFAULT NULL,
    --x_non_acad_dismissal                IN     VARCHAR2 DEFAULT NULL,
    --x_country_cd3                       IN     VARCHAR2 DEFAULT NULL,
    --x_state_of_residence                IN     VARCHAR2 DEFAULT NULL,
    --x_resid_stat_id                     IN     NUMBER DEFAULT NULL,
    x_socio_eco_cd                      IN     VARCHAR2,
    x_next_to_kin                       IN     VARCHAR2,
    x_in_state_tuition                  IN     VARCHAR2,
    x_tuition_st_date                   IN     DATE,
    x_tuition_end_date                  IN     DATE,
    x_further_education_cd                 IN     VARCHAR2,
    X_MATR_CAL_TYPE                     IN     VARCHAR2 ,--   DEFAULT NULL ,
    X_MATR_SEQUENCE_NUMBER              IN     NUMBER   ,--   DEFAULT NULL,
    X_INIT_CAL_TYPE                     IN     VARCHAR2 ,--   DEFAULT NULL ,
    X_INIT_SEQUENCE_NUMBER             IN     NUMBER    ,--  DEFAULT NULL,
    X_RECENT_CAL_TYPE                   IN     VARCHAR2 ,--   DEFAULT NULL ,
    X_RECENT_SEQUENCE_NUMBER           IN     NUMBER    ,--  DEFAULT NULL,
    X_CATALOG_CAL_TYPE                  IN     VARCHAR2 ,--   DEFAULT NULL ,
    X_CATALOG_SEQUENCE_NUMBER          IN     NUMBER    ,--  DEFAULT NULL,
    x_mode                              IN     VARCHAR2 ,--DEFAULT 'R' ,
    X_ATTRIBUTE_CATEGORY 		IN VARCHAR2 ,--DEFAULT NULL,
    X_ATTRIBUTE1 			  IN VARCHAR2,--  DEFAULT NULL,
    X_ATTRIBUTE2 			  IN VARCHAR2,-- DEFAULT NULL,
    X_ATTRIBUTE3 			  IN VARCHAR2,-- DEFAULT NULL,
    X_ATTRIBUTE4 			  IN VARCHAR2,-- DEFAULT NULL,
    X_ATTRIBUTE5  			IN VARCHAR2 ,--DEFAULT NULL,
    X_ATTRIBUTE6  			IN VARCHAR2 ,--DEFAULT NULL,
   	X_ATTRIBUTE7  			IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE8  			IN VARCHAR2,-- DEFAULT NULL,
	  X_ATTRIBUTE9 		  	IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE10 			IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE11  			IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE12  			IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE13  			IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE14  			IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE15  			IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE16  			IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE17  			IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE18  			IN VARCHAR2 ,--DEFAULT NULL,
	  X_ATTRIBUTE19  			IN VARCHAR2 ,--DEFAULT NULL,
  	X_ATTRIBUTE20  			IN VARCHAR2, -- DEFAULT NULL
	X_BIRTH_CNTRY_RESN_CODE		IN VARCHAR2
  ) AS
  /*
  ||  Created By : bshankar
  ||  Created On : 28-AUG-2000
  ||  Purpose : Handles the UPDATE DML logic for the table.
  ||  Known limitations, enhancements or remarks :
  ||  Change History :
  ||  Who             When            What
  ||  Bayadav  31-Jan-2002  Bug number 2203778 .addded descriptive flexfield columns (IGS_PE_PERS_STAT )
  ||  (reverse chronological order - newest change first)
  */
    x_last_update_date           DATE ;

Line: 1100


    x_last_updated_by            NUMBER;

Line: 1101


    x_last_update_login          NUMBER;

Line: 1105


    x_program_update_date        DATE;

Line: 1109


    x_last_update_date := SYSDATE;

Line: 1111


      x_last_updated_by := 1;

Line: 1112


      x_last_update_login := 0;

Line: 1114


      x_last_updated_by := fnd_global.user_id;

Line: 1115


      IF x_last_updated_by IS NULL THEN
        x_last_updated_by := -1;

Line: 1118


      x_last_update_login := fnd_global.login_id;

Line: 1119


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

Line: 1129


      p_action                            => 'UPDATE',
      x_rowid                             => x_rowid,
      --x_person_profile_id                 => x_person_profile_id,
      x_person_id                         => x_person_id,
      x_effective_start_date              => x_effective_start_date,
      x_effective_end_date                => x_effective_end_date,
      x_religion_cd                       => x_religion_cd,
      --x_criminal_convict                  => x_criminal_convict,
      --x_acad_dismissal                    => x_acad_dismissal,
      --x_non_acad_dismissal                => x_non_acad_dismissal,
      --x_country_cd3                       => x_country_cd3,
      --x_state_of_residence                => x_state_of_residence,
      --x_resid_stat_id                     => x_resid_stat_id,
      x_socio_eco_cd                      => x_socio_eco_cd,
      x_next_to_kin                       => x_next_to_kin,
      x_in_state_tuition                  => x_in_state_tuition,
      x_tuition_st_date                   => x_tuition_st_date,
      x_tuition_end_date                  => x_tuition_end_date,
      x_further_education_cd                 => x_further_education_cd,
      X_MATR_CAL_TYPE                     => X_MATR_CAL_TYPE,
      X_MATR_SEQUENCE_NUMBER              => X_MATR_SEQUENCE_NUMBER,
      X_INIT_CAL_TYPE                     => X_INIT_CAL_TYPE,
      X_INIT_SEQUENCE_NUMBER             => X_INIT_SEQUENCE_NUMBER,
      X_RECENT_CAL_TYPE                   => X_RECENT_CAL_TYPE,
      X_RECENT_SEQUENCE_NUMBER           => X_RECENT_SEQUENCE_NUMBER,
      X_CATALOG_CAL_TYPE                  => X_CATALOG_CAL_TYPE,
      X_CATALOG_SEQUENCE_NUMBER          => X_CATALOG_SEQUENCE_NUMBER,
      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_ATTRIBUTE_CATEGORY 		=>X_ATTRIBUTE_CATEGORY,
      X_ATTRIBUTE1 		  	=>X_ATTRIBUTE1,
      X_ATTRIBUTE2 		  	=>X_ATTRIBUTE2,
      X_ATTRIBUTE3 		  	=>X_ATTRIBUTE3,
      X_ATTRIBUTE4 	  		=>X_ATTRIBUTE4,
      X_ATTRIBUTE5  			=>X_ATTRIBUTE5,
      X_ATTRIBUTE6  			=>X_ATTRIBUTE6,
   	  X_ATTRIBUTE7  			=>X_ATTRIBUTE7,
	    X_ATTRIBUTE8  			=>X_ATTRIBUTE8,
	    X_ATTRIBUTE9  			=>X_ATTRIBUTE9,
	    X_ATTRIBUTE10 			=>X_ATTRIBUTE10,
	    X_ATTRIBUTE11  			=>X_ATTRIBUTE11,
	    X_ATTRIBUTE12  			=>X_ATTRIBUTE12,
	    X_ATTRIBUTE13  			=>X_ATTRIBUTE13,
	    X_ATTRIBUTE14  			=>X_ATTRIBUTE14,
	    X_ATTRIBUTE15  			=>X_ATTRIBUTE15,
	    X_ATTRIBUTE16  			=>X_ATTRIBUTE16,
	    X_ATTRIBUTE17  			=>X_ATTRIBUTE17,
	    X_ATTRIBUTE18  			=>X_ATTRIBUTE18,
	    X_ATTRIBUTE19  			=>X_ATTRIBUTE19,
  	  X_ATTRIBUTE20  			=>X_ATTRIBUTE20,
	  X_BIRTH_CNTRY_RESN_CODE		=>X_BIRTH_CNTRY_RESN_CODE
    );

Line: 1193


        x_program_update_date := old_references.program_update_date;

Line: 1195


        x_program_update_date := SYSDATE;

Line: 1202


 UPDATE igs_pe_stat_details
      SET
        effective_start_date              = new_references.effective_start_date,
        effective_end_date                = new_references.effective_end_date,
        religion_cd                       = new_references.religion_cd,
        --criminal_convict                  = new_references.criminal_convict,
        --acad_dismissal                    = new_references.acad_dismissal,
        --non_acad_dismissal                = new_references.non_acad_dismissal,
        --country_cd3                       = new_references.country_cd3,
        --state_of_residence                = new_references.state_of_residence,
        --resid_stat_id                     = new_references.resid_stat_id,
        socio_eco_cd                      = new_references.socio_eco_cd,
        next_to_kin                       = new_references.next_to_kin,
        in_state_tuition                  = new_references.in_state_tuition,
        tuition_st_date                   = new_references.tuition_st_date,
        tuition_end_date                  = new_references.tuition_end_date,
        further_education_cd                 = new_references.further_education_cd,
        MATR_CAL_TYPE                     = NEW_REFERENCES.MATR_CAL_TYPE,
        MATR_SEQUENCE_NUMBER              = NEW_REFERENCES.MATR_SEQUENCE_NUMBER,
        INIT_CAL_TYPE                     = NEW_REFERENCES.INIT_CAL_TYPE,
        INIT_SEQUENCE_NUMBER             = NEW_REFERENCES.INIT_SEQUENCE_NUMBER,
        RECENT_CAL_TYPE                   = NEW_REFERENCES.RECENT_CAL_TYPE,
        RECENT_SEQUENCE_NUMBER           = NEW_REFERENCES.RECENT_SEQUENCE_NUMBER,
        CATALOG_CAL_TYPE                  = NEW_REFERENCES.CATALOG_CAL_TYPE,
        CATALOG_SEQUENCE_NUMBER          = NEW_REFERENCES.CATALOG_SEQUENCE_NUMBER,
        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 ,
        ATTRIBUTE_CATEGORY 		= new_references.ATTRIBUTE_CATEGORY,
        ATTRIBUTE1 		  	=new_references.ATTRIBUTE1,
        ATTRIBUTE2 		  	=new_references.ATTRIBUTE2,
        ATTRIBUTE3 		  	=new_references.ATTRIBUTE3,
        ATTRIBUTE4 	  		=new_references.ATTRIBUTE4,
        ATTRIBUTE5  			=new_references.ATTRIBUTE5,
        ATTRIBUTE6  			=new_references.ATTRIBUTE6,
   	    ATTRIBUTE7  			=new_references.ATTRIBUTE7,
	      ATTRIBUTE8  			=new_references.ATTRIBUTE8,
	      ATTRIBUTE9  			=new_references.ATTRIBUTE9,
	      ATTRIBUTE10 			=new_references.ATTRIBUTE10,
	      ATTRIBUTE11  			=new_references.ATTRIBUTE11,
	      ATTRIBUTE12  			=new_references.ATTRIBUTE12,
	      ATTRIBUTE13  			=new_references.ATTRIBUTE13,
	      ATTRIBUTE14  			=new_references.ATTRIBUTE14,
	      ATTRIBUTE15  			=new_references.ATTRIBUTE15,
	      ATTRIBUTE16  			=new_references.ATTRIBUTE16,
	      ATTRIBUTE17  			=new_references.ATTRIBUTE17,
	      ATTRIBUTE18  			=new_references.ATTRIBUTE18,
	      ATTRIBUTE19  			=new_references.ATTRIBUTE19,
  	    ATTRIBUTE20  			=new_references.ATTRIBUTE20,
	    BIRTH_CNTRY_RESN_CODE		=new_references.BIRTH_CNTRY_RESN_CODE
      WHERE ROWID = x_rowid;

Line: 1282


 END update_row;

Line: 1339


  ||  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
  ||  Bayadav  31-Jan-2002  Bug number 2203778 .addded descriptive flexfield columns (IGS_PE_PERS_STAT )
  ||  (reverse chronological order - newest change first)
  ||  ssawhney               2203778 : person_id replaces person_profile_id
  */
    CURSOR c1 IS
      SELECT   ROWID
      FROM     igs_pe_stat_details
      WHERE    person_id                 = x_person_id;

Line: 1359


      insert_row (
        x_rowid,
       -- x_person_profile_id,
        x_person_id,
        x_effective_start_date,
        x_effective_end_date,
        x_religion_cd,
        --x_criminal_convict,
        -- x_acad_dismissal,
        --x_non_acad_dismissal,
        --x_country_cd3,
        --x_state_of_residence,
        --x_resid_stat_id,
        x_socio_eco_cd,
        x_next_to_kin,
        x_in_state_tuition,
        x_tuition_st_date,
        x_tuition_end_date,
        x_further_education_cd,
        X_MATR_CAL_TYPE,
        X_MATR_SEQUENCE_NUMBER,
        X_INIT_CAL_TYPE,
        X_INIT_SEQUENCE_NUMBER,
        X_RECENT_CAL_TYPE,
        X_RECENT_SEQUENCE_NUMBER,
        X_CATALOG_CAL_TYPE,
        X_CATALOG_SEQUENCE_NUMBER,
        x_mode ,
        X_ATTRIBUTE_CATEGORY ,
      X_ATTRIBUTE1 	,
      X_ATTRIBUTE2 	 ,
      X_ATTRIBUTE3 	 ,
      X_ATTRIBUTE4 	 ,
      X_ATTRIBUTE5   ,
      X_ATTRIBUTE6   ,
   	  X_ATTRIBUTE7   ,
	    X_ATTRIBUTE8   ,
	    X_ATTRIBUTE9   ,
	    X_ATTRIBUTE10  ,
	    X_ATTRIBUTE11  ,
	    X_ATTRIBUTE12  ,
	    X_ATTRIBUTE13  ,
	    X_ATTRIBUTE14  ,
	    X_ATTRIBUTE15  ,
	    X_ATTRIBUTE16  ,
	    X_ATTRIBUTE17  ,
	    X_ATTRIBUTE18  ,
	    X_ATTRIBUTE19  ,
  	  X_ATTRIBUTE20 ,
	  X_BIRTH_CNTRY_RESN_CODE
      );

Line: 1414


    update_row (
      x_rowid,
      --x_person_profile_id,
      x_person_id,
      x_effective_start_date,
      x_effective_end_date,
      x_religion_cd,
      --x_criminal_convict,
      --x_acad_dismissal,
      --x_non_acad_dismissal,
      --x_country_cd3,
      --x_state_of_residence,
      --x_resid_stat_id,
      x_socio_eco_cd,
      x_next_to_kin,
      x_in_state_tuition,
      x_tuition_st_date,
      x_tuition_end_date,
      x_further_education_cd,
      X_MATR_CAL_TYPE,
      X_MATR_SEQUENCE_NUMBER,
      X_INIT_CAL_TYPE,
      X_INIT_SEQUENCE_NUMBER,
      X_RECENT_CAL_TYPE,
      X_RECENT_SEQUENCE_NUMBER,
      X_CATALOG_CAL_TYPE,
      X_CATALOG_SEQUENCE_NUMBER,
      x_mode ,
       X_ATTRIBUTE_CATEGORY ,
      X_ATTRIBUTE1 	,
      X_ATTRIBUTE2 	 ,
      X_ATTRIBUTE3 	 ,
      X_ATTRIBUTE4 	 ,
      X_ATTRIBUTE5   ,
      X_ATTRIBUTE6   ,
   	  X_ATTRIBUTE7   ,
	    X_ATTRIBUTE8   ,
	    X_ATTRIBUTE9   ,
	    X_ATTRIBUTE10  ,
	    X_ATTRIBUTE11  ,
	    X_ATTRIBUTE12  ,
	    X_ATTRIBUTE13  ,
	    X_ATTRIBUTE14  ,
	    X_ATTRIBUTE15  ,
	    X_ATTRIBUTE16  ,
	    X_ATTRIBUTE17  ,
	    X_ATTRIBUTE18  ,
	    X_ATTRIBUTE19  ,
  	  X_ATTRIBUTE20 ,
	  X_BIRTH_CNTRY_RESN_CODE
    );

Line: 1469


  PROCEDURE delete_row (
    x_rowid IN VARCHAR2,
  x_mode IN VARCHAR2
  ) AS
  /*
  ||  Created By : bshankar
  ||  Created On : 28-AUG-2000
  ||  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

    before_dml (
      p_action => 'DELETE',
      x_rowid => x_rowid
    );

Line: 1492


 DELETE FROM igs_pe_stat_details
    WHERE ROWID = x_rowid;

Line: 1506


  END delete_row;