499: END;
500: END audp_get_coh_col;
501:
502: Function Audp_Get_Crch_Col(
503: p_course_cd IGS_PS_REF_CD_HIST_ALL.course_cd%TYPE ,
504: p_version_number IGS_PS_REF_CD_HIST_ALL.version_number%TYPE ,
505: p_reference_cd_type IGS_PS_REF_CD_HIST_ALL.reference_cd_type%TYPE ,
506: p_reference_cd IGS_PS_REF_CD_HIST_ALL.reference_cd%TYPE ,
507: p_hist_date IGS_PS_REF_CD_HIST_ALL.hist_start_dt%TYPE )
500: END audp_get_coh_col;
501:
502: Function Audp_Get_Crch_Col(
503: p_course_cd IGS_PS_REF_CD_HIST_ALL.course_cd%TYPE ,
504: p_version_number IGS_PS_REF_CD_HIST_ALL.version_number%TYPE ,
505: p_reference_cd_type IGS_PS_REF_CD_HIST_ALL.reference_cd_type%TYPE ,
506: p_reference_cd IGS_PS_REF_CD_HIST_ALL.reference_cd%TYPE ,
507: p_hist_date IGS_PS_REF_CD_HIST_ALL.hist_start_dt%TYPE )
508: RETURN VARCHAR2 AS
501:
502: Function Audp_Get_Crch_Col(
503: p_course_cd IGS_PS_REF_CD_HIST_ALL.course_cd%TYPE ,
504: p_version_number IGS_PS_REF_CD_HIST_ALL.version_number%TYPE ,
505: p_reference_cd_type IGS_PS_REF_CD_HIST_ALL.reference_cd_type%TYPE ,
506: p_reference_cd IGS_PS_REF_CD_HIST_ALL.reference_cd%TYPE ,
507: p_hist_date IGS_PS_REF_CD_HIST_ALL.hist_start_dt%TYPE )
508: RETURN VARCHAR2 AS
509:
502: Function Audp_Get_Crch_Col(
503: p_course_cd IGS_PS_REF_CD_HIST_ALL.course_cd%TYPE ,
504: p_version_number IGS_PS_REF_CD_HIST_ALL.version_number%TYPE ,
505: p_reference_cd_type IGS_PS_REF_CD_HIST_ALL.reference_cd_type%TYPE ,
506: p_reference_cd IGS_PS_REF_CD_HIST_ALL.reference_cd%TYPE ,
507: p_hist_date IGS_PS_REF_CD_HIST_ALL.hist_start_dt%TYPE )
508: RETURN VARCHAR2 AS
509:
510: BEGIN -- audp_get_crch_col
503: p_course_cd IGS_PS_REF_CD_HIST_ALL.course_cd%TYPE ,
504: p_version_number IGS_PS_REF_CD_HIST_ALL.version_number%TYPE ,
505: p_reference_cd_type IGS_PS_REF_CD_HIST_ALL.reference_cd_type%TYPE ,
506: p_reference_cd IGS_PS_REF_CD_HIST_ALL.reference_cd%TYPE ,
507: p_hist_date IGS_PS_REF_CD_HIST_ALL.hist_start_dt%TYPE )
508: RETURN VARCHAR2 AS
509:
510: BEGIN -- audp_get_crch_col
511: -- get the oldest column value (after a given date) for the descritpion