1 PACKAGE IGS_AS_VAL_UAP AUTHID CURRENT_USER AS
2 /* $Header: IGSAS35S.pls 115.7 2002/11/28 22:48:09 nsidana ship $ */
3 -- Bug #1956374
4 -- As part of the bug# 1956374 removed the function crsp_val_loc_cd
5 -- As part of the bug# 1956374 removed the function crsp_val_ucl_closed
6 -- As part of the bug# 1956374 removed the function crsp_val_um_closed
7 -- As part of the bug# 1956374 removed the function crsp_val_uo_cal_type
8 -- As part of the bug# 1956373 removed the function crsp_val_iud_uv_dtl
9 -- Bug No 1956374 , Procedure assp_val_uap_loc_uc is removed
10 -- Validate the ass_pattern_cd is unique within a IGS_PS_UNIT offering pattern.
11 FUNCTION ASSP_VAL_UAP_UNIQ_CD(
12 p_unit_cd IN VARCHAR2 ,
13 p_version_number IN NUMBER ,
14 p_cal_type IN VARCHAR2 ,
15 p_ci_sequence_number IN NUMBER ,
16 p_ass_pattern_id IN NUMBER ,
17 p_ass_pattern_cd IN VARCHAR2 ,
18 p_message_name OUT NOCOPY VARCHAR2 )
19 RETURN BOOLEAN;
20
21 -- Validate the IGS_PS_UNIT assessment pattern restrictions can be updated.
22 FUNCTION ASSP_VAL_UAP_UOO_UPD(
23 p_unit_cd IN VARCHAR2 ,
24 p_version_number IN NUMBER ,
25 p_cal_type IN VARCHAR2 ,
26 p_ci_sequence_number IN NUMBER ,
27 p_ass_pattern_id IN NUMBER ,
28 p_location_cd IN VARCHAR2 ,
29 p_unit_class IN VARCHAR2 ,
30 p_unit_mode IN VARCHAR2 ,
31 p_message_name OUT NOCOPY VARCHAR2 )
32 RETURN BOOLEAN;
33
34 --
35
36 --
37 -- Validate IGS_PS_UNIT class and IGS_PS_UNIT mode cannot both be set.
38 FUNCTION ASSP_VAL_UC_UM(
39 p_unit_mode IN VARCHAR2 ,
40 p_unit_class IN VARCHAR2 ,
41 p_message_name OUT NOCOPY VARCHAR2 )
42 RETURN BOOLEAN;
43
44
45
46 --
47
48
49 --
50 -- Val IGS_PS_UNIT assess pattern applies to stud IGS_PS_UNIT IGS_AD_LOCATION, class and mode.
51 FUNCTION ASSP_VAL_SUA_UAP(
52 p_student_location_cd IN VARCHAR2 ,
53 p_student_unit_class IN VARCHAR2 ,
54 p_student_unit_mode IN VARCHAR2 ,
55 p_location_cd IN VARCHAR2 ,
56 p_unit_class IN VARCHAR2 ,
57 p_unit_mode IN VARCHAR2 )
58 RETURN CHAR;
59 PRAGMA RESTRICT_REFERENCES(ASSP_VAL_SUA_UAP,WNDS,WNPS);
60
61
62 -- Routine to save rowids in a PL/SQL TABLE for the current commit.
63
64 END IGS_AS_VAL_UAP;