APPS.IGS_AU_GEN_003 dependencies on IGS_EN_SU_ATTEMPT_H_ALL

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 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