APPS.IGS_ST_GVT_SPSHT_CHG_PKG SQL Statements

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

Line: 16

    x_changed_update_who IN VARCHAR2 DEFAULT NULL,
    x_changed_update_on IN DATE DEFAULT NULL,
    x_govt_semester IN NUMBER DEFAULT NULL,
    x_unit_cd IN VARCHAR2 DEFAULT NULL,
    x_eftsu IN NUMBER DEFAULT NULL,
    x_hecs_prexmt_exie IN NUMBER DEFAULT NULL,
    x_hecs_amount_paid IN NUMBER DEFAULT NULL,
    x_hecs_payment_option IN VARCHAR2 DEFAULT NULL,
    x_differential_hecs_ind IN VARCHAR2 DEFAULT NULL,
    x_citizenship_cd IN VARCHAR2 DEFAULT NULL,
    x_perm_resident_cd IN VARCHAR2 DEFAULT NULL,
    x_prior_degree IN VARCHAR2 DEFAULT NULL,
    x_prior_post_grad IN VARCHAR2 DEFAULT NULL,
    x_old_unit_cd IN VARCHAR2 DEFAULT NULL,
    x_old_eftsu IN NUMBER DEFAULT NULL,
    x_old_hecs_prexmt_exie IN NUMBER DEFAULT NULL,
    x_old_hecs_amount_paid IN NUMBER DEFAULT NULL,
    x_old_hecs_payment_option IN VARCHAR2 DEFAULT NULL,
    x_old_differential_hecs_ind IN VARCHAR2 DEFAULT NULL,
    x_old_citizenship_cd IN VARCHAR2 DEFAULT NULL,
    x_old_perm_resident_cd IN VARCHAR2 DEFAULT NULL,
    x_old_prior_degree IN VARCHAR2 DEFAULT NULL,
    x_old_prior_post_grad IN VARCHAR2 DEFAULT NULL,
    x_reported_ind IN VARCHAR2 DEFAULT NULL,
    x_creation_date IN DATE DEFAULT NULL,
    x_created_by IN NUMBER DEFAULT NULL,
    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_GVT_SPSHT_CHG
      WHERE    rowid = x_rowid;

Line: 60

    IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
      Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

Line: 76

    new_references.changed_update_who := x_changed_update_who;

Line: 77

    new_references.changed_update_on := x_changed_update_on;

Line: 100

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

Line: 107

    new_references.last_update_date := x_last_update_date;

Line: 108

    new_references.last_updated_by := x_last_updated_by;

Line: 109

    new_references.last_update_login := x_last_update_login;

Line: 126

        FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');

Line: 143

      SELECT   rowid
      FROM     IGS_ST_GVT_SPSHT_CHG
      WHERE    submission_yr = x_submission_yr
      AND      submission_number = x_submission_number
      AND      person_id = x_person_id
      AND      course_cd = x_course_cd
      AND      sequence_number = x_sequence_number
      FOR UPDATE NOWAIT;

Line: 174

      SELECT   rowid
      FROM     IGS_ST_GVT_SPSHT_CHG
      WHERE    submission_yr = x_submission_yr
      AND      submission_number = x_submission_number ;

Line: 205

     ELSIF upper(column_name) = 'CHANGED_UPDATE_WHO' THEN
      new_references.changed_update_who := column_value;

Line: 241

     IF upper(column_name) = 'CHANGED_UPDATE_WHO' OR column_name IS NULL THEN
      IF new_references.changed_update_who <> UPPER(new_references.changed_update_who) THEN
       FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');

Line: 373

    x_changed_update_who IN VARCHAR2 DEFAULT NULL,
    x_changed_update_on IN DATE DEFAULT NULL,
    x_govt_semester IN NUMBER DEFAULT NULL,
    x_unit_cd IN VARCHAR2 DEFAULT NULL,
    x_eftsu IN NUMBER DEFAULT NULL,
    x_hecs_prexmt_exie IN NUMBER DEFAULT NULL,
    x_hecs_amount_paid IN NUMBER DEFAULT NULL,
    x_hecs_payment_option IN VARCHAR2 DEFAULT NULL,
    x_differential_hecs_ind IN VARCHAR2 DEFAULT NULL,
    x_citizenship_cd IN VARCHAR2 DEFAULT NULL,
    x_perm_resident_cd IN VARCHAR2 DEFAULT NULL,
    x_prior_degree IN VARCHAR2 DEFAULT NULL,
    x_prior_post_grad IN VARCHAR2 DEFAULT NULL,
    x_old_unit_cd IN VARCHAR2 DEFAULT NULL,
    x_old_eftsu IN NUMBER DEFAULT NULL,
    x_old_hecs_prexmt_exie IN NUMBER DEFAULT NULL,
    x_old_hecs_amount_paid IN NUMBER DEFAULT NULL,
    x_old_hecs_payment_option IN VARCHAR2 DEFAULT NULL,
    x_old_differential_hecs_ind IN VARCHAR2 DEFAULT NULL,
    x_old_citizenship_cd IN VARCHAR2 DEFAULT NULL,
    x_old_perm_resident_cd IN VARCHAR2 DEFAULT NULL,
    x_old_prior_degree IN VARCHAR2 DEFAULT NULL,
    x_old_prior_post_grad IN VARCHAR2 DEFAULT NULL,
    x_reported_ind IN VARCHAR2 DEFAULT NULL,
    x_creation_date IN DATE DEFAULT NULL,
    x_created_by IN NUMBER DEFAULT NULL,
    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_sequence_number,
      x_changed_update_who,
      x_changed_update_on,
      x_govt_semester,
      x_unit_cd,
      x_eftsu,
      x_hecs_prexmt_exie,
      x_hecs_amount_paid,
      x_hecs_payment_option,
      x_differential_hecs_ind,
      x_citizenship_cd,
      x_perm_resident_cd,
      x_prior_degree,
      x_prior_post_grad,
      x_old_unit_cd,
      x_old_eftsu,
      x_old_hecs_prexmt_exie,
      x_old_hecs_amount_paid,
      x_old_hecs_payment_option,
      x_old_differential_hecs_ind,
      x_old_citizenship_cd,
      x_old_perm_resident_cd,
      x_old_prior_degree,
      x_old_prior_post_grad,
      x_reported_ind,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 445

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

Line: 461

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

Line: 466

    ELSIF (p_action = 'DELETE') THEN
      -- Call all the procedures related to Before Delete.
      Null;

Line: 469

    ELSIF (p_action = 'VALIDATE_INSERT') THEN
      -- Call all the procedures related to Before Delete.
      IF GET_PK_FOR_VALIDATION(
        new_references.submission_yr,
        new_references.submission_number,
        new_references.person_id,
        new_references.course_cd,
        new_references.sequence_number
       )THEN
        FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

Line: 483

    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      -- Call all the procedures related to Before Delete.
      check_constraints;

Line: 486

    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      -- Call all the procedures related to Before Delete.
      null;

Line: 505

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_SEQUENCE_NUMBER in NUMBER,
  X_VERSION_NUMBER in NUMBER,
  X_CHANGED_UPDATE_WHO in VARCHAR2,
  X_CHANGED_UPDATE_ON in DATE,
  X_GOVT_SEMESTER in NUMBER,
  X_UNIT_CD in VARCHAR2,
  X_EFTSU in NUMBER,
  X_HECS_PREXMT_EXIE in NUMBER,
  X_HECS_AMOUNT_PAID in NUMBER,
  X_HECS_PAYMENT_OPTION in VARCHAR2,
  X_DIFFERENTIAL_HECS_IND in VARCHAR2,
  X_CITIZENSHIP_CD in VARCHAR2,
  X_PERM_RESIDENT_CD in VARCHAR2,
  X_PRIOR_DEGREE in VARCHAR2,
  X_PRIOR_POST_GRAD in VARCHAR2,
  X_OLD_UNIT_CD in VARCHAR2,
  X_OLD_EFTSU in NUMBER,
  X_OLD_HECS_PREXMT_EXIE in NUMBER,
  X_OLD_HECS_AMOUNT_PAID in NUMBER,
  X_OLD_HECS_PAYMENT_OPTION in VARCHAR2,
  X_OLD_DIFFERENTIAL_HECS_IND in VARCHAR2,
  X_OLD_CITIZENSHIP_CD in VARCHAR2,
  X_OLD_PERM_RESIDENT_CD in VARCHAR2,
  X_OLD_PRIOR_DEGREE in VARCHAR2,
  X_OLD_PRIOR_POST_GRAD in VARCHAR2,
  X_REPORTED_IND in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) as
    cursor C is select ROWID from IGS_ST_GVT_SPSHT_CHG
      where SUBMISSION_YR = X_SUBMISSION_YR
      and SUBMISSION_NUMBER = X_SUBMISSION_NUMBER
      and PERSON_ID = X_PERSON_ID
      and COURSE_CD = X_COURSE_CD
      and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER;

