2003: ELSIF (p_foreign_database_object_name = 'OE_AK_LAT_SCH_LIMIT_V') THEN
2004: IF NVL(p_record.LATEST_SCHEDULE_LIMIT,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2005: RETURN NULL;
2006: END IF;
2007: IF ONT_LAT_SCH_LIMIT_Def_Util.Sync_LAT_SCH_LIMIT_Cache
2008: (p_LATEST_SCHEDULE_LIMIT => p_record.LATEST_SCHEDULE_LIMIT) = 1 then
2009: RETURN ONT_LAT_SCH_LIMIT_Def_Util.Get_Attr_Val_Varchar2
2010: (p_foreign_attr_code,ONT_LAT_SCH_LIMIT_Def_Util.g_cached_record);
2011: END IF;
2005: RETURN NULL;
2006: END IF;
2007: IF ONT_LAT_SCH_LIMIT_Def_Util.Sync_LAT_SCH_LIMIT_Cache
2008: (p_LATEST_SCHEDULE_LIMIT => p_record.LATEST_SCHEDULE_LIMIT) = 1 then
2009: RETURN ONT_LAT_SCH_LIMIT_Def_Util.Get_Attr_Val_Varchar2
2010: (p_foreign_attr_code,ONT_LAT_SCH_LIMIT_Def_Util.g_cached_record);
2011: END IF;
2012:
2013: ELSIF (p_foreign_database_object_name = 'OE_AK_EAR_SCH_LIMIT_V') THEN
2006: END IF;
2007: IF ONT_LAT_SCH_LIMIT_Def_Util.Sync_LAT_SCH_LIMIT_Cache
2008: (p_LATEST_SCHEDULE_LIMIT => p_record.LATEST_SCHEDULE_LIMIT) = 1 then
2009: RETURN ONT_LAT_SCH_LIMIT_Def_Util.Get_Attr_Val_Varchar2
2010: (p_foreign_attr_code,ONT_LAT_SCH_LIMIT_Def_Util.g_cached_record);
2011: END IF;
2012:
2013: ELSIF (p_foreign_database_object_name = 'OE_AK_EAR_SCH_LIMIT_V') THEN
2014: IF NVL(p_record.EARLIEST_SCHEDULE_LIMIT,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2576: ELSIF (p_foreign_database_object_name = 'OE_AK_LAT_SCH_LIMIT_V') THEN
2577: IF NVL(p_record.LATEST_SCHEDULE_LIMIT,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2578: RETURN NULL;
2579: END IF;
2580: IF ONT_LAT_SCH_LIMIT_Def_Util.Sync_LAT_SCH_LIMIT_Cache
2581: (p_LATEST_SCHEDULE_LIMIT => p_record.LATEST_SCHEDULE_LIMIT) = 1 then
2582: RETURN ONT_LAT_SCH_LIMIT_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_LAT_SCH_LIMIT_Def_Util.g_cached_record);
2583: END IF;
2584:
2578: RETURN NULL;
2579: END IF;
2580: IF ONT_LAT_SCH_LIMIT_Def_Util.Sync_LAT_SCH_LIMIT_Cache
2581: (p_LATEST_SCHEDULE_LIMIT => p_record.LATEST_SCHEDULE_LIMIT) = 1 then
2582: RETURN ONT_LAT_SCH_LIMIT_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_LAT_SCH_LIMIT_Def_Util.g_cached_record);
2583: END IF;
2584:
2585: ELSIF (p_foreign_database_object_name = 'OE_AK_EAR_SCH_LIMIT_V') THEN
2586: IF NVL(p_record.EARLIEST_SCHEDULE_LIMIT,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN