1 PACKAGE IGS_AS_VAL_GSGT AUTHID CURRENT_USER AS
2 /* $Header: IGSAS25S.pls 115.4 2002/11/28 22:45:52 nsidana ship $ */
3 -- Bug # 1956374 , Procedure assp_val_gs_cur_fut is removed
4
5
6
7 --
8 -- Validate grade may not be translated against another grade in same ver
9 FUNCTION assp_val_gsgt_gs_gs(
10 p_grading_schema_cd IN VARCHAR2 ,
11 p_version_number IN NUMBER ,
12 p_to_grading_schema_cd IN VARCHAR2 ,
13 p_to_version_number IN NUMBER ,
14 p_message_name OUT NOCOPY VARCHAR2 )
15 RETURN BOOLEAN;
16
17
18 --
19 -- Validate grade may not be translated against more than 1 grade
20 FUNCTION assp_val_gsgt_multi(
21 p_grading_schema_cd IN VARCHAR2 ,
22 p_version_number IN NUMBER ,
23 p_grade IN VARCHAR2 ,
24 p_to_grading_schema_cd IN VARCHAR2 ,
25 p_to_version_number IN NUMBER ,
26 p_to_grade IN VARCHAR2 ,
27 p_message_name OUT NOCOPY VARCHAR2 )
28 RETURN BOOLEAN;
29
30
31 --
32 -- Validate rslt type for grade is same as rslt type for xlation grade
33 FUNCTION assp_val_gsgt_result(
34 p_grading_schema_cd IN VARCHAR2 ,
35 p_version_number IN NUMBER ,
36 p_grade IN VARCHAR2 ,
37 p_to_grading_schema_cd IN VARCHAR2 ,
38 p_to_version_number IN NUMBER ,
39 p_to_grade IN VARCHAR2 ,
40 p_message_name OUT NOCOPY VARCHAR2 )
41 RETURN BOOLEAN;
42
43
44 --
45 -- Validate is SUAO exist when changing/deleting translations
46 FUNCTION assp_val_gsgt_suao(
47 p_grading_schema_cd IN VARCHAR2 ,
48 p_version_number IN NUMBER ,
49 p_grade IN VARCHAR2 ,
50 p_to_grading_schema_cd IN VARCHAR2 ,
51 p_to_version_number IN NUMBER ,
52 p_to_grade IN VARCHAR2 ,
53 p_message_name OUT NOCOPY VARCHAR2 )
54 RETURN BOOLEAN;
55
56
57 --
58 -- Routine to clear rowids saved in a PL/SQL TABLE from a prior commit.
59
60 END IGS_AS_VAL_GSGT;