APPS.IGS_EN_VAL_SCT dependencies on IGS_PS_STDNT_TRN

Line 185: -- This module validates IGS_PS_STDNT_TRN courses.

181: p_message_name OUT NOCOPY VARCHAR2)
182: RETURN BOOLEAN AS
183:
184: BEGIN -- enrp_val_sct_insert
185: -- This module validates IGS_PS_STDNT_TRN courses.
186: -- Course_cd and transfer_course_cd must not be the same.
187: -- Course_cd and transfer_course_cd must be in a system defined course transfer
188: -- group type, and must be members of the same group.
189: -- Validate course_cd.

Line 367: -- This module validates IGS_PS_STDNT_TRN.course_cd details.

363: --bdeviset 07-JAN-2005 Bug# 4103437.Modified cursor c_sct. To avoid having another transfer
364: -- when a destination program is already invloved in a stored transfer.
365: -------------------------------------------------------------------------------------------
366: BEGIN -- enrp_val_sct_to
367: -- This module validates IGS_PS_STDNT_TRN.course_cd details.
368: -- Course_cd must not be course version defined as generic.
369: -- Course_cd must map to IGS_EN_STDNT_PS_ATT whose course_attempt_status
370: -- is 'ENROLLED', 'INTERMIT', 'INACTIVE' or ('UNCONFIRM' and
371: -- admission_course_appl matching transfer details exist).

Line 380: -- Course_cd must not have existing IGS_PS_STDNT_TRN mapping whose

376: -- s_adm_outcome_status 'OFFER', 'COND-OFFER'.
377: -- If IGS_EN_STDNT_PS_ATT is created through Admissions, the related
378: -- IGS_AD_PS_APPL_INST.IGS_AD_OFR_RESP_STAT must map to
379: -- s_adm_offer_resp_status 'REJECTED', 'LAPSED'.
380: -- Course_cd must not have existing IGS_PS_STDNT_TRN mapping whose
381: -- transfer_dt is >= this transfer_dt.
382: -- Transfer_dt >= IGS_EN_STDNT_PS_ATT.commencement_dt and <= today's date
383: DECLARE
384: cst_lapsed CONSTANT VARCHAR2(6) := 'LAPSED';

Line 417: FROM IGS_PS_STDNT_TRN sct

413:
414: -- cursor to check if a destination program is already invloved in a stored transfer
415: CURSOR c_sct IS
416: SELECT 'x'
417: FROM IGS_PS_STDNT_TRN sct
418: WHERE sct.person_id = p_person_id AND
419: (course_cd = p_course_cd OR
420: transfer_course_cd = p_course_cd) AND
421: status_flag = 'U';

Line 566: -- This module validates IGS_PS_STDNT_TRN.transfer_course_cd details.

562: --bdeviset 07-JAN-2005 Bug# 4103437.Modified cursor c_sct_sca. To avoid having another transfer
563: -- when a source program is already invloved in a stored transfer.
564:
565: BEGIN -- enrp_val_sct_from
566: -- This module validates IGS_PS_STDNT_TRN.transfer_course_cd details.
567: -- Transfer_course_cd must map to IGS_EN_STDNT_PS_ATT whose
568: -- course_attempt_status is 'ENROLLED', 'DISCONTIN', 'INACTIVE',
569: -- 'INTERMIT', 'COMPLETED', 'LAPSED'.
570: -- Transfer_course_cd must not have existing IGS_PS_STDNT_TRN mapping

Line 570: -- Transfer_course_cd must not have existing IGS_PS_STDNT_TRN mapping

566: -- This module validates IGS_PS_STDNT_TRN.transfer_course_cd details.
567: -- Transfer_course_cd must map to IGS_EN_STDNT_PS_ATT whose
568: -- course_attempt_status is 'ENROLLED', 'DISCONTIN', 'INACTIVE',
569: -- 'INTERMIT', 'COMPLETED', 'LAPSED'.
570: -- Transfer_course_cd must not have existing IGS_PS_STDNT_TRN mapping
571: -- whose transfer_dt is >= this transfer_dt.
572: -- Transfer_course_cd is not currently transferred to IGS_EN_STDNT_PS_ATT
573: -- with course_attempt_status 'ENROLLED', 'INACTIVE', 'INTERMIT','LAPSED'.
574: DECLARE

Line 586: FROM IGS_PS_STDNT_TRN sct

582: --cursor to check if a source program is invloved in a stored transfer
583:
584: CURSOR c_sct_sca IS
585: SELECT 'x'
586: FROM IGS_PS_STDNT_TRN sct
587: WHERE sct.person_id = p_person_id AND
588: (course_cd = p_transfer_course_cd OR
589: transfer_course_cd = p_transfer_course_cd) AND
590: status_flag = 'U';