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_HIST_PKG SQL Statements

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

Line: 27


    x_last_update_date IN DATE ,
    x_last_updated_by IN NUMBER ,
    x_last_update_login IN NUMBER ) AS

    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     IGS_FI_FEE_TYPE_HIST_ALL
      WHERE    rowid = x_rowid;

Line: 44


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

Line: 46


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

Line: 69


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

Line: 77


    new_references.last_update_date := x_last_update_date;

Line: 78


    new_references.last_updated_by := x_last_updated_by;

Line: 79


    new_references.last_update_login := x_last_update_login;

Line: 183


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

Line: 197


      SELECT   rowid
      FROM     IGS_FI_FEE_TYPE_HIST_ALL
      WHERE    fee_type = x_fee_type
      AND      hist_start_dt = x_hist_start_dt
      FOR UPDATE NOWAIT;

Line: 237


    x_last_update_date IN DATE ,
    x_last_updated_by IN NUMBER ,
    x_last_update_login IN NUMBER
  ) AS

  BEGIN

    Set_Column_Values (
      p_action,
      x_rowid,
      x_fee_type,
      x_hist_start_dt,
      x_hist_end_dt,
      x_hist_who,
      x_s_fee_type,
      x_s_fee_trigger_cat,
      x_description,
      x_optional_payment_ind,
      x_closed_ind,
      x_comments,
      x_org_id,
      x_fee_class,      --for Bug 2175865
      x_designated_payment_flag,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 266


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

          IF Get_PK_For_Validation ( new_references.fee_type,
                                       new_references.hist_start_dt) THEN
            Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');

Line: 277


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

Line: 281


   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.hist_start_dt) THEN
           Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');

Line: 290


   ELSIF (p_action = 'VALIDATE_UPDATE') THEN
        Check_Constraints;

Line: 297


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_FEE_TYPE in VARCHAR2,
  X_HIST_START_DT in DATE,
  X_HIST_END_DT in DATE,
  X_HIST_WHO in NUMBER,
  X_S_FEE_TYPE in VARCHAR2,
  X_S_FEE_TRIGGER_CAT in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_OPTIONAL_PAYMENT_IND in VARCHAR2,
  X_CLOSED_IND in VARCHAR2,
  X_COMMENTS in VARCHAR2,
  X_ORG_ID in NUMBER,
  X_MODE in VARCHAR2 ,
  X_FEE_CLASS      IN VARCHAR2, --Bug 2175865
  x_designated_payment_flag IN VARCHAR2
  ) AS
  /*-----------------------------------------------------------------------------
  CHANGE HISTORY:
  WHO        WHEN           WHAT
  sapanigr  09-Mar-2006   Bug 3296531. Removed NVL clause in call to Before_DML for
                          columns S_FEE_TYPE, S_FEE_TRIGGER_CAT and OPTIONAL_PAYMENT_IND
 -------------------------------------------------------------------------------*/
    cursor C is select ROWID from IGS_FI_FEE_TYPE_HIST_ALL
      where FEE_TYPE = X_FEE_TYPE
      and HIST_START_DT = X_HIST_START_DT;

Line: 323


    X_LAST_UPDATE_DATE DATE;

Line: 324


    X_LAST_UPDATED_BY NUMBER;

Line: 325


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 327


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 329


    X_LAST_UPDATED_BY := 1;

Line: 330


    X_LAST_UPDATE_LOGIN := 0;

Line: 332


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 333


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 336


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 337


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 348


  p_action=>'INSERT',
  x_rowid=>X_ROWID,
  x_closed_ind=>X_CLOSED_IND,
  x_comments=>X_COMMENTS,
  x_description=>X_DESCRIPTION,
  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_optional_payment_ind=>X_OPTIONAL_PAYMENT_IND,
  x_s_fee_trigger_cat=>X_S_FEE_TRIGGER_CAT,
  x_s_fee_type=>X_S_FEE_TYPE,
  x_org_id => igs_ge_gen_003.get_org_id,
  x_fee_class =>X_FEE_CLASS,            --for bug 2175865
  x_designated_payment_flag => x_designated_payment_flag,
  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: 370


  insert into IGS_FI_FEE_TYPE_HIST_ALL (
    FEE_TYPE,
    HIST_START_DT,
    HIST_END_DT,
    HIST_WHO,
    S_FEE_TYPE,
    S_FEE_TRIGGER_CAT,
    DESCRIPTION,
    OPTIONAL_PAYMENT_IND,
    CLOSED_IND,
    COMMENTS,
    ORG_ID,
    FEE_CLASS,     --for Bug 2175865
    designated_payment_flag,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    NEW_REFERENCES.FEE_TYPE,
    NEW_REFERENCES.HIST_START_DT,
    NEW_REFERENCES.HIST_END_DT,
    NEW_REFERENCES.HIST_WHO,
    NEW_REFERENCES.S_FEE_TYPE,
    NEW_REFERENCES.S_FEE_TRIGGER_CAT,
    NEW_REFERENCES.DESCRIPTION,
    NEW_REFERENCES.OPTIONAL_PAYMENT_IND,
    NEW_REFERENCES.CLOSED_IND,
    NEW_REFERENCES.COMMENTS,
    NEW_REFERENCES.ORG_ID,
    NEW_REFERENCES.FEE_CLASS,     --for Bug 2175865
    new_references.designated_payment_flag,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 418


end INSERT_ROW;

Line: 436


  cursor c1 is select
      HIST_END_DT,
      HIST_WHO,
      S_FEE_TYPE,
      S_FEE_TRIGGER_CAT,
      DESCRIPTION,
      OPTIONAL_PAYMENT_IND,
      CLOSED_IND,
      COMMENTS,
      FEE_CLASS,        --for Bug 2175865
      designated_payment_flag
    from IGS_FI_FEE_TYPE_HIST_ALL
    where ROWID = X_ROWID
    for update nowait;

Line: 457


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

Line: 500


procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_FEE_TYPE in VARCHAR2,
  X_HIST_START_DT in DATE,
  X_HIST_END_DT in DATE,
  X_HIST_WHO in NUMBER,
  X_S_FEE_TYPE in VARCHAR2,
  X_S_FEE_TRIGGER_CAT in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_OPTIONAL_PAYMENT_IND in VARCHAR2,
  X_CLOSED_IND in VARCHAR2,
  X_COMMENTS in VARCHAR2,
  X_MODE in VARCHAR2 ,
  X_FEE_CLASS in VARCHAR2,   --FOR BUG 2175865
  x_designated_payment_flag IN VARCHAR2
  ) AS
    X_LAST_UPDATE_DATE DATE;

