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

Line 1014: FROM IGS_PS_VER crv,

1010: DECLARE
1011:
1012: CURSOR c_crv IS
1013: SELECT 'x'
1014: FROM IGS_PS_VER crv,
1015: IGS_PS_TYPE cty
1016: WHERE crv.course_cd = v_acaiv_rec.course_cd AND
1017: crv.version_number = v_acaiv_rec.crv_version_number AND
1018: cty.COURSE_TYPE = crv.COURSE_TYPE AND

Line 1082: FROM IGS_PS_VER ps,

1078: WHERE rowid = cp_rowid;
1079:
1080: CURSOR c_sca_ctype (cp_rowid VARCHAR2) IS
1081: SELECT ps.course_type
1082: FROM IGS_PS_VER ps,
1083: igs_en_stdnt_ps_att spa
1084: WHERE spa.rowid= cp_rowid
1085: AND ps.course_cd = spa.course_cd
1086: AND ps.version_number = spa.version_number;

Line 1087: v_sca_ctype IGS_PS_VER.course_type%TYPE;

1083: igs_en_stdnt_ps_att spa
1084: WHERE spa.rowid= cp_rowid
1085: AND ps.course_cd = spa.course_cd
1086: AND ps.version_number = spa.version_number;
1087: v_sca_ctype IGS_PS_VER.course_type%TYPE;
1088:
1089: CURSOR c_sca_primary(cp_course_type IGS_PS_VER.course_type%TYPE) IS
1090: SELECT 'X'
1091: FROM igs_en_stdnt_ps_att spa,

Line 1089: CURSOR c_sca_primary(cp_course_type IGS_PS_VER.course_type%TYPE) IS

1085: AND ps.course_cd = spa.course_cd
1086: AND ps.version_number = spa.version_number;
1087: v_sca_ctype IGS_PS_VER.course_type%TYPE;
1088:
1089: CURSOR c_sca_primary(cp_course_type IGS_PS_VER.course_type%TYPE) IS
1090: SELECT 'X'
1091: FROM igs_en_stdnt_ps_att spa,
1092: igs_ps_ver pv
1093: WHERE spa.person_id = p_person_id

Line 1092: igs_ps_ver pv

1088:
1089: CURSOR c_sca_primary(cp_course_type IGS_PS_VER.course_type%TYPE) IS
1090: SELECT 'X'
1091: FROM igs_en_stdnt_ps_att spa,
1092: igs_ps_ver pv
1093: WHERE spa.person_id = p_person_id
1094: AND spa.primary_program_type = 'PRIMARY'
1095: AND spa.course_cd = pv.course_cd
1096: AND spa.version_number = pv.version_number

Line 4164: FROM IGS_PS_VER crv,

4160: cp_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE,
4161: cp_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE,
4162: cp_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE) IS
4163: SELECT 'x'
4164: FROM IGS_PS_VER crv,
4165: IGS_PS_STAT cs,
4166: IGS_PS_OFR_PAT cop
4167: WHERE crv.course_cd = cp_course_cd AND
4168: crv.version_number = cp_version_number AND

Line 6216: v_source_course_type IGS_PS_VER.course_type%TYPE;

6212: cst_dropped CONSTANT VARCHAR2(10) := 'DROPPED';
6213: cst_waitlist CONSTANT VARCHAR2(10) := 'WAITLISTED';
6214: cst_invalid CONSTANT VARCHAR2(10) := 'INVALID';
6215: -- These variables are declared as part Career Impact Part 2 DLD . Bug # 2158626
6216: v_source_course_type IGS_PS_VER.course_type%TYPE;
6217: v_destn_course_type IGS_PS_VER.course_type%TYPE;
6218:
6219: e_record_locked EXCEPTION;
6220: PRAGMA EXCEPTION_INIT(e_record_locked, -54);

Line 6217: v_destn_course_type IGS_PS_VER.course_type%TYPE;

6213: cst_waitlist CONSTANT VARCHAR2(10) := 'WAITLISTED';
6214: cst_invalid CONSTANT VARCHAR2(10) := 'INVALID';
6215: -- These variables are declared as part Career Impact Part 2 DLD . Bug # 2158626
6216: v_source_course_type IGS_PS_VER.course_type%TYPE;
6217: v_destn_course_type IGS_PS_VER.course_type%TYPE;
6218:
6219: e_record_locked EXCEPTION;
6220: PRAGMA EXCEPTION_INIT(e_record_locked, -54);
6221: v_message_name VARCHAR2(2000);

Line 6305: FROM IGS_PS_VER ver ,

6301: FOR UPDATE OF sua.unit_attempt_status NOWAIT;
6302:
6303: CURSOR c_sua_career ( p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE , p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE ) IS
6304: SELECT ver.course_type
6305: FROM IGS_PS_VER ver ,
6306: igs_en_stdnt_ps_att spa
6307: WHERE ver.course_cd = p_course_cd AND
6308: ver.version_number = spa.version_number AND
6309: spa.course_cd = p_course_cd AND

Line 8648: FROM IGS_PS_VER pv,

8644:
8645: CURSOR cur_course_type (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
8646: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
8647: SELECT course_type
8648: FROM IGS_PS_VER pv,
8649: IGS_EN_STDNT_PS_ATT sca
8650: WHERE sca.person_id = cp_person_id
8651: AND sca.course_cd = cp_course_cd
8652: AND pv.course_cd = sca.course_cd

Line 8662: l_primary_program_cd IGS_PS_VER_ALL.COURSE_CD%TYPE;

8658: l_person_number igs_pe_person.person_number%TYPE;
8659: l_ret_stat VARCHAR2(1);
8660: l_unit_attempt_status igs_en_su_attempt.unit_attempt_status%TYPE;
8661: l_sub_sup_status igs_en_su_attempt.unit_attempt_status%TYPE;
8662: l_primary_program_cd IGS_PS_VER_ALL.COURSE_CD%TYPE;
8663: l_primary_program_vers IGS_PS_VER_ALL.VERSION_NUMBER%TYPE;
8664: l_all_program_title VARCHAR2(2000);
8665: l_profile VARCHAR2(1);
8666: l_career IGS_EN_SCA_V.course_type%TYPE;

Line 8663: l_primary_program_vers IGS_PS_VER_ALL.VERSION_NUMBER%TYPE;

8659: l_ret_stat VARCHAR2(1);
8660: l_unit_attempt_status igs_en_su_attempt.unit_attempt_status%TYPE;
8661: l_sub_sup_status igs_en_su_attempt.unit_attempt_status%TYPE;
8662: l_primary_program_cd IGS_PS_VER_ALL.COURSE_CD%TYPE;
8663: l_primary_program_vers IGS_PS_VER_ALL.VERSION_NUMBER%TYPE;
8664: l_all_program_title VARCHAR2(2000);
8665: l_profile VARCHAR2(1);
8666: l_career IGS_EN_SCA_V.course_type%TYPE;
8667:

Line 9353: FROM IGS_PS_VER ver ,

9349: -- get the course type of the passed program attempt
9350: CURSOR c_sua_career ( cp_person_id IN igs_en_stdnt_ps_att.person_id%TYPE ,
9351: cp_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE ) IS
9352: SELECT ver.course_type
9353: FROM IGS_PS_VER ver ,
9354: igs_en_stdnt_ps_att spa
9355: WHERE ver.course_cd = spa.course_cd AND
9356: ver.version_number = spa.version_number AND
9357: spa.course_cd = cp_course_cd AND

Line 9359: l_source_course_type igs_ps_ver.course_type%TYPE;

9355: WHERE ver.course_cd = spa.course_cd AND
9356: ver.version_number = spa.version_number AND
9357: spa.course_cd = cp_course_cd AND
9358: spa.person_id = cp_person_id;
9359: l_source_course_type igs_ps_ver.course_type%TYPE;
9360: l_destn_course_type igs_ps_ver.course_type%TYPE;
9361:
9362: CURSOR c_unit_dcnt is
9363: SELECT DISCONTINUATION_REASON_CD

Line 9360: l_destn_course_type igs_ps_ver.course_type%TYPE;

9356: ver.version_number = spa.version_number AND
9357: spa.course_cd = cp_course_cd AND
9358: spa.person_id = cp_person_id;
9359: l_source_course_type igs_ps_ver.course_type%TYPE;
9360: l_destn_course_type igs_ps_ver.course_type%TYPE;
9361:
9362: CURSOR c_unit_dcnt is
9363: SELECT DISCONTINUATION_REASON_CD
9364: FROM IGS_EN_DCNT_REASONCD