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_VAL_SUA dependencies on IGS_EN_STDNT_PS_ATT

Line 117: CURSOR c_com_dt(p_person_id IGS_EN_STDNT_PS_ATT_ALL.Person_id%TYPE,

113: rsup.end_dt >= v_teach_start_dt)
114: ORDER BY rsup.start_dt ASC;
115:
116: --tray
117: CURSOR c_com_dt(p_person_id IGS_EN_STDNT_PS_ATT_ALL.Person_id%TYPE,
118: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.Course_cd%TYPE)IS
119: SELECT commencement_dt from igs_en_stdnt_ps_att_all
120: WHERE person_id = p_person_id
121: AND course_cd = p_course_cd;

Line 118: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.Course_cd%TYPE)IS

114: ORDER BY rsup.start_dt ASC;
115:
116: --tray
117: CURSOR c_com_dt(p_person_id IGS_EN_STDNT_PS_ATT_ALL.Person_id%TYPE,
118: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.Course_cd%TYPE)IS
119: SELECT commencement_dt from igs_en_stdnt_ps_att_all
120: WHERE person_id = p_person_id
121: AND course_cd = p_course_cd;
122: v_commencement_dt igs_en_stdnt_ps_att_all.commencement_dt%TYPE;

Line 119: SELECT commencement_dt from igs_en_stdnt_ps_att_all

115:
116: --tray
117: CURSOR c_com_dt(p_person_id IGS_EN_STDNT_PS_ATT_ALL.Person_id%TYPE,
118: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.Course_cd%TYPE)IS
119: SELECT commencement_dt from igs_en_stdnt_ps_att_all
120: WHERE person_id = p_person_id
121: AND course_cd = p_course_cd;
122: v_commencement_dt igs_en_stdnt_ps_att_all.commencement_dt%TYPE;
123:

Line 122: v_commencement_dt igs_en_stdnt_ps_att_all.commencement_dt%TYPE;

118: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.Course_cd%TYPE)IS
119: SELECT commencement_dt from igs_en_stdnt_ps_att_all
120: WHERE person_id = p_person_id
121: AND course_cd = p_course_cd;
122: v_commencement_dt igs_en_stdnt_ps_att_all.commencement_dt%TYPE;
123:
124: FUNCTION respl_check_percentage(
125: pl_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE,
126: pl_check_dt IGS_RE_SPRVSR.start_dt%TYPE)

Line 651: FROM IGS_EN_STDNT_PS_ATT sca

647: and sut3.course_cd = sut1.transfer_course_cd
648: and sut3.uoo_id = sut1.uoo_id);
649: CURSOR c_sca IS
650: SELECT sca.course_attempt_status
651: FROM IGS_EN_STDNT_PS_ATT sca
652: WHERE sca.person_id = p_person_id AND
653: sca.course_cd = p_course_cd;
654: CURSOR c_old_sua_attr IS
655: SELECT sua.unit_attempt_status

Line 662: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

658: sua.course_cd = p_course_cd AND
659: sua.uoo_id = p_uoo_id;
660: l_old_unit_status igs_en_su_attempt.unit_attempt_status%TYPE;
661:
662: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
663: v_sut_found VARCHAR2(1) := NULL;
664: cst_duplicate CONSTANT VARCHAR2(10) := 'DUPLICATE';
665: cst_completed CONSTANT VARCHAR2(10) := 'COMPLETED';
666: cst_discontin CONSTANT VARCHAR2(10) := 'DISCONTIN';

Line 798: -- only exists if one of IGS_EN_STDNT_PS_ATT.override_enrolled_cp or

794: RETURN BOOLEAN AS
795:
796: BEGIN -- enrp_val_sua_cp_rsn
797: -- This module validates that IGS_EN_SU_ATTEMPT.override_credit_reason
798: -- only exists if one of IGS_EN_STDNT_PS_ATT.override_enrolled_cp or
799: -- IGS_EN_STDNT_PS_ATT.override_achievalble_cp exists.
800: BEGIN
801: p_message_name := null;
802: IF (p_override_credit_reason IS NOT NULL) AND

Line 799: -- IGS_EN_STDNT_PS_ATT.override_achievalble_cp exists.

