APPS.IGS_FI_PRC_FEE_ROLLV dependencies on IGS_FI_FEE_TYPE

Line 152: p_fee_type IN IGS_FI_FEE_TYPE.fee_type%TYPE ,

148: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
149: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
150: p_fee_cat_ci_status IN IGS_FI_F_CAT_CA_INST.fee_cat_ci_status%TYPE ,
151: p_fee_liability_status IN IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE ,
152: p_fee_type IN IGS_FI_FEE_TYPE.fee_type%TYPE ,
153: p_message_name OUT NOCOPY VARCHAR2 ,
154: p_message_warning OUT NOCOPY VARCHAR2 )
155: RETURN BOOLEAN;
156: --

Line 353: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,

349: p_rollover_fee_type_ci_ind IN VARCHAR ,
350: p_rollover_fee_cat_ci_ind IN VARCHAR ,
351: P_Source_Calendar IN VARCHAR2,
352: P_Dest_Calendar IN VARCHAR2 ,
353: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
354: p_fee_cat IN IGS_FI_F_CAT_CA_INST.fee_cat%TYPE ,
355: p_fee_type_ci_status IN IGS_FI_F_TYP_CA_INST_ALL.fee_type_ci_status%TYPE ,
356: p_fee_cat_ci_status IN IGS_FI_F_CAT_CA_INST.fee_cat_ci_status%TYPE ,
357: p_fee_liability_status IN IGS_FI_F_CAT_FEE_LBL_ALL.fee_liability_status%TYPE,

Line 707: v_closed_ind IGS_FI_FEE_TYPE.closed_ind%TYPE;

703: l_fcfl_exists_ind BOOLEAN := TRUE;
704: v_fee_cat IGS_FI_F_CAT_FEE_LBL.fee_cat%TYPE;
705: v_fee_type_ci_status IGS_FI_F_TYP_CA_INST.fee_type_ci_status%TYPE;
706: v_tmp_fee_type IGS_FI_F_TYP_CA_INST.fee_type%TYPE;
707: v_closed_ind IGS_FI_FEE_TYPE.closed_ind%TYPE;
708: v_sequence_number IGS_CA_INST.sequence_number%TYPE;
709: v_valid_dai BOOLEAN;
710: v_dummy IGS_CA_DA_INST.dt_alias%TYPE;
711: l_n_org_id IGS_FI_F_TYP_CA_INST.ORG_ID%type := igs_ge_gen_003.get_org_id;

Line 755: FROM IGS_FI_FEE_TYPE ft

751: fss.s_fee_structure_status = cst_active;
752: CURSOR c_ft (
753: cp_fee_type IGS_FI_F_TYP_CA_INST.fee_type%TYPE) IS
754: SELECT ft.closed_ind, ft.s_fee_type
755: FROM IGS_FI_FEE_TYPE ft
756: WHERE ft.fee_type = cp_fee_type;
757:
758: l_s_fee_type igs_fi_fee_type.s_fee_type%TYPE;
759:

Line 758: l_s_fee_type igs_fi_fee_type.s_fee_type%TYPE;

754: SELECT ft.closed_ind, ft.s_fee_type
755: FROM IGS_FI_FEE_TYPE ft
756: WHERE ft.fee_type = cp_fee_type;
757:
758: l_s_fee_type igs_fi_fee_type.s_fee_type%TYPE;
759:
760: -- This cursor is changed as a part of SFCR005 (Enh #1966961)
761: CURSOR c_ftci (
762: cp_fee_type IGS_FI_F_TYP_CA_INST.fee_type%TYPE) IS

Line 1182: p_fee_type IN IGS_FI_FEE_TYPE.fee_type%TYPE ,

1178: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
1179: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
1180: p_fee_cat_ci_status IN IGS_FI_F_CAT_CA_INST.fee_cat_ci_status%TYPE ,
1181: p_fee_liability_status IN IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE ,
1182: p_fee_type IN IGS_FI_FEE_TYPE.fee_type%TYPE ,
1183: p_message_name OUT NOCOPY VARCHAR2 ,
1184: p_message_warning OUT NOCOPY VARCHAR2 )
1185: /*----------------------------------------------------------------------------
1186: || Created By :

Line 1742: v_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE;

1738: v_message_name VARCHAR2(30);
1739: v_message_warning VARCHAR2(30);
1740: v_fcfl_inserted_ind BOOLEAN;
1741: v_fcfl_exists_ind BOOLEAN;
1742: v_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE;
1743: v_fee_liability_status IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE;
1744: v_next_fcfl BOOLEAN;
1745: v_valid_dai BOOLEAN;
1746: v_dummy IGS_CA_DA_INST.dt_alias%TYPE;