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_PE_PERSON

Line 106: (p_person_id IN igs_pe_person.person_id%TYPE,

102: END get_campus_id;
103:
104:
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

Line 814: (p_person_id IN igs_pe_person.person_id%TYPE,

810: END get_funding_src;
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,

Line 977: (p_person_id IN igs_pe_person.person_id%TYPE,

973: END get_fundability_cd;
974:
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

Line 994: FROM igs_pe_person_alias_v

990: ***************************************************************/
991: -- smaddali modified this cursor to get records which are effective in the HESA submission period, bug#3235753
992: CURSOR c_fmly_nm IS
993: SELECT surname
994: FROM igs_pe_person_alias_v
995: WHERE person_id = p_person_id
996: AND alias_type = 'SNAME16'
997: AND ( Start_Dt IS NULL OR Start_Dt <= p_enrl_end_dt )
998: AND ( End_Dt IS NULL OR End_Dt >= p_enrl_start_dt )

Line 1024: (p_gender IN igs_pe_person.sex%TYPE,

1020: END get_fmly_name_on_16_bday;
1021:
1022:
1023: PROCEDURE get_gender
1024: (p_gender IN igs_pe_person.sex%TYPE,
1025: p_hesa_gender OUT NOCOPY VARCHAR2)
1026: IS
1027: /***************************************************************
1028: Created By :

Line 1103: (p_person_id IN igs_pe_person.person_id%TYPE,

1099: END get_domicile;
1100:
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

Line 1169: p_person_id IN igs_pe_person.person_id%TYPE,

1165: END get_nationality;
1166:
1167:
1168: PROCEDURE get_ethnicity (
1169: p_person_id IN igs_pe_person.person_id%TYPE,
1170: p_oss_eth IN igs_pe_stat_v.ethnic_origin_id%TYPE,
1171: p_hesa_eth OUT NOCOPY VARCHAR2) IS
1172: /***************************************************************
1173: Created By :

Line 1252: (p_person_id IN igs_pe_person.person_id%TYPE,

1248: END get_disablity_allow;
1249:
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:

Line 1378: (p_person_id IN igs_pe_person.person_id%TYPE,

1374: END get_addnl_supp_band;
1375:
1376:
1377: PROCEDURE get_yr_left_last_inst
1378: (p_person_id IN igs_pe_person.person_id%TYPE,
1379: p_com_dt IN DATE,
1380: p_hesa_gen_qaim IN VARCHAR2,
1381: p_ucasnum IN igs_pe_alt_pers_id.api_person_id%TYPE,
1382: p_year OUT NOCOPY VARCHAR2)

Line 1743: (p_person_id IN igs_pe_person.person_id%TYPE,

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

Line 2184: (p_person_id IN igs_pe_person.person_id%TYPE,

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

Line 2348: (p_person_id IN igs_pe_person.person_id%TYPE,

2344: END get_good_stand_mrkr;
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,

Line 2750: p_person_number IN igs_pe_person.person_number%TYPE,

2746:
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

Line 2803: p_person_number IN igs_pe_person.person_number%TYPE,

2799: App_Exception.Raise_Exception;
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

Line 2858: (p_person_id IN igs_pe_person.person_id%TYPE,

2854: App_Exception.Raise_Exception;
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,

Line 3317: (p_person_id IN igs_pe_person.person_id%TYPE,

3313: END get_teach_qual_sbj;
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,

Line 3526: (p_person_id IN igs_pe_person.person_id%TYPE,

3522: END get_fee_band;
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,

Line 3618: (p_person_id IN igs_pe_person.person_id%TYPE,

3614: END get_amt_tuition_fees;
3615:
3616:
3617: PROCEDURE get_maj_src_tu_fee
3618: (p_person_id IN igs_pe_person.person_id%TYPE,
3619: p_enrl_start_dt IN DATE,
3620: p_enrl_end_dt IN DATE,
3621: p_special_stdnt IN VARCHAR2,
3622: p_study_mode IN VARCHAR2,

Line 3705: igs_pe_person_id_typ pit

3701: -- smaddali modified this cursor to get records which are effective in the HESA submission period, bug#3235753
3702: CURSOR cur_slc_lea_cd IS
3703: SELECT SUBSTR (api.api_person_id,1,4)
3704: FROM igs_pe_alt_pers_id_v api,
3705: igs_pe_person_id_typ pit
3706: WHERE api.person_id_type = pit.Person_id_type
3707: AND pit.s_person_id_type = 'SLC'
3708: AND api.pe_person_id = p_person_id
3709: AND NVL (api.start_dt, p_enrl_end_dt ) <= p_enrl_end_dt

Line 4033: (p_person_id IN igs_pe_person.person_id%TYPE,

4029: END get_non_payment_rsn;
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,

Line 4148: (p_person_id IN igs_pe_person.person_id%TYPE,

4144: END get_oth_teach_inst;
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,

Line 4357: (p_person_id IN igs_pe_person.person_id%TYPE,

4353: END get_credit_level;
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,

Line 4505: (p_person_id IN igs_pe_person.person_id%TYPE,

4501: END get_credit_obtained;
4502:
4503:
4504: PROCEDURE get_cost_centres
4505: (p_person_id IN igs_pe_person.person_id%TYPE,
4506: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
4507: p_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
4508: p_unit_set_cd IN igs_he_poous.unit_set_cd%TYPE,
4509: p_us_version_number IN igs_he_poous.us_version_number%TYPE,

Line 5047: (p_person_id IN igs_pe_person.person_id%TYPE,

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

Line 5756: (p_person_id IN igs_pe_person.person_id%TYPE,

5752:
5753:
5754:
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

Line 6034: (p_person_id IN igs_pe_person.person_id%TYPE,

6030: END get_nhs_employer;
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)

Line 6094: (p_person_id IN igs_pe_person.person_id%TYPE,

6090:
6091:
6092:
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,

Line 6317: (p_person_id IN igs_pe_person.person_id%TYPE,

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

Line 6409: (p_person_id IN igs_pe_person.person_id%TYPE,

6405:
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)

Line 6689: (p_person_id IN igs_pe_person.person_id%TYPE,

6685: END get_mod_oth_teach_inst;
6686:
6687:
6688: PROCEDURE get_pgce_class
6689: (p_person_id IN igs_pe_person.person_id%TYPE,
6690: p_pgce_class OUT NOCOPY VARCHAR2)
6691:
6692: IS
6693: /***************************************************************

Line 6756: p_person_id IN igs_pe_person.person_id%TYPE ,

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

Line 6820: PROCEDURE get_ucasnum(p_person_id IN igs_pe_person.person_id%TYPE,

6816: App_Exception.Raise_Exception;
6817:
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:

Line 7411: (p_person_id IN igs_pe_person.person_id%TYPE,

7407: END get_enh_fund_elig;
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

Line 7512: (p_person_id IN igs_pe_person.person_id%TYPE,

7508: App_Exception.Raise_Exception;
7509: END get_gov_init;
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)

Line 7744: (p_person_id IN igs_pe_person.person_id%TYPE,

7740: END get_franchise_partner;
7741:
7742:
7743: PROCEDURE get_welsh_speaker_ind
7744: (p_person_id IN igs_pe_person.person_id%TYPE,
7745: p_hesa_welsh_speaker_ind OUT NOCOPY VARCHAR2)
7746: IS
7747: /***************************************************************
7748: Created By : Jonathan Baber

Line 7796: (p_person_id IN igs_pe_person.person_id%TYPE,

7792: App_Exception.Raise_Exception;
7793: END get_welsh_speaker_ind;
7794:
7795: PROCEDURE get_national_id
7796: (p_person_id IN igs_pe_person.person_id%TYPE,
7797: p_hesa_national_id1 OUT NOCOPY VARCHAR2,
7798: p_hesa_national_id2 OUT NOCOPY VARCHAR2)
7799:
7800: IS

Line 7858: (p_person_id IN igs_pe_person.person_id%TYPE,

7854:
7855:
7856: -- anwest 19-Dec-05 Changes as per (4731723) HE360 - HESA REQUIREMENTS FOR 2005/06 REPORTING
7857: PROCEDURE get_welsh_bacc_qual
7858: (p_person_id IN igs_pe_person.person_id%TYPE,
7859: p_welsh_bacc OUT NOCOPY VARCHAR2) IS
7860:
7861: /******************************************************************************
7862: Created By : Andrew West