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.

[Home] [Help]

APPS.IGS_FI_VAL_CFAR dependencies on IGS_FI_FEE_AS_RT

Line 75: -- Validate the IGS_FI_FEE_AS_RT can only be defined for

71: CST_TUITION IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'TUITION';
72: CST_TUTNFEE IGS_FI_FEE_TYPE.s_fee_type%TYPE := 'TUTNFEE';
73: CST_INSTITUTN IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE := 'INSTITUTN';
74: BEGIN
75: -- Validate the IGS_FI_FEE_AS_RT can only be defined for
76: -- fee types with s_fee_type = 'OTHER'or 'TUTNFEE' or 'TUITION' and
77: -- s_fee_trigger_cat not 'INSTITUTN'.
78: -- Set the default message number
79: p_message_name := Null;

Line 127: FROM IGS_FI_FEE_AS_RT cfar

123: DECLARE
124: CURSOR c_cfar IS
125: SELECT cfar.start_dt,
126: cfar.end_dt
127: FROM IGS_FI_FEE_AS_RT cfar
128: WHERE cfar.person_id = p_person_id AND
129: cfar.course_cd = p_course_cd AND
130: cfar.fee_type = p_fee_type AND
131: cfar.start_dt <> p_start_dt;

Line 183: v_person_id IGS_FI_FEE_AS_RT.person_id%TYPE;

179: RETURN BOOLEAN AS
180: gv_other_detail VARCHAR2(255);
181: BEGIN
182: DECLARE
183: v_person_id IGS_FI_FEE_AS_RT.person_id%TYPE;
184: CURSOR c_cfar IS
185: SELECT cfar.person_id
186: FROM IGS_FI_FEE_AS_RT cfar
187: WHERE cfar.person_id = p_person_id AND

Line 186: FROM IGS_FI_FEE_AS_RT cfar

182: DECLARE
183: v_person_id IGS_FI_FEE_AS_RT.person_id%TYPE;
184: CURSOR c_cfar IS
185: SELECT cfar.person_id
186: FROM IGS_FI_FEE_AS_RT cfar
187: WHERE cfar.person_id = p_person_id AND
188: cfar.course_cd = p_course_cd AND
189: cfar.fee_type = p_fee_type AND
190: cfar.start_dt <> p_start_dt AND

Line 193: -- Validate the IGS_FI_FEE_AS_RT (cfar) table to ensure that

189: cfar.fee_type = p_fee_type AND
190: cfar.start_dt <> p_start_dt AND
191: cfar.end_dt IS NULL;
192: BEGIN
193: -- Validate the IGS_FI_FEE_AS_RT (cfar) table to ensure that
194: -- for records with the same person_id, course_cd, and fee_type
195: -- that only one record has a NULL end_dt.
196: OPEN c_cfar;
197: FETCH c_cfar INTO v_person_id;

Line 217: -- Validates the IGS_FI_FEE_AS_RT (cfar) table to ensure that if the

213: p_message_name OUT NOCOPY VARCHAR2 )
214: RETURN BOOLEAN AS
215: gv_other_detail VARCHAR2(255);
216: BEGIN
217: -- Validates the IGS_FI_FEE_AS_RT (cfar) table to ensure that if the
218: -- end_dt is NOT NULL and it is greater than or equal to the start_dt.
219: IF (p_end_dt IS NOT NULL) AND
220: (p_end_dt < p_start_dt) THEN
221: -- The end date must be greater than or equal to the start date.