APPS.IGS_EN_VAL_SCSR dependencies on IGS_PS_STDNT_SPL_REQ

Line 15: -- IGS_PS_STDNT_SPL_REQ record does not does not exist for the same

11: p_message_name OUT NOCOPY VARCHAR2)
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

Line 19: -- overlap with another IGS_PS_STDNT_SPL_REQ record for the same

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.
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.

Line 33: FROM IGS_PS_STDNT_SPL_REQ scsr1

29: v_dummy VARCHAR2(1);
30: v_ret_val BOOLEAN := TRUE;
31: CURSOR c_scsr1 IS
32: SELECT 'X'
33: FROM IGS_PS_STDNT_SPL_REQ scsr1
34: WHERE scsr1.person_id = p_person_id AND
35: scsr1.course_cd = p_course_cd AND
36: scsr1.special_requirement_cd = p_special_requirement_cd AND
37: scsr1.completed_dt <> p_completed_dt AND

Line 42: FROM IGS_PS_STDNT_SPL_REQ scsr2

38: scsr1.expiry_dt IS NULL;
39: CURSOR c_scsr2 IS
40: SELECT scsr2.completed_dt,
41: scsr2.expiry_dt
42: FROM IGS_PS_STDNT_SPL_REQ scsr2
43: WHERE scsr2.person_id = p_person_id AND
44: scsr2.course_cd = p_course_cd AND
45: scsr2.special_requirement_cd = p_special_requirement_cd AND
46: scsr2.completed_dt <> p_completed_dt;

Line 137: -- Validate thata IGS_PS_STDNT_SPL_REQ.completed_dt is less

133: p_completed_dt IN DATE ,
134: p_message_name OUT NOCOPY VARCHAR2)
135: RETURN BOOLEAN AS
136: BEGIN -- enrp_val_scsr_cmp_dt
137: -- Validate thata IGS_PS_STDNT_SPL_REQ.completed_dt is less
138: -- than or equal to today's date/
139: DECLARE
140: CURSOR c_scsr IS
141: SELECT 'x'

Line 185: -- Validate that IGS_PS_STDNT_SPL_REQ.expiry_dt

181: p_message_name OUT NOCOPY VARCHAR2)
182: RETURN BOOLEAN AS
183:
184: BEGIN -- enrp_val_scsr_exp_dt
185: -- Validate that IGS_PS_STDNT_SPL_REQ.expiry_dt
186: -- if it is not NULL, it must be greater than or equal to the completed_dt
187: DECLARE
188: BEGIN
189: -- Set the default message number

Line 222: -- or deleting IGS_PS_STDNT_SPL_REQ records.

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
224: CURSOR c_sca IS
225: SELECT course_attempt_status
226: FROM IGS_EN_STDNT_PS_ATT