APPS.IGS_FI_VAL_ERR dependencies on IGS_FI_ELM_RANGE_RT

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 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 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