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.

[Home] [Help]

APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_HE_SUBMSN_HEADER

Line 109: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,

105: PROCEDURE get_alt_pers_id
106: (p_person_id IN igs_pe_person.person_id%TYPE,
107: p_id_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
108: p_api_id OUT NOCOPY VARCHAR2,
109: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
110: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE
111: ) IS
112: /***************************************************************
113: Created By :

Line 110: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE

106: (p_person_id IN igs_pe_person.person_id%TYPE,
107: p_id_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
108: p_api_id OUT NOCOPY VARCHAR2,
109: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
110: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE
111: ) IS
112: /***************************************************************
113: Created By :
114: Date Created By :

Line 153: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,

149: PROCEDURE get_stdnt_id
150: (p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
151: p_inst_id IN igs_or_institution.govt_institution_cd%TYPE,
152: p_stdnt_id OUT NOCOPY VARCHAR2,
153: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
154: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE)
155:
156: IS
157: /***************************************************************

Line 154: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE)

150: (p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
151: p_inst_id IN igs_or_institution.govt_institution_cd%TYPE,
152: p_stdnt_id OUT NOCOPY VARCHAR2,
153: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
154: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE)
155:
156: IS
157: /***************************************************************
158: Created By :

Line 822: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,

818: p_prg_fund_cd IN igs_he_st_prog.fundability%TYPE,
819: p_prg_funding_source IN igs_fi_fnd_src_rstn.funding_source%TYPE,
820: p_oss_fund_cd OUT NOCOPY VARCHAR2,
821: p_hesa_fund_cd OUT NOCOPY VARCHAR2,
822: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
823: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE)
824:
825: IS
826: /***************************************************************

Line 823: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE)

819: p_prg_funding_source IN igs_fi_fnd_src_rstn.funding_source%TYPE,
820: p_oss_fund_cd OUT NOCOPY VARCHAR2,
821: p_hesa_fund_cd OUT NOCOPY VARCHAR2,
822: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
823: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE)
824:
825: IS
826: /***************************************************************
827: Created By :

Line 979: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,

975:
976: PROCEDURE get_fmly_name_on_16_bday
977: (p_person_id IN igs_pe_person.person_id%TYPE,
978: p_fmly_name OUT NOCOPY VARCHAR2,
979: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
980: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE )
981: IS
982: /***************************************************************
983: Created By :

Line 980: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE )

976: PROCEDURE get_fmly_name_on_16_bday
977: (p_person_id IN igs_pe_person.person_id%TYPE,
978: p_fmly_name OUT NOCOPY VARCHAR2,
979: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
980: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE )
981: IS
982: /***************************************************************
983: Created By :
984: Date Created By :

Line 1105: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE)

1101:
1102: PROCEDURE get_nationality
1103: (p_person_id IN igs_pe_person.person_id%TYPE,
1104: p_nationality OUT NOCOPY VARCHAR2,
1105: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE)
1106:
1107: IS
1108: /***************************************************************
1109: Created By :

Line 1254: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,

1250:
1251: PROCEDURE get_disablity
1252: (p_person_id IN igs_pe_person.person_id%TYPE,
1253: p_disability OUT NOCOPY VARCHAR2,
1254: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
1255: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE)
1256:
1257: IS
1258: /***************************************************************

Line 1255: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE)

1251: PROCEDURE get_disablity
1252: (p_person_id IN igs_pe_person.person_id%TYPE,
1253: p_disability OUT NOCOPY VARCHAR2,
1254: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
1255: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE)
1256:
1257: IS
1258: /***************************************************************
1259: Created By :

Line 1747: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,

1743: (p_person_id IN igs_pe_person.person_id%TYPE,
1744: p_susa_term_time_acc IN igs_he_en_susa.term_time_accom%TYPE,
1745: p_study_location IN VARCHAR2,
1746: p_hesa_term_time_acc OUT NOCOPY VARCHAR2,
1747: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
1748: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE)
1749:
1750: IS
1751: /***************************************************************

Line 1748: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE)

1744: p_susa_term_time_acc IN igs_he_en_susa.term_time_accom%TYPE,
1745: p_study_location IN VARCHAR2,
1746: p_hesa_term_time_acc OUT NOCOPY VARCHAR2,
1747: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
1748: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE)
1749:
1750: IS
1751: /***************************************************************
1752: Created By :

Line 1880: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,

1876: p_search_prog IN BOOLEAN,
1877: p_search_prog_type IN BOOLEAN,
1878: p_course_cd IN igs_ps_ver_all.course_cd%TYPE,
1879: p_course_type IN igs_ps_ver_all.course_type%TYPE,
1880: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
1881: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
1882: p_awd_conf_start_dt OUT NOCOPY igs_he_submsn_awd.award_start_date%TYPE,
1883: p_awd_conf_end_dt OUT NOCOPY igs_he_submsn_awd.award_end_date%TYPE)
1884: IS

Line 1881: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,

1877: p_search_prog_type IN BOOLEAN,
1878: p_course_cd IN igs_ps_ver_all.course_cd%TYPE,
1879: p_course_type IN igs_ps_ver_all.course_type%TYPE,
1880: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
1881: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
1882: p_awd_conf_start_dt OUT NOCOPY igs_he_submsn_awd.award_start_date%TYPE,
1883: p_awd_conf_end_dt OUT NOCOPY igs_he_submsn_awd.award_end_date%TYPE)
1884: IS
1885: BEGIN

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

1942: App_Exception.Raise_Exception;
1943: END get_awd_conferral_dates;
1944:
1945: PROCEDURE get_min_max_awd_dates
1946: (p_submission_name IN igs_he_submsn_header.submission_name%TYPE,
1947: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
1948: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
1949: p_min_start_dt OUT NOCOPY igs_he_submsn_awd.award_start_date%TYPE,
1950: p_max_start_dt OUT NOCOPY igs_he_submsn_awd.award_end_date%TYPE)

Line 1947: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,

1943: END get_awd_conferral_dates;
1944:
1945: PROCEDURE get_min_max_awd_dates
1946: (p_submission_name IN igs_he_submsn_header.submission_name%TYPE,
1947: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
1948: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
1949: p_min_start_dt OUT NOCOPY igs_he_submsn_awd.award_start_date%TYPE,
1950: p_max_start_dt OUT NOCOPY igs_he_submsn_awd.award_end_date%TYPE)
1951: IS

Line 1948: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,

1944:
1945: PROCEDURE get_min_max_awd_dates
1946: (p_submission_name IN igs_he_submsn_header.submission_name%TYPE,
1947: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
1948: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
1949: p_min_start_dt OUT NOCOPY igs_he_submsn_awd.award_start_date%TYPE,
1950: p_max_start_dt OUT NOCOPY igs_he_submsn_awd.award_end_date%TYPE)
1951: IS
1952: /***************************************************************

Line 2107: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,

2103: p_crs_req_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
2104: p_crs_req_comp_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,
2105: p_disc_reason_cd IN igs_en_stdnt_ps_att.discontinuation_reason_cd%TYPE,
2106: p_disc_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
2107: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
2108: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
2109: p_rsn_inst_left OUT NOCOPY VARCHAR2)
2110: IS
2111: /***************************************************************

Line 2108: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,

2104: p_crs_req_comp_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,
2105: p_disc_reason_cd IN igs_en_stdnt_ps_att.discontinuation_reason_cd%TYPE,
2106: p_disc_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
2107: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
2108: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
2109: p_rsn_inst_left OUT NOCOPY VARCHAR2)
2110: IS
2111: /***************************************************************
2112: Created By :

Line 2350: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,

2346:
2347: PROCEDURE get_qual_obtained
2348: (p_person_id IN igs_pe_person.person_id%TYPE,
2349: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
2350: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
2351: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
2352: p_oss_qual_obt1 OUT NOCOPY VARCHAR2,
2353: p_oss_qual_obt2 OUT NOCOPY VARCHAR2,
2354: p_hesa_qual_obt1 OUT NOCOPY VARCHAR2,

Line 2351: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,

2347: PROCEDURE get_qual_obtained
2348: (p_person_id IN igs_pe_person.person_id%TYPE,
2349: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
2350: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
2351: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
2352: p_oss_qual_obt1 OUT NOCOPY VARCHAR2,
2353: p_oss_qual_obt2 OUT NOCOPY VARCHAR2,
2354: p_hesa_qual_obt1 OUT NOCOPY VARCHAR2,
2355: p_hesa_qual_obt2 OUT NOCOPY VARCHAR2,

Line 2863: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,

2859: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
2860: p_version_number IN igs_he_st_spa.version_number%TYPE,
2861: p_spa_gen_qaim IN igs_he_st_spa.student_qual_aim%TYPE,
2862: p_hesa_gen_qaim OUT NOCOPY VARCHAR2,
2863: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
2864: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
2865: p_awd_conf_start_dt IN igs_he_submsn_awd.award_start_date%TYPE)
2866:
2867: IS

Line 2864: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,

2860: p_version_number IN igs_he_st_spa.version_number%TYPE,
2861: p_spa_gen_qaim IN igs_he_st_spa.student_qual_aim%TYPE,
2862: p_hesa_gen_qaim OUT NOCOPY VARCHAR2,
2863: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
2864: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
2865: p_awd_conf_start_dt IN igs_he_submsn_awd.award_start_date%TYPE)
2866:
2867: IS
2868: /***************************************************************

Line 3323: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,

3319: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
3320: p_study_mode IN VARCHAR2,
3321: p_special_student IN VARCHAR2,
3322: p_hesa_fee_elig OUT NOCOPY VARCHAR2,
3323: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
3324: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE)
3325:
3326: IS
3327: /***************************************************************

Line 3324: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE)

3320: p_study_mode IN VARCHAR2,
3321: p_special_student IN VARCHAR2,
3322: p_hesa_fee_elig OUT NOCOPY VARCHAR2,
3323: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
3324: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE)
3325:
3326: IS
3327: /***************************************************************
3328: Created By :

Line 4523: p_validation_country IN igs_he_submsn_header.validation_country%TYPE) IS

4519: p_total_recs OUT NOCOPY NUMBER,
4520: p_enrl_start_dt IN DATE,
4521: p_enrl_end_dt IN DATE,
4522: p_sequence_number IN NUMBER,
4523: p_validation_country IN igs_he_submsn_header.validation_country%TYPE) IS
4524: /***************************************************************
4525: Created By :
4526: Date Created By :
4527: Purpose : This procedure gets the Cost Centres, Subjects for each and their proportions.

Line 5260: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,

5256: p_crse_rqr_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
5257: p_crse_req_complete_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,
5258: p_disc_reason_cd IN igs_en_stdnt_ps_att.discontinuation_reason_cd%TYPE,
5259: p_discont_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
5260: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
5261: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
5262: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
5263: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
5264: p_hesa_comp_pyr_study OUT NOCOPY VARCHAR2) IS

Line 5261: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,

5257: p_crse_req_complete_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,
5258: p_disc_reason_cd IN igs_en_stdnt_ps_att.discontinuation_reason_cd%TYPE,
5259: p_discont_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
5260: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
5261: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
5262: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
5263: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
5264: p_hesa_comp_pyr_study OUT NOCOPY VARCHAR2) IS
5265: /***************************************************************

Line 5290: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,

5286:
5287: -- Cursor to fetch the STudent Progression Outcome Type
5288: CURSOR cur_prog_out_type (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
5289: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
5290: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
5291: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS
5292: SELECT progression_outcome_type,ca.start_dt , spo.decision_dt, spo.applied_dt
5293: FROM IGS_PR_STDNT_PR_OU spo,
5294: IGS_CA_INST ca

Line 5291: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS

5287: -- Cursor to fetch the STudent Progression Outcome Type
5288: CURSOR cur_prog_out_type (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
5289: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
5290: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
5291: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS
5292: SELECT progression_outcome_type,ca.start_dt , spo.decision_dt, spo.applied_dt
5293: FROM IGS_PR_STDNT_PR_OU spo,
5294: IGS_CA_INST ca
5295: WHERE spo.person_id = cp_person_id AND

Line 5759: p_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,

5755: PROCEDURE get_inst_last_attended
5756: (p_person_id IN igs_pe_person.person_id%TYPE,
5757: p_com_date IN DATE,
5758: p_inst_last_att OUT NOCOPY VARCHAR2,
5759: p_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
5760: p_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE
5761: )
5762:
5763: IS

Line 5760: p_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE

5756: (p_person_id IN igs_pe_person.person_id%TYPE,
5757: p_com_date IN DATE,
5758: p_inst_last_att OUT NOCOPY VARCHAR2,
5759: p_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
5760: p_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE
5761: )
5762:
5763: IS
5764: /***************************************************************

Line 6320: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,

6316: PROCEDURE get_mode_of_study
6317: (p_person_id IN igs_pe_person.person_id%TYPE,
6318: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
6319: p_version_number IN igs_he_st_spa.version_number%TYPE,
6320: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
6321: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
6322: p_susa_study_mode IN igs_he_en_susa.study_mode%TYPE,
6323: p_poous_study_mode IN igs_he_poous.attendance_mode%TYPE,
6324: p_attendance_type IN igs_en_stdnt_ps_att.attendance_type%TYPE,

Line 6321: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,

6317: (p_person_id IN igs_pe_person.person_id%TYPE,
6318: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
6319: p_version_number IN igs_he_st_spa.version_number%TYPE,
6320: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
6321: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
6322: p_susa_study_mode IN igs_he_en_susa.study_mode%TYPE,
6323: p_poous_study_mode IN igs_he_poous.attendance_mode%TYPE,
6324: p_attendance_type IN igs_en_stdnt_ps_att.attendance_type%TYPE,
6325: p_mode_of_study OUT NOCOPY VARCHAR2)

Line 6412: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,

6408: FUNCTION isDormant
6409: (p_person_id IN igs_pe_person.person_id%TYPE,
6410: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
6411: p_version_number IN igs_he_st_spa.version_number%TYPE,
6412: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
6413: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE)
6414: RETURN BOOLEAN IS
6415: /***************************************************************
6416: Created By : Jonathan Baber

Line 6413: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE)

6409: (p_person_id IN igs_pe_person.person_id%TYPE,
6410: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
6411: p_version_number IN igs_he_st_spa.version_number%TYPE,
6412: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
6413: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE)
6414: RETURN BOOLEAN IS
6415: /***************************************************************
6416: Created By : Jonathan Baber
6417: Date Created By : 29th November 2004

Line 6822: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,

6818: END get_commencement_dt;
6819:
6820: PROCEDURE get_ucasnum(p_person_id IN igs_pe_person.person_id%TYPE,
6821: p_ucasnum OUT NOCOPY igs_pe_alt_pers_id.api_person_id%TYPE,
6822: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
6823: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE)
6824:
6825: IS
6826: /***************************************************************

Line 6823: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE)

6819:
6820: PROCEDURE get_ucasnum(p_person_id IN igs_pe_person.person_id%TYPE,
6821: p_ucasnum OUT NOCOPY igs_pe_alt_pers_id.api_person_id%TYPE,
6822: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
6823: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE)
6824:
6825: IS
6826: /***************************************************************
6827: Created By : bayadav

Line 7412: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,

7408:
7409:
7410: PROCEDURE get_learn_dif
7411: (p_person_id IN igs_pe_person.person_id%TYPE,
7412: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
7413: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
7414: p_hesa_disability_type OUT NOCOPY VARCHAR2)
7415: IS
7416: /***************************************************************

Line 7413: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,

7409:
7410: PROCEDURE get_learn_dif
7411: (p_person_id IN igs_pe_person.person_id%TYPE,
7412: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
7413: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
7414: p_hesa_disability_type OUT NOCOPY VARCHAR2)
7415: IS
7416: /***************************************************************
7417: Created By : Jonathan Baber

Line 7514: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,

7510:
7511: PROCEDURE get_units_completed
7512: (p_person_id IN igs_pe_person.person_id%TYPE,
7513: p_course_cd IN igs_ps_ver.course_cd%TYPE,
7514: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
7515: p_spa_units_completed IN igs_he_st_spa.units_completed%TYPE,
7516: p_hesa_units_completed OUT NOCOPY VARCHAR2)
7517: IS
7518: /***************************************************************