3917: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_SETS_V') THEN
3918: IF NVL(p_record.SHIP_SET_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
3919: RETURN NULL;
3920: END IF;
3921: IF ONT_SHIP_SET_Def_Util.Sync_SHIP_SET_Cache
3922: (p_SET_ID => p_record.SHIP_SET_ID) = 1 then
3923: RETURN ONT_SHIP_SET_Def_Util.Get_Attr_Val_Varchar2
3924: (p_foreign_attr_code,ONT_SHIP_SET_Def_Util.g_cached_record);
3925: END IF;
3919: RETURN NULL;
3920: END IF;
3921: IF ONT_SHIP_SET_Def_Util.Sync_SHIP_SET_Cache
3922: (p_SET_ID => p_record.SHIP_SET_ID) = 1 then
3923: RETURN ONT_SHIP_SET_Def_Util.Get_Attr_Val_Varchar2
3924: (p_foreign_attr_code,ONT_SHIP_SET_Def_Util.g_cached_record);
3925: END IF;
3926:
3927: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_TOL_ABOVE_V') THEN
3920: END IF;
3921: IF ONT_SHIP_SET_Def_Util.Sync_SHIP_SET_Cache
3922: (p_SET_ID => p_record.SHIP_SET_ID) = 1 then
3923: RETURN ONT_SHIP_SET_Def_Util.Get_Attr_Val_Varchar2
3924: (p_foreign_attr_code,ONT_SHIP_SET_Def_Util.g_cached_record);
3925: END IF;
3926:
3927: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_TOL_ABOVE_V') THEN
3928: IF NVL(p_record.SHIP_TOLERANCE_ABOVE,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
4506: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_SETS_V') THEN
4507: IF NVL(p_record.SHIP_SET_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
4508: RETURN NULL;
4509: END IF;
4510: IF ONT_SHIP_SET_Def_Util.Sync_SHIP_SET_Cache
4511: (p_SET_ID => p_record.SHIP_SET_ID) = 1 then
4512: RETURN ONT_SHIP_SET_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SHIP_SET_Def_Util.g_cached_record);
4513: END IF;
4514:
4508: RETURN NULL;
4509: END IF;
4510: IF ONT_SHIP_SET_Def_Util.Sync_SHIP_SET_Cache
4511: (p_SET_ID => p_record.SHIP_SET_ID) = 1 then
4512: RETURN ONT_SHIP_SET_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SHIP_SET_Def_Util.g_cached_record);
4513: END IF;
4514:
4515: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_TOL_ABOVE_V') THEN
4516: IF NVL(p_record.SHIP_TOLERANCE_ABOVE,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN