APPS.IGS_AD_INT_RECONSIDER dependencies on IGS_RE_SPRVSR

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

84: FROM igs_pr_milestone_all
85: WHERE person_id = cp_person_id
86: AND ca_sequence_number = cp_ca_sequence_number;
87:
88: CURSOR c_get_supervisor (cp_ca_person_id igs_re_sprvsr.ca_person_id%TYPE,
89: cp_ca_sequence_number igs_re_sprvsr.ca_sequence_number%TYPE) IS
90: SELECT *
91: FROM igs_re_sprvsr
92: WHERE ca_person_id = cp_ca_person_id

Line 89: cp_ca_sequence_number igs_re_sprvsr.ca_sequence_number%TYPE) IS

85: WHERE person_id = cp_person_id
86: AND ca_sequence_number = cp_ca_sequence_number;
87:
88: CURSOR c_get_supervisor (cp_ca_person_id igs_re_sprvsr.ca_person_id%TYPE,
89: cp_ca_sequence_number igs_re_sprvsr.ca_sequence_number%TYPE) IS
90: SELECT *
91: FROM igs_re_sprvsr
92: WHERE ca_person_id = cp_ca_person_id
93: AND ca_sequence_number = cp_ca_sequence_number

Line 91: FROM igs_re_sprvsr

87:
88: CURSOR c_get_supervisor (cp_ca_person_id igs_re_sprvsr.ca_person_id%TYPE,
89: cp_ca_sequence_number igs_re_sprvsr.ca_sequence_number%TYPE) IS
90: SELECT *
91: FROM igs_re_sprvsr
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:

Line 125: l_supvsr_start_dt igs_re_sprvsr.start_dt%TYPE;

121:
122: l_min_submission_dt igs_re_candidature.min_submission_dt%TYPE;
123: l_max_submission_dt igs_re_candidature.max_submission_dt%TYPE;
124:
125: l_supvsr_start_dt igs_re_sprvsr.start_dt%TYPE;
126: l_supvsr_end_dt igs_re_sprvsr.end_dt%TYPE;
127: l_comm_date_offset NUMBER;
128:
129:

Line 126: l_supvsr_end_dt igs_re_sprvsr.end_dt%TYPE;

122: l_min_submission_dt igs_re_candidature.min_submission_dt%TYPE;
123: l_max_submission_dt igs_re_candidature.max_submission_dt%TYPE;
124:
125: l_supvsr_start_dt igs_re_sprvsr.start_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;

Line 379: IGS_RE_SPRVSR_PKG.INSERT_ROW(

375: l_supvsr_end_dt := l_get_supervisor_rec.end_dt + l_comm_date_offset;
376:
377: l_rowid_child1 := NULL;
378:
379: IGS_RE_SPRVSR_PKG.INSERT_ROW(
380: X_ROWID => l_rowid_child1,
381: X_CA_PERSON_ID => p_person_id,
382: X_CA_SEQUENCE_NUMBER => l_get_candidature_sequence,
383: X_PERSON_ID => l_get_supervisor_rec.person_id,