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.

[Home] [Help]

APPS.IGS_HE_FTE_CALC_PKG dependencies on IGS_PS_VER_ALL

Line 10: FUNCTION research_st ( p_course_cd igs_ps_ver_all.course_cd%TYPE , p_version_number igs_ps_ver_all.version_number%TYPE )

6: p_fte_cal_type igs_ca_inst.cal_type%TYPE ;
7: p_fte_sequence_number igs_ca_inst.sequence_number%TYPE ;
8:
9:
10: FUNCTION research_st ( p_course_cd igs_ps_ver_all.course_cd%TYPE , p_version_number igs_ps_ver_all.version_number%TYPE )
11: RETURN BOOLEAN AS
12: /*************************************************************
13: Created By : smaddali
14: Date Created By : 15-APR-2002

Line 28: FROM igs_ps_type_all pt, igs_ps_ver_all cv

24:
25: --find if the passed program attempt has a candidacy details record
26: CURSOR c_res_st IS
27: SELECT 'Y'
28: FROM igs_ps_type_all pt, igs_ps_ver_all cv
29: WHERE cv.course_cd = p_course_cd AND
30: cv.version_number = p_version_number AND
31: cv.course_type = pt.course_type AND
32: pt.research_type_ind = 'Y' AND

Line 78: l_course_cd igs_ps_ver_all.course_cd%TYPE ;

74:
75: l_coo_type VARCHAR2(2) ;
76: l_oss_mode igs_he_poous_all.mode_of_study%TYPE ;
77: l_hesa_mode igs_he_code_map_val.map1%TYPE ;
78: l_course_cd igs_ps_ver_all.course_cd%TYPE ;
79: l_version_number igs_ps_ver_all.version_number%TYPE ;
80: l_cal_type igs_ps_ofr_opt_all.cal_type%TYPE ;
81: l_location_cd igs_ps_ofr_opt_all.location_cd%TYPE ;
82: l_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE ;

Line 79: l_version_number igs_ps_ver_all.version_number%TYPE ;

75: l_coo_type VARCHAR2(2) ;
76: l_oss_mode igs_he_poous_all.mode_of_study%TYPE ;
77: l_hesa_mode igs_he_code_map_val.map1%TYPE ;
78: l_course_cd igs_ps_ver_all.course_cd%TYPE ;
79: l_version_number igs_ps_ver_all.version_number%TYPE ;
80: l_cal_type igs_ps_ofr_opt_all.cal_type%TYPE ;
81: l_location_cd igs_ps_ofr_opt_all.location_cd%TYPE ;
82: l_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE ;
83: l_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE ;

Line 829: FROM igs_ps_ver_all

825: -- get the standard annual load for the program
826: CURSOR c_ann_load (cp_course_cd igs_ps_ver.course_cd%TYPE ,
827: cp_version_number igs_ps_ver.version_number%TYPE ) IS
828: SELECT std_annual_load
829: FROM igs_ps_ver_all
830: WHERE course_cd = cp_course_cd AND
831: version_number = cp_version_number ;
832:
833: -- get the current year of program for the passed program attempt which has

Line 905: CURSOR c_prog_app(cp_course_cd igs_ps_ver_all.course_cd%TYPE ,

901:
902: c_intm_part_rec c_intm_part%ROWTYPE ;
903:
904: -- get the apportionment period set up at the program level
905: CURSOR c_prog_app(cp_course_cd igs_ps_ver_all.course_cd%TYPE ,
906: cp_version_number igs_ps_ver_all.version_number%TYPE ) IS
907: SELECT teach_period_start_dt , teach_period_end_dt
908: FROM igs_he_st_prog_all prog
909: WHERE prog.course_cd = cp_course_cd AND

Line 906: cp_version_number igs_ps_ver_all.version_number%TYPE ) IS

902: c_intm_part_rec c_intm_part%ROWTYPE ;
903:
904: -- get the apportionment period set up at the program level
905: CURSOR c_prog_app(cp_course_cd igs_ps_ver_all.course_cd%TYPE ,
906: cp_version_number igs_ps_ver_all.version_number%TYPE ) IS
907: SELECT teach_period_start_dt , teach_period_end_dt
908: FROM igs_he_st_prog_all prog
909: WHERE prog.course_cd = cp_course_cd AND
910: prog.version_number = cp_version_number ;

Line 1010: CURSOR c_prg_cat ( cp_course_cd igs_ps_ver_all.course_cd%TYPE,

1006: c_term_con_rec c_term_con%ROWTYPE ;
1007: l_lev_dt igs_en_stdnt_ps_att_all.discontinued_dt%TYPE ;
1008:
1009: -- Check if the passed course version belongs to the course category parameter
1010: CURSOR c_prg_cat ( cp_course_cd igs_ps_ver_all.course_cd%TYPE,
1011: cp_version_number igs_ps_ver_all.version_number%TYPE ) IS
1012: SELECT course_cd,version_number
1013: FROM igs_ps_categorise_all ct where
1014: ct.course_cd = cp_course_cd AND

Line 1011: cp_version_number igs_ps_ver_all.version_number%TYPE ) IS

1007: l_lev_dt igs_en_stdnt_ps_att_all.discontinued_dt%TYPE ;
1008:
1009: -- Check if the passed course version belongs to the course category parameter
1010: CURSOR c_prg_cat ( cp_course_cd igs_ps_ver_all.course_cd%TYPE,
1011: cp_version_number igs_ps_ver_all.version_number%TYPE ) IS
1012: SELECT course_cd,version_number
1013: FROM igs_ps_categorise_all ct where
1014: ct.course_cd = cp_course_cd AND
1015: ct.version_number = cp_version_number AND