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;
|