795:
796: BEGIN -- enrp_val_sua_cp_rsn
797: -- This module validates that IGS_EN_SU_ATTEMPT.override_credit_reason
798: -- only exists if one of IGS_EN_STDNT_PS_ATT.override_enrolled_cp or
799: -- IGS_EN_STDNT_PS_ATT.override_achievalble_cp exists.
800: BEGIN
801: p_message_name := null;
802: IF (p_override_credit_reason IS NOT NULL) AND
803: (p_override_enrolled_cp IS NULL) AND

Line 844: -- IGS_EN_STDNT_PS_ATT.

840: BEGIN -- enrp_val_sua_ci
841: -- This module validates that the teaching period is valid for the
842: -- IGS_EN_SU_ATTEMPT.
843: -- * Teaching period must start after the commencement date of the
844: -- IGS_EN_STDNT_PS_ATT.
845: DECLARE
846: CURSOR c_ci IS
847: SELECT ci.end_dt
848: FROM IGS_CA_INST ci

Line 854: FROM IGS_EN_STDNT_PS_ATT sca

850: ci.sequence_number = p_ci_sequence_number;
851: v_ci_rec c_ci%ROWTYPE;
852: CURSOR c_sca IS
853: SELECT sca.commencement_dt
854: FROM IGS_EN_STDNT_PS_ATT sca
855: WHERE sca.person_id = p_person_id AND
856: sca.course_cd = p_course_cd;
857: v_sca_rec c_sca%ROWTYPE;
858: cst_duplicate CONSTANT VARCHAR2(9) := 'DUPLICATE';

Line 861: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;

857: v_sca_rec c_sca%ROWTYPE;
858: cst_duplicate CONSTANT VARCHAR2(9) := 'DUPLICATE';
859: cst_discontin CONSTANT VARCHAR2(9) := 'DISCONTIN';
860: cst_completed CONSTANT VARCHAR2(9) := 'COMPLETED';
861: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
862: BEGIN
863: -- Set the default message number
864: p_message_name := null;
865: IF p_unit_attempt_status NOT IN (cst_duplicate,cst_discontin,cst_completed) THEN

Line 1108: v_crs_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

1104: v_total_exmptn_approved IGS_AV_ADV_STANDING.total_exmptn_approved%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

Line 1111: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%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
1114: FROM IGS_EN_STDNT_PS_ATT sca
1115: WHERE sca.person_id = cp_person_id AND

Line 1112: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS

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
1114: FROM IGS_EN_STDNT_PS_ATT sca
1115: WHERE sca.person_id = cp_person_id AND
1116: sca.course_cd = cp_course_cd;

