APPS.IGS_EN_GEN_009 dependencies on IGS_PS_PAT_STUDY_UNT

Line 750: FROM IGS_PS_PAT_STUDY_UNT posu

746: posp.acad_period_num >= cp_period_number AND
747: posp.acad_period_num < (cp_period_number
748: + cp_number_of_periods) AND
749: EXISTS (SELECT 'x'
750: FROM IGS_PS_PAT_STUDY_UNT posu
751: WHERE posp.sequence_number = posu.posp_sequence_number AND
752: posu.unit_cd IS NOT NULL)
753: ORDER BY posp.acad_period_num;
754: CURSOR c_ci (

Line 808: FROM IGS_PS_PAT_STUDY_UNT posu

804: posu.unit_location_cd,
805: posu.unit_class,
806: posu.core_ind
807:
808: FROM IGS_PS_PAT_STUDY_UNT posu
809: WHERE posu.posp_sequence_number = cp_sequence_number AND
810: unit_cd IS NOT NULL
811: AND (
812: ( NVL (core_ind,'N') = cp_core_only

Line 879: core_ind IGS_PS_PAT_STUDY_UNT.CORE_IND%TYPE );

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;
883: t_sub_params t_params_table;

Line 2664: l_core_ind igs_ps_pat_study_unt.core_ind%TYPE;

2660: susa.course_cd = pos.course_cd AND
2661: susa.student_confirmed_ind = 'Y' AND
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;

Line 2732: FROM igs_ps_pat_study_unt posu

2728: posp.acad_period_num >= cp_period_number AND
2729: posp.acad_period_num < (cp_period_number
2730: + cp_number_of_periods) AND
2731: EXISTS (SELECT 'x'
2732: FROM igs_ps_pat_study_unt posu
2733: WHERE posp.sequence_number = posu.posp_sequence_number AND
2734: posu.unit_cd IS NOT NULL)
2735: ORDER BY posp.acad_period_num;
2736:

Line 2741: FROM IGS_PS_PAT_STUDY_UNT posu

2737: CURSOR c_posu (
2738: cp_sequence_number igs_ps_pat_study_prd.sequence_number%TYPE,
2739: cp_unit_cd igs_ps_unit_ver.unit_cd%TYPE) IS
2740: SELECT core_ind
2741: FROM IGS_PS_PAT_STUDY_UNT posu
2742: WHERE posu.posp_sequence_number = cp_sequence_number
2743: AND posu.unit_cd = cp_unit_cd;
2744:
2745: l_dummy VARCHAR2(1);

Line 2748: l_core_ind igs_ps_pat_study_unt.core_ind%TYPE;

2744:
2745: l_dummy VARCHAR2(1);
2746: l_rec_exist BOOLEAN;
2747: l_period_number NUMBER;
2748: l_core_ind igs_ps_pat_study_unt.core_ind%TYPE;
2749:
2750: BEGIN
2751: -- Get the unit section details
2752:

Line 3098: l_core_ind igs_ps_pat_study_unt.core_ind%TYPE;

3094: susa.course_cd = p_src_program_cd AND
3095: susa.student_confirmed_ind = 'Y' AND
3096: susa.end_dt IS NULL);
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;

Line 3157: FROM igs_ps_pat_study_unt posu

3153: posp.acad_period_num >= cp_period_number AND
3154: posp.acad_period_num < (cp_period_number
3155: + cp_number_of_periods) AND
3156: EXISTS (SELECT 'x'
3157: FROM igs_ps_pat_study_unt posu
3158: WHERE posp.sequence_number = posu.posp_sequence_number AND
3159: posu.unit_cd IS NOT NULL)
3160: ORDER BY posp.acad_period_num;
3161:

Line 3166: FROM IGS_PS_PAT_STUDY_UNT posu

3162: CURSOR c_posu (
3163: cp_sequence_number igs_ps_pat_study_prd.sequence_number%TYPE,
3164: cp_unit_cd igs_ps_unit_ver.unit_cd%TYPE) IS
3165: SELECT core_ind
3166: FROM IGS_PS_PAT_STUDY_UNT posu
3167: WHERE posu.posp_sequence_number = cp_sequence_number
3168: AND posu.unit_cd = cp_unit_cd;
3169:
3170: l_dummy VARCHAR2(1);

Line 3173: l_core_ind igs_ps_pat_study_unt.core_ind%TYPE;

3169:
3170: l_dummy VARCHAR2(1);
3171: l_rec_exist BOOLEAN;
3172: l_period_number NUMBER;
3173: l_core_ind igs_ps_pat_study_unt.core_ind%TYPE;
3174:
3175: BEGIN
3176: -- Get the unit section details
3177: