APPS.IGS_EN_VAL_USFT dependencies on IGS_EN_UNITSETFEETRG

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 115: -- Validate IGS_EN_UNITSETFEETRG can belong to a IGS_FI_FEE_TRG_GRP

111: gv_other_detail VARCHAR2(255);
112:
113: BEGIN -- finp_val_usft_ftg
114:
115: -- Validate IGS_EN_UNITSETFEETRG can belong to a IGS_FI_FEE_TRG_GRP
116:
117: DECLARE
118:
119: CURSOR c_ft(

Line 185: -- Ensure only one open IGS_EN_UNITSETFEETRG record exists.

181: END finp_val_usft_ftg;
182:
183: --
184:
185: -- Ensure only one open IGS_EN_UNITSETFEETRG record exists.
186:
187: FUNCTION finp_val_usft_open(
188:
189: p_fee_cat IN IGS_EN_UNITSETFEETRG.fee_cat%TYPE ,

Line 189: p_fee_cat IN IGS_EN_UNITSETFEETRG.fee_cat%TYPE ,

185: -- Ensure only one open IGS_EN_UNITSETFEETRG record exists.
186:
187: FUNCTION finp_val_usft_open(
188:
189: p_fee_cat IN IGS_EN_UNITSETFEETRG.fee_cat%TYPE ,
190:
191: p_fee_cal_type IN IGS_EN_UNITSETFEETRG.fee_cal_type%TYPE ,
192:
193: p_fee_ci_sequence_number IN NUMBER ,

Line 191: p_fee_cal_type IN IGS_EN_UNITSETFEETRG.fee_cal_type%TYPE ,

187: FUNCTION finp_val_usft_open(
188:
189: p_fee_cat IN IGS_EN_UNITSETFEETRG.fee_cat%TYPE ,
190:
191: p_fee_cal_type IN IGS_EN_UNITSETFEETRG.fee_cal_type%TYPE ,
192:
193: p_fee_ci_sequence_number IN NUMBER ,
194:
195: p_fee_type IN IGS_EN_UNITSETFEETRG.fee_type%TYPE ,

Line 195: p_fee_type IN IGS_EN_UNITSETFEETRG.fee_type%TYPE ,

191: p_fee_cal_type IN IGS_EN_UNITSETFEETRG.fee_cal_type%TYPE ,
192:
193: p_fee_ci_sequence_number IN NUMBER ,
194:
195: p_fee_type IN IGS_EN_UNITSETFEETRG.fee_type%TYPE ,
196:
197: p_unit_set_cd IN IGS_EN_UNITSETFEETRG.unit_set_cd%TYPE ,
198:
199: p_version_number IN IGS_EN_UNITSETFEETRG.version_number%TYPE ,

Line 197: p_unit_set_cd IN IGS_EN_UNITSETFEETRG.unit_set_cd%TYPE ,

193: p_fee_ci_sequence_number IN NUMBER ,
194:
195: p_fee_type IN IGS_EN_UNITSETFEETRG.fee_type%TYPE ,
196:
197: p_unit_set_cd IN IGS_EN_UNITSETFEETRG.unit_set_cd%TYPE ,
198:
199: p_version_number IN IGS_EN_UNITSETFEETRG.version_number%TYPE ,
200:
201: p_create_dt IN IGS_EN_UNITSETFEETRG.create_dt%TYPE ,

Line 199: p_version_number IN IGS_EN_UNITSETFEETRG.version_number%TYPE ,

195: p_fee_type IN IGS_EN_UNITSETFEETRG.fee_type%TYPE ,
196:
197: p_unit_set_cd IN IGS_EN_UNITSETFEETRG.unit_set_cd%TYPE ,
198:
199: p_version_number IN IGS_EN_UNITSETFEETRG.version_number%TYPE ,
200:
201: p_create_dt IN IGS_EN_UNITSETFEETRG.create_dt%TYPE ,
202:
203: p_fee_trigger_group_number IN NUMBER ,

Line 201: p_create_dt IN IGS_EN_UNITSETFEETRG.create_dt%TYPE ,

197: p_unit_set_cd IN IGS_EN_UNITSETFEETRG.unit_set_cd%TYPE ,
198:
199: p_version_number IN IGS_EN_UNITSETFEETRG.version_number%TYPE ,
200:
201: p_create_dt IN IGS_EN_UNITSETFEETRG.create_dt%TYPE ,
202:
203: p_fee_trigger_group_number IN NUMBER ,
204:
205: p_message_name OUT NOCOPY VARCHAR2)

Line 213: -- Validate that there are no other "open" IGS_EN_UNITSETFEETRG records for

209:
210:
211: BEGIN -- finp_val_usft_open
212:
213: -- Validate that there are no other "open" IGS_EN_UNITSETFEETRG records for
214:
215: -- the nominated unit_set_cd details and the same parent IGS_FI_F_CAT_FEE_LBL.
216:
217: DECLARE

Line 223: FROM IGS_EN_UNITSETFEETRG usft

219: CURSOR c_usft IS
220:
221: SELECT 'x'
222:
223: FROM IGS_EN_UNITSETFEETRG usft
224:
225: WHERE usft.fee_cat = p_fee_cat AND
226:
227: usft.fee_cal_type = p_fee_cal_type AND