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_PAT_OF_STUDY

Line 665: FROM IGS_PS_PAT_OF_STUDY pos

661: pos.always_pre_enrol_ind,
662: pos.number_of_periods,
663: pos.aprvd_ci_sequence_number ,
664: pos.acad_perd_unit_set
665: FROM IGS_PS_PAT_OF_STUDY pos
666: WHERE pos.course_cd = p_course_cd AND
667: pos.version_number = p_version_number AND
668: pos.cal_type = p_acad_cal_type AND
669: ((pos.location_cd IS NULL AND

Line 738: cp_sequence_number IGS_PS_PAT_OF_STUDY.sequence_number%TYPE,

734: sca.course_cd = p_course_cd AND
735: am.attendance_mode = sca.attendance_mode;
736: v_am_rec c_am%ROWTYPE;
737: CURSOR c_posp (
738: cp_sequence_number IGS_PS_PAT_OF_STUDY.sequence_number%TYPE,
739: cp_number_of_periods IGS_PS_PAT_OF_STUDY.number_of_periods%TYPE,
740: cp_period_number NUMBER) IS
741: SELECT posp.acad_period_num,
742: posp.teach_cal_type,

Line 739: cp_number_of_periods IGS_PS_PAT_OF_STUDY.number_of_periods%TYPE,

735: am.attendance_mode = sca.attendance_mode;
736: v_am_rec c_am%ROWTYPE;
737: CURSOR c_posp (
738: cp_sequence_number IGS_PS_PAT_OF_STUDY.sequence_number%TYPE,
739: cp_number_of_periods IGS_PS_PAT_OF_STUDY.number_of_periods%TYPE,
740: cp_period_number NUMBER) IS
741: SELECT posp.acad_period_num,
742: posp.teach_cal_type,
743: posp.sequence_number

Line 2571: FROM IGS_PS_PAT_OF_STUDY pos

2567: pos.always_pre_enrol_ind,
2568: pos.number_of_periods,
2569: pos.aprvd_ci_sequence_number ,
2570: pos.acad_perd_unit_set
2571: FROM IGS_PS_PAT_OF_STUDY pos
2572: WHERE pos.course_cd = p_program_cd AND
2573: pos.version_number = l_ps_att_dtls_rec.version_number AND
2574: pos.cal_type = l_acad_cal_type AND
2575: ((pos.location_cd IS NULL AND

Line 2650: CURSOR c_pos_unit_sets( cp_version_number igs_ps_pat_of_study.version_number%TYPE) IS

2646: susa.student_confirmed_ind = 'Y' AND
2647: susa.rqrmnts_complete_dt IS NULL AND
2648: susa.end_dt IS NULL;
2649:
2650: CURSOR c_pos_unit_sets( cp_version_number igs_ps_pat_of_study.version_number%TYPE) IS
2651: SELECT unit_set_cd
2652: FROM igs_ps_pat_of_study pos
2653: WHERE course_cd = p_program_cd AND
2654: version_number = cp_version_number AND

Line 2652: FROM igs_ps_pat_of_study pos

2648: susa.end_dt IS NULL;
2649:
2650: CURSOR c_pos_unit_sets( cp_version_number igs_ps_pat_of_study.version_number%TYPE) IS
2651: SELECT unit_set_cd
2652: FROM igs_ps_pat_of_study pos
2653: WHERE course_cd = p_program_cd AND
2654: version_number = cp_version_number AND
2655: cal_type = l_acad_cal_type AND
2656: unit_set_cd IN

Line 2670: FUNCTION get_core_indicator (p_acad_perd_unit_set igs_ps_pat_of_study.acad_perd_unit_set%TYPE,

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,
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

Line 2671: p_sequence_number igs_ps_pat_of_study.sequence_number%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,
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

Line 2672: p_number_of_periods igs_ps_pat_of_study.number_of_periods%TYPE,

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,
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

Line 2720: cp_sequence_number igs_ps_pat_of_study.sequence_number%TYPE,

2716: AND course_cd = p_program_cd
2717: AND unit_set_cd = p_unit_set_cd ;
2718:
2719: CURSOR c_posp (
2720: cp_sequence_number igs_ps_pat_of_study.sequence_number%TYPE,
2721: cp_number_of_periods igs_ps_pat_of_study.number_of_periods%TYPE,
2722: cp_period_number NUMBER) IS
2723: SELECT posp.acad_period_num,
2724: posp.teach_cal_type,

Line 2721: cp_number_of_periods igs_ps_pat_of_study.number_of_periods%TYPE,

2717: AND unit_set_cd = p_unit_set_cd ;
2718:
2719: CURSOR c_posp (
2720: cp_sequence_number igs_ps_pat_of_study.sequence_number%TYPE,
2721: cp_number_of_periods igs_ps_pat_of_study.number_of_periods%TYPE,
2722: cp_period_number NUMBER) IS
2723: SELECT posp.acad_period_num,
2724: posp.teach_cal_type,
2725: posp.sequence_number

Line 3005: FROM IGS_PS_PAT_OF_STUDY pos

3001: pos.always_pre_enrol_ind,
3002: pos.number_of_periods,
3003: pos.aprvd_ci_sequence_number ,
3004: pos.acad_perd_unit_set
3005: FROM IGS_PS_PAT_OF_STUDY pos
3006: WHERE pos.course_cd = p_dest_program_cd AND
3007: pos.version_number = l_ps_att_dtls_rec.version_number AND
3008: pos.cal_type = l_acad_cal_type AND
3009: ((pos.location_cd IS NULL AND

Line 3084: CURSOR c_pos_unit_sets( cp_version_number igs_ps_pat_of_study.version_number%TYPE) IS

3080: susa.student_confirmed_ind = 'Y' AND
3081: susa.rqrmnts_complete_dt IS NULL AND
3082: susa.end_dt IS NULL;
3083:
3084: CURSOR c_pos_unit_sets( cp_version_number igs_ps_pat_of_study.version_number%TYPE) IS
3085: SELECT unit_set_cd
3086: FROM igs_ps_pat_of_study pos
3087: WHERE course_cd = p_dest_program_cd AND
3088: version_number = cp_version_number AND

Line 3086: FROM igs_ps_pat_of_study pos

3082: susa.end_dt IS NULL;
3083:
3084: CURSOR c_pos_unit_sets( cp_version_number igs_ps_pat_of_study.version_number%TYPE) IS
3085: SELECT unit_set_cd
3086: FROM igs_ps_pat_of_study pos
3087: WHERE course_cd = p_dest_program_cd AND
3088: version_number = cp_version_number AND
3089: cal_type = l_acad_cal_type AND
3090: unit_set_cd IN

Line 3105: FUNCTION get_trn_core_indicator (p_acad_perd_unit_set igs_ps_pat_of_study.acad_perd_unit_set%TYPE,

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,
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

Line 3106: p_sequence_number igs_ps_pat_of_study.sequence_number%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,
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

Line 3107: p_number_of_periods igs_ps_pat_of_study.number_of_periods%TYPE,

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,
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

Line 3145: cp_sequence_number igs_ps_pat_of_study.sequence_number%TYPE,

3141: AND course_cd = p_src_program_cd
3142: AND unit_set_cd = p_unit_set_cd ;
3143:
3144: CURSOR c_posp (
3145: cp_sequence_number igs_ps_pat_of_study.sequence_number%TYPE,
3146: cp_number_of_periods igs_ps_pat_of_study.number_of_periods%TYPE,
3147: cp_period_number NUMBER) IS
3148: SELECT posp.acad_period_num,
3149: posp.teach_cal_type,

Line 3146: cp_number_of_periods igs_ps_pat_of_study.number_of_periods%TYPE,

3142: AND unit_set_cd = p_unit_set_cd ;
3143:
3144: CURSOR c_posp (
3145: cp_sequence_number igs_ps_pat_of_study.sequence_number%TYPE,
3146: cp_number_of_periods igs_ps_pat_of_study.number_of_periods%TYPE,
3147: cp_period_number NUMBER) IS
3148: SELECT posp.acad_period_num,
3149: posp.teach_cal_type,
3150: posp.sequence_number