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_AS_SU_SETATMPT

Line 658: CURSOR c_pos ( cp_unit_set_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE ) IS

654: FROM IGS_CA_INST aci
655: WHERE aci.cal_type = p_acad_cal_type AND
656: aci.sequence_number = p_acad_sequence_number;
657: v_aci_rec c_aci%ROWTYPE;
658: CURSOR c_pos ( cp_unit_set_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE ) IS
659: SELECT pos.cal_type,
660: pos.sequence_number,
661: pos.always_pre_enrol_ind,
662: pos.number_of_periods,

Line 708: CURSOR c_acad_us (cp_admin_unit_Set_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE) IS

704: TYPE t_two_pos IS TABLE OF c_pos%ROWTYPE INDEX BY BINARY_INTEGER;
705: vt_two_pos t_two_pos;
706: v_index BINARY_INTEGER;
707:
708: CURSOR c_acad_us (cp_admin_unit_Set_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE) IS
709: SELECT usm.stream_unit_set_Cd
710: FROM igs_en_unit_set_map usm,
711: igs_ps_us_prenr_cfg upc
712: WHERE upc.unit_set_cd = cp_admin_unit_set_cd

Line 716: CURSOR c_susa_exists (cp_stream_unit_Set_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE,

712: WHERE upc.unit_set_cd = cp_admin_unit_set_cd
713: AND usm.mapping_set_cd = upc.mapping_set_cd
714: AND usm.sequence_no = upc.sequence_no;
715:
716: CURSOR c_susa_exists (cp_stream_unit_Set_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE,
717: cp_person_id IGS_AS_SU_SETATMPT.PERSON_ID%TYPE,
718: cp_course_cd IGS_AS_SU_SETATMPT.COURSE_CD%TYPE) IS
719: SELECT 'X'
720: FROM igs_as_su_setatmpt susa

Line 717: cp_person_id IGS_AS_SU_SETATMPT.PERSON_ID%TYPE,

713: AND usm.mapping_set_cd = upc.mapping_set_cd
714: AND usm.sequence_no = upc.sequence_no;
715:
716: CURSOR c_susa_exists (cp_stream_unit_Set_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE,
717: cp_person_id IGS_AS_SU_SETATMPT.PERSON_ID%TYPE,
718: cp_course_cd IGS_AS_SU_SETATMPT.COURSE_CD%TYPE) IS
719: SELECT 'X'
720: FROM igs_as_su_setatmpt susa
721: WHERE susa.unit_set_cd = cp_stream_unit_set_cd

Line 718: cp_course_cd IGS_AS_SU_SETATMPT.COURSE_CD%TYPE) IS

714: AND usm.sequence_no = upc.sequence_no;
715:
716: CURSOR c_susa_exists (cp_stream_unit_Set_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE,
717: cp_person_id IGS_AS_SU_SETATMPT.PERSON_ID%TYPE,
718: cp_course_cd IGS_AS_SU_SETATMPT.COURSE_CD%TYPE) IS
719: SELECT 'X'
720: FROM igs_as_su_setatmpt susa
721: WHERE susa.unit_set_cd = cp_stream_unit_set_cd
722: AND susa.person_id = cp_person_id

Line 720: FROM igs_as_su_setatmpt susa

716: CURSOR c_susa_exists (cp_stream_unit_Set_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE,
717: cp_person_id IGS_AS_SU_SETATMPT.PERSON_ID%TYPE,
718: cp_course_cd IGS_AS_SU_SETATMPT.COURSE_CD%TYPE) IS
719: SELECT 'X'
720: FROM igs_as_su_setatmpt susa
721: WHERE susa.unit_set_cd = cp_stream_unit_set_cd
722: AND susa.person_id = cp_person_id
723: AND susa.course_cd = cp_course_cd
724: AND susa.end_dt IS NULL

Line 2564: CURSOR c_pos ( cp_unit_set_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE ) IS

