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

Line 36: -- or not data exists on IGS_RE_CANDIDATURE detail tables for the specified

32: p_scholarship_exists OUT NOCOPY BOOLEAN )
33: AS
34: BEGIN -- resp_get_ca_exists
35: -- Description: This module returns output parameters indicating whether
36: -- or not data exists on IGS_RE_CANDIDATURE detail tables for the specified
37: -- IGS_RE_CANDIDATURE.person_id /sequence_number.
38: DECLARE
39: v_the_dummy_rec VARCHAR2(1);
40: v_cafos_dummy_rec VARCHAR2(1);

Line 37: -- IGS_RE_CANDIDATURE.person_id /sequence_number.

33: AS
34: BEGIN -- resp_get_ca_exists
35: -- Description: This module returns output parameters indicating whether
36: -- or not data exists on IGS_RE_CANDIDATURE detail tables for the specified
37: -- IGS_RE_CANDIDATURE.person_id /sequence_number.
38: DECLARE
39: v_the_dummy_rec VARCHAR2(1);
40: v_cafos_dummy_rec VARCHAR2(1);
41: v_csc_dummy_rec VARCHAR2(1);

Line 99: --Validate for existence of IGS_RE_CANDIDATURE field of study

95: CLOSE c_the;
96: END IF;
97: END IF;
98: IF p_check_field_of_study THEN
99: --Validate for existence of IGS_RE_CANDIDATURE field of study
100: OPEN c_cafos;
101: FETCH c_cafos INTO v_cafos_dummy_rec;
102: IF (c_cafos%FOUND) THEN
103: CLOSE c_cafos;

Line 110: --Validate for existence of IGS_RE_CANDIDATURE socio-economic classification code

106: CLOSE c_cafos;
107: END IF;
108: END IF;
109: IF p_check_seo_class_cd THEN
110: --Validate for existence of IGS_RE_CANDIDATURE socio-economic classification code
111: OPEN c_csc;
112: FETCH c_csc INTO v_csc_dummy_rec;
113: IF (c_csc%FOUND) THEN
114: CLOSE c_csc;

Line 132: --Validate for existence of research IGS_RE_CANDIDATURE milestones

128: CLOSE c_rsup;
129: END IF;
130: END IF;
131: IF p_check_milestone THEN
132: --Validate for existence of research IGS_RE_CANDIDATURE milestones
133: OPEN c_mil;
134: FETCH c_mil INTO v_mil_dummy_rec;
135: IF (c_mil%FOUND) THEN
136: CLOSE c_mil;

Line 143: --Validate for existence of research IGS_RE_CANDIDATURE IGS_RE_SCHOLARSHIP

139: CLOSE c_mil;
140: END IF;
141: END IF;
142: IF p_check_scholarship THEN
143: --Validate for existence of research IGS_RE_CANDIDATURE IGS_RE_SCHOLARSHIP
144: OPEN c_sch;
145: FETCH c_sch INTO v_sch_dummy_rec;
146: IF (c_sch%FOUND) THEN
147: CLOSE c_sch;

Line 193: -- IGS_RE_CANDIDATURE.

189: p_parent IN VARCHAR2 )
190: RETURN DATE AS
191: BEGIN -- resp_get_rsup_start
192: -- This module gets the date that supervision is required from for a
193: -- IGS_RE_CANDIDATURE.
194: DECLARE
195: cst_sca CONSTANT VARCHAR2(10) := 'SCA';
196: cst_acai CONSTANT VARCHAR2(10) := 'ACAI';
197: cst_rsup CONSTANT VARCHAR2(10) := 'RSUP';

Line 208: FROM IGS_RE_CANDIDATURE ca

