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_GEN_012 dependencies on IGS_EN_SU_ATTEMPT

Line 10: --pradhakr 16-Dec-2002 Changed the call to the update_row of igs_en_su_attempt

6: --ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure
7: call as a part of bug 3544927.
8: --npalanis 10-JUN-2003 Bug:2923413 igs_pe_typ_instances_pkgs call
9: -- modified for the new employment category column added in the table
10: --pradhakr 16-Dec-2002 Changed the call to the update_row of igs_en_su_attempt
11: -- table to igs_en_sua_api.update_unit_attempt.
12: -- Changes wrt ENCR031 build. Bug#2643207
13: --nalkumar 05-OCT-2001 Modified the IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW call.
14: -- Added four new parameters to call it as per the Bug# 2027984.

Line 15: --Aiyer 10-Oct-2001 Added the column grading schema in all Tbh calls of IGS_EN_SU_ATTEMPT_PKG as a part of the bug 2037897.

11: -- table to igs_en_sua_api.update_unit_attempt.
12: -- Changes wrt ENCR031 build. Bug#2643207
13: --nalkumar 05-OCT-2001 Modified the IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW call.
14: -- Added four new parameters to call it as per the Bug# 2027984.
15: --Aiyer 10-Oct-2001 Added the column grading schema in all Tbh calls of IGS_EN_SU_ATTEMPT_PKG as a part of the bug 2037897.
16: --pradhakr 07-Dec-2001 Added a column deg_aud_detail_id in the TBH calls
17: -- of IGS_EN_SU_ATTEMPT_PKG as part of
18: -- Degree Audit Interface build.(Bug# 2033208)
19: --svenkata 20-Dec-2001 Added columns student_career_transcript and Student_career_statistics as part of build Career

Line 17: -- of IGS_EN_SU_ATTEMPT_PKG as part of

13: --nalkumar 05-OCT-2001 Modified the IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW call.
14: -- Added four new parameters to call it as per the Bug# 2027984.
15: --Aiyer 10-Oct-2001 Added the column grading schema in all Tbh calls of IGS_EN_SU_ATTEMPT_PKG as a part of the bug 2037897.
16: --pradhakr 07-Dec-2001 Added a column deg_aud_detail_id in the TBH calls
17: -- of IGS_EN_SU_ATTEMPT_PKG as part of
18: -- Degree Audit Interface build.(Bug# 2033208)
19: --svenkata 20-Dec-2001 Added columns student_career_transcript and Student_career_statistics as part of build Career
20: -- Impact Part2 . Bug #2158626
21: --svenkata 07-JAN-2002 Bug No. 2172405 Standard Flex Field columns have been added

Line 23: --Nishikant 29-jan-2002 Added the column session_id in the Tbh calls of IGS_EN_SU_ATTEMPT_PKG

19: --svenkata 20-Dec-2001 Added columns student_career_transcript and Student_career_statistics as part of build Career
20: -- Impact Part2 . Bug #2158626
21: --svenkata 07-JAN-2002 Bug No. 2172405 Standard Flex Field columns have been added
22: -- to table handler procedure calls as part of CCR - ENCR022.
23: --Nishikant 29-jan-2002 Added the column session_id in the Tbh calls of IGS_EN_SU_ATTEMPT_PKG
24: -- as a part of the bug 2172380.
25: --mesriniv 12-sep-2002 Added a new parameter waitlist_manual_ind in TBH call of IGS_EN_SU_ATTEMPT
26: -- for Bug 2554109 MINI Waitlist Build for Jan 03 Release
27: -- Added refernces to column ORG_UNIT_CD incall to IGS_EN_SU_ATTEMPT TBH call as a part of bug 1964697

Line 25: --mesriniv 12-sep-2002 Added a new parameter waitlist_manual_ind in TBH call of IGS_EN_SU_ATTEMPT

21: --svenkata 07-JAN-2002 Bug No. 2172405 Standard Flex Field columns have been added
22: -- to table handler procedure calls as part of CCR - ENCR022.
23: --Nishikant 29-jan-2002 Added the column session_id in the Tbh calls of IGS_EN_SU_ATTEMPT_PKG
24: -- as a part of the bug 2172380.
25: --mesriniv 12-sep-2002 Added a new parameter waitlist_manual_ind in TBH call of IGS_EN_SU_ATTEMPT
26: -- for Bug 2554109 MINI Waitlist Build for Jan 03 Release
27: -- Added refernces to column ORG_UNIT_CD incall to IGS_EN_SU_ATTEMPT TBH call as a part of bug 1964697
28: --Bayadav 05-May-2002 Included code in ENRP_UPD_SCA_STATUS proc to pass message back to IGSEN036 as a part of
29: -- bug 2335633 to indicate the program attempt status has changed.

Line 27: -- Added refernces to column ORG_UNIT_CD incall to IGS_EN_SU_ATTEMPT TBH call as a part of bug 1964697

23: --Nishikant 29-jan-2002 Added the column session_id in the Tbh calls of IGS_EN_SU_ATTEMPT_PKG
24: -- as a part of the bug 2172380.
25: --mesriniv 12-sep-2002 Added a new parameter waitlist_manual_ind in TBH call of IGS_EN_SU_ATTEMPT
26: -- for Bug 2554109 MINI Waitlist Build for Jan 03 Release
27: -- Added refernces to column ORG_UNIT_CD incall to IGS_EN_SU_ATTEMPT TBH call as a part of bug 1964697
28: --Bayadav 05-May-2002 Included code in ENRP_UPD_SCA_STATUS proc to pass message back to IGSEN036 as a part of
29: -- bug 2335633 to indicate the program attempt status has changed.
30: --Nishikant 15-may-2002 Condition in an IF clause in the function Enrp_Upd_Sca_Discont modified as part of the bug#2364216.
31: --PKPATEL/SSAWHNEY 04-OCT-2002 Bug No: 2600842

Line 45: -- IGS_EN_SU_ATTEMPT_PKG procedures and consequently to IGS_EN_SUA_API procedures

41: --svanukur 26-jun-2003 Passing discontinued date with a nvl substitution of sysdate in the call to the update_row api of
42: -- ig_en_su_attmept in case of a "dropped" unit attempt status as part of bug 2898213.
43: --smaddali 04-jul-03 modified procedure enrp_upd_sca_coo for bug 3035523 , to update igs_he_st_spa_all.version_number
44: --rvivekan 3-SEP-2003 Waitlist Enhacements build # 3052426. 2 new columns added to
45: -- IGS_EN_SU_ATTEMPT_PKG procedures and consequently to IGS_EN_SUA_API procedures
46: --rvangala 07-OCT-2003 Value for CORE_INDICATOR_CODE passed to IGS_EN_SUA_API.UPDATE_UNIT_ATTEMPT
47: -- and IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW, added as part of Prevent Dropping Core Units. Enh Bug# 3052432
48: --ptandon 05-DEC-2003 Modified cursor c_sua in Function Enrp_Upd_Sca_Discont as per Placements build. Bug# 3052438.
49: --vkarthik 19-Apr-2004 Modified exception handling section to handle no_ausl_record_found

Line 47: -- and IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW, added as part of Prevent Dropping Core Units. Enh Bug# 3052432

43: --smaddali 04-jul-03 modified procedure enrp_upd_sca_coo for bug 3035523 , to update igs_he_st_spa_all.version_number
44: --rvivekan 3-SEP-2003 Waitlist Enhacements build # 3052426. 2 new columns added to
45: -- IGS_EN_SU_ATTEMPT_PKG procedures and consequently to IGS_EN_SUA_API procedures
46: --rvangala 07-OCT-2003 Value for CORE_INDICATOR_CODE passed to IGS_EN_SUA_API.UPDATE_UNIT_ATTEMPT
47: -- and IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW, added as part of Prevent Dropping Core Units. Enh Bug# 3052432
48: --ptandon 05-DEC-2003 Modified cursor c_sua in Function Enrp_Upd_Sca_Discont as per Placements build. Bug# 3052438.
49: --vkarthik 19-Apr-2004 Modified exception handling section to handle no_ausl_record_found
50: for bug 3526251 in Enrp_Upd_Sca_Discont
51: --amuthu 21-NOV-2004 Modifed as part of program transfer build. When the program transfer is done the enrolled units are

Line 834: || kkillams 28-04-2003 Modified c_suao_check,c_sua_drop and c_igs_en_su_attempt cursors in this function

830: || kkillams 21-03-2003 Added new parameter p_transf_course_cd to the function.
831: || Which will distigush the from where this function was called.
832: || Value will be passed if function is invoked from program transfer
833: || else null value wil come w.r.t bug 2863707
834: || kkillams 28-04-2003 Modified c_suao_check,c_sua_drop and c_igs_en_su_attempt cursors in this function
835: || due to change in pk of student unit attempt w.r.t. bug number 2829262
836: || rvangala 07-OCT-2003 Value for CORE_INDICATOR_CODE passed to IGS_EN_SUA_API.UPDATE_UNIT_ATTEMPT
837: || and IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW, added as part of Prevent Dropping Core Units. Enh Bug# 3052432
838: || ptandon 05-DEC-2003 Modified the cursor c_sua to include the order by clause to select the subordinate units first

Line 837: || and IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW, added as part of Prevent Dropping Core Units. Enh Bug# 3052432

833: || else null value wil come w.r.t bug 2863707
834: || kkillams 28-04-2003 Modified c_suao_check,c_sua_drop and c_igs_en_su_attempt cursors in this function
835: || due to change in pk of student unit attempt w.r.t. bug number 2829262
836: || rvangala 07-OCT-2003 Value for CORE_INDICATOR_CODE passed to IGS_EN_SUA_API.UPDATE_UNIT_ATTEMPT
837: || and IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW, added as part of Prevent Dropping Core Units. Enh Bug# 3052432
838: || ptandon 05-DEC-2003 Modified the cursor c_sua to include the order by clause to select the subordinate units first
839: || for discontinuation. Placements build. Bug# 3052438.
840: || vkarthik 19-Apr-2004 Modified exception handling section to handle no_ausl_record_found
841: || for bug 3526251

Line 849: v_administrative_unit_status IGS_EN_SU_ATTEMPT.ADMINISTRATIVE_UNIT_STATUS%TYPE;

845: BEGIN
846: DECLARE
847: v_discontinuation_reason_cd IGS_EN_STDNT_PS_ATT.discontinuation_reason_cd%TYPE;
848: v_description IGS_EN_DCNT_REASONCD.description%TYPE;
849: v_administrative_unit_status IGS_EN_SU_ATTEMPT.ADMINISTRATIVE_UNIT_STATUS%TYPE;
850: v_suao_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE;
851: v_sca_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
852: v_alias_val DATE;
853: v_message_name VARCHAR2(30);

Line 882: FROM IGS_EN_SU_ATTEMPT sua

878: sua.ci_start_dt,
879: sua.enrolled_dt,
880: sua.unit_attempt_status,
881: sua.uoo_id
882: FROM IGS_EN_SU_ATTEMPT sua
883: WHERE sua.person_id = cp_person_id AND
884: sua.course_cd = cp_course_cd AND
885: sua.unit_attempt_status IN (cst_enrolled,cst_waitlisted)
886: ORDER BY sup_unit_cd ASC

Line 892: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS

888:
889: CURSOR c_suao_check
890: (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
891: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
892: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
893: SELECT suao.person_id
894: FROM IGS_AS_SU_STMPTOUT suao
895: WHERE suao.person_id = cp_person_id AND
896: suao.course_cd = cp_course_cd AND

Line 941: -- a) check to see if a IGS_EN_SU_ATTEMPT can be deleted

937: BEGIN
938: -- This module updates the IGS_EN_STDNT_PS_ATT future dated
939: -- discontinuation. This will need to do the following :
940: -- 1. Discontinue/delete currently enrolled student_unit_attmmpts :
941: -- a) check to see if a IGS_EN_SU_ATTEMPT can be deleted
942: -- as defined by IGS_PS_UNIT Discontinuation date Criteria
943: -- b) if deletion is allowed, delete
944: -- c) if deletion is not allowed, then discontinue
945: -- IGS_EN_SU_ATTEMPT

Line 945: -- IGS_EN_SU_ATTEMPT

941: -- a) check to see if a IGS_EN_SU_ATTEMPT can be deleted
942: -- as defined by IGS_PS_UNIT Discontinuation date Criteria
943: -- b) if deletion is allowed, delete
944: -- c) if deletion is not allowed, then discontinue
945: -- IGS_EN_SU_ATTEMPT
946: -- i) get administrative IGS_PS_UNIT status
947: -- ii) validate that the IGS_EN_SU_ATTEMPT
948: -- can be discontinued
949: -- iii) set IGS_EN_SU_ATTEMPT discontinuation

Line 947: -- ii) validate that the IGS_EN_SU_ATTEMPT

943: -- b) if deletion is allowed, delete
944: -- c) if deletion is not allowed, then discontinue
945: -- IGS_EN_SU_ATTEMPT
946: -- i) get administrative IGS_PS_UNIT status
947: -- ii) validate that the IGS_EN_SU_ATTEMPT
948: -- can be discontinued
949: -- iii) set IGS_EN_SU_ATTEMPT discontinuation
950: -- details
951: -- iv) set IGS_EN_SU_ATTEMPT.unit_attempt_status

Line 949: -- iii) set IGS_EN_SU_ATTEMPT discontinuation

