DBA Data[Home] [Help]

APPS.IGS_PR_RU_APPL_PKG dependencies on FND_DATE

Line 151: NVL((fnd_date.date_to_canonical(new_references.ou_start_dt)), '1900/01/01') <>

147: -- Validate the IGS_OR_UNIT is active
148: IF p_inserting OR
149: (p_updating AND (NVL(new_references.ou_org_unit_cd, 'NULL') <>
150: NVL(old_references.ou_org_unit_cd,'NULL') OR
151: NVL((fnd_date.date_to_canonical(new_references.ou_start_dt)), '1900/01/01') <>
152: NVL((fnd_date.date_to_canonical(old_references.ou_start_dt)), '1900/01/01'))) THEN
153: IF IGS_PR_VAL_SOPC.prgp_val_ou_active (
154: new_references.ou_org_unit_cd,
155: new_references.ou_start_dt,

Line 152: NVL((fnd_date.date_to_canonical(old_references.ou_start_dt)), '1900/01/01'))) THEN

148: IF p_inserting OR
149: (p_updating AND (NVL(new_references.ou_org_unit_cd, 'NULL') <>
150: NVL(old_references.ou_org_unit_cd,'NULL') OR
151: NVL((fnd_date.date_to_canonical(new_references.ou_start_dt)), '1900/01/01') <>
152: NVL((fnd_date.date_to_canonical(old_references.ou_start_dt)), '1900/01/01'))) THEN
153: IF IGS_PR_VAL_SOPC.prgp_val_ou_active (
154: new_references.ou_org_unit_cd,
155: new_references.ou_start_dt,
156: v_message_name) = FALSE THEN