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

Line 653: v_acad_cal_type igs_ca_inst.cal_type%TYPE;

649: v_gs_version_number igs_as_grd_sch_grade.version_number%TYPE;
650: v_grade igs_as_grd_sch_grade.grade%TYPE;
651: v_dummy VARCHAR2 (1);
652: v_result_type igs_as_grd_sch_grade.s_result_type%TYPE;
653: v_acad_cal_type igs_ca_inst.cal_type%TYPE;
654: v_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
655: v_acad_start_dt igs_ca_inst.start_dt%TYPE;
656: v_acad_end_dt igs_ca_inst.end_dt%TYPE;
657: v_effect_enr_strt_dt_alias igs_en_cal_conf.effect_enr_strt_dt_alias%TYPE;

Line 654: v_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

650: v_grade igs_as_grd_sch_grade.grade%TYPE;
651: v_dummy VARCHAR2 (1);
652: v_result_type igs_as_grd_sch_grade.s_result_type%TYPE;
653: v_acad_cal_type igs_ca_inst.cal_type%TYPE;
654: v_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
655: v_acad_start_dt igs_ca_inst.start_dt%TYPE;
656: v_acad_end_dt igs_ca_inst.end_dt%TYPE;
657: v_effect_enr_strt_dt_alias igs_en_cal_conf.effect_enr_strt_dt_alias%TYPE;
658: v_effective_dt DATE;

Line 655: v_acad_start_dt igs_ca_inst.start_dt%TYPE;

651: v_dummy VARCHAR2 (1);
652: v_result_type igs_as_grd_sch_grade.s_result_type%TYPE;
653: v_acad_cal_type igs_ca_inst.cal_type%TYPE;
654: v_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
655: v_acad_start_dt igs_ca_inst.start_dt%TYPE;
656: v_acad_end_dt igs_ca_inst.end_dt%TYPE;
657: v_effect_enr_strt_dt_alias igs_en_cal_conf.effect_enr_strt_dt_alias%TYPE;
658: v_effective_dt DATE;
659: v_alt_code igs_ca_inst.alternate_code%TYPE;

Line 656: v_acad_end_dt igs_ca_inst.end_dt%TYPE;

652: v_result_type igs_as_grd_sch_grade.s_result_type%TYPE;
653: v_acad_cal_type igs_ca_inst.cal_type%TYPE;
654: v_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
655: v_acad_start_dt igs_ca_inst.start_dt%TYPE;
656: v_acad_end_dt igs_ca_inst.end_dt%TYPE;
657: v_effect_enr_strt_dt_alias igs_en_cal_conf.effect_enr_strt_dt_alias%TYPE;
658: v_effective_dt DATE;
659: v_alt_code igs_ca_inst.alternate_code%TYPE;
660: v_message_name VARCHAR2 (30);

Line 659: v_alt_code igs_ca_inst.alternate_code%TYPE;

655: v_acad_start_dt igs_ca_inst.start_dt%TYPE;
656: v_acad_end_dt igs_ca_inst.end_dt%TYPE;
657: v_effect_enr_strt_dt_alias igs_en_cal_conf.effect_enr_strt_dt_alias%TYPE;
658: v_effective_dt DATE;
659: v_alt_code igs_ca_inst.alternate_code%TYPE;
660: v_message_name VARCHAR2 (30);
661: cst_enrolled CONSTANT VARCHAR2 (15) := 'ENROLLED';
662: cst_active CONSTANT VARCHAR2 (15) := 'ACTIVE';
663: CURSOR c_aus IS

Line 697: CURSOR c_ci (cp_acad_cal_type igs_ca_inst.cal_type%TYPE, cp_acad_ci_seq_no igs_ca_inst.sequence_number%TYPE) IS

693: SELECT 'x'
694: FROM igs_ps_unit_category uc
695: WHERE uc.unit_cd = p_unit_cd
696: AND uc.unit_cat = p_exclude_unit_category;
697: CURSOR c_ci (cp_acad_cal_type igs_ca_inst.cal_type%TYPE, cp_acad_ci_seq_no igs_ca_inst.sequence_number%TYPE) IS
698: SELECT 'x'
699: FROM igs_ca_inst ci,
700: igs_ca_stat cs
701: WHERE ci.cal_type = cp_acad_cal_type

Line 699: FROM igs_ca_inst ci,

695: WHERE uc.unit_cd = p_unit_cd
696: AND uc.unit_cat = p_exclude_unit_category;
697: CURSOR c_ci (cp_acad_cal_type igs_ca_inst.cal_type%TYPE, cp_acad_ci_seq_no igs_ca_inst.sequence_number%TYPE) IS
698: SELECT 'x'
699: FROM igs_ca_inst ci,
700: igs_ca_stat cs
701: WHERE ci.cal_type = cp_acad_cal_type
702: AND ci.sequence_number = cp_acad_ci_seq_no
703: AND ci.cal_status = cs.cal_status

Line 710: cp_acad_cal_type igs_ca_inst.cal_type%TYPE,

706: SELECT secc.effect_enr_strt_dt_alias
707: FROM igs_en_cal_conf secc
708: WHERE secc.s_control_num = 1;
709: CURSOR c_daiv (
710: cp_acad_cal_type igs_ca_inst.cal_type%TYPE,
711: cp_acad_ci_seq_no igs_ca_inst.sequence_number%TYPE,
712: cp_effect_dt_alias VARCHAR2
713: ) IS
714: SELECT igs_ca_gen_001.calp_set_alias_value (

Line 711: cp_acad_ci_seq_no igs_ca_inst.sequence_number%TYPE,

707: FROM igs_en_cal_conf secc
708: WHERE secc.s_control_num = 1;
709: CURSOR c_daiv (
710: cp_acad_cal_type igs_ca_inst.cal_type%TYPE,
711: cp_acad_ci_seq_no igs_ca_inst.sequence_number%TYPE,
712: cp_effect_dt_alias VARCHAR2
713: ) IS
714: SELECT igs_ca_gen_001.calp_set_alias_value (
715: absolute_val,