APPS.IGS_FI_VAL_ERR dependencies on IGS_FI_ELM_RANGE

Line 17: -- Validate that the IGS_FI_ELM_RANGE_RT record can be created.

13: p_message_name OUT NOCOPY VARCHAR2 )
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

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 23: FROM IGS_FI_ELM_RANGE er

19: -- records it is based on, are logically deleted.
20: DECLARE
21: CURSOR c_er IS
22: SELECT 'x'
23: FROM IGS_FI_ELM_RANGE er
24: WHERE er.fee_type = p_fee_type AND
25: er.fee_cal_type = p_fee_cal_type AND
26: er.fee_ci_sequence_number = p_fee_ci_sequence_number AND
27: er.s_relation_type = p_s_relation_type AND

Line 55: -- 2. Check that the parent IGS_FI_ELM_RANGE record is not logically deleted

51: p_range_number IS NULL OR
52: p_rate_number IS NULL THEN
53: RETURN TRUE;
54: END IF;
55: -- 2. Check that the parent IGS_FI_ELM_RANGE record is not logically deleted
56: OPEN c_er;
57: FETCH c_er INTO v_er_exists;
58: IF c_er%FOUND THEN
59: CLOSE c_er;

Line 102: -- for the nominated IGS_FI_ELM_RANGE record

98: RETURN BOOLEAN AS
99: gv_other_detail VARCHAR2(255);
100: BEGIN -- finp_val_err_active
101: -- Validate that there are no other "open-ended" element_range_rate records
102: -- for the nominated IGS_FI_ELM_RANGE record
103: DECLARE
104: v_err_exists CHAR;
105: v_ret_val BOOLEAN DEFAULT TRUE;
106: CURSOR c_err IS

Line 108: FROM IGS_FI_ELM_RANGE_RT err

104: v_err_exists CHAR;
105: v_ret_val BOOLEAN DEFAULT TRUE;
106: CURSOR c_err IS
107: SELECT 'x'
108: FROM IGS_FI_ELM_RANGE_RT err
109: WHERE err.fee_type = p_fee_type AND
110: err.fee_cal_type = p_fee_cal_type AND
111: err.fee_ci_sequence_number = p_fee_ci_sequence_number AND
112: err.s_relation_type = p_s_relation_type AND

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 154: -- the same level as the IGS_FI_ELM_RANGE on which it is based

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
157: SELECT far.rate_number
158: FROM IGS_FI_FEE_AS_RATE far

Line 165: v_rate_number IGS_FI_ELM_RANGE_RT.rate_number%TYPE;

161: far.fee_ci_sequence_number = p_fee_ci_sequence_number AND
162: far.s_relation_type = p_s_relation_type AND
163: far.rate_number = p_rate_number AND
164: far.logical_delete_dt IS NULL;
165: v_rate_number IGS_FI_ELM_RANGE_RT.rate_number%TYPE;
166: BEGIN
167: --- Set the default message number
168: p_message_name := Null;
169: IF p_fee_type IS NULL OR