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_PLAN_UTILS dependencies on IGS_EN_SU_ATTEMPT_ALL

Line 824: SELECT 'X' FROM igs_en_su_attempt_all sua, igs_ps_unit_ofr_opt_all uoo

820: l_row_id ROWID;
821: l_warning_id igs_en_std_warnings.warning_id%TYPE;
822: l_deny_warn VARCHAR2(20);
823: CURSOR c_unit_sec_rep(cp_uoo_id IN NUMBER) IS
824: SELECT 'X' FROM igs_en_su_attempt_all sua, igs_ps_unit_ofr_opt_all uoo
825: WHERE uoo.uoo_id = cp_uoo_id
826: AND sua.person_id = p_n_person_id
827: AND sua.course_cd = p_c_program_code
828: AND sua.core_indicator_code = 'CORE'

Line 1453: FROM igs_en_su_attempt_all sua,

1449: CURSOR c_sub_sua (cp_person_id IN NUMBER, cp_course_cd IN VARCHAR2, cp_uoo_id IN NUMBER) IS
1450: SELECT sua.unit_cd || '/' || sua.unit_class AS UNIT_SECTION,
1451: sua.uoo_id,
1452: sua.core_indicator_code AS CORE
1453: FROM igs_en_su_attempt_all sua,
1454: igs_ps_unit_ofr_opt_all uoo
1455: WHERE sua.person_id = cp_person_id
1456: AND sua.course_cd = cp_course_cd
1457: AND sua.uoo_id = uoo.uoo_id

Line 1547: FROM IGS_EN_SU_ATTEMPT_ALL

1543: program_cd IN VARCHAR2,
1544: p_uoo_ids IN VARCHAR2) AS
1545: CURSOR cur_sua(cp_person_id IN NUMBER,cp_program_cd IN VARCHAR2,cp_uoo_id IN NUMBER) IS
1546: SELECT *
1547: FROM IGS_EN_SU_ATTEMPT_ALL
1548: WHERE person_id = cp_person_id
1549: AND course_cd = cp_program_cd
1550: AND uoo_Id = cp_uoo_Id;
1551:

Line 1558: old_rec igs_en_su_attempt_all%rowTYPE;

1554: FROM igs_ps_rsv_ext rsv
1555: WHERE rsv_ext_id = cp_rsv_ext_id FOR UPDATE;
1556:
1557:
1558: old_rec igs_en_su_attempt_all%rowTYPE;
1559: new_rec igs_en_su_attempt_all%ROWTYPE;
1560: l_uoo_ids varchar2(30);
1561: l_cur_uoo_id varchar2(30);
1562: pos number;

Line 1559: new_rec igs_en_su_attempt_all%ROWTYPE;

1555: WHERE rsv_ext_id = cp_rsv_ext_id FOR UPDATE;
1556:
1557:
1558: old_rec igs_en_su_attempt_all%rowTYPE;
1559: new_rec igs_en_su_attempt_all%ROWTYPE;
1560: l_uoo_ids varchar2(30);
1561: l_cur_uoo_id varchar2(30);
1562: pos number;
1563: v_message_name VARCHAR2(30);

Line 1649: FROM igs_en_su_attempt_all sua,

1645: cp_c_load_cal IN VARCHAR2,
1646: cp_n_seq_num IN NUMBER) IS
1647: SELECT sua.ROWID ROW_ID,
1648: sua.uoo_id
1649: FROM igs_en_su_attempt_all sua,
1650: igs_ca_teach_to_load_v rel
1651: WHERE sua.person_id = cp_n_person_id
1652: AND sua.course_cd = cp_c_program_code
1653: AND sua.cal_type = rel.teach_cal_type

Line 2171: FROM IGS_EN_SU_ATTEMPT_ALL

2167: program_cd IN VARCHAR2,
2168: p_uoo_ids IN VARCHAR2) AS
2169: CURSOR cur_sua(cp_person_id IN NUMBER,cp_program_cd IN VARCHAR2,cp_uoo_id IN NUMBER) IS
2170: SELECT *
2171: FROM IGS_EN_SU_ATTEMPT_ALL
2172: WHERE person_id = cp_person_id
2173: AND course_cd = cp_program_cd
2174: AND uoo_Id = cp_uoo_Id;
2175:

Line 2183: old_rec igs_en_su_attempt_all%rowTYPE;

2179: WHERE rsv_ext_id = cp_rsv_ext_id FOR UPDATE;
2180:
2181: l_cur_igs_ps_rsv_ext cur_igs_ps_rsv_ext%ROWTYPE;
2182: l_rsv_ext_id igs_ps_rsv_ext.rsv_ext_id%TYPE;
2183: old_rec igs_en_su_attempt_all%rowTYPE;
2184: new_rec igs_en_su_attempt_all%ROWTYPE;
2185: l_uoo_ids varchar2(30);
2186: l_cur_uoo_id varchar2(30);
2187: pos number;

Line 2184: new_rec igs_en_su_attempt_all%ROWTYPE;

2180:
2181: l_cur_igs_ps_rsv_ext cur_igs_ps_rsv_ext%ROWTYPE;
2182: l_rsv_ext_id igs_ps_rsv_ext.rsv_ext_id%TYPE;
2183: old_rec igs_en_su_attempt_all%rowTYPE;
2184: new_rec igs_en_su_attempt_all%ROWTYPE;
2185: l_uoo_ids varchar2(30);
2186: l_cur_uoo_id varchar2(30);
2187: pos number;
2188: v_message_name VARCHAR2(30);

Line 2191: p_sua_rec OUT NOCOPY igs_en_su_attempt_all%ROWTYPE ) AS

2187: pos number;
2188: v_message_name VARCHAR2(30);
2189:
2190: PROCEDURE get_old_sua (p_person_id IN NUMBER,p_program_cd IN VARCHAR2,p_uoo_id IN NUMBER,
2191: p_sua_rec OUT NOCOPY igs_en_su_attempt_all%ROWTYPE ) AS
2192: PRAGMA AUTONOMOUS_TRANSACTION;
2193:
2194: CURSOR c_old_sua IS
2195: SELECT *

Line 2196: FROM IGS_EN_SU_ATTEMPT_ALL

2192: PRAGMA AUTONOMOUS_TRANSACTION;
2193:
2194: CURSOR c_old_sua IS
2195: SELECT *
2196: FROM IGS_EN_SU_ATTEMPT_ALL
2197: WHERE person_id = p_person_id
2198: AND course_cd = p_program_cd
2199: AND uoo_Id = p_uoo_Id;
2200: c_old_sua_rec c_old_sua%ROWTYPE;

Line 2289: FUNCTION get_sua_fin_mark(p_person_id IN igs_en_su_attempt_all.person_id%TYPE,

2285:
2286: END drop_submit;
2287:
2288:
2289: FUNCTION get_sua_fin_mark(p_person_id IN igs_en_su_attempt_all.person_id%TYPE,
2290: p_course_cd IN igs_en_su_attempt_all.course_Cd%TYPE,
2291: p_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE)
2292: RETURN NUMBER IS
2293:

Line 2290: p_course_cd IN igs_en_su_attempt_all.course_Cd%TYPE,

2286: END drop_submit;
2287:
2288:
2289: FUNCTION get_sua_fin_mark(p_person_id IN igs_en_su_attempt_all.person_id%TYPE,
2290: p_course_cd IN igs_en_su_attempt_all.course_Cd%TYPE,
2291: p_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE)
2292: RETURN NUMBER IS
2293:
2294: CURSOR c_suao IS

Line 2291: p_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE)

2287:
2288:
2289: FUNCTION get_sua_fin_mark(p_person_id IN igs_en_su_attempt_all.person_id%TYPE,
2290: p_course_cd IN igs_en_su_attempt_all.course_Cd%TYPE,
2291: p_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE)
2292: RETURN NUMBER IS
2293:
2294: CURSOR c_suao IS
2295: SELECT susv.mark

Line 2314: FUNCTION get_sua_fin_grade(p_person_id IN igs_en_su_attempt_all.person_id%TYPE,

2310: CLOSE c_suao;
2311: RETURN l_mark;
2312: END get_sua_fin_mark;
2313:
2314: FUNCTION get_sua_fin_grade(p_person_id IN igs_en_su_attempt_all.person_id%TYPE,
2315: p_course_cd IN igs_en_su_attempt_all.course_Cd%TYPE,
2316: p_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE)
2317: RETURN VARCHAR2 IS
2318:

Line 2315: p_course_cd IN igs_en_su_attempt_all.course_Cd%TYPE,

2311: RETURN l_mark;
2312: END get_sua_fin_mark;
2313:
2314: FUNCTION get_sua_fin_grade(p_person_id IN igs_en_su_attempt_all.person_id%TYPE,
2315: p_course_cd IN igs_en_su_attempt_all.course_Cd%TYPE,
2316: p_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE)
2317: RETURN VARCHAR2 IS
2318:
2319: CURSOR c_suao IS

Line 2316: p_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE)

2312: END get_sua_fin_mark;
2313:
2314: FUNCTION get_sua_fin_grade(p_person_id IN igs_en_su_attempt_all.person_id%TYPE,
2315: p_course_cd IN igs_en_su_attempt_all.course_Cd%TYPE,
2316: p_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE)
2317: RETURN VARCHAR2 IS
2318:
2319: CURSOR c_suao IS
2320: SELECT susv.grade