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_ANON_GRD_PKG dependencies on IGS_AS_ANON_METHOD

Line 34: igs_as_anon_method anm,

30: CURSOR c_uoo_ug
31: IS
32: SELECT 'X'
33: FROM igs_ps_unit_ofr_opt uoo,
34: igs_as_anon_method anm,
35: igs_ca_teach_to_load_v ttl
36: WHERE uoo.uoo_id = p_uoo_id
37: AND uoo.anon_unit_grading_ind = 'Y'
38: AND uoo.cal_type = ttl.teach_cal_type

Line 83: igs_as_anon_method anm,

79: CURSOR c_uoo_ai
80: IS
81: SELECT 'X'
82: FROM igs_ps_unit_ofr_opt uoo,
83: igs_as_anon_method anm,
84: igs_ca_teach_to_load_v ttl
85: WHERE uoo.uoo_id = p_uoo_id
86: AND uoo.anon_assess_grading_ind = 'Y'
87: AND uoo.cal_type = ttl.teach_cal_type

Line 178: p_method IN igs_as_anon_method.method%TYPE,

174:
175: END chk_anon_graded;
176:
177: PROCEDURE sub_get_insert(
178: p_method IN igs_as_anon_method.method%TYPE,
179: p_person_id IN hz_parties.party_id%TYPE,
180: p_course_cd IN igs_en_su_attempt_all.course_cd%TYPE,
181: p_unit_cd IN igs_en_su_attempt_all.unit_cd%TYPE,
182: p_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE,

Line 354: l_method igs_as_anon_method.method%TYPE;

350: l_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;
351: l_anon_id_count NUMBER;
352: l_anon_id_required NUMBER;
353: l_rowid ROWID;
354: l_method igs_as_anon_method.method%TYPE;
355: l_anum_id NUMBER(15);
356:
357: -- Exception to handle the error in parameters.
358: PARAM_ERROR EXCEPTION;

Line 361: CURSOR c_method(cp_load_cal_type igs_as_anon_method.load_cal_type%TYPE)

357: -- Exception to handle the error in parameters.
358: PARAM_ERROR EXCEPTION;
359:
360: -- Find Anonymous Grading Method for the Load Cal Type supplied
361: CURSOR c_method(cp_load_cal_type igs_as_anon_method.load_cal_type%TYPE)
362: IS
363: SELECT anm.method
364: FROM igs_as_anon_method anm
365: WHERE anm.load_cal_type = cp_load_cal_type;

Line 364: FROM igs_as_anon_method anm

360: -- Find Anonymous Grading Method for the Load Cal Type supplied
361: CURSOR c_method(cp_load_cal_type igs_as_anon_method.load_cal_type%TYPE)
362: IS
363: SELECT anm.method
364: FROM igs_as_anon_method anm
365: WHERE anm.load_cal_type = cp_load_cal_type;
366:
367: -- COUNT the NUMBER of Anonymous Numbers available for ASSESSMENT/SECTION methods
368: CURSOR c_count_anon_num(cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,

Line 463: FROM igs_as_anon_method anm

459: AND suaai.ass_id = ai.ass_id
460: AND ai.assessment_type = ast.assessment_type))
461: OR (uoo.anon_unit_grading_ind = 'Y'
462: AND EXISTS (SELECT 'X'
463: FROM igs_as_anon_method anm
464: WHERE anm.load_cal_type = cp_load_cal_type
465: AND anm.assessment_type = ast.assessment_type)))
466: AND NOT EXISTS (SELECT 'X'
467: FROM igs_as_anon_id_ass ania

Line 554: FROM igs_as_anon_method anm

550: AND suaai.ass_id = ai.ass_id
551: AND ai.assessment_type = ast.assessment_type))
552: OR (uoo.anon_unit_grading_ind = 'Y'
553: AND EXISTS (SELECT 'X'
554: FROM igs_as_anon_method anm
555: WHERE anm.load_cal_type = cp_load_cal_type
556: AND anm.assessment_type = ast.assessment_type)))
557: AND NOT EXISTS (SELECT 'X'
558: FROM igs_as_anon_id_ass ania

Line 1082: FROM igs_as_anon_method anm

1078: AND ttl2.teach_ci_sequence_number = p_teach_ci_sequence_number)
1079: AND ( ( p_unit_grading_ind = 'Y'
1080: AND uoo.anon_unit_grading_ind = 'Y'
1081: AND ania.assessment_type = (SELECT anm.assessment_type
1082: FROM igs_as_anon_method anm
1083: WHERE anm.method = 'ASSESSMENT'
1084: AND anm.load_cal_type = ttl.load_cal_type))
1085: OR ( p_ass_id IS NOT NULL
1086: AND p_unit_grading_ind = 'N'

Line 1099: igs_as_anon_method anm

1095: CURSOR c_method
1096: IS
1097: SELECT anm.method
1098: FROM igs_ca_teach_to_load_v ttl,
1099: igs_as_anon_method anm
1100: WHERE ttl.teach_cal_type = p_teach_cal_type
1101: AND ttl.teach_ci_sequence_number = p_teach_ci_sequence_number
1102: AND ttl.load_start_dt = (SELECT MIN(ttl2.load_start_dt)
1103: FROM igs_ca_teach_to_load_v ttl2

Line 1242: igs_as_anon_method anm

1238: CURSOR c_method
1239: IS
1240: SELECT anm.method
1241: FROM igs_ca_teach_to_load_v ttl,
1242: igs_as_anon_method anm
1243: WHERE ttl.teach_cal_type = p_teach_cal_type
1244: AND ttl.teach_ci_sequence_number = p_teach_ci_sequence_number
1245: AND ttl.load_start_dt = (SELECT MIN(ttl2.load_start_dt)
1246: FROM igs_ca_teach_to_load_v ttl2

Line 1321: p_method IN igs_as_anon_method.METHOD%TYPE,

1317:
1318:
1319: FUNCTION user_anon_id (
1320: p_anonymous_number IN varchar2,
1321: p_method IN igs_as_anon_method.METHOD%TYPE,
1322: p_person_id IN hz_parties.party_id%TYPE,
1323: p_course_cd IN igs_en_su_attempt_all.course_cd%TYPE,
1324: p_unit_cd IN igs_en_su_attempt_all.unit_cd%TYPE,
1325: p_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE,