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_005 dependencies on IGS_EN_STDNT_PS_ATT

Line 188: v_course_cd igs_en_stdnt_ps_att.course_cd%TYPE;

184: v_rule_text igs_ru_named_rule.rule_text%TYPE;
185: v_message_text igs_ru_named_rule.rule_text%TYPE;
186: v_rule_status VARCHAR2 (50);
187: v_ssp_sequence_number igs_pr_s_scratch_pad.sequence_number%TYPE;
188: v_course_cd igs_en_stdnt_ps_att.course_cd%TYPE;
189: v_version_number igs_en_stdnt_ps_att.version_number%TYPE;
190: CURSOR c_cvr IS
191: SELECT igs_ru_gen_003.rulp_get_rule (rul_sequence_number)
192: FROM igs_ps_ver_ru

Line 189: v_version_number igs_en_stdnt_ps_att.version_number%TYPE;

185: v_message_text igs_ru_named_rule.rule_text%TYPE;
186: v_rule_status VARCHAR2 (50);
187: v_ssp_sequence_number igs_pr_s_scratch_pad.sequence_number%TYPE;
188: v_course_cd igs_en_stdnt_ps_att.course_cd%TYPE;
189: v_version_number igs_en_stdnt_ps_att.version_number%TYPE;
190: CURSOR c_cvr IS
191: SELECT igs_ru_gen_003.rulp_get_rule (rul_sequence_number)
192: FROM igs_ps_ver_ru
193: WHERE course_cd = v_course_cd

Line 1416: FROM igs_en_stdnt_ps_att sca,

1412: CURSOR c_crv_cow IS
1413: SELECT crv.course_type,
1414: cow.org_unit_cd,
1415: cow.ou_start_dt
1416: FROM igs_en_stdnt_ps_att sca,
1417: igs_ps_ver crv,
1418: igs_ps_own cow
1419: WHERE sca.person_id = p_person_id
1420: AND sca.course_cd = p_course_cd

Line 1508: -- IGS_EN_STDNT_PS_ATT that are applicable to a progression calendar.

1504: ) RETURN VARCHAR2 IS
1505: gv_other_detail VARCHAR2 (255);
1506: BEGIN -- IGS_PR_get_sca_state
1507: -- Routine to determine the state of unit attempts for a nominated
1508: -- IGS_EN_STDNT_PS_ATT that are applicable to a progression calendar.
1509: --This routine can return one of four outcomes :
1510: --NONE There are no unit attempts within the calendar
1511: --FINAL All required /entered grades are finalised
1512: --RECOMMEND There are recommended grades which will contribute to the calendar

Line 1534: v_original_course_cd igs_en_stdnt_ps_att.course_cd%TYPE;

1530: v_grading_schema_cd igs_as_su_stmptout.grading_schema_cd%TYPE;
1531: v_gs_version_number igs_as_su_stmptout.version_number%TYPE;
1532: v_grade igs_as_su_stmptout.grade%TYPE;
1533: v_mark igs_as_su_stmptout.mark%TYPE;
1534: v_original_course_cd igs_en_stdnt_ps_att.course_cd%TYPE;
1535: --
1536: -- kdande; 22-Apr-2003; Bug# 2829262
1537: -- Added uoo_id field to the SELECT clause of cursor c_sua
1538: --