APPS.IGS_EN_VAL_USFT dependencies on IGS_FI_FEE_TYPE

Line 19: -- Validate IGS_EN_UNITSETFEETRG IGS_FI_FEE_TYPE.s_fee_trigger_cat = UNITSET or COMPOSITE

15:
16:
17: BEGIN -- finp_val_usft_ins
18:
19: -- Validate IGS_EN_UNITSETFEETRG IGS_FI_FEE_TYPE.s_fee_trigger_cat = UNITSET or COMPOSITE
20:
21: -- otherwise IGS_PS_UNIT set fee triggers cannot be defined.
22:
23: DECLARE

Line 27: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS

23: DECLARE
24:
25: CURSOR c_ft(
26:
27: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS
28:
29: SELECT s_fee_trigger_cat
30:
31: FROM IGS_FI_FEE_TYPE

Line 31: FROM IGS_FI_FEE_TYPE

27: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS
28:
29: SELECT s_fee_trigger_cat
30:
31: FROM IGS_FI_FEE_TYPE
32:
33: WHERE fee_type = cp_fee_type;
34:
35: v_ft_rec c_ft%ROWTYPE;

Line 55: -- Get the system fee trigger category of the IGS_FI_FEE_TYPE.

51: RETURN TRUE;
52:
53: END IF;
54:
55: -- Get the system fee trigger category of the IGS_FI_FEE_TYPE.
56:
57: OPEN c_ft (p_fee_type);
58:
59: FETCH c_ft INTO v_ft_rec;

Line 103: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,

99: -- Validate IGS_PS_UNIT set fee trigger can belong to a fee trigger group.
100:
101: FUNCTION finp_val_usft_ftg(
102:
103: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
104:
105: p_fee_trigger_group_num IN NUMBER ,
106:
107: p_message_name OUT NOCOPY VARCHAR2)

Line 121: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS

117: DECLARE
118:
119: CURSOR c_ft(
120:
121: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS
122:
123: SELECT s_fee_trigger_cat
124:
125: FROM IGS_FI_FEE_TYPE

Line 125: FROM IGS_FI_FEE_TYPE

121: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS
122:
123: SELECT s_fee_trigger_cat
124:
125: FROM IGS_FI_FEE_TYPE
126:
127: WHERE fee_type = cp_fee_type;
128:
129: v_ft_rec c_ft%ROWTYPE;

Line 145: -- Get the system fee trigger category of the IGS_FI_FEE_TYPE.

141: RETURN TRUE;
142:
143: END IF;
144:
145: -- Get the system fee trigger category of the IGS_FI_FEE_TYPE.
146:
147: OPEN c_ft (p_fee_type);
148:
149: FETCH c_ft INTO v_ft_rec;