APPS.IGS_AD_GEN_014 dependencies on IGS_EN_UNIT_SET

Line 1518: v_s_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;

1514: cst_active CONSTANT VARCHAR2(6) := 'ACTIVE';
1515: cst_yes CONSTANT VARCHAR2(1) := 'Y';
1516: cst_error CONSTANT VARCHAR2(1) := 'E';
1517: cst_warn CONSTANT VARCHAR2(1) := 'W';
1518: v_s_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;
1519: v_expiry_dt IGS_EN_UNIT_SET.expiry_dt%TYPE;
1520: v_message_name VARCHAR2(30);
1521: v_coousv_match BOOLEAN DEFAULT FALSE;
1522: v_coacus_match BOOLEAN DEFAULT FALSE;

Line 1519: v_expiry_dt IGS_EN_UNIT_SET.expiry_dt%TYPE;

1515: cst_yes CONSTANT VARCHAR2(1) := 'Y';
1516: cst_error CONSTANT VARCHAR2(1) := 'E';
1517: cst_warn CONSTANT VARCHAR2(1) := 'W';
1518: v_s_unit_set_status IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;
1519: v_expiry_dt IGS_EN_UNIT_SET.expiry_dt%TYPE;
1520: v_message_name VARCHAR2(30);
1521: v_coousv_match BOOLEAN DEFAULT FALSE;
1522: v_coacus_match BOOLEAN DEFAULT FALSE;
1523: v_coacus_rec_found BOOLEAN DEFAULT FALSE;

Line 1526: cp_unit_set_cd IGS_EN_UNIT_SET.unit_set_cd%TYPE,

1522: v_coacus_match BOOLEAN DEFAULT FALSE;
1523: v_coacus_rec_found BOOLEAN DEFAULT FALSE;
1524:
1525: CURSOR c_us_uss (
1526: cp_unit_set_cd IGS_EN_UNIT_SET.unit_set_cd%TYPE,
1527: cp_us_version_number IGS_EN_UNIT_SET.version_number%TYPE) IS
1528: SELECT uss.s_unit_set_status,
1529: us.expiry_dt
1530: FROM IGS_EN_UNIT_SET us,

Line 1527: cp_us_version_number IGS_EN_UNIT_SET.version_number%TYPE) IS

1523: v_coacus_rec_found BOOLEAN DEFAULT FALSE;
1524:
1525: CURSOR c_us_uss (
1526: cp_unit_set_cd IGS_EN_UNIT_SET.unit_set_cd%TYPE,
1527: cp_us_version_number IGS_EN_UNIT_SET.version_number%TYPE) IS
1528: SELECT uss.s_unit_set_status,
1529: us.expiry_dt
1530: FROM IGS_EN_UNIT_SET us,
1531: IGS_EN_UNIT_SET_STAT uss

Line 1530: FROM IGS_EN_UNIT_SET us,

1526: cp_unit_set_cd IGS_EN_UNIT_SET.unit_set_cd%TYPE,
1527: cp_us_version_number IGS_EN_UNIT_SET.version_number%TYPE) IS
1528: SELECT uss.s_unit_set_status,
1529: us.expiry_dt
1530: FROM IGS_EN_UNIT_SET us,
1531: IGS_EN_UNIT_SET_STAT uss
1532: WHERE us.unit_set_cat IN
1533: ( SELECT usc.unit_set_cat
1534: FROM igs_en_unit_set_cat usc

Line 1531: IGS_EN_UNIT_SET_STAT uss

1527: cp_us_version_number IGS_EN_UNIT_SET.version_number%TYPE) IS
1528: SELECT uss.s_unit_set_status,
1529: us.expiry_dt
1530: FROM IGS_EN_UNIT_SET us,
1531: IGS_EN_UNIT_SET_STAT uss
1532: WHERE us.unit_set_cat IN
1533: ( SELECT usc.unit_set_cat
1534: FROM igs_en_unit_set_cat usc
1535: WHERE (fnd_profile.value ('IGS_PS_PRENRL_YEAR_IND' ) <> 'Y'

Line 1534: FROM igs_en_unit_set_cat usc

1530: FROM IGS_EN_UNIT_SET us,
1531: IGS_EN_UNIT_SET_STAT uss
1532: WHERE us.unit_set_cat IN
1533: ( SELECT usc.unit_set_cat
1534: FROM igs_en_unit_set_cat usc
1535: WHERE (fnd_profile.value ('IGS_PS_PRENRL_YEAR_IND' ) <> 'Y'
1536: OR usc.s_unit_set_cat = 'PRENRL_YR') )
1537: AND us.UNIT_SET_STATUS = uss.UNIT_SET_STATUS
1538: AND us.unit_set_cd = cp_unit_set_cd

Line 1575: FROM igs_en_unit_set_stat uss

1571: AND psus.admission_cat = cp_admission_cat
1572: )
1573: AND psusv.UNIT_SET_STATUS IN
1574: (SELECT unit_set_status
1575: FROM igs_en_unit_set_stat uss
1576: WHERE psusv.unit_set_status = uss.unit_set_status
1577: AND uss.s_unit_set_status <> 'INACTIVE'
1578: )
1579: AND psusv.unit_set_cat IN

Line 1581: FROM igs_en_unit_set_cat usc

1577: AND uss.s_unit_set_status <> 'INACTIVE'
1578: )
1579: AND psusv.unit_set_cat IN
1580: (SELECT usc.unit_set_cat
1581: FROM igs_en_unit_set_cat usc
1582: WHERE ((fnd_profile.value ('IGS_PS_PRENRL_YEAR_IND') <> 'Y'
1583: OR usc.s_unit_set_cat = 'PRENRL_YR'))
1584: )
1585: AND psusv.expiry_dt IS NULL

Line 1589: igs_en_unit_set us

1585: AND psusv.expiry_dt IS NULL
1586: UNION
1587: SELECT 1
1588: FROM igs_ps_coo_ad_unit_s psus,
1589: igs_en_unit_set us
1590: WHERE us.unit_set_cd = psus.unit_set_cd
1591: AND us.version_number = psus.us_version_number
1592: AND psus.unit_set_cd = cp_unit_set_cd
1593: AND psus.us_version_number = cp_us_version_number

Line 1603: FROM igs_en_unit_set_stat uss

1599: AND psus.attendance_type = NVL(cp_attendance_type, psus.attendance_type)
1600: AND psus.admission_cat = cp_admission_cat
1601: AND us.unit_set_status IN
1602: (SELECT unit_set_status
1603: FROM igs_en_unit_set_stat uss
1604: WHERE us.unit_set_status = uss.unit_set_status
1605: AND uss.s_unit_set_status <> 'INACTIVE'
1606: )
1607: AND us.unit_set_cat IN

Line 1609: FROM igs_en_unit_set_cat usc

1605: AND uss.s_unit_set_status <> 'INACTIVE'
1606: )
1607: AND us.unit_set_cat IN
1608: (SELECT usc.unit_set_cat
1609: FROM igs_en_unit_set_cat usc
1610: WHERE ((fnd_profile.value ('IGS_PS_PRENRL_YEAR_IND') <> 'Y'
1611: OR usc.s_unit_set_cat = 'PRENRL_YR'))
1612: )
1613: AND us.expiry_dt IS NULL;