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_FIELDS_PKG dependencies on IGS_HE_EN_SUSA

Line 83: p_susa_fund_cd IN igs_he_en_susa.fundability_code%TYPE,

79:
80: -- smaddali 11-dec-03 Modified for bug#3235753 , added 2 new parameters
81: PROCEDURE get_fundability_cd
82: (p_person_id IN igs_pe_person.person_id%TYPE,
83: p_susa_fund_cd IN igs_he_en_susa.fundability_code%TYPE,
84: p_spa_funding_source IN igs_en_stdnt_ps_att.funding_source%TYPE,
85: p_poous_fund_cd IN igs_he_poous.fundability_cd%TYPE,
86: p_prg_fund_cd IN igs_he_st_prog.fundability%TYPE,
87: p_prg_funding_source IN igs_fi_fnd_src_rstn.funding_source%TYPE,

Line 121: (p_oss_dis_allow IN igs_he_en_susa.disability_allow%TYPE,

117: p_oss_eth IN igs_pe_stat_v.ethnic_origin_id%TYPE,
118: p_hesa_eth OUT NOCOPY VARCHAR2);
119:
120: PROCEDURE get_disablity_allow
121: (p_oss_dis_allow IN igs_he_en_susa.disability_allow%TYPE,
122: p_hesa_dis_allow OUT NOCOPY VARCHAR2);
123:
124: -- smaddali 11-dec-03 Modified for bug#3235753 , added 2 new parameters
125: PROCEDURE get_disablity

Line 132: (p_oss_supp_band IN igs_he_en_susa.additional_sup_band%TYPE,

128: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,
129: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);
130:
131: PROCEDURE get_addnl_supp_band
132: (p_oss_supp_band IN igs_he_en_susa.additional_sup_band%TYPE,
133: p_hesa_supp_band OUT NOCOPY VARCHAR2);
134:
135: PROCEDURE get_yr_left_last_inst
136: (p_person_id IN igs_pe_person.person_id%TYPE,

Line 144: p_susa_new_ent_to_he IN igs_he_en_susa.new_he_entrant_cd%TYPE,

140: p_year OUT NOCOPY VARCHAR2);
141:
142: PROCEDURE get_new_ent_to_he
143: (p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
144: p_susa_new_ent_to_he IN igs_he_en_susa.new_he_entrant_cd%TYPE,
145: p_yop IN VARCHAR2,
146: p_high_qual_on_ent IN igs_he_st_spa.highest_qual_on_entry%TYPE,
147: p_domicile IN igs_he_st_spa.domicile_cd%TYPE,
148: p_hesa_new_ent_to_he OUT NOCOPY VARCHAR2);

Line 151: (p_unit_set_cd IN igs_he_en_susa.unit_set_cd%TYPE,

147: p_domicile IN igs_he_st_spa.domicile_cd%TYPE,
148: p_hesa_new_ent_to_he OUT NOCOPY VARCHAR2);
149:
150: PROCEDURE get_year_of_prog
151: (p_unit_set_cd IN igs_he_en_susa.unit_set_cd%TYPE,
152: p_year_of_prog OUT NOCOPY VARCHAR2);
153:
154: PROCEDURE get_special_student
155: (p_ad_special_student IN igs_he_ad_dtl.special_student_cd%TYPE,

Line 163: (p_person_id IN igs_he_en_susa.person_id%TYPE,

159:
160: -- smaddali 29-oct-03 modified procedure get_year_of_student to add 1 new parameter for bug#3224246
161: -- jbaber 30-aug-04 - added new parameter p_susa_year_of_student for HEFD350
162: PROCEDURE get_year_of_student
163: (p_person_id IN igs_he_en_susa.person_id%TYPE,
164: p_course_cd IN igs_he_en_susa.course_cd%TYPE,
165: p_unit_set_cd IN igs_he_en_susa.unit_set_cd%TYPE,
166: p_sequence_number IN igs_he_en_susa.sequence_number%TYPE,
167: p_year_of_student OUT NOCOPY VARCHAR2,

Line 164: p_course_cd IN igs_he_en_susa.course_cd%TYPE,

160: -- smaddali 29-oct-03 modified procedure get_year_of_student to add 1 new parameter for bug#3224246
161: -- jbaber 30-aug-04 - added new parameter p_susa_year_of_student for HEFD350
162: PROCEDURE get_year_of_student
163: (p_person_id IN igs_he_en_susa.person_id%TYPE,
164: p_course_cd IN igs_he_en_susa.course_cd%TYPE,
165: p_unit_set_cd IN igs_he_en_susa.unit_set_cd%TYPE,
166: p_sequence_number IN igs_he_en_susa.sequence_number%TYPE,
167: p_year_of_student OUT NOCOPY VARCHAR2,
168: p_enrl_end_dt IN DATE DEFAULT NULL,

Line 165: p_unit_set_cd IN igs_he_en_susa.unit_set_cd%TYPE,

161: -- jbaber 30-aug-04 - added new parameter p_susa_year_of_student for HEFD350
162: PROCEDURE get_year_of_student
163: (p_person_id IN igs_he_en_susa.person_id%TYPE,
164: p_course_cd IN igs_he_en_susa.course_cd%TYPE,
165: p_unit_set_cd IN igs_he_en_susa.unit_set_cd%TYPE,
166: p_sequence_number IN igs_he_en_susa.sequence_number%TYPE,
167: p_year_of_student OUT NOCOPY VARCHAR2,
168: p_enrl_end_dt IN DATE DEFAULT NULL,
169: p_susa_year_of_student IN igs_he_en_susa.year_stu%TYPE);

Line 166: p_sequence_number IN igs_he_en_susa.sequence_number%TYPE,

162: PROCEDURE get_year_of_student
163: (p_person_id IN igs_he_en_susa.person_id%TYPE,
164: p_course_cd IN igs_he_en_susa.course_cd%TYPE,
165: p_unit_set_cd IN igs_he_en_susa.unit_set_cd%TYPE,
166: p_sequence_number IN igs_he_en_susa.sequence_number%TYPE,
167: p_year_of_student OUT NOCOPY VARCHAR2,
168: p_enrl_end_dt IN DATE DEFAULT NULL,
169: p_susa_year_of_student IN igs_he_en_susa.year_stu%TYPE);
170:

Line 169: p_susa_year_of_student IN igs_he_en_susa.year_stu%TYPE);

165: p_unit_set_cd IN igs_he_en_susa.unit_set_cd%TYPE,
166: p_sequence_number IN igs_he_en_susa.sequence_number%TYPE,
167: p_year_of_student OUT NOCOPY VARCHAR2,
168: p_enrl_end_dt IN DATE DEFAULT NULL,
169: p_susa_year_of_student IN igs_he_en_susa.year_stu%TYPE);
170:
171:
172: PROCEDURE get_study_location
173: (p_susa_study_location IN igs_he_en_susa.study_location%TYPE,

Line 173: (p_susa_study_location IN igs_he_en_susa.study_location%TYPE,

169: p_susa_year_of_student IN igs_he_en_susa.year_stu%TYPE);
170:
171:
172: PROCEDURE get_study_location
173: (p_susa_study_location IN igs_he_en_susa.study_location%TYPE,
174: p_poous_study_location IN igs_he_poous.location_of_study%TYPE,
175: p_prg_study_location IN igs_he_st_prog.location_of_study%TYPE,
176: p_oss_study_location OUT NOCOPY VARCHAR2,
177: p_hesa_study_location OUT NOCOPY VARCHAR2);

Line 182: p_susa_term_time_acc IN igs_he_en_susa.term_time_accom%TYPE,

178:
179: -- smaddali 11-dec-03 Modified for bug#3235753 , added 2 new parameters
180: PROCEDURE get_term_time_acc
181: (p_person_id IN igs_pe_person.person_id%TYPE,
182: p_susa_term_time_acc IN igs_he_en_susa.term_time_accom%TYPE,
183: p_study_location IN VARCHAR2,
184: p_hesa_term_time_acc OUT NOCOPY VARCHAR2,
185: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,
186: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);

Line 214: (p_person_id IN igs_he_en_susa.person_id%TYPE,

210: p_awd_conf_start_dt OUT NOCOPY igs_he_submsn_awd.award_start_date%TYPE,
211: p_awd_conf_end_dt OUT NOCOPY igs_he_submsn_awd.award_end_date%TYPE);
212:
213: PROCEDURE get_rsn_inst_left
214: (p_person_id IN igs_he_en_susa.person_id%TYPE,
215: p_course_cd IN igs_he_en_susa.course_cd%TYPE,
216: p_crs_req_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
217: p_crs_req_comp_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,
218: p_disc_reason_cd IN igs_en_stdnt_ps_att.discontinuation_reason_cd%TYPE,

Line 215: p_course_cd IN igs_he_en_susa.course_cd%TYPE,

211: p_awd_conf_end_dt OUT NOCOPY igs_he_submsn_awd.award_end_date%TYPE);
212:
213: PROCEDURE get_rsn_inst_left
214: (p_person_id IN igs_he_en_susa.person_id%TYPE,
215: p_course_cd IN igs_he_en_susa.course_cd%TYPE,
216: p_crs_req_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
217: p_crs_req_comp_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,
218: p_disc_reason_cd IN igs_en_stdnt_ps_att.discontinuation_reason_cd%TYPE,
219: p_disc_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,

Line 229: p_susa_comp_status IN igs_he_en_susa.completion_status%TYPE,

225: --smaddali 6-jun-2002 bug 2396174 added parameter p_course_cd
226: PROCEDURE get_completion_status
227: (p_person_id IN igs_pe_person.person_id%TYPE,
228: p_course_cd IN igs_he_st_spa.course_cd%TYPE ,
229: p_susa_comp_status IN igs_he_en_susa.completion_status%TYPE,
230: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
231: p_crs_req_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE ,
232: p_discont_date IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
233: p_hesa_comp_status OUT NOCOPY VARCHAR2);

Line 236: (p_susa_good_st_mk IN igs_he_en_susa.good_stand_marker%TYPE,

232: p_discont_date IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
233: p_hesa_comp_status OUT NOCOPY VARCHAR2);
234:
235: PROCEDURE get_good_stand_mrkr
236: (p_susa_good_st_mk IN igs_he_en_susa.good_stand_marker%TYPE,
237: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
238: p_crs_req_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE ,
239: p_discont_date IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
240: p_hesa_good_st_mk OUT NOCOPY VARCHAR2);

Line 320: p_susa_fee_elig IN igs_he_en_susa.fee_eligibility%TYPE,

316:
317: -- smaddali 11-dec-03 Modified for bug#3235753 , added 2 new parameters
318: PROCEDURE get_fee_elig
319: (p_person_id IN igs_pe_person.person_id%TYPE,
320: p_susa_fee_elig IN igs_he_en_susa.fee_eligibility%TYPE,
321: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
322: p_study_mode IN VARCHAR2,
323: p_special_student IN VARCHAR2,
324: p_hesa_fee_elig OUT NOCOPY VARCHAR2,

Line 329: (p_hesa_fee_elig IN igs_he_en_susa.fee_eligibility%TYPE,

325: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,
326: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);
327:
328: PROCEDURE get_fee_band
329: (p_hesa_fee_elig IN igs_he_en_susa.fee_eligibility%TYPE,
330: p_susa_fee_band IN igs_he_en_susa.fee_band%TYPE,
331: p_poous_fee_band IN igs_he_poous.fee_band%TYPE,
332: p_prg_fee_band IN igs_he_st_prog.fee_band%TYPE,
333: p_hesa_fee_band OUT NOCOPY VARCHAR2);

Line 330: p_susa_fee_band IN igs_he_en_susa.fee_band%TYPE,

326: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);
327:
328: PROCEDURE get_fee_band
329: (p_hesa_fee_elig IN igs_he_en_susa.fee_eligibility%TYPE,
330: p_susa_fee_band IN igs_he_en_susa.fee_band%TYPE,
331: p_poous_fee_band IN igs_he_poous.fee_band%TYPE,
332: p_prg_fee_band IN igs_he_st_prog.fee_band%TYPE,
333: p_hesa_fee_band OUT NOCOPY VARCHAR2);
334:

Line 354: p_susa_mstufee IN igs_he_en_susa.student_fee%TYPE,

350: p_enrl_end_dt IN DATE,
351: p_special_stdnt IN VARCHAR2,
352: p_study_mode IN VARCHAR2,
353: p_amt_tu_fee IN NUMBER,
354: p_susa_mstufee IN igs_he_en_susa.student_fee%TYPE,
355: p_hesa_mstufee OUT NOCOPY VARCHAR2);
356:
357: PROCEDURE get_religion
358: (p_oss_religion IN igs_pe_stat_v.religion%TYPE,

Line 362: (p_oss_sldd_disc_prv IN igs_he_en_susa.sldd_discrete_prov%TYPE,

358: (p_oss_religion IN igs_pe_stat_v.religion%TYPE,
359: p_hesa_religion OUT NOCOPY VARCHAR2);
360:
361: PROCEDURE get_sldd_disc_prv
362: (p_oss_sldd_disc_prv IN igs_he_en_susa.sldd_discrete_prov%TYPE,
363: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
364: p_hesa_sldd_disc_prv OUT NOCOPY VARCHAR2);
365:
366:

Line 369: (p_oss_non_payment_rsn IN igs_he_en_susa.non_payment_reason%TYPE,

365:
366:
367:
368: PROCEDURE get_non_payment_rsn
369: (p_oss_non_payment_rsn IN igs_he_en_susa.non_payment_reason%TYPE,
370: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
371: p_hesa_non_payment_rsn OUT NOCOPY VARCHAR2);
372:
373:

Line 379: p_susa_inst1 IN igs_he_en_susa.teaching_inst1%TYPE,

375: PROCEDURE get_oth_teach_inst
376: (p_person_id IN igs_pe_person.person_id%TYPE,
377: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
378: p_program_calc IN igs_he_st_prog.program_calc%TYPE,
379: p_susa_inst1 IN igs_he_en_susa.teaching_inst1%TYPE,
380: p_poous_inst1 IN igs_he_poous.other_instit_teach1%TYPE,
381: p_prog_inst1 IN igs_he_st_prog.other_inst_prov_teaching1%TYPE,
382: p_susa_inst2 IN igs_he_en_susa.teaching_inst1%TYPE,
383: p_poous_inst2 IN igs_he_poous.other_instit_teach1%TYPE,

Line 382: p_susa_inst2 IN igs_he_en_susa.teaching_inst1%TYPE,

378: p_program_calc IN igs_he_st_prog.program_calc%TYPE,
379: p_susa_inst1 IN igs_he_en_susa.teaching_inst1%TYPE,
380: p_poous_inst1 IN igs_he_poous.other_instit_teach1%TYPE,
381: p_prog_inst1 IN igs_he_st_prog.other_inst_prov_teaching1%TYPE,
382: p_susa_inst2 IN igs_he_en_susa.teaching_inst1%TYPE,
383: p_poous_inst2 IN igs_he_poous.other_instit_teach1%TYPE,
384: p_prog_inst2 IN igs_he_st_prog.other_inst_prov_teaching1%TYPE,
385: p_hesa_inst1 OUT NOCOPY VARCHAR2,
386: p_hesa_inst2 OUT NOCOPY VARCHAR2,

Line 397: p_susa_prop IN igs_he_en_susa.pro_not_taught%TYPE,

393: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
394: p_enrl_start_dt IN DATE,
395: p_enrl_end_dt IN DATE,
396: p_program_calc IN igs_he_st_prog.program_calc%TYPE,
397: p_susa_prop IN igs_he_en_susa.pro_not_taught%TYPE,
398: p_poous_prop IN igs_he_poous.prop_not_taught%TYPE,
399: p_prog_prop IN igs_he_st_prog.prop_not_taught%TYPE,
400: p_hesa_prop OUT NOCOPY VARCHAR2);
401:

Line 407: (p_susa_credit_level IN igs_he_en_susa.credit_level1%TYPE ,

403: (p_oss_credit_trans_sch IN igs_he_st_prog.credit_transfer_scheme%TYPE,
404: p_hesa_credit_trans_sch OUT NOCOPY VARCHAR2);
405: --smaddali added new parameter p_susa_credit_level for bug 2415879
406: PROCEDURE get_credit_level
407: (p_susa_credit_level IN igs_he_en_susa.credit_level1%TYPE ,
408: p_poous_credit_level IN igs_he_poous.level_credit1%TYPE,
409: p_hesa_credit_level OUT NOCOPY VARCHAR2);
410:
411: -- jbaber added crd_pt3-4, lvl_crd_pt3-4 for HEFD350

Line 416: p_susa_crd_pt1 IN igs_he_en_susa.credit_pt_achieved1%TYPE,

412: PROCEDURE get_credit_obtained
413: (p_person_id IN igs_pe_person.person_id%TYPE,
414: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
415: p_prog_calc IN igs_he_st_prog.program_calc%TYPE,
416: p_susa_crd_pt1 IN igs_he_en_susa.credit_pt_achieved1%TYPE,
417: p_susa_crd_pt2 IN igs_he_en_susa.credit_pt_achieved2%TYPE,
418: p_susa_crd_pt3 IN igs_he_en_susa.credit_pt_achieved3%TYPE,
419: p_susa_crd_pt4 IN igs_he_en_susa.credit_pt_achieved4%TYPE,
420: p_susa_crd_lvl1 IN igs_he_en_susa.credit_level_achieved1%TYPE,

Line 417: p_susa_crd_pt2 IN igs_he_en_susa.credit_pt_achieved2%TYPE,

413: (p_person_id IN igs_pe_person.person_id%TYPE,
414: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
415: p_prog_calc IN igs_he_st_prog.program_calc%TYPE,
416: p_susa_crd_pt1 IN igs_he_en_susa.credit_pt_achieved1%TYPE,
417: p_susa_crd_pt2 IN igs_he_en_susa.credit_pt_achieved2%TYPE,
418: p_susa_crd_pt3 IN igs_he_en_susa.credit_pt_achieved3%TYPE,
419: p_susa_crd_pt4 IN igs_he_en_susa.credit_pt_achieved4%TYPE,
420: p_susa_crd_lvl1 IN igs_he_en_susa.credit_level_achieved1%TYPE,
421: p_susa_crd_lvl2 IN igs_he_en_susa.credit_level_achieved2%TYPE,

Line 418: p_susa_crd_pt3 IN igs_he_en_susa.credit_pt_achieved3%TYPE,

414: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
415: p_prog_calc IN igs_he_st_prog.program_calc%TYPE,
416: p_susa_crd_pt1 IN igs_he_en_susa.credit_pt_achieved1%TYPE,
417: p_susa_crd_pt2 IN igs_he_en_susa.credit_pt_achieved2%TYPE,
418: p_susa_crd_pt3 IN igs_he_en_susa.credit_pt_achieved3%TYPE,
419: p_susa_crd_pt4 IN igs_he_en_susa.credit_pt_achieved4%TYPE,
420: p_susa_crd_lvl1 IN igs_he_en_susa.credit_level_achieved1%TYPE,
421: p_susa_crd_lvl2 IN igs_he_en_susa.credit_level_achieved2%TYPE,
422: p_susa_crd_lvl3 IN igs_he_en_susa.credit_level_achieved3%TYPE,

Line 419: p_susa_crd_pt4 IN igs_he_en_susa.credit_pt_achieved4%TYPE,

415: p_prog_calc IN igs_he_st_prog.program_calc%TYPE,
416: p_susa_crd_pt1 IN igs_he_en_susa.credit_pt_achieved1%TYPE,
417: p_susa_crd_pt2 IN igs_he_en_susa.credit_pt_achieved2%TYPE,
418: p_susa_crd_pt3 IN igs_he_en_susa.credit_pt_achieved3%TYPE,
419: p_susa_crd_pt4 IN igs_he_en_susa.credit_pt_achieved4%TYPE,
420: p_susa_crd_lvl1 IN igs_he_en_susa.credit_level_achieved1%TYPE,
421: p_susa_crd_lvl2 IN igs_he_en_susa.credit_level_achieved2%TYPE,
422: p_susa_crd_lvl3 IN igs_he_en_susa.credit_level_achieved3%TYPE,
423: p_susa_crd_lvl4 IN igs_he_en_susa.credit_level_achieved4%TYPE,

Line 420: p_susa_crd_lvl1 IN igs_he_en_susa.credit_level_achieved1%TYPE,

416: p_susa_crd_pt1 IN igs_he_en_susa.credit_pt_achieved1%TYPE,
417: p_susa_crd_pt2 IN igs_he_en_susa.credit_pt_achieved2%TYPE,
418: p_susa_crd_pt3 IN igs_he_en_susa.credit_pt_achieved3%TYPE,
419: p_susa_crd_pt4 IN igs_he_en_susa.credit_pt_achieved4%TYPE,
420: p_susa_crd_lvl1 IN igs_he_en_susa.credit_level_achieved1%TYPE,
421: p_susa_crd_lvl2 IN igs_he_en_susa.credit_level_achieved2%TYPE,
422: p_susa_crd_lvl3 IN igs_he_en_susa.credit_level_achieved3%TYPE,
423: p_susa_crd_lvl4 IN igs_he_en_susa.credit_level_achieved4%TYPE,
424: p_no_crd_pt1 OUT NOCOPY VARCHAR2,

Line 421: p_susa_crd_lvl2 IN igs_he_en_susa.credit_level_achieved2%TYPE,

417: p_susa_crd_pt2 IN igs_he_en_susa.credit_pt_achieved2%TYPE,
418: p_susa_crd_pt3 IN igs_he_en_susa.credit_pt_achieved3%TYPE,
419: p_susa_crd_pt4 IN igs_he_en_susa.credit_pt_achieved4%TYPE,
420: p_susa_crd_lvl1 IN igs_he_en_susa.credit_level_achieved1%TYPE,
421: p_susa_crd_lvl2 IN igs_he_en_susa.credit_level_achieved2%TYPE,
422: p_susa_crd_lvl3 IN igs_he_en_susa.credit_level_achieved3%TYPE,
423: p_susa_crd_lvl4 IN igs_he_en_susa.credit_level_achieved4%TYPE,
424: p_no_crd_pt1 OUT NOCOPY VARCHAR2,
425: p_no_crd_pt2 OUT NOCOPY VARCHAR2,

Line 422: p_susa_crd_lvl3 IN igs_he_en_susa.credit_level_achieved3%TYPE,

418: p_susa_crd_pt3 IN igs_he_en_susa.credit_pt_achieved3%TYPE,
419: p_susa_crd_pt4 IN igs_he_en_susa.credit_pt_achieved4%TYPE,
420: p_susa_crd_lvl1 IN igs_he_en_susa.credit_level_achieved1%TYPE,
421: p_susa_crd_lvl2 IN igs_he_en_susa.credit_level_achieved2%TYPE,
422: p_susa_crd_lvl3 IN igs_he_en_susa.credit_level_achieved3%TYPE,
423: p_susa_crd_lvl4 IN igs_he_en_susa.credit_level_achieved4%TYPE,
424: p_no_crd_pt1 OUT NOCOPY VARCHAR2,
425: p_no_crd_pt2 OUT NOCOPY VARCHAR2,
426: p_no_crd_pt3 OUT NOCOPY VARCHAR2,

Line 423: p_susa_crd_lvl4 IN igs_he_en_susa.credit_level_achieved4%TYPE,

419: p_susa_crd_pt4 IN igs_he_en_susa.credit_pt_achieved4%TYPE,
420: p_susa_crd_lvl1 IN igs_he_en_susa.credit_level_achieved1%TYPE,
421: p_susa_crd_lvl2 IN igs_he_en_susa.credit_level_achieved2%TYPE,
422: p_susa_crd_lvl3 IN igs_he_en_susa.credit_level_achieved3%TYPE,
423: p_susa_crd_lvl4 IN igs_he_en_susa.credit_level_achieved4%TYPE,
424: p_no_crd_pt1 OUT NOCOPY VARCHAR2,
425: p_no_crd_pt2 OUT NOCOPY VARCHAR2,
426: p_no_crd_pt3 OUT NOCOPY VARCHAR2,
427: p_no_crd_pt4 OUT NOCOPY VARCHAR2,

Line 476: p_susa_comp_pyr_study IN igs_he_en_susa.complete_pyr_study_cd%TYPE,

472: p_prg_lvl_appl_fund IN igs_he_st_prog.level_applicable_to_funding%TYPE,
473: p_hesa_lvl_appl_fund OUT NOCOPY VARCHAR2);
474:
475: PROCEDURE get_comp_pyr_study(
476: p_susa_comp_pyr_study IN igs_he_en_susa.complete_pyr_study_cd%TYPE,
477: p_fundlev IN VARCHAR2,
478: p_spcstu IN VARCHAR2,
479: p_notact IN VARCHAR2,
480: p_mode IN VARCHAR2,

Line 506: (p_susa_franch_activity IN igs_he_en_susa.franchising_activity%TYPE,

502: (p_oss_ufi_place IN igs_he_st_spa.ufi_place%TYPE,
503: p_hesa_ufi_place OUT NOCOPY VARCHAR2);
504:
505: PROCEDURE get_franchising_activity
506: (p_susa_franch_activity IN igs_he_en_susa.franchising_activity%TYPE,
507: p_poous_franch_activity IN igs_he_poous.franchising_activity%TYPE,
508: p_prog_franch_activity IN igs_he_st_prog.franchising_activity%TYPE,
509: p_hesa_franch_activity OUT NOCOPY VARCHAR2);
510:

Line 568: p_susa_study_mode IN igs_he_en_susa.study_mode%TYPE,

564: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
565: p_version_number IN igs_he_st_spa.version_number%TYPE,
566: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
567: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
568: p_susa_study_mode IN igs_he_en_susa.study_mode%TYPE,
569: p_poous_study_mode IN igs_he_poous.attendance_mode%TYPE,
570: p_attendance_type IN igs_en_stdnt_ps_att.attendance_type%TYPE,
571: p_mode_of_study OUT NOCOPY VARCHAR2);
572:

Line 662: (p_susa_enh_fund_elig IN igs_he_en_susa.enh_fund_elig_cd%TYPE ,

658: (p_oss_dependants IN igs_he_st_spa.dependants_cd%TYPE,
659: p_hesa_dependants OUT NOCOPY VARCHAR2);
660:
661: PROCEDURE get_enh_fund_elig
662: (p_susa_enh_fund_elig IN igs_he_en_susa.enh_fund_elig_cd%TYPE ,
663: p_spa_enh_fund_elig IN igs_he_st_spa.enh_fund_elig_cd%TYPE,
664: p_hesa_enh_fund_elig OUT NOCOPY VARCHAR2);
665:
666: PROCEDURE get_learn_dif