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_006 dependencies on IGS_AS_GRD_SCH_GRADE

Line 250: v_grade igs_as_grd_sch_grade.grade%TYPE;

246: DECLARE
247: i BINARY_INTEGER DEFAULT 0;
248: n BINARY_INTEGER DEFAULT 0;
249: v_record_found BOOLEAN DEFAULT FALSE;
250: v_grade igs_as_grd_sch_grade.grade%TYPE;
251: --added another variable to handle audit grades for audited attempts--
252: v_audit_grade igs_as_grd_sch_grade.grade%TYPE;
253: v_grading_schema igs_as_grd_schema.grading_schema_cd%TYPE;
254: v_gs_version_number igs_as_grd_schema.version_number%TYPE;

Line 252: v_audit_grade igs_as_grd_sch_grade.grade%TYPE;

248: n BINARY_INTEGER DEFAULT 0;
249: v_record_found BOOLEAN DEFAULT FALSE;
250: v_grade igs_as_grd_sch_grade.grade%TYPE;
251: --added another variable to handle audit grades for audited attempts--
252: v_audit_grade igs_as_grd_sch_grade.grade%TYPE;
253: v_grading_schema igs_as_grd_schema.grading_schema_cd%TYPE;
254: v_gs_version_number igs_as_grd_schema.version_number%TYPE;
255: v_insert_grade igs_as_grd_sch_grade.grade%TYPE;
256: --

Line 255: v_insert_grade igs_as_grd_sch_grade.grade%TYPE;

251: --added another variable to handle audit grades for audited attempts--
252: v_audit_grade igs_as_grd_sch_grade.grade%TYPE;
253: v_grading_schema igs_as_grd_schema.grading_schema_cd%TYPE;
254: v_gs_version_number igs_as_grd_schema.version_number%TYPE;
255: v_insert_grade igs_as_grd_sch_grade.grade%TYPE;
256: --
257: -- Get all the Student Unit Attempts that do not have any Unit Attempt Outcome
258: -- and match the criteria passed thru parameters
259: --

Line 347: FROM igs_as_grd_sch_grade gsg

343: cp_grading_schema igs_as_grd_schema.grading_schema_cd%TYPE,
344: cp_gs_version_number igs_as_grd_schema.version_number%TYPE
345: ) IS
346: SELECT gsg.grade
347: FROM igs_as_grd_sch_grade gsg
348: WHERE gsg.grading_schema_cd = cp_grading_schema
349: AND gsg.version_number = cp_gs_version_number
350: AND gsg.dflt_outstanding_ind = 'Y'
351: AND gsg.s_result_type <> 'AUDIT'

Line 363: FROM igs_as_grd_sch_grade gsg

359: cp_grading_schema igs_as_grd_schema.grading_schema_cd%TYPE,
360: cp_gs_version_number igs_as_grd_schema.version_number%TYPE
361: ) IS
362: SELECT gsg.grade
363: FROM igs_as_grd_sch_grade gsg
364: WHERE gsg.grading_schema_cd = cp_grading_schema
365: AND gsg.version_number = cp_gs_version_number
366: AND gsg.dflt_outstanding_ind = 'Y'
367: AND gsg.s_result_type = 'AUDIT'

Line 538: cp_grading_schema igs_as_grd_sch_grade.grading_schema_cd%TYPE,

534: p_uoo_id igs_en_su_attempt.uoo_id%TYPE
535: ) IS
536: --
537: CURSOR c_grading_schema_grade (
538: cp_grading_schema igs_as_grd_sch_grade.grading_schema_cd%TYPE,
539: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE,
540: cp_grade igs_as_grd_sch_grade.grade%TYPE
541: ) IS
542: SELECT gsg.grade

Line 539: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE,

535: ) IS
536: --
537: CURSOR c_grading_schema_grade (
538: cp_grading_schema igs_as_grd_sch_grade.grading_schema_cd%TYPE,
539: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE,
540: cp_grade igs_as_grd_sch_grade.grade%TYPE
541: ) IS
542: SELECT gsg.grade
543: FROM igs_as_grd_sch_grade gsg

Line 540: cp_grade igs_as_grd_sch_grade.grade%TYPE

536: --
537: CURSOR c_grading_schema_grade (
538: cp_grading_schema igs_as_grd_sch_grade.grading_schema_cd%TYPE,
539: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE,
540: cp_grade igs_as_grd_sch_grade.grade%TYPE
541: ) IS
542: SELECT gsg.grade
543: FROM igs_as_grd_sch_grade gsg
544: WHERE gsg.grading_schema_cd = cp_grading_schema

Line 543: FROM igs_as_grd_sch_grade gsg

539: cp_gs_version_number igs_as_grd_sch_grade.version_number%TYPE,
540: cp_grade igs_as_grd_sch_grade.grade%TYPE
541: ) IS
542: SELECT gsg.grade
543: FROM igs_as_grd_sch_grade gsg
544: WHERE gsg.grading_schema_cd = cp_grading_schema
545: AND gsg.version_number = cp_gs_version_number
546: AND gsg.grade = cp_grade;
547: --

Line 2467: -- Get a record from IGS_AS_GRD_SCH_GRADE and make duplicates under the new

2463: BEGIN -- assp_ins_gs_duprec
2464: -- This procedure is responsible for transferring all of the details for a
2465: -- nominated
2466: -- grading schema over into another grading schema.
2467: -- Get a record from IGS_AS_GRD_SCH_GRADE and make duplicates under the new
2468: -- IGS_AS_GRD_SCHEMA.
2469: DECLARE
2470: cst_exist_ind CONSTANT CHAR := 'x';
2471: CURSOR c_gs_new (

Line 2486: cp_old_grading_schema_cd IN IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE,

2482: FROM IGS_AS_GRD_SCHEMA
2483: WHERE grading_schema_cd = cp_old_grading_schema_cd AND
2484: version_number = cp_old_version_number;
2485: CURSOR c_gsg (
2486: cp_old_grading_schema_cd IN IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE,
2487: cp_old_version_number IN IGS_AS_GRD_SCH_GRADE.version_number%TYPE) IS
2488: SELECT *
2489: FROM IGS_AS_GRD_SCH_GRADE
2490: WHERE grading_schema_cd = cp_old_grading_schema_cd AND

Line 2487: cp_old_version_number IN IGS_AS_GRD_SCH_GRADE.version_number%TYPE) IS

2483: WHERE grading_schema_cd = cp_old_grading_schema_cd AND
2484: version_number = cp_old_version_number;
2485: CURSOR c_gsg (
2486: cp_old_grading_schema_cd IN IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE,
2487: cp_old_version_number IN IGS_AS_GRD_SCH_GRADE.version_number%TYPE) IS
2488: SELECT *
2489: FROM IGS_AS_GRD_SCH_GRADE
2490: WHERE grading_schema_cd = cp_old_grading_schema_cd AND
2491: version_number = cp_old_version_number AND

Line 2489: FROM IGS_AS_GRD_SCH_GRADE

2485: CURSOR c_gsg (
2486: cp_old_grading_schema_cd IN IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE,
2487: cp_old_version_number IN IGS_AS_GRD_SCH_GRADE.version_number%TYPE) IS
2488: SELECT *
2489: FROM IGS_AS_GRD_SCH_GRADE
2490: WHERE grading_schema_cd = cp_old_grading_schema_cd AND
2491: version_number = cp_old_version_number AND
2492: closed_ind = 'N';
2493: v_gs_old_rec c_gs_old%ROWTYPE;

Line 2530: IGS_AS_GRD_SCH_GRADE_PKG.INSERT_ROW(

2526: p_old_grading_schema_cd,
2527: p_old_version_number) LOOP
2528: BEGIN
2529: x_rowid := NULL;
2530: IGS_AS_GRD_SCH_GRADE_PKG.INSERT_ROW(
2531: X_ROWID => x_rowid,
2532: X_GRADING_SCHEMA_CD => p_new_grading_schema_cd,
2533: X_VERSION_NUMBER => p_new_version_number,
2534: X_GRADE => v_gsg_rec.grade,