204: SELECT ca.sca_course_cd,
205: ca.acai_admission_appl_number,
206: ca.acai_nominated_course_cd,
207: ca.acai_sequence_number
208: FROM IGS_RE_CANDIDATURE ca
209: WHERE ca.person_id = p_person_id AND
210: ca.sequence_number = p_ca_sequence_number;
211: v_ca_rec c_ca%ROWTYPE;
212: CURSOR c_sca(

Line 224: cp_adm_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE,

220: sca.course_cd = cp_course_cd;
221: v_sca_rec c_sca%ROWTYPE;
222: v_sca_rec1 c_sca%ROWTYPE;
223: CURSOR c_acai(
224: cp_adm_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE,
225: cp_nom_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE,
226: cp_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE)
227: IS
228: SELECT acai.course_cd,

Line 225: cp_nom_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE,

221: v_sca_rec c_sca%ROWTYPE;
222: v_sca_rec1 c_sca%ROWTYPE;
223: CURSOR c_acai(
224: cp_adm_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE,
225: cp_nom_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE,
226: cp_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE)
227: IS
228: SELECT acai.course_cd,
229: acai.crv_version_number,

Line 226: cp_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE)

222: v_sca_rec1 c_sca%ROWTYPE;
223: CURSOR c_acai(
224: cp_adm_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE,
225: cp_nom_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE,
226: cp_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE)
227: IS
228: SELECT acai.course_cd,
229: acai.crv_version_number,
230: acai.adm_outcome_status,

Line 239: cp_adm_appl_num IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE)

235: acai.nominated_course_cd = cp_nom_course_cd AND
236: acai.sequence_number = cp_sequence_number;
237: v_acai_rec c_acai%ROWTYPE;
238: CURSOR c_apcs (
239: cp_adm_appl_num IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE)
240: IS
241: SELECT aa.s_admission_process_type
242: FROM IGS_AD_APPL aa,
243: IGS_AD_PRCS_CAT_STEP apcs

Line 358: -- IGS_RE_CANDIDATURE has been added through ENRF3000.

354: END IF;
355: IF v_ca_rec.acai_admission_appl_number IS NULL AND
356: v_ca_rec.acai_nominated_course_cd IS NULL AND
357: v_ca_rec.acai_sequence_number IS NULL THEN
358: -- IGS_RE_CANDIDATURE has been added through ENRF3000.
359: OPEN c_sca(v_ca_rec.sca_course_cd);
360: FETCH c_sca INTO v_sca_rec;
361: IF c_sca%NOTFOUND THEN
362: CLOSE c_sca;

Line 368: -- the IGS_RE_CANDIDATURE.

364: END IF;
365: CLOSE c_sca;
366: IF v_sca_rec.course_attempt_status = 'UNCONFIRM' THEN
367: -- There is no start date requirement for
368: -- the IGS_RE_CANDIDATURE.
369: RETURN IGS_GE_DATE.IGSDATE(NULL);
370: ELSE
371: -- Get research IGS_PS_COURSE type
372: respl_get_rsch_cty (

Line 519: -- the reasearch IGS_RE_CANDIDATURE.

515: p_out_acai_sequence_number OUT NOCOPY NUMBER )
516: AS
517: BEGIN -- resp_get_sca_ca_acai
518: -- Return the admission IGS_PS_COURSE application instance to be used for
519: -- the reasearch IGS_RE_CANDIDATURE.
520: DECLARE
521: CURSOR c_sca IS
522: SELECT sca.adm_admission_appl_number,
523: sca.adm_nominated_course_cd,

Line 526: IGS_RE_CANDIDATURE ca

522: SELECT sca.adm_admission_appl_number,
523: sca.adm_nominated_course_cd,
524: sca.adm_sequence_number
525: FROM IGS_EN_STDNT_PS_ATT sca,
526: IGS_RE_CANDIDATURE ca
527: WHERE sca.person_id = p_person_id AND
528: sca.course_cd = p_course_cd AND
529: ca.person_id = sca.person_id AND
530: ca.sca_course_cd = sca.course_cd;

Line 582: v_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;

578: -- less Days prior to the IGS_PS_COURSE commencement date, where the date is
579: -- within the teaching period
580: DECLARE
581: v_research_unit_ind IGS_PS_UNIT_VER.research_unit_ind%TYPE;
582: v_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;
583: v_acai_admission_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE;
584: v_acai_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE;
585: v_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE;
586: v_ca_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;

Line 583: v_acai_admission_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE;

579: -- within the teaching period
580: DECLARE
581: v_research_unit_ind IGS_PS_UNIT_VER.research_unit_ind%TYPE;
582: v_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;
583: v_acai_admission_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE;
584: v_acai_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE;
585: v_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE;
586: v_ca_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
587: v_commencement_dt DATE;

Line 584: v_acai_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE;

580: DECLARE
581: v_research_unit_ind IGS_PS_UNIT_VER.research_unit_ind%TYPE;
582: v_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;
583: v_acai_admission_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE;
584: v_acai_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE;
585: v_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE;
586: v_ca_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
587: v_commencement_dt DATE;
588: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;

Line 585: v_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE;

581: v_research_unit_ind IGS_PS_UNIT_VER.research_unit_ind%TYPE;
582: v_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;
583: v_acai_admission_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE;
584: v_acai_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE;
585: v_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE;
586: v_ca_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
587: v_commencement_dt DATE;
588: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
589: v_sca_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;

Line 586: v_ca_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;

582: v_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;
583: v_acai_admission_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE;
584: v_acai_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE;
585: v_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE;
586: v_ca_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
587: v_commencement_dt DATE;
588: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
589: v_sca_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
590: v_record_found BOOLEAN DEFAULT FALSE;

Line 592: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;

588: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
589: v_sca_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
590: v_record_found BOOLEAN DEFAULT FALSE;
591: v_cah2_hist_end_dt IGS_RE_CDT_ATT_HIST.hist_end_dt%TYPE;
592: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
593: v_tp_days NUMBER;
594: v_effective_start_dt DATE;
595: v_effective_end_dt DATE;
596: v_attendance_percentage NUMBER;

Line 620: FROM IGS_RE_CANDIDATURE ca

616: ca.sca_course_cd,
617: ca.acai_admission_appl_number,
618: ca.acai_nominated_course_cd,
619: ca.acai_sequence_number
620: FROM IGS_RE_CANDIDATURE ca
621: WHERE ca.person_id = p_person_id AND
622: ca.sca_course_cd = p_course_cd;
623: CURSOR c_sca IS
624: SELECT sca.attendance_type,

Line 632: cp_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE)

628: WHERE sca.person_id = p_person_id AND
629: sca.course_cd = p_course_cd;
630: CURSOR c_cah1 (
631: cp_effective_start_dt DATE,
632: cp_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE)
633: IS
634: SELECT cah.hist_start_dt,
635: cah.hist_end_dt,
636: cah.attendance_percentage

Line 660: cp_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE,

656: eit.intermission_type = sci.intermission_type
657: ORDER BY sci.start_dt ASC;
658:
659: CURSOR c_cah2 (
660: cp_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE,
661: cp_intermit_end_dt DATE,
662: cp_intermit_start_dt DATE)
663: IS
664: SELECT cah.hist_start_dt,

Line 687: --2. Load IGS_RE_CANDIDATURE details

683: IF v_research_unit_ind = 'N' THEN
684: --IGS_PS_UNIT is not research load 'derivable'
685: RETURN 0;
686: END IF;
687: --2. Load IGS_RE_CANDIDATURE details
688: OPEN c_ca;
689: FETCH c_ca INTO
690: v_ca_sequence_number,
691: v_ca_attendance_percentage,

Line 698: --If no IGS_RE_CANDIDATURE then the student is not a research student

694: v_acai_nominated_course_cd,
695: v_acai_sequence_number;
696: IF c_ca%NOTFOUND THEN
697: CLOSE c_ca;
698: --If no IGS_RE_CANDIDATURE then the student is not a research student
699: RETURN 0;
700: END IF;
701: CLOSE c_ca;
702: --3. Get the commencement date - this routine handles both enrolled students

Line 991: -- or not data exists on IGS_RE_CANDIDATURE detail tables for the

987: p_milestone_exists OUT NOCOPY boolean )
988: AS
989: BEGIN -- resp_get_the_exists
990: -- This modulew returns output oarameters indicating whether
991: -- or not data exists on IGS_RE_CANDIDATURE detail tables for the
992: -- specified IGS_RE_THESIS.
993: DECLARE
994: v_the_found VARCHAR2(1);
995: v_mil_found VARCHAR2(1);

Line 1134: -- IGS_RE_CANDIDATURE.attendance_percentage is changed. The following is validated:

