eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_EN_TRANSFER_APIS dependencies on IGS_PS_VER

Line 985: CURSOR c_get_career_type(c_program_cd IGS_PS_VER.course_cd%TYPE,c_program_ver IGS_PS_VER.version_number%TYPE) IS

981: --Who When What
982:
983: -------------------------------------------------------------------------------------------
984:
985: CURSOR c_get_career_type(c_program_cd IGS_PS_VER.course_cd%TYPE,c_program_ver IGS_PS_VER.version_number%TYPE) IS
986: SELECT course_type
987: FROM IGS_PS_VER
988: WHERE course_cd = c_program_cd AND
989: version_number = c_program_ver;

Line 987: FROM IGS_PS_VER

983: -------------------------------------------------------------------------------------------
984:
985: CURSOR c_get_career_type(c_program_cd IGS_PS_VER.course_cd%TYPE,c_program_ver IGS_PS_VER.version_number%TYPE) IS
986: SELECT course_type
987: FROM IGS_PS_VER
988: WHERE course_cd = c_program_cd AND
989: version_number = c_program_ver;
990: l_src_prgm_career IGS_PS_VER.COURSE_TYPE%TYPE;
991: l_dest_prgm_career IGS_PS_VER.COURSE_TYPE%TYPE;

Line 990: l_src_prgm_career IGS_PS_VER.COURSE_TYPE%TYPE;

986: SELECT course_type
987: FROM IGS_PS_VER
988: WHERE course_cd = c_program_cd AND
989: version_number = c_program_ver;
990: l_src_prgm_career IGS_PS_VER.COURSE_TYPE%TYPE;
991: l_dest_prgm_career IGS_PS_VER.COURSE_TYPE%TYPE;
992:
993: BEGIN
994:

Line 991: l_dest_prgm_career IGS_PS_VER.COURSE_TYPE%TYPE;

987: FROM IGS_PS_VER
988: WHERE course_cd = c_program_cd AND
989: version_number = c_program_ver;
990: l_src_prgm_career IGS_PS_VER.COURSE_TYPE%TYPE;
991: l_dest_prgm_career IGS_PS_VER.COURSE_TYPE%TYPE;
992:
993: BEGIN
994:
995: OPEN c_get_career_type(p_src_program_cd,p_src_progam_ver);

Line 1627: l_src_crs_type igs_ps_ver.course_type%TYPE;

1623:
1624: cst_enrolled CONSTANT VARCHAR2(10) := 'ENROLLED';
1625: cst_waitlist CONSTANT VARCHAR2(10) := 'WAITLISTED';
1626: cst_invalid CONSTANT VARCHAR2(10) := 'INVALID';
1627: l_src_crs_type igs_ps_ver.course_type%TYPE;
1628: BEGIN
1629:
1630: l_strtpoint := 0;
1631: l_pre_cindex := 0;

Line 2783: FROM IGS_PS_VER

2779: l_status BOOLEAN;
2780: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2781: CURSOR c_course_type IS
2782: SELECT course_type
2783: FROM IGS_PS_VER
2784: WHERE COURSE_CD = p_source_program_cd
2785: AND VERSION_NUMBER = p_source_prog_ver;
2786: CURSOR c_get_stdnt_ps_att_dtls IS
2787: SELECT *

Line 2804: IGS_PS_VER pv

2800: -- check if any other active program exists in the source career other than the source program
2801: CURSOR c_act_src_prg_exists_as_prmy IS
2802: SELECT 'x'
2803: FROM IGS_EN_STDNT_PS_ATT sca,
2804: IGS_PS_VER pv
2805: WHERE sca.person_id = p_person_id AND
2806: sca.course_cd = pv.course_cd AND
2807: sca.version_number = pv.version_number AND
2808: pv.course_type = p_src_career_type AND

Line 2812: l_course_type igs_ps_ver.course_type%TYPE;

2808: pv.course_type = p_src_career_type AND
2809: sca.course_cd <> p_source_program_cd AND
2810: sca.course_attempt_status IN ('ENROLLED','INACTIVE','LAPSED','INTERMIT');
2811: l_act_src_exist_across_career c_act_src_prg_exists_as_prmy%ROWTYPE;
2812: l_course_type igs_ps_ver.course_type%TYPE;
2813: BEGIN
2814:
2815: OPEN c_get_stdnt_ps_att_dtls;
2816: FETCH c_get_stdnt_ps_att_dtls INTO l_stdnt_ps_attempt_dtls_rec;

Line 3057: l_src_career_type IGS_PS_VER.COURSE_TYPE%TYPE;

3053: l_career_model_enabled BOOLEAN;
3054: l_tran_across_careers BOOLEAN;
3055: l_drop BOOLEAN;
3056: l_sct_tran_status BOOLEAN;
3057: l_src_career_type IGS_PS_VER.COURSE_TYPE%TYPE;
3058: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
3059: l_debt_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
3060: l_hold_status BOOLEAN;
3061:

Line 3094: CURSOR c_get_progam_type(c_course_cd IGS_PS_VER.course_cd%TYPE,c_course_ver IGS_PS_VER.version_number%TYPE) IS

3090: SELECT student_confirmed_ind, primary_program_type
3091: FROM IGS_EN_STDNT_PS_ATT
3092: WHERE person_id = c_person_id and
3093: course_cd = c_program_cd;
3094: CURSOR c_get_progam_type(c_course_cd IGS_PS_VER.course_cd%TYPE,c_course_ver IGS_PS_VER.version_number%TYPE) IS
3095: SELECT cty.research_type_ind
3096: FROM IGS_PS_VER crv,
3097: IGS_PS_TYPE cty
3098: WHERE crv.course_cd = c_course_cd AND

Line 3096: FROM IGS_PS_VER crv,

3092: WHERE person_id = c_person_id and
3093: course_cd = c_program_cd;
3094: CURSOR c_get_progam_type(c_course_cd IGS_PS_VER.course_cd%TYPE,c_course_ver IGS_PS_VER.version_number%TYPE) IS
3095: SELECT cty.research_type_ind
3096: FROM IGS_PS_VER crv,
3097: IGS_PS_TYPE cty
3098: WHERE crv.course_cd = c_course_cd AND
3099: crv.version_number = c_course_ver AND
3100: crv.course_type = cty.course_type ;