3887: ELSIF (p_foreign_database_object_name = 'OE_AK_ARRIVAL_SETS_V') THEN
3888: IF NVL(p_record.ARRIVAL_SET_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
3889: RETURN NULL;
3890: END IF;
3891: IF ONT_ARRIVAL_SET_Def_Util.Sync_ARRIVAL_SET_Cache
3892: (p_SET_ID => p_record.ARRIVAL_SET_ID) = 1 then
3893: RETURN ONT_ARRIVAL_SET_Def_Util.Get_Attr_Val_Varchar2
3894: (p_foreign_attr_code,ONT_ARRIVAL_SET_Def_Util.g_cached_record);
3895: END IF;
3889: RETURN NULL;
3890: END IF;
3891: IF ONT_ARRIVAL_SET_Def_Util.Sync_ARRIVAL_SET_Cache
3892: (p_SET_ID => p_record.ARRIVAL_SET_ID) = 1 then
3893: RETURN ONT_ARRIVAL_SET_Def_Util.Get_Attr_Val_Varchar2
3894: (p_foreign_attr_code,ONT_ARRIVAL_SET_Def_Util.g_cached_record);
3895: END IF;
3896:
3897: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_PRIORITIES_V') THEN
3890: END IF;
3891: IF ONT_ARRIVAL_SET_Def_Util.Sync_ARRIVAL_SET_Cache
3892: (p_SET_ID => p_record.ARRIVAL_SET_ID) = 1 then
3893: RETURN ONT_ARRIVAL_SET_Def_Util.Get_Attr_Val_Varchar2
3894: (p_foreign_attr_code,ONT_ARRIVAL_SET_Def_Util.g_cached_record);
3895: END IF;
3896:
3897: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_PRIORITIES_V') THEN
3898: IF NVL(p_record.SHIPMENT_PRIORITY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
4479: ELSIF (p_foreign_database_object_name = 'OE_AK_ARRIVAL_SETS_V') THEN
4480: IF NVL(p_record.ARRIVAL_SET_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
4481: RETURN NULL;
4482: END IF;
4483: IF ONT_ARRIVAL_SET_Def_Util.Sync_ARRIVAL_SET_Cache
4484: (p_SET_ID => p_record.ARRIVAL_SET_ID) = 1 then
4485: RETURN ONT_ARRIVAL_SET_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_ARRIVAL_SET_Def_Util.g_cached_record);
4486: END IF;
4487:
4481: RETURN NULL;
4482: END IF;
4483: IF ONT_ARRIVAL_SET_Def_Util.Sync_ARRIVAL_SET_Cache
4484: (p_SET_ID => p_record.ARRIVAL_SET_ID) = 1 then
4485: RETURN ONT_ARRIVAL_SET_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_ARRIVAL_SET_Def_Util.g_cached_record);
4486: END IF;
4487:
4488: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_PRIORITIES_V') THEN
4489: IF NVL(p_record.SHIPMENT_PRIORITY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN