1 PACKAGE IGS_PR_GEN_001 AUTHID CURRENT_USER AS
2 /* $Header: IGSPR01S.pls 115.3 2002/02/12 17:20:06 pkm ship $ */
3 FUNCTION PRGP_GET_CAL_STREAM(
4 P_COURSE_CD IN VARCHAR2 ,
5 P_VERSION_NUMBER IN NUMBER ,
6 P_PRG_CAL_TYPE IN VARCHAR2 ,
7 p_comparison_prg_cal_type IN VARCHAR2 )
8 RETURN VARCHAR2;
9 PRAGMA RESTRICT_REFERENCES(PRGP_GET_CAL_STREAM, WNDS);
10
11 FUNCTION PRGP_GET_CRV_CMT(
12 p_course_cd IN VARCHAR2 ,
13 p_version_number IN NUMBER ,
14 p_org_unit_cd IN VARCHAR2 ,
15 p_ou_start_dt IN DATE )
16 RETURN VARCHAR2;
17 PRAGMA RESTRICT_REFERENCES(PRGP_GET_CRV_CMT, WNDS);
18
19 FUNCTION prgp_get_drtn_efctv(
20 p_prg_cal_type IN VARCHAR2 ,
21 p_prg_sequence_number IN NUMBER ,
22 p_person_id IN NUMBER ,
23 p_course_cd IN VARCHAR2 )
24 RETURN VARCHAR2;
25 PRAGMA RESTRICT_REFERENCES(prgp_get_drtn_efctv, WNDS);
26
27 FUNCTION prgp_get_msr_efctv(
28 p_prg_cal_type IN VARCHAR2 ,
29 p_prg_sequence_number IN NUMBER ,
30 p_person_id IN NUMBER ,
31 p_course_cd IN VARCHAR2 )
32 RETURN VARCHAR2;
33 PRAGMA RESTRICT_REFERENCES(prgp_get_msr_efctv, WNDS);
34
35 FUNCTION prgp_get_prg_efctv(
36 p_prg_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
37 p_prg_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE )
38 RETURN DATE;
39 PRAGMA RESTRICT_REFERENCES(prgp_get_prg_efctv, WNDS);
40
41 FUNCTION prgp_get_sca_elps_tm(
42 p_person_id IN NUMBER ,
43 p_course_cd IN VARCHAR2 ,
44 p_version_number IN NUMBER ,
45 p_commencement_dt IN DATE ,
46 p_effective_dt IN DATE DEFAULT SYSDATE)
47 RETURN NUMBER;
48 PRAGMA RESTRICT_REFERENCES(prgp_get_sca_elps_tm, WNDS);
49
50 FUNCTION PRGP_GET_SCA_GPA(
51 p_person_id IN NUMBER ,
52 p_course_cd IN VARCHAR2 ,
53 p_unit_set_cd IN VARCHAR2 ,
54 p_course_stage_type IN VARCHAR2 ,
55 p_prg_cal_type IN VARCHAR2 ,
56 p_prg_sequence_number IN NUMBER ,
57 p_best_worst IN VARCHAR2 ,
58 p_use_recommended_ind IN VARCHAR2 ,
59 p_use_first_attempt_ind IN VARCHAR2 ,
60 p_use_entered_grade_ind IN VARCHAR2 )
61 RETURN NUMBER;
62
63
64 END IGS_PR_GEN_001;