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_AS_GEN_003 dependencies on IGS_AS_SU_STMPTOUT

Line 34: FROM IGS_AS_SU_STMPTOUT suao,

30: --ijeddy, Bug 3201661, Grade Book.
31: DECLARE
32: CURSOR c_gsg IS
33: SELECT gsg.s_special_grade_type
34: FROM IGS_AS_SU_STMPTOUT suao,
35: IGS_AS_GRD_SCH_GRADE gsg
36: WHERE suao.person_id = p_person_id AND
37: suao.course_cd = p_course_cd AND
38: -- anilk, 22-Apr-2003, Bug# 2829262

Line 45: FROM IGS_AS_SU_STMPTOUT

41: suao.grading_schema_cd = gsg.grading_schema_cd AND
42: suao.version_number = gsg.version_number AND
43: suao.grade = gsg.grade AND
44: suao.outcome_dt IN (SELECT MAX(outcome_dt)
45: FROM IGS_AS_SU_STMPTOUT
46: WHERE person_id = suao.person_id AND
47: course_cd = suao.course_cd AND
48: -- anilk, 22-Apr-2003, Bug# 2829262
49: uoo_id = suao.uoo_id);

Line 238: IGS_AS_SU_STMPTOUT.translated_grading_schema_cd%TYPE;

234: v_gsg_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
235: v_gsg_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
236: v_gsg_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
237: v_suao_trans_grading_schema_cd
238: IGS_AS_SU_STMPTOUT.translated_grading_schema_cd%TYPE;
239: v_suao_trans_version_number
240: IGS_AS_SU_STMPTOUT.translated_version_number%TYPE;
241: v_suao_trans_grade IGS_AS_SU_STMPTOUT.translated_grade%TYPE;
242: v_gsg2_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;

Line 240: IGS_AS_SU_STMPTOUT.translated_version_number%TYPE;

236: v_gsg_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
237: v_suao_trans_grading_schema_cd
238: IGS_AS_SU_STMPTOUT.translated_grading_schema_cd%TYPE;
239: v_suao_trans_version_number
240: IGS_AS_SU_STMPTOUT.translated_version_number%TYPE;
241: v_suao_trans_grade IGS_AS_SU_STMPTOUT.translated_grade%TYPE;
242: v_gsg2_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
243: CURSOR c_sua (
244: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

Line 241: v_suao_trans_grade IGS_AS_SU_STMPTOUT.translated_grade%TYPE;

237: v_suao_trans_grading_schema_cd
238: IGS_AS_SU_STMPTOUT.translated_grading_schema_cd%TYPE;
239: v_suao_trans_version_number
240: IGS_AS_SU_STMPTOUT.translated_version_number%TYPE;
241: v_suao_trans_grade IGS_AS_SU_STMPTOUT.translated_grade%TYPE;
242: v_gsg2_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
243: CURSOR c_sua (
244: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
245: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,

Line 279: FROM IGS_AS_SU_STMPTOUT suao,

275: gsg.s_result_type,
276: suao.translated_grading_schema_cd,
277: suao.translated_version_number,
278: suao.translated_grade
279: FROM IGS_AS_SU_STMPTOUT suao,
280: IGS_AS_GRD_SCH_GRADE gsg
281: WHERE suao.person_id = cp_person_id AND
282: suao.course_cd = c_v_course_cd AND
283: -- anilk, 22-Apr-2003, Bug# 2829262

Line 510: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;

506: cst_enrolled CONSTANT VARCHAR2(10) := 'ENROLLED';
507: v_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
508: v_finalised_ind VARCHAR2(1);
509: v_sua_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
510: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
511: v_gsg_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
512: v_gsg_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
513: v_gsg_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
514: v_gsg_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;

Line 515: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;

511: v_gsg_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
512: v_gsg_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
513: v_gsg_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
514: v_gsg_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
515: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
516: v_suao_trans_grading_schema_cd
517: IGS_AS_SU_STMPTOUT.translated_grading_schema_cd%TYPE;
518: v_suao_trans_version_number
519: IGS_AS_SU_STMPTOUT.translated_version_number%TYPE;

Line 517: IGS_AS_SU_STMPTOUT.translated_grading_schema_cd%TYPE;

513: v_gsg_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
514: v_gsg_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
515: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
516: v_suao_trans_grading_schema_cd
517: IGS_AS_SU_STMPTOUT.translated_grading_schema_cd%TYPE;
518: v_suao_trans_version_number
519: IGS_AS_SU_STMPTOUT.translated_version_number%TYPE;
520: v_suao_trans_grade IGS_AS_SU_STMPTOUT.translated_grade%TYPE;
521: v_gsg2_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;

Line 519: IGS_AS_SU_STMPTOUT.translated_version_number%TYPE;

515: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
516: v_suao_trans_grading_schema_cd
517: IGS_AS_SU_STMPTOUT.translated_grading_schema_cd%TYPE;
518: v_suao_trans_version_number
519: IGS_AS_SU_STMPTOUT.translated_version_number%TYPE;
520: v_suao_trans_grade IGS_AS_SU_STMPTOUT.translated_grade%TYPE;
521: v_gsg2_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
522: v_released_date IGS_AS_SU_STMPTOUT.release_date%TYPE;
523: l_course_cd igs_en_su_attempt_all.course_cd%TYPE;

Line 520: v_suao_trans_grade IGS_AS_SU_STMPTOUT.translated_grade%TYPE;

516: v_suao_trans_grading_schema_cd
517: IGS_AS_SU_STMPTOUT.translated_grading_schema_cd%TYPE;
518: v_suao_trans_version_number
519: IGS_AS_SU_STMPTOUT.translated_version_number%TYPE;
520: v_suao_trans_grade IGS_AS_SU_STMPTOUT.translated_grade%TYPE;
521: v_gsg2_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
522: v_released_date IGS_AS_SU_STMPTOUT.release_date%TYPE;
523: l_course_cd igs_en_su_attempt_all.course_cd%TYPE;
524:

Line 522: v_released_date IGS_AS_SU_STMPTOUT.release_date%TYPE;

518: v_suao_trans_version_number
519: IGS_AS_SU_STMPTOUT.translated_version_number%TYPE;
520: v_suao_trans_grade IGS_AS_SU_STMPTOUT.translated_grade%TYPE;
521: v_gsg2_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
522: v_released_date IGS_AS_SU_STMPTOUT.release_date%TYPE;
523: l_course_cd igs_en_su_attempt_all.course_cd%TYPE;
524:
525: -- smaddali modified cursor for bug#4666657
526: CURSOR c_sua (cp_course_cd igs_en_su_attempt_all.course_Cd%TYPE ) IS

Line 552: FROM IGS_AS_SU_STMPTOUT suao,

548: suao.translated_grading_schema_cd,
549: suao.translated_version_number,
550: suao.translated_grade,
551: suao.release_date
552: FROM IGS_AS_SU_STMPTOUT suao,
553: IGS_AS_GRD_SCH_GRADE gsg
554: WHERE suao.person_id = p_person_id AND
555: suao.course_cd = cp_course_cd AND
556: -- anilk, 22-Apr-2003, Bug# 2829262

Line 1630: IGS_AS_SU_STMPTOUT.translated_grading_schema_cd%TYPE;

1626: v_gsg_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1627: v_gsg_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1628: v_gsg_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1629: v_suao_trans_grading_schema_cd
1630: IGS_AS_SU_STMPTOUT.translated_grading_schema_cd%TYPE;
1631: v_suao_trans_version_number
1632: IGS_AS_SU_STMPTOUT.translated_version_number%TYPE;
1633: v_suao_trans_grade IGS_AS_SU_STMPTOUT.translated_grade%TYPE;
1634: v_gsg2_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;

Line 1632: IGS_AS_SU_STMPTOUT.translated_version_number%TYPE;

1628: v_gsg_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1629: v_suao_trans_grading_schema_cd
1630: IGS_AS_SU_STMPTOUT.translated_grading_schema_cd%TYPE;
1631: v_suao_trans_version_number
1632: IGS_AS_SU_STMPTOUT.translated_version_number%TYPE;
1633: v_suao_trans_grade IGS_AS_SU_STMPTOUT.translated_grade%TYPE;
1634: v_gsg2_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1635: CURSOR c_sua (
1636: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

Line 1633: v_suao_trans_grade IGS_AS_SU_STMPTOUT.translated_grade%TYPE;

1629: v_suao_trans_grading_schema_cd
1630: IGS_AS_SU_STMPTOUT.translated_grading_schema_cd%TYPE;
1631: v_suao_trans_version_number
1632: IGS_AS_SU_STMPTOUT.translated_version_number%TYPE;
1633: v_suao_trans_grade IGS_AS_SU_STMPTOUT.translated_grade%TYPE;
1634: v_gsg2_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1635: CURSOR c_sua (
1636: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1637: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,

Line 1668: FROM IGS_AS_SU_STMPTOUT suao,

1664: gsg.s_result_type,
1665: suao.translated_grading_schema_cd,
1666: suao.translated_version_number,
1667: suao.translated_grade
1668: FROM IGS_AS_SU_STMPTOUT suao,
1669: IGS_AS_GRD_SCH_GRADE gsg
1670: WHERE suao.person_id = cp_person_id AND
1671: suao.course_cd = c_v_course_cd AND
1672: suao.uoo_id = cp_uoo_id AND

Line 1822: IGS_AS_SU_STMPTOUT.translated_grading_schema_cd%TYPE;

1818: v_gsg_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
1819: v_gsg_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
1820: v_gsg_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1821: v_suao_trans_grading_schema_cd
1822: IGS_AS_SU_STMPTOUT.translated_grading_schema_cd%TYPE;
1823: v_suao_trans_version_number
1824: IGS_AS_SU_STMPTOUT.translated_version_number%TYPE;
1825: v_suao_trans_grade IGS_AS_SU_STMPTOUT.translated_grade%TYPE;
1826: v_gsg2_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;

Line 1824: IGS_AS_SU_STMPTOUT.translated_version_number%TYPE;

1820: v_gsg_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1821: v_suao_trans_grading_schema_cd
1822: IGS_AS_SU_STMPTOUT.translated_grading_schema_cd%TYPE;
1823: v_suao_trans_version_number
1824: IGS_AS_SU_STMPTOUT.translated_version_number%TYPE;
1825: v_suao_trans_grade IGS_AS_SU_STMPTOUT.translated_grade%TYPE;
1826: v_gsg2_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1827: v_marks IGS_AS_SU_STMPTOUT.mark%TYPE;
1828: CURSOR c_sua (

Line 1825: v_suao_trans_grade IGS_AS_SU_STMPTOUT.translated_grade%TYPE;

1821: v_suao_trans_grading_schema_cd
1822: IGS_AS_SU_STMPTOUT.translated_grading_schema_cd%TYPE;
1823: v_suao_trans_version_number
1824: IGS_AS_SU_STMPTOUT.translated_version_number%TYPE;
1825: v_suao_trans_grade IGS_AS_SU_STMPTOUT.translated_grade%TYPE;
1826: v_gsg2_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1827: v_marks IGS_AS_SU_STMPTOUT.mark%TYPE;
1828: CURSOR c_sua (
1829: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

Line 1827: v_marks IGS_AS_SU_STMPTOUT.mark%TYPE;

1823: v_suao_trans_version_number
1824: IGS_AS_SU_STMPTOUT.translated_version_number%TYPE;
1825: v_suao_trans_grade IGS_AS_SU_STMPTOUT.translated_grade%TYPE;
1826: v_gsg2_s_result_type IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1827: v_marks IGS_AS_SU_STMPTOUT.mark%TYPE;
1828: CURSOR c_sua (
1829: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1830: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1831: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,

Line 1862: FROM IGS_AS_SU_STMPTOUT suao,

1858: suao.translated_grading_schema_cd,
1859: suao.translated_version_number,
1860: suao.translated_grade ,
1861: suao.mark
1862: FROM IGS_AS_SU_STMPTOUT suao,
1863: IGS_AS_GRD_SCH_GRADE gsg
1864: WHERE suao.person_id = cp_person_id AND
1865: suao.course_cd = c_v_course_cd AND
1866: suao.uoo_id = cp_uoo_id AND