APPS.IGS_FI_VAL_FLS dependencies on IGS_FI_F_CAT_FEE_LBL

Line 10: p_fee_cat IN IGS_FI_F_CAT_FEE_LBL_ALL.FEE_CAT%TYPE ,

6: Removed functions finp_val_fls_scafs,finp_val_fls_status,finp_val_fls_status2,finp_val_fls_del along with pragmas
7: */
8: -- Validate the Fee Cat Fee Liability is active
9: FUNCTION finp_val_fls_fcfl(
10: p_fee_cat IN IGS_FI_F_CAT_FEE_LBL_ALL.FEE_CAT%TYPE ,
11: p_fee_cal_type IN IGS_FI_F_CAT_FEE_LBL_ALL.fee_cal_type%TYPE ,
12: p_fee_ci_sequence_number IN NUMBER ,
13: p_fee_type IN IGS_FI_F_CAT_FEE_LBL_ALL.fee_type%TYPE ,
14: p_message_name OUT NOCOPY VARCHAR2 )

Line 11: p_fee_cal_type IN IGS_FI_F_CAT_FEE_LBL_ALL.fee_cal_type%TYPE ,

7: */
8: -- Validate the Fee Cat Fee Liability is active
9: FUNCTION finp_val_fls_fcfl(
10: p_fee_cat IN IGS_FI_F_CAT_FEE_LBL_ALL.FEE_CAT%TYPE ,
11: p_fee_cal_type IN IGS_FI_F_CAT_FEE_LBL_ALL.fee_cal_type%TYPE ,
12: p_fee_ci_sequence_number IN NUMBER ,
13: p_fee_type IN IGS_FI_F_CAT_FEE_LBL_ALL.fee_type%TYPE ,
14: p_message_name OUT NOCOPY VARCHAR2 )
15: RETURN BOOLEAN AS

Line 13: p_fee_type IN IGS_FI_F_CAT_FEE_LBL_ALL.fee_type%TYPE ,

9: FUNCTION finp_val_fls_fcfl(
10: p_fee_cat IN IGS_FI_F_CAT_FEE_LBL_ALL.FEE_CAT%TYPE ,
11: p_fee_cal_type IN IGS_FI_F_CAT_FEE_LBL_ALL.fee_cal_type%TYPE ,
12: p_fee_ci_sequence_number IN NUMBER ,
13: p_fee_type IN IGS_FI_F_CAT_FEE_LBL_ALL.fee_type%TYPE ,
14: p_message_name OUT NOCOPY VARCHAR2 )
15: RETURN BOOLEAN AS
16: gv_other_detail VARCHAR2(255);
17: BEGIN -- finp_val_fls_fcfl

Line 19: -- IGS_FI_F_CAT_FEE_LBL which is ACTIVE.

15: RETURN BOOLEAN AS
16: gv_other_detail VARCHAR2(255);
17: BEGIN -- finp_val_fls_fcfl
18: -- Validate if the IGS_FI_FEE_LBL_SPNSR is related to a
19: -- IGS_FI_F_CAT_FEE_LBL which is ACTIVE.
20: DECLARE
21: cst_active CONSTANT VARCHAR2(6) := 'ACTIVE';
22: v_s_fee_structure_status IGS_FI_FEE_STR_STAT.s_fee_structure_status%TYPE;
23: CURSOR c_fss IS

Line 26: IGS_FI_F_CAT_FEE_LBL fcfl

22: v_s_fee_structure_status IGS_FI_FEE_STR_STAT.s_fee_structure_status%TYPE;
23: CURSOR c_fss IS
24: SELECT s_fee_structure_status
25: FROM IGS_FI_FEE_STR_STAT fss,
26: IGS_FI_F_CAT_FEE_LBL fcfl
27: WHERE fcfl.fee_cat = p_fee_cat AND
28: fcfl.fee_cal_type = p_fee_cal_type AND
29: fcfl.fee_ci_sequence_number = p_fee_ci_sequence_number AND
30: fcfl.fee_type = p_fee_type AND