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_RE_THESIS_PKG dependencies on IGS_RE_VAL_THE

Line 7: -- igs_re_val_the.resp_val_the_expct, igs_re_val_the.resp_val_the_embrg,

3: -------------------------------------------------------------------------------------------
4: --Change History:
5: --Who When What
6: --Nishikant 19NOV2002 Bug#2661533. In the procedure BeforeRowInsertUpdate1 the calls of the functions
7: -- igs_re_val_the.resp_val_the_expct, igs_re_val_the.resp_val_the_embrg,
8: -- igs_re_val_the.resp_val_the_thr got modified to add one more parameer p_legacy.
9: --smadathi 24-AUG-2001 Bug No. 1956374 .The call to igs_re_val_the.genp_val_sdtt_sess
10: -- is changed to igs_as_val_suaap.genp_val_sdtt_sess
11: -------------------------------------------------------------------------------------------

Line 8: -- igs_re_val_the.resp_val_the_thr got modified to add one more parameer p_legacy.

4: --Change History:
5: --Who When What
6: --Nishikant 19NOV2002 Bug#2661533. In the procedure BeforeRowInsertUpdate1 the calls of the functions
7: -- igs_re_val_the.resp_val_the_expct, igs_re_val_the.resp_val_the_embrg,
8: -- igs_re_val_the.resp_val_the_thr got modified to add one more parameer p_legacy.
9: --smadathi 24-AUG-2001 Bug No. 1956374 .The call to igs_re_val_the.genp_val_sdtt_sess
10: -- is changed to igs_as_val_suaap.genp_val_sdtt_sess
11: -------------------------------------------------------------------------------------------
12: l_rowid VARCHAR2(25);

Line 9: --smadathi 24-AUG-2001 Bug No. 1956374 .The call to igs_re_val_the.genp_val_sdtt_sess

5: --Who When What
6: --Nishikant 19NOV2002 Bug#2661533. In the procedure BeforeRowInsertUpdate1 the calls of the functions
7: -- igs_re_val_the.resp_val_the_expct, igs_re_val_the.resp_val_the_embrg,
8: -- igs_re_val_the.resp_val_the_thr got modified to add one more parameer p_legacy.
9: --smadathi 24-AUG-2001 Bug No. 1956374 .The call to igs_re_val_the.genp_val_sdtt_sess
10: -- is changed to igs_as_val_suaap.genp_val_sdtt_sess
11: -------------------------------------------------------------------------------------------
12: l_rowid VARCHAR2(25);
13: old_references IGS_RE_THESIS_ALL%RowType;

