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_SCHEMA

Line 253: v_grading_schema igs_as_grd_schema.grading_schema_cd%TYPE;

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: --
257: -- Get all the Student Unit Attempts that do not have any Unit Attempt Outcome

Line 254: v_gs_version_number igs_as_grd_schema.version_number%TYPE;

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: --
257: -- Get all the Student Unit Attempts that do not have any Unit Attempt Outcome
258: -- and match the criteria passed thru parameters

Line 343: cp_grading_schema igs_as_grd_schema.grading_schema_cd%TYPE,

339: --
340: -- Changed the defn of this cursor to exclude audited grades
341: --
342: CURSOR c_grading_schema_grade (
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

Line 344: cp_gs_version_number igs_as_grd_schema.version_number%TYPE

340: -- Changed the defn of this cursor to exclude audited grades
341: --
342: CURSOR c_grading_schema_grade (
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

Line 359: cp_grading_schema igs_as_grd_schema.grading_schema_cd%TYPE,

355: --
356: -- Added one more cursor to handle audited grades
357: --
358: CURSOR c_grading_schema_audit_grade (
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

Line 360: cp_gs_version_number igs_as_grd_schema.version_number%TYPE

356: -- Added one more cursor to handle audited grades
357: --
358: CURSOR c_grading_schema_audit_grade (
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

Line 2457: p_old_grading_schema_cd IN IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE ,

2453: IGS_GE_MSG_STACK.ADD;
2454: App_Exception.Raise_Exception;
2455: END assp_ins_ese_sprvsr;
2456: PROCEDURE assp_ins_gs_duprec(
2457: p_old_grading_schema_cd IN IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE ,
2458: p_old_version_number IN IGS_AS_GRD_SCHEMA.version_number%TYPE ,
2459: p_new_grading_schema_cd IN IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE ,
2460: p_new_version_number IN IGS_AS_GRD_SCHEMA.version_number%TYPE ,
2461: p_message_name OUT NOCOPY VARCHAR2 )

Line 2458: p_old_version_number IN IGS_AS_GRD_SCHEMA.version_number%TYPE ,

2454: App_Exception.Raise_Exception;
2455: END assp_ins_ese_sprvsr;
2456: PROCEDURE assp_ins_gs_duprec(
2457: p_old_grading_schema_cd IN IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE ,
2458: p_old_version_number IN IGS_AS_GRD_SCHEMA.version_number%TYPE ,
2459: p_new_grading_schema_cd IN IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE ,
2460: p_new_version_number IN IGS_AS_GRD_SCHEMA.version_number%TYPE ,
2461: p_message_name OUT NOCOPY VARCHAR2 )
2462: IS

Line 2459: p_new_grading_schema_cd IN IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE ,

2455: END assp_ins_ese_sprvsr;
2456: PROCEDURE assp_ins_gs_duprec(
2457: p_old_grading_schema_cd IN IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE ,
2458: p_old_version_number IN IGS_AS_GRD_SCHEMA.version_number%TYPE ,
2459: p_new_grading_schema_cd IN IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE ,
2460: p_new_version_number IN IGS_AS_GRD_SCHEMA.version_number%TYPE ,
2461: p_message_name OUT NOCOPY VARCHAR2 )
2462: IS
2463: BEGIN -- assp_ins_gs_duprec

Line 2460: p_new_version_number IN IGS_AS_GRD_SCHEMA.version_number%TYPE ,

2456: PROCEDURE assp_ins_gs_duprec(
2457: p_old_grading_schema_cd IN IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE ,
2458: p_old_version_number IN IGS_AS_GRD_SCHEMA.version_number%TYPE ,
2459: p_new_grading_schema_cd IN IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE ,
2460: p_new_version_number IN IGS_AS_GRD_SCHEMA.version_number%TYPE ,
2461: p_message_name OUT NOCOPY VARCHAR2 )
2462: IS
2463: BEGIN -- assp_ins_gs_duprec
2464: -- This procedure is responsible for transferring all of the details for a

Line 2468: -- IGS_AS_GRD_SCHEMA.

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 (
2472: cp_new_grading_schema_cd IN IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE,

Line 2472: cp_new_grading_schema_cd IN IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE,

2468: -- IGS_AS_GRD_SCHEMA.
2469: DECLARE
2470: cst_exist_ind CONSTANT CHAR := 'x';
2471: CURSOR c_gs_new (
2472: cp_new_grading_schema_cd IN IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE,
2473: cp_new_version_number IN IGS_AS_GRD_SCHEMA.version_number%TYPE) IS
2474: SELECT cst_exist_ind
2475: FROM IGS_AS_GRD_SCHEMA
2476: WHERE grading_schema_cd = cp_new_grading_schema_cd AND

Line 2473: cp_new_version_number IN IGS_AS_GRD_SCHEMA.version_number%TYPE) IS

2469: DECLARE
2470: cst_exist_ind CONSTANT CHAR := 'x';
2471: CURSOR c_gs_new (
2472: cp_new_grading_schema_cd IN IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE,
2473: cp_new_version_number IN IGS_AS_GRD_SCHEMA.version_number%TYPE) IS
2474: SELECT cst_exist_ind
2475: FROM IGS_AS_GRD_SCHEMA
2476: WHERE grading_schema_cd = cp_new_grading_schema_cd AND
2477: version_number = cp_new_version_number;

Line 2475: FROM IGS_AS_GRD_SCHEMA

2471: CURSOR c_gs_new (
2472: cp_new_grading_schema_cd IN IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE,
2473: cp_new_version_number IN IGS_AS_GRD_SCHEMA.version_number%TYPE) IS
2474: SELECT cst_exist_ind
2475: FROM IGS_AS_GRD_SCHEMA
2476: WHERE grading_schema_cd = cp_new_grading_schema_cd AND
2477: version_number = cp_new_version_number;
2478: CURSOR c_gs_old (
2479: cp_old_grading_schema_cd IN IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE,

Line 2479: cp_old_grading_schema_cd IN IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE,

2475: FROM IGS_AS_GRD_SCHEMA
2476: WHERE grading_schema_cd = cp_new_grading_schema_cd AND
2477: version_number = cp_new_version_number;
2478: CURSOR c_gs_old (
2479: cp_old_grading_schema_cd IN IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE,
2480: cp_old_version_number IN IGS_AS_GRD_SCHEMA.version_number%TYPE) IS
2481: SELECT cst_exist_ind
2482: FROM IGS_AS_GRD_SCHEMA
2483: WHERE grading_schema_cd = cp_old_grading_schema_cd AND

Line 2480: cp_old_version_number IN IGS_AS_GRD_SCHEMA.version_number%TYPE) IS

2476: WHERE grading_schema_cd = cp_new_grading_schema_cd AND
2477: version_number = cp_new_version_number;
2478: CURSOR c_gs_old (
2479: cp_old_grading_schema_cd IN IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE,
2480: cp_old_version_number IN IGS_AS_GRD_SCHEMA.version_number%TYPE) IS
2481: SELECT cst_exist_ind
2482: FROM IGS_AS_GRD_SCHEMA
2483: WHERE grading_schema_cd = cp_old_grading_schema_cd AND
2484: version_number = cp_old_version_number;

Line 2482: FROM IGS_AS_GRD_SCHEMA

2478: CURSOR c_gs_old (
2479: cp_old_grading_schema_cd IN IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE,
2480: cp_old_version_number IN IGS_AS_GRD_SCHEMA.version_number%TYPE) IS
2481: SELECT cst_exist_ind
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,

Line 2497: v_grading_schema_cd IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE;

2493: v_gs_old_rec c_gs_old%ROWTYPE;
2494: v_gs_new_rec c_gs_new%ROWTYPE;
2495: v_gsg_rec c_gsg%ROWTYPE;
2496: v_copy_flag BOOLEAN;
2497: v_grading_schema_cd IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE;
2498: v_version_number IGS_AS_GRD_SCHEMA.version_number%TYPE;
2499: BEGIN
2500: -- Set the default message number
2501: p_message_name := NULL;

Line 2498: v_version_number IGS_AS_GRD_SCHEMA.version_number%TYPE;

2494: v_gs_new_rec c_gs_new%ROWTYPE;
2495: v_gsg_rec c_gsg%ROWTYPE;
2496: v_copy_flag BOOLEAN;
2497: v_grading_schema_cd IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE;
2498: v_version_number IGS_AS_GRD_SCHEMA.version_number%TYPE;
2499: BEGIN
2500: -- Set the default message number
2501: p_message_name := NULL;
2502: OPEN c_gs_new(