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 49: (p_person_id IN igs_pe_person.person_id%TYPE,

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

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

78: p_hesa_fund_src OUT NOCOPY VARCHAR2);
79:
80: -- smaddali 11-dec-03 Modified for bug#3235753 , added 2 new parameters
81: PROCEDURE get_fundability_cd
82: (p_person_id IN igs_pe_person.person_id%TYPE,
83: p_susa_fund_cd IN igs_he_en_susa.fundability_code%TYPE,
84: p_spa_funding_source IN igs_en_stdnt_ps_att.funding_source%TYPE,
85: p_poous_fund_cd IN igs_he_poous.fundability_cd%TYPE,
86: p_prg_fund_cd IN igs_he_st_prog.fundability%TYPE,

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

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

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

97: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,
98: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);
99:
100: PROCEDURE get_gender
101: (p_gender IN igs_pe_person.sex%TYPE,
102: p_hesa_gender OUT NOCOPY VARCHAR2);
103:
104: PROCEDURE get_domicile
105: (p_ad_domicile IN igs_he_ad_dtl.domicile_cd%TYPE,

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

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

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

112: p_nationality OUT NOCOPY VARCHAR2,
113: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL);
114:
115: PROCEDURE get_ethnicity
116: (p_person_id IN igs_pe_person.person_id%TYPE,
117: p_oss_eth IN igs_pe_stat_v.ethnic_origin_id%TYPE,
118: p_hesa_eth OUT NOCOPY VARCHAR2);
119:
120: PROCEDURE get_disablity_allow

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

122: p_hesa_dis_allow OUT NOCOPY VARCHAR2);
123:
124: -- smaddali 11-dec-03 Modified for bug#3235753 , added 2 new parameters
125: PROCEDURE get_disablity
126: (p_person_id IN igs_pe_person.person_id%TYPE,
127: p_disability OUT NOCOPY VARCHAR2,
128: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,
129: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);
130:

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

132: (p_oss_supp_band IN igs_he_en_susa.additional_sup_band%TYPE,
133: p_hesa_supp_band OUT NOCOPY VARCHAR2);
134:
135: PROCEDURE get_yr_left_last_inst
136: (p_person_id IN igs_pe_person.person_id%TYPE,
137: p_com_dt IN DATE,
138: p_hesa_gen_qaim IN VARCHAR2,
139: p_ucasnum IN igs_pe_alt_pers_id.api_person_id%TYPE,
140: p_year OUT NOCOPY VARCHAR2);

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

