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_AS_GEN_007 dependencies on IGS_AS_UNITASS_ITEM

Line 15: | igs_as_unitass_item_pkg; igs_ps_unitass_item_pkg

11: +======================================================================+
12: | WHO WHEN WHAT |
13: +======================================================================+
14: | Nalin Kumar 24-May-2003 Modified the call to the igs_as_su_atmpt_itm_pkg;
15: | igs_as_unitass_item_pkg; igs_ps_unitass_item_pkg
16: | Added the references of the newly added columns
17: | in the base tables. This is as per 'Assessment
18: | Item description Build'; Bug# 2829291;
19: | smvk 09-Jul-2004 Bug # 3676145. Modified the cursors c_suaai,

Line 49: v_uai_due_dt igs_as_unitass_item.due_dt%TYPE;

45: gv_log_created BOOLEAN DEFAULT FALSE;
46: BEGIN -- assp_ins_suaai_tri
47: -- Create a tracking item for a IGS_AS_SU_ATMPT_ITM.
48: DECLARE
49: v_uai_due_dt igs_as_unitass_item.due_dt%TYPE;
50: v_uai_reference igs_as_unitass_item.REFERENCE%TYPE;
51: v_uai_location_cd igs_en_su_attempt.location_cd%TYPE;
52: v_uai_unit_class igs_as_unitass_item.unit_class%TYPE;
53: v_uai_unit_mode igs_as_unitass_item.unit_mode%TYPE;

Line 50: v_uai_reference igs_as_unitass_item.REFERENCE%TYPE;

46: BEGIN -- assp_ins_suaai_tri
47: -- Create a tracking item for a IGS_AS_SU_ATMPT_ITM.
48: DECLARE
49: v_uai_due_dt igs_as_unitass_item.due_dt%TYPE;
50: v_uai_reference igs_as_unitass_item.REFERENCE%TYPE;
51: v_uai_location_cd igs_en_su_attempt.location_cd%TYPE;
52: v_uai_unit_class igs_as_unitass_item.unit_class%TYPE;
53: v_uai_unit_mode igs_as_unitass_item.unit_mode%TYPE;
54: v_create_item BOOLEAN;

Line 52: v_uai_unit_class igs_as_unitass_item.unit_class%TYPE;

48: DECLARE
49: v_uai_due_dt igs_as_unitass_item.due_dt%TYPE;
50: v_uai_reference igs_as_unitass_item.REFERENCE%TYPE;
51: v_uai_location_cd igs_en_su_attempt.location_cd%TYPE;
52: v_uai_unit_class igs_as_unitass_item.unit_class%TYPE;
53: v_uai_unit_mode igs_as_unitass_item.unit_mode%TYPE;
54: v_create_item BOOLEAN;
55: v_record VARCHAR2 (1024);
56: v_log_dt DATE := NULL;

Line 53: v_uai_unit_mode igs_as_unitass_item.unit_mode%TYPE;

49: v_uai_due_dt igs_as_unitass_item.due_dt%TYPE;
50: v_uai_reference igs_as_unitass_item.REFERENCE%TYPE;
51: v_uai_location_cd igs_en_su_attempt.location_cd%TYPE;
52: v_uai_unit_class igs_as_unitass_item.unit_class%TYPE;
53: v_uai_unit_mode igs_as_unitass_item.unit_mode%TYPE;
54: v_create_item BOOLEAN;
55: v_record VARCHAR2 (1024);
56: v_log_dt DATE := NULL;
57: v_check CHAR;

Line 134: igs_as_unitass_item uai,

130: uai.location_cd,
131: uai.unit_class,
132: uai.unit_mode
133: FROM igs_en_su_attempt sua,
134: igs_as_unitass_item uai,
135: igs_as_unit_class uc
136: WHERE sua.person_id = cp_person_id
137: AND sua.course_cd = cp_course_cd
138: AND sua.uoo_id = cp_uoo_id

Line 208: -- Determine the appropriate IGS_AS_UNITASS_ITEM for the

204: -- Process each suaai record that is to have tracking item assigned.
205: FOR v_suaai_rec IN c_suaai LOOP
206: v_create_item := TRUE;
207: SAVEPOINT sp_ins_suaai_tri;
208: -- Determine the appropriate IGS_AS_UNITASS_ITEM for the
209: -- location mode and class of the student and get the due date
210: v_uai_reference := NULL;
211: OPEN c_sua_uai_v (
212: v_suaai_rec.person_id,

Line 572: igs_as_unitass_item uai,

568: v_uai_reference := NULL;
569: SELECT uai.REFERENCE
570: INTO v_uai_reference
571: FROM igs_en_su_attempt sua,
572: igs_as_unitass_item uai,
573: igs_as_unit_class uc
574: WHERE sua.person_id = v_suaai_rec.person_id
575: AND sua.course_cd = v_suaai_rec.course_cd
576: AND sua.uoo_id = v_suaai_rec.uoo_id

Line 1282: FROM igs_as_unitass_item uai,

1278: uai.final_mandatory_type_code,
1279: uai.final_weight_qty,
1280: uai.grading_schema_cd,
1281: uai.gs_version_number
1282: FROM igs_as_unitass_item uai,
1283: igs_as_assessmnt_itm ai,
1284: igs_ca_inst_rel cir
1285: WHERE uai.ass_id = ai.ass_id
1286: AND (p_teach_perd_cal_type IS NULL

Line 1324: p_unit_cd igs_as_unitass_item.unit_cd%TYPE,

1320: --
1321: --
1322: --
1323: PROCEDURE asspl_prc_update_uai (
1324: p_unit_cd igs_as_unitass_item.unit_cd%TYPE,
1325: p_version_number igs_as_unitass_item.version_number%TYPE,
1326: p_cal_type igs_as_unitass_item.cal_type%TYPE,
1327: p_ci_sequence_number igs_as_unitass_item.ci_sequence_number%TYPE,
1328: p_ass_id igs_as_unitass_item.ass_id%TYPE,

Line 1325: p_version_number igs_as_unitass_item.version_number%TYPE,

1321: --
1322: --
1323: PROCEDURE asspl_prc_update_uai (
1324: p_unit_cd igs_as_unitass_item.unit_cd%TYPE,
1325: p_version_number igs_as_unitass_item.version_number%TYPE,
1326: p_cal_type igs_as_unitass_item.cal_type%TYPE,
1327: p_ci_sequence_number igs_as_unitass_item.ci_sequence_number%TYPE,
1328: p_ass_id igs_as_unitass_item.ass_id%TYPE,
1329: p_sequence_number igs_as_unitass_item.sequence_number%TYPE,

Line 1326: p_cal_type igs_as_unitass_item.cal_type%TYPE,

1322: --
1323: PROCEDURE asspl_prc_update_uai (
1324: p_unit_cd igs_as_unitass_item.unit_cd%TYPE,
1325: p_version_number igs_as_unitass_item.version_number%TYPE,
1326: p_cal_type igs_as_unitass_item.cal_type%TYPE,
1327: p_ci_sequence_number igs_as_unitass_item.ci_sequence_number%TYPE,
1328: p_ass_id igs_as_unitass_item.ass_id%TYPE,
1329: p_sequence_number igs_as_unitass_item.sequence_number%TYPE,
1330: p_session_id igs_ge_s_log.KEY%TYPE,

Line 1327: p_ci_sequence_number igs_as_unitass_item.ci_sequence_number%TYPE,

1323: PROCEDURE asspl_prc_update_uai (
1324: p_unit_cd igs_as_unitass_item.unit_cd%TYPE,
1325: p_version_number igs_as_unitass_item.version_number%TYPE,
1326: p_cal_type igs_as_unitass_item.cal_type%TYPE,
1327: p_ci_sequence_number igs_as_unitass_item.ci_sequence_number%TYPE,
1328: p_ass_id igs_as_unitass_item.ass_id%TYPE,
1329: p_sequence_number igs_as_unitass_item.sequence_number%TYPE,
1330: p_session_id igs_ge_s_log.KEY%TYPE,
1331: p_log_dt IN OUT NOCOPY DATE

Line 1328: p_ass_id igs_as_unitass_item.ass_id%TYPE,

1324: p_unit_cd igs_as_unitass_item.unit_cd%TYPE,
1325: p_version_number igs_as_unitass_item.version_number%TYPE,
1326: p_cal_type igs_as_unitass_item.cal_type%TYPE,
1327: p_ci_sequence_number igs_as_unitass_item.ci_sequence_number%TYPE,
1328: p_ass_id igs_as_unitass_item.ass_id%TYPE,
1329: p_sequence_number igs_as_unitass_item.sequence_number%TYPE,
1330: p_session_id igs_ge_s_log.KEY%TYPE,
1331: p_log_dt IN OUT NOCOPY DATE
1332: ) IS

Line 1329: p_sequence_number igs_as_unitass_item.sequence_number%TYPE,

1325: p_version_number igs_as_unitass_item.version_number%TYPE,
1326: p_cal_type igs_as_unitass_item.cal_type%TYPE,
1327: p_ci_sequence_number igs_as_unitass_item.ci_sequence_number%TYPE,
1328: p_ass_id igs_as_unitass_item.ass_id%TYPE,
1329: p_sequence_number igs_as_unitass_item.sequence_number%TYPE,
1330: p_session_id igs_ge_s_log.KEY%TYPE,
1331: p_log_dt IN OUT NOCOPY DATE
1332: ) IS
1333: gv_other_detail VARCHAR2 (255);

Line 1335: -- Select the IGS_AS_UNITASS_ITEM table for update NOWAIT and set

1331: p_log_dt IN OUT NOCOPY DATE
1332: ) IS
1333: gv_other_detail VARCHAR2 (255);
1334: BEGIN -- asspl_prc_update_uai
1335: -- Select the IGS_AS_UNITASS_ITEM table for update NOWAIT and set
1336: -- the action date to null.
1337: -- If a lock occurs, then commit the processing anyway but report on
1338: -- the exception. No need to rollback as processing completed. If the
1339: -- item and action date is processed again then no changes will occur

Line 1347: FROM igs_as_unitass_item uai

1343: PRAGMA EXCEPTION_INIT (e_resource_busy, -54);
1344: CURSOR c_uai_upd IS
1345: SELECT ROWID,
1346: uai.*
1347: FROM igs_as_unitass_item uai
1348: WHERE uai.unit_cd = p_unit_cd
1349: AND uai.version_number = p_version_number
1350: AND uai.cal_type = p_cal_type
1351: AND uai.ci_sequence_number = p_ci_sequence_number

Line 1363: igs_as_unitass_item_pkg.update_row (

1359: IF c_uai_upd%NOTFOUND THEN
1360: CLOSE c_uai_upd;
1361: RAISE NO_DATA_FOUND;
1362: ELSE
1363: igs_as_unitass_item_pkg.update_row (
1364: x_rowid => v_uai_upd_rec.ROWID,
1365: x_unit_ass_item_id => v_uai_upd_rec.unit_ass_item_id,
1366: x_unit_cd => v_uai_upd_rec.unit_cd,
1367: x_version_number => v_uai_upd_rec.version_number,

Line 1613: -- associated with the IGS_AS_UNITASS_ITEM record so that all can be

1609: -- that it is still valid. If not then logically delete it.
1610: -- Will need to attempt to insert the item as it may not have existed
1611: -- for the student in the first place.
1612: -- If locking error occurs then set a flag to roll back processing
1613: -- associated with the IGS_AS_UNITASS_ITEM record so that all can be
1614: -- processed again at a later date. Report on the exception.
1615: --
1616: IF NOT igs_as_gen_005.assp_mnt_suaai_uai (
1617: v_uai_rec.unit_cd,

Line 1696: UPDATE igs_as_unitass_item

1692: );
1693: END IF;
1694: ELSIF v_uai_rec.record_ind = 'UNIT' THEN
1695: IF v_clear_action_dt THEN
1696: UPDATE igs_as_unitass_item
1697: SET action_dt = NULL,
1698: last_update_date = SYSDATE,
1699: last_updated_by = fnd_global.user_id,
1700: last_update_login = fnd_global.login_id,