DBA Data[Home] [Help]

APPS.IGS_AS_UNITASS_ITEM_PKG dependencies on IGS_GE_DATE

Line 257: igs_ge_date.igsdate ('1900/01/01')

253: IF (NVL (new_references.dflt_item_ind, 'x') <>
254: NVL (old_references.dflt_item_ind, 'x')
255: OR NVL (
256: new_references.logical_delete_dt,
257: igs_ge_date.igsdate ('1900/01/01')
258: ) <> NVL (
259: old_references.logical_delete_dt,
260: igs_ge_date.igsdate ('1900/01/01')
261: )

Line 260: igs_ge_date.igsdate ('1900/01/01')

256: new_references.logical_delete_dt,
257: igs_ge_date.igsdate ('1900/01/01')
258: ) <> NVL (
259: old_references.logical_delete_dt,
260: igs_ge_date.igsdate ('1900/01/01')
261: )
262: ) THEN
263: IF NVL (old_references.action_dt, igs_ge_date.igsdate ('1900/01/01')) =
264: igs_ge_date.igsdate ('1900/01/01') THEN

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

259: old_references.logical_delete_dt,
260: igs_ge_date.igsdate ('1900/01/01')
261: )
262: ) THEN
263: IF NVL (old_references.action_dt, igs_ge_date.igsdate ('1900/01/01')) =
264: igs_ge_date.igsdate ('1900/01/01') THEN
265: new_references.action_dt := SYSDATE;
266: END IF;
267: END IF;

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

260: igs_ge_date.igsdate ('1900/01/01')
261: )
262: ) THEN
263: IF NVL (old_references.action_dt, igs_ge_date.igsdate ('1900/01/01')) =
264: igs_ge_date.igsdate ('1900/01/01') THEN
265: new_references.action_dt := SYSDATE;
266: END IF;
267: END IF;
268: END IF;

Line 310: igs_ge_date.igsdate ('1900/01/01')

306: --
307: -- if record has not been deleted
308: IF NVL (
309: new_references.logical_delete_dt,
310: igs_ge_date.igsdate ('1900/01/01')
311: ) = igs_ge_date.igsdate ('1900/01/01') THEN
312: -- Validate that the reference number id unique within a UOP
313: IF igs_as_val_uai.assp_val_uai_opt_ref (
314: new_references.unit_cd,

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

307: -- if record has not been deleted
308: IF NVL (
309: new_references.logical_delete_dt,
310: igs_ge_date.igsdate ('1900/01/01')
311: ) = igs_ge_date.igsdate ('1900/01/01') THEN
312: -- Validate that the reference number id unique within a UOP
313: IF igs_as_val_uai.assp_val_uai_opt_ref (
314: new_references.unit_cd,
315: new_references.version_number,