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

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

Line: 24


    x_last_update_date IN DATE ,
    x_last_updated_by IN NUMBER ,
    x_last_update_login IN NUMBER
  ) AS
/*----------------------------------------------------------------------------
  ||  Created By :
  ||  Created On :
  ||  Purpose :
  ||  Known limitations, enhancements or remarks :
  ||  Change History :
  ||  Who             When            What
  ||  (reverse chronological order - newest change first)
  ||  shtatiko        30-MAY-2003     Enh# 2831582, Added new column designated_payment_flag
  ||  smvk         02-Sep-2002        Removed the Default value in the parameters to overcome File.Pkg.22 gscc warnings.
  ||                                  As a part of Build SFCR005_Cleanup_Build (Enhancement Bug # 2531390)
  ----------------------------------------------------------------------------*/

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

Line: 55


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

Line: 57


      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: 98


  PROCEDURE BeforeRowInsertUpdateDelete1(
    p_inserting IN BOOLEAN ,
    p_updating IN BOOLEAN ,
    p_deleting IN BOOLEAN

    ) AS
  /*---------------------------------------------------------------------------
   CHANGE HISTORY:
   WHO        WHEN           WHAT
   svuppala   09-SEP-2005  Bug#3286824 Modify cursors cur_docactiveft_count and c_ft to have one cursor c_act_ft
                           Made check for DOCUMENT and REFUND once.
   vvutukur   03-Dec-2003  Bug#3249288.Modified cursor cur_optfeeflag_set to remove additional condition
                           on optional_fee_flag.
   uudayapr   15-oct-2003  Enh #3117341 Modified by adding the token to IGS_FI_ANC_TRG_CAT message
   smvk       02-Sep-2002  Removed the Default value in the parameters to overcome File.Pkg.22 gscc warnings.
                           As a part of Build SFCR005_Cleanup_Build (Enhancement Bug # 2531390)
   vvutukur   24-Jun-2002  Added cursor cur_docactiveft_count and related validation
                           to throw error message if user tries to save two active fee type
                           records with system fee type 'DOCUMENT'.
   smvk       13-Mar-2002    checking System Fee Trigger Category as INSTITUTN and
                            and only one active fee type having system fee type as
                            Refunds for a subaccount w.r.t Bug # 2144600
  ----------------------------------------------------------------------------*/

  CURSOR cur_optfeeflag_set(p_fee_type varchar2) is
         SELECT 'x'
         FROM igs_fi_inv_int
         WHERE fee_type = p_fee_type;

Line: 130


   SELECT count('x')
   FROM   igs_fi_fee_type
   WHERE  s_fee_type = cp_s_fee_type
   AND    fee_type <> cp_fee_type
   AND    closed_ind='N';

Line: 170


        IF (p_inserting OR (p_updating AND
                (((old_references.s_fee_type) <> (new_references.s_fee_type))  OR
                ((old_references.s_fee_trigger_cat) <> (new_references.s_fee_trigger_cat))))) THEN
                IF IGS_FI_VAL_FT.finp_val_ft_sft_trig (
                                new_references.s_fee_type,
                                new_references.s_fee_trigger_cat,
                                v_message_name) = FALSE THEN
                        Fnd_Message.Set_Name('IGS',v_message_name);

Line: 211


  IF (p_inserting OR (p_updating AND old_references.closed_ind <> new_references.closed_ind)) THEN

    IF new_references.s_fee_type IN ('DOCUMENT','REFUND') AND
       new_references.closed_ind='N' THEN

      OPEN cur_act_ft(cp_s_fee_type => new_references.s_fee_type,
                      cp_fee_type => new_references.fee_type);

Line: 236


    IF p_inserting OR p_updating THEN
      IF new_references.s_fee_type = 'REFUND' THEN
        IF new_references.s_fee_trigger_cat <> 'INSTITUTN' THEN
           --got the lookup meaning and added token to the
           --message IGS_FI_ANC_TRG_CAT.
           fnd_Message.Set_Name('IGS','IGS_FI_ANC_TRG_CAT');

Line: 251


  END BeforeRowInsertUpdateDelete1;

