APPS.IGS_FI_VAL_FC dependencies on IGS_FI_F_CAT_FEE_LBL

Line 68: -- Check if IGS_FI_F_CAT_FEE_LBL records exist for the IGS_FI_FEE_CAT,

64: p_message_name OUT NOCOPY VARCHAR2 )
65: RETURN BOOLEAN AS
66: gv_other_detail VARCHAR2(255);
67: BEGIN -- finp_chk_rates_exist
68: -- Check if IGS_FI_F_CAT_FEE_LBL records exist for the IGS_FI_FEE_CAT,
69: -- which have associated IGS_FI_FEE_AS_RATE records.
70: DECLARE
71: cst_fcfl CONSTANT VARCHAR2(5) := 'FCFL';
72: CURSOR c_fcfl(

Line 77: FROM IGS_FI_F_CAT_FEE_LBL

73: cp_fee_cat IGS_FI_FEE_CAT.fee_cat%TYPE) IS
74: SELECT fee_cal_type,
75: fee_ci_sequence_number,
76: FEE_TYPE
77: FROM IGS_FI_F_CAT_FEE_LBL
78: WHERE fee_cat = cp_fee_cat;
79: CURSOR c_far(
80: cp_fee_type IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE,
81: cp_fee_cal_type IGS_FI_F_CAT_FEE_LBL.fee_cal_type%TYPE,

Line 80: cp_fee_type IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE,

76: FEE_TYPE
77: FROM IGS_FI_F_CAT_FEE_LBL
78: WHERE fee_cat = cp_fee_cat;
79: CURSOR c_far(
80: cp_fee_type IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE,
81: cp_fee_cal_type IGS_FI_F_CAT_FEE_LBL.fee_cal_type%TYPE,
82: cp_fee_ci_sequence_number IGS_FI_F_CAT_FEE_LBL.fee_ci_sequence_number%TYPE,
83: cp_fee_cat IGS_FI_FEE_CAT.fee_cat%TYPE) IS
84: SELECT rate_number

Line 81: cp_fee_cal_type IGS_FI_F_CAT_FEE_LBL.fee_cal_type%TYPE,

77: FROM IGS_FI_F_CAT_FEE_LBL
78: WHERE fee_cat = cp_fee_cat;
79: CURSOR c_far(
80: cp_fee_type IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE,
81: cp_fee_cal_type IGS_FI_F_CAT_FEE_LBL.fee_cal_type%TYPE,
82: cp_fee_ci_sequence_number IGS_FI_F_CAT_FEE_LBL.fee_ci_sequence_number%TYPE,
83: cp_fee_cat IGS_FI_FEE_CAT.fee_cat%TYPE) IS
84: SELECT rate_number
85: FROM IGS_FI_FEE_AS_RATE

Line 82: cp_fee_ci_sequence_number IGS_FI_F_CAT_FEE_LBL.fee_ci_sequence_number%TYPE,

78: WHERE fee_cat = cp_fee_cat;
79: CURSOR c_far(
80: cp_fee_type IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE,
81: cp_fee_cal_type IGS_FI_F_CAT_FEE_LBL.fee_cal_type%TYPE,
82: cp_fee_ci_sequence_number IGS_FI_F_CAT_FEE_LBL.fee_ci_sequence_number%TYPE,
83: cp_fee_cat IGS_FI_FEE_CAT.fee_cat%TYPE) IS
84: SELECT rate_number
85: FROM IGS_FI_FEE_AS_RATE
86: WHERE fee_type= cp_fee_type AND

Line 92: cp_fee_type IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE,

88: fee_ci_sequence_number = cp_fee_ci_sequence_number AND
89: s_relation_type = cst_fcfl AND
90: fee_cat = cp_fee_cat;
91: CURSOR c_err(
92: cp_fee_type IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE,
93: cp_fee_cal_type IGS_FI_F_CAT_FEE_LBL.fee_cal_type%TYPE,
94: cp_fee_ci_sequence_number IGS_FI_F_CAT_FEE_LBL.fee_ci_sequence_number%TYPE,
95: cp_fee_cat IGS_FI_FEE_CAT.fee_cat%TYPE)IS
96: SELECT range_number

Line 93: cp_fee_cal_type IGS_FI_F_CAT_FEE_LBL.fee_cal_type%TYPE,

89: s_relation_type = cst_fcfl AND
90: fee_cat = cp_fee_cat;
91: CURSOR c_err(
92: cp_fee_type IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE,
93: cp_fee_cal_type IGS_FI_F_CAT_FEE_LBL.fee_cal_type%TYPE,
94: cp_fee_ci_sequence_number IGS_FI_F_CAT_FEE_LBL.fee_ci_sequence_number%TYPE,
95: cp_fee_cat IGS_FI_FEE_CAT.fee_cat%TYPE)IS
96: SELECT range_number
97: FROM IGS_FI_ELM_RANGE_RT

Line 94: cp_fee_ci_sequence_number IGS_FI_F_CAT_FEE_LBL.fee_ci_sequence_number%TYPE,

90: fee_cat = cp_fee_cat;
91: CURSOR c_err(
92: cp_fee_type IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE,
93: cp_fee_cal_type IGS_FI_F_CAT_FEE_LBL.fee_cal_type%TYPE,
94: cp_fee_ci_sequence_number IGS_FI_F_CAT_FEE_LBL.fee_ci_sequence_number%TYPE,
95: cp_fee_cat IGS_FI_FEE_CAT.fee_cat%TYPE)IS
96: SELECT range_number
97: FROM IGS_FI_ELM_RANGE_RT
98: WHERE FEE_TYPE = cp_fee_type AND

Line 113: -- Use a loop to find any IGS_FI_F_CAT_FEE_LBL records based on the IGS_FI_FEE_CAT.

109: -- Check parameter
110: IF p_fee_cat IS NULL THEN
111: RETURN FALSE;
112: END IF;
113: -- Use a loop to find any IGS_FI_F_CAT_FEE_LBL records based on the IGS_FI_FEE_CAT.
114: FOR v_fcfl_rec IN c_fcfl(p_fee_cat) LOOP
115: -- Check if any associated IGS_FI_FEE_AS_RATE records exist for the
116: -- IGS_FI_F_CAT_FEE_LBL record. If so, return a warning.
117: OPEN c_far(

Line 116: -- IGS_FI_F_CAT_FEE_LBL record. If so, return a warning.

112: END IF;
113: -- Use a loop to find any IGS_FI_F_CAT_FEE_LBL records based on the IGS_FI_FEE_CAT.
114: FOR v_fcfl_rec IN c_fcfl(p_fee_cat) LOOP
115: -- Check if any associated IGS_FI_FEE_AS_RATE records exist for the
116: -- IGS_FI_F_CAT_FEE_LBL record. If so, return a warning.
117: OPEN c_far(
118: v_fcfl_rec.fee_type,
119: v_fcfl_rec.fee_cal_type,
120: v_fcfl_rec.fee_ci_sequence_number,

Line 131: -- IGS_FI_F_CAT_FEE_LBL record. If so, return a warning.

127: p_message_name := 'IGS_FI_FEECATFEELIAB_EXIST';
128: RETURN TRUE;
129: END IF;
130: -- Check if any associated IGS_FI_ELM_RANGE_RT records exist for the
131: -- IGS_FI_F_CAT_FEE_LBL record. If so, return a warning.
132: OPEN c_err(
133: v_fcfl_rec.FEE_TYPE,
134: v_fcfl_rec.fee_cal_type,
135: v_fcfl_rec.fee_ci_sequence_number,