1130: p_message_name OUT NOCOPY VARCHAR2 )
1131: RETURN BOOLEAN AS
1132: BEGIN -- resp_ins_ca_cah
1133: -- This modules inserts into IGS_RE_CDT_ATT_HIST when
1134: -- IGS_RE_CANDIDATURE.attendance_percentage is changed. The following is validated:
1135: -- IGS_RE_CANDIDATURE requires attendance history details to be retained.
1136: DECLARE
1137: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
1138: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;

Line 1135: -- IGS_RE_CANDIDATURE requires attendance history details to be retained.

1131: RETURN BOOLEAN AS
1132: BEGIN -- resp_ins_ca_cah
1133: -- This modules inserts into IGS_RE_CDT_ATT_HIST when
1134: -- IGS_RE_CANDIDATURE.attendance_percentage is changed. The following is validated:
1135: -- IGS_RE_CANDIDATURE requires attendance history details to be retained.
1136: DECLARE
1137: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
1138: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
1139: v_message_name VARCHAR2(30);

Line 1141: v_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;

1137: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
1138: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
1139: v_message_name VARCHAR2(30);
1140: v_hist_end_dt IGS_RE_CDT_ATT_HIST.hist_end_dt%TYPE;
1141: v_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
1142: v_hist_start_dt IGS_RE_CDT_ATT_HIST.hist_start_dt%TYPE;
1143: v_sequence_number IGS_RE_CDT_ATT_HIST.sequence_number%TYPE;
1144:
1145: LV_ROWID VARCHAR2(25);

Line 1160: -- Validate that IGS_RE_CANDIDATURE attendance history is required

1156: WHERE cah2.person_id = p_person_id AND
1157: cah2.ca_sequence_number = p_ca_sequence_number;
1158: BEGIN
1159: p_message_name := NULL;
1160: -- Validate that IGS_RE_CANDIDATURE attendance history is required
1161: IF IGS_RE_VAL_CAH.resp_val_cah_ca_ins(
1162: p_person_id,
1163: p_ca_sequence_number,
1164: p_sca_course_cd,

Line 1168: --IGS_RE_CANDIDATURE attendance history is not retained yet

1164: p_sca_course_cd,
1165: v_commencement_dt,
1166: v_attendance_type,
1167: v_message_name) = FALSE THEN
1168: --IGS_RE_CANDIDATURE attendance history is not retained yet
1169: RETURN TRUE;
1170: END IF;
1171: -- Determine attendance percentage
1172: v_attendance_percentage := IGS_RE_GEN_001.resp_get_ca_att(

Line 1226: -- Warn that IGS_RE_CANDIDATURE attendance history has been inserted

1222: X_ATTENDANCE_PERCENTAGE => v_attendance_percentage,
1223: X_ORG_ID => v_org_id,
1224: X_MODE => 'R');
1225:
1226: -- Warn that IGS_RE_CANDIDATURE attendance history has been inserted
1227: p_message_name := 'IGS_RE_CAND_ATT_HIST_INSERTED';
1228: RETURN TRUE;
1229: EXCEPTION
1230: WHEN OTHERS THEN

Line 1275: -- Description: Insert IGS_RE_CANDIDATURE history (IGS_RE_CDT_HIST)

1271: AS
1272: LV_ROWID VARCHAR2(25);
1273: v_org_id igs_re_cdt_att_hist.org_id%TYPE;
1274: BEGIN -- resp_ins_ca_hist
1275: -- Description: Insert IGS_RE_CANDIDATURE history (IGS_RE_CDT_HIST)
1276: v_org_id := IGS_GE_GEN_003.Get_Org_Id;
1277: DECLARE
1278: r_ch IGS_RE_CDT_HIST%ROWTYPE;
1279: v_create_history BOOLEAN := FALSE;

Line 1388: -- Insert default milestones against a IGS_RE_CANDIDATURE based on their

1384: *******************************************************************************/
1385: LV_ROWID VARCHAR2(25);
1386: v_org_id igs_re_cdt_att_hist.org_id%TYPE;
1387: BEGIN -- resp_ins_dflt_mil
1388: -- Insert default milestones against a IGS_RE_CANDIDATURE based on their
1389: -- IGS_PS_COURSE version.
1390: v_org_id := IGS_GE_GEN_003.Get_Org_Id;
1391:
1392: DECLARE

Line 1395: v_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;

1391:
1392: DECLARE
1393: cst_planned CONSTANT VARCHAR2(10) := 'PLANNED';
1394: v_dummy VARCHAR2(1);
1395: v_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;
1396: v_acai_admission_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE;
1397: v_acai_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE;
1398: v_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE;
1399: v_crv_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

Line 1396: v_acai_admission_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE;

1392: DECLARE
1393: cst_planned CONSTANT VARCHAR2(10) := 'PLANNED';
1394: v_dummy VARCHAR2(1);
1395: v_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;
1396: v_acai_admission_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE;
1397: v_acai_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE;
1398: v_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE;
1399: v_crv_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
1400: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;

Line 1397: v_acai_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE;

1393: cst_planned CONSTANT VARCHAR2(10) := 'PLANNED';
1394: v_dummy VARCHAR2(1);
1395: v_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;
1396: v_acai_admission_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE;
1397: v_acai_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE;
1398: v_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE;
1399: v_crv_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
1400: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
1401: v_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;

Line 1398: v_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE;

1394: v_dummy VARCHAR2(1);
1395: v_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE;
1396: v_acai_admission_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE;
1397: v_acai_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE;
1398: v_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE;
1399: v_crv_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
1400: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
1401: v_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
1402: v_milestone_status IGS_PR_MS_STAT.milestone_status%TYPE;

Line 1423: FROM IGS_RE_CANDIDATURE ca

1419: SELECT ca.sca_course_cd,
1420: ca.acai_admission_appl_number,
1421: ca.acai_nominated_course_cd,
1422: ca.acai_sequence_number
1423: FROM IGS_RE_CANDIDATURE ca
1424: WHERE ca.person_id = p_person_id AND
1425: ca.sequence_number = p_ca_sequence_number;
1426: CURSOR c_sca (
1427: cp_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE) IS

Line 1427: cp_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE) IS

1423: FROM IGS_RE_CANDIDATURE ca
1424: WHERE ca.person_id = p_person_id AND
1425: ca.sequence_number = p_ca_sequence_number;
1426: CURSOR c_sca (
1427: cp_sca_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE) IS
1428: SELECT sca.version_number,
1429: sca.attendance_type
1430: FROM IGS_EN_STDNT_PS_ATT sca
1431: WHERE sca.person_id = p_person_id AND

Line 1434: cp_acai_admission_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE,

1430: FROM IGS_EN_STDNT_PS_ATT sca
1431: WHERE sca.person_id = p_person_id AND
1432: sca.course_cd = cp_sca_course_cd;
1433: CURSOR c_acai (
1434: cp_acai_admission_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE,
1435: cp_acai_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE,
1436: cp_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE) IS
1437: SELECT acai.course_cd,
1438: acai.crv_version_number,

Line 1435: cp_acai_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE,

1431: WHERE sca.person_id = p_person_id AND
1432: sca.course_cd = cp_sca_course_cd;
1433: CURSOR c_acai (
1434: cp_acai_admission_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE,
1435: cp_acai_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE,
1436: cp_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE) IS
1437: SELECT acai.course_cd,
1438: acai.crv_version_number,
1439: acai.attendance_type

Line 1436: cp_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE) IS

1432: sca.course_cd = cp_sca_course_cd;
1433: CURSOR c_acai (
1434: cp_acai_admission_appl_number IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE,
1435: cp_acai_nominated_course_cd IGS_RE_CANDIDATURE.acai_nominated_course_cd%TYPE,
1436: cp_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE) IS
1437: SELECT acai.course_cd,
1438: acai.crv_version_number,
1439: acai.attendance_type
1440: FROM IGS_AD_PS_APPL_INST acai

Line 1472: -- 2. Load details from the IGS_RE_CANDIDATURE table.

1468: BEGIN
1469: -- Set default value
1470: p_message_name := null;
1471: v_records_inserted := 0;
1472: -- 2. Load details from the IGS_RE_CANDIDATURE table.
1473: OPEN c_ca_detail;
1474: FETCH c_ca_detail INTO v_sca_course_cd,
1475: v_acai_admission_appl_number,
1476: v_acai_nominated_course_cd,