eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_FEE_TYPE_CI_H_PKG SQL Statements

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

Line: 59


    x_last_update_date IN DATE DEFAULT NULL,

    x_last_updated_by IN NUMBER DEFAULT NULL,

    x_last_update_login IN NUMBER DEFAULT NULL ,
    x_scope_rul_sequence_num IN NUMBER DEFAULT NULL,
    x_elm_rng_order_name IN VARCHAR2 DEFAULT NULL


  ) AS
  /*----------------------------------------------------------------------------
  ||  Created By :
  ||  Created On :
  ||  Purpose :
  ||  Known limitations, enhancements or remarks :
  ||  Change History :
  ||  Who             When            What
  ||  (reverse chronological order - newest change first)
  ||  gurprsin        18-Jun-2005  Bug# 3392088 , Added 2 new columns scope_rul_sequence_num and elm_rng_order_name.
  ||  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_FEE_TYPE_CI_H_ALL

      WHERE    rowid = x_rowid;

Line: 109


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

      Close cur_old_ref_values;

Line: 112


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

Line: 163


    IF (p_action = 'UPDATE') THEN

      new_references.creation_date := old_references.creation_date;

Line: 177


    new_references.last_update_date := x_last_update_date;

Line: 179


    new_references.last_updated_by := x_last_updated_by;

Line: 181


    new_references.last_update_login := x_last_update_login;

Line: 372


      SELECT   rowid
      FROM     IGS_FI_FEE_TYPE_CI_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      hist_start_dt = x_hist_start_dt
      FOR UPDATE NOWAIT;

Line: 438


    x_last_update_date IN DATE DEFAULT NULL,

    x_last_updated_by IN NUMBER DEFAULT NULL,

    x_last_update_login IN NUMBER DEFAULT NULL,

    x_nonzero_billable_cp_flag IN VARCHAR2 DEFAULT NULL,
    x_scope_rul_sequence_num IN NUMBER DEFAULT NULL,
    x_elm_rng_order_name IN VARCHAR2 DEFAULT NULL
  ) AS
  /*----------------------------------------------------------------------------
  ||  Created By :
  ||  Created On :
  ||  Purpose :
  ||  Known limitations, enhancements or remarks :
  ||  Change History :
  ||  Who             When            What
  ||  (reverse chronological order - newest change first)
  ||  gurprsin      18-Jun-2005   Bug# 3392088 , Added 2 new columns scope_rul_sequence_num and elm_rng_order_name.
  ||  vvutukur        19-Jul-2002  Bug#2425767.removed parameter x_payment_hierarchy_rank
  ||                               and from call to set_column_values procedure.
  ----------------------------------------------------------------------------*/

  BEGIN

    Set_Column_Values (

      p_action,

      x_rowid,

      x_fee_type,

      x_fee_cal_type,

      x_fee_ci_sequence_number,

      x_hist_start_dt,

      x_hist_end_dt,

      x_hist_who,

      x_fee_type_ci_status,

      x_start_dt_alias,

      x_start_dai_sequence_number,

      x_end_dt_alias,

      x_end_dai_sequence_number,

      x_retro_dt_alias,

      x_retro_dai_sequence_number,

      x_s_chg_method_type,

      x_rul_sequence_number,

      x_initial_default_amount,

      x_org_id,

      x_nonzero_billable_cp_flag,

      x_creation_date,

      x_created_by,

      x_last_update_date,

      x_last_updated_by,

      x_last_update_login,
      x_scope_rul_sequence_num,
      x_elm_rng_order_name
    );

Line: 520


    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to Before Insert.
	  IF Get_PK_For_Validation (   new_references.fee_type,
			    new_references.fee_cal_type,
			    new_references.fee_ci_sequence_number ,
			    new_references.hist_start_dt  )
				THEN
			Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');

Line: 532


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

Line: 535


    ELSIF (p_action = 'VALIDATE_INSERT') THEN
      -- Call all the procedures related to Before Insert.
	  IF Get_PK_For_Validation (   new_references.fee_type,
			    new_references.fee_cal_type,
			    new_references.fee_ci_sequence_number ,
			    new_references.hist_start_dt  )
				THEN
			Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');

