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_FTE_CALC_PKG dependencies on IGS_CA_INST

Line 4: p_fte_start_dt igs_ca_inst.start_dt%TYPE ;

1: PACKAGE BODY igs_he_fte_calc_pkg AS
2: /* $Header: IGSHE21B.pls 120.8 2006/05/23 03:58:38 jtmathew ship $ */
3:
4: p_fte_start_dt igs_ca_inst.start_dt%TYPE ;
5: p_fte_end_dt igs_ca_inst.end_dt%TYPE ;
6: p_fte_cal_type igs_ca_inst.cal_type%TYPE ;
7: p_fte_sequence_number igs_ca_inst.sequence_number%TYPE ;
8:

Line 5: p_fte_end_dt igs_ca_inst.end_dt%TYPE ;

1: PACKAGE BODY igs_he_fte_calc_pkg AS
2: /* $Header: IGSHE21B.pls 120.8 2006/05/23 03:58:38 jtmathew ship $ */
3:
4: p_fte_start_dt igs_ca_inst.start_dt%TYPE ;
5: p_fte_end_dt igs_ca_inst.end_dt%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:

Line 6: p_fte_cal_type igs_ca_inst.cal_type%TYPE ;

2: /* $Header: IGSHE21B.pls 120.8 2006/05/23 03:58:38 jtmathew ship $ */
3:
4: p_fte_start_dt igs_ca_inst.start_dt%TYPE ;
5: p_fte_end_dt igs_ca_inst.end_dt%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 )

Line 7: p_fte_sequence_number igs_ca_inst.sequence_number%TYPE ;

3:
4: p_fte_start_dt igs_ca_inst.start_dt%TYPE ;
5: p_fte_end_dt igs_ca_inst.end_dt%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

Line 651: (cal_type igs_ca_inst.cal_type%TYPE,

647: TYPE ref_spa IS REF CURSOR;
648: c_ref_spa ref_spa;
649:
650: TYPE year_cal_type IS RECORD
651: (cal_type igs_ca_inst.cal_type%TYPE,
652: sequence_number igs_ca_inst.sequence_number%TYPE,
653: start_dt igs_ca_inst.start_dt%TYPE,
654: end_dt igs_ca_inst.end_dt%TYPE);
655: l_year_cal_rec year_cal_type;

Line 652: sequence_number igs_ca_inst.sequence_number%TYPE,

648: c_ref_spa ref_spa;
649:
650: TYPE year_cal_type IS RECORD
651: (cal_type igs_ca_inst.cal_type%TYPE,
652: sequence_number igs_ca_inst.sequence_number%TYPE,
653: start_dt igs_ca_inst.start_dt%TYPE,
654: end_dt igs_ca_inst.end_dt%TYPE);
655: l_year_cal_rec year_cal_type;
656:

Line 653: start_dt igs_ca_inst.start_dt%TYPE,

649:
650: TYPE year_cal_type IS RECORD
651: (cal_type igs_ca_inst.cal_type%TYPE,
652: sequence_number igs_ca_inst.sequence_number%TYPE,
653: start_dt igs_ca_inst.start_dt%TYPE,
654: end_dt igs_ca_inst.end_dt%TYPE);
655: l_year_cal_rec year_cal_type;
656:
657: -- get the start and end dates for the passed FTE calendar

Line 654: end_dt igs_ca_inst.end_dt%TYPE);

650: TYPE year_cal_type IS RECORD
651: (cal_type igs_ca_inst.cal_type%TYPE,
652: sequence_number igs_ca_inst.sequence_number%TYPE,
653: start_dt igs_ca_inst.start_dt%TYPE,
654: end_dt igs_ca_inst.end_dt%TYPE);
655: l_year_cal_rec year_cal_type;
656:
657: -- get the start and end dates for the passed FTE calendar
658: CURSOR c_fte_prd IS

Line 660: FROM igs_ca_inst ci

656:
657: -- get the start and end dates for the passed FTE calendar
658: CURSOR c_fte_prd IS
659: SELECT ci.start_dt , ci.end_dt
660: FROM igs_ca_inst ci
661: WHERE ci.cal_type = p_fte_cal_type AND
662: ci.sequence_number = p_fte_sequence_number ;
663:
664: -- check whether student has previously had an enrollment history

Line 799: FROM igs_ca_inst ci,

795: cp_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE,
796: cp_selection_dt_from igs_as_su_setatmpt.selection_dt%TYPE,
797: cp_selection_dt_to igs_as_su_setatmpt.selection_dt%TYPE) IS
798: SELECT ci.cal_type, ci.sequence_number, ci.start_dt, ci.end_dt
799: FROM igs_ca_inst ci,
800: igs_ca_type cat,
801: igs_ca_stat cs,
802: igs_en_stdnt_ps_att_all sca,
803: igs_as_su_setatmpt susa

