APPS.IGS_EN_VAL_SCA dependencies on IGS_PS_STDNT_TRN

Line 1096: -- application can only occur when matching IGS_PS_STDNT_TRN details

1092: p_message_name OUT NOCOPY VARCHAR2)
1093: RETURN BOOLEAN AS
1094: BEGIN -- enrp_val_trnsfr_acpt
1095: -- This module validates that acceptance of an admission course transfer
1096: -- application can only occur when matching IGS_PS_STDNT_TRN details
1097: -- exist.
1098: -- This validation routine will be called from ENRF3000, ADMF3240,
1099: -- IGS_EN_STDNT_PS_ATT and IGS_AD_PS_APPL_INST database triggers,
1100: -- and the pre-enrolment process.

Line 1113: IGS_PS_STDNT_TRN sct

1109: admission_appl_number = p_admission_appl_number;
1110: CURSOR c_aca_sct IS
1111: SELECT 'x'
1112: FROM IGS_AD_PS_APPL aca,
1113: IGS_PS_STDNT_TRN sct
1114: WHERE aca.person_id = p_person_id AND
1115: aca.admission_appl_number = p_admission_appl_number AND
1116: aca.nominated_course_cd = p_nominated_course_cd AND
1117: sct.person_id = aca.person_id AND

Line 1733: FROM IGS_PS_STDNT_TRN sct

1729:
1730: -- Modifed cursor to consider the status_flag while finding the transfer records
1731: CURSOR c_sct IS
1732: SELECT 'X'
1733: FROM IGS_PS_STDNT_TRN sct
1734: WHERE sct.person_id = p_person_id AND
1735: sct.transfer_course_cd = p_course_cd AND
1736: (sct.status_date >= p_discontinued_dt OR
1737: sct.status_flag = 'U');

Line 1941: FROM IGS_PS_STDNT_TRN sct

1937: -- status_flag is set to 'T'
1938: CURSOR c_sct IS
1939: SELECT sct.transfer_course_cd,
1940: sct.status_date
1941: FROM IGS_PS_STDNT_TRN sct
1942: WHERE sct.person_id = p_person_id AND
1943: (sct.course_cd = p_course_cd OR
1944: sct.transfer_course_cd = p_course_cd) AND
1945: sct.status_flag = 'T'

Line 1947: v_sct_transfer_actual_dt IGS_PS_STDNT_TRN.status_date%TYPE;

1943: (sct.course_cd = p_course_cd OR
1944: sct.transfer_course_cd = p_course_cd) AND
1945: sct.status_flag = 'T'
1946: ORDER BY sct.status_date desc;
1947: v_sct_transfer_actual_dt IGS_PS_STDNT_TRN.status_date%TYPE;
1948: v_sct_transfer_course_cd IGS_PS_STDNT_TRN.transfer_course_cd%TYPE;
1949: v_message_name varchar2(30);
1950: BEGIN
1951: p_message_name := null;

Line 1948: v_sct_transfer_course_cd IGS_PS_STDNT_TRN.transfer_course_cd%TYPE;

1944: sct.transfer_course_cd = p_course_cd) AND
1945: sct.status_flag = 'T'
1946: ORDER BY sct.status_date desc;
1947: v_sct_transfer_actual_dt IGS_PS_STDNT_TRN.status_date%TYPE;
1948: v_sct_transfer_course_cd IGS_PS_STDNT_TRN.transfer_course_cd%TYPE;
1949: v_message_name varchar2(30);
1950: BEGIN
1951: p_message_name := null;
1952: IF p_discontinued_dt IS NOT NULL THEN

Line 2150: FROM IGS_PS_STDNT_TRN sct,

2146: v_only_one_rec_found BOOLEAN := FALSE;
2147: v_commencement_dt_validated BOOLEAN;
2148: CURSOR c_sct_sca_crv IS
2149: SELECT sca.commencement_dt
2150: FROM IGS_PS_STDNT_TRN sct,
2151: IGS_EN_STDNT_PS_ATT sca,
2152: IGS_PS_VER crv
2153: WHERE sct.person_id = p_person_id AND
2154: sca.person_id = sct.person_id AND

Line 2224: FROM IGS_PS_STDNT_TRN sct,

2220: sua.ci_end_dt < p_commencement_dt;
2221: v_sua_ci_exists VARCHAR2(1);
2222: CURSOR c_sct_ca_sca IS
2223: SELECT sca.commencement_dt
2224: FROM IGS_PS_STDNT_TRN sct,
2225: IGS_RE_CANDIDATURE ca,
2226: IGS_EN_STDNT_PS_ATT sca
2227: WHERE sct.person_id = p_person_id AND
2228: sct.course_cd = p_course_cd AND

Line 2860: FROM IGS_PS_STDNT_TRN trnsf

2856: -- Cursor to check secondry program is destination of a future
2857: CURSOR cur_term_cal(cp_person_id NUMBER,
2858: cp_course_cd VARCHAR2) IS
2859: SELECT effective_term_cal_type,effective_term_sequence_num
2860: FROM IGS_PS_STDNT_TRN trnsf
2861: WHERE trnsf.person_id = cp_person_id
2862: AND trnsf.course_cd = cp_course_cd
2863: AND trnsf.STATUS_FLAG = 'U' ;
2864: