2424: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_DATE_TYPE_V') THEN
2425: IF NVL(p_record.ORDER_DATE_TYPE_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2426: RETURN NULL;
2427: END IF;
2428: IF ONT_ORD_DATE_TYPE_Def_Util.Sync_ORD_DATE_TYPE_Cache
2429: (p_ORDER_DATE_TYPE_CODE => p_record.ORDER_DATE_TYPE_CODE) = 1 then
2430: RETURN ONT_ORD_DATE_TYPE_Def_Util.Get_Attr_Val_Varchar2
2431: (p_foreign_attr_code,ONT_ORD_DATE_TYPE_Def_Util.g_cached_record);
2432: END IF;
2426: RETURN NULL;
2427: END IF;
2428: IF ONT_ORD_DATE_TYPE_Def_Util.Sync_ORD_DATE_TYPE_Cache
2429: (p_ORDER_DATE_TYPE_CODE => p_record.ORDER_DATE_TYPE_CODE) = 1 then
2430: RETURN ONT_ORD_DATE_TYPE_Def_Util.Get_Attr_Val_Varchar2
2431: (p_foreign_attr_code,ONT_ORD_DATE_TYPE_Def_Util.g_cached_record);
2432: END IF;
2433:
2434: ELSIF (p_foreign_database_object_name = 'OE_AK_DEFAULT_FULFILMENT_SET_V') THEN
2427: END IF;
2428: IF ONT_ORD_DATE_TYPE_Def_Util.Sync_ORD_DATE_TYPE_Cache
2429: (p_ORDER_DATE_TYPE_CODE => p_record.ORDER_DATE_TYPE_CODE) = 1 then
2430: RETURN ONT_ORD_DATE_TYPE_Def_Util.Get_Attr_Val_Varchar2
2431: (p_foreign_attr_code,ONT_ORD_DATE_TYPE_Def_Util.g_cached_record);
2432: END IF;
2433:
2434: ELSIF (p_foreign_database_object_name = 'OE_AK_DEFAULT_FULFILMENT_SET_V') THEN
2435: IF NVL(p_record.DEFAULT_FULFILLMENT_SET,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2956: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_DATE_TYPE_V') THEN
2957: IF NVL(p_record.ORDER_DATE_TYPE_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2958: RETURN NULL;
2959: END IF;
2960: IF ONT_ORD_DATE_TYPE_Def_Util.Sync_ORD_DATE_TYPE_Cache
2961: (p_ORDER_DATE_TYPE_CODE => p_record.ORDER_DATE_TYPE_CODE) = 1 then
2962: RETURN ONT_ORD_DATE_TYPE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_ORD_DATE_TYPE_Def_Util.g_cached_record);
2963: END IF;
2964:
2958: RETURN NULL;
2959: END IF;
2960: IF ONT_ORD_DATE_TYPE_Def_Util.Sync_ORD_DATE_TYPE_Cache
2961: (p_ORDER_DATE_TYPE_CODE => p_record.ORDER_DATE_TYPE_CODE) = 1 then
2962: RETURN ONT_ORD_DATE_TYPE_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_ORD_DATE_TYPE_Def_Util.g_cached_record);
2963: END IF;
2964:
2965: ELSIF (p_foreign_database_object_name = 'OE_AK_DEFAULT_FULFILMENT_SET_V') THEN
2966: IF NVL(p_record.DEFAULT_FULFILLMENT_SET,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN