1 PACKAGE IGS_AS_VAL_SUAAP AS
2 /* $Header: IGSAS31S.pls 120.0 2005/07/05 11:24:30 appldev noship $ */
3 -------------------------------------------------------------------------------------------
4 --Change History:
5 --Who When What
6 --smadathi 24-AUG-2001 Bug No. 1956374 .Added Pragma restrict reference to function
7 -- GENP_VAL_SDTT_SESS
8 -------------------------------------------------------------------------------------------
9
10 -- Val IGS_PS_UNIT assess pattern applies to stud IGS_PS_UNIT IGS_AD_LOCATION, class and mode.
11 FUNCTION ASSP_VAL_UAP_LOC_UC(
12 p_location_cd IN VARCHAR2 ,
13 p_unit_class IN VARCHAR2 ,
14 p_unit_mode IN VARCHAR2 ,
15 p_uap_location_cd IN VARCHAR2 ,
16 p_uap_unit_class IN VARCHAR2 ,
17 p_uap_unit_mode IN VARCHAR2 ,
18 p_message_NAME OUT NOCOPY VARCHAR2)
19 RETURN BOOLEAN;
20 PRAGMA RESTRICT_REFERENCES(ASSP_VAL_UAP_LOC_UC,WNDS,WNPS);
21 --
22 -- Validate able to create stdnt_unit_atmp_ass_pattern.
23 FUNCTION ASSP_VAL_SUAAP_INS(
24 p_person_id IN NUMBER ,
25 p_course_cd IN VARCHAR2 ,
26 p_unit_cd IN VARCHAR2 ,
27 p_cal_type IN VARCHAR2 ,
28 p_ci_sequence_number IN NUMBER ,
29 p_ass_pattern_id IN NUMBER ,
30 p_message_NAME OUT NOCOPY VARCHAR2 ,
31 -- anilk, 22-Apr-2003, Bug# 2829262
32 p_uoo_id IN NUMBER DEFAULT NULL )
33 RETURN BOOLEAN;
34
35 -- Validate only one active instance of the assessment pattern for suaap.
36 FUNCTION ASSP_VAL_SUAAP_ACTV(
37 p_person_id IN NUMBER ,
38 p_course_cd IN VARCHAR2 ,
39 p_unit_cd IN VARCHAR2 ,
40 p_cal_type IN VARCHAR2 ,
41 p_ci_sequence_number IN NUMBER ,
42 p_ass_pattern_id IN NUMBER ,
43 p_creation_dt IN DATE ,
44 p_message_NAME OUT NOCOPY VARCHAR2 ,
45 -- anilk, 22-Apr-2003, Bug# 2829262
46 p_uoo_id IN NUMBER DEFAULT NULL )
47 RETURN BOOLEAN;
48
49 -- Validate that an entry exist in s_disable_table_trigger.
50 FUNCTION GENP_VAL_SDTT_SESS(
51 p_table_name IN VARCHAR2 )
52 RETURN BOOLEAN;
53
54 PRAGMA RESTRICT_REFERENCES (GENP_VAL_SDTT_SESS,WNDS);
55 --
56
57 END IGS_AS_VAL_SUAAP;