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_PR_GEN_004 dependencies on IGS_PE_STD_TODO

Line 55: -- Insert a IGS_PE_STD_TODO entry for an amendment of grade, providing the

51: p_uoo_id IN NUMBER)
52: IS
53: gv_other_detail VARCHAR2(255);
54: BEGIN -- IGS_PR_ins_suao_todo
55: -- Insert a IGS_PE_STD_TODO entry for an amendment of grade, providing the
56: -- student has already undergone a progression check in the appropriate
57: -- period.
58: DECLARE
59: cst_progress CONSTANT VARCHAR2(10) := 'PROGRESS';

Line 3098: FROM IGS_PE_STD_TODO st,

3094: st.s_student_todo_type,
3095: st.sequence_number,
3096: str.course_cd,
3097: sca.version_number
3098: FROM IGS_PE_STD_TODO st,
3099: IGS_PE_STD_TODO_REF str,
3100: IGS_EN_STDNT_PS_ATT sca
3101: WHERE st.s_student_todo_type = cst_prg_check AND
3102: st.logical_delete_dt IS NULL AND

Line 3099: IGS_PE_STD_TODO_REF str,

3095: st.sequence_number,
3096: str.course_cd,
3097: sca.version_number
3098: FROM IGS_PE_STD_TODO st,
3099: IGS_PE_STD_TODO_REF str,
3100: IGS_EN_STDNT_PS_ATT sca
3101: WHERE st.s_student_todo_type = cst_prg_check AND
3102: st.logical_delete_dt IS NULL AND
3103: st.person_id = str.person_id AND

Line 3146: cp_person_id IGS_PE_STD_TODO.person_id%TYPE,

3142: scae2.course_cd = scae.course_cd AND
3143: ci2.cal_type = scae2.cal_type AND
3144: ci2.sequence_number = scae2.ci_sequence_number)));
3145: CURSOR c_st_lck (
3146: cp_person_id IGS_PE_STD_TODO.person_id%TYPE,
3147: cp_s_student_todo_type IGS_PE_STD_TODO.s_student_todo_type%TYPE,
3148: cp_sequence_number IGS_PE_STD_TODO.sequence_number%TYPE) IS
3149: SELECT st.*,
3150: st.ROWID

Line 3147: cp_s_student_todo_type IGS_PE_STD_TODO.s_student_todo_type%TYPE,

3143: ci2.cal_type = scae2.cal_type AND
3144: ci2.sequence_number = scae2.ci_sequence_number)));
3145: CURSOR c_st_lck (
3146: cp_person_id IGS_PE_STD_TODO.person_id%TYPE,
3147: cp_s_student_todo_type IGS_PE_STD_TODO.s_student_todo_type%TYPE,
3148: cp_sequence_number IGS_PE_STD_TODO.sequence_number%TYPE) IS
3149: SELECT st.*,
3150: st.ROWID
3151: FROM IGS_PE_STD_TODO st

Line 3148: cp_sequence_number IGS_PE_STD_TODO.sequence_number%TYPE) IS

3144: ci2.sequence_number = scae2.ci_sequence_number)));
3145: CURSOR c_st_lck (
3146: cp_person_id IGS_PE_STD_TODO.person_id%TYPE,
3147: cp_s_student_todo_type IGS_PE_STD_TODO.s_student_todo_type%TYPE,
3148: cp_sequence_number IGS_PE_STD_TODO.sequence_number%TYPE) IS
3149: SELECT st.*,
3150: st.ROWID
3151: FROM IGS_PE_STD_TODO st
3152: WHERE st.person_id = cp_person_id AND

Line 3151: FROM IGS_PE_STD_TODO st

3147: cp_s_student_todo_type IGS_PE_STD_TODO.s_student_todo_type%TYPE,
3148: cp_sequence_number IGS_PE_STD_TODO.sequence_number%TYPE) IS
3149: SELECT st.*,
3150: st.ROWID
3151: FROM IGS_PE_STD_TODO st
3152: WHERE st.person_id = cp_person_id AND
3153: st.s_student_todo_type = cp_s_student_todo_type AND
3154: st.sequence_number = cp_sequence_number
3155: FOR UPDATE NOWAIT;

Line 3167: cp_person_id IGS_PE_STD_TODO_REF.person_id%TYPE,

3163: FROM IGS_PS_VER crv
3164: WHERE crv.course_cd = cp_course_cd AND
3165: crv.version_number = cp_version_number;
3166: CURSOR c_str (
3167: cp_person_id IGS_PE_STD_TODO_REF.person_id%TYPE,
3168: cp_s_student_todo_type IGS_PE_STD_TODO_REF.s_student_todo_type%TYPE,
3169: cp_sequence_number IGS_PE_STD_TODO_REF.sequence_number%TYPE,
3170: cp_course_cd IGS_PE_STD_TODO_REF.course_cd%TYPE) IS
3171: SELECT str.*,

Line 3168: cp_s_student_todo_type IGS_PE_STD_TODO_REF.s_student_todo_type%TYPE,

3164: WHERE crv.course_cd = cp_course_cd AND
3165: crv.version_number = cp_version_number;
3166: CURSOR c_str (
3167: cp_person_id IGS_PE_STD_TODO_REF.person_id%TYPE,
3168: cp_s_student_todo_type IGS_PE_STD_TODO_REF.s_student_todo_type%TYPE,
3169: cp_sequence_number IGS_PE_STD_TODO_REF.sequence_number%TYPE,
3170: cp_course_cd IGS_PE_STD_TODO_REF.course_cd%TYPE) IS
3171: SELECT str.*,
3172: str.ROWID

Line 3169: cp_sequence_number IGS_PE_STD_TODO_REF.sequence_number%TYPE,

3165: crv.version_number = cp_version_number;
3166: CURSOR c_str (
3167: cp_person_id IGS_PE_STD_TODO_REF.person_id%TYPE,
3168: cp_s_student_todo_type IGS_PE_STD_TODO_REF.s_student_todo_type%TYPE,
3169: cp_sequence_number IGS_PE_STD_TODO_REF.sequence_number%TYPE,
3170: cp_course_cd IGS_PE_STD_TODO_REF.course_cd%TYPE) IS
3171: SELECT str.*,
3172: str.ROWID
3173: FROM IGS_PE_STD_TODO_REF str

Line 3170: cp_course_cd IGS_PE_STD_TODO_REF.course_cd%TYPE) IS

3166: CURSOR c_str (
3167: cp_person_id IGS_PE_STD_TODO_REF.person_id%TYPE,
3168: cp_s_student_todo_type IGS_PE_STD_TODO_REF.s_student_todo_type%TYPE,
3169: cp_sequence_number IGS_PE_STD_TODO_REF.sequence_number%TYPE,
3170: cp_course_cd IGS_PE_STD_TODO_REF.course_cd%TYPE) IS
3171: SELECT str.*,
3172: str.ROWID
3173: FROM IGS_PE_STD_TODO_REF str
3174: WHERE str.person_id = cp_person_id AND

Line 3173: FROM IGS_PE_STD_TODO_REF str

3169: cp_sequence_number IGS_PE_STD_TODO_REF.sequence_number%TYPE,
3170: cp_course_cd IGS_PE_STD_TODO_REF.course_cd%TYPE) IS
3171: SELECT str.*,
3172: str.ROWID
3173: FROM IGS_PE_STD_TODO_REF str
3174: WHERE str.person_id = cp_person_id AND
3175: str.s_student_todo_type = cp_s_student_todo_type AND
3176: str.sequence_number = cp_sequence_number AND
3177: str.course_cd = cp_course_cd AND

Line 3181: cp_person_id IGS_PE_STD_TODO_REF.person_id%TYPE,

3177: str.course_cd = cp_course_cd AND
3178: str.logical_delete_dt IS NULL
3179: FOR UPDATE NOWAIT;
3180: CURSOR c_str_chk (
3181: cp_person_id IGS_PE_STD_TODO_REF.person_id%TYPE,
3182: cp_s_student_todo_type IGS_PE_STD_TODO_REF.s_student_todo_type%TYPE,
3183: cp_sequence_number IGS_PE_STD_TODO_REF.sequence_number%TYPE) IS
3184: SELECT 'x'
3185: FROM IGS_PE_STD_TODO_REF str

Line 3182: cp_s_student_todo_type IGS_PE_STD_TODO_REF.s_student_todo_type%TYPE,

3178: str.logical_delete_dt IS NULL
3179: FOR UPDATE NOWAIT;
3180: CURSOR c_str_chk (
3181: cp_person_id IGS_PE_STD_TODO_REF.person_id%TYPE,
3182: cp_s_student_todo_type IGS_PE_STD_TODO_REF.s_student_todo_type%TYPE,
3183: cp_sequence_number IGS_PE_STD_TODO_REF.sequence_number%TYPE) IS
3184: SELECT 'x'
3185: FROM IGS_PE_STD_TODO_REF str
3186: WHERE str.person_id = cp_person_id AND

Line 3183: cp_sequence_number IGS_PE_STD_TODO_REF.sequence_number%TYPE) IS

3179: FOR UPDATE NOWAIT;
3180: CURSOR c_str_chk (
3181: cp_person_id IGS_PE_STD_TODO_REF.person_id%TYPE,
3182: cp_s_student_todo_type IGS_PE_STD_TODO_REF.s_student_todo_type%TYPE,
3183: cp_sequence_number IGS_PE_STD_TODO_REF.sequence_number%TYPE) IS
3184: SELECT 'x'
3185: FROM IGS_PE_STD_TODO_REF str
3186: WHERE str.person_id = cp_person_id AND
3187: str.s_student_todo_type = cp_s_student_todo_type AND

Line 3185: FROM IGS_PE_STD_TODO_REF str

3181: cp_person_id IGS_PE_STD_TODO_REF.person_id%TYPE,
3182: cp_s_student_todo_type IGS_PE_STD_TODO_REF.s_student_todo_type%TYPE,
3183: cp_sequence_number IGS_PE_STD_TODO_REF.sequence_number%TYPE) IS
3184: SELECT 'x'
3185: FROM IGS_PE_STD_TODO_REF str
3186: WHERE str.person_id = cp_person_id AND
3187: str.s_student_todo_type = cp_s_student_todo_type AND
3188: str.sequence_number = cp_sequence_number AND
3189: str.logical_delete_dt IS NULL;

Line 3351: /* UPDATE IGS_PE_STD_TODO_REF

3347: END IF;
3348: END LOOP; -- c_spc2
3349: END IF;
3350: -- Logically delete the str record
3351: /* UPDATE IGS_PE_STD_TODO_REF
3352: SET logical_delete_dt = SYSDATE
3353: WHERE CURRENT OF c_str;
3354: */
3355: --

Line 3358: -- igs_pe_std_todo_ref_pkg.update_row PROCEDURE call

3354: */
3355: --
3356: -- kdande; 23-Apr-2003; Bug# 2829262
3357: -- Added uoo_id parameter to the
3358: -- igs_pe_std_todo_ref_pkg.update_row PROCEDURE call
3359: --
3360: igs_pe_std_todo_ref_pkg.update_row (
3361: x_rowid => v_str_rec.ROWID,
3362: x_person_id => v_str_rec.person_id,

Line 3360: igs_pe_std_todo_ref_pkg.update_row (

3356: -- kdande; 23-Apr-2003; Bug# 2829262
3357: -- Added uoo_id parameter to the
3358: -- igs_pe_std_todo_ref_pkg.update_row PROCEDURE call
3359: --
3360: igs_pe_std_todo_ref_pkg.update_row (
3361: x_rowid => v_str_rec.ROWID,
3362: x_person_id => v_str_rec.person_id,
3363: x_s_student_todo_type => v_str_rec.s_student_todo_type,
3364: x_sequence_number => v_str_rec.sequence_number,

Line 3404: UPDATE IGS_PE_STD_TODO

3400: v_st_rec.sequence_number);
3401: FETCH c_st_lck INTO v_st_lck_rec;
3402: -- Logically delete the st record
3403: /*
3404: UPDATE IGS_PE_STD_TODO
3405: SET logical_delete_dt = SYSDATE
3406: WHERE CURRENT OF c_st_lck;
3407: */
3408: IGS_PE_STD_TODO_PKG.UPDATE_ROW(

Line 3408: IGS_PE_STD_TODO_PKG.UPDATE_ROW(

3404: UPDATE IGS_PE_STD_TODO
3405: SET logical_delete_dt = SYSDATE
3406: WHERE CURRENT OF c_st_lck;
3407: */
3408: IGS_PE_STD_TODO_PKG.UPDATE_ROW(
3409: X_ROWID => v_st_lck_rec.ROWID,
3410: X_PERSON_ID => v_st_lck_rec.PERSON_ID,
3411: X_S_STUDENT_TODO_TYPE => v_st_lck_rec.S_STUDENT_TODO_TYPE,
3412: X_SEQUENCE_NUMBER => v_st_lck_rec.SEQUENCE_NUMBER,