APPS.IGS_EN_VAL_SCSR dependencies on IGS_EN_STDNT_PS_ATT

Line 16: -- IGS_EN_STDNT_PS_ATT with the same special_requirement_cd with a NULL

12: RETURN BOOLEAN AS
13: BEGIN -- enrp_val_scsr_dates
14: -- * Validate that if the expiry_dt of the current record is NULL that another
15: -- IGS_PS_STDNT_SPL_REQ record does not does not exist for the same
16: -- IGS_EN_STDNT_PS_ATT with the same special_requirement_cd with a NULL
17: -- expiry_dt.
18: -- * Validate that the current record's completed_dt and expiry_dt do not
19: -- overlap with another IGS_PS_STDNT_SPL_REQ record for the same
20: -- IGS_EN_STDNT_PS_ATT with the same special_requirement_cd.

Line 20: -- IGS_EN_STDNT_PS_ATT with the same special_requirement_cd.

16: -- IGS_EN_STDNT_PS_ATT with the same special_requirement_cd with a NULL
17: -- expiry_dt.
18: -- * Validate that the current record's completed_dt and expiry_dt do not
19: -- overlap with another IGS_PS_STDNT_SPL_REQ record for the same
20: -- IGS_EN_STDNT_PS_ATT with the same special_requirement_cd.
21: -- * Validation will fail if any of the following are true -
22: -- (a) The current completed date is between an existing date range.
23: -- (b) The current expiry date is between an existing date range.
24: -- (c) The current dates overlap an entire existing date range.

Line 213: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,

209: END enrp_val_scsr_exp_dt;
210: --
211: -- Validate the student course special requirement SCA status.
212: FUNCTION enrp_val_scsr_scas(
213: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
214: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
215: p_message_name OUT NOCOPY VARCHAR2)
216: RETURN BOOLEAN AS
217:

Line 214: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,

210: --
211: -- Validate the student course special requirement SCA status.
212: FUNCTION enrp_val_scsr_scas(
213: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
214: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
215: p_message_name OUT NOCOPY VARCHAR2)
216: RETURN BOOLEAN AS
217:
218: BEGIN -- enrp_val_scsr_scas

Line 219: -- Validate the IGS_EN_STDNT_PS_ATT.course_attempt_status is

215: p_message_name OUT NOCOPY VARCHAR2)
216: RETURN BOOLEAN AS
217:
218: BEGIN -- enrp_val_scsr_scas
219: -- Validate the IGS_EN_STDNT_PS_ATT.course_attempt_status is
220: -- ENROLLED, COMPLETED, INACTIVE or INTERMIT (not DISCONTIN,
221: -- DELETED, LAPSED or UNCONFIRM) before inserting, updating
222: -- or deleting IGS_PS_STDNT_SPL_REQ records.
223: DECLARE

Line 226: FROM IGS_EN_STDNT_PS_ATT

222: -- or deleting IGS_PS_STDNT_SPL_REQ records.
223: DECLARE
224: CURSOR c_sca IS
225: SELECT course_attempt_status
226: FROM IGS_EN_STDNT_PS_ATT
227: WHERE person_id = p_person_id AND
228: course_cd = p_course_cd;
229: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
230: BEGIN

Line 229: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

225: SELECT course_attempt_status
226: FROM IGS_EN_STDNT_PS_ATT
227: WHERE person_id = p_person_id AND
228: course_cd = p_course_cd;
229: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
230: BEGIN
231: p_message_name := null;
232: -- Check parameters
233: IF p_person_id IS NULL OR p_course_cd IS NULL THEN

Line 237: -- IGS_EN_STDNT_PS_ATT.

233: IF p_person_id IS NULL OR p_course_cd IS NULL THEN
234: RETURN TRUE;
235: END IF;
236: -- Get the course_attempt_status for the specified
237: -- IGS_EN_STDNT_PS_ATT.
238: OPEN c_sca;
239: FETCH c_sca INTO v_course_attempt_status;
240: IF (c_sca%FOUND) THEN
241: IF v_course_attempt_status IN (