Line 142: IF IGS_RE_VAL_THE.resp_val_the_upd(new_references.logical_delete_dt,

138: NVL(old_references.embargo_details,' ') <> NVL(new_references.embargo_details,' ') OR
139: NVL(old_references.thesis_topic,' ') <> NVL(new_references.thesis_topic,' ') OR
140: NVL(old_references.citation,' ') <> NVL(new_references.citation,' ') OR
141: NVL(old_references.comments,' ') <> NVL(new_references.comments,' ') THEN
142: IF IGS_RE_VAL_THE.resp_val_the_upd(new_references.logical_delete_dt,
143: v_message_name) = FALSE THEN
144: Fnd_Message.Set_Name ('IGS', v_message_name);
145: IGS_GE_MSG_STACK.ADD;
146: App_Exception.Raise_Exception;

Line 153: IF IGS_RE_VAL_THE.resp_val_the_fnl( new_references.person_id,

149: END IF;
150: IF p_updating THEN
151: -- Validate the IGS_RE_THESIS final title indicator.
152: IF old_references.final_title_ind <> new_references.final_title_ind THEN
153: IF IGS_RE_VAL_THE.resp_val_the_fnl( new_references.person_id,
154: new_references.ca_sequence_number,
155: new_references.sequence_number,
156: new_references.final_title_ind,
157: v_thesis_status,

Line 166: IF IGS_RE_VAL_THE.resp_val_the_ttl( old_references.title,

162: END IF;
163: END IF;
164: -- Validate the IGS_RE_THESIS IGS_PE_TITLE
165: IF old_references.title <> new_references.title THEN
166: IF IGS_RE_VAL_THE.resp_val_the_ttl( old_references.title,
167: new_references.title,
168: old_references.thesis_result_cd,
169: v_message_name) = FALSE THEN
170: Fnd_Message.Set_Name ('IGS', v_message_name);

Line 182: IF IGS_RE_VAL_THE.resp_val_the_embrg( new_references.embargo_details,

178: NVL(old_references.embargo_details,' ') <> NVL(new_references.embargo_details,' ') OR
179: NVL(old_references.embargo_expiry_dt,igs_ge_date.igsdate('1900/01/01')) <>
180: NVL(new_references.embargo_expiry_dt,igs_ge_date.igsdate('1900/01/01'))) THEN
181: -- Validate embargo details
182: IF IGS_RE_VAL_THE.resp_val_the_embrg( new_references.embargo_details,
183: old_references.embargo_expiry_dt,
184: new_references.embargo_expiry_dt,
185: v_thesis_status,
186: 'N', --p_legacy parameter

Line 197: IF IGS_RE_VAL_THE.resp_val_the_ctn( v_thesis_status,

193: IF p_inserting OR
194: ( p_updating AND
195: NVL(old_references.citation,' ') <> NVL(new_references.citation,' ')) THEN
196: -- Validate citation
197: IF IGS_RE_VAL_THE.resp_val_the_ctn( v_thesis_status,
198: new_references.citation,
199: v_message_name) = FALSE THEN
200: Fnd_Message.Set_Name ('IGS', v_message_name);
201: IGS_GE_MSG_STACK.ADD;

Line 212: IF IGS_RE_VAL_THE.resp_val_the_lbry( new_references.person_id,

208: NVL(new_references.library_catalogue_number,' ') OR
209: NVL(old_references.library_lodgement_dt,igs_ge_date.igsdate('1900/01/01')) <>
210: NVL(new_references.library_lodgement_dt,igs_ge_date.igsdate('1900/01/01'))) THEN
211: -- Validate library details
212: IF IGS_RE_VAL_THE.resp_val_the_lbry( new_references.person_id,
213: new_references.ca_sequence_number,
214: new_references.sequence_number,
215: new_references.library_catalogue_number,
216: new_references.library_lodgement_dt,

Line 228: IF IGS_RE_VAL_THE.resp_val_the_thr( new_references.person_id,

224: IF p_inserting OR
225: (p_updating AND
226: NVL(old_references.thesis_result_cd,' ') <> NVL(new_references.thesis_result_cd,' ')) THEN
227: -- Validate IGS_RE_THESIS result code
228: IF IGS_RE_VAL_THE.resp_val_the_thr( new_references.person_id,
229: new_references.ca_sequence_number,
230: new_references.sequence_number,
231: new_references.thesis_result_cd,
232: v_thesis_status,

Line 242: IF IGS_RE_VAL_THE.resp_val_the_del( new_references.person_id,

238: END IF;
239: END IF;
240: IF p_updating THEN
241: IF old_references.logical_delete_dt IS NULL AND new_references.logical_delete_dt IS NOT NULL THEN
242: IF IGS_RE_VAL_THE.resp_val_the_del( new_references.person_id,
243: new_references.ca_sequence_number,
244: new_references.sequence_number,
245: new_references.logical_delete_dt,
246: v_thesis_status,

Line 257: IF IGS_RE_VAL_THE.resp_val_the_del_dt( old_references.logical_delete_dt,

253: END IF;
254: IF p_updating AND
255: ( NVL(old_references.logical_delete_dt,igs_ge_date.igsdate('1900/01/01')) <>
256: NVL(new_references.logical_delete_dt,igs_ge_date.igsdate('1900/01/01'))) THEN
257: IF IGS_RE_VAL_THE.resp_val_the_del_dt( old_references.logical_delete_dt,
258: new_references.logical_delete_dt,
259: v_message_name) = FALSE THEN
260: Fnd_Message.Set_Name ('IGS', v_message_name);
261: IGS_GE_MSG_STACK.ADD;

Line 270: IF IGS_RE_VAL_THE.resp_val_the_expct( new_references.person_id,

266: ( p_updating AND
267: ( new_references.expected_submission_dt IS NOT NULL AND
268: NVL(old_references.expected_submission_dt,igs_ge_date.igsdate('1900/01/01')) <>
269: new_references.expected_submission_dt)) THEN
270: IF IGS_RE_VAL_THE.resp_val_the_expct( new_references.person_id,
271: new_references.ca_sequence_number,
272: new_references.expected_submission_dt,
273: 'N', --p_legacy
274: v_message_name) = FALSE THEN