Line: 547


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
	 	    Check_Constraints;

Line: 555


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_FEE_TYPE in VARCHAR2,
  X_FEE_CAL_TYPE in VARCHAR2,
  X_HIST_START_DT in DATE,
  X_FEE_CI_SEQUENCE_NUMBER in NUMBER,
  X_HIST_END_DT in DATE,
  X_HIST_WHO in NUMBER,
  X_FEE_TYPE_CI_STATUS in VARCHAR2,
  X_START_DT_ALIAS in VARCHAR2,
  X_START_DAI_SEQUENCE_NUMBER in NUMBER,
  X_END_DT_ALIAS in VARCHAR2,
  X_END_DAI_SEQUENCE_NUMBER in NUMBER,
  X_RETRO_DT_ALIAS in VARCHAR2,
  X_RETRO_DAI_SEQUENCE_NUMBER in NUMBER,
  X_S_CHG_METHOD_TYPE in VARCHAR2,
  X_RUL_SEQUENCE_NUMBER in NUMBER,
  X_INITIAL_DEFAULT_AMOUNT in NUMBER DEFAULT NULL,
  X_ORG_ID in NUMBER,
  X_MODE in VARCHAR2 default 'R',
  X_NONZERO_BILLABLE_CP_FLAG IN VARCHAR2 DEFAULT NULL,
  x_scope_rul_sequence_num IN NUMBER DEFAULT NULL,
  x_elm_rng_order_name IN VARCHAR2 DEFAULT NULL
  ) AS
  /*----------------------------------------------------------------------------
  ||  Created By :
  ||  Created On :
  ||  Purpose :
  ||  Known limitations, enhancements or remarks :
  ||  Change History :
  ||  Who             When            What
  ||  (reverse chronological order - newest change first)
  ||  gurprsin      18-Jun-2005   Bug# 3392088 , Added 2 new columns scope_rul_sequence_num and elm_rng_order_name.
  ||  vvutukur        19-Jul-2002  Bug#2425767.removed parameter x_payment_hierarchy_rank,
  ||                               and from call to before_dml procedure,from insert statement.
  ----------------------------------------------------------------------------*/
    cursor C is select ROWID from IGS_FI_FEE_TYPE_CI_H_ALL
      where FEE_TYPE = X_FEE_TYPE
      and FEE_CAL_TYPE = X_FEE_CAL_TYPE
      and HIST_START_DT = X_HIST_START_DT
      and FEE_CI_SEQUENCE_NUMBER = X_FEE_CI_SEQUENCE_NUMBER;

Line: 596


    X_LAST_UPDATE_DATE DATE;

Line: 597


    X_LAST_UPDATED_BY NUMBER;

Line: 598


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 600


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 602


    X_LAST_UPDATED_BY := 1;

Line: 603


    X_LAST_UPDATE_LOGIN := 0;

Line: 605


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 606


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 609


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 610


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 622


 p_action=>'INSERT',

 x_rowid=>X_ROWID,

 x_end_dai_sequence_number=>X_END_DAI_SEQUENCE_NUMBER,

 x_end_dt_alias=>X_END_DT_ALIAS,

 x_fee_cal_type=>X_FEE_CAL_TYPE,

 x_fee_ci_sequence_number=>X_FEE_CI_SEQUENCE_NUMBER,

 x_fee_type=>X_FEE_TYPE,

 x_fee_type_ci_status=>X_FEE_TYPE_CI_STATUS,

 x_hist_end_dt=>X_HIST_END_DT,

 x_hist_start_dt=>X_HIST_START_DT,

 x_hist_who=>X_HIST_WHO,

 x_initial_default_amount=>X_INITIAL_DEFAULT_AMOUNT,

 x_retro_dai_sequence_number=>X_RETRO_DAI_SEQUENCE_NUMBER,

 x_retro_dt_alias=>X_RETRO_DT_ALIAS,

 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_nonzero_billable_cp_flag => X_NONZERO_BILLABLE_CP_FLAG,
 x_scope_rul_sequence_num  =>  X_scope_rul_sequence_num,
 x_elm_rng_order_name      =>  X_elm_rng_order_name
);

Line: 676


  insert into IGS_FI_FEE_TYPE_CI_H_ALL (
    FEE_TYPE,
    FEE_CAL_TYPE,
    FEE_CI_SEQUENCE_NUMBER,
    HIST_START_DT,
    HIST_END_DT,
    HIST_WHO,
    FEE_TYPE_CI_STATUS,
    START_DT_ALIAS,
    START_DAI_SEQUENCE_NUMBER,
    END_DT_ALIAS,
    END_DAI_SEQUENCE_NUMBER,
    RETRO_DT_ALIAS,
    RETRO_DAI_SEQUENCE_NUMBER,
    S_CHG_METHOD_TYPE,
    RUL_SEQUENCE_NUMBER,
    INITIAL_DEFAULT_AMOUNT,
    ORG_ID,
    NONZERO_BILLABLE_CP_FLAG,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    SCOPE_RUL_SEQUENCE_NUM,
    ELM_RNG_ORDER_NAME
  ) values (
    NEW_REFERENCES.FEE_TYPE,
    NEW_REFERENCES.FEE_CAL_TYPE,
    NEW_REFERENCES.FEE_CI_SEQUENCE_NUMBER,
    NEW_REFERENCES.HIST_START_DT,
    NEW_REFERENCES.HIST_END_DT,
    NEW_REFERENCES.HIST_WHO,
    NEW_REFERENCES.FEE_TYPE_CI_STATUS,
    NEW_REFERENCES.START_DT_ALIAS,
    NEW_REFERENCES.START_DAI_SEQUENCE_NUMBER,
    NEW_REFERENCES.END_DT_ALIAS,
    NEW_REFERENCES.END_DAI_SEQUENCE_NUMBER,
    NEW_REFERENCES.RETRO_DT_ALIAS,
    NEW_REFERENCES.RETRO_DAI_SEQUENCE_NUMBER,
    NEW_REFERENCES.S_CHG_METHOD_TYPE,
    NEW_REFERENCES.RUL_SEQUENCE_NUMBER,
    NEW_REFERENCES.INITIAL_DEFAULT_AMOUNT,
    NEW_REFERENCES.ORG_ID,
    NEW_REFERENCES.NONZERO_BILLABLE_CP_FLAG,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    NEW_REFERENCES.SCOPE_RUL_SEQUENCE_NUM,
    NEW_REFERENCES.ELM_RNG_ORDER_NAME
  );

Line: 737


end INSERT_ROW;

Line: 772


  cursor c1 is select
      HIST_END_DT,
      HIST_WHO,
      FEE_TYPE_CI_STATUS,
      START_DT_ALIAS,
      START_DAI_SEQUENCE_NUMBER,
      END_DT_ALIAS,
      END_DAI_SEQUENCE_NUMBER,
      RETRO_DT_ALIAS,
      RETRO_DAI_SEQUENCE_NUMBER,
      S_CHG_METHOD_TYPE,
      RUL_SEQUENCE_NUMBER,
      INITIAL_DEFAULT_AMOUNT,
      NONZERO_BILLABLE_CP_FLAG,
      SCOPE_RUL_SEQUENCE_NUM,
      ELM_RNG_ORDER_NAME
    from IGS_FI_FEE_TYPE_CI_H_ALL
    where ROWID = X_ROWID
    for update nowait;

Line: 798


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

Line: 854


procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_FEE_TYPE in VARCHAR2,
  X_FEE_CAL_TYPE in VARCHAR2,
  X_HIST_START_DT in DATE,
  X_FEE_CI_SEQUENCE_NUMBER in NUMBER,
  X_HIST_END_DT in DATE,
  X_HIST_WHO in NUMBER,
  X_FEE_TYPE_CI_STATUS in VARCHAR2,
  X_START_DT_ALIAS in VARCHAR2,
  X_START_DAI_SEQUENCE_NUMBER in NUMBER,
  X_END_DT_ALIAS in VARCHAR2,
  X_END_DAI_SEQUENCE_NUMBER in NUMBER,
  X_RETRO_DT_ALIAS in VARCHAR2,
  X_RETRO_DAI_SEQUENCE_NUMBER in NUMBER,
  X_S_CHG_METHOD_TYPE in VARCHAR2,
  X_RUL_SEQUENCE_NUMBER in NUMBER,
  X_INITIAL_DEFAULT_AMOUNT in NUMBER DEFAULT NULL,
  X_MODE in VARCHAR2 default 'R',
  X_NONZERO_BILLABLE_CP_FLAG IN VARCHAR2 DEFAULT NULL,
  X_SCOPE_RUL_SEQUENCE_NUM IN NUMBER DEFAULT NULL,
  X_ELM_RNG_ORDER_NAME IN VARCHAR2 DEFAULT NULL
  ) AS
  /*----------------------------------------------------------------------------
  ||  Created By :
  ||  Created On :
  ||  Purpose :
  ||  Known limitations, enhancements or remarks :
  ||  Change History :
  ||  Who             When            What
  ||  (reverse chronological order - newest change first)
  ||  gurprsin      18-Jun-2005   Bug# 3392088 , Added 2 new columns scope_rul_sequence_num and elm_rng_order_name.
  ||  vvutukur        19-Jul-2002  Bug#2425767.removed parameter x_payment_hierarchy_rank,
  ||                               and from call to before_dml procedure and from update statement.
  ----------------------------------------------------------------------------*/
    X_LAST_UPDATE_DATE DATE;

Line: 890


    X_LAST_UPDATED_BY NUMBER;

Line: 891


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 893


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 895


    X_LAST_UPDATED_BY := 1;

Line: 896


    X_LAST_UPDATE_LOGIN := 0;

Line: 898


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 899


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 902


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 903


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 916


 p_action=>'UPDATE',

 x_rowid=>X_ROWID,

 x_end_dai_sequence_number=>X_END_DAI_SEQUENCE_NUMBER,

 x_end_dt_alias=>X_END_DT_ALIAS,

 x_fee_cal_type=>X_FEE_CAL_TYPE,

 x_fee_ci_sequence_number=>X_FEE_CI_SEQUENCE_NUMBER,

 x_fee_type=>X_FEE_TYPE,

 x_fee_type_ci_status=>X_FEE_TYPE_CI_STATUS,

 x_hist_end_dt=>X_HIST_END_DT,

 x_hist_start_dt=>X_HIST_START_DT,

 x_hist_who=>X_HIST_WHO,

 x_initial_default_amount=>X_INITIAL_DEFAULT_AMOUNT,

 x_retro_dai_sequence_number=>X_RETRO_DAI_SEQUENCE_NUMBER,

 x_retro_dt_alias=>X_RETRO_DT_ALIAS,

 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_nonzero_billable_cp_flag => X_NONZERO_BILLABLE_CP_FLAG,
 x_scope_rul_sequence_num => X_SCOPE_RUL_SEQUENCE_NUM,
 x_elm_rng_order_name     => X_ELM_RNG_ORDER_NAME
);

Line: 966


  update IGS_FI_FEE_TYPE_CI_H_ALL set
    HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
    HIST_WHO = NEW_REFERENCES.HIST_WHO,
    FEE_TYPE_CI_STATUS = NEW_REFERENCES.FEE_TYPE_CI_STATUS,
    START_DT_ALIAS = NEW_REFERENCES.START_DT_ALIAS,
    START_DAI_SEQUENCE_NUMBER = NEW_REFERENCES.START_DAI_SEQUENCE_NUMBER,
    END_DT_ALIAS = NEW_REFERENCES.END_DT_ALIAS,
    END_DAI_SEQUENCE_NUMBER = NEW_REFERENCES.END_DAI_SEQUENCE_NUMBER,
    RETRO_DT_ALIAS = NEW_REFERENCES.RETRO_DT_ALIAS,
    RETRO_DAI_SEQUENCE_NUMBER = NEW_REFERENCES.RETRO_DAI_SEQUENCE_NUMBER,
    S_CHG_METHOD_TYPE = NEW_REFERENCES.S_CHG_METHOD_TYPE,
    RUL_SEQUENCE_NUMBER = NEW_REFERENCES.RUL_SEQUENCE_NUMBER,
    INITIAL_DEFAULT_AMOUNT = NEW_REFERENCES.INITIAL_DEFAULT_AMOUNT,
    NONZERO_BILLABLE_CP_FLAG = NEW_REFERENCES.NONZERO_BILLABLE_CP_FLAG,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    SCOPE_RUL_SEQUENCE_NUM = NEW_REFERENCES.SCOPE_RUL_SEQUENCE_NUM,
    ELM_RNG_ORDER_NAME     = NEW_REFERENCES.ELM_RNG_ORDER_NAME
  where ROWID = X_ROWID;

Line: 990


end UPDATE_ROW;

Line: 1026


  ||                               and from calls to procedures insert_row and update_row.
  ----------------------------------------------------------------------------*/
  cursor c1 is select rowid from IGS_FI_FEE_TYPE_CI_H_ALL
     where FEE_TYPE = X_FEE_TYPE
     and FEE_CAL_TYPE = X_FEE_CAL_TYPE
     and HIST_START_DT = X_HIST_START_DT
     and FEE_CI_SEQUENCE_NUMBER = X_FEE_CI_SEQUENCE_NUMBER
  ;

Line: 1039


    INSERT_ROW (
     X_ROWID,
     X_FEE_TYPE,
     X_FEE_CAL_TYPE,
     X_HIST_START_DT,
     X_FEE_CI_SEQUENCE_NUMBER,
     X_HIST_END_DT,
     X_HIST_WHO,
     X_FEE_TYPE_CI_STATUS,
     X_START_DT_ALIAS,
     X_START_DAI_SEQUENCE_NUMBER,
     X_END_DT_ALIAS,
     X_END_DAI_SEQUENCE_NUMBER,
     X_RETRO_DT_ALIAS,
     X_RETRO_DAI_SEQUENCE_NUMBER,
     X_S_CHG_METHOD_TYPE,
     X_RUL_SEQUENCE_NUMBER,
     X_INITIAL_DEFAULT_AMOUNT,
     X_ORG_ID,
     X_MODE,
     X_NONZERO_BILLABLE_CP_FLAG,
     X_SCOPE_RUL_SEQUENCE_NUM,
     X_ELM_RNG_ORDER_NAME);

Line: 1065


  UPDATE_ROW (
   X_ROWID,
   X_FEE_TYPE,
   X_FEE_CAL_TYPE,
   X_HIST_START_DT,
   X_FEE_CI_SEQUENCE_NUMBER,
   X_HIST_END_DT,
   X_HIST_WHO,
   X_FEE_TYPE_CI_STATUS,
   X_START_DT_ALIAS,
   X_START_DAI_SEQUENCE_NUMBER,
   X_END_DT_ALIAS,
   X_END_DAI_SEQUENCE_NUMBER,
   X_RETRO_DT_ALIAS,
   X_RETRO_DAI_SEQUENCE_NUMBER,
   X_S_CHG_METHOD_TYPE,
   X_RUL_SEQUENCE_NUMBER,
   X_INITIAL_DEFAULT_AMOUNT,
   X_MODE,
   X_NONZERO_BILLABLE_CP_FLAG,
   X_SCOPE_RUL_SEQUENCE_NUM,
   X_ELM_RNG_ORDER_NAME
   );

Line: 1090


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

Line: 1098


  delete from IGS_FI_FEE_TYPE_CI_H_ALL
  where ROWID = X_ROWID;

Line: 1104


end DELETE_ROW;