APPS.IGS_AD_VAL_ACAI_FTR_OFFER dependencies on IGS_RE_SPRVSR

Line 110: CURSOR c_get_supervisor (cp_ca_person_id igs_re_sprvsr.ca_person_id%TYPE,

106: FROM igs_pr_milestone_all
107: WHERE person_id = cp_person_id
108: AND ca_sequence_number = cp_ca_sequence_number;
109:
110: CURSOR c_get_supervisor (cp_ca_person_id igs_re_sprvsr.ca_person_id%TYPE,
111: cp_ca_sequence_number igs_re_sprvsr.ca_sequence_number%TYPE) IS
112: SELECT *
113: FROM igs_re_sprvsr
114: WHERE ca_person_id = cp_ca_person_id

Line 111: cp_ca_sequence_number igs_re_sprvsr.ca_sequence_number%TYPE) IS

107: WHERE person_id = cp_person_id
108: AND ca_sequence_number = cp_ca_sequence_number;
109:
110: CURSOR c_get_supervisor (cp_ca_person_id igs_re_sprvsr.ca_person_id%TYPE,
111: cp_ca_sequence_number igs_re_sprvsr.ca_sequence_number%TYPE) IS
112: SELECT *
113: FROM igs_re_sprvsr
114: WHERE ca_person_id = cp_ca_person_id
115: AND ca_sequence_number = cp_ca_sequence_number

Line 113: FROM igs_re_sprvsr

109:
110: CURSOR c_get_supervisor (cp_ca_person_id igs_re_sprvsr.ca_person_id%TYPE,
111: cp_ca_sequence_number igs_re_sprvsr.ca_sequence_number%TYPE) IS
112: SELECT *
113: FROM igs_re_sprvsr
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:

Line 147: l_supvsr_start_dt igs_re_sprvsr.start_dt%TYPE;

143:
144: l_min_submission_dt igs_re_candidature.min_submission_dt%TYPE;
145: l_max_submission_dt igs_re_candidature.max_submission_dt%TYPE;
146:
147: l_supvsr_start_dt igs_re_sprvsr.start_dt%TYPE;
148: l_supvsr_end_dt igs_re_sprvsr.end_dt%TYPE;
149: l_comm_date_offset NUMBER;
150:
151:

Line 148: l_supvsr_end_dt igs_re_sprvsr.end_dt%TYPE;

144: l_min_submission_dt igs_re_candidature.min_submission_dt%TYPE;
145: l_max_submission_dt igs_re_candidature.max_submission_dt%TYPE;
146:
147: l_supvsr_start_dt igs_re_sprvsr.start_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;

Line 401: IGS_RE_SPRVSR_PKG.INSERT_ROW(

397: l_supvsr_end_dt := l_get_supervisor_rec.end_dt + l_comm_date_offset;
398:
399: l_rowid_child1 := NULL;
400:
401: IGS_RE_SPRVSR_PKG.INSERT_ROW(
402: X_ROWID => l_rowid_child1,
403: X_CA_PERSON_ID => p_person_id,
404: X_CA_SEQUENCE_NUMBER => l_get_candidature_sequence,
405: X_PERSON_ID => l_get_supervisor_rec.person_id,