1 PACKAGE IGS_PS_GEN_003 AS
2 /* $Header: IGSPS03S.pls 120.3 2005/09/29 06:42:38 appldev ship $ */
3
4 -------------------------------------------------------------------------------------------
5 --Change History:
6 --Who When What
7 --sarakshi 29-Sep-2005 Bug#4589117, changed the signature of the function CheckValid
8 --sarakshi 26-Sep-2005 Bug#4589301, modified the signature of function CheckValid
9 --sarakshi 21-oct-2003 Enh#3052452,added function enrollment_for_uoo_check
10 -------------------------------------------------------------------------------------------
11
12 PROCEDURE crsp_get_coo_key(
13 p_coo_id IN OUT NOCOPY NUMBER ,
14 p_course_cd IN OUT NOCOPY VARCHAR2 ,
15 p_version_number IN OUT NOCOPY NUMBER ,
16 p_cal_type IN OUT NOCOPY VARCHAR2 ,
17 p_location_cd IN OUT NOCOPY VARCHAR2 ,
18 p_attendance_mode IN OUT NOCOPY VARCHAR2 ,
19 p_attendance_type IN OUT NOCOPY VARCHAR2 )
20 ;
21
22 PROCEDURE crsp_get_cop_key(
23 p_cop_id IN OUT NOCOPY NUMBER ,
24 p_course_cd IN OUT NOCOPY VARCHAR2 ,
25 p_version_number IN OUT NOCOPY NUMBER ,
26 p_cal_type IN OUT NOCOPY VARCHAR2 ,
27 p_ci_sequence_number IN OUT NOCOPY NUMBER ,
28 p_location_cd IN OUT NOCOPY VARCHAR2 ,
29 p_attendance_mode IN OUT NOCOPY VARCHAR2 ,
30 p_attendance_type IN OUT NOCOPY VARCHAR2 )
31 ;
32
33 FUNCTION crsp_get_cous_ind(
34 p_course_cd IN VARCHAR2 ,
35 p_crv_version_number IN NUMBER ,
36 p_cal_type IN VARCHAR2 ,
37 p_unit_set_cd IN VARCHAR2 )
38 RETURN VARCHAR2;
39
40 FUNCTION crsp_get_cous_subind(
41 p_course_cd IN VARCHAR2 ,
42 p_crv_version_number IN NUMBER ,
43 p_cal_type IN VARCHAR2 ,
44 p_unit_set_cd IN VARCHAR2 ,
45 p_us_version_number IN NUMBER )
46 RETURN VARCHAR2;
47
48
49 PROCEDURE CRSP_INS_CI_COP (
50 errbuf out NOCOPY varchar2,
51 retcode out NOCOPY number,
52 p_source_cal IN VARCHAR2 ,
53 p_dest_cal IN VARCHAR2 ,
54 p_org_unit IN VARCHAR2,
55 p_org_id IN NUMBER)
56 ;
57
58 FUNCTION crsp_ins_coi_cop(
59 p_course_cd IN VARCHAR2 ,
60 p_version_number IN NUMBER ,
61 p_source_cal_type IN VARCHAR2 ,
62 p_source_sequence_number IN NUMBER ,
63 p_dest_cal_type IN VARCHAR2 ,
64 p_dest_sequence_number IN NUMBER ,
65 p_message_name OUT NOCOPY VARCHAR2 )
66 RETURN boolean;
67
68 PROCEDURE crsp_ins_cous(
69 p_course_cd IN VARCHAR2 ,
70 p_crv_version_number IN NUMBER ,
71 p_cal_type IN VARCHAR2 ,
72 p_unit_set_cd IN VARCHAR2 ,
73 p_us_version_number IN NUMBER ,
74 p_override_title IN VARCHAR2 ,
75 p_only_as_sub_ind IN VARCHAR2 DEFAULT 'N')
76 ;
77
78 FUNCTION enrollment_for_uoo_check(
79 p_n_uoo_id IN NUMBER)
80 RETURN BOOLEAN;
81
82 FUNCTION CheckValid(
83 p_n_uoo_id NUMBER,
84 p_n_usec_occurs_id NUMBER,
85 p_c_building_cd VARCHAR2,
86 p_c_room_cd VARCHAR2,
87 p_d_start_date DATE,
88 p_d_end_date DATE,
89 p_d_start_time DATE,
90 p_d_end_time DATE,
91 p_c_monday VARCHAR2,
92 p_c_tuesday VARCHAR2,
93 p_c_wednesday VARCHAR2,
94 p_c_thrusday VARCHAR2,
95 p_c_friday VARCHAR2,
96 p_c_saturday VARCHAR2,
97 p_c_sunday VARCHAR2,
98 p_called_from VARCHAR2 ,
99 p_c_clash_section OUT NOCOPY VARCHAR2,
100 p_c_clash_occurrence OUT NOCOPY VARCHAR2
101 )
102 RETURN BOOLEAN;
103
104
105 END IGS_PS_GEN_003;