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_ST_SPA

Line 633: (p_spa_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,

629: END get_stdnt_id;
630:
631:
632: PROCEDURE get_fe_stdnt_mrker
633: (p_spa_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
634: p_fe_program_marker IN igs_he_st_prog.fe_program_marker%TYPE,
635: p_funding_src IN igs_he_ex_rn_dat_fd.value%TYPE,
636: p_fundability_cd IN igs_he_ex_rn_dat_fd.value%TYPE,
637: p_oss_fe_stdnt_mrker OUT NOCOPY VARCHAR2,

Line 1064: p_spa_domicile IN igs_he_st_spa.domicile_cd%TYPE,

1060:
1061:
1062: PROCEDURE get_domicile
1063: (p_ad_domicile IN igs_he_ad_dtl.domicile_cd%TYPE,
1064: p_spa_domicile IN igs_he_st_spa.domicile_cd%TYPE,
1065: p_hesa_domicile OUT NOCOPY VARCHAR2)
1066: IS
1067: /***************************************************************
1068: Created By :

Line 1436: (p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,

1432: END get_yr_left_last_inst;
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,

Line 1439: p_high_qual_on_ent IN igs_he_st_spa.highest_qual_on_entry%TYPE,

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)
1442:
1443: IS

Line 1440: p_domicile IN igs_he_st_spa.domicile_cd%TYPE,

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)
1442:
1443: IS
1444: /***************************************************************

Line 1549: p_spa_special_student IN igs_he_st_spa.special_student%TYPE,

1545:
1546:
1547: PROCEDURE get_special_student
1548: (p_ad_special_student IN igs_he_ad_dtl.special_student_cd%TYPE,
1549: p_spa_special_student IN igs_he_st_spa.special_student%TYPE,
1550: p_oss_special_student OUT NOCOPY VARCHAR2,
1551: p_hesa_special_student OUT NOCOPY VARCHAR2)
1552: IS
1553: /***************************************************************

Line 1620: FROM igs_en_stdnt_ps_att_all a , igs_he_st_spa_all b

1616:
1617: -- Get the academic calendar type and student instance number of the current program attempt.
1618: CURSOR c_acad_cal IS
1619: SELECT a.cal_type,b.student_inst_number
1620: FROM igs_en_stdnt_ps_att_all a , igs_he_st_spa_all b
1621: WHERE a.person_id = p_person_id AND
1622: a.course_cd = p_course_cd AND
1623: a.person_id = b.person_id AND
1624: a.course_cd = b.course_cd ;

Line 1635: CURSOR c_yos (p_student_inst_number igs_he_st_spa_all.student_inst_number%TYPE,

1631: -- that when the student is transfering into a program in a different calendar type then he will
1632: -- mandatorily transfer all his unit and unit set attempts , Thus they will be counted in the
1633: -- latest calendar.
1634: -- smaddali 29-oct-03 modified to add condition enrolled_dt <= p_enr_end_dt for bug#3224246
1635: CURSOR c_yos (p_student_inst_number igs_he_st_spa_all.student_inst_number%TYPE,
1636: p_cal_type igs_en_stdnt_ps_att_all.cal_type%TYPE ) IS
1637: SELECT COUNT (DISTINCT cir.sup_ci_sequence_number || cir.sup_cal_type)
1638: FROM igs_he_st_spa_all spa ,
1639: igs_en_stdnt_ps_att sca,

Line 1638: FROM igs_he_st_spa_all spa ,

1634: -- smaddali 29-oct-03 modified to add condition enrolled_dt <= p_enr_end_dt for bug#3224246
1635: CURSOR c_yos (p_student_inst_number igs_he_st_spa_all.student_inst_number%TYPE,
1636: p_cal_type igs_en_stdnt_ps_att_all.cal_type%TYPE ) IS
1637: SELECT COUNT (DISTINCT cir.sup_ci_sequence_number || cir.sup_cal_type)
1638: FROM igs_he_st_spa_all spa ,
1639: igs_en_stdnt_ps_att sca,
1640: igs_en_su_attempt sua,
1641: igs_ca_inst_rel cir,
1642: igs_ca_inst_all ca

Line 2185: p_course_cd IN igs_he_st_spa.course_cd%TYPE ,

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

Line 2187: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,

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)
2191: IS

Line 2210: CURSOR c_sin ( cp_course_cd igs_he_st_spa.course_cd%TYPE ) IS

2206: AND transfer_course_cd = p_course_cd
2207: ORDER BY transfer_dt DESC ;
2208:
2209: -- smaddali added this cursor to get the student instance number of an spa record for bug 2396174
2210: CURSOR c_sin ( cp_course_cd igs_he_st_spa.course_cd%TYPE ) IS
2211: SELECT student_inst_number
2212: FROM igs_he_st_spa
2213: WHERE person_id = p_person_id
2214: AND course_cd = cp_course_cd ;

Line 2212: FROM igs_he_st_spa

2208:
2209: -- smaddali added this cursor to get the student instance number of an spa record for bug 2396174
2210: CURSOR c_sin ( cp_course_cd igs_he_st_spa.course_cd%TYPE ) IS
2211: SELECT student_inst_number
2212: FROM igs_he_st_spa
2213: WHERE person_id = p_person_id
2214: AND course_cd = cp_course_cd ;
2215:
2216: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;

Line 2217: l_to_course_cd igs_he_st_spa.course_cd%TYPE := NULL ;

2213: WHERE person_id = p_person_id
2214: AND course_cd = cp_course_cd ;
2215:
2216: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
2217: l_to_course_cd igs_he_st_spa.course_cd%TYPE := NULL ;
2218: l_from_sin igs_he_st_spa.student_inst_number%TYPE := NULL ;
2219: l_to_sin igs_he_st_spa.student_inst_number%TYPE := NULL ;
2220:
2221: BEGIN

Line 2218: l_from_sin igs_he_st_spa.student_inst_number%TYPE := NULL ;

2214: AND course_cd = cp_course_cd ;
2215:
2216: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
2217: l_to_course_cd igs_he_st_spa.course_cd%TYPE := NULL ;
2218: l_from_sin igs_he_st_spa.student_inst_number%TYPE := NULL ;
2219: l_to_sin igs_he_st_spa.student_inst_number%TYPE := NULL ;
2220:
2221: BEGIN
2222: IF p_fe_stdnt_mrker IN ('1','3','4')

Line 2219: l_to_sin igs_he_st_spa.student_inst_number%TYPE := NULL ;

2215:
2216: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
2217: l_to_course_cd igs_he_st_spa.course_cd%TYPE := NULL ;
2218: l_from_sin igs_he_st_spa.student_inst_number%TYPE := NULL ;
2219: l_to_sin igs_he_st_spa.student_inst_number%TYPE := NULL ;
2220:
2221: BEGIN
2222: IF p_fe_stdnt_mrker IN ('1','3','4')
2223: THEN

Line 2298: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,

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)
2302: IS

Line 2349: p_course_cd IN igs_he_st_spa.course_cd%TYPE,

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

Line 2480: (p_spa_fe_qual_aim IN igs_he_st_spa.student_fe_qual_aim%TYPE,

2476: END get_qual_obtained ;
2477:
2478:
2479: PROCEDURE get_fe_qual_aim
2480: (p_spa_fe_qual_aim IN igs_he_st_spa.student_fe_qual_aim%TYPE,
2481: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
2482: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
2483: p_version_number IN igs_he_st_spa.version_number%TYPE,
2484: p_hesa_fe_qual_aim OUT NOCOPY VARCHAR2)

Line 2481: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,

2477:
2478:
2479: PROCEDURE get_fe_qual_aim
2480: (p_spa_fe_qual_aim IN igs_he_st_spa.student_fe_qual_aim%TYPE,
2481: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
2482: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
2483: p_version_number IN igs_he_st_spa.version_number%TYPE,
2484: p_hesa_fe_qual_aim OUT NOCOPY VARCHAR2)
2485:

Line 2482: p_course_cd IN igs_he_st_spa.course_cd%TYPE,

2478:
2479: PROCEDURE get_fe_qual_aim
2480: (p_spa_fe_qual_aim IN igs_he_st_spa.student_fe_qual_aim%TYPE,
2481: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
2482: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
2483: p_version_number IN igs_he_st_spa.version_number%TYPE,
2484: p_hesa_fe_qual_aim OUT NOCOPY VARCHAR2)
2485:
2486: IS

Line 2483: p_version_number IN igs_he_st_spa.version_number%TYPE,

2479: PROCEDURE get_fe_qual_aim
2480: (p_spa_fe_qual_aim IN igs_he_st_spa.student_fe_qual_aim%TYPE,
2481: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
2482: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
2483: p_version_number IN igs_he_st_spa.version_number%TYPE,
2484: p_hesa_fe_qual_aim OUT NOCOPY VARCHAR2)
2485:
2486: IS
2487: /***************************************************************

Line 2548: (p_qual_aim_subj1 IN igs_he_st_spa.qual_aim_subj1%TYPE,

2544: App_Exception.Raise_Exception;
2545: END get_fe_qual_aim;
2546:
2547: PROCEDURE get_qual_aim_sbj1
2548: (p_qual_aim_subj1 IN igs_he_st_spa.qual_aim_subj1%TYPE,
2549: p_qual_aim_subj2 IN igs_he_st_spa.qual_aim_subj2%TYPE,
2550: p_qual_aim_subj3 IN igs_he_st_spa.qual_aim_subj3%TYPE,
2551: p_oss_qualaim_sbj IN igs_he_code_values.value%TYPE,
2552: p_hesa_qualaim_sbj OUT NOCOPY igs_he_code_values.value%TYPE

Line 2549: p_qual_aim_subj2 IN igs_he_st_spa.qual_aim_subj2%TYPE,

2545: END get_fe_qual_aim;
2546:
2547: PROCEDURE get_qual_aim_sbj1
2548: (p_qual_aim_subj1 IN igs_he_st_spa.qual_aim_subj1%TYPE,
2549: p_qual_aim_subj2 IN igs_he_st_spa.qual_aim_subj2%TYPE,
2550: p_qual_aim_subj3 IN igs_he_st_spa.qual_aim_subj3%TYPE,
2551: p_oss_qualaim_sbj IN igs_he_code_values.value%TYPE,
2552: p_hesa_qualaim_sbj OUT NOCOPY igs_he_code_values.value%TYPE
2553: )

Line 2550: p_qual_aim_subj3 IN igs_he_st_spa.qual_aim_subj3%TYPE,

2546:
2547: PROCEDURE get_qual_aim_sbj1
2548: (p_qual_aim_subj1 IN igs_he_st_spa.qual_aim_subj1%TYPE,
2549: p_qual_aim_subj2 IN igs_he_st_spa.qual_aim_subj2%TYPE,
2550: p_qual_aim_subj3 IN igs_he_st_spa.qual_aim_subj3%TYPE,
2551: p_oss_qualaim_sbj IN igs_he_code_values.value%TYPE,
2552: p_hesa_qualaim_sbj OUT NOCOPY igs_he_code_values.value%TYPE
2553: )
2554: IS

Line 2605: ( p_course_cd IN igs_he_st_spa.course_cd%TYPE,

2601:
2602: END get_qual_aim_sbj1;
2603:
2604: PROCEDURE get_qual_aim_sbj
2605: ( p_course_cd IN igs_he_st_spa.course_cd%TYPE,
2606: p_version_number IN igs_he_st_spa.version_number%TYPE,
2607: p_subject1 OUT NOCOPY VARCHAR2,
2608: p_subject2 OUT NOCOPY VARCHAR2,
2609: p_subject3 OUT NOCOPY VARCHAR2,

Line 2606: p_version_number IN igs_he_st_spa.version_number%TYPE,

2602: END get_qual_aim_sbj1;
2603:
2604: PROCEDURE get_qual_aim_sbj
2605: ( p_course_cd IN igs_he_st_spa.course_cd%TYPE,
2606: p_version_number IN igs_he_st_spa.version_number%TYPE,
2607: p_subject1 OUT NOCOPY VARCHAR2,
2608: p_subject2 OUT NOCOPY VARCHAR2,
2609: p_subject3 OUT NOCOPY VARCHAR2,
2610: p_prop_ind OUT NOCOPY VARCHAR2)

Line 2751: p_course_cd IN igs_he_st_spa.course_cd%TYPE,

2747: END is_ucas_ftug;
2748:
2749: PROCEDURE limit_no_of_qual(p_field_number IN NUMBER,
2750: p_person_number IN igs_pe_person.person_number%TYPE,
2751: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
2752: p_hesa_qual IN VARCHAR2,
2753: p_no_of_qual IN OUT NOCOPY NUMBER)
2754: IS
2755: /***************************************************************

Line 2804: p_course_cd IN igs_he_st_spa.course_cd%TYPE,

2800: END limit_no_of_qual;
2801:
2802: PROCEDURE limit_tariff_score(p_field_number IN NUMBER,
2803: p_person_number IN igs_pe_person.person_number%TYPE,
2804: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
2805: p_hesa_qual IN VARCHAR2,
2806: p_tariff_score IN OUT NOCOPY igs_he_ex_rn_dat_fd.value%TYPE)
2807: IS
2808: /***************************************************************

Line 2859: p_course_cd IN igs_he_st_spa.course_cd%TYPE,

2855: END limit_tariff_score;
2856:
2857: PROCEDURE get_gen_qual_aim
2858: (p_person_id IN igs_pe_person.person_id%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,

Line 2860: p_version_number IN igs_he_st_spa.version_number%TYPE,

2856:
2857: PROCEDURE get_gen_qual_aim
2858: (p_person_id IN igs_pe_person.person_id%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,

Line 2861: p_spa_gen_qaim IN igs_he_st_spa.student_qual_aim%TYPE,

2857: PROCEDURE get_gen_qual_aim
2858: (p_person_id IN igs_pe_person.person_id%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)

Line 2966: (p_course_cd IN igs_he_st_spa.course_cd%TYPE,

2962:
2963:
2964:
2965: PROCEDURE get_awd_body_12
2966: (p_course_cd IN igs_he_st_spa.course_cd%TYPE,
2967: p_version_number IN igs_he_st_spa.version_number%TYPE,
2968: p_awd1 IN VARCHAR2,
2969: p_awd2 IN VARCHAR2,
2970: p_awd_body1 OUT NOCOPY VARCHAR2,

Line 2967: p_version_number IN igs_he_st_spa.version_number%TYPE,

2963:
2964:
2965: PROCEDURE get_awd_body_12
2966: (p_course_cd IN igs_he_st_spa.course_cd%TYPE,
2967: p_version_number IN igs_he_st_spa.version_number%TYPE,
2968: p_awd1 IN VARCHAR2,
2969: p_awd2 IN VARCHAR2,
2970: p_awd_body1 OUT NOCOPY VARCHAR2,
2971: p_awd_body2 OUT NOCOPY VARCHAR2)

Line 3118: p_spa_ttcid IN igs_he_st_spa.teacher_train_prog_id%TYPE,

3114: END get_prog_length;
3115:
3116: PROCEDURE get_teach_train_crs_id
3117: (p_prg_ttcid IN igs_he_st_prog.teacher_train_prog_id%TYPE,
3118: p_spa_ttcid IN igs_he_st_spa.teacher_train_prog_id%TYPE,
3119: p_hesa_ttcid OUT NOCOPY VARCHAR2)
3120: IS
3121: /***************************************************************
3122: Created By :

Line 3158: p_spa_itt_phsc IN igs_he_st_spa.itt_phase%TYPE,

3154:
3155:
3156: PROCEDURE get_itt_phsc
3157: (p_prg_itt_phsc IN igs_he_st_prog.itt_phase%TYPE,
3158: p_spa_itt_phsc IN igs_he_st_spa.itt_phase%TYPE,
3159: p_hesa_itt_phsc OUT NOCOPY VARCHAR2)
3160: IS
3161: /***************************************************************
3162: Created By :

Line 3198: p_spa_itt_mrker IN igs_he_st_spa.bilingual_itt_marker%TYPE,

3194:
3195:
3196: PROCEDURE get_itt_mrker
3197: (p_prg_itt_mrker IN igs_he_st_prog.bilingual_itt_marker%TYPE,
3198: p_spa_itt_mrker IN igs_he_st_spa.bilingual_itt_marker%TYPE,
3199: p_hesa_itt_mrker OUT NOCOPY VARCHAR2)
3200: IS
3201: /***************************************************************
3202: Created By :

Line 3319: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,

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,
3323: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,

Line 3527: p_course_cd IN igs_he_st_spa.course_cd%TYPE,

3523:
3524:
3525: PROCEDURE get_amt_tuition_fees
3526: (p_person_id IN igs_pe_person.person_id%TYPE,
3527: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
3528: p_cal_type IN igs_en_stdnt_ps_att.cal_type%TYPE,
3529: p_fe_prg_mrker IN igs_he_st_prog.fe_program_marker%TYPE,
3530: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
3531: p_oss_amt OUT NOCOPY NUMBER,

Line 3530: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,

3526: (p_person_id IN igs_pe_person.person_id%TYPE,
3527: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
3528: p_cal_type IN igs_en_stdnt_ps_att.cal_type%TYPE,
3529: p_fe_prg_mrker IN igs_he_st_prog.fe_program_marker%TYPE,
3530: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
3531: p_oss_amt OUT NOCOPY NUMBER,
3532: p_hesa_amt OUT NOCOPY VARCHAR2,
3533: p_enrl_start_dt IN DATE,
3534: p_enrl_end_dt IN DATE)

Line 3950: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,

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: /***************************************************************
3954: Created By :

Line 3992: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,

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: /***************************************************************
3996: Created By :

Line 4034: p_course_cd IN igs_he_st_spa.course_cd%TYPE,

4030:
4031:
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,

Line 4149: p_course_cd IN igs_he_st_spa.course_cd%TYPE,

4145:
4146:
4147: PROCEDURE get_prop_not_taught
4148: (p_person_id IN igs_pe_person.person_id%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,

Line 4358: p_course_cd IN igs_he_st_spa.course_cd%TYPE,

4354:
4355:
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,

Line 4573: CURSOR spa_cc_dtls_cur(cp_person_id IGS_HE_ST_SPA_CC.person_id%TYPE,

4569: AND unit_set_cd = cp_unit_set_cd
4570: AND sequence_number = cp_sequence_number;
4571:
4572: -- Cost Centers at Student Program Attempt Level
4573: CURSOR spa_cc_dtls_cur(cp_person_id IGS_HE_ST_SPA_CC.person_id%TYPE,
4574: cp_course_cd IGS_HE_ST_SPA_CC.course_cd%TYPE) IS
4575: SELECT 'X'
4576: FROM IGS_HE_ST_SPA_CC
4577: WHERE person_id = cp_person_id

Line 4574: cp_course_cd IGS_HE_ST_SPA_CC.course_cd%TYPE) IS

4570: AND sequence_number = cp_sequence_number;
4571:
4572: -- Cost Centers at Student Program Attempt Level
4573: CURSOR spa_cc_dtls_cur(cp_person_id IGS_HE_ST_SPA_CC.person_id%TYPE,
4574: cp_course_cd IGS_HE_ST_SPA_CC.course_cd%TYPE) IS
4575: SELECT 'X'
4576: FROM IGS_HE_ST_SPA_CC
4577: WHERE person_id = cp_person_id
4578: AND course_cd = cp_course_cd;

Line 4576: FROM IGS_HE_ST_SPA_CC

4572: -- Cost Centers at Student Program Attempt Level
4573: CURSOR spa_cc_dtls_cur(cp_person_id IGS_HE_ST_SPA_CC.person_id%TYPE,
4574: cp_course_cd IGS_HE_ST_SPA_CC.course_cd%TYPE) IS
4575: SELECT 'X'
4576: FROM IGS_HE_ST_SPA_CC
4577: WHERE person_id = cp_person_id
4578: AND course_cd = cp_course_cd;
4579:
4580: -- Cost Centers at Program Offering Option Level

Line 4746: FROM igs_he_st_spa_cc

4742: CLOSE spa_cc_dtls_cur;
4743:
4744: OPEN c_cc FOR
4745: SELECT cost_centre, subject, proportion
4746: FROM igs_he_st_spa_cc
4747: WHERE person_id = p_person_id
4748: AND course_cd = p_course_cd
4749: ORDER BY proportion DESC;
4750:

Line 5048: p_course_cd IN igs_he_st_spa.course_cd%TYPE,

5044: END get_cost_centres;
5045:
5046: PROCEDURE get_studies_susp
5047: (p_person_id IN igs_pe_person.person_id%TYPE,
5048: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
5049: p_version_number IN igs_he_st_spa.version_number%TYPE,
5050: p_enrl_start_dt IN DATE,
5051: p_enrl_end_dt IN DATE,
5052: p_susp_act_std OUT NOCOPY VARCHAR2)

Line 5049: p_version_number IN igs_he_st_spa.version_number%TYPE,

5045:
5046: PROCEDURE get_studies_susp
5047: (p_person_id IN igs_pe_person.person_id%TYPE,
5048: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
5049: p_version_number IN igs_he_st_spa.version_number%TYPE,
5050: p_enrl_start_dt IN DATE,
5051: p_enrl_end_dt IN DATE,
5052: p_susp_act_std OUT NOCOPY VARCHAR2)
5053:

Line 5509: (p_oss_destination IN igs_he_st_spa.destination%TYPE,

5505:
5506:
5507:
5508: PROCEDURE get_destination
5509: (p_oss_destination IN igs_he_st_spa.destination%TYPE,
5510: p_hesa_destination OUT NOCOPY VARCHAR2)
5511: IS
5512: /***************************************************************
5513: Created By :

Line 5549: (p_oss_itt_outcome IN igs_he_st_spa.itt_prog_outcome%TYPE,

5545:
5546:
5547:
5548: PROCEDURE get_itt_outcome
5549: (p_oss_itt_outcome IN igs_he_st_spa.itt_prog_outcome%TYPE,
5550: p_teach_train_prg IN igs_he_st_spa.teacher_train_prog_id%TYPE,
5551: p_hesa_itt_outcome OUT NOCOPY VARCHAR2)
5552: IS
5553: /***************************************************************

Line 5550: p_teach_train_prg IN igs_he_st_spa.teacher_train_prog_id%TYPE,

5546:
5547:
5548: PROCEDURE get_itt_outcome
5549: (p_oss_itt_outcome IN igs_he_st_spa.itt_prog_outcome%TYPE,
5550: p_teach_train_prg IN igs_he_st_spa.teacher_train_prog_id%TYPE,
5551: p_hesa_itt_outcome OUT NOCOPY VARCHAR2)
5552: IS
5553: /***************************************************************
5554: Created By :

Line 5590: (p_oss_ufi_place IN igs_he_st_spa.ufi_place%TYPE,

5586: END get_itt_outcome;
5587:
5588:
5589: PROCEDURE get_ufi_place
5590: (p_oss_ufi_place IN igs_he_st_spa.ufi_place%TYPE,
5591: p_hesa_ufi_place OUT NOCOPY VARCHAR2)
5592: IS
5593: /***************************************************************
5594: Created By :

Line 5674: (p_spa_social_class_ind IN igs_he_st_spa.social_class_ind%TYPE,

5670:
5671:
5672:
5673: PROCEDURE get_social_class_ind
5674: (p_spa_social_class_ind IN igs_he_st_spa.social_class_ind%TYPE,
5675: p_adm_social_class_ind IN igs_he_ad_dtl.social_class_cd%TYPE,
5676: p_hesa_social_class_ind OUT NOCOPY VARCHAR2)
5677: IS
5678: /***************************************************************

Line 5716: (p_spa_occupation_code IN igs_he_st_spa.occupation_code%TYPE,

5712:
5713:
5714:
5715: PROCEDURE get_occupation_code
5716: (p_spa_occupation_code IN igs_he_st_spa.occupation_code%TYPE,
5717: p_hesa_occupation_code OUT NOCOPY VARCHAR2)
5718: IS
5719: /***************************************************************
5720: Created By :

Line 5902: (p_course_cd IN igs_he_st_spa.course_cd%TYPE,

5898:
5899:
5900:
5901: PROCEDURE get_regulatory_body
5902: (p_course_cd IN igs_he_st_spa.course_cd%TYPE,
5903: p_version_number IN igs_he_st_spa.version_number%TYPE,
5904: p_hesa_regulatory_body OUT NOCOPY VARCHAR2)
5905: IS
5906: /***************************************************************

Line 5903: p_version_number IN igs_he_st_spa.version_number%TYPE,

5899:
5900:
5901: PROCEDURE get_regulatory_body
5902: (p_course_cd IN igs_he_st_spa.course_cd%TYPE,
5903: p_version_number IN igs_he_st_spa.version_number%TYPE,
5904: p_hesa_regulatory_body OUT NOCOPY VARCHAR2)
5905: IS
5906: /***************************************************************
5907: Created By :

Line 5953: (p_spa_nhs_fund_src IN igs_he_st_spa.nhs_funding_source%TYPE,

5949:
5950:
5951:
5952: PROCEDURE get_nhs_fund_src
5953: (p_spa_nhs_fund_src IN igs_he_st_spa.nhs_funding_source%TYPE,
5954: p_prg_nhs_fund_src IN igs_he_st_spa.nhs_funding_source%TYPE,
5955: p_hesa_nhs_fund_src OUT NOCOPY VARCHAR2)
5956: IS
5957: /***************************************************************

Line 5954: p_prg_nhs_fund_src IN igs_he_st_spa.nhs_funding_source%TYPE,

5950:
5951:
5952: PROCEDURE get_nhs_fund_src
5953: (p_spa_nhs_fund_src IN igs_he_st_spa.nhs_funding_source%TYPE,
5954: p_prg_nhs_fund_src IN igs_he_st_spa.nhs_funding_source%TYPE,
5955: p_hesa_nhs_fund_src OUT NOCOPY VARCHAR2)
5956: IS
5957: /***************************************************************
5958: Created By :

Line 5995: (p_spa_nhs_employer IN igs_he_st_spa.nhs_employer%TYPE,

5991:
5992:
5993:
5994: PROCEDURE get_nhs_employer
5995: (p_spa_nhs_employer IN igs_he_st_spa.nhs_employer%TYPE,
5996: p_hesa_nhs_employer OUT NOCOPY VARCHAR2)
5997: IS
5998: /***************************************************************
5999: Created By :

Line 6035: p_course_cd IN igs_he_st_spa.course_cd%TYPE,

6031:
6032:
6033: PROCEDURE get_qual_dets
6034: (p_person_id IN igs_pe_person.person_id%TYPE,
6035: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
6036: p_hesa_qual IN VARCHAR2,
6037: p_no_of_qual OUT NOCOPY NUMBER,
6038: p_tariff_score OUT NOCOPY NUMBER)
6039: IS

Line 6057: FROM igs_he_st_spa_ut a,

6053:
6054: CURSOR c_qdet IS
6055: SELECT SUM(number_of_qual),
6056: SUM(tariff_score)
6057: FROM igs_he_st_spa_ut a,
6058: igs_he_ut_lvl_award b,
6059: igs_he_ut_calc_type c
6060: WHERE a.person_id = p_person_id
6061: AND a.course_cd = p_course_cd

Line 6097: p_student_inst_number IN igs_he_st_spa.student_inst_number%TYPE,

6093: PROCEDURE get_module_dets
6094: (p_person_id IN igs_pe_person.person_id%TYPE,
6095: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
6096: p_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
6097: p_student_inst_number IN igs_he_st_spa.student_inst_number%TYPE,
6098: p_cal_type IN igs_en_stdnt_ps_att.cal_type%TYPE,
6099: p_enrl_start_dt IN DATE,
6100: p_enrl_end_dt IN DATE,
6101: p_offset_days IN NUMBER,

Line 6134: igs_he_st_spa_all c,

6130: d.prop_of_teaching_in_welsh,
6131: NVL(cps.enrolled_credit_points,b.enrolled_credit_points) enrolled_credit_point
6132: FROM igs_en_su_attempt_all a,
6133: igs_ps_unit_ver_all b,
6134: igs_he_st_spa_all c,
6135: igs_he_st_unt_vs_all d,
6136: igs_ps_usec_cps cps
6137: WHERE a.unit_cd = b.unit_cd
6138: AND a.version_number = b.version_number

Line 6156: igs_he_st_spa_all c,

6152: d.prop_of_teaching_in_welsh,
6153: NVL(cps.enrolled_credit_points,b.enrolled_credit_points) enrolled_credit_point
6154: FROM igs_en_su_attempt_all a,
6155: igs_ps_unit_ver_all b,
6156: igs_he_st_spa_all c,
6157: igs_he_st_unt_vs_all d,
6158: igs_as_su_stmptout e,
6159: igs_ps_usec_cps cps
6160: WHERE a.unit_cd = b.unit_cd

Line 6190: igs_he_st_spa_all spa

6186: suo.outcome_dt,
6187: sua.uoo_id
6188: FROM igs_as_su_stmptout suo,
6189: igs_en_su_attempt_all sua,
6190: igs_he_st_spa_all spa
6191: WHERE suo.person_id = sua.person_id
6192: AND suo.course_cd = sua.course_cd
6193: AND suo.uoo_id = sua.uoo_id
6194: AND sua.person_id = spa.person_id

Line 6318: p_course_cd IN igs_he_st_spa.course_cd%TYPE,

6314:
6315:
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,

Line 6319: p_version_number IN igs_he_st_spa.version_number%TYPE,

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

Line 6410: p_course_cd IN igs_he_st_spa.course_cd%TYPE,

6406:
6407:
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

Line 6411: p_version_number IN igs_he_st_spa.version_number%TYPE,

6407:
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: /***************************************************************

Line 6754: ( p_hesa_commdate IN igs_he_st_spa_all.commencement_dt%TYPE ,

6750:
6751:
6752:
6753: PROCEDURE get_commencement_dt
6754: ( p_hesa_commdate IN igs_he_st_spa_all.commencement_dt%TYPE ,
6755: p_enstdnt_commdate IN igs_en_stdnt_ps_att.commencement_dt%TYPE,
6756: p_person_id IN igs_pe_person.person_id%TYPE ,
6757: p_course_cd IN igs_he_st_spa_all.course_cd%TYPE,
6758: p_version_number IN igs_he_st_spa_all.version_number%TYPE,

Line 6757: p_course_cd IN igs_he_st_spa_all.course_cd%TYPE,

6753: PROCEDURE get_commencement_dt
6754: ( p_hesa_commdate IN igs_he_st_spa_all.commencement_dt%TYPE ,
6755: p_enstdnt_commdate IN igs_en_stdnt_ps_att.commencement_dt%TYPE,
6756: p_person_id IN igs_pe_person.person_id%TYPE ,
6757: p_course_cd IN igs_he_st_spa_all.course_cd%TYPE,
6758: p_version_number IN igs_he_st_spa_all.version_number%TYPE,
6759: p_student_inst_number IN igs_he_st_spa_all.student_inst_number%TYPE,
6760: p_final_commdate OUT NOCOPY igs_he_ex_rn_dat_fd.value%TYPE)
6761:

Line 6758: p_version_number IN igs_he_st_spa_all.version_number%TYPE,

6754: ( p_hesa_commdate IN igs_he_st_spa_all.commencement_dt%TYPE ,
6755: p_enstdnt_commdate IN igs_en_stdnt_ps_att.commencement_dt%TYPE,
6756: p_person_id IN igs_pe_person.person_id%TYPE ,
6757: p_course_cd IN igs_he_st_spa_all.course_cd%TYPE,
6758: p_version_number IN igs_he_st_spa_all.version_number%TYPE,
6759: p_student_inst_number IN igs_he_st_spa_all.student_inst_number%TYPE,
6760: p_final_commdate OUT NOCOPY igs_he_ex_rn_dat_fd.value%TYPE)
6761:
6762: IS

Line 6759: p_student_inst_number IN igs_he_st_spa_all.student_inst_number%TYPE,

6755: p_enstdnt_commdate IN igs_en_stdnt_ps_att.commencement_dt%TYPE,
6756: p_person_id IN igs_pe_person.person_id%TYPE ,
6757: p_course_cd IN igs_he_st_spa_all.course_cd%TYPE,
6758: p_version_number IN igs_he_st_spa_all.version_number%TYPE,
6759: p_student_inst_number IN igs_he_st_spa_all.student_inst_number%TYPE,
6760: p_final_commdate OUT NOCOPY igs_he_ex_rn_dat_fd.value%TYPE)
6761:
6762: IS
6763: /***************************************************************

Line 6767: First IGS_HE_ST_SPA_ALL.commencement date is cinsidered.If NULL then it is checked if program transfer has taken palce

6763: /***************************************************************
6764: Created By : bayadav
6765: Date Created By : 25-Mar-2002
6766: Purpose : This procedure gets the value of commencement date for combined/stduent field 26.
6767: First IGS_HE_ST_SPA_ALL.commencement date is cinsidered.If NULL then it is checked if program transfer has taken palce
6768: If yes ,then assign get the value of first program in chain for that person
6769: (For the person having the same student instance number for the different program transfer are said to be in same chain)
6770: and assign the corresponding IGS_EN_STDNT_PS_ATT.commencement_dt value to it
6771: else if the program transfer has not taken palce then get the IGS_EN_STDNT_PS_ATT.commencement_dt value

Line 6781: -- IGS_HE_ST_SPA having same instance number

6777: smaddali 24-mar-03 modified for Build HEFD209 - Bug#2717755 , removed cursor c_course_trn and its code
6778: ***************************************************************/
6779:
6780: --Cursor to get the commencement date of the first porgram in chain for the context person from
6781: -- IGS_HE_ST_SPA having same instance number
6782: CURSOR c_list_crs_trn IS
6783: SELECT MIN(sca.commencement_dt) commencement_dt
6784: FROM igs_en_stdnt_ps_att_all sca,
6785: igs_he_st_spa_all hspa

Line 6785: igs_he_st_spa_all hspa

6781: -- IGS_HE_ST_SPA having same instance number
6782: CURSOR c_list_crs_trn IS
6783: SELECT MIN(sca.commencement_dt) commencement_dt
6784: FROM igs_en_stdnt_ps_att_all sca,
6785: igs_he_st_spa_all hspa
6786: WHERE hspa.person_id = p_person_id
6787: AND hspa.student_inst_number = p_student_inst_number
6788: AND sca.person_id = hspa.person_id
6789: AND sca.course_cd = hspa.course_cd;

Line 7332: (p_oss_dependants IN igs_he_st_spa.dependants_cd%TYPE,

7328: App_Exception.Raise_Exception;
7329: END get_marital_status;
7330:
7331: PROCEDURE get_dependants
7332: (p_oss_dependants IN igs_he_st_spa.dependants_cd%TYPE,
7333: p_hesa_dependants OUT NOCOPY VARCHAR2)
7334: IS
7335: /***************************************************************
7336: Created By : Jonathan Baber

Line 7372: p_spa_enh_fund_elig IN igs_he_st_spa.enh_fund_elig_cd%TYPE,

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: /***************************************************************
7376: Created By : Jonathan Baber

Line 7471: (p_spa_gov_initiatives_cd IN igs_he_st_spa.gov_initiatives_cd%TYPE,

7467:
7468:
7469:
7470: PROCEDURE get_gov_init
7471: (p_spa_gov_initiatives_cd IN igs_he_st_spa.gov_initiatives_cd%TYPE,
7472: p_prog_gov_initiatives_cd IN igs_he_st_prog.gov_initiatives_cd%TYPE,
7473: p_hesa_gov_initiatives_cd OUT NOCOPY VARCHAR2)
7474: IS
7475: /***************************************************************

Line 7515: p_spa_units_completed IN igs_he_st_spa.units_completed%TYPE,

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: /***************************************************************
7519: Created By : Jonathan Baber

Line 7528: -- attempted by the student from the igs_he_st_spa table with the same student inst number

7524: Who When What
7525: ***************************************************************/
7526:
7527: -- This query counts the number of units completed by getting all the course codes
7528: -- attempted by the student from the igs_he_st_spa table with the same student inst number
7529: -- as the course given in the parameter p_course_cd.
7530: -- The associated "COMPLETED' unit attempts are then selected where the outcome date is less
7531: -- than or equal to the reporting period end date.
7532: CURSOR c_unit_count IS

Line 7536: igs_he_st_spa spa1, igs_he_st_spa spa2, igs_as_grd_sch_grade gsg

7532: CURSOR c_unit_count IS
7533: SELECT count(*)
7534: FROM
7535: igs_en_su_attempt_all su, igs_as_su_stmptout_all suo1,
7536: igs_he_st_spa spa1, igs_he_st_spa spa2, igs_as_grd_sch_grade gsg
7537: WHERE su.person_id = suo1.person_id
7538: AND su.course_cd = suo1.course_cd
7539: AND su.unit_cd = suo1.unit_cd
7540: AND su.unit_attempt_status = 'COMPLETED'

Line 7588: (p_spa_disadv_uplift_elig_cd IN igs_he_st_spa.disadv_uplift_elig_cd%TYPE,

7584: App_Exception.Raise_Exception;
7585: END get_units_completed;
7586:
7587: PROCEDURE get_disadv_uplift_elig
7588: (p_spa_disadv_uplift_elig_cd IN igs_he_st_spa.disadv_uplift_elig_cd%TYPE,
7589: p_prog_disadv_uplift_elig_cd IN igs_he_st_prog.disadv_uplift_elig_cd%TYPE,
7590: p_hesa_disadv_uplift_elig_cd OUT NOCOPY VARCHAR2)
7591: IS
7592: /***************************************************************

Line 7627: (p_spa_franch_out_arr_cd IN igs_he_st_spa.franch_out_arr_cd%TYPE,

7623: App_Exception.Raise_Exception;
7624: END get_disadv_uplift_elig;
7625:
7626: PROCEDURE get_franch_out_arr
7627: (p_spa_franch_out_arr_cd IN igs_he_st_spa.franch_out_arr_cd%TYPE,
7628: p_prog_franch_out_arr_cd IN igs_he_st_prog.franch_out_arr_cd%TYPE,
7629: p_hesa_franch_out_arr_cd OUT NOCOPY VARCHAR2)
7630: IS
7631: /***************************************************************

Line 7666: (p_spa_employer_role_cd IN igs_he_st_spa.employer_role_cd%TYPE,

7662: App_Exception.Raise_Exception;
7663: END get_franch_out_arr;
7664:
7665: PROCEDURE get_employer_role
7666: (p_spa_employer_role_cd IN igs_he_st_spa.employer_role_cd%TYPE,
7667: p_hesa_employer_role_cd OUT NOCOPY VARCHAR2)
7668: IS
7669: /***************************************************************
7670: Created By : Jonathan Baber

Line 7705: (p_spa_franch_partner_cd IN igs_he_st_spa.franch_partner_cd%TYPE,

7701: END get_employer_role;
7702:
7703:
7704: PROCEDURE get_franchise_partner
7705: (p_spa_franch_partner_cd IN igs_he_st_spa.franch_partner_cd%TYPE,
7706: p_hesa_franch_partner_cd OUT NOCOPY VARCHAR2)
7707: IS
7708: /***************************************************************
7709: Created By : Jonathan Baber