[Home] [Help]
2073: ELSIF (p_foreign_database_object_name = 'OE_AK_DEL_TO_CONTACT_V') THEN
2074: IF NVL(p_record.DELIVER_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2075: RETURN NULL;
2076: END IF;
2077: IF ONT_DEL_TO_CON_Def_Util.Sync_DEL_TO_CON_Cache
2078: (p_CONTACT_ID => p_record.DELIVER_TO_CONTACT_ID) = 1 then
2079: RETURN ONT_DEL_TO_CON_Def_Util.Get_Attr_Val_Varchar2
2080: (p_foreign_attr_code,ONT_DEL_TO_CON_Def_Util.g_cached_record);
2081: END IF;
2075: RETURN NULL;
2076: END IF;
2077: IF ONT_DEL_TO_CON_Def_Util.Sync_DEL_TO_CON_Cache
2078: (p_CONTACT_ID => p_record.DELIVER_TO_CONTACT_ID) = 1 then
2079: RETURN ONT_DEL_TO_CON_Def_Util.Get_Attr_Val_Varchar2
2080: (p_foreign_attr_code,ONT_DEL_TO_CON_Def_Util.g_cached_record);
2081: END IF;
2082:
2083: ELSIF (p_foreign_database_object_name = 'OE_AK_DEMAND_CLASS_V') THEN
2076: END IF;
2077: IF ONT_DEL_TO_CON_Def_Util.Sync_DEL_TO_CON_Cache
2078: (p_CONTACT_ID => p_record.DELIVER_TO_CONTACT_ID) = 1 then
2079: RETURN ONT_DEL_TO_CON_Def_Util.Get_Attr_Val_Varchar2
2080: (p_foreign_attr_code,ONT_DEL_TO_CON_Def_Util.g_cached_record);
2081: END IF;
2082:
2083: ELSIF (p_foreign_database_object_name = 'OE_AK_DEMAND_CLASS_V') THEN
2084: IF NVL(p_record.DEMAND_CLASS_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2639: ELSIF (p_foreign_database_object_name = 'OE_AK_DEL_TO_CONTACT_V') THEN
2640: IF NVL(p_record.DELIVER_TO_CONTACT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2641: RETURN NULL;
2642: END IF;
2643: IF ONT_DEL_TO_CON_Def_Util.Sync_DEL_TO_CON_Cache
2644: (p_CONTACT_ID => p_record.DELIVER_TO_CONTACT_ID) = 1 then
2645: RETURN ONT_DEL_TO_CON_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_DEL_TO_CON_Def_Util.g_cached_record);
2646: END IF;
2647:
2641: RETURN NULL;
2642: END IF;
2643: IF ONT_DEL_TO_CON_Def_Util.Sync_DEL_TO_CON_Cache
2644: (p_CONTACT_ID => p_record.DELIVER_TO_CONTACT_ID) = 1 then
2645: RETURN ONT_DEL_TO_CON_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_DEL_TO_CON_Def_Util.g_cached_record);
2646: END IF;
2647:
2648: ELSIF (p_foreign_database_object_name = 'OE_AK_DEMAND_CLASS_V') THEN
2649: IF NVL(p_record.DEMAND_CLASS_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN