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_EN_GEN_002 dependencies on IGS_CA_INST

Line 87: IGS_CA_INST CI

83: cp_course_cd IGS_PS_COURSE.course_cd%TYPE) IS
84: SELECT IGS_EN_GEN_014.enrs_get_acad_alt_cd(SUAV.cal_type,SUAV.ci_sequence_number)
85: ||'/'|| IGS_CA_GEN_001.calp_get_alt_cd(SUAV.cal_type,SUAV.ci_sequence_number)
86: FROM IGS_EN_SU_ATTEMPT SUAV,
87: IGS_CA_INST CI
88: WHERE SUAV.person_id = cp_person_id AND
89: SUAV.course_cd = cp_course_cd AND
90: SUAV.enrolled_dt IS NOT NULL AND
91: SUAV.cal_type = CI.cal_type AND

Line 139: gv_alternate_code IGS_CA_INST.alternate_code%TYPE;

135: p_message_name out NOCOPY Varchar2 )
136: RETURN VARCHAR2 AS
137:
138: gv_acad_rec_found BOOLEAN := FALSE;
139: gv_alternate_code IGS_CA_INST.alternate_code%TYPE;
140: gv_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
141:
142: BEGIN -- enrp_get_acad_alt_cd
143: -- Get the alternate_code for the superior ACADEMIC IGS_CA_INST of the

Line 143: -- Get the alternate_code for the superior ACADEMIC IGS_CA_INST of the

139: gv_alternate_code IGS_CA_INST.alternate_code%TYPE;
140: gv_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
141:
142: BEGIN -- enrp_get_acad_alt_cd
143: -- Get the alternate_code for the superior ACADEMIC IGS_CA_INST of the
144: -- IGS_CA_INST passed
145: DECLARE
146: -- This function recursively track down the first superior academic
147: -- IGS_CA_INST (deep first recursive). Returning TRUE if it can find one,

Line 144: -- IGS_CA_INST passed

140: gv_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
141:
142: BEGIN -- enrp_get_acad_alt_cd
143: -- Get the alternate_code for the superior ACADEMIC IGS_CA_INST of the
144: -- IGS_CA_INST passed
145: DECLARE
146: -- This function recursively track down the first superior academic
147: -- IGS_CA_INST (deep first recursive). Returning TRUE if it can find one,
148: -- FALSE otherwise

Line 147: -- IGS_CA_INST (deep first recursive). Returning TRUE if it can find one,

143: -- Get the alternate_code for the superior ACADEMIC IGS_CA_INST of the
144: -- IGS_CA_INST passed
145: DECLARE
146: -- This function recursively track down the first superior academic
147: -- IGS_CA_INST (deep first recursive). Returning TRUE if it can find one,
148: -- FALSE otherwise
149:
150: CURSOR c_check_s_cal_cat (cp_cal_type IGS_CA_TYPE.cal_type%TYPE) IS
151: SELECT cat.s_cal_cat

Line 155: CURSOR c_get_super_ci_for_load (cp_cal_type IGS_CA_INST.cal_type%TYPE,

151: SELECT cat.s_cal_cat
152: FROM IGS_CA_TYPE cat
153: WHERE cat.cal_type = cp_cal_type;
154:
155: CURSOR c_get_super_ci_for_load (cp_cal_type IGS_CA_INST.cal_type%TYPE,
156: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
157: SELECT cir.sup_cal_type,
158: cir.sup_ci_sequence_number,
159: ci.start_dt,

Line 156: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

152: FROM IGS_CA_TYPE cat
153: WHERE cat.cal_type = cp_cal_type;
154:
155: CURSOR c_get_super_ci_for_load (cp_cal_type IGS_CA_INST.cal_type%TYPE,
156: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
157: SELECT cir.sup_cal_type,
158: cir.sup_ci_sequence_number,
159: ci.start_dt,
160: ci.end_dt,

Line 162: FROM IGS_CA_INST_REL cir,

158: cir.sup_ci_sequence_number,
159: ci.start_dt,
160: ci.end_dt,
161: ci.alternate_code
162: FROM IGS_CA_INST_REL cir,
163: IGS_CA_INST ci,
164: IGS_CA_TYPE cat
165: WHERE cir.sub_cal_type = cp_cal_type AND
166: cir.sub_ci_sequence_number = cp_ci_sequence_number AND

Line 163: IGS_CA_INST ci,

159: ci.start_dt,
160: ci.end_dt,
161: ci.alternate_code
162: FROM IGS_CA_INST_REL cir,
163: IGS_CA_INST ci,
164: IGS_CA_TYPE cat
165: WHERE cir.sub_cal_type = cp_cal_type AND
166: cir.sub_ci_sequence_number = cp_ci_sequence_number AND
167: ci.cal_type = cir.sup_cal_type AND

Line 175: FUNCTION enrpl_get_acad_alt_cd_re (cp_cal_type IGS_CA_INST.cal_type%TYPE,

171: ORDER BY
172: ci.start_dt asc,
173: ci.end_dt asc;
174:
175: FUNCTION enrpl_get_acad_alt_cd_re (cp_cal_type IGS_CA_INST.cal_type%TYPE,
176: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE)
177: RETURN BOOLEAN
178: AS
179: BEGIN

Line 176: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE)

172: ci.start_dt asc,
173: ci.end_dt asc;
174:
175: FUNCTION enrpl_get_acad_alt_cd_re (cp_cal_type IGS_CA_INST.cal_type%TYPE,
176: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE)
177: RETURN BOOLEAN
178: AS
179: BEGIN
180: DECLARE

Line 182: CURSOR c_get_super_ci (cp_cal_type IGS_CA_INST.cal_type%TYPE,

178: AS
179: BEGIN
180: DECLARE
181:
182: CURSOR c_get_super_ci (cp_cal_type IGS_CA_INST.cal_type%TYPE,
183: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
184: SELECT cir.sup_cal_type,
185: cir.sup_ci_sequence_number,
186: ci.start_dt,

Line 183: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

179: BEGIN
180: DECLARE
181:
182: CURSOR c_get_super_ci (cp_cal_type IGS_CA_INST.cal_type%TYPE,
183: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
184: SELECT cir.sup_cal_type,
185: cir.sup_ci_sequence_number,
186: ci.start_dt,
187: ci.end_dt,

Line 190: FROM IGS_CA_INST_REL cir,

186: ci.start_dt,
187: ci.end_dt,
188: ci.alternate_code,
189: cat.s_cal_cat
190: FROM IGS_CA_INST_REL cir,
191: IGS_CA_INST ci,
192: IGS_CA_TYPE cat
193: WHERE cir.sub_cal_type = cp_cal_type AND
194: cir.sub_ci_sequence_number = cp_ci_sequence_number AND

Line 191: IGS_CA_INST ci,

187: ci.end_dt,
188: ci.alternate_code,
189: cat.s_cal_cat
190: FROM IGS_CA_INST_REL cir,
191: IGS_CA_INST ci,
192: IGS_CA_TYPE cat
193: WHERE cir.sub_cal_type = cp_cal_type AND
194: cir.sub_ci_sequence_number = cp_ci_sequence_number AND
195: ci.cal_type = cir.sup_cal_type AND

Line 337: IGS_CA_INST ci,

333: acai.prpsd_commencement_dt prpsd_commencement_dt
334: FROM
335: IGS_AD_PS_APPL_INST acai,
336: IGS_AD_APPL aa,
337: IGS_CA_INST ci,
338: IGS_AD_PS_APPL aca,
339: IGS_PS_VER crv
340: WHERE acai.person_id = p_person_id AND
341: aa.person_id = acai.person_id AND

Line 365: IGS_CA_INST_REL cir,

361: CURSOR c_scae_cir_ci_cat IS
362: SELECT cir.sup_cal_type,
363: cir.sup_ci_sequence_number
364: FROM IGS_AS_SC_ATMPT_ENR scae,
365: IGS_CA_INST_REL cir,
366: IGS_CA_INST ci,
367: IGS_CA_TYPE cat
368: WHERE scae.person_id = p_person_id AND
369: scae.course_cd = p_course_cd AND

Line 366: IGS_CA_INST ci,

362: SELECT cir.sup_cal_type,
363: cir.sup_ci_sequence_number
364: FROM IGS_AS_SC_ATMPT_ENR scae,
365: IGS_CA_INST_REL cir,
366: IGS_CA_INST ci,
367: IGS_CA_TYPE cat
368: WHERE scae.person_id = p_person_id AND
369: scae.course_cd = p_course_cd AND
370: scae.cal_type = cir.sub_cal_type AND

Line 377: v_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE;

373: cir.sub_ci_sequence_number = ci_sequence_number AND
374: cir.sup_cal_type = cat.cal_type AND
375: cat.s_cal_cat = cst_academic
376: ORDER BY ci.start_dt ASC;
377: v_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE;
378: v_acad_ci_sequence_number
379: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;
380: v_course_start_dt DATE DEFAULT NULL;
381: BEGIN

Line 379: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;

375: cat.s_cal_cat = cst_academic
376: ORDER BY ci.start_dt ASC;
377: v_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE;
378: v_acad_ci_sequence_number
379: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;
380: v_course_start_dt DATE DEFAULT NULL;
381: BEGIN
382:
383: -- Determine that student IGS_PS_COURSE attempt is not the result of a