APPS.IGS_FI_FEE_AS_RT_H_PKG SQL Statements

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

Line: 35

    x_last_update_date IN DATE ,
    x_last_updated_by IN NUMBER ,
    x_last_update_login IN NUMBER ,
    x_unit_set_cd         IN VARCHAR2,
    x_us_version_number   IN NUMBER,
    x_unit_cd                   IN VARCHAR2 ,
    x_unit_version_number       IN NUMBER   ,
    x_unit_level                IN VARCHAR2 ,
    x_unit_type_id              IN NUMBER   ,
    x_unit_mode                 IN VARCHAR2

  ) AS
 /************************************************************************************
 | HISTORY
 | Who         When             What
 | svuppala     31-MAY-2005    Enh 3442712: Added Unit Program Type Level, Unit Mode, Unit Class, Unit Code,
 |                                 Unit Version and Unit Level
 | pathipat     10-Sep-2003     Enh 3108052 - Add Unit Sets to Rate Table
 |                              Added 2 new columns unit_set_cd and us_version_number
**************************************************************************************/
    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     IGS_FI_FEE_AS_RT_H_ALL
      WHERE    rowid = x_rowid;

Line: 65

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

Line: 67

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

Line: 106

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

Line: 113

    new_references.last_update_date := x_last_update_date;

Line: 114

    new_references.last_updated_by := x_last_updated_by;

Line: 115

    new_references.last_update_login := x_last_update_login;

Line: 410

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

Line: 428

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

Line: 446

      SELECT   rowid
      FROM     IGS_FI_FEE_AS_RT_H_ALL
      WHERE    fee_type = x_fee_type
      AND      fee_cal_type = x_fee_cal_type
      AND      fee_ci_sequence_number = x_fee_ci_sequence_number
      AND      s_relation_type = x_s_relation_type
      AND      rate_number = x_rate_number
      AND      hist_start_dt = x_hist_start_dt
      FOR UPDATE NOWAIT;

Line: 479

       SELECT   rowid
       FROM     IGS_FI_FEE_AS_RT_H_ALL
         WHERE    fee_type = x_fee_type
         AND      fee_cal_type = x_fee_cal_type
         AND      fee_ci_sequence_number = x_fee_ci_sequence_number
         AND      rate_number = x_rate_number
         AND      hist_start_dt = x_hist_start_dt
         AND      fee_cat = x_fee_cat
         AND      ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line: 531

    x_last_update_date IN DATE ,
    x_last_updated_by IN NUMBER ,
    x_last_update_login IN NUMBER,
    x_unit_set_cd         IN VARCHAR2,
    x_us_version_number   IN NUMBER,
    x_unit_cd                     IN VARCHAR2 ,
    x_unit_version_number         IN NUMBER   ,
    x_unit_level                  IN VARCHAR2 ,
    x_unit_type_id                IN NUMBER   ,
    x_unit_mode                   IN VARCHAR2
  ) AS
 /************************************************************************************
 | HISTORY
 | Who         When             What
 | svuppala     31-MAY-2005    Enh 3442712: Added Unit Program Type Level, Unit Mode, Unit Class, Unit Code,
 |                                 Unit Version and Unit Level
 | pathipat     10-Sep-2003     Enh 3108052 - Add Unit Sets to Rate Table
 |                              Added 2 new columns unit_set_cd and us_version_number
**************************************************************************************/
  BEGIN
    Set_Column_Values (
      p_action,
      x_rowid,
      x_chg_rate,
      x_fee_type,
      x_fee_cal_type,
      x_fee_ci_sequence_number,
      x_s_relation_type,
      x_rate_number,
      x_hist_start_dt,
      x_hist_end_dt,
      x_hist_who,
      x_fee_cat,
      x_location_cd,
      x_attendance_type,
      x_attendance_mode,
      x_order_of_precedence,
      x_govt_hecs_payment_option,
      x_govt_hecs_cntrbtn_band,
      x_unit_class,
      x_residency_status_cd,
      x_course_cd,
      x_version_number,
      x_org_party_id,
      x_class_standing,
      x_org_id,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login,
      x_unit_set_cd,
      x_us_version_number,
      x_unit_cd ,
      x_unit_version_number,
      x_unit_level,
      x_unit_type_id,
      x_unit_mode
    );

