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

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

Line: 25


    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_F_CAT_CA_INST
      WHERE    rowid = x_rowid;

Line: 39


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

Line: 41


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

Line: 58


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

Line: 65


    new_references.last_update_date := x_last_update_date;

Line: 66


    new_references.last_updated_by := x_last_updated_by;

Line: 67


    new_references.last_update_login := x_last_update_login;

Line: 73


  PROCEDURE BeforeRowInsertUpdateDelete1(
    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)
  ||  vvutukur     02-Sep-2002     Bug#2531390. Removed DEFAULT from parameters to avoid gscc warnings.
  ----------------------------------------------------------------------------*/
	v_message_name varchar2(30);

Line: 91


	IF p_inserting THEN
		IF IGS_FI_VAL_FCCI.finp_val_ci_fee (
					new_references.fee_cal_type,
					new_references.fee_ci_sequence_number,
					v_message_name) = FALSE THEN
			Fnd_Message.Set_Name('IGS',v_message_name);

Line: 102


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

Line: 133


	IF (p_inserting OR ((old_references.start_dt_alias) <> (new_references.start_dt_alias) OR
		                (old_references.end_dt_alias) <> (new_references.end_dt_alias) OR
		                (old_references.retro_dt_alias) <> (new_references.retro_dt_alias))) THEN
		IF IGS_FI_VAL_FCCI.finp_val_fcci_dates (
					new_references.fee_cal_type,
					new_references.fee_ci_sequence_number,
					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,
					v_message_name) = FALSE THEN
			Fnd_Message.Set_Name('IGS',v_message_name);

Line: 151


  END BeforeRowInsertUpdateDelete1;

Line: 156


  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)
  ||  vvutukur     02-Sep-2002     Bug#2531390. Removed DEFAULT from parameters to avoid gscc warnings.
  ----------------------------------------------------------------------------*/
  BEGIN
	-- create a history
	IGS_FI_GEN_002.FINP_INS_FCCI_HIST(old_references.fee_cat,
		old_references.fee_cal_type,
		old_references.fee_ci_sequence_number,
		new_references.fee_cat_ci_status,
		old_references.fee_cat_ci_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.end_dt_alias,
		old_references.end_dt_alias,
		new_references.end_dai_sequence_number,
		old_references.end_dai_sequence_number,
		new_references.retro_dt_alias,
		old_references.retro_dt_alias,
		new_references.retro_dai_sequence_number,
		old_references.retro_dai_sequence_number,
		new_references.last_updated_by,
		old_references.last_updated_by,
		new_references.last_update_date,
		old_references.last_update_date);

Line: 194


  END AfterRowUpdate2;

Line: 306


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

Line: 321


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

Line: 342


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

Line: 354


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

Line: 366


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

Line: 387


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

Line: 430


      SELECT   rowid
      FROM     IGS_FI_F_CAT_CA_INST
      WHERE    fee_cat = x_fee_cat
      AND      fee_cal_type = x_fee_cal_type
      AND      fee_ci_sequence_number = x_fee_ci_sequence_number
      FOR UPDATE NOWAIT;

Line: 455


      SELECT   rowid
      FROM     IGS_FI_F_CAT_CA_INST
      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)
      OR       (end_dt_alias = x_dt_alias
      AND      end_dai_sequence_number = x_sequence_number
      AND      fee_cal_type = x_cal_type
      AND      Fee_ci_sequence_number = x_ci_sequence_number);

Line: 483


      SELECT   rowid
      FROM     IGS_FI_F_CAT_CA_INST
      WHERE    fee_cal_type = x_cal_type
      AND      fee_ci_sequence_number = x_sequence_number ;

Line: 504


      SELECT   rowid
      FROM     IGS_FI_F_CAT_CA_INST
      WHERE    fee_cat = x_fee_cat ;

Line: 524


      SELECT   rowid
      FROM     IGS_FI_F_CAT_CA_INST
      WHERE    fee_cat_ci_status = x_fee_structure_status ;

Line: 555


    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)
  || vvutukur    02-Sep-2002 Bug#2531390. Modified the calls to procedure BeforeRowInsertUpdateDelete1
  ||                         to pass FALSE for the parameters which were defaulting to false in that
  ||                         procedure previously. This is done because we removed DEFAULT from package
  ||                         body to avoid gscc warning.
  ----------------------------------------------------------------------------*/
  BEGIN
    Set_Column_Values (
      p_action,
      x_rowid,
      x_fee_cat,
      x_fee_cal_type,
      x_fee_ci_sequence_number,
      x_fee_cat_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_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 592


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

Line: 608


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

Line: 615


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

Line: 621


    ELSIF (p_action = 'VALIDATE_INSERT') THEN
      IF (Get_PK_For_Validation (
            new_references.fee_cat,
            new_references.fee_cal_type,
            new_references.fee_ci_sequence_number
            )) THEN
        Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

Line: 632


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      Check_Constraints;

Line: 634


    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      Check_Child_Existance;

Line: 650


  ||  VVUTUKUR      02-Sep-2002   Bug#2531390. Modified call to afterrowupdate2 and provided FALSE
  ||                              for the parameters which used to default to FALSE in that procedure
  ||                              previously.Done because the DEFAULT is removed from package body
  ||                              due to gscc warning.
  ----------------------------------------------------------------------------*/
  BEGIN
    l_rowid := x_rowid;

Line: 657


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

Line: 664


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_FEE_CAT in VARCHAR2,
  X_FEE_CAL_TYPE in VARCHAR2,
  X_FEE_CI_SEQUENCE_NUMBER in NUMBER,
  X_FEE_CAT_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_MODE in VARCHAR2
  ) as
    cursor C is select ROWID from IGS_FI_F_CAT_CA_INST
      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: 682


    X_LAST_UPDATE_DATE DATE;

