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_FCFL dependencies on IGS_FI_F_CAT_FEE_LBL

Line 18: -- Validates that IGS_FI_F_CAT_FEE_LBL has a system calendar category of

14: p_message_name OUT NOCOPY VARCHAR2 )
15: RETURN BOOLEAN AS
16: gv_other_detail VARCHAR2(255);
17: BEGIN -- finp_val_fcfl_active
18: -- Validates that IGS_FI_F_CAT_FEE_LBL has a system calendar category of
19: -- 'FEE' and that the calendar instance is active when setting the
20: -- IGS_FI_F_CAT_FEE_LBL status to active.
21: DECLARE
22: cst_active CONSTANT VARCHAR2(6) := 'ACTIVE';

Line 20: -- IGS_FI_F_CAT_FEE_LBL status to active.

16: gv_other_detail VARCHAR2(255);
17: BEGIN -- finp_val_fcfl_active
18: -- Validates that IGS_FI_F_CAT_FEE_LBL has a system calendar category of
19: -- 'FEE' and that the calendar instance is active when setting the
20: -- IGS_FI_F_CAT_FEE_LBL status to active.
21: DECLARE
22: cst_active CONSTANT VARCHAR2(6) := 'ACTIVE';
23: cst_fee CONSTANT VARCHAR2(3) := 'FEE';
24: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;

Line 28: cp_fee_liability_status IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE) IS

24: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
25: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
26: v_dummy VARCHAR2(1);
27: CURSOR c_fss (
28: cp_fee_liability_status IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE) IS
29: SELECT 'x'
30: FROM IGS_FI_FEE_STR_STAT fss
31: WHERE fss.fee_structure_status = cp_fee_liability_status AND
32: fss.s_fee_structure_status = cst_active;

Line 113: -- Validate if IGS_FI_F_CAT_FEE_LBL.s_chg_method_type and

109: WHERE ftci.fee_cal_type = p_fee_cal_type AND
110: ftci.fee_ci_sequence_number = p_fee_ci_sequence_number AND
111: ftci.fee_type = p_fee_type;
112: BEGIN
113: -- Validate if IGS_FI_F_CAT_FEE_LBL.s_chg_method_type and
114: --IGS_FI_F_CAT_FEE_LBL.rul_sequence_number are required or
115: --not, depending on related values.
116: --1. Check parameters.
117: IF (p_fee_cal_type IS NULL OR

Line 114: --IGS_FI_F_CAT_FEE_LBL.rul_sequence_number are required or

110: ftci.fee_ci_sequence_number = p_fee_ci_sequence_number AND
111: ftci.fee_type = p_fee_type;
112: BEGIN
113: -- Validate if IGS_FI_F_CAT_FEE_LBL.s_chg_method_type and
114: --IGS_FI_F_CAT_FEE_LBL.rul_sequence_number are required or
115: --not, depending on related values.
116: --1. Check parameters.
117: IF (p_fee_cal_type IS NULL OR
118: p_fee_ci_sequence_number IS NULL OR

Line 152: -- IGS_FI_F_CAT_FEE_LBL record. If they are, they cannot be

148: RETURN FALSE;
149: END IF;
150: --3. Validate the IGS_FI_F_TYP_CA_INST record to see if
151: -- these fields are set. If not, they must be specified in the
152: -- IGS_FI_F_CAT_FEE_LBL record. If they are, they cannot be
153: -- specified in the IGS_FI_F_CAT_FEE_LBL record.
154: IF v_fee_type <> cst_fee_type AND v_fee_type <> cst_fee_type THEN
155: OPEN c_ftci;
156: FETCH c_ftci INTO v_s_chg_method_type,

Line 153: -- specified in the IGS_FI_F_CAT_FEE_LBL record.

149: END IF;
150: --3. Validate the IGS_FI_F_TYP_CA_INST record to see if
151: -- these fields are set. If not, they must be specified in the
152: -- IGS_FI_F_CAT_FEE_LBL record. If they are, they cannot be
153: -- specified in the IGS_FI_F_CAT_FEE_LBL record.
154: IF v_fee_type <> cst_fee_type AND v_fee_type <> cst_fee_type THEN
155: OPEN c_ftci;
156: FETCH c_ftci INTO v_s_chg_method_type,
157: v_rul_sequence_number;

Line 221: --Validate IGS_FI_F_CAT_FEE_LBL.fee_liability_status. Check

217: fcci.fee_ci_sequence_number = p_fee_ci_sequence_number AND
218: fcci.fee_cat = p_fee_cat AND
219: fcci.fee_cat_ci_status = fss.fee_structure_status;
220: BEGIN
221: --Validate IGS_FI_F_CAT_FEE_LBL.fee_liability_status. Check
222: -- that parent records have a status of 'ACTIVE' when
223: -- setting fee_liability_status to 'ACTIVE'.
224: --1. Check Parameters
225: IF (p_fee_cal_type IS NULL OR

Line 245: -- record has status of 'ACTIVE'. (IGS_GE_NOTE: IGS_FI_F_CAT_FEE_LBL

241: RETURN TRUE;
242: END IF;
243: v_fss_fee_structure_status := NULL;
244: --3. Validate that corresponding IGS_FI_F_TYP_CA_INST
245: -- record has status of 'ACTIVE'. (IGS_GE_NOTE: IGS_FI_F_CAT_FEE_LBL
246: -- records cannot exist without corresponding IGS_FI_F_TYP_CA_INST
247: -- records.
248: OPEN c_ftci;
249: FETCH c_ftci INTO v_fss_fee_structure_status;

Line 258: -- has a status of 'ACTIVE'. (IGS_GE_NOTE: IGS_FI_F_CAT_FEE_LBL

254: RETURN FALSE;
255: END IF;
256: v_fss_fee_structure_status := NULL;
257: --4. Validate that corresdponding fee_cal_cat_instance record
258: -- has a status of 'ACTIVE'. (IGS_GE_NOTE: IGS_FI_F_CAT_FEE_LBL
259: -- records cannot exist without corresponding IGS_FI_F_TYP_CA_INST
260: -- records.
261: OPEN c_fcci;
262: FETCH c_fcci INTO v_fss_fee_structure_status;

Line 296: -- Validate insert of the IGS_FI_F_CAT_FEE_LBL.

292: || obsoleted.Instead defaulted the currency that is set up in System Options Form.
293: ----------------------------------------------------------------------------*/
294: gv_other_detail VARCHAR2(255);
295: BEGIN -- finp_val_fcfl_cur
296: -- Validate insert of the IGS_FI_F_CAT_FEE_LBL.
297: -- When the fee category currency does not match the local currency
298: -- check there are no inherited definitions taken from the
299: -- fee type calendar instance. All definitions at the FTCI level
300: -- operate under the local currency