1 PACKAGE IGS_PS_GEN_006 AS
2 /* $Header: IGSPS06S.pls 120.0 2005/06/01 12:37:17 appldev noship $ */
3
4 -- Who When What
5 --sarakshi 30-Apr-2004 Bug#3568858, Added parameters ovrd_wkld_val_flag, workload_val_code to crsp_ins_uv_hist .
6 --sarakshi 03-Nov-2003 Enh#3116171,Modified the procedure crsp_ins_uv_hist to include a new parameter p_billing_credit_points
7 --sarakshi 02-Sep-2003 Enh#3052452,removed the reference of the column sup_unit_allowed_ind and sub_unit_allowed_ind
8 -- shtatiko 25-OCT-2002 Added auditable_ind, audit_permission_ind and max_auditors_allowed
9 -- to crsp_ins_uv procedure. This has been done as per Bug# 2636716.
10 -- jbegum 18 April 02 As part of bug fix of bug #2322290 and bug#2250784
11 -- Removed the following 4 columns
12 -- BILLING_CREDIT_POINTS,BILLING_HRS,FIN_AID_CP,FIN_AID_HRS
13 -- from crsp_ins_uv_hist procedure.
14 -- rgangara 03-May-2001 modified by adding 2 parameters to crsp_ins_uv_hist as per DLD Unit Section Enrollment INfo.
15 FUNCTION CRSP_GET_UCL_MODE(
16 p_unit_class IN VARCHAR2 )
17 RETURN VARCHAR2;
18 PRAGMA RESTRICT_REFERENCES(CRSP_GET_UCL_MODE,WNDS,WNPS);
19
20 FUNCTION CRSP_GET_UOO_ID(
21 p_unit_cd IN VARCHAR2 ,
22 p_version_number IN NUMBER ,
23 p_cal_type IN VARCHAR2 ,
24 p_ci_sequence_number IN NUMBER ,
25 p_location_cd IN VARCHAR2 ,
26 p_unit_class IN VARCHAR2 )
27 RETURN NUMBER;
28 PRAGMA RESTRICT_REFERENCES(CRSP_GET_UOO_ID,WNDS,WNPS);
29
30 PROCEDURE crsp_get_uoo_key(
31 p_unit_cd IN OUT NOCOPY VARCHAR2 ,
32 p_version_number IN OUT NOCOPY NUMBER ,
33 p_cal_type IN OUT NOCOPY VARCHAR2 ,
34 p_ci_sequence_number IN OUT NOCOPY NUMBER ,
35 p_location_cd IN OUT NOCOPY VARCHAR2 ,
36 p_unit_class IN OUT NOCOPY VARCHAR2 ,
37 p_uoo_id IN OUT NOCOPY NUMBER )
38 ;
39
40 FUNCTION crsp_get_us_admin(
41 p_unit_set_cd IN VARCHAR2 ,
42 p_version_number IN NUMBER )
43 RETURN VARCHAR2;
44
45 FUNCTION crsp_get_us_sys_sts(
46 p_unit_set_status IN VARCHAR2 )
47 RETURN VARCHAR2;
48
49 PROCEDURE crsp_ins_ci_uop_uoo(
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 PROCEDURE crsp_ins_us_hist(
59 p_unit_set_cd IN VARCHAR2 ,
60 p_version_number IN NUMBER ,
61 p_new_unit_set_status IN VARCHAR2 ,
62 p_old_unit_set_status IN VARCHAR2 ,
63 p_new_unit_set_cat IN VARCHAR2 ,
64 p_old_unit_set_cat IN VARCHAR2 ,
65 p_new_start_dt IN DATE ,
66 p_old_start_dt IN DATE ,
67 p_new_review_dt IN DATE ,
68 p_old_review_dt IN DATE ,
69 p_new_expiry_dt IN DATE ,
70 p_old_expiry_dt IN DATE ,
71 p_new_end_dt IN DATE ,
72 p_old_end_dt IN DATE ,
73 p_new_title IN VARCHAR2 ,
74 p_old_title IN VARCHAR2 ,
75 p_new_short_title IN VARCHAR2 ,
76 p_old_short_title IN VARCHAR2 ,
77 p_new_abbreviation IN VARCHAR2 ,
78 p_old_abbreviation IN VARCHAR2 ,
79 p_new_responsible_org_unit_cd IN VARCHAR2 ,
80 p_old_responsible_org_unit_cd IN VARCHAR2 ,
81 p_new_responsible_ou_start_dt IN DATE ,
82 p_old_responsible_ou_start_dt IN DATE ,
83 p_new_administrative_ind IN VARCHAR2 DEFAULT 'N',
84 p_old_administrative_ind IN VARCHAR2 DEFAULT 'N',
85 p_new_authorisation_rqrd_ind IN VARCHAR2 DEFAULT 'N',
86 p_old_authorisation_rqrd_ind IN VARCHAR2 DEFAULT 'N',
87 p_new_update_who IN VARCHAR2 ,
88 p_old_update_who IN VARCHAR2 ,
89 p_new_update_on IN DATE ,
90 p_old_update_on IN DATE );
91
92 PROCEDURE crsp_ins_uv_hist(
93 p_unit_cd IN VARCHAR2 ,
94 p_version_number IN NUMBER ,
95 p_last_update_on IN DATE ,
96 p_update_on IN DATE ,
97 p_last_update_who IN VARCHAR2 ,
98 p_start_dt IN DATE ,
99 p_review_dt IN DATE ,
100 p_expiry_dt IN DATE ,
101 p_end_dt IN DATE ,
102 p_unit_status IN VARCHAR2 ,
103 p_title IN VARCHAR2 ,
104 p_short_title IN VARCHAR2 ,
105 p_title_override_ind IN VARCHAR2 DEFAULT 'N',
106 p_abbreviation IN VARCHAR2 ,
107 p_unit_level IN VARCHAR2 ,
108 p_credit_point_descriptor IN VARCHAR2 ,
109 p_achievable_credit_points IN NUMBER ,
110 p_enrolled_credit_points IN NUMBER ,
111 p_supp_exam_permitted_ind IN VARCHAR2 DEFAULT 'N',
112 p_points_increment IN NUMBER ,
113 p_points_min IN NUMBER ,
114 p_points_max IN NUMBER ,
115 p_points_override_ind IN VARCHAR2 DEFAULT 'N',
116 p_coord_person_id IN NUMBER ,
117 p_owner_org_unit_cd IN VARCHAR2 ,
118 p_owner_ou_start_dt IN DATE ,
119 p_award_course_only_ind IN VARCHAR2 DEFAULT 'N',
120 p_research_unit_ind IN VARCHAR2 DEFAULT 'N',
121 p_industrial_ind IN VARCHAR2 DEFAULT 'N',
122 p_practical_ind IN VARCHAR2 DEFAULT 'N',
123 p_repeatable_ind IN VARCHAR2 DEFAULT 'N',
124 p_assessable_ind IN VARCHAR2 DEFAULT 'N',
125 p_unit_int_course_level_cd IN VARCHAR2,
126 p_ss_enrol_ind IN VARCHAR2 DEFAULT 'N',
127 p_ivr_enrol_ind IN VARCHAR2 DEFAULT 'N',
128 p_advance_maximum IN NUMBER,
129 p_approval_date IN DATE,
130 p_cal_type_enrol_load_cal IN VARCHAR2,
131 p_cal_type_offer_load_cal IN VARCHAR2,
132 p_clock_hours IN NUMBER,
133 p_contact_hrs_lab IN NUMBER,
134 p_contact_hrs_lecture IN NUMBER,
135 p_contact_hrs_other IN NUMBER,
136 p_continuing_education_units IN NUMBER,
137 p_curriculum_id IN VARCHAR2 ,
138 p_enrollment_expected IN NUMBER,
139 p_enrollment_maximum IN NUMBER,
140 p_enrollment_minimum IN NUMBER,
141 p_exclude_from_max_cp_limit IN VARCHAR2 DEFAULT 'N',
142 p_federal_financial_aid IN VARCHAR2 DEFAULT 'N',
143 p_institutional_financial_aid IN VARCHAR2 DEFAULT 'N',
144 p_lab_credit_points IN NUMBER,
145 p_lecture_credit_points IN NUMBER,
146 p_max_repeat_credit_points IN NUMBER,
147 p_max_repeats_for_credit IN NUMBER,
148 p_max_repeats_for_funding IN NUMBER,
149 p_non_schd_required_hrs IN NUMBER,
150 p_other_credit_points IN NUMBER,
151 p_override_enrollment_max IN NUMBER,
152 p_record_exclusion_flag IN VARCHAR2 DEFAULT 'N',
153 p_ss_display_ind IN VARCHAR2 DEFAULT 'N',
154 p_rpt_fmly_id IN NUMBER,
155 p_same_teach_period_repeats IN NUMBER DEFAULT 'N',
156 p_same_teach_period_repeats_cp IN NUMBER,
157 p_same_teaching_period IN VARCHAR2,
158 p_sequence_num_enrol_load_cal IN NUMBER,
159 p_sequence_num_offer_load_cal IN NUMBER,
160 p_special_permission_ind IN VARCHAR2 DEFAULT 'N',
161 p_state_financial_aid IN VARCHAR2 DEFAULT 'N',
162 p_subtitle_id IN NUMBER,
163 p_subtitle_modifiable_flag IN VARCHAR2 DEFAULT 'N',
164 p_unit_type_id IN NUMBER,
165 p_work_load_cp_lab IN NUMBER,
166 p_work_load_cp_lecture IN NUMBER,
167 p_work_load_other IN NUMBER,
168 p_claimable_hours IN NUMBER DEFAULT NULL ,
169 p_auditable_ind IN VARCHAR2 DEFAULT 'N',
170 p_audit_permission_ind IN VARCHAR2 DEFAULT 'N',
171 p_max_auditors_allowed IN NUMBER DEFAULT NULL,
172 p_billing_credit_points IN NUMBER DEFAULT NULL,
173 p_ovrd_wkld_val_flag IN VARCHAR2 ,
174 p_workload_val_code IN VARCHAR2 ,
175 p_billing_hrs IN NUMBER
176 );
177
178 END IGS_PS_GEN_006;