APPS.IGS_AU_GEN_003 dependencies on USER_TAB_COLUMNS

Line 102: p_column_name IN user_tab_columns.column_name%TYPE ,

98: END audp_get_enrs_stat;
99:
100:
101: FUNCTION Audp_Get_Gach_Col(
102: p_column_name IN user_tab_columns.column_name%TYPE ,
103: p_person_id IN NUMBER ,
104: p_create_dt IN DATE ,
105: p_grd_cal_type IN VARCHAR2 ,
106: p_grd_ci_sequence_number IN NUMBER ,

Line 192: p_column_name user_tab_columns.column_name%TYPE ,

188:
189: FUNCTION Audp_Get_Grh_Col(
190: p_person_id IGS_GR_GRADUAND_HIST_ALL.person_id%TYPE ,
191: p_create_dt IGS_GR_GRADUAND_HIST_ALL.create_dt%TYPE ,
192: p_column_name user_tab_columns.column_name%TYPE ,
193: p_hist_dt IGS_GR_GRADUAND_HIST_ALL.hist_start_dt%TYPE )
194: RETURN VARCHAR2 AS
195: BEGIN -- audp_get_grh_col
196: -- Get the oldest column value(after a given date) for a

Line 277: p_column_name IN user_tab_columns.column_name%TYPE ,

273:
274:
275:
276: FUNCTION Audp_Get_Ih_Col(
277: p_column_name IN user_tab_columns.column_name%TYPE ,
278: p_institution_cd IN IGS_OR_INST_HIST_ALL.institution_cd%TYPE ,
279: p_hist_end_dt IN IGS_OR_INST_HIST_ALL.hist_end_dt%TYPE )
280: RETURN VARCHAR2 AS
281: /*

Line 375: p_column_name IN user_tab_columns.column_name%TYPE ,

371:
372:
373:
374: FUNCTION Audp_Get_Ouh_Col(
375: p_column_name IN user_tab_columns.column_name%TYPE ,
376: p_org_unit_cd IN IGS_OR_UNIT_HIST_ALL.institution_cd%TYPE ,
377: p_ou_start_dt IN IGS_OR_UNIT_HIST_ALL.ou_start_dt%TYPE ,
378: p_hist_end_dt IN IGS_OR_UNIT_HIST_ALL.hist_end_dt%TYPE )
379: RETURN VARCHAR2 AS

Line 433: p_column_name IN user_tab_columns.column_name%TYPE ,

429: END audp_get_ouh_col;
430:
431:
432: FUNCTION Audp_Get_Scah_Col(
433: p_column_name IN user_tab_columns.column_name%TYPE ,
434: p_person_id IN IGS_AS_SC_ATTEMPT_H_ALL.person_id%TYPE ,
435: p_course_cd IN IGS_AS_SC_ATTEMPT_H_ALL.course_cd%TYPE ,
436: p_hist_end_dt IN IGS_AS_SC_ATTEMPT_H_ALL.hist_end_dt%TYPE )
437: RETURN VARCHAR2 AS

Line 688: p_column_name user_tab_columns.column_name%TYPE ,

684: END Enrp_Get_Sph_col;
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)

Line 806: p_column_name IN user_tab_columns.column_name%TYPE ,

802: END audp_get_suah_col;
803:
804:
805: FUNCTION Audp_Get_Suaoh_Col(
806: p_column_name IN user_tab_columns.column_name%TYPE ,
807: p_person_id IN NUMBER ,
808: p_course_cd IN VARCHAR2 ,
809: p_unit_cd IN VARCHAR2 ,
810: p_cal_type IN VARCHAR2 ,

Line 884: p_column_name IN user_tab_columns.column_name%TYPE ,

880: END audp_get_suaoh_col;
881:
882:
883: FUNCTION Audp_Get_Susah_Col(
884: p_column_name IN user_tab_columns.column_name%TYPE ,
885: p_person_id IN NUMBER ,
886: p_course_cd IN VARCHAR2 ,
887: p_unit_set_cd IN VARCHAR2 ,
888: p_sequence_number IN NUMBER ,