APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_HE_ST_UNT_VS

Line 22: TYPE welsh_prop IS TABLE of igs_he_st_unt_vs.prop_of_teaching_in_welsh%TYPE

18: TYPE unit IS TABLE of VARCHAR2(20)
19: INDEX BY binary_integer;
20: TYPE result IS TABLE of igs_he_code_map_val.map1%TYPE
21: INDEX BY binary_integer;
22: TYPE welsh_prop IS TABLE of igs_he_st_unt_vs.prop_of_teaching_in_welsh%TYPE
23: INDEX BY binary_integer;
24:
25: TYPE mod_rec IS RECORD
26: (module_id unit,

Line 447: p_unit_cd IN igs_he_st_unt_vs.unit_cd%TYPE,

443: p_attendance_mode IN igs_he_poous.attendance_mode%TYPE,
444: p_attendance_type IN igs_he_poous.attendance_type%TYPE,
445: p_location_cd IN igs_he_poous.location_cd%TYPE,
446: p_program_calc IN igs_he_st_prog.program_calc%TYPE,
447: p_unit_cd IN igs_he_st_unt_vs.unit_cd%TYPE,
448: p_uv_version_number IN igs_he_st_unt_vs.version_number%TYPE,
449: p_return_type IN VARCHAR2,
450: p_cost_ctr_rec IN OUT NOCOPY cc_rec,
451: p_total_recs OUT NOCOPY NUMBER,

Line 448: p_uv_version_number IN igs_he_st_unt_vs.version_number%TYPE,

444: p_attendance_type IN igs_he_poous.attendance_type%TYPE,
445: p_location_cd IN igs_he_poous.location_cd%TYPE,
446: p_program_calc IN igs_he_st_prog.program_calc%TYPE,
447: p_unit_cd IN igs_he_st_unt_vs.unit_cd%TYPE,
448: p_uv_version_number IN igs_he_st_unt_vs.version_number%TYPE,
449: p_return_type IN VARCHAR2,
450: p_cost_ctr_rec IN OUT NOCOPY cc_rec,
451: p_total_recs OUT NOCOPY NUMBER,
452: p_enrl_start_dt IN DATE,

Line 607: (p_unit_cd IN igs_he_st_unt_vs.unit_cd%TYPE,

603: p_unit_level IN igs_ps_unit_ver_v.unit_level%TYPE,
604: p_prop_of_fte OUT NOCOPY VARCHAR2);
605:
606: PROCEDURE get_mod_prop_not_taught
607: (p_unit_cd IN igs_he_st_unt_vs.unit_cd%TYPE,
608: p_version_number IN igs_he_st_unt_vs.version_number%TYPE,
609: p_prop_not_taught OUT NOCOPY VARCHAR2);
610:
611: PROCEDURE get_mod_oth_teach_inst

Line 608: p_version_number IN igs_he_st_unt_vs.version_number%TYPE,

604: p_prop_of_fte OUT NOCOPY VARCHAR2);
605:
606: PROCEDURE get_mod_prop_not_taught
607: (p_unit_cd IN igs_he_st_unt_vs.unit_cd%TYPE,
608: p_version_number IN igs_he_st_unt_vs.version_number%TYPE,
609: p_prop_not_taught OUT NOCOPY VARCHAR2);
610:
611: PROCEDURE get_mod_oth_teach_inst
612: (p_unit_cd IN igs_he_st_unt_vs.unit_cd%TYPE,

Line 612: (p_unit_cd IN igs_he_st_unt_vs.unit_cd%TYPE,

608: p_version_number IN igs_he_st_unt_vs.version_number%TYPE,
609: p_prop_not_taught OUT NOCOPY VARCHAR2);
610:
611: PROCEDURE get_mod_oth_teach_inst
612: (p_unit_cd IN igs_he_st_unt_vs.unit_cd%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

Line 613: p_version_number IN igs_he_st_unt_vs.version_number%TYPE,

609: p_prop_not_taught OUT NOCOPY VARCHAR2);
610:
611: PROCEDURE get_mod_oth_teach_inst
612: (p_unit_cd IN igs_he_st_unt_vs.unit_cd%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,