DBA Data[Home] [Help]

APPS.IGS_PE_EV_FORM_PKG SQL Statements

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

Line: 45

    x_last_update_date                  IN     DATE,
    x_last_updated_by                   IN     NUMBER,
    x_last_update_login                 IN     NUMBER,
    x_category_code                     IN     VARCHAR2,
    x_init_prgm_start_date              IN     DATE,
    x_govt_org1_othr_name               IN     VARCHAR2,
    x_govt_org2_othr_name               IN     VARCHAR2 ,
    x_intl_org1_othr_name               IN     VARCHAR2 ,
    x_intl_org2_othr_name               IN     VARCHAR2 ,
    x_no_show_flag			IN     VARCHAR2 ,
    x_other_govt_name			IN     VARCHAR2 ,
    x_sevis_school_id                   IN     NUMBER
  ) AS
  /*
  ||  Created By : [email protected]
  ||  Created On : 28-NOV-2002
  ||  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_ev_form
      WHERE    rowid = x_rowid;
Line: 81

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

      fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
Line: 133

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

    new_references.last_update_date                  := x_last_update_date;
Line: 142

    new_references.last_updated_by                   := x_last_updated_by;
Line: 143

    new_references.last_update_login                 := x_last_update_login;
Line: 147

  PROCEDURE afterrowinsertupdatedel(p_insert BOOLEAN ,p_update BOOLEAN,p_delete BOOLEAN) AS

   CURSOR per_type(cp_system_type IGS_PE_PERSON_TYPES.system_type%TYPE,cp_closed_ind igs_pe_person_types.closed_ind%TYPE) IS
   SELECT person_type_code FROM
   IGS_PE_PERSON_TYPES
   WHERE system_type = cp_system_type
   AND closed_ind = cp_closed_ind;
Line: 156

   SELECT typ.rowid,typ.* FROM
   igs_pe_typ_instances_all typ , igs_pe_person_types per_typ
   WHERE
   typ.person_id = old_references.person_id AND
   per_typ.system_type = cp_system_type AND
   typ.person_type_code = per_typ.person_type_code AND
   typ.end_date IS NULL ;
Line: 173

     IF p_insert = TRUE THEN
         igs_pe_typ_instances_pkg.insert_row
                (
                 X_ROWID                        => lv_rowid,
                 X_PERSON_ID                    => new_references.person_id,
                 X_COURSE_CD                    => null,
                 X_TYPE_INSTANCE_ID             => l_type_instance_id,
                 X_PERSON_TYPE_CODE             => l_per_type.person_type_code,
                 X_CC_VERSION_NUMBER            => null,
                 X_FUNNEL_STATUS                => null,
                 X_ADMISSION_APPL_NUMBER        => null,
                 X_NOMINATED_COURSE_CD          => null,
                 X_NCC_VERSION_NUMBER           => null,
                 X_SEQUENCE_NUMBER              => null,
                 X_START_DATE                   => new_references.form_effective_date,
                 X_END_DATE                     => null,
                 X_CREATE_METHOD                => 'CREATE_EXCHG_VISITOR',
                 X_ENDED_BY                     => null,
                 X_END_METHOD                   => null,
                 X_ORG_ID                       => null,
                 X_EMPLMNT_CATEGORY_CODE        => null
                 );
Line: 196

     ELSIF p_update = TRUE THEN

	 IF (new_references.form_effective_date <> old_references.form_effective_date ) THEN
         OPEN person_type('EXCHG_VISITOR');
Line: 203

            igs_pe_typ_instances_pkg.UPDATE_ROW
                 (
                 X_ROWID                        => l_person_type.rowid,
                 X_PERSON_ID                    => l_person_type.person_id,
                 X_COURSE_CD                    => l_person_type.course_cd,
                 X_TYPE_INSTANCE_ID             => l_person_type.type_instance_id,
                 X_PERSON_TYPE_CODE             => l_person_type.person_type_code,
                 X_CC_VERSION_NUMBER            => l_person_type.cc_version_number,
                 X_FUNNEL_STATUS                => l_person_type.funnel_status,
                 X_ADMISSION_APPL_NUMBER        => l_person_type.admission_appl_number,
                 X_NOMINATED_COURSE_CD          => l_person_type.nominated_course_cd,
                 X_NCC_VERSION_NUMBER           => l_person_type.ncc_version_number,
                 X_SEQUENCE_NUMBER              => l_person_type.sequence_number,
                 X_START_DATE                   => new_references.form_effective_date,
                 X_END_DATE                     => l_person_type.end_date,
                 X_CREATE_METHOD                => l_person_type.create_method,
                 X_ENDED_BY                     => l_person_type.ended_by,
                 X_END_METHOD                   => l_person_type.end_method,
                 X_EMPLMNT_CATEGORY_CODE        => l_person_type.emplmnt_category_code
		 );
Line: 224

     ELSIF p_delete = TRUE THEN
         OPEN person_type('EXCHG_VISITOR');
Line: 228

               igs_pe_typ_instances_pkg.DELETE_ROW(l_person_type.rowid);
Line: 232

 END afterrowinsertupdatedel;
Line: 271

         Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
Line: 292

      SELECT   rowid
      FROM     igs_pe_ev_form
      WHERE    ev_form_id = x_ev_form_id
      FOR UPDATE NOWAIT;
Line: 351

    x_last_update_date                  IN     DATE,
    x_last_updated_by                   IN     NUMBER,
    x_last_update_login                 IN     NUMBER ,
    x_category_code                     IN     VARCHAR2,
    x_init_prgm_start_date              IN     DATE,
    x_govt_org1_othr_name               IN     VARCHAR2,
    x_govt_org2_othr_name               IN     VARCHAR2 ,
    x_intl_org1_othr_name               IN     VARCHAR2 ,
    x_intl_org2_othr_name               IN     VARCHAR2 ,
    x_no_show_flag  			IN     VARCHAR2 ,
    x_other_govt_name			IN     VARCHAR2 ,
    x_sevis_school_id                   IN     NUMBER
  ) AS
  /*
  ||  Created By : [email protected]
  ||  Created On : 28-NOV-2002
  ||  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

    set_column_values (
      p_action,
      x_rowid,
      x_ev_form_id,
      x_person_id,
      x_print_form,
      x_form_effective_date,
      x_form_status,
      x_create_reason,
      x_is_valid,
      x_prgm_sponsor_amt,
      x_govt_org1_amt,
      x_govt_org1_code,
      x_govt_org2_amt,
      x_govt_org2_code,
      x_intl_org1_amt,
      x_intl_org1_code,
      x_intl_org2_amt,
      x_intl_org2_code,
      x_ev_govt_amt,
      x_bi_natnl_com_amt,
      x_other_govt_amt,
      x_personal_funds_amt,
      x_ev_form_number,
      x_prgm_start_date,
      x_prgm_end_date,
      x_last_reprint_date,
      x_reprint_reason,
      x_reprint_remarks,
      x_position_code,
      x_position_remarks,
      x_subject_field_code,
      x_subject_field_remarks,
      x_matriculation,
      x_remarks,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login ,
      x_category_code,
      x_init_prgm_start_date,
      x_govt_org1_othr_name,
      x_govt_org2_othr_name,
      x_intl_org1_othr_name,
      x_intl_org2_othr_name,
      x_no_show_flag,
      x_other_govt_name,
      x_sevis_school_id
    );
Line: 427

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

    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to Before Update.
      check_parent_existance;
Line: 441

    ELSIF (p_action = 'DELETE') THEN
      -- Call all the procedures related to Before Delete.
      check_child_existance;
Line: 444

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

    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      check_child_existance;
Line: 461

  PROCEDURE insert_row (
    x_rowid                             IN OUT NOCOPY VARCHAR2,
    x_ev_form_id                        IN OUT NOCOPY NUMBER,
    x_person_id                         IN     NUMBER,
    x_print_form                        IN     VARCHAR2,
    x_form_effective_date               IN     DATE,
    x_form_status                       IN     VARCHAR2,
    x_create_reason                     IN     VARCHAR2,
    x_is_valid                          IN     VARCHAR2,
    x_prgm_sponsor_amt                  IN     NUMBER,
    x_govt_org1_amt                     IN     NUMBER,
    x_govt_org1_code                    IN     VARCHAR2,
    x_govt_org2_amt                     IN     NUMBER,
    x_govt_org2_code                    IN     VARCHAR2,
    x_intl_org1_amt                     IN     NUMBER,
    x_intl_org1_code                    IN     VARCHAR2,
    x_intl_org2_amt                     IN     NUMBER,
    x_intl_org2_code                    IN     VARCHAR2,
    x_ev_govt_amt                       IN     NUMBER,
    x_bi_natnl_com_amt                  IN     NUMBER,
    x_other_govt_amt                    IN     NUMBER,
    x_personal_funds_amt                IN     NUMBER,
    x_ev_form_number                    IN     VARCHAR2,
    x_prgm_start_date                   IN     DATE,
    x_prgm_end_date                     IN     DATE,
    x_last_reprint_date                 IN     DATE,
    x_reprint_reason                    IN     VARCHAR2,
    x_reprint_remarks                   IN     VARCHAR2,
    x_position_code                     IN     NUMBER,
    x_position_remarks                  IN     VARCHAR2,
    x_subject_field_code                IN     VARCHAR2,
    x_subject_field_remarks             IN     VARCHAR2,
    x_matriculation                     IN     VARCHAR2,
    x_remarks                           IN     VARCHAR2,
    x_mode                              IN     VARCHAR2 ,
    x_category_code                     IN     VARCHAR2,
    x_init_prgm_start_date              IN     DATE,
    x_govt_org1_othr_name               IN     VARCHAR2,
    x_govt_org2_othr_name               IN     VARCHAR2 ,
    x_intl_org1_othr_name               IN     VARCHAR2 ,
    x_intl_org2_othr_name               IN     VARCHAR2 ,
    x_no_show_flag			IN     VARCHAR2 ,
    x_other_govt_name			IN     VARCHAR2 ,
    x_sevis_school_id                   IN     NUMBER
  ) AS
  /*
  ||  Created By : [email protected]
  ||  Created On : 28-NOV-2002
  ||  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)
  */

    x_last_update_date           DATE;
Line: 517

    x_last_updated_by            NUMBER;
Line: 518

    x_last_update_login          NUMBER;
Line: 522

    x_last_update_date := SYSDATE;
Line: 524

      x_last_updated_by := 1;
Line: 525

      x_last_update_login := 0;
Line: 527

      x_last_updated_by := fnd_global.user_id;
Line: 528

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

      x_last_update_login := fnd_global.login_id;
Line: 532

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

      p_action                            => 'INSERT',
      x_rowid                             => x_rowid,
      x_ev_form_id                        => x_ev_form_id,
      x_person_id                         => x_person_id,
      x_print_form                        => x_print_form,
      x_form_effective_date               => x_form_effective_date,
      x_form_status                       => x_form_status,
      x_create_reason                     => x_create_reason,
      x_is_valid                          => x_is_valid,
      x_prgm_sponsor_amt                  => x_prgm_sponsor_amt,
      x_govt_org1_amt                     => x_govt_org1_amt,
      x_govt_org1_code                    => x_govt_org1_code,
      x_govt_org2_amt                     => x_govt_org2_amt,
      x_govt_org2_code                    => x_govt_org2_code,
      x_intl_org1_amt                     => x_intl_org1_amt,
      x_intl_org1_code                    => x_intl_org1_code,
      x_intl_org2_amt                     => x_intl_org2_amt,
      x_intl_org2_code                    => x_intl_org2_code,
      x_ev_govt_amt                       => x_ev_govt_amt,
      x_bi_natnl_com_amt                  => x_bi_natnl_com_amt,
      x_other_govt_amt                    => x_other_govt_amt,
      x_personal_funds_amt                => x_personal_funds_amt,
      x_ev_form_number                    => x_ev_form_number,
      x_prgm_start_date                   => x_prgm_start_date,
      x_prgm_end_date                     => x_prgm_end_date,
      x_last_reprint_date                 => x_last_reprint_date,
      x_reprint_reason                    => x_reprint_reason,
      x_reprint_remarks                   => x_reprint_remarks,
      x_position_code                     => x_position_code,
      x_position_remarks                  => x_position_remarks,
      x_subject_field_code                => x_subject_field_code,
      x_subject_field_remarks             => x_subject_field_remarks,
      x_matriculation                     => x_matriculation,
      x_remarks                           => x_remarks,
      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_category_code                     => x_category_code,
      x_init_prgm_start_date              => x_init_prgm_start_date,
      x_govt_org1_othr_name               => x_govt_org1_othr_name,
      x_govt_org2_othr_name               => x_govt_org2_othr_name,
      x_intl_org1_othr_name               => x_intl_org1_othr_name,
      x_intl_org2_othr_name               => x_intl_org2_othr_name,
      x_no_show_flag			  => x_no_show_flag,
      x_other_govt_name			  => x_other_govt_name,
      x_sevis_school_id			  => x_sevis_school_id
    );