Line: 590

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

Line: 608

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

Line: 614

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

Line: 617

        ELSIF (p_action = 'VALIDATE_INSERT') THEN
              IF  Get_PK_For_Validation (
                    new_references.fee_type ,
                    new_references.fee_cal_type ,
                    new_references.fee_ci_sequence_number ,
                    new_references.s_relation_type ,
                    new_references.rate_number ,
                    new_references.hist_start_dt
                         ) THEN
                 Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');

Line: 632

        ELSIF (p_action = 'VALIDATE_UPDATE') THEN
               Check_Constraints;

Line: 635

        ELSIF (p_action = 'VALIDATE_DELETE') THEN
              Null;

Line: 641

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_FEE_TYPE in VARCHAR2,
  X_FEE_CAL_TYPE in VARCHAR2,
  X_FEE_CI_SEQUENCE_NUMBER in NUMBER,
  X_S_RELATION_TYPE in VARCHAR2,
  X_HIST_START_DT in DATE,
  X_RATE_NUMBER in NUMBER,
  X_HIST_END_DT in DATE,
  X_HIST_WHO in NUMBER,
  X_FEE_CAT in VARCHAR2,
  X_LOCATION_CD in VARCHAR2,
  X_ATTENDANCE_TYPE in VARCHAR2,
  X_ATTENDANCE_MODE in VARCHAR2,
  X_ORDER_OF_PRECEDENCE in NUMBER,
  X_GOVT_HECS_PAYMENT_OPTION in VARCHAR2,
  X_GOVT_HECS_CNTRBTN_BAND in NUMBER,
  X_CHG_RATE in NUMBER,
  X_UNIT_CLASS IN VARCHAR2,
  X_RESIDENCY_STATUS_CD  in  VARCHAR2 ,
  X_COURSE_CD  in VARCHAR2 ,
  X_VERSION_NUMBER in NUMBER ,
  X_ORG_PARTY_ID in NUMBER ,
  X_CLASS_STANDING  in VARCHAR2 ,
  X_ORG_ID in NUMBER,
  X_MODE in VARCHAR2,
  x_unit_set_cd         IN VARCHAR2,
  x_us_version_number   IN NUMBER,
  x_unit_cd                     IN VARCHAR2 ,
  x_unit_version_number         IN NUMBER   ,
  x_unit_level                  IN VARCHAR2 ,
  x_unit_type_id                IN NUMBER   ,
  x_unit_mode                   IN VARCHAR2
  ) AS
 /************************************************************************************
 | HISTORY
 | Who         When             What
 | svuppala     31-MAY-2005    Enh 3442712: Added Unit Program Type Level, Unit Mode, Unit Class, Unit Code,
 |                                 Unit Version and Unit Level
 | pathipat     10-Sep-2003     Enh 3108052 - Add Unit Sets to Rate Table
 |                              Added 2 new columns unit_set_cd and us_version_number
**************************************************************************************/
    cursor C is select ROWID from IGS_FI_FEE_AS_RT_H_ALL
      where FEE_TYPE = X_FEE_TYPE
      and FEE_CAL_TYPE = X_FEE_CAL_TYPE
      and FEE_CI_SEQUENCE_NUMBER = X_FEE_CI_SEQUENCE_NUMBER
      and S_RELATION_TYPE = X_S_RELATION_TYPE
      and HIST_START_DT = X_HIST_START_DT
      and RATE_NUMBER = X_RATE_NUMBER;

Line: 690

    X_LAST_UPDATE_DATE DATE;

Line: 691

    X_LAST_UPDATED_BY NUMBER;

Line: 692

    X_LAST_UPDATE_LOGIN NUMBER;

Line: 694

  X_LAST_UPDATE_DATE := SYSDATE;

Line: 696

    X_LAST_UPDATED_BY := 1;

Line: 697

    X_LAST_UPDATE_LOGIN := 0;

Line: 699

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 700

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 703

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 704

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 713

  p_action=>'INSERT',
  x_rowid=>X_ROWID,
  x_attendance_mode=>X_ATTENDANCE_MODE,
  x_attendance_type=>X_ATTENDANCE_TYPE,
  x_chg_rate=>X_CHG_RATE,
  x_fee_cal_type=>X_FEE_CAL_TYPE,
  x_fee_cat=>X_FEE_CAT,
  x_fee_ci_sequence_number=>X_FEE_CI_SEQUENCE_NUMBER,
  x_fee_type=>X_FEE_TYPE,
  x_govt_hecs_cntrbtn_band=>X_GOVT_HECS_CNTRBTN_BAND,
  x_govt_hecs_payment_option=>X_GOVT_HECS_PAYMENT_OPTION,
  x_hist_end_dt=>X_HIST_END_DT,
  x_hist_start_dt=>X_HIST_START_DT,
  x_hist_who=>X_HIST_WHO,
  x_location_cd=>X_LOCATION_CD,
  x_order_of_precedence=>X_ORDER_OF_PRECEDENCE,
  x_rate_number=>X_RATE_NUMBER,
  x_s_relation_type=>X_S_RELATION_TYPE,
  x_unit_class => X_UNIT_CLASS,
  x_residency_status_cd => X_RESIDENCY_STATUS_CD,
  x_course_cd => X_COURSE_CD,
  x_version_number => X_VERSION_NUMBER,
  x_org_party_id => X_ORG_PARTY_ID,
  x_class_standing => X_CLASS_STANDING,
  x_org_id => igs_ge_gen_003.get_org_id,
  x_creation_date => X_LAST_UPDATE_DATE,
  x_created_by => X_LAST_UPDATED_BY,
  x_last_update_date => X_LAST_UPDATE_DATE,
  x_last_updated_by => X_LAST_UPDATED_BY,
  x_last_update_login => X_LAST_UPDATE_LOGIN,
  x_unit_set_cd         => x_unit_set_cd,
  x_us_version_number   => x_us_version_number,
  x_unit_cd                   => x_unit_cd,
  x_unit_version_number       => x_unit_version_number,
  x_unit_level                => x_unit_level ,
  x_unit_type_id              => x_unit_type_id,
  x_unit_mode                 => x_unit_mode
  );

Line: 752

  insert into IGS_FI_FEE_AS_RT_H_ALL (
    FEE_TYPE,
    FEE_CAL_TYPE,
    FEE_CI_SEQUENCE_NUMBER,
    S_RELATION_TYPE,
    RATE_NUMBER,
    HIST_START_DT,
    HIST_END_DT,
    HIST_WHO,
    FEE_CAT,
    LOCATION_CD,
    ATTENDANCE_TYPE,
    ATTENDANCE_MODE,
    ORDER_OF_PRECEDENCE,
    GOVT_HECS_PAYMENT_OPTION,
    GOVT_HECS_CNTRBTN_BAND,
    CHG_RATE,
    UNIT_CLASS,
    RESIDENCY_STATUS_CD,
    COURSE_CD,
    VERSION_NUMBER,
    ORG_PARTY_ID,
    CLASS_STANDING,
    ORG_ID,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    unit_set_cd,
    us_version_number,
    unit_cd ,
    unit_version_number,
    unit_level  ,
    unit_type_id,
    unit_mode
  ) values (
    NEW_REFERENCES.FEE_TYPE,
    NEW_REFERENCES.FEE_CAL_TYPE,
    NEW_REFERENCES.FEE_CI_SEQUENCE_NUMBER,
    NEW_REFERENCES.S_RELATION_TYPE,
    NEW_REFERENCES.RATE_NUMBER,
    NEW_REFERENCES.HIST_START_DT,
    NEW_REFERENCES.HIST_END_DT,
    NEW_REFERENCES.HIST_WHO,
    NEW_REFERENCES.FEE_CAT,
    NEW_REFERENCES.LOCATION_CD,
    NEW_REFERENCES.ATTENDANCE_TYPE,
    NEW_REFERENCES.ATTENDANCE_MODE,
    NEW_REFERENCES.ORDER_OF_PRECEDENCE,
    NEW_REFERENCES.GOVT_HECS_PAYMENT_OPTION,
    NEW_REFERENCES.GOVT_HECS_CNTRBTN_BAND,
    NEW_REFERENCES.CHG_RATE,
    NEW_REFERENCES.UNIT_CLASS,
    NEW_REFERENCES.RESIDENCY_STATUS_CD,
    NEW_REFERENCES.COURSE_CD,
    NEW_REFERENCES.VERSION_NUMBER,
    NEW_REFERENCES.ORG_PARTY_ID,
    NEW_REFERENCES.CLASS_STANDING,
    NEW_REFERENCES.ORG_ID,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    new_references.unit_set_cd,
    new_references.us_version_number,
    new_references.unit_cd,
    new_references.unit_version_number,
    new_references.unit_level ,
    new_references.unit_type_id ,
    new_references.unit_mode
  );

