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 815: p_susa_fund_cd IN igs_he_en_susa.fundability_code%TYPE,

811:
812:
813: PROCEDURE get_fundability_cd
814: (p_person_id IN igs_pe_person.person_id%TYPE,
815: p_susa_fund_cd IN igs_he_en_susa.fundability_code%TYPE,
816: p_spa_funding_source IN igs_en_stdnt_ps_att.funding_source%TYPE,
817: p_poous_fund_cd IN igs_he_poous.fundability_cd%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,

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

1208: END get_ethnicity;
1209:
1210:
1211: PROCEDURE get_disablity_allow
1212: (p_oss_dis_allow IN igs_he_en_susa.disability_allow%TYPE,
1213: p_hesa_dis_allow OUT NOCOPY VARCHAR2)
1214:
1215: IS
1216: /***************************************************************

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

1334: END get_disablity;
1335:
1336:
1337: PROCEDURE get_addnl_supp_band
1338: (p_oss_supp_band IN igs_he_en_susa.additional_sup_band%TYPE,
1339: p_hesa_supp_band OUT NOCOPY VARCHAR2)
1340:
1341: IS
1342: /***************************************************************

Line 1437: p_susa_new_ent_to_he IN igs_he_en_susa.new_he_entrant_cd%TYPE,

1433:
1434:
1435: PROCEDURE get_new_ent_to_he
1436: (p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
1437: p_susa_new_ent_to_he IN igs_he_en_susa.new_he_entrant_cd%TYPE,
1438: p_yop IN VARCHAR2,
1439: p_high_qual_on_ent IN igs_he_st_spa.highest_qual_on_entry%TYPE,
1440: p_domicile IN igs_he_st_spa.domicile_cd%TYPE,
1441: p_hesa_new_ent_to_he OUT NOCOPY VARCHAR2)

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

1503: END get_new_ent_to_he;
1504:
1505:
1506: PROCEDURE get_year_of_prog
1507: (p_unit_set_cd IN igs_he_en_susa.unit_set_cd%TYPE,
1508: p_year_of_prog OUT NOCOPY VARCHAR2)
1509:
1510: IS
1511: /***************************************************************

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

1586: END get_special_student;
1587:
1588:
1589: PROCEDURE get_year_of_student
1590: (p_person_id IN igs_he_en_susa.person_id%TYPE,
1591: p_course_cd IN igs_he_en_susa.course_cd%TYPE,
1592: p_unit_set_cd IN igs_he_en_susa.unit_set_cd%TYPE,
1593: p_sequence_number IN igs_he_en_susa.sequence_number%TYPE,
1594: p_year_of_student OUT NOCOPY VARCHAR2,

Line 1591: p_course_cd IN igs_he_en_susa.course_cd%TYPE,

1587:
1588:
1589: PROCEDURE get_year_of_student
1590: (p_person_id IN igs_he_en_susa.person_id%TYPE,
1591: p_course_cd IN igs_he_en_susa.course_cd%TYPE,
1592: p_unit_set_cd IN igs_he_en_susa.unit_set_cd%TYPE,
1593: p_sequence_number IN igs_he_en_susa.sequence_number%TYPE,
1594: p_year_of_student OUT NOCOPY VARCHAR2,
1595: p_enrl_end_dt IN DATE,

Line 1592: p_unit_set_cd IN igs_he_en_susa.unit_set_cd%TYPE,

1588:
1589: PROCEDURE get_year_of_student
1590: (p_person_id IN igs_he_en_susa.person_id%TYPE,
1591: p_course_cd IN igs_he_en_susa.course_cd%TYPE,
1592: p_unit_set_cd IN igs_he_en_susa.unit_set_cd%TYPE,
1593: p_sequence_number IN igs_he_en_susa.sequence_number%TYPE,
1594: p_year_of_student OUT NOCOPY VARCHAR2,
1595: p_enrl_end_dt IN DATE,
1596: p_susa_year_of_student IN igs_he_en_susa.year_stu%TYPE)

Line 1593: p_sequence_number IN igs_he_en_susa.sequence_number%TYPE,

1589: PROCEDURE get_year_of_student
1590: (p_person_id IN igs_he_en_susa.person_id%TYPE,
1591: p_course_cd IN igs_he_en_susa.course_cd%TYPE,
1592: p_unit_set_cd IN igs_he_en_susa.unit_set_cd%TYPE,
1593: p_sequence_number IN igs_he_en_susa.sequence_number%TYPE,
1594: p_year_of_student OUT NOCOPY VARCHAR2,
1595: p_enrl_end_dt IN DATE,
1596: p_susa_year_of_student IN igs_he_en_susa.year_stu%TYPE)
1597: IS

Line 1596: p_susa_year_of_student IN igs_he_en_susa.year_stu%TYPE)

1592: p_unit_set_cd IN igs_he_en_susa.unit_set_cd%TYPE,
1593: p_sequence_number IN igs_he_en_susa.sequence_number%TYPE,
1594: p_year_of_student OUT NOCOPY VARCHAR2,
1595: p_enrl_end_dt IN DATE,
1596: p_susa_year_of_student IN igs_he_en_susa.year_stu%TYPE)
1597: IS
1598: /***************************************************************
1599: Created By :
1600: Date Created By :

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

1691: END get_year_of_student;
1692:
1693:
1694: PROCEDURE get_study_location
1695: (p_susa_study_location IN igs_he_en_susa.study_location%TYPE,
1696: p_poous_study_location IN igs_he_poous.location_of_study%TYPE,
1697: p_prg_study_location IN igs_he_st_prog.location_of_study%TYPE,
1698: p_oss_study_location OUT NOCOPY VARCHAR2,
1699: p_hesa_study_location OUT NOCOPY VARCHAR2)

Line 1744: p_susa_term_time_acc IN igs_he_en_susa.term_time_accom%TYPE,

1740:
1741:
1742: PROCEDURE get_term_time_acc
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)

Line 1789: l_oss_term_time_acc igs_he_en_susa.term_time_accom%TYPE;

1785: ORDER BY c.Start_Date DESC;
1786:
1787:
1788: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
1789: l_oss_term_time_acc igs_he_en_susa.term_time_accom%TYPE;
1790: l_address_usage igs_he_code_map_val.map1%TYPE;
1791:
1792: BEGIN
1793:

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

2097: END get_awd_dtls;
2098:
2099:
2100: PROCEDURE get_rsn_inst_left
2101: (p_person_id IN igs_he_en_susa.person_id%TYPE,
2102: p_course_cd IN igs_he_en_susa.course_cd%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,

Line 2102: p_course_cd IN igs_he_en_susa.course_cd%TYPE,

2098:
2099:
2100: PROCEDURE get_rsn_inst_left
2101: (p_person_id IN igs_he_en_susa.person_id%TYPE,
2102: p_course_cd IN igs_he_en_susa.course_cd%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,

Line 2186: p_susa_comp_status IN igs_he_en_susa.completion_status%TYPE,

2182:
2183: PROCEDURE get_completion_status
2184: (p_person_id IN igs_pe_person.person_id%TYPE,
2185: p_course_cd IN igs_he_st_spa.course_cd%TYPE ,
2186: p_susa_comp_status IN igs_he_en_susa.completion_status%TYPE,
2187: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
2188: p_crs_req_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
2189: p_discont_date IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
2190: p_hesa_comp_status OUT NOCOPY VARCHAR2)

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

2293:
2294:
2295:
2296: PROCEDURE get_good_stand_mrkr
2297: (p_susa_good_st_mk IN igs_he_en_susa.good_stand_marker%TYPE,
2298: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
2299: p_crs_req_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
2300: p_discont_date IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
2301: p_hesa_good_st_mk OUT NOCOPY VARCHAR2)

Line 3318: p_susa_fee_elig IN igs_he_en_susa.fee_eligibility%TYPE,

3314:
3315:
3316: PROCEDURE get_fee_elig
3317: (p_person_id IN igs_pe_person.person_id%TYPE,
3318: p_susa_fee_elig IN igs_he_en_susa.fee_eligibility%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,

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

3468:
3469:
3470:
3471: PROCEDURE get_fee_band
3472: (p_hesa_fee_elig IN igs_he_en_susa.fee_eligibility%TYPE,
3473: p_susa_fee_band IN igs_he_en_susa.fee_band%TYPE,
3474: p_poous_fee_band IN igs_he_poous.fee_band%TYPE,
3475: p_prg_fee_band IN igs_he_st_prog.fee_band%TYPE,
3476: p_hesa_fee_band OUT NOCOPY VARCHAR2)

Line 3473: p_susa_fee_band IN igs_he_en_susa.fee_band%TYPE,

3469:
3470:
3471: PROCEDURE get_fee_band
3472: (p_hesa_fee_elig IN igs_he_en_susa.fee_eligibility%TYPE,
3473: p_susa_fee_band IN igs_he_en_susa.fee_band%TYPE,
3474: p_poous_fee_band IN igs_he_poous.fee_band%TYPE,
3475: p_prg_fee_band IN igs_he_st_prog.fee_band%TYPE,
3476: p_hesa_fee_band OUT NOCOPY VARCHAR2)
3477: IS

Line 3624: p_susa_mstufee IN igs_he_en_susa.student_fee%TYPE,

3620: p_enrl_end_dt IN DATE,
3621: p_special_stdnt IN VARCHAR2,
3622: p_study_mode IN VARCHAR2,
3623: p_amt_tu_fee IN NUMBER,
3624: p_susa_mstufee IN igs_he_en_susa.student_fee%TYPE,
3625: p_hesa_mstufee OUT NOCOPY VARCHAR2)
3626: IS
3627: /***************************************************************
3628: Created By :

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

3945:
3946:
3947:
3948: PROCEDURE get_sldd_disc_prv
3949: (p_oss_sldd_disc_prv IN igs_he_en_susa.sldd_discrete_prov%TYPE,
3950: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
3951: p_hesa_sldd_disc_prv OUT NOCOPY VARCHAR2)
3952: IS
3953: /***************************************************************

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

3987:
3988:
3989:
3990: PROCEDURE get_non_payment_rsn
3991: (p_oss_non_payment_rsn IN igs_he_en_susa.non_payment_reason%TYPE,
3992: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
3993: p_hesa_non_payment_rsn OUT NOCOPY VARCHAR2)
3994: IS
3995: /***************************************************************

Line 4036: p_susa_inst1 IN igs_he_en_susa.teaching_inst1%TYPE,

4032: PROCEDURE get_oth_teach_inst
4033: (p_person_id IN igs_pe_person.person_id%TYPE,
4034: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
4035: p_program_calc IN igs_he_st_prog.program_calc%TYPE,
4036: p_susa_inst1 IN igs_he_en_susa.teaching_inst1%TYPE,
4037: p_poous_inst1 IN igs_he_poous.other_instit_teach1%TYPE,
4038: p_prog_inst1 IN igs_he_st_prog.other_inst_prov_teaching1%TYPE,
4039: p_susa_inst2 IN igs_he_en_susa.teaching_inst1%TYPE,
4040: p_poous_inst2 IN igs_he_poous.other_instit_teach1%TYPE,

Line 4039: p_susa_inst2 IN igs_he_en_susa.teaching_inst1%TYPE,

4035: p_program_calc IN igs_he_st_prog.program_calc%TYPE,
4036: p_susa_inst1 IN igs_he_en_susa.teaching_inst1%TYPE,
4037: p_poous_inst1 IN igs_he_poous.other_instit_teach1%TYPE,
4038: p_prog_inst1 IN igs_he_st_prog.other_inst_prov_teaching1%TYPE,
4039: p_susa_inst2 IN igs_he_en_susa.teaching_inst1%TYPE,
4040: p_poous_inst2 IN igs_he_poous.other_instit_teach1%TYPE,
4041: p_prog_inst2 IN igs_he_st_prog.other_inst_prov_teaching1%TYPE,
4042: p_hesa_inst1 OUT NOCOPY VARCHAR2,
4043: p_hesa_inst2 OUT NOCOPY VARCHAR2,

Line 4153: p_susa_prop IN igs_he_en_susa.pro_not_taught%TYPE,

4149: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
4150: p_enrl_start_dt IN DATE,
4151: p_enrl_end_dt IN DATE,
4152: p_program_calc IN igs_he_st_prog.program_calc%TYPE,
4153: p_susa_prop IN igs_he_en_susa.pro_not_taught%TYPE,
4154: p_poous_prop IN igs_he_poous.prop_not_taught%TYPE,
4155: p_prog_prop IN igs_he_st_prog.prop_not_taught%TYPE,
4156: p_hesa_prop OUT NOCOPY VARCHAR2)
4157:

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

4312:
4313:
4314:
4315: PROCEDURE get_credit_level
4316: (p_susa_credit_level IN igs_he_en_susa.credit_level1%TYPE ,
4317: p_poous_credit_level IN igs_he_poous.level_credit1%TYPE,
4318: p_hesa_credit_level OUT NOCOPY VARCHAR2)
4319: IS
4320: /***************************************************************

Line 4360: p_susa_crd_pt1 IN igs_he_en_susa.credit_pt_achieved1%TYPE,

4356: PROCEDURE get_credit_obtained
4357: (p_person_id IN igs_pe_person.person_id%TYPE,
4358: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
4359: p_prog_calc IN igs_he_st_prog.program_calc%TYPE,
4360: p_susa_crd_pt1 IN igs_he_en_susa.credit_pt_achieved1%TYPE,
4361: p_susa_crd_pt2 IN igs_he_en_susa.credit_pt_achieved2%TYPE,
4362: p_susa_crd_pt3 IN igs_he_en_susa.credit_pt_achieved3%TYPE,
4363: p_susa_crd_pt4 IN igs_he_en_susa.credit_pt_achieved4%TYPE,
4364: p_susa_crd_lvl1 IN igs_he_en_susa.credit_level_achieved1%TYPE,

Line 4361: p_susa_crd_pt2 IN igs_he_en_susa.credit_pt_achieved2%TYPE,

4357: (p_person_id IN igs_pe_person.person_id%TYPE,
4358: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
4359: p_prog_calc IN igs_he_st_prog.program_calc%TYPE,
4360: p_susa_crd_pt1 IN igs_he_en_susa.credit_pt_achieved1%TYPE,
4361: p_susa_crd_pt2 IN igs_he_en_susa.credit_pt_achieved2%TYPE,
4362: p_susa_crd_pt3 IN igs_he_en_susa.credit_pt_achieved3%TYPE,
4363: p_susa_crd_pt4 IN igs_he_en_susa.credit_pt_achieved4%TYPE,
4364: p_susa_crd_lvl1 IN igs_he_en_susa.credit_level_achieved1%TYPE,
4365: p_susa_crd_lvl2 IN igs_he_en_susa.credit_level_achieved2%TYPE,

Line 4362: p_susa_crd_pt3 IN igs_he_en_susa.credit_pt_achieved3%TYPE,

4358: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
4359: p_prog_calc IN igs_he_st_prog.program_calc%TYPE,
4360: p_susa_crd_pt1 IN igs_he_en_susa.credit_pt_achieved1%TYPE,
4361: p_susa_crd_pt2 IN igs_he_en_susa.credit_pt_achieved2%TYPE,
4362: p_susa_crd_pt3 IN igs_he_en_susa.credit_pt_achieved3%TYPE,
4363: p_susa_crd_pt4 IN igs_he_en_susa.credit_pt_achieved4%TYPE,
4364: p_susa_crd_lvl1 IN igs_he_en_susa.credit_level_achieved1%TYPE,
4365: p_susa_crd_lvl2 IN igs_he_en_susa.credit_level_achieved2%TYPE,
4366: p_susa_crd_lvl3 IN igs_he_en_susa.credit_level_achieved3%TYPE,

Line 4363: p_susa_crd_pt4 IN igs_he_en_susa.credit_pt_achieved4%TYPE,

4359: p_prog_calc IN igs_he_st_prog.program_calc%TYPE,
4360: p_susa_crd_pt1 IN igs_he_en_susa.credit_pt_achieved1%TYPE,
4361: p_susa_crd_pt2 IN igs_he_en_susa.credit_pt_achieved2%TYPE,
4362: p_susa_crd_pt3 IN igs_he_en_susa.credit_pt_achieved3%TYPE,
4363: p_susa_crd_pt4 IN igs_he_en_susa.credit_pt_achieved4%TYPE,
4364: p_susa_crd_lvl1 IN igs_he_en_susa.credit_level_achieved1%TYPE,
4365: p_susa_crd_lvl2 IN igs_he_en_susa.credit_level_achieved2%TYPE,
4366: p_susa_crd_lvl3 IN igs_he_en_susa.credit_level_achieved3%TYPE,
4367: p_susa_crd_lvl4 IN igs_he_en_susa.credit_level_achieved4%TYPE,

Line 4364: p_susa_crd_lvl1 IN igs_he_en_susa.credit_level_achieved1%TYPE,

4360: p_susa_crd_pt1 IN igs_he_en_susa.credit_pt_achieved1%TYPE,
4361: p_susa_crd_pt2 IN igs_he_en_susa.credit_pt_achieved2%TYPE,
4362: p_susa_crd_pt3 IN igs_he_en_susa.credit_pt_achieved3%TYPE,
4363: p_susa_crd_pt4 IN igs_he_en_susa.credit_pt_achieved4%TYPE,
4364: p_susa_crd_lvl1 IN igs_he_en_susa.credit_level_achieved1%TYPE,
4365: p_susa_crd_lvl2 IN igs_he_en_susa.credit_level_achieved2%TYPE,
4366: p_susa_crd_lvl3 IN igs_he_en_susa.credit_level_achieved3%TYPE,
4367: p_susa_crd_lvl4 IN igs_he_en_susa.credit_level_achieved4%TYPE,
4368: p_no_crd_pt1 OUT NOCOPY VARCHAR2,

Line 4365: p_susa_crd_lvl2 IN igs_he_en_susa.credit_level_achieved2%TYPE,

4361: p_susa_crd_pt2 IN igs_he_en_susa.credit_pt_achieved2%TYPE,
4362: p_susa_crd_pt3 IN igs_he_en_susa.credit_pt_achieved3%TYPE,
4363: p_susa_crd_pt4 IN igs_he_en_susa.credit_pt_achieved4%TYPE,
4364: p_susa_crd_lvl1 IN igs_he_en_susa.credit_level_achieved1%TYPE,
4365: p_susa_crd_lvl2 IN igs_he_en_susa.credit_level_achieved2%TYPE,
4366: p_susa_crd_lvl3 IN igs_he_en_susa.credit_level_achieved3%TYPE,
4367: p_susa_crd_lvl4 IN igs_he_en_susa.credit_level_achieved4%TYPE,
4368: p_no_crd_pt1 OUT NOCOPY VARCHAR2,
4369: p_no_crd_pt2 OUT NOCOPY VARCHAR2,

Line 4366: p_susa_crd_lvl3 IN igs_he_en_susa.credit_level_achieved3%TYPE,

4362: p_susa_crd_pt3 IN igs_he_en_susa.credit_pt_achieved3%TYPE,
4363: p_susa_crd_pt4 IN igs_he_en_susa.credit_pt_achieved4%TYPE,
4364: p_susa_crd_lvl1 IN igs_he_en_susa.credit_level_achieved1%TYPE,
4365: p_susa_crd_lvl2 IN igs_he_en_susa.credit_level_achieved2%TYPE,
4366: p_susa_crd_lvl3 IN igs_he_en_susa.credit_level_achieved3%TYPE,
4367: p_susa_crd_lvl4 IN igs_he_en_susa.credit_level_achieved4%TYPE,
4368: p_no_crd_pt1 OUT NOCOPY VARCHAR2,
4369: p_no_crd_pt2 OUT NOCOPY VARCHAR2,
4370: p_no_crd_pt3 OUT NOCOPY VARCHAR2,

Line 4367: p_susa_crd_lvl4 IN igs_he_en_susa.credit_level_achieved4%TYPE,

4363: p_susa_crd_pt4 IN igs_he_en_susa.credit_pt_achieved4%TYPE,
4364: p_susa_crd_lvl1 IN igs_he_en_susa.credit_level_achieved1%TYPE,
4365: p_susa_crd_lvl2 IN igs_he_en_susa.credit_level_achieved2%TYPE,
4366: p_susa_crd_lvl3 IN igs_he_en_susa.credit_level_achieved3%TYPE,
4367: p_susa_crd_lvl4 IN igs_he_en_susa.credit_level_achieved4%TYPE,
4368: p_no_crd_pt1 OUT NOCOPY VARCHAR2,
4369: p_no_crd_pt2 OUT NOCOPY VARCHAR2,
4370: p_no_crd_pt3 OUT NOCOPY VARCHAR2,
4371: p_no_crd_pt4 OUT NOCOPY VARCHAR2,

Line 4561: CURSOR susa_cc_dtls_cur(cp_person_id IGS_HE_EN_SUSA_CC.person_id%TYPE,

4557: FROM IGS_PS_FLD_OF_STUDY PFS
4558: WHERE field_of_study = p_subject;
4559:
4560: -- Cost Centers at Student Unit Set Attempt Level
4561: CURSOR susa_cc_dtls_cur(cp_person_id IGS_HE_EN_SUSA_CC.person_id%TYPE,
4562: cp_course_cd IGS_HE_EN_SUSA_CC.course_cd%TYPE,
4563: cp_unit_set_cd IGS_HE_EN_SUSA_CC.unit_set_cd%TYPE,
4564: cp_sequence_number IGS_HE_EN_SUSA_CC.sequence_number%TYPE) IS
4565: SELECT 'X'

Line 4562: cp_course_cd IGS_HE_EN_SUSA_CC.course_cd%TYPE,

4558: WHERE field_of_study = p_subject;
4559:
4560: -- Cost Centers at Student Unit Set Attempt Level
4561: CURSOR susa_cc_dtls_cur(cp_person_id IGS_HE_EN_SUSA_CC.person_id%TYPE,
4562: cp_course_cd IGS_HE_EN_SUSA_CC.course_cd%TYPE,
4563: cp_unit_set_cd IGS_HE_EN_SUSA_CC.unit_set_cd%TYPE,
4564: cp_sequence_number IGS_HE_EN_SUSA_CC.sequence_number%TYPE) IS
4565: SELECT 'X'
4566: FROM IGS_HE_EN_SUSA_CC

Line 4563: cp_unit_set_cd IGS_HE_EN_SUSA_CC.unit_set_cd%TYPE,

4559:
4560: -- Cost Centers at Student Unit Set Attempt Level
4561: CURSOR susa_cc_dtls_cur(cp_person_id IGS_HE_EN_SUSA_CC.person_id%TYPE,
4562: cp_course_cd IGS_HE_EN_SUSA_CC.course_cd%TYPE,
4563: cp_unit_set_cd IGS_HE_EN_SUSA_CC.unit_set_cd%TYPE,
4564: cp_sequence_number IGS_HE_EN_SUSA_CC.sequence_number%TYPE) IS
4565: SELECT 'X'
4566: FROM IGS_HE_EN_SUSA_CC
4567: WHERE person_id = cp_person_id

Line 4564: cp_sequence_number IGS_HE_EN_SUSA_CC.sequence_number%TYPE) IS

4560: -- Cost Centers at Student Unit Set Attempt Level
4561: CURSOR susa_cc_dtls_cur(cp_person_id IGS_HE_EN_SUSA_CC.person_id%TYPE,
4562: cp_course_cd IGS_HE_EN_SUSA_CC.course_cd%TYPE,
4563: cp_unit_set_cd IGS_HE_EN_SUSA_CC.unit_set_cd%TYPE,
4564: cp_sequence_number IGS_HE_EN_SUSA_CC.sequence_number%TYPE) IS
4565: SELECT 'X'
4566: FROM IGS_HE_EN_SUSA_CC
4567: WHERE person_id = cp_person_id
4568: AND course_cd = cp_course_cd

Line 4566: FROM IGS_HE_EN_SUSA_CC

4562: cp_course_cd IGS_HE_EN_SUSA_CC.course_cd%TYPE,
4563: cp_unit_set_cd IGS_HE_EN_SUSA_CC.unit_set_cd%TYPE,
4564: cp_sequence_number IGS_HE_EN_SUSA_CC.sequence_number%TYPE) IS
4565: SELECT 'X'
4566: FROM IGS_HE_EN_SUSA_CC
4567: WHERE person_id = cp_person_id
4568: AND course_cd = cp_course_cd
4569: AND unit_set_cd = cp_unit_set_cd
4570: AND sequence_number = cp_sequence_number;

Line 4727: FROM igs_he_en_susa_cc

4723: CLOSE susa_cc_dtls_cur;
4724:
4725: OPEN c_cc FOR
4726: SELECT cost_centre, subject, proportion
4727: FROM igs_he_en_susa_cc
4728: WHERE person_id = p_person_id
4729: AND course_cd = p_course_cd
4730: AND unit_set_cd = p_unit_set_cd
4731: AND sequence_number = p_sequence_number

Line 5250: p_susa_comp_pyr_study IN igs_he_en_susa.complete_pyr_study_cd%TYPE,

5246: END get_lvl_appl_to_fund;
5247:
5248:
5249: PROCEDURE get_comp_pyr_study(
5250: p_susa_comp_pyr_study IN igs_he_en_susa.complete_pyr_study_cd%TYPE,
5251: p_fundlev IN VARCHAR2,
5252: p_spcstu IN VARCHAR2,
5253: p_notact IN VARCHAR2,
5254: p_mode IN VARCHAR2,

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

5626:
5627:
5628:
5629: PROCEDURE get_franchising_activity
5630: (p_susa_franch_activity IN igs_he_en_susa.franchising_activity%TYPE,
5631: p_poous_franch_activity IN igs_he_poous.franchising_activity%TYPE,
5632: p_prog_franch_activity IN igs_he_st_prog.franchising_activity%TYPE,
5633: p_hesa_franch_activity OUT NOCOPY VARCHAR2)
5634: IS

Line 6322: p_susa_study_mode IN igs_he_en_susa.study_mode%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)
6326:

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

7367: END get_dependants;
7368:
7369:
7370: PROCEDURE get_enh_fund_elig
7371: (p_susa_enh_fund_elig IN igs_he_en_susa.enh_fund_elig_cd%TYPE ,
7372: p_spa_enh_fund_elig IN igs_he_st_spa.enh_fund_elig_cd%TYPE,
7373: p_hesa_enh_fund_elig OUT NOCOPY VARCHAR2)
7374: IS
7375: /***************************************************************