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

Line 523: l_course_cd igs_en_su_attempt_all.course_cd%TYPE;

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
527: SELECT sut.transfer_course_cd , sua.unit_attempt_status

Line 526: CURSOR c_sua (cp_course_cd igs_en_su_attempt_all.course_Cd%TYPE ) IS

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
527: SELECT sut.transfer_course_cd , sua.unit_attempt_status
528: FROM IGS_PS_STDNT_UNT_TRN sut,
529: IGS_EN_SU_ATTEMPT sua
530: WHERE sut.person_id = p_person_id AND

Line 695: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,

691: END assp_get_sua_outcome;
692: FUNCTION assp_get_supp_cal(
693: p_exam_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
694: p_exam_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
695: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
696: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
697: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
698: p_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
699: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,

Line 696: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,

692: FUNCTION assp_get_supp_cal(
693: p_exam_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
694: p_exam_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
695: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
696: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
697: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
698: p_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
699: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
700: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,

Line 697: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,

693: p_exam_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
694: p_exam_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
695: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
696: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
697: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
698: p_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
699: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
700: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
701: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,

Line 698: p_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,

694: p_exam_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
695: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
696: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
697: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
698: p_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
699: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
700: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
701: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
702: p_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,

Line 699: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,

695: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
696: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
697: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
698: p_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
699: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
700: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
701: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
702: p_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
703: p_unit_mode IN IGS_AS_UNIT_CLASS_ALL.unit_mode%TYPE ,

Line 700: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,

696: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
697: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
698: p_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
699: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
700: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
701: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
702: p_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
703: p_unit_mode IN IGS_AS_UNIT_CLASS_ALL.unit_mode%TYPE ,
704: p_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,

Line 701: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,

697: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
698: p_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
699: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
700: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
701: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
702: p_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
703: p_unit_mode IN IGS_AS_UNIT_CLASS_ALL.unit_mode%TYPE ,
704: p_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
705: p_ass_id IN IGS_AS_UNITASS_ITEM_ALL.ass_id%TYPE )

Line 702: p_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,

698: p_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
699: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
700: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
701: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
702: p_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
703: p_unit_mode IN IGS_AS_UNIT_CLASS_ALL.unit_mode%TYPE ,
704: p_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
705: p_ass_id IN IGS_AS_UNITASS_ITEM_ALL.ass_id%TYPE )
706: RETURN VARCHAR2 IS

Line 704: p_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,

700: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
701: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
702: p_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
703: p_unit_mode IN IGS_AS_UNIT_CLASS_ALL.unit_mode%TYPE ,
704: p_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
705: p_ass_id IN IGS_AS_UNITASS_ITEM_ALL.ass_id%TYPE )
706: RETURN VARCHAR2 IS
707: gv_other_detail VARCHAR2(1000);
708: -- anilk, 22-Apr-2003, Bug# 2829262

Line 1501: FROM igs_en_su_attempt_all sua,

1497: AND spa.person_id = p_person_id
1498: AND spa.course_cd = p_course_cd
1499: AND ( EXISTS (
1500: SELECT 1
1501: FROM igs_en_su_attempt_all sua,
1502: igs_ca_teach_to_load_v ttl
1503: WHERE sua.person_id = spa.person_id
1504: AND sua.course_cd = spa.course_cd
1505: AND sua.cal_type = ttl.teach_cal_type