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

Line 8: CURSOR C_SUA_lock (cp_person_id igs_en_su_attempt_all.person_id%TYPE,

4: --package variables
5: g_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6:
7:
8: CURSOR C_SUA_lock (cp_person_id igs_en_su_attempt_all.person_id%TYPE,
9: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
10: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
11: SELECT unit_attempt_status
12: FROM IGS_EN_SU_ATTEMPT_ALL sua

Line 9: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,

5: g_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6:
7:
8: CURSOR C_SUA_lock (cp_person_id igs_en_su_attempt_all.person_id%TYPE,
9: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
10: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
11: SELECT unit_attempt_status
12: FROM IGS_EN_SU_ATTEMPT_ALL sua
13: WHERE person_id = cp_person_id AND

Line 10: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS

6:
7:
8: CURSOR C_SUA_lock (cp_person_id igs_en_su_attempt_all.person_id%TYPE,
9: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
10: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
11: SELECT unit_attempt_status
12: FROM IGS_EN_SU_ATTEMPT_ALL sua
13: WHERE person_id = cp_person_id AND
14: course_cd = cp_course_cd AND

Line 12: FROM IGS_EN_SU_ATTEMPT_ALL sua

8: CURSOR C_SUA_lock (cp_person_id igs_en_su_attempt_all.person_id%TYPE,
9: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
10: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
11: SELECT unit_attempt_status
12: FROM IGS_EN_SU_ATTEMPT_ALL sua
13: WHERE person_id = cp_person_id AND
14: course_cd = cp_course_cd AND
15: uoo_id = cp_uoo_id
16: FOR UPDATE NOWAIT;

Line 21: p_person_id IN igs_en_su_attempt.person_id%TYPE,

17: l_lock_rec C_SUA_lock%ROWTYPE;
18:
19:
20: FUNCTION is_unit_subordinate(
21: p_person_id IN igs_en_su_attempt.person_id%TYPE,
22: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
23: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
24: p_drop_alluoo_ids IN VARCHAR2
25: ) RETURN VARCHAR2 AS

Line 22: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

18:
19:
20: FUNCTION is_unit_subordinate(
21: p_person_id IN igs_en_su_attempt.person_id%TYPE,
22: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
23: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
24: p_drop_alluoo_ids IN VARCHAR2
25: ) RETURN VARCHAR2 AS
26:

Line 23: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,

19:
20: FUNCTION is_unit_subordinate(
21: p_person_id IN igs_en_su_attempt.person_id%TYPE,
22: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
23: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
24: p_drop_alluoo_ids IN VARCHAR2
25: ) RETURN VARCHAR2 AS
26:
27: -------------------------------------------------------------------------------------------

Line 36: l_sup_unitcd igs_en_su_attempt.sup_unit_cd%TYPE;

32: --Who When What
33: -------------------------------------------------------------------------------------------
34:
35: l_sub_unit VARCHAR2(1);
36: l_sup_unitcd igs_en_su_attempt.sup_unit_cd%TYPE;
37: l_sup_version igs_en_su_attempt.sup_version_number%TYPE;
38:
39: TYPE c_ref_cursor IS REF CURSOR;
40: c_chk_is_sub c_ref_cursor;

Line 37: l_sup_version igs_en_su_attempt.sup_version_number%TYPE;

33: -------------------------------------------------------------------------------------------
34:
35: l_sub_unit VARCHAR2(1);
36: l_sup_unitcd igs_en_su_attempt.sup_unit_cd%TYPE;
37: l_sup_version igs_en_su_attempt.sup_version_number%TYPE;
38:
39: TYPE c_ref_cursor IS REF CURSOR;
40: c_chk_is_sub c_ref_cursor;
41:

Line 47: FROM igs_en_su_attempt sua

43: BEGIN
44: --modified sqlquery for bug 5037726,sqlid :14792699
45: OPEN c_chk_is_sub FOR
46: 'SELECT sua.sup_unit_cd ,sua.sup_version_number
47: FROM igs_en_su_attempt sua
48: WHERE sua.uoo_id =:1
49: AND sua.person_id =:2
50: AND sua.course_cd =:3
51: AND EXISTS

Line 83: p_person_id IN igs_en_su_attempt.person_id%TYPE,

79: END is_unit_subordinate;
80:
81:
82: PROCEDURE drop_units(
83: p_person_id IN igs_en_su_attempt.person_id%TYPE,
84: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
85: p_course_version IN igs_en_stdnt_ps_att.version_number%TYPE,
86: p_start_uoo_id IN NUMBER,
87: p_drop_alluoo_ids IN VARCHAR2,

Line 84: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

80:
81:
82: PROCEDURE drop_units(
83: p_person_id IN igs_en_su_attempt.person_id%TYPE,
84: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
85: p_course_version IN igs_en_stdnt_ps_att.version_number%TYPE,
86: p_start_uoo_id IN NUMBER,
87: p_drop_alluoo_ids IN VARCHAR2,
88: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,

Line 124: v_ref_cur_rec igs_en_su_attempt%ROWTYPE;

120:
121:
122: TYPE c_ref_cursor IS REF CURSOR;
123: c_ref_cur_coreq_prereq c_ref_cursor;
124: v_ref_cur_rec igs_en_su_attempt%ROWTYPE;
125:
126: l_drop_alluoo_ids VARCHAR2(1000);
127: l_message VARCHAR2(200);
128: l_eftsu_total igs_en_su_attempt.override_eftsu%TYPE;

Line 128: l_eftsu_total igs_en_su_attempt.override_eftsu%TYPE;

124: v_ref_cur_rec igs_en_su_attempt%ROWTYPE;
125:
126: l_drop_alluoo_ids VARCHAR2(1000);
127: l_message VARCHAR2(200);
128: l_eftsu_total igs_en_su_attempt.override_eftsu%TYPE;
129: l_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE;
130: l_total_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE;
131:
132: l_coreq_failed_uoo_ids VARCHAR2(1000);

Line 129: l_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE;

125:
126: l_drop_alluoo_ids VARCHAR2(1000);
127: l_message VARCHAR2(200);
128: l_eftsu_total igs_en_su_attempt.override_eftsu%TYPE;
129: l_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE;
130: l_total_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE;
131:
132: l_coreq_failed_uoo_ids VARCHAR2(1000);
133: l_prereq_failed_uoo_ids VARCHAR2(1000);

Line 130: l_total_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE;

126: l_drop_alluoo_ids VARCHAR2(1000);
127: l_message VARCHAR2(200);
128: l_eftsu_total igs_en_su_attempt.override_eftsu%TYPE;
129: l_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE;
130: l_total_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE;
131:
132: l_coreq_failed_uoo_ids VARCHAR2(1000);
133: l_prereq_failed_uoo_ids VARCHAR2(1000);
134:

Line 138: l_uoo_id igs_en_su_attempt.uoo_id%TYPE;

134:
135: l_message_name VARCHAR2(50);
136:
137: l_att_typ_failed BOOLEAN;
138: l_uoo_id igs_en_su_attempt.uoo_id%TYPE;
139: l_sub_unit VARCHAR2(1);
140:
141: -- cursor to get unit details
142: CURSOR get_unit_dtls (p_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS

Line 142: CURSOR get_unit_dtls (p_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS

138: l_uoo_id igs_en_su_attempt.uoo_id%TYPE;
139: l_sub_unit VARCHAR2(1);
140:
141: -- cursor to get unit details
142: CURSOR get_unit_dtls (p_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
143: SELECT unit_cd||'/'||unit_class unit_det
144: FROM igs_ps_unit_ofr_opt
145: WHERE uoo_id = p_uoo_id ;
146:

Line 167: 'SELECT U.* FROM IGS_EN_SU_ATTEMPT U, IGS_CA_LOAD_TO_TEACH_V V

163:
164: -- cursor to get all uooids with enrolled,invalid status and not in dropped list
165: --modified sqlquery for bug 5037726,sqlid : 14792726
166: OPEN c_ref_cur_coreq_prereq FOR
167: 'SELECT U.* FROM IGS_EN_SU_ATTEMPT U, IGS_CA_LOAD_TO_TEACH_V V
168: WHERE U.person_id = :1
169: AND U.course_cd = :2
170: AND U.unit_attempt_status IN (''ENROLLED'',''INVALID'')
171: AND U.uoo_id NOT IN ('||p_drop_alluoo_ids||')

Line 462: 'SELECT U.* FROM IGS_EN_SU_ATTEMPT U, igs_ca_load_to_teach_v V

458:
459: END LOOP; --end of WHILE l_drop_alluoo_ids LOOP
460: --modified sqlquery for bug 5037726,sql id :14792727
461: OPEN c_ref_cur_coreq_prereq FOR
462: 'SELECT U.* FROM IGS_EN_SU_ATTEMPT U, igs_ca_load_to_teach_v V
463: WHERE U.person_id = :1
464: AND U.course_cd = :2
465: AND U.unit_attempt_status IN (''ENROLLED'',''INVALID'')
466: AND U.uoo_id NOT IN ('||p_drop_alluoo_ids||')

Line 661: p_person_id IN igs_en_su_attempt.person_id%TYPE,

657:
658:
659:
660: PROCEDURE drop_student_unit_attempts(
661: p_person_id IN igs_en_su_attempt.person_id%TYPE,
662: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
663: p_course_version IN igs_en_stdnt_ps_att.version_number%TYPE,
664: p_start_uoo_id IN NUMBER,
665: p_drop_uoo_ids IN VARCHAR2,

Line 662: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

658:
659:
660: PROCEDURE drop_student_unit_attempts(
661: p_person_id IN igs_en_su_attempt.person_id%TYPE,
662: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
663: p_course_version IN igs_en_stdnt_ps_att.version_number%TYPE,
664: p_start_uoo_id IN NUMBER,
665: p_drop_uoo_ids IN VARCHAR2,
666: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,

Line 706: v_ref_cur_rec igs_en_su_attempt%ROWTYPE;

702: TYPE c_ref_cursor IS REF CURSOR;
703: c_chk_units c_ref_cursor;
704: c_ref_only_dup c_ref_cursor;
705: c_chk_is_sub c_ref_cursor;
706: v_ref_cur_rec igs_en_su_attempt%ROWTYPE;
707:
708: l_all_units_for_drop BOOLEAN;
709:
710: l_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE;

Line 710: l_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE;

706: v_ref_cur_rec igs_en_su_attempt%ROWTYPE;
707:
708: l_all_units_for_drop BOOLEAN;
709:
710: l_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE;
711: l_uoo_id igs_en_su_attempt.uoo_id%TYPE;
712: l_sub_unit VARCHAR2(1);
713:
714: l_enc_message_name VARCHAR2(2000);

Line 711: l_uoo_id igs_en_su_attempt.uoo_id%TYPE;

707:
708: l_all_units_for_drop BOOLEAN;
709:
710: l_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE;
711: l_uoo_id igs_en_su_attempt.uoo_id%TYPE;
712: l_sub_unit VARCHAR2(1);
713:
714: l_enc_message_name VARCHAR2(2000);
715: l_app_short_name VARCHAR2(100);

Line 744: 'SELECT U.* FROM IGS_EN_SU_ATTEMPT U

740: --in which case, just delete all units w/o checking cp or coreq requirements.
741: --modified sqlquery for bug 5037726 ,sql id :14792729
742:
743: OPEN c_chk_units FOR
744: 'SELECT U.* FROM IGS_EN_SU_ATTEMPT U
745: WHERE person_id =:1
746: AND course_cd = :2
747: AND unit_attempt_status IN (''ENROLLED'',''INVALID'',''WAITLISTED'')
748: AND (cal_type,ci_sequence_number) IN

Line 773: 'SELECT U.* FROM IGS_EN_SU_ATTEMPT U

769: -- not perform any validations. So that we do not get any min cp or
770: -- attendance type validation fialures.
771: --modified sqlquery for bug 5037726
772: OPEN c_ref_only_dup FOR
773: 'SELECT U.* FROM IGS_EN_SU_ATTEMPT U
774: WHERE person_id =:1
775: AND course_cd = :2
776: AND unit_attempt_status <> ''DUPLICATE''
777: AND (cal_type,ci_sequence_number) IN

Line 923: p_person_id IN igs_en_su_attempt.person_id%TYPE,

919: END drop_student_unit_attempts;
920:
921:
922: PROCEDURE reorder_drop_units(
923: p_person_id IN igs_en_su_attempt.person_id%TYPE,
924: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
925: p_start_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
926: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
927: p_load_ci_seq_num IN igs_ca_inst.sequence_number%TYPE,

Line 924: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

920:
921:
922: PROCEDURE reorder_drop_units(
923: p_person_id IN igs_en_su_attempt.person_id%TYPE,
924: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
925: p_start_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
926: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
927: p_load_ci_seq_num IN igs_ca_inst.sequence_number%TYPE,
928: p_selected_uoo_ids IN VARCHAR2,

Line 925: p_start_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,

921:
922: PROCEDURE reorder_drop_units(
923: p_person_id IN igs_en_su_attempt.person_id%TYPE,
924: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
925: p_start_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
926: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
927: p_load_ci_seq_num IN igs_ca_inst.sequence_number%TYPE,
928: p_selected_uoo_ids IN VARCHAR2,
929: p_ret_all_uoo_ids OUT NOCOPY VARCHAR2,

Line 945: CURSOR get_unit_dtls (p_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS

941:
942:
943:
944: -- cursor to get unit details
945: CURSOR get_unit_dtls (p_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
946: SELECT unit_cd||'/'||unit_class unit_det
947: FROM igs_ps_unit_ofr_opt
948: WHERE uoo_id = p_uoo_id ;
949:

Line 970: ( SELECT uoo_id FROM igs_en_su_attempt

966: FROM igs_ps_unit_ofr_opt uoo
967: WHERE uoo.sup_uoo_id IN ('||p_selected_uoo_ids||')
968: AND uoo.RELATION_TYPE = ''SUBORDINATE''
969: AND uoo.uoo_id IN
970: ( SELECT uoo_id FROM igs_en_su_attempt
971: WHERE person_id = :1
972: AND course_cd = :2
973: AND cal_type = uoo.cal_type
974: AND ci_sequence_number = uoo.ci_sequence_number

Line 1074: p_person_id IN igs_en_su_attempt.person_id%TYPE,

1070: END reorder_drop_units;
1071:
1072:
1073: PROCEDURE create_ss_warning (
1074: p_person_id IN igs_en_su_attempt.person_id%TYPE,
1075: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
1076: p_term_cal_type IN igs_ca_inst.cal_type%TYPE,
1077: p_term_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1078: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,

Line 1075: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,

1071:
1072:
1073: PROCEDURE create_ss_warning (
1074: p_person_id IN igs_en_su_attempt.person_id%TYPE,
1075: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
1076: p_term_cal_type IN igs_ca_inst.cal_type%TYPE,
1077: p_term_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1078: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
1079: p_message_for IN IGS_EN_STD_WARNINGS.message_for%TYPE,

Line 1078: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,

1074: p_person_id IN igs_en_su_attempt.person_id%TYPE,
1075: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
1076: p_term_cal_type IN igs_ca_inst.cal_type%TYPE,
1077: p_term_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1078: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE,
1079: p_message_for IN IGS_EN_STD_WARNINGS.message_for%TYPE,
1080: p_message_icon IN IGS_EN_STD_WARNINGS.message_icon%TYPE,
1081: p_message_name IN IGS_EN_STD_WARNINGS.message_name%TYPE,
1082: p_message_rule_text IN VARCHAR2,

Line 1599: igs_en_su_attempt_pkg.pkg_source_of_drop := 'DROP';

1595: p_message := NULL;
1596:
1597: -- smaddali 8-dec-2005 added this global variable to bypass update spa,
1598: -- matriculation and reserved seat counts for DROP : bug#4864437
1599: igs_en_su_attempt_pkg.pkg_source_of_drop := 'DROP';
1600:
1601:
1602: -- This loop drop the units passed and in that process collects
1603: -- all the uooids that are failing (prereq/coreq in deny mode) because of dropping

Line 1635: igs_en_su_attempt_pkg.pkg_source_of_drop := NULL;

1631: p_message,
1632: l_return_status);
1633:
1634: IF l_return_status = 'E' AND p_message IS NOT NULL THEN
1635: igs_en_su_attempt_pkg.pkg_source_of_drop := NULL;
1636: p_return_status := 'E';
1637: igs_en_add_units_api.g_ss_session_id := NULL;
1638: RETURN;
1639: END IF;

Line 1655: igs_en_su_attempt_pkg.pkg_source_of_drop := NULL;

1651: l_return_status := NULL;
1652: l_uooids_dropped := NULL;
1653:
1654: END LOOP;
1655: igs_en_su_attempt_pkg.pkg_source_of_drop := NULL;
1656: igs_en_add_units_api.g_ss_session_id := NULL;
1657:
1658: EXCEPTION
1659: WHEN NO_AUSL_RECORD_FOUND THEN

Line 1660: igs_en_su_attempt_pkg.pkg_source_of_drop := NULL;

1656: igs_en_add_units_api.g_ss_session_id := NULL;
1657:
1658: EXCEPTION
1659: WHEN NO_AUSL_RECORD_FOUND THEN
1660: igs_en_su_attempt_pkg.pkg_source_of_drop := NULL;
1661: igs_en_add_units_api.g_ss_session_id := NULL;
1662: p_message := 'IGS_SS_CANTDET_ADM_UNT_STATUS';
1663: p_return_status := 'E';
1664: RETURN;

Line 1667: igs_en_su_attempt_pkg.pkg_source_of_drop := NULL;

1663: p_return_status := 'E';
1664: RETURN;
1665:
1666: WHEN resource_busy THEN
1667: igs_en_su_attempt_pkg.pkg_source_of_drop := NULL;
1668: igs_en_add_units_api.g_ss_session_id := NULL;
1669: p_message := 'IGS_GE_RECORD_LOCKED';
1670: p_return_status := 'E';
1671: RETURN;

Line 1674: igs_en_su_attempt_pkg.pkg_source_of_drop := NULL;

1670: p_return_status := 'E';
1671: RETURN;
1672:
1673: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
1674: igs_en_su_attempt_pkg.pkg_source_of_drop := NULL;
1675: igs_en_add_units_api.g_ss_session_id := NULL;
1676: IGS_GE_MSG_STACK.GET(-1, 'T', l_enc_message_name, l_msg_index);
1677: FND_MESSAGE.PARSE_ENCODED(l_enc_message_name,l_app_short_name,l_message_name);
1678: l_token := FND_MESSAGE.GET_TOKEN('LIST',NULL);

Line 1687: igs_en_su_attempt_pkg.pkg_source_of_drop := NULL;

1683: p_message := l_message_name;
1684: RETURN;
1685:
1686: WHEN OTHERS THEN
1687: igs_en_su_attempt_pkg.pkg_source_of_drop := NULL;
1688: igs_en_add_units_api.g_ss_session_id := NULL;
1689: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1690: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_DROP_UNITS_API.drop_ss_unit_attempt');
1691: IGS_GE_MSG_STACK.ADD;

Line 1702: p_person_id igs_en_su_attempt.person_id%TYPE,

1698: END drop_ss_unit_attempt;
1699:
1700:
1701: FUNCTION update_dropped_units (
1702: p_person_id igs_en_su_attempt.person_id%TYPE,
1703: p_course_cd igs_en_su_attempt.course_cd%TYPE,
1704: p_uoo_ids VARCHAR2,
1705: p_discontinuation_reason_cd VARCHAR2 )
1706: RETURN VARCHAR2 AS

Line 1703: p_course_cd igs_en_su_attempt.course_cd%TYPE,

1699:
1700:
1701: FUNCTION update_dropped_units (
1702: p_person_id igs_en_su_attempt.person_id%TYPE,
1703: p_course_cd igs_en_su_attempt.course_cd%TYPE,
1704: p_uoo_ids VARCHAR2,
1705: p_discontinuation_reason_cd VARCHAR2 )
1706: RETURN VARCHAR2 AS
1707: BEGIN

Line 1714: p_person_id igs_en_su_attempt.person_id%TYPE,

1710:
1711: END update_dropped_units;
1712:
1713: FUNCTION update_dropped_units (
1714: p_person_id igs_en_su_attempt.person_id%TYPE,
1715: p_course_cd igs_en_su_attempt.course_cd%TYPE,
1716: p_uoo_ids VARCHAR2,
1717: p_discontinuation_reason_cd VARCHAR2,
1718: p_admin_unit_status VARCHAR2)

Line 1715: p_course_cd igs_en_su_attempt.course_cd%TYPE,

1711: END update_dropped_units;
1712:
1713: FUNCTION update_dropped_units (
1714: p_person_id igs_en_su_attempt.person_id%TYPE,
1715: p_course_cd igs_en_su_attempt.course_cd%TYPE,
1716: p_uoo_ids VARCHAR2,
1717: p_discontinuation_reason_cd VARCHAR2,
1718: p_admin_unit_status VARCHAR2)
1719: RETURN VARCHAR2 AS

Line 1726: upd_units_rec igs_en_su_attempt%ROWTYPE;

1722:
1723: TYPE c_ref_cursor IS REF CURSOR;
1724: c_upd_units c_ref_cursor;
1725:
1726: upd_units_rec igs_en_su_attempt%ROWTYPE;
1727: l_admin_unit_status igs_en_su_attempt.administrative_unit_status%TYPE;
1728: BEGIN
1729: --check that the uoo_ids list to be modified is not null
1730:

Line 1727: l_admin_unit_status igs_en_su_attempt.administrative_unit_status%TYPE;

1723: TYPE c_ref_cursor IS REF CURSOR;
1724: c_upd_units c_ref_cursor;
1725:
1726: upd_units_rec igs_en_su_attempt%ROWTYPE;
1727: l_admin_unit_status igs_en_su_attempt.administrative_unit_status%TYPE;
1728: BEGIN
1729: --check that the uoo_ids list to be modified is not null
1730:
1731: IF p_uoo_ids IS NULL THEN

Line 1739: 'SELECT sua.* FROM igs_En_su_attempt sua

1735: END IF;
1736:
1737: --modified sqlquery for bug 5037726,sql id : 14792801
1738: OPEN c_upd_units FOR
1739: 'SELECT sua.* FROM igs_En_su_attempt sua
1740: WHERE person_id = :1
1741: AND course_cd = :2
1742: AND uoo_id IN ('||p_uoo_ids||')' USING p_person_id,p_course_cd ;
1743:

Line 1757: igs_En_su_Attempt_pkg.update_row( X_ROWID => upd_units_rec.row_id ,

1753: l_admin_unit_status := p_admin_unit_status;
1754: END IF;
1755:
1756: -- Call update_row of the student unit attempt table handler i.e
1757: igs_En_su_Attempt_pkg.update_row( X_ROWID => upd_units_rec.row_id ,
1758: X_PERSON_ID => upd_units_rec.person_id ,
1759: X_COURSE_CD => upd_units_rec.course_cd ,
1760: X_UNIT_CD => upd_units_rec.unit_cd ,
1761: X_CAL_TYPE => upd_units_rec.cal_type ,