eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_INT_RECONSIDER dependencies on IGS_RE_THESIS

Line 47: CURSOR c_get_thesis (cp_person_id igs_re_thesis_all.person_id%TYPE,

43: FROM dual;
44:
45: l_get_candidature_sequence igs_re_candidature.sequence_number%TYPE;
46:
47: CURSOR c_get_thesis (cp_person_id igs_re_thesis_all.person_id%TYPE,
48: cp_ca_sequence_number igs_re_thesis_all.ca_sequence_number%TYPE) IS
49: SELECT *
50: FROM igs_re_thesis_all
51: WHERE person_id = cp_person_id

Line 48: cp_ca_sequence_number igs_re_thesis_all.ca_sequence_number%TYPE) IS

44:
45: l_get_candidature_sequence igs_re_candidature.sequence_number%TYPE;
46:
47: CURSOR c_get_thesis (cp_person_id igs_re_thesis_all.person_id%TYPE,
48: cp_ca_sequence_number igs_re_thesis_all.ca_sequence_number%TYPE) IS
49: SELECT *
50: FROM igs_re_thesis_all
51: WHERE person_id = cp_person_id
52: AND ca_sequence_number = cp_ca_sequence_number;

Line 50: FROM igs_re_thesis_all

46:
47: CURSOR c_get_thesis (cp_person_id igs_re_thesis_all.person_id%TYPE,
48: cp_ca_sequence_number igs_re_thesis_all.ca_sequence_number%TYPE) IS
49: SELECT *
50: FROM igs_re_thesis_all
51: WHERE person_id = cp_person_id
52: AND ca_sequence_number = cp_ca_sequence_number;
53:
54: CURSOR c_get_thesis_sequence IS

Line 55: SELECT igs_re_thesis_seq_num_s.nextval

51: WHERE person_id = cp_person_id
52: AND ca_sequence_number = cp_ca_sequence_number;
53:
54: CURSOR c_get_thesis_sequence IS
55: SELECT igs_re_thesis_seq_num_s.nextval
56: FROM dual;
57:
58: l_get_thesis_sequence igs_re_thesis_all.sequence_number%TYPE;
59:

Line 58: l_get_thesis_sequence igs_re_thesis_all.sequence_number%TYPE;

54: CURSOR c_get_thesis_sequence IS
55: SELECT igs_re_thesis_seq_num_s.nextval
56: FROM dual;
57:
58: l_get_thesis_sequence igs_re_thesis_all.sequence_number%TYPE;
59:
60: CURSOR c_get_cdt_fld_of_sy (cp_person_id igs_re_cdt_fld_of_sy.person_id%TYPE,
61: cp_ca_sequence_number igs_re_cdt_fld_of_sy.ca_sequence_number%TYPE) IS
62: SELECT *

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 131: l_expected_submission_dt igs_re_thesis.expected_submission_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 ;
135:

Line 132: l_embargo_expiry_dt igs_re_thesis.embargo_expiry_dt%TYPE;

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 ;
135:
136: v_message_name VARCHAR2(30);

Line 204: IGS_RE_THESIS_PKG.INSERT_ROW(

200: CLOSE c_get_thesis_sequence;
201:
202: l_rowid_child1 := NULL;
203:
204: IGS_RE_THESIS_PKG.INSERT_ROW(
205: X_ROWID => l_rowid_child1,
206: X_PERSON_ID => p_person_id,
207: X_CA_SEQUENCE_NUMBER => l_get_candidature_sequence,
208: X_SEQUENCE_NUMBER => l_get_thesis_sequence,

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,