Line: 683


    X_LAST_UPDATED_BY NUMBER;

Line: 684


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 688


    X_PROGRAM_UPDATE_DATE DATE;

Line: 690


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 692


    X_LAST_UPDATED_BY := 1;

Line: 693


    X_LAST_UPDATE_LOGIN := 0;

Line: 695


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 696


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 699


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 700


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 710


      X_PROGRAM_UPDATE_DATE:=NULL;

Line: 712


      X_PROGRAM_UPDATE_DATE:=SYSDATE;

Line: 720


 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_cat=>X_FEE_CAT,
 x_fee_cat_ci_status=>X_FEE_CAT_CI_STATUS,
 x_fee_ci_sequence_number=>X_FEE_CI_SEQUENCE_NUMBER,
 x_retro_dai_sequence_number=>X_RETRO_DAI_SEQUENCE_NUMBER,
 x_retro_dt_alias=>X_RETRO_DT_ALIAS,
 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
);

Line: 738


  insert into IGS_FI_F_CAT_CA_INST (
    FEE_CAT,
    FEE_CAL_TYPE,
    FEE_CI_SEQUENCE_NUMBER,
    FEE_CAT_CI_STATUS,
    START_DT_ALIAS,
    START_DAI_SEQUENCE_NUMBER,
    END_DT_ALIAS,
    END_DAI_SEQUENCE_NUMBER,
    RETRO_DT_ALIAS,
    RETRO_DAI_SEQUENCE_NUMBER,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    REQUEST_ID,
    PROGRAM_ID,
    PROGRAM_APPLICATION_ID,
    PROGRAM_UPDATE_DATE
  ) values (
    NEW_REFERENCES.FEE_CAT,
    NEW_REFERENCES.FEE_CAL_TYPE,
    NEW_REFERENCES.FEE_CI_SEQUENCE_NUMBER,
    NEW_REFERENCES.FEE_CAT_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,
    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
  );

Line: 787


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

Line: 790


end INSERT_ROW;

Line: 804


  cursor c1 is select
      FEE_CAT_CI_STATUS,
      START_DT_ALIAS,
      START_DAI_SEQUENCE_NUMBER,
      END_DT_ALIAS,
      END_DAI_SEQUENCE_NUMBER,
      RETRO_DT_ALIAS,
      RETRO_DAI_SEQUENCE_NUMBER
    from IGS_FI_F_CAT_CA_INST
    where ROWID=X_ROWID
    for update nowait;

Line: 821


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

Line: 847


procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_FEE_CAT in VARCHAR2,
  X_FEE_CAL_TYPE in VARCHAR2,
  X_FEE_CI_SEQUENCE_NUMBER in NUMBER,
  X_FEE_CAT_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_MODE in VARCHAR2
  ) as
    X_LAST_UPDATE_DATE DATE;

Line: 862


    X_LAST_UPDATED_BY NUMBER;

Line: 863


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 867


    X_PROGRAM_UPDATE_DATE DATE;

Line: 869


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 871


    X_LAST_UPDATED_BY := 1;

Line: 872


    X_LAST_UPDATE_LOGIN := 0;

Line: 874


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 875


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 878


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 879


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 889


      X_PROGRAM_UPDATE_DATE:=OLD_REFERENCES.PROGRAM_UPDATE_DATE;

Line: 891


      X_PROGRAM_UPDATE_DATE:=SYSDATE;

Line: 899


 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_cat=>X_FEE_CAT,
 x_fee_cat_ci_status=>X_FEE_CAT_CI_STATUS,
 x_fee_ci_sequence_number=>X_FEE_CI_SEQUENCE_NUMBER,
 x_retro_dai_sequence_number=>X_RETRO_DAI_SEQUENCE_NUMBER,
 x_retro_dt_alias=>X_RETRO_DT_ALIAS,
 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
);

Line: 917


  update IGS_FI_F_CAT_CA_INST set
    FEE_CAT_CI_STATUS = NEW_REFERENCES.FEE_CAT_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,
    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
  where ROWID=X_ROWID
  ;

Line: 938


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

Line: 941


end UPDATE_ROW;

Line: 956


  cursor c1 is select rowid from IGS_FI_F_CAT_CA_INST
     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: 966


    INSERT_ROW (
     X_ROWID,
     X_FEE_CAT,
     X_FEE_CAL_TYPE,
     X_FEE_CI_SEQUENCE_NUMBER,
     X_FEE_CAT_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_MODE);

Line: 982


  UPDATE_ROW (
   X_ROWID,
   X_FEE_CAT,
   X_FEE_CAL_TYPE,
   X_FEE_CI_SEQUENCE_NUMBER,
   X_FEE_CAT_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_MODE);

Line: 996


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

Line: 1004


  delete from IGS_FI_F_CAT_CA_INST
  where ROWID=X_ROWID;

Line: 1010


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

Line: 1013


end DELETE_ROW;