PACKAGE: APPS.IGS_AS_VAL_SUAAI

Source

1 PACKAGE IGS_AS_VAL_SUAAI AUTHID CURRENT_USER AS
2 /* $Header: IGSAS30S.pls 115.7 2003/05/27 16:47:23 anilk ship $ */
3 -- Val IGS_PS_UNIT assess item applies to stud IGS_PS_UNIT IGS_AD_LOCATION, class and mode.
4  -- BUG #1956374 , Procedure assp_val_cutoff_dt, assp_val_suaai_ins ,assp_val_ai_exmnblare  removed
5   FUNCTION ASSP_VAL_UAI_LOC_UC(
6   p_student_location_cd IN VARCHAR2 ,
7   p_student_unit_class IN VARCHAR2 ,
8   p_student_unit_mode IN VARCHAR2 ,
9   p_location_cd IN VARCHAR2 ,
10   p_unit_class IN VARCHAR2 ,
11   p_unit_mode IN VARCHAR2 ,
12   p_message_name OUT NOCOPY VARCHAR2)
13 RETURN BOOLEAN;
14 PRAGMA RESTRICT_REFERENCES(ASSP_VAL_UAI_LOC_UC,WNDS,WNPS);
15   --
16 
17 
18   --
19   -- Validate Assessment Item IGS_PS_COURSE Type restrictions.
20   FUNCTION ASSP_VAL_AI_ACOT(
21   p_ass_id IN NUMBER ,
22   p_course_type IN VARCHAR2 ,
23   p_message_name OUT NOCOPY VARCHAR2)
24 RETURN BOOLEAN;
25 pragma restrict_references (assp_val_ai_acot,wnds,WNPS,WNDS);
26 
27   --
28   -- Validate if assessment item completed for discontinued IGS_PS_UNIT.
29   FUNCTION ASSP_VAL_ASS_COUNT(
30   p_unit_attempt_status IN VARCHAR2 ,
31   p_tracking_id IN NUMBER )
32 RETURN VARCHAR2;
33 
34   --
35   -- Validate the attempt number is unique within the student assigment.
36   FUNCTION assp_val_suaai_atmpt(
37   p_person_id  IGS_AS_SU_ATMPT_ITM.person_id%TYPE ,
38   p_course_cd  IGS_AS_SU_ATMPT_ITM.course_cd%TYPE ,
39   p_unit_cd  IGS_AS_SU_ATMPT_ITM.unit_cd%TYPE ,
40   p_cal_type  IGS_AS_SU_ATMPT_ITM.cal_type%TYPE ,
41   p_ci_sequence_number  IGS_AS_SU_ATMPT_ITM.ci_sequence_number%TYPE ,
42   p_ass_id  IGS_AS_SU_ATMPT_ITM.ass_id%TYPE ,
43   p_creation_dt IN DATE ,
44   p_attempt_number  NUMBER ,
45   p_message_name OUT NOCOPY VARCHAR2,
46   -- anilk, 22-Apr-2003, Bug# 2829262
47   p_uoo_id IN NUMBER DEFAULT NULL )
48 RETURN BOOLEAN;
49 PRAGMA RESTRICT_REFERENCES(assp_val_suaai_atmpt,WNDS);
50   --
51   -- Validate item still applies to student as a uai or part of a pattern.
52   FUNCTION ASSP_VAL_SUAAI_VALID(
53   p_person_id IN NUMBER ,
54   p_unit_cd IN VARCHAR2 ,
55   p_course_cd IN VARCHAR2 ,
56   p_cal_type IN VARCHAR2 ,
57   p_ci_sequence_number IN NUMBER ,
58   p_ass_pattern_id IN NUMBER ,
59   p_ass_id IN NUMBER ,
60   p_suaai_logical_delete_dt IN DATE ,
61   p_message_name OUT NOCOPY VARCHAR2 ,
62   -- anilk, 22-Apr-2003, Bug# 2829262
63   p_uoo_id IN NUMBER DEFAULT NULL )
64 
65 RETURN BOOLEAN;
66 PRAGMA RESTRICT_REFERENCES (ASSP_VAL_SUAAI_VALID,WNDS,WNPS);  --
67 END IGS_AS_VAL_SUAAI;