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_EN_GEN_009 dependencies on IGS_PS_UNIT_OFR_OPT

Line 830: CURSOR c_uoo_status(p_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS

826: AND course_cd = p_course_cd
827: AND unit_set_cd = p_unit_set_cd ;
828: -- end of changes by smaddali
829:
830: CURSOR c_uoo_status(p_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS
831: SELECT DECODE(sua.unit_attempt_status, 'UNCONFIRM', 'N', 'WAITLISTED', 'Y' , NULL)
832: FROM IGS_EN_SU_ATTEMPT sua
833: WHERE sua.person_id = p_person_id AND
834: sua.course_cd = p_course_cd AND

Line 837: CURSOR c_rel_type(p_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS

833: WHERE sua.person_id = p_person_id AND
834: sua.course_cd = p_course_cd AND
835: sua.uoo_id = p_uoo_id;
836:
837: CURSOR c_rel_type(p_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS
838: SELECT relation_type
839: FROM IGS_PS_UNIT_OFR_OPT
840: WHERE uoo_id = p_uoo_id;
841:

Line 839: FROM IGS_PS_UNIT_OFR_OPT

835: sua.uoo_id = p_uoo_id;
836:
837: CURSOR c_rel_type(p_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS
838: SELECT relation_type
839: FROM IGS_PS_UNIT_OFR_OPT
840: WHERE uoo_id = p_uoo_id;
841:
842: v_posu_rec c_posu%ROWTYPE;
843: v_attendance_mode VARCHAR2(3) ;

Line 848: v_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;

844: v_period_number NUMBER(2) := 0;
845: v_warn_level VARCHAR2(5) ;
846: vp_warn_level VARCHAR2(5) ;
847: v_message_name VARCHAR2(2000) ;
848: v_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;
849: v_last_acad_start_dt IGS_CA_INST.start_dt%TYPE;
850: v_last_acad_period_num NUMBER(2) := 0;
851: v_ci_start_dt DATE;
852: v_ci_end_dt DATE;

Line 870: l_rel_type IGS_PS_UNIT_OFR_OPT.relation_type%TYPE;

866: l_rec_exist BOOLEAN;
867: l_core_indicator_code IGS_EN_SU_ATTEMPT.core_indicator_code%TYPE;
868:
869: l_waitlist_flag VARCHAR2(1) := NULL;
870: l_rel_type IGS_PS_UNIT_OFR_OPT.relation_type%TYPE;
871: l_enr_uoo_ids VARCHAR2(2000);
872: l_out_uoo_ids VARCHAR2(2000);
873: l_waitlist_uoo_ids VARCHAR2(2000);
874: l_failed_uoo_ids VARCHAR2(2000);

Line 878: uoo_id IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE,

874: l_failed_uoo_ids VARCHAR2(2000);
875: l_unit_cds VARCHAR2(2000);
876:
877: TYPE l_params_rec IS RECORD (
878: uoo_id IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE,
879: core_ind IGS_PS_PAT_STUDY_UNT.CORE_IND%TYPE );
880:
881: TYPE t_params_table IS TABLE OF l_params_rec INDEX BY BINARY_INTEGER;
882: t_sup_params t_params_table;

Line 890: l_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE;

886: v_sup_index BINARY_INTEGER := 1;
887: v_sub_index BINARY_INTEGER := 1;
888: v_ord_index BINARY_INTEGER := 1;
889: v_all_index BINARY_INTEGER := 1;
890: l_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE;
891: l_seq_num IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE;
892: l_uoo_Id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;
893:
894: CURSOR cur_teach_cal(p_uoo_Id igs_ps_unit_ofr_opt.uoo_Id%TYPE) IS

Line 891: l_seq_num IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE;

887: v_sub_index BINARY_INTEGER := 1;
888: v_ord_index BINARY_INTEGER := 1;
889: v_all_index BINARY_INTEGER := 1;
890: l_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE;
891: l_seq_num IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE;
892: l_uoo_Id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;
893:
894: CURSOR cur_teach_cal(p_uoo_Id igs_ps_unit_ofr_opt.uoo_Id%TYPE) IS
895: SELECT cal_type, ci_sequence_number

Line 892: l_uoo_Id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;

888: v_ord_index BINARY_INTEGER := 1;
889: v_all_index BINARY_INTEGER := 1;
890: l_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE;
891: l_seq_num IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE;
892: l_uoo_Id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;
893:
894: CURSOR cur_teach_cal(p_uoo_Id igs_ps_unit_ofr_opt.uoo_Id%TYPE) IS
895: SELECT cal_type, ci_sequence_number
896: FROM igs_ps_unit_ofr_opt

Line 894: CURSOR cur_teach_cal(p_uoo_Id igs_ps_unit_ofr_opt.uoo_Id%TYPE) IS

890: l_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE;
891: l_seq_num IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE;
892: l_uoo_Id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;
893:
894: CURSOR cur_teach_cal(p_uoo_Id igs_ps_unit_ofr_opt.uoo_Id%TYPE) IS
895: SELECT cal_type, ci_sequence_number
896: FROM igs_ps_unit_ofr_opt
897: WHERE uoo_id = p_uoo_id;
898:

Line 896: FROM igs_ps_unit_ofr_opt

892: l_uoo_Id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;
893:
894: CURSOR cur_teach_cal(p_uoo_Id igs_ps_unit_ofr_opt.uoo_Id%TYPE) IS
895: SELECT cal_type, ci_sequence_number
896: FROM igs_ps_unit_ofr_opt
897: WHERE uoo_id = p_uoo_id;
898:
899:
900: BEGIN

Line 2679: FROM igs_ps_unit_ofr_opt

2675: IS
2676: CURSOR c_usec_details IS
2677: SELECT unit_cd,
2678: cal_type
2679: FROM igs_ps_unit_ofr_opt
2680: WHERE uoo_id = p_uoo_id;
2681: l_usec_details_rec c_usec_details%ROWTYPE;
2682:
2683: CURSOR c_aci IS

Line 3114: FROM igs_ps_unit_ofr_opt

3110: IS
3111: CURSOR c_usec_details IS
3112: SELECT unit_cd,
3113: cal_type
3114: FROM igs_ps_unit_ofr_opt
3115: WHERE uoo_id = p_uoo_id;
3116: l_usec_details_rec c_usec_details%ROWTYPE;
3117:
3118: CURSOR c_aci IS