Line: 833

end INSERT_ROW;

Line: 876

  cursor c1 is select
      HIST_END_DT,
      HIST_WHO,
      FEE_CAT,
      LOCATION_CD,
      ATTENDANCE_TYPE,
      ATTENDANCE_MODE,
      ORDER_OF_PRECEDENCE,
      GOVT_HECS_PAYMENT_OPTION,
      GOVT_HECS_CNTRBTN_BAND,
      CHG_RATE,
      UNIT_CLASS,
      RESIDENCY_STATUS_CD,
      COURSE_CD,
      VERSION_NUMBER,
      ORG_PARTY_ID,
      CLASS_STANDING,
      unit_set_cd,
      us_version_number,
      unit_cd,
      unit_version_number,
      unit_level  ,
      unit_type_id ,
      unit_mode
    from IGS_FI_FEE_AS_RT_H_ALL
    where ROWID = X_ROWID
    for update nowait;

Line: 909

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

Line: 973

procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_FEE_TYPE in VARCHAR2,
  X_FEE_CAL_TYPE in VARCHAR2,
  X_FEE_CI_SEQUENCE_NUMBER in NUMBER,
  X_S_RELATION_TYPE in VARCHAR2,
  X_HIST_START_DT in DATE,
  X_RATE_NUMBER in NUMBER,
  X_HIST_END_DT in DATE,
  X_HIST_WHO in NUMBER,
  X_FEE_CAT in VARCHAR2,
  X_LOCATION_CD in VARCHAR2,
  X_ATTENDANCE_TYPE in VARCHAR2,
  X_ATTENDANCE_MODE in VARCHAR2,
  X_ORDER_OF_PRECEDENCE in NUMBER,
  X_GOVT_HECS_PAYMENT_OPTION in VARCHAR2,
  X_GOVT_HECS_CNTRBTN_BAND in NUMBER,
  X_CHG_RATE in NUMBER,
  X_UNIT_CLASS in VARCHAR2,
  X_RESIDENCY_STATUS_CD  in  VARCHAR2 ,
  X_COURSE_CD  in VARCHAR2 ,
  X_VERSION_NUMBER in NUMBER ,
  X_ORG_PARTY_ID in NUMBER ,
  X_CLASS_STANDING  in VARCHAR2 ,
  X_MODE in VARCHAR2,
  x_unit_set_cd         IN VARCHAR2,
  x_us_version_number   IN NUMBER,
  x_unit_cd                     IN VARCHAR2 ,
  x_unit_version_number         IN NUMBER   ,
  x_unit_level                  IN VARCHAR2 ,
  x_unit_type_id                IN NUMBER   ,
  x_unit_mode                   IN VARCHAR2
  ) AS
 /************************************************************************************
 | HISTORY
 | Who         When             What
 | svuppala     31-MAY-2005    Enh 3442712: Added Unit Program Type Level, Unit Mode, Unit Class, Unit Code,
 |                                 Unit Version and Unit Level
 | pathipat     10-Sep-2003     Enh 3108052 - Add Unit Sets to Rate Table
 |                              Added 2 new columns unit_set_cd and us_version_number
**************************************************************************************/
    X_LAST_UPDATE_DATE DATE;

Line: 1015

    X_LAST_UPDATED_BY NUMBER;

Line: 1016

    X_LAST_UPDATE_LOGIN NUMBER;

Line: 1018

  X_LAST_UPDATE_DATE := SYSDATE;

Line: 1020

    X_LAST_UPDATED_BY := 1;

Line: 1021

    X_LAST_UPDATE_LOGIN := 0;

Line: 1023

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1024

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 1027

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 1028

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 1037

  p_action=>'UPDATE',
  x_rowid=>X_ROWID,
  x_attendance_mode=>X_ATTENDANCE_MODE,
  x_attendance_type=>X_ATTENDANCE_TYPE,
  x_chg_rate=>X_CHG_RATE,
  x_fee_cal_type=>X_FEE_CAL_TYPE,
  x_fee_cat=>X_FEE_CAT,
  x_fee_ci_sequence_number=>X_FEE_CI_SEQUENCE_NUMBER,
  x_fee_type=>X_FEE_TYPE,
  x_govt_hecs_cntrbtn_band=>X_GOVT_HECS_CNTRBTN_BAND,
  x_govt_hecs_payment_option=>X_GOVT_HECS_PAYMENT_OPTION,
  x_hist_end_dt=>X_HIST_END_DT,
  x_hist_start_dt=>X_HIST_START_DT,
  x_hist_who=>X_HIST_WHO,
  x_location_cd=>X_LOCATION_CD,
  x_order_of_precedence=>X_ORDER_OF_PRECEDENCE,
  x_rate_number=>X_RATE_NUMBER,
  x_s_relation_type=>X_S_RELATION_TYPE,
  x_unit_class => X_UNIT_CLASS,
  x_residency_status_cd => X_RESIDENCY_STATUS_CD,
  x_course_cd => X_COURSE_CD,
  x_version_number => X_VERSION_NUMBER,
  x_org_party_id => X_ORG_PARTY_ID,
  x_class_standing => X_CLASS_STANDING,
  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_unit_set_cd         => x_unit_set_cd,
  x_us_version_number   => x_us_version_number,
  x_unit_cd                     => x_unit_cd,
  x_unit_version_number         => x_unit_version_number,
  x_unit_level                  => x_unit_level ,
  x_unit_type_id                => x_unit_type_id,
  x_unit_mode                   => x_unit_mode
  );

Line: 1074

  update IGS_FI_FEE_AS_RT_H_ALL set
    HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
    HIST_WHO = NEW_REFERENCES.HIST_WHO,
    FEE_CAT = NEW_REFERENCES.FEE_CAT,
    LOCATION_CD = NEW_REFERENCES.LOCATION_CD,
    ATTENDANCE_TYPE = NEW_REFERENCES.ATTENDANCE_TYPE,
    ATTENDANCE_MODE = NEW_REFERENCES.ATTENDANCE_MODE,
    ORDER_OF_PRECEDENCE = NEW_REFERENCES.ORDER_OF_PRECEDENCE,
    GOVT_HECS_PAYMENT_OPTION = NEW_REFERENCES.GOVT_HECS_PAYMENT_OPTION,
    GOVT_HECS_CNTRBTN_BAND = NEW_REFERENCES.GOVT_HECS_CNTRBTN_BAND,
    CHG_RATE = NEW_REFERENCES.CHG_RATE,
    UNIT_CLASS = NEW_REFERENCES.UNIT_CLASS,
    RESIDENCY_STATUS_CD = NEW_REFERENCES.RESIDENCY_STATUS_CD,
    COURSE_CD = NEW_REFERENCES.COURSE_CD,
    VERSION_NUMBER = NEW_REFERENCES.VERSION_NUMBER,
    ORG_PARTY_ID = NEW_REFERENCES.ORG_PARTY_ID,
    CLASS_STANDING = NEW_REFERENCES.CLASS_STANDING,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    unit_set_cd       = new_references.unit_set_cd,
    us_version_number = new_references.us_version_number,
    unit_cd                  = new_references.unit_cd,
    unit_version_number      = new_references.unit_version_number,
    unit_level               = new_references.unit_level ,
    unit_type_id             = new_references.unit_type_id,
    unit_mode                = new_references.unit_mode
  where ROWID = X_ROWID;

Line: 1105

end UPDATE_ROW;

Line: 1150

  cursor c1 is select rowid from IGS_FI_FEE_AS_RT_H_ALL
     where FEE_TYPE = X_FEE_TYPE
     and FEE_CAL_TYPE = X_FEE_CAL_TYPE
     and FEE_CI_SEQUENCE_NUMBER = X_FEE_CI_SEQUENCE_NUMBER
     and S_RELATION_TYPE = X_S_RELATION_TYPE
     and HIST_START_DT = X_HIST_START_DT
     and RATE_NUMBER = X_RATE_NUMBER ;

Line: 1162

    INSERT_ROW (
     X_ROWID,
     X_FEE_TYPE,
     X_FEE_CAL_TYPE,
     X_FEE_CI_SEQUENCE_NUMBER,
     X_S_RELATION_TYPE,
     X_HIST_START_DT,
     X_RATE_NUMBER,
     X_HIST_END_DT,
     X_HIST_WHO,
     X_FEE_CAT,
     X_LOCATION_CD,
     X_ATTENDANCE_TYPE,
     X_ATTENDANCE_MODE,
     X_ORDER_OF_PRECEDENCE,
     X_GOVT_HECS_PAYMENT_OPTION,
     X_GOVT_HECS_CNTRBTN_BAND,
     X_CHG_RATE,
     X_UNIT_CLASS,
     X_RESIDENCY_STATUS_CD,
     X_COURSE_CD,
     X_VERSION_NUMBER,
     X_ORG_PARTY_ID,
     X_CLASS_STANDING,
     X_ORG_ID,
     X_MODE,
     x_unit_set_cd,
     x_us_version_number,
     x_unit_cd,
     x_unit_version_number,
     x_unit_level,
     x_unit_type_id,
     x_unit_mode
     );

Line: 1201

  UPDATE_ROW (
   X_ROWID,
   X_FEE_TYPE,
   X_FEE_CAL_TYPE,
   X_FEE_CI_SEQUENCE_NUMBER,
   X_S_RELATION_TYPE,
   X_HIST_START_DT,
   X_RATE_NUMBER,
   X_HIST_END_DT,
   X_HIST_WHO,
   X_FEE_CAT,
   X_LOCATION_CD,
   X_ATTENDANCE_TYPE,
   X_ATTENDANCE_MODE,
   X_ORDER_OF_PRECEDENCE,
   X_GOVT_HECS_PAYMENT_OPTION,
   X_GOVT_HECS_CNTRBTN_BAND,
   X_CHG_RATE,
   X_UNIT_CLASS,
   X_RESIDENCY_STATUS_CD,
   X_COURSE_CD,
   X_VERSION_NUMBER,
   X_ORG_PARTY_ID,
   X_CLASS_STANDING,
   X_MODE,
   x_unit_set_cd,
   x_us_version_number,
   x_unit_cd,
   x_unit_version_number,
   x_unit_level,
   x_unit_type_id,
   x_unit_mode
   );

Line: 1237

PROCEDURE delete_row (
  X_ROWID in VARCHAR2
) AS
BEGIN
   Before_DML(
               p_action => 'DELETE',
               x_rowid  => X_ROWID
             );

Line: 1245

  DELETE FROM igs_fi_fee_as_rt_h_all
  WHERE rowid = x_rowid;

Line: 1250

END delete_row;