1 PACKAGE IGS_PR_VAL_SCA AUTHID CURRENT_USER AS
2 /* $Header: IGSPR08S.pls 115.5 2002/11/29 02:45:46 nsidana ship $ */
3
4
5 -------------------------------------------------------------------------------------------
6 --Change History:
7 --Who When What
8 --kdande 26-01-2002 Bug ID 1956374 - Removal of Duplicate Program Units from OSS.
9 -- Removed program unit (PRGP_VAL_SCA_CMPLT) - from the spec and body.
10 --kkillams 11-11-2002 As part of Legacy Build bug no:2661533,
11 -- New parameter p_legacy is added to following function
12 -- course_rqrmnts_complete_dt.
13 -------------------------------------------------------------------------------------------
14
15 --
16 -- Validate the Student IGS_PS_UNIT Set Attempts.
17 FUNCTION prgp_val_susa_cmplt(
18 p_person_id IN NUMBER ,
19 p_course_cd IN VARCHAR2 ,
20 p_message_name OUT NOCOPY VARCHAR2 )
21 RETURN BOOLEAN;
22 PRAGMA RESTRICT_REFERENCES(prgp_val_susa_cmplt, WNDS);
23 --
24 -- Validate the Student IGS_PS_COURSE Attempt Status.
25 FUNCTION prgp_val_sca_status(
26 p_person_id IN NUMBER ,
27 p_course_cd IN VARCHAR2 ,
28 p_message_name OUT NOCOPY VARCHAR2 )
29 RETURN BOOLEAN;
30 PRAGMA RESTRICT_REFERENCES(prgp_val_sca_status, WNDS);
31 --
32 -- Validate the Student IGS_PS_COURSE complete indicator.
33 FUNCTION prgp_val_undo_cmpltn(
34 p_person_id IN NUMBER ,
35 p_course_cd IN VARCHAR2 ,
36 p_version_number IN NUMBER ,
37 p_exit_course_cd IN VARCHAR2 ,
38 p_exit_version_number IN NUMBER ,
39 p_message_name OUT NOCOPY VARCHAR2 )
40 RETURN BOOLEAN;
41 PRAGMA RESTRICT_REFERENCES(prgp_val_undo_cmpltn, WNDS);
42 --
43 -- Validate the Student IGS_PS_COURSE complete indicator.
44 FUNCTION prgp_val_cmplt_ind(
45 p_person_id IN NUMBER ,
46 p_course_cd IN VARCHAR2 ,
47 p_course_complete_ind IN VARCHAR2 DEFAULT 'N',
48 p_exit_course_complete_ind IN VARCHAR2 DEFAULT 'N',
49 p_call_type IN VARCHAR2 ,
50 p_message_name OUT NOCOPY VARCHAR2 )
51 RETURN BOOLEAN;
52 PRAGMA RESTRICT_REFERENCES(prgp_val_cmplt_ind, WNDS);
53 --
54 -- Validate that rqrmnts complete dt and source set if IGS_PS_COURSE complete.
55 FUNCTION prgp_val_sca_crcd(
56 p_course_rqrmnt_complete_ind IN VARCHAR2 DEFAULT 'N',
57 p_course_rqrmnts_complete_dt IN DATE ,
58 p_s_completed_source_type IN VARCHAR2 ,
59 p_message_name OUT NOCOPY VARCHAR2 )
60 RETURN BOOLEAN;
61 PRAGMA RESTRICT_REFERENCES(prgp_val_sca_crcd, WNDS);
62 --
63 -- To validate the IGS_EN_STDNT_PS_ATT.course_rqrmnts_complete_dt
64 FUNCTION prgp_val_sca_cmpl_dt(
65 p_person_id IN NUMBER ,
66 p_course_cd IN VARCHAR2 ,
67 p_commencement_dt IN DATE ,
68 p_course_rqrmnts_complete_dt IN DATE ,
69 p_message_name OUT NOCOPY VARCHAR2,
70 p_legacy IN VARCHAR2 DEFAULT 'N')
71 RETURN BOOLEAN;
72 PRAGMA RESTRICT_REFERENCES(prgp_val_sca_cmpl_dt, WNDS);
73 END IGS_PR_VAL_SCA;