APPS.IGS_EN_STDNT_PS_ATT_PKG dependencies on IGS_PS_STDNT_TRN

Line 2134: IGS_PS_STDNT_TRN_PKG.GET_FK_IGS_EN_STDNT_PS_ATT (

2130: IGS_EN_STDNT_PS_INTM_PKG.GET_FK_IGS_EN_STDNT_PS_ATT (
2131: old_references.person_id,
2132: old_references.course_cd
2133: );
2134: IGS_PS_STDNT_TRN_PKG.GET_FK_IGS_EN_STDNT_PS_ATT (
2135: old_references.person_id,
2136: old_references.course_cd
2137: );
2138: IGS_PS_STDNT_APV_ALT_PKG.GET_FK_IGS_EN_STDNT_PS_ATT (

Line 2906: CURSOR cur_fut_dt_trnsf(cp_person_id IGS_PS_STDNT_TRN.person_id%TYPE,

2902: p_new_references IGS_EN_STDNT_PS_ATT_ALL%ROWTYPE,
2903: p_action VARCHAR2,
2904: p_skip_before_after_dml BOOLEAN DEFAULT FALSE) IS
2905:
2906: CURSOR cur_fut_dt_trnsf(cp_person_id IGS_PS_STDNT_TRN.person_id%TYPE,
2907: cp_program_cd IGS_PS_STDNT_TRN.transfer_course_cd%TYPE) IS
2908: SELECT sct.course_cd,sct.effective_term_cal_type,sct.effective_term_sequence_num
2909: FROM IGS_PS_STDNT_TRN sct, IGS_EN_STDNT_PS_ATT sca
2910: WHERE sct.person_id = cp_person_id

Line 2907: cp_program_cd IGS_PS_STDNT_TRN.transfer_course_cd%TYPE) IS

2903: p_action VARCHAR2,
2904: p_skip_before_after_dml BOOLEAN DEFAULT FALSE) IS
2905:
2906: CURSOR cur_fut_dt_trnsf(cp_person_id IGS_PS_STDNT_TRN.person_id%TYPE,
2907: cp_program_cd IGS_PS_STDNT_TRN.transfer_course_cd%TYPE) IS
2908: SELECT sct.course_cd,sct.effective_term_cal_type,sct.effective_term_sequence_num
2909: FROM IGS_PS_STDNT_TRN sct, IGS_EN_STDNT_PS_ATT sca
2910: WHERE sct.person_id = cp_person_id
2911: AND sct.transfer_course_cd = cp_program_cd

Line 2909: FROM IGS_PS_STDNT_TRN sct, IGS_EN_STDNT_PS_ATT sca

2905:
2906: CURSOR cur_fut_dt_trnsf(cp_person_id IGS_PS_STDNT_TRN.person_id%TYPE,
2907: cp_program_cd IGS_PS_STDNT_TRN.transfer_course_cd%TYPE) IS
2908: SELECT sct.course_cd,sct.effective_term_cal_type,sct.effective_term_sequence_num
2909: FROM IGS_PS_STDNT_TRN sct, IGS_EN_STDNT_PS_ATT sca
2910: WHERE sct.person_id = cp_person_id
2911: AND sct.transfer_course_cd = cp_program_cd
2912: AND sct.course_cd = sca.course_cd
2913: AND sct.person_id = sca.person_id

Line 2916: v_eff_term_cal_type IGS_PS_STDNT_TRN.effective_term_cal_type%TYPE;

2912: AND sct.course_cd = sca.course_cd
2913: AND sct.person_id = sca.person_id
2914: AND sca.future_dated_trans_flag = 'Y';
2915:
2916: v_eff_term_cal_type IGS_PS_STDNT_TRN.effective_term_cal_type%TYPE;
2917: v_eff_term_seq_num IGS_PS_STDNT_TRN.effective_term_sequence_num%TYPE;
2918: v_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
2919: v_errbuf VARCHAR2(20);
2920:

Line 2917: v_eff_term_seq_num IGS_PS_STDNT_TRN.effective_term_sequence_num%TYPE;

2913: AND sct.person_id = sca.person_id
2914: AND sca.future_dated_trans_flag = 'Y';
2915:
2916: v_eff_term_cal_type IGS_PS_STDNT_TRN.effective_term_cal_type%TYPE;
2917: v_eff_term_seq_num IGS_PS_STDNT_TRN.effective_term_sequence_num%TYPE;
2918: v_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
2919: v_errbuf VARCHAR2(20);
2920:
2921: BEGIN