DBA Data[Home] [Help]

PACKAGE: APPS.IGS_AS_VAL_AI

Source


1 PACKAGE IGS_AS_VAL_AI AUTHID CURRENT_USER AS
2 /* $Header: IGSAS11S.pls 115.4 2002/11/28 22:42:07 nsidana ship $ */
3   --
4   --
5   -- Validate the appropriate assessment item details set and are not set
6   FUNCTION assp_val_ai_details(
7   p_assessment_type IN IGS_AS_ASSESSMNT_ITM_ALL.ASSESSMENT_TYPE%TYPE ,
8   p_exam_scheduled_ind IN IGS_AS_ASSESSMNT_ITM_ALL.exam_scheduled_ind%TYPE ,
9   p_exam_working_time IN IGS_AS_ASSESSMNT_ITM_ALL.exam_working_time%TYPE ,
10   p_exam_announcements IN IGS_AS_ASSESSMNT_ITM_ALL.exam_announcements%TYPE ,
11   p_exam_short_paper_name IN IGS_AS_ASSESSMNT_ITM_ALL.exam_short_paper_name%TYPE ,
12   p_exam_paper_name IN IGS_AS_ASSESSMNT_ITM_ALL.exam_paper_name%TYPE ,
13   p_exam_perusal_time IN IGS_AS_ASSESSMNT_ITM_ALL.exam_perusal_time%TYPE ,
14   p_exam_supervisor_instrctn IN IGS_AS_ASSESSMNT_ITM_ALL.exam_supervisor_instrctn%TYPE ,
15   p_exam_allowable_instrctn IN IGS_AS_ASSESSMNT_ITM_ALL.exam_allowable_instrctn%TYPE ,
16   p_exam_non_allowed_instrctn IN IGS_AS_ASSESSMNT_ITM_ALL.exam_non_allowed_instrctn%TYPE ,
17   p_exam_supplied_instrctn IN IGS_AS_ASSESSMNT_ITM_ALL.exam_supplied_instrctn%TYPE ,
18   p_question_or_title IN IGS_AS_ASSESSMNT_ITM_ALL.question_or_title%TYPE ,
19   p_ass_length_or_duration IN IGS_AS_ASSESSMNT_ITM_ALL.ass_length_or_duration%TYPE ,
20   p_message_name OUT NOCOPY VARCHAR2 )
21 RETURN BOOLEAN;
22 
23   --
24   -- Validate exam times
25   FUNCTION assp_val_ai_ex_times(
26   p_assessment_type IN IGS_AS_ASSESSMNT_ITM_ALL.ASSESSMENT_TYPE%TYPE ,
27   p_exam_working_time IN IGS_AS_ASSESSMNT_ITM_ALL.exam_working_time%TYPE ,
28   p_exam_perusal_time IN IGS_AS_ASSESSMNT_ITM_ALL.exam_perusal_time%TYPE ,
29   p_message_name OUT NOCOPY VARCHAR2 )
30 RETURN BOOLEAN;
31 
32   --
33   -- Validate assessment type closed indicator.
34   FUNCTION assp_val_atyp_closed(
35   p_assessment_type IN IGS_AS_ASSESSMNT_TYP.ASSESSMENT_TYPE%TYPE ,
36   p_message_name OUT NOCOPY VARCHAR2 )
37 RETURN BOOLEAN;
38 
39   --
40   -- Validate updating ass type, does not cause non-unique uai.reference
41   FUNCTION ASSP_VAL_AI_TYPE(
42   p_ass_id IN NUMBER ,
43   p_assessment_type IN VARCHAR2 ,
44   p_old_assessment_type IN VARCHAR2 ,
45   p_message_name OUT NOCOPY VARCHAR2 )
46 RETURN BOOLEAN;
47 
48 END IGS_AS_VAL_AI;