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_CFT dependencies on IGS_PS_FEE_TRG

Line 22: -- Validate IGS_PS_FEE_TRG.IGS_FI_FEE_TYPE.s_fee_trigger_cat = IGS_PS_COURSE or COMPOSITE

18: p_message_name OUT NOCOPY VARCHAR2 )
19: RETURN BOOLEAN AS
20: gv_other_detail VARCHAR2(255);
21: BEGIN -- finp_val_cft_ins
22: -- Validate IGS_PS_FEE_TRG.IGS_FI_FEE_TYPE.s_fee_trigger_cat = IGS_PS_COURSE or COMPOSITE
23: -- otherwise IGS_PS_COURSE fee triggers cannot be defined.
24: DECLARE
25: CURSOR c_ft(
26: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS

Line 58: -- Ensure only one open IGS_PS_FEE_TRG record exists.

54: RETURN TRUE;
55: END;
56: END finp_val_cft_ins;
57:
58: -- Ensure only one open IGS_PS_FEE_TRG record exists.
59: FUNCTION finp_val_cft_open(
60: p_fee_cat IN VARCHAR2 ,
61: p_fee_cal_type IN VARCHAR2 ,
62: p_fee_ci_sequence_number IN NUMBER ,

Line 77: -- Validate that there are no other "open-ended" IGS_PS_FEE_TRG records for

73: p_message_name OUT NOCOPY VARCHAR2 )
74: RETURN BOOLEAN AS
75: gv_other_detail VARCHAR2(255);
76: BEGIN -- finp_val_cft_open
77: -- Validate that there are no other "open-ended" IGS_PS_FEE_TRG records for
78: -- the nominated course_cd details and the same parent IGS_FI_F_CAT_FEE_LBL.
79: DECLARE
80: CURSOR c_cft IS
81: SELECT 'x'

Line 82: FROM IGS_PS_FEE_TRG cft

78: -- the nominated course_cd details and the same parent IGS_FI_F_CAT_FEE_LBL.
79: DECLARE
80: CURSOR c_cft IS
81: SELECT 'x'
82: FROM IGS_PS_FEE_TRG cft
83: WHERE cft.fee_cat = p_fee_cat AND
84: cft.fee_cal_type = p_fee_cal_type AND
85: cft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
86: cft.fee_type = p_fee_type AND

Line 129: -- Validate IGS_PS_FEE_TRG.course_cd. Course code must have at least one

125: p_message_name OUT NOCOPY VARCHAR2 )
126: RETURN BOOLEAN AS
127: gv_other_detail VARCHAR2(255);
128: BEGIN -- finp_val_cft_crs
129: -- Validate IGS_PS_FEE_TRG.course_cd. Course code must have at least one
130: -- version which has a status of 'ACTIVE' or 'PLANNED'
131: DECLARE
132: cst_planned CONSTANT VARCHAR2(10) := 'PLANNED';
133: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';

Line 136: cp_course_cd IGS_PS_FEE_TRG.course_cd%TYPE) IS

132: cst_planned CONSTANT VARCHAR2(10) := 'PLANNED';
133: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
134: v_dummy VARCHAR2(1);
135: CURSOR c_course_version_status (
136: cp_course_cd IGS_PS_FEE_TRG.course_cd%TYPE) IS
137: SELECT 'x'
138: FROM IGS_PS_VER crv,
139: IGS_PS_STAT cs
140: WHERE crv.course_cd = cp_course_cd AND

Line 168: -- Validates that the IGS_PS_FEE_TRG.IGS_CA_TYPE has a system calendar

164: p_message_name OUT NOCOPY VARCHAR2 )
165: RETURN BOOLEAN AS
166: gv_other_detail VARCHAR2(255);
167: BEGIN -- finp_val_ct_academic
168: -- Validates that the IGS_PS_FEE_TRG.IGS_CA_TYPE has a system calendar
169: -- category of 'ACADEMIC'
170: DECLARE
171: cst_academic CONSTANT VARCHAR2(10) := 'ACADEMIC';
172: v_dummy VARCHAR2(1);

Line 248: -- Validate IGS_PS_FEE_TRG can belong to a IGS_FI_FEE_TRG_GRP

244: p_message_name OUT NOCOPY VARCHAR2 )
245: RETURN BOOLEAN AS
246: gv_other_detail VARCHAR2(255);
247: BEGIN -- finp_val_cft_ftg
248: -- Validate IGS_PS_FEE_TRG can belong to a IGS_FI_FEE_TRG_GRP
249: DECLARE
250: v_dummy VARCHAR2(1);
251: CURSOR c_ft(
252: cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE)IS

Line 258: CURSOR c_cft( cp_fee_cat IGS_PS_FEE_TRG.fee_cat%TYPE,

254: FROM IGS_FI_FEE_TYPE
255: WHERE fee_type= cp_fee_type;
256: v_ft_rec c_ft%ROWTYPE;
257: cst_composite CONSTANT VARCHAR2(10) := 'COMPOSITE';
258: CURSOR c_cft( cp_fee_cat IGS_PS_FEE_TRG.fee_cat%TYPE,
259: cp_fee_cal_type IGS_PS_FEE_TRG.fee_cal_type%TYPE,
260: cp_fee_ci_sequence_num IGS_PS_FEE_TRG.fee_ci_sequence_number%TYPE,
261: cp_fee_type IGS_PS_FEE_TRG.fee_type%TYPE,
262: cp_course_cd IGS_PS_FEE_TRG.course_cd%TYPE,

Line 259: cp_fee_cal_type IGS_PS_FEE_TRG.fee_cal_type%TYPE,

255: WHERE fee_type= cp_fee_type;
256: v_ft_rec c_ft%ROWTYPE;
257: cst_composite CONSTANT VARCHAR2(10) := 'COMPOSITE';
258: CURSOR c_cft( cp_fee_cat IGS_PS_FEE_TRG.fee_cat%TYPE,
259: cp_fee_cal_type IGS_PS_FEE_TRG.fee_cal_type%TYPE,
260: cp_fee_ci_sequence_num IGS_PS_FEE_TRG.fee_ci_sequence_number%TYPE,
261: cp_fee_type IGS_PS_FEE_TRG.fee_type%TYPE,
262: cp_course_cd IGS_PS_FEE_TRG.course_cd%TYPE,
263: cp_fee_trigger_group_num

Line 260: cp_fee_ci_sequence_num IGS_PS_FEE_TRG.fee_ci_sequence_number%TYPE,

256: v_ft_rec c_ft%ROWTYPE;
257: cst_composite CONSTANT VARCHAR2(10) := 'COMPOSITE';
258: CURSOR c_cft( cp_fee_cat IGS_PS_FEE_TRG.fee_cat%TYPE,
259: cp_fee_cal_type IGS_PS_FEE_TRG.fee_cal_type%TYPE,
260: cp_fee_ci_sequence_num IGS_PS_FEE_TRG.fee_ci_sequence_number%TYPE,
261: cp_fee_type IGS_PS_FEE_TRG.fee_type%TYPE,
262: cp_course_cd IGS_PS_FEE_TRG.course_cd%TYPE,
263: cp_fee_trigger_group_num
264: IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE) IS

Line 261: cp_fee_type IGS_PS_FEE_TRG.fee_type%TYPE,

257: cst_composite CONSTANT VARCHAR2(10) := 'COMPOSITE';
258: CURSOR c_cft( cp_fee_cat IGS_PS_FEE_TRG.fee_cat%TYPE,
259: cp_fee_cal_type IGS_PS_FEE_TRG.fee_cal_type%TYPE,
260: cp_fee_ci_sequence_num IGS_PS_FEE_TRG.fee_ci_sequence_number%TYPE,
261: cp_fee_type IGS_PS_FEE_TRG.fee_type%TYPE,
262: cp_course_cd IGS_PS_FEE_TRG.course_cd%TYPE,
263: cp_fee_trigger_group_num
264: IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE) IS
265: SELECT 'x'

Line 262: cp_course_cd IGS_PS_FEE_TRG.course_cd%TYPE,

258: CURSOR c_cft( cp_fee_cat IGS_PS_FEE_TRG.fee_cat%TYPE,
259: cp_fee_cal_type IGS_PS_FEE_TRG.fee_cal_type%TYPE,
260: cp_fee_ci_sequence_num IGS_PS_FEE_TRG.fee_ci_sequence_number%TYPE,
261: cp_fee_type IGS_PS_FEE_TRG.fee_type%TYPE,
262: cp_course_cd IGS_PS_FEE_TRG.course_cd%TYPE,
263: cp_fee_trigger_group_num
264: IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE) IS
265: SELECT 'x'
266: FROM IGS_PS_FEE_TRG cft

Line 264: IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE) IS

260: cp_fee_ci_sequence_num IGS_PS_FEE_TRG.fee_ci_sequence_number%TYPE,
261: cp_fee_type IGS_PS_FEE_TRG.fee_type%TYPE,
262: cp_course_cd IGS_PS_FEE_TRG.course_cd%TYPE,
263: cp_fee_trigger_group_num
264: IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE) IS
265: SELECT 'x'
266: FROM IGS_PS_FEE_TRG cft
267: WHERE cft.fee_cat= cp_fee_cat AND
268: cft.fee_cal_type = cp_fee_cal_type AND

Line 266: FROM IGS_PS_FEE_TRG cft

262: cp_course_cd IGS_PS_FEE_TRG.course_cd%TYPE,
263: cp_fee_trigger_group_num
264: IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE) IS
265: SELECT 'x'
266: FROM IGS_PS_FEE_TRG cft
267: WHERE cft.fee_cat= cp_fee_cat AND
268: cft.fee_cal_type = cp_fee_cal_type AND
269: cft.fee_ci_sequence_number = cp_fee_ci_sequence_num AND
270: cft.fee_type = cp_fee_type AND