461: END;
462: END audp_get_cfosh_col;
463:
464: Function Audp_Get_Coh_Col(
465: p_course_cd IGS_PS_OWN_HIST_ALL.course_cd%TYPE ,
466: p_version_number IGS_PS_OWN_HIST_ALL.version_number%TYPE ,
467: p_org_unit_cd IGS_PS_OWN_HIST_ALL.org_unit_cd%TYPE ,
468: p_ou_start_dt IGS_PS_OWN_HIST_ALL.ou_start_dt%TYPE ,
469: p_hist_date IGS_PS_OWN_HIST_ALL.hist_start_dt%TYPE )
462: END audp_get_cfosh_col;
463:
464: Function Audp_Get_Coh_Col(
465: p_course_cd IGS_PS_OWN_HIST_ALL.course_cd%TYPE ,
466: p_version_number IGS_PS_OWN_HIST_ALL.version_number%TYPE ,
467: p_org_unit_cd IGS_PS_OWN_HIST_ALL.org_unit_cd%TYPE ,
468: p_ou_start_dt IGS_PS_OWN_HIST_ALL.ou_start_dt%TYPE ,
469: p_hist_date IGS_PS_OWN_HIST_ALL.hist_start_dt%TYPE )
470: RETURN NUMBER AS
463:
464: Function Audp_Get_Coh_Col(
465: p_course_cd IGS_PS_OWN_HIST_ALL.course_cd%TYPE ,
466: p_version_number IGS_PS_OWN_HIST_ALL.version_number%TYPE ,
467: p_org_unit_cd IGS_PS_OWN_HIST_ALL.org_unit_cd%TYPE ,
468: p_ou_start_dt IGS_PS_OWN_HIST_ALL.ou_start_dt%TYPE ,
469: p_hist_date IGS_PS_OWN_HIST_ALL.hist_start_dt%TYPE )
470: RETURN NUMBER AS
471:
464: Function Audp_Get_Coh_Col(
465: p_course_cd IGS_PS_OWN_HIST_ALL.course_cd%TYPE ,
466: p_version_number IGS_PS_OWN_HIST_ALL.version_number%TYPE ,
467: p_org_unit_cd IGS_PS_OWN_HIST_ALL.org_unit_cd%TYPE ,
468: p_ou_start_dt IGS_PS_OWN_HIST_ALL.ou_start_dt%TYPE ,
469: p_hist_date IGS_PS_OWN_HIST_ALL.hist_start_dt%TYPE )
470: RETURN NUMBER AS
471:
472: BEGIN -- audp_get_coh_col
465: p_course_cd IGS_PS_OWN_HIST_ALL.course_cd%TYPE ,
466: p_version_number IGS_PS_OWN_HIST_ALL.version_number%TYPE ,
467: p_org_unit_cd IGS_PS_OWN_HIST_ALL.org_unit_cd%TYPE ,
468: p_ou_start_dt IGS_PS_OWN_HIST_ALL.ou_start_dt%TYPE ,
469: p_hist_date IGS_PS_OWN_HIST_ALL.hist_start_dt%TYPE )
470: RETURN NUMBER AS
471:
472: BEGIN -- audp_get_coh_col
473: -- get the oldest column value (after a given date) for the percentage