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_GE_DATE

Line 129: NVL(old_references.expected_submission_dt,igs_ge_date.igsdate('1900/01/01')) <>

125: old_references.final_title_ind <> new_references.final_title_ind OR
126: NVL(old_references.short_title,' ') <> NVL(new_references.short_title,' ') OR
127: NVL(old_references.abbreviated_title,' ') <> NVL(new_references.abbreviated_title,' ') OR
128: NVL(old_references.thesis_result_cd,' ') <> NVL(new_references.thesis_result_cd,' ') OR
129: NVL(old_references.expected_submission_dt,igs_ge_date.igsdate('1900/01/01')) <>
130: NVL(new_references.expected_submission_dt,igs_ge_date.igsdate('1900/01/01')) OR
131: NVL(old_references.library_lodgement_dt,igs_ge_date.igsdate('1900/01/01')) <>
132: NVL(new_references.library_lodgement_dt,igs_ge_date.igsdate('1900/01/01')) OR
133: NVL(old_references.library_catalogue_number,' ') <>

Line 130: NVL(new_references.expected_submission_dt,igs_ge_date.igsdate('1900/01/01')) OR

126: NVL(old_references.short_title,' ') <> NVL(new_references.short_title,' ') OR
127: NVL(old_references.abbreviated_title,' ') <> NVL(new_references.abbreviated_title,' ') OR
128: NVL(old_references.thesis_result_cd,' ') <> NVL(new_references.thesis_result_cd,' ') OR
129: NVL(old_references.expected_submission_dt,igs_ge_date.igsdate('1900/01/01')) <>
130: NVL(new_references.expected_submission_dt,igs_ge_date.igsdate('1900/01/01')) OR
131: NVL(old_references.library_lodgement_dt,igs_ge_date.igsdate('1900/01/01')) <>
132: NVL(new_references.library_lodgement_dt,igs_ge_date.igsdate('1900/01/01')) OR
133: NVL(old_references.library_catalogue_number,' ') <>
134: NVL(new_references.library_catalogue_number,' ') OR

Line 131: NVL(old_references.library_lodgement_dt,igs_ge_date.igsdate('1900/01/01')) <>

127: NVL(old_references.abbreviated_title,' ') <> NVL(new_references.abbreviated_title,' ') OR
128: NVL(old_references.thesis_result_cd,' ') <> NVL(new_references.thesis_result_cd,' ') OR
129: NVL(old_references.expected_submission_dt,igs_ge_date.igsdate('1900/01/01')) <>
130: NVL(new_references.expected_submission_dt,igs_ge_date.igsdate('1900/01/01')) OR
131: NVL(old_references.library_lodgement_dt,igs_ge_date.igsdate('1900/01/01')) <>
132: NVL(new_references.library_lodgement_dt,igs_ge_date.igsdate('1900/01/01')) OR
133: NVL(old_references.library_catalogue_number,' ') <>
134: NVL(new_references.library_catalogue_number,' ') OR
135: NVL(old_references.embargo_expiry_dt,igs_ge_date.igsdate('1900/01/01')) <>

Line 132: NVL(new_references.library_lodgement_dt,igs_ge_date.igsdate('1900/01/01')) OR

128: NVL(old_references.thesis_result_cd,' ') <> NVL(new_references.thesis_result_cd,' ') OR
129: NVL(old_references.expected_submission_dt,igs_ge_date.igsdate('1900/01/01')) <>
130: NVL(new_references.expected_submission_dt,igs_ge_date.igsdate('1900/01/01')) OR
131: NVL(old_references.library_lodgement_dt,igs_ge_date.igsdate('1900/01/01')) <>
132: NVL(new_references.library_lodgement_dt,igs_ge_date.igsdate('1900/01/01')) OR
133: NVL(old_references.library_catalogue_number,' ') <>
134: NVL(new_references.library_catalogue_number,' ') OR
135: NVL(old_references.embargo_expiry_dt,igs_ge_date.igsdate('1900/01/01')) <>
136: NVL(new_references.embargo_expiry_dt,igs_ge_date.igsdate('1900/01/01')) OR

Line 135: NVL(old_references.embargo_expiry_dt,igs_ge_date.igsdate('1900/01/01')) <>

131: NVL(old_references.library_lodgement_dt,igs_ge_date.igsdate('1900/01/01')) <>
132: NVL(new_references.library_lodgement_dt,igs_ge_date.igsdate('1900/01/01')) OR
133: NVL(old_references.library_catalogue_number,' ') <>
134: NVL(new_references.library_catalogue_number,' ') OR
135: NVL(old_references.embargo_expiry_dt,igs_ge_date.igsdate('1900/01/01')) <>
136: NVL(new_references.embargo_expiry_dt,igs_ge_date.igsdate('1900/01/01')) OR
137: NVL(old_references.thesis_format,' ') <> NVL(new_references.thesis_format,' ') OR
138: NVL(old_references.embargo_details,' ') <> NVL(new_references.embargo_details,' ') OR
139: NVL(old_references.thesis_topic,' ') <> NVL(new_references.thesis_topic,' ') OR

Line 136: NVL(new_references.embargo_expiry_dt,igs_ge_date.igsdate('1900/01/01')) OR

132: NVL(new_references.library_lodgement_dt,igs_ge_date.igsdate('1900/01/01')) OR
133: NVL(old_references.library_catalogue_number,' ') <>
134: NVL(new_references.library_catalogue_number,' ') OR
135: NVL(old_references.embargo_expiry_dt,igs_ge_date.igsdate('1900/01/01')) <>
136: NVL(new_references.embargo_expiry_dt,igs_ge_date.igsdate('1900/01/01')) OR
137: NVL(old_references.thesis_format,' ') <> NVL(new_references.thesis_format,' ') OR
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

Line 179: NVL(old_references.embargo_expiry_dt,igs_ge_date.igsdate('1900/01/01')) <>

175: END IF;
176: IF p_inserting OR
177: ( p_updating AND
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,

Line 180: NVL(new_references.embargo_expiry_dt,igs_ge_date.igsdate('1900/01/01'))) THEN

176: IF p_inserting OR
177: ( p_updating AND
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,

Line 209: NVL(old_references.library_lodgement_dt,igs_ge_date.igsdate('1900/01/01')) <>

205: IF p_inserting OR
206: ( p_updating AND
207: NVL(old_references.library_catalogue_number,' ') <>
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,

Line 210: NVL(new_references.library_lodgement_dt,igs_ge_date.igsdate('1900/01/01'))) THEN

206: ( p_updating AND
207: NVL(old_references.library_catalogue_number,' ') <>
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,

Line 255: ( NVL(old_references.logical_delete_dt,igs_ge_date.igsdate('1900/01/01')) <>

251: END IF;
252: END IF;
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

Line 256: NVL(new_references.logical_delete_dt,igs_ge_date.igsdate('1900/01/01'))) THEN

252: END IF;
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);

Line 268: NVL(old_references.expected_submission_dt,igs_ge_date.igsdate('1900/01/01')) <>

264: END IF;
265: IF p_inserting OR
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,