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.

[Home] [Help]

APPS.IGS_EN_VAL_SUA dependencies on IGS_PS_UNIT_VER

Line 37: -- rvivekan 09-sep-2003 Modified the behaviour of repeatable_ind column in igs_ps_unit_ver table. PSP integration build #3052433

33: -- for discontinuation which was initially returning NULL as part of Bug# 3036433
34: -- amuthu 07-JUL-2003 Added logic to check if the program attempt status is not Unconfirm/discontin
35: -- when the unit attempt status is enrolled or invalid.
36: -- amuthu 04-AUG-2003 Bypassed the discontinuation validation for a dropped unit attempt in enrp_val_sua_discont
37: -- rvivekan 09-sep-2003 Modified the behaviour of repeatable_ind column in igs_ps_unit_ver table. PSP integration build #3052433
38: --svanukur 18-oct-2003 created procedures enr_sub_units and drop_sub_units as part of placements build 3052438
39: --rvivekan 17-nov-2003 Bug3264064. Changed the datatype of variables holding the concatenated administrative unit status list
40: -- to varchar(2000) in enrp_val_discont_aus
41: --ptandon 29-Dec-2003 Removed the exception handling sections of enrp_val_sua_cnfrm, enrp_val_sua_insert,

Line 93: FROM IGS_PS_UNIT_VER uv

89: v_teach_start_dt DATE;
90: v_check_dt DATE;
91: CURSOR c_uv IS
92: SELECT 'x'
93: FROM IGS_PS_UNIT_VER uv
94: WHERE uv.unit_cd = p_unit_cd AND
95: uv.version_number = p_version_number AND
96: uv.research_unit_ind <> 'N';
97: v_uv_exists VARCHAR2(1);

Line 392: IGS_PS_UNIT_VER_ALL uv1,

388: loadcal.sequence_number ci_sequence_number
389: FROM
390: IGS_EN_SU_ATTEMPT_all sua1,
391: IGS_EN_SU_ATTEMPT_all sua2 ,
392: IGS_PS_UNIT_VER_ALL uv1,
393: IGS_PS_UNIT_VER_ALL uv2,
394: IGS_CA_INST_ALL loadcal,
395: IGS_CA_INST_REL acadterm,
396: IGS_CA_TYPE cat2,

Line 393: IGS_PS_UNIT_VER_ALL uv2,

389: FROM
390: IGS_EN_SU_ATTEMPT_all sua1,
391: IGS_EN_SU_ATTEMPT_all sua2 ,
392: IGS_PS_UNIT_VER_ALL uv1,
393: IGS_PS_UNIT_VER_ALL uv2,
394: IGS_CA_INST_ALL loadcal,
395: IGS_CA_INST_REL acadterm,
396: IGS_CA_TYPE cat2,
397: IGS_CA_STAT cs2 ,

Line 930: v_title_override_ind IGS_PS_UNIT_VER.title_override_ind%TYPE;

926:
927: BEGIN -- enrp_val_sua_alt_ttl
928: -- validate the student unit attempt alternative title.
929: DECLARE
930: v_title_override_ind IGS_PS_UNIT_VER.title_override_ind%TYPE;
931: CURSOR c_uv IS
932: SELECT title_override_ind
933: FROM IGS_PS_UNIT_VER uv
934: WHERE uv.unit_cd = p_unit_cd AND

Line 933: FROM IGS_PS_UNIT_VER uv

929: DECLARE
930: v_title_override_ind IGS_PS_UNIT_VER.title_override_ind%TYPE;
931: CURSOR c_uv IS
932: SELECT title_override_ind
933: FROM IGS_PS_UNIT_VER uv
934: WHERE uv.unit_cd = p_unit_cd AND
935: uv.version_number = p_version_number;
936: BEGIN
937: p_message_name := null;

Line 1093: --rvivekan 09-sep-2003 Modified the behaviour of repeatable_ind column in igs_ps_unit_ver table. PSP integration build #3052433