Line: 595

 INSERT INTO igs_pe_ev_form (
      ev_form_id,
      person_id,
      print_form,
      form_effective_date,
      form_status,
      create_reason,
      is_valid,
      prgm_sponsor_amt,
      govt_org1_amt,
      govt_org1_code,
      govt_org2_amt,
      govt_org2_code,
      intl_org1_amt,
      intl_org1_code,
      intl_org2_amt,
      intl_org2_code,
      ev_govt_amt,
      bi_natnl_com_amt,
      other_govt_amt,
      personal_funds_amt,
      ev_form_number,
      prgm_start_date,
      prgm_end_date,
      last_reprint_date,
      reprint_reason,
      reprint_remarks,
      position_code,
      position_remarks,
      subject_field_code,
      subject_field_remarks,
      matriculation,
      remarks,
      govt_org1_othr_name,
      govt_org2_othr_name,
      intl_org1_othr_name,
      intl_org2_othr_name,
      creation_date,
      created_by,
      last_update_date,
      last_updated_by,
      last_update_login,
      category_code,
      init_prgm_start_date,
      no_show_flag,
      other_govt_name,
      SEVIS_SCHOOL_IDENTIFIER
    ) VALUES (
      igs_pe_ev_form_s.NEXTVAL,
      new_references.person_id,
      new_references.print_form,
      new_references.form_effective_date,
      new_references.form_status,
      new_references.create_reason,
      new_references.is_valid,
      new_references.prgm_sponsor_amt,
      new_references.govt_org1_amt,
      new_references.govt_org1_code,
      new_references.govt_org2_amt,
      new_references.govt_org2_code,
      new_references.intl_org1_amt,
      new_references.intl_org1_code,
      new_references.intl_org2_amt,
      new_references.intl_org2_code,
      new_references.ev_govt_amt,
      new_references.bi_natnl_com_amt,
      new_references.other_govt_amt,
      new_references.personal_funds_amt,
      new_references.ev_form_number,
      new_references.prgm_start_date,
      new_references.prgm_end_date,
      new_references.last_reprint_date,
      new_references.reprint_reason,
      new_references.reprint_remarks,
      new_references.position_code,
      new_references.position_remarks,
      new_references.subject_field_code,
      new_references.subject_field_remarks,
      new_references.matriculation,
      new_references.remarks,
      new_references.govt_org1_othr_name,
      new_references.govt_org2_othr_name,
      new_references.intl_org1_othr_name,
      new_references.intl_org2_othr_name,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login ,
      new_references.category_code,
      new_references.init_prgm_start_date,
      new_references.no_show_flag,
      new_references.other_govt_name,
      new_references.SEVIS_SCHOOL_IDENTIFIER
    ) RETURNING ROWID, ev_form_id INTO x_rowid, x_ev_form_id;
