4312: ELSIF (p_foreign_database_object_name = 'OE_AK_FOB_POINT_V') THEN
4313: IF NVL(p_record.FOB_POINT_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
4314: RETURN NULL;
4315: END IF;
4316: IF ONT_FOB_Def_Util.Sync_FOB_Cache
4317: (p_FOB_POINT_CODE => p_record.FOB_POINT_CODE) = 1 then
4318: RETURN ONT_FOB_Def_Util.Get_Attr_Val_Varchar2
4319: (p_foreign_attr_code,ONT_FOB_Def_Util.g_cached_record);
4320: END IF;
4314: RETURN NULL;
4315: END IF;
4316: IF ONT_FOB_Def_Util.Sync_FOB_Cache
4317: (p_FOB_POINT_CODE => p_record.FOB_POINT_CODE) = 1 then
4318: RETURN ONT_FOB_Def_Util.Get_Attr_Val_Varchar2
4319: (p_foreign_attr_code,ONT_FOB_Def_Util.g_cached_record);
4320: END IF;
4321:
4322: ELSIF (p_foreign_database_object_name = 'OE_AK_FREIGHT_TERMS_V') THEN
4315: END IF;
4316: IF ONT_FOB_Def_Util.Sync_FOB_Cache
4317: (p_FOB_POINT_CODE => p_record.FOB_POINT_CODE) = 1 then
4318: RETURN ONT_FOB_Def_Util.Get_Attr_Val_Varchar2
4319: (p_foreign_attr_code,ONT_FOB_Def_Util.g_cached_record);
4320: END IF;
4321:
4322: ELSIF (p_foreign_database_object_name = 'OE_AK_FREIGHT_TERMS_V') THEN
4323: IF NVL(p_record.FREIGHT_TERMS_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
4867: ELSIF (p_foreign_database_object_name = 'OE_AK_FOB_POINT_V') THEN
4868: IF NVL(p_record.FOB_POINT_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
4869: RETURN NULL;
4870: END IF;
4871: IF ONT_FOB_Def_Util.Sync_FOB_Cache
4872: (p_FOB_POINT_CODE => p_record.FOB_POINT_CODE) = 1 then
4873: RETURN ONT_FOB_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_FOB_Def_Util.g_cached_record);
4874: END IF;
4875:
4869: RETURN NULL;
4870: END IF;
4871: IF ONT_FOB_Def_Util.Sync_FOB_Cache
4872: (p_FOB_POINT_CODE => p_record.FOB_POINT_CODE) = 1 then
4873: RETURN ONT_FOB_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_FOB_Def_Util.g_cached_record);
4874: END IF;
4875:
4876: ELSIF (p_foreign_database_object_name = 'OE_AK_FREIGHT_TERMS_V') THEN
4877: IF NVL(p_record.FREIGHT_TERMS_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN