[Home] [Help]
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
2346: RETURN NULL;
2347: END IF;
2348: IF ONT_SHIP_FROM_ORG_Def_Util.Sync_SHIP_FROM_ORG_Cache
2349: (p_ORGANIZATION_ID => p_record.SHIP_FROM_ORG_ID) = 1 then
2350: RETURN ONT_SHIP_FROM_ORG_Def_Util.Get_Attr_Val_Varchar2
2351: (p_foreign_attr_code,ONT_SHIP_FROM_ORG_Def_Util.g_cached_record);
2352: END IF;
2346: RETURN NULL;
2347: END IF;
2348: IF ONT_SHIP_FROM_ORG_Def_Util.Sync_SHIP_FROM_ORG_Cache
2349: (p_ORGANIZATION_ID => p_record.SHIP_FROM_ORG_ID) = 1 then
2350: RETURN ONT_SHIP_FROM_ORG_Def_Util.Get_Attr_Val_Varchar2
2351: (p_foreign_attr_code,ONT_SHIP_FROM_ORG_Def_Util.g_cached_record);
2352: END IF;
2353:
2354: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_PARTIAL_V') THEN
2347: END IF;
2348: IF ONT_SHIP_FROM_ORG_Def_Util.Sync_SHIP_FROM_ORG_Cache
2349: (p_ORGANIZATION_ID => p_record.SHIP_FROM_ORG_ID) = 1 then
2350: RETURN ONT_SHIP_FROM_ORG_Def_Util.Get_Attr_Val_Varchar2
2351: (p_foreign_attr_code,ONT_SHIP_FROM_ORG_Def_Util.g_cached_record);
2352: END IF;
2353:
2354: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_PARTIAL_V') THEN
2355: IF NVL(p_record.PARTIAL_SHIPMENTS_ALLOWED,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
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
2886: RETURN NULL;
2887: END IF;
2888: IF ONT_SHIP_FROM_ORG_Def_Util.Sync_SHIP_FROM_ORG_Cache
2889: (p_ORGANIZATION_ID => p_record.SHIP_FROM_ORG_ID) = 1 then
2890: RETURN ONT_SHIP_FROM_ORG_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SHIP_FROM_ORG_Def_Util.g_cached_record);
2891: END IF;
2892:
2886: RETURN NULL;
2887: END IF;
2888: IF ONT_SHIP_FROM_ORG_Def_Util.Sync_SHIP_FROM_ORG_Cache
2889: (p_ORGANIZATION_ID => p_record.SHIP_FROM_ORG_ID) = 1 then
2890: RETURN ONT_SHIP_FROM_ORG_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SHIP_FROM_ORG_Def_Util.g_cached_record);
2891: END IF;
2892:
2893: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_PARTIAL_V') THEN
2894: IF NVL(p_record.PARTIAL_SHIPMENTS_ALLOWED,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN