APPS.IGS_EN_PLAN_UTILS dependencies on IGS_EN_STD_WARNINGS

Line 821: l_warning_id igs_en_std_warnings.warning_id%TYPE;

817: l_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
818: l_found varchar2(1);
819: l_pos number;
820: l_row_id ROWID;
821: l_warning_id igs_en_std_warnings.warning_id%TYPE;
822: l_deny_warn VARCHAR2(20);
823: CURSOR c_unit_sec_rep(cp_uoo_id IN NUMBER) IS
824: SELECT 'X' FROM igs_en_su_attempt_all sua, igs_ps_unit_ofr_opt_all uoo
825: WHERE uoo.uoo_id = cp_uoo_id

Line 1668: FROM igs_en_std_warnings warn

1664: cp_c_program_code IN VARCHAR2,
1665: cp_c_load_cal IN VARCHAR2,
1666: cp_n_seq_num IN NUMBER) IS
1667: SELECT warn.ROWID ROW_ID
1668: FROM igs_en_std_warnings warn
1669: WHERE warn.person_id = cp_n_person_id
1670: AND warn.course_cd = cp_c_program_code
1671: AND warn.term_cal_type = cp_c_load_cal
1672: AND warn.term_ci_sequence_number = cp_n_seq_num;

Line 1677: IGS_EN_STD_WARNINGS_pkg.delete_row(x_rowid =>rec_warn.row_id);

1673:
1674: BEGIN
1675:
1676: FOR rec_warn in c_warn(p_n_person_id,p_c_program_code,p_c_load_cal,p_n_load_seq_num) LOOP
1677: IGS_EN_STD_WARNINGS_pkg.delete_row(x_rowid =>rec_warn.row_id);
1678: END LOOP;
1679:
1680: FOR rec_sua IN c_sua(p_n_person_id,p_c_program_code,p_c_load_cal,p_n_load_seq_num) LOOP
1681: