DBA Data[Home] [Help]

APPS.IGS_PE_PERSON_ALIAS_PKG dependencies on IGS_GE_DATE

Line 111: (NVL(old_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <> new_references.end_dt))

107: -- Validate START DATE AND END DATE.
108: -- Validate that if end date is specified, then start date is also specified.
109: IF (new_references.end_dt IS NOT NULL) AND
110: ((p_inserting OR p_updating) OR
111: (NVL(old_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <> new_references.end_dt))
112: THEN
113: IF IGS_EN_VAL_PAL.enrp_val_api_end_dt (
114: new_references.start_dt,
115: new_references.end_dt,

Line 125: (NVL(old_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <> new_references.end_dt)) THEN

121: END IF;
122: -- Validate that if both are specified, then end is not greater than start.
123: IF (new_references.end_dt IS NOT NULL) AND
124: ((p_inserting OR p_updating) OR
125: (NVL(old_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <> new_references.end_dt)) THEN
126: IF igs_ad_val_edtl.genp_val_strt_end_dt (
127: new_references.start_dt,
128: new_references.end_dt,
129: v_message_name) = FALSE THEN