APPS.IGS_FI_VAL_FTCI SQL Statements

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

Line: 5

pmarada      28-jul-2005              Enh 3392095, Added waiver_calc_flag cloumn to the IGS_FI_F_CAT_FEE_LBL_Pkg.Update_Row
shtatiko     04-FEB-2004              Enh# 3167098, Removed validation of Retro Date Alias from finp_val_ftci_dates.
vvutukur     29-Jul-2002              Bug#2425767. Removed payment_hierarchy_rank column references as this
                                      is obsoleted(from call to IGS_FI_F_CAT_FEE_LBL_Pkg.Update_Row in
				      FUNCTION finp_upd_fcfl_status.Removed function finp_val_ftci_rank
				      as this function validates payment_hierarchy_rank,an obsoleted column.)
vchappid     25-Apr-2002              Bug# 2329407, Removed the parameters account_cd, fin_cal_type
                                      and fin_ci_sequence_number from the function call finp_val_ftci_rqrd

vchappid     04-Feb-2002            As per Enh#2187247, procedure finp_val_ftci_rqrd is modofied to include new validations
*/

 /* Bug 1966961
    Who schodava
    When 5 Sept,2001
    What Obsolete the account code link with Financial Calendar
 */
 /* Bug 1956374
    Who msrinivi
    When 25 Aug,2001
    What Duplicate code removal finp_val_ft_closed
 */

 /*  Who          When                     What
     vivuyyur     10-sep-2001		   Bug No :1966961
                                           PROCEDURE finp_val_ftci_ac is changed  */
  -- Validate the IGS_FI_ACC has the correct calendar relations.
  FUNCTION finp_val_ftci_ac(
  p_fee_cal_type IN VARCHAR2 ,
  p_fee_ci_sequence_number IN NUMBER ,
  p_message_name OUT NOCOPY VARCHAR2 )
  RETURN BOOLEAN AS
  	gv_other_detail		VARCHAR2(255);

Line: 44

  		SELECT	sub_cal_type
  		FROM	IGS_CA_INST_REL
  		WHERE	sub_cal_type		= p_fee_cal_type		AND
  			sub_ci_sequence_number	= p_fee_ci_sequence_number ;

Line: 84

  		SELECT	cir.sub_cal_type
  		FROM	IGS_CA_INST_REL	cir
  		WHERE	cir.sub_cal_type = p_fee_cal_type AND
  			cir.sub_ci_sequence_number = p_fee_ci_sequence_number AND
  			cir.sup_cal_type IN (	SELECT	ct.CAL_TYPE
  						FROM	IGS_CA_TYPE	ct
  						WHERE	ct.CAL_TYPE = cir.sup_cal_type AND
  							ct.S_CAL_CAT = cst_cal_cat AND
  							ct.closed_ind = 'N');

Line: 136

  		SELECT	fss.s_fee_structure_status
  		FROM	IGS_FI_FEE_STR_STAT	fss
  		WHERE	fss.fee_structure_status = p_fee_type_ci_status;

Line: 140

 		SELECT	fcfl.*, fcfl.rowid  -- kdande -> rowid was added to make a call to Update_Row TBH.
  		FROM	IGS_FI_F_CAT_FEE_LBL	fcfl
  		WHERE	fcfl.fee_cal_type = p_fee_cal_type AND
  			fcfl.fee_ci_sequence_number = p_fee_ci_sequence_number AND
  			fcfl.fee_type =p_fee_type
  		FOR UPDATE OF fcfl.fee_liability_status NOWAIT;

Line: 149

  	-- to 'INACTIVE' update the IGS_FI_F_CAT_FEE_LBL.fee_liability_status
  	-- in related records to 'INACTIVE'.
  	p_message_name := NULL;

Line: 160

  	-- 2. Update any related IGS_FI_F_CAT_FEE_LBL records.
  	OPEN c_fcfl;

Line: 163

   		FETCH c_fcfl INTO fcfl_rec; -- kdande -> Added fcfl_rec for use in Update_Row DML.

Line: 170

      		IGS_FI_F_CAT_FEE_LBL_Pkg.Update_Row (
        		x_rowid => fcfl_rec.rowid,
        		x_fee_cat => fcfl_rec.fee_cat,
        		x_fee_ci_sequence_number => fcfl_rec.fee_ci_sequence_number,
        		x_fee_type => fcfl_rec.fee_type,
        		x_fee_cal_type => fcfl_rec.fee_cal_type,
        		x_fee_liability_status => p_fee_type_ci_status,
        		x_start_dt_alias => fcfl_rec.start_dt_alias,
        		x_start_dai_sequence_number => fcfl_rec.start_dai_sequence_number,
        		x_s_chg_method_type => fcfl_rec.s_chg_method_type,
        		x_rul_sequence_number => fcfl_rec.rul_sequence_number,
                        x_waiver_calc_flag => fcfl_rec.waiver_calc_flag
      			);

Line: 215

  		SELECT	ft.s_fee_type
  		FROM	IGS_FI_FEE_TYPE	ft
  		WHERE	ft.fee_type = p_fee_type;

Line: 260

  		SELECT	daiv.alias_val
  		FROM	IGS_CA_DA_INST_V	daiv
  		WHERE	daiv.CAL_TYPE = p_fee_cal_type AND
  			daiv.ci_sequence_number = p_fee_ci_sequence_number AND
  			daiv.DT_ALIAS = cp_dt_alias AND
  			daiv.sequence_number = cp_dai_sequence_number;

Line: 358

  		SELECT	fss.s_fee_structure_status
  		FROM	IGS_FI_FEE_STR_STAT	fss
  		WHERE	fss.fee_structure_status = cp_fee_type_ci_status;

Line: 362

  		SELECT	ft.s_fee_type,
  			ft.s_fee_trigger_cat
  		FROM	IGS_FI_FEE_TYPE	ft
  		WHERE	ft.fee_type = p_fee_type;

Line: 367

  		SELECT	fcfl.fee_type
  		FROM	IGS_FI_F_CAT_FEE_LBL	fcfl
  		WHERE	fcfl.fee_type = p_fee_type AND
  			fcfl.fee_cal_type = p_fee_cal_type AND
  			fcfl.fee_ci_sequence_number = p_fee_ci_sequence_number;

Line: 373

  		SELECT	cs.s_cal_status,
  			ct.S_CAL_CAT
  		FROM	IGS_CA_INST	ci,
  			IGS_CA_TYPE	ct,
  			IGS_CA_STAT	cs
  		WHERE	ci.CAL_TYPE	= p_fee_cal_type	AND
  			ci.sequence_number = p_fee_ci_sequence_number AND
  			ci.CAL_TYPE		= ct.CAL_TYPE		AND
  			ci.CAL_STATUS		= cs.CAL_STATUS;

Line: 399

        SELECT s.s_cal_status
        FROM   igs_ca_inst i,
               igs_ca_stat s
        WHERE  s.cal_status = i.cal_status
        AND    i.cal_type = cp_load_cal_type
        AND    i.sequence_number = cp_load_cal_seq_num;

Line: 469

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

Line: 496

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

Line: 552

  		SELECT	fss.s_fee_structure_status
  		FROM	IGS_FI_FEE_STR_STAT	fss
  		WHERE	fss.fee_structure_status = cp_ftci_status;

Line: 556

  		SELECT	fcfl.fee_type
  		FROM	IGS_FI_F_CAT_FEE_LBL	fcfl
  		WHERE	fcfl.fee_type = p_fee_type AND
  			fcfl.fee_cal_type = p_fee_cal_type AND
  			fcfl.fee_ci_sequence_number = p_fee_ci_sequence_number;

Line: 562

  		SELECT	fcfl.fee_type
  		FROM	IGS_FI_F_CAT_FEE_LBL		fcfl,
  			IGS_FI_FEE_STR_STAT	fss
  		WHERE	fcfl.fee_type = p_fee_type AND
  			fcfl.fee_cal_type = p_fee_cal_type AND
  			fcfl.fee_ci_sequence_number = p_fee_ci_sequence_number AND
  			fcfl.fee_liability_status = fss.fee_structure_status AND
  			fss.s_fee_structure_status = cst_active;