PACKAGE: APPS.IGS_AS_GEN_002

Source

1 PACKAGE IGS_AS_GEN_002 AUTHID CURRENT_USER AS
2 /* $Header: IGSAS02S.pls 115.7 2003/05/27 18:42:28 anilk ship $ */
3 
4 FUNCTION assp_get_atyp_exmnbl(
5   p_assessment_type IN IGS_AS_ASSESSMNT_ITM_ALL.assessment_type%TYPE )
6 RETURN VARCHAR2 ;
7 FUNCTION assp_get_dflt_exloc(
8   p_location_cd IN VARCHAR2 )
9 RETURN VARCHAR2 ;
10  PRAGMA RESTRICT_REFERENCES(assp_get_dflt_exloc,WNDS,WNPS);
11 FUNCTION assp_get_dflt_finls(
12   p_person_id IN NUMBER ,
13   p_course_cd IN VARCHAR2 ,
14   p_unit_cd IN VARCHAR2 ,
15   p_cal_type IN VARCHAR2 ,
16   p_ci_sequence_number IN NUMBER ,
17   -- anilk, 22-Apr-2003, Bug# 2829262
18   p_uoo_id IN NUMBER )
19 RETURN VARCHAR2 ;
20  FUNCTION assp_get_dflt_grade(
21   p_mark IN NUMBER ,
22   p_grading_schema_cd IN VARCHAR2 ,
23   p_gs_version_number IN NUMBER )
24 RETURN VARCHAR2 ;
25  FUNCTION assp_get_exam_view(
26   p_uai_exam_cal_type  IGS_AS_UNITASS_ITEM_ALL.exam_cal_type%TYPE ,
27   p_uai_exam_ci_seq  IGS_AS_UNITASS_ITEM_ALL.exam_ci_sequence_number%TYPE ,
28   p_ueciv_exam_cal_type  IGS_AS_UNITASS_ITEM_ALL.exam_cal_type%TYPE ,
29   p_ueciv_exam_ci_seq  IGS_AS_UNITASS_ITEM_ALL.exam_ci_sequence_number%TYPE ,
30   p_sua_person_id  IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
31   p_sua_course_cd  IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
32   p_sua_unit_cd  IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
33   p_sua_version_number  IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
34   p_sua_cal_type  IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
35   p_sua_ci_seq  IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
36   p_sua_unit_attempt_status  IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
37   p_sua_location_cd  IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
38   p_ucl_unit_mode  IGS_AS_UNIT_CLASS_ALL.unit_mode%TYPE ,
39   p_sua_unit_class  IGS_EN_SU_ATTEMPT_ALL.UNIT_CLASS%TYPE ,
40   p_ueciv_ass_id  IGS_AS_UNITASS_ITEM_ALL.ass_id%TYPE )
41 RETURN VARCHAR2 ;
42  PRAGMA RESTRICT_REFERENCES(assp_get_exam_view,WNDS,WNPS);
43 FUNCTION assp_get_gsg_cncd(
44   p_grading_schema_cd IN VARCHAR2 ,
45   p_version_number IN NUMBER ,
46   p_grade IN VARCHAR2 )
47 RETURN VARCHAR2 ;
48 FUNCTION assp_get_gsg_rank(
49   p_grading_schema_cd IN VARCHAR2 ,
50   p_version_number IN NUMBER ,
51   p_grade IN VARCHAR2 )
52 RETURN NUMBER ;
53 FUNCTION assp_get_gsg_result(
54   p_grading_schema_cd IN VARCHAR2 ,
55   p_version_number IN NUMBER ,
56   p_grade IN VARCHAR2 )
57 RETURN VARCHAR2 ;
58 FUNCTION assp_get_mark_mndtry(
59   p_grading_schema_cd IN VARCHAR2 ,
60   p_version_number IN NUMBER ,
61   p_grade IN VARCHAR2 )
62 RETURN VARCHAR2 ;
63 FUNCTION assp_get_ai_s_type(
64   p_ass_id IN NUMBER )
65 RETURN VARCHAR2 ;
66  PRAGMA RESTRICT_REFERENCES(assp_get_ai_s_type,WNDS,WNPS);
67 END IGS_AS_GEN_002 ;