Line 1114: FROM IGS_EN_STDNT_PS_ATT sca

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
1114: FROM IGS_EN_STDNT_PS_ATT sca
1115: WHERE sca.person_id = cp_person_id AND
1116: sca.course_cd = cp_course_cd;
1117: CURSOR c_adv_stnd_unit_details (
1118: cp_person_id IGS_AV_STND_UNIT.person_id%TYPE,

Line 1885: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

1881: DECLARE
1882:
1883: v_unit_attempt_status IGS_AD_ADM_UNIT_STAT.unit_attempt_status%TYPE;
1884: v_s_unit_status IGS_AD_ADM_UNIT_STAT.unit_attempt_status%TYPE;
1885: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
1886: CURSOR c_uas IS
1887: SELECT unit_attempt_status
1888: FROM IGS_AD_ADM_UNIT_STAT
1889: WHERE administrative_unit_status = p_administrative_unit_status;

Line 1899: FROM IGS_EN_STDNT_PS_ATT

1895: uv.version_number = p_version_number AND
1896: us.unit_status = uv.unit_status;
1897: CURSOR c_cas IS
1898: SELECT course_attempt_status
1899: FROM IGS_EN_STDNT_PS_ATT
1900: WHERE person_id = p_person_id AND
1901: course_cd = p_course_cd;
1902: BEGIN
1903: -- This module validates the discontinued_dt from

Line 2021: v_sca_details IGS_EN_STDNT_PS_ATT%ROWTYPE;

2017: cst_discontin CONSTANT VARCHAR2(10) := 'DISCONTIN';
2018: cst_waitlisted CONSTANT VARCHAR2(10) := 'WAITLISTED';
2019: cst_dropped CONSTANT VARCHAR2(10) := 'DROPPED'; -- Added by Nishikant - bug#2364216
2020: cst_planned CONSTANT VARCHAR2(10) := 'PLANNED';
2021: v_sca_details IGS_EN_STDNT_PS_ATT%ROWTYPE;
2022:
2023: CURSOR c_sca_details (
2024: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
2025: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE) IS

Line 2027: FROM IGS_EN_STDNT_PS_ATT

2023: CURSOR c_sca_details (
2024: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
2025: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE) IS
2026: SELECT *
2027: FROM IGS_EN_STDNT_PS_ATT
2028: WHERE person_id = cp_person_id AND
2029: course_cd = cp_course_cd;
2030: BEGIN
2031: -- Validate that the IGS_EN_SU_ATTEMPT.enrolled_dt must be set

Line 2034: -- IGS_EN_STDNT_PS_ATT.commencement_dt.

2030: BEGIN
2031: -- Validate that the IGS_EN_SU_ATTEMPT.enrolled_dt must be set
2032: -- for all unit attempt statuses with the exception of UNCONFIRM
2033: -- Validate that IGS_EN_SU_ATTEMPT.enrolled_dt >=
2034: -- IGS_EN_STDNT_PS_ATT.commencement_dt.
2035: -- Validate that the student unit attempt enrolled date must
2036: -- be set for all unit attempt statuses, with the exception
2037: -- of UNCONFIRM.
2038: -- amuthu 02-APR-2002, Now adding the WAITLISED status also

Line 2143: FROM IGS_EN_STDNT_PS_ATT

2139: cst_invalid IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'INVALID';
2140: v_del_alwd_dt DATE := NULL;
2141: CURSOR c_sca IS
2142: SELECT course_rqrmnt_complete_ind
2143: FROM IGS_EN_STDNT_PS_ATT
2144: WHERE person_id = p_person_id AND
2145: course_cd = p_course_cd;
2146: v_course_rqrmnt_complete_ind
2147: IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind%TYPE := NULL;

Line 2147: IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind%TYPE := NULL;

2143: FROM IGS_EN_STDNT_PS_ATT
2144: WHERE person_id = p_person_id AND
2145: course_cd = p_course_cd;
2146: v_course_rqrmnt_complete_ind
2147: IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind%TYPE := NULL;
2148: CURSOR c_sut IS
2149: SELECT 'x'
2150: FROM IGS_PS_STDNT_UNT_TRN
2151: WHERE person_id = p_person_id AND

Line 2270: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE:= 'DISCONTIN';

2266: gv_other_details VARCHAR2(255);
2267: BEGIN
2268: DECLARE
2269: cst_discontin CONSTANT
2270: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE:= 'DISCONTIN';
2271: cst_lapsed CONSTANT
2272: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'LAPSED';
2273: cst_unconfirm CONSTANT
2274: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'UNCONFIRM';

Line 2272: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'LAPSED';

2268: DECLARE
2269: cst_discontin CONSTANT
2270: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE:= 'DISCONTIN';
2271: cst_lapsed CONSTANT
2272: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'LAPSED';
2273: cst_unconfirm CONSTANT
2274: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'UNCONFIRM';
2275: cst_completed CONSTANT
2276: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'COMPLETED';

Line 2274: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'UNCONFIRM';

2270: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE:= 'DISCONTIN';
2271: cst_lapsed CONSTANT
2272: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'LAPSED';
2273: cst_unconfirm CONSTANT
2274: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'UNCONFIRM';
2275: cst_completed CONSTANT
2276: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'COMPLETED';
2277: cst_duplicate CONSTANT
2278: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'DUPLICATE';

Line 2276: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'COMPLETED';

2272: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'LAPSED';
2273: cst_unconfirm CONSTANT
2274: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'UNCONFIRM';
2275: cst_completed CONSTANT
2276: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'COMPLETED';
2277: cst_duplicate CONSTANT
2278: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'DUPLICATE';
2279: CURSOR c_sca IS
2280: SELECT sca.course_attempt_status

Line 2278: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'DUPLICATE';

2274: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'UNCONFIRM';
2275: cst_completed CONSTANT
2276: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'COMPLETED';
2277: cst_duplicate CONSTANT
2278: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'DUPLICATE';
2279: CURSOR c_sca IS
2280: SELECT sca.course_attempt_status
2281: FROM IGS_EN_STDNT_PS_ATT sca
2282: WHERE sca.person_id = p_person_id AND

Line 2281: FROM IGS_EN_STDNT_PS_ATT sca

2277: cst_duplicate CONSTANT
2278: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'DUPLICATE';
2279: CURSOR c_sca IS
2280: SELECT sca.course_attempt_status
2281: FROM IGS_EN_STDNT_PS_ATT sca
2282: WHERE sca.person_id = p_person_id AND
2283: sca.course_cd = p_course_cd;
2284: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
2285: BEGIN

Line 2284: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

2280: SELECT sca.course_attempt_status
2281: FROM IGS_EN_STDNT_PS_ATT sca
2282: WHERE sca.person_id = p_person_id AND
2283: sca.course_cd = p_course_cd;
2284: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
2285: BEGIN
2286: --- Set the default message number
2287: p_message_name := null;
2288: --- Get the course attempt status

Line 2296: -- Validate against status of IGS_EN_STDNT_PS_ATT

2292: CLOSE c_sca;
2293: RETURN TRUE;
2294: END IF;
2295: CLOSE c_sca;
2296: -- Validate against status of IGS_EN_STDNT_PS_ATT
2297: IF (v_course_attempt_status = cst_discontin) THEN
2298: IF (p_unit_attempt_status <> cst_duplicate) THEN
2299: p_message_name := 'IGS_EN_CANT_INS_STUD_UNT_ATMP';
2300: RETURN FALSE;

Line 2406: FROM IGS_EN_STDNT_PS_ATT sca

2402: CURSOR c_sca IS
2403: SELECT sca.version_number,
2404: sca.coo_id,
2405: sca.commencement_dt
2406: FROM IGS_EN_STDNT_PS_ATT sca
2407: WHERE person_id = p_person_id AND
2408: course_cd = p_course_cd;
2409: CURSOR c_sua IS
2410: SELECT uoo_id

Line 3075: cp_coo_id IGS_EN_STDNT_PS_ATT.coo_id%TYPE) IS

3071: v_s_unit_mode IGS_AS_UNIT_MODE.s_unit_mode%TYPE;
3072: v_govt_attend_mode IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
3073: v_other_detail VARCHAR(255);
3074: CURSOR c_coo(
3075: cp_coo_id IGS_EN_STDNT_PS_ATT.coo_id%TYPE) IS
3076: SELECT *
3077: FROM IGS_PS_OFR_OPT
3078: WHERE IGS_PS_OFR_OPT.coo_id = cp_coo_id
3079: AND IGS_PS_OFR_OPT.delete_flag = 'N';

Line 3115: cp_coo_id IGS_EN_STDNT_PS_ATT.coo_id%TYPE) IS

3111: v_s_unit_mode IGS_AS_UNIT_MODE.s_unit_mode%TYPE;
3112: v_govt_attend_mode IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
3113: v_other_detail VARCHAR(255);
3114: CURSOR c_coo(
3115: cp_coo_id IGS_EN_STDNT_PS_ATT.coo_id%TYPE) IS
3116: SELECT *
3117: FROM IGS_PS_OFR_OPT
3118: WHERE IGS_PS_OFR_OPT.coo_id = cp_coo_id
3119: AND IGS_PS_OFR_OPT.delete_flag = 'N';

Line 3727: FROM igs_en_stdnt_ps_att sca

3723: uoo.relation_type = 'SUBORDINATE' ;
3724:
3725: CURSOR cur_coo_id is
3726: SELECT sca.coo_id
3727: FROM igs_en_stdnt_ps_att sca
3728: WHERE sca.person_id = p_person_id
3729: AND sca.course_cd = p_course_cd;
3730:
3731: l_coo_id igs_en_stdnt_ps_att.coo_id%TYPE;

Line 3731: l_coo_id igs_en_stdnt_ps_att.coo_id%TYPE;

3727: FROM igs_en_stdnt_ps_att sca
3728: WHERE sca.person_id = p_person_id
3729: AND sca.course_cd = p_course_cd;
3730:
3731: l_coo_id igs_en_stdnt_ps_att.coo_id%TYPE;
3732:
3733: l_sub_sua IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;
3734: l_ovrrd_chk VARCHAR2(1);
3735: l_ovrrd_drop VARCHAR2(1);