APPS.IGS_AD_VAL_ACAI_FTR_OFFER dependencies on IGS_RE_THESIS_EXAM

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

114: WHERE ca_person_id = cp_ca_person_id
115: AND ca_sequence_number = cp_ca_sequence_number
116: ORDER BY start_dt,end_dt;
117:
118: CURSOR c_get_thesis_exam (cp_person_id igs_re_thesis_exam.person_id%TYPE,
119: cp_ca_sequence_number igs_re_thesis_exam.ca_sequence_number%TYPE,
120: cp_the_sequence_number igs_re_thesis_exam.the_sequence_number%TYPE) IS
121: SELECT *
122: FROM igs_re_thesis_exam

Line 119: cp_ca_sequence_number igs_re_thesis_exam.ca_sequence_number%TYPE,

115: AND ca_sequence_number = cp_ca_sequence_number
116: ORDER BY start_dt,end_dt;
117:
118: CURSOR c_get_thesis_exam (cp_person_id igs_re_thesis_exam.person_id%TYPE,
119: cp_ca_sequence_number igs_re_thesis_exam.ca_sequence_number%TYPE,
120: cp_the_sequence_number igs_re_thesis_exam.the_sequence_number%TYPE) IS
121: SELECT *
122: FROM igs_re_thesis_exam
123: WHERE person_id = cp_person_id

Line 120: cp_the_sequence_number igs_re_thesis_exam.the_sequence_number%TYPE) IS

116: ORDER BY start_dt,end_dt;
117:
118: CURSOR c_get_thesis_exam (cp_person_id igs_re_thesis_exam.person_id%TYPE,
119: cp_ca_sequence_number igs_re_thesis_exam.ca_sequence_number%TYPE,
120: cp_the_sequence_number igs_re_thesis_exam.the_sequence_number%TYPE) IS
121: SELECT *
122: FROM igs_re_thesis_exam
123: WHERE person_id = cp_person_id
124: AND ca_sequence_number = cp_ca_sequence_number

Line 122: FROM igs_re_thesis_exam

118: CURSOR c_get_thesis_exam (cp_person_id igs_re_thesis_exam.person_id%TYPE,
119: cp_ca_sequence_number igs_re_thesis_exam.ca_sequence_number%TYPE,
120: cp_the_sequence_number igs_re_thesis_exam.the_sequence_number%TYPE) IS
121: SELECT *
122: FROM igs_re_thesis_exam
123: WHERE person_id = cp_person_id
124: AND ca_sequence_number = cp_ca_sequence_number
125: AND the_sequence_number = cp_the_sequence_number;
126:

Line 152: l_submission_dt igs_re_thesis_exam.submission_dt%TYPE;

148: l_supvsr_end_dt igs_re_sprvsr.end_dt%TYPE;
149: l_comm_date_offset NUMBER;
150:
151:
152: l_submission_dt igs_re_thesis_exam.submission_dt%TYPE;
153: l_expected_submission_dt igs_re_thesis.expected_submission_dt%TYPE;
154: l_embargo_expiry_dt igs_re_thesis.embargo_expiry_dt%TYPE;
155:
156: l_sysdate DATE ;

Line 259: IGS_RE_THESIS_EXAM_PKG.INSERT_ROW(

255:
256: l_submission_dt := l_get_thesis_exam_rec.submission_dt + l_comm_date_offset;
257: l_rowid_child2 := NULL;
258:
259: IGS_RE_THESIS_EXAM_PKG.INSERT_ROW(
260: X_ROWID => l_rowid_child2,
261: X_PERSON_ID => p_person_id,
262: X_CA_SEQUENCE_NUMBER => l_get_candidature_sequence,
263: X_THE_SEQUENCE_NUMBER => l_get_thesis_sequence,