APPS.IGS_FI_VAL_ERR dependencies on IGS_FI_FEE_AS_RATE

Line 18: -- Unable to be created if the IGS_FI_ELM_RANGE or IGS_FI_FEE_AS_RATE

14: RETURN BOOLEAN AS
15: gv_other_detail VARCHAR2(255);
16: BEGIN -- finp_val_err_create
17: -- Validate that the IGS_FI_ELM_RANGE_RT record can be created.
18: -- Unable to be created if the IGS_FI_ELM_RANGE or IGS_FI_FEE_AS_RATE
19: -- records it is based on, are logically deleted.
20: DECLARE
21: CURSOR c_er IS
22: SELECT 'x'

Line 33: FROM IGS_FI_FEE_AS_RATE far

29: er.range_number = p_range_number AND
30: er.logical_delete_dt IS NOT NULL;
31: CURSOR c_far IS
32: SELECT 'x'
33: FROM IGS_FI_FEE_AS_RATE far
34: WHERE far.fee_type = p_fee_type AND
35: far.fee_cal_type = p_fee_cal_type AND
36: far.fee_ci_sequence_number = p_fee_ci_sequence_number AND
37: far.s_relation_type = p_s_relation_type AND

Line 64: -- 3. Check that the parent IGS_FI_FEE_AS_RATE record is not logically deleted

60: p_message_name := 'IGS_FI_ELERNG_RATE_NOTCREATED';
61: RETURN FALSE;
62: END IF;
63: CLOSE c_er;
64: -- 3. Check that the parent IGS_FI_FEE_AS_RATE record is not logically deleted
65: OPEN c_far;
66: FETCH c_far INTO v_far_exists;
67: IF c_far%FOUND THEN
68: CLOSE c_far;

Line 152: -- validate IGS_FI_ELM_RANGE_RT records can only be matched to a IGS_FI_FEE_AS_RATE

148: p_message_name OUT NOCOPY VARCHAR2 )
149: RETURN BOOLEAN AS
150: gv_other_detail VARCHAR2(255);
151: BEGIN -- finp_val_err_ins
152: -- validate IGS_FI_ELM_RANGE_RT records can only be matched to a IGS_FI_FEE_AS_RATE
153: -- defined at
154: -- the same level as the IGS_FI_ELM_RANGE on which it is based
155: DECLARE
156: CURSOR c_far IS

Line 158: FROM IGS_FI_FEE_AS_RATE far

154: -- the same level as the IGS_FI_ELM_RANGE on which it is based
155: DECLARE
156: CURSOR c_far IS
157: SELECT far.rate_number
158: FROM IGS_FI_FEE_AS_RATE far
159: WHERE far.fee_type = p_fee_type AND
160: far.fee_cal_type = p_fee_cal_type AND
161: far.fee_ci_sequence_number = p_fee_ci_sequence_number AND
162: far.s_relation_type = p_s_relation_type AND