Line: 253


  PROCEDURE BeforeRowInsertUpdate2(
                                 p_inserting IN BOOLEAN ,
                                 p_updating  IN BOOLEAN ,
                                 p_deleteing IN BOOLEAN
                                 )AS

  --HISTORY
  --Who        When          What
  --smvk       02-Sep-200    Removed the Default value in the parameters to overcome File.Pkg.22 gscc warnings.
  --                         As a part of Build SFCR005_Cleanup_Build (Enhancement Bug # 2531390)
  --vvutukur   15-Jul-2002   Removed cursor cur_ft and related code as multiple fee classes can be attached to the
  --                         single subaccount that exists in the system,for bug#2432134.
  --vvutukur   15-1-2002     created the procedure for Bug 2175865


  --Cursor to check if the fee type has been used for creation of charge.
    CURSOR cur_ft_chrg(
                       cp_new_fee_type VARCHAR2
                      ) IS
      SELECT 'x'
      FROM   igs_fi_inv_int
      WHERE  fee_type = cp_new_fee_type;

Line: 295


  END BeforeRowInsertUpdate2;

Line: 303


  PROCEDURE AfterRowUpdate2(
    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)
  ||  shtatiko        30-MAY-2003     Enh# 2831582, Added new column designated_payment_flag
  ||  smvk         02-Sep-2002        Removed the Default value in the parameters to overcome File.Pkg.22 gscc warnings.
  ||                                  As a part of Build SFCR005_Cleanup_Build (Enhancement Bug # 2531390)
  ----------------------------------------------------------------------------*/

  BEGIN
        -- create a history

        IGS_FI_GEN_002.FINP_INS_FT_HIST(old_references.fee_type,
                new_references.s_fee_type,
                old_references.s_fee_type,
                new_references.s_fee_trigger_cat,
                old_references.s_fee_trigger_cat,
                new_references.description,
                old_references.description,
                new_references.optional_payment_ind,
                old_references.optional_payment_ind,
                new_references.closed_ind,
                old_references.closed_ind,
                new_references.fee_class,
                old_references.fee_class,
                new_references.designated_payment_flag,
                old_references.designated_payment_flag,
                new_references.last_updated_by,
                old_references.last_updated_by,
                new_references.last_update_date,
                old_references.last_update_date,
                new_references.comments,
                old_references.comments);

Line: 346


  END AfterRowUpdate2;

Line: 500


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

Line: 518


   SELECT   rowid
   FROM     igs_fi_fee_type_all
   WHERE    fee_type = x_fee_type ;

Line: 552


    x_last_update_date IN DATE,
    x_last_updated_by IN NUMBER,
    x_last_update_login IN NUMBER
  ) AS
  ------------------------------------------------------------------
  --Change History:
  --Who         When            What
  --shtatiko    30-MAY-2003     Enh# 2831582, Added new column designated_payment_flag
  --pathipat    11-Feb-2003     Enh 2747325 - Locking Issues build
  --                            Removed code for p_action = 'DELETE' and
  --                            'VALIDATE_DELETE'
  -------------------------------------------------------------------

  BEGIN

    Set_Column_Values (
      p_action,
      x_rowid,
      x_fee_type,
      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,          --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: 587


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

Line: 598


      BeforeRowInsertUpdate2 ( p_inserting => TRUE, p_updating => FALSE, p_deleteing =>FALSE);

Line: 601


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

Line: 606


      BeforeRowInsertUpdate2 ( p_inserting => FALSE, p_updating => TRUE, p_deleteing =>FALSE);

Line: 610


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

Line: 618


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
                 Check_Constraints;

Line: 638


    IF (p_action = 'UPDATE') THEN

      -- Call all the procedures related to After Update.

      AfterRowUpdate2 (p_inserting => FALSE, p_updating => TRUE, p_deleting => FALSE);

Line: 648


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_FEE_TYPE in VARCHAR2,
  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_ORG_ID in NUMBER,
  X_FEE_CLASS  in VARCHAR2,       --Bug 2175865
  X_DESIGNATED_PAYMENT_FLAG IN VARCHAR2
  ) AS
    cursor C is select ROWID from IGS_FI_FEE_TYPE_ALL
      where FEE_TYPE = X_FEE_TYPE;

Line: 664


    X_LAST_UPDATE_DATE DATE;

Line: 665


    X_LAST_UPDATED_BY NUMBER;

Line: 666


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 668


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 670


    X_LAST_UPDATED_BY := 1;

Line: 671


    X_LAST_UPDATE_LOGIN := 0;

Line: 673


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 674


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 677


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 678


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 690


  p_action=>'INSERT',
  x_rowid=>X_ROWID,
  x_closed_ind=>NVL(X_CLOSED_IND,'N'),
  x_comments=>X_COMMENTS,
  x_description=>X_DESCRIPTION,
  x_fee_type=>X_FEE_TYPE,
  x_optional_payment_ind=>NVL(X_OPTIONAL_PAYMENT_IND,'N'),
  x_s_fee_trigger_cat=>NVL(X_S_FEE_TRIGGER_CAT,'INSTITUTN'),
  x_s_fee_type=>NVL(X_S_FEE_TYPE,'OTHER'),
  x_org_id => igs_ge_gen_003.get_org_id,
  x_fee_class => X_FEE_CLASS,            --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: 709


  insert into IGS_FI_FEE_TYPE_ALL (
    FEE_TYPE,
    S_FEE_TYPE,
    S_FEE_TRIGGER_CAT,
    DESCRIPTION,
    OPTIONAL_PAYMENT_IND,
    CLOSED_IND,
    COMMENTS,
    ORG_ID,
    FEE_CLASS,            --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.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,         --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: 751


end INSERT_ROW;

Line: 766


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

Line: 784


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

Line: 816


procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_FEE_TYPE in VARCHAR2,
  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,        --Bug 2175865
  X_DESIGNATED_PAYMENT_FLAG IN VARCHAR2
  ) is
    X_LAST_UPDATE_DATE DATE;

Line: 830


    X_LAST_UPDATED_BY NUMBER;

Line: 831


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 833


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 835


    X_LAST_UPDATED_BY := 1;

Line: 836


    X_LAST_UPDATE_LOGIN := 0;

Line: 838


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 839


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 842


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 843


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 855


  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_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_fee_class => X_FEE_CLASS,             --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: 874


  update IGS_FI_FEE_TYPE_ALL set
    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,           --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: 894


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

Line: 897


END update_row;

Line: 914


  CURSOR c1 is SELECT rowid FROM igs_fi_fee_type_all
     WHERE FEE_TYPE = X_FEE_TYPE
  ;

Line: 922


    INSERT_ROW (
     X_ROWID,
     X_FEE_TYPE,
     X_S_FEE_TYPE,
     X_S_FEE_TRIGGER_CAT,
     X_DESCRIPTION,
     X_OPTIONAL_PAYMENT_IND,
     X_CLOSED_IND,
     X_COMMENTS,
     X_MODE,
     X_ORG_ID,
     X_FEE_CLASS,       --Bug 2175865
     X_DESIGNATED_PAYMENT_FLAG );

Line: 938


  UPDATE_ROW (
  X_ROWID,
   X_FEE_TYPE,
   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,      --Bug 2175865
   X_DESIGNATED_PAYMENT_FLAG );