APPS.IGS_EN_GEN_010 dependencies on IGS_AS_SU_STMPTOUT

Line 5607: FROM IGS_AS_SU_STMPTOUT

5603: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
5604: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE,
5605: cp_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE) IS
5606: SELECT 1
5607: FROM IGS_AS_SU_STMPTOUT
5608: WHERE person_id = cp_person_id AND
5609: course_cd = cp_course_cd AND
5610: uoo_id = cp_uoo_id AND
5611: outcome_dt = cp_discontinued_dt;

Line 5661: IGS_AS_SU_STMPTOUT_PKG.INSERT_ROW(

5657: DECLARE
5658: l_rowid VARCHAR2(25);
5659: l_org_id NUMBER := igs_ge_gen_003.get_org_id;
5660: BEGIN
5661: IGS_AS_SU_STMPTOUT_PKG.INSERT_ROW(
5662: x_rowid => l_rowid,
5663: x_person_id => p_person_id,
5664: x_course_cd => p_course_cd,
5665: x_unit_cd => p_unit_cd,

Line 8886: cp_finalised_outcome_ind IGS_AS_SU_STMPTOUT.FINALISED_OUTCOME_IND%TYPE ) IS

8882:
8883: CURSOR c_suao (cp_person_id IGS_EN_SU_ATTEMPT.PERSON_ID%TYPE,
8884: cp_source_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
8885: cp_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE,
8886: cp_finalised_outcome_ind IGS_AS_SU_STMPTOUT.FINALISED_OUTCOME_IND%TYPE ) IS
8887: SELECT outcome_dt
8888: FROM igs_as_su_stmptout source_suao
8889: WHERE person_id = cp_person_id
8890: AND course_cd = cp_source_course_cd

Line 8888: FROM igs_as_su_stmptout source_suao

8884: cp_source_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
8885: cp_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE,
8886: cp_finalised_outcome_ind IGS_AS_SU_STMPTOUT.FINALISED_OUTCOME_IND%TYPE ) IS
8887: SELECT outcome_dt
8888: FROM igs_as_su_stmptout source_suao
8889: WHERE person_id = cp_person_id
8890: AND course_cd = cp_source_course_cd
8891: AND uoo_id = cp_uoo_id
8892: AND finalised_outcome_ind = cp_finalised_outcome_ind

Line 8895: v_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE;

8891: AND uoo_id = cp_uoo_id
8892: AND finalised_outcome_ind = cp_finalised_outcome_ind
8893: ORDER BY outcome_dt desc;
8894:
8895: v_outcome_dt igs_as_su_stmptout.outcome_dt%TYPE;
8896:
8897: CURSOR c_load(cp_date IGS_EN_SU_ATTEMPT.DISCONTINUED_DT%TYPE,
8898: cp_load_start_dt IGS_CA_INST.START_DT%TYPE,
8899: cp_teach_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

Line 8994: FROM igs_as_su_stmptout source_suao

8990: cp_dest_course_cd IGS_EN_SU_ATTEMPT.COURSE_CD%TYPE,
8991: cp_source_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE,
8992: cp_dest_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS
8993: SELECT source_suao.rowid,source_suao.*
8994: FROM igs_as_su_stmptout source_suao
8995: WHERE person_id = cp_person_id
8996: AND course_cd = cp_source_course_cd
8997: AND uoo_id = cp_source_uoo_id
8998: AND NOT EXISTS (SELECT 'x'

Line 8999: FROM igs_as_su_stmptout dest_suao

8995: WHERE person_id = cp_person_id
8996: AND course_cd = cp_source_course_cd
8997: AND uoo_id = cp_source_uoo_id
8998: AND NOT EXISTS (SELECT 'x'
8999: FROM igs_as_su_stmptout dest_suao
9000: WHERE dest_suao.person_id = source_suao.person_id
9001: AND dest_suao.course_cd = cp_dest_course_cd
9002: AND dest_suao.outcome_dt = source_suao.outcome_dt
9003: AND dest_suao.grading_period_cd = source_suao.grading_period_cd

Line 9028: igs_as_su_stmptout_pkg.DELETE_ROW(v_suao_rec.rowid);

9024: FOR v_suao_rec in c_suao(p_person_id, p_source_course_cd, p_Dest_course_cd,
9025: p_source_uoo_id, p_dest_uoo_id) LOOP
9026:
9027: IF p_delete_source THEN
9028: igs_as_su_stmptout_pkg.DELETE_ROW(v_suao_rec.rowid);
9029: END IF;
9030:
9031: OPEN c_usec (p_dest_uoo_id);
9032: FETCH c_usec INTO v_dest_usec_rec;

Line 9035: igs_as_su_stmptout_pkg.insert_row(

9031: OPEN c_usec (p_dest_uoo_id);
9032: FETCH c_usec INTO v_dest_usec_rec;
9033: CLOSE c_usec;
9034:
9035: igs_as_su_stmptout_pkg.insert_row(
9036: X_ROWID => l_ROWID ,
9037: X_ORG_ID => v_suao_rec.ORG_ID ,
9038: X_PERSON_ID => v_suao_rec.PERSON_ID ,
9039: X_COURSE_CD => P_DEST_COURSE_CD ,