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

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

194: (p_updating AND
195: ((NVL(new_references.location_cd, 'NULL') <> NVL(old_references.location_cd, 'NULL')) OR
196: (NVL(new_references.unit_class,'NULL') <> NVL(old_references.unit_class,'NULL')) OR
197: (new_references.dflt_pattern_ind <> old_references.dflt_pattern_ind) OR
198: (NVL(new_references.logical_delete_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
199: NVL(old_references.logical_delete_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
200: (NVL(new_references.unit_mode,'NULL') <> NVL(old_references.unit_mode,'NULL'))))THEN
201: IF NVL(new_references.action_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))
202: = IGS_GE_DATE.IGSDATE('1900/01/01') THEN

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

195: ((NVL(new_references.location_cd, 'NULL') <> NVL(old_references.location_cd, 'NULL')) OR
196: (NVL(new_references.unit_class,'NULL') <> NVL(old_references.unit_class,'NULL')) OR
197: (new_references.dflt_pattern_ind <> old_references.dflt_pattern_ind) OR
198: (NVL(new_references.logical_delete_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
199: NVL(old_references.logical_delete_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
200: (NVL(new_references.unit_mode,'NULL') <> NVL(old_references.unit_mode,'NULL'))))THEN
201: IF NVL(new_references.action_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))
202: = IGS_GE_DATE.IGSDATE('1900/01/01') THEN
203: new_references.action_dt := SYSDATE;

Line 201: IF NVL(new_references.action_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))

197: (new_references.dflt_pattern_ind <> old_references.dflt_pattern_ind) OR
198: (NVL(new_references.logical_delete_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
199: NVL(old_references.logical_delete_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
200: (NVL(new_references.unit_mode,'NULL') <> NVL(old_references.unit_mode,'NULL'))))THEN
201: IF NVL(new_references.action_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))
202: = IGS_GE_DATE.IGSDATE('1900/01/01') THEN
203: new_references.action_dt := SYSDATE;
204: END IF;
205: END IF;

Line 202: = IGS_GE_DATE.IGSDATE('1900/01/01') THEN

198: (NVL(new_references.logical_delete_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
199: NVL(old_references.logical_delete_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
200: (NVL(new_references.unit_mode,'NULL') <> NVL(old_references.unit_mode,'NULL'))))THEN
201: IF NVL(new_references.action_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))
202: = IGS_GE_DATE.IGSDATE('1900/01/01') THEN
203: new_references.action_dt := SYSDATE;
204: END IF;
205: END IF;
206: END BeforeRowInsertUpdate1;