DBA Data[Home] [Help]

APPS.IGS_TR_STEP_PKG dependencies on IGS_GE_DATE

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

116: -- indicator.
117: IF (p_inserting OR
118: (p_updating AND ((old_references.step_completion_ind <> new_references.step_completion_ind) OR
119: (old_references.by_pass_ind <> new_references.by_pass_ind) OR
120: (NVL(old_references.completion_dt, igs_ge_date.igsdate ('1900/01/01')) <>
121: NVL(new_references.completion_dt, igs_ge_date.igsdate ('1900/01/01')))))) THEN
122:
123: IF igs_tr_val_trst.trkp_val_trst_sci_cd(
124: new_references.step_completion_ind,

Line 121: NVL(new_references.completion_dt, igs_ge_date.igsdate ('1900/01/01')))))) THEN

117: IF (p_inserting OR
118: (p_updating AND ((old_references.step_completion_ind <> new_references.step_completion_ind) OR
119: (old_references.by_pass_ind <> new_references.by_pass_ind) OR
120: (NVL(old_references.completion_dt, igs_ge_date.igsdate ('1900/01/01')) <>
121: NVL(new_references.completion_dt, igs_ge_date.igsdate ('1900/01/01')))))) THEN
122:
123: IF igs_tr_val_trst.trkp_val_trst_sci_cd(
124: new_references.step_completion_ind,
125: new_references.completion_dt,