DBA Data[Home] [Help]

APPS.IGS_AS_EXM_SUPRVISOR_PKG dependencies on IGS_GE_DATE

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

85: IF p_inserting OR
86: (p_updating AND
87: (NVL(new_references.responsible_org_unit_cd, 'NULL') <>
88: NVL(old_references.responsible_org_unit_cd, 'NULL')) OR
89: (NVL(new_references.responsible_ou_start_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
90: NVL(old_references.responsible_ou_start_dt, IGS_GE_DATE.IGSDATE('1900/01/01')))) THEN
91: -- As part of the bug# 1956374 changed to the below call from IGS_AS_VAL_ESU.crsp_val_ou_sys_sts
92: IF IGS_PS_VAL_CRV.crsp_val_ou_sys_sts(new_references.responsible_org_unit_cd,
93: new_references.responsible_ou_start_dt,

Line 90: NVL(old_references.responsible_ou_start_dt, IGS_GE_DATE.IGSDATE('1900/01/01')))) THEN

86: (p_updating AND
87: (NVL(new_references.responsible_org_unit_cd, 'NULL') <>
88: NVL(old_references.responsible_org_unit_cd, 'NULL')) OR
89: (NVL(new_references.responsible_ou_start_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
90: NVL(old_references.responsible_ou_start_dt, IGS_GE_DATE.IGSDATE('1900/01/01')))) THEN
91: -- As part of the bug# 1956374 changed to the below call from IGS_AS_VAL_ESU.crsp_val_ou_sys_sts
92: IF IGS_PS_VAL_CRV.crsp_val_ou_sys_sts(new_references.responsible_org_unit_cd,
93: new_references.responsible_ou_start_dt,
94: v_message_name) = FALSE THEN