APPS.IGS_AS_GEN_006 dependencies on IGS_AS_UNIT_MODE

Line 149: p_unit_mode igs_as_unit_mode.unit_mode%TYPE;

145: p_teach_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
146: p_org_unit_cd igs_or_unit.org_unit_cd%TYPE;
147: p_unit_cd igs_ps_unit.unit_cd%TYPE;
148: p_location_cd igs_ad_location.location_cd%TYPE;
149: p_unit_mode igs_as_unit_mode.unit_mode%TYPE;
150: p_unit_class igs_as_unit_class.unit_class%TYPE;
151: p_assessable_type igs_lookups_view.lookup_code%TYPE;
152: p_no_assessment_type igs_lookups_view.lookup_code%TYPE;
153: --

Line 1012: p_unit_mode IGS_AS_UNIT_MODE.UNIT_MODE%TYPE;

1008: p_course_cd IGS_PS_COURSE.COURSE_CD%TYPE;
1009: p_unit_cd IGS_PS_UNIT.UNIT_CD%TYPE;
1010: p_location_cd IGS_AD_LOCATION.LOCATION_CD%TYPE;
1011: p_unit_class IGS_AS_UNIT_CLASS.UNIT_CLASS%TYPE;
1012: p_unit_mode IGS_AS_UNIT_MODE.UNIT_MODE%TYPE;
1013: p_reproduce IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE ;
1014: --------------------------------------------------------------------------------------------------------------------------
1015: --Change History:
1016: --Who When What

Line 1347: FROM IGS_AS_UNIT_MODE

1343: uv.version_number = sua.version_number;
1344: CURSOR c_um(
1345: cp_unit_mode IGS_AS_UNIT_CLASS.UNIT_MODE%TYPE) IS
1346: SELECT s_unit_mode
1347: FROM IGS_AS_UNIT_MODE
1348: WHERE UNIT_MODE = cp_unit_mode;
1349:
1350: CURSOR c_suaav(
1351: cp_person_id IGS_AS_SU_ATMPT_ITM.person_id%TYPE,