APPS.IGS_AS_VAL_AI dependencies on IGS_AS_ASSESSMNT_TYP

Line 27: FROM IGS_AS_ASSESSMNT_TYP

23: DECLARE
24: CURSOR c_atyp(
25: cp_assessment_type IGS_AS_ASSESSMNT_ITM.assessment_type%TYPE) IS
26: SELECT examinable_ind
27: FROM IGS_AS_ASSESSMNT_TYP
28: WHERE assessment_type = cp_assessment_type;
29: v_atyp_rec c_atyp%ROWTYPE;
30: cst_yes CONSTANT CHAR := 'Y';
31: BEGIN

Line 92: FROM IGS_AS_ASSESSMNT_TYP

88: DECLARE
89: CURSOR c_atyp(
90: cp_assessment_type IGS_AS_ASSESSMNT_ITM.assessment_type%TYPE) IS
91: SELECT examinable_ind
92: FROM IGS_AS_ASSESSMNT_TYP
93: WHERE assessment_type = cp_assessment_type;
94: v_atyp_rec c_atyp%ROWTYPE;
95: cst_yes CONSTANT CHAR := 'Y';
96: v_exam_working_time VARCHAR2(10);

Line 137: p_assessment_type IN IGS_AS_ASSESSMNT_TYP.assessment_type%TYPE ,

133: END assp_val_ai_ex_times;
134: --
135: -- Validate assessment type closed indicator.
136: FUNCTION assp_val_atyp_closed(
137: p_assessment_type IN IGS_AS_ASSESSMNT_TYP.assessment_type%TYPE ,
138: P_MESSAGE_NAME OUT NOCOPY VARCHAR2 )
139: RETURN BOOLEAN AS
140: V_MESSAGE_NAME VARCHAR2(30);
141: BEGIN -- assp_val_atyp_closed

Line 145: cp_assessment_type IGS_AS_ASSESSMNT_TYP.assessment_type%TYPE) IS

141: BEGIN -- assp_val_atyp_closed
142: -- Validate the assessemnt type closed indicator
143: DECLARE
144: CURSOR c_atyp(
145: cp_assessment_type IGS_AS_ASSESSMNT_TYP.assessment_type%TYPE) IS
146: SELECT closed_ind
147: FROM IGS_AS_ASSESSMNT_TYP
148: WHERE assessment_type = cp_assessment_type;
149: v_atyp_rec c_atyp%ROWTYPE;

Line 147: FROM IGS_AS_ASSESSMNT_TYP

143: DECLARE
144: CURSOR c_atyp(
145: cp_assessment_type IGS_AS_ASSESSMNT_TYP.assessment_type%TYPE) IS
146: SELECT closed_ind
147: FROM IGS_AS_ASSESSMNT_TYP
148: WHERE assessment_type = cp_assessment_type;
149: v_atyp_rec c_atyp%ROWTYPE;
150: cst_yes CONSTANT CHAR := 'Y';
151: BEGIN

Line 192: v_atyp_s_ass_type IGS_AS_ASSESSMNT_TYP.s_assessment_type%TYPE;

188: -- type, that no IGS_AS_UNITASS_ITEM records exist within a unitoffering
189: -- pattern that will have the same reference and type.
190: DECLARE
191: v_dummy VARCHAR2(1);
192: v_atyp_s_ass_type IGS_AS_ASSESSMNT_TYP.s_assessment_type%TYPE;
193: v_atyp_examinable_ind IGS_AS_ASSESSMNT_TYP.examinable_ind%TYPE;
194: cst_assignment CONSTANT VARCHAR2(10) := 'ASSIGNMENT';
195: CURSOR c_uai IS
196: SELECT 'x'

Line 193: v_atyp_examinable_ind IGS_AS_ASSESSMNT_TYP.examinable_ind%TYPE;

189: -- pattern that will have the same reference and type.
190: DECLARE
191: v_dummy VARCHAR2(1);
192: v_atyp_s_ass_type IGS_AS_ASSESSMNT_TYP.s_assessment_type%TYPE;
193: v_atyp_examinable_ind IGS_AS_ASSESSMNT_TYP.examinable_ind%TYPE;
194: cst_assignment CONSTANT VARCHAR2(10) := 'ASSIGNMENT';
195: CURSOR c_uai IS
196: SELECT 'x'
197: FROM IGS_AS_UNITASS_ITEM uai

Line 215: CURSOR c_atyp ( cp_assessment_type IGS_AS_ASSESSMNT_TYP.assessment_type%TYPE) IS

211: FROM IGS_AS_ASSESSMNT_ITM ai
212: WHERE ai.ass_id = uai2.ass_id AND
213: ai.assessment_type = p_assessment_type)) AND
214: uai.logical_delete_dt IS NULL;
215: CURSOR c_atyp ( cp_assessment_type IGS_AS_ASSESSMNT_TYP.assessment_type%TYPE) IS
216: SELECT atyp.s_assessment_type,
217: atyp.examinable_ind
218: FROM IGS_AS_ASSESSMNT_TYP atyp
219: WHERE atyp.assessment_type = cp_assessment_type;

Line 218: FROM IGS_AS_ASSESSMNT_TYP atyp

214: uai.logical_delete_dt IS NULL;
215: CURSOR c_atyp ( cp_assessment_type IGS_AS_ASSESSMNT_TYP.assessment_type%TYPE) IS
216: SELECT atyp.s_assessment_type,
217: atyp.examinable_ind
218: FROM IGS_AS_ASSESSMNT_TYP atyp
219: WHERE atyp.assessment_type = cp_assessment_type;
220: CURSOR c_suaai IS
221: SELECT 'x'
222: FROM IGS_AS_SU_ATMPT_ITM suaai

Line 236: IGS_AS_ASSESSMNT_TYP atyp

232: EXISTS (
233: SELECT 'x'
234: FROM IGS_AS_UNITASS_ITEM uai2,
235: IGS_AS_ASSESSMNT_ITM ai,
236: IGS_AS_ASSESSMNT_TYP atyp
237: WHERE uai2.unit_cd = uai.unit_cd AND
238: uai2.version_number = uai.version_number AND
239: uai2.cal_type = uai.cal_type AND
240: uai2.ci_sequence_number = uai.ci_sequence_number AND