APPS.IGS_FI_F_CAT_FEE_LBL_PKG SQL Statements

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

Line: 21

    x_last_update_date IN DATE ,
    x_last_updated_by IN NUMBER ,
    x_last_update_login IN NUMBER,
    x_waiver_calc_flag IN VARCHAR2
  ) AS
  /*----------------------------------------------------------------------------
  ||  Created By :
  ||  Created On :
  ||  Purpose :
  ||  Known limitations, enhancements or remarks :
  ||  Change History :
  ||  Who             When            What
  ||  (reverse chronological order - newest change first)
  ||  smvk            02-Sep-2002  Default values are removed from the signature of this procedure to overcome
  ||                               File.Pkg.22 gscc warning.As a part of Build SFCR005_Cleanup_Build (Enhancement Bug # 2531390)
  ||  vvutukur        19-Jul-2002  Bug#2425767.removed parameter x_payment_hierarchy_rank
  ||                               and its reference in copying old_references value
  ||                               into new_references value.
  ----------------------------------------------------------------------------*/
    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     IGS_FI_F_CAT_FEE_LBL_ALL
      WHERE    rowid = x_rowid;

Line: 50

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

Line: 52

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

Line: 68

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

Line: 76

    new_references.last_update_date := x_last_update_date;

Line: 77

    new_references.last_updated_by := x_last_updated_by;

Line: 78

    new_references.last_update_login := x_last_update_login;

Line: 86

  PROCEDURE BeforeRowInsertUpdateDelete1(
    p_inserting IN BOOLEAN ,
    p_updating IN BOOLEAN ,
    p_deleting IN BOOLEAN
    ) AS
  /*************************************************************
  Created By :
  Date Created By :
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What
  shtatiko        10-FEB-2003     Enh# 2747325, Removed the code of handling p_deleting = 'TRUE' case as deletion of
                                  Fee Category Fee Liability records is not allowed.
  smvk            02-Sep-2002     Default values are removed from the signature of this procedure to overcome
                                  File.Pkg.22 gscc warning.As a part of Build SFCR005_Cleanup_Build (Enhancement Bug # 2531390)
  smvk            14-Mar-2002     Check for system fee type refund
                                  as its invalid for Fee Category Fee
				  Liability w.r.t Bug # 2144600
  SCHODAVA	  13-OCT-2001     Bug # 2021281
				  Added IF condition for
				  p_deleting
  (reverse chronological order - newest change first)
  ***************************************************************/

	-- Returns the system fee trigger category of a fee type
	CURSOR c_ft(cp_fee_type IN igs_fi_fee_type.fee_type%TYPE ) IS
	SELECT s_fee_trigger_cat
	FROM   igs_fi_fee_type
	WHERE  fee_type = cp_fee_type;

Line: 123

	SELECT 'x'
	FROM   igs_fi_fee_as
	WHERE  fee_type = cp_fee_type
	AND    fee_cal_type = cp_fee_cal_type
	AND    fee_ci_sequence_number = cp_fee_ci_sequence_number
	AND    fee_cat IS NULL;

Line: 132

	SELECT s_fee_type
	FROM  igs_fi_fee_type
	WHERE fee_type = cp_fee_type;

Line: 142

        IF( p_inserting OR p_updating) THEN
                OPEN c_sft(new_references.fee_type);

Line: 153

	IF (p_inserting OR (old_references.fee_liability_status) <>
			(new_references.fee_liability_status)) THEN
		IF IGS_FI_VAL_FCCI.finp_val_fss_closed (
					new_references.fee_liability_status,
					v_message_name) = FALSE THEN
			Fnd_Message.Set_Name('IGS',v_message_name);

Line: 185

	IF p_inserting OR p_updating THEN
		IF IGS_FI_VAL_FCFL.finp_val_fcfl_rqrd (
					new_references.fee_cal_type,
					new_references.fee_ci_sequence_number,
					new_references.fee_type,
					new_references.s_chg_method_type,
					new_references.rul_sequence_number,
					v_message_name) = FALSE THEN
			Fnd_Message.Set_Name('IGS',v_message_name);

Line: 199

	IF p_inserting THEN
		IF IGS_FI_VAL_FCFL.finp_val_fcfl_cur (
					new_references.fee_cal_type,
					new_references.fee_ci_sequence_number,
					new_references.fee_type,
					new_references.fee_cat,
					v_message_name) = FALSE THEN
			Fnd_Message.Set_Name('IGS',v_message_name);

Line: 221

  END BeforeRowInsertUpdateDelete1;

Line: 227

  PROCEDURE AfterRowUpdate3(
    p_inserting IN BOOLEAN ,
    p_updating IN BOOLEAN ,
    p_deleting IN BOOLEAN
    ) AS
  /*----------------------------------------------------------------------------
  ||  Created By :
  ||  Created On :
  ||  Purpose :
  ||  Known limitations, enhancements or remarks :
  ||  Change History :
  ||  Who             When            What
  ||  (reverse chronological order - newest change first)
  ||  smvk            02-Sep-2002  Default values are removed from the signature of this procedure to overcome
  ||                               File.Pkg.22 gscc warning.As a part of Build SFCR005_Cleanup_Build (Enhancement Bug # 2531390)
  ||  vvutukur        19-Jul-2002  Bug#2425767.removed parameters new_references.payment_hierarchy_rank,
  ||                               new_references.payment_hierarchy_rank,from the call to
  ||                               IGS_FI_GEN_002.FINP_INS_FCFL_HIST.
  ----------------------------------------------------------------------------*/
  BEGIN
	-- create a history
	IGS_FI_GEN_002.FINP_INS_FCFL_HIST (old_references.fee_cat,
		old_references.fee_cal_type,
		old_references.fee_ci_sequence_number,
		old_references.fee_type,
		new_references.fee_liability_status,
		old_references.fee_liability_status,
		new_references.start_dt_alias,
		old_references.start_dt_alias,
		new_references.start_dai_sequence_number,
		old_references.start_dai_sequence_number,
		new_references.s_chg_method_type,
		old_references.s_chg_method_type,
		new_references.rul_sequence_number,
		old_references.rul_sequence_number,
		new_references.last_updated_by,
		old_references.last_updated_by,
		new_references.last_update_date,
		old_references.last_update_date);

Line: 266

  END AfterRowUpdate3;

Line: 380

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

Line: 398

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

Line: 410

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

Line: 428

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

Line: 440

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

Line: 456

      SELECT   rowid
      FROM     IGS_FI_F_CAT_FEE_LBL_ALL
      WHERE    fee_cat = x_fee_cat
      AND      fee_cal_type = x_fee_cal_type
      AND      fee_ci_sequence_number = x_fee_ci_sequence_number
      AND      fee_type = x_fee_type;

Line: 483

      SELECT   rowid
      FROM     IGS_FI_F_CAT_FEE_LBL_ALL
      WHERE    fee_cat = x_fee_cat
      AND      fee_cal_type = x_fee_cal_type
      AND      fee_ci_sequence_number = x_fee_ci_sequence_number
      AND      fee_type = x_fee_type
      AND      s_chg_method_type = x_s_chg_method_type
      AND      ((l_rowid IS NULL) OR (rowid <> l_rowid))
      FOR UPDATE NOWAIT;

Line: 511

      SELECT   rowid
      FROM     IGS_FI_F_CAT_FEE_LBL_ALL
      WHERE    start_dt_alias = x_dt_alias
      AND      start_dai_sequence_number = x_sequence_number
      AND      fee_cal_type = x_cal_type
      AND      fee_ci_sequence_number = x_ci_sequence_number ;

Line: 536

      SELECT   rowid
      FROM     IGS_FI_F_CAT_FEE_LBL_ALL
      WHERE    fee_cat = x_fee_cat
      AND      fee_cal_type = x_fee_cal_type
      AND      fee_ci_sequence_number = x_fee_ci_sequence_number ;

Line: 558

      SELECT   rowid
      FROM     IGS_FI_F_CAT_FEE_LBL_ALL
      WHERE    fee_liability_status = x_fee_structure_status ;

Line: 579

      SELECT   rowid
      FROM     IGS_FI_F_CAT_FEE_LBL_ALL
      WHERE    rul_sequence_number = x_sequence_number ;

Line: 599

      SELECT   rowid
      FROM     IGS_FI_F_CAT_FEE_LBL_ALL
      WHERE    s_chg_method_type = x_s_chg_method_type ;

Line: 631

    x_last_update_date IN DATE,
    x_last_updated_by IN NUMBER,
    x_last_update_login IN NUMBER,
    x_waiver_calc_flag  IN VARCHAR2
  ) AS
  /*************************************************************
  Created By :
  Date Created By :
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What
  shtatiko        10-FEB-2003     Enh# 2747325, Removed cases for p_action = 'DELETE' and
                                  p_action = 'VALIDATE_DELETE'
  vvutukur        19-Jul-2002     Bug#2425767.removed parameter x_payment_hierarchy_rank and its reference
                                  from the call to set_column_values.
  SCHODAVA	  13-OCT-2001     Bug # 2021281
				  Added the call to
				  BeforeRowInsertUpdateDelete1
				  for p_action = 'VALIDATE_DELETE'
  (reverse chronological order - newest change first)
  ***************************************************************/

  BEGIN
    Set_Column_Values (
      p_action,
      x_rowid,
      x_fee_cat,
      x_fee_cal_type,
      x_fee_ci_sequence_number,
      x_fee_type,
      x_fee_liability_status,
      x_start_dt_alias,
      x_start_dai_sequence_number,
      x_s_chg_method_type,
      x_rul_sequence_number,
      x_org_id,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login,
      x_waiver_calc_flag
    );

Line: 675

    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to Before Insert.
      BeforeRowInsertUpdateDelete1 ( p_inserting => TRUE, p_updating =>FALSE ,  p_deleting => FALSE );

Line: 691

    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to Before Update.
      BeforeRowInsertUpdateDelete1 ( p_inserting => FALSE, p_updating => TRUE ,  p_deleting => FALSE );

Line: 697

    ELSIF (p_action = 'VALIDATE_INSERT') THEN
      IF (Get_PK_For_Validation (
            x_fee_cat,
            x_fee_cal_type,
            x_fee_ci_sequence_number,
            x_fee_type
          )) THEN
        Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');

Line: 710

    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      Check_Uniqueness;

Line: 728

  ||  smvk            02-Sep-2002  Call to AfterRowUpdate3 is updated to pass all the parameter as per the Apps
  ||                               standard. As a part of Build SFCR005_Cleanup_Build (Enhancement Bug # 2531390)
  ||  vvutukur        19-Jul-2002  Bug#2425767.removed (earlier commented) calls to AfterStmtInsertUpdate4
  ||                               procedure if p_action='INSERT' or 'UPDATE' as this procedure itself is
  ||                               removed from this package body.Removed if conditions i)if p_action='INSERT'
  ||                               ii)p_action='DELETE' as no code exists in those conditions.
  ----------------------------------------------------------------------------*/
  BEGIN
    l_rowid := x_rowid;

Line: 737

    IF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to After Update.
      AfterRowUpdate3 (p_inserting  => FALSE, p_updating => TRUE, p_deleting =>FALSE );

Line: 743

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_FEE_CAT in VARCHAR2,
  X_FEE_CI_SEQUENCE_NUMBER in NUMBER,
  X_FEE_TYPE in VARCHAR2,
  X_FEE_CAL_TYPE in VARCHAR2,
  X_FEE_LIABILITY_STATUS in VARCHAR2,
  X_START_DT_ALIAS in VARCHAR2,
  X_START_DAI_SEQUENCE_NUMBER in NUMBER,
  X_S_CHG_METHOD_TYPE in VARCHAR2,
  X_RUL_SEQUENCE_NUMBER in NUMBER,
  X_ORG_ID in NUMBER,
  X_MODE in VARCHAR2,
  X_WAIVER_CALC_FLAG IN VARCHAR2
  ) is
  /************************************************************************************
  vvutukur      19-Jul-2002     Bug#2425767.removed parameter x_payment_hierarchy_rank and from call to
                                before_dml and from insert statement.
  sbaliga 	13-feb-2002	Assigned igs_ge_gen_003.get_org_id  to x_org_id
  				in call to before_dml as part of SWCR006 build.
  *****************************************************************************/
    cursor C is select ROWID from IGS_FI_F_CAT_FEE_LBL_ALL
      where FEE_CAT = X_FEE_CAT
      and FEE_CI_SEQUENCE_NUMBER = X_FEE_CI_SEQUENCE_NUMBER
      and FEE_TYPE = X_FEE_TYPE
      and FEE_CAL_TYPE = X_FEE_CAL_TYPE;

Line: 769

    X_LAST_UPDATE_DATE DATE;

Line: 770

    X_LAST_UPDATED_BY NUMBER;

Line: 771

    X_LAST_UPDATE_LOGIN NUMBER;

Line: 775

    X_PROGRAM_UPDATE_DATE DATE;

Line: 777

  X_LAST_UPDATE_DATE := SYSDATE;

Line: 779

    X_LAST_UPDATED_BY := 1;

Line: 780

    X_LAST_UPDATE_LOGIN := 0;

Line: 782

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 783

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 786

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 787

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 797

      X_PROGRAM_UPDATE_DATE:=NULL;

Line: 799

      X_PROGRAM_UPDATE_DATE:=SYSDATE;

Line: 807

 p_action=>'INSERT',
 x_rowid=>X_ROWID,
 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_liability_status=>X_FEE_LIABILITY_STATUS,
 x_fee_type=>X_FEE_TYPE,
 x_rul_sequence_number=>X_RUL_SEQUENCE_NUMBER,
 x_s_chg_method_type=>X_S_CHG_METHOD_TYPE,
 x_start_dai_sequence_number=>X_START_DAI_SEQUENCE_NUMBER,
 x_start_dt_alias=>X_START_DT_ALIAS,
 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_waiver_calc_flag => X_WAIVER_CALC_FLAG
);

Line: 826

  insert into IGS_FI_F_CAT_FEE_LBL_ALL (
    FEE_CAT,
    FEE_CAL_TYPE,
    FEE_CI_SEQUENCE_NUMBER,
    FEE_TYPE,
    FEE_LIABILITY_STATUS,
    START_DT_ALIAS,
    START_DAI_SEQUENCE_NUMBER,
    S_CHG_METHOD_TYPE,
    RUL_SEQUENCE_NUMBER,
    ORG_ID,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    REQUEST_ID,
    PROGRAM_ID,
    PROGRAM_APPLICATION_ID,
    PROGRAM_UPDATE_DATE,
    WAIVER_CALC_FLAG
  ) values (
    NEW_REFERENCES.FEE_CAT,
    NEW_REFERENCES.FEE_CAL_TYPE,
    NEW_REFERENCES.FEE_CI_SEQUENCE_NUMBER,
    NEW_REFERENCES.FEE_TYPE,
    NEW_REFERENCES.FEE_LIABILITY_STATUS,
    NEW_REFERENCES.START_DT_ALIAS,
    NEW_REFERENCES.START_DAI_SEQUENCE_NUMBER,
    NEW_REFERENCES.S_CHG_METHOD_TYPE,
    NEW_REFERENCES.RUL_SEQUENCE_NUMBER,
    NEW_REFERENCES.ORG_ID,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_REQUEST_ID,
    X_PROGRAM_ID,
    X_PROGRAM_APPLICATION_ID,
    X_PROGRAM_UPDATE_DATE,
    NEW_REFERENCES.WAIVER_CALC_FLAG
  );

Line: 877

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

Line: 880

end INSERT_ROW;

Line: 905

  cursor c1 is select
      FEE_LIABILITY_STATUS,
      START_DT_ALIAS,
      START_DAI_SEQUENCE_NUMBER,
      S_CHG_METHOD_TYPE,
      RUL_SEQUENCE_NUMBER,
      WAIVER_CALC_FLAG
    from IGS_FI_F_CAT_FEE_LBL_ALL
    where ROWID=X_ROWID
    for update nowait;

Line: 921

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

Line: 952

procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_FEE_CAT in VARCHAR2,
  X_FEE_CI_SEQUENCE_NUMBER in NUMBER,
  X_FEE_TYPE in VARCHAR2,
  X_FEE_CAL_TYPE in VARCHAR2,
  X_FEE_LIABILITY_STATUS in VARCHAR2,
  X_START_DT_ALIAS in VARCHAR2,
  X_START_DAI_SEQUENCE_NUMBER in NUMBER,
  X_S_CHG_METHOD_TYPE in VARCHAR2,
  X_RUL_SEQUENCE_NUMBER in NUMBER,
  X_MODE in VARCHAR2,
  X_WAIVER_CALC_FLAG IN VARCHAR2
  ) is
  /*----------------------------------------------------------------------------
  ||  Created By :
  ||  Created On :
  ||  Purpose :
  ||  Known limitations, enhancements or remarks :
  ||  Change History :
  ||  Who             When            What
  ||  (reverse chronological order - newest change first)
  ||  vvutukur        19-Jul-2002  Bug#2425767.removed parameter x_payment_hierarchy_rank
  ||                               and from call to before_dml and from update statement.
  ----------------------------------------------------------------------------*/
    X_LAST_UPDATE_DATE DATE;

