DBA Data[Home] [Help]

APPS.IGS_ST_GOVT_STDNT_EN_PKG SQL Statements

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

Line: 58

    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

    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     IGS_ST_GOVT_STDNT_EN
      WHERE    rowid = x_rowid;
Line: 76

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

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

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

    new_references.last_update_date := x_last_update_date;
Line: 139

    new_references.last_updated_by := x_last_updated_by;
Line: 140

    new_references.last_update_login := x_last_update_login;
Line: 144

  PROCEDURE BeforeRowInsertUpdateDelete1(
    p_inserting IN BOOLEAN DEFAULT FALSE,
    p_updating IN BOOLEAN DEFAULT FALSE,
    p_deleting IN BOOLEAN DEFAULT FALSE
    ) AS
	v_message_name VARCHAR2(30);
Line: 154

	IF p_inserting THEN
		v_transaction_type := 'p_inserting';
Line: 178

  END BeforeRowInsertUpdateDelete1;
Line: 193

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

      SELECT   rowid
      FROM     IGS_ST_GOVT_STDNT_EN
      WHERE    submission_yr = x_submission_yr
      AND      submission_number = x_submission_number
      AND      person_id = x_person_id
      AND      course_cd = x_course_cd
      FOR UPDATE NOWAIT;
Line: 239

      SELECT   rowid
      FROM     IGS_ST_GOVT_STDNT_EN
      WHERE    submission_yr = x_submission_yr
      AND      submission_number = x_submission_number ;
Line: 311

    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
  BEGIN

    Set_Column_Values (
      p_action,
      x_rowid,
      x_submission_yr,
      x_submission_number,
      x_person_id,
      x_course_cd,
      x_version_number,
      x_birth_dt,
      x_sex,
      x_aborig_torres_cd,
      x_govt_aborig_torres_cd,
      x_citizenship_cd,
      x_govt_citizenship_cd,
      x_perm_resident_cd,
      x_govt_perm_resident_cd,
      x_home_location,
      x_govt_home_location,
      x_term_location,
      x_govt_term_location,
      x_birth_country_cd,
      x_govt_birth_country_cd,
      x_yr_arrival,
      x_home_language_cd,
      x_govt_home_language_cd,
      x_prior_ug_inst,
      x_govt_prior_ug_inst,
      x_prior_other_qual,
      x_prior_post_grad,
      x_prior_degree,
      x_prior_subdeg_notafe,
      x_prior_subdeg_tafe,
      x_prior_seced_tafe,
      x_prior_seced_school,
      x_prior_tafe_award,
      x_prior_studies_exemption,
      x_exemption_institution_cd,
      x_govt_exempt_institu_cd,
      x_attendance_mode,
      x_govt_attendance_mode,
      x_attendance_type,
      x_govt_attendance_type,
      x_commencement_dt,
      x_major_course,
      x_tertiary_entrance_score,
      x_basis_for_admission_type,
      x_govt_basis_for_adm_type,
      x_govt_disability,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );
Line: 372

    IF (p_action = 'INSERT') THEN
      BeforeRowInsertUpdateDelete1 ( p_inserting => TRUE );
Line: 386

    ELSIF (p_action = 'UPDATE') THEN
      BeforeRowInsertUpdateDelete1 ( p_updating => TRUE );
Line: 390

    ELSIF (p_action = 'DELETE') THEN
      BeforeRowInsertUpdateDelete1 ( p_deleting => TRUE );
Line: 392

    ELSIF (p_action = 'VALIDATE_INSERT') THEN
	IF Get_PK_For_Validation (
		new_references.submission_yr,
		new_references.submission_number,
		new_references.person_id,
		new_references.course_cd
	) THEN
		Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
Line: 404

    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
	Null;
Line: 406

    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      Null;
Line: 420

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_SUBMISSION_YR in NUMBER,
  X_SUBMISSION_NUMBER in NUMBER,
  X_PERSON_ID in NUMBER,
  X_COURSE_CD in VARCHAR2,
  X_VERSION_NUMBER in NUMBER,
  X_BIRTH_DT in DATE,
  X_SEX in VARCHAR2,
  X_ABORIG_TORRES_CD in VARCHAR2,
  X_GOVT_ABORIG_TORRES_CD in NUMBER,
  X_CITIZENSHIP_CD in VARCHAR2,
  X_GOVT_CITIZENSHIP_CD in NUMBER,
  X_PERM_RESIDENT_CD in VARCHAR2,
  X_GOVT_PERM_RESIDENT_CD in NUMBER,
  X_HOME_LOCATION in VARCHAR2,
  X_GOVT_HOME_LOCATION in VARCHAR2,
  X_TERM_LOCATION in VARCHAR2,
  X_GOVT_TERM_LOCATION in VARCHAR2,
  X_BIRTH_COUNTRY_CD in VARCHAR2,
  X_GOVT_BIRTH_COUNTRY_CD in VARCHAR2,
  X_YR_ARRIVAL in VARCHAR2,
  X_HOME_LANGUAGE_CD in VARCHAR2,
  X_GOVT_HOME_LANGUAGE_CD in NUMBER,
  X_PRIOR_UG_INST in VARCHAR2,
  X_GOVT_PRIOR_UG_INST in VARCHAR2,
  X_PRIOR_OTHER_QUAL in VARCHAR2,
  X_PRIOR_POST_GRAD in VARCHAR2,
  X_PRIOR_DEGREE in VARCHAR2,
  X_PRIOR_SUBDEG_NOTAFE in VARCHAR2,
  X_PRIOR_SUBDEG_TAFE in VARCHAR2,
  X_PRIOR_SECED_TAFE in VARCHAR2,
  X_PRIOR_SECED_SCHOOL in VARCHAR2,
  X_PRIOR_TAFE_AWARD in VARCHAR2,
  X_PRIOR_STUDIES_EXEMPTION in NUMBER,
  X_EXEMPTION_INSTITUTION_CD in VARCHAR2,
  X_GOVT_EXEMPT_INSTITU_CD in VARCHAR2,
  X_ATTENDANCE_MODE in VARCHAR2,
  X_GOVT_ATTENDANCE_MODE in VARCHAR2,
  X_ATTENDANCE_TYPE in VARCHAR2,
  X_GOVT_ATTENDANCE_TYPE in VARCHAR2,
  X_COMMENCEMENT_DT in DATE,
  X_MAJOR_COURSE in NUMBER,
  X_TERTIARY_ENTRANCE_SCORE in NUMBER,
  X_BASIS_FOR_ADMISSION_TYPE in VARCHAR2,
  X_GOVT_BASIS_FOR_ADM_TYPE in VARCHAR2,
  X_GOVT_DISABILITY in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    cursor C is select ROWID from IGS_ST_GOVT_STDNT_EN
      where SUBMISSION_YR = X_SUBMISSION_YR
      and SUBMISSION_NUMBER = X_SUBMISSION_NUMBER
      and PERSON_ID = X_PERSON_ID
      and COURSE_CD = X_COURSE_CD;
Line: 474

    X_LAST_UPDATE_DATE DATE;
Line: 475

    X_LAST_UPDATED_BY NUMBER;
Line: 476

    X_LAST_UPDATE_LOGIN NUMBER;
Line: 480

    X_PROGRAM_UPDATE_DATE DATE;
Line: 483

  X_LAST_UPDATE_DATE := SYSDATE;
Line: 485

    X_LAST_UPDATED_BY := 1;
Line: 486

    X_LAST_UPDATE_LOGIN := 0;
Line: 488

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 489

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;
Line: 492

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 493

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;
Line: 503

      X_PROGRAM_UPDATE_DATE := NULL;
Line: 505

      X_PROGRAM_UPDATE_DATE := SYSDATE;
Line: 513

     p_action => 'INSERT',
     x_rowid => X_ROWID,
     x_submission_yr => X_SUBMISSION_YR,
     x_submission_number => X_SUBMISSION_NUMBER,
     x_person_id => X_PERSON_ID,
     x_course_cd => X_COURSE_CD,
     x_version_number => X_VERSION_NUMBER,
     x_birth_dt => X_BIRTH_DT,
     x_sex => X_SEX,
     x_aborig_torres_cd => X_ABORIG_TORRES_CD,
     x_govt_aborig_torres_cd => X_GOVT_ABORIG_TORRES_CD,
     x_citizenship_cd => X_CITIZENSHIP_CD,
     x_govt_citizenship_cd => X_GOVT_CITIZENSHIP_CD,
     x_perm_resident_cd => X_PERM_RESIDENT_CD,
     x_govt_perm_resident_cd => X_GOVT_PERM_RESIDENT_CD,
     x_home_location => X_HOME_LOCATION,
     x_govt_home_location => X_GOVT_HOME_LOCATION,
     x_term_location => X_TERM_LOCATION,
     x_govt_term_location => X_GOVT_TERM_LOCATION,
     x_birth_country_cd => X_BIRTH_COUNTRY_CD,
     x_govt_birth_country_cd => X_GOVT_BIRTH_COUNTRY_CD,
     x_yr_arrival => X_YR_ARRIVAL,
     x_home_language_cd => X_HOME_LANGUAGE_CD,
     x_govt_home_language_cd => X_GOVT_HOME_LANGUAGE_CD,
     x_prior_ug_inst => X_PRIOR_UG_INST,
     x_govt_prior_ug_inst => X_GOVT_PRIOR_UG_INST,
     x_prior_other_qual => X_PRIOR_OTHER_QUAL,
     x_prior_post_grad => X_PRIOR_POST_GRAD,
     x_prior_degree => X_PRIOR_DEGREE,
     x_prior_subdeg_notafe => X_PRIOR_SUBDEG_NOTAFE,
     x_prior_subdeg_tafe => X_PRIOR_SUBDEG_TAFE,
     x_prior_seced_tafe => X_PRIOR_SECED_TAFE,
     x_prior_seced_school => X_PRIOR_SECED_SCHOOL,
     x_prior_tafe_award => X_PRIOR_TAFE_AWARD,
     x_prior_studies_exemption => X_PRIOR_STUDIES_EXEMPTION,
     x_exemption_institution_cd => X_EXEMPTION_INSTITUTION_CD,
     x_govt_exempt_institu_cd => X_GOVT_EXEMPT_INSTITU_CD,
     x_attendance_mode => X_ATTENDANCE_MODE,
     x_govt_attendance_mode => X_GOVT_ATTENDANCE_MODE,
     x_attendance_type => X_ATTENDANCE_TYPE,
     x_govt_attendance_type => X_GOVT_ATTENDANCE_TYPE,
     x_commencement_dt => X_COMMENCEMENT_DT,
     x_major_course => X_MAJOR_COURSE,
     x_tertiary_entrance_score => X_TERTIARY_ENTRANCE_SCORE,
     x_basis_for_admission_type => X_BASIS_FOR_ADMISSION_TYPE,
     x_govt_basis_for_adm_type => X_GOVT_BASIS_FOR_ADM_TYPE,
     x_govt_disability => X_GOVT_DISABILITY,
     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
  );
Line: 567

  insert into IGS_ST_GOVT_STDNT_EN (
    SUBMISSION_YR,
    SUBMISSION_NUMBER,
    PERSON_ID,
    COURSE_CD,
    VERSION_NUMBER,
    BIRTH_DT,
    SEX,
    ABORIG_TORRES_CD,
    GOVT_ABORIG_TORRES_CD,
    CITIZENSHIP_CD,
    GOVT_CITIZENSHIP_CD,
    PERM_RESIDENT_CD,
    GOVT_PERM_RESIDENT_CD,
    HOME_LOCATION,
    GOVT_HOME_LOCATION,
    TERM_LOCATION,
    GOVT_TERM_LOCATION,
    BIRTH_COUNTRY_CD,
    GOVT_BIRTH_COUNTRY_CD,
    YR_ARRIVAL,
    HOME_LANGUAGE_CD,
    GOVT_HOME_LANGUAGE_CD,
    PRIOR_UG_INST,
    GOVT_PRIOR_UG_INST,
    PRIOR_OTHER_QUAL,
    PRIOR_POST_GRAD,
    PRIOR_DEGREE,
    PRIOR_SUBDEG_NOTAFE,
    PRIOR_SUBDEG_TAFE,
    PRIOR_SECED_TAFE,
    PRIOR_SECED_SCHOOL,
    PRIOR_TAFE_AWARD,
    PRIOR_STUDIES_EXEMPTION,
    EXEMPTION_INSTITUTION_CD,
    GOVT_EXEMPTION_INSTITUTION_CD,
    ATTENDANCE_MODE,
    GOVT_ATTENDANCE_MODE,
    ATTENDANCE_TYPE,
    GOVT_ATTENDANCE_TYPE,
    COMMENCEMENT_DT,
    MAJOR_COURSE,
    TERTIARY_ENTRANCE_SCORE,
    BASIS_FOR_ADMISSION_TYPE,
    GOVT_BASIS_FOR_ADMISSION_TYPE,
    GOVT_DISABILITY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    REQUEST_ID,
    PROGRAM_ID,
    PROGRAM_APPLICATION_ID,
    PROGRAM_UPDATE_DATE
  ) values (
    NEW_REFERENCES.SUBMISSION_YR,
    NEW_REFERENCES.SUBMISSION_NUMBER,
    NEW_REFERENCES.PERSON_ID,
    NEW_REFERENCES.COURSE_CD,
    NEW_REFERENCES.VERSION_NUMBER,
    NEW_REFERENCES.BIRTH_DT,
    NEW_REFERENCES.SEX,
    NEW_REFERENCES.ABORIG_TORRES_CD,
    NEW_REFERENCES.GOVT_ABORIG_TORRES_CD,
    NEW_REFERENCES.CITIZENSHIP_CD,
    NEW_REFERENCES.GOVT_CITIZENSHIP_CD,
    NEW_REFERENCES.PERM_RESIDENT_CD,
    NEW_REFERENCES.GOVT_PERM_RESIDENT_CD,
    NEW_REFERENCES.HOME_LOCATION,
    NEW_REFERENCES.GOVT_HOME_LOCATION,
    NEW_REFERENCES.TERM_LOCATION,
    NEW_REFERENCES.GOVT_TERM_LOCATION,
    NEW_REFERENCES.BIRTH_COUNTRY_CD,
    NEW_REFERENCES.GOVT_BIRTH_COUNTRY_CD,
    NEW_REFERENCES.YR_ARRIVAL,
    NEW_REFERENCES.HOME_LANGUAGE_CD,
    NEW_REFERENCES.GOVT_HOME_LANGUAGE_CD,
    NEW_REFERENCES.PRIOR_UG_INST,
    NEW_REFERENCES.GOVT_PRIOR_UG_INST,
    NEW_REFERENCES.PRIOR_OTHER_QUAL,
    NEW_REFERENCES.PRIOR_POST_GRAD,
    NEW_REFERENCES.PRIOR_DEGREE,
    NEW_REFERENCES.PRIOR_SUBDEG_NOTAFE,
    NEW_REFERENCES.PRIOR_SUBDEG_TAFE,
    NEW_REFERENCES.PRIOR_SECED_TAFE,
    NEW_REFERENCES.PRIOR_SECED_SCHOOL,
    NEW_REFERENCES.PRIOR_TAFE_AWARD,
    NEW_REFERENCES.PRIOR_STUDIES_EXEMPTION,
    NEW_REFERENCES.EXEMPTION_INSTITUTION_CD,
    NEW_REFERENCES.GOVT_EXEMPTION_INSTITUTION_CD,
    NEW_REFERENCES.ATTENDANCE_MODE,
    NEW_REFERENCES.GOVT_ATTENDANCE_MODE,
    NEW_REFERENCES.ATTENDANCE_TYPE,
    NEW_REFERENCES.GOVT_ATTENDANCE_TYPE,
    NEW_REFERENCES.COMMENCEMENT_DT,
    NEW_REFERENCES.MAJOR_COURSE,
    NEW_REFERENCES.TERTIARY_ENTRANCE_SCORE,
    NEW_REFERENCES.BASIS_FOR_ADMISSION_TYPE,
    NEW_REFERENCES.GOVT_BASIS_FOR_ADMISSION_TYPE,
    NEW_REFERENCES.GOVT_DISABILITY,
    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
  );
Line: 687

     p_action => 'INSERT',
     x_rowid => X_ROWID
    );
Line: 691

end INSERT_ROW;
Line: 741

  cursor c1 is select
      VERSION_NUMBER,
      BIRTH_DT,
      SEX,
      ABORIG_TORRES_CD,
      GOVT_ABORIG_TORRES_CD,
      CITIZENSHIP_CD,
      GOVT_CITIZENSHIP_CD,
      PERM_RESIDENT_CD,
      GOVT_PERM_RESIDENT_CD,
      HOME_LOCATION,
      GOVT_HOME_LOCATION,
      TERM_LOCATION,
      GOVT_TERM_LOCATION,
      BIRTH_COUNTRY_CD,
      GOVT_BIRTH_COUNTRY_CD,
      YR_ARRIVAL,
      HOME_LANGUAGE_CD,
      GOVT_HOME_LANGUAGE_CD,
      PRIOR_UG_INST,
      GOVT_PRIOR_UG_INST,
      PRIOR_OTHER_QUAL,
      PRIOR_POST_GRAD,
      PRIOR_DEGREE,
      PRIOR_SUBDEG_NOTAFE,
      PRIOR_SUBDEG_TAFE,
      PRIOR_SECED_TAFE,
      PRIOR_SECED_SCHOOL,
      PRIOR_TAFE_AWARD,
      PRIOR_STUDIES_EXEMPTION,
      EXEMPTION_INSTITUTION_CD,
      GOVT_EXEMPTION_INSTITUTION_CD,
      ATTENDANCE_MODE,
      GOVT_ATTENDANCE_MODE,
      ATTENDANCE_TYPE,
      GOVT_ATTENDANCE_TYPE,
      COMMENCEMENT_DT,
      MAJOR_COURSE,
      TERTIARY_ENTRANCE_SCORE,
      BASIS_FOR_ADMISSION_TYPE,
      GOVT_BASIS_FOR_ADMISSION_TYPE,
      GOVT_DISABILITY
    from IGS_ST_GOVT_STDNT_EN
    where ROWID = X_ROWID
    for update nowait;
Line: 793

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

procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_SUBMISSION_YR in NUMBER,
  X_SUBMISSION_NUMBER in NUMBER,
  X_PERSON_ID in NUMBER,
  X_COURSE_CD in VARCHAR2,
  X_VERSION_NUMBER in NUMBER,
  X_BIRTH_DT in DATE,
  X_SEX in VARCHAR2,
  X_ABORIG_TORRES_CD in VARCHAR2,
  X_GOVT_ABORIG_TORRES_CD in NUMBER,
  X_CITIZENSHIP_CD in VARCHAR2,
  X_GOVT_CITIZENSHIP_CD in NUMBER,
  X_PERM_RESIDENT_CD in VARCHAR2,
  X_GOVT_PERM_RESIDENT_CD in NUMBER,
  X_HOME_LOCATION in VARCHAR2,
  X_GOVT_HOME_LOCATION in VARCHAR2,
  X_TERM_LOCATION in VARCHAR2,
  X_GOVT_TERM_LOCATION in VARCHAR2,
  X_BIRTH_COUNTRY_CD in VARCHAR2,
  X_GOVT_BIRTH_COUNTRY_CD in VARCHAR2,
  X_YR_ARRIVAL in VARCHAR2,
  X_HOME_LANGUAGE_CD in VARCHAR2,
  X_GOVT_HOME_LANGUAGE_CD in NUMBER,
  X_PRIOR_UG_INST in VARCHAR2,
  X_GOVT_PRIOR_UG_INST in VARCHAR2,
  X_PRIOR_OTHER_QUAL in VARCHAR2,
  X_PRIOR_POST_GRAD in VARCHAR2,
  X_PRIOR_DEGREE in VARCHAR2,
  X_PRIOR_SUBDEG_NOTAFE in VARCHAR2,
  X_PRIOR_SUBDEG_TAFE in VARCHAR2,
  X_PRIOR_SECED_TAFE in VARCHAR2,
  X_PRIOR_SECED_SCHOOL in VARCHAR2,
  X_PRIOR_TAFE_AWARD in VARCHAR2,
  X_PRIOR_STUDIES_EXEMPTION in NUMBER,
  X_EXEMPTION_INSTITUTION_CD in VARCHAR2,
  X_GOVT_EXEMPT_INSTITU_CD in VARCHAR2,
  X_ATTENDANCE_MODE in VARCHAR2,
  X_GOVT_ATTENDANCE_MODE in VARCHAR2,
  X_ATTENDANCE_TYPE in VARCHAR2,
  X_GOVT_ATTENDANCE_TYPE in VARCHAR2,
  X_COMMENCEMENT_DT in DATE,
  X_MAJOR_COURSE in NUMBER,
  X_TERTIARY_ENTRANCE_SCORE in NUMBER,
  X_BASIS_FOR_ADMISSION_TYPE in VARCHAR2,
  X_GOVT_BASIS_FOR_ADM_TYPE in VARCHAR2,
  X_GOVT_DISABILITY in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    X_LAST_UPDATE_DATE DATE;
Line: 903

    X_LAST_UPDATED_BY NUMBER;
Line: 904

    X_LAST_UPDATE_LOGIN NUMBER;
Line: 908

    X_PROGRAM_UPDATE_DATE DATE;
Line: 911

  X_LAST_UPDATE_DATE := SYSDATE;
Line: 913

    X_LAST_UPDATED_BY := 1;
Line: 914

    X_LAST_UPDATE_LOGIN := 0;
Line: 916

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 917

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;
Line: 920

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 921

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;
Line: 931

     p_action => 'UPDATE',
     x_rowid => X_ROWID,
     x_submission_yr => X_SUBMISSION_YR,
     x_submission_number => X_SUBMISSION_NUMBER,
     x_person_id => X_PERSON_ID,
     x_course_cd => X_COURSE_CD,
     x_version_number => X_VERSION_NUMBER,
     x_birth_dt => X_BIRTH_DT,
     x_sex => X_SEX,
     x_aborig_torres_cd => X_ABORIG_TORRES_CD,
     x_govt_aborig_torres_cd => X_GOVT_ABORIG_TORRES_CD,
     x_citizenship_cd => X_CITIZENSHIP_CD,
     x_govt_citizenship_cd => X_GOVT_CITIZENSHIP_CD,
     x_perm_resident_cd => X_PERM_RESIDENT_CD,
     x_govt_perm_resident_cd => X_GOVT_PERM_RESIDENT_CD,
     x_home_location => X_HOME_LOCATION,
     x_govt_home_location => X_GOVT_HOME_LOCATION,
     x_term_location => X_TERM_LOCATION,
     x_govt_term_location => X_GOVT_TERM_LOCATION,
     x_birth_country_cd => X_BIRTH_COUNTRY_CD,
     x_govt_birth_country_cd => X_GOVT_BIRTH_COUNTRY_CD,
     x_yr_arrival => X_YR_ARRIVAL,
     x_home_language_cd => X_HOME_LANGUAGE_CD,
     x_govt_home_language_cd => X_GOVT_HOME_LANGUAGE_CD,
     x_prior_ug_inst => X_PRIOR_UG_INST,
     x_govt_prior_ug_inst => X_GOVT_PRIOR_UG_INST,
     x_prior_other_qual => X_PRIOR_OTHER_QUAL,
     x_prior_post_grad => X_PRIOR_POST_GRAD,
     x_prior_degree => X_PRIOR_DEGREE,
     x_prior_subdeg_notafe => X_PRIOR_SUBDEG_NOTAFE,
     x_prior_subdeg_tafe => X_PRIOR_SUBDEG_TAFE,
     x_prior_seced_tafe => X_PRIOR_SECED_TAFE,
     x_prior_seced_school => X_PRIOR_SECED_SCHOOL,
     x_prior_tafe_award => X_PRIOR_TAFE_AWARD,
     x_prior_studies_exemption => X_PRIOR_STUDIES_EXEMPTION,
     x_exemption_institution_cd => X_EXEMPTION_INSTITUTION_CD,
     x_govt_exempt_institu_cd => X_GOVT_EXEMPT_INSTITU_CD,
     x_attendance_mode => X_ATTENDANCE_MODE,
     x_govt_attendance_mode => X_GOVT_ATTENDANCE_MODE,
     x_attendance_type => X_ATTENDANCE_TYPE,
     x_govt_attendance_type => X_GOVT_ATTENDANCE_TYPE,
     x_commencement_dt => X_COMMENCEMENT_DT,
     x_major_course => X_MAJOR_COURSE,
     x_tertiary_entrance_score => X_TERTIARY_ENTRANCE_SCORE,
     x_basis_for_admission_type => X_BASIS_FOR_ADMISSION_TYPE,
     x_govt_basis_for_adm_type => X_GOVT_BASIS_FOR_ADM_TYPE,
     x_govt_disability => X_GOVT_DISABILITY,
     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
  );
Line: 993

      X_PROGRAM_UPDATE_DATE := OLD_REFERENCES.PROGRAM_UPDATE_DATE;
Line: 995

      X_PROGRAM_UPDATE_DATE := SYSDATE;
Line: 999

update IGS_ST_GOVT_STDNT_EN set
    VERSION_NUMBER = NEW_REFERENCES.VERSION_NUMBER,
    BIRTH_DT = NEW_REFERENCES.BIRTH_DT,
    SEX = NEW_REFERENCES.SEX,
    ABORIG_TORRES_CD = NEW_REFERENCES.ABORIG_TORRES_CD,
    GOVT_ABORIG_TORRES_CD = NEW_REFERENCES.GOVT_ABORIG_TORRES_CD,
    CITIZENSHIP_CD = NEW_REFERENCES.CITIZENSHIP_CD,
    GOVT_CITIZENSHIP_CD = NEW_REFERENCES.GOVT_CITIZENSHIP_CD,
    PERM_RESIDENT_CD = NEW_REFERENCES.PERM_RESIDENT_CD,
    GOVT_PERM_RESIDENT_CD = NEW_REFERENCES.GOVT_PERM_RESIDENT_CD,
    HOME_LOCATION = NEW_REFERENCES.HOME_LOCATION,
    GOVT_HOME_LOCATION = NEW_REFERENCES.GOVT_HOME_LOCATION,
    TERM_LOCATION = NEW_REFERENCES.TERM_LOCATION,
    GOVT_TERM_LOCATION = NEW_REFERENCES.GOVT_TERM_LOCATION,
    BIRTH_COUNTRY_CD = NEW_REFERENCES.BIRTH_COUNTRY_CD,
    GOVT_BIRTH_COUNTRY_CD = NEW_REFERENCES.GOVT_BIRTH_COUNTRY_CD,
    YR_ARRIVAL = NEW_REFERENCES.YR_ARRIVAL,
    HOME_LANGUAGE_CD = NEW_REFERENCES.HOME_LANGUAGE_CD,
    GOVT_HOME_LANGUAGE_CD = NEW_REFERENCES.GOVT_HOME_LANGUAGE_CD,
    PRIOR_UG_INST = NEW_REFERENCES.PRIOR_UG_INST,
    GOVT_PRIOR_UG_INST = NEW_REFERENCES.GOVT_PRIOR_UG_INST,
    PRIOR_OTHER_QUAL = NEW_REFERENCES.PRIOR_OTHER_QUAL,
    PRIOR_POST_GRAD = NEW_REFERENCES.PRIOR_POST_GRAD,
    PRIOR_DEGREE = NEW_REFERENCES.PRIOR_DEGREE,
    PRIOR_SUBDEG_NOTAFE = NEW_REFERENCES.PRIOR_SUBDEG_NOTAFE,
    PRIOR_SUBDEG_TAFE = NEW_REFERENCES.PRIOR_SUBDEG_TAFE,
    PRIOR_SECED_TAFE = NEW_REFERENCES.PRIOR_SECED_TAFE,
    PRIOR_SECED_SCHOOL = NEW_REFERENCES.PRIOR_SECED_SCHOOL,
    PRIOR_TAFE_AWARD = NEW_REFERENCES.PRIOR_TAFE_AWARD,
    PRIOR_STUDIES_EXEMPTION = NEW_REFERENCES.PRIOR_STUDIES_EXEMPTION,
    EXEMPTION_INSTITUTION_CD = NEW_REFERENCES.EXEMPTION_INSTITUTION_CD,
    GOVT_EXEMPTION_INSTITUTION_CD = NEW_REFERENCES.GOVT_EXEMPTION_INSTITUTION_CD,
    ATTENDANCE_MODE = NEW_REFERENCES.ATTENDANCE_MODE,
    GOVT_ATTENDANCE_MODE = NEW_REFERENCES.GOVT_ATTENDANCE_MODE,
    ATTENDANCE_TYPE = NEW_REFERENCES.ATTENDANCE_TYPE,
    GOVT_ATTENDANCE_TYPE = NEW_REFERENCES.GOVT_ATTENDANCE_TYPE,
    COMMENCEMENT_DT = NEW_REFERENCES.COMMENCEMENT_DT,
    MAJOR_COURSE = NEW_REFERENCES.MAJOR_COURSE,
    TERTIARY_ENTRANCE_SCORE = NEW_REFERENCES.TERTIARY_ENTRANCE_SCORE,
    BASIS_FOR_ADMISSION_TYPE = NEW_REFERENCES.BASIS_FOR_ADMISSION_TYPE,
    GOVT_BASIS_FOR_ADMISSION_TYPE = NEW_REFERENCES.GOVT_BASIS_FOR_ADMISSION_TYPE,
    GOVT_DISABILITY = NEW_REFERENCES.GOVT_DISABILITY,
    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

  where ROWID = X_ROWID
  ;
Line: 1055

     p_action => 'UPDATE',
     x_rowid => X_ROWID
    );
Line: 1058

end UPDATE_ROW;
Line: 1109

  cursor c1 is select rowid from IGS_ST_GOVT_STDNT_EN
     where SUBMISSION_YR = X_SUBMISSION_YR
     and SUBMISSION_NUMBER = X_SUBMISSION_NUMBER
     and PERSON_ID = X_PERSON_ID
     and COURSE_CD = X_COURSE_CD
  ;
Line: 1120

    INSERT_ROW (
     X_ROWID,
     X_SUBMISSION_YR,
     X_SUBMISSION_NUMBER,
     X_PERSON_ID,
     X_COURSE_CD,
     X_VERSION_NUMBER,
     X_BIRTH_DT,
     X_SEX,
     X_ABORIG_TORRES_CD,
     X_GOVT_ABORIG_TORRES_CD,
     X_CITIZENSHIP_CD,
     X_GOVT_CITIZENSHIP_CD,
     X_PERM_RESIDENT_CD,
     X_GOVT_PERM_RESIDENT_CD,
     X_HOME_LOCATION,
     X_GOVT_HOME_LOCATION,
     X_TERM_LOCATION,
     X_GOVT_TERM_LOCATION,
     X_BIRTH_COUNTRY_CD,
     X_GOVT_BIRTH_COUNTRY_CD,
     X_YR_ARRIVAL,
     X_HOME_LANGUAGE_CD,
     X_GOVT_HOME_LANGUAGE_CD,
     X_PRIOR_UG_INST,
     X_GOVT_PRIOR_UG_INST,
     X_PRIOR_OTHER_QUAL,
     X_PRIOR_POST_GRAD,
     X_PRIOR_DEGREE,
     X_PRIOR_SUBDEG_NOTAFE,
     X_PRIOR_SUBDEG_TAFE,
     X_PRIOR_SECED_TAFE,
     X_PRIOR_SECED_SCHOOL,
     X_PRIOR_TAFE_AWARD,
     X_PRIOR_STUDIES_EXEMPTION,
     X_EXEMPTION_INSTITUTION_CD,
     X_GOVT_EXEMPT_INSTITU_CD,
     X_ATTENDANCE_MODE,
     X_GOVT_ATTENDANCE_MODE,
     X_ATTENDANCE_TYPE,
     X_GOVT_ATTENDANCE_TYPE,
     X_COMMENCEMENT_DT,
     X_MAJOR_COURSE,
     X_TERTIARY_ENTRANCE_SCORE,
     X_BASIS_FOR_ADMISSION_TYPE,
     X_GOVT_BASIS_FOR_ADM_TYPE,
     X_GOVT_DISABILITY,
     X_MODE);
Line: 1171

  UPDATE_ROW (
   X_ROWID,
   X_SUBMISSION_YR,
   X_SUBMISSION_NUMBER,
   X_PERSON_ID,
   X_COURSE_CD,
   X_VERSION_NUMBER,
   X_BIRTH_DT,
   X_SEX,
   X_ABORIG_TORRES_CD,
   X_GOVT_ABORIG_TORRES_CD,
   X_CITIZENSHIP_CD,
   X_GOVT_CITIZENSHIP_CD,
   X_PERM_RESIDENT_CD,
   X_GOVT_PERM_RESIDENT_CD,
   X_HOME_LOCATION,
   X_GOVT_HOME_LOCATION,
   X_TERM_LOCATION,
   X_GOVT_TERM_LOCATION,
   X_BIRTH_COUNTRY_CD,
   X_GOVT_BIRTH_COUNTRY_CD,
   X_YR_ARRIVAL,
   X_HOME_LANGUAGE_CD,
   X_GOVT_HOME_LANGUAGE_CD,
   X_PRIOR_UG_INST,
   X_GOVT_PRIOR_UG_INST,
   X_PRIOR_OTHER_QUAL,
   X_PRIOR_POST_GRAD,
   X_PRIOR_DEGREE,
   X_PRIOR_SUBDEG_NOTAFE,
   X_PRIOR_SUBDEG_TAFE,
   X_PRIOR_SECED_TAFE,
   X_PRIOR_SECED_SCHOOL,
   X_PRIOR_TAFE_AWARD,
   X_PRIOR_STUDIES_EXEMPTION,
   X_EXEMPTION_INSTITUTION_CD,
   X_GOVT_EXEMPT_INSTITU_CD,
   X_ATTENDANCE_MODE,
   X_GOVT_ATTENDANCE_MODE,
   X_ATTENDANCE_TYPE,
   X_GOVT_ATTENDANCE_TYPE,
   X_COMMENCEMENT_DT,
   X_MAJOR_COURSE,
   X_TERTIARY_ENTRANCE_SCORE,
   X_BASIS_FOR_ADMISSION_TYPE,
   X_GOVT_BASIS_FOR_ADM_TYPE,
   X_GOVT_DISABILITY,
   X_MODE);
Line: 1221

procedure DELETE_ROW (
   X_ROWID in VARCHAR2
) AS
begin
  Before_DML (
     p_action => 'DELETE',
     x_rowid => X_ROWID
  );
Line: 1229

  delete from IGS_ST_GOVT_STDNT_EN
  where ROWID = X_ROWID;
Line: 1235

     p_action => 'DELETE',
     x_rowid => X_ROWID
  );
Line: 1238

end DELETE_ROW;