APPS.IGS_FI_VAL_FRTNS dependencies on IGS_FI_FEE_TYPE

Line 116: -- If IGS_FI_FEE_TYPE.s_fee_trigger_cat = 'INSTITUTN', then retention schedules

112: RETURN BOOLEAN AS
113: gv_other_detail VARCHAR2(255);
114: BEGIN -- finp_val_frtns_ft
115: -- Validate IGS_FI_FEE_RET_SCHD.FEE_TYPE.
116: -- If IGS_FI_FEE_TYPE.s_fee_trigger_cat = 'INSTITUTN', then retention schedules
117: -- can only be defined against fee_type_cal_instances. If the
118: -- IGS_FI_FEE_TYPE.optional_payment_ind
119: -- is set to 'Y' then fee retention schedules can only be set against
120: -- fee_cat_cal_instances.

Line 118: -- IGS_FI_FEE_TYPE.optional_payment_ind

114: BEGIN -- finp_val_frtns_ft
115: -- Validate IGS_FI_FEE_RET_SCHD.FEE_TYPE.
116: -- If IGS_FI_FEE_TYPE.s_fee_trigger_cat = 'INSTITUTN', then retention schedules
117: -- can only be defined against fee_type_cal_instances. If the
118: -- IGS_FI_FEE_TYPE.optional_payment_ind
119: -- is set to 'Y' then fee retention schedules can only be set against
120: -- fee_cat_cal_instances.
121: DECLARE
122: cst_institutn CONSTANT VARCHAR(10) := 'INSTITUTN';

Line 128: cp_fee_type IGS_FI_FEE_TYPE.FEE_TYPE%TYPE) IS

124: cst_ftci CONSTANT VARCHAR(5) := 'FTCI';
125: cst_fcci CONSTANT VARCHAR(5) := 'FCCI';
126: cst_yes CONSTANT CHAR := 'Y';
127: CURSOR c_ft(
128: cp_fee_type IGS_FI_FEE_TYPE.FEE_TYPE%TYPE) IS
129: SELECT s_fee_trigger_cat,
130: s_fee_type,
131: optional_payment_ind
132: FROM IGS_FI_FEE_TYPE

Line 132: FROM IGS_FI_FEE_TYPE

128: cp_fee_type IGS_FI_FEE_TYPE.FEE_TYPE%TYPE) IS
129: SELECT s_fee_trigger_cat,
130: s_fee_type,
131: optional_payment_ind
132: FROM IGS_FI_FEE_TYPE
133: WHERE FEE_TYPE = cp_fee_type;
134: v_ft_rec c_ft%ROWTYPE;
135: BEGIN
136: -- Set the default message number

Line 142: -- IGS_FI_FEE_TYPE.

138: IF (p_fee_type IS NULL) THEN
139: RETURN TRUE;
140: END IF;
141: -- Get the system fee trigger category and the optional indicator of the
142: -- IGS_FI_FEE_TYPE.
143: OPEN c_ft (p_fee_type);
144: FETCH c_ft INTO v_ft_rec;
145: IF c_ft%NOTFOUND THEN
146: CLOSE c_ft;

Line 176: p_fee_type IN IGS_FI_FEE_TYPE_ALL.FEE_TYPE%TYPE ,

172: -- Validate insert of FRTNS does not clash currency code set up with FCFL definitions
173: FUNCTION finp_val_frtns_cur(
174: p_fee_cal_type IN IGS_CA_TYPE.CAL_TYPE%TYPE ,
175: p_fee_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
176: p_fee_type IN IGS_FI_FEE_TYPE_ALL.FEE_TYPE%TYPE ,
177: p_s_relation_type IN VARCHAR2 ,
178: p_message_name OUT NOCOPY VARCHAR2 )
179: RETURN BOOLEAN AS
180: /*----------------------------------------------------------------------------