[Home] [Help]
4030: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_FROM_ORGS_V') THEN
4031: IF NVL(p_record.SHIP_FROM_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
4032: RETURN NULL;
4033: END IF;
4034: IF ONT_SHIP_FROM_ORG_Def_Util.Sync_SHIP_FROM_ORG_Cache
4035: (p_ORGANIZATION_ID => p_record.SHIP_FROM_ORG_ID) = 1 then
4036: RETURN ONT_SHIP_FROM_ORG_Def_Util.Get_Attr_Val_Varchar2
4037: (p_foreign_attr_code,ONT_SHIP_FROM_ORG_Def_Util.g_cached_record);
4038: END IF;
4032: RETURN NULL;
4033: END IF;
4034: IF ONT_SHIP_FROM_ORG_Def_Util.Sync_SHIP_FROM_ORG_Cache
4035: (p_ORGANIZATION_ID => p_record.SHIP_FROM_ORG_ID) = 1 then
4036: RETURN ONT_SHIP_FROM_ORG_Def_Util.Get_Attr_Val_Varchar2
4037: (p_foreign_attr_code,ONT_SHIP_FROM_ORG_Def_Util.g_cached_record);
4038: END IF;
4039:
4040: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_SETS_V') THEN
4033: END IF;
4034: IF ONT_SHIP_FROM_ORG_Def_Util.Sync_SHIP_FROM_ORG_Cache
4035: (p_ORGANIZATION_ID => p_record.SHIP_FROM_ORG_ID) = 1 then
4036: RETURN ONT_SHIP_FROM_ORG_Def_Util.Get_Attr_Val_Varchar2
4037: (p_foreign_attr_code,ONT_SHIP_FROM_ORG_Def_Util.g_cached_record);
4038: END IF;
4039:
4040: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_SETS_V') THEN
4041: IF NVL(p_record.SHIP_SET_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
4605: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_FROM_ORGS_V') THEN
4606: IF NVL(p_record.SHIP_FROM_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
4607: RETURN NULL;
4608: END IF;
4609: IF ONT_SHIP_FROM_ORG_Def_Util.Sync_SHIP_FROM_ORG_Cache
4610: (p_ORGANIZATION_ID => p_record.SHIP_FROM_ORG_ID) = 1 then
4611: RETURN ONT_SHIP_FROM_ORG_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SHIP_FROM_ORG_Def_Util.g_cached_record);
4612: END IF;
4613:
4607: RETURN NULL;
4608: END IF;
4609: IF ONT_SHIP_FROM_ORG_Def_Util.Sync_SHIP_FROM_ORG_Cache
4610: (p_ORGANIZATION_ID => p_record.SHIP_FROM_ORG_ID) = 1 then
4611: RETURN ONT_SHIP_FROM_ORG_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SHIP_FROM_ORG_Def_Util.g_cached_record);
4612: END IF;
4613:
4614: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_SETS_V') THEN
4615: IF NVL(p_record.SHIP_SET_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN