2324: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_PRIORITIES_V') THEN
2325: IF NVL(p_record.SHIPMENT_PRIORITY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2326: RETURN NULL;
2327: END IF;
2328: IF ONT_SHIP_PR_Def_Util.Sync_SHIP_PR_Cache
2329: (p_SHIPMENT_PRIORITY_CODE => p_record.SHIPMENT_PRIORITY_CODE) = 1 then
2330: RETURN ONT_SHIP_PR_Def_Util.Get_Attr_Val_Varchar2
2331: (p_foreign_attr_code,ONT_SHIP_PR_Def_Util.g_cached_record);
2332: END IF;
2326: RETURN NULL;
2327: END IF;
2328: IF ONT_SHIP_PR_Def_Util.Sync_SHIP_PR_Cache
2329: (p_SHIPMENT_PRIORITY_CODE => p_record.SHIPMENT_PRIORITY_CODE) = 1 then
2330: RETURN ONT_SHIP_PR_Def_Util.Get_Attr_Val_Varchar2
2331: (p_foreign_attr_code,ONT_SHIP_PR_Def_Util.g_cached_record);
2332: END IF;
2333:
2334: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIPPING_METHOD_V') THEN
2327: END IF;
2328: IF ONT_SHIP_PR_Def_Util.Sync_SHIP_PR_Cache
2329: (p_SHIPMENT_PRIORITY_CODE => p_record.SHIPMENT_PRIORITY_CODE) = 1 then
2330: RETURN ONT_SHIP_PR_Def_Util.Get_Attr_Val_Varchar2
2331: (p_foreign_attr_code,ONT_SHIP_PR_Def_Util.g_cached_record);
2332: END IF;
2333:
2334: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIPPING_METHOD_V') THEN
2335: IF NVL(p_record.SHIPPING_METHOD_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2866: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIP_PRIORITIES_V') THEN
2867: IF NVL(p_record.SHIPMENT_PRIORITY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2868: RETURN NULL;
2869: END IF;
2870: IF ONT_SHIP_PR_Def_Util.Sync_SHIP_PR_Cache
2871: (p_SHIPMENT_PRIORITY_CODE => p_record.SHIPMENT_PRIORITY_CODE) = 1 then
2872: RETURN ONT_SHIP_PR_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SHIP_PR_Def_Util.g_cached_record);
2873: END IF;
2874:
2868: RETURN NULL;
2869: END IF;
2870: IF ONT_SHIP_PR_Def_Util.Sync_SHIP_PR_Cache
2871: (p_SHIPMENT_PRIORITY_CODE => p_record.SHIPMENT_PRIORITY_CODE) = 1 then
2872: RETURN ONT_SHIP_PR_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SHIP_PR_Def_Util.g_cached_record);
2873: END IF;
2874:
2875: ELSIF (p_foreign_database_object_name = 'OE_AK_SHIPPING_METHOD_V') THEN
2876: IF NVL(p_record.SHIPPING_METHOD_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN