[Home] [Help]
24: -- the call to enrp_ins_snew_prenrl and enrp_ins_sret_prenrl in IGS_EN_GEN_008
25: -- amuthu 10-JUN-2003 modified as per the UK Streaming and Repeat TD (bug 2829265)
26: -- amuthu 04-FEB-2003 removed the exception section from enrp_ins_suao_discon
27: -- as part of bug 2782096.
28: -- pradhakr 19-Dec-2002 Changed the call to the insert_row of igs_en_su_attempt
29: -- table to igs_en_sua_api.create_unit_attempt.
30: -- Changes wrt ENCR031 build. Bug#2643207
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
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
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.
51: --Nalin Kumar 28-Jan-2002 Added Procedure 'enrp_ins_sca_ukstat_trnsfr' and modified function enrp_ins_susa_trnsfr
52: -- procedure as pert of the HESA Intregation DLD (ENCR019). Bug# 2201753.
53: --prraj 21-Feb-2002 Added column QUAL_DETS_ID to the tbh calls of pkg
54: -- IGS_AV_STND_UNIT_LVL_PKG (Bug# 2233334)
55: --Added refernces to column ORG_UNIT_CD in call to IGS_EN_SU_ATTEMPT TBH call as a part of bug 1964697
56: --pmarada 24-Feb-2002 Added the copy-hesa_details Procedure, for the hesa requirment.
57: --Nishikant 03-May-2002 The Local procedure enrpl_copy_adm_unit_sets got modified to make Unit Sets Confirmed if
58: -- Program attempt got confirmed - due to the Enhancement Bug#2347141
59: --smadadli 14-may-2002 Modified procedures copy_hesa_details , enrp_ins_snew_prenrl , enrp_ins_sret_prenrl for bug#2350629
2400: p_lload_ci_seq_num IN NUMBER)
2401: AS
2402: /*****************************************************/
2403: --Who When What
2404: --mesriniv 12-sep-2002 Added a new parameter waitlist_manual_ind in insert row of IGS_EN_SU_ATTEMPT
2405: -- for Bug 2554109 MINI Waitlist Build for Jan 03 Release
2406: --ptandon 06-Oct-2003 Modified to get the value of core indicator and pass to Igs_En_Gen_010.enrp_vald_inst_sua
2407: -- as part of Prevent Dropping Core Units. Enh Bug# 3052432.
2408: /****************************************************/
2437: acaiu.unit_class = uoo.unit_class
2438: ORDER BY uoo.sup_uoo_id DESC;
2439:
2440: CURSOR c_sua (
2441: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
2442: cp_uv_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE) IS
2443: SELECT 'x'
2444: FROM IGS_EN_SU_ATTEMPT sua
2445: WHERE person_id = p_person_id AND
2438: ORDER BY uoo.sup_uoo_id DESC;
2439:
2440: CURSOR c_sua (
2441: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
2442: cp_uv_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE) IS
2443: SELECT 'x'
2444: FROM IGS_EN_SU_ATTEMPT sua
2445: WHERE person_id = p_person_id AND
2446: course_cd = p_course_cd AND
2440: CURSOR c_sua (
2441: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
2442: cp_uv_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE) IS
2443: SELECT 'x'
2444: FROM IGS_EN_SU_ATTEMPT sua
2445: WHERE person_id = p_person_id AND
2446: course_cd = p_course_cd AND
2447: unit_cd = cp_unit_cd AND
2448: version_number = cp_uv_version_number;
2465: AND unit_class = cp_unit_class;
2466:
2467: CURSOR c_sua_status(p_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS
2468: SELECT DECODE(sua.unit_attempt_status, 'UNCONFIRM', 'N', 'WAITLISTED', 'Y' , NULL)
2469: FROM IGS_EN_SU_ATTEMPT sua
2470: WHERE sua.person_id = p_person_id AND
2471: sua.course_cd = p_course_cd AND
2472: sua.uoo_id = p_uoo_id;
2473:
2484: v_log_creation_dt DATE;
2485: v_ci_start_dt DATE;
2486: v_ci_end_dt DATE;
2487: l_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;
2488: l_core_indicator IGS_EN_SU_ATTEMPT.core_indicator_code%TYPE;
2489: l_uoo_ids VARCHAR2(2000);
2490: l_enr_uoo_ids VARCHAR2(2000);
2491: l_waitlist_flag VARCHAR2(1) := NULL;
2492: l_out_uoo_ids VARCHAR2(2000);
2491: l_waitlist_flag VARCHAR2(1) := NULL;
2492: l_out_uoo_ids VARCHAR2(2000);
2493: l_waitlist_uoo_ids VARCHAR2(2000);
2494: l_failed_uoo_ids VARCHAR2(2000);
2495: l_unit_attempt_status igs_en_su_Attempt.unit_attempt_status%type;
2496: l_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE;
2497: l_seq_num IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE;
2498: l_sup_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;
2499: l_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;
2739: cs.CAL_STATUS = ci.CAL_STATUS AND
2740: cs.s_cal_status = 'ACTIVE'
2741: ORDER BY ci.start_dt;
2742: CURSOR c_sua (
2743: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
2744: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
2745: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
2746: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
2747: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
2740: cs.s_cal_status = 'ACTIVE'
2741: ORDER BY ci.start_dt;
2742: CURSOR c_sua (
2743: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
2744: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
2745: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
2746: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
2747: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
2748: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
2741: ORDER BY ci.start_dt;
2742: CURSOR c_sua (
2743: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
2744: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
2745: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
2746: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
2747: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
2748: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
2749: cp_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE) IS
2742: CURSOR c_sua (
2743: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
2744: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
2745: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
2746: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
2747: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
2748: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
2749: cp_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE) IS
2750: SELECT 'x'
2743: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
2744: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
2745: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
2746: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
2747: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
2748: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
2749: cp_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE) IS
2750: SELECT 'x'
2751: FROM IGS_EN_SU_ATTEMPT
2744: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
2745: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
2746: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
2747: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
2748: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
2749: cp_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE) IS
2750: SELECT 'x'
2751: FROM IGS_EN_SU_ATTEMPT
2752: WHERE person_id = cp_person_id AND
2745: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
2746: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
2747: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
2748: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
2749: cp_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE) IS
2750: SELECT 'x'
2751: FROM IGS_EN_SU_ATTEMPT
2752: WHERE person_id = cp_person_id AND
2753: course_cd = cp_course_cd AND
2747: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
2748: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
2749: cp_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE) IS
2750: SELECT 'x'
2751: FROM IGS_EN_SU_ATTEMPT
2752: WHERE person_id = cp_person_id AND
2753: course_cd = cp_course_cd AND
2754: unit_cd = cp_unit_cd AND
2755: cal_type = cp_cal_type AND
2758: unit_class = cp_unit_class;
2759:
2760: CURSOR c_sua_status(p_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS
2761: SELECT DECODE(sua.unit_attempt_status, 'UNCONFIRM', 'N', 'WAITLISTED', 'Y' , NULL)
2762: FROM IGS_EN_SU_ATTEMPT sua
2763: WHERE sua.person_id = p_person_id AND
2764: sua.course_cd = p_course_cd AND
2765: sua.uoo_id = p_uoo_id;
2766:
2792: v_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;
2793: v_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE;
2794: v_location_cd IGS_PS_UNIT_OFR_OPT.location_cd%TYPE;
2795: v_unit_class IGS_PS_UNIT_OFR_OPT.unit_class%TYPE;
2796: l_core_indicator IGS_EN_SU_ATTEMPT.core_indicator_code%TYPE;
2797:
2798: l_rel_type IGS_PS_UNIT_OFR_OPT.relation_type%TYPE;
2799: l_uoo_ids VARCHAR2(2000);
2800: l_enr_uoo_ids VARCHAR2(2000);
3849: --bmerugu added condition for build 319
3850: IF (l_sua_create = TRUE) THEN
3851: BEGIN
3852: -- Pre-enrollment of Unit Attempts
3853: -- copy admissions IGS_EN_SU_ATTEMPT
3854: enrpl_copy_adm_sua(
3855: v_warn_level,
3856: v_message_name,
3857: v_adm_added_ind,
3872:
3873: IF v_adm_added_ind = 'N' THEN
3874: -- Pre-enrol IGS_PS_UNIT attempts entered during Admissions, as parameter
3875: -- to the process.
3876: -- create parameter IGS_EN_SU_ATTEMPT
3877: enrpl_copy_param_sua(
3878: p_warn_level => v_warn_level,
3879: p_message_name => v_message_name,
3880: p_added_ind => v_parm_added_ind,
3898: IF ( p_units_indicator = 'Y' OR p_units_indicator = 'CORE_ONLY' )THEN
3899:
3900: -- Pre-enrol IGS_PS_UNIT attempts entered during Admissions
3901: -- through the Pattern of Study.
3902: -- create pattern of study IGS_EN_SU_ATTEMPT
3903: enrpl_create_pos_sua(
3904: p_unit_set_cd => v_unit_set_cd,
3905: p_warn_level => v_warn_level,
3906: p_message_name => v_message_name,
4083: -- specified academic calendar.
4084: -- * Determine the enrolment category from either a previous pre-enrolment
4085: -- or the default enrolment category passed to the routine.
4086: -- * Create IGS_AS_SC_ATMPT_ENR record.
4087: -- * Pre-enrol the students IGS_EN_SU_ATTEMPT records (next phase)
4088: -- If at any point it becomes impossible to pre-enrol the student, the
4089: -- routine will return FALSE and message number of a message indicating the
4090: -- reason for failure. This can be used by the calling routine (whether batch
4091: -- or online) to indicate who was and wasn't pre-enrolled.
4387: cs.s_cal_status = 'ACTIVE'
4388: ORDER BY ci.start_dt;
4389:
4390: CURSOR c_sua (
4391: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
4392: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
4393: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
4394: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
4395: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
4388: ORDER BY ci.start_dt;
4389:
4390: CURSOR c_sua (
4391: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
4392: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
4393: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
4394: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
4395: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
4396: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
4389:
4390: CURSOR c_sua (
4391: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
4392: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
4393: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
4394: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
4395: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
4396: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
4397: cp_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE) IS
4390: CURSOR c_sua (
4391: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
4392: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
4393: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
4394: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
4395: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
4396: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
4397: cp_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE) IS
4398: SELECT 'x'
4391: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
4392: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
4393: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
4394: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
4395: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
4396: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
4397: cp_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE) IS
4398: SELECT 'x'
4399: FROM IGS_EN_SU_ATTEMPT
4392: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
4393: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
4394: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
4395: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
4396: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
4397: cp_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE) IS
4398: SELECT 'x'
4399: FROM IGS_EN_SU_ATTEMPT
4400: WHERE person_id = cp_person_id AND
4393: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
4394: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
4395: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
4396: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
4397: cp_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE) IS
4398: SELECT 'x'
4399: FROM IGS_EN_SU_ATTEMPT
4400: WHERE person_id = cp_person_id AND
4401: course_cd = cp_course_cd AND
4395: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
4396: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
4397: cp_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE) IS
4398: SELECT 'x'
4399: FROM IGS_EN_SU_ATTEMPT
4400: WHERE person_id = cp_person_id AND
4401: course_cd = cp_course_cd AND
4402: unit_cd = cp_unit_cd AND
4403: cal_type = cp_cal_type AND
4407:
4408: --cursor to select the unit section status , placements build.
4409: CURSOR c_sua_status(p_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS
4410: SELECT DECODE(sua.unit_attempt_status, 'UNCONFIRM', 'N', 'WAITLISTED', 'Y' , NULL)
4411: FROM IGS_EN_SU_ATTEMPT sua
4412: WHERE sua.person_id = p_person_id AND
4413: sua.course_cd = p_course_cd AND
4414: sua.uoo_id = p_uoo_id;
4415:
4443: v_unit_cd IGS_PS_UNIT_OFR_OPT.unit_cd%TYPE;
4444: v_cal_type IGS_PS_UNIT_OFR_OPT.cal_type%TYPE;
4445: v_location_cd IGS_PS_UNIT_OFR_OPT.location_cd%TYPE;
4446: v_unit_class IGS_PS_UNIT_OFR_OPT.unit_class%TYPE;
4447: l_core_indicator IGS_EN_SU_ATTEMPT.core_indicator_code%TYPE;
4448:
4449: --following vars added as part of placements build.
4450: l_rel_type IGS_PS_UNIT_OFR_OPT.relation_type%TYPE;
4451: l_uoo_ids VARCHAR2(2000);
5431: v_admission_cat := NULL;
5432: END IF;
5433:
5434: -- Pre-enrol UNIT attempts passed as parameters to the process.
5435: -- create parameter IGS_EN_SU_ATTEMPT
5436: enrpl_copy_param_sua(
5437: p_warn_level => v_warn_level,
5438: p_message_name => v_message_name,
5439: p_added_ind => v_parm_added_ind,
5588: -- w.r.t. bug number 2829262
5589: -------------------------------------------------------------------------------------------
5590: gv_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
5591: gv_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
5592: gv_admin_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE;
5593: gv_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
5594: gv_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE;
5595: gv_message_name VARCHAR2(2000);
5596: gv_input BOOLEAN;
5590: gv_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
5591: gv_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
5592: gv_admin_unit_status IGS_EN_SU_ATTEMPT.administrative_unit_status%TYPE;
5593: gv_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
5594: gv_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE;
5595: gv_message_name VARCHAR2(2000);
5596: gv_input BOOLEAN;
5597: l_exists NUMBER(1);
5598: BEGIN
5598: BEGIN
5599: DECLARE
5600:
5601: CURSOR c_suao_details
5602: (cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
5603: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
5604: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE,
5605: cp_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE) IS
5606: SELECT 1
5599: DECLARE
5600:
5601: CURSOR c_suao_details
5602: (cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
5603: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
5604: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE,
5605: cp_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE) IS
5606: SELECT 1
5607: FROM IGS_AS_SU_STMPTOUT
5600:
5601: CURSOR c_suao_details
5602: (cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
5603: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
5604: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE,
5605: cp_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE) IS
5606: SELECT 1
5607: FROM IGS_AS_SU_STMPTOUT
5608: WHERE person_id = cp_person_id AND
5601: CURSOR c_suao_details
5602: (cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
5603: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
5604: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE,
5605: cp_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE) IS
5606: SELECT 1
5607: FROM IGS_AS_SU_STMPTOUT
5608: WHERE person_id = cp_person_id AND
5609: course_cd = cp_course_cd AND
5723: END;
5724: END enrp_ins_suao_discon;
5725:
5726: PROCEDURE Enrp_Ins_Sua_Hist(
5727: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
5728: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
5729: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
5730: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
5731: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
5724: END enrp_ins_suao_discon;
5725:
5726: PROCEDURE Enrp_Ins_Sua_Hist(
5727: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
5728: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
5729: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
5730: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
5731: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
5732: p_new_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
5725:
5726: PROCEDURE Enrp_Ins_Sua_Hist(
5727: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
5728: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
5729: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
5730: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
5731: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
5732: p_new_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
5733: p_old_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
5726: PROCEDURE Enrp_Ins_Sua_Hist(
5727: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
5728: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
5729: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
5730: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
5731: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
5732: p_new_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
5733: p_old_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
5734: p_new_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
5727: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
5728: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
5729: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
5730: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
5731: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
5732: p_new_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
5733: p_old_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
5734: p_new_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
5735: p_old_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
5728: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
5729: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
5730: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
5731: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
5732: p_new_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
5733: p_old_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
5734: p_new_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
5735: p_old_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
5736: p_new_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
5729: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
5730: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
5731: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
5732: p_new_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
5733: p_old_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
5734: p_new_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
5735: p_old_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
5736: p_new_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
5737: p_old_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
5730: p_cal_type IN IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
5731: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
5732: p_new_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
5733: p_old_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
5734: p_new_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
5735: p_old_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
5736: p_new_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
5737: p_old_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
5738: p_new_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
5731: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
5732: p_new_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
5733: p_old_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
5734: p_new_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
5735: p_old_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
5736: p_new_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
5737: p_old_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
5738: p_new_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
5739: p_old_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
5732: p_new_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
5733: p_old_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
5734: p_new_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
5735: p_old_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
5736: p_new_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
5737: p_old_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
5738: p_new_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
5739: p_old_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
5740: p_new_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
5733: p_old_version_number IN IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
5734: p_new_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
5735: p_old_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
5736: p_new_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
5737: p_old_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
5738: p_new_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
5739: p_old_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
5740: p_new_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
5741: p_old_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
5734: p_new_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
5735: p_old_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
5736: p_new_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
5737: p_old_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
5738: p_new_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
5739: p_old_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
5740: p_new_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
5741: p_old_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
5742: p_new_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
5735: p_old_location_cd IN IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE ,
5736: p_new_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
5737: p_old_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
5738: p_new_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
5739: p_old_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
5740: p_new_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
5741: p_old_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
5742: p_new_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
5743: p_old_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
5736: p_new_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
5737: p_old_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
5738: p_new_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
5739: p_old_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
5740: p_new_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
5741: p_old_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
5742: p_new_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
5743: p_old_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
5744: p_new_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
5737: p_old_unit_class IN IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE ,
5738: p_new_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
5739: p_old_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
5740: p_new_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
5741: p_old_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
5742: p_new_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
5743: p_old_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
5744: p_new_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
5745: p_old_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
5738: p_new_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
5739: p_old_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
5740: p_new_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
5741: p_old_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
5742: p_new_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
5743: p_old_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
5744: p_new_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
5745: p_old_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
5746: p_new_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
5739: p_old_enrolled_dt IN IGS_EN_SU_ATTEMPT_ALL.enrolled_dt%TYPE ,
5740: p_new_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
5741: p_old_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
5742: p_new_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
5743: p_old_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
5744: p_new_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
5745: p_old_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
5746: p_new_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
5747: p_old_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
5740: p_new_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
5741: p_old_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
5742: p_new_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
5743: p_old_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
5744: p_new_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
5745: p_old_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
5746: p_new_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
5747: p_old_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
5748: p_new_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
5741: p_old_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE ,
5742: p_new_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
5743: p_old_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
5744: p_new_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
5745: p_old_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
5746: p_new_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
5747: p_old_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
5748: p_new_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
5749: p_old_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
5742: p_new_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
5743: p_old_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
5744: p_new_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
5745: p_old_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
5746: p_new_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
5747: p_old_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
5748: p_new_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
5749: p_old_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
5750: p_new_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
5743: p_old_admin_unit_status IN IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE ,
5744: p_new_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
5745: p_old_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
5746: p_new_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
5747: p_old_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
5748: p_new_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
5749: p_old_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
5750: p_new_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
5751: p_old_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
5744: p_new_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
5745: p_old_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
5746: p_new_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
5747: p_old_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
5748: p_new_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
5749: p_old_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
5750: p_new_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
5751: p_old_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
5752: p_new_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
5745: p_old_discontinued_dt IN IGS_EN_SU_ATTEMPT_ALL.discontinued_dt%TYPE ,
5746: p_new_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
5747: p_old_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
5748: p_new_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
5749: p_old_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
5750: p_new_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
5751: p_old_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
5752: p_new_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
5753: p_old_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
5746: p_new_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
5747: p_old_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
5748: p_new_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
5749: p_old_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
5750: p_new_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
5751: p_old_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
5752: p_new_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
5753: p_old_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
5754: p_new_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
5747: p_old_rule_waived_dt IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_dt%TYPE ,
5748: p_new_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
5749: p_old_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
5750: p_new_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
5751: p_old_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
5752: p_new_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
5753: p_old_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
5754: p_new_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
5755: p_old_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
5748: p_new_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
5749: p_old_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
5750: p_new_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
5751: p_old_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
5752: p_new_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
5753: p_old_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
5754: p_new_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
5755: p_old_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
5756: p_new_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
5749: p_old_rule_waived_person_id IN IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE ,
5750: p_new_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
5751: p_old_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
5752: p_new_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
5753: p_old_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
5754: p_new_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
5755: p_old_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
5756: p_new_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
5757: p_old_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
5750: p_new_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
5751: p_old_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
5752: p_new_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
5753: p_old_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
5754: p_new_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
5755: p_old_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
5756: p_new_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
5757: p_old_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
5758: p_new_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
5751: p_old_no_assessment_ind IN IGS_EN_SU_ATTEMPT_ALL.no_assessment_ind%TYPE ,
5752: p_new_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
5753: p_old_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
5754: p_new_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
5755: p_old_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
5756: p_new_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
5757: p_old_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
5758: p_new_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
5759: p_old_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
5752: p_new_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
5753: p_old_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
5754: p_new_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
5755: p_old_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
5756: p_new_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
5757: p_old_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
5758: p_new_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
5759: p_old_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
5760: p_new_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
5753: p_old_exam_location_cd IN IGS_EN_SU_ATTEMPT_ALL.exam_location_cd%TYPE ,
5754: p_new_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
5755: p_old_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
5756: p_new_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
5757: p_old_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
5758: p_new_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
5759: p_old_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
5760: p_new_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
5761: p_old_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
5754: p_new_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
5755: p_old_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
5756: p_new_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
5757: p_old_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
5758: p_new_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
5759: p_old_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
5760: p_new_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
5761: p_old_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
5762: p_new_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
5755: p_old_sup_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.sup_unit_cd%TYPE ,
5756: p_new_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
5757: p_old_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
5758: p_new_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
5759: p_old_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
5760: p_new_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
5761: p_old_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
5762: p_new_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
5763: p_old_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
5756: p_new_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
5757: p_old_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
5758: p_new_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
5759: p_old_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
5760: p_new_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
5761: p_old_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
5762: p_new_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
5763: p_old_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
5764: p_new_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
5757: p_old_sup_version_number IN IGS_EN_SU_ATTEMPT_ALL.sup_version_number%TYPE ,
5758: p_new_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
5759: p_old_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
5760: p_new_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
5761: p_old_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
5762: p_new_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
5763: p_old_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
5764: p_new_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
5765: p_old_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
5758: p_new_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
5759: p_old_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
5760: p_new_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
5761: p_old_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
5762: p_new_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
5763: p_old_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
5764: p_new_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
5765: p_old_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
5766: p_new_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
5759: p_old_alternative_title IN IGS_EN_SU_ATTEMPT_ALL.alternative_title%TYPE ,
5760: p_new_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
5761: p_old_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
5762: p_new_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
5763: p_old_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
5764: p_new_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
5765: p_old_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
5766: p_new_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
5767: p_old_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
5760: p_new_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
5761: p_old_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
5762: p_new_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
5763: p_old_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
5764: p_new_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
5765: p_old_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
5766: p_new_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
5767: p_old_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
5768: p_new_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
5761: p_old_override_enrolled_cp IN IGS_EN_SU_ATTEMPT_ALL.override_enrolled_cp%TYPE ,
5762: p_new_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
5763: p_old_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
5764: p_new_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
5765: p_old_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
5766: p_new_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
5767: p_old_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
5768: p_new_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
5769: p_old_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
5762: p_new_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
5763: p_old_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
5764: p_new_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
5765: p_old_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
5766: p_new_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
5767: p_old_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
5768: p_new_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
5769: p_old_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
5770: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
5763: p_old_override_eftsu IN IGS_EN_SU_ATTEMPT_ALL.override_eftsu%TYPE ,
5764: p_new_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
5765: p_old_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
5766: p_new_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
5767: p_old_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
5768: p_new_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
5769: p_old_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
5770: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
5771: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
5764: p_new_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
5765: p_old_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
5766: p_new_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
5767: p_old_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
5768: p_new_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
5769: p_old_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
5770: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
5771: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
5772: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
5765: p_old_override_achievable_cp IN IGS_EN_SU_ATTEMPT_ALL.override_achievable_cp%TYPE ,
5766: p_new_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
5767: p_old_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
5768: p_new_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
5769: p_old_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
5770: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
5771: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
5772: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
5773: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
5766: p_new_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
5767: p_old_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
5768: p_new_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
5769: p_old_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
5770: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
5771: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
5772: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
5773: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
5774: p_new_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
5767: p_old_override_outcome_due_dt IN IGS_EN_SU_ATTEMPT_ALL.override_outcome_due_dt%TYPE ,
5768: p_new_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
5769: p_old_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
5770: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
5771: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
5772: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
5773: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
5774: p_new_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
5775: p_old_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
5768: p_new_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
5769: p_old_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
5770: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
5771: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
5772: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
5773: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
5774: p_new_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
5775: p_old_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
5776: p_uoo_id IN IGS_EN_SU_ATTEMPT_ALL.uoo_id%TYPE,
5769: p_old_override_credit_reason IN IGS_EN_SU_ATTEMPT_ALL.override_credit_reason%TYPE ,
5770: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
5771: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
5772: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
5773: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
5774: p_new_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
5775: p_old_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
5776: p_uoo_id IN IGS_EN_SU_ATTEMPT_ALL.uoo_id%TYPE,
5777: p_new_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE, -- ptandon, Prevent Dropping Core Units build
5770: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
5771: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
5772: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
5773: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
5774: p_new_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
5775: p_old_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
5776: p_uoo_id IN IGS_EN_SU_ATTEMPT_ALL.uoo_id%TYPE,
5777: p_new_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE, -- ptandon, Prevent Dropping Core Units build
5778: p_old_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE -- ptandon, Prevent Dropping Core Units build
5771: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
5772: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
5773: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
5774: p_new_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
5775: p_old_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
5776: p_uoo_id IN IGS_EN_SU_ATTEMPT_ALL.uoo_id%TYPE,
5777: p_new_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE, -- ptandon, Prevent Dropping Core Units build
5778: p_old_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE -- ptandon, Prevent Dropping Core Units build
5779: )
5772: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
5773: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
5774: p_new_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
5775: p_old_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
5776: p_uoo_id IN IGS_EN_SU_ATTEMPT_ALL.uoo_id%TYPE,
5777: p_new_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE, -- ptandon, Prevent Dropping Core Units build
5778: p_old_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE -- ptandon, Prevent Dropping Core Units build
5779: )
5780: AS
5773: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_date%TYPE ,
5774: p_new_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
5775: p_old_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
5776: p_uoo_id IN IGS_EN_SU_ATTEMPT_ALL.uoo_id%TYPE,
5777: p_new_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE, -- ptandon, Prevent Dropping Core Units build
5778: p_old_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE -- ptandon, Prevent Dropping Core Units build
5779: )
5780: AS
5781: -------------------------------------------------------------------------------------------
5774: p_new_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
5775: p_old_dcnt_reason_Cd IN IGS_EN_SU_ATTEMPT_ALL.dcnt_reason_cd%TYPE,
5776: p_uoo_id IN IGS_EN_SU_ATTEMPT_ALL.uoo_id%TYPE,
5777: p_new_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE, -- ptandon, Prevent Dropping Core Units build
5778: p_old_core_indicator_code IN IGS_EN_SU_ATTEMPT_ALL.core_indicator_code%TYPE -- ptandon, Prevent Dropping Core Units build
5779: )
5780: AS
5781: -------------------------------------------------------------------------------------------
5782: --Change History:
5789: -------------------------------------------------------------------------------------------
5790: gv_other_detail VARCHAR2(255);
5791: BEGIN
5792: DECLARE
5793: r_suah IGS_EN_SU_ATTEMPT_H%ROWTYPE;
5794: v_create_history BOOLEAN := FALSE;
5795: v_aus_description IGS_AD_ADM_UNIT_STAT.description%TYPE;
5796: v_elo_description IGS_AD_LOCATION.description%TYPE;
5797:
5803: SELECT description
5804: FROM IGS_AD_LOCATION
5805: WHERE location_cd = r_suah.exam_location_cd;
5806: BEGIN
5807: -- Create a history for a IGS_EN_SU_ATTEMPT record.
5808: -- Check if any of the non-primary key fields have been changed
5809: -- and set the flag v_create_history to indicate so.
5810: IF p_new_version_number <> p_old_version_number THEN
5811: r_suah.version_number := p_old_version_number;
5945: l_rowid VARCHAR2(25);
5946: l_org_id NUMBER := igs_ge_gen_003.get_org_id;
5947: BEGIN
5948:
5949: IGS_EN_SU_ATTEMPT_H_PKG.INSERT_ROW (
5950: x_rowid => l_rowid,
5951: x_person_id =>r_suah.person_id ,
5952: x_course_cd => r_suah.course_cd,
5953: x_unit_cd => r_suah.unit_cd,
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:
6004: RETURN BOOLEAN AS
6201: */
6202: RETURN BOOLEAN AS
6203:
6204: BEGIN -- enrp_ins_sua_trnsfr
6205: -- Transfer a IGS_EN_SU_ATTEMPT record as part of a IGS_PS_COURSE transfer.
6206: DECLARE
6207: cst_completed CONSTANT VARCHAR2(10) := 'COMPLETED';
6208: cst_discontin CONSTANT VARCHAR2(10) := 'DISCONTIN';
6209: cst_duplicate CONSTANT VARCHAR2(10) := 'DUPLICATE';
6219: e_record_locked EXCEPTION;
6220: PRAGMA EXCEPTION_INIT(e_record_locked, -54);
6221: v_message_name VARCHAR2(2000);
6222: v_fail_type VARCHAR2(10) ;
6223: v_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
6224: v_record_exists BOOLEAN := FALSE;
6225: CURSOR c_sua IS
6226: SELECT sua.person_id,
6227: sua.course_cd,
6284: sua.waitlist_manual_ind,
6285: sua.wlst_priority_weight_num,
6286: sua.wlst_preference_weight_num,
6287: sua.core_indicator_code
6288: FROM IGS_EN_SU_ATTEMPT sua
6289: WHERE sua.person_id = p_person_id AND
6290: sua.course_cd = p_course_cd AND
6291: sua.uoo_id = p_uoo_id;
6292: v_sua_rec c_sua%ROWTYPE;
6293:
6294: CURSOR c_sua_delete IS
6295: SELECT sua.rowid rowid1,
6296: sua.unit_attempt_status unit_attempt_status
6297: FROM IGS_EN_SU_ATTEMPT sua
6298: WHERE sua.person_id = p_person_id AND
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;
6324: p_return_type := NULL;
6325: p_message_name := null;
6326: RETURN TRUE;
6327: END IF;
6328: -- Get the details of the IGS_EN_SU_ATTEMPT record which is to be
6329: -- transferred.
6330: OPEN c_sua;
6331: FETCH c_sua INTO v_sua_rec;
6332: IF (c_sua%NOTFOUND) THEN
6382: RETURN FALSE;
6383: END IF;
6384: END IF;
6385:
6386: -- Perform validations on the IGS_EN_SU_ATTEMPT record to be created.
6387: IF v_status = cst_enrolled THEN -- perform confirmation validations
6388: IF enrp_val_sua_cnfrm_before_pt(p_person_id,
6389: p_transfer_course_cd,
6390: p_unit_cd,
6411:
6412: -- removed cst_dropped and added ELSIF by ckasu as a part of bug #4080883 inorder to allow update of
6413: -- unit attempt rather than deleting of unit attempt when unit attempt status is 'DROPPED'
6414: IF v_uas.unit_attempt_status IN (cst_unconfirm) THEN
6415: IGS_EN_SU_ATTEMPT_PKG.DELETE_ROW( v_uas.rowid1 );
6416: ELSIF v_uas.unit_attempt_status <> cst_dropped THEN
6417: v_record_exists := TRUE;
6418: EXIT;
6419: END IF;
6484: END IF;
6485:
6486:
6487:
6488: IGS_EN_SU_ATTEMPT_PKG.INSERT_ROW (
6489: X_ROWID => l_rowid,
6490: X_PERSON_ID => p_person_id,
6491: X_COURSE_CD => p_transfer_course_cd,
6492: X_UNIT_CD => p_unit_cd,
6654: p_new_catalog_cal_type IN VARCHAR2 ,
6655: p_old_catalog_cal_type IN VARCHAR2 ,
6656: p_new_catalog_seq_num IN NUMBER ,
6657: p_old_catalog_seq_num IN NUMBER ,
6658: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
6659: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
6660: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_DATE%TYPE,
6661: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_DATE%TYPE )
6662: AS
6655: p_old_catalog_cal_type IN VARCHAR2 ,
6656: p_new_catalog_seq_num IN NUMBER ,
6657: p_old_catalog_seq_num IN NUMBER ,
6658: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
6659: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
6660: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_DATE%TYPE,
6661: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_DATE%TYPE )
6662: AS
6663: gv_other_detail VARCHAR2(255);
6656: p_new_catalog_seq_num IN NUMBER ,
6657: p_old_catalog_seq_num IN NUMBER ,
6658: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
6659: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
6660: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_DATE%TYPE,
6661: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_DATE%TYPE )
6662: AS
6663: gv_other_detail VARCHAR2(255);
6664: BEGIN -- enrp_ins_susa_hist
6657: p_old_catalog_seq_num IN NUMBER ,
6658: p_new_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
6659: p_old_update_who IN IGS_EN_SU_ATTEMPT_ALL.last_updated_by%TYPE ,
6660: p_new_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_DATE%TYPE,
6661: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_DATE%TYPE )
6662: AS
6663: gv_other_detail VARCHAR2(255);
6664: BEGIN -- enrp_ins_susa_hist
6665: -- Create a history for an IGS_AD_APPL record
6924: p_message_name := 'IGS_EN_SUA_SET_ATT_TRNS_EXIST';
6925: RETURN FALSE;
6926: END IF;
6927: CLOSE c_susa1;
6928: -- Transfer the IGS_EN_SU_ATTEMPT.
6929: DECLARE
6930: l_rowid VARCHAR2(25) := NULL;
6931: BEGIN
6932: IGS_AS_SU_SETATMPT_PKG.INSERT_ROW (
8597:
8598: END update_stream_unit_sets;
8599:
8600: FUNCTION enrp_vald_inst_sua(
8601: p_person_id IN igs_en_su_attempt.person_id%TYPE,
8602: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
8603: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
8604: p_version_number IN igs_en_su_attempt.version_number%TYPE,
8605: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
8598: END update_stream_unit_sets;
8599:
8600: FUNCTION enrp_vald_inst_sua(
8601: p_person_id IN igs_en_su_attempt.person_id%TYPE,
8602: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
8603: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
8604: p_version_number IN igs_en_su_attempt.version_number%TYPE,
8605: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
8606: p_teach_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,
8599:
8600: FUNCTION enrp_vald_inst_sua(
8601: p_person_id IN igs_en_su_attempt.person_id%TYPE,
8602: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
8603: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
8604: p_version_number IN igs_en_su_attempt.version_number%TYPE,
8605: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
8606: p_teach_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,
8607: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
8600: FUNCTION enrp_vald_inst_sua(
8601: p_person_id IN igs_en_su_attempt.person_id%TYPE,
8602: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
8603: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
8604: p_version_number IN igs_en_su_attempt.version_number%TYPE,
8605: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
8606: p_teach_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,
8607: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
8608: p_load_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,
8601: p_person_id IN igs_en_su_attempt.person_id%TYPE,
8602: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
8603: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
8604: p_version_number IN igs_en_su_attempt.version_number%TYPE,
8605: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
8606: p_teach_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,
8607: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
8608: p_load_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,
8609: p_location_cd IN igs_en_su_attempt.location_cd%TYPE,
8602: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
8603: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
8604: p_version_number IN igs_en_su_attempt.version_number%TYPE,
8605: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
8606: p_teach_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,
8607: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
8608: p_load_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,
8609: p_location_cd IN igs_en_su_attempt.location_cd%TYPE,
8610: p_unit_class IN igs_en_su_attempt.unit_class%TYPE,
8603: p_unit_cd IN igs_en_su_attempt.unit_cd%TYPE,
8604: p_version_number IN igs_en_su_attempt.version_number%TYPE,
8605: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
8606: p_teach_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,
8607: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
8608: p_load_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,
8609: p_location_cd IN igs_en_su_attempt.location_cd%TYPE,
8610: p_unit_class IN igs_en_su_attempt.unit_class%TYPE,
8611: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
8604: p_version_number IN igs_en_su_attempt.version_number%TYPE,
8605: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
8606: p_teach_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,
8607: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
8608: p_load_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,
8609: p_location_cd IN igs_en_su_attempt.location_cd%TYPE,
8610: p_unit_class IN igs_en_su_attempt.unit_class%TYPE,
8611: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
8612: p_enr_method IN igs_en_method_type.enr_method_type%TYPE,
8605: p_teach_cal_type IN igs_en_su_attempt.cal_type%TYPE,
8606: p_teach_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,
8607: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
8608: p_load_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,
8609: p_location_cd IN igs_en_su_attempt.location_cd%TYPE,
8610: p_unit_class IN igs_en_su_attempt.unit_class%TYPE,
8611: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
8612: p_enr_method IN igs_en_method_type.enr_method_type%TYPE,
8613: p_core_indicator_code IN igs_en_su_attempt.core_indicator_code%TYPE, -- ptandon, Prevent Dropping Core Units build
8606: p_teach_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,
8607: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
8608: p_load_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,
8609: p_location_cd IN igs_en_su_attempt.location_cd%TYPE,
8610: p_unit_class IN igs_en_su_attempt.unit_class%TYPE,
8611: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
8612: p_enr_method IN igs_en_method_type.enr_method_type%TYPE,
8613: p_core_indicator_code IN igs_en_su_attempt.core_indicator_code%TYPE, -- ptandon, Prevent Dropping Core Units build
8614: p_message OUT NOCOPY VARCHAR2) RETURN BOOLEAN AS
8607: p_load_cal_type IN igs_en_su_attempt.cal_type%TYPE,
8608: p_load_seq_num IN igs_en_su_attempt.ci_sequence_number%TYPE,
8609: p_location_cd IN igs_en_su_attempt.location_cd%TYPE,
8610: p_unit_class IN igs_en_su_attempt.unit_class%TYPE,
8611: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
8612: p_enr_method IN igs_en_method_type.enr_method_type%TYPE,
8613: p_core_indicator_code IN igs_en_su_attempt.core_indicator_code%TYPE, -- ptandon, Prevent Dropping Core Units build
8614: p_message OUT NOCOPY VARCHAR2) RETURN BOOLEAN AS
8615: ------------------------------------------------------------------------------------------------
8609: p_location_cd IN igs_en_su_attempt.location_cd%TYPE,
8610: p_unit_class IN igs_en_su_attempt.unit_class%TYPE,
8611: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
8612: p_enr_method IN igs_en_method_type.enr_method_type%TYPE,
8613: p_core_indicator_code IN igs_en_su_attempt.core_indicator_code%TYPE, -- ptandon, Prevent Dropping Core Units build
8614: p_message OUT NOCOPY VARCHAR2) RETURN BOOLEAN AS
8615: ------------------------------------------------------------------------------------------------
8616: --Created by :
8617: --Date created:
8652: AND pv.course_cd = sca.course_cd
8653: AND pv.version_number = sca.version_number;
8654:
8655: l_waitlist_ind VARCHAR2(2);
8656: l_unit_section_status igs_en_su_attempt.unit_attempt_status%TYPE;
8657: l_uoo_id igs_en_su_attempt.uoo_id%TYPE;
8658: l_person_number igs_pe_person.person_number%TYPE;
8659: l_ret_stat VARCHAR2(1);
8660: l_unit_attempt_status igs_en_su_attempt.unit_attempt_status%TYPE;
8653: AND pv.version_number = sca.version_number;
8654:
8655: l_waitlist_ind VARCHAR2(2);
8656: l_unit_section_status igs_en_su_attempt.unit_attempt_status%TYPE;
8657: l_uoo_id igs_en_su_attempt.uoo_id%TYPE;
8658: l_person_number igs_pe_person.person_number%TYPE;
8659: l_ret_stat VARCHAR2(1);
8660: l_unit_attempt_status igs_en_su_attempt.unit_attempt_status%TYPE;
8661: l_sub_sup_status igs_en_su_attempt.unit_attempt_status%TYPE;
8656: l_unit_section_status igs_en_su_attempt.unit_attempt_status%TYPE;
8657: l_uoo_id igs_en_su_attempt.uoo_id%TYPE;
8658: l_person_number igs_pe_person.person_number%TYPE;
8659: l_ret_stat VARCHAR2(1);
8660: l_unit_attempt_status igs_en_su_attempt.unit_attempt_status%TYPE;
8661: l_sub_sup_status igs_en_su_attempt.unit_attempt_status%TYPE;
8662: l_primary_program_cd IGS_PS_VER_ALL.COURSE_CD%TYPE;
8663: l_primary_program_vers IGS_PS_VER_ALL.VERSION_NUMBER%TYPE;
8664: l_all_program_title VARCHAR2(2000);
8657: l_uoo_id igs_en_su_attempt.uoo_id%TYPE;
8658: l_person_number igs_pe_person.person_number%TYPE;
8659: l_ret_stat VARCHAR2(1);
8660: l_unit_attempt_status igs_en_su_attempt.unit_attempt_status%TYPE;
8661: l_sub_sup_status igs_en_su_attempt.unit_attempt_status%TYPE;
8662: l_primary_program_cd IGS_PS_VER_ALL.COURSE_CD%TYPE;
8663: l_primary_program_vers IGS_PS_VER_ALL.VERSION_NUMBER%TYPE;
8664: l_all_program_title VARCHAR2(2000);
8665: l_profile VARCHAR2(1);
8864: cst_completed CONSTANT VARCHAR2(10) := 'COMPLETED';
8865: cst_discontin CONSTANT VARCHAR2(10) := 'DISCONTIN';
8866: cst_duplicate CONSTANT VARCHAR2(10) := 'DUPLICATE';
8867:
8868: CURSOR c_teach_to_load(cp_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE,
8869: cp_source_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
8870: cp_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS
8871: SELECT load_cal_type, load_ci_sequence_number, load_start_dt, teach_cal_type, teach_ci_sequence_number
8872: FROM IGS_EN_SU_ATTEMPT sua,
8865: cst_discontin CONSTANT VARCHAR2(10) := 'DISCONTIN';
8866: cst_duplicate CONSTANT VARCHAR2(10) := 'DUPLICATE';
8867:
8868: CURSOR c_teach_to_load(cp_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE,
8869: cp_source_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
8870: cp_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS
8871: SELECT load_cal_type, load_ci_sequence_number, load_start_dt, teach_cal_type, teach_ci_sequence_number
8872: FROM IGS_EN_SU_ATTEMPT sua,
8873: IGS_CA_TEACH_TO_LOAD_V tl
8866: cst_duplicate CONSTANT VARCHAR2(10) := 'DUPLICATE';
8867:
8868: CURSOR c_teach_to_load(cp_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE,
8869: cp_source_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
8870: cp_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS
8871: SELECT load_cal_type, load_ci_sequence_number, load_start_dt, teach_cal_type, teach_ci_sequence_number
8872: FROM IGS_EN_SU_ATTEMPT sua,
8873: IGS_CA_TEACH_TO_LOAD_V tl
8874: WHERE sua.person_id = cp_person_id
8868: CURSOR c_teach_to_load(cp_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE,
8869: cp_source_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
8870: cp_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS
8871: SELECT load_cal_type, load_ci_sequence_number, load_start_dt, teach_cal_type, teach_ci_sequence_number
8872: FROM IGS_EN_SU_ATTEMPT sua,
8873: IGS_CA_TEACH_TO_LOAD_V tl
8874: WHERE sua.person_id = cp_person_id
8875: AND sua.course_cd = cp_source_course_cd
8876: AND sua.uoo_id = cp_uoo_id
8879: order by tl.load_start_dt asc;
8880:
8881: v_teach_to_load_rec c_teach_to_load%ROWTYPE;
8882:
8883: CURSOR c_suao (cp_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE,
8884: cp_source_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
8885: cp_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE,
8886: cp_finalised_outcome_ind IGS_AS_SU_STMPTOUT.FINALISED_OUTCOME_IND%TYPE ) IS
8887: SELECT outcome_dt
8880:
8881: v_teach_to_load_rec c_teach_to_load%ROWTYPE;
8882:
8883: CURSOR c_suao (cp_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE,
8884: cp_source_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
8885: cp_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE,
8886: cp_finalised_outcome_ind IGS_AS_SU_STMPTOUT.FINALISED_OUTCOME_IND%TYPE ) IS
8887: SELECT outcome_dt
8888: FROM igs_as_su_stmptout source_suao
8881: v_teach_to_load_rec c_teach_to_load%ROWTYPE;
8882:
8883: CURSOR c_suao (cp_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE,
8884: cp_source_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
8885: cp_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE,
8886: cp_finalised_outcome_ind IGS_AS_SU_STMPTOUT.FINALISED_OUTCOME_IND%TYPE ) IS
8887: SELECT outcome_dt
8888: FROM igs_as_su_stmptout source_suao
8889: WHERE person_id = cp_person_id
8893: ORDER BY outcome_dt desc;
8894:
8895: v_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE;
8896:
8897: CURSOR c_load(cp_date IGS_EN_SU_ATTEMPT.DISCONTINUED_DT%TYPE,
8898: cp_load_start_dt IGS_CA_INST.START_DT%TYPE,
8899: cp_teach_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
8900: cp_teach_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
8901: SELECT load_cal_type, load_ci_sequence_number, load_start_dt
8984: p_source_uoo_id IN NUMBER,
8985: p_dest_uoo_id IN NUMBER,
8986: p_delete_source IN BOOLEAN) AS
8987:
8988: CURSOR c_suao (cp_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE,
8989: cp_source_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
8990: cp_dest_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
8991: cp_source_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE,
8992: cp_dest_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS
8985: p_dest_uoo_id IN NUMBER,
8986: p_delete_source IN BOOLEAN) AS
8987:
8988: CURSOR c_suao (cp_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE,
8989: cp_source_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
8990: cp_dest_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
8991: cp_source_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE,
8992: cp_dest_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS
8993: SELECT source_suao.rowid,source_suao.*
8986: p_delete_source IN BOOLEAN) AS
8987:
8988: CURSOR c_suao (cp_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE,
8989: cp_source_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
8990: cp_dest_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
8991: cp_source_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE,
8992: cp_dest_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS
8993: SELECT source_suao.rowid,source_suao.*
8994: FROM igs_as_su_stmptout source_suao
8987:
8988: CURSOR c_suao (cp_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE,
8989: cp_source_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
8990: cp_dest_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
8991: cp_source_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE,
8992: cp_dest_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS
8993: SELECT source_suao.rowid,source_suao.*
8994: FROM igs_as_su_stmptout source_suao
8995: WHERE person_id = cp_person_id
8988: CURSOR c_suao (cp_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE,
8989: cp_source_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
8990: cp_dest_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
8991: cp_source_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE,
8992: cp_dest_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS
8993: SELECT source_suao.rowid,source_suao.*
8994: FROM igs_as_su_stmptout source_suao
8995: WHERE person_id = cp_person_id
8996: AND course_cd = cp_source_course_cd
9003: AND dest_suao.grading_period_cd = source_suao.grading_period_cd
9004: AND dest_suao.uoo_id = cp_dest_uoo_id)
9005: order by outcome_dt asc;
9006:
9007: CURSOR c_usec (cp_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS
9008: SELECT usec.UNIT_CD,
9009: usec.CAL_TYPE,
9010: usec.CI_SEQUENCE_NUMBER,
9011: CI.START_DT,
9308: cst_enrolled CONSTANT VARCHAR2(10) := 'ENROLLED';
9309: cst_waitlist CONSTANT VARCHAR2(10) := 'WAITLISTED';
9310: cst_invalid CONSTANT VARCHAR2(10) := 'INVALID';
9311:
9312: CURSOR c_sua_source (cp_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE,
9313: cp_source_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
9314: cp_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS
9315: SELECT *
9316: FROM IGS_EN_SU_ATTEMPT
9309: cst_waitlist CONSTANT VARCHAR2(10) := 'WAITLISTED';
9310: cst_invalid CONSTANT VARCHAR2(10) := 'INVALID';
9311:
9312: CURSOR c_sua_source (cp_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE,
9313: cp_source_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
9314: cp_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS
9315: SELECT *
9316: FROM IGS_EN_SU_ATTEMPT
9317: WHERE person_id = cp_person_id
9310: cst_invalid CONSTANT VARCHAR2(10) := 'INVALID';
9311:
9312: CURSOR c_sua_source (cp_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE,
9313: cp_source_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
9314: cp_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS
9315: SELECT *
9316: FROM IGS_EN_SU_ATTEMPT
9317: WHERE person_id = cp_person_id
9318: and course_cd = cp_source_course_cd
9312: CURSOR c_sua_source (cp_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE,
9313: cp_source_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
9314: cp_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS
9315: SELECT *
9316: FROM IGS_EN_SU_ATTEMPT
9317: WHERE person_id = cp_person_id
9318: and course_cd = cp_source_course_cd
9319: and uoo_id = cp_uoo_id;
9320:
9319: and uoo_id = cp_uoo_id;
9320:
9321: v_sua_source_rec c_sua_source%ROWTYPE;
9322:
9323: CURSOR c_sub_sua_exists( cp_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE,
9324: cp_source_program_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
9325: cp_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS
9326: SELECT 'X'
9327: FROM IGS_PS_UNIT_OFR_OPT uoo
9320:
9321: v_sua_source_rec c_sua_source%ROWTYPE;
9322:
9323: CURSOR c_sub_sua_exists( cp_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE,
9324: cp_source_program_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
9325: cp_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS
9326: SELECT 'X'
9327: FROM IGS_PS_UNIT_OFR_OPT uoo
9328: WHERE uoo.relation_type = 'SUBORDINATE'
9321: v_sua_source_rec c_sua_source%ROWTYPE;
9322:
9323: CURSOR c_sub_sua_exists( cp_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE,
9324: cp_source_program_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
9325: cp_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS
9326: SELECT 'X'
9327: FROM IGS_PS_UNIT_OFR_OPT uoo
9328: WHERE uoo.relation_type = 'SUBORDINATE'
9329: AND uoo.sup_uoo_id = cp_uoo_id
9327: FROM IGS_PS_UNIT_OFR_OPT uoo
9328: WHERE uoo.relation_type = 'SUBORDINATE'
9329: AND uoo.sup_uoo_id = cp_uoo_id
9330: AND exists (SELECT 'X'
9331: FROM IGS_EN_SU_ATTEMPT sub_sua
9332: WHERE sub_sua.person_id = cp_person_id
9333: AND sub_sua.course_cd = cp_source_program_cd
9334: AND sub_sua.uoo_id = uoo.uoo_id
9335: AND sub_sua.unit_attempt_status <> cst_dropped);
9336:
9337: -- get all the unit attempts selected and unselected by the user and order them so
9338: -- that subordinate is dropped first
9339: CURSOR c_get_all_units_in_src IS
9340: SELECT uoo_id FROM IGS_EN_SU_ATTEMPT
9341: WHERE person_id = p_person_id AND
9342: course_cd = p_source_course_cd AND
9343: unit_attempt_status NOT IN (cst_dropped,cst_duplicate)
9344: ORDER BY SUP_UNIT_CD ;
9553: END IF;
9554:
9555:
9556:
9557: IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW( -- calling the TBH since the count need not be updated
9558: X_ROWID => v_sua_source_rec.ROW_ID,
9559: X_PERSON_ID => v_sua_source_rec.PERSON_ID,
9560: X_COURSE_CD => v_sua_source_rec.COURSE_CD ,
9561: X_UNIT_CD => v_sua_source_rec.UNIT_CD,
9738: CURSOR cur_supuoo_id IS select sup_uoo_id
9739: from IGS_PS_UNIT_OFR_OPT where uoo_id=p_uoo_id;
9740:
9741: CURSOR cur_sua (
9742: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
9743: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
9744: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
9745: IS
9746: Select 1 from IGS_EN_SU_ATTEMPT
9739: from IGS_PS_UNIT_OFR_OPT where uoo_id=p_uoo_id;
9740:
9741: CURSOR cur_sua (
9742: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
9743: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
9744: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
9745: IS
9746: Select 1 from IGS_EN_SU_ATTEMPT
9747: Where person_id=cp_person_id AND
9740:
9741: CURSOR cur_sua (
9742: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
9743: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
9744: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
9745: IS
9746: Select 1 from IGS_EN_SU_ATTEMPT
9747: Where person_id=cp_person_id AND
9748: course_cd=cp_course_cd AND
9742: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
9743: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
9744: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE)
9745: IS
9746: Select 1 from IGS_EN_SU_ATTEMPT
9747: Where person_id=cp_person_id AND
9748: course_cd=cp_course_cd AND
9749: uoo_id=cp_uoo_id AND
9750: unit_attempt_status <> 'DROPPED';
9748: course_cd=cp_course_cd AND
9749: uoo_id=cp_uoo_id AND
9750: unit_attempt_status <> 'DROPPED';
9751:
9752: CURSOR c_sup_unit_cd (cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
9753: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
9754: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
9755: SELECT sup_unit_Cd
9756: FROM IGS_EN_SU_ATTEMPT
9749: uoo_id=cp_uoo_id AND
9750: unit_attempt_status <> 'DROPPED';
9751:
9752: CURSOR c_sup_unit_cd (cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
9753: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
9754: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
9755: SELECT sup_unit_Cd
9756: FROM IGS_EN_SU_ATTEMPT
9757: WHERE person_id = cp_person_id
9750: unit_attempt_status <> 'DROPPED';
9751:
9752: CURSOR c_sup_unit_cd (cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
9753: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
9754: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
9755: SELECT sup_unit_Cd
9756: FROM IGS_EN_SU_ATTEMPT
9757: WHERE person_id = cp_person_id
9758: AND course_cd = cp_course_cd
9752: CURSOR c_sup_unit_cd (cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
9753: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
9754: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
9755: SELECT sup_unit_Cd
9756: FROM IGS_EN_SU_ATTEMPT
9757: WHERE person_id = cp_person_id
9758: AND course_cd = cp_course_cd
9759: AND uoo_id = cp_uoo_id;
9760:
9758: AND course_cd = cp_course_cd
9759: AND uoo_id = cp_uoo_id;
9760:
9761: l_sup_uoo_id IGS_PS_UNIT_OFR_OPT.sup_uoo_id%TYPE;
9762: l_sup_unit_Cd IGS_EN_SU_ATTEMPT.SUP_UNIT_CD%TYPE;
9763: l_cur_sua_rec cur_sua%ROWTYPE;
9764: l_result BOOLEAN;
9765: l_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE;
9766: l_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
9761: l_sup_uoo_id IGS_PS_UNIT_OFR_OPT.sup_uoo_id%TYPE;
9762: l_sup_unit_Cd IGS_EN_SU_ATTEMPT.SUP_UNIT_CD%TYPE;
9763: l_cur_sua_rec cur_sua%ROWTYPE;
9764: l_result BOOLEAN;
9765: l_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE;
9766: l_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
9767: BEGIN
9768:
9769: OPEN c_sup_unit_cd(p_person_id, p_course_cd, p_uoo_id);
9762: l_sup_unit_Cd IGS_EN_SU_ATTEMPT.SUP_UNIT_CD%TYPE;
9763: l_cur_sua_rec cur_sua%ROWTYPE;
9764: l_result BOOLEAN;
9765: l_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE;
9766: l_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
9767: BEGIN
9768:
9769: OPEN c_sup_unit_cd(p_person_id, p_course_cd, p_uoo_id);
9770: FETCH c_sup_unit_cd INTO l_sup_unit_Cd;
10162: AND ci_sequence_number = p_ci_sequence_number
10163: AND location_cd = p_location_cd
10164: AND unit_class = p_unit_class;
10165:
10166: l_uoo_id igs_en_su_attempt.uoo_id%TYPE;
10167: v_sca_rec c_sca%ROWTYPE;
10168: v_return_val BOOLEAN := FALSE;
10169: v_message_name varchar2(30);
10170: v_duplicate_course_cd VARCHAR2(6);