APPS.IGS_AU_GEN_003 dependencies on IGS_EN_SU_ATTEMPT

Line 34: FROM igs_en_su_attempt

30: DECLARE
31: -- get count of students discontinued in this unit section
32: CURSOR cur_disc IS
33: SELECT COUNT(*)
34: FROM igs_en_su_attempt
35: WHERE uoo_id = p_uoo_id
36: AND unit_attempt_status = 'DISCONTIN' ;
37:
38: -- get count of students dropped in this unit section

Line 41: FROM igs_en_su_attempt

37:
38: -- get count of students dropped in this unit section
39: CURSOR cur_drop IS
40: SELECT COUNT(*)
41: FROM igs_en_su_attempt
42: WHERE uoo_id = p_uoo_id
43: AND unit_attempt_status = 'DROPPED' ;
44:
45: -- get unit section preferences

Line 689: p_person_id IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,

685:
686:
687: FUNCTION Audp_Get_Suah_Col(
688: p_column_name user_tab_columns.column_name%TYPE ,
689: p_person_id IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
690: p_course_cd IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
691: p_hist_end_dt IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE ,
692: p_uoo_id IGS_EN_SU_ATTEMPT_H_ALL.uoo_id%TYPE)
693: RETURN VARCHAR2 AS

Line 690: p_course_cd IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,

686:
687: FUNCTION Audp_Get_Suah_Col(
688: p_column_name user_tab_columns.column_name%TYPE ,
689: p_person_id IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
690: p_course_cd IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
691: p_hist_end_dt IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE ,
692: p_uoo_id IGS_EN_SU_ATTEMPT_H_ALL.uoo_id%TYPE)
693: RETURN VARCHAR2 AS
694: --

Line 691: p_hist_end_dt IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE ,

687: FUNCTION Audp_Get_Suah_Col(
688: p_column_name user_tab_columns.column_name%TYPE ,
689: p_person_id IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
690: p_course_cd IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
691: p_hist_end_dt IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE ,
692: p_uoo_id IGS_EN_SU_ATTEMPT_H_ALL.uoo_id%TYPE)
693: RETURN VARCHAR2 AS
694: --
695: -- Who When What

Line 692: p_uoo_id IGS_EN_SU_ATTEMPT_H_ALL.uoo_id%TYPE)

688: p_column_name user_tab_columns.column_name%TYPE ,
689: p_person_id IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
690: p_course_cd IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
691: p_hist_end_dt IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE ,
692: p_uoo_id IGS_EN_SU_ATTEMPT_H_ALL.uoo_id%TYPE)
693: RETURN VARCHAR2 AS
694: --
695: -- Who When What
696: -- knaraset 29-Apr-03 added p_uoo_id as parameter used the same in cursor c_suah,also removed the other parameter unit_cd,cal_type and sequence_number

Line 756: FROM IGS_EN_SU_ATTEMPT_H suah

752: cst_grading_schema_code, suah.grading_schema_code,
753: cst_enr_method_type, suah.enr_method_type,
754: --added by rvangala 01-OCT-2003. Enh Bug# 3052432
755: cst_core_indicator, suah.core_indicator_code)
756: FROM IGS_EN_SU_ATTEMPT_H suah
757: WHERE suah.person_id = p_person_id AND
758: suah.course_cd = p_course_cd AND
759: suah.uoo_id = p_uoo_id AND
760: suah.hist_start_dt >= p_hist_end_dt AND

Line 977: p_uoo_id IN IGS_EN_SU_ATTEMPT_H_ALL.uoo_id%TYPE

973: P_H_RULE_WAIVED_PERSON_ID IN NUMBER,
974: P_person_id IN NUMBER,
975: P_course_cd IN VARCHAR2,
976: P_hist_end_dt IN DATE,
977: p_uoo_id IN IGS_EN_SU_ATTEMPT_H_ALL.uoo_id%TYPE
978: )
979: RETURN NUMBER IS
980: ----------------------------------------------
981: -- This Function returns Rule_waived_person_id

Line 994: FROM IGS_EN_SU_ATTEMPT

990: --
991: ----------------------------------------------
992: CURSOR CUR_RWP IS
993: SELECT rule_waived_person_id
994: FROM IGS_EN_SU_ATTEMPT
995: WHERE person_id=p_person_id AND
996: course_cd = p_course_cd AND
997: uoo_id = p_uoo_id;
998: P_RWP NUMBER;