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_THS_PNL_MBR_PKG dependencies on IGS_GE_DATE

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

96: IF p_inserting OR
97: ( p_updating AND
98: ( NVL(old_references.thesis_result_cd,' ') <> NVL(new_references.thesis_result_cd,' ') OR
99: old_references.panel_member_type <> new_references.panel_member_type OR
100: NVL(old_references.confirmed_dt, igs_ge_date.igsdate('1900/01/01')) <>
101: NVL(new_references.confirmed_dt, igs_ge_date.igsdate('1900/01/01')))) THEN
102: IF p_inserting THEN
103: v_transaction_type := 'INSERT';
104: ELSIF p_updating THEN

Line 101: NVL(new_references.confirmed_dt, igs_ge_date.igsdate('1900/01/01')))) THEN

97: ( p_updating AND
98: ( NVL(old_references.thesis_result_cd,' ') <> NVL(new_references.thesis_result_cd,' ') OR
99: old_references.panel_member_type <> new_references.panel_member_type OR
100: NVL(old_references.confirmed_dt, igs_ge_date.igsdate('1900/01/01')) <>
101: NVL(new_references.confirmed_dt, igs_ge_date.igsdate('1900/01/01')))) THEN
102: IF p_inserting THEN
103: v_transaction_type := 'INSERT';
104: ELSIF p_updating THEN
105: v_transaction_type := 'UPDATE';

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

180: END IF;
181: END IF;
182: IF p_inserting OR
183: ( p_updating AND
184: (NVL(old_references.confirmed_dt,igs_ge_date.igsdate('1900/01/01')) <>
185: NVL(new_references.confirmed_dt,igs_ge_date.igsdate('1900/01/01')) OR
186: NVL(old_references.declined_dt,igs_ge_date.igsdate('1900/01/01')) <>
187: NVL(new_references.declined_dt,igs_ge_date.igsdate('1900/01/01')))) THEN
188: -- Validate declined date and confirmed dates.

Line 185: NVL(new_references.confirmed_dt,igs_ge_date.igsdate('1900/01/01')) OR

181: END IF;
182: IF p_inserting OR
183: ( p_updating AND
184: (NVL(old_references.confirmed_dt,igs_ge_date.igsdate('1900/01/01')) <>
185: NVL(new_references.confirmed_dt,igs_ge_date.igsdate('1900/01/01')) OR
186: NVL(old_references.declined_dt,igs_ge_date.igsdate('1900/01/01')) <>
187: NVL(new_references.declined_dt,igs_ge_date.igsdate('1900/01/01')))) THEN
188: -- Validate declined date and confirmed dates.
189: IF IGS_RE_VAL_TPM.resp_val_tpm_dcln( new_references.declined_dt,

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

182: IF p_inserting OR
183: ( p_updating AND
184: (NVL(old_references.confirmed_dt,igs_ge_date.igsdate('1900/01/01')) <>
185: NVL(new_references.confirmed_dt,igs_ge_date.igsdate('1900/01/01')) OR
186: NVL(old_references.declined_dt,igs_ge_date.igsdate('1900/01/01')) <>
187: NVL(new_references.declined_dt,igs_ge_date.igsdate('1900/01/01')))) THEN
188: -- Validate declined date and confirmed dates.
189: IF IGS_RE_VAL_TPM.resp_val_tpm_dcln( new_references.declined_dt,
190: new_references.confirmed_dt,

Line 187: NVL(new_references.declined_dt,igs_ge_date.igsdate('1900/01/01')))) THEN

183: ( p_updating AND
184: (NVL(old_references.confirmed_dt,igs_ge_date.igsdate('1900/01/01')) <>
185: NVL(new_references.confirmed_dt,igs_ge_date.igsdate('1900/01/01')) OR
186: NVL(old_references.declined_dt,igs_ge_date.igsdate('1900/01/01')) <>
187: NVL(new_references.declined_dt,igs_ge_date.igsdate('1900/01/01')))) THEN
188: -- Validate declined date and confirmed dates.
189: IF IGS_RE_VAL_TPM.resp_val_tpm_dcln( new_references.declined_dt,
190: new_references.confirmed_dt,
191: v_message_name) = FALSE THEN

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

204: END IF;
205: END IF;
206: IF ( p_inserting AND new_references.paid_dt IS NOT NULL ) OR
207: ( p_updating AND
208: NVL(old_references.paid_dt,igs_ge_date.igsdate('1900/01/01')) <>
209: NVL(new_references.paid_dt,igs_ge_date.igsdate('1900/01/01'))) THEN
210: -- Validate the paid date.
211: IF IGS_RE_VAL_TPM.resp_val_tpm_paid( new_references.paid_dt,
212: new_references.confirmed_dt,

Line 209: NVL(new_references.paid_dt,igs_ge_date.igsdate('1900/01/01'))) THEN

205: END IF;
206: IF ( p_inserting AND new_references.paid_dt IS NOT NULL ) OR
207: ( p_updating AND
208: NVL(old_references.paid_dt,igs_ge_date.igsdate('1900/01/01')) <>
209: NVL(new_references.paid_dt,igs_ge_date.igsdate('1900/01/01'))) THEN
210: -- Validate the paid date.
211: IF IGS_RE_VAL_TPM.resp_val_tpm_paid( new_references.paid_dt,
212: new_references.confirmed_dt,
213: v_message_name ) = FALSE THEN