1 PACKAGE IGS_PS_VAL_POSu AS
2 /* $Header: IGSPS52S.pls 120.0 2005/06/01 16:14:57 appldev noship $ */
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
7 --
8 --
9 -- Validate pattern of study IGS_PS_UNIT record is unique.
10 FUNCTION crsp_val_posu_iu(
11 p_course_cd IN VARCHAR2 ,
12 p_version_number IN NUMBER ,
13 p_cal_type IN VARCHAR2 ,
14 p_pos_sequence_number IN NUMBER ,
15 p_posp_sequence_number IN NUMBER ,
16 p_sequence_number IN NUMBER ,
17 p_unit_cd IN VARCHAR2 ,
18 p_return_type OUT NOCOPY VARCHAR2 ,
19 p_message_name OUT NOCOPY VARCHAR2,
20 p_location_cd IN VARCHAR2,
21 p_unit_class IN VARCHAR2)
22 RETURN BOOLEAN;
23 --
24 -- Validate the pattern of study IGS_PS_UNIT record has the required fields.
25 FUNCTION crsp_val_posu_rqrd(
26 p_unit_cd IN VARCHAR2 ,
27 p_unit_location_cd IN VARCHAR2 ,
28 p_unit_class IN VARCHAR2 ,
29 p_description IN VARCHAR2 ,
30 p_message_name OUT NOCOPY VARCHAR2)
31 RETURN BOOLEAN;
32 --
33 -- Warn if no IGS_PS_UNIT offering option exists for the specified options.
34 FUNCTION crsp_val_posu_uoo(
35 p_course_cd IN VARCHAR2 ,
36 p_version_number IN NUMBER ,
37 p_cal_type IN VARCHAR2 ,
38 p_pos_sequence_number IN NUMBER ,
39 p_posp_sequence_number IN NUMBER ,
40 p_unit_cd IN VARCHAR2 ,
41 p_unit_location_cd IN VARCHAR2 ,
42 p_unit_class IN VARCHAR2 ,
43 p_message_name OUT NOCOPY VARCHAR2)
44 RETURN BOOLEAN;
45 --
46 -- Validate a least one version of the IGS_PS_UNIT is active.
47 FUNCTION crsp_val_uv_active(
48 p_unit_cd IN IGS_PS_UNIT_VER_ALL.unit_cd%TYPE ,
49 p_message_name OUT NOCOPY VARCHAR2)
50 RETURN BOOLEAN;
51 PRAGMA RESTRICT_REFERENCES(crsp_val_uv_active,WNDS);
52
53 END IGS_PS_VAL_POSu;