1089: -------------------------------------------------------------------------------------------
1090: --Change History:
1091: --Who When What
1092: --kkillams 10-JUL-2003 Returning error message only if repeatable_ind is 'N' w.r.t. 3036367
1093: --rvivekan 09-sep-2003 Modified the behaviour of repeatable_ind column in igs_ps_unit_ver table. PSP integration build #3052433
1094: --rvivekan 24-SEP-2006 Removed p_legacy check for the granted advanced standing validation Bug#3132543
1095: -------------------------------------------------------------------------------------------
1096: RETURN BOOLEAN AS
1097: BEGIN

Line 1109: v_repeatable_ind IGS_PS_UNIT_VER.repeatable_ind%TYPE;

1105: v_total_exmptn_granted IGS_AV_ADV_STANDING.total_exmptn_granted%TYPE;
1106: v_total_exmptn_perc_grntd IGS_AV_ADV_STANDING.total_exmptn_perc_grntd%TYPE;
1107: v_message_name varchar2(30);
1108: v_crs_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
1109: v_repeatable_ind IGS_PS_UNIT_VER.repeatable_ind%TYPE;
1110: CURSOR c_sca(
1111: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1112: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
1113: SELECT sca.version_number

Line 1135: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,

1131: cst_preclusion) AND
1132: asu.s_adv_stnd_granting_status IN (cst_approved, cst_granted)
1133: GROUP BY unit_cd,version_number,s_adv_stnd_recognition_type;
1134: CURSOR c_unit_version(
1135: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
1136: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS
1137: SELECT repeatable_ind
1138: FROM IGS_PS_UNIT_VER uv
1139: WHERE uv.unit_cd = cp_unit_cd AND

Line 1136: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS

1132: asu.s_adv_stnd_granting_status IN (cst_approved, cst_granted)
1133: GROUP BY unit_cd,version_number,s_adv_stnd_recognition_type;
1134: CURSOR c_unit_version(
1135: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
1136: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS
1137: SELECT repeatable_ind
1138: FROM IGS_PS_UNIT_VER uv
1139: WHERE uv.unit_cd = cp_unit_cd AND
1140: uv.version_number = cp_version_number;

Line 1138: FROM IGS_PS_UNIT_VER uv

1134: CURSOR c_unit_version(
1135: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
1136: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS
1137: SELECT repeatable_ind
1138: FROM IGS_PS_UNIT_VER uv
1139: WHERE uv.unit_cd = cp_unit_cd AND
1140: uv.version_number = cp_version_number;
1141: l_credits NUMBER;
1142: l_s_adv_atnd_granting_status igs_av_stnd_unit_all.s_adv_stnd_granting_status%TYPE;

Line 1892: FROM IGS_PS_UNIT_VER uv,

1888: FROM IGS_AD_ADM_UNIT_STAT
1889: WHERE administrative_unit_status = p_administrative_unit_status;
1890: CURSOR c_uvus IS
1891: SELECT us.s_unit_status
1892: FROM IGS_PS_UNIT_VER uv,
1893: IGS_PS_UNIT_STAT us
1894: WHERE uv.unit_cd = p_unit_cd AND
1895: uv.version_number = p_version_number AND
1896: us.unit_status = uv.unit_status;

Line 2846: -- constraints set in the IGS_PS_UNIT_VER table.

2842: RETURN BOOLEAN AS
2843:
2844: BEGIN -- enrp_val_sua_ovrd_cp
2845: -- Validate the override credit point and EFTSU values against the
2846: -- constraints set in the IGS_PS_UNIT_VER table.
2847: DECLARE
2848: v_points_override_ind IGS_PS_UNIT_VER.points_override_ind%TYPE;
2849: v_points_min IGS_PS_UNIT_VER.points_min%TYPE;
2850: v_points_max IGS_PS_UNIT_VER.points_max%TYPE;

Line 2848: v_points_override_ind IGS_PS_UNIT_VER.points_override_ind%TYPE;

2844: BEGIN -- enrp_val_sua_ovrd_cp
2845: -- Validate the override credit point and EFTSU values against the
2846: -- constraints set in the IGS_PS_UNIT_VER table.
2847: DECLARE
2848: v_points_override_ind IGS_PS_UNIT_VER.points_override_ind%TYPE;
2849: v_points_min IGS_PS_UNIT_VER.points_min%TYPE;
2850: v_points_max IGS_PS_UNIT_VER.points_max%TYPE;
2851: v_points_increment IGS_PS_UNIT_VER.points_increment%TYPE;
2852: CURSOR c_uv IS

Line 2849: v_points_min IGS_PS_UNIT_VER.points_min%TYPE;

2845: -- Validate the override credit point and EFTSU values against the
2846: -- constraints set in the IGS_PS_UNIT_VER table.
2847: DECLARE
2848: v_points_override_ind IGS_PS_UNIT_VER.points_override_ind%TYPE;
2849: v_points_min IGS_PS_UNIT_VER.points_min%TYPE;
2850: v_points_max IGS_PS_UNIT_VER.points_max%TYPE;
2851: v_points_increment IGS_PS_UNIT_VER.points_increment%TYPE;
2852: CURSOR c_uv IS
2853: SELECT uv.points_override_ind,

Line 2850: v_points_max IGS_PS_UNIT_VER.points_max%TYPE;

2846: -- constraints set in the IGS_PS_UNIT_VER table.
2847: DECLARE
2848: v_points_override_ind IGS_PS_UNIT_VER.points_override_ind%TYPE;
2849: v_points_min IGS_PS_UNIT_VER.points_min%TYPE;
2850: v_points_max IGS_PS_UNIT_VER.points_max%TYPE;
2851: v_points_increment IGS_PS_UNIT_VER.points_increment%TYPE;
2852: CURSOR c_uv IS
2853: SELECT uv.points_override_ind,
2854: uv.points_min,

Line 2851: v_points_increment IGS_PS_UNIT_VER.points_increment%TYPE;

2847: DECLARE
2848: v_points_override_ind IGS_PS_UNIT_VER.points_override_ind%TYPE;
2849: v_points_min IGS_PS_UNIT_VER.points_min%TYPE;
2850: v_points_max IGS_PS_UNIT_VER.points_max%TYPE;
2851: v_points_increment IGS_PS_UNIT_VER.points_increment%TYPE;
2852: CURSOR c_uv IS
2853: SELECT uv.points_override_ind,
2854: uv.points_min,
2855: uv.points_max,

Line 2857: FROM IGS_PS_UNIT_VER uv

2853: SELECT uv.points_override_ind,
2854: uv.points_min,
2855: uv.points_max,
2856: uv.points_increment
2857: FROM IGS_PS_UNIT_VER uv
2858: WHERE unit_cd = p_unit_cd AND
2859: version_number = p_version_number;
2860: --New cursor is added w.r.t. bug 2375757 by kkillams
2861: --To get the details override credit points at unit section level

Line 2991: FROM IGS_PS_UNIT_VER,

2987: BEGIN
2988: DECLARE
2989: CURSOR c_get_uv_status IS
2990: SELECT IGS_PS_UNIT_STAT.s_unit_status
2991: FROM IGS_PS_UNIT_VER,
2992: IGS_PS_UNIT_STAT
2993: WHERE IGS_PS_UNIT_VER.unit_cd = p_unit_cd AND
2994: IGS_PS_UNIT_VER.version_number = p_version_number AND
2995: IGS_PS_UNIT_STAT.unit_status = IGS_PS_UNIT_VER.unit_status;

Line 2993: WHERE IGS_PS_UNIT_VER.unit_cd = p_unit_cd AND

2989: CURSOR c_get_uv_status IS
2990: SELECT IGS_PS_UNIT_STAT.s_unit_status
2991: FROM IGS_PS_UNIT_VER,
2992: IGS_PS_UNIT_STAT
2993: WHERE IGS_PS_UNIT_VER.unit_cd = p_unit_cd AND
2994: IGS_PS_UNIT_VER.version_number = p_version_number AND
2995: IGS_PS_UNIT_STAT.unit_status = IGS_PS_UNIT_VER.unit_status;
2996: CURSOR c_val_uoo IS
2997: SELECT offered_ind

Line 2994: IGS_PS_UNIT_VER.version_number = p_version_number AND

2990: SELECT IGS_PS_UNIT_STAT.s_unit_status
2991: FROM IGS_PS_UNIT_VER,
2992: IGS_PS_UNIT_STAT
2993: WHERE IGS_PS_UNIT_VER.unit_cd = p_unit_cd AND
2994: IGS_PS_UNIT_VER.version_number = p_version_number AND
2995: IGS_PS_UNIT_STAT.unit_status = IGS_PS_UNIT_VER.unit_status;
2996: CURSOR c_val_uoo IS
2997: SELECT offered_ind
2998: FROM IGS_PS_UNIT_OFR_OPT

Line 2995: IGS_PS_UNIT_STAT.unit_status = IGS_PS_UNIT_VER.unit_status;

2991: FROM IGS_PS_UNIT_VER,
2992: IGS_PS_UNIT_STAT
2993: WHERE IGS_PS_UNIT_VER.unit_cd = p_unit_cd AND
2994: IGS_PS_UNIT_VER.version_number = p_version_number AND
2995: IGS_PS_UNIT_STAT.unit_status = IGS_PS_UNIT_VER.unit_status;
2996: CURSOR c_val_uoo IS
2997: SELECT offered_ind
2998: FROM IGS_PS_UNIT_OFR_OPT
2999: WHERE unit_cd = p_unit_cd AND

Line 3208: -- in igs_ps_unit_ver table. PSP integration build #3052433

3204: -- Modified the c_sua cursor where clause due
3205: -- to change in pk of student unit attempt table
3206: -- w.r.t. bug number 2829262
3207: -- rvivekan 09-sep-2003 Modified the behaviour of repeatable_ind column
3208: -- in igs_ps_unit_ver table. PSP integration build #3052433
3209: -- ckasu 28-NOV-2005 modified v_message_name <> NULL to v_message_name IS NOT NULL
3210: -- as a partof bug #4666102
3211: -------------------------------------------------------------------------------------------
3212:

Line 3265: FROM IGS_PS_UNIT_VER uv

3261: sct.course_cd = p_course_cd AND
3262: sct.transfer_course_cd = cp_course_cd;
3263: CURSOR c_uv IS
3264: SELECT uv.repeatable_ind
3265: FROM IGS_PS_UNIT_VER uv
3266: WHERE uv.unit_cd = p_unit_cd AND
3267: uv.version_number = p_uv_version_number;
3268: v_sct_exists VARCHAR2(1);
3269: TYPE r_alias_val_record_type IS RECORD(

Line 3287: v_repeatable_ind IGS_PS_UNIT_VER.repeatable_ind%TYPE;

3283: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
3284: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
3285: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
3286: v_origin_course_cd IGS_AS_SU_STMPTOUT.course_cd%TYPE;
3287: v_repeatable_ind IGS_PS_UNIT_VER.repeatable_ind%TYPE;
3288: v_duplicate_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
3289: BEGIN
3290: -- Set the default message number and duplicate course code
3291: p_message_name := null;

Line 3887: FROM igs_ps_unit_ver uv

3883:
3884:
3885: CURSOR c_same_section(cp_unit_cd VARCHAR2,cp_version_number NUMBER) IS
3886: SELECT same_teaching_period
3887: FROM igs_ps_unit_ver uv
3888: WHERE unit_cd = cp_unit_cd AND
3889: uv.version_number =cp_version_number;
3890:
3891: CURSOR c_mus_allowed (cp_person_id NUMBER, cp_course_cd VARCHAR2, cp_unit_cd VARCHAR2,

Line 3928: l_same_teaching_period igs_ps_unit_ver.same_teaching_period%TYPE;

3924: l_unit_cd igs_en_su_attempt.unit_cd%TYPE;
3925: l_unit_ver igs_en_su_attempt.version_number%TYPE;
3926: l_cal_type igs_en_su_attempt.cal_type%TYPE;
3927: l_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE;
3928: l_same_teaching_period igs_ps_unit_ver.same_teaching_period%TYPE;
3929: l_usec_exclude_mus_flag igs_ps_unit_ofr_opt.not_multiple_section_flag%TYPE;
3930: l_notused VARCHAR2(1);
3931:
3932: