APPS.IGS_FI_VAL_UFT dependencies on IGS_FI_FEE_TYPE

Line 18: -- Validate IGS_FI_UNIT_FEE_TRG.IGS_FI_FEE_TYPE.s_fee_trigger_cat = IGS_PS_UNIT or COMPOSITE

14: p_message_name OUT NOCOPY VARCHAR2)
15: RETURN BOOLEAN AS
16: gv_other_detail VARCHAR2(255);
17: BEGIN -- finp_val_uft_ins
18: -- Validate IGS_FI_UNIT_FEE_TRG.IGS_FI_FEE_TYPE.s_fee_trigger_cat = IGS_PS_UNIT or COMPOSITE
19: -- otherwise IGS_PS_UNIT fee triggers cannot be defined.
20: DECLARE
21: CURSOR c_ft(
22: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS

Line 22: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS

18: -- Validate IGS_FI_UNIT_FEE_TRG.IGS_FI_FEE_TYPE.s_fee_trigger_cat = IGS_PS_UNIT or COMPOSITE
19: -- otherwise IGS_PS_UNIT fee triggers cannot be defined.
20: DECLARE
21: CURSOR c_ft(
22: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS
23: SELECT s_fee_trigger_cat
24: FROM IGS_FI_FEE_TYPE
25: WHERE fee_type = cp_fee_type;
26: v_ft_rec c_ft%ROWTYPE;

Line 24: FROM IGS_FI_FEE_TYPE

20: DECLARE
21: CURSOR c_ft(
22: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS
23: SELECT s_fee_trigger_cat
24: FROM IGS_FI_FEE_TYPE
25: WHERE fee_type = cp_fee_type;
26: v_ft_rec c_ft%ROWTYPE;
27: cst_unit CONSTANT VARCHAR2(10) := 'UNIT';
28: cst_composite CONSTANT VARCHAR2(10) := 'COMPOSITE';

Line 62: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,

58: END finp_val_uft_ins;
59: --
60: -- Validate IGS_PS_UNIT fee trigger can belong to a fee trigger group.
61: FUNCTION finp_val_uft_ftg(
62: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
63: p_fee_trigger_group_num IN NUMBER ,
64: p_message_name OUT NOCOPY VARCHAR2)
65: RETURN BOOLEAN AS
66: gv_other_detail VARCHAR2(255);

Line 71: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS

67: BEGIN -- finp_val_uft_ftg
68: -- Validate IGS_FI_UNIT_FEE_TRG can belong to a IGS_FI_FEE_TRG_GRP
69: DECLARE
70: CURSOR c_ft(
71: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS
72: SELECT s_fee_trigger_cat
73: FROM IGS_FI_FEE_TYPE
74: WHERE fee_type = cp_fee_type;
75: v_ft_rec c_ft%ROWTYPE;

Line 73: FROM IGS_FI_FEE_TYPE

69: DECLARE
70: CURSOR c_ft(
71: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS
72: SELECT s_fee_trigger_cat
73: FROM IGS_FI_FEE_TYPE
74: WHERE fee_type = cp_fee_type;
75: v_ft_rec c_ft%ROWTYPE;
76: cst_composite CONSTANT VARCHAR2(10) := 'COMPOSITE';
77: BEGIN