Line: 695

   afterrowinsertupdatedel(TRUE,FALSE,FALSE);
Line: 710

 END insert_row;
Line: 767

      SELECT
        person_id,
        print_form,
        form_effective_date,
        form_status,
        create_reason,
        is_valid,
        prgm_sponsor_amt,
        govt_org1_amt,
        govt_org1_code,
        govt_org2_amt,
        govt_org2_code,
        intl_org1_amt,
        intl_org1_code,
        intl_org2_amt,
        intl_org2_code,
        ev_govt_amt,
        bi_natnl_com_amt,
        other_govt_amt,
        personal_funds_amt,
        ev_form_number,
        prgm_start_date,
        prgm_end_date,
        last_reprint_date,
        reprint_reason,
        reprint_remarks,
        position_code,
        position_remarks,
        subject_field_code,
        subject_field_remarks,
        matriculation,
        remarks,
        category_code,
        init_prgm_start_date,
	govt_org1_othr_name,
        govt_org2_othr_name,
        intl_org1_othr_name,
        intl_org2_othr_name,
	no_show_flag,
	other_govt_name,
	SEVIS_SCHOOL_IDENTIFIER
      FROM  igs_pe_ev_form
      WHERE rowid = x_rowid
      FOR UPDATE NOWAIT;
Line: 819

      fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
Line: 881

  PROCEDURE update_row (
    x_rowid                             IN     VARCHAR2,
    x_ev_form_id                        IN     NUMBER,
    x_person_id                         IN     NUMBER,
    x_print_form                        IN     VARCHAR2,
    x_form_effective_date               IN     DATE,
    x_form_status                       IN     VARCHAR2,
    x_create_reason                     IN     VARCHAR2,
    x_is_valid                          IN     VARCHAR2,
    x_prgm_sponsor_amt                  IN     NUMBER,
    x_govt_org1_amt                     IN     NUMBER,
    x_govt_org1_code                    IN     VARCHAR2,
    x_govt_org2_amt                     IN     NUMBER,
    x_govt_org2_code                    IN     VARCHAR2,
    x_intl_org1_amt                     IN     NUMBER,
    x_intl_org1_code                    IN     VARCHAR2,
    x_intl_org2_amt                     IN     NUMBER,
    x_intl_org2_code                    IN     VARCHAR2,
    x_ev_govt_amt                       IN     NUMBER,
    x_bi_natnl_com_amt                  IN     NUMBER,
    x_other_govt_amt                    IN     NUMBER,
    x_personal_funds_amt                IN     NUMBER,
    x_ev_form_number                    IN     VARCHAR2,
    x_prgm_start_date                   IN     DATE,
    x_prgm_end_date                     IN     DATE,
    x_last_reprint_date                 IN     DATE,
    x_reprint_reason                    IN     VARCHAR2,
    x_reprint_remarks                   IN     VARCHAR2,
    x_position_code                     IN     NUMBER,
    x_position_remarks                  IN     VARCHAR2,
    x_subject_field_code                IN     VARCHAR2,
    x_subject_field_remarks             IN     VARCHAR2,
    x_matriculation                     IN     VARCHAR2,
    x_remarks                           IN     VARCHAR2,
    x_mode                              IN     VARCHAR2 ,
    x_category_code                     IN     VARCHAR2,
    x_init_prgm_start_date              IN     DATE,
    x_govt_org1_othr_name               IN     VARCHAR2,
    x_govt_org2_othr_name               IN     VARCHAR2 ,
    x_intl_org1_othr_name               IN     VARCHAR2 ,
    x_intl_org2_othr_name               IN     VARCHAR2 ,
    x_no_show_flag			IN     VARCHAR2 ,
    x_other_govt_name			IN     VARCHAR2 ,
    x_sevis_school_id                   IN     NUMBER
  ) AS
  /*
  ||  Created By : [email protected]
  ||  Created On : 28-NOV-2002
  ||  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)
  */
    x_last_update_date           DATE ;
Line: 936

    x_last_updated_by            NUMBER;
Line: 937

    x_last_update_login          NUMBER;
Line: 941

    x_last_update_date := SYSDATE;
Line: 943

      x_last_updated_by := 1;
Line: 944

      x_last_update_login := 0;
Line: 946

      x_last_updated_by := fnd_global.user_id;
Line: 947

      IF x_last_updated_by IS NULL THEN
        x_last_updated_by := -1;
Line: 950

      x_last_update_login := fnd_global.login_id;
Line: 951

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

      p_action                            => 'UPDATE',
      x_rowid                             => x_rowid,
      x_ev_form_id                        => x_ev_form_id,
      x_person_id                         => x_person_id,
      x_print_form                        => x_print_form,
      x_form_effective_date               => x_form_effective_date,
      x_form_status                       => x_form_status,
      x_create_reason                     => x_create_reason,
      x_is_valid                          => x_is_valid,
      x_prgm_sponsor_amt                  => x_prgm_sponsor_amt,
      x_govt_org1_amt                     => x_govt_org1_amt,
      x_govt_org1_code                    => x_govt_org1_code,
      x_govt_org2_amt                     => x_govt_org2_amt,
      x_govt_org2_code                    => x_govt_org2_code,
      x_intl_org1_amt                     => x_intl_org1_amt,
      x_intl_org1_code                    => x_intl_org1_code,
      x_intl_org2_amt                     => x_intl_org2_amt,
      x_intl_org2_code                    => x_intl_org2_code,
      x_ev_govt_amt                       => x_ev_govt_amt,
      x_bi_natnl_com_amt                  => x_bi_natnl_com_amt,
      x_other_govt_amt                    => x_other_govt_amt,
      x_personal_funds_amt                => x_personal_funds_amt,
      x_ev_form_number                    => x_ev_form_number,
      x_prgm_start_date                   => x_prgm_start_date,
      x_prgm_end_date                     => x_prgm_end_date,
      x_last_reprint_date                 => x_last_reprint_date,
      x_reprint_reason                    => x_reprint_reason,
      x_reprint_remarks                   => x_reprint_remarks,
      x_position_code                     => x_position_code,
      x_position_remarks                  => x_position_remarks,
      x_subject_field_code                => x_subject_field_code,
      x_subject_field_remarks             => x_subject_field_remarks,
      x_matriculation                     => x_matriculation,
      x_remarks                           => x_remarks,
      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_category_code                     => x_category_code,
      x_init_prgm_start_date              => x_init_prgm_start_date,
      x_govt_org1_othr_name               => x_govt_org1_othr_name,
      x_govt_org2_othr_name               => x_govt_org2_othr_name,
      x_intl_org1_othr_name               => x_intl_org1_othr_name,
      x_intl_org2_othr_name               => x_intl_org2_othr_name,
      x_no_show_flag			  => x_no_show_flag,
      x_other_govt_name			  => x_other_govt_name,
      x_sevis_school_id			  => x_sevis_school_id
    );
Line: 1014

 UPDATE igs_pe_ev_form
      SET
        person_id                         = new_references.person_id,
        print_form                        = new_references.print_form,
        form_effective_date               = new_references.form_effective_date,
        form_status                       = new_references.form_status,
        create_reason                     = new_references.create_reason,
        is_valid                          = new_references.is_valid,
        prgm_sponsor_amt                  = new_references.prgm_sponsor_amt,
        govt_org1_amt                     = new_references.govt_org1_amt,
        govt_org1_code                    = new_references.govt_org1_code,
        govt_org2_amt                     = new_references.govt_org2_amt,
        govt_org2_code                    = new_references.govt_org2_code,
        intl_org1_amt                     = new_references.intl_org1_amt,
        intl_org1_code                    = new_references.intl_org1_code,
        intl_org2_amt                     = new_references.intl_org2_amt,
        intl_org2_code                    = new_references.intl_org2_code,
        ev_govt_amt                       = new_references.ev_govt_amt,
        bi_natnl_com_amt                  = new_references.bi_natnl_com_amt,
        other_govt_amt                    = new_references.other_govt_amt,
        personal_funds_amt                = new_references.personal_funds_amt,
        ev_form_number                    = new_references.ev_form_number,
        prgm_start_date                   = new_references.prgm_start_date,
        prgm_end_date                     = new_references.prgm_end_date,
        last_reprint_date                 = new_references.last_reprint_date,
        reprint_reason                    = new_references.reprint_reason,
        reprint_remarks                   = new_references.reprint_remarks,
        position_code                     = new_references.position_code,
        position_remarks                  = new_references.position_remarks,
        subject_field_code                = new_references.subject_field_code,
        subject_field_remarks             = new_references.subject_field_remarks,
        matriculation                     = new_references.matriculation,
        remarks                           = new_references.remarks,
	govt_org1_othr_name               = new_references.govt_org1_othr_name,
        govt_org2_othr_name               = new_references.govt_org2_othr_name,
        intl_org1_othr_name               = new_references.intl_org1_othr_name,
        intl_org2_othr_name               = new_references.intl_org2_othr_name,
        last_update_date                  = x_last_update_date,
        last_updated_by                   = x_last_updated_by,
        last_update_login                 = x_last_update_login ,
        category_code                     = x_category_code,
        init_prgm_start_date              = x_init_prgm_start_date,
	no_show_flag			  = x_no_show_flag,
	other_govt_name			  = new_references.other_govt_name,
	SEVIS_SCHOOL_IDENTIFIER			  = new_references.SEVIS_SCHOOL_IDENTIFIER
      WHERE rowid = x_rowid;
