1 PACKAGE IGS_PS_VAL_CRV AUTHID CURRENT_USER AS
2 /* $Header: IGSPS34S.pls 115.4 2002/11/29 03:02:17 nsidana ship $ */
3 -- Bug #1956374
4 -- As part of the bug# 1956374 removed the function crsp_val_ver_dt
5 --Bug No 1956374, Removed procedure "crsp_val_caw_insert"
6
7 -- Validate IGS_PS_COURSE version government special IGS_PS_COURSE type.
8 FUNCTION crsp_val_crv_gsct(
9 p_govt_special_course_type IN VARCHAR2 ,
10 p_message_name OUT NOCOPY VARCHAR2 )
11 RETURN BOOLEAN;
12
13 --
14 -- Validate IGS_PS_COURSE version IGS_PS_COURSE type.
15 FUNCTION crsp_val_crv_type(
16 p_course_cd IN VARCHAR2 ,
17 p_version_number IN NUMBER ,
18 p_course_type IN VARCHAR2 ,
19 p_message_name OUT NOCOPY VARCHAR2 )
20 RETURN BOOLEAN;
21
22 --
23
24
25 --
26 -- Validate organisational IGS_PS_UNIT system status is ACTIVE
27 FUNCTION crsp_val_ou_sys_sts(
28 p_org_unit_cd IN VARCHAR2 ,
29 p_start_dt IN DATE ,
30 p_message_name OUT NOCOPY VARCHAR2 )
31 RETURN BOOLEAN;
32
33 --
34 -- Validate the IGS_PS_COURSE version end date and status.
35 FUNCTION crsp_val_crv_end_sts(
36 p_end_dt IN DATE ,
37 p_course_status IN VARCHAR2 ,
38 p_message_name OUT NOCOPY VARCHAR2 )
39 RETURN BOOLEAN;
40
41 --
42 -- Validate IGS_PS_COURSE version expiry date and status
43 FUNCTION crsp_val_crv_exp_sts(
44 p_course_cd IN VARCHAR2 ,
45 p_version_number IN NUMBER ,
46 p_expiry_dt IN DATE ,
47 p_course_status IN VARCHAR2 ,
48 p_message_name OUT NOCOPY VARCHAR2 )
49 RETURN BOOLEAN;
50
51
52 --
53 -- Validate the IGS_PS_COURSE version status.
54 FUNCTION crsp_val_crv_status(
55 p_new_course_status IN VARCHAR2 ,
56 p_old_course_status IN VARCHAR2 ,
57 p_message_name OUT NOCOPY VARCHAR2)
58 RETURN BOOLEAN;
59
60 --
61 -- Perform quality validation checks on a IGS_PS_COURSE version and its details.
62 FUNCTION CRSP_VAL_CRV_QUALITY(
63 p_course_cd IN VARCHAR2 ,
64 p_version_number IN NUMBER ,
65 p_old_course_status IN VARCHAR2 ,
66 p_message_name OUT NOCOPY VARCHAR2 )
67 RETURN BOOLEAN;
68
69 --
70 -- Validate that a IGS_PS_COURSE version can end, looking at sca status
71 FUNCTION crsp_val_crv_end(
72 p_course_cd IN VARCHAR2 ,
73 p_version_number IN NUMBER ,
74 p_return_type OUT NOCOPY VARCHAR2 ,
75 p_message_name OUT NOCOPY VARCHAR2 )
76 RETURN BOOLEAN;
77
78 END IGS_PS_VAL_CRV;