APPS.IGS_AS_GEN_002 dependencies on IGS_AS_ASSESSMNT_ITM

Line 5: p_assessment_type IN igs_as_assessmnt_itm_all.assessment_type%TYPE

1: PACKAGE BODY igs_as_gen_002 AS
2: /* $Header: IGSAS02B.pls 115.10 2003/12/12 15:48:33 kdande ship $ */
3:
4: FUNCTION assp_get_atyp_exmnbl (
5: p_assessment_type IN igs_as_assessmnt_itm_all.assessment_type%TYPE
6: ) RETURN VARCHAR2 IS
7: gv_other_detail VARCHAR2 (255);
8: BEGIN -- assp_get_atyp_exmnbl
9: -- This module fetches the value for the examinable_ind

Line 395: CURSOR c_atyp (cp_ass_id igs_as_assessmnt_itm.ass_id%TYPE) IS

391: gv_other_detail VARCHAR2 (255);
392: BEGIN -- assp_get_ai_s_type
393: -- Return the system type of an assessment item.
394: DECLARE
395: CURSOR c_atyp (cp_ass_id igs_as_assessmnt_itm.ass_id%TYPE) IS
396: SELECT s_assessment_type
397: FROM igs_as_assessmnt_typ atyp,
398: igs_as_assessmnt_itm ai
399: WHERE ai.ass_id = cp_ass_id

Line 398: igs_as_assessmnt_itm ai

394: DECLARE
395: CURSOR c_atyp (cp_ass_id igs_as_assessmnt_itm.ass_id%TYPE) IS
396: SELECT s_assessment_type
397: FROM igs_as_assessmnt_typ atyp,
398: igs_as_assessmnt_itm ai
399: WHERE ai.ass_id = cp_ass_id
400: AND ai.assessment_type = atyp.assessment_type;
401: v_atyp_rec c_atyp%ROWTYPE;
402: BEGIN