Line: 1072

    afterrowinsertupdatedel(FALSE,TRUE,FALSE);
Line: 1087

 END update_row;
Line: 1138

  ||  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)
  */
    CURSOR c1 IS
      SELECT   rowid
      FROM     igs_pe_ev_form
      WHERE    ev_form_id                        = x_ev_form_id;
Line: 1156

      insert_row (
        x_rowid,
        x_ev_form_id,
        x_person_id,
        x_print_form,
        x_form_effective_date,
        x_form_status,
        x_create_reason,
        x_is_valid,
        x_prgm_sponsor_amt,
        x_govt_org1_amt,
        x_govt_org1_code,
        x_govt_org2_amt,
        x_govt_org2_code,
        x_intl_org1_amt,
        x_intl_org1_code,
        x_intl_org2_amt,
        x_intl_org2_code,
        x_ev_govt_amt,
        x_bi_natnl_com_amt,
        x_other_govt_amt,
        x_personal_funds_amt,
        x_ev_form_number,
        x_prgm_start_date,
        x_prgm_end_date,
        x_last_reprint_date,
        x_reprint_reason,
        x_reprint_remarks,
        x_position_code,
        x_position_remarks,
        x_subject_field_code,
        x_subject_field_remarks,
        x_matriculation,
        x_remarks,
        x_mode ,
        x_category_code,
        x_init_prgm_start_date,
	x_govt_org1_othr_name,
	x_govt_org2_othr_name,
	x_intl_org1_othr_name,
	x_intl_org2_othr_name,
	x_no_show_flag,
	x_other_govt_name,
	x_sevis_school_id
      );
Line: 1205

    update_row (
      x_rowid,
      x_ev_form_id,
      x_person_id,
      x_print_form,
      x_form_effective_date,
      x_form_status,
      x_create_reason,
      x_is_valid,
      x_prgm_sponsor_amt,
      x_govt_org1_amt,
      x_govt_org1_code,
      x_govt_org2_amt,
      x_govt_org2_code,
      x_intl_org1_amt,
      x_intl_org1_code,
      x_intl_org2_amt,
      x_intl_org2_code,
      x_ev_govt_amt,
      x_bi_natnl_com_amt,
      x_other_govt_amt,
      x_personal_funds_amt,
      x_ev_form_number,
      x_prgm_start_date,
      x_prgm_end_date,
      x_last_reprint_date,
      x_reprint_reason,
      x_reprint_remarks,
      x_position_code,
      x_position_remarks,
      x_subject_field_code,
      x_subject_field_remarks,
      x_matriculation,
      x_remarks,
      x_mode ,
      x_category_code,
      x_init_prgm_start_date,
      x_govt_org1_othr_name,
      x_govt_org2_othr_name,
      x_intl_org1_othr_name,
      x_intl_org2_othr_name,
      x_no_show_flag,
      x_other_govt_name,
      x_sevis_school_id
    );
Line: 1254

  PROCEDURE delete_row (
    x_rowid IN VARCHAR2,
  x_mode IN VARCHAR2
  ) AS
  /*
  ||  Created By : [email protected]
  ||  Created On : 28-NOV-2002
  ||  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: 1277

 DELETE FROM igs_pe_ev_form
    WHERE rowid = x_rowid;
Line: 1291

    afterrowinsertupdatedel(FALSE,FALSE,TRUE);
Line: 1293

  END delete_row;