APPS.IGS_EN_DROP_UNITS_API dependencies on IGS_EN_DCNT_REASONCD

Line 95: p_dcnt_reason_cd IN igs_en_dcnt_reasoncd.discontinuation_reason_cd%TYPE,

91: p_load_sequence_number IN igs_ca_inst.sequence_number%TYPE,
92: p_enr_cat IN igs_ps_type.enrolment_cat%TYPE,
93: p_enr_comm IN VARCHAR2,
94: p_enr_meth_type IN igs_en_method_type.enr_method_type%TYPE,
95: p_dcnt_reason_cd IN igs_en_dcnt_reasoncd.discontinuation_reason_cd%TYPE,
96: p_admin_unit_status IN VARCHAR2,
97: p_effective_date IN DATE,
98: p_deny_warn_coreq IN VARCHAR2,
99: p_deny_warn_prereq IN VARCHAR2,

Line 673: p_dcnt_reason_cd IN igs_en_dcnt_reasoncd.discontinuation_reason_cd%TYPE,

669: p_load_sequence_number IN igs_ca_inst.sequence_number%TYPE,
670: p_enr_cat IN igs_ps_type.enrolment_cat%TYPE,
671: p_enr_comm IN VARCHAR2,
672: p_enr_meth_type IN igs_en_method_type.enr_method_type%TYPE,
673: p_dcnt_reason_cd IN igs_en_dcnt_reasoncd.discontinuation_reason_cd%TYPE,
674: p_admin_unit_status IN VARCHAR2,
675: p_effective_date IN DATE,
676: p_deny_warn_coreq IN VARCHAR2,
677: p_deny_warn_prereq IN VARCHAR2,

Line 1334: FROM igs_en_dcnt_reasoncd

1330:
1331:
1332: CURSOR c_dcnt_rsn IS
1333: SELECT discontinuation_reason_cd
1334: FROM igs_en_dcnt_reasoncd
1335: WHERE NVL(closed_ind,'N') ='N'
1336: AND dflt_ind ='Y'
1337: AND dcnt_unit_ind ='Y'
1338: AND s_discontinuation_reason_type IS NULL;

Line 1340: l_dcnt_reason_cd igs_en_dcnt_reasoncd.discontinuation_reason_cd%TYPE;

1336: AND dflt_ind ='Y'
1337: AND dcnt_unit_ind ='Y'
1338: AND s_discontinuation_reason_type IS NULL;
1339:
1340: l_dcnt_reason_cd igs_en_dcnt_reasoncd.discontinuation_reason_cd%TYPE;
1341:
1342: -- Cursor to get the coo_id of the student.
1343: CURSOR cur_coo_id IS
1344: SELECT coo_id coo_id

Line 1721: l_discont_reason_cd igs_en_dcnt_reasoncd.discontinuation_reason_cd%TYPE;

1717: p_discontinuation_reason_cd VARCHAR2,
1718: p_admin_unit_status VARCHAR2)
1719: RETURN VARCHAR2 AS
1720:
1721: l_discont_reason_cd igs_en_dcnt_reasoncd.discontinuation_reason_cd%TYPE;
1722:
1723: TYPE c_ref_cursor IS REF CURSOR;
1724: c_upd_units c_ref_cursor;
1725: