APPS.IGS_PRECREATE_APPL_PUB dependencies on IGS_AD_SCHL_APLY_TO

Line 785: FROM IGS_AD_SCHL_APLY_TO

781:
782: -- Cursor to validate School Applying To
783: CURSOR c_sch_apl_to(p_sch_apl_to_id NUMBER) IS
784: SELECT sch_apl_to_id
785: FROM IGS_AD_SCHL_APLY_TO
786: WHERE sch_apl_to_id = p_sch_apl_to_id;
787:
788: -- Cursor to validate Location Code
789: CURSOR c_location(p_location_cd VARCHAR2) IS

Line 858: l_sch_apl_to_rec IGS_AD_SCHL_APLY_TO.sch_apl_to_id%TYPE := NULL;

854: WHERE SS_ADM_APPL_ID = p_ss_adm_appl_id;
855:
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;

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