eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_VAL_FCCI dependencies on IGS_FI_F_CAT_CA_INST

Line 25: -- Validates that IGS_FI_F_CAT_CA_INST has a system calendar category of

21: p_message_name OUT NOCOPY VARCHAR2 )
22: RETURN BOOLEAN AS
23: gv_other_detail VARCHAR2(255);
24: BEGIN -- finp_val_fcci_active
25: -- Validates that IGS_FI_F_CAT_CA_INST has a system calendar category of
26: -- 'FEE' and that the calendar instance is active when setting the
27: -- IGS_FI_F_CAT_CA_INST status to active.
28: DECLARE
29: cst_active CONSTANT VARCHAR2(6) := 'ACTIVE';

Line 27: -- IGS_FI_F_CAT_CA_INST status to active.

23: gv_other_detail VARCHAR2(255);
24: BEGIN -- finp_val_fcci_active
25: -- Validates that IGS_FI_F_CAT_CA_INST has a system calendar category of
26: -- 'FEE' and that the calendar instance is active when setting the
27: -- IGS_FI_F_CAT_CA_INST status to active.
28: DECLARE
29: cst_active CONSTANT VARCHAR2(6) := 'ACTIVE';
30: cst_fee CONSTANT VARCHAR2(3) := 'FEE';
31: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;

Line 35: cp_fee_cat_ci_status IGS_FI_F_CAT_CA_INST.fee_cat_ci_status%TYPE) IS

31: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
32: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
33: v_dummy VARCHAR2(1);
34: CURSOR c_fss (
35: cp_fee_cat_ci_status IGS_FI_F_CAT_CA_INST.fee_cat_ci_status%TYPE) IS
36: SELECT 'x'
37: FROM IGS_FI_FEE_STR_STAT fss
38: WHERE fss.fee_structure_status = cp_fee_cat_ci_status AND
39: fss.s_fee_structure_status = cst_active;

Line 134: -- When the IGS_FI_F_CAT_CA_INST.fee_cat_ci_status is changed

130: FOR UPDATE OF fcfl.fee_liability_status NOWAIT;
131: fcfl_rec c_fcfl%ROWTYPE; -- kdande -> Added while converting DMLs.
132:
133: BEGIN
134: -- When the IGS_FI_F_CAT_CA_INST.fee_cat_ci_status is changed
135: -- to 'INACTIVE' update the IGS_FI_F_CAT_FEE_LBL.fee_liability_status
136: -- in related records to 'INACTIVE'.
137: p_message_name := NULL;
138: -- 1. Check if the fee_cat_ci_status relates to a system

Line 186: -- Validate the IGS_FI_F_CAT_CA_INST status

182: App_Exception.Raise_Exception;
183: END;
184: END finp_upd_fcci_status;
185: --
186: -- Validate the IGS_FI_F_CAT_CA_INST status
187: FUNCTION finp_val_fcci_status(
188: p_fee_cat IN VARCHAR2 ,
189: p_fee_cal_type IN VARCHAR2 ,
190: p_fee_ci_sequence_number IN NUMBER ,

Line 227: -- Validate the IGS_FI_F_CAT_CA_INST.fee_cat_ci_status. The checks are:

223: fcfl.fee_ci_sequence_number = p_fee_ci_sequence_number AND
224: fcfl.fee_liability_status = fss.fee_structure_status AND
225: fss.s_fee_structure_status = cst_active;
226: BEGIN
227: -- Validate the IGS_FI_F_CAT_CA_INST.fee_cat_ci_status. The checks are:
228: -- Fee_cat_ci_status can only be set back to a system status of
229: -- 'PLANNED' from 'ACTIVE' if it has no associate
230: -- IGS_FI_F_CAT_FEE_LBL records.
231: -- Fee_cat_ci_status can only be set to a system status of 'INACTIVE' from