Line: 517


    X_LAST_UPDATED_BY NUMBER;

Line: 518


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 520


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 522


    X_LAST_UPDATED_BY := 1;

Line: 523


    X_LAST_UPDATE_LOGIN := 0;

Line: 525


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 526


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 529


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 530


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 542


  p_action=>'UPDATE',
  x_rowid=>X_ROWID,
  x_closed_ind=>X_CLOSED_IND,
  x_comments=>X_COMMENTS,
  x_description=>X_DESCRIPTION,
  x_fee_type=>X_FEE_TYPE,
  x_hist_end_dt=>X_HIST_END_DT,
  x_hist_start_dt=>X_HIST_START_DT,
  x_fee_class =>X_FEE_CLASS,           --for Bug 2175865
  x_hist_who=>X_HIST_WHO,
  x_optional_payment_ind=>X_OPTIONAL_PAYMENT_IND,
  x_s_fee_trigger_cat=>X_S_FEE_TRIGGER_CAT,
  x_s_fee_type=>X_S_FEE_TYPE,
  x_designated_payment_flag => x_designated_payment_flag,
  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: 564


  update IGS_FI_FEE_TYPE_HIST_ALL set
    HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
    HIST_WHO = NEW_REFERENCES.HIST_WHO,
    S_FEE_TYPE = NEW_REFERENCES.S_FEE_TYPE,
    S_FEE_TRIGGER_CAT = NEW_REFERENCES.S_FEE_TRIGGER_CAT,
    DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
    OPTIONAL_PAYMENT_IND = NEW_REFERENCES.OPTIONAL_PAYMENT_IND,
    CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
    COMMENTS = NEW_REFERENCES.COMMENTS,
    FEE_CLASS = NEW_REFERENCES.FEE_CLASS,          --for Bug 2175865
    designated_payment_flag = new_references.designated_payment_flag,
    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: 583


end UPDATE_ROW;

Line: 603


  cursor c1 is select rowid from IGS_FI_FEE_TYPE_HIST_ALL
     where FEE_TYPE = X_FEE_TYPE
     and HIST_START_DT = X_HIST_START_DT
  ;

Line: 612


    INSERT_ROW (
     X_ROWID,
     X_FEE_TYPE,
     X_HIST_START_DT,
     X_HIST_END_DT,
     X_HIST_WHO,
     X_S_FEE_TYPE,
     X_S_FEE_TRIGGER_CAT,
     X_DESCRIPTION,
     X_OPTIONAL_PAYMENT_IND,
     X_CLOSED_IND,
     X_COMMENTS,
     X_ORG_ID,
     X_MODE,
     X_FEE_CLASS,      --for Bug 2175865
     x_designated_payment_flag);

Line: 631


  UPDATE_ROW (
   X_ROWID,
   X_FEE_TYPE,
   X_HIST_START_DT,
   X_HIST_END_DT,
   X_HIST_WHO,
   X_S_FEE_TYPE,
   X_S_FEE_TRIGGER_CAT,
   X_DESCRIPTION,
   X_OPTIONAL_PAYMENT_IND,
   X_CLOSED_IND,
   X_COMMENTS,
   X_MODE,
   X_FEE_CLASS,      --for Bug 2175865
   x_designated_payment_flag);

Line: 648


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

Line: 656


  delete from IGS_FI_FEE_TYPE_HIST_ALL
  where ROWID = X_ROWID;

Line: 662


end DELETE_ROW;