APPS.IGS_AU_GEN_003 dependencies on IGS_EN_SU_ATTEMPT_H_ALL

Line 74: p_person_id IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,

70: PRAGMA RESTRICT_REFERENCES(Enrp_Get_Sph_col, WNDS);
71:
72: Function Audp_Get_Suah_Col(
73: p_column_name user_tab_columns.column_name%TYPE ,
74: p_person_id IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
75: p_course_cd IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
76: p_hist_end_dt IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE,
77: p_uoo_id IGS_EN_SU_ATTEMPT_H_ALL.uoo_id%TYPE )
78: RETURN VARCHAR2;

Line 75: p_course_cd IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,

71:
72: Function Audp_Get_Suah_Col(
73: p_column_name user_tab_columns.column_name%TYPE ,
74: p_person_id IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
75: p_course_cd IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
76: p_hist_end_dt IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE,
77: p_uoo_id IGS_EN_SU_ATTEMPT_H_ALL.uoo_id%TYPE )
78: RETURN VARCHAR2;
79: PRAGMA RESTRICT_REFERENCES(Audp_Get_Suah_Col, WNDS);

Line 76: p_hist_end_dt IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE,

72: Function Audp_Get_Suah_Col(
73: p_column_name user_tab_columns.column_name%TYPE ,
74: p_person_id IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
75: p_course_cd IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
76: p_hist_end_dt IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE,
77: p_uoo_id IGS_EN_SU_ATTEMPT_H_ALL.uoo_id%TYPE )
78: RETURN VARCHAR2;
79: PRAGMA RESTRICT_REFERENCES(Audp_Get_Suah_Col, WNDS);
80:

Line 77: p_uoo_id IGS_EN_SU_ATTEMPT_H_ALL.uoo_id%TYPE )

73: p_column_name user_tab_columns.column_name%TYPE ,
74: p_person_id IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
75: p_course_cd IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
76: p_hist_end_dt IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE,
77: p_uoo_id IGS_EN_SU_ATTEMPT_H_ALL.uoo_id%TYPE )
78: RETURN VARCHAR2;
79: PRAGMA RESTRICT_REFERENCES(Audp_Get_Suah_Col, WNDS);
80:
81: Function Audp_Get_Suaoh_Col(

Line 109: p_uoo_id IN IGS_EN_SU_ATTEMPT_H_ALL.uoo_id%TYPE)

105: P_H_RULE_WAIVED_PERSON_ID IN NUMBER,
106: P_person_id IN NUMBER,
107: P_course_cd IN VARCHAR2,
108: P_hist_end_dt IN DATE,
109: p_uoo_id IN IGS_EN_SU_ATTEMPT_H_ALL.uoo_id%TYPE)
110: RETURN NUMBER;
111:
112: END igs_au_gen_003;