Line: 545

    X_LAST_UPDATE_DATE DATE;

Line: 546

    X_LAST_UPDATED_BY NUMBER;

Line: 547

    X_LAST_UPDATE_LOGIN NUMBER;

Line: 551

    X_PROGRAM_UPDATE_DATE DATE;

Line: 553

  X_LAST_UPDATE_DATE := SYSDATE;

Line: 555

    X_LAST_UPDATED_BY := 1;

Line: 556

    X_LAST_UPDATE_LOGIN := 0;

Line: 558

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 559

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 562

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 563

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 573

      X_PROGRAM_UPDATE_DATE := NULL;

Line: 575

      X_PROGRAM_UPDATE_DATE := SYSDATE;

Line: 584

    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_sequence_number => X_SEQUENCE_NUMBER,
    x_changed_update_who => X_CHANGED_UPDATE_WHO,
    x_changed_update_on => X_CHANGED_UPDATE_ON,
    x_govt_semester => X_GOVT_SEMESTER,
    x_unit_cd => X_UNIT_CD,
    x_eftsu => X_EFTSU,
    x_hecs_prexmt_exie => X_HECS_PREXMT_EXIE,
    x_hecs_amount_paid => X_HECS_AMOUNT_PAID,
    x_hecs_payment_option => X_HECS_PAYMENT_OPTION,
    x_differential_hecs_ind => X_DIFFERENTIAL_HECS_IND,
    x_citizenship_cd => X_CITIZENSHIP_CD,
    x_perm_resident_cd => X_PERM_RESIDENT_CD,
    x_prior_degree => X_PRIOR_DEGREE,
    x_prior_post_grad => X_PRIOR_POST_GRAD,
    x_old_unit_cd => X_OLD_UNIT_CD,
    x_old_eftsu => X_OLD_EFTSU,
    x_old_hecs_prexmt_exie => X_OLD_HECS_PREXMT_EXIE,
    x_old_hecs_amount_paid => X_OLD_HECS_AMOUNT_PAID,
    x_old_hecs_payment_option => X_OLD_HECS_PAYMENT_OPTION,
    x_old_differential_hecs_ind => X_OLD_DIFFERENTIAL_HECS_IND,
    x_old_citizenship_cd => X_OLD_CITIZENSHIP_CD,
    x_old_perm_resident_cd => X_OLD_PERM_RESIDENT_CD,
    x_old_prior_degree => X_OLD_PRIOR_DEGREE,
    x_old_prior_post_grad => X_OLD_PRIOR_POST_GRAD,
    x_reported_ind => NVL(X_REPORTED_IND,'N'),
    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: 622

  insert into IGS_ST_GVT_SPSHT_CHG (
    SUBMISSION_YR,
    SUBMISSION_NUMBER,
    PERSON_ID,
    COURSE_CD,
    VERSION_NUMBER,
    SEQUENCE_NUMBER,
    CHANGED_UPDATE_WHO,
    CHANGED_UPDATE_ON,
    GOVT_SEMESTER,
    UNIT_CD,
    EFTSU,
    HECS_PREXMT_EXIE,
    HECS_AMOUNT_PAID,
    HECS_PAYMENT_OPTION,
    DIFFERENTIAL_HECS_IND,
    CITIZENSHIP_CD,
    PERM_RESIDENT_CD,
    PRIOR_DEGREE,
    PRIOR_POST_GRAD,
    OLD_UNIT_CD,
    OLD_EFTSU,
    OLD_HECS_PREXMT_EXIE,
    OLD_HECS_AMOUNT_PAID,
    OLD_HECS_PAYMENT_OPTION,
    OLD_DIFFERENTIAL_HECS_IND,
    OLD_CITIZENSHIP_CD,
    OLD_PERM_RESIDENT_CD,
    OLD_PRIOR_DEGREE,
    OLD_PRIOR_POST_GRAD,
    REPORTED_IND,
    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.SEQUENCE_NUMBER,
    NEW_REFERENCES.CHANGED_UPDATE_WHO,
    NEW_REFERENCES.CHANGED_UPDATE_ON,
    NEW_REFERENCES.GOVT_SEMESTER,
    NEW_REFERENCES.UNIT_CD,
    NEW_REFERENCES.EFTSU,
    NEW_REFERENCES.HECS_PREXMT_EXIE,
    NEW_REFERENCES.HECS_AMOUNT_PAID,
    NEW_REFERENCES.HECS_PAYMENT_OPTION,
    NEW_REFERENCES.DIFFERENTIAL_HECS_IND,
    NEW_REFERENCES.CITIZENSHIP_CD,
    NEW_REFERENCES.PERM_RESIDENT_CD,
    NEW_REFERENCES.PRIOR_DEGREE,
    NEW_REFERENCES.PRIOR_POST_GRAD,
    NEW_REFERENCES.OLD_UNIT_CD,
    NEW_REFERENCES.OLD_EFTSU,
    NEW_REFERENCES.OLD_HECS_PREXMT_EXIE,
    NEW_REFERENCES.OLD_HECS_AMOUNT_PAID,
    NEW_REFERENCES.OLD_HECS_PAYMENT_OPTION,
    NEW_REFERENCES.OLD_DIFFERENTIAL_HECS_IND,
    NEW_REFERENCES.OLD_CITIZENSHIP_CD,
    NEW_REFERENCES.OLD_PERM_RESIDENT_CD,
    NEW_REFERENCES.OLD_PRIOR_DEGREE,
    NEW_REFERENCES.OLD_PRIOR_POST_GRAD,
    NEW_REFERENCES.REPORTED_IND,
    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: 712

    p_action => 'INSERT',
    x_rowid => X_ROWID
  );

Line: 715

end INSERT_ROW;

Line: 725

  X_CHANGED_UPDATE_WHO in VARCHAR2,
  X_CHANGED_UPDATE_ON in DATE,
  X_GOVT_SEMESTER in NUMBER,
  X_UNIT_CD in VARCHAR2,
  X_EFTSU in NUMBER,
  X_HECS_PREXMT_EXIE in NUMBER,
  X_HECS_AMOUNT_PAID in NUMBER,
  X_HECS_PAYMENT_OPTION in VARCHAR2,
  X_DIFFERENTIAL_HECS_IND in VARCHAR2,
  X_CITIZENSHIP_CD in VARCHAR2,
  X_PERM_RESIDENT_CD in VARCHAR2,
  X_PRIOR_DEGREE in VARCHAR2,
  X_PRIOR_POST_GRAD in VARCHAR2,
  X_OLD_UNIT_CD in VARCHAR2,
  X_OLD_EFTSU in NUMBER,
  X_OLD_HECS_PREXMT_EXIE in NUMBER,
  X_OLD_HECS_AMOUNT_PAID in NUMBER,
  X_OLD_HECS_PAYMENT_OPTION in VARCHAR2,
  X_OLD_DIFFERENTIAL_HECS_IND in VARCHAR2,
  X_OLD_CITIZENSHIP_CD in VARCHAR2,
  X_OLD_PERM_RESIDENT_CD in VARCHAR2,
  X_OLD_PRIOR_DEGREE in VARCHAR2,
  X_OLD_PRIOR_POST_GRAD in VARCHAR2,
  X_REPORTED_IND in VARCHAR2
) as
  cursor c1 is select
      VERSION_NUMBER,
      CHANGED_UPDATE_WHO,
      CHANGED_UPDATE_ON,
      GOVT_SEMESTER,
      UNIT_CD,
      EFTSU,
      HECS_PREXMT_EXIE,
      HECS_AMOUNT_PAID,
      HECS_PAYMENT_OPTION,
      DIFFERENTIAL_HECS_IND,
      CITIZENSHIP_CD,
      PERM_RESIDENT_CD,
      PRIOR_DEGREE,
      PRIOR_POST_GRAD,
      OLD_UNIT_CD,
      OLD_EFTSU,
      OLD_HECS_PREXMT_EXIE,
      OLD_HECS_AMOUNT_PAID,
      OLD_HECS_PAYMENT_OPTION,
      OLD_DIFFERENTIAL_HECS_IND,
      OLD_CITIZENSHIP_CD,
      OLD_PERM_RESIDENT_CD,
      OLD_PRIOR_DEGREE,
      OLD_PRIOR_POST_GRAD,
      REPORTED_IND
    from IGS_ST_GVT_SPSHT_CHG
    where ROWID = X_ROWID
    for update nowait;

Line: 785

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

