...
GVATRMP does not seem capable of crosswalking values.
XB11
Custom
cos_sv_mis_xb_bp.f_get_wsch
STVACCT_CODE = lv_acct_mth = 'W' OR lv_acct_mth = 'L' OR lv_acct_mth = 'WE' then returns the sum of SSRMEET_HRS_WEEK for crn and term, else return default 8888.88
| Expand |
|---|
|
| Code Block |
|---|
FUNCTION f_get_wsch( p_acct_code STVACCT.STVACCT_CODE%TYPE,
p_crn SSBSECT.SSBSECT_CRN%TYPE,
p_term STVTERM.STVTERM_CODE%TYPE )
RETURN VARCHAR2
IS
lv_wsch NUMBER:=0;
lv_acct_mth STVACCT.STVACCT_CODE%TYPE;
CURSOR ssrmeet_c( p_crn SSBSECT.SSBSECT_CRN%TYPE,
p_term_code SSBSECT.SSBSECT_TERM_CODE%TYPE
) IS
SELECT *
FROM ssrmeet
WHERE ssrmeet_crn = p_crn
AND ssrmeet_term_code = p_term_code;
BEGIN
-- Get Accounting Method
lv_acct_mth := f_get_acct_mthd(p_acct_code);
IF lv_acct_mth IS NOT NULL AND
( lv_acct_mth = 'W' OR
lv_acct_mth = 'L' OR lv_acct_mth = 'WE')
THEN
-- Calculate WSCH according with Chris' tech specification
-- you need a cursor to get the ssrmeet rows using the crn, and term
FOR lv_ssrmeet_rec IN ssrmeet_c(p_crn, p_term) LOOP
-- lv_wsch := NVL( NVL(lv_ssrmeet_rec.ssrmeet_hrs_week, sv_acad_calendar_bp.F_Calc_weekcontact_Hrs ( lv_ssrmeet_rec)),0) + lv_wsch; -- C3SC Mod JR 08/01/2007
lv_wsch := NVL(lv_ssrmeet_rec.ssrmeet_hrs_week, 0) + lv_wsch; -- C3SC Mod JR 12/05/2007
END LOOP;
RETURN (lv_wsch);
ELSE
RETURN 8888.88;
END IF;
END f_get_wsch; |
|
Baseline
sv_mis_xb_bp.f_get_wsch
STVACCT_CODE = lv_acct_mth = 'W' OR lv_acct_mth = 'L' then returns the sum of SSRMEET_HRS_WEEK for crn and term, else return default 8888.88
| Expand |
|---|
|
| Code Block |
|---|
FUNCTION f_get_wsch( p_acct_code STVACCT.STVACCT_CODE%TYPE,
p_crn SSBSECT.SSBSECT_CRN%TYPE,
p_term STVTERM.STVTERM_CODE%TYPE )
RETURN VARCHAR2
IS
lv_wsch NUMBER:=0;
lv_acct_mth STVACCT.STVACCT_CODE%TYPE;
CURSOR ssrmeet_c( p_crn SSBSECT.SSBSECT_CRN%TYPE,
p_term_code SSBSECT.SSBSECT_TERM_CODE%TYPE
) IS
SELECT *
FROM ssrmeet
WHERE ssrmeet_crn = p_crn
AND ssrmeet_term_code = p_term_code;
BEGIN
-- Get Accounting Method
lv_acct_mth := f_get_acct_mthd(p_acct_code);
IF lv_acct_mth IS NOT NULL AND
( lv_acct_mth = 'W' OR
lv_acct_mth = 'L' )
THEN
-- Calculate WSCH according with Chris' tech specification
-- you need a cursor to get the ssrmeet rows using the crn, and term
FOR lv_ssrmeet_rec IN ssrmeet_c(p_crn, p_term) LOOP
-- lv_wsch := NVL( NVL(lv_ssrmeet_rec.ssrmeet_hrs_week, sv_acad_calendar_bp.F_Calc_weekcontact_Hrs ( lv_ssrmeet_rec)),0) + lv_wsch; -- C3SC Mod JR 08/01/2007
lv_wsch := NVL(lv_ssrmeet_rec.ssrmeet_hrs_week, 0) + lv_wsch; -- C3SC Mod JR 12/05/2007
END LOOP;
RETURN (lv_wsch);
ELSE
RETURN 8888.88;
END IF;
END f_get_wsch; |
|
Custom WHERE filter
Will not pull SCBCRSE_SUBJ_CODE = ('CLEP', ‘TRNS’, ‘AP’, ‘AML1’, ‘CAR1’, ‘BB’. ‘CED1’, ‘CER1’, ‘HFW1’,'MED1’) and will not pull 'LIBR490AB' in XB_COS
| Code Block |
|---|
AND A.SCBCRSE_SUBJ_CODE NOT IN
('CLEP','TRNS','AP','AML1','CAR1','BB','CED1','CER1','HFW1','MED1') -- COS change ADDED
AND (SCBCRSE_SUBJ_CODE || SCBCRSE_CRSE_NUMB <> 'LIBR490AB')
--COS Above 2 lines added |