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_SUBMSN_HEADER

Line 52: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,

48: PROCEDURE get_alt_pers_id
49: (p_person_id IN igs_pe_person.person_id%TYPE,
50: p_id_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
51: p_api_id OUT NOCOPY VARCHAR2,
52: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,
53: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);
54:
55: -- smaddali 11-dec-03 Modified for bug#3235753 , added 2 new parameters
56: PROCEDURE get_stdnt_id

Line 53: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);

49: (p_person_id IN igs_pe_person.person_id%TYPE,
50: p_id_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
51: p_api_id OUT NOCOPY VARCHAR2,
52: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,
53: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);
54:
55: -- smaddali 11-dec-03 Modified for bug#3235753 , added 2 new parameters
56: PROCEDURE get_stdnt_id
57: (p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,

Line 60: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,

56: PROCEDURE get_stdnt_id
57: (p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
58: p_inst_id IN igs_or_institution.govt_institution_cd%TYPE,
59: p_stdnt_id OUT NOCOPY VARCHAR2,
60: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,
61: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);
62:
63: PROCEDURE get_fe_stdnt_mrker
64: (p_spa_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,

Line 61: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);

57: (p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
58: p_inst_id IN igs_or_institution.govt_institution_cd%TYPE,
59: p_stdnt_id OUT NOCOPY VARCHAR2,
60: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,
61: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);
62:
63: PROCEDURE get_fe_stdnt_mrker
64: (p_spa_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
65: p_fe_program_marker IN igs_he_st_prog.fe_program_marker%TYPE,

Line 90: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,

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,
88: p_oss_fund_cd OUT NOCOPY VARCHAR2,
89: p_hesa_fund_cd OUT NOCOPY VARCHAR2,
90: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,
91: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);
92:
93: -- smaddali 11-dec-03 Modified for bug#3235753 , added 2 new parameters
94: PROCEDURE get_fmly_name_on_16_bday

Line 91: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);

87: p_prg_funding_source IN igs_fi_fnd_src_rstn.funding_source%TYPE,
88: p_oss_fund_cd OUT NOCOPY VARCHAR2,
89: p_hesa_fund_cd OUT NOCOPY VARCHAR2,
90: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,
91: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);
92:
93: -- smaddali 11-dec-03 Modified for bug#3235753 , added 2 new parameters
94: PROCEDURE get_fmly_name_on_16_bday
95: (p_person_id IN igs_pe_person.person_id%TYPE,

Line 97: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,

93: -- smaddali 11-dec-03 Modified for bug#3235753 , added 2 new parameters
94: PROCEDURE get_fmly_name_on_16_bday
95: (p_person_id IN igs_pe_person.person_id%TYPE,
96: p_fmly_name OUT NOCOPY VARCHAR2,
97: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,
98: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);
99:
100: PROCEDURE get_gender
101: (p_gender IN igs_pe_person.sex%TYPE,

Line 98: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);

94: PROCEDURE get_fmly_name_on_16_bday
95: (p_person_id IN igs_pe_person.person_id%TYPE,
96: p_fmly_name OUT NOCOPY VARCHAR2,
97: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,
98: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);
99:
100: PROCEDURE get_gender
101: (p_gender IN igs_pe_person.sex%TYPE,
102: p_hesa_gender OUT NOCOPY VARCHAR2);

Line 113: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL);

109: -- smaddali 11-dec-03 Modified for bug#3235753 , added 1 new parameter
110: PROCEDURE get_nationality
111: (p_person_id IN igs_pe_person.person_id%TYPE,
112: p_nationality OUT NOCOPY VARCHAR2,
113: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL);
114:
115: PROCEDURE get_ethnicity
116: (p_person_id IN igs_pe_person.person_id%TYPE,
117: p_oss_eth IN igs_pe_stat_v.ethnic_origin_id%TYPE,

Line 128: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,

124: -- smaddali 11-dec-03 Modified for bug#3235753 , added 2 new parameters
125: PROCEDURE get_disablity
126: (p_person_id IN igs_pe_person.person_id%TYPE,
127: p_disability OUT NOCOPY VARCHAR2,
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,

Line 129: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);

125: PROCEDURE get_disablity
126: (p_person_id IN igs_pe_person.person_id%TYPE,
127: p_disability OUT NOCOPY VARCHAR2,
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);

Line 185: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,

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);
187:
188: PROCEDURE get_min_max_awd_dates
189: (p_submission_name IN igs_he_submsn_header.submission_name%TYPE,

Line 186: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);

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);
187:
188: PROCEDURE get_min_max_awd_dates
189: (p_submission_name IN igs_he_submsn_header.submission_name%TYPE,
190: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,

Line 189: (p_submission_name IN igs_he_submsn_header.submission_name%TYPE,

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);
187:
188: PROCEDURE get_min_max_awd_dates
189: (p_submission_name IN igs_he_submsn_header.submission_name%TYPE,
190: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
191: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
192: p_min_start_dt OUT NOCOPY igs_he_submsn_awd.award_start_date%TYPE,
193: p_max_start_dt OUT NOCOPY igs_he_submsn_awd.award_end_date%TYPE);

Line 190: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,

186: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);
187:
188: PROCEDURE get_min_max_awd_dates
189: (p_submission_name IN igs_he_submsn_header.submission_name%TYPE,
190: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
191: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
192: p_min_start_dt OUT NOCOPY igs_he_submsn_awd.award_start_date%TYPE,
193: p_max_start_dt OUT NOCOPY igs_he_submsn_awd.award_end_date%TYPE);
194:

