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

Line 292: select sua.rowid,sua.* from IGS_EN_SU_ATTEMPT sua where

288: --Who When What
289: -------------------------------------------------------------------
290:
291: cursor select_sua is
292: select sua.rowid,sua.* from IGS_EN_SU_ATTEMPT sua where
293: PERSON_ID=P_PERSON_ID AND
294: COURSE_CD=P_COURSE_CD AND
295: UOO_ID=P_UOOID ;
296:

Line 307: l_gradingcode IGS_EN_SU_ATTEMPT.GRADING_SCHEMA_CODE%TYPE;

303:
304: old_refsua select_sua%ROWTYPE;
305: old_refplan select_plan%ROWTYPE;
306:
307: l_gradingcode IGS_EN_SU_ATTEMPT.GRADING_SCHEMA_CODE%TYPE;
308: l_gradingver IGS_EN_SU_ATTEMPT.GS_VERSION_NUMBER%TYPE;
309: l_enrolled_cp IGS_EN_SU_ATTEMPT.OVERRIDE_ENROLLED_CP%TYPE;
310: l_no_assessment_ind IGS_EN_SU_ATTEMPT.NO_ASSESSMENT_IND%TYPE;
311:

Line 308: l_gradingver IGS_EN_SU_ATTEMPT.GS_VERSION_NUMBER%TYPE;

304: old_refsua select_sua%ROWTYPE;
305: old_refplan select_plan%ROWTYPE;
306:
307: l_gradingcode IGS_EN_SU_ATTEMPT.GRADING_SCHEMA_CODE%TYPE;
308: l_gradingver IGS_EN_SU_ATTEMPT.GS_VERSION_NUMBER%TYPE;
309: l_enrolled_cp IGS_EN_SU_ATTEMPT.OVERRIDE_ENROLLED_CP%TYPE;
310: l_no_assessment_ind IGS_EN_SU_ATTEMPT.NO_ASSESSMENT_IND%TYPE;
311:
312: -- Internal Procedure to update the Planning Sheet record.

Line 309: l_enrolled_cp IGS_EN_SU_ATTEMPT.OVERRIDE_ENROLLED_CP%TYPE;