177: p_hesa_study_location OUT NOCOPY VARCHAR2);
178:
179: -- smaddali 11-dec-03 Modified for bug#3235753 , added 2 new parameters
180: PROCEDURE get_term_time_acc
181: (p_person_id IN igs_pe_person.person_id%TYPE,
182: p_susa_term_time_acc IN igs_he_en_susa.term_time_accom%TYPE,
183: p_study_location IN VARCHAR2,
184: p_hesa_term_time_acc OUT NOCOPY VARCHAR2,
185: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,

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

223:
224:
225: --smaddali 6-jun-2002 bug 2396174 added parameter p_course_cd
226: PROCEDURE get_completion_status
227: (p_person_id IN igs_pe_person.person_id%TYPE,
228: p_course_cd IN igs_he_st_spa.course_cd%TYPE ,
229: p_susa_comp_status IN igs_he_en_susa.completion_status%TYPE,
230: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
231: p_crs_req_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE ,

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

239: p_discont_date IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
240: p_hesa_good_st_mk OUT NOCOPY VARCHAR2);
241:
242: PROCEDURE get_qual_obtained
243: (p_person_id IN igs_pe_person.person_id%TYPE,
244: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
245: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
246: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
247: p_oss_qual_obt1 OUT NOCOPY VARCHAR2,

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

266: p_prop_ind OUT NOCOPY VARCHAR2);
267:
268: -- smaddali added 2 new parameters for bug#3360646
269: PROCEDURE get_gen_qual_aim
270: (p_person_id IN igs_pe_person.person_id%TYPE,
271: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
272: p_version_number IN igs_he_st_spa.version_number%TYPE,
273: p_spa_gen_qaim IN igs_he_st_spa.student_qual_aim%TYPE,
274: p_hesa_gen_qaim OUT NOCOPY VARCHAR2,

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

315: p_hesa_teach_qual_sbj OUT NOCOPY VARCHAR2);
316:
317: -- smaddali 11-dec-03 Modified for bug#3235753 , added 2 new parameters
318: PROCEDURE get_fee_elig
319: (p_person_id IN igs_pe_person.person_id%TYPE,
320: p_susa_fee_elig IN igs_he_en_susa.fee_eligibility%TYPE,
321: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
322: p_study_mode IN VARCHAR2,
323: p_special_student IN VARCHAR2,

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

333: p_hesa_fee_band OUT NOCOPY VARCHAR2);
334:
335: -- smaddali 13-oct-03 modified procedure to add 2 new parameters for bug# 3179544
336: PROCEDURE get_amt_tuition_fees
337: (p_person_id IN igs_pe_person.person_id%TYPE,
338: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
339: p_cal_type IN igs_en_stdnt_ps_att.cal_type%TYPE,
340: p_fe_prg_mrker IN igs_he_st_prog.fe_program_marker%TYPE,
341: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,

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

344: p_enrl_start_dt IN DATE DEFAULT NULL,
345: p_enrl_end_dt IN DATE DEFAULT NULL);
346:
347: PROCEDURE get_maj_src_tu_fee
348: (p_person_id IN igs_pe_person.person_id%TYPE,
349: p_enrl_start_dt IN DATE,
350: p_enrl_end_dt IN DATE,
351: p_special_stdnt IN VARCHAR2,
352: p_study_mode IN VARCHAR2,

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

372:
373:
374:
375: PROCEDURE get_oth_teach_inst
376: (p_person_id IN igs_pe_person.person_id%TYPE,
377: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
378: p_program_calc IN igs_he_st_prog.program_calc%TYPE,
379: p_susa_inst1 IN igs_he_en_susa.teaching_inst1%TYPE,
380: p_poous_inst1 IN igs_he_poous.other_instit_teach1%TYPE,

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

388: p_enrl_end_dt IN DATE);
389:
390: -- smaddali added new parameters p_enrl_start_dt , p_enrl_end_dt for bug 2437081
391: PROCEDURE get_prop_not_taught
392: (p_person_id IN igs_pe_person.person_id%TYPE,
393: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
394: p_enrl_start_dt IN DATE,
395: p_enrl_end_dt IN DATE,
396: p_program_calc IN igs_he_st_prog.program_calc%TYPE,

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

409: p_hesa_credit_level OUT NOCOPY VARCHAR2);
410:
411: -- jbaber added crd_pt3-4, lvl_crd_pt3-4 for HEFD350
412: PROCEDURE get_credit_obtained
413: (p_person_id IN igs_pe_person.person_id%TYPE,
414: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
415: p_prog_calc IN igs_he_st_prog.program_calc%TYPE,
416: p_susa_crd_pt1 IN igs_he_en_susa.credit_pt_achieved1%TYPE,
417: p_susa_crd_pt2 IN igs_he_en_susa.credit_pt_achieved2%TYPE,

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

433: p_enrl_end_dt IN DATE );
434:
435: --jbaber added new parameter p_validation_country for HEFD350 process 2
436: PROCEDURE get_cost_centres
437: (p_person_id IN igs_pe_person.person_id%TYPE,
438: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
439: p_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
440: p_unit_set_cd IN igs_he_poous.unit_set_cd%TYPE,
441: p_us_version_number IN igs_he_poous.us_version_number%TYPE,

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

455: p_validation_country IN igs_he_submsn_header.validation_country%TYPE);
456:
457: -- jbaber 25-Nov-2004 Included p_version_number for bug # 4037237
458: PROCEDURE get_studies_susp
459: (p_person_id IN igs_pe_person.person_id%TYPE,
460: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
461: p_version_number IN igs_he_st_spa.version_number%TYPE,
462: p_enrl_start_dt IN DATE,
463: p_enrl_end_dt IN DATE,

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

517: (p_spa_occupation_code IN igs_he_st_spa.occupation_code%TYPE,
518: p_hesa_occupation_code OUT NOCOPY VARCHAR2);
519:
520: PROCEDURE get_inst_last_attended
521: (p_person_id IN igs_pe_person.person_id%TYPE,
522: p_com_date IN DATE,
523: p_inst_last_att OUT NOCOPY VARCHAR2,
524: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,
525: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);

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

538: (p_spa_nhs_employer IN igs_he_st_spa.nhs_employer%TYPE,
539: p_hesa_nhs_employer OUT NOCOPY VARCHAR2);
540:
541: PROCEDURE get_qual_dets
542: (p_person_id IN igs_pe_person.person_id%TYPE,
543: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
544: p_hesa_qual IN VARCHAR2,
545: p_no_of_qual OUT NOCOPY NUMBER,
546: p_tariff_score OUT NOCOPY NUMBER);

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

546: p_tariff_score OUT NOCOPY NUMBER);
547:
548:
549: PROCEDURE get_module_dets
550: (p_person_id IN igs_pe_person.person_id%TYPE,
551: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
552: p_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
553: p_student_inst_number IN igs_he_st_spa.student_inst_number%TYPE,
554: p_cal_type IN igs_en_stdnt_ps_att.cal_type%TYPE,

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

559: p_total_recs OUT NOCOPY NUMBER);
560:
561: -- jbaber 25-Nov-2004 Included p_version_number for bug # 4037237
562: PROCEDURE get_mode_of_study
563: (p_person_id IN igs_pe_person.person_id%TYPE,
564: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
565: p_version_number IN igs_he_st_spa.version_number%TYPE,
566: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
567: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,

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

570: p_attendance_type IN igs_en_stdnt_ps_att.attendance_type%TYPE,
571: p_mode_of_study OUT NOCOPY VARCHAR2);
572:
573: FUNCTION isDormant
574: (p_person_id IN igs_pe_person.person_id%TYPE,
575: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
576: p_version_number IN igs_he_st_spa.version_number%TYPE,
577: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
578: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE)

Line 589: p_person_number IN igs_pe_person.person_number%TYPE,

585: p_min_commdate IN DATE) RETURN BOOLEAN;
586:
587: PROCEDURE limit_no_of_qual
588: (p_field_number IN NUMBER,
589: p_person_number IN igs_pe_person.person_number%TYPE,
590: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
591: p_hesa_qual IN VARCHAR2,
592: p_no_of_qual IN OUT NOCOPY NUMBER);
593:

Line 596: p_person_number IN igs_pe_person.person_number%TYPE,

592: p_no_of_qual IN OUT NOCOPY NUMBER);
593:
594: PROCEDURE limit_tariff_score
595: (p_field_number IN NUMBER,
596: p_person_number IN igs_pe_person.person_number%TYPE,
597: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
598: p_hesa_qual IN VARCHAR2,
599: p_tariff_score IN OUT NOCOPY igs_he_ex_rn_dat_fd.value%TYPE);
600:

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

613: p_version_number IN igs_he_st_unt_vs.version_number%TYPE,
614: p_oth_teach_inst OUT NOCOPY VARCHAR2);
615:
616: PROCEDURE get_pgce_class
617: (p_person_id IN igs_pe_person.person_id%TYPE,
618: p_pgce_class OUT NOCOPY VARCHAR2);
619:
620:
621: PROCEDURE get_commencement_dt

Line 624: p_person_id IN igs_pe_person.person_id%TYPE ,

620:
621: PROCEDURE get_commencement_dt
622: ( p_hesa_commdate IN igs_he_st_spa_all.commencement_dt%TYPE DEFAULT NULL,
623: p_enstdnt_commdate IN igs_en_stdnt_ps_att.commencement_dt%TYPE DEFAULT NULL,
624: p_person_id IN igs_pe_person.person_id%TYPE ,
625: p_course_cd IN igs_he_st_spa_all.course_cd%TYPE,
626: p_version_number IN igs_he_st_spa_all.version_number%TYPE,
627: p_student_inst_number IN igs_he_st_spa_all.student_inst_number%TYPE,
628: p_final_commdate OUT NOCOPY igs_he_ex_rn_dat_fd.value%TYPE );

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

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

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

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

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

674: p_prog_gov_initiatives_cd IN igs_he_st_prog.gov_initiatives_cd%TYPE,
675: p_hesa_gov_initiatives_cd OUT NOCOPY VARCHAR2);
676:
677: PROCEDURE get_units_completed
678: (p_person_id IN igs_pe_person.person_id%TYPE,
679: p_course_cd IN igs_ps_ver.course_cd%TYPE,
680: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
681: p_spa_units_completed IN igs_he_st_spa.units_completed%TYPE,
682: p_hesa_units_completed OUT NOCOPY VARCHAR2);

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

699: (p_spa_franch_partner_cd IN igs_he_st_spa.franch_partner_cd%TYPE,
700: p_hesa_franch_partner_cd OUT NOCOPY VARCHAR2);
701:
702: PROCEDURE get_welsh_speaker_ind
703: (p_person_id IN igs_pe_person.person_id%TYPE,
704: p_hesa_welsh_speaker_ind OUT NOCOPY VARCHAR2);
705:
706: PROCEDURE get_national_id
707: (p_person_id IN igs_pe_person.person_id%TYPE,

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

703: (p_person_id IN igs_pe_person.person_id%TYPE,
704: p_hesa_welsh_speaker_ind OUT NOCOPY VARCHAR2);
705:
706: PROCEDURE get_national_id
707: (p_person_id IN igs_pe_person.person_id%TYPE,
708: p_hesa_national_id1 OUT NOCOPY VARCHAR2,
709: p_hesa_national_id2 OUT NOCOPY VARCHAR2);
710:
711: -- anwest 19-Dec-05 Changes as per (4731723) HE360 - HESA REQUIREMENTS FOR 2005/06 REPORTING

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

709: p_hesa_national_id2 OUT NOCOPY VARCHAR2);
710:
711: -- anwest 19-Dec-05 Changes as per (4731723) HE360 - HESA REQUIREMENTS FOR 2005/06 REPORTING
712: PROCEDURE get_welsh_bacc_qual
713: (p_person_id IN igs_pe_person.person_id%TYPE,
714: p_welsh_bacc OUT NOCOPY VARCHAR2);
715:
716: END IGS_HE_EXTRACT_FIELDS_PKG;