Line: 978

    X_LAST_UPDATED_BY NUMBER;

Line: 979

    X_LAST_UPDATE_LOGIN NUMBER;

Line: 983

    X_PROGRAM_UPDATE_DATE DATE;

Line: 985

  X_LAST_UPDATE_DATE := SYSDATE;

Line: 987

    X_LAST_UPDATED_BY := 1;

Line: 988

    X_LAST_UPDATE_LOGIN := 0;

Line: 990

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 991

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 994

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 995

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 1005

      X_PROGRAM_UPDATE_DATE:=OLD_REFERENCES.PROGRAM_UPDATE_DATE;

Line: 1007

      X_PROGRAM_UPDATE_DATE:=SYSDATE;

Line: 1015

 p_action=>'UPDATE',
 x_rowid=>X_ROWID,
 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_liability_status=>X_FEE_LIABILITY_STATUS,
 x_fee_type=>X_FEE_TYPE,
 x_rul_sequence_number=>X_RUL_SEQUENCE_NUMBER,
 x_s_chg_method_type=>X_S_CHG_METHOD_TYPE,
 x_start_dai_sequence_number=>X_START_DAI_SEQUENCE_NUMBER,
 x_start_dt_alias=>X_START_DT_ALIAS,
 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_waiver_calc_flag => X_WAIVER_CALC_FLAG
);

Line: 1033

  update IGS_FI_F_CAT_FEE_LBL_ALL set
    FEE_LIABILITY_STATUS = NEW_REFERENCES.FEE_LIABILITY_STATUS,
    START_DT_ALIAS = NEW_REFERENCES.START_DT_ALIAS,
    START_DAI_SEQUENCE_NUMBER = NEW_REFERENCES.START_DAI_SEQUENCE_NUMBER,
    S_CHG_METHOD_TYPE = NEW_REFERENCES.S_CHG_METHOD_TYPE,
    RUL_SEQUENCE_NUMBER = NEW_REFERENCES.RUL_SEQUENCE_NUMBER,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    REQUEST_ID=X_REQUEST_ID,
    PROGRAM_ID=X_PROGRAM_ID,
    PROGRAM_APPLICATION_ID=X_PROGRAM_APPLICATION_ID,
    PROGRAM_UPDATE_DATE=X_PROGRAM_UPDATE_DATE,
    WAIVER_CALC_FLAG=X_WAIVER_CALC_FLAG
  where ROWID=X_ROWID
  ;

Line: 1053

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

Line: 1056

end UPDATE_ROW;

Line: 1081

  ||                               and from calls to insert_row and update_row.
  ----------------------------------------------------------------------------*/
  cursor c1 is select rowid from IGS_FI_F_CAT_FEE_LBL_ALL
     where FEE_CAT = X_FEE_CAT
     and FEE_CI_SEQUENCE_NUMBER = X_FEE_CI_SEQUENCE_NUMBER
     and FEE_TYPE = X_FEE_TYPE
     and FEE_CAL_TYPE = X_FEE_CAL_TYPE
  ;

Line: 1094

    INSERT_ROW (
     X_ROWID,
     X_FEE_CAT,
     X_FEE_CI_SEQUENCE_NUMBER,
     X_FEE_TYPE,
     X_FEE_CAL_TYPE,
     X_FEE_LIABILITY_STATUS,
     X_START_DT_ALIAS,
     X_START_DAI_SEQUENCE_NUMBER,
     X_S_CHG_METHOD_TYPE,
     X_RUL_SEQUENCE_NUMBER,
     X_ORG_ID,
     X_MODE,
     X_WAIVER_CALC_FLAG
     );

Line: 1112

  UPDATE_ROW (
   X_ROWID,
   X_FEE_CAT,
   X_FEE_CI_SEQUENCE_NUMBER,
   X_FEE_TYPE,
   X_FEE_CAL_TYPE,
   X_FEE_LIABILITY_STATUS,
   X_START_DT_ALIAS,
   X_START_DAI_SEQUENCE_NUMBER,
   X_S_CHG_METHOD_TYPE,
   X_RUL_SEQUENCE_NUMBER,
   X_MODE,
   X_WAIVER_CALC_FLAG
   );