305: old_refplan select_plan%ROWTYPE;
306:
307: l_gradingcode IGS_EN_SU_ATTEMPT.GRADING_SCHEMA_CODE%TYPE;
308: l_gradingver IGS_EN_SU_ATTEMPT.GS_VERSION_NUMBER%TYPE;
309: l_enrolled_cp IGS_EN_SU_ATTEMPT.OVERRIDE_ENROLLED_CP%TYPE;
310: l_no_assessment_ind IGS_EN_SU_ATTEMPT.NO_ASSESSMENT_IND%TYPE;
311:
312: -- Internal Procedure to update the Planning Sheet record.
313: PROCEDURE update_plan( p_grd_schm_cd IN VARCHAR2,

Line 310: l_no_assessment_ind IGS_EN_SU_ATTEMPT.NO_ASSESSMENT_IND%TYPE;

306:
307: l_gradingcode IGS_EN_SU_ATTEMPT.GRADING_SCHEMA_CODE%TYPE;
308: l_gradingver IGS_EN_SU_ATTEMPT.GS_VERSION_NUMBER%TYPE;
309: l_enrolled_cp IGS_EN_SU_ATTEMPT.OVERRIDE_ENROLLED_CP%TYPE;
310: l_no_assessment_ind IGS_EN_SU_ATTEMPT.NO_ASSESSMENT_IND%TYPE;
311:
312: -- Internal Procedure to update the Planning Sheet record.
313: PROCEDURE update_plan( p_grd_schm_cd IN VARCHAR2,
314: p_gs_ver IN NUMBER,

Line 346: igs_en_su_attempt_pkg.UPDATE_ROW(

342: p_audit IN VARCHAR2,
343: p_credit IN NUMBER,
344: p_old_refsua select_sua%ROWTYPE) IS
345: BEGIN
346: igs_en_su_attempt_pkg.UPDATE_ROW(
347: X_ROWID => p_old_refsua.rowid,
348: X_PERSON_ID => p_old_refsua.PERSON_ID,
349: X_COURSE_CD => p_old_refsua.COURSE_CD,
350: X_UNIT_CD => p_old_refsua.UNIT_CD,

Line 824: SELECT 'X' FROM igs_en_su_attempt_all sua, igs_ps_unit_ofr_opt_all uoo

820: l_row_id ROWID;
821: l_warning_id igs_en_std_warnings.warning_id%TYPE;
822: l_deny_warn VARCHAR2(20);
823: CURSOR c_unit_sec_rep(cp_uoo_id IN NUMBER) IS
824: SELECT 'X' FROM igs_en_su_attempt_all sua, igs_ps_unit_ofr_opt_all uoo
825: WHERE uoo.uoo_id = cp_uoo_id
826: AND sua.person_id = p_n_person_id
827: AND sua.course_cd = p_c_program_code
828: AND sua.core_indicator_code = 'CORE'

Line 937: FROM IGS_EN_SU_ATTEMPT sua

933:
934: -- Get the SUA Details
935: CURSOR c_sua (cp_n_person_id IN NUMBER, cp_c_course_cd IN VARCHAR2, cp_n_uoo_id IN NUMBER) IS
936: SELECT *
937: FROM IGS_EN_SU_ATTEMPT sua
938: WHERE sua.person_id = cp_n_person_id
939: AND sua.course_cd = cp_c_course_cd
940: AND sua.uoo_id = cp_n_uoo_id;
941:

Line 978: l_unit_cd igs_en_su_attempt.unit_cd%TYPE;

974: l_icon VARCHAR2(1);
975: l_display_rule VARCHAR2(1);
976: l_coreq_failed_uoo_ids VARCHAR2(1000);
977: l_prereq_failed_uoo_ids VARCHAR2(1000);
978: l_unit_cd igs_en_su_attempt.unit_cd%TYPE;
979: l_uoo_id igs_en_su_attempt.uoo_id%TYPE;
980: l_unit_class igs_en_su_attempt.unit_class%TYPE;
981:
982: BEGIN

Line 979: l_uoo_id igs_en_su_attempt.uoo_id%TYPE;

975: l_display_rule VARCHAR2(1);
976: l_coreq_failed_uoo_ids VARCHAR2(1000);
977: l_prereq_failed_uoo_ids VARCHAR2(1000);
978: l_unit_cd igs_en_su_attempt.unit_cd%TYPE;
979: l_uoo_id igs_en_su_attempt.uoo_id%TYPE;
980: l_unit_class igs_en_su_attempt.unit_class%TYPE;
981:
982: BEGIN
983:

Line 980: l_unit_class igs_en_su_attempt.unit_class%TYPE;

976: l_coreq_failed_uoo_ids VARCHAR2(1000);
977: l_prereq_failed_uoo_ids VARCHAR2(1000);
978: l_unit_cd igs_en_su_attempt.unit_cd%TYPE;
979: l_uoo_id igs_en_su_attempt.uoo_id%TYPE;
980: l_unit_class igs_en_su_attempt.unit_class%TYPE;
981:
982: BEGIN
983:
984: -- reset the global variable

Line 1075: FROM IGS_EN_SU_ATTEMPT U, IGS_CA_LOAD_TO_TEACH_V V

1071:
1072: -- Validate prereq and coreq before dropping the units to be swapped
1073: OPEN c_ref_cur_coreq_prereq FOR
1074: 'SELECT U.unit_cd, U.unit_class, U.uoo_id
1075: FROM IGS_EN_SU_ATTEMPT U, IGS_CA_LOAD_TO_TEACH_V V
1076: WHERE U.person_id = :1
1077: AND U.course_cd = :2
1078: AND U.unit_attempt_status IN (''ENROLLED'',''INVALID'')
1079: AND U.uoo_id NOT IN('||p_uoo_ids||')

Line 1145: -- Set the calling package as 'SWAP' so that check parent existence in igs_en_su_attempt_pkg will not be called.

1141: CLOSE c_drop_reason;
1142:
1143: IF l_uoo_ids IS NOT NULL THEN
1144:
1145: -- Set the calling package as 'SWAP' so that check parent existence in igs_en_su_attempt_pkg will not be called.
1146: -- This is to overcome the locking issue encountered during Swap.
1147: -- (i.e) when the user is dropping few sua in the swap to be replaced, the sua is getting updated as 'DROPPED' and
1148: -- it locks all the parent records like SPA terms, sca...., in the swap to be added page when the user tries to
1149: -- add few sua, sua records are created in autonomous transaction where the check_parent_existences of TBH is being

Line 1153: igs_en_su_attempt_pkg.pkg_source_of_drop := 'SWAP';

1149: -- add few sua, sua records are created in autonomous transaction where the check_parent_existences of TBH is being
1150: -- called as the parents are already locked in another transaction while dropping, SUA record creation in autonomous
1151: -- transaction fails.
1152:
1153: igs_en_su_attempt_pkg.pkg_source_of_drop := 'SWAP';
1154:
1155: while l_uoo_ids is not null loop
1156: pos := instr(l_uoo_ids,',',1);
1157: if pos=0 then

Line 1169: IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW (

1165: FOR rec_sua IN c_sua(p_person_id,p_program_cd,l_cur_uoo_id)
1166: LOOP
1167:
1168: -- Drop the sua with reason code as swap reason code.
1169: IGS_EN_SU_ATTEMPT_PKG.UPDATE_ROW (
1170: X_ROWID => rec_sua.row_id,
1171: X_PERSON_ID => rec_sua.person_id,
1172: X_COURSE_CD => rec_sua.course_cd,
1173: X_UNIT_CD => rec_sua.unit_cd,

Line 1276: igs_en_su_attempt_pkg.pkg_source_of_drop := NULL;

1272: END LOOP; -- While loop
1273: END IF;
1274:
1275: -- Unsetting the package variable after dropping SUA.
1276: igs_en_su_attempt_pkg.pkg_source_of_drop := NULL;
1277:
1278:
1279: l_display_rule := NVL(fnd_profile.value('IGS_EN_CART_RULE_DISPLAY'),'N');
1280:

Line 1283: FROM IGS_EN_SU_ATTEMPT U, IGS_CA_LOAD_TO_TEACH_V V

1279: l_display_rule := NVL(fnd_profile.value('IGS_EN_CART_RULE_DISPLAY'),'N');
1280:
1281: OPEN c_ref_cur_coreq_prereq FOR
1282: 'SELECT U.unit_cd, U.unit_class, U.uoo_id
1283: FROM IGS_EN_SU_ATTEMPT U, IGS_CA_LOAD_TO_TEACH_V V
1284: WHERE U.person_id = :1
1285: AND U.course_cd = :2
1286: AND U.unit_attempt_status IN (''ENROLLED'',''INVALID'')
1287: AND U.uoo_id NOT IN('||p_uoo_ids||')

Line 1453: FROM igs_en_su_attempt_all sua,

1449: CURSOR c_sub_sua (cp_person_id IN NUMBER, cp_course_cd IN VARCHAR2, cp_uoo_id IN NUMBER) IS
1450: SELECT sua.unit_cd || '/' || sua.unit_class AS UNIT_SECTION,
1451: sua.uoo_id,
1452: sua.core_indicator_code AS CORE
1453: FROM igs_en_su_attempt_all sua,
1454: igs_ps_unit_ofr_opt_all uoo
1455: WHERE sua.person_id = cp_person_id
1456: AND sua.course_cd = cp_course_cd
1457: AND sua.uoo_id = uoo.uoo_id

Line 1477: FROM igs_en_su_attempt sua

1473: CURSOR c_del (cp_person_id IN NUMBER,
1474: cp_course_cd IN VARCHAR2,
1475: cp_uoo_id IN NUMBER) IS
1476: SELECT sua.row_id AS ROW_ID
1477: FROM igs_en_su_attempt sua
1478: WHERE sua.person_id = cp_person_id
1479: AND sua.course_cd = cp_course_cd
1480: AND sua.uoo_id = cp_uoo_id;
1481:

Line 1484: igs_en_su_attempt_pkg.delete_row ( X_ROWID => rec_del.row_id,

1480: AND sua.uoo_id = cp_uoo_id;
1481:
1482: BEGIN
1483: FOR rec_del IN c_del(p_person_id, p_course_cd, p_uoo_id) LOOP
1484: igs_en_su_attempt_pkg.delete_row ( X_ROWID => rec_del.row_id,
1485: X_MODE => 'R');
1486: END LOOP;
1487: END sua_delete;
1488:

Line 1547: FROM IGS_EN_SU_ATTEMPT_ALL

1543: program_cd IN VARCHAR2,
1544: p_uoo_ids IN VARCHAR2) AS
1545: CURSOR cur_sua(cp_person_id IN NUMBER,cp_program_cd IN VARCHAR2,cp_uoo_id IN NUMBER) IS
1546: SELECT *
1547: FROM IGS_EN_SU_ATTEMPT_ALL
1548: WHERE person_id = cp_person_id
1549: AND course_cd = cp_program_cd
1550: AND uoo_Id = cp_uoo_Id;
1551:

Line 1558: old_rec igs_en_su_attempt_all%rowTYPE;

1554: FROM igs_ps_rsv_ext rsv
1555: WHERE rsv_ext_id = cp_rsv_ext_id FOR UPDATE;
1556:
1557:
1558: old_rec igs_en_su_attempt_all%rowTYPE;
1559: new_rec igs_en_su_attempt_all%ROWTYPE;
1560: l_uoo_ids varchar2(30);
1561: l_cur_uoo_id varchar2(30);
1562: pos number;

Line 1559: new_rec igs_en_su_attempt_all%ROWTYPE;

1555: WHERE rsv_ext_id = cp_rsv_ext_id FOR UPDATE;
1556:
1557:
1558: old_rec igs_en_su_attempt_all%rowTYPE;
1559: new_rec igs_en_su_attempt_all%ROWTYPE;
1560: l_uoo_ids varchar2(30);
1561: l_cur_uoo_id varchar2(30);
1562: pos number;
1563: v_message_name VARCHAR2(30);

Line 1649: FROM igs_en_su_attempt_all sua,

1645: cp_c_load_cal IN VARCHAR2,
1646: cp_n_seq_num IN NUMBER) IS
1647: SELECT sua.ROWID ROW_ID,
1648: sua.uoo_id
1649: FROM igs_en_su_attempt_all sua,
1650: igs_ca_teach_to_load_v rel
1651: WHERE sua.person_id = cp_n_person_id
1652: AND sua.course_cd = cp_c_program_code
1653: AND sua.cal_type = rel.teach_cal_type

Line 1682: igs_en_su_attempt_pkg.delete_row(X_ROWID => rec_sua.row_id,

1678: END LOOP;
1679:
1680: FOR rec_sua IN c_sua(p_n_person_id,p_c_program_code,p_c_load_cal,p_n_load_seq_num) LOOP
1681:
1682: igs_en_su_attempt_pkg.delete_row(X_ROWID => rec_sua.row_id,
1683: x_mode => 'R');
1684: END LOOP;
1685:
1686: COMMIT;

Line 2004: igs_en_su_attempt_pkg.lock_row(

2000: -------------------------------------------------------------------
2001: IS
2002: PRAGMA AUTONOMOUS_TRANSACTION;
2003: BEGIN
2004: igs_en_su_attempt_pkg.lock_row(
2005: X_ROWID => X_ROWID,
2006: X_PERSON_ID => p_person_id,
2007: X_COURSE_CD => p_course_cd,
2008: X_UNIT_CD => X_UNIT_CD,

Line 2171: FROM IGS_EN_SU_ATTEMPT_ALL

2167: program_cd IN VARCHAR2,
2168: p_uoo_ids IN VARCHAR2) AS
2169: CURSOR cur_sua(cp_person_id IN NUMBER,cp_program_cd IN VARCHAR2,cp_uoo_id IN NUMBER) IS
2170: SELECT *
2171: FROM IGS_EN_SU_ATTEMPT_ALL
2172: WHERE person_id = cp_person_id
2173: AND course_cd = cp_program_cd
2174: AND uoo_Id = cp_uoo_Id;
2175:

Line 2183: old_rec igs_en_su_attempt_all%rowTYPE;

2179: WHERE rsv_ext_id = cp_rsv_ext_id FOR UPDATE;
2180:
2181: l_cur_igs_ps_rsv_ext cur_igs_ps_rsv_ext%ROWTYPE;
2182: l_rsv_ext_id igs_ps_rsv_ext.rsv_ext_id%TYPE;
2183: old_rec igs_en_su_attempt_all%rowTYPE;
2184: new_rec igs_en_su_attempt_all%ROWTYPE;
2185: l_uoo_ids varchar2(30);
2186: l_cur_uoo_id varchar2(30);
2187: pos number;

Line 2184: new_rec igs_en_su_attempt_all%ROWTYPE;

2180:
2181: l_cur_igs_ps_rsv_ext cur_igs_ps_rsv_ext%ROWTYPE;
2182: l_rsv_ext_id igs_ps_rsv_ext.rsv_ext_id%TYPE;
2183: old_rec igs_en_su_attempt_all%rowTYPE;
2184: new_rec igs_en_su_attempt_all%ROWTYPE;
2185: l_uoo_ids varchar2(30);
2186: l_cur_uoo_id varchar2(30);
2187: pos number;
2188: v_message_name VARCHAR2(30);

Line 2191: p_sua_rec OUT NOCOPY igs_en_su_attempt_all%ROWTYPE ) AS

2187: pos number;
2188: v_message_name VARCHAR2(30);
2189:
2190: PROCEDURE get_old_sua (p_person_id IN NUMBER,p_program_cd IN VARCHAR2,p_uoo_id IN NUMBER,
2191: p_sua_rec OUT NOCOPY igs_en_su_attempt_all%ROWTYPE ) AS
2192: PRAGMA AUTONOMOUS_TRANSACTION;
2193:
2194: CURSOR c_old_sua IS
2195: SELECT *

Line 2196: FROM IGS_EN_SU_ATTEMPT_ALL

2192: PRAGMA AUTONOMOUS_TRANSACTION;
2193:
2194: CURSOR c_old_sua IS
2195: SELECT *
2196: FROM IGS_EN_SU_ATTEMPT_ALL
2197: WHERE person_id = p_person_id
2198: AND course_cd = p_program_cd
2199: AND uoo_Id = p_uoo_Id;
2200: c_old_sua_rec c_old_sua%ROWTYPE;

Line 2289: FUNCTION get_sua_fin_mark(p_person_id IN igs_en_su_attempt_all.person_id%TYPE,

2285:
2286: END drop_submit;
2287:
2288:
2289: FUNCTION get_sua_fin_mark(p_person_id IN igs_en_su_attempt_all.person_id%TYPE,
2290: p_course_cd IN igs_en_su_attempt_all.course_Cd%TYPE,
2291: p_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE)
2292: RETURN NUMBER IS
2293:

Line 2290: p_course_cd IN igs_en_su_attempt_all.course_Cd%TYPE,

2286: END drop_submit;
2287:
2288:
2289: FUNCTION get_sua_fin_mark(p_person_id IN igs_en_su_attempt_all.person_id%TYPE,
2290: p_course_cd IN igs_en_su_attempt_all.course_Cd%TYPE,
2291: p_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE)
2292: RETURN NUMBER IS
2293:
2294: CURSOR c_suao IS

Line 2291: p_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE)

2287:
2288:
2289: FUNCTION get_sua_fin_mark(p_person_id IN igs_en_su_attempt_all.person_id%TYPE,
2290: p_course_cd IN igs_en_su_attempt_all.course_Cd%TYPE,
2291: p_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE)
2292: RETURN NUMBER IS
2293:
2294: CURSOR c_suao IS
2295: SELECT susv.mark

Line 2314: FUNCTION get_sua_fin_grade(p_person_id IN igs_en_su_attempt_all.person_id%TYPE,

2310: CLOSE c_suao;
2311: RETURN l_mark;
2312: END get_sua_fin_mark;
2313:
2314: FUNCTION get_sua_fin_grade(p_person_id IN igs_en_su_attempt_all.person_id%TYPE,
2315: p_course_cd IN igs_en_su_attempt_all.course_Cd%TYPE,
2316: p_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE)
2317: RETURN VARCHAR2 IS
2318:

Line 2315: p_course_cd IN igs_en_su_attempt_all.course_Cd%TYPE,

2311: RETURN l_mark;
2312: END get_sua_fin_mark;
2313:
2314: FUNCTION get_sua_fin_grade(p_person_id IN igs_en_su_attempt_all.person_id%TYPE,
2315: p_course_cd IN igs_en_su_attempt_all.course_Cd%TYPE,
2316: p_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE)
2317: RETURN VARCHAR2 IS
2318:
2319: CURSOR c_suao IS

Line 2316: p_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE)

2312: END get_sua_fin_mark;
2313:
2314: FUNCTION get_sua_fin_grade(p_person_id IN igs_en_su_attempt_all.person_id%TYPE,
2315: p_course_cd IN igs_en_su_attempt_all.course_Cd%TYPE,
2316: p_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE)
2317: RETURN VARCHAR2 IS
2318:
2319: CURSOR c_suao IS
2320: SELECT susv.grade