2384: ELSIF (p_foreign_database_object_name = 'OE_AK_BLANKET_HEADERS_V') THEN
2385: IF NVL(p_record.BLANKET_NUMBER,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2386: RETURN NULL;
2387: END IF;
2388: IF ONT_BLANKET_HEADER_Def_Util.Sync_BLANKET_HEADER_Cache
2389: (p_ORDER_NUMBER => p_record.BLANKET_NUMBER) = 1 then
2390: RETURN ONT_BLANKET_HEADER_Def_Util.Get_Attr_Val_Varchar2
2391: (p_foreign_attr_code,ONT_BLANKET_HEADER_Def_Util.g_cached_record);
2392: END IF;
2386: RETURN NULL;
2387: END IF;
2388: IF ONT_BLANKET_HEADER_Def_Util.Sync_BLANKET_HEADER_Cache
2389: (p_ORDER_NUMBER => p_record.BLANKET_NUMBER) = 1 then
2390: RETURN ONT_BLANKET_HEADER_Def_Util.Get_Attr_Val_Varchar2
2391: (p_foreign_attr_code,ONT_BLANKET_HEADER_Def_Util.g_cached_record);
2392: END IF;
2393:
2394: ELSIF (p_foreign_database_object_name = 'OE_AK_LAT_SCH_LIMIT_V') THEN
2387: END IF;
2388: IF ONT_BLANKET_HEADER_Def_Util.Sync_BLANKET_HEADER_Cache
2389: (p_ORDER_NUMBER => p_record.BLANKET_NUMBER) = 1 then
2390: RETURN ONT_BLANKET_HEADER_Def_Util.Get_Attr_Val_Varchar2
2391: (p_foreign_attr_code,ONT_BLANKET_HEADER_Def_Util.g_cached_record);
2392: END IF;
2393:
2394: ELSIF (p_foreign_database_object_name = 'OE_AK_LAT_SCH_LIMIT_V') THEN
2395: IF NVL(p_record.LATEST_SCHEDULE_LIMIT,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2920: ELSIF (p_foreign_database_object_name = 'OE_AK_BLANKET_HEADERS_V') THEN
2921: IF NVL(p_record.BLANKET_NUMBER,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2922: RETURN NULL;
2923: END IF;
2924: IF ONT_BLANKET_HEADER_Def_Util.Sync_BLANKET_HEADER_Cache
2925: (p_ORDER_NUMBER => p_record.BLANKET_NUMBER) = 1 then
2926: RETURN ONT_BLANKET_HEADER_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_BLANKET_HEADER_Def_Util.g_cached_record);
2927: END IF;
2928:
2922: RETURN NULL;
2923: END IF;
2924: IF ONT_BLANKET_HEADER_Def_Util.Sync_BLANKET_HEADER_Cache
2925: (p_ORDER_NUMBER => p_record.BLANKET_NUMBER) = 1 then
2926: RETURN ONT_BLANKET_HEADER_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_BLANKET_HEADER_Def_Util.g_cached_record);
2927: END IF;
2928:
2929: ELSIF (p_foreign_database_object_name = 'OE_AK_LAT_SCH_LIMIT_V') THEN
2930: IF NVL(p_record.LATEST_SCHEDULE_LIMIT,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN