APPS.IGS_AU_GEN_003 dependencies on IGS_EN_SU_ATTEMPT_H

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