2560: l_ps_att_dtls_rec c_ps_att_dtls%ROWTYPE;
2561: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
2562: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
2563:
2564: CURSOR c_pos ( cp_unit_set_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE ) IS
2565: SELECT pos.cal_type,
2566: pos.sequence_number,
2567: pos.always_pre_enrol_ind,
2568: pos.number_of_periods,

Line 2612: FROM igs_as_su_setatmpt susa ,

2608:
2609:
2610: CURSOR c_last_unit_set IS
2611: SELECT susa.unit_set_cd
2612: FROM igs_as_su_setatmpt susa ,
2613: igs_en_unit_set us ,
2614: igs_en_unit_set_cat usc
2615: WHERE susa.person_id = p_person_id AND
2616: susa.course_cd = p_program_cd AND

Line 2623: l_last_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE;

2619: susa.end_dt IS NULL AND
2620: susa.unit_set_cd = us.unit_set_cd AND
2621: us.unit_set_cat = usc.unit_set_cat AND
2622: usc.s_unit_set_cat = 'PRENRL_YR';
2623: l_last_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE;
2624:
2625: CURSOR c_map_unit_set( cp_person_id igs_as_su_setatmpt.person_id%TYPE,
2626: cp_course_cd igs_as_su_setatmpt.course_cd%TYPE,
2627: cp_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE) IS

Line 2625: CURSOR c_map_unit_set( cp_person_id igs_as_su_setatmpt.person_id%TYPE,

2621: us.unit_set_cat = usc.unit_set_cat AND
2622: usc.s_unit_set_cat = 'PRENRL_YR';
2623: l_last_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE;
2624:
2625: CURSOR c_map_unit_set( cp_person_id igs_as_su_setatmpt.person_id%TYPE,
2626: cp_course_cd igs_as_su_setatmpt.course_cd%TYPE,
2627: cp_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE) IS
2628: SELECT unit_set_cd
2629: FROM igs_as_su_setatmpt

Line 2626: cp_course_cd igs_as_su_setatmpt.course_cd%TYPE,

2622: usc.s_unit_set_cat = 'PRENRL_YR';
2623: l_last_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE;
2624:
2625: CURSOR c_map_unit_set( cp_person_id igs_as_su_setatmpt.person_id%TYPE,
2626: cp_course_cd igs_as_su_setatmpt.course_cd%TYPE,
2627: cp_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE) IS
2628: SELECT unit_set_cd
2629: FROM igs_as_su_setatmpt
2630: WHERE (

Line 2627: cp_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE) IS

2623: l_last_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE;
2624:
2625: CURSOR c_map_unit_set( cp_person_id igs_as_su_setatmpt.person_id%TYPE,
2626: cp_course_cd igs_as_su_setatmpt.course_cd%TYPE,
2627: cp_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE) IS
2628: SELECT unit_set_cd
2629: FROM igs_as_su_setatmpt
2630: WHERE (
2631: (unit_set_cd = cp_unit_set_cd) OR

Line 2629: FROM igs_as_su_setatmpt

2625: CURSOR c_map_unit_set( cp_person_id igs_as_su_setatmpt.person_id%TYPE,
2626: cp_course_cd igs_as_su_setatmpt.course_cd%TYPE,
2627: cp_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE) IS
2628: SELECT unit_set_cd
2629: FROM igs_as_su_setatmpt
2630: WHERE (
2631: (unit_set_cd = cp_unit_set_cd) OR
2632: (unit_set_cd IN (SELECT stream_unit_set_cd
2633: FROM igs_en_unit_set_map

Line 2643: FROM igs_as_su_setatmpt susa

2639: AND course_cd = cp_course_cd;
2640:
2641: CURSOR c_susa IS
2642: SELECT susa.unit_set_cd
2643: FROM igs_as_su_setatmpt susa
2644: WHERE susa.person_id = p_person_id AND
2645: susa.course_cd = p_program_cd AND
2646: susa.student_confirmed_ind = 'Y' AND
2647: susa.rqrmnts_complete_dt IS NULL AND

Line 2658: FROM igs_as_su_setatmpt susa

2654: version_number = cp_version_number AND
2655: cal_type = l_acad_cal_type AND
2656: unit_set_cd IN
2657: ( SELECT susa.unit_set_cd
2658: FROM igs_as_su_setatmpt susa
2659: WHERE susa.person_id = p_person_id AND
2660: susa.course_cd = pos.course_cd AND
2661: susa.student_confirmed_ind = 'Y' AND
2662: susa.end_dt IS NULL);

Line 2666: l_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE;

2662: susa.end_dt IS NULL);
2663:
2664: l_core_ind igs_ps_pat_study_unt.core_ind%TYPE;
2665: l_message VARCHAR2(100);
2666: l_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE;
2667: l_row_count NUMBER;
2668: l_pos_count NUMBER;
2669:
2670: FUNCTION get_core_indicator (p_acad_perd_unit_set igs_ps_pat_of_study.acad_perd_unit_set%TYPE,

Line 2673: p_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE)

2669:
2670: FUNCTION get_core_indicator (p_acad_perd_unit_set igs_ps_pat_of_study.acad_perd_unit_set%TYPE,
2671: p_sequence_number igs_ps_pat_of_study.sequence_number%TYPE,
2672: p_number_of_periods igs_ps_pat_of_study.number_of_periods%TYPE,
2673: p_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE)
2674: RETURN VARCHAR2
2675: IS
2676: CURSOR c_usec_details IS
2677: SELECT unit_cd,

Line 2693: CURSOR c_acad_us (cp_admin_unit_Set_cd igs_as_su_setatmpt.unit_set_cd%TYPE) IS

2689: WHERE aci.cal_type = l_acad_cal_type AND
2690: aci.sequence_number = l_acad_ci_sequence_number;
2691: l_aci_rec c_aci%ROWTYPE;
2692:
2693: CURSOR c_acad_us (cp_admin_unit_Set_cd igs_as_su_setatmpt.unit_set_cd%TYPE) IS
2694: SELECT usm.stream_unit_set_Cd
2695: FROM igs_en_unit_set_map usm,
2696: igs_ps_us_prenr_cfg upc
2697: WHERE upc.unit_set_cd = cp_admin_unit_set_cd

Line 2701: CURSOR c_susa_exists (cp_stream_unit_Set_cd igs_as_su_setatmpt.unit_set_cd%TYPE,

2697: WHERE upc.unit_set_cd = cp_admin_unit_set_cd
2698: AND usm.mapping_set_cd = upc.mapping_set_cd
2699: AND usm.sequence_no = upc.sequence_no;
2700:
2701: CURSOR c_susa_exists (cp_stream_unit_Set_cd igs_as_su_setatmpt.unit_set_cd%TYPE,
2702: cp_person_id igs_as_su_setatmpt.person_id%TYPE,
2703: cp_course_cd igs_as_su_setatmpt.course_cd%TYPE) IS
2704: SELECT 'X'
2705: FROM igs_as_su_setatmpt susa

Line 2702: cp_person_id igs_as_su_setatmpt.person_id%TYPE,

2698: AND usm.mapping_set_cd = upc.mapping_set_cd
2699: AND usm.sequence_no = upc.sequence_no;
2700:
2701: CURSOR c_susa_exists (cp_stream_unit_Set_cd igs_as_su_setatmpt.unit_set_cd%TYPE,
2702: cp_person_id igs_as_su_setatmpt.person_id%TYPE,
2703: cp_course_cd igs_as_su_setatmpt.course_cd%TYPE) IS
2704: SELECT 'X'
2705: FROM igs_as_su_setatmpt susa
2706: WHERE susa.unit_set_cd = cp_stream_unit_set_cd

Line 2703: cp_course_cd igs_as_su_setatmpt.course_cd%TYPE) IS

2699: AND usm.sequence_no = upc.sequence_no;
2700:
2701: CURSOR c_susa_exists (cp_stream_unit_Set_cd igs_as_su_setatmpt.unit_set_cd%TYPE,
2702: cp_person_id igs_as_su_setatmpt.person_id%TYPE,
2703: cp_course_cd igs_as_su_setatmpt.course_cd%TYPE) IS
2704: SELECT 'X'
2705: FROM igs_as_su_setatmpt susa
2706: WHERE susa.unit_set_cd = cp_stream_unit_set_cd
2707: AND susa.person_id = cp_person_id

Line 2705: FROM igs_as_su_setatmpt susa

2701: CURSOR c_susa_exists (cp_stream_unit_Set_cd igs_as_su_setatmpt.unit_set_cd%TYPE,
2702: cp_person_id igs_as_su_setatmpt.person_id%TYPE,
2703: cp_course_cd igs_as_su_setatmpt.course_cd%TYPE) IS
2704: SELECT 'X'
2705: FROM igs_as_su_setatmpt susa
2706: WHERE susa.unit_set_cd = cp_stream_unit_set_cd
2707: AND susa.person_id = cp_person_id
2708: AND susa.course_cd = cp_course_cd
2709: AND susa.end_dt IS NULL

Line 2998: CURSOR c_pos ( cp_unit_set_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE ) IS

2994: l_ps_att_dtls_rec c_ps_att_dtls%ROWTYPE;
2995: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
2996: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
2997:
2998: CURSOR c_pos ( cp_unit_set_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE ) IS
2999: SELECT pos.cal_type,
3000: pos.sequence_number,
3001: pos.always_pre_enrol_ind,
3002: pos.number_of_periods,

Line 3046: FROM igs_as_su_setatmpt susa ,

3042:
3043:
3044: CURSOR c_last_unit_set IS
3045: SELECT susa.unit_set_cd
3046: FROM igs_as_su_setatmpt susa ,
3047: igs_en_unit_set us ,
3048: igs_en_unit_set_cat usc
3049: WHERE susa.person_id = p_person_id AND
3050: susa.course_cd = p_src_program_cd AND

Line 3057: l_last_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE;

3053: susa.end_dt IS NULL AND
3054: susa.unit_set_cd = us.unit_set_cd AND
3055: us.unit_set_cat = usc.unit_set_cat AND
3056: usc.s_unit_set_cat = 'PRENRL_YR';
3057: l_last_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE;
3058:
3059: CURSOR c_map_unit_set( cp_person_id igs_as_su_setatmpt.person_id%TYPE,
3060: cp_course_cd igs_as_su_setatmpt.course_cd%TYPE,
3061: cp_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE) IS

Line 3059: CURSOR c_map_unit_set( cp_person_id igs_as_su_setatmpt.person_id%TYPE,

3055: us.unit_set_cat = usc.unit_set_cat AND
3056: usc.s_unit_set_cat = 'PRENRL_YR';
3057: l_last_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE;
3058:
3059: CURSOR c_map_unit_set( cp_person_id igs_as_su_setatmpt.person_id%TYPE,
3060: cp_course_cd igs_as_su_setatmpt.course_cd%TYPE,
3061: cp_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE) IS
3062: SELECT unit_set_cd
3063: FROM igs_as_su_setatmpt

Line 3060: cp_course_cd igs_as_su_setatmpt.course_cd%TYPE,

3056: usc.s_unit_set_cat = 'PRENRL_YR';
3057: l_last_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE;
3058:
3059: CURSOR c_map_unit_set( cp_person_id igs_as_su_setatmpt.person_id%TYPE,
3060: cp_course_cd igs_as_su_setatmpt.course_cd%TYPE,
3061: cp_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE) IS
3062: SELECT unit_set_cd
3063: FROM igs_as_su_setatmpt
3064: WHERE (

Line 3061: cp_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE) IS

3057: l_last_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE;
3058:
3059: CURSOR c_map_unit_set( cp_person_id igs_as_su_setatmpt.person_id%TYPE,
3060: cp_course_cd igs_as_su_setatmpt.course_cd%TYPE,
3061: cp_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE) IS
3062: SELECT unit_set_cd
3063: FROM igs_as_su_setatmpt
3064: WHERE (
3065: (unit_set_cd = cp_unit_set_cd) OR

Line 3063: FROM igs_as_su_setatmpt

3059: CURSOR c_map_unit_set( cp_person_id igs_as_su_setatmpt.person_id%TYPE,
3060: cp_course_cd igs_as_su_setatmpt.course_cd%TYPE,
3061: cp_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE) IS
3062: SELECT unit_set_cd
3063: FROM igs_as_su_setatmpt
3064: WHERE (
3065: (unit_set_cd = cp_unit_set_cd) OR
3066: (unit_set_cd IN (SELECT stream_unit_set_cd
3067: FROM igs_en_unit_set_map

Line 3077: FROM igs_as_su_setatmpt susa

3073: AND course_cd = cp_course_cd;
3074:
3075: CURSOR c_susa IS
3076: SELECT susa.unit_set_cd
3077: FROM igs_as_su_setatmpt susa
3078: WHERE susa.person_id = p_person_id AND
3079: susa.course_cd = p_src_program_cd AND
3080: susa.student_confirmed_ind = 'Y' AND
3081: susa.rqrmnts_complete_dt IS NULL AND

Line 3092: FROM igs_as_su_setatmpt susa

3088: version_number = cp_version_number AND
3089: cal_type = l_acad_cal_type AND
3090: unit_set_cd IN
3091: ( SELECT susa.unit_set_cd
3092: FROM igs_as_su_setatmpt susa
3093: WHERE susa.person_id = p_person_id AND
3094: susa.course_cd = p_src_program_cd AND
3095: susa.student_confirmed_ind = 'Y' AND
3096: susa.end_dt IS NULL);

Line 3101: l_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE;

3097:
3098: l_core_ind igs_ps_pat_study_unt.core_ind%TYPE;
3099: l_dest_core_ind IGS_EN_SU_ATTEMPT.CORE_INDICATOR_CODE%TYPE;
3100: l_message VARCHAR2(100);
3101: l_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE;
3102: l_row_count NUMBER;
3103: l_pos_count NUMBER;
3104:
3105: FUNCTION get_trn_core_indicator (p_acad_perd_unit_set igs_ps_pat_of_study.acad_perd_unit_set%TYPE,

Line 3108: p_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE)

3104:
3105: FUNCTION get_trn_core_indicator (p_acad_perd_unit_set igs_ps_pat_of_study.acad_perd_unit_set%TYPE,
3106: p_sequence_number igs_ps_pat_of_study.sequence_number%TYPE,
3107: p_number_of_periods igs_ps_pat_of_study.number_of_periods%TYPE,
3108: p_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE)
3109: RETURN VARCHAR2
3110: IS
3111: CURSOR c_usec_details IS
3112: SELECT unit_cd,

Line 3128: CURSOR c_acad_us (cp_admin_unit_Set_cd igs_as_su_setatmpt.unit_set_cd%TYPE) IS

3124: WHERE aci.cal_type = l_acad_cal_type AND
3125: aci.sequence_number = l_acad_ci_sequence_number;
3126: l_aci_rec c_aci%ROWTYPE;
3127:
3128: CURSOR c_acad_us (cp_admin_unit_Set_cd igs_as_su_setatmpt.unit_set_cd%TYPE) IS
3129: SELECT usm.stream_unit_set_Cd
3130: FROM igs_en_unit_set_map usm,
3131: igs_ps_us_prenr_cfg upc
3132: WHERE upc.unit_set_cd = cp_admin_unit_set_cd