[Home] [Help]
PACKAGE: APPS.IGS_HE_EXTRACT_DLHE_FIELDS_PKG
Source
1 PACKAGE IGS_HE_EXTRACT_DLHE_FIELDS_PKG AS
2 /* $Header: IGSHE9DS.pls 120.1 2006/02/13 17:25:31 jbaber noship $ */
3
4 -- Method of data collection
5 PROCEDURE get_survey_method
6 (p_dlhe_method IN igs_he_stdnt_dlhe.survey_method%TYPE,
7 p_hesa_method OUT NOCOPY VARCHAR2);
8
9 -- Employment circumstances
10 PROCEDURE get_empcir
11 (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
12 p_dlhe_employment IN igs_he_stdnt_dlhe.Employment%TYPE,
13 p_hesa_empcir OUT NOCOPY VARCHAR2);
14
15 -- Mode of Study
16 PROCEDURE get_mode_study
17 (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
18 p_dlhe_further_study IN igs_he_stdnt_dlhe.Further_study%TYPE,
19 p_hesa_modstudy OUT NOCOPY VARCHAR2);
20
21 -- Nature of employers business
22 PROCEDURE get_makedo
23 (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
24 p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,
25 p_dlhe_Emp_business IN igs_he_stdnt_dlhe.Employer_business%TYPE,
26 p_hesa_makedo OUT NOCOPY VARCHAR2);
27
28 -- Standard Industrial Classification
29 PROCEDURE get_sic
30 (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
31 p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,
32 p_dlhe_Emp_class IN igs_he_stdnt_dlhe.Employer_classification%TYPE,
33 p_hesa_sic OUT NOCOPY VARCHAR2);
34
35 -- Location of employment
36 PROCEDURE get_emp_loc
37 (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
38 p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,
39 p_dlhe_Emp_postcode IN igs_he_stdnt_dlhe.Employer_postcode%TYPE,
40 p_dlhe_emp_country IN igs_he_stdnt_dlhe.Employer_country%TYPE,
41 p_hesa_locemp OUT NOCOPY VARCHAR2);
42
43 -- Job title
44 PROCEDURE get_job_title
45 (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
46 p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,
47 p_dlhe_jobtitle IN igs_he_stdnt_dlhe.Job_title%TYPE,
48 p_hesa_jobtitle OUT NOCOPY VARCHAR2);
49
50 -- Standard Occupational Classification
51 PROCEDURE get_occ_class
52 (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
53 p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,
54 p_dlhe_job_class IN igs_he_stdnt_dlhe.Job_classification%TYPE,
55 p_hesa_soc OUT NOCOPY VARCHAR2);
56
57 -- Employer size
58 PROCEDURE get_emp_size
59 (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
60 p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,
61 p_dlhe_emp_size IN igs_he_stdnt_dlhe.Employer_size%TYPE,
62 p_hesa_empsize OUT NOCOPY VARCHAR2);
63
64 -- Duration of employment
65 PROCEDURE get_emp_duration
66 (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
67 p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,
68 p_dlhe_emp_duration IN igs_he_stdnt_dlhe.Job_duration%TYPE,
69 p_hesa_duration OUT NOCOPY VARCHAR2);
70
71 -- Salary
72 PROCEDURE get_salary
73 (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
74 p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,
75 p_dlhe_Job_salary IN igs_he_stdnt_dlhe.Job_salary%TYPE,
76 p_hesa_salary OUT NOCOPY VARCHAR2);
77
78 -- Qualification required for job
79 PROCEDURE get_qual_req
80 (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
81 p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,
82 p_dlhe_qual_req IN igs_he_stdnt_dlhe.Qualification_requirement%TYPE,
83 p_hesa_qualreq OUT NOCOPY VARCHAR2);
84
85 -- Importance to employer
86 PROCEDURE get_emp_imp
87 (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
88 p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,
89 p_dlhe_emp_imp IN igs_he_stdnt_dlhe.Qualification_importance%TYPE,
90 p_hesa_empimp OUT NOCOPY VARCHAR2);
91
92 -- Career related code 1 to 8
93 PROCEDURE get_career
94 (p_hesa_reason IN igs_he_stdnt_dlhe.Job_reason1%TYPE,
95 p_hesa_career OUT NOCOPY VARCHAR2);
96
97 -- How found job
98 PROCEDURE get_job_find
99 (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
100 p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,
101 p_dlhe_job_source IN igs_he_stdnt_dlhe.Job_source%TYPE,
102 p_hesa_jobfnd OUT NOCOPY VARCHAR2);
103
104 -- Previously employed
105 PROCEDURE get_prev_emp
106 (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
107 p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,
108 p_dlhe_previous_job IN igs_he_stdnt_dlhe.Previous_job%TYPE,
109 p_hesa_prevemp OUT NOCOPY VARCHAR2);
110
111 -- Category of previous employment 1 to 6
112 PROCEDURE get_prev_emp_cat
113 (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
114 p_hesa_empcir IN igs_he_ex_rn_dat_fd.value%TYPE,
115 p_hesa_prevemp IN igs_he_ex_rn_dat_fd.value%TYPE,
116 p_dlhe_previous_jobtype IN igs_he_stdnt_dlhe.Previous_jobtype1%TYPE,
117 p_hesa_prevcat OUT NOCOPY VARCHAR2);
118
119 -- Nature of study/training
120 PROCEDURE get_nat_study
121 (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
122 p_hesa_modstudy IN igs_he_ex_rn_dat_fd.value%TYPE,
123 p_dlhe_study_type IN igs_he_stdnt_dlhe.Further_study_type%TYPE,
124 p_hesa_natstudy OUT NOCOPY VARCHAR2);
125
126 -- Professional subject of training
127 PROCEDURE get_train_subj
128 (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
129 p_hesa_modstudy IN igs_he_ex_rn_dat_fd.value%TYPE,
130 p_hesa_natstudy IN igs_he_ex_rn_dat_fd.value%TYPE,
131 p_dlhe_crse_train_subj IN igs_he_stdnt_dlhe.Course_training_subject%TYPE,
132 p_dlhe_res_train_subj IN igs_he_stdnt_dlhe.Research_training_subject%TYPE,
133 p_hesa_profsoct OUT NOCOPY VARCHAR2);
134
135 -- Institution providing study
136 PROCEDURE get_inst_prov
137 (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
138 p_hesa_modstudy IN igs_he_ex_rn_dat_fd.value%TYPE,
139 p_hesa_natstudy IN igs_he_ex_rn_dat_fd.value%TYPE,
140 p_dlhe_study_prov IN igs_he_stdnt_dlhe.Further_study_provider%TYPE,
141 p_hesa_instprov OUT NOCOPY VARCHAR2);
142
143 -- Type of qualification
144 -- smaddali removed parameter p_hesa_natstudy from the procedure for build HECR011 ,bug#3051597
145 PROCEDURE get_type_qual
146 (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
147 p_hesa_modstudy IN igs_he_ex_rn_dat_fd.value%TYPE,
148 p_dlhe_study_qualaim IN igs_he_stdnt_dlhe.Further_study_qualaim%TYPE,
149 p_hesa_typequal OUT NOCOPY VARCHAR2);
150
151 -- Reason for taking another course 1 to 7
152 --smaddali Removed parameter p_hesa_natstudy, p_hesa_emppaid for build HECR011 , bug#3051597
153 PROCEDURE get_study_reason2
154 (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
155 p_hesa_modstudy IN igs_he_ex_rn_dat_fd.value%TYPE,
156 p_dlhe_study_reason IN igs_he_stdnt_dlhe.Study_reason2%TYPE,
157 p_hesa_secint OUT NOCOPY VARCHAR2);
158
159 -- Reason for taking another course 8
160 --smaddali Removed parameter p_hesa_natstudy, p_hesa_emppaid for build HECR011 , bug#3051597
161 PROCEDURE get_study_reason8
162 (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
163 p_hesa_modstudy IN igs_he_ex_rn_dat_fd.value%TYPE,
164 p_dlhe_other_study_reason IN igs_he_stdnt_dlhe.Other_study_reason%TYPE,
165 p_dlhe_no_study_reason IN igs_he_stdnt_dlhe.No_other_study_reason%TYPE,
166 p_hesa_secint8 OUT NOCOPY VARCHAR2);
167
168 -- How funding further study
169 --smaddali Removed parameter p_hesa_natstudy, p_hesa_emppaid for build HECR011 , bug#3051597
170 PROCEDURE get_funding_source
171 (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
172 p_hesa_modstudy IN igs_he_ex_rn_dat_fd.value%TYPE,
173 p_dlhe_funding_source IN igs_he_stdnt_dlhe.Funding_source%TYPE,
174 p_hesa_fundstudy OUT NOCOPY VARCHAR2);
175
176 -- Teaching employment marker
177 PROCEDURE get_teaching_emp
178 (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
179 p_dlhe_qualified IN igs_he_stdnt_dlhe.Qualified_teacher%TYPE,
180 p_dlhe_teaching IN igs_he_stdnt_dlhe.Teacher_teaching%TYPE ,
181 p_dlhe_seeking IN igs_he_stdnt_dlhe.Teacher_seeking%TYPE ,
182 p_hesa_tchemp OUT NOCOPY VARCHAR2);
183
184 -- Teaching sector
185 PROCEDURE get_teaching_sector
186 (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
187 p_hesa_tchemp IN igs_he_ex_rn_dat_fd.value%TYPE,
188 p_dlhe_teach_sector IN igs_he_stdnt_dlhe.Teaching_sector%TYPE,
189 p_hesa_teachsct OUT NOCOPY VARCHAR2);
190
191 -- Teaching phase
192 PROCEDURE get_teaching_phase
193 (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
194 p_hesa_tchemp IN igs_he_ex_rn_dat_fd.value%TYPE,
195 p_dlhe_teach_level IN igs_he_stdnt_dlhe.Teaching_level%TYPE,
196 p_hesa_teachphs OUT NOCOPY VARCHAR2);
197
198 -- Reason for taking original course
199 PROCEDURE get_intent
200 (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
201 p_dlhe_pt_study IN igs_he_stdnt_dlhe.PT_Study%TYPE,
202 p_dlhe_reason_ptcrse IN igs_he_stdnt_dlhe.Reason_for_PTcourse%TYPE,
203 p_hesa_intent OUT NOCOPY VARCHAR2);
204
205 -- Employed during course
206 PROCEDURE get_job_while_study
207 (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
208 p_dlhe_pt_study IN igs_he_stdnt_dlhe.PT_Study%TYPE,
209 p_dlhe_job_while_study IN igs_he_stdnt_dlhe.Job_while_studying%TYPE,
210 p_hesa_empcrse OUT NOCOPY VARCHAR2);
211
212 -- Employer sponsorship 1 to 5
213 PROCEDURE get_emp_sponsorship
214 (p_hesa_method IN igs_he_ex_rn_dat_fd.value%TYPE,
215 p_hesa_empcrse IN igs_he_ex_rn_dat_fd.value%TYPE,
216 p_dlhe_pt_study IN igs_he_stdnt_dlhe.PT_Study%TYPE,
217 p_dlhe_emp_support IN igs_he_stdnt_dlhe.Employer_support1%TYPE,
218 p_hesa_empspns OUT NOCOPY VARCHAR2);
219
220 END IGS_HE_EXTRACT_DLHE_FIELDS_PKG;