eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_HE_EXTRACT_DLHE_FIELDS_PKG dependencies on IGS_HE_STDNT_DLHE

Line 6: (p_dlhe_method IN igs_he_stdnt_dlhe.survey_method%TYPE,

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

Line 12: p_dlhe_employment IN igs_he_stdnt_dlhe.Employment%TYPE,

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

Line 18: p_dlhe_further_study IN igs_he_stdnt_dlhe.Further_study%TYPE,

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

Line 25: p_dlhe_Emp_business IN igs_he_stdnt_dlhe.Employer_business%TYPE,

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

Line 32: p_dlhe_Emp_class IN igs_he_stdnt_dlhe.Employer_classification%TYPE,

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

Line 39: p_dlhe_Emp_postcode IN igs_he_stdnt_dlhe.Employer_postcode%TYPE,

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

Line 40: p_dlhe_emp_country IN igs_he_stdnt_dlhe.Employer_country%TYPE,

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

Line 47: p_dlhe_jobtitle IN igs_he_stdnt_dlhe.Job_title%TYPE,

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

Line 54: p_dlhe_job_class IN igs_he_stdnt_dlhe.Job_classification%TYPE,

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

Line 61: p_dlhe_emp_size IN igs_he_stdnt_dlhe.Employer_size%TYPE,

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

Line 68: p_dlhe_emp_duration IN igs_he_stdnt_dlhe.Job_duration%TYPE,

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

Line 75: p_dlhe_Job_salary IN igs_he_stdnt_dlhe.Job_salary%TYPE,

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

Line 82: p_dlhe_qual_req IN igs_he_stdnt_dlhe.Qualification_requirement%TYPE,

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

Line 89: p_dlhe_emp_imp IN igs_he_stdnt_dlhe.Qualification_importance%TYPE,

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

Line 94: (p_hesa_reason IN igs_he_stdnt_dlhe.Job_reason1%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

Line 101: p_dlhe_job_source IN igs_he_stdnt_dlhe.Job_source%TYPE,

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

Line 108: p_dlhe_previous_job IN igs_he_stdnt_dlhe.Previous_job%TYPE,

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

Line 116: p_dlhe_previous_jobtype IN igs_he_stdnt_dlhe.Previous_jobtype1%TYPE,

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

Line 123: p_dlhe_study_type IN igs_he_stdnt_dlhe.Further_study_type%TYPE,

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

Line 131: p_dlhe_crse_train_subj IN igs_he_stdnt_dlhe.Course_training_subject%TYPE,

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

Line 132: p_dlhe_res_train_subj IN igs_he_stdnt_dlhe.Research_training_subject%TYPE,

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

Line 140: p_dlhe_study_prov IN igs_he_stdnt_dlhe.Further_study_provider%TYPE,

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

Line 148: p_dlhe_study_qualaim IN igs_he_stdnt_dlhe.Further_study_qualaim%TYPE,

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

Line 156: p_dlhe_study_reason IN igs_he_stdnt_dlhe.Study_reason2%TYPE,

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

Line 164: p_dlhe_other_study_reason IN igs_he_stdnt_dlhe.Other_study_reason%TYPE,

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

Line 165: p_dlhe_no_study_reason IN igs_he_stdnt_dlhe.No_other_study_reason%TYPE,

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

Line 173: p_dlhe_funding_source IN igs_he_stdnt_dlhe.Funding_source%TYPE,

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

Line 179: p_dlhe_qualified IN igs_he_stdnt_dlhe.Qualified_teacher%TYPE,

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:

Line 180: p_dlhe_teaching IN igs_he_stdnt_dlhe.Teacher_teaching%TYPE ,

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

Line 181: p_dlhe_seeking IN igs_he_stdnt_dlhe.Teacher_seeking%TYPE ,

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

Line 188: p_dlhe_teach_sector IN igs_he_stdnt_dlhe.Teaching_sector%TYPE,

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

Line 195: p_dlhe_teach_level IN igs_he_stdnt_dlhe.Teaching_level%TYPE,

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

Line 201: p_dlhe_pt_study IN igs_he_stdnt_dlhe.PT_Study%TYPE,

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

Line 202: p_dlhe_reason_ptcrse IN igs_he_stdnt_dlhe.Reason_for_PTcourse%TYPE,

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

Line 208: p_dlhe_pt_study IN igs_he_stdnt_dlhe.PT_Study%TYPE,

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

Line 209: p_dlhe_job_while_study IN igs_he_stdnt_dlhe.Job_while_studying%TYPE,

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

Line 216: p_dlhe_pt_study IN igs_he_stdnt_dlhe.PT_Study%TYPE,

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;

Line 217: p_dlhe_emp_support IN igs_he_stdnt_dlhe.Employer_support1%TYPE,

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;