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

Line 199: ((NVL(new_references.logical_delete_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>

195: --<>
196: END IF;
197: -- Commented out NOCOPY by DDEY as a part of Bug # 2162831
198: /* IF p_updating AND
199: ((NVL(new_references.logical_delete_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
200: NVL(old_references.logical_delete_dt, IGS_GE_DATE.IGSDATE('1900/01/01')))
201: (NVL(new_references.location_cd, 'NULL') <> NVL(old_references.location_cd, 'NULL')) OR
202: (NVL(new_references.unit_class, 'NULL') <> NVL(old_references.unit_class, 'NULL')) OR
203: (NVL(new_references.unit_mode,'NULL') <> NVL(old_references.unit_mode, 'NULL')))

Line 200: NVL(old_references.logical_delete_dt, IGS_GE_DATE.IGSDATE('1900/01/01')))

196: END IF;
197: -- Commented out NOCOPY by DDEY as a part of Bug # 2162831
198: /* IF p_updating AND
199: ((NVL(new_references.logical_delete_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
200: NVL(old_references.logical_delete_dt, IGS_GE_DATE.IGSDATE('1900/01/01')))
201: (NVL(new_references.location_cd, 'NULL') <> NVL(old_references.location_cd, 'NULL')) OR
202: (NVL(new_references.unit_class, 'NULL') <> NVL(old_references.unit_class, 'NULL')) OR
203: (NVL(new_references.unit_mode,'NULL') <> NVL(old_references.unit_mode, 'NULL')))
204: THEN

Line 271: OR NVL (new_references.logical_delete_dt, igs_ge_date.igsdate ('1900/01/01')) <>

267: IF ( /* NVL(new_references.location_cd, 'x') <> NVL(old_references.location_cd, 'x') OR
268: NVL(new_references.unit_mode,'x') <> NVL(old_references.unit_mode,'x') OR
269: NVL(new_references.unit_class,'x') <> NVL(old_references.unit_class,'x') OR */ -- Commented out NOCOPY by DDEY as a part of Bug # 2162831
270: NVL (new_references.dflt_item_ind, 'x') <> NVL (old_references.dflt_item_ind, 'x')
271: OR NVL (new_references.logical_delete_dt, igs_ge_date.igsdate ('1900/01/01')) <>
272: NVL (old_references.logical_delete_dt, igs_ge_date.igsdate ('1900/01/01'))
273: ) THEN
274: IF NVL (old_references.action_dt, igs_ge_date.igsdate ('1900/01/01')) = igs_ge_date.igsdate ('1900/01/01') THEN
275: new_references.action_dt := TRUNC (SYSDATE);

Line 272: NVL (old_references.logical_delete_dt, igs_ge_date.igsdate ('1900/01/01'))

268: NVL(new_references.unit_mode,'x') <> NVL(old_references.unit_mode,'x') OR
269: NVL(new_references.unit_class,'x') <> NVL(old_references.unit_class,'x') OR */ -- Commented out NOCOPY by DDEY as a part of Bug # 2162831
270: NVL (new_references.dflt_item_ind, 'x') <> NVL (old_references.dflt_item_ind, 'x')
271: OR NVL (new_references.logical_delete_dt, igs_ge_date.igsdate ('1900/01/01')) <>
272: NVL (old_references.logical_delete_dt, igs_ge_date.igsdate ('1900/01/01'))
273: ) THEN
274: IF NVL (old_references.action_dt, igs_ge_date.igsdate ('1900/01/01')) = igs_ge_date.igsdate ('1900/01/01') THEN
275: new_references.action_dt := TRUNC (SYSDATE);
276: END IF;

Line 274: IF NVL (old_references.action_dt, igs_ge_date.igsdate ('1900/01/01')) = igs_ge_date.igsdate ('1900/01/01') THEN

270: NVL (new_references.dflt_item_ind, 'x') <> NVL (old_references.dflt_item_ind, 'x')
271: OR NVL (new_references.logical_delete_dt, igs_ge_date.igsdate ('1900/01/01')) <>
272: NVL (old_references.logical_delete_dt, igs_ge_date.igsdate ('1900/01/01'))
273: ) THEN
274: IF NVL (old_references.action_dt, igs_ge_date.igsdate ('1900/01/01')) = igs_ge_date.igsdate ('1900/01/01') THEN
275: new_references.action_dt := TRUNC (SYSDATE);
276: END IF;
277: END IF;
278: END IF;

Line 315: IF NVL (new_references.logical_delete_dt, igs_ge_date.igsdate ('1900/01/01')) =

311: END IF;
312: ELSE
313: --
314: -- if record has not been deleted
315: IF NVL (new_references.logical_delete_dt, igs_ge_date.igsdate ('1900/01/01')) =
316: igs_ge_date.igsdate ('1900/01/01') THEN
317: -- Validate that the reference number id unique within a UOP
318: IF igs_ps_val_uai.assp_val_uai_opt_ref (
319: lv_unit_cd,

Line 316: igs_ge_date.igsdate ('1900/01/01') THEN

312: ELSE
313: --
314: -- if record has not been deleted
315: IF NVL (new_references.logical_delete_dt, igs_ge_date.igsdate ('1900/01/01')) =
316: igs_ge_date.igsdate ('1900/01/01') THEN
317: -- Validate that the reference number id unique within a UOP
318: IF igs_ps_val_uai.assp_val_uai_opt_ref (
319: lv_unit_cd,
320: lv_version_number,