APPS.IGS_AD_INT_RECONSIDER dependencies on IGS_RE_THESIS_EXAM

Line 96: CURSOR c_get_thesis_exam (cp_person_id igs_re_thesis_exam.person_id%TYPE,

92: WHERE ca_person_id = cp_ca_person_id
93: AND ca_sequence_number = cp_ca_sequence_number
94: ORDER BY start_dt,end_dt;
95:
96: CURSOR c_get_thesis_exam (cp_person_id igs_re_thesis_exam.person_id%TYPE,
97: cp_ca_sequence_number igs_re_thesis_exam.ca_sequence_number%TYPE,
98: cp_the_sequence_number igs_re_thesis_exam.the_sequence_number%TYPE) IS
99: SELECT *
100: FROM igs_re_thesis_exam

Line 97: cp_ca_sequence_number igs_re_thesis_exam.ca_sequence_number%TYPE,

93: AND ca_sequence_number = cp_ca_sequence_number
94: ORDER BY start_dt,end_dt;
95:
96: CURSOR c_get_thesis_exam (cp_person_id igs_re_thesis_exam.person_id%TYPE,
97: cp_ca_sequence_number igs_re_thesis_exam.ca_sequence_number%TYPE,
98: cp_the_sequence_number igs_re_thesis_exam.the_sequence_number%TYPE) IS
99: SELECT *
100: FROM igs_re_thesis_exam
101: WHERE person_id = cp_person_id

Line 98: cp_the_sequence_number igs_re_thesis_exam.the_sequence_number%TYPE) IS

94: ORDER BY start_dt,end_dt;
95:
96: CURSOR c_get_thesis_exam (cp_person_id igs_re_thesis_exam.person_id%TYPE,
97: cp_ca_sequence_number igs_re_thesis_exam.ca_sequence_number%TYPE,
98: cp_the_sequence_number igs_re_thesis_exam.the_sequence_number%TYPE) IS
99: SELECT *
100: FROM igs_re_thesis_exam
101: WHERE person_id = cp_person_id
102: AND ca_sequence_number = cp_ca_sequence_number

Line 100: FROM igs_re_thesis_exam

96: CURSOR c_get_thesis_exam (cp_person_id igs_re_thesis_exam.person_id%TYPE,
97: cp_ca_sequence_number igs_re_thesis_exam.ca_sequence_number%TYPE,
98: cp_the_sequence_number igs_re_thesis_exam.the_sequence_number%TYPE) IS
99: SELECT *
100: FROM igs_re_thesis_exam
101: WHERE person_id = cp_person_id
102: AND ca_sequence_number = cp_ca_sequence_number
103: AND the_sequence_number = cp_the_sequence_number;
104:

Line 130: l_submission_dt igs_re_thesis_exam.submission_dt%TYPE;

126: l_supvsr_end_dt igs_re_sprvsr.end_dt%TYPE;
127: l_comm_date_offset NUMBER;
128:
129:
130: l_submission_dt igs_re_thesis_exam.submission_dt%TYPE;
131: l_expected_submission_dt igs_re_thesis.expected_submission_dt%TYPE;
132: l_embargo_expiry_dt igs_re_thesis.embargo_expiry_dt%TYPE;
133:
134: l_sysdate DATE ;

Line 237: IGS_RE_THESIS_EXAM_PKG.INSERT_ROW(

233:
234: l_submission_dt := l_get_thesis_exam_rec.submission_dt + l_comm_date_offset;
235: l_rowid_child2 := NULL;
236:
237: IGS_RE_THESIS_EXAM_PKG.INSERT_ROW(
238: X_ROWID => l_rowid_child2,
239: X_PERSON_ID => p_person_id,
240: X_CA_SEQUENCE_NUMBER => l_get_candidature_sequence,
241: X_THE_SEQUENCE_NUMBER => l_get_thesis_sequence,