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

Line 105: (NVL(new_references.end_dt,igs_ge_date.igsdate('9999/01/01')) <>

101: IF igs_as_val_suaap.genp_val_sdtt_sess('ENRP_INS_CA_TRNSFR') THEN
102: IF p_inserting OR
103: (p_updating AND
104: (new_references.start_dt <> old_references.start_dt) OR
105: (NVL(new_references.end_dt,igs_ge_date.igsdate('9999/01/01')) <>
106: NVL(old_references.end_dt,igs_ge_date.igsdate('9999/01/01'))) OR
107: (NVL(new_references.supervision_percentage,-1) <>
108: NVL(old_references.supervision_percentage,-1)) OR
109: (new_references.research_supervisor_type <>

Line 106: NVL(old_references.end_dt,igs_ge_date.igsdate('9999/01/01'))) OR

102: IF p_inserting OR
103: (p_updating AND
104: (new_references.start_dt <> old_references.start_dt) OR
105: (NVL(new_references.end_dt,igs_ge_date.igsdate('9999/01/01')) <>
106: NVL(old_references.end_dt,igs_ge_date.igsdate('9999/01/01'))) OR
107: (NVL(new_references.supervision_percentage,-1) <>
108: NVL(old_references.supervision_percentage,-1)) OR
109: (new_references.research_supervisor_type <>
110: old_references.research_supervisor_type) OR

Line 187: (NVL(new_references.ou_start_dt,igs_ge_date.igsdate('9999/01/01')) <>

183: IF p_inserting OR
184: (p_updating AND
185: NVL(new_references.funding_percentage,-1) = NVL(old_references.funding_percentage,-1) AND
186: ((NVL(new_references.org_unit_cd,'NULL') <> NVL(old_references.org_unit_cd,'NULL')) OR
187: (NVL(new_references.ou_start_dt,igs_ge_date.igsdate('9999/01/01')) <>
188: NVL(old_references.ou_start_dt,igs_ge_date.igsdate('9999/01/01'))))) THEN
189:
190: IF IGS_RE_VAL_RSUP.resp_val_rsup_ou(
191: new_references.person_id,

Line 188: NVL(old_references.ou_start_dt,igs_ge_date.igsdate('9999/01/01'))))) THEN

184: (p_updating AND
185: NVL(new_references.funding_percentage,-1) = NVL(old_references.funding_percentage,-1) AND
186: ((NVL(new_references.org_unit_cd,'NULL') <> NVL(old_references.org_unit_cd,'NULL')) OR
187: (NVL(new_references.ou_start_dt,igs_ge_date.igsdate('9999/01/01')) <>
188: NVL(old_references.ou_start_dt,igs_ge_date.igsdate('9999/01/01'))))) THEN
189:
190: IF IGS_RE_VAL_RSUP.resp_val_rsup_ou(
191: new_references.person_id,
192: new_references.org_unit_cd,

Line 244: IF (NVL( NEW_REFERENCES.end_dt,igs_ge_date.igsdate('9999/01/01')) <>

240: -- Set rowid
241:
242:
243: --Validate research supervisor end date
244: IF (NVL( NEW_REFERENCES.end_dt,igs_ge_date.igsdate('9999/01/01')) <>
245: NVL(OLD_REFERENCES.end_dt,igs_ge_date.igsdate('9999/01/01')))
246: THEN
247: IF IGS_RE_VAL_RSUP.resp_val_rsup_end_dt(
248: NEW_REFERENCES.ca_person_id,

Line 245: NVL(OLD_REFERENCES.end_dt,igs_ge_date.igsdate('9999/01/01')))

241:
242:
243: --Validate research supervisor end date
244: IF (NVL( NEW_REFERENCES.end_dt,igs_ge_date.igsdate('9999/01/01')) <>
245: NVL(OLD_REFERENCES.end_dt,igs_ge_date.igsdate('9999/01/01')))
246: THEN
247: IF IGS_RE_VAL_RSUP.resp_val_rsup_end_dt(
248: NEW_REFERENCES.ca_person_id,
249: NEW_REFERENCES.ca_sequence_number,

Line 266: (NVL(NEW_REFERENCES.end_dt,igs_ge_date.igsdate('9999/01/01')) <>

262: -- Validate research supervisor overlapping periods
263: IF p_inserting OR
264: (p_updating AND
265: (NEW_REFERENCES.start_dt <> OLD_REFERENCES.start_dt) OR
266: (NVL(NEW_REFERENCES.end_dt,igs_ge_date.igsdate('9999/01/01')) <>
267: NVL(OLD_REFERENCES.end_dt,igs_ge_date.igsdate('9999/01/01'))))
268: THEN
269: IF IGS_RE_VAL_RSUP.resp_val_rsup_ovrlp(
270: NEW_REFERENCES.ca_person_id,

Line 267: NVL(OLD_REFERENCES.end_dt,igs_ge_date.igsdate('9999/01/01'))))

263: IF p_inserting OR
264: (p_updating AND
265: (NEW_REFERENCES.start_dt <> OLD_REFERENCES.start_dt) OR
266: (NVL(NEW_REFERENCES.end_dt,igs_ge_date.igsdate('9999/01/01')) <>
267: NVL(OLD_REFERENCES.end_dt,igs_ge_date.igsdate('9999/01/01'))))
268: THEN
269: IF IGS_RE_VAL_RSUP.resp_val_rsup_ovrlp(
270: NEW_REFERENCES.ca_person_id,
271: NEW_REFERENCES.ca_sequence_number,

Line 315: (NVL(NEW_REFERENCES.end_dt,igs_ge_date.igsdate('9999/01/01')) <>

311: -- Validate supervision and funding percentage
312: IF p_inserting OR
313: (p_updating AND
314: (NEW_REFERENCES.start_dt <> OLD_REFERENCES.start_dt) OR
315: (NVL(NEW_REFERENCES.end_dt,igs_ge_date.igsdate('9999/01/01')) <>
316: NVL(OLD_REFERENCES.end_dt,
317: igs_ge_date.igsdate('9999/01/01'))) OR
318: (NVL(NEW_REFERENCES.supervision_percentage,-1) <>
319: NVL(OLD_REFERENCES.supervision_percentage,-1)) OR

Line 317: igs_ge_date.igsdate('9999/01/01'))) OR

313: (p_updating AND
314: (NEW_REFERENCES.start_dt <> OLD_REFERENCES.start_dt) OR
315: (NVL(NEW_REFERENCES.end_dt,igs_ge_date.igsdate('9999/01/01')) <>
316: NVL(OLD_REFERENCES.end_dt,
317: igs_ge_date.igsdate('9999/01/01'))) OR
318: (NVL(NEW_REFERENCES.supervision_percentage,-1) <>
319: NVL(OLD_REFERENCES.supervision_percentage,-1)) OR
320: (NVL(NEW_REFERENCES.funding_percentage,-1) <>
321: NVL(OLD_REFERENCES.funding_percentage,-1))) THEN