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_VAL_ACAI_FTR_OFFER dependencies on IGS_RE_THESIS

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

65: FROM dual;
66:
67: l_get_candidature_sequence igs_re_candidature.sequence_number%TYPE;
68:
69: CURSOR c_get_thesis (cp_person_id igs_re_thesis_all.person_id%TYPE,
70: cp_ca_sequence_number igs_re_thesis_all.ca_sequence_number%TYPE) IS
71: SELECT *
72: FROM igs_re_thesis_all
73: WHERE person_id = cp_person_id

Line 70: cp_ca_sequence_number igs_re_thesis_all.ca_sequence_number%TYPE) IS

66:
67: l_get_candidature_sequence igs_re_candidature.sequence_number%TYPE;
68:
69: CURSOR c_get_thesis (cp_person_id igs_re_thesis_all.person_id%TYPE,
70: cp_ca_sequence_number igs_re_thesis_all.ca_sequence_number%TYPE) IS
71: SELECT *
72: FROM igs_re_thesis_all
73: WHERE person_id = cp_person_id
74: AND ca_sequence_number = cp_ca_sequence_number;

Line 72: FROM igs_re_thesis_all

68:
69: CURSOR c_get_thesis (cp_person_id igs_re_thesis_all.person_id%TYPE,
70: cp_ca_sequence_number igs_re_thesis_all.ca_sequence_number%TYPE) IS
71: SELECT *
72: FROM igs_re_thesis_all
73: WHERE person_id = cp_person_id
74: AND ca_sequence_number = cp_ca_sequence_number;
75:
76: CURSOR c_get_thesis_sequence IS

Line 77: SELECT igs_re_thesis_seq_num_s.nextval

73: WHERE person_id = cp_person_id
74: AND ca_sequence_number = cp_ca_sequence_number;
75:
76: CURSOR c_get_thesis_sequence IS
77: SELECT igs_re_thesis_seq_num_s.nextval
78: FROM dual;
79:
80: l_get_thesis_sequence igs_re_thesis_all.sequence_number%TYPE;
81:

Line 80: l_get_thesis_sequence igs_re_thesis_all.sequence_number%TYPE;

76: CURSOR c_get_thesis_sequence IS
77: SELECT igs_re_thesis_seq_num_s.nextval
78: FROM dual;
79:
80: l_get_thesis_sequence igs_re_thesis_all.sequence_number%TYPE;
81:
82: CURSOR c_get_cdt_fld_of_sy (cp_person_id igs_re_cdt_fld_of_sy.person_id%TYPE,
83: cp_ca_sequence_number igs_re_cdt_fld_of_sy.ca_sequence_number%TYPE) IS
84: SELECT *

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 153: l_expected_submission_dt igs_re_thesis.expected_submission_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 ;
157:

Line 154: l_embargo_expiry_dt igs_re_thesis.embargo_expiry_dt%TYPE;

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 ;
157:
158: v_message_name VARCHAR2(30);

Line 226: IGS_RE_THESIS_PKG.INSERT_ROW(

222: CLOSE c_get_thesis_sequence;
223:
224: l_rowid_child1 := NULL;
225:
226: IGS_RE_THESIS_PKG.INSERT_ROW(
227: X_ROWID => l_rowid_child1,
228: X_PERSON_ID => p_person_id,
229: X_CA_SEQUENCE_NUMBER => l_get_candidature_sequence,
230: X_SEQUENCE_NUMBER => l_get_thesis_sequence,

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,