Line 191: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,

187:
188: PROCEDURE get_min_max_awd_dates
189: (p_submission_name IN igs_he_submsn_header.submission_name%TYPE,
190: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
191: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
192: p_min_start_dt OUT NOCOPY igs_he_submsn_awd.award_start_date%TYPE,
193: p_max_start_dt OUT NOCOPY igs_he_submsn_awd.award_end_date%TYPE);
194:
195: PROCEDURE get_awd_dtls

Line 208: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,

204: p_search_prog IN BOOLEAN,
205: p_search_prog_type IN BOOLEAN,
206: p_course_cd IN igs_ps_ver_all.course_cd%TYPE,
207: p_course_type IN igs_ps_ver_all.course_type%TYPE,
208: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
209: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%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:

Line 209: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,

205: p_search_prog_type IN BOOLEAN,
206: p_course_cd IN igs_ps_ver_all.course_cd%TYPE,
207: p_course_type IN igs_ps_ver_all.course_type%TYPE,
208: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
209: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%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

Line 220: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%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,
220: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
221: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
222: p_rsn_inst_left OUT NOCOPY VARCHAR2);
223:
224:

Line 221: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%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,
220: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
221: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
222: p_rsn_inst_left OUT NOCOPY VARCHAR2);
223:
224:
225: --smaddali 6-jun-2002 bug 2396174 added parameter p_course_cd

Line 245: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,

241:
242: PROCEDURE get_qual_obtained
243: (p_person_id IN igs_pe_person.person_id%TYPE,
244: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
245: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
246: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
247: p_oss_qual_obt1 OUT NOCOPY VARCHAR2,
248: p_oss_qual_obt2 OUT NOCOPY VARCHAR2,
249: p_hesa_qual_obt1 OUT NOCOPY VARCHAR2,

Line 246: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,

242: PROCEDURE get_qual_obtained
243: (p_person_id IN igs_pe_person.person_id%TYPE,
244: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
245: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
246: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
247: p_oss_qual_obt1 OUT NOCOPY VARCHAR2,
248: p_oss_qual_obt2 OUT NOCOPY VARCHAR2,
249: p_hesa_qual_obt1 OUT NOCOPY VARCHAR2,
250: p_hesa_qual_obt2 OUT NOCOPY VARCHAR2,

Line 275: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,

271: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
272: p_version_number IN igs_he_st_spa.version_number%TYPE,
273: p_spa_gen_qaim IN igs_he_st_spa.student_qual_aim%TYPE,
274: p_hesa_gen_qaim OUT NOCOPY VARCHAR2,
275: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,
276: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL,
277: p_awd_conf_start_dt IN igs_he_submsn_awd.award_start_date%TYPE DEFAULT NULL);
278:
279: PROCEDURE get_awd_body_12

Line 276: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL,

272: p_version_number IN igs_he_st_spa.version_number%TYPE,
273: p_spa_gen_qaim IN igs_he_st_spa.student_qual_aim%TYPE,
274: p_hesa_gen_qaim OUT NOCOPY VARCHAR2,
275: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,
276: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL,
277: p_awd_conf_start_dt IN igs_he_submsn_awd.award_start_date%TYPE DEFAULT NULL);
278:
279: PROCEDURE get_awd_body_12
280: (p_course_cd IN igs_he_st_spa.course_cd%TYPE,

Line 325: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,

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,
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,

Line 326: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);

322: p_study_mode IN VARCHAR2,
323: p_special_student IN VARCHAR2,
324: p_hesa_fee_elig OUT NOCOPY VARCHAR2,
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,

Line 455: p_validation_country IN igs_he_submsn_header.validation_country%TYPE);

451: p_total_recs OUT NOCOPY NUMBER,
452: p_enrl_start_dt IN DATE,
453: p_enrl_end_dt IN DATE,
454: p_sequence_number IN NUMBER DEFAULT NULL,
455: p_validation_country IN igs_he_submsn_header.validation_country%TYPE);
456:
457: -- jbaber 25-Nov-2004 Included p_version_number for bug # 4037237
458: PROCEDURE get_studies_susp
459: (p_person_id IN igs_pe_person.person_id%TYPE,

Line 486: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,

482: p_crse_rqr_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
483: p_crse_req_complete_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,
484: p_disc_reason_cd IN igs_en_stdnt_ps_att.discontinuation_reason_cd%TYPE,
485: p_discont_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
486: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
487: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
488: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
489: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
490: p_hesa_comp_pyr_study OUT NOCOPY VARCHAR2);

Line 487: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,

483: p_crse_req_complete_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,
484: p_disc_reason_cd IN igs_en_stdnt_ps_att.discontinuation_reason_cd%TYPE,
485: p_discont_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
486: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
487: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
488: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
489: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
490: p_hesa_comp_pyr_study OUT NOCOPY VARCHAR2);
491:

Line 524: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,

520: PROCEDURE get_inst_last_attended
521: (p_person_id IN igs_pe_person.person_id%TYPE,
522: p_com_date IN DATE,
523: p_inst_last_att OUT NOCOPY VARCHAR2,
524: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,
525: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);
526:
527: PROCEDURE get_regulatory_body
528: (p_course_cd IN igs_he_st_spa.course_cd%TYPE,

Line 525: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);

521: (p_person_id IN igs_pe_person.person_id%TYPE,
522: p_com_date IN DATE,
523: p_inst_last_att OUT NOCOPY VARCHAR2,
524: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,
525: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);
526:
527: PROCEDURE get_regulatory_body
528: (p_course_cd IN igs_he_st_spa.course_cd%TYPE,
529: p_version_number IN igs_he_st_spa.version_number%TYPE,

Line 566: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,

562: PROCEDURE get_mode_of_study
563: (p_person_id IN igs_pe_person.person_id%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,

Line 567: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,

563: (p_person_id IN igs_pe_person.person_id%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);

Line 577: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,

573: FUNCTION isDormant
574: (p_person_id IN igs_pe_person.person_id%TYPE,
575: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
576: p_version_number IN igs_he_st_spa.version_number%TYPE,
577: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
578: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE)
579: RETURN BOOLEAN;
580:
581: FUNCTION is_ucas_ftug

Line 578: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE)

574: (p_person_id IN igs_pe_person.person_id%TYPE,
575: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
576: p_version_number IN igs_he_st_spa.version_number%TYPE,
577: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
578: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE)
579: RETURN BOOLEAN;
580:
581: FUNCTION is_ucas_ftug
582: (p_hesa_qual_aim IN igs_he_ex_rn_dat_fd.value%TYPE,

Line 650: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,

646: -- smaddali 11-dec-03 Modified for bug#3235753 , added 2 new parameters
647: PROCEDURE get_ucasnum
648: (p_person_id IN igs_pe_person.person_id%TYPE,
649: p_ucasnum OUT NOCOPY igs_pe_alt_pers_id.api_person_id%TYPE,
650: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,
651: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);
652:
653: PROCEDURE get_marital_status
654: (p_oss_marital_status IN igs_pe_stat_v.marital_status%TYPE,

Line 651: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);

647: PROCEDURE get_ucasnum
648: (p_person_id IN igs_pe_person.person_id%TYPE,
649: p_ucasnum OUT NOCOPY igs_pe_alt_pers_id.api_person_id%TYPE,
650: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,
651: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);
652:
653: PROCEDURE get_marital_status
654: (p_oss_marital_status IN igs_pe_stat_v.marital_status%TYPE,
655: p_hesa_marital_status OUT NOCOPY VARCHAR2);

Line 668: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,

664: p_hesa_enh_fund_elig OUT NOCOPY VARCHAR2);
665:
666: PROCEDURE get_learn_dif
667: (p_person_id IN igs_pe_person.person_id%TYPE,
668: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
669: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
670: p_hesa_disability_type OUT NOCOPY VARCHAR2);
671:
672: PROCEDURE get_gov_init

Line 669: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,

665:
666: PROCEDURE get_learn_dif
667: (p_person_id IN igs_pe_person.person_id%TYPE,
668: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
669: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
670: p_hesa_disability_type OUT NOCOPY VARCHAR2);
671:
672: PROCEDURE get_gov_init
673: (p_spa_gov_initiatives_cd IN igs_he_st_spa.gov_initiatives_cd%TYPE,

Line 680: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,

676:
677: PROCEDURE get_units_completed
678: (p_person_id IN igs_pe_person.person_id%TYPE,
679: p_course_cd IN igs_ps_ver.course_cd%TYPE,
680: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
681: p_spa_units_completed IN igs_he_st_spa.units_completed%TYPE,
682: p_hesa_units_completed OUT NOCOPY VARCHAR2);
683:
684: PROCEDURE get_disadv_uplift_elig