APPS.IGS_EN_SUA_LGCY_PUB dependencies on IGS_EN_SCA_V

Line 775: FROM igs_en_sca_v sca

771: --
772: -- Cursor to get the Course Type of the Primary Program
773: CURSOR get_course_type IS
774: SELECT sca.course_type
775: FROM igs_en_sca_v sca
776: WHERE sca.person_id = p_person_id AND
777: sca.course_cd = p_sua_dtls_rec.program_cd ;
778:
779: --

Line 783: FROM igs_en_stdnt_ps_att spa , igs_en_sca_v sca

779: --
780: -- Cursor to fetch all the secondary Programs in a career for the given Primary Program
781: CURSOR get_spa_sec_prgm (p_course_type IN VARCHAR2 ) IS
782: SELECT spa.ROWID
783: FROM igs_en_stdnt_ps_att spa , igs_en_sca_v sca
784: WHERE spa.person_id = p_person_id AND
785: spa.person_id = sca.person_id AND
786: sca.course_cd = spa.course_cd AND
787: sca.course_type = p_course_type AND

Line 793: l_course_type igs_en_sca_v.course_type%TYPE DEFAULT NULL ;

789: spa.course_attempt_status NOT IN ('UNCONFIRM' , 'DISCONTIN' , 'COMPLETED')
790: FOR UPDATE NOWAIT ;
791:
792: l_suao_rec igs_as_suao_lgcy_pub.lgcy_suo_rec_type;
793: l_course_type igs_en_sca_v.course_type%TYPE DEFAULT NULL ;
794: l_spa_row get_spa%ROWTYPE;
795: l_spa_row_sec get_spa_sec_prgm %ROWTYPE;
796:
797: l_usec_row usec_upd_enr_act%ROWTYPE;

Line 1162: l_src_program_typ igs_en_sca_v.course_type%TYPE ;

1158: l_version_number igs_as_grd_sch_grade.version_number%TYPE := 0 ;
1159: l_program_attempt_status igs_en_stdnt_ps_att.course_attempt_status%TYPE ;
1160: l_prgm_discontinued_dt igs_en_stdnt_ps_att.discontinued_dt%TYPE := NULL ;
1161:
1162: l_src_program_typ igs_en_sca_v.course_type%TYPE ;
1163: l_destn_program_typ igs_en_sca_v.course_type%TYPE ;
1164: l_person_id igs_pe_person.person_id%TYPE;
1165: l_discontin_dt igs_en_stdnt_ps_att.discontinued_dt%TYPE;
1166:

Line 1163: l_destn_program_typ igs_en_sca_v.course_type%TYPE ;

1159: l_program_attempt_status igs_en_stdnt_ps_att.course_attempt_status%TYPE ;
1160: l_prgm_discontinued_dt igs_en_stdnt_ps_att.discontinued_dt%TYPE := NULL ;
1161:
1162: l_src_program_typ igs_en_sca_v.course_type%TYPE ;
1163: l_destn_program_typ igs_en_sca_v.course_type%TYPE ;
1164: l_person_id igs_pe_person.person_id%TYPE;
1165: l_discontin_dt igs_en_stdnt_ps_att.discontinued_dt%TYPE;
1166:
1167: l_unit_attempt_status igs_en_su_attempt.unit_attempt_status%TYPE := NULL ;

Line 1859: l_primary_program_type igs_en_sca_v.course_type%TYPE ;

1855: l_api_name CONSTANT VARCHAR2(30) := 'create_sua';
1856: l_api_version CONSTANT NUMBER := 1.0;
1857: l_insert_flag BOOLEAN := TRUE;
1858:
1859: l_primary_program_type igs_en_sca_v.course_type%TYPE ;
1860: l_person_id igs_pe_person.person_id%TYPE;
1861: l_adm_unit_status_ret igs_en_su_attempt.administrative_unit_Status %TYPE;
1862: l_adm_unit_status VARCHAR2(2000);
1863: l_alias_val igs_ca_da_inst.absolute_val%TYPE ;