APPS.IGS_AS_ANON_GRD_PKG dependencies on IGS_AS_ASSESSMNT_ITM

Line 17: p_ass_id IN igs_as_assessmnt_itm_all.ass_id%TYPE

13: */
14:
15: FUNCTION chk_anon_graded (
16: p_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
17: p_ass_id IN igs_as_assessmnt_itm_all.ass_id%TYPE
18: ) RETURN VARCHAR2 IS
19: /*
20: || Created By : pkpatel
21: || Created On : 28-JAN-2002

Line 49: igs_as_assessmnt_itm ai,

45: AND (anm.method <> 'ASSESSMENT'
46: OR (anm.method = 'ASSESSMENT'
47: AND (EXISTS ( SELECT 'X'
48: FROM igs_ps_unitass_item uooai,
49: igs_as_assessmnt_itm ai,
50: igs_as_assessmnt_typ ast
51: WHERE uooai.uoo_id = uoo.uoo_id
52: AND uooai.logical_delete_dt IS NULL
53: AND uooai.ass_id = ai.ass_id

Line 59: igs_as_assessmnt_itm ai,

55: AND ai.assessment_type = ast.assessment_type
56: AND ast.anon_grading_ind = 'Y')
57: OR EXISTS ( SELECT 'X'
58: FROM igs_as_unitass_item uoai,
59: igs_as_assessmnt_itm ai,
60: igs_as_assessmnt_typ ast,
61: igs_as_unit_class uc
62: WHERE uoai.unit_cd = uoo.unit_cd
63: AND uoai.version_number = uoo.version_number

Line 96: igs_as_assessmnt_itm ai,

92: AND uoo.ci_sequence_number = ttl2.teach_ci_sequence_number)
93: AND anm.load_cal_type = ttl.load_cal_type
94: AND (EXISTS ( SELECT 'X'
95: FROM igs_ps_unitass_item uooai,
96: igs_as_assessmnt_itm ai,
97: igs_as_assessmnt_typ ast
98: WHERE uooai.uoo_id = uoo.uoo_id
99: AND uooai.ass_id = p_ass_id
100: AND uooai.logical_delete_dt IS NULL

Line 106: igs_as_assessmnt_itm ai,

102: AND ai.assessment_type = ast.assessment_type
103: AND ast.anon_grading_ind = 'Y')
104: OR EXISTS ( SELECT 'X'
105: FROM igs_as_unitass_item uoai,
106: igs_as_assessmnt_itm ai,
107: igs_as_assessmnt_typ ast,
108: igs_as_unit_class uc
109: WHERE uoai.unit_cd = uoo.unit_cd
110: AND uoai.version_number = uoo.version_number

Line 453: igs_as_assessmnt_itm ai

449: AND ((uoo.anon_assess_grading_ind = 'Y'
450: AND ast.anon_grading_ind = 'Y'
451: AND EXISTS (SELECT 'X'
452: FROM igs_as_su_atmpt_itm suaai,
453: igs_as_assessmnt_itm ai
454: WHERE sua.person_id = suaai.person_id
455: AND sua.course_cd = suaai.course_cd
456: AND sua.unit_cd = suaai.unit_cd
457: AND sua.cal_type = suaai.cal_type

Line 544: igs_as_assessmnt_itm ai

540: AND ((uoo.anon_assess_grading_ind = 'Y'
541: AND ast.anon_grading_ind = 'Y'
542: AND EXISTS (SELECT 'X'
543: FROM igs_as_su_atmpt_itm suaai,
544: igs_as_assessmnt_itm ai
545: WHERE sua.person_id = suaai.person_id
546: AND sua.course_cd = suaai.course_cd
547: AND sua.unit_cd = suaai.unit_cd
548: AND sua.cal_type = suaai.cal_type

Line 975: p_ass_id IN igs_as_assessmnt_itm_all.ass_id%TYPE,

971: p_unit_cd IN igs_en_su_attempt_all.unit_cd%TYPE,
972: p_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE,
973: p_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
974: p_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
975: p_ass_id IN igs_as_assessmnt_itm_all.ass_id%TYPE,
976: p_unit_grading_ind IN VARCHAR2
977: ) RETURN VARCHAR2 IS
978: /*
979: || Created By : pkpatel

Line 1014: igs_as_assessmnt_itm ai

1010: AND p_ass_id IS NOT NULL
1011: AND uoo.anon_assess_grading_ind = 'Y'
1012: AND 'Y' = ( SELECT ast.anon_grading_ind
1013: FROM igs_as_assessmnt_typ ast,
1014: igs_as_assessmnt_itm ai
1015: WHERE ai.ass_id = p_ass_id
1016: AND ai.assessment_type = ast.assessment_type)));
1017:
1018: CURSOR c_aniu

Line 1048: igs_as_assessmnt_itm ai

1044: AND p_ass_id IS NOT NULL
1045: AND uoo.anon_assess_grading_ind = 'Y'
1046: AND 'Y' = ( SELECT ast.anon_grading_ind
1047: FROM igs_as_assessmnt_typ ast,
1048: igs_as_assessmnt_itm ai
1049: WHERE ai.ass_id = p_ass_id
1050: AND ai.assessment_type = ast.assessment_type)));
1051:
1052: CURSOR c_ania

Line 1090: igs_as_assessmnt_itm ai

1086: AND p_unit_grading_ind = 'N'
1087: AND uoo.anon_assess_grading_ind = 'Y'
1088: AND ania.assessment_type = (SELECT ai.assessment_type
1089: FROM igs_as_assessmnt_typ ast,
1090: igs_as_assessmnt_itm ai
1091: WHERE ai.ass_id = p_ass_id
1092: AND ai.assessment_type = ast.assessment_type
1093: AND ast.anon_grading_ind = 'Y')));
1094: