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

Line 7: p_person_id igs_en_su_attempt.person_id%TYPE,

3: --package variables
4: pkg_coreq_failed_uooids VARCHAR2(2000);
5: pkg_prereq_failed_uooids VARCHAR2(2000);
6: PROCEDURE validate_prog_pro(
7: p_person_id igs_en_su_attempt.person_id%TYPE,
8: p_cal_type igs_ca_inst.cal_type%TYPE,
9: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
10: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
11: p_course_cd igs_en_su_attempt.course_cd%TYPE,

Line 11: p_course_cd igs_en_su_attempt.course_cd%TYPE,

7: p_person_id igs_en_su_attempt.person_id%TYPE,
8: p_cal_type igs_ca_inst.cal_type%TYPE,
9: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
10: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
11: p_course_cd igs_en_su_attempt.course_cd%TYPE,
12: p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,
13: p_message_name OUT NOCOPY VARCHAR2,
14: p_deny_warn OUT NOCOPY VARCHAR2,
15: p_return_status OUT NOCOPY VARCHAR2

Line 12: p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,

8: p_cal_type igs_ca_inst.cal_type%TYPE,
9: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
10: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
11: p_course_cd igs_en_su_attempt.course_cd%TYPE,
12: p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,
13: p_message_name OUT NOCOPY VARCHAR2,
14: p_deny_warn OUT NOCOPY VARCHAR2,
15: p_return_status OUT NOCOPY VARCHAR2
16: ) AS

Line 181: p_person_id IN igs_en_su_attempt.person_id%TYPE,

177: END enrp_ss_val_person_step;
178:
179:
180: PROCEDURE validate_unit_steps(
181: p_person_id IN igs_en_su_attempt.person_id%TYPE,
182: p_cal_type IN igs_ca_inst.cal_type%TYPE,
183: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
184: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
185: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

Line 185: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

181: p_person_id IN igs_en_su_attempt.person_id%TYPE,
182: p_cal_type IN igs_ca_inst.cal_type%TYPE,
183: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
184: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
185: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
186: p_return_status OUT NOCOPY VARCHAR2,
187: p_message_name OUT NOCOPY VARCHAR2,
188: p_deny_warn OUT NOCOPY VARCHAR2
189: ) AS

Line 273: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE

269: p_cal_type IN VARCHAR2,
270: p_sequence_number IN NUMBER,
271: p_course_cd IN VARCHAR2,
272: p_unit_cd IN VARCHAR2,
273: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE
274: ) IS
275:
276: l_row_id VARCHAR2(25);
277: l_return_val NUMBER;

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

342: --Who When What
343: --stutta 11-FEB-2004 Added new parameter p_enrolled_dt. Replace the code to
344: -- populate enrolled date with SYSDATE always to consider the
345: -- value passed in.
346: --mesriniv 12-sep-2002 Added a new parameter waitlist_manual_ind in TBH call of IGS_EN_SU_ATTEMPT
347: -- for Bug 2554109 MINI Waitlist Build for Jan 03 Release
348: -- kamohan 10-NOV-2001 Added this procedure for the Enrollment Worksheet
349: --
350: -------------------------------------------------------------------------------------

Line 354: igs_en_su_attempt sua

350: -------------------------------------------------------------------------------------
351: CURSOR cart_cur IS
352: SELECT sua.*
353: FROM
354: igs_en_su_attempt sua
355: WHERE
356: person_id = p_person_id AND
357: course_cd = p_course_cd AND
358: unit_cd = p_unit_cd AND

Line 445: p_person_id IN igs_en_su_attempt.person_id%TYPE,

441: X_CORE_INDICATOR_CODE => cart_rec.core_indicator_code
442: );
443: END enroll_cart_unit;
444: PROCEDURE Validate_enroll_validate (
445: p_person_id IN igs_en_su_attempt.person_id%TYPE,
446: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
447: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
448: p_uoo_ids IN VARCHAR2,
449: p_program_cd IN igs_en_su_attempt.course_cd%TYPE,

Line 449: p_program_cd IN igs_en_su_attempt.course_cd%TYPE,

445: p_person_id IN igs_en_su_attempt.person_id%TYPE,
446: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
447: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
448: p_uoo_ids IN VARCHAR2,
449: p_program_cd IN igs_en_su_attempt.course_cd%TYPE,
450: p_message_name OUT NOCOPY VARCHAR2,
451: p_deny_warn OUT NOCOPY VARCHAR2,
452: p_return_status OUT NOCOPY VARCHAR2,
453: p_enr_method IN igs_en_cat_prc_dtl.enr_method_type%TYPE,

Line 806: IGS_EN_SU_ATTEMPT SUA,

802: -------------------------------------------------------------------------------------*/
803: CURSOR cur_units_cart(cp_person_id NUMBER,cp_course_cd VARCHAR2,cp_load_cal_type VARCHAR2,cp_load_ci_seq_num NUMBER ) IS
804: SELECT count(*) UNITS_IN_CART
805: FROM
806: IGS_EN_SU_ATTEMPT SUA,
807: IGS_EN_USEC_STAT_DSP_V ENUSECSTAT,
808: IGS_PS_UNIT_OFR_OPT UOO
809: WHERE sua.person_id = cp_person_id
810: AND sua.course_cd = cp_course_cd

Line 825: FROM igs_en_su_attempt sua,

821: -- get the total credit points in the cart
822: CURSOR cur_cart_credit_pts(cp_person_id NUMBER,cp_course_cd VARCHAR2,cp_load_cal_type VARCHAR2,cp_load_ci_seq_num NUMBER ) IS
823: SELECT SUM(NVL(sua.override_enrolled_cp,NVL(cps.enrolled_credit_points,
824: uv.enrolled_credit_points))) total_credit_points
825: FROM igs_en_su_attempt sua,
826: igs_en_usec_stat_dsp_v enusecstat,
827: igs_ps_unit_ofr_opt uoo,
828: igs_ps_usec_cps cps,
829: igs_ps_unit_ver uv

Line 1024: l_eftsu_total igs_en_su_attempt.override_eftsu%type;

1020: l_alternate_code igs_ca_inst.alternate_code%type;
1021: l_acad_message varchar2(100);
1022:
1023: -- Added as part of Enrollment Eligibility and validations
1024: l_eftsu_total igs_en_su_attempt.override_eftsu%type;
1025: l_total_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE ;
1026: l_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE := 0;
1027: l_dummy VARCHAR2(200);
1028: l_return_status VARCHAR2(10);

Line 1025: l_total_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE ;

1021: l_acad_message varchar2(100);
1022:
1023: -- Added as part of Enrollment Eligibility and validations
1024: l_eftsu_total igs_en_su_attempt.override_eftsu%type;
1025: l_total_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE ;
1026: l_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE := 0;
1027: l_dummy VARCHAR2(200);
1028: l_return_status VARCHAR2(10);
1029:

Line 1026: l_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE := 0;

1022:
1023: -- Added as part of Enrollment Eligibility and validations
1024: l_eftsu_total igs_en_su_attempt.override_eftsu%type;
1025: l_total_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE ;
1026: l_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE := 0;
1027: l_dummy VARCHAR2(200);
1028: l_return_status VARCHAR2(10);
1029:
1030: l_sub_uoo_ids VARCHAR2(2000);

Line 1076: v_ref_cur_rec igs_en_su_attempt%ROWTYPE;

1072: TYPE c_ref_cursor IS REF CURSOR;
1073: c_ref_cur_inst c_ref_cursor;
1074: c_ref_only_dup c_ref_cursor;
1075: c_chk_sub c_ref_cursor;
1076: v_ref_cur_rec igs_en_su_attempt%ROWTYPE;
1077:
1078: TYPE tDataBuff IS
1079: TABLE OF igs_en_su_attempt%ROWTYPE
1080: INDEX BY BINARY_INTEGER;

Line 1079: TABLE OF igs_en_su_attempt%ROWTYPE

1075: c_chk_sub c_ref_cursor;
1076: v_ref_cur_rec igs_en_su_attempt%ROWTYPE;
1077:
1078: TYPE tDataBuff IS
1079: TABLE OF igs_en_su_attempt%ROWTYPE
1080: INDEX BY BINARY_INTEGER;
1081:
1082: lData tDataBuff;
1083: lDataEmpty tDataBuff;

Line 1087: l_person_id_found igs_en_su_attempt_all.person_id%TYPE;

1083: lDataEmpty tDataBuff;
1084: t1_idx BINARY_INTEGER := 0;
1085: l_prereq_failed_uoo_ids VARCHAR2(2000);
1086: l_coreq_failed_uoo_ids VARCHAR2(2000);
1087: l_person_id_found igs_en_su_attempt_all.person_id%TYPE;
1088: BEGIN
1089: lData := lDataEmpty; --Initializing the array
1090:
1091: -- call igs_en_gen_017.enrp_get_enr_method to decide enrollment method type

Line 1235: FROM IGS_EN_SU_ATTEMPT U, IGS_CA_LOAD_TO_TEACH_V

1231: l_drop_uoo_ids := p_uoo_ids;
1232:
1233: OPEN c_ref_cur_inst FOR '
1234: SELECT DISTINCT u.person_id
1235: FROM IGS_EN_SU_ATTEMPT U, IGS_CA_LOAD_TO_TEACH_V
1236: WHERE person_id =:1
1237: AND course_cd = :2
1238: AND unit_attempt_status IN (''ENROLLED'',''INVALID'',''WAITLISTED'')
1239: AND cal_type = teach_cal_type

Line 1258: FROM IGS_EN_SU_ATTEMPT U

1254: -- not perform any validations. So that we do not get any min cp or
1255: -- attendance type validation fialures.
1256: OPEN c_ref_only_dup FOR '
1257: SELECT U.*
1258: FROM IGS_EN_SU_ATTEMPT U
1259: WHERE person_id =:1 AND
1260: unit_attempt_status <> ''DUPLICATE'' AND
1261: (cal_type,ci_sequence_number) IN
1262: (SELECT teach_cal_type,teach_ci_sequence_number

Line 1306: OPEN c_chk_sub FOR 'Select ''X'' from igs_en_su_attempt sua where sua.uoo_id in ('||l_sub_drop_uoo_ids||') AND sua.person_id =

1302: l_sub_unit := 'N';
1303: --cursor to
1304: IF l_sub_drop_uoo_ids IS NOT NULL THEN
1305:
1306: OPEN c_chk_sub FOR 'Select ''X'' from igs_en_su_attempt sua where sua.uoo_id in ('||l_sub_drop_uoo_ids||') AND sua.person_id =
1307: '||p_person_id|| 'AND sua.course_cd = '''|| p_program_cd|| '''AND exists (SELECT ''X'' from igs_ps_unit_ofr_opt uoo
1308: WHERE uoo.sup_uoo_id IN (' ||l_drop_alluoo_ids||') AND uoo.relation_type = ''SUBORDINATE'' AND uoo.uoo_id = sua.uoo_id)';
1309:
1310: FETCH c_chk_sub INTO l_chk_sub;

Line 1337: OPEN c_ref_cur_inst FOR ' SELECT U.* FROM IGS_EN_SU_ATTEMPT U WHERE person_id

1333: END IF;
1334: END LOOP;
1335: ELSE
1336:
1337: OPEN c_ref_cur_inst FOR ' SELECT U.* FROM IGS_EN_SU_ATTEMPT U WHERE person_id
1338: = :1 AND unit_attempt_status IN (''ENROLLED'',''INVALID'') AND
1339: uoo_id NOT IN('||p_uoo_ids||')'
1340: USING p_person_id;
1341:

Line 1426: OPEN c_chk_sub FOR 'Select ''X'' from igs_en_su_attempt sua where sua.uoo_id in ('||l_sub_drop_uoo_ids||') AND sua.person_id =

1422: l_sub_unit := 'N';
1423: --cursor to
1424: IF l_sub_drop_uoo_ids IS NOT NULL THEN
1425:
1426: OPEN c_chk_sub FOR 'Select ''X'' from igs_en_su_attempt sua where sua.uoo_id in ('||l_sub_drop_uoo_ids||') AND sua.person_id =
1427: '||p_person_id|| 'AND sua.course_cd = '''|| p_program_cd|| '''AND exists (SELECT ''X'' from igs_ps_unit_ofr_opt uoo
1428: WHERE uoo.sup_uoo_id IN (' ||l_drop_alluoo_ids||') AND uoo.relation_type = ''SUBORDINATE'' AND uoo.uoo_id = sua.uoo_id)';
1429:
1430: FETCH c_chk_sub INTO l_chk_sub;

Line 1585: OPEN c_ref_cur_inst FOR ' SELECT U.* FROM IGS_EN_SU_ATTEMPT U WHERE person_id

1581: IF p_ovrrd_min_cp_chk = 'Y' OR NOT l_min_cp_failed THEN
1582:
1583: -- check if any prereq/coreq rules are failing before the drop so that these rule failures
1584: -- can be ignored later.
1585: OPEN c_ref_cur_inst FOR ' SELECT U.* FROM IGS_EN_SU_ATTEMPT U WHERE person_id
1586: = :1 AND unit_attempt_status IN (''ENROLLED'',''INVALID'') AND
1587: uoo_id NOT IN('||p_uoo_ids||')'
1588: USING p_person_id;
1589:

Line 1840: wf_event.addparametertolist(P_NAME => 'REASON' ,P_VALUE => igs_en_su_attempt_pkg.pkg_reason ,P_PARAMETERLIST => l_wf_parameter_list_t);

1836: wf_event.addparametertolist(P_NAME => 'OLD_CP' ,P_VALUE => NVL(p_old_cp,0) ,P_PARAMETERLIST => l_wf_parameter_list_t);
1837: wf_event.addparametertolist(P_NAME => 'NEW_CP' ,P_VALUE => NVL(p_new_cp,0) ,P_PARAMETERLIST => l_wf_parameter_list_t);
1838: wf_event.addparametertolist(P_NAME => 'P_WF_ROLE' ,P_VALUE => l_wf_role ,P_PARAMETERLIST => l_wf_parameter_list_t);
1839: wf_event.addparametertolist(P_NAME => 'CAL_DESC' ,P_VALUE => l_cal_desc ,P_PARAMETERLIST => l_wf_parameter_list_t);
1840: wf_event.addparametertolist(P_NAME => 'REASON' ,P_VALUE => igs_en_su_attempt_pkg.pkg_reason ,P_PARAMETERLIST => l_wf_parameter_list_t);
1841: wf_event.addparametertolist(P_NAME => 'SOURCE_OF_DROP' ,P_VALUE => igs_en_su_attempt_pkg.pkg_source_of_drop ,P_PARAMETERLIST => l_wf_parameter_list_t);
1842:
1843: -- raise the event
1844: WF_EVENT.RAISE(p_event_name=>'oracle.apps.igs.en.dropnotification',

Line 1841: wf_event.addparametertolist(P_NAME => 'SOURCE_OF_DROP' ,P_VALUE => igs_en_su_attempt_pkg.pkg_source_of_drop ,P_PARAMETERLIST => l_wf_parameter_list_t);

1837: wf_event.addparametertolist(P_NAME => 'NEW_CP' ,P_VALUE => NVL(p_new_cp,0) ,P_PARAMETERLIST => l_wf_parameter_list_t);
1838: wf_event.addparametertolist(P_NAME => 'P_WF_ROLE' ,P_VALUE => l_wf_role ,P_PARAMETERLIST => l_wf_parameter_list_t);
1839: wf_event.addparametertolist(P_NAME => 'CAL_DESC' ,P_VALUE => l_cal_desc ,P_PARAMETERLIST => l_wf_parameter_list_t);
1840: wf_event.addparametertolist(P_NAME => 'REASON' ,P_VALUE => igs_en_su_attempt_pkg.pkg_reason ,P_PARAMETERLIST => l_wf_parameter_list_t);
1841: wf_event.addparametertolist(P_NAME => 'SOURCE_OF_DROP' ,P_VALUE => igs_en_su_attempt_pkg.pkg_source_of_drop ,P_PARAMETERLIST => l_wf_parameter_list_t);
1842:
1843: -- raise the event
1844: WF_EVENT.RAISE(p_event_name=>'oracle.apps.igs.en.dropnotification',
1845: p_event_key =>'oracle.apps.igs.en.dropnotification'||l_cur_seq_val.seq_val,

Line 2060: FROM igs_en_su_attempt

2056: discontinued_dt,
2057: administrative_unit_status ,
2058: unit_attempt_status,
2059: no_assessment_ind
2060: FROM igs_en_su_attempt
2061: WHERE person_id = x_person_id AND
2062: course_cd = x_program_cd AND
2063: uoo_id = x_uoo_id;
2064:

Line 2075: FROM igs_en_su_attempt_all sua

2071:
2072: -- Cursor to get the Unit Attempt Details .
2073: CURSOR get_sua_dtls IS
2074: SELECT sua.rowid , sua.*
2075: FROM igs_en_su_attempt_all sua
2076: WHERE person_id = x_person_id AND
2077: course_cd = x_program_cd AND
2078: uoo_id = x_uoo_id FOR UPDATE NOWAIT;
2079:

Line 2083: FROM igs_en_su_attempt

2079:
2080: -- Cursor to get the assessment indicator value.
2081: CURSOR c_assessment IS
2082: SELECT no_assessment_ind
2083: FROM igs_en_su_attempt
2084: WHERE person_id = x_person_id
2085: AND course_cd = x_program_cd
2086: AND uoo_id = x_uoo_id;
2087:

Line 2107: l_calc_cp igs_en_su_attempt.override_enrolled_cp%TYPE;

2103: l_enr_ci_seq NUMBER(20);
2104: l_enr_cat VARCHAR2(20);
2105: l_enr_comm VARCHAR2(2000);
2106:
2107: l_calc_cp igs_en_su_attempt.override_enrolled_cp%TYPE;
2108: l_calc_min_cp igs_en_su_attempt.override_enrolled_cp%TYPE;
2109: l_eftsu_total igs_en_su_attempt.override_enrolled_cp%TYPE;
2110:
2111: l_su_rec cur_su%ROWTYPE;

Line 2108: l_calc_min_cp igs_en_su_attempt.override_enrolled_cp%TYPE;

2104: l_enr_cat VARCHAR2(20);
2105: l_enr_comm VARCHAR2(2000);
2106:
2107: l_calc_cp igs_en_su_attempt.override_enrolled_cp%TYPE;
2108: l_calc_min_cp igs_en_su_attempt.override_enrolled_cp%TYPE;
2109: l_eftsu_total igs_en_su_attempt.override_enrolled_cp%TYPE;
2110:
2111: l_su_rec cur_su%ROWTYPE;
2112: l_total_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE := NULL ;

Line 2109: l_eftsu_total igs_en_su_attempt.override_enrolled_cp%TYPE;

2105: l_enr_comm VARCHAR2(2000);
2106:
2107: l_calc_cp igs_en_su_attempt.override_enrolled_cp%TYPE;
2108: l_calc_min_cp igs_en_su_attempt.override_enrolled_cp%TYPE;
2109: l_eftsu_total igs_en_su_attempt.override_enrolled_cp%TYPE;
2110:
2111: l_su_rec cur_su%ROWTYPE;
2112: l_total_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE := NULL ;
2113:

Line 2112: l_total_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE := NULL ;

2108: l_calc_min_cp igs_en_su_attempt.override_enrolled_cp%TYPE;
2109: l_eftsu_total igs_en_su_attempt.override_enrolled_cp%TYPE;
2110:
2111: l_su_rec cur_su%ROWTYPE;
2112: l_total_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE := NULL ;
2113:
2114: l_enr_incurred_cp NUMBER DEFAULT 0;
2115: l_over_incurred_cp NUMBER DEFAULT 0;
2116: l_current_cp NUMBER DEFAULT 0;

Line 2181: -- (As the current CP can be from igs_ps_unit_ver or from igs_en_su_attempt)

2177: -- Below code is added as part of Bug 2401891
2178: -- Checking Load Incurred as user can re-instate a discontinued unit and change CP in one transaction
2179: --
2180: -- Getting the current cp and passing this against parameter p_override_enrolled_cp to get Incurred CP.
2181: -- (As the current CP can be from igs_ps_unit_ver or from igs_en_su_attempt)
2182: l_current_cp := igs_ss_enr_details.get_credit_points(x_person_id,x_uoo_id,l_su_rec.unit_cd,l_su_rec.version_number,x_program_cd);
2183: IF Igs_En_Prc_Load.ENRP_GET_LOAD_INCUR(
2184: l_su_rec.cal_type,
2185: l_su_rec.ci_sequence_number,

Line 2470: Igs_En_Su_Attempt_Pkg.update_row

2466: OPEN get_sua_dtls;
2467: FETCH get_sua_dtls INTO l_sua_dtls_rec;
2468: CLOSE get_sua_dtls;
2469:
2470: Igs_En_Su_Attempt_Pkg.update_row
2471: (x_rowid => l_sua_dtls_rec.ROWID,
2472: x_person_id =>l_sua_dtls_rec.person_id,
2473: x_course_cd =>l_sua_dtls_rec.course_cd,
2474: x_unit_cd =>l_sua_dtls_rec.unit_cd,

Line 2685: l_eftsu_total igs_en_su_attempt.override_eftsu%type;

2681: l_enr_ci_seq NUMBER(20);
2682: l_enr_comm VARCHAR2(2000);
2683: l_return_status VARCHAR2(10);
2684: -- Added as part of Enrollment Eligibility and validations
2685: l_eftsu_total igs_en_su_attempt.override_eftsu%type;
2686: l_total_credit_points NUMBER;
2687: l_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE := 0;
2688: l_unit_version_number igs_ps_unit_ver.VERSION_NUMBER%TYPE;
2689: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;

Line 2687: l_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE := 0;

2683: l_return_status VARCHAR2(10);
2684: -- Added as part of Enrollment Eligibility and validations
2685: l_eftsu_total igs_en_su_attempt.override_eftsu%type;
2686: l_total_credit_points NUMBER;
2687: l_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE := 0;
2688: l_unit_version_number igs_ps_unit_ver.VERSION_NUMBER%TYPE;
2689: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
2690: l_acad_start_dt igs_ca_inst.start_dt%type;
2691: l_acad_end_dt igs_ca_inst.end_dt%type;

Line 2726: l_core_indicator_code igs_en_su_attempt.core_indicator_code%TYPE;

2722:
2723: l_attendance_type_reach BOOLEAN := TRUE;
2724: l_cur_coo_id cur_coo_id%ROWTYPE;
2725: l_attendance_types VARCHAR2(100); -- As returned from the function igs_en_val_sca.enrp_val_coo_att
2726: l_core_indicator_code igs_en_su_attempt.core_indicator_code%TYPE;
2727: l_deny_warn VARCHAR2(10);
2728:
2729: --
2730: -- Cursor to find the Core Indicator associated with a Unit Attempt - ptandon, Enh Bug# 3052432

Line 2732: CURSOR cur_get_core_ind(cp_person_id igs_en_su_attempt.person_id%TYPE,

2728:
2729: --
2730: -- Cursor to find the Core Indicator associated with a Unit Attempt - ptandon, Enh Bug# 3052432
2731: --
2732: CURSOR cur_get_core_ind(cp_person_id igs_en_su_attempt.person_id%TYPE,
2733: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
2734: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE)
2735: IS
2736: SELECT core_indicator_code

Line 2733: cp_course_cd igs_en_su_attempt.course_cd%TYPE,

2729: --
2730: -- Cursor to find the Core Indicator associated with a Unit Attempt - ptandon, Enh Bug# 3052432
2731: --
2732: CURSOR cur_get_core_ind(cp_person_id igs_en_su_attempt.person_id%TYPE,
2733: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
2734: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE)
2735: IS
2736: SELECT core_indicator_code
2737: FROM igs_en_su_attempt

Line 2734: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE)

2730: -- Cursor to find the Core Indicator associated with a Unit Attempt - ptandon, Enh Bug# 3052432
2731: --
2732: CURSOR cur_get_core_ind(cp_person_id igs_en_su_attempt.person_id%TYPE,
2733: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
2734: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE)
2735: IS
2736: SELECT core_indicator_code
2737: FROM igs_en_su_attempt
2738: WHERE person_id = cp_person_id

Line 2737: FROM igs_en_su_attempt

2733: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
2734: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE)
2735: IS
2736: SELECT core_indicator_code
2737: FROM igs_en_su_attempt
2738: WHERE person_id = cp_person_id
2739: AND course_cd = cp_course_cd
2740: AND uoo_id = cp_uoo_id;
2741:

Line 2752: v_ref_cur_rec igs_en_su_attempt%ROWTYPE;

2748: WHERE uoo_id = p_uoo_id;
2749:
2750: TYPE c_ref_cursor IS REF CURSOR;
2751: c_ref_cur_inst c_ref_cursor;
2752: v_ref_cur_rec igs_en_su_attempt%ROWTYPE;
2753: l_person_id_found igs_en_su_attempt_all.person_id%TYPE;
2754: TYPE tDataBuff IS
2755: TABLE OF igs_en_su_attempt%ROWTYPE
2756: INDEX BY BINARY_INTEGER;

Line 2753: l_person_id_found igs_en_su_attempt_all.person_id%TYPE;

2749:
2750: TYPE c_ref_cursor IS REF CURSOR;
2751: c_ref_cur_inst c_ref_cursor;
2752: v_ref_cur_rec igs_en_su_attempt%ROWTYPE;
2753: l_person_id_found igs_en_su_attempt_all.person_id%TYPE;
2754: TYPE tDataBuff IS
2755: TABLE OF igs_en_su_attempt%ROWTYPE
2756: INDEX BY BINARY_INTEGER;
2757:

Line 2755: TABLE OF igs_en_su_attempt%ROWTYPE

2751: c_ref_cur_inst c_ref_cursor;
2752: v_ref_cur_rec igs_en_su_attempt%ROWTYPE;
2753: l_person_id_found igs_en_su_attempt_all.person_id%TYPE;
2754: TYPE tDataBuff IS
2755: TABLE OF igs_en_su_attempt%ROWTYPE
2756: INDEX BY BINARY_INTEGER;
2757:
2758: lData tDataBuff;
2759: lDataEmpty tDataBuff;

Line 2882: OPEN c_ref_cur_inst FOR 'SELECT DISTINCT U.PERSON_ID FROM IGS_EN_SU_ATTEMPT U, igs_ca_load_to_teach_v WHERE person_id =:1 AND course_cd = :2 '||

2878: END IF;
2879: --Decode the concatenated string and check that all units are not selected,
2880: --in which case, just delete all units w/o checking cp or coreq requirements.
2881:
2882: OPEN c_ref_cur_inst FOR 'SELECT DISTINCT U.PERSON_ID FROM IGS_EN_SU_ATTEMPT U, igs_ca_load_to_teach_v WHERE person_id =:1 AND course_cd = :2 '||
2883: 'AND unit_attempt_status IN (''ENROLLED'',''INVALID'',''WAITLISTED'') '||
2884: 'AND cal_type = teach_cal_type AND ci_sequence_number= teach_ci_sequence_number '||
2885: 'AND load_cal_type = :3 AND load_ci_sequence_number =:4 '||
2886: 'AND uoo_id <> :5 '

Line 2915: OPEN c_ref_cur_inst FOR 'SELECT U.* FROM IGS_EN_SU_ATTEMPT U WHERE person_id = :1 '||

2911: CLOSE cur_uoo_id ;
2912: IF p_ovrrd_drop = 'N' THEN
2913: -- Check for rule failure prior to dropping the unit, so that such failures can be ignored.
2914: -- The list of failed uoo_ids is stored in package variables pkg_coreq_failed_uooids, pkg_prereq_failed_uooids
2915: OPEN c_ref_cur_inst FOR 'SELECT U.* FROM IGS_EN_SU_ATTEMPT U WHERE person_id = :1 '||
2916: 'AND unit_attempt_status IN (''ENROLLED'',''INVALID'') AND ' ||
2917: ' uoo_id <> :2'
2918: USING p_person_id, p_uoo_id;
2919:

Line 3123: OPEN c_ref_cur_inst FOR 'SELECT U.* FROM IGS_EN_SU_ATTEMPT U WHERE person_id = :1 '||

3119: END IF ;
3120: END IF; --l_deny_warn_att_type IS NOT NULL
3121: -- Only if min_cp validation passed, need to check for coreq validation
3122: l_message:= NULL;
3123: OPEN c_ref_cur_inst FOR 'SELECT U.* FROM IGS_EN_SU_ATTEMPT U WHERE person_id = :1 '||
3124: 'AND unit_attempt_status IN (''ENROLLED'',''INVALID'') AND ' ||
3125: ' uoo_id <> :2'
3126: USING p_person_id, p_uoo_id;
3127: LOOP

Line 3239: CURSOR cur_get_source_rowid(cp_person_id igs_en_su_attempt.person_id%TYPE,

3235:
3236: --
3237: -- Cursor to find the Rowid associated with a Unit Attempt
3238: --
3239: CURSOR cur_get_source_rowid(cp_person_id igs_en_su_attempt.person_id%TYPE,
3240: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
3241: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE)
3242: IS
3243: SELECT rowid

Line 3240: cp_course_cd igs_en_su_attempt.course_cd%TYPE,

3236: --
3237: -- Cursor to find the Rowid associated with a Unit Attempt
3238: --
3239: CURSOR cur_get_source_rowid(cp_person_id igs_en_su_attempt.person_id%TYPE,
3240: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
3241: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE)
3242: IS
3243: SELECT rowid
3244: FROM igs_en_su_attempt

Line 3241: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE)

3237: -- Cursor to find the Rowid associated with a Unit Attempt
3238: --
3239: CURSOR cur_get_source_rowid(cp_person_id igs_en_su_attempt.person_id%TYPE,
3240: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
3241: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE)
3242: IS
3243: SELECT rowid
3244: FROM igs_en_su_attempt
3245: WHERE person_id = cp_person_id

Line 3244: FROM igs_en_su_attempt

3240: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
3241: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE)
3242: IS
3243: SELECT rowid
3244: FROM igs_en_su_attempt
3245: WHERE person_id = cp_person_id
3246: AND course_cd = cp_course_cd
3247: AND uoo_id = cp_uoo_id;
3248:

Line 3273: IGS_EN_SU_ATTEMPT_PKG.DELETE_ROW(l_source_rowid);

3269: FETCH cur_get_source_rowid INTO l_source_rowid;
3270: CLOSE cur_get_source_rowid;
3271:
3272: -- Delete the source unit attempt
3273: IGS_EN_SU_ATTEMPT_PKG.DELETE_ROW(l_source_rowid);
3274:
3275: -- Get the Person Number
3276: OPEN cur_get_person_num(p_person_id);
3277: FETCH cur_get_person_num INTO l_person_number;

Line 3316: igs_en_su_attempt_pkg.pkg_reason := NULL;

3312: || Change History :
3313: || Who When What
3314: */
3315: BEGIN
3316: igs_en_su_attempt_pkg.pkg_reason := NULL;
3317: igs_en_su_attempt_pkg.pkg_source_of_drop :=NULL;
3318: igs_en_su_attempt_pkg.pkg_reason := p_reason;
3319: igs_en_su_attempt_pkg.pkg_source_of_drop := p_source_of_drop;
3320: NULL;

Line 3317: igs_en_su_attempt_pkg.pkg_source_of_drop :=NULL;

3313: || Who When What
3314: */
3315: BEGIN
3316: igs_en_su_attempt_pkg.pkg_reason := NULL;
3317: igs_en_su_attempt_pkg.pkg_source_of_drop :=NULL;
3318: igs_en_su_attempt_pkg.pkg_reason := p_reason;
3319: igs_en_su_attempt_pkg.pkg_source_of_drop := p_source_of_drop;
3320: NULL;
3321: END drop_notif_variable;

Line 3318: igs_en_su_attempt_pkg.pkg_reason := p_reason;

3314: */
3315: BEGIN
3316: igs_en_su_attempt_pkg.pkg_reason := NULL;
3317: igs_en_su_attempt_pkg.pkg_source_of_drop :=NULL;
3318: igs_en_su_attempt_pkg.pkg_reason := p_reason;
3319: igs_en_su_attempt_pkg.pkg_source_of_drop := p_source_of_drop;
3320: NULL;
3321: END drop_notif_variable;
3322:

Line 3319: igs_en_su_attempt_pkg.pkg_source_of_drop := p_source_of_drop;

3315: BEGIN
3316: igs_en_su_attempt_pkg.pkg_reason := NULL;
3317: igs_en_su_attempt_pkg.pkg_source_of_drop :=NULL;
3318: igs_en_su_attempt_pkg.pkg_reason := p_reason;
3319: igs_en_su_attempt_pkg.pkg_source_of_drop := p_source_of_drop;
3320: NULL;
3321: END drop_notif_variable;
3322:
3323: PROCEDURE ENRP_CHK_DEL_SUB_UNITS(

Line 3378: SELECT sua.rowid,sua.* from igs_en_su_attempt sua

3374: p_uoo_id IN NUMBER) AS
3375: --local procedure to update the unit attempt to drop
3376: --fetch the unit attempts for the student and program in context
3377: CURSOR c_sua_rec IS
3378: SELECT sua.rowid,sua.* from igs_en_su_attempt sua
3379: WHERE person_id = p_person_id
3380: AND course_cd = p_course_cd
3381: AND uoo_id = p_uoo_id;
3382:

Line 3389: igs_en_su_attempt_pkg.delete_row(v_sua_rec.row_id);

3385:
3386: FOR v_sua_rec IN c_sua_rec LOOP
3387: --phisically delelte if sua status is "unconfirm"
3388: IF v_sua_rec.unit_attempt_status = 'UNCONFIRM' THEN
3389: igs_en_su_attempt_pkg.delete_row(v_sua_rec.row_id);
3390:
3391: --update to dropped if status is invalid
3392:
3393: ELSIF v_sua_rec.unit_attempt_status = 'INVALID' THEN

Line 3537: || ' FROM IGS_EN_SU_ATTEMPT SUA '

3533: --the records are ordered by the superior unit code so that the
3534: --subordinate units are returned first since a superior unit will have a null value for SUP_UNIT_CD.
3535:
3536: v_select_stmt := ' SELECT SUA.UOO_ID, SUA.SUP_UNIT_CD '
3537: || ' FROM IGS_EN_SU_ATTEMPT SUA '
3538: || ' WHERE SUA.PERSON_ID = :1 '
3539: || ' AND SUA.COURSE_CD = :2 '
3540: || ' AND SUA.UNIT_ATTEMPT_STATUS NOT IN (''DROPPED'',''DISCONTIN'',''COMPLETED'') '
3541: || ' AND (( SUA.UOO_ID IN (' || P_SELECTED_UOO_IDS || ') )'

Line 3637: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;

3633: l_acad_end_dt igs_ca_inst.end_dt%type;
3634: l_alternate_code igs_ca_inst.alternate_code%type;
3635: l_acad_message varchar2(100);
3636: l_message VARCHAR2(1200);
3637: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;
3638: l_return_status VARCHAR2(10);
3639: l_dummy1 VARCHAR2(200);
3640:
3641: BEGIN

Line 3802: FROM IGS_EN_SU_ATTEMPT_ALL su

3798: Cursor cur_grading(cp_person_id NUMBER,
3799: cp_course_cd VARCHAR2,
3800: cp_uoo_id NUMBER) IS
3801: SELECT su.ROWID , su.*
3802: FROM IGS_EN_SU_ATTEMPT_ALL su
3803: WHERE person_id = cp_person_id
3804: AND course_cd = cp_course_cd
3805: AND uoo_id = cp_uoo_id;
3806:

Line 3813: -- select unit attempt and call update row using IGS_EN_SU_ATTEMPT_PKG

3809: l_enc_message_name VARCHAR2(2000);
3810: l_app_short_name VARCHAR2(10);
3811: l_msg_index NUMBER;
3812: BEGIN
3813: -- select unit attempt and call update row using IGS_EN_SU_ATTEMPT_PKG
3814: OPEN cur_grading(p_person_id,p_course_cd,p_uoo_id);
3815: FETCH cur_grading INTO l_data;
3816: IF cur_grading%FOUND THEN
3817: igs_en_su_attempt_pkg.update_row (

Line 3817: igs_en_su_attempt_pkg.update_row (

3813: -- select unit attempt and call update row using IGS_EN_SU_ATTEMPT_PKG
3814: OPEN cur_grading(p_person_id,p_course_cd,p_uoo_id);
3815: FETCH cur_grading INTO l_data;
3816: IF cur_grading%FOUND THEN
3817: igs_en_su_attempt_pkg.update_row (
3818: x_rowid => l_data.rowid,
3819: x_person_id => l_data.person_id,
3820: x_course_cd => l_data.course_cd,
3821: x_unit_cd => l_data.unit_cd,

Line 3933: FROM IGS_EN_SU_ATTEMPT_ALL su

3929: CURSOR cur_credit(cp_person_id NUMBER,
3930: cp_course_cd VARCHAR2,
3931: cp_uoo_id NUMBER) IS
3932: SELECT su.ROWID, su.*
3933: FROM IGS_EN_SU_ATTEMPT_ALL su
3934: WHERE person_id = cp_person_id
3935: AND course_cd = cp_course_cd
3936: AND uoo_id = cp_uoo_id;
3937: l_rowid VARCHAR2(25);

Line 3966: igs_en_su_attempt_pkg.update_row (

3962: OPEN cur_credit(p_person_id,p_course_cd,p_uoo_id);
3963: FETCH cur_credit INTO l_data;
3964:
3965: IF cur_credit%FOUND THEN
3966: igs_en_su_attempt_pkg.update_row (
3967: x_rowid => l_data.rowid,
3968: x_person_id => l_data.person_id,
3969: x_course_cd => l_data.course_cd,
3970: x_unit_cd => l_data.unit_cd,

Line 4090: FROM igs_en_su_attempt

4086: AND uoo.uoo_id = p_uoo_id;
4087:
4088: CURSOR c_audit_sua IS
4089: SELECT COUNT(*)
4090: FROM igs_en_su_attempt
4091: WHERE uoo_id=p_uoo_id
4092: AND no_assessment_ind = 'Y'
4093: AND unit_attempt_status IN ('ENROLLED', 'COMPLETED','INVALID','UNCONFIRM' ) ;
4094:

Line 4140: FROM IGS_EN_SU_ATTEMPT_ALL su

4136: CURSOR cur_grading(cp_person_id NUMBER,
4137: cp_course_cd VARCHAR2,
4138: cp_uoo_id NUMBER) IS
4139: SELECT su.ROWID , su.*
4140: FROM IGS_EN_SU_ATTEMPT_ALL su
4141: WHERE person_id = cp_person_id
4142: AND course_cd = cp_course_cd
4143: AND uoo_id = cp_uoo_id;
4144:

Line 4174: l_override_eftsu igs_en_su_attempt.override_eftsu%type;

4170: l_categories VARCHAR2(255);
4171: l_enc_message_name VARCHAR2(2000);
4172: l_app_short_name VARCHAR2(10);
4173: l_msg_index NUMBER;
4174: l_override_eftsu igs_en_su_attempt.override_eftsu%type;
4175: l_override_enrolled_cp igs_en_su_attempt.override_enrolled_cp%TYPE;
4176: l_override_credit_reason igs_en_su_attempt.override_outcome_due_dt%TYPE;
4177: l_override_cp igs_en_su_attempt.override_enrolled_cp%TYPE;
4178:

Line 4175: l_override_enrolled_cp igs_en_su_attempt.override_enrolled_cp%TYPE;

4171: l_enc_message_name VARCHAR2(2000);
4172: l_app_short_name VARCHAR2(10);
4173: l_msg_index NUMBER;
4174: l_override_eftsu igs_en_su_attempt.override_eftsu%type;
4175: l_override_enrolled_cp igs_en_su_attempt.override_enrolled_cp%TYPE;
4176: l_override_credit_reason igs_en_su_attempt.override_outcome_due_dt%TYPE;
4177: l_override_cp igs_en_su_attempt.override_enrolled_cp%TYPE;
4178:
4179: BEGIN

Line 4176: l_override_credit_reason igs_en_su_attempt.override_outcome_due_dt%TYPE;

4172: l_app_short_name VARCHAR2(10);
4173: l_msg_index NUMBER;
4174: l_override_eftsu igs_en_su_attempt.override_eftsu%type;
4175: l_override_enrolled_cp igs_en_su_attempt.override_enrolled_cp%TYPE;
4176: l_override_credit_reason igs_en_su_attempt.override_outcome_due_dt%TYPE;
4177: l_override_cp igs_en_su_attempt.override_enrolled_cp%TYPE;
4178:
4179: BEGIN
4180: IF p_no_assessment_ind = 'N' THEN

Line 4177: l_override_cp igs_en_su_attempt.override_enrolled_cp%TYPE;

4173: l_msg_index NUMBER;
4174: l_override_eftsu igs_en_su_attempt.override_eftsu%type;
4175: l_override_enrolled_cp igs_en_su_attempt.override_enrolled_cp%TYPE;
4176: l_override_credit_reason igs_en_su_attempt.override_outcome_due_dt%TYPE;
4177: l_override_cp igs_en_su_attempt.override_enrolled_cp%TYPE;
4178:
4179: BEGIN
4180: IF p_no_assessment_ind = 'N' THEN
4181: l_override_cp := NULL ;

Line 4351: -- select unit attempt and call update row using IGS_EN_SU_ATTEMPT_PKG

4347:
4348: OPEN c_crs_ver;
4349: FETCH c_crs_ver INTO l_crs_ver;
4350: CLOSE c_crs_ver;
4351: -- select unit attempt and call update row using IGS_EN_SU_ATTEMPT_PKG
4352: OPEN cur_grading(p_person_id,p_course_cd,p_uoo_id);
4353: FETCH cur_grading INTO l_data;
4354: IF cur_grading%FOUND THEN
4355:

Line 4366: igs_en_su_attempt_pkg.update_row (

4362: l_override_eftsu := l_data.override_eftsu ;
4363: l_override_credit_reason := l_data.override_credit_reason ;
4364: END IF;
4365:
4366: igs_en_su_attempt_pkg.update_row (
4367: x_rowid => l_data.rowid,
4368: x_person_id => l_data.person_id,
4369: x_course_cd => l_data.course_cd,
4370: x_unit_cd => l_data.unit_cd,

Line 4561: FROM IGS_EN_SU_ATTEMPT_ALL su

4557: CURSOR cur_core_ind(p_person_id NUMBER,
4558: p_course_cd VARCHAR2,
4559: p_uoo_id NUMBER) IS
4560: SELECT su.ROWID, su.*
4561: FROM IGS_EN_SU_ATTEMPT_ALL su
4562: WHERE person_id = p_person_id
4563: AND course_cd = p_course_cd
4564: AND uoo_id = p_uoo_id;
4565:

Line 4568: l_core_indicator igs_en_su_attempt_all.core_indicator_code%TYPE;

4564: AND uoo_id = p_uoo_id;
4565:
4566: l_rowid VARCHAR2(25);
4567: l_data cur_core_ind%ROWTYPE;
4568: l_core_indicator igs_en_su_attempt_all.core_indicator_code%TYPE;
4569: l_enc_message_name VARCHAR2(2000);
4570: l_app_short_name VARCHAR2(10);
4571: l_msg_index NUMBER;
4572: BEGIN

Line 4577: -- select unit attempt and call update row using IGS_EN_SU_ATTEMPT_PKG

4573: SAVEPOINT update_core_indicator;
4574:
4575: l_core_indicator := p_core_indicator;
4576:
4577: -- select unit attempt and call update row using IGS_EN_SU_ATTEMPT_PKG
4578: OPEN cur_core_ind(p_person_id, p_program_cd, p_uoo_id);
4579: FETCH cur_core_ind INTO l_data;
4580: CLOSE cur_core_ind;
4581:

Line 4586: -- make call to update_row of IGS_EN_SU_ATTEMPT_PKG to update core indicator code value l_core_indicator

4582: -- IF length(l_core_indicator)=0 THEN
4583: -- l_core_indicator := p_core_indicator;
4584: -- END IF;
4585:
4586: -- make call to update_row of IGS_EN_SU_ATTEMPT_PKG to update core indicator code value l_core_indicator
4587: Igs_En_Su_Attempt_Pkg.update_row(
4588: x_rowid =>l_data.ROWID,
4589: x_person_id =>l_data.person_id,
4590: x_course_cd =>l_data.course_cd,

Line 4587: Igs_En_Su_Attempt_Pkg.update_row(

4583: -- l_core_indicator := p_core_indicator;
4584: -- END IF;
4585:
4586: -- make call to update_row of IGS_EN_SU_ATTEMPT_PKG to update core indicator code value l_core_indicator
4587: Igs_En_Su_Attempt_Pkg.update_row(
4588: x_rowid =>l_data.ROWID,
4589: x_person_id =>l_data.person_id,
4590: x_course_cd =>l_data.course_cd,
4591: x_unit_cd =>l_data.unit_cd,

Line 4710: FROM igs_en_su_attempt_all sua

4706:
4707: --cursor to get the rowid for the unit attempt of the student
4708: CURSOR cur_unit(p_person_id NUMBER, p_course_cd VARCHAR2, p_uoo_id IN NUMBER) IS
4709: SELECT sua.ROWID
4710: FROM igs_en_su_attempt_all sua
4711: WHERE sua.person_id = p_person_id
4712: AND sua.course_cd = p_course_cd
4713: AND sua.uoo_id = p_uoo_id;
4714:

Line 4808: IF p_uoo_id IS NOT NULL AND p_table = 'IGS_EN_SU_ATTEMPT_ALL' THEN

4804:
4805: l_unit_rowid := NULL;
4806:
4807: -- get the unit attempt rowid
4808: IF p_uoo_id IS NOT NULL AND p_table = 'IGS_EN_SU_ATTEMPT_ALL' THEN
4809: -- get the row id for unit attempt
4810: OPEN cur_unit(p_person_id,p_course_cd,p_uoo_id);
4811: FETCH cur_unit INTO l_unit_rowid;
4812: CLOSE cur_unit;

Line 4820: p_tab_name => 'IGS_EN_SU_ATTEMPT_ALL',

4816: --Checking for unit Updates
4817: IF (l_unit_rowid IS NOT NULL) THEN
4818: -- check for update permission on the table student unit attempt
4819: l_sec_out := Igs_sc_gen_001.check_sel_upd_del_security(
4820: p_tab_name => 'IGS_EN_SU_ATTEMPT_ALL',
4821: p_rowid => l_unit_rowid,
4822: p_action => 'U',
4823: p_msg_data => l_msg_data);
4824:

Line 4828: p_message := 'IGS_SC_PRE_CHECK_EXCEP'||l_msg_data||'IGS_EN_SU_ATTEMPT_ALL*U';

4824:
4825: IF NOT l_sec_out THEN
4826: p_message := 'IGS_SC_NO_ACCESS_PRIV';
4827: IF l_msg_data IS NOT NULL THEN
4828: p_message := 'IGS_SC_PRE_CHECK_EXCEP*'||l_msg_data||'*IGS_EN_SU_ATTEMPT_ALL*U';
4829: END IF;
4830: RETURN;
4831: END IF;
4832:

Line 4851: FROM igs_en_su_attempt

4847: p_course_cd IN VARCHAR2,
4848: p_uoo_id IN NUMBER)
4849: IS
4850: SELECT *
4851: FROM igs_en_su_attempt
4852: WHERE person_id = p_person_id
4853: AND course_cd = p_course_cd
4854: AND uoo_id = p_uoo_id;
4855:

Line 4862: IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW( -- calling the TBH

4858:
4859: OPEN c_sua(p_person_id, p_course_cd, p_uoo_id);
4860: FETCH c_sua INTO l_sua_rec;
4861: IF c_sua%FOUND THEN
4862: IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW( -- calling the TBH
4863: X_ROWID => l_sua_rec.ROW_ID,
4864: X_PERSON_ID => l_sua_rec.PERSON_ID,
4865: X_COURSE_CD => l_sua_rec.COURSE_CD ,
4866: X_UNIT_CD => l_sua_rec.UNIT_CD,

Line 4971: SELECT 'X' FROM igs_en_su_attempt sua

4967: FUNCTION check_sua_exists(p_person_id IN NUMBER,
4968: p_uoo_id IN NUMBER,
4969: p_course_cd IN VARCHAR2) return varchar2 as
4970: CURSOR cur_sua_exists is
4971: SELECT 'X' FROM igs_en_su_attempt sua
4972: WHERE sua.person_id = p_person_id
4973: AND sua.course_Cd = p_course_cd
4974: AND sua.uoo_id = p_uoo_id;
4975:

Line 5012: FROM igs_en_su_attempt sua,

5008: -------------------------------------------------------------------
5009:
5010: CURSOR c_chk_cart_units IS
5011: SELECT 'x'
5012: FROM igs_en_su_attempt sua,
5013: igs_ca_teach_to_load_v ltt
5014: WHERE sua.person_id = p_person_id
5015: AND sua.course_cd = p_course_cd
5016: AND sua.unit_attempt_status = 'UNCONFIRM'