1 PACKAGE IGS_PR_VAL_PRA AUTHID CURRENT_USER AS
2 /* $Header: IGSPR04S.pls 115.5 2002/11/29 02:44:39 nsidana ship $ */
3 /*
4 || Bug ID 1956374 - Removal of Duplicate Program Units from OSS.
5 || Removed program unit (PRGP_VAL_OU_ACTIVE) - from the spec and body. -- kdande
6 */
7 -------------------------------------------------------------------------------------------
8 --Change History:
9 --Who When What
10 --avenkatr 29-AUG-2001 Bug Id : 1956374. Removed procedure "crsp_val_cty_closed"
11 -------------------------------------------------------------------------------------------
12 --
13 -- bug id : 1956374
14 -- sjadhav , 28-aug-2001
15 -- removed FUNCTION enrp_val_att_closed
16 --
17 --
18 -- Validate the IGS_PR_RU_APPL record.
19 FUNCTION prgp_val_pra_rqrd(
20 p_s_relation_type IN VARCHAR2 ,
21 p_progression_rule_cd IN VARCHAR2 ,
22 p_rul_sequence_number IN NUMBER ,
23 p_ou_org_unit_cd IN VARCHAR2 ,
24 p_ou_start_dt IN DATE ,
25 p_course_type IN VARCHAR2 ,
26 p_crv_course_cd IN VARCHAR2 ,
27 p_crv_version_number IN NUMBER ,
28 p_sca_person_id IN NUMBER ,
29 p_sca_course_cd IN VARCHAR2 ,
30 p_pro_progression_rule_cat IN VARCHAR2 ,
31 p_pro_pra_sequence_number IN NUMBER ,
32 p_pro_sequence_number IN NUMBER ,
33 p_spo_person_id IN NUMBER ,
34 p_spo_course_cd IN VARCHAR2 ,
35 p_spo_sequence_number IN NUMBER ,
36 p_message_name OUT NOCOPY VARCHAR2 )
37 RETURN BOOLEAN;
38 PRAGMA RESTRICT_REFERENCES(prgp_val_pra_rqrd, WNDS);
39 --
40 -- Validate that the IGS_PR_RU_CAT is not closed.
41 FUNCTION prgp_val_prgc_closed(
42 p_progression_rule_cat IN VARCHAR2 ,
43 p_message_name OUT NOCOPY VARCHAR2 )
44 RETURN BOOLEAN;
45 PRAGMA RESTRICT_REFERENCES(prgp_val_prgc_closed, WNDS);
46 --
47 -- Validate that the IGS_PR_RULE is not closed.
48 FUNCTION prgp_val_prr_closed(
49 p_progression_rule_cd IN VARCHAR2 ,
50 p_message_name OUT NOCOPY VARCHAR2 )
51 RETURN BOOLEAN;
52 PRAGMA RESTRICT_REFERENCES(prgp_val_prr_closed, WNDS);
53 --
54 -- Validate the IGS_PS_COURSE version is active.
55 FUNCTION crsp_val_crv_active(
56 p_course_cd IN IGS_PS_VER_ALL.course_cd%TYPE ,
57 p_version_number IN IGS_PS_VER_ALL.version_number%TYPE ,
58 p_message_name OUT NOCOPY VARCHAR2)
59 RETURN BOOLEAN;
60 PRAGMA RESTRICT_REFERENCES(crsp_val_crv_active, WNDS);
61 END IGS_PR_VAL_PRA;