SFKFUNC
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);
SFKWDRL
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;