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.

[Home] [Help]

APPS.IGS_AS_GEN_004 dependencies on IGS_AS_SU_ATMPT_ITM

Line 14: | nalkumar 24-May-2003 Modified the call to the igs_as_su_atmpt_itm_pkg|

10: | CHANGE HISTORY |
11: +======================================================================+
12: | WHO WHEN WHAT |
13: +======================================================================+
14: | nalkumar 24-May-2003 Modified the call to the igs_as_su_atmpt_itm_pkg|
15: | Added two new parameters |
16: | x_unit_section_ass_item_id and |
17: | x_unit_ass_item_id in the call; |
18: | This is as per 'Assessment Item description |

Line 1218: v_ass_id igs_as_su_atmpt_itm.ass_id%TYPE;

1214: -- This procedure is responsible for copying all of the assessment
1215: -- items for a Student IGS_PS_UNIT Attempt to the Special Consideration
1216: -- Application table.
1217: DECLARE
1218: v_ass_id igs_as_su_atmpt_itm.ass_id%TYPE;
1219: v_creation_dt igs_as_su_atmpt_itm.creation_dt%TYPE;
1220: v_spcl_consideration_cat igs_as_spcl_cons_cat.spcl_consideration_cat%TYPE;
1221: v_static_sysdate igs_as_spl_cons_appl.received_dt%TYPE;
1222: v_ins_fail_flag BOOLEAN DEFAULT FALSE;

Line 1219: v_creation_dt igs_as_su_atmpt_itm.creation_dt%TYPE;

1215: -- items for a Student IGS_PS_UNIT Attempt to the Special Consideration
1216: -- Application table.
1217: DECLARE
1218: v_ass_id igs_as_su_atmpt_itm.ass_id%TYPE;
1219: v_creation_dt igs_as_su_atmpt_itm.creation_dt%TYPE;
1220: v_spcl_consideration_cat igs_as_spcl_cons_cat.spcl_consideration_cat%TYPE;
1221: v_static_sysdate igs_as_spl_cons_appl.received_dt%TYPE;
1222: v_ins_fail_flag BOOLEAN DEFAULT FALSE;
1223: v_scap_exists_flag BOOLEAN DEFAULT FALSE;

Line 1232: FROM igs_as_su_atmpt_itm suaai

1228: v_message_name VARCHAR2 (30) DEFAULT NULL;
1229: CURSOR c_suaai IS
1230: SELECT suaai.ass_id,
1231: suaai.creation_dt
1232: FROM igs_as_su_atmpt_itm suaai
1233: WHERE suaai.person_id = p_person_id
1234: AND suaai.course_cd = p_course_cd
1235: AND suaai.uoo_id = p_uoo_id
1236: AND suaai.logical_delete_dt IS NULL

Line 1238: FROM igs_as_su_atmpt_itm suaai2

1234: AND suaai.course_cd = p_course_cd
1235: AND suaai.uoo_id = p_uoo_id
1236: AND suaai.logical_delete_dt IS NULL
1237: AND suaai.creation_dt = (SELECT MAX (suaai2.creation_dt)
1238: FROM igs_as_su_atmpt_itm suaai2
1239: WHERE suaai2.person_id = suaai.person_id
1240: AND suaai2.course_cd = suaai.course_cd
1241: AND suaai2.uoo_id = suaai.uoo_id
1242: AND suaai2.logical_delete_dt IS NULL

Line 1424: v_attempt_number igs_as_su_atmpt_itm.attempt_number%TYPE;

1420: e_resource_busy EXCEPTION;
1421: v_dummy VARCHAR2 (1);
1422: v_level VARCHAR2 (10);
1423: v_message_name VARCHAR2 (30);
1424: v_attempt_number igs_as_su_atmpt_itm.attempt_number%TYPE;
1425: v_course_type igs_ps_ver.course_type%TYPE;
1426: v_creation_dt DATE;
1427: l_update_flag VARCHAR2 (20) := 'FALSE';
1428: -- l_grading_schema_cd igs_ps_unitass_item.grading_schema_cd%TYPE;

Line 1461: FROM igs_as_su_atmpt_itm suaai

1457: -- For checking if the unit assessment item is MANUALLY delete or not.
1458: --
1459: CURSOR c_suaai_deleted (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
1460: SELECT 'x'
1461: FROM igs_as_su_atmpt_itm suaai
1462: WHERE suaai.person_id = p_person_id
1463: AND suaai.course_cd = p_course_cd
1464: AND suaai.uoo_id = cp_uoo_id
1465: AND suaai.ass_id = p_ass_id

Line 1469: FROM igs_as_su_atmpt_itm suaai

1465: AND suaai.ass_id = p_ass_id
1466: AND suaai.logical_delete_dt IS NOT NULL
1467: AND suaai.s_default_ind = 'N'
1468: AND NOT EXISTS ( SELECT 'x'
1469: FROM igs_as_su_atmpt_itm suaai
1470: WHERE suaai.person_id = p_person_id
1471: AND suaai.course_cd = p_course_cd
1472: AND suaai.uoo_id = cp_uoo_id
1473: AND suaai.ass_id = p_ass_id

Line 1489: FROM igs_as_su_atmpt_itm suaai

1485: --
1486: --
1487: CURSOR c_suaai_an (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
1488: SELECT NVL (MAX (suaai.attempt_number), 0) + 1
1489: FROM igs_as_su_atmpt_itm suaai
1490: WHERE suaai.person_id = p_person_id
1491: AND suaai.course_cd = p_course_cd
1492: AND suaai.uoo_id = cp_uoo_id
1493: AND suaai.ass_id = p_ass_id

Line 1501: CURSOR c_suaai_upd (cp_ass_id igs_ps_unitass_item.ass_id%TYPE, cp_uoo_id igs_en_su_attempt.uoo_id%TYPE , cp_ass_item_id igs_as_su_atmpt_itm.unit_section_ass_item_id%TYPE ) IS

1497: -- This cursor is declared to fetch the Assessment Items which are are attached to the
1498: -- Assessment Pattern , but already logically deleted. This would enable the logical deleted
1499: -- record to be back in the system.
1500: --
1501: CURSOR c_suaai_upd (cp_ass_id igs_ps_unitass_item.ass_id%TYPE, cp_uoo_id igs_en_su_attempt.uoo_id%TYPE , cp_ass_item_id igs_as_su_atmpt_itm.unit_section_ass_item_id%TYPE ) IS
1502: SELECT suaai.ROWID,
1503: suaai.*,
1504: sag.unit_ass_item_group_id,
1505: sag.us_ass_item_group_id

Line 1506: FROM igs_as_su_atmpt_itm suaai,

1502: SELECT suaai.ROWID,
1503: suaai.*,
1504: sag.unit_ass_item_group_id,
1505: sag.us_ass_item_group_id
1506: FROM igs_as_su_atmpt_itm suaai,
1507: igs_as_sua_ai_group sag
1508: WHERE suaai.person_id = p_person_id
1509: AND suaai.course_cd = p_course_cd
1510: AND suaai.uoo_id = cp_uoo_id

Line 1516: FROM igs_as_su_atmpt_itm suaai1

1512: AND (suaai.unit_section_ass_item_id = cp_ass_item_id OR suaai.UNIT_ASS_ITEM_ID = cp_ass_item_id)
1513: AND suaai.sua_ass_item_group_id = sag.sua_ass_item_group_id
1514: /* AND NOT EXISTS (
1515: SELECT 'X'
1516: FROM igs_as_su_atmpt_itm suaai1
1517: WHERE suaai1.person_id = suaai.person_id
1518: AND suaai1.course_cd = suaai.course_cd
1519: AND suaai1.uoo_id = suaai.uoo_id
1520: AND suaai1.unit_section_ass_item_id IS NOT NULL

Line 1703: FROM igs_as_su_atmpt_itm suaai

1699: cp_uoo_id NUMBER
1700: ) IS
1701: SELECT suaai.ROWID,
1702: suaai.*
1703: FROM igs_as_su_atmpt_itm suaai
1704: WHERE person_id = cp_person_id
1705: AND course_cd = cp_course_cd
1706: AND uoo_id = cp_uoo_id
1707: AND unit_ass_item_id IS NOT NULL

Line 1877: UPDATE igs_as_su_atmpt_itm suaai

1873: CLOSE cur_usec_ass_items_exist;
1874: --
1875: IF (rec_usec_ass_items_exist.ass_item_exists = 'Y') THEN
1876: --
1877: UPDATE igs_as_su_atmpt_itm suaai
1878: SET suaai.logical_delete_dt = SYSDATE,
1879: suaai.last_update_date = SYSDATE,
1880: suaai.last_updated_by = fnd_global.user_id,
1881: suaai.last_update_login = fnd_global.login_id,

Line 2038: UPDATE igs_as_su_atmpt_itm suaai

2034: ((p_ass_id_usec_unit_ind = 'USEC') AND (suaai_upd_rec.unit_section_ass_item_id IS NOT NULL) AND suaai_upd_rec.us_ass_item_group_id = p_group_id )) AND
2035: (suaai_upd_rec.logical_delete_dt IS NOT NULL)) THEN
2036: CLOSE c_suaai_upd;
2037: --
2038: UPDATE igs_as_su_atmpt_itm suaai
2039: SET suaai.logical_delete_dt = NULL,
2040: suaai.last_update_date = SYSDATE,
2041: suaai.last_updated_by = fnd_global.user_id,
2042: suaai.last_update_login = fnd_global.login_id,

Line 2055: /* igs_as_su_atmpt_itm_pkg.update_row (

2051: suaai.grading_schema_cd = p_grading_schema_cd,
2052: suaai.gs_version_number = p_gs_version_number
2053: WHERE suaai.rowid = suaai_upd_rec.ROWID;
2054:
2055: /* igs_as_su_atmpt_itm_pkg.update_row (
2056: x_mode => 'R',
2057: x_rowid => suaai_upd_rec.ROWID,
2058: x_person_id => suaai_upd_rec.person_id,
2059: x_course_cd => suaai_upd_rec.course_cd,

Line 2118: UPDATE igs_as_su_atmpt_itm suaai

2114: CLOSE c_suaai_upd;
2115: --
2116: -- Item already exists; so apply the changed assessment item definition if any
2117: --
2118: UPDATE igs_as_su_atmpt_itm suaai
2119: SET suaai.last_update_date = SYSDATE,
2120: suaai.last_updated_by = fnd_global.user_id,
2121: suaai.last_update_login = fnd_global.login_id,
2122: suaai.request_id = fnd_global.conc_request_id,

Line 2133: /* igs_as_su_atmpt_itm_pkg.update_row (

2129: suaai.final_weight_qty = p_final_weight_qty,
2130: suaai.grading_schema_cd = p_grading_schema_cd,
2131: suaai.gs_version_number = p_gs_version_number
2132: WHERE suaai.rowid = suaai_upd_rec.ROWID;
2133: /* igs_as_su_atmpt_itm_pkg.update_row (
2134: x_mode => 'R',
2135: x_rowid => suaai_upd_rec.ROWID,
2136: x_person_id => suaai_upd_rec.person_id,
2137: x_course_cd => suaai_upd_rec.course_cd,

Line 2205: igs_as_su_atmpt_itm_pkg.insert_row (

2201: END IF;
2202: OPEN c_suaai_an (p_uoo_id);
2203: FETCH c_suaai_an INTO v_attempt_number;
2204: CLOSE c_suaai_an;
2205: igs_as_su_atmpt_itm_pkg.insert_row (
2206: x_mode => 'R',
2207: x_rowid => l_rowid8,
2208: x_person_id => p_person_id,
2209: x_course_cd => p_course_cd,