Line: 794

      AND ((tlinfo.CHANGED_UPDATE_WHO = X_CHANGED_UPDATE_WHO)
           OR ((tlinfo.CHANGED_UPDATE_WHO is null)
               AND (X_CHANGED_UPDATE_WHO is null)))
      AND ((tlinfo.CHANGED_UPDATE_ON = X_CHANGED_UPDATE_ON)
           OR ((tlinfo.CHANGED_UPDATE_ON is null)
               AND (X_CHANGED_UPDATE_ON is null)))
      AND ((tlinfo.GOVT_SEMESTER = X_GOVT_SEMESTER)
           OR ((tlinfo.GOVT_SEMESTER is null)
               AND (X_GOVT_SEMESTER is null)))
      AND ((tlinfo.UNIT_CD = X_UNIT_CD)
           OR ((tlinfo.UNIT_CD is null)
               AND (X_UNIT_CD is null)))
      AND ((tlinfo.EFTSU = X_EFTSU)
           OR ((tlinfo.EFTSU is null)
               AND (X_EFTSU is null)))
      AND ((tlinfo.HECS_PREXMT_EXIE = X_HECS_PREXMT_EXIE)
           OR ((tlinfo.HECS_PREXMT_EXIE is null)
               AND (X_HECS_PREXMT_EXIE is null)))
      AND ((tlinfo.HECS_AMOUNT_PAID = X_HECS_AMOUNT_PAID)
           OR ((tlinfo.HECS_AMOUNT_PAID is null)
               AND (X_HECS_AMOUNT_PAID is null)))
      AND ((tlinfo.HECS_PAYMENT_OPTION = X_HECS_PAYMENT_OPTION)
           OR ((tlinfo.HECS_PAYMENT_OPTION is null)
               AND (X_HECS_PAYMENT_OPTION is null)))
      AND ((tlinfo.DIFFERENTIAL_HECS_IND = X_DIFFERENTIAL_HECS_IND)
           OR ((tlinfo.DIFFERENTIAL_HECS_IND is null)
               AND (X_DIFFERENTIAL_HECS_IND is null)))
      AND ((tlinfo.CITIZENSHIP_CD = X_CITIZENSHIP_CD)
           OR ((tlinfo.CITIZENSHIP_CD is null)
               AND (X_CITIZENSHIP_CD is null)))
      AND ((tlinfo.PERM_RESIDENT_CD = X_PERM_RESIDENT_CD)
           OR ((tlinfo.PERM_RESIDENT_CD is null)
               AND (X_PERM_RESIDENT_CD is null)))
      AND ((tlinfo.PRIOR_DEGREE = X_PRIOR_DEGREE)
           OR ((tlinfo.PRIOR_DEGREE is null)
               AND (X_PRIOR_DEGREE is null)))
      AND ((tlinfo.PRIOR_POST_GRAD = X_PRIOR_POST_GRAD)
           OR ((tlinfo.PRIOR_POST_GRAD is null)
               AND (X_PRIOR_POST_GRAD is null)))
      AND ((tlinfo.OLD_UNIT_CD = X_OLD_UNIT_CD)
           OR ((tlinfo.OLD_UNIT_CD is null)
               AND (X_OLD_UNIT_CD is null)))
      AND ((tlinfo.OLD_EFTSU = X_OLD_EFTSU)
           OR ((tlinfo.OLD_EFTSU is null)
               AND (X_OLD_EFTSU is null)))
      AND ((tlinfo.OLD_HECS_PREXMT_EXIE = X_OLD_HECS_PREXMT_EXIE)
           OR ((tlinfo.OLD_HECS_PREXMT_EXIE is null)
               AND (X_OLD_HECS_PREXMT_EXIE is null)))
      AND ((tlinfo.OLD_HECS_AMOUNT_PAID = X_OLD_HECS_AMOUNT_PAID)
           OR ((tlinfo.OLD_HECS_AMOUNT_PAID is null)
               AND (X_OLD_HECS_AMOUNT_PAID is null)))
      AND ((tlinfo.OLD_HECS_PAYMENT_OPTION = X_OLD_HECS_PAYMENT_OPTION)
           OR ((tlinfo.OLD_HECS_PAYMENT_OPTION is null)
               AND (X_OLD_HECS_PAYMENT_OPTION is null)))
      AND ((tlinfo.OLD_DIFFERENTIAL_HECS_IND = X_OLD_DIFFERENTIAL_HECS_IND)
           OR ((tlinfo.OLD_DIFFERENTIAL_HECS_IND is null)
               AND (X_OLD_DIFFERENTIAL_HECS_IND is null)))
      AND ((tlinfo.OLD_CITIZENSHIP_CD = X_OLD_CITIZENSHIP_CD)
           OR ((tlinfo.OLD_CITIZENSHIP_CD is null)
               AND (X_OLD_CITIZENSHIP_CD is null)))
      AND ((tlinfo.OLD_PERM_RESIDENT_CD = X_OLD_PERM_RESIDENT_CD)
           OR ((tlinfo.OLD_PERM_RESIDENT_CD is null)
               AND (X_OLD_PERM_RESIDENT_CD is null)))
      AND ((tlinfo.OLD_PRIOR_DEGREE = X_OLD_PRIOR_DEGREE)
           OR ((tlinfo.OLD_PRIOR_DEGREE is null)
               AND (X_OLD_PRIOR_DEGREE is null)))
      AND ((tlinfo.OLD_PRIOR_POST_GRAD = X_OLD_PRIOR_POST_GRAD)
           OR ((tlinfo.OLD_PRIOR_POST_GRAD is null)
               AND (X_OLD_PRIOR_POST_GRAD is null)))
      AND (tlinfo.REPORTED_IND = X_REPORTED_IND)
  ) then
    null;

