Useful Banner procs and funcs

   PROCEDURE p_validate_rsts_by_date (
             p_rsts_code        IN sftregs.sftregs_rsts_code%TYPE,
             p_rsts_date        IN sftregs.sftregs_rsts_date%TYPE,
             p_term_code        IN sftregs.sftregs_term_code%TYPE,
             p_ptrm_code        IN sftregs.sftregs_ptrm_code%TYPE,
             p_crn              IN sftregs.sftregs_crn%TYPE,
             p_dunt_code        IN sftregs.sftregs_dunt_code%TYPE,
             p_start_date       IN sftregs.sftregs_start_date%TYPE,
             p_completion_date  IN sftregs.sftregs_completion_date%TYPE,
             p_err_out          OUT VARCHAR2);

  PROCEDURE P_CalcCharges (
                      pidm_in       IN  tbraccd.tbraccd_pidm%TYPE,
                      term_in       IN  tbraccd.tbraccd_term_code%TYPE,
                      orig_chgs     OUT tbraccd.tbraccd_amount%TYPE,
                      non_orig_chgs OUT tbraccd.tbraccd_amount%TYPE,
                      net_inst_chgs OUT tbraccd.tbraccd_amount%TYPE);
--
  FUNCTION F_PeriodDate (
                       pidm_in  IN  sfrstcr.sfrstcr_pidm%TYPE,
                       term_in  IN  sfrstcr.sfrstcr_term_code%TYPE,
                       type_in  IN  varchar2)
         RETURN DATE;
  PRAGMA RESTRICT_REFERENCES(F_PeriodDate, WNDS);
--
  FUNCTION F_CountBreakDays (
                      term_in      IN  sortbrk.sortbrk_term_code%TYPE,
                      from_date_in IN  sortbrk.sortbrk_start_date%TYPE,
                      to_date_in   IN  sortbrk.sortbrk_end_date%TYPE)
         RETURN NUMBER;
  PRAGMA RESTRICT_REFERENCES(F_CountBreakDays, WNDS);
--
  FUNCTION F_CountEnrlBreakDays (
                      pidm_in       IN  sfrwdrl.sfrwdrl_pidm%TYPE,
                      term_in       IN  sortbrk.sortbrk_term_code%TYPE,
                      start_date_in IN  sortbrk.sortbrk_start_date%TYPE,
                      end_date_in   IN  sortbrk.sortbrk_end_date%TYPE)
         RETURN NUMBER;
  PRAGMA RESTRICT_REFERENCES(F_CountEnrlBreakDays, WNDS);
--
  FUNCTION F_CountAttendBreakDays (
                      pidm_in       IN  sfrwdrl.sfrwdrl_pidm%TYPE,
                      term_in       IN  sortbrk.sortbrk_term_code%TYPE,
                      start_date_in IN  sortbrk.sortbrk_start_date%TYPE,
                      wdrl_date_in  IN  sortbrk.sortbrk_end_date%TYPE)
         RETURN NUMBER;
  PRAGMA RESTRICT_REFERENCES(F_CountAttendBreakDays, WNDS);
--
  FUNCTION F_CalcEnrlDays (
                      pidm_in       IN  sfrwdrl.sfrwdrl_pidm%TYPE,
                      term_in       IN  sfrwdrl.sfrwdrl_term_code%TYPE,
                      start_date_in IN  sfrwdrl.sfrwdrl_enrl_start_date%TYPE,
                      end_date_in   IN  sfrwdrl.sfrwdrl_enrl_end_date%TYPE)
         RETURN NUMBER;
  PRAGMA RESTRICT_REFERENCES(F_CalcEnrlDays, WNDS);
--
  FUNCTION F_CalcAttendDays (
                      pidm_in       IN  sfrwdrl.sfrwdrl_pidm%TYPE,
                      term_in       IN  sfrwdrl.sfrwdrl_term_code%TYPE,
                      start_date_in IN  sfrwdrl.sfrwdrl_enrl_start_date%TYPE,
                      wdrl_date_in  IN  sfrwdrl.sfrwdrl_eff_wdrl_date%TYPE,
                      leave_days_in IN  sfrwdrl.sfrwdrl_leave_days%TYPE)
         RETURN NUMBER;
  PRAGMA RESTRICT_REFERENCES(F_CalcAttendDays, WNDS);
--
  FUNCTION F_WD_Exists (
                      pidm_in       IN  sfrwdrl.sfrwdrl_pidm%TYPE,
                      aidy_in       IN  stvterm.stvterm_fa_proc_yr%TYPE,
                      term_in       IN  sfrwdrl.sfrwdrl_term_code%TYPE)
         RETURN NUMBER;
  PRAGMA RESTRICT_REFERENCES(F_WD_Exists, WNDS, WNPS, RNPS);
--
  FUNCTION F_TIV_WD_Exists (
                      pidm_in       IN  sfrwdrl.sfrwdrl_pidm%TYPE,
                      aidy_in       IN  stvterm.stvterm_fa_proc_yr%TYPE,
                      term_in       IN  sfrwdrl.sfrwdrl_term_code%TYPE)
         RETURN NUMBER;
  PRAGMA RESTRICT_REFERENCES(F_TIV_WD_Exists, WNDS, WNPS, RNPS);
--
  FUNCTION f_check_olr_enrl (
                        pidm_in       IN  sfrwdrl.sfrwdrl_pidm%TYPE,
                        term_in       IN  sfrwdrl.sfrwdrl_term_code%TYPE)
          RETURN BOOLEAN;

   PROCEDURE p_get_olr_dates  (
                        pidm_in       IN  sfrwdrl.sfrwdrl_pidm%TYPE,
                        term_in       IN  sfrwdrl.sfrwdrl_term_code%TYPE,
                        start_dateout OUT sfrareg.sfrareg_start_date%TYPE,
                        end_dateout   OUT sfrareg.sfrareg_completion_date%TYPE);

    FUNCTION F_Cal_MidPoint (
                      term_in       IN  sortbrk.sortbrk_term_code%TYPE,
                      start_date_in IN  sortbrk.sortbrk_start_date%TYPE,
                      end_date_in  IN sortbrk.sortbrk_end_date%TYPE  )
         RETURN DATE;