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

Line 13: --ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row and

9: -- create_stream_unit_sets,update_stream_unit_sets.
10: -- Changed procedures create_unit_set,create_stream_unit_sets,update_stream_unit_sets
11: -- enrpl_copy_adm_unit_sets to functions which returns booleanfor bug 3149133.
12: --
13: --ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row and
14: -- IGS_EN_STDNT_PS_ATT_Pkg.Insert_Row Procedure call as a part of bug 3544927.
15: --rvangala 04-Dec-2003 Added call to igs_ss_enr_details.enrp_get_prgm_for_career to check for
16: -- primary program in enrp_valid_inst_sua
17: --ijeddy, Dec 3, 2003 Grade Book Enh build, bug no 3201661

Line 14: -- IGS_EN_STDNT_PS_ATT_Pkg.Insert_Row Procedure call as a part of bug 3544927.

10: -- Changed procedures create_unit_set,create_stream_unit_sets,update_stream_unit_sets
11: -- enrpl_copy_adm_unit_sets to functions which returns booleanfor bug 3149133.
12: --
13: --ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row and
14: -- IGS_EN_STDNT_PS_ATT_Pkg.Insert_Row Procedure call as a part of bug 3544927.
15: --rvangala 04-Dec-2003 Added call to igs_ss_enr_details.enrp_get_prgm_for_career to check for
16: -- primary program in enrp_valid_inst_sua
17: --ijeddy, Dec 3, 2003 Grade Book Enh build, bug no 3201661
18:

Line 35: --nalkumar 5-OCT-2001 Modified the IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW and IGS_EN_STDNT_PS_ATT_PKG.INSERT_ROW calls.

31: --amuthu 23-Sep-02 Modified the code as per the EN Core Vs Option TD. Added logic
32: -- to call Enrp_Ins_Pre_Pos when the p_units_ind(icator) parameter
33: -- value is either 'Y' or 'CORE_ONLY'
34: --ayedubat 04-JUN-2002 Changed the functions: enrp_ins_snew_prenrl, enrp_ins_sret_prenrl for bug # 2391842
35: --nalkumar 5-OCT-2001 Modified the IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW and IGS_EN_STDNT_PS_ATT_PKG.INSERT_ROW calls.
36: -- Added four new parameters to call it as per the Bug# 2027984.
37: --Aiyer 10-Oct-2001 Added the columns grading schema and gs_version_number in all
38: -- Tbh calls of IGS_EN_SU_ATTEMPT_PKG as a part of the bug 2037897.
39: --Bayadav 09-Nov-2001 Added the columns catalog cal type and catalog seq num in Enrp_ins_susa_hist

Line 43: --Nalin Kumar 16-Nov-2001 Added parameter key_program in IGS_EN_STDNT_PS_ATT_PKG.update_row call

39: --Bayadav 09-Nov-2001 Added the columns catalog cal type and catalog seq num in Enrp_ins_susa_hist
40: -- as a part of build of career impact DLD
41: --Nalin Kumar 11-Nov-2001 Added Procedure 'adv_stand_trans' as part of the Career Impact DLD.
42: -- Bug# 2027984.
43: --Nalin Kumar 16-Nov-2001 Added parameter key_program in IGS_EN_STDNT_PS_ATT_PKG.update_row call
44: -- as pert of the Career Impact DLD. Bug# 2027984.
45: --pmarada 27-nov-2001 Modified the adv_stand_trans procedure as part of AVCR001 Advanced standing dld..
46: --pradhakr 06-Dec-2001 Added the column deg_aud_detail_id as part of Degree Audit Interfacec build. (Bug# 2033208)
47: --svenkata 20-Dec-2001 Added columns student_career_transcript and Student_career_statistics as part of build Career

Line 341: -- * Create a IGS_EN_STDNT_PS_ATT record

337: -- This process will pre-enrol a single new student in the specified
338: -- IGS_PS_COURSE. The following steps will be performed :
339: -- * Check the students eligibility to enrol in the specified IGS_PS_COURSE
340: -- in the specified academic calendar.
341: -- * Create a IGS_EN_STDNT_PS_ATT record
342: -- * Create a IGS_AS_SC_ATMPT_ENR record
343: -- * Create any required IGS_AS_SU_SETATMPT details
344: -- * Create default IGS_EN_STDNTPSHECSOP details
345: -- * Pre-enrol IGS_PS_UNIT attempts entered during Admissions, as parameter

Line 563: CURSOR c_us_version_number(cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

559: cf1.sequence_no > cf2.sequence_no
560: ORDER BY cf1.sequence_no asc;
561: c_next_us_rec c_next_us%ROWTYPE;
562:
563: CURSOR c_us_version_number(cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
564: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
565: cp_unit_set_cd igs_en_unit_set.unit_set_cd%TYPE) IS
566: SELECT coous.us_version_number
567: FROM igs_en_unit_set_stat uss, igs_ps_ofr_opt_unit_set_v coous, igs_en_stdnt_ps_att sca

Line 564: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,

560: ORDER BY cf1.sequence_no asc;
561: c_next_us_rec c_next_us%ROWTYPE;
562:
563: CURSOR c_us_version_number(cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
564: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
565: cp_unit_set_cd igs_en_unit_set.unit_set_cd%TYPE) IS
566: SELECT coous.us_version_number
567: FROM igs_en_unit_set_stat uss, igs_ps_ofr_opt_unit_set_v coous, igs_en_stdnt_ps_att sca
568: WHERE sca.person_id = cp_person_id AND

Line 567: FROM igs_en_unit_set_stat uss, igs_ps_ofr_opt_unit_set_v coous, igs_en_stdnt_ps_att sca

563: CURSOR c_us_version_number(cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
564: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
565: cp_unit_set_cd igs_en_unit_set.unit_set_cd%TYPE) IS
566: SELECT coous.us_version_number
567: FROM igs_en_unit_set_stat uss, igs_ps_ofr_opt_unit_set_v coous, igs_en_stdnt_ps_att sca
568: WHERE sca.person_id = cp_person_id AND
569: sca.course_cd = cp_course_cd AND
570: sca.coo_id = coous.coo_id AND
571: coous.unit_set_cd = cp_unit_set_cd AND

Line 650: FROM IGS_EN_STDNT_PS_ATT spa

646: ORDER BY ci.start_dt;
647:
648: CURSOR cur_spa IS
649: SELECT spa.commencement_dt
650: FROM IGS_EN_STDNT_PS_ATT spa
651: WHERE spa.person_id = p_person_id AND
652: spa.course_cd = p_course_cd;
653:
654: l_load_cal_type igs_ca_inst.cal_type%TYPE;

Line 999: sarakshi 16-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the insert row,update call of IGS_EN_STDNT_PS_ATT_PKG

995: AS
996: /****************************************************************************
997: History
998: Who When Why
999: sarakshi 16-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the insert row,update call of IGS_EN_STDNT_PS_ATT_PKG
1000: ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure
1001: call as a part of bug 3544927.
1002: smaddali modified this procedure to create the HESA UK statistics record
1003: whenever oss program attempt record is being created for bug#2350629

Line 1000: ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure

996: /****************************************************************************
997: History
998: Who When Why
999: sarakshi 16-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the insert row,update call of IGS_EN_STDNT_PS_ATT_PKG
1000: ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure
1001: call as a part of bug 3544927.
1002: smaddali modified this procedure to create the HESA UK statistics record
1003: whenever oss program attempt record is being created for bug#2350629
1004: svanukur 15-APR-2004 Passing the values for catalog fields while creating or updating a SPA. bug 3548376

Line 1009: -- Create a IGS_EN_STDNT_PS_ATT record

1005: ctyagi 15-march-2005 Modify cursor cur_catalog_details for bug #4238062 (INCORRECT SPA CATALOG CODE )
1006: *****************************************************************************/
1007:
1008: BEGIN -- enrpl_create_sca
1009: -- Create a IGS_EN_STDNT_PS_ATT record
1010: DECLARE
1011:
1012: CURSOR c_crv IS
1013: SELECT 'x'

Line 1039: FROM IGS_EN_STDNT_PS_ATT sca

1035: adm_admission_appl_number,
1036: adm_nominated_course_cd,
1037: adm_sequence_number,
1038: provisional_ind
1039: FROM IGS_EN_STDNT_PS_ATT sca
1040: WHERE person_id = p_person_id AND
1041: course_cd = p_course_cd;
1042: v_sca_rec c_sca%ROWTYPE;
1043:

Line 1045: SELECT rowid,IGS_EN_STDNT_PS_ATT.*

1041: course_cd = p_course_cd;
1042: v_sca_rec c_sca%ROWTYPE;
1043:
1044: CURSOR c_sca_upd IS
1045: SELECT rowid,IGS_EN_STDNT_PS_ATT.*
1046: FROM IGS_EN_STDNT_PS_ATT
1047: WHERE person_id = p_person_id AND
1048: course_cd = p_course_cd
1049: FOR UPDATE OF course_attempt_status,

Line 1046: FROM IGS_EN_STDNT_PS_ATT

1042: v_sca_rec c_sca%ROWTYPE;
1043:
1044: CURSOR c_sca_upd IS
1045: SELECT rowid,IGS_EN_STDNT_PS_ATT.*
1046: FROM IGS_EN_STDNT_PS_ATT
1047: WHERE person_id = p_person_id AND
1048: course_cd = p_course_cd
1049: FOR UPDATE OF course_attempt_status,
1050: fee_cat,

Line 1065: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

1061: catalog_seq_num NOWAIT;
1062:
1063: v_sca_upd_rec c_sca_upd%ROWTYPE;
1064: v_confirmed_ind VARCHAR2(1);
1065: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
1066: v_commencement_dt DATE ;
1067: v_description IGS_FI_FEE_CAT.description%TYPE;
1068: v_funding_source IGS_EN_STDNT_PS_ATT.funding_source%TYPE;
1069:

Line 1068: v_funding_source IGS_EN_STDNT_PS_ATT.funding_source%TYPE;

1064: v_confirmed_ind VARCHAR2(1);
1065: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
1066: v_commencement_dt DATE ;
1067: v_description IGS_FI_FEE_CAT.description%TYPE;
1068: v_funding_source IGS_EN_STDNT_PS_ATT.funding_source%TYPE;
1069:
1070: --bmerugu added for build 319
1071: v_rowid VARCHAR2(25);
1072: v_program_type IGS_EN_STDNT_PS_ATT.primary_program_type%TYPE;

Line 1072: v_program_type IGS_EN_STDNT_PS_ATT.primary_program_type%TYPE;

1068: v_funding_source IGS_EN_STDNT_PS_ATT.funding_source%TYPE;
1069:
1070: --bmerugu added for build 319
1071: v_rowid VARCHAR2(25);
1072: v_program_type IGS_EN_STDNT_PS_ATT.primary_program_type%TYPE;
1073:
1074: -- bmerugu added this cursor for build 319
1075: CURSOR c_sca_ptype (cp_rowid VARCHAR2) IS
1076: SELECT primary_program_type

Line 1077: FROM IGS_EN_STDNT_PS_ATT

1073:
1074: -- bmerugu added this cursor for build 319
1075: CURSOR c_sca_ptype (cp_rowid VARCHAR2) IS
1076: SELECT primary_program_type
1077: FROM IGS_EN_STDNT_PS_ATT
1078: WHERE rowid = cp_rowid;
1079:
1080: CURSOR c_sca_ctype (cp_rowid VARCHAR2) IS
1081: SELECT ps.course_type

Line 1083: igs_en_stdnt_ps_att spa

1079:
1080: CURSOR c_sca_ctype (cp_rowid VARCHAR2) IS
1081: SELECT ps.course_type
1082: FROM IGS_PS_VER ps,
1083: igs_en_stdnt_ps_att spa
1084: WHERE spa.rowid= cp_rowid
1085: AND ps.course_cd = spa.course_cd
1086: AND ps.version_number = spa.version_number;
1087: v_sca_ctype IGS_PS_VER.course_type%TYPE;

Line 1091: FROM igs_en_stdnt_ps_att spa,

1087: v_sca_ctype IGS_PS_VER.course_type%TYPE;
1088:
1089: CURSOR c_sca_primary(cp_course_type IGS_PS_VER.course_type%TYPE) IS
1090: SELECT 'X'
1091: FROM igs_en_stdnt_ps_att spa,
1092: igs_ps_ver pv
1093: WHERE spa.person_id = p_person_id
1094: AND spa.primary_program_type = 'PRIMARY'
1095: AND spa.course_cd = pv.course_cd

Line 1178: -- Create IGS_EN_STDNT_PS_ATT record matching offer

1174: v_acaiv_rec.admission_cat,
1175: v_description);
1176: END IF;
1177:
1178: -- Create IGS_EN_STDNT_PS_ATT record matching offer
1179: OPEN c_sca;
1180: FETCH c_sca INTO v_sca_rec;
1181: IF c_sca%NOTFOUND THEN
1182: CLOSE c_sca;

Line 1230: IGS_EN_STDNT_PS_ATT_PKG.INSERT_ROW(

1226: FETCH cur_catalog_details into catalog_cal_type, catalog_seq_num;
1227: CLOSE cur_catalog_details;
1228: END IF;
1229:
1230: IGS_EN_STDNT_PS_ATT_PKG.INSERT_ROW(
1231: x_rowid => l_rowid,
1232: x_person_id => p_person_id,
1233: x_course_cd => p_course_cd,
1234: x_version_number => v_acaiv_rec.crv_version_number,

Line 1421: IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW(

1417: FETCH cur_catalog_details into catalog_cal_type, catalog_seq_num;
1418: CLOSE cur_catalog_details;
1419: END IF;
1420:
1421: IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW(
1422: X_ROWID => v_sca_upd_rec.rowid,
1423: X_PERSON_ID => v_sca_upd_rec.PERSON_ID,
1424: X_COURSE_CD => v_sca_upd_rec.COURSE_CD,
1425: X_ADVANCED_STANDING_IND => v_sca_upd_rec.ADVANCED_STANDING_IND,

Line 1569: IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW(

1565: -- attempt according to the new offer.
1566: OPEN c_sca_upd;
1567: FETCH c_sca_upd INTO v_sca_upd_rec;
1568:
1569: IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW(
1570: X_ROWID => v_sca_upd_rec.rowid,
1571: X_PERSON_ID => v_sca_upd_rec.PERSON_ID,
1572: X_COURSE_CD => v_sca_upd_rec.COURSE_CD,
1573: X_ADVANCED_STANDING_IND => v_sca_upd_rec.ADVANCED_STANDING_IND,

Line 1722: IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW(

1718: BEGIN
1719: OPEN c_sca_upd;
1720: FETCH c_sca_upd INTO v_sca_upd_rec;
1721:
1722: IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW(
1723: X_ROWID => v_sca_upd_rec.rowid,
1724: X_PERSON_ID => v_sca_upd_rec.PERSON_ID,
1725: X_COURSE_CD => v_sca_upd_rec.COURSE_CD,
1726: X_ADVANCED_STANDING_IND => v_sca_upd_rec.ADVANCED_STANDING_IND,

Line 2147: FROM IGS_EN_STDNT_PS_ATT spa

2143: -- The Cursor has been added to check the Student Confirmed indicator is yes
2144: CURSOR c_spa IS
2145: SELECT spa.student_confirmed_ind,
2146: spa.commencement_dt ,spa.version_number
2147: FROM IGS_EN_STDNT_PS_ATT spa
2148: WHERE spa.person_id = p_person_id AND
2149: spa.course_cd = p_course_cd;
2150:
2151: -- Bug#2347141

Line 3279: IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE := v_sca_commencement_dt;

3275: apcs.s_admission_step_type = cst_fee_cntrct AND
3276: apcs.step_group_type <> 'TRACK'; -- 2402377
3277: v_apcs_exists VARCHAR2(1);
3278: v_commencement_dt2
3279: IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE := v_sca_commencement_dt;
3280: v_completion_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE ;
3281: BEGIN
3282: p_warn_level := NULL;
3283: p_message_name := null;

Line 3280: v_completion_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE ;

3276: apcs.step_group_type <> 'TRACK'; -- 2402377
3277: v_apcs_exists VARCHAR2(1);
3278: v_commencement_dt2
3279: IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE := v_sca_commencement_dt;
3280: v_completion_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE ;
3281: BEGIN
3282: p_warn_level := NULL;
3283: p_message_name := null;
3284: -- Check if a fee contract should be created.

Line 3459: -- create or update IGS_EN_STDNT_PS_ATT record

3455: p_message_name := v_message_name;
3456: RETURN FALSE;
3457: END IF;
3458:
3459: -- create or update IGS_EN_STDNT_PS_ATT record
3460: enrpl_create_sca(
3461: v_warn_level,
3462: v_message_name);
3463: IF v_message_name is not null THEN

Line 4116: FROM IGS_EN_STDNT_PS_ATT sca

4112: sca.attendance_type,
4113: sca.adm_admission_appl_number,
4114: sca.adm_nominated_course_cd,
4115: sca.adm_sequence_number
4116: FROM IGS_EN_STDNT_PS_ATT sca
4117: WHERE sca.person_id = p_person_id AND
4118: sca.course_cd = p_course_cd;
4119: v_sca_rec c_sca_details%ROWTYPE;
4120:

Line 4157: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

4153:
4154:
4155:
4156: CURSOR c_crv (
4157: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
4158: cp_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
4159: cp_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE,
4160: cp_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE,
4161: cp_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE,

Line 4158: cp_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,

4154:
4155:
4156: CURSOR c_crv (
4157: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
4158: cp_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
4159: cp_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE,
4160: cp_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE,
4161: cp_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE,
4162: cp_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE) IS

Line 4159: cp_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE,

4155:
4156: CURSOR c_crv (
4157: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
4158: cp_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
4159: cp_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE,
4160: cp_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE,
4161: cp_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE,
4162: cp_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE) IS
4163: SELECT 'x'

Line 4160: cp_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE,

4156: CURSOR c_crv (
4157: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
4158: cp_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
4159: cp_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE,
4160: cp_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE,
4161: cp_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE,
4162: cp_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE) IS
4163: SELECT 'x'
4164: FROM IGS_PS_VER crv,

Line 4161: cp_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE,

4157: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
4158: cp_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
4159: cp_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE,
4160: cp_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE,
4161: cp_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE,
4162: cp_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE) IS
4163: SELECT 'x'
4164: FROM IGS_PS_VER crv,
4165: IGS_PS_STAT cs,

Line 4162: cp_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE) IS

4158: cp_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
4159: cp_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE,
4160: cp_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE,
4161: cp_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE,
4162: cp_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE) IS
4163: SELECT 'x'
4164: FROM IGS_PS_VER crv,
4165: IGS_PS_STAT cs,
4166: IGS_PS_OFR_PAT cop

Line 4184: cp_adm_admission_appl_number IGS_EN_STDNT_PS_ATT.adm_admission_appl_number%TYPE,

4180: v_crv_rec VARCHAR2(1);
4181:
4182: -- Cursor to fetch the Unit Set and Admission Cal Type and Category of the pre-enrolling students.
4183: CURSOR c_acaiv(
4184: cp_adm_admission_appl_number IGS_EN_STDNT_PS_ATT.adm_admission_appl_number%TYPE,
4185: cp_adm_nominated_course_cd IGS_EN_STDNT_PS_ATT.adm_nominated_course_cd%TYPE,
4186: cp_adm_sequence_number IGS_EN_STDNT_PS_ATT.adm_sequence_number%TYPE ) IS
4187: SELECT acaiv.unit_set_cd,
4188: acaiv.adm_cal_type,

Line 4185: cp_adm_nominated_course_cd IGS_EN_STDNT_PS_ATT.adm_nominated_course_cd%TYPE,

4181:
4182: -- Cursor to fetch the Unit Set and Admission Cal Type and Category of the pre-enrolling students.
4183: CURSOR c_acaiv(
4184: cp_adm_admission_appl_number IGS_EN_STDNT_PS_ATT.adm_admission_appl_number%TYPE,
4185: cp_adm_nominated_course_cd IGS_EN_STDNT_PS_ATT.adm_nominated_course_cd%TYPE,
4186: cp_adm_sequence_number IGS_EN_STDNT_PS_ATT.adm_sequence_number%TYPE ) IS
4187: SELECT acaiv.unit_set_cd,
4188: acaiv.adm_cal_type,
4189: aa.admission_cat

Line 4186: cp_adm_sequence_number IGS_EN_STDNT_PS_ATT.adm_sequence_number%TYPE ) IS

4182: -- Cursor to fetch the Unit Set and Admission Cal Type and Category of the pre-enrolling students.
4183: CURSOR c_acaiv(
4184: cp_adm_admission_appl_number IGS_EN_STDNT_PS_ATT.adm_admission_appl_number%TYPE,
4185: cp_adm_nominated_course_cd IGS_EN_STDNT_PS_ATT.adm_nominated_course_cd%TYPE,
4186: cp_adm_sequence_number IGS_EN_STDNT_PS_ATT.adm_sequence_number%TYPE ) IS
4187: SELECT acaiv.unit_set_cd,
4188: acaiv.adm_cal_type,
4189: aa.admission_cat
4190: FROM IGS_AD_PS_APPL_INST acaiv,

Line 4284: CURSOR c_us_version_number(cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

4280: cf1.sequence_no > cf2.sequence_no
4281: ORDER BY cf1.sequence_no asc;
4282: c_next_us_rec c_next_us%ROWTYPE;
4283:
4284: CURSOR c_us_version_number(cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
4285: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
4286: cp_unit_set_cd igs_en_unit_set.unit_set_cd%TYPE) IS
4287: SELECT coous.us_version_number
4288: FROM igs_en_unit_set_stat uss, igs_ps_ofr_opt_unit_set_v coous, igs_en_stdnt_ps_att sca

Line 4285: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,

4281: ORDER BY cf1.sequence_no asc;
4282: c_next_us_rec c_next_us%ROWTYPE;
4283:
4284: CURSOR c_us_version_number(cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
4285: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
4286: cp_unit_set_cd igs_en_unit_set.unit_set_cd%TYPE) IS
4287: SELECT coous.us_version_number
4288: FROM igs_en_unit_set_stat uss, igs_ps_ofr_opt_unit_set_v coous, igs_en_stdnt_ps_att sca
4289: WHERE sca.person_id = cp_person_id AND

Line 4288: FROM igs_en_unit_set_stat uss, igs_ps_ofr_opt_unit_set_v coous, igs_en_stdnt_ps_att sca

4284: CURSOR c_us_version_number(cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
4285: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
4286: cp_unit_set_cd igs_en_unit_set.unit_set_cd%TYPE) IS
4287: SELECT coous.us_version_number
4288: FROM igs_en_unit_set_stat uss, igs_ps_ofr_opt_unit_set_v coous, igs_en_stdnt_ps_att sca
4289: WHERE sca.person_id = cp_person_id AND
4290: sca.course_cd = cp_course_cd AND
4291: sca.coo_id = coous.coo_id AND
4292: coous.unit_set_cd = cp_unit_set_cd AND

Line 5998: FUNCTION unit_effect_or_future_term( p_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,

5994: App_Exception.Raise_Exception;*/
5995: END enrp_ins_sua_hist;
5996:
5997:
5998: FUNCTION unit_effect_or_future_term( p_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,
5999: p_dest_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
6000: p_uoo_id igs_en_su_attempt_all.uoo_id%TYPE,
6001: p_term_cal_type igs_ca_inst_all.cal_type%TYPE,
6002: p_term_seq_num igs_ca_inst_all.sequence_number%TYPE)

Line 5999: p_dest_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,

5995: END enrp_ins_sua_hist;
5996:
5997:
5998: FUNCTION unit_effect_or_future_term( p_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,
5999: p_dest_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
6000: p_uoo_id igs_en_su_attempt_all.uoo_id%TYPE,
6001: p_term_cal_type igs_ca_inst_all.cal_type%TYPE,
6002: p_term_seq_num igs_ca_inst_all.sequence_number%TYPE)
6003:

Line 6013: FROM igs_en_stdnt_ps_att

6009: -------------------------------------------------------------------------------------------
6010:
6011: CURSOR c_sca_dtls IS
6012: SELECT cal_type
6013: FROM igs_en_stdnt_ps_att
6014: WHERE person_id = p_person_id AND
6015: course_cd = p_dest_course_cd ;
6016: -- Cursor to get the term calendar start date for a given term calendar instance.
6017: CURSOR c_get_term_start_dt(cp_term_cal_type igs_ca_inst.cal_type%TYPE,

Line 6060: l_acad_cal_type igs_en_stdnt_ps_att.cal_type%TYPE;

6056: AND cs.s_cal_status = 'ACTIVE'
6057: AND ci.start_dt > cp_curr_term_start_dt
6058: ORDER BY ci.start_dt ASC;
6059:
6060: l_acad_cal_type igs_en_stdnt_ps_att.cal_type%TYPE;
6061: l_effect_or_future_term BOOLEAN;
6062: l_load_ci_start_dt igs_ca_inst.start_dt%TYPE;
6063: l_dummy VARCHAR2(1);
6064:

Line 6303: CURSOR c_sua_career ( p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE , p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE ) IS

6299: sua.course_cd = p_transfer_course_cd AND
6300: sua.uoo_id = p_uoo_id
6301: FOR UPDATE OF sua.unit_attempt_status NOWAIT;
6302:
6303: CURSOR c_sua_career ( p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE , p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE ) IS
6304: SELECT ver.course_type
6305: FROM IGS_PS_VER ver ,
6306: igs_en_stdnt_ps_att spa
6307: WHERE ver.course_cd = p_course_cd AND

Line 6306: igs_en_stdnt_ps_att spa

6302:
6303: CURSOR c_sua_career ( p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE , p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE ) IS
6304: SELECT ver.course_type
6305: FROM IGS_PS_VER ver ,
6306: igs_en_stdnt_ps_att spa
6307: WHERE ver.course_cd = p_course_cd AND
6308: ver.version_number = spa.version_number AND
6309: spa.course_cd = p_course_cd AND
6310: spa.person_id = p_person_id;

Line 7952: CURSOR c_us_version_number(cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

7948: WHERE upc.unit_set_cd = cp_new_admin_unit_set_cd
7949: AND usm.mapping_set_cd = upc.mapping_set_cd
7950: AND usm.sequence_no = upc.sequence_no;
7951:
7952: CURSOR c_us_version_number(cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
7953: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
7954: cp_unit_set_cd igs_en_unit_set.unit_set_cd%TYPE) IS
7955: SELECT coous.us_version_number
7956: FROM igs_en_unit_set_stat uss, igs_ps_ofr_opt_unit_set_v coous, igs_en_stdnt_ps_att sca

Line 7953: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,

7949: AND usm.mapping_set_cd = upc.mapping_set_cd
7950: AND usm.sequence_no = upc.sequence_no;
7951:
7952: CURSOR c_us_version_number(cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
7953: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
7954: cp_unit_set_cd igs_en_unit_set.unit_set_cd%TYPE) IS
7955: SELECT coous.us_version_number
7956: FROM igs_en_unit_set_stat uss, igs_ps_ofr_opt_unit_set_v coous, igs_en_stdnt_ps_att sca
7957: WHERE sca.person_id = cp_person_id AND

Line 7956: FROM igs_en_unit_set_stat uss, igs_ps_ofr_opt_unit_set_v coous, igs_en_stdnt_ps_att sca

7952: CURSOR c_us_version_number(cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
7953: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
7954: cp_unit_set_cd igs_en_unit_set.unit_set_cd%TYPE) IS
7955: SELECT coous.us_version_number
7956: FROM igs_en_unit_set_stat uss, igs_ps_ofr_opt_unit_set_v coous, igs_en_stdnt_ps_att sca
7957: WHERE sca.person_id = cp_person_id AND
7958: sca.course_cd = cp_course_cd AND
7959: sca.coo_id = coous.coo_id AND
7960: coous.unit_set_cd = cp_unit_set_cd AND

Line 8645: CURSOR cur_course_type (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

8641: CURSOR c_per_num
8642: IS SELECT party_number FROM hz_parties
8643: WHERE party_id = p_person_id;
8644:
8645: CURSOR cur_course_type (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
8646: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
8647: SELECT course_type
8648: FROM IGS_PS_VER pv,
8649: IGS_EN_STDNT_PS_ATT sca

Line 8646: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS

8642: IS SELECT party_number FROM hz_parties
8643: WHERE party_id = p_person_id;
8644:
8645: CURSOR cur_course_type (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
8646: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
8647: SELECT course_type
8648: FROM IGS_PS_VER pv,
8649: IGS_EN_STDNT_PS_ATT sca
8650: WHERE sca.person_id = cp_person_id

Line 8649: IGS_EN_STDNT_PS_ATT sca

8645: CURSOR cur_course_type (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
8646: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
8647: SELECT course_type
8648: FROM IGS_PS_VER pv,
8649: IGS_EN_STDNT_PS_ATT sca
8650: WHERE sca.person_id = cp_person_id
8651: AND sca.course_cd = cp_course_cd
8652: AND pv.course_cd = sca.course_cd
8653: AND pv.version_number = sca.version_number;

Line 9350: CURSOR c_sua_career ( cp_person_id IN igs_en_stdnt_ps_att.person_id%TYPE ,

9346: v_get_all_units_in_src_rec c_get_all_units_in_src%ROWTYPE;
9347: l_temp_uoo_ids VARCHAR2(1000);
9348:
9349: -- get the course type of the passed program attempt
9350: CURSOR c_sua_career ( cp_person_id IN igs_en_stdnt_ps_att.person_id%TYPE ,
9351: cp_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE ) IS
9352: SELECT ver.course_type
9353: FROM IGS_PS_VER ver ,
9354: igs_en_stdnt_ps_att spa

Line 9351: cp_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE ) IS

9347: l_temp_uoo_ids VARCHAR2(1000);
9348:
9349: -- get the course type of the passed program attempt
9350: CURSOR c_sua_career ( cp_person_id IN igs_en_stdnt_ps_att.person_id%TYPE ,
9351: cp_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE ) IS
9352: SELECT ver.course_type
9353: FROM IGS_PS_VER ver ,
9354: igs_en_stdnt_ps_att spa
9355: WHERE ver.course_cd = spa.course_cd AND

Line 9354: igs_en_stdnt_ps_att spa

9350: CURSOR c_sua_career ( cp_person_id IN igs_en_stdnt_ps_att.person_id%TYPE ,
9351: cp_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE ) IS
9352: SELECT ver.course_type
9353: FROM IGS_PS_VER ver ,
9354: igs_en_stdnt_ps_att spa
9355: WHERE ver.course_cd = spa.course_cd AND
9356: ver.version_number = spa.version_number AND
9357: spa.course_cd = cp_course_cd AND
9358: spa.person_id = cp_person_id;

Line 10153: FROM IGS_EN_STDNT_PS_ATT sca

10149: CURSOR c_sca IS
10150: SELECT sca.version_number,
10151: sca.coo_id,
10152: sca.commencement_dt
10153: FROM IGS_EN_STDNT_PS_ATT sca
10154: WHERE person_id = p_person_id AND
10155: course_cd = p_course_cd;
10156: CURSOR c_sua IS
10157: SELECT uoo_id