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_EN_CAREER_MODEL dependencies on IGS_PS_VER

Line 35: IGS_PS_VER crv

31:
32: CURSOR c_pri_course_cd is
33: SELECT sca.course_attempt_status
34: FROM IGS_EN_STDNT_PS_ATT sca,
35: IGS_PS_VER crv
36: WHERE sca.person_id = p_person_id
37: AND crv.course_type = p_course_type
38: AND sca.course_cd = crv.course_Cd
39: AND sca.version_number = crv.version_number

Line 169: v_course_cd_rank IGS_PS_VER.PRIMARY_PROGRAM_RANK%TYPE;

165:
166:
167: v_course_type IGS_PS_TYPE.COURSE_TYPE%TYPE;
168: v_primary_prog_type_source IGS_EN_STDNT_PS_ATT_ALL.primary_prog_type_source%TYPE;
169: v_course_cd_rank IGS_PS_VER.PRIMARY_PROGRAM_RANK%TYPE;
170: v_exst_primary_rank IGS_PS_VER.PRIMARY_PROGRAM_RANK%TYPE;
171: v_exst_key_program IGS_EN_STDNT_PS_ATT_ALL.KEY_PROGRAM%TYPE ;
172: v_min_sec_rank IGS_PS_VER.PRIMARY_PROGRAM_RANK%TYPE;
173: cst_system CONSTANT VARCHAR2(10) := 'SYSTEM';

Line 170: v_exst_primary_rank IGS_PS_VER.PRIMARY_PROGRAM_RANK%TYPE;

166:
167: v_course_type IGS_PS_TYPE.COURSE_TYPE%TYPE;
168: v_primary_prog_type_source IGS_EN_STDNT_PS_ATT_ALL.primary_prog_type_source%TYPE;
169: v_course_cd_rank IGS_PS_VER.PRIMARY_PROGRAM_RANK%TYPE;
170: v_exst_primary_rank IGS_PS_VER.PRIMARY_PROGRAM_RANK%TYPE;
171: v_exst_key_program IGS_EN_STDNT_PS_ATT_ALL.KEY_PROGRAM%TYPE ;
172: v_min_sec_rank IGS_PS_VER.PRIMARY_PROGRAM_RANK%TYPE;
173: cst_system CONSTANT VARCHAR2(10) := 'SYSTEM';
174: cst_primary CONSTANT VARCHAR2(10) := 'PRIMARY';

Line 172: v_min_sec_rank IGS_PS_VER.PRIMARY_PROGRAM_RANK%TYPE;

168: v_primary_prog_type_source IGS_EN_STDNT_PS_ATT_ALL.primary_prog_type_source%TYPE;
169: v_course_cd_rank IGS_PS_VER.PRIMARY_PROGRAM_RANK%TYPE;
170: v_exst_primary_rank IGS_PS_VER.PRIMARY_PROGRAM_RANK%TYPE;
171: v_exst_key_program IGS_EN_STDNT_PS_ATT_ALL.KEY_PROGRAM%TYPE ;
172: v_min_sec_rank IGS_PS_VER.PRIMARY_PROGRAM_RANK%TYPE;
173: cst_system CONSTANT VARCHAR2(10) := 'SYSTEM';
174: cst_primary CONSTANT VARCHAR2(10) := 'PRIMARY';
175: cst_secondary CONSTANT VARCHAR2(10) := 'SECONDARY';
176: l_count NUMBER(5);

Line 180: FROM igs_ps_ver crv

176: l_count NUMBER(5);
177:
178: CURSOR c_course_type IS
179: SELECT crv.course_type
180: FROM igs_ps_ver crv
181: WHERE course_cd = p_course_cd
182: and version_number = p_version_number;
183:
184: /*

Line 188: igs_ps_ver crv

184: /*
185: CURSOR c_auto_enabled (cp_course_type IGS_PS_TYPE.COURSE_TYPE%TYPE) IS
186: SELECT crv.primary_program_rank
187: FROM igs_ps_type pst,
188: igs_ps_ver crv
189: WHERE pst.course_type = cp_course_type
190: AND crv.course_Cd = p_course_Cd
191: AND crv.version_number = p_version_number
192: AND crv.course_type = pst.course_type;

Line 197: igs_ps_ver crv

193: */
194: CURSOR c_exst_primary_rank (cp_course_type IGS_PS_TYPE.COURSE_TYPE%TYPE) IS
195: SELECT PRIMARY_PROGRAM_RANK , key_program
196: FROM igs_en_stdnt_ps_att sca,
197: igs_ps_ver crv
198: WHERE crv.course_type = cp_course_type
199: AND sca.course_cd = crv.course_cd
200: AND sca.version_number = crv.version_number
201: AND sca.person_id = p_person_id

Line 216: IGS_PS_VER crv

212: --Cursor gets the total number of courses attempted by student for a given course type.
213: CURSOR c_prg_count(cp_course_type IGS_PS_TYPE.COURSE_TYPE%TYPE) IS
214: SELECT count(1)
215: FROM IGS_EN_STDNT_PS_ATT sca,
216: IGS_PS_VER crv
217: WHERE sca.person_id = p_person_id
218: AND crv.course_type = cp_course_type
219: AND sca.course_cd = crv.course_cd
220: AND sca.version_number = crv.version_number

Line 357: v_sec_rank IGS_PS_VER.PRIMARY_PROGRAM_RANK%TYPE;

353: p_old_key_program IN VARCHAR2
354: ) AS
355:
356: v_course_type IGS_PS_TYPE.COURSE_TYPE%TYPE;
357: v_sec_rank IGS_PS_VER.PRIMARY_PROGRAM_RANK%TYPE;
358: v_test_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE;
359: v_primary_prog_type_source IGS_EN_STDNT_PS_ATT_ALL.primary_prog_type_source%TYPE;
360: v_course_attempt_status IGS_EN_STDNT_PS_ATT_ALL.course_attempt_status%TYPE;
361: cst_primary CONSTANT VARCHAR2(10) := 'PRIMARY';

Line 380: FROM igs_ps_ver crv

376:
377: CURSOR c_course_type(cp_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE,
378: cp_version_number IGS_EN_STDNT_PS_ATT_ALL.version_number%TYPE) IS
379: SELECT crv.course_type
380: FROM igs_ps_ver crv
381: WHERE course_cd = cp_course_cd
382: and version_number = cp_version_number;
383:
384: CURSOR c_sca_upd (cp_course_type IGS_PS_TYPE.COURSE_TYPE%TYPE ,

Line 389: igs_ps_ver crv

385: cp_person_id IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
386: cp_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE) IS
387: SELECT sca.*
388: FROM igs_en_stdnt_ps_att sca,
389: igs_ps_ver crv
390: WHERE crv.course_type = cp_course_type
391: and sca.course_cd = crv.course_cd
392: and sca.version_number = crv.version_number
393: and sca.person_id = cp_person_id

Line 401: igs_ps_ver crv

397: cp_person_id IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
398: cp_course_cd IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ) IS
399: SELECT crv.PRIMARY_PROGRAM_RANK, sca.course_Cd
400: FROM igs_en_stdnt_ps_att sca,
401: igs_ps_ver crv
402: WHERE crv.course_type = cp_course_type
403: and sca.course_cd = crv.course_cd
404: and sca.version_number = crv.version_number
405: and sca.person_id = cp_person_id

Line 416: igs_ps_ver crv

412: --Added by kkillams
413: CURSOR c_ext_oth_prg_key (cp_course_type IGS_PS_TYPE.COURSE_TYPE%TYPE) IS
414: SELECT 'X'
415: FROM igs_en_stdnt_ps_att sca,
416: igs_ps_ver crv
417: WHERE crv.course_type <> cp_course_type
418: AND sca.course_cd = crv.course_cd
419: AND sca.version_number = crv.version_number
420: AND sca.person_id = p_person_id

Line 428: igs_ps_ver crv

424: --Following cursor get's any primary program for this career other than current program
425: CURSOR c_ext_oth_primprg (cp_course_type IGS_PS_TYPE.COURSE_TYPE%TYPE,cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
426: SELECT 'X'
427: FROM igs_en_stdnt_ps_att sca,
428: igs_ps_ver crv
429: WHERE crv.course_type = cp_course_type
430: AND sca.course_cd = crv.course_cd
431: AND sca.version_number = crv.version_number
432: AND sca.person_id = p_person_id

Line 674: IGS_PS_VER crv

670:
671: CURSOR c_primary_count IS
672: SELECT count(primary_program_type)
673: FROM IGS_EN_STDNT_PS_ATT sca,
674: IGS_PS_VER crv
675: WHERE crv.course_type = p_course_type AND
676: sca.course_cd = crv.course_cd AND
677: sca.version_number = crv.version_number AND
678: sca.person_id = p_person_id AND

Line 683: from IGS_EN_STDNT_PS_ATT sca, igs_ps_ver crv

679: sca.primary_program_type = 'PRIMARY';
680:
681: CURSOR c_confirmed_sca IS
682: select count(student_confirmed_ind)
683: from IGS_EN_STDNT_PS_ATT sca, igs_ps_ver crv
684: where crv.course_type = p_course_type and
685: sca.course_cd = crv.course_cd and
686: sca.version_number = crv.version_number and
687: sca.person_id = p_person_id and