945: -- IGS_EN_SU_ATTEMPT
946: -- i) get administrative IGS_PS_UNIT status
947: -- ii) validate that the IGS_EN_SU_ATTEMPT
948: -- can be discontinued
949: -- iii) set IGS_EN_SU_ATTEMPT discontinuation
950: -- details
951: -- iv) set IGS_EN_SU_ATTEMPT.unit_attempt_status
952: -- (this is done by table database trigger)
953: -- 2. Validate that the IGS_EN_STDNT_PS_ATT can be

Line 951: -- iv) set IGS_EN_SU_ATTEMPT.unit_attempt_status

947: -- ii) validate that the IGS_EN_SU_ATTEMPT
948: -- can be discontinued
949: -- iii) set IGS_EN_SU_ATTEMPT discontinuation
950: -- details
951: -- iv) set IGS_EN_SU_ATTEMPT.unit_attempt_status
952: -- (this is done by table database trigger)
953: -- 2. Validate that the IGS_EN_STDNT_PS_ATT can be
954: -- discontinued
955: -- 3. Discontinue IGS_EN_STDNT_PS_ATT, setting default

Line 990: -- delete the IGS_EN_SU_ATTEMPT if allowed

986:
987: FOR v_sua IN c_sua(
988: p_person_id,
989: p_course_cd) LOOP
990: -- delete the IGS_EN_SU_ATTEMPT if allowed
991: -- Added the OR clause in the below If condtion OR unit_attempt status is WAITLISTED
992: -- Added by Nishikant - bug#2364216. If the status is WAITLISTED then no need to check whether the unit attempt can be deleted
993: IF (Igs_En_Gen_008.enrp_get_ua_del_alwd(
994: v_sua.cal_type,

Line 1002: -- be performed on the IGS_EN_SU_ATTEMPT

998: OR p_transf_course_cd IS NOT NULL) THEN
999: -- check to see whether child
1000: -- IGS_AS_SU_STMPTOUT records
1001: -- exist, otherwise a delete can not
1002: -- be performed on the IGS_EN_SU_ATTEMPT
1003: -- table
1004: OPEN c_suao_check(
1005: p_person_id,
1006: p_course_cd,

Line 1017: -- delete IGS_EN_SU_ATTEMPT

1013: p_message_name := 'IGS_EN_ONE_SUA_NOT_DISCONT';
1014: RETURN FALSE;
1015: ELSE
1016: CLOSE c_suao_check;
1017: -- delete IGS_EN_SU_ATTEMPT
1018: -- The logic of deleting the Unit attempt status
1019: -- when trying to discontinue has been modified
1020: -- to Update the Record with the Unit Attempt status
1021: -- set to DROPPED

Line 1030: FROM IGS_EN_SU_ATTEMPT sua

1026: v_uoo_ids VARCHAR2(4000);
1027: tr_flag NUMBER(1);
1028: CURSOR c_sua_drop IS
1029: SELECT sua.ROWID, sua.*
1030: FROM IGS_EN_SU_ATTEMPT sua
1031: WHERE person_id = p_person_id AND
1032: course_cd = p_course_cd AND
1033: uoo_id = v_sua.uoo_id;
1034: CURSOR c_trans_cd(cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS

Line 1034: CURSOR c_trans_cd(cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS

1030: FROM IGS_EN_SU_ATTEMPT sua
1031: WHERE person_id = p_person_id AND
1032: course_cd = p_course_cd AND
1033: uoo_id = v_sua.uoo_id;
1034: CURSOR c_trans_cd(cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
1035: SELECT 1
1036: FROM IGS_EN_SU_ATTEMPT sua
1037: WHERE person_id = p_person_id
1038: AND course_cd = p_transf_course_cd

Line 1036: FROM IGS_EN_SU_ATTEMPT sua

1032: course_cd = p_course_cd AND
1033: uoo_id = v_sua.uoo_id;
1034: CURSOR c_trans_cd(cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
1035: SELECT 1
1036: FROM IGS_EN_SU_ATTEMPT sua
1037: WHERE person_id = p_person_id
1038: AND course_cd = p_transf_course_cd
1039: AND uoo_id = cp_uoo_id
1040: AND unit_Attempt_status <> 'DROPPED';

Line 1083: X_UNIT_ATTEMPT_STATUS => cst_dropped, -- c_IGS_EN_SU_ATTEMPT_rec.UNIT_ATTEMPT_STATUS,

1079: X_CI_START_DT => sua_drop_rec.CI_START_DT,
1080: X_CI_END_DT => sua_drop_rec.CI_END_DT,
1081: X_UOO_ID => sua_drop_rec.UOO_ID ,
1082: X_ENROLLED_DT => sua_drop_rec.ENROLLED_DT,
1083: X_UNIT_ATTEMPT_STATUS => cst_dropped, -- c_IGS_EN_SU_ATTEMPT_rec.UNIT_ATTEMPT_STATUS,
1084: X_ADMINISTRATIVE_UNIT_STATUS => sua_drop_rec.administrative_unit_status,
1085: X_ADMINISTRATIVE_PRIORITY => sua_drop_rec.administrative_PRIORITY,
1086: X_DISCONTINUED_DT => nvl(sua_drop_rec.discontinued_dt,trunc(SYSDATE)),
1087: X_DCNT_REASON_CD => l_dflt_disc_code,

Line 1153: IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW(

1149: p_message_name := 'IGS_EN_NO_SYS_DFLT_REASON';
1150: RETURN FALSE;
1151: END IF;
1152:
1153: IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW(
1154: X_ROWID => sua_drop_rec.ROWID,
1155: X_PERSON_ID => sua_drop_rec.PERSON_ID,
1156: X_COURSE_CD => sua_drop_rec.COURSE_CD ,
1157: X_UNIT_CD => sua_drop_rec.UNIT_CD,

Line 1167: X_UNIT_ATTEMPT_STATUS => cst_dropped, -- c_IGS_EN_SU_ATTEMPT_rec.UNIT_ATTEMPT_STATUS,

1163: X_CI_START_DT => sua_drop_rec.CI_START_DT,
1164: X_CI_END_DT => sua_drop_rec.CI_END_DT,
1165: X_UOO_ID => sua_drop_rec.UOO_ID ,
1166: X_ENROLLED_DT => sua_drop_rec.ENROLLED_DT,
1167: X_UNIT_ATTEMPT_STATUS => cst_dropped, -- c_IGS_EN_SU_ATTEMPT_rec.UNIT_ATTEMPT_STATUS,
1168: X_ADMINISTRATIVE_UNIT_STATUS => sua_drop_rec.administrative_unit_status,
1169: X_ADMINISTRATIVE_PRIORITY => sua_drop_rec.administrative_PRIORITY,
1170: X_DISCONTINUED_DT => nvl(sua_drop_rec.discontinued_dt,SYSDATE),
1171: X_DCNT_REASON_CD => l_unt_disc_code,

Line 1246: -- discontinue IGS_EN_SU_ATTEMPT

1242: END;
1243:
1244: END IF;
1245: ELSE
1246: -- discontinue IGS_EN_SU_ATTEMPT
1247: -- get administrative IGS_PS_UNIT status associated
1248: -- with discontinued
1249: v_administrative_unit_status := Igs_En_Gen_008.enrp_get_uddc_aus(
1250: p_discontinued_dt,

Line 1280: -- update IGS_EN_SU_ATTEMPT

1276: ROLLBACK TO sp_discontinue_sua;
1277: p_message_name := 'IGS_EN_ONE_SUA_NOTBE_DISCONT';
1278: RETURN FALSE;
1279: ELSE
1280: -- update IGS_EN_SU_ATTEMPT
1281:
1282: DECLARE
1283: v_unit_cds VARCHAR2(4000);
1284: v_uoo_ids VARCHAR2(4000);

Line 1285: CURSOR c_igs_en_su_attempt IS

1281:
1282: DECLARE
1283: v_unit_cds VARCHAR2(4000);
1284: v_uoo_ids VARCHAR2(4000);
1285: CURSOR c_igs_en_su_attempt IS
1286: SELECT ROWID, IGS_EN_SU_ATTEMPT.*
1287: FROM IGS_EN_SU_ATTEMPT
1288: WHERE person_id = p_person_id AND
1289: course_cd = p_course_cd AND

Line 1286: SELECT ROWID, IGS_EN_SU_ATTEMPT.*

1282: DECLARE
1283: v_unit_cds VARCHAR2(4000);
1284: v_uoo_ids VARCHAR2(4000);
1285: CURSOR c_igs_en_su_attempt IS
1286: SELECT ROWID, IGS_EN_SU_ATTEMPT.*
1287: FROM IGS_EN_SU_ATTEMPT
1288: WHERE person_id = p_person_id AND
1289: course_cd = p_course_cd AND
1290: uoo_id = v_sua.uoo_id;

Line 1287: FROM IGS_EN_SU_ATTEMPT

1283: v_unit_cds VARCHAR2(4000);
1284: v_uoo_ids VARCHAR2(4000);
1285: CURSOR c_igs_en_su_attempt IS
1286: SELECT ROWID, IGS_EN_SU_ATTEMPT.*
1287: FROM IGS_EN_SU_ATTEMPT
1288: WHERE person_id = p_person_id AND
1289: course_cd = p_course_cd AND
1290: uoo_id = v_sua.uoo_id;
1291:

Line 1296: FOR c_IGS_EN_SU_ATTEMPT_rec IN c_IGS_EN_SU_ATTEMPT LOOP

1292: BEGIN
1293: v_uoo_ids := null;
1294: v_unit_cds := null;
1295:
1296: FOR c_IGS_EN_SU_ATTEMPT_rec IN c_IGS_EN_SU_ATTEMPT LOOP
1297:
1298: --Following validation is added as part of bug fix.2860412
1299: --Cursor will checks the context unit attempt got transferred or not.
1300: --If Unit got transferred then call the direct tbh call else

Line 1317: X_ROWID => c_IGS_EN_SU_ATTEMPT_rec.ROWID,

1313: );
1314: -- Call the API to update the student unit attempt. This API is a
1315: -- wrapper to the update row of the TBH.
1316: igs_en_sua_api.update_unit_attempt(
1317: X_ROWID => c_IGS_EN_SU_ATTEMPT_rec.ROWID,
1318: X_PERSON_ID => c_IGS_EN_SU_ATTEMPT_rec.PERSON_ID,
1319: X_COURSE_CD => c_IGS_EN_SU_ATTEMPT_rec.COURSE_CD ,
1320: X_UNIT_CD => c_IGS_EN_SU_ATTEMPT_rec.UNIT_CD,
1321: X_CAL_TYPE => c_IGS_EN_SU_ATTEMPT_rec.CAL_TYPE,

Line 1318: X_PERSON_ID => c_IGS_EN_SU_ATTEMPT_rec.PERSON_ID,

1314: -- Call the API to update the student unit attempt. This API is a
1315: -- wrapper to the update row of the TBH.
1316: igs_en_sua_api.update_unit_attempt(
1317: X_ROWID => c_IGS_EN_SU_ATTEMPT_rec.ROWID,
1318: X_PERSON_ID => c_IGS_EN_SU_ATTEMPT_rec.PERSON_ID,
1319: X_COURSE_CD => c_IGS_EN_SU_ATTEMPT_rec.COURSE_CD ,
1320: X_UNIT_CD => c_IGS_EN_SU_ATTEMPT_rec.UNIT_CD,
1321: X_CAL_TYPE => c_IGS_EN_SU_ATTEMPT_rec.CAL_TYPE,
1322: X_CI_SEQUENCE_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.CI_SEQUENCE_NUMBER ,

Line 1319: X_COURSE_CD => c_IGS_EN_SU_ATTEMPT_rec.COURSE_CD ,

1315: -- wrapper to the update row of the TBH.
1316: igs_en_sua_api.update_unit_attempt(
1317: X_ROWID => c_IGS_EN_SU_ATTEMPT_rec.ROWID,
1318: X_PERSON_ID => c_IGS_EN_SU_ATTEMPT_rec.PERSON_ID,
1319: X_COURSE_CD => c_IGS_EN_SU_ATTEMPT_rec.COURSE_CD ,
1320: X_UNIT_CD => c_IGS_EN_SU_ATTEMPT_rec.UNIT_CD,
1321: X_CAL_TYPE => c_IGS_EN_SU_ATTEMPT_rec.CAL_TYPE,
1322: X_CI_SEQUENCE_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.CI_SEQUENCE_NUMBER ,
1323: X_VERSION_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.VERSION_NUMBER ,

Line 1320: X_UNIT_CD => c_IGS_EN_SU_ATTEMPT_rec.UNIT_CD,

1316: igs_en_sua_api.update_unit_attempt(
1317: X_ROWID => c_IGS_EN_SU_ATTEMPT_rec.ROWID,
1318: X_PERSON_ID => c_IGS_EN_SU_ATTEMPT_rec.PERSON_ID,
1319: X_COURSE_CD => c_IGS_EN_SU_ATTEMPT_rec.COURSE_CD ,
1320: X_UNIT_CD => c_IGS_EN_SU_ATTEMPT_rec.UNIT_CD,
1321: X_CAL_TYPE => c_IGS_EN_SU_ATTEMPT_rec.CAL_TYPE,
1322: X_CI_SEQUENCE_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.CI_SEQUENCE_NUMBER ,
1323: X_VERSION_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.VERSION_NUMBER ,
1324: X_LOCATION_CD => c_IGS_EN_SU_ATTEMPT_rec.LOCATION_CD,

Line 1321: X_CAL_TYPE => c_IGS_EN_SU_ATTEMPT_rec.CAL_TYPE,

1317: X_ROWID => c_IGS_EN_SU_ATTEMPT_rec.ROWID,
1318: X_PERSON_ID => c_IGS_EN_SU_ATTEMPT_rec.PERSON_ID,
1319: X_COURSE_CD => c_IGS_EN_SU_ATTEMPT_rec.COURSE_CD ,
1320: X_UNIT_CD => c_IGS_EN_SU_ATTEMPT_rec.UNIT_CD,
1321: X_CAL_TYPE => c_IGS_EN_SU_ATTEMPT_rec.CAL_TYPE,
1322: X_CI_SEQUENCE_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.CI_SEQUENCE_NUMBER ,
1323: X_VERSION_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.VERSION_NUMBER ,
1324: X_LOCATION_CD => c_IGS_EN_SU_ATTEMPT_rec.LOCATION_CD,
1325: X_UNIT_CLASS => c_IGS_EN_SU_ATTEMPT_rec.UNIT_CLASS ,

Line 1322: X_CI_SEQUENCE_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.CI_SEQUENCE_NUMBER ,

1318: X_PERSON_ID => c_IGS_EN_SU_ATTEMPT_rec.PERSON_ID,
1319: X_COURSE_CD => c_IGS_EN_SU_ATTEMPT_rec.COURSE_CD ,
1320: X_UNIT_CD => c_IGS_EN_SU_ATTEMPT_rec.UNIT_CD,
1321: X_CAL_TYPE => c_IGS_EN_SU_ATTEMPT_rec.CAL_TYPE,
1322: X_CI_SEQUENCE_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.CI_SEQUENCE_NUMBER ,
1323: X_VERSION_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.VERSION_NUMBER ,
1324: X_LOCATION_CD => c_IGS_EN_SU_ATTEMPT_rec.LOCATION_CD,
1325: X_UNIT_CLASS => c_IGS_EN_SU_ATTEMPT_rec.UNIT_CLASS ,
1326: X_CI_START_DT => c_IGS_EN_SU_ATTEMPT_rec.CI_START_DT,

Line 1323: X_VERSION_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.VERSION_NUMBER ,

1319: X_COURSE_CD => c_IGS_EN_SU_ATTEMPT_rec.COURSE_CD ,
1320: X_UNIT_CD => c_IGS_EN_SU_ATTEMPT_rec.UNIT_CD,
1321: X_CAL_TYPE => c_IGS_EN_SU_ATTEMPT_rec.CAL_TYPE,
1322: X_CI_SEQUENCE_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.CI_SEQUENCE_NUMBER ,
1323: X_VERSION_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.VERSION_NUMBER ,
1324: X_LOCATION_CD => c_IGS_EN_SU_ATTEMPT_rec.LOCATION_CD,
1325: X_UNIT_CLASS => c_IGS_EN_SU_ATTEMPT_rec.UNIT_CLASS ,
1326: X_CI_START_DT => c_IGS_EN_SU_ATTEMPT_rec.CI_START_DT,
1327: X_CI_END_DT => c_IGS_EN_SU_ATTEMPT_rec.CI_END_DT,

Line 1324: X_LOCATION_CD => c_IGS_EN_SU_ATTEMPT_rec.LOCATION_CD,

1320: X_UNIT_CD => c_IGS_EN_SU_ATTEMPT_rec.UNIT_CD,
1321: X_CAL_TYPE => c_IGS_EN_SU_ATTEMPT_rec.CAL_TYPE,
1322: X_CI_SEQUENCE_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.CI_SEQUENCE_NUMBER ,
1323: X_VERSION_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.VERSION_NUMBER ,
1324: X_LOCATION_CD => c_IGS_EN_SU_ATTEMPT_rec.LOCATION_CD,
1325: X_UNIT_CLASS => c_IGS_EN_SU_ATTEMPT_rec.UNIT_CLASS ,
1326: X_CI_START_DT => c_IGS_EN_SU_ATTEMPT_rec.CI_START_DT,
1327: X_CI_END_DT => c_IGS_EN_SU_ATTEMPT_rec.CI_END_DT,
1328: X_UOO_ID => c_IGS_EN_SU_ATTEMPT_rec.UOO_ID ,

Line 1325: X_UNIT_CLASS => c_IGS_EN_SU_ATTEMPT_rec.UNIT_CLASS ,

1321: X_CAL_TYPE => c_IGS_EN_SU_ATTEMPT_rec.CAL_TYPE,
1322: X_CI_SEQUENCE_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.CI_SEQUENCE_NUMBER ,
1323: X_VERSION_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.VERSION_NUMBER ,
1324: X_LOCATION_CD => c_IGS_EN_SU_ATTEMPT_rec.LOCATION_CD,
1325: X_UNIT_CLASS => c_IGS_EN_SU_ATTEMPT_rec.UNIT_CLASS ,
1326: X_CI_START_DT => c_IGS_EN_SU_ATTEMPT_rec.CI_START_DT,
1327: X_CI_END_DT => c_IGS_EN_SU_ATTEMPT_rec.CI_END_DT,
1328: X_UOO_ID => c_IGS_EN_SU_ATTEMPT_rec.UOO_ID ,
1329: X_ENROLLED_DT => c_IGS_EN_SU_ATTEMPT_rec.ENROLLED_DT,

Line 1326: X_CI_START_DT => c_IGS_EN_SU_ATTEMPT_rec.CI_START_DT,

1322: X_CI_SEQUENCE_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.CI_SEQUENCE_NUMBER ,
1323: X_VERSION_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.VERSION_NUMBER ,
1324: X_LOCATION_CD => c_IGS_EN_SU_ATTEMPT_rec.LOCATION_CD,
1325: X_UNIT_CLASS => c_IGS_EN_SU_ATTEMPT_rec.UNIT_CLASS ,
1326: X_CI_START_DT => c_IGS_EN_SU_ATTEMPT_rec.CI_START_DT,
1327: X_CI_END_DT => c_IGS_EN_SU_ATTEMPT_rec.CI_END_DT,
1328: X_UOO_ID => c_IGS_EN_SU_ATTEMPT_rec.UOO_ID ,
1329: X_ENROLLED_DT => c_IGS_EN_SU_ATTEMPT_rec.ENROLLED_DT,
1330: X_UNIT_ATTEMPT_STATUS => cst_discontinue, -- c_IGS_EN_SU_ATTEMPT_rec.UNIT_ATTEMPT_STATUS,

Line 1327: X_CI_END_DT => c_IGS_EN_SU_ATTEMPT_rec.CI_END_DT,

1323: X_VERSION_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.VERSION_NUMBER ,
1324: X_LOCATION_CD => c_IGS_EN_SU_ATTEMPT_rec.LOCATION_CD,
1325: X_UNIT_CLASS => c_IGS_EN_SU_ATTEMPT_rec.UNIT_CLASS ,
1326: X_CI_START_DT => c_IGS_EN_SU_ATTEMPT_rec.CI_START_DT,
1327: X_CI_END_DT => c_IGS_EN_SU_ATTEMPT_rec.CI_END_DT,
1328: X_UOO_ID => c_IGS_EN_SU_ATTEMPT_rec.UOO_ID ,
1329: X_ENROLLED_DT => c_IGS_EN_SU_ATTEMPT_rec.ENROLLED_DT,
1330: X_UNIT_ATTEMPT_STATUS => cst_discontinue, -- c_IGS_EN_SU_ATTEMPT_rec.UNIT_ATTEMPT_STATUS,
1331: X_ADMINISTRATIVE_UNIT_STATUS => v_administrative_unit_status,

Line 1328: X_UOO_ID => c_IGS_EN_SU_ATTEMPT_rec.UOO_ID ,

1324: X_LOCATION_CD => c_IGS_EN_SU_ATTEMPT_rec.LOCATION_CD,
1325: X_UNIT_CLASS => c_IGS_EN_SU_ATTEMPT_rec.UNIT_CLASS ,
1326: X_CI_START_DT => c_IGS_EN_SU_ATTEMPT_rec.CI_START_DT,
1327: X_CI_END_DT => c_IGS_EN_SU_ATTEMPT_rec.CI_END_DT,
1328: X_UOO_ID => c_IGS_EN_SU_ATTEMPT_rec.UOO_ID ,
1329: X_ENROLLED_DT => c_IGS_EN_SU_ATTEMPT_rec.ENROLLED_DT,
1330: X_UNIT_ATTEMPT_STATUS => cst_discontinue, -- c_IGS_EN_SU_ATTEMPT_rec.UNIT_ATTEMPT_STATUS,
1331: X_ADMINISTRATIVE_UNIT_STATUS => v_administrative_unit_status,
1332: X_ADMINISTRATIVE_PRIORITY => c_IGS_EN_SU_ATTEMPT_rec.administrative_PRIORITY,

Line 1329: X_ENROLLED_DT => c_IGS_EN_SU_ATTEMPT_rec.ENROLLED_DT,

1325: X_UNIT_CLASS => c_IGS_EN_SU_ATTEMPT_rec.UNIT_CLASS ,
1326: X_CI_START_DT => c_IGS_EN_SU_ATTEMPT_rec.CI_START_DT,
1327: X_CI_END_DT => c_IGS_EN_SU_ATTEMPT_rec.CI_END_DT,
1328: X_UOO_ID => c_IGS_EN_SU_ATTEMPT_rec.UOO_ID ,
1329: X_ENROLLED_DT => c_IGS_EN_SU_ATTEMPT_rec.ENROLLED_DT,
1330: X_UNIT_ATTEMPT_STATUS => cst_discontinue, -- c_IGS_EN_SU_ATTEMPT_rec.UNIT_ATTEMPT_STATUS,
1331: X_ADMINISTRATIVE_UNIT_STATUS => v_administrative_unit_status,
1332: X_ADMINISTRATIVE_PRIORITY => c_IGS_EN_SU_ATTEMPT_rec.administrative_PRIORITY,
1333: X_DISCONTINUED_DT => p_discontinued_dt,

Line 1330: X_UNIT_ATTEMPT_STATUS => cst_discontinue, -- c_IGS_EN_SU_ATTEMPT_rec.UNIT_ATTEMPT_STATUS,

1326: X_CI_START_DT => c_IGS_EN_SU_ATTEMPT_rec.CI_START_DT,
1327: X_CI_END_DT => c_IGS_EN_SU_ATTEMPT_rec.CI_END_DT,
1328: X_UOO_ID => c_IGS_EN_SU_ATTEMPT_rec.UOO_ID ,
1329: X_ENROLLED_DT => c_IGS_EN_SU_ATTEMPT_rec.ENROLLED_DT,
1330: X_UNIT_ATTEMPT_STATUS => cst_discontinue, -- c_IGS_EN_SU_ATTEMPT_rec.UNIT_ATTEMPT_STATUS,
1331: X_ADMINISTRATIVE_UNIT_STATUS => v_administrative_unit_status,
1332: X_ADMINISTRATIVE_PRIORITY => c_IGS_EN_SU_ATTEMPT_rec.administrative_PRIORITY,
1333: X_DISCONTINUED_DT => p_discontinued_dt,
1334: X_DCNT_REASON_CD => NULL, -- unable to insert value in to this field

Line 1332: X_ADMINISTRATIVE_PRIORITY => c_IGS_EN_SU_ATTEMPT_rec.administrative_PRIORITY,

1328: X_UOO_ID => c_IGS_EN_SU_ATTEMPT_rec.UOO_ID ,
1329: X_ENROLLED_DT => c_IGS_EN_SU_ATTEMPT_rec.ENROLLED_DT,
1330: X_UNIT_ATTEMPT_STATUS => cst_discontinue, -- c_IGS_EN_SU_ATTEMPT_rec.UNIT_ATTEMPT_STATUS,
1331: X_ADMINISTRATIVE_UNIT_STATUS => v_administrative_unit_status,
1332: X_ADMINISTRATIVE_PRIORITY => c_IGS_EN_SU_ATTEMPT_rec.administrative_PRIORITY,
1333: X_DISCONTINUED_DT => p_discontinued_dt,
1334: X_DCNT_REASON_CD => NULL, -- unable to insert value in to this field
1335: X_RULE_WAIVED_DT => c_IGS_EN_SU_ATTEMPT_rec.RULE_WAIVED_DT ,
1336: X_RULE_WAIVED_PERSON_ID => c_IGS_EN_SU_ATTEMPT_rec.RULE_WAIVED_PERSON_ID ,

Line 1335: X_RULE_WAIVED_DT => c_IGS_EN_SU_ATTEMPT_rec.RULE_WAIVED_DT ,

1331: X_ADMINISTRATIVE_UNIT_STATUS => v_administrative_unit_status,
1332: X_ADMINISTRATIVE_PRIORITY => c_IGS_EN_SU_ATTEMPT_rec.administrative_PRIORITY,
1333: X_DISCONTINUED_DT => p_discontinued_dt,
1334: X_DCNT_REASON_CD => NULL, -- unable to insert value in to this field
1335: X_RULE_WAIVED_DT => c_IGS_EN_SU_ATTEMPT_rec.RULE_WAIVED_DT ,
1336: X_RULE_WAIVED_PERSON_ID => c_IGS_EN_SU_ATTEMPT_rec.RULE_WAIVED_PERSON_ID ,
1337: X_NO_ASSESSMENT_IND => c_IGS_EN_SU_ATTEMPT_rec.NO_ASSESSMENT_IND,
1338: X_SUP_UNIT_CD => c_IGS_EN_SU_ATTEMPT_rec.SUP_UNIT_CD ,
1339: X_SUP_VERSION_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.SUP_VERSION_NUMBER,

Line 1336: X_RULE_WAIVED_PERSON_ID => c_IGS_EN_SU_ATTEMPT_rec.RULE_WAIVED_PERSON_ID ,

1332: X_ADMINISTRATIVE_PRIORITY => c_IGS_EN_SU_ATTEMPT_rec.administrative_PRIORITY,
1333: X_DISCONTINUED_DT => p_discontinued_dt,
1334: X_DCNT_REASON_CD => NULL, -- unable to insert value in to this field
1335: X_RULE_WAIVED_DT => c_IGS_EN_SU_ATTEMPT_rec.RULE_WAIVED_DT ,
1336: X_RULE_WAIVED_PERSON_ID => c_IGS_EN_SU_ATTEMPT_rec.RULE_WAIVED_PERSON_ID ,
1337: X_NO_ASSESSMENT_IND => c_IGS_EN_SU_ATTEMPT_rec.NO_ASSESSMENT_IND,
1338: X_SUP_UNIT_CD => c_IGS_EN_SU_ATTEMPT_rec.SUP_UNIT_CD ,
1339: X_SUP_VERSION_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.SUP_VERSION_NUMBER,
1340: X_EXAM_LOCATION_CD => c_IGS_EN_SU_ATTEMPT_rec.EXAM_LOCATION_CD,

Line 1337: X_NO_ASSESSMENT_IND => c_IGS_EN_SU_ATTEMPT_rec.NO_ASSESSMENT_IND,

1333: X_DISCONTINUED_DT => p_discontinued_dt,
1334: X_DCNT_REASON_CD => NULL, -- unable to insert value in to this field
1335: X_RULE_WAIVED_DT => c_IGS_EN_SU_ATTEMPT_rec.RULE_WAIVED_DT ,
1336: X_RULE_WAIVED_PERSON_ID => c_IGS_EN_SU_ATTEMPT_rec.RULE_WAIVED_PERSON_ID ,
1337: X_NO_ASSESSMENT_IND => c_IGS_EN_SU_ATTEMPT_rec.NO_ASSESSMENT_IND,
1338: X_SUP_UNIT_CD => c_IGS_EN_SU_ATTEMPT_rec.SUP_UNIT_CD ,
1339: X_SUP_VERSION_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.SUP_VERSION_NUMBER,
1340: X_EXAM_LOCATION_CD => c_IGS_EN_SU_ATTEMPT_rec.EXAM_LOCATION_CD,
1341: X_ALTERNATIVE_TITLE => c_IGS_EN_SU_ATTEMPT_rec.ALTERNATIVE_TITLE,

Line 1338: X_SUP_UNIT_CD => c_IGS_EN_SU_ATTEMPT_rec.SUP_UNIT_CD ,

1334: X_DCNT_REASON_CD => NULL, -- unable to insert value in to this field
1335: X_RULE_WAIVED_DT => c_IGS_EN_SU_ATTEMPT_rec.RULE_WAIVED_DT ,
1336: X_RULE_WAIVED_PERSON_ID => c_IGS_EN_SU_ATTEMPT_rec.RULE_WAIVED_PERSON_ID ,
1337: X_NO_ASSESSMENT_IND => c_IGS_EN_SU_ATTEMPT_rec.NO_ASSESSMENT_IND,
1338: X_SUP_UNIT_CD => c_IGS_EN_SU_ATTEMPT_rec.SUP_UNIT_CD ,
1339: X_SUP_VERSION_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.SUP_VERSION_NUMBER,
1340: X_EXAM_LOCATION_CD => c_IGS_EN_SU_ATTEMPT_rec.EXAM_LOCATION_CD,
1341: X_ALTERNATIVE_TITLE => c_IGS_EN_SU_ATTEMPT_rec.ALTERNATIVE_TITLE,
1342: X_OVERRIDE_ENROLLED_CP => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_ENROLLED_CP,

Line 1339: X_SUP_VERSION_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.SUP_VERSION_NUMBER,

1335: X_RULE_WAIVED_DT => c_IGS_EN_SU_ATTEMPT_rec.RULE_WAIVED_DT ,
1336: X_RULE_WAIVED_PERSON_ID => c_IGS_EN_SU_ATTEMPT_rec.RULE_WAIVED_PERSON_ID ,
1337: X_NO_ASSESSMENT_IND => c_IGS_EN_SU_ATTEMPT_rec.NO_ASSESSMENT_IND,
1338: X_SUP_UNIT_CD => c_IGS_EN_SU_ATTEMPT_rec.SUP_UNIT_CD ,
1339: X_SUP_VERSION_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.SUP_VERSION_NUMBER,
1340: X_EXAM_LOCATION_CD => c_IGS_EN_SU_ATTEMPT_rec.EXAM_LOCATION_CD,
1341: X_ALTERNATIVE_TITLE => c_IGS_EN_SU_ATTEMPT_rec.ALTERNATIVE_TITLE,
1342: X_OVERRIDE_ENROLLED_CP => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_ENROLLED_CP,
1343: X_OVERRIDE_EFTSU => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_EFTSU ,

Line 1340: X_EXAM_LOCATION_CD => c_IGS_EN_SU_ATTEMPT_rec.EXAM_LOCATION_CD,

1336: X_RULE_WAIVED_PERSON_ID => c_IGS_EN_SU_ATTEMPT_rec.RULE_WAIVED_PERSON_ID ,
1337: X_NO_ASSESSMENT_IND => c_IGS_EN_SU_ATTEMPT_rec.NO_ASSESSMENT_IND,
1338: X_SUP_UNIT_CD => c_IGS_EN_SU_ATTEMPT_rec.SUP_UNIT_CD ,
1339: X_SUP_VERSION_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.SUP_VERSION_NUMBER,
1340: X_EXAM_LOCATION_CD => c_IGS_EN_SU_ATTEMPT_rec.EXAM_LOCATION_CD,
1341: X_ALTERNATIVE_TITLE => c_IGS_EN_SU_ATTEMPT_rec.ALTERNATIVE_TITLE,
1342: X_OVERRIDE_ENROLLED_CP => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_ENROLLED_CP,
1343: X_OVERRIDE_EFTSU => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_EFTSU ,
1344: X_OVERRIDE_ACHIEVABLE_CP => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_ACHIEVABLE_CP,

Line 1341: X_ALTERNATIVE_TITLE => c_IGS_EN_SU_ATTEMPT_rec.ALTERNATIVE_TITLE,

1337: X_NO_ASSESSMENT_IND => c_IGS_EN_SU_ATTEMPT_rec.NO_ASSESSMENT_IND,
1338: X_SUP_UNIT_CD => c_IGS_EN_SU_ATTEMPT_rec.SUP_UNIT_CD ,
1339: X_SUP_VERSION_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.SUP_VERSION_NUMBER,
1340: X_EXAM_LOCATION_CD => c_IGS_EN_SU_ATTEMPT_rec.EXAM_LOCATION_CD,
1341: X_ALTERNATIVE_TITLE => c_IGS_EN_SU_ATTEMPT_rec.ALTERNATIVE_TITLE,
1342: X_OVERRIDE_ENROLLED_CP => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_ENROLLED_CP,
1343: X_OVERRIDE_EFTSU => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_EFTSU ,
1344: X_OVERRIDE_ACHIEVABLE_CP => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_ACHIEVABLE_CP,
1345: X_OVERRIDE_OUTCOME_DUE_DT => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_OUTCOME_DUE_DT,

Line 1342: X_OVERRIDE_ENROLLED_CP => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_ENROLLED_CP,

1338: X_SUP_UNIT_CD => c_IGS_EN_SU_ATTEMPT_rec.SUP_UNIT_CD ,
1339: X_SUP_VERSION_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.SUP_VERSION_NUMBER,
1340: X_EXAM_LOCATION_CD => c_IGS_EN_SU_ATTEMPT_rec.EXAM_LOCATION_CD,
1341: X_ALTERNATIVE_TITLE => c_IGS_EN_SU_ATTEMPT_rec.ALTERNATIVE_TITLE,
1342: X_OVERRIDE_ENROLLED_CP => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_ENROLLED_CP,
1343: X_OVERRIDE_EFTSU => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_EFTSU ,
1344: X_OVERRIDE_ACHIEVABLE_CP => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_ACHIEVABLE_CP,
1345: X_OVERRIDE_OUTCOME_DUE_DT => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_OUTCOME_DUE_DT,
1346: X_OVERRIDE_CREDIT_REASON => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_CREDIT_REASON,

Line 1343: X_OVERRIDE_EFTSU => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_EFTSU ,

1339: X_SUP_VERSION_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.SUP_VERSION_NUMBER,
1340: X_EXAM_LOCATION_CD => c_IGS_EN_SU_ATTEMPT_rec.EXAM_LOCATION_CD,
1341: X_ALTERNATIVE_TITLE => c_IGS_EN_SU_ATTEMPT_rec.ALTERNATIVE_TITLE,
1342: X_OVERRIDE_ENROLLED_CP => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_ENROLLED_CP,
1343: X_OVERRIDE_EFTSU => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_EFTSU ,
1344: X_OVERRIDE_ACHIEVABLE_CP => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_ACHIEVABLE_CP,
1345: X_OVERRIDE_OUTCOME_DUE_DT => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_OUTCOME_DUE_DT,
1346: X_OVERRIDE_CREDIT_REASON => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_CREDIT_REASON,
1347: X_WAITLIST_DT => c_IGS_EN_SU_ATTEMPT_rec.waitlist_dt,

Line 1344: X_OVERRIDE_ACHIEVABLE_CP => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_ACHIEVABLE_CP,

1340: X_EXAM_LOCATION_CD => c_IGS_EN_SU_ATTEMPT_rec.EXAM_LOCATION_CD,
1341: X_ALTERNATIVE_TITLE => c_IGS_EN_SU_ATTEMPT_rec.ALTERNATIVE_TITLE,
1342: X_OVERRIDE_ENROLLED_CP => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_ENROLLED_CP,
1343: X_OVERRIDE_EFTSU => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_EFTSU ,
1344: X_OVERRIDE_ACHIEVABLE_CP => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_ACHIEVABLE_CP,
1345: X_OVERRIDE_OUTCOME_DUE_DT => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_OUTCOME_DUE_DT,
1346: X_OVERRIDE_CREDIT_REASON => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_CREDIT_REASON,
1347: X_WAITLIST_DT => c_IGS_EN_SU_ATTEMPT_rec.waitlist_dt,
1348: X_MODE => 'R',

Line 1345: X_OVERRIDE_OUTCOME_DUE_DT => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_OUTCOME_DUE_DT,

1341: X_ALTERNATIVE_TITLE => c_IGS_EN_SU_ATTEMPT_rec.ALTERNATIVE_TITLE,
1342: X_OVERRIDE_ENROLLED_CP => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_ENROLLED_CP,
1343: X_OVERRIDE_EFTSU => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_EFTSU ,
1344: X_OVERRIDE_ACHIEVABLE_CP => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_ACHIEVABLE_CP,
1345: X_OVERRIDE_OUTCOME_DUE_DT => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_OUTCOME_DUE_DT,
1346: X_OVERRIDE_CREDIT_REASON => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_CREDIT_REASON,
1347: X_WAITLIST_DT => c_IGS_EN_SU_ATTEMPT_rec.waitlist_dt,
1348: X_MODE => 'R',
1349: -- Added 5 cols as part of Enrollement Process Build -- amuthu

Line 1346: X_OVERRIDE_CREDIT_REASON => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_CREDIT_REASON,

1342: X_OVERRIDE_ENROLLED_CP => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_ENROLLED_CP,
1343: X_OVERRIDE_EFTSU => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_EFTSU ,
1344: X_OVERRIDE_ACHIEVABLE_CP => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_ACHIEVABLE_CP,
1345: X_OVERRIDE_OUTCOME_DUE_DT => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_OUTCOME_DUE_DT,
1346: X_OVERRIDE_CREDIT_REASON => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_CREDIT_REASON,
1347: X_WAITLIST_DT => c_IGS_EN_SU_ATTEMPT_rec.waitlist_dt,
1348: X_MODE => 'R',
1349: -- Added 5 cols as part of Enrollement Process Build -- amuthu
1350: X_GS_VERSION_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.gs_version_number,

Line 1347: X_WAITLIST_DT => c_IGS_EN_SU_ATTEMPT_rec.waitlist_dt,

1343: X_OVERRIDE_EFTSU => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_EFTSU ,
1344: X_OVERRIDE_ACHIEVABLE_CP => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_ACHIEVABLE_CP,
1345: X_OVERRIDE_OUTCOME_DUE_DT => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_OUTCOME_DUE_DT,
1346: X_OVERRIDE_CREDIT_REASON => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_CREDIT_REASON,
1347: X_WAITLIST_DT => c_IGS_EN_SU_ATTEMPT_rec.waitlist_dt,
1348: X_MODE => 'R',
1349: -- Added 5 cols as part of Enrollement Process Build -- amuthu
1350: X_GS_VERSION_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.gs_version_number,
1351: X_ENR_METHOD_TYPE => c_IGS_EN_SU_ATTEMPT_rec.enr_method_type,

Line 1350: X_GS_VERSION_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.gs_version_number,

1346: X_OVERRIDE_CREDIT_REASON => c_IGS_EN_SU_ATTEMPT_rec.OVERRIDE_CREDIT_REASON,
1347: X_WAITLIST_DT => c_IGS_EN_SU_ATTEMPT_rec.waitlist_dt,
1348: X_MODE => 'R',
1349: -- Added 5 cols as part of Enrollement Process Build -- amuthu
1350: X_GS_VERSION_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.gs_version_number,
1351: X_ENR_METHOD_TYPE => c_IGS_EN_SU_ATTEMPT_rec.enr_method_type,
1352: X_FAILED_UNIT_RULE => c_IGS_EN_SU_ATTEMPT_rec.FAILED_UNIT_RULE,
1353: X_CART => c_IGS_EN_SU_ATTEMPT_rec.cart,
1354: X_RSV_SEAT_EXT_ID => c_IGS_EN_SU_ATTEMPT_rec.RSV_SEAT_EXT_ID,

Line 1351: X_ENR_METHOD_TYPE => c_IGS_EN_SU_ATTEMPT_rec.enr_method_type,

1347: X_WAITLIST_DT => c_IGS_EN_SU_ATTEMPT_rec.waitlist_dt,
1348: X_MODE => 'R',
1349: -- Added 5 cols as part of Enrollement Process Build -- amuthu
1350: X_GS_VERSION_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.gs_version_number,
1351: X_ENR_METHOD_TYPE => c_IGS_EN_SU_ATTEMPT_rec.enr_method_type,
1352: X_FAILED_UNIT_RULE => c_IGS_EN_SU_ATTEMPT_rec.FAILED_UNIT_RULE,
1353: X_CART => c_IGS_EN_SU_ATTEMPT_rec.cart,
1354: X_RSV_SEAT_EXT_ID => c_IGS_EN_SU_ATTEMPT_rec.RSV_SEAT_EXT_ID,
1355: X_ORG_UNIT_CD => c_IGS_EN_SU_ATTEMPT_rec.ORG_UNIT_CD,

Line 1352: X_FAILED_UNIT_RULE => c_IGS_EN_SU_ATTEMPT_rec.FAILED_UNIT_RULE,

1348: X_MODE => 'R',
1349: -- Added 5 cols as part of Enrollement Process Build -- amuthu
1350: X_GS_VERSION_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.gs_version_number,
1351: X_ENR_METHOD_TYPE => c_IGS_EN_SU_ATTEMPT_rec.enr_method_type,
1352: X_FAILED_UNIT_RULE => c_IGS_EN_SU_ATTEMPT_rec.FAILED_UNIT_RULE,
1353: X_CART => c_IGS_EN_SU_ATTEMPT_rec.cart,
1354: X_RSV_SEAT_EXT_ID => c_IGS_EN_SU_ATTEMPT_rec.RSV_SEAT_EXT_ID,
1355: X_ORG_UNIT_CD => c_IGS_EN_SU_ATTEMPT_rec.ORG_UNIT_CD,
1356: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.

Line 1353: X_CART => c_IGS_EN_SU_ATTEMPT_rec.cart,

1349: -- Added 5 cols as part of Enrollement Process Build -- amuthu
1350: X_GS_VERSION_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.gs_version_number,
1351: X_ENR_METHOD_TYPE => c_IGS_EN_SU_ATTEMPT_rec.enr_method_type,
1352: X_FAILED_UNIT_RULE => c_IGS_EN_SU_ATTEMPT_rec.FAILED_UNIT_RULE,
1353: X_CART => c_IGS_EN_SU_ATTEMPT_rec.cart,
1354: X_RSV_SEAT_EXT_ID => c_IGS_EN_SU_ATTEMPT_rec.RSV_SEAT_EXT_ID,
1355: X_ORG_UNIT_CD => c_IGS_EN_SU_ATTEMPT_rec.ORG_UNIT_CD,
1356: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
1357: X_SESSION_ID => c_IGS_EN_SU_ATTEMPT_rec.SESSION_ID,

Line 1354: X_RSV_SEAT_EXT_ID => c_IGS_EN_SU_ATTEMPT_rec.RSV_SEAT_EXT_ID,

1350: X_GS_VERSION_NUMBER => c_IGS_EN_SU_ATTEMPT_rec.gs_version_number,
1351: X_ENR_METHOD_TYPE => c_IGS_EN_SU_ATTEMPT_rec.enr_method_type,
1352: X_FAILED_UNIT_RULE => c_IGS_EN_SU_ATTEMPT_rec.FAILED_UNIT_RULE,
1353: X_CART => c_IGS_EN_SU_ATTEMPT_rec.cart,
1354: X_RSV_SEAT_EXT_ID => c_IGS_EN_SU_ATTEMPT_rec.RSV_SEAT_EXT_ID,
1355: X_ORG_UNIT_CD => c_IGS_EN_SU_ATTEMPT_rec.ORG_UNIT_CD,
1356: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
1357: X_SESSION_ID => c_IGS_EN_SU_ATTEMPT_rec.SESSION_ID,
1358: -- Added the column grading schema as a part of the bug 2037897. - aiyer

Line 1355: X_ORG_UNIT_CD => c_IGS_EN_SU_ATTEMPT_rec.ORG_UNIT_CD,

1351: X_ENR_METHOD_TYPE => c_IGS_EN_SU_ATTEMPT_rec.enr_method_type,
1352: X_FAILED_UNIT_RULE => c_IGS_EN_SU_ATTEMPT_rec.FAILED_UNIT_RULE,
1353: X_CART => c_IGS_EN_SU_ATTEMPT_rec.cart,
1354: X_RSV_SEAT_EXT_ID => c_IGS_EN_SU_ATTEMPT_rec.RSV_SEAT_EXT_ID,
1355: X_ORG_UNIT_CD => c_IGS_EN_SU_ATTEMPT_rec.ORG_UNIT_CD,
1356: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
1357: X_SESSION_ID => c_IGS_EN_SU_ATTEMPT_rec.SESSION_ID,
1358: -- Added the column grading schema as a part of the bug 2037897. - aiyer
1359: X_GRADING_SCHEMA_CODE => c_IGS_EN_SU_ATTEMPT_rec.grading_schema_code,

Line 1357: X_SESSION_ID => c_IGS_EN_SU_ATTEMPT_rec.SESSION_ID,

1353: X_CART => c_IGS_EN_SU_ATTEMPT_rec.cart,
1354: X_RSV_SEAT_EXT_ID => c_IGS_EN_SU_ATTEMPT_rec.RSV_SEAT_EXT_ID,
1355: X_ORG_UNIT_CD => c_IGS_EN_SU_ATTEMPT_rec.ORG_UNIT_CD,
1356: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
1357: X_SESSION_ID => c_IGS_EN_SU_ATTEMPT_rec.SESSION_ID,
1358: -- Added the column grading schema as a part of the bug 2037897. - aiyer
1359: X_GRADING_SCHEMA_CODE => c_IGS_EN_SU_ATTEMPT_rec.grading_schema_code,
1360: X_DEG_AUD_DETAIL_ID => c_IGS_EN_SU_ATTEMPT_rec.deg_aud_detail_id,
1361: X_SUBTITLE => c_IGS_EN_SU_ATTEMPT_rec.subtitle,

Line 1359: X_GRADING_SCHEMA_CODE => c_IGS_EN_SU_ATTEMPT_rec.grading_schema_code,

1355: X_ORG_UNIT_CD => c_IGS_EN_SU_ATTEMPT_rec.ORG_UNIT_CD,
1356: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
1357: X_SESSION_ID => c_IGS_EN_SU_ATTEMPT_rec.SESSION_ID,
1358: -- Added the column grading schema as a part of the bug 2037897. - aiyer
1359: X_GRADING_SCHEMA_CODE => c_IGS_EN_SU_ATTEMPT_rec.grading_schema_code,
1360: X_DEG_AUD_DETAIL_ID => c_IGS_EN_SU_ATTEMPT_rec.deg_aud_detail_id,
1361: X_SUBTITLE => c_IGS_EN_SU_ATTEMPT_rec.subtitle,
1362: X_STUDENT_CAREER_TRANSCRIPT => c_IGS_EN_SU_ATTEMPT_rec.student_career_transcript,
1363: X_STUDENT_CAREER_STATISTICS => c_IGS_EN_SU_ATTEMPT_rec.student_career_statistics,

Line 1360: X_DEG_AUD_DETAIL_ID => c_IGS_EN_SU_ATTEMPT_rec.deg_aud_detail_id,

1356: -- session_id added by Nishikant 28JAN2002 - Enh Bug#2172380.
1357: X_SESSION_ID => c_IGS_EN_SU_ATTEMPT_rec.SESSION_ID,
1358: -- Added the column grading schema as a part of the bug 2037897. - aiyer
1359: X_GRADING_SCHEMA_CODE => c_IGS_EN_SU_ATTEMPT_rec.grading_schema_code,
1360: X_DEG_AUD_DETAIL_ID => c_IGS_EN_SU_ATTEMPT_rec.deg_aud_detail_id,
1361: X_SUBTITLE => c_IGS_EN_SU_ATTEMPT_rec.subtitle,
1362: X_STUDENT_CAREER_TRANSCRIPT => c_IGS_EN_SU_ATTEMPT_rec.student_career_transcript,
1363: X_STUDENT_CAREER_STATISTICS => c_IGS_EN_SU_ATTEMPT_rec.student_career_statistics,
1364: X_ATTRIBUTE_CATEGORY => c_IGS_EN_SU_ATTEMPT_rec.attribute_category,

Line 1361: X_SUBTITLE => c_IGS_EN_SU_ATTEMPT_rec.subtitle,

1357: X_SESSION_ID => c_IGS_EN_SU_ATTEMPT_rec.SESSION_ID,
1358: -- Added the column grading schema as a part of the bug 2037897. - aiyer
1359: X_GRADING_SCHEMA_CODE => c_IGS_EN_SU_ATTEMPT_rec.grading_schema_code,
1360: X_DEG_AUD_DETAIL_ID => c_IGS_EN_SU_ATTEMPT_rec.deg_aud_detail_id,
1361: X_SUBTITLE => c_IGS_EN_SU_ATTEMPT_rec.subtitle,
1362: X_STUDENT_CAREER_TRANSCRIPT => c_IGS_EN_SU_ATTEMPT_rec.student_career_transcript,
1363: X_STUDENT_CAREER_STATISTICS => c_IGS_EN_SU_ATTEMPT_rec.student_career_statistics,
1364: X_ATTRIBUTE_CATEGORY => c_IGS_EN_SU_ATTEMPT_rec.attribute_category,
1365: X_ATTRIBUTE1 => c_IGS_EN_SU_ATTEMPT_rec.attribute1,

Line 1362: X_STUDENT_CAREER_TRANSCRIPT => c_IGS_EN_SU_ATTEMPT_rec.student_career_transcript,

1358: -- Added the column grading schema as a part of the bug 2037897. - aiyer
1359: X_GRADING_SCHEMA_CODE => c_IGS_EN_SU_ATTEMPT_rec.grading_schema_code,
1360: X_DEG_AUD_DETAIL_ID => c_IGS_EN_SU_ATTEMPT_rec.deg_aud_detail_id,
1361: X_SUBTITLE => c_IGS_EN_SU_ATTEMPT_rec.subtitle,
1362: X_STUDENT_CAREER_TRANSCRIPT => c_IGS_EN_SU_ATTEMPT_rec.student_career_transcript,
1363: X_STUDENT_CAREER_STATISTICS => c_IGS_EN_SU_ATTEMPT_rec.student_career_statistics,
1364: X_ATTRIBUTE_CATEGORY => c_IGS_EN_SU_ATTEMPT_rec.attribute_category,
1365: X_ATTRIBUTE1 => c_IGS_EN_SU_ATTEMPT_rec.attribute1,
1366: X_ATTRIBUTE2 => c_IGS_EN_SU_ATTEMPT_rec.attribute2,

Line 1363: X_STUDENT_CAREER_STATISTICS => c_IGS_EN_SU_ATTEMPT_rec.student_career_statistics,

1359: X_GRADING_SCHEMA_CODE => c_IGS_EN_SU_ATTEMPT_rec.grading_schema_code,
1360: X_DEG_AUD_DETAIL_ID => c_IGS_EN_SU_ATTEMPT_rec.deg_aud_detail_id,
1361: X_SUBTITLE => c_IGS_EN_SU_ATTEMPT_rec.subtitle,
1362: X_STUDENT_CAREER_TRANSCRIPT => c_IGS_EN_SU_ATTEMPT_rec.student_career_transcript,
1363: X_STUDENT_CAREER_STATISTICS => c_IGS_EN_SU_ATTEMPT_rec.student_career_statistics,
1364: X_ATTRIBUTE_CATEGORY => c_IGS_EN_SU_ATTEMPT_rec.attribute_category,
1365: X_ATTRIBUTE1 => c_IGS_EN_SU_ATTEMPT_rec.attribute1,
1366: X_ATTRIBUTE2 => c_IGS_EN_SU_ATTEMPT_rec.attribute2,
1367: X_ATTRIBUTE3 => c_IGS_EN_SU_ATTEMPT_rec.attribute3,

Line 1364: X_ATTRIBUTE_CATEGORY => c_IGS_EN_SU_ATTEMPT_rec.attribute_category,

1360: X_DEG_AUD_DETAIL_ID => c_IGS_EN_SU_ATTEMPT_rec.deg_aud_detail_id,
1361: X_SUBTITLE => c_IGS_EN_SU_ATTEMPT_rec.subtitle,
1362: X_STUDENT_CAREER_TRANSCRIPT => c_IGS_EN_SU_ATTEMPT_rec.student_career_transcript,
1363: X_STUDENT_CAREER_STATISTICS => c_IGS_EN_SU_ATTEMPT_rec.student_career_statistics,
1364: X_ATTRIBUTE_CATEGORY => c_IGS_EN_SU_ATTEMPT_rec.attribute_category,
1365: X_ATTRIBUTE1 => c_IGS_EN_SU_ATTEMPT_rec.attribute1,
1366: X_ATTRIBUTE2 => c_IGS_EN_SU_ATTEMPT_rec.attribute2,
1367: X_ATTRIBUTE3 => c_IGS_EN_SU_ATTEMPT_rec.attribute3,
1368: X_ATTRIBUTE4 => c_IGS_EN_SU_ATTEMPT_rec.attribute4,

Line 1365: X_ATTRIBUTE1 => c_IGS_EN_SU_ATTEMPT_rec.attribute1,

1361: X_SUBTITLE => c_IGS_EN_SU_ATTEMPT_rec.subtitle,
1362: X_STUDENT_CAREER_TRANSCRIPT => c_IGS_EN_SU_ATTEMPT_rec.student_career_transcript,
1363: X_STUDENT_CAREER_STATISTICS => c_IGS_EN_SU_ATTEMPT_rec.student_career_statistics,
1364: X_ATTRIBUTE_CATEGORY => c_IGS_EN_SU_ATTEMPT_rec.attribute_category,
1365: X_ATTRIBUTE1 => c_IGS_EN_SU_ATTEMPT_rec.attribute1,
1366: X_ATTRIBUTE2 => c_IGS_EN_SU_ATTEMPT_rec.attribute2,
1367: X_ATTRIBUTE3 => c_IGS_EN_SU_ATTEMPT_rec.attribute3,
1368: X_ATTRIBUTE4 => c_IGS_EN_SU_ATTEMPT_rec.attribute4,
1369: X_ATTRIBUTE5 => c_IGS_EN_SU_ATTEMPT_rec.attribute5,

Line 1366: X_ATTRIBUTE2 => c_IGS_EN_SU_ATTEMPT_rec.attribute2,

1362: X_STUDENT_CAREER_TRANSCRIPT => c_IGS_EN_SU_ATTEMPT_rec.student_career_transcript,
1363: X_STUDENT_CAREER_STATISTICS => c_IGS_EN_SU_ATTEMPT_rec.student_career_statistics,
1364: X_ATTRIBUTE_CATEGORY => c_IGS_EN_SU_ATTEMPT_rec.attribute_category,
1365: X_ATTRIBUTE1 => c_IGS_EN_SU_ATTEMPT_rec.attribute1,
1366: X_ATTRIBUTE2 => c_IGS_EN_SU_ATTEMPT_rec.attribute2,
1367: X_ATTRIBUTE3 => c_IGS_EN_SU_ATTEMPT_rec.attribute3,
1368: X_ATTRIBUTE4 => c_IGS_EN_SU_ATTEMPT_rec.attribute4,
1369: X_ATTRIBUTE5 => c_IGS_EN_SU_ATTEMPT_rec.attribute5,
1370: X_ATTRIBUTE6 => c_IGS_EN_SU_ATTEMPT_rec.attribute6,

Line 1367: X_ATTRIBUTE3 => c_IGS_EN_SU_ATTEMPT_rec.attribute3,

1363: X_STUDENT_CAREER_STATISTICS => c_IGS_EN_SU_ATTEMPT_rec.student_career_statistics,
1364: X_ATTRIBUTE_CATEGORY => c_IGS_EN_SU_ATTEMPT_rec.attribute_category,
1365: X_ATTRIBUTE1 => c_IGS_EN_SU_ATTEMPT_rec.attribute1,
1366: X_ATTRIBUTE2 => c_IGS_EN_SU_ATTEMPT_rec.attribute2,
1367: X_ATTRIBUTE3 => c_IGS_EN_SU_ATTEMPT_rec.attribute3,
1368: X_ATTRIBUTE4 => c_IGS_EN_SU_ATTEMPT_rec.attribute4,
1369: X_ATTRIBUTE5 => c_IGS_EN_SU_ATTEMPT_rec.attribute5,
1370: X_ATTRIBUTE6 => c_IGS_EN_SU_ATTEMPT_rec.attribute6,
1371: X_ATTRIBUTE7 => c_IGS_EN_SU_ATTEMPT_rec.attribute7,

Line 1368: X_ATTRIBUTE4 => c_IGS_EN_SU_ATTEMPT_rec.attribute4,

1364: X_ATTRIBUTE_CATEGORY => c_IGS_EN_SU_ATTEMPT_rec.attribute_category,
1365: X_ATTRIBUTE1 => c_IGS_EN_SU_ATTEMPT_rec.attribute1,
1366: X_ATTRIBUTE2 => c_IGS_EN_SU_ATTEMPT_rec.attribute2,
1367: X_ATTRIBUTE3 => c_IGS_EN_SU_ATTEMPT_rec.attribute3,
1368: X_ATTRIBUTE4 => c_IGS_EN_SU_ATTEMPT_rec.attribute4,
1369: X_ATTRIBUTE5 => c_IGS_EN_SU_ATTEMPT_rec.attribute5,
1370: X_ATTRIBUTE6 => c_IGS_EN_SU_ATTEMPT_rec.attribute6,
1371: X_ATTRIBUTE7 => c_IGS_EN_SU_ATTEMPT_rec.attribute7,
1372: X_ATTRIBUTE8 => c_IGS_EN_SU_ATTEMPT_rec.attribute8,

Line 1369: X_ATTRIBUTE5 => c_IGS_EN_SU_ATTEMPT_rec.attribute5,

1365: X_ATTRIBUTE1 => c_IGS_EN_SU_ATTEMPT_rec.attribute1,
1366: X_ATTRIBUTE2 => c_IGS_EN_SU_ATTEMPT_rec.attribute2,
1367: X_ATTRIBUTE3 => c_IGS_EN_SU_ATTEMPT_rec.attribute3,
1368: X_ATTRIBUTE4 => c_IGS_EN_SU_ATTEMPT_rec.attribute4,
1369: X_ATTRIBUTE5 => c_IGS_EN_SU_ATTEMPT_rec.attribute5,
1370: X_ATTRIBUTE6 => c_IGS_EN_SU_ATTEMPT_rec.attribute6,
1371: X_ATTRIBUTE7 => c_IGS_EN_SU_ATTEMPT_rec.attribute7,
1372: X_ATTRIBUTE8 => c_IGS_EN_SU_ATTEMPT_rec.attribute8,
1373: X_ATTRIBUTE9 => c_IGS_EN_SU_ATTEMPT_rec.attribute9,

Line 1370: X_ATTRIBUTE6 => c_IGS_EN_SU_ATTEMPT_rec.attribute6,

1366: X_ATTRIBUTE2 => c_IGS_EN_SU_ATTEMPT_rec.attribute2,
1367: X_ATTRIBUTE3 => c_IGS_EN_SU_ATTEMPT_rec.attribute3,
1368: X_ATTRIBUTE4 => c_IGS_EN_SU_ATTEMPT_rec.attribute4,
1369: X_ATTRIBUTE5 => c_IGS_EN_SU_ATTEMPT_rec.attribute5,
1370: X_ATTRIBUTE6 => c_IGS_EN_SU_ATTEMPT_rec.attribute6,
1371: X_ATTRIBUTE7 => c_IGS_EN_SU_ATTEMPT_rec.attribute7,
1372: X_ATTRIBUTE8 => c_IGS_EN_SU_ATTEMPT_rec.attribute8,
1373: X_ATTRIBUTE9 => c_IGS_EN_SU_ATTEMPT_rec.attribute9,
1374: X_ATTRIBUTE10 => c_IGS_EN_SU_ATTEMPT_rec.attribute10,

Line 1371: X_ATTRIBUTE7 => c_IGS_EN_SU_ATTEMPT_rec.attribute7,

1367: X_ATTRIBUTE3 => c_IGS_EN_SU_ATTEMPT_rec.attribute3,
1368: X_ATTRIBUTE4 => c_IGS_EN_SU_ATTEMPT_rec.attribute4,
1369: X_ATTRIBUTE5 => c_IGS_EN_SU_ATTEMPT_rec.attribute5,
1370: X_ATTRIBUTE6 => c_IGS_EN_SU_ATTEMPT_rec.attribute6,
1371: X_ATTRIBUTE7 => c_IGS_EN_SU_ATTEMPT_rec.attribute7,
1372: X_ATTRIBUTE8 => c_IGS_EN_SU_ATTEMPT_rec.attribute8,
1373: X_ATTRIBUTE9 => c_IGS_EN_SU_ATTEMPT_rec.attribute9,
1374: X_ATTRIBUTE10 => c_IGS_EN_SU_ATTEMPT_rec.attribute10,
1375: X_ATTRIBUTE11 => c_IGS_EN_SU_ATTEMPT_rec.attribute11,

Line 1372: X_ATTRIBUTE8 => c_IGS_EN_SU_ATTEMPT_rec.attribute8,

1368: X_ATTRIBUTE4 => c_IGS_EN_SU_ATTEMPT_rec.attribute4,
1369: X_ATTRIBUTE5 => c_IGS_EN_SU_ATTEMPT_rec.attribute5,
1370: X_ATTRIBUTE6 => c_IGS_EN_SU_ATTEMPT_rec.attribute6,
1371: X_ATTRIBUTE7 => c_IGS_EN_SU_ATTEMPT_rec.attribute7,
1372: X_ATTRIBUTE8 => c_IGS_EN_SU_ATTEMPT_rec.attribute8,
1373: X_ATTRIBUTE9 => c_IGS_EN_SU_ATTEMPT_rec.attribute9,
1374: X_ATTRIBUTE10 => c_IGS_EN_SU_ATTEMPT_rec.attribute10,
1375: X_ATTRIBUTE11 => c_IGS_EN_SU_ATTEMPT_rec.attribute11,
1376: X_ATTRIBUTE12 => c_IGS_EN_SU_ATTEMPT_rec.attribute12,

Line 1373: X_ATTRIBUTE9 => c_IGS_EN_SU_ATTEMPT_rec.attribute9,

1369: X_ATTRIBUTE5 => c_IGS_EN_SU_ATTEMPT_rec.attribute5,
1370: X_ATTRIBUTE6 => c_IGS_EN_SU_ATTEMPT_rec.attribute6,
1371: X_ATTRIBUTE7 => c_IGS_EN_SU_ATTEMPT_rec.attribute7,
1372: X_ATTRIBUTE8 => c_IGS_EN_SU_ATTEMPT_rec.attribute8,
1373: X_ATTRIBUTE9 => c_IGS_EN_SU_ATTEMPT_rec.attribute9,
1374: X_ATTRIBUTE10 => c_IGS_EN_SU_ATTEMPT_rec.attribute10,
1375: X_ATTRIBUTE11 => c_IGS_EN_SU_ATTEMPT_rec.attribute11,
1376: X_ATTRIBUTE12 => c_IGS_EN_SU_ATTEMPT_rec.attribute12,
1377: X_ATTRIBUTE13 => c_IGS_EN_SU_ATTEMPT_rec.attribute13,

Line 1374: X_ATTRIBUTE10 => c_IGS_EN_SU_ATTEMPT_rec.attribute10,

1370: X_ATTRIBUTE6 => c_IGS_EN_SU_ATTEMPT_rec.attribute6,
1371: X_ATTRIBUTE7 => c_IGS_EN_SU_ATTEMPT_rec.attribute7,
1372: X_ATTRIBUTE8 => c_IGS_EN_SU_ATTEMPT_rec.attribute8,
1373: X_ATTRIBUTE9 => c_IGS_EN_SU_ATTEMPT_rec.attribute9,
1374: X_ATTRIBUTE10 => c_IGS_EN_SU_ATTEMPT_rec.attribute10,
1375: X_ATTRIBUTE11 => c_IGS_EN_SU_ATTEMPT_rec.attribute11,
1376: X_ATTRIBUTE12 => c_IGS_EN_SU_ATTEMPT_rec.attribute12,
1377: X_ATTRIBUTE13 => c_IGS_EN_SU_ATTEMPT_rec.attribute13,
1378: X_ATTRIBUTE14 => c_IGS_EN_SU_ATTEMPT_rec.attribute14,

Line 1375: X_ATTRIBUTE11 => c_IGS_EN_SU_ATTEMPT_rec.attribute11,

1371: X_ATTRIBUTE7 => c_IGS_EN_SU_ATTEMPT_rec.attribute7,
1372: X_ATTRIBUTE8 => c_IGS_EN_SU_ATTEMPT_rec.attribute8,
1373: X_ATTRIBUTE9 => c_IGS_EN_SU_ATTEMPT_rec.attribute9,
1374: X_ATTRIBUTE10 => c_IGS_EN_SU_ATTEMPT_rec.attribute10,
1375: X_ATTRIBUTE11 => c_IGS_EN_SU_ATTEMPT_rec.attribute11,
1376: X_ATTRIBUTE12 => c_IGS_EN_SU_ATTEMPT_rec.attribute12,
1377: X_ATTRIBUTE13 => c_IGS_EN_SU_ATTEMPT_rec.attribute13,
1378: X_ATTRIBUTE14 => c_IGS_EN_SU_ATTEMPT_rec.attribute14,
1379: X_ATTRIBUTE15 => c_IGS_EN_SU_ATTEMPT_rec.attribute15,

Line 1376: X_ATTRIBUTE12 => c_IGS_EN_SU_ATTEMPT_rec.attribute12,

1372: X_ATTRIBUTE8 => c_IGS_EN_SU_ATTEMPT_rec.attribute8,
1373: X_ATTRIBUTE9 => c_IGS_EN_SU_ATTEMPT_rec.attribute9,
1374: X_ATTRIBUTE10 => c_IGS_EN_SU_ATTEMPT_rec.attribute10,
1375: X_ATTRIBUTE11 => c_IGS_EN_SU_ATTEMPT_rec.attribute11,
1376: X_ATTRIBUTE12 => c_IGS_EN_SU_ATTEMPT_rec.attribute12,
1377: X_ATTRIBUTE13 => c_IGS_EN_SU_ATTEMPT_rec.attribute13,
1378: X_ATTRIBUTE14 => c_IGS_EN_SU_ATTEMPT_rec.attribute14,
1379: X_ATTRIBUTE15 => c_IGS_EN_SU_ATTEMPT_rec.attribute15,
1380: X_ATTRIBUTE16 => c_IGS_EN_SU_ATTEMPT_rec.attribute16,

Line 1377: X_ATTRIBUTE13 => c_IGS_EN_SU_ATTEMPT_rec.attribute13,

1373: X_ATTRIBUTE9 => c_IGS_EN_SU_ATTEMPT_rec.attribute9,
1374: X_ATTRIBUTE10 => c_IGS_EN_SU_ATTEMPT_rec.attribute10,
1375: X_ATTRIBUTE11 => c_IGS_EN_SU_ATTEMPT_rec.attribute11,
1376: X_ATTRIBUTE12 => c_IGS_EN_SU_ATTEMPT_rec.attribute12,
1377: X_ATTRIBUTE13 => c_IGS_EN_SU_ATTEMPT_rec.attribute13,
1378: X_ATTRIBUTE14 => c_IGS_EN_SU_ATTEMPT_rec.attribute14,
1379: X_ATTRIBUTE15 => c_IGS_EN_SU_ATTEMPT_rec.attribute15,
1380: X_ATTRIBUTE16 => c_IGS_EN_SU_ATTEMPT_rec.attribute16,
1381: X_ATTRIBUTE17 => c_IGS_EN_SU_ATTEMPT_rec.attribute17,

Line 1378: X_ATTRIBUTE14 => c_IGS_EN_SU_ATTEMPT_rec.attribute14,

1374: X_ATTRIBUTE10 => c_IGS_EN_SU_ATTEMPT_rec.attribute10,
1375: X_ATTRIBUTE11 => c_IGS_EN_SU_ATTEMPT_rec.attribute11,
1376: X_ATTRIBUTE12 => c_IGS_EN_SU_ATTEMPT_rec.attribute12,
1377: X_ATTRIBUTE13 => c_IGS_EN_SU_ATTEMPT_rec.attribute13,
1378: X_ATTRIBUTE14 => c_IGS_EN_SU_ATTEMPT_rec.attribute14,
1379: X_ATTRIBUTE15 => c_IGS_EN_SU_ATTEMPT_rec.attribute15,
1380: X_ATTRIBUTE16 => c_IGS_EN_SU_ATTEMPT_rec.attribute16,
1381: X_ATTRIBUTE17 => c_IGS_EN_SU_ATTEMPT_rec.attribute17,
1382: X_ATTRIBUTE18 => c_IGS_EN_SU_ATTEMPT_rec.attribute18,

Line 1379: X_ATTRIBUTE15 => c_IGS_EN_SU_ATTEMPT_rec.attribute15,

1375: X_ATTRIBUTE11 => c_IGS_EN_SU_ATTEMPT_rec.attribute11,
1376: X_ATTRIBUTE12 => c_IGS_EN_SU_ATTEMPT_rec.attribute12,
1377: X_ATTRIBUTE13 => c_IGS_EN_SU_ATTEMPT_rec.attribute13,
1378: X_ATTRIBUTE14 => c_IGS_EN_SU_ATTEMPT_rec.attribute14,
1379: X_ATTRIBUTE15 => c_IGS_EN_SU_ATTEMPT_rec.attribute15,
1380: X_ATTRIBUTE16 => c_IGS_EN_SU_ATTEMPT_rec.attribute16,
1381: X_ATTRIBUTE17 => c_IGS_EN_SU_ATTEMPT_rec.attribute17,
1382: X_ATTRIBUTE18 => c_IGS_EN_SU_ATTEMPT_rec.attribute18,
1383: X_ATTRIBUTE19 => c_IGS_EN_SU_ATTEMPT_rec.attribute19,

Line 1380: X_ATTRIBUTE16 => c_IGS_EN_SU_ATTEMPT_rec.attribute16,

1376: X_ATTRIBUTE12 => c_IGS_EN_SU_ATTEMPT_rec.attribute12,
1377: X_ATTRIBUTE13 => c_IGS_EN_SU_ATTEMPT_rec.attribute13,
1378: X_ATTRIBUTE14 => c_IGS_EN_SU_ATTEMPT_rec.attribute14,
1379: X_ATTRIBUTE15 => c_IGS_EN_SU_ATTEMPT_rec.attribute15,
1380: X_ATTRIBUTE16 => c_IGS_EN_SU_ATTEMPT_rec.attribute16,
1381: X_ATTRIBUTE17 => c_IGS_EN_SU_ATTEMPT_rec.attribute17,
1382: X_ATTRIBUTE18 => c_IGS_EN_SU_ATTEMPT_rec.attribute18,
1383: X_ATTRIBUTE19 => c_IGS_EN_SU_ATTEMPT_rec.attribute19,
1384: X_ATTRIBUTE20 => c_IGS_EN_SU_ATTEMPT_rec.attribute20,

Line 1381: X_ATTRIBUTE17 => c_IGS_EN_SU_ATTEMPT_rec.attribute17,

1377: X_ATTRIBUTE13 => c_IGS_EN_SU_ATTEMPT_rec.attribute13,
1378: X_ATTRIBUTE14 => c_IGS_EN_SU_ATTEMPT_rec.attribute14,
1379: X_ATTRIBUTE15 => c_IGS_EN_SU_ATTEMPT_rec.attribute15,
1380: X_ATTRIBUTE16 => c_IGS_EN_SU_ATTEMPT_rec.attribute16,
1381: X_ATTRIBUTE17 => c_IGS_EN_SU_ATTEMPT_rec.attribute17,
1382: X_ATTRIBUTE18 => c_IGS_EN_SU_ATTEMPT_rec.attribute18,
1383: X_ATTRIBUTE19 => c_IGS_EN_SU_ATTEMPT_rec.attribute19,
1384: X_ATTRIBUTE20 => c_IGS_EN_SU_ATTEMPT_rec.attribute20,
1385: X_WAITLIST_MANUAL_IND => c_IGS_EN_SU_ATTEMPT_rec.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.

Line 1382: X_ATTRIBUTE18 => c_IGS_EN_SU_ATTEMPT_rec.attribute18,

1378: X_ATTRIBUTE14 => c_IGS_EN_SU_ATTEMPT_rec.attribute14,
1379: X_ATTRIBUTE15 => c_IGS_EN_SU_ATTEMPT_rec.attribute15,
1380: X_ATTRIBUTE16 => c_IGS_EN_SU_ATTEMPT_rec.attribute16,
1381: X_ATTRIBUTE17 => c_IGS_EN_SU_ATTEMPT_rec.attribute17,
1382: X_ATTRIBUTE18 => c_IGS_EN_SU_ATTEMPT_rec.attribute18,
1383: X_ATTRIBUTE19 => c_IGS_EN_SU_ATTEMPT_rec.attribute19,
1384: X_ATTRIBUTE20 => c_IGS_EN_SU_ATTEMPT_rec.attribute20,
1385: X_WAITLIST_MANUAL_IND => c_IGS_EN_SU_ATTEMPT_rec.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.
1386: X_WLST_PRIORITY_WEIGHT_NUM => c_IGS_EN_SU_ATTEMPT_rec.wlst_priority_weight_num,

Line 1383: X_ATTRIBUTE19 => c_IGS_EN_SU_ATTEMPT_rec.attribute19,

1379: X_ATTRIBUTE15 => c_IGS_EN_SU_ATTEMPT_rec.attribute15,
1380: X_ATTRIBUTE16 => c_IGS_EN_SU_ATTEMPT_rec.attribute16,
1381: X_ATTRIBUTE17 => c_IGS_EN_SU_ATTEMPT_rec.attribute17,
1382: X_ATTRIBUTE18 => c_IGS_EN_SU_ATTEMPT_rec.attribute18,
1383: X_ATTRIBUTE19 => c_IGS_EN_SU_ATTEMPT_rec.attribute19,
1384: X_ATTRIBUTE20 => c_IGS_EN_SU_ATTEMPT_rec.attribute20,
1385: X_WAITLIST_MANUAL_IND => c_IGS_EN_SU_ATTEMPT_rec.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.
1386: X_WLST_PRIORITY_WEIGHT_NUM => c_IGS_EN_SU_ATTEMPT_rec.wlst_priority_weight_num,
1387: X_WLST_PREFERENCE_WEIGHT_NUM => c_IGS_EN_SU_ATTEMPT_rec.wlst_preference_weight_num,

Line 1384: X_ATTRIBUTE20 => c_IGS_EN_SU_ATTEMPT_rec.attribute20,

1380: X_ATTRIBUTE16 => c_IGS_EN_SU_ATTEMPT_rec.attribute16,
1381: X_ATTRIBUTE17 => c_IGS_EN_SU_ATTEMPT_rec.attribute17,
1382: X_ATTRIBUTE18 => c_IGS_EN_SU_ATTEMPT_rec.attribute18,
1383: X_ATTRIBUTE19 => c_IGS_EN_SU_ATTEMPT_rec.attribute19,
1384: X_ATTRIBUTE20 => c_IGS_EN_SU_ATTEMPT_rec.attribute20,
1385: X_WAITLIST_MANUAL_IND => c_IGS_EN_SU_ATTEMPT_rec.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.
1386: X_WLST_PRIORITY_WEIGHT_NUM => c_IGS_EN_SU_ATTEMPT_rec.wlst_priority_weight_num,
1387: X_WLST_PREFERENCE_WEIGHT_NUM => c_IGS_EN_SU_ATTEMPT_rec.wlst_preference_weight_num,
1388: -- CORE_INDICATOR_CODE added by rvangala 07-OCT-2003. Enh Bug# 3052432

Line 1385: X_WAITLIST_MANUAL_IND => c_IGS_EN_SU_ATTEMPT_rec.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.

1381: X_ATTRIBUTE17 => c_IGS_EN_SU_ATTEMPT_rec.attribute17,
1382: X_ATTRIBUTE18 => c_IGS_EN_SU_ATTEMPT_rec.attribute18,
1383: X_ATTRIBUTE19 => c_IGS_EN_SU_ATTEMPT_rec.attribute19,
1384: X_ATTRIBUTE20 => c_IGS_EN_SU_ATTEMPT_rec.attribute20,
1385: X_WAITLIST_MANUAL_IND => c_IGS_EN_SU_ATTEMPT_rec.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.
1386: X_WLST_PRIORITY_WEIGHT_NUM => c_IGS_EN_SU_ATTEMPT_rec.wlst_priority_weight_num,
1387: X_WLST_PREFERENCE_WEIGHT_NUM => c_IGS_EN_SU_ATTEMPT_rec.wlst_preference_weight_num,
1388: -- CORE_INDICATOR_CODE added by rvangala 07-OCT-2003. Enh Bug# 3052432
1389: X_CORE_INDICATOR_CODE => c_IGS_EN_SU_ATTEMPT_rec.core_indicator_code

Line 1386: X_WLST_PRIORITY_WEIGHT_NUM => c_IGS_EN_SU_ATTEMPT_rec.wlst_priority_weight_num,

1382: X_ATTRIBUTE18 => c_IGS_EN_SU_ATTEMPT_rec.attribute18,
1383: X_ATTRIBUTE19 => c_IGS_EN_SU_ATTEMPT_rec.attribute19,
1384: X_ATTRIBUTE20 => c_IGS_EN_SU_ATTEMPT_rec.attribute20,
1385: X_WAITLIST_MANUAL_IND => c_IGS_EN_SU_ATTEMPT_rec.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.
1386: X_WLST_PRIORITY_WEIGHT_NUM => c_IGS_EN_SU_ATTEMPT_rec.wlst_priority_weight_num,
1387: X_WLST_PREFERENCE_WEIGHT_NUM => c_IGS_EN_SU_ATTEMPT_rec.wlst_preference_weight_num,
1388: -- CORE_INDICATOR_CODE added by rvangala 07-OCT-2003. Enh Bug# 3052432
1389: X_CORE_INDICATOR_CODE => c_IGS_EN_SU_ATTEMPT_rec.core_indicator_code
1390: );

Line 1387: X_WLST_PREFERENCE_WEIGHT_NUM => c_IGS_EN_SU_ATTEMPT_rec.wlst_preference_weight_num,

1383: X_ATTRIBUTE19 => c_IGS_EN_SU_ATTEMPT_rec.attribute19,
1384: X_ATTRIBUTE20 => c_IGS_EN_SU_ATTEMPT_rec.attribute20,
1385: X_WAITLIST_MANUAL_IND => c_IGS_EN_SU_ATTEMPT_rec.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.
1386: X_WLST_PRIORITY_WEIGHT_NUM => c_IGS_EN_SU_ATTEMPT_rec.wlst_priority_weight_num,
1387: X_WLST_PREFERENCE_WEIGHT_NUM => c_IGS_EN_SU_ATTEMPT_rec.wlst_preference_weight_num,
1388: -- CORE_INDICATOR_CODE added by rvangala 07-OCT-2003. Enh Bug# 3052432
1389: X_CORE_INDICATOR_CODE => c_IGS_EN_SU_ATTEMPT_rec.core_indicator_code
1390: );
1391:

Line 1389: X_CORE_INDICATOR_CODE => c_IGS_EN_SU_ATTEMPT_rec.core_indicator_code

1385: X_WAITLIST_MANUAL_IND => c_IGS_EN_SU_ATTEMPT_rec.waitlist_manual_ind ,--Added by mesriniv for Bug 2554109 Mini Waitlist Build.
1386: X_WLST_PRIORITY_WEIGHT_NUM => c_IGS_EN_SU_ATTEMPT_rec.wlst_priority_weight_num,
1387: X_WLST_PREFERENCE_WEIGHT_NUM => c_IGS_EN_SU_ATTEMPT_rec.wlst_preference_weight_num,
1388: -- CORE_INDICATOR_CODE added by rvangala 07-OCT-2003. Enh Bug# 3052432
1389: X_CORE_INDICATOR_CODE => c_IGS_EN_SU_ATTEMPT_rec.core_indicator_code
1390: );
1391:
1392: IF v_unit_cds IS NULL THEN
1393: v_unit_cds := v_sua.unit_cd;

Line 1398: v_uoo_ids := to_char(c_IGS_EN_SU_ATTEMPT_rec.uoo_id);

1394: ELSE
1395: v_unit_cds := v_unit_Cds || ',' || v_sua.unit_Cd;
1396: END IF;
1397: IF v_uoo_ids IS NULL THEN
1398: v_uoo_ids := to_char(c_IGS_EN_SU_ATTEMPT_rec.uoo_id);
1399: ELSE
1400: v_uoo_ids := v_uoo_ids || ',' || to_char(c_IGS_EN_SU_ATTEMPT_rec.uoo_id);
1401: END IF;
1402: END LOOP;

Line 1400: v_uoo_ids := v_uoo_ids || ',' || to_char(c_IGS_EN_SU_ATTEMPT_rec.uoo_id);

1396: END IF;
1397: IF v_uoo_ids IS NULL THEN
1398: v_uoo_ids := to_char(c_IGS_EN_SU_ATTEMPT_rec.uoo_id);
1399: ELSE
1400: v_uoo_ids := v_uoo_ids || ',' || to_char(c_IGS_EN_SU_ATTEMPT_rec.uoo_id);
1401: END IF;
1402: END LOOP;
1403: END;
1404: END IF;

Line 1695: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

1691: ci.sequence_number = scae.ci_sequence_number AND
1692: ci.end_dt > SYSDATE
1693: ORDER BY ci.start_dt DESC; -- for latest date
1694: CURSOR c_sua (
1695: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1696: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE) IS
1697: SELECT ci.alternate_code,
1698: sua.cal_type,
1699: sua.ci_sequence_number

Line 1696: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE) IS

1692: ci.end_dt > SYSDATE
1693: ORDER BY ci.start_dt DESC; -- for latest date
1694: CURSOR c_sua (
1695: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1696: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE) IS
1697: SELECT ci.alternate_code,
1698: sua.cal_type,
1699: sua.ci_sequence_number
1700: FROM IGS_EN_SU_ATTEMPT sua,

Line 1700: FROM IGS_EN_SU_ATTEMPT sua,

1696: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE) IS
1697: SELECT ci.alternate_code,
1698: sua.cal_type,
1699: sua.ci_sequence_number
1700: FROM IGS_EN_SU_ATTEMPT sua,
1701: IGS_CA_INST ci
1702: WHERE sua.person_id = cp_person_id AND
1703: sua.course_cd = cp_course_cd AND
1704: sua.unit_attempt_status IN (cst_enrolled,cst_discontin,cst_completed) AND

Line 1712: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

1708: ORDER BY ci_start_dt DESC;
1709: v_sua_rec c_sua%ROWTYPE;
1710: v_scae_ci_rec c_scae_ci%ROWTYPE;
1711: CURSOR c_sca (
1712: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1713: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE) IS
1714: SELECT ROWID,sca.*
1715: FROM IGS_EN_STDNT_PS_ATT sca
1716: WHERE sca.person_id = cp_person_id AND

Line 1713: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE) IS

1709: v_sua_rec c_sua%ROWTYPE;
1710: v_scae_ci_rec c_scae_ci%ROWTYPE;
1711: CURSOR c_sca (
1712: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1713: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE) IS
1714: SELECT ROWID,sca.*
1715: FROM IGS_EN_STDNT_PS_ATT sca
1716: WHERE sca.person_id = cp_person_id AND
1717: sca.course_cd = cp_course_cd

Line 2479: FROM IGS_EN_SU_ATTEMPT sua

2475: sca.discontinued_dt IS NULL OR
2476: sca.discontinued_dt > SYSDATE
2477: ) AND
2478: NOT EXISTS ( SELECT 'x'
2479: FROM IGS_EN_SU_ATTEMPT sua
2480: WHERE sua.person_id = sca.person_id AND
2481: sua.unit_attempt_status = 'ENROLLED' AND
2482: sua.ci_start_dt <= SYSDATE) AND
2483: NOT EXISTS ( SELECT 'x'

Line 2503: FROM IGS_EN_SU_ATTEMPT sua

2499: FROM IGS_EN_STDNT_PS_ATT sca
2500: WHERE sca.course_attempt_status IN ('INACTIVE','LAPSED') AND
2501: EXISTS (
2502: SELECT 'x'
2503: FROM IGS_EN_SU_ATTEMPT sua
2504: WHERE person_id = sca.person_id AND
2505: course_cd = sca.course_cd AND
2506: unit_attempt_status = 'ENROLLED' AND
2507: ci_start_dt <= SYSDATE);

Line 3123: unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,

3119: BEGIN
3120: DECLARE
3121: -- table to hold sua records which have been checked and cannot be changed
3122: TYPE r_checked_sua_typ IS RECORD(
3123: unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
3124: cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
3125: ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE);
3126: r_checked_sua r_checked_sua_typ;
3127: TYPE t_checked_sua_typ IS TABLE OF r_checked_sua%TYPE

Line 3124: cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,

3120: DECLARE
3121: -- table to hold sua records which have been checked and cannot be changed
3122: TYPE r_checked_sua_typ IS RECORD(
3123: unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
3124: cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
3125: ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE);
3126: r_checked_sua r_checked_sua_typ;
3127: TYPE t_checked_sua_typ IS TABLE OF r_checked_sua%TYPE
3128: INDEX BY BINARY_INTEGER;

Line 3125: ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE);

3121: -- table to hold sua records which have been checked and cannot be changed
3122: TYPE r_checked_sua_typ IS RECORD(
3123: unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
3124: cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
3125: ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE);
3126: r_checked_sua r_checked_sua_typ;
3127: TYPE t_checked_sua_typ IS TABLE OF r_checked_sua%TYPE
3128: INDEX BY BINARY_INTEGER;
3129: t_checked_sua t_checked_sua_typ;

Line 3146: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;

3142: v_fail_type VARCHAR2(10);
3143: v_rec_found BOOLEAN;
3144: v_validation_error BOOLEAN;
3145: v_message_name VARCHAR2(30);
3146: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
3147: v_change_made BOOLEAN;
3148: PROCEDURE enrpl_upd_invalid_ua(
3149: p_acad_cal_type IGS_CA_INST.cal_type%TYPE,
3150: p_acad_sequence_number IGS_CA_INST.sequence_number%TYPE,

Line 3180: FROM IGS_EN_SU_ATTEMPT sua,

3176: Igs_En_Gen_004.enrp_get_rule_cutoff(
3177: sua.cal_type,
3178: sua.ci_sequence_number,
3179: cst_enrolled) enrolled_cutoff_date
3180: FROM IGS_EN_SU_ATTEMPT sua,
3181: IGS_EN_STDNT_PS_ATT sca
3182: WHERE sua.person_id = p_person_id AND
3183: sua.course_cd = p_course_cd AND
3184: sua.unit_attempt_status = cst_invalid AND

Line 3188: lv_rule_failed IGS_EN_SU_ATTEMPT.FAILED_UNIT_RULE%TYPE;

3184: sua.unit_attempt_status = cst_invalid AND
3185: sca.person_id = sua.person_id AND
3186: sca.course_cd = sua.course_cd;
3187:
3188: lv_rule_failed IGS_EN_SU_ATTEMPT.FAILED_UNIT_RULE%TYPE;
3189:
3190: BEGIN
3191: v_change_made := FALSE;
3192: FOR v_sua_sca_rec IN c_sua_sca LOOP

Line 3270: -- update igs_en_su_attempt

3266: v_ret_val := FALSE;
3267: v_validation_error := TRUE;
3268: ELSE
3269: DECLARE
3270: -- update igs_en_su_attempt
3271: CURSOR c_assu IS
3272: SELECT ROWID,
3273: IGS_EN_SU_ATTEMPT.*
3274: FROM IGS_EN_SU_ATTEMPT

Line 3273: IGS_EN_SU_ATTEMPT.*

3269: DECLARE
3270: -- update igs_en_su_attempt
3271: CURSOR c_assu IS
3272: SELECT ROWID,
3273: IGS_EN_SU_ATTEMPT.*
3274: FROM IGS_EN_SU_ATTEMPT
3275: WHERE person_id = v_sua_sca_rec.person_id AND
3276: course_cd = v_sua_sca_rec.course_cd AND
3277: uoo_id = v_sua_sca_rec.uoo_id

Line 3274: FROM IGS_EN_SU_ATTEMPT

3270: -- update igs_en_su_attempt
3271: CURSOR c_assu IS
3272: SELECT ROWID,
3273: IGS_EN_SU_ATTEMPT.*
3274: FROM IGS_EN_SU_ATTEMPT
3275: WHERE person_id = v_sua_sca_rec.person_id AND
3276: course_cd = v_sua_sca_rec.course_cd AND
3277: uoo_id = v_sua_sca_rec.uoo_id
3278: FOR UPDATE NOWAIT;

Line 3458: FROM IGS_EN_SU_ATTEMPT sua

3454: Igs_En_Gen_004.enrp_get_rule_cutoff(
3455: sua.cal_type,
3456: sua.ci_sequence_number,
3457: cst_invalid) invalid_cutoff_date
3458: FROM IGS_EN_SU_ATTEMPT sua
3459: WHERE sua.person_id = p_person_id AND
3460: sua.course_cd = p_course_cd AND
3461: sua.unit_attempt_status = cst_enrolled AND
3462: sua.rule_waived_dt IS NULL;

Line 3539: -- set the IGS_EN_SU_ATTEMPT to invalid as rules are being breached

3535: t_checked_sua(gv_cntr).cal_type := v_sua_rec.cal_type;
3536: t_checked_sua(gv_cntr).ci_sequence_number
3537: := v_sua_rec.ci_sequence_number;
3538: ELSE
3539: -- set the IGS_EN_SU_ATTEMPT to invalid as rules are being breached
3540: -- update IGS_EN_SU_ATTEMPT
3541: DECLARE
3542: CURSOR c_suatt IS
3543: SELECT ROWID,

Line 3540: -- update IGS_EN_SU_ATTEMPT

3536: t_checked_sua(gv_cntr).ci_sequence_number
3537: := v_sua_rec.ci_sequence_number;
3538: ELSE
3539: -- set the IGS_EN_SU_ATTEMPT to invalid as rules are being breached
3540: -- update IGS_EN_SU_ATTEMPT
3541: DECLARE
3542: CURSOR c_suatt IS
3543: SELECT ROWID,
3544: IGS_EN_SU_ATTEMPT.*

Line 3544: IGS_EN_SU_ATTEMPT.*

3540: -- update IGS_EN_SU_ATTEMPT
3541: DECLARE
3542: CURSOR c_suatt IS
3543: SELECT ROWID,
3544: IGS_EN_SU_ATTEMPT.*
3545: FROM IGS_EN_SU_ATTEMPT
3546: WHERE person_id = v_sua_rec.person_id AND
3547: course_cd = v_sua_rec.course_cd AND
3548: uoo_id = v_sua_rec.uoo_id

Line 3545: FROM IGS_EN_SU_ATTEMPT

3541: DECLARE
3542: CURSOR c_suatt IS
3543: SELECT ROWID,
3544: IGS_EN_SU_ATTEMPT.*
3545: FROM IGS_EN_SU_ATTEMPT
3546: WHERE person_id = v_sua_rec.person_id AND
3547: course_cd = v_sua_rec.course_cd AND
3548: uoo_id = v_sua_rec.uoo_id
3549: FOR UPDATE NOWAIT;