2334: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIPPING_METHOD_V') THEN
2335: IF NVL(p_record.SHIPPING_METHOD_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2336: RETURN NULL;
2337: END IF;
2338: IF ONT_SHIP_METHOD_Def_Util.Sync_SHIP_METHOD_Cache
2339: (p_SHIPPING_METHOD_CODE => p_record.SHIPPING_METHOD_CODE) = 1 then
2340: RETURN ONT_SHIP_METHOD_Def_Util.Get_Attr_Val_Varchar2
2341: (p_foreign_attr_code,ONT_SHIP_METHOD_Def_Util.g_cached_record);
2342: END IF;
2336: RETURN NULL;
2337: END IF;
2338: IF ONT_SHIP_METHOD_Def_Util.Sync_SHIP_METHOD_Cache
2339: (p_SHIPPING_METHOD_CODE => p_record.SHIPPING_METHOD_CODE) = 1 then
2340: RETURN ONT_SHIP_METHOD_Def_Util.Get_Attr_Val_Varchar2
2341: (p_foreign_attr_code,ONT_SHIP_METHOD_Def_Util.g_cached_record);
2342: END IF;
2343:
2344: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_FROM_ORGS_V') THEN
2337: END IF;
2338: IF ONT_SHIP_METHOD_Def_Util.Sync_SHIP_METHOD_Cache
2339: (p_SHIPPING_METHOD_CODE => p_record.SHIPPING_METHOD_CODE) = 1 then
2340: RETURN ONT_SHIP_METHOD_Def_Util.Get_Attr_Val_Varchar2
2341: (p_foreign_attr_code,ONT_SHIP_METHOD_Def_Util.g_cached_record);
2342: END IF;
2343:
2344: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_FROM_ORGS_V') THEN
2345: IF NVL(p_record.SHIP_FROM_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2875: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIPPING_METHOD_V') THEN
2876: IF NVL(p_record.SHIPPING_METHOD_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2877: RETURN NULL;
2878: END IF;
2879: IF ONT_SHIP_METHOD_Def_Util.Sync_SHIP_METHOD_Cache
2880: (p_SHIPPING_METHOD_CODE => p_record.SHIPPING_METHOD_CODE) = 1 then
2881: RETURN ONT_SHIP_METHOD_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SHIP_METHOD_Def_Util.g_cached_record);
2882: END IF;
2883:
2877: RETURN NULL;
2878: END IF;
2879: IF ONT_SHIP_METHOD_Def_Util.Sync_SHIP_METHOD_Cache
2880: (p_SHIPPING_METHOD_CODE => p_record.SHIPPING_METHOD_CODE) = 1 then
2881: RETURN ONT_SHIP_METHOD_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SHIP_METHOD_Def_Util.g_cached_record);
2882: END IF;
2883:
2884: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_FROM_ORGS_V') THEN
2885: IF NVL(p_record.SHIP_FROM_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN