DBA Data[Home] [Help]

APPS.IGS_FI_F_RET_SCHD_HT_PKG SQL Statements

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

Line: 26

    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
  /*----------------------------------------------------------------------------
  ||  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_deduction_amount and its reference in
  ||                               copying old_references value into new_references.value.
  ----------------------------------------------------------------------------*/
    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     IGS_FI_F_RET_SCHD_HT_ALL
      WHERE    rowid = x_rowid;
Line: 51

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

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

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

    new_references.last_update_date := x_last_update_date;
Line: 83

    new_references.last_updated_by := x_last_updated_by;
Line: 84

    new_references.last_update_login := x_last_update_login;
Line: 218

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

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

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

      SELECT   rowid
      FROM     IGS_FI_F_RET_SCHD_HT_ALL
      WHERE    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      sequence_number = x_sequence_number
      AND      hist_start_dt = x_hist_start_dt
      FOR UPDATE NOWAIT;
Line: 300

      SELECT   rowid
      FROM     IGS_FI_F_RET_SCHD_HT_ALL
      WHERE    fee_cal_type = x_fee_cal_type
      AND      fee_ci_sequence_number = x_fee_ci_sequence_number
      AND      fee_type = x_fee_type
      AND      fee_cat = x_fee_cat
      AND      schedule_number = x_schedule_number
      AND      hist_start_dt = x_hist_start_dt
      AND      ((l_rowid IS NULL) OR (rowid <> l_rowid))
      FOR UPDATE NOWAIT;
Line: 328

      SELECT   rowid
      FROM     IGS_FI_F_RET_SCHD_HT_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: 367

    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
  /*----------------------------------------------------------------------------
  ||  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_deduction_amount and its reference in
  ||                               from call to set_column_values.
  ----------------------------------------------------------------------------*/
  BEGIN
    Set_Column_Values (
      p_action,
      x_rowid,
      x_fee_cal_type,
      x_fee_ci_sequence_number,
      x_s_relation_type,
      x_sequence_number,
      x_hist_start_dt,
      x_hist_end_dt,
      x_hist_who,
      x_fee_type,
      x_fee_cat,
      x_schedule_number,
      x_dt_alias,
      x_dai_sequence_number,
      x_retention_percentage,
      x_retention_amount,
      x_org_id,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );
Line: 407

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

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

    ELSIF (p_action = 'VALIDATE_INSERT') THEN
      IF (Get_PK_For_Validation (
            new_references.fee_cal_type,
            new_references.fee_ci_sequence_number,
			new_references.s_relation_type,
			new_references.sequence_number,
			new_references.hist_start_dt
          )) THEN
        Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
Line: 443

    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      Check_Uniqueness;
Line: 448

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_FEE_CAL_TYPE in VARCHAR2,
  X_FEE_CI_SEQUENCE_NUMBER in NUMBER,
  X_S_RELATION_TYPE in VARCHAR2,
  X_SEQUENCE_NUMBER in NUMBER,
  X_HIST_START_DT in DATE,
  X_HIST_END_DT in DATE,
  X_HIST_WHO in NUMBER,
  X_FEE_TYPE in VARCHAR2,
  X_FEE_CAT in VARCHAR2,
  X_SCHEDULE_NUMBER in NUMBER,
  X_DT_ALIAS in VARCHAR2,
  X_DAI_SEQUENCE_NUMBER in NUMBER,
  X_RETENTION_PERCENTAGE in NUMBER,
  X_RETENTION_AMOUNT in NUMBER,
  X_ORG_ID in NUMBER,
  X_MODE in VARCHAR2 default 'R'
  ) 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_deduction_amount and its references
  ||                               (from call to before_dml and insert statement).
  ----------------------------------------------------------------------------*/
    cursor C is select ROWID from IGS_FI_F_RET_SCHD_HT_ALL
      where 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 SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
      and HIST_START_DT = X_HIST_START_DT;
Line: 484

    X_LAST_UPDATE_DATE DATE;
Line: 485

    X_LAST_UPDATED_BY NUMBER;
Line: 486

    X_LAST_UPDATE_LOGIN NUMBER;
Line: 488

  X_LAST_UPDATE_DATE := SYSDATE;
Line: 490

    X_LAST_UPDATED_BY := 1;
Line: 491

    X_LAST_UPDATE_LOGIN := 0;
Line: 493

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 494

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

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 498

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

 p_action=>'INSERT',
 x_rowid=>X_ROWID,
 x_dai_sequence_number=>X_DAI_SEQUENCE_NUMBER,
 x_dt_alias=>X_DT_ALIAS,
 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_hist_end_dt=>X_HIST_END_DT,
 x_hist_start_dt=>X_HIST_START_DT,
 x_hist_who=>X_HIST_WHO,
 x_retention_amount=>X_RETENTION_AMOUNT,
 x_retention_percentage=>X_RETENTION_PERCENTAGE,
 x_s_relation_type=>X_S_RELATION_TYPE,
 x_schedule_number=>X_SCHEDULE_NUMBER,
 x_sequence_number=>X_SEQUENCE_NUMBER,
 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
 );
Line: 530

  insert into IGS_FI_F_RET_SCHD_HT_ALL (
    FEE_CAL_TYPE,
    FEE_CI_SEQUENCE_NUMBER,
    S_RELATION_TYPE,
    SEQUENCE_NUMBER,
    HIST_START_DT,
    HIST_END_DT,
    HIST_WHO,
    FEE_TYPE,
    FEE_CAT,
    SCHEDULE_NUMBER,
    DT_ALIAS,
    DAI_SEQUENCE_NUMBER,
    RETENTION_PERCENTAGE,
    RETENTION_AMOUNT,
    ORG_ID,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    NEW_REFERENCES.FEE_CAL_TYPE,
    NEW_REFERENCES.FEE_CI_SEQUENCE_NUMBER,
    NEW_REFERENCES.S_RELATION_TYPE,
    NEW_REFERENCES.SEQUENCE_NUMBER,
    NEW_REFERENCES.HIST_START_DT,
    NEW_REFERENCES.HIST_END_DT,
    NEW_REFERENCES.HIST_WHO,
    NEW_REFERENCES.FEE_TYPE,
    NEW_REFERENCES.FEE_CAT,
    NEW_REFERENCES.SCHEDULE_NUMBER,
    NEW_REFERENCES.DT_ALIAS,
    NEW_REFERENCES.DAI_SEQUENCE_NUMBER,
    NEW_REFERENCES.RETENTION_PERCENTAGE,
    NEW_REFERENCES.RETENTION_AMOUNT,
    NEW_REFERENCES.ORG_ID,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );
Line: 580

end INSERT_ROW;
Line: 609

  cursor c1 is select
      HIST_END_DT,
      HIST_WHO,
      FEE_TYPE,
      FEE_CAT,
      SCHEDULE_NUMBER,
      DT_ALIAS,
      DAI_SEQUENCE_NUMBER,
      RETENTION_PERCENTAGE,
      RETENTION_AMOUNT
    from IGS_FI_F_RET_SCHD_HT_ALL
    where ROWID=X_ROWID
    for update nowait;
Line: 628

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

procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_FEE_CAL_TYPE in VARCHAR2,
  X_FEE_CI_SEQUENCE_NUMBER in NUMBER,
  X_S_RELATION_TYPE in VARCHAR2,
  X_SEQUENCE_NUMBER in NUMBER,
  X_HIST_START_DT in DATE,
  X_HIST_END_DT in DATE,
  X_HIST_WHO in NUMBER,
  X_FEE_TYPE in VARCHAR2,
  X_FEE_CAT in VARCHAR2,
  X_SCHEDULE_NUMBER in NUMBER,
  X_DT_ALIAS in VARCHAR2,
  X_DAI_SEQUENCE_NUMBER in NUMBER,
  X_RETENTION_PERCENTAGE in NUMBER,
  X_RETENTION_AMOUNT in NUMBER,
  X_MODE in VARCHAR2 default 'R'
  ) 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_deduction_amount and its references
  ||                               (from call to before_dml and update statement).
  ----------------------------------------------------------------------------*/
    X_LAST_UPDATE_DATE DATE;
Line: 696

    X_LAST_UPDATED_BY NUMBER;
Line: 697

    X_LAST_UPDATE_LOGIN NUMBER;
Line: 699

  X_LAST_UPDATE_DATE := SYSDATE;
Line: 701

    X_LAST_UPDATED_BY := 1;
Line: 702

    X_LAST_UPDATE_LOGIN := 0;
Line: 704

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 705

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

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 709

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

 p_action=>'UPDATE',
 x_rowid=>X_ROWID,
 x_dai_sequence_number=>X_DAI_SEQUENCE_NUMBER,
 x_dt_alias=>X_DT_ALIAS,
 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_hist_end_dt=>X_HIST_END_DT,
 x_hist_start_dt=>X_HIST_START_DT,
 x_hist_who=>X_HIST_WHO,
 x_retention_amount=>X_RETENTION_AMOUNT,
 x_retention_percentage=>X_RETENTION_PERCENTAGE,
 x_s_relation_type=>X_S_RELATION_TYPE,
 x_schedule_number=>X_SCHEDULE_NUMBER,
 x_sequence_number=>X_SEQUENCE_NUMBER,
 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: 740

  update IGS_FI_F_RET_SCHD_HT_ALL set
    HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
    HIST_WHO = NEW_REFERENCES.HIST_WHO,
    FEE_TYPE = NEW_REFERENCES.FEE_TYPE,
    FEE_CAT = NEW_REFERENCES.FEE_CAT,
    SCHEDULE_NUMBER = NEW_REFERENCES.SCHEDULE_NUMBER,
    DT_ALIAS = NEW_REFERENCES.DT_ALIAS,
    DAI_SEQUENCE_NUMBER = NEW_REFERENCES.DAI_SEQUENCE_NUMBER,
    RETENTION_PERCENTAGE = NEW_REFERENCES.RETENTION_PERCENTAGE,
    RETENTION_AMOUNT = NEW_REFERENCES.RETENTION_AMOUNT,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where ROWID=X_ROWID
  ;
Line: 758

end UPDATE_ROW;
Line: 787

  ||                               (from calls to insert_row and update_row).
  ----------------------------------------------------------------------------*/
  cursor c1 is select rowid from IGS_FI_F_RET_SCHD_HT_ALL
     where 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 SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
     and HIST_START_DT = X_HIST_START_DT
  ;
Line: 801

    INSERT_ROW (
     X_ROWID,
     X_FEE_CAL_TYPE,
     X_FEE_CI_SEQUENCE_NUMBER,
     X_S_RELATION_TYPE,
     X_SEQUENCE_NUMBER,
     X_HIST_START_DT,
     X_HIST_END_DT,
     X_HIST_WHO,
     X_FEE_TYPE,
     X_FEE_CAT,
     X_SCHEDULE_NUMBER,
     X_DT_ALIAS,
     X_DAI_SEQUENCE_NUMBER,
     X_RETENTION_PERCENTAGE,
     X_RETENTION_AMOUNT,
     X_ORG_ID,
     X_MODE);
Line: 822

  UPDATE_ROW (
   X_ROWID,
   X_FEE_CAL_TYPE,
   X_FEE_CI_SEQUENCE_NUMBER,
   X_S_RELATION_TYPE,
   X_SEQUENCE_NUMBER,
   X_HIST_START_DT,
   X_HIST_END_DT,
   X_HIST_WHO,
   X_FEE_TYPE,
   X_FEE_CAT,
   X_SCHEDULE_NUMBER,
   X_DT_ALIAS,
   X_DAI_SEQUENCE_NUMBER,
   X_RETENTION_PERCENTAGE,
   X_RETENTION_AMOUNT,
   X_MODE);
Line: 840

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

  delete from IGS_FI_F_RET_SCHD_HT_ALL
  where ROWID=X_ROWID;
Line: 853

end DELETE_ROW;