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_FTCI dependencies on IGS_FI_FEE_TYPE

Line 211: cst_hecs CONSTANT IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'HECS';

207: RETURN BOOLEAN AS
208: gv_other_detail VARCHAR2(255);
209: BEGIN
210: DECLARE
211: cst_hecs CONSTANT IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'HECS';
212: cst_eftsu CONSTANT VARCHAR2(10) := 'EFTSU';
213: v_s_fee_type IGS_FI_FEE_TYPE.s_fee_type%TYPE;
214: CURSOR c_ft IS
215: SELECT ft.s_fee_type

Line 213: v_s_fee_type IGS_FI_FEE_TYPE.s_fee_type%TYPE;

209: BEGIN
210: DECLARE
211: cst_hecs CONSTANT IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'HECS';
212: cst_eftsu CONSTANT VARCHAR2(10) := 'EFTSU';
213: v_s_fee_type IGS_FI_FEE_TYPE.s_fee_type%TYPE;
214: CURSOR c_ft IS
215: SELECT ft.s_fee_type
216: FROM IGS_FI_FEE_TYPE ft
217: WHERE ft.fee_type = p_fee_type;

Line 216: FROM IGS_FI_FEE_TYPE ft

212: cst_eftsu CONSTANT VARCHAR2(10) := 'EFTSU';
213: v_s_fee_type IGS_FI_FEE_TYPE.s_fee_type%TYPE;
214: CURSOR c_ft IS
215: SELECT ft.s_fee_type
216: FROM IGS_FI_FEE_TYPE ft
217: WHERE ft.fee_type = p_fee_type;
218: BEGIN
219: -- Validate if IGS_FI_F_TYP_CA_INST.s_chg_method_type
220: -- is correct for the IGS_FI_FEE_TYPE.s_fee_type

Line 220: -- is correct for the IGS_FI_FEE_TYPE.s_fee_type

216: FROM IGS_FI_FEE_TYPE ft
217: WHERE ft.fee_type = p_fee_type;
218: BEGIN
219: -- Validate if IGS_FI_F_TYP_CA_INST.s_chg_method_type
220: -- is correct for the IGS_FI_FEE_TYPE.s_fee_type
221: p_message_name := NULL;
222: -- 1. Check parameters
223: IF (p_fee_type IS NULL) THEN
224: RETURN TRUE;

Line 346: cst_hecs CONSTANT IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'HECS';

342: -- on related values.
343: -- Ensure that the FINANCE calendar_instance is
344: -- ACTIVE.
345: DECLARE
346: cst_hecs CONSTANT IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'HECS';
347: cst_institutn CONSTANT IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE := 'INSTITUTN';
348: cst_active CONSTANT IGS_FI_FEE_STR_STAT.fee_structure_status%TYPE := 'ACTIVE';
349: v_s_fee_type IGS_FI_FEE_TYPE.s_fee_type%TYPE;
350: v_s_fee_trigger_cat IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE;

Line 347: cst_institutn CONSTANT IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE := 'INSTITUTN';

343: -- Ensure that the FINANCE calendar_instance is
344: -- ACTIVE.
345: DECLARE
346: cst_hecs CONSTANT IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'HECS';
347: cst_institutn CONSTANT IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE := 'INSTITUTN';
348: cst_active CONSTANT IGS_FI_FEE_STR_STAT.fee_structure_status%TYPE := 'ACTIVE';
349: v_s_fee_type IGS_FI_FEE_TYPE.s_fee_type%TYPE;
350: v_s_fee_trigger_cat IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE;
351: v_fee_type IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE;

Line 349: v_s_fee_type IGS_FI_FEE_TYPE.s_fee_type%TYPE;

345: DECLARE
346: cst_hecs CONSTANT IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'HECS';
347: cst_institutn CONSTANT IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE := 'INSTITUTN';
348: cst_active CONSTANT IGS_FI_FEE_STR_STAT.fee_structure_status%TYPE := 'ACTIVE';
349: v_s_fee_type IGS_FI_FEE_TYPE.s_fee_type%TYPE;
350: v_s_fee_trigger_cat IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE;
351: v_fee_type IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE;
352: v_s_fee_structure_status IGS_FI_FEE_STR_STAT.fee_structure_status%TYPE;
353: v_acc_closed_ind IGS_FI_ACC.closed_ind%TYPE;

Line 350: v_s_fee_trigger_cat IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE;

346: cst_hecs CONSTANT IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'HECS';
347: cst_institutn CONSTANT IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE := 'INSTITUTN';
348: cst_active CONSTANT IGS_FI_FEE_STR_STAT.fee_structure_status%TYPE := 'ACTIVE';
349: v_s_fee_type IGS_FI_FEE_TYPE.s_fee_type%TYPE;
350: v_s_fee_trigger_cat IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE;
351: v_fee_type IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE;
352: v_s_fee_structure_status IGS_FI_FEE_STR_STAT.fee_structure_status%TYPE;
353: v_acc_closed_ind IGS_FI_ACC.closed_ind%TYPE;
354: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;

Line 364: FROM IGS_FI_FEE_TYPE ft

360: WHERE fss.fee_structure_status = cp_fee_type_ci_status;
361: CURSOR c_ft IS
362: SELECT ft.s_fee_type,
363: ft.s_fee_trigger_cat
364: FROM IGS_FI_FEE_TYPE ft
365: WHERE ft.fee_type = p_fee_type;
366: CURSOR c_fcfl IS
367: SELECT fcfl.fee_type
368: FROM IGS_FI_F_CAT_FEE_LBL fcfl

Line 428: -- validate the IGS_FI_FEE_TYPE to see if it is permissible for these values to be

424: IF (v_s_fee_structure_status <> cst_active) THEN
425: RETURN TRUE;
426: END IF;
427: -- 2.2 If p_chg_method is not null pr p_rul_sequence is not null, then
428: -- validate the IGS_FI_FEE_TYPE to see if it is permissible for these values to be
429: -- specified. Required when IGS_FI_FEE_TYPE.s_fee_trigger_cat = 'INSTITUTN' or
430: -- s_fee_type = 'HECS'.
431: OPEN c_ft;
432: FETCH c_ft INTO v_s_fee_type,

Line 429: -- specified. Required when IGS_FI_FEE_TYPE.s_fee_trigger_cat = 'INSTITUTN' or

425: RETURN TRUE;
426: END IF;
427: -- 2.2 If p_chg_method is not null pr p_rul_sequence is not null, then
428: -- validate the IGS_FI_FEE_TYPE to see if it is permissible for these values to be
429: -- specified. Required when IGS_FI_FEE_TYPE.s_fee_trigger_cat = 'INSTITUTN' or
430: -- s_fee_type = 'HECS'.
431: OPEN c_ft;
432: FETCH c_ft INTO v_s_fee_type,
433: v_s_fee_trigger_cat;

Line 618: -- Validate the IGS_FI_FEE_TYPE in the fee_type_account is not closed.

614: RETURN TRUE;
615: END;
616: END finp_val_ftci_status;
617: --
618: -- Validate the IGS_FI_FEE_TYPE in the fee_type_account is not closed.
619: -- Bug 1956374 Removed duplicate code finp_val_ft_closed
620: -- Validate PAYMENT HIERARCHY RAN
621: --As part of bugfix#2425767, removed function finp_val_ftci_rank,as this validates obsoleted column,
622: --payment_hierarchy_rank.