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

Line 51: -- igs_en_su_attempt table to igs_en_sua_api.update_unit_attempt

47: -- Changes as per bug# 2715516.
48: -- svenkata 22-Dec-02 Bug # 2686793 - Added a call to routine igs_en_elgbl_program.eval_unit_forced_type to enforce
49: -- to enforce Attendance Type validations on transferring.Modifications made in enrp_prc_sua_blk_trn.
50: -- pradhakr 15-Dec-2002 Changed the call to the update_row and update_row of
51: -- igs_en_su_attempt table to igs_en_sua_api.update_unit_attempt
52: -- and igs_en_sua_api.create_unit_attempt. Changes wrt ENCR031 build.
53: -- Bug#2643207
54: --samaresh 02-DEC-2001 Bug # 2097333 : Impact of addition of the waitlist_status field to igs_ad_ps_appl_inst_all
55: -- To the function Enrp_Upd_Acai_Accept

Line 59: --smaddali 1-08-2001 Modified calls to igs_en_su_attempt and

55: -- To the function Enrp_Upd_Acai_Accept
56: --pradhakr 12/07/2001 Added one parameter p_dcnt_reason_cd in
57: -- the procedure Enrp_prc_sua_enr_ds as part
58: -- of Enrollment build (Bug # 1832130 )
59: --smaddali 1-08-2001 Modified calls to igs_en_su_attempt and
60: -- igs_en_stdnt_ps_att and enrp_get_var_window
61: -- and enrp_get_rec_window , added new columns(Bug # 1832130 )
62: --Bayadav 5-sep-2001 Added refernces to column ORG_UNIT_CD incall to
63: -- IGS_EN_SU_ATTEMPT TBH call as a part of bug 1964697

Line 63: -- IGS_EN_SU_ATTEMPT TBH call as a part of bug 1964697

59: --smaddali 1-08-2001 Modified calls to igs_en_su_attempt and
60: -- igs_en_stdnt_ps_att and enrp_get_var_window
61: -- and enrp_get_rec_window , added new columns(Bug # 1832130 )
62: --Bayadav 5-sep-2001 Added refernces to column ORG_UNIT_CD incall to
63: -- IGS_EN_SU_ATTEMPT TBH call as a part of bug 1964697
64: --nalkumar 5-OCT-2001 Modified the IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW call.
65: -- Added four new parameters to call it as per the Bug# 2027984.
66: --Aiyer 10-Oct-2001 Added the column grading schema in all Tbh calls of IGS_EN_SU_ATTEMPT_PKG as a part of the bug 2037897.
67: --nalkumar 21-NOV-2001 Modified the IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW call.

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

62: --Bayadav 5-sep-2001 Added refernces to column ORG_UNIT_CD incall to
63: -- IGS_EN_SU_ATTEMPT TBH call as a part of bug 1964697
64: --nalkumar 5-OCT-2001 Modified the IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW call.
65: -- Added four new parameters to call it as per the Bug# 2027984.
66: --Aiyer 10-Oct-2001 Added the column grading schema in all Tbh calls of IGS_EN_SU_ATTEMPT_PKG as a part of the bug 2037897.
67: --nalkumar 21-NOV-2001 Modified the IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW call.
68: -- Added key program parameter to call it as per the Bug# 2027984.
69: --pradhakr 07-Dec-2001 Added the column deg_aud_detail_id in the
70: -- TBH calls as part of Degree Audit Interface build.

Line 76: --Nishikant 30-jan-2002 Added the column session_id in the Tbh calls of IGS_EN_SU_ATTEMPT_PKG

72: --svenkata 20-Dec-2001 Added the columns Student_career_transcrit , Student_career_statistics as part of Career Impact
73: -- Part 2 build . Bug #2158626
74: -- svenkata 7-JAN-2002 Bug No. 2172405 Standard Flex Field columns have been added
75: -- to table handler procedure calls as part of CCR - ENCR022.
76: --Nishikant 30-jan-2002 Added the column session_id in the Tbh calls of IGS_EN_SU_ATTEMPT_PKG
77: -- as a part of the bug 2172380.
78: --cdcruz 18-feb-2002 Bug 2217104 Admit to future term Enhancement,updated tbh call for
79: -- new columns being added to IGS_AD_PS_APPL_INST
80: --cdcruz 21-feb-2002 Bug 2231567 Message cleanup activity

Line 82: --mesriniv 18-sep-2002 Added a new parameter waitlist_manual_ind in TBH calls of IGS_EN_SU_ATTEMPT

78: --cdcruz 18-feb-2002 Bug 2217104 Admit to future term Enhancement,updated tbh call for
79: -- new columns being added to IGS_AD_PS_APPL_INST
80: --cdcruz 21-feb-2002 Bug 2231567 Message cleanup activity
81: --nshee 29-Aug-2002 Bug 2395510 added 6 columns in IGS_AD_PS_APPL_INST as part of deferments build
82: --mesriniv 18-sep-2002 Added a new parameter waitlist_manual_ind in TBH calls of IGS_EN_SU_ATTEMPT
83: -- for Bug 2554109 MINI Waitlist Build for Jan 03 Release
84: --pkpatel 3-OCT-2002 Bug No: 2600842
85: -- Added the parameter x_auth_resp_id in the call to IGS_PE_PERS_ENCUMB_PKG.UPDATE_ROW in the procedure Enrp_Set_Pen_Expry
86: -- Added the expiry date synchronization logic for table IGS_PE_FUND_EXCL in the procedure Enrp_Set_Pee_Expry

Line 108: TYPE r_sua_typ IS RECORD( unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,

104: -- igs_ss_en_wrappers.insert_into_enr_worksheet as part of Bug 5070742.
105: --ckasu 02-May-2006 Modified as a part of bug#5191592
106: --------------------------------------------------------------------------
107:
108: TYPE r_sua_typ IS RECORD( unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
109: uv_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE,
110: location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
111: unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE);
112: r_sua r_sua_typ;

Line 109: uv_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE,

105: --ckasu 02-May-2006 Modified as a part of bug#5191592
106: --------------------------------------------------------------------------
107:
108: TYPE r_sua_typ IS RECORD( unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
109: uv_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE,
110: location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
111: unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE);
112: r_sua r_sua_typ;
113: TYPE t_sua_typ IS TABLE OF r_sua%TYPE INDEX BY BINARY_INTEGER;

Line 110: location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,

106: --------------------------------------------------------------------------
107:
108: TYPE r_sua_typ IS RECORD( unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
109: uv_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE,
110: location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
111: unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE);
112: r_sua r_sua_typ;
113: TYPE t_sua_typ IS TABLE OF r_sua%TYPE INDEX BY BINARY_INTEGER;
114:

Line 111: unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE);

107:
108: TYPE r_sua_typ IS RECORD( unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
109: uv_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE,
110: location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
111: unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE);
112: r_sua r_sua_typ;
113: TYPE t_sua_typ IS TABLE OF r_sua%TYPE INDEX BY BINARY_INTEGER;
114:
115: TYPE suar_record_type IS RECORD (

Line 1296: l_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;

1292: l_action_processed BOOLEAN;
1293: l_attendance_type_reach BOOLEAN := TRUE;
1294: l_att_type VARCHAR2(40);
1295: l_attendance_types VARCHAR2(100); -- As returned from the function igs_en_val_sca.enrp_val_coo_att
1296: l_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
1297: l_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;
1298: l_person_type IGS_PE_PERSON_TYPES.person_type_code%TYPE;
1299: l_en_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1300: l_en_ci_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE;

Line 1314: l_eftsu_total IGS_EN_SU_ATTEMPT.override_eftsu%type;

1310: l_unit_key IGS_GE_S_LOG_ENTRY.key%TYPE;
1311: l_text IGS_GE_S_LOG_ENTRY.text%TYPE;
1312: l_enroll IGS_LOOKUP_VALUES.meaning%TYPE;
1313: l_discon IGS_LOOKUP_VALUES.meaning%TYPE;
1314: l_eftsu_total IGS_EN_SU_ATTEMPT.override_eftsu%type;
1315: l_total_credit_points IGS_EN_SU_ATTEMPT.override_enrolled_cp%TYPE ;
1316: l_administrative_unit_status IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE;
1317: l_person_number IGS_PE_PERSON.person_number%TYPE;
1318: l_dummy VARCHAR2(100);

Line 1315: l_total_credit_points IGS_EN_SU_ATTEMPT.override_enrolled_cp%TYPE ;

1311: l_text IGS_GE_S_LOG_ENTRY.text%TYPE;
1312: l_enroll IGS_LOOKUP_VALUES.meaning%TYPE;
1313: l_discon IGS_LOOKUP_VALUES.meaning%TYPE;
1314: l_eftsu_total IGS_EN_SU_ATTEMPT.override_eftsu%type;
1315: l_total_credit_points IGS_EN_SU_ATTEMPT.override_enrolled_cp%TYPE ;
1316: l_administrative_unit_status IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE;
1317: l_person_number IGS_PE_PERSON.person_number%TYPE;
1318: l_dummy VARCHAR2(100);
1319: l_creation_dt DATE;

Line 1316: l_administrative_unit_status IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE;

1312: l_enroll IGS_LOOKUP_VALUES.meaning%TYPE;
1313: l_discon IGS_LOOKUP_VALUES.meaning%TYPE;
1314: l_eftsu_total IGS_EN_SU_ATTEMPT.override_eftsu%type;
1315: l_total_credit_points IGS_EN_SU_ATTEMPT.override_enrolled_cp%TYPE ;
1316: l_administrative_unit_status IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE;
1317: l_person_number IGS_PE_PERSON.person_number%TYPE;
1318: l_dummy VARCHAR2(100);
1319: l_creation_dt DATE;
1320: l_encoded_msg VARCHAR2(2000);

Line 1324: l_core_indicator_code IGS_EN_SU_ATTEMPT.core_indicator_code%TYPE;

1320: l_encoded_msg VARCHAR2(2000);
1321: l_app_sht_name VARCHAR2(100);
1322: l_msg_name VARCHAR2(2000);
1323: l_temp_msg VARCHAR2(2000);
1324: l_core_indicator_code IGS_EN_SU_ATTEMPT.core_indicator_code%TYPE;
1325: l_relation_type VARCHAR2(100);
1326: l_enr_uoo_ids VARCHAR2(2000);
1327: l_sub_success VARCHAR2(2000);
1328: l_sub_waitlist VARCHAR2(2000);

Line 1377: FROM IGS_EN_SU_ATTEMPT sua

1373: AND sca.course_attempt_status IN (cst_inactive,cst_enrolled,cst_intermit,cst_complete)
1374: AND (p_unit_cd IS NULL OR
1375: EXISTS (
1376: SELECT 'X'
1377: FROM IGS_EN_SU_ATTEMPT sua
1378: WHERE sua.person_id = sca.person_id AND
1379: sua.unit_cd = p_unit_cd AND
1380: sua.version_number = NVL(p_uv_version_number, sua.version_number) AND
1381: sua.location_cd = NVL(p_unit_loc_cd,sua.location_cd) AND

Line 1410: CURSOR cur_sua_stat (cp_person_id igs_en_su_attempt.person_id%TYPE,

1406: AND cal_type = cp_cal_type
1407: AND ci_sequence_number = cp_ci_seq_num
1408: AND unit_class = cp_unit_class
1409: AND location_cd = cp_location_cd;
1410: CURSOR cur_sua_stat (cp_person_id igs_en_su_attempt.person_id%TYPE,
1411: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
1412: cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE)IS
1413: SELECT unit_attempt_status
1414: FROM igs_en_su_attempt

Line 1411: cp_course_cd igs_en_su_attempt.course_cd%TYPE,

1407: AND ci_sequence_number = cp_ci_seq_num
1408: AND unit_class = cp_unit_class
1409: AND location_cd = cp_location_cd;
1410: CURSOR cur_sua_stat (cp_person_id igs_en_su_attempt.person_id%TYPE,
1411: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
1412: cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE)IS
1413: SELECT unit_attempt_status
1414: FROM igs_en_su_attempt
1415: WHERE person_id = cp_person_id

Line 1414: FROM igs_en_su_attempt

1410: CURSOR cur_sua_stat (cp_person_id igs_en_su_attempt.person_id%TYPE,
1411: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
1412: cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE)IS
1413: SELECT unit_attempt_status
1414: FROM igs_en_su_attempt
1415: WHERE person_id = cp_person_id
1416: AND course_cd = cp_course_cd
1417: AND uoo_id = cp_uoo_id;
1418:

Line 1431: CURSOR cur_get_sua_d (cp_person_id igs_en_su_attempt.person_id%TYPE,

1427: AND load_cal_type = cp_load_cal_type
1428: AND load_ci_sequence_number = cp_load_seq_num;
1429:
1430:
1431: CURSOR cur_get_sua_d (cp_person_id igs_en_su_attempt.person_id%TYPE,
1432: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
1433: cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
1434: cp_ver_num igs_ps_unit_ofr_opt.version_number%TYPE,
1435: cp_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE,

Line 1432: cp_course_cd igs_en_su_attempt.course_cd%TYPE,

1428: AND load_ci_sequence_number = cp_load_seq_num;
1429:
1430:
1431: CURSOR cur_get_sua_d (cp_person_id igs_en_su_attempt.person_id%TYPE,
1432: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
1433: cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
1434: cp_ver_num igs_ps_unit_ofr_opt.version_number%TYPE,
1435: cp_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE,
1436: cp_ci_seq_num igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,

Line 1440: FROM igs_en_su_attempt sua,

1436: cp_ci_seq_num igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,
1437: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
1438: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE)IS
1439: SELECT sua.uoo_id,sua.unit_attempt_status,uoo.relation_type
1440: FROM igs_en_su_attempt sua,
1441: igs_ps_unit_ofr_opt uoo
1442: WHERE sua.person_id = cp_person_id
1443: AND sua.course_cd = cp_course_cd
1444: AND sua.unit_cd = cp_unit_cd

Line 2792: igs_en_su_attempt sua,

2788: sua.version_number,
2789: sca.version_number program_version_number,
2790: sua.uoo_id
2791: FROM
2792: igs_en_su_attempt sua,
2793: igs_en_stdnt_ps_att sca
2794: WHERE (
2795: (p_course_cd IS NULL OR sca.course_cd LIKE p_course_cd) AND
2796: (sca.course_attempt_status NOT IN ('LAPSED','DISCONTIN')) AND

Line 2895: v_to_uv_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE := 0;

2891: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE ;
2892: v_message_name Varchar2(30) ;
2893: v_teach_start_dt IGS_CA_INST.start_dt%TYPE ;
2894: v_teach_end_dt IGS_CA_INST.end_dt%TYPE ;
2895: v_to_uv_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE := 0;
2896: v_to_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE ;
2897: v_to_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE ;
2898: v_rollback_occurred BOOLEAN := FALSE;
2899: v_processing_occurred BOOLEAN :=FALSE;

Line 2896: v_to_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE ;

2892: v_message_name Varchar2(30) ;
2893: v_teach_start_dt IGS_CA_INST.start_dt%TYPE ;
2894: v_teach_end_dt IGS_CA_INST.end_dt%TYPE ;
2895: v_to_uv_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE := 0;
2896: v_to_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE ;
2897: v_to_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE ;
2898: v_rollback_occurred BOOLEAN := FALSE;
2899: v_processing_occurred BOOLEAN :=FALSE;
2900: v_error_occurred BOOLEAN := FALSE;

Line 2897: v_to_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE ;

2893: v_teach_start_dt IGS_CA_INST.start_dt%TYPE ;
2894: v_teach_end_dt IGS_CA_INST.end_dt%TYPE ;
2895: v_to_uv_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE := 0;
2896: v_to_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE ;
2897: v_to_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE ;
2898: v_rollback_occurred BOOLEAN := FALSE;
2899: v_processing_occurred BOOLEAN :=FALSE;
2900: v_error_occurred BOOLEAN := FALSE;
2901: v_validation_error BOOLEAN := FALSE;

Line 2917: l_unit_attempt_status IGS_EN_SU_ATTEMPT.UNIT_ATTEMPT_STATUS%TYPE;

2913: l_person_type IGS_PE_PERSON_TYPES.person_type_code%TYPE;
2914: l_waitlist_flag VARCHAR2(1) DEFAULT 'N';
2915: l_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2916: l_load_seq_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
2917: l_unit_attempt_status IGS_EN_SU_ATTEMPT.UNIT_ATTEMPT_STATUS%TYPE;
2918: l_destination_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE;
2919: l_dummy1 VARCHAR2(30);
2920: l_dummy2 VARCHAR2(30);
2921: l_dummy VARCHAR2(200);

Line 2918: l_destination_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE;

2914: l_waitlist_flag VARCHAR2(1) DEFAULT 'N';
2915: l_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2916: l_load_seq_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
2917: l_unit_attempt_status IGS_EN_SU_ATTEMPT.UNIT_ATTEMPT_STATUS%TYPE;
2918: l_destination_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE;
2919: l_dummy1 VARCHAR2(30);
2920: l_dummy2 VARCHAR2(30);
2921: l_dummy VARCHAR2(200);
2922:

Line 2924: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

2920: l_dummy2 VARCHAR2(30);
2921: l_dummy VARCHAR2(200);
2922:
2923: PROCEDURE enrpl_upd_sua_uoo(
2924: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
2925: p_course_cd IGS_PS_VER.course_cd%TYPE,
2926: p_version_number IGS_PS_UNIT_VER.version_number%TYPE, --program version
2927: p_u_version_number IGS_PS_UNIT_VER.version_number%TYPE, --unit version
2928: p_from_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE,

Line 2928: p_from_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE,

2924: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
2925: p_course_cd IGS_PS_VER.course_cd%TYPE,
2926: p_version_number IGS_PS_UNIT_VER.version_number%TYPE, --program version
2927: p_u_version_number IGS_PS_UNIT_VER.version_number%TYPE, --unit version
2928: p_from_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE,
2929: p_teach_end_dt IGS_CA_INST.end_dt%TYPE,
2930: p_location_cd IGS_AD_LOCATION.location_cd%TYPE,
2931: p_unit_class IGS_AS_UNIT_CLASS.unit_class%TYPE,
2932: p_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE,

Line 2932: p_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE,

2928: p_from_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE,
2929: p_teach_end_dt IGS_CA_INST.end_dt%TYPE,
2930: p_location_cd IGS_AD_LOCATION.location_cd%TYPE,
2931: p_unit_class IGS_AS_UNIT_CLASS.unit_class%TYPE,
2932: p_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE,
2933: p_enrolled_dt IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE,
2934: p_to_uv_version_number IGS_PS_UNIT_VER.version_number%TYPE,
2935: p_to_location_cd IGS_AD_LOCATION.location_cd%TYPE,
2936: p_to_unit_class IGS_AS_UNIT_CLASS.unit_class%TYPE,

Line 2933: p_enrolled_dt IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE,

2929: p_teach_end_dt IGS_CA_INST.end_dt%TYPE,
2930: p_location_cd IGS_AD_LOCATION.location_cd%TYPE,
2931: p_unit_class IGS_AS_UNIT_CLASS.unit_class%TYPE,
2932: p_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE,
2933: p_enrolled_dt IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE,
2934: p_to_uv_version_number IGS_PS_UNIT_VER.version_number%TYPE,
2935: p_to_location_cd IGS_AD_LOCATION.location_cd%TYPE,
2936: p_to_unit_class IGS_AS_UNIT_CLASS.unit_class%TYPE,
2937: p_sua_error_count IN OUT NOCOPY NUMBER,

Line 2950: p_destination_uoo_id IN OUT NOCOPY IGS_EN_SU_ATTEMPT.UOO_ID%TYPE,

2946: p_reason IN VARCHAR2,
2947: p_load_cal_type IN VARCHAR2,
2948: p_load_seq_number IN NUMBER,
2949: p_waitlist_flag OUT NOCOPY VARCHAR2,
2950: p_destination_uoo_id IN OUT NOCOPY IGS_EN_SU_ATTEMPT.UOO_ID%TYPE,
2951: p_acad_cal_type IN VARCHAR2,
2952: p_acad_seq_number IN NUMBER )
2953: AS
2954: /*

Line 2997: FROM IGS_EN_SU_ATTEMPT

2993: grading_schema_code,
2994: gs_version_number,
2995: override_enrolled_cp,
2996: no_assessment_ind
2997: FROM IGS_EN_SU_ATTEMPT
2998: WHERE person_id = p_person_id
2999: AND course_cd = p_course_cd
3000: AND uoo_id = p_from_uoo_id;
3001: rec_f_unit cur_f_unit%ROWTYPE;

Line 3024: CURSOR c_dest_sua(p_d_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS

3020: WHERE uoo_id = cp_uoo_id;
3021: src_exam_rec cur_exam_loc%ROWTYPE;
3022: dst_exam_rec cur_exam_loc%ROWTYPE;
3023:
3024: CURSOR c_dest_sua(p_d_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS
3025: SELECT 'X'
3026: FROM IGS_EN_SU_ATTEMPT sua
3027: WHERE sua.person_id = p_person_id AND
3028: sua.course_cd = p_course_cd AND

Line 3026: FROM IGS_EN_SU_ATTEMPT sua

3022: dst_exam_rec cur_exam_loc%ROWTYPE;
3023:
3024: CURSOR c_dest_sua(p_d_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS
3025: SELECT 'X'
3026: FROM IGS_EN_SU_ATTEMPT sua
3027: WHERE sua.person_id = p_person_id AND
3028: sua.course_cd = p_course_cd AND
3029: sua.uoo_id = p_d_uoo_id AND
3030: sua.unit_attempt_status <> 'DROPPED';

Line 3035: FROM IGS_EN_SU_ATTEMPT sua

3031: r_dest_sua c_dest_sua%ROWTYPE;
3032:
3033: CURSOR c_sua_upd IS
3034: SELECT sua.rowid, sua.*
3035: FROM IGS_EN_SU_ATTEMPT sua
3036: WHERE sua.person_id = p_person_id AND
3037: sua.course_cd = p_course_cd AND
3038: sua.uoo_id = p_from_uoo_id
3039: FOR UPDATE OF

Line 3047: CURSOR c_from_usec_grad_schm(l_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS

3043: sua.uoo_id NOWAIT;
3044:
3045: -- Curosr for getting the grading schema in Unit section level for
3046: -- the source
3047: CURSOR c_from_usec_grad_schm(l_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
3048: SELECT grading_schema_code, grd_schm_version_number, default_flag
3049: FROM igs_ps_usec_grd_schm
3050: WHERE uoo_id = l_uoo_id
3051: AND default_flag = 'Y';

Line 3054: CURSOR c_usec_grad_schm(l_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS

3050: WHERE uoo_id = l_uoo_id
3051: AND default_flag = 'Y';
3052:
3053: -- Curosr for getting the grading schema in Unit section level for the destination
3054: CURSOR c_usec_grad_schm(l_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
3055: SELECT grading_schema_code, grd_schm_version_number, default_flag
3056: FROM igs_ps_usec_grd_schm
3057: WHERE uoo_id = l_uoo_id;
3058:

Line 3078: CURSOR c_unit_cd (l_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS

3074: AND grd_schm_version_number = p_grd_schm_version_number
3075: AND default_flag = 'Y';
3076:
3077: -- Cursor to get the unit code and version number for the passed uoo_id
3078: CURSOR c_unit_cd (l_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
3079: SELECT unit_cd, version_number
3080: FROM igs_ps_unit_ofr_opt
3081: WHERE uoo_id = l_uoo_id ;
3082:

Line 3084: CURSOR c_uoo_rel_type (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS

3080: FROM igs_ps_unit_ofr_opt
3081: WHERE uoo_id = l_uoo_id ;
3082:
3083: -- Cursor to get the Relation_type for the passed uoo_id
3084: CURSOR c_uoo_rel_type (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
3085: SELECT NVL(relation_type,'NONE'),sup_uoo_id
3086: FROM igs_ps_unit_ofr_opt
3087: WHERE uoo_id = cp_uoo_id ;
3088:

Line 3112: FROM igs_en_su_attempt

3108:
3109: -- Cursor to get the assessment indicator value.
3110: CURSOR c_assessment IS
3111: SELECT no_assessment_ind
3112: FROM igs_en_su_attempt
3113: WHERE person_id = p_person_id
3114: AND course_cd = p_course_cd
3115: AND uoo_id = p_destination_uoo_id;
3116:

Line 3118: CURSOR c_admin_pri (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE,cp_waitlist_dt DATE) IS

3114: AND course_cd = p_course_cd
3115: AND uoo_id = p_destination_uoo_id;
3116:
3117: --Cursor to get waitlist position
3118: CURSOR c_admin_pri (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE,cp_waitlist_dt DATE) IS
3119: SELECT NVL(MAX(administrative_priority),0)+1
3120: FROM igs_en_su_attempt
3121: WHERE uoo_id=cp_uoo_id
3122: AND waitlist_dt<=cp_waitlist_dt

Line 3120: FROM igs_en_su_attempt

3116:
3117: --Cursor to get waitlist position
3118: CURSOR c_admin_pri (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE,cp_waitlist_dt DATE) IS
3119: SELECT NVL(MAX(administrative_priority),0)+1
3120: FROM igs_en_su_attempt
3121: WHERE uoo_id=cp_uoo_id
3122: AND waitlist_dt<=cp_waitlist_dt
3123: AND unit_attempt_status='WAITLISTED';
3124:

Line 3125: CURSOR c_lock_dest_usec(cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS

3121: WHERE uoo_id=cp_uoo_id
3122: AND waitlist_dt<=cp_waitlist_dt
3123: AND unit_attempt_status='WAITLISTED';
3124:
3125: CURSOR c_lock_dest_usec(cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
3126: SELECT uoo_id
3127: FROM igs_ps_unit_ofr_opt
3128: WHERE uoo_id=cp_uoo_id FOR UPDATE;
3129:

Line 3157: l_override_enrolled_cp igs_en_su_attempt.override_enrolled_cp%TYPE DEFAULT 0;

3153: l_dummy VARCHAR2(50) DEFAULT NULL;
3154: l_dummy_bolean BOOLEAN DEFAULT TRUE;
3155: l_message VARCHAR2(100) DEFAULT NULL;
3156: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;
3157: l_override_enrolled_cp igs_en_su_attempt.override_enrolled_cp%TYPE DEFAULT 0;
3158: l_repeat_flag VARCHAR2(1);
3159: l_source_enrolled_cp igs_en_su_attempt.override_enrolled_cp%TYPE DEFAULT 0;
3160: l_dest_enrolled_cp igs_en_su_attempt.override_enrolled_cp%TYPE DEFAULT 0;
3161: -- Added as part of Enrollment Eligibility and validations

Line 3159: l_source_enrolled_cp igs_en_su_attempt.override_enrolled_cp%TYPE DEFAULT 0;

3155: l_message VARCHAR2(100) DEFAULT NULL;
3156: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;
3157: l_override_enrolled_cp igs_en_su_attempt.override_enrolled_cp%TYPE DEFAULT 0;
3158: l_repeat_flag VARCHAR2(1);
3159: l_source_enrolled_cp igs_en_su_attempt.override_enrolled_cp%TYPE DEFAULT 0;
3160: l_dest_enrolled_cp igs_en_su_attempt.override_enrolled_cp%TYPE DEFAULT 0;
3161: -- Added as part of Enrollment Eligibility and validations
3162: l_eftsu_total igs_en_su_attempt.override_eftsu%type DEFAULT NULL ;
3163: l_total_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE ;

Line 3160: l_dest_enrolled_cp igs_en_su_attempt.override_enrolled_cp%TYPE DEFAULT 0;

3156: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;
3157: l_override_enrolled_cp igs_en_su_attempt.override_enrolled_cp%TYPE DEFAULT 0;
3158: l_repeat_flag VARCHAR2(1);
3159: l_source_enrolled_cp igs_en_su_attempt.override_enrolled_cp%TYPE DEFAULT 0;
3160: l_dest_enrolled_cp igs_en_su_attempt.override_enrolled_cp%TYPE DEFAULT 0;
3161: -- Added as part of Enrollment Eligibility and validations
3162: l_eftsu_total igs_en_su_attempt.override_eftsu%type DEFAULT NULL ;
3163: l_total_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE ;
3164: l_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE DEFAULT NULL ;

Line 3162: l_eftsu_total igs_en_su_attempt.override_eftsu%type DEFAULT NULL ;

3158: l_repeat_flag VARCHAR2(1);
3159: l_source_enrolled_cp igs_en_su_attempt.override_enrolled_cp%TYPE DEFAULT 0;
3160: l_dest_enrolled_cp igs_en_su_attempt.override_enrolled_cp%TYPE DEFAULT 0;
3161: -- Added as part of Enrollment Eligibility and validations
3162: l_eftsu_total igs_en_su_attempt.override_eftsu%type DEFAULT NULL ;
3163: l_total_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE ;
3164: l_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE DEFAULT NULL ;
3165: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;
3166: l_rowid VARCHAR2(25);

Line 3163: l_total_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE ;

3159: l_source_enrolled_cp igs_en_su_attempt.override_enrolled_cp%TYPE DEFAULT 0;
3160: l_dest_enrolled_cp igs_en_su_attempt.override_enrolled_cp%TYPE DEFAULT 0;
3161: -- Added as part of Enrollment Eligibility and validations
3162: l_eftsu_total igs_en_su_attempt.override_eftsu%type DEFAULT NULL ;
3163: l_total_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE ;
3164: l_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE DEFAULT NULL ;
3165: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;
3166: l_rowid VARCHAR2(25);
3167: l_encoded_msg VARCHAR2(2000);

Line 3164: l_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE DEFAULT NULL ;

3160: l_dest_enrolled_cp igs_en_su_attempt.override_enrolled_cp%TYPE DEFAULT 0;
3161: -- Added as part of Enrollment Eligibility and validations
3162: l_eftsu_total igs_en_su_attempt.override_eftsu%type DEFAULT NULL ;
3163: l_total_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE ;
3164: l_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE DEFAULT NULL ;
3165: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;
3166: l_rowid VARCHAR2(25);
3167: l_encoded_msg VARCHAR2(2000);
3168: l_app_sht_name VARCHAR2(100);

Line 3165: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;

3161: -- Added as part of Enrollment Eligibility and validations
3162: l_eftsu_total igs_en_su_attempt.override_eftsu%type DEFAULT NULL ;
3163: l_total_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE ;
3164: l_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE DEFAULT NULL ;
3165: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;
3166: l_rowid VARCHAR2(25);
3167: l_encoded_msg VARCHAR2(2000);
3168: l_app_sht_name VARCHAR2(100);
3169: l_msg_name VARCHAR2(2000);