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

Line 185: v_last_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE;

181: cst_duplicate CONSTANT VARCHAR2(10) := 'DUPLICATE';
182: cst_pass CONSTANT VARCHAR2(10) := 'PASS';
183: v_credit_point_total NUMBER;
184: v_advanced_standing NUMBER;
185: v_last_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE;
186: v_result_type IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE;
187: v_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE;
188: v_grading_schema_cd IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE;
189: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;

Line 206: FROM IGS_EN_SU_ATTEMPT sua,

202: uv.repeatable_ind,
203: NVL(cps.achievable_credit_points,uv.achievable_credit_points) achievable_credit_points,
204: NVL(cps.enrolled_credit_points,uv.enrolled_credit_points) enrolled_credit_points,
205: sua.uoo_id
206: FROM IGS_EN_SU_ATTEMPT sua,
207: IGS_PS_UNIT_VER uv,
208: IGS_PS_USEC_CPS cps,
209: IGS_CA_INST ci
210: WHERE sua.person_id = p_person_id AND

Line 307: (cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

303: BEGIN
304: DECLARE
305: --v_suao_rec IGS_AS_SU_STMPTOUT%ROWTYPE;
306: CURSOR c_suao_find_details
307: (cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
308: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
309: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE,
310: cp_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE) IS
311: SELECT rowid

Line 308: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,

304: DECLARE
305: --v_suao_rec IGS_AS_SU_STMPTOUT%ROWTYPE;
306: CURSOR c_suao_find_details
307: (cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
308: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
309: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE,
310: cp_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE) IS
311: SELECT rowid
312: FROM IGS_AS_SU_STMPTOUT

Line 309: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE,

305: --v_suao_rec IGS_AS_SU_STMPTOUT%ROWTYPE;
306: CURSOR c_suao_find_details
307: (cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
308: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
309: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE,
310: cp_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE) IS
311: SELECT rowid
312: FROM IGS_AS_SU_STMPTOUT
313: WHERE person_id = cp_person_id AND

Line 310: cp_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE) IS

306: CURSOR c_suao_find_details
307: (cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
308: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
309: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE,
310: cp_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE) IS
311: SELECT rowid
312: FROM IGS_AS_SU_STMPTOUT
313: WHERE person_id = cp_person_id AND
314: course_cd = cp_course_cd AND

Line 364: -- This module validates if a duplicate IGS_EN_SU_ATTEMPT can be deleted,

360: -------------------------------------------------------------------------------------------
361: e_resource_busy_exception EXCEPTION;
362: PRAGMA EXCEPTION_INIT(e_resource_busy_exception, -54);
363: BEGIN -- enrp_del_sua_sut
364: -- This module validates if a duplicate IGS_EN_SU_ATTEMPT can be deleted,
365: -- and deletes associated IGS_PS_STDNT_UNT_TRN detail.
366: DECLARE
367: cst_duplicate VARCHAR2(10) := 'DUPLICATE';
368: v_person_id IGS_PS_STDNT_UNT_TRN.person_id%TYPE;

Line 447: -- This module deletes a transferred IGS_EN_SU_ATTEMPT record.

443: -- Cursor c_sua_delete is modified.
444: -- w.r.t. bug number 2829262
445: -------------------------------------------------------------------------------------------
446: BEGIN -- enrp_del_sua_trnsfr
447: -- This module deletes a transferred IGS_EN_SU_ATTEMPT record.
448: DECLARE
449: e_resource_busy_exception EXCEPTION;
450: PRAGMA EXCEPTION_INIT(e_resource_busy_exception, -54);
451: -- cursor to lock records for delete

Line 454: FROM IGS_EN_SU_ATTEMPT sua

450: PRAGMA EXCEPTION_INIT(e_resource_busy_exception, -54);
451: -- cursor to lock records for delete
452: CURSOR c_sua_delete IS
453: SELECT rowid rowid1,person_id
454: FROM IGS_EN_SU_ATTEMPT sua
455: WHERE sua.person_id = p_person_id AND
456: sua.course_cd = p_course_cd AND
457: sua.uoo_id = p_uoo_id
458: FOR UPDATE OF sua.person_id NOWAIT;

Line 474: IGS_EN_SU_ATTEMPT_PKG.DELETE_ROW(v_sua_delete_rec.rowid1 );

470:
471: FOR v_sua_delete_rec IN c_sua_delete
472: LOOP
473: -- Delete current record
474: IGS_EN_SU_ATTEMPT_PKG.DELETE_ROW(v_sua_delete_rec.rowid1 );
475: END LOOP;
476: -- Record successfuly deleted
477: RETURN TRUE;
478: EXCEPTION