Line 872: CURSOR c_fte_prop( cp_cal_type igs_ca_inst.cal_type%TYPE ,

868: c_susa_upd_rec c_susa_upd%ROWTYPE ;
869:
870: -- jtmathew modified for HE357 to avoid the selection of proportions that are closed
871: -- get the apportioned fte % for the current academic calendar
872: CURSOR c_fte_prop( cp_cal_type igs_ca_inst.cal_type%TYPE ,
873: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE ,
874: cp_acad_perd igs_ps_us_prenr_cfg.sequence_no%TYPE ) IS
875: SELECT fte_perc
876: FROM igs_he_fte_proprt

Line 873: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE ,

869:
870: -- jtmathew modified for HE357 to avoid the selection of proportions that are closed
871: -- get the apportioned fte % for the current academic calendar
872: CURSOR c_fte_prop( cp_cal_type igs_ca_inst.cal_type%TYPE ,
873: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE ,
874: cp_acad_perd igs_ps_us_prenr_cfg.sequence_no%TYPE ) IS
875: SELECT fte_perc
876: FROM igs_he_fte_proprt
877: WHERE cal_type = cp_cal_type AND

Line 933: FROM igs_he_fte_cal_prd fp , igs_ca_inst ci

929:
930: -- get the apportionment period setup at the fte calendar level
931: CURSOR c_fte_app IS
932: SELECT ci.start_dt , ci.end_dt
933: FROM igs_he_fte_cal_prd fp , igs_ca_inst ci
934: WHERE fp.teach_cal_type = ci.cal_type AND
935: fp.teach_sequence_num = ci.sequence_number AND
936: fp.fte_cal_type = p_fte_cal_type AND
937: fp.fte_sequence_num = p_fte_sequence_number ;

Line 941: CURSOR c_cal_inst(cp_cal_type igs_ca_inst.cal_type%TYPE ,

937: fp.fte_sequence_num = p_fte_sequence_number ;
938:
939:
940: -- get the start and end dates of the teaching calendar passed
941: CURSOR c_cal_inst(cp_cal_type igs_ca_inst.cal_type%TYPE ,
942: cp_sequence_number igs_ca_inst.sequence_number%TYPE ) IS
943: SELECT start_dt , end_dt
944: FROM igs_ca_inst
945: WHERE cal_type = cp_cal_type AND

Line 942: cp_sequence_number igs_ca_inst.sequence_number%TYPE ) IS

938:
939:
940: -- get the start and end dates of the teaching calendar passed
941: CURSOR c_cal_inst(cp_cal_type igs_ca_inst.cal_type%TYPE ,
942: cp_sequence_number igs_ca_inst.sequence_number%TYPE ) IS
943: SELECT start_dt , end_dt
944: FROM igs_ca_inst
945: WHERE cal_type = cp_cal_type AND
946: sequence_number = cp_sequence_number ;

Line 944: FROM igs_ca_inst

940: -- get the start and end dates of the teaching calendar passed
941: CURSOR c_cal_inst(cp_cal_type igs_ca_inst.cal_type%TYPE ,
942: cp_sequence_number igs_ca_inst.sequence_number%TYPE ) IS
943: SELECT start_dt , end_dt
944: FROM igs_ca_inst
945: WHERE cal_type = cp_cal_type AND
946: sequence_number = cp_sequence_number ;
947: c_cal_inst_rec c_cal_inst%ROWTYPE ;
948:

Line 971: FROM igs_en_spa_terms tr , igs_ca_inst_all ca

967: CURSOR c_term1_lev( cp_person_id igs_en_spa_terms.person_id%TYPE,
968: cp_course_cd igs_en_spa_terms.program_cd%TYPE,
969: cp_lev_dt DATE ) IS
970: SELECT tr.program_version , tr.coo_id
971: FROM igs_en_spa_terms tr , igs_ca_inst_all ca
972: WHERE tr.term_cal_type = ca.cal_type AND
973: tr.term_sequence_number = ca.sequence_number AND
974: tr.person_id = cp_person_id AND
975: tr.program_cd = cp_course_cd AND

Line 985: FROM igs_en_spa_terms tr , igs_ca_inst_all ca

981: CURSOR c_term2_lev( cp_person_id igs_en_spa_terms.person_id%TYPE,
982: cp_course_cd igs_en_spa_terms.program_cd%TYPE,
983: cp_lev_dt DATE ) IS
984: SELECT tr.program_version , tr.coo_id
985: FROM igs_en_spa_terms tr , igs_ca_inst_all ca
986: WHERE tr.term_cal_type = ca.cal_type AND
987: tr.term_sequence_number = ca.sequence_number AND
988: tr.person_id = cp_person_id AND
989: tr.program_cd = cp_course_cd AND

Line 999: FROM igs_en_spa_terms tr , igs_ca_inst_all ca

995: -- Get the latest term record for the Continuing students
996: CURSOR c_term_con ( cp_person_id igs_en_spa_terms.person_id%TYPE,
997: cp_course_cd igs_en_spa_terms.program_cd%TYPE) IS
998: SELECT tr.program_version , tr.coo_id
999: FROM igs_en_spa_terms tr , igs_ca_inst_all ca
1000: WHERE tr.term_cal_type = ca.cal_type AND
1001: tr.term_sequence_number = ca.sequence_number AND
1002: tr.person_id = cp_person_id AND
1003: tr.program_cd = cp_course_cd AND