1 PACKAGE igs_he_st_prog_all_pkg AS
2 /* $Header: IGSWI26S.pls 120.1 2006/02/06 19:54:29 jbaber noship $ */
3
4 PROCEDURE insert_row (
5 x_rowid IN OUT NOCOPY VARCHAR2,
6 x_hesa_st_prog_id IN OUT NOCOPY NUMBER,
7 x_org_id IN NUMBER,
8 x_course_cd IN VARCHAR2,
9 x_version_number IN NUMBER,
10 x_teacher_train_prog_id IN VARCHAR2,
11 x_itt_phase IN VARCHAR2,
12 x_bilingual_itt_marker IN VARCHAR2,
13 x_teaching_qual_sought_sector IN VARCHAR2,
14 x_teaching_qual_sought_subj1 IN VARCHAR2,
15 x_teaching_qual_sought_subj2 IN VARCHAR2,
16 x_teaching_qual_sought_subj3 IN VARCHAR2,
17 x_location_of_study IN VARCHAR2,
18 x_other_inst_prov_teaching1 IN VARCHAR2,
19 x_other_inst_prov_teaching2 IN VARCHAR2,
20 x_prop_teaching_in_welsh IN NUMBER,
21 x_prop_not_taught IN NUMBER,
22 x_credit_transfer_scheme IN VARCHAR2,
23 x_return_type IN VARCHAR2,
24 x_default_award IN VARCHAR2,
25 x_program_calc IN VARCHAR2,
26 x_level_applicable_to_funding IN VARCHAR2,
27 x_franchising_activity IN VARCHAR2,
28 x_nhs_funding_source IN VARCHAR2,
29 x_fe_program_marker IN VARCHAR2,
30 x_fee_band IN VARCHAR2,
31 x_fundability IN VARCHAR2,
32 x_fte_intensity IN NUMBER DEFAULT NULL,
33 x_teach_period_start_dt IN DATE DEFAULT NULL,
34 x_teach_period_end_dt IN DATE DEFAULT NULL,
35 x_mode IN VARCHAR2 DEFAULT NULL,
36 x_implied_fund_rate IN NUMBER DEFAULT NULL,
37 x_gov_initiatives_cd IN VARCHAR2 DEFAULT NULL,
38 x_units_for_qual IN NUMBER DEFAULT NULL,
39 x_disadv_uplift_elig_cd IN VARCHAR2 DEFAULT NULL,
40 x_franch_partner_cd IN VARCHAR2 DEFAULT NULL,
41 x_franch_out_arr_cd IN VARCHAR2 DEFAULT NULL,
42 x_exclude_flag IN VARCHAR2
43 );
44
45 PROCEDURE lock_row (
46 x_rowid IN VARCHAR2,
47 x_hesa_st_prog_id IN NUMBER,
48 x_org_id IN NUMBER,
49 x_course_cd IN VARCHAR2,
50 x_version_number IN NUMBER,
51 x_teacher_train_prog_id IN VARCHAR2,
52 x_itt_phase IN VARCHAR2,
53 x_bilingual_itt_marker IN VARCHAR2,
54 x_teaching_qual_sought_sector IN VARCHAR2,
55 x_teaching_qual_sought_subj1 IN VARCHAR2,
56 x_teaching_qual_sought_subj2 IN VARCHAR2,
57 x_teaching_qual_sought_subj3 IN VARCHAR2,
58 x_location_of_study IN VARCHAR2,
59 x_other_inst_prov_teaching1 IN VARCHAR2,
60 x_other_inst_prov_teaching2 IN VARCHAR2,
61 x_prop_teaching_in_welsh IN NUMBER,
62 x_prop_not_taught IN NUMBER,
63 x_credit_transfer_scheme IN VARCHAR2,
64 x_return_type IN VARCHAR2,
65 x_default_award IN VARCHAR2,
66 x_program_calc IN VARCHAR2,
67 x_level_applicable_to_funding IN VARCHAR2,
68 x_franchising_activity IN VARCHAR2,
69 x_nhs_funding_source IN VARCHAR2,
70 x_fe_program_marker IN VARCHAR2,
71 x_fee_band IN VARCHAR2,
72 x_fundability IN VARCHAR2,
73 x_fte_intensity IN NUMBER DEFAULT NULL,
74 x_teach_period_start_dt IN DATE DEFAULT NULL,
75 x_teach_period_end_dt IN DATE DEFAULT NULL,
76 x_implied_fund_rate IN NUMBER DEFAULT NULL,
77 x_gov_initiatives_cd IN VARCHAR2 DEFAULT NULL,
78 x_units_for_qual IN NUMBER DEFAULT NULL,
79 x_disadv_uplift_elig_cd IN VARCHAR2 DEFAULT NULL,
80 x_franch_partner_cd IN VARCHAR2 DEFAULT NULL,
81 x_franch_out_arr_cd IN VARCHAR2 DEFAULT NULL,
82 x_exclude_flag IN VARCHAR2
83 );
84
85 PROCEDURE update_row (
86 x_rowid IN VARCHAR2,
87 x_hesa_st_prog_id IN NUMBER,
88 x_org_id IN NUMBER,
89 x_course_cd IN VARCHAR2,
90 x_version_number IN NUMBER,
91 x_teacher_train_prog_id IN VARCHAR2,
92 x_itt_phase IN VARCHAR2,
93 x_bilingual_itt_marker IN VARCHAR2,
94 x_teaching_qual_sought_sector IN VARCHAR2,
95 x_teaching_qual_sought_subj1 IN VARCHAR2,
96 x_teaching_qual_sought_subj2 IN VARCHAR2,
97 x_teaching_qual_sought_subj3 IN VARCHAR2,
98 x_location_of_study IN VARCHAR2,
99 x_other_inst_prov_teaching1 IN VARCHAR2,
100 x_other_inst_prov_teaching2 IN VARCHAR2,
101 x_prop_teaching_in_welsh IN NUMBER,
102 x_prop_not_taught IN NUMBER,
103 x_credit_transfer_scheme IN VARCHAR2,
104 x_return_type IN VARCHAR2,
105 x_default_award IN VARCHAR2,
106 x_program_calc IN VARCHAR2,
107 x_level_applicable_to_funding IN VARCHAR2,
108 x_franchising_activity IN VARCHAR2,
109 x_nhs_funding_source IN VARCHAR2,
110 x_fe_program_marker IN VARCHAR2,
111 x_fee_band IN VARCHAR2,
112 x_fundability IN VARCHAR2,
113 x_fte_intensity IN NUMBER DEFAULT NULL,
114 x_teach_period_start_dt IN DATE DEFAULT NULL,
115 x_teach_period_end_dt IN DATE DEFAULT NULL,
116 x_mode IN VARCHAR2 DEFAULT NULL,
117 x_implied_fund_rate IN NUMBER DEFAULT NULL,
118 x_gov_initiatives_cd IN VARCHAR2 DEFAULT NULL,
119 x_units_for_qual IN NUMBER DEFAULT NULL,
120 x_disadv_uplift_elig_cd IN VARCHAR2 DEFAULT NULL,
121 x_franch_partner_cd IN VARCHAR2 DEFAULT NULL,
122 x_franch_out_arr_cd IN VARCHAR2 DEFAULT NULL,
123 x_exclude_flag IN VARCHAR2
124 );
125
126 PROCEDURE add_row (
127 x_rowid IN OUT NOCOPY VARCHAR2,
128 x_hesa_st_prog_id IN OUT NOCOPY NUMBER,
129 x_org_id IN NUMBER,
130 x_course_cd IN VARCHAR2,
131 x_version_number IN NUMBER,
132 x_teacher_train_prog_id IN VARCHAR2,
133 x_itt_phase IN VARCHAR2,
134 x_bilingual_itt_marker IN VARCHAR2,
135 x_teaching_qual_sought_sector IN VARCHAR2,
136 x_teaching_qual_sought_subj1 IN VARCHAR2,
137 x_teaching_qual_sought_subj2 IN VARCHAR2,
138 x_teaching_qual_sought_subj3 IN VARCHAR2,
139 x_location_of_study IN VARCHAR2,
140 x_other_inst_prov_teaching1 IN VARCHAR2,
141 x_other_inst_prov_teaching2 IN VARCHAR2,
142 x_prop_teaching_in_welsh IN NUMBER,
143 x_prop_not_taught IN NUMBER,
144 x_credit_transfer_scheme IN VARCHAR2,
145 x_return_type IN VARCHAR2,
146 x_default_award IN VARCHAR2,
147 x_program_calc IN VARCHAR2,
148 x_level_applicable_to_funding IN VARCHAR2,
149 x_franchising_activity IN VARCHAR2,
150 x_nhs_funding_source IN VARCHAR2,
151 x_fe_program_marker IN VARCHAR2,
152 x_fee_band IN VARCHAR2,
153 x_fundability IN VARCHAR2,
154 x_fte_intensity IN NUMBER DEFAULT NULL,
155 x_teach_period_start_dt IN DATE DEFAULT NULL ,
156 x_teach_period_end_dt IN DATE DEFAULT NULL,
157 x_mode IN VARCHAR2 DEFAULT NULL,
158 x_implied_fund_rate IN NUMBER DEFAULT NULL,
159 x_gov_initiatives_cd IN VARCHAR2 DEFAULT NULL,
160 x_units_for_qual IN NUMBER DEFAULT NULL,
161 x_disadv_uplift_elig_cd IN VARCHAR2 DEFAULT NULL,
162 x_franch_partner_cd IN VARCHAR2 DEFAULT NULL,
163 x_franch_out_arr_cd IN VARCHAR2 DEFAULT NULL,
164 x_exclude_flag IN VARCHAR2
165 );
166
167 PROCEDURE delete_row (
168 x_rowid IN VARCHAR2
169 );
170
171 FUNCTION get_pk_for_validation (
172 x_hesa_st_prog_id IN NUMBER
173 ) RETURN BOOLEAN;
174
175 FUNCTION get_uk_for_validation (
176 x_course_cd IN VARCHAR2,
177 x_version_number IN NUMBER
178 ) RETURN BOOLEAN;
179
180 PROCEDURE get_fk_igs_ps_ver_all (
181 x_course_cd IN VARCHAR2,
182 x_version_number IN NUMBER
183 );
184
185 PROCEDURE before_dml (
186 p_action IN VARCHAR2,
187 x_rowid IN VARCHAR2 DEFAULT NULL,
188 x_hesa_st_prog_id IN NUMBER DEFAULT NULL,
189 x_org_id IN NUMBER DEFAULT NULL,
190 x_course_cd IN VARCHAR2 DEFAULT NULL,
191 x_version_number IN NUMBER DEFAULT NULL,
192 x_teacher_train_prog_id IN VARCHAR2 DEFAULT NULL,
193 x_itt_phase IN VARCHAR2 DEFAULT NULL,
194 x_bilingual_itt_marker IN VARCHAR2 DEFAULT NULL,
195 x_teaching_qual_sought_sector IN VARCHAR2 DEFAULT NULL,
196 x_teaching_qual_sought_subj1 IN VARCHAR2 DEFAULT NULL,
197 x_teaching_qual_sought_subj2 IN VARCHAR2 DEFAULT NULL,
198 x_teaching_qual_sought_subj3 IN VARCHAR2 DEFAULT NULL,
199 x_location_of_study IN VARCHAR2 DEFAULT NULL,
200 x_other_inst_prov_teaching1 IN VARCHAR2 DEFAULT NULL,
201 x_other_inst_prov_teaching2 IN VARCHAR2 DEFAULT NULL,
202 x_prop_teaching_in_welsh IN NUMBER DEFAULT NULL,
203 x_prop_not_taught IN NUMBER DEFAULT NULL,
204 x_credit_transfer_scheme IN VARCHAR2 DEFAULT NULL,
205 x_return_type IN VARCHAR2 DEFAULT NULL,
206 x_default_award IN VARCHAR2 DEFAULT NULL,
207 x_program_calc IN VARCHAR2 DEFAULT NULL,
208 x_level_applicable_to_funding IN VARCHAR2 DEFAULT NULL,
209 x_franchising_activity IN VARCHAR2 DEFAULT NULL,
210 x_nhs_funding_source IN VARCHAR2 DEFAULT NULL,
211 x_fe_program_marker IN VARCHAR2 DEFAULT NULL,
212 x_fee_band IN VARCHAR2 DEFAULT NULL,
213 x_fundability IN VARCHAR2 DEFAULT NULL,
214 x_fte_intensity IN NUMBER DEFAULT NULL,
215 x_teach_period_start_dt IN DATE DEFAULT NULL ,
216 x_teach_period_end_dt IN DATE DEFAULT NULL,
217 x_creation_date IN DATE DEFAULT NULL,
218 x_created_by IN NUMBER DEFAULT NULL,
219 x_last_update_date IN DATE DEFAULT NULL,
220 x_last_updated_by IN NUMBER DEFAULT NULL,
221 x_last_update_login IN NUMBER DEFAULT NULL,
222 x_implied_fund_rate IN NUMBER DEFAULT NULL,
223 x_gov_initiatives_cd IN VARCHAR2 DEFAULT NULL,
224 x_units_for_qual IN NUMBER DEFAULT NULL,
225 x_disadv_uplift_elig_cd IN VARCHAR2 DEFAULT NULL,
226 x_franch_partner_cd IN VARCHAR2 DEFAULT NULL,
227 x_franch_out_arr_cd IN VARCHAR2 DEFAULT NULL,
228 x_exclude_flag IN VARCHAR2 DEFAULT NULL
229 );
230
231 END igs_he_st_prog_all_pkg;