Line: 874

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_SEQUENCE_NUMBER in NUMBER,
  X_VERSION_NUMBER in NUMBER,
  X_CHANGED_UPDATE_WHO in VARCHAR2,
  X_CHANGED_UPDATE_ON in DATE,
  X_GOVT_SEMESTER in NUMBER,
  X_UNIT_CD in VARCHAR2,
  X_EFTSU in NUMBER,
  X_HECS_PREXMT_EXIE in NUMBER,
  X_HECS_AMOUNT_PAID in NUMBER,
  X_HECS_PAYMENT_OPTION in VARCHAR2,
  X_DIFFERENTIAL_HECS_IND in VARCHAR2,
  X_CITIZENSHIP_CD in VARCHAR2,
  X_PERM_RESIDENT_CD in VARCHAR2,
  X_PRIOR_DEGREE in VARCHAR2,
  X_PRIOR_POST_GRAD in VARCHAR2,
  X_OLD_UNIT_CD in VARCHAR2,
  X_OLD_EFTSU in NUMBER,
  X_OLD_HECS_PREXMT_EXIE in NUMBER,
  X_OLD_HECS_AMOUNT_PAID in NUMBER,
  X_OLD_HECS_PAYMENT_OPTION in VARCHAR2,
  X_OLD_DIFFERENTIAL_HECS_IND in VARCHAR2,
  X_OLD_CITIZENSHIP_CD in VARCHAR2,
  X_OLD_PERM_RESIDENT_CD in VARCHAR2,
  X_OLD_PRIOR_DEGREE in VARCHAR2,
  X_OLD_PRIOR_POST_GRAD in VARCHAR2,
  X_REPORTED_IND in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) as
    X_LAST_UPDATE_DATE DATE;

Line: 909

    X_LAST_UPDATED_BY NUMBER;

Line: 910

    X_LAST_UPDATE_LOGIN NUMBER;

Line: 914

    X_PROGRAM_UPDATE_DATE DATE;

Line: 916

  X_LAST_UPDATE_DATE := SYSDATE;

Line: 918

    X_LAST_UPDATED_BY := 1;

Line: 919

    X_LAST_UPDATE_LOGIN := 0;

Line: 921

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 922

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 925

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 926

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 935

    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_sequence_number => X_SEQUENCE_NUMBER,
    x_changed_update_who => X_CHANGED_UPDATE_WHO,
    x_changed_update_on => X_CHANGED_UPDATE_ON,
    x_govt_semester => X_GOVT_SEMESTER,
    x_unit_cd => X_UNIT_CD,
    x_eftsu => X_EFTSU,
    x_hecs_prexmt_exie => X_HECS_PREXMT_EXIE,
    x_hecs_amount_paid => X_HECS_AMOUNT_PAID,
    x_hecs_payment_option => X_HECS_PAYMENT_OPTION,
    x_differential_hecs_ind => X_DIFFERENTIAL_HECS_IND,
    x_citizenship_cd => X_CITIZENSHIP_CD,
    x_perm_resident_cd => X_PERM_RESIDENT_CD,
    x_prior_degree => X_PRIOR_DEGREE,
    x_prior_post_grad => X_PRIOR_POST_GRAD,
    x_old_unit_cd => X_OLD_UNIT_CD,
    x_old_eftsu => X_OLD_EFTSU,
    x_old_hecs_prexmt_exie => X_OLD_HECS_PREXMT_EXIE,
    x_old_hecs_amount_paid => X_OLD_HECS_AMOUNT_PAID,
    x_old_hecs_payment_option => X_OLD_HECS_PAYMENT_OPTION,
    x_old_differential_hecs_ind => X_OLD_DIFFERENTIAL_HECS_IND,
    x_old_citizenship_cd => X_OLD_CITIZENSHIP_CD,
    x_old_perm_resident_cd => X_OLD_PERM_RESIDENT_CD,
    x_old_prior_degree => X_OLD_PRIOR_DEGREE,
    x_old_prior_post_grad => X_OLD_PRIOR_POST_GRAD,
    x_reported_ind => X_REPORTED_IND,
    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: 982

    X_PROGRAM_UPDATE_DATE := OLD_REFERENCES.PROGRAM_UPDATE_DATE;

Line: 984

    X_PROGRAM_UPDATE_DATE := SYSDATE;

Line: 987

    update IGS_ST_GVT_SPSHT_CHG set
    VERSION_NUMBER = NEW_REFERENCES.VERSION_NUMBER,
    CHANGED_UPDATE_WHO = NEW_REFERENCES.CHANGED_UPDATE_WHO,
    CHANGED_UPDATE_ON = NEW_REFERENCES.CHANGED_UPDATE_ON,
    GOVT_SEMESTER = NEW_REFERENCES.GOVT_SEMESTER,
    UNIT_CD = NEW_REFERENCES.UNIT_CD,
    EFTSU = NEW_REFERENCES.EFTSU,
    HECS_PREXMT_EXIE = NEW_REFERENCES.HECS_PREXMT_EXIE,
    HECS_AMOUNT_PAID = NEW_REFERENCES.HECS_AMOUNT_PAID,
    HECS_PAYMENT_OPTION = NEW_REFERENCES.HECS_PAYMENT_OPTION,
    DIFFERENTIAL_HECS_IND = NEW_REFERENCES.DIFFERENTIAL_HECS_IND,
    CITIZENSHIP_CD = NEW_REFERENCES.CITIZENSHIP_CD,
    PERM_RESIDENT_CD = NEW_REFERENCES.PERM_RESIDENT_CD,
    PRIOR_DEGREE = NEW_REFERENCES.PRIOR_DEGREE,
    PRIOR_POST_GRAD = NEW_REFERENCES.PRIOR_POST_GRAD,
    OLD_UNIT_CD = NEW_REFERENCES.OLD_UNIT_CD,
    OLD_EFTSU = NEW_REFERENCES.OLD_EFTSU,
    OLD_HECS_PREXMT_EXIE = NEW_REFERENCES.OLD_HECS_PREXMT_EXIE,
    OLD_HECS_AMOUNT_PAID = NEW_REFERENCES.OLD_HECS_AMOUNT_PAID,
    OLD_HECS_PAYMENT_OPTION = NEW_REFERENCES.OLD_HECS_PAYMENT_OPTION,
    OLD_DIFFERENTIAL_HECS_IND = NEW_REFERENCES.OLD_DIFFERENTIAL_HECS_IND,
    OLD_CITIZENSHIP_CD = NEW_REFERENCES.OLD_CITIZENSHIP_CD,
    OLD_PERM_RESIDENT_CD = NEW_REFERENCES.OLD_PERM_RESIDENT_CD,
    OLD_PRIOR_DEGREE = NEW_REFERENCES.OLD_PRIOR_DEGREE,
    OLD_PRIOR_POST_GRAD = NEW_REFERENCES.OLD_PRIOR_POST_GRAD,
    REPORTED_IND = NEW_REFERENCES.REPORTED_IND,
    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: 1026

    p_action => 'UPDATE',
    x_rowid => X_ROWID
);

Line: 1029

end UPDATE_ROW;

Line: 1039

  X_CHANGED_UPDATE_WHO in VARCHAR2,
  X_CHANGED_UPDATE_ON in DATE,
  X_GOVT_SEMESTER in NUMBER,
  X_UNIT_CD in VARCHAR2,
  X_EFTSU in NUMBER,
  X_HECS_PREXMT_EXIE in NUMBER,
  X_HECS_AMOUNT_PAID in NUMBER,
  X_HECS_PAYMENT_OPTION in VARCHAR2,
  X_DIFFERENTIAL_HECS_IND in VARCHAR2,
  X_CITIZENSHIP_CD in VARCHAR2,
  X_PERM_RESIDENT_CD in VARCHAR2,
  X_PRIOR_DEGREE in VARCHAR2,
  X_PRIOR_POST_GRAD in VARCHAR2,
  X_OLD_UNIT_CD in VARCHAR2,
  X_OLD_EFTSU in NUMBER,
  X_OLD_HECS_PREXMT_EXIE in NUMBER,
  X_OLD_HECS_AMOUNT_PAID in NUMBER,
  X_OLD_HECS_PAYMENT_OPTION in VARCHAR2,
  X_OLD_DIFFERENTIAL_HECS_IND in VARCHAR2,
  X_OLD_CITIZENSHIP_CD in VARCHAR2,
  X_OLD_PERM_RESIDENT_CD in VARCHAR2,
  X_OLD_PRIOR_DEGREE in VARCHAR2,
  X_OLD_PRIOR_POST_GRAD in VARCHAR2,
  X_REPORTED_IND in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) as
  cursor c1 is select rowid from IGS_ST_GVT_SPSHT_CHG
     where SUBMISSION_YR = X_SUBMISSION_YR
     and SUBMISSION_NUMBER = X_SUBMISSION_NUMBER
     and PERSON_ID = X_PERSON_ID
     and COURSE_CD = X_COURSE_CD
     and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
  ;

Line: 1077

    INSERT_ROW (
     X_ROWID,
     X_SUBMISSION_YR,
     X_SUBMISSION_NUMBER,
     X_PERSON_ID,
     X_COURSE_CD,
     X_SEQUENCE_NUMBER,
     X_VERSION_NUMBER,
     X_CHANGED_UPDATE_WHO,
     X_CHANGED_UPDATE_ON,
     X_GOVT_SEMESTER,
     X_UNIT_CD,
     X_EFTSU,
     X_HECS_PREXMT_EXIE,
     X_HECS_AMOUNT_PAID,
     X_HECS_PAYMENT_OPTION,
     X_DIFFERENTIAL_HECS_IND,
     X_CITIZENSHIP_CD,
     X_PERM_RESIDENT_CD,
     X_PRIOR_DEGREE,
     X_PRIOR_POST_GRAD,
     X_OLD_UNIT_CD,
     X_OLD_EFTSU,
     X_OLD_HECS_PREXMT_EXIE,
     X_OLD_HECS_AMOUNT_PAID,
     X_OLD_HECS_PAYMENT_OPTION,
     X_OLD_DIFFERENTIAL_HECS_IND,
     X_OLD_CITIZENSHIP_CD,
     X_OLD_PERM_RESIDENT_CD,
     X_OLD_PRIOR_DEGREE,
     X_OLD_PRIOR_POST_GRAD,
     X_REPORTED_IND,
     X_MODE);

Line: 1113

  UPDATE_ROW (
   X_ROWID,
   X_SUBMISSION_YR,
   X_SUBMISSION_NUMBER,
   X_PERSON_ID,
   X_COURSE_CD,
   X_SEQUENCE_NUMBER,
   X_VERSION_NUMBER,
   X_CHANGED_UPDATE_WHO,
   X_CHANGED_UPDATE_ON,
   X_GOVT_SEMESTER,
   X_UNIT_CD,
   X_EFTSU,
   X_HECS_PREXMT_EXIE,
   X_HECS_AMOUNT_PAID,
   X_HECS_PAYMENT_OPTION,
   X_DIFFERENTIAL_HECS_IND,
   X_CITIZENSHIP_CD,
   X_PERM_RESIDENT_CD,
   X_PRIOR_DEGREE,
   X_PRIOR_POST_GRAD,
   X_OLD_UNIT_CD,
   X_OLD_EFTSU,
   X_OLD_HECS_PREXMT_EXIE,
   X_OLD_HECS_AMOUNT_PAID,
   X_OLD_HECS_PAYMENT_OPTION,
   X_OLD_DIFFERENTIAL_HECS_IND,
   X_OLD_CITIZENSHIP_CD,
   X_OLD_PERM_RESIDENT_CD,
   X_OLD_PRIOR_DEGREE,
   X_OLD_PRIOR_POST_GRAD,
   X_REPORTED_IND,
   X_MODE);

Line: 1148

procedure DELETE_ROW (
  X_ROWID in VARCHAR2
) as
begin
Before_DML (
    p_action => 'DELETE',
    x_rowid => X_ROWID
  );

Line: 1156

delete from IGS_ST_GVT_SPSHT_CHG
  where ROWID = X_ROWID;

Line: 1162

    p_action => 'DELETE',
    x_rowid => X_ROWID
);

Line: 1165

end DELETE_ROW;