APPS.IGS_PRECREATE_APPL_PUB dependencies on IGS_EN_ATD_TYPE

Line 797: FROM IGS_EN_ATD_TYPE

793:
794: -- Cursor to validate Attendance Type
795: CURSOR c_att_type(p_attendance_type VARCHAR2) IS
796: SELECT attendance_type
797: FROM IGS_EN_ATD_TYPE
798: WHERE attendance_type = p_attendance_type;
799:
800: -- Cursor to validate Attendance Mode
801: CURSOR c_att_mode(p_attendance_mode VARCHAR2) IS

Line 813: IGS_EN_ATD_TYPE atd_type

809: SELECT acopv.ACAD_CAL_TYPE
810: FROM IGS_PS_OFR_PAT_OFERPAT_V acopv,
811: IGS_AD_LOCATION loc,
812: IGS_EN_ATD_MODE atd_mode,
813: IGS_EN_ATD_TYPE atd_type
814: WHERE
815: (IGS_AD_GEN_013.ADMS_GET_COO_CRV(
816: acopv.course_cd,
817: acopv.version_number,

Line 860: l_att_type_rec IGS_EN_ATD_TYPE.ATTENDANCE_TYPE%TYPE := NULL;

856: /* ******************* Put additional parameters here ******************************************** */
857: l_admappl_rec c_admappl%ROWTYPE := NULL;
858: l_sch_apl_to_rec IGS_AD_SCHL_APLY_TO.sch_apl_to_id%TYPE := NULL;
859: l_location_rec IGS_AD_LOCATION.location_cd%TYPE := NULL;
860: l_att_type_rec IGS_EN_ATD_TYPE.ATTENDANCE_TYPE%TYPE := NULL;
861: l_att_mode_rec IGS_EN_ATD_MODE.ATTENDANCE_MODE%TYPE := NULL;
862: l_off_pattern_rec IGS_PS_OFR_PAT_OFERPAT_V.ACAD_CAL_TYPE%TYPE := NULL;
863: l_pref_limit_rec IGS_AD_PRCS_CAT_STEP.S_ADMISSION_STEP_TYPE%TYPE := NULL;
864: l_prog_inst_rec IGS_SS_APP_PGM_STG.SS_ADMAPPL_PGM_ID%TYPE := NULL;

Line 1426: a) That the individual values exist in OSS Tables IGS_AD_SCHL_APLY_TO, IGS_AD_LOCATION, IGS_EN_ATD_MODE, IGS_EN_ATD_TYPE resp.

1422:
1423:
1424: /*
1425: For the parameters p_sch_apl_to_id, p_location_cd, p_attendance_type and p_attendance_mode there will be 2 kinds of validations:
1426: a) That the individual values exist in OSS Tables IGS_AD_SCHL_APLY_TO, IGS_AD_LOCATION, IGS_EN_ATD_MODE, IGS_EN_ATD_TYPE resp.
1427: b) That the combination of these parameter values is a part of a valid Offering Option corresponding to this Application's Calendar and Application Type.
1428: */
1429:
1430: -- validate p_sch_apl_to_id