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_UNT_VS

Line 4072: igs_he_st_unt_vs_all hunt

4068: FROM igs_en_su_attempt a,
4069: igs_ps_tch_resp b,
4070: igs_pe_hz_parties ihpou,
4071: igs_pe_hz_parties ihpinst,
4072: igs_he_st_unt_vs_all hunt
4073: WHERE a.course_cd = p_course_cd
4074: AND a.person_id = p_person_id
4075: AND b.unit_cd = a.unit_cd
4076: AND b.version_number = a.version_number

Line 4186: igs_he_st_unt_vs_all hunt

4182: igs_pe_hz_parties ihpou,
4183: igs_pe_hz_parties ihpinst,
4184: igs_ps_unit_ver e,
4185: igs_ps_usec_cps cps,
4186: igs_he_st_unt_vs_all hunt
4187: WHERE a.course_cd = p_course_cd
4188: AND a.person_id = p_person_id
4189: AND b.unit_cd = a.unit_cd
4190: AND b.version_number = a.version_number

Line 4208: igs_he_st_unt_vs_all hunt

4204: SELECT SUM( NVL(override_enrolled_cp,NVL(cps.enrolled_credit_points,e.enrolled_credit_points))) Total_credit_points
4205: FROM igs_en_su_attempt a,
4206: igs_ps_unit_ver e,
4207: igs_ps_usec_cps cps,
4208: igs_he_st_unt_vs_all hunt
4209: WHERE a.course_cd = p_course_cd
4210: AND a.person_id = p_person_id
4211: AND a.unit_cd = hunt.unit_cd (+)
4212: AND a.version_number = hunt.version_number (+)

Line 4401: igs_he_st_unt_vs_all hunt

4397: SELECT SUM( NVL(override_enrolled_cp,NVL(cps.enrolled_credit_points,b.enrolled_credit_points)) ) credit_points, b.unit_level
4398: FROM igs_en_su_attempt a ,
4399: igs_ps_unit_ver b,
4400: igs_ps_usec_cps cps,
4401: igs_he_st_unt_vs_all hunt
4402: WHERE a.course_cd = p_course_cd
4403: AND a.person_id = p_person_id
4404: AND a.unit_cd = b.unit_cd
4405: AND a.version_number = b.version_number

Line 4515: p_unit_cd IN igs_he_st_unt_vs.unit_cd%TYPE,

4511: p_attendance_mode IN igs_he_poous.attendance_mode%TYPE,
4512: p_attendance_type IN igs_he_poous.attendance_type%TYPE,
4513: p_location_cd IN igs_he_poous.location_cd%TYPE,
4514: p_program_calc IN igs_he_st_prog.program_calc%TYPE,
4515: p_unit_cd IN igs_he_st_unt_vs.unit_cd%TYPE,
4516: p_uv_version_number IN igs_he_st_unt_vs.version_number%TYPE,
4517: p_return_type IN VARCHAR2,
4518: p_cost_ctr_rec IN OUT NOCOPY cc_rec,
4519: p_total_recs OUT NOCOPY NUMBER,

Line 4516: p_uv_version_number IN igs_he_st_unt_vs.version_number%TYPE,

4512: p_attendance_type IN igs_he_poous.attendance_type%TYPE,
4513: p_location_cd IN igs_he_poous.location_cd%TYPE,
4514: p_program_calc IN igs_he_st_prog.program_calc%TYPE,
4515: p_unit_cd IN igs_he_st_unt_vs.unit_cd%TYPE,
4516: p_uv_version_number IN igs_he_st_unt_vs.version_number%TYPE,
4517: p_return_type IN VARCHAR2,
4518: p_cost_ctr_rec IN OUT NOCOPY cc_rec,
4519: p_total_recs OUT NOCOPY NUMBER,
4520: p_enrl_start_dt IN DATE,

Line 4653: igs_he_st_unt_vs_all hunt

4649: SELECT 'X'
4650: FROM igs_he_unt_ou_cc a,
4651: igs_en_su_attempt_all b,
4652: igs_ps_tch_resp c,
4653: igs_he_st_unt_vs_all hunt
4654: WHERE b.course_cd = p_course_cd
4655: AND b.person_id = p_person_id
4656: AND a.unit_cd = b.unit_cd
4657: AND a.version_number = b.version_number

Line 4882: igs_he_st_unt_vs_all hunt

4878: SUM(proportion*percentage/100) proportion
4879: FROM igs_he_unt_ou_cc a,
4880: igs_en_su_attempt_all b,
4881: igs_ps_tch_resp c,
4882: igs_he_st_unt_vs_all hunt
4883: WHERE b.course_cd = p_course_cd
4884: AND b.person_id = p_person_id
4885: AND a.unit_cd = b.unit_cd
4886: AND a.version_number = b.version_number

Line 6135: igs_he_st_unt_vs_all d,

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
6139: AND c.person_id = a.person_id

Line 6157: igs_he_st_unt_vs_all d,

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
6161: AND a.version_number = b.version_number

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

6575: END get_mod_prop_fte;
6576:
6577:
6578: PROCEDURE get_mod_prop_not_taught
6579: (p_unit_cd IN igs_he_st_unt_vs.unit_cd%TYPE,
6580: p_version_number IN igs_he_st_unt_vs.version_number%TYPE,
6581: p_prop_not_taught OUT NOCOPY VARCHAR2)
6582:
6583: IS

Line 6580: p_version_number IN igs_he_st_unt_vs.version_number%TYPE,

6576:
6577:
6578: PROCEDURE get_mod_prop_not_taught
6579: (p_unit_cd IN igs_he_st_unt_vs.unit_cd%TYPE,
6580: p_version_number IN igs_he_st_unt_vs.version_number%TYPE,
6581: p_prop_not_taught OUT NOCOPY VARCHAR2)
6582:
6583: IS
6584: /***************************************************************

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

6627:
6628:
6629:
6630: PROCEDURE get_mod_oth_teach_inst
6631: (p_unit_cd IN igs_he_st_unt_vs.unit_cd%TYPE,
6632: p_version_number IN igs_he_st_unt_vs.version_number%TYPE,
6633: p_oth_teach_inst OUT NOCOPY VARCHAR2)
6634:
6635: IS

Line 6632: p_version_number IN igs_he_st_unt_vs.version_number%TYPE,

6628:
6629:
6630: PROCEDURE get_mod_oth_teach_inst
6631: (p_unit_cd IN igs_he_st_unt_vs.unit_cd%TYPE,
6632: p_version_number IN igs_he_st_unt_vs.version_number%TYPE,
6633: p_oth_teach_inst OUT NOCOPY VARCHAR2)
6634:
6635: IS
6636: /***************************************************************