1 PACKAGE IGS_AD_VAL_SCFT AUTHID CURRENT_USER AS
2 /* $Header: IGSAD69S.pls 115.4 2002/11/28 21:39:39 nsidana ship $ */
3
4 -------------------------------------------------------------------
5 -- Change History :
6 -- Who When What
7 -- avenkatr 30-AUG-2001 Bug Id : 1956374. Removed Procedure "crsp_val_fs_closed"
8 -- avenkatr 30-AUG-2001 Bug Id : 1956374. Removed Procedure "crsp_val_iud_crv_dtl"
9 ------------------------------------------------------------------
10 --
11 -- Validate SCFT optional values unique across records
12 FUNCTION admp_val_scft_uniq(
13 p_submission_yr IN NUMBER ,
14 p_submission_number IN NUMBER ,
15 p_course_cd IN VARCHAR2 ,
16 p_crv_version_number IN NUMBER ,
17 p_funding_source IN VARCHAR2 ,
18 p_location_cd IN VARCHAR2 ,
19 p_attendance_mode IN VARCHAR2 ,
20 p_attendance_type IN VARCHAR2 ,
21 p_unit_set_cd IN VARCHAR2 ,
22 p_us_version_number IN NUMBER ,
23 p_message_name OUT NOCOPY VARCHAR2 )
24 RETURN BOOLEAN;
25 -- Validate crs fund target course version in a valid course off pattern
26 FUNCTION admp_val_scft_cop(
27 p_submission_yr IN NUMBER ,
28 p_submission_number IN NUMBER ,
29 p_course_cd IN VARCHAR2 ,
30 p_crv_version_number IN NUMBER ,
31 p_message_name OUT NOCOPY VARCHAR2 )
32 RETURN BOOLEAN;
33 -- Validate crs fund target funding source is within restriction
34 FUNCTION admp_val_scft_fs(
35 p_course_cd IN VARCHAR2 ,
36 p_crv_version_number IN NUMBER ,
37 p_funding_source IN VARCHAR2 ,
38 p_message_name OUT NOCOPY VARCHAR2 )
39 RETURN BOOLEAN;
40 -- Validate crs fund target IGS_PS_UNIT set in a valid course offering IGS_PS_UNIT set
41 FUNCTION admp_val_scft_cous(
42 p_course_cd IN VARCHAR2 ,
43 p_crv_version_number IN NUMBER ,
44 p_unit_set_cd IN VARCHAR2 ,
45 p_us_version_number IN NUMBER ,
46 p_location_cd IN VARCHAR2 ,
47 p_attendance_mode IN VARCHAR2 ,
48 p_attendance_type IN VARCHAR2 ,
49 p_message_name OUT NOCOPY VARCHAR2 )
50 RETURN BOOLEAN;
51 -- Validate crs fund target detail in a valid course offering pattern
52 FUNCTION admp_val_scft_dtl(
53 p_submission_yr IN NUMBER ,
54 p_submission_number IN NUMBER ,
55 p_course_cd IN VARCHAR2 ,
56 p_crv_version_number IN NUMBER ,
57 p_location_cd IN VARCHAR2 ,
58 p_attendance_mode IN VARCHAR2 ,
59 p_attendance_type IN VARCHAR2 ,
60 p_message_name OUT NOCOPY VARCHAR2 )
61 RETURN BOOLEAN;
62 END IGS_AD_VAL_SCFT;