1 PACKAGE IGS_PR_GEN_002 AS
2 /* $Header: IGSPR02S.pls 120.1 2006/04/28 05:47:59 sepalani noship $ */
3 /************************************************************************
4 Know limitations, enhancements or remarks
5 Change History
6 Who When What
7 sepalani 11-Apr-2006 Bug # 5076203
8 ***************************************************************/
9 FUNCTION prgp_get_sca_wam(
10 p_person_id IN NUMBER ,
11 p_course_cd IN VARCHAR2 ,
12 p_course_version IN NUMBER ,
13 p_unit_set_cd IN VARCHAR2 ,
14 p_course_stage_type IN VARCHAR2 ,
15 p_prg_cal_type IN VARCHAR2 ,
16 p_prg_sequence_number IN NUMBER ,
17 p_use_recommended_ind IN VARCHAR2 ,
18 p_abort_when_missing_ind IN VARCHAR2 )
19 RETURN NUMBER;
20
21 FUNCTION prgp_get_stg_comp(
22 p_person_id IN NUMBER ,
23 p_course_cd IN VARCHAR2 ,
24 p_crv_version_number IN NUMBER ,
25 p_course_stage_type IN VARCHAR2 )
26 RETURN VARCHAR2;
27 --PRAGMA RESTRICT_REFERENCES(PRGP_GET_STG_COMP, WNDS);
28
29 --
30 -- kdande; 22-Apr-2003; Bug# 2829262
31 -- Added p_uoo_id parameter to the FUNCTION prgp_get_sua_gpa_val
32 --
33 FUNCTION prgp_get_sua_gpa_val(
34 p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
35 p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
36 p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
37 p_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
38 p_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
39 p_best_worst IN VARCHAR2 ,
40 p_recommended_ind IN VARCHAR2,
41 p_uoo_id IN NUMBER DEFAULT NULL)
42 RETURN IGS_AS_GRD_SCH_GRADE.gpa_val%TYPE;
43 PRAGMA RESTRICT_REFERENCES(prgp_get_sua_gpa_val, WNDS);
44
45 --
46 -- kdande; 22-Apr-2003; Bug# 2829262
47 -- Added p_uoo_id parameter to the FUNCTION prgp_get_sua_prg_num
48 --
49 FUNCTION prgp_get_sua_prg_num(
50 p_prg_cal_type IN VARCHAR ,
51 p_prg_sequence_number IN NUMBER ,
52 p_number_of_periods IN NUMBER ,
53 p_person_id IN NUMBER ,
54 p_course_cd IN VARCHAR2 ,
55 p_unit_cd IN VARCHAR2 ,
56 p_cal_type IN VARCHAR2 ,
57 p_ci_sequence_number IN NUMBER,
58 p_uoo_id IN NUMBER DEFAULT NULL)
59 RETURN VARCHAR2;
60 PRAGMA RESTRICT_REFERENCES(prgp_get_sua_prg_num, WNDS);
61
62 --
63 -- kdande; 22-Apr-2003; Bug# 2829262
64 -- Added p_uoo_id parameter to the FUNCTION prgp_get_sua_prg_prd
65 --
66 FUNCTION prgp_get_sua_prg_prd(
67 p_prg_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
68 p_prg_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
69 p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
70 p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
71 p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
72 p_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
73 p_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
74 p_details_ind IN VARCHAR2 ,
75 p_unit_attempt_status IN VARCHAR2 ,
76 p_discontinued_dt IN DATE,
77 p_uoo_id IN NUMBER DEFAULT NULL)
78 RETURN VARCHAR2;
79 PRAGMA RESTRICT_REFERENCES(prgp_get_sua_prg_prd, WNDS);
80
81 --
82 -- kdande; 22-Apr-2003; Bug# 2829262
83 -- Added p_uoo_id parameter to the FUNCTION prgp_get_sua_wam
84 --
85 FUNCTION prgp_get_sua_wam(
86 p_person_id IN NUMBER ,
87 p_course_cd IN VARCHAR2 ,
88 p_unit_cd IN VARCHAR2 ,
89 p_cal_type IN VARCHAR2 ,
90 p_ci_sequence_number IN NUMBER ,
91 p_use_recommended_ind IN VARCHAR2 ,
92 p_abort_when_missing_ind IN VARCHAR2,
93 p_wam_type IN VARCHAR2 DEFAULT 'COURSE',
94 p_uoo_id IN NUMBER DEFAULT NULL)
95 RETURN NUMBER;
96 PRAGMA RESTRICT_REFERENCES(PRGP_GET_SUA_WAM, WNDS);
97
98 END IGS_PR_GEN_002;