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_RE_GEN_001 dependencies on IGS_RE_CANDIDATURE

Line 199: -- IGS_RE_CANDIDATURE. This is calculated as the remaining EFTD (Effective

195: ----------------------------------------------------------------------------*/
196: gv_other_detail VARCHAR2(255);
197: BEGIN -- resp_clc_max_sbmsn
198: -- Calculate the minimum submission date of a student IGS_PS_COURSE attempt
199: -- IGS_RE_CANDIDATURE. This is calculated as the remaining EFTD (Effective
200: -- Full Time Days) remaining in the IGS_PS_COURSE multiplied by the minimum
201: -- submission percentage (stored against the students IGS_PS_COURSE version)
202: -- factored with the students current attendance percentage.
203: DECLARE

Line 205: v_ca_acai_adm_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE;

201: -- submission percentage (stored against the students IGS_PS_COURSE version)
202: -- factored with the students current attendance percentage.
203: DECLARE
204: cst_unconfirm CONSTANT VARCHAR2(10) := 'UNCONFIRM';
205: v_ca_acai_adm_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE;
206: v_ca_acai_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE;
207: v_ca_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE;
208: v_ca_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;
209: v_ca_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;

Line 206: v_ca_acai_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE;

202: -- factored with the students current attendance percentage.
203: DECLARE
204: cst_unconfirm CONSTANT VARCHAR2(10) := 'UNCONFIRM';
205: v_ca_acai_adm_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE;
206: v_ca_acai_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE;
207: v_ca_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE;
208: v_ca_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;
209: v_ca_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
210: v_candidature_exists_ind VARCHAR2(1);

Line 207: v_ca_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE;

203: DECLARE
204: cst_unconfirm CONSTANT VARCHAR2(10) := 'UNCONFIRM';
205: v_ca_acai_adm_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE;
206: v_ca_acai_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE;
207: v_ca_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE;
208: v_ca_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;
209: v_ca_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
210: v_candidature_exists_ind VARCHAR2(1);
211: v_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;

Line 208: v_ca_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;

204: cst_unconfirm CONSTANT VARCHAR2(10) := 'UNCONFIRM';
205: v_ca_acai_adm_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE;
206: v_ca_acai_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE;
207: v_ca_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE;
208: v_ca_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;
209: v_ca_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
210: v_candidature_exists_ind VARCHAR2(1);
211: v_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
212: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

Line 209: v_ca_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;

205: v_ca_acai_adm_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE;
206: v_ca_acai_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE;
207: v_ca_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE;
208: v_ca_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;
209: v_ca_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
210: v_candidature_exists_ind VARCHAR2(1);
211: v_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
212: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
213: v_sca_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;

Line 234: FROM IGS_RE_CANDIDATURE ca

230: ca.acai_nominated_course_cd,
231: ca.acai_sequence_number,
232: ca.sca_course_cd,
233: ca.attendance_percentage
234: FROM IGS_RE_CANDIDATURE ca
235: WHERE ca.person_id = p_person_id AND
236: ca.sequence_number = p_ca_sequence_number;
237: CURSOR c_sca IS
238: SELECT sca.course_cd,

Line 286: -- Select details from IGS_RE_CANDIDATURE

282: v_ca_acai_sequence_number := NULL;
283: v_ca_sca_course_cd := NULL;
284: v_ca_attendance_percentage := NULL;
285: IF p_ca_sequence_number IS NOT NULL THEN
286: -- Select details from IGS_RE_CANDIDATURE
287: OPEN c_ca;
288: FETCH c_ca INTO v_ca_acai_adm_appl_number,
289: v_ca_acai_nominated_course_cd,
290: v_ca_acai_sequence_number,

Line 311: -- IGS_PS_COURSE attempt depending on the IGS_RE_CANDIDATURE fields which are set.

307: v_ca_acai_sequence_number := p_acai_sequence_number;
308: v_ca_sca_course_cd := p_sca_course_cd;
309: END IF;
310: -- Either select details from the admission application or the student
311: -- IGS_PS_COURSE attempt depending on the IGS_RE_CANDIDATURE fields which are set.
312: IF v_ca_sca_course_cd IS NOT NULL THEN
313: OPEN c_sca;
314: FETCH c_sca INTO v_sca_course_cd,
315: v_sca_version_number,

Line 478: -- IGS_RE_CANDIDATURE. This is calculated as the remaining EFTD (Effective

474: ----------------------------------------------------------------------------*/
475: gv_other_detail VARCHAR2(255);
476: BEGIN -- resp_clc_min_sbmsn
477: -- Calculate the minimum submission date of a student IGS_PS_COURSE attempt
478: -- IGS_RE_CANDIDATURE. This is calculated as the remaining EFTD (Effective
479: -- Full Time Days) remaining in the IGS_PS_COURSE multiplied by the minimum
480: -- submission percentage (stored against the students IGS_PS_COURSE version)
481: -- factored with the students current attendance percentage.
482: DECLARE

Line 484: v_ca_acai_adm_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE;

480: -- submission percentage (stored against the students IGS_PS_COURSE version)
481: -- factored with the students current attendance percentage.
482: DECLARE
483: cst_unconfirm CONSTANT VARCHAR2(10) := 'UNCONFIRM';
484: v_ca_acai_adm_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE;
485: v_ca_acai_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE;
486: v_ca_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE;
487: v_ca_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;
488: v_ca_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;

Line 485: v_ca_acai_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE;

481: -- factored with the students current attendance percentage.
482: DECLARE
483: cst_unconfirm CONSTANT VARCHAR2(10) := 'UNCONFIRM';
484: v_ca_acai_adm_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE;
485: v_ca_acai_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE;
486: v_ca_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE;
487: v_ca_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;
488: v_ca_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
489: v_candidature_exists_ind VARCHAR2(1);

Line 486: v_ca_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE;

482: DECLARE
483: cst_unconfirm CONSTANT VARCHAR2(10) := 'UNCONFIRM';
484: v_ca_acai_adm_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE;
485: v_ca_acai_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE;
486: v_ca_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE;
487: v_ca_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;
488: v_ca_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
489: v_candidature_exists_ind VARCHAR2(1);
490: v_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;

Line 487: v_ca_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;

483: cst_unconfirm CONSTANT VARCHAR2(10) := 'UNCONFIRM';
484: v_ca_acai_adm_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE;
485: v_ca_acai_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE;
486: v_ca_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE;
487: v_ca_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;
488: v_ca_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
489: v_candidature_exists_ind VARCHAR2(1);
490: v_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
491: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

Line 488: v_ca_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;

484: v_ca_acai_adm_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE;
485: v_ca_acai_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE;
486: v_ca_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE;
487: v_ca_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;
488: v_ca_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
489: v_candidature_exists_ind VARCHAR2(1);
490: v_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
491: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
492: v_sca_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;

Line 514: FROM IGS_RE_CANDIDATURE ca

510: ca.acai_nominated_course_cd,
511: ca.acai_sequence_number,
512: ca.sca_course_cd,
513: ca.attendance_percentage
514: FROM IGS_RE_CANDIDATURE ca
515: WHERE ca.person_id = p_person_id AND
516: ca.sequence_number = p_ca_sequence_number;
517: CURSOR c_sca IS
518: SELECT sca.course_cd,

Line 578: -- Select details from IGS_RE_CANDIDATURE

574: v_ca_acai_sequence_number := NULL;
575: v_ca_sca_course_cd := NULL;
576: v_ca_attendance_percentage := NULL;
577: IF p_ca_sequence_number IS NOT NULL THEN
578: -- Select details from IGS_RE_CANDIDATURE
579: OPEN c_ca;
580: FETCH c_ca INTO v_ca_acai_adm_appl_number,
581: v_ca_acai_nominated_course_cd,
582: v_ca_acai_sequence_number,

Line 603: -- IGS_PS_COURSE attempt depending on the IGS_RE_CANDIDATURE fields which are set.

599: v_ca_acai_sequence_number := p_acai_sequence_number;
600: v_ca_sca_course_cd := p_sca_course_cd;
601: END IF;
602: -- Either select details from the admission application or the student
603: -- IGS_PS_COURSE attempt depending on the IGS_RE_CANDIDATURE fields which are set.
604: IF v_ca_sca_course_cd IS NOT NULL THEN
605: OPEN c_sca;
606: FETCH c_sca INTO v_sca_course_cd,
607: v_sca_version_number,

Line 785: v_ca_person_id IGS_RE_CANDIDATURE.person_id%TYPE;

781: -- calendar (ie. multiple units are not taken into consideration when
782: -- comparing the research load with the coursework load).
783: DECLARE
784: v_census_dt IGS_CA_DA_INST.absolute_val%TYPE;
785: v_ca_person_id IGS_RE_CANDIDATURE.person_id%TYPE;
786: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
787: v_sua_override_eftsu IGS_EN_SU_ATTEMPT.override_eftsu%TYPE;
788: v_sua_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
789: v_sua_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;

Line 786: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;

782: -- comparing the research load with the coursework load).
783: DECLARE
784: v_census_dt IGS_CA_DA_INST.absolute_val%TYPE;
785: v_ca_person_id IGS_RE_CANDIDATURE.person_id%TYPE;
786: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
787: v_sua_override_eftsu IGS_EN_SU_ATTEMPT.override_eftsu%TYPE;
788: v_sua_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
789: v_sua_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE;
790: v_sua_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE;

Line 809: FROM IGS_RE_CANDIDATURE ca

805: v_census_att_perc NUMBER;
806: CURSOR c_ca IS
807: SELECT ca.person_id,
808: ca.sequence_number
809: FROM IGS_RE_CANDIDATURE ca
810: WHERE ca.person_id = p_person_id AND
811: NVL(ca.sca_course_cd, 'NULL') = NVL(p_course_cd, 'NULL');
812: CURSOR c_sua(cp_person_id igs_en_su_attempt.person_id%TYPE,
813: cp_course_cd igs_en_su_attempt.course_cd%TYPE,

Line 850: -- 1. Select detail from research IGS_RE_CANDIDATURE

846: dai.ci_sequence_number = cp_ci_sequence_number AND
847: dai.dt_alias = sgcc.census_dt_alias
848: ORDER BY 1;
849: BEGIN
850: -- 1. Select detail from research IGS_RE_CANDIDATURE
851: OPEN c_ca;
852: FETCH c_ca INTO
853: v_ca_person_id,
854: v_ca_sequence_number;

Line 1027: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;

1023: -------------------------------------------------------------------------------------------
1024: DECLARE
1025: cst_unconfirm CONSTANT
1026: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'UNCONFIRM';
1027: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
1028: v_ca_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
1029: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
1030: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
1031: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;

Line 1028: v_ca_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;

1024: DECLARE
1025: cst_unconfirm CONSTANT
1026: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'UNCONFIRM';
1027: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
1028: v_ca_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
1029: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
1030: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
1031: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
1032: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

Line 1043: v_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;

1039: v_count_intrmsn_in_time_ind IGS_PS_VER.count_intrmsn_in_time_ind%TYPE;
1040: v_start_dt IGS_RE_CDT_ATT_HIST.hist_start_dt%TYPE;
1041: v_last_end_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
1042: v_cah_last_end_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
1043: v_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
1044: v_today_dt DATE;
1045: v_EFTD_total NUMBER;
1046: v_next_rec_flg BOOLEAN;
1047: v_sci_end_dt IGS_EN_STDNT_PS_INTM.end_dt%TYPE;

Line 1052: FROM IGS_RE_CANDIDATURE ca

1048: v_end_dt IGS_EN_STDNT_PS_INTM.end_dt%TYPE;
1049: CURSOR c_ca IS
1050: SELECT ca.sequence_number,
1051: ca.attendance_percentage
1052: FROM IGS_RE_CANDIDATURE ca
1053: WHERE ca.person_id = p_person_id AND
1054: (ca.sca_course_cd IS NULL OR
1055: ca.sca_course_cd = p_course_cd);
1056: CURSOR c_sca IS

Line 1065: cp_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE

1061: FROM IGS_EN_STDNT_PS_ATT sca
1062: WHERE sca.person_id = p_person_id AND
1063: sca.course_cd = p_course_cd;
1064: CURSOR c_cah (
1065: cp_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE
1066: ) IS
1067: SELECT cah.hist_start_dt,
1068: cah.hist_end_dt,
1069: cah.attendance_percentage

Line 1100: cp_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE,

1096: eit.intermission_type = sci.intermission_type AND
1097: sci.logical_delete_date = TO_DATE('31-12-4712','DD-MM-YYYY')
1098: ORDER BY sci.start_dt;
1099: CURSOR c_cah2 (
1100: cp_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE,
1101: cp_sci_end_dt IGS_EN_STDNT_PS_INTM.end_dt%TYPE,
1102: cp_sci_start_dt IGS_EN_STDNT_PS_INTM.start_dt%TYPE) IS
1103: SELECT cah.hist_start_dt,
1104: cah.hist_end_dt,

Line 1114: -- IGS_RE_CANDIDATURE for the IGS_PS_COURSE attempt.

1110: cah.hist_end_dt >= cp_sci_start_dt
1111: ORDER BY cah.hist_start_dt ASC;
1112: BEGIN
1113: -- 1. Determine whether IGS_PE_PERSON has a research
1114: -- IGS_RE_CANDIDATURE for the IGS_PS_COURSE attempt.
1115: IF (p_candidature_identified_ind = 'Y') THEN
1116: v_attendance_percentage := p_attendance_percentage;
1117: v_ca_sequence_number := p_ca_sequence_number;
1118: ELSE

Line 1143: -- 3. Loop though IGS_RE_CANDIDATURE history totalling effective attendance periods

1139: -- Unconfirmed IGS_PS_COURSE attempts can't have used any days
1140: RETURN 0;
1141: END IF;
1142: v_today_dt := TRUNC(SYSDATE);
1143: -- 3. Loop though IGS_RE_CANDIDATURE history totalling effective attendance periods
1144: v_EFTD_total := 0;
1145:
1146: FOR v_cah_rec IN c_cah( v_ca_sequence_number) LOOP
1147: v_start_dt := v_cah_rec.hist_start_dt;

Line 1182: -- If the current (IGS_RE_CANDIDATURE) attendance percentage is set then use it,

1178: v_last_end_dt := v_last_hist_end_dt;
1179: END IF;
1180: CLOSE c_cah;
1181: IF (v_last_end_dt < v_today_dt - 1) THEN
1182: -- If the current (IGS_RE_CANDIDATURE) attendance percentage is set then use it,
1183: -- otherwise load the default from the attendance type
1184: IF (v_attendance_percentage IS NULL) THEN
1185: OPEN c_att(v_attendance_type);
1186: FETCH c_att INTO v_research_percentage;

Line 1262: -- If the current (IGS_RE_CANDIDATURE) attendance percentage is set then

1258: v_last_end_dt := v_sci_rec.start_dt - 1;
1259: ELSE
1260: v_last_end_dt := v_last_hist_end_dt;
1261: END IF;
1262: -- If the current (IGS_RE_CANDIDATURE) attendance percentage is set then
1263: -- use it, otherwise load the default from the attendance type
1264: IF (v_attendance_percentage IS NULL) THEN
1265: OPEN c_att(v_attendance_type);
1266: FETCH c_att INTO v_research_percentage;

Line 1321: -- Get the attendance percentage of a IGS_RE_CANDIDATURE as at a given date.

1317: p_attendance_percentage IN NUMBER )
1318: RETURN NUMBER AS
1319: gv_other_detail VARCHAR2(255);
1320: BEGIN -- resp_get_ca_att
1321: -- Get the attendance percentage of a IGS_RE_CANDIDATURE as at a given date.
1322: -- This is determined by looking through attendance history for the persons
1323: -- IGS_RE_CANDIDATURE.
1324: -- IGS_GE_NOTE: A returned value of NULL indicates that the value could not be
1325: -- determined.

Line 1323: -- IGS_RE_CANDIDATURE.

1319: gv_other_detail VARCHAR2(255);
1320: BEGIN -- resp_get_ca_att
1321: -- Get the attendance percentage of a IGS_RE_CANDIDATURE as at a given date.
1322: -- This is determined by looking through attendance history for the persons
1323: -- IGS_RE_CANDIDATURE.
1324: -- IGS_GE_NOTE: A returned value of NULL indicates that the value could not be
1325: -- determined.
1326: DECLARE
1327: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;

Line 1327: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;

1323: -- IGS_RE_CANDIDATURE.
1324: -- IGS_GE_NOTE: A returned value of NULL indicates that the value could not be
1325: -- determined.
1326: DECLARE
1327: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
1328: v_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
1329: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
1330: CURSOR c_ca_sca IS
1331: SELECT ca.sequence_number,

Line 1328: v_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;

1324: -- IGS_GE_NOTE: A returned value of NULL indicates that the value could not be
1325: -- determined.
1326: DECLARE
1327: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
1328: v_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
1329: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
1330: CURSOR c_ca_sca IS
1331: SELECT ca.sequence_number,
1332: ca.attendance_percentage,

Line 1334: FROM IGS_RE_CANDIDATURE ca,

1330: CURSOR c_ca_sca IS
1331: SELECT ca.sequence_number,
1332: ca.attendance_percentage,
1333: sca.attendance_type
1334: FROM IGS_RE_CANDIDATURE ca,
1335: IGS_EN_STDNT_PS_ATT sca
1336: WHERE ca.person_id = p_person_id AND
1337: ca.sca_course_cd = p_course_cd AND
1338: sca.course_cd = ca.sca_course_cd AND

Line 1341: cp_person_id IGS_RE_CANDIDATURE.person_id%TYPE,

1337: ca.sca_course_cd = p_course_cd AND
1338: sca.course_cd = ca.sca_course_cd AND
1339: sca.person_id = ca.person_id;
1340: CURSOR c_cah (
1341: cp_person_id IGS_RE_CANDIDATURE.person_id%TYPE,
1342: cp_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE,
1343: cp_effective_dt DATE) IS
1344: SELECT cah.attendance_type,
1345: cah.attendance_percentage

Line 1342: cp_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE,

1338: sca.course_cd = ca.sca_course_cd AND
1339: sca.person_id = ca.person_id;
1340: CURSOR c_cah (
1341: cp_person_id IGS_RE_CANDIDATURE.person_id%TYPE,
1342: cp_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE,
1343: cp_effective_dt DATE) IS
1344: SELECT cah.attendance_type,
1345: cah.attendance_percentage
1346: FROM IGS_RE_CDT_ATT_HIST cah

Line 1358: -- If IGS_RE_CANDIDATURE details have not been passed then load the record

1354: SELECT att.research_percentage
1355: FROM IGS_EN_ATD_TYPE att
1356: WHERE att.attendance_type = cp_attendance_type;
1357: BEGIN
1358: -- If IGS_RE_CANDIDATURE details have not been passed then load the record
1359: IF p_ca_sequence_number IS NULL OR
1360: p_attendance_type IS NULL THEN
1361: OPEN c_ca_sca;
1362: FETCH c_ca_sca INTO v_ca_sequence_number,