APPS.IGS_AS_VAL_UAI dependencies on IGS_AS_ASSESSMNT_ITM

Line 12: p_ass_id IN IGS_AS_ASSESSMNT_ITM_ALL.ass_id%TYPE ,

8: -- function GENP_VAL_SDTT_SESS
9: -------------------------------------------------------------------------------------------
10: -- Validate assessment item exists
11: FUNCTION assp_val_ai_exists(
12: p_ass_id IN IGS_AS_ASSESSMNT_ITM_ALL.ass_id%TYPE ,
13: p_message_name OUT NOCOPY VARCHAR2 )
14: RETURN BOOLEAN IS
15: gv_other_detail VARCHAR2(255);
16: BEGIN -- assp_val_ai_exists

Line 20: cp_ass_id IGS_AS_ASSESSMNT_ITM.ass_id%TYPE) IS

16: BEGIN -- assp_val_ai_exists
17: --Validate that the assessment item exists.
18: DECLARE
19: CURSOR c_ai (
20: cp_ass_id IGS_AS_ASSESSMNT_ITM.ass_id%TYPE) IS
21: SELECT COUNT(*)
22: FROM IGS_AS_ASSESSMNT_ITM
23: WHERE ass_id = cp_ass_id;
24: v_ai_count NUMBER;

Line 22: FROM IGS_AS_ASSESSMNT_ITM

18: DECLARE
19: CURSOR c_ai (
20: cp_ass_id IGS_AS_ASSESSMNT_ITM.ass_id%TYPE) IS
21: SELECT COUNT(*)
22: FROM IGS_AS_ASSESSMNT_ITM
23: WHERE ass_id = cp_ass_id;
24: v_ai_count NUMBER;
25: BEGIN
26: -- Set the default message number

Line 299: IGS_AS_ASSESSMNT_ITM ai,

295: DECLARE
296: CURSOR c_uai IS
297: SELECT 'x'
298: FROM IGS_AS_ASSESSMNT_TYP atyp,
299: IGS_AS_ASSESSMNT_ITM ai,
300: IGS_AS_UNITASS_ITEM uai
301: WHERE atyp.examinable_ind = 'Y' AND
302: ai.assessment_type = atyp.assessment_type AND
303: uai.ass_id = ai.ass_id AND

Line 366: IGS_AS_ASSESSMNT_ITM ai,

362: DECLARE
363: CURSOR c_uai IS
364: SELECT 'x'
365: FROM IGS_AS_ASSESSMNT_TYP atyp,
366: IGS_AS_ASSESSMNT_ITM ai,
367: IGS_PS_UNITASS_ITEM uai,
368: IGS_PS_UNIT_OFR_OPT uoo
369: WHERE atyp.examinable_ind = 'Y' AND
370: ai.assessment_type = atyp.assessment_type AND

Line 438: IGS_AS_ASSESSMNT_ITM ai,

434: DECLARE
435: CURSOR c_uai IS
436: SELECT 'x'
437: FROM IGS_AS_UNITASS_ITEM uai,
438: IGS_AS_ASSESSMNT_ITM ai,
439: IGS_AS_ASSESSMNT_TYP atyp
440: WHERE atyp.examinable_ind = 'N' AND
441: atyp.ASSESSMENT_TYPE = p_assessment_type AND
442: atyp.ASSESSMENT_TYPE = ai.ASSESSMENT_TYPE AND

Line 518: IGS_AS_ASSESSMNT_ITM ai,

514: DECLARE
515: CURSOR c_uai IS
516: SELECT 'x'
517: FROM IGS_AS_ASSESSMNT_TYP atyp,
518: IGS_AS_ASSESSMNT_ITM ai,
519: IGS_AS_UNITASS_ITEM uai
520: WHERE atyp.examinable_ind = 'Y' AND
521: ai.assessment_type = atyp.assessment_type AND
522: uai.ass_id = ai.ass_id AND