APPS.IGS_EN_FUTURE_DT_TRANS dependencies on IGS_PS_STDNT_TRN

Line 1162: FROM IGS_PS_STDNT_TRN trnsf

1158: IS
1159:
1160: CURSOR c_del_ps_trnsf IS
1161: SELECT rowid
1162: FROM IGS_PS_STDNT_TRN trnsf
1163: WHERE trnsf.person_id = p_person_id
1164: AND trnsf.course_cd = p_course_cd
1165: AND trnsf.effective_term_cal_type = p_term_cal_type
1166: AND trnsf.effective_term_sequence_num = p_term_sequence_number

Line 1175: IGS_PS_STDNT_TRN_PKG.DELETE_ROW(v_del_ps_trnsf.rowid);

1171: BEGIN
1172:
1173: FOR v_del_ps_trnsf IN c_del_ps_trnsf LOOP
1174:
1175: IGS_PS_STDNT_TRN_PKG.DELETE_ROW(v_del_ps_trnsf.rowid);
1176:
1177: END LOOP;
1178:
1179: EXCEPTION

Line 1729: FROM IGS_PS_STDNT_TRN sct

1725: cp_term_sequence_number IGS_CA_INST.sequence_number%TYPE,
1726: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1727: cp_dest_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
1728: SELECT rowid,sct.*
1729: FROM IGS_PS_STDNT_TRN sct
1730: WHERE sct.effective_term_cal_type = cp_term_cal_type
1731: AND sct.effective_term_sequence_num = cp_term_sequence_number
1732: AND sct.person_id = cp_person_id
1733: AND sct.course_cd = cp_dest_course_cd

Line 1831: l_status_date IGS_PS_STDNT_TRN.status_date%TYPE;

1827: v_rec_exists VARCHAR2(1);
1828: v_message_name VARCHAR2(30);
1829: v_src_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
1830: l_src_career_type IGS_PS_VER.COURSE_TYPE%TYPE;
1831: l_status_date IGS_PS_STDNT_TRN.status_date%TYPE;
1832: l_trans_status IGS_PS_STDNT_TRN.status_flag%TYPE;
1833: l_tran_across_careers BOOLEAN;
1834: l_trans_within_careers BOOLEAN;
1835: l_stdnt_conf_ind IGS_EN_STDNT_PS_ATT.STUDENT_CONFIRMED_IND%TYPE;

Line 1832: l_trans_status IGS_PS_STDNT_TRN.status_flag%TYPE;

1828: v_message_name VARCHAR2(30);
1829: v_src_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
1830: l_src_career_type IGS_PS_VER.COURSE_TYPE%TYPE;
1831: l_status_date IGS_PS_STDNT_TRN.status_date%TYPE;
1832: l_trans_status IGS_PS_STDNT_TRN.status_flag%TYPE;
1833: l_tran_across_careers BOOLEAN;
1834: l_trans_within_careers BOOLEAN;
1835: l_stdnt_conf_ind IGS_EN_STDNT_PS_ATT.STUDENT_CONFIRMED_IND%TYPE;
1836: l_comm_date IGS_EN_STDNT_PS_ATT.COMMENCEMENT_DT%TYPE;

Line 1975: IGS_PS_STDNT_TRN_PKG.update_row(

1971: END IF; -- End of IF l_trans_within_careers
1972:
1973:
1974: -- Update the transfer record set status_flag = 'C' and status_date = SYSDATE
1975: IGS_PS_STDNT_TRN_PKG.update_row(
1976: X_ROWID => v_spa_clnup_rec.rowid,
1977: X_PERSON_ID => v_spa_clnup_rec.person_id,
1978: X_COURSE_CD => v_spa_clnup_rec.course_cd,
1979: X_TRANSFER_COURSE_CD => v_spa_clnup_rec.transfer_course_cd,

Line 2272: FROM IGS_PS_STDNT_TRN sct

2268: -- Cursor to fetch the records to process
2269: CURSOR c_spa_clnup(cp_term_cal_type IGS_CA_INST.cal_type%TYPE,
2270: cp_term_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
2271: SELECT sct.*
2272: FROM IGS_PS_STDNT_TRN sct
2273: WHERE effective_term_cal_type = cp_term_cal_type
2274: AND effective_term_sequence_num = cp_term_sequence_number
2275: AND ( sct.status_flag = 'U' and p_mode IN ('PROCESS','CLEANUP')
2276: OR sct.status_flag = 'C' and p_mode IN ('DELETE'));

Line 2334: cp_transfer_dt IGS_PS_STDNT_TRN.transfer_dt%TYPE ) IS

2330: cp_dest_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
2331: cp_cur_term_cal IGS_CA_INST.cal_type%TYPE,
2332: cp_cur_term_seq_num IGS_CA_INST.sequence_number%TYPE,
2333: cp_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
2334: cp_transfer_dt IGS_PS_STDNT_TRN.transfer_dt%TYPE ) IS
2335: SELECT 'x'
2336: FROM igs_ca_inst ci2,
2337: igs_ca_inst_rel cir,
2338: igs_ca_type ct,

Line 2384: FROM IGS_PS_STDNT_TRN sct

2380: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2381: cp_dest_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE
2382: ) IS
2383: SELECT 'X'
2384: FROM IGS_PS_STDNT_TRN sct
2385: WHERE effective_term_cal_type = cp_term_cal_type
2386: AND effective_term_sequence_num = cp_term_sequence_number
2387: AND sct.person_id = cp_person_id
2